Spreadsheet: 60332d1260892697-nested-if-statements-inventory-segmentation
Sheet: Sheet1

Field1 | Field2 | Field3 | Field4 | Field5 | EOQ Group | Family | Sub-Family | Format Type | Format Sub-Type | [NAME] | CBU SKU | ED_SKU | Price Marked | SKU w/o leading zeroes | PAV Ind | SKU Description | [NAME] | SKU Alpha First Letter | Sending Situation | Captions | Design Theme | Metrics | GP Wholesale Shipments | [NAME] | Discards | Royalties | Season Returns | Evday Rtns & Obs | New GMb4T calc | GM% | COSV | Total Inventory | [NAME] | ED Variability_SKU | TOT WKLY SLS | USP | [NAME] | [NAME] | RTLSHP_50 | RTLSHP_49 | RTLSHP_48 | RTLSHP_47 | [NAME] | RTLSHP_45 | RTLSHP_44 | RTLSHP_43 | RTLSHP_42 | RTLSHP_41 | RTLSHP_40 | RTLSHP_39 | RTLSHP_38 | RTLSHP_37 | [NAME] | RTLSHP_35 | [NAME] | RTLSHP_33 | RTLSHP_32 | RTLSHP_31 | [NAME] | RTLSHP_29 | RTLSHP_28 | RTLSHP_27 | RTLSHP_26 | RTLSHP_25 | RTLSHP_24 | RTLSHP_23 | RTLSHP_22 | [NAME] | RTLSHP_20 | RTLSHP_19 | RTLSHP_18 | RTLSHP_17 | RTLSHP_16 | RTLSHP_15 | RTLSHP_14 | [NAME] | RTLSHP_12 | RTLSHP_11 | RTLSHP_10 | RTLSHP_09 | RTLSHP_08 | RTLSHP_07 | RTLSHP_06 | RTLSHP_05 | RTLSHP_04 | RTLSHP_03 | [NAME] | RTLSHP_01 | Tot Units | UIV | STDEV | GMROI | ICR | [NAME] | STDEVLT | PO/MR$ | SL | EOQ | LTD | Wk Demand | S Factor | SS | AIOH | AIOHV | AIOHD | ROP | WBD | STDDEV% | EOQ Group | Family | Sub-Family | Format Type | Format Sub-Type | [NAME] | CBU SKU | ED_SKU | Price Marked | SKU w/o leading zeroes | PAV Ind | SKU Description | [NAME] | SKU Alpha First Letter | Sending Situation | Captions | Design Theme | Metrics | GP Wholesale Shipments | [NAME] | Discards | Royalties | Season Returns | Evday Rtns & Obs | New GMb4T calc | GM% | COSV | Total Inventory | [NAME] | ED Variability_SKU | TOT WKLY SLS | USP | [NAME] | [NAME] | RTLSHP_50 | RTLSHP_49 | RTLSHP_48 | RTLSHP_47 | [NAME] | RTLSHP_45 | RTLSHP_44 | RTLSHP_43 | RTLSHP_42 | RTLSHP_41 | RTLSHP_40 | RTLSHP_39 | RTLSHP_38 | RTLSHP_37 | [NAME] | RTLSHP_35 | [NAME] | RTLSHP_33 | RTLSHP_32 | RTLSHP_31 | [NAME] | RTLSHP_29 | RTLSHP_28 | RTLSHP_27 | RTLSHP_26 | RTLSHP_25 | RTLSHP_24 | RTLSHP_23 | RTLSHP_22 | [NAME] | RTLSHP_20 | RTLSHP_19 | RTLSHP_18 | RTLSHP_17 | RTLSHP_16 | RTLSHP_15 | RTLSHP_14 | [NAME] | RTLSHP_12 | RTLSHP_11 | RTLSHP_10 | RTLSHP_09 | RTLSHP_08 | RTLSHP_07 | RTLSHP_06 | RTLSHP_05 | RTLSHP_04 | RTLSHP_03 | [NAME] | RTLSHP_01 | Tot Units | UIV | STDEV | GMROI | ICR | [NAME] | STDEVLT | PO/MR$ | SL | EOQ | LTD | Wk Demand | S Factor | SS | AIOH | AIOHV | AIOHD | ROP | WBD | STDDEV% | LT Buckets
 |  |  |  |  | SYST - CLASS | PARTY EXPRESS | SOLIDS | PARTY GOODS | TABLE COVER | N/A | 0001TAS4640 | 0001TAS4640 | 3.2 |  | N | [NAME] | TAS | T | GENERAL | NOT ASSIGNED | NOT ASSIGNED |  | 11769.6 | 4402.89 | 1662.17 | 0 | 0 | 0 | 7366.71 | 0.625909971451876 | 3121.89 |  | 5425.27 |  |  | 1.6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 708 | 216 | 324 | 420 | 312 | 300 | 336 | 216 | 204 | 108 | 396 | 84 | 468 | 264 | 432 | 396 | 456 | 564 | 612 | 216 | 252 | 72 | 7356 | 0.4244004893964111 | 196.1569683009445 | 0.9627909031656362 | 0.508 | 7 |  | 472 | 0.9 | 5675.276996893389 | 990.2307692307692 | 141.4615384615385 | 1.2815515655446 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 1.386645235406351 | SYST - CLASS | PARTY EXPRESS | SOLIDS | PARTY GOODS | TABLE COVER | N/A | 0001TAS4640 | 0001TAS4640 | 3.2 | 0 | N | [NAME] | TAS | T | GENERAL | NOT ASSIGNED | NOT ASSIGNED |  | 11769.6 | 4402.89 | 1662.17 | 0 | 0 | 0 | 7366.71 | 0.625909971451876 | 3121.89 | 0 | 5425.27 | 0 | 0 | 1.6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 708 | 216 | 324 | 420 | 312 | 300 | 336 | 216 | 204 | 108 | 396 | 84 | 468 | 264 | 432 | 396 | 456 | 564 | 612 | 216 | 252 | 72 | 7356 | 0.4244004893964111 | 196.1569683009445 | 0.9627909031656362 | 0.508 | 7 |  | 273 | 0.98 | 4316.158527888121 | 990.2307692307692 | 141.4615384615385 | 2.05374891063182 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 1.386645235406351 | 7
 |  |  |  |  | SYST - CLASS | PARTY EXPRESS | KIDS | PARTY GOODS | AWARD RIBBON | N/A | 0001FVT2129 | 0001FVT2129 | 3.99 |  | N | [NAME] THMAS CHUG | FVT | F | BIRTHDAY | NOT ASSIGNED | NOT ASSIGNED |  | 17081.19 | 6289.71 | 736.86 | 833.14 | 0 | 13.97 | 10777.51 | 0.6309577962659509 | 4878.29 |  | 646.54 |  |  | 1.995 | 720 | 456 | 564 | 252 | 582 | 570 | 474 | 204 | 384 | 576 | 432 | 1170 | 594 | 408 | 936 | 234 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8556 | 0.5697605699602898 | 281.3076923076923 | 12.90020142182579 | 0.508 | 7 |  | 472 | 0.9 | 5284.398460515221 | 1152.576923076923 | 164.6538461538461 | 1.2815515655446 | 953.8206345331846 | 3596.019864790795 | 2048.870327751727 | -1402.330327751728 | 2106.397557610107 | 12.79288402192544 | 1.708479327259986 | SYST - CLASS | PARTY EXPRESS | KIDS | PARTY GOODS | AWARD RIBBON | N/A | 0001FVT2129 | 0001FVT2129 | 3.99 | 0 | N | [NAME] THMAS CHUG | FVT | F | BIRTHDAY | NOT ASSIGNED | NOT ASSIGNED |  | 17081.19 | 6289.71 | 736.86 | 833.14 | 0 | 13.97 | 10777.51 | 0.6309577962659509 | 4878.29 | 0 | 646.54 | 0 | 0 | 1.995 | 720 | 456 | 564 | 252 | 582 | 570 | 474 | 204 | 384 | 576 | 432 | 1170 | 594 | 408 | 936 | 234 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8556 | 0.5697605699602898 | 281.3076923076923 | 12.90020142182579 | 0.508 | 7 | 0 | 273 | 0.98 | 4018.887799238125 | 1152.576923076923 | 164.6538461538461 | 2.05374891063182 | 1528.544103707785 | 3537.988003326847 | 2015.806061288172 | -1369.266061288172 | 2681.121026784707 | 16.28337927970156 | 1.708479327259986 | 7
 |  |  |  |  | SYST - CLASS | PARTY EXPRESS | BABY | PARTY GOODS | CENTERPIECE | N/A | 0001CPH3573 | 0001CPH3573 | 4.79 |  | Y | POOHS BABY DAYS | CPH | C | BABY | NOT ASSIGNED | NOT ASSIGNED |  | 34818.51 | 11427.36 | 762.54 | 1630.57 | 0 | 45.5 | 23345.65 | 0.670495377315112 | 7980.3 |  | 2535.87 |  |  | 2.395 | 1620 | 1086 | 1050 | 378 | 498 | 408 | 432 | 198 | 264 | 576 | 438 | 408 | 630 | 354 | 666 | 582 | 684 | 468 | 552 | 534 | 330 | 498 | 528 | 348 | 102 | 150 | 12 | 108 | 72 | 0 | 18 | 6 | 12 | 6 | 6 | 180 | 300 | 24 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14532 | 0.5489269500619067 | 336.8300451116866 | 6.403634093903272 | 0.508 | 15 |  | 0 | 0.9 | 0 | 4193.653846153847 | 279.5769230769231 | 1.2815515655446 | 1671.831633583105 | 1671.831633583105 | 917.7134396397888 | 1618.156560360211 | 5865.485479736952 | 20.97986276972909 | 1.204784863516832 | SYST - CLASS | PARTY EXPRESS | BABY | PARTY GOODS | CENTERPIECE | N/A | 0001CPH3573 | 0001CPH3573 | 4.79 | 0 | Y | POOHS BABY DAYS | CPH | C | BABY | NOT ASSIGNED | NOT ASSIGNED |  | 34818.51 | 11427.36 | 762.54 | 1630.57 | 0 | 45.5 | 23345.65 | 0.670495377315112 | 7980.3 | 0 | 2535.87 | 0 | 0 | 2.395 | 1620 | 1086 | 1050 | 378 | 498 | 408 | 432 | 198 | 264 | 576 | 438 | 408 | 630 | 354 | 666 | 582 | 684 | 468 | 552 | 534 | 330 | 498 | 528 | 348 | 102 | 150 | 12 | 108 | 72 | 0 | 18 | 6 | 12 | 6 | 6 | 180 | 300 | 24 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14532 | 0.5489269500619067 | 336.8300451116866 | 6.403634093903272 | 0.508 | 15 | 0 | 273 | 0.98 | 5335.308308005095 | 4193.653846153847 | 279.5769230769231 | 2.05374891063182 | 2679.191761411511 | 5346.845915414058 | 2935.027820799203 | -399.1578207992029 | 6872.845607565358 | 24.5830218457421 | 1.204784863516832 | 3
 |  |  |  |  | SYST - CLASS | PARTY EXPRESS | GENERAL ENTERTAINING | PARTY GOODS | FAVORS | N/A | 0001TPG8610 | 0001TPG8610 | 2.99 |  | N | TEMP TATTOO | TPG | T | GENERAL | NOT ASSIGNED | DECADES |  | 1462.11 | 408.19 | 388.01 | 0 | 0 | 0 | 1053.92 | 0.7208212788367496 | 316.7 |  | 1864.33 |  |  | 1.495 | 0 | 18 | 0 | 0 | 12 | 0 | 12 | 6 | 0 | 0 | 6 | 0 | 48 | 12 | 12 | 24 | 12 | 42 | 36 | 6 | 0 | 6 | 0 | 42 | 6 | 18 | 0 | 6 | 42 | 18 | 6 | 36 | 42 | 18 | 0 | 24 | 6 | 6 | 18 | 6 | 0 | 36 | 6 | 72 | 36 | 54 | 12 | 42 | 132 | 18 | 18 | 6 | 978 | 0.3238241308793456 | 23.26853145802325 | 0.4386019521919787 | 0.508 | 7 |  | 472 | 0.9 | 2369.021292379409 | 131.6538461538461 | 18.8076923076923 | 1.2815515655446 | 78.89583558088934 | 1263.406481770594 | 409.1215059066944 | 1455.208494093305 | 210.5496817347355 | 11.19487060348287 | 1.237181631714938 | SYST - CLASS | PARTY EXPRESS | GENERAL ENTERTAINING | PARTY GOODS | FAVORS | N/A | 0001TPG8610 | 0001TPG8610 | 2.99 | 0 | N | TEMP TATTOO | TPG | T | GENERAL | NOT ASSIGNED | DECADES |  | 1462.11 | 408.19 | 388.01 | 0 | 0 | 0 | 1053.92 | 0.7208212788367496 | 316.7 | 0 | 1864.33 | 0 | 0 | 1.495 | 0 | 18 | 0 | 0 | 12 | 0 | 12 | 6 | 0 | 0 | 6 | 0 | 48 | 12 | 12 | 24 | 12 | 42 | 36 | 6 | 0 | 6 | 0 | 42 | 6 | 18 | 0 | 6 | 42 | 18 | 6 | 36 | 42 | 18 | 0 | 24 | 6 | 6 | 18 | 6 | 0 | 36 | 6 | 72 | 36 | 54 | 12 | 42 | 132 | 18 | 18 | 6 | 978 | 0.3238241308793456 | 23.26853145802325 | 0.4386019521919787 | 0.508 | 7 | 0 | 273 | 0.98 | 1801.686765148038 | 131.6538461538461 | 18.8076923076923 | 2.05374891063182 | 126.4344258428512 | 1027.27780841687 | 332.657343482232 | 1531.672656517768 | 258.0882719966974 | 13.72248480964035 | 1.237181631714938 | 7
 |  |  |  |  | SYST - CLASS | PARTY EXPRESS | SEASON | PARTY GOODS | BOWL | PAPER | 0349TAC0139 | 0349TAC0139 | 3.49 |  | N | COUNTRY THANKSGIVING | TAC | T | THANKSGIVING | NOT ASSIGNED | NOT ASSIGNED |  | 35001.21 | 9717.87 | 5128.44 | 0 | 0 | 0 | 25283.34 | 0.7223561699724095 | 6284.57 |  | 3345.95 |  |  | 1.745 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 174 | 0 | 6 | 0 | 204 | 36 | 1152 | 54 | 2736 | 9528 | 5628 | 540 | 0 | 20058 | 0.3133198723701266 | 1543.601683817436 | 4.886742791543339 | 0.508 | 7 |  | 472 | 0.9 | 10906.96662010316 | 2700.115384615385 | 385.7307692307692 | 1.2815515655446 | 5233.838881003036 | 10687.32219105462 | 3348.550424879654 | -2.600424879654383 | 7933.954265618421 | 20.56863205764074 | 4.001759276024861 | SYST - CLASS | PARTY EXPRESS | SEASON | PARTY GOODS | BOWL | PAPER | 0349TAC0139 | 0349TAC0139 | 3.49 | 0 | N | COUNTRY THANKSGIVING | TAC | T | THANKSGIVING | NOT ASSIGNED | NOT ASSIGNED |  | 35001.21 | 9717.87 | 5128.44 | 0 | 0 | 0 | 25283.34 | 0.7223561699724095 | 6284.57 | 0 | 3345.95 | 0 | 0 | 1.745 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 174 | 0 | 6 | 0 | 204 | 36 | 1152 | 54 | 2736 | 9528 | 5628 | 540 | 0 | 20058 | 0.3133198723701266 | 1543.601683817436 | 4.886742791543339 | 0.508 | 7 | 0 | 273 | 0.98 | 8294.96023128361 | 2700.115384615385 | 385.7307692307692 | 2.05374891063182 | 8387.482165584672 | 12534.96228122648 | 3927.452782118231 | -581.5027821182307 | 11087.59755020006 | 28.74439488535262 | 4.001759276024861 | 7
 |  |  |  |  | SYST - CLASS | PARTY EXPRESS | KIDS | PARTY GOODS | NAPKINS | BEVERAGE | 0001BEV6370 | 0001BEV6370 | 3.49 |  | N | PIRATES CARIBBEAN 3 | BEV | B | BIRTHDAY | NOT ASSIGNED | NOT ASSIGNED |  | 14574.24 | 2688.42 | 243.76 | 762.66 | 0 | 619.46 | 11266.36 | 0.7730324188431094 | 1475.13 |  | 4127.7 |  |  | 1.745 | 726 | 114 | 252 | 126 | 402 | 240 | 216 | 96 | 456 | 222 | 216 | 168 | 216 | 150 | 294 | 264 | 180 | 234 | 162 | 468 | 216 | 138 | 180 | 300 | 168 | 174 | 144 | 108 | 138 | 132 | 270 | 156 | 198 | 108 | 78 | 24 | 42 | 48 | 30 | 48 | 48 | 18 | 30 | 12 | 6 | 186 | 60 | 42 | 12 | 12 | 18 | 12 | 8358 | 0.1766199712643678 | 136.0769176414314 | 1.217183476680816 | 0.508 | 7 |  | 472 | 0.9 | 9374.097772948153 | 1124.307692307692 | 160.6153846153846 | 1.2815515655446 | 461.3914780122805 | 5148.440364486357 | 909.3173892318918 | 3218.382610768108 | 1585.699170319973 | 9.872648091072628 | 0.8472221883805594 | SYST - CLASS | PARTY EXPRESS | KIDS | PARTY GOODS | NAPKINS | BEVERAGE | 0001BEV6370 | 0001BEV6370 | 3.49 | 0 | N | PIRATES CARIBBEAN 3 | BEV | B | BIRTHDAY | NOT ASSIGNED | NOT ASSIGNED |  | 14574.24 | 2688.42 | 243.76 | 762.66 | 0 | 619.46 | 11266.36 | 0.7730324188431094 | 1475.13 | 0 | 4127.7 | 0 | 0 | 1.745 | 726 | 114 | 252 | 126 | 402 | 240 | 216 | 96 | 456 | 222 | 216 | 168 | 216 | 150 | 294 | 264 | 180 | 234 | 162 | 468 | 216 | 138 | 180 | 300 | 168 | 174 | 144 | 108 | 138 | 132 | 270 | 156 | 198 | 108 | 78 | 24 | 42 | 48 | 30 | 48 | 48 | 18 | 30 | 12 | 6 | 186 | 60 | 42 | 12 | 12 | 18 | 12 | 8358 | 0.1766199712643678 | 136.0769176414314 | 1.217183476680816 | 0.508 | 7 | 0 | 273 | 0.98 | 7129.183662068796 | 1124.307692307692 | 160.6153846153846 | 2.05374891063182 | 739.4023547853478 | 4303.994185819746 | 760.1713294214898 | 3367.52867057851 | 1863.71004709304 | 11.60355872232257 | 0.8472221883805594 | 7
 |  |  |  |  | SYST - CLASS | PARTY EXPRESS | SEASON | PARTY GOODS | JEWELRY | LAPEL PIN | 0249FVS8184 | 0249FVS8184 | 2.49 |  | N | FABRIC FELT PIN | FVS | F | [NAME] DAY | NOT ASSIGNED | NOT ASSIGNED |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | 0 |  | 1817.53 |  |  | 1.245 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.508 | 7 |  | 472 | 0.9 | 0 | 0 | 0 | 1.2815515655446 | 0 | 0 | 0 | 1817.53 | 0 | 0 | 0 | SYST - CLASS | PARTY EXPRESS | SEASON | PARTY GOODS | JEWELRY | LAPEL PIN | 0249FVS8184 | 0249FVS8184 | 2.49 | 0 | N | FABRIC FELT PIN | FVS | F | [NAME] DAY | NOT ASSIGNED | NOT ASSIGNED |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | 0 | 0 | 1817.53 | 0 | 0 | 1.245 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.508 | 7 | 0 | 273 | 0.98 | 0 | 0 | 0 | 2.05374891063182 | 0 | 0 | 0 | 1817.53 | 0 | 0 | 0 | 7
 |  |  |  |  | SYST - CLASS | PARTY EXPRESS | SPORTS | PARTY GOODS | CUP | PLASTIC | 0001PCU3941 | 0001PCU3941 | 0.79 |  | N | ALL STAR SPORTS | PCU | P | GENERAL | NOT ASSIGNED | SPORTS |  | 1568.94 | 937.92 | 553.86 | 0 | 0 | 0 | 631.0200000000001 | 0.4021951126238097 | 760.28 |  | 2464.53 |  |  | 0.395 | 0 | 96 | 36 | 0 | 0 | 36 | 48 | 0 | 0 | 0 | 72 | 12 | 204 | 0 | 48 | 12 | 0 | 12 | 0 | 108 | 24 | 48 | 144 | 12 | 48 | 36 | 0 | 12 | 12 | 24 | 24 | 12 | 12 | 24 | 0 | 36 | 12 | 0 | 12 | 0 | 120 | 12 | 0 | 36 | 144 | 696 | 168 | 252 | 456 | 372 | 348 | 192 | 3972 | 0.1914098690835851 | 133.0246006522787 | 0.2075471549816556 | 0.508 | 7 |  | 472 | 0.9 | 6209.785484041823 | 534.6923076923077 | 76.38461538461539 | 1.2815515655446 | 451.0420883332894 | 3555.934830354201 | 680.641020347858 | 1783.888979652142 | 985.7343960255971 | 12.90488131755565 | 1.741510381147657 | SYST - CLASS | PARTY EXPRESS | SPORTS | PARTY GOODS | CUP | PLASTIC | 0001PCU3941 | 0001PCU3941 | 0.79 | 0 | N | ALL STAR SPORTS | PCU | P | GENERAL | NOT ASSIGNED | SPORTS |  | 1568.94 | 937.92 | 553.86 | 0 | 0 | 0 | 631.0200000000001 | 0.4021951126238097 | 760.28 | 0 | 2464.53 | 0 | 0 | 0.395 | 0 | 96 | 36 | 0 | 0 | 36 | 48 | 0 | 0 | 0 | 72 | 12 | 204 | 0 | 48 | 12 | 0 | 12 | 0 | 108 | 24 | 48 | 144 | 12 | 48 | 36 | 0 | 12 | 12 | 24 | 24 | 12 | 12 | 24 | 0 | 36 | 12 | 0 | 12 | 0 | 120 | 12 | 0 | 36 | 144 | 696 | 168 | 252 | 456 | 372 | 348 | 192 | 3972 | 0.1914098690835851 | 133.0246006522787 | 0.2075471549816556 | 0.508 | 7 | 0 | 273 | 0.98 | 4722.662627387959 | 534.6923076923077 | 76.38461538461539 | 2.05374891063182 | 722.8169528784806 | 3084.14826657246 | 590.3364159390005 | 1874.193584061 | 1257.509260570788 | 16.46286041029229 | 1.741510381147657 | 7
 |  |  |  |  | SYST - CLASS | PARTY EXPRESS | KIDS | PARTY GOODS | DECORATION | N/A | 0001CDC2370 | 0001CDC2370 | 9.99 |  | N | CEL DEC PIRATES | CDC | C | BIRTHDAY | NOT ASSIGNED | NOT ASSIGNED |  | 539.46 | 249.07 | 25.93 | 19 | 0 | 24.98 | 265.41 | 0.491991991991992 | 217.39 |  | 7579.41 |  |  | 4.995 | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 12 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 18 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 108 | 2.01287037037037 | 5.504704819327644 | 0.02777740287478216 | 0.508 | 7 |  | 472 | 0.9 | 315.760728399059 | 14.53846153846154 | 2.076923076923077 | 1.2815515655446 | 18.66461951543797 | 176.5449837149675 | 355.3621667573776 | 7224.047833242622 | 33.20308105389951 | 15.98666865558124 | 2.650413431528125 | SYST - CLASS | PARTY EXPRESS | KIDS | PARTY GOODS | DECORATION | N/A | 0001CDC2370 | 0001CDC2370 | 9.99 | 0 | N | CEL DEC PIRATES | CDC | C | BIRTHDAY | NOT ASSIGNED | NOT ASSIGNED |  | 539.46 | 249.07 | 25.93 | 19 | 0 | 24.98 | 265.41 | 0.491991991991992 | 217.39 | 0 | 7579.41 | 0 | 0 | 4.995 | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 12 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 18 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 108 | 2.01287037037037 | 5.504704819327644 | 0.02777740287478216 | 0.508 | 7 | 0 | 273 | 0.98 | 240.1421748044706 | 14.53846153846154 | 2.076923076923077 | 2.05374891063182 | 29.91096341948489 | 149.9820508217202 | 301.8944261864236 | 7277.515573813576 | 44.44942495794643 | 21.40157497975198 | 2.650413431528125 | 7