capacity planning: 5-day rolling basis

I am trying to create a spreadsheet that tracks daily capacity on a 5-day rolling basis (please see attached). I need to be able to manually change CAPACITY and REPORT values on an nightly basis and have the spreadsheet automatcially do the calculations throughout the remainder of the week.

For example; if the value entered into C8 exceeds the value entered into C6 I need the spreadsheet to automatically subtract the difference from the value entered into E6. I need this functionality to roll throughout all five days of the week (hope that makes sense).

As mentioned the goal is to create greater visibility to daily CAPACITY based on report totals for each day. I am not “new” to Excel but this is by far the most advanced table/spreadsheet I have tried to create. I’m not really sure if it can even be done so any assistance would be greatly appreciated.

Thanks for the time!

i'm not folowing your ideas, can you demonstrate this in a spread sheet ?

Thanks Charlie. I’ve attached an updated spreadsheet which will hopefully help to clarify what I’m trying to accomplish. To put it in words:

My Monday CAPACITY is 30 and my Monday REPORTS is 20. Lets say I assign those 20 reports. My Monday REPORTS is now 0 and I’m left with a Monday CAPACITY of 10. Now I want to assign out the 10 REPORTS for Tuesday. Once those are assigned my Monday CAPACITY becomes 0 and my Tuesday REPORTS also becomes 0.

The goal would is to have the spreadsheet make these calculations based on the values I enter into the CAPACITY and REPORTS row for each day of the week.

Thanks. Will do!