Hi -

I'm looking at your spreadsheet, and this is more of a question of what numbers are you trying to produce, rather than an excel question. Can you explain what "3rd Qty Allocation" is? Also, the Spending Authority is 768,512 in Cell C6. I noticed in Cell Q6 we have the same number, which is the New Spending minus 3rd Qty Allocation plus the monthly spend for April, May, June. Is that on purpose? Like, are you trying to tie out your spending for those three months with the A,M, J allocations?

Finally, your A,M,J percentages in Cells N6, O6, and P6 I assume are the three entries of $74,300 but I don't know what you're dividing them by to get your percentage. Since they are even 1/3's of the total, the April column says spending % for April should be 58%? You're never going to be at 58% if you only allocate 33% of the money in April. Can you explain what these entries are?

Sorry I'm not much help.