{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Satisfaction Questionnaire","Statistics","City Wide","Administration_Front Desk","Community Development","Justice Court","Parks & Recreation","Public Works","Code Book","Validation Questions"],"not_rendered":{"charts":37,"images":0,"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":"Satisfaction Questionnaire","index":0,"n_rows":31,"n_cols":10,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["Service Satisfaction Questionnaire"]
["Department","Wait Time","Representative Courteous?","Representative Prompt?","Representative Knowledgeable?","Request Handled to Satisfaction?","Additional Comments","Newsletter?","E-mail?","Column1"]
["Justice Court","Less than 5 min","Disagree","Agree","Neutral","Disagree","Test comment","Yes","example@mail.com"]
["Community Development","5-10 min","Disagree","Agree","Neutral","Strongly Agree","Test comment","No"]
["Parks & Recreation","Less than 5 min","Disagree","Agree","Disagree","Agree","Test comment","Yes","example@mail.com"]
["Public Works","5-10 min","Disagree","Agree","Neutral","Disagree","Test comment","No"]
["Community Development","0 minutes","Disagree","Disagree","Neutral","Disagree",null,"No"]
["Administration/Front Desk","Less than 5 min","Strongly Agree","Agree","Disagree","Agree",null,"No"]
["Community Development","Over 10 min","Neutral","Strongly Disagree","Agree","Strongly Disagree",null,"No"]
["Public Works","0 minutes","Agree","Strongly Agree","Strongly Agree","Neutral","Test comment","Yes","example@mail.com"]
["Parks & Recreation","5-10 min","Strongly Disagree","Neutral","Strongly Disagree","Agree",null,"No"]
["Justice Court","Over 10 min","Agree","Disagree","Agree","Strongly Agree",null,"No"]
["Justice Court","Less than 5 min","Disagree","Agree","Neutral","Disagree","Test comment","Yes","example@mail.com"]
["Community Development","5-10 min","Disagree","Agree","Neutral","Strongly Agree","Test comment","No"]
["Parks & Recreation","Less than 5 min","Disagree","Agree","Disagree","Agree","Test comment","Yes","example@mail.com"]
["Public Works","5-10 min","Disagree","Agree","Neutral","Disagree","Test comment","No"]
["Community Development","0 minutes","Disagree","Disagree","Neutral","Disagree",null,"No"]
["Administration/Front Desk","Less than 5 min","Strongly Agree","Agree","Disagree","Agree",null,"No"]
["Community Development","Over 10 min","Neutral","Strongly Disagree","Agree","Strongly Disagree",null,"No"]
["Public Works","0 minutes","Agree","Strongly Agree","Strongly Agree","Neutral","Test comment","Yes","example@mail.com"]
["Parks & Recreation","5-10 min","Strongly Disagree","Neutral","Strongly Disagree","Agree",null,"No"]
["Justice Court","Over 10 min","Agree","Disagree","Agree","Strongly Agree",null,"No"]
["Administration/Front Desk","Less than 5 min","Disagree","Agree","Neutral","Disagree","Test comment","Yes","example@mail.com"]
["Community Development","5-10 min","Disagree","Agree","Neutral","Strongly Agree","Test comment","No"]
["Parks & Recreation","Less than 5 min","Disagree","Agree","Disagree","Agree","Test comment","Yes","example@mail.com"]
["Administration/Front Desk","5-10 min","Disagree","Agree","Neutral","Disagree","Test comment","No"]
["Public Works","0 minutes","Disagree","Disagree","Neutral","Disagree",null,"No"]
["Parks & Recreation","Less than 5 min","Strongly Agree","Agree","Disagree","Agree",null,"No"]
["Community Development","Over 10 min","Neutral","Strongly Disagree","Agree","Strongly Disagree",null,"No"]
["Justice Court","0 minutes","Agree","Strongly Agree","Neutral",null,null,null,null,"2015-04-06T21:13:44"]
["Justice Court","Less than 5 min","Agree","Neutral","Strongly Agree",null,null,null,null,"2015-04-06T21:13:54"]

{"sheet":"Statistics","index":1,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Department",null,"Wait Time",null,"Representative Courteous?",null,"Representative Prompt?",null,"Representative Knowledgeable?",null,"Request Handled to Satisfaction?",null,"Newsletter?"]
[]
["Mean",3,"Mean",2.4814814814814814,"Mean",2.6666666666666665,"Mean",3.2962962962962963,"Mean",2.9629629629629628,"Mean",3.1111111111111112,"Mean",0.29629629629629628]
["Standard Error",0.26688025634181189,"Standard Error",0.19517229126443245,"Standard Error",0.22645540682891915,"Standard Error",0.23152421258017142,"Standard Error",0.19598157859737708,"Standard Error",0.26329780855981821,"Standard Error",8.9551188863257608E-2]
["Median",3,"Median",2,"Median",2,"Median",4,"Median",3,"Median",3,"Median",0]
["Mode",2,"Mode",2,"Mode",2,"Mode",4,"Mode",3,"Mode",2,"Mode",0]
["Standard Deviation",1.3867504905630728,"Standard Deviation",1.014144974098885,"Standard Deviation",1.1766968108291043,"Standard Deviation",1.203035098113703,"Standard Deviation",1.0183501544346312,"Standard Deviation",1.3681355458414464,"Standard Deviation",0.46532162696807522]
["Sample Variance",1.9230769230769231,"Sample Variance",1.0284900284900282,"Sample Variance",1.3846153846153846,"Sample Variance",1.4472934472934469,"Sample Variance",1.037037037037037,"Sample Variance",1.8717948717948725,"Sample Variance",0.21652421652421652]
["Kurtosis",-1.3095679999999992,"Kurtosis",-1.0098983279747693,"Kurtosis",-0.34666666666666801,"Kurtosis",-0.6482368714737432,"Kurtosis",2.9670329670321571E-3,"Kurtosis",-1.4165584537436675,"Kurtosis",-1.2007894736842091]
["Skewness",9.3455889060026623E-2,"Skewness",5.4191905651651238E-2,"Skewness",0.86683331731077373,"Skewness",-0.76702326221291817,"Skewness",7.8558440484957859E-2,"Skewness",-2.0425757933410667E-2,"Skewness",0.94558252722302105]
["Range",4,"Range",3,"Range",4,"Range",4,"Range",4,"Range",4,"Range",1]
["Minimum",1,"Minimum",1,"Minimum",1,"Minimum",1,"Minimum",1,"Minimum",1,"Minimum",0]
["Maximum",5,"Maximum",4,"Maximum",5,"Maximum",5,"Maximum",5,"Maximum",5,"Maximum",1]
["Sum",81,"Sum",67,"Sum",72,"Sum",89,"Sum",80,"Sum",84,"Sum",8]
["Count",27,"Count",27,"Count",27,"Count",27,"Count",27,"Count",27,"Count",27]
["Confidence Level(95.0%)",0.54858022350315072,"Confidence Level(95.0%)",0.40118239030142216,"Confidence Level(95.0%)",0.46548575527669162,"Confidence Level(95.0%)",0.47590483471715295,"Confidence Level(95.0%)",0.40284590423861061,"Confidence Level(95.0%)",0.54121639662486176,"Confidence Level(95.0%)",0.18407510497389382]

{"sheet":"City Wide","index":2,"n_rows":52,"n_cols":12,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,0,0,19]]}
["City Wide"]
[]
[]
[]
[]
["Department",null,null,null,null,null,null,null,null,null,"Representative Prompt?"]
["Administration/Front Desk",{"$f":"COUNTIF('Code Book'!$A$3:$A$1048576,1)","v":4},null,null,null,null,null,null,null,null,"Strongly Disagree",{"$f":"COUNTIF('Code Book'!$D$3:$D$1048576,1)","v":3}]
["Community Development",{"$f":"COUNTIF('Code Book'!$A$3:$A$1048576,2)","v":8},null,null,null,null,null,null,null,null,"Disagree",{"$f":"COUNTIF('Code Book'!$D$3:$D$1048576,2)","v":5}]
["Justice Court",{"$f":"COUNTIF('Code Book'!$A$3:$A$1048576,3)","v":6},null,null,null,null,null,null,null,null,"Neutral",{"$f":"COUNTIF('Code Book'!$D$3:$D$1048576,3)","v":3}]
["Parks & Recreation",{"$f":"COUNTIF('Code Book'!$A$3:$A$1048576,4)","v":6},null,null,null,null,null,null,null,null,"Agree",{"$f":"COUNTIF('Code Book'!$D$3:$D$1048576,4)","v":15}]
["Public Works",{"$f":"COUNTIF('Code Book'!$A$3:$A$1048576,5)","v":5},null,null,null,null,null,null,null,null,"Strongly Agree",{"$f":"COUNTIF('Code Book'!$D$3:$D$1048576,5)","v":3}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Wait Time",null,null,null,null,null,null,null,null,null,"Representative Knowledgeable?"]
["0 minutes",{"$f":"COUNTIF('Code Book'!$B$3:$B$1048576,1)","v":6},null,null,null,null,null,null,null,null,"Strongly Disagree",{"$f":"COUNTIF('Code Book'!$E$3:$E$1048576,1)","v":2}]
["Less than 5 min",{"$f":"COUNTIF('Code Book'!$B$3:$B$1048576,2)","v":10},null,null,null,null,null,null,null,null,"Disagree",{"$f":"COUNTIF('Code Book'!$E$3:$E$1048576,2)","v":6}]
["5-10 min",{"$f":"COUNTIF('Code Book'!$B$3:$B$1048576,3)","v":8},null,null,null,null,null,null,null,null,"Neutral",{"$f":"COUNTIF('Code Book'!$E$3:$E$1048576,3)","v":13}]
["Over 10 min",{"$f":"COUNTIF('Code Book'!$B$3:$B$1048576,4)","v":5},null,null,null,null,null,null,null,null,"Agree",{"$f":"COUNTIF('Code Book'!$E$3:$E$1048576,4)","v":5}]
[null,null,null,null,null,null,null,null,null,null,"Strongly Agree",{"$f":"COUNTIF('Code Book'!$E$3:$E$1048576,5)","v":3}]
[]
[]
[]
[]
[]
[]
[]
["Representative Courteous?",null,null,null,null,null,null,null,null,null,"Request Handled to Satisfaction?"]
["Strongly Disagree",{"$f":"COUNTIF('Code Book'!$C$3:$C$1048576,1)","v":2},null,null,null,null,null,null,null,null,"Strongly Disagree",{"$f":"COUNTIF('Code Book'!$F$3:$F$1048576,1)","v":3}]
["Disagree",{"$f":"COUNTIF('Code Book'!$C$3:$C$1048576,2)","v":15},null,null,null,null,null,null,null,null,"Disagree",{"$f":"COUNTIF('Code Book'!$F$3:$F$1048576,2)","v":9}]
["Neutral",{"$f":"COUNTIF('Code Book'!$C$3:$C$1048576,3)","v":3},null,null,null,null,null,null,null,null,"Neutral",{"$f":"COUNTIF('Code Book'!$F$3:$F$1048576,3)","v":2}]
["Agree",{"$f":"COUNTIF('Code Book'!$C$3:$C$1048576,4)","v":6},null,null,null,null,null,null,null,null,"Agree",{"$f":"COUNTIF('Code Book'!$F$3:$F$1048576,4)","v":8}]
["Strongly Agree",{"$f":"COUNTIF('Code Book'!$C$3:$C$1048576,5)","v":3},null,null,null,null,null,null,null,null,"Strongly Agree",{"$f":"COUNTIF('Code Book'!$F$3:$F$1048576,5)","v":5}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Newsletter?"]
["Yes",{"$f":"COUNTIF('Code Book'!$G$2:$G$1048575,1)","v":8}]
["No",{"$f":"COUNTIF('Code Book'!$G$2:$G$1048575,0)","v":19}]

{"sheet":"Administration_Front Desk","index":3,"n_rows":41,"n_cols":12,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,19]]}
["Administration / Front Desk"]
[]
[]
[]
[]
[]
["Wait Time",null,null,null,null,null,null,null,null,null,"Representative Knowledgeable?"]
["0 minutes",{"$f":"COUNTIFS('Code Book'!$B$3:$B$1048576,1,'Code Book'!$A$3:$A$1048576,1)","v":0},null,null,null,null,null,null,null,null,"Strongly Disagree",{"$f":"COUNTIFS('Code Book'!$E$3:$E$1048576,1,'Code Book'!$A$3:$A$1048576,1)","v":0}]
["Less than 5 min",{"$f":"COUNTIFS('Code Book'!$B$3:$B$1048576,2,'Code Book'!$A$3:$A$1048576,1)","v":3},null,null,null,null,null,null,null,null,"Disagree",{"$f":"COUNTIFS('Code Book'!$E$3:$E$1048576,2,'Code Book'!$A$3:$A$1048576,1)","v":2}]
["5-10 min",{"$f":"COUNTIFS('Code Book'!$B$3:$B$1048576,3,'Code Book'!$A$3:$A$1048576,1)","v":1},null,null,null,null,null,null,null,null,"Neutral",{"$f":"COUNTIFS('Code Book'!$E$3:$E$1048576,3,'Code Book'!$A$3:$A$1048576,1)","v":2}]
["Over 10 min",{"$f":"COUNTIFS('Code Book'!$B$3:$B$1048576,4,'Code Book'!$A$3:$A$1048576,1)","v":0},null,null,null,null,null,null,null,null,"Agree",{"$f":"COUNTIFS('Code Book'!$E$3:$E$1048576,4,'Code Book'!$A$3:$A$1048576,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Strongly Agree",{"$f":"COUNTIFS('Code Book'!$E$3:$E$1048576,5,'Code Book'!$A$3:$A$1048576,1)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
["Representative Courteous?",null,null,null,null,null,null,null,null,null,"Request Handled in Satisfactory Manner?"]
["Strongly Disagree",{"$f":"COUNTIFS('Code Book'!$C$3:$C$1048576,1,'Code Book'!$A$3:$A$1048576,1)","v":0},null,null,null,null,null,null,null,null,"Strongly Disagree",{"$f":"COUNTIFS('Code Book'!$F$3:$F$1048576,1,'Code Book'!$A$3:$A$1048576,1)","v":0}]
["Disagree",{"$f":"COUNTIFS('Code Book'!$C$3:$C$1048576,2,'Code Book'!$A$3:$A$1048576,1)","v":2},null,null,null,null,null,null,null,null,"Disagree",{"$f":"COUNTIFS('Code Book'!$F$3:$F$1048576,2,'Code Book'!$A$3:$A$1048576,1)","v":2}]
["Neutral",{"$f":"COUNTIFS('Code Book'!$C$3:$C$1048576,3,'Code Book'!$A$3:$A$1048576,1)","v":0},null,null,null,null,null,null,null,null,"Neutral",{"$f":"COUNTIFS('Code Book'!$F$3:$F$1048576,3,'Code Book'!$A$3:$A$1048576,1)","v":0}]
["Agree",{"$f":"COUNTIFS('Code Book'!$C$3:$C$1048576,4,'Code Book'!$A$3:$A$1048576,1)","v":0},null,null,null,null,null,null,null,null,"Agree",{"$f":"COUNTIFS('Code Book'!$F$3:$F$1048576,4,'Code Book'!$A$3:$A$1048576,1)","v":2}]
["Strongly Agree",{"$f":"COUNTIFS('Code Book'!$C$3:$C$1048576,5,'Code Book'!$A$3:$A$1048576,1)","v":2},null,null,null,null,null,null,null,null,"Strongly Agree",{"$f":"COUNTIFS('Code Book'!$F$3:$F$1048576,5,'Code Book'!$A$3:$A$1048576,1)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Newsletter?"]
["Representative Prompt?",null,null,null,null,null,null,null,null,null,"Yes",{"$f":"COUNTIFS('Code Book'!$G$3:$G$1048576,1,'Code Book'!$A$3:$A$1048576,1)","v":1}]
["Strongly Disagree",{"$f":"COUNTIFS('Code Book'!$D$3:$D$1048576,1,'Code Book'!$A$3:$A$1048576,1)","v":0},null,null,null,null,null,null,null,null,"No",{"$f":"COUNTIFS('Code Book'!$G$3:$G$1048576,0,'Code Book'!$A$3:$A$1048576,1)","v":3}]
["Disagree",{"$f":"COUNTIFS('Code Book'!$D$3:$D$1048576,2,'Code Book'!$A$3:$A$1048576,1)","v":0}]
["Neutral",{"$f":"COUNTIFS('Code Book'!$D$3:$D$1048576,3,'Code Book'!$A$3:$A$1048576,1)","v":0}]
["Agree",{"$f":"COUNTIFS('Code Book'!$D$3:$D$1048576,4,'Code Book'!$A$3:$A$1048576,1)","v":4}]
["Strongly Agree",{"$f":"COUNTIFS('Code Book'!$D$3:$D$1048576,5,'Code Book'!$A$3:$A$1048576,1)","v":0}]

{"sheet":"Community Development","index":4,"n_rows":41,"n_cols":12,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,19]]}
["Community Development"]
[]
[]
[]
[]
[]
["Wait Time",null,null,null,null,null,null,null,null,null,"Representative Knowledgeable?"]
["0 minutes",{"$f":"COUNTIFS('Code Book'!$B$3:$B$1048576,1,'Code Book'!$A$3:$A$1048576,2)","v":2},null,null,null,null,null,null,null,null,"Strongly Disagree",{"$f":"COUNTIFS('Code Book'!$E$3:$E$1048576,1,'Code Book'!$A$3:$A$1048576,2)","v":0}]
["Less than 5 min",{"$f":"COUNTIFS('Code Book'!$B$3:$B$1048576,2,'Code Book'!$A$3:$A$1048576,2)","v":0},null,null,null,null,null,null,null,null,"Disagree",{"$f":"COUNTIFS('Code Book'!$E$3:$E$1048576,2,'Code Book'!$A$3:$A$1048576,2)","v":0}]
["5-10 min",{"$f":"COUNTIFS('Code Book'!$B$3:$B$1048576,3,'Code Book'!$A$3:$A$1048576,2)","v":3},null,null,null,null,null,null,null,null,"Neutral",{"$f":"COUNTIFS('Code Book'!$E$3:$E$1048576,3,'Code Book'!$A$3:$A$1048576,2)","v":5}]
["Over 10 min",{"$f":"COUNTIFS('Code Book'!$B$3:$B$1048576,4,'Code Book'!$A$3:$A$1048576,2)","v":3},null,null,null,null,null,null,null,null,"Agree",{"$f":"COUNTIFS('Code Book'!$E$3:$E$1048576,4,'Code Book'!$A$3:$A$1048576,2)","v":3}]
[null,null,null,null,null,null,null,null,null,null,"Strongly Agree",{"$f":"COUNTIFS('Code Book'!$E$3:$E$1048576,5,'Code Book'!$A$3:$A$1048576,2)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
["Representative Courteous?",null,null,null,null,null,null,null,null,null,"Request Handled in Satisfactory Manner?"]
["Strongly Disagree",{"$f":"COUNTIFS('Code Book'!$C$3:$C$1048576,1,'Code Book'!$A$3:$A$1048576,2)","v":0},null,null,null,null,null,null,null,null,"Strongly Disagree",{"$f":"COUNTIFS('Code Book'!$F$3:$F$1048576,1,'Code Book'!$A$3:$A$1048576,2)","v":3}]
["Disagree",{"$f":"COUNTIFS('Code Book'!$C$3:$C$1048576,2,'Code Book'!$A$3:$A$1048576,2)","v":5},null,null,null,null,null,null,null,null,"Disagree",{"$f":"COUNTIFS('Code Book'!$F$3:$F$1048576,2,'Code Book'!$A$3:$A$1048576,2)","v":2}]
["Neutral",{"$f":"COUNTIFS('Code Book'!$C$3:$C$1048576,3,'Code Book'!$A$3:$A$1048576,2)","v":3},null,null,null,null,null,null,null,null,"Neutral",{"$f":"COUNTIFS('Code Book'!$F$3:$F$1048576,3,'Code Book'!$A$3:$A$1048576,2)","v":0}]
["Agree",{"$f":"COUNTIFS('Code Book'!$C$3:$C$1048576,4,'Code Book'!$A$3:$A$1048576,2)","v":0},null,null,null,null,null,null,null,null,"Agree",{"$f":"COUNTIFS('Code Book'!$F$3:$F$1048576,4,'Code Book'!$A$3:$A$1048576,2)","v":0}]
["Strongly Agree",{"$f":"COUNTIFS('Code Book'!$C$3:$C$1048576,5,'Code Book'!$A$3:$A$1048576,2)","v":0},null,null,null,null,null,null,null,null,"Strongly Agree",{"$f":"COUNTIFS('Code Book'!$F$3:$F$1048576,5,'Code Book'!$A$3:$A$1048576,2)","v":3}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Newsletter?"]
["Representative Prompt?",null,null,null,null,null,null,null,null,null,"Yes",{"$f":"COUNTIFS('Code Book'!$G$3:$G$1048576,1,'Code Book'!$A$3:$A$1048576,2)","v":0}]
["Strongly Disagree",{"$f":"COUNTIFS('Code Book'!$D$3:$D$1048576,1,'Code Book'!$A$3:$A$1048576,2)","v":3},null,null,null,null,null,null,null,null,"No",{"$f":"COUNTIFS('Code Book'!$G$3:$G$1048576,0,'Code Book'!$A$3:$A$1048576,2)","v":8}]
["Disagree",{"$f":"COUNTIFS('Code Book'!$D$3:$D$1048576,2,'Code Book'!$A$3:$A$1048576,2)","v":2}]
["Neutral",{"$f":"COUNTIFS('Code Book'!$D$3:$D$1048576,3,'Code Book'!$A$3:$A$1048576,2)","v":0}]
["Agree",{"$f":"COUNTIFS('Code Book'!$D$3:$D$1048576,4,'Code Book'!$A$3:$A$1048576,2)","v":3}]
["Strongly Agree",{"$f":"COUNTIFS('Code Book'!$D$3:$D$1048576,5,'Code Book'!$A$3:$A$1048576,2)","v":0}]

{"sheet":"Justice Court","index":5,"n_rows":41,"n_cols":12,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,19]]}
["Justice Court"]
[]
[]
[]
[]
[]
["Wait Time",null,null,null,null,null,null,null,null,null,"Representative Knowledgeable?"]
["0 minutes",{"$f":"COUNTIFS('Code Book'!$B$3:$B$1048576,1,'Code Book'!$A$3:$A$1048576,3)","v":1},null,null,null,null,null,null,null,null,"Strongly Disagree",{"$f":"COUNTIFS('Code Book'!$E$3:$E$1048576,1,'Code Book'!$A$3:$A$1048576,3)","v":0}]
["Less than 5 min",{"$f":"COUNTIFS('Code Book'!$B$3:$B$1048576,2,'Code Book'!$A$3:$A$1048576,3)","v":3},null,null,null,null,null,null,null,null,"Disagree",{"$f":"COUNTIFS('Code Book'!$E$3:$E$1048576,2,'Code Book'!$A$3:$A$1048576,3)","v":0}]
["5-10 min",{"$f":"COUNTIFS('Code Book'!$B$3:$B$1048576,3,'Code Book'!$A$3:$A$1048576,3)","v":0},null,null,null,null,null,null,null,null,"Neutral",{"$f":"COUNTIFS('Code Book'!$E$3:$E$1048576,3,'Code Book'!$A$3:$A$1048576,3)","v":3}]
["Over 10 min",{"$f":"COUNTIFS('Code Book'!$B$3:$B$1048576,4,'Code Book'!$A$3:$A$1048576,3)","v":2},null,null,null,null,null,null,null,null,"Agree",{"$f":"COUNTIFS('Code Book'!$E$3:$E$1048576,4,'Code Book'!$A$3:$A$1048576,3)","v":2}]
[null,null,null,null,null,null,null,null,null,null,"Strongly Agree",{"$f":"COUNTIFS('Code Book'!$E$3:$E$1048576,5,'Code Book'!$A$3:$A$1048576,3)","v":1}]
[]
[]
[]
[]
[]
[]
[]
[]
["Representative Courteous?",null,null,null,null,null,null,null,null,null,"Request Handled in Satisfactory Manner?"]
["Strongly Disagree",{"$f":"COUNTIFS('Code Book'!$C$3:$C$1048576,1,'Code Book'!$A$3:$A$1048576,3)","v":0},null,null,null,null,null,null,null,null,"Strongly Disagree",{"$f":"COUNTIFS('Code Book'!$F$3:$F$1048576,1,'Code Book'!$A$3:$A$1048576,3)","v":0}]
["Disagree",{"$f":"COUNTIFS('Code Book'!$C$3:$C$1048576,2,'Code Book'!$A$3:$A$1048576,3)","v":2},null,null,null,null,null,null,null,null,"Disagree",{"$f":"COUNTIFS('Code Book'!$F$3:$F$1048576,2,'Code Book'!$A$3:$A$1048576,3)","v":2}]
["Neutral",{"$f":"COUNTIFS('Code Book'!$C$3:$C$1048576,3,'Code Book'!$A$3:$A$1048576,3)","v":0},null,null,null,null,null,null,null,null,"Neutral",{"$f":"COUNTIFS('Code Book'!$F$3:$F$1048576,3,'Code Book'!$A$3:$A$1048576,3)","v":0}]
["Agree",{"$f":"COUNTIFS('Code Book'!$C$3:$C$1048576,4,'Code Book'!$A$3:$A$1048576,3)","v":4},null,null,null,null,null,null,null,null,"Agree",{"$f":"COUNTIFS('Code Book'!$F$3:$F$1048576,4,'Code Book'!$A$3:$A$1048576,3)","v":0}]
["Strongly Agree",{"$f":"COUNTIFS('Code Book'!$C$3:$C$1048576,5,'Code Book'!$A$3:$A$1048576,3)","v":0},null,null,null,null,null,null,null,null,"Strongly Agree",{"$f":"COUNTIFS('Code Book'!$F$3:$F$1048576,5,'Code Book'!$A$3:$A$1048576,3)","v":2}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Newsletter?"]
["Representative Prompt?",null,null,null,null,null,null,null,null,null,"Yes",{"$f":"COUNTIFS('Code Book'!$G$3:$G$1048576,1,'Code Book'!$A$3:$A$1048576,3)","v":2}]
["Strongly Disagree",{"$f":"COUNTIFS('Code Book'!$D$3:$D$1048576,1,'Code Book'!$A$3:$A$1048576,3)","v":0},null,null,null,null,null,null,null,null,"No",{"$f":"COUNTIFS('Code Book'!$G$3:$G$1048576,0,'Code Book'!$A$3:$A$1048576,3)","v":2}]
["Disagree",{"$f":"COUNTIFS('Code Book'!$D$3:$D$1048576,2,'Code Book'!$A$3:$A$1048576,3)","v":2}]
["Neutral",{"$f":"COUNTIFS('Code Book'!$D$3:$D$1048576,3,'Code Book'!$A$3:$A$1048576,3)","v":1}]
["Agree",{"$f":"COUNTIFS('Code Book'!$D$3:$D$1048576,4,'Code Book'!$A$3:$A$1048576,3)","v":2}]
["Strongly Agree",{"$f":"COUNTIFS('Code Book'!$D$3:$D$1048576,5,'Code Book'!$A$3:$A$1048576,3)","v":1}]

{"sheet":"Parks & Recreation","index":6,"n_rows":41,"n_cols":12,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,19]]}
["Parks & Recreation"]
[]
[]
[]
[]
[]
["Wait Time",null,null,null,null,null,null,null,null,null,"Representative Knowledgeable?"]
["0 minutes",{"$f":"COUNTIFS('Code Book'!$B$3:$B$1048576,1,'Code Book'!$A$3:$A$1048576,4)","v":0},null,null,null,null,null,null,null,null,"Strongly Disagree",{"$f":"COUNTIFS('Code Book'!$E$3:$E$1048576,1,'Code Book'!$A$3:$A$1048576,4)","v":2}]
["Less than 5 min",{"$f":"COUNTIFS('Code Book'!$B$3:$B$1048576,2,'Code Book'!$A$3:$A$1048576,4)","v":4},null,null,null,null,null,null,null,null,"Disagree",{"$f":"COUNTIFS('Code Book'!$E$3:$E$1048576,2,'Code Book'!$A$3:$A$1048576,4)","v":4}]
["5-10 min",{"$f":"COUNTIFS('Code Book'!$B$3:$B$1048576,3,'Code Book'!$A$3:$A$1048576,4)","v":2},null,null,null,null,null,null,null,null,"Neutral",{"$f":"COUNTIFS('Code Book'!$E$3:$E$1048576,3,'Code Book'!$A$3:$A$1048576,4)","v":0}]
["Over 10 min",{"$f":"COUNTIFS('Code Book'!$B$3:$B$1048576,4,'Code Book'!$A$3:$A$1048576,4)","v":0},null,null,null,null,null,null,null,null,"Agree",{"$f":"COUNTIFS('Code Book'!$E$3:$E$1048576,4,'Code Book'!$A$3:$A$1048576,4)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Strongly Agree",{"$f":"COUNTIFS('Code Book'!$E$3:$E$1048576,5,'Code Book'!$A$3:$A$1048576,4)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
["Representative Courteous?",null,null,null,null,null,null,null,null,null,"Request Handled in Satisfactory Manner?"]
["Strongly Disagree",{"$f":"COUNTIFS('Code Book'!$C$3:$C$1048576,1,'Code Book'!$A$3:$A$1048576,4)","v":2},null,null,null,null,null,null,null,null,"Strongly Disagree",{"$f":"COUNTIFS('Code Book'!$F$3:$F$1048576,1,'Code Book'!$A$3:$A$1048576,4)","v":0}]
["Disagree",{"$f":"COUNTIFS('Code Book'!$C$3:$C$1048576,2,'Code Book'!$A$3:$A$1048576,4)","v":3},null,null,null,null,null,null,null,null,"Disagree",{"$f":"COUNTIFS('Code Book'!$F$3:$F$1048576,2,'Code Book'!$A$3:$A$1048576,4)","v":0}]
["Neutral",{"$f":"COUNTIFS('Code Book'!$C$3:$C$1048576,3,'Code Book'!$A$3:$A$1048576,4)","v":0},null,null,null,null,null,null,null,null,"Neutral",{"$f":"COUNTIFS('Code Book'!$F$3:$F$1048576,3,'Code Book'!$A$3:$A$1048576,4)","v":0}]
["Agree",{"$f":"COUNTIFS('Code Book'!$C$3:$C$1048576,4,'Code Book'!$A$3:$A$1048576,4)","v":0},null,null,null,null,null,null,null,null,"Agree",{"$f":"COUNTIFS('Code Book'!$F$3:$F$1048576,4,'Code Book'!$A$3:$A$1048576,4)","v":6}]
["Strongly Agree",{"$f":"COUNTIFS('Code Book'!$C$3:$C$1048576,5,'Code Book'!$A$3:$A$1048576,4)","v":1},null,null,null,null,null,null,null,null,"Strongly Agree",{"$f":"COUNTIFS('Code Book'!$F$3:$F$1048576,5,'Code Book'!$A$3:$A$1048576,4)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Newsletter?"]
["Representative Prompt?",null,null,null,null,null,null,null,null,null,"Yes",{"$f":"COUNTIFS('Code Book'!$G$3:$G$1048576,1,'Code Book'!$A$3:$A$1048576,4)","v":3}]
["Strongly Disagree",{"$f":"COUNTIFS('Code Book'!$D$3:$D$1048576,1,'Code Book'!$A$3:$A$1048576,4)","v":0},null,null,null,null,null,null,null,null,"No",{"$f":"COUNTIFS('Code Book'!$G$3:$G$1048576,0,'Code Book'!$A$3:$A$1048576,4)","v":3}]
["Disagree",{"$f":"COUNTIFS('Code Book'!$D$3:$D$1048576,2,'Code Book'!$A$3:$A$1048576,4)","v":0}]
["Neutral",{"$f":"COUNTIFS('Code Book'!$D$3:$D$1048576,3,'Code Book'!$A$3:$A$1048576,4)","v":2}]
["Agree",{"$f":"COUNTIFS('Code Book'!$D$3:$D$1048576,4,'Code Book'!$A$3:$A$1048576,4)","v":4}]
["Strongly Agree",{"$f":"COUNTIFS('Code Book'!$D$3:$D$1048576,5,'Code Book'!$A$3:$A$1048576,4)","v":0}]

{"sheet":"Public Works","index":7,"n_rows":41,"n_cols":12,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,19]]}
["Public Works"]
[]
[]
[]
[]
[]
["Wait Time",null,null,null,null,null,null,null,null,null,"Representative Knowledgeable?"]
["0 minutes",{"$f":"COUNTIFS('Code Book'!$B$3:$B$1048576,1,'Code Book'!$A$3:$A$1048576,5)","v":3},null,null,null,null,null,null,null,null,"Strongly Disagree",{"$f":"COUNTIFS('Code Book'!$E$3:$E$1048576,1,'Code Book'!$A$3:$A$1048576,5)","v":0}]
["Less than 5 min",{"$f":"COUNTIFS('Code Book'!$B$3:$B$1048576,2,'Code Book'!$A$3:$A$1048576,5)","v":0},null,null,null,null,null,null,null,null,"Disagree",{"$f":"COUNTIFS('Code Book'!$E$3:$E$1048576,2,'Code Book'!$A$3:$A$1048576,5)","v":0}]
["5-10 min",{"$f":"COUNTIFS('Code Book'!$B$3:$B$1048576,3,'Code Book'!$A$3:$A$1048576,5)","v":2},null,null,null,null,null,null,null,null,"Neutral",{"$f":"COUNTIFS('Code Book'!$E$3:$E$1048576,3,'Code Book'!$A$3:$A$1048576,5)","v":3}]
["Over 10 min",{"$f":"COUNTIFS('Code Book'!$B$3:$B$1048576,4,'Code Book'!$A$3:$A$1048576,5)","v":0},null,null,null,null,null,null,null,null,"Agree",{"$f":"COUNTIFS('Code Book'!$E$3:$E$1048576,4,'Code Book'!$A$3:$A$1048576,5)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Strongly Agree",{"$f":"COUNTIFS('Code Book'!$E$3:$E$1048576,5,'Code Book'!$A$3:$A$1048576,5)","v":2}]
[]
[]
[]
[]
[]
[]
[]
[]
["Representative Courteous?",null,null,null,null,null,null,null,null,null,"Request Handled in Satisfactory Manner?"]
["Strongly Disagree",{"$f":"COUNTIFS('Code Book'!$C$3:$C$1048576,1,'Code Book'!$A$3:$A$1048576,5)","v":0},null,null,null,null,null,null,null,null,"Strongly Disagree",{"$f":"COUNTIFS('Code Book'!$F$3:$F$1048576,1,'Code Book'!$A$3:$A$1048576,5)","v":0}]
["Disagree",{"$f":"COUNTIFS('Code Book'!$C$3:$C$1048576,2,'Code Book'!$A$3:$A$1048576,5)","v":3},null,null,null,null,null,null,null,null,"Disagree",{"$f":"COUNTIFS('Code Book'!$F$3:$F$1048576,2,'Code Book'!$A$3:$A$1048576,5)","v":3}]
["Neutral",{"$f":"COUNTIFS('Code Book'!$C$3:$C$1048576,3,'Code Book'!$A$3:$A$1048576,5)","v":0},null,null,null,null,null,null,null,null,"Neutral",{"$f":"COUNTIFS('Code Book'!$F$3:$F$1048576,3,'Code Book'!$A$3:$A$1048576,5)","v":2}]
["Agree",{"$f":"COUNTIFS('Code Book'!$C$3:$C$1048576,4,'Code Book'!$A$3:$A$1048576,5)","v":2},null,null,null,null,null,null,null,null,"Agree",{"$f":"COUNTIFS('Code Book'!$F$3:$F$1048576,4,'Code Book'!$A$3:$A$1048576,5)","v":0}]
["Strongly Agree",{"$f":"COUNTIFS('Code Book'!$C$3:$C$1048576,5,'Code Book'!$A$3:$A$1048576,5)","v":0},null,null,null,null,null,null,null,null,"Strongly Agree",{"$f":"COUNTIFS('Code Book'!$F$3:$F$1048576,5,'Code Book'!$A$3:$A$1048576,5)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Newsletter?"]
["Representative Prompt?",null,null,null,null,null,null,null,null,null,"Yes",{"$f":"COUNTIFS('Code Book'!$G$3:$G$1048576,1,'Code Book'!$A$3:$A$1048576,5)","v":2}]
["Strongly Disagree",{"$f":"COUNTIFS('Code Book'!$D$3:$D$1048576,1,'Code Book'!$A$3:$A$1048576,5)","v":0},null,null,null,null,null,null,null,null,"No",{"$f":"COUNTIFS('Code Book'!$G$3:$G$1048576,0,'Code Book'!$A$3:$A$1048576,5)","v":3}]
["Disagree",{"$f":"COUNTIFS('Code Book'!$D$3:$D$1048576,2,'Code Book'!$A$3:$A$1048576,5)","v":1}]
["Neutral",{"$f":"COUNTIFS('Code Book'!$D$3:$D$1048576,3,'Code Book'!$A$3:$A$1048576,5)","v":0}]
["Agree",{"$f":"COUNTIFS('Code Book'!$D$3:$D$1048576,4,'Code Book'!$A$3:$A$1048576,5)","v":2}]
["Strongly Agree",{"$f":"COUNTIFS('Code Book'!$D$3:$D$1048576,5,'Code Book'!$A$3:$A$1048576,5)","v":2}]

{"sheet":"Code Book","index":8,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["Service Satisfaction Questionnaire"]
["Department","Wait Time","Representative Courteous?","Representative Prompt?","Representative Knowledgeable?","Request Handled to Satisfaction?","Newsletter?"]
[3,2,2,4,3,2,1]
[2,3,2,4,3,5,0]
[4,2,2,4,2,4,1]
[5,3,2,4,3,2,0]
[2,1,2,2,3,2,0]
[1,2,5,4,2,4,0]
[2,4,3,1,4,1,0]
[5,1,4,5,5,3,1]
[4,3,1,3,1,4,0]
[3,4,4,2,4,5,0]
[3,2,2,4,3,2,1]
[2,3,2,4,3,5,0]
[4,2,2,4,2,4,1]
[5,3,2,4,3,2,0]
[2,1,2,2,3,2,0]
[1,2,5,4,2,4,0]
[2,4,3,1,4,1,0]
[5,1,4,5,5,3,1]
[4,3,1,3,1,4,0]
[3,4,4,2,4,5,0]
[1,2,2,4,3,2,1]
[2,3,2,4,3,5,0]
[4,2,2,4,2,4,1]
[1,3,2,4,3,2,0]
[5,1,2,2,3,2,0]
[4,2,5,4,2,4,0]
[2,4,3,1,4,1,0]
[3,1,4,5,3]
[3,2,4,3,5]

{"sheet":"Validation Questions","index":9,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Department",null,"Wait Time",null,"Representative Questions",null,"Newsletter"]
["Administration/Front Desk",null,"0 minutes",null,"Strongly Disagree",null,"Yes"]
["Community Development",null,"Less than 5 min",null,"Disagree",null,"No"]
["Justice Court",null,"5-10 min",null,"Neutral"]
["Parks & Recreation",null,"Over 10 min",null,"Agree"]
["Public Works",null,null,null,"Strongly Agree"]