{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["List","Data","Financial","Calcs","Summary"],"not_rendered":{"charts":4,"images":10,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"List","index":0,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["State Office",null,"State","Red","Green","Blue",null,"Choice","Red","Green","Blue"]
[null,null,"AK",{"$f":"IF($H$2=$A2,I$2,I$3)","v":255},255,255,null,{"$f":"Calcs!B2","v":"Texas"},54,96,146]
[null,null,"AL",255,255,255,null,null,255,255,255]
[null,null,"AR",255,255,255]
["Arizona",null,"AZ",255,255,255]
["California",null,"CA",{"$f":"IF($H$2=A6,I$2,I$3)","v":255},{"$f":"IF($H$2=$A6,J$2,J$3)","v":255},{"$f":"IF($H$2=$A6,K$2,K$3)","v":255}]
[null,null,"CO",255,255,255]
[null,null,"CT",255,255,255]
[null,null,"DE",255,255,255]
["Florida",null,"FL",255,255,255]
["Georgia",null,"GA",255,255,255]
[null,null,"IA",255,255,255]
[null,null,"IA",255,255,255]
[null,null,"ID",255,255,255]
["Illinois",null,"IL",255,255,255]
[null,null,"IN",255,255,255]
[null,null,"KS",255,255,255]
[null,null,"KY",255,255,255]
[null,null,"LA",255,255,255]
["Massachusetts",null,"MA",255,255,255]
[null,null,"MA",255,255,255]
[null,null,"MD",255,255,255]
[null,null,"ME",255,255,255]
["Michigan",null,"MI",255,255,255]
[null,null,"MN",255,255,255]
[null,null,"MO",255,255,255]
[null,null,"MS",255,255,255]
[null,null,"MT",255,255,255]
["North Carolina",null,"NC",255,255,255]
[null,null,"ND",255,255,255]
[null,null,"NE",255,255,255]
[null,null,"NH",255,255,255]
["New Jersey",null,"NJ",255,255,255]
[null,null,"NM",255,255,255]
[null,null,"NV",255,255,255]
["New York",null,"NY",255,255,255]
["Ohio",null,"OH",255,255,255]
[null,null,"OK",255,255,255]
[null,null,"OR",255,255,255]
["Pennsylvania",null,"PA",255,255,255]
[null,null,"RI",255,255,255]
[null,null,"SC",255,255,255]
[null,null,"SD",255,255,255]
[null,null,"TN",255,255,255]
["Texas",null,"TX",54,96,146]
[null,null,"UT",255,255,255]
["Virginia",null,"VA",255,255,255]
[null,null,"VT",255,255,255]
["Washington",null,"WA",255,255,255]
[null,null,"WI",255,255,255]
[null,null,"WV",255,255,255]
[null,null,"WY",255,255,255]

{"sheet":"Data","index":1,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["ID","State","Followers","Likes","Member Visits","Members","Avg Time on Site","Security","EBIT 000s","Customer Satisfaction","FTE"]
[1,"Arizona",1154.4224999999999,2085.1819999999998,{"$f":"F2*0.44","v":917.48007999999993},2085.1819999999998,63,2,{"$f":"I1*2","v":{"$error":"#VALUE!"}},0.86,11]
[2,"California",3804.143,3387.1648,{"$f":"F3*0.53","v":2513.2762815999999},4742.0307199999997,75,4,338716.48,0.92,55]
[3,"Florida",689.70119999999997,1598.2378000000001,{"$f":"F4*0.44","v":984.5144848000001},2237.5329200000001,68,4,159823.78,0.76,29]
[4,"Georgia",818.58669999999995,818.64530000000002,504.28550479999996,1146.1034199999999,64,2,81864.53,0.81,16]
[5,"Illinois",1287.5255,993.84439999999995,612.20815039999991,1391.3821599999999,62,3,124192.93,0.9,20]
[6,"Massachusetts",664.61440000000005,589.41210000000001,363.07785359999997,825.17693999999995,58,2,63490.97,0.92,11]
[7,"Michigan",988.33600000000001,634.90970000000004,391.10437520000005,888.87358000000006,67,3,99384.44,0.96,16]
[8,"New Jersey",886.45899999999995,841.43499999999995,518.32395999999994,1178.0089999999998,69,2,84143.5,0.85,14]
[9,"New York",1957.0261,1897.6457,{"$f":"F10*0.53","v":1408.0531094},2656.7039799999998,72,6,189764.57,0.88,29]
[10,"North Carolina",975.20730000000003,804.93129999999996,{"$f":"F11*0.44","v":495.83768079999987},1126.9038199999998,59,1,80493.13,0.92,15]
[11,"Ohio",1931.7568000000001,1135.3140000000001,{"$f":"F12*0.44","v":699.35342400000002},1589.4395999999999,60,1,113531.4,0.82,18]
[12,"Pennsylvania",991.99450000000002,1228.1053999999999,{"$f":"F13*0.44","v":756.51292639999986},1719.3475599999997,61,2,122810.54,0.86,20]
[13,"Texas",2605.9203000000002,2097,{"$f":"F14*0.53","v":1555.9739999999999},2935.7999999999997,64,3,208518.2,0.93,38]
[14,"Virginia",1276.3535999999999,707.85149999999999,{"$f":"F15*0.44","v":436.03652399999999},990.99209999999994,63,1,70785.149999999994,0.79,13]
[15,"Washington",888,1241.9293,{"$f":"F16*0.44","v":765.02844879999998},1738.70102,61,0,58941.21,0.81,12]

{"sheet":"Financial","index":2,"n_rows":16,"n_cols":15,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Number","State","2013/14","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","NPS","NPS -1","CS","CS-1","EE","EE-1"]
[1,"Arizona",126,129,107,130,136,121,126.98194000000001,27,{"$f":"100-J2","v":73},83,{"$f":"100-L2","v":17},82,{"$f":"100-N2","v":18}]
[2,"California",114,117,123,156,200,224,338.71647999999999,27,73,77,23,82,18]
[3,"Florida",134,126,108,123,109,121,159.82378,23,77,76,24,87,13]
[4,"Georgia",114,101,110,125,116,112,81.864530000000002,15,85,89,11,80,20]
[5,"Illinois",131,138,124,139,137,152,124.19292999999999,26,74,81,19,76,24]
[6,"Massachusetts",101,101,85,115,118,96,63.490970000000004,15,85,77,23,75,25]
[7,"Michigan",148,126,151,126,123,146,99.384439999999998,20,80,88,12,86,14]
[8,"New Jersey",153,140,156,153,162,160,84.143500000000003,23,77,80,20,90,10]
[9,"New York",117,118,117,121,139,129,189.76457000000002,27,73,77,23,84,16]
[10,"North Carolina",152,143,159,160,155,155,80.493130000000008,17,83,83,17,75,25]
[11,"Ohio",110,105,114,102,90,110,113.53139999999999,18,82,76,24,76,24]
[12,"Pennsylvania",104,123,106,98,104,100,122.81053999999999,29,71,84,16,90,10]
[13,"Texas",88,116,126,117,120,132,208.51820000000001,18,82,79,21,88,12]
[14,"Virginia",90,93,114,92,98,119,70.785149999999987,17,83,79,21,80,20]
[15,"Washington",89,75,92,85,101,95,58.941209999999998,25,75,89,11,74,26]

{"sheet":"Calcs","index":3,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["ID","State","Followers","Likes","Member Visits","Members","Avg Time on Site","Security","EBIT 000s","Customer Satisfaction","FTE"]
[{"$f":"Summary!AB1","v":13},{"$f":"INDEX(Data!B$2:B$16,MATCH($A$2,Data!$A$2:$A$16,0),1)","v":"Texas"},{"$f":"INDEX(Data!C$2:C$16,MATCH($A$2,Data!$A$2:$A$16,0),1)","v":2605.9203000000002},{"$f":"INDEX(Data!D$2:D$16,MATCH($A$2,Data!$A$2:$A$16,0),1)","v":2097},{"$f":"INDEX(Data!E$2:E$16,MATCH($A$2,Data!$A$2:$A$16,0),1)","v":1555.9739999999999},{"$f":"INDEX(Data!F$2:F$16,MATCH($A$2,Data!$A$2:$A$16,0),1)","v":2935.7999999999997},{"$f":"INDEX(Data!G$2:G$16,MATCH($A$2,Data!$A$2:$A$16,0),1)","v":64},{"$f":"INDEX(Data!H$2:H$16,MATCH($A$2,Data!$A$2:$A$16,0),1)","v":3},{"$f":"INDEX(Data!I$2:I$16,MATCH($A$2,Data!$A$2:$A$16,0),1)/1000","v":208.51820000000001},{"$f":"INDEX(Data!J$2:J$16,MATCH($A$2,Data!$A$2:$A$16,0),1)","v":0.93},{"$f":"INDEX(Data!K$2:K$16,MATCH($A$2,Data!$A$2:$A$16,0),1)","v":38}]
[]
[]
[]
[]
["ID","State",{"$f":"Financial!C1","v":"2013/14"},{"$f":"Financial!D1","v":"2014/15"},{"$f":"Financial!E1","v":"2015/16"},{"$f":"Financial!F1","v":"2016/17"},{"$f":"Financial!G1","v":"2017/18"},{"$f":"Financial!H1","v":"2018/19"},{"$f":"Financial!I1","v":"2019/20"}]
[{"$f":"A2","v":13},{"$f":"INDEX(Data!B$2:B$16,MATCH($A$8,Data!$A$2:$A$16,0),1)","v":"Texas"},{"$f":"SUMIFS(Financial!C2:C16,Financial!$B$2:$B$16,$B8)","v":88},{"$f":"SUMIFS(Financial!D2:D16,Financial!$B$2:$B$16,$B8)","v":116},{"$f":"SUMIFS(Financial!E2:E16,Financial!$B$2:$B$16,$B8)","v":126},{"$f":"SUMIFS(Financial!F2:F16,Financial!$B$2:$B$16,$B8)","v":117},{"$f":"SUMIFS(Financial!G2:G16,Financial!$B$2:$B$16,$B8)","v":120},{"$f":"SUMIFS(Financial!H2:H16,Financial!$B$2:$B$16,$B8)","v":132},{"$f":"SUMIFS(Financial!I2:I16,Financial!$B$2:$B$16,$B8)","v":208.51820000000001}]
[]
[]
["ID","State",{"$f":"Financial!J1","v":"NPS"},{"$f":"Financial!K1","v":"NPS -1"},{"$f":"Financial!L1","v":"CS"},{"$f":"Financial!M1","v":"CS-1"},{"$f":"Financial!N1","v":"EE"},{"$f":"Financial!O1","v":"EE-1"}]
[null,{"$f":"B2","v":"Texas"},{"$f":"SUMIFS(Financial!J2:J16,Financial!$B$2:$B$16,$B12)","v":18},{"$f":"SUMIFS(Financial!K2:K16,Financial!$B$2:$B$16,$B12)","v":82},{"$f":"SUMIFS(Financial!L2:L16,Financial!$B$2:$B$16,$B12)","v":79},{"$f":"SUMIFS(Financial!M2:M16,Financial!$B$2:$B$16,$B12)","v":21},{"$f":"SUMIFS(Financial!N2:N16,Financial!$B$2:$B$16,$B12)","v":88},{"$f":"SUMIFS(Financial!O2:O16,Financial!$B$2:$B$16,$B12)","v":12}]
[null,"% Change",{"$f":"C12/100","v":0.18},null,{"$f":"E12/100","v":0.79},null,{"$f":"G12/100","v":0.88}]

{"sheet":"Summary","index":4,"n_rows":16,"n_cols":29,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"State"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Arizona"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"California"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Florida"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Georgia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Illinois"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Massachusetts"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Michigan"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New Jersey"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New York"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"North Carolina"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ohio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pennsylvania"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Texas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Virginia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Washington"]