Hi -

I'm building the attached a spreadsheet (that it seems I can't share yet...). In Row 15, the total amount spent for that week is to be entered. Each week is its own column. Row 16 calculates over / under spend versus budget for each week. Ultimate goal is for the over/under amount from that week to be spread evenly across remaining weeks, and combined with the budget for each individual week so that the quarter ends on the planned budget.

I've set up dummy rows to test approaches, and the math is right for each week (sums to the correct total across weeks). But when I add the weekly over/under to the planned budget in row 14 for each week, I end up over. I've been through this so many times I'm cross eyed. Open to any suggestions on how to make this work. Thanks for looking!!