{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Score","P(1)","P(1an)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":3,"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":"Score","index":0,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Formula Like:","Points","Your Points"]
["Min Distance"," =MIN(A8:D8)",5,{"$f":"C3","v":5},"See sheet for example ==>>"]
["Shipping Center"," =INDEX($A$4:$D$4,MATCH(E8,A8:D8,0))",15,15,"See sheet for example ==>>"]
["Total Shipping Charge"," =IF(E8*$J$8<$J$9,$J$9,E8*$J$8) or\n=MAX(E8*$L$8,$L$9)",10,{"$f":"C5","v":10},"See sheet for example ==>>"]
[null,null,{"$f":"SUM(C3:C5)","v":30}]
[null,null,"Your Score",{"$f":"SUM(D3:D6)","v":30}]

{"sheet":"P(1)","index":1,"n_rows":77,"n_cols":11,"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."]
["For each customer, determine which Shipping Center has the shortest distance and then calculate the total shipping charge for each customer transaction."]
[]
["Seattle, Washington","Milwaukee, Wisconsin","Birmingham, Alabama","Oakland, California"]
["Shipping Center Source Zip Code with Miles from Shipping Center to Destination:"]
[]
["98108","53203","35203","94612","Min Distance","Shipping Center","Total Shipping Charge",null,null,"Formula Inputs"]
[1447,1830,1686,766,null,null,null,null,null,"Per Mile Shipping Charge",3.11]
[1405,1870,1715,744,null,null,null,null,null,"Minimum Charge",75]
[1440,1816,1702,758]
[1435,1818,1706,754]
[2277,743,373,1955]
[796,2146,2299,36]
[795,2165,2319,4]
[1258,2124,1996,499]
[785,2155,2319,25]
[813,2183,2329,21]
[759,2129,2339,41]
[816,2186,2306,20]
[1162,2063,2034,404]
[1156,2071,2042,398]
[822,2158,2248,82]
[834,2204,2290,44]
[835,2205,2293,44]
[1143,2092,2062,385]
[773,2143,2328,25]
[1332,1045,1318,1260]
[1388,1114,1312,1316]
[1318,1043,1328,1246]
[2067,93,663,2124]
[2052,126,671,2099]
[2254,387,343,2214]
[2233,262,597,2269]
[1832,244,782,1919]
[1842,576,695,1802]
[1848,630,748,1776]
[2406,468,411,2383]
[2340,401,363,2317]
[2617,1016,344,2265]
[2771,800,781,2808]
[2314,343,710,2351]
[2352,381,722,2389]
[1668,332,1069,1970]
[1840,569,688,1800]
[2089,375,500,2050]
[1659,508,869,1661]
[1145,1806,1799,568]
[738,1964,2267,256]
[3087,1116,1214,3124]
[2857,886,950,2894]
[2860,889,959,2896]
[2852,881,952,2889]
[2863,892,964,2900]
[2873,902,980,2910]
[2876,905,543,2829]
[2856,885,531,2808]
[2327,389,468,2374]
[2417,446,712,2453]
[2007,892,705,1639]
[2000,773,639,1718]
[278,2173,2494,523]
[168,2065,2480,629]
[2832,861,878,2869]
[2535,564,753,2572]
[3046,1075,1153,3083]
[2835,903,362,2678]
[1478,497,1053,1727]
[2359,561,232,2294]
[2091,1156,741,1744]
[2219,1432,978,1780]
[2123,1052,629,1734]
[2781,811,746,2818]
[2945,974,716,2950]
[0,1995,2525,796]
[282,1714,2244,864]
[1934,121,878,2224]
[1927,74,811,2091]

{"sheet":"P(1an)","index":2,"n_rows":77,"n_cols":11,"rows_kept":77,"cut":false,"hidden":true,"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."]
["For each customer, determine which Shipping Center has the shortest distance and then calculate the total shipping charge for each customer transaction."]
[]
["Seattle, Washington","Milwaukee, Wisconsin","Birmingham, Alabama","Oakland, California"]
["Shipping Center Source Zip Code with Miles from Shipping Center to Destination:"]
[]
["98108","53203","35203","94612","Min Distance","Shipping Center","Total Shipping Charge","Total Shipping Charge",null,"Formula Inputs"]
[1447,1830,1686,766,{"$f":"MIN(A8:D8)","v":766},{"$f":"INDEX($A$4:$D$4,MATCH(E8,A8:D8,0))","v":"Oakland, California"},{"$f":"IF(E8*$K$8<$K$9,$K$9,E8*$K$8)","v":2382.2599999999998},{"$f":"MAX(E8*$K$8,$K$9)","v":2382.2599999999998},null,"Per Mile Shipping Charge",3.11]
[1405,1870,1715,744,{"$f":"MIN(A9:D9)","v":744},{"$f":"INDEX($A$4:$D$4,MATCH(E9,A9:D9,0))","v":"Oakland, California"},{"$f":"IF(E9*$K$8<$K$9,$K$9,E9*$K$8)","v":2313.8399999999997},{"$f":"MAX(E9*$K$8,$K$9)","v":2313.8399999999997},null,"Minimum Charge",75]
[1440,1816,1702,758,758,"Oakland, California",2357.38,2357.38]
[1435,1818,1706,754,754,"Oakland, California",2344.94,2344.94]
[2277,743,373,1955,{"$f":"MIN(A12:D12)","v":373},{"$f":"INDEX($A$4:$D$4,MATCH(E12,A12:D12,0))","v":"Birmingham, Alabama"},{"$f":"IF(E12*$K$8<$K$9,$K$9,E12*$K$8)","v":1160.03},{"$f":"MAX(E12*$K$8,$K$9)","v":1160.03}]
[796,2146,2299,36,36,"Oakland, California",111.96,111.96]
[795,2165,2319,4,4,"Oakland, California",75,75]
[1258,2124,1996,499,499,"Oakland, California",1551.8899999999999,1551.8899999999999]
[785,2155,2319,25,25,"Oakland, California",77.75,77.75]
[813,2183,2329,21,21,"Oakland, California",75,75]
[759,2129,2339,41,41,"Oakland, California",127.50999999999999,127.50999999999999]
[816,2186,2306,20,20,"Oakland, California",75,75]
[1162,2063,2034,404,404,"Oakland, California",1256.44,1256.44]
[1156,2071,2042,398,398,"Oakland, California",1237.78,1237.78]
[822,2158,2248,82,82,"Oakland, California",255.01999999999998,255.01999999999998]
[834,2204,2290,44,44,"Oakland, California",136.84,136.84]
[835,2205,2293,44,44,"Oakland, California",136.84,136.84]
[1143,2092,2062,385,385,"Oakland, California",1197.3499999999999,1197.3499999999999]
[773,2143,2328,25,25,"Oakland, California",77.75,77.75]
[1332,1045,1318,1260,1045,"Milwaukee, Wisconsin",3249.95,3249.95]
[1388,1114,1312,1316,1114,"Milwaukee, Wisconsin",3464.54,3464.54]
[1318,1043,1328,1246,1043,"Milwaukee, Wisconsin",3243.73,3243.73]
[2067,93,663,2124,93,"Milwaukee, Wisconsin",289.22999999999996,289.22999999999996]
[2052,126,671,2099,126,"Milwaukee, Wisconsin",391.85999999999996,391.85999999999996]
[2254,387,343,2214,343,"Birmingham, Alabama",1066.73,1066.73]
[2233,262,597,2269,262,"Milwaukee, Wisconsin",814.81999999999994,814.81999999999994]
[1832,244,782,1919,244,"Milwaukee, Wisconsin",758.83999999999992,758.83999999999992]
[1842,576,695,1802,576,"Milwaukee, Wisconsin",1791.36,1791.36]
[1848,630,748,1776,630,"Milwaukee, Wisconsin",1959.3,1959.3]
[2406,468,411,2383,411,"Birmingham, Alabama",1278.21,1278.21]
[2340,401,363,2317,363,"Birmingham, Alabama",1128.93,1128.93]
[2617,1016,344,2265,344,"Birmingham, Alabama",1069.8399999999999,1069.8399999999999]
[2771,800,781,2808,781,"Birmingham, Alabama",2428.91,2428.91]
[2314,343,710,2351,343,"Milwaukee, Wisconsin",1066.73,1066.73]
[2352,381,722,2389,381,"Milwaukee, Wisconsin",1184.9099999999999,1184.9099999999999]
[1668,332,1069,1970,332,"Milwaukee, Wisconsin",1032.52,1032.52]
[1840,569,688,1800,569,"Milwaukee, Wisconsin",1769.59,1769.59]
[2089,375,500,2050,375,"Milwaukee, Wisconsin",1166.25,1166.25]
[1659,508,869,1661,508,"Milwaukee, Wisconsin",1579.8799999999999,1579.8799999999999]
[1145,1806,1799,568,568,"Oakland, California",1766.48,1766.48]
[738,1964,2267,256,256,"Oakland, California",796.16,796.16]
[3087,1116,1214,3124,1116,"Milwaukee, Wisconsin",3470.7599999999998,3470.7599999999998]
[2857,886,950,2894,886,"Milwaukee, Wisconsin",2755.46,2755.46]
[2860,889,959,2896,889,"Milwaukee, Wisconsin",2764.79,2764.79]
[2852,881,952,2889,881,"Milwaukee, Wisconsin",2739.91,2739.91]
[2863,892,964,2900,892,"Milwaukee, Wisconsin",2774.12,2774.12]
[2873,902,980,2910,902,"Milwaukee, Wisconsin",2805.22,2805.22]
[2876,905,543,2829,543,"Birmingham, Alabama",1688.73,1688.73]
[2856,885,531,2808,531,"Birmingham, Alabama",1651.4099999999999,1651.4099999999999]
[2327,389,468,2374,389,"Milwaukee, Wisconsin",1209.79,1209.79]
[2417,446,712,2453,446,"Milwaukee, Wisconsin",1387.06,1387.06]
[2007,892,705,1639,705,"Birmingham, Alabama",2192.5499999999997,2192.5499999999997]
[2000,773,639,1718,639,"Birmingham, Alabama",1987.29,1987.29]
[278,2173,2494,523,278,"Seattle, Washington",864.57999999999993,864.57999999999993]
[168,2065,2480,629,168,"Seattle, Washington",522.48,522.48]
[2832,861,878,2869,861,"Milwaukee, Wisconsin",2677.71,2677.71]
[2535,564,753,2572,564,"Milwaukee, Wisconsin",1754.04,1754.04]
[3046,1075,1153,3083,1075,"Milwaukee, Wisconsin",3343.25,3343.25]
[2835,903,362,2678,362,"Birmingham, Alabama",1125.82,1125.82]
[1478,497,1053,1727,497,"Milwaukee, Wisconsin",1545.6699999999998,1545.6699999999998]
[2359,561,232,2294,232,"Birmingham, Alabama",721.52,721.52]
[2091,1156,741,1744,741,"Birmingham, Alabama",2304.5099999999998,2304.5099999999998]
[2219,1432,978,1780,978,"Birmingham, Alabama",3041.58,3041.58]
[2123,1052,629,1734,629,"Birmingham, Alabama",1956.1899999999998,1956.1899999999998]
[2781,811,746,2818,{"$f":"MIN(A72:D72)","v":746},{"$f":"INDEX($A$4:$D$4,MATCH(E72,A72:D72,0))","v":"Birmingham, Alabama"},2320.06,2320.06]
[2945,974,716,2950,716,"Birmingham, Alabama",2226.7599999999998,2226.7599999999998]
[0,1995,2525,796,0,"Seattle, Washington",75,75]
[282,1714,2244,864,282,"Seattle, Washington",877.02,877.02]
[1934,121,878,2224,121,"Milwaukee, Wisconsin",{"$f":"IF(E76*$K$8<$K$9,$K$9,E76*$K$8)","v":376.31},{"$f":"MAX(E76*$K$8,$K$9)","v":376.31}]
[1927,74,811,2091,74,"Milwaukee, Wisconsin",230.14,230.14]