Spreadsheet: 754179d1635985159-production-line-time-management-sample-workshop-schedule
Sheet: Sheet1

Job Type | Stage 1 | Stage 2 | Stage 3 | Stage 4 | Stage 5 |  | stage 1 time | small | medium | large |  | Stage | time |  | Holidays | Date
A | N | N | Y | N | N |  | type 1 | 6 | 8 | 12 |  | Stage 2 | 3 |  | New Years | 2001-01-01 00:00:00
B | N | Y | Y | N | N |  | type 2 | 9 | 11 | 14 |  | Stage 4 | 5 |  | Australia day | 2027-01-01 00:00:00
C | Y | N | Y | N | N |  |  |  |  |  |  | Stage 5 | 2 |  | Good Friday | 2010-04-01 00:00:00
D | Y | Y | Y | Y | N |  | stage 3 time | small | medium | large |  |  |  |  | Easter Monday | 2013-04-01 00:00:00
E | Y | N | N | Y | N |  | type 1 | 2 | 4 | 6 |  | Workers | Float |  | Anzac Day | 2025-04-01 00:00:00
F | Y | N | N | Y | N |  | type 2 | 3 | 6 | 8 |  | 5 | 2 |  | Labour Day | 2004-05-01 00:00:00
G | Y | Y | N | Y | Y |  |  |  |  |  |  |  |  |  | Queen's birthday | 2005-10-01 00:00:00
H | Y | N | Y | N | N |  | work day start | work day end | Break | Total Hours |  |  |  |  | Christmas Eve | 2024-12-01 00:00:00
I | N | Y | Y | N | Y |  | 07:00:00 | 15:00:00 | 00:30:00 |  |  |  |  |  | Christmas day | 2025-12-01 00:00:00
J | Y | Y | Y | Y | Y |  |  |  |  |  |  |  |  |  | boxing day | 2026-12-01 00:00:00
Job | Pri # | Job Type | size | type | status | time | start | end | status2 | start2 | end2 | status3 | time3 | start3 | end3 | status4 | start4 | end4 | status5 | start5 | end5
0042 | 1 | G | large | type 2 | No |  |  |  | Pending |  |  | NA |  |  |  | Pending |  |  | Pending
0107 | 2 | C | medium | type 2 | Pending |  |  |  | NA |  |  | Pending |  |  |  | NA |  |  | NA
0283 | 3 | H | large | type 2 | Pending |  |  |  | NA |  |  | Pending |  |  |  | NA |  |  | NA
0289 | 3 | D | large | type 1 | No |  |  |  | No |  |  | Pending |  |  |  | Pending |  |  | NA
0345 | 3 | F | medium | type 1 | Pending |  |  |  | NA |  |  | NA |  |  |  | Yes |  |  | NA
0671 | 4 | H | small | type 2 | Yes |  |  |  | NA |  |  | Pending |  |  |  | NA |  |  | NA
0932 | 4 | G | medium | type 1 | Pending |  |  |  | Yes |  |  | NA |  |  |  | Yes |  |  | Pending
1328 | 5 | G | large | type 2 | Pending |  |  |  | Pending |  |  | NA |  |  |  | Yes |  |  | Pending
1535 | 6 | A | large | type 1 | NA |  |  |  | NA |  |  | Pending |  |  |  | NA |  |  | NA
1929 | 6 | F | large | type 2 | Pending |  |  |  | NA |  |  | NA |  |  |  | Pending |  |  | NA
2009 | 6 | B | medium | type 2 | NA |  |  |  | No |  |  | Yes |  |  |  | NA |  |  | NA
2205 | 7 | I | medium | type 2 | NA |  |  |  | Yes |  |  | No |  |  |  | NA |  |  | Pending
2225 | 8 | E | small | type 2 | Pending |  |  |  | NA |  |  | NA |  |  |  | No |  |  | NA
2476 | 9 | G | small | type 1 | Pending |  |  |  | Pending |  |  | NA |  |  |  | Pending |  |  | No
2591 | 10 | G | medium | type 2 | No |  |  |  | No |  |  | NA |  |  |  | Yes |  |  | Yes
2641 | 10 | J | small | type 2 | Yes |  |  |  | Yes |  |  | No |  |  |  | Pending |  |  | No
2689 | 11 | B | large | type 2 | NA |  |  |  | Yes |  |  | Yes |  |  |  | NA |  |  | NA
2753 | 11 | H | medium | type 2 | No |  |  |  | NA |  |  | Pending |  |  |  | NA |  |  | NA
2834 | 12 | E | medium | type 1 | No |  |  |  | NA |  |  | NA |  |  |  | No |  |  | NA
2922 | 12 | C | small | type 2 | Yes |  |  |  | NA |  |  | Pending |  |  |  | NA |  |  | NA
2927 | 12 | A | large | type 1 | NA |  |  |  | NA |  |  | No |  |  |  | NA |  |  | NA
2938 | 12 | A | small | type 2 | NA |  |  |  | NA |  |  | Pending |  |  |  | NA |  |  | NA
3005 | 13 | H | large | type 1 | Yes |  |  |  | NA |  |  | No |  |  |  | NA |  |  | NA
3238 | 13 | J | large | type 1 | No |  |  |  | Yes |  |  | No |  |  |  | Pending |  |  | No
3413 | 13 | F | small | type 2 | Pending |  |  |  | NA |  |  | NA |  |  |  | No |  |  | NA
3485 | 14 | H | medium | type 2 | No |  |  |  | NA |  |  | Yes |  |  |  | NA |  |  | NA
3618 | 14 | G | medium | type 2 | No |  |  |  | Yes |  |  | NA |  |  |  | Pending |  |  | Yes
3756 | 14 | G | small | type 1 | No |  |  |  | Yes |  |  | NA |  |  |  | Yes |  |  | Pending
3776 | 14 | D | medium | type 1 | Yes |  |  |  | No |  |  | No |  |  |  | No |  |  | NA
3806 | 15 | B | medium | type 2 | NA |  |  |  | No |  |  | Pending |  |  |  | NA |  |  | NA
4036 | 15 | B | small | type 2 | NA |  |  |  | Pending |  |  | Pending |  |  |  | NA |  |  | NA
4156 | 15 | J | small | type 1 | Yes |  |  |  | No |  |  | No |  |  |  | Pending |  |  | Pending
4434 | 15 | F | large | type 2 | Yes |  |  |  | NA |  |  | NA |  |  |  | Pending |  |  | NA
4589 | 16 | H | medium | type 2 | Yes |  |  |  | NA |  |  | Yes |  |  |  | NA |  |  | NA
4646 | 17 | E | large | type 1 | No |  |  |  | NA |  |  | NA |  |  |  | Pending |  |  | NA
4675 | 17 | G | large | type 2 | No |  |  |  | Yes |  |  | NA |  |  |  | No |  |  | Pending
5073 | 18 | B | large | type 2 | NA |  |  |  | Yes |  |  | No |  |  |  | NA |  |  | NA
5440 | 18 | G | small | type 2 | Pending |  |  |  | No |  |  | NA |  |  |  | Pending |  |  | No
5595 | 18 | B | medium | type 1 | NA |  |  |  | Yes |  |  | Pending |  |  |  | NA |  |  | NA
5597 | 19 | F | medium | type 2 | Pending |  |  |  | NA |  |  | NA |  |  |  | Pending |  |  | NA
5805 | 20 | J | small | type 1 | Pending |  |  |  | Yes |  |  | No |  |  |  | No |  |  | Pending
5817 | 20 | B | large | type 2 | NA |  |  |  | No |  |  | Yes |  |  |  | NA |  |  | NA
6007 | 20 | E | large | type 1 | No |  |  |  | NA |  |  | NA |  |  |  | Pending |  |  | NA
6159 | 20 | D | medium | type 1 | Yes |  |  |  | Pending |  |  | Pending |  |  |  | Pending |  |  | NA
6239 | 20 | A | large | type 1 | NA |  |  |  | NA |  |  | No |  |  |  | NA |  |  | NA
6307 | 20 | I | medium | type 1 | NA |  |  |  | Pending |  |  | No |  |  |  | NA |  |  | Yes
6355 | 21 | J | large | type 2 | Yes |  |  |  | No |  |  | Pending |  |  |  | Yes |  |  | No
6361 | 22 | E | large | type 1 | Pending |  |  |  | NA |  |  | NA |  |  |  | Yes |  |  | NA
6505 | 22 | I | small | type 2 | NA |  |  |  | No |  |  | Yes |  |  |  | NA |  |  | Pending
6661 | 22 | J | small | type 1 | No |  |  |  | Pending |  |  | No |  |  |  | No |  |  | Yes
6908 | 23 | E | large | type 1 | No |  |  |  | NA |  |  | NA |  |  |  | No |  |  | NA
7068 | 23 | A | large | type 1 | NA |  |  |  | NA |  |  | Pending |  |  |  | NA |  |  | NA
7112 | 24 | B | small | type 1 | NA |  |  |  | No |  |  | Pending |  |  |  | NA |  |  | NA
7198 | 25 | G | large | type 1 | Pending |  |  |  | Yes |  |  | NA |  |  |  | No |  |  | Pending
7216 | 25 | I | small | type 1 | NA |  |  |  | Yes |  |  | Yes |  |  |  | NA |  |  | Pending
7418 | 26 | I | medium | type 2 | NA |  |  |  | Pending |  |  | Pending |  |  |  | NA |  |  | Pending
7449 | 26 | H | medium | type 1 | Yes |  |  |  | NA |  |  | Pending |  |  |  | NA |  |  | NA
7796 | 27 | E | small | type 2 | Yes |  |  |  | NA |  |  | NA |  |  |  | No |  |  | NA
7881 | 27 | H | large | type 1 | No |  |  |  | NA |  |  | Pending |  |  |  | NA |  |  | NA
8108 | 27 | D | small | type 1 | Yes |  |  |  | Pending |  |  | No |  |  |  | No |  |  | NA
8223 | 27 | H | medium | type 1 | No |  |  |  | NA |  |  | Yes |  |  |  | NA |  |  | NA
8252 | 28 | G | small | type 2 | Pending |  |  |  | Yes |  |  | NA |  |  |  | Pending |  |  | No
8304 | 29 | I | small | type 2 | NA |  |  |  | Pending |  |  | Pending |  |  |  | NA |  |  | Pending
8385 | 30 | A | large | type 1 | NA |  |  |  | NA |  |  | No |  |  |  | NA |  |  | NA
8464 | 30 | G | small | type 1 | Pending |  |  |  | No |  |  | NA |  |  |  | Pending |  |  | No
8653 |  | E | small | type 2 | No |  |  |  | NA |  |  | NA |  |  |  | Pending |  |  | NA
8734 |  | E | small | type 1 | Yes |  |  |  | NA |  |  | NA |  |  |  | Yes |  |  | NA
8883 |  | J | small | type 2 | No |  |  |  | No |  |  | No |  |  |  | No |  |  | Yes
9060 |  | I | small | type 1 | NA |  |  |  | Yes |  |  | Pending |  |  |  | NA |  |  | Pending
9273 |  | A | large | type 1 | NA |  |  |  | NA |  |  | Yes |  |  |  | NA |  |  | NA
9308 |  | I | medium | type 2 | NA |  |  |  | Yes |  |  | No |  |  |  | NA |  |  | No
9318 |  | J | medium | type 1 | No |  |  |  | No |  |  | Yes |  |  |  | Pending |  |  | No
9408 |  | D | medium | type 2 | Yes |  |  |  | Yes |  |  | Pending |  |  |  | No |  |  | NA
9739 |  | B | medium | type 2 | NA |  |  |  | Pending |  |  | No |  |  |  | NA |  |  | NA