Progressive Data Projection

[MikeLittle]

I use excel to project production across a 12.5 hour shift. The chart is broken down by hours (rows) and columns for projected volume per hour and the actual volume for that hour. I'd like to figure out how to make the projected volume for each hour increase or decrease as the previous hour's volume is input. For example, if they don't get enough completed, the rest of the hours increase by the difference, evenly spread across the rest of the shift.

I feel like i'm not explaining this well enough, but I could send you what I'm working on if there is a place to drop it in here, or I could email it to anyone that want's to give it a go. Thanks in advance.

Mike

 

[RoryA]

Please note that sharing workbooks by email is against board policy as we like to keep everything out in the open. If necessary, you can put a file onto a cloud site like Dropbox or OneDrive and then put a link to it here.

Thanks.

 

[MikeLittle]

https://1drv.ms/x/s!As0EmCu8Pu5gkiIPt4J5qH0xZGRi

I think this will work. Please let me know if this opens the document named "B1 CPH Tracker WK1 REBUILD". Thanks.