{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Instructions","Data Input","F-65 Cross-walk","Rev","Exp","Position","Obligations","Budget Projection","Sheet1","Sheet2"],"not_rendered":{"charts":14,"images":0,"macros":1,"external_links":0,"defined_names":8,"comments":2,"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":"Instructions","index":0,"n_rows":62,"n_cols":1,"rows_kept":62,"cut":false,"hidden":true,"merged":[[61,0,63,0],[3,0,5,0],[54,0,55,0],[40,0,43,0],[45,0,47,0],[49,0,52,0],[12,0,13,0],[15,0,17,0],[21,0,22,0],[24,0,27,0],[31,0,32,0],[57,0,59,0]]}
["INSTRUCTIONS FOR THE CITIZEN'S GUIDE SPREADSHEET"]
[]
[]
["The spreadsheet is organized by tabs.  The first tab to the right of the Instruction tab is titled \"Data Input\" and is the only tab where you should have to enter data or make modifications.  The next four tabs contain the Citizens' Guide organized as follows:"]
[]
[]
[]
["     ●  Revenues"]
["     ●  Expenditures "]
["     ●  Financial Position     "]
["     ●  Other long-term obligations"]
[]
["To enter information in the data input tab, you will need to have copies of your financial statements, trial balances, or F-65 forms.  To use the spreadsheet:"]
[]
[]
["     ●  The model requires 5 years of data, but allows for 10 years (10 years being preferable.)  In order for the graphs to ignore the first five years, we have hidden those columns.  If you want to use more than five years, just \"unhide\" columns C-G and the input areas will be available."]
[]
[]
[]
["     ●  Rows 4 through 29 present the revenues and expenditures from all governmental funds."]
[]
["         »  This should include the General Fund plus all special revenue, debt service, capital project, and permanent funds (if you are using the F-65, this is the sum of columns (a) and (b)."]
[]
[]
["         »  If you have any revenue or expenditure categories that are not being used by your local unit, please \"hide\" those rows on the data input sheet.  This will remove them from the graphs so that the graphical presentation will be easier for the citizen to understand.  This will be very common; for instance, row 27-extraordinary/special items, is quite uncommon to use. "]
[]
[]
[]
[]
["     ●  Rows 31 through 35 present the fund balance as of the balance sheet date;"]
[]
["         » This should include the General Fund plus all special revenue, debt service, capital project, and permanent funds (if you are using the F-65, this is the sum of columns (a) and (b)."]
[]
[]
["         »  If you have any fund balance categories that are not being used by your local unit (i.e., you have no reservations or you have no designation), please \"hide\" those rows on the data input sheet.  This will remove them from the graphs."]
[]
["     ●  Rows 39 through 54 presents the funded status of all \"defined benefit\" employee benefit plans (pension plans, retiree health care, or any other OPEB plans.)"]
[]
["        »  This information should be in the footnote disclosures of your annual financial statements; it is also available in your actuarial valuations."]
[]
["        »  Many local units only have every other year (or every third year) information related to the actuarial accrued liability (AAL) for retiree health care plans.  For those communities, we recommend extrapolating the information between valuations so that a fair picture can still be obtained.  For example:  if the 2007 AAL was $5 million and the 2010 AAL was $8 million, you could extrapolate to $6 million for 2008 and $7 million for 2009. "]
[]
[]
[]
[]
["     ●  Rows 57 through 67 present the debt information from the \"long term debt account group.\"  In other words, this represents all governmental liabilities not already reported in the funds themselves.  This information generally can be found in the footnote disclosures of your financial statements."]
[]
[]
[]
["    ●  Row 69 presents population information.  This is presented so that we can compute measures on a per-capita basis, and will make it easier when you want to do comparisons with other local units in the future.  For 2010, the population count should agree with the U.S. census figures.  For all other years, estimates of population are generally available through your regional council of governments."]
[]
[]
[]
[]
["     ●  Rows 79-83 are grayed out and should be ignored.  This section is necessary in order for the interactive revenue and expenditure charts to operate properly."]
[]
[]
["On the first two tabs of the Citizens' Guide (revenue and expenditures), table number 4 has been built as an interactive chart.  When this is put on your website, the user can choose any revenue (expenditure) from the drop-down list and see the historical trend for that particular revenue (expenditure)."]
[]
[]
[]
["Before publishing the spreadsheet to your website, we highly recommend you \"hide\" the Data Input Tab and the F-65 Crosswalk Tab so that this document will be more user-friendly.  To hide a tab, right click on the tab and select \"Hide\"."]

{"sheet":"Data Input","index":1,"n_rows":88,"n_cols":18,"rows_kept":88,"cut":false,"hidden":true,"merged":[[1,16,1,17]]}
["VILLAGE OF SARANAC"]
["CITIZENS' GUIDE TO LOCAL UNIT FINANCES ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Per capita information"]
["Date Input Page",null,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2013,2014]
[]
[]
["Stmt. Of Rev & Exp - All governmental funds"]
["Revenue"]
[null,"Taxes",null,null,null,null,null,275673,288123,300799,307746,307551,288939,282961,{"$f":"213664.08+4496.04+25601.92+25601.92","v":269363.95999999996},{"$f":"203481.11+4918.83+24391.61+24391.61","v":257183.15999999997},{"$f":"ROUND(O8/$O$74,2)","v":203.29},{"$f":"ROUND(P8/$P$74,2)","v":194.1}]
[null,"Licenses & permits",null,null,null,null,null,780,1080,303,525,340,200,415,575,350,{"$f":"ROUND(O9/$O$74,2)","v":0.43},{"$f":"ROUND(P9/$P$74,2)","v":0.26}]
[null,"from Federal Govt.",null,null,null,null,null,100200,0,0,0,0,207764,27452.89,0,0,0,0]
[null,"from State Govt.",null,null,null,null,null,244246,301793,239599,234712,217236,218467,219870.2,{"$f":"1518.55+124456+4452.54+68889.32+2473.84+21301.15+765","v":223856.4},{"$f":"1533.95+127752+4541.55+74937.97+2471.84+23189.93+764.91","v":235192.15},168.95,177.5]
[null,"Local contributions",null,null,null,null,null,95250,76335,73743,85964,77012,88355,127127.83,98791.52,103057.02,74.56,77.78]
[null,"Charges for services",null,null,null,null,null,38093,40617,41607,46581,44038,44190,47377.63,49299.19,50881.83,37.21,38.4]
[null,"Fines & forfeitures",null,null,null,null,null,1336,1184,1158,2555,2586,2712,2133.9299999999998,{"$f":"782.31+508.83+45","v":1336.1399999999999},{"$f":"201.53+901.26","v":1102.79},1.01,0.83]
[null,"Interest & rent",null,null,null,null,null,39503,66862,96397,{"$f":"77001+765","v":77766},65620,49883,32244.76,{"$f":"35421.96+1982.07","v":37404.03},{"$f":"1998.98+40249.12","v":42248.100000000006},28.23,31.89]
[null,"Other revenue",null,null,null,null,null,232037,56379,164827,113771,82342,233162,141659.49,{"$f":"1075+57.5+1719+1649.26+8505.45+187000+57500","v":257506.21},{"$f":"1150-147.5+1533+314.89+10169.48+140000+1400","v":154419.87},194.34,116.54]
[null,"total revenue",{"$f":"SUM(C8:C16)","v":0},0,0,0,0,1027118,832373,918433,869620,796725,1133672,881242.7300000001,938132.45000000007,844434.91999999993,708.02,637.30999999999995]
["Expenditures"]
[null,"General government",null,null,null,null,null,80475,82766,98097,{"$f":"108678-4728","v":103950},102400,96123,105564,{"$f":"7272.56+35468.42+52140.94+354.7+833.33+320+660","v":97049.95},{"$f":"7965.17+34824.68+50171.57+3822.68+355+660","v":97799.099999999991},73.25,73.81]
[null,"Police & fire",null,null,null,null,null,132788,158376,148209,{"$f":"86150+59828","v":145978},153627,172819,174408.15,{"$f":"63168.11+29469.51+103057.02","v":195694.64},{"$f":"66202.91+30247.24+96022.48","v":192472.63},147.69,145.26]
[null,"Other public safety",null,null,null,null,null,{"$f":"10321-7475","v":2846},{"$f":"9479-5980","v":3499},{"$f":"9309-5980","v":3329},4728,5965,3354,3247.46,{"$f":"2784.44+450+233.5+592.85+1555.76","v":5616.55},{"$f":"4618.94+600+387.96","v":5606.9},4.24,4.2300000000000004]
[null,"Roads ",null,null,null,null,null,465000,179737,301295,254485,217588,186735,168504.43,385065.6,297145.15999999997,290.62,224.26]
[null,"Other public works",null,null,null,null,null,62684,70442,71696,76787,78245,80669,77361.460000000006,{"$f":"25886.33+47701.02","v":73587.350000000006},{"$f":"25039.88+49375.41","v":74415.290000000008},55.54,56.16]
[null,"Health & welfare",null,null,null,null,null,7475,5980,5980,5980,6142,6142,6141.76,6141.76,6100.26,4.6399999999999997,4.5999999999999996]
[null,"Community & economic development",null,null,null,null,null,0,0,0,0,0,null,null,null,null,0,0]
[null,"Recreation & culture",null,null,null,null,null,44923,27356,38435,34075,39548,31420,42712.61,48423.56,{"$f":"37565.02+5000","v":42565.02},36.549999999999997,32.119999999999997]
[null,"Capital outlay",null,null,null,null,null,122303,114213,20338,{"$f":"63055+14394","v":77449},176045,734901,175248.98,{"$f":"13063.69-2741.73","v":10321.960000000001},29425,7.79,22.21]
[null,"Debt service",null,null,null,null,null,0,0,0,0,0,null,null,null,null,0,0]
[null,"Unallocated fringes & insurance",null,null,null,null,null,0,0,0,0,0,null,null,null,null,0,0]
[null,"Net Interfund transfers",null,null,null,null,null,217959,38000,151000,106100,72900,218500,82500,244500,140000,184.53,105.66]
[null,"Extraordinary/ Special items",null,null,null,null,null,0,0,0,0,0,null,null,null,null,0,0]
[null,"total expenditures",{"$f":"SUM(C19:C31)","v":0},0,0,0,0,1136453,680369,838379,809532,852460,1530663,835688.85,1066401.3699999999,885529.3600000001,804.83,668.32]
[null,"Surplus (shortfall)",{"$f":"+C17-C32","v":0},0,0,0,0,-109335,152004,80054,60088,-55735,-396991,{"$f":"+N17-N32","v":45553.880000000121},{"$f":"+O17-O32","v":-128268.91999999981},{"$f":"+P17-P32","v":-41094.440000000177},-96.81,-31.01]
["Financial position - All governmental funds"]
[]
[null,"Undesignated fund balance",null,null,null,null,null,684655,883222,947228,{"$f":"989825+12507","v":1002332},950967,553975,599493,471191,430069,355.62,324.58]
[null,"Designated",null,null,null,null,null,15797,0,16838,17448,17880,18003,18039.349999999999,18072.490000000002,18099.62,13.64,13.66]
[null,"Reserved",null,null,null,null,null,0,0,0,0,0,null,null,null,null,0,0]
[null,"Total fund balance",{"$f":"SUM(C36:C38)","v":0},0,0,0,0,700452,883222,964066,1019780,968847,571978,617532.35,489263.49,448168.62,369.26,338.24]
[]
[null,"Calculated - Unreserved fund balance",{"$f":"SUM(C36:C37)","v":0},0,0,0,0,700452,883222,964066,1019780,968847,571978,617532.35,489263.49,448168.62,369.26,338.24]
[]
["Liabilities not counted on a modified-accrual basis:"]
["Pensions"]
["Date of actuarial valuation:",null,{"$f":"EOMONTH(D45,-12)","v":"2000-12-31"},"2001-12-31","2002-12-31","2003-12-31","2004-12-31","2005-12-31","2006-12-31","2007-12-31","2008-12-31","2009-12-31"]
[null,"Assets",null,null,null,null,null,"Enter","Enter","Enter","Enter","Enter"]
[null,"Actuarial Liability",null,null,null,null,null,"Enter","Enter","Enter","Enter","Enter"]
[null,"Unfunded (Overfunded)",{"$f":"+C47-C46","v":0},0,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,{"$f":"ROUND(K48/$L$74,2)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(L48/$L$74,2)","v":{"$error":"#VALUE!"}}]
[null,"Percent funded",{"$f":"IF(ABS(C47)=0,\"\",+C46/C47)","v":""},{"$f":"IF(ABS(D47)=0,\"\",+D46/D47)","v":""},"","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["OPEB"]
["Date of actuarial valuation:",null,{"$f":"EOMONTH(D51,-12)","v":"2000-12-31"},"2001-12-31","2002-12-31","2003-12-31","2004-12-31","2005-12-31","2006-12-31","2007-12-31","2008-12-31","2009-12-31"]
[null,"Assets",0,{"$f":"C52*1.05","v":0},{"$f":"D52*1.05","v":0},{"$f":"E52*1.05","v":0},{"$f":"F52*1.05","v":0},"Enter","Enter","Enter","Enter","Enter"]
[null,"Actuarial Liability",null,null,null,null,null,"Enter","Enter","Enter","Enter","Enter"]
[null,"Unfunded",null,null,null,null,null,{"$f":"+H53-H52","v":{"$error":"#VALUE!"}},{"$f":"+I53-I52","v":{"$error":"#VALUE!"}},{"$f":"+J53-J52","v":{"$error":"#VALUE!"}},{"$f":"+K53-K52","v":{"$error":"#VALUE!"}},{"$f":"+L53-L52","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"ROUND(K54/$L$74,2)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(L54/$L$74,2)","v":{"$error":"#VALUE!"}}]
[null,"Percent funded",{"$f":"IF(ABS(C53)=0,\"\",+C52/C53)","v":""},{"$f":"IF(ABS(D53)=0,\"\",+D52/D53)","v":""},"","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(ABS(L53)=0,\"\",+L52/L53)","v":{"$error":"#VALUE!"}}]
["Sum of all pension & OPEB plans"]
[null,"Assets",{"$f":"+C46+C52","v":0},0,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Actuarial Liability",{"$f":"+C47+C53","v":0},0,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Unfunded",{"$f":"+C58-C57","v":0},0,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,{"$f":"ROUND(K59/$L$74,2)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(L59/$L$74,2)","v":{"$error":"#VALUE!"}}]
[null,"Percent funded",{"$f":"IF(ABS(C58)=0,\"\",+C57/C58)","v":""},{"$f":"IF(ABS(D58)=0,\"\",+D57/D58)","v":""},"","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(ABS(L58)=0,\"\",+L57/L58)","v":{"$error":"#VALUE!"}}]
[]
[]
["Debt:"]
["Bonds & contracts payable",null,null,null,null,null,null,"Enter","Enter","Enter","Enter","Enter"]
["Capital leases",null,null,null,null,null,null,"Enter","Enter","Enter","Enter","Enter"]
["Other contractual debt",null,null,null,null,null,null,"Enter","Enter","Enter","Enter","Enter"]
["Structured debt",null,{"$f":"SUM(C63:C66)","v":0},0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"ROUND(K67/$L$74,2)","v":0},{"$f":"ROUND(L67/$L$74,2)","v":0}]
["Employee compensated absences",null,null,null,null,null,null,"Enter","Enter","Enter","Enter","Enter",null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Landfill closure & postclosure care",null,null,null,null,null,null,"Enter","Enter","Enter","Enter","Enter",null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Uninsured losses",null,null,null,null,null,null,"Enter","Enter","Enter","Enter","Enter",null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Other claims & contingencies",null,null,null,null,null,null,"Enter","Enter","Enter","Enter","Enter",null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Total long term debt (excl. pension & RHC)",{"$f":"SUM(C67:C71)","v":0},0,0,0,0,0,0,0,0,0,null,null,null,null,0,0]
[]
["Population information",null,null,null,null,null,null,1329,1304,1296,1287,1325,1325,1325,1325,1325]
[]
["Contact information:"]
[]
[]
[]
[]
[]
[]
[]
["Graph data, pulled from above data:"]
["Revenue:",10,{"$f":"+C3","v":2001},2002,2003,2004,2005,2006,2007,2008,2009,2010,{"$f":"+M3","v":2011},{"$f":"+N3","v":2012},{"$f":"+O3","v":2013},{"$f":"+P3","v":2014}]
[null,{"$f":"INDEX(B8:B17,B85)","v":"total revenue"},{"$f":"INDEX(C$8:C$17,$B$85)","v":0},0,0,0,0,1027118,832373,918433,869620,796725,1133672,881242.7300000001,938132.45000000007,844434.91999999993]
["Expendtiures:",1]
[null,{"$f":"INDEX(B$19:B$32,$B$87)","v":"General government"},{"$f":"INDEX(C$19:C$32,$B$87)","v":0},0,0,0,0,80475,82766,98097,103950,102400,96123,105564,97049.95,97799.099999999991]

{"sheet":"F-65 Cross-walk","index":2,"n_rows":135,"n_cols":13,"rows_kept":135,"cut":false,"hidden":true,"merged":[]}
["F-65 line","Description","Aggregation",{"$f":"+'Data Input'!C3","v":2001},{"$f":"+'Data Input'!D3","v":2002},{"$f":"+'Data Input'!E3","v":2003},{"$f":"+'Data Input'!F3","v":2004},{"$f":"+'Data Input'!G3","v":2005},{"$f":"+'Data Input'!H3","v":2006},{"$f":"+'Data Input'!I3","v":2007},{"$f":"+'Data Input'!J3","v":2008},{"$f":"+'Data Input'!K3","v":2009},{"$f":"+'Data Input'!L3","v":2010}]
[null,"All Governmental Funds (col. A & b)"]
[null,"REVENUE"]
[101,"Property taxes","Taxes",null,null,null,null,null,275673,288123,300799,307746,300967]
[102,"Tax reverted property","Taxes",null,null,null,null,null,0,0,0,0,0]
[103,"Commercial facilities tax","Taxes",null,null,null,null,null,0,0,0,0,0]
[104,"Trailer taxes","Taxes",null,null,null,null,null,0,0,0,0,0]
[105,"Hotel/ motel tax","Taxes",null,null,null,null,null,0,0,0,0,0]
[106,"Industrial facilities tax","Taxes",null,null,null,null,null,0,0,0,0,0]
[107,"Income tax","Taxes",null,null,null,null,null,0,0,0,0,0]
[108,"Business licenses & permits","Licenses & permits",null,null,null,null,null,0,0,0,0,0]
[109,"Non-business licenses & permits","Licenses & permits",null,null,null,null,null,780,1080,303,525,340]
[110,"Federal govt. grants - general government","from Federal Govt.",null,null,null,null,null,0,0,0,0,0]
[111,"Federal govt. grants - public safety","from Federal Govt.",null,null,null,null,null,100200,0,0,0,0]
[112,"Federal govt. grants - streets & highways","from Federal Govt.",null,null,null,null,null,0,0,0,0,0]
[113,"Federal govt. grants - sanitation","from Federal Govt.",null,null,null,null,null,0,0,0,0,0]
[114,"Federal govt. grants - health and/or hospitals","from Federal Govt.",null,null,null,null,null,0,0,0,0,0]
[115,"Federal govt. grants - welfare","from Federal Govt.",null,null,null,null,null,0,0,0,0,0]
[116,"Federal govt. grants - culture & recreation","from Federal Govt.",null,null,null,null,null,0,0,0,0,0]
[117,"Federal govt. grants - housing & community development","from Federal Govt.",null,null,null,null,null,0,0,0,0,0]
[118,"Federal govt. grants - water","from Federal Govt.",null,null,null,null,null,0,0,0,0,0]
[119,"Federal govt. grants - electric","from Federal Govt.",null,null,null,null,null,0,0,0,0,0]
[120,"Federal govt. grants - transit","from Federal Govt.",null,null,null,null,null,0,0,0,0,0]
[121,"Federal govt. grants - other","from Federal Govt.",null,null,null,null,null,0,0,0,0,0]
[122,"State revenue sharing","from State Govt.",null,null,null,null,null,148307,147099,144930,144835,129890]
[123,"State aid - general government","from State Govt.",null,null,null,null,null,0,0,0,0,0]
[124,"State payment in lieu of taxes","from State Govt.",null,null,null,null,null,0,0,0,0,0]
[125,"State swamp and land taxes","from State Govt.",null,null,null,null,null,0,0,0,0,0]
[126,"State aid - public safety","from State Govt.",null,null,null,null,null,0,0,0,0,0]
[127,"State pass-thru of act 51(Streets)","from State Govt.",null,null,null,null,null,94497,90704,93249,89877,96074]
[128,"State aid - streets & bridges","from State Govt.",null,null,null,null,null,0,3124,0,0,0]
[129,"State aid - sanitation","from State Govt.",null,null,null,null,null,0,0,0,0,0]
[130,"State aid - health and/or hospitals","from State Govt.",null,null,null,null,null,0,0,0,0,0]
[131,"State aid - welfare","from State Govt.",null,null,null,null,null,0,0,0,0,0]
[132,"State aid - culture & recreation","from State Govt.",null,null,null,null,null,0,0,0,0,0]
[133,"State aid - housing & community development","from State Govt.",null,null,null,null,null,0,0,0,0,0]
[134,"State aid - water","from State Govt.",null,null,null,null,null,0,0,0,0,0]
[135,"State aid - electric","from State Govt.",null,null,null,null,null,0,0,0,0,0]
[136,"State aid - transit","from State Govt.",null,null,null,null,null,0,0,0,0,0]
[137,"State aid - other","from State Govt.",null,null,null,null,null,1442,60866,1420,0,0]
[138,"Local donations - general government","Local contributions",null,null,null,null,null,0,0,0,0,0]
[139,"Local donations - public safety","Local contributions",null,null,null,null,null,95250,76335,73743,0,77012]
[140,"Local donations - streets & highways","Local contributions",null,null,null,null,null,0,0,0,0,0]
[141,"Local donations - sanitation","Local contributions",null,null,null,null,null,0,0,0,0,0]
[142,"Local donations - health and/or hospitals","Local contributions",null,null,null,null,null,0,0,0,0,0]
[143,"Local donations - welfare","Local contributions",null,null,null,null,null,0,0,0,0,0]
[144,"Local donations - culture & recreation","Local contributions",null,null,null,null,null,0,0,0,0,0]
[145,"Local donations - housing & community development","Local contributions",null,null,null,null,null,0,0,0,0,0]
[146,"Local donations - Gas, water, electric ","Local contributions",null,null,null,null,null,0,0,0,0,0]
[147,"Local donations - transit","Local contributions",null,null,null,null,null,0,0,0,0,0]
[148,"Local donations - other","Local contributions",null,null,null,null,null,0,0,0,0,0]
[149,"Court-ordered fees and charges","Fines & forfeitures",null,null,null,null,null,0,0,0,0,0]
[150,"Statutory court fees & charges","Fines & forfeitures",null,null,null,null,null,0,0,0,0,0]
[151,"Clerk's office charges","Charges for services",null,null,null,null,null,0,0,0,0,0]
[152,"Election charges","Charges for services",null,null,null,null,null,0,0,0,0,0]
[153,"Register of Deeds fees","Charges for services",null,null,null,null,null,0,0,0,0,0]
[154,"All other statutory fees","Charges for services",null,null,null,null,null,0,0,0,0,0]
[155,"Fire run charges","Charges for services",null,null,null,null,null,0,0,0,0,0]
[156,"Police fees","Charges for services",null,null,null,null,null,0,0,0,0,0]
[157,"Other charges for services","Charges for services",null,null,null,null,null,38093,40017,41607,46581,44038]
[158,"Parks and recreation fees","Charges for services",null,null,null,null,null,0,600,0,0,0]
[159,"Parking fees","Charges for services",null,null,null,null,null,0,0,0,0,0]
[160,"All other fees","Charges for services",null,null,null,null,null,0,0,0,0,0]
[161,"Fines, penalties & forfeits","Fines & forfeitures",null,null,null,null,null,1336,1184,1158,2555,298]
[162,"Interest & dividends","Interest & rent",null,null,null,null,null,16406,24732,35149,15704,13276]
[163,"Rents & royalties","Interest & rent",null,null,null,null,null,23097,42130,61248,61297,52345]
[164,"Misc. other revenue","Other revenue",null,null,null,null,null,13253,17591,13827,6700,8756]
[165,"Special assessments","Other revenue",null,null,null,null,null,0,0,0,0,0]
[166,"Sale of fixed assets","Other revenue",null,null,null,null,null,0,0,0,0,0]
[167,"Contributions","Other revenue",null,null,null,null,null,0,0,0,0,0]
[168,"Ambulance services","Charges for services",null,null,null,null,null,0,0,0,0,0]
[169,"Other  refunds & rebates","Other revenue",null,null,null,null,null,825,788,0,971,829]
[170,"Debt issuance","Other revenue",null,null,null,null,null,0,0,0,0,0]
[171,"Extraordinary/ Special items","Other revenue",null,null,null,null,null,0,0,0,0,0]
[172,"Interfund transfers In","Other revenue",null,null,null,null,null,217959,38000,151000,106100,72900]
[173,"Total revenue",null,null,null,null,null,null,{"$f":"SUM(I4:I75)","v":1027118},{"$f":"SUM(J4:J75)","v":832373},{"$f":"SUM(K4:K75)","v":918433},{"$f":"SUM(L4:L75)","v":782891},{"$f":"SUM(M4:M75)","v":796725}]
[null,"EXPENDITURES"]
[201,"Legislative","General government",null,null,null,null,null,11048,8429,8440,8279,8238]
[203,"Chief executive","General government",null,null,null,null,null,0,0,0,0,0]
[204,"Treasurer","General government",null,null,null,null,null,0,0,0,0,0]
[205,"Assessing","General government",null,null,null,null,null,0,27441,0,0,0]
[206,"Clerk","General government",null,null,null,null,null,0,0,0,0,0]
[207,"Elections","General government",null,null,null,null,null,28589,750,30240,35202,32569]
[208,"Finance","General government",null,null,null,null,null,957,0,2286,0,1026]
[209,"Building & grounds","General government",null,null,null,null,null,0,0,0,0,0]
[210,"All other gen gov.","General government",null,null,null,null,null,37034,40034,52649,58194,56945]
[202,"Judicial","General government",null,null,null,null,null,2847,6112,4482,7003,3622]
[211,"Police","Police & fire",null,null,null,null,null,47981,55309,55930,58136,60369]
[212,"Fire","Police & fire",null,null,null,null,null,84807,103067,92279,28014,93258]
[213,"Combined public safety","Police & fire",null,null,null,null,null,0,0,0,0,0]
[214,"Dispatch (if separate)","Police & fire",null,null,null,null,null,0,0,0,0,0]
[215,"Jail","Police & fire",null,null,null,null,null,0,0,0,0,0]
[216,"Building regulations","Other public safety",null,null,null,null,null,0,3499,0,0,0]
[217,"Other public safety","Other public safety",null,null,null,null,null,10321,5980,9309,0,5965]
[218,"DPW ","Other public works",null,null,null,null,null,62684,0,71696,76787,78245]
[219,"Roads & bridges","Roads ",null,null,null,null,null,465000,179737,301295,254485,217588]
[220,"Trash disposal & landfilling","Other public works",null,null,null,null,null,0,0,0,0,0]
[221,"Water or sewer","Other public works",null,null,null,null,null,0,0,0,0,0]
[222,"Electricity","Other public works",null,null,null,null,null,0,19774,0,0,0]
[223,"Airports","Other public works",null,null,null,null,null,0,0,0,0,0]
[224,"Public transportation","Other public works",null,null,null,null,null,0,0,0,0,0]
[225,"Water or sewer","Other public works",null,null,null,null,null,0,0,0,0,0]
[226,"Other public works","Other public works",null,null,null,null,null,0,50668,0,0,0]
[227,"Health dept.","Health & welfare",null,null,null,null,null,0,0,0,0,0]
[228,"Alcoholism & substance abuse","Health & welfare",null,null,null,null,null,0,0,0,0,0]
[229,"Hospital","Health & welfare",null,null,null,null,null,0,0,0,0,0]
[230,"Medical examiner","Health & welfare",null,null,null,null,null,0,0,0,0,0]
[231,"Mental health","Health & welfare",null,null,null,null,null,0,0,0,0,0]
[232,"Ambulance","Health & welfare",null,null,null,null,null,0,0,0,5980,6142]
[233,"Child care","Health & welfare",null,null,null,null,null,0,0,0,0,0]
[234,"Human services","Health & welfare",null,null,null,null,null,0,0,0,0,0]
[235,"Area agency on aging","Health & welfare",null,null,null,null,null,0,0,0,0,0]
[236,"Veterans' programs","Health & welfare",null,null,null,null,null,0,0,0,0,0]
[237,"Other health & welfare","Health & welfare",null,null,null,null,null,0,0,0,0,0]
[238,"Public housing","Community & economic development",null,null,null,null,null,0,0,0,0,0]
[239,"Planning & zoning","Community & economic development",null,null,null,null,null,0,0,0,0,0]
[240,"Economic development","Community & economic development",null,null,null,null,null,0,0,0,0,0]
[241,"Oher community development","Community & economic development",null,null,null,null,null,0,0,0,0,0]
[242,"Parks & recreation","Recreation & culture",null,null,null,null,null,44923,27356,38435,34075,39548]
[243,"Library","Recreation & culture",null,null,null,null,null,0,0,0,0,0]
[244,"Other cultural activities","Recreation & culture",null,null,null,null,null,0,0,0,0,0]
[245,"Fringe benefits not directly allocated to departments","Unallocated fringes & insurance",null,null,null,null,null,0,0,0,0,0]
[246,"Capital outlay","Capital outlay",null,null,null,null,null,122303,114213,20338,63055,176045]
[247,"Debt service","Debt service",null,null,null,null,null,0,0,0,0,0]
[248,"Interfund transfers out","Interfund transfers (net)",null,null,null,null,null,217959,38000,151000,106100,72900]
[249,"Extraordinary/ Special items","Extraordinary/ Special items",null,null,null,null,null,0,0,0,0,0]
[250,"Total expenditures",null,null,null,null,null,null,{"$f":"SUM(I78:I126)","v":1136453},{"$f":"SUM(J78:J126)","v":680369},{"$f":"SUM(K78:K126)","v":838379},{"$f":"SUM(L78:L126)","v":735310},{"$f":"SUM(M78:M126)","v":852460}]
[]
[null,"FUND BALANCE"]
[531,"- Reserved/ Restricted","Reserved",null,null,null,null,null,0,0,0,0,0]
[532,"- Designated","Designated",null,null,null,null,null,15797,0,16838,17448,17880]
[533,"- Undesignated/ unreserved/ unrestricted","Undesignated fund balance",null,null,null,null,null,684655,883222,947228,989825,950967]
[534,"Total equity"]
[]
[null,"Population information"]

{"sheet":"Rev","index":3,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["VILLAGE OF SARANAC"]
["CITIZENS' GUIDE TO LOCAL UNIT FINANCES - REVENUES "]
[]
["1. Where our money comes from (all governmental funds)",null,null,null,null,null,"2. Compared to the prior year "]
[null,null,null,null,null,null,null,2013,2014,"% change"]
[null,null,null,null,null,null,"Taxes",{"$f":"+'Data Input'!O8","v":269363.95999999996},{"$f":"+'Data Input'!P8","v":257183.15999999997},{"$f":"IF(H6=0,\"n/a\",(I6-H6)/H6)","v":-4.5220600409943447E-2}]
[null,null,null,null,null,null,"Licenses & permits",{"$f":"+'Data Input'!O9","v":575},{"$f":"+'Data Input'!P9","v":350},{"$f":"IF(H7=0,\"n/a\",(I7-H7)/H7)","v":-0.39130434782608697}]
[null,null,null,null,null,null,"from Federal Govt.",{"$f":"+'Data Input'!O10","v":0},{"$f":"+'Data Input'!P10","v":0},"n/a"]
[null,null,null,null,null,null,"from State Govt.",{"$f":"+'Data Input'!O11","v":223856.4},{"$f":"+'Data Input'!P11","v":235192.15},5.06384896746307E-2]
[null,null,null,null,null,null,"Local contributions",{"$f":"+'Data Input'!O12","v":98791.52},{"$f":"+'Data Input'!P12","v":103057.02},4.3176782784595275E-2]
[null,null,null,null,null,null,"Charges for services",{"$f":"+'Data Input'!O13","v":49299.19},{"$f":"+'Data Input'!P13","v":50881.83},3.2102758686298888E-2]
[null,null,null,null,null,null,"Fines & forfeitures",{"$f":"+'Data Input'!O14","v":1336.1399999999999},{"$f":"+'Data Input'!P14","v":1102.79},-0.1746448725432963]
[null,null,null,null,null,null,"Interest & rent",{"$f":"+'Data Input'!O15","v":37404.03},{"$f":"+'Data Input'!P15","v":42248.100000000006},0.12950663337613641]
[null,null,null,null,null,null,"Other revenue",{"$f":"+'Data Input'!O16","v":257506.21},{"$f":"+'Data Input'!P16","v":154419.87},-0.40032564651547625]
[null,null,null,null,null,null,"Total ",{"$f":"+'Data Input'!O17","v":938132.45000000007},{"$f":"+'Data Input'!P17","v":844434.91999999993},{"$f":"IF(H15=0,\"n/a\",(I15-H15)/H15)","v":-9.9876653877605595E-2}]
[]
[]
[]
[]
["3. Revenue sources per capita - compared to the prior year",null,null,null,null,null,"4. Historical trends of individual sources "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"+'Data Input'!A77","v":0}]

{"sheet":"Exp","index":4,"n_rows":43,"n_cols":10,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["VILLAGE OF SARANAC"]
["CITIZENS' GUIDE TO LOCAL UNIT FINANCES - EXPENDITURES "]
[]
["1. Where we spend our money (all governmental funds)",null,null,null,null,null,"2. Compared to the prior year "]
[null,null,null,null,null,null,null,{"$f":"+'Data Input'!O3","v":2013},{"$f":"+'Data Input'!P3","v":2014},"% change"]
[null,null,null,null,null,null,"General government",{"$f":"+'Data Input'!O19","v":97049.95},{"$f":"+'Data Input'!P19","v":97799.099999999991},{"$f":"IF(H6=0,\"n/a\",(I6-H6)/H6)","v":7.719220875435734E-3}]
[null,null,null,null,null,null,"Police & fire",{"$f":"+'Data Input'!O20","v":195694.64},{"$f":"+'Data Input'!P20","v":192472.63},-1.6464477514560486E-2]
[null,null,null,null,null,null,"Other public safety",{"$f":"+'Data Input'!O21","v":5616.55},{"$f":"+'Data Input'!P21","v":5606.9},-1.7181365785046952E-3]
[null,null,null,null,null,null,"Roads ",{"$f":"+'Data Input'!O22","v":385065.6},{"$f":"+'Data Input'!P22","v":297145.15999999997},-0.22832587486391931]
[null,null,null,null,null,null,"Other public works",{"$f":"+'Data Input'!O23","v":73587.350000000006},{"$f":"+'Data Input'!P23","v":74415.290000000008},1.1251118568612706E-2]
[null,null,null,null,null,null,"Health & welfare",{"$f":"+'Data Input'!O24","v":6141.76},{"$f":"+'Data Input'!P24","v":6100.26},-6.7570207888292605E-3]
[null,null,null,null,null,null,"Community & economic development",{"$f":"+'Data Input'!O25","v":0},{"$f":"+'Data Input'!P25","v":0},"n/a"]
[null,null,null,null,null,null,"Recreation & culture",{"$f":"+'Data Input'!O26","v":48423.56},{"$f":"+'Data Input'!P26","v":42565.02},-0.12098532202093364]
[null,null,null,null,null,null,"Capital outlay",{"$f":"+'Data Input'!O27","v":10321.960000000001},{"$f":"+'Data Input'!P27","v":29425},1.8507182744362505]
[null,null,null,null,null,null,"Debt service",{"$f":"+'Data Input'!O28","v":0},{"$f":"+'Data Input'!P28","v":0},"n/a"]
[null,null,null,null,null,null,"Unallocated fringes & insurance",{"$f":"+'Data Input'!O29","v":0},{"$f":"+'Data Input'!P29","v":0},{"$f":"IF(H16=0,\"n/a\",(I16-H16)/H16)","v":"n/a"}]
[null,null,null,null,null,null,"Net Interfund transfers",{"$f":"+'Data Input'!O30","v":244500},{"$f":"+'Data Input'!P30","v":140000},{"$f":"IF(H17=0,\"n/a\",(I17-H17)/H17)","v":-0.42740286298568508}]
[null,null,null,null,null,null,"Extraordinary/ Special items",{"$f":"+'Data Input'!O31","v":0},{"$f":"+'Data Input'!P31","v":0},{"$f":"IF(H18=0,\"n/a\",(I18-H18)/H18)","v":"n/a"}]
[null,null,null,null,null,null,"total expenditures",{"$f":"+'Data Input'!O32","v":1066401.3699999999},{"$f":"+'Data Input'!P32","v":885529.3600000001},{"$f":"(I19-H19)/H19","v":-0.16960969395603814}]
["3. Spending per capita - compared to the prior year",null,null,null,null,null,"4. Historical trends of individual departments:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"+'Data Input'!A77","v":0}]

{"sheet":"Position","index":5,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["VILLAGE OF SARANAC"]
["CITIZENS' GUIDE TO LOCAL UNIT FINANCES - FINANCIAL POSITION "]
[]
["1. How have we managed our governmental fund resources (fund balance)?",null,null,null,null,null,"2. Compared to the prior year "]
[null,null,null,null,null,null,null,{"$f":"+'Data Input'!O3","v":2013},{"$f":"+'Data Input'!P3","v":2014},"% change"]
[null,null,null,null,null,null,"Revenue",{"$f":"+'Data Input'!O17","v":938132.45000000007},{"$f":"+'Data Input'!P17","v":844434.91999999993},{"$f":"(I6-H6)/H6","v":-9.9876653877605595E-2}]
[null,null,null,null,null,null,"Expenditures",{"$f":"+'Data Input'!O32","v":1066401.3699999999},{"$f":"+'Data Input'!P32","v":885529.3600000001},{"$f":"(I7-H7)/H7","v":-0.16960969395603814}]
[null,null,null,null,null,null,"Surplus (shortfall)",{"$f":"+'Data Input'!O33","v":-128268.91999999981},{"$f":"+'Data Input'!P33","v":-41094.440000000177},{"$f":"(I8-H8)/H8","v":-0.67962278001560905}]
[null,null,null,null,null,null,"Fund balance, by component:"]
[null,null,null,null,null,null,"Reserved",{"$f":"+'Data Input'!K38","v":0},{"$f":"+'Data Input'!L38","v":0},{"$f":"(I10-H10)/H10","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,"Designated",{"$f":"+'Data Input'!O37","v":18072.490000000002},{"$f":"+'Data Input'!P37","v":18099.62},{"$f":"(I11-H11)/H11","v":1.5011766502566817E-3}]
[null,null,null,null,null,null,"Undesignated",{"$f":"+'Data Input'!O36","v":471191},{"$f":"+'Data Input'!P36","v":430069},{"$f":"(I12-H12)/H12","v":-8.7272464881544845E-2}]
[null,null,null,null,null,null,"total fund balance",{"$f":"SUM(H10:H12)","v":489263.49},{"$f":"SUM(I10:I12)","v":448168.62},{"$f":"(I13-H13)/H13","v":-8.3993330464940258E-2}]
[]
[]
[]
[]
[]
[]
["3. Fund balance per capita - compared to the prior year",null,null,null,null,null,"4. Historical trends of individual components "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"+'Data Input'!A77","v":0}]

{"sheet":"Obligations","index":6,"n_rows":38,"n_cols":16,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+'Data Input'!A2","v":"CITIZENS' GUIDE TO LOCAL UNIT FINANCES "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OTHER LONG TERM OBLIGATIONS"]
["1. Pension funding status",null,null,null,null,"2. Retiree Health care funding status",null,null,null,null,"3. Percent funded - compared to the prior year"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["4. Long Term Debt obligations:",null,null,null,null,null,null,null,null,"5. Debt & other long term obligations per capita - compared to the prior year"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"+'Data Input'!A77","v":0}]

{"sheet":"Budget Projection","index":7,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["VILLAGE OF SARANAC"]
["CITIZENS' GUIDE TO LOCAL UNIT FINANCES - BUDGET PROJECTION"]
[]
[null,null,"FYE 2015","FYE 2016"]
[null,null,"Current FY","Subsequent FY"]
["Revenues"]
[null,"Taxes",{"$f":"203000+4500+24000+24000","v":255500},255000,null,0]
[null,"Licenses & permits",250,250]
[null,"from Federal Govt.",0,0]
[null,"from State Govt.",{"$f":"1500+127000+4500+68500+21250","v":222750},223000]
[null,"Local contributions",119000,123000]
[null,"Charges for services",50750,51000]
[null,"Fines & forfeitures",500,500]
[null,"Interest & rent",{"$f":"750+1000+1750+40000","v":43500},44000]
[null,"Other revenue",{"$f":"500+8000+118000+50500","v":177000},{"$f":"8000+500+79250","v":87750}]
[null,"total revenue",{"$f":"SUM(C7:C15)","v":869250},{"$f":"SUM(D7:D15)","v":784500}]
["Expenditures"]
[null,"General government",{"$f":"10500+500+38700+72000-13000+5000+867+500+500+1000","v":116567},119000]
[null,"Police & fire",{"$f":"69000+30000+119000","v":218000},{"$f":"70000+123000+32000","v":225000}]
[null,"Other public safety",{"$f":"1500+500+4800+750","v":7550},7500]
[null,"Roads ",{"$f":"210500+95750","v":306250},217000]
[null,"Other public works",{"$f":"50000+27000","v":77000},{"$f":"51000+28000","v":79000}]
[null,"Health & welfare",6045,6500]
[null,"Recreation & culture",{"$f":"84500-37200","v":47300},49000]
[null,"Capital outlay",{"$f":"13000+37200","v":50200},0]
["  ","Net Interfund transfers",168500,79250]
[null,"total expenditures",{"$f":"SUM(C18:C26)","v":997412},{"$f":"SUM(D18:D26)","v":782250}]
[null,"Surplus (shortfall)",{"$f":"+C16-C27","v":-128162},{"$f":"+D16-D27","v":2250}]
["Financial position - General Fund"]
[null,"Beginning fund balance",448169,{"$f":"+C31","v":320007}]
[null,"Ending fund balance",{"$f":"C28+C30","v":320007},{"$f":"D28+D30","v":322257}]
[]
[]
["Budget Assumptions:"]
[null,"FYE 2016 Budget Projection was created with the assumption that  "]
[null,"Revenues and Expenditures (other than \"Capital Outlay\") shall remain"]
[null,"fairly equal to those of FYE 2015.  The lack of \"Capital Outlay\", directly"]
[null,"impacts the \"Other Revenue\" and \"Net Interfund Transfers\"."]

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

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