{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Instructions","Key Inputs","Info","Sheet A","Sheet B","1 - Certification","2 - Resolution","3 - Levy Cap","4 - Revenues","5 - Appropriations","6 - Appropriations","7 - Adoption"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":4,"defined_names":43,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,"General Instructions to Complete the"]
[null,"Solid Waste Collection District (SWCD) Budget Workbook"]
["a)","This workbook shall be used for completing the Solid Waste Collection District Introduced and Adopted Budgets."]
["b)","It is designed to automatically calculate amounts linked from various data entry points. "]
["c)","The individual tabs containing formulas are locked to protect the formulas. "]
["d)","Fill in only the gray sections of the worksheet. "]
["e)","Begin by navigating to the \"Key Inputs\" tab."]
["f)","Select the municipality (and county) by clicking on the arrow on the right side. This will populate the entity name and county.  Continue to complete each of the fields in order to populate standard information throughout the workbook. "]
["g)","In all applicable signature lines, insert the email address of the applicable official. "]
["h)","Once approved by the Governing Body, the completed Introduced Budget must be submitted to the Division via the FAST \"Introduced Budget\" record portal and it must be precisely named as: <municode>_swcd_introbudget_20xx (all 4 digits municode must be included). "]
["i)","Once approved by the Governing Body, the completed Adopted Budget must be submitted to the Division via the FAST \"Adopted Budget\" record portal and it must be precisely named as: <municode>_swcd_adoptbudget_20xx (all 4 digits municode must be included). "]
["j)","Only the Chief Financial Officer has access to the \"Submit for Review\" tab within the FAST portal."]
["k)","If copying data from a prior workbook, utilize the copy and paste-special values functionality built into Excel to preserve formatting. "]

{"sheet":"Key Inputs","index":1,"n_rows":55,"n_cols":12,"rows_kept":55,"cut":false,"hidden":false,"merged":[[2,4,2,5],[38,6,38,7],[49,2,49,4],[1,4,1,5]]}
[]
[null,null,"Information Required for",null,"SWCD Budget Version 2023.1"]
[null,null,"SWCD Budget Document:",null,"Responses and Data"]
[null,null,"Name and County of Municipality",null,1]
[null,null,"Full Name of Municipality",null,{"$f":"UPPER(VLOOKUP($E$4,Info!A1:K16,8,FALSE)&\" Of \"&VLOOKUP($E$4,Info!A1:K16,7,FALSE))","v":" OF MUNICIPALITY"}]
[null,"DLGS","County of Municipality",null,{"$f":"UPPER(VLOOKUP($E$4,Info!A1:K15,4,FALSE))","v":"COUNTY"},null,null,null,null,null,null,"DLGS"]
[null,null,"Name of Municipality",null,{"$f":"UPPER(VLOOKUP($E$4,Info!A1:K15,7,FALSE))","v":"MUNICIPALITY"}]
[null,null,"Type ",null,{"$f":"UPPER(VLOOKUP($E$4,Info!A1:K15,8,FALSE))","v":""}]
[null,null,"Governing Body Type",null,{"$f":"UPPER(VLOOKUP($E$4,Info!A1:K15,9,FALSE))","v":""}]
[null,null,"Location"]
[null,null,"Address"]
[null,null,"Address"]
[null,null,"Phone "]
[null,null,"Fax"]
[null,null,null,null,null,null,"Cert  #","Date of Original Appt. "]
[null,null,"Clerk"]
[null,null,"Tax Collector"]
[null,null,"Chief Financial Officer"]
[null,null,"Registered Municipal Accountant"]
[null,null,"Municipal Attorney"]
[]
[null,null,"Newspaper"]
[]
[null,null,null,null,"Day","Month"]
[null,null,"Date of Introduction"]
[null,null,"Date of Advertisement"]
[null,null,"Date of Public Hearing"]
[]
[null,null,"Time of Public Hearing"]
[]
[null,null,"Net Valuation Taxable Current"]
[null,null,"Net Valuation Taxable Prior"]
[null,null,null,null,null,{"$f":"+F31-F32","v":0}]
[null,null,"Budget Year",null,"2023","Budget Year Type:","Calendar Year"]
[]
[null,null,"Municipal Code",null,{"$f":"VLOOKUP($E$4,Info!A1:K15,2,FALSE)","v":"0000"}]
[]
[null,null,"How many utilities does municipality have?",null,0]
[null,null,"Utility #",null,"Utility Type",null,"Capital Improvement Program"]
[null,null,"Utility 1",null,null,null,"# of Years",6]
[null,null,"Utility 2",null,null,null,"Beginning Year",{"$f":"+E34","v":"2023"}]
[null,null,"Utility 3",null,null,null,"Ending Year",{"$f":"+H41+H40-1","v":2028}]
[null,null,"Utility 4"]
[null,null,"Utility 5"]
[null,null,"Utility 6"]
[]
[null,null,"Utility Assessment (Tab 37)"]
[null,null,"Utility Assessment (Tab 38)"]
[]
[null,null,"Page Count - Standard or Expanded:"]
[null,null,"Grant Revenues (Sheet 9)",null,"Standard"]
[null,null,"Other Special Item Revenues (Sheet 10)",null,"Standard"]
[null,null,"General Appropriations (Sheet 15)",null,"Standard"]
[null,null,"Grant Appropriations (Sheet 24)",null,"Standard"]
[null,null,"Capital Improvements (Sheets 40b, 40c, 40d)",null,"Standard"]

{"sheet":"Info","index":2,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[null,"Muncode","Town","County","Town Name","Name of Municipality","Muniname","Type of Government","Governing Body Members","Governing Body Type","2020 Census Population"]
[1,"0000","MUNICIPALITY","COUNTY","PLEASE SELECT A MUNICIPALITY","MUNICIPALITY","MUNICIPALITY"]
[2,"1330","Aberdeen Township","Monmouth","Aberdeen Township, Monmouth County","Aberdeen Township","Aberdeen","Township","Council Members","Mayor-6 Council Members",19329]
[{"$f":"A3+1","v":3},"2101","Allamuchy Township","Warren","Allamuchy Township, Warren County","Allamuchy Township","Allamuchy","Township","Council Members","Mayor-4 Council Members",4323]
[{"$f":"A4+1","v":4},"0704","Cedar Grove Township","Essex","Cedar Grove Township, Essex County","Cedar Grove Township","Cedar Grove","Township","Council Members","5 Council Members",12980]
[5,"1101","East Windsor Township","Mercer","East Windsor Township, Mercer County","East Windsor Township","East Windsor","Township","Council Members","7 Council Members",30045]
[6,"1205","Edison Township","Middlesex","Edison Township, Middlesex County","Edison Township","Edison","Township","Council Members","Mayor-7 Council Members",107588]
[7,"1414","Jefferson Township","Morris","Jefferson Township, Morris County","Jefferson Township","Jefferson","Township","Council Members","Mayor-5 Council Members",20538]
[8,"1331","Middletown Township","Monmouth","Middletown Township, Monmouth County","Middletown Township","Middletown","Township","Council Members","5 Council Members",67106]
[9,"1420","Mine Hill Township","Morris","Mine Hill Township, Morris County","Mine Hill Township","Mine Hill","Township","Council Members","Mayor-5 Council Members",4015]
[10,"1427","Mount Olive Township","Morris","Mount Olive Township, Morris County","Mount Olive Township","Mount Olive","Township","Council Members","Mayor-6 Council Members",28886]
[11,"0427","Pennsauken Township","Camden","Pennsauken Township, Camden County","Pennsauken Township","Pennsauken","Township","Committeepersons","5 Committee Members",37074]
[12,"0911","Weehawken Township","Hudson","Weehawken Township, Hudson County","Weehawken Township","Weehawken","Township","Council Members","5 Council Members",17197]
[13,"1615","West Milford Township","Passaic","West Milford Township, Passaic County","West Milford Township","West Milford","Township","Council Members","Mayor-6 Council Members",24862]
[14,"1439","Wharton Borough","Morris","Wharton Borough, Morris County","Wharton","Wharton","Borough","Council Members","Mayor-6 Council Members",7241]

{"sheet":"Sheet A","index":3,"n_rows":37,"n_cols":14,"rows_kept":37,"cut":false,"hidden":false,"merged":[[12,2,12,3],[24,2,24,3],[30,9,34,13],[13,13,14,13],[15,13,16,13],[17,13,18,13],[19,13,20,13],[21,13,22,13],[33,2,33,5],[23,2,23,3],[27,2,27,3],[28,2,28,3],[25,2,26,3],[31,2,31,5],[32,2,32,5],[13,4,16,4],[36,6,36,8],[11,9,11,11],[12,9,12,11],[13,9,14,11],[15,9,16,11],[17,9,18,11],[19,9,20,11],[21,9,22,11],[23,9,24,11],[29,9,29,13],[23,13,24,13],[25,13,26,13],[25,9,26,11],[27,9,27,11],[29,2,29,5],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[1,1,1,14],[10,2,10,3],[9,2,9,3],[9,9,9,11],[5,4,5,8],[7,8,7,14],[8,2,8,3],[3,4,3,10],[2,1,2,14]]}
[]
[null,{"$f":"'Key Inputs'!E34&\"  MUNICIPAL  DATA  SHEET\"","v":"2023  MUNICIPAL  DATA  SHEET"}]
[null,"OF A SOLID WASTE COLLECTION DISTRICT"]
[null,null,null,null,{"$f":"\"(MUST ACCOMPANY \"&'Key Inputs'!E34&\" BUDGET)\"","v":"(MUST ACCOMPANY 2023 BUDGET)"}]
[]
[null,null,null,"MUNICIPALITY:",{"$f":"+'Key Inputs'!E5","v":" OF MUNICIPALITY"},null,null,null,null,null,"COUNTY:",{"$f":"+'Key Inputs'!E6","v":"COUNTY"}]
[]
[null,null,null,null,null,null,null,null,"Governing  Body  Members"]
[]
[null,null,"Mayor's Name",null,null,"Term Expires",null,null,null,"Name",null,null,null,"Term Expires"]
[]
[]
[null,null,"Municipal  Officials"]
[null,null,null,null,"{",{"$f":"+'Key Inputs'!H16","v":"00:00:00"}]
[null,null,null,null,null,"Date of Orig. Appt."]
[null,null,{"$f":"+'Key Inputs'!E16","v":0},null,null,{"$f":"+'Key Inputs'!G16","v":0}]
[null,null,"Municipal Clerk",null,null,"Cert. No."]
[null,null,{"$f":"+'Key Inputs'!E17","v":0},null,null,{"$f":"+'Key Inputs'!G17","v":0}]
[null,null,"Tax Collector",null,null,"Cert. No."]
[null,null,{"$f":"+'Key Inputs'!E18","v":0},null,null,{"$f":"+'Key Inputs'!G18","v":0}]
[null,null,"Chief Financial Officer",null,null,"Cert. No."]
[null,null,{"$f":"+'Key Inputs'!E19","v":0},null,null,{"$f":"+'Key Inputs'!G19","v":0}]
[null,null,"Registered Municipal Accountant",null,null,"Lic. No."]
[null,null,{"$f":"+'Key Inputs'!E20","v":0}]
[null,null,"Municipal Attorney"]
[]
[]
[]
[]
[null,null,"Official Mailing Address of Solid Waste Collection District"]
[null,null,null,null,null,null,null,null,null,"Pursuant to Public Law 2002, Chapter 126 - N.J.S.A. 40:66-10 is ameded to read: \"any municipality which operates a \"Solid Waste Collection District\" as of December 31, 1989, shall determine the amount of money necessary for the support of the solid waste collection district.  The amount so determined shall become part of the municipal budget and subject to approval by the director\"."]
[null,null,{"$f":"+'Key Inputs'!E10","v":0}]
[null,null,{"$f":"+'Key Inputs'!E11","v":0}]
[null,null,{"$f":"+'Key Inputs'!E12","v":0}]
[]
[null,null,"Fax #:",{"$f":"+'Key Inputs'!E14","v":0}]
[null,null,null,null,null,null,"Sheet  A"]

{"sheet":"Sheet B","index":4,"n_rows":45,"n_cols":2,"rows_kept":45,"cut":false,"hidden":false,"merged":[[2,1,2,15],[3,1,3,15],[44,1,44,15],[6,1,6,15],[7,1,7,15],[10,1,14,15],[19,1,22,15],[25,1,29,15],[33,1,36,15],[39,1,43,15]]}
[]
[]
[null,"New Jersey Department of Community Affairs"]
[null,"Division of Local Government Services"]
[]
[]
[null,"Budget Approval of a Solid Waste Collection District"]
[null,"(P.L. 2001, c. 126)"]
[]
[null,"1. Please describe the services provided by the Solid Waste Collection District (SWCD) (i.e. collection, disposal, tipping fees, etc.):"]
[]
[]
[]
[]
[]
[]
[null,"2. What percentage of your municipality is serviced by the district? "]
[null,"If you are requesting an expansion of the district, please provide a map showing the current district and the proposed expansion.  Also explain the background, fiscal impact on  "]
[null,"the district's budget, and reasons to expand the district (attach additional documentation if necessary). "]
[]
[]
[]
[]
[]
[null,"3. If less than 100% of the municipality is in the district, what arrangements are made for the provision of trash removal to the balance of the municipality?"]
[]
[]
[]
[]
[]
[]
[null,"4. Are services provided by municipal employees or are they contractural?  If contractural, please state the name of the vendor, contract period, services provided and "]
[null,"maximum contract amount. "]
[]
[]
[]
[]
[]
[null,"5. Do the employees of the district provide any other services in the municipality other than trash removal?  If so, please explain. "]
[]
[]
[]
[]
[]
[null,"Sheet B"]

{"sheet":"1 - Certification","index":5,"n_rows":44,"n_cols":21,"rows_kept":44,"cut":false,"hidden":false,"merged":[[24,2,24,5],[10,2,10,3],[10,5,10,7],[13,8,13,9],[21,4,21,5],[23,2,23,5],[21,7,21,8],[23,7,23,9],[24,7,24,9],[24,15,24,18],[8,16,8,19],[10,16,10,19],[12,16,12,19],[13,16,13,19],[14,16,14,19],[43,1,43,20],[41,17,41,20],[28,8,28,14],[25,15,25,18],[32,1,32,9],[32,11,32,20],[25,2,25,5],[26,2,26,5],[25,7,25,9],[26,7,26,9],[33,2,33,9],[1,1,1,20],[4,4,4,7],[4,15,4,17],[4,9,4,13],[22,15,22,16],[7,16,7,19],[9,16,9,19],[11,16,11,19],[2,1,2,20],[22,18,22,19]]}
[]
[null,{"$f":"'Key Inputs'!E34","v":"2023"}]
[null,"SOLID WASTE COLLECTION DISTRICT BUDGET"]
[]
[null,"Solid Waste Collection District Budget of the",null,null,{"$f":"+'Key Inputs'!E8","v":""},null,null,null,"of",{"$f":"+'Key Inputs'!E7","v":"MUNICIPALITY"},null,null,null,null,", County of",{"$f":"+'Key Inputs'!E6","v":"COUNTY"},null,null,{"$f":"\"for the Fiscal Year \"&'Key Inputs'!E34&\".\"","v":"for the Fiscal Year 2023."}]
[]
[]
[null,null,null,"It is hereby certified that the Budget and Capital Budget annexed hereto and hereby made a part"]
[null,null,"hereof is a true copy of the Budget and Capital Budget approved by resolution of the Governing Body on the",null,null,null,null,null,null,null,null,null,null,null,null,null,"Clerk"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+'Key Inputs'!E11","v":0}]
[null,null,{"$f":"+'Key Inputs'!E25","v":0},null,"day of",{"$f":"+'Key Inputs'!F25","v":0},null,null,{"$f":"IF(Budget_Year_Type = \"Calendar Year\", \", \"&'Key Inputs'!E34&\"\",\", \"&'Key Inputs'!E34-1&\"\")","v":", 2023"},null,null,null,null,null,null,null,"Address"]
[null,null,"and that public advertisement will be made in accordance with the provisions of N.J.S.A. 40A:4-6 and",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+'Key Inputs'!E12","v":0}]
[null,null,"N.J.A.C. 5:30-4.4(d).",null,null,null,null,null,null,null,null,null,null,null,null,null,"Address"]
[null,null,null,null,"Certified by me, this ",null,{"$f":"+'Key Inputs'!E25","v":0},"day of",{"$f":"+'Key Inputs'!F25","v":0},null,{"$f":"IF(Budget_Year_Type = \"Calendar Year\", \", \"&'Key Inputs'!E34&\"\",\", \"&'Key Inputs'!E34-1&\"\")","v":", 2023"},null,null,null,null,null,{"$f":"+'Key Inputs'!E13","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone Number"]
[]
[null,null,null,"It is hereby certified that the approved Budget annexed hereto and hereby made",null,null,null,null,null,null,null,null,null,null,"It is hereby certified that the approved Budget annexed hereto and hereby made"]
[null,null,"a part is an exact copy of the original on file with the Clerk of the Governing Body, that all",null,null,null,null,null,null,null,null,null,null,"a part is an exact copy of the original on file with the Clerk of the Governing Body, that all"]
[null,null,"additions are correct, all statements contained herein are in proof, and the total of anticipated",null,null,null,null,null,null,null,null,null,null,"additions are correct, all statements contained herein are in proof, the total of anticipated"]
[null,null,"revenues equals the total of appropriations.",null,null,null,null,null,null,null,null,null,null,"revenues equals the total of appropriations and the budget is in full compliance with the"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Local Budget Law, N.J.S.A. 40A:4-1 et seq."]
[null,null,null,"Certified by me, this ",{"$f":"+'Key Inputs'!E25","v":0},null,"day of",{"$f":"+'Key Inputs'!F25","v":0},null,{"$f":"IF(Budget_Year_Type = \"Calendar Year\", \", \"&'Key Inputs'!E34&\"\",\", \"&'Key Inputs'!E34-1&\"\")","v":", 2023"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Certified by me, this",null,{"$f":"+'Key Inputs'!E25","v":0},null,"day of",{"$f":"+'Key Inputs'!F25","v":0},null,{"$f":"IF(Budget_Year_Type = \"Calendar Year\", \", \"&'Key Inputs'!E34&\"\",\", \"&'Key Inputs'!E34-1&\"\")","v":", 2023"}]
[]
[null,null,"Registered Municipal Accountant",null,null,null,null,"Address"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chief Financial Officer"]
[null,null,"Address",null,null,null,null,"Phone Number"]
[]
[null,null,null,null,null,null,null,null,"DO  NOT  USE  THESE  SPACES"]
[]
[]
[]
[null,"CERTIFICATION  OF  ADOPTED  BUDGET"]
[null,null,"(Do not advertise this Certification form)"]
[null,null,"It is hereby certified that the amounts to be raised by taxation for local purposes has been"]
[null,null,"compared with the approved Budget previously certified by me and any changes required as a"]
[null,null,"condition to such approval have been made. The adopted budget is certified with respect to the"]
[null,null,"foregoing only. "]
[null,null,null,null,null,"STATE OF NEW JERSEY"]
[null,null,null,null,null,"Department of Community Affairs"]
[null,null,null,null,null,"Director of the Division of Local Government Services"]
[null,null,"Dated:",null,{"$f":"\", \"&'Key Inputs'!E34","v":", 2023"},"By:"]
[]
[null,"Sheet  1"]

{"sheet":"2 - Resolution","index":6,"n_rows":39,"n_cols":19,"rows_kept":39,"cut":false,"hidden":false,"merged":[[1,1,1,18],[38,1,38,18],[5,5,5,7],[9,10,9,14],[13,5,13,7],[13,9,13,12],[32,14,32,15],[5,15,5,17],[28,11,28,14],[28,16,28,18],[32,9,32,12],[5,9,5,13],[11,4,11,6],[30,12,30,13],[30,2,30,6],[30,9,30,10]]}
[]
[null,"SOLID  WASTE  COLLECTION  DISTRICT  BUDGET  RESOLUTION"]
[]
[null,"Section  1."]
[]
[null,null,"Solid Waste Collection District Budget of the",null,null,{"$f":"+'Key Inputs'!E8","v":""},null,null,"of",{"$f":"+'Key Inputs'!E7","v":"MUNICIPALITY"},null,null,null,null,", County of",{"$f":"+'Key Inputs'!E6","v":"COUNTY"},null,null,{"$f":"\"for the Fiscal Year \"&'Key Inputs'!E34","v":"for the Fiscal Year 2023"}]
[]
[null,null,{"$f":"\"Be it Resolved, that the following statements of revenues and appropriations shall constitute the Solid Waste Collection District Budget for the year \"&'Key Inputs'!E34&\";\"","v":"Be it Resolved, that the following statements of revenues and appropriations shall constitute the Solid Waste Collection District Budget for the year 2023;"}]
[]
[null,null,"Be it Further Resolved, that said Budget be published in the",null,null,null,null,null,null,null,{"$f":"+'Key Inputs'!E22","v":0}]
[]
[null,null,"in  the  issue of ",null,{"$f":"+'Key Inputs'!F26&\"    \"&'Key Inputs'!E26","v":"    "},null,null,{"$f":"IF(Budget_Year_Type = \"Calendar Year\", \", \"&'Key Inputs'!E34&\"\",\", \"&'Key Inputs'!E34-1&\"\")","v":", 2023"}]
[]
[null,null,"The Governing Body of the",null,null,{"$f":"+'Key Inputs'!E8","v":""},null,null,"of",{"$f":"+'Key Inputs'!E7","v":"MUNICIPALITY"},null,null,null,{"$f":"\"does hereby approve the following as the Budget for the year \"&'Key Inputs'!E34&\":\"","v":"does hereby approve the following as the Budget for the year 2023:"}]
[]
[]
[]
[null,null,null,"RECORDED  VOTE",null,null,null,null,null,null,null,null,null,"Abstained"]
[null,null,null,"(Insert last name)"]
[]
[null,null,null,null,null,"Ayes",null,null,null,"Nays"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Absent"]
[]
[]
[]
[]
[null,null,"Notice is hereby given that the Budget and Tax Resolution was approved by the",null,null,null,null,null,null,null,null,{"$f":"+'Key Inputs'!E9","v":""},null,null,null,"of  the",{"$f":"+'Key Inputs'!E8","v":""}]
[]
[null,"of",{"$f":"'Key Inputs'!E7","v":"MUNICIPALITY"},null,null,null,null,",  County  of",null,{"$f":"+'Key Inputs'!E6","v":"COUNTY"},null,", on",{"$f":"+'Key Inputs'!F25","v":0},null,{"$f":"+'Key Inputs'!E25","v":0},{"$f":"IF(Budget_Year_Type = \"Calendar Year\", \", \"&'Key Inputs'!E34&\".\",\", \"&'Key Inputs'!E34-1&\".\")","v":", 2023."}]
[]
[null,null,"A Hearing on the Budget and Tax Resolution will be held at",null,null,null,null,null,null,{"$f":"+'Key Inputs'!E10","v":0},null,null,null,", on",{"$f":"+'Key Inputs'!F27","v":0},null,{"$f":"+'Key Inputs'!E27","v":0},{"$f":"IF(Budget_Year_Type = \"Calendar Year\", \", \"&'Key Inputs'!E34&\" at\",\", \"&'Key Inputs'!E34-1&\" at\")","v":", 2023 at"}]
[]
[null,{"$f":"+'Key Inputs'!E29","v":0},{"$f":"\"o'clock\"","v":"o'clock"},null,{"$f":"\"at which time and place objections to said Budget and Tax Resolution for the year \"&'Key Inputs'!E34&\" may be presented by taxpayers or other\"","v":"at which time and place objections to said Budget and Tax Resolution for the year 2023 may be presented by taxpayers or other"}]
[]
[null,"interested persons."]
[]
[null,"Sheet  2"]

{"sheet":"3 - Levy Cap","index":7,"n_rows":45,"n_cols":24,"rows_kept":45,"cut":false,"hidden":false,"merged":[[3,6,3,15],[1,6,1,15],[35,10,35,11],[5,11,5,19],[5,2,5,9]]}
[]
[null,null,null,null,null,null,"EXPLANATORY  STATEMENT  -  (Continued)"]
[]
[null,null,null,null,null,null,"BUDGET  MESSAGE"]
[]
[null,null,"Appropriation \"CAPS\"",null,null,null,null,null,null,null,null,"LEVY  CAP  CALCULATION"]
[]
[null,null,"N.J.S.A. 40A:4-45.44 through 45.47 established a formula that limits increase in each",null,null,null,null,null,null,null,null,"Prior Year Amount to be Raised by Taxation for Special District Purpose:"]
[null,null,{"$f":"\"local unit's 'Amount to be Raised by Taxation'.  The Tax Levy Cap for the year \"&'Key Inputs'!E34&\"\"","v":"local unit's 'Amount to be Raised by Taxation'.  The Tax Levy Cap for the year 2023"},null,null,null,null,null,null,null,null,null,"Less: Prior Year Capital Improvement Fund & Down Payments:"]
[null,null,"is calculated as follows:",null,null,null,null,null,null,null,null,null,"Less: Prior Year Deferred Charges to Future Taxation Unfunded:",null,null,null,null,null,null,null,null,null,null,"New Construction"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Net Prior Year Tax Levy for Special District Tax for Cap Calculation:",null,null,null,null,null,null,null,{"$f":"TRUNC(T8-T9-T10)","v":0},null,null,{"$f":"+W10/100","v":0},"Divided by 100"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Plus: 2% CAP Increase",null,null,null,null,null,null,{"$f":"TRUNC(T12*0.02)","v":0},null,null,null,"Rate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+W12*W13","v":0},"Addition Amount"]
[null,null,null,null,null,null,null,null,null,null,null,"Adjusted Tax Levy Prior to Exclusion",null,null,null,null,null,null,null,{"$f":"TRUNC(T12+T13)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Exclusions:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Changes in Debt Service & Existing County Leases"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Allowable Pension Increases"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Allowable Health Benefit Increases"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Capital Imp. Fund and/or Down Payment on Improvements"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Deferred Charges to Future Taxation Unfunded"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Exlucisons",null,null,null,null,{"$f":"TRUNC(SUM(S18:S22))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Less: Cancelled or Unexpended Exclusions"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Adjusted Tax Levy",null,null,null,null,null,null,null,{"$f":"TRUNC(T15+T23-T24)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Additions:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"New Ratables - Increase on Valuations",null,null,null,null,{"$f":"TRUNC(W14)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"CAP Bank Utilized in Current Year"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Maximum Allowable Amount to be Raised by Taxation",null,null,null,null,null,null,null,{"$f":"TRUNC(T26+S28+S29)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Amount to be Raised by Taxation for Municipal Purposes",null,null,null,null,null,null,null,{"$f":"TRUNC('4 - Revenues'!J25)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Amount of Levy CAP Remaining",null,null,null,null,null,null,null,{"$f":"TRUNC(T31-T32)","v":0}]
[]
[]
[null,"NOTE:",null,null,null,null,null,null,null,null,"Sheet  3"]
[null,null,"MANDATORY MINIMUM BUDGET MESSAGE MUST INCLUDE A SUMMARY OF:"]
[null,null,null,"1. HOW THE \"CAP\" WAS CALCULATED. (Explain in words what the \"CAPS\" mean and show the figures.)"]
[null,null,null,"2. A SUMMARY BY FUNCTION OF THE APPROPRIATIONS THAT ARE SPREAD AMONG MORE THAN ONE OFFICIAL LINE ITEM"]
[null,null,null,null,"(e.g. if Police  S & W appears in the regular section and also under \"Operation Excluded from \"CAPS\" section, combine the"]
[null,null,null,null,"figures for purposes of citizen understanding.)"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+I30+S26","v":0}]

{"sheet":"4 - Revenues","index":8,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,2,26,13],[1,2,1,11],[2,9,2,10],[3,2,3,7],[5,4,5,7],[20,4,20,7]]}
[]
[null,null,"SOLID WASTE COLLECTION DISTRICT BUDGET"]
[null,null,null,null,null,null,null,null,null,"Anticipated",null,"Realized in"]
[null,null,"REVENUES FROM SOLID WASTE COLLECTION DISTRICT",null,null,null,null,null,"FCOA",{"$f":"'Key Inputs'!E34","v":"2023"},{"$f":"J4-1","v":2022},{"$f":"\"Cash in \"&K4","v":"Cash in 2022"}]
[null,null,null,null,"Operating  Surplus  Anticipated"]
[null,null,null,null,"Operating Surplus  Anticipated with Prior Written Consent of Director of Local Government Services"]
[null,null,null,null,null,null,"Total Operating Surplus Anticipated",null,null,{"$f":"+J5+J6","v":0},{"$f":"+K5+K6","v":0},{"$f":"+L5+L6","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Special Items of General Revenues Anticipated with Prior Written Consent of Director of Local Governement Services",null,null,null,"XXXXXX","XXXXXXXXXX","XXXXXXXXXX","XXXXXXXXXX"]
[]
[]
[]
[null,null,null,null,"Amount to be Raised by Taxation for Support of Solid Waste Collection District",null,null,null,null,{"$f":"'6 - Appropriations'!H25-SUM(J7:J24)","v":0},{"$f":"'6 - Appropriations'!I25-SUM('4 - Revenues'!K7:K24)","v":0},{"$f":"K25","v":0}]
[null,null,null,null,null,"TOTAL - Solid Waste Collection District Revenues",null,null,null,{"$f":"SUM(J7:J25)","v":0},{"$f":"SUM(K7:K25)","v":0},{"$f":"SUM(L7:L25)","v":0}]
[null,null,"Sheet  4"]

{"sheet":"5 - Appropriations","index":9,"n_rows":27,"n_cols":18,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,1,1,12],[2,7,2,10],[2,11,2,12],[26,1,26,12]]}
[]
[null,"SOLID WASTE COLLECTION DISTRICT BUDGET"]
[null,null,null,null,null,null,null,"Appropriated",null,null,null,{"$f":"\"Expended \"&'Key Inputs'!E34-1","v":"Expended 2022"}]
[null,null,"APPROPRIATIONS FOR SOLID WASTE COLLECTION",null,null,null,"FCOA",null,null,{"$f":"\"for \"&'Key Inputs'!E34-1&\"  By\"","v":"for 2022  By"},{"$f":"\"Total for \"&'Key Inputs'!E34-1","v":"Total for 2022"}]
[null,null,"DISTRICT ",null,null,null,null,{"$f":"\"for  \"&'Key Inputs'!E34","v":"for  2023"},{"$f":"\"for  \"&'Key Inputs'!E34-1","v":"for  2022"},"Emergency","As Modified By","Paid or","Reserved",null,"Canceled",null,null,"Transfers"]
[null,null,null,null,null,null,null,null,null,"Appropriation","All Transfers","Charged"]
[null,null,"Operating:",null,null,null,"XXXXXX","XXXXXXXXXX","XXXXXXXXXX","XXXXXXXXXX","XXXXXXXXXX","XXXXXXXXXX","XXXXXXXXXX"]
[null,null,null,null,"Salaries & Wages",null,null,null,null,null,{"$f":"IF(R8=\"\",I8,I8+R8)","v":0},null,{"$f":"IFERROR(IF(+K8-L8>=0,K8-L8,\"*\")-O8,\"*\")","v":0}]
[null,null,null,null,"Other Expenses",null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Sheet  5"]

{"sheet":"6 - Appropriations","index":10,"n_rows":26,"n_cols":17,"rows_kept":26,"cut":false,"hidden":false,"merged":[[14,12,15,12],[1,1,1,12],[2,11,2,12],[2,7,2,10],[25,1,25,12],[17,4,17,5],[14,7,15,7],[14,8,15,8],[14,9,15,9],[14,10,15,10],[14,11,15,11]]}
[]
[null,"SOLID WASTE COLLECTION DISTRICT BUDGET"]
[null,null,null,null,null,null,null,"Appropriated",null,null,null,{"$f":"\"Expended \"&'Key Inputs'!E34-1","v":"Expended 2022"}]
[null,"APPROPRIATIONS FOR SOLID WASTE COLLECTION",null,null,null,null,"FCOA",null,null,{"$f":"\"for \"&'Key Inputs'!E34-1&\"  By\"","v":"for 2022  By"},{"$f":"\"Total for \"&'Key Inputs'!E34-1","v":"Total for 2022"}]
[null,"DISTRICT",null,null,null,null,null,{"$f":"\"for  \"&'Key Inputs'!E34","v":"for  2023"},{"$f":"\"for  \"&'Key Inputs'!E34-1","v":"for  2022"},"Emergency","As Modified By","Paid or","Reserved",null,"Canceled",null,"Transfers"]
[null,null,null,null,null,null,null,null,null,"Appropriation","All Transfers","Charged"]
[null,null,"Deferred Charges and Statutory Expenditures:",null,null,null,"XXXXXX","XXXXXXXXXX","XXXXXXXXXX","XXXXXXXXXX","XXXXXXXXXX","XXXXXXXXXX","XXXXXXXXXX"]
[null,null,null,"DEFERRED CHARGES:",null,null,"XXXXXX","XXXXXXXXXX","XXXXXXXXXX","XXXXXXXXXX","XXXXXXXXXX","XXXXXXXXXX","XXXXXXXXXX"]
[null,null,null,null,"Emergency Authorizations",null,null,null,null,"XXXXXXXXXX",{"$f":"IF(Q9=\"\",I9,I9+Q9)","v":0},null,"XXXXXXXXXX",null,{"$f":"K9-L9","v":0}]
[null,null,null,null,null,null,null,null,null,"XXXXXXXXXX",{"$f":"IF(Q10=\"\",I10,I10+Q10)","v":0},null,"XXXXXXXXXX",null,{"$f":"K10-L10","v":0}]
[null,null,null,null,null,null,null,null,null,"XXXXXXXXXX",{"$f":"IF(Q11=\"\",I11,I11+Q11)","v":0},null,"XXXXXXXXXX",null,{"$f":"K11-L11","v":0}]
[null,null,null,null,null,null,null,null,null,"XXXXXXXXXX",{"$f":"IF(Q12=\"\",I12,I12+Q12)","v":0},null,"XXXXXXXXXX",null,{"$f":"K12-L12","v":0}]
[null,null,null,null,null,null,null,null,null,"XXXXXXXXXX",{"$f":"IF(Q13=\"\",I13,I13+Q13)","v":0},null,"XXXXXXXXXX",null,{"$f":"K13-L13","v":0}]
[null,null,null,"STATUTORY  EXPENDITURES:",null,null,"XXXXXX","XXXXXXXXXX","XXXXXXXXXX","XXXXXXXXXX","XXXXXXXXXX","XXXXXXXXXX","XXXXXXXXXX"]
[null,null,null,null,"Contribution To:",null,null,null,null,null,{"$f":"IF(Q16=\"\",I15,I15+Q16)","v":0},null,{"$f":"IFERROR(IF(+K15-L15>=0,K15-L15,\"*\")-O16,\"*\")","v":0}]
[null,null,null,null,null,"Public Employee's Retirement System"]
[null,null,null,null,null,"Social Security System  (O.A.S.I.)",null,null,null,null,{"$f":"IF(Q17=\"\",I17,I17+Q17)","v":0},null,{"$f":"IFERROR(IF(+K17-L17>=0,K17-L17,\"*\")-O17,\"*\")","v":0}]
[null,null,null,null,"Unemployment  Compensation  Insurance                      (N.J.S.A. 43:21-3 et. Seq.)",null,null,null,null,null,0,null,{"$f":"IFERROR(IF(+K18-L18>=0,K18-L18,\"*\")-O18,\"*\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(IF(+K19-L19>=0,K19-L19,\"*\")-O19,\"*\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(IF(+K20-L20>=0,K20-L20,\"*\")-O20,\"*\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(IF(+K21-L21>=0,K21-L21,\"*\")-O21,\"*\")","v":0}]
[null,null,"Judgements",null,null,null,null,null,null,null,0,null,"XXXXXXXXXX",null,{"$f":"K22-L22","v":0}]
[null,null,"Deficit in Operations in Prior Years",null,null,null,null,null,null,"XXXXXXXXXX",0,null,"XXXXXXXXXX",null,{"$f":"K23-L23","v":0}]
[null,null,"Surplus  (General  Budget )",null,null,null,null,null,null,"XXXXXXXXXX",0,null,"XXXXXXXXXX",null,{"$f":"K24-L24","v":0}]
[null,null,"Total Solid Waste Collection District Appropriations",null,null,null,null,{"$f":"+SUM(H9:H24)+SUM('5 - Appropriations'!H8:H26)","v":0},{"$f":"+SUM(I9:I24)+SUM('5 - Appropriations'!I8:I26)","v":0},{"$f":"+SUM(J9:J24)+SUM('5 - Appropriations'!J8:J26)","v":0},{"$f":"+SUM(K9:K24)+SUM('5 - Appropriations'!K8:K26)","v":0},{"$f":"+SUM(L9:L24)+SUM('5 - Appropriations'!L8:L26)","v":0},{"$f":"+SUM(M9:M24)+SUM('5 - Appropriations'!M8:M26)","v":0},null,{"$f":"K25-L25-M25","v":0}]
[null,"Sheet 6"]

{"sheet":"7 - Adoption","index":11,"n_rows":52,"n_cols":20,"rows_kept":52,"cut":false,"hidden":false,"merged":[[40,12,40,14],[41,12,41,14],[36,15,36,16],[42,1,42,16],[21,1,21,16],[7,3,7,5],[4,9,4,12],[1,1,1,16],[2,1,2,16],[4,2,4,7],[3,5,3,9],[3,11,3,16]]}
[]
[null,{"$f":"\"SECTION  2 - UPON  ADOPTION  FOR  YEAR  \"&'Key Inputs'!E34","v":"SECTION  2 - UPON  ADOPTION  FOR  YEAR  2023"}]
[null,{"$f":"\"RESOLUTION \"&T10&\"\"","v":"RESOLUTION "}]
[null,"Be it Resolved by the ",null,null,null,{"$f":"+'Key Inputs'!E9","v":""},null,null,null,null,"of the",{"$f":"+'Key Inputs'!E8","v":""}]
[null,"of",{"$f":"+'Key Inputs'!E7","v":"MUNICIPALITY"},null,null,null,null,null,",County of",{"$f":"+'Key Inputs'!E6","v":"COUNTY"},null,null,null,"that the budget hereinbefore set forth is hereby"]
[null,"adopted and shall constitute an appropriation for the purposes stated of the sums therein set forth as appropriations, and authorization of the amount of:"]
[]
[null,null,"(a) $",{"$f":"+Q26","v":0},null,null,"  (Item 2 below) for Solid Waste Collection District"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Resolution #"]
[]
[null,null,"RECORDED  VOTE",null,null,null,null,null,null,null,null,null,null,null,"Abstained"]
[null,null,"(Insert last name)"]
[]
[null,null,null,null,null,null,"Ayes",null,null,null,"Nays"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Absent"]
[]
[]
[]
[]
[null,"SUMMARY  OF  REVENUES  AND APPROPRIATIONS"]
[null,"1.","GENERAL REVENUES"]
[null,null,null,"Surplus Anticipated",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'4 - Revenues'!J7","v":0}]
[null,null,null,"Miscellaneous Revenues Anticipated",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'4 - Revenues'!J26-'4 - Revenues'!J25-'4 - Revenues'!J7","v":0}]
[null,"2.","AMOUNT  TO  BE  RAISED  BY  TAXATION  FOR  SOLID  WASTE  COLLECTION  DISTRICT",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'4 - Revenues'!J25","v":0}]
[null,null,"Total Revenues",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q24:Q26)","v":0}]
[null,"3.","GENERAL APPROPRIATIONS"]
[null,null,null,"Operations",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM('5 - Appropriations'!H8:H26)","v":0}]
[null,null,null,"Deferred Charges",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM('6 - Appropriations'!H9:H13)","v":0}]
[null,null,null,"Statutory Expenditures",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM('6 - Appropriations'!H15:H21)","v":0}]
[null,null,null,"Judgements",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'6 - Appropriations'!H22","v":0}]
[null,null,null,"Deficit in Operations in Prior Years",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'6 - Appropriations'!H23","v":0}]
[null,null,null,"Surplus (General Budget)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'6 - Appropriations'!H24","v":0}]
[null,null,"Total Appropriations",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q29:Q34)","v":0}]
[]
[null,"It is hereby certified that the within budget is a true copy of the budget finally adopted by resolution of the Governing Body on the ",null,null,null,null,null,null,null,null,null,null,null,null,"day of ",null,null,","]
[null,{"$f":"'Key Inputs'!E34","v":"2023"},".",{"$f":"\"It is further certified that each item of revenue and appropriation is set forth in the same amount and by the same title as appeared in the \"&'Key Inputs'!E34&\" approved budget and\"","v":"It is further certified that each item of revenue and appropriation is set forth in the same amount and by the same title as appeared in the 2023 approved budget and"}]
[null,"all amendments thereto, if any, which have been previously approved by the Director of the Division of Local Government Services. "]
[]
[null,null,null,"Certified by me this ",null,null,null,null,"day of ",null,{"$f":"\", \"&'Key Inputs'!E34&\",\"","v":", 2023,"},null,null,null,null,", Clerk"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Signature"]
[null,"Sheet  7"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q27-Q35","v":0}]