{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Dashboard","Underlying data","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"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":15,"rows_kept":30,"cut":false,"hidden":false,"merged":[[26,1,26,12],[29,1,29,12]]}
[null,"VILLAGE OF SARANAC - PERFORMANCE DASHBOARD",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"},"2016","2016","2017","Trend","Performance",0.01,"threshhold for Good or Bad change"]
[null,"Fiscal Stability",null,null,null,null,null,null,null,null,null," ",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.33333333333331},{"$f":"+'Underlying data'!C6","v":351.35135135135135},{"$f":"+'Underlying data'!D6","v":588.34716981132078},{"$f":"+'Underlying data'!E6","v":833.50792452830194},{"$f":"+'Underlying data'!F6","v":568.44460377358484},{"$f":"+'Underlying data'!G6","v":620.30264150943401},{"$f":"+'Underlying data'!I6","v":585.90792452830192},{"$f":"+'Underlying data'!J6","v":585.57660377358491},{"$f":"+'Underlying data'!K6","v":532.5577358490566},{"$f":"+K4/J4-1","v":-9.0541301655262529E-2},"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.21153846153846154},{"$f":"+'Underlying data'!D9","v":1.2428126122428036},{"$f":"+'Underlying data'!E9","v":0.51790930443553862},{"$f":"+'Underlying data'!F9","v":0.81988971959365853},{"$f":"+'Underlying data'!G9","v":0.59528215685344099},{"$f":"+'Underlying data'!I9","v":0.51253207407178414},{"$f":"+'Underlying data'!J9","v":0.6449646792260233},{"$f":"+'Underlying data'!K9","v":0.80910635608292625},{"$f":"+K5/J5-1","v":0.25449715642394222},"Positive","Good"]
[null,{"$f":"+'Underlying data'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Underlying data'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Underlying data'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Underlying data'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Underlying data'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Underlying data'!#REF!","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"+I6/H6-1","v":{"$error":"#DIV/0!"}},{"$f":"IF(ABS(F6/E6-1)<$N$2,\"Neutral\",IF(N6=\"Good\",IF(F6>E6,\"Positive\",\"Negative\"),IF(N6=\"Bad\",IF(F6<E6,\"Positive\",\"Negative\"),\"Neutral\")))","v":{"$error":"#REF!"}},"Bad"]
[null,{"$f":"+'Underlying data'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Underlying data'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Underlying data'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Underlying data'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Underlying data'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Underlying data'!#REF!","v":{"$error":"#REF!"}},null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#REF!"},"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"]
[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"]
[null,{"$f":"+'Underlying data'!A10","v":"Percentage of road funding provided by the General Fund"},{"$f":"+'Underlying data'!B19","v":0.18965517241379309},{"$f":"+'Underlying data'!C19","v":0.21258503401360543},{"$f":"+'Underlying data'!D19","v":0.3350368586502932},{"$f":"+'Underlying data'!E19","v":0.38469393504042365},{"$f":"+'Underlying data'!F19","v":0.34562139584961071},{"$f":"+'Underlying data'!G19","v":0.63495608545028648},{"$f":"+'Underlying data'!I19","v":0.23019919523097984},{"$f":"+'Underlying data'!J19","v":5.3584106953877483E-2},{"$f":"+'Underlying data'!K19","v":9.7635554634698113E-2},{"$f":"+K10/J10-1","v":0.82209912948139485},"Negative","Neutral"]
[null,{"$f":"+'Underlying data'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Underlying data'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Underlying data'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Underlying data'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Underlying data'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Underlying data'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Underlying data'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Underlying data'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Underlying data'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+K11/J11-1","v":{"$error":"#REF!"}},{"$error":"#REF!"},"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},0,"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.91935483870967738},{"$f":"+'Underlying data'!C37","v":0.91935483870967738},{"$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":"+K14/J14-1","v":0},{"$f":"IF(ABS(F14/E14-1)<$N$2,\"Neutral\",IF(N14=\"Good\",IF(F14>E14,\"Positive\",\"Negative\"),IF(N14=\"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.72634361233480171},{"$f":"+'Underlying data'!C42","v":0.72634361233480171},{"$f":"+'Underlying data'!D42","v":0.14054726368159204},{"$f":"+'Underlying data'!E42","v":0.14054726368159204},{"$f":"+'Underlying data'!F42","v":0.14054726368159204},{"$f":"+'Underlying data'!G42","v":0.14054726368159204},{"$f":"+'Underlying data'!I42","v":0.14054726368159204},{"$f":"+'Underlying data'!J42","v":0.14054726368159204},{"$f":"+'Underlying data'!K42","v":0.14054726368159204},{"$f":"+K15/J15-1","v":0},{"$f":"IF(ABS(F15/E15-1)<$N$2,\"Neutral\",IF(N15=\"Good\",IF(F15>E15,\"Positive\",\"Negative\"),IF(N15=\"Bad\",IF(F15<E15,\"Positive\",\"Negative\"),\"Neutral\")))","v":"Neutral"},"Good"]
[null,{"$f":"+'Underlying data'!A44","v":"Average age of critical infrastructure (years)"},{"$f":"+'Underlying data'!B84","v":18.857142857142858},{"$f":"+'Underlying data'!C84","v":18.533333333333331},{"$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,{"$error":"#DIV/0!"},{"$f":"IF(ABS(F16/E16-1)<$N$2,\"Neutral\",IF(N16=\"Good\",IF(F16>E16,\"Positive\",\"Negative\"),IF(N16=\"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.891891891891891},{"$f":"+'Underlying data'!D89","v":4.5283018867924527},{"$f":"+'Underlying data'!E89","v":1.5094339622641511},{"$f":"+'Underlying data'!F89","v":1.5094339622641511},{"$f":"+'Underlying data'!G89","v":2.2641509433962264},{"$f":"+'Underlying data'!I89","v":0},{"$f":"+'Underlying data'!J89","v":2.2641509433962264},{"$f":"+'Underlying data'!K89","v":0.75471698113207553},-0.66666666666666663,"Positive","Bad"]
[null,{"$f":"+'Underlying data'!A91","v":"Property crimes per thousand"},{"$f":"+'Underlying data'!B93","v":56},{"$f":"+'Underlying data'!C93","v":57.432432432432428},{"$f":"+'Underlying data'!D93","v":19.622641509433961},{"$f":"+'Underlying data'!E93","v":30.188679245283019},{"$f":"+'Underlying data'!F93","v":13.584905660377359},{"$f":"+'Underlying data'!G93","v":12.075471698113208},{"$f":"+'Underlying data'!I93","v":10.566037735849058},{"$f":"+'Underlying data'!J93","v":3.7735849056603774},{"$f":"+'Underlying data'!K93","v":4.5283018867924527},0.19999999999999996,"Negative","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":3},-0.7,"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.21428571428571427},{"$f":"+'Underlying data'!C102","v":0.24285714285714285},{"$f":"+'Underlying data'!D102","v":1.2113055181695829},{"$f":"+'Underlying data'!E102","v":1.2113055181695829},{"$f":"+'Underlying data'!F102","v":1.2113055181695829},{"$f":"+'Underlying data'!G102","v":1.2113055181695829},{"$f":"+'Underlying data'!I102","v":1.3930013458950201},{"$f":"+'Underlying data'!J102","v":1.3930013458950201},{"$f":"+'Underlying data'!K102","v":1.3930013458950201},{"$f":"+K22/J22-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":8.5384615384615378E-2},{"$f":"+'Underlying data'!D106","v":7.1102929857868535E-2},{"$f":"+'Underlying data'!E106","v":2.8449888536560188E-2},{"$f":"+'Underlying data'!F106","v":5.6709530183057619E-2},{"$f":"+'Underlying data'!G106","v":5.8917071520779268E-2},{"$f":"+'Underlying data'!I106","v":5.5298791232571802E-2},{"$f":"+'Underlying data'!J106","v":7.1336234951133476E-2},{"$f":"+'Underlying data'!K106","v":7.5007192062796976E-2},{"$f":"+K23/J23-1","v":5.1459922354721632E-2},"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.4324324324324325},{"$f":"+'Underlying data'!D110","v":61.509433962264154},{"$f":"+'Underlying data'!E110","v":61.509433962264154},{"$f":"+'Underlying data'!F110","v":61.509433962264154},{"$f":"+'Underlying data'!G110","v":61.509433962264154},{"$f":"+'Underlying data'!I110","v":61.509433962264154},{"$f":"+'Underlying data'!J110","v":61.509433962264154},{"$f":"+'Underlying data'!K110","v":61.509433962264154},0,{"$f":"IF(ABS(F24/E24-1)<$N$2,\"Neutral\",IF(N24=\"Good\",IF(F24>E24,\"Positive\",\"Negative\"),IF(N24=\"Bad\",IF(F24<E24,\"Positive\",\"Negative\"),\"Neutral\")))","v":"Neutral"},"Good"]
[null,{"$f":"+'Underlying data'!A112","v":"Percent of community being provided with curbside recycling"},{"$f":"+'Underlying data'!B114","v":0.95333333333333337},{"$f":"+'Underlying data'!C114","v":0.96621621621621623},{"$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},0,{"$f":"IF(ABS(F25/E25-1)<$N$2,\"Neutral\",IF(N25=\"Good\",IF(F25>E25,\"Positive\",\"Negative\"),IF(N25=\"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 $755,000 at the end of the 2017 FY."]

{"sheet":"Underlying data","index":1,"n_rows":121,"n_cols":12,"rows_kept":121,"cut":false,"hidden":true,"merged":[]}
[null,"2008","2009","2010","2011","2012","2013","2014","2015","2016","2017","Comments"]
["Population",7500,7400,1325,1325,1325,1325,1325,1325,1325,1325,"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,"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}]
["Expenditures per capita",{"$f":"+B5/B2","v":333.33333333333331},351.35135135135135,588.34716981132078,833.50792452830194,568.44460377358484,620.30264150943401,562.66366792452834,585.90792452830192,585.57660377358491,532.5577358490566]
["Fund Balance as % of Annual GF Expenditures",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]
["Fund Balance as % of Annual GF Expenditures",{"$f":"+B8/B5","v":0.2},0.21153846153846154,1.2428126122428036,0.51790930443553862,0.81988971959365853,0.59528215685344099,0.60114198587698819,0.51253207407178414,0.6449646792260233,0.80910635608292625]
["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]
["Local streets fund",260000,264000,92542,77600,130369.67,103990,185752.24,72818.720000000001,61831.28,78027.570000000007]
["Total road expenditures",{"$f":"SUM(B12:B13)","v":580000},588000,217588,567984,238700.5,385066,297145.15999999997,271503.99,186622.5,194601.24]
["Transfers from the General Fund into:"]
["Major streets fund",null,null,30000,189000,0,187000,0,45000,6000,0]
["Local streets fund",110000,125000,42900,29500,82500,57500,140000,17500,4000,19000]
["Total General Fund funding",{"$f":"SUM(B15:B17)","v":110000},125000,72900,218500,82500,244500,140000,62500,10000,19000]
["Ratio of road funding to total GF expenditures",{"$f":"+B18/B14","v":0.18965517241379309},0.21258503401360543,0.3350368586502932,0.38469393504042365,0.34562139584961071,0.63495608545028648,0.47115019473983694,0.23019919523097984,5.3584106953877483E-2,9.7635554634698113E-2]
["Number of services delivered via cooperative venture",null,null,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"]
["Dispatch",null,null,"x","x","x","x","x","x","x","x"]
["Building inspections",null,null,"x","x","x","x","x","x","x","x"]
["Recreation","X"]
["Finance dept. consolidation"]
["Assessing",null,null,"x","x","x","x","x","x","x","x"]
["Fire",null,null,"x","x","x","x","x","x","x","x"]
["Police",null,null,"x","x","x","x","x","x","x","x"]
["Other:"]
[]
["Totals",{"$f":"COUNTA(B21:B31)","v":2},1,6,6,6,6,6,6,6,6]
["Economic Strength"]
["% of community with access to high speed broadband",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]
["Number of homes passed by highspeed internet",2850,2850,511,511,511,511,511,511,511,511]
["% of homes with access to high speed boradband",{"$f":"+B36/B35","v":0.91935483870967738},0.91935483870967738,1,1,1,1,{"$f":"+H36/H35","v":1},1,1,1]
[]
["% of community age 25+ with Bachelor's Degree or higher. ",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,"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]
["% of community age 25+ with bachelor's degree or higher",{"$f":"+B41/B40","v":0.72634361233480171},0.72634361233480171,0.14054726368159204,0.14054726368159204,0.14054726368159204,0.14054726368159204,{"$f":"+H41/H40","v":0.14054726368159204},0.14054726368159204,0.14054726368159204,0.14054726368159204]
[]
["Average age of critical infrastructure (years)",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.1428571428571432},{"$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.833333333333332},{"$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.4285714285714288},{"$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.1428571428571432},{"$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.3333333335}]
["Average depreciable life (in years)",75,{"$f":"+B66","v":75}]
["Average age",{"$f":"IF(B64>0,+B65/(B64/B66),\"\")","v":14.999999999999998},{"$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.1428571428571423},{"$f":"IF(ISNUMBER(C67)=TRUE,C67*C64/C$83,\"\")","v":2.1333333333333333},{"$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.857142857142858},{"$f":"SUMIF($A$44:$A$82,$A$50,C44:C82)","v":18.533333333333331},{"$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,"      Report consistent with the Michigan Incident Crime Reporting guidelines"]
["Violent crimes ",120,125,6,2,2,3,4,0,3,1,"2010 and 2011 from roger vandermolen via micr"]
["Violent crimes per thousand",{"$f":"+B88/(B$2/1000)","v":16},16.891891891891891,4.5283018867924527,1.5094339622641511,1.5094339622641511,2.2641509433962264,3.0188679245283021,0,2.2641509433962264,0.75471698113207553]
[]
["Property crimes per thousand",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,6,"2010 and 2011 from roger vandermolen via micr"]
["Property crimes per thousand",{"$f":"+B92/(B$2/1000)","v":56},57.432432432432428,19.622641509433961,30.188679245283019,13.584905660377359,12.075471698113208,12.075471698113208,10.566037735849058,3.7735849056603774,4.5283018867924527]
[]
["Traffic injuries or fatalities",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,3,"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,"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]
["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]
[null,{"$f":"+B100/B101","v":0.21428571428571427},0.24285714285714285,1.2113055181695829,1.2113055181695829,1.2113055181695829,1.2113055181695829,1.3930013458950201,1.3930013458950201,1.3930013458950201,1.3930013458950201]
[]
["Percent of GF Expenditures Committed to Arts, Culture and Recreation",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]
[null,{"$f":"+B105/B5","v":0.09},8.5384615384615378E-2,7.1102929857868535E-2,2.8449888536560188E-2,5.6709530183057619E-2,5.8917071520779268E-2,5.7093660268456768E-2,5.5298791232571802E-2,7.1336234951133476E-2,7.5007192062796976E-2]
[]
["Acres of park per thousand residents",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]
[null,{"$f":"+B109/(B$2/1000)","v":2.4},2.4324324324324325,61.509433962264154,61.509433962264154,61.509433962264154,61.509433962264154,{"$f":"+H109/(H$2/1000)","v":61.509433962264154},61.509433962264154,61.509433962264154,61.509433962264154]
[]
["Percent of community being provided with curbside recycling",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]
[null,{"$f":"+B113/B2","v":0.95333333333333337},0.96621621621621623,1,1,1,1,1,1,1,1]
[]
[]
[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,"All reported data may be footnoted to explain the reported scores"]
[]
[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."]

{"sheet":"Sheet1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}