{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Dashboard","Underlying data"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Dashboard","index":0,"n_rows":30,"n_cols":20,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,1,0,17],[2,16,2,17],[26,1,26,17],[29,1,29,17]]}
[null,"VILLAGE OF SARANAC - PERFORMANCE DASHBOARD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hide columns H & I  before publishing. Also hide the underlying data tab"]
[null,null,{"$f":"+'Underlying data'!B1","v":"2008"},{"$f":"+'Underlying data'!C1","v":"2009"},{"$f":"+'Underlying data'!D1","v":"2010"},{"$f":"+'Underlying data'!E1","v":"2011"},{"$f":"+'Underlying data'!F1","v":"2012"},{"$f":"+'Underlying data'!G1","v":"2013"},null,null,null,null,null,null,null,null,"Trend","Performance",0.01,"threshhold for Good or Bad change"]
[null,"Fiscal Stability",null,null,null,null,null,null,"2015","2016","2017","2018","2019","2020","2021","2022","2021 to 2022",null,"Is an increase \"Good, Bad, or Neutral? "]
[null,{"$f":"+'Underlying data'!A4","v":"Annual GF Expenditures per capita"},{"$f":"+'Underlying data'!B6","v":333.333333333333},{"$f":"+'Underlying data'!C6","v":351.351351351351},{"$f":"+'Underlying data'!D6","v":588.347169811321},{"$f":"+'Underlying data'!E6","v":833.507924528302},{"$f":"+'Underlying data'!F6","v":568.444603773585},{"$f":"+'Underlying data'!G6","v":620.302641509434},{"$f":"+'Underlying data'!I6","v":585.907924528302},{"$f":"+'Underlying data'!J6","v":585.576603773585},{"$f":"+'Underlying data'!K6","v":532.557735849057},{"$f":"+'Underlying data'!L6","v":762.036981132075},{"$f":"+'Underlying data'!M6","v":742.190943396226},{"$f":"+'Underlying data'!N6","v":649.65962264151},{"$f":"+'Underlying data'!O6","v":419.162790697674},{"$f":"+'Underlying data'!P6","v":368.873546511628},{"$f":"+P4/O4-1","v":-0.119975449400799},"Positive","Bad"]
[null,{"$f":"+'Underlying data'!A7","v":"Fund Balance as % of Annual GF Expenditures"},{"$f":"+'Underlying data'!B9","v":0.2},{"$f":"+'Underlying data'!C9","v":0.211538461538462},{"$f":"+'Underlying data'!D9","v":1.2428126122428},{"$f":"+'Underlying data'!E9","v":0.517909304435539},{"$f":"+'Underlying data'!F9","v":0.819889719593659},{"$f":"+'Underlying data'!G9","v":0.595282156853441},{"$f":"+'Underlying data'!I9","v":0.512532074071784},{"$f":"+'Underlying data'!J9","v":0.644964679226023},{"$f":"+'Underlying data'!K9","v":0.809106356082926},{"$f":"+'Underlying data'!L9","v":0.633447195649397},{"$f":"+'Underlying data'!M9","v":0.75056614633065},{"$f":"+'Underlying data'!N9","v":0.875594651016091},{"$f":"+'Underlying data'!O9","v":1.32273461773191},{"$f":"+'Underlying data'!P9","v":1.70877908465827},{"$f":"+P5/O5-1","v":0.291853302810135},"Positive","Good"]
[null,{"$f":"+'underlying data'!#ref!","v":{"$error":"#VALUE!"}},{"$f":"+'underlying data'!#ref!","v":{"$error":"#VALUE!"}},{"$f":"+'underlying data'!#ref!","v":{"$error":"#VALUE!"}},{"$f":"+'underlying data'!#ref!","v":{"$error":"#VALUE!"}},{"$f":"+'underlying data'!#ref!","v":{"$error":"#VALUE!"}},{"$f":"+'underlying data'!#ref!","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"+'Underlying data'!L8","v":639591},null,null,null,null,{"$f":"+I6/H6-1","v":{"$error":"#DIV/0!"}},{"$f":"IF(ABS(F6/E6-1)<$S$2,\"Neutral\",IF(S6=\"Good\",IF(F6>E6,\"Positive\",\"Negative\"),IF(S6=\"Bad\",IF(F6<E6,\"Positive\",\"Negative\"),\"Neutral\")))","v":{"$error":"#VALUE!"}},"Bad"]
[null,{"$f":"+'underlying data'!#ref!","v":{"$error":"#VALUE!"}},{"$f":"+'underlying data'!#ref!","v":{"$error":"#VALUE!"}},{"$f":"+'underlying data'!#ref!","v":{"$error":"#VALUE!"}},{"$f":"+'underlying data'!#ref!","v":{"$error":"#VALUE!"}},{"$f":"+'underlying data'!#ref!","v":{"$error":"#VALUE!"}},{"$f":"+'underlying data'!#ref!","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"+'Underlying data'!L9","v":0.633447195649397},null,null,null,null,{"$f":"+I7/H7-1","v":{"$error":"#DIV/0!"}},{"$f":"IF(ABS(F7/E7-1)<$S$2,\"Neutral\",IF(S7=\"Good\",IF(F7>E7,\"Positive\",\"Negative\"),IF(S7=\"Bad\",IF(F7<E7,\"Positive\",\"Negative\"),\"Neutral\")))","v":{"$error":"#VALUE!"}},"Bad"]
[1,"Unfunded Pension & Retiree health care liability, as a % of annual GF revenue",null,null,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[2,"Debt burden per capita",null,null,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,{"$f":"+'Underlying data'!A10","v":"Percentage of road funding provided by the General Fund"},{"$f":"+'Underlying data'!B19","v":0.189655172413793},{"$f":"+'Underlying data'!C19","v":0.212585034013605},{"$f":"+'Underlying data'!D19","v":0.335036858650293},{"$f":"+'Underlying data'!E19","v":0.384693935040424},{"$f":"+'Underlying data'!F19","v":0.345621395849611},{"$f":"+'Underlying data'!G19","v":0.634956085450287},{"$f":"+'Underlying data'!I19","v":0.23019919523098},{"$f":"+'Underlying data'!J19","v":0.0535841069538775},{"$f":"+'Underlying data'!K19","v":0.0976355546346981},{"$f":"+'Underlying data'!L19","v":0.225907331882255},{"$f":"+'Underlying data'!M19","v":0.212346387398281},{"$f":"+'Underlying data'!N19","v":0.365119886058455},{"$f":"+'Underlying data'!O19","v":0.228077791829467},{"$f":"+'Underlying data'!P19","v":0},{"$f":"+P10/O10-1","v":-1},"Positive","Neutral"]
[null,{"$f":"+'underlying data'!#ref!","v":{"$error":"#VALUE!"}},{"$f":"+'underlying data'!#ref!","v":{"$error":"#VALUE!"}},{"$f":"+'underlying data'!#ref!","v":{"$error":"#VALUE!"}},{"$f":"+'underlying data'!#ref!","v":{"$error":"#VALUE!"}},{"$f":"+'underlying data'!#ref!","v":{"$error":"#VALUE!"}},{"$f":"+'underlying data'!#ref!","v":{"$error":"#VALUE!"}},{"$f":"+'underlying data'!#ref!","v":{"$error":"#VALUE!"}},{"$f":"+'underlying data'!#ref!","v":{"$error":"#VALUE!"}},{"$f":"+'underlying data'!#ref!","v":{"$error":"#VALUE!"}},null,{"$f":"+'Underlying data'!L13","v":75810.66},null,null,null,null,{"$f":"+N11/M11-1","v":{"$error":"#DIV/0!"}},{"$f":"IF(ABS(F11/E11-1)<$S$2,\"Neutral\",IF(S11=\"Good\",IF(F11>E11,\"Positive\",\"Negative\"),IF(S11=\"Bad\",IF(F11<E11,\"Positive\",\"Negative\"),\"Neutral\")))","v":{"$error":"#VALUE!"}},"Bad"]
[null,{"$f":"+'Underlying data'!A20","v":"Number of services delivered via cooperative venture"},{"$f":"+'Underlying data'!B32","v":2},{"$f":"+'Underlying data'!C32","v":1},{"$f":"+'Underlying data'!D32","v":6},{"$f":"+'Underlying data'!E32","v":6},{"$f":"+'Underlying data'!F32","v":6},{"$f":"+'Underlying data'!G32","v":6},{"$f":"+'Underlying data'!I32","v":6},{"$f":"+'Underlying data'!J32","v":6},{"$f":"+'Underlying data'!K32","v":6},{"$f":"+'Underlying data'!L32","v":6},{"$f":"+'Underlying data'!M32","v":6},{"$f":"+'Underlying data'!N32","v":6},{"$f":"+'Underlying data'!O32","v":6},{"$f":"+'Underlying data'!P32","v":6},{"$f":"+P12/O12-1","v":0},{"$f":"IF(ABS(F12/E12-1)<$S$2,\"Neutral\",IF(S12=\"Good\",IF(F12>E12,\"Positive\",\"Negative\"),IF(S12=\"Bad\",IF(F12<E12,\"Positive\",\"Negative\"),\"Neutral\")))","v":"Neutral"},"Good"]
[null,"Economic Strength"]
[null,{"$f":"+'Underlying data'!A34","v":"% of community with access to high speed broadband"},{"$f":"+'Underlying data'!B37","v":0.919354838709677},{"$f":"+'Underlying data'!C37","v":0.919354838709677},{"$f":"+'Underlying data'!D37","v":1},{"$f":"+'Underlying data'!E37","v":1},{"$f":"+'Underlying data'!F37","v":1},{"$f":"+'Underlying data'!G37","v":1},{"$f":"+'Underlying data'!I37","v":1},{"$f":"+'Underlying data'!J37","v":1},{"$f":"+'Underlying data'!K37","v":1},{"$f":"+'Underlying data'!L37","v":1},{"$f":"+'Underlying data'!M37","v":1},{"$f":"+'Underlying data'!N37","v":1},{"$f":"+'Underlying data'!O37","v":1},{"$f":"+'Underlying data'!P37","v":1},{"$f":"+P14/O14-1","v":0},{"$f":"IF(ABS(F14/E14-1)<$S$2,\"Neutral\",IF(S14=\"Good\",IF(F14>E14,\"Positive\",\"Negative\"),IF(S14=\"Bad\",IF(F14<E14,\"Positive\",\"Negative\"),\"Neutral\")))","v":"Neutral"},"Good"]
[null,{"$f":"+'Underlying data'!A39","v":"% of community age 25+ with Bachelor's Degree or higher. "},{"$f":"+'Underlying data'!B42","v":0.726343612334802},{"$f":"+'Underlying data'!C42","v":0.726343612334802},{"$f":"+'Underlying data'!D42","v":0.140547263681592},{"$f":"+'Underlying data'!E42","v":0.140547263681592},{"$f":"+'Underlying data'!F42","v":0.140547263681592},{"$f":"+'Underlying data'!G42","v":0.140547263681592},{"$f":"+'Underlying data'!I42","v":0.140547263681592},{"$f":"+'Underlying data'!J42","v":0.140547263681592},{"$f":"+'Underlying data'!K42","v":0.140547263681592},{"$f":"+'Underlying data'!L42","v":0.140547263681592},{"$f":"+'Underlying data'!M42","v":0.140547263681592},{"$f":"+'Underlying data'!N42","v":0.140547263681592},{"$f":"+'Underlying data'!O42","v":0.140547263681592},{"$f":"+'Underlying data'!P42","v":0.256224066390041},{"$f":"+P15/O15-1","v":0.823045569713216},"Positive","Good"]
[null,{"$f":"+'Underlying data'!A44","v":"Average age of critical infrastructure (years)"},{"$f":"+'Underlying data'!B84","v":18.8571428571429},{"$f":"+'Underlying data'!C84","v":18.5333333333333},{"$f":"+'Underlying data'!D84","v":0},{"$f":"+'Underlying data'!E84","v":0},{"$f":"+'Underlying data'!F84","v":0},{"$f":"+'Underlying data'!G84","v":0},{"$f":"+'Underlying data'!H84","v":0},{"$f":"+'Underlying data'!I84","v":0},null,{"$f":"+'Underlying data'!L18","v":68000},null,null,null,null,{"$f":"+N16/M16-1","v":{"$error":"#DIV/0!"}},{"$f":"IF(ABS(F16/E16-1)<$S$2,\"Neutral\",IF(S16=\"Good\",IF(F16>E16,\"Positive\",\"Negative\"),IF(S16=\"Bad\",IF(F16<E16,\"Positive\",\"Negative\"),\"Neutral\")))","v":{"$error":"#DIV/0!"}},"Bad"]
[null,"Public Safety"]
[null,{"$f":"+'Underlying data'!A87","v":"Violent crimes per thousand"},{"$f":"+'Underlying data'!B89","v":16},{"$f":"+'Underlying data'!C89","v":16.8918918918919},{"$f":"+'Underlying data'!D89","v":4.52830188679245},{"$f":"+'Underlying data'!E89","v":1.50943396226415},{"$f":"+'Underlying data'!F89","v":1.50943396226415},{"$f":"+'Underlying data'!G89","v":2.26415094339623},{"$f":"+'Underlying data'!I89","v":0},{"$f":"+'Underlying data'!J89","v":2.26415094339623},{"$f":"+'Underlying data'!K89","v":4.52830188679245},0.01,{"$f":"+'Underlying data'!M89","v":2.26415094339623},{"$f":"+'Underlying data'!N89","v":5.28301886792453},{"$f":"+'Underlying data'!O89","v":0},{"$f":"+'Underlying data'!P89","v":0},0,"Neutral","Bad"]
[null,{"$f":"+'Underlying data'!A91","v":"Property crimes per thousand"},{"$f":"+'Underlying data'!B93","v":56},{"$f":"+'Underlying data'!C93","v":57.4324324324324},{"$f":"+'Underlying data'!D93","v":19.622641509434},{"$f":"+'Underlying data'!E93","v":30.188679245283},{"$f":"+'Underlying data'!F93","v":13.5849056603774},{"$f":"+'Underlying data'!G93","v":12.0754716981132},{"$f":"+'Underlying data'!I93","v":10.5660377358491},{"$f":"+'Underlying data'!J93","v":3.77358490566038},{"$f":"+'Underlying data'!K93","v":14.3396226415094},{"$f":"+'Underlying data'!L93","v":9.81132075471698},{"$f":"+'Underlying data'!M93","v":8.30188679245283},{"$f":"+'Underlying data'!N93","v":6.79245283018868},{"$f":"+'Underlying data'!O93","v":2.90697674418605},{"$f":"+'Underlying data'!P93","v":1.45348837209302},{"$f":"+P19/O19-1","v":-0.5},"Positive","Bad"]
[null,{"$f":"+'Underlying data'!A95","v":"Traffic injuries or fatalities"},{"$f":"+'Underlying data'!B96","v":850},{"$f":"+'Underlying data'!C96","v":875},{"$f":"+'Underlying data'!D96","v":7},{"$f":"+'Underlying data'!E96","v":9},{"$f":"+'Underlying data'!F96","v":8},{"$f":"+'Underlying data'!G96","v":7},{"$f":"+'Underlying data'!I96","v":7},{"$f":"+'Underlying data'!J96","v":10},{"$f":"+'Underlying data'!K96","v":4},{"$f":"+'Underlying data'!L96","v":6},{"$f":"+'Underlying data'!M96","v":6},{"$f":"+'Underlying data'!N96","v":3},{"$f":"+'Underlying data'!O96","v":9},{"$f":"+'Underlying data'!P96","v":7},{"$f":"+P20/O20-1","v":-0.222222222222222},"Positive","Bad"]
[null,"Quality of Life"]
[null,{"$f":"+'Underlying data'!A99","v":"Miles of sidewalks and non-motorized paths/trails as a factor of total miles of local/major road streets"},{"$f":"+'Underlying data'!B102","v":0.214285714285714},{"$f":"+'Underlying data'!C102","v":0.242857142857143},{"$f":"+'Underlying data'!D102","v":1.21130551816958},{"$f":"+'Underlying data'!E102","v":1.21130551816958},{"$f":"+'Underlying data'!F102","v":1.21130551816958},{"$f":"+'Underlying data'!G102","v":1.21130551816958},{"$f":"+'Underlying data'!I102","v":1.39300134589502},{"$f":"+'Underlying data'!J102","v":1.39300134589502},{"$f":"+'Underlying data'!K102","v":1.39300134589502},{"$f":"+'Underlying data'!L102","v":1.39300134589502},{"$f":"+'Underlying data'!M102","v":1.39300134589502},{"$f":"+'Underlying data'!N102","v":1.39300134589502},{"$f":"+'Underlying data'!O102","v":1.39300134589502},{"$f":"+'Underlying data'!P102","v":1.39300134589502},{"$f":"+P22/O22-1","v":0},"Neutral","Good"]
[null,{"$f":"+'Underlying data'!A104","v":"Percent of GF Expenditures Committed to Arts, Culture and Recreation"},{"$f":"+'Underlying data'!B106","v":0.09},{"$f":"+'Underlying data'!C106","v":0.0853846153846154},{"$f":"+'Underlying data'!D106","v":0.0711029298578685},{"$f":"+'Underlying data'!E106","v":0.0284498885365602},{"$f":"+'Underlying data'!F106","v":0.0567095301830576},{"$f":"+'Underlying data'!G106","v":0.0589170715207793},{"$f":"+'Underlying data'!I106","v":0.0552987912325718},{"$f":"+'Underlying data'!J106","v":0.0713362349511335},{"$f":"+'Underlying data'!K106","v":0.075007192062797},{"$f":"+'Underlying data'!L106","v":0.0408666345118694},{"$f":"+'Underlying data'!M106","v":0.0442372048895519},{"$f":"+'Underlying data'!N106","v":0.264900400674257},{"$f":"+'Underlying data'!O106","v":0.0962380021083},{"$f":"+'Underlying data'!P106","v":0.118708749532084},{"$f":"+P23/O23-1","v":0.233491416400115},"Positive","Neutral"]
[null,{"$f":"+'Underlying data'!A108","v":"Acres of park per thousand residents"},{"$f":"+'Underlying data'!B110","v":2.4},{"$f":"+'Underlying data'!C110","v":2.43243243243243},{"$f":"+'Underlying data'!D110","v":61.5094339622642},{"$f":"+'Underlying data'!E110","v":61.5094339622642},{"$f":"+'Underlying data'!F110","v":61.5094339622642},{"$f":"+'Underlying data'!G110","v":61.5094339622642},{"$f":"+'Underlying data'!I110","v":61.5094339622642},{"$f":"+'Underlying data'!J110","v":61.5094339622642},{"$f":"+'Underlying data'!K110","v":61.5094339622642},{"$f":"+'Underlying data'!L110","v":61.5094339622642},{"$f":"+'Underlying data'!M110","v":61.5094339622642},{"$f":"+'Underlying data'!N110","v":70.6188679245283},{"$f":"+'Underlying data'!O110","v":68.0014534883721},{"$f":"+'Underlying data'!P110","v":68.0014534883721},{"$f":"+P24/O24-1","v":0},"Neutral","Good"]
[null,{"$f":"+'Underlying data'!A112","v":"Percent of community being provided with curbside recycling"},{"$f":"+'Underlying data'!B114","v":0.953333333333333},{"$f":"+'Underlying data'!C114","v":0.966216216216216},{"$f":"+'Underlying data'!D114","v":1},{"$f":"+'Underlying data'!E114","v":1},{"$f":"+'Underlying data'!F114","v":1},{"$f":"+'Underlying data'!G114","v":1},{"$f":"+'Underlying data'!I114","v":1},{"$f":"+'Underlying data'!J114","v":1},{"$f":"+'Underlying data'!K114","v":1},{"$f":"+'Underlying data'!L114","v":1},{"$f":"+'Underlying data'!M114","v":1},{"$f":"+'Underlying data'!N114","v":1},{"$f":"+'Underlying data'!O114","v":1},{"$f":"+'Underlying data'!P114","v":1},{"$f":"+P25/O25-1","v":0},{"$f":"IF(ABS(F25/E25-1)<$S$2,\"Neutral\",IF(S25=\"Good\",IF(F25>E25,\"Positive\",\"Negative\"),IF(S25=\"Bad\",IF(F25<E25,\"Positive\",\"Negative\"),\"Neutral\")))","v":"Neutral"},"Good"]
[]
[1,"The Village of Saranac does not offer a pension plan or retiree health care and therefore does not have any "]
[null,"unfunded liabilities."]
[2,"The Village of Sarnanac Governmental Funds are debt free.  The Water/Sewer Fund, which is not included  "]
[null,"in this report, has an outstanding Bond with a principal balance of $390,000 at the end of the 2022 FY."]

{"sheet":"Underlying data","index":1,"n_rows":121,"n_cols":17,"rows_kept":121,"cut":false,"hidden":true,"merged":[]}
[null,"2008","2009","2010","2011","2012","2013","2014","2015","2016","2017","2018","2019","2020","2021","2022","Comments"]
["Population",7500,7400,1325,1325,1325,1325,1325,1325,1325,1325,1325,1325,1325,1376,1376,"We suggest you \"Hide\" this tab before publishing the Excel file to your web site."]
[]
["Annual GF Expenditures per capita",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alternatively, you might consider using All Governmental funds' spending per capita"]
["General Fund Expenditures",2500000,2600000,{"$f":"852460-72900","v":779560},{"$f":"1530662-218500-207764","v":1104398},753189.1,821901,745529.36,776328,775889,{"$f":"724639-19000","v":705639},{"$f":"1077699-68000","v":1009699},{"$f":"1048403-65000","v":983403},860799,576768,507570]
["Expenditures per capita",{"$f":"+B5/B2","v":333.333333333333},{"$f":"+C5/C2","v":351.351351351351},{"$f":"+D5/D2","v":588.347169811321},{"$f":"+E5/E2","v":833.507924528302},{"$f":"+F5/F2","v":568.444603773585},{"$f":"+G5/G2","v":620.302641509434},{"$f":"+H5/H2","v":562.663667924528},{"$f":"+I5/I2","v":585.907924528302},{"$f":"+J5/J2","v":585.576603773585},{"$f":"+K5/K2","v":532.557735849057},{"$f":"+L5/L2","v":762.036981132075},{"$f":"+M5/M2","v":742.190943396226},{"$f":"+N5/N2","v":649.65962264151},{"$f":"+O5/O2","v":419.162790697674},{"$f":"+P5/P2","v":368.873546511628}]
["Fund Balance as % of Annual GF Expenditures",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alternatively, you couild use \"Unreserved\" Fund Balance."]
["Fund Balance ",500000,550000,968847,571978,617532,489263,448169,397893,500421,570937,639591,738109,{"$f":"783477-29766","v":753711},762911,867325]
["Fund Balance as % of Annual GF Expenditures",{"$f":"+B8/B5","v":0.2},{"$f":"+C8/C5","v":0.211538461538462},{"$f":"+D8/D5","v":1.2428126122428},{"$f":"+E8/E5","v":0.517909304435539},{"$f":"+F8/F5","v":0.819889719593659},{"$f":"+G8/G5","v":0.595282156853441},{"$f":"+H8/H5","v":0.601141985876988},{"$f":"+I8/I5","v":0.512532074071784},{"$f":"+J8/J5","v":0.644964679226023},{"$f":"+K8/K5","v":0.809106356082926},{"$f":"+L8/L5","v":0.633447195649397},{"$f":"+M8/M5","v":0.75056614633065},{"$f":"+N8/N5","v":0.875594651016091},{"$f":"+O8/O5","v":1.32273461773191},{"$f":"+P8/P5","v":1.70877908465827}]
["Percentage of road funding provided by the General Fund"]
["Road expenditures:"]
["Major streets fund",320000,324000,125046,490384,108330.83,281076,111392.92,198685.27,124791.22,116573.67,225197.72,217474.35,164068,144227,133377.34]
["Local streets fund",260000,264000,92542,77600,130369.67,103990,185752.24,72818.72,61831.28,78027.57,75810.66,88629.28,333029,491521,85726.81]
["Total road expenditures",{"$f":"SUM(B12:B13)","v":580000},{"$f":"SUM(C12:C13)","v":588000},{"$f":"SUM(D12:D13)","v":217588},{"$f":"SUM(E12:E13)","v":567984},{"$f":"SUM(F12:F13)","v":238700.5},{"$f":"SUM(G12:G13)","v":385066},{"$f":"SUM(H12:H13)","v":297145.16},{"$f":"SUM(I12:I13)","v":271503.99},{"$f":"SUM(J12:J13)","v":186622.5},{"$f":"SUM(K12:K13)","v":194601.24},{"$f":"SUM(L12:L13)","v":301008.38},{"$f":"SUM(M12:M13)","v":306103.63},{"$f":"SUM(N12:N13)","v":497097},{"$f":"SUM(O12:O13)","v":635748},{"$f":"SUM(P12:P13)","v":219104.15}]
["Transfers from the General Fund into:"]
["Major streets fund",null,null,30000,189000,0,187000,0,45000,6000,0,63000,50000,0,0,0]
["Local streets fund",110000,125000,42900,29500,82500,57500,140000,17500,4000,19000,5000,15000,181500,145000,0]
["Total General Fund funding",{"$f":"SUM(B15:B17)","v":110000},{"$f":"SUM(C15:C17)","v":125000},{"$f":"SUM(D15:D17)","v":72900},{"$f":"SUM(E15:E17)","v":218500},{"$f":"SUM(F15:F17)","v":82500},{"$f":"SUM(G15:G17)","v":244500},{"$f":"SUM(H15:H17)","v":140000},{"$f":"SUM(I15:I17)","v":62500},{"$f":"SUM(J15:J17)","v":10000},{"$f":"SUM(K15:K17)","v":19000},{"$f":"SUM(L15:L17)","v":68000},{"$f":"SUM(M15:M17)","v":65000},{"$f":"SUM(N15:N17)","v":181500},{"$f":"SUM(O15:O17)","v":145000},{"$f":"SUM(P15:P17)","v":0}]
["Ratio of road funding to total GF expenditures",{"$f":"+B18/B14","v":0.189655172413793},{"$f":"+C18/C14","v":0.212585034013605},{"$f":"+D18/D14","v":0.335036858650293},{"$f":"+E18/E14","v":0.384693935040424},{"$f":"+F18/F14","v":0.345621395849611},{"$f":"+G18/G14","v":0.634956085450287},{"$f":"+H18/H14","v":0.471150194739837},{"$f":"+I18/I14","v":0.23019919523098},{"$f":"+J18/J14","v":0.0535841069538775},{"$f":"+K18/K14","v":0.0976355546346981},{"$f":"+L18/L14","v":0.225907331882255},{"$f":"+M18/M14","v":0.212346387398281},{"$f":"+N18/N14","v":0.365119886058455},{"$f":"+O18/O14","v":0.228077791829467},{"$f":"+P18/P14","v":0}]
["Number of services delivered via cooperative venture",null,null,6,6,6,6,6,6,6,6,6,6,6,6,6]
["List the individual services delivered via cooperative venture:    (place an \"X\" in each year the services were delivered cooperatively)"]
["Library","X","X","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["Dispatch",null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
["Building inspections",null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
["Recreation","X"]
["Finance dept. consolidation"]
["Assessing",null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
["Fire",null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
["Police",null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
["Other:"]
[]
["Totals",{"$f":"COUNTA(B21:B31)","v":2},{"$f":"COUNTA(C21:C31)","v":1},{"$f":"COUNTA(D21:D31)","v":6},{"$f":"COUNTA(E21:E31)","v":6},{"$f":"COUNTA(F21:F31)","v":6},{"$f":"COUNTA(G21:G31)","v":6},{"$f":"COUNTA(H21:H31)","v":6},{"$f":"COUNTA(I21:I31)","v":6},{"$f":"COUNTA(J21:J31)","v":6},{"$f":"COUNTA(K21:K31)","v":6},{"$f":"COUNTA(L21:L31)","v":6},{"$f":"COUNTA(M21:M31)","v":6},{"$f":"COUNTA(N21:N31)","v":6},{"$f":"COUNTA(O21:O31)","v":6},{"$f":"COUNTA(P21:P31)","v":6}]
["Economic Strength"]
["% of community with access to high speed broadband",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% with access (not how many residents are actively utilizing the service)."]
["Number of homes",3100,3100,511,511,511,511,511,511,511,511,511,511,511,511,511]
["Number of homes passed by highspeed internet",2850,2850,511,511,511,511,511,511,511,511,511,511,511,511,511]
["% of homes with access to high speed boradband",{"$f":"+B36/B35","v":0.919354838709677},{"$f":"+C36/C35","v":0.919354838709677},{"$f":"+D36/D35","v":1},{"$f":"+E36/E35","v":1},{"$f":"+F36/F35","v":1},{"$f":"+G36/G35","v":1},{"$f":"+H36/H35","v":1},{"$f":"+I36/I35","v":1},{"$f":"+J36/J35","v":1},{"$f":"+K36/K35","v":1},{"$f":"+L36/L35","v":1},{"$f":"+M36/M35","v":1},{"$f":"+N36/N35","v":1},{"$f":"+O36/O35","v":1},{"$f":"+P36/P35","v":1}]
[]
["% of community age 25+ with Bachelor's Degree or higher. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Report consistent with the most current census data."]
["Population aged 25 and over",5675,5675,804,804,804,804,804,804,804,804,804,804,804,804,964,"Alternative: % of High school graduates going to college (data point is available from the local school district)."]
["Number with Bachelor's degree or higher",4122,4122,113,113,113,113,113,113,113,113,113,113,113,113,247]
["% of community age 25+ with bachelor's degree or higher",{"$f":"+B41/B40","v":0.726343612334802},{"$f":"+C41/C40","v":0.726343612334802},{"$f":"+D41/D40","v":0.140547263681592},{"$f":"+E41/E40","v":0.140547263681592},{"$f":"+F41/F40","v":0.140547263681592},{"$f":"+G41/G40","v":0.140547263681592},{"$f":"+H41/H40","v":0.140547263681592},{"$f":"+I41/I40","v":0.140547263681592},{"$f":"+J41/J40","v":0.140547263681592},{"$f":"+K41/K40","v":0.140547263681592},{"$f":"+L41/L40","v":0.140547263681592},{"$f":"+M41/M40","v":0.140547263681592},{"$f":"+N41/N40","v":0.140547263681592},{"$f":"+O41/O40","v":0.140547263681592},{"$f":"+P41/P40","v":0.256224066390041}]
[]
["Average age of critical infrastructure (years)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Buildings need not be reported."]
["Water lines"]
["Historical cost",15000000,15000000]
["Accumulated depreciation",6000000,{"$f":"+B47+B46/$B48","v":6250000}]
["Average depreciable life (in years)",60,60]
["Average age",{"$f":"IF(B46>0,+B47/(B46/B48),\"\")","v":24},{"$f":"IF(C46>0,+C47/(C46/C48),\"\")","v":25},{"$f":"IF(D46>0,+D47/(D46/D48),\"\")","v":""},{"$f":"IF(E46>0,+E47/(E46/E48),\"\")","v":""}]
["component of the weighted average",{"$f":"IF(ISNUMBER(B49)=TRUE(),B49*B46/B$83,\"\")","v":5.14285714285714},{"$f":"IF(ISNUMBER(C49)=TRUE(),C49*C46/C$83,\"\")","v":5},{"$f":"IF(ISNUMBER(D49)=TRUE(),D49*D46/D$83,\"\")","v":""},{"$f":"IF(ISNUMBER(E49)=TRUE(),E49*E46/E$83,\"\")","v":""}]
["Sewer lines"]
["Historical cost",15000000,18000000]
["Accumulated depreciation",6000000,{"$f":"+B53+B52/$B54","v":6200000}]
["Average depreciable life (in years)",75,75]
["Average age",{"$f":"IF(B52>0,+B53/(B52/B54),\"\")","v":30},{"$f":"IF(C52>0,+C53/(C52/C54),\"\")","v":25.8333333333333},{"$f":"IF(D52>0,+D53/(D52/D54),\"\")","v":""},{"$f":"IF(E52>0,+E53/(E52/E54),\"\")","v":""}]
["component of the weighted average",{"$f":"IF(ISNUMBER(B55)=TRUE(),B55*B52/B$83,\"\")","v":6.42857142857143},{"$f":"IF(ISNUMBER(C55)=TRUE(),C55*C52/C$83,\"\")","v":6.2},{"$f":"IF(ISNUMBER(D55)=TRUE(),D55*D52/D$83,\"\")","v":""},{"$f":"IF(ISNUMBER(E55)=TRUE(),E55*E52/E$83,\"\")","v":""}]
["Roads"]
["Historical cost",30000000,32000000]
["Accumulated depreciation",18000000,{"$f":"+B59+B58/$B60","v":19500000}]
["Average depreciable life (in years)",20,20]
["Average age",{"$f":"IF(B58>0,+B59/(B58/B60),\"\")","v":12},{"$f":"IF(C58>0,+C59/(C58/C60),\"\")","v":12.1875},{"$f":"IF(D58>0,+D59/(D58/D60),\"\")","v":""},{"$f":"IF(E58>0,+E59/(E58/E60),\"\")","v":""}]
["component of the weighted average",{"$f":"IF(ISNUMBER(B61)=TRUE(),B61*B58/B$83,\"\")","v":5.14285714285714},{"$f":"IF(ISNUMBER(C61)=TRUE(),C61*C58/C$83,\"\")","v":5.2},{"$f":"IF(ISNUMBER(D61)=TRUE(),D61*D58/D$83,\"\")","v":""},{"$f":"IF(ISNUMBER(E61)=TRUE(),E61*E58/E$83,\"\")","v":""}]
["Storm drains"]
["Historical cost",10000000,10000000]
["Accumulated depreciation",2000000,{"$f":"+B65+B64/$B66","v":2133333.33333333}]
["Average depreciable life (in years)",75,{"$f":"+B66","v":75}]
["Average age",{"$f":"IF(B64>0,+B65/(B64/B66),\"\")","v":15},{"$f":"IF(C64>0,+C65/(C64/C66),\"\")","v":16},{"$f":"IF(D64>0,+D65/(D64/D66),\"\")","v":""},{"$f":"IF(E64>0,+E65/(E64/E66),\"\")","v":""}]
["component of the weighted average",{"$f":"IF(ISNUMBER(B67)=TRUE(),B67*B64/B$83,\"\")","v":2.14285714285714},{"$f":"IF(ISNUMBER(C67)=TRUE(),C67*C64/C$83,\"\")","v":2.13333333333333},{"$f":"IF(ISNUMBER(D67)=TRUE(),D67*D64/D$83,\"\")","v":""},{"$f":"IF(ISNUMBER(E67)=TRUE(),E67*E64/E$83,\"\")","v":""}]
[]
["Historical cost"]
["Accumulated depreciation"]
["Average depreciable life (in years)"]
["Average age",{"$f":"IF(B70>0,+B71/(B70/B72),\"\")","v":""},{"$f":"IF(C70>0,+C71/(C70/C72),\"\")","v":""},{"$f":"IF(D70>0,+D71/(D70/D72),\"\")","v":""},{"$f":"IF(E70>0,+E71/(E70/E72),\"\")","v":""}]
["component of the weighted average",{"$f":"IF(ISNUMBER(B73)=TRUE(),B73*B70/B$83,\"\")","v":""},{"$f":"IF(ISNUMBER(C73)=TRUE(),C73*C70/C$83,\"\")","v":""},{"$f":"IF(ISNUMBER(D73)=TRUE(),D73*D70/D$83,\"\")","v":""},{"$f":"IF(ISNUMBER(E73)=TRUE(),E73*E70/E$83,\"\")","v":""}]
[]
["Historical cost"]
["Accumulated depreciation"]
["Average depreciable life (in years)"]
["Average age",{"$f":"IF(B76>0,+B77/(B76/B78),\"\")","v":""},{"$f":"IF(C76>0,+C77/(C76/C78),\"\")","v":""},{"$f":"IF(D76>0,+D77/(D76/D78),\"\")","v":""},{"$f":"IF(E76>0,+E77/(E76/E78),\"\")","v":""}]
["component of the weighted average",{"$f":"IF(ISNUMBER(B79)=TRUE(),B79*B76/B$83,\"\")","v":""},{"$f":"IF(ISNUMBER(C79)=TRUE(),C79*C76/C$83,\"\")","v":""},{"$f":"IF(ISNUMBER(D79)=TRUE(),D79*D76/D$83,\"\")","v":""},{"$f":"IF(ISNUMBER(E79)=TRUE(),E79*E76/E$83,\"\")","v":""}]
[]
["Weighted average:"]
["Total cost of critical infrastructure",{"$f":"SUMIF($A$44:$A$82,\"Historical cost\",B44:B82)","v":70000000},{"$f":"SUMIF($A$44:$A$82,\"Historical cost\",C44:C82)","v":75000000},{"$f":"SUMIF($A$44:$A$82,\"Historical cost\",D44:D82)","v":0},{"$f":"SUMIF($A$44:$A$82,\"Historical cost\",E44:E82)","v":0}]
["Average age of critical infrastructure",{"$f":"SUMIF($A$44:$A$82,$A$50,B44:B82)","v":18.8571428571429},{"$f":"SUMIF($A$44:$A$82,$A$50,C44:C82)","v":18.5333333333333},{"$f":"SUMIF($A$44:$A$82,$A$50,D44:D82)","v":0},{"$f":"SUMIF($A$44:$A$82,$A$50,E44:E82)","v":0}]
[]
["Public Safety"]
["Violent crimes per thousand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"      Report consistent with the Michigan Incident Crime Reporting guidelines"]
["Violent crimes ",120,125,6,2,2,3,4,0,3,6,0,3,7,0,0,"2010 and 2011 from roger vandermolen via micr"]
["Violent crimes per thousand",{"$f":"+B88/(B$2/1000)","v":16},{"$f":"+C88/(C$2/1000)","v":16.8918918918919},{"$f":"+D88/(D$2/1000)","v":4.52830188679245},{"$f":"+E88/(E$2/1000)","v":1.50943396226415},{"$f":"+F88/(F$2/1000)","v":1.50943396226415},{"$f":"+G88/(G$2/1000)","v":2.26415094339623},{"$f":"+H88/(H$2/1000)","v":3.0188679245283},{"$f":"+I88/(I$2/1000)","v":0},{"$f":"+J88/(J$2/1000)","v":2.26415094339623},{"$f":"+K88/(K$2/1000)","v":4.52830188679245},{"$f":"+L88/(L$2/1000)","v":0},{"$f":"+M88/(M$2/1000)","v":2.26415094339623},{"$f":"+N88/(N$2/1000)","v":5.28301886792453},{"$f":"+O88/(O$2/1000)","v":0},{"$f":"+P88/(P$2/1000)","v":0}]
[]
["Property crimes per thousand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"      Report consistent with the Michigan Incident Crime Reporting guidelines"]
["Property crimes ",420,425,26,40,18,16,16,14,5,19,13,11,9,4,2,"2010 and 2011 from roger vandermolen via micr"]
["Property crimes per thousand",{"$f":"+B92/(B$2/1000)","v":56},{"$f":"+C92/(C$2/1000)","v":57.4324324324324},{"$f":"+D92/(D$2/1000)","v":19.622641509434},{"$f":"+E92/(E$2/1000)","v":30.188679245283},{"$f":"+F92/(F$2/1000)","v":13.5849056603774},{"$f":"+G92/(G$2/1000)","v":12.0754716981132},{"$f":"+H92/(H$2/1000)","v":12.0754716981132},{"$f":"+I92/(I$2/1000)","v":10.5660377358491},{"$f":"+J92/(J$2/1000)","v":3.77358490566038},{"$f":"+K92/(K$2/1000)","v":14.3396226415094},{"$f":"+L92/(L$2/1000)","v":9.81132075471698},{"$f":"+M92/(M$2/1000)","v":8.30188679245283},{"$f":"+N92/(N$2/1000)","v":6.79245283018868},{"$f":"+O92/(O$2/1000)","v":2.90697674418605},{"$f":"+P92/(P$2/1000)","v":1.45348837209302}]
[]
["Traffic injuries or fatalities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Report from the UD 10.  The information on the UD10 does not distinguish between serious injury and minor injury"]
["Traffic  incidents form the UD - 10",850,875,7,9,8,7,7,7,10,4,6,6,3,9,7,"2009 and 2010 from roger vandermolen"]
[]
["Quality of Life"]
["Miles of sidewalks and non-motorized paths/trails as a factor of total miles of local/major road streets",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Utilize the most recent audited act 51 reports as the source data."]
["Miles of sidewalks and non-motorized paths/trails",7.5,8.5,9,9,9,9,{"$f":"7.8+2.55","v":10.35},{"$f":"7.8+2.55","v":10.35},{"$f":"7.8+2.55","v":10.35},10.35,10.35,10.35,10.35,10.35,10.35]
["Total miles of local/major road streets",35,35,7.43,7.43,7.43,7.43,7.43,7.43,7.43,7.43,7.43,7.43,7.43,7.43,7.43]
[null,{"$f":"+B100/B101","v":0.214285714285714},{"$f":"+C100/C101","v":0.242857142857143},{"$f":"+D100/D101","v":1.21130551816958},{"$f":"+E100/E101","v":1.21130551816958},{"$f":"+F100/F101","v":1.21130551816958},{"$f":"+G100/G101","v":1.21130551816958},{"$f":"+H100/H101","v":1.39300134589502},{"$f":"+I100/I101","v":1.39300134589502},{"$f":"+J100/J101","v":1.39300134589502},{"$f":"+K100/K101","v":1.39300134589502},{"$f":"+L100/L101","v":1.39300134589502},{"$f":"+M100/M101","v":1.39300134589502},{"$f":"+N100/N101","v":1.39300134589502},{"$f":"+O100/O101","v":1.39300134589502},{"$f":"+P100/P101","v":1.39300134589502}]
[]
["Percent of GF Expenditures Committed to Arts, Culture and Recreation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Utilize the most recent audited financial statements as the source data."]
["Arts, recreation & culture expenditures",225000,222000,55429,31420,42713,48424,42565,42930,55349,52928,41263,43503,{"$f":"53309+356217-181500","v":228026},55507,60253]
[null,{"$f":"+B105/B5","v":0.09},{"$f":"+C105/C5","v":0.0853846153846154},{"$f":"+D105/D5","v":0.0711029298578685},{"$f":"+E105/E5","v":0.0284498885365602},{"$f":"+F105/F5","v":0.0567095301830576},{"$f":"+G105/G5","v":0.0589170715207793},{"$f":"+H105/H5","v":0.0570936602684568},{"$f":"+I105/I5","v":0.0552987912325718},{"$f":"+J105/J5","v":0.0713362349511335},{"$f":"+K105/K5","v":0.075007192062797},{"$f":"+L105/L5","v":0.0408666345118694},{"$f":"+M105/M5","v":0.0442372048895519},{"$f":"+N105/N5","v":0.264900400674257},{"$f":"+O105/O5","v":0.0962380021083},{"$f":"+P105/P5","v":0.118708749532084}]
[]
["Acres of park per thousand residents",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Report the number of acres of total parkland, developed and undeveloped, and utilize the most recent census or other recognized population estimate such as Semcog."]
["Acres of parks",18,18,81.5,81.5,81.5,81.5,81.5,81.5,81.5,81.5,81.5,81.5,93.57,93.57,93.57]
[null,{"$f":"+B109/(B$2/1000)","v":2.4},{"$f":"+C109/(C$2/1000)","v":2.43243243243243},{"$f":"+D109/(D$2/1000)","v":61.5094339622642},{"$f":"+E109/(E$2/1000)","v":61.5094339622642},{"$f":"+F109/(F$2/1000)","v":61.5094339622642},{"$f":"+G109/(G$2/1000)","v":61.5094339622642},{"$f":"+H109/(H$2/1000)","v":61.5094339622642},{"$f":"+I109/(I$2/1000)","v":61.5094339622642},{"$f":"+J109/(J$2/1000)","v":61.5094339622642},{"$f":"+K109/(K$2/1000)","v":61.5094339622642},{"$f":"+L109/(L$2/1000)","v":61.5094339622642},{"$f":"+M109/(M$2/1000)","v":61.5094339622642},{"$f":"+N109/(N$2/1000)","v":70.6188679245283},{"$f":"+O109/(O$2/1000)","v":68.0014534883721},{"$f":"+P109/(P$2/1000)","v":68.0014534883721}]
[]
["Percent of community being provided with curbside recycling",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"What percent of a community has access to, not necessarily utilizing, curbside recycling"]
["Population where curbside recycling is offered",7150,7150,1325,1325,1325,1325,1325,1325,1325,1325,1325,1325,1325,{"$f":"+O2","v":1376},{"$f":"+P2","v":1376}]
[null,{"$f":"+B113/B2","v":0.953333333333333},{"$f":"+C113/C2","v":0.966216216216216},{"$f":"+D113/D2","v":1},{"$f":"+E113/E2","v":1},{"$f":"+F113/F2","v":1},{"$f":"+G113/G2","v":1},{"$f":"+H113/H2","v":1},{"$f":"+I113/I2","v":1},{"$f":"+J113/J2","v":1},{"$f":"+K113/K2","v":1},{"$f":"+L113/L2","v":1},{"$f":"+M113/M2","v":1},{"$f":"+N113/N2","v":1},{"$f":"+O113/O2","v":1},{"$f":"+P113/P2","v":1}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Communities may report other measures for each category that are unique or important to their community"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All reported data may be footnoted to explain the reported scores"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data should be updated at least annually, but communities are encouraged to update the dashboards more frequently."]