{"text_format":"3","workbook":"xlsx","n_sheets":14,"sheets":["Loading","Summary","Import","Upload","CategoryTemplate","SoldToShipTo","GlobalVariables","ShipMethods","ProductLine_Style","CellStyle","CategoryList","CATEGORY","HistoryData","Instructions"],"not_rendered":{"macros":1,"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Loading","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}

{"sheet":"Summary","index":1,"n_rows":28,"n_cols":20,"rows_kept":28,"merged":[[1,4,1,16],[8,3,8,7],[10,2,10,16],[11,3,11,4],[11,5,11,6],[11,7,11,8],[11,9,11,10],[11,11,11,12],[11,13,11,14],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[12,11,12,12],[12,13,12,14],[13,3,13,4],[13,5,13,6],[13,7,13,8],[13,9,13,10],[13,11,13,12],[13,13,13,14],[14,3,14,4],[14,5,14,6],[14,7,14,8],[14,9,14,10],[14,11,14,12],[14,13,14,14],[16,3,16,4],[16,5,16,6],[16,7,16,8],[16,9,16,10],[16,11,16,12],[16,13,16,14],[17,3,17,4],[17,5,17,6],[17,7,17,8],[17,9,17,10],[17,11,17,12],[17,13,17,14],[20,3,20,4],[20,5,20,6],[20,7,20,8],[20,9,20,10],[20,11,20,12],[20,13,20,14],[20,15,20,16]]}
[]
[{"$nulls":3},"Comments"]
[]
[]
[]
["Tubbs2223"," ","Tubbs 22/23"]
[]
[]
[null,null,"Enter your Account No:"]
[]
[null,null,"SHIPTO, SHIP DATE, PO# ARE REQUIRED FIELDS FOR EACH ORDER:"]
[{"$nulls":3},"Order 1",null,"Order 2",null,"Order 3",null,"Order 4",null,"Order 5",null,"Order 6"]
[null,null,"Ship To"]
[null,null,"Ship Date","2022-06-01"]
[null,null,"PO Number"]
[]
[null,null,"Deadline"]
[null,null,"Requested Delivery Date"]
[]
[null,null,"Order and Category Sub-Totals"]
[{"$nulls":3},"Order 1",null,"Order 2",null,"Order 3",null,"Order 4",null,"Order 5",null,"Order 6",null,"TOTALS",null,"Discount %","Net Total"]
[{"$nulls":3},"Units","Value","Units","Value","Units","Value","Units","Value","Units","Value","Units","Value","Units","Value","Percent","Value"]
[null,null,"Order Total",{"$f":"SUM(D24)","v":0},{"v":0,"d":"0.00"},0,{"v":0,"d":"0.00"},0,{"v":0,"d":"0.00"},0,{"v":0,"d":"0.00"},0,{"v":0,"d":"0.00"},0,{"v":0,"d":"0.00"},0,{"v":0,"d":"0.00"},null,{"$f":"Q23*(1-R23)","v":{"v":0,"d":"0.00"}},"USD"]
["U0","1","CATEGORY Total",{"$f":"SUM(D25:D28)","v":0},{"v":0,"d":"0.00"},0,{"v":0,"d":"0.00"},0,{"v":0,"d":"0.00"},0,{"v":0,"d":"0.00"},0,{"v":0,"d":"0.00"},0,{"v":0,"d":"0.00"},{"$f":"SUM(D24,F24,H24,J24,L24,N24)","v":0},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
["U","32","Snowshoe",{"$f":"CATEGORY!N88","v":0},{"$f":"SUMPRODUCT(CATEGORY!K11:K71,CATEGORY!N11:N71)","v":{"v":0,"d":"0.00"}},{"$f":"CATEGORY!O88","v":0},{"$f":"SUMPRODUCT(CATEGORY!K11:K71,CATEGORY!O11:O71)","v":{"v":0,"d":"0.00"}},{"$f":"CATEGORY!P88","v":0},{"$f":"SUMPRODUCT(CATEGORY!K11:K71,CATEGORY!P11:P71)","v":{"v":0,"d":"0.00"}},{"$f":"CATEGORY!Q88","v":0},{"$f":"SUMPRODUCT(CATEGORY!K11:K71,CATEGORY!Q11:Q71)","v":{"v":0,"d":"0.00"}},{"$f":"CATEGORY!R88","v":0},{"$f":"SUMPRODUCT(CATEGORY!K11:K71,CATEGORY!R11:R71)","v":{"v":0,"d":"0.00"}},{"$f":"CATEGORY!S88","v":0},{"$f":"SUMPRODUCT(CATEGORY!K11:K71,CATEGORY!S11:S71)","v":{"v":0,"d":"0.00"}},0,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
["U","20","Poles",{"$f":"CATEGORY!N89","v":0},{"$f":"CATEGORY!K72:K72 * CATEGORY!N72:N72","v":{"v":0,"d":"0.00"}},{"$f":"CATEGORY!O89","v":0},{"$f":"CATEGORY!K72:K72 * CATEGORY!O72:O72","v":{"v":0,"d":"0.00"}},{"$f":"CATEGORY!P89","v":0},{"$f":"CATEGORY!K72:K72 * CATEGORY!P72:P72","v":{"v":0,"d":"0.00"}},{"$f":"CATEGORY!Q89","v":0},{"$f":"CATEGORY!K72:K72 * CATEGORY!Q72:Q72","v":{"v":0,"d":"0.00"}},{"$f":"CATEGORY!R89","v":0},{"$f":"CATEGORY!K72:K72 * CATEGORY!R72:R72","v":{"v":0,"d":"0.00"}},{"$f":"CATEGORY!S89","v":0},{"$f":"CATEGORY!K72:K72 * CATEGORY!S72:S72","v":{"v":0,"d":"0.00"}},0,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
["U","16","Kits",{"$f":"CATEGORY!N90","v":0},{"$f":"SUMPRODUCT(CATEGORY!K73:K80,CATEGORY!N73:N80)","v":{"v":0,"d":"0.00"}},{"$f":"CATEGORY!O90","v":0},{"$f":"SUMPRODUCT(CATEGORY!K73:K80,CATEGORY!O73:O80)","v":{"v":0,"d":"0.00"}},{"$f":"CATEGORY!P90","v":0},{"$f":"SUMPRODUCT(CATEGORY!K73:K80,CATEGORY!P73:P80)","v":{"v":0,"d":"0.00"}},{"$f":"CATEGORY!Q90","v":0},{"$f":"SUMPRODUCT(CATEGORY!K73:K80,CATEGORY!Q73:Q80)","v":{"v":0,"d":"0.00"}},{"$f":"CATEGORY!R90","v":0},{"$f":"SUMPRODUCT(CATEGORY!K73:K80,CATEGORY!R73:R80)","v":{"v":0,"d":"0.00"}},{"$f":"CATEGORY!S90","v":0},{"$f":"SUMPRODUCT(CATEGORY!K73:K80,CATEGORY!S73:S80)","v":{"v":0,"d":"0.00"}},0,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
["U","2","Accessories",{"$f":"CATEGORY!N91","v":0},{"$f":"SUMPRODUCT(CATEGORY!K81:K86,CATEGORY!N81:N86)","v":{"v":0,"d":"0.00"}},{"$f":"CATEGORY!O91","v":0},{"$f":"SUMPRODUCT(CATEGORY!K81:K86,CATEGORY!O81:O86)","v":{"v":0,"d":"0.00"}},{"$f":"CATEGORY!P91","v":0},{"$f":"SUMPRODUCT(CATEGORY!K81:K86,CATEGORY!P81:P86)","v":{"v":0,"d":"0.00"}},{"$f":"CATEGORY!Q91","v":0},{"$f":"SUMPRODUCT(CATEGORY!K81:K86,CATEGORY!Q81:Q86)","v":{"v":0,"d":"0.00"}},{"$f":"CATEGORY!R91","v":0},{"$f":"SUMPRODUCT(CATEGORY!K81:K86,CATEGORY!R81:R86)","v":{"v":0,"d":"0.00"}},{"$f":"CATEGORY!S91","v":0},{"$f":"SUMPRODUCT(CATEGORY!K81:K86,CATEGORY!S81:S86)","v":{"v":0,"d":"0.00"}},0,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]

{"sheet":"Import","index":2,"n_rows":96,"n_cols":11,"rows_kept":96,"hidden":true}
["2.0.0"]
[{"$nulls":5},"Order1","Order2","Order3","Order4","Order5","Order6"]
["Soldto",{"$nulls":4},{"$f":"Summary!D9&\"\"","v":""},{"$f":"Summary!D9&\"\"","v":""},{"$f":"Summary!D9&\"\"","v":""},{"$f":"Summary!D9&\"\"","v":""},{"$f":"Summary!D9&\"\"","v":""},{"$f":"Summary!D9&\"\"","v":""}]
["Shipto",{"$nulls":4},{"$f":"Summary!D13&\"\"","v":""},{"$f":"Summary!F13&\"\"","v":""},{"$f":"Summary!H13&\"\"","v":""},{"$f":"Summary!J13&\"\"","v":""},{"$f":"Summary!L13&\"\"","v":""},{"$f":"Summary!N13&\"\"","v":""}]
["PONumber",{"$nulls":4},{"$f":"Summary!D15&\"\"","v":""},{"$f":"Summary!F15&\"\"","v":""},{"$f":"Summary!H15&\"\"","v":""},{"$f":"Summary!J15&\"\"","v":""},{"$f":"Summary!L15&\"\"","v":""},{"$f":"Summary!N15&\"\"","v":""}]
["ShipRequiredDate",{"$nulls":4},{"$f":"Summary!D14","v":"2022-06-01"},{"$f":"Summary!F14","v":"00:00:00"},{"$f":"Summary!H14","v":"00:00:00"},{"$f":"Summary!J14","v":"00:00:00"},{"$f":"Summary!L14","v":"00:00:00"},{"$f":"Summary!N14","v":"00:00:00"}]
["ShipNotBeforeDate"]
["ShipCancelDate"]
["ShipMethod"]
{"$rows_empty":10}
["UPC","StyleNumber","StyleName","ColorCode","Size"]
["886745820246",{"$f":"CATEGORY!F11","v":"X190100101250"},{"$f":"CATEGORY!G11","v":"886745820246"},{"$f":"CATEGORY!H11","v":"MOUNTAINEER"},{"$f":"CATEGORY!I11","v":"GREEN (01)"},{"$f":"+CATEGORY!N11","v":0},{"$f":"+CATEGORY!O11","v":0},{"$f":"+CATEGORY!P11","v":0},{"$f":"+CATEGORY!Q11","v":0},{"$f":"+CATEGORY!R11","v":0},{"$f":"+CATEGORY!S11","v":0}]
["886745819899",{"$f":"CATEGORY!F12","v":"X190100101300"},{"$f":"CATEGORY!G12","v":"886745819899"},{"$f":"CATEGORY!H12","v":"MOUNTAINEER"},{"$f":"CATEGORY!I12","v":"GREEN (01)"},{"$f":"+CATEGORY!N12","v":0},{"$f":"+CATEGORY!O12","v":0},{"$f":"+CATEGORY!P12","v":0},{"$f":"+CATEGORY!Q12","v":0},{"$f":"+CATEGORY!R12","v":0},{"$f":"+CATEGORY!S12","v":0}]
["886745820154",{"$f":"CATEGORY!F13","v":"X190100101360"},{"$f":"CATEGORY!G13","v":"886745820154"},{"$f":"CATEGORY!H13","v":"MOUNTAINEER"},{"$f":"CATEGORY!I13","v":"GREEN (01)"},{"$f":"+CATEGORY!N13","v":0},{"$f":"+CATEGORY!O13","v":0},{"$f":"+CATEGORY!P13","v":0},{"$f":"+CATEGORY!Q13","v":0},{"$f":"+CATEGORY!R13","v":0},{"$f":"+CATEGORY!S13","v":0}]
["886745820260",{"$f":"CATEGORY!F14","v":"X19010010121W"},{"$f":"CATEGORY!G14","v":"886745820260"},{"$f":"CATEGORY!H14","v":"MOUNTAINEER W"},{"$f":"CATEGORY!I14","v":"PURPLE (01)"},{"$f":"+CATEGORY!N14","v":0},{"$f":"+CATEGORY!O14","v":0},{"$f":"+CATEGORY!P14","v":0},{"$f":"+CATEGORY!Q14","v":0},{"$f":"+CATEGORY!R14","v":0},{"$f":"+CATEGORY!S14","v":0}]
["886745819981",{"$f":"CATEGORY!F15","v":"X19010010125W"},{"$f":"CATEGORY!G15","v":"886745819981"},{"$f":"CATEGORY!H15","v":"MOUNTAINEER W"},{"$f":"CATEGORY!I15","v":"PURPLE (01)"},{"$f":"+CATEGORY!N15","v":0},{"$f":"+CATEGORY!O15","v":0},{"$f":"+CATEGORY!P15","v":0},{"$f":"+CATEGORY!Q15","v":0},{"$f":"+CATEGORY!R15","v":0},{"$f":"+CATEGORY!S15","v":0}]
["886745886082",{"$f":"CATEGORY!F16","v":"X19010010130W"},{"$f":"CATEGORY!G16","v":"886745886082"},{"$f":"CATEGORY!H16","v":"MOUNTAINEER W"},{"$f":"CATEGORY!I16","v":"PURPLE (01)"},{"$f":"+CATEGORY!N16","v":0},{"$f":"+CATEGORY!O16","v":0},{"$f":"+CATEGORY!P16","v":0},{"$f":"+CATEGORY!Q16","v":0},{"$f":"+CATEGORY!R16","v":0},{"$f":"+CATEGORY!S16","v":0}]
["886745975083",{"$f":"CATEGORY!F17","v":"X220100201250"},{"$f":"CATEGORY!G17","v":"886745975083"},{"$f":"CATEGORY!H17","v":"FLEX VRT"},{"$f":"CATEGORY!I17","v":"YELLOW (01)"},{"$f":"+CATEGORY!N17","v":0},{"$f":"+CATEGORY!O17","v":0},{"$f":"+CATEGORY!P17","v":0},{"$f":"+CATEGORY!Q17","v":0},{"$f":"+CATEGORY!R17","v":0},{"$f":"+CATEGORY!S17","v":0}]
["886745975748",{"$f":"CATEGORY!F18","v":"X220100201290"},{"$f":"CATEGORY!G18","v":"886745975748"},{"$f":"CATEGORY!H18","v":"FLEX VRT"},{"$f":"CATEGORY!I18","v":"YELLOW (01)"},{"$f":"+CATEGORY!N18","v":0},{"$f":"+CATEGORY!O18","v":0},{"$f":"+CATEGORY!P18","v":0},{"$f":"+CATEGORY!Q18","v":0},{"$f":"+CATEGORY!R18","v":0},{"$f":"+CATEGORY!S18","v":0}]
["886745974628",{"$f":"CATEGORY!F19","v":"X220100401250"},{"$f":"CATEGORY!G19","v":"886745974628"},{"$f":"CATEGORY!H19","v":"FLEX ALP"},{"$f":"CATEGORY!I19","v":"WHITE (01)"},{"$f":"+CATEGORY!N19","v":0},{"$f":"+CATEGORY!O19","v":0},{"$f":"+CATEGORY!P19","v":0},{"$f":"+CATEGORY!Q19","v":0},{"$f":"+CATEGORY!R19","v":0},{"$f":"+CATEGORY!S19","v":0}]
["886745975687",{"$f":"CATEGORY!F20","v":"X220100401290"},{"$f":"CATEGORY!G20","v":"886745975687"},{"$f":"CATEGORY!H20","v":"FLEX ALP"},{"$f":"CATEGORY!I20","v":"WHITE (01)"},{"$f":"+CATEGORY!N20","v":0},{"$f":"+CATEGORY!O20","v":0},{"$f":"+CATEGORY!P20","v":0},{"$f":"+CATEGORY!Q20","v":0},{"$f":"+CATEGORY!R20","v":0},{"$f":"+CATEGORY!S20","v":0}]
["886745780175",{"$f":"CATEGORY!F21","v":"X180101501250"},{"$f":"CATEGORY!G21","v":"886745780175"},{"$f":"CATEGORY!H21","v":"PANORAMIC"},{"$f":"CATEGORY!I21","v":"BLACK/RED (01)"},{"$f":"+CATEGORY!N21","v":0},{"$f":"+CATEGORY!O21","v":0},{"$f":"+CATEGORY!P21","v":0},{"$f":"+CATEGORY!Q21","v":0},{"$f":"+CATEGORY!R21","v":0},{"$f":"+CATEGORY!S21","v":0}]
["886745780205",{"$f":"CATEGORY!F22","v":"X180101501300"},{"$f":"CATEGORY!G22","v":"886745780205"},{"$f":"CATEGORY!H22","v":"PANORAMIC"},{"$f":"CATEGORY!I22","v":"BLACK/RED (01)"},{"$f":"+CATEGORY!N22","v":0},{"$f":"+CATEGORY!O22","v":0},{"$f":"+CATEGORY!P22","v":0},{"$f":"+CATEGORY!Q22","v":0},{"$f":"+CATEGORY!R22","v":0},{"$f":"+CATEGORY!S22","v":0}]
["886745780083",{"$f":"CATEGORY!F23","v":"X180101501360"},{"$f":"CATEGORY!G23","v":"886745780083"},{"$f":"CATEGORY!H23","v":"PANORAMIC"},{"$f":"CATEGORY!I23","v":"BLACK/RED (01)"},{"$f":"+CATEGORY!N23","v":0},{"$f":"+CATEGORY!O23","v":0},{"$f":"+CATEGORY!P23","v":0},{"$f":"+CATEGORY!Q23","v":0},{"$f":"+CATEGORY!R23","v":0},{"$f":"+CATEGORY!S23","v":0}]
["886745780267",{"$f":"CATEGORY!F24","v":"X18010150121W"},{"$f":"CATEGORY!G24","v":"886745780267"},{"$f":"CATEGORY!H24","v":"PANORAMIC W"},{"$f":"CATEGORY!I24","v":"GREY/ICE BLUE (01)"},{"$f":"+CATEGORY!N24","v":0},{"$f":"+CATEGORY!O24","v":0},{"$f":"+CATEGORY!P24","v":0},{"$f":"+CATEGORY!Q24","v":0},{"$f":"+CATEGORY!R24","v":0},{"$f":"+CATEGORY!S24","v":0}]
["886745779988",{"$f":"CATEGORY!F25","v":"X18010150125W"},{"$f":"CATEGORY!G25","v":"886745779988"},{"$f":"CATEGORY!H25","v":"PANORAMIC W"},{"$f":"CATEGORY!I25","v":"GREY/ICE BLUE (01)"},{"$f":"+CATEGORY!N25","v":0},{"$f":"+CATEGORY!O25","v":0},{"$f":"+CATEGORY!P25","v":0},{"$f":"+CATEGORY!Q25","v":0},{"$f":"+CATEGORY!R25","v":0},{"$f":"+CATEGORY!S25","v":0}]
["886745886174",{"$f":"CATEGORY!F26","v":"X18010150130W"},{"$f":"CATEGORY!G26","v":"886745886174"},{"$f":"CATEGORY!H26","v":"PANORAMIC W"},{"$f":"CATEGORY!I26","v":"GREY/ICE BLUE (01)"},{"$f":"+CATEGORY!N26","v":0},{"$f":"+CATEGORY!O26","v":0},{"$f":"+CATEGORY!P26","v":0},{"$f":"+CATEGORY!Q26","v":0},{"$f":"+CATEGORY!R26","v":0},{"$f":"+CATEGORY!S26","v":0}]
["886745975724",{"$f":"CATEGORY!F27","v":"X220100801250"},{"$f":"CATEGORY!G27","v":"886745975724"},{"$f":"CATEGORY!H27","v":"WILDERNESS"},{"$f":"CATEGORY!I27","v":"BLACK (01)"},{"$f":"+CATEGORY!N27","v":0},{"$f":"+CATEGORY!O27","v":0},{"$f":"+CATEGORY!P27","v":0},{"$f":"+CATEGORY!Q27","v":0},{"$f":"+CATEGORY!R27","v":0},{"$f":"+CATEGORY!S27","v":0}]
["886745975113",{"$f":"CATEGORY!F28","v":"X220100801300"},{"$f":"CATEGORY!G28","v":"886745975113"},{"$f":"CATEGORY!H28","v":"WILDERNESS"},{"$f":"CATEGORY!I28","v":"BLACK (01)"},{"$f":"+CATEGORY!N28","v":0},{"$f":"+CATEGORY!O28","v":0},{"$f":"+CATEGORY!P28","v":0},{"$f":"+CATEGORY!Q28","v":0},{"$f":"+CATEGORY!R28","v":0},{"$f":"+CATEGORY!S28","v":0}]
["886745974871",{"$f":"CATEGORY!F29","v":"X220100801360"},{"$f":"CATEGORY!G29","v":"886745974871"},{"$f":"CATEGORY!H29","v":"WILDERNESS"},{"$f":"CATEGORY!I29","v":"BLACK (01)"},{"$f":"+CATEGORY!N29","v":0},{"$f":"+CATEGORY!O29","v":0},{"$f":"+CATEGORY!P29","v":0},{"$f":"+CATEGORY!Q29","v":0},{"$f":"+CATEGORY!R29","v":0},{"$f":"+CATEGORY!S29","v":0}]
["886745974550",{"$f":"CATEGORY!F30","v":"X220100802250"},{"$f":"CATEGORY!G30","v":"886745974550"},{"$f":"CATEGORY!H30","v":"WILDERNESS"},{"$f":"CATEGORY!I30","v":"BLUE (02)"},{"$f":"+CATEGORY!N30","v":0},{"$f":"+CATEGORY!O30","v":0},{"$f":"+CATEGORY!P30","v":0},{"$f":"+CATEGORY!Q30","v":0},{"$f":"+CATEGORY!R30","v":0},{"$f":"+CATEGORY!S30","v":0}]
["886745975632",{"$f":"CATEGORY!F31","v":"X220100802300"},{"$f":"CATEGORY!G31","v":"886745975632"},{"$f":"CATEGORY!H31","v":"WILDERNESS"},{"$f":"CATEGORY!I31","v":"BLUE (02)"},{"$f":"+CATEGORY!N31","v":0},{"$f":"+CATEGORY!O31","v":0},{"$f":"+CATEGORY!P31","v":0},{"$f":"+CATEGORY!Q31","v":0},{"$f":"+CATEGORY!R31","v":0},{"$f":"+CATEGORY!S31","v":0}]
["886745975885",{"$f":"CATEGORY!F32","v":"X220100802360"},{"$f":"CATEGORY!G32","v":"886745975885"},{"$f":"CATEGORY!H32","v":"WILDERNESS"},{"$f":"CATEGORY!I32","v":"BLUE (02)"},{"$f":"+CATEGORY!N32","v":0},{"$f":"+CATEGORY!O32","v":0},{"$f":"+CATEGORY!P32","v":0},{"$f":"+CATEGORY!Q32","v":0},{"$f":"+CATEGORY!R32","v":0},{"$f":"+CATEGORY!S32","v":0}]
["886745975977",{"$f":"CATEGORY!F33","v":"X22010090121W"},{"$f":"CATEGORY!G33","v":"886745975977"},{"$f":"CATEGORY!H33","v":"WILDERNESS W"},{"$f":"CATEGORY!I33","v":"NO COLOR (01)"},{"$f":"+CATEGORY!N33","v":0},{"$f":"+CATEGORY!O33","v":0},{"$f":"+CATEGORY!P33","v":0},{"$f":"+CATEGORY!Q33","v":0},{"$f":"+CATEGORY!R33","v":0},{"$f":"+CATEGORY!S33","v":0}]
["886745975779",{"$f":"CATEGORY!F34","v":"X22010090125W"},{"$f":"CATEGORY!G34","v":"886745975779"},{"$f":"CATEGORY!H34","v":"WILDERNESS W"},{"$f":"CATEGORY!I34","v":"NO COLOR (01)"},{"$f":"+CATEGORY!N34","v":0},{"$f":"+CATEGORY!O34","v":0},{"$f":"+CATEGORY!P34","v":0},{"$f":"+CATEGORY!Q34","v":0},{"$f":"+CATEGORY!R34","v":0},{"$f":"+CATEGORY!S34","v":0}]
["886745974260",{"$f":"CATEGORY!F35","v":"X22010090130W"},{"$f":"CATEGORY!G35","v":"886745974260"},{"$f":"CATEGORY!H35","v":"WILDERNESS W"},{"$f":"CATEGORY!I35","v":"NO COLOR (01)"},{"$f":"+CATEGORY!N35","v":0},{"$f":"+CATEGORY!O35","v":0},{"$f":"+CATEGORY!P35","v":0},{"$f":"+CATEGORY!Q35","v":0},{"$f":"+CATEGORY!R35","v":0},{"$f":"+CATEGORY!S35","v":0}]
["886745780397",{"$f":"CATEGORY!F36","v":"X180102001240"},{"$f":"CATEGORY!G36","v":"886745780397"},{"$f":"CATEGORY!H36","v":"FLEX RDG 24 LLB"},{"$f":"CATEGORY!I36","v":"BLACK/GREEN (01)"},{"$f":"+CATEGORY!N36","v":0},{"$f":"+CATEGORY!O36","v":0},{"$f":"+CATEGORY!P36","v":0},{"$f":"+CATEGORY!Q36","v":0},{"$f":"+CATEGORY!R36","v":0},{"$f":"+CATEGORY!S36","v":0}]
["886745779971",{"$f":"CATEGORY!F37","v":"X18010200122W"},{"$f":"CATEGORY!G37","v":"886745779971"},{"$f":"CATEGORY!H37","v":"FLEX RDG W"},{"$f":"CATEGORY!I37","v":"BLACK/BLUE (01)"},{"$f":"+CATEGORY!N37","v":0},{"$f":"+CATEGORY!O37","v":0},{"$f":"+CATEGORY!P37","v":0},{"$f":"+CATEGORY!Q37","v":0},{"$f":"+CATEGORY!R37","v":0},{"$f":"+CATEGORY!S37","v":0}]
["886745974987",{"$f":"CATEGORY!F38","v":"X220100601240"},{"$f":"CATEGORY!G38","v":"886745974987"},{"$f":"CATEGORY!H38","v":"FLEX TRK"},{"$f":"CATEGORY!I38","v":"NO COLOR (01)"},{"$f":"+CATEGORY!N38","v":0},{"$f":"+CATEGORY!O38","v":0},{"$f":"+CATEGORY!P38","v":0},{"$f":"+CATEGORY!Q38","v":0},{"$f":"+CATEGORY!R38","v":0},{"$f":"+CATEGORY!S38","v":0}]
["886745974772",{"$f":"CATEGORY!F39","v":"X22010070122W"},{"$f":"CATEGORY!G39","v":"886745974772"},{"$f":"CATEGORY!H39","v":"FLEX TRK W"},{"$f":"CATEGORY!I39","v":"NO COLOR (01)"},{"$f":"+CATEGORY!N39","v":0},{"$f":"+CATEGORY!O39","v":0},{"$f":"+CATEGORY!P39","v":0},{"$f":"+CATEGORY!Q39","v":0},{"$f":"+CATEGORY!R39","v":0},{"$f":"+CATEGORY!S39","v":0}]
["886745883111",{"$f":"CATEGORY!F40","v":"X200100401250"},{"$f":"CATEGORY!G40","v":"886745883111"},{"$f":"CATEGORY!H40","v":"WAYFINDER"},{"$f":"CATEGORY!I40","v":"RED/BLACK (01)"},{"$f":"+CATEGORY!N40","v":0},{"$f":"+CATEGORY!O40","v":0},{"$f":"+CATEGORY!P40","v":0},{"$f":"+CATEGORY!Q40","v":0},{"$f":"+CATEGORY!R40","v":0},{"$f":"+CATEGORY!S40","v":0}]
["886745882978",{"$f":"CATEGORY!F41","v":"X200100401300"},{"$f":"CATEGORY!G41","v":"886745882978"},{"$f":"CATEGORY!H41","v":"WAYFINDER"},{"$f":"CATEGORY!I41","v":"RED/BLACK (01)"},{"$f":"+CATEGORY!N41","v":0},{"$f":"+CATEGORY!O41","v":0},{"$f":"+CATEGORY!P41","v":0},{"$f":"+CATEGORY!Q41","v":0},{"$f":"+CATEGORY!R41","v":0},{"$f":"+CATEGORY!S41","v":0}]
["886745884118",{"$f":"CATEGORY!F42","v":"X200100401360"},{"$f":"CATEGORY!G42","v":"886745884118"},{"$f":"CATEGORY!H42","v":"WAYFINDER"},{"$f":"CATEGORY!I42","v":"RED/BLACK (01)"},{"$f":"+CATEGORY!N42","v":0},{"$f":"+CATEGORY!O42","v":0},{"$f":"+CATEGORY!P42","v":0},{"$f":"+CATEGORY!Q42","v":0},{"$f":"+CATEGORY!R42","v":0},{"$f":"+CATEGORY!S42","v":0}]
["886745884040",{"$f":"CATEGORY!F43","v":"X20010040121W"},{"$f":"CATEGORY!G43","v":"886745884040"},{"$f":"CATEGORY!H43","v":"WAYFINDER W"},{"$f":"CATEGORY!I43","v":"PURPLE (01)"},{"$f":"+CATEGORY!N43","v":0},{"$f":"+CATEGORY!O43","v":0},{"$f":"+CATEGORY!P43","v":0},{"$f":"+CATEGORY!Q43","v":0},{"$f":"+CATEGORY!R43","v":0},{"$f":"+CATEGORY!S43","v":0}]
["886745884064",{"$f":"CATEGORY!F44","v":"X20010040125W"},{"$f":"CATEGORY!G44","v":"886745884064"},{"$f":"CATEGORY!H44","v":"WAYFINDER W"},{"$f":"CATEGORY!I44","v":"PURPLE (01)"},{"$f":"+CATEGORY!N44","v":0},{"$f":"+CATEGORY!O44","v":0},{"$f":"+CATEGORY!P44","v":0},{"$f":"+CATEGORY!Q44","v":0},{"$f":"+CATEGORY!R44","v":0},{"$f":"+CATEGORY!S44","v":0}]
["886745894254",{"$f":"CATEGORY!F45","v":"X200100302250"},{"$f":"CATEGORY!G45","v":"886745894254"},{"$f":"CATEGORY!H45","v":"FRONTIER"},{"$f":"CATEGORY!I45","v":"BLACK (02)"},{"$f":"+CATEGORY!N45","v":0},{"$f":"+CATEGORY!O45","v":0},{"$f":"+CATEGORY!P45","v":0},{"$f":"+CATEGORY!Q45","v":0},{"$f":"+CATEGORY!R45","v":0},{"$f":"+CATEGORY!S45","v":0}]
["886745894209",{"$f":"CATEGORY!F46","v":"X200100302300"},{"$f":"CATEGORY!G46","v":"886745894209"},{"$f":"CATEGORY!H46","v":"FRONTIER"},{"$f":"CATEGORY!I46","v":"BLACK (02)"},{"$f":"+CATEGORY!N46","v":0},{"$f":"+CATEGORY!O46","v":0},{"$f":"+CATEGORY!P46","v":0},{"$f":"+CATEGORY!Q46","v":0},{"$f":"+CATEGORY!R46","v":0},{"$f":"+CATEGORY!S46","v":0}]
["886745894483",{"$f":"CATEGORY!F47","v":"X200100302360"},{"$f":"CATEGORY!G47","v":"886745894483"},{"$f":"CATEGORY!H47","v":"FRONTIER"},{"$f":"CATEGORY!I47","v":"BLACK (02)"},{"$f":"+CATEGORY!N47","v":0},{"$f":"+CATEGORY!O47","v":0},{"$f":"+CATEGORY!P47","v":0},{"$f":"+CATEGORY!Q47","v":0},{"$f":"+CATEGORY!R47","v":0},{"$f":"+CATEGORY!S47","v":0}]
["886745883128",{"$f":"CATEGORY!F48","v":"X200100301250"},{"$f":"CATEGORY!G48","v":"886745883128"},{"$f":"CATEGORY!H48","v":"FRONTIER"},{"$f":"CATEGORY!I48","v":"FOREST (01)"},{"$f":"+CATEGORY!N48","v":0},{"$f":"+CATEGORY!O48","v":0},{"$f":"+CATEGORY!P48","v":0},{"$f":"+CATEGORY!Q48","v":0},{"$f":"+CATEGORY!R48","v":0},{"$f":"+CATEGORY!S48","v":0}]
["886745883517",{"$f":"CATEGORY!F49","v":"X200100301300"},{"$f":"CATEGORY!G49","v":"886745883517"},{"$f":"CATEGORY!H49","v":"FRONTIER"},{"$f":"CATEGORY!I49","v":"FOREST (01)"},{"$f":"+CATEGORY!N49","v":0},{"$f":"+CATEGORY!O49","v":0},{"$f":"+CATEGORY!P49","v":0},{"$f":"+CATEGORY!Q49","v":0},{"$f":"+CATEGORY!R49","v":0},{"$f":"+CATEGORY!S49","v":0}]
["886745883951",{"$f":"CATEGORY!F50","v":"X200100301360"},{"$f":"CATEGORY!G50","v":"886745883951"},{"$f":"CATEGORY!H50","v":"FRONTIER"},{"$f":"CATEGORY!I50","v":"FOREST (01)"},{"$f":"+CATEGORY!N50","v":0},{"$f":"+CATEGORY!O50","v":0},{"$f":"+CATEGORY!P50","v":0},{"$f":"+CATEGORY!Q50","v":0},{"$f":"+CATEGORY!R50","v":0},{"$f":"+CATEGORY!S50","v":0}]
["886745883777",{"$f":"CATEGORY!F51","v":"X20010030121W"},{"$f":"CATEGORY!G51","v":"886745883777"},{"$f":"CATEGORY!H51","v":"FRONTIER W"},{"$f":"CATEGORY!I51","v":"CORAL (01)"},{"$f":"+CATEGORY!N51","v":0},{"$f":"+CATEGORY!O51","v":0},{"$f":"+CATEGORY!P51","v":0},{"$f":"+CATEGORY!Q51","v":0},{"$f":"+CATEGORY!R51","v":0},{"$f":"+CATEGORY!S51","v":0}]
["886745884187",{"$f":"CATEGORY!F52","v":"X20010030125W"},{"$f":"CATEGORY!G52","v":"886745884187"},{"$f":"CATEGORY!H52","v":"FRONTIER W"},{"$f":"CATEGORY!I52","v":"CORAL (01)"},{"$f":"+CATEGORY!N52","v":0},{"$f":"+CATEGORY!O52","v":0},{"$f":"+CATEGORY!P52","v":0},{"$f":"+CATEGORY!Q52","v":0},{"$f":"+CATEGORY!R52","v":0},{"$f":"+CATEGORY!S52","v":0}]
["886745883906",{"$f":"CATEGORY!F53","v":"X20010030130W"},{"$f":"CATEGORY!G53","v":"886745883906"},{"$f":"CATEGORY!H53","v":"FRONTIER W"},{"$f":"CATEGORY!I53","v":"CORAL (01)"},{"$f":"+CATEGORY!N53","v":0},{"$f":"+CATEGORY!O53","v":0},{"$f":"+CATEGORY!P53","v":0},{"$f":"+CATEGORY!Q53","v":0},{"$f":"+CATEGORY!R53","v":0},{"$f":"+CATEGORY!S53","v":0}]
["886745819967",{"$f":"CATEGORY!F54","v":"X190100201250"},{"$f":"CATEGORY!G54","v":"886745819967"},{"$f":"CATEGORY!H54","v":"XPLORE"},{"$f":"CATEGORY!I54","v":"SILVER/BLUE (01)"},{"$f":"+CATEGORY!N54","v":0},{"$f":"+CATEGORY!O54","v":0},{"$f":"+CATEGORY!P54","v":0},{"$f":"+CATEGORY!Q54","v":0},{"$f":"+CATEGORY!R54","v":0},{"$f":"+CATEGORY!S54","v":0}]
["886745819875",{"$f":"CATEGORY!F55","v":"X190100201300"},{"$f":"CATEGORY!G55","v":"886745819875"},{"$f":"CATEGORY!H55","v":"XPLORE"},{"$f":"CATEGORY!I55","v":"SILVER/BLUE (01)"},{"$f":"+CATEGORY!N55","v":0},{"$f":"+CATEGORY!O55","v":0},{"$f":"+CATEGORY!P55","v":0},{"$f":"+CATEGORY!Q55","v":0},{"$f":"+CATEGORY!R55","v":0},{"$f":"+CATEGORY!S55","v":0}]
["886745820086",{"$f":"CATEGORY!F56","v":"X19010020121W"},{"$f":"CATEGORY!G56","v":"886745820086"},{"$f":"CATEGORY!H56","v":"XPLORE W"},{"$f":"CATEGORY!I56","v":"RASBERRY RED (01)"},{"$f":"+CATEGORY!N56","v":0},{"$f":"+CATEGORY!O56","v":0},{"$f":"+CATEGORY!P56","v":0},{"$f":"+CATEGORY!Q56","v":0},{"$f":"+CATEGORY!R56","v":0},{"$f":"+CATEGORY!S56","v":0}]
["886745819882",{"$f":"CATEGORY!F57","v":"X19010020125W"},{"$f":"CATEGORY!G57","v":"886745819882"},{"$f":"CATEGORY!H57","v":"XPLORE W"},{"$f":"CATEGORY!I57","v":"RASBERRY RED (01)"},{"$f":"+CATEGORY!N57","v":0},{"$f":"+CATEGORY!O57","v":0},{"$f":"+CATEGORY!P57","v":0},{"$f":"+CATEGORY!Q57","v":0},{"$f":"+CATEGORY!R57","v":0},{"$f":"+CATEGORY!S57","v":0}]
["886745700876",{"$f":"CATEGORY!F58","v":"X170100201240"},{"$f":"CATEGORY!G58","v":"886745700876"},{"$f":"CATEGORY!H58","v":"FLEX ESC 24"},{"$f":"CATEGORY!I58","v":"CYAN/BLACK (01)"},{"$f":"+CATEGORY!N58","v":0},{"$f":"+CATEGORY!O58","v":0},{"$f":"+CATEGORY!P58","v":0},{"$f":"+CATEGORY!Q58","v":0},{"$f":"+CATEGORY!R58","v":0},{"$f":"+CATEGORY!S58","v":0}]
["886745838258",{"$f":"CATEGORY!F59","v":"X1901010018"},{"$f":"CATEGORY!G59","v":"886745838258"},{"$f":"CATEGORY!H59","v":"FLEX ESC XL"},{"$f":"CATEGORY!I59","v":"CYAN/BLACK (01)"},{"$f":"+CATEGORY!N59","v":0},{"$f":"+CATEGORY!O59","v":0},{"$f":"+CATEGORY!P59","v":0},{"$f":"+CATEGORY!Q59","v":0},{"$f":"+CATEGORY!R59","v":0},{"$f":"+CATEGORY!S59","v":0}]
["886745696551",{"$f":"CATEGORY!F60","v":"X170100101220"},{"$f":"CATEGORY!G60","v":"886745696551"},{"$f":"CATEGORY!H60","v":"FLEX ESC 22 W"},{"$f":"CATEGORY!I60","v":"CYAN/BLACK (01)"},{"$f":"+CATEGORY!N60","v":0},{"$f":"+CATEGORY!O60","v":0},{"$f":"+CATEGORY!P60","v":0},{"$f":"+CATEGORY!Q60","v":0},{"$f":"+CATEGORY!R60","v":0},{"$f":"+CATEGORY!S60","v":0}]
["886745698302",{"$f":"CATEGORY!F61","v":"X170101301240"},{"$f":"CATEGORY!G61","v":"886745698302"},{"$f":"CATEGORY!H61","v":"FLEX STP 24"},{"$f":"CATEGORY!I61","v":"BLACK/RED (01)"},{"$f":"+CATEGORY!N61","v":0},{"$f":"+CATEGORY!O61","v":0},{"$f":"+CATEGORY!P61","v":0},{"$f":"+CATEGORY!Q61","v":0},{"$f":"+CATEGORY!R61","v":0},{"$f":"+CATEGORY!S61","v":0}]
["886745838333",{"$f":"CATEGORY!F62","v":"X1901009018"},{"$f":"CATEGORY!G62","v":"886745838333"},{"$f":"CATEGORY!H62","v":"FLEX STP XL"},{"$f":"CATEGORY!I62","v":"BLACK/RED (01)"},{"$f":"+CATEGORY!N62","v":0},{"$f":"+CATEGORY!O62","v":0},{"$f":"+CATEGORY!P62","v":0},{"$f":"+CATEGORY!Q62","v":0},{"$f":"+CATEGORY!R62","v":0},{"$f":"+CATEGORY!S62","v":0}]
["886745697169",{"$f":"CATEGORY!F63","v":"X170101201220"},{"$f":"CATEGORY!G63","v":"886745697169"},{"$f":"CATEGORY!H63","v":"FLEX STP 22 W"},{"$f":"CATEGORY!I63","v":"BLACK/TEAL (01)"},{"$f":"+CATEGORY!N63","v":0},{"$f":"+CATEGORY!O63","v":0},{"$f":"+CATEGORY!P63","v":0},{"$f":"+CATEGORY!Q63","v":0},{"$f":"+CATEGORY!R63","v":0},{"$f":"+CATEGORY!S63","v":0}]
["886745975205",{"$f":"CATEGORY!F64","v":"X220101201220"},{"$f":"CATEGORY!G64","v":"886745975205"},{"$f":"CATEGORY!H64","v":"FLEX HKE"},{"$f":"CATEGORY!I64","v":"NO COLOR (01)"},{"$f":"+CATEGORY!N64","v":0},{"$f":"+CATEGORY!O64","v":0},{"$f":"+CATEGORY!P64","v":0},{"$f":"+CATEGORY!Q64","v":0},{"$f":"+CATEGORY!R64","v":0},{"$f":"+CATEGORY!S64","v":0}]
["886745975403",{"$f":"CATEGORY!F65","v":"X220101301210"},{"$f":"CATEGORY!G65","v":"886745975403"},{"$f":"CATEGORY!H65","v":"GLACIER"},{"$f":"CATEGORY!I65","v":"NO COLOR (01)"},{"$f":"+CATEGORY!N65","v":0},{"$f":"+CATEGORY!O65","v":0},{"$f":"+CATEGORY!P65","v":0},{"$f":"+CATEGORY!Q65","v":0},{"$f":"+CATEGORY!R65","v":0},{"$f":"+CATEGORY!S65","v":0}]
["886745780182",{"$f":"CATEGORY!F66","v":"X180102101190"},{"$f":"CATEGORY!G66","v":"886745780182"},{"$f":"CATEGORY!H66","v":"STORM"},{"$f":"CATEGORY!I66","v":"TEAL (01)"},{"$f":"+CATEGORY!N66","v":0},{"$f":"+CATEGORY!O66","v":0},{"$f":"+CATEGORY!P66","v":0},{"$f":"+CATEGORY!Q66","v":0},{"$f":"+CATEGORY!R66","v":0},{"$f":"+CATEGORY!S66","v":0}]
["886745837251",{"$f":"CATEGORY!F67","v":"X1901008010"},{"$f":"CATEGORY!G67","v":"886745837251"},{"$f":"CATEGORY!H67","v":"STORM"},{"$f":"CATEGORY!I67","v":"PURPLE (01)"},{"$f":"+CATEGORY!N67","v":0},{"$f":"+CATEGORY!O67","v":0},{"$f":"+CATEGORY!P67","v":0},{"$f":"+CATEGORY!Q67","v":0},{"$f":"+CATEGORY!R67","v":0},{"$f":"+CATEGORY!S67","v":0}]
["886745169901",{"$f":"CATEGORY!F68","v":"X130101001170"},{"$f":"CATEGORY!G68","v":"886745169901"},{"$f":"CATEGORY!H68","v":"FLEX JR"},{"$f":"CATEGORY!I68","v":"CYAN/BLACK (67896578476676656775)"},{"$f":"+CATEGORY!N68","v":0},{"$f":"+CATEGORY!O68","v":0},{"$f":"+CATEGORY!P68","v":0},{"$f":"+CATEGORY!Q68","v":0},{"$f":"+CATEGORY!R68","v":0},{"$f":"+CATEGORY!S68","v":0}]
["886745300298",{"$f":"CATEGORY!F69","v":"X140101001160"},{"$f":"CATEGORY!G69","v":"886745300298"},{"$f":"CATEGORY!H69","v":"SNOWGLOW"},{"$f":"CATEGORY!I69","v":"PEARL/GLOW (80696582764771767987)"},{"$f":"+CATEGORY!N69","v":0},{"$f":"+CATEGORY!O69","v":0},{"$f":"+CATEGORY!P69","v":0},{"$f":"+CATEGORY!Q69","v":0},{"$f":"+CATEGORY!R69","v":0},{"$f":"+CATEGORY!S69","v":0}]
["886745883715",{"$f":"CATEGORY!F70","v":"X200100101160"},{"$f":"CATEGORY!G70","v":"886745883715"},{"$f":"CATEGORY!H70","v":"SNOWBALL"},{"$f":"CATEGORY!I70","v":"NO COLOR (01)"},{"$f":"+CATEGORY!N70","v":0},{"$f":"+CATEGORY!O70","v":0},{"$f":"+CATEGORY!P70","v":0},{"$f":"+CATEGORY!Q70","v":0},{"$f":"+CATEGORY!R70","v":0},{"$f":"+CATEGORY!S70","v":0}]
["886745596479",{"$f":"CATEGORY!F71","v":"X160103201140"},{"$f":"CATEGORY!G71","v":"886745596479"},{"$f":"CATEGORY!H71","v":"SNOWFLAKE"},{"$f":"CATEGORY!I71","v":"RED/YELLOW/BLUE (01)"},{"$f":"+CATEGORY!N71","v":0},{"$f":"+CATEGORY!O71","v":0},{"$f":"+CATEGORY!P71","v":0},{"$f":"+CATEGORY!Q71","v":0},{"$f":"+CATEGORY!R71","v":0},{"$f":"+CATEGORY!S71","v":0}]
["886745995531",{"$f":"CATEGORY!F72","v":"X2202001010"},{"$f":"CATEGORY!G72","v":"886745995531"},{"$f":"CATEGORY!H72","v":"TUBBS TRAIL WALKING POLES- 2 PC"},{"$f":"CATEGORY!I72","v":"NO COLOR (01)"},{"$f":"+CATEGORY!N72","v":0},{"$f":"+CATEGORY!O72","v":0},{"$f":"+CATEGORY!P72","v":0},{"$f":"+CATEGORY!Q72","v":0},{"$f":"+CATEGORY!R72","v":0},{"$f":"+CATEGORY!S72","v":0}]
["886745991731",{"$f":"CATEGORY!F73","v":"X22010150122W"},{"$f":"CATEGORY!G73","v":"886745991731"},{"$f":"CATEGORY!H73","v":"FLEX TRK KIT W"},{"$f":"CATEGORY!I73","v":"NO COLOR (01)"},{"$f":"+CATEGORY!N73","v":0},{"$f":"+CATEGORY!O73","v":0},{"$f":"+CATEGORY!P73","v":0},{"$f":"+CATEGORY!Q73","v":0},{"$f":"+CATEGORY!R73","v":0},{"$f":"+CATEGORY!S73","v":0}]
["886745991724",{"$f":"CATEGORY!F74","v":"X220101501240"},{"$f":"CATEGORY!G74","v":"886745991724"},{"$f":"CATEGORY!H74","v":"FLEX TRK KIT"},{"$f":"CATEGORY!I74","v":"NO COLOR (01)"},{"$f":"+CATEGORY!N74","v":0},{"$f":"+CATEGORY!O74","v":0},{"$f":"+CATEGORY!P74","v":0},{"$f":"+CATEGORY!Q74","v":0},{"$f":"+CATEGORY!R74","v":0},{"$f":"+CATEGORY!S74","v":0}]
["886745820079",{"$f":"CATEGORY!F75","v":"X190100601250"},{"$f":"CATEGORY!G75","v":"886745820079"},{"$f":"CATEGORY!H75","v":"XPLORE KIT"},{"$f":"CATEGORY!I75","v":"SILVER/BLUE (01)"},{"$f":"+CATEGORY!N75","v":0},{"$f":"+CATEGORY!O75","v":0},{"$f":"+CATEGORY!P75","v":0},{"$f":"+CATEGORY!Q75","v":0},{"$f":"+CATEGORY!R75","v":0},{"$f":"+CATEGORY!S75","v":0}]
["886745819868",{"$f":"CATEGORY!F76","v":"X190100601300"},{"$f":"CATEGORY!G76","v":"886745819868"},{"$f":"CATEGORY!H76","v":"XPLORE KIT"},{"$f":"CATEGORY!I76","v":"SILVER/BLUE (01)"},{"$f":"+CATEGORY!N76","v":0},{"$f":"+CATEGORY!O76","v":0},{"$f":"+CATEGORY!P76","v":0},{"$f":"+CATEGORY!Q76","v":0},{"$f":"+CATEGORY!R76","v":0},{"$f":"+CATEGORY!S76","v":0}]
["886745819950",{"$f":"CATEGORY!F77","v":"X19010060121W"},{"$f":"CATEGORY!G77","v":"886745819950"},{"$f":"CATEGORY!H77","v":"XPLORE KIT W"},{"$f":"CATEGORY!I77","v":"RASBERRY RED (01)"},{"$f":"+CATEGORY!N77","v":0},{"$f":"+CATEGORY!O77","v":0},{"$f":"+CATEGORY!P77","v":0},{"$f":"+CATEGORY!Q77","v":0},{"$f":"+CATEGORY!R77","v":0},{"$f":"+CATEGORY!S77","v":0}]
["886745820109",{"$f":"CATEGORY!F78","v":"X19010060125W"},{"$f":"CATEGORY!G78","v":"886745820109"},{"$f":"CATEGORY!H78","v":"XPLORE KIT W"},{"$f":"CATEGORY!I78","v":"RASBERRY RED (01)"},{"$f":"+CATEGORY!N78","v":0},{"$f":"+CATEGORY!O78","v":0},{"$f":"+CATEGORY!P78","v":0},{"$f":"+CATEGORY!Q78","v":0},{"$f":"+CATEGORY!R78","v":0},{"$f":"+CATEGORY!S78","v":0}]
["886745719908",{"$f":"CATEGORY!F79","v":"X170101601220"},{"$f":"CATEGORY!G79","v":"886745719908"},{"$f":"CATEGORY!H79","v":"FLEX STP KIT 22 W"},{"$f":"CATEGORY!I79","v":"BLACK/TEAL (01)"},{"$f":"+CATEGORY!N79","v":0},{"$f":"+CATEGORY!O79","v":0},{"$f":"+CATEGORY!P79","v":0},{"$f":"+CATEGORY!Q79","v":0},{"$f":"+CATEGORY!R79","v":0},{"$f":"+CATEGORY!S79","v":0}]
["886745719847",{"$f":"CATEGORY!F80","v":"X170101701240"},{"$f":"CATEGORY!G80","v":"886745719847"},{"$f":"CATEGORY!H80","v":"FLEX STP KIT 24"},{"$f":"CATEGORY!I80","v":"BLACK/RED (01)"},{"$f":"+CATEGORY!N80","v":0},{"$f":"+CATEGORY!O80","v":0},{"$f":"+CATEGORY!P80","v":0},{"$f":"+CATEGORY!Q80","v":0},{"$f":"+CATEGORY!R80","v":0},{"$f":"+CATEGORY!S80","v":0}]
["886745169932",{"$f":"CATEGORY!F81","v":"X1303001010"},{"$f":"CATEGORY!G81","v":"886745169932"},{"$f":"CATEGORY!H81","v":"TUBBS SNOWSHOE HOLSTER"},{"$f":"CATEGORY!I81","v":"BLACK (6676656775)"},{"$f":"+CATEGORY!N81","v":0},{"$f":"+CATEGORY!O81","v":0},{"$f":"+CATEGORY!P81","v":0},{"$f":"+CATEGORY!Q81","v":0},{"$f":"+CATEGORY!R81","v":0},{"$f":"+CATEGORY!S81","v":0}]
["714636638529",{"$f":"CATEGORY!F82","v":"X10500192"},{"$f":"CATEGORY!G82","v":"714636638529"},{"$f":"CATEGORY!H82","v":"SNOWSHOE_BAG"},{"$f":"CATEGORY!I82","v":"GRAY (71826589)"},{"$f":"+CATEGORY!N82","v":0},{"$f":"+CATEGORY!O82","v":0},{"$f":"+CATEGORY!P82","v":0},{"$f":"+CATEGORY!Q82","v":0},{"$f":"+CATEGORY!R82","v":0},{"$f":"+CATEGORY!S82","v":0}]
["714636638536",{"$f":"CATEGORY!F83","v":"X10500194"},{"$f":"CATEGORY!G83","v":"714636638536"},{"$f":"CATEGORY!H83","v":"SNOWSHOE_BAG"},{"$f":"CATEGORY!I83","v":"GRAY (71826589)"},{"$f":"+CATEGORY!N83","v":0},{"$f":"+CATEGORY!O83","v":0},{"$f":"+CATEGORY!P83","v":0},{"$f":"+CATEGORY!Q83","v":0},{"$f":"+CATEGORY!R83","v":0},{"$f":"+CATEGORY!S83","v":0}]
["714636638543",{"$f":"CATEGORY!F84","v":"X10500196"},{"$f":"CATEGORY!G84","v":"714636638543"},{"$f":"CATEGORY!H84","v":"SNOWSHOE_BAG"},{"$f":"CATEGORY!I84","v":"GRAY (71826589)"},{"$f":"+CATEGORY!N84","v":0},{"$f":"+CATEGORY!O84","v":0},{"$f":"+CATEGORY!P84","v":0},{"$f":"+CATEGORY!Q84","v":0},{"$f":"+CATEGORY!R84","v":0},{"$f":"+CATEGORY!S84","v":0}]
["886745011101",{"$f":"CATEGORY!F85","v":"X1203002010"},{"$f":"CATEGORY!G85","v":"886745011101"},{"$f":"CATEGORY!H85","v":"MENS SNOWSHOE GAITERS"},{"$f":"CATEGORY!I85","v":"BLACK (6676656775)"},{"$f":"+CATEGORY!N85","v":0},{"$f":"+CATEGORY!O85","v":0},{"$f":"+CATEGORY!P85","v":0},{"$f":"+CATEGORY!Q85","v":0},{"$f":"+CATEGORY!R85","v":0},{"$f":"+CATEGORY!S85","v":0}]
["714636952946",{"$f":"CATEGORY!F86","v":"X1203001010"},{"$f":"CATEGORY!G86","v":"714636952946"},{"$f":"CATEGORY!H86","v":"WOMENS SNOWSHOE GAITERS"},{"$f":"CATEGORY!I86","v":"BLACK/GRAY (66766567754771826589)"},{"$f":"+CATEGORY!N86","v":0},{"$f":"+CATEGORY!O86","v":0},{"$f":"+CATEGORY!P86","v":0},{"$f":"+CATEGORY!Q86","v":0},{"$f":"+CATEGORY!R86","v":0},{"$f":"+CATEGORY!S86","v":0}]

{"sheet":"Upload","index":3,"n_rows":9,"n_cols":28,"rows_kept":9,"hidden":true,"merged":[[4,8,4,9],[4,11,4,12],[4,14,4,15],[4,17,4,18],[4,20,4,21],[4,23,4,24],[7,8,7,9],[7,11,7,12],[7,14,7,15],[7,17,7,18],[7,20,7,21],[7,23,7,24],[7,26,7,27]]}
[null,null,"UPLOAD"," ",{"$nulls":3},"*The blue \"filter\" button will exclude each UPC with a qty of 0 and include any qty above 0"]
[null,null,"Account Name",{"$nulls":4},"*The red \"unfilter\" button will allow to view all UPC's and this step MUST be done before each upload into DB"]
[]
[]
[{"$nulls":3}," "," "," ",null,null,"Filter qty(s) to Upload",null,null,"Filter qty(s) to Upload",null,null,"Filter qty(s) to Upload",null,null,"Filter qty(s) to Upload",null,null,"Filter qty(s) to Upload",null,null,"Filter qty(s) to Upload"]
[{"$nulls":5},"_________",null,null,"_________","_________",null,"_________","_________",null,"_________","_________",null,"_________","_________",null,"_________","_________",null,"_________","_________",null,"_________"," _______"]
[]
[{"$nulls":8},"DELIVERY  1",null,null,"DELIVERY  2",null,null,"DELIVERY 3",null,null,"DELIVERY 4",null,null,"DELIVERY  5",null,null,"DELIVERY  6",null,null,"TOTAL"]
["SKU","UPC","Product Group","Style","Description","Color","Earliest CRD",null,"UPC"," QTY",null,"UPC"," QTY",null,"UPC"," QTY",null,"UPC"," QTY",null,"UPC"," QTY",null,"UPC"," QTY",null,"UPC"," QTY"]

{"sheet":"CategoryTemplate","index":4,"n_rows":10,"n_cols":21,"rows_kept":10,"hidden":true,"merged":[[7,6,7,7],[8,6,8,7]]}
[{"$nulls":6}," "]
[]
[]
[]
[{"$nulls":13},"Order 1","Order 2","Order 3","Order 4","Order 5","Order 6"]
[{"$nulls":6}," "," "," ",null,"Ship To*"]
[{"$nulls":6}," "," "," ",null,"Ship Date*"]
[{"$nulls":6}," Total {0} Units",null,null," ","PO Number*"]
[{"$nulls":6},"Total {0} Order Value",null,{"$f":"SUM(N9:S9)","v":{"v":0,"d":"0.00"}}," ","Sub-Totals"]
[null,"CategoryID","SKU","UPC","Product Category","SKU","UPC","Description","Color","Size","Price WS","MAP","Order History","Order 1","Order 2","Order 3","Order 4","Order 5","Order 6","Style Total Units","Style Total Value"]

{"sheet":"SoldToShipTo","index":5,"n_rows":21,"n_cols":18,"rows_kept":21,"hidden":true}
["SoldTo","SoldToName","ShipTo","SoldToAddress","ShipToDisplayAs","ShipToName","ShipToAddress","ShipToAddress1","ShipToAddress2","ShipToAddress3","ShipToCity","ShipToStateProvince","ShipToPostalCode","SoldToCountry","ShipToCountry","SoldToCity","SoldToState"]
["119792","PENINSULA","119793","PENINSULA BOUTIQUE, LLC","PENINSULA","PENINSULA"," BOYNE CITY MI","","","","BOYNE CITY","MI","49712","","","BOYNE CITY","MI",""]
["119869","ATMOSPHERE MOUNTAINWORKS LLC","119869","210 2ND ST","ATMOSPHERE MOUNTAINWORKS LLC","ATMOSPHERE MOUNTAINWORKS LLC"," LARAMIE WY","","","","LARAMIE","WY","82070","","","LARAMIE","WY",""]
["119874","WILD ERNEST SPORTS","119874","14 FAWN COURT","WILD ERNEST SPORTS","WILD ERNEST SPORTS"," SILVERTHORNE CO","","","","SILVERTHORNE","CO","80498","","","SILVERTHORNE","CO",""]
["119902","ASHCROFT SKI TOURING UNIT INC.","119903","PO BOX 7931","ASHCROFT SKI TOURING","ASHCROFT SKI TOURING"," ASPEN CO","","","","ASPEN","CO","81611","","","ASPEN","CO",""]
["X01","DANE STEPHENSON","X01 + X01","","DANE STEPHENSON","DANE STEPHENSON","","","","","","","","","","","",""]
["X02","MIKE ROSEN","X02 + X02","","MIKE ROSEN","MIKE ROSEN","","","","","","","","","","","",""]
["X03","MARK VAUGHN","X03 + X03","","MARK VAUGHN","MARK VAUGHN","","","","","","","","","","","",""]
["X04","BRUCE MARSH","X04 + X04","","BRUCE MARSH","BRUCE MARSH","","","","","","","","","","","",""]
["X05","TOM LAWRENCE","X05 + X05","","TOM LAWRENCE","TOM LAWRENCE","","","","","","","","","","","",""]
["X06","RENE KNUDSEN","X06 + X06","","RENE KNUDSEN","RENE KNUDSEN","","","","","","","","","","","",""]
["X07","MIKE SCHMIDT","X07 + X07","","MIKE SCHMIDT","MIKE SCHMIDT","","","","","","","","","","","",""]
["X08","JEFF DARBY","X08 + X08","","JEFF DARBY","JEFF DARBY","","","","","","","","","","","",""]
["X09","AVAILABLE","X09 + X09","","AVAILABLE","AVAILABLE","","","","","","","","","","","",""]
["X10","SCOTT SQUIRES","X10 + X10","","SCOTT SQUIRES","SCOTT SQUIRES","","","","","","","","","","","",""]
["X11","DAVE EGAN","X11 + X11","","DAVE EGAN","DAVE EGAN","","","","","","","","","","","",""]
["X15","AVAILABLE","X15 + X15","","AVAILABLE","AVAILABLE","","","","","","","","","","","",""]
["X96","SALES MANAGER","X96 + X96","","SALES MANAGER","SALES MANAGER","","","","","","","","","","","",""]
["X97","WARRANTY","X97 + X97","","WARRANTY","WARRANTY","","","","","","","","","","","",""]
["X98","NO REP","X98 + X98","","NO REP","NO REP","","","","","","","","","","","",""]
["X99","HOUSE","X99 + X99","","HOUSE","HOUSE","","","","","","","","","","","",""]

{"sheet":"GlobalVariables","index":6,"n_rows":200,"n_cols":7,"rows_kept":200,"hidden":true}
["OLOFType","Tabular","X04_Tubbs2223.xlsm","2/6/2022 1:16:39 PM"]
[" "]
["BookingCatalog","0",null,null," "," "," "]
["DateShipStart","2022/6/1",null,null," "," "," "]
["DateShipEnd","2023/3/1",null,null," "," "," "]
["ReqDateDays","-1",null,null," "," "," "]
["ReqDefaultDays","0",null,null," "," "," "]
["CancelDateDays","14",null,null," "," "," "]
["CancelDefaultDays","-1"]
["CategoryNumbers","5"]
["ShipWindowNumbers","6"]
["QtyColumns","N|O|P|Q|R|S"]
["PriceColumnName","K"]
[null,"1"]
["PONumber Regex","/[*&]/gi"]
["isPoRequired","1"]
["isPoUnique","1"]
["isPOUpper","1"]
[null," "]
[null,"0"]
[null," "]
[null," "]
{"$rows_empty":177}
[null,"Plumriver"]

{"sheet":"ShipMethods","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}

{"sheet":"ProductLine_Style","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}

{"sheet":"CellStyle","index":9,"n_rows":3,"n_cols":1,"rows_kept":3,"hidden":true}
[]
[]
["bolder10"]

{"sheet":"CategoryList","index":10,"n_rows":6,"n_cols":9,"rows_kept":6,"hidden":true}
["CategoryID","Category","ParentID","ParentCategory","CategoryRow","SKUBeginRow","SKUEndRow","SKURowNumber","IsTopLevel"]
["1","CATEGORY","","","0","0","0","76","1"]
["32","Snowshoe","1","CATEGORY","88","11","71","0","0"]
["20","Poles","1","CATEGORY","89","72","72","0","0"]
["16","Kits","1","CATEGORY","90","73","80","0","0"]
["2","Accessories","1","CATEGORY","91","81","86","0","0"]

{"sheet":"CATEGORY","index":11,"n_rows":91,"n_cols":21,"rows_kept":91,"merged":[[7,6,7,7],[8,6,8,7]]}
[{"$nulls":6}," "]
[]
[]
[]
[{"$nulls":13},"Order 1","Order 2","Order 3","Order 4","Order 5","Order 6"]
[{"$nulls":6}," "," "," ",null,"Ship To*",null,null,{"$f":"Summary!D13&\"\"","v":""},{"$f":"Summary!F13&\"\"","v":""},{"$f":"Summary!H13&\"\"","v":""},{"$f":"Summary!J13&\"\"","v":""},{"$f":"Summary!L13&\"\"","v":""},{"$f":"Summary!N13&\"\"","v":""}]
[{"$nulls":6}," "," "," ",null,"Ship Date*",null,null,{"$f":"Summary!D14","v":"2022-06-01"},{"$f":"Summary!F14","v":"00:00:00"},{"$f":"Summary!H14","v":"00:00:00"},{"$f":"Summary!J14","v":"00:00:00"},{"$f":"Summary!L14","v":"00:00:00"},{"$f":"Summary!N14","v":"00:00:00"}]
[{"$nulls":6}," Total CATEGORY Units",null,{"$f":"SUM(T11:T86)","v":0}," ","PO Number*",null,null,{"$f":"Summary!D15&\"\"","v":""},{"$f":"Summary!F15&\"\"","v":""},{"$f":"Summary!H15&\"\"","v":""},{"$f":"Summary!J15&\"\"","v":""},{"$f":"Summary!L15&\"\"","v":""},{"$f":"Summary!N15&\"\"","v":""}]
[{"$nulls":6},"Total CATEGORY Order Value",null,{"$f":"SUM(N9:S9)","v":{"v":0,"d":"0.00"}},"USD","Sub-Totals",null,null,{"$f":"SUMPRODUCT(K11:K86,N11:N86)","v":{"v":0,"d":"0.00"}},{"$f":"SUMPRODUCT(K11:K86,O11:O86)","v":{"v":0,"d":"0.00"}},{"$f":"SUMPRODUCT(K11:K86,P11:P86)","v":{"v":0,"d":"0.00"}},{"$f":"SUMPRODUCT(K11:K86,Q11:Q86)","v":{"v":0,"d":"0.00"}},{"$f":"SUMPRODUCT(K11:K86,R11:R86)","v":{"v":0,"d":"0.00"}},{"$f":"SUMPRODUCT(K11:K86,S11:S86)","v":{"v":0,"d":"0.00"}},"USD"]
[null,"CategoryID","SKU","UPC","Product Category","SKU","UPC","Description","Color","Size","Price WS","MAP","Order History","Order 1","Order 2","Order 3","Order 4","Order 5","Order 6","Total Units","Total Value"]
["","Tubbs2223","32","X1901001","Snowshoe","X190100101250","886745820246","MOUNTAINEER","GREEN (01)","25",{"v":173,"d":"173.00"},279.95,"",{"$nulls":6},{"$f":"SUM(N11:S11)","v":0},{"$f":"SUMPRODUCT(K11:K11,T11:T11)","v":{"v":0,"d":"0.00"}}]
["","Tubbs2223","32","X1901001","Snowshoe","X190100101300","886745819899","MOUNTAINEER","GREEN (01)","30",{"v":173,"d":"173.00"},279.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X1901001","Snowshoe","X190100101360","886745820154","MOUNTAINEER","GREEN (01)","36",{"v":173,"d":"173.00"},279.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X1901001W","Snowshoe","X19010010121W","886745820260","MOUNTAINEER W","PURPLE (01)","21 W",{"v":173,"d":"173.00"},279.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X1901001W","Snowshoe","X19010010125W","886745819981","MOUNTAINEER W","PURPLE (01)","25 W",{"v":173,"d":"173.00"},279.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X1901001W","Snowshoe","X19010010130W","886745886082","MOUNTAINEER W","PURPLE (01)","30 W",{"v":173,"d":"173.00"},279.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X2201002","Snowshoe","X220100201250","886745975083","FLEX VRT","YELLOW (01)","25",{"v":173,"d":"173.00"},279.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X2201002","Snowshoe","X220100201290","886745975748","FLEX VRT","YELLOW (01)","29",{"v":173,"d":"173.00"},279.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X2201004","Snowshoe","X220100401250","886745974628","FLEX ALP","WHITE (01)","25",{"v":160,"d":"160.00"},259.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X2201004","Snowshoe","X220100401290","886745975687","FLEX ALP","WHITE (01)","29",{"v":160,"d":"160.00"},259.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X1801015","Snowshoe","X180101501250","886745780175","PANORAMIC","BLACK/RED (01)","25",{"v":167,"d":"167.00"},269.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X1801015","Snowshoe","X180101501300","886745780205","PANORAMIC","BLACK/RED (01)","30",{"v":167,"d":"167.00"},269.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X1801015","Snowshoe","X180101501360","886745780083","PANORAMIC","BLACK/RED (01)","36",{"v":167,"d":"167.00"},269.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X1801015W","Snowshoe","X18010150121W","886745780267","PANORAMIC W","GREY/ICE BLUE (01)","21 W",{"v":167,"d":"167.00"},269.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X1801015W","Snowshoe","X18010150125W","886745779988","PANORAMIC W","GREY/ICE BLUE (01)","25 W",{"v":167,"d":"167.00"},269.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X1801015W","Snowshoe","X18010150130W","886745886174","PANORAMIC W","GREY/ICE BLUE (01)","30 W",{"v":167,"d":"167.00"},269.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X2201008","Snowshoe","X220100801250","886745975724","WILDERNESS","BLACK (01)","25",{"v":136,"d":"136.00"},219.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X2201008","Snowshoe","X220100801300","886745975113","WILDERNESS","BLACK (01)","30",{"v":136,"d":"136.00"},219.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X2201008","Snowshoe","X220100801360","886745974871","WILDERNESS","BLACK (01)","36",{"v":136,"d":"136.00"},219.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X2201008","Snowshoe","X220100802250","886745974550","WILDERNESS","BLUE (02)","25",{"v":136,"d":"136.00"},219.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X2201008","Snowshoe","X220100802300","886745975632","WILDERNESS","BLUE (02)","30",{"v":136,"d":"136.00"},219.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X2201008","Snowshoe","X220100802360","886745975885","WILDERNESS","BLUE (02)","36",{"v":136,"d":"136.00"},219.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X2201009W","Snowshoe","X22010090121W","886745975977","WILDERNESS W","NO COLOR (01)","21 W",{"v":136,"d":"136.00"},219.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X2201009W","Snowshoe","X22010090125W","886745975779","WILDERNESS W","NO COLOR (01)","25 W",{"v":136,"d":"136.00"},219.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X2201009W","Snowshoe","X22010090130W","886745974260","WILDERNESS W","NO COLOR (01)","30 W",{"v":136,"d":"136.00"},219.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X1801020","Snowshoe","X180102001240","886745780397","FLEX RDG 24 LLB","BLACK/GREEN (01)","24",{"v":124,"d":"124.00"},199.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X1801020W","Snowshoe","X18010200122W","886745779971","FLEX RDG W","BLACK/BLUE (01)","22 W",{"v":124,"d":"124.00"},199.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X2201006","Snowshoe","X220100601240","886745974987","FLEX TRK","NO COLOR (01)","24",{"v":105,"d":"105.00"},169.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X2201007W","Snowshoe","X22010070122W","886745974772","FLEX TRK W","NO COLOR (01)","22 W",{"v":105,"d":"105.00"},169.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X2001004","Snowshoe","X200100401250","886745883111","WAYFINDER","RED/BLACK (01)","25",{"v":125,"d":"125.00"},199.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X2001004","Snowshoe","X200100401300","886745882978","WAYFINDER","RED/BLACK (01)","30",{"v":125,"d":"125.00"},199.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X2001004","Snowshoe","X200100401360","886745884118","WAYFINDER","RED/BLACK (01)","36",{"v":125,"d":"125.00"},199.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X2001004W","Snowshoe","X20010040121W","886745884040","WAYFINDER W","PURPLE (01)","21 W",{"v":125,"d":"125.00"},199.95,"",{"$nulls":6},{"$f":"SUM(N43:S43)","v":0},{"$f":"SUMPRODUCT(K43:K43,T43:T43)","v":{"v":0,"d":"0.00"}}]
["","Tubbs2223","32","X2001004W","Snowshoe","X20010040125W","886745884064","WAYFINDER W","PURPLE (01)","25 W",{"v":125,"d":"125.00"},199.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X2001003","Snowshoe","X200100302250","886745894254","FRONTIER","BLACK (02)","25",{"v":111,"d":"111.00"},179.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X2001003","Snowshoe","X200100302300","886745894209","FRONTIER","BLACK (02)","30",{"v":111,"d":"111.00"},179.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X2001003","Snowshoe","X200100302360","886745894483","FRONTIER","BLACK (02)","36",{"v":111,"d":"111.00"},179.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X2001003","Snowshoe","X200100301250","886745883128","FRONTIER","FOREST (01)","25",{"v":111,"d":"111.00"},179.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X2001003","Snowshoe","X200100301300","886745883517","FRONTIER","FOREST (01)","30",{"v":111,"d":"111.00"},179.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X2001003","Snowshoe","X200100301360","886745883951","FRONTIER","FOREST (01)","36",{"v":111,"d":"111.00"},179.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X2001003W","Snowshoe","X20010030121W","886745883777","FRONTIER W","CORAL (01)","21 W",{"v":111,"d":"111.00"},179.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X2001003W","Snowshoe","X20010030125W","886745884187","FRONTIER W","CORAL (01)","25 W",{"v":111,"d":"111.00"},179.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X2001003W","Snowshoe","X20010030130W","886745883906","FRONTIER W","CORAL (01)","30 W",{"v":111,"d":"111.00"},179.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X1901002","Snowshoe","X190100201250","886745819967","XPLORE","SILVER/BLUE (01)","25",{"v":93,"d":"93.00"},149.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X1901002","Snowshoe","X190100201300","886745819875","XPLORE","SILVER/BLUE (01)","30",{"v":93,"d":"93.00"},149.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X1901002W","Snowshoe","X19010020121W","886745820086","XPLORE W","RASBERRY RED (01)","21 W",{"v":93,"d":"93.00"},149.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X1901002W","Snowshoe","X19010020125W","886745819882","XPLORE W","RASBERRY RED (01)","25 W",{"v":93,"d":"93.00"},149.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X1701002","Snowshoe","X170100201240","886745700876","FLEX ESC 24","CYAN/BLACK (01)","24",{"v":87,"d":"87.00"},139.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X1901010","Snowshoe","X1901010018","886745838258","FLEX ESC XL","CYAN/BLACK (01)","XL",{"v":87,"d":"87.00"},139.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X1701001","Snowshoe","X170100101220","886745696551","FLEX ESC 22 W","CYAN/BLACK (01)","22",{"v":87,"d":"87.00"},139.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X1701013","Snowshoe","X170101301240","886745698302","FLEX STP 24","BLACK/RED (01)","24",{"v":68,"d":"68.00"},99.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X1901009","Snowshoe","X1901009018","886745838333","FLEX STP XL","BLACK/RED (01)","XL",{"v":68,"d":"68.00"},99.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X1701012","Snowshoe","X170101201220","886745697169","FLEX STP 22 W","BLACK/TEAL (01)","22",{"v":68,"d":"68.00"},99.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X2201012","Snowshoe","X220101201220","886745975205","FLEX HKE","NO COLOR (01)","22",{"v":62,"d":"62.00"},99.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X2201013","Snowshoe","X220101301210","886745975403","GLACIER","NO COLOR (01)","21",{"v":62,"d":"62.00"},99.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X1801021","Snowshoe","X180102101190","886745780182","STORM","TEAL (01)","19",{"v":56,"d":"56.00"},89.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X1901008","Snowshoe","X1901008010","886745837251","STORM","PURPLE (01)","1SZ",{"v":56,"d":"56.00"},89.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X1301010","Snowshoe","X130101001170","886745169901","FLEX JR","CYAN/BLACK (67896578476676656775)","17",{"v":44,"d":"44.00"},69.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X1401010","Snowshoe","X140101001160","886745300298","SNOWGLOW","PEARL/GLOW (80696582764771767987)","16",{"v":37,"d":"37.00"},59.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X2001001","Snowshoe","X200100101160","886745883715","SNOWBALL","NO COLOR (01)","16",{"v":34,"d":"34.00"},54.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","32","X1601032","Snowshoe","X160103201140","886745596479","SNOWFLAKE","RED/YELLOW/BLUE (01)","14",{"v":28,"d":"28.00"},44.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","20","X2202001","Poles","X2202001010","886745995531","TUBBS TRAIL WALKING POLES- 2 PC","NO COLOR (01)","1SZ",{"v":30,"d":"30.00"},49.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","16","X2201015W","Kits","X22010150122W","886745991731","FLEX TRK KIT W","NO COLOR (01)","22 W",{"v":142,"d":"142.00"},229.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","16","X2201015","Kits","X220101501240","886745991724","FLEX TRK KIT","NO COLOR (01)","24",{"v":142,"d":"142.00"},229.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","16","X1901006","Kits","X190100601250","886745820079","XPLORE KIT","SILVER/BLUE (01)","25",{"v":123,"d":"123.00"},199.95,"",{"$nulls":6},{"$f":"SUM(N75:S75)","v":0},{"$f":"SUMPRODUCT(K75:K75,T75:T75)","v":{"v":0,"d":"0.00"}}]
["","Tubbs2223","16","X1901006","Kits","X190100601300","886745819868","XPLORE KIT","SILVER/BLUE (01)","30",{"v":123,"d":"123.00"},199.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","16","X1901006W","Kits","X19010060121W","886745819950","XPLORE KIT W","RASBERRY RED (01)","21 W",{"v":123,"d":"123.00"},199.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","16","X1901006W","Kits","X19010060125W","886745820109","XPLORE KIT W","RASBERRY RED (01)","25 W",{"v":123,"d":"123.00"},199.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","16","X1701016","Kits","X170101601220","886745719908","FLEX STP KIT 22 W","BLACK/TEAL (01)","22",{"v":105,"d":"105.00"},169.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","16","X1701017","Kits","X170101701240","886745719847","FLEX STP KIT 24","BLACK/RED (01)","24",{"v":105,"d":"105.00"},169.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","2","X1303001","Accessories","X1303001010","886745169932","TUBBS SNOWSHOE HOLSTER","BLACK (6676656775)","1SZ",{"v":18,"d":"18.00"},29.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","2","X1050019","Accessories","X10500192","714636638529","SNOWSHOE_BAG","GRAY (71826589)","S",{"v":27,"d":"27.00"},44.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","2","X1050019","Accessories","X10500194","714636638536","SNOWSHOE_BAG","GRAY (71826589)","M",{"v":27,"d":"27.00"},44.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","2","X1050019","Accessories","X10500196","714636638543","SNOWSHOE_BAG","GRAY (71826589)","L",{"v":27,"d":"27.00"},44.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","2","X1203002","Accessories","X1203002010","886745011101","MENS SNOWSHOE GAITERS","BLACK (6676656775)","1SZ",{"v":21,"d":"21.00"},34.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","Tubbs2223","2","X1203001","Accessories","X1203001010","714636952946","WOMENS SNOWSHOE GAITERS","BLACK/GRAY (66766567754771826589)","1SZ",{"v":21,"d":"21.00"},34.95,"",{"$nulls":6},0,{"v":0,"d":"0.00"}]
["","","","","","","","","","","","","","","","","","","","",""]
["","32","","","Snowshoe","","","","","","","","",{"$f":"SUM(N11:N71)","v":0},0,0,0,0,0,0,{"v":0,"d":"0.00"}]
["","20","","","Poles","","","","","","","","",{"$f":"SUM(N72:N72)","v":0},0,0,0,0,0,0,{"v":0,"d":"0.00"}]
["","16","","","Kits","","","","","","","","",{"$f":"SUM(N73:N80)","v":0},0,0,0,0,0,0,{"v":0,"d":"0.00"}]
["","2","","","Accessories","","","","","","","","",{"$f":"SUM(N81:N86)","v":0},0,0,0,0,0,0,{"v":0,"d":"0.00"}]

{"sheet":"HistoryData","index":12,"n_rows":1,"n_cols":3,"rows_kept":1,"hidden":true}
["SKU","Description","History Quantity"]

{"sheet":"Instructions","index":13,"n_rows":57,"n_cols":1,"rows_kept":57}
[]
[]
["Offline Order Tool Instructions:"]
[]
["SUMMARY TAB"]
["Mandatory Fields:"]
["1. ACCOUNT NUMBER: Enter the Account Number of the retailer in the Account No. field."]
["2. SHIP TO: Select a Ship To Number for each Ship Date entered"]
["3. SHIP DATE:  Enter one or more Ship Dates (make sure to tab off the date to accept the date entry.)  NOTE: You may have the same Ship Date in multiple columns"]
["4. PO NUMBER: Enter a PO Number for each Ship Date  (Note: PO Number must be unique for each ship date)"]
["Optional Fields:"]
["1. COMMENTS: Any notes or comments can be entered here"]
["2. DEADLINE: If you wish to have the deadlines populated in the tool"]
["3. REQUESTED DELIVER DATE: to inform the user of the CRD for the season"]
["Notes:"]
["1.  Summary information MUST BE populated before entering quantities into the the product tabs.  All tab columns are protected until Ship dates are entered"]
["2.  All gray fields in the Summary tab are auto-populated fields and cannot be edited by the user."]
["3.  Ship dates dictate when a product can be ordered and will \"un-protect\" the columns in the product tabs"]
[]
["PRODUCT TABS"]
["Mandatory Fields:"]
["1. None"]
["Notes:"]
["1.  To search for a specific product within the workbook - do a ctrl F, Click on OPTIONS, Type in the product in the \"Find What\" field, Select WORKBOOK in the \"Within\" field"]
[]
[]
["UPLOAD TAB"]
["TWO Options To upload the Spreadsheet... "]
["1. Upload from your saved file"]
["i.  Once you have saved your spreadsheet to your computer, make sure that you close the spreadsheet.  You will receive an error when trying to load the spreadsheet if it is opened."]
["ii.  Login "]
["iii. Go to the Product Catalog page and select the Quick Web Order tab.  Click on the Upload link at the bottom of the page."]
["iv.  Add files from your computer and then Start Upload."]
["v.  If there are no problems with your order(s), they will be listed as a Working Order for the Customer.  "]
["vi.  If any issues are present you will receive an email message detailing the issues.  You can make necessary corrections and upload the spreadsheet again."]
[]
["2. Use the Upload Tab format"]
["i.  Once you have saved your spreadsheet, go to the UPLOAD tab to upload your order"]
["ii. Filter the delivery to upload by clicking on the blue filter button above the column to upload.  (this command eliminates all 0 qty)"]
["iii. Copy the UPC and qty and paste into the QUICK WEB ORDER screen "]
["    To upload an addiotnal delivery YOU MUST…."]
["i. Unfilter the previous delivery by selecting the red unfilter button above the column that is filtered."]
["ii.  Filter the new delivery by clicking on the filter button above the new column to be uploaded."]
[]
[]
[]
["2. Set Macro Security (from the menu at the top of the page)"]
["a. Developer, Macro Security, Macro Settings, select radio button for \"Enable All Macros\" "]
["b. Click OK"]
["d. Close and then re-open the Offline Order Form"]
[]
["3. If after making the above Macro Security Setting change you are still unable to see Customer's address, Ship Date Comment, Ship To popup etc, then from the top of the page,"]
["a. Select Office 2007 button, Choose Excel Options, Select Ad-ins"]
["b. Near bottom of page for Manage drop-down select  \"Excel Add-ins\", and click GO"]
["c. Select \" Analysis Tool Pack\" and \"Analysis Tool Pack – VBA\" from list"]
["d. Click OK"]
["e. Close and then re-open the Offline Order Form"]