Spreadsheet: 866249d1713205627-help-with-formulas-to-populate-a-calendar-kansas-scheduler-calendar-test-v1-2-
Sheet: Art Due from Timeline Requests

 | Rows in Green are in Production
 | [NAME] in gray = On Master [NAME]
 | Update made to Timeline/ Art or Ship date change
Press | SchedTime | Art Due | Ship Date | Timeline ID | Job# | Line# | Master [NAME] [NAME] | QTY | Kitting | #OfKits | Account Manager | Notes | DateRecieved
[NAME] |  | 2024-02-13 00:00:00 | 2024-02-29 00:00:00 |  | 245063 |  | C947611 |  | Yes | ? | [NAME]
FabriVue | 5.41 | 2024-02-15 00:00:00 | 2024-02-27 00:00:00 |  | HHGJ 180 |  | E03067682 | ? | Yes | ? | [NAME]
FabriVue | 1.5 | 2024-02-19 00:00:00 | 2024-02-23 00:00:00 |  |  |  | UPAC Fabric Banners 2 Test pcs | 2 | Yes | ? |  | [NAME]
FabriVue | 12.4 | 2024-02-19 00:00:00 | 2024-03-01 00:00:00 |  | HHGJ 144 |  | Nike Need it Now- E03031693- HHGJ 144 | 527 | Yes | ? | [NAME] | New Ship Date 3/4-3/5?
FabriVue | 2.04 | 2024-02-21 00:00:00 | 2024-03-01 00:00:00 |  | HHGJ 188 |  | E03058955 [NAME] PUMA  Suede XL | 89 | Yes | 69 | [NAME]
FabriVue | 0.56 | 2024-02-22 00:00:00 | 2024-03-01 00:00:00 |  |  |  | E03055560- MENS Vans Q1 0226 | 19 | Yes | 18 | [NAME]
[NAME] | 10.88 | 2024-02-22 00:00:00 | 2024-03-12 00:00:00 |  | 245265 245260 245253 |  | Savers Endcap FSC Prints  job #'s 245265 245260 245253 | 1769 | Yes | 315 | [NAME]
FabriVue | 26.4 | 2024-02-22 00:00:00 | 2024-03-12 00:00:00 |  | 245356 |  | Blast Media March All Gender Run Campaign +245360 | 185 | Yes | 92 | [NAME]
[NAME] | 8.57 | 2024-02-23 00:00:00 | 2024-03-01 00:00:00 |  | HHGJ 197 |  |  | 1394 | Yes | 101 | [NAME] | NOT AWARDED TO GSP
FabriVue | 10.16 | 2024-02-26 00:00:00 | 2024-03-06 00:00:00 |  | HHGJ 127 |  | E03059601 JD Nike Classics | 535 | Yes | 217 | [NAME]
FabriVue | 1.29 | 2024-02-26 00:00:00 | 2024-03-07 00:00:00 |  |  |  | E03075080- FNL x Crocs SON Wall Graphics | 109 | Yes | 40 | [NAME]
[NAME] |  | 2024-02-27 00:00:00 | 2024-03-13 00:00:00 |  | 244792 |  | C990406 Prepaid 3.21 | 12910 | Yes | ? | [NAME] | [NAME]
FabriVue | 0.89 | 2024-02-28 00:00:00 | 2024-03-07 00:00:00 |  | HHGJ 205 |  | E03073968 JD Crocs Classics Echo | 128 | Yes | 55 | [NAME]
FabriVue | 0.25 | 2024-02-28 00:00:00 | 2024-03-08 00:00:00 |  | HHGJ 158 |  | E03067688 | 127 | Yes | 127 | [NAME]
[NAME] | 6.24 | 2024-02-29 00:00:00 | 2024-03-11 00:00:00 |  | HHGJ 198 |  | E03071491 Macy's 3.1.2 | 683 | Yes | 167 | [NAME]
FabriVue | 28 | 2024-02-29 00:00:00 | 2024-03-15 00:00:00 |  | HHGJ 129 |  | E03066090 Macy's Evergreen Refresh | 1268 | Yes | 107 | [NAME] | [NAME]
FabriVue | 0.89 | 2024-03-01 00:00:00 | 2024-03-18 00:00:00 |  | HHGJ |  | E03071659-  NB Festival Pack | 78 | Yes | 37 | [NAME]
[NAME] |  | 2024-03-07 00:00:00 | 2024-03-15 00:00:00 |  | TMOBILE |  | HHG T-Mobile Apple NPI TEST | 15013 | Yes | ? | [NAME] | Celtic+Samba+Styrene+ [NAME] [NAME]
[NAME] | 1.13 | 2024-03-11 00:00:00 | 2024-03-26 00:00:00 |  | HHGJ 202 |  | E03083035 Macy's Birkenstock V6 Core Wall Call Out | 152 | Yes | 33 | [NAME]
[NAME] | 4.34 | 2024-03-11 00:00:00 | 2024-03-27 00:00:00 |  | HHGJ 201 |  | E03078010 Macy's Mens Nike Air Evergreen Son Shops | 728 | Yes | 107 | [NAME]
FabriVue | 24.31 | 2024-03-11 00:00:00 | 2024-04-01 00:00:00 |  | HHGJ 196 |  | E03073641 JD Nike Air Max | 716 | Yes | 217 | [NAME]
FabriVue |  | 2024-03-15 00:00:00 | 2024-03-22 00:00:00 |  | 245901 |  | [NAME] | 605 | Yes | 55 | [NAME]
FabriVue | 16.67 | 2024-03-15 00:00:00 | 2024-03-25 00:00:00 |  | HHGJ |  | E03092536- adidas Always On Terrace Culture | 1447 | Yes | 218 | [NAME]
[NAME] | 1.37 | 2024-03-15 00:00:00 | 2024-03-26 00:00:00 |  | HHGJ 199 |  | E03078012 Macy's Nike Air Evergreen Refresh - V6 Shops | 223 | Yes | 173 | [NAME]
FabriVue | 0.94 | 2024-03-18 00:00:00 | 2024-03-22 00:00:00 |  | HHGJ 170 |  | E03067673- Macy's 3.1.24 [NAME] | 139 | Yes | 99 | [NAME]
3R | 0.72 | 2024-03-18 00:00:00 | 2024-03-25 00:00:00 |  | TMOBILE |  | HHG TMO Timing 3.14 Inventory Reprint.xlsx | 11 | Yes | 1 | [NAME]
FabriVue | 38.49 | 2024-03-19 00:00:00 | 2024-04-18 00:00:00 |  | 246177 |  | Caleres | 4370 | Yes | 4370 | [NAME] | Tiki
[NAME] | 4.81 | 2024-03-20 00:00:00 | 2024-03-27 00:00:00 |  | HHGJ 225 |  | E03087982 [NAME] Spring Always on.xlsx | 459 | Yes | 139 | [NAME] | date moving
FabriVue | 2.26 | 2024-03-21 00:00:00 | 2024-03-27 00:00:00 |  | HHGJ 237 |  | E03085455- Nike Need It Now APRIL | 63 | Yes | 68 | [NAME] | New ship date 4/2/24
FabriVue | 9.96 | 2024-03-25 00:00:00 | 2024-04-10 00:00:00 |  | HHGJ 232 |  | [NAME] Need it NOW April.xlsx | 442 | Yes | 146 | [NAME]
FabriVue | 1.18 | 2024-03-26 00:00:00 | 2024-04-09 00:00:00 |  | HHGJ 249 |  | HHGJ 249 -E03100115 JD New Era 1H.xlsx | 157 | Yes | 146 | [NAME]
FabriVue | 15.41 | 2024-03-27 00:00:00 | 2024-04-09 00:00:00 |  | [NAME] |  | [NAME] 3311 | 2228 | Yes | 265
FabriVue | 10.72 | 2024-03-27 00:00:00 | 2024-04-17 00:00:00 |  | HHGJ 271 |  | E03082789- [NAME] Badge of Sports.xlsx | 1195 | Yes |  | [NAME] | Ship Date moved per Mark L & Breezi 4/9/24- Need art 4/10
[NAME] | 4.9 | 2024-03-27 00:00:00 | 2024-04-17 00:00:00 |  | HHGJ 271 |  | E03082789- [NAME] Badge of Sports.xlsx | 219 | Yes | 219 | [NAME] | Ship Date moved per Mark L & Breezi 4/9/24- Need art 4/10
FabriVue | 8 | 2024-03-27 00:00:00 | 2024-04-23 00:00:00 |  | 246183 |  | Caleres | 498 | Yes | 125 | [NAME]
[NAME] | 8.06 | 2024-03-28 00:00:00 | 2024-04-18 00:00:00 |  | HHGJ 272 |  | E03081809 [NAME] | 5436 | Yes |  | [NAME] | Ship Date moved per Mark L & Breezi 4/9/24- Need art 4/10
FabriVue | 27.55 | 2024-03-28 00:00:00 | 2024-04-18 00:00:00 |  | HHGJ 272 |  | E03081809 [NAME] | 3123 | Yes | 219 | [NAME] | Ship Date moved per Mark L & Breezi 4/9/24- Need art 4/10
FabriVue | 3.33 | 2024-03-29 00:00:00 | 2024-04-05 00:00:00 |  | HHGJ 273 |  | HHG [NAME] | 68 | Yes | 32 | [NAME]
FabriVue | 3.3 | 2024-03-30 00:00:00 | 2024-04-04 00:00:00 |  | 246465 |  | Fogarty Services | 76 | No |  | [NAME]
Indigo | 6.25 | 2024-04-01 00:00:00 | 2024-04-10 00:00:00 |  | 246457 |  | C765390 Prepaid Fast Follow Inserts 4.4_TMOBILE.xlsx | 7753 | Yes | ? | [NAME] | IN FF
FabriVue | 0.23 | 2024-04-02 00:00:00 | 2024-04-04 00:00:00 |  | HHGJ 274 |  |  | 15 | Yes | ? | [NAME]
[NAME] | 2.89 | 2024-04-02 00:00:00 | 2024-04-05 00:00:00 |  | HHGJ 239 |  |  | 34 | Yes | ? | [NAME]
[NAME] | 2.08 | 2024-04-02 00:00:00 | 2024-04-08 00:00:00 |  | HHGJ 202 |  | E03066090-2 Macy's FY24 SON Nike Evergreen Marketing Refresh.xlsx | 103 | Yes | 1 | [NAME]
FabriVue | 1.35 | 2024-04-02 00:00:00 | 2024-04-09 00:00:00 |  | HHGJ 253 |  | 111050- E03096132-JD x Juicy FLG & BOC.xlsx | 108 | Yes | 51 | [NAME]
FabriVue | 7.7 | 2024-04-02 00:00:00 | 2024-04-11 00:00:00 |  | HHGJ |  | E03098042- [NAME] x Hoodrich Q2.xlsx | 874 | Yes | 216 | [NAME]
FabriVue | 0.29 | 2024-04-04 00:00:00 | 2024-04-08 00:00:00 |  | HHGJ 218 |  | E03087980 Macy's 4.1.24 Retail [NAME] SON HSQ.xlsx | 2 | Yes | 1 | [NAME]
FabriVue |  | 2024-04-05 00:00:00 | 2024-04-08 00:00:00 |  | 245662 |  | CRMX 245662 [8] | 265 | Yes | 253 | [NAME] | In Shipping
FabriVue | 13.93 | 2024-04-05 00:00:00 | 2024-04-09 00:00:00 |  | 245662 |  | SESY 245662 [9] | 2145 | Yes | 195 | [NAME]
FabriVue | 0.34 | 2024-04-05 00:00:00 | 2024-04-11 00:00:00 |  | HHGJ 275 |  | E03079504- [NAME] New Balance 1906 AZ.xlsx | 2 | Yes | 1 | [NAME]
[NAME] | 0.81 | 2024-04-05 00:00:00 | 2024-04-11 00:00:00 |  | HHGJ 275 |  | E03079504- [NAME] New Balance 1906 AZ.xlsx | 8 | Yes | 1 | [NAME]
[NAME] | 0.46 | 2024-04-09 00:00:00 | 2024-04-12 00:00:00 |  | HHGJ 297 |  | E03110783 Macy's SON [NAME] of Sock BOGO Gondola Header.xlsx | 200 | Yes | 1 | [NAME]
 |  |  | 2024-04-12 00:00:00 |  | 242679 |  | [NAME] | 150 |  |  |  | [NAME]
 |  |  | 2024-04-19 00:00:00 |  | 245630 |  | [NAME] |  |  |  |  | [NAME] job details in Pace
 |  |  | 2024-05-09 00:00:00 |  | 244473 |  | [NAME] |  |  |  |  | Amanda N.- Hardware Ticket
FabriVue | 0.1 | 2024-04-10 00:00:00 | 2024-04-12 00:00:00 |  | HHGJ 211 |  | E03087968 Macy's 3.1.24 [NAME] SON 4 x 9.5 HSQ.xlsx | 2 | Yes | 2 | [NAME] | Possibly ship 4/11 if art hits floor 4/10 early .
[NAME] | 0.28 | 2024-04-10 00:00:00 | 2024-04-17 00:00:00 |  | HHGJ 295 |  | [NAME] Bonus.xlsx | 8 | Yes | 4 | [NAME]
FabriVue | 3.29 | 2024-04-10 00:00:00 | 2024-04-17 00:00:00 |  | HHGJ 282 |  | E03094459 [NAME] | 429 | Yes | 146 | [NAME]
FabriVue | 3.37 | 2024-04-10 00:00:00 | 2024-04-19 00:00:00 |  | HHGJ 305 |  | E03086138 JD BOC Asics As Seen in March | 302 | Yes | 156 | [NAME] | Ship date moved- art date missed- AN 4/11/24
FabriVue | 12.49 | 2024-04-10 00:00:00 | 2024-04-25 00:00:00 |  | 246738 |  | BLAST MEDIA | 182 | Yes |  | [NAME] | & 246740
FabriVue | 3.29 | 2024-04-11 00:00:00 | 2024-04-18 00:00:00 |  | HHGJ 282 |  | E03094459- [NAME] x TNF 0426 APRIL.xlsx | 429 | Yes | 146 | [NAME]
[NAME] | 0.8 | 2024-04-11 00:00:00 | 2024-04-25 00:00:00 |  | HHGJ 309 |  | E03093298- VM Daily SZN Marketing.xlsx | 150 | Yes | 1 | [NAME]
FabriVue | 0.77 | 2024-04-11 00:00:00 | 2024-04-25 00:00:00 |  | HHGJ 309 |  | E03093298- VM Daily SZN Marketing.xlsx | 100 | Yes | 1 | [NAME]
FabriVue | 7.24 | 2024-04-12 00:00:00 | 2024-04-18 00:00:00 |  | 246279 |  | NAC 246279 [18] | 457 | Yes | 419 | [NAME]
FabriVue | 2.66 | 2024-04-12 00:00:00 | 2024-04-19 00:00:00 |  | HHGJ 178 |  | E03059762 [NAME] | 34 | Yes | 15 | [NAME] | New timeline on 4/11/24- AN- Ship Date moved from 4/17
FabriVue | 2.33 | 2024-04-12 00:00:00 | 2024-04-23 00:00:00 |  | HHGJ 241 |  | E03095485 FNL TNG April.xlsx | 50 | Yes | 35 | [NAME] | Changed timeline from 4/1 art to 4/12 with 4/23 ship from 4/17
FabriVue | 7.11 | 2024-04-12 00:00:00 | 2024-05-10 00:00:00 |  | PACE #?? |  | DXL Group | 102 | Yes | ?? | [NAME]
FabriVue | 4.29 | 2024-04-18 00:00:00 | 2024-05-01 00:00:00 |  | HHGJ |  | E03093301- [NAME] x 0513 MAY ON Evergreen.xlsx | 394 | Yes | 158 | [NAME] | Last day for 5/1 ship (4/18/24)
[NAME] | 49.64 | 2024-04-19 00:00:00 | 2024-05-01 00:00:00 |  | TMOBILE |  | C546580 HSI Q2 2024 Refresh 4.25.xlsx | 3067 | Yes | 2242 | [NAME] | **Dates updated by [NAME] on 4/5 AN**-  Updated QTY's per Lisa's email- AN.
[NAME] | 31.42 | 2024-04-19 00:00:00 | 2024-05-01 00:00:00 |  | TMOBILE |  | C214610 TFB Refresh LM_T-MOBILE.xlsx | 985 | Yes |  | [NAME] | Refresh LS to Refresh LM
[NAME] | 2.66 | 2024-04-19 00:00:00 | 2024-05-02 00:00:00 |  | TMOBILE |  | Pre-lim TFB Refresh H1 2024 RFP - 425_TMO | 248 | Yes |  | [NAME]
[NAME] | 16.56 | 2024-04-19 00:00:00 | 2024-05-02 00:00:00 |  | TMOBILE |  | C214610 TFB Refresh LS_T-MOBILE.xlsx | 985 | Yes | ? | [NAME]
FabriVue | 8.77 | 2024-04-22 00:00:00 | 2024-05-17 00:00:00 |  | NAC |  | North American Corporation | 573 | Yes |  | [NAME]
[NAME] | 0.77 | 2024-04-25 00:00:00 | 2024-05-01 00:00:00 |  | TMOBILE |  | C635866 | 6 | Yes | ? | [NAME]
[NAME] | 40.32 | 2024-04-30 00:00:00 | 2024-05-08 00:00:00 |  | TMOBILE |  | DARK_Apple Spring NPI 2024- C280525 | 4415 | Yes | ? | [NAME] | Job is a go
[NAME] | 14.9 | 2024-04-30 00:00:00 | 2024-05-08 00:00:00 |  | TMOBILE |  | Prelim Apple Spring NPI 2024 Offer- C280525 | 702 | Yes | ? | [NAME] | Job is a go
[NAME] | 0.9 | 2024-05-01 00:00:00 | 2024-05-08 00:00:00 |  | TMOBILE |  | C511411 [NAME] | 557 | Yes | ? | [NAME]
[NAME] | 14.9 | 2024-05-03 00:00:00 | 2024-05-08 00:00:00 |  | TMOBILE |  | Prelim Apple Spring NPI 2024  Evergreen FWs- C280525 | 702 | Yes | ? | [NAME] | May be duplicate job.  See email to [NAME].
[NAME] | 0.83 | 2024-05-09 00:00:00 | 2024-05-13 00:00:00 |  | TMOBILE |  | 111051- Revvl 7 & Revvl 7 Pro_TMOBILE.xlsx | 6 | Yes | ? | [NAME]
[NAME] | 12.62 | 2024-05-14 00:00:00 | 2024-06-11 00:00:00 |  | HHGJ 242 |  | E03073966- JD BOC x BTS '24 Seasonal Changeout.xlsx | 779 | Yes |  | [NAME]
FabriVue | 158.73 | 2024-05-14 00:00:00 | 2024-06-11 00:00:00 |  | HHGJ 242 |  | E03073966- JD BOC x BTS '24 Seasonal Changeout.xlsx | 8421 | Yes | 222 | [NAME]
FabriVue | 55.6 | 2024-06-18 00:00:00 | 2024-07-05 00:00:00 |  | HHGJ |  | PRELIM SCHEDULE JD x BTS adidas HERO.xlsx | 2028 | Yes |  | [NAME]
[NAME] | 1.66 | 2024-06-18 00:00:00 | 2024-07-05 00:00:00 |  | HHGJ |  | PRELIM SCHEDULE JD x BTS adidas HERO.xlsx | 12 | Yes |  | [NAME]
FabriVue | 17.89 |  |  |  | HHGJ 231 |  | E03083060- [NAME] [NAME] for SG.xlsx | 1980 | Yes |  | [NAME] | 12 days to produce and 2 days to pack and ship
[NAME] | 13.11 |  |  |  | HHGJ 231 |  | E03083060- [NAME] [NAME] for SG.xlsx | 7740 | Yes |  | [NAME] | 12 days to produce and 2 days to pack and ship