Spreadsheet: 268575d1380699336-formula-needed-for-planning-chart-hard-to-explain-in-title-newplan1
Sheet: Sheet1

 |  |  |  |  |  |  | Monday |  |  |  |  |  |  |  | Tuesday |  |  |  |  |  |  |  | Wednesday |  |  |  |  |  |  |  | Thursday |  |  |  |  |  |  |  | Friday |  |  |  |  |  | [NAME]
 | Job Number | Part Number | Qty | Hours | Start | Stop | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38
 | 325 D
1 | 55555 | 1 | 555 | 6 | 0 | 6 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32
2 | 12345 | 2 | 50 | 6.25 | 6 | 12.25 |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25.75
3 | 56984 | 3 | 25 | 10 | 12.25 | 22.25 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15.75
4 | 54321 | 4 | 100 | 2.5 | 22.25 | 24.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13.25
5 | 23456 | 5 | 20 | 10 | 24.75 | 34.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  | 3.25
 | 325 A
 |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  | 2
1 |  |  |  | 10 | 0 | 10 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28
2 |  |  | 0 | 5 | 10 | 15 |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
3 |  |  | 0 | 19 | 15 | 34 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  | 4
4 |  |  | 0 | 2 | 34 | 36 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  | 2
5 |  |  | 0 | 0 | 36 | 36 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  | 4
 | 325 B
1 |  |  | 0 | 15 | 0 | 15 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
2 |  |  | 0 | 4 | 15 | 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
3 |  |  | 0 | 7 | 19 | 26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 12
4 |  |  | 0 | 0 | 26 | 26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
5 |  |  | 0 | 0 | 26 | 26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  | 0
 | 325 C
1 |  |  | 0 | 13 | 0 | 13 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25
2 |  |  | 0 | 12 | 13 | 25 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
3 |  |  | 0 | 0 | 25 | 25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
4 |  |  | 0 | 0 | 25 | 25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
5 |  |  | 0 | 0 | 25 | 25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 0
 | 325 E
1 |  |  | 0 | 15 | 0 | 15 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
2 |  |  | 0 | 0 | 15 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
3 |  |  | 0 | 0 | 15 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
4 |  |  | 0 | 0 | 15 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
5 |  |  | 0 | 0 | 15 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
 | E25 LT1
1 |  |  | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38
2 |  |  | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38
3 |  |  | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38
4 |  |  | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38
5 |  |  | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 40 |  |  |  |  |  |  |  | 40 |  |  |  |  |  |  |  | 40 |  |  |  |  |  |  |  | 40 |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34