Work load forecasting

[Stanford]

I have 2 queries.  They are linked together by job name.  One has estimated hours required per job.  The other contains schedule as to when job is to start and finish.  Currently I am able to forecast hours for each job by end date month.  Issue is that the job could take longer than month, but it puts all hours required in completed month.  This shows end month over inflated and previous month under capacity.  I would like to break down by week.  Example:  Job requires 120 hours and will finish on week 40.  I want to be able to show 40 hours on week 38, 40 hours on week 39, and 40 hours on week 40.

[Stanford]

[v-easonf-msft]

Hi , @Stanford 

The information you have provided is not making the problem clear to me. 

Can you show me your expected results in excel and explain the calculation logic showing 38 weeks 40 hours, 39 weeks 40 hours and 40 weeks 40 hours？

Best Regards,
Community Support Team _ Eason

[Stanford]

Thank you for response and sorry I am not very clear.  I cannot seem to figure out how to attach an excel, but did figure out how to upload a picture.