{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Customer Info","OrderForm"],"not_rendered":{"images":3,"macros":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":11,"n_cols":2,"rows_kept":11,"merged":[[0,0,0,1],[1,0,1,1]]}
["Using the Order Form"]
["Step by Step"]
[1,"Open F21 Order Form"]
[2,"When prompted click Enable Macros"]
[3,"Click the Customer Info tab (adjacent to instructions tab)"]
[4,"Enter your store information (yellow areas)"]
[5,"If the shipping address is the same as the billing address click the Copy to Ship to button. Otherwise  manually enter the ship to address in the ship to address box."]
[6,"Input your PO # and ship date for each ship month"]
[7,"Click the Order Form tab (adjacent to Customer Info tab) to open the order form."]
[8,"Enter your order using the appropriate column for each ship month."]
[9,"Once you have completed entering your order save the file as your store name.xlsm (ex. Outdoorshop.xlsm) - please save as a macro enabled workbook!"]

{"sheet":"Customer Info","index":1,"n_rows":57,"n_cols":2,"rows_kept":57,"merged":[[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,0,3,1],[4,0,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[11,0,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[47,1,47,2],[48,1,48,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[53,1,53,2],[55,1,55,2],[56,1,56,2]]}
["Mountainsmith Spring F21 PRSN"]
["Valid on Shipments"]
["7/15/2021-12/31/2021"]
["Customer Name:"]
["Bill to address:"]
["Street/Box #"]
["Suite/Unit #"]
["City"]
["State"]
["Zip Code"]
[]
["Ship to address:"]
["Store Name"]
["Street Address"]
["Suite/Unit #"]
["City"]
["State"]
["Zip Code"]
[]
[{"$f":"OrderForm!F6","v":"July"}]
["PO #"]
["Ship Date"]
["Cancel date"]
["Order Total",{"$f":"OrderForm!F3","v":{"v":0,"d":"$0.00"}}]
["Terms"]
[{"$f":"OrderForm!G6","v":"August"}]
["PO #"]
["Ship Date"]
["Cancel date"]
["Order Total",{"$f":"OrderForm!G3","v":{"v":0,"d":"$0.00"}}]
["Terms"]
[{"$f":"OrderForm!H6","v":"September"}]
["PO #"]
["Ship Date"]
["Cancel date"]
["Order Total",{"$f":"OrderForm!H3","v":{"v":0,"d":"$0.00"}}]
["Terms"]
[{"$f":"OrderForm!I6","v":"October"}]
["PO #"]
["Ship Date"]
["Cancel date"]
["Order Total",{"$f":"OrderForm!I3","v":{"v":0,"d":"$0.00"}}]
["Terms"]
[{"$f":"OrderForm!J6","v":"November"}]
["PO #"]
["Ship Date"]
["Cancel date"]
["Order Total",{"$f":"OrderForm!J3","v":{"v":0,"d":"$0.00"}}]
["Terms"]
[{"$f":"OrderForm!K6","v":"December"}]
["PO #"]
["Ship Date"]
["Cancel date"]
["Order Total",{"$f":"OrderForm!K3","v":{"v":0,"d":"$0.00"}}]
[]
["Grand Total",{"$f":"OrderForm!L3","v":0}]
["Terms",{"$f":"IF(OrderForm!L3>10000,\"8% Net 60\",IF(AND(OrderForm!L3>=5000,OrderForm!L3<=9999),\"6% Net 60\",IF(AND(OrderForm!L3>=1000,OrderForm!L3<=4999),\"4% Net 60\",\"Order Minumum Not Met\")))","v":"Order Minumum Not Met"}]

{"sheet":"OrderForm","index":2,"n_rows":190,"n_cols":243,"rows_kept":190,"merged":[[0,5,0,11]]}
[{"$nulls":5},"Order Summary",{"$nulls":6},0]
[{"$nulls":5},{"$f":"F6&\" SHIP\"","v":"July SHIP"},{"$f":"G6&\" SHIP\"","v":"August SHIP"},"September SHIP","October SHIP","November SHIP","December SHIP","TOTAL",0]
[{"$nulls":3},"$ Totals",null,{"$f":"F189","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
["ITEM DESCRIPTION","COLOR","WHOLESALE ","UPC","ITEM NUMBER","July","August","September","October","November","December","WHOLESALE",0]
["LUMBAR SERIES",{"$nulls":11},0]
["Day","Heritage Black ",{"v":49.5,"d":"$49.50"},757894330569,"20-10020-01",{"$nulls":6},{"$f":"(F8*C8)+(G8*C8)+(H8*C8)+(I8*C8)+(J8*C8)+(K8*C8)","v":{"v":0,"d":"$0.00"}},{"$f":"IF(AND(ISBLANK(F8),ISBLANK(G8),ISBLANK(H8),ISBLANK(I8),ISBLANK(J8),ISBLANK(K8)),1,0)","v":1}]
["Day","Moss Green",{"v":49.5,"d":"$49.50"},757894330576,"20-10020-54",{"$nulls":6},{"v":0,"d":"$0.00"},{"$f":"IF(AND(ISBLANK(F9),ISBLANK(G9),ISBLANK(H9),ISBLANK(I9),ISBLANK(J9),ISBLANK(K9)),1,0)","v":1}]
["Day","Rust Brown",{"v":49.5,"d":"$49.50"},757894330583,"20-10020-18",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Day","Concrete",{"v":49.5,"d":"$49.50"},757894330590,"20-10020-72",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Day","Asphalt (Grey/Blue)",{"v":49.5,"d":"$49.50"},757894330613,"20-10020-52",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Tour","Moss Green ",{"v":44,"d":"$44.00"},757894330514,"20-10200-54",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Tour","Heritage Black  ",{"v":44,"d":"$44.00"},757894330507,"20-10200-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Tour","Rust Brown",{"v":44,"d":"$44.00"},757894330521,"20-10200-18",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Tour","Concrete",{"v":44,"d":"$44.00"},757894330538,"20-10200-72",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Tour","Asphalt Grey (Grey/Blue)",{"v":44,"d":"$44.00"},757894330552,"20-10200-52",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Tour SM","Heritage Black",{"v":41.25,"d":"$41.25"},757894330965,"20-10202-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Tour SM","Concrete",{"v":41.25,"d":"$41.25"},757894330972,"20-10202-72",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Tour SM","Sage Blue",{"v":41.25,"d":"$41.25"},757894330545,"20-10202-17",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Drift","Heritage Black  ",{"v":27.5,"d":"$27.50"},757894330620,"20-10160-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Drift","Moss Green",{"v":27.5,"d":"$27.50"},757894330637,"20-10160-54",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Drift","Rust Brown",{"v":27.5,"d":"$27.50"},757894330644,"20-10160-18",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Drift","Concrete",{"v":27.5,"d":"$27.50"},757894330651,"20-10160-72",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Drift","Sage Blue",{"v":27.5,"d":"$27.50"},757894330668,"20-10160-17",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Drift","Asphalt (Grey/Blue)",{"v":27.5,"d":"$27.50"},757894330675,"20-10160-52",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Tanack 10","Heritage Black",{"v":55,"d":"$55.00"},757894326197,"17-81450-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Knockabout","Heritage Black  ",{"v":19.25,"d":"$19.25"},757894324506,"16-10190-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Knockabout","Huckleberry  ",{"v":19.25,"d":"$19.25"},757894324520,"16-10190-49",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Knockabout","Mint",{"v":19.25,"d":"$19.25"},757894327354,"16-10190-21",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Sidekick, S","Heritage Black",{"v":13.75,"d":"$13.75"},757894327316,"18-10265-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Sidekick, M","Heritage Black",{"v":15.5,"d":"$15.50"},757894327323,"18-10270-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Trippin Fanny","Heritage Black",{"v":15.5,"d":"$15.50"},757894331511,"21-10301-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Trippin Fanny","Heritage Purple",{"v":15.5,"d":"$15.50"},757894331528,"21-10301-20",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Trippin Fanny","Classic Red",{"v":15.5,"d":"$15.50"},757894331535,"21-10301-31",{"$nulls":6},{"$f":"(F35*C35)+(G35*C35)+(H35*C35)+(I35*C35)+(J35*C35)+(K35*C35)","v":{"v":0,"d":"$0.00"}},{"$f":"IF(AND(ISBLANK(F35),ISBLANK(G35),ISBLANK(H35),ISBLANK(I35),ISBLANK(J35),ISBLANK(K35)),1,0)","v":1}]
["Trippin Fanny","Salmon",{"v":15.5,"d":"$15.50"},757894331542,"21-10301-75",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Trippin Fanny","Mint",{"v":15.5,"d":"$15.50"},757894331559,"21-10301-21",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Trippin Lil ","Purple Reign",{"v":13.75,"d":"$13.75"},757894331184,"20-10302-20",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Trippin Lil ","Classic Red",{"v":13.75,"d":"$13.75"},757894331191,"20-10302-31",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Trippin Lil ","Salmon",{"v":13.75,"d":"$13.75"},757894331207,"20-10302-75",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Trippin Lil ","Mint",{"v":13.75,"d":"$13.75"},757894331214,"20-10302-21",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Trippin Lil ","Heritage Black",{"v":13.75,"d":"$13.75"},757894331177,"20-10302-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Vibe","Heritage Black  ",{"v":16.5,"d":"$16.50"},757894324537,"16-10220-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Vibe","Deep Blue",{"v":16.5,"d":"$16.50"},757894326869,"16-10220-63",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Vibe","Mint  ",{"v":16.5,"d":"$16.50"},757894326838,"16-10220-21",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Groove","Stone Grey ",{"v":10,"d":"$10.00"},757894330699,"20-10220-33",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Groove","Caribe Blue",{"v":10,"d":"$10.00"},757894330705,"20-10220-50",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Groove","Moss Green",{"v":10,"d":"$10.00"},757894330897,"20-10220-54",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Dry Tour","Moss Green ",{"v":99,"d":"$99.00"},757894328771,"19-10041-28",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Dry Kick","Moss Green",{"v":22,"d":"$22.00"},757894328788,"19-10042-28",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Strapettes","Black",{"v":14,"d":"$14.00"},757894990657,"99-90004-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Day Rain Cover","Black",{"v":10,"d":"$10.00"},757894328016,"09-90015-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Tour Rain Cover","Black",{"v":9.5,"d":"$9.50"},757894328023,"09-90016-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["LUMBAR SERIES SUBTOTAL",{"$nulls":4},{"$f":"SUMPRODUCT($C$8:$C$53,F8:F53)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"SUM(L8:L53)","v":{"v":0,"d":"$0.00"}},0]
["BACKPACKS",{"$nulls":11},0]
["Zerk 40","Phantom",{"v":122,"d":"$122.00"},757894331580,"21-50441-44",{"$nulls":6},{"$f":"(F56*C56)+(G56*C56)+(H56*C56)+(I56*C56)+(J56*C56)+(K56*C56)","v":{"v":0,"d":"$0.00"}},1]
["Scream 55","Stone Grey",{"v":88,"d":"$88.00"},757894327545,"18-50240-33",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Scream 50 WSD","Mint",{"v":88,"d":"$88.00"},757894327996,"18-50241-21",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Apex 80","Anvil Grey",{"v":121,"d":"$121.00"},757894328726,"19-50181-65",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Apex 60","Anvil Grey",{"v":110,"d":"$110.00"},757894328795,"19-50161-65",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Apex 55 WSD","Moonstone",{"v":110,"d":"$110.00"},757894328801,"19-50156-70",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Mayhem 45","Heritage Black",{"v":99,"d":"$99.00"},757894328542,"19-50301-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Mayhem 30","Heritage Black",{"v":88,"d":"$88.00"},757894328566,"19-50311-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Clear Creek 25","Anvil Grey",{"v":55,"d":"$55.00"},757894328580,"19-50341-65",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Clear Creek 25","Moss Green",{"v":55,"d":"$55.00"},757894328597,"19-50341-54",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Clear Creek 25 WSD","Caribe Blue",{"v":55,"d":"$55.00"},757894330989,"19-50341-50",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Clear Creek 20","Anvil Grey",{"v":44,"d":"$44.00"},757894328610,"19-50351-65",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Clear Creek 20","Moss Green",{"v":44,"d":"$44.00"},757894328627,"19-50351-54",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Clear Creek 20 WSD","Caribe Blue",{"v":44,"d":"$44.00"},757894328634,"19-50351-50",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Clear Creek 15","Anvil Grey",{"v":33,"d":"$33.00"},757894328641,"19-50361-65",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Clear Creek 15","Moss Green",{"v":33,"d":"$33.00"},757894328658,"19-50361-54",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Clear Creek 15 WSD","Caribe Blue",{"v":33,"d":"$33.00"},757894328665,"19-50361-50",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Clear Creek 10","Anvil Grey",{"v":38.5,"d":"$38.50"},757894328535,"19-50371-65",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Clear Creek 10","Caribe Blue",{"v":38.5,"d":"$38.50"},757894331016,"19-50371-50",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Rain Cover Extra Small","Black",{"v":10,"d":"$10.00"},757894314811,"07-90010-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Rain Cover Small","Black",{"v":11,"d":"$11.00"},757894990725,"07-90011-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Rain Cover Medium","Black",{"v":12,"d":"$12.00"},757894990732,"07-90012-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Rain Cover Large","Black",{"v":13,"d":"$13.00"},757894990749,"07-90013-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Trippin Pack","Heritage Black",{"v":33,"d":"$33.00"},757894331603,"21-10401-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Trippin Pack","Heritage Purple",{"v":33,"d":"$33.00"},"757894331610","21-10401-20",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Trippin Pack","Classic Red",{"v":33,"d":"$33.00"},"757894331627","21-10401-31",{"$nulls":6},{"$f":"(F81*C81)+(G81*C81)+(H81*C81)+(I81*C81)+(J81*C81)+(K81*C81)","v":{"v":0,"d":"$0.00"}},{"$f":"IF(AND(ISBLANK(F81),ISBLANK(G81),ISBLANK(H81),ISBLANK(I81),ISBLANK(J81),ISBLANK(K81)),1,0)","v":1}]
["Trippin Pack","Salmon",{"v":33,"d":"$33.00"},"757894331634","21-10401-75",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Trippin Pack","Mint",{"v":33,"d":"$33.00"},"757894331641","21-10401-21",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Trippin Pouch","Heritage Black",{"v":13.75,"d":"$13.75"},"757894331771","21-10201-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Trippin Pouch","Heritage Purple",{"v":13.75,"d":"$13.75"},"757894331788","21-10201-20",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Trippin Pouch","Classic Red",{"v":13.75,"d":"$13.75"},"757894331795","21-10201-31",{"$nulls":6},{"$f":"(F86*C86)+(G86*C86)+(H86*C86)+(I86*C86)+(J86*C86)+(K86*C86)","v":{"v":0,"d":"$0.00"}},{"$f":"IF(AND(ISBLANK(F86),ISBLANK(G86),ISBLANK(H86),ISBLANK(I86),ISBLANK(J86),ISBLANK(K86)),1,0)","v":1}]
["Trippin Pouch","Salmon",{"v":13.75,"d":"$13.75"},"757894331801","21-10201-75",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Trippin Pouch","Mint",{"v":13.75,"d":"$13.75"},"757894331818","21-10201-21",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Grand Tour","Anvil Grey",{"v":55,"d":"$55.00"},757894326401,"16-75330-65",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Grand Tour","Heritage Black",{"v":55,"d":"$55.00"},757894325565,"16-75330-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["World Cup","Heritage Black",{"v":66,"d":"$66.00"},757894325541,"16-75320-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["World Cup","Anvil Grey",{"v":66,"d":"$66.00"},757894326371,"16-75320-65",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Adventure Office","Heritage Black ",{"v":44,"d":"$44.00"},757894327590,"18-75311-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Adventure Office","Anvil Grey",{"v":44,"d":"$44.00"},757894328078,"18-75311-65",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Adventure Office Small","Heritage Black",{"v":33,"d":"$33.00"},757894325510,"16-75300-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Adventure Office Small","Mint",{"v":33,"d":"$33.00"},757894327583,"16-75300-21",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Divide","Blackout",{"v":49.5,"d":"$49.50"},757894331351,"21-75350-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Divide","Basil",{"v":49.5,"d":"$49.50"},757894331719,"21-75350-77",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Amble","Navy",{"v":44,"d":"$44.00"},757894331344,"21-75353-48",{"$nulls":6},{"$f":"(F99*C99)+(G99*C99)+(H99*C99)+(I99*C99)+(J99*C99)+(K99*C99)","v":{"v":0,"d":"$0.00"}},{"$f":"IF(AND(ISBLANK(F99),ISBLANK(G99),ISBLANK(H99),ISBLANK(I99),ISBLANK(J99),ISBLANK(K99)),1,0)","v":1}]
["Amble","Basil",{"v":44,"d":"$44.00"},757894331740,"21-75353-77",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["TanuckLITE 40","Hops",{"v":137.5,"d":"$137.50"},757894328863,"18-81401-09",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Tanuck 40","Heritage Black",{"v":126.5,"d":"$126.50"},757894326142,"17-81400-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Spectrum","Heritage Black",{"v":82.5,"d":"$82.50"},757894326159,"17-81410-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Borealis","Heritage Black",{"v":137.5,"d":"$137.50"},757894326166,"17-81420-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Descent","Heritage Black",{"v":66,"d":"$66.00"},757894326173,"17-81430-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Descent SM","Heritage Black",{"v":55,"d":"$55.00"},757894327231,"17-81435-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["BACKPACKS SUBTOTAL",{"$nulls":4},{"$f":"SUMPRODUCT($C$56:$C$106,F56:F106)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"SUM(L56:L106)","v":{"v":0,"d":"$0.00"}},0]
["TREKKING POLES",{"$nulls":11},0]
["Andesite","Carbon ",{"v":50,"d":"$50.00"},757894330026,"19-9100-01",{"$nulls":6},{"$f":"(F109*C109)+(G109*C109)+(H109*C109)+(I109*C109)+(J109*C109)+(K109*C109)","v":{"v":0,"d":"$0.00"}},{"$f":"IF(AND(ISBLANK(F109),ISBLANK(G109),ISBLANK(H109),ISBLANK(I109),ISBLANK(J109),ISBLANK(K109)),1,0)","v":1}]
["Halite 7075 ","Moroccan Blue ",{"v":40,"d":"$40.00"},757894329433,"19-9732-30",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Halite WSD 7075","Capri Blue ",{"v":40,"d":"$40.00"},757894329440,"19-9732-26",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Carbonlite Pro","Carbon  ",{"v":40,"d":"$40.00"},757894328696,"19-9622-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Tellurite 7075 OLS","Burnt Ochre",{"v":32.5,"d":"$32.50"},757894329464,"19-9752-06",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Tellurite WSD 7075","Berry ",{"v":32.5,"d":"$32.50"},757894329471,"19-9752-19",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Pyrite 7075","Lava Red",{"v":30,"d":"$30.00"},757894328689,"19-9612-02",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Rhyolite 6061","Deep Blue",{"v":20,"d":"$20.00"},757894328672,"19-9602-63",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Trekker FX Lite","Carbon",{"v":20,"d":"$20.00"},757894328733,"19-9701-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Globetrotter","Graphite ",{"v":19,"d":"$19.00"},757894329457,"19-9741-08",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Dolomite 7075 OLS","Moroccan Blue ",{"v":15,"d":"$15.00"},757894329426,"19-9711-30",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Pinnacle Single","Sand",{"v":10,"d":"$10.00"},757894328702,"19-9651-14",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Pinnacle Single","Glacier Blue",{"v":10,"d":"$10.00"},757894328719,"19-9651-39",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["SlingBack Chair","Anvil Grey",{"v":12.5,"d":"$12.50"},757894326210,"17-9490-65",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Snow Baskets (Pair)",null,{"v":3,"d":"$3.00"},757894325299,"15-9470-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Hiking Baskets (Pair)",null,{"v":3,"d":"$3.00"},757894325893,"17-9480-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Trekking Pole Nordic Boot Tips (Pair)",null,{"v":4,"d":"$4.00"},757894325909,"17-9501-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Trekking Pole Rubber Boot Tips (Pair)",null,{"v":3,"d":"$3.00"},757894321789,"12-9500-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Hiking Baskets Bulk (20pcs ",null,{"v":20,"d":"$20.00"},757894326333,"17-9489-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Snow Baskets Bulk (20pcs ",null,{"v":20,"d":"$20.00"},757894326340,"17-9479-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Rubber Boot Tips Bulk (20pcs ",null,{"v":20,"d":"$20.00"},757894326357,"17-9509-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["TREKKING POLES SUBTOTAL",null,null,"  "," ",{"$f":"SUMPRODUCT($C$109:$C$129,F109:F129)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"SUM(L109:L129)","v":{"v":0,"d":"$0.00"}},0]
["TENTS",{"$nulls":11},0]
["Morrison EVO 4 w/FP, 4 Person 3 Season Tent","Cactus Green",{"v":137.5,"d":"$137.50"},757894325848,"17-2034-29",{"$nulls":6},{"$f":"(F132*C132)+(G132*C132)+(H132*C132)+(I132*C132)+(J132*C132)+(K132*C132)","v":{"v":0,"d":"$0.00"}},1]
["Morrison EVO 2 w/FP, 2 Person 3 Season Tent","Cactus Green",{"v":110,"d":"$110.00"},757894325831,"17-2032-29",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Bear Creek 4 w/FP, 4 Person 3 Season Tent","Olympic Blue",{"v":99,"d":"$99.00"},757894325879,"17-2044-39",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Bear Creek 2 w/FP, 2 Person 3 Season Tent","Olympic Blue",{"v":77,"d":"$77.00"},757894325855,"17-2042-39",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Conifer, 5+ Person 3 Season Tent","Olympic Blue",{"v":220,"d":"$220.00"},757894325886,"12-2014-39",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Mountain Shelter LT, 2 Person 3 Season Tarp","Pinon Green",{"v":71.5,"d":"$71.50"},757894326029,"13-2019-38",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Mountain Shade Tarp 12","Burnt Ochre",{"v":33,"d":"$33.00"},757894325961,"17-2050-06",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Tent Field Repair Kit",null,{"v":6.5,"d":"$6.50"},757894325916,"17-3001-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Replacement Guylines (Set of 4)",null,{"v":4,"d":"$4.00"},757894325954,"17-3002-43",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Steel Tarp Pole (Set of 2)",null,{"v":20,"d":"$20.00"},757894326227,"17-3003-08",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Carpet Stakes Bulk (25pcs - no Pkg)",null,{"v":25,"d":"$25.00"},757894326364,"17-3005-08",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Tent Stakes (Set of 8)",null,{"v":5,"d":"$5.00"},757894321260,"12-2015-08",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Tent Footprint - 2 Person",null,{"v":15,"d":"$15.00"},757894321277,"12-2016-08",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Tent Footprint - 4 Person",null,{"v":20,"d":"$20.00"},757894321284,"12-2017-08",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Tent Footprint - 5 Person",null,{"v":25,"d":"$25.00"},757894321291,"12-2018-08",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["TENTS SUBTOTAL",{"$nulls":4},{"$f":"SUMPRODUCT($C$132:$C$146,F132:F146)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"SUM(L132:L146)","v":{"v":0,"d":"$0.00"}},0]
["DOG",{"$nulls":11},0]
["K-9 Pack, SM","Lava Red",{"v":38.5,"d":"$38.50"},757894328870,"19-80035-02",{"$nulls":6},{"$f":"(F149*C149)+(G149*C149)+(H149*C149)+(I149*C149)+(J149*C149)+(K149*C149)","v":{"v":0,"d":"$0.00"}},1]
["K-9 Pack, MD","Lava Red",{"v":38.5,"d":"$38.50"},757894328887,"19-80045-02",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["K-9 Pack, LG","Lava Red",{"v":38.5,"d":"$38.50"},757894328894,"19-80055-02",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["K-9 Pack, SM","Caribe Blue",{"v":38.5,"d":"$38.50"},757894329044,"19-80035-50",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["K-9 Pack, MD","Caribe Blue",{"v":38.5,"d":"$38.50"},757894329051,"19-80045-50",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["K-9 Pack, LG","Caribe Blue",{"v":38.5,"d":"$38.50"},757894329068,"19-80055-50",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["K-9 Cube-","Ice Grey",{"v":44,"d":"$44.00"},757894329075,"19-80026-59",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["K-9 Bed","Heritage Red",{"v":22,"d":"$22.00"},757894329037,"19-80110-02",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["K-9 Backbowl","Glacier Grey",{"v":7,"d":"$7.00"},757894329419,"19-80022-07",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["DOG SUBTOTAL",{"$nulls":4},{"$f":"SUMPRODUCT($C$149:$C$157,F149:F157)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMPRODUCT($C$149:$C$157,G149:G157)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"SUM(L149:L157)","v":{"v":0,"d":"$0.00"}},0,{"$nulls":18},"Quilted Zip-Top Tote, XS"," Black  ",{"v":12.5,"d":"12.50"},"07-70135-01",{"$nulls":12},"Quilted Zip-Top Tote, XS"," Black  ",{"v":12.5,"d":"12.50"},"07-70135-01",{"$nulls":12},"Quilted Zip-Top Tote, XS"," Black  ",{"v":12.5,"d":"12.50"},"07-70135-01",{"$nulls":12},"Quilted Zip-Top Tote, XS"," Black  ",{"v":12.5,"d":"12.50"},"07-70135-01",{"$nulls":12},"Quilted Zip-Top Tote, XS"," Black  ",{"v":12.5,"d":"12.50"},"07-70135-01",{"$nulls":12},"Quilted Zip-Top Tote, XS"," Black  ",{"v":12.5,"d":"12.50"},"07-70135-01",{"$nulls":12},"Quilted Zip-Top Tote, XS"," Black  ",{"v":12.5,"d":"12.50"},"07-70135-01",{"$nulls":12},"Quilted Zip-Top Tote, XS"," Black  ",{"v":12.5,"d":"12.50"},"07-70135-01",{"$nulls":12},"Quilted Zip-Top Tote, XS"," Black  ",{"v":12.5,"d":"12.50"},"07-70135-01",{"$nulls":12},"Quilted Zip-Top Tote, XS"," Black  ",{"v":12.5,"d":"12.50"},"07-70135-01",{"$nulls":12},"Quilted Zip-Top Tote, XS"," Black  ",{"v":12.5,"d":"12.50"},"07-70135-01",{"$nulls":12},"Quilted Zip-Top Tote, XS"," Black  ",{"v":12.5,"d":"12.50"},"07-70135-01",{"$nulls":12},"Quilted Zip-Top Tote, XS"," Black  ",{"v":12.5,"d":"12.50"},"07-70135-01",{"$nulls":12},"Quilted Zip-Top Tote, XS"," Black  ",{"v":12.5,"d":"12.50"},"07-70135-01"]
["GEAR STORAGE",{"$nulls":11},0,{"$nulls":18},"Quilted Zip-Top Tote, XS"," Green Mist ",{"v":12.5,"d":"12.50"},"07-70135-13",{"$nulls":12},"Quilted Zip-Top Tote, XS"," Green Mist ",{"v":12.5,"d":"12.50"},"07-70135-13",{"$nulls":12},"Quilted Zip-Top Tote, XS"," Green Mist ",{"v":12.5,"d":"12.50"},"07-70135-13",{"$nulls":12},"Quilted Zip-Top Tote, XS"," Green Mist ",{"v":12.5,"d":"12.50"},"07-70135-13",{"$nulls":12},"Quilted Zip-Top Tote, XS"," Green Mist ",{"v":12.5,"d":"12.50"},"07-70135-13",{"$nulls":12},"Quilted Zip-Top Tote, XS"," Green Mist ",{"v":12.5,"d":"12.50"},"07-70135-13",{"$nulls":12},"Quilted Zip-Top Tote, XS"," Green Mist ",{"v":12.5,"d":"12.50"},"07-70135-13",{"$nulls":12},"Quilted Zip-Top Tote, XS"," Green Mist ",{"v":12.5,"d":"12.50"},"07-70135-13",{"$nulls":12},"Quilted Zip-Top Tote, XS"," Green Mist ",{"v":12.5,"d":"12.50"},"07-70135-13",{"$nulls":12},"Quilted Zip-Top Tote, XS"," Green Mist ",{"v":12.5,"d":"12.50"},"07-70135-13",{"$nulls":12},"Quilted Zip-Top Tote, XS"," Green Mist ",{"v":12.5,"d":"12.50"},"07-70135-13",{"$nulls":12},"Quilted Zip-Top Tote, XS"," Green Mist ",{"v":12.5,"d":"12.50"},"07-70135-13",{"$nulls":12},"Quilted Zip-Top Tote, XS"," Green Mist ",{"v":12.5,"d":"12.50"},"07-70135-13",{"$nulls":12},"Quilted Zip-Top Tote, XS"," Green Mist ",{"v":12.5,"d":"12.50"},"07-70135-13"]
["The Sixer","Frost Blue",{"v":15,"d":"$15.00"},757894330804,"20-75090-74",{"$nulls":6},{"$f":"(F160*C160)+(G160*C160)+(H160*C160)+(I160*C160)+(J160*C160)+(K160*C160)","v":{"v":0,"d":"$0.00"}},{"$f":"IF(AND(ISBLANK(F160),ISBLANK(G160),ISBLANK(H160),ISBLANK(I160),ISBLANK(J160),ISBLANK(K160)),1,0)","v":1}]
["The Sixer","Cedar Green",{"v":15,"d":"$15.00"},757894330811,"20-75090-55",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["The Sixer","Light Sand",{"v":15,"d":"$15.00"},757894330828,"20-75090-73",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["The TakeOut","Frost Blue",{"v":12.5,"d":"$12.50"},757894330835,"20-75100-74",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["The TakeOut","Cedar Green",{"v":12.5,"d":"$12.50"},757894330842,"20-75100-55",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["The TakeOut","Light Sand",{"v":12.5,"d":"$12.50"},757894330859,"20-75100-73",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Cooler Cube","Frost Blue",{"v":22.5,"d":"$22.50"},757894330743,"20-75060-74",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Cooler Cube","Cedar Green",{"v":22.5,"d":"$22.50"},757894330750,"20-75060-54",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Cooler Cube","Light Sand",{"v":22.5,"d":"$22.50"},757894330767,"20-75060-73",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Cooler Tube Sling","Frost Blue",{"v":11,"d":"$11.00"},757894330866,"20-75110-74",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Cooler Tube Sling","Cedar Green",{"v":11,"d":"$11.00"},757894330873,"20-75110-55",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Cooler Tube Sling","Light Sand",{"v":11,"d":"$11.00"},757894330880,"20-75110-73",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Zip Top Hauler","Ice Grey",{"v":33,"d":"$33.00"},757894327651,"18-75003-59",{"$nulls":6},{"$f":"(F172*C172)+(G172*C172)+(H172*C172)+(I172*C172)+(J172*C172)+(K172*C172)","v":{"v":0,"d":"$0.00"}},1]
["Basic Cube","Ice Grey (Yellow Trim)",{"v":15.5,"d":"$15.50"},757894327637,"18-75021-59",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Basic Cube, 3 Pack","Assorted (Yellow, Lime, Blue Trim)",{"v":44,"d":"$44.00"},757894327644,"18-75023-08",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Hot Box Hauler","Ice Grey",{"v":44,"d":"$44.00"},757894327675,"18-75055-59",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Cycle Cube","Ice Grey",{"v":44,"d":"$44.00"},757894327682,"18-75040-59",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Haulin' Padded Shoulder Strap","Ice Grey",{"v":7.5,"d":"$7.50"},757894328092,"14-75270-59",{"$nulls":6},{"$f":"(F177*C177)+(G177*C177)+(H177*C177)+(I177*C177)+(J177*C177)+(K177*C177)","v":{"v":0,"d":"$0.00"}},1]
["Essentials Stash, S","Glacier Grey",{"v":12.25,"d":"$12.25"},757894328047,"17-70012-07",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Essentials Stash, M","Glacier Grey",{"v":13.75,"d":"$13.75"},757894327958,"17-70011-07",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Kit Cube SM","Heritage Black",{"v":27.5,"d":"$27.50"},757894326111,"17-81330-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Kit Cube MD","Heritage Black",{"v":33,"d":"$33.00"},757894326128,"17-81340-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Kit Cube LG","Heritage Black",{"v":38.5,"d":"$38.50"},757894326135,"17-81350-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Travel Trunk, M","Black",{"v":38.5,"d":"$38.50"},757894319304,"10-70000-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Travel Trunk, L","Black",{"v":44,"d":"$44.00"},757894319328,"10-70001-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Travel Trunk, XL","Black",{"v":49.5,"d":"$49.50"},757894319342,"10-70002-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["Travel Trunk, XXL","Black",{"v":55,"d":"$55.00"},757894319366,"10-70003-01",{"$nulls":6},{"v":0,"d":"$0.00"},1]
["GEAR STORAGE SUBTOTAL",{"$nulls":4},{"$f":"SUMPRODUCT($C$160:$C$186,F160:F186)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"SUM(L160:L186)","v":{"v":0,"d":"$0.00"}},{"$f":"IF(AND(ISBLANK(F187),ISBLANK(G187),ISBLANK(H187),ISBLANK(I187),ISBLANK(J187),ISBLANK(K187)),1,0)","v":0}]
[{"$nulls":12},0]
["GRAND TOTAL $","GRAND TOTAL $",{"$nulls":3},{"$f":"SUM(F54+F107+F130+F147+F158+F187)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"SUM(F189:K189)","v":{"v":0,"d":"$0.00"}},{"$f":"IF(AND(ISBLANK(F189),ISBLANK(G189),ISBLANK(H189),ISBLANK(I189),ISBLANK(J189),ISBLANK(K189)),1,0)","v":0}]
["Total # of Items",{"$nulls":4},{"$f":"SUM(F8:F53,F56:F106,F109:F129,F132:F146,F149:F157,F160:F186)","v":0},{"$f":"SUM(G160:G186,G149:G157,G132:G146,G109:G129,G56:G106,G8:G53)","v":0},{"$f":"SUM(H160:H186,H149:H157,H132:H146,H109:H129,H56:H106,H8:H53)","v":0},{"$f":"SUM(I160:I186,I149:I157,I132:I146,I109:I129,I56:I106,I8:I53)","v":0},{"$f":"SUM(J160:J186,J149:J157,J132:J146,J109:J129,J56:J106,J8:J53)","v":0},{"$f":"SUM(K160:K186,K149:K157,K132:K146,K109:K129,K56:K106,K8:K53)","v":0},{"$f":"SUM(F190:K190)","v":0},0]