Good morning all,
I was hoping you could help me with something I am trying to achieve. Forgive me if I fail to explain concisely.
Capture.PNG
The above image shows a timetable I am trying to create for a production environment.
The "Part #", "WO #", and "WO QTY" fields are manually entered into this sheet. The other cells in the rows are all calculated automatically using a range of different formulae and calculations/functions.
The figure in the "Run Time Board/hour" "Target" field is automatically populated using a VLOOKUP from another worksheet. The information used is as below:
Capture2.PNG
This target is then pulled through from the information above.
However, as this is a time sheet/efficiency measure for a production environment, and as specified in the first imaged - the quantity of boards we are going to produce is more than 947. 1500 to be exact (taken from "WO QTY") field.
Is excel smart enough to be able to work when it should stop displaying figures on an hour by hour basis?
For example:
We are producing 1500 x SA1K0310
07:00 - 08:00 - The target output will be 947
08:00 - 09:00 - The target output should be 553 (not 947)
Is there a formula I can use for this?
Currently, the formula in the "Run Time Board/hour" "Target" field looks like this: "=IFERROR(VLOOKUP(D10,'SMT Timings'!A:F,6,FALSE),"")"
If I could call on the wisdom of the people on here to help me then I would be most appreciative.
Many thanks in advance.
Bookmarks