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

{"sheet":"1. Projection Worksheet","index":0,"n_rows":49,"n_cols":17,"rows_kept":49,"cut":false,"hidden":false,"merged":[[5,1,5,4],[5,5,5,7],[7,4,9,4],[23,5,23,6],[23,8,23,9],[3,5,3,7],[3,8,3,9],[4,8,4,9],[28,2,28,4],[10,4,11,4],[14,2,15,2],[14,4,17,4],[19,4,21,4],[24,5,24,6],[24,8,24,9],[25,2,25,4],[26,2,26,4],[27,2,27,4],[41,3,42,3],[29,2,29,4],[30,2,30,4],[31,2,31,4],[32,2,32,4],[33,2,33,4],[34,2,34,4]]}
[]
[{"$f":"MID(C3,3,2)","v":"04"},"Name:","Village of Coxsackie",null,null,null,"Fiscal Year End:","2018-05-31"]
[null,"MuniCode:","190420801180",null,null,null,"Year Last Filed:",2017]
[null,"County:","Greene",null,null,null,null,null,"Enter data here and scroll down to see the projected fiscal stress scores.  "]
["No",null,null,null,null,null,null,null,"Projection"]
[null,"Fiscal Stress Financial Indicator Data Inputs",null,null,null,"Data",null,null,"Current Fiscal Year","Next Fiscal Year"]
[null,"Financial Indicators","Components","Account Code(s)","Fund(s)",{"$f":"H3-2","v":2015},{"$f":"H3-1","v":2016},{"$f":"H3","v":2017},{"$f":"H3+1","v":2018},{"$f":"H3+2","v":2019}]
["Yes",1,"Assigned Unappropriated and Unassigned Fund Balance","915 & 917","General Fund",34744,15409,746354]
[null,2,"Total Fund Balance",8029,null,810676,949694,911069]
[null,"1, 2","Gross Expenditures \n(includes transfers out)",null,null,1518247,1567435,1794129]
[null,"3, 5","Gross Expenditures \n(includes transfers out)",null,"Combined Funds",3257081,3381108,3752673]
[null,3,"Gross Revenues \n(includes transfers in)",null,null,3384086,3718980,4697891]
[null,6,"Total Revenues \n(does not include transfers in)",null,"General Fund",1674084,1706453,1752422]
[null,"8, 9","Total Revenues \n(does not include transfers in)",null,"All Funds Except Capital Projects Fund",3605470,3945474,4922406]
[null,4,"Cash and Investments","200-223, 450 & 451","Combined Funds",195775,640821,1387237]
[null,5,null,"200, 201, 450 & 451",null,195425,640471,1386887]
[null,4,"Current Liabilities","600-626, 631-637, 639-668",null,54114,278560,209811]
[null,4,"Taxes Receivable","280, 290 & 295",null,0,0,0]
[null,"6, 7","Short-Term Cash-Flow Debt","Revenue Anticipation Notes, Tax Anticipation Notes, Budget Notes, and Defiency Notes Only","All  Funds",0,150000,0]
[null,8,"Personal Service and Employee Benefits ","Expenditure Object Codes:\n     .1 (Personal Services) and \n     .8 (Employee Benefits)","All Funds Except Capital Projects Fund",1376004,1491657,1485560]
[null,9,"Debt Service","Expenditure Object Codes:\n     .6 (Debt Principal) and \n     .7 (Debt Interest)",null,602669,595809,672408]
[null,9,"Proceeds from Current Refunding Bonds Proceeds",5792,null,0,0,0,null,null,null,null,"IF((I17-I18)=0,0,IF(AND((I17-I18)<=0,I15>=0),0,ROUND(I15/(I17-I18),4)))"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ROUND(IF(I15=0,0,IF(AND(I15<=0, I13 >= 0),0,I13/I15)),4)"]
[null,null,null,null,null,"Public Scores",null,"Public Scores","Projected Scores",null,null,null,"IF(AND(J13=\"\", J15=\"\"), \"\",IF(J15 = 0,0,IF(AND(J15 <=0, J13 >=0),0,IF(O24<=50%,10,IF(O24<=75%,6.67,IF(O24<=100%,3.33,0))))))"]
[null,null,null,null,null,"Pre System Enhancements",null,"Post System Enhancements","(Based on Data Elements Above)"]
[null,"Financial Indicators","Fiscal Stress Financial Indicators",null,null,{"$f":"F7","v":2015},{"$f":"G7","v":2016},{"$f":"H7","v":2017},{"$f":"I7","v":2018},{"$f":"J7","v":2019},null,{"$f":"M26-1","v":2015},{"$f":"N26-1","v":2016},{"$f":"H7","v":2017},{"$f":"\"Projected \" & N26 +1","v":"Projected 2018"},{"$f":"\"Projected \" & N26 +2","v":"Projected 2019"}]
[null,1,"Assigned and Unassigned Fund Balance as a Percentage (%) of Gross Expenditures",null,null,25,6.25,0,{"$f":"IFERROR(IF(I8/I10<=0,25,IF((I8/I10)<=3.33%,18.75,IF((I8/I10)<=6.67%,12.5,IF((I8/I10)<=10%,6.25,0)))), \"\")","v":""},{"$f":"IFERROR(IF(J8/J10<=0,25,IF((J8/J10)<=3.33%,18.75,IF((J8/J10)<=6.67%,12.5,IF((J8/J10)<=10%,6.25,0)))), \"\")","v":""},null,{"$f":"ROUND(F8/F10,4)","v":2.29E-2},{"$f":"ROUND(G8/G10,4)","v":9.7999999999999997E-3},{"$f":"ROUND(H8/H10,4)","v":0.41599999999999998},{"$f":"ROUND(I8/I10,4)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(J8/J10,4)","v":{"$error":"#DIV/0!"}},"Assigned Unassigned FB / Gross Exp (General Fund)"]
[null,2,"Total Fund Balance as a Percentage (%) of Gross Expenditures",null,null,6.25,6.25,0,{"$f":"IFERROR(IF(I9/I10 <= 0, 25,IF((I9/I10)<=10%,18.75,IF((I9/I10)<=15%,12.5,IF((I9/I10)<=20%,6.25,0)))), \"\")","v":""},{"$f":"IFERROR(IF(J9/J10 <= 0, 25,IF((J9/J10)<=10%,18.75,IF((J9/J10)<=15%,12.5,IF((J9/J10)<=20%,6.25,0)))), \"\")","v":""},null,{"$f":"ROUND(F9/F10,4)","v":0.53400000000000003},{"$f":"ROUND(G9/G10,4)","v":0.60589999999999999},{"$f":"ROUND(H9/H10,4)","v":0.50780000000000003},{"$f":"ROUND(I9/I10,4)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(J9/J10,4)","v":{"$error":"#DIV/0!"}},"Total FB / Gross Exp (General Fund)"]
[null,3,"Operating Deficits",null,null,6.67,3.33,0,{"$f":"IFERROR(ROUND((IF(O29<0,1,0) + IF(N29 < 0,1,0) + IF(M29 < 0,1,0)) * 3.333,2), \"\")","v":""},{"$f":"IFERROR(ROUND((IF(P29<0,1,0) + IF(O29 < 0,1,0) + IF(N29 < 0,1,0)) * 3.333,2), \"\")","v":""},null,{"$f":"ROUND((F12-F11)/F11,4)","v":3.9E-2},{"$f":"ROUND((G12-G11)/G11,4)","v":9.9900000000000003E-2},{"$f":"ROUND((H12-H11)/H11,4)","v":0.25190000000000001},{"$f":"ROUND((I12-I11)/I11,4)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND((J12-J11)/J11,4)","v":{"$error":"#DIV/0!"}},"Deficit / Gross Expenditures (Combined Fund)"]
[null,4,"Cash Ratio - Cash and Investments as a Percentage (%) of Current Liabilities",null,null,0,0,0,{"$f":"IF(AND(I15=\"\", I17=\"\", I18=\"\"), \"\", IF((I17-I18) = 0,0,IF(AND((I17-I18) <=0, I15 >=0),0,IF(O30<=50%,10,IF(O30<=75%,6.67,IF(O30<=100%,3.33,0))))))","v":""},{"$f":"IF(AND(J15=\"\", J17=\"\", J18=\"\"), \"\", IF((J17-J18) = 0,0,IF(AND((J17-J18) <=0, J15 >=0),0,IF(P30<=50%,10,IF(P30<=75%,6.67,IF(P30<=100%,3.33,0))))))","v":""},{"$f":"IF($A$2<=\"02\", 0.5,0.3333)","v":0.33329999999999999},{"$f":"IF((F17-F18)=0,0,IF(AND((F17-F18)<=0,F15>=0),0,ROUND(F15/(F17-F18),4)))","v":3.6177999999999999},{"$f":"IF((G17-G18)=0,0,IF(AND((G17-G18)<=0,G15>=0),0,ROUND(G15/(G17-G18),4)))","v":2.3005},{"$f":"IF((H17-H18)=0,0,IF(AND((H17-H18)<=0,H15>=0),0,ROUND(H15/(H17-H18),4)))","v":6.6117999999999997},{"$f":"IF((I17-I18)=0,0,IF(AND((I17-I18)<=0,I15>=0),0,ROUND(I15/(I17-I18),4)))","v":0},{"$f":"IF((J17-J18)=0,0,IF(AND((J17-J18)<=0,J15>=0),0,ROUND(J15/(J17-J18),4)))","v":0},"Cash Investment / Current Liability"]
[null,5,"Cash as a Percentage (%) of Monthly Gross Expenditures",null,null,3.33,0,0,{"$f":"IFERROR(IF((I16/(I11/12))<=$K$30,10,IF((I16/(I11/12))<=$K$31,6.67,IF((I16/(I11/12))<=$K$32,3.33,0))), \"\")","v":""},{"$f":"IFERROR(IF((J16/(J11/12))<=$K$30,10,IF((J16/(J11/12))<=$K$31,6.67,IF((J16/(J11/12))<=$K$32,3.33,0))), \"\")","v":""},{"$f":"IF($A$2<=\"02\", 1,0.6667)","v":0.66669999999999996},{"$f":"ROUND((F16/(F11/12)),4)","v":0.72},{"$f":"ROUND((G16/(G11/12)),4)","v":2.2730999999999999},{"$f":"ROUND((H16/(H11/12)),4)","v":4.4348999999999998},{"$f":"ROUND((I16/(I11/12)),4)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND((J16/(J11/12)),4)","v":{"$error":"#DIV/0!"}},"Cash / Avg Monthly Exp"]
[null,6,"Short-Term Cash-Flow Debt Issuance as a Percentage (%) of Total Revenues ",null,null,0,3.33,0,{"$f":"IF(I19=\"\", \"\",IF(O32>0.15,5,IF(O32>0.05,3.33,IF(O32>0,1.67,0))))","v":""},{"$f":"IF(J19=\"\", \"\",IF(P32>0.15,5,IF(P32>0.05,3.33,IF(P32>0,1.67,0))))","v":""},{"$f":"IF($A$2<=\"02\", 1.5,1)","v":1},{"$f":"IF(ISERROR(F19/F13),0,ROUND(F19/F13,4))","v":0},{"$f":"IF(ISERROR(G19/G13),0,ROUND(G19/G13,4))","v":8.7900000000000006E-2},{"$f":"IF(ISERROR(H19/H13),0,ROUND(H19/H13,4))","v":0},{"$f":"IF(ISERROR(I19/I13),0,ROUND(I19/I13,4))","v":0},{"$f":"IF(ISERROR(J19/J13),0,ROUND(J19/J13,4))","v":0},"Debt / Total Revenues"]
[null,7,"Short-Term Cash-Flow Debt Issuance Trend",null,null,0,1.67,0,{"$f":"IF(I19=\"\", \"\",IF(I19>0, IF(H19>0, IF(G19>0,5,3.33),1.67),0))","v":""},{"$f":"IF(J19=\"\", \"\", IF(J19>0, IF(I19>0, IF(H19>0,5,3.33),1.67),0))","v":""}]
[null,8,"Personal Service and Employee Benefits  as a Percentage (%) of Total Revenues (3 year avg)",null,null,0,0,0,{"$f":"IFERROR(IF(O34>=75%,5,IF(O34>=70%,3.33,IF(O34>=65%,1.67,0))), \"\")","v":""},{"$f":"IFERROR(IF(P34>=75%,5,IF(P34>=70%,3.33,IF(P34>=65%,1.67,0))), \"\")","v":""},null,null,null,{"$f":"ROUND(AVERAGE(ROUND(H20/H14,4), ROUND(G20/G14,4),ROUND(F20/F14,4)),4)","v":0.3538},{"$f":"ROUND(AVERAGE(ROUND(I20/I14,4), ROUND(H20/H14,4),ROUND(G20/G14,4)),4)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE(ROUND(J20/J14,4), ROUND(I20/I14,4),ROUND(H20/H14,4)),4)","v":{"$error":"#DIV/0!"}},"Pers Svc & Benefits / Net Revenues (3 year average)"]
[null,9,"Debt Service as a Percentage (%) of Total Revenues (3 year avg)",null,null,3.33,3.33,3.33,{"$f":"IFERROR(IF(O35>=20%,5,IF(O35>=15%,3.33,IF(O35>=10%,1.67,0))), \"\")","v":""},{"$f":"IFERROR(IF(P35>=20%,5,IF(P35>=15%,3.33,IF(P35>=10%,1.67,0))), \"\")","v":""},null,null,null,{"$f":"ROUND(AVERAGE(ROUND((H21-H22)/H14,4), ROUND((G21-G22)/G14,4),ROUND((F21-F22)/F14,4)),4)","v":0.15160000000000001},{"$f":"ROUND(AVERAGE(ROUND((I21-I22)/I14,4), ROUND((H21-H22)/H14,4),ROUND((G21-G22)/G14,4)),4)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE(ROUND((J21-J22)/J14,4), ROUND((I21-I22)/I14,4),ROUND((H21-H22)/H14,4)),4)","v":{"$error":"#DIV/0!"}},"Debt Svc / Net Rev (3 year average)"]
[]
[null,null,null,null,"Total Points*",44.6,24.2,3.3,{"$f":"ROUND(SUM(I27:I35),1)","v":0},{"$f":"ROUND(SUM(J27:J35),1)","v":0}]
[null,null,null,null,"Score Classification","No Designation","No Designation","No Designation",{"$f":"IF(I37>=65,\"Significant Fiscal Stress\",IF(I37>=55,\"Moderate Fiscal Stress\",IF(I37>=45,\"Susceptible Fiscal Stress\",\"No Designation\")))","v":"No Designation"},{"$f":"IF(J37>=65,\"Significant Fiscal Stress\",IF(J37>=55,\"Moderate Fiscal Stress\",IF(J37>=45,\"Susceptible Fiscal Stress\",\"No Designation\")))","v":"No Designation"}]
[]
[null,null,null,null,null,null,null,null,null,"Point Range "]
[null,null,"General Fund","Combined Funds","Revenue and Expenditure Definitions",null,null,null,"Classification","(Out of 100 total pts)"]
[null,"Villages","A","A, FX, G, ES, EW","Gross Revenues = Revenues and Other Sources",null,null,null,"Significant","65 - 100"]
[null,null,null,null,"Total Revenues = Revenues",null,null,null,"Moderate","55 - 64.9"]
[null,null,null,null,"Gross Expenditures = Expenditures and Other Uses",null,null,null,"Susceptible","45 - 54.9"]
[null,null,null,null,null,null,null,null,"No Designation","  0 - 44.9"]
[]
[null,"*Indicator points are rounded to two decimal places.  Total points are rounded to one decimal place."]
[]
[null,"Data as of 2/28/2018"]

{"sheet":"2. Graphs","index":1,"n_rows":138,"n_cols":17,"rows_kept":138,"cut":false,"hidden":false,"merged":[[112,1,114,12],[115,1,116,12],[118,1,118,2]]}
[]
[null,{"$f":" '1. Projection Worksheet'!C2 & \": Projected data for \"  & C9 & \" and \" & C9 + 1 & \" are based on Projection Worksheet \"","v":"Village of Coxsackie: Projected data for 2018 and 2019 are based on Projection Worksheet "}]
[null,"Indicator 1 ",null,null,null,null,null,"Indicator 2"]
[]
[null,null,"Year","Amt",null,null,null,null,"Year"]
[null,null,{"$f":"C7-1","v":2015},{"$f":"'1. Projection Worksheet'!L27","v":2.29E-2},null,null,null,null,{"$f":"I7-1","v":2015},{"$f":"'1. Projection Worksheet'!L28","v":0.53400000000000003}]
[null,null,{"$f":"C8-1","v":2016},{"$f":"'1. Projection Worksheet'!M27","v":9.7999999999999997E-3},null,null,null,null,{"$f":"I8-1","v":2016},{"$f":"'1. Projection Worksheet'!M28","v":0.60589999999999999}]
[null,null,{"$f":"'1. Projection Worksheet'!H7","v":2017},{"$f":"'1. Projection Worksheet'!N27","v":0.41599999999999998},null,null,null,null,{"$f":"C8","v":2017},{"$f":"'1. Projection Worksheet'!N28","v":0.50780000000000003}]
[null,null,{"$f":"C8+1","v":2018},{"$f":"'1. Projection Worksheet'!O27","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"I8+1","v":2018},{"$f":"'1. Projection Worksheet'!O28","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"C9+1","v":2019},{"$f":"'1. Projection Worksheet'!P27","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"I9+1","v":2019},{"$f":"'1. Projection Worksheet'!P28","v":{"$error":"#DIV/0!"}}]
[null,null,"pts","Left",null,null,null,null,"pts","Left"]
[null,null,"a",-0.10000000149011612,null,null,null,null,"a",0]
[null,null,"b",3.3300000000000003E-2,null,null,null,null,"b",0.1,null,null,null,null,null,null,"`"]
[null,null,"c",3.3300000000000003E-2,null,null,null,null,"c",0.05]
[null,null,"c",3.3300000000000003E-2,null,null,null,null,"c",0.05]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Indicator 3"]
[]
[null,null,null,null,null,"ind 3"]
[null,null,null,null,null,"Year"]
[null,null,null,null,null,{"$f":"F31-1","v":2015},{"$f":"'1. Projection Worksheet'!L29","v":3.9E-2}]
[null,null,null,null,null,{"$f":"F32-1","v":2016},{"$f":"'1. Projection Worksheet'!M29","v":9.9900000000000003E-2}]
[null,null,null,null,null,{"$f":"I8","v":2017},{"$f":"'1. Projection Worksheet'!N29","v":0.25190000000000001}]
[null,null,null,null,null,{"$f":"F32+1","v":2018},{"$f":"'1. Projection Worksheet'!O29","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,{"$f":"F33+1","v":2019},{"$f":"'1. Projection Worksheet'!P29","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Indicator 4",null,null,null,null,null,"Indicator 5"]
[]
[null,null,"Year",null,null,null,null,null,"ind 5"]
[null,null,{"$f":"C53-1","v":2015},{"$f":"'1. Projection Worksheet'!L30","v":3.6177999999999999},null,null,null,null,"Year"]
[null,null,{"$f":"C54-1","v":2016},{"$f":"'1. Projection Worksheet'!M30","v":2.3005},null,null,null,null,{"$f":"I54-1","v":2015},{"$f":"'1. Projection Worksheet'!L31","v":0.72}]
[null,null,{"$f":"C8","v":2017},{"$f":"'1. Projection Worksheet'!N30","v":6.6117999999999997},null,null,null,null,{"$f":"I55-1","v":2016},{"$f":"'1. Projection Worksheet'!M31","v":2.2730999999999999}]
[null,null,{"$f":"C54+1","v":2018},{"$f":"'1. Projection Worksheet'!O30","v":0},null,null,null,null,{"$f":"C8","v":2017},{"$f":"'1. Projection Worksheet'!N31","v":4.4348999999999998}]
[null,null,{"$f":"C55+1","v":2019},{"$f":"'1. Projection Worksheet'!P30","v":0},null,null,null,null,{"$f":"I55+1","v":2018},{"$f":"'1. Projection Worksheet'!O31","v":{"$error":"#DIV/0!"}}]
[null,null,"pts","Left",null,null,null,null,{"$f":"I56+1","v":2019},{"$f":"'1. Projection Worksheet'!P31","v":{"$error":"#DIV/0!"}}]
[null,null,null,0,null,null,null,null,"pts","Left"]
[null,null,"3 points",0.5,null,null,null,null,"a",0]
[null,null,"2 points",0.25,null,null,null,null,"b",{"$f":"'1. Projection Worksheet'!$K$30","v":0.33329999999999999}]
[null,null,"1 point",0.25,null,null,null,null,"c",{"$f":"'1. Projection Worksheet'!$K$30","v":0.33329999999999999}]
[null,null,null,null,null,null,null,null,"d",{"$f":"'1. Projection Worksheet'!$K$30","v":0.33329999999999999}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Indicator 6/7"]
[]
[null,null,null,null,null,"ind 6"]
[null,null,null,null,null,"Year"]
[null,null,null,null,null,{"$f":"F76-1","v":2015},{"$f":"'1. Projection Worksheet'!L32","v":0}]
[null,null,null,null,null,{"$f":"F77-1","v":2016},{"$f":"'1. Projection Worksheet'!M32","v":8.7900000000000006E-2}]
[null,null,null,null,null,{"$f":"I8","v":2017},{"$f":"'1. Projection Worksheet'!N32","v":0}]
[null,null,null,null,null,{"$f":"F77+1","v":2018},{"$f":"'1. Projection Worksheet'!O32","v":0}]
[null,null,null,null,null,{"$f":"F78+1","v":2019},{"$f":"'1. Projection Worksheet'!P32","v":0}]
[null,null,null,null,null,"pts","Left"]
[null,null,null,null,null,"a",0.05]
[null,null,null,null,null,"b",0.1]
[null,null,null,null,null,"c",1]
[null,null,null,null,null,"d",0,null,0.25]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Indicator 8 ",null,null,null,null,null,"Indicator 9 "]
[null,null,"ind 8"]
[null,null,"Yr",null,null,null,null,null,"ind 9"]
[null,null,{"$f":"C98-1","v":2015},{"$f":"'1. Projection Worksheet'!L$34","v":0},null,null,null,null,"Yr"]
[null,null,{"$f":"C99-1","v":2016},{"$f":"'1. Projection Worksheet'!M$34","v":0},null,null,null,null,{"$f":"I99-1","v":2015},{"$f":"'1. Projection Worksheet'!L$35","v":0}]
[null,null,{"$f":"C8","v":2017},{"$f":"'1. Projection Worksheet'!N$34","v":0.3538},null,null,null,null,{"$f":"I100-1","v":2016},{"$f":"'1. Projection Worksheet'!M$35","v":0}]
[null,null,{"$f":"C99+1","v":2018},{"$f":"'1. Projection Worksheet'!O$34","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"C8","v":2017},{"$f":"'1. Projection Worksheet'!N$35","v":0.15160000000000001}]
[null,null,{"$f":"C100+1","v":2019},{"$f":"'1. Projection Worksheet'!P$34","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"I100+1","v":2018},{"$f":"'1. Projection Worksheet'!O$35","v":{"$error":"#DIV/0!"}}]
[null,null,"pts","Left",null,null,null,null,{"$f":"I101+1","v":2019},{"$f":"'1. Projection Worksheet'!P$35","v":{"$error":"#DIV/0!"}}]
[null,null,"a",0.65,null,null,null,null,null,"Left"]
[null,null,"b",0.05,null,null,null,null,null,0.1]
[null,null,"c",0.05,null,null,null,null,null,0.05]
[null,null,null,0.80000001192092896,null,null,null,null,null,0.05]
[null,null,null,null,null,null,null,null,null,0.3]
[]
[]
[]
[]
[]
[null,"These graphs are provided for informational purposes. Calculations are based on the financial information provided by the municipality.  The last two data points of each graph are based on projection numbers entered by the user.  OSC takes no responsibility for the accuracy of the projection or the submitted financial information."]
[]
[]
[]
[]
[]
[null,"Data as of 2/28/2018"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]

{"sheet":"3. Comparison","index":2,"n_rows":122,"n_cols":16,"rows_kept":122,"cut":false,"hidden":false,"merged":[[121,1,121,2],[27,10,28,13],[30,10,30,11],[31,10,31,11],[114,1,117,12],[119,1,120,12]]}
[{"$f":"'1. Projection Worksheet'!C3","v":"190420801180"},null,null,18]
[null,{"$f":"'1. Projection Worksheet'!C2","v":"Village of Coxsackie"}]
[null,"Indicator 1",null,null,null,null,null,null,"Indicator 2"]
[null,null,"Indicator 1",null,null,null,null,null,null,"ind 2"]
[null,null,"pts","Left",null,null,null,null,null,"Indicator 2"]
[null,null,"25 points",-0.05,null,null,null,null,null,"25 points",-5.000000074505806E-2]
[null,null,"18.75 points",3.3300000000000003E-2,null,null,null,null,null,"18.75 points",0.1]
[null,null,"12.5 points",3.3300000000000003E-2,null,null,null,null,null,"12.5 points",0.05]
[null,null,"6.25 point",3.3300000000000003E-2,null,null,null,null,null,"6.25 points",0.05,null,null,null,null,"Reported in"]
[null,null,"name","amt",null,null,null,null,null,"name","amt",null,null,null,null,{"$f":"\"for \" & '1. Projection Worksheet'!$H$3","v":"for 2017"}]
[null,null,{"$f":"'1. Projection Worksheet'!C2","v":"Village of Coxsackie"},{"$f":"'1. Projection Worksheet'!N27","v":0.41599999999999998},null,null,null,null,null,{"$f":"C11","v":"Village of Coxsackie"},{"$f":"'1. Projection Worksheet'!N28","v":0.50780000000000003},null,null,null,{"$f":"J12","v":"All Villages"}]
[null,null,"All Villages",0.43499733059548229,null,null,null,null,null,{"$f":"C12","v":"All Villages"},0.66761971252566676,null,null,null,{"$f":"J13","v":"Capital District Villages"}]
[null,null,"Capital District Villages",0.35375263157894732,null,null,null,null,null,{"$f":"C13","v":"Capital District Villages"},0.65135789473684225,null,null,null,{"$f":"J14","v":"Medium Upstate Villages"}]
[null,null,"Medium Upstate Villages",0.36725074626865684,null,null,null,null,null,{"$f":"C14","v":"Medium Upstate Villages"},0.68077985074626823]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"`"]
[null,null,null,"Indicator 3"]
[]
[]
[null,null,null,null,null,null,null,"ind 3","Indicator 3"]
[]
[null,null,null,null,null,null,null,"name","amount",null,"Peer Group Used in Comparison for all Indicators"]
[null,null,null,null,null,null,null,{"$f":"C11","v":"Village of Coxsackie"},{"$f":"'1. Projection Worksheet'!N29","v":0.25190000000000001}]
[null,null,null,null,null,null,null,{"$f":"J12","v":"All Villages"},4.4163244353182758E-2,null,{"$f":"O11","v":"All Villages"},null,487]
[null,null,null,null,null,null,null,{"$f":"J13","v":"Capital District Villages"},4.0723684210526322E-2,null,{"$f":"O12","v":"Capital District Villages"},null,38]
[null,null,null,null,null,null,null,{"$f":"J14","v":"Medium Upstate Villages"},4.0788805970149264E-2,null,{"$f":"O13","v":"Medium Upstate Villages"},null,134]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Indicator 4",null,null,null,null,null,null,"Indicator 5"]
[null,null,null,"ind 4"]
[null,null,"pts","Left",null,null,null,null,null,null,"ind 5"]
[null,null,"a",-100000,null,null,null,null,null,"pts","Left"]
[null,null,"3 points",0.5,null,null,null,null,null,"a",-1]
[null,null,"2 points",0.25,null,null,null,null,null,"3 points",{"$f":"'1. Projection Worksheet'!$K$30","v":0.33329999999999999}]
[null,null,"1 point",0.25,null,null,null,null,null,"2 points",{"$f":"'1. Projection Worksheet'!$K$30","v":0.33329999999999999}]
[null,null,"name","amt",null,null,null,null,null,"1 point",{"$f":"'1. Projection Worksheet'!$K$30","v":0.33329999999999999},null,null,null,null,"Reported in"]
[null,null,{"$f":"H29","v":"Village of Coxsackie"},{"$f":"'1. Projection Worksheet'!N30","v":6.6117999999999997},null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"for \" & '1. Projection Worksheet'!$H$3","v":"for 2017"}]
[null,null,{"$f":"H30","v":"All Villages"},12.745750000000001,null,null,null,null,null,"name","amt",null,null,null,{"$f":"K30","v":"All Villages"}]
[null,null,{"$f":"H31","v":"Capital District Villages"},9.1713000000000005,null,null,null,null,null,{"$f":"C53","v":"Village of Coxsackie"},{"$f":"'1. Projection Worksheet'!N31","v":4.4348999999999998},null,null,null,{"$f":"K31","v":"Capital District Villages"}]
[null,null,{"$f":"H32","v":"Medium Upstate Villages"},16.679400000000001,null,null,null,null,null,{"$f":"C54","v":"All Villages"},6.4430447638603683,null,null,null,{"$f":"K32","v":"Medium Upstate Villages"}]
[null,null,null,null,null,null,null,null,null,{"$f":"C55","v":"Capital District Villages"},6.0250289473684209]
[null,null,null,null,null,null,null,null,null,{"$f":"C56","v":"Medium Upstate Villages"},5.6062970149253735]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,"Indicator 8",null,null,null,null,null,null,"Indicator 9"]
[]
[null,null,null,"ind 8"]
[null,null,"pts","Left",null,null,null,null,null,null,"ind 9"]
[null,null,"0 points",0.65,null,null,null,null,null,"pts","Left"]
[null,null,"1 point",0.05,null,null,null,null,null,"0 points",0.1]
[null,null,"2 points",0.05,null,null,null,null,null,"1 point",0.05,null,null,null,null,"Reported in"]
[null,null,"3 points",1.2,null,null,null,null,null,"2 points",0.05,null,null,null,null,{"$f":"\"for \" & '1. Projection Worksheet'!$H$3","v":"for 2017"}]
[null,null,null,null,null,null,null,null,null,"3 points",1,null,null,null,{"$f":"O54","v":"All Villages"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O55","v":"Capital District Villages"}]
[null,null,"name","amt",null,null,null,null,null,null,null,null,null,null,{"$f":"O56","v":"Medium Upstate Villages"}]
[null,null,{"$f":"J55","v":"Village of Coxsackie"},{"$f":"'1. Projection Worksheet'!N34","v":0.3538},null,null,null,null,null,"name","amt"]
[null,null,{"$f":"J56","v":"All Villages"},0.40191909650924018,null,null,null,null,null,{"$f":"C81","v":"Village of Coxsackie"},{"$f":"'1. Projection Worksheet'!N35","v":0.15160000000000001}]
[null,null,{"$f":"J57","v":"Capital District Villages"},0.38841315789473679,null,null,null,null,null,{"$f":"C82","v":"All Villages"},9.197597535934289E-2]
[null,null,{"$f":"J58","v":"Medium Upstate Villages"},0.39575373134328357,null,null,null,null,null,{"$f":"C83","v":"Capital District Villages"},0.10500789473684208]
[null,null,null,null,null,null,null,null,null,{"$f":"C84","v":"Medium Upstate Villages"},9.371268656716418E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Fiscal Stress Score"]
[]
[]
[null,null,null,null,null,null,null,null,"name","amt"]
[null,null,null,null,null,null,null,null,{"$f":"C81","v":"Village of Coxsackie"},{"$f":"'1. Projection Worksheet'!H37","v":3.3}]
[null,null,null,null,null,null,null,null,{"$f":"C82","v":"All Villages"},7.7063655030800975]
[null,null,null,null,null,null,null,null,{"$f":"C83","v":"Capital District Villages"},10.513157894736844]
[null,null,null,null,null,null,null,null,{"$f":"C84","v":"Medium Upstate Villages"},8.714925373134319]
[]
[null,null,null,null,null,null,null,null,"none"]
[]
[null,null,null,null,null,null,null,null,"Not in Fiscal Stress",45]
[null,null,null,null,null,null,null,null,"Susceptible FS",10]
[null,null,null,null,null,null,null,null,"Moderate FS",10]
[null,null,null,null,null,null,null,null,"Significant FS",35]
[]
[]
[]
[]
[]
[]
[null,"This page provides graphical comparisons of financial indicators for the selected municipality against selected peer groups. Peer groups include data for municipalities for which current AUDs have been filed. The tables show the number of municipalities which are included in each selected peer group. Greater caution should be taken when the number of units in the comparison group is small.  "]
[]
[]
[]
[]
[]
[]
[null,"Data as of 2/28/2018"]