Spreadsheet: 835324d1688496466-trouble-sorting-a-filtered-index-schedule-sandbox
Sheet: Order Data Sheet

Job # | Subs | Customer | Salesman | PO# | Description | QTY | Date Ordered | Priority | [NAME] | Job Notes | Required Ship Date from PRI | Client Accepted Ship Date from PRI | Expected Completion Date from PRI | Scheduled Ship Date | Shipping Week Number | Steel Resource Factor | Required Start Date Steel | Steel WCCD | Steel Starting Week | Steel Actual Completion Date | Molding Resource Factor | Required Start Date Molding | Molding WCCD | Molding Starting Week | Molding Actual Completion Date | Rubber Resource Factor | Required Start Date Rubber | Rubber WCCD | Rubber Starting Week | Rubber Actual Completion Date | Finishing Resource Factor | Required Start Date Finishing | Finishing WCCD | Finishing Starting Week | Finishing Actual Completion Date | Paint Resource Factor | Required Start Date Paint | Paint WCCD | Paint Starting Week | Paint Actual Completion Date | [NAME] | Required Start Date Hose | [NAME] | [NAME] Week | Hose Actual Completion Date | Bid By | Quote # | Estimated Steel Hrs | Actual Steel Hrs | Estimated Molding Hrs | Actual Molding Hrs | Estimated Rubber Hrs | Actual [NAME] | Estimated Finishing Hrs | Actual Finishing Hrs | Estimated Paint Hrs | Actual Paint Hrs | Estimated [NAME] | Actual [NAME] | Job Category | Job Value | WO Release Date | Days from PO to WO | RTS Date | Actual Ship Date | OTD
9635-2 |  | Customer A | Shawn | 1 | Widget | 60 | 2023-06-06 00:00:00 |  | [NAME] |  | 2023-07-06 00:00:00 | 2023-07-06 00:00:00 | 2023-07-05 00:00:00 | 2023-07-06 00:00:00 |  | 1 |  | x |  |  | 1 |  |  |  | 2023-06-22 00:00:00 | 1 |  | x |  |  | 1 |  | x |  |  | 1 |  | x |  |  | 1 |  | x |  |  | MP | 23-396 | 0 |  | 4 |  | 0 |  | 0 |  | 0 |  | 0 |  | R |  | 2023-06-14 00:00:00 |  | 2023-06-26 00:00:00 | 2023-06-26 00:00:00
9635-1 |  | Customer B | Shawn | 2 | Widget | 800 | 2023-06-06 00:00:00 |  | [NAME] | Mat rec'd 06/12 parts rack, 06/15 | 2023-07-06 00:00:00 | 2023-07-06 00:00:00 | 2023-07-05 00:00:00 | 2023-07-06 00:00:00 |  | 1 |  | x |  |  | 1 |  | x |  |  | 1 |  | x |  |  | 1 |  | x |  |  | 1 |  | x |  |  | 1 |  | x |  |  | MP | 23-396 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | R | 30702 | 2023-06-14 00:00:00 |  | 2023-06-19 00:00:00 | 2023-06-19 00:00:00
9683 |  | Customer C | House | 3 | Widget | 2 | 2023-06-22 00:00:00 |  | Queued |  | 2023-07-07 00:00:00 | 2023-07-07 00:00:00 | 2023-07-07 00:00:00 | 2023-07-07 00:00:00 |  | 1 |  | x |  |  | 1 |  | x |  |  | 1 |  |  |  |  | 1 |  |  |  |  | 1 |  |  |  |  | 1 |  | x |  |  | KM | 23-462 Rev 1 | 0 |  | 0 |  | 6 |  | 6 |  | 4 |  | 0 |  | R | 2890 | 2023-06-30 00:00:00
9369-4 |  | Customer D | [NAME] | 4 | Widget | 1 | 2023-02-13 00:00:00 |  | Production Complete, Waiting on QC |  | 2023-06-20 00:00:00 | 2023-06-20 00:00:00 | 2023-06-07 00:00:00 | 2023-07-07 00:00:00 |  | 1 |  |  |  | 2023-05-04 00:00:00 | 1 |  | x |  |  | 1 |  |  |  | 2023-05-08 00:00:00 | 1 |  |  |  | 2023-05-29 00:00:00 | 1 |  | x |  |  | 1 |  | x |  |  | SS | 23-043 | 1.5 |  | 0 |  | 8 |  | 10 |  | 0 |  | 0 |  | OS |  | 2023-03-15 00:00:00
9369-5 |  | Customer E | [NAME] | 5 | Widget | 1 | 2023-02-13 00:00:00 |  | WIP Finishing |  | 2023-06-20 00:00:00 | 2023-06-20 00:00:00 | 2023-06-07 00:00:00 | 2023-07-07 00:00:00 |  | 1 |  |  |  | 2023-05-05 00:00:00 | 1 |  | x |  |  | 1 |  |  |  | 2023-05-10 00:00:00 | 1 |  |  |  |  | 1 |  | x |  |  | 1 |  | x |  |  | SS | 23-043 | 1.5 |  | 0 |  | 5.25 |  | 10 |  | 0 |  | 0 |  | OS |  | 2023-03-15 00:00:00
9369-6 |  | Customer F | [NAME] | 6 | Widget | 1 | 2023-02-13 00:00:00 |  | Production Complete, Waiting on QC |  | 2023-06-20 00:00:00 | 2023-06-20 00:00:00 | 2023-06-07 00:00:00 | 2023-07-07 00:00:00 |  | 1 |  |  |  | 2023-05-08 00:00:00 | 1 |  | x |  |  | 1 |  |  |  | 2023-05-08 00:00:00 | 2 |  |  |  | 2023-05-29 00:00:00 | 1 |  | x |  |  | 1 |  | x |  |  | SS | 23-043 | 1.5 |  | 0 |  | 8.25 |  | 10 |  | 0 |  | 0 |  | OS |  | 2023-03-15 00:00:00
9369-1 |  | Customer A | [NAME] | 7 | Widget | 1 | 2023-02-13 00:00:00 |  | WIP Finishing |  | 2023-06-20 00:00:00 | 2023-06-20 00:00:00 | 2023-06-10 00:00:00 | 2023-07-07 00:00:00 |  | 1 |  |  |  | 2023-05-02 00:00:00 | 1 |  | x |  |  | 1 |  |  |  | 2023-05-04 00:00:00 | 1 |  |  |  |  | 1 |  | x |  |  | 1 |  | x |  |  | SS | 23-043 | 1.5 |  | 0 |  | 25.5 |  | 27 |  | 0 |  | 0 |  | OS |  | 2023-03-15 00:00:00
9369-13 |  | Customer B | [NAME] | 8 | Widget | 1 | 2023-02-13 00:00:00 |  | Production Complete, Waiting on QC |  | 2023-06-20 00:00:00 | 2023-06-20 00:00:00 | 2023-06-10 00:00:00 | 2023-07-07 00:00:00 |  | 1 |  |  |  | 2023-05-10 00:00:00 | 1 |  | x |  |  | 1 |  |  |  | 2023-05-12 00:00:00 | 1 |  |  |  |  | 1 |  | x |  |  | 1 |  | x |  |  | SS | 23-043 | 1.5 |  | 0 |  | 22.5 |  | 24 |  | 0 |  | 0 |  | OS |  | 2023-03-15 00:00:00
9369-2 |  | Customer C | [NAME] | 9 | Widget | 1 | 2023-02-13 00:00:00 |  | WIP Finishing |  | 2023-06-20 00:00:00 | 2023-06-20 00:00:00 | 2023-06-10 00:00:00 | 2023-07-07 00:00:00 |  | 1 |  |  |  | 2023-05-02 00:00:00 | 1 |  | x |  |  | 1 |  |  |  | 2023-05-04 00:00:00 | 1 |  |  |  |  | 1 |  | x |  |  | 1 |  | x |  |  | SS | 23-043 | 1.5 |  | 0 |  | 11.5 |  | 14 |  | 0 |  | 0 |  | OS |  | 2023-03-15 00:00:00
9369-12 |  | Customer D | [NAME] | 10 | Widget | 1 | 2023-02-13 00:00:00 |  | WIP Finishing |  | 2023-06-20 00:00:00 | 2023-06-20 00:00:00 | 2023-06-10 00:00:00 | 2023-07-07 00:00:00 |  | 1 |  |  |  | 2023-05-12 00:00:00 | 1 |  | x |  |  | 1 |  |  |  |  | 1 |  |  |  |  | 1 |  | x |  |  | 1 |  | x |  |  | SS | 23-043 | 1.5 |  | 0 |  | 10.75 |  | 12 |  | 0 |  | 0 |  | OS |  | 2023-03-15 00:00:00
9369-11 |  | Customer E | [NAME] | 11 | Widget | 1 | 2023-02-13 00:00:00 |  | WIP Finishing |  | 2023-06-20 00:00:00 | 2023-06-20 00:00:00 | 2023-06-10 00:00:00 | 2023-07-07 00:00:00 |  | 1 |  |  |  |  | 1 |  | x |  |  | 1 |  |  |  | 2023-05-15 00:00:00 | 1 |  |  |  |  | 1 |  | x |  |  | 1 |  | x |  |  | SS | 23-043 | 1.5 |  | 0 |  | 7 |  | 10 |  | 0 |  | 0 |  | OS |  | 2023-03-15 00:00:00
9369-14 |  | Customer F | [NAME] | 12 | Widget | 1 | 2023-02-13 00:00:00 |  | Production Complete, Waiting on QC |  | 2023-06-20 00:00:00 | 2023-06-20 00:00:00 | 2023-06-10 00:00:00 | 2023-07-07 00:00:00 |  | 1 |  |  |  | 2023-05-05 00:00:00 | 1 |  | x |  |  | 1 |  |  |  | 2023-05-10 00:00:00 | 1 |  |  |  | 2023-05-24 00:00:00 | 1 |  | x |  |  | 1 |  | x |  |  | SS | 23-043 | 1.5 |  | 0 |  | 6 |  | 10 |  | 0 |  | 0 |  | OS |  | 2023-03-15 00:00:00
9369-3 |  | Customer A | [NAME] | 13 | Widget | 1 | 2023-02-13 00:00:00 |  | Production Complete, Waiting on QC |  | 2023-06-20 00:00:00 | 2023-06-20 00:00:00 | 2023-06-10 00:00:00 | 2023-07-07 00:00:00 |  | 1 |  |  |  | 2023-05-02 00:00:00 | 1 |  | x |  |  | 1 |  |  |  | 2023-05-04 00:00:00 | 1 |  |  |  | 2023-05-29 00:00:00 | 1 |  | x |  |  | 1 |  | x |  |  | SS | 23-043 | 1.5 |  | 0 |  | 5.5 |  | 10 |  | 0 |  | 0 |  | OS |  | 2023-03-15 00:00:00
9369-10 |  | Customer B | [NAME] | 14 | Widget | 1 | 2023-02-13 00:00:00 |  | WIP Finishing |  | 2023-06-20 00:00:00 | 2023-06-20 00:00:00 | 2023-06-10 00:00:00 | 2023-07-07 00:00:00 |  | 1 |  |  |  | 2023-05-10 00:00:00 | 1 |  | x |  |  | 1 |  |  |  | 2023-05-16 00:00:00 | 1 |  |  |  |  | 1 |  | x |  |  | 1 |  | x |  |  | SS | 23-043 | 1.5 |  | 0 |  | 4.25 |  | 7 |  | 0 |  | 0 |  | OS |  | 2023-03-15 00:00:00
9369-8 |  | Customer C | [NAME] | 15 | Widget | 1 | 2023-02-13 00:00:00 |  | WIP Finishing |  | 2023-06-20 00:00:00 | 2023-06-20 00:00:00 | 2023-06-15 00:00:00 | 2023-07-07 00:00:00 |  | 1 |  |  |  | 2023-05-08 00:00:00 | 1 |  | x |  |  | 1 |  |  |  | 2023-05-12 00:00:00 | 1 |  |  |  |  | 1 |  | x |  |  | 1 |  | x |  |  | SS | 23-043 | 1.5 |  | 0 |  | 5.25 |  | 10 |  | 0 |  | 0 |  | OS |  | 2023-03-15 00:00:00
9369-9 |  | Customer D | [NAME] | 16 | Widget | 1 | 2023-02-13 00:00:00 |  | WIP Finishing |  | 2023-06-20 00:00:00 | 2023-06-20 00:00:00 | 2023-06-15 00:00:00 | 2023-07-07 00:00:00 |  | 1 |  |  |  | 2023-05-08 00:00:00 | 1 |  | x |  |  | 1 |  |  |  | 2023-05-16 00:00:00 | 1 |  |  |  |  | 1 |  | x |  |  | 1 |  | x |  |  | SS | 23-043 | 1.5 |  | 0 |  | 5.25 |  | 10 |  | 0 |  | 0 |  | OS |  | 2023-03-15 00:00:00
9369-7 |  | Customer E | [NAME] | 17 | Widget | 1 | 2023-02-13 00:00:00 |  | WIP Finishing |  | 2023-06-20 00:00:00 | 2023-06-20 00:00:00 | 2023-06-15 00:00:00 | 2023-07-07 00:00:00 |  | 1 |  |  |  | 2023-05-08 00:00:00 | 1 |  | x |  |  | 1 |  |  |  | 2023-05-16 00:00:00 | 1 |  |  |  |  | 1 |  | x |  |  | 1 |  | x |  |  | SS | 23-043 | 1.5 |  | 0 |  | 4.25 |  | 7 |  | 0 |  | 0 |  | OS |  | 2023-03-15 00:00:00
9537 |  | Customer F | Shawn | 18 | Widget | 12 | 2023-05-03 00:00:00 |  | Waiting for Material | Buy and Sell | 2023-05-27 00:00:00 | 2023-05-27 00:00:00 | 2023-06-19 00:00:00 | 2023-07-07 00:00:00 |  | 1 |  | x |  |  | 1 |  | x |  |  | 1 |  | x |  |  | 1 |  | x |  |  | 1 |  | x |  |  | 1 |  | x |  |  | KM | 23-051 | 0 |  | 0 |  | 0 |  | 1.5 |  | 0 |  | 0 |  | R | 1380 | 2023-05-04 00:00:00
9561 |  | Customer A | [NAME] | 19 | Widget | 2 | 2023-05-09 00:00:00 |  | Waiting for Material | Buy and [NAME], parts out 5 weeks- late. ETA 2023-07/05 | 2023-06-09 00:00:00 | 2023-06-09 00:00:00 | 2023-06-19 00:00:00 | 2023-07-07 00:00:00 |  | 1 |  |  |  |  | 1 |  | x |  |  | 1 |  | x |  |  | 1 |  | x |  |  | 1 |  |  |  |  | 1 |  | x |  |  | MP | 23-355 | 1 |  | 0 |  | 0 |  | 0 |  | 2 |  |  |  | R | 25456 | 2023-05-16 00:00:00
9570 |  | Customer B | House | 20 | Widget | 1 | 2023-05-12 00:00:00 |  | Waiting for Material | Buy and Sell- new ETA 2023-07-19 | 2023-06-09 00:00:00 | 2023-06-09 00:00:00 | 2023-07-20 00:00:00 | 2023-07-07 00:00:00 |  | 1 |  | x |  |  | 1 |  |  |  |  | 1 |  | x |  |  | 1 |  | x |  |  | 1 |  | x |  |  | 1 |  | x |  |  | KM | 23-364 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | R | 2125 | 20235-17
9450 |  | Customer C | Shawn | 21 | Widget | 1 | 2023-03-30 00:00:00 |  | WIP Finishing | Mat rec'd 04/11 pumpkin P2, 04/13 zone D, 04/20 zone D, 04/24 zone D, 05/05 [NAME] | 2023-06-15 00:00:00 | 2023-06-15 00:00:00 | 2023-06-15 00:00:00 | 2023-07-07 00:00:00 |  | 1 |  |  |  | 2023-05-23 00:00:00 | 1 |  | x |  |  | 2 |  |  |  | 2023-06-15 00:00:00 | 2 |  |  |  |  | 1 |  |  |  |  | 1 |  | x |  |  | KM | 22-643 Rev 3 | 74 |  | 0 |  | 22 |  | 22 |  | 7 |  | 0 |  | R | 33485 | 2023-04-17 00:00:00
9483-1 |  | Customer D | [NAME] | 22 | Widget | 1 | 2023-04-13 00:00:00 |  | WIP Packaging | Removal (10hrs) due: 2023-05-12- complete | 2023-06-16 00:00:00 | 2023-06-16 00:00:00 | 2023-06-23 00:00:00 | 2023-07-07 00:00:00 |  | 2 |  |  |  | 2023-06-01 00:00:00 | 1 |  | x |  |  | 1 |  |  |  | 2023-06-22 00:00:00 | 1 |  |  |  | 2023-06-22 00:00:00 | 1 |  |  |  | 2023-06-26 00:00:00 | 1 |  | x |  |  | SS | 23-256 | 8 |  | 0 |  | 8 |  | 7 |  | 1 |  | 0 |  | R | 9920 | 2023-04-25 00:00:00