A Newbie "How To" Question...

[DarcyIII]

Hi All,

Brand new here and hoping you can help ;o)

I have a simple weekly budgets spreadsheet that also tracks the actual sales values. What's the best way to recalculate the remaining budgets as the actuals come in? Basically, if the cummulative weekly actuals vs budgets are negative, take the shortfall and distribute it across the remaining weeks. I don't know if there is a technical name for this - any help would be awesome ;o)

Thanks
D

 

[steve the fish]

Essentially the calculation is (Budget - Actual) / Remaining Weeks. How you do that depends on the setup of your sheet.