{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Topics","Spreadsheet Models","FC VC Analysis","Quad FC VC Profit","Goal Seek","1 V Data Table","2 V Data Table","Calcualte Revenue","Shipping Costs"],"not_rendered":{"charts":1,"images":2,"macros":0,"external_links":0,"defined_names":4,"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":"Topics","index":0,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Good Spreadsheet Model Design"]
["Model 01: FC/VC Example"]
["Build Formula Input Area and Model area separately"]
["Goal Seek"]
["Data Tables"]
["Chart"]
["Model 02: Calculate Total Revenue from Transactional Data and Lookup Tables"]
["SUM, VLOOKUP, COUNTIFS, SUMPRODUCT and LOOKUP functions."]
["Model 03: Calculate Total Shipping Costs"]
["MIN, INDEX, MATCH, IF functions."]

{"sheet":"Spreadsheet Models","index":1,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Good Spreadsheet Model Building:"]
["1) Excel’s Golden Rule: If formula input (parameter, assumption, variable) can change put it in a cell and"]
["refer to it in the formula with a cell reference."]
["2) Label all formula inputs."]
["3) Separate the formula input area from the model area."]
["4) Model is where you create your formulas and where you can put your decision variable."]
["5) Label all elements in the model area."]
["6) Use appropriate Number & Stylistic Formatting to make the spreadsheet easy to understand."]
["Remember: Number Formatting is a Facade."]
["7) Keep default alignments to visually portray the data type (Numbers to the right, Text to the left)"]
["8) Name all sheets and files smartly."]
["9) Sometimes it is helpful to create math formulas or a influence diagram to describe your model."]

{"sheet":"FC VC Analysis","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Quad FC VC Profit","index":3,"n_rows":31,"n_cols":3,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Formula Inputs (Parameters, Assumptions, Variables)"]
["Gel Boomerangs","Manufactures Boomerangs"]
["Product to be made","Quad"]
["Total Fixed Costs = FC",17430]
["Material costs per unit = MC",4.3]
["Assigned Indirect Costs per unit = IC",1.1499999999999999]
["Labor Costs per units = LC",4.17]
["Revenue = R",16.5]
["% of boomerangs made, but not sold (defects & returns) = D",0.02]
["Goal:","Calculate and Analyze Profit"]
[]
[]
[]
[]
[]
["Math Formula:"]
["Variable cost per unit = VC = MC + IC + LC"]
["Total Variable Costs = TVC(q) = VC*q"]
["Total Costs = TC(q) = FC + TVC(q)"]
["Total Revenue = TR(q) = R*q*(1-D)"]
["Total Profit = TP(q) =TR(q) - TC(q)"]
["Unit Break Even Point = UBE = FC/(R*(1-D)-VC)"]
[]
["Model: Calculate Total Profit Based on Quantity"]
["Production Volume = Units Produced = Quantity = q",2000,"Decision Variable"]
[{"$f":"A17","v":"Variable cost per unit = VC = MC + IC + LC"},{"$f":"SUM(B5:B7)","v":9.6199999999999992}]
["Total Variable Costs = TVC(q) = VC*q",{"$f":"B26*B25","v":19240}]
["Total Costs = TC(q) = FC + TVC(q)",{"$f":"B4+B27","v":36670}]
["Total Revenue = TR(q) = R*q*(1-D)",{"$f":"B8*B25*(1-B9)","v":32340}]
["Total Profit = TP(q) =TR(q) - TC(q)",{"$f":"B29-B28","v":-4330}]
["Unit Break Even Point = UBE = FC/(R*(1-D)-VC)",{"$f":"ROUNDUP(B4/(B8*(1-B9)-B26),0)","v":2662}]

{"sheet":"Goal Seek","index":4,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Formula Inputs (Parameters, Assumptions, Variables)"]
["Gel Boomerangs","Manufactures Boomerangs"]
["Product to be made","Quad"]
["Total Fixed Costs = FC",17430]
["Material costs per unit = MC",4.3]
["Assigned Indirect Costs per unit = IC",1.1499999999999999]
["Labor Costs per units = LC",4.17]
["Revenue = R",16.5]
["% of boomerangs made, but not sold (defects & returns) = D",0.02]
["Goal:","Calculate and Analyze Profit"]
[]
[]
[]
[]
[]
["Math Formula:"]
["Variable cost per unit = VC = MC + IC + LC"]
["Total Variable Costs = TVC(q) = VC*q"]
["Total Costs = TC(q) = FC + TVC(q)"]
["Total Revenue = TR(q) = R*q*(1-D)"]
["Total Profit = TP(q) =TR(q) - TC(q)"]
[]
[]
["Model: Calculate Total Profit Based on Quantity"]
["Production Volume = Units Produced = Quantity = q",2000,"Decision Variable"]
[{"$f":"A17","v":"Variable cost per unit = VC = MC + IC + LC"},{"$f":"SUM(B5:B7)","v":9.6199999999999992}]
[{"$f":"A18","v":"Total Variable Costs = TVC(q) = VC*q"},{"$f":"B26*B25","v":19240}]
[{"$f":"A19","v":"Total Costs = TC(q) = FC + TVC(q)"},{"$f":"B4+B27","v":36670}]
[{"$f":"A20","v":"Total Revenue = TR(q) = R*q*(1-D)"},{"$f":"B8*B25*(1-B9)","v":32340}]
[{"$f":"A21","v":"Total Profit = TP(q) =TR(q) - TC(q)"},{"$f":"B29-B28","v":-4330}]
[]
[]
["When \"By Change Cells\" was the \"Quantity\" Variable, Goal Seek gave us break even  Total Profit of $0 when the units were changed to 2,661."]
["When \"By Change Cells\" was the \"Revenue\" Variable, Goal Seek gave us break even  Total Profit of $0 when the Revenue was changed to $18.71"]

{"sheet":"1 V Data Table","index":5,"n_rows":62,"n_cols":14,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
["Formula Inputs (Parameters, Assumptions, Variables)"]
["Gel Boomerangs","Manufactures Boomerangs"]
["Product to be made","Quad"]
["Total Fixed Costs = FC",17430]
["Material costs per unit = MC",4.3]
["Assigned Indirect Costs per unit = IC",1.1499999999999999]
["Labor Costs per units = LC",4.17]
["Revenue = R",16.5]
["% of boomerangs made, but not sold (defects & returns) = D",0.02]
["Goal:","Calculate and Analyze Profit"]
["Data Table Start Unit Value",0]
["Data Table Unit Increment Value",500]
[]
[]
[]
["Math Formula:"]
["Variable cost per unit = VC = MC + IC + LC"]
["Total Variable Costs = TVC(q) = VC*q"]
["Total Costs = TC(q) = FC + TVC(q)"]
["Total Revenue = TR(q) = R*q*(1-D)"]
["Total Profit = TP(q) =TR(q) - TC(q)"]
["Unit Break Even Point = UBE = FC/(R*(1-D)-VC)"]
[]
["Model: Calculate Total Profit Based on Quantity"]
["Production Volume = Units Produced = Quantity = q",2000,"Decision Variable",null,"X","Y"]
[{"$f":"A17","v":"Variable cost per unit = VC = MC + IC + LC"},{"$f":"SUM(B5:B7)","v":9.6199999999999992},null,null,{"$f":"B31","v":2662},{"$f":"B4+E26*B26","v":43038.44}]
["Total Variable Costs = TVC(q) = VC*q",{"$f":"B26*B25","v":19240}]
["Total Costs = TC(q) = FC + TVC(q)",{"$f":"B4+B27","v":36670},null,null,"BEU Label:"]
["Total Revenue = TR(q) = R*q*(1-D)",{"$f":"B8*B25*(1-B9)","v":32340},null,null,{"$f":"\"BEU = \"&E26","v":"BEU = 2662"}]
["Total Profit = TP(q) =TR(q) - TC(q)",{"$f":"B29-B28","v":-4330}]
["Unit Break Even Point = UBE = FC/(R*(1-D)-VC)",{"$f":"ROUNDUP(B4/(B8*(1-B9)-B26),0)","v":2662}]
[]
["What-If Analysis: Data Table, 1 Variable:",null,"Total Revenue","Total Costs","Fixed Costs","Total Profit"]
[null,"Quantity",{"$f":"B29","v":32340},{"$f":"B28","v":36670},{"$f":"B4","v":17430},{"$f":"B30","v":-4330}," <<== Formulas From Original Model (q = 2000)"]
[null,{"$f":"B11","v":0},0,17430,17430,-17430,null,null,null,null,null,null,null,"Steps to create Data Table:"]
[null,{"$f":"B35+$B$12","v":500},8085,22240,17430,-14155,null,null,null,null,null,null,null,"1) You must have a formula that uses formula inputs. We have that in cell B30. It is the Total Profit = TP(q) =TR(q) - TC(q) formula."]
[null,1000,16170,27050,17430,-10880,null,null,null,null,null,null,null,"2) The B30 formula is pointing to two previous formulas (cells B28 and B29) that use the formula input from cell B25 (our decision variable)."]
[null,1500,24255,31860,17430,-7605,null,null,null,null,null,null,null,"3) In cell C34, create a formula that points to the Total Profit = TP(q) =TR(q) - TC(q) formula."]
[null,2000,32340,36670,17430,-4330,null,null,null,null,null,null,null,"4) Because we want to see how the \"Total Profit\" formula will change when we change the Decision Variable, \"Quantity\", we create a column of the new quantity inputs for quantity in the range B35:B47."]
[null,2500,40425,41480,17430,-1055,null,null,null,null,null,null,null,"5) We highlight the range B34:C47, with the range C35:C47 containing empty cells."]
[null,3000,48510,46290,17430,2220,null,null,null,null,null,null,null,"6) On the Data Ribbon, we go to the Data Tools group, then click on the What-If Analysis dropdown arrow, then click Data Table."]
[null,3500,56595,51100,17430,5495,null,null,null,null,null,null,null,"7) Keyboard for Data Table: Alt, A, W, T or Alt, D, T"]
[null,4000,64680,55910,17430,8770,null,null,null,null,null,null,null,"8) Because out New Inputs for \"Quantity\" are in a column, we click in the \"Column input cell\" textbox and then click on the cell that contains the Decision Variable, \"Quantity\", cell B25."]
[null,4500,72765,60720,17430,12045,null,null,null,null,null,null,null,"9) When you click OK, the Array Function TABLE is automatically entered as an Array Formula (notice the curly brackets in the formula bar)"]
[null,5000,80850,65529.999999999993,17430,15320.000000000007,null,null,null,null,null,null,null,"10) This TABLE function automatically takes the formula in cell B30 (which is using the two previous formulas in cells B28 and B29) and substitutes the New Inputs for Quantities and displays the results in the range C35:C47."]
[null,5500,88935,70340,17430,18595,null,null,null,null,null,null,null,"**Note: the use of \"Column input cell\" may seem backwards if you are used to using PivotTables where we have \"Row area\" Criteria and \"Column area\" criteria. This is an inconsistency on Microsoft's part."]
[null,6000,97020,75150,17430,21870]
[]
["What-If Analysis: Formulas","Units","Total Revenue","Total Costs","Fixed Costs","Total Profit"]
[null,{"$f":"B11","v":0},{"$f":"B50*$B$8*(1-$B$9)","v":0},{"$f":"E50+B50*$B$26","v":17430},{"$f":"$B$4","v":17430},{"$f":"C50-D50","v":-17430}]
[null,{"$f":"B50+$B$12","v":500},{"$f":"B51*$B$8*(1-$B$9)","v":8085},22240,{"$f":"$B$4","v":17430},-14155]
[null,{"$f":"B51+$B$12","v":1000},16170,27050,17430,-10880]
[null,1500,24255,31860,17430,-7605]
[null,2000,32340,36670,17430,-4330]
[null,2500,40425,41480,17430,-1055]
[null,3000,48510,46290,17430,2220]
[null,3500,56595,51100,17430,5495]
[null,4000,64680,55910,17430,8770]
[null,4500,72765,60720,17430,12045]
[null,5000,80850,65529.999999999993,17430,15320.000000000007]
[null,{"$f":"B60+$B$12","v":5500},88935,70340,17430,18595]
[null,6000,97020,75150,17430,21870]

{"sheet":"2 V Data Table","index":6,"n_rows":62,"n_cols":12,"rows_kept":62,"cut":false,"hidden":false,"merged":[[33,1,45,1],[31,3,31,7]]}
["Formula Inputs (Parameters, Assumptions, Variables)"]
["Gel Boomerangs","Manufactures Boomerangs"]
["Product to be made","Quad"]
["Total Fixed Costs = FC",17430]
["Material costs per unit = MC",4.3]
["Assigned Indirect Costs per unit = IC",1.1499999999999999]
["Labor Costs per units = LC",4.17]
["Revenue = R",16.5]
["% of boomerangs made, but not sold (defects & returns) = D",0.02]
["Goal:","Calculate and Analyze Profit"]
["Data Table Start Unit Value",1000]
["Data Table Unit Increment Value",500]
["Defect Rate Start Value",0.02]
["Defect Rate Increment Value",5.0000000000000001E-3]
[]
["Math Formula:"]
["Variable cost per unit = VC = MC + IC + LC"]
["Total Variable Costs = TVC(q) = VC*q"]
["Total Costs = TC(q) = FC + TVC(q)"]
["Total Revenue = TR(q) = R*q*(1-D)"]
["Total Profit = TP(q) =TR(q) - TC(q)"]
["Unit Break Even Point = UBE = FC/(R*(1-D)-VC)"]
[]
["Model: Calculate Total Profit Based on Quantity"]
["Production Volume = Units Produced = Quantity = q",2000,"Decision Variable"]
[{"$f":"A17","v":"Variable cost per unit = VC = MC + IC + LC"},{"$f":"SUM(B5:B7)","v":9.6199999999999992}]
["Total Variable Costs = TVC(q) = VC*q",{"$f":"B26*B25","v":19240}]
["Total Costs = TC(q) = FC + TVC(q)",{"$f":"B4+B27","v":36670}]
["Total Revenue = TR(q) = R*q*(1-D)",{"$f":"B8*B25*(1-B9)","v":32340}]
["Total Profit = TP(q) =TR(q) - TC(q)",{"$f":"B29-B28","v":-4330}]
["Unit Break Even Point = UBE = FC/(R*(1-D)-VC)",{"$f":"ROUNDUP(B4/(B8*(1-B9)-B26),0)","v":2662}]
[null,null,null,{"$f":"A9","v":"% of boomerangs made, but not sold (defects & returns) = D"}]
[null,"Formula From Original Model (q = 2000) ==>>",{"$f":"B30","v":-4330},{"$f":"B13","v":0.02},{"$f":"D33+$B$14","v":2.5000000000000001E-2},{"$f":"E33+$B$14","v":3.0000000000000002E-2},3.5000000000000003E-2,0.04,null,null,null,"Steps for 2 Variable Data Table:"]
[null,{"$f":"A25","v":"Production Volume = Units Produced = Quantity = q"},{"$f":"B11","v":1000},-10880,-10962.5,-11045,-11127.5,-11210,null,null,null,"1) You must have a formula that uses formula inputs. We have that in cell B30. It is the Total Profit = TP(q) =TR(q) - TC(q) formula."]
[null,null,{"$f":"C34+$B$12","v":1500},-7605,-7728.75,-7852.5,-7976.25,-8100,null,null,null,"2) The B30 formula is pointing to two previous formulas (cells B28 and B29) that use the formula inputs from cell B25 (our decision variable) and from cell B9 (Defect Rate)."]
[null,null,{"$f":"C35+$B$12","v":2000},-4330,-4495,-4660,-4825,-4990,null,null,null,"3) In cell C33, create a formula that points to the \"Total Revenue\" formula. This must be in the upper left corner!!!!"]
[null,null,2500,-1055,-1261.25,-1467.5,-1673.75,-1880,null,null,null,"4) Because we want to see how the \"Total Revenue\" formula will change when we change the Decision Variable, \"Quantity\" and \"Defect Rate\", we create a column of the new quantity inputs for quantity in the range C34:C46 and a row of new costs in the range D33:H33."]
[null,null,3000,2220,1972.5,1725,1477.5,1230,null,null,null,"5) We highlight the range C33:H46, with the range D34:H46 containing empty cells."]
[null,null,3500,5495,5206.25,4917.5,4628.75,4340,null,null,null,"6) On the Data Ribbon, we go to the Data Tools group, then click on the What-If Analysis dropdown arrow, then click Data Table."]
[null,null,4000,8770,8440,8110,7780,7450,null,null,null,"7) Keyboard for Data Table: Alt, A, W, T or Alt, D, T"]
[null,null,4500,12045,11673.75,11302.5,10931.25,10560,null,null,null,"8) Because our New Inputs for \"Quantity\" are in a column, we click in the \"Column input cell\" textbox and then click on the cell that contains the Decision Variable, \"Quantity\", cell B25."]
[null,null,5000,15320.000000000007,14907.500000000007,14495.000000000007,14082.500000000007,13670.000000000007,null,null,null,"9) Because our New Inputs for \"Defect Rate\" are in a row, we click in the \"Row input cell\" textbox and then click on the cell that contains the Variable, \"Defect Rate\", cell B9."]
[null,null,5500,18595,18141.25,17687.5,17233.75,16780,null,null,null,"10) When you click OK, the Array Function TABLE is automatically entered as an Array Formula (notice the curly brackets in the formula bar)"]
[null,null,6000,21870,21375,20880,20385,19890,null,null,null,"11) This TABLE function automatically takes the formula in cell B30 (which is using the two previous formulas in cells B25 and B9) and substitutes the New Inputs for Quantities and Defect Rate into the TABLE function formula and displays the results in the range D34:H46."]
[null,null,6500,25145,24608.75,24072.5,23536.25,23000,null,null,null,"**Note: the use of \"Column input cell\" and \"Row input cell\" may seem backwards if you are used to using PivotTables where we have \"Row area\" Criteria and \"Column area\" criteria. This is an inconsistency on Microsoft's part."]
[null,null,7000,28420,27842.5,27265,26687.5,26110]
[]
[]
["What-If Analysis: Formula Version for  2 Variable:",null,"Units/Defect %",{"$f":"B13","v":0.02},{"$f":"D49+$B$14","v":2.5000000000000001E-2},{"$f":"E49+$B$14","v":3.0000000000000002E-2},3.5000000000000003E-2,0.04]
[null,null,{"$f":"B11","v":1000},{"$f":"$C50*$B$8*(1-D$49)-($C50*$B$26+$B$4)","v":-10880},-10962.5,-11045,-11127.5,-11210]
[null,null,{"$f":"C50+$B$12","v":1500},-7605,-7728.75,-7852.5,-7976.25,-8100]
[null,null,{"$f":"C51+$B$12","v":2000},-4330,-4495,-4660,-4825,-4990]
[null,null,2500,-1055,-1261.25,-1467.5,-1673.75,-1880]
[null,null,3000,2220,1972.5,1725,1477.5,1230]
[null,null,3500,5495,5206.25,4917.5,4628.75,4340]
[null,null,4000,8770,8440,8110,7780,7450]
[null,null,4500,12045,11673.75,11302.5,10931.25,10560]
[null,null,5000,15320.000000000007,14907.500000000007,14495.000000000007,14082.500000000007,13670.000000000007]
[null,null,5500,18595,18141.25,17687.5,17233.75,16780]
[null,null,6000,21870,21375,20880,20385,19890]
[null,null,6500,25145,24608.75,24072.5,23536.25,23000]
[null,null,7000,28420,27842.5,27265,26687.5,26110]

{"sheet":"Calcualte Revenue","index":7,"n_rows":179,"n_cols":17,"rows_kept":179,"cut":false,"hidden":false,"merged":[]}
["A company that sells rolls of fence needs to calculate total revenue from a list of customer transactions and a pricing table."]
["Given the transactional data table with the number of rolls of fence sold for each transaction and the pricing table,"]
["calculate total revenue and count the number of transactions that fell into each pricing category."]
[]
["Data set with number of rolls of fence sold for each transaction:",null,null,null,null,null,null,null,"Pricing Table:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOOKUP to get Price:"]
["Date","Number of Rolls","Price","Revenue",null,"Total Revenue\nHelper Column","Total Revenue\nSingle Cell Formula",null,"Units From","Units To","Price per Roll (100 feet)","Count Transactions in Each Price Category","Count Transactions in Each Price Category",null,null,null,{"$f":"LOOKUP(B8,$I$8:$K$11)","v":168}]
["2015-09-16",540,{"$f":"VLOOKUP(B8,$I$8:$K$11,3)","v":168},{"$f":"C8*B8","v":90720},null,{"$f":"SUM(D8:D179)","v":11852436},{"$f":"SUMPRODUCT(LOOKUP(B8:B179,I8:K11),B8:B179)","v":11852436},null,0,143,198,{"$f":"COUNTIFS($C$8:$C$179,K8)","v":22},{"$f":"COUNTIFS($B$8:$B$179,\">=\"&I8,$B$8:$B$179,\"<=\"&J8)","v":22},null,null,null,168]
["2015-09-15",360,{"$f":"VLOOKUP(B9,$I$8:$K$11,3)","v":168},{"$f":"C9*B9","v":60480},null,null,null,null,144,288,187,{"$f":"COUNTIFS($C$8:$C$179,K9)","v":34},{"$f":"COUNTIFS($B$8:$B$179,\">=\"&I9,$B$8:$B$179,\"<=\"&J9)","v":34},null,null,null,198]
["2015-09-16",12,198,2376,null,null,null,null,289,577,168,65,65,null,null,null,168]
["2015-09-15",468,168,78624,null,null,null,null,578,"and up",152,51,{"$f":"COUNTIFS($B$8:$B$179,\">=\"&I11)","v":51},null,null,null,198]
["2015-09-17",48,198,9504,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-18",84,198,16632,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-17",540,168,90720,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-18",492,168,82656,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-18",204,187,38148,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-15",408,168,68544,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-17",780,152,118560,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-16",444,168,74592,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-15",432,168,72576,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-16",456,168,76608,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-16",768,152,116736,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-17",528,168,88704,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-15",624,152,94848,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-17",372,168,62496,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-18",588,152,89376,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-15",504,168,84672,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-16",504,168,84672,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-18",660,152,100320,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-16",468,168,78624,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-18",492,168,82656,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-18",204,187,38148,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-15",168,187,31416,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-17",84,198,16632,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-17",588,152,89376,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-15",240,187,44880,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-18",696,152,105792,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-15",360,168,60480,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-15",264,187,49368,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(B40,$I$8:$K$11)","v":152}]
["2015-09-15",612,152,93024,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-16",792,152,120384,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-18",12,198,2376,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-18",324,168,54432,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-15",324,168,54432,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-15",588,152,89376,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-17",492,168,82656,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-15",804,152,122208,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-15",540,168,90720,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-17",468,168,78624,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-15",624,152,94848,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-16",396,168,66528,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-15",36,198,7128,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-18",384,168,64512,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-15",132,198,26136,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-18",312,168,52416,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-16",492,168,82656,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-17",516,168,86688,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-16",744,152,113088,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-15",240,187,44880,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-17",252,187,47124,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-15",768,152,116736,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-15",468,168,78624,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-15",720,152,109440,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-17",804,152,122208,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-17",192,187,35904,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-15",732,152,111264,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-17",216,187,40392,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-15",648,152,98496,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-16",432,168,72576,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-15",384,168,64512,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-15",144,187,26928,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(B72,$I$8:$K$11)","v":152}]
["2015-09-18",684,152,103968,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-15",216,{"$f":"VLOOKUP(B73,$I$8:$K$11,3)","v":187},{"$f":"C73*B73","v":40392},null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-15",480,168,80640,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-15",384,168,64512,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-15",84,198,16632,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-15",756,152,114912,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-18",744,152,113088,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-18",300,168,50400,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-15",576,168,96768,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-18",408,168,68544,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-17",420,168,70560,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-16",240,187,44880,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-17",96,198,19008,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-16",348,168,58464,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-18",420,168,70560,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-18",132,198,26136,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-15",516,168,86688,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-17",576,168,96768,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-18",288,187,53856,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-15",492,168,82656,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-15",636,152,96672,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-16",348,168,58464,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-15",168,187,31416,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-15",264,187,49368,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-18",600,152,91200,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-15",216,187,40392,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-18",648,152,98496,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-17",288,187,53856,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-16",684,152,103968,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-15",168,187,31416,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-16",756,152,114912,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-17",648,152,98496,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(B104,$I$8:$K$11)","v":152}]
["2015-09-15",696,152,105792,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-17",456,168,76608,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-16",696,152,105792,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-17",252,187,47124,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-16",732,152,111264,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-18",132,198,26136,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-17",744,152,113088,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-18",732,152,111264,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-17",312,168,52416,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-18",288,187,53856,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-17",108,198,21384,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-18",540,168,90720,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-15",648,152,98496,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-16",156,187,29172,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-18",12,198,2376,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-16",216,187,40392,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-15",660,152,100320,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-18",168,187,31416,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-17",624,152,94848,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-15",72,198,14256,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-16",444,168,74592,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-17",204,187,38148,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-17",576,168,96768,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-18",84,198,16632,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-18",108,198,21384,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-16",228,187,42636,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-15",408,168,68544,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-16",516,168,86688,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-16",804,152,122208,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-18",696,152,105792,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-16",264,187,49368,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-15",396,168,66528,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(B136,$I$8:$K$11)","v":152}]
["2015-09-15",780,152,118560,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-17",12,{"$f":"VLOOKUP(B137,$I$8:$K$11,3)","v":198},{"$f":"C137*B137","v":2376},null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-16",432,168,72576,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-15",216,187,40392,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-18",768,152,116736,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-15",204,187,38148,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-16",540,168,90720,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-17",300,168,50400,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-15",804,152,122208,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-16",132,198,26136,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-17",804,152,122208,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-17",168,187,31416,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-15",96,198,19008,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-17",588,152,89376,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-15",384,168,64512,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-17",456,168,76608,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-17",24,198,4752,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-18",684,152,103968,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-17",384,168,64512,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-15",192,187,35904,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-16",300,168,50400,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-18",684,152,103968,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-16",288,187,53856,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-18",432,168,72576,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-16",648,152,98496,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-16",324,168,54432,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-16",24,198,4752,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-15",552,168,92736,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-17",168,187,31416,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-17",744,152,113088,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-17",228,187,42636,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-16",636,152,96672,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(B168,$I$8:$K$11)","v":168}]
["2015-09-16",312,168,52416,null,null,null,null,null,null,null,null,null,null,null,null,198]
["2015-09-16",36,198,7128,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-17",492,168,82656,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-17",660,152,100320,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-15",756,152,114912,null,null,null,null,null,null,null,null,null,null,null,null,187]
["2015-09-18",288,187,53856,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-18",408,168,68544,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-16",384,168,64512,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-18",612,152,93024,null,null,null,null,null,null,null,null,null,null,null,null,152]
["2015-09-15",600,152,91200,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-17",432,168,72576,null,null,null,null,null,null,null,null,null,null,null,null,168]
["2015-09-16",300,168,50400]

{"sheet":"Shipping Costs","index":8,"n_rows":77,"n_cols":14,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
["A Compressor Sales Company has four shipping centers. It delevers the compressors to customers by truck. The per mile shipping charge is $3.11 with a minimum charge of $75.",null,null,null,null,null,null,null,null,null,null,null,"Formula Inputs (Parameters, Assumptions, Variables)"]
["For each customer, determine which Shipping Center has the shortest distance and then calculate the total shipping charge for each customer transaction.",null,null,null,null,null,null,null,null,null,null,null,"Per Mile Shipping Charge",3.11]
[null,null,null,null,null,null,null,null,null,null,null,null,"Minimum Charge",75]
[null,null,null,null,"Seattle, Washington","Milwaukee, Wisconsin","Birmingham, Alabama","Oakland, California"]
["Customer List of Destination Zip Codes for current transactions:",null,null,null,"Shipping Center Source Zip Code with Miles from Shipping Center to Destination:"]
[]
["City","State","Zip Code",null,"98108","53203","35203","94612","Min Distance","Shipping Center","Total Shipping Charge"]
["Chandler","Arizona","85225",null,1447,1830,1686,766,{"$f":"MIN(E8:H8)","v":766},{"$f":"INDEX($E$4:$H$4,MATCH(I8,E8:H8,0))","v":"Oakland, California"},{"$f":"IF(I8*$N$2<$N$3,$N$3,I8*$N$2)","v":2382.2599999999998}]
["Glendale","Arizona","85302",null,1405,1870,1715,744,{"$f":"MIN(E9:H9)","v":744},{"$f":"INDEX($E$4:$H$4,MATCH(I9,E9:H9,0))","v":"Oakland, California"},{"$f":"IF(I9*$N$2<$N$3,$N$3,I9*$N$2)","v":2313.8399999999997}]
["Mesa","Arizona","85201",null,1440,1816,1702,758,758,"Oakland, California",2357.38]
["Scottsdale","Arizona","85251",null,1435,1818,1706,754,754,"Oakland, California",2344.94]
["Little Rock","Arkansas","72202",null,2277,743,373,1955,373,"Birmingham, Alabama",1160.03]
["Antioch","California","94509",null,796,2146,2299,36,36,"Oakland, California",111.96]
["Berkeley","California","94704",null,795,2165,2319,4,4,"Oakland, California",75]
["Chula Vista","California","91910",null,1258,2124,1996,499,499,"Oakland, California",1551.8899999999999]
["Concord","California","94520",null,785,2155,2319,25,25,"Oakland, California",77.75]
["Daly City","California","94015",null,813,2183,2329,21,21,"Oakland, California",75]
["Fairfield","California","94533",null,759,2129,2339,41,41,"Oakland, California",127.50999999999999]
["Hayward","California","94544",null,816,2186,2306,20,20,"Oakland, California",75]
["Huntington Beach","California","92647",null,1162,2063,2034,404,404,"Oakland, California",1256.44]
["Long Beach","California","90802",null,1156,2071,2042,398,398,"Oakland, California",1237.78]
["Modesto","California","95350",null,822,2158,2248,82,82,"Oakland, California",255.01999999999998]
["Santa Clara","California","95050",null,834,2204,2290,44,44,"Oakland, California",136.84]
["Sunnyvale","California","94086",null,835,2205,2293,44,44,"Oakland, California",136.84]
["Thousand Oaks","California","91362",null,1143,2092,2062,385,385,"Oakland, California",1197.3499999999999]
["Vallejo","California","94590",null,773,2143,2328,25,25,"Oakland, California",77.75]
["Aurora","Colorado","80017",null,1332,1045,1318,1260,1045,"Milwaukee, Wisconsin",3249.95]
["Colorado Springs","Colorado","80903",null,1388,1114,1312,1316,1114,"Milwaukee, Wisconsin",3464.54]
["Denver","Colorado","80202",null,1318,1043,1328,1246,1043,"Milwaukee, Wisconsin",3243.73]
["Chicago","Illinois","60607",null,2067,93,663,2124,93,"Milwaukee, Wisconsin",289.22999999999996]
["Joliet","Illinois","60436",null,2052,126,671,2099,126,"Milwaukee, Wisconsin",391.85999999999996]
["Evansville","Indiana","47708",null,2254,387,343,2214,343,"Birmingham, Alabama",1066.73]
["Fort Wayne","Indiana","46802",null,2233,262,597,2269,262,"Milwaukee, Wisconsin",814.81999999999994]
["Cedar Rapids","Iowa","52401",null,1832,244,782,1919,244,"Milwaukee, Wisconsin",758.83999999999992]
["Kansas City","Kansas","66106",null,1842,576,695,1802,576,"Milwaukee, Wisconsin",1791.36]
["Topeka","Kansas","66603",null,1848,630,748,1776,630,"Milwaukee, Wisconsin",1959.3]
["Lexington-Fayette","Kentucky","40511",null,2406,468,411,2383,411,"Birmingham, Alabama",1278.21]
["Louisville-Jefferson County5","Kentucky","40231",null,2340,401,363,2317,363,"Birmingham, Alabama",1128.93]
["New Orleans","Louisiana","70113",null,2617,1016,344,2265,344,"Birmingham, Alabama",1069.8399999999999]
["Baltimore","Maryland","21202",null,2771,800,781,2808,781,"Birmingham, Alabama",2428.91]
["Ann Arbor","Michigan","48104",null,2314,343,710,2351,343,"Milwaukee, Wisconsin",1066.73]
["Detroit","Michigan","48233",null,2352,381,722,2389,381,"Milwaukee, Wisconsin",1184.9099999999999]
["St. Paul","Minnesota","55109",null,1668,332,1069,1970,332,"Milwaukee, Wisconsin",1032.52]
["Kansas City","Missouri","64108",null,1840,569,688,1800,569,"Milwaukee, Wisconsin",1769.59]
["St. Louis","Missouri","63155",null,2089,375,500,2050,375,"Milwaukee, Wisconsin",1166.25]
["Omaha","Nebraska","68108",null,1659,508,869,1661,508,"Milwaukee, Wisconsin",1579.8799999999999]
["Henderson","Nevada","89015",null,1145,1806,1799,568,568,"Oakland, California",1766.48]
["Reno","Nevada","89510",null,738,1964,2267,256,256,"Oakland, California",796.16]
["Manchester","New Hampshire","03103",null,3087,1116,1214,3124,1116,"Milwaukee, Wisconsin",3470.7599999999998]
["Elizabeth","New Jersey","07208",null,2857,886,950,2894,886,"Milwaukee, Wisconsin",2755.46]
["Jersey City","New Jersey","07302",null,2860,889,959,2896,889,"Milwaukee, Wisconsin",2764.79]
["Newark","New Jersey","07102",null,2852,881,952,2889,881,"Milwaukee, Wisconsin",2739.91]
["New York","New York","10199",null,2863,892,964,2900,892,"Milwaukee, Wisconsin",2774.12]
["Yonkers","New York","10701",null,2873,902,980,2910,902,"Milwaukee, Wisconsin",2805.22]
["Cary","North Carolina","27511",null,2876,905,543,2829,543,"Birmingham, Alabama",1688.73]
["Durham","North Carolina","27701",null,2856,885,531,2808,531,"Birmingham, Alabama",1651.4099999999999]
["Cincinnati","Ohio","45225",null,2327,389,468,2374,389,"Milwaukee, Wisconsin",1209.79]
["Cleveland","Ohio","44101",null,2417,446,712,2453,446,"Milwaukee, Wisconsin",1387.06]
["Norman","Oklahoma","73019",null,2007,892,705,1639,705,"Birmingham, Alabama",2192.5499999999997]
["Tulsa","Oklahoma","74107",null,2000,773,639,1718,639,"Birmingham, Alabama",1987.29]
["Eugene","Oregon","97401",null,278,2173,2494,523,278,"Seattle, Washington",864.57999999999993]
["Portland","Oregon","97208",null,168,2065,2480,629,168,"Seattle, Washington",522.48]
["Philadelphia","Pennsylvania","19104",null,2832,861,878,2869,861,"Milwaukee, Wisconsin",2677.71]
["Pittsburgh","Pennsylvania","15290",null,2535,564,753,2572,564,"Milwaukee, Wisconsin",1754.04]
["Providence","Rhode Island","02904",null,3046,1075,1153,3083,1075,"Milwaukee, Wisconsin",3343.25]
["Columbia","South Carolina","29201",null,2835,903,362,2678,362,"Birmingham, Alabama",1125.82]
["Sioux Falls","South Dakota","57104",null,1478,497,1053,1727,497,"Milwaukee, Wisconsin",1545.6699999999998]
["Clarksville","Tennessee","37043",null,2359,561,232,2294,232,"Birmingham, Alabama",721.52]
["Killeen","Texas","76541",null,2091,1156,741,1744,741,"Birmingham, Alabama",2304.5099999999998]
["Laredo","Texas","78041",null,2219,1432,978,1780,978,"Birmingham, Alabama",3041.58]
["Mesquite","Texas","75149",null,2123,1052,629,1734,629,"Birmingham, Alabama",1956.1899999999998]
["Alexandria","Virginia","22314",null,2781,811,746,2818,746,"Birmingham, Alabama",2320.06]
["Hampton","Virginia","23607",null,2945,974,716,2950,{"$f":"MIN(E73:H73)","v":716},{"$f":"INDEX($E$4:$H$4,MATCH(I73,E73:H73,0))","v":"Birmingham, Alabama"},{"$f":"IF(I73*$N$2<$N$3,$N$3,I73*$N$2)","v":2226.7599999999998}]
["Seattle","Washington","98108",null,0,1995,2525,796,0,"Seattle, Washington",75]
["Spokane","Washington","99201",null,282,1714,2244,864,282,"Seattle, Washington",877.02]
["Green Bay","Wisconsin","54303",null,1934,121,878,2224,121,"Milwaukee, Wisconsin",376.31]
["Madison","Wisconsin","53714",null,1927,74,811,2091,74,"Milwaukee, Wisconsin",230.14]