{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["List","SocialData","Data","Calcs","Dash"],"not_rendered":{"charts":8,"images":6,"macros":1,"external_links":0,"defined_names":3,"comments":1,"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":"List","index":0,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Country","Region"]
["United States","All Regions"]
["Germany","The West"]
["United Kingdom","The South"]
["France","The North-East"]
["Spain","The Mid-West"]
["Russia"]
["Greece"]
["Netherlands"]
["Brazil"]
["Argentina"]
["Japan"]
["China"]
["Australia"]
["Indonesia"]
["Mexico"]
["Canada"]
["South Africa"]
["Croatia"]
["Italy"]
["Switzerland"]

{"sheet":"SocialData","index":1,"n_rows":81,"n_cols":14,"rows_kept":81,"cut":false,"hidden":false,"merged":[]}
["Country","Year","Facebook","Twitter","Google +","Linkedin","YouTube","Page Views","Avg Visitors Per Day","Average Visit Duration","Returning Visitors","Year","Search Engines","% Split"]
["United States",2010,1033.8,775,1007,790,982,9459,25,1.25,5202,2010,"Google",0.6]
["Germany",2010,745,447,581,412,707,6816,18,1.27,3748,2010,"Bing",0.26]
["United Kingdom",2010,674.6,337,438,283,640,6172,16,1.29,3147,2010,"Other",0.14000000000000001]
["France",2010,796.2,597,776,587,756,7285,19,1.06,4298,2011,"Google",0.65]
["Spain",2010,1389.4,833,1124,895,2361,12713,34,1.08,6610,2011,"Bing",0.2]
["Russia",2010,551.20000000000005,413,557,390,937,5043,13,1.05,2773,2011,"Other",0.15]
["Greece",2010,307.40000000000003,230,310,168,522,2812,7,1.35,1096,2012,"Google",0.7]
["Netherlands",2010,743.80000000000007,632,853,657,1264,6805,18,1.35,3742,2012,"Bing",0.15]
["Brazil",2010,643.80000000000007,386,521,358,1094,5890,16,1.36,3239,2012,"Other",0.15]
["Argentina",2010,459.8,390,526,357,781,4207,11,1.39,2313,2013,"Google",0.65]
["Japan",2010,403.40000000000003,242,326,180,685,3691,10,1.39,2030,2013,"Bing",0.18]
["China",2010,231.20000000000002,196,264,125,393,2115,5,2.0299999999999998,1078,2013,"Other",0.17]
["Australia",2010,581.80000000000007,494,666,486,989,5323,14,2.0299999999999998,3140]
["Indonesia",2010,191,181,251,790,324,1747,4,1.54,593]
["Mexico",2010,233.20000000000002,139,193,61,699,2133,5,2.13,1173]
["Canada",2010,199.20000000000002,99,137,10,597,1822,4,1.2,619]
["South Africa",2010,190.60000000000002,181,251,109,571,1743,4,1.27,958]
["Croatia",2010,269.40000000000003,255,354,168,808,2465,6,1.54,961]
["Italy",2010,336.20000000000005,168,233,59,1008,3076,8,1.25,1814]
["Switzerland",2010,134,67,93,49,402,1226,3,1.28,416]
["United States",2011,1059,809,1022,849,996,9689,26,1.22,5328]
["Germany",2011,763,467,589,442,717,6981,19,1.24,3839]
["United Kingdom",2011,691,352,444,304,649,6322,17,1.26,2465]
["France",2011,816,623,787,631,767,7466,20,1.03,4106]
["Spain",2011,1424,870,1140,962,2396,13029,35,1.05,4429]
["Russia",2011,564,431,565,419,951,5160,14,1.02,3044]
["Greece",2011,315,240,314,180,529,2882,7,1.32,1498]
["Netherlands",2011,762,660,865,706,1282,6972,19,1.32,3834]
["Brazil",2011,659,403,528,384,1110,6029,16,1.33,3315]
["Argentina",2011,471,407,533,383,792,4309,11,1.3599999999999999,2369]
["Japan",2011,413,252,330,193,695,3778,10,1.3599999999999999,2077]
["China",2011,236,204,267,134,398,2159,5,1.9999999999999998,842]
["Australia",2011,596,516,675,522,1003,5453,14,1.9999999999999998,2126]
["Indonesia",2011,195,189,254,849,328,1784,4,1.52,909]
["Mexico",2011,239,145,195,65,709,2186,5,2.06,1289]
["Canada",2011,204,103,139,10,605,1866,5,1.1099999999999999,970]
["South Africa",2011,195,189,254,117,579,1784,4,1.19,981]
["Croatia",2011,276,266,359,180,820,2525,6,1.43,1287]
["Italy",2011,344,175,236,63,1023,3147,8,1.22,1856]
["Switzerland",2011,137,70,94,52,408,1253,3,1.25,488]
["United States",2012,1085,845,1037,912,1010,9927,27,1.19,5459]
["Germany",2012,782,488,597,475,727,7155,19,1.29,3935]
["United Kingdom",2012,708,367,450,326,658,6478,17,1.31,2202]
["France",2012,836,651,798,678,778,7649,20,1.08,4206]
["Spain",2012,1459,909,1157,1034,2431,13349,36,1.1000000000000001,7341]
["Russia",2012,578,450,573,450,965,5288,14,1.07,1797]
["Greece",2012,322,250,318,193,536,2946,8,1.29,1620]
["Netherlands",2012,781,689,877,758,1301,7146,19,1.29,3930]
["Brazil",2012,675,421,535,412,1126,6176,16,1.24,3396]
["Argentina",2012,482,425,540,411,803,4410,12,1.2699999999999998,2425]
["Japan",2012,423,263,334,207,705,3870,10,1.2699999999999998,1973]
["China",2012,241,213,271,144,403,2205,6,1.9099999999999997,1300]
["Australia",2012,610,539,685,561,1018,5581,15,1.9099999999999997,1897]
["Indonesia",2012,199,197,257,912,332,1820,4,1.43,1001]
["Mexico",2012,244,151,197,69,719,2232,6,1.97,1227]
["Canada",2012,209,107,141,10,614,1912,5,1.0799999999999998,975]
["South Africa",2012,199,197,257,125,587,1820,4,1.1599999999999999,782]
["Croatia",2012,282,277,364,193,832,2580,7,1.41,1341]
["Italy",2012,352,182,239,67,1038,3220,8,1.1499999999999999,1771]
["Switzerland",2012,140,73,95,55,414,1281,3,1.1599999999999999,704]
["United States",2013,855,883,1052,980,1025,10174,27,1.1099999999999999,5595]
["Germany",2013,801,509,605,510,737,7329,20,1.18,3737]
["United Kingdom",2013,725,383,456,350,667,6633,18,1.34,2852]
["France",2013,856,680,809,728,789,7832,21,1.03,3367]
["Spain",2013,1495,949,1174,1111,2467,13679,37,1.05,7523]
["Russia",2013,592,470,581,483,979,5416,14,1.04,2978]
["Greece",2013,330,261,322,207,544,3019,8,1.26,1660]
["Netherlands",2013,800,720,890,814,1320,7320,20,1.27,4026]
["Brazil",2013,691,439,543,442,1142,6322,17,1.17,3477]
["Argentina",2013,390.83,331.5,447.09999999999997,303.45,663.85,3575.95,12,1.1799999999999997,2486]
["Japan",2013,342.89000000000004,205.7,277.09999999999997,153,582.25,3137.35,10,1.1899999999999997,2178]
["China",2013,196.52,166.6,224.4,106.25,334.05,1797.75,6,1.7999999999999996,971]
["Australia",2013,494.53000000000003,419.9,566.1,413.09999999999997,840.65,4524.55,15,1.8199999999999996,3373]
["Indonesia",2013,187.18,177.38,245.98,774.19999999999993,317.52,1712.06,5,1.3399999999999999,965]
["Mexico",2013,228.536,136.22,189.14,59.78,685.02,2090.34,6,1.88,1257]
["Canada",2013,195.21600000000001,97.02,134.26,9.8000000000000007,585.05999999999995,1785.56,5,0.98999999999999988,1076]
["South Africa",2013,186.78800000000001,177.38,245.98,106.82,559.58000000000004,1708.1399999999999,5,1.0699999999999998,798]
["Croatia",2013,264.012,249.9,346.92,164.64,791.84,2415.6999999999998,7,1.3199999999999998,1559]
["Italy",2013,329.47600000000006,164.64,228.34,57.82,987.84,3014.48,9,1.0599999999999998,1712]
["Switzerland",2013,131.32,65.66,91.14,48.019999999999996,393.96,1201.48,3,1.21,719]

{"sheet":"Data","index":2,"n_rows":51,"n_cols":18,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[null,"State","Region","Revenue 2010","Revenue 2011","Revenue 2012","Revenue 2013","Expenses 2010","Expenses 2011","Expenses 2012","Expenses 2013","Late Debtors","Staff","% of US","Staff Rank Reg","Rev Rank","Exp Rank","Late Debtors Rank Reg"]
[1,"California","The West",1787984.7286865602,2340508.5920000002,2410723.8497600006,2483045.5652528009,1089787.0131937501,1122480.6235895625,1156155.0422972494,1167716.592720222,8.6999999999999994E-2,244.2,0.1191,{"$f":"SUMPRODUCT((C$2:C$601=$C2)*(M$2:M$601>M2))+1","v":1},{"$f":"SUMPRODUCT(($C$2:$C$601=$C2)*(G$2:G$601>G2))+1","v":1},{"$f":"SUMPRODUCT(($C$2:$C$601=$C2)*(K$2:K$601>K2))+1","v":1},{"$f":"COUNTIFS($C:$C,$C2,$L:$L,\">\"&$L2)+COUNTIFS($C$2:$C2,$C2,$L$2:$L2,$L2)","v":2}]
[2,"Texas","The South",1676519.8460053997,2194598.7799999998,{"$f":"E3*0.95","v":2084868.8409999998},{"$f":"F3*1.03","v":2147414.9062299998},1174893.0068399999,{"$f":"H3*0.95","v":1116148.356498},{"$f":"I3*1.03","v":1149632.80719294},{"$f":"J3*1.01","v":1161129.1352648695},6.2E-2,98.07,8.0399999999999999E-2,9,{"$f":"SUMPRODUCT(($C$2:$C$601=$C3)*(G$2:G$601>G3))+1","v":1},{"$f":"SUMPRODUCT(($C$2:$C$601=$C3)*(K$2:K$601>K3))+1","v":1},{"$f":"COUNTIFS($C:$C,$C3,$L:$L,\">\"&$L3)+COUNTIFS($C$2:$C3,$C3,$L$2:$L3,$L3)","v":11}]
[3,"New York","The North-East",1536782.3509922,2011679.54,1911095.5629999998,{"$f":"F4*1.07","v":2044872.25241},904550.71048999997,859323.1749654999,{"$f":"I4*1.07","v":919475.797213085},{"$f":"J4*1.01","v":928670.5551852159},7.6999999999999999E-2,415.3,6.1899999999999997E-2,5,1,1,{"$f":"COUNTIFS($C:$C,$C4,$L:$L,\">\"&$L4)+COUNTIFS($C$2:$C4,$C4,$L$2:$L4,$L4)","v":4}]
[4,"Florida","The South",933901.63665550016,1222496.3500000001,1161371.5325,{"$f":"F5*1.07","v":1242667.539775},878247.13570999994,834334.77892449987,{"$f":"I5*1.07","v":892738.21344921493},{"$f":"J5*1.01","v":901665.59558370709},6.7000000000000004E-2,360.2,6.0100000000000001E-2,1,2,2,{"$f":"COUNTIFS($C:$C,$C5,$L:$L,\">\"&$L5)+COUNTIFS($C$2:$C5,$C5,$L$2:$L5,$L5)","v":8}]
[5,"Illinois","The Mid-West",950567.47242110013,1244312.27,1182096.6565,{"$f":"F6*1.07","v":1264843.4224550002},599136.98109999998,569180.13204499998,{"$f":"I6*1.07","v":609022.74128814996},{"$f":"J6*1.095","v":666879.90171052422},8.900000000000001E-2,231.9,4.1000000000000002E-2,2,1,1,{"$f":"COUNTIFS($C:$C,$C6,$L:$L,\">\"&$L6)+COUNTIFS($C$2:$C6,$C6,$L$2:$L6,$L6)","v":2}]
[6,"Pennsylvania","The North-East",832389.70153949992,1089615.1499999999,1035134.3924999998,{"$f":"F7*1.07","v":1107593.7999749999},593291.74225999997,563627.15514699998,{"$f":"I7*1.07","v":603081.05600729003},{"$f":"J7*0.8","v":482464.84480583202},7.4999999999999997E-2,285.3,4.0599999999999997E-2,6,3,2,{"$f":"COUNTIFS($C:$C,$C7,$L:$L,\">\"&$L7)+COUNTIFS($C$2:$C7,$C7,$L$2:$L7,$L7)","v":5}]
[7,"Ohio","The Mid-West",848682.50264680013,1110942.76,1055395.622,{"$f":"F8*0.95","v":1002625.8409},539223.28299000009,512262.11884050007,{"$f":"I8*0.95","v":486649.01289847505},{"$f":"J8*0.96","v":467183.05238253606},7.4999999999999997E-2,282.5,3.6900000000000002E-2,1,2,3,{"$f":"COUNTIFS($C:$C,$C8,$L:$L,\">\"&$L8)+COUNTIFS($C$2:$C8,$C8,$L$2:$L8,$L8)","v":3}]
[8,"Georgia","The South",500361.22430440004,654983.07999999996,{"$f":"E9*0.96","v":628783.75679999997},{"$f":"F9*0.95","v":597344.56895999995},453006.01010000001,{"$f":"H9*0.96","v":434885.76969599997},{"$f":"I9*0.95","v":413141.48121119995},{"$f":"J9*0.97","v":400747.23677486397},8.1000000000000003E-2,172.5,3.1E-2,4,5,4,{"$f":"COUNTIFS($C:$C,$C9,$L:$L,\">\"&$L9)+COUNTIFS($C$2:$C9,$C9,$L$2:$L9,$L9)","v":4}]
[9,"Michigan","The Mid-West",452324.16000939999,592101.57999999996,{"$f":"E10*0.97","v":574338.53259999992},{"$f":"F10*0.96","v":551364.99129599985},461773.86836000008,{"$f":"H10*0.97","v":447920.65230920009},{"$f":"I10*0.96","v":430003.82621683209},{"$f":"J10*1.095","v":470854.18970743113},0.09,174.8,3.1600000000000003E-2,4,4,2,{"$f":"COUNTIFS($C:$C,$C10,$L:$L,\">\"&$L10)+COUNTIFS($C$2:$C10,$C10,$L$2:$L10,$L10)","v":1}]
[10,"North Carolina","The South",470581.3689152,616000.64,{"$f":"E11*1.095","v":674520.70079999999},{"$f":"F11*0.95","v":640794.66576},445699.46155000001,{"$f":"H11*1.095","v":488040.91039724997},{"$f":"I11*0.95","v":463638.86487738747},{"$f":"J11*0.95","v":440456.92163351807},0.08,200.6,3.0499999999999999E-2,3,4,3,{"$f":"COUNTIFS($C:$C,$C11,$L:$L,\">\"&$L11)+COUNTIFS($C$2:$C11,$C11,$L$2:$L11,$L11)","v":5}]
[11,"New Jersey","The North-East",871083.34928999993,1113774.8999999999,{"$f":"E12*0.95","v":1058086.1549999998},{"$f":"F12*1.095","v":1158604.3397249999},410628.02850999997,{"$f":"H12*0.95","v":390096.62708449998},{"$f":"I12*1.095","v":427155.80665752746},{"$f":"J12*0.95","v":405798.01632465108},8.4000000000000005E-2,204,2.81E-2,7,2,3,{"$f":"COUNTIFS($C:$C,$C12,$L:$L,\">\"&$L12)+COUNTIFS($C$2:$C12,$C12,$L$2:$L12,$L12)","v":2}]
[12,"Virginia","The South",502869.96540000004,642974,{"$f":"E13*0.95","v":610825.29999999993},{"$f":"F13*1.07","v":653583.071},374095.28576,{"$f":"H13*0.95","v":355390.52147199999},{"$f":"I13*1.07","v":380267.85797504004},{"$f":"J13*0.95","v":361254.46507628803},5.5999999999999994E-2,207.3,2.5600000000000001E-2,2,3,5,{"$f":"COUNTIFS($C:$C,$C13,$L:$L,\">\"&$L13)+COUNTIFS($C$2:$C13,$C13,$L$2:$L13,$L13)","v":13}]
[13,"Washington","The West",820326.88940400002,1048877.24,996433.37799999991,1066183.7144599999,628363.1753,596945.01653499994,638731.16769244999,606794.60930782743,7.0000000000000007E-2,102.6,2.1499999999999998E-2,3,2,2,{"$f":"COUNTIFS($C:$C,$C14,$L:$L,\">\"&$L14)+COUNTIFS($C$2:$C14,$C14,$L$2:$L14,$L14)","v":5}]
[14,"Massachusetts","The North-East",624326.77929600002,798269.76,{"$f":"E15*0.95","v":758356.272},{"$f":"F15*1.03","v":781106.96016000002},305413.72938999999,{"$f":"H15*0.95","v":290143.04292049998},{"$f":"I15*1.03","v":298847.334208115},{"$f":"J15*0.95","v":283904.96749770927},7.2000000000000008E-2,852.1,2.0899999999999998E-2,1,4,4,{"$f":"COUNTIFS($C:$C,$C15,$L:$L,\">\"&$L15)+COUNTIFS($C$2:$C15,$C15,$L$2:$L15,$L15)","v":6}]
[15,"Arizona","The West",545130.51991200005,697008.72,717918.98159999994,682023.03251999989,596214.36167999997,614100.79253039998,583395.75290387997,{"$f":"J16*0.8","v":466716.60232310399},8.199999999999999E-2,57.05,2.0400000000000001E-2,4,4,3,{"$f":"COUNTIFS($C:$C,$C16,$L:$L,\">\"&$L16)+COUNTIFS($C$2:$C16,$C16,$L$2:$L16,$L16)","v":3}]
[16,"Indiana","The Mid-West",400736.402352,512385.12,{"$f":"E17*0.95","v":486765.864},{"$f":"F17*0.95","v":462427.57079999999},302491.10996999999,{"$f":"H17*0.95","v":287366.55447149999},{"$f":"I17*0.95","v":272998.22674792499},{"$f":"J17*0.97","v":264808.27994548721},7.4999999999999997E-2,182.5,2.07E-2,3,6,5,{"$f":"COUNTIFS($C:$C,$C17,$L:$L,\">\"&$L17)+COUNTIFS($C$2:$C17,$C17,$L$2:$L17,$L17)","v":4}]
[17,"Tennessee","The South",367667.57976300007,470103.03,{"$f":"E18*0.95","v":446597.87849999999},{"$f":"F18*1.03","v":459995.814855},296645.87112999998,{"$f":"H18*0.95","v":281813.57757349999},{"$f":"I18*0.96","v":270541.03447055997},{"$f":"J18*1.095","v":296242.43274526316},8.4000000000000005E-2,156.6,2.0299999999999999E-2,6,6,6,{"$f":"COUNTIFS($C:$C,$C18,$L:$L,\">\"&$L18)+COUNTIFS($C$2:$C18,$C18,$L$2:$L18,$L18)","v":2}]
[18,"Missouri","The Mid-West",378640.00478700001,484132.47,{"$f":"E19*0.96","v":464767.17119999998},{"$f":"F19*0.97","v":450824.15606399998},279110.15461000003,{"$f":"H19*0.96","v":267945.7484256},{"$f":"I19*0.97","v":259907.375972832},{"$f":"J19*0.95","v":246912.0071741904},6.5000000000000002E-2,87.26,1.9099999999999999E-2,6,7,6,{"$f":"COUNTIFS($C:$C,$C19,$L:$L,\">\"&$L19)+COUNTIFS($C$2:$C19,$C19,$L$2:$L19,$L19)","v":5}]
[19,"Maryland","The North-East",376244.86264200002,481070.02,{"$f":"E20*0.97","v":466637.91940000001},{"$f":"F20*1.095","v":510968.52174300002},270342.29635000002,{"$f":"H20*0.97","v":262232.02745950001},{"$f":"I20*1.095","v":287144.0700681525},{"$f":"J20*0.97","v":278529.74796610791},6.7000000000000004E-2,606.20000000000005,1.8499999999999999E-2,3,6,5,{"$f":"COUNTIFS($C:$C,$C20,$L:$L,\">\"&$L20)+COUNTIFS($C$2:$C20,$C20,$L$2:$L20,$L20)","v":8}]
[20,"Wisconsin","The Mid-West",324556.11609299999,414980.33,{"$f":"E21*1.095","v":454403.46135},{"$f":"F21*1.03","v":468035.5651905},265958.36722000001,{"$f":"H21*1.095","v":291224.4121059},{"$f":"I21*0.95","v":276663.19150060497},{"$f":"J21*1.095","v":302946.19469316246},6.5000000000000002E-2,105.2,1.8200000000000001E-2,5,5,4,{"$f":"COUNTIFS($C:$C,$C21,$L:$L,\">\"&$L21)+COUNTIFS($C$2:$C21,$C21,$L$2:$L21,$L21)","v":6}]
[21,"Minnesota","The Mid-West",615398.52904199995,786854.02,{"$f":"E22*1.03","v":810459.64060000004},{"$f":"F22*0.95","v":769936.65856999997},248422.65070000003,{"$f":"H22*1.03","v":255875.33022100004},{"$f":"I22*0.95","v":243081.56370995002},{"$f":"J22*0.95","v":230927.4855244525},4.8000000000000001E-2,67.14,1.7000000000000001E-2,7,3,7,{"$f":"COUNTIFS($C:$C,$C22,$L:$L,\">\"&$L22)+COUNTIFS($C$2:$C22,$C22,$L$2:$L22,$L22)","v":8}]
[22,"Colorado","The West",645274.74904200004,825054.02,849805.64060000004,807315.35857000004,235270.86330999999,{"$f":"H23*1.03","v":242328.98920929999},{"$f":"I23*0.95","v":230212.53974883497},{"$f":"J23*0.96","v":221004.03815888157},6.8000000000000005E-2,49.33,1.61E-2,5,3,5,{"$f":"COUNTIFS($C:$C,$C23,$L:$L,\">\"&$L23)+COUNTIFS($C$2:$C23,$C23,$L$2:$L23,$L23)","v":6}]
[23,"Alabama","The South",163325.54412899999,208829.49,{"$f":"E24*1.03","v":215094.37469999999},{"$f":"F24*0.95","v":204339.65596499998},223580.38563,{"$f":"H24*1.03","v":230287.79719890002},{"$f":"I24*0.95","v":218773.407338955},{"$f":"J24*0.97","v":212210.20511878634},6.5000000000000002E-2,94.65,1.5299999999999999E-2,10,11,8,{"$f":"COUNTIFS($C:$C,$C24,$L:$L,\">\"&$L24)+COUNTIFS($C$2:$C24,$C24,$L$2:$L24,$L24)","v":9}]
[24,"South Carolina","The South",145135.595286,185571.66,{"$f":"E25*1.03","v":191138.80980000002},{"$f":"F25*1.03","v":196872.97409400003},216273.83708,{"$f":"H25*1.03","v":222762.05219240001},{"$f":"I25*1.03","v":229444.91375817201},{"$f":"J25*1.095","v":251242.18056519836},7.4999999999999997E-2,157.1,1.4800000000000001E-2,5,12,7,{"$f":"COUNTIFS($C:$C,$C25,$L:$L,\">\"&$L25)+COUNTIFS($C$2:$C25,$C25,$L$2:$L25,$L25)","v":6}]
[25,"Louisiana","The South",272257.39411199995,348110.72,{"$f":"E26*0.95","v":330705.18399999995},{"$f":"F26*0.97","v":320784.02847999992},211889.90794999999,{"$f":"H26*0.95","v":201295.4125525},{"$f":"I26*0.97","v":195256.55017592499},{"$f":"J26*0.95","v":185493.72266712872},6.5000000000000002E-2,105,1.4500000000000001E-2,8,7,9,{"$f":"COUNTIFS($C:$C,$C26,$L:$L,\">\"&$L26)+COUNTIFS($C$2:$C26,$C26,$L$2:$L26,$L26)","v":10}]
[26,"Kentucky","The South",196196.14347300003,250858.13,{"$f":"E27*0.95","v":238315.22349999999},{"$f":"F27*1.095","v":260955.16973249998},203122.04969000001,{"$f":"H27*0.95","v":192965.94720550001},{"$f":"I27*1.095","v":211297.71219002252},{"$f":"J27*0.8","v":169038.16975201803},8.4000000000000005E-2,110,1.3899999999999999E-2,7,10,11,{"$f":"COUNTIFS($C:$C,$C27,$L:$L,\">\"&$L27)+COUNTIFS($C$2:$C27,$C27,$L$2:$L27,$L27)","v":3}]
[27,"Oregon","The West",177666.544242,227166.02,{"$f":"E28*0.96","v":218079.3792},{"$f":"F28*1.03","v":224621.760576},356559.56923999998,342297.18647039996,352566.10206451197,338463.45798193145,7.6999999999999999E-2,40.33,1.2200000000000001E-2,6,6,4,{"$f":"COUNTIFS($C:$C,$C28,$L:$L,\">\"&$L28)+COUNTIFS($C$2:$C28,$C28,$L$2:$L28,$L28)","v":4}]
[28,"Oklahoma","The South",209709.59788799999,270872.64,{"$f":"E29*0.97","v":262746.4608},270628.85462400003,175357.16519999999,{"$f":"H29*0.97","v":170096.45024399998},{"$f":"I29*1.03","v":175199.34375131998},{"$f":"J29*0.97","v":169943.36343878036},5.5E-2,55.22,1.2E-2,14,8,10,{"$f":"COUNTIFS($C:$C,$C29,$L:$L,\">\"&$L29)+COUNTIFS($C$2:$C29,$C29,$L$2:$L29,$L29)","v":14}]
[29,"Connecticut","The North-East",365907.83888400003,472627.02,{"$f":"E30*1.095","v":517526.58689999999},533052.38450699998,166589.30694000001,{"$f":"H30*1.095","v":182415.2910993},187887.74983227899,{"$f":"J30*0.95","v":178493.36234066504},7.9000000000000001E-2,741.4,1.14E-2,2,5,6,{"$f":"COUNTIFS($C:$C,$C30,$L:$L,\">\"&$L30)+COUNTIFS($C$2:$C30,$C30,$L$2:$L30,$L30)","v":3}]
[30,"Iowa","The Mid-West",145190.34023200002,187535.96,{"$f":"E31*1.03","v":193162.03880000001},198956.89996400001,141747.04186999999,{"$f":"H31*1.03","v":145999.45312609998},150379.43671988297,{"$f":"J31*0.96","v":144364.25925108764},4.5999999999999999E-2,54.81,9.7000000000000003E-3,8,9,8,{"$f":"COUNTIFS($C:$C,$C31,$L:$L,\">\"&$L31)+COUNTIFS($C$2:$C31,$C31,$L$2:$L31,$L31)","v":9}]
[31,"Mississippi","The South",80970.086358000015,104585.49,107723.05470000001,110954.74634100001,138824.42245000001,142989.15512350001,147278.82977720501,{"$f":"J32*0.97","v":142860.46488388887},8.5000000000000006E-2,63.5,9.4999999999999998E-3,12,13,13,{"$f":"COUNTIFS($C:$C,$C32,$L:$L,\">\"&$L32)+COUNTIFS($C$2:$C32,$C32,$L$2:$L32,$L32)","v":1}]
[32,"Arkansas","The South",195871.299344,252998.32,260588.2696,268405.91768800002,135901.80302999998,139978.85712089998,144178.22283452697,{"$f":"J33*1.095","v":157875.15400380702},7.4999999999999997E-2,56.43,9.2999999999999992E-3,13,9,12,{"$f":"COUNTIFS($C:$C,$C33,$L:$L,\">\"&$L33)+COUNTIFS($C$2:$C33,$C33,$L$2:$L33,$L33)","v":7}]
[33,"Kansas","The Mid-West",169585.52932999999,219046.15,225617.53450000001,232386.06053500003,132979.18361000001,136968.55911830001,141077.61589184901,{"$f":"J34*0.8","v":112862.09271347921},5.5999999999999994E-2,35.090000000000003,9.1000000000000004E-3,{"$f":"SUMPRODUCT((C$2:C$601=$C34)*(M$2:M$601>M34))+1","v":9},8,9,{"$f":"COUNTIFS($C:$C,$C34,$L:$L,\">\"&$L34)+COUNTIFS($C$2:$C34,$C34,$L$2:$L34,$L34)","v":7}]
[34,"Utah","The West",121101.36271800002,156421.29,161113.92870000002,165947.34656100001,128595.25448,132453.11211440002,136426.70547783203,{"$f":"J35*1.03","v":140519.50664216699},4.5999999999999999E-2,34.299999999999997,8.8000000000000005E-3,7,10,6,{"$f":"COUNTIFS($C:$C,$C35,$L:$L,\">\"&$L35)+COUNTIFS($C$2:$C35,$C35,$L$2:$L35,$L35)","v":11}]
[35,"Nevada","The West",106277.72434999999,137274.25,141392.47750000001,145634.25182500001,125672.63506,129442.81411180001,133326.09853515401,{"$f":"J36*1.03","v":137325.88149120865},9.3000000000000013E-2,24.8,8.6E-3,8,11,7,{"$f":"COUNTIFS($C:$C,$C36,$L:$L,\">\"&$L36)+COUNTIFS($C$2:$C36,$C36,$L$2:$L36,$L36)","v":1}]
[36,"New Mexico","The West",182700.50055599998,235986.18,224186.87099999998,212977.52744999999,96446.440860000002,{"$f":"H37*0.95","v":91624.118816999995},87042.912876149989,82690.767232342492,6.6000000000000003E-2,17.16,6.6E-3,10,8,8,{"$f":"COUNTIFS($C:$C,$C37,$L:$L,\">\"&$L37)+COUNTIFS($C$2:$C37,$C37,$L$2:$L37,$L37)","v":8}]
[37,"Nebraska","The Mid-West",153254.85646800001,197952.54,{"$f":"E38*0.95","v":188054.913},{"$f":"F38*0.95","v":178652.16735},84755.963180000006,80518.165021000008,76492.256769950007,72667.643931452505,3.9E-2,23.97,5.7999999999999996E-3,10,10,10,{"$f":"COUNTIFS($C:$C,$C38,$L:$L,\">\"&$L38)+COUNTIFS($C$2:$C38,$C38,$L$2:$L38,$L38)","v":10}]
[38,"West Virginia","The South",50311.402483999998,64985.02,{"$f":"E39*0.96","v":62385.619199999994},{"$f":"F39*0.96","v":59890.194431999989},86217.272889999993,{"$f":"H39*0.96","v":82768.581974399989},{"$f":"I39*0.96","v":79457.838695423983},{"$f":"J39*0.96","v":76279.525147607026},6.2E-2,77.06,5.8999999999999999E-3,11,14,14,{"$f":"COUNTIFS($C:$C,$C39,$L:$L,\">\"&$L39)+COUNTIFS($C$2:$C39,$C39,$L$2:$L39,$L39)","v":12}]
[39,"Idaho","The West",184266.07326000003,228674.69999999998,221814.45899999997,215160.02522999997,74526.795209999997,{"$f":"H40*0.97","v":72290.991353699996},{"$f":"I40*0.97","v":70122.261613088995},{"$f":"J40*0.95","v":66616.148532434541},6.7000000000000004E-2,19.5,5.1000000000000004E-3,9,7,10,{"$f":"COUNTIFS($C:$C,$C40,$L:$L,\">\"&$L40)+COUNTIFS($C$2:$C40,$C40,$L$2:$L40,$L40)","v":7}]
[40,"Hawaii","The West",157410.88657200002,195347.34,213905.33730000001,207488.17718100001,62836.31753,{"$f":"H41*1.095","v":68805.767695350005},{"$f":"I41*1.095","v":75342.31562640825},{"$f":"J41*0.97","v":73082.046157616001},4.4000000000000004E-2,216.8,4.3E-3,2,9,9,{"$f":"COUNTIFS($C:$C,$C41,$L:$L,\">\"&$L41)+COUNTIFS($C$2:$C41,$C41,$L$2:$L41,$L41)","v":13}]
[41,"Maine","The North-East",50194.804962000002,62291.89,{"$f":"E42*1.03","v":64160.646699999998},{"$f":"F42*1.095","v":70255.908136500002},61375.007819999999,{"$f":"H42*1.03","v":63216.258054600003},{"$f":"I42*0.95","v":60055.445151870001},{"$f":"J42*1.095","v":65760.712441297655},6.7000000000000004E-2,43.04,4.1999999999999997E-3,11,10,8,{"$f":"COUNTIFS($C:$C,$C42,$L:$L,\">\"&$L42)+COUNTIFS($C$2:$C42,$C42,$L$2:$L42,$L42)","v":9}]
[42,"New Hampshire","The North-East",70972.374078000008,88076.91,{"$f":"E43*1.03","v":90719.217300000004},{"$f":"F43*1.03","v":93440.793819000013},61375.007819999999,{"$f":"H43*1.03","v":63216.258054600003},{"$f":"I43*1.03","v":65112.745796238007},{"$f":"J43*1.03","v":67066.128170125143},5.0999999999999997E-2,147,4.1999999999999997E-3,8,9,7,{"$f":"COUNTIFS($C:$C,$C43,$L:$L,\">\"&$L43)+COUNTIFS($C$2:$C43,$C43,$L$2:$L43,$L43)","v":10}]
[43,"Rhode Island","The North-East",88576.259604000006,109923.38,{"$f":"E44*1.03","v":113221.08140000001},{"$f":"F44*1.03","v":116617.71384200001},49684.530140000003,{"$f":"H44*1.03","v":51175.066044200001},{"$f":"I44*1.03","v":52710.318025526001},{"$f":"J44*0.95","v":50074.802124249698},9.1999999999999998E-2,100.6,3.3999999999999998E-3,9,8,9,{"$f":"COUNTIFS($C:$C,$C44,$L:$L,\">\"&$L44)+COUNTIFS($C$2:$C44,$C44,$L$2:$L44,$L44)","v":1}]
[44,"Montana","The West",552798.21978000004,686024.1,665443.37699999986,645480.07568999985,46761.91072,{"$f":"H45*0.95","v":44423.815183999999},{"$f":"I45*1.03","v":45756.529639519998},{"$f":"J45*0.96","v":43926.268453939199},5.2000000000000005E-2,6.8579999999999997,3.2000000000000002E-3,11,5,11,{"$f":"COUNTIFS($C:$C,$C45,$L:$L,\">\"&$L45)+COUNTIFS($C$2:$C45,$C45,$L$2:$L45,$L45)","v":10}]
[45,"Delaware","The North-East",175949.74989600002,218354.12,{"$f":"E46*0.95","v":207436.41399999999},{"$f":"F46*0.97","v":201213.32157999999},42377.981590000003,{"$f":"H46*0.95","v":40259.082510500004},{"$f":"I46*0.97","v":39051.310035185001},{"$f":"J46*0.95","v":37098.74453342575},6.8000000000000005E-2,470.7,2.8999999999999998E-3,4,7,10,{"$f":"COUNTIFS($C:$C,$C46,$L:$L,\">\"&$L46)+COUNTIFS($C$2:$C46,$C46,$L$2:$L46,$L46)","v":7}]
[46,"South Dakota","The Mid-West",41387.894441999997,51362.49,{"$f":"E47*0.96","v":49307.990399999995},{"$f":"F47*1.095","v":53992.249487999994},37994.052459999999,{"$f":"H47*0.96","v":36474.290361599997},{"$f":"I47*1.095","v":39939.347945951995},{"$f":"J47*0.8","v":31951.478356761596},3.7000000000000005E-2,10.86,2.5999999999999999E-3,11,12,12,{"$f":"COUNTIFS($C:$C,$C47,$L:$L,\">\"&$L47)+COUNTIFS($C$2:$C47,$C47,$L$2:$L47,$L47)","v":11}]
[47,"Alaska","The West",39474.369240000007,48987.8,{"$f":"E48*0.97","v":47518.166000000005},{"$f":"F48*1.03","v":48943.710980000003},33610.123330000002,{"$f":"H48*0.97","v":32601.819630100003},{"$f":"I48*1.03","v":33579.874219003003},{"$f":"J48*0.97","v":32572.477992432912},6.5000000000000002E-2,1.264,2.3E-3,13,12,12,{"$f":"COUNTIFS($C:$C,$C48,$L:$L,\">\"&$L48)+COUNTIFS($C$2:$C48,$C48,$L$2:$L48,$L48)","v":9}]
[48,"North Dakota","The Mid-West",45647.441880000006,56648.6,{"$f":"E49*1.095","v":62030.216999999997},{"$f":"F49*1.03","v":63891.123509999998},30687.503909999999,{"$f":"H49*1.095","v":33602.816781449998},{"$f":"I49*0.95","v":31922.675942377497},{"$f":"J49*1.095","v":34955.330156903357},2.7000000000000003E-2,9.9160000000000004,2.0999999999999999E-3,12,11,11,{"$f":"COUNTIFS($C:$C,$C49,$L:$L,\">\"&$L49)+COUNTIFS($C$2:$C49,$C49,$L$2:$L49,$L49)","v":12}]
[49,"Vermont","The North-East",28403.539446000006,35248.870000000003,{"$f":"E50*1.03","v":36306.3361},{"$f":"F50*1.03","v":37395.526183000002},29226.194200000002,{"$f":"H50*1.03","v":30102.980026000001},{"$f":"I50*0.96","v":28898.86082496},{"$f":"J50*1.03","v":29765.826649708801},4.4999999999999998E-2,67.73,2E-3,10,11,11,{"$f":"COUNTIFS($C:$C,$C50,$L:$L,\">\"&$L50)+COUNTIFS($C$2:$C50,$C50,$L$2:$L50,$L50)","v":11}]
[50,"Wyoming","The West",30849.077981999999,38283.79,{"$f":"E51*1.03","v":39432.303700000004},{"$f":"F51*1.03","v":40615.272811000003},26303.574779999999,{"$f":"H51*1.03","v":27092.682023400001},{"$f":"I51*0.97","v":26279.901562698},{"$f":"J51*1.03","v":27068.298609578942},4.5999999999999999E-2,5.851,1.8E-3,12,13,13,{"$f":"COUNTIFS($C:$C,$C51,$L:$L,\">\"&$L51)+COUNTIFS($C$2:$C51,$C51,$L$2:$L51,$L51)","v":12}]

{"sheet":"Calcs","index":3,"n_rows":97,"n_cols":25,"rows_kept":97,"cut":false,"hidden":false,"merged":[]}
["Top 10","Revenue Region","Revenue State","Revenue 10","Revenue 11","Revenue 12","Revenue 13","Expense Region","Expense State","Expenses 10","Expenses 11","Expenses 12","Expenses 13","Staff","State","FTE by City","Late Debt","State","Late Debt"]
[1,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B2)*(Data!$P$2:$P$51=A2),0),0))","v":"California"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C2)*(Data!$C$2:$C$51=B2)*(Data!$D$2:$D$51))","v":1787984.7286865602},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C2)*(Data!$C$2:$C$51=$B2)*(Data!E$2:E$51))","v":2340508.5920000002},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C2)*(Data!$C$2:$C$51=$B2)*(Data!F$2:F$51))","v":2410723.8497600006},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C2)*(Data!$C$2:$C$51=$B2)*(Data!G$2:G$51))","v":2483045.5652528009},"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B2)*(Data!$Q$2:$Q$51=A2),0),0))","v":"California"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I2)*(Data!$C$2:$C$51=$H2)*(Data!H$2:H$51))","v":1089787.0131937501},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I2)*(Data!$C$2:$C$51=$H2)*(Data!I$2:I$51))","v":1122480.6235895625},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I2)*(Data!$C$2:$C$51=$H2)*(Data!J$2:J$51))","v":1156155.0422972494},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I2)*(Data!$C$2:$C$51=$H2)*(Data!K$2:K$51))","v":1167716.592720222},"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N2)*(Data!$O$2:$O$51=A2),0),0))","v":"California"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O2)*(Data!$C$2:$C$51=N2)*(Data!$M$2:$M$51))","v":244.2},"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q2)*(Data!$R$2:$R$51=A2),0),0))","v":"Nevada"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R2)*(Data!$C$2:$C$51=Q2)*(Data!$L$2:$L$51))","v":9.3000000000000013E-2}]
[2,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B3)*(Data!$P$2:$P$51=A3),0),0))","v":"Washington"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C3)*(Data!$C$2:$C$51=B3)*(Data!$D$2:$D$51))","v":820326.88940400002},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C3)*(Data!$C$2:$C$51=$B3)*(Data!E$2:E$51))","v":1048877.24},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C3)*(Data!$C$2:$C$51=$B3)*(Data!F$2:F$51))","v":996433.37799999991},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C3)*(Data!$C$2:$C$51=$B3)*(Data!G$2:G$51))","v":1066183.7144599999},"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B3)*(Data!$Q$2:$Q$51=A3),0),0))","v":"Washington"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I3)*(Data!$C$2:$C$51=$H3)*(Data!H$2:H$51))","v":628363.1753},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I3)*(Data!$C$2:$C$51=$H3)*(Data!I$2:I$51))","v":596945.01653499994},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I3)*(Data!$C$2:$C$51=$H3)*(Data!J$2:J$51))","v":638731.16769244999},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I3)*(Data!$C$2:$C$51=$H3)*(Data!K$2:K$51))","v":606794.60930782743},"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N3)*(Data!$O$2:$O$51=A3),0),0))","v":"Hawaii"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O3)*(Data!$C$2:$C$51=N3)*(Data!$M$2:$M$51))","v":216.8},"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q3)*(Data!$R$2:$R$51=A3),0),0))","v":"California"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R3)*(Data!$C$2:$C$51=Q3)*(Data!$L$2:$L$51))","v":8.6999999999999994E-2}]
[3,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B4)*(Data!$P$2:$P$51=A4),0),0))","v":"Colorado"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C4)*(Data!$C$2:$C$51=B4)*(Data!$D$2:$D$51))","v":645274.74904200004},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C4)*(Data!$C$2:$C$51=$B4)*(Data!E$2:E$51))","v":825054.02},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C4)*(Data!$C$2:$C$51=$B4)*(Data!F$2:F$51))","v":849805.64060000004},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C4)*(Data!$C$2:$C$51=$B4)*(Data!G$2:G$51))","v":807315.35857000004},"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B4)*(Data!$Q$2:$Q$51=A4),0),0))","v":"Arizona"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I4)*(Data!$C$2:$C$51=$H4)*(Data!H$2:H$51))","v":596214.36167999997},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I4)*(Data!$C$2:$C$51=$H4)*(Data!I$2:I$51))","v":614100.79253039998},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I4)*(Data!$C$2:$C$51=$H4)*(Data!J$2:J$51))","v":583395.75290387997},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I4)*(Data!$C$2:$C$51=$H4)*(Data!K$2:K$51))","v":466716.60232310399},"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N4)*(Data!$O$2:$O$51=A4),0),0))","v":"Washington"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O4)*(Data!$C$2:$C$51=N4)*(Data!$M$2:$M$51))","v":102.6},"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q4)*(Data!$R$2:$R$51=A4),0),0))","v":"Arizona"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R4)*(Data!$C$2:$C$51=Q4)*(Data!$L$2:$L$51))","v":8.199999999999999E-2}]
[4,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B5)*(Data!$P$2:$P$51=A5),0),0))","v":"Arizona"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C5)*(Data!$C$2:$C$51=B5)*(Data!$D$2:$D$51))","v":545130.51991200005},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C5)*(Data!$C$2:$C$51=$B5)*(Data!E$2:E$51))","v":697008.72},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C5)*(Data!$C$2:$C$51=$B5)*(Data!F$2:F$51))","v":717918.98159999994},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C5)*(Data!$C$2:$C$51=$B5)*(Data!G$2:G$51))","v":682023.03251999989},"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B5)*(Data!$Q$2:$Q$51=A5),0),0))","v":"Oregon"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I5)*(Data!$C$2:$C$51=$H5)*(Data!H$2:H$51))","v":356559.56923999998},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I5)*(Data!$C$2:$C$51=$H5)*(Data!I$2:I$51))","v":342297.18647039996},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I5)*(Data!$C$2:$C$51=$H5)*(Data!J$2:J$51))","v":352566.10206451197},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I5)*(Data!$C$2:$C$51=$H5)*(Data!K$2:K$51))","v":338463.45798193145},"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N5)*(Data!$O$2:$O$51=A5),0),0))","v":"Arizona"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O5)*(Data!$C$2:$C$51=N5)*(Data!$M$2:$M$51))","v":57.05},"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q5)*(Data!$R$2:$R$51=A5),0),0))","v":"Oregon"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R5)*(Data!$C$2:$C$51=Q5)*(Data!$L$2:$L$51))","v":7.6999999999999999E-2}]
[5,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B6)*(Data!$P$2:$P$51=A6),0),0))","v":"Montana"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C6)*(Data!$C$2:$C$51=B6)*(Data!$D$2:$D$51))","v":552798.21978000004},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C6)*(Data!$C$2:$C$51=$B6)*(Data!E$2:E$51))","v":686024.1},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C6)*(Data!$C$2:$C$51=$B6)*(Data!F$2:F$51))","v":665443.37699999986},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C6)*(Data!$C$2:$C$51=$B6)*(Data!G$2:G$51))","v":645480.07568999985},"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B6)*(Data!$Q$2:$Q$51=A6),0),0))","v":"Colorado"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I6)*(Data!$C$2:$C$51=$H6)*(Data!H$2:H$51))","v":235270.86330999999},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I6)*(Data!$C$2:$C$51=$H6)*(Data!I$2:I$51))","v":242328.98920929999},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I6)*(Data!$C$2:$C$51=$H6)*(Data!J$2:J$51))","v":230212.53974883497},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I6)*(Data!$C$2:$C$51=$H6)*(Data!K$2:K$51))","v":221004.03815888157},"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N6)*(Data!$O$2:$O$51=A6),0),0))","v":"Colorado"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O6)*(Data!$C$2:$C$51=N6)*(Data!$M$2:$M$51))","v":49.33},"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q6)*(Data!$R$2:$R$51=A6),0),0))","v":"Washington"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R6)*(Data!$C$2:$C$51=Q6)*(Data!$L$2:$L$51))","v":7.0000000000000007E-2}]
[6,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B7)*(Data!$P$2:$P$51=A7),0),0))","v":"Oregon"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C7)*(Data!$C$2:$C$51=B7)*(Data!$D$2:$D$51))","v":177666.544242},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C7)*(Data!$C$2:$C$51=$B7)*(Data!E$2:E$51))","v":227166.02},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C7)*(Data!$C$2:$C$51=$B7)*(Data!F$2:F$51))","v":218079.3792},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C7)*(Data!$C$2:$C$51=$B7)*(Data!G$2:G$51))","v":224621.760576},"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B7)*(Data!$Q$2:$Q$51=A7),0),0))","v":"Utah"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I7)*(Data!$C$2:$C$51=$H7)*(Data!H$2:H$51))","v":128595.25448},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I7)*(Data!$C$2:$C$51=$H7)*(Data!I$2:I$51))","v":132453.11211440002},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I7)*(Data!$C$2:$C$51=$H7)*(Data!J$2:J$51))","v":136426.70547783203},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I7)*(Data!$C$2:$C$51=$H7)*(Data!K$2:K$51))","v":140519.50664216699},"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N7)*(Data!$O$2:$O$51=A7),0),0))","v":"Oregon"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O7)*(Data!$C$2:$C$51=N7)*(Data!$M$2:$M$51))","v":40.33},"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q7)*(Data!$R$2:$R$51=A7),0),0))","v":"Colorado"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R7)*(Data!$C$2:$C$51=Q7)*(Data!$L$2:$L$51))","v":6.8000000000000005E-2}]
[7,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B8)*(Data!$P$2:$P$51=A8),0),0))","v":"Idaho"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C8)*(Data!$C$2:$C$51=B8)*(Data!$D$2:$D$51))","v":184266.07326000003},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C8)*(Data!$C$2:$C$51=$B8)*(Data!E$2:E$51))","v":228674.69999999998},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C8)*(Data!$C$2:$C$51=$B8)*(Data!F$2:F$51))","v":221814.45899999997},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C8)*(Data!$C$2:$C$51=$B8)*(Data!G$2:G$51))","v":215160.02522999997},"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B8)*(Data!$Q$2:$Q$51=A8),0),0))","v":"Nevada"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I8)*(Data!$C$2:$C$51=$H8)*(Data!H$2:H$51))","v":125672.63506},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I8)*(Data!$C$2:$C$51=$H8)*(Data!I$2:I$51))","v":129442.81411180001},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I8)*(Data!$C$2:$C$51=$H8)*(Data!J$2:J$51))","v":133326.09853515401},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I8)*(Data!$C$2:$C$51=$H8)*(Data!K$2:K$51))","v":137325.88149120865},"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N8)*(Data!$O$2:$O$51=A8),0),0))","v":"Utah"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O8)*(Data!$C$2:$C$51=N8)*(Data!$M$2:$M$51))","v":34.299999999999997},"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q8)*(Data!$R$2:$R$51=A8),0),0))","v":"Idaho"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R8)*(Data!$C$2:$C$51=Q8)*(Data!$L$2:$L$51))","v":6.7000000000000004E-2}]
[8,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B9)*(Data!$P$2:$P$51=A9),0),0))","v":"New Mexico"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C9)*(Data!$C$2:$C$51=B9)*(Data!$D$2:$D$51))","v":182700.50055599998},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C9)*(Data!$C$2:$C$51=$B9)*(Data!E$2:E$51))","v":235986.18},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C9)*(Data!$C$2:$C$51=$B9)*(Data!F$2:F$51))","v":224186.87099999998},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C9)*(Data!$C$2:$C$51=$B9)*(Data!G$2:G$51))","v":212977.52744999999},"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B9)*(Data!$Q$2:$Q$51=A9),0),0))","v":"New Mexico"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I9)*(Data!$C$2:$C$51=$H9)*(Data!H$2:H$51))","v":96446.440860000002},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I9)*(Data!$C$2:$C$51=$H9)*(Data!I$2:I$51))","v":91624.118816999995},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I9)*(Data!$C$2:$C$51=$H9)*(Data!J$2:J$51))","v":87042.912876149989},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I9)*(Data!$C$2:$C$51=$H9)*(Data!K$2:K$51))","v":82690.767232342492},"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N9)*(Data!$O$2:$O$51=A9),0),0))","v":"Nevada"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O9)*(Data!$C$2:$C$51=N9)*(Data!$M$2:$M$51))","v":24.8},"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q9)*(Data!$R$2:$R$51=A9),0),0))","v":"New Mexico"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R9)*(Data!$C$2:$C$51=Q9)*(Data!$L$2:$L$51))","v":6.6000000000000003E-2}]
[9,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B10)*(Data!$P$2:$P$51=A10),0),0))","v":"Hawaii"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C10)*(Data!$C$2:$C$51=B10)*(Data!$D$2:$D$51))","v":157410.88657200002},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C10)*(Data!$C$2:$C$51=$B10)*(Data!E$2:E$51))","v":195347.34},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C10)*(Data!$C$2:$C$51=$B10)*(Data!F$2:F$51))","v":213905.33730000001},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C10)*(Data!$C$2:$C$51=$B10)*(Data!G$2:G$51))","v":207488.17718100001},"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B10)*(Data!$Q$2:$Q$51=A10),0),0))","v":"Hawaii"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I10)*(Data!$C$2:$C$51=$H10)*(Data!H$2:H$51))","v":62836.31753},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I10)*(Data!$C$2:$C$51=$H10)*(Data!I$2:I$51))","v":68805.767695350005},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I10)*(Data!$C$2:$C$51=$H10)*(Data!J$2:J$51))","v":75342.31562640825},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I10)*(Data!$C$2:$C$51=$H10)*(Data!K$2:K$51))","v":73082.046157616001},"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N10)*(Data!$O$2:$O$51=A10),0),0))","v":"Idaho"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O10)*(Data!$C$2:$C$51=N10)*(Data!$M$2:$M$51))","v":19.5},"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q10)*(Data!$R$2:$R$51=A10),0),0))","v":"Alaska"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R10)*(Data!$C$2:$C$51=Q10)*(Data!$L$2:$L$51))","v":6.5000000000000002E-2}]
[10,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B11)*(Data!$P$2:$P$51=A11),0),0))","v":"Utah"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C11)*(Data!$C$2:$C$51=B11)*(Data!$D$2:$D$51))","v":121101.36271800002},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C11)*(Data!$C$2:$C$51=$B11)*(Data!E$2:E$51))","v":156421.29},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C11)*(Data!$C$2:$C$51=$B11)*(Data!F$2:F$51))","v":161113.92870000002},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C11)*(Data!$C$2:$C$51=$B11)*(Data!G$2:G$51))","v":165947.34656100001},"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B11)*(Data!$Q$2:$Q$51=A11),0),0))","v":"Idaho"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I11)*(Data!$C$2:$C$51=$H11)*(Data!H$2:H$51))","v":74526.795209999997},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I11)*(Data!$C$2:$C$51=$H11)*(Data!I$2:I$51))","v":72290.991353699996},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I11)*(Data!$C$2:$C$51=$H11)*(Data!J$2:J$51))","v":70122.261613088995},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I11)*(Data!$C$2:$C$51=$H11)*(Data!K$2:K$51))","v":66616.148532434541},"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N11)*(Data!$O$2:$O$51=A11),0),0))","v":"New Mexico"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O11)*(Data!$C$2:$C$51=N11)*(Data!$M$2:$M$51))","v":17.16},"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q11)*(Data!$R$2:$R$51=A11),0),0))","v":"Montana"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R11)*(Data!$C$2:$C$51=Q11)*(Data!$L$2:$L$51))","v":5.2000000000000005E-2}]
[1,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B12)*(Data!$P$2:$P$51=A12),0),0))","v":"Texas"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C12)*(Data!$C$2:$C$51=B12)*(Data!$D$2:$D$51))","v":1676519.8460053997},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C12)*(Data!$C$2:$C$51=$B12)*(Data!E$2:E$51))","v":2194598.7799999998},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C12)*(Data!$C$2:$C$51=$B12)*(Data!F$2:F$51))","v":2084868.8409999998},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C12)*(Data!$C$2:$C$51=$B12)*(Data!G$2:G$51))","v":2147414.9062299998},"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B12)*(Data!$Q$2:$Q$51=A12),0),0))","v":"Texas"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I12)*(Data!$C$2:$C$51=$H12)*(Data!H$2:H$51))","v":1174893.0068399999},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I12)*(Data!$C$2:$C$51=$H12)*(Data!I$2:I$51))","v":1116148.356498},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I12)*(Data!$C$2:$C$51=$H12)*(Data!J$2:J$51))","v":1149632.80719294},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I12)*(Data!$C$2:$C$51=$H12)*(Data!K$2:K$51))","v":1161129.1352648695},"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N12)*(Data!$O$2:$O$51=A12),0),0))","v":"Florida"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O12)*(Data!$C$2:$C$51=N12)*(Data!$M$2:$M$51))","v":360.2},"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q12)*(Data!$R$2:$R$51=A12),0),0))","v":"Mississippi"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R12)*(Data!$C$2:$C$51=Q12)*(Data!$L$2:$L$51))","v":8.5000000000000006E-2}]
[2,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B13)*(Data!$P$2:$P$51=A13),0),0))","v":"Florida"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C13)*(Data!$C$2:$C$51=B13)*(Data!$D$2:$D$51))","v":933901.63665550016},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C13)*(Data!$C$2:$C$51=$B13)*(Data!E$2:E$51))","v":1222496.3500000001},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C13)*(Data!$C$2:$C$51=$B13)*(Data!F$2:F$51))","v":1161371.5325},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C13)*(Data!$C$2:$C$51=$B13)*(Data!G$2:G$51))","v":1242667.539775},"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B13)*(Data!$Q$2:$Q$51=A13),0),0))","v":"Florida"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I13)*(Data!$C$2:$C$51=$H13)*(Data!H$2:H$51))","v":878247.13570999994},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I13)*(Data!$C$2:$C$51=$H13)*(Data!I$2:I$51))","v":834334.77892449987},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I13)*(Data!$C$2:$C$51=$H13)*(Data!J$2:J$51))","v":892738.21344921493},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I13)*(Data!$C$2:$C$51=$H13)*(Data!K$2:K$51))","v":901665.59558370709},"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N13)*(Data!$O$2:$O$51=A13),0),0))","v":"Virginia"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O13)*(Data!$C$2:$C$51=N13)*(Data!$M$2:$M$51))","v":207.3},"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q13)*(Data!$R$2:$R$51=A13),0),0))","v":"Tennessee"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R13)*(Data!$C$2:$C$51=Q13)*(Data!$L$2:$L$51))","v":8.4000000000000005E-2}]
[3,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B14)*(Data!$P$2:$P$51=A14),0),0))","v":"Virginia"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C14)*(Data!$C$2:$C$51=B14)*(Data!$D$2:$D$51))","v":502869.96540000004},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C14)*(Data!$C$2:$C$51=$B14)*(Data!E$2:E$51))","v":642974},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C14)*(Data!$C$2:$C$51=$B14)*(Data!F$2:F$51))","v":610825.29999999993},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C14)*(Data!$C$2:$C$51=$B14)*(Data!G$2:G$51))","v":653583.071},"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B14)*(Data!$Q$2:$Q$51=A14),0),0))","v":"North Carolina"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I14)*(Data!$C$2:$C$51=$H14)*(Data!H$2:H$51))","v":445699.46155000001},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I14)*(Data!$C$2:$C$51=$H14)*(Data!I$2:I$51))","v":488040.91039724997},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I14)*(Data!$C$2:$C$51=$H14)*(Data!J$2:J$51))","v":463638.86487738747},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I14)*(Data!$C$2:$C$51=$H14)*(Data!K$2:K$51))","v":440456.92163351807},"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N14)*(Data!$O$2:$O$51=A14),0),0))","v":"North Carolina"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O14)*(Data!$C$2:$C$51=N14)*(Data!$M$2:$M$51))","v":200.6},"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q14)*(Data!$R$2:$R$51=A14),0),0))","v":"Kentucky"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R14)*(Data!$C$2:$C$51=Q14)*(Data!$L$2:$L$51))","v":8.4000000000000005E-2}]
[4,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B15)*(Data!$P$2:$P$51=A15),0),0))","v":"North Carolina"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C15)*(Data!$C$2:$C$51=B15)*(Data!$D$2:$D$51))","v":470581.3689152},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C15)*(Data!$C$2:$C$51=$B15)*(Data!E$2:E$51))","v":616000.64},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C15)*(Data!$C$2:$C$51=$B15)*(Data!F$2:F$51))","v":674520.70079999999},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C15)*(Data!$C$2:$C$51=$B15)*(Data!G$2:G$51))","v":640794.66576},"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B15)*(Data!$Q$2:$Q$51=A15),0),0))","v":"Georgia"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I15)*(Data!$C$2:$C$51=$H15)*(Data!H$2:H$51))","v":453006.01010000001},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I15)*(Data!$C$2:$C$51=$H15)*(Data!I$2:I$51))","v":434885.76969599997},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I15)*(Data!$C$2:$C$51=$H15)*(Data!J$2:J$51))","v":413141.48121119995},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I15)*(Data!$C$2:$C$51=$H15)*(Data!K$2:K$51))","v":400747.23677486397},"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N15)*(Data!$O$2:$O$51=A15),0),0))","v":"Georgia"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O15)*(Data!$C$2:$C$51=N15)*(Data!$M$2:$M$51))","v":172.5},"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q15)*(Data!$R$2:$R$51=A15),0),0))","v":"Georgia"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R15)*(Data!$C$2:$C$51=Q15)*(Data!$L$2:$L$51))","v":8.1000000000000003E-2}]
[5,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B16)*(Data!$P$2:$P$51=A16),0),0))","v":"Georgia"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C16)*(Data!$C$2:$C$51=B16)*(Data!$D$2:$D$51))","v":500361.22430440004},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C16)*(Data!$C$2:$C$51=$B16)*(Data!E$2:E$51))","v":654983.07999999996},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C16)*(Data!$C$2:$C$51=$B16)*(Data!F$2:F$51))","v":628783.75679999997},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C16)*(Data!$C$2:$C$51=$B16)*(Data!G$2:G$51))","v":597344.56895999995},"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B16)*(Data!$Q$2:$Q$51=A16),0),0))","v":"Virginia"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I16)*(Data!$C$2:$C$51=$H16)*(Data!H$2:H$51))","v":374095.28576},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I16)*(Data!$C$2:$C$51=$H16)*(Data!I$2:I$51))","v":355390.52147199999},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I16)*(Data!$C$2:$C$51=$H16)*(Data!J$2:J$51))","v":380267.85797504004},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I16)*(Data!$C$2:$C$51=$H16)*(Data!K$2:K$51))","v":361254.46507628803},"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N16)*(Data!$O$2:$O$51=A16),0),0))","v":"South Carolina"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O16)*(Data!$C$2:$C$51=N16)*(Data!$M$2:$M$51))","v":157.1},"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q16)*(Data!$R$2:$R$51=A16),0),0))","v":"North Carolina"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R16)*(Data!$C$2:$C$51=Q16)*(Data!$L$2:$L$51))","v":0.08}]
[6,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B17)*(Data!$P$2:$P$51=A17),0),0))","v":"Tennessee"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C17)*(Data!$C$2:$C$51=B17)*(Data!$D$2:$D$51))","v":367667.57976300007},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C17)*(Data!$C$2:$C$51=$B17)*(Data!E$2:E$51))","v":470103.03},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C17)*(Data!$C$2:$C$51=$B17)*(Data!F$2:F$51))","v":446597.87849999999},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C17)*(Data!$C$2:$C$51=$B17)*(Data!G$2:G$51))","v":459995.814855},"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B17)*(Data!$Q$2:$Q$51=A17),0),0))","v":"Tennessee"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I17)*(Data!$C$2:$C$51=$H17)*(Data!H$2:H$51))","v":296645.87112999998},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I17)*(Data!$C$2:$C$51=$H17)*(Data!I$2:I$51))","v":281813.57757349999},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I17)*(Data!$C$2:$C$51=$H17)*(Data!J$2:J$51))","v":270541.03447055997},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I17)*(Data!$C$2:$C$51=$H17)*(Data!K$2:K$51))","v":296242.43274526316},"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N17)*(Data!$O$2:$O$51=A17),0),0))","v":"Tennessee"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O17)*(Data!$C$2:$C$51=N17)*(Data!$M$2:$M$51))","v":156.6},"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q17)*(Data!$R$2:$R$51=A17),0),0))","v":"South Carolina"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R17)*(Data!$C$2:$C$51=Q17)*(Data!$L$2:$L$51))","v":7.4999999999999997E-2}]
[7,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B18)*(Data!$P$2:$P$51=A18),0),0))","v":"Louisiana"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C18)*(Data!$C$2:$C$51=B18)*(Data!$D$2:$D$51))","v":272257.39411199995},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C18)*(Data!$C$2:$C$51=$B18)*(Data!E$2:E$51))","v":348110.72},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C18)*(Data!$C$2:$C$51=$B18)*(Data!F$2:F$51))","v":330705.18399999995},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C18)*(Data!$C$2:$C$51=$B18)*(Data!G$2:G$51))","v":320784.02847999992},"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B18)*(Data!$Q$2:$Q$51=A18),0),0))","v":"South Carolina"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I18)*(Data!$C$2:$C$51=$H18)*(Data!H$2:H$51))","v":216273.83708},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I18)*(Data!$C$2:$C$51=$H18)*(Data!I$2:I$51))","v":222762.05219240001},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I18)*(Data!$C$2:$C$51=$H18)*(Data!J$2:J$51))","v":229444.91375817201},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I18)*(Data!$C$2:$C$51=$H18)*(Data!K$2:K$51))","v":251242.18056519836},"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N18)*(Data!$O$2:$O$51=A18),0),0))","v":"Kentucky"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O18)*(Data!$C$2:$C$51=N18)*(Data!$M$2:$M$51))","v":110},"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q18)*(Data!$R$2:$R$51=A18),0),0))","v":"Arkansas"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R18)*(Data!$C$2:$C$51=Q18)*(Data!$L$2:$L$51))","v":7.4999999999999997E-2}]
[8,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B19)*(Data!$P$2:$P$51=A19),0),0))","v":"Oklahoma"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C19)*(Data!$C$2:$C$51=B19)*(Data!$D$2:$D$51))","v":209709.59788799999},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C19)*(Data!$C$2:$C$51=$B19)*(Data!E$2:E$51))","v":270872.64},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C19)*(Data!$C$2:$C$51=$B19)*(Data!F$2:F$51))","v":262746.4608},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C19)*(Data!$C$2:$C$51=$B19)*(Data!G$2:G$51))","v":270628.85462400003},"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B19)*(Data!$Q$2:$Q$51=A19),0),0))","v":"Alabama"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I19)*(Data!$C$2:$C$51=$H19)*(Data!H$2:H$51))","v":223580.38563},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I19)*(Data!$C$2:$C$51=$H19)*(Data!I$2:I$51))","v":230287.79719890002},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I19)*(Data!$C$2:$C$51=$H19)*(Data!J$2:J$51))","v":218773.407338955},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I19)*(Data!$C$2:$C$51=$H19)*(Data!K$2:K$51))","v":212210.20511878634},"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N19)*(Data!$O$2:$O$51=A19),0),0))","v":"Louisiana"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O19)*(Data!$C$2:$C$51=N19)*(Data!$M$2:$M$51))","v":105},"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q19)*(Data!$R$2:$R$51=A19),0),0))","v":"Florida"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R19)*(Data!$C$2:$C$51=Q19)*(Data!$L$2:$L$51))","v":6.7000000000000004E-2}]
[9,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B20)*(Data!$P$2:$P$51=A20),0),0))","v":"Arkansas"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C20)*(Data!$C$2:$C$51=B20)*(Data!$D$2:$D$51))","v":195871.299344},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C20)*(Data!$C$2:$C$51=$B20)*(Data!E$2:E$51))","v":252998.32},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C20)*(Data!$C$2:$C$51=$B20)*(Data!F$2:F$51))","v":260588.2696},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C20)*(Data!$C$2:$C$51=$B20)*(Data!G$2:G$51))","v":268405.91768800002},"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B20)*(Data!$Q$2:$Q$51=A20),0),0))","v":"Louisiana"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I20)*(Data!$C$2:$C$51=$H20)*(Data!H$2:H$51))","v":211889.90794999999},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I20)*(Data!$C$2:$C$51=$H20)*(Data!I$2:I$51))","v":201295.4125525},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I20)*(Data!$C$2:$C$51=$H20)*(Data!J$2:J$51))","v":195256.55017592499},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I20)*(Data!$C$2:$C$51=$H20)*(Data!K$2:K$51))","v":185493.72266712872},"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N20)*(Data!$O$2:$O$51=A20),0),0))","v":"Texas"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O20)*(Data!$C$2:$C$51=N20)*(Data!$M$2:$M$51))","v":98.07},"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q20)*(Data!$R$2:$R$51=A20),0),0))","v":"Alabama"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R20)*(Data!$C$2:$C$51=Q20)*(Data!$L$2:$L$51))","v":6.5000000000000002E-2}]
[10,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B21)*(Data!$P$2:$P$51=A21),0),0))","v":"Kentucky"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C21)*(Data!$C$2:$C$51=B21)*(Data!$D$2:$D$51))","v":196196.14347300003},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C21)*(Data!$C$2:$C$51=$B21)*(Data!E$2:E$51))","v":250858.13},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C21)*(Data!$C$2:$C$51=$B21)*(Data!F$2:F$51))","v":238315.22349999999},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C21)*(Data!$C$2:$C$51=$B21)*(Data!G$2:G$51))","v":260955.16973249998},"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B21)*(Data!$Q$2:$Q$51=A21),0),0))","v":"Oklahoma"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I21)*(Data!$C$2:$C$51=$H21)*(Data!H$2:H$51))","v":175357.16519999999},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I21)*(Data!$C$2:$C$51=$H21)*(Data!I$2:I$51))","v":170096.45024399998},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I21)*(Data!$C$2:$C$51=$H21)*(Data!J$2:J$51))","v":175199.34375131998},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I21)*(Data!$C$2:$C$51=$H21)*(Data!K$2:K$51))","v":169943.36343878036},"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N21)*(Data!$O$2:$O$51=A21),0),0))","v":"Alabama"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O21)*(Data!$C$2:$C$51=N21)*(Data!$M$2:$M$51))","v":94.65},"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q21)*(Data!$R$2:$R$51=A21),0),0))","v":"Louisiana"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R21)*(Data!$C$2:$C$51=Q21)*(Data!$L$2:$L$51))","v":6.5000000000000002E-2}]
[1,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B22)*(Data!$P$2:$P$51=A22),0),0))","v":"New York"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C22)*(Data!$C$2:$C$51=B22)*(Data!$D$2:$D$51))","v":1536782.3509922},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C22)*(Data!$C$2:$C$51=$B22)*(Data!E$2:E$51))","v":2011679.54},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C22)*(Data!$C$2:$C$51=$B22)*(Data!F$2:F$51))","v":1911095.5629999998},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C22)*(Data!$C$2:$C$51=$B22)*(Data!G$2:G$51))","v":2044872.25241},"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B22)*(Data!$Q$2:$Q$51=A22),0),0))","v":"New York"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I22)*(Data!$C$2:$C$51=$H22)*(Data!H$2:H$51))","v":904550.71048999997},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I22)*(Data!$C$2:$C$51=$H22)*(Data!I$2:I$51))","v":859323.1749654999},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I22)*(Data!$C$2:$C$51=$H22)*(Data!J$2:J$51))","v":919475.797213085},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I22)*(Data!$C$2:$C$51=$H22)*(Data!K$2:K$51))","v":928670.5551852159},"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N22)*(Data!$O$2:$O$51=A22),0),0))","v":"Massachusetts"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O22)*(Data!$C$2:$C$51=N22)*(Data!$M$2:$M$51))","v":852.1},"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q22)*(Data!$R$2:$R$51=A22),0),0))","v":"Rhode Island"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R22)*(Data!$C$2:$C$51=Q22)*(Data!$L$2:$L$51))","v":9.1999999999999998E-2}]
[2,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B23)*(Data!$P$2:$P$51=A23),0),0))","v":"New Jersey"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C23)*(Data!$C$2:$C$51=B23)*(Data!$D$2:$D$51))","v":871083.34928999993},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C23)*(Data!$C$2:$C$51=$B23)*(Data!E$2:E$51))","v":1113774.8999999999},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C23)*(Data!$C$2:$C$51=$B23)*(Data!F$2:F$51))","v":1058086.1549999998},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C23)*(Data!$C$2:$C$51=$B23)*(Data!G$2:G$51))","v":1158604.3397249999},"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B23)*(Data!$Q$2:$Q$51=A23),0),0))","v":"Pennsylvania"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I23)*(Data!$C$2:$C$51=$H23)*(Data!H$2:H$51))","v":593291.74225999997},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I23)*(Data!$C$2:$C$51=$H23)*(Data!I$2:I$51))","v":563627.15514699998},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I23)*(Data!$C$2:$C$51=$H23)*(Data!J$2:J$51))","v":603081.05600729003},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I23)*(Data!$C$2:$C$51=$H23)*(Data!K$2:K$51))","v":482464.84480583202},"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N23)*(Data!$O$2:$O$51=A23),0),0))","v":"Connecticut"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O23)*(Data!$C$2:$C$51=N23)*(Data!$M$2:$M$51))","v":741.4},"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q23)*(Data!$R$2:$R$51=A23),0),0))","v":"New Jersey"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R23)*(Data!$C$2:$C$51=Q23)*(Data!$L$2:$L$51))","v":8.4000000000000005E-2}]
[3,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B24)*(Data!$P$2:$P$51=A24),0),0))","v":"Pennsylvania"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C24)*(Data!$C$2:$C$51=B24)*(Data!$D$2:$D$51))","v":832389.70153949992},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C24)*(Data!$C$2:$C$51=$B24)*(Data!E$2:E$51))","v":1089615.1499999999},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C24)*(Data!$C$2:$C$51=$B24)*(Data!F$2:F$51))","v":1035134.3924999998},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C24)*(Data!$C$2:$C$51=$B24)*(Data!G$2:G$51))","v":1107593.7999749999},"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B24)*(Data!$Q$2:$Q$51=A24),0),0))","v":"New Jersey"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I24)*(Data!$C$2:$C$51=$H24)*(Data!H$2:H$51))","v":410628.02850999997},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I24)*(Data!$C$2:$C$51=$H24)*(Data!I$2:I$51))","v":390096.62708449998},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I24)*(Data!$C$2:$C$51=$H24)*(Data!J$2:J$51))","v":427155.80665752746},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I24)*(Data!$C$2:$C$51=$H24)*(Data!K$2:K$51))","v":405798.01632465108},"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N24)*(Data!$O$2:$O$51=A24),0),0))","v":"Maryland"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O24)*(Data!$C$2:$C$51=N24)*(Data!$M$2:$M$51))","v":606.20000000000005},"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q24)*(Data!$R$2:$R$51=A24),0),0))","v":"Connecticut"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R24)*(Data!$C$2:$C$51=Q24)*(Data!$L$2:$L$51))","v":7.9000000000000001E-2}]
[4,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B25)*(Data!$P$2:$P$51=A25),0),0))","v":"Massachusetts"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C25)*(Data!$C$2:$C$51=B25)*(Data!$D$2:$D$51))","v":624326.77929600002},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C25)*(Data!$C$2:$C$51=$B25)*(Data!E$2:E$51))","v":798269.76},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C25)*(Data!$C$2:$C$51=$B25)*(Data!F$2:F$51))","v":758356.272},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C25)*(Data!$C$2:$C$51=$B25)*(Data!G$2:G$51))","v":781106.96016000002},"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B25)*(Data!$Q$2:$Q$51=A25),0),0))","v":"Massachusetts"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I25)*(Data!$C$2:$C$51=$H25)*(Data!H$2:H$51))","v":305413.72938999999},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I25)*(Data!$C$2:$C$51=$H25)*(Data!I$2:I$51))","v":290143.04292049998},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I25)*(Data!$C$2:$C$51=$H25)*(Data!J$2:J$51))","v":298847.334208115},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I25)*(Data!$C$2:$C$51=$H25)*(Data!K$2:K$51))","v":283904.96749770927},"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N25)*(Data!$O$2:$O$51=A25),0),0))","v":"Delaware"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O25)*(Data!$C$2:$C$51=N25)*(Data!$M$2:$M$51))","v":470.7},"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q25)*(Data!$R$2:$R$51=A25),0),0))","v":"New York"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R25)*(Data!$C$2:$C$51=Q25)*(Data!$L$2:$L$51))","v":7.6999999999999999E-2}]
[5,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B26)*(Data!$P$2:$P$51=A26),0),0))","v":"Connecticut"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C26)*(Data!$C$2:$C$51=B26)*(Data!$D$2:$D$51))","v":365907.83888400003},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C26)*(Data!$C$2:$C$51=$B26)*(Data!E$2:E$51))","v":472627.02},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C26)*(Data!$C$2:$C$51=$B26)*(Data!F$2:F$51))","v":517526.58689999999},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C26)*(Data!$C$2:$C$51=$B26)*(Data!G$2:G$51))","v":533052.38450699998},"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B26)*(Data!$Q$2:$Q$51=A26),0),0))","v":"Maryland"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I26)*(Data!$C$2:$C$51=$H26)*(Data!H$2:H$51))","v":270342.29635000002},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I26)*(Data!$C$2:$C$51=$H26)*(Data!I$2:I$51))","v":262232.02745950001},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I26)*(Data!$C$2:$C$51=$H26)*(Data!J$2:J$51))","v":287144.0700681525},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I26)*(Data!$C$2:$C$51=$H26)*(Data!K$2:K$51))","v":278529.74796610791},"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N26)*(Data!$O$2:$O$51=A26),0),0))","v":"New York"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O26)*(Data!$C$2:$C$51=N26)*(Data!$M$2:$M$51))","v":415.3},"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q26)*(Data!$R$2:$R$51=A26),0),0))","v":"Pennsylvania"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R26)*(Data!$C$2:$C$51=Q26)*(Data!$L$2:$L$51))","v":7.4999999999999997E-2}]
[6,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B27)*(Data!$P$2:$P$51=A27),0),0))","v":"Maryland"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C27)*(Data!$C$2:$C$51=B27)*(Data!$D$2:$D$51))","v":376244.86264200002},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C27)*(Data!$C$2:$C$51=$B27)*(Data!E$2:E$51))","v":481070.02},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C27)*(Data!$C$2:$C$51=$B27)*(Data!F$2:F$51))","v":466637.91940000001},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C27)*(Data!$C$2:$C$51=$B27)*(Data!G$2:G$51))","v":510968.52174300002},"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B27)*(Data!$Q$2:$Q$51=A27),0),0))","v":"Connecticut"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I27)*(Data!$C$2:$C$51=$H27)*(Data!H$2:H$51))","v":166589.30694000001},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I27)*(Data!$C$2:$C$51=$H27)*(Data!I$2:I$51))","v":182415.2910993},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I27)*(Data!$C$2:$C$51=$H27)*(Data!J$2:J$51))","v":187887.74983227899},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I27)*(Data!$C$2:$C$51=$H27)*(Data!K$2:K$51))","v":178493.36234066504},"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N27)*(Data!$O$2:$O$51=A27),0),0))","v":"Pennsylvania"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O27)*(Data!$C$2:$C$51=N27)*(Data!$M$2:$M$51))","v":285.3},"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q27)*(Data!$R$2:$R$51=A27),0),0))","v":"Massachusetts"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R27)*(Data!$C$2:$C$51=Q27)*(Data!$L$2:$L$51))","v":7.2000000000000008E-2}]
[7,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B28)*(Data!$P$2:$P$51=A28),0),0))","v":"Delaware"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C28)*(Data!$C$2:$C$51=B28)*(Data!$D$2:$D$51))","v":175949.74989600002},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C28)*(Data!$C$2:$C$51=$B28)*(Data!E$2:E$51))","v":218354.12},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C28)*(Data!$C$2:$C$51=$B28)*(Data!F$2:F$51))","v":207436.41399999999},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C28)*(Data!$C$2:$C$51=$B28)*(Data!G$2:G$51))","v":201213.32157999999},"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B28)*(Data!$Q$2:$Q$51=A28),0),0))","v":"New Hampshire"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I28)*(Data!$C$2:$C$51=$H28)*(Data!H$2:H$51))","v":61375.007819999999},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I28)*(Data!$C$2:$C$51=$H28)*(Data!I$2:I$51))","v":63216.258054600003},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I28)*(Data!$C$2:$C$51=$H28)*(Data!J$2:J$51))","v":65112.745796238007},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I28)*(Data!$C$2:$C$51=$H28)*(Data!K$2:K$51))","v":67066.128170125143},"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N28)*(Data!$O$2:$O$51=A28),0),0))","v":"New Jersey"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O28)*(Data!$C$2:$C$51=N28)*(Data!$M$2:$M$51))","v":204},"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q28)*(Data!$R$2:$R$51=A28),0),0))","v":"Delaware"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R28)*(Data!$C$2:$C$51=Q28)*(Data!$L$2:$L$51))","v":6.8000000000000005E-2}]
[8,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B29)*(Data!$P$2:$P$51=A29),0),0))","v":"Rhode Island"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C29)*(Data!$C$2:$C$51=B29)*(Data!$D$2:$D$51))","v":88576.259604000006},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C29)*(Data!$C$2:$C$51=$B29)*(Data!E$2:E$51))","v":109923.38},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C29)*(Data!$C$2:$C$51=$B29)*(Data!F$2:F$51))","v":113221.08140000001},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C29)*(Data!$C$2:$C$51=$B29)*(Data!G$2:G$51))","v":116617.71384200001},"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B29)*(Data!$Q$2:$Q$51=A29),0),0))","v":"Maine"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I29)*(Data!$C$2:$C$51=$H29)*(Data!H$2:H$51))","v":61375.007819999999},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I29)*(Data!$C$2:$C$51=$H29)*(Data!I$2:I$51))","v":63216.258054600003},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I29)*(Data!$C$2:$C$51=$H29)*(Data!J$2:J$51))","v":60055.445151870001},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I29)*(Data!$C$2:$C$51=$H29)*(Data!K$2:K$51))","v":65760.712441297655},"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N29)*(Data!$O$2:$O$51=A29),0),0))","v":"New Hampshire"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O29)*(Data!$C$2:$C$51=N29)*(Data!$M$2:$M$51))","v":147},"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q29)*(Data!$R$2:$R$51=A29),0),0))","v":"Maryland"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R29)*(Data!$C$2:$C$51=Q29)*(Data!$L$2:$L$51))","v":6.7000000000000004E-2}]
[9,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B30)*(Data!$P$2:$P$51=A30),0),0))","v":"New Hampshire"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C30)*(Data!$C$2:$C$51=B30)*(Data!$D$2:$D$51))","v":70972.374078000008},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C30)*(Data!$C$2:$C$51=$B30)*(Data!E$2:E$51))","v":88076.91},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C30)*(Data!$C$2:$C$51=$B30)*(Data!F$2:F$51))","v":90719.217300000004},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C30)*(Data!$C$2:$C$51=$B30)*(Data!G$2:G$51))","v":93440.793819000013},"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B30)*(Data!$Q$2:$Q$51=A30),0),0))","v":"Rhode Island"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I30)*(Data!$C$2:$C$51=$H30)*(Data!H$2:H$51))","v":49684.530140000003},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I30)*(Data!$C$2:$C$51=$H30)*(Data!I$2:I$51))","v":51175.066044200001},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I30)*(Data!$C$2:$C$51=$H30)*(Data!J$2:J$51))","v":52710.318025526001},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I30)*(Data!$C$2:$C$51=$H30)*(Data!K$2:K$51))","v":50074.802124249698},"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N30)*(Data!$O$2:$O$51=A30),0),0))","v":"Rhode Island"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O30)*(Data!$C$2:$C$51=N30)*(Data!$M$2:$M$51))","v":100.6},"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q30)*(Data!$R$2:$R$51=A30),0),0))","v":"Maine"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R30)*(Data!$C$2:$C$51=Q30)*(Data!$L$2:$L$51))","v":6.7000000000000004E-2}]
[10,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B31)*(Data!$P$2:$P$51=A31),0),0))","v":"Maine"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C31)*(Data!$C$2:$C$51=B31)*(Data!$D$2:$D$51))","v":50194.804962000002},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C31)*(Data!$C$2:$C$51=$B31)*(Data!E$2:E$51))","v":62291.89},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C31)*(Data!$C$2:$C$51=$B31)*(Data!F$2:F$51))","v":64160.646699999998},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C31)*(Data!$C$2:$C$51=$B31)*(Data!G$2:G$51))","v":70255.908136500002},"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B31)*(Data!$Q$2:$Q$51=A31),0),0))","v":"Delaware"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I31)*(Data!$C$2:$C$51=$H31)*(Data!H$2:H$51))","v":42377.981590000003},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I31)*(Data!$C$2:$C$51=$H31)*(Data!I$2:I$51))","v":40259.082510500004},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I31)*(Data!$C$2:$C$51=$H31)*(Data!J$2:J$51))","v":39051.310035185001},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I31)*(Data!$C$2:$C$51=$H31)*(Data!K$2:K$51))","v":37098.74453342575},"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N31)*(Data!$O$2:$O$51=A31),0),0))","v":"Vermont"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O31)*(Data!$C$2:$C$51=N31)*(Data!$M$2:$M$51))","v":67.73},"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q31)*(Data!$R$2:$R$51=A31),0),0))","v":"New Hampshire"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R31)*(Data!$C$2:$C$51=Q31)*(Data!$L$2:$L$51))","v":5.0999999999999997E-2}]
[1,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B32)*(Data!$P$2:$P$51=A32),0),0))","v":"Illinois"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C32)*(Data!$C$2:$C$51=B32)*(Data!$D$2:$D$51))","v":950567.47242110013},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C32)*(Data!$C$2:$C$51=$B32)*(Data!E$2:E$51))","v":1244312.27},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C32)*(Data!$C$2:$C$51=$B32)*(Data!F$2:F$51))","v":1182096.6565},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C32)*(Data!$C$2:$C$51=$B32)*(Data!G$2:G$51))","v":1264843.4224550002},"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B32)*(Data!$Q$2:$Q$51=A32),0),0))","v":"Illinois"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I32)*(Data!$C$2:$C$51=$H32)*(Data!H$2:H$51))","v":599136.98109999998},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I32)*(Data!$C$2:$C$51=$H32)*(Data!I$2:I$51))","v":569180.13204499998},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I32)*(Data!$C$2:$C$51=$H32)*(Data!J$2:J$51))","v":609022.74128814996},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I32)*(Data!$C$2:$C$51=$H32)*(Data!K$2:K$51))","v":666879.90171052422},"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N32)*(Data!$O$2:$O$51=A32),0),0))","v":"Ohio"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O32)*(Data!$C$2:$C$51=N32)*(Data!$M$2:$M$51))","v":282.5},"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q32)*(Data!$R$2:$R$51=A32),0),0))","v":"Michigan"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R32)*(Data!$C$2:$C$51=Q32)*(Data!$L$2:$L$51))","v":0.09}]
[2,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B33)*(Data!$P$2:$P$51=A33),0),0))","v":"Ohio"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C33)*(Data!$C$2:$C$51=B33)*(Data!$D$2:$D$51))","v":848682.50264680013},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C33)*(Data!$C$2:$C$51=$B33)*(Data!E$2:E$51))","v":1110942.76},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C33)*(Data!$C$2:$C$51=$B33)*(Data!F$2:F$51))","v":1055395.622},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C33)*(Data!$C$2:$C$51=$B33)*(Data!G$2:G$51))","v":1002625.8409},"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B33)*(Data!$Q$2:$Q$51=A33),0),0))","v":"Michigan"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I33)*(Data!$C$2:$C$51=$H33)*(Data!H$2:H$51))","v":461773.86836000008},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I33)*(Data!$C$2:$C$51=$H33)*(Data!I$2:I$51))","v":447920.65230920009},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I33)*(Data!$C$2:$C$51=$H33)*(Data!J$2:J$51))","v":430003.82621683209},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I33)*(Data!$C$2:$C$51=$H33)*(Data!K$2:K$51))","v":470854.18970743113},"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N33)*(Data!$O$2:$O$51=A33),0),0))","v":"Illinois"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O33)*(Data!$C$2:$C$51=N33)*(Data!$M$2:$M$51))","v":231.9},"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q33)*(Data!$R$2:$R$51=A33),0),0))","v":"Illinois"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R33)*(Data!$C$2:$C$51=Q33)*(Data!$L$2:$L$51))","v":8.900000000000001E-2}]
[3,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B34)*(Data!$P$2:$P$51=A34),0),0))","v":"Minnesota"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C34)*(Data!$C$2:$C$51=B34)*(Data!$D$2:$D$51))","v":615398.52904199995},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C34)*(Data!$C$2:$C$51=$B34)*(Data!E$2:E$51))","v":786854.02},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C34)*(Data!$C$2:$C$51=$B34)*(Data!F$2:F$51))","v":810459.64060000004},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C34)*(Data!$C$2:$C$51=$B34)*(Data!G$2:G$51))","v":769936.65856999997},"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B34)*(Data!$Q$2:$Q$51=A34),0),0))","v":"Ohio"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I34)*(Data!$C$2:$C$51=$H34)*(Data!H$2:H$51))","v":539223.28299000009},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I34)*(Data!$C$2:$C$51=$H34)*(Data!I$2:I$51))","v":512262.11884050007},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I34)*(Data!$C$2:$C$51=$H34)*(Data!J$2:J$51))","v":486649.01289847505},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I34)*(Data!$C$2:$C$51=$H34)*(Data!K$2:K$51))","v":467183.05238253606},"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N34)*(Data!$O$2:$O$51=A34),0),0))","v":"Indiana"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O34)*(Data!$C$2:$C$51=N34)*(Data!$M$2:$M$51))","v":182.5},"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q34)*(Data!$R$2:$R$51=A34),0),0))","v":"Ohio"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R34)*(Data!$C$2:$C$51=Q34)*(Data!$L$2:$L$51))","v":7.4999999999999997E-2}]
[4,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B35)*(Data!$P$2:$P$51=A35),0),0))","v":"Michigan"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C35)*(Data!$C$2:$C$51=B35)*(Data!$D$2:$D$51))","v":452324.16000939999},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C35)*(Data!$C$2:$C$51=$B35)*(Data!E$2:E$51))","v":592101.57999999996},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C35)*(Data!$C$2:$C$51=$B35)*(Data!F$2:F$51))","v":574338.53259999992},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C35)*(Data!$C$2:$C$51=$B35)*(Data!G$2:G$51))","v":551364.99129599985},"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B35)*(Data!$Q$2:$Q$51=A35),0),0))","v":"Wisconsin"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I35)*(Data!$C$2:$C$51=$H35)*(Data!H$2:H$51))","v":265958.36722000001},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I35)*(Data!$C$2:$C$51=$H35)*(Data!I$2:I$51))","v":291224.4121059},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I35)*(Data!$C$2:$C$51=$H35)*(Data!J$2:J$51))","v":276663.19150060497},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I35)*(Data!$C$2:$C$51=$H35)*(Data!K$2:K$51))","v":302946.19469316246},"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N35)*(Data!$O$2:$O$51=A35),0),0))","v":"Michigan"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O35)*(Data!$C$2:$C$51=N35)*(Data!$M$2:$M$51))","v":174.8},"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q35)*(Data!$R$2:$R$51=A35),0),0))","v":"Indiana"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R35)*(Data!$C$2:$C$51=Q35)*(Data!$L$2:$L$51))","v":7.4999999999999997E-2}]
[5,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B36)*(Data!$P$2:$P$51=A36),0),0))","v":"Wisconsin"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C36)*(Data!$C$2:$C$51=B36)*(Data!$D$2:$D$51))","v":324556.11609299999},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C36)*(Data!$C$2:$C$51=$B36)*(Data!E$2:E$51))","v":414980.33},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C36)*(Data!$C$2:$C$51=$B36)*(Data!F$2:F$51))","v":454403.46135},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C36)*(Data!$C$2:$C$51=$B36)*(Data!G$2:G$51))","v":468035.5651905},"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B36)*(Data!$Q$2:$Q$51=A36),0),0))","v":"Indiana"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I36)*(Data!$C$2:$C$51=$H36)*(Data!H$2:H$51))","v":302491.10996999999},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I36)*(Data!$C$2:$C$51=$H36)*(Data!I$2:I$51))","v":287366.55447149999},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I36)*(Data!$C$2:$C$51=$H36)*(Data!J$2:J$51))","v":272998.22674792499},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I36)*(Data!$C$2:$C$51=$H36)*(Data!K$2:K$51))","v":264808.27994548721},"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N36)*(Data!$O$2:$O$51=A36),0),0))","v":"Wisconsin"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O36)*(Data!$C$2:$C$51=N36)*(Data!$M$2:$M$51))","v":105.2},"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q36)*(Data!$R$2:$R$51=A36),0),0))","v":"Missouri"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R36)*(Data!$C$2:$C$51=Q36)*(Data!$L$2:$L$51))","v":6.5000000000000002E-2}]
[6,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B37)*(Data!$P$2:$P$51=A37),0),0))","v":"Indiana"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C37)*(Data!$C$2:$C$51=B37)*(Data!$D$2:$D$51))","v":400736.402352},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C37)*(Data!$C$2:$C$51=$B37)*(Data!E$2:E$51))","v":512385.12},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C37)*(Data!$C$2:$C$51=$B37)*(Data!F$2:F$51))","v":486765.864},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C37)*(Data!$C$2:$C$51=$B37)*(Data!G$2:G$51))","v":462427.57079999999},"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B37)*(Data!$Q$2:$Q$51=A37),0),0))","v":"Missouri"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I37)*(Data!$C$2:$C$51=$H37)*(Data!H$2:H$51))","v":279110.15461000003},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I37)*(Data!$C$2:$C$51=$H37)*(Data!I$2:I$51))","v":267945.7484256},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I37)*(Data!$C$2:$C$51=$H37)*(Data!J$2:J$51))","v":259907.375972832},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I37)*(Data!$C$2:$C$51=$H37)*(Data!K$2:K$51))","v":246912.0071741904},"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N37)*(Data!$O$2:$O$51=A37),0),0))","v":"Missouri"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O37)*(Data!$C$2:$C$51=N37)*(Data!$M$2:$M$51))","v":87.26},"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q37)*(Data!$R$2:$R$51=A37),0),0))","v":"Wisconsin"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R37)*(Data!$C$2:$C$51=Q37)*(Data!$L$2:$L$51))","v":6.5000000000000002E-2}]
[7,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B38)*(Data!$P$2:$P$51=A38),0),0))","v":"Missouri"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C38)*(Data!$C$2:$C$51=B38)*(Data!$D$2:$D$51))","v":378640.00478700001},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C38)*(Data!$C$2:$C$51=$B38)*(Data!E$2:E$51))","v":484132.47},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C38)*(Data!$C$2:$C$51=$B38)*(Data!F$2:F$51))","v":464767.17119999998},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C38)*(Data!$C$2:$C$51=$B38)*(Data!G$2:G$51))","v":450824.15606399998},"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B38)*(Data!$Q$2:$Q$51=A38),0),0))","v":"Minnesota"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I38)*(Data!$C$2:$C$51=$H38)*(Data!H$2:H$51))","v":248422.65070000003},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I38)*(Data!$C$2:$C$51=$H38)*(Data!I$2:I$51))","v":255875.33022100004},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I38)*(Data!$C$2:$C$51=$H38)*(Data!J$2:J$51))","v":243081.56370995002},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I38)*(Data!$C$2:$C$51=$H38)*(Data!K$2:K$51))","v":230927.4855244525},"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N38)*(Data!$O$2:$O$51=A38),0),0))","v":"Minnesota"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O38)*(Data!$C$2:$C$51=N38)*(Data!$M$2:$M$51))","v":67.14},"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q38)*(Data!$R$2:$R$51=A38),0),0))","v":"Kansas"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R38)*(Data!$C$2:$C$51=Q38)*(Data!$L$2:$L$51))","v":5.5999999999999994E-2}]
[8,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B39)*(Data!$P$2:$P$51=A39),0),0))","v":"Kansas"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C39)*(Data!$C$2:$C$51=B39)*(Data!$D$2:$D$51))","v":169585.52932999999},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C39)*(Data!$C$2:$C$51=$B39)*(Data!E$2:E$51))","v":219046.15},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C39)*(Data!$C$2:$C$51=$B39)*(Data!F$2:F$51))","v":225617.53450000001},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C39)*(Data!$C$2:$C$51=$B39)*(Data!G$2:G$51))","v":232386.06053500003},"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B39)*(Data!$Q$2:$Q$51=A39),0),0))","v":"Iowa"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I39)*(Data!$C$2:$C$51=$H39)*(Data!H$2:H$51))","v":141747.04186999999},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I39)*(Data!$C$2:$C$51=$H39)*(Data!I$2:I$51))","v":145999.45312609998},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I39)*(Data!$C$2:$C$51=$H39)*(Data!J$2:J$51))","v":150379.43671988297},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I39)*(Data!$C$2:$C$51=$H39)*(Data!K$2:K$51))","v":144364.25925108764},"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N39)*(Data!$O$2:$O$51=A39),0),0))","v":"Iowa"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O39)*(Data!$C$2:$C$51=N39)*(Data!$M$2:$M$51))","v":54.81},"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q39)*(Data!$R$2:$R$51=A39),0),0))","v":"Minnesota"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R39)*(Data!$C$2:$C$51=Q39)*(Data!$L$2:$L$51))","v":4.8000000000000001E-2}]
[9,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B40)*(Data!$P$2:$P$51=A40),0),0))","v":"Iowa"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C40)*(Data!$C$2:$C$51=B40)*(Data!$D$2:$D$51))","v":145190.34023200002},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C40)*(Data!$C$2:$C$51=$B40)*(Data!E$2:E$51))","v":187535.96},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C40)*(Data!$C$2:$C$51=$B40)*(Data!F$2:F$51))","v":193162.03880000001},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C40)*(Data!$C$2:$C$51=$B40)*(Data!G$2:G$51))","v":198956.89996400001},"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B40)*(Data!$Q$2:$Q$51=A40),0),0))","v":"Kansas"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I40)*(Data!$C$2:$C$51=$H40)*(Data!H$2:H$51))","v":132979.18361000001},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I40)*(Data!$C$2:$C$51=$H40)*(Data!I$2:I$51))","v":136968.55911830001},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I40)*(Data!$C$2:$C$51=$H40)*(Data!J$2:J$51))","v":141077.61589184901},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I40)*(Data!$C$2:$C$51=$H40)*(Data!K$2:K$51))","v":112862.09271347921},"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N40)*(Data!$O$2:$O$51=A40),0),0))","v":"Kansas"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O40)*(Data!$C$2:$C$51=N40)*(Data!$M$2:$M$51))","v":35.090000000000003},"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q40)*(Data!$R$2:$R$51=A40),0),0))","v":"Iowa"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R40)*(Data!$C$2:$C$51=Q40)*(Data!$L$2:$L$51))","v":4.5999999999999999E-2}]
[10,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B41)*(Data!$P$2:$P$51=A41),0),0))","v":"Nebraska"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C41)*(Data!$C$2:$C$51=B41)*(Data!$D$2:$D$51))","v":153254.85646800001},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C41)*(Data!$C$2:$C$51=$B41)*(Data!E$2:E$51))","v":197952.54},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C41)*(Data!$C$2:$C$51=$B41)*(Data!F$2:F$51))","v":188054.913},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$C41)*(Data!$C$2:$C$51=$B41)*(Data!G$2:G$51))","v":178652.16735},"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B41)*(Data!$Q$2:$Q$51=A41),0),0))","v":"Nebraska"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I41)*(Data!$C$2:$C$51=$H41)*(Data!H$2:H$51))","v":84755.963180000006},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I41)*(Data!$C$2:$C$51=$H41)*(Data!I$2:I$51))","v":80518.165021000008},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I41)*(Data!$C$2:$C$51=$H41)*(Data!J$2:J$51))","v":76492.256769950007},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=$I41)*(Data!$C$2:$C$51=$H41)*(Data!K$2:K$51))","v":72667.643931452505},"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N41)*(Data!$O$2:$O$51=A41),0),0))","v":"Nebraska"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O41)*(Data!$C$2:$C$51=N41)*(Data!$M$2:$M$51))","v":23.97},"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=Q41)*(Data!$R$2:$R$51=A41),0),0))","v":"Nebraska"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=R41)*(Data!$C$2:$C$51=Q41)*(Data!$L$2:$L$51))","v":3.9E-2}]
[1,"All Regions",{"$f":"INDEX(C$2:C$41,MATCH(VLOOKUP(LARGE(G$2:G$41,A42),G$2:G$41,1,0),G$2:G$41,0),1)","v":"California"},{"$f":"SUMPRODUCT((($C$2:$C$41=$C42)*(D$2:D$41)))","v":1787984.7286865602},{"$f":"SUMPRODUCT((($C$2:$C$41=$C42)*(E$2:E$41)))","v":2340508.5920000002},2410723.8497600006,2483045.5652528009,"All Regions",{"$f":"INDEX(I$2:I$41,MATCH(VLOOKUP(LARGE(M$2:M$41,A42),M$2:M$41,1,0),M$2:M$41,0),1)","v":"California"},{"$f":"SUMPRODUCT((($I$2:$I$41=$I42)*(J$2:J$41)))","v":1089787.0131937501},{"$f":"SUMPRODUCT((($I$2:$I$41=$I42)*(K$2:K$41)))","v":1122480.6235895625},1156155.0422972494,1167716.592720222,"All Regions",{"$f":"INDEX(O$2:O$41,MATCH(VLOOKUP(LARGE(P$2:P$41,$A42),P$2:P$41,1,0),P$2:P$41,0),1)","v":"Massachusetts"},{"$f":"VLOOKUP(LARGE(P$2:P$41,$A42),P$2:P$41,1,0)","v":852.1},"All Regions",{"$f":"INDEX(R$2:R$41,MATCH(VLOOKUP(LARGE(S$2:S$41,$A42),S$2:S$41,1,0),S$2:S$41,0),1)","v":"Nevada"},{"$f":"VLOOKUP(LARGE(S$2:S$41,A42),S$2:S$41,1,0)","v":9.3000000000000013E-2}]
[2,"All Regions",{"$f":"INDEX(C$2:C$41,MATCH(VLOOKUP(LARGE(G$2:G$41,A43),G$2:G$41,1,0),G$2:G$41,0),1)","v":"Texas"},{"$f":"SUMPRODUCT((($C$2:$C$41=$C43)*(D$2:D$41)))","v":1676519.8460053997},2194598.7799999998,2084868.8409999998,2147414.9062299998,"All Regions",{"$f":"INDEX(I$2:I$41,MATCH(VLOOKUP(LARGE(M$2:M$41,A43),M$2:M$41,1,0),M$2:M$41,0),1)","v":"Texas"},{"$f":"SUMPRODUCT((($I$2:$I$41=$I43)*(J$2:J$41)))","v":1174893.0068399999},1116148.356498,1149632.80719294,1161129.1352648695,"All Regions","Connecticut",741.4,"All Regions","Rhode Island",9.1999999999999998E-2]
[3,"All Regions","New York",1536782.3509922,2011679.54,1911095.5629999998,2044872.25241,"All Regions","New York",904550.71048999997,859323.1749654999,919475.797213085,928670.5551852159,"All Regions","Maryland",606.20000000000005,"All Regions","Michigan",0.09]
[4,"All Regions","Illinois",950567.47242110013,1244312.27,1182096.6565,1264843.4224550002,"All Regions","Florida",878247.13570999994,834334.77892449987,892738.21344921493,901665.59558370709,"All Regions","Delaware",470.7,"All Regions","Illinois",8.900000000000001E-2]
[5,"All Regions","Florida",933901.63665550016,1222496.3500000001,1161371.5325,1242667.539775,"All Regions","Illinois",599136.98109999998,569180.13204499998,609022.74128814996,666879.90171052422,"All Regions","New York",415.3,"All Regions","California",8.6999999999999994E-2]
[6,"All Regions","New Jersey",871083.34928999993,1113774.8999999999,1058086.1549999998,1158604.3397249999,"All Regions","Washington",628363.1753,596945.01653499994,638731.16769244999,606794.60930782743,"All Regions","Florida",360.2,"All Regions","Mississippi",8.5000000000000006E-2]
[7,"All Regions","Pennsylvania",832389.70153949992,1089615.1499999999,1035134.3924999998,1107593.7999749999,"All Regions","Pennsylvania",593291.74225999997,563627.15514699998,603081.05600729003,482464.84480583202,"All Regions","Pennsylvania",285.3,"All Regions","Tennessee",8.4000000000000005E-2]
[8,"All Regions","Washington",820326.88940400002,1048877.24,996433.37799999991,1066183.7144599999,"All Regions","Michigan",461773.86836000008,447920.65230920009,430003.82621683209,470854.18970743113,"All Regions","Ohio",282.5,"All Regions","Tennessee",8.4000000000000005E-2]
[9,"All Regions","Ohio",848682.50264680013,1110942.76,1055395.622,1002625.8409,"All Regions","Ohio",539223.28299000009,512262.11884050007,486649.01289847505,467183.05238253606,"All Regions","California",244.2,"All Regions","Tennessee",8.4000000000000005E-2]
[10,"All Regions","Colorado",645274.74904200004,825054.02,849805.64060000004,807315.35857000004,"All Regions","Arizona",596214.36167999997,614100.79253039998,583395.75290387997,466716.60232310399,"All Regions","Illinois",231.9,"All Regions","Arizona",8.199999999999999E-2]
[]
["Table & Chart","Region","State",2010,2011,2012,2013,"Region","State",2010,2011,2012,2013,"Region","Staff","FTE","Region","State","Late Debt",null,"Revenue",{"$f":"Dash!$B$1","v":2010},"Expenses",{"$f":"Dash!$B$1","v":2010},"Chart 1"]
[1,{"$f":"Dash!$T$11","v":"The Mid-West"},{"$f":"INDEX(C$2:C$51,MATCH(1,INDEX(($A$2:$A$51=$A54)*(B$2:B$51=B54),0),0))","v":"Illinois"},{"$f":"SUMPRODUCT(($B$2:$B$51=$B54)*($C$2:$C$51=$C54)*(D$2:D$51))/1000","v":950.56747242110009},1244.3122700000001,1182.0966565000001,{"$f":"SUMPRODUCT(($B$2:$B$51=$B54)*($C$2:$C$51=$C54)*(G$2:G$51))/1000","v":1264.8434224550003},{"$f":"Dash!$T$11","v":"The Mid-West"},{"$f":"INDEX(I$2:I$51,MATCH(1,INDEX(($A$2:$A$51=$A54)*(H$2:H$51=H54),0),0))","v":"Illinois"},{"$f":"SUMPRODUCT(($H$2:$H$51=$H54)*($I$2:$I$51=$I54)*(J$2:J$51))/1000","v":599.13698109999996},{"$f":"SUMPRODUCT(($H$2:$H$51=$H54)*($I$2:$I$51=$I54)*(K$2:K$51))/1000","v":569.18013204499994},609.02274128814997,666.87990171052422,{"$f":"$B54","v":"The Mid-West"},{"$f":"INDEX(O$2:O$51,MATCH(1,INDEX(($A$2:$A$51=$A54)*(N$2:N$51=N54),0),0))","v":"Ohio"},{"$f":"SUMPRODUCT((N$2:N$51=N54)*(O$2:O$51=O54)*(P$2:P$51))","v":282.5},{"$f":"$B54","v":"The Mid-West"},{"$f":"INDEX(R$2:R$51,MATCH(1,INDEX(($A$2:$A$51=$A54)*(Q$2:Q$51=Q54),0),0))","v":"Michigan"},{"$f":"SUMPRODUCT((Q$2:Q$51=Q54)*(R$2:R$51=R54)*(S$2:S$51))","v":0.09},null,{"$f":"C54","v":"Illinois"},{"$f":"HLOOKUP(Dash!$B$1,$D$53:$G$58,ROW(A2),0)","v":950.56747242110009},{"$f":"I54","v":"Illinois"},{"$f":"HLOOKUP(Dash!$B$1,$J$53:$M$58,ROW(A2),0)","v":599.13698109999996}]
[2,{"$f":"Dash!$T$11","v":"The Mid-West"},{"$f":"INDEX(C$2:C$51,MATCH(1,INDEX(($A$2:$A$51=$A55)*(B$2:B$51=B55),0),0))","v":"Ohio"},848.68250264680012,1110.9427599999999,1055.395622,{"$f":"SUMPRODUCT(($B$2:$B$51=$B55)*($C$2:$C$51=$C55)*(G$2:G$51))/1000","v":1002.6258409},{"$f":"Dash!$T$11","v":"The Mid-West"},{"$f":"INDEX(I$2:I$51,MATCH(1,INDEX(($A$2:$A$51=$A55)*(H$2:H$51=H55),0),0))","v":"Michigan"},{"$f":"SUMPRODUCT(($H$2:$H$51=$H55)*($I$2:$I$51=$I55)*(J$2:J$51))/1000","v":461.77386836000011},447.92065230920008,430.00382621683207,470.85418970743115,{"$f":"$B55","v":"The Mid-West"},{"$f":"INDEX(O$2:O$51,MATCH(1,INDEX(($A$2:$A$51=$A55)*(N$2:N$51=N55),0),0))","v":"Illinois"},{"$f":"SUMPRODUCT((N$2:N$51=N55)*(O$2:O$51=O55)*(P$2:P$51))","v":231.9},{"$f":"$B55","v":"The Mid-West"},{"$f":"INDEX(R$2:R$51,MATCH(1,INDEX(($A$2:$A$51=$A55)*(Q$2:Q$51=Q55),0),0))","v":"Illinois"},{"$f":"SUMPRODUCT((Q$2:Q$51=Q55)*(R$2:R$51=R55)*(S$2:S$51))","v":8.900000000000001E-2},null,{"$f":"C55","v":"Ohio"},{"$f":"HLOOKUP(Dash!$B$1,$D$53:$G$58,ROW(A3),0)","v":848.68250264680012},{"$f":"I55","v":"Michigan"},{"$f":"HLOOKUP(Dash!$B$1,$J$53:$M$58,ROW(A3),0)","v":461.77386836000011}]
[3,{"$f":"Dash!$T$11","v":"The Mid-West"},{"$f":"INDEX(C$2:C$51,MATCH(1,INDEX(($A$2:$A$51=$A56)*(B$2:B$51=B56),0),0))","v":"Minnesota"},615.39852904199995,786.85401999999999,810.45964060000006,769.93665856999996,{"$f":"Dash!$T$11","v":"The Mid-West"},"Ohio",{"$f":"SUMPRODUCT(($H$2:$H$51=$H56)*($I$2:$I$51=$I56)*(J$2:J$51))/1000","v":539.22328299000014},512.26211884050008,486.64901289847506,467.18305238253606,{"$f":"$B56","v":"The Mid-West"},{"$f":"INDEX(O$2:O$51,MATCH(1,INDEX(($A$2:$A$51=$A56)*(N$2:N$51=N56),0),0))","v":"Indiana"},{"$f":"SUMPRODUCT((N$2:N$51=N56)*(O$2:O$51=O56)*(P$2:P$51))","v":182.5},{"$f":"$B56","v":"The Mid-West"},{"$f":"INDEX(R$2:R$51,MATCH(1,INDEX(($A$2:$A$51=$A56)*(Q$2:Q$51=Q56),0),0))","v":"Ohio"},{"$f":"SUMPRODUCT((Q$2:Q$51=Q56)*(R$2:R$51=R56)*(S$2:S$51))","v":7.4999999999999997E-2},null,"Minnesota",{"$f":"HLOOKUP(Dash!$B$1,$D$53:$G$58,ROW(A4),0)","v":615.39852904199995},{"$f":"I56","v":"Ohio"},{"$f":"HLOOKUP(Dash!$B$1,$J$53:$M$58,ROW(A4),0)","v":539.22328299000014}]
[4,{"$f":"Dash!$T$11","v":"The Mid-West"},{"$f":"INDEX(C$2:C$51,MATCH(1,INDEX(($A$2:$A$51=$A57)*(B$2:B$51=B57),0),0))","v":"Michigan"},452.32416000939998,592.10158000000001,574.33853259999989,551.36499129599986,{"$f":"Dash!$T$11","v":"The Mid-West"},"Wisconsin",{"$f":"SUMPRODUCT(($H$2:$H$51=$H57)*($I$2:$I$51=$I57)*(J$2:J$51))/1000","v":265.95836722000001},291.2244121059,276.66319150060497,302.94619469316245,{"$f":"$B57","v":"The Mid-West"},{"$f":"INDEX(O$2:O$51,MATCH(1,INDEX(($A$2:$A$51=$A57)*(N$2:N$51=N57),0),0))","v":"Michigan"},{"$f":"SUMPRODUCT((N$2:N$51=N57)*(O$2:O$51=O57)*(P$2:P$51))","v":174.8},{"$f":"$B57","v":"The Mid-West"},{"$f":"INDEX(R$2:R$51,MATCH(1,INDEX(($A$2:$A$51=$A57)*(Q$2:Q$51=Q57),0),0))","v":"Indiana"},{"$f":"SUMPRODUCT((Q$2:Q$51=Q57)*(R$2:R$51=R57)*(S$2:S$51))","v":7.4999999999999997E-2},null,"Michigan",{"$f":"HLOOKUP(Dash!$B$1,$D$53:$G$58,ROW(A5),0)","v":452.32416000939998},{"$f":"I57","v":"Wisconsin"},{"$f":"HLOOKUP(Dash!$B$1,$J$53:$M$58,ROW(A5),0)","v":265.95836722000001}]
[5,{"$f":"Dash!$T$11","v":"The Mid-West"},{"$f":"INDEX(C$2:C$51,MATCH(1,INDEX(($A$2:$A$51=$A58)*(B$2:B$51=B58),0),0))","v":"Wisconsin"},324.55611609300001,414.98033000000004,454.40346134999999,468.03556519049999,{"$f":"Dash!$T$11","v":"The Mid-West"},"Indiana",{"$f":"SUMPRODUCT(($H$2:$H$51=$H58)*($I$2:$I$51=$I58)*(J$2:J$51))/1000","v":302.49110996999997},287.36655447149997,272.998226747925,264.80827994548724,{"$f":"$B58","v":"The Mid-West"},{"$f":"INDEX(O$2:O$51,MATCH(1,INDEX(($A$2:$A$51=$A58)*(N$2:N$51=N58),0),0))","v":"Wisconsin"},{"$f":"SUMPRODUCT((N$2:N$51=N58)*(O$2:O$51=O58)*(P$2:P$51))","v":105.2},{"$f":"$B58","v":"The Mid-West"},{"$f":"INDEX(R$2:R$51,MATCH(1,INDEX(($A$2:$A$51=$A58)*(Q$2:Q$51=Q58),0),0))","v":"Missouri"},{"$f":"SUMPRODUCT((Q$2:Q$51=Q58)*(R$2:R$51=R58)*(S$2:S$51))","v":6.5000000000000002E-2},null,"Wisconsin",{"$f":"HLOOKUP(Dash!$B$1,$D$53:$G$58,ROW(A6),0)","v":324.55611609300001},{"$f":"I58","v":"Indiana"},{"$f":"HLOOKUP(Dash!$B$1,$J$53:$M$58,ROW(A6),0)","v":302.49110996999997}]
[]
["Top 10 All Regions","Region","State",2010,2011,2012,2013,"Region","State",2010,2011,2012,2013,null,null,null,null,null,null,null,"Revenue",{"$f":"Dash!$B$1","v":2010},"Expenses",{"$f":"Dash!$B$1","v":2010},"Chart 2"]
[1,{"$f":"Dash!$T$11","v":"The Mid-West"},{"$f":"INDEX(C$2:C$51,MATCH(1,INDEX(($A$2:$A$51=$A61)*(B$2:B$51=B61),0),0))","v":"Illinois"},{"$f":"SUMPRODUCT(($B$2:$B$51=$B61)*($C$2:$C$51=$C61)*(D$2:D$51))/1000","v":950.56747242110009},1244.3122700000001,1182.0966565000001,{"$f":"SUMPRODUCT(($B$2:$B$51=$B61)*($C$2:$C$51=$C61)*(G$2:G$51))/1000","v":1264.8434224550003},"All Regions",{"$f":"INDEX(I$2:I$51,MATCH(1,INDEX(($A$2:$A$51=$A61)*(H$2:H$51=H61),0),0))","v":"California"},{"$f":"SUMPRODUCT(($B$2:$B$51=$B61)*($C$2:$C$51=$C61)*(J$2:J$51))/1000","v":599.13698109999996},{"$f":"SUMPRODUCT(($B$2:$B$51=$B61)*($C$2:$C$51=$C61)*(K$2:K$51))/1000","v":569.18013204499994},609.02274128814997,{"$f":"SUMPRODUCT(($B$2:$B$51=$B61)*($C$2:$C$51=$C61)*(M$2:M$51))/1000","v":666.87990171052422},{"$f":"$B61","v":"The Mid-West"},{"$f":"INDEX(O$2:O$51,MATCH(1,INDEX(($A$2:$A$51=$A61)*(N$2:N$51=N61),0),0))","v":"Ohio"},{"$f":"SUMPRODUCT((N$2:N$51=N61)*(O$2:O$51=O61)*(P$2:P$51))","v":282.5},{"$f":"$B61","v":"The Mid-West"},{"$f":"INDEX(R$2:R$51,MATCH(1,INDEX(($A$2:$A$51=$A61)*(Q$2:Q$51=Q61),0),0))","v":"Michigan"},{"$f":"SUMPRODUCT((Q$2:Q$51=Q61)*(R$2:R$51=R61)*(S$2:S$51))","v":0.09},null,{"$f":"C61","v":"Illinois"},{"$f":"HLOOKUP(Dash!$B$1,$D$60:$G$70,ROW(A2),0)","v":950.56747242110009},{"$f":"I61","v":"California"},{"$f":"HLOOKUP(Dash!$B$1,$J$60:$M$70,ROW(A2),0)","v":599.13698109999996}]
[2,{"$f":"Dash!$T$11","v":"The Mid-West"},"Ohio",848.68250264680012,1110.9427599999999,1055.395622,{"$f":"SUMPRODUCT(($B$2:$B$51=$B62)*($C$2:$C$51=$C62)*(G$2:G$51))/1000","v":1002.6258409},"All Regions",{"$f":"INDEX(I$2:I$51,MATCH(1,INDEX(($A$2:$A$51=$A62)*(H$2:H$51=H62),0),0))","v":"Texas"},{"$f":"SUMPRODUCT(($B$2:$B$51=$B62)*($C$2:$C$51=$C62)*(J$2:J$51))/1000","v":461.77386836000011},447.92065230920008,430.00382621683207,470.85418970743115,"The Mid-West","Illinois",231.9,"The Mid-West","Illinois",8.900000000000001E-2,null,{"$f":"C62","v":"Ohio"},{"$f":"HLOOKUP(Dash!$B$1,$D$60:$G$70,ROW(A3),0)","v":848.68250264680012},{"$f":"I62","v":"Texas"},{"$f":"HLOOKUP(Dash!$B$1,$J$60:$M$70,ROW(A3),0)","v":461.77386836000011}]
[3,{"$f":"Dash!$T$11","v":"The Mid-West"},"Minnesota",615.39852904199995,786.85401999999999,810.45964060000006,769.93665856999996,"All Regions","New York",539.22328299000014,512.26211884050008,486.64901289847506,467.18305238253606,"The Mid-West","Indiana",182.5,"The Mid-West","Ohio",7.4999999999999997E-2,null,"Minnesota",{"$f":"HLOOKUP(Dash!$B$1,$D$60:$G$70,ROW(A4),0)","v":615.39852904199995},"New York",{"$f":"HLOOKUP(Dash!$B$1,$J$60:$M$70,ROW(A4),0)","v":539.22328299000014}]
[4,{"$f":"Dash!$T$11","v":"The Mid-West"},"Michigan",452.32416000939998,592.10158000000001,574.33853259999989,551.36499129599986,"All Regions","Florida",265.95836722000001,291.2244121059,276.66319150060497,302.94619469316245,"The Mid-West","Michigan",174.8,"The Mid-West","Indiana",7.4999999999999997E-2,null,"Michigan",{"$f":"HLOOKUP(Dash!$B$1,$D$60:$G$70,ROW(A5),0)","v":452.32416000939998},"Florida",{"$f":"HLOOKUP(Dash!$B$1,$J$60:$M$70,ROW(A5),0)","v":265.95836722000001}]
[5,{"$f":"Dash!$T$11","v":"The Mid-West"},"Wisconsin",324.55611609300001,414.98033000000004,454.40346134999999,468.03556519049999,"All Regions","Illinois",302.49110996999997,287.36655447149997,272.998226747925,264.80827994548724,"The Mid-West","Wisconsin",105.2,"The Mid-West","Missouri",6.5000000000000002E-2,null,"Wisconsin",{"$f":"HLOOKUP(Dash!$B$1,$D$60:$G$70,ROW(A6),0)","v":324.55611609300001},"Illinois",{"$f":"HLOOKUP(Dash!$B$1,$J$60:$M$70,ROW(A6),0)","v":302.49110996999997}]
[6,{"$f":"Dash!$T$11","v":"The Mid-West"},"Indiana",400.73640235200003,512.38512000000003,486.76586400000002,462.42757080000001,"All Regions","Washington",279.11015461000005,267.94574842560002,259.90737597283203,246.91200717419039,"The Mid-West","Missouri",87.26,"The Mid-West","Wisconsin",6.5000000000000002E-2,null,"Indiana",{"$f":"HLOOKUP(Dash!$B$1,$D$60:$G$70,ROW(A7),0)","v":400.73640235200003},"Washington",{"$f":"HLOOKUP(Dash!$B$1,$J$60:$M$70,ROW(A7),0)","v":279.11015461000005}]
[7,{"$f":"Dash!$T$11","v":"The Mid-West"},"Missouri",378.64000478700001,484.13246999999996,464.76717120000001,450.82415606399996,"All Regions","Pennsylvania",248.42265070000002,255.87533022100004,243.08156370995002,230.92748552445249,"The Mid-West","Minnesota",67.14,"The Mid-West","Kansas",5.5999999999999994E-2,null,"Missouri",{"$f":"HLOOKUP(Dash!$B$1,$D$60:$G$70,ROW(A8),0)","v":378.64000478700001},"Pennsylvania",{"$f":"HLOOKUP(Dash!$B$1,$J$60:$M$70,ROW(A8),0)","v":248.42265070000002}]
[8,{"$f":"Dash!$T$11","v":"The Mid-West"},"Kansas",169.58552932999999,219.04614999999998,225.6175345,232.38606053500001,"All Regions","Michigan",141.74704186999998,145.99945312609998,150.37943671988296,144.36425925108765,"The Mid-West","Iowa",54.81,"The Mid-West","Minnesota",4.8000000000000001E-2,null,"Kansas",{"$f":"HLOOKUP(Dash!$B$1,$D$60:$G$70,ROW(A9),0)","v":169.58552932999999},"Michigan",{"$f":"HLOOKUP(Dash!$B$1,$J$60:$M$70,ROW(A9),0)","v":141.74704186999998}]
[9,{"$f":"Dash!$T$11","v":"The Mid-West"},"Iowa",145.19034023200001,187.53595999999999,193.1620388,198.956899964,"All Regions","Ohio",132.97918361000001,136.96855911829999,141.07761589184901,112.86209271347921,"The Mid-West","Kansas",35.090000000000003,"The Mid-West","Iowa",4.5999999999999999E-2,null,"Iowa",{"$f":"HLOOKUP(Dash!$B$1,$D$60:$G$70,ROW(A10),0)","v":145.19034023200001},"Ohio",{"$f":"HLOOKUP(Dash!$B$1,$J$60:$M$70,ROW(A10),0)","v":132.97918361000001}]
[10,{"$f":"Dash!$T$11","v":"The Mid-West"},"Nebraska",153.25485646800001,197.95254,188.054913,178.65216735000001,"All Regions","Arizona",84.755963180000009,80.518165021000002,76.492256769950004,72.667643931452503,"The Mid-West","Nebraska",23.97,"The Mid-West","Nebraska",3.9E-2,null,"Nebraska",{"$f":"HLOOKUP(Dash!$B$1,$D$60:$G$70,ROW(A11),0)","v":153.25485646800001},"Arizona",{"$f":"HLOOKUP(Dash!$B$1,$J$60:$M$70,ROW(A11),0)","v":84.755963180000009}]
[]
[null,null,"Revenue",2010,2011,2012,2013,null,"Expenses",2010,2011,2012,2013,null,{"$f":"Dash!B1","v":2010}]
[null,{"$f":"Dash!$T$11","v":"The Mid-West"},null,{"$f":"SUM(D61:D70)","v":4438.9359133813005},{"$f":"SUM(E61:E70)","v":5750.2431999999999},5635.0614345499998,5580.0533331244997,{"$f":"Dash!$T$11","v":"The Mid-West"},null,{"$f":"SUM(J61:J70)","v":3055.5986036099994},{"$f":"SUM(K61:K70)","v":2995.2611256841005},2946.2752477164508,2980.4051070338037,"Expenses",{"$f":"HLOOKUP(O72,$J$72:$M$74,3,0)","v":0.40771025827988011}]
[null,{"$f":"Dash!$T$11","v":"The Mid-West"},null,{"$f":"D73/(D73+J73)","v":0.59228974172011994},{"$f":"E73/(E73+K73)","v":0.65750847359511178},0.65666476484893044,0.65184047935420042,{"$f":"Dash!$T$11","v":"The Mid-West"},null,{"$f":"J73/(D73+J73)","v":0.40771025827988011},{"$f":"K73/(E73+K73)","v":0.34249152640488828},0.34333523515106956,0.34815952064579953,"Revenue",{"$f":"HLOOKUP(O72,$D$72:$G$74,3,0)","v":0.59228974172011994}]
[]
[null,"Region",null,2010,2011,2012,2013,"Region",null,2010,2011,2012,2013]
[null,"The West",null,{"$f":"SUMIF($B$2:$B$41,$B77,D$2:D$41)/1000","v":5174.6604741725596},6641.0682019999986,6679.4252021599996,6710.2425834908008,"The West",null,{"$f":"SUMIF($B$2:$B$41,$H77,J$2:J$41)/1000","v":3394.2724258637504},3412.7694124269128,3463.3208988355605,3300.929650547735]
[null,"The South",null,5325.9360558605022,6923.9956899999997,6699.3231474999993,6862.5745371044995,"The South",null,4449.6880669499997,4335.055626749051,4388.6344742007141,4380.385258868404]
[null,"The North-East",null,4992.4280711837,6445.6826899999987,6222.3742481999998,6617.7259958975001,"The North-East",null,2865.6283413099995,2765.7039833402005,2940.5216329952682,2777.8618813892795]
[null,"The Mid-West",null,4438.9359133813005,5750.2431999999999,5635.0614345499998,5580.0533331244997,"The Mid-West",null,3055.5986036100007,2995.2611256841001,2946.2752477164508,2980.4051070338032]
[]
[null,"Country","Year","Facebook","Twitter","Google +","Linkedin","YouTube","Page Views","Avg Visitors Per Day","Average Visit Duration","Returning Visitors"]
[null,{"$f":"Dash!$T$32","v":"Australia"},2010,{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B88)*(SocialData!$B$2:$B$81=$C88)*(SocialData!C$2:C$81))","v":581.80000000000007},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B83)*(SocialData!$B$2:$B$81=$C83)*(SocialData!D$2:D$81))","v":494},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B83)*(SocialData!$B$2:$B$81=$C83)*(SocialData!E$2:E$81))","v":666},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B83)*(SocialData!$B$2:$B$81=$C83)*(SocialData!F$2:F$81))","v":486},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B83)*(SocialData!$B$2:$B$81=$C83)*(SocialData!G$2:G$81))","v":989},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B83)*(SocialData!$B$2:$B$81=$C83)*(SocialData!H$2:H$81))","v":5323},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B83)*(SocialData!$B$2:$B$81=$C83)*(SocialData!I$2:I$81))","v":14},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B83)*(SocialData!$B$2:$B$81=$C83)*(SocialData!J$2:J$81))","v":2.0299999999999998},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B83)*(SocialData!$B$2:$B$81=$C83)*(SocialData!K$2:K$81))","v":3140}]
[null,{"$f":"Dash!$T$32","v":"Australia"},2011,{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B84)*(SocialData!$B$2:$B$81=$C84)*(SocialData!C$2:C$81))","v":596},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B84)*(SocialData!$B$2:$B$81=$C84)*(SocialData!D$2:D$81))","v":516},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B84)*(SocialData!$B$2:$B$81=$C84)*(SocialData!E$2:E$81))","v":675},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B84)*(SocialData!$B$2:$B$81=$C84)*(SocialData!F$2:F$81))","v":522},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B84)*(SocialData!$B$2:$B$81=$C84)*(SocialData!G$2:G$81))","v":1003},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B84)*(SocialData!$B$2:$B$81=$C84)*(SocialData!H$2:H$81))","v":5453},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B84)*(SocialData!$B$2:$B$81=$C84)*(SocialData!I$2:I$81))","v":14},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B84)*(SocialData!$B$2:$B$81=$C84)*(SocialData!J$2:J$81))","v":1.9999999999999998},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B84)*(SocialData!$B$2:$B$81=$C84)*(SocialData!K$2:K$81))","v":2126}]
[null,{"$f":"Dash!$T$32","v":"Australia"},2012,{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B85)*(SocialData!$B$2:$B$81=$C85)*(SocialData!C$2:C$81))","v":610},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B85)*(SocialData!$B$2:$B$81=$C85)*(SocialData!D$2:D$81))","v":539},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B85)*(SocialData!$B$2:$B$81=$C85)*(SocialData!E$2:E$81))","v":685},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B85)*(SocialData!$B$2:$B$81=$C85)*(SocialData!F$2:F$81))","v":561},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B85)*(SocialData!$B$2:$B$81=$C85)*(SocialData!G$2:G$81))","v":1018},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B85)*(SocialData!$B$2:$B$81=$C85)*(SocialData!H$2:H$81))","v":5581},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B85)*(SocialData!$B$2:$B$81=$C85)*(SocialData!I$2:I$81))","v":15},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B85)*(SocialData!$B$2:$B$81=$C85)*(SocialData!J$2:J$81))","v":1.9099999999999997},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B85)*(SocialData!$B$2:$B$81=$C85)*(SocialData!K$2:K$81))","v":1897}]
[null,{"$f":"Dash!$T$32","v":"Australia"},2013,{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B86)*(SocialData!$B$2:$B$81=$C86)*(SocialData!C$2:C$81))","v":494.53000000000003},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B86)*(SocialData!$B$2:$B$81=$C86)*(SocialData!D$2:D$81))","v":419.9},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B86)*(SocialData!$B$2:$B$81=$C86)*(SocialData!E$2:E$81))","v":566.1},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B86)*(SocialData!$B$2:$B$81=$C86)*(SocialData!F$2:F$81))","v":413.09999999999997},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B86)*(SocialData!$B$2:$B$81=$C86)*(SocialData!G$2:G$81))","v":840.65},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B86)*(SocialData!$B$2:$B$81=$C86)*(SocialData!H$2:H$81))","v":4524.55},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B86)*(SocialData!$B$2:$B$81=$C86)*(SocialData!I$2:I$81))","v":15},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B86)*(SocialData!$B$2:$B$81=$C86)*(SocialData!J$2:J$81))","v":1.8199999999999996},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B86)*(SocialData!$B$2:$B$81=$C86)*(SocialData!K$2:K$81))","v":3373}]
[]
[null,{"$f":"Dash!T32","v":"Australia"},2010,2011,2012,2013,null,"Search Engines",{"$f":"Dash!$B$1","v":2010}]
[null,"Facebook",{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B88)*(SocialData!$B$2:$B$81=C$88)*(SocialData!$C$2:$C$81))","v":581.80000000000007},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B88)*(SocialData!$B$2:$B$81=D$88)*(SocialData!$C$2:$C$81))","v":596},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B88)*(SocialData!$B$2:$B$81=E$88)*(SocialData!$C$2:$C$81))","v":610},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B88)*(SocialData!$B$2:$B$81=F$88)*(SocialData!$C$2:$C$81))","v":494.53000000000003},null,"Google",{"$f":"SUMIFS(SocialData!$N$2:$N$13,SocialData!$L$2:$L$13,$I$88,SocialData!$M$2:$M$13,H89)","v":0.6}]
[null,"Twitter",{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B$88)*(SocialData!$B$2:$B$81=C$88)*(SocialData!$D$2:$D$81))","v":494},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B$88)*(SocialData!$B$2:$B$81=D$88)*(SocialData!$D$2:$D$81))","v":516},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B$88)*(SocialData!$B$2:$B$81=E$88)*(SocialData!$D$2:$D$81))","v":539},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B$88)*(SocialData!$B$2:$B$81=F$88)*(SocialData!$D$2:$D$81))","v":419.9},null,"Bing",{"$f":"SUMIFS(SocialData!$N$2:$N$13,SocialData!$L$2:$L$13,$I$88,SocialData!$M$2:$M$13,H90)","v":0.26}]
[null,"Google +",{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B$88)*(SocialData!$B$2:$B$81=C$88)*(SocialData!$E$2:$E$81))","v":666},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B$88)*(SocialData!$B$2:$B$81=D$88)*(SocialData!$E$2:$E$81))","v":675},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B$88)*(SocialData!$B$2:$B$81=E$88)*(SocialData!$E$2:$E$81))","v":685},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B$88)*(SocialData!$B$2:$B$81=F$88)*(SocialData!$E$2:$E$81))","v":566.1},null,"Other",{"$f":"SUMIFS(SocialData!$N$2:$N$13,SocialData!$L$2:$L$13,$I$88,SocialData!$M$2:$M$13,H91)","v":0.14000000000000001}]
[null,"Linkedin",{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B$88)*(SocialData!$B$2:$B$81=C$88)*(SocialData!$F$2:$F$81))","v":486},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B$88)*(SocialData!$B$2:$B$81=D$88)*(SocialData!$F$2:$F$81))","v":522},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B$88)*(SocialData!$B$2:$B$81=E$88)*(SocialData!$F$2:$F$81))","v":561},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B$88)*(SocialData!$B$2:$B$81=F$88)*(SocialData!$F$2:$F$81))","v":413.09999999999997}]
[null,"YouTube",{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B$88)*(SocialData!$B$2:$B$81=C$88)*(SocialData!$G$2:$G$81))","v":989},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B$88)*(SocialData!$B$2:$B$81=D$88)*(SocialData!$G$2:$G$81))","v":1003},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B$88)*(SocialData!$B$2:$B$81=E$88)*(SocialData!$G$2:$G$81))","v":1018},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B$88)*(SocialData!$B$2:$B$81=F$88)*(SocialData!$G$2:$G$81))","v":840.65}]
[null,"Page Views",{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B$88)*(SocialData!$B$2:$B$81=C$88)*(SocialData!$H$2:$H$81))","v":5323},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B$88)*(SocialData!$B$2:$B$81=D$88)*(SocialData!$H$2:$H$81))","v":5453},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B$88)*(SocialData!$B$2:$B$81=E$88)*(SocialData!$H$2:$H$81))","v":5581},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B$88)*(SocialData!$B$2:$B$81=F$88)*(SocialData!$H$2:$H$81))","v":4524.55}]
[null,"Avg Visitors Per Day",{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B$88)*(SocialData!$B$2:$B$81=C$88)*(SocialData!$I$2:$I$81))","v":14},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B$88)*(SocialData!$B$2:$B$81=D$88)*(SocialData!$I$2:$I$81))","v":14},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B$88)*(SocialData!$B$2:$B$81=E$88)*(SocialData!$I$2:$I$81))","v":15},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B$88)*(SocialData!$B$2:$B$81=F$88)*(SocialData!$I$2:$I$81))","v":15}]
[null,"Average Visit Duration",{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B$88)*(SocialData!$B$2:$B$81=C$88)*(SocialData!$J$2:$J$81))","v":2.0299999999999998},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B$88)*(SocialData!$B$2:$B$81=D$88)*(SocialData!$J$2:$J$81))","v":1.9999999999999998},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B$88)*(SocialData!$B$2:$B$81=E$88)*(SocialData!$J$2:$J$81))","v":1.9099999999999997},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B$88)*(SocialData!$B$2:$B$81=F$88)*(SocialData!$J$2:$J$81))","v":1.8199999999999996}]
[null,"Returning Visitors",{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B$88)*(SocialData!$B$2:$B$81=C$88)*(SocialData!$K$2:$K$81))","v":3140},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B$88)*(SocialData!$B$2:$B$81=D$88)*(SocialData!$K$2:$K$81))","v":2126},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B$88)*(SocialData!$B$2:$B$81=E$88)*(SocialData!$K$2:$K$81))","v":1897},{"$f":"SUMPRODUCT((SocialData!$A$2:$A$81=$B$88)*(SocialData!$B$2:$B$81=F$88)*(SocialData!$K$2:$K$81))","v":3373}]

{"sheet":"Dash","index":4,"n_rows":45,"n_cols":20,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[null,2010]
[null,{"$f":"$B$1 & \" Rev Exp Split\"","v":"2010 Rev Exp Split"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2010,2011,2012,2013]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(HYPERLINK(yr(N10),N10),N10)","v":2010},{"$f":"IFERROR(HYPERLINK(yr(O10),O10),O10)","v":2011},{"$f":"IFERROR(HYPERLINK(yr(P10),P10),P10)","v":2012},{"$f":"IFERROR(HYPERLINK(yr(Q10),Q10),Q10)","v":2013},null,null,"The Mid-West"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Ú","Ú","Ú","Ú"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Revenue",null,null,null,"Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calcs!C54","v":"Illinois"},null,null,null,{"$f":"Calcs!W54","v":"Illinois"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calcs!C55","v":"Ohio"},null,null,null,{"$f":"Calcs!W55","v":"Michigan"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calcs!C56","v":"Minnesota"},null,null,null,{"$f":"Calcs!W56","v":"Ohio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calcs!C57","v":"Michigan"},null,null,null,{"$f":"Calcs!W57","v":"Wisconsin"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calcs!C58","v":"Wisconsin"},null,null,null,{"$f":"Calcs!W58","v":"Indiana"}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Late Debt %",null,null,null,{"$f":"Calcs!P53","v":"FTE"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calcs!R54","v":"Michigan"},null,null,null,{"$f":"Calcs!O54","v":"Ohio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calcs!R55","v":"Illinois"},null,null,null,{"$f":"Calcs!O55","v":"Illinois"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calcs!R56","v":"Ohio"},null,null,null,{"$f":"Calcs!O56","v":"Indiana"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calcs!R57","v":"Indiana"},null,null,null,{"$f":"Calcs!O57","v":"Michigan"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calcs!R58","v":"Missouri"},null,null,null,{"$f":"Calcs!O58","v":"Wisconsin"}]
[]
[]
[]
[null,null,null,2010,2011,2012,2013,"Trend",null,null,null,null,2010,2011,2012,2013,"Trend",null,null,"Australia"]
[null,null,"Revenue","Ú","Ú","Ú","Ú",null,null,null,null,null,"Ú","Ú","Ú","Ú"]
[null,null,"The West",{"$f":"Calcs!D77","v":5174.6604741725596},{"$f":"Calcs!E77","v":6641.0682019999986},{"$f":"Calcs!F77","v":6679.4252021599996},{"$f":"Calcs!G77","v":6710.2425834908008},null,null,"Page Views",null,null,{"$f":"Calcs!C94","v":5323},{"$f":"Calcs!D94","v":5453},{"$f":"Calcs!E94","v":5581},{"$f":"Calcs!F94","v":4524.55}]
[null,null,"The South",{"$f":"Calcs!D78","v":5325.9360558605022},{"$f":"Calcs!E78","v":6923.9956899999997},{"$f":"Calcs!F78","v":6699.3231474999993},{"$f":"Calcs!G78","v":6862.5745371044995},null,null,"Avg Visitors Per Day",null,null,{"$f":"Calcs!C95","v":14},{"$f":"Calcs!D95","v":14},{"$f":"Calcs!E95","v":15},{"$f":"Calcs!F95","v":15}]
[null,null,"The North-East",{"$f":"Calcs!D79","v":4992.4280711837},{"$f":"Calcs!E79","v":6445.6826899999987},{"$f":"Calcs!F79","v":6222.3742481999998},{"$f":"Calcs!G79","v":6617.7259958975001},null,null,"Average Visit Duration",null,null,{"$f":"Calcs!C96","v":2.0299999999999998},{"$f":"Calcs!D96","v":1.9999999999999998},{"$f":"Calcs!E96","v":1.9099999999999997},{"$f":"Calcs!F96","v":1.8199999999999996}]
[null,null,"The Mid-West",{"$f":"Calcs!D80","v":4438.9359133813005},{"$f":"Calcs!E80","v":5750.2431999999999},{"$f":"Calcs!F80","v":5635.0614345499998},{"$f":"Calcs!G80","v":5580.0533331244997},null,null,"Returning Visitors",null,null,{"$f":"Calcs!C97","v":3140},{"$f":"Calcs!D97","v":2126},{"$f":"Calcs!E97","v":1897},{"$f":"Calcs!F97","v":3373}]
[]
[null,null,null,2010,2011,2012,2013,"Trend",null,null,null,null,2010,2011,2012,2013,"Trend"]
[null,null,null,"Ú","Ú","Ú","Ú",null,null,null,null,null,"Ú","Ú","Ú","Ú"]
[null,null,null,null,null,null,null,null,null,"Facebook",null,null,{"$f":"Calcs!C89","v":581.80000000000007},{"$f":"Calcs!D89","v":596},{"$f":"Calcs!E89","v":610},{"$f":"Calcs!F89","v":494.53000000000003}]
[null,null,"The West",{"$f":"Calcs!J77","v":3394.2724258637504},{"$f":"Calcs!K77","v":3412.7694124269128},{"$f":"Calcs!L77","v":3463.3208988355605},{"$f":"Calcs!M77","v":3300.929650547735},null,null,"Twitter",null,null,{"$f":"Calcs!C90","v":494},{"$f":"Calcs!D90","v":516},{"$f":"Calcs!E90","v":539},{"$f":"Calcs!F90","v":419.9}]
[null,null,"The South",{"$f":"Calcs!J78","v":4449.6880669499997},{"$f":"Calcs!K78","v":4335.055626749051},{"$f":"Calcs!L78","v":4388.6344742007141},{"$f":"Calcs!M78","v":4380.385258868404},null,null,"Google +",null,null,{"$f":"Calcs!C91","v":666},{"$f":"Calcs!D91","v":675},{"$f":"Calcs!E91","v":685},{"$f":"Calcs!F91","v":566.1}]
[null,null,"The North-East",{"$f":"Calcs!J79","v":2865.6283413099995},{"$f":"Calcs!K79","v":2765.7039833402005},{"$f":"Calcs!L79","v":2940.5216329952682},{"$f":"Calcs!M79","v":2777.8618813892795},null,null,"Linkedin",null,null,{"$f":"Calcs!C92","v":486},{"$f":"Calcs!D92","v":522},{"$f":"Calcs!E92","v":561},{"$f":"Calcs!F92","v":413.09999999999997}]
[null,null,"The Mid-West",{"$f":"Calcs!J80","v":3055.5986036100007},{"$f":"Calcs!K80","v":2995.2611256841001},{"$f":"Calcs!L80","v":2946.2752477164508},{"$f":"Calcs!M80","v":2980.4051070338032},null,null,"YouTube",null,null,{"$f":"Calcs!C93","v":989},{"$f":"Calcs!D93","v":1003},{"$f":"Calcs!E93","v":1018},{"$f":"Calcs!F93","v":840.65}]