Retired and have new part time position...need to break down petty cash for weekly cash payout. ....example, 80 folks get petty cash...anywhere from 100 to 1000 to each...need to determine dollar denominations to give to runner to get exact denominations from bank..... example...

employee....total....100's...20's...10's...5.....1's

John Dow...$350.....3........2.........1.....0.....0
Mary Doe....$128....1........1.........0.....1.....3
------------------------------------------------------
total....100's...20's...10's...5.....1's
Petty CASH
TOTALS......$478.....4.......3..........1.....1....3

I could have more than $15,000 to hand out weekly and I need exact denominations to stuff into envelopes at the end of the week with none left over at the office, so it needs to be easy for the runner to get exact denominations and follow the list on how many of each denominations go into envelopes.

Whew...hope that explains it....need some sort of spreadsheet formula. The previous young man used one but left with the spreadsheet.

Any help would be greatly appreciated.

Thank you so much!

Jose