I think a little more detail is required before offering any suggestions.

"Martha" wrote:

I need to formulate a spreadsheet to track allowances and taken