Hi all
I am trying to make a production planning spreadhseet with excel and i am almost there. Its a bit hard to explain but ill try my best! On the attached spreadsheet you can see on the left hand side 6 machines that we have. 325 D,A,B,C,E and E25LT1. The Job number, part number qty etc are jst normal, nothing fancy. When you put something in the hours box it automatcially starts filling the week in on that particular machine. All that works great!
On the bottom of the spread sheet you will notice some figures, 0.00,1.00,8.00,21.00 and 34.00. these are the man hours that are left for each remaining day that automaticall deducts as you plan hours in to machines.
Here is my problem..as you can see in this test data i have no man hours remaining on monday and only 1 remaining for tueaday. If i wanted to plan another job no on the E25LT1 (say h hours) i would like it to know this and automatically plan it in the next slot (on the wednesday). Is there a formula to do this? or is it just a bit to complicated for Excel?
thanks for any help
chris
Bookmarks