Spreadsheet: 60346d1260903282-nested-if-statements-inventory-segmentation
Sheet: Data

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 | 273 | 472 | 0.9 | 5675.276996893389 | 990.2307692307692 | 141.4615384615385 | 1.2815515655446 | 3068.358310949592 | 5905.996809396287 | 2506.507936281426 | 2918.762063718574 | 4058.589080180361 | 28.69040676582093 | 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 | 273 | 0.98 | 4316.158527888121 | 990.2307692307692 | 141.4615384615385 | 2.05374891063182 | 4917.193898368741 | 7075.273162312802 | 3002.749392698846 | 2422.520607301155 | 5907.424667599511 | 41.75993511625538 | 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 | 273 | 472 | 0.9 | 5284.398460515221 | 1152.576923076923 | 164.6538461538461 | 1.2815515655446 | 3614.61405185098 | 6256.813282108591 | 3564.885501749302 | -2918.345501749302 | 4767.190974927903 | 28.9528066685647 | 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 | 273 | 273 | 0.98 | 4018.887799238125 | 1152.576923076923 | 164.6538461538461 | 2.05374891063182 | 5792.595374957676 | 7802.039274576739 | 4445.294343935409 | -3798.754343935409 | 6945.172298034598 | 42.1804437628824 | 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 | 273 | 0 | 0.9 | 0 | 4193.653846153847 | 279.5769230769231 | 1.2815515655446 | 6151.499050757408 | 6151.499050757408 | 3376.723612240978 | -840.8536122409782 | 10345.15289691126 | 37.00288558532021 | 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 | 273 | 273 | 0.98 | 5335.308308005095 | 4193.653846153847 | 279.5769230769231 | 2.05374891063182 | 9858.077360216863 | 12525.73151421941 | 6875.711597394769 | -4339.841597394769 | 14051.73120637071 | 50.26069767033133 | 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 | 273 | 472 | 0.9 | 2369.021292379409 | 131.6538461538461 | 18.8076923076923 | 1.2815515655446 | 405.9870974733199 | 1590.497743663024 | 515.0415495072392 | 1349.288450492761 | 537.640943627166 | 28.58622604152621 | 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 | 273 | 273 | 0.98 | 1801.686765148038 | 131.6538461538461 | 18.8076923076923 | 2.05374891063182 | 650.6141317942839 | 1551.457514368303 | 502.3993811865457 | 1361.930618813454 | 782.26797794813 | 41.59298042259996 | 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 | 581 | 472 | 0.9 | 10906.96662010316 | 2700.115384615385 | 385.7307692307692 | 1.2815515655446 | 13014.21152455064 | 18467.69483460223 | 5786.295788548015 | -2440.345788548016 | 15714.32690916603 | 40.73910655482268 | 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 | 581 | 273 | 0.98 | 8294.96023128361 | 2700.115384615385 | 385.7307692307692 | 2.05374891063182 | 20855.90893092143 | 25003.38904656323 | 7834.058664889812 | -4488.108664889813 | 23556.02431553681 | 61.06856438368302 | 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 | 205 | 472 | 0.9 | 9374.097772948153 | 1124.307692307692 | 160.6153846153846 | 1.2815515655446 | 2983.034012735984 | 7670.08289921006 | 1354.6898212538 | 2773.0101787462 | 4107.341705043676 | 25.57252977278151 | 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 | 205 | 273 | 0.98 | 7129.183662068796 | 1124.307692307692 | 160.6153846153846 | 2.05374891063182 | 4780.457547512538 | 8345.049378546937 | 1473.902381438691 | 2653.797618561309 | 5904.765239820231 | 36.76338511382328 | 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 | 273 | 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 | 273 | 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 | 472 | 0.9 | 6209.785484041823 | 534.6923076923077 | 76.38461538461539 | 1.2815515655446 | 2174.035981438517 | 5278.928723459429 | 1010.439055858946 | 1454.090944141054 | 2708.728289130825 | 35.46169965629479 | 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 | 472 | 273 | 0.98 | 4722.662627387959 | 534.6923076923077 | 76.38461538461539 | 2.05374891063182 | 3483.99873137867 | 5845.330045072649 | 1118.853858677702 | 1345.676141322298 | 4018.691039070977 | 52.61126234433303 | 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 | 273 | 472 | 0.9 | 315.760728399059 | 14.53846153846154 | 2.076923076923077 | 1.2815515655446 | 47.77502904483875 | 205.6553932443683 | 413.9576475684557 | 7165.452352431545 | 62.31349058330029 | 30.00279176232977 | 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 | 273 | 273 | 0.98 | 240.1421748044706 | 14.53846153846154 | 2.076923076923077 | 2.05374891063182 | 76.56181498599751 | 196.6329023882328 | 395.7965430572031 | 7183.613456942797 | 91.10027652445905 | 43.86309610436917 | 2.650413431528125 | 7