Spreading hours out over weeks

[myrtle67204]

I have employees who only work 1560 hours per year. I want to create a spreadsheet for planning. row 4 will be what hours they actually worked. row 5 they will fill out for future planned hours for projects we know they will have. row 7 I have set up as an IF row. see the example in column M

My problem is I want row 8 to be an average of what they have left available to work per week. for example if its Feb 20 their total hours of planned and actual work is 246 (f6) there are 45 week left in the year 1560 max hour-246 hours already counted for. it means they can average 24.3 hours per week the rest of the year. but we know the week of Feb 24 they have 50 hours planned so I would want that to drop down to the average per week for planning purposes, like a place holder.

The spreadsheet increases per week all the way out to Dec 31 2019.

My head is exploding just thinking about it.

 

[Logit]

.
For future consideration, post a workbook example with existing data sample and a sample of the expected outcome.

Images are too small to interpret ... and the FORUM volunteers do not have the time to re-create a worksheet.

Thanks.