Spreadsheet: 853054d1703005642-sumifs-with-date-and-1-other-criteria-scheduling-kansas-press-calc
Sheet: Fabric

T1 |  | Total hours |  |  |  |  | 2023-11-30 00:00:00 |  | 11:59:19
Time to Print | Job # | Line # | Customer | QTY | H | W | Material | Sides to Print | [NAME] | Due Date | Est. usage | PRESS | Notes
 | 243099 | 1 | Custom Color Marketing | 1 | 52 | 69 | CON-4586 - FABRIC-LIGHTBOX-126 | 1 | 2 Pass | 2023-12-06 00:00:00 |  | Fab
 | 243062 | 1 | HH Global- JD Sports | 4 | 48 | 23 | CON-4586 - FABRIC-LIGHTBOX-126 | 1 | 2 Pass | 2023-12-06 00:00:00 |  | Fab
 | 243146 | 1 | HH Global- JD Sports | 5 | 24 | 114 | CON-4586 - FABRIC-LIGHTBOX-126 | 1 | 2 Pass | 2023-12-08 00:00:00 |  | Fab
 | 243061 | 1 | Tanger Outlet Centers | 1 | 72 | 30 | ART-4960 - ABERDEEN 6653 FABRIC BANNER SOFT | 1 | 2 Pass | 2023-12-11 00:00:00 |  | Fab
 | 243060 | 1 | Tanger Outlet Centers | 12 | 72 | 30 | ART-4960 - ABERDEEN 6653 FABRIC BANNER SOFT | 1 | 2 Pass | 2023-12-11 00:00:00 |  | Fab
 | 243051 | 1-2 | SEG Systems | 2 | 24 | 24 | ART-4589 - CELTIC BLACK BLACK | 1 | 2 Pass | 2023-12-11 00:00:00 |  | Fab
 | 243072 | 1 | HH Global- JD Sports | 4 | 38 | 95 | CON-4586 - FABRIC-LIGHTBOX-126 | 1 | 2 Pass | 2023-12-12 00:00:00 |  | Fab
 | 243071 | 1 | HH Global- JD Sports | 2 | 38 | 95 | CON-4586 - FABRIC-LIGHTBOX-126 | 1 | 2 Pass | 2023-12-12 00:00:00 |  | Fab
 | 243070 | 1 | HH Global- JD Sports | 1 | 95 | 95 | CON-4586 - FABRIC-LIGHTBOX-126 | 1 | 2 Pass | 2023-12-12 00:00:00 |  | Fab
 | 243069 | 1 | HH Global- JD Sports | 3 | 48 | 14 | CON-4586 - FABRIC-LIGHTBOX-126 | 1 | 2 Pass | 2023-12-12 00:00:00 |  | Fab
 | 243066 | 1 | HH Global- JD Sports | 4 | 38 | 95 | CON-4586 - FABRIC-LIGHTBOX-126 | 1 | 2 Pass | 2023-12-12 00:00:00 |  | Fab
 | 243067 | 1 | HH Global- JD Sports | 1 | 20 | 28 | CON-4586 - FABRIC-LIGHTBOX-126 | 1 | 2 Pass | 2023-12-12 00:00:00 |  | Fab
 | 243065 | 1-2 | Acrylic Design Associates | 5 | 40 | 30 | ART-4960 - ABERDEEN 6653 FABRIC BANNER SOFT | 1 | 2 Pass | 2023-12-12 00:00:00 |  | Fab
 | 243131 | 1 | IBT Industrial Solutions | 1 | 32 | 85 |  | 1 | 2 Pass | 2023-12-13 00:00:00 |  | Fab
 | 243112 | 3 | SEG Systems | 2 | 24 | 96 | ART-4589 - CELTIC BLACK BLACK | 1 | 2 Pass | 2023-12-13 00:00:00 |  | Fab
 | 243232 | 1 | SEG Systems | 1 | 48 | 35 | ART-4589 - CELTIC BLACK BLACK | 1 | 2 Pass | 2023-12-13 00:00:00 |  | Fab
 | 243236 | 1 | HH Global- JD Sports | 2 | 48 | 95 | CON-4586 - FABRIC-LIGHTBOX-126 | 1 | 2 Pass | 2023-12-13 00:00:00 |  | Fab
 | 243261 | 1 | Acrylic Design Associates | 3 | 40 | 30 | ART-4960 - ABERDEEN 6653 FABRIC BANNER SOFT | 1 | 2 Pass | 2023-12-13 00:00:00 |  | Fab
 | 243187 | 1-2 | SEG Systems | 4 | 64 | 94 | CON-4586 - FABRIC-LIGHTBOX-126 | 1 | 2 Pass | 2023-12-14 00:00:00 |  | Fab
 | 243233 | 1 | SEG Systems | 2 | 83 | 113 | CON-4586 - FABRIC-LIGHTBOX-126 | 1 | 2 Pass | 2023-12-14 00:00:00 |  | Fab
 | 243161 | 1 | SEG Systems | 6 | 99 | 35 | ART-4589 - CELTIC BLACK BLACK | 1 | 2 Pass | 2023-12-15 00:00:00 |  | Fab
 | 243161 | 2 | SEG Systems | 4 | 48 | 35 | ART-4589 - CELTIC BLACK BLACK | 1 | 2 Pass | 2023-12-15 00:00:00 |  | Fab
 | 243150 | 1 | HH Global- JD Sports | 1 | 20 | 28 | CON-4586 - FABRIC-LIGHTBOX-126 | 1 | 2 Pass | 2023-12-15 00:00:00 |  | Fab
 | 243149 | 1 | HH Global- JD Sports | 1 | 24 | 107 | CON-4586 - FABRIC-LIGHTBOX-126 | 1 | 2 Pass | 2023-12-15 00:00:00 |  | Fab
 | 243123 | 1 | Kansas Speedway | 1 | 120 | 96 | ART-4960 - ABERDEEN 6653 FABRIC BANNER SOFT | 1 | 2 Pass | 2023-12-15 00:00:00 |  | Fab
 | 243215 | 1 | Blast Media Print Corp | 1 | 245 | 123 | CON-4586 - FABRIC-LIGHTBOX-126 | 1 | 2 Pass | 2023-12-15 00:00:00 |  | Fab
 | 243259 | 1 | HH Global- JD Sports | 13 | 38 | 95 | CON-4586 - FABRIC-LIGHTBOX-126 | 1 | 2 Pass | 2023-12-15 00:00:00 |  | Fab
 | 243287 | 1 | HH Global- JD Sports | 1 | 40 | 91 | CON-4586 - FABRIC-LIGHTBOX-126 | 1 | 2 Pass | 2023-12-15 00:00:00 |  | Fab
 | 243179 | 1 | [NAME] | 1 | 76 | 30 | ART-4960 - ABERDEEN 6653 FABRIC BANNER SOFT | 1 | 2 Pass | 2023-12-15 00:00:00 |  | Fab
 | 243288 | 1 | HH Global- JD Sports | 1 | 46 | 95 | CON-4586 - FABRIC-LIGHTBOX-126 | 1 | 2 Pass | 2023-12-15 00:00:00 |  | Fab
 | 243302 | 1 | HH Global- JD Sports | 1 | 24 | 114 | CON-4586 - FABRIC-LIGHTBOX-126 | 1 | 3 Pass | 2023-12-15 00:00:00 |  | Fab
 | 243346 | 1 | HH Global- JD Sports | 4 | 71 | 99 | CON-4586 - FABRIC-LIGHTBOX-126 | 1 | 2 Pass | 2023-12-19 00:00:00 |  | Fab
 | 243346 | 2 | HH Global- JD Sports | 2 | 48 | 23 | CON-4586 - FABRIC-LIGHTBOX-126 | 1 | 2 Pass | 2023-12-19 00:00:00 |  | Fab
 | 243227 | 1 | Honeywell FMT LLC | 3 | 40 | 86 | ART-4589 - CELTIC BLACK BLACK | 1 | 2 Pass | 2023-12-20 00:00:00 |  | Fab
 | 243289 | 1 | SEG Systems | 2 | 120 | 12 | ART-4589 - CELTIC BLACK BLACK | 1 | 2 Pass | 2023-12-20 00:00:00 |  | Fab
 | 243339 | 1 | HH Global- JD Sports | 20 | 24 | 107 | CON-4586 - FABRIC-LIGHTBOX-126 | 1 | 2 Pass | 2023-12-20 00:00:00 |  | Fab
 | 243339 | 2 | HH Global- JD Sports | 33 | 48 | 23 | CON-4586 - FABRIC-LIGHTBOX-126 | 1 | 2 Pass | 2023-12-20 00:00:00 |  | Fab
 | 243327 | 1 | [NAME] | 1 | 56 | 80 | ART-4960 - ABERDEEN 6653 FABRIC BANNER SOFT | 1 | 2 Pass | 2023-12-21 00:00:00 |  | Fab
 | 243385 | 1 | HH Global- JD Sports | 125 | 20 | 28 | CON-4586 - FABRIC-LIGHTBOX-126 | 1 | 2 Pass | 2023-12-21 00:00:00 |  | Fab | Not Approved
 | 243339 | 1 | HH Global- JD Sports | 14 | 48 | 23 | CON-4586 - FABRIC-LIGHTBOX-126 | 1 | 2 Pass | 2023-12-21 00:00:00 |  | Fab | Outsourced??
 | 243330 | 1 | [NAME] | 1 | 40 | 31 | CON-4586 - FABRIC-LIGHTBOX-126 | 1 | 2 Pass | 2023-12-22 00:00:00 |  | Fab
 | 243304 | 1 | Tanger Outlet Centers | 1 | 92 | 44 | ART-4960 - ABERDEEN 6653 FABRIC BANNER SOFT | 1 | 2 Pass | 2023-12-22 00:00:00 |  | Fab
 | 243381 | 1 | Event Strategy Group | 1 | 72 | 72 | ART-4960 - ABERDEEN 6653 FABRIC BANNER SOFT | 1 | 2 Pass | 2023-12-22 00:00:00 |  | Fab | Presses down in Fab-
 | 243405 | 1 | Tanger Outlet Centers | 12 | 72 | 30 | ART-4960 - ABERDEEN 6653 FABRIC BANNER SOFT | 1 | 2 Pass | 2023-12-22 00:00:00 |  | Fab
 | 243408 | 1 | Blast Media Print Corp | 2 | 60 | 96 | CON-4586 - FABRIC-LIGHTBOX-126 | 1 | 2 Pass | 2023-12-22 00:00:00 |  | Fab
 | 243413 | 1 | SEG Systems | 1 | 48 | 24 | ART-4589 - CELTIC BLACK BLACK | 1 | 2 Pass | 2023-12-28 00:00:00 |  | Fab
 | 243413 | 2 | SEG Systems | 1 | 48 | 84 | ART-4589 - CELTIC BLACK BLACK | 1 | 2 Pass | 2023-12-28 00:00:00 |  | Fab
 | 243413 | 3 | SEG Systems | 1 | 144 | 84 | ART-4589 - CELTIC BLACK BLACK | 1 | 2 Pass | 2023-12-28 00:00:00 |  | Fab
 | 243413 | 4 | SEG Systems | 1 | 48 | 48 | ART-4589 - CELTIC BLACK BLACK | 1 | 2 Pass | 2023-12-28 00:00:00 |  | Fab
 | 243413 | 5 | SEG Systems | 4 | 96 | 18 | ART-4589 - CELTIC BLACK BLACK | 1 | 2 Pass | 2023-12-28 00:00:00 |  | Fab
 | 243413 | 6 | SEG Systems | 1 | 96 | 24 | ART-4589 - CELTIC BLACK BLACK | 1 | 2 Pass | 2023-12-28 00:00:00 |  | Fab
 | 243413 | 7 | SEG Systems | 2 | 42 | 114 | ART-4589 - CELTIC BLACK BLACK | 1 | 2 Pass | 2023-12-28 00:00:00 |  | Fab
 | 243413 | 8 | SEG Systems | 3 | 108 | 13 | ART-4589 - CELTIC BLACK BLACK | 1 | 2 Pass | 2023-12-28 00:00:00 |  | Fab
 | 243413 | 9 | SEG Systems | 3 | 111 | 35 | ART-4589 - CELTIC BLACK BLACK | 1 | 2 Pass | 2023-12-28 00:00:00 |  | Fab
 | 243413 | 10 | SEG Systems | 2 | 123 | 18 | ART-4589 - CELTIC BLACK BLACK | 1 | 2 Pass | 2023-12-28 00:00:00 |  | Fab
 | 243413 | 11 | SEG Systems | 1 | 43 | 16 | CON-4586 - FABRIC-LIGHTBOX-126 | 1 | 2 Pass | 2023-12-28 00:00:00 |  | Fab
 | 243413 | 12 | SEG Systems | 3 | 184 | 44 | CON-4586 - FABRIC-LIGHTBOX-126 | 1 | 2 Pass | 2023-12-28 00:00:00 |  | Fab
 | 243414 | 1 | SEG Systems | 1 | 48 | 60 | ART-4589 - CELTIC BLACK BLACK | 1 | 2 Pass | 2023-12-28 00:00:00 |  | Fab
 | 243416 | 1 | SEG Systems | 1 | 96 | 24 | ART-4589 - CELTIC BLACK BLACK | 1 | 2 Pass | 2023-12-28 00:00:00 |  | Fab
 | 243416 | 2 | SEG Systems | 2 | 96 | 18 | ART-4589 - CELTIC BLACK BLACK | 1 | 2 Pass | 2023-12-28 00:00:00 |  | Fab
 | 243416 | 3 | SEG Systems | 2 | 42 | 114 | ART-4589 - CELTIC BLACK BLACK | 1 | 2 Pass | 2023-12-28 00:00:00 |  | Fab
 | 243416 | 4 | SEG Systems | 2 | 60 | 42 | ART-4589 - CELTIC BLACK BLACK | 1 | 2 Pass | 2023-12-28 00:00:00 |  | Fab
 | 243416 | 5 | SEG Systems | 2 | 76 | 95 | ART-4589 - CELTIC BLACK BLACK | 1 | 2 Pass | 2023-12-28 00:00:00 |  | Fab
 | 243416 | 6 | SEG Systems | 2 | 123 | 18 | CON-4586 - FABRIC-LIGHTBOX-126 | 1 | 2 Pass | 2023-12-28 00:00:00 |  | Fab
 | 243416 | 7 | SEG Systems | 2 | 48 | 24 | CON-4586 - FABRIC-LIGHTBOX-126 | 1 | 2 Pass | 2023-12-28 00:00:00 |  | Fab
 | 243417 | 1 | SEG Systems | 2 | 31 | 35 | ART-4589 - CELTIC BLACK BLACK | 1 | 2 Pass | 2023-12-28 00:00:00 |  | Fab
 | 243417 | 2 | SEG Systems | 2 | 37 | 35 | ART-4589 - CELTIC BLACK BLACK | 1 | 2 Pass | 2023-12-28 00:00:00 |  | Fab
 | 243417 | 3 | SEG Systems | 1 | 60 | 72 | ART-4589 - CELTIC BLACK BLACK | 1 | 2 Pass | 2023-12-28 00:00:00 |  | Fab
 | 243417 | 4 | SEG Systems | 3 | 48 | 24 | CON-4586 - FABRIC-LIGHTBOX-126 | 1 | 2 Pass | 2023-12-28 00:00:00 |  | Fab
 | 243400 | 1-2 | SEG Systems | 5 | 60 | 84 | CON-4586 - FABRIC-LIGHTBOX-126 | 1 | 2 Pass | 2024-01-02 00:00:00 |  | Fab
 | 243400 | 3-4 | SEG Systems | 5 | 60 | 84 | ART-4589 - CELTIC BLACK BLACK | 1 | 2 Pass | 2024-01-02 00:00:00 |  | Fab