{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":1,"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":"Sheet1","index":0,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[[6,1,6,7],[7,1,7,4],[7,5,7,7],[0,2,0,6],[1,2,1,6],[2,1,2,7],[3,3,3,7],[4,3,4,7],[5,1,5,7],[18,1,18,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[25,1,25,2],[26,1,26,7],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2]]}
[null,"CITY NAME","NOTICE OF PUBLIC HEARING -PROPOSED PROPERTY TAX LEVY",null,null,null,null,"CITY CODE"]
[null,{"$f":"IF(ISBLANK([1]CERT!$D$5),\"\",[1]CERT!$D$5)","v":"Cumming"},"Fiscal Year July 1, 2020 - June 30, 2021",null,null,null,null,{"$f":"IF(ISBLANK([1]CERT!$L$3),\"\",[1]CERT!$L$3)","v":"91-871"}]
[null,"The City Council will conduct a public hearing on the proposed Fiscal Year City property tax levy as follows:"]
[null,"Meeting Date:","Meeting Time:","Meeting Location:"]
[null,"2020-01-27","7:00 p.m.","City Hall, 649 N. 44th Street, Cumming, Iowa"]
[null,"At the public hearing any resident or taxpayer may present objections to, or arguments in favor of the proposed tax levy. "]
[null,"After adoption of the proposed tax levy, the Council will publish notice and hold a hearing on the proposed city budget."]
[null,"City Web Site: https://www.cumming-iowa.com",null,null,null,"City Phone Number: 515-981-9214"]
[null,"Iowa Department of Management",null," ","Current Year Certified Property Tax","Budget Year Effective Property Tax","Budget Year Proposed Maximum Property Tax","Annual"]
[null,null,null," ","2019/2020","2020/2021**","2020/2021","% CHG"]
[null,"Regular Taxable Valuation",null,1,{"$f":"IFERROR(VLOOKUP([1]Start!$M$1,Max_Levy_Lookup,3,0),0)","v":27587836},25645041,25645041]
[null,"Tax Levies:"]
[null,"Regular General",null,2,{"$f":"IFERROR(VLOOKUP([1]Start!$M$1,Max_Levy_Lookup,4,0),0)","v":223461},{"$f":"E13","v":223461},207725,{"$f":"IF(ISERROR(I13),\"\",IF(I13>8.1,\"REDUCE LEVY\",\"\"))","v":""}]
[null,"Contract for Use of Bridge",null,3,{"$f":"IFERROR(VLOOKUP([1]Start!$M$1,Max_Levy_Lookup,5,0),0)","v":0},{"$f":"E14","v":0},null,{"$f":"IF(ISERROR(I14),\"\",IF(I14>0.675,\"REDUCE LEVY\",\"\"))","v":""}]
[null,"Opr & Maint Publicly Owned Transit",null,4,{"$f":"IFERROR(VLOOKUP([1]Start!$M$1,Max_Levy_Lookup,6,0),0)","v":0},0,null,{"$f":"IF(ISERROR(I15),\"\",IF(I15>0.95,\"REDUCE LEVY\",\"\"))","v":""}]
[null,"Rent, Ins. Maint. Of Non-Owned Civ. Ctr.",null,5,{"$f":"IFERROR(VLOOKUP([1]Start!$M$1,Max_Levy_Lookup,7,0),0)","v":0},0]
[null,"Opr & Maint of City-Owned Civic Center",null,6,{"$f":"IFERROR(VLOOKUP([1]Start!$M$1,Max_Levy_Lookup,8,0),0)","v":0},0,null,{"$f":"IF(ISERROR(I17),\"\",IF(I17>0.135,\"REDUCE LEVY\",\"\"))","v":""}]
[null,"Planning a Sanitary Disposal Project",null,7,{"$f":"IFERROR(VLOOKUP([1]Start!$M$1,Max_Levy_Lookup,9,0),0)","v":0},0,null,{"$f":"IF(ISERROR(I18),\"\",IF(I18>0.0675,\"REDUCE LEVY\",\"\"))","v":""}]
[null,"Liability, Property & Self-Insurance Costs",null,8,{"$f":"IFERROR(VLOOKUP([1]Start!$M$1,Max_Levy_Lookup,10,0),0)","v":4000},4000,6000]
[null,"Support of Local Emer. Mgmt. Commission",null,9,{"$f":"IFERROR(VLOOKUP([1]Start!$M$1,Max_Levy_Lookup,11,0),0)","v":0},0]
[null,"Emergency",null,10,{"$f":"IFERROR(VLOOKUP([1]Start!$M$1,Max_Levy_Lookup,12,0),0)","v":7449},7449,6925,{"$f":"IF(ISERROR(I21),\"\",IF(I21>0.27,\"REDUCE LEVY\",\"\"))","v":""}]
[null,"Police & Fire Retirement",null,11,{"$f":"IFERROR(VLOOKUP([1]Start!$M$1,Max_Levy_Lookup,13,0),0)","v":0},0]
[null,"FICA & IPERS",null,12,{"$f":"IFERROR(VLOOKUP([1]Start!$M$1,Max_Levy_Lookup,14,0),0)","v":13500},13500,15000]
[null,"Other Employee Benefits",null,13,{"$f":"IFERROR(VLOOKUP([1]Start!$M$1,Max_Levy_Lookup,15,0),0)","v":6240},6240,7200]
[null,"*Total 384.15A Maximum Tax Levy",null,14,{"$f":"SUM(E13:E24)","v":254650},{"$f":"SUM(F12:F24)","v":254650},{"$f":"SUM(G12:G24)","v":242850},{"$f":"IFERROR((G25-E25)/E25,0)","v":-4.6338111132927545E-2}]
[null,"Calculated 384.15A MaximumTax Rate",null,15,{"$f":"IF(E11>0, ROUND(E25/E11*1000,5),0)","v":9.2305200000000003},{"$f":"IF(F11>0, ROUND(F25/F11*1000,5),0)","v":9.9298000000000002},{"$f":"IFERROR(IF(G11>0, ROUND(G25/G11*1000,5),0),0)","v":9.4696700000000007}]
[null,"Explanation of significant increases in the budget: None"]
[null,"If applicable, the above notice also available online at: https://www.cumming-iowa.com, https://facebook.com/cummingdeputyclerk"]
[null,"  *Total city tax rate will also include voted general fund levy, debt service levy, and capital improvement reserve levy"]
[null,"**Budget year effective propert tax rate is the rate that would be assessed for these levies if the dollars requested is not changed in the coming budget year"]