Spreadsheet: 875897d1722520605-help-adding-data-to-formula-result-ojr-formula-08012024
Sheet: OJR DATA

Order #/ Name | PLANT | Monthly | Ship | Due | Stores/ Signs | Write-ups/ Changes | Special Production Items | [NAME] | Stores | Signs | Days to Kit
BASS   177 - 36x72 promo frame #001 | K | N | 45503 | 45506 | 1/ 1 |  | 1 Resale/Spec. Order (0 recv'd) | UPGRADE | 1 | 1 | 0.002222222222222222
CKFL 98283- BEER BREEZER WRAP | U | N | 45503 | 45504 | 14/ 120 | 1 in Sched. | 1 ROUTER CUT | 7 shipped | 14 | 120 | #N/A
CKRE  2947- RE FREEZER FUR DOWN EXTENTION 2704164 | U | N | 45503 | 45506 | 1/ 2 |  |  | UPGRADE | 1 | 2 | #N/A
DASH  1297- RE NB DASH #1464 Resale | M | N | 45503 | 45506 | To Inv./ 2 | 2 in Sched. | 2 RESALE  MGNT TP FRNT | To Inv. | 1 | 2 | #N/A
GGPM 26187- Tobacco Number Sheets to INV | K | N | 45503 | 45511 | To Inv./ 5200 | 3 in Sched. | 2 Die-cut 1 ROUTER CUT | To Inv. | 1 | 5200 | 0.002857142857142857
HENN  1137 (ships w/ HENN  1136) - 6010 24 SPEC - US0100 Installation | M | N | 45503 | 45519 | 1/ 1 |  |  | SHIP | 1 | 1
HHGJ   557 - **REUSE THIS ORDER** | K | N | 45503 | 45506 | 1/ 10 |  |  | UPGRADE | 1 | 10 | 0.00303030303030303
LLBE  5334 (ships w/ LLBE  5333)   - VM #1640 Indianapolis, IN - Phase II | M | N | 45503 | 45510 | 1/ 18 |  |  | SHIP | 1 | 18
LLBE  5335 (ships w/ LLBE  5333)   - #1640 Indianapolis, IN - Footwear Uppers | M | N | 45503 | 45510 | 1/ 6 |  |  | SHIP | 1 | 6
LLBE  5336 (ships w/ LLBE  5333)   - VM #1640 Indianapolis, IN - Phase II Installation | M | N | 45503 | 45567 | 1/ 2 |  |  | SHIP | 1 | 2
RACT 11259- INV FANCY CANDY POP | K | N | 45503 | 45509 | To Inv./ 568 | 8 in Sched. | 8 Lamination 8 ROUTER CUT | To Inv. | 1 | 568 | 0.004
TOFA   229  - RS 6.99 Pasta Buttons | K | N | 45503 | 45509 | To Inv./ 3395 | 1 in Sched. | 1 Resale/Spec. Order (1 recv'd) | To Inv. | 1 | 3395 | 0.004
QUIC 11720 (ships w/ QUIC 11723)  - Mobile Rewards Stickers/Buttons | M | N | 45504 | 45508 | To Inv./ 910 |  |  | To Inv. | 1 | 910
CASY110626 (ships w/ CASY110824-)NM July 2024 Magnetic Build Guide Insert Test | M | N | 45504 | 45505 | 1/ 24 | 4 in Sched. |  | UPGRADE | 1 | 24
CKRE  2480- OPEN JOB | T | N | 45504 | 45506 | 1/ 1 |  |  | UPGRADE | 1 | 1 | #N/A
CKRE  2528- RE B BULK HORIZON SIGNAGE INV ORDER MAY 24 | U | N | 45504 | 45506 | To Inv./ 6205 |  |  | To Inv. | 1 | 6205 | #N/A
CKRE  2634- NB BULK HORIZON CC RR LETTER SET ORDER | U | N | 45504 | 45506 | To Inv./ 3182 | 33 in Sched. | 1 4CP 4 Lamination 21 ROUTER CUT | To Inv. | 1 | 3182 | #N/A
CKRE  2923- RE NB ACM CKRM PANEL 2741157 | U | N | 45504 | 45510 | 2/ 6 | 5 in Sched. | 4 Lamination 4 ROUTER CUT | SHIP | 2 | 6 | #N/A
CKRE  2940- RE CKMW 4703975 RR Signage | U | N | 45504 | 45513 | 1/ 1 |  |  | SHIP | 1 | 1 | #N/A
GFAC  2442- Archival Update FA24 US | M | N | 45504 | 45509 | 19/ 564 | 98 New Orders 2 Eliminated |  | UPGRADE | 19 | 564 | #N/A
HENN  1131- 6010 24 SPEC - Fabric | M | N | 45504 | 45512 | 4/ 11 | 8 in Sched. | 1 4CP | SHIP | 4 | 11 | #N/A
HUCK   678 - RE NB NTI - OUTSOURCED PRODUCTION | M | N | 45504 | 45509 | To Inv./ 15 |  |  | To Inv. | 1 | 15 | #N/A
KCHK  1296- RS Counter Mats | U | N | 45504 | 45509 | To Inv./ 200 |  |  | To Inv. | 1 | 200 | #N/A
KCHK  1314- CAR WASH UPDATE | U | N | 45504 | 45509 | 10/ 143 |  |  | UPGRADE | 10 | 143 | #N/A
QUIC 15069 - CANCELLED REUSE | M | N | 45504 | 45508 | To Inv./ 15 |  |  | To Inv. | 1 | 15 | #N/A
TOFA   199  - HR Recruiting Material Print Inventory (RTP) | K | N | 45504 | 45506 | To Inv./ 230 | 8 in Sched. | 3 Lamination | To Inv. | 1 | 230 | 0.004
BASS   174 - BP241572517 MENS 602 RH LS POCKET CREW | K | N | 45505 | 45511 | 157/ 1559 | 8 in Sched. |  | SHIP | 157 | 1559 | 0.3488888888888889
CASY110824- NM RS July 2024 Magnetic Build Guide Holders | M | N | 45505 | 45512 | 1/ 24 | 1 in Sched. | 1 Resale/Spec. Order (1 recv'd) 1 RESALE  MGNT TP FRNT | SHIP | 1 | 24 | 0.0025
CKRE   747 - RE CKRM Horizon Remodel 2709904 Highlands Rnch, CO | T | N | 45505 | 45510 | 1/ 2 |  |  | SHIP | 1 | 2 | #N/A
CKRE  2689- RE CKGC STORE # 2723828 RED COMM BOARD & TRIM | T | N | 45505 | 45510 | 1/ 1 |  |  | SHIP | 1 | 1 | #N/A
CKRE  2902- RE NB BULK CKRM NTSY HANGING SIGN PRODUCTION | M | N | 45505 | 45510 | To Inv./ 10 | 2 in Sched. | 1 ROUTER CUT | To Inv. | 1 | 10 | #N/A
CKRE  2955- NB RE CKGC ACM Graphic 2721584 | U | N | 45505 | 45509 | 2/ 7 | 7 in Sched. | 6 Lamination 6 ROUTER CUT | UPGRADE | 2 | 7 | #N/A
CROC  5005- [NAME] | M | N | 45505 | 45512 | 3/ 5 | 2 in Sched. | 1 4CP 1 ROUTER CUT | SHIP | 3 | 5 | #N/A
CROS   288 - RE NB CROS #43 IN-HOUSE (bill 287) | M | N | 45505 | 45510 | 1/ 6 | 5 in Sched. | 2 Lamination | SHIP | 1 | 6 | #N/A
CROS   290 (ships w/ CROS   288)   - NB CROS #43 FROM INVENTORY (bill 287) | M | N | 45505 | 45510 | 1/ 6 | From inventory |  | SHIP | 1 | 6
GRET  2780 - NB Soho 5002 Accessory Images FA24 HR | M | N | 45505 | 45506 | 1/ 10 | 6 in Sched. |  | UPGRADE | 1 | 10 | #N/A
GRET  2781 - NB Fall 24 Riser Cover Samples Round 2 HR | M | N | 45505 | 45506 | 1/ 6 | 9 in Sched. | 9 ROUTER CUT | UPGRADE | 1 | 6 | #N/A
HHGJ   563 - E03152874 HR JD SPORTS 1290 | K | N | 45505 | 45506 | 1/ 1 | 1 in Sched. |  | UPGRADE | 1 | 1 | 0.00303030303030303
KRKR  1159- NB - Promo 2 2024 UTAH Inv Replen FINAL | U | N | 45505 | 45506 | To Inv./ 1904 | 10 in Sched. | 1 4CP 4 ROUTER CUT | To Inv. | 1 | 1904 | #N/A
RACT 10880- M Flyers FR Inv Direct to Stores | K | N | 45505 | 45510 | 20/ 400 LOW$ | From inventory |  | SHIP | 20 | 400 | 0.08
UPAC 24290- NM Top Shelf Hardware Order | U | N | 45505 | 45509 | To Inv./ 2107 | 9 in Sched. | 12 Resale/Spec. Order (0 recv'd) | To Inv. | 1 | 2107 | #N/A
WEIG   214  - Store 112 items | M | N | 45505 | 45510 | 1/ 4 | 3 in Sched. | 2 ROUTER CUT | SHIP | 1 | 4 | #N/A
BASS     2   - BP21433239-7 Reprint 2021 FEEDBACK SIGNAGE | K | N | 45506 | 45509 | 1/ 2 | 1 in Sched. |  | UPGRADE | 1 | 2 | 0.002222222222222222
CASY111238- NB NM July 24 FFE Header 24pt Samples | M | N | 45506 | 45511 | 1/ 5 | 1 in Sched. |  | SHIP | 1 | 5 | 0.0025
CKNF 14269- Non FFF Translites - C7 | U | N | 45506 | 45513 | 1/ 22 | 3 in Sched. |  | SHIP | 1 | 22 | #N/A
CKRE  2920- NB INV CKMW Welcome & Beverage Sign | U | N | 45506 | 45511 | To Inv./ 92 | 1 Eliminated 2 not apprvd 8 in Sched. | 3 Lamination 8 ROUTER CUT | To Inv. | 1 | 92 | #N/A
CKRE  2930- RE NB ACM PANEL CKMW 4703959_CKRM 2709904 | U | N | 45506 | 45512 | 3/ 4 | 4 in Sched. | 3 Lamination 3 ROUTER CUT | SHIP | 3 | 4 | #N/A
CKRE  2981- RE CKCC 2723868 Coffee Panel Replacement | U | N | 45506 | 45511 | 1/ 1 |  |  | SHIP | 1 | 1 | #N/A
DODG  7474- NB From INV Menu Updates | M | N | 45506 | 45512 | 2/ 3 LOW$ | From inventory |  | SHIP | 2 | 3 | #N/A
GFAC  2474- NB 3118 Woodbury LB Graphic | M | N | 45506 | 45520 | 1/ 2 | 2 in Sched. |  | SHIP | 1 | 2 | #N/A
GGPM 26317- NB P3.2 Reprints part 3 | K | N | 45506 | 45511 | 2/ 3 | 2 in Sched. |  | SHIP | 2 | 3 | 0.005714285714285714
HHGJ   559 - E03146325 [NAME] and Flagships x Birken | K | N | 45506 | 45511 | 61/ 284 | 12 in Sched. | 4 ROUTER CUT 4 SPECIAL TAPE | SHIP | 61 | 284 | 0.1848484848484848
HUCK   665 - Huck's CELEBRATING 50 YEARS of FRESH FAST FRIENDLY | M | N | 45506 | 45511 | 128/ 147 | 1 in Sched. |  | SHIP | 128 | 147 | #N/A
[NAME]  1341 - Dry Erase Boards 2024 Refresh to INV | M | N | 45506 | 45544 | To Inv./ 75 | 1 in Sched. | 1 Lamination 1 ROUTER CUT | To Inv. | 1 | 75 | #N/A
LLBE  5386 - HR Store Requests - Ulster | M | N | 45506 | 45512 | 1/ 8 | 8 in Sched. | 8 ROUTER CUT | SHIP | 1 | 8 | 0.004
LLBE  5387 - Store Requests 7.15.2024 - Small Format | M | N | 45506 | 45512 | 1/ 6 | 3 in Sched. | 2 Resale/Spec. Order (2 recv'd) 2 4CP 3 RESALE  MGNT TP FRNT | SHIP | 1 | 6 | 0.004
NBD    736   - RE NB DMG - Store 3776 from inventory | M | N | 45506 | 45511 | 1/ 47 LOW$ | From inventory |  | SHIP | 1 | 47 | #N/A
QUIC 17467 (ships w/ QUIC 17469)  - SP4 2024 Midkit | M | N | 45506 | 45510 | 156/ 774 | 3 in Sched. |  | <!>UPGRADE | 156 | 774
QUIC 17469 - SP4 Breakfast Bundle | M | Y | 45506 | 45511 | 156/ 721 | 8 in Sched. |  | SHIP | 156 | 721 | #N/A
TOFA   218  - Blank Channel Strips (RTP) | K | N | 45506 | 45509 | To Inv./ 3750 | 1 in Sched. | 1 4CP 1 ROUTER CUT | To Inv. | 1 | 3750 | 0.004
[NAME]  3474 - NB BTS GWP 2024 AUG 9 | K | N | 45509 | 45513 | 18/ 36 | 1 in Sched. |  | SHIP | 18 | 36 | 0.072
BASS    98  - BP241538928 LADIES ACID WASH PLAID DENIM SHIRT | K | N | 45509 | 45512 | 158/ 348 LOW$ |  |  | SHIP | 158 | 348 | 0.3511111111111111
BASS   127 - BP241543640 LADIES 664 | K | N | 45509 | 45512 | 134/ 270 | 4 in Sched. | 1 ROUTER CUT | SHIP | 134 | 270 | 0.2977777777777778
BASS   128 - BP241538218 LADIES 652 NR CC FLANNEL SHIRT | K | N | 45509 | 45512 | 157/ 613 | 8 in Sched. |  | SHIP | 157 | 613 | 0.3488888888888889
BASS   164 - BP241572607 MENS 602 RH OZARK MTN FLANNEL | K | N | 45509 | 45512 | 157/ 356 |  |  | SHIP | 157 | 356 | 0.3488888888888889
CALS  7580 - NB HR Missing Signage 7005 | K | N | 45509 | 45510 | 1/ 13 | 5 in Sched. | 1 Lamination 4 ROUTER CUT | UPGRADE | 1 | 13 | 0.005
CALS  7581 - NB HR Missing Signage 7006 | K | N | 45509 | 45510 | 1/ 16 | 8 in Sched. 3 not ganged | 1 Die-cut 1 Lamination 4 ROUTER CUT | UPGRADE | 1 | 16 | 0.005
CASY111116- NM Aug 2024 Inventory Replenishment 1 | M | N | 45509 | 45511 | To Inv./ 1035 | 10 in Sched. | 2 Lamination 2 ROUTER CUT | To Inv. | 1 | 1035 | 0.0025
CKCL    37  - NTI MARANA PUMPSIDER | U | N | 45509 | 45512 | 5/ 30 |  |  | SHIP | 5 | 30 | #N/A
CKFL 98285- CKFL REMODEL STORES ORDER | U | N | 45509 | 45516 | 60/ 3242 | 47 in Sched. | 6 ROUTER CUT | SHIP | 60 | 3242 | #N/A
CKRE  2956- RE CKCC F'real Medium LED 2709205 | T | N | 45509 | 45512 | 1/ 1 |  |  | SHIP | 1 | 1 | #N/A
CKRE  2972- RE [NAME] On 2721578 Bay Minette AL | T | N | 45509 | 45513 | 1/ 1 |  |  | SHIP | 1 | 1 | #N/A
CROC  5007- Inventory Requests 7.23 | M | N | 45509 | 45510 | To Inv./ 10 | 2 in Sched. | 1 Resale/Spec. Order (0 recv'd) | To Inv. | 1 | 10 | #N/A
CROS   292 - RE CROS #58 IN-HOUSE (bill 291) | M | N | 45509 | 45512 | 1/ 7 | 2 not apprvd 7 in Sched. | 6 Lamination 1 ROUTER CUT | SHIP | 1 | 7 | #N/A
CROS   294 (ships w/ CROS   292)   - nb CROS #58 FROM INVENTORY (bill 291) | M | N | 45509 | 45512 | 1/ 15 | From inventory |  | SHIP | 1 | 15
CRSS  1265 - Car Wash OH VA WV TN PA | M | N | 45509 | 45513 | 11/ 271 | 36 in Sched. | 9 Lamination 11 ROUTER CUT | SHIP | 11 | 271 | #N/A
DODG  7463- RE VM Store 6506 Ripley | M | N | 45509 | 45513 | 1/ 1 | 1 in Sched. |  | SHIP | 1 | 1 | #N/A
GGPM 26192- NB P3.2 Reprints Part 2 | K | N | 45509 | 45513 | 16/ 105 | 40 in Sched. | 17 Die-cut 1 Lamination 3 ROUTER CUT | SHIP | 16 | 105 | 0.04571428571428571
GGPM 26305- P3 Reprint Snack Zone 5611 | K | N | 45509 | 45512 | 1/ 13 | 13 in Sched. | 13 Die-cut | SHIP | 1 | 13 | 0.002857142857142857
GWHO   692- Fall 24 Campaign | M | N | 45509 | 45516 | 104/ 363 | 138 in Sched. | 2 Resale/Spec. Order (2 recv'd) 8 Lamination 7 ROUTER CUT | SHIP | 104 | 363 | #N/A
GWHO   695- Fall Canada 24 Montreal Showroom #1 | M | N | 45509 | 45516 | 1/ 28 | 15 in Sched. | 5 ROUTER CUT | SHIP | 1 | 28 | #N/A
GWHO   696- Fall Canada 24 Toronto Showroom #2 | M | N | 45509 | 45516 | 1/ 14 | 9 in Sched. |  | SHIP | 1 | 14 | #N/A
GWHO   698- Fall Canada 24 The Bay #4 | M | N | 45509 | 45516 | 10/ 68 | 36 in Sched. | 1 ROUTER CUT | SHIP | 10 | 68 | #N/A
GWHO   699- Fall Canada 24 Clusters #5 | M | N | 45509 | 45516 | 3/ 302 | 10 in Sched. | 1 4CP | SHIP | 3 | 302 | #N/A
HENN  1136- 6010 24 SPEC - US0100 Graphics | M | N | 45509 | 45513 | 1/ 6 | 11 in Sched. | 1 4CP 10 Lamination | SHIP | 1 | 6 | #N/A
KCHK  1282- VM [NAME] | U | N | 45509 | 45511 | To Inv./ 600 |  |  | To Inv. | 1 | 600 | #N/A
RACT 10477- INV Back Orders July 24 | K | N | 45509 | 45511 | To Inv./ 1249 | 24 in Sched. | 4 Die-cut 6 Lamination 12 ROUTER CUT | To Inv. | 1 | 1249 | 0.004
RACT 10860- Tobacco Reprints | K | N | 45509 | 45513 | To Inv./ 153 | 3 in Sched. |  | To Inv. | 1 | 153 | 0.004
THOR 52612- Inventory Replenishment - | M | N | 45509 | 45510 | To Inv./ 515 | 20 in Sched. | 18 Die-cut | To Inv. | 1 | 515 | #N/A
THOR 52620- Inventory Replenishment - Alcohol (PO 329956) | M | N | 45509 | 45510 | To Inv./ 22 | 2 in Sched. |  | To Inv. | 1 | 22 | #N/A
THOR 52621- Inventory Replenishment - Candy (PO 329957) | M | N | 45509 | 45510 | 1/ 11 | 1 in Sched. |  | UPGRADE | 1 | 11 | #N/A
THOR 52623- Inventory Replenishment - Fuel (PO 329961) | M | N | 45509 | 45510 | To Inv./ 26 | 1 in Sched. |  | To Inv. | 1 | 26 | #N/A
TOFA   281  - RS Hardware for Sept-Oct Monthly Kit | K | N | 45509 | 45511 | To Inv./ 19447 | 3 in Sched. | 3 Resale/Spec. Order (0 recv'd) 1 4CP | To Inv. | 1 | 19447 | 0.004
UPAC 25354- VM Bollard Frame Inventory | U | N | 45509 | 45512 | To Inv./ 50 | 1 in Sched. |  | To Inv. | 1 | 50 | #N/A