Excel Schedule with Daily Availability and Process Length

Hi there,

I need to make a schedule in Excel and I would really appreciate your help. It is best if you check out the attachment - so at the top it has the days of the week (Mon-Fri) and above the day it has how many hours availability there is for workers to work. Down the left hand side it has the different jobs and how many hours it will take to complete the job. At the moment I have filled in the white space the way I want the schedule to work so that it checks how many hours are required for the project and compares that to the availability of that day. However I want to automate this with a formula as my actual schedule has like 150 projects. I am finding it difficult as the formula needs to be aware of the cells above it and aware of cells to the left of it. So I need 1 formula that I can put in that white space which I can copy and paste from cell d4 down to G10. At the moment I can get it going with different formulas in the different cells but it means I can't copy and paste the formula.

I hope this makes sense. Thank you!