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

 |  | [NAME] for column A |  | Data Validation for Column J
 |  |  | [NAME]
 |  |  | HP/ 3R Formula
 |  |  | GS Formula
 |  |  | HS Formula
ALL JOBS |  | Total hours
Time to Print | Job # | Line # | Customer | QTY | H | W | Material | Sides to Print | [NAME] | Due_Date | Est. usage | PRESS | Notes
 | 243116 | 1 | Savers | 1 | 67 | 79 | ART-2150 - 54X150 3M IJ180C CONTROLTAC PLUS | 1 | 5-Pass | 2023-12-11 00:00:00 |  | HP
 | 243088 | 1 | Compass Visual Structures | 3 | 39 | 95 | PAP-444450 - 48X96 30PT STYRENE | 1 | 4 Pass | 2023-12-13 00:00:00 |  | [NAME] | NIP
 | 243088 | 2 | Compass Visual Structures | 1 | 20 | 10 | PAP-444450 - 48X96 30PT STYRENE | 1 | 4 Pass | 2023-12-13 00:00:00 |  | [NAME] | NIP
 | 243041 | 1 | Adform Creative | 300 | 21 | 57 | PAP-SO-2171 - E-FLUTE SINGLE SIDED 50X80 | 1 | 4 Pass | 2023-12-13 00:00:00 |  | [NAME] | Double-sided  Tape NIP DATE CHANGED
 | 243235 | 1 | Custom Color Marketing | 2000 | 3 | 4 |  | 2 |  | 2023-12-13 00:00:00 |  | Indigo | Stoplight-
 | 243258 | 1 | HH Global- JD Sports | 72 | 48 | 18 | PAP-SO-0040 - 48X96 20PT STYRENE | 1 | 4 Pass | 2023-12-13 00:00:00 |  | [NAME]
 | 243128 | 1 | Kansas City Parks and Recreations | 1 | 60 | 36 | PAP-SO-2144 - ACM-6MMWHT-4896 | 2 | 4 Pass | 2023-12-14 00:00:00 |  | [NAME] | LL Gloss- Special Order Material
 | 243130 | 1 | Clipper Distributing | 1 | 79 | 49 | ART-2132 - 54x150 3MIL WHITE PERMANENT DECAL | 1 | 4 Pass | 2023-12-14 00:00:00 |  | [NAME] | Mount to Rigid Substrate (b-Flute) + Laminate
 | 243171 | 1 | Artworkstudio, Inc | 1 | 30 | 24 | PAP-SO-1157 - 3MM ACM White | 1 | 4 Pass | 2023-12-14 00:00:00 |  | [NAME] | [NAME]
 | 242177 | 1 | SupplyLogic | 15 | 20 | 14 | PAP-SO-2193 - CARDSTOCK 24PT C2S 48X96 | 1 | 4 Pass | 2023-12-14 00:00:00 |  | [NAME] | Easels
 | 243254 | 1 | Savers | 1 | 96 | 48 | PAP-SO-1157 - 3MM ACM White | 1 | 4 Pass | 2023-12-14 00:00:00 |  | [NAME]
 | 243255 | 1 | Savers | 9 | 96 | 30 | PAP-SO-0056 - 48X96 40PT STYRENE | 2 | 4 Pass | 2023-12-14 00:00:00 |  | [NAME]
1 | 243132 | 1-2 | Century Marketing | 4 | 30 | 3 | PAP-SO-0056 - 48X96 40PT STYRENE | 1 |  | 2023-12-14 00:00:00 |  | Cut Only
1 | 243167 | 1 | SEG Systems | 1 | 72 | 39 | ART-4393 - VINYL WHITE 31086 PERM 54X300 | 1 |  | 2023-12-14 00:00:00 |  | Cut Only
1 | 243213 | 1 | SupplyLogic | 30 | 6 | 3 | ART-4499 - CUTVINYL-WHT-48 | 1 |  | 2023-12-14 00:00:00 |  | Cut Only | Saphire Blue
 | 243150 | 2 | HH Global- JD Sports | 6 | 60 | 15 | PAP-SO-0040 - 48X96 20PT STYRENE | 1 | 4 Pass | 2023-12-15 00:00:00 |  | [NAME]
 | 243092 | 1 | SupplyLogic | 25 | 14 | 6 | PAP-SO-0056 - 48X96 40PT STYRENE | 1 | 4 Pass | 2023-12-15 00:00:00 |  | [NAME]
 | 243091 | 1 | SupplyLogic | 10 | 18 | 4 | PAP-SO-2145 - ACRYLIC-1875CL-4896 | 1 | FU or [NAME] | 2023-12-15 00:00:00 |  | [NAME] | Acrylic 1/8" Clear
 | 243089 | 1 | SupplyLogic | 15 | 12 | 16 | PAP-SO-1157 - 3MM ACM White | 1 | 4 Pass | 2023-12-15 00:00:00 |  | [NAME]
 | 243182 | 1 | Discovery-Based Retail | 1 | 20 | 14 | PAP-SO-1157 - 3MM ACM White | 1 | 4 Pass | 2023-12-15 00:00:00 |  | [NAME]
 | 243202 | 1 | [NAME] | 16 | 36 | 24 | PAP-SO-0016 - 48X96 COROPLAST | 1 | 4 Pass | 2023-12-15 00:00:00 |  | [NAME]
 | 243212 | 1-2 | Artworkstudio, Inc | 2 | 30 | 42 | PAP-SO-2149 - ALUM-040WHT-4896 | 1 | 4 Pass | 2023-12-15 00:00:00 |  | [NAME]
 | 243214 | 1-2 | American Outdoor Brands | 15 | 62 | 10 | PAP-444450 - 48X96 30PT STYRENE | 2 | 4 Pass | 2023-12-15 00:00:00 |  | [NAME]
 | 243216 | 2 | Careismatic Brands | 3 | 48 | 16 | PAP-SO-1278 - CARDSTOCK 24PT C2S 50X98 | 1 | 4 Pass | 2023-12-15 00:00:00 |  | [NAME] | Changed to PAP-413740
 | 243222 | 1 | Bo Shannon Graphic Production | 4 | 68 | 24 | PAP-SO-1374 - FOAMCORE 3/16IN WHITE 48X96 | 1 | 4 Pass | 2023-12-15 00:00:00 |  | [NAME]
 | 243229 | 2 | Westlake Hardware | 8 | 23 | 23 | PAP-SO-0016 - 48X96 COROPLAST | 1 | 4 Pass | 2023-12-15 00:00:00 |  | [NAME]
 | 243229 | 3 | Westlake Hardware | 4 | 24 | 24 | PAP-SO-0016 - 48X96 COROPLAST | 1 | 4 Pass | 2023-12-15 00:00:00 |  | [NAME]
 | 243238 | 1-3 | Careismatic Brands | 35 | 22 | 7 | PAP-SO-1283 - CARDSTOCK 12PT C2S 48X96 | 2 | 4 Pass | 2023-12-15 00:00:00 |  | [NAME]
 | 243238 | 4 | Careismatic Brands | 1 | 22 | 28 | PAP-413740 - 48X60 24PT C2S SBS | 1 | 4 Pass | 2023-12-15 00:00:00 |  | [NAME]
 | 243205 | 1 | Scooter's | 2 | 33 | 67 | ART-4399 - WHT 70/30 PERF VINYL 54X300 | 1 | 5-Pass | 2023-12-15 00:00:00 |  | HP
 | 243205 | 2 | Scooter's | 2 | 36 | 68 | ART-4399 - WHT 70/30 PERF VINYL 54X300 | 1 | 5-Pass | 2023-12-15 00:00:00 |  | HP
 | 243240 | 1 | Seaboard Foods | 350 | 9 | 6 | ART-2150 - 54X150 3M IJ180C CONTROLTAC PLUS | 1 | 5-Pass | 2023-12-15 00:00:00 |  | HP | Needs to print ASAP-Needs to Laminate & has a  Large cutting time
 | 243216 | 1 | Careismatic Brands | 2 | 23 | 48 | ART-4537 - VINYL-SS12OZ-126 | 1 | 5-Pass | 2023-12-15 00:00:00 |  | 3R
 | 243229 | 1 | Westlake Hardware | 1 | 72 | 36 | ART-4531 - VINYL-MAT13OZ-JUMBO-126 | 1 | 5-Pass | 2023-12-15 00:00:00 |  | 3R
1 | 243205 | 3 | Scooter's | 3 | 23 | 7 | ART-4499 - CUTVINYL-WHT-48 | 1 |  | 2023-12-15 00:00:00 |  | CO
1 | 243212 | 3-4 | Artworkstudio, Inc | 7 | 60 | 40 | PAP-SO-0040 - 48X96 20PT STYRENE | 1 |  | 2023-12-15 00:00:00 |  | CO
 | 243274 | 1 | Custom Color Marketing | 4 | 36 | 12 | ART-2132 - 54x150 3MIL WHITE PERMANENT DECAL | 1 | 4 Pass | 2023-12-15 00:00:00 |  | [NAME] | Mount to .40 Alum
 | 243274 | 2 | Custom Color Marketing | 4 | 36 | 12 | ART-2132 - 54x150 3MIL WHITE PERMANENT DECAL | 1 | 4 Pass | 2023-12-15 00:00:00 |  | [NAME] | Mount to .25 white acrylic
 | 243274 | 3 | Custom Color Marketing | 4 | 36 | 12 | ART-2132 - 54x150 3MIL WHITE PERMANENT DECAL | 1 | 4 Pass | 2023-12-15 00:00:00 |  | [NAME] | Mount to .125 white acrylic
 | 243296 | 1 | Katalyst Group Inc. | 13 | 71 | 34 | PAP-444450 - 48X96 30PT STYRENE | 1 | 4 Pass | 2023-12-15 00:00:00 |  | [NAME] | Reprint
 | 243139 | 1 | APEX | 20 | 33 | 10 | PAP-SO-1841 - PETG 0.06IN CLEAR | 1 | FU or [NAME] | 2023-12-18 00:00:00 |  | [NAME]
 | 243158 | 1 | HH Global- JD Sports | 54 | 11 | 6 | PAP-SO-0061 - SINTRA 3MM WHITE 48X96 | 1 | 4 Pass | 2023-12-18 00:00:00 |  | [NAME]
 | 243208 | 1 | HH Global- JD Sports | 6 | 60 | 15 | PAP-SO-0040 - 48X96 20PT STYRENE | 1 | 4 Pass | 2023-12-18 00:00:00 |  | [NAME]
 | 243209 | 1 | HH Global- JD Sports | 2 | 48 | 36 | PAP-SO-0040 - 48X96 20PT STYRENE | 1 | 4 Pass | 2023-12-18 00:00:00 |  | [NAME]
 | 242211 | 1 | HH Global- JD Sports | 4 | 56 | 15 | PAP-SO-0040 - 48X96 20PT STYRENE | 1 | 4 Pass | 2023-12-18 00:00:00 |  | [NAME] | NIP 12/15/23 @ 7am- AN
 | 243234 | 3 | Westlake Hardware | 4 | 20 | 24 | PAP-SO-0016 - 48X96 COROPLAST | 1 | 4 Pass | 2023-12-18 00:00:00 |  | [NAME]
 | 243250 | 1 | American Outdoor Brands | 2 | 32 | 72 | PAP-SO-0040 - 48X96 20PT STYRENE | 1 | 4 Pass | 2023-12-18 00:00:00 |  | [NAME]
 | 243234 | 1 | Westlake Hardware | 1 | 24 | 48 | ART-4531 - VINYL-MAT13OZ-JUMBO-126 | 1 | 5-Pass | 2023-12-18 00:00:00 |  | 3R
 | 243234 | 2 | Westlake Hardware | 1 | 144 | 24 | ART-4531 - VINYL-MAT13OZ-JUMBO-127 | 1 | 5-Pass | 2023-12-18 00:00:00 |  | 3R
 | 243268 | 1 | Buckle | 5 | 36 | 84 | ART-4537 - VINYL-SS12OZ-126 | 1 | 5-Pass | 2023-12-18 00:00:00 |  | 3R | Due 12/19 - Changed to smaller rolls
 | 243277 | 1 | Acrylic Design Associates | 1 | 28 | 16 | [NAME] 102" | 1 | 5-Pass | 2023-12-18 00:00:00 |  | 3R | Samba FR
 | 243276 | 1 | BigSigns | 2 | 60 | 60 | ART-4483 - GFLOOR-SMALL-COIN-120 | 1 | FU or [NAME] | 2023-12-20 00:00:00 |  | [NAME]
 | 243278 | 1-2 | Careismatic Brands | 126 | 22 | 7 | PAP-SO-1283 - CARDSTOCK 12PT C2S 48X96 | 2 | 4 Pass | 2023-12-20 00:00:00 |  | [NAME]
 | 243278 | 3 | Careismatic Brands | 63 | 18 | 24 | PAP-SO-1278 - CARDSTOCK 24PT C2S 50X98 | 1 | 4 Pass | 2023-12-20 00:00:00 |  | [NAME]
 | 243278 | 4 | Careismatic Brands | 63 | 3 | 3 | ART-2132 - 54x150 3MIL WHITE PERMANENT DECAL | 1 | 5-Pass | 2023-12-20 00:00:00 |  | 3R
 | 243284 | 1 | CarMax | 10 | 5 | 6 | ART-2150 - 54X150 3M IJ180C CONTROLTAC PLUS | 1 | 5-Pass | 2023-12-20 00:00:00 |  | HP | Laminate
1 | 243285 | 1 | CarMax | 10 | 144 | 30 | ART-4495 - CUTVINYL-ETCH-48 | 1 |  | 2023-12-20 00:00:00 |  | Cut Only | Kisscut+Weed+premask
 | 243286 | 1 | CarMax | 2 | 11 | 9 | PAP-SO-0061 - SINTRA 3MM WHITE 48X96 | 1 | 4 Pass | 2023-12-20 00:00:00 |  | [NAME]
 | 243295 | 1 | The Rogers Company | 1 | 60 | 36 | ART-5008 - GFLOOR-.050 CERAMIC-CL-120-SATIN | 1 | FU or [NAME] | 2023-12-20 00:00:00 |  | [NAME] | Back Trac Anti slip
 | 243299 | 1 | Country Club Plaza | 5 | 37 | 49 | ART-3307 - 63X328 DURAVIEW 5MIL BACKLIT (UV) | 1 | Backlit | 2023-12-20 00:00:00 |  | HP | backlit film??
 | 243305 | 1-2 | Careismatic Brands | 4 | 22 | 7 | PAP-SO-1283 - CARDSTOCK 12PT C2S 48X96 | 2 | 4 Pass | 2023-12-20 00:00:00 |  | [NAME]
 | 243305 | 3 | Careismatic Brands | 2 | 21 | 52 | PAP-SO-2193 - CARDSTOCK 24PT C2S 48X96 | 1 | 4 Pass | 2023-12-20 00:00:00 |  | [NAME]
 | 243306 | 1-2 | Careismatic Brands | 4 | 22 | 7 | PAP-SO-1283 - CARDSTOCK 12PT C2S 48X96 | 2 | 4 Pass | 2023-12-20 00:00:00 |  | [NAME]
 | 243306 | 3 | Careismatic Brands | 2 | 21 | 52 | PAP-SO-2193 - CARDSTOCK 24PT C2S 48X96 | 1 | 4 Pass | 2023-12-20 00:00:00 |  | [NAME]
 | 243210 | 1 | SEG Systems | 2 | 12 | 32 | PAP-SO-0061 - SINTRA 3MM WHITE 48X96 | 1 | 4 Pass | 2023-12-20 00:00:00 |  | [NAME]
 | 243410 | 1 | SEG Systems | 2 | 12 | 32 | PAP-SO-0061 - SINTRA 3MM WHITE 48X96 | 1 | 4 Pass | 2023-12-20 00:00:00 |  | [NAME]
 | 243298 | 1-2 | Careismatic Brands | 402 | 22 | 7 | PAP-SO-1283 - CARDSTOCK 12PT C2S 48X96 | 2 | 4 Pass | 2023-12-21 00:00:00 |  | [NAME]
 | 243298 | 3 | Careismatic Brands | 201 | 18 | 24 | PAP-SO-2193 - CARDSTOCK 24PT C2S 48X96 | 1 | 4 Pass | 2023-12-21 00:00:00 |  | [NAME]
 | 243298 | 4 | Careismatic Brands | 201 | 3 | 3 | ART-2132 - 54x150 3MIL WHITE PERMANENT DECAL | 1 | 5-Pass | 2023-12-21 00:00:00 |  | 3R
 | 243307 | 1 | SEG Systems | 4 | 20 | 20 | ART-2132 - 54x150 3MIL WHITE PERMANENT DECAL | 1 | 5-Pass | 2023-12-21 00:00:00 |  | 3R
 | 243314 | 1 | BigSigns | 2 | 48 | 48 | ART-4483 - GFLOOR-SMALL-COIN-120 | 1 | FU or [NAME] | 2023-12-21 00:00:00 |  | [NAME]
 | 243308 | 1 | [NAME] | 140 | 18 | 24 | PAP-SO-1283 - CARDSTOCK 12PT C2S 48X96 | 1 | 4 Pass | 2023-12-21 00:00:00 |  | [NAME]
 | 243320 | 1-2 | Careismatic Brands- MC | 3 | 48 | 84 | ART-4399 - WHT 70/30 PERF VINYL 54X300 | 1 | 5-Pass | 2023-12-21 00:00:00 |  | HP
 | 243326 | 1 | BigSigns.com | 2 | 60 | 60 | ART-4483 - GFLOOR-SMALL-COIN-120 | 1 | FU or [NAME] | 2023-12-21 00:00:00 |  | [NAME] | Grey foam backer
 | 243407 | 1 | SupplyLogic | 1 | 96 | 48 | ART-4531 - VINYL-MAT13OZ-JUMBO-126 | 1 | 5-Pass | 2023-12-21 00:00:00 |  | 3R | sew hem grommets
 |  |  | HH Global- JD Sports | 10 | 28 | 96 | ART-4389 - Static Cling Clear CV800C 54X300 | 1 | FU or [NAME] | 2023-12-21 00:00:00 |  | [NAME]
 | 243319 | 1 | SupplyLogic | 2 | 120 | 36 | ART-4531 - VINYL-MAT13OZ-JUMBO-126 | 1 | 5-Pass | 2023-12-22 00:00:00 |  | 3R
 | 243375 | 1 | Blast Media Print Corp | 21 | 24 | 36 | PAP-SO-0016 - 48X96 COROPLAST | 1 | 4 Pass | 2023-12-22 00:00:00 |  | [NAME]
 | 243375 | 2 | Blast Media Print Corp | 1 | 48 | 54 | PAP-SO-0016 - 48X96 COROPLAST | 1 | 4 Pass | 2023-12-22 00:00:00 |  | [NAME]
 | 243375 | 3 | Blast Media Print Corp | 2 | 24 | 24 | PAP-SO-0016 - 48X96 COROPLAST |  | 4 Pass | 2023-12-22 00:00:00 |  | [NAME]
 | 243375 | 4 | Blast Media Print Corp | 4 | 24 | 84 | PAP-SO-0016 - 48X96 COROPLAST | 1 | 4 Pass | 2023-12-22 00:00:00 |  | [NAME]
 | 243375 | 5-6 | Blast Media Print Corp | 16 | 18 | 80 | ART-4399 - WHT 70/30 PERF VINYL 54X300 | 1 | 5-Pass | 2023-12-22 00:00:00 |  | 3R
 | 243375 | 7 | Blast Media Print Corp | 2 | 24 | 20 | ART-2132 - 54x150 3MIL WHITE PERMANENT DECAL | 1 | 5-Pass | 2023-12-22 00:00:00 |  | 3R
 | 243375 | 8 | Blast Media Print Corp | 300 | 2 | 2 | ART-2132 - 54x150 3MIL WHITE PERMANENT DECAL | 1 | 5-Pass | 2023-12-22 00:00:00 |  | 3R
 | 243375 | 9-12 | Blast Media Print Corp | 50 | 15 | 8 | ART-2132 - 54x150 3MIL WHITE PERMANENT DECAL | 1 | 5-Pass | 2023-12-22 00:00:00 |  | 3R
 | 243381 | 2 | Event Strategy Group | 2 | 27 | 71 | ART-4531 - VINYL-MAT13OZ-JUMBO-127 | 1 | 5-Pass | 2023-12-22 00:00:00 |  | 3R
 | 243383 | 1-2 | Brush Art Corporation | 2 | 111 | 72 | ART-4531 - VINYL-MAT13OZ-JUMBO-127 | 1 | 5-Pass | 2023-12-22 00:00:00 |  | 3R
 | 243403 | 1-2 | Country Club Plaza | 3 | 110 | 86 | ART-4378 - 60X300 3.6MIL WHT REM/POLYETHYL | 1 | 4 Pass | 2023-12-22 00:00:00 |  | 3R
 | 243411 | 1 | Full Bright Sign | 1 | 62 | 52 |  | 1 | 4 Pass | 2023-12-22 00:00:00 |  | [NAME] | 6mm White Rigid material- Special Order
 | 243411 | 2 | Full Bright Sign | 7 | 75 | 35 | PAP-SO-2144 - ACM-6MMWHT-4896 | 1 | 4 Pass | 2023-12-22 00:00:00 |  | [NAME]
 | 243378 | 1 | Careismatic Brands | 6 | 22 | 7 | PAP-SO-1283 - CARDSTOCK 12PT C2S 48X96 | 2 | 4 Pass | 2023-12-26 00:00:00 | 23 | [NAME]
 | 243391 | 1-2 | [NAME] | 16 | 36 | 24 | PAP-SO-0016 - 48X96 COROPLAST | 1 | 4 Pass | 2023-12-27 00:00:00 |  | [NAME]
 | 243394 | 1 | SupplyLogic | 20 | 24 | 36 | PAP-SO-1157 - 3MM ACM White | 1 | 4 Pass | 2023-12-27 00:00:00 |  | [NAME]
 | 243367 | 1 | [NAME] | 132 | 25 | 27 | PAP-SO-0061 - SINTRA 3MM WHITE 48X96 | 2 | 4 Pass | 2023-12-28 00:00:00 |  | [NAME] | Approved by [NAME]
 | 243418 | 1-8 | APEX | 31 | 53 | 8 | PAP-SO-1841 - PETG 0.06IN CLEAR | 1 | FU or [NAME] | 2023-12-29 00:00:00 |  | [NAME]
 | 243406 | 2 | SupplyLogic | 1 | 42 | 42 | ART-4399 - WHT 70/30 PERF VINYL 54X300 | 1 | 5-Pass | 2024-01-01 00:00:00 |  | 3R
 | 243406 | 1 | SupplyLogic | 2 | 120 | 36 | ART-4531 - VINYL-MAT13OZ-JUMBO-127 | 1 | 5-Pass | 2024-01-01 00:00:00 |  | 3R
 | 243409 | 1 | SupplyLogic | 1 | 120 | 36 | ART-4531 - VINYL-MAT13OZ-JUMBO-126 | 1 | 5-Pass | 2024-01-01 00:00:00 |  | 3R
 | 243415 | 1 | Regency Office Products | 2 | 48 | 36 | ART-4592 - PHOTOPAPER-SUNSETSATIN-54 | 1 | 5-Pass | 2024-01-01 00:00:00 |  | 3R
 | 243169 | 1-2 | SEG Systems | 2 | 122 | 18 | ART-2132 - 54x150 3MIL WHITE PERMANENT DECAL | 1 | 5-Pass | 2024-01-02 00:00:00 |  | HP | Kisscut+Weed+premask
 | 243372 | 1-3 | Dimensional Innovations | 19 | 60 | 108 |  | 1 | 5-Pass | 2024-01-05 00:00:00 |  | HP | 3M™ Scotchcal™ Clear View Graphic Film IJ8150 150'