{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Enable Macros","Boolean Functions","If Function","Lookup Functions","Conditional Functions"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":157,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Enable Macros","index":0,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["asdf"]
[null,"Boolean Functions"]
[null,"If Function"]
[null,"Lookup Functions"]
[null,"Conditional Functions"]

{"sheet":"Boolean Functions","index":1,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[1,1,6,10],[8,4,8,5]]}
[]
[null,"An infield fly in baseball is called to prevent the defense from recording an easy double play. When an infield fly occurs, the batter is automatically out once the ball is touched by a fielder or hits the ground and the baserunners must go back to their bases (though they may \"tag up\" if they wish). An infield fly occurs when the following conditions are met: (1) there is a force out at third base (this means that there are runners on first base and second base), (2) there are not two outs, and (3) the batter hits a catchable fly ball to the infield or the shallow outfield. The table below highlights 30 baseball scenarios. Complete the tasks below to determine if the umpire should declare an infield fly."]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Catchable Fly Ball Hit to…"]
[null,"Scenario","Runner on 1st","Runner on 2nd","Infield","Shallow Outfield","Outs","Force @ Third","Fly Ball","Not 2 Outs","Infield Fly"]
[null,1,"Yes","No","No","Yes",0,{"$f":"AND(C11=\"Yes\",D11=\"Yes\")","v":false},{"$f":"OR(E11=\"Yes\",F11=\"Yes\")","v":true},{"$f":"NOT(G11=2)","v":true},{"$f":"AND(H11=TRUE,I11=TRUE,J11=TRUE)","v":false}]
[null,2,"Yes","No","Yes","No",0,{"$f":"AND(C12=\"Yes\",D12=\"Yes\")","v":false},{"$f":"OR(E12=\"Yes\",F12=\"Yes\")","v":true},{"$f":"NOT(G12=2)","v":true},{"$f":"AND(H12=TRUE,I12=TRUE,J12=TRUE)","v":false}]
[null,3,"Yes","No","No","Yes",0,false,true,true,false]
[null,4,"No","Yes","No","No",2,false,false,false,false]
[null,5,"Yes","Yes","No","No",0,true,false,true,false]
[null,6,"No","No","No","Yes",1,false,true,true,false]
[null,7,"Yes","Yes","No","No",1,true,false,true,false]
[null,8,"Yes","Yes","No","Yes",2,true,true,false,false]
[null,9,"Yes","Yes","No","No",1,true,false,true,false]
[null,10,"Yes","Yes","No","Yes",1,true,true,true,true]
[null,11,"No","No","No","No",0,false,false,true,false]
[null,12,"Yes","Yes","Yes","No",2,true,true,false,false]
[null,13,"No","Yes","No","Yes",0,false,true,true,false]
[null,14,"No","Yes","No","No",2,false,false,false,false]
[null,15,"Yes","Yes","Yes","No",1,true,true,true,true]
[null,16,"No","No","Yes","No",0,false,true,true,false]
[null,17,"No","Yes","Yes","No",0,false,true,true,false]
[null,18,"No","No","Yes","No",0,false,true,true,false]
[null,19,"No","No","No","No",0,false,false,true,false]
[null,20,"Yes","Yes","No","Yes",0,true,true,true,true]
[null,21,"Yes","Yes","Yes","No",0,true,true,true,true]
[null,22,"No","No","Yes","No",1,false,true,true,false]
[null,23,"No","Yes","Yes","No",1,false,true,true,false]
[null,24,"No","Yes","No","Yes",0,false,true,true,false]
[null,25,"No","No","No","Yes",0,false,true,true,false]
[null,26,"Yes","No","Yes","No",1,false,true,true,false]
[null,27,"Yes","Yes","No","Yes",0,true,true,true,true]
[null,28,"No","No","No","Yes",1,false,true,true,false]
[null,29,"No","No","No","Yes",2,false,true,false,false]
[null,30,"No","No","No","Yes",2,false,true,false,false]

{"sheet":"If Function","index":2,"n_rows":165,"n_cols":10,"rows_kept":165,"cut":false,"hidden":false,"merged":[[1,1,6,7],[8,0,8,1]]}
[]
[null,"Quickstove ships worldwide and this is but a sample of shipments to the Western United States. \nWhen multiple quantities of an item are in the same order, quantity discounts on that item are offered. Customers are charged sales tax on all shipments within Utah where Quickstove is located as well as on shipments to Oregon where they have another facility. Sales tax is not charged on shipments to other states."]
[]
[]
[]
[]
[]
[]
["Sales Tax Rate",null,null,"Quantity Break Point","Discount",null,null,"Total Sales",{"$f":"SUM(H15:H165)","v":7908.2764999999772}]
["UT",0.05,null,1,0,null,null,"Total Tax",{"$f":"SUM(I15:I165)","v":112.30989999999998}]
["OR",0.06,null,2,0.02,null,null,"Grand Total",{"$f":"SUM(J15:J165)","v":8020.5863999999838}]
["All Others",0,null,10,0.05]
[]
["OrderID","Ship To","ProductID","Product Name","Unit Price","Quantity","Net Price","Sale Amt","Tax","Total"]
[1003,"AZ",100,"QuickStove",17.55,4,{"$f":"IF(F15>=$D$12,E15-(E15*$E$12),IF(F15>=$D$11,E15-(E15*$E$11),IF(F15<=$D$10,E15-(E15*$E$10),E15)))","v":17.199000000000002},{"$f":"F15*G15","v":68.796000000000006},{"$f":"IF(B15=$A$10,H15*$B$10,IF(B15=$A$11,H15*$B$11,$B$12))","v":0},{"$f":"H15+I15","v":68.796000000000006}]
[1004,"WA",100,"QuickStove",17.55,5,{"$f":"IF(F16>=$D$12,E16-(E16*$E$12),IF(F16>=$D$11,E16-(E16*$E$11),IF(F16<=$D$10,E16-(E16*$E$10),E16)))","v":17.199000000000002},{"$f":"F16*G16","v":85.995000000000005},{"$f":"IF(B16=$A$10,H16*$B$10,IF(B16=$A$11,H16*$B$11,$B$12))","v":0},{"$f":"H16+I16","v":85.995000000000005}]
[1007,"NV",100,"QuickStove",17.55,7,17.199000000000002,120.39300000000001,0,120.39300000000001]
[1011,"UT",100,"QuickStove",17.55,7,17.199000000000002,120.39300000000001,6.0196500000000013,126.41265000000001]
[1027,"CA",100,"QuickStove",17.55,1,17.55,17.55,0,17.55]
[1041,"MT",102,"Replacement Fuel Cells",4,1,4,4,0,4]
[1042,"CA",104,"Quick Stove Can",34.99,2,34.290199999999999,68.580399999999997,0,68.580399999999997]
[1050,"OR",104,"Quick Stove Can",34.99,8,34.290199999999999,274.32159999999999,16.459295999999998,290.78089599999998]
[1058,"UT",104,"Quick Stove Can",34.99,8,34.290199999999999,274.32159999999999,13.71608,288.03767999999997]
[1059,"AZ",102,"Replacement Fuel Cells",4,4,3.92,15.68,0,15.68]
[1060,"WA",104,"Quick Stove Can",34.99,2,34.290199999999999,68.580399999999997,0,68.580399999999997]
[1062,"UT",102,"Replacement Fuel Cells",4,16,3.8,60.8,3.04,63.839999999999996]
[1073,"CO",104,"Quick Stove Can",34.99,1,34.99,34.99,0,34.99]
[1074,"CO",102,"Replacement Fuel Cells",4,5,3.92,19.600000000000001,0,19.600000000000001]
[1088,"WA",102,"Replacement Fuel Cells",4,1,4,4,0,4]
[1094,"NV",102,"Replacement Fuel Cells",4,2,3.92,7.84,0,7.84]
[1109,"HI",102,"Replacement Fuel Cells",4,2,3.92,7.84,0,7.84]
[1120,"OR",102,"Replacement Fuel Cells",4,10,3.8,38,2.2799999999999998,40.28]
[1255,"OR",106,"Stove In A Can",34.99,1,34.99,34.99,2.0994000000000002,37.089400000000005]
[1262,"UT",106,"Stove In A Can",34.99,3,34.290199999999999,102.8706,5.1435300000000002,108.01412999999999]
[1265,"WA",106,"Stove In A Can",34.99,1,34.99,34.99,0,34.99]
[1267,"CA",106,"Stove In A Can",34.99,3,34.290199999999999,102.8706,0,102.8706]
[1268,"MT",106,"Stove In A Can",34.99,1,34.99,34.99,0,34.99]
[1364,"AZ",106,"Stove In A Can",34.99,12,33.240500000000004,398.88600000000008,0,398.88600000000008]
[1417,"UT",108,"QuickStove Fuel Disk",1.66,24,1.577,37.847999999999999,1.8924000000000001,39.740400000000001]
[1629,"CA",107,"SIAC Fuel Cell",5,2,4.9000000000000004,9.8000000000000007,0,9.8000000000000007]
[1635,"CO",106,"Stove In A Can",34.99,2,34.290199999999999,68.580399999999997,0,68.580399999999997]
[1661,"AZ",107,"SIAC Fuel Cell",5,10,4.75,47.5,0,47.5]
[1666,"OR",107,"SIAC Fuel Cell",5,4,4.9000000000000004,19.600000000000001,1.1759999999999999,20.776]
[1677,"WA",108,"QuickStove Fuel Disk",1.66,20,1.577,31.54,0,31.54]
[1686,"CA",101,"QuickStove Can",19.95,1,19.95,19.95,0,19.95]
[1701,"CO",101,"QuickStove Can",19.95,1,19.95,19.95,0,19.95]
[1708,"AZ",101,"QuickStove Can",19.95,1,19.95,19.95,0,19.95]
[1712,"AZ",108,"QuickStove Fuel Disk",1.66,30,1.577,47.31,0,47.31]
[1718,"OR",101,"QuickStove Can",19.95,2,19.550999999999998,39.101999999999997,2.3461199999999995,41.448119999999996]
[1720,"UT",101,"QuickStove Can",19.95,4,19.550999999999998,78.203999999999994,3.9101999999999997,82.114199999999997]
[1725,"WA",101,"QuickStove Can",19.95,4,19.550999999999998,78.203999999999994,0,78.203999999999994]
[1733,"CA",110,"Firebox Bundle",87.75,2,85.995000000000005,171.99,0,171.99]
[1746,"CO",110,"Firebox Bundle",87.75,1,87.75,87.75,0,87.75]
[1748,"NV",101,"QuickStove Can",19.95,4,19.550999999999998,78.203999999999994,0,78.203999999999994]
[1776,"MT",101,"QuickStove Can",19.95,4,19.550999999999998,78.203999999999994,0,78.203999999999994]
[1797,"WA",114,"Cube Stove + 2 Fuel Disks",24.95,2,24.451000000000001,48.902000000000001,0,48.902000000000001]
[1814,"AZ",114,"Cube Stove + 2 Fuel Disks",24.95,1,24.95,24.95,0,24.95]
[1834,"CO",113,"Firebox Stove w/ Fuel",49.95,1,49.95,49.95,0,49.95]
[1835,"CA",113,"Firebox Stove w/ Fuel",49.95,1,49.95,49.95,0,49.95]
[1839,"CA",114,"Cube Stove + 2 Fuel Disks",24.95,2,24.451000000000001,48.902000000000001,0,48.902000000000001]
[1842,"MT",108,"QuickStove Fuel Disk",1.66,12,1.577,18.923999999999999,0,18.923999999999999]
[1873,"CA",109,"Folding  Campfire Stove",59.99,1,59.99,59.99,0,59.99]
[1877,"CA",121,"Firebox Master Combo Kit",144.97999999999999,1,144.97999999999999,144.97999999999999,0,144.97999999999999]
[1897,"NV",118,"Firebox Deluxe Combo Kit",89.99,1,89.99,89.99,0,89.99]
[1913,"AZ",118,"Firebox Deluxe Combo Kit",89.99,1,89.99,89.99,0,89.99]
[1923,"WA",109,"Folding  Campfire Stove",59.99,1,59.99,59.99,0,59.99]
[1946,"WA",118,"Firebox Deluxe Combo Kit",89.99,1,89.99,89.99,0,89.99]
[1964,"AZ",109,"Folding  Campfire Stove",59.99,1,59.99,59.99,0,59.99]
[1979,"HI",118,"Firebox Deluxe Combo Kit",89.99,1,89.99,89.99,0,89.99]
[1982,"CA",118,"Firebox Deluxe Combo Kit",89.99,1,89.99,89.99,0,89.99]
[1990,"CO",109,"Folding  Campfire Stove",59.99,1,59.99,59.99,0,59.99]
[2000,"WA",121,"Firebox Master Combo Kit",144.97999999999999,1,144.97999999999999,144.97999999999999,0,144.97999999999999]
[2031,"CA",117,"Firebox Upgrade Kit",34.979999999999997,2,34.2804,68.5608,0,68.5608]
[2078,"AZ",117,"Firebox Upgrade Kit",34.979999999999997,1,34.979999999999997,34.979999999999997,0,34.979999999999997]
[2093,"AZ",121,"Firebox Master Combo Kit",144.97999999999999,1,144.97999999999999,144.97999999999999,0,144.97999999999999]
[2136,"NV",109,"Folding  Campfire Stove",59.99,1,59.99,59.99,0,59.99]
[2146,"CO",118,"Firebox Deluxe Combo Kit",89.99,1,89.99,89.99,0,89.99]
[2168,"NV",108,"QuickStove Fuel Disk",1.66,20,1.577,31.54,0,31.54]
[2198,"UT",114,"Cube Stove + 2 Fuel Disks",24.95,1,24.95,24.95,1.2475000000000001,26.197499999999998]
[2202,"AZ",123,"Cordura D-Ring Bag",15.99,1,{"$f":"IF(F80>=$D$12,E80-(E80*$E$12),IF(F80>=$D$11,E80-(E80*$E$11),IF(F80<=$D$10,E80-(E80*$E$10),E80)))","v":15.99},{"$f":"F80*G80","v":15.99},{"$f":"IF(B80=$A$10,H80*$B$10,IF(B80=$A$11,H80*$B$11,$B$12))","v":0},{"$f":"H80+I80","v":15.99}]
[2217,"WA",117,"Firebox Upgrade Kit",34.979999999999997,1,34.979999999999997,34.979999999999997,0,34.979999999999997]
[2218,"OR",118,"Firebox Deluxe Combo Kit",89.99,1,89.99,89.99,5.3993999999999991,95.389399999999995]
[2249,"OR",117,"Firebox Upgrade Kit",34.979999999999997,1,34.979999999999997,34.979999999999997,2.0987999999999998,37.078799999999994]
[2258,"CA",123,"Cordura D-Ring Bag",15.99,1,15.99,15.99,0,15.99]
[2283,"UT",118,"Firebox Deluxe Combo Kit",89.99,1,89.99,89.99,4.4995000000000003,94.489499999999992]
[2319,"WA",124,"The Ugly Bag - HD VCP Bag",9.99,1,9.99,9.99,0,9.99]
[2324,"UT",121,"Firebox Master Combo Kit",144.97999999999999,1,144.97999999999999,144.97999999999999,7.2489999999999997,152.22899999999998]
[2328,"MT",118,"Firebox Deluxe Combo Kit",89.99,1,89.99,89.99,0,89.99]
[2331,"UT",109,"Folding  Campfire Stove",59.99,1,59.99,59.99,2.9995000000000003,62.9895]
[2353,"CA",124,"The Ugly Bag - HD VCP Bag",9.99,2,9.7902000000000005,19.580400000000001,0,19.580400000000001]
[2358,"HI",109,"Folding  Campfire Stove",59.99,1,59.99,59.99,0,59.99]
[2386,"CO",123,"Cordura D-Ring Bag",15.99,1,15.99,15.99,0,15.99]
[2393,"CO",114,"Cube Stove + 2 Fuel Disks",24.95,1,24.95,24.95,0,24.95]
[2417,"OR",109,"Folding  Campfire Stove",59.99,1,59.99,59.99,3.5994000000000002,63.589400000000005]
[2419,"HI",123,"Cordura D-Ring Bag",15.99,1,15.99,15.99,0,15.99]
[2423,"AZ",124,"The Ugly Bag - HD VCP Bag",9.99,3,9.7902000000000005,29.370600000000003,0,29.370600000000003]
[2439,"UT",117,"Firebox Upgrade Kit",34.979999999999997,1,34.979999999999997,34.979999999999997,1.7489999999999999,36.728999999999999]
[2513,"AZ",125,"3 Months Fuel  with Stove",189.99,1,189.99,189.99,0,189.99]
[2521,"CA",125,"3 Months Fuel  with Stove",189.99,1,189.99,189.99,0,189.99]
[2527,"CO",117,"Firebox Upgrade Kit",34.979999999999997,1,34.979999999999997,34.979999999999997,0,34.979999999999997]
[2605,"CO",125,"3 Months Fuel  with Stove",189.99,1,189.99,189.99,0,189.99]
[2644,"WA",128,"Heavy Duty Cordura D-Ring Bag",15.99,1,15.99,15.99,0,15.99]
[2653,"OR",129,"Stainless Steel Cup Charger",149.99,1,149.99,149.99,8.9993999999999996,158.98940000000002]
[2714,"NV",117,"Firebox Upgrade Kit",34.979999999999997,1,34.979999999999997,34.979999999999997,0,34.979999999999997]
[2726,"CA",127,"Stainless Steel Cooking Pot",19.989999999999998,1,19.989999999999998,19.989999999999998,0,19.989999999999998]
[2779,"MT",109,"Folding  Campfire Stove",59.99,1,59.99,59.99,0,59.99]
[2829,"HI",132,"Adjustable Fire Grate",7.99,1,7.99,7.99,0,7.99]
[2833,"OR",132,"Adjustable Fire Grate",7.99,1,7.99,7.99,0.47939999999999999,8.4694000000000003]
[2837,"AZ",127,"Stainless Steel Cooking Pot",19.989999999999998,1,19.989999999999998,19.989999999999998,0,19.989999999999998]
[2855,"AZ",137,"QuickStove Fire Starter",1.95,2,1.911,3.8220000000000001,0,3.8220000000000001]
[2859,"CA",132,"Adjustable Fire Grate",7.99,5,7.8302000000000005,39.151000000000003,0,39.151000000000003]
[2865,"CA",137,"QuickStove Fire Starter",1.95,35,1.8525,64.837500000000006,0,64.837500000000006]
[2868,"NV",132,"Adjustable Fire Grate",7.99,1,7.99,7.99,0,7.99]
[2887,"WA",123,"Cordura D-Ring Bag",15.99,1,15.99,15.99,0,15.99]
[2889,"OR",133,"Extended Grill Plate",9.99,1,9.99,9.99,0.59940000000000004,10.589399999999999]
[2896,"WA",132,"Adjustable Fire Grate",7.99,1,7.99,7.99,0,7.99]
[2903,"WA",134,"Set of 2 Fire Sticks",5.99,1,5.99,5.99,0,5.99]
[2905,"WA",139,"Aluminum Matchbox",3.99,1,3.99,3.99,0,3.99]
[2921,"AZ",110,"Firebox Bundle",87.75,1,87.75,87.75,0,87.75]
[2928,"MT",132,"Adjustable Fire Grate",7.99,1,7.99,7.99,0,7.99]
[2932,"MT",150,"Trangia Fuel Bottle - 0.3L",16.489999999999998,1,16.489999999999998,16.489999999999998,0,16.489999999999998]
[2938,"CA",138,"Grill Plate",7.99,1,7.99,7.99,0,7.99]
[2939,"CO",132,"Adjustable Fire Grate",7.99,1,7.99,7.99,0,7.99]
[2979,"OR",124,"The Ugly Bag - HD VCP Bag",9.99,1,9.99,9.99,0.59940000000000004,10.589399999999999]
[2999,"MT",133,"Extended Grill Plate",9.99,1,9.99,9.99,0,9.99]
[3005,"MT",146,"Olicamp Space Saver Cup",8.9600000000000009,1,8.9600000000000009,8.9600000000000009,0,8.9600000000000009]
[3034,"MT",121,"Firebox Master Combo Kit",144.97999999999999,1,144.97999999999999,144.97999999999999,0,144.97999999999999]
[3043,"UT",123,"Cordura D-Ring Bag",15.99,1,15.99,15.99,0.7995000000000001,16.7895]
[3049,"UT",132,"Adjustable Fire Grate",7.99,1,7.99,7.99,0.39950000000000002,8.3895]
[3069,"CA",157,"Nalgene Cantene 32 oz",11.49,1,11.49,11.49,0,11.49]
[3079,"CA",145,"Cube Stove + 9 Fuel Disks",35.99,1,35.99,35.99,0,35.99]
[3095,"OR",134,"Set of 2 Fire Sticks",5.99,2,5.8702000000000005,11.740400000000001,0.70442400000000005,12.444824000000001]
[3111,"AZ",136,"Boil Plate",7.99,1,7.99,7.99,0,7.99]
[3233,"CA",144,"Trangia Spirit Burner",14.99,1,14.99,14.99,0,14.99]
[3246,"WA",146,"Olicamp Space Saver Cup",8.9600000000000009,1,8.9600000000000009,8.9600000000000009,0,8.9600000000000009]
[3265,"AZ",144,"Trangia Spirit Burner",14.99,1,14.99,14.99,0,14.99]
[3324,"UT",124,"The Ugly Bag - HD VCP Bag",9.99,1,9.99,9.99,0.49950000000000006,10.4895]
[3330,"WA",163,"Klean Kanteen Wide 40 oz",25.16,1,25.16,25.16,0,25.16]
[3345,"CA",163,"Klean Kanteen Wide 40 oz",25.16,1,25.16,25.16,0,25.16]
[3352,"CO",161,"Olicamp Pot Lifter",4.95,1,4.95,4.95,0,4.95]
[3357,"CA",136,"Boil Plate",7.99,1,7.99,7.99,0,7.99]
[3360,"CO",134,"Set of 2 Fire Sticks",5.99,1,5.99,5.99,0,5.99]
[3374,"CA",168,"Blue Bag",4.99,1,4.99,4.99,0,4.99]
[3377,"AZ",150,"Trangia Fuel Bottle - 0.3L",16.489999999999998,1,{"$f":"IF(F144>=$D$12,E144-(E144*$E$12),IF(F144>=$D$11,E144-(E144*$E$11),IF(F144<=$D$10,E144-(E144*$E$10),E144)))","v":16.489999999999998},{"$f":"F144*G144","v":16.489999999999998},{"$f":"IF(B144=$A$10,H144*$B$10,IF(B144=$A$11,H144*$B$11,$B$12))","v":0},{"$f":"H144+I144","v":16.489999999999998}]
[3381,"OR",150,"Trangia Fuel Bottle - 0.3L",16.489999999999998,1,16.489999999999998,16.489999999999998,0.98939999999999984,17.479399999999998]
[3394,"UT",129,"Stainless Steel Cup Charger",149.99,1,149.99,149.99,7.4995000000000012,157.48950000000002]
[3403,"CO",128,"Heavy Duty Cordura D-Ring Bag",15.99,2,15.670199999999999,31.340399999999999,0,31.340399999999999]
[3404,"CA",146,"Olicamp Space Saver Cup",8.9600000000000009,1,8.9600000000000009,8.9600000000000009,0,8.9600000000000009]
[3429,"OR",171,"Power Bank with Flashlight",14.99,1,14.99,14.99,0.89939999999999998,15.8894]
[3430,"HI",128,"Heavy Duty Cordura D-Ring Bag",15.99,2,15.670199999999999,31.340399999999999,0,31.340399999999999]
[3441,"HI",121,"Firebox Master Combo Kit",144.97999999999999,1,144.97999999999999,144.97999999999999,0,144.97999999999999]
[3446,"HI",133,"Extended Grill Plate",9.99,1,9.99,9.99,0,9.99]
[3464,"OR",127,"Stainless Steel Cooking Pot",19.989999999999998,1,19.989999999999998,19.989999999999998,1.1993999999999998,21.189399999999999]
[3485,"AZ",130,"Emergency Cook Kit",25,1,25,25,0,25]
[3539,"CA",139,"Aluminum Matchbox",3.99,2,3.9102000000000001,7.8204000000000002,0,7.8204000000000002]
[3546,"UT",128,"Heavy Duty Cordura D-Ring Bag",15.99,1,15.99,15.99,0.7995000000000001,16.7895]
[3554,"HI",134,"Set of 2 Fire Sticks",5.99,1,5.99,5.99,0,5.99]
[3585,"NV",127,"Stainless Steel Cooking Pot",19.989999999999998,1,19.989999999999998,19.989999999999998,0,19.989999999999998]
[3616,"CA",175,"Folding Firebox Nano",29.99,1,29.99,29.99,0,29.99]
[3618,"OR",143,"Trangia Fuel Bottle - 0.5L",15.29,1,15.29,15.29,0.91739999999999988,16.2074]
[3653,"CA",120,"Master Combo Kit",144.97999999999999,1,144.97999999999999,144.97999999999999,0,144.97999999999999]
[3663,"CA",154,"Deluxe Combo Kit",89.99,1,89.99,89.99,0,89.99]
[3702,"CA",171,"Power Bank with Flashlight",14.99,1,14.99,14.99,0,14.99]
[3718,"CA",176,"Firebox Accessory Kit",31.48,1,31.48,31.48,0,31.48]
[3800,"MT",168,"Blue Bag",4.99,1,4.99,4.99,0,4.99]

{"sheet":"Lookup Functions","index":3,"n_rows":161,"n_cols":14,"rows_kept":161,"cut":false,"hidden":false,"merged":[[1,0,6,3],[3,4,3,13],[9,10,9,11]]}
[]
["When shipping products two major costs are incurred: the cost of insuring the item and the actual freight cost. Insurance is dependent on the value of the shipment\nQuickstove has an agreement with shippers for a fixed rate that is determined by destination state and service level (regular , express or overnite). "]
[]
[null,null,null,null,"Freight Cost"]
[null,null,null,null,null,"AZ","WA","NV","UT","CA","MT","OR","CO","HI"]
[null,null,null,null,"Regular",5,6,5,3,5,6,6,5,8]
[null,null,null,null,"Express",7.6,8.4,7.6,4.7,7.6,8.4,8.4,7.6,13.5]
[null,null,null,null,"Overnite",11.6,13.7,11.6,7.8,11.6,13.7,13.7,11.6,17.100000000000001]
[]
["OrderID","Ship To","ProductID","Product Name","Value","Shipping Class","Insurance Cost","Freight Cost","Shipping Total",null,"Insurance Cost"]
[1003,"AZ",100,"QuickStove",68.796000000000006,"Express",{"$f":"VLOOKUP(E11,$K$11:$L$18,2)","v":2.5},{"$f":"HLOOKUP(B11,$E$5:$N$8,IF(F11=$E$6,2,IF(F11=$E$7,3,4)),FALSE)","v":7.6},{"$f":"G11+H11","v":10.1},null,"Shipment Value","Insurance Cost"]
[1004,"WA",100,"QuickStove",85.995000000000005,"Express",{"$f":"VLOOKUP(E12,$K$11:$L$18,2)","v":2.5},{"$f":"HLOOKUP(B12,$E$5:$N$8,IF(F12=$E$6,2,IF(F12=$E$7,3,4)),FALSE)","v":8.4},{"$f":"G12+H12","v":10.9},null,0,0.5]
[1007,"NV",100,"QuickStove",120.39300000000001,"Regular",3,5,8,null,10,1]
[1011,"UT",100,"QuickStove",120.39300000000001,"Express",3,4.7,7.7,null,30,2]
[1027,"CA",100,"QuickStove",17.55,"Overnite",1,11.6,12.6,null,50,2.5]
[1041,"MT",102,"Replacement Fuel Cells",4,"Overnite",0.5,13.7,14.2,null,100,3]
[1042,"CA",104,"Quick Stove Can",69.98,"Overnite",2.5,11.6,14.1,null,200,4]
[1050,"OR",104,"Quick Stove Can",274.32159999999999,"Overnite",4,13.7,17.7,null,400,5]
[1058,"UT",104,"Quick Stove Can",274.32159999999999,"Express",4,4.7,8.6999999999999993]
[1059,"AZ",102,"Replacement Fuel Cells",15.68,"Regular",1,5,6]
[1060,"WA",104,"Quick Stove Can",69.98,"Overnite",2.5,13.7,16.2]
[1062,"UT",102,"Replacement Fuel Cells",60.8,"Regular",2.5,3,5.5]
[1073,"CO",104,"Quick Stove Can",34.99,"Overnite",2,11.6,13.6]
[1074,"CO",102,"Replacement Fuel Cells",19.600000000000001,"Overnite",1,11.6,12.6]
[1088,"WA",102,"Replacement Fuel Cells",4,"Overnite",0.5,13.7,14.2]
[1094,"NV",102,"Replacement Fuel Cells",8,"Express",0.5,7.6,8.1]
[1109,"HI",102,"Replacement Fuel Cells",8,"Express",0.5,13.5,14]
[1120,"OR",102,"Replacement Fuel Cells",38,"Express",2,8.4,10.4]
[1255,"OR",106,"Stove In A Can",34.99,"Overnite",2,13.7,15.7]
[1262,"UT",106,"Stove In A Can",102.8706,"Regular",3,3,6]
[1265,"WA",106,"Stove In A Can",34.99,"Express",2,8.4,10.4]
[1267,"CA",106,"Stove In A Can",102.8706,"Overnite",3,11.6,14.6]
[1268,"MT",106,"Stove In A Can",34.99,"Regular",2,6,8]
[1364,"AZ",106,"Stove In A Can",398.88599999999997,"Regular",4,5,9]
[1417,"UT",108,"QuickStove Fuel Disk",37.847999999999999,"Overnite",2,7.8,9.8000000000000007]
[1629,"CA",107,"SIAC Fuel Cell",10,"Express",1,7.6,8.6]
[1635,"CO",106,"Stove In A Can",69.98,"Express",2.5,7.6,10.1]
[1661,"AZ",107,"SIAC Fuel Cell",47.5,"Regular",2,5,7]
[1666,"OR",107,"SIAC Fuel Cell",19.600000000000001,"Express",1,8.4,9.4]
[1677,"WA",108,"QuickStove Fuel Disk",31.54,"Express",2,8.4,10.4]
[1686,"CA",101,"QuickStove Can",19.95,"Overnite",1,11.6,12.6]
[1701,"CO",101,"QuickStove Can",19.95,"Overnite",1,11.6,12.6]
[1708,"AZ",101,"QuickStove Can",19.95,"Overnite",1,11.6,12.6]
[1712,"AZ",108,"QuickStove Fuel Disk",47.31,"Express",2,7.6,9.6]
[1718,"OR",101,"QuickStove Can",39.9,"Overnite",2,13.7,15.7]
[1720,"UT",101,"QuickStove Can",78.203999999999994,"Overnite",2.5,7.8,10.3]
[1725,"WA",101,"QuickStove Can",78.203999999999994,"Express",2.5,8.4,10.9]
[1733,"CA",110,"Firebox Bundle",175.5,"Regular",3,5,8]
[1746,"CO",110,"Firebox Bundle",87.75,"Express",2.5,7.6,10.1]
[1748,"NV",101,"QuickStove Can",78.203999999999994,"Overnite",2.5,11.6,14.1]
[1776,"MT",101,"QuickStove Can",78.203999999999994,"Overnite",2.5,13.7,16.2]
[1797,"WA",114,"Cube Stove + 2 Fuel Disks",49.9,"Express",2,8.4,10.4]
[1814,"AZ",114,"Cube Stove + 2 Fuel Disks",24.95,"Regular",1,5,6]
[1834,"CO",113,"Firebox Stove w/ Fuel",49.95,"Overnite",2,11.6,13.6]
[1835,"CA",113,"Firebox Stove w/ Fuel",49.95,"Overnite",2,11.6,13.6]
[1839,"CA",114,"Cube Stove + 2 Fuel Disks",49.9,"Express",2,7.6,9.6]
[1842,"MT",108,"QuickStove Fuel Disk",18.923999999999999,"Overnite",1,13.7,14.7]
[1873,"CA",109,"Folding  Campfire Stove",59.99,"Regular",2.5,5,7.5]
[1877,"CA",121,"Firebox Master Combo Kit",144.97999999999999,"Overnite",3,11.6,14.6]
[1897,"NV",118,"Firebox Deluxe Combo Kit",89.99,"Regular",2.5,5,7.5]
[1913,"AZ",118,"Firebox Deluxe Combo Kit",89.99,"Regular",2.5,5,7.5]
[1923,"WA",109,"Folding  Campfire Stove",59.99,"Regular",2.5,6,8.5]
[1946,"WA",118,"Firebox Deluxe Combo Kit",89.99,"Overnite",2.5,13.7,16.2]
[1964,"AZ",109,"Folding  Campfire Stove",59.99,"Express",2.5,7.6,10.1]
[1979,"HI",118,"Firebox Deluxe Combo Kit",89.99,"Overnite",2.5,17.100000000000001,19.600000000000001]
[1982,"CA",118,"Firebox Deluxe Combo Kit",89.99,"Overnite",2.5,11.6,14.1]
[1990,"CO",109,"Folding  Campfire Stove",59.99,"Regular",2.5,5,7.5]
[2000,"WA",121,"Firebox Master Combo Kit",144.97999999999999,"Express",3,8.4,11.4]
[2031,"CA",117,"Firebox Upgrade Kit",69.959999999999994,"Overnite",2.5,11.6,14.1]
[2078,"AZ",117,"Firebox Upgrade Kit",34.979999999999997,"Overnite",2,11.6,13.6]
[2093,"AZ",121,"Firebox Master Combo Kit",144.97999999999999,"Overnite",3,11.6,14.6]
[2136,"NV",109,"Folding  Campfire Stove",59.99,"Overnite",2.5,11.6,14.1]
[2146,"CO",118,"Firebox Deluxe Combo Kit",89.99,"Regular",2.5,5,7.5]
[2168,"NV",108,"QuickStove Fuel Disk",31.54,"Regular",2,5,7]
[2198,"UT",114,"Cube Stove + 2 Fuel Disks",24.95,"Regular",1,3,4]
[2202,"AZ",123,"Cordura D-Ring Bag",15.99,"Regular",{"$f":"VLOOKUP(E76,$K$11:$L$18,2)","v":1},{"$f":"HLOOKUP(B76,$E$5:$N$8,IF(F76=$E$6,2,IF(F76=$E$7,3,4)),FALSE)","v":5},{"$f":"G76+H76","v":6}]
[2217,"WA",117,"Firebox Upgrade Kit",34.979999999999997,"Regular",2,6,8]
[2218,"OR",118,"Firebox Deluxe Combo Kit",89.99,"Overnite",2.5,13.7,16.2]
[2249,"OR",117,"Firebox Upgrade Kit",34.979999999999997,"Regular",2,6,8]
[2258,"CA",123,"Cordura D-Ring Bag",15.99,"Regular",1,5,6]
[2283,"UT",118,"Firebox Deluxe Combo Kit",89.99,"Overnite",2.5,7.8,10.3]
[2319,"WA",124,"The Ugly Bag - HD VCP Bag",9.99,"Express",0.5,8.4,8.9]
[2324,"UT",121,"Firebox Master Combo Kit",144.97999999999999,"Regular",3,3,6]
[2328,"MT",118,"Firebox Deluxe Combo Kit",89.99,"Express",2.5,8.4,10.9]
[2331,"UT",109,"Folding  Campfire Stove",59.99,"Regular",2.5,3,5.5]
[2353,"CA",124,"The Ugly Bag - HD VCP Bag",19.98,"Express",1,7.6,8.6]
[2358,"HI",109,"Folding  Campfire Stove",59.99,"Express",2.5,13.5,16]
[2386,"CO",123,"Cordura D-Ring Bag",15.99,"Regular",1,5,6]
[2393,"CO",114,"Cube Stove + 2 Fuel Disks",24.95,"Express",1,7.6,8.6]
[2417,"OR",109,"Folding  Campfire Stove",59.99,"Overnite",2.5,13.7,16.2]
[2419,"HI",123,"Cordura D-Ring Bag",15.99,"Regular",1,8,9]
[2423,"AZ",124,"The Ugly Bag - HD VCP Bag",29.370600000000003,"Overnite",1,11.6,12.6]
[2439,"UT",117,"Firebox Upgrade Kit",34.979999999999997,"Overnite",2,7.8,9.8000000000000007]
[2513,"AZ",125,"3 Months Fuel  with Stove",189.99,"Overnite",3,11.6,14.6]
[2521,"CA",125,"3 Months Fuel  with Stove",189.99,"Express",3,7.6,10.6]
[2527,"CO",117,"Firebox Upgrade Kit",34.979999999999997,"Overnite",2,11.6,13.6]
[2605,"CO",125,"3 Months Fuel  with Stove",189.99,"Express",3,7.6,10.6]
[2644,"WA",128,"Heavy Duty Cordura D-Ring Bag",15.99,"Overnite",1,13.7,14.7]
[2653,"OR",129,"Stainless Steel Cup Charger",149.99,"Overnite",3,13.7,16.7]
[2714,"NV",117,"Firebox Upgrade Kit",34.979999999999997,"Overnite",2,11.6,13.6]
[2726,"CA",127,"Stainless Steel Cooking Pot",19.989999999999998,"Overnite",1,11.6,12.6]
[2779,"MT",109,"Folding  Campfire Stove",59.99,"Express",2.5,8.4,10.9]
[2829,"HI",132,"Adjustable Fire Grate",7.99,"Regular",0.5,8,8.5]
[2833,"OR",132,"Adjustable Fire Grate",7.99,"Regular",0.5,6,6.5]
[2837,"AZ",127,"Stainless Steel Cooking Pot",19.989999999999998,"Regular",1,5,6]
[2855,"AZ",137,"QuickStove Fire Starter",3.9,"Express",0.5,7.6,8.1]
[2859,"CA",132,"Adjustable Fire Grate",39.151000000000003,"Overnite",2,11.6,13.6]
[2865,"CA",137,"QuickStove Fire Starter",64.837499999999991,"Regular",2.5,5,7.5]
[2868,"NV",132,"Adjustable Fire Grate",7.99,"Regular",0.5,5,5.5]
[2887,"WA",123,"Cordura D-Ring Bag",15.99,"Overnite",1,13.7,14.7]
[2889,"OR",133,"Extended Grill Plate",9.99,"Express",0.5,8.4,8.9]
[2896,"WA",132,"Adjustable Fire Grate",7.99,"Regular",0.5,6,6.5]
[2903,"WA",134,"Set of 2 Fire Sticks",5.99,"Overnite",0.5,13.7,14.2]
[2905,"WA",139,"Aluminum Matchbox",3.99,"Overnite",0.5,13.7,14.2]
[2921,"AZ",110,"Firebox Bundle",87.75,"Overnite",2.5,11.6,14.1]
[2928,"MT",132,"Adjustable Fire Grate",7.99,"Express",0.5,8.4,8.9]
[2932,"MT",150,"Trangia Fuel Bottle - 0.3L",16.489999999999998,"Express",1,8.4,9.4]
[2938,"CA",138,"Grill Plate",7.99,"Overnite",0.5,11.6,12.1]
[2939,"CO",132,"Adjustable Fire Grate",7.99,"Overnite",0.5,11.6,12.1]
[2979,"OR",124,"The Ugly Bag - HD VCP Bag",9.99,"Overnite",0.5,13.7,14.2]
[2999,"MT",133,"Extended Grill Plate",9.99,"Express",0.5,8.4,8.9]
[3005,"MT",146,"Olicamp Space Saver Cup",8.9600000000000009,"Regular",0.5,6,6.5]
[3034,"MT",121,"Firebox Master Combo Kit",144.97999999999999,"Express",3,8.4,11.4]
[3043,"UT",123,"Cordura D-Ring Bag",15.99,"Regular",1,3,4]
[3049,"UT",132,"Adjustable Fire Grate",7.99,"Express",0.5,4.7,5.2]
[3069,"CA",157,"Nalgene Cantene 32 oz",11.49,"Overnite",1,11.6,12.6]
[3079,"CA",145,"Cube Stove + 9 Fuel Disks",35.99,"Express",2,7.6,9.6]
[3095,"OR",134,"Set of 2 Fire Sticks",11.98,"Express",1,8.4,9.4]
[3111,"AZ",136,"Boil Plate",7.99,"Express",0.5,7.6,8.1]
[3233,"CA",144,"Trangia Spirit Burner",14.99,"Regular",1,5,6]
[3246,"WA",146,"Olicamp Space Saver Cup",8.9600000000000009,"Express",0.5,8.4,8.9]
[3265,"AZ",144,"Trangia Spirit Burner",14.99,"Overnite",1,11.6,12.6]
[3324,"UT",124,"The Ugly Bag - HD VCP Bag",9.99,"Regular",0.5,3,3.5]
[3330,"WA",163,"Klean Kanteen Wide 40 oz",25.16,"Express",1,8.4,9.4]
[3345,"CA",163,"Klean Kanteen Wide 40 oz",25.16,"Overnite",1,11.6,12.6]
[3352,"CO",161,"Olicamp Pot Lifter",4.95,"Overnite",0.5,11.6,12.1]
[3357,"CA",136,"Boil Plate",7.99,"Express",0.5,7.6,8.1]
[3360,"CO",134,"Set of 2 Fire Sticks",5.99,"Regular",0.5,5,5.5]
[3374,"CA",168,"Blue Bag",4.99,"Overnite",0.5,11.6,12.1]
[3377,"AZ",150,"Trangia Fuel Bottle - 0.3L",16.489999999999998,"Regular",{"$f":"VLOOKUP(E140,$K$11:$L$18,2)","v":1},{"$f":"HLOOKUP(B140,$E$5:$N$8,IF(F140=$E$6,2,IF(F140=$E$7,3,4)),FALSE)","v":5},{"$f":"G140+H140","v":6}]
[3381,"OR",150,"Trangia Fuel Bottle - 0.3L",16.489999999999998,"Overnite",1,13.7,14.7]
[3394,"UT",129,"Stainless Steel Cup Charger",149.99,"Regular",3,3,6]
[3403,"CO",128,"Heavy Duty Cordura D-Ring Bag",31.98,"Overnite",2,11.6,13.6]
[3404,"CA",146,"Olicamp Space Saver Cup",8.9600000000000009,"Regular",0.5,5,5.5]
[3429,"OR",171,"Power Bank with Flashlight",14.99,"Regular",1,6,7]
[3430,"HI",128,"Heavy Duty Cordura D-Ring Bag",31.98,"Overnite",2,17.100000000000001,19.100000000000001]
[3441,"HI",121,"Firebox Master Combo Kit",144.97999999999999,"Express",3,13.5,16.5]
[3446,"HI",133,"Extended Grill Plate",9.99,"Overnite",0.5,17.100000000000001,17.600000000000001]
[3464,"OR",127,"Stainless Steel Cooking Pot",19.989999999999998,"Regular",1,6,7]
[3485,"AZ",130,"Emergency Cook Kit",25,"Express",1,7.6,8.6]
[3539,"CA",139,"Aluminum Matchbox",7.98,"Overnite",0.5,11.6,12.1]
[3546,"UT",128,"Heavy Duty Cordura D-Ring Bag",15.99,"Overnite",1,7.8,8.8000000000000007]
[3554,"HI",134,"Set of 2 Fire Sticks",5.99,"Regular",0.5,8,8.5]
[3585,"NV",127,"Stainless Steel Cooking Pot",19.989999999999998,"Overnite",1,11.6,12.6]
[3616,"CA",175,"Folding Firebox Nano",29.99,"Express",1,7.6,8.6]
[3618,"OR",143,"Trangia Fuel Bottle - 0.5L",15.29,"Overnite",1,13.7,14.7]
[3653,"CA",120,"Master Combo Kit",144.97999999999999,"Express",3,7.6,10.6]
[3663,"CA",154,"Deluxe Combo Kit",89.99,"Express",2.5,7.6,10.1]
[3702,"CA",171,"Power Bank with Flashlight",14.99,"Overnite",1,11.6,12.6]
[3718,"CA",176,"Firebox Accessory Kit",31.48,"Express",2,7.6,9.6]
[3800,"MT",168,"Blue Bag",4.99,"Express",0.5,8.4,8.9]

{"sheet":"Conditional Functions","index":4,"n_rows":157,"n_cols":12,"rows_kept":157,"cut":false,"hidden":false,"merged":[[1,1,2,6],[5,9,5,11],[14,9,14,11]]}
[]
[null,"Looking at shipments, at employee performance, and at services required by customers; Quickstove managment performs several analyses."]
[]
[]
[]
["OrderID","Ship To","ProductID","Product Name","Ship Class","Value","Employee",null,null,"Shipments by Employee"]
[1003,"AZ",100,"QuickStove","Express",68.796000000000006,"Merrill",null,null,"Count","Total  Value","Average Value"]
[1004,"WA",100,"QuickStove","Express",85.995000000000005,"George",null,"Merrill",{"$f":"COUNTIF($G$7:$G$157,I8)","v":58},{"$f":"SUMIF($G$7:$G$157,I8,$F$7:$F$157)","v":3027.3441999999968},{"$f":"AVERAGEIF($G$7:$G$157,I8,$F$7:$F$157)","v":52.195589655172355}]
[1007,"NV",100,"QuickStove","Regular",120.39300000000001,"George",null,"Frank",{"$f":"COUNTIF($G$7:$G$157,I9)","v":32},{"$f":"SUMIF($G$7:$G$157,I9,$F$7:$F$157)","v":2098.4031999999997},{"$f":"AVERAGEIF($G$7:$G$157,I9,$F$7:$F$157)","v":65.575099999999992}]
[1011,"UT",100,"QuickStove","Express",120.39300000000001,"Merrill",null,"George",43,2003.2591000000004,46.587420930232568]
[1027,"CA",100,"QuickStove","Overnite",17.55,"Frank",null,"Howard",18,793.84800000000007,{"$f":"AVERAGEIF($G$7:$G$157,I11,$F$7:$F$157)","v":44.102666666666671}]
[1041,"MT",102,"Replacement Fuel Cells","Overnite",4,"Frank",null,"All",{"$f":"COUNTA(G7:G157)","v":151},{"$f":"SUM(F7:F157)","v":7922.8544999999758},{"$f":"AVERAGE(F7:F157)","v":52.469235099337588}]
[1042,"CA",104,"Quick Stove Can","Overnite",69.98,"George"]
[1050,"OR",104,"Quick Stove Can","Overnite",274.32159999999999,"Frank"]
[1058,"UT",104,"Quick Stove Can","Express",274.32159999999999,"Frank",null,null,"Shipments by Shipping Class"]
[1059,"AZ",102,"Replacement Fuel Cells","Regular",15.68,"Frank",null,null,"Count"," Total Value","Average Value"]
[1060,"WA",104,"Quick Stove Can","Overnite",69.98,"George",null,"Regular",{"$f":"COUNTIF($E$7:$E$157,I17)","v":42},{"$f":"SUMIF($E$7:$E$157,I17,$F$7:$F$157)","v":2216.0070999999998},{"$f":"AVERAGEIF($E$7:$E$157,I17,$F$7:$F$157)","v":52.762073809523805}]
[1062,"UT",102,"Replacement Fuel Cells","Regular",60.8,"George",null,"Express",{"$f":"COUNTIF($E$7:$E$157,I18)","v":47},{"$f":"SUMIF($E$7:$E$157,I18,$F$7:$F$157)","v":2703.3295999999987},{"$f":"AVERAGEIF($E$7:$E$157,I18,$F$7:$F$157)","v":57.51765106382976}]
[1073,"CO",104,"Quick Stove Can","Overnite",34.99,"Merrill",null,"Overnite",62,3003.5177999999969,48.44383548387092]
[1074,"CO",102,"Replacement Fuel Cells","Overnite",19.600000000000001,"George"]
[1088,"WA",102,"Replacement Fuel Cells","Overnite",4,"Frank"]
[1094,"NV",102,"Replacement Fuel Cells","Express",8,"George"]
[1109,"HI",102,"Replacement Fuel Cells","Express",8,"Howard"]
[1120,"OR",102,"Replacement Fuel Cells","Express",38,"George"]
[1255,"OR",106,"Stove In A Can","Overnite",34.99,"George"]
[1262,"UT",106,"Stove In A Can","Regular",102.8706,"Merrill"]
[1265,"WA",106,"Stove In A Can","Express",34.99,"Merrill"]
[1267,"CA",106,"Stove In A Can","Overnite",102.8706,"Merrill"]
[1268,"MT",106,"Stove In A Can","Regular",34.99,"Merrill"]
[1364,"AZ",106,"Stove In A Can","Regular",398.88599999999997,"Frank"]
[1417,"UT",108,"QuickStove Fuel Disk","Overnite",37.847999999999999,"George"]
[1629,"CA",107,"SIAC Fuel Cell","Express",10,"George"]
[1635,"CO",106,"Stove In A Can","Express",69.98,"Merrill"]
[1661,"AZ",107,"SIAC Fuel Cell","Regular",47.5,"Merrill"]
[1666,"OR",107,"SIAC Fuel Cell","Express",19.600000000000001,"Merrill"]
[1677,"WA",108,"QuickStove Fuel Disk","Express",31.54,"Frank"]
[1686,"CA",101,"QuickStove Can","Overnite",19.95,"Frank"]
[1701,"CO",101,"QuickStove Can","Overnite",19.95,"Merrill"]
[1708,"AZ",101,"QuickStove Can","Overnite",19.95,"Merrill"]
[1712,"AZ",108,"QuickStove Fuel Disk","Express",47.31,"Frank"]
[1718,"OR",101,"QuickStove Can","Overnite",39.9,"Merrill"]
[1720,"UT",101,"QuickStove Can","Overnite",78.203999999999994,"George"]
[1725,"WA",101,"QuickStove Can","Express",78.203999999999994,"Frank"]
[1733,"CA",110,"Firebox Bundle","Regular",175.5,"Merrill"]
[1746,"CO",110,"Firebox Bundle","Express",87.75,"George"]
[1748,"NV",101,"QuickStove Can","Overnite",78.203999999999994,"Howard"]
[1776,"MT",101,"QuickStove Can","Overnite",78.203999999999994,"Merrill"]
[1797,"WA",114,"Cube Stove + 2 Fuel Disks","Express",49.9,"George"]
[1814,"AZ",114,"Cube Stove + 2 Fuel Disks","Regular",24.95,"Frank"]
[1834,"CO",113,"Firebox Stove w/ Fuel","Overnite",49.95,"Merrill"]
[1835,"CA",113,"Firebox Stove w/ Fuel","Overnite",49.95,"George"]
[1839,"CA",114,"Cube Stove + 2 Fuel Disks","Express",49.9,"Merrill"]
[1842,"MT",108,"QuickStove Fuel Disk","Overnite",18.923999999999999,"Howard"]
[1873,"CA",109,"Folding  Campfire Stove","Regular",59.99,"Merrill"]
[1877,"CA",121,"Firebox Master Combo Kit","Overnite",144.97999999999999,"George"]
[1897,"NV",118,"Firebox Deluxe Combo Kit","Regular",89.99,"George"]
[1913,"AZ",118,"Firebox Deluxe Combo Kit","Regular",89.99,"George"]
[1923,"WA",109,"Folding  Campfire Stove","Regular",59.99,"Frank"]
[1946,"WA",118,"Firebox Deluxe Combo Kit","Overnite",89.99,"Merrill"]
[1964,"AZ",109,"Folding  Campfire Stove","Express",59.99,"George"]
[1979,"HI",118,"Firebox Deluxe Combo Kit","Overnite",89.99,"Frank"]
[1982,"CA",118,"Firebox Deluxe Combo Kit","Overnite",89.99,"Merrill"]
[1990,"CO",109,"Folding  Campfire Stove","Regular",59.99,"Frank"]
[2000,"WA",121,"Firebox Master Combo Kit","Express",144.97999999999999,"George"]
[2031,"CA",117,"Firebox Upgrade Kit","Overnite",69.959999999999994,"Merrill"]
[2078,"AZ",117,"Firebox Upgrade Kit","Overnite",34.979999999999997,"Howard"]
[2093,"AZ",121,"Firebox Master Combo Kit","Overnite",144.97999999999999,"Frank"]
[2136,"NV",109,"Folding  Campfire Stove","Overnite",59.99,"Frank"]
[2146,"CO",118,"Firebox Deluxe Combo Kit","Regular",89.99,"Merrill"]
[2168,"NV",108,"QuickStove Fuel Disk","Regular",31.54,"Merrill"]
[2198,"UT",114,"Cube Stove + 2 Fuel Disks","Regular",24.95,"Merrill"]
[2202,"AZ",123,"Cordura D-Ring Bag","Regular",15.99,"George"]
[2217,"WA",117,"Firebox Upgrade Kit","Regular",34.979999999999997,"Frank"]
[2218,"OR",118,"Firebox Deluxe Combo Kit","Overnite",89.99,"Merrill"]
[2249,"OR",117,"Firebox Upgrade Kit","Regular",34.979999999999997,"Howard"]
[2258,"CA",123,"Cordura D-Ring Bag","Regular",15.99,"George"]
[2283,"UT",118,"Firebox Deluxe Combo Kit","Overnite",89.99,"Howard"]
[2319,"WA",124,"The Ugly Bag - HD VCP Bag","Express",9.99,"Merrill"]
[2324,"UT",121,"Firebox Master Combo Kit","Regular",144.97999999999999,"George"]
[2328,"MT",118,"Firebox Deluxe Combo Kit","Express",89.99,"Frank"]
[2331,"UT",109,"Folding  Campfire Stove","Regular",59.99,"George"]
[2353,"CA",124,"The Ugly Bag - HD VCP Bag","Express",19.98,"Merrill"]
[2358,"HI",109,"Folding  Campfire Stove","Express",59.99,"George"]
[2386,"CO",123,"Cordura D-Ring Bag","Regular",15.99,"George"]
[2393,"CO",114,"Cube Stove + 2 Fuel Disks","Express",24.95,"Frank"]
[2417,"OR",109,"Folding  Campfire Stove","Overnite",59.99,"Merrill"]
[2419,"HI",123,"Cordura D-Ring Bag","Regular",15.99,"George"]
[2423,"AZ",124,"The Ugly Bag - HD VCP Bag","Overnite",29.370600000000003,"George"]
[2439,"UT",117,"Firebox Upgrade Kit","Overnite",34.979999999999997,"Merrill"]
[2513,"AZ",125,"3 Months Fuel  with Stove","Overnite",189.99,"Merrill"]
[2521,"CA",125,"3 Months Fuel  with Stove","Express",189.99,"Merrill"]
[2527,"CO",117,"Firebox Upgrade Kit","Overnite",34.979999999999997,"Merrill"]
[2605,"CO",125,"3 Months Fuel  with Stove","Express",189.99,"Merrill"]
[2644,"WA",128,"Heavy Duty Cordura D-Ring Bag","Overnite",15.99,"George"]
[2653,"OR",129,"Stainless Steel Cup Charger","Overnite",149.99,"Howard"]
[2714,"NV",117,"Firebox Upgrade Kit","Overnite",34.979999999999997,"Frank"]
[2726,"CA",127,"Stainless Steel Cooking Pot","Overnite",19.989999999999998,"George"]
[2779,"MT",109,"Folding  Campfire Stove","Express",59.99,"Merrill"]
[2829,"HI",132,"Adjustable Fire Grate","Regular",7.99,"Merrill"]
[2833,"OR",132,"Adjustable Fire Grate","Regular",7.99,"Howard"]
[2837,"AZ",127,"Stainless Steel Cooking Pot","Regular",19.989999999999998,"Howard"]
[2855,"AZ",137,"QuickStove Fire Starter","Express",3.9,"Merrill"]
[2859,"CA",132,"Adjustable Fire Grate","Overnite",39.151000000000003,"George"]
[2865,"CA",137,"QuickStove Fire Starter","Regular",64.837499999999991,"George"]
[2868,"NV",132,"Adjustable Fire Grate","Regular",7.99,"George"]
[2887,"WA",123,"Cordura D-Ring Bag","Overnite",15.99,"Merrill"]
[2889,"OR",133,"Extended Grill Plate","Express",9.99,"Frank"]
[2896,"WA",132,"Adjustable Fire Grate","Regular",7.99,"Merrill"]
[2903,"WA",134,"Set of 2 Fire Sticks","Overnite",5.99,"George"]
[2905,"WA",139,"Aluminum Matchbox","Overnite",3.99,"Frank"]
[2921,"AZ",110,"Firebox Bundle","Overnite",87.75,"Howard"]
[2928,"MT",132,"Adjustable Fire Grate","Express",7.99,"Frank"]
[2932,"MT",150,"Trangia Fuel Bottle - 0.3L","Express",16.489999999999998,"George"]
[2938,"CA",138,"Grill Plate","Overnite",7.99,"Frank"]
[2939,"CO",132,"Adjustable Fire Grate","Overnite",7.99,"George"]
[2979,"OR",124,"The Ugly Bag - HD VCP Bag","Overnite",9.99,"Merrill"]
[2999,"MT",133,"Extended Grill Plate","Express",9.99,"Merrill"]
[3005,"MT",146,"Olicamp Space Saver Cup","Regular",8.9600000000000009,"Howard"]
[3034,"MT",121,"Firebox Master Combo Kit","Express",144.97999999999999,"Merrill"]
[3043,"UT",123,"Cordura D-Ring Bag","Regular",15.99,"Merrill"]
[3049,"UT",132,"Adjustable Fire Grate","Express",7.99,"George"]
[3069,"CA",157,"Nalgene Cantene 32 oz","Overnite",11.49,"Merrill"]
[3079,"CA",145,"Cube Stove + 9 Fuel Disks","Express",35.99,"Howard"]
[3095,"OR",134,"Set of 2 Fire Sticks","Express",11.98,"Merrill"]
[3111,"AZ",136,"Boil Plate","Express",7.99,"Merrill"]
[3233,"CA",144,"Trangia Spirit Burner","Regular",14.99,"George"]
[3246,"WA",146,"Olicamp Space Saver Cup","Express",8.9600000000000009,"Merrill"]
[3265,"AZ",144,"Trangia Spirit Burner","Overnite",14.99,"Frank"]
[3324,"UT",124,"The Ugly Bag - HD VCP Bag","Regular",9.99,"Merrill"]
[3330,"WA",163,"Klean Kanteen Wide 40 oz","Express",25.16,"Howard"]
[3345,"CA",163,"Klean Kanteen Wide 40 oz","Overnite",25.16,"Merrill"]
[3352,"CO",161,"Olicamp Pot Lifter","Overnite",4.95,"Merrill"]
[3357,"CA",136,"Boil Plate","Express",7.99,"Howard"]
[3360,"CO",134,"Set of 2 Fire Sticks","Regular",5.99,"Merrill"]
[3374,"CA",168,"Blue Bag","Overnite",4.99,"Merrill"]
[3377,"AZ",150,"Trangia Fuel Bottle - 0.3L","Regular",16.489999999999998,"Frank"]
[3381,"OR",150,"Trangia Fuel Bottle - 0.3L","Overnite",16.489999999999998,"Merrill"]
[3394,"UT",129,"Stainless Steel Cup Charger","Regular",149.99,"Merrill"]
[3403,"CO",128,"Heavy Duty Cordura D-Ring Bag","Overnite",31.98,"Frank"]
[3404,"CA",146,"Olicamp Space Saver Cup","Regular",8.9600000000000009,"Merrill"]
[3429,"OR",171,"Power Bank with Flashlight","Regular",14.99,"Howard"]
[3430,"HI",128,"Heavy Duty Cordura D-Ring Bag","Overnite",31.98,"George"]
[3441,"HI",121,"Firebox Master Combo Kit","Express",144.97999999999999,"Howard"]
[3446,"HI",133,"Extended Grill Plate","Overnite",9.99,"George"]
[3464,"OR",127,"Stainless Steel Cooking Pot","Regular",19.989999999999998,"George"]
[3485,"AZ",130,"Emergency Cook Kit","Express",25,"Merrill"]
[3539,"CA",139,"Aluminum Matchbox","Overnite",7.98,"Frank"]
[3546,"UT",128,"Heavy Duty Cordura D-Ring Bag","Overnite",15.99,"Merrill"]
[3554,"HI",134,"Set of 2 Fire Sticks","Regular",5.99,"Merrill"]
[3585,"NV",127,"Stainless Steel Cooking Pot","Overnite",19.989999999999998,"Howard"]
[3616,"CA",175,"Folding Firebox Nano","Express",29.99,"Frank"]
[3618,"OR",143,"Trangia Fuel Bottle - 0.5L","Overnite",15.29,"George"]
[3653,"CA",120,"Master Combo Kit","Express",144.97999999999999,"Frank"]
[3663,"CA",154,"Deluxe Combo Kit","Express",89.99,"Merrill"]
[3702,"CA",171,"Power Bank with Flashlight","Overnite",14.99,"George"]
[3718,"CA",176,"Firebox Accessory Kit","Express",31.48,"Frank"]
[3800,"MT",168,"Blue Bag","Express",4.99,"Howard"]