{"text_format":"3","workbook":"xlsx","n_sheets":26,"sheets":["Totals","Resolution 20-10","LB-50","LB-1 Notice","LB-20 General","LB-31 General D Req"," LB-30 Admin Req","LB-31 Admin Fund Req","LB-30 Park Req","LB-31 Park D Req","LB-20 Water","LB-30 Water Req","LB-31 Water D Req","LB-20 State Street","LB-30 Streets Req","LB-31 Streets D Req","LB-20 Library","LB-30 Library Req","LB-31 Library D Req","LB-20 State Rev","LB-31 State Rev D Req","LB-11 Capital Outlay","LB-11 Water Loan","LB-11 WSR","LB-35 Debt Serv","LB-11 Park"],"not_rendered":{"defined_names":18,"comments":18},"read":"whole","date_system":"1900"}

{"sheet":"Totals","index":0,"n_rows":27,"n_cols":9,"rows_kept":27}
["Resources:"]
[" Beginning Fund Balance/Net Working Capital",{"$nulls":6},{"$f":"SUM('LB-20 General'!F9,'LB-20 Water'!F9,'LB-20 State Street'!F9,'LB-20 Library'!F9,'LB-20 State Rev'!F9,'LB-11 Capital Outlay'!F12,'LB-11 Water Loan'!F12,'LB-11 WSR'!F12,)","v":{"v":451886,"d":"$451,886.00"}}]
[" Fees, Licenses, Permits, Fines, Assessments & Other Service Charges",{"$nulls":6},{"$f":"SUM('LB-20 General'!F15,'LB-20 General'!F18,'LB-20 General'!F21,'LB-20 General'!F23,'LB-20 General'!F24,'LB-20 General'!F25,'LB-20 General'!F28,'LB-20 State Street'!F19)","v":{"v":32200,"d":"$32,200.00"}}]
[" Federal, State and All Other Grants, Gifts, Allocations and Donations",{"$nulls":6},{"$f":"SUM('LB-20 General'!F16,'LB-20 General'!F17,'LB-20 State Street'!F16,'LB-20 Library'!F18,'LB-20 Library'!F17,'LB-20 Library'!F19,'LB-20 State Rev'!F16,)","v":{"v":35200,"d":"$35,200.00"}}]
[" Revenue from Bonds and Other Debt ",{"$nulls":6},{"v":0,"d":"$0.00"}]
[" Interfund Transfers / Internal Service Reimbursements",{"$nulls":6},{"$f":"SUM('LB-20 General'!F28,'LB-20 State Street'!F13,'LB-20 Library'!F23)","v":{"v":24000,"d":"$24,000.00"}}]
["All Other Resources Except Property Taxes",{"$nulls":6},{"$f":"SUM('LB-20 General'!F12,'LB-20 General'!F19,'LB-20 General'!F20,'LB-20 Water'!F12,'LB-20 Water'!F15,'LB-20 Water'!F16,'LB-20 Water'!F17,'LB-20 Water'!F18,'LB-20 Water'!F19,'LB-20 Water'!F20,'LB-20 State Street'!F12,'LB-20 State Street'!F18,'LB-20 State Rev'!F12,'LB-11 Capital Outlay'!F15,'LB-11 Water Loan'!F15,'LB-11 Water Loan'!F15,'LB-11 WSR'!F15)","v":{"v":145236,"d":"$145,236.00"}},{"v":139276,"d":"$139,276.00"}]
["Property Taxes Estimated to be Received",{"$nulls":6},{"$f":"SUM('LB-20 General'!F11,'LB-20 General'!F38,'LB-20 Library'!F15)","v":{"v":98500,"d":"$98,500.00"}}]
[{"$nulls":7},{"$f":"SUM(H2:H8)","v":{"v":787022,"d":"$787,022.00"}}]
[]
["Total Budget:",{"$nulls":6},{"v":781542,"d":"$781,542.00"}]
[]
[]
[]
[]
[]
[]
["Expenses:"]
["Personell Services",null,null,{"$f":"SUM(' LB-30 Admin Req'!F16,'LB-30 Park Req'!F16,'LB-30 Water Req'!F16,'LB-30 Streets Req'!F16,'LB-30 Library Req'!F16)","v":{"v":164450,"d":"$164,450.00"}}]
["Materials & Services",null,null,{"v":217126,"d":"$217,126.00"}]
["Capital Outlay",null,null,{"$f":"SUM(' LB-30 Admin Req'!F31,'LB-30 Park Req'!F24,'LB-30 Water Req'!F32,'LB-30 Streets Req'!F32,'LB-11 Capital Outlay'!F30,'LB-11 WSR'!F26)","v":{"v":312793,"d":"$312,793.00"}}]
["Debt Service",null,null,{"$f":"SUM('LB-30 Water Req'!F22)","v":{"v":22500,"d":"$22,500.00"}}]
["Interfund Transfers",null,null,{"$f":"SUM('LB-31 General D Req'!J21,' LB-30 Admin Req'!F33,)","v":{"v":17000,"d":"$17,000.00"}}]
["Contingencies",null,null,{"$f":"SUM('LB-31 General D Req'!J10,'LB-30 Water Req'!F38,'LB-30 Library Req'!F38,)","v":{"v":68716,"d":"$68,716.00"}}]
["Special Payments",null,null,{"v":0,"d":"$0.00"}]
["Reserved for future Expenditure",null,null,{"$f":"SUM('LB-11 Water Loan'!F40)","v":{"v":42890,"d":"$42,890.00"}}]
[{"$nulls":3},{"$f":"SUM(D19:D26)","v":{"v":845475,"d":"$845,475.00"}}]

{"sheet":"Resolution 20-10","index":1,"n_rows":86,"n_cols":10,"rows_kept":86,"merged":[[0,1,0,8],[2,1,2,8],[4,1,4,9],[8,1,8,8],[10,1,10,9],[17,2,17,3],[19,2,19,3],[52,7,52,8],[56,1,56,8],[59,1,59,6],[60,1,60,8],[61,1,61,8],[62,1,62,8],[64,1,64,8],[68,2,68,6],[70,1,70,6],[71,1,71,6],[73,2,73,4],[75,1,75,6],[77,1,77,8],[80,2,80,3]]}
[null,"RESOLUTION  NO. 20-10  "]
[]
[null,"RESOLUTION ADOPTING THE BUDGET"]
[]
[null,"BE IT RESOLVED that the City Council of City of Adams hereby adopts the budget for fiscal year   2020-2021                                                                                                                                                                                                                                                         "]
[null,"in the amount of $781,542.00*"]
[null,"This budget is now on file at Adams City Hall in Adams, Oregon."]
[]
[null,"RESOLUTION MAKING APPROPRIATIONS"]
[]
[null,"BE IT RESOLVED that the amounts shown below are hereby appropriated for the fiscal year beginning "]
[null," July 1, 2020 for the following purposes:"]
[null,null,"General Fund",{"$nulls":3},"Capital Outlay"]
[null,null,"Organizational Unit or Program:  General Fund",{"$nulls":3},"Org. Unit/Program: Public Works",null,{"v":192813,"d":"192,813"}]
[null,null,"Adminstration   ",null,{"v":101950,"d":"101,950"},null,"Special Payments………………",null,0]
[null,null,"Parks",null,{"v":26850,"d":"26,850"},null,"Transfers Out…………",null,0]
[{"$nulls":6},"Debt Service………………………",null,0]
[{"$nulls":6},"Contingency…………..……",null,0]
[]
[{"$nulls":4},{"$f":"SUM(E15:E19)","v":{"v":128800,"d":"$128,800"}}]
[null,null,"Not Allocated to Organizational Unit or Program:",{"$nulls":3},"   Total………....",null,{"$f":"SUM(I14:I18)","v":{"v":192813,"d":"$192,813"}}]
[null,null,"Transfers Out…………",null,{"v":7000,"d":"7,000"}]
[null,null,"Contingency…………..……",null,{"v":30181,"d":"30,181"}]
[null,null,"   Total………....",null,{"$f":"SUM(E20:E23)","v":{"v":165981,"d":"$165,981"}},"         "]
[]
[null,null,"State Street Fund",{"$nulls":3},"Water Fund"]
[null,null,"Org. Unit/Program:  State St. Fund",null,{"v":104913,"d":"104,913"},null,"Org. Unit/Program: Public Works",null,{"v":105650,"d":"105,650"}]
[null,null,"Special Payments………………",{"$nulls":3},"Debt Service ………………",null,{"v":22500,"d":"22,500"}]
[null,null,"Transfers Out…………",null,0,null,"Transfers Out…………",null,{"v":7000,"d":"7,000"}]
[null,null,"Contingency…………..……",null,0,null,"Contingency…………..……",null,{"v":24525,"d":"24,525"}]
[null,null,"   Total………....",null,{"$f":"SUM(E27:E30)","v":{"v":104913,"d":"$104,913"}},null,"   Total………....",null,{"$f":"SUM(I27:I30)","v":{"v":159675,"d":"$159,675"}}]
[]
[null,null,"LibraryFund"]
[null,null,"Org. Unit/Program:  Library",null,{"v":56950,"d":"56,950"}]
[null,null,"Special Payments………………",null,0,null,"Water Reserve Loan Fund"]
[null,null,"Transfers Out…………",null,0,null,"Org. Unit/Program: Public Works ",null,{"v":42890,"d":"42,890"}]
[null,null,"Contingency…………..……",null,{"v":11010,"d":"11,010"},null,"Debt Service………………",null,0]
[null,null,"   Total………....",null,{"$f":"SUM(E34:E37)","v":{"v":67960,"d":"$67,960"}},null,"Transfers Out…………",null,0]
[{"$nulls":6},"Contingency…………..……",null,0]
[{"$nulls":6},"   Total………....",null,{"$f":"SUM(I36:I39)","v":{"v":42890,"d":"$42,890"}}]
[null,null,"Water System Replacement Fund"]
[null,null,"Org. Unit/Program: Utility System Improve ",null,{"v":37317,"d":"37,317"}]
[null,null,"Special Payments………………",null,0]
[null,null,"Transfers Out…………",null,0,null,"State Revenue Sharing"]
[null,null,"Contingency…………..……",null,0,null,"Org. Unit/Program:  State Revenue Sharing",null,{"v":9993,"d":"9,993"}]
[null,null,"   Total………....",null,{"$f":"SUM(E42:E45)","v":{"v":37317,"d":"$37,317"}},null,"Special Payments………………",null,0]
[{"$nulls":6},"Transfers Out…………",null,0]
[{"$nulls":6},"Contingency…………..……",null,0]
[null,null," ",{"$nulls":3},"   Total………....",null,{"$f":"SUM(I45:I48)","v":{"v":9993,"d":"$9,993"}}]
[null,null," ",null," "]
[{"$nulls":7},"Total Unappropriated and Reserve Amounts, All Funds . . . ."]
[{"$nulls":7},"TOTAL ADOPTED BUDGET . . . .",{"$f":"SUM(E24+E31+E38+E46+I21+I31+I40+I49+I51)","v":{"v":781542,"d":"$781,542"}}," *"]
[{"$nulls":7},"(*amounts with asterisks must match)"]
[]
[]
[]
[null,"RESOLUTION IMPOSING THE TAX"]
[]
[null,"BE IT RESOLVED that the following ad valorem property taxes are hereby imposed upon the assessed value"]
[null,"of all taxable property within the district for tax year 2020- 2021:"]
[null," (1) In the amount of $ __________ OR  at the rate of $ 4.1176 per $1000 of assessed value for permanent rate tax;"]
[]
[]
[]
[null,"RESOLUTION CATEGORIZING THE TAX"]
[]
[null,"BE IT RESOLVED that the taxes imposed are hereby categorized for purposes of Article XI section 11b as: "]
[]
[null,null,"Subject to the General Government Limitation"]
[]
[null,"Permanent Rate Tax..........$___________ OR $ 4.1176/$1,000"]
[]
[]
[]
[]
[]
[]
[null,"The above resolution statements were approved and declared adopted on June 15, 2020."]
[]
[null,null," _______________________________"]
[" ",null,"Mayor"]
[]
[null,"                 X____________________________________________"," _______________________________"]
[null,null,"City Recorder"]
[]
["150-504-073-6 (Rev. 12-13)"]

{"sheet":"LB-50","index":2,"n_rows":55,"n_cols":15,"rows_kept":55,"merged":[[0,0,1,11],[0,14,0,15],[1,13,1,15],[2,0,2,12],[7,1,7,5],[8,1,8,6],[9,2,9,6],[10,2,10,5],[11,0,11,6],[11,7,11,9],[11,10,11,11],[11,14,11,15],[12,0,12,3],[12,6,12,8],[12,14,12,15],[13,0,13,3],[13,5,13,8],[13,10,13,12],[13,14,13,15],[14,5,14,7],[14,10,14,12],[19,11,19,13],[19,14,19,15],[20,11,20,13],[20,14,20,15],[21,11,21,13],[22,11,22,13],[23,11,23,13],[24,11,24,13],[24,14,24,15],[25,11,25,13],[25,14,25,15],[26,14,26,15],[27,14,27,15],[28,14,28,15],[31,14,31,15],[32,14,32,15],[33,14,33,15],[38,0,38,6],[38,7,38,9],[38,10,38,11],[38,13,38,15],[39,0,39,6],[39,7,39,9],[39,10,39,11],[39,13,39,15],[40,0,40,6],[40,7,40,9],[40,10,40,11],[40,13,40,15],[41,0,41,6],[41,7,41,9],[41,10,41,11],[41,13,41,15],[44,7,44,11],[45,1,45,6],[45,7,45,11],[45,12,45,15],[46,1,46,6],[46,7,46,11],[46,12,46,15],[47,0,47,15],[54,0,54,15]]}
["Notice of Property Tax and Certification of Intent to Impose a Tax, Fee, Assessment or Charge on Property",{"$nulls":13},"FORM LB-50"]
[{"$nulls":13},"2020-2021"]
["To assessor of UMATILLA County"]
[]
[{"$nulls":14},"Check here if this is "]
[".","Be sure to read instructions in the Notice of Property Tax Levy Forms and Instruction booklet",{"$nulls":12},"an amended form."]
[]
["The","City of Adams",{"$nulls":4},"has the responsibility and authority to place the following property tax, fee, charge or assessment"]
[null,"District Name"]
["on the tax roll of",null,"Umatilla",{"$nulls":4},"County.  The property tax, fee, charge or assessment is categorized as stated by this form."]
[null,null,"County Name"]
["P. O. Box 20",{"$nulls":6},"Adams",null,null,"OR",null,"97810",null,"June 15, 2020"]
["Mailing Address of District",{"$nulls":5},"City",{"$nulls":3},"State",null,"ZIP code",null,"Date"]
["Donna Grimes",{"$nulls":4},"Budget Officer",{"$nulls":4},"541-566-9380",{"$nulls":3},"cityofadams@wtechlink.us"]
["Contact Person",{"$nulls":4},"Title",{"$nulls":4},"Daytime Telephone",{"$nulls":3},"Contact Person E-Mail"]
["CERTIFICATION - You must check one box if your district is subject to Local Budget Law."]
[null,"The tax rate or levy amounts certified in Part I are within the tax rate or levy amounts approved by the budget committee."]
[null,"The tax rate or levy amounts certified in Part I were changed by the governing body and republished as required in ORS 294.435."]
[]
["PART I:  TOTAL PROPERTY TAX LEVY",{"$nulls":10},"Subject to"]
[{"$nulls":11},"General Government Limits"]
[null,"   ",{"$nulls":9},"Rate -or- Dollar Amount"]
[{"v":1,"d":"1."},"Rate/Amount levied (within permanent rate limit) . . . . . . . . . . . . . . . . . . . ",{"$nulls":8},{"$f":"A23","v":1},4.1176]
[{"v":2,"d":"2."},"Local option operating tax . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",{"$nulls":8},{"$f":"A24","v":2}]
[{"v":3,"d":"3."},"Local option capital project tax . . . . . . . . . . . . . . . . . . . . . . . .  . . . . . . . . . . . . . .",{"$nulls":8},{"$f":"A25","v":3},{"$nulls":3},"Excluded from            Measure 5 Limits"]
[{"v":4,"d":"4."},"Levy for pension and disability obligations . . . . . . . . . . . . . . . . . . . . . . . . . ",{"$nulls":8},{"$f":"A26","v":4},{"$nulls":3},"Dollar Amount of Bond Levy"]
["5a.","Levy for bonded indebtedness from bonds approved by voters prior to October 6, 2001 . . . . . . . . . . . . ",{"$nulls":11},{"$f":"A27","v":"5a."}]
["5b.","Levy for bonded indebtedness from bonds approved by voters on or after October 6, 2001  . . . . . . . . . . . . . . . . . . . . . . . . .",{"$nulls":11},{"$f":"A28","v":"5b."}]
["5c.","Total levy for bonded indebtedness not subject to Measure 5 or Measure 50 (total of 5a + 5b) . . . . . . . . . . . . .",{"$nulls":11},{"$f":"A29","v":"5c."},{"$f":"SUM(O27:O28)","v":{"v":0,"d":"0 "}}]
[]
["PART II:  RATE LIMIT CERTIFICATION"]
[{"v":6,"d":"6."},"Permanent rate limit in dollars and cents per $1,000 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",{"$nulls":11},{"$f":"A32","v":6},4.1176]
[{"v":7,"d":"7."},"Election date when your new district received voter approval for your permanent rate limit . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",{"$nulls":11},{"$f":"A33","v":7}]
[{"v":8,"d":"8."},"Estimated permanent rate limit for newly merged/consolidated district . . . . . . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . ",{"$nulls":11},{"$f":"A34","v":8}]
[]
[]
["PART III:  SCHEDULE OF LOCAL OPTION TAXES  -  Enter all local option taxes on this schedule.  If there are more than two taxes,"]
[{"$nulls":7},"   attach a sheet showing the information for each."]
["Purpose",{"$nulls":6},"Date voters approved",null,null,"First year",null,"Final year ","Tax amount -or- rate"]
["(operating, capital project, or mixed)",{"$nulls":6},"local option ballot measure",null,null,"levied",null,"to be levied","authorized per year by voters"]
[]
[]
[]
["Part IV. SPECIAL ASSESSMENTS, FEES AND CHARGES"]
[null,"Description",{"$nulls":5},"Subject to General Government Limitation",{"$nulls":6},"Excluded from Measure 5 Limitation"]
[1]
[2]
[]
["If fees, charges, or assessments will be imposed on specific property within your district, you must attach a complete listing of"]
["properties, by assessor’s account number, to which fees, charges, or assessments will be imposed. Show the fees, charges, or"]
["assessments uniformly imposed on the properties. If these amounts are not uniform, show the amount imposed on each property."]
["The authority for putting these assessments on the roll is ORS __________________    (Must be completed if you have an entry in Part IV)"]
[]
["150-504-073-7 (Rev. 11-11)",null,null,"(see the back for worksheet for lines 5a, 5b, and 5c)"]
["File with your assessor no later than JULY 15, unless granted an extension in writing."]

{"sheet":"LB-1 Notice","index":3,"n_rows":69,"n_cols":5,"rows_kept":69,"merged":[[0,1,0,4],[7,0,7,1],[7,3,7,4],[8,0,8,4],[9,0,9,4],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,4],[21,0,21,4],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,4],[32,0,32,4],[33,0,33,1],[34,0,34,1],[35,0,35,1],[36,0,36,1],[37,0,37,1],[38,0,38,1],[39,0,39,1],[40,0,40,1],[41,0,41,1],[42,0,42,1],[43,0,43,1],[44,0,44,1],[45,0,45,1],[46,0,46,1],[47,0,47,4],[48,0,48,4],[49,0,54,4],[55,0,55,4],[56,0,56,1],[57,0,57,1],[58,0,58,1],[59,0,59,1],[60,0,60,4],[61,0,61,4],[62,1,62,2],[62,3,62,4],[63,1,63,2],[63,3,63,4],[64,1,64,2],[64,3,64,4],[65,1,65,2],[65,3,65,4],[66,1,66,2],[66,3,66,4],[67,1,67,2],[67,3,67,4]]}
["FORM LB-1 ","                         NOTICE OF BUDGET HEARING               "]
[]
[]
[]
[]
[]
[]
["Contact:  Donna Grimes",null,"Telephone:   541-566-9380","Email:   cityofadams@wtechlink.us"]
[]
["FINANCIAL SUMMARY - RESOURCES"]
["TOTAL OF ALL FUNDS",null,"Actual Amount","Adopted Budget","Approved Budget"]
[null,null,"2018-2019","This Year 2019-2020","Next Year 2020-21"]
[" Beginning Fund Balance/Net Working Capital",null,{"v":337632,"d":"337,632 "},{"v":372290,"d":"372,290 "},{"v":451886,"d":"451,886 "}]
[" Fees, Licenses, Permits, Fines, Assessments & Other Service Charges",null,{"v":113100,"d":"113,100 "},{"v":113100,"d":"113,100 "},{"v":32680,"d":"32,680 "}]
[" Federal, State and All Other Grants, Gifts, Allocations and Donations",null,{"v":134900,"d":"134,900 "},{"v":144000,"d":"144,000 "},{"v":35200,"d":"35,200 "}]
[" Revenue from Bonds and Other Debt ",null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[" Interfund Transfers / Internal Service Reimbursements",null,{"v":41000,"d":"41,000 "},{"v":72400,"d":"72,400 "},{"v":24000,"d":"24,000 "}]
["All Other Resources Except Property Taxes",null,{"v":2257,"d":"2,257 "},{"v":2324,"d":"2,324 "},{"v":139276,"d":"139,276 "}]
["Property Taxes Estimated to be Received",null,{"v":66800,"d":"66,800 "},{"v":68300,"d":"68,300 "},{"v":98500,"d":"98,500 "}]
["     Total Resources ",null,{"$f":"SUM(C13:C19)","v":{"v":695689,"d":"695,689 "}},{"$f":"SUM(D13:D19)","v":{"v":772414,"d":"772,414 "}},{"$f":"SUM(E13:E19)","v":{"v":781542,"d":"781,542 "}}]
[]
["FINANCIAL SUMMARY - REQUIREMENTS BY OBJECT CLASSIFICATION"]
["Personnel Services",null,{"v":145800,"d":"145,800 "},{"v":152350,"d":"152,350 "},{"v":164450,"d":"164,450 "}]
["Materials and Services",null,{"v":160344,"d":"160,344 "},{"v":167230,"d":"167,230 "},{"v":217606,"d":"217,606 "}]
["Capital Outlay",null,{"v":316250,"d":"316,250 "},{"v":350075,"d":"350,075 "},{"v":248380,"d":"248,380 "}]
["Debt Service",null,{"v":8485,"d":"8,485 "},{"v":3440,"d":"3,440 "},{"v":22500,"d":"22,500 "}]
["Interfund Transfers",null,{"v":41000,"d":"41,000 "},{"v":72400,"d":"72,400 "},{"v":17000,"d":"17,000 "}]
["Contingencies",null,{"v":23810,"d":"23,810 "},{"v":26919,"d":"26,919 "},{"v":68716,"d":"68,716 "}]
["Special Payments",{"$nulls":3},{"v":0,"d":"0 "}]
["Unappropriated Ending Balance and Reserved for Future Expenditure",null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":42890,"d":"42,890 "}]
["     Total Requirements",null,{"$f":"SUM(C23:C30)","v":{"v":695689,"d":"695,689 "}},{"$f":"SUM(D23:D30)","v":{"v":772414,"d":"772,414 "}},{"$f":"SUM(E23:E30)","v":{"v":781542,"d":"781,542 "}}]
[]
["FINANCIAL SUMMARY - REQUIREMENTS BY ORGANIZATIONAL UNIT OR PROGRAM *"]
["Name of Organizational Unit or Program "]
["     FTE for that unit or program"]
["GENERAL-ADMINISTRATIVE",null,{"v":17452,"d":"17,452 "},{"v":33200,"d":"33,200 "},{"v":36400,"d":"36,400 "}]
["      FTE",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},0.75]
["GENERAL-PARK",null,{"v":10093,"d":"10,093 "},{"v":15600,"d":"15,600 "},{"v":15600,"d":"15,600 "}]
["     FTE",null,0.25,0.25,0.25]
["LIBRARY",null,{"v":24961,"d":"24,961 "},{"v":31900,"d":"31,900 "},{"v":40800,"d":"40,800 "}]
["     FTE",null,{"v":0.5,"d":"0.50"},{"v":0.5,"d":"0.50"},{"v":1,"d":"1.00"}]
["WATER",null,{"v":41793,"d":"41,793 "},{"v":53100,"d":"53,100 "},{"v":53100,"d":"53,100 "}]
["     FTE",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"}]
["GAS TAX-STREET",null,{"v":13230,"d":"13,230 "},{"v":18550,"d":"18,550 "},{"v":18550,"d":"18,550 "}]
["     FTE",null,0.25,0.25,0.25]
["     Total Requirements",null,{"$f":"C36+C38+C40+C42+C44","v":{"v":107529,"d":"107,529 "}},{"v":152350,"d":"152,350 "},{"v":164450,"d":"164,450 "}]
["           Total FTE",null,{"v":3,"d":"3.00"},{"v":3,"d":"3.00"},3.25]
[]
["STATEMENT OF CHANGES IN ACTIVITIES and SOURCES OF FINANCING *"]
["  The City will be increasing the Librarians hours from 25 to 30 per week making the position eligible for health benefits. The library will be open more hours and the Librarian will serve as a grant writer for the City.  The Wildhorse Creek Stabilization Project will conclude this year helping to protect our park structures."]
[]
[]
[]
[]
[]
["PROPERTY TAX LEVIES"]
[null,null,"Rate or Amount Imposed","Rate or Amount Imposed","Rate or Amount Approved"]
[" Permanent Rate Levy      (rate limit  4.1176 per $1,000)",null,"4.1176","4.1176","4.1176"]
[" Local Option Levy"]
[" Levy For General Obligation Bonds"]
[]
["STATEMENT OF INDEBTEDNESS"]
["LONG TERM DEBT","Estimated Debt Outstanding ",null,"Estimated Debt Authorized, But "]
[null,"on July 1.",null," Not Incurred on July 1"]
["General Obligation Bonds"]
["Other Bonds"]
["Other Borrowings",{"v":277601,"d":"$277,601"},null,{"v":0,"d":"$0"}]
["     Total",{"v":277601,"d":"$277,601"},null,{"v":0,"d":"$0"}]
["* If more space is needed to complete any section of this form, insert lines (rows) on this sheet or add sheets.  You may delete unused lines."]

{"sheet":"LB-20 General","index":4,"n_rows":41,"n_cols":9,"rows_kept":41,"merged":[[0,1,0,2],[0,6,0,7],[1,1,1,2],[1,5,1,7],[2,1,2,2],[2,5,2,7],[3,0,6,0],[3,1,3,3],[3,4,6,4],[3,5,3,7],[3,8,6,8],[4,1,4,2],[4,5,6,5],[4,6,6,6],[4,7,6,7]]}
[null,"FORM",null,null,"RESOURCES"]
[null,"LB-20",null,null,"GENERAL FUND","CITY OF ADAMS"]
[{"$nulls":4},"(Fund)","(Name of Municipal Corporation)"]
[null,"Historical Data",null,null,"RESOURCE DESCRIPTION\n","Budget for Next Year 2020-2021"]
[null,"Actual",null,"Adopted Budget",null,"Proposed By\nBudget Officer","Approved By\nBudget Committee","Adopted By\nGoverning Body"]
[null,"Second Preceding","First Preceding","This Year"]
[null,"Year '17-'18","Year '18-'19","19-'20"]
[]
[1,62000,68293,108269,"1.   Available cash on hand* (cash basis) or",{"$f":"123131-58400","v":64731},64731,64731,1]
[2,{"$nulls":3},"2.   Net working capital (accrual basis)",{"$nulls":3},2]
[3,800,800,800,"3.   Previously levied taxes estimated to be received",1000,1000,1000,3]
[4,50,43,100,"4.   Interest",1500,1500,1500,4]
[5,{"$nulls":3},"5.   Transferred IN, from other funds",{"$nulls":3},5]
[6,{"$nulls":3},"6.                      OTHER RESOURCES",{"$nulls":3},6]
[7,10750,10786,12000,"7.   P. P. & L. FRANCHISE",12000,12000,12000,7]
[8,5564,5931,5700,"8.   OLCC",5700,5700,5700,8]
[9,600,390,600,"9.   CIGARETTE TAX",400,400,400,9]
[10,600,538,600,"10.  GARBAGE FRANCHISE",600,600,600,10]
[11,1000,750,1000,"11.   PLANNING PERMITS",500,500,500,11]
[12,750,0,750,"12.  MISCELLANEOUS",750,750,750,12]
[13,1000,758,1000,"13.  QWEST",800,800,800,13]
[14,1000,0,1000,"14.  GRANTS",1000,1000,1000,14]
[15,500,320,600,"15.  LICENSES & FEES",500,500,500,15]
[16,{"$nulls":3},"16   EASTERN OREGON TELECOM FRANCHISE",1000,1000,1000,16]
[17,{"$nulls":3},"17.  WTECHLINK FRANCHISE",1000,1000,1000,17]
[18,{"$nulls":3},18,{"$nulls":3},18]
[19,{"$nulls":3},19,{"$nulls":3},19]
[20,7000,7000,7000,"20  WATER UTILITY EASEMENT FEES",7000,7000,7000,20]
[21,null,null,3439,"21   DEBT SERVICE LOAN REPAYMENT",0,0,0,21]
[22,{"$nulls":3},22,{"$nulls":3},22]
[23,{"$nulls":3},23,{"$nulls":3},23]
[24,{"$nulls":3},24,{"$nulls":3},24]
[25,{"$nulls":3},25,{"$nulls":3},25]
[26,{"$nulls":3},26,{"$nulls":3},26]
[27,{"$nulls":3},27,{"$nulls":3},27]
[28,{"$nulls":3},28,{"$nulls":3},28]
[29,{"$f":"SUM(B9:B36)","v":91614},{"$f":"SUM(C9:C36)","v":95609},{"$f":"SUM(D9:D29)","v":142858},"29. Total resources, except taxes to be levied",{"$f":"SUM(F9:F33)","v":98481},98481,98481,29]
[30,null,null,67500,"30. Taxes estimated to be received",67500,67500,67500,30]
[31,62235,69329,null,"31. Taxes collected in year levied",{"$nulls":3},31]
[32,{"$f":"B37+B39","v":153849},{"$f":"C37+C39","v":164938},206919,"32.  TOTAL RESOURCES",{"$f":"F37+F38","v":165981},{"$f":"G37+G38","v":165981},{"$f":"H37+H38","v":165981},32]
[{"$nulls":4},"*Includes ending balance from prior year",{"$f":"IF(NOT(F40='LB-31 General D Req'!J41),\"RESOURCES <> REQUIREMENTS\", \"\")","v":""}]

{"sheet":"LB-31 General D Req","index":5,"n_rows":42,"n_cols":13,"rows_kept":42,"merged":[[0,1,0,3],[0,4,0,6],[0,7,0,12],[1,1,1,3],[1,4,1,6],[1,7,1,12],[2,1,2,3],[2,4,2,6],[2,7,2,12],[3,1,3,3],[3,4,3,6],[3,7,3,12],[4,0,7,0],[4,1,4,3],[4,4,7,6],[4,7,7,7],[4,8,7,8],[4,9,5,11],[4,12,7,12],[5,1,5,2],[8,4,8,6],[9,4,9,6],[10,4,10,6],[11,4,11,6],[12,4,12,6],[13,4,13,6],[14,4,14,6],[15,4,15,6],[16,4,16,6],[17,4,17,6],[18,4,18,6],[19,4,19,6],[20,4,20,6],[21,4,21,6],[22,4,22,6],[23,4,23,6],[24,4,24,6],[25,4,25,6],[26,4,26,6],[27,4,27,6],[28,4,28,6],[29,4,29,6],[30,4,30,6],[31,4,31,6],[32,4,32,6],[33,4,33,6],[34,4,34,6],[35,4,35,6],[36,4,36,6],[37,4,37,6],[38,4,38,6],[39,4,39,6],[40,4,40,6]]}
[{"$nulls":4},"DETAILED REQUIREMENTS"]
[null,"FORM"]
[null,"LB-31",null,null,"CITY OF ADAMS-GENERAL FUND",null,null," "]
[{"$nulls":4},"(Name of Organizational Unit - Fund)"]
[null,"Historical Data",null,null,"REQUIREMENTS DESCRIPTION",null,null,"Number of Employ-ees","Range*","Budget for Next Year 2019-2020"]
[null,"Actual",null,"Adopted Budget"]
[null,"Second Preceding","First Preceding","This Year",{"$nulls":5},"Proposed by","Approved by","Adopted by"]
[null,"Year '17-'18","Year '18-'19","19-'20",{"$nulls":5},"Budget Officer","Budget Committee","Governing Body"]
[1,{"$nulls":3},1,{"$nulls":7},1]
[2,25850,23810,26919,"2     OPERATING CONTINGENCY",{"$nulls":4},{"$f":"88581-58400","v":30181},30181,30181,2]
[3,{"$nulls":3},3,{"$nulls":7},3]
[4,8810,43301,87750,"4     TOTAL ADMINISTRATIVE",{"$nulls":4},101950,101950,101950,4]
[5,{"$nulls":3},5,{"$nulls":7},5]
[6,26300,26300,26850,"6     TOTAL PARK",{"$nulls":4},26850,26850,26850,6]
[7,{"$nulls":3},7,{"$nulls":7},7]
[8,{"$nulls":3},8,{"$nulls":7},8]
[9,10000,20000,58400,"9     TRANSFER TO CAPITAL OUTLAY FUND",{"$nulls":4},0,0,0,9]
[10,{"$nulls":3},10,{"$nulls":7},10]
[11,0,0,0,"11    TRANSFER TO DEBT SERVICE FUND",{"$nulls":4},0,0,0,11]
[12,{"$nulls":3},12,{"$nulls":7},12]
[13,7000,7000,7000,"13   TRANSFER TO GAS TAX FUND",{"$nulls":4},7000,7000,7000,13]
[14,{"$nulls":3},14,{"$nulls":7},14]
[15,{"$nulls":3},15,{"$nulls":7},15]
[16,{"$nulls":3},16,{"$nulls":7},16]
[17,{"$nulls":3},17,{"$nulls":7},17]
[18,{"$nulls":3},18,{"$nulls":7},18]
[19,{"$nulls":3},19,{"$nulls":7},19]
[20,{"$nulls":3},20,{"$nulls":7},20]
[21,{"$nulls":3},21,{"$nulls":7},21]
[22,{"$nulls":3},22,{"$nulls":7},22]
[23,{"$nulls":3},23,{"$nulls":7},23]
[24,{"$nulls":3},24,{"$nulls":7},24]
[25,{"$nulls":3},25,{"$nulls":7},25]
[26,{"$nulls":3},26,{"$nulls":7},26]
[27,{"$nulls":3},27,{"$nulls":7},27]
[28,{"$nulls":3},28,{"$nulls":7},28]
[29,{"$nulls":3},29,{"$nulls":7},29]
[30,{"$nulls":3},30,{"$nulls":7},30]
[31,60691,91827,null,"31 Ending balance (prior years)",{"$nulls":7},31]
[32,null,null,0,"32  UNAPPROPRIATED ENDING FUND BALANCE",{"$nulls":7},32]
[33,{"$f":"SUM(B9:B40)","v":138651},{"$f":"SUM(C9:C40)","v":212238},{"$f":"SUM(D9:D40)","v":206919},"33    TOTAL REQUIREMENTS",{"$nulls":4},{"$f":"SUM(J9:J40)","v":165981},{"$f":"SUM(K9:K40)","v":165981},{"$f":"SUM(L9:L40)","v":165981},33]
[null,"150-504-031  (Rev 12/09)",{"$nulls":7},{"$f":"IF(NOT(J41='LB-20 General'!F40),\"RESOURCES <> REQUIREMENTS\", \"\")","v":""}]

{"sheet":" LB-30 Admin Req","index":6,"n_rows":42,"n_cols":9,"rows_kept":42,"merged":[[0,3,0,5],[1,3,1,5],[2,3,2,5],[3,3,3,5],[3,6,3,8],[4,0,7,0],[4,1,4,3],[4,4,7,4],[4,5,5,7],[4,8,7,8],[5,1,5,2],[8,1,8,3],[8,5,8,7],[16,1,16,3],[16,5,16,7],[24,1,24,3],[24,5,24,7],[31,1,31,3],[31,5,31,7]]}
[{"$nulls":3},"REQUIREMENTS SUMMARY"]
[null,"FORM",null,"BY FUND, ORGANIZATIONAL UNIT OR PROGRAM"]
[null,"LB-30",null,"CITY OF ADAMS-ADMINISTRATIVE-GENERAL FUND"]
[{"$nulls":3},"(name of organizational unit - fund)",null,null," "]
[null,"Historical Data",null,null,"REQUIREMENTS DESCRIPTION","Budget For Next Year 2020-2021"]
[null,"Actual",null,"Adopted Budget"]
[null,"Second Preceding","First Preceding","This Year",null,"Proprosed By","Approved By","Adopted By"]
[null,"Year '17-'18","Year '18-'19","19-20",null,"Budget Officer","Budget Committee","Governing Body"]
[{"$nulls":4},"PERSONAL SERVICES"]
[1,17000,12157,18000,"1      RECORDER/ASSISTANT",{"$f":"'LB-31 Admin Fund Req'!J9","v":18000},18000,18000,1]
[2,7500,2386,7500,"2     SUMMER TEMPORARY HELP",{"$f":"'LB-31 Admin Fund Req'!J10","v":7500},7500,7500,2]
[3,2450,2065,2500,"3     PAYROLL TAXES",{"$f":"'LB-31 Admin Fund Req'!J11","v":2500},2500,2500,3]
[4,5400,1784,5200,"4     BENEFITS",{"$f":"'LB-31 Admin Fund Req'!J12","v":8400},8400,8400,4]
[5,{"$nulls":3},5,{"$nulls":3},5]
[6,{"$nulls":3},6,{"$nulls":3},6]
[7,{"$f":"SUM(B10:B15)","v":32350},{"$f":"SUM(C10:C15)","v":18392},{"$f":"SUM(D10:D15)","v":33200},"7  TOTAL PERSONAL SERVICES",{"$f":"SUM(F10:F15)","v":36400},{"$f":"SUM(G10:G15)","v":36400},{"$f":"SUM(H10:H15)","v":36400},7]
[" ",{"$nulls":3},"MATERIALS AND SERVICES",{"$nulls":3}," "]
[8,{"$nulls":3},8,{"$nulls":3},8]
[9,7500,7500,7500,"9     MATERIALS & SUPPLIES",{"$f":"SUM('LB-31 Admin Fund Req'!J14:J16)","v":7500},7500,7500,9]
[10,{"$nulls":3},10,{"$nulls":3},10]
[11,35250,35250,40050,"11    CONTRACTUAL SERVICES",41050,41050,41050,11]
[12,{"$nulls":3},12,{"$nulls":3},12]
[13,{"$nulls":3},13,{"$nulls":3},13]
[14,{"$f":"SUM(B18:B23)","v":42750},25569,{"$f":"SUM(D18:D23)","v":47550},"14  TOTAL MATERIALS AND SERVICES",{"$f":"SUM(F18:F23)","v":48550},{"$f":"SUM(G18:G23)","v":48550},{"$f":"SUM(H18:H23)","v":48550},14]
[" ",{"$nulls":3},"CAPITAL OUTLAY"]
[15,5000,0,5000,"15    CITY HALL IMPROVEMENTS",{"$f":"'LB-31 Admin Fund Req'!J35","v":5000},5000,5000,15]
[16,1000,0,2000,"16    NEW OFFICE EQUIPMENT",{"$f":"'LB-31 Admin Fund Req'!J36","v":2000},2000,2000,16]
[17,{"$nulls":3},17,{"$nulls":3},17]
[18,{"$nulls":3},18,{"$nulls":3},18]
[19,{"$nulls":3},19,{"$nulls":3},19]
[20,{"$f":"SUM(B26:B30)","v":6000},{"$f":"SUM(C26:C30)","v":0},{"$f":"SUM(D26:D30)","v":7000},"20  TOTAL CAPITAL OUTLAY",{"$f":"SUM(F26:F30)","v":7000},{"$f":"SUM(G26:G30)","v":7000},{"$f":"SUM(H26:H30)","v":7000},20]
[" ",{"$nulls":3},"TRANSFERRED TO OTHER FUNDS",{"$nulls":3}," "]
[21,7000,7000,0,"21    TRANSFER TO LIBRARY FUND",{"$f":"'LB-31 Admin Fund Req'!J38","v":10000},10000,10000,21]
[22,{"$nulls":3},"22    TRANSFER TO CITY EQUIPMENT FUND",{"$f":"'LB-31 Admin Fund Req'!J39","v":0},0,0,22]
[23,{"$nulls":3},"23    TRANSFER TO PARK RECREATIONAL ",{"$f":"'LB-31 Admin Fund Req'!J37","v":0},0,0,23]
[24,{"$nulls":3},"24    TRANSFER TO CAPITAL OUTLAY FUND",{"$f":"'LB-31 Admin Fund Req'!J40","v":0},0,0,24]
[25,{"$f":"SUM(B33:B36)","v":7000},{"$f":"SUM(C33:C36)","v":7000},0,"25  TOTAL TRANSFERS",10000,{"$f":"SUM(G33:G36)","v":10000},{"$f":"SUM(H33:H36)","v":10000},25]
[26,{"$nulls":3},"26  OPERATING CONTINGENCY",{"$nulls":3},26]
[27,{"$nulls":3},"27   Ending balance (prior years)",{"$nulls":3},27]
[28,{"$nulls":3},"28  UNAPPROPRIATED ENDING FUND BALANCE",0,null,null,28]
[29,88100,88100,87750,"29        TOTAL REQUIREMENTS",{"$f":"+F16+F24+F31+F37+F38+F39+F40","v":101950},{"$f":"+G16+G24+G31+G37+G38+G39+G40","v":101950},{"$f":"+H16+H24+H31+H37+H38+H39+H40","v":101950},29]
[null,"150-504-030  (Rev 12/09)"]

{"sheet":"LB-31 Admin Fund Req","index":7,"n_rows":44,"n_cols":13,"rows_kept":44,"merged":[[0,1,0,3],[0,4,0,6],[0,7,0,12],[1,1,1,3],[1,4,1,6],[1,7,1,12],[2,1,2,3],[2,4,2,6],[2,7,2,12],[3,1,3,3],[3,4,3,6],[3,7,3,12],[4,0,7,0],[4,1,4,3],[4,4,7,6],[4,7,7,7],[4,8,7,8],[4,9,5,11],[4,12,7,12],[5,1,5,2],[8,4,8,6],[9,4,9,6],[10,4,10,6],[11,4,11,6],[12,4,12,6],[13,4,13,6],[14,4,14,6],[15,4,15,6],[17,4,17,6],[18,4,18,6],[19,4,19,6],[20,4,20,6],[21,4,21,6],[22,4,22,6],[23,4,23,6],[24,4,24,6],[25,4,25,6],[26,4,26,6],[27,4,27,6],[28,4,28,6],[29,4,29,6],[30,4,30,6],[31,4,31,6],[32,4,32,6],[34,4,34,6],[35,4,35,6],[36,4,36,6],[37,4,37,6],[38,4,38,6],[40,4,40,6],[41,4,41,6],[42,4,42,6]]}
[{"$nulls":4},"DETAILED REQUIREMENTS"]
[null,"FORM"]
[null,"LB-31",null,null,"CITY OF ADAMS-ADMIN-GENERAL FUND",null,null," "]
[{"$nulls":4},"(Name of Organizational Unit - Fund)"]
[null,"Historical Data",null,null,"REQUIREMENTS DESCRIPTION",null,null,"Number of Employ-ees","Range*","Budget for Next Year 2020-2021"]
[null,"Actual",null,"Adopted Budget"]
[null,"Second Preceding","First Preceding","This Year",{"$nulls":5},"Proposed by","Approved by","Adopted by"]
[null,"Year '17-'18","Year '18-'19","19-'20",{"$nulls":5},"Budget Officer","Budget Committee","Governing Body"]
[1,17000,12157,18000,"1     RECORDER/ASSISTANT",null,null,0.5,null,18000,18000,18000,1]
[2,7500,2387,7500,"2    TEMPORARY SUMMER HELP",null,null,0.25,null,7500,7500,7500,2]
[3,2450,2065,2500,"3     PAYROLL TAXES",{"$nulls":4},2500,2500,2500,3]
[4,5400,1785,5200,"4     BENEFITS",{"$nulls":4},8400,8400,8400,4]
[5,{"$nulls":3},5,{"$nulls":7},5]
[6,2000,444,2000,"6     CITY HALL MAINTENANCE",{"$nulls":4},2000,2000,2000,6]
[7,500,500,500,"7     MISCELLANEOUS",{"$nulls":4},500,500,500,7]
[8,5000,5009,5000,"8     OFFICE EXPENDITURES",{"$nulls":4},5000,5000,5000,8]
[{"$nulls":4},9]
[10,2500,2200,2800,"10    COMMUNICATIONS",{"$nulls":4},2800,2800,2800,10]
[11,350,310,400,"11    LEAGUE OF OREGON CITIES",{"$nulls":4},400,400,400,11]
[12,1200,1379,1300,"12    PUBLISHING",{"$nulls":4},1300,1300,1300,12]
[13,2500,90,2500,"13    LAWYER'S FEE/COURT",{"$nulls":4},2500,2500,2500,13]
[14,2500,2105,2800,"14    P.P. & L. (ELECTRICITY)",{"$nulls":4},2800,2800,2800,14]
[15,3500,1860,4000,"15    INSURANCE",{"$nulls":4},4000,4000,4000,15]
[16,9000,8950,9500,"16    AUDIT & FILING FEE",{"$nulls":4},9500,9500,9500,16]
[17,250,208,250,"17    POST OFFICE BOX RENT",{"$nulls":4},250,250,250,17]
[18,100,45,100,"18    SAFE DEPOSIT BOX RENT",{"$nulls":4},100,100,100,18]
[19,1000,1115,1000,"19    MISCELLANEOUS PLANNING",{"$nulls":4},1000,1000,1000,19]
[20,850,796,900,"20    EMPLOYEE TRAVEL",{"$nulls":4},900,900,900,20]
[22,500,665,1000,"21   EMPLOYEE TRAINING",{"$nulls":4},1000,1000,1000,22]
[23,1000,0,1500,"22    SAFETY, HEALTH, WELLNESS",{"$nulls":4},1500,1500,1500,23]
[24,10000,682,10000,"23   CODE ENFORCEMENT",{"$nulls":4},10000,10000,10000,24]
[25,null,null,2000,"24   COMMUNITY OUTREACH",{"$nulls":4},2000,2000,2000,25]
[26,{"$nulls":3},"25   EASTERN OREGON TELECOM",{"$nulls":4},1000,1000,1000,26]
[{"$nulls":4},26]
[27,5000,0,5000,"27    CITY HALL IMPROVEMENTS",{"$nulls":4},5000,5000,5000,27]
[28,1000,0,2000,"28    NEW OFFICE EQUIPMENT",{"$nulls":4},2000,2000,2000,28]
[29,{"$nulls":3},"29    TRANSFER TO PARK RECREATIONAL CAPITAL FUND",{"$nulls":7},29]
[30,7000,7000,0,"30    TRANSFER TO LIBRARY FUND",{"$nulls":4},10000,10000,10000,30]
[31,{"$nulls":3},"31    TRANSFER TO CITY EQUIPMENT FUND",{"$nulls":7},31]
[32,{"$nulls":3},"32    TRANSFER TO CAPITAL OUTLAY FUND",{"$nulls":7},32]
[33,{"$nulls":3},"33    Ending balance (prior years)",{"$nulls":7},33]
[34,{"$nulls":3},"34    UNAPPROPRIATED ENDING FUND BALANCE",{"$nulls":4},0,0,0,34]
[35,{"$f":"SUM(B9:B41)","v":88100},{"$f":"SUM(C9:C41)","v":51752},{"$f":"SUM(D9:D41)","v":87750},"35    TOTAL REQUIREMENTS",{"$nulls":4},{"$f":"SUM(J9:J42)","v":101950},{"$f":"SUM(K9:K42)","v":101950},{"$f":"SUM(L9:L42)","v":101950},35]
[null,"150-504-031  (Rev 12/09)"]

{"sheet":"LB-30 Park Req","index":8,"n_rows":42,"n_cols":9,"rows_kept":42,"merged":[[0,3,0,5],[1,3,1,5],[2,3,2,5],[3,3,3,5],[3,6,3,8],[4,0,7,0],[4,1,4,3],[4,4,7,4],[4,5,5,7],[4,8,7,8],[5,1,5,2],[8,1,8,3],[8,5,8,7],[16,1,16,3],[16,5,16,7],[24,1,24,3],[24,5,24,7],[32,1,32,3],[32,5,32,7]]}
[{"$nulls":3},"REQUIREMENTS SUMMARY"]
[null,"FORM",null,"BY FUND, ORGANIZATIONAL UNIT OR PROGRAM"]
[null,"LB-30",null,"CITY OF ADAMS-PARK-GENERAL FUND"]
[{"$nulls":3},"(name of organizational unit - fund)",null,null," "]
[null,"Historical Data",null,null,"REQUIREMENTS DESCRIPTION","Budget For Next Year 2020-2021"]
[null,"Actual",null,"Adopted Budget"]
[null,"Second Preceding","First Preceding","This Year",null,"Proprosed By","Approved By","Adopted By"]
[null,"Year '17-'18","Year '18-'19",";19-'20",null,"Budget Officer","Budget Committee","Governing Body"]
[{"$nulls":4},"PERSONAL SERVICES"]
[1,12000,8013,12000,"1      PARK ATTENDANT",{"$f":"'LB-31 Park D Req'!J9","v":12000},12000,12000,1]
[2,1200,694,1200,"2     PAYROLL TAXES",{"$f":"'LB-31 Park D Req'!J10","v":1200},1200,1200,2]
[3,2100,1386,2400,"3     BENEFITS",{"$f":"'LB-31 Park D Req'!J11","v":2400},2400,2400,3]
[4,{"$nulls":3},4,{"$nulls":3},4]
[5,{"$nulls":3},5,{"$nulls":3},5]
[6,{"$nulls":3},6,{"$nulls":3},6]
[7,{"$f":"SUM(B10:B15)","v":15300},{"$f":"SUM(C10:C15)","v":10093},{"$f":"SUM(D10:D15)","v":15600},"7  TOTAL PERSONAL SERVICES",{"$f":"SUM(F10:F15)","v":15600},{"$f":"SUM(G10:G15)","v":15600},{"$f":"SUM(H10:H15)","v":15600},7]
[" ",{"$nulls":3},"MATERIALS AND SERVICES",{"$nulls":3}," "]
[8,{"$nulls":3},8,{"$nulls":3},8]
[9,3750,3750,3750,"9     MATERIALS & SUPPLIES",{"$f":"SUM('LB-31 Park D Req'!J13:J15)","v":3750},3750,3750,9]
[10,{"$nulls":3},10,{"$nulls":3},10]
[11,4250,4250,4500,"11    CONTRACTUAL SERVICES",{"$f":"SUM('LB-31 Park D Req'!J17+'LB-31 Park D Req'!J19)","v":4500},4500,4500,11]
[12,{"$nulls":3},12,{"$nulls":3},12]
[13,3000,3000,3000,"13    PARK EQUIPMENT",3000,3000,3000,13]
[14,{"$f":"SUM(B18:B23)","v":11000},{"$f":"SUM(C18:C23)","v":11000},{"$f":"SUM(D18:D23)","v":11250},"14  TOTAL MATERIALS AND SERVICES",{"$f":"SUM(F18:F23)","v":11250},{"$f":"SUM(G18:G23)","v":11250},{"$f":"SUM(H18:H23)","v":11250},14]
[" ",{"$nulls":3},"CAPITAL OUTLAY"]
[15,{"$nulls":3},15,{"$nulls":3},15]
[16,0,0,0,"16    PARK IMPROVEMENT",{"$f":"'LB-31 Park D Req'!J25","v":0},0,0,16]
[17," ",null,null,17,{"$nulls":3},17]
[18,{"$nulls":3},18,{"$nulls":3},18]
[19,{"$nulls":3},19,{"$nulls":3},19]
[20,{"$nulls":3},20,{"$nulls":3},20]
[21,{"$f":"SUM(B26:B31)","v":0},{"$f":"SUM(C26:C31)","v":0},{"$f":"SUM(D26:D31)","v":0},"21  TOTAL CAPITAL OUTLAY",{"$f":"SUM(F26:F31)","v":0},{"$f":"SUM(G26:G31)","v":0},{"$f":"SUM(H26:H31)","v":0},21]
[" ",{"$nulls":3},"TRANSFERRED TO OTHER FUNDS",{"$nulls":3}," "]
[22,{"$nulls":3},22,{"$nulls":3},22]
[23,{"$nulls":3},"23    CAPITAL OUTLAY FUND",{"$nulls":3},23]
[24,{"$nulls":3},24,{"$nulls":3},24]
[25,{"$f":"SUM(B34:B36)","v":0},{"$f":"SUM(C34:C36)","v":0},{"$f":"SUM(D34:D36)","v":0},"25  TOTAL TRANSFERS",{"$f":"SUM(F34:F36)","v":0},{"$f":"SUM(G34:G36)","v":0},{"$f":"SUM(H34:H36)","v":0},25]
[{"$nulls":4},"26  OPERATING CONTINGENCY"]
[26,{"$nulls":3},"27   Ending balance (prior years)",{"$nulls":3},26]
[27,{"$nulls":3},"28  UNAPPROPRIATED ENDING FUND BALANCE",{"$nulls":3},27]
[28,{"$f":"+B16+B24+B32+B37+B39","v":26300},{"$f":"+C16+C24+C32+C37+C39+C40","v":21093},{"$f":"+D16+D24+D32+D37+D38+D39+D40","v":26850},"29        TOTAL REQUIREMENTS",{"$f":"+F16+F24+F32+F37+F38+F39+F40","v":26850},{"$f":"+G16+G24+G32+G37+G38+G39+G40","v":26850},{"$f":"+H16+H24+H32+H37+H38+H39+H40","v":26850},28]
[null,"150-504-030  (Rev 12/09)"]

{"sheet":"LB-31 Park D Req","index":9,"n_rows":42,"n_cols":13,"rows_kept":42,"merged":[[0,1,0,3],[0,4,0,6],[0,7,0,12],[1,1,1,3],[1,4,1,6],[1,7,1,12],[2,1,2,3],[2,4,2,6],[2,7,2,12],[3,1,3,3],[3,4,3,6],[3,7,3,12],[4,0,7,0],[4,1,4,3],[4,4,7,6],[4,7,7,7],[4,8,7,8],[4,9,5,11],[4,12,7,12],[5,1,5,2],[8,4,8,6],[9,4,9,6],[10,4,10,6],[11,4,11,6],[12,4,12,6],[13,4,13,6],[14,4,14,6],[15,4,15,6],[16,4,16,6],[17,4,17,6],[18,4,18,6],[19,4,19,6],[20,4,20,6],[21,4,21,6],[22,4,22,6],[23,4,23,6],[24,4,24,6],[25,4,25,6],[26,4,26,6],[27,4,27,6],[28,4,28,6],[29,4,29,6],[30,4,30,6],[31,4,31,6],[32,4,32,6],[33,4,33,6],[34,4,34,6],[35,4,35,6],[36,4,36,6],[37,4,37,6],[38,4,38,6],[39,4,39,6],[40,4,40,6]]}
[{"$nulls":4},"DETAILED REQUIREMENTS"]
[null,"FORM"]
[null,"LB-31",null,null,"CITY OF ADAMS-PARK-GENERAL FUND",null,null," "]
[{"$nulls":4},"(Name of Organizational Unit - Fund)"]
[null,"Historical Data",null,null,"REQUIREMENTS DESCRIPTION",null,null,"Number of Employ-ees","Range*","Budget for Next Year 2020-2021"]
[null,"Actual",null,"Adopted Budget"]
[null,"Second Preceding","First Preceding","This Year",{"$nulls":5},"Proposed by","Approved by","Adopted by"]
[null,"Year '17-'18","Year '18-'19","19-'20",{"$nulls":5},"Budget Officer","Budget Committee","Governing Body"]
[1,12000,8013,12000,"1     PARK ATTENDANT",null,null,0.25,null,12000,12000,12000,1]
[2,1200,694,1200,"2     PAYROLL TAXES",{"$nulls":4},1200,1200,1200,2]
[3,2100,1386,2400,"3     BENEFITS",{"$nulls":4},2400,2400,2400,3]
[4,{"$nulls":3},4,{"$nulls":7},4]
[5,250,225,250,"5     MISCELLANEOUS",{"$nulls":4},250,250,250,5]
[6,500,478,500,"6     FUEL & OIL",{"$nulls":4},500,500,500,6]
[7,3000,1321,3000,"7     OPERATING MATERIALS & SUPPLIES",{"$nulls":4},3000,3000,3000,7]
[8,{"$nulls":3},8,{"$nulls":7},8]
[9,3500,637,3500,"9     CONTRACTUAL SERVICES",{"$nulls":4},3500,3500,3500,9]
[10,0,0,0,"10    WATER (LL, PARK, RR, SHED)",{"$nulls":4},0,0,0,10]
[11,750,285,1000,"11    EQUIPMENT MAINTENANCE",{"$nulls":4},1000,1000,1000,11]
[12,{"$nulls":3},12,{"$nulls":7},12]
[13,3000,0,3000,"13    PARK EQUIPMENT REPAIR",{"$nulls":4},3000,3000,3000,13]
[14,{"$nulls":3},14,{"$nulls":7},14]
[15,{"$nulls":3},"15    TRANSFER TO:",{"$nulls":7},15]
[16,{"$nulls":3},16,{"$nulls":7},16]
[17,0,0,0,"17    CAPITAL OUTLAY FUND",{"$nulls":4},0,0,0,17]
[18,{"$nulls":3},18,{"$nulls":7},18]
[19,{"$nulls":3},19,{"$nulls":7},19]
[20,{"$nulls":3},20,{"$nulls":7},20]
[21,{"$nulls":3},21,{"$nulls":7},21]
[22,{"$nulls":3},22,{"$nulls":7},22]
[23,{"$nulls":3},23,{"$nulls":7},23]
[24,{"$nulls":3},24,{"$nulls":7},24]
[25,{"$nulls":3},25,{"$nulls":7},25]
[26,{"$nulls":3},26,{"$nulls":7},26]
[27,{"$nulls":3},27,{"$nulls":7},27]
[28,{"$nulls":3},28,{"$nulls":7},28]
[29,{"$nulls":3},29,{"$nulls":7},29]
[30,{"$nulls":3},30,{"$nulls":7},30]
[31,{"$nulls":3},"31 Ending balance (prior years)",{"$nulls":7},31]
[32,{"$nulls":3},"32  UNAPPROPRIATED ENDING FUND BALANCE",{"$nulls":7},32]
[33,{"$f":"SUM(B9:B39)","v":26300},{"$f":"SUM(C9:C39)","v":13039},{"$f":"SUM(D9:D40)","v":26850},"33    TOTAL REQUIREMENTS",{"$nulls":4},{"$f":"SUM(J9:J40)","v":26850},{"$f":"SUM(K9:K40)","v":26850},{"$f":"SUM(L9:L40)","v":26850},33]
[null,"150-504-031  (Rev 12/09)"]

{"sheet":"LB-20 Water","index":10,"n_rows":41,"n_cols":9,"rows_kept":41,"merged":[[0,1,0,2],[0,6,0,7],[1,1,1,2],[1,5,1,7],[2,1,2,2],[2,5,2,7],[3,0,6,0],[3,1,3,3],[3,4,6,4],[3,5,3,7],[3,8,6,8],[4,1,4,2],[4,5,6,5],[4,6,6,6],[4,7,6,7]]}
[null,"FORM",null,null,"RESOURCES"]
[null,"LB-20",null,null,"WATER","CITY OF ADAMS"]
[{"$nulls":4},"(Fund)","(Name of Municipal Corporation)"]
[null,"Historical Data",null,null,"RESOURCE DESCRIPTION\n","Budget for Next Year 2020-2021"]
[null,"Actual",null,"Adopted Budget",null,"Proposed By\nBudget Officer","Approved By\nBudget Committee","Adopted By\nGoverning Body"]
[null,"Second Preceding","First Preceding","This Year"]
[null,"Year '17-'18","Year '18-'19","19-'20"]
[]
[1,51500,25526,23700,"1.  Available cash on hand* (cash basis) or",39499,39499,39499,1]
[2,{"$nulls":3},"2. Net working capital (accrual basis)",{"$nulls":3},2]
[3,{"$nulls":3},"3. Previously levied taxes estimated to be received",{"$nulls":3},3]
[4,50,16,25,"4. Interest",576,576,576,4]
[5,null,0,0,"5. Transferred IN, from other funds-WATER LOAN",{"$nulls":3},5]
[6,{"$nulls":3},"6                      OTHER RESOURCES",{"$nulls":3},6]
[7,98153,92683,105000,"7     WATER SALES / DELIVERY",113000,113000,113000,7]
[8,140,353,100,"8     MISCELLANEOUS",100,100,100,8]
[9,871,1622,1500,"9     USER FEES",1500,1500,1500,9]
[10,0,0,1000,"10    WATER METERS",1000,1000,1000,10]
[11,856,1001,1500,"11    CHECK VALVE FEES",1500,1500,1500,11]
[12,2080,2879,2500,"12    LATE FEES",2500,2500,2500,12]
[13,{"$nulls":3},13,{"$nulls":3},13]
[14,{"$nulls":3},14,{"$nulls":3},14]
[15,{"$nulls":3},15,{"$nulls":3},15]
[16,{"$nulls":3},16,{"$nulls":3},16]
[17,{"$nulls":3},17,{"$nulls":3},17]
[18,{"$nulls":3},18,{"$nulls":3},18]
[19,{"$nulls":3},19,{"$nulls":3},19]
[20,{"$nulls":3},20,{"$nulls":3},20]
[21,{"$nulls":3},21,{"$nulls":3},21]
[22,{"$nulls":3},22,{"$nulls":3},22]
[23,{"$nulls":3},23,{"$nulls":3},23]
[24,{"$nulls":3},24,{"$nulls":3},24]
[25,{"$nulls":3},25,{"$nulls":3},25]
[26,{"$nulls":3},26,{"$nulls":3},26]
[27,{"$nulls":3},27,{"$nulls":3},27]
[28,null,null," ",28,{"$nulls":3},28]
[29,183150,98554,{"$f":"SUM(D9:D36)","v":135325},"29. Total resources, except taxes to be levied",{"$f":"SUM(F9:F36)","v":159675},{"$f":"SUM(G9:G36)","v":159675},{"$f":"SUM(H9:H36)","v":159675},29]
[30,{"$nulls":3},"30. Taxes estimated to be received",{"$nulls":3},30]
[31,{"$nulls":3},"31. Taxes collected in year levied",{"$nulls":3},31]
[32,{"$f":"B37+B39","v":183150},{"$f":"C37+C39","v":98554},{"$f":"D37+D38","v":135325},"32.  TOTAL RESOURCES",{"$f":"F37+F38","v":159675},{"$f":"G37+G38","v":159675},{"$f":"H37+H38","v":159675},32]
[{"$nulls":4},"*Includes ending balance from prior year",{"$f":"IF(NOT(F40='LB-30 Water Req'!F41),\"RESOURCES <> REQUIREMENTS\", \"\")","v":""}]

{"sheet":"LB-30 Water Req","index":11,"n_rows":42,"n_cols":9,"rows_kept":42,"merged":[[0,3,0,5],[1,3,1,5],[2,3,2,5],[3,3,3,5],[3,6,3,8],[4,0,7,0],[4,1,4,3],[4,4,7,4],[4,5,5,7],[4,8,7,8],[5,1,5,2],[8,1,8,3],[8,5,8,7],[16,1,16,3],[16,5,16,7],[24,1,24,3],[24,5,24,7],[32,1,32,3],[32,5,32,7]]}
[{"$nulls":3},"REQUIREMENTS SUMMARY"]
[null,"FORM",null,"BY FUND, ORGANIZATIONAL UNIT OR PROGRAM"]
[null,"LB-30",null,"CITY OF ADAMS-WATER-WATER"]
[{"$nulls":3},"(name of organizational unit - fund)",null,null," "]
[null,"Historical Data",null,null,"REQUIREMENTS DESCRIPTION","Budget For Next Year 2020-2021"]
[null,"Actual",null,"Adopted Budget"]
[null,"Second Preceding","First Preceding","This Year",null,"Proprosed By","Approved By","Adopted By"]
[null,"Year '17-'18","Year '18-'19","19-'20",null,"Budget Officer","Budget Committee","Governing Body"]
[{"$nulls":4},"PERSONAL SERVICES"]
[1,19000,12686,19000,"1     WATER CLERK/ASSISTANT",{"$f":"'LB-31 Water D Req'!J9","v":19000},19000,19000,1]
[2,20800,21895,22000,"2     WATER LABORER",{"$f":"'LB-31 Water D Req'!J10","v":22000},22000,25000,2]
[3,3900,3230,4100,"3     PAYROLL TAXES",{"$f":"'LB-31 Water D Req'!J11","v":4100},4100,4100,3]
[4,7500,3983,8000,"4     BENEFITS",{"$f":"'LB-31 Water D Req'!J12","v":8000},8000,8000,4]
[5,{"$nulls":3},5,{"$nulls":3},5]
[6,{"$nulls":3},6,{"$nulls":3},6]
[7,{"$f":"SUM(B10:B15)","v":51200},{"$f":"SUM(C10:C15)","v":41794},{"$f":"SUM(D10:D15)","v":53100},"7  TOTAL PERSONAL SERVICES",{"$f":"SUM(F10:F15)","v":53100},{"$f":"SUM(G10:G15)","v":53100},{"$f":"SUM(H10:H15)","v":56100},7]
[" ",{"$nulls":3},"MATERIALS AND SERVICES",{"$nulls":3}," "]
[8,8000,8000,6250,"8     MATERIALS & SUPPLIES",{"$f":"SUM('LB-31 Water D Req'!J14:J17)","v":6250},6250,6250,8]
[9,{"$nulls":3},9,{"$nulls":3},9]
[10,26200,3312,27300,"10    CONTRACTUAL SERVICES",{"$f":"SUM('LB-31 Water D Req'!J19:J25)","v":31800},31800,31800,10]
[11,{"$nulls":3},11,{"$nulls":3},11]
[12,45000,21113,21500,"12    DEBT SERVICE",{"$f":"SUM('LB-31 Water D Req'!J27:J28)","v":22500},22500,22500,12]
[13,{"$nulls":3},13,{"$nulls":3},13]
[14,{"$f":"SUM(B18:B23)","v":79200},45758,{"$f":"SUM(D18:D23)","v":55050},"14  TOTAL MATERIALS AND SERVICES",{"$f":"SUM(F18:F23)","v":60550},{"$f":"SUM(G18:G23)","v":60550},{"$f":"SUM(H18:H23)","v":60550},14]
[" ",{"$nulls":3},"CAPITAL OUTLAY"]
[15,2000,0,2000,"15    WATER METERS",{"$f":"'LB-31 Water D Req'!J30","v":2000},2000,2000,15]
[16,500,0,500,"16    TOOLS",{"$f":"'LB-31 Water D Req'!J31","v":500},500,500,16]
[17,5000,1377,4500,"17    SYSTEM IMPROVEMENTS",{"$f":"'LB-31 Water D Req'!J32","v":4500},4500,4500,17]
[18,5000,0,4500,"18    SYSTEM MAINTENANCE",{"$f":"'LB-31 Water D Req'!J33","v":4500},4500,4500,18]
[19,7000,7000,7000,"19    FEES IN LIEU OF FRANCHISE FEE GEN FUND",{"$f":"'LB-31 Water D Req'!J34","v":7000},7000,7000,19]
[20,{"$nulls":3},20,{"$nulls":3},20]
[21,{"$f":"SUM(B26:B31)","v":19500},{"$f":"SUM(C26:C31)","v":8377},{"$f":"SUM(D26:D31)","v":18500},"21  TOTAL CAPITAL OUTLAY",{"$f":"SUM(F26:F31)","v":18500},{"$f":"SUM(G26:G31)","v":18500},{"$f":"SUM(H26:H31)","v":18500},21]
[" ",{"$nulls":3},"TRANSFERRED TO OTHER FUNDS",{"$nulls":3}," "]
[22,4000,4000,null,"22    RESERVE LOAN FUND",{"$f":"'LB-31 Water D Req'!$J$35","v":0},0,0,22]
[23,5000,5000,null,"23    SYSTEM REPLACEMENT FUND",{"$f":"'LB-31 Water D Req'!$J$36","v":0},0,0,23]
[24,10000,10000,0,"24     CAPITAL OUTLAY FUND",{"$f":"'LB-31 Water D Req'!$J$37","v":0},0,0,24]
[25,{"$f":"SUM(B34:B36)","v":19000},{"$f":"SUM(C34:C36)","v":19000},{"$f":"SUM(D34:D36)","v":0},"25  TOTAL TRANSFERS",{"$f":"SUM(F34:F36)","v":0},0,0,25]
[null,null,14250,8675,"26  OPERATING CONTINGENCY",27525,27525,24525]
[26,0,null,null,"27  Ending balance (prior years)",{"$nulls":3},26]
[27,{"$nulls":4},0,null,null,27]
[28,{"$f":"+B16+B24+B32+B37+B39","v":168900},183150,{"$f":"+D16+D24+D32+D37+D38+D39+D40","v":135325},"29        TOTAL REQUIREMENTS",{"$f":"+F16+F24+F32+F37+F38+F39+F40","v":159675},{"$f":"+G16+G24+G32+G37+G38+G39+G40","v":159675},{"$f":"+H16+H24+H32+H37+H38+H39+H40","v":159675},28]
[null,"150-504-030  (Rev 12/09)",{"$nulls":3},{"$f":"IF(NOT(F41='LB-20 Water'!F40),\"RESOURCES <> REQUIREMENTS\", \"\")","v":""}]

{"sheet":"LB-31 Water D Req","index":12,"n_rows":42,"n_cols":13,"rows_kept":42,"merged":[[0,1,0,3],[0,4,0,6],[0,7,0,12],[1,1,1,3],[1,4,1,6],[1,7,1,12],[2,1,2,3],[2,4,2,6],[2,7,2,12],[3,1,3,3],[3,4,3,6],[3,7,3,12],[4,0,7,0],[4,1,4,3],[4,4,7,6],[4,7,7,7],[4,8,7,8],[4,9,5,11],[4,12,7,12],[5,1,5,2],[8,4,8,6],[9,4,9,6],[10,4,10,6],[11,4,11,6],[12,4,12,6],[13,4,13,6],[14,4,14,6],[15,4,15,6],[16,4,16,6],[17,4,17,6],[18,4,18,6],[19,4,19,6],[20,4,20,6],[21,4,21,6],[22,4,22,6],[23,4,23,6],[24,4,24,6],[25,4,25,6],[26,4,26,6],[27,4,27,6],[28,4,28,6],[29,4,29,6],[30,4,30,6],[31,4,31,6],[32,4,32,6],[33,4,33,6],[34,4,34,6],[35,4,35,6],[36,4,36,6],[37,4,37,6],[38,4,38,6],[39,4,39,6],[40,4,40,6]]}
[{"$nulls":4},"DETAILED REQUIREMENTS"]
[null,"FORM"]
[null,"LB-31",null,null,"CITY OF ADAMS-WATER-WATER",null,null," "]
[{"$nulls":4},"(Name of Organizational Unit - Fund)"]
[null,"Historical Data",null,null,"REQUIREMENTS DESCRIPTION",null,null,"Number of Employ-ees","Range*","Budget for Next Year 2020-2021"]
[null,"Actual",null,"Adopted Budget"]
[null,"Second Preceding","First Preceding","This Year",{"$nulls":5},"Proposed by","Approved by","Adopted by"]
[null,"Year '17-'18","Year '18-'19","19-'20",{"$nulls":5},"Budget Officer","Budget Committee","Governing Body"]
[1,19000,12686,19000,"1     WATER CLERK/ASSISTANT",null,null,0.5,null,19000,19000,19000,1]
[2,20800,21895,22000,"2     WATER LABORER",null,null,0.5,null,22000,22000,25000,2]
[3,3900,3230,4100,"3     PAYROLL TAXES",{"$nulls":4},4100,4100,4100,3]
[4,7500,3981,8000,"4     BENEFITS",{"$nulls":4},8000,8000,8000,4]
[5,{"$nulls":3},5,{"$nulls":7},5]
[6,4500,1789,3000,"6     SUPPLIES",{"$nulls":4},3000,3000,3000,6]
[7,2500,1508,2500,"7     STAMPS & OFFICE SUPPLIES",{"$nulls":4},2500,2500,2500,7]
[8,500,98,250,"8     MISCELLANEOUS",{"$nulls":4},250,250,250,8]
[9,500,481,500,"9     FUEL & OIL",{"$nulls":4},500,500,500,9]
[10,{"$nulls":3},10,{"$nulls":7},10]
[11,2000,2135,2000,"11    WATER QUALITY MONITORING",{"$nulls":4},5000,5000,5000,11]
[12,14000,9918,15000,"12    P. P. & L. (ELECTRICITY)",{"$nulls":4},15000,15000,15000,12]
[13,3000,2950,3000,"13    INSURANCE",{"$nulls":4},3000,3000,3000,13]
[14,3500,3312,3500,"14    CONTRACTUAL SERVICES",{"$nulls":4},5000,5000,5000,14]
[15,1000,0,500,"15    TRAINING",{"$nulls":4},500,500,500,15]
[16,500,203,500,"16    EQUIPMENT MAINTENANCE",{"$nulls":4},500,500,500,16]
[17,2200,2188,2800,"17    COMMUNICATION",{"$nulls":4},2800,2800,2800,17]
[18,{"$nulls":3},18,{"$nulls":7},18]
[19,30000,7567,11500,"19    PRINCIPAL",{"$nulls":4},8500,8500,8500,19]
[20,15000,13545,10000,"20    INTEREST",{"$nulls":4},14000,14000,14000,20]
[21,{"$nulls":3},21,{"$nulls":7},21]
[22,2000,0,2000,"22    WATER METERS",{"$nulls":4},2000,2000,2000,22]
[23,500,0,500,"23    TOOLS",{"$nulls":4},500,500,500,23]
[24,5000,1377,4500,"24    SYSTEM IMPROVEMENTS",{"$nulls":4},4500,4500,4500,24]
[25,5000,0,4500,"25    SYSTEM MAINTENANCE",{"$nulls":4},4500,4500,4500,25]
[26,7000,7000,7000,"26    FEES IN LIEU OF FRANCHISE FEE TO GENERAL FUND",{"$nulls":4},7000,7000,7000,26]
[27,4000,4000,0,"27    TRANSFER TO RESERVE LOAN FUND",{"$nulls":7},27]
[28,5000,5000,0,"28    TRANSFER TO SYSTEM REPLACEMENT FUND",{"$nulls":7},28]
[29,10000,10000,0,"29    TRANSFER TO CAPITAL OUTLAY FUND",{"$nulls":7},29]
[30,14250,14250,8675,"30     CONTINGENCY",{"$nulls":4},27525,27525,24525,30]
[31,0,null,null,"31   Ending balance (prior years)",{"$nulls":7},31]
[32,{"$nulls":3},"32  UNAPPROPRIATED ENDING FUND BALANCE",{"$nulls":4},0,null,null,32]
[33,{"$f":"SUM(B9:B40)","v":183150},{"$f":"SUM(C9:C40)","v":129113},{"$f":"SUM(D9:D40)","v":135325},"33    TOTAL REQUIREMENTS",{"$nulls":4},{"$f":"SUM(J9:J40)","v":159675},{"$f":"SUM(K9:K40)","v":159675},{"$f":"SUM(L9:L40)","v":159675},33]
[null,"150-504-031  (Rev 12/09)"]

{"sheet":"LB-20 State Street","index":13,"n_rows":41,"n_cols":9,"rows_kept":41,"merged":[[0,1,0,2],[0,6,0,7],[1,1,1,2],[1,5,1,7],[2,1,2,2],[2,5,2,7],[3,0,6,0],[3,1,3,3],[3,4,6,4],[3,5,3,7],[3,8,6,8],[4,1,4,2],[4,5,6,5],[4,6,6,6],[4,7,6,7]]}
[null,"FORM",null,null,"RESOURCES"]
[null,"LB-20",null,null,"GAS TAX","CITY OF ADAMS"]
[{"$nulls":4},"(Fund)","(Name of Municipal Corporation)"]
[null,"Historical Data",null,null,"RESOURCE DESCRIPTION\n","Budget for Next Year 2020-2021"]
[null,"Actual",null,"Adopted Budget",null,"Proposed By\nBudget Officer","Approved By\nBudget Committee","Adopted By\nGoverning Body"]
[null,"Second Preceding","First Preceding","This Year"]
[null,"Year '17-'18","Year '18-'19","19-'20"]
[]
[1,21500,18370,28500,"1. Available cash on hand* (cash basis) or",44713,44713,44713,1]
[2,{"$nulls":3},"2. Net working capital (accrual basis)",{"$nulls":3},2]
[3,{"$nulls":3},"3. Previously levied taxes estimated to be received",{"$nulls":3},3]
[4,20,7,15,"4. Interest",700,700,700,4]
[5,7000,7000,7000,"5. Transferred IN, from other funds-GENERAL",7000,7000,7000,5]
[6,{"$nulls":3},"6                      OTHER RESOURCES",{"$nulls":3},6]
[7,{"$nulls":3},7,{"$nulls":3},7]
[8,24200,27312,29500,"8     STATE GAS TAXES",25000,25000,25000,8]
[9,50000,0,50000,"9     SMALL CITY GRANT",0,0,0,9]
[10,200,0,200,"10    MISCELLANEOUS",18200,18200,18200,10]
[11,9300,9268,9300,"11     P. P. & L. FRANCHISE",9300,9300,9300,11]
[12,{"$nulls":3},12,{"$nulls":3},12]
[13,{"$nulls":3},13,{"$nulls":3},13]
[14,{"$nulls":3},14,{"$nulls":3},14]
[15,{"$nulls":3},15,{"$nulls":3},15]
[16,{"$nulls":3},16,{"$nulls":3},16]
[17,{"$nulls":3},17,{"$nulls":3},17]
[18,{"$nulls":3},18,{"$nulls":3},18]
[19,{"$nulls":3},19,{"$nulls":3},19]
[20,{"$nulls":3},20,{"$nulls":3},20]
[21,{"$nulls":3},21,{"$nulls":3},21]
[22,{"$nulls":3},22,{"$nulls":3},22]
[23,{"$nulls":3},23,{"$nulls":3},23]
[24,{"$nulls":3},24,{"$nulls":3},24]
[25,{"$nulls":3},25,{"$nulls":3},25]
[26,{"$nulls":3},26,{"$nulls":3},26]
[27,{"$nulls":3},27,{"$nulls":3},27]
[28,null," ",null,28,{"$nulls":3},28]
[29,{"$f":"SUM(B9:B23)","v":112220},36587,{"$f":"SUM(D9:D36)","v":124515},"29. Total resources, except taxes to be levied",{"$f":"SUM(F9:F36)","v":104913},{"$f":"SUM(G9:G36)","v":104913},{"$f":"SUM(H9:H36)","v":104913},29]
[30,{"$nulls":3},"30. Taxes estimated to be received",{"$nulls":3},30]
[31,{"$nulls":3},"31. Taxes collected in year levied",{"$nulls":3},31]
[32,{"$f":"B37+B39","v":112220},{"$f":"C37+C39","v":36587},{"$f":"D37+D38","v":124515},"32.  TOTAL RESOURCES",{"$f":"F37+F38","v":104913},{"$f":"G37+G38","v":104913},{"$f":"H37+H38","v":104913},32]
[{"$nulls":4},"*Includes ending balance from prior year",{"$f":"IF(NOT(F40='LB-30 Streets Req'!F41),\"RESOURCES <> REQUIREMENTS\", \"\")","v":""}]

{"sheet":"LB-30 Streets Req","index":14,"n_rows":42,"n_cols":9,"rows_kept":42,"merged":[[0,3,0,5],[1,3,1,5],[2,3,2,5],[3,3,3,5],[3,6,3,8],[4,0,7,0],[4,1,4,3],[4,4,7,4],[4,5,5,7],[4,8,7,8],[5,1,5,2],[8,1,8,3],[8,5,8,7],[16,1,16,3],[16,5,16,7],[24,1,24,3],[24,5,24,7],[32,1,32,3],[32,5,32,7]]}
[{"$nulls":3},"REQUIREMENTS SUMMARY"]
[null,"FORM",null,"BY FUND, ORGANIZATIONAL UNIT OR PROGRAM"]
[null,"LB-30",null,"CITY OF ADAMS-STREETS-GAS TAX"]
[{"$nulls":3},"(name of organizational unit - fund)",null,null," "]
[null,"Historical Data",null,null,"REQUIREMENTS DESCRIPTION","Budget For Next Year 2020-2021"]
[null,"Actual",null,"Adopted Budget"]
[null,"Second Preceding","First Preceding","This Year",null,"Proprosed By","Approved By","Adopted By"]
[null,"Year '17-'18","Year '18-'19","19-'20",null,"Budget Officer","Budget Committee","Governing Body"]
[{"$nulls":4},"PERSONAL SERVICES"]
[1,13500,10504,14500,"1     MAINTENANCE PERSON",{"$f":"'LB-31 Streets D Req'!J9","v":14500},14500,14500,1]
[2,1350,910,1450,"2     PAYROLL TAXES",{"$f":"'LB-31 Streets D Req'!J10","v":1450},1450,1450,2]
[3,2300,1816,2600,"3     BENEFITS",{"$f":"'LB-31 Streets D Req'!J11","v":2600},2600,2600,3]
[4,{"$nulls":3},4,{"$nulls":3},4]
[5,{"$nulls":3},5,{"$nulls":3},5]
[6,{"$nulls":3},6,{"$nulls":3},6]
[7,{"$f":"SUM(B10:B15)","v":17150},{"$f":"SUM(C10:C15)","v":13230},{"$f":"SUM(D10:D15)","v":18550},"7  TOTAL PERSONAL SERVICES",{"$f":"SUM(F10:F15)","v":18550},{"$f":"SUM(G10:G15)","v":18550},{"$f":"SUM(H10:H15)","v":18550},7]
[" ",{"$nulls":3},"MATERIALS AND SERVICES",{"$nulls":3}," "]
[8,{"$nulls":3},8,{"$nulls":3},8]
[9,4750,10300,4250,"9     MATERIALS & SUPPLIES",{"$f":"SUM('LB-31 Streets D Req'!J13:J15)","v":2750},2750,2750,9]
[10,{"$nulls":3},10,{"$nulls":3},10]
[11,25500,493,27500,"11    CONTRACTUAL SERVICES",37700,37700,37700,11]
[12,{"$nulls":3},12,{"$nulls":3},12]
[13,{"$nulls":3},13,{"$nulls":3},13]
[14,{"$f":"SUM(B18:B23)","v":30250},{"$f":"SUM(C18:C23)","v":10793},{"$f":"SUM(D18:D23)","v":31750},"14  TOTAL MATERIALS AND SERVICES",{"$f":"SUM(F18:F23)","v":40450},{"$f":"SUM(G18:G23)","v":40450},{"$f":"SUM(H18:H23)","v":40450},14]
[" ",{"$nulls":3},"CAPITAL OUTLAY"]
[15,50000,0,50000,"15    STREET IMPROVEMENT",{"$f":"'LB-31 Streets D Req'!$J$26","v":15000},15000,15000,15]
[16,14820,0,24215,"16    BRIDGE IMPROVEMENT",{"$f":"'LB-31 Streets D Req'!$J$27","v":30913},30193,30193,16]
[17,{"$nulls":3},17,{"$nulls":3},17]
[18,{"$nulls":3},"18    CITY EQUIPMENT",{"$nulls":3},18]
[19,{"$nulls":3},19,{"$nulls":3},19]
[20,{"$nulls":3},20,{"$nulls":3},20]
[21,{"$f":"SUM(B26:B31)","v":64820},{"$f":"SUM(C26:C31)","v":0},{"$f":"SUM(D26:D31)","v":74215},"21  TOTAL CAPITAL OUTLAY",45913,{"$f":"SUM(G26:G31)","v":45193},{"$f":"SUM(H26:H31)","v":45193},21]
[" ",{"$nulls":3},"TRANSFERRED TO OTHER FUNDS",{"$nulls":3}," "]
[22,0,0,0,"22    CAPTIAL OUTLAY FUND",{"$f":"-'LB-31 Streets D Req'!$J$30","v":0},0,0,22]
[23,{"$nulls":3},23," ",null,null,23]
[24,{"$nulls":3},24,{"$nulls":3},24]
[25,{"$f":"SUM(B34:B36)","v":0},{"$f":"SUM(C34:C36)","v":0},{"$f":"SUM(D34:D36)","v":0},"25  TOTAL TRANSFERS",{"$f":"SUM(F34:F36)","v":0},{"$f":"SUM(G34:G36)","v":0},{"$f":"SUM(H34:H36)","v":0},25]
[{"$nulls":4},"26  OPERATING CONTINGENCY"]
[26,0,null,null,"27   Ending balance (prior years)",{"$nulls":3},26]
[27,{"$nulls":3},"28  UNAPPROPRIATED ENDING FUND BALANCE",{"$nulls":3},27]
[28,{"$f":"+B16+B24+B32+B37+B39","v":112220},{"$f":"+C16+C24+C32+C37+C39+C40","v":24023},{"$f":"+D16+D24+D32+D37+D38+D39+D40","v":124515},"29        TOTAL REQUIREMENTS",{"$f":"+F16+F24+F32+F37+F38+F39+F40","v":104913},{"$f":"+G16+G24+G32+G37+G38+G39+G40","v":104193},{"$f":"+H16+H24+H32+H37+H38+H39+H40","v":104193},28]
[null,"150-504-030  (Rev 12/09)",{"$nulls":3},{"$f":"IF(NOT(F41='LB-20 State Street'!F40),\"RESOURCES <> REQUIREMENTS\", \"\")","v":""}]

{"sheet":"LB-31 Streets D Req","index":15,"n_rows":42,"n_cols":13,"rows_kept":42,"merged":[[0,1,0,3],[0,4,0,6],[0,7,0,12],[1,1,1,3],[1,4,1,6],[1,7,1,12],[2,1,2,3],[2,4,2,6],[2,7,2,12],[3,1,3,3],[3,4,3,6],[3,7,3,12],[4,0,7,0],[4,1,4,3],[4,4,7,6],[4,7,7,7],[4,8,7,8],[4,9,5,11],[4,12,7,12],[5,1,5,2],[8,4,8,6],[9,4,9,6],[10,4,10,6],[11,4,11,6],[12,4,12,6],[13,4,13,6],[14,4,14,6],[15,4,15,6],[16,4,16,6],[17,4,17,6],[18,4,18,6],[19,4,19,6],[20,4,20,6],[21,4,21,6],[22,4,22,6],[23,4,23,6],[24,4,24,6],[25,4,25,6],[26,4,26,6],[27,4,27,6],[28,4,28,6],[29,4,29,6],[30,4,30,6],[31,4,31,6],[32,4,32,6],[33,4,33,6],[34,4,34,6],[35,4,35,6],[36,4,36,6],[37,4,37,6],[38,4,38,6],[39,4,39,6],[40,4,40,6]]}
[{"$nulls":4},"DETAILED REQUIREMENTS"]
[null,"FORM"]
[null,"LB-31",null,null,"CITY OF ADAMS-STREETS-GAS TAX",null,null," "]
[{"$nulls":4},"(Name of Organizational Unit - Fund)"]
[null,"Historical Data",null,null,"REQUIREMENTS DESCRIPTION",null,null,"Number of Employ-ees","Range*","Budget for Next Year 2020-2021"]
[null,"Actual",null,"Adopted Budget"]
[null,"Second Preceding","First Preceding","This Year",{"$nulls":5},"Proposed by","Approved by","Adopted by"]
[null,"Year '17-'18","Year '18-'19","19-'20",{"$nulls":5},"Budget Officer","Budget Committee","Governing Body"]
[1,13500,10504,14500,"1     MAINTENANCE PERSON",null,null,0.25,null,14500,14500,14500,1]
[2,1350,910,1450,"2     PAYROLL TAXES",{"$nulls":4},1450,1450,1450,2]
[3,2300,1815,2600,"3     BENEFITS",{"$nulls":4},2600,2600,2600,3]
[4,{"$nulls":3},4,{"$nulls":7},4]
[5,2000,1395,2000,"5     MATERIALS & SUPPLIES",{"$nulls":4},2000,2000,2000,5]
[6,250,23,250,"6     MISCELLANEOUS",{"$nulls":4},250,250,250,6]
[7,2500,144,2000,"7     SIGNS",{"$nulls":4},500,500,500,7]
[8,{"$nulls":3},8,{"$nulls":7},8]
[9,500,481,500,"9     FUEL & OIL",{"$nulls":4},600,600,600,9]
[10,5000,6491,6500,"10    P. P. & L. (ELECTRICITY)",{"$nulls":4},6500,6500,6500,10]
[11,1000,208,1500,"11    EQUIPMENT MAINTENANCE",{"$nulls":4},500,500,500,11]
[12,7000,492,7500,"12    CONTRACTUAL SERVICE",{"$nulls":4},25000,25000,25000,12]
[13,9500,0,9500,"13    STREET MAINTENANCE",{"$nulls":4},3000,3000,3000,13]
[14,500,135,500,"14    TRAINING",{"$nulls":4},500,500,500,14]
[15,500,0,0,"15    CITY EQUIPMENT REPAIR",{"$nulls":4},0,0,0,15]
[16,1500,1425,1500,"16    INSURANCE",{"$nulls":4},1600,1600,1600,16]
[17,{"$nulls":3},17,{"$nulls":7},17]
[18,50000,0,50000,"18    STREET IMPROVEMENT",{"$nulls":4},15000,15000,15000,18]
[19,14820,0,24215,"19    BRIDGE IMPROVEMENT",{"$nulls":4},30913,30913,30913,19]
[20,{"$nulls":3},20,{"$nulls":7},20]
[21,{"$nulls":3},21,{"$nulls":7},21]
[22,0,null,null,"22     TRANSFER TO CAPITAL OUTLAY",{"$nulls":4},0,0,null,22]
[23,{"$nulls":3},23,{"$nulls":7},23]
[24,{"$nulls":3},24,{"$nulls":7},24]
[25,{"$nulls":3},25,{"$nulls":7},25]
[26,{"$nulls":3},26,{"$nulls":7},26]
[27,{"$nulls":3},27,{"$nulls":7},27]
[28,{"$nulls":3},28,{"$nulls":7},28]
[29,{"$nulls":3},29,{"$nulls":7},29]
[30,{"$nulls":3},30,{"$nulls":7},30]
[31,0,null,null,"31 Ending balance (prior years)",{"$nulls":7},31]
[32,{"$nulls":3},"32  UNAPPROPRIATED ENDING FUND BALANCE",{"$nulls":7},32]
[33,{"$f":"SUM(B9:B39)","v":112220},{"$f":"SUM(C9:C39)","v":24023},{"$f":"SUM(D9:D39)","v":124515},"33    TOTAL REQUIREMENTS",{"$nulls":4},{"$f":"SUM(J9:J40)","v":104913},{"$f":"SUM(K9:K40)","v":104913},{"$f":"SUM(L9:L40)","v":104913},33]
[null,"150-504-031  (Rev 12/09)"]

{"sheet":"LB-20 Library","index":16,"n_rows":41,"n_cols":9,"rows_kept":41,"merged":[[0,1,0,2],[0,6,0,7],[1,1,1,2],[1,5,1,7],[2,1,2,2],[2,5,2,7],[3,0,6,0],[3,1,3,3],[3,4,6,4],[3,5,3,7],[3,8,6,8],[4,1,4,2],[4,5,6,5],[4,6,6,6],[4,7,6,7]]}
[null,"FORM",null,null,"RESOURCES"]
[null,"LB-20",null,null,"LIBRARY","CITY OF ADAMS"]
[]
[null,"Historical Data",null,null,"RESOURCE DESCRIPTION\n","Budget for Next Year 2020-2021"]
[null,"Actual",null,"Adopted Budget",null,"Proposed By\nBudget Officer","Approved By\nBudget Committee","Adopted By\nGoverning Body"]
[null,"Second Preceding","First Preceding","This Year"]
[null,"Year '17-'18","Year '18-'19","19-'20"]
[]
[1,8500,18708,16111,"1. Available cash on hand* (cash basis) or",25360,25360,25360,1]
[2,{"$nulls":3},"2. Net working capital (accrual basis)",{"$nulls":3},2]
[3,{"$nulls":3},"3. Previously levied taxes estimated to be received",{"$nulls":3},3]
[4,{"$nulls":3},"4. Interest",{"$nulls":3},4]
[5,{"$nulls":3},"5. Transferred IN, from other funds",{"$nulls":3},5]
[6,{"$nulls":3},"6                      OTHER RESOURCES",{"$nulls":3},6]
[7,25500,29797,30000,"7    SPECIAL LIBRARY DISTRICT",30000,30000,30000,7]
[8,1000,982,1000,"8    MISCELLANEOUS",1000,1000,1000,8]
[9,300,0,0,"9    DONATIONS",100,100,100,9]
[10,2000,4000,1000,"10   GRANTS",1000,1000,1000,10]
[11,null,0,500,"11    WINDMILL ",500,500,500,11]
[12,{"$nulls":3},12,{"$nulls":3},12]
[13,{"$nulls":3},13,{"$nulls":3},13]
[14,{"$nulls":3},"14   TRANSFER FROM:",{"$nulls":3},14]
[15,7000,7000,0,"15   GENERAL FUND",10000,10000,10000,15]
[16,{"$nulls":3},16,{"$nulls":3},16]
[17,{"$nulls":3},17,{"$nulls":3},17]
[18,{"$nulls":3},18,{"$nulls":3},18]
[19,{"$nulls":3},19,{"$nulls":3},19]
[20,{"$nulls":3},20,{"$nulls":3},20]
[21,{"$nulls":3},21,{"$nulls":3},21]
[22,{"$nulls":3},22,{"$nulls":3},22]
[23,{"$nulls":3},23,{"$nulls":3},23]
[24,{"$nulls":3},24,{"$nulls":3},24]
[25,{"$nulls":3},25,{"$nulls":3},25]
[26,{"$nulls":3},26,{"$nulls":3},26]
[27,{"$nulls":3},27,{"$nulls":3},27]
[28," ",null,null,28,{"$nulls":3},28]
[29,{"$f":"SUM(B9:B36)","v":44300},34779,{"$f":"SUM(D9:D23)","v":48611},"29. Total resources, except taxes to be levied",{"$f":"SUM(F9:F23)","v":67960},{"$f":"SUM(G9:G23)","v":67960},{"$f":"SUM(H9:H23)","v":67960},29]
[30,{"$nulls":3},"30. Taxes estimated to be received",{"$nulls":3},30]
[31,{"$nulls":3},"31. Taxes collected in year levied",{"$nulls":3},31]
[32,{"$f":"B37+B39","v":44300},{"$f":"C37+C39","v":34779},{"$f":"D37+D38","v":48611},"32.  TOTAL RESOURCES",{"$f":"F37+F38","v":67960},{"$f":"G37+G38","v":67960},{"$f":"H37+H38","v":67960},32]
[{"$nulls":4},"*Includes ending balance from prior year",{"$f":"IF(NOT(F40='LB-30 Library Req'!F41),\"RESOURCES <> REQUIREMENTS\", \"\")","v":""}]

{"sheet":"LB-30 Library Req","index":17,"n_rows":42,"n_cols":9,"rows_kept":42,"merged":[[0,3,0,5],[1,3,1,5],[2,3,2,5],[3,3,3,5],[3,6,3,8],[4,0,7,0],[4,1,4,3],[4,4,7,4],[4,5,5,7],[4,8,7,8],[5,1,5,2],[8,1,8,3],[8,5,8,7],[16,1,16,3],[16,5,16,7],[24,1,24,3],[24,5,24,7],[32,1,32,3],[32,5,32,7]]}
[" ",null,null,"REQUIREMENTS SUMMARY"]
[null,"FORM",null,"BY FUND, ORGANIZATIONAL UNIT OR PROGRAM"]
[null,"LB-30",null,"LIBRARY"]
[{"$nulls":3},"CITY OF ADAMS",null,null," "]
[null,"Historical Data",null,null,"REQUIREMENTS DESCRIPTION","Budget For Next Year 2019-2020"]
[null,"Actual",null,"Adopted Budget"]
[null,"Second Preceding","First Preceding","This Year",null,"Proprosed By","Approved By","Adopted By"]
[null,"Year '17-'18","Year '18-'19","19-'20",null,"Budget Officer","Budget Committee","Governing Body"]
[{"$nulls":4},"PERSONAL SERVICES"]
[1,24500,20679,29500,"1    LIBRARIAN/ASSISTANT",{"$f":"'LB-31 Library D Req'!J9","v":29500},29500,29500,1]
[2,2450,2007,2400,"2   PAYROLL TAXES",{"$f":"'LB-31 Library D Req'!J10","v":2900},2900,2900,2]
[3,0,0,0,"3    BENEFITS",{"$f":"'LB-31 Library D Req'!J11","v":8400},8400,8400,3]
[4,{"$nulls":3},4,{"$nulls":3},4]
[5,{"$nulls":3},5,{"$nulls":3},5]
[6,{"$nulls":3},6,{"$nulls":3},6]
[7,{"$f":"SUM(B10:B15)","v":26950},{"$f":"SUM(C10:C15)","v":22686},{"$f":"SUM(D10:D15)","v":31900},"7  TOTAL PERSONAL SERVICES",{"$f":"SUM(F10:F15)","v":40800},{"$f":"SUM(G10:G15)","v":40800},{"$f":"SUM(H10:H15)","v":40800},7]
[" ",{"$nulls":3},"MATERIALS AND SERVICES",{"$nulls":3}," "]
[8,5600,12931,5000,"8    MATERIALS AND SUPPLIES",5000,5000,5000,8]
[9,{"$nulls":3},9,{"$nulls":3},9]
[10,7750,45,8711,"10   CONTRACTUAL SERVICES",11150,11150,11150,10]
[11,{"$nulls":3},11,{"$nulls":3},11]
[12,{"$nulls":3},12,{"$nulls":3},12]
[13,{"$nulls":3},13,{"$nulls":3},13]
[14,{"$f":"SUM(B18:B23)","v":13350},{"$f":"SUM(C18:C23)","v":12976},{"$f":"SUM(D18:D23)","v":13711},"14  TOTAL MATERIALS AND SERVICES",{"$f":"SUM(F18:F23)","v":16150},{"$f":"SUM(G18:G23)","v":16150},{"$f":"SUM(H18:H23)","v":16150},14]
[" ",{"$nulls":3},"CAPITAL OUTLAY"]
[15,{"$nulls":3},15,{"$nulls":3},15]
[16,{"$nulls":3},16,{"$nulls":3},16]
[17," ",null,null,17,{"$nulls":3},17]
[18,{"$nulls":3},18,{"$nulls":3},18]
[19,{"$nulls":3},19,{"$nulls":3},19]
[20,{"$nulls":3},20,{"$nulls":3},20]
[21,{"$f":"SUM(B26:B31)","v":0},{"$f":"SUM(C26:C31)","v":0},{"$f":"SUM(D26:D31)","v":0},"21  TOTAL CAPITAL OUTLAY",{"$f":"SUM(F26:F31)","v":0},{"$f":"SUM(G26:G31)","v":0},{"$f":"SUM(H26:H31)","v":0},21]
[" ",{"$nulls":3},"TRANSFERRED TO OTHER FUNDS",{"$nulls":3}," "]
[22,{"$nulls":3},"22   TO LIBRARY CAPITAL FUND",{"$nulls":3},22]
[23,0,0,0,"23   REPAY LOAN",{"$nulls":3},23]
[24,{"$nulls":3},24,{"$nulls":3},24]
[25,0,{"$f":"SUM(C34:C36)","v":0},{"$f":"SUM(D34:D36)","v":0},"25  TOTAL TRANSFERS",0,{"$f":"SUM(G34:G36)","v":0},{"$f":"SUM(H34:H36)","v":0},25]
[26,{"$nulls":3},"26  OPERATING CONTINGENCY",11010,11010,11010,26]
[27,0,null,null,"27  Ending balance (prior years)",{"$nulls":3},27]
[28,null,22550,3000,"28  UNAPPROPRIATED ENDING FUND BALANCE",0,null,null,28]
[29,{"$f":"+B16+B24+B32+B37+B39","v":40300},{"$f":"+C16+C24+C32+C37+C39+C40","v":58212},{"$f":"+D16+D24+D32+D37+D38+D39+D40","v":48611},"29        TOTAL REQUIREMENTS",{"$f":"+F16+F24+F32+F37+F38+F39+F40","v":67960},{"$f":"+G16+G24+G32+G37+G38+G39+G40","v":67960},{"$f":"+H16+H24+H32+H37+H38+H39+H40","v":67960},29]
[null,"150-504-030  (Rev 12/09)",{"$nulls":3},{"$f":"IF(NOT(F41='LB-20 Library'!F40),\"RESOURCES <> REQUIREMENTS\", \"\")","v":""}]

{"sheet":"LB-31 Library D Req","index":18,"n_rows":42,"n_cols":13,"rows_kept":42,"merged":[[0,1,0,3],[0,4,0,6],[0,7,0,12],[1,1,1,3],[1,4,1,6],[1,7,1,12],[2,1,2,3],[2,4,2,6],[2,7,2,12],[3,1,3,3],[3,4,3,6],[3,7,3,12],[4,0,7,0],[4,1,4,3],[4,4,7,6],[4,7,7,7],[4,8,7,8],[4,9,5,11],[4,12,7,12],[5,1,5,2],[8,4,8,6],[9,4,9,6],[10,4,10,6],[11,4,11,6],[12,4,12,6],[13,4,13,6],[14,4,14,6],[15,4,15,6],[16,4,16,6],[17,4,17,6],[18,4,18,6],[19,4,19,6],[20,4,20,6],[21,4,21,6],[22,4,22,6],[23,4,23,6],[24,4,24,6],[25,4,25,6],[26,4,26,6],[27,4,27,6],[28,4,28,6],[29,4,29,6],[30,4,30,6],[31,4,31,6],[32,4,32,6],[33,4,33,6],[34,4,34,6],[35,4,35,6],[36,4,36,6],[37,4,37,6],[38,4,38,6],[39,4,39,6],[40,4,40,6]]}
[{"$nulls":4},"DETAILED REQUIREMENTS"]
[null,"FORM"]
[null,"LB-31",null,null,"LIBRARY"]
[{"$nulls":4},"CITY OF ADAMS"]
[null,"Historical Data",null,null,"REQUIREMENTS DESCRIPTION",null,null,"Number of Employ-ees","Range*","Budget for Next Year 2020-2021"]
[null,"Actual",null,"Adopted Budget"]
[null,"Second Preceding","First Preceding","This Year",{"$nulls":5},"Proposed by","Approved by","Adopted by"]
[null,"Year '17-'18","Year '18-'19","19-'20",{"$nulls":5},"Budget Officer","Budget Committee","Governing Body"]
[1,24500,20679,29500,"1    LIBRARIAN/ASSISTANT",null,null,{"v":1,"d":"1.0"},null,29500,29500,29500,1]
[2,2450,2007,2400,"2    PAYROLL TAXES",{"$nulls":4},2900,2900,2900,2]
[3,0,2274,0,"3    BENEFITS",{"$nulls":4},8400,8400,8400,3]
[4,{"$nulls":3},4,{"$nulls":7},4]
[5,2100,2154,2000,"5    SUPPLIES",{"$nulls":4},2000,2000,2000,5]
[6,3500,5421,3000,"6    BOOKS & MAGAZINES",{"$nulls":4},3000,3000,3000,6]
[7,{"$nulls":3},7,{"$nulls":7},7]
[8,750,615,750,"8    INSURANCE",{"$nulls":4},750,750,750,8]
[9,2350,1956,2261,"9    SPECIAL PROGRAMS",{"$nulls":4},4500,4500,4500,9]
[10,1500,1317,1700,"10   COMMUNICATION",{"$nulls":4},1700,1700,1700,10]
[11,500,261,1000,"11   EQUIPMENT MAINTENANCE",{"$nulls":4},500,500,500,11]
[12,263,14,500,"12   STAFF TRAINING",{"$nulls":4},1000,1000,1000,12]
[13,1250,1194,1500,"13   ELECTRICITY",{"$nulls":4},1500,1500,1500,13]
[14,500,0,500,"14   MILEAGE",{"$nulls":4},1000,1000,1000,14]
[15,400,45,500,"15   CONTRACTUAL SERVICES",{"$nulls":4},200,200,200,15]
[16,{"$nulls":3},16,{"$nulls":7},16]
[17,{"$nulls":3},17,{"$nulls":7},17]
[18,{"$nulls":3},18,{"$nulls":7},18]
[19,0,0,0,"19   PAY BACK LOAN",{"$nulls":4},0,0,0,19]
[20,{"$nulls":3},20,{"$nulls":7},20]
[21,{"$nulls":3},21,{"$nulls":7},21]
[22,{"$nulls":3},22,{"$nulls":7},22]
[23,{"$nulls":3},23,{"$nulls":7},23]
[24,{"$nulls":3},24,{"$nulls":7},24]
[25,{"$nulls":3},25,{"$nulls":7},25]
[26,{"$nulls":3},26,{"$nulls":7},26]
[27,{"$nulls":3},27,{"$nulls":7},27]
[28,null,{"$f":"SUM(C9:C24)","v":37937},{"$f":"SUM(D9:D24)","v":45611},"25   TOTAL EXPENDITURES",{"$nulls":4},{"$f":"SUM(J9:J27)","v":56950},{"$f":"SUM(K9:K24)","v":56950},{"$f":"SUM(L9:L24)","v":56950},28]
[29,{"$nulls":3},29,{"$nulls":7},29]
[30,{"$nulls":3},"30   OPERATING CONTINGENCY",{"$nulls":4},11010,11010,11010,30]
[31,8057,22550,null,"31  Ending balance (prior years)",{"$nulls":7},31]
[32,null,0,0,"32  UNAPPROPRIATED ENDING FUND BALANCE",{"$nulls":4},0,null,null,32]
[33,{"$f":"SUM(B9:B39)","v":48120},44300,{"$f":"D36+D40","v":45611},"33    TOTAL REQUIREMENTS",{"$nulls":4},{"$f":"J36+J38+J40","v":67960},{"$f":"K36+K38+K40","v":67960},{"$f":"L36+L38+L40","v":67960},33]
[null,"150-504-031  (Rev 12/09)"]

{"sheet":"LB-20 State Rev","index":19,"n_rows":41,"n_cols":9,"rows_kept":41,"merged":[[0,1,0,2],[0,6,0,7],[1,1,1,2],[1,5,1,7],[2,1,2,2],[2,5,2,7],[3,0,6,0],[3,1,3,3],[3,4,6,4],[3,5,3,7],[3,8,6,8],[4,1,4,2],[4,5,6,5],[4,6,6,6],[4,7,6,7]]}
[null,"FORM",null,null,"RESOURCES"]
[null,"LB-20",null,null,"STATE REVENUE SHARING","CITY OF ADAMS"]
[{"$nulls":4},"(Fund)","(Name of Municipal Corporation)"]
[null,"Historical Data",null,null,"RESOURCE DESCRIPTION\n","Budget for Next Year 2020-2021"]
[null,"Actual",null,"Adopted Budget",null,"Proposed By\nBudget Officer","Approved By\nBudget Committee","Adopted By\nGoverning Body"]
[null,"Second Preceding","First Preceding","This Year"]
[null,"Year '17-'18","Year '18-'19","19-'20"]
[]
[1,2680,2887,5115,"1. Available cash on hand* (cash basis) or",7343,7343,7343,1]
[2,{"$nulls":3},"2. Net working capital (accrual basis)",{"$nulls":3},2]
[3,{"$nulls":3},"3. Previously levied taxes estimated to be received",{"$nulls":3},3]
[4,10,2,4,"4. Interest",150,150,150,4]
[5,{"$nulls":3},"5. Transferred IN, from other funds",{"$nulls":3},5]
[6,{"$nulls":3},"6                      OTHER RESOURCES",{"$nulls":3},6]
[7,{"$nulls":3},7,{"$nulls":3},7]
[8,2500,2597,2800,"8     STATE REVENUE SHARING",2500,2500,2500,8]
[9,{"$nulls":3},9,{"$nulls":3},9]
[10,{"$nulls":3},10,{"$nulls":3},10]
[11,{"$nulls":3},11,{"$nulls":3},11]
[12,{"$nulls":3},12,{"$nulls":3},12]
[13,{"$nulls":3},13,{"$nulls":3},13]
[14,{"$nulls":3},14,{"$nulls":3},14]
[15,{"$nulls":3},15,{"$nulls":3},15]
[16,{"$nulls":3},16,{"$nulls":3},16]
[17,{"$nulls":3},17,{"$nulls":3},17]
[18,{"$nulls":3},18,{"$nulls":3},18]
[19,{"$nulls":3},19,{"$nulls":3},19]
[20,{"$nulls":3},20,{"$nulls":3},20]
[21,{"$nulls":3},21,{"$nulls":3},21]
[22,{"$nulls":3},22,{"$nulls":3},22]
[23,{"$nulls":3},23,{"$nulls":3},23]
[24,{"$nulls":3},24,{"$nulls":3},24]
[25,{"$nulls":3},25,{"$nulls":3},25]
[26,{"$nulls":3},26,{"$nulls":3},26]
[27,{"$nulls":3},27,{"$nulls":3},27]
[28,null,null," ",28,{"$nulls":3},28]
[29,{"$f":"SUM(B9:B36)","v":5190},{"$f":"SUM(C9:C36)","v":5486},{"$f":"SUM(D9:D36)","v":7919},"29. Total resources, except taxes to be levied",{"$f":"SUM(F9:F36)","v":9993},9993,9993,29]
[30,{"$nulls":3},"30. Taxes estimated to be received",{"$nulls":3},30]
[31,{"$nulls":3},"31. Taxes collected in year levied",{"$nulls":3},31]
[32,{"$f":"B37+B39","v":5190},5165,{"$f":"D37+D38","v":7919},"32.  TOTAL RESOURCES",{"$f":"F37+F38","v":9993},{"$f":"G37+G38","v":9993},{"$f":"H37+H38","v":9993},32]
[{"$nulls":4},"*Includes ending balance from prior year",{"$f":"IF(NOT(F40='LB-31 State Rev D Req'!J41),\"RESOURCES <> REQUIREMENTS\", \"\")","v":""}]

{"sheet":"LB-31 State Rev D Req","index":20,"n_rows":42,"n_cols":13,"rows_kept":42,"merged":[[0,1,0,3],[0,4,0,6],[0,7,0,12],[1,1,1,3],[1,4,1,6],[1,7,1,12],[2,2,2,10],[3,1,3,3],[3,4,3,6],[3,7,3,12],[4,0,7,0],[4,1,4,3],[4,4,7,6],[4,7,7,7],[4,8,7,8],[4,9,5,11],[4,12,7,12],[5,1,5,2],[8,4,8,6],[9,4,9,6],[10,4,10,6],[11,4,11,6],[12,4,12,6],[13,4,13,6],[14,4,14,6],[15,4,15,6],[16,4,16,6],[17,4,17,6],[18,4,18,6],[19,4,19,6],[20,4,20,6],[21,4,21,6],[22,4,22,6],[23,4,23,6],[24,4,24,6],[25,4,25,6],[26,4,26,6],[27,4,27,6],[28,4,28,6],[29,4,29,6],[30,4,30,6],[31,4,31,6],[32,4,32,6],[33,4,33,6],[34,4,34,6],[35,4,35,6],[36,4,36,6],[37,4,37,6],[38,4,38,6],[39,4,39,6],[40,4,40,6]]}
[{"$nulls":4},"DETAILED REQUIREMENTS"]
[null,"FORM"]
[null,"LB-31","CITY OF ADAMS-STATE REVENUE SHARING-STATE REVENUE SHARING"]
[{"$nulls":4},"(Name of Organizational Unit - Fund)"]
[null,"Historical Data",null,null,"REQUIREMENTS DESCRIPTION",null,null,"Number of Employ-ees","Range*","Budget for Next Year 2019-2020"]
[null,"Actual",null,"Adopted Budget"]
[null,"Second Preceding","First Preceding","This Year",{"$nulls":5},"Proposed by","Approved by","Adopted by"]
[null,"Year '17-'18","Year '18-'19","19-'20",{"$nulls":5},"Budget Officer","Budget Committee","Governing Body"]
[1,{"$nulls":3},1,{"$nulls":7},1]
[2,2800,2500,4919,"2     STREETS-P.P. & L. (ELECTRICITY)",{"$nulls":4},5000,5000,5000,2]
[3,{"$nulls":3},3,{"$nulls":7},3]
[4,{"$nulls":3},4,{"$nulls":7},4]
[5,2390,2007,3000,"5     CITY BEAUTIFICATION",{"$nulls":4},4993,4993,4993,5]
[6,{"$nulls":3},6,{"$nulls":7},6]
[7,{"$nulls":3},7,{"$nulls":7},7]
[8,{"$nulls":3},8,{"$nulls":7},8]
[9,{"$nulls":3},9,{"$nulls":7},9]
[10,{"$nulls":3},10,{"$nulls":7},10]
[11,{"$nulls":3},11,{"$nulls":7},11]
[12,{"$nulls":3},12,{"$nulls":7},12]
[13,{"$nulls":3},13,{"$nulls":7},13]
[14,{"$nulls":3},14,{"$nulls":7},14]
[15,{"$nulls":3},15,{"$nulls":7},15]
[16,{"$nulls":3},16,{"$nulls":7},16]
[17,{"$nulls":3},17,{"$nulls":7},17]
[18,{"$nulls":3},18,{"$nulls":7},18]
[19,{"$nulls":3},19,{"$nulls":7},19]
[20,{"$nulls":3},20,{"$nulls":7},20]
[21,{"$nulls":3},21,{"$nulls":7},21]
[22,{"$nulls":3},22,{"$nulls":7},22]
[23,{"$nulls":3},23,{"$nulls":7},23]
[24,{"$nulls":3},24,{"$nulls":7},24]
[25,{"$nulls":3},25,{"$nulls":7},25]
[26,{"$nulls":3},26,{"$nulls":7},26]
[27,{"$nulls":3},27,{"$nulls":7},27]
[28,{"$nulls":3},28,{"$nulls":7},28]
[29,{"$nulls":3},29,{"$nulls":7},29]
[30,{"$nulls":3},30,{"$nulls":7},30]
[31,2887,5165,7570,"31 Ending balance (prior years)",{"$nulls":7},31]
[32,{"$nulls":3},"32  UNAPPROPRIATED ENDING FUND BALANCE",{"$nulls":7},32]
[33,{"$f":"SUM(B9:B39)","v":8077},{"$f":"SUM(C9:C39)","v":9672},{"$f":"SUM(D9:D40)","v":15489},"33    TOTAL REQUIREMENTS",{"$nulls":4},{"$f":"SUM(J9:J40)","v":9993},{"$f":"SUM(K9:K40)","v":9993},{"$f":"SUM(L9:L40)","v":9993},33]
[null,"150-504-031  (Rev 12/09)",{"$nulls":7},{"$f":"IF(NOT(J41='LB-20 State Rev'!F40),\"RESOURCES <> REQUIREMENTS\", \"\")","v":""}]

{"sheet":"LB-11 Capital Outlay","index":21,"n_rows":41,"n_cols":9,"rows_kept":41,"merged":[[0,0,0,1],[1,0,1,1],[1,5,1,8],[2,0,2,3],[2,5,2,8],[3,0,3,3],[3,5,3,8],[4,0,4,3],[4,5,4,8],[5,0,5,3],[5,5,5,8],[6,0,9,0],[6,1,6,3],[6,5,6,7],[6,8,9,8],[7,1,7,2]]}
["FORM ",{"$nulls":7}," "]
["LB-11",{"$nulls":3},"RESERVE FUND","Year this reserve fund will be reviewed to be continued or abolished."]
["This fund is authorized and established by resolution / ordinance number",{"$nulls":3},"RESOURCES AND REQUIREMENTS","Date can not be more than 10 years after establishment."]
["13-08        on 6/12/2013             for the following specified purpose:",{"$nulls":4},"Review Year:   2023"]
["Plan for large capital outlay expenses.",{"$nulls":3},"CAPITAL OUTLAY RESERVE FUND","             CITY OF ADAMS"]
[{"$nulls":4},"(Fund)","(Name of Municipal Corporation) "]
[null,"Historical Data",{"$nulls":3},"Budget for Next Year 2019-2020"]
[null,"Actual",null,"Adopted Budget","DESCRIPTION","Proposed By","Approved By","Adopted By"]
[null,"Second Preceding","First Preceding","This Year","RESOURCES AND REQUIREMENTS","Budget Officer","Budget Committee","Governing Body"]
[null,"Year '17-'18","Year '18-'19","19-'20"]
[{"$nulls":4},"RESOURCES  "]
[1,92239,102296,102360,"1.   Cash on hand* (cash basis) or",191013,191013,191013,1]
[2,{"$nulls":3},"2.  Working Capital (accrual basis)",{"$nulls":3},2]
[3,{"$nulls":3},"3.  Previously levied taxes estimated to be received",{"$nulls":3},3]
[4,57,46,70,"4.  Interest",1800,1800,1800,4]
[5,10000,10000,58400,"5.  Transferred IN, from other funds-GENERAL",{"$nulls":3},5]
[6,{"$nulls":3},"6.  Transferred IN, from other funds-GENERAL-PARK",{"$nulls":3},6]
[7,{"$nulls":3},"7.  Transferred IN, from other funds-STREET",{"$nulls":3},7]
[8,null,10000,0,"8.  Transferred IN, from other funds-WATER",{"$nulls":3},8]
[9,0,0,9505,"9.  Transferred IN, from other funds-PARK REC CAPITAL",{"$nulls":3},9]
[10,{"$nulls":3},"10. Transferred IN, from other funds-CITY EQUIPMENT CAP",{"$nulls":3},10]
[11,{"$nulls":3},"11.  Transferred IN, from other funds-LIBRARY CAPITAL",{"$nulls":3},11]
[12,{"$nulls":3},"12.  Loan Proceeds",{"$nulls":3},12]
[13,{"$f":"SUM(B12:B23)","v":102296},122342,{"$f":"SUM(D12:D22)","v":170335},"13.  Total Resources, except taxes to be levied",{"$f":"SUM(F12:F22)","v":192813},{"$f":"SUM(G12:G22)","v":192813},{"$f":"SUM(H12:H22)","v":192813},13]
[14,{"$nulls":3},"14.  Taxes estimated to be received",{"$nulls":3},14]
[15," ",null,null,"15.  Taxes collected in year levied",{"$nulls":3},15]
[16,{"$f":"SUM(B24:B26)","v":102296},{"$f":"SUM(C24:C26)","v":122342},{"$f":"SUM(D24:D26)","v":170335},"16.  TOTAL RESOURCES",{"$f":"SUM(F24:F26)","v":192813},{"$f":"SUM(G24:G26)","v":192813},{"$f":"SUM(H24:H26)","v":192813},16]
[{"$nulls":4},"REQUIREMENTS"]
[1,{"$nulls":3},1,{"$nulls":3},1]
[2,102296,122342,170335,"2     CAPITAL OUTLAY",192813,192813,192813,2]
[3,{"$nulls":3},3,{"$nulls":3},3]
[4,{"$nulls":3},"4     SYSTEM IMPROVEMENTS",{"$nulls":3},4]
[5,{"$nulls":3},5,{"$nulls":3},5]
[6,{"$nulls":3},6,{"$nulls":3},6]
[7,{"$nulls":3},7,{"$nulls":3},7]
[8,{"$nulls":3},8,{"$nulls":3},8]
[9,{"$nulls":3},9,{"$nulls":3},9]
[10,{"$nulls":3},10,{"$nulls":3},10]
[11,{"$nulls":3},11,{"$nulls":3},11]
[12,0,0,0,"12.  RESERVED FOR FUTURE EXPENDITURE",{"$nulls":3},12]
[13,102296,122342,{"$f":"SUM(D29:D40)","v":170335},"13.  TOTAL REQUIREMENTS",{"$f":"SUM(F29:F40)","v":192813},{"$f":"SUM(G29:G40)","v":192813},{"$f":"SUM(H29:H40)","v":192813},13]

{"sheet":"LB-11 Water Loan","index":22,"n_rows":41,"n_cols":9,"rows_kept":41,"merged":[[0,0,0,1],[1,0,1,1],[1,5,1,8],[2,0,2,3],[2,5,2,8],[3,0,3,3],[3,5,3,8],[4,0,4,3],[4,5,4,8],[5,0,5,3],[5,5,5,8],[6,0,9,0],[6,1,6,3],[6,5,6,7],[6,8,9,8],[7,1,7,2]]}
["FORM ",{"$nulls":7}," "]
["LB-11",{"$nulls":3},"RESERVE FUND","Year this reserve fund will be reviewed to be continued or abolished."]
["This fund is authorized and established by resolution / ordinance number",{"$nulls":3},"RESOURCES AND REQUIREMENTS","Date can not be more than 10 years after establishment."]
["11-03 on (date) 02-09-2011 for the following specified purpose:",{"$nulls":4},"Review Year: 2021"]
["To set aside money which will be equal to one year's loan payment.",{"$nulls":3},"WATER RESERVE LOAN FUND","CITY OF ADAMS"]
[{"$nulls":4},"(Fund)","(Name of Municipal Corporation) "]
[null,"Historical Data",{"$nulls":3},"Budget for Next Year 2020-2021"]
[null,"Actual",null,"Adopted Budget","DESCRIPTION","Proposed By","Approved By","Adopted By"]
[null,"Second Preceding","First Preceding","This Year","RESOURCES AND REQUIREMENTS","Budget Officer","Budget Committee","Governing Body"]
[null,"Year '17-'18","Year '18-'19","19-'20"]
[{"$nulls":4}," "]
[1,38175,42189,42200,"1.  Cash on hand* (cash basis) or",42410,42410,42410,1]
[2,{"$nulls":3},"2.  Working Capital (accrual basis)",{"$nulls":3},2]
[3,{"$nulls":3},"3.  Previously levied taxes estimated to be received",{"$nulls":3},3]
[4,0,11,30,"4.  Interest",480,480,480,4]
[5,4000,0,0,"5.  Transferred IN, from other funds WATER",{"$nulls":3},5]
[6,{"$nulls":3},6,{"$nulls":3},6]
[7,{"$nulls":3},7,{"$nulls":3},7]
[8,{"$nulls":3},8,{"$nulls":3},8]
[9,{"$f":"SUM(B12:B17)","v":42175},{"$f":"SUM(C12:C19)","v":42200},{"$f":"SUM(D12:D16)","v":42230},"9.  Total Resources, except taxes to be levied",{"$f":"SUM(F12:F16)","v":42890},42890,42890,9]
[10,{"$nulls":3},"10. Taxes estimated to be received",{"$nulls":3},10]
[11,{"$nulls":3},"11.  Taxes collected in year levied",{"$nulls":3},11]
[12,{"$f":"SUM(B20:B22)","v":42175},{"$f":"SUM(C20:C22)","v":42200},{"$f":"SUM(D20:D22)","v":42230},"12.  TOTAL RESOURCES",{"$f":"SUM(F20:F22)","v":42890},{"$f":"SUM(G20:G22)","v":42890},{"$f":"SUM(H20:H22)","v":42890},12]
[{"$nulls":4},"REQUIREMENTS"]
[1,{"$nulls":3},1,{"$nulls":3},1]
[2,{"$nulls":3},2,{"$nulls":3},2]
[3,20000,20000,0,"3    Transfer to Water Fund",0,0,0,3]
[4,{"$nulls":3},4,{"$nulls":3},4]
[5,{"$nulls":3},5,{"$nulls":3},5]
[6,{"$nulls":3},6,{"$nulls":3},6]
[7,{"$nulls":3},7,{"$nulls":3},7]
[8,{"$nulls":3},8,{"$nulls":3},8]
[9,{"$nulls":3},9,{"$nulls":3},9]
[10,{"$nulls":3},10,{"$nulls":3},10]
[11,{"$nulls":3},11,{"$nulls":3},11]
[12,{"$nulls":3},12,{"$nulls":3},12]
[13,{"$nulls":3},13,{"$nulls":3},13]
[14,{"$nulls":3},14,{"$nulls":3},14]
[15,{"$nulls":3},15,{"$nulls":3},15]
[16,22175,22175,42230,"16.  RESERVED FOR FUTURE EXPENDITURE",42890,42890,42890,16]
[17,{"$f":"SUM(B25:B40)","v":42175},{"$f":"SUM(C25:C40)","v":42175},{"$f":"SUM(D25:D40)","v":42230},"17.  TOTAL REQUIREMENTS",{"$f":"SUM(F25:F40)","v":42890},{"$f":"SUM(G25:G40)","v":42890},{"$f":"SUM(H25:H40)","v":42890},17]

{"sheet":"LB-11 WSR","index":23,"n_rows":41,"n_cols":9,"rows_kept":41,"merged":[[0,0,0,1],[1,0,1,1],[1,5,1,8],[2,0,2,3],[2,5,2,8],[3,0,3,3],[3,5,3,8],[4,0,4,3],[4,5,4,8],[5,0,5,3],[5,5,5,8],[6,0,9,0],[6,1,6,3],[6,5,6,7],[6,8,9,8],[7,1,7,2]]}
["FORM ",{"$nulls":7}," "]
["LB-11",{"$nulls":3},"RESERVE FUND","Year this reserve fund will be reviewed to be continued or abolished."]
["This fund is authorized and established by resolution / ordinance number",{"$nulls":3},"RESOURCES AND REQUIREMENTS","Date can not be more than 10 years after establishment."]
["11-02 on (date) 02-09-2011 for the following specified purpose:",{"$nulls":4},"Review Year: 2021"]
["Plan for water facilities.",{"$nulls":3},"WATER SYSTEM REPLACEMENT FUND","             CITY OF ADAMS"]
[{"$nulls":4},"(Fund)","(Name of Municipal Corporation) "]
[null,"Historical Data",{"$nulls":3},"Budget for Next Year 2020-2021"]
[null,"Actual",null,"Adopted Budget","DESCRIPTION","Proposed By","Approved By","Adopted By"]
[null,"Second Preceding","First Preceding","This Year","RESOURCES AND REQUIREMENTS","Budget Officer","Budget Committee","Governing Body"]
[null,"Year '17-'18","Year '18-'19","19-'20"]
[{"$nulls":4},"RESOURCES  "]
[1,64900,42568,42595,"1.  Cash on hand* (cash basis) or",36817,36817,36817,1]
[2,{"$nulls":3},"2.  Working Capital (accrual basis)",{"$nulls":3},2]
[3,{"$nulls":3},"3.  Previously levied taxes estimated to be received",{"$nulls":3},3]
[4,50,21,30,"4.  Interest",500,500,500,4]
[5,5000,0,null,"5.  Transferred IN, from other funds-WATER",{"$nulls":3},5]
[6,{"$nulls":3},6,{"$nulls":3},6]
[7,{"$nulls":3},7,{"$nulls":3},7]
[8,{"$nulls":3},8,{"$nulls":3},8]
[9,{"$f":"SUM(B12:B17)","v":69950},{"$f":"SUM(C12:C19)","v":42589},{"$f":"SUM(D12:D17)","v":42625},"9.  Total Resources, except taxes to be levied",{"$f":"SUM(F12:F17)","v":37317},37317,37317,9]
[10,{"$nulls":3},"10.  Taxes estimated to be received",{"$nulls":3},10]
[11,{"$nulls":3},"11.  Taxes collected in year levied",{"$nulls":3},11]
[12,{"$f":"SUM(B20:B22)","v":69950},{"$f":"SUM(C20:C22)","v":42589},{"$f":"SUM(D20:D22)","v":42625},"12.  TOTAL RESOURCES",{"$f":"SUM(F20:F22)","v":37317},{"$f":"SUM(G20:G22)","v":37317},{"$f":"SUM(H20:H22)","v":37317},12]
[{"$nulls":4},"REQUIREMENTS"]
[1,{"$nulls":3},1,{"$nulls":3},1]
[2,69950,42589,42625,"2     WATER SYSTEM REPLACEMENT",37317,37317,37317,2]
[3,{"$nulls":3},3,{"$nulls":3},3]
[4,{"$nulls":7},4]
[5,{"$nulls":3},5,{"$nulls":3},5]
[6,{"$nulls":3},6,{"$nulls":3},6]
[7,{"$nulls":3},7,{"$nulls":3},7]
[8,{"$nulls":3},8,{"$nulls":3},8]
[9,{"$nulls":3},9,{"$nulls":3},9]
[10,{"$nulls":3},10,{"$nulls":3},10]
[11,{"$nulls":3},11,{"$nulls":3},11]
[12,{"$nulls":3},12,{"$nulls":3},12]
[13,{"$nulls":3},13,{"$nulls":3},13]
[14,{"$nulls":3},14,{"$nulls":3},14]
[15,{"$nulls":3},15,{"$nulls":3},15]
[16,0,null,0,"16.  RESERVED FOR FUTURE EXPENDITURE",{"$nulls":3},16]
[17,{"$f":"SUM(B25:B40)","v":69950},{"$f":"SUM(C25:C40)","v":42589},{"$f":"SUM(D25:D40)","v":42625},"17.  TOTAL REQUIREMENTS",{"$f":"SUM(F25:F40)","v":37317},{"$f":"SUM(G25:G40)","v":37317},{"$f":"SUM(H25:H40)","v":37317},17]

{"sheet":"LB-35 Debt Serv","index":24,"n_rows":44,"n_cols":10,"rows_kept":44,"merged":[[0,3,0,6],[0,7,0,9],[1,3,1,6],[1,7,1,9],[2,3,2,6],[2,7,2,9],[3,4,3,5],[3,7,3,8],[4,3,4,6],[4,7,4,9],[5,0,8,0],[5,1,5,3],[5,4,8,5],[5,6,5,8],[5,9,8,9],[6,1,6,2],[6,6,8,6],[6,7,8,7],[6,8,8,8],[9,4,9,5],[10,4,10,5],[11,4,11,5],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[17,4,17,5],[18,4,18,5],[19,4,19,5],[20,0,22,0],[20,4,20,5],[20,9,22,9],[21,4,21,5],[26,4,26,5],[27,0,28,0],[27,4,27,5],[27,9,28,9],[32,4,32,5],[33,0,34,0],[33,4,33,5],[33,9,34,9],[38,4,38,5],[39,4,39,5],[40,4,40,5],[41,4,41,5],[42,4,42,5],[43,3,43,6],[44,3,44,6]]}
[{"$nulls":3},"BONDED DEBT",{"$nulls":3},"Bond Debt Payments are for:"]
[null,"FORM",null,"RESOURCES AND REQUIREMENTS"]
[null,"LB-35"]
[{"$nulls":4},"DEBT SERVICE FUND",null,null,"CITY OF ADAMS"]
[{"$nulls":3},"(Fund)",{"$nulls":3}," (Name of Municipal Corporation)"]
[null,"Historical Data",null,null,"DESCRIPTION OF\nRESOURCES AND REQUIREMENTS",null,"Budget for Next Year 2020-2021"]
[null,"Actual",null,"Adopted Budget\n",null,null,"Proposed By\nBudget Officer","Approved By\nBudget Committee","Adopted By\nGoverning Body"]
[null,"Second Preceding\n","First Preceding\n","This Year"]
[null,"Year '17-'18","Year '18-'19","19-'20"]
[{"$nulls":4},"Resources"]
[1,{"v":17930,"d":"17,930"},{"v":9446,"d":"9,446"},{"v":3439,"d":"3,439"},"1.  Beginning Cash on Hand (Cash Basis), or",null,0,0,0,1]
[2,{"$nulls":3},"2.  Working Capital (Accrual Basis)",{"$nulls":4},2]
[3,{"$nulls":3},"3.  Previously Levied Taxes to be Received",{"$nulls":4},3]
[4,{"$nulls":3},"4.  Interest",{"$nulls":4},4]
[5,0,null,null,"5.  Transferred from Other Funds",{"$nulls":4},5]
[6,0,null,null,"6   Proceeds from Sale of Capital Assets",{"$nulls":4},6]
[7,0,{"$f":"SUM(C11:C16)","v":{"v":9446,"d":"9,446"}},{"$f":"SUM(D11:D16)","v":{"v":3439,"d":"3,439"}},"7.  Total Resources, Except Taxes to be Levied",null,0,0,0,7]
[8,{"$nulls":3},"8.  Taxes Estimated to be Received *",{"$nulls":4},"`"]
[9,{"$nulls":3},"9.  Taxes Collected in Year Levied",{"$nulls":4},9]
[10,{"$f":"+B19+B17","v":0},{"v":9446,"d":"9,446"},{"$f":"+D18+D17","v":{"v":3439,"d":"3,439"}},"10.           TOTAL RESOURCES",null,{"$f":"+G18+G17","v":0},{"$f":"+H18+H17","v":0},{"$f":"+I18+I17","v":0},10]
[{"$nulls":4},"Requirements"]
[{"$nulls":4},"Bond Principal Payments"]
[{"$nulls":4},"Bond Issue","Budgeted Payment Date"]
[11,{"v":5330,"d":"5,330"},{"v":5865,"d":"5,865"},0,"11.","9/15/18-6/16/19",{"$nulls":3},11]
[12,{"$nulls":3},"12.",{"$nulls":4},12]
[13,{"$nulls":3},"13.",{"$nulls":4},13]
[14,{"$f":"SUM(B24:B26)","v":{"v":5330,"d":"5,330"}},{"$f":"SUM(C24:C26)","v":{"v":5865,"d":"5,865"}},{"$f":"SUM(D24:D26)","v":0},"14.                     Total Principal",null,{"$f":"SUM(G24:G26)","v":0},0,0,14]
[{"$nulls":4},"Bond Interest Payments"]
[{"$nulls":4},"Bond Issue","Budgeted Payment Date"]
[15,{"v":1740,"d":"1,740"},142,0,"15.","9/15/18-6/16/19",{"$nulls":3},15]
[16,{"$nulls":3},"16.",{"$nulls":4},16]
[17,{"$nulls":3},"17.",{"$nulls":4},17]
[18,{"$f":"SUM(B30:B32)","v":{"v":1740,"d":"1,740"}},{"$f":"SUM(C30:C32)","v":142},{"$f":"SUM(D30:D32)","v":0},"18.                      Total Interest",null,{"$f":"SUM(G30:G32)","v":0},0,0,18]
[{"$nulls":4},"Unappropriated Balance for Following Year By"]
[{"$nulls":4},"Bond Issue","Projected Payment Date"]
[19,{"$nulls":3},"19.",{"$nulls":4},19]
[20,{"$nulls":3},"20.",{"$nulls":4},20]
[21,{"$nulls":3},"21.",{"$nulls":4},21]
[22,0,null,null,"22.   Ending balance (prior years)",{"$nulls":4},22]
[23,null,0,0,"23.   Total Unappropriated Ending Fund Balance",null,0,0,0,23]
[24,null,null,{"v":3439,"d":"3,439"},"24.  Loan Repayment to   General            Fund",null,0,0,0,24]
[25,{"$nulls":3},"25. Tax Credit Bond Reserve",{"$nulls":4},25]
[26,{"$f":"+B27+B33+B39+B41+B42","v":{"v":7070,"d":"7,070"}},{"v":3439,"d":"3,439"},{"$f":"+D27+D33+D36+D37+D38+D40+D41+D42","v":{"v":3439,"d":"3,439"}},"26.          TOTAL REQUIREMENTS",null,{"$f":"G27+G33+G40+G41","v":0},{"$f":"+H27+H33+H36+H37+H38+H40+H41+H42","v":0},{"$f":"+I27+I33+I36+I37+I38+I40+I41+I42","v":0},26]
[null,"150-504-035  (Rev 02-14)",null,"*If this form is used for revenue bonds, property tax resources may not be included."]

{"sheet":"LB-11 Park","index":25,"n_rows":41,"n_cols":9,"rows_kept":41,"merged":[[0,0,0,1],[1,0,1,1],[1,5,1,8],[2,0,2,3],[2,5,2,8],[3,0,3,3],[3,5,3,8],[4,0,4,3],[4,5,4,8],[5,0,5,3],[5,5,5,8],[6,0,9,0],[6,1,6,3],[6,5,6,7],[6,8,9,8],[7,1,7,2]]}
["FORM ",{"$nulls":7}," "]
["LB-11",{"$nulls":3},"RESERVE FUND","Year this reserve fund will be reviewed to be continued or abolished."]
["This fund is authorized and established by resolution / ordinance number",{"$nulls":3},"RESOURCES AND REQUIREMENTS","Date can not be more than 10 years after establishment."]
["09-03 on (date) 03-10-2009 for the following specified purpose:",{"$nulls":4},"Review Year: 2019"]
["To accumulate funds for park projects.",{"$nulls":3},"PARK RECREATIONAL CAPITAL FUND","             CITY OF ADAMS"]
[{"$nulls":4},"(Fund)","(Name of Municipal Corporation) "]
[null,"Historical Data",{"$nulls":3},"Budget for Next Year 2020-21"]
[null,"Actual",null,"Adopted Budget","DESCRIPTION","Proposed By","Approved By","Adopted By"]
[null,"Second Preceding","First Preceding","This Year","RESOURCES AND REQUIREMENTS","Budget Officer","Budget Committee","Governing Body"]
[null,"Year '17-'18","Year '18-'19","19-'20"]
[{"$nulls":4},"RESOURCES  "]
[1,9508,9508,0,"1.  Cash on hand* (cash basis) or",0,0,0,1]
[2,{"$nulls":3},"2.  Working Capital (accrual basis)",{"$nulls":3},2]
[3,{"$nulls":3},"3.  Previously levied taxes estimated to be received",{"$nulls":3},3]
[4,0,null,null,"4.  Interest",{"$nulls":3},4]
[5,{"$nulls":3},"5.  Transferred IN, from other funds-GENERAL: PARK",{"$nulls":3},5]
[6,{"$nulls":3},"6     DONATIONS",{"$nulls":3},6]
[7,{"$nulls":3},"7     GRANTS",{"$nulls":3},7]
[8,{"$nulls":3},"8     MISCELLANEOUS",{"$nulls":3},8]
[9,{"$f":"SUM(B12:B19)","v":9508},9508,9505,"9.  Total Resources, except taxes to be levied",0,0,0,9]
[10,{"$nulls":3},"10.  Taxes estimated to be received",{"$nulls":3},10]
[11,{"$nulls":3},"11.  Taxes collected in year levied",{"$nulls":3},11]
[12,{"$f":"SUM(B20:B22)","v":9508},9508,{"$f":"SUM(D20:D22)","v":9505},"12.  TOTAL RESOURCES",{"$f":"SUM(F20:F22)","v":0},{"$f":"SUM(G20:G22)","v":0},{"$f":"SUM(H20:H22)","v":0},12]
[{"$nulls":4},"REQUIREMENTS"]
[1,{"$nulls":3},1,{"$nulls":3},1]
[2,{"$nulls":3},"2     PARK CAPITAL EXPENDITURES",{"$nulls":3},2]
[3,{"$nulls":3},3,{"$nulls":3},3]
[4,{"$nulls":3},4,{"$nulls":3},4]
[5,9508,9508,9505,"5     TRANSFER TO CAPITAL OUTLAY",0,0,0,5]
[6,{"$nulls":3},6,{"$nulls":3},6]
[7,{"$nulls":3},7,{"$nulls":3},7]
[8,{"$nulls":3},8,{"$nulls":3},8]
[9,{"$nulls":3},9,{"$nulls":3},9]
[10,{"$nulls":3},10,{"$nulls":3},10]
[11,{"$nulls":3},11,{"$nulls":3},11]
[12,{"$nulls":3},12,{"$nulls":3},12]
[13,{"$nulls":3},13,{"$nulls":3},13]
[14,{"$nulls":3},14,{"$nulls":3},14]
[15,{"$nulls":3},15,{"$nulls":3},15]
[16,0,null,null,"16.  RESERVED FOR FUTURE EXPENDITURE",{"$nulls":3},16]
[17,{"$f":"SUM(B26:B40)","v":9508},{"$f":"SUM(C26:C40)","v":9508},{"$f":"D23","v":9505},"17.  TOTAL REQUIREMENTS",0,{"$f":"SUM(G25:G40)","v":0},{"$f":"SUM(H25:H40)","v":0},17]