{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Problem 1","Problem 2"],"read":"whole","date_system":"1900"}

{"sheet":"Problem 1","index":0,"n_rows":184,"n_cols":6,"rows_kept":184}
["Table 1:  Number of 311 Complaints by Service Type and Year"]
[]
[null,null,"Potholes","Graffiti","Parks"]
[null,2000,50,105,75]
[null,2001,53,110,77]
[null,2002,57,105,85]
[null,2003,60,115,83]
[null,2004,66,117,87]
[null,2005,64,120,90]
[null,2006,68,125,100]
[null,2007,70,123,105]
[null,2008,74,124,107]
[null,2009,77,170,110]
[null,2010,100,173,130]
[null,2011,105,177,135]
[null,2012,130,180,155]
[null,2013,135,183,175]
[null,2014,145,185,190]
[]
[]
[]
["Table 1:  311 Rapid Response Signpost Dashboard"]
[null,null,"Days to Dispatch","Days to Schedule","Days to Complete Repair","Total"]
["Potholes","Ave"]
[null,"SD"]
[]
["Graffiti","Ave"]
[null,"SD"]
[]
["Parks","Ave"]
[null,"SD"]
[]
[]
["Case #","Service Type","Dispatch","Scheduled","Completed","Total"]
[1,"Pothole",1,41,13,{"$f":"SUM(C35:E35)","v":55}]
[2,"Pothole",7,15,14,{"$f":"SUM(C36:E36)","v":36}]
[3,"Pothole",3,17,10,30]
[4,"Pothole",5,17,11,33]
[5,"Pothole",1,42,8,51]
[6,"Pothole",8,8,7,23]
[7,"Pothole",3,42,7,52]
[8,"Pothole",6,12,12,30]
[9,"Pothole",4,9,19,32]
[10,"Pothole",1,22,13,36]
[11,"Pothole",5,30,17,52]
[12,"Pothole",4,28,10,42]
[13,"Pothole",6,26,9,41]
[14,"Pothole",3,10,18,31]
[15,"Pothole",6,17,11,34]
[16,"Pothole",6,16,18,40]
[17,"Pothole",8,36,17,61]
[18,"Pothole",7,14,19,40]
[19,"Pothole",7,14,13,34]
[20,"Pothole",6,9,20,35]
[21,"Pothole",2,22,60,84]
[22,"Pothole",3,6,59,68]
[23,"Pothole",2,24,13,39]
[24,"Pothole",5,5,18,28]
[25,"Pothole",6,35,5,46]
[26,"Pothole",3,6,10,19]
[27,"Pothole",1,5,9,15]
[28,"Pothole",1,35,27,63]
[29,"Pothole",1,42,13,56]
[30,"Pothole",2,41,66,109]
[31,"Pothole",2,18,11,31]
[32,"Pothole",6,25,18,49]
[33,"Pothole",5,15,50,70]
[34,"Pothole",2,10,12,24]
[35,"Pothole",2,22,18,42]
[36,"Pothole",9,10,59,78]
[37,"Pothole",9,25,17,51]
[38,"Pothole",4,14,60,78]
[39,"Pothole",2,28,7,37]
[40,"Pothole",3,20,12,35]
[41,"Pothole",4,26,34,64]
[42,"Pothole",1,39,12,52]
[43,"Pothole",3,13,21,37]
[44,"Pothole",5,21,7,33]
[45,"Pothole",4,10,8,22]
[46,"Pothole",1,13,10,24]
[47,"Pothole",2,13,9,24]
[48,"Pothole",7,29,12,48]
[49,"Pothole",6,31,64,101]
[50,"Pothole",5,14,13,32]
[51,"Graffiti",10,13,6,29]
[52,"Graffiti",{"v":4,"d":"4.0"},14,3,21]
[53,"Graffiti",{"v":13,"d":"13.0"},7,6,26]
[54,"Graffiti",3,14,6,23]
[55,"Graffiti",20,18,8,46]
[56,"Graffiti",4,7,7,18]
[57,"Graffiti",6,7,7,20]
[58,"Graffiti",21,12,6,39]
[59,"Graffiti",6,19,2,27]
[60,"Graffiti",18,3,3,24]
[61,"Graffiti",15,17,8,40]
[62,"Graffiti",9,19,3,31]
[63,"Graffiti",7,19,6,32]
[64,"Graffiti",5,18,4,27]
[65,"Graffiti",12,21,1,34]
[66,"Graffiti",15,18,5,{"$f":"SUM(C100:E100)","v":38}]
[67,"Graffiti",9,7,4,20]
[68,"Graffiti",12,19,2,33]
[69,"Graffiti",4,13,5,22]
[70,"Graffiti",6,75,6,87]
[71,"Graffiti",21,5,3,29]
[72,"Graffiti",6,38,6,50]
[73,"Graffiti",18,23,5,46]
[74,"Graffiti",15,18,2,35]
[75,"Graffiti",9,5,2,16]
[76,"Graffiti",7,10,9,26]
[77,"Graffiti",5,9,9,23]
[78,"Graffiti",12,18,4,34]
[79,"Graffiti",15,13,1,29]
[80,"Graffiti",9,46,1,56]
[81,"Graffiti",12,21,1,34]
[82,"Graffiti",4,18,2,24]
[83,"Graffiti",6,83,2,91]
[84,"Graffiti",21,23,6,50]
[85,"Graffiti",6,18,5,29]
[86,"Graffiti",12,29,2,43]
[87,"Graffiti",4,17,2,23]
[88,"Graffiti",6,89,2,97]
[89,"Graffiti",21,17,6,44]
[90,"Graffiti",2,12,5,19]
[91,"Graffiti",6,9,4,19]
[92,"Graffiti",5,22,1,28]
[93,"Graffiti",6,21,3,30]
[94,"Graffiti",10,7,5,22]
[95,"Graffiti",4,18,4,26]
[96,"Graffiti",13,10,1,24]
[97,"Graffiti",6,9,2,17]
[98,"Graffiti",7,12,7,26]
[99,"Graffiti",21,64,6,91]
[100,"Graffiti",15,13,5,33]
[101,"Parks",6,37,9,52]
[102,"Parks",5,16,6,27]
[103,"Parks",3,15,4,22]
[104,"Parks",2,41,20,63]
[105,"Parks",3,16,45,64]
[106,"Parks",5,8,70,83]
[107,"Parks",5,37,25,67]
[108,"Parks",3,13,5,21]
[109,"Parks",2,8,7,17]
[110,"Parks",6,32,25,63]
[111,"Parks",4,20,8,32]
[112,"Parks",1,17,15,33]
[113,"Parks",3,26,60,89]
[114,"Parks",4,10,2,16]
[115,"Parks",4,25,7,36]
[116,"Parks",1,15,4,20]
[117,"Parks",1,10,5,16]
[118,"Parks",4,22,6,32]
[119,"Parks",2,10,5,17]
[120,"Parks",5,9,50,64]
[121,"Parks",5,14,2,21]
[122,"Parks",1,36,3,40]
[123,"Parks",3,14,7,24]
[124,"Parks",5,5,35,45]
[125,"Parks",6,35,7,48]
[126,"Parks",3,6,5,14]
[127,"Parks",5,5,32,42]
[128,"Parks",6,35,5,46]
[129,"Parks",9,42,8,59]
[130,"Parks",5,41,4,{"$f":"SUM(C164:E164)","v":50}]
[131,"Parks",4,18,42,64]
[132,"Parks",5,25,12,42]
[133,"Parks",9,15,7,31]
[134,"Parks",1,10,4,15]
[135,"Parks",4,22,37,63]
[136,"Parks",10,10,4,24]
[137,"Parks",5,25,3,33]
[138,"Parks",1,14,24,39]
[139,"Parks",1,14,7,22]
[140,"Parks",7,20,29,56]
[141,"Parks",5,26,4,35]
[142,"Parks",3,39,3,45]
[143,"Parks",5,18,28,51]
[144,"Parks",5,25,12,42]
[145,"Parks",4,15,15,34]
[146,"Parks",8,13,4,25]
[147,"Parks",3,13,1,17]
[148,"Parks",9,29,5,43]
[149,"Parks",4,31,2,37]
[150,"Parks",1,14,12,27]

{"sheet":"Problem 2","index":1,"n_rows":22,"n_cols":6,"rows_kept":22,"merged":[[0,0,0,1],[0,2,0,3],[0,4,0,5],[0,6,0,7]]}
["High School #1",null,"High School #2",null,"High School #3"]
["Hours","Difference Score","Hours","Difference Score","Hours","Difference Score"]
[20,18.28,20,8.04,15,13.16]
[16,16.24,16,6.95,16,11.52]
[26,17.48,26,7.58,15,15.42]
[18,17.54,18,8.81,15,17.68]
[22,18.52,22,8.33,16,16.94]
[28,16.2,28,9.96,16,14.08]
[12,12.26,12,7.24,15,10.5]
[8,6.2,8,4.26,35,26.3]
[24,18.26,24,10.84,16,11.12]
[14,14.52,14,4.82,15,15.82]
[10,9.48,10,5.68,16,13.78]
[19,17.8,20,8.07,16,11.52]
[12,12.3,16,6.93,16,15.42]
[24,17.9,26,7.5,15,17.68]
[16,16.1,18,8.79,15,16.94]
[15,15.3,22,8.3,16,15.82]
[22,18.4,28,10.1,15,13.78]
[23,18.3,12,7.14,38,25.1]
[27,15.9,8,4.16,16,15.42]
[8,6.5,24,10.83,15,16.94]