{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Model","States","Data","Calcs","Summary"],"not_rendered":{"charts":7,"images":86,"macros":0,"external_links":0,"defined_names":71,"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":"Model","index":0,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,"Sheets","Sheet Type","Description","Links"]
[null,"Model","Assumptions","Description of Sheets",{"$f":"HYPERLINK(\"#\"&B2&\"!A2\",B2)","v":"Model"}]
[null,"List","Assumptions","Lists and model assumptions",{"$f":"HYPERLINK(\"#\"&B3&\"!A2\",B3)","v":"List"}]
[null,"Data","Input Sheet","Primary Inputs Sheet","Data"]
[null,"Calcs","Calculations sheet","Primary calculations page","Calcs"]
[null,"Check","Error trapping","Checks and balances for the model","Check"]
[null,"Summary","Output Sheet","Primary output page","Summary"]

{"sheet":"States","index":1,"n_rows":51,"n_cols":5,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["No","State","NameRng","FullName","Region"]
[1,null,"Alabama","Alabama","The South"]
[2,null,"Alaska","Alaska","The West"]
[3,null,"Arizona","Arizona","The West"]
[4,null,"Arkansas","Arkansas","The South"]
[5,null,"California","California","The West"]
[6,null,"Colorado","Colorado","The West"]
[7,null,"Connecticut","Connecticut","The North-East"]
[8,null,"Delaware","Delaware","The North-East"]
[9,null,"Florida","Florida","The South"]
[10,null,"Georgia","Georgia","The South"]
[11,null,"Hawaii","Hawaii","The West"]
[12,null,"Idaho","Idaho","The West"]
[13,null,"Illinois","Illinois","The Mid-West"]
[14,null,"Indiana","Indiana","The Mid-West"]
[15,null,"Iowa","Iowa","The Mid-West"]
[16,null,"Kansas","Kansas","The Mid-West"]
[17,null,"Kentucky","Kentucky","The South"]
[18,null,"Louisiana","Louisiana","The South"]
[19,null,"Maine","Maine","The North-East"]
[20,null,"Maryland","Maryland","The North-East"]
[21,null,"Massachusetts","Massachusetts","The North-East"]
[22,null,"Michigan","Michigan","The Mid-West"]
[23,null,"Minnesota","Minnesota","The Mid-West"]
[24,null,"Mississippi","Mississippi","The South"]
[25,null,"Missouri","Missouri","The Mid-West"]
[26,null,"Montana","Montana","The West"]
[27,null,"Nebraska","Nebraska","The Mid-West"]
[28,null,"Nevada","Nevada","The West"]
[29,null,"NewHampshire","New Hampshire","The North-East"]
[30,null,"NewJersey","New Jersey","The North-East"]
[31,null,"NewMexico","New Mexico","The West"]
[32,null,"NewYork","New York","The North-East"]
[33,null,"NorthCarolina","North Carolina","The South"]
[34,null,"NorthDakota","North Dakota","The Mid-West"]
[35,null,"Ohio","Ohio","The Mid-West"]
[36,null,"Oklahoma","Oklahoma","The South"]
[37,null,"Oregon","Oregon","The West"]
[38,null,"Pennsylvania","Pennsylvania","The North-East"]
[39,null,"RhodeIsland","Rhode Island","The North-East"]
[40,null,"SouthCarolina","South Carolina","The South"]
[41,null,"SouthDakota","South Dakota","The Mid-West"]
[42,null,"Tennessee","Tennessee","The South"]
[43,null,"Texas","Texas","The South"]
[44,null,"Utah","Utah","The West"]
[45,null,"Vermont","Vermont","The North-East"]
[46,null,"Virginia","Virginia","The South"]
[47,null,"Washington","Washington","The West"]
[48,null,"WestVirginia","West Virginia","The South"]
[49,null,"Wisconsin","Wisconsin","The Mid-West"]
[50,null,"Wyoming","Wyoming","The West"]

{"sheet":"Data","index":2,"n_rows":51,"n_cols":21,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["Index","State","Region","Pop 1 Jul 12","Pop April 1, 2010","Pop April 1, 2000","% of US","Population Density","Tax Revenue","Expenses","Unemployment","Pop Rank","Density Rank","Rev Rank","Exp Rank","Unemployment Rank","Pop Rank Reg","Density Rank Reg","Rev Rank","Exp Rank","Unemployment Rank Reg"]
[1,"California",{"$f":"VLOOKUP(B2,States!$D$2:$E$51,2,0)","v":"The West"},38041430,37253956,33871648,0.1191,244.2,292563574000,435914805277.5,8.6999999999999994E-2,{"$f":"RANK(D2,D$2:D$51)+COUNTIF(D$2:D2,D2)-1","v":1},{"$f":"RANK(H2,H$2:H$51)+COUNTIF(H$2:H2,H2)-1","v":10},{"$f":"RANK(I2,I$2:I$51)+COUNTIF(I$2:I2,I2)-1","v":1},{"$f":"RANK(J2,J$2:J$51)+COUNTIF(J$2:J2,J2)-1","v":1},{"$f":"RANK(K2,K$2:K$51)+COUNTIF(K$2:K2,K2)-1","v":5},{"$f":"SUMPRODUCT((C$2:C$601=$C2)*(D$2:D$601>D2))+1","v":1},{"$f":"SUMPRODUCT((C$2:C$601=$C2)*(H$2:H$601>H2))+1","v":1},{"$f":"SUMPRODUCT(($C$2:$C$601=$C2)*(I$2:I$601>I2))+1","v":1},{"$f":"SUMPRODUCT(($C$2:$C$601=$C2)*(I$2:I$601>I2))+1","v":1},{"$f":"COUNTIFS($C:$C,$C2,$K:$K,\">\"&$K2)+COUNTIFS($C$2:$C2,$C2,$K$2:$K2,$K2)","v":2}]
[2,"Texas",{"$f":"VLOOKUP(B3,States!$D$2:$E$51,2,0)","v":"The South"},26059203,25145561,20851820,8.0399999999999999E-2,98.07,219459878000,293723251710,6.2E-2,{"$f":"RANK(D3,D$2:D$51)+COUNTIF(D$2:D3,D3)-1","v":2},{"$f":"RANK(H3,H$2:H$51)+COUNTIF(H$2:H3,H3)-1","v":26},{"$f":"RANK(I3,I$2:I$51)+COUNTIF(I$2:I3,I3)-1","v":2},{"$f":"RANK(J3,J$2:J$51)+COUNTIF(J$2:J3,J3)-1","v":2},{"$f":"RANK(K3,K$2:K$51)+COUNTIF(K$2:K3,K3)-1","v":35},1,{"$f":"SUMPRODUCT((C$2:C$601=$C3)*(H$2:H$601>H3))+1","v":9},{"$f":"SUMPRODUCT(($C$2:$C$601=$C3)*(I$2:I$601>I3))+1","v":1},{"$f":"SUMPRODUCT(($C$2:$C$601=$C3)*(I$2:I$601>I3))+1","v":1},{"$f":"COUNTIFS($C:$C,$C3,$K:$K,\">\"&$K3)+COUNTIFS($C$2:$C3,$C3,$K$2:$K3,$K3)","v":11}]
[3,"New York",{"$f":"VLOOKUP(B4,States!$D$2:$E$51,2,0)","v":"The North-East"},19570261,19378102,18976457,6.1899999999999997E-2,415.3,201167954000,226137677622.5,7.6999999999999999E-2,{"$f":"RANK(D4,D$2:D$51)+COUNTIF(D$2:D4,D4)-1","v":3},{"$f":"RANK(H4,H$2:H$51)+COUNTIF(H$2:H4,H4)-1","v":6},{"$f":"RANK(I4,I$2:I$51)+COUNTIF(I$2:I4,I4)-1","v":3},{"$f":"RANK(J4,J$2:J$51)+COUNTIF(J$2:J4,J4)-1","v":3},{"$f":"RANK(K4,K$2:K$51)+COUNTIF(K$2:K4,K4)-1","v":14},1,6,{"$f":"SUMPRODUCT(($C$2:$C$601=$C4)*(I$2:I$601>I4))+1","v":1},1,{"$f":"COUNTIFS($C:$C,$C4,$K:$K,\">\"&$K4)+COUNTIFS($C$2:$C4,$C4,$K$2:$K4,$K4)","v":4}]
[4,"Florida",{"$f":"VLOOKUP(B5,States!$D$2:$E$51,2,0)","v":"The South"},19317568,18801310,15982378,6.0100000000000001E-2,360.2,122249635000,219561783927.5,6.7000000000000004E-2,{"$f":"RANK(D5,D$2:D$51)+COUNTIF(D$2:D5,D5)-1","v":4},{"$f":"RANK(H5,H$2:H$51)+COUNTIF(H$2:H5,H5)-1","v":7},{"$f":"RANK(I5,I$2:I$51)+COUNTIF(I$2:I5,I5)-1","v":5},{"$f":"RANK(J5,J$2:J$51)+COUNTIF(J$2:J5,J5)-1","v":4},{"$f":"RANK(K5,K$2:K$51)+COUNTIF(K$2:K5,K5)-1","v":25},{"$f":"SUMPRODUCT((C$2:C$601=$C5)*(D$2:D$601>D5))+1","v":2},1,2,2,{"$f":"COUNTIFS($C:$C,$C5,$K:$K,\">\"&$K5)+COUNTIFS($C$2:$C5,$C5,$K$2:$K5,$K5)","v":8}]
[5,"Illinois",{"$f":"VLOOKUP(B6,States!$D$2:$E$51,2,0)","v":"The Mid-West"},12875255,12830632,12419293,4.1000000000000002E-2,231.9,124431227000,149784245275,8.900000000000001E-2,{"$f":"RANK(D6,D$2:D$51)+COUNTIF(D$2:D6,D6)-1","v":5},{"$f":"RANK(H6,H$2:H$51)+COUNTIF(H$2:H6,H6)-1","v":11},{"$f":"RANK(I6,I$2:I$51)+COUNTIF(I$2:I6,I6)-1","v":4},{"$f":"RANK(J6,J$2:J$51)+COUNTIF(J$2:J6,J6)-1","v":5},{"$f":"RANK(K6,K$2:K$51)+COUNTIF(K$2:K6,K6)-1","v":4},{"$f":"SUMPRODUCT((C$2:C$601=$C6)*(D$2:D$601>D6))+1","v":1},2,1,1,{"$f":"COUNTIFS($C:$C,$C6,$K:$K,\">\"&$K6)+COUNTIFS($C$2:$C6,$C6,$K$2:$K6,$K6)","v":2}]
[6,"Pennsylvania",{"$f":"VLOOKUP(B7,States!$D$2:$E$51,2,0)","v":"The North-East"},12763536,12702379,12281054,4.0599999999999997E-2,285.3,108961515000,148322935565,7.4999999999999997E-2,{"$f":"RANK(D7,D$2:D$51)+COUNTIF(D$2:D7,D7)-1","v":6},{"$f":"RANK(H7,H$2:H$51)+COUNTIF(H$2:H7,H7)-1","v":8},{"$f":"RANK(I7,I$2:I$51)+COUNTIF(I$2:I7,I7)-1","v":8},{"$f":"RANK(J7,J$2:J$51)+COUNTIF(J$2:J7,J7)-1","v":6},{"$f":"RANK(K7,K$2:K$51)+COUNTIF(K$2:K7,K7)-1","v":16},2,7,3,3,{"$f":"COUNTIFS($C:$C,$C7,$K:$K,\">\"&$K7)+COUNTIFS($C$2:$C7,$C7,$K$2:$K7,$K7)","v":5}]
[7,"Ohio",{"$f":"VLOOKUP(B8,States!$D$2:$E$51,2,0)","v":"The Mid-West"},11544225,11536504,11353140,3.6900000000000002E-2,282.5,111094276000,134805820747.50002,7.4999999999999997E-2,{"$f":"RANK(D8,D$2:D$51)+COUNTIF(D$2:D8,D8)-1","v":7},{"$f":"RANK(H8,H$2:H$51)+COUNTIF(H$2:H8,H8)-1","v":9},{"$f":"RANK(I8,I$2:I$51)+COUNTIF(I$2:I8,I8)-1","v":7},{"$f":"RANK(J8,J$2:J$51)+COUNTIF(J$2:J8,J8)-1","v":7},{"$f":"RANK(K8,K$2:K$51)+COUNTIF(K$2:K8,K8)-1","v":17},2,1,2,2,{"$f":"COUNTIFS($C:$C,$C8,$K:$K,\">\"&$K8)+COUNTIFS($C$2:$C8,$C8,$K$2:$K8,$K8)","v":3}]
[8,"Georgia",{"$f":"VLOOKUP(B9,States!$D$2:$E$51,2,0)","v":"The South"},9919945,9687653,8186453,3.1E-2,172.5,65498308000,113251502525,8.1000000000000003E-2,{"$f":"RANK(D9,D$2:D$51)+COUNTIF(D$2:D9,D9)-1","v":8},{"$f":"RANK(H9,H$2:H$51)+COUNTIF(H$2:H9,H9)-1","v":17},{"$f":"RANK(I9,I$2:I$51)+COUNTIF(I$2:I9,I9)-1","v":11},{"$f":"RANK(J9,J$2:J$51)+COUNTIF(J$2:J9,J9)-1","v":9},{"$f":"RANK(K9,K$2:K$51)+COUNTIF(K$2:K9,K9)-1","v":11},3,4,3,3,{"$f":"COUNTIFS($C:$C,$C9,$K:$K,\">\"&$K9)+COUNTIFS($C$2:$C9,$C9,$K$2:$K9,$K9)","v":4}]
[9,"Michigan",{"$f":"VLOOKUP(B10,States!$D$2:$E$51,2,0)","v":"The Mid-West"},9883360,9883640,9938444,3.1600000000000003E-2,174.8,59210158000,115443467090.00002,0.09,{"$f":"RANK(D10,D$2:D$51)+COUNTIF(D$2:D10,D10)-1","v":9},{"$f":"RANK(H10,H$2:H$51)+COUNTIF(H$2:H10,H10)-1","v":16},{"$f":"RANK(I10,I$2:I$51)+COUNTIF(I$2:I10,I10)-1","v":14},{"$f":"RANK(J10,J$2:J$51)+COUNTIF(J$2:J10,J10)-1","v":8},{"$f":"RANK(K10,K$2:K$51)+COUNTIF(K$2:K10,K10)-1","v":3},3,4,4,4,{"$f":"COUNTIFS($C:$C,$C10,$K:$K,\">\"&$K10)+COUNTIFS($C$2:$C10,$C10,$K$2:$K10,$K10)","v":1}]
[10,"North Carolina",{"$f":"VLOOKUP(B11,States!$D$2:$E$51,2,0)","v":"The South"},9752073,9535483,8049313,3.0499999999999999E-2,200.6,61600064000,111424865387.5,0.08,{"$f":"RANK(D11,D$2:D$51)+COUNTIF(D$2:D11,D11)-1","v":10},{"$f":"RANK(H11,H$2:H$51)+COUNTIF(H$2:H11,H11)-1","v":14},{"$f":"RANK(I11,I$2:I$51)+COUNTIF(I$2:I11,I11)-1","v":13},{"$f":"RANK(J11,J$2:J$51)+COUNTIF(J$2:J11,J11)-1","v":10},{"$f":"RANK(K11,K$2:K$51)+COUNTIF(K$2:K11,K11)-1","v":12},4,3,5,5,{"$f":"COUNTIFS($C:$C,$C11,$K:$K,\">\"&$K11)+COUNTIFS($C$2:$C11,$C11,$K$2:$K11,$K11)","v":5}]
[11,"New Jersey",{"$f":"VLOOKUP(B12,States!$D$2:$E$51,2,0)","v":"The North-East"},8864590,8791894,8414350,2.81E-2,1189,111377490000,102657007127.5,8.4000000000000005E-2,{"$f":"RANK(D12,D$2:D$51)+COUNTIF(D$2:D12,D12)-1","v":11},{"$f":"RANK(H12,H$2:H$51)+COUNTIF(H$2:H12,H12)-1","v":1},{"$f":"RANK(I12,I$2:I$51)+COUNTIF(I$2:I12,I12)-1","v":6},{"$f":"RANK(J12,J$2:J$51)+COUNTIF(J$2:J12,J12)-1","v":11},{"$f":"RANK(K12,K$2:K$51)+COUNTIF(K$2:K12,K12)-1","v":7},3,1,2,2,{"$f":"COUNTIFS($C:$C,$C12,$K:$K,\">\"&$K12)+COUNTIFS($C$2:$C12,$C12,$K$2:$K12,$K12)","v":2}]
[12,"Virginia",{"$f":"VLOOKUP(B13,States!$D$2:$E$51,2,0)","v":"The South"},8185867,8001024,7078515,2.5600000000000001E-2,207.3,64297400000,93523821440,5.5999999999999994E-2,{"$f":"RANK(D13,D$2:D$51)+COUNTIF(D$2:D13,D13)-1","v":12},{"$f":"RANK(H13,H$2:H$51)+COUNTIF(H$2:H13,H13)-1","v":13},{"$f":"RANK(I13,I$2:I$51)+COUNTIF(I$2:I13,I13)-1","v":12},{"$f":"RANK(J13,J$2:J$51)+COUNTIF(J$2:J13,J13)-1","v":12},{"$f":"RANK(K13,K$2:K$51)+COUNTIF(K$2:K13,K13)-1","v":37},5,2,4,4,{"$f":"COUNTIFS($C:$C,$C13,$K:$K,\">\"&$K13)+COUNTIFS($C$2:$C13,$C13,$K$2:$K13,$K13)","v":13}]
[13,"Washington",{"$f":"VLOOKUP(B14,States!$D$2:$E$51,2,0)","v":"The West"},6897012,6724540,5894121,2.1499999999999998E-2,102.6,52443862000,78545396912.5,7.0000000000000007E-2,{"$f":"RANK(D14,D$2:D$51)+COUNTIF(D$2:D14,D14)-1","v":13},{"$f":"RANK(H14,H$2:H$51)+COUNTIF(H$2:H14,H14)-1","v":24},{"$f":"RANK(I14,I$2:I$51)+COUNTIF(I$2:I14,I14)-1","v":15},{"$f":"RANK(J14,J$2:J$51)+COUNTIF(J$2:J14,J14)-1","v":13},{"$f":"RANK(K14,K$2:K$51)+COUNTIF(K$2:K14,K14)-1","v":22},2,3,2,2,{"$f":"COUNTIFS($C:$C,$C14,$K:$K,\">\"&$K14)+COUNTIFS($C$2:$C14,$C14,$K$2:$K14,$K14)","v":5}]
[14,"Massachusetts",{"$f":"VLOOKUP(B15,States!$D$2:$E$51,2,0)","v":"The North-East"},6646144,6547629,6349097,2.0899999999999998E-2,852.1,79826976000,76353432347.5,7.2000000000000008E-2,{"$f":"RANK(D15,D$2:D$51)+COUNTIF(D$2:D15,D15)-1","v":14},{"$f":"RANK(H15,H$2:H$51)+COUNTIF(H$2:H15,H15)-1","v":2},{"$f":"RANK(I15,I$2:I$51)+COUNTIF(I$2:I15,I15)-1","v":9},{"$f":"RANK(J15,J$2:J$51)+COUNTIF(J$2:J15,J15)-1","v":14},{"$f":"RANK(K15,K$2:K$51)+COUNTIF(K$2:K15,K15)-1","v":21},4,2,4,4,{"$f":"COUNTIFS($C:$C,$C15,$K:$K,\">\"&$K15)+COUNTIFS($C$2:$C15,$C15,$K$2:$K15,$K15)","v":6}]
[15,"Arizona",{"$f":"VLOOKUP(B16,States!$D$2:$E$51,2,0)","v":"The West"},6553255,6392017,5130632,2.0400000000000001E-2,57.05,34850436000,74526795210,8.199999999999999E-2,{"$f":"RANK(D16,D$2:D$51)+COUNTIF(D$2:D16,D16)-1","v":15},{"$f":"RANK(H16,H$2:H$51)+COUNTIF(H$2:H16,H16)-1","v":33},{"$f":"RANK(I16,I$2:I$51)+COUNTIF(I$2:I16,I16)-1","v":23},{"$f":"RANK(J16,J$2:J$51)+COUNTIF(J$2:J16,J16)-1","v":16},{"$f":"RANK(K16,K$2:K$51)+COUNTIF(K$2:K16,K16)-1","v":10},3,4,4,4,{"$f":"COUNTIFS($C:$C,$C16,$K:$K,\">\"&$K16)+COUNTIFS($C$2:$C16,$C16,$K$2:$K16,$K16)","v":3}]
[16,"Indiana",{"$f":"VLOOKUP(B17,States!$D$2:$E$51,2,0)","v":"The Mid-West"},6537334,6483802,6080485,2.07E-2,182.5,51238512000,75622777492.5,7.4999999999999997E-2,{"$f":"RANK(D17,D$2:D$51)+COUNTIF(D$2:D17,D17)-1","v":16},{"$f":"RANK(H17,H$2:H$51)+COUNTIF(H$2:H17,H17)-1","v":15},{"$f":"RANK(I17,I$2:I$51)+COUNTIF(I$2:I17,I17)-1","v":16},{"$f":"RANK(J17,J$2:J$51)+COUNTIF(J$2:J17,J17)-1","v":15},{"$f":"RANK(K17,K$2:K$51)+COUNTIF(K$2:K17,K17)-1","v":18},4,3,5,5,{"$f":"COUNTIFS($C:$C,$C17,$K:$K,\">\"&$K17)+COUNTIFS($C$2:$C17,$C17,$K$2:$K17,$K17)","v":4}]
[17,"Tennessee",{"$f":"VLOOKUP(B18,States!$D$2:$E$51,2,0)","v":"The South"},6456243,6346105,5689283,2.0299999999999999E-2,156.6,47010303000,74161467782.5,8.4000000000000005E-2,{"$f":"RANK(D18,D$2:D$51)+COUNTIF(D$2:D18,D18)-1","v":17},{"$f":"RANK(H18,H$2:H$51)+COUNTIF(H$2:H18,H18)-1","v":19},{"$f":"RANK(I18,I$2:I$51)+COUNTIF(I$2:I18,I18)-1","v":20},{"$f":"RANK(J18,J$2:J$51)+COUNTIF(J$2:J18,J18)-1","v":17},{"$f":"RANK(K18,K$2:K$51)+COUNTIF(K$2:K18,K18)-1","v":8},6,6,6,6,{"$f":"COUNTIFS($C:$C,$C18,$K:$K,\">\"&$K18)+COUNTIFS($C$2:$C18,$C18,$K$2:$K18,$K18)","v":2}]
[18,"Missouri",{"$f":"VLOOKUP(B19,States!$D$2:$E$51,2,0)","v":"The Mid-West"},6021988,5988927,5595211,1.9099999999999999E-2,87.26,48413247000,69777538652.5,6.5000000000000002E-2,{"$f":"RANK(D19,D$2:D$51)+COUNTIF(D$2:D19,D19)-1","v":18},{"$f":"RANK(H19,H$2:H$51)+COUNTIF(H$2:H19,H19)-1","v":28},{"$f":"RANK(I19,I$2:I$51)+COUNTIF(I$2:I19,I19)-1","v":17},{"$f":"RANK(J19,J$2:J$51)+COUNTIF(J$2:J19,J19)-1","v":18},{"$f":"RANK(K19,K$2:K$51)+COUNTIF(K$2:K19,K19)-1","v":30},5,6,6,6,{"$f":"COUNTIFS($C:$C,$C19,$K:$K,\">\"&$K19)+COUNTIFS($C$2:$C19,$C19,$K$2:$K19,$K19)","v":5}]
[19,"Maryland",{"$f":"VLOOKUP(B20,States!$D$2:$E$51,2,0)","v":"The North-East"},5884563,5773552,5296486,1.8499999999999999E-2,606.20000000000005,48107002000,67585574087.5,6.7000000000000004E-2,{"$f":"RANK(D20,D$2:D$51)+COUNTIF(D$2:D20,D20)-1","v":19},{"$f":"RANK(H20,H$2:H$51)+COUNTIF(H$2:H20,H20)-1","v":4},{"$f":"RANK(I20,I$2:I$51)+COUNTIF(I$2:I20,I20)-1","v":18},{"$f":"RANK(J20,J$2:J$51)+COUNTIF(J$2:J20,J20)-1","v":19},{"$f":"RANK(K20,K$2:K$51)+COUNTIF(K$2:K20,K20)-1","v":26},5,4,5,5,{"$f":"COUNTIFS($C:$C,$C20,$K:$K,\">\"&$K20)+COUNTIFS($C$2:$C20,$C20,$K$2:$K20,$K20)","v":8}]
[20,"Wisconsin",{"$f":"VLOOKUP(B21,States!$D$2:$E$51,2,0)","v":"The Mid-West"},5726398,5686986,5363675,1.8200000000000001E-2,105.2,41498033000,66489591805,6.5000000000000002E-2,{"$f":"RANK(D21,D$2:D$51)+COUNTIF(D$2:D21,D21)-1","v":20},{"$f":"RANK(H21,H$2:H$51)+COUNTIF(H$2:H21,H21)-1","v":22},{"$f":"RANK(I21,I$2:I$51)+COUNTIF(I$2:I21,I21)-1","v":21},{"$f":"RANK(J21,J$2:J$51)+COUNTIF(J$2:J21,J21)-1","v":20},{"$f":"RANK(K21,K$2:K$51)+COUNTIF(K$2:K21,K21)-1","v":31},6,5,7,7,{"$f":"COUNTIFS($C:$C,$C21,$K:$K,\">\"&$K21)+COUNTIFS($C$2:$C21,$C21,$K$2:$K21,$K21)","v":6}]
[21,"Minnesota",{"$f":"VLOOKUP(B22,States!$D$2:$E$51,2,0)","v":"The Mid-West"},5379139,5303925,4919479,1.7000000000000001E-2,67.14,78685402000,62105662675.000008,4.8000000000000001E-2,{"$f":"RANK(D22,D$2:D$51)+COUNTIF(D$2:D22,D22)-1","v":21},{"$f":"RANK(H22,H$2:H$51)+COUNTIF(H$2:H22,H22)-1","v":31},{"$f":"RANK(I22,I$2:I$51)+COUNTIF(I$2:I22,I22)-1","v":10},{"$f":"RANK(J22,J$2:J$51)+COUNTIF(J$2:J22,J22)-1","v":21},{"$f":"RANK(K22,K$2:K$51)+COUNTIF(K$2:K22,K22)-1","v":42},7,7,3,3,{"$f":"COUNTIFS($C:$C,$C22,$K:$K,\">\"&$K22)+COUNTIFS($C$2:$C22,$C22,$K$2:$K22,$K22)","v":8}]
[22,"Colorado",{"$f":"VLOOKUP(B23,States!$D$2:$E$51,2,0)","v":"The West"},5187582,5029196,4301261,1.61E-2,49.33,41252701000,58817715827.5,6.8000000000000005E-2,{"$f":"RANK(D23,D$2:D$51)+COUNTIF(D$2:D23,D23)-1","v":22},{"$f":"RANK(H23,H$2:H$51)+COUNTIF(H$2:H23,H23)-1","v":37},{"$f":"RANK(I23,I$2:I$51)+COUNTIF(I$2:I23,I23)-1","v":22},{"$f":"RANK(J23,J$2:J$51)+COUNTIF(J$2:J23,J23)-1","v":22},{"$f":"RANK(K23,K$2:K$51)+COUNTIF(K$2:K23,K23)-1","v":23},4,5,3,3,{"$f":"COUNTIFS($C:$C,$C23,$K:$K,\">\"&$K23)+COUNTIFS($C$2:$C23,$C23,$K$2:$K23,$K23)","v":6}]
[23,"Alabama",{"$f":"VLOOKUP(B24,States!$D$2:$E$51,2,0)","v":"The South"},4822023,4779736,4447100,1.5299999999999999E-2,94.65,20882949000,55895096407.5,6.5000000000000002E-2,{"$f":"RANK(D24,D$2:D$51)+COUNTIF(D$2:D24,D24)-1","v":23},{"$f":"RANK(H24,H$2:H$51)+COUNTIF(H$2:H24,H24)-1","v":27},{"$f":"RANK(I24,I$2:I$51)+COUNTIF(I$2:I24,I24)-1","v":31},{"$f":"RANK(J24,J$2:J$51)+COUNTIF(J$2:J24,J24)-1","v":23},{"$f":"RANK(K24,K$2:K$51)+COUNTIF(K$2:K24,K24)-1","v":32},7,10,11,11,{"$f":"COUNTIFS($C:$C,$C24,$K:$K,\">\"&$K24)+COUNTIFS($C$2:$C24,$C24,$K$2:$K24,$K24)","v":9}]
[24,"South Carolina",{"$f":"VLOOKUP(B25,States!$D$2:$E$51,2,0)","v":"The South"},4723723,4625364,4012012,1.4800000000000001E-2,157.1,18557166000,54068459270,7.4999999999999997E-2,{"$f":"RANK(D25,D$2:D$51)+COUNTIF(D$2:D25,D25)-1","v":24},{"$f":"RANK(H25,H$2:H$51)+COUNTIF(H$2:H25,H25)-1","v":18},{"$f":"RANK(I25,I$2:I$51)+COUNTIF(I$2:I25,I25)-1","v":34},{"$f":"RANK(J25,J$2:J$51)+COUNTIF(J$2:J25,J25)-1","v":24},{"$f":"RANK(K25,K$2:K$51)+COUNTIF(K$2:K25,K25)-1","v":19},8,5,12,12,{"$f":"COUNTIFS($C:$C,$C25,$K:$K,\">\"&$K25)+COUNTIFS($C$2:$C25,$C25,$K$2:$K25,$K25)","v":6}]
[25,"Louisiana",{"$f":"VLOOKUP(B26,States!$D$2:$E$51,2,0)","v":"The South"},4601893,4533372,4468976,1.4500000000000001E-2,105,34811072000,52972476987.5,6.5000000000000002E-2,{"$f":"RANK(D26,D$2:D$51)+COUNTIF(D$2:D26,D26)-1","v":25},{"$f":"RANK(H26,H$2:H$51)+COUNTIF(H$2:H26,H26)-1","v":23},{"$f":"RANK(I26,I$2:I$51)+COUNTIF(I$2:I26,I26)-1","v":24},{"$f":"RANK(J26,J$2:J$51)+COUNTIF(J$2:J26,J26)-1","v":25},{"$f":"RANK(K26,K$2:K$51)+COUNTIF(K$2:K26,K26)-1","v":33},9,8,7,7,{"$f":"COUNTIFS($C:$C,$C26,$K:$K,\">\"&$K26)+COUNTIFS($C$2:$C26,$C26,$K$2:$K26,$K26)","v":10}]
[26,"Kentucky",{"$f":"VLOOKUP(B27,States!$D$2:$E$51,2,0)","v":"The South"},4380415,4339367,4041769,1.3899999999999999E-2,110,25085813000,50780512422.5,8.4000000000000005E-2,{"$f":"RANK(D27,D$2:D$51)+COUNTIF(D$2:D27,D27)-1","v":26},{"$f":"RANK(H27,H$2:H$51)+COUNTIF(H$2:H27,H27)-1","v":21},{"$f":"RANK(I27,I$2:I$51)+COUNTIF(I$2:I27,I27)-1","v":27},{"$f":"RANK(J27,J$2:J$51)+COUNTIF(J$2:J27,J27)-1","v":26},{"$f":"RANK(K27,K$2:K$51)+COUNTIF(K$2:K27,K27)-1","v":9},10,7,10,10,{"$f":"COUNTIFS($C:$C,$C27,$K:$K,\">\"&$K27)+COUNTIFS($C$2:$C27,$C27,$K$2:$K27,$K27)","v":3}]
[27,"Oregon",{"$f":"VLOOKUP(B28,States!$D$2:$E$51,2,0)","v":"The West"},3899353,3831074,3421399,1.2200000000000001E-2,40.33,22716602000,44569946155,7.6999999999999999E-2,{"$f":"RANK(D28,D$2:D$51)+COUNTIF(D$2:D28,D28)-1","v":27},{"$f":"RANK(H28,H$2:H$51)+COUNTIF(H$2:H28,H28)-1","v":39},{"$f":"RANK(I28,I$2:I$51)+COUNTIF(I$2:I28,I28)-1","v":28},{"$f":"RANK(J28,J$2:J$51)+COUNTIF(J$2:J28,J28)-1","v":27},{"$f":"RANK(K28,K$2:K$51)+COUNTIF(K$2:K28,K28)-1","v":15},5,6,5,5,{"$f":"COUNTIFS($C:$C,$C28,$K:$K,\">\"&$K28)+COUNTIFS($C$2:$C28,$C28,$K$2:$K28,$K28)","v":4}]
[28,"Oklahoma",{"$f":"VLOOKUP(B29,States!$D$2:$E$51,2,0)","v":"The South"},3814820,3751351,3450654,1.2E-2,55.22,27087264000,43839291300,5.5E-2,{"$f":"RANK(D29,D$2:D$51)+COUNTIF(D$2:D29,D29)-1","v":28},{"$f":"RANK(H29,H$2:H$51)+COUNTIF(H$2:H29,H29)-1","v":35},{"$f":"RANK(I29,I$2:I$51)+COUNTIF(I$2:I29,I29)-1","v":25},{"$f":"RANK(J29,J$2:J$51)+COUNTIF(J$2:J29,J29)-1","v":28},{"$f":"RANK(K29,K$2:K$51)+COUNTIF(K$2:K29,K29)-1","v":39},11,14,8,8,{"$f":"COUNTIFS($C:$C,$C29,$K:$K,\">\"&$K29)+COUNTIFS($C$2:$C29,$C29,$K$2:$K29,$K29)","v":14}]
[29,"Connecticut",{"$f":"VLOOKUP(B30,States!$D$2:$E$51,2,0)","v":"The North-East"},3590347,3574097,3405565,1.14E-2,741.4,47262702000,41647326735,7.9000000000000001E-2,{"$f":"RANK(D30,D$2:D$51)+COUNTIF(D$2:D30,D30)-1","v":29},{"$f":"RANK(H30,H$2:H$51)+COUNTIF(H$2:H30,H30)-1","v":3},{"$f":"RANK(I30,I$2:I$51)+COUNTIF(I$2:I30,I30)-1","v":19},{"$f":"RANK(J30,J$2:J$51)+COUNTIF(J$2:J30,J30)-1","v":29},{"$f":"RANK(K30,K$2:K$51)+COUNTIF(K$2:K30,K30)-1","v":13},6,3,6,6,{"$f":"COUNTIFS($C:$C,$C30,$K:$K,\">\"&$K30)+COUNTIFS($C$2:$C30,$C30,$K$2:$K30,$K30)","v":3}]
[30,"Iowa",{"$f":"VLOOKUP(B31,States!$D$2:$E$51,2,0)","v":"The Mid-West"},3074186,3046355,2926324,9.7000000000000003E-3,54.81,18753596000,35436760467.5,4.5999999999999999E-2,{"$f":"RANK(D31,D$2:D$51)+COUNTIF(D$2:D31,D31)-1","v":30},{"$f":"RANK(H31,H$2:H$51)+COUNTIF(H$2:H31,H31)-1","v":36},{"$f":"RANK(I31,I$2:I$51)+COUNTIF(I$2:I31,I31)-1","v":33},{"$f":"RANK(J31,J$2:J$51)+COUNTIF(J$2:J31,J31)-1","v":30},{"$f":"RANK(K31,K$2:K$51)+COUNTIF(K$2:K31,K31)-1","v":43},8,8,10,10,{"$f":"COUNTIFS($C:$C,$C31,$K:$K,\">\"&$K31)+COUNTIFS($C$2:$C31,$C31,$K$2:$K31,$K31)","v":9}]
[31,"Mississippi",{"$f":"VLOOKUP(B32,States!$D$2:$E$51,2,0)","v":"The South"},2984926,2967297,2844658,9.4999999999999998E-3,63.5,10458549000,34706105612.5,8.5000000000000006E-2,{"$f":"RANK(D32,D$2:D$51)+COUNTIF(D$2:D32,D32)-1","v":31},{"$f":"RANK(H32,H$2:H$51)+COUNTIF(H$2:H32,H32)-1","v":32},{"$f":"RANK(I32,I$2:I$51)+COUNTIF(I$2:I32,I32)-1","v":38},{"$f":"RANK(J32,J$2:J$51)+COUNTIF(J$2:J32,J32)-1","v":31},{"$f":"RANK(K32,K$2:K$51)+COUNTIF(K$2:K32,K32)-1","v":6},12,12,13,13,{"$f":"COUNTIFS($C:$C,$C32,$K:$K,\">\"&$K32)+COUNTIFS($C$2:$C32,$C32,$K$2:$K32,$K32)","v":1}]
[32,"Arkansas",{"$f":"VLOOKUP(B33,States!$D$2:$E$51,2,0)","v":"The South"},2949131,2915918,2673400,9.2999999999999992E-3,56.43,25299832000,33975450757.499996,7.4999999999999997E-2,{"$f":"RANK(D33,D$2:D$51)+COUNTIF(D$2:D33,D33)-1","v":32},{"$f":"RANK(H33,H$2:H$51)+COUNTIF(H$2:H33,H33)-1","v":34},{"$f":"RANK(I33,I$2:I$51)+COUNTIF(I$2:I33,I33)-1","v":26},{"$f":"RANK(J33,J$2:J$51)+COUNTIF(J$2:J33,J33)-1","v":32},{"$f":"RANK(K33,K$2:K$51)+COUNTIF(K$2:K33,K33)-1","v":20},13,13,9,9,{"$f":"COUNTIFS($C:$C,$C33,$K:$K,\">\"&$K33)+COUNTIFS($C$2:$C33,$C33,$K$2:$K33,$K33)","v":7}]
[33,"Kansas",{"$f":"VLOOKUP(B34,States!$D$2:$E$51,2,0)","v":"The Mid-West"},2885905,2853118,2688418,9.1000000000000004E-3,35.090000000000003,21904615000,33244795902.5,5.5999999999999994E-2,{"$f":"RANK(D34,D$2:D$51)+COUNTIF(D$2:D34,D34)-1","v":33},{"$f":"RANK(H34,H$2:H$51)+COUNTIF(H$2:H34,H34)-1","v":40},{"$f":"RANK(I34,I$2:I$51)+COUNTIF(I$2:I34,I34)-1","v":29},{"$f":"RANK(J34,J$2:J$51)+COUNTIF(J$2:J34,J34)-1","v":33},{"$f":"RANK(K34,K$2:K$51)+COUNTIF(K$2:K34,K34)-1","v":38},9,9,8,8,{"$f":"COUNTIFS($C:$C,$C34,$K:$K,\">\"&$K34)+COUNTIFS($C$2:$C34,$C34,$K$2:$K34,$K34)","v":7}]
[34,"Utah",{"$f":"VLOOKUP(B35,States!$D$2:$E$51,2,0)","v":"The West"},2855287,2763885,2233169,8.8000000000000005E-3,34.299999999999997,15642129000,32148813620,4.5999999999999999E-2,{"$f":"RANK(D35,D$2:D$51)+COUNTIF(D$2:D35,D35)-1","v":34},{"$f":"RANK(H35,H$2:H$51)+COUNTIF(H$2:H35,H35)-1","v":41},{"$f":"RANK(I35,I$2:I$51)+COUNTIF(I$2:I35,I35)-1","v":35},{"$f":"RANK(J35,J$2:J$51)+COUNTIF(J$2:J35,J35)-1","v":34},{"$f":"RANK(K35,K$2:K$51)+COUNTIF(K$2:K35,K35)-1","v":44},6,7,6,6,{"$f":"COUNTIFS($C:$C,$C35,$K:$K,\">\"&$K35)+COUNTIFS($C$2:$C35,$C35,$K$2:$K35,$K35)","v":11}]
[35,"Nevada",{"$f":"VLOOKUP(B36,States!$D$2:$E$51,2,0)","v":"The West"},2758931,2700551,1998257,8.6E-3,24.8,13727425000,31418158765,9.3000000000000013E-2,{"$f":"RANK(D36,D$2:D$51)+COUNTIF(D$2:D36,D36)-1","v":35},{"$f":"RANK(H36,H$2:H$51)+COUNTIF(H$2:H36,H36)-1","v":42},{"$f":"RANK(I36,I$2:I$51)+COUNTIF(I$2:I36,I36)-1","v":36},{"$f":"RANK(J36,J$2:J$51)+COUNTIF(J$2:J36,J36)-1","v":35},{"$f":"RANK(K36,K$2:K$51)+COUNTIF(K$2:K36,K36)-1","v":1},7,8,7,7,{"$f":"COUNTIFS($C:$C,$C36,$K:$K,\">\"&$K36)+COUNTIFS($C$2:$C36,$C36,$K$2:$K36,$K36)","v":1}]
[36,"New Mexico",{"$f":"VLOOKUP(B37,States!$D$2:$E$51,2,0)","v":"The West"},2085538,2059179,1819046,6.6E-3,17.16,7866206000,24111610215,6.6000000000000003E-2,{"$f":"RANK(D37,D$2:D$51)+COUNTIF(D$2:D37,D37)-1","v":36},{"$f":"RANK(H37,H$2:H$51)+COUNTIF(H$2:H37,H37)-1","v":45},{"$f":"RANK(I37,I$2:I$51)+COUNTIF(I$2:I37,I37)-1","v":40},{"$f":"RANK(J37,J$2:J$51)+COUNTIF(J$2:J37,J37)-1","v":36},{"$f":"RANK(K37,K$2:K$51)+COUNTIF(K$2:K37,K37)-1","v":29},8,10,8,8,{"$f":"COUNTIFS($C:$C,$C37,$K:$K,\">\"&$K37)+COUNTIFS($C$2:$C37,$C37,$K$2:$K37,$K37)","v":8}]
[37,"Nebraska",{"$f":"VLOOKUP(B38,States!$D$2:$E$51,2,0)","v":"The Mid-West"},1855525,1826341,1711263,5.7999999999999996E-3,23.97,19795254000,21188990795,3.9E-2,{"$f":"RANK(D38,D$2:D$51)+COUNTIF(D$2:D38,D38)-1","v":37},{"$f":"RANK(H38,H$2:H$51)+COUNTIF(H$2:H38,H38)-1","v":43},{"$f":"RANK(I38,I$2:I$51)+COUNTIF(I$2:I38,I38)-1","v":32},{"$f":"RANK(J38,J$2:J$51)+COUNTIF(J$2:J38,J38)-1","v":38},{"$f":"RANK(K38,K$2:K$51)+COUNTIF(K$2:K38,K38)-1","v":48},10,10,9,9,{"$f":"COUNTIFS($C:$C,$C38,$K:$K,\">\"&$K38)+COUNTIFS($C$2:$C38,$C38,$K$2:$K38,$K38)","v":10}]
[38,"West Virginia",{"$f":"VLOOKUP(B39,States!$D$2:$E$51,2,0)","v":"The South"},1855413,1852994,1808344,5.8999999999999999E-3,77.06,6498502000,21554318222.5,6.2E-2,{"$f":"RANK(D39,D$2:D$51)+COUNTIF(D$2:D39,D39)-1","v":38},{"$f":"RANK(H39,H$2:H$51)+COUNTIF(H$2:H39,H39)-1","v":29},{"$f":"RANK(I39,I$2:I$51)+COUNTIF(I$2:I39,I39)-1","v":43},{"$f":"RANK(J39,J$2:J$51)+COUNTIF(J$2:J39,J39)-1","v":37},{"$f":"RANK(K39,K$2:K$51)+COUNTIF(K$2:K39,K39)-1","v":36},14,11,14,14,{"$f":"COUNTIFS($C:$C,$C39,$K:$K,\">\"&$K39)+COUNTIFS($C$2:$C39,$C39,$K$2:$K39,$K39)","v":12}]
[39,"Idaho",{"$f":"VLOOKUP(B40,States!$D$2:$E$51,2,0)","v":"The West"},1595728,1567582,1293953,5.1000000000000004E-3,19.5,7622490000,18631698802.5,6.7000000000000004E-2,{"$f":"RANK(D40,D$2:D$51)+COUNTIF(D$2:D40,D40)-1","v":39},{"$f":"RANK(H40,H$2:H$51)+COUNTIF(H$2:H40,H40)-1","v":44},{"$f":"RANK(I40,I$2:I$51)+COUNTIF(I$2:I40,I40)-1","v":41},{"$f":"RANK(J40,J$2:J$51)+COUNTIF(J$2:J40,J40)-1","v":39},{"$f":"RANK(K40,K$2:K$51)+COUNTIF(K$2:K40,K40)-1","v":27},9,9,9,9,{"$f":"COUNTIFS($C:$C,$C40,$K:$K,\">\"&$K40)+COUNTIFS($C$2:$C40,$C40,$K$2:$K40,$K40)","v":7}]
[40,"Hawaii",{"$f":"VLOOKUP(B41,States!$D$2:$E$51,2,0)","v":"The West"},1392313,1360301,1211537,4.3E-3,216.8,6511578000,15709079382.5,4.4000000000000004E-2,{"$f":"RANK(D41,D$2:D$51)+COUNTIF(D$2:D41,D41)-1","v":40},{"$f":"RANK(H41,H$2:H$51)+COUNTIF(H$2:H41,H41)-1","v":12},{"$f":"RANK(I41,I$2:I$51)+COUNTIF(I$2:I41,I41)-1","v":42},{"$f":"RANK(J41,J$2:J$51)+COUNTIF(J$2:J41,J41)-1","v":40},{"$f":"RANK(K41,K$2:K$51)+COUNTIF(K$2:K41,K41)-1","v":47},10,2,10,10,{"$f":"COUNTIFS($C:$C,$C41,$K:$K,\">\"&$K41)+COUNTIFS($C$2:$C41,$C41,$K$2:$K41,$K41)","v":13}]
[41,"Maine",{"$f":"VLOOKUP(B42,States!$D$2:$E$51,2,0)","v":"The North-East"},1329192,1328361,1274923,4.1999999999999997E-3,43.04,6229189000,15343751955,6.7000000000000004E-2,{"$f":"RANK(D42,D$2:D$51)+COUNTIF(D$2:D42,D42)-1","v":41},{"$f":"RANK(H42,H$2:H$51)+COUNTIF(H$2:H42,H42)-1","v":38},{"$f":"RANK(I42,I$2:I$51)+COUNTIF(I$2:I42,I42)-1","v":44},{"$f":"RANK(J42,J$2:J$51)+COUNTIF(J$2:J42,J42)-1","v":41},{"$f":"RANK(K42,K$2:K$51)+COUNTIF(K$2:K42,K42)-1","v":28},7,11,10,10,{"$f":"COUNTIFS($C:$C,$C42,$K:$K,\">\"&$K42)+COUNTIFS($C$2:$C42,$C42,$K$2:$K42,$K42)","v":9}]
[42,"New Hampshire",{"$f":"VLOOKUP(B43,States!$D$2:$E$51,2,0)","v":"The North-East"},1320718,1316470,1235786,4.1999999999999997E-3,147,8807691000,15343751955,5.0999999999999997E-2,{"$f":"RANK(D43,D$2:D$51)+COUNTIF(D$2:D43,D43)-1","v":42},{"$f":"RANK(H43,H$2:H$51)+COUNTIF(H$2:H43,H43)-1","v":20},{"$f":"RANK(I43,I$2:I$51)+COUNTIF(I$2:I43,I43)-1","v":39},{"$f":"RANK(J43,J$2:J$51)+COUNTIF(J$2:J43,J43)-1","v":42},{"$f":"RANK(K43,K$2:K$51)+COUNTIF(K$2:K43,K43)-1","v":41},8,8,9,9,{"$f":"COUNTIFS($C:$C,$C43,$K:$K,\">\"&$K43)+COUNTIFS($C$2:$C43,$C43,$K$2:$K43,$K43)","v":10}]
[43,"Rhode Island",{"$f":"VLOOKUP(B44,States!$D$2:$E$51,2,0)","v":"The North-East"},1050292,1052567,1048319,3.3999999999999998E-3,100.6,10992338000,12421132535,9.1999999999999998E-2,{"$f":"RANK(D44,D$2:D$51)+COUNTIF(D$2:D44,D44)-1","v":43},{"$f":"RANK(H44,H$2:H$51)+COUNTIF(H$2:H44,H44)-1","v":25},{"$f":"RANK(I44,I$2:I$51)+COUNTIF(I$2:I44,I44)-1","v":37},{"$f":"RANK(J44,J$2:J$51)+COUNTIF(J$2:J44,J44)-1","v":43},{"$f":"RANK(K44,K$2:K$51)+COUNTIF(K$2:K44,K44)-1","v":2},9,9,8,8,{"$f":"COUNTIFS($C:$C,$C44,$K:$K,\">\"&$K44)+COUNTIFS($C$2:$C44,$C44,$K$2:$K44,$K44)","v":1}]
[44,"Montana",{"$f":"VLOOKUP(B45,States!$D$2:$E$51,2,0)","v":"The West"},1005141,989415,902195,3.2000000000000002E-3,6.8579999999999997,4383727000,11690477680,5.2000000000000005E-2,{"$f":"RANK(D45,D$2:D$51)+COUNTIF(D$2:D45,D45)-1","v":44},{"$f":"RANK(H45,H$2:H$51)+COUNTIF(H$2:H45,H45)-1","v":48},{"$f":"RANK(I45,I$2:I$51)+COUNTIF(I$2:I45,I45)-1","v":48},{"$f":"RANK(J45,J$2:J$51)+COUNTIF(J$2:J45,J45)-1","v":44},{"$f":"RANK(K45,K$2:K$51)+COUNTIF(K$2:K45,K45)-1","v":40},11,11,12,12,{"$f":"COUNTIFS($C:$C,$C45,$K:$K,\">\"&$K45)+COUNTIFS($C$2:$C45,$C45,$K$2:$K45,$K45)","v":10}]
[45,"Delaware",{"$f":"VLOOKUP(B46,States!$D$2:$E$51,2,0)","v":"The North-East"},917092,897934,783600,2.8999999999999998E-3,470.7,21835412000,10594495397.5,6.8000000000000005E-2,{"$f":"RANK(D46,D$2:D$51)+COUNTIF(D$2:D46,D46)-1","v":45},{"$f":"RANK(H46,H$2:H$51)+COUNTIF(H$2:H46,H46)-1","v":5},{"$f":"RANK(I46,I$2:I$51)+COUNTIF(I$2:I46,I46)-1","v":30},{"$f":"RANK(J46,J$2:J$51)+COUNTIF(J$2:J46,J46)-1","v":45},{"$f":"RANK(K46,K$2:K$51)+COUNTIF(K$2:K46,K46)-1","v":24},10,5,7,7,{"$f":"COUNTIFS($C:$C,$C46,$K:$K,\">\"&$K46)+COUNTIFS($C$2:$C46,$C46,$K$2:$K46,$K46)","v":7}]
[46,"South Dakota",{"$f":"VLOOKUP(B47,States!$D$2:$E$51,2,0)","v":"The Mid-West"},833354,814180,754844,2.5999999999999999E-3,10.86,5136249000,9498513115,3.7000000000000005E-2,{"$f":"RANK(D47,D$2:D$51)+COUNTIF(D$2:D47,D47)-1","v":46},{"$f":"RANK(H47,H$2:H$51)+COUNTIF(H$2:H47,H47)-1","v":46},{"$f":"RANK(I47,I$2:I$51)+COUNTIF(I$2:I47,I47)-1","v":46},{"$f":"RANK(J47,J$2:J$51)+COUNTIF(J$2:J47,J47)-1","v":46},{"$f":"RANK(K47,K$2:K$51)+COUNTIF(K$2:K47,K47)-1","v":49},11,11,12,12,{"$f":"COUNTIFS($C:$C,$C47,$K:$K,\">\"&$K47)+COUNTIFS($C$2:$C47,$C47,$K$2:$K47,$K47)","v":11}]
[47,"Alaska",{"$f":"VLOOKUP(B48,States!$D$2:$E$51,2,0)","v":"The West"},731449,710231,626932,2.3E-3,1.264,4898780000,8402530832.5,6.5000000000000002E-2,{"$f":"RANK(D48,D$2:D$51)+COUNTIF(D$2:D48,D48)-1","v":47},{"$f":"RANK(H48,H$2:H$51)+COUNTIF(H$2:H48,H48)-1","v":50},{"$f":"RANK(I48,I$2:I$51)+COUNTIF(I$2:I48,I48)-1","v":47},{"$f":"RANK(J48,J$2:J$51)+COUNTIF(J$2:J48,J48)-1","v":47},{"$f":"RANK(K48,K$2:K$51)+COUNTIF(K$2:K48,K48)-1","v":34},12,13,11,11,{"$f":"COUNTIFS($C:$C,$C48,$K:$K,\">\"&$K48)+COUNTIFS($C$2:$C48,$C48,$K$2:$K48,$K48)","v":9}]
[48,"North Dakota",{"$f":"VLOOKUP(B49,States!$D$2:$E$51,2,0)","v":"The Mid-West"},699628,672591,642200,2.0999999999999999E-3,9.9160000000000004,5664860000,7671875977.5,2.7000000000000003E-2,{"$f":"RANK(D49,D$2:D$51)+COUNTIF(D$2:D49,D49)-1","v":48},{"$f":"RANK(H49,H$2:H$51)+COUNTIF(H$2:H49,H49)-1","v":47},{"$f":"RANK(I49,I$2:I$51)+COUNTIF(I$2:I49,I49)-1","v":45},{"$f":"RANK(J49,J$2:J$51)+COUNTIF(J$2:J49,J49)-1","v":48},{"$f":"RANK(K49,K$2:K$51)+COUNTIF(K$2:K49,K49)-1","v":50},12,12,11,11,{"$f":"COUNTIFS($C:$C,$C49,$K:$K,\">\"&$K49)+COUNTIFS($C$2:$C49,$C49,$K$2:$K49,$K49)","v":12}]
[49,"Vermont",{"$f":"VLOOKUP(B50,States!$D$2:$E$51,2,0)","v":"The North-East"},626011,625741,608827,2E-3,67.73,3524887000,7306548550,4.4999999999999998E-2,{"$f":"RANK(D50,D$2:D$51)+COUNTIF(D$2:D50,D50)-1","v":49},{"$f":"RANK(H50,H$2:H$51)+COUNTIF(H$2:H50,H50)-1","v":30},{"$f":"RANK(I50,I$2:I$51)+COUNTIF(I$2:I50,I50)-1","v":50},{"$f":"RANK(J50,J$2:J$51)+COUNTIF(J$2:J50,J50)-1","v":49},{"$f":"RANK(K50,K$2:K$51)+COUNTIF(K$2:K50,K50)-1","v":46},11,10,11,11,{"$f":"COUNTIFS($C:$C,$C50,$K:$K,\">\"&$K50)+COUNTIFS($C$2:$C50,$C50,$K$2:$K50,$K50)","v":11}]
[50,"Wyoming",{"$f":"VLOOKUP(B51,States!$D$2:$E$51,2,0)","v":"The West"},576412,563626,493782,1.8E-3,5.851,3828379000,6575893695,4.5999999999999999E-2,{"$f":"RANK(D51,D$2:D$51)+COUNTIF(D$2:D51,D51)-1","v":50},{"$f":"RANK(H51,H$2:H$51)+COUNTIF(H$2:H51,H51)-1","v":49},{"$f":"RANK(I51,I$2:I$51)+COUNTIF(I$2:I51,I51)-1","v":49},{"$f":"RANK(J51,J$2:J$51)+COUNTIF(J$2:J51,J51)-1","v":50},{"$f":"RANK(K51,K$2:K$51)+COUNTIF(K$2:K51,K51)-1","v":45},13,12,13,13,{"$f":"COUNTIFS($C:$C,$C51,$K:$K,\">\"&$K51)+COUNTIFS($C$2:$C51,$C51,$K$2:$K51,$K51)","v":12}]

{"sheet":"Calcs","index":3,"n_rows":89,"n_cols":20,"rows_kept":89,"cut":false,"hidden":false,"merged":[]}
[null,"Population",null,null,null,"Revenue",null,null,null,"Revenue",null,null,null,"Expenses",null,null,null,"Unemployment"]
["Top 10","Region","State","Population 12",null,"Region","State","Pop Density",null,"Region","State","Revenue",null,"Region","State","Expenses",null,"Region","State","Unemployment"]
[1,"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":"California"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C3)*(Data!$C$2:$C$51=B3)*(Data!$D$2:$D$51))","v":38041430},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F3)*(Data!$R$2:$R$51=A3),0),0))","v":"California"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G3)*(Data!$C$2:$C$51=F3)*(Data!$H$2:$H$51))","v":244.2},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J3)*(Data!$S$2:$S$51=A3),0),0))","v":"California"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K3)*(Data!$C$2:$C$51=J3)*(Data!$I$2:$I$51))","v":292563574000},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N3)*(Data!$T$2:$T$51=A3),0),0))","v":"California"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O3)*(Data!$C$2:$C$51=N3)*(Data!$J$2:$J$51))","v":435914805277.5},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R3)*(Data!$U$2:$U$51=A3),0),0))","v":"Nevada"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S3)*(Data!$C$2:$C$51=R3)*(Data!$K$2:$K$51))","v":9.3000000000000013E-2}]
[2,"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":"Washington"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C4)*(Data!$C$2:$C$51=B4)*(Data!$D$2:$D$51))","v":6897012},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F4)*(Data!$R$2:$R$51=A4),0),0))","v":"Hawaii"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G4)*(Data!$C$2:$C$51=F4)*(Data!$H$2:$H$51))","v":216.8},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J4)*(Data!$S$2:$S$51=A4),0),0))","v":"Washington"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K4)*(Data!$C$2:$C$51=J4)*(Data!$I$2:$I$51))","v":52443862000},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N4)*(Data!$T$2:$T$51=A4),0),0))","v":"Washington"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O4)*(Data!$C$2:$C$51=N4)*(Data!$J$2:$J$51))","v":78545396912.5},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R4)*(Data!$U$2:$U$51=A4),0),0))","v":"California"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S4)*(Data!$C$2:$C$51=R4)*(Data!$K$2:$K$51))","v":8.6999999999999994E-2}]
[3,"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":"Arizona"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C5)*(Data!$C$2:$C$51=B5)*(Data!$D$2:$D$51))","v":6553255},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F5)*(Data!$R$2:$R$51=A5),0),0))","v":"Washington"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G5)*(Data!$C$2:$C$51=F5)*(Data!$H$2:$H$51))","v":102.6},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J5)*(Data!$S$2:$S$51=A5),0),0))","v":"Colorado"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K5)*(Data!$C$2:$C$51=J5)*(Data!$I$2:$I$51))","v":41252701000},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N5)*(Data!$T$2:$T$51=A5),0),0))","v":"Colorado"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O5)*(Data!$C$2:$C$51=N5)*(Data!$J$2:$J$51))","v":58817715827.5},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R5)*(Data!$U$2:$U$51=A5),0),0))","v":"Arizona"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S5)*(Data!$C$2:$C$51=R5)*(Data!$K$2:$K$51))","v":8.199999999999999E-2}]
[4,"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=C6)*(Data!$C$2:$C$51=B6)*(Data!$D$2:$D$51))","v":5187582},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F6)*(Data!$R$2:$R$51=A6),0),0))","v":"Arizona"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G6)*(Data!$C$2:$C$51=F6)*(Data!$H$2:$H$51))","v":57.05},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J6)*(Data!$S$2:$S$51=A6),0),0))","v":"Arizona"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K6)*(Data!$C$2:$C$51=J6)*(Data!$I$2:$I$51))","v":34850436000},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N6)*(Data!$T$2:$T$51=A6),0),0))","v":"Arizona"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O6)*(Data!$C$2:$C$51=N6)*(Data!$J$2:$J$51))","v":74526795210},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R6)*(Data!$U$2:$U$51=A6),0),0))","v":"Oregon"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S6)*(Data!$C$2:$C$51=R6)*(Data!$K$2:$K$51))","v":7.6999999999999999E-2}]
[5,"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":"Oregon"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C7)*(Data!$C$2:$C$51=B7)*(Data!$D$2:$D$51))","v":3899353},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F7)*(Data!$R$2:$R$51=A7),0),0))","v":"Colorado"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G7)*(Data!$C$2:$C$51=F7)*(Data!$H$2:$H$51))","v":49.33},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J7)*(Data!$S$2:$S$51=A7),0),0))","v":"Oregon"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K7)*(Data!$C$2:$C$51=J7)*(Data!$I$2:$I$51))","v":22716602000},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N7)*(Data!$T$2:$T$51=A7),0),0))","v":"Oregon"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O7)*(Data!$C$2:$C$51=N7)*(Data!$J$2:$J$51))","v":44569946155},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R7)*(Data!$U$2:$U$51=A7),0),0))","v":"Washington"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S7)*(Data!$C$2:$C$51=R7)*(Data!$K$2:$K$51))","v":7.0000000000000007E-2}]
[6,"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":"Utah"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C8)*(Data!$C$2:$C$51=B8)*(Data!$D$2:$D$51))","v":2855287},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F8)*(Data!$R$2:$R$51=A8),0),0))","v":"Oregon"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G8)*(Data!$C$2:$C$51=F8)*(Data!$H$2:$H$51))","v":40.33},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J8)*(Data!$S$2:$S$51=A8),0),0))","v":"Utah"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K8)*(Data!$C$2:$C$51=J8)*(Data!$I$2:$I$51))","v":15642129000},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N8)*(Data!$T$2:$T$51=A8),0),0))","v":"Utah"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O8)*(Data!$C$2:$C$51=N8)*(Data!$J$2:$J$51))","v":32148813620},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R8)*(Data!$U$2:$U$51=A8),0),0))","v":"Colorado"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S8)*(Data!$C$2:$C$51=R8)*(Data!$K$2:$K$51))","v":6.8000000000000005E-2}]
[7,"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":"Nevada"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C9)*(Data!$C$2:$C$51=B9)*(Data!$D$2:$D$51))","v":2758931},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F9)*(Data!$R$2:$R$51=A9),0),0))","v":"Utah"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G9)*(Data!$C$2:$C$51=F9)*(Data!$H$2:$H$51))","v":34.299999999999997},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J9)*(Data!$S$2:$S$51=A9),0),0))","v":"Nevada"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K9)*(Data!$C$2:$C$51=J9)*(Data!$I$2:$I$51))","v":13727425000},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N9)*(Data!$T$2:$T$51=A9),0),0))","v":"Nevada"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O9)*(Data!$C$2:$C$51=N9)*(Data!$J$2:$J$51))","v":31418158765},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R9)*(Data!$U$2:$U$51=A9),0),0))","v":"Idaho"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S9)*(Data!$C$2:$C$51=R9)*(Data!$K$2:$K$51))","v":6.7000000000000004E-2}]
[8,"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":"New Mexico"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C10)*(Data!$C$2:$C$51=B10)*(Data!$D$2:$D$51))","v":2085538},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F10)*(Data!$R$2:$R$51=A10),0),0))","v":"Nevada"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G10)*(Data!$C$2:$C$51=F10)*(Data!$H$2:$H$51))","v":24.8},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J10)*(Data!$S$2:$S$51=A10),0),0))","v":"New Mexico"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K10)*(Data!$C$2:$C$51=J10)*(Data!$I$2:$I$51))","v":7866206000},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N10)*(Data!$T$2:$T$51=A10),0),0))","v":"New Mexico"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O10)*(Data!$C$2:$C$51=N10)*(Data!$J$2:$J$51))","v":24111610215},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R10)*(Data!$U$2:$U$51=A10),0),0))","v":"New Mexico"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S10)*(Data!$C$2:$C$51=R10)*(Data!$K$2:$K$51))","v":6.6000000000000003E-2}]
[9,"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=C11)*(Data!$C$2:$C$51=B11)*(Data!$D$2:$D$51))","v":1595728},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F11)*(Data!$R$2:$R$51=A11),0),0))","v":"Idaho"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G11)*(Data!$C$2:$C$51=F11)*(Data!$H$2:$H$51))","v":19.5},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J11)*(Data!$S$2:$S$51=A11),0),0))","v":"Idaho"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K11)*(Data!$C$2:$C$51=J11)*(Data!$I$2:$I$51))","v":7622490000},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N11)*(Data!$T$2:$T$51=A11),0),0))","v":"Idaho"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O11)*(Data!$C$2:$C$51=N11)*(Data!$J$2:$J$51))","v":18631698802.5},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R11)*(Data!$U$2:$U$51=A11),0),0))","v":"Alaska"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S11)*(Data!$C$2:$C$51=R11)*(Data!$K$2:$K$51))","v":6.5000000000000002E-2}]
[10,"The West",{"$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":"Hawaii"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C12)*(Data!$C$2:$C$51=B12)*(Data!$D$2:$D$51))","v":1392313},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F12)*(Data!$R$2:$R$51=A12),0),0))","v":"New Mexico"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G12)*(Data!$C$2:$C$51=F12)*(Data!$H$2:$H$51))","v":17.16},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J12)*(Data!$S$2:$S$51=A12),0),0))","v":"Hawaii"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K12)*(Data!$C$2:$C$51=J12)*(Data!$I$2:$I$51))","v":6511578000},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N12)*(Data!$T$2:$T$51=A12),0),0))","v":"Hawaii"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O12)*(Data!$C$2:$C$51=N12)*(Data!$J$2:$J$51))","v":15709079382.5},null,"The West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R12)*(Data!$U$2:$U$51=A12),0),0))","v":"Montana"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S12)*(Data!$C$2:$C$51=R12)*(Data!$K$2:$K$51))","v":5.2000000000000005E-2}]
[1,"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":"Texas"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C13)*(Data!$C$2:$C$51=B13)*(Data!$D$2:$D$51))","v":26059203},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F13)*(Data!$R$2:$R$51=A13),0),0))","v":"Florida"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G13)*(Data!$C$2:$C$51=F13)*(Data!$H$2:$H$51))","v":360.2},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J13)*(Data!$S$2:$S$51=A13),0),0))","v":"Texas"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K13)*(Data!$C$2:$C$51=J13)*(Data!$I$2:$I$51))","v":219459878000},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N13)*(Data!$T$2:$T$51=A13),0),0))","v":"Texas"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O13)*(Data!$C$2:$C$51=N13)*(Data!$J$2:$J$51))","v":293723251710},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R13)*(Data!$U$2:$U$51=A13),0),0))","v":"Mississippi"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S13)*(Data!$C$2:$C$51=R13)*(Data!$K$2:$K$51))","v":8.5000000000000006E-2}]
[2,"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":"Florida"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C14)*(Data!$C$2:$C$51=B14)*(Data!$D$2:$D$51))","v":19317568},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F14)*(Data!$R$2:$R$51=A14),0),0))","v":"Virginia"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G14)*(Data!$C$2:$C$51=F14)*(Data!$H$2:$H$51))","v":207.3},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J14)*(Data!$S$2:$S$51=A14),0),0))","v":"Florida"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K14)*(Data!$C$2:$C$51=J14)*(Data!$I$2:$I$51))","v":122249635000},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N14)*(Data!$T$2:$T$51=A14),0),0))","v":"Florida"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O14)*(Data!$C$2:$C$51=N14)*(Data!$J$2:$J$51))","v":219561783927.5},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R14)*(Data!$U$2:$U$51=A14),0),0))","v":"Tennessee"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S14)*(Data!$C$2:$C$51=R14)*(Data!$K$2:$K$51))","v":8.4000000000000005E-2}]
[3,"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=C15)*(Data!$C$2:$C$51=B15)*(Data!$D$2:$D$51))","v":9919945},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F15)*(Data!$R$2:$R$51=A15),0),0))","v":"North Carolina"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G15)*(Data!$C$2:$C$51=F15)*(Data!$H$2:$H$51))","v":200.6},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J15)*(Data!$S$2:$S$51=A15),0),0))","v":"Georgia"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K15)*(Data!$C$2:$C$51=J15)*(Data!$I$2:$I$51))","v":65498308000},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N15)*(Data!$T$2:$T$51=A15),0),0))","v":"Georgia"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O15)*(Data!$C$2:$C$51=N15)*(Data!$J$2:$J$51))","v":113251502525},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R15)*(Data!$U$2:$U$51=A15),0),0))","v":"Kentucky"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S15)*(Data!$C$2:$C$51=R15)*(Data!$K$2:$K$51))","v":8.4000000000000005E-2}]
[4,"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":"North Carolina"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C16)*(Data!$C$2:$C$51=B16)*(Data!$D$2:$D$51))","v":9752073},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F16)*(Data!$R$2:$R$51=A16),0),0))","v":"Georgia"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G16)*(Data!$C$2:$C$51=F16)*(Data!$H$2:$H$51))","v":172.5},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J16)*(Data!$S$2:$S$51=A16),0),0))","v":"Virginia"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K16)*(Data!$C$2:$C$51=J16)*(Data!$I$2:$I$51))","v":64297400000},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N16)*(Data!$T$2:$T$51=A16),0),0))","v":"Virginia"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O16)*(Data!$C$2:$C$51=N16)*(Data!$J$2:$J$51))","v":93523821440},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R16)*(Data!$U$2:$U$51=A16),0),0))","v":"Georgia"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S16)*(Data!$C$2:$C$51=R16)*(Data!$K$2:$K$51))","v":8.1000000000000003E-2}]
[5,"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":"Virginia"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C17)*(Data!$C$2:$C$51=B17)*(Data!$D$2:$D$51))","v":8185867},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F17)*(Data!$R$2:$R$51=A17),0),0))","v":"South Carolina"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G17)*(Data!$C$2:$C$51=F17)*(Data!$H$2:$H$51))","v":157.1},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J17)*(Data!$S$2:$S$51=A17),0),0))","v":"North Carolina"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K17)*(Data!$C$2:$C$51=J17)*(Data!$I$2:$I$51))","v":61600064000},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N17)*(Data!$T$2:$T$51=A17),0),0))","v":"North Carolina"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O17)*(Data!$C$2:$C$51=N17)*(Data!$J$2:$J$51))","v":111424865387.5},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R17)*(Data!$U$2:$U$51=A17),0),0))","v":"North Carolina"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S17)*(Data!$C$2:$C$51=R17)*(Data!$K$2:$K$51))","v":0.08}]
[6,"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":"Tennessee"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C18)*(Data!$C$2:$C$51=B18)*(Data!$D$2:$D$51))","v":6456243},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F18)*(Data!$R$2:$R$51=A18),0),0))","v":"Tennessee"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G18)*(Data!$C$2:$C$51=F18)*(Data!$H$2:$H$51))","v":156.6},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J18)*(Data!$S$2:$S$51=A18),0),0))","v":"Tennessee"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K18)*(Data!$C$2:$C$51=J18)*(Data!$I$2:$I$51))","v":47010303000},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N18)*(Data!$T$2:$T$51=A18),0),0))","v":"Tennessee"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O18)*(Data!$C$2:$C$51=N18)*(Data!$J$2:$J$51))","v":74161467782.5},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R18)*(Data!$U$2:$U$51=A18),0),0))","v":"South Carolina"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S18)*(Data!$C$2:$C$51=R18)*(Data!$K$2:$K$51))","v":7.4999999999999997E-2}]
[7,"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=C19)*(Data!$C$2:$C$51=B19)*(Data!$D$2:$D$51))","v":4822023},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F19)*(Data!$R$2:$R$51=A19),0),0))","v":"Kentucky"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G19)*(Data!$C$2:$C$51=F19)*(Data!$H$2:$H$51))","v":110},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J19)*(Data!$S$2:$S$51=A19),0),0))","v":"Louisiana"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K19)*(Data!$C$2:$C$51=J19)*(Data!$I$2:$I$51))","v":34811072000},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N19)*(Data!$T$2:$T$51=A19),0),0))","v":"Louisiana"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O19)*(Data!$C$2:$C$51=N19)*(Data!$J$2:$J$51))","v":52972476987.5},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R19)*(Data!$U$2:$U$51=A19),0),0))","v":"Arkansas"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S19)*(Data!$C$2:$C$51=R19)*(Data!$K$2:$K$51))","v":7.4999999999999997E-2}]
[8,"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":"South Carolina"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C20)*(Data!$C$2:$C$51=B20)*(Data!$D$2:$D$51))","v":4723723},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F20)*(Data!$R$2:$R$51=A20),0),0))","v":"Louisiana"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G20)*(Data!$C$2:$C$51=F20)*(Data!$H$2:$H$51))","v":105},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J20)*(Data!$S$2:$S$51=A20),0),0))","v":"Oklahoma"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K20)*(Data!$C$2:$C$51=J20)*(Data!$I$2:$I$51))","v":27087264000},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N20)*(Data!$T$2:$T$51=A20),0),0))","v":"Oklahoma"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O20)*(Data!$C$2:$C$51=N20)*(Data!$J$2:$J$51))","v":43839291300},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R20)*(Data!$U$2:$U$51=A20),0),0))","v":"Florida"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S20)*(Data!$C$2:$C$51=R20)*(Data!$K$2:$K$51))","v":6.7000000000000004E-2}]
[9,"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":"Louisiana"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C21)*(Data!$C$2:$C$51=B21)*(Data!$D$2:$D$51))","v":4601893},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F21)*(Data!$R$2:$R$51=A21),0),0))","v":"Texas"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G21)*(Data!$C$2:$C$51=F21)*(Data!$H$2:$H$51))","v":98.07},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J21)*(Data!$S$2:$S$51=A21),0),0))","v":"Arkansas"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K21)*(Data!$C$2:$C$51=J21)*(Data!$I$2:$I$51))","v":25299832000},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N21)*(Data!$T$2:$T$51=A21),0),0))","v":"Arkansas"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O21)*(Data!$C$2:$C$51=N21)*(Data!$J$2:$J$51))","v":33975450757.499996},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R21)*(Data!$U$2:$U$51=A21),0),0))","v":"Alabama"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S21)*(Data!$C$2:$C$51=R21)*(Data!$K$2:$K$51))","v":6.5000000000000002E-2}]
[10,"The South",{"$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":"Kentucky"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C22)*(Data!$C$2:$C$51=B22)*(Data!$D$2:$D$51))","v":4380415},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F22)*(Data!$R$2:$R$51=A22),0),0))","v":"Alabama"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G22)*(Data!$C$2:$C$51=F22)*(Data!$H$2:$H$51))","v":94.65},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J22)*(Data!$S$2:$S$51=A22),0),0))","v":"Kentucky"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K22)*(Data!$C$2:$C$51=J22)*(Data!$I$2:$I$51))","v":25085813000},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N22)*(Data!$T$2:$T$51=A22),0),0))","v":"Kentucky"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O22)*(Data!$C$2:$C$51=N22)*(Data!$J$2:$J$51))","v":50780512422.5},null,"The South",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R22)*(Data!$U$2:$U$51=A22),0),0))","v":"Louisiana"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S22)*(Data!$C$2:$C$51=R22)*(Data!$K$2:$K$51))","v":6.5000000000000002E-2}]
[1,"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":"New York"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C23)*(Data!$C$2:$C$51=B23)*(Data!$D$2:$D$51))","v":19570261},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F23)*(Data!$R$2:$R$51=A23),0),0))","v":"New Jersey"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G23)*(Data!$C$2:$C$51=F23)*(Data!$H$2:$H$51))","v":1189},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J23)*(Data!$S$2:$S$51=A23),0),0))","v":"New York"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K23)*(Data!$C$2:$C$51=J23)*(Data!$I$2:$I$51))","v":201167954000},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N23)*(Data!$T$2:$T$51=A23),0),0))","v":"New York"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O23)*(Data!$C$2:$C$51=N23)*(Data!$J$2:$J$51))","v":226137677622.5},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R23)*(Data!$U$2:$U$51=A23),0),0))","v":"Rhode Island"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S23)*(Data!$C$2:$C$51=R23)*(Data!$K$2:$K$51))","v":9.1999999999999998E-2}]
[2,"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":"Pennsylvania"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C24)*(Data!$C$2:$C$51=B24)*(Data!$D$2:$D$51))","v":12763536},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F24)*(Data!$R$2:$R$51=A24),0),0))","v":"Massachusetts"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G24)*(Data!$C$2:$C$51=F24)*(Data!$H$2:$H$51))","v":852.1},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J24)*(Data!$S$2:$S$51=A24),0),0))","v":"New Jersey"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K24)*(Data!$C$2:$C$51=J24)*(Data!$I$2:$I$51))","v":111377490000},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N24)*(Data!$T$2:$T$51=A24),0),0))","v":"New Jersey"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O24)*(Data!$C$2:$C$51=N24)*(Data!$J$2:$J$51))","v":102657007127.5},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R24)*(Data!$U$2:$U$51=A24),0),0))","v":"New Jersey"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S24)*(Data!$C$2:$C$51=R24)*(Data!$K$2:$K$51))","v":8.4000000000000005E-2}]
[3,"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":"New Jersey"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C25)*(Data!$C$2:$C$51=B25)*(Data!$D$2:$D$51))","v":8864590},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F25)*(Data!$R$2:$R$51=A25),0),0))","v":"Connecticut"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G25)*(Data!$C$2:$C$51=F25)*(Data!$H$2:$H$51))","v":741.4},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J25)*(Data!$S$2:$S$51=A25),0),0))","v":"Pennsylvania"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K25)*(Data!$C$2:$C$51=J25)*(Data!$I$2:$I$51))","v":108961515000},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N25)*(Data!$T$2:$T$51=A25),0),0))","v":"Pennsylvania"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O25)*(Data!$C$2:$C$51=N25)*(Data!$J$2:$J$51))","v":148322935565},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R25)*(Data!$U$2:$U$51=A25),0),0))","v":"Connecticut"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S25)*(Data!$C$2:$C$51=R25)*(Data!$K$2:$K$51))","v":7.9000000000000001E-2}]
[4,"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":"Massachusetts"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C26)*(Data!$C$2:$C$51=B26)*(Data!$D$2:$D$51))","v":6646144},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F26)*(Data!$R$2:$R$51=A26),0),0))","v":"Maryland"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G26)*(Data!$C$2:$C$51=F26)*(Data!$H$2:$H$51))","v":606.20000000000005},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J26)*(Data!$S$2:$S$51=A26),0),0))","v":"Massachusetts"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K26)*(Data!$C$2:$C$51=J26)*(Data!$I$2:$I$51))","v":79826976000},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N26)*(Data!$T$2:$T$51=A26),0),0))","v":"Massachusetts"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O26)*(Data!$C$2:$C$51=N26)*(Data!$J$2:$J$51))","v":76353432347.5},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R26)*(Data!$U$2:$U$51=A26),0),0))","v":"New York"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S26)*(Data!$C$2:$C$51=R26)*(Data!$K$2:$K$51))","v":7.6999999999999999E-2}]
[5,"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":"Maryland"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C27)*(Data!$C$2:$C$51=B27)*(Data!$D$2:$D$51))","v":5884563},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F27)*(Data!$R$2:$R$51=A27),0),0))","v":"Delaware"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G27)*(Data!$C$2:$C$51=F27)*(Data!$H$2:$H$51))","v":470.7},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J27)*(Data!$S$2:$S$51=A27),0),0))","v":"Maryland"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K27)*(Data!$C$2:$C$51=J27)*(Data!$I$2:$I$51))","v":48107002000},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N27)*(Data!$T$2:$T$51=A27),0),0))","v":"Maryland"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O27)*(Data!$C$2:$C$51=N27)*(Data!$J$2:$J$51))","v":67585574087.5},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R27)*(Data!$U$2:$U$51=A27),0),0))","v":"Pennsylvania"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S27)*(Data!$C$2:$C$51=R27)*(Data!$K$2:$K$51))","v":7.4999999999999997E-2}]
[6,"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":"Connecticut"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C28)*(Data!$C$2:$C$51=B28)*(Data!$D$2:$D$51))","v":3590347},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F28)*(Data!$R$2:$R$51=A28),0),0))","v":"New York"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G28)*(Data!$C$2:$C$51=F28)*(Data!$H$2:$H$51))","v":415.3},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J28)*(Data!$S$2:$S$51=A28),0),0))","v":"Connecticut"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K28)*(Data!$C$2:$C$51=J28)*(Data!$I$2:$I$51))","v":47262702000},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N28)*(Data!$T$2:$T$51=A28),0),0))","v":"Connecticut"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O28)*(Data!$C$2:$C$51=N28)*(Data!$J$2:$J$51))","v":41647326735},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R28)*(Data!$U$2:$U$51=A28),0),0))","v":"Massachusetts"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S28)*(Data!$C$2:$C$51=R28)*(Data!$K$2:$K$51))","v":7.2000000000000008E-2}]
[7,"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=C29)*(Data!$C$2:$C$51=B29)*(Data!$D$2:$D$51))","v":1329192},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F29)*(Data!$R$2:$R$51=A29),0),0))","v":"Pennsylvania"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G29)*(Data!$C$2:$C$51=F29)*(Data!$H$2:$H$51))","v":285.3},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J29)*(Data!$S$2:$S$51=A29),0),0))","v":"Delaware"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K29)*(Data!$C$2:$C$51=J29)*(Data!$I$2:$I$51))","v":21835412000},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N29)*(Data!$T$2:$T$51=A29),0),0))","v":"Delaware"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O29)*(Data!$C$2:$C$51=N29)*(Data!$J$2:$J$51))","v":10594495397.5},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R29)*(Data!$U$2:$U$51=A29),0),0))","v":"Delaware"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S29)*(Data!$C$2:$C$51=R29)*(Data!$K$2:$K$51))","v":6.8000000000000005E-2}]
[8,"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":"New Hampshire"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C30)*(Data!$C$2:$C$51=B30)*(Data!$D$2:$D$51))","v":1320718},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F30)*(Data!$R$2:$R$51=A30),0),0))","v":"New Hampshire"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G30)*(Data!$C$2:$C$51=F30)*(Data!$H$2:$H$51))","v":147},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J30)*(Data!$S$2:$S$51=A30),0),0))","v":"Rhode Island"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K30)*(Data!$C$2:$C$51=J30)*(Data!$I$2:$I$51))","v":10992338000},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N30)*(Data!$T$2:$T$51=A30),0),0))","v":"Rhode Island"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O30)*(Data!$C$2:$C$51=N30)*(Data!$J$2:$J$51))","v":12421132535},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R30)*(Data!$U$2:$U$51=A30),0),0))","v":"Maryland"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S30)*(Data!$C$2:$C$51=R30)*(Data!$K$2:$K$51))","v":6.7000000000000004E-2}]
[9,"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":"Rhode Island"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C31)*(Data!$C$2:$C$51=B31)*(Data!$D$2:$D$51))","v":1050292},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F31)*(Data!$R$2:$R$51=A31),0),0))","v":"Rhode Island"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G31)*(Data!$C$2:$C$51=F31)*(Data!$H$2:$H$51))","v":100.6},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J31)*(Data!$S$2:$S$51=A31),0),0))","v":"New Hampshire"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K31)*(Data!$C$2:$C$51=J31)*(Data!$I$2:$I$51))","v":8807691000},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N31)*(Data!$T$2:$T$51=A31),0),0))","v":"New Hampshire"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O31)*(Data!$C$2:$C$51=N31)*(Data!$J$2:$J$51))","v":15343751955},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R31)*(Data!$U$2:$U$51=A31),0),0))","v":"Maine"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S31)*(Data!$C$2:$C$51=R31)*(Data!$K$2:$K$51))","v":6.7000000000000004E-2}]
[10,"The North-East",{"$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":"Delaware"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C32)*(Data!$C$2:$C$51=B32)*(Data!$D$2:$D$51))","v":917092},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F32)*(Data!$R$2:$R$51=A32),0),0))","v":"Vermont"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G32)*(Data!$C$2:$C$51=F32)*(Data!$H$2:$H$51))","v":67.73},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J32)*(Data!$S$2:$S$51=A32),0),0))","v":"Maine"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K32)*(Data!$C$2:$C$51=J32)*(Data!$I$2:$I$51))","v":6229189000},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N32)*(Data!$T$2:$T$51=A32),0),0))","v":"Maine"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O32)*(Data!$C$2:$C$51=N32)*(Data!$J$2:$J$51))","v":15343751955},null,"The North-East",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R32)*(Data!$U$2:$U$51=A32),0),0))","v":"New Hampshire"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S32)*(Data!$C$2:$C$51=R32)*(Data!$K$2:$K$51))","v":5.0999999999999997E-2}]
[1,"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":"Illinois"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C33)*(Data!$C$2:$C$51=B33)*(Data!$D$2:$D$51))","v":12875255},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F33)*(Data!$R$2:$R$51=A33),0),0))","v":"Ohio"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G33)*(Data!$C$2:$C$51=F33)*(Data!$H$2:$H$51))","v":282.5},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J33)*(Data!$S$2:$S$51=A33),0),0))","v":"Illinois"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K33)*(Data!$C$2:$C$51=J33)*(Data!$I$2:$I$51))","v":124431227000},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N33)*(Data!$T$2:$T$51=A33),0),0))","v":"Illinois"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O33)*(Data!$C$2:$C$51=N33)*(Data!$J$2:$J$51))","v":149784245275},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R33)*(Data!$U$2:$U$51=A33),0),0))","v":"Michigan"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S33)*(Data!$C$2:$C$51=R33)*(Data!$K$2:$K$51))","v":0.09}]
[2,"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=C34)*(Data!$C$2:$C$51=B34)*(Data!$D$2:$D$51))","v":11544225},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F34)*(Data!$R$2:$R$51=A34),0),0))","v":"Illinois"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G34)*(Data!$C$2:$C$51=F34)*(Data!$H$2:$H$51))","v":231.9},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J34)*(Data!$S$2:$S$51=A34),0),0))","v":"Ohio"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K34)*(Data!$C$2:$C$51=J34)*(Data!$I$2:$I$51))","v":111094276000},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N34)*(Data!$T$2:$T$51=A34),0),0))","v":"Ohio"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O34)*(Data!$C$2:$C$51=N34)*(Data!$J$2:$J$51))","v":134805820747.50002},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R34)*(Data!$U$2:$U$51=A34),0),0))","v":"Illinois"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S34)*(Data!$C$2:$C$51=R34)*(Data!$K$2:$K$51))","v":8.900000000000001E-2}]
[3,"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":"Michigan"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C35)*(Data!$C$2:$C$51=B35)*(Data!$D$2:$D$51))","v":9883360},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F35)*(Data!$R$2:$R$51=A35),0),0))","v":"Indiana"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G35)*(Data!$C$2:$C$51=F35)*(Data!$H$2:$H$51))","v":182.5},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J35)*(Data!$S$2:$S$51=A35),0),0))","v":"Minnesota"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K35)*(Data!$C$2:$C$51=J35)*(Data!$I$2:$I$51))","v":78685402000},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N35)*(Data!$T$2:$T$51=A35),0),0))","v":"Minnesota"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O35)*(Data!$C$2:$C$51=N35)*(Data!$J$2:$J$51))","v":62105662675.000008},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R35)*(Data!$U$2:$U$51=A35),0),0))","v":"Ohio"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S35)*(Data!$C$2:$C$51=R35)*(Data!$K$2:$K$51))","v":7.4999999999999997E-2}]
[4,"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=C36)*(Data!$C$2:$C$51=B36)*(Data!$D$2:$D$51))","v":6537334},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F36)*(Data!$R$2:$R$51=A36),0),0))","v":"Michigan"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G36)*(Data!$C$2:$C$51=F36)*(Data!$H$2:$H$51))","v":174.8},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J36)*(Data!$S$2:$S$51=A36),0),0))","v":"Michigan"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K36)*(Data!$C$2:$C$51=J36)*(Data!$I$2:$I$51))","v":59210158000},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N36)*(Data!$T$2:$T$51=A36),0),0))","v":"Michigan"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O36)*(Data!$C$2:$C$51=N36)*(Data!$J$2:$J$51))","v":115443467090.00002},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R36)*(Data!$U$2:$U$51=A36),0),0))","v":"Indiana"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S36)*(Data!$C$2:$C$51=R36)*(Data!$K$2:$K$51))","v":7.4999999999999997E-2}]
[5,"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=C37)*(Data!$C$2:$C$51=B37)*(Data!$D$2:$D$51))","v":6021988},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F37)*(Data!$R$2:$R$51=A37),0),0))","v":"Wisconsin"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G37)*(Data!$C$2:$C$51=F37)*(Data!$H$2:$H$51))","v":105.2},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J37)*(Data!$S$2:$S$51=A37),0),0))","v":"Indiana"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K37)*(Data!$C$2:$C$51=J37)*(Data!$I$2:$I$51))","v":51238512000},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N37)*(Data!$T$2:$T$51=A37),0),0))","v":"Indiana"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O37)*(Data!$C$2:$C$51=N37)*(Data!$J$2:$J$51))","v":75622777492.5},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R37)*(Data!$U$2:$U$51=A37),0),0))","v":"Missouri"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S37)*(Data!$C$2:$C$51=R37)*(Data!$K$2:$K$51))","v":6.5000000000000002E-2}]
[6,"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":"Wisconsin"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C38)*(Data!$C$2:$C$51=B38)*(Data!$D$2:$D$51))","v":5726398},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F38)*(Data!$R$2:$R$51=A38),0),0))","v":"Missouri"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G38)*(Data!$C$2:$C$51=F38)*(Data!$H$2:$H$51))","v":87.26},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J38)*(Data!$S$2:$S$51=A38),0),0))","v":"Missouri"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K38)*(Data!$C$2:$C$51=J38)*(Data!$I$2:$I$51))","v":48413247000},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N38)*(Data!$T$2:$T$51=A38),0),0))","v":"Missouri"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O38)*(Data!$C$2:$C$51=N38)*(Data!$J$2:$J$51))","v":69777538652.5},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R38)*(Data!$U$2:$U$51=A38),0),0))","v":"Wisconsin"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S38)*(Data!$C$2:$C$51=R38)*(Data!$K$2:$K$51))","v":6.5000000000000002E-2}]
[7,"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":"Minnesota"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C39)*(Data!$C$2:$C$51=B39)*(Data!$D$2:$D$51))","v":5379139},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F39)*(Data!$R$2:$R$51=A39),0),0))","v":"Minnesota"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G39)*(Data!$C$2:$C$51=F39)*(Data!$H$2:$H$51))","v":67.14},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J39)*(Data!$S$2:$S$51=A39),0),0))","v":"Wisconsin"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K39)*(Data!$C$2:$C$51=J39)*(Data!$I$2:$I$51))","v":41498033000},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N39)*(Data!$T$2:$T$51=A39),0),0))","v":"Wisconsin"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O39)*(Data!$C$2:$C$51=N39)*(Data!$J$2:$J$51))","v":66489591805},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R39)*(Data!$U$2:$U$51=A39),0),0))","v":"Kansas"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S39)*(Data!$C$2:$C$51=R39)*(Data!$K$2:$K$51))","v":5.5999999999999994E-2}]
[8,"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":"Iowa"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C40)*(Data!$C$2:$C$51=B40)*(Data!$D$2:$D$51))","v":3074186},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F40)*(Data!$R$2:$R$51=A40),0),0))","v":"Iowa"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G40)*(Data!$C$2:$C$51=F40)*(Data!$H$2:$H$51))","v":54.81},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J40)*(Data!$S$2:$S$51=A40),0),0))","v":"Kansas"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K40)*(Data!$C$2:$C$51=J40)*(Data!$I$2:$I$51))","v":21904615000},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N40)*(Data!$T$2:$T$51=A40),0),0))","v":"Kansas"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O40)*(Data!$C$2:$C$51=N40)*(Data!$J$2:$J$51))","v":33244795902.5},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R40)*(Data!$U$2:$U$51=A40),0),0))","v":"Minnesota"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S40)*(Data!$C$2:$C$51=R40)*(Data!$K$2:$K$51))","v":4.8000000000000001E-2}]
[9,"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":"Kansas"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C41)*(Data!$C$2:$C$51=B41)*(Data!$D$2:$D$51))","v":2885905},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F41)*(Data!$R$2:$R$51=A41),0),0))","v":"Kansas"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G41)*(Data!$C$2:$C$51=F41)*(Data!$H$2:$H$51))","v":35.090000000000003},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J41)*(Data!$S$2:$S$51=A41),0),0))","v":"Nebraska"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K41)*(Data!$C$2:$C$51=J41)*(Data!$I$2:$I$51))","v":19795254000},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N41)*(Data!$T$2:$T$51=A41),0),0))","v":"Nebraska"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O41)*(Data!$C$2:$C$51=N41)*(Data!$J$2:$J$51))","v":21188990795},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R41)*(Data!$U$2:$U$51=A41),0),0))","v":"Iowa"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S41)*(Data!$C$2:$C$51=R41)*(Data!$K$2:$K$51))","v":4.5999999999999999E-2}]
[10,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=B42)*(Data!$Q$2:$Q$51=A42),0),0))","v":"Nebraska"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C42)*(Data!$C$2:$C$51=B42)*(Data!$D$2:$D$51))","v":1855525},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=F42)*(Data!$R$2:$R$51=A42),0),0))","v":"Nebraska"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=G42)*(Data!$C$2:$C$51=F42)*(Data!$H$2:$H$51))","v":23.97},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=J42)*(Data!$S$2:$S$51=A42),0),0))","v":"Iowa"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=K42)*(Data!$C$2:$C$51=J42)*(Data!$I$2:$I$51))","v":18753596000},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=N42)*(Data!$T$2:$T$51=A42),0),0))","v":"Iowa"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=O42)*(Data!$C$2:$C$51=N42)*(Data!$J$2:$J$51))","v":35436760467.5},null,"The Mid-West",{"$f":"INDEX(Data!$B$2:$B$51,MATCH(1,INDEX((Data!$C$2:$C$51=R42)*(Data!$U$2:$U$51=A42),0),0))","v":"Nebraska"},{"$f":"SUMPRODUCT((Data!$B$2:$B$51=S42)*(Data!$C$2:$C$51=R42)*(Data!$K$2:$K$51))","v":3.9E-2}]
[1,"All Regions",{"$f":"INDEX(C$3:C$42,MATCH(VLOOKUP(LARGE(D$3:D$42,A43),D$3:D$42,1,0),D$3:D$42,0),1)","v":"California"},{"$f":"VLOOKUP(LARGE(D$3:D$42,A43),D$3:D$42,1,0)","v":38041430},null,"All Regions",{"$f":"INDEX(G$3:G$42,MATCH(VLOOKUP(LARGE(H$3:H$42,$A43),H$3:H$42,1,0),H$3:H$42,0),1)","v":"New Jersey"},{"$f":"VLOOKUP(LARGE(H$3:H$42,$A43),H$3:H$42,1,0)","v":1189},null,"All Regions",{"$f":"INDEX(K$3:K$42,MATCH(VLOOKUP(LARGE(L$3:L$42,$A43),L$3:L$42,1,0),L$3:L$42,0),1)","v":"California"},{"$f":"VLOOKUP(LARGE(L$3:L$42,$A43),L$3:L$42,1,0)","v":292563574000},null,"All Regions",{"$f":"INDEX(O$3:O$42,MATCH(VLOOKUP(LARGE(P$3:P$42,$A43),P$3:P$42,1,0),P$3:P$42,0),1)","v":"California"},{"$f":"VLOOKUP(LARGE(P$3:P$42,$A43),P$3:P$42,1,0)","v":435914805277.5},null,"All Regions",{"$f":"INDEX(S$3:S$42,MATCH(VLOOKUP(LARGE(T$3:T$42,$A43),T$3:T$42,1,0),T$3:T$42,0),1)","v":"Nevada"},{"$f":"VLOOKUP(LARGE(T$3:T$42,A43),T$3:T$42,1,0)","v":9.3000000000000013E-2}]
[2,"All Regions","Texas",26059203,null,"All Regions","Massachusetts",852.1,null,"All Regions","Texas",219459878000,null,"All Regions","Texas",293723251710,null,"All Regions","Rhode Island",9.1999999999999998E-2]
[3,"All Regions","New York",19570261,null,"All Regions","Connecticut",741.4,null,"All Regions","New York",201167954000,null,"All Regions","New York",226137677622.5,null,"All Regions","Michigan",0.09]
[4,"All Regions","Florida",19317568,null,"All Regions","Maryland",606.20000000000005,null,"All Regions","Illinois",124431227000,null,"All Regions","Florida",219561783927.5,null,"All Regions","Illinois",8.900000000000001E-2]
[5,"All Regions","Illinois",12875255,null,"All Regions","Delaware",470.7,null,"All Regions","Florida",122249635000,null,"All Regions","Illinois",149784245275,null,"All Regions","California",8.6999999999999994E-2]
[6,"All Regions",{"$f":"INDEX(C$3:C$42,MATCH(VLOOKUP(LARGE(D$3:D$42,A48),D$3:D$42,1,0),D$3:D$42,0),1)","v":"Pennsylvania"},{"$f":"VLOOKUP(LARGE(D$3:D$42,A48),D$3:D$42,1,0)","v":12763536},null,"All Regions",{"$f":"INDEX(G$3:G$42,MATCH(VLOOKUP(LARGE(H$3:H$42,$A48),H$3:H$42,1,0),H$3:H$42,0),1)","v":"New York"},{"$f":"VLOOKUP(LARGE(H$3:H$42,$A48),H$3:H$42,1,0)","v":415.3},null,"All Regions",{"$f":"INDEX(K$3:K$42,MATCH(VLOOKUP(LARGE(L$3:L$42,$A48),L$3:L$42,1,0),L$3:L$42,0),1)","v":"New Jersey"},{"$f":"VLOOKUP(LARGE(L$3:L$42,$A48),L$3:L$42,1,0)","v":111377490000},null,"All Regions",{"$f":"INDEX(O$3:O$42,MATCH(VLOOKUP(LARGE(P$3:P$42,$A48),P$3:P$42,1,0),P$3:P$42,0),1)","v":"Pennsylvania"},{"$f":"VLOOKUP(LARGE(P$3:P$42,$A48),P$3:P$42,1,0)","v":148322935565},null,"All Regions",{"$f":"INDEX(S$3:S$42,MATCH(VLOOKUP(LARGE(T$3:T$42,$A48),T$3:T$42,1,0),T$3:T$42,0),1)","v":"Mississippi"},{"$f":"VLOOKUP(LARGE(T$3:T$42,A48),T$3:T$42,1,0)","v":8.5000000000000006E-2}]
[7,"All Regions",{"$f":"INDEX(C$3:C$42,MATCH(VLOOKUP(LARGE(D$3:D$42,A49),D$3:D$42,1,0),D$3:D$42,0),1)","v":"Ohio"},{"$f":"VLOOKUP(LARGE(D$3:D$42,A49),D$3:D$42,1,0)","v":11544225},null,"All Regions",{"$f":"INDEX(G$3:G$42,MATCH(VLOOKUP(LARGE(H$3:H$42,$A49),H$3:H$42,1,0),H$3:H$42,0),1)","v":"Florida"},{"$f":"VLOOKUP(LARGE(H$3:H$42,$A49),H$3:H$42,1,0)","v":360.2},null,"All Regions",{"$f":"INDEX(K$3:K$42,MATCH(VLOOKUP(LARGE(L$3:L$42,$A49),L$3:L$42,1,0),L$3:L$42,0),1)","v":"Ohio"},{"$f":"VLOOKUP(LARGE(L$3:L$42,$A49),L$3:L$42,1,0)","v":111094276000},null,"All Regions",{"$f":"INDEX(O$3:O$42,MATCH(VLOOKUP(LARGE(P$3:P$42,$A49),P$3:P$42,1,0),P$3:P$42,0),1)","v":"Ohio"},{"$f":"VLOOKUP(LARGE(P$3:P$42,$A49),P$3:P$42,1,0)","v":134805820747.50002},null,"All Regions",{"$f":"INDEX(S$3:S$42,MATCH(VLOOKUP(LARGE(T$3:T$42,$A49),T$3:T$42,1,0),T$3:T$42,0),1)","v":"Tennessee"},{"$f":"VLOOKUP(LARGE(T$3:T$42,A49),T$3:T$42,1,0)","v":8.4000000000000005E-2}]
[8,"All Regions","Georgia",9919945,null,"All Regions","Pennsylvania",285.3,null,"All Regions","Pennsylvania",108961515000,null,"All Regions","Michigan",115443467090.00002,null,"All Regions","Tennessee",{"$f":"VLOOKUP(LARGE(T$3:T$42,A50),T$3:T$42,1,0)","v":8.4000000000000005E-2}]
[9,"All Regions","Michigan",9883360,null,"All Regions","Ohio",282.5,null,"All Regions","Massachusetts",79826976000,null,"All Regions","Georgia",113251502525,null,"All Regions","Tennessee",{"$f":"VLOOKUP(LARGE(T$3:T$42,A51),T$3:T$42,1,0)","v":8.4000000000000005E-2}]
[10,"All Regions","North Carolina",9752073,null,"All Regions","California",244.2,null,"All Regions","Minnesota",78685402000,null,"All Regions","North Carolina",111424865387.5,null,"All Regions","Arizona",{"$f":"VLOOKUP(LARGE(T$3:T$42,A52),T$3:T$42,1,0)","v":8.199999999999999E-2}]
[]
["Table & Chart","Region","State","Pop",null,"Region","State","Density",null,"Region","State","Revenue",null,"Region","State","Expenses",null,"Region","State","Unemployment"]
[1,{"$f":"Summary!$D$1","v":"All Regions"},{"$f":"INDEX(C$3:C$52,MATCH(1,INDEX(($A$3:$A$52=$A55)*(B$3:B$52=B55),0),0))","v":"California"},{"$f":"SUMPRODUCT((B$3:B$52=B55)*(C$3:C$52=C55)*(D$3:D$52))","v":38041430},null,{"$f":"$B55","v":"All Regions"},{"$f":"INDEX(G$3:G$52,MATCH(1,INDEX(($A$3:$A$52=$A55)*(F$3:F$52=F55),0),0))","v":"New Jersey"},{"$f":"SUMPRODUCT((F$3:F$52=F55)*(G$3:G$52=G55)*(H$3:H$52))","v":1189},null,{"$f":"$B55","v":"All Regions"},{"$f":"INDEX(K$3:K$52,MATCH(1,INDEX(($A$3:$A$52=$A55)*(J$3:J$52=J55),0),0))","v":"California"},{"$f":"SUMPRODUCT((J$3:J$52=J55)*(K$3:K$52=K55)*(L$3:L$52))/1000","v":292563574},null,{"$f":"$B55","v":"All Regions"},{"$f":"INDEX(O$3:O$52,MATCH(1,INDEX(($A$3:$A$52=$A55)*(N$3:N$52=N55),0),0))","v":"California"},{"$f":"SUMPRODUCT((N$3:N$52=N55)*(O$3:O$52=O55)*(P$3:P$52))/1000","v":435914805.27749997},null,{"$f":"$B55","v":"All Regions"},{"$f":"INDEX(S$3:S$52,MATCH(1,INDEX(($A$3:$A$52=$A55)*(R$3:R$52=R55),0),0))","v":"Nevada"},{"$f":"SUMPRODUCT((R$3:R$52=R55)*(S$3:S$52=S55)*(T$3:T$52))","v":9.3000000000000013E-2}]
[2,{"$f":"Summary!$D$1","v":"All Regions"},{"$f":"INDEX(C$3:C$52,MATCH(1,INDEX(($A$3:$A$52=$A56)*(B$3:B$52=B56),0),0))","v":"Texas"},{"$f":"SUMPRODUCT((B$3:B$52=B56)*(C$3:C$52=C56)*(D$3:D$52))","v":26059203},null,{"$f":"$B56","v":"All Regions"},{"$f":"INDEX(G$3:G$52,MATCH(1,INDEX(($A$3:$A$52=$A56)*(F$3:F$52=F56),0),0))","v":"Massachusetts"},{"$f":"SUMPRODUCT((F$3:F$52=F56)*(G$3:G$52=G56)*(H$3:H$52))","v":852.1},null,{"$f":"$B56","v":"All Regions"},{"$f":"INDEX(K$3:K$52,MATCH(1,INDEX(($A$3:$A$52=$A56)*(J$3:J$52=J56),0),0))","v":"Texas"},{"$f":"SUMPRODUCT((J$3:J$52=J56)*(K$3:K$52=K56)*(L$3:L$52))/1000","v":219459878},null,{"$f":"$B56","v":"All Regions"},{"$f":"INDEX(O$3:O$52,MATCH(1,INDEX(($A$3:$A$52=$A56)*(N$3:N$52=N56),0),0))","v":"Texas"},{"$f":"SUMPRODUCT((N$3:N$52=N56)*(O$3:O$52=O56)*(P$3:P$52))/1000","v":293723251.70999998},null,{"$f":"$B56","v":"All Regions"},{"$f":"INDEX(S$3:S$52,MATCH(1,INDEX(($A$3:$A$52=$A56)*(R$3:R$52=R56),0),0))","v":"Rhode Island"},{"$f":"SUMPRODUCT((R$3:R$52=R56)*(S$3:S$52=S56)*(T$3:T$52))","v":9.1999999999999998E-2}]
[3,{"$f":"Summary!$D$1","v":"All Regions"},{"$f":"INDEX(C$3:C$52,MATCH(1,INDEX(($A$3:$A$52=$A57)*(B$3:B$52=B57),0),0))","v":"New York"},{"$f":"SUMPRODUCT((B$3:B$52=B57)*(C$3:C$52=C57)*(D$3:D$52))","v":19570261},null,"All Regions",{"$f":"INDEX(G$3:G$52,MATCH(1,INDEX(($A$3:$A$52=$A57)*(F$3:F$52=F57),0),0))","v":"Connecticut"},{"$f":"SUMPRODUCT((F$3:F$52=F57)*(G$3:G$52=G57)*(H$3:H$52))","v":741.4},null,"All Regions",{"$f":"INDEX(K$3:K$52,MATCH(1,INDEX(($A$3:$A$52=$A57)*(J$3:J$52=J57),0),0))","v":"New York"},{"$f":"SUMPRODUCT((J$3:J$52=J57)*(K$3:K$52=K57)*(L$3:L$52))/1000","v":201167954},null,"All Regions",{"$f":"INDEX(O$3:O$52,MATCH(1,INDEX(($A$3:$A$52=$A57)*(N$3:N$52=N57),0),0))","v":"New York"},{"$f":"SUMPRODUCT((N$3:N$52=N57)*(O$3:O$52=O57)*(P$3:P$52))/1000","v":226137677.6225},null,"All Regions",{"$f":"INDEX(S$3:S$52,MATCH(1,INDEX(($A$3:$A$52=$A57)*(R$3:R$52=R57),0),0))","v":"Michigan"},{"$f":"SUMPRODUCT((R$3:R$52=R57)*(S$3:S$52=S57)*(T$3:T$52))","v":0.09}]
[4,{"$f":"Summary!$D$1","v":"All Regions"},{"$f":"INDEX(C$3:C$52,MATCH(1,INDEX(($A$3:$A$52=$A58)*(B$3:B$52=B58),0),0))","v":"Florida"},{"$f":"SUMPRODUCT((B$3:B$52=B58)*(C$3:C$52=C58)*(D$3:D$52))","v":19317568},null,"All Regions",{"$f":"INDEX(G$3:G$52,MATCH(1,INDEX(($A$3:$A$52=$A58)*(F$3:F$52=F58),0),0))","v":"Maryland"},{"$f":"SUMPRODUCT((F$3:F$52=F58)*(G$3:G$52=G58)*(H$3:H$52))","v":606.20000000000005},null,"All Regions",{"$f":"INDEX(K$3:K$52,MATCH(1,INDEX(($A$3:$A$52=$A58)*(J$3:J$52=J58),0),0))","v":"Illinois"},{"$f":"SUMPRODUCT((J$3:J$52=J58)*(K$3:K$52=K58)*(L$3:L$52))/1000","v":124431227},null,"All Regions",{"$f":"INDEX(O$3:O$52,MATCH(1,INDEX(($A$3:$A$52=$A58)*(N$3:N$52=N58),0),0))","v":"Florida"},{"$f":"SUMPRODUCT((N$3:N$52=N58)*(O$3:O$52=O58)*(P$3:P$52))/1000","v":219561783.92750001},null,"All Regions",{"$f":"INDEX(S$3:S$52,MATCH(1,INDEX(($A$3:$A$52=$A58)*(R$3:R$52=R58),0),0))","v":"Illinois"},{"$f":"SUMPRODUCT((R$3:R$52=R58)*(S$3:S$52=S58)*(T$3:T$52))","v":8.900000000000001E-2}]
[5,{"$f":"Summary!$D$1","v":"All Regions"},{"$f":"INDEX(C$3:C$52,MATCH(1,INDEX(($A$3:$A$52=$A59)*(B$3:B$52=B59),0),0))","v":"Illinois"},{"$f":"SUMPRODUCT((B$3:B$52=B59)*(C$3:C$52=C59)*(D$3:D$52))","v":12875255},null,"All Regions",{"$f":"INDEX(G$3:G$52,MATCH(1,INDEX(($A$3:$A$52=$A59)*(F$3:F$52=F59),0),0))","v":"Delaware"},{"$f":"SUMPRODUCT((F$3:F$52=F59)*(G$3:G$52=G59)*(H$3:H$52))","v":470.7},null,"All Regions",{"$f":"INDEX(K$3:K$52,MATCH(1,INDEX(($A$3:$A$52=$A59)*(J$3:J$52=J59),0),0))","v":"Florida"},{"$f":"SUMPRODUCT((J$3:J$52=J59)*(K$3:K$52=K59)*(L$3:L$52))/1000","v":122249635},null,"All Regions",{"$f":"INDEX(O$3:O$52,MATCH(1,INDEX(($A$3:$A$52=$A59)*(N$3:N$52=N59),0),0))","v":"Illinois"},{"$f":"SUMPRODUCT((N$3:N$52=N59)*(O$3:O$52=O59)*(P$3:P$52))/1000","v":149784245.27500001},null,"All Regions",{"$f":"INDEX(S$3:S$52,MATCH(1,INDEX(($A$3:$A$52=$A59)*(R$3:R$52=R59),0),0))","v":"California"},{"$f":"SUMPRODUCT((R$3:R$52=R59)*(S$3:S$52=S59)*(T$3:T$52))","v":8.6999999999999994E-2}]
[]
[1,{"$f":"Summary!$D$1","v":"All Regions"},{"$f":"INDEX(C$3:C$52,MATCH(1,INDEX(($A$3:$A$52=$A61)*(B$3:B$52=B61),0),0))","v":"California"},{"$f":"SUMPRODUCT((B$3:B$52=B61)*(C$3:C$52=C61)*(D$3:D$52))","v":38041430},null,{"$f":"$B61","v":"All Regions"},{"$f":"INDEX(G$3:G$52,MATCH(1,INDEX(($A$3:$A$52=$A61)*(F$3:F$52=F61),0),0))","v":"New Jersey"},{"$f":"SUMPRODUCT((F$3:F$52=F61)*(G$3:G$52=G61)*(H$3:H$52))","v":1189},null,{"$f":"$B61","v":"All Regions"},{"$f":"INDEX(K$3:K$52,MATCH(1,INDEX(($A$3:$A$52=$A61)*(J$3:J$52=J61),0),0))","v":"California"},{"$f":"SUMPRODUCT((J$3:J$52=J61)*(K$3:K$52=K61)*(L$3:L$52))/1000","v":292563574},null,{"$f":"$B61","v":"All Regions"},{"$f":"INDEX(O$3:O$52,MATCH(1,INDEX(($A$3:$A$52=$A61)*(N$3:N$52=N61),0),0))","v":"California"},{"$f":"SUMPRODUCT((N$3:N$52=N61)*(O$3:O$52=O61)*(P$3:P$52))/1000","v":435914805.27749997},null,{"$f":"$B61","v":"All Regions"},{"$f":"INDEX(S$3:S$52,MATCH(1,INDEX(($A$3:$A$52=$A61)*(R$3:R$52=R61),0),0))","v":"Nevada"},{"$f":"SUMPRODUCT((R$3:R$52=R61)*(S$3:S$52=S61)*(T$3:T$52))","v":9.3000000000000013E-2}]
[2,{"$f":"Summary!$D$1","v":"All Regions"},"Texas",{"$f":"SUMPRODUCT((B$3:B$52=B62)*(C$3:C$52=C62)*(D$3:D$52))","v":26059203},null,{"$f":"$B62","v":"All Regions"},{"$f":"INDEX(G$3:G$52,MATCH(1,INDEX(($A$3:$A$52=$A62)*(F$3:F$52=F62),0),0))","v":"Massachusetts"},{"$f":"SUMPRODUCT((F$3:F$52=F62)*(G$3:G$52=G62)*(H$3:H$52))","v":852.1},null,{"$f":"$B62","v":"All Regions"},{"$f":"INDEX(K$3:K$52,MATCH(1,INDEX(($A$3:$A$52=$A62)*(J$3:J$52=J62),0),0))","v":"Texas"},{"$f":"SUMPRODUCT((J$3:J$52=J62)*(K$3:K$52=K62)*(L$3:L$52))/1000","v":219459878},null,{"$f":"$B62","v":"All Regions"},{"$f":"INDEX(O$3:O$52,MATCH(1,INDEX(($A$3:$A$52=$A62)*(N$3:N$52=N62),0),0))","v":"Texas"},{"$f":"SUMPRODUCT((N$3:N$52=N62)*(O$3:O$52=O62)*(P$3:P$52))/1000","v":293723251.70999998},null,{"$f":"$B62","v":"All Regions"},{"$f":"INDEX(S$3:S$52,MATCH(1,INDEX(($A$3:$A$52=$A62)*(R$3:R$52=R62),0),0))","v":"Rhode Island"},{"$f":"SUMPRODUCT((R$3:R$52=R62)*(S$3:S$52=S62)*(T$3:T$52))","v":9.1999999999999998E-2}]
[3,{"$f":"Summary!$D$1","v":"All Regions"},"New York",{"$f":"SUMPRODUCT((B$3:B$52=B63)*(C$3:C$52=C63)*(D$3:D$52))","v":19570261},null,"All Regions","Connecticut",741.4,null,"All Regions","New York",201167954,null,"All Regions","New York",226137677.6225,null,"All Regions","Michigan",0.09]
[4,{"$f":"Summary!$D$1","v":"All Regions"},"Florida",{"$f":"SUMPRODUCT((B$3:B$52=B64)*(C$3:C$52=C64)*(D$3:D$52))","v":19317568},null,"All Regions","Maryland",606.20000000000005,null,"All Regions","Illinois",124431227,null,"All Regions","Florida",219561783.92750001,null,"All Regions","Illinois",8.900000000000001E-2]
[5,{"$f":"Summary!$D$1","v":"All Regions"},"Illinois",{"$f":"SUMPRODUCT((B$3:B$52=B65)*(C$3:C$52=C65)*(D$3:D$52))","v":12875255},null,"All Regions","Delaware",470.7,null,"All Regions","Florida",122249635,null,"All Regions","Illinois",149784245.27500001,null,"All Regions","California",8.6999999999999994E-2]
[6,{"$f":"Summary!$D$1","v":"All Regions"},"Pennsylvania",{"$f":"SUMPRODUCT((B$3:B$52=B66)*(C$3:C$52=C66)*(D$3:D$52))","v":12763536},null,"All Regions","New York",415.3,null,"All Regions","New Jersey",111377490,null,"All Regions","Pennsylvania",148322935.565,null,"All Regions","Mississippi",8.5000000000000006E-2]
[7,{"$f":"Summary!$D$1","v":"All Regions"},"Ohio",11544225,null,"All Regions","Florida",360.2,null,"All Regions","Ohio",111094276,null,"All Regions","Ohio",134805820.7475,null,"All Regions","Tennessee",0.252]
[8,{"$f":"Summary!$D$1","v":"All Regions"},"Georgia",9919945,null,"All Regions","Pennsylvania",285.3,null,"All Regions","Pennsylvania",108961515,null,"All Regions","Michigan",115443467.09000002,null,"All Regions","Tennessee",0.252]
[9,{"$f":"Summary!$D$1","v":"All Regions"},"Michigan",9883360,null,"All Regions","Ohio",282.5,null,"All Regions","Massachusetts",79826976,null,"All Regions","Georgia",113251502.52500001,null,"All Regions","Tennessee",0.252]
[10,{"$f":"Summary!$D$1","v":"All Regions"},"North Carolina",9752073,null,"All Regions","California",244.2,null,"All Regions","Minnesota",78685402,null,"All Regions","North Carolina",111424865.3875,null,"All Regions","Arizona",8.199999999999999E-2]
[]
[1,{"$f":"Summary!$D$1","v":"All Regions"},{"$f":"C61","v":"California"},{"$f":"D61","v":38041430},null,{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C72)*(Data!$K$2:$K$51))","v":8.6999999999999994E-2}]
[2,{"$f":"Summary!$D$1","v":"All Regions"},{"$f":"C62","v":"Texas"},26059203,null,{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C73)*(Data!$K$2:$K$51))","v":6.2E-2}]
[3,{"$f":"Summary!$D$1","v":"All Regions"},"New York",19570261,null,{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C74)*(Data!$K$2:$K$51))","v":7.6999999999999999E-2}]
[4,{"$f":"Summary!$D$1","v":"All Regions"},"Florida",19317568,null,{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C75)*(Data!$K$2:$K$51))","v":6.7000000000000004E-2}]
[5,{"$f":"Summary!$D$1","v":"All Regions"},"Illinois",12875255,null,{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C76)*(Data!$K$2:$K$51))","v":8.900000000000001E-2}]
[6,{"$f":"Summary!$D$1","v":"All Regions"},"Pennsylvania",12763536,null,{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C77)*(Data!$K$2:$K$51))","v":7.4999999999999997E-2}]
[7,{"$f":"Summary!$D$1","v":"All Regions"},"Ohio",11544225,null,{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C78)*(Data!$K$2:$K$51))","v":7.4999999999999997E-2}]
[8,{"$f":"Summary!$D$1","v":"All Regions"},"Georgia",9919945,null,{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C79)*(Data!$K$2:$K$51))","v":8.1000000000000003E-2}]
[9,{"$f":"Summary!$D$1","v":"All Regions"},"Michigan",9883360,null,{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C80)*(Data!$K$2:$K$51))","v":0.09}]
[10,{"$f":"Summary!$D$1","v":"All Regions"},"North Carolina",9752073,null,{"$f":"SUMPRODUCT((Data!$B$2:$B$51=C81)*(Data!$K$2:$K$51))","v":0.08}]
[]
[]
[]
[null,"Region","Population 2012","Population 2012",null,"Region","Population 2012","Population 2010"]
[null,"The West",{"$f":"SUMPRODUCT((Data!$C$2:$C$51=$F86)*(Data!$H$2:$H$51))","v":820.04299999999989},{"$f":"SUMPRODUCT((Data!$C$2:$C$51=$F86)*(Data!$D$2:$D$51))","v":73579431},null,"The West",{"$f":"SUMPRODUCT((Data!$C$2:$C$51=$F86)*(Data!D$2:D$51))","v":73579431},{"$f":"SUMPRODUCT((Data!$C$2:$C$51=$F86)*(Data!E$2:E$51))","v":71945553}]
[null,"The South",{"$f":"SUMPRODUCT((Data!$C$2:$C$51=$F87)*(Data!$H$2:$H$51))","v":1914.23},{"$f":"SUMPRODUCT((Data!$C$2:$C$51=$F87)*(Data!$D$2:$D$51))","v":109823243},null,"The South",{"$f":"SUMPRODUCT((Data!$C$2:$C$51=$F87)*(Data!$D$2:$D$51))","v":109823243},{"$f":"SUMPRODUCT((Data!$C$2:$C$51=$F87)*(Data!$D$2:$D$51))","v":109823243}]
[null,"The North-East",{"$f":"SUMPRODUCT((Data!$C$2:$C$51=$F88)*(Data!$H$2:$H$51))","v":4918.37},{"$f":"SUMPRODUCT((Data!$C$2:$C$51=$F88)*(Data!$D$2:$D$51))","v":62562746},null,"The North-East",{"$f":"SUMPRODUCT((Data!$C$2:$C$51=$F88)*(Data!$D$2:$D$51))","v":62562746},{"$f":"SUMPRODUCT((Data!$C$2:$C$51=$F88)*(Data!$D$2:$D$51))","v":62562746}]
[null,"The Mid-West",{"$f":"SUMPRODUCT((Data!$C$2:$C$51=$F89)*(Data!$H$2:$H$51))","v":1265.9459999999999},{"$f":"SUMPRODUCT((Data!$C$2:$C$51=$F89)*(Data!$D$2:$D$51))","v":67316297},null,"The Mid-West",{"$f":"SUMPRODUCT((Data!$C$2:$C$51=$F89)*(Data!$D$2:$D$51))","v":67316297},{"$f":"SUMPRODUCT((Data!$C$2:$C$51=$F89)*(Data!$D$2:$D$51))","v":67316297}]

{"sheet":"Summary","index":4,"n_rows":21,"n_cols":15,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,true,null,{"$f":"IF(B1=TRUE,\"All Regions\",IF(B2=TRUE,\"The West\",IF(B3=TRUE,\"The Mid-West\",IF(B4=TRUE,\"The South\",IF(B5=TRUE,\"The North-East\",\"\")))))","v":"All Regions"}]
[null,false]
[null,false]
[null,false]
[null,false]
[]
[null,null,null,"TOP 5 by Metrics by State and Region"]
[]
[null,"Flag",null,"State","Population",null,null,null,null,null,null,"Flag",null,"State","% Unemployment"]
[1,null,{"$f":"INDEX(States!C$2:C$51,MATCH(D10,States!D$2:D$51,0),1)","v":"California"},{"$f":"Calcs!C55","v":"California"},{"$f":"Calcs!D55","v":38041430},null,null,null,null,null,null,null,{"$f":"INDEX(States!C$2:C$51,MATCH(N10,States!D$2:D$51,0),1)","v":"Nevada"},{"$f":"Calcs!S55","v":"Nevada"},{"$f":"Calcs!T55","v":9.3000000000000013E-2}]
[2,null,{"$f":"INDEX(States!C$2:C$51,MATCH(D11,States!D$2:D$51,0),1)","v":"Texas"},{"$f":"Calcs!C56","v":"Texas"},{"$f":"Calcs!D56","v":26059203},null,null,null,null,null,null,null,{"$f":"INDEX(States!C$2:C$51,MATCH(N11,States!D$2:D$51,0),1)","v":"RhodeIsland"},{"$f":"Calcs!S56","v":"Rhode Island"},{"$f":"Calcs!T56","v":9.1999999999999998E-2}]
[3,null,{"$f":"INDEX(States!C$2:C$51,MATCH(D12,States!D$2:D$51,0),1)","v":"NewYork"},{"$f":"Calcs!C57","v":"New York"},{"$f":"Calcs!D57","v":19570261},null,null,null,null,null,null,null,{"$f":"INDEX(States!C$2:C$51,MATCH(N12,States!D$2:D$51,0),1)","v":"Michigan"},{"$f":"Calcs!S57","v":"Michigan"},{"$f":"Calcs!T57","v":0.09}]
[4,null,{"$f":"INDEX(States!C$2:C$51,MATCH(D13,States!D$2:D$51,0),1)","v":"Florida"},{"$f":"Calcs!C58","v":"Florida"},{"$f":"Calcs!D58","v":19317568},null,null,null,null,null,null,null,{"$f":"INDEX(States!C$2:C$51,MATCH(N13,States!D$2:D$51,0),1)","v":"Illinois"},{"$f":"Calcs!S58","v":"Illinois"},{"$f":"Calcs!T58","v":8.900000000000001E-2}]
[5,null,{"$f":"INDEX(States!C$2:C$51,MATCH(D14,States!D$2:D$51,0),1)","v":"Illinois"},{"$f":"Calcs!C59","v":"Illinois"},{"$f":"Calcs!D59","v":12875255},null,null,null,null,null,null,null,{"$f":"INDEX(States!C$2:C$51,MATCH(N14,States!D$2:D$51,0),1)","v":"California"},{"$f":"Calcs!S59","v":"California"},{"$f":"Calcs!T59","v":8.6999999999999994E-2}]
[]
[null,"Flag",null,"State","Revenue",null,null,null,null,null,null,"Flag",null,"State","Expenses"]
[1,null,{"$f":"INDEX(States!C$2:C$51,MATCH(D17,States!D$2:D$51,0),1)","v":"California"},{"$f":"Calcs!K55","v":"California"},{"$f":"Calcs!L55","v":292563574},null,null,null,null,null,null,null,{"$f":"INDEX(States!C$2:C$51,MATCH(N17,States!D$2:D$51,0),1)","v":"California"},{"$f":"Calcs!O55","v":"California"},{"$f":"Calcs!P55","v":435914805.27749997}]
[2,null,{"$f":"INDEX(States!C$2:C$51,MATCH(D18,States!D$2:D$51,0),1)","v":"Texas"},{"$f":"Calcs!K56","v":"Texas"},{"$f":"Calcs!L56","v":219459878},null,null,null,null,null,null,null,{"$f":"INDEX(States!C$2:C$51,MATCH(N18,States!D$2:D$51,0),1)","v":"Texas"},{"$f":"Calcs!O56","v":"Texas"},{"$f":"Calcs!P56","v":293723251.70999998}]
[3,null,{"$f":"INDEX(States!C$2:C$51,MATCH(D19,States!D$2:D$51,0),1)","v":"NewYork"},{"$f":"Calcs!K57","v":"New York"},{"$f":"Calcs!L57","v":201167954},null,null,null,null,null,null,null,{"$f":"INDEX(States!C$2:C$51,MATCH(N19,States!D$2:D$51,0),1)","v":"NewYork"},{"$f":"Calcs!O57","v":"New York"},{"$f":"Calcs!P57","v":226137677.6225}]
[4,null,{"$f":"INDEX(States!C$2:C$51,MATCH(D20,States!D$2:D$51,0),1)","v":"Illinois"},{"$f":"Calcs!K58","v":"Illinois"},{"$f":"Calcs!L58","v":124431227},null,null,null,null,null,null,null,{"$f":"INDEX(States!C$2:C$51,MATCH(N20,States!D$2:D$51,0),1)","v":"Florida"},{"$f":"Calcs!O58","v":"Florida"},{"$f":"Calcs!P58","v":219561783.92750001}]
[5,null,{"$f":"INDEX(States!C$2:C$51,MATCH(D21,States!D$2:D$51,0),1)","v":"Florida"},{"$f":"Calcs!K59","v":"Florida"},{"$f":"Calcs!L59","v":122249635},null,null,null,null,null,null,null,{"$f":"INDEX(States!C$2:C$51,MATCH(N21,States!D$2:D$51,0),1)","v":"Illinois"},{"$f":"Calcs!O59","v":"Illinois"},{"$f":"Calcs!P59","v":149784245.27500001}]