{"text_format":"1","workbook":"xlsx","n_sheets":33,"sheets":["instructions","inputPrYr","inputOth","inputBudSum","cert","computation","mvalloc","transfer","TransferStatutes","debt-lease","Library Grant","gen","DebtSvs-Library","road","levypage9","levypage10","levypage11","nolevypage12","nonbud","NonBudFunds","summ","nhood","Resolution","Tab A","Tab B","Tab C","Tab D","Tab E","Mill Rate Computation","Helpful Links","legend","SignCert","Publication"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":0,"defined_names":9,"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":111,"n_cols":1,"rows_kept":111,"cut":false,"hidden":false,"merged":[]}
["Township Spreadsheet Instructions"]
[]
["Read these instructions carefully.  If after reviewing them you still have questions, call Municipal Services at 785-296-2311 or e-mail : armunis@da.ks.gov"]
[]
["Townships can use the township.xls,  township1.xls, township2 or township3.xls files.   You must choose a form that meets the needs for the number of funds.  If you don't need all the funds, just leave the pages blank and number the completed pages sequentially. "]
[]
["Township.xls spreadsheet has General Fund, Debt Service, Library, Road Bridge, 4 levy fund pages, 2 no levy fund pages, and one Non-Budgeted fund page which holds 5 non- budgeted funds. "]
[]
["When the page numbers are changed on the fund pages, the Certificate page will also be changed."]
[]
[]
["Submitting the Budget "]
[]
["Budgets are required to be sent to the County Clerk by August 25 of each year. "]
[]
["K.S.A. 79-2926 requires budgets to be submitted by electronic means. Contact your County Clerk for the specify instruction as to submission of the budget.  "]
[]
[]
[]
["General Instructions "]
[]
["The worksheets are named (see the tab) in each budget workbook.  We will identify the worksheet by referencing the tab in parentheses (i.e. General Fund reference would be (gen). "]
[]
["All dollar amounts should be rounded to whole dollars (do not record cents)."]
[]
["Enter information  in all areas that are green if they apply to the budget you are preparing. "]
[]
["The yellowed shaded areas of the budget worksheets contain formulas or links which should not be changed, and are protected.  Most errors occur because of information entered on the input pages.  If you are experiencing a problem with a protected cell, first check to see how the information was entered on the input pages.  If the information was entered correctly, and you still continue to experience problems, please contact us for assistance. "]
[]
["The blue areas indicated where the information comes from to complete the section input."]
[]
["Red areas are for notes or indicate a problem area that will need possible corrective action taken."]
[]
["To print the spreadsheets, you can either print one sheet at a time or all of the sheets at once."]
[]
[]
["Computer Spreadsheet Preparation"]
[]
["1.  The information needed for the Input Prior Year Sheet (inputPrYr) comes directly from last year budget.  After the information has been entered, please verify the data is correct.  If at a later date, it is determined  the information is incorrect, correct the information on this page, not the fund page. "]
["1a. On line 2- 'Enter Township Name' - In the green area. The green area will expand and accommodate the township name. "]
["1b. Dates for the entire budget workbook is controlled by the year entered into the \"Enter year being budgeted (YYYY)\" field.  If you find a date that is not correct for the budget being submitted, please contact us for assistance."]
["1c. Next to the last year Ad Valorem Taxes column, column added, 'Amounts used in lieu of last year ad valorem taxes'. If you would like to adjust the previous year ad valorem due to delinquency in taxes to show a more actual amount of taxes received, you can key in the percentage in the green box which will calculate new ad valorem taxes to be used for the current budgeted year.  The new amounts will be linked to the applicable tax levy fund pages. This is not required to be used and the original ad valorem taxes will be linked to the applicable fund pages. "]
[]
["2. The information entered into the Input Other (inputOth) worksheet is obtained from the County Clerk County Treasurer, and the budget from two years ago(the year for actual column of current budget).  After the information has been entered, please verify the data is correct. "]
["2a.  Enter the Computation of Delinquency information. Please note that K.S.A. 79-2930 states that such allowance shall not exceed by more than 5% the percentage of delinquency for the preceding tax year.  Such allowance is not mandatory, but may be used if the municipality wishes."]
["2b. If the township chooses not to use the delinquency rate for all tax levy funds, then the township must delete the rate from those funds. First step, go to the fund tab the fund not requiring the delinquency rate, take the protection off the sheet by going to the 'Tools' and scrolling down to 'Protect' slide to right to 'Unprotect' and press enter. Next, go to the delinquency rate cell and press 'delete' key and put the protection back on by going to 'Tools' and scrolling down to 'Protect Sheet' and press the 'OK' button. Go to the next fund tab and complete the same steps."]
[]
["3. The 'inputBudSum' tab is used to place information on the Budget Summary. On this tab you will need to key in the following information: Name of Person presenting the budget, Title of Person, date the budget hearing will be held, time of the hearing, location of the budget hearing, and a place whereas the taxpayers can obtain a copy of the budget.  "]
["3a. Note: There must be at least 10 days between when the Notice of Budget Hearing is printed and when the hearing is to be held. To be in compliance with K.S.A. 79-2929, it's critical to have at least 10 days between publication and hearing, but also to provide the date, time, and location of the hearing."]
["3b. Once a date has been entered in the Date block, the following statement will appear: 'Latest date for notice to be published in your newspaper'.  Please ensure to take into consideration as to when your newspaper is published when arriving at the hearing date."]
[]
["4. The information contained on the Certificate Page (cert) is the result of links from the fund and input pages .  If there is incorrect information on the Certificate Page, do not correct the Certification Page, but rather correct the fund or input page that links the information to the Certificate Page.  If you can not correct the error, please call us for assistance. "]
["4a. The Certificate page has a statement 'Is a Resolution required?' which will either show 'Yes' or 'No'. This statement compares the Certificate total Ad Valorem Tax to Computation to Determine Limit line 14. If a 'Yes' appears then a resolution is required to be completed and attached to the budget. No action is required if a 'No' appears."]
["4b.  If someone other than a municipal employee assists in preparing the budget, please enter the person's or firm's name and address or email address in the area provided. "]
["4c. If the city has a library, then in the Certificate page will show under the 'Table of Contents:' a new table is required.  The new table is named: 'Computation to Determine State Library Grant' which found on the \"Library Grant\" tab.  The State Library will use the \"Library Grant\" tab to authorize a grant to the library.  This tab must be printed and attached to the budget that is submitted to the County Clerk.  No action is taken if the city does not have a library and will not appear on the Certificate page."]
[]
["5. The majority of information on the Computation to Determine Limit Page (computation) comes from data on the Input Pages (inputpryr and inputOth) and Debt Service Page (DebtService). If there is incorrect information on the Computation Page, please correct the source of the information from either the Input Page or Debt Service Page. If you can not correct the error, please call us for assistance."]
["5a. The information for Computation to Determine Limit page (computationSpecial) comes from data on the input pages (inputpryr and inputoth). If a error is found, please correct the information from the input pages."]
["5b. Print the Resolution page (resolution) if the max levy is exceeded.  Complete the printed resolution and ensure to attached it the budget."]
[]
["6.  Motor Vehicle Allocation (Mvalloc) information comes from the input pages (inputPrYr and inputOth).  Once calculated, the motor allocation information are linked to the applicable fund pages. If information concerning the table are not correct, please do not change the table, but rather correct the information on the input worksheets.  "]
[]
["7. The Schedule of Transfers (transfer) is completed from the individual completed fund pages. Be sure to provide the statute that authorizes the transfer."]
["7a. The totals are now linked to the Budget Summary page. "]
["7b. Adjustments are made for only those non-budgeted expenditure transfers appearing in the current and/or proposed columns of the schedule and do not have expenditures shown in the Budget Summary current and proposed columns. These types of transfers are not truely an expenditure at this time and as such an adjustment is needed to show the taxpayers the actual expenditures for the municipality. "]
["7c. If the General Fund (gen) and Road Fund (road) has transfers to the Special Machinery Fund (road), the Schedule of Transfers now has links for the transfers and provides the statute reference.  "]
["7d. TransferStatutes tab provides statute reference for transfers which are not already identified."]
[]
["8.  Statement of Indebtedness (debt) must show all the debt owed or proposed to be issued.  The general obligation and other bond totals for budget year is linked to the Budget Summary and prior years are linked by the input page (inputpryr). If the township does not have any debt, then on the first line enter 'none'."]
[]
["9.  Statement of Conditional Lease, Lease-Purchases and Certificate of Participation (debt) must be completed for all transactions which will be owned by the township at the end of lease period.  Principal Balance Due for the actual year is linked to the Budget Summary page and prior year linked by the input page (inputpryr). If the township does not have any leases, then on the first line enter 'none'."]
[]
["10. Library Grant tab is linked with the Library fund page.  This table information comes directly off the Library fund page and Budget Summary page which is used to determine if the municipality qualifies for a State grant. If qualify, then the Library fund page will indicate 'Qualifies for State Library Grant' and if not, then indicates to 'See 'Library Grant' tab for further assistance.  If the Library fund page is used, then the Certificate page will reflect in the Table of Contents the requirement of 'Computation to Determine State Library Grant' which is required to be attached to the budget. For those printing paper copies of the budget, only the table will be printed off.  Please note:  For those you do not have a Library fund page, no action is required and the table does not become part of the budget."]
[]
["11.  The spreadsheet has individual fund sheets for General Fund (general), Debt Service and Library (DebtSvs-Library), Road (road),  8 levy pages (levy page9 to levy page12), and 2 no levy fund pages (nolevypage12),   Only complete the fund pages needed.  When the fund pages are completed, the totals will be shown on the Certificate and Budget Summary pages."]
["11a. General Fund page and General Fund Detail page number is no longer set.  Once the number is entered on the General Fund, then the page number is linked to the General Fund Detail page. If the municipality has a Library Fund, the Library Grant page becomes number 6 and the General Fund page would be numbered 7 otherwise the General would be 6."]
["11b. On all tax levy fund pages, we have placed 'Projected Carryover' for the proposed budgeted year.   The carryover table provides a little insight as what the projected cash might be using figures from the budget being submitted.  Please keep in mind that the figures used are only estimates and if the actual receipts or expenditures vary, then the project cash carryover will be affected.  Be advised that the delinquent taxes are not included in the projected carryover as they have a major impact on the  'Desired Carryover' table."]
["11c. On all tax levy fund page, we have placed 'Desired Carryover' which you can place a desired carryover amount and the table will show the mill rate impact along with the expenditure adjustments required to reach the desired carryover.  Note: if a delinquency rate is used, the table might have you do several adjustments to get the desired result or close to the desire amount."]
["11d. On all tax levy fund pages, we have placed 'Mill Rate Comparison' table so you can compare the propose fund mill rate to the current fund mill rate and compare the total proposed mill rate to the total current mill rate. These figures are provided to assist with the determining appropriate mill rate for the proposed budgeted year."]
["11e. Each tax levy fund will have an expenditure for the neighborhood revitalization.  You will only need to input the rebate amounts for the actual and current year.  The proposed budget year amount will be computed for you. Please see step 12 for instructions for the neighborhood revitalization rebate for the proposed budget year. "]
["11f. Each fund page has a 'Miscellaneous' receipt and expenditure line item.  Once an amount has been entered into the block for actual/current/proposed columns, the amount will be compared with either total expenditures or total receipts to determine if it exceeds the 10% Rule for K.S.A. 79-2927.  If the amount exceeds the 10% Rule, the block will turn red, the amount bolded, and a red statement will appear 'Exceed 10% Rule'.  In order to remove the statement and return the block to normal, you must reduce the amount to either 10% or less. Note: the proposed column miscellaneous receipt also takes into consideration the amount of ad valorem taxes in determining the 10% Rule."]
["11g. The Debt Service  (DebtSvs-Library) fund page can contain all debts owe by the township and the amounts should agree with the Statement of Indebtedness amounts.  Debts that are not from a tax levy fund should have enough funds transferred into the Debt Service fund to cover the bond principle and interest for these debts."]
["11h All levy fund pages have a Non-Appropriated Balance block. K.S.A. 79-2927 allows the township to enter an amount not to exceed 5% of the total expenditures for each fund. The Non-Appropriated Balance block is not mandatory to have an amount entered.  If the amount entered in the block exceeds the 5%, a warning \"Exceeds 5%\" will appear.  In order to remove this warning message, you must reduce the non-appropriate figure."]
["11i. Each fund after the \"unencumbered cash bal dec31\", will show the budget authority expenditure amount.  A comparison is made between the budget authority for the actual year and the actual total expenditures for the actual year as shown in the budget. If the total expenditures exceed the budget authority amount, then a \"See Tab A\" appears to indicate a possible violation.  Another comparison is made for the unencumbered cash balance dec 31 to determine if the fund ended with a negative cash balance and if so, then a \"See Tab B\" will appear for the possible violation.  "]
["11j. A comparison is made between the budget authority for the current year and total expenditures for the current budget expenditures as shown in the budget. If the current year adjusted expenditures are more than the budget authority, then a possible violation has occurred and red 'See Tab C' will appear and expenditure block turns red. Another comparison is made for the unencumbered cash balance dec 31 to determine if the fund ended with a negative cash balance and if so, then a \"See Tab D\" will appear for the possible violation.  "]
["11k. All no-tax levy fund pages for the proposed budget year will have an edit on the unencumbered cash balance. If the cash balance is negative, then the block turns red and statement 'See Tab E' will appear. "]
["11l. If a transfer from the Road fund to Special Machinery is made in the actual year, the transfer has been link to the Special Machinery fund. If the transfer exceeds 25% of Resources Available, then a red error message will appear (Exceeds 25%) and the block turns red.  To remove the error message, you should reduce the amount of the transfer for the Road which will change the Special Machinery amount. If the transfer money has not been spent in the Special Machinery fund, then you can fix the transfer to bring within the limitation. But, if the transfer money has been spent, then no action can be taken to fix the violation. In addition, the transfer is linked to the Schedule of Transfers."]
["11m. If a transfer from the Road fund to Special Machinery is made for the current and proposed budgeted years, the transfers has been link to the Special Machinery and Schedule of Transfers. If the transfer exceeds 25% of Resources Available, then a red error message will appear (Exceeds 25%) and the block turns red.  To remove the error message, you should reduce the amount of the transfer for both Road and Special Machinery.  "]
["11n. The General Fund has two line expenditures for transfers to the Special Machinery Fund. The transfers are labeled, 'Transfer to Spec. Mach.(No Levy) and 'Transfer to Spec. Mach.(Gen has Levy). Note: If a transfer is made from the General Fund to Special Machinery, only one transfer is allowed, you must chose the expenditure based upon the General Fund situation. If two transfers are made, on the Special Machinery page will show a error message 'No Authorized Two Transfers - Only One'. You are not required to make a transfer."]
["11o. When the General Fund has ad valorem taxes for the actual, current, and proposed budgeted year, then the block for 'Transfer to Spec. Mach.(No Levied) will turn red. If a transfer amount is shown in the block, then in the yellow area a message will appear 'Not Auth', the transfer should be moved to the next expenditure line 'Transfer to Spec. Mach. (Gen has levy) or deleted if the transferred money has not been spent in the Special Machinery Fund. The transfer is linked to the Schedule of Transfers and Special Machinery Fund. Note: Transfers for the current or proposed budgeted year and a violation occurs, then the amount should be reduced."]
["11p. The General Fund has expenditure line item 'Transfer to Spec. Mach.(Gen has levy) which can be used to transfer up to 25% of the General Fund Resources Available (if the fund has enough cash) to the Special Machinery Fund. If the transfer exceeds the 25% limitation, the block will turn red and a message will appear in yellow box below the transfer in red 'Exceeds 25%'. The violation can be fixed for the actual budgeted year by reducing the transfer amount to 25% or below and the message will go away and the block will turn back to green. But, if the transfer amount has already been spent, then the violation can not be fix. If violation occurs for transfers in the current and proposed budget years, the violation should be fixed by reducing the amount. All transfers are linked to the Schedule of Transfers and Special Machinery Fund.  "]
["11q. The non-budgeted pages (nonbud) holds 5 non-budgeted funds.  The non-budgeted funds are only required to show the actual year receipts and expenditures. The expenditures total will only be linked to the Budget Summary page and Certificate page will list the fund name (non-budgeted funds). Normally, the unencumbered cash balance should end with a positive cash balance, but if it ends with a negative, then the spreadsheet will indicate the negative balance by having 'See Tab B' under the unencumbered cash balance.  "]
[]
["12. Neighborhood Revitalization (nhood) should be completed only after all tax levy fund pages been completed and the levy rates have been computed on the Budget Summary page.  You will need to either print the Budget Summary page or write down the dollar amount of ad valorem needed for each tax levy fund.  The ad valorem amounts for each fund will then be input in the neighborhood revitalization table.  The table will then compute the approximate amount of rebate and link to each tax levy fund page. This will cause each tax levy fund to have an entry in the neighborhood revitalization expenditure block, increase the total expenditures  amount, recomputed the ad valorem needed, and link the new amount to the Budget Summary page.  "]
["12a. Warning, if you had already set the ad valorem taxes so that they were equal to or below the max amount for ad valorem without passing a ordinance, then the neighborhood revitalization rebate might cause the ad valorem tax amount to exceed the max levying amount. If so, you have three options, accept the rebate expenditures and pass the ordinance, or accept the rebate expenditures and reduce other expenditures to come back under the max amount for levying, or lastly, not use the rebate expenditures by deleting the ad valorem taxes that were keyed into the Neighborhood Revitalization Table."]
["12b. Note: You are not required to use the Neighborhood Revitalization Table and may continue doing the way you have in the past. The table can be used to know approximate amount of the rebate so that you will have an idea of the amount of ad valorem taxes you will not be receiving."]
["12c. Note: If you do not have Neighborhood Revitalization, this step is not done."]
[]
["13.  Budget Summary (summ) should link the information from other worksheets.  If you find information which is not correct, please go to the worksheet from which the information is linked, and  take corrective action. If you can not correct the error, please contact us for assistance.   "]
["13a. At the bottom of the page, in the green shaded area, enter the page number."]
["13b. The table 'Estimated Value Of One Mill' to show what 1 mill rate would generate in dollars for the municipality.  "]
["13c. Tables 'What The Mill Rate The Same As' and 'Impact On Keeping The Same Mill Rate', that shows the impact if the previous mill rate is used for the proposed budgeted year.  To achieve this mill rate, the tax levy fund expenditures will need to be changed by the amount shown.  Depending upon the number of tax levy funds involved, the change can be made to one fund, combination of funds, or all of the tax levy fund expenditures.  Note: If a delinquency rate is used on the tax levy fund pages, the table might have you do several adjustments to get the desired result or close to the desire amount. Also please note, this table is not required to be used, but as a tool to assist in budgeting. "]
["13d. The table 'What Mill Rate Would Be Desired', whereas a municipality can create a desired mill rate.  If a municipality has future plans to make a large purchase, project, or just would like a little more unencumbered cash balance, this table will show the amount of ad valorem taxes needed to reach its needs and amount of adjustments to the tax levy fund expenditures to reach this desired mill rate.  This table could also be used to see the impact if the municipality would like to lower the mill rate. To use this table, simply enter in the green area the desired mill rate.  Note: If a delinquency rate used on the tax levy fund pages, the table might have you do several adjustments to get the desired result or close to the desire amount. Also please note, this table is not required to be used, but as a tool to assist in budgeting. "]
["13e. Before printing, review the form to ensure all the information is provided and the figures are correct. Print the page, have official sign it, and take to the local newspaper for printing. For those municipalities that are electronically sending the summary to the newspaper, you can type in the official name before sending.  Please note:  Signing the document is desired, but not signing will not cause the municipality to reprint."]
["13f. Once the 'Notice of Budget Hearing' has been printed in the local newspaper, please review the notice to ensure the information was correctly printed.  If the information is not correct, the Notice may need to be republished, and may delay the submission of the budget to the County Clerk."]
[]
["14.  Before submission of the budget to the County Clerk, please review the entire document and verify that all amounts are correct.  Amounts on the Certificate page should match to the fund pages and may also match to the Budget Summary. In addition, the Certificate Page needs to be signed by at least one member of the governing body (signatures of the entire governing body is preferred, but not mandatory). "]
[]
["15.  How to Unprotect.  All pages within the budget spreadsheet are protected.  We protect the spreadsheets so that the links and formulas are kept in place.  The protection can be taken off to increase lines or add additional information to the individual spreadsheet. "]
["15a.  If you have an older version of excel whereas 'Tools' is one of the excel heading. To remove the protection, place the cursor on the cell that is protected, go to the 'Tools' heading with your mouse and click on it, slide down where it shows 'Unprotect' and click on it.  The cell is now unprotected and you can make your changes.  Once all changes are completed for that spreadsheet, put the protection back on by clicking on 'Tools', slide down to 'Protect' and click on it, a box will appear and press the 'OK' button.  Now the spreadsheet is protected again."]
["15b. If you have the newer version of excel with headings; Home, Insert, Page Layout, Formulas, etc. To unprotect the spreadsheet, move your mouse to the cell that is protected, click on heading 'Home', move mouse to heading 'Cells' and click on 'Format', slide the mouse down to 'Unprotect' under 'Protect' heading and click.  Now the cell is unprotected and you may make your changes. Once all changes are completed for that spreadsheet, put the protection back on by following the steps except the last step by selecting 'Protect' which a box will appear and press the 'Ok' button.  Now the protection is back on for that spreadsheet."]

{"sheet":"inputPrYr","index":1,"n_rows":61,"n_cols":8,"rows_kept":61,"cut":false,"hidden":false,"merged":[[39,3,40,3],[9,0,9,4],[6,6,11,7]]}
["Input sheet for Township budget form"]
["Enter Township Name followed by 'Township'",null,null,"Garden City Township"]
["Enter County Name followed by 'County\"",null,null,"Finney County"]
[]
["Enter year being budgeted (YYYY)",null,null,2013]
[]
["Enter the following information from the sources shown.  This information will be entered on the budget ",null,null,null,null,null,"Note: The below amounts are used to reflect actual taxes received due to delinquent taxes.  Put a percentage in the green box to compute the amount and link to the fund pages. This is not mandatory and can be left blank.            "]
["forms in the appropriate locations.  If any of the numbers are wrong, change them on this input sheet."]
[]
["Note:  All amounts are to be entered in as whole numbers only."]
[]
["The input for the following comes directly from "]
[{"$f":"CONCATENATE(\"the \",D5-1,\" Budget, Certificate Page:\")","v":"the 2012 Budget, Certificate Page:"}]
["*If amended, then use the amended figures.*",null,null,{"$f":"$D$5-1","v":2012},{"$f":"$D$5-2","v":2011},null,"Amounts used in lieu of ","%"]
["Fund name for all funds with a tax levy:",null,"Statute","*Expenditures*","Ad Valorem Tax",null,{"$f":"CONCATENATE(\"\",E14,\" Ad Valorem Tax\")","v":"2011 Ad Valorem Tax"},0]
[null,"General","79-1962",38615,null,null,{"$f":"IF(H15>0,ROUND(E16-(E16*H15),0),0)","v":0}]
[null,"Debt Service","10-113",null,null,null,{"$f":"IF(H15>0,ROUND(E17-(E17*H15),0),0)","v":0}]
[null,"Library","12-1220",null,null,null,{"$f":"IF(H15>0,ROUND(E18-(E18*H15),0),0)","v":0}]
[null,"Road","68-518c",null,null,null,{"$f":"IF(H15>0,ROUND(E19-(E19*H15),0),0)","v":0}]
[null,"Fire","79-1962",200000,77801,null,{"$f":"IF(H15>0,ROUND(E20-(E20*H15),0),0)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(H15>0,ROUND(E21-(E21*H15),0),0)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(H15>0,ROUND(E22-(E22*H15),0),0)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(H15>0,ROUND(E23-(E23*H15),0),0)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(H15>0,ROUND(E24-(E24*H15),0),0)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(H15>0,ROUND(E25-(E25*H15),0),0)","v":0}]
[{"$f":"CONCATENATE(\"Total Ad Valorem Tax for \",D5-1,\" Budgeted Year\")","v":"Total Ad Valorem Tax for 2012 Budgeted Year"},null,null,null,{"$f":"SUM(E16:E25)","v":77801}]
[]
["Other Fund Names:"]
[]
[]
[{"$f":"CONCATENATE(\"Total Expenditures for \",D5-1,\"\")","v":"Total Expenditures for 2012"},null,null,{"$f":"SUM(D16:D25,D29:D30)","v":238615}]
[]
["Non-budgeted funds:"]
[1]
[2]
[3]
[4]
[5]
[]
["The input for the following comes directly from ",null,null,{"$f":"CONCATENATE(\"\",D5-3,\" Tax Rate                    (\",D5-2,\" Column)\")","v":"2010 Tax Rate                    (2011 Column)"}]
[{"$f":"CONCATENATE(\"the \",D5-1,\" Budget, Budget Summary Page:\")","v":"the 2012 Budget, Budget Summary Page:"}]
[null,{"$f":"B16","v":"General"}]
[null,{"$f":"B17","v":"Debt Service"}]
[null,{"$f":"B18","v":"Library"}]
[null,{"$f":"B19","v":"Road"}]
[null,"Fire",null,0.18099999999999999]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[{"$f":"CONCATENATE(\"Total \",D5-3,\" Tax Levy Rate\")","v":"Total 2010 Tax Levy Rate"},null,null,{"$f":"SUM(D42:D51)","v":0.18099999999999999}]
[]
[{"$f":"CONCATENATE(\"Total Tax Levied (\",D5-2,\" budget column)\")","v":"Total Tax Levied (2011 budget column)"},null,null,null,87521]
[{"$f":"CONCATENATE(\"Assessed Valuation (\",D5-2,\" budget column)\")","v":"Assessed Valuation (2011 budget column)"},null,null,null,74128974]
[]
[]
["Outstanding Indebtedness, January 1:",null,null,{"$f":"D5-3","v":2010},{"$f":"D5-2","v":2011}]
["  G.O. Bonds",null,null,0,0]
["  No-Fund Warrant",null,null,0,0]
["  Lease Purchase Principal",null,null,0,0]

{"sheet":"inputOth","index":2,"n_rows":57,"n_cols":5,"rows_kept":57,"cut":false,"hidden":false,"merged":[[3,0,3,4],[15,0,15,1],[42,0,42,1],[43,2,43,4]]}
[{"$f":"inputPrYr!D2","v":"Garden City Township"},null,null,null,{"$f":"inputPrYr!D5","v":2013}]
[{"$f":"inputPrYr!D3","v":"Finney County"}]
[]
["Note:  All amounts are to be entered in as whole numbers only."]
[]
[{"$f":"CONCATENATE(\"From the County Clerks Budget Information for \",E1,\":\")","v":"From the County Clerks Budget Information for 2013:"}]
[{"$f":"CONCATENATE(\"Total Assessed Valuation for \",E1-1,\"\")","v":"Total Assessed Valuation for 2012"},null,null,null,83550962]
[{"$f":"CONCATENATE(\"New Improvements for \",E1-1,\"\")","v":"New Improvements for 2012"},null,null,null,601869]
[{"$f":"CONCATENATE(\"Personal Property excluding oil, gas, and mobile homes - \",E1-1,\"\")","v":"Personal Property excluding oil, gas, and mobile homes - 2012"},null,null,null,5732257]
[{"$f":"CONCATENATE(\"Property that has changed in use for \",E1-1,\"\")","v":"Property that has changed in use for 2012"},null,null,null,641281]
[{"$f":"CONCATENATE(\"Personal Property excluding oil, gas, and mobile homes- \",E1-2,\"\")","v":"Personal Property excluding oil, gas, and mobile homes- 2011"},null,null,null,5633721]
[{"$f":"CONCATENATE(\"Gross earnings (intangible) tax estimate for \",E1,\"\")","v":"Gross earnings (intangible) tax estimate for 2013"}]
[{"$f":"CONCATENATE(\"Neighborhood Revitalization - \",E1,\"\")","v":"Neighborhood Revitalization - 2013"}]
[]
[{"$f":"CONCATENATE(\"Actual Tax Rates for the \",E1-1,\" Budget:\")","v":"Actual Tax Rates for the 2012 Budget:"}]
["Fund",null,null,"Rate"]
[{"$f":"inputPrYr!B16","v":"General"}]
[{"$f":"inputPrYr!B17","v":"Debt Service"}]
[{"$f":"inputPrYr!B18","v":"Library"}]
[{"$f":"inputPrYr!B19","v":"Road"}]
[{"$f":"inputPrYr!B20","v":"Fire"},null,null,0.92300000000000004]
[{"$f":"inputPrYr!B21","v":0}]
[{"$f":"inputPrYr!B22","v":0}]
[{"$f":"inputPrYr!B23","v":0}]
[{"$f":"inputPrYr!B24","v":0}]
[{"$f":"inputPrYr!B25","v":0}]
[null,"Total",null,{"$f":"SUM(D17:D26)","v":0.92300000000000004}]
[]
[{"$f":"CONCATENATE(\"Final Assessed Valuation from the November 1, \",E1-2,\" Abstract:\")","v":"Final Assessed Valuation from the November 1, 2011 Abstract:"},null,null,null,84374869]
[]
[{"$f":"CONCATENATE(\"From the County Treasurer's Budget Information - \",E1,\" Budget Year Estimates:\")","v":"From the County Treasurer's Budget Information - 2013 Budget Year Estimates:"}]
["Motor Vehicle Tax Estimate",null,null,null,7970]
["Recreational Vehicle Tax Estimate",null,null,null,133]
["16\\20 M Vehicle Tax",null,null,null,438]
["LAVTR"]
["Special Highway/Gasoline Tax"]
["   "]
["Computation of Delinquency"]
[{"$f":"CONCATENATE(\"Actual Delinquency for \",E1-3,\" Tax - (rate .01213 = 1.213%, key in 1.2)\")","v":"Actual Delinquency for 2010 Tax - (rate .01213 = 1.213%, key in 1.2)"},null,null,null,0]
["Delinquency % used in this budget will be shown on all fund pages with a tax levy**",null,null,null,0]
["**Note: The delinquency rate can be up to 5% more than the actual delinquency rate from the previous year."]
[]
[{"$f":"CONCATENATE(\"From the \",E1-2,\" Budget Certificate Page\")","v":"From the 2011 Budget Certificate Page"}]
[null,{"$f":"CONCATENATE(\"\",E1-2,\" Expenditure Amounts\")","v":"2011 Expenditure Amounts"},{"$f":"CONCATENATE(\"Note: If the \",E1-2,\" budget was amended, then the\")","v":"Note: If the 2011 budget was amended, then the"}]
["Funds","Budget Authority","expenditure amounts should reflect the amended "]
[{"$f":"inputPrYr!B16","v":"General"},48990,"expenditure amounts."]
[{"$f":"inputPrYr!B17","v":"Debt Service"}]
[{"$f":"inputPrYr!B18","v":"Library"}]
[{"$f":"inputPrYr!B19","v":"Road"}]
[{"$f":"inputPrYr!B20","v":"Fire"},165000]
[{"$f":"inputPrYr!B21","v":0}]
[{"$f":"inputPrYr!B22","v":0}]
[{"$f":"inputPrYr!B23","v":0}]
[{"$f":"inputPrYr!B24","v":0}]
[{"$f":"inputPrYr!B25","v":0}]
[{"$f":"inputPrYr!B29","v":0}]
[{"$f":"inputPrYr!B30","v":0}]

{"sheet":"inputBudSum","index":3,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,0,1,5],[17,0,17,1]]}
[null,null,null,null,null,null,null,null,null,"January"]
["This tab will put the date and time and location of the budget hearing on the Budget Summary page.  Also, provide the location where as the budget can be reveiwed.  Please input information in the green areas.",null,null,null,null,null,null,null,null,"February"]
[null,null,null,null,null,null,null,null,null,"March"]
["Official Name:","Patricia Stockham",null,null,null,null,null,null,null,"April"]
[null,null,null,null,null,null,null,null,null,"May"]
["Official Title:","Garden City Township Treasurer",null,null,null,null,null,null,null,"June"]
[null,null,null,null,null,null,null,null,null,"July"]
["Date:","July 25, 2012",null,"Must be at least 10 days between date published and hearing held.",null,null,null,null,null,"August"]
[null,null,null,{"$f":"IF(B8=\"\",\"\",CONCATENATE(\"Latest date for notice to be published in your newspaper: \",G19,\" \",G23,\", \",G24))","v":"Latest date for notice to be published in your newspaper: July 15, 2012"},null,null,null,null,null,"September"]
["Time:","10:30 a.m.",null,null,null,null,null,null,null,"October"]
[null,null,null,null,null,null,null,null,null,"November"]
["Location:","2005 E. 6 Mile Road",null,null,null,null,null,null,null,"December"]
[]
[]
["Available at:","Finney County Clerk's office"]
[]
[]
["Examples"]
[null,null,null,null,null,null,{"$f":"IF(B8=\"\",\"\",INDIRECT(G20))","v":"July"}]
["Date:","August 12, 2010",null,null,null,null,{"$f":"IF(B8=\"\",\"\",CONCATENATE(\"J\",G22))","v":"J7"}]
[null,null,null,null,null,null,{"$f":"B8-10","v":"2012-07-15"}]
["Time:","7:00 PM or 7:00 AM",null,null,null,null,{"$f":"IF(B8=\"\",\"\",MONTH(G21))","v":7}]
[null,null,null,null,null,null,{"$f":"IF(B8=\"\",\"\",DAY(G21))","v":15}]
["Location:","John Boy's residence 2310 S Highway, Ike City",null,null,null,null,{"$f":"IF(B8=\"\",\"\",YEAR(G21))","v":2012}]
[]
["Available at:","Shawnee County Clerk's Office"]

{"sheet":"cert","index":4,"n_rows":59,"n_cols":8,"rows_kept":59,"cut":false,"hidden":false,"merged":[[53,4,53,6],[38,2,38,3],[39,2,39,3],[40,2,40,3],[0,1,0,6],[11,5,13,5],[10,4,10,6],[5,1,5,6],[6,1,6,6],[2,1,2,7],[7,1,7,6],[8,1,8,6],[4,1,4,6],[3,1,3,6]]}
[null,"CERTIFICATE",null,null,null,null,null,{"$f":"inputPrYr!D5","v":2013}]
[]
[null,{"$f":"CONCATENATE(\"To the Clerk of \",inputPrYr!D3,\", State of Kansas\")","v":"To the Clerk of Finney County, State of Kansas"}]
[null,"We, the undersigned, officers of"]
[null,{"$f":"inputPrYr!D2","v":"Garden City Township"}]
[null,"certify that:  (1) the hearing mentioned in the attached publication was held; "]
[null,"(2) after the Budget Hearing this budget was approved and adopted as the"]
[null,{"$f":"CONCATENATE(\"maximum expenditures for the various funds for the year \",H1,\"; and (3) the\")","v":"maximum expenditures for the various funds for the year 2013; and (3) the"}]
[null,{"$f":"CONCATENATE(\"Amount(s) of \",H1-1,\" Ad Valorem Tax are within statutory limitations for the \",H1,\" Budget.\")","v":"Amount(s) of 2012 Ad Valorem Tax are within statutory limitations for the 2013 Budget."}]
[]
[null,null,null,null,{"$f":"CONCATENATE(\"\",H1,\" Adopted Budget\")","v":"2013 Adopted Budget"}]
[null,null,null,null," ",{"$f":"CONCATENATE(\"Amount of \",H1-1,\" Ad Valorem Tax\")","v":"Amount of 2012 Ad Valorem Tax"},"County"]
[null,null,null,"Page","Budget Authority",null,"Clerk's"]
[null,"Table of Contents:",null,"No.","for Expenditures",null,"Use Only"]
[null,{"$f":"CONCATENATE(\"Computation to Determine Limit for \",H1,\"\")","v":"Computation to Determine Limit for 2013"},null,2]
[null,"Alloc of MVT, RVT, and 16/20M Vehicles Tax",null,3]
[null,"Schedule of Transfers",null,4]
[null,"Statement of Indebt. & Lease/Purchase",null,5]
[null,{"$f":"IF(inputPrYr!E18=\"\",\"\",\"Computation to Determine State Library Grant\")","v":""},null,{"$f":"IF(inputPrYr!D18=\"\",\"\",'Library Grant'!F40)","v":""}]
[null,"Fund","K.S.A."]
[null,{"$f":"inputPrYr!B16","v":"General"},{"$f":"inputPrYr!C16","v":"79-1962"},{"$f":"IF(gen!C61>0,gen!C61,\"  \")","v":6},{"$f":"IF(gen!$E$50<>0,gen!$E$50,\"  \")","v":38539},{"$f":"IF(gen!$E$57<>0,gen!$E$57,0)","v":0},{"$f":"IF(AND(gen!E57=0,$C$40>=0),\" \",IF(AND(F21>0,$C$40=0),\" \",IF(AND(F21>0,$C$40>0),ROUND(F21/$C$40*1000,3))))","v":" "}]
[null,"Debt Service",{"$f":"inputPrYr!C17","v":"10-113"},{"$f":"IF('DebtSvs-Library'!C83>0,'DebtSvs-Library'!C83,\"  \")","v":"  "},{"$f":"IF('DebtSvs-Library'!E33<>0,'DebtSvs-Library'!E33,\"  \")","v":"  "},{"$f":"IF('DebtSvs-Library'!E40<>0,'DebtSvs-Library'!E40,\"  \")","v":"  "},{"$f":"IF(AND('DebtSvs-Library'!E40=0,$C$40>=0),\" \",IF(AND(F22>0,$C$40=0),\" \",IF(AND(F22>0,$C$40>0),ROUND(F22/$C$40*1000,3))))","v":" "}]
[null,{"$f":"inputPrYr!B18","v":"Library"},{"$f":"inputPrYr!C18","v":"12-1220"},{"$f":"IF('DebtSvs-Library'!C83>0,'DebtSvs-Library'!C83,\"  \")","v":"  "},{"$f":"IF('DebtSvs-Library'!E73<>0,'DebtSvs-Library'!E73,\"  \")","v":"  "},{"$f":"IF('DebtSvs-Library'!E80<>0,'DebtSvs-Library'!E80,\"  \")","v":"  "},{"$f":"IF(AND('DebtSvs-Library'!E80=0,$C$40>=0),\" \",IF(AND(F23>0,$C$40=0),\" \",IF(AND(F23>0,$C$40>0),ROUND(F23/$C$40*1000,3))))","v":" "}]
[null,{"$f":"IF(inputPrYr!$B19>\"  \",inputPrYr!$B19,\"  \")","v":"Road"},{"$f":"IF(inputPrYr!C19>0,inputPrYr!C19,\"  \")","v":"68-518c"},{"$f":"IF(road!C67>0,road!C67,\"  \")","v":"  "},{"$f":"IF(road!$E$43<>0,road!$E$43,\"  \")","v":"  "},{"$f":"IF(road!$E$50<>0,road!$E$50,\"  \")","v":"  "},{"$f":"IF(AND(road!E50=0,$C$40>=0),\" \",IF(AND(F24>0,$C$40=0),\" \",IF(AND(F24>0,$C$40>0),ROUND(F24/$C$40*1000,3))))","v":" "}]
[null,{"$f":"IF(inputPrYr!$B20>\"  \",inputPrYr!$B20,\"  \")","v":"Fire"},{"$f":"IF(inputPrYr!C20>0,inputPrYr!C20,\"  \")","v":"79-1962"},{"$f":"IF(levypage9!C81>0,levypage9!C81,\"  \")","v":7},{"$f":"IF(levypage9!$E$33<>0,levypage9!$E$33,\"  \")","v":190000},{"$f":"IF(levypage9!$E$40<>0,levypage9!$E$40,\"  \")","v":98116},1.1779999999999999]
[null,{"$f":"IF(inputPrYr!$B21>\"  \",inputPrYr!$B21,\"  \")","v":"  "},{"$f":"IF(inputPrYr!C21>0,inputPrYr!C21,\"  \")","v":"  "}," ",{"$f":"IF(levypage9!$E$73<>0,levypage9!$E$73,\"  \")","v":"  "},{"$f":"IF(levypage9!$E$80<>0,levypage9!$E$80,\"  \")","v":"  "},{"$f":"IF(AND(levypage9!E80=0,$C$40>=0),\" \",IF(AND(F26>0,$C$40=0),\" \",IF(AND(F26>0,$C$40>0),ROUND(F26/$C$40*1000,3))))","v":" "}]
[null,{"$f":"IF(inputPrYr!$B22>\"  \",inputPrYr!$B22,\"  \")","v":"  "},{"$f":"IF(inputPrYr!C22>0,inputPrYr!C22,\"  \")","v":"  "},{"$f":"IF(levypage10!C81>0,levypage10!C81,\"  \")","v":"  "},{"$f":"IF(levypage10!$E$33<>0,levypage10!$E$33,\"  \")","v":"  "},{"$f":"IF(levypage10!$E$40<>0,levypage10!$E$40,\"  \")","v":"  "},{"$f":"IF(AND(levypage10!$E$40=0,$C$40>=0),\" \",IF(AND(F27>0,$C$40=0),\" \",IF(AND(F27>0,$C$40>0),ROUND(F27/$C$40*1000,3))))","v":" "}]
[null,{"$f":"IF(inputPrYr!$B23>\"  \",inputPrYr!$B23,\"  \")","v":"  "},{"$f":"IF(inputPrYr!C23>0,inputPrYr!C23,\"  \")","v":"  "},{"$f":"IF(levypage10!C81>0,levypage10!C81,\"  \")","v":"  "},{"$f":"IF(levypage10!$E$73<>0,levypage10!$E$73,\"  \")","v":"  "},{"$f":"IF(levypage10!$E$80<>0,levypage10!$E$80,\"  \")","v":"  "},{"$f":"IF(AND(levypage10!$E$80=0,$C$40>=0),\" \",IF(AND(F28>0,$C$40=0),\" \",IF(AND(F28>0,$C$40>0),ROUND(F28/$C$40*1000,3))))","v":" "}]
[null,{"$f":"IF(inputPrYr!$B24>\"  \",inputPrYr!$B24,\"  \")","v":"  "},{"$f":"IF(inputPrYr!C24>0,inputPrYr!C24,\"  \")","v":"  "},{"$f":"IF(levypage11!C81>0,levypage11!C81,\"  \")","v":"  "},{"$f":"IF(levypage11!$E$33<>0,levypage11!$E$33,\"  \")","v":"  "},{"$f":"IF(levypage11!$E$40<>0,levypage11!$E$40,\"  \")","v":"  "},{"$f":"IF(AND(levypage11!$E$40=0,$C$40>=0),\" \",IF(AND(F29>0,$C$40=0),\" \",IF(AND(F29>0,$C$40>0),ROUND(F29/$C$40*1000,3))))","v":" "}]
[null,{"$f":"IF(inputPrYr!$B25>\"  \",inputPrYr!$B25,\"  \")","v":"  "},{"$f":"IF(inputPrYr!C25>0,inputPrYr!C25,\"  \")","v":"  "},{"$f":"IF(levypage11!C81>0,levypage11!C81,\"  \")","v":"  "},{"$f":"IF(levypage11!$E$73<>0,levypage11!$E$73,\"  \")","v":"  "},{"$f":"IF(levypage11!$E$80<>0,levypage11!$E$80,\"  \")","v":"  "},{"$f":"IF(AND(levypage11!$E$80=0,$C$40>=0),\" \",IF(AND(F30>0,$C$40=0),\" \",IF(AND(F30>0,$C$40>0),ROUND(F30/$C$40*1000,3))))","v":" "}]
[null,{"$f":"IF(inputPrYr!$B29>\"  \",inputPrYr!$B29,\"  \")","v":"  "},null,{"$f":"IF(nolevypage12!$C$65>0,nolevypage12!$C$65,\"  \")","v":"  "},{"$f":"IF(nolevypage12!$E$28<>0,nolevypage12!$E$28,\"  \")","v":"  "}]
[null,{"$f":"IF(inputPrYr!$B30>\"  \",inputPrYr!$B30,\"  \")","v":"  "},null,{"$f":"IF(nolevypage12!$C$65>0,nolevypage12!$C$65,\"  \")","v":"  "},{"$f":"IF(nolevypage12!$E$59<>0,nolevypage12!$E$59,\"  \")","v":"  "}]
[null,{"$f":"IF((inputPrYr!$B34>\"  \"),(nonbud!$A3),\"  \")","v":"  "},null,{"$f":"IF(nonbud!$F$33>0,nonbud!$F$33,\"  \")","v":"  "}]
[null,"Special Machinery",null,{"$f":"IF(road!C67>0,road!C67,\"  \")","v":"  "}]
[null,"Totals",null,"x",{"$f":"SUM(E21:E30)","v":228539},{"$f":"SUM(F21:F30)","v":98116},{"$f":"IF(SUM(G21:G30)>0,SUM(G21:G30),\"\")","v":1.1779999999999999}]
[null,"Budget Summary",null,{"$f":"summ!D38","v":8}]
[null,"Neighborhood Revitalization Rebate",null,{"$f":"IF(nhood!C38>0,nhood!C38,\"\")","v":""},"Is a Resolution required?",{"$f":"IF(F35>computation!J34,\"Yes\",\"No\")","v":"Yes"}]
[null,"Resolution",null,{"$f":"IF(Resolution!D36>0,Resolution!D36,\"\")","v":9}]
[null,"Final Assessed Valuation:","County Clerk's Use Only",null,null,null,"         "]
[null,"     Township",83334330]
[null,null,{"$f":"CONCATENATE(\"Nov. 1, \",H1-1,\" Valuation\")","v":"Nov. 1, 2012 Valuation"}]
[null,"Assisted by:"]
[null,null,null,null,"________________________  _______________________"]
[]
[null,"Address:",null,null,"________________________  _______________________"]
[]
[null,null,null,null,"________________________  _______________________"]
[null,"Email:"]
[null,null,null,null,"________________________  _______________________"]
[]
[null,"Attest: ____________________,",{"$f":"H1-1","v":2012},null,"________________________  _______________________"]
[]
[null,null,null,null,"________________________  _______________________"]
[null,"County Clerk",null,null,"    Governing Body"]
[]
[]
[]
[null,"Special Road Election held ___________ for ___Mills for ___ years."]
[null,"First levy in ______."]

{"sheet":"computation","index":5,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":false,"merged":[[35,0,35,9],[36,0,36,9],[2,0,2,9],[3,4,3,6]]}
[null,null,{"$f":"inputPrYr!D2","v":"Garden City Township"},null,null,null,null,null,null,{"$f":"inputPrYr!D5","v":2013}]
[]
[{"$f":"CONCATENATE(\"Computation to Determine Limit for \",J1,\"\")","v":"Computation to Determine Limit for 2013"}]
[null,null,null,null,null,null,null,null,null,"Amount of Levy"]
[" 1.",{"$f":"CONCATENATE(\"Total Tax Levy Amount in \",J1-1,\"\")","v":"Total Tax Levy Amount in 2012"},null,null,null,null,null,"+","$",{"$f":"inputPrYr!E26","v":77801}]
[" 2.",{"$f":"CONCATENATE(\"Debt Service Levy in \",J1-1,\"\")","v":"Debt Service Levy in 2012"},null,null,null,null,null,"-","$",{"$f":"inputPrYr!E17","v":0}]
[" 3.","Tax Levy Excluding Debt Service",null,null,null,null,null,null,"$",{"$f":"J5-J6","v":77801}]
[]
[null,{"$f":"CONCATENATE(\"\",J1-1,\" Valuation Information for Valuation Adjustments:\")","v":"2012 Valuation Information for Valuation Adjustments:"}]
[]
[" 4.",{"$f":"CONCATENATE(\"New Improvements for \",J1-1,\":\")","v":"New Improvements for 2012:"},null,null,null,"+",{"$f":"inputOth!E8","v":601869}]
[]
[" 5.",{"$f":"CONCATENATE(\"Increase in Personal Property for \",J1-1,\":\")","v":"Increase in Personal Property for 2012:"}]
[null,"5a.",{"$f":"CONCATENATE(\"Personal Property \",J1-1,\"\")","v":"Personal Property 2012"},"+",{"$f":"inputOth!E9","v":5732257}]
[null,"5b.",{"$f":"CONCATENATE(\"Personal Property \",J1-2,\"\")","v":"Personal Property 2011"},"-",{"$f":"inputOth!E11","v":5633721}]
[null,"5c.","Increase in Personal Property (5a minus 5b)",null,null,"+",{"$f":"IF(E14>E15,E14-E15,0)","v":98536}]
[null,null,null,null,null,null,"(Use Only if > 0)"]
["6.",{"$f":"CONCATENATE(\"Valuation of Property that Changed in Use during \",J1-1,\":\")","v":"Valuation of Property that Changed in Use during 2012:"},null,null,null,"+",{"$f":"inputOth!E10","v":641281}]
[" "]
["7.","Total Valuation Adjustment (Sum of 4, 5c, 6)",null,null,null,null,{"$f":"G11+G16+G18","v":1341686}]
[]
["8.",{"$f":"CONCATENATE(\"Total Estimated Valuation July 1,\",J1-1,\"\")","v":"Total Estimated Valuation July 1,2012"},null,null,{"$f":"inputOth!E7","v":83550962}]
[]
["9.","Total Valuation less Valuation Adjustment (8 minus 7)",null,null,null,null,{"$f":"E22-G20","v":82209276}]
[]
["10.","Factor for Increase (7 divided by 9)",null,null,null,null,{"$f":"IF(G20>0,G20/G24,0)","v":1.6320372411502564E-2}]
[]
["11.","Amount of Increase (10 times 3)",null,null,null,null,null,"+","$",{"$f":"ROUND(G26*J7,0)","v":1270}]
[]
["12.","Maximum Tax Levy, excluding debt service,  without Resolution (3 plus 11)",null,null,null,null,null,null,"$",{"$f":"J7+J28","v":79071}]
[]
["13.",{"$f":"CONCATENATE(\"Debt Service Levy in this \",J1,\"\")","v":"Debt Service Levy in this 2013"},null,null,null,null,null,null,null,{"$f":"'DebtSvs-Library'!E40","v":0}]
[]
["14.","Maximum levy, including debt service, without a Resolution (12 plus 13)",null,null,null,null,null,null,null,{"$f":"J30+J32","v":79071}]
[]
[{"$f":"CONCATENATE(\"If the \",J1,\" budget includes tax levies exceeding the total on line 14, you must\")","v":"If the 2013 budget includes tax levies exceeding the total on line 14, you must"}]
["adopt a resolution to exceed this limit and attach a copy to this budget."]

{"sheet":"mvalloc","index":6,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[[8,4,9,4],[8,6,8,9],[5,1,5,9]]}
[null,{"$f":"inputPrYr!D2","v":"Garden City Township"},null,null,null,null,null,null,null,{"$f":"inputPrYr!D5","v":2013}]
[null,{"$f":"inputPrYr!D3","v":"Finney County"}]
[]
[]
[]
[null,"Allocation of Motor, Recreational, and 16/20M Vehicle Tax "]
[]
[]
[null,"Budgeted Funds",null,"Budget Tax Levy ",{"$f":"CONCATENATE(\"Budget Tax Levy Rate for \",J1-1,\"\")","v":"Budget Tax Levy Rate for 2012"},null,{"$f":"CONCATENATE(\"Allocation for Proposed Year \",J1,\"\")","v":"Allocation for Proposed Year 2013"}]
[null,{"$f":"CONCATENATE(\"for \",J1-1,\"\")","v":"for 2012"},null,{"$f":"CONCATENATE(\"Amount for \",J1,\"\")","v":"Amount for 2013"},null,null,"MVT",null,"RVT","16/20M Veh"]
[null,{"$f":"inputPrYr!B16","v":"General"},null,{"$f":"IF(inputPrYr!E16>0,inputPrYr!E16,\"  \")","v":"  "},{"$f":"IF(inputOth!D17>0,inputOth!D17,\"  \")","v":"  "},null,{"$f":"IF(inputPrYr!E16=0,0,G23-SUM(G12:G20))","v":0},null,{"$f":"IF(inputPrYr!E16=0,0,I25-SUM(I12:I20))","v":0},{"$f":"IF(inputPrYr!E16=0,0,J27-SUM(J12:J20))","v":0}]
[null,{"$f":"inputPrYr!B17","v":"Debt Service"},null,{"$f":"IF(inputPrYr!E17>=0,inputPrYr!E17,\"  \")","v":0},{"$f":"IF(inputOth!D18>0,inputOth!D18,\"  \")","v":"  "},null,{"$f":"IF(inputPrYr!E17=0,0,ROUND(D12*$G$30,0))","v":0},null,{"$f":"IF(inputPrYr!$E$17=0,0,ROUND($D$12*$I$32,0))","v":0},{"$f":"IF(inputPrYr!E17=0,0,ROUND($D12*$J$34,0))","v":0}]
[null,{"$f":"inputPrYr!B18","v":"Library"},null,{"$f":"IF(inputPrYr!E18>=0,inputPrYr!E18,\"  \")","v":0},null,null,{"$f":"IF(inputPrYr!E18=0,0,ROUND(D13*$G$30,0))","v":0},null,{"$f":"IF(inputPrYr!$E$18=0,0,ROUND($D$13*$I$32,0))","v":0},{"$f":"IF(inputPrYr!E18=0,0,ROUND($D13*$J$34,0))","v":0}]
[null,{"$f":"IF(inputPrYr!$B19>\"  \",inputPrYr!$B19,\"  \")","v":"Road"},null,{"$f":"IF(inputPrYr!E19>=0,inputPrYr!E19,\"  \")","v":0},{"$f":"IF(inputOth!D20>0,inputOth!D20,\"  \")","v":"  "},null,{"$f":"IF(inputPrYr!E19=0,0,ROUND(D14*$G$30,0))","v":0},null,{"$f":"IF(inputPrYr!$E$19=0,0,ROUND($D$14*$I$32,0))","v":0},{"$f":"IF(inputPrYr!E19=0,0,ROUND($D14*$J$34,0))","v":0}]
[null,{"$f":"IF(inputPrYr!$B20>\"  \",inputPrYr!$B20,\"  \")","v":"Fire"},null,{"$f":"IF(inputPrYr!E20>=0,inputPrYr!E20,\"  \")","v":77801},{"$f":"IF(inputOth!D21>0,inputOth!D21,\"  \")","v":0.92300000000000004},null,{"$f":"IF(inputPrYr!E20=0,0,ROUND(D15*$G$30,0))","v":7970},null,{"$f":"IF(inputPrYr!$E$20=0,0,ROUND($D$15*$I$32,0))","v":133},{"$f":"IF(inputPrYr!E20=0,0,ROUND($D15*$J$34,0))","v":438}]
[null,{"$f":"IF(inputPrYr!$B21>\"  \",inputPrYr!$B21,\"  \")","v":"  "},null,{"$f":"IF(inputPrYr!E21>=0,inputPrYr!E21,\"  \")","v":0},{"$f":"IF(inputOth!D22>0,inputOth!D22,\"  \")","v":"  "},null,{"$f":"IF(inputPrYr!E21=0,0,ROUND(D16*$G$30,0))","v":0},null,{"$f":"IF(inputPrYr!$E$21=0,0,ROUND($D$16*$I$32,0))","v":0},{"$f":"IF(inputPrYr!E21=0,0,ROUND($D16*$J$34,0))","v":0}]
[null,{"$f":"IF(inputPrYr!$B22>\"  \",inputPrYr!$B22,\"  \")","v":"  "},null,{"$f":"IF(inputPrYr!E22>=0,inputPrYr!E22,\"  \")","v":0},{"$f":"IF(inputOth!D23>0,inputOth!D23,\"  \")","v":"  "},null,{"$f":"IF(inputPrYr!E22=0,0,ROUND(D17*$G$30,0))","v":0},null,{"$f":"IF(inputPrYr!$E$22=0,0,ROUND($D$17*$I$32,0))","v":0},{"$f":"IF(inputPrYr!E22=0,0,ROUND($D17*$J$34,0))","v":0}]
[null,{"$f":"IF(inputPrYr!$B23>\"  \",inputPrYr!$B23,\"  \")","v":"  "},null,{"$f":"IF(inputPrYr!E23>=0,inputPrYr!E23,\"  \")","v":0},{"$f":"IF(inputOth!D24>0,inputOth!D24,\"  \")","v":"  "},null,{"$f":"IF(inputPrYr!E23=0,0,ROUND(D18*$G$30,0))","v":0},null,{"$f":"IF(inputPrYr!$E$23=0,0,ROUND($D$18*$I$32,0))","v":0},{"$f":"IF(inputPrYr!E23=0,0,ROUND($D18*$J$34,0))","v":0}]
[null,{"$f":"IF(inputPrYr!$B24>\"  \",inputPrYr!$B24,\"  \")","v":"  "},null,{"$f":"IF(inputPrYr!E24>=0,inputPrYr!E24,\"  \")","v":0},{"$f":"IF(inputOth!D25>0,inputOth!D25,\"  \")","v":"  "},null,{"$f":"IF(inputPrYr!E24=0,0,ROUND(D19*$G$30,0))","v":0},null,{"$f":"IF(inputPrYr!$E$24=0,0,ROUND($D$19*$I$32,0))","v":0},{"$f":"IF(inputPrYr!E24=0,0,ROUND($D19*$J$34,0))","v":0}]
[null,{"$f":"IF(inputPrYr!$B25>\"  \",inputPrYr!$B25,\"  \")","v":"  "},null,{"$f":"IF(inputPrYr!E25>=0,inputPrYr!E25,\"  \")","v":0},{"$f":"IF(inputOth!D26>0,inputOth!D26,\"  \")","v":"  "},null,{"$f":"IF(inputPrYr!E25=0,0,ROUND(D20*$G$30,0))","v":0},null,{"$f":"IF(inputPrYr!$E$25=0,0,ROUND($D$20*$I$32,0))","v":0},{"$f":"IF(inputPrYr!E25=0,0,ROUND($D20*$J$34,0))","v":0}]
[null,"Total",null,{"$f":"SUM(D11:D20)","v":77801},{"$f":"SUM(E11:E20)","v":0.92300000000000004},null,{"$f":"SUM(G11:G20)","v":7970},null,{"$f":"SUM(I11:I20)","v":133},{"$f":"SUM(J11:J20)","v":438}]
[]
[null,"County Treasurer's Motor Vehicle Estimate",null,null,null,null,{"$f":"inputOth!E32","v":7970}]
[]
[null,"County Treasurer's Recreational Vehicle Estimate",null,null,null,null,null,{"$f":"inputPrYr!E75","v":0},{"$f":"inputOth!E33","v":133}]
[]
[null,"County Treasurer's 16/20M Vehicle Estimate",null,null,null,null,null,null,null,{"$f":"inputOth!E34","v":438}]
[]
[]
[null,"Motor Vehicle Factor",null,null,null,null,{"$f":"IF(D21=0,0,G23/D21)","v":0.10244084266269071}]
[]
[null,null,null,"Recreational Vehicle Factor",null,null,null,{"$f":"IF(D21=0,0,H25/D21)","v":0},{"$f":"IF(D21=0,0,I25/D21)","v":1.7094895952494183E-3}]
[]
[null,null,null,null,null,null,"16/20M Vehicle Factor",null,null,{"$f":"IF(D21=0,0,J27/D21)","v":5.629747689618385E-3}]

{"sheet":"transfer","index":7,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[[4,0,4,5]]}
[null,null,null,null,null,{"$f":"inputPrYr!D5","v":2013}]
[{"$f":"inputPrYr!D2","v":"Garden City Township"}]
[]
[]
["Schedule of Transfers"]
[]
["Expenditure","Receipt","Actual","Current","Proposed","Transfers"]
["Fund Transferred ","Fund Transferred","Amount for","Amount for","Amount for","Authorized by "]
["From:","  To:",{"$f":"F1-2","v":2011},{"$f":"F1-1","v":2012},{"$f":"F1","v":2013},"Statute"]
[]
["General ","Special Machinery",{"$f":"gen!$C$43","v":0},{"$f":"gen!$D$43","v":0},{"$f":"gen!$E$43","v":0},{"$f":"IF(C11+D11+E11>0,\"80-1406b\",\"\")","v":""}]
["General ","Special Machinery",{"$f":"gen!$C$45","v":0},{"$f":"gen!$D$45","v":0},{"$f":"gen!$E$45","v":0},{"$f":"IF(C12+D12+E12>0,\"80-122\",\"\")","v":""}]
["Road","Special Machinery",{"$f":"road!$C$38","v":0},{"$f":"road!$D$38","v":0},{"$f":"road!$E$38","v":0},{"$f":"IF(C13+D13+E13>0,\"68-141g\",\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",{"$f":"SUM(C10:C26)","v":0},{"$f":"SUM(D10:D26)","v":0},{"$f":"SUM(E10:E26)","v":0}]
[null,"Adjustments*"]
[null,"Adjusted Totals",{"$f":"C27","v":0},{"$f":"SUM(D27-D28)","v":0},{"$f":"SUM(E27-E28)","v":0}]
[]
[]
["*Note:",{"$f":"CONCATENATE(\"Adjustments are required only if the transfer is being made in \",D9,\" and/or \",E9,\" from a non-budgeted fund.\")","v":"Adjustments are required only if the transfer is being made in 2012 and/or 2013 from a non-budgeted fund."}]

{"sheet":"TransferStatutes","index":8,"n_rows":33,"n_cols":1,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Transfers - Townships"]
[]
["K.S.A. 2-1318.  Transfer to noxious weed capital outlay fund.  Any moneys remaining in the noxious weed eradication fund at the end of any year for which a levy is made may be transferred to the noxious weed capital outlay fund."]
[]
[]
["K.S.A. 10-117a.  Transfer from debt service fund.  Whenever all bond issues have been completely retired the governing body may transfer to the general fund the unexpended balance in the debt service fund."]
[]
[]
["K.S.A. 12-110d.  Transfer to special ambulance or emergency medical service equipment fund.  May transfer annually any funds received from a tax levy specifically authorized to be made for ambulance or emergency medical service, to a special reserve fund for replacement of ambulance or emergency medical service equipment."]
[]
[]
["K.S.A. 12-16,102.  Transfer to employee benefits contribution trust fund.  May transfer to employee benefits trust fund from any source that may be lawfully utilized for the purposes stated in the ordinance or resolution creating such trust funds, including transfers from employee benefit funds established for other postemployment benefits."]
[]
[]
["K.S.A. 12-17,118.  Transfer to and from neighborhood revitalization fund.  Authorizes transfers to a neighborhood revitalization fund from any source which may be lawfully utilized to finance redevelopment of designated revitalization areas and dilapidated structures and to provide rebates such purposes."]
[]
[]
["K.S.A. 68-141g.  Transfer to special machinery or equipment fund.  Authorizes an annual transfer, not to exceed 25%, from the road, bridge or street fund to a special road, bridge or street building machinery, equipment and bridge building fund. "]
[]
[]
["K.S.A. 79-2958.  Transfer from closed tax levy fund.  Whenever there shall remain in any fund moneys received from the levy of a tax, after all obligations of such fund have been fully paid, the treasurer shall close out the fund and credit the excess to the general fund.  Should any back taxes for such levy afterwards be received by the taxing subdivision, it shall be credited to the fund for general purposes."]
[]
[]
["K.S.A. 80-122.  Transfer from general fund to equipment reserve fund.  Authorizes and annual budgeted transfer of up to 25% of the general fund to an equipment reserve fund to finance the acquisition of equipment"]
[]
[]
["K.S.A. 80-1406b.  Transfer from general fund.  The township board of any township which did not make a tax levy for the township general fund in the year next preceding and which has a surplus of moneys in the general fund may transfer all or any part of such surplus to any other fund."]
[]
[]
["K.S.A. 80-1406c.  Transfer from general fund to cemetery fund by certain townships.  Townships in counties with a population less than 3,100, assessed taxable tangible valuation of the county between $14,000,000 and $20,000,000, and operating under the county road unit system may, by unanimous resolution, declare a surplus of monies in the general fund and transfer such surplus or any part therof to the cemetery fund."]
[]
[]
["K.S.A. 80-1558.  Transfer to special fire protection reserve fund.  Authorizes an annual transfer of up to 25% from the fire fund to a special fire protection reserve fund. "]

{"sheet":"debt-lease","index":9,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":false,"merged":[[17,1,17,8]]}
[null,{"$f":"inputPrYr!$D$2","v":"Garden City Township"},null,null,null,null,null,null,null,null,null,{"$f":"inputPrYr!D5","v":2013}]
[null,{"$f":"inputPrYr!$D$3","v":"Finney County"}]
[null,"STATEMENT OF INDEBTEDNESS"]
[]
[null,"Type","Date","Interest",null,"Amount",null,null,"   Amount Due",null,"   Amount Due"]
[null,"of","of","Rate","Amount","Outstanding","  Date Due",null,{"$f":"L1-1","v":2012},null,{"$f":"L1","v":2013}]
[null,"Debt","Issue","%","Issued",{"$f":"CONCATENATE(\"Jan 1,\",L1-1,\"\")","v":"Jan 1,2012"},"Interest","Principal","Interest","Principal","Interest","Principal"]
[null,"G.O. Bonds"]
[]
[]
[null,"Total G.O. Bonds",null,null,null,{"$f":"SUM(F9:F10)","v":0},null,null,{"$f":"SUM(I9:I10)","v":0},{"$f":"SUM(J9:J10)","v":0},{"$f":"SUM(K9:K10)","v":0},{"$f":"SUM(L9:L10)","v":0}]
[null,"Other"]
[]
[]
[null,"Total Other",null,null,null,{"$f":"SUM(F13:F14)","v":0},null,null,{"$f":"SUM(I13:I14)","v":0},{"$f":"SUM(J13:J14)","v":0},{"$f":"SUM(K13:K14)","v":0},{"$f":"SUM(L13:L14)","v":0}]
[null,"Total Indebtedness",null,null,null,{"$f":"SUM(F11+F15)","v":0},null,null,{"$f":"SUM(I11+I15)","v":0},{"$f":"SUM(J11+J15)","v":0},{"$f":"SUM(K11+K15)","v":0},{"$f":"SUM(L11+L15)","v":0}]
[]
[null,"STATEMENT OF CONDITIONAL LEASE-PURCHASE AND CERTIFICATE OF PARTICIPATION*"]
[]
[null,null,null,"Term",null,"Total"]
[null,null,null,"of","Interest","Amount","Principal","Payments","Payments"]
[null,"Items","  Contract","Contract","Rate","Financed","Balance On","Due","Due"]
[null,"Purchased","Date","(Months)","%","(Beginning Principal)",{"$f":"CONCATENATE(\"Jan 1,\",L1-1,\"\")","v":"Jan 1,2012"},{"$f":"L1-1","v":2012},{"$f":"L1","v":2013}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Total",{"$f":"SUM(G24:G35)","v":0},{"$f":"SUM(H24:H35)","v":0},{"$f":"SUM(I24:I35)","v":0}]
[]
[null,"***If you are merely leasing/renting with no intent to purchase, do not list--such transactions are not lease-purchases."]

{"sheet":"Library Grant","index":10,"n_rows":105,"n_cols":7,"rows_kept":105,"cut":false,"hidden":false,"merged":[[42,1,42,8],[1,1,1,8],[2,1,2,8],[4,1,4,8],[9,1,9,8],[35,1,35,8]]}
[]
[null,"WORKSHEET FOR STATE GRANT-IN-AID TO PUBLIC LIBRARIES AND"]
[null,"REGIONAL LIBRARY SYSTEMS"]
[]
[null,{"$f":"CONCATENATE(\"Budgeted Year: \",inputPrYr!D5,\"\")","v":"Budgeted Year: 2013"}]
[]
[null,{"$f":"CONCATENATE(\"Library found in: \",inputPrYr!D2,\"\")","v":"Library found in: Garden City Township"}]
[null,{"$f":"inputPrYr!D3","v":"Finney County"}]
[]
[null,"Two tests are used to determine eligibility for State Library Grant.  If the grant is approved, then the municipality's library will be paid the grant on February 15 of  each year."]
[]
[null,"First test:"]
[null,null,null,null,"Current Year",null,"Proposed Year"]
[null,null,null,null,{"$f":"inputPrYr!D5-1","v":2012},null,{"$f":"inputPrYr!D5","v":2013}]
[null,{"$f":"'DebtSvs-Library'!B48","v":"Ad Valorem Tax"},null,null,{"$f":"'DebtSvs-Library'!D48","v":77801},null,{"$f":"'DebtSvs-Library'!E80","v":0}]
[null,{"$f":"'DebtSvs-Library'!B49","v":"Delinquent Tax"},null,null,{"$f":"'DebtSvs-Library'!D49","v":0},null,{"$f":"'DebtSvs-Library'!E49","v":0}]
[null,{"$f":"'DebtSvs-Library'!B50","v":"Motor Vehicle Tax"},null,null,{"$f":"'DebtSvs-Library'!D50","v":0},null,{"$f":"'DebtSvs-Library'!E50","v":0}]
[null,{"$f":"'DebtSvs-Library'!B51","v":"Recreational Vehicle Tax"},null,null,{"$f":"'DebtSvs-Library'!D51","v":0},null,{"$f":"'DebtSvs-Library'!E51","v":0}]
[null,{"$f":"'DebtSvs-Library'!B52","v":"16/20M Vehicle Tax"},null,null,{"$f":"'DebtSvs-Library'!D52","v":0},null,{"$f":"'DebtSvs-Library'!E52","v":0}]
[null,"LAVTR",null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,"TOTAL TAXES",null,null,{"$f":"SUM(E15:E21)","v":77801},null,{"$f":"SUM(G15:G21)","v":0}]
[null,"Difference in Total Taxes:",null,null,{"$f":"G22-E22","v":-77801}]
[null,"Qualify for grant:",null,{"$f":"IF((G22-E22)>0,\"Qualify\",\"Not Qualify\")","v":"Not Qualify"}]
[]
[null,"Second test:"]
[null,"Assessed Valuation",null,null,{"$f":"summ!E27","v":84374869},null,{"$f":"summ!G27","v":83550962}]
[null,"Did Assessed Valuation Decrease?",null,null,{"$f":"IF(G27-E27>0,\"No\",\"Yes\")","v":"Yes"}]
[null,"Levy Rate",null,null,{"$f":"summ!F18","v":"  "},null,{"$f":"summ!I18","v":" "}]
[null,"Difference in Levy Rate:",null,null,{"$f":"G29-E29","v":{"$error":"#VALUE!"}}]
[null,"Qualify for grant:",null,{"$f":"IF(E30>=0,\"Qualify\",\"Not Qualify\")","v":{"$error":"#VALUE!"}}]
[]
[null,"Overall does the municipality qualify for a grant?",null,null,null,{"$f":"IF(D24=\"Not Qualify\",IF(D31=\"Not Qualify\",IF(D31=\"Not Qualify\",\"Not Qualify\",\"Qualify\"),\"Qualify\"),\"Qualify\")","v":{"$error":"#VALUE!"}}]
[]
[]
[null,"If the municipality would not have qualified for a grant, please see the below narrative for assistance from the State Library."]
[]
[]
[]
[null,null,null,null,"Page No. ",6]
[]
[]
[null,"Proposed Budget Year – Possible Loss of Library State Aid"]
[]
[null,"Welcome. You have been directed to this section because the amount of revenue from qualifying "]
[null,{"$f":"CONCATENATE(\"sources in your \",G14,\" library fund is not equal to or greater than the amount from the same\")","v":"sources in your 2013 library fund is not equal to or greater than the amount from the same"}]
[null,{"$f":"CONCATENATE(\"sources in \",E14,\".\")","v":"sources in 2012."}]
[]
[null,"In municipalities supporting a library the municipality must budget as much or more for the "]
[null,"budget year as received in the current year for its library to be eligible for a state grant-in-aid "]
[null,"through the State Library of Kansas."]
[]
[null,"Is this a violation?"]
[]
[null,"No. However, it may cost the library valuable supplemental state—and in some cases, regional—"]
[null,"revenue."]
[]
[null,"Why did this happen?"]
[]
[null,"To answer this question, review K.S.A. 75-2556 et seq. to see how it applies to your library fund. "]
[null,"No public library is eligible for a grant-in-aid if the total amount of current year ad valorem "]
[null,"property tax, delinquent tax, and MV, recreational vehicle, and 16/20M tax is less than the total "]
[null,"amount produced from such sources for the previous year."]
[]
[null,"The statute only includes the library fund. If a separate library employee fund exists, it is not "]
[null,"included in the calculation."]
[]
[null,"Note also that although you are eligible to expend carryover from the previous year, the statute "]
[null,"does not include carryover and it is not considered for determination of eligibility."]
[]
[null,"Who determines eligibility?"]
[]
[null,"K.S.A. 75-2556 et seq. makes the State Library of Kansas responsible for determining eligibility "]
[null,"and distribution of library grants-in-aid."]
[]
[null,"Can this issue be corrected at this time?"]
[]
[null,{"$f":"CONCATENATE(\"If the \",G14,\" municipal budget has not been published and has not been submitted to the County\")","v":"If the 2013 municipal budget has not been published and has not been submitted to the County"}]
[null,"Clerk the library fund can be fixed before the submission of the budget to the County Clerk."]
[]
[null,"What should I do?"]
[]
[null,"First, review the budget summary page to ensure that the ad valorem tax mill rate for Proposed "]
[null,{"$f":"CONCATENATE(\"Budget Year \",G14,\" is equal to or greater than that for Current Year Estimate \",E14,\".\")","v":"Budget Year 2013 is equal to or greater than that for Current Year Estimate 2012."}]
[]
[null,"If the mill rate is lower, check to see if the lesser amount is due to a decline in the assessed valuation. "]
[null,"K.S.A. 75-2556(c) says that if the assessed valuation decreases the library will remain eligible as "]
[null,"long as the ad valorem tax mill rate has not been reduced below the mill rate imposed for such "]
[null,{"$f":"CONCATENATE(\"purpose for the previous (\",E14,\") year.\")","v":"purpose for the previous (2012) year."}]
[]
[null,{"$f":"CONCATENATE(\"Next, look to see if delinquent tax for \",G14,\" is budgeted. Often this line is budgeted at $0 or left\")","v":"Next, look to see if delinquent tax for 2013 is budgeted. Often this line is budgeted at $0 or left"}]
[null,"blank. If an amount is budgeted for the Proposed Budget Year it may improve the total to help "]
[null,"the library’s eligibility as well as provide the library with authority under the cash basis law to "]
[null,"spend any delinquent taxes it receives."]
[]
[null,"Further options"]
[]
[null,"The State Library can continue eligibility if after evaluation of all circumstances it is determined "]
[null,"that the maintenance of local tax support for the operations of the library is being met."]
[]
[null,"These circumstances might include authorized transfer from the other funds, additional tax funds spent "]
[null,"for support of the library that do not appear in the library fund, or special circumstances in this "]
[null,"budget year. The State Library requires a letter of certification from the municipality to continue "]
[null,"eligibility. For more information contact the State Library of Kansas at 785.296.3296, or e-mail:"]
[null,"marc.galbraith@library.ks.gov"]

{"sheet":"gen","index":11,"n_rows":73,"n_cols":17,"rows_kept":73,"cut":false,"hidden":false,"merged":[[57,6,57,9],[56,2,56,3],[52,2,52,3],[53,2,53,3],[40,6,40,9],[47,6,47,9]]}
[null,{"$f":"inputPrYr!D2","v":"Garden City Township"},null,null,{"$f":"inputPrYr!D5","v":2013}]
[]
[null,"FUND PAGE FOR FUNDS WITH A TAX LEVY"]
[null,"Adopted Budget","Prior Year","Current Year","Proposed Budget"]
[null,{"$f":"inputPrYr!B16","v":"General"},{"$f":"CONCATENATE(\"Actual for \",$E$1-2,\"\")","v":"Actual for 2011"},{"$f":"CONCATENATE(\"Estimate for \",$E$1-1,\"\")","v":"Estimate for 2012"},{"$f":"CONCATENATE(\"Year for \",$E$1,\"\")","v":"Year for 2013"}]
[null,"Unencumbered Cash Balance January 1",48515,{"$f":"C51","v":48439},{"$f":"D51","v":38239}]
[null,"Receipts:"]
[null,"Ad Valorem Tax",null,{"$f":"IF(inputPrYr!H15>0,inputPrYr!G16,inputPrYr!E16)","v":0},"x"]
[null,"Delinquent Tax"]
[null,"Motor Vehicle Tax",null,null,{"$f":"mvalloc!G11","v":0}]
[null,"Recreational Vehicle Tax",null,null,{"$f":"mvalloc!I11","v":0}]
[null,"16/20 M Vehicle Tax",null,null,{"$f":"mvalloc!J11","v":0}]
[null,"LAVTR",null,null,{"$f":"inputOth!E35","v":0}]
[null,"Gross Earnings (Intangibles) Tax",null,null,{"$f":"inputOth!E12","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48]
[]
[]
[]
[null,"Interest on Idle Funds",274,300,300]
[null,"Miscellaneous"]
[null,"Does miscellaneous exceed 10% of Total Receipts",{"$f":"IF(C26*0.1<C24,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(D26*0.1<D24,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(E26*0.1+E57<E24,\"Exceed 10% Rule\",\"\")","v":""}]
[null,"Total Receipts",{"$f":"SUM(C8:C24)","v":274},{"$f":"SUM(D8:D24)","v":300},{"$f":"SUM(E8:E24)","v":300}]
[null,"Resources Available:",{"$f":"C26+C6","v":48789},{"$f":"D26+D6","v":48739},{"$f":"E26+E6","v":38539}]
[null,"Expenditures:"]
[]
[null,"Officers Pay"]
[null,"Salaries & Wages"]
[null,"Employee Benefits"]
[null,"Supplies/Legal Publications",101,200,500]
[null,"Equipment",null,10000,37539]
[null,"Buildings Maintenance"]
[null,"Insurance"]
[null,"Officer Bond",249,300,500]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"CONCATENATE(\"Desired Carryover Into \",E1+1,\"\")","v":"Desired Carryover Into 2014"}]
[]
[null,"Transfer to Spec. Mach.(No Levy)",null,null,null,null,"Desired Carryover Amount:",null,null,0]
[null,"Does the General Fund have a tax levy",{"$f":"IF(AND($C$43>0,$C$8>0),\"Not Authorized\",\"\")","v":""},{"$f":"IF(AND($D$43>0,$D$8>0),\"Not Authorized\",\"\")","v":""},{"$f":"IF(AND(cert!F21>0,$E$43>0),\"Not Authorized\",\"\")","v":""},null,"Estimated Mill Rate Impact:",null,null,{"$f":"IF(J43=0,\"\",ROUND((J43+E57-G56)/inputOth!E7*1000,3)-G61)","v":""}]
[null,"Transfer to Spec. Mach.(Gen has Levy)",null,null,null,null,{"$f":"CONCATENATE(\"\",E1,\" Tot Exp/Non-Appr Must Be:\")","v":"2013 Tot Exp/Non-Appr Must Be:"},null,null,{"$f":"IF(J43>0,IF(E54<E23,IF(J43=G56,E54,((J43-G56)*(1-D56))+E23),E54+(J43-G56)),0)","v":0}]
[null,"Transfer can not exceed 25% Resources Available",{"$f":"IF(C27*0.25<C45,\"Exceeds 25%\",\"\")","v":""},{"$f":"IF(D27*0.25<D45,\"Exceeds 25%\",\"\")","v":""},{"$f":"IF(E27*0.25+E57<E45,\"Exceeds 25%\",\"\")","v":""},null,"Expenditures Must Be Changed by:",null,null,{"$f":"IF(J43>0,J45-E54,0)","v":0}]
[null,"Neighborhood Revitalization Rebate",null,null,{"$f":"nhood!E6","v":""}]
[null,"Miscellaneous",null,null,null,null,{"$f":"CONCATENATE(\"Projected Carryover Into \",E1+1,\"\")","v":"Projected Carryover Into 2014"}]
[null,"Does misc. exceed 10% of Total Expenditures",{"$f":"IF(C50*0.1<C48,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(D50*0.1<D48,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(E50*0.1<E48,\"Exceed 10% Rule\",\"\")","v":""}]
[null,"Total Expenditures",{"$f":"SUM(C29:C48)","v":350},{"$f":"SUM(D29:D48)","v":10500},{"$f":"SUM(E29:E43,E45,E47:E48)","v":38539},null,{"$f":"D51","v":38239},{"$f":"CONCATENATE(\"\",E1-1,\" Ending Cash Balance (est.)\")","v":"2012 Ending Cash Balance (est.)"}]
[null,"Unencumbered Cash Balance Dec 31",{"$f":"C27-C50","v":48439},{"$f":"SUM(D27-D50)","v":38239},"x",null,{"$f":"E26","v":300},{"$f":"CONCATENATE(\"\",E1,\" Non-AV Receipts (est.)\")","v":"2013 Non-AV Receipts (est.)"}]
[null,{"$f":"CONCATENATE(\"\",E1-2,\"/\",E1-1,\" Budget Authority Amount:\")","v":"2011/2012 Budget Authority Amount:"},{"$f":"inputOth!B46","v":48990},{"$f":"inputPrYr!D16","v":38615},"x",null,{"$f":"IF(D56>0,E55,E57)","v":0},{"$f":"CONCATENATE(\"\",E1,\" Ad Valorem Tax (est.)\")","v":"2013 Ad Valorem Tax (est.)"},null,null,{"$f":"IF(G52=E57,\"\",\"Note: Does not include Delinquent Taxes\")","v":""}]
[null,null,"Non-Appropriated Balance",null,null,{"$f":"IF(E50/0.95-E50<E53,\"Exceeds 5%\",\"\")","v":""},{"$f":"SUM(G50:G52)","v":38539},{"$f":"CONCATENATE(\"Total \",E1,\" Resources Available\")","v":"Total 2013 Resources Available"}]
[null,{"$f":"CONCATENATE(C72,\"     \",D72)","v":"     "},"Total Expenditure/Non-Appr Balance",null,{"$f":"E50+E53","v":38539}]
[null,{"$f":"CONCATENATE(C73,\"     \",D73)","v":"     "},null,"Tax Required",{"$f":"IF(E54-E27>0,E54-E27,0)","v":0},null,{"$f":"ROUND(C50*0.05+C50,0)","v":368},{"$f":"CONCATENATE(\"Less \",E1-2,\" Expenditures + 5%\")","v":"Less 2011 Expenditures + 5%"}]
[null,null,"Delinquent Comp Rate:",{"$f":"inputOth!$E$40","v":0},{"$f":"ROUND(IF(D56>0,(E55*D56),0),0)","v":0},null,{"$f":"G53-G55","v":38171},{"$f":"CONCATENATE(\"Projected \",E1+1,\" Carryover (est.)\")","v":"Projected 2014 Carryover (est.)"}]
[null,null,{"$f":"CONCATENATE(\"Amount of  \",$E$1-1,\" Ad Valorem Tax\")","v":"Amount of  2012 Ad Valorem Tax"},null,{"$f":"E55+E56","v":0}]
[null,null,null,null,null,null,"Mill Rate Comparison"]
[]
[null,null,null,null,null,null,{"$f":"summ!I16","v":" "},{"$f":"CONCATENATE(\"\",E1,\" Fund Mill Rate\")","v":"2013 Fund Mill Rate"}]
[null,"Page No.",{"$f":"IF(inputPrYr!D18>0,7,6)","v":6},null,null,null,{"$f":"summ!F16","v":"  "},{"$f":"CONCATENATE(\"\",E1-1,\" Fund Mill Rate\")","v":"2012 Fund Mill Rate"}]
[null,null,null,null,null,null,{"$f":"summ!I22","v":1.1739999999999999},{"$f":"CONCATENATE(\"Total \",E1,\" Mill Rate\")","v":"Total 2013 Mill Rate"}]
[null,null,null,null,null,null,{"$f":"summ!F22","v":0.92300000000000004},{"$f":"CONCATENATE(\"Total \",E1-1,\" Mill Rate\")","v":"Total 2012 Mill Rate"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(C50>C52,\"See Tab A\",\"\")","v":""},{"$f":"IF(D50>D52,\"See Tab C\",\"\")","v":""}]
[null,null,{"$f":"IF(C51<0,\"See Tab B\",\"\")","v":""},{"$f":"IF(D51<0,\"See Tab D\",\"\")","v":""}]

{"sheet":"DebtSvs-Library","index":12,"n_rows":96,"n_cols":11,"rows_kept":96,"cut":false,"hidden":false,"merged":[[23,6,23,9],[30,6,30,9],[35,2,35,3],[36,2,36,3],[39,2,39,3],[76,2,76,3],[79,2,79,3],[80,2,80,3],[80,6,80,9],[40,2,40,3],[40,6,40,9],[63,6,63,9],[70,6,70,9],[75,2,75,3]]}
[null,{"$f":"inputPrYr!D2","v":"Garden City Township"},null,null,{"$f":"inputPrYr!D5","v":2013}]
[]
[null,"FUND PAGE FOR FUNDS WITH A TAX LEVY"]
[null,"Adopted Budget","Prior Year ","Current Year ","Proposed Budget "]
[null,{"$f":"inputPrYr!B17","v":"Debt Service"},{"$f":"CONCATENATE(\"Actual for \",$E$1-2,\"\")","v":"Actual for 2011"},{"$f":"CONCATENATE(\"Estimate for \",$E$1-1,\"\")","v":"Estimate for 2012"},{"$f":"CONCATENATE(\"Year for \",$E$1,\"\")","v":"Year for 2013"}]
[null,"Unencumbered Cash Balance Jan 1",null,{"$f":"C34","v":0},{"$f":"D34","v":0}]
[null,"Receipts:"]
[null,"Ad Valorem Tax",null,{"$f":"IF(inputPrYr!H15>0,inputPrYr!G19,inputPrYr!E19)","v":0},"x"]
[null,"Delinquent Tax"]
[null,"Motor Vehicle Tax",null,null,{"$f":"mvalloc!G12","v":0}]
[null,"Recreational Vehicle Tax",null,null,{"$f":"mvalloc!I12","v":0}]
[null,"16/20M Vehicle Tax",null,null,{"$f":"mvalloc!J12","v":0}]
[]
[]
[]
[]
[null,"Interest on Idle Funds"]
[null,"Miscellaneous"]
[null,"Does misc. exceed 10% of Total Receipts",{"$f":"IF(C20*0.1<C18,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(D20*0.1<D18,\"Exceeds 10% Rule\",\"\")","v":""},{"$f":"IF(E20*0.1<E18,\"Exceed 10% Rule\",\"\")","v":""}]
[null,"Total Receipts",{"$f":"SUM(C8:C18)","v":0},{"$f":"SUM(D8:D18)","v":0},{"$f":"SUM(E9:E18)","v":0}]
[null,"Resources Available:",{"$f":"C6+C20","v":0},{"$f":"D6+D20","v":0},{"$f":"E6+E20","v":0}]
[null,"Expenditures:"]
[]
[null,null,null,null,null,null,{"$f":"CONCATENATE(\"Desired Carryover Into \",E1+1,\"\")","v":"Desired Carryover Into 2014"}]
[]
[null,null,null,null,null,null,"Desired Carryover Amount:",null,null,0]
[null,null,null,null,null,null,"Estimated Mill Rate Impact:",null,null,{"$f":"IF(J26=0,\"\",ROUND((J26+E40-G39)/inputOth!E7*1000,3)-G44)","v":""}]
[null,null,null,null,null,null,{"$f":"CONCATENATE(\"\",E1,\" Tot Exp/Non-Appr Must Be:\")","v":"2013 Tot Exp/Non-Appr Must Be:"},null,null,{"$f":"IF(J26>0,IF(E37<E21,IF(J26=G39,E37,((J26-G39)*(1-D39))+E21),E37+(J26-G39)),0)","v":0}]
[null,null,null,null,null,null,"Expenditures Must Be Changed by:",null,null,{"$f":"IF(J26>0,J28-E37,0)","v":0}]
[null,"Neighborhood Revitalization Rebate",null,null,{"$f":"nhood!E7","v":""}]
[null,"Miscellaneous",null,null,null,null,{"$f":"CONCATENATE(\"Projected Carryover Into \",E1+1,\"\")","v":"Projected Carryover Into 2014"}]
[null,"Does misc. exceed 10% of Total Expenditures",{"$f":"IF(C33*0.1<C31,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(D33*0.1<D31,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(E33*0.1<E31,\"Exceed 10% Rule\",\"\")","v":""}]
[null,"Total Expenditures",{"$f":"SUM(C23:C31)","v":0},{"$f":"SUM(D23:D31)","v":0},{"$f":"SUM(E23:E31)","v":0},null,{"$f":"D34","v":0},{"$f":"CONCATENATE(\"\",E1-1,\" Ending Cash Balance (est.)\")","v":"2012 Ending Cash Balance (est.)"}]
[null,"Unencumbered Cash Balance Dec 31",{"$f":"C21-C33","v":0},{"$f":"D21-D33","v":0},"x",null,{"$f":"E20","v":0},{"$f":"CONCATENATE(\"\",E1,\" Non-AV Receipts (est.)\")","v":"2013 Non-AV Receipts (est.)"}]
[null,{"$f":"CONCATENATE(\"\",E1-2,\"/\",E1-1,\" Budget Authority Amount:\")","v":"2011/2012 Budget Authority Amount:"},{"$f":"inputOth!B47","v":0},{"$f":"inputPrYr!D17","v":0},"x",null,{"$f":"IF(E39>0,E38,E40)","v":0},{"$f":"CONCATENATE(\"\",E1,\" Ad Valorem Tax (est.)\")","v":"2013 Ad Valorem Tax (est.)"},null,null,{"$f":"IF(G35=E40,\"\",\"Note: Does not include Delinquent Taxes\")","v":""}]
[null,null,"Non-Appropriated Balance",null,null,{"$f":"IF(E33/0.95-E33<E36,\"Exceeds 5%\",\"\")","v":""},{"$f":"SUM(G33:G35)","v":0},{"$f":"CONCATENATE(\"Total \",E1,\" Resources Available\")","v":"Total 2013 Resources Available"}]
[null,{"$f":"CONCATENATE(C93,\"     \",D93)","v":"     "},"Total Expenditure/Non-Appr Balance",null,{"$f":"E33+E36","v":0}]
[null,{"$f":"CONCATENATE(C94,\"     \",D94)","v":"     "},null,"Tax Required",{"$f":"IF(E37-E21>0,E37-E21,0)","v":0},null,{"$f":"C33","v":0},{"$f":"CONCATENATE(\"Less \",E1-2,\" Expenditures\")","v":"Less 2011 Expenditures"}]
[null,null,"Delinquent Comp Rate:",{"$f":"inputOth!E40","v":0},{"$f":"ROUND(IF(D39>0,(E38*D39),0),0)","v":0},null,{"$f":"G36-G38","v":0},{"$f":"CONCATENATE(\"Projected \",E1+1,\" carryover (est.)\")","v":"Projected 2014 carryover (est.)"}]
[null,null,{"$f":"CONCATENATE(\"Amount of  \",E1-1,\" Ad Valorem Tax\")","v":"Amount of  2012 Ad Valorem Tax"},null,{"$f":"SUM(E38:E39)","v":0}]
[null,null,null,null,null,null,"Mill Rate Comparison"]
[]
[null,null,null,null,null,null,{"$f":"summ!I17","v":" "},{"$f":"CONCATENATE(\"\",E1,\" Fund Mill Rate\")","v":"2013 Fund Mill Rate"}]
[null,"Adopted Budget","Prior Year ","Current Year ","Proposed Budget ",null,{"$f":"summ!F17","v":"  "},{"$f":"CONCATENATE(\"\",E1-1,\" Fund Mill Rate\")","v":"2012 Fund Mill Rate"}]
[null,{"$f":"inputPrYr!B18","v":"Library"},{"$f":"CONCATENATE(\"Actual for \",$E$1-2,\"\")","v":"Actual for 2011"},{"$f":"CONCATENATE(\"Estimate for \",$E$1-1,\"\")","v":"Estimate for 2012"},{"$f":"CONCATENATE(\"Year for \",$E$1,\"\")","v":"Year for 2013"},null,{"$f":"summ!I22","v":1.1739999999999999},{"$f":"CONCATENATE(\"Total \",E1,\" Mill Rate\")","v":"Total 2013 Mill Rate"}]
[null,"Unencumbered Cash Balance Jan 1",0,{"$f":"C74","v":0},{"$f":"D74","v":77801},null,{"$f":"summ!F22","v":0.92300000000000004},{"$f":"CONCATENATE(\"Total \",E1-1,\" Mill Rate\")","v":"Total 2012 Mill Rate"}]
[null,"Receipts:"]
[null,"Ad Valorem Tax",null,{"$f":"IF(inputPrYr!H15>0,inputPrYr!G20,inputPrYr!E20)","v":77801},"x"]
[null,"Delinquent Tax"]
[null,"Motor Vehicle Tax",null,null,{"$f":"mvalloc!G13","v":0}]
[null,"Recreational Vehicle Tax",null,null,{"$f":"mvalloc!I13","v":0}]
[null,"16/20M Vehicle Tax",null,null,{"$f":"mvalloc!J13","v":0}]
[]
[]
[]
[]
[null,"Interest on Idle Funds"]
[null,"Miscellaneous"]
[null,"Does misc. exceed 10% of Total Receipts",{"$f":"IF(C60*0.1<C58,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(D60*0.1<D58,\"Exceeds 10% Rule\",\"\")","v":""},{"$f":"IF(E60*0.1<E58,\"Exceed 10% Rule\",\"\")","v":""}]
[null,"Total Receipts",{"$f":"SUM(C48:C58)","v":0},{"$f":"SUM(D48:D58)","v":77801},{"$f":"SUM(E49:E58)","v":0}]
[null,"Resources Available:",{"$f":"C46+C60","v":0},{"$f":"D46+D60","v":77801},{"$f":"E46+E60","v":77801}]
[null,"Expenditures:"]
[]
[null,null,null,null,null,null,{"$f":"CONCATENATE(\"Desired Carryover Into \",E1+1,\"\")","v":"Desired Carryover Into 2014"}]
[]
[null,null,null,null,null,null,"Desired Carryover Amount:",null,null,0]
[null,null,null,null,null,null,"Estimated Mill Rate Impact:",null,null,{"$f":"IF(J66=0,\"\",ROUND((J66+E80-G79)/inputOth!E7*1000,3)-G84)","v":""}]
[null,null,null,null,null,null,{"$f":"CONCATENATE(\"\",E1,\" Tot Exp/Non-Appr Must Be:\")","v":"2013 Tot Exp/Non-Appr Must Be:"},null,null,{"$f":"IF(J66>0,IF(E77<E61,IF(J66=G79,E77,((J66-G79)*(1-D79))+E61),E77+(J66-G79)),0)","v":0}]
[null,null,null,null,null,null,"Expenditures Must Be Changed by:",null,null,{"$f":"IF(J66>0,J68-E77,0)","v":0}]
[null,"Neighborhood Revitalization Rebate",null,null,{"$f":"nhood!E8","v":""}]
[null,"Miscellaneous",null,null,null,null,{"$f":"CONCATENATE(\"Projected Carryover Into \",E1+1,\"\")","v":"Projected Carryover Into 2014"}]
[null,"Does misc. exceed 10% of Total Expenditures",{"$f":"IF(C73*0.1<C71,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(D73*0.1<D71,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(E73*0.1<E71,\"Exceed 10% Rule\",\"\")","v":""}]
[null,"Total Expenditures",{"$f":"SUM(C63:C71)","v":0},{"$f":"SUM(D63:D71)","v":0},{"$f":"SUM(E63:E71)","v":0},null,{"$f":"D74","v":77801},{"$f":"CONCATENATE(\"\",E1-1,\" Ending Cash Balance (est.)\")","v":"2012 Ending Cash Balance (est.)"}]
[null,"Unencumbered Cash Balance Dec 31",{"$f":"C61-C73","v":0},{"$f":"D61-D73","v":77801},"x",null,{"$f":"E60","v":0},{"$f":"CONCATENATE(\"\",E1,\" Non-AV Receipts (est.)\")","v":"2013 Non-AV Receipts (est.)"}]
[null,{"$f":"CONCATENATE(\"\",E1-2,\"/\",E1-1,\" Budget Authority Amount:\")","v":"2011/2012 Budget Authority Amount:"},{"$f":"inputOth!B48","v":0},{"$f":"inputPrYr!D18","v":0},"x",null,{"$f":"IF(E79>0,E78,E80)","v":0},{"$f":"CONCATENATE(\"\",E1,\" Ad Valorem Tax (est.)\")","v":"2013 Ad Valorem Tax (est.)"},null,null,{"$f":"IF(G75=E80,\"\",\"Note: Does not include Delinquent Taxes\")","v":""}]
[null,null,"Non-Appropriated Balance",null,null,{"$f":"IF(E73/0.95-E73<E76,\"Exceeds 5%\",\"\")","v":""},{"$f":"SUM(G73:G75)","v":77801},{"$f":"CONCATENATE(\"Total \",E1,\" Resources Available\")","v":"Total 2013 Resources Available"}]
[null,{"$f":"CONCATENATE(C95,\"     \",D95)","v":"     "},"Total Expenditure/Non-Appr Balance",null,{"$f":"E73+E76","v":0}]
[null,{"$f":"CONCATENATE(C96,\"     \",D96)","v":"     "},null,"Tax Required",{"$f":"IF(E77-E61>0,E77-E61,0)","v":0},null,{"$f":"ROUND(C73*0.05+C73,0)","v":0},{"$f":"CONCATENATE(\"Less \",E1-2,\" Expenditures + 5%\")","v":"Less 2011 Expenditures + 5%"}]
[null,null,"Delinquent Comp Rate:",{"$f":"inputOth!E40","v":0},{"$f":"ROUND(IF(E78>0,(E78*D79),0),0)","v":0},null,{"$f":"G76-G78","v":77801},{"$f":"CONCATENATE(\"Projected \",E1+1,\" carryover (est.)\")","v":"Projected 2014 carryover (est.)"}]
[null,null,{"$f":"CONCATENATE(\"Amount of  \",E1-1,\" Ad Valorem Tax\")","v":"Amount of  2012 Ad Valorem Tax"},null,{"$f":"E78+E79","v":0},{"$f":"IF('Library Grant'!F33=\"\",\"\",IF('Library Grant'!F33=\"Qualify\",\"Qualifies for State Library Grant\",\"See 'Library Grant' tab\"))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,"Mill Rate Comparison"]
[]
[null,"Page No.",null,null,null,null,{"$f":"summ!I18","v":" "},{"$f":"CONCATENATE(\"\",E1,\" Fund Mill Rate\")","v":"2013 Fund Mill Rate"}]
[null,null,null,null,null,null,{"$f":"summ!F18","v":"  "},{"$f":"CONCATENATE(\"\",E1-1,\" Fund Mill Rate\")","v":"2012 Fund Mill Rate"}]
[null,null,null,null,null,null,{"$f":"summ!I22","v":1.1739999999999999},{"$f":"CONCATENATE(\"Total \",E1,\" Mill Rate\")","v":"Total 2013 Mill Rate"}]
[null,null,null,null,null,null,{"$f":"summ!F22","v":0.92300000000000004},{"$f":"CONCATENATE(\"Total \",E1-1,\" Mill Rate\")","v":"Total 2012 Mill Rate"}]
[]
[null,null,"",""]
[null,null,"",""]
[]
[null,null,"",""]
[null,null,"",""]
[null,null,{"$f":"IF(C33>C35,\"See Tab A\",\"\")","v":""},{"$f":"IF(D33>D35,\"See Tab C\",\"\")","v":""}]
[null,null,{"$f":"IF(C34<0,\"See Tab B\",\"\")","v":""},{"$f":"IF(D34<0,\"See Tab D\",\"\")","v":""}]
[null,null,{"$f":"IF(C73>C75,\"See Tab A\",\"\")","v":""},{"$f":"IF(D73>D75,\"See Tab C\",\"\")","v":""}]
[null,null,{"$f":"IF(C74<0,\"See Tab B\",\"\")","v":""},{"$f":"IF(D74<0,\"See Tab D\",\"\")","v":""}]

{"sheet":"road","index":13,"n_rows":75,"n_cols":11,"rows_kept":75,"cut":false,"hidden":false,"merged":[[49,2,49,3],[45,2,45,3],[46,2,46,3],[57,3,58,4],[33,6,33,9],[40,6,40,9],[50,6,50,9]]}
[null,{"$f":"inputPrYr!D2","v":"Garden City Township"},null,null,{"$f":"inputPrYr!D5","v":2013}]
[]
[null,"FUND PAGE FOR FUNDS WITH A TAX LEVY"]
[null,"Adopted Budget","Prior Year","Current Year","Proposed Budget"]
[null,{"$f":"inputPrYr!B19","v":"Road"},{"$f":"gen!C5","v":"Actual for 2011"},{"$f":"gen!D5","v":"Estimate for 2012"},{"$f":"gen!E5","v":"Year for 2013"}]
[null,"Unencumbered Cash Balance January 1",null,{"$f":"C44","v":0},{"$f":"D44","v":0}]
[null,"Receipts:"]
[null,"Ad Valorem Tax",null,{"$f":"IF(inputPrYr!H15>0,inputPrYr!G19,inputPrYr!E19)","v":0},"x"]
[null,"Delinquent Tax"]
[null,"Motor Vehicle Tax",null,null,{"$f":"mvalloc!G14","v":0}]
[null,"Recreational Vehicle Tax",null,null,{"$f":"mvalloc!I14","v":0}]
[null,"16/20M Vehicle Tax",null,null,{"$f":"mvalloc!J14","v":0}]
[null,"Special Highway/Gasoline Tax",null,null,{"$f":"inputOth!E36","v":0}]
[]
[]
[]
[]
[]
[]
[null,"Interest on Idle Funds"]
[null,"Miscellaneous"]
[null,"Does miscellaneous exceed 10% of Total Receipts",{"$f":"IF(C23*0.1<C21,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(D23*0.1<D21,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(E23*0.1+E50<E21,\"Exceed 10% Rule\",\"\")","v":""}]
[null,"Total Receipts",{"$f":"SUM(C8:C21)","v":0},{"$f":"SUM(D8:D21)","v":0},{"$f":"SUM(E8:E21)","v":0}]
[null,"Resources Available:",{"$f":"C23+C6","v":0},{"$f":"D23+D6","v":0},{"$f":"E23+E6","v":0}]
[null,"Expenditures:"]
[null,"Salaries & Wages"]
[null,"Employee Benefits"]
[null,"Road Maintenance"]
[null,"Road Materials"]
[null,"Equipment"]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"CONCATENATE(\"Desired Carryover Into \",E1+1,\"\")","v":"Desired Carryover Into 2014"}]
[]
[null,null,null,null,null,null,"Desired Carryover Amount:",null,null,0]
[null,null,null,null,null,null,"Estimated Mill Rate Impact:",null,null,{"$f":"IF(J36=0,\"\",ROUND((J36+E50-G49)/inputOth!E7*1000,3)-G54)","v":""}]
[null,"Transfer to Special Machinery",null,null,null,null,{"$f":"CONCATENATE(\"\",E1,\" Tot Exp/Non-Appr Must Be:\")","v":"2013 Tot Exp/Non-Appr Must Be:"},null,null,{"$f":"IF(J36>0,IF(E47<E16,IF(J36=G49,E47,((J36-G49)*(1-D49))+E16),E47+(J36-G49)),0)","v":0}]
[null,"Does transfer exceed 25% of Resources Available",{"$f":"IF(C24*0.25<C38,\"Not Authorized\",\"\")","v":""},{"$f":"IF(D24*0.25<D38,\"Not Authorized\",\"\")","v":""},{"$f":"IF(E24*0.25+E50<E38,\"Not Authorized\",\"\")","v":""},null,"Expenditures Must Be Changed by:",null,null,{"$f":"IF(J36>0,J38-E47,0)","v":0}]
[null,"Neighborhood Revitalization Rebate",null,null,{"$f":"nhood!E9","v":""}]
[null,"Miscellaneous",null,null,null,null,{"$f":"CONCATENATE(\"Projected Carryover Into \",E1+1,\"\")","v":"Projected Carryover Into 2014"}]
[null,"Does misc. exceed 10% of Total Expenditures",{"$f":"IF(C43*0.1<C41,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(D43*0.1<D41,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(E43*0.1<E41,\"Exceed 10% Rule\",\"\")","v":""}]
[null,"Total Expenditures",{"$f":"SUM(C26:C38,C40:C41)","v":0},{"$f":"SUM(D26:D38,D40:D41)","v":0},{"$f":"SUM(E26:E38,E40:E41)","v":0},null,{"$f":"D44","v":0},{"$f":"CONCATENATE(\"\",E1-1,\" Ending Cash Balance (est.)\")","v":"2012 Ending Cash Balance (est.)"}]
[null,"Unencumbered Cash Balance Dec 31",{"$f":"C24-C43","v":0},{"$f":"D24-D43","v":0},"x",null,{"$f":"E23","v":0},{"$f":"CONCATENATE(\"\",E1,\" Non-AV Receipts (est.)\")","v":"2013 Non-AV Receipts (est.)"}]
[null,{"$f":"CONCATENATE(\"\",E1-2,\"/\",E1-1,\" Budget Authority Amount:\")","v":"2011/2012 Budget Authority Amount:"},{"$f":"inputOth!B49","v":0},{"$f":"inputPrYr!D19","v":0},"x",null,{"$f":"IF(D49>0,E48,E50)","v":0},{"$f":"CONCATENATE(\"\",E1,\" Ad Valorem Tax (est.)\")","v":"2013 Ad Valorem Tax (est.)"},null,null,{"$f":"IF(G45=E50,\"\",\"Note: Does not include Delinquent Taxes\")","v":""}]
[null,null,"Non-Appropriated Balance",null,null,{"$f":"IF(E43/0.95-E43<E46,\"Exceeds 5%\",\"\")","v":""},{"$f":"SUM(G43:G45)","v":0},{"$f":"CONCATENATE(\"Total \",E1,\" Resources Available\")","v":"Total 2013 Resources Available"}]
[null,{"$f":"CONCATENATE(C74,\"     \",D74)","v":"     "},"Total Expenditure/Non-Appr Balance",null,{"$f":"E43+E46","v":0}]
[null,{"$f":"CONCATENATE(C75,\"     \",D75)","v":"     "},null,"Tax Required",{"$f":"IF(E47-E24>0,E47-E24,0)","v":0},null,{"$f":"ROUND(C43*0.05+C43,0)","v":0},{"$f":"CONCATENATE(\"Less \",E1-2,\" Expenditures + 5%\")","v":"Less 2011 Expenditures + 5%"}]
[null,null,"Delinquent Comp Rate:",{"$f":"inputOth!$E$40","v":0},{"$f":"ROUND(IF(D49>0,(E48*D49),0),0)","v":0},null,{"$f":"G46-G48","v":0},{"$f":"CONCATENATE(\"Projected \",E1+1,\" Carryover (est.)\")","v":"Projected 2014 Carryover (est.)"}]
[null,null,{"$f":"CONCATENATE(\"Amount of  \",$E$1-1,\" Ad Valorem Tax\")","v":"Amount of  2012 Ad Valorem Tax"},null,{"$f":"E48+E49","v":0}]
[null,null,null,null,null,null,"Mill Rate Comparison"]
[]
[null,"Special Machinery ",null,null,null,null,{"$f":"summ!I19","v":" "},{"$f":"CONCATENATE(\"\",E1,\" Fund Mill Rate\")","v":"2013 Fund Mill Rate"}]
[null,"     K.S.A. 68-141g",{"$f":"CONCATENATE(\"\",E1-2,\" Actual Year\")","v":"2011 Actual Year"},null,null,null,{"$f":"summ!F19","v":"  "},{"$f":"CONCATENATE(\"\",E1-1,\" Fund Mill Rate\")","v":"2012 Fund Mill Rate"}]
[null,"Unencumbered Cash Balance, Jan 1",null,null,null,null,{"$f":"summ!I22","v":1.1739999999999999},{"$f":"CONCATENATE(\"Total \",E1,\" Mill Rate\")","v":"Total 2013 Mill Rate"}]
[null,"Transfers from:",null,null,null,null,{"$f":"summ!F22","v":0.92300000000000004},{"$f":"CONCATENATE(\"Total \",E1-1,\" Mill Rate\")","v":"Total 2012 Mill Rate"}]
[null,"  Road Fund",{"$f":"C38","v":0}]
[null,"  General Fund(No Levy)",{"$f":"gen!C43","v":0},{"$f":"IF(AND(C58>0,C59>0),\"Not Auth. Two General Transfers - Only One\",\"\")","v":""}]
[null,"  General Fund(Gen has Levy)",{"$f":"gen!C45","v":0}]
[]
[null,"Interest on Idle Funds"]
[null,"Other"]
[null,"Resources Available:",{"$f":"SUM(C55:C62)","v":0}]
[null,"Total Expenditures"]
[null,"Unencumbered Cash Balance, Dec 31",{"$f":"SUM(C63-C64)","v":0}]
[]
[null,"Page No."]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(C43>C45,\"See Tab A\",\"\")","v":""},{"$f":"IF(D43>D45,\"See Tab C\",\"\")","v":""}]
[null,null,{"$f":"IF(C44<0,\"See Tab B\",\"\")","v":""},{"$f":"IF(D44<0,\"See Tab D\",\"\")","v":""}]

{"sheet":"levypage9","index":14,"n_rows":95,"n_cols":11,"rows_kept":95,"cut":false,"hidden":false,"merged":[[23,6,23,9],[30,6,30,9],[40,6,40,9],[63,6,63,9],[70,6,70,9],[80,6,80,9],[79,2,79,3],[39,2,39,3],[35,2,35,3],[36,2,36,3],[75,2,75,3],[76,2,76,3]]}
[null,{"$f":"inputPrYr!D2","v":"Garden City Township"},"        ",null,{"$f":"inputPrYr!D5","v":2013}]
[]
[null,"FUND PAGE FOR FUNDS WITH A TAX LEVY"]
[null,"Adopted Budget","Prior Year","Current Year","Proposed Budget"]
[null,{"$f":"inputPrYr!B20","v":"Fire"},{"$f":"gen!C5","v":"Actual for 2011"},{"$f":"gen!D5","v":"Estimate for 2012"},{"$f":"gen!E5","v":"Year for 2013"}]
[null,"Unencumbered Cash Balance January 1",91897,{"$f":"C34","v":91901},{"$f":"D34","v":81080}]
[null,"Receipts:"]
[null,"Ad Valorem Tax",86188,{"$f":"IF(inputPrYr!H15>0,inputPrYr!G20,inputPrYr!E20)","v":77801},"x"]
[null,"Delinquent Tax",2315]
[null,"Motor Vehicle Tax",10028,10504,{"$f":"mvalloc!G15","v":7970}]
[null,"Recreational Vehicle Tax",170,197,{"$f":"mvalloc!I15","v":133}]
[null,"16/20 M Vehicle Tax",391,438,{"$f":"mvalloc!J15","v":438}]
[null,"Rental Excise Tax",26]
[null,"In Lieu of Tax",3267,6239,2263]
[]
[]
[null,"Interest on Idle Funds"]
[null,"Miscellaneous"]
[null,"Does miscellaneous exceed 10% of Total Receipts",{"$f":"IF(C20*0.1<C18,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(D20*0.1<D18,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(E20*0.1+E40<E18,\"Exceed 10% Rule\",\"\")","v":""}]
[null,"Total Receipts",{"$f":"SUM(C8:C18)","v":102385},{"$f":"SUM(D8:D18)","v":95179},{"$f":"SUM(E8:E18)","v":10804}]
[null,"Resources Available:",{"$f":"C20+C6","v":194282},{"$f":"D20+D6","v":187080},{"$f":"E20+E6","v":91884}]
[null,"Expenditures:"]
[null,"Fire Contract",82381,86000,90000]
[null,"Equipment",20000,20000,100000,null,{"$f":"CONCATENATE(\"Desired Carryover Into \",E1+1,\"\")","v":"Desired Carryover Into 2014"}]
[]
[null,null,null,null,null,null,"Desired Carryover Amount:",null,null,0]
[null,null,null,null,null,null,"Estimated Mill Rate Impact:",null,null,{"$f":"IF(J26=0,\"\",ROUND((J26+E40-G39)/inputOth!E7*1000,3)-G44)","v":""}]
[null,null,null,null,null,null,{"$f":"CONCATENATE(\"\",E1,\" Tot Exp/Non-Appr Must Be:\")","v":"2013 Tot Exp/Non-Appr Must Be:"},null,null,{"$f":"IF(J26>0,IF(E37<E21,IF(J26=G39,E37,((J26-G39)*(1-D39))+E21),E37+(J26-G39)),0)","v":0}]
[null,null,null,null,null,null,"Expenditures Must Be Changed by:",null,null,{"$f":"IF(J26>0,J28-E37,0)","v":0}]
[null,"Neighborhood Revitalization Rebate",null,null,{"$f":"nhood!E10","v":""}]
[null,"Miscellaneous",null,null,null,null,{"$f":"CONCATENATE(\"Projected Carryover Into \",E1+1,\"\")","v":"Projected Carryover Into 2014"}]
[null,"Does misc. exceed 10% of Total Expenditures",{"$f":"IF(C33*0.1<C31,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(D33*0.1<D31,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(E33*0.1<E31,\"Exceed 10% Rule\",\"\")","v":""}]
[null,"Total Expenditures",{"$f":"SUM(C23:C31)","v":102381},{"$f":"SUM(D23:D31)","v":106000},{"$f":"SUM(E23:E31)","v":190000},null,{"$f":"D34","v":81080},{"$f":"CONCATENATE(\"\",E1-1,\" Ending Cash Balance (est.)\")","v":"2012 Ending Cash Balance (est.)"}]
[null,"Unencumbered Cash Balance Dec 31",{"$f":"C21-C33","v":91901},{"$f":"D21-D33","v":81080},"x",null,{"$f":"E20","v":10804},{"$f":"CONCATENATE(\"\",E1,\" Non-AV Receipts (est.)\")","v":"2013 Non-AV Receipts (est.)"}]
[null,{"$f":"CONCATENATE(\"\",E1-2,\"/\",E1-1,\" Budget Authority Amount:\")","v":"2011/2012 Budget Authority Amount:"},{"$f":"inputOth!B50","v":165000},{"$f":"inputPrYr!D20","v":200000},"x",null,{"$f":"IF(E39>0,E38,E40)","v":98116},{"$f":"CONCATENATE(\"\",E1,\" Ad Valorem Tax (est.)\")","v":"2013 Ad Valorem Tax (est.)"},null,null,{"$f":"IF(G35=E40,\"\",\"Note: Does not include Delinquent Taxes\")","v":""}]
[null,null,"Non-Appropriated Balance",null,null,{"$f":"IF(E33/0.95-E33<E36,\"Exceeds 5%\",\"\")","v":""},{"$f":"SUM(G33:G35)","v":190000},{"$f":"CONCATENATE(\"Total \",E1,\" Resources Available\")","v":"Total 2013 Resources Available"}]
[null,{"$f":"CONCATENATE(C92,\"     \",D92)","v":"     "},"Total Expenditure/Non-Appr Balance",null,{"$f":"E33+E36","v":190000}]
[null,{"$f":"CONCATENATE(C93,\"     \",D93)","v":"     "},null,"Tax Required",{"$f":"IF(E37-E21>0,E37-E21,0)","v":98116},null,{"$f":"C33*0.05+C33","v":107500.05},{"$f":"CONCATENATE(\"Less \",E1-2,\" Expenditures + 5%\")","v":"Less 2011 Expenditures + 5%"}]
[null,null,"Delinquent Comp Rate:",{"$f":"inputOth!$E$40","v":0},{"$f":"ROUND(IF(D39>0,(E38*D39),0),0)","v":0},null,{"$f":"G36-G38","v":82499.95},{"$f":"CONCATENATE(\"Projected \",E1+1,\" carryover (est.)\")","v":"Projected 2014 carryover (est.)"}]
[null,null,{"$f":"CONCATENATE(\"Amount of  \",$E$1-1,\" Ad Valorem Tax\")","v":"Amount of  2012 Ad Valorem Tax"},null,{"$f":"E38+E39","v":98116}]
[null,null,null,null,null,null,"Mill Rate Comparison"]
[]
[null,"Adopted Budget",null,null,null,null,{"$f":"summ!I20","v":1.1739999999999999},{"$f":"CONCATENATE(\"\",E1,\" Fund Mill Rate\")","v":"2013 Fund Mill Rate"}]
[null,null,"Prior Year","Current Year","Proposed Budget",null,{"$f":"summ!F20","v":0.92300000000000004},{"$f":"CONCATENATE(\"\",E1-1,\" Fund Mill Rate\")","v":"2012 Fund Mill Rate"}]
[null,{"$f":"inputPrYr!B21","v":0},{"$f":"C5","v":"Actual for 2011"},{"$f":"D5","v":"Estimate for 2012"},{"$f":"E5","v":"Year for 2013"},null,{"$f":"summ!I22","v":1.1739999999999999},{"$f":"CONCATENATE(\"Total \",E1,\" Mill Rate\")","v":"Total 2013 Mill Rate"}]
[null,"Unencumbered Cash Balance January 1",null,{"$f":"C74","v":0},{"$f":"D74","v":0},null,{"$f":"summ!F22","v":0.92300000000000004},{"$f":"CONCATENATE(\"Total \",E1-1,\" Mill Rate\")","v":"Total 2012 Mill Rate"}]
[null,"Receipts:"]
[null,"Ad Valorem Tax",null,{"$f":"IF(inputPrYr!H15>0,inputPrYr!G21,inputPrYr!E21)","v":0},"x"]
[null,"Delinquent Tax"]
[null,"Motor Vehicle Tax",null,null,{"$f":"mvalloc!G16","v":0}]
[null,"Recreational Vehicle Tax",null,null,{"$f":"mvalloc!I16","v":0}]
[null,"16/20M Vehicle Tax",null,null,{"$f":"mvalloc!J16","v":0}]
[]
[]
[]
[]
[null,"Interest on Idle Funds"]
[null,"Miscellaneous"]
[null,"Does miscellaneous exceed 10% of Total Receipts",{"$f":"IF(C60*0.1<C58,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(D60*0.1<D58,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(E60*0.1+E80<E58,\"Exceed 10% Rule\",\"\")","v":""}]
[null,"Total Receipts",{"$f":"SUM(C48:C58)","v":0},{"$f":"SUM(D48:D58)","v":0},{"$f":"SUM(E48:E58)","v":0}]
[null,"Resources Available:",{"$f":"C60+C46","v":0},{"$f":"D60+D46","v":0},{"$f":"E60+E46","v":0}]
[null,"Expenditures:"]
[]
[null,null,null,null,null,null,{"$f":"CONCATENATE(\"Desired Carryover Into \",E1+1,\"\")","v":"Desired Carryover Into 2014"}]
[]
[null,null,null,null,null,null,"Desired Carryover Amount:",null,null,0]
[null,null,null,null,null,null,"Estimated Mill Rate Impact:",null,null,{"$f":"IF(J66=0,\"\",ROUND((J66+E80-G79)/inputOth!E7*1000,3)-G84)","v":""}]
[null,null,null,null,null,null,{"$f":"CONCATENATE(\"\",E1,\" Tot Exp/Non-Appr Must Be:\")","v":"2013 Tot Exp/Non-Appr Must Be:"},null,null,{"$f":"IF(J66>0,IF(E77<E61,IF(J66=G79,E77,((J66-G79)*(1-D79))+E61),E77+(J66-G79)),0)","v":0}]
[null,null,null,null,null,null,"Expenditures Must Be Changed by:",null,null,{"$f":"IF(J66>0,J68-E77,0)","v":0}]
[null,"Neighborhood Revitalization Rebate",null,null,{"$f":"nhood!E11","v":""}]
[null,"Miscellaneous",null,null,null,null,{"$f":"CONCATENATE(\"Projected Carryover Into \",E1+1,\"\")","v":"Projected Carryover Into 2014"}]
[null,"Does misc. exceed 10% of Total Expenditures",{"$f":"IF(C73*0.1<C71,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(D73*0.1<D71,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(E73*0.1<E71,\"Exceed 10% Rule\",\"\")","v":""}]
[null,"Total Expenditures",{"$f":"SUM(C63:C71)","v":0},{"$f":"SUM(D63:D71)","v":0},{"$f":"SUM(E63:E71)","v":0},null,{"$f":"D74","v":0},{"$f":"CONCATENATE(\"\",E1-1,\" Ending Cash Balance (est.)\")","v":"2012 Ending Cash Balance (est.)"}]
[null,"Unencumbered Cash Balance Dec 31",{"$f":"C61-C73","v":0},{"$f":"D61-D73","v":0},"x",null,{"$f":"E60","v":0},{"$f":"CONCATENATE(\"\",E1,\" Non-AV Receipts (est.)\")","v":"2013 Non-AV Receipts (est.)"}]
[null,{"$f":"CONCATENATE(\"\",E1-2,\"/\",E1-1,\" Budget Authority Amount:\")","v":"2011/2012 Budget Authority Amount:"},{"$f":"inputOth!B51","v":0},{"$f":"inputPrYr!D21","v":0},"x",null,{"$f":"IF(E79>0,E78,E80)","v":0},{"$f":"CONCATENATE(\"\",E1,\" Ad Valorem Tax (est.)\")","v":"2013 Ad Valorem Tax (est.)"},null,null,{"$f":"IF(G75=E80,\"\",\"Note: Does not include Delinquent Taxes\")","v":""}]
[null,null,"Non-Appropriated Balance",null,null,{"$f":"IF(E73/0.95-E73<E76,\"Exceeds 5%\",\"\")","v":""},{"$f":"SUM(G73:G75)","v":0},{"$f":"CONCATENATE(\"Total \",E1,\" Resources Available\")","v":"Total 2013 Resources Available"}]
[null,{"$f":"CONCATENATE(C94,\"     \",D94)","v":"     "},"Total Expenditure/Non-Appr Balance",null,{"$f":"E73+E76","v":0}]
[null,{"$f":"CONCATENATE(C95,\"     \",D95)","v":"     "},null,"Tax Required",{"$f":"IF(E77-E61>0,E77-E61,0)","v":0},null,{"$f":"ROUND(C73*0.05+C73,0)","v":0},{"$f":"CONCATENATE(\"Less \",E1-2,\" Expenditures + 5%\")","v":"Less 2011 Expenditures + 5%"}]
[null,null,"Delinquent Comp Rate:",{"$f":"inputOth!$E$40","v":0},{"$f":"ROUND(IF(D79>0,(E78*D79),0),0)","v":0},null,{"$f":"G76-G78","v":0},{"$f":"CONCATENATE(\"Projected \",E1+1,\" carryover (est.)\")","v":"Projected 2014 carryover (est.)"}]
[null,null,{"$f":"CONCATENATE(\"Amount of  \",$E$1-1,\" Ad Valorem Tax\")","v":"Amount of  2012 Ad Valorem Tax"},null,{"$f":"E78+E79","v":0}]
[null,"Page No.",7,null,null,null,"Mill Rate Comparison"]
[]
[null,null,null,null,null,null,{"$f":"summ!#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(\"\",E1,\" Fund Mill Rate\")","v":"2013 Fund Mill Rate"}]
[null,null,null,null,null,null,{"$f":"summ!#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(\"\",E1-1,\" Fund Mill Rate\")","v":"2012 Fund Mill Rate"}]
[null,null,null,null,null,null,{"$f":"summ!I22","v":1.1739999999999999},{"$f":"CONCATENATE(\"Total \",E1,\" Mill Rate\")","v":"Total 2013 Mill Rate"}]
[null,null,null,null,null,null,{"$f":"summ!F22","v":0.92300000000000004},{"$f":"CONCATENATE(\"Total \",E1-1,\" Mill Rate\")","v":"Total 2012 Mill Rate"}]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(C33>C35,\"See Tab A\",\"\")","v":""},{"$f":"IF(D33>D35,\"See Tab C\",\"\")","v":""}]
[null,null,{"$f":"IF(C34<0,\"See Tab B\",\"\")","v":""},{"$f":"IF(D34<0,\"See Tab D\",\"\")","v":""}]
[null,null,{"$f":"IF(C73>C75,\"See Tab A\",\"\")","v":""},{"$f":"IF(D73>D75,\"See Tab C\",\"\")","v":""}]
[null,null,{"$f":"IF(C74<0,\"See Tab B\",\"\")","v":""},{"$f":"IF(D74<0,\"See Tab D\",\"\")","v":""}]

{"sheet":"levypage10","index":15,"n_rows":95,"n_cols":11,"rows_kept":95,"cut":false,"hidden":false,"merged":[[23,6,23,9],[30,6,30,9],[40,6,40,9],[63,6,63,9],[70,6,70,9],[80,6,80,9],[79,2,79,3],[39,2,39,3],[35,2,35,3],[36,2,36,3],[75,2,75,3],[76,2,76,3]]}
[null,{"$f":"inputPrYr!D2","v":"Garden City Township"},null,null,{"$f":"inputPrYr!D5","v":2013}]
[]
[null,"FUND PAGE FOR FUNDS WITH A TAX LEVY"]
[null,"Adopted Budget","Prior Year","Current Year","Proposed Budget"]
[null,{"$f":"inputPrYr!B22","v":0},{"$f":"gen!C5","v":"Actual for 2011"},{"$f":"gen!D5","v":"Estimate for 2012"},{"$f":"gen!E5","v":"Year for 2013"}]
[null,"Unencumbered Cash Balance January 1",null,{"$f":"C34","v":0},{"$f":"D34","v":0}]
[null,"Receipts:"]
[null,"Ad Valorem Tax",null,{"$f":"IF(inputPrYr!H15>0,inputPrYr!G22,inputPrYr!E22)","v":0},"x"]
[null,"Delinquent Tax"]
[null,"Motor Vehicle Tax",null,null,{"$f":"mvalloc!G17","v":0}]
[null,"Recreational Vehicle Tax",null,null,{"$f":"mvalloc!I17","v":0}]
[null,"16/20M Vehicle Tax",null,null,{"$f":"mvalloc!J17","v":0}]
[]
[]
[]
[]
[null,"Interest on Idle Funds"]
[null,"Miscellaneous"]
[null,"Does miscellaneous exceed 10% of Total Receipts",{"$f":"IF(C20*0.1<C18,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(D20*0.1<D18,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(E20*0.1+E40<E18,\"Exceed 10% Rule\",\"\")","v":""}]
[null,"Total Receipts",{"$f":"SUM(C8:C18)","v":0},{"$f":"SUM(D8:D18)","v":0},{"$f":"SUM(E8:E18)","v":0}]
[null,"Resources Available:",{"$f":"C20+C6","v":0},{"$f":"D20+D6","v":0},{"$f":"E20+E6","v":0}]
[null,"Expenditures:"]
[]
[null,null,null,null,null,null,{"$f":"CONCATENATE(\"Desired Carryover Into \",E1+1,\"\")","v":"Desired Carryover Into 2014"}]
[]
[null,null,null,null,null,null,"Desired Carryover Amount:",null,null,0]
[null,null,null,null,null,null,"Estimated Mill Rate Impact:",null,null,{"$f":"IF(J26=0,\"\",ROUND((J26+E40-G39)/inputOth!E7*1000,3)-G44)","v":""}]
[null,null,null,null,null,null,{"$f":"CONCATENATE(\"\",E1,\" Tot Exp/Non-Appr Must Be:\")","v":"2013 Tot Exp/Non-Appr Must Be:"},null,null,{"$f":"IF(J26>0,IF(E37<E21,IF(J26=G39,E37,((J26-G39)*(1-D39))+E21),E37+(J26-G39)),0)","v":0}]
[null,null,null,null,null,null,"Expenditures Must Be Changed by:",null,null,{"$f":"IF(J26>0,J28-E37,0)","v":0}]
[null,"Neighborhood Revitalization Rebate",null,null,{"$f":"nhood!E12","v":""}]
[null,"Miscellaneous",null,null,null,null,{"$f":"CONCATENATE(\"Projected Carryover Into \",E1+1,\"\")","v":"Projected Carryover Into 2014"}]
[null,"Does misc. exceed 10% of Total Expenditures",{"$f":"IF(C33*0.1<C31,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(D33*0.1<D31,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(E33*0.1<E31,\"Exceed 10% Rule\",\"\")","v":""}]
[null,"Total Expenditures",{"$f":"SUM(C23:C31)","v":0},{"$f":"SUM(D23:D31)","v":0},{"$f":"SUM(E23:E31)","v":0},null,{"$f":"D34","v":0},{"$f":"CONCATENATE(\"\",E1-1,\" Ending Cash Balance (est.)\")","v":"2012 Ending Cash Balance (est.)"}]
[null,"Unencumbered Cash Balance Dec 31",{"$f":"C21-C33","v":0},{"$f":"D21-D33","v":0},"x",null,{"$f":"E20","v":0},{"$f":"CONCATENATE(\"\",E1,\" Non-AV Receipts (est.)\")","v":"2013 Non-AV Receipts (est.)"}]
[null,{"$f":"CONCATENATE(\"\",E1-2,\"/\",E1-1,\" Budget Authority Amount:\")","v":"2011/2012 Budget Authority Amount:"},{"$f":"inputOth!B52","v":0},{"$f":"inputPrYr!D22","v":0},"x",null,{"$f":"IF(E39>0,E38,E40)","v":0},{"$f":"CONCATENATE(\"\",E1,\" Ad Valorem Tax (est.)\")","v":"2013 Ad Valorem Tax (est.)"},null,null,{"$f":"IF(G35=E40,\"\",\"Note: Does not include Delinquent Taxes\")","v":""}]
[null,null,"Non-Appropriated Balance",null,null,{"$f":"IF(E33/0.95-E33<E36,\"Exceeds 5%\",\"\")","v":""},{"$f":"SUM(G33:G35)","v":0},{"$f":"CONCATENATE(\"Total \",E1,\" Resources Available\")","v":"Total 2013 Resources Available"}]
[null,{"$f":"CONCATENATE(C92,\"     \",D92)","v":"     "},"Total Expenditure/Non-Appr Balance",null,{"$f":"E33+E36","v":0}]
[null,{"$f":"CONCATENATE(C93,\"     \",D93)","v":"     "},null,"Tax Required",{"$f":"IF(E37-E21>0,E37-E21,0)","v":0},null,{"$f":"C33*0.05+C33","v":0},{"$f":"CONCATENATE(\"Less \",E1-2,\" Expenditures + 5%\")","v":"Less 2011 Expenditures + 5%"}]
[null,null,"Delinquent Comp Rate:",{"$f":"inputOth!$E$40","v":0},{"$f":"ROUND(IF(D39>0,(E38*D39),0),0)","v":0},null,{"$f":"G36-G38","v":0},{"$f":"CONCATENATE(\"Projected \",E1+1,\" carryover (est.)\")","v":"Projected 2014 carryover (est.)"}]
[null,null,{"$f":"CONCATENATE(\"Amount of  \",$E$1-1,\" Ad Valorem Tax\")","v":"Amount of  2012 Ad Valorem Tax"},null,{"$f":"E38+E39","v":0}]
[null,null,null,null,null,null,"Mill Rate Comparison"]
[]
[null,"Adopted Budget",null,null,null,null,{"$f":"summ!#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(\"\",E1,\" Fund Mill Rate\")","v":"2013 Fund Mill Rate"}]
[null,null,"Prior Year","Current Year","Proposed Budget",null,{"$f":"summ!#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(\"\",E1-1,\" Fund Mill Rate\")","v":"2012 Fund Mill Rate"}]
[null,{"$f":"inputPrYr!B23","v":0},{"$f":"C5","v":"Actual for 2011"},{"$f":"D5","v":"Estimate for 2012"},{"$f":"E5","v":"Year for 2013"},null,{"$f":"summ!I22","v":1.1739999999999999},{"$f":"CONCATENATE(\"Total \",E1,\" Mill Rate\")","v":"Total 2013 Mill Rate"}]
[null,"Unencumbered Cash Balance January 1",null,{"$f":"C74","v":0},{"$f":"D74","v":0},null,{"$f":"summ!F22","v":0.92300000000000004},{"$f":"CONCATENATE(\"Total \",E1-1,\" Mill Rate\")","v":"Total 2012 Mill Rate"}]
[null,"Receipts:"]
[null,"Ad Valorem Tax",null,{"$f":"IF(inputPrYr!H15>0,inputPrYr!G23,inputPrYr!E23)","v":0},"x"]
[null,"Delinquent Tax"]
[null,"Motor Vehicle Tax",null,null,{"$f":"mvalloc!G18","v":0}]
[null,"Recreational Vehicle Tax",null,null,{"$f":"mvalloc!I18","v":0}]
[null,"16/20M Vehicle Tax",null,null,{"$f":"mvalloc!J18","v":0}]
[]
[]
[]
[]
[null,"Interest on Idle Funds"]
[null,"Miscellaneous"]
[null,"Does miscellaneous exceed 10% of Total Receipts",{"$f":"IF(C60*0.1<C58,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(D60*0.1<D58,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(E60*0.1+E80<E58,\"Exceed 10% Rule\",\"\")","v":""}]
[null,"Total Receipts",{"$f":"SUM(C48:C58)","v":0},{"$f":"SUM(D48:D58)","v":0},{"$f":"SUM(E48:E58)","v":0}]
[null,"Resources Available:",{"$f":"C60+C46","v":0},{"$f":"D60+D46","v":0},{"$f":"E60+E46","v":0}]
[null,"Expenditures:"]
[]
[null,null,null,null,null,null,{"$f":"CONCATENATE(\"Desired Carryover Into \",E1+1,\"\")","v":"Desired Carryover Into 2014"}]
[]
[null,null,null,null,null,null,"Desired Carryover Amount:",null,null,0]
[null,null,null,null,null,null,"Estimated Mill Rate Impact:",null,null,{"$f":"IF(J66=0,\"\",ROUND((J66+E80-G79)/inputOth!E7*1000,3)-G84)","v":""}]
[null,null,null,null,null,null,{"$f":"CONCATENATE(\"\",E1,\" Tot Exp/Non-Appr Must Be:\")","v":"2013 Tot Exp/Non-Appr Must Be:"},null,null,{"$f":"IF(J66>0,IF(E77<E61,IF(J66=G79,E77,((J66-G79)*(1-D79))+E61),E77+(J66-G79)),0)","v":0}]
[null,null,null,null,null,null,"Expenditures Must Be Changed by:",null,null,{"$f":"IF(J66>0,J68-E77,0)","v":0}]
[null,"Neighborhood Revitalization Rebate",null,null,{"$f":"nhood!E13","v":""}]
[null,"Miscellaneous",null,null,null,null,{"$f":"CONCATENATE(\"Projected Carryover Into \",E1+1,\"\")","v":"Projected Carryover Into 2014"}]
[null,"Does misc. exceed 10% of Total Expenditures",{"$f":"IF(C73*0.1<C71,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(D73*0.1<D71,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(E73*0.1<E71,\"Exceed 10% Rule\",\"\")","v":""}]
[null,"Total Expenditures",{"$f":"SUM(C63:C71)","v":0},{"$f":"SUM(D63:D71)","v":0},{"$f":"SUM(E63:E71)","v":0},null,{"$f":"D74","v":0},{"$f":"CONCATENATE(\"\",E1-1,\" Ending Cash Balance (est.)\")","v":"2012 Ending Cash Balance (est.)"}]
[null,"Unencumbered Cash Balance Dec 31",{"$f":"C61-C73","v":0},{"$f":"D61-D73","v":0},"x",null,{"$f":"E60","v":0},{"$f":"CONCATENATE(\"\",E1,\" Non-AV Receipts (est.)\")","v":"2013 Non-AV Receipts (est.)"}]
[null,{"$f":"CONCATENATE(\"\",E1-2,\"/\",E1-1,\" Budget Authority Amount:\")","v":"2011/2012 Budget Authority Amount:"},{"$f":"inputOth!B53","v":0},{"$f":"inputPrYr!D23","v":0},"x",null,{"$f":"IF(E79>0,E78,E80)","v":0},{"$f":"CONCATENATE(\"\",E1,\" Ad Valorem Tax (est.)\")","v":"2013 Ad Valorem Tax (est.)"},null,null,{"$f":"IF(G75=E80,\"\",\"Note: Does not include Delinquent Taxes\")","v":""}]
[null,null,"Non-Appropriated Balance",null,null,{"$f":"IF(E73/0.95-E73<E76,\"Exceeds 5%\",\"\")","v":""},{"$f":"SUM(G73:G75)","v":0},{"$f":"CONCATENATE(\"Total \",E1,\" Resources Available\")","v":"Total 2013 Resources Available"}]
[null,{"$f":"CONCATENATE(C94,\"     \",D94)","v":"     "},"Total Expenditure/Non-Appr Balance",null,{"$f":"E73+E76","v":0}]
[null,{"$f":"CONCATENATE(C95,\"     \",D95)","v":"     "},null,"Tax Required",{"$f":"IF(E77-E61>0,E77-E61,0)","v":0},null,{"$f":"ROUND(C73*0.05+C73,0)","v":0},{"$f":"CONCATENATE(\"Less \",E1-2,\" Expenditures + 5%\")","v":"Less 2011 Expenditures + 5%"}]
[null,null,"Delinquent Comp Rate:",{"$f":"inputOth!$E$40","v":0},{"$f":"ROUND(IF(D79>0,(E78*D79),0),0)","v":0},null,{"$f":"G76-G78","v":0},{"$f":"CONCATENATE(\"Projected \",E1+1,\" carryover (est.)\")","v":"Projected 2014 carryover (est.)"}]
[null,null,{"$f":"CONCATENATE(\"Amount of  \",$E$1-1,\" Ad Valorem Tax\")","v":"Amount of  2012 Ad Valorem Tax"},null,{"$f":"E78+E79","v":0}]
[null,"Page No.",null,null,null,null,"Mill Rate Comparison"]
[]
[null,null,null,null,null,null,{"$f":"summ!#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(\"\",E1,\" Fund Mill Rate\")","v":"2013 Fund Mill Rate"}]
[null,null,null,null,null,null,{"$f":"summ!#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(\"\",E1-1,\" Fund Mill Rate\")","v":"2012 Fund Mill Rate"}]
[null,null,null,null,null,null,{"$f":"summ!I22","v":1.1739999999999999},{"$f":"CONCATENATE(\"Total \",E1,\" Mill Rate\")","v":"Total 2013 Mill Rate"}]
[null,null,null,null,null,null,{"$f":"summ!F22","v":0.92300000000000004},{"$f":"CONCATENATE(\"Total \",E1-1,\" Mill Rate\")","v":"Total 2012 Mill Rate"}]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(C33>C35,\"See Tab A\",\"\")","v":""},{"$f":"IF(D33>D35,\"See Tab C\",\"\")","v":""}]
[null,null,{"$f":"IF(C34<0,\"See Tab B\",\"\")","v":""},{"$f":"IF(D34<0,\"See Tab D\",\"\")","v":""}]
[null,null,{"$f":"IF(C73>C75,\"See Tab A\",\"\")","v":""},{"$f":"IF(D73>D75,\"See Tab C\",\"\")","v":""}]
[null,null,{"$f":"IF(C74<0,\"See Tab B\",\"\")","v":""},{"$f":"IF(D74<0,\"See Tab D\",\"\")","v":""}]

{"sheet":"levypage11","index":16,"n_rows":95,"n_cols":11,"rows_kept":95,"cut":false,"hidden":false,"merged":[[23,6,23,9],[30,6,30,9],[40,6,40,9],[63,6,63,9],[70,6,70,9],[35,2,35,3],[36,2,36,3],[80,6,80,9],[79,2,79,3],[39,2,39,3],[75,2,75,3],[76,2,76,3]]}
[null,{"$f":"inputPrYr!D2","v":"Garden City Township"},null,null,{"$f":"inputPrYr!D5","v":2013}]
[]
[null,"FUND PAGE FOR FUNDS WITH A TAX LEVY"]
[null,"Adopted Budget","Prior Year","Current Year","Proposed Budget"]
[null,{"$f":"inputPrYr!B24","v":0},{"$f":"gen!C5","v":"Actual for 2011"},{"$f":"gen!D5","v":"Estimate for 2012"},{"$f":"gen!E5","v":"Year for 2013"}]
[null,"Unencumbered Cash Balance January 1",null,{"$f":"C34","v":0},{"$f":"D34","v":0}]
[null,"Receipts:"]
[null,"Ad Valorem Tax",null,{"$f":"IF(inputPrYr!H15>0,inputPrYr!G24,inputPrYr!E24)","v":0},"x"]
[null,"Delinquent Tax"]
[null,"Motor Vehicle Tax",null,null,{"$f":"mvalloc!G19","v":0}]
[null,"Recreational Vehicle Tax",null,null,{"$f":"mvalloc!I19","v":0}]
[null,"16/20M Vehicle Tax",null,null,{"$f":"mvalloc!J19","v":0}]
[]
[]
[]
[]
[null,"Interest on Idle Funds"]
[null,"Miscellaneous"]
[null,"Does miscellaneous exceed 10% of Total Receipts",{"$f":"IF(C20*0.1<C18,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(D20*0.1<D18,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(E20*0.1+E40<E18,\"Exceed 10% Rule\",\"\")","v":""}]
[null,"Total Receipts",{"$f":"SUM(C8:C18)","v":0},{"$f":"SUM(D8:D18)","v":0},{"$f":"SUM(E8:E18)","v":0}]
[null,"Resources Available:",{"$f":"C20+C6","v":0},{"$f":"D20+D6","v":0},{"$f":"E20+E6","v":0}]
[null,"Expenditures:"]
[]
[null,null,null,null,null,null,{"$f":"CONCATENATE(\"Desired Carryover Into \",E1+1,\"\")","v":"Desired Carryover Into 2014"}]
[]
[null,null,null,null,null,null,"Desired Carryover Amount:",null,null,0]
[null,null,null,null,null,null,"Estimated Mill Rate Impact:",null,null,{"$f":"IF(J26=0,\"\",ROUND((J26+E40-G39)/inputOth!E7*1000,3)-G44)","v":""}]
[null,null,null,null,null,null,{"$f":"CONCATENATE(\"\",E1,\" Tot Exp/Non-Appr Must Be:\")","v":"2013 Tot Exp/Non-Appr Must Be:"},null,null,{"$f":"IF(J26>0,IF(E37<E21,IF(J26=G39,E37,((J26-G39)*(1-D39))+E21),E37+(J26-G39)),0)","v":0}]
[null,null,null,null,null,null,"Expenditures Must Be Changed by:",null,null,{"$f":"IF(J26>0,J28-E37,0)","v":0}]
[null,"Neighborhood Revitalization Rebate",null,null,{"$f":"nhood!E14","v":""}]
[null,"Miscellaneous",null,null,null,null,{"$f":"CONCATENATE(\"Projected Carryover Into \",E1+1,\"\")","v":"Projected Carryover Into 2014"}]
[null,"Does misc. exceed 10% of Total Expenditures",{"$f":"IF(C33*0.1<C31,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(D33*0.1<D31,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(E33*0.1<E31,\"Exceed 10% Rule\",\"\")","v":""}]
[null,"Total Expenditures",{"$f":"SUM(C23:C31)","v":0},{"$f":"SUM(D23:D31)","v":0},{"$f":"SUM(E23:E31)","v":0},null,{"$f":"D34","v":0},{"$f":"CONCATENATE(\"\",E1-1,\" Ending Cash Balance (est.)\")","v":"2012 Ending Cash Balance (est.)"}]
[null,"Unencumbered Cash Balance Dec 31",{"$f":"C21-C33","v":0},{"$f":"D21-D33","v":0},"x",null,{"$f":"E20","v":0},{"$f":"CONCATENATE(\"\",E1,\" Non-AV Receipts (est.)\")","v":"2013 Non-AV Receipts (est.)"}]
[null,{"$f":"CONCATENATE(\"\",E1-2,\"/\",E1-1,\" Budget Authority Amount:\")","v":"2011/2012 Budget Authority Amount:"},{"$f":"inputOth!B54","v":0},{"$f":"inputPrYr!D24","v":0},"x",null,{"$f":"IF(E39>0,E38,E40)","v":0},{"$f":"CONCATENATE(\"\",E1,\" Ad Valorem Tax (est.)\")","v":"2013 Ad Valorem Tax (est.)"},null,null,{"$f":"IF(G35=E40,\"\",\"Note: Does not include Delinquent Taxes\")","v":""}]
[null,null,"Non-Appropriated Balance",null,null,{"$f":"IF(E33/0.95-E33<E36,\"Exceeds 5%\",\"\")","v":""},{"$f":"SUM(G33:G35)","v":0},{"$f":"CONCATENATE(\"Total \",E1,\" Resources Available\")","v":"Total 2013 Resources Available"}]
[null,{"$f":"CONCATENATE(C92,\"     \",D92)","v":"     "},"Total Expenditure/Non-Appr Balance",null,{"$f":"E33+E36","v":0}]
[null,{"$f":"CONCATENATE(C93,\"     \",D93)","v":"     "},null,"Tax Required",{"$f":"IF(E37-E21>0,E37-E21,0)","v":0},null,{"$f":"ROUND(C33*0.05+C33,)","v":0},{"$f":"CONCATENATE(\"Less \",E1-2,\" Expenditures + 5%\")","v":"Less 2011 Expenditures + 5%"}]
[null,null,"Delinquent Comp Rate:",{"$f":"inputOth!$E$40","v":0},{"$f":"ROUND(IF(D39>0,(E38*D39),0),0)","v":0},null,{"$f":"G36-G38","v":0},{"$f":"CONCATENATE(\"Projected \",E1+1,\" carryover (est.)\")","v":"Projected 2014 carryover (est.)"}]
[null,null,{"$f":"CONCATENATE(\"Amount of  \",$E$1-1,\" Ad Valorem Tax\")","v":"Amount of  2012 Ad Valorem Tax"},null,{"$f":"E38+E39","v":0}]
[null,null,null,null,null,null,"Mill Rate Comparison"]
[]
[null,"Adopted Budget",null,null,null,null,{"$f":"summ!#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(\"\",E1,\" Fund Mill Rate\")","v":"2013 Fund Mill Rate"}]
[null,null,"Prior Year","Current Year","Proposed Budget",null,{"$f":"summ!#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(\"\",E1-1,\" Fund Mill Rate\")","v":"2012 Fund Mill Rate"}]
[null,{"$f":"inputPrYr!B25","v":0},{"$f":"C5","v":"Actual for 2011"},{"$f":"D5","v":"Estimate for 2012"},{"$f":"E5","v":"Year for 2013"},null,{"$f":"summ!I22","v":1.1739999999999999},{"$f":"CONCATENATE(\"Total \",E1,\" Mill Rate\")","v":"Total 2013 Mill Rate"}]
[null,"Unencumbered Cash Balance January 1",null,{"$f":"C74","v":0},{"$f":"D74","v":0},null,{"$f":"summ!F22","v":0.92300000000000004},{"$f":"CONCATENATE(\"Total \",E1-1,\" Mill Rate\")","v":"Total 2012 Mill Rate"}]
[null,"Receipts:"]
[null,"Ad Valorem Tax",null,{"$f":"IF(inputPrYr!H15>0,inputPrYr!G25,inputPrYr!E25)","v":0},"x"]
[null,"Delinquent Tax"]
[null,"Motor Vehicle Tax",null,null,{"$f":"mvalloc!G20","v":0}]
[null,"Recreational Vehicle Tax",null,null,{"$f":"mvalloc!I20","v":0}]
[null,"16/20M Vehicle Tax",null,null,{"$f":"mvalloc!J20","v":0}]
[]
[]
[]
[]
[null,"Interest on Idle Funds"]
[null,"Miscellaneous"]
[null,"Does miscellaneous exceed 10% of Total Receipts",{"$f":"IF(C60*0.1<C58,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(D60*0.1<D58,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(E60*0.1+E80<E58,\"Exceed 10% Rule\",\"\")","v":""}]
[null,"Total Receipts",{"$f":"SUM(C48:C58)","v":0},{"$f":"SUM(D48:D58)","v":0},{"$f":"SUM(E48:E58)","v":0}]
[null,"Resources Available:",{"$f":"C60+C46","v":0},{"$f":"D60+D46","v":0},{"$f":"E60+E46","v":0}]
[null,"Expenditures:"]
[]
[null,null,null,null,null,null,{"$f":"CONCATENATE(\"Desired Carryover Into \",E1+1,\"\")","v":"Desired Carryover Into 2014"}]
[]
[null,null,null,null,null,null,"Desired Carryover Amount:",null,null,0]
[null,null,null,null,null,null,"Estimated Mill Rate Impact:",null,null,{"$f":"IF(J66=0,\"\",ROUND((J66+E80-G79)/inputOth!E7*1000,3)-G84)","v":""}]
[null,null,null,null,null,null,{"$f":"CONCATENATE(\"\",E1,\" Tot Exp/Non-Appr Must Be:\")","v":"2013 Tot Exp/Non-Appr Must Be:"},null,null,{"$f":"IF(J66>0,IF(E77<E61,IF(J66=G79,E77,((J66-G79)*(1-D79))+E61),E77+(J66-G79)),0)","v":0}]
[null,null,null,null,null,null,"Expenditures Must Be Changed by:",null,null,{"$f":"IF(J66>0,J68-E77,0)","v":0}]
[null,"Neighborhood Revitalization Rebate",null,null,{"$f":"nhood!E15","v":""}]
[null,"Miscellaneous",null,null,null,null,{"$f":"CONCATENATE(\"Projected Carryover Into \",E1+1,\"\")","v":"Projected Carryover Into 2014"}]
[null,"Does misc. exceed 10% of Total Expenditures",{"$f":"IF(C73*0.1<C71,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(D73*0.1<D71,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(E73*0.1<E71,\"Exceed 10% Rule\",\"\")","v":""}]
[null,"Total Expenditures",{"$f":"SUM(C63:C71)","v":0},{"$f":"SUM(D63:D71)","v":0},{"$f":"SUM(E63:E71)","v":0},null,{"$f":"D74","v":0},{"$f":"CONCATENATE(\"\",E1-1,\" Ending Cash Balance (est.)\")","v":"2012 Ending Cash Balance (est.)"}]
[null,"Unencumbered Cash Balance Dec 31",{"$f":"C61-C73","v":0},{"$f":"D61-D73","v":0},"x",null,{"$f":"E60","v":0},{"$f":"CONCATENATE(\"\",E1,\" Non-AV Receipts (est.)\")","v":"2013 Non-AV Receipts (est.)"}]
[null,{"$f":"CONCATENATE(\"\",E1-2,\"/\",E1-1,\" Budget Authority Amount:\")","v":"2011/2012 Budget Authority Amount:"},{"$f":"inputOth!B55","v":0},{"$f":"inputPrYr!D25","v":0},"x",null,{"$f":"IF(E79>0,E78,E80)","v":0},{"$f":"CONCATENATE(\"\",E1,\" Ad Valorem Tax (est.)\")","v":"2013 Ad Valorem Tax (est.)"},null,null,{"$f":"IF(G75=E80,\"\",\"Note: Does not include Delinquent Taxes\")","v":""}]
[null,null,"Non-Appropriated Balance",null,null,{"$f":"IF(E73/0.95-E73<E76,\"Exceeds 5%\",\"\")","v":""},{"$f":"SUM(G73:G75)","v":0},{"$f":"CONCATENATE(\"Total \",E1,\" Resources Available\")","v":"Total 2013 Resources Available"}]
[null,null,"Total Expenditure/Non-Appr Balance",null,{"$f":"E73+E76","v":0}]
[null,null,null,"Tax Required",{"$f":"IF(E77-E61>0,E77-E61,0)","v":0},null,{"$f":"ROUND(C73*0.05+C73,0)","v":0},{"$f":"CONCATENATE(\"Less \",E1-2,\" Expenditures + 5%\")","v":"Less 2011 Expenditures + 5%"}]
[null,null,"Delinquent Comp Rate:",{"$f":"inputOth!$E$40","v":0},{"$f":"ROUND(IF(D79>0,(E78*D79),0),0)","v":0},null,{"$f":"G76-G78","v":0},{"$f":"CONCATENATE(\"Projected \",E1+1,\" carryover (est.)\")","v":"Projected 2014 carryover (est.)"}]
[null,null,{"$f":"CONCATENATE(\"Amount of  \",$E$1-1,\" Ad Valorem Tax\")","v":"Amount of  2012 Ad Valorem Tax"},null,{"$f":"E78+E79","v":0}]
[null,"Page No.",null,null,null,null,"Mill Rate Comparison"]
[]
[null,null,null,null,null,null,{"$f":"summ!#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(\"\",E1,\" Fund Mill Rate\")","v":"2013 Fund Mill Rate"}]
[null,null,null,null,null,null,{"$f":"summ!#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(\"\",E1-1,\" Fund Mill Rate\")","v":"2012 Fund Mill Rate"}]
[null,null,null,null,null,null,{"$f":"summ!I22","v":1.1739999999999999},{"$f":"CONCATENATE(\"Total \",E1,\" Mill Rate\")","v":"Total 2013 Mill Rate"}]
[null,null,null,null,null,null,{"$f":"summ!F22","v":0.92300000000000004},{"$f":"CONCATENATE(\"Total \",E1-1,\" Mill Rate\")","v":"Total 2012 Mill Rate"}]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(C33>C35,\"See Tab A\",\"\")","v":""},{"$f":"IF(D33>D35,\"See Tab C\",\"\")","v":""}]
[null,null,{"$f":"IF(C34<0,\"See Tab B\",\"\")","v":""},{"$f":"IF(D34<0,\"See Tab D\",\"\")","v":""}]
[null,null,{"$f":"IF(C73>C75,\"See Tab A\",\"\")","v":""},{"$f":"IF(D73>D75,\"See Tab C\",\"\")","v":""}]
[null,null,{"$f":"IF(C74<0,\"See Tab B\",\"\")","v":""},{"$f":"IF(D74<0,\"See Tab D\",\"\")","v":""}]

{"sheet":"nolevypage12","index":17,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"inputPrYr!D2","v":"Garden City Township"},null,null,{"$f":"inputPrYr!D5","v":2013}]
[]
[null,"FUND PAGE FOR FUNDS WITH NO TAX LEVY"]
[null,"Adopted Budget","Prior Year","Current Year","Proposed Budget"]
[null,{"$f":"inputPrYr!B29","v":0},{"$f":"gen!C5","v":"Actual for 2011"},{"$f":"gen!D5","v":"Estimate for 2012"},{"$f":"gen!E5","v":"Year for 2013"}]
[null,"Unencumbered Cash Balance Jan 1",null,{"$f":"C29","v":0},{"$f":"D29","v":0}]
[null,"Receipts:"]
[]
[]
[]
[]
[null,"Interest on Idle Funds"]
[null,"Miscellaneous"]
[null,"Does miscellaneous exceed 10% of Total Receipts",{"$f":"IF(C15*0.1<C13,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(D15*0.1<D13,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(E15*0.1<E13,\"Exceed 10% Rule\",\"\")","v":""}]
[null,"Total Receipts",{"$f":"SUM(C8:C13)","v":0},{"$f":"SUM(D8:D13)","v":0},{"$f":"SUM(E8:E13)","v":0}]
[null,"Resources Available:",{"$f":"C6+C15","v":0},{"$f":"D6+D15","v":0},{"$f":"E6+E15","v":0}]
[null,"Expenditures:"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Miscellaneous"]
[null,"Does misc. exceed 10% of Total Expenditures",{"$f":"IF(C28*0.1<C26,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(D28*0.1<D26,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(E28*0.1<E26,\"Exceed 10% Rule\",\"\")","v":""}]
[null,"Total Expenditures",{"$f":"SUM(C18:C26)","v":0},{"$f":"SUM(D18:D26)","v":0},{"$f":"SUM(E18:E26)","v":0}]
[null,"Unencumbered Cash Balance Dec 31",{"$f":"C16-C28","v":0},{"$f":"D16-D28","v":0},{"$f":"E16-E28","v":0}]
[null,{"$f":"CONCATENATE(\"\",E1-2,\"/\",E1-1,\" Budget Authority Amount:\")","v":"2011/2012 Budget Authority Amount:"},{"$f":"inputOth!B56","v":0},{"$f":"inputPrYr!D29","v":0},{"$f":"IF(E29<0,\"See Tab E\",\"\")","v":""}]
[null,null,{"$f":"IF(C28>C30,\"See Tab A\",\"\")","v":""},{"$f":"IF(D28>D30,\"See Tab C\",\"\")","v":""}]
[null,null,{"$f":"IF(C29<0,\"See Tab B\",\"\")","v":""},{"$f":"IF(D29<0,\"See Tab D\",\"\")","v":""}]
[]
[null,"Adopted Budget"]
[null,null,"Prior Year","Current Year","Proposed Budget"]
[null,{"$f":"inputPrYr!B30","v":0},{"$f":"C5","v":"Actual for 2011"},{"$f":"D5","v":"Estimate for 2012"},{"$f":"E5","v":"Year for 2013"}]
[null,"Unencumbered Cash Balance Jan 1",null,{"$f":"C60","v":0},{"$f":"D60","v":0}]
[null,"Receipts:"]
[]
[]
[]
[]
[null,"Interest on Idle Funds"]
[null,"Miscellaneous"]
[null,"Does miscellaneous exceed 10% of Total Receipts",{"$f":"IF(C46*0.1<C44,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(D46*0.1<D44,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(E46*0.1<E44,\"Exceed 10% Rule\",\"\")","v":""}]
[null,"Total Receipts",{"$f":"SUM(C39:C44)","v":0},{"$f":"SUM(D39:D44)","v":0},{"$f":"SUM(E39:E44)","v":0}]
[null,"Resources Available:",{"$f":"C37+C46","v":0},{"$f":"D37+D46","v":0},{"$f":"E37+E46","v":0}]
[null,"Expenditures:"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Miscellaneous"]
[null,"Does misc. exceed 10% of Total Expenditures",{"$f":"IF(C59*0.1<C57,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(D59*0.1<D57,\"Exceed 10% Rule\",\"\")","v":""},{"$f":"IF(E59*0.1<E57,\"Exceed 10% Rule\",\"\")","v":""}]
[null,"Total Expenditures",{"$f":"SUM(C49:C57)","v":0},{"$f":"SUM(D49:D57)","v":0},{"$f":"SUM(E49:E57)","v":0}]
[null,"Unencumbered Cash Balance Dec 31",{"$f":"C47-C59","v":0},{"$f":"D47-D59","v":0},{"$f":"E47-E59","v":0}]
[null,{"$f":"CONCATENATE(\"\",E1-2,\"/\",E1-1,\" Budget Authority Amount:\")","v":"2011/2012 Budget Authority Amount:"},{"$f":"inputOth!B57","v":0},{"$f":"inputPrYr!D30","v":0},{"$f":"IF(E60<0,\"See Tab E\",\"\")","v":""}]
[null,null,{"$f":"IF(C59>C61,\"See Tab A\",\"\")","v":""},{"$f":"IF(D59>D61,\"See Tab C\",\"\")","v":""}]
[null,null,{"$f":"IF(C60<0,\"See Tab B\",\"\")","v":""},{"$f":"IF(D60<0,\"See Tab D\",\"\")","v":""}]
[]
[null,"Page No."]

{"sheet":"nonbud","index":18,"n_rows":33,"n_cols":12,"rows_kept":33,"cut":false,"hidden":false,"merged":[[4,0,4,1],[4,2,4,3],[4,4,4,5],[4,6,4,7],[4,8,4,9]]}
[{"$f":"inputPrYr!$D$2","v":"Garden City Township"},null,null,null,null,"NON-BUDGETED FUNDS ",null,null,null,null,{"$f":"inputPrYr!$D$5","v":2013}]
[null,null,null,null,null,{"$f":"CONCATENATE(\"(Only the actual budget year for \",K1-2,\" is to be shown)\")","v":"(Only the actual budget year for 2011 is to be shown)"}]
["Non-Budgeted Funds"]
["(1) Fund Name:",null,"(2) Fund Name:",null,"(3) Fund Name:",null,"(4) Fund Name:",null,"(5) Fund Name:"]
[{"$f":"inputPrYr!B34","v":0},null,{"$f":"inputPrYr!B35","v":0},null,{"$f":"inputPrYr!B36","v":0},null,{"$f":"inputPrYr!B37","v":0},null,{"$f":"inputPrYr!B38","v":0}]
["Unencumbered ",null,"Unencumbered ",null,"Unencumbered ",null,"Unencumbered ",null,"Unencumbered ",null,"Total"]
["Cash Balance Jan 1",null,"Cash Balance Jan 1",null,"Cash Balance Jan 1",null,"Cash Balance Jan 1",null,"Cash Balance Jan 1",null,{"$f":"SUM(B7+D7+F7+H7+J7)","v":0}]
["Receipts:",null,"Receipts:",null,"Receipts:",null,"Receipts:",null,"Receipts:"]
[]
[]
[]
[]
[]
[]
[]
[]
["Total Receipts",{"$f":"SUM(B9:B16)","v":0},"Total Receipts",{"$f":"SUM(D9:D16)","v":0},"Total Receipts",{"$f":"SUM(F9:F16)","v":0},"Total Receipts",{"$f":"SUM(H9:H16)","v":0},"Total Receipts",{"$f":"SUM(J9:J16)","v":0},{"$f":"SUM(B17+D17+F17+H17+J17)","v":0}]
["Resources Available:",{"$f":"SUM(B7+B17)","v":0},"Resources Available:",{"$f":"SUM(D7+D17)","v":0},"Resources Available:",{"$f":"SUM(F7+F17)","v":0},"Resources Available:",{"$f":"SUM(H7+H17)","v":0},"Resources Available:",{"$f":"SUM(J7+J17)","v":0},{"$f":"SUM(B18+D18+F18+H18+J18)","v":0}]
["Expenditures:",null,"Expenditures:",null,"Expenditures:",null,"Expenditures:",null,"Expenditures:"]
[]
[]
[]
[]
[]
[]
[]
[]
["Total Expenditures",{"$f":"SUM(B20:B27)","v":0},"Total Expenditures",{"$f":"SUM(D20:D27)","v":0},"Total Expenditures",{"$f":"SUM(F20:F27)","v":0},"Total Expenditures",{"$f":"SUM(H20:H27)","v":0},"Total Expenditures",{"$f":"SUM(J20:J27)","v":0},{"$f":"SUM(B28+D28+F28+H28+J28)","v":0}]
["Cash Balance Dec 31",{"$f":"SUM(B18-B28)","v":0},"Cash Balance Dec 31",{"$f":"SUM(D18-D28)","v":0},"Cash Balance Dec 31",{"$f":"SUM(F18-F28)","v":0},"Cash Balance Dec 31",{"$f":"SUM(H18-H28)","v":0},"Cash Balance Dec 31",{"$f":"SUM(J18-J28)","v":0},{"$f":"SUM(B29+D29+F29+H29+J29)","v":0},"**"]
[null,{"$f":"IF(B29<0,\"See Tab B\",\"\")","v":""},null,{"$f":"IF(D29<0,\"See Tab B\",\"\")","v":""},null,{"$f":"IF(F29<0,\"See Tab B\",\"\")","v":""},null,{"$f":"IF(H29<0,\"See Tab B\",\"\")","v":""},null,{"$f":"IF(J29<0,\"See Tab B\",\"\")","v":""},{"$f":"SUM(K7+K17-K28)","v":0},"**"]
[null,null,null,null,null,null,"** Note: These two block figures should agree."]
[]
[null,null,null,null,"Page No."]

{"sheet":"NonBudFunds","index":19,"n_rows":25,"n_cols":1,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Non-Budgeted Funds - Townships"]
["K.S.A. 12-110d.  Special ambulance or emergency medical service equipment fund.  The governing body may create a special reserve fund for replacement of ambulance or emergency medical service equipment."]
[]
["K.S.A. 12-631p.  Sewerage system reserve fund.  The governing body may create a sewer system reserve fund for the future maintenance and operation of its system and for the construction of improvements and expansions to such system."]
[]
["K.S.A. 12-1663.  Federal grants (e.g. FEMA).  Federal aid intended to be used alone or with funds of the public agency may be expended without regard to budget limitations and over, above or outside the budget."]
[]
["K.S.A. 12-16,102.  Employee benefits trust funds.  For the purpose of holding and investing the assets of other postemployment benefits funds any taxing subdivision may establish one or more trust funds."]
[]
["K.S.A. 12-16,111.  State loans and grants.  State loans or grants may be expended without regard to budget limitations and over, above or outside the budget."]
[]
["K.S.A. 12-17,118.  Neighborhood revitalization fund.  After adoption of a neighborhood revitalization plan the governing body shall create a neighborhood revitalization fund."]
[]
["K.S.A. 68-141g.  Special road, bridge or street building machinery, equipment and bridge building fund.  Authorizes a special road, bridge or street building machinery, equipment and bridge building fund and the annual transfer of not to exceed 25% of the budgeted amount of the corresponding operating fund."]
[]
["K.S.A. 75-6110.  Special liability expense fund.  Authorizes the creation of special liability expense fund for payment of costs and claims against the municipality or its employees."]
[]
["K.S.A. 79-1808.  Special assessment fund.  Proceeds of tax levy to raise funds to pay special assessments against municipality-owned property and, for cities and counties, to pay debt service, shall be placed in a special assessment fund."]
[]
["K.S.A. 79-2925.   Budgets exempt from the state budget law.  The state budget law does not apply to townships in counties having the county road unit system which have an annual expenditure of less than $200, and to any money received as a gift or bequest."]
[]
["K.S.A. 80-122.  Township equipment reserve fund.  Authorizes a township to create a township equipment reserve fund to finance the acquisition of equipment and to budget and transfer each year to such fund up to 25% of the general fund."]
[]
[]
["K.S.A. 80-1558.  Township special fire protection reserve fund.  Authorizes a township to create a township special fire protection reserve fund to finance the acquisition of fire-fighting equipment, land, and buildings, and to transfer each year to such fund up to 25% of the money credited to the fire fund."]

{"sheet":"summ","index":20,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,1,1,8],[35,1,35,2],[34,1,34,2],[21,10,21,13],[27,10,27,13],[18,10,18,13],[2,1,2,8],[12,7,14,7],[5,1,5,8],[4,1,4,8],[3,1,3,8]]}
[null,"Published in the Garden City Telegram July 14, 2012",null,null,null,null,null,null,{"$f":"inputPrYr!D5","v":2013}]
[null,"NOTICE OF BUDGET HEARING"]
[null,"The governing body of"]
[null,{"$f":"inputPrYr!D2","v":"Garden City Township"}]
[null,{"$f":"inputPrYr!D3","v":"Finney County"}]
[null,{"$f":"CONCATENATE(\"will meet on \",inputBudSum!B8,\" at \",inputBudSum!B10,\" at \",inputBudSum!B12,\" for the purpose of hearing and\")","v":"will meet on July 25, 2012 at 10:30 a.m. at 2005 E. 6 Mile Road for the purpose of hearing and"}]
[null,"answering objections of taxpayers relating to the proposed use of all funds and the amount of ad valorem tax."]
[null,{"$f":"CONCATENATE(\"Detailed budget information is available at \",inputBudSum!B15,\" and will be available at this hearing.\")","v":"Detailed budget information is available at Finney County Clerk's office and will be available at this hearing."}]
[null,"BUDGET SUMMARY"]
[null,{"$f":"CONCATENATE(\"Proposed Budget \",I1,\" Expenditures and Amount of \",I1-1,\" Ad Valorem Tax establish the maximum limits\")","v":"Proposed Budget 2013 Expenditures and Amount of 2012 Ad Valorem Tax establish the maximum limits"}]
[null,{"$f":"CONCATENATE(\"of the \",I1,\" budget.  Estimated Tax Rate is subject to change depending on the final assessed valuation.\")","v":"of the 2013 budget.  Estimated Tax Rate is subject to change depending on the final assessed valuation."}]
[null,null,{"$f":"CONCATENATE(\"Prior Year Actual \",I1-2,\"\")","v":"Prior Year Actual 2011"},null,{"$f":"CONCATENATE(\"Current Year Estimate \",I1-1,\"\")","v":"Current Year Estimate 2012"},null,{"$f":"CONCATENATE(\"Proposed Budget \",I1,\"\")","v":"Proposed Budget 2013"}]
[null,null,null,"Actual",null,"Actual",null,{"$f":"CONCATENATE(\"Amount of \",I1-1,\" Ad Valorem Tax\")","v":"Amount of 2012 Ad Valorem Tax"},"Est."]
[null,null,null,"Tax",null,"Tax","Budget Authority",null,"Tax"]
[null,"Fund","Expenditures","Rate*","Expenditures","Rate*","for Expenditures",null,"Rate*"]
[null,{"$f":"inputPrYr!B16","v":"General"},{"$f":"IF(gen!$C$50<>0,gen!$C$50,\"  \")","v":350},{"$f":"IF(inputPrYr!D42>0,inputPrYr!D42,\"  \")","v":"  "},{"$f":"IF(gen!$D$50<>0,gen!$D$50,\"  \")","v":10500},{"$f":"IF(inputOth!D17>0,inputOth!D17,\"  \")","v":"  "},{"$f":"IF(gen!$E$50<>0,gen!$E$50,\"  \")","v":38539},{"$f":"IF(gen!$E$57<>0,gen!$E$57,\" \")","v":" "},{"$f":"IF(gen!E57>0,ROUND(H16/$G$27*1000,3),\" \")","v":" "}]
[null,"Debt Service",{"$f":"IF('DebtSvs-Library'!C33<>0,'DebtSvs-Library'!C33,\"  \")","v":"  "},{"$f":"IF(inputPrYr!D43>0,inputPrYr!D43,\"  \")","v":"  "},{"$f":"IF('DebtSvs-Library'!D33<>0,'DebtSvs-Library'!D33,\"  \")","v":"  "},{"$f":"IF(inputOth!D18>0,inputOth!D18,\"  \")","v":"  "},{"$f":"IF('DebtSvs-Library'!E33<>0,'DebtSvs-Library'!E33,\"  \")","v":"  "},{"$f":"IF('DebtSvs-Library'!E40<>0,'DebtSvs-Library'!E40,\" \")","v":" "},{"$f":"IF('DebtSvs-Library'!E40>0,ROUND(H17/$G$27*1000,3),\" \")","v":" "}]
[null,{"$f":"IF(inputPrYr!$B18>\"  \",inputPrYr!$B18,\"  \")","v":"Library"},{"$f":"IF('DebtSvs-Library'!C73<>0,'DebtSvs-Library'!C73,\"  \")","v":"  "},{"$f":"IF(inputPrYr!D44>0,inputPrYr!D44,\"  \")","v":"  "},{"$f":"IF('DebtSvs-Library'!D73<>0,'DebtSvs-Library'!D73,\"  \")","v":"  "},{"$f":"IF(inputOth!D19>0,inputOth!D19,\"  \")","v":"  "},{"$f":"IF('DebtSvs-Library'!E73<>0,'DebtSvs-Library'!E73,\"  \")","v":"  "},{"$f":"IF('DebtSvs-Library'!E80<>0,'DebtSvs-Library'!E80,\" \")","v":" "},{"$f":"IF('DebtSvs-Library'!E80>0,ROUND(H18/$G$27*1000,3),\" \")","v":" "}]
[null,{"$f":"IF(inputPrYr!$B19>\"  \",inputPrYr!$B19,\"  \")","v":"Road"},{"$f":"IF(road!$C$43<>0,road!$C$43,\"  \")","v":"  "},{"$f":"IF(inputPrYr!D45>0,inputPrYr!D45,\"  \")","v":"  "},{"$f":"IF(road!$D$43<>0,road!$D$43,\"  \")","v":"  "},{"$f":"IF(inputOth!D20>0,inputOth!D20,\"  \")","v":"  "},{"$f":"IF(road!$E$43<>0,road!$E$43,\"  \")","v":"  "},{"$f":"IF(road!$E$50<>0,road!$E$50,\"  \")","v":"  "},{"$f":"IF(road!E50>0,ROUND(H19/$G$27*1000,3),\" \")","v":" "},null,{"$f":"CONCATENATE(\"Estimated Value Of One Mill For \",I1,\"\")","v":"Estimated Value Of One Mill For 2013"}]
[null,{"$f":"IF(inputPrYr!$B20>\"  \",inputPrYr!$B20,\"  \")","v":"Fire"},{"$f":"IF(levypage9!$C$33<>0,levypage9!$C$33,\"  \")","v":102381},{"$f":"IF(inputPrYr!D46>0,inputPrYr!D46,\"  \")","v":0.18099999999999999},{"$f":"IF(levypage9!$D$33<>0,levypage9!$D$33,\"  \")","v":106000},{"$f":"IF(inputOth!D21>0,inputOth!D21,\"  \")","v":0.92300000000000004},{"$f":"IF(levypage9!$E$33<>0,levypage9!$E$33,\"  \")","v":190000},{"$f":"IF(levypage9!$E$40<>0,levypage9!$E$40,\"  \")","v":98116},{"$f":"IF(levypage9!E40>0,ROUND(H20/$G$27*1000,3),\" \")","v":1.1739999999999999}]
[null,"Special Machinery",{"$f":"IF(road!C64<>0,road!C64,\"  \")","v":"  "}]
[null,"Totals",{"$f":"SUM(C16:C21)","v":102731},0.18099999999999999,116500,0.92300000000000004,228539,98116,1.1739999999999999,null,{"$f":"CONCATENATE(\"Impact On Keeping The Same Mill Rate As For \",I1-1,\"\")","v":"Impact On Keeping The Same Mill Rate As For 2012"}]
[null,"Less: Transfers",{"$f":"transfer!C29","v":0},null,{"$f":"transfer!D29","v":0},null,{"$f":"transfer!E29","v":0}]
[null,"Net Expenditure",{"$f":"C22-C23","v":102731},null,{"$f":"E22-E23","v":116500},null,{"$f":"G22-G23","v":228539},null,null,null,{"$f":"CONCATENATE(\"\",I1,\" Ad Valorem Tax Revenue:\")","v":"2013 Ad Valorem Tax Revenue:"},null,null,{"$f":"H22","v":98116}]
[null,"Total Tax Levied",{"$f":"inputPrYr!E54","v":87521},null,{"$f":"inputPrYr!E26","v":77801},null,"x",null,null,null,{"$f":"CONCATENATE(\"\",I1-1,\" Ad Valorem Tax Revenue:\")","v":"2012 Ad Valorem Tax Revenue:"},null,null,{"$f":"ROUND(G27*#REF!/1000,0)","v":{"$error":"#REF!"}}]
[null,"Assessed Valuation:",null,null,null,null,null,null,null,null,"Change in Ad Valorem Tax Revenue:",null,null,{"$f":"N24-N25","v":{"$error":"#REF!"}}]
[null,"  Township",{"$f":"inputPrYr!E55","v":74128974},null,{"$f":"inputOth!E29","v":84374869},null,{"$f":"inputOth!E7","v":83550962}]
[null,"Outstanding Indebtedness,",null,null,null,null,null,null,null,null,"What Mill Rate Would Be Desired?"]
[null,"  Jan 1",{"$f":"I1-3","v":2010},null,{"$f":"I1-2","v":2011},null,{"$f":"I1-1","v":2012}]
[null,"G.O. Bonds",{"$f":"inputPrYr!D59","v":0},null,{"$f":"inputPrYr!E59","v":0},null,{"$f":"'debt-lease'!F11","v":0},null,null,null,{"$f":"CONCATENATE(\"Current \",I1,\" Estimated Mill Rate:\")","v":"Current 2013 Estimated Mill Rate:"},null,null,{"$f":"I22","v":1.1739999999999999}]
[null,"Other",{"$f":"inputPrYr!D60","v":0},null,{"$f":"inputPrYr!E60","v":0},null,{"$f":"'debt-lease'!F15","v":0},null,null,null,{"$f":"CONCATENATE(\"Desired \",I1,\" Mill Rate:\")","v":"Desired 2013 Mill Rate:"},null,null,0]
[null,"Lease Purchase Principal",{"$f":"inputPrYr!D61","v":0},null,{"$f":"inputPrYr!E61","v":0},null,{"$f":"'debt-lease'!G36","v":0},null,null,null,{"$f":"CONCATENATE(\"\",I1,\" Ad Valorem Tax:\")","v":"2013 Ad Valorem Tax:"},null,null,{"$f":"ROUND(G27*N31/1000,0)","v":0}]
[null,"     Total",{"$f":"SUM(C30:C32)","v":0},null,{"$f":"SUM(E30:E32)","v":0},null,{"$f":"SUM(G30:G32)","v":0},null,null,null,{"$f":"CONCATENATE(\"\",I1,\" Tax Levy Fund Exp. Changed By:\")","v":"2013 Tax Levy Fund Exp. Changed By:"},null,null,{"$f":"IF(N31=0,0,(N32-H22))","v":0}]
[null,"  *Tax rates are expressed in mills."]
[null,{"$f":"inputBudSum!B4","v":"Patricia Stockham"}]
[null,{"$f":"inputBudSum!B6","v":"Garden City Township Treasurer"}]
[]
[null,null,"Page No.",8]

{"sheet":"nhood","index":21,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[[24,1,24,2],[2,1,2,4],[18,0,18,2],[20,1,20,2],[22,0,22,2]]}
[{"$f":"inputPrYr!D2","v":"Garden City Township"},null,null,null,null,{"$f":"inputPrYr!D5","v":2013}]
[]
[null,{"$f":"CONCATENATE(\"\",F1,\" Neighborhood Revitalization Rebate\")","v":"2013 Neighborhood Revitalization Rebate"}]
[]
[null,{"$f":"CONCATENATE(\"Budgeted Funds                            for \",F1,\"\")","v":"Budgeted Funds                            for 2013"},{"$f":"CONCATENATE(\"\",F1-1,\" Ad Valorem before Rebate**\")","v":"2012 Ad Valorem before Rebate**"},{"$f":"CONCATENATE(\"\",F1-1,\" Mil Rate before Rebate\")","v":"2012 Mil Rate before Rebate"},{"$f":"CONCATENATE(\"Estimate \",F1,\" NR Rebate\")","v":"Estimate 2013 NR Rebate"}]
[null,{"$f":"inputPrYr!B16","v":"General"},null,{"$f":"IF(C6>0,C6/$D$21,\"\")","v":""},{"$f":"IF(C6>0,ROUND(D6*$D$25,0),\"\")","v":""}]
[null,{"$f":"inputPrYr!B17","v":"Debt Service"},null,"",""]
[null,{"$f":"inputPrYr!B18","v":"Library"},null,{"$f":"IF(C8>0,C8/$D$21,\"\")","v":""},{"$f":"IF(C8>0,ROUND(D8*$D$25,0),\"\")","v":""}]
[null,{"$f":"inputPrYr!B19","v":"Road"},null,"",""]
[null,{"$f":"inputPrYr!B20","v":"Fire"},null,"",""]
[null,{"$f":"inputPrYr!B21","v":0},null,"",""]
[null,{"$f":"inputPrYr!B22","v":0},null,"",""]
[null,{"$f":"inputPrYr!B23","v":0},null,"",""]
[null,{"$f":"inputPrYr!B24","v":0},null,"",""]
[null,{"$f":"inputPrYr!B25","v":0},null,"",""]
[null,"TOTAL",{"$f":"SUM(C6:C15)","v":0},{"$f":"SUM(D6:D15)","v":0},{"$f":"SUM(E6:E15)","v":0}]
[]
[]
[{"$f":"CONCATENATE(\"\",F1-1,\" July 1 Valuation:\")","v":"2012 July 1 Valuation:"},null,null,{"$f":"inputOth!E7","v":83550962}]
[]
[null,"Valuation Factor:",null,{"$f":"IF(D19>0,(D19*0.001),\"\")","v":83550.962}]
[]
["Neighborhood Revitalization Subj to Rebate:",null,null,{"$f":"inputOth!E13","v":0}]
[]
[null,"Neighborhood Revitalization factor:",null,{"$f":"IF(D23>0,(D23*0.001),\"\")","v":""}]
[]
[]
[]
[{"$f":"CONCATENATE(\"**This information comes from the \",F1,\" Budget Summary page.  See instructions tab #12 for completing\")","v":"**This information comes from the 2013 Budget Summary page.  See instructions tab #12 for completing"}]
["the Neighborhood Revitalization Rebate table."]
[]
[]
[]
[]
[]
[]
[]
[null,"Page No."]

{"sheet":"Resolution","index":22,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[[1,0,1,6],[2,0,2,6],[4,0,5,6],[27,3,27,6],[25,3,25,6],[15,0,16,6],[18,0,20,6],[23,3,23,6],[24,3,24,6],[21,0,22,6],[28,3,28,6],[30,3,30,6],[31,3,31,6],[13,0,14,6],[8,0,9,6],[10,0,12,6]]}
["Published in the Garden City Telegram July 14, 2012"]
["TOWNSHIP RESOLUTION"]
["RESOLUTION NO.1-2012"]
[{"$f":"CONCATENATE(\"A resolution expressing the property taxation policy of the Board of \",(inputPrYr!D2),\" \")","v":"A resolution expressing the property taxation policy of the Board of Garden City Township "},null,null,null,null,null,null,null,{"$f":"CONCATENATE(I5)","v":""}]
[{"$f":"CONCATENATE(\"   with respect to financing the \",inputPrYr!D5,\" annual budget for \",(inputPrYr!D2),\" , \",(inputPrYr!D3),\" , Kansas.\")","v":"   with respect to financing the 2013 annual budget for Garden City Township , Finney County , Kansas."}]
[]
["Whereas, K.S.A. 79-2925b provides that a resolution be adopted if property taxes levied"]
[{"$f":"CONCATENATE(\"to finance the \",inputPrYr!D5,\" \",(inputPrYr!D2),\" budget exceed the amount levied to finance the \",inputPrYr!D5-1,\"\")","v":"to finance the 2013 Garden City Township budget exceed the amount levied to finance the 2012"}]
[{"$f":"CONCATENATE((inputPrYr!D2),\" Township budget, except with regard to revenue produced and attributable to the taxation of 1) new improvements to real property; 2) increased personal property valuation, other than increased\")","v":"Garden City Township Township budget, except with regard to revenue produced and attributable to the taxation of 1) new improvements to real property; 2) increased personal property valuation, other than increased"}]
[]
["valuation of oil and gas leaseholds and mobile homes; and 3) property which has changed in use during the past year, or with regard to revenue produced for the purpose of repaying the principal of and interest upon bonded indebtedness, temporary notes, or no-fund warrants; and"]
[]
[]
["Whereas, budgeting, taxing and service level decisions for all township services are the responsibility of the township board; and"]
[]
[{"$f":"CONCATENATE(\"Whereas, \",(inputPrYr!D2),\" provides essential services to protect the safety and well being of the citizens of the township; and\")","v":"Whereas, Garden City Township provides essential services to protect the safety and well being of the citizens of the township; and"}]
[]
["Whereas, the cost of provision of these services continues to increase."]
[{"$f":"CONCATENATE(\"NOW, THEREFORE, BE IT RESOLVED by the Board of \",(inputPrYr!D2),\" of \",(inputPrYr!D3),\", Kansas that is our desire to notify the public of increased property taxes to finance the \",inputPrYr!D5,\" \",(inputPrYr!D2),\"  budget as defined above.\")","v":"NOW, THEREFORE, BE IT RESOLVED by the Board of Garden City Township of Finney County, Kansas that is our desire to notify the public of increased property taxes to finance the 2013 Garden City Township  budget as defined above."}]
[]
[]
[{"$f":"CONCATENATE(\"Adopted this 25th day of July, \",inputPrYr!D5-1,\" by the \",(inputPrYr!D2),\" Board, \",(inputPrYr!D3),\", Kansas.\")","v":"Adopted this 25th day of July, 2012 by the Garden City Township Board, Finney County, Kansas."}]
[]
[null,null,null,{"$f":"CONCATENATE((inputPrYr!D2),\" Board\")","v":"Garden City Township Board"}]
[null,null,null,"___________________________________"]
[null,null,null,"Treasurer"]
[]
[null,null,null,"___________________________________"]
[null,null,null,"Trustee"]
[]
[null,null,null,"____________________________"]
[null,null,null,"Clerk"]
[]
[]
[]
[null,null,"Page No.",9]

{"sheet":"Tab A","index":23,"n_rows":85,"n_cols":1,"rows_kept":85,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Possible Budget Law Violation"]
[]
["Welcome.  You have been directed to this tab because your "]
[{"$f":"CONCATENATE(inputPrYr!D5-2,\" 'total expenditures' exceed your \",inputPrYr!D5-2,\" 'budget authority.'\")","v":"2011 'total expenditures' exceed your 2011 'budget authority.'"}]
[]
["In short, you are looking at a potential budget law violation."]
["However, the good news is that you may have options available"]
["that will allow you to avoid a budget law violation."]
[]
[]
["Can the potential violation be corrected at this time?"]
[]
["If the municipality financial records have not been closed"]
[{"$f":"CONCATENATE(\"(i.e. an audit has not been completed, or the \",inputPrYr!D5,\" adopted\")","v":"(i.e. an audit has not been completed, or the 2013 adopted"}]
["budget has not been submitted to the county clerk) then the "]
["budget law violation can be fixed before submission of the "]
["budget to the county clerk."]
[]
["What should I do?"]
[]
["First, review the input page information (inputPrYr tab) "]
["to ensure that the correct amount was entered for this"]
[{"$f":"CONCATENATE(\"particular fund.  If your \",inputPrYr!D5-2,\" budget was amended, did you\")","v":"particular fund.  If your 2011 budget was amended, did you"}]
["use the amended, higher budget amount?"]
[]
[{"$f":"CONCATENATE(\"Next, look to see if any of your \",inputPrYr!D5-2,\" expenditures can be\")","v":"Next, look to see if any of your 2011 expenditures can be"}]
["reduced or eliminated.  For example, are you showing any "]
["transfers from this fund to another?  If so, consider whether"]
["you can reduce or eliminate one or more transfers."]
[]
[{"$f":"CONCATENATE(\"Additionally, do your \",inputPrYr!D5-2,\" receipts contain a reimbursement\")","v":"Additionally, do your 2011 receipts contain a reimbursement"}]
["(e.g. FEMA)?  If so, instead of showing the reimbursement as a"]
["receipt, show the reimbursement as a negative expenditure."]
[]
["Another option is to consider whether your fund shares"]
["expenditures with another fund.  For example, your road"]
["and noxious weed funds may split salaries between the two funds.  If"]
["one of those funds is in trouble, you might be able to allocate"]
["a little more in salaries to the healthy fund in order to"]
["eliminate the violation (be sure, though, that the"]
["healthy fund has sufficient budget authority and cash"]
["available)."]
[]
["The shifting of expenditures between funds, as described in"]
["the preceding paragraph, can be accomplished between any funds"]
["that share expenses."]
[]
["Finally, if your general fund is healthy - it has enough budget"]
["authority and cash - then it might be used to cover the excess"]
["expenditures. (AGO No. 85-181)"]
[]
["Is amending the budget an option?"]
[]
["Amending the budget is a timing issue.  In order to amend the "]
["budget, you must have the complete amending process completed"]
["before the end of the calandar year.  If you start at the "]
["beginning of December, then you should have enough time to "]
["amend the budget.  But, if started during the middle of "]
["December, then you might not have enough time to complete"]
["the amending process.  Remember the complete processing must "]
["be completed on or before the end of December and you must have "]
["at least 10 days between when published in local newspaper and "]
["when the budget hearing is held. So, if your local newspaper only "]
["publishes once a week or bi-weekly, then there might not be "]
["time enough to have the 10 day requirement between publication "]
["and the hearing."]
[]
["Amending the budget can be done at any time during the budgeted"]
["year.  But, amending the budget should take place before the "]
["expenditures exceed the budget authority."]
[]
[{"$f":"CONCATENATE(\"What if the \",inputPrYr!D5-2,\" financial records have been closed?\")","v":"What if the 2011 financial records have been closed?"}]
[]
["Well, if the municipality financial records have been closed "]
[{"$f":"CONCATENATE(\"(i.e. an audit for \",inputPrYr!D5-2,\" has been completed, or the \",inputPrYr!D5)","v":"(i.e. an audit for 2011 has been completed, or the 2013"}]
["adopted budget has been submitted to the county clerk), then"]
["the violation cannot be fixed and must be shown as it occurred. "]
[]
["No punitive action will be taken as a result of the "]
["violation, but you should determine what caused the violation"]
["and take steps to avoid future violations of this nature."]
[]
["Thank you."]

{"sheet":"Tab B","index":24,"n_rows":79,"n_cols":1,"rows_kept":79,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Possible Cash Basis Law Violation"]
[]
["Welcome.  You have been directed to this tab because your"]
[{"$f":"CONCATENATE(inputPrYr!D5-2,\" expenditures show that you finished the year with a \")","v":"2011 expenditures show that you finished the year with a "}]
["negative unencumbered cash balance in this fund."]
[]
["However, the good news is that you may have one or more "]
["options available that will allow you to avoid a cash basis"]
["law violation."]
[]
["Is this a violation?  "]
[]
["Hopefully not.  The first thing that you might do is"]
["to review K.S.A. 10-1116 to see if your fund might be one of"]
["those for which a negative cash balance is permitted. "]
[]
["What if K.S.A. 10-1116 applies?"]
[]
["If the fund falls into one of the categories, then a cash  "]
["basis law violation has not occurred. Please annotate to the"]
["left of the 'See Tab B' as follows:  \"10-1116 applies.\""]
[]
["What if K.S.A. 10-1116 does not apply?"]
[]
["If the fund does not fall into one of the categories, then "]
["let's explore your options, below, to see if we can help you "]
["avoid a cash basis law violation."]
[]
["Options"]
[]
[{"$f":"CONCATENATE(\"If your financial records for \",inputPrYr!D5-2,\" are not closed\")","v":"If your financial records for 2011 are not closed"}]
[{"$f":"CONCATENATE(\"(i.e. an audit has not been completed, or the \",inputPrYr!D5,\" adopted \")","v":"(i.e. an audit has not been completed, or the 2013 adopted "}]
["budget has not been submitted to the county clerk) then "]
["either your fund receipts will need to be increased "]
["(transfer from another fund) or your expenditures will"]
["need to be decreased (shifting of expenditures to another"]
["fund), or a combination of the two."]
[]
["Increasing your receipts through one or more transfers"]
["is contingent upon the available cash, budget authority,"]
["and statutory authority for the transfer from the fund or"]
["funds from which one or more transfers might be made."]
[]
["Another option for you to consider is the shifting of "]
["expenditures from this fund to another fund.  Again, the "]
["fund to which expenditures are shifted must have available"]
["cash and budget authority in order to absorb the additional"]
["expenditures.  "]
[]
["What if K.S.A. 10-1116 does not apply, and no options"]
["are available to me?"]
[]
["Unfortunately, under this scenario you are pretty much stuck "]
["with a cash basis law violation.  However, you can accept"]
["the violation as a learning tool to help you prevent violations"]
["in the future."]
[]
["Regular reviews of current year budget performance, especially"]
["from the end of the third quarter on, might allow you to determine"]
["in a timely fashion whether an increase in revenue or a decrease"]
["in expenditures is going to be needed before the end of the fiscal"]
["year in order to ensure that a fund finishes the year in good"]
["shape."]
[]
["In addition to the options discussed above, during the later"]
["part of the year if a utility fund or the general fund has"]
["the cash, but not the budget authority, amending the budget"]
["might be done in order to increase budget authority so that "]
["a transfer can then be made to the struggling fund or, in"]
["the case of the general fund, there can be a shifting of"]
["expenditures from the struggling fund to the general fund."]
[]
["If, in the future, you choose to amend the budget as described"]
["in the paragraph above, please remember that the amendment"]
["must occur before the end of the fiscal year."]
[]
["Thank you."]

{"sheet":"Tab C","index":25,"n_rows":75,"n_cols":1,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Current Year - Possible Budget Law Violation"]
[]
["Welcome.  You have been directed to this tab because your "]
[{"$f":"CONCATENATE(\"estimated \",inputPrYr!D5-1,\" 'total expenditures' exceed your \",inputPrYr!D5-1,\"\")","v":"estimated 2012 'total expenditures' exceed your 2012"}]
["budget authority.'"]
[]
["In short, you are looking at a potential budget law violation"]
["if you truly end up the year as your current estimates"]
["reflect.  The good news is that you have an early "]
["indication of possible issues which can be addressed"]
["sooner rather than later."]
[]
["Should the potential for a violation be corrected at "]
["this time? "]
[]
["Naturally, our preference would be that you consider "]
[{"$f":"CONCATENATE(\"your \",inputPrYr!D5-1,\" numbers to see what steps might be necessary to\")","v":"your 2012 numbers to see what steps might be necessary to"}]
["ensure that your expenditures do not, at year-end, exceed your"]
["budget authority for this fund."]
[]
["What should I do at this time?"]
[]
["Well, the easiest thing to do at this time is to increase"]
["any underestimated revenue numbers, or decrease"]
["any overestimated expenditure numbers, or a combination"]
["of the two."]
[]
["What if I check my estimates and find that we're still"]
["on pace for a budget law violation?"]
[]
[{"$f":"CONCATENATE(\"Well, let's look to see if any of your \",inputPrYr!D5-1,\" expenditures can\")","v":"Well, let's look to see if any of your 2012 expenditures can"}]
["be reduced or eliminated.  For example, are you showing any "]
["transfers from this fund to another?  If so, consider whether"]
["you can reduce or eliminate one or more transfers."]
[]
[{"$f":"CONCATENATE(\"Additionally, do your \",inputPrYr!D5-1,\" receipts contain a reimbursement\")","v":"Additionally, do your 2012 receipts contain a reimbursement"}]
["(e.g. FEMA)?  If so, instead of showing the reimbursement as a"]
["receipt, show the reimbursement as a negative expenditure."]
[]
["Another option is to consider whether your fund shares"]
["expenditures with another fund.  For example, your road"]
["and noxious weed funds may split salaries between the two funds.  If"]
["one of those funds is in trouble you might be able to allocate"]
["a little more in salaries to the healthy fund in order to"]
["eliminate the potential violation (be sure, though, that"]
["the healthy fund has sufficient budget authority and cash"]
["available)."]
[]
["The shifting of expenditures between funds, as described in"]
["the preceding paragraph, can be accomplished between any funds"]
["that share expenses."]
[]
["A sometimes overlooked option is to use your general"]
["fund to cover the excess expenditures, assuming that the"]
["general fund is not the one that's in trouble and that it"]
["has the budget authority and cash to absorb additional"]
["expenditures."]
[]
["Finally, If none of the above options can be applied and the"]
["fund has an unencumbered cash balance which will cover"]
["the estimated overage, the budget can be amended before"]
["the end of the fiscal year.  Remember, though, that"]
["the amendment process must occur before the end of the "]
["fiscal year."]
[]
["If the fund does not have enough ending cash so that an"]
["amendment will cover the expected overage, but another fund"]
["does have enough unemcumbered cash (along with budget"]
["authority and statutory authority to transfer to the "]
["fund with the potential budget law violation), go ahead"]
["and make the transfer and then amend the budget."]
[]
["Thank you."]

{"sheet":"Tab D","index":26,"n_rows":72,"n_cols":1,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Current Year - Possible Cash Basis Law Violation"]
[]
["Welcome.  You have been directed to this tab because your"]
[{"$f":"CONCATENATE(inputPrYr!D5,\" estimated expenditures show that at the end of this year\")","v":"2013 estimated expenditures show that at the end of this year"}]
["you will have a negative unencumbered cash balance in this"]
["fund."]
[]
["However, the good news is that you may have one or more "]
["options available that will allow you to avoid a cash basis"]
["law violation."]
[]
["Should this be fixed?"]
[]
["Yes, by all means.  You really don't want to end this year"]
["with a negative cash balance in the fund.  At a minimum"]
["you will want your ending cash balance to be $0."]
[]
["Now, it is possible that this is one of those funds which"]
["may, under K.S.A. 10-1116, end the year with a negative cash"]
["balance, but otherwise you will want to make sure that it"]
["does not."]
[]
["What should I do at this time?"]
[]
["Well, the easiest thing to do at this time is to increase"]
["any underestimated revenue numbers, or decrease"]
["any overestimated expenditure numbers, or a combination"]
["of the two."]
[]
["What if I check my estimates and find that we're still"]
["on pace for a budget law violation?"]
[]
["Either your fund receipts will need to be increased before "]
["the end of the year (transfer from another fund) or your"]
["expenditures will need to be decreased before the end of the"]
["year (shifting of expenditures to another fund), or a"]
["combination of the two."]
[]
[{"$f":"CONCATENATE(\"So, let's look to see if any of your \",inputPrYr!D5-1,\" expenditures can\")","v":"So, let's look to see if any of your 2012 expenditures can"}]
["be reduced or eliminated.  For example, are you showing any "]
["transfers from this fund to another?  If so, consider whether"]
["you can reduce or eliminate one or more transfers."]
[]
[{"$f":"CONCATENATE(\"Additionally, do your \",inputPrYr!D5-1,\" receipts contain a reimbursement\")","v":"Additionally, do your 2012 receipts contain a reimbursement"}]
["(e.g. FEMA)?  If so, instead of showing the reimbursement as a"]
["receipt, show the reimbursement as a negative expenditure."]
[]
["Another option for you to consider is the shifting of "]
["expenditures from this fund to another fund.  Again, the "]
["fund to which expenditures are shifted must have available"]
["cash and budget authority in order to absorb the additional"]
["expenditures.  "]
[]
["The shifting of expenditures between funds, as described in"]
["the preceding paragraph, can be accomplished between any funds"]
["that share expenses."]
[]
["On the revenue side of the fund you might increase your "]
["receipts through one or more transfers, contingent upon"]
["available cash, budget authority, and statutory authority for "]
["the transfer from the fund or funds from which one or"]
["more transfers might be made."]
[]
["A sometimes overlooked option is to use your general"]
["fund to cover the excess expenditures, assuming that the"]
["general fund is not the one that's in trouble and that it"]
["has the budget authority and cash to absorb additional"]
["expenditures."]
[]
["Thank you."]

{"sheet":"Tab E","index":27,"n_rows":52,"n_cols":1,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Proposed Budget Year - Possible Budget Law Violation"]
["No Levy Funds"]
[]
[]
["Welcome.  You have been directed to this tab because your "]
[{"$f":"CONCATENATE(\"estimated \",inputPrYr!D5,\" 'total expenditures' exceed your \",inputPrYr!D5,\"\")","v":"estimated 2013 'total expenditures' exceed your 2013"}]
["Unemcumbered cash balance Dec 31.'"]
[]
["In short, you are looking at a budget law violation if you"]
["adopt a budget in which there exists a fund with a negative"]
["ending cash balance."]
[]
["Should this be fixed before we adopt the budget?"]
[]
["Yes.  The budget law mandates that fund expenditures "]
["shall balance with anticipated revenue.  A fund ending"]
["cash balance should end either in $0 or a positive cash"]
["balance."]
[]
["How do I fix the violation?"]
[]
["The negative cash balance can be remedied by increasing "]
["the anticipated receipts or by reducing the proposed "]
["expenditures, or a combination of the two."]
[]
["Is there a benefit to having a positive cash balance?"]
[]
["If the municipality governing body chooses to adopt a "]
["budget whereby the no levy fund has a positive ending "]
["balance, that's okay.  But, we recommend that the fund"]
["be budgeted to end with a $0 balance."]
[]
["Why?  Well, remember that no levy funds do not result in a"]
["levy of property tax dollars.  So, there is no impact to the"]
["property taxpayer from a budget which utilizes all anticipated"]
["revenue in the upcoming year."]
[]
["The advantage to the municipality of budgeting the no levy fund"]
["to end the budget year with a $0 balance is that it provides"]
["the municipality with maximum spending authority.  In"]
["the event the municipality is faced with unanticipated"]
["spending during the budget year it will not need to amend"]
["its budget to do so."]
[]
["Of course, by budgeting to $0 the municipality does not have"]
["to spend down to $0, but the authority to do so "]
["without a budget amendment is there in the event that a need"]
["to do so should arise."]
[]
["Thank you."]

{"sheet":"Mill Rate Computation","index":28,"n_rows":148,"n_cols":10,"rows_kept":148,"cut":false,"hidden":false,"merged":[[147,2,147,3],[147,9,147,10],[127,1,127,10],[129,1,129,10],[132,2,132,3],[132,7,132,8],[133,2,133,3],[133,7,133,8],[135,2,135,3],[136,2,136,3],[143,1,143,10],[146,2,146,3],[146,9,146,10],[125,1,125,10],[99,2,99,3],[102,2,102,3],[104,1,104,10],[105,1,105,10],[107,1,107,10],[109,1,109,10],[113,2,113,3],[116,2,116,3],[119,2,119,3],[122,2,122,3],[124,1,124,10],[96,2,96,3],[56,1,56,10],[57,1,57,10],[73,2,73,3],[76,2,76,3],[79,2,79,3],[82,2,82,3],[84,1,84,10],[85,1,85,10],[87,1,87,10],[89,1,89,10],[93,2,93,3],[54,1,54,10],[24,2,24,3],[29,1,29,10],[30,1,30,10],[32,1,32,10],[34,1,34,10],[40,2,40,3],[47,1,47,2],[49,6,49,7],[50,8,50,10],[51,1,51,10],[52,1,52,10],[22,5,22,6],[5,1,5,10],[6,1,6,10],[7,1,7,10],[9,1,9,10],[11,1,11,10]]}
[]
[]
[]
[]
[]
[null,"How To Compute The Value of One Mill, And The Impact Of Tax Dollars And Assessed Valuation On Mill Rates"]
[null,"* * * * *"]
[null,"To Compute the Value of One Mill"]
[]
[null,"Example #1 and Formula"]
[]
[null,"This example allows you to compute a mill rate.  Simply input in the green area the total assessed valuation for your municipality."]
[]
[null,"Formula:"]
[]
[null,"Assessed valuation = X"]
[null,"X / 1000 = value of one mill"]
[]
[null,"Computation of Example:  $312,000,000 (assessed valuation) / 1000 = $312,000 (value of one mill)"]
[]
[null,"In this example, one mill for the municipality will generate $312,000 in taxes."]
[]
[null,"Input the assessed valuation:",null,null,"=",312000000]
[]
[null,null,{"$f":"F23","v":312000000},null,"/",1000,"=",{"$f":"F23/F25","v":312000}]
[]
[null,"Formula:"]
[null,{"$f":"F23","v":312000000},"(assessed valuation)",null,"/",1000,"=",{"$f":"B28/F28","v":312000},"(value of one mill)"]
[]
[null,"* * * * *"]
[null,"To Determine a Mill Rate Increase"]
[]
[null,"Example #2 and Formula"]
[]
[null,"Example #2 allows you to compute the impact on mill rate by a specific dollar amount of property tax.  This example might be useful at a budget hearing when the governing body is making small adjustments to one or more property tax funds and would like to know the impact of those changes on the total mill rate.  As with the first example, input the municipality's total assessed valuation in the first green box, and with the second green box input the amount of property tax dollars under consideration."]
[]
[null,"Computation of Example:"]
[]
[null,"The first step is to determine the value of one mill:"]
[]
[null,null,312000000,null,"/",1000,"=",{"$f":"C41/F41","v":312000}]
[]
[null,"In the next step, we will determine the increase:"]
[]
[null,"$50,000 (increased property tax) / $312,000 (mill value) = .160 increase to the mill rate "]
[]
[null,"Formula:"]
[null,312000000,null,"(asd. val.)","/",1000,"=",{"$f":"B48/F48","v":312000},"(value one mill)"]
[]
[null,50000,"(property tax)",null,"/",{"$f":"H48","v":312000},"(mill value) ",null,"=",{"$f":"B50/F50","v":0.16025641025641027}]
[null,null,null,null,null,null,null,null,"(mill rate increase)"]
[null,"* * * * *"]
[null,"Impact of a Property Tax Increase on a $100,000 Home"]
[]
[null,"Example #3a and Formula"]
[]
[null,"Example #3a allows you to quickly compute the standard \"impact of a property tax increase on a $100,000 home\" (or any other residential property value, for that matter).   Using the same information as in example #2, the additional piece of information to input in this example is a residential property value.  Additionally, residential property is assessed at 11.5% of its value (K.S.A. 79-1439(b)(1)(A))."]
[]
[null,"Computation of Example:"]
[]
[null,"The first step is to determine the mill rate:"]
[null,"$312,000,000 / 1000 = $312,000 (example #1)"]
[null,"$50,000 / $312,000 = .160 mills (example #2)"]
[]
[null,"The second step is to determine the residential property assessed value:"]
[null,"$100,000 home x .115 = $11,500 (assessed value)"]
[]
[null,"The last step is to determine the property tax increase:"]
[null,"$11,500 (assessed value) x .160 (mill rate) / 1000 = $1.84"]
[null,"The increase in property tax for a $100,000 home will be $1.84"]
[]
[null,"Formula:"]
[null,null,"(assessed valuation)"]
[null,"First Step:",312000000,null,"/",1000,"=",{"$f":"C74/F74","v":312000},"(value of 1 mill)"]
[]
[null,null,"(increased prop. tax)",null,null,"(value of 1 mill)"]
[null,"Second Step:",50000,null,"/",{"$f":"H74","v":312000},"=",{"$f":"C77/F77","v":0.16025641025641027},"(increase mill rate)"]
[]
[null,null,"(value of the home) "]
[null,"Third Step:",100000,null,"x",0.115,"=",{"$f":"C80*F80","v":11500},"(assessed value)"]
[]
[null,null,"(assessed value) ",null,null,"(increase mill rate)",null,null,null,"(increase tax)"]
[null,"Result:",{"$f":"H80","v":11500},null,"x",{"$f":"H77","v":0.16025641025641027},"/",1000,"=",{"$f":"C83*F83/H83","v":1.8429487179487181}]
[]
[null,"* * * * *"]
[null,"Impact of a Property Tax Increase on Unimproved Ag Land"]
[]
[null,"Example #3b and Formula"]
[]
[null,"Example #3b uses the same computation as example #3a, except in this case we are computing the impact of property taxes on unimproved agricultural land.  Unimproved agricultural land is assessed at 30% pursuant to K.S.A. 79-1439(b)(1)(B))."]
[]
[null,"Formula:"]
[null,null,"(assessed valuation)"]
[null,"First Step:",312000000,null,"/",1000,"=",{"$f":"C94/F94","v":312000},"(value of 1 mill)"]
[]
[null,null,"(increased prop. tax)",null,null,"(value of 1 mill)"]
[null,"Second Step:",50000,null,"/",{"$f":"H94","v":312000},"=",{"$f":"C97/F97","v":0.16025641025641027},"(increase mill rate)"]
[]
[null,null,"(value of the property) "]
[null,"Third Step:",2500000,null,"x",0.3,"=",{"$f":"C100*F100","v":750000},"(assessed value)"]
[]
[null,null,"(assessed value) ",null,null,"(increase mill rate)",null,null,null,"(increase tax)"]
[null,"Result:",{"$f":"H100","v":750000},null,"x",{"$f":"H97","v":0.16025641025641027},"/",1000,"=",{"$f":"C103*F103/H103","v":120.19230769230771}]
[]
[null,"* * * * *"]
[null,"Impact of a Property Tax Increase on Commercial, Industrial, Railroad, and Improved Ag Land"]
[]
[null,"Example #3c and Formula"]
[]
[null,"Example #3c uses the same computation as examples #3a and #3b, except in this case we are computing the impact of property taxes on commercial, industrial, railroad, and improved agricultural land.  The foregoing categories of land are assessed at 25% pursuant to K.S.A. 79-1439(b)(1)(F))."]
[]
[null,"Formula:"]
[null,null,"(assessed valuation)"]
[null,"First Step:",312000000,null,"/",1000,"=",{"$f":"C114/F114","v":312000},"(value of 1 mill)"]
[]
[null,null,"(increased prop. tax)",null,null,"(value of 1 mill)"]
[null,"Second Step:",50000,null,"/",{"$f":"H114","v":312000},"=",{"$f":"C117/F117","v":0.16025641025641027},"(increase mill rate)"]
[]
[null,null,"(value of the property) "]
[null,"Third Step:",2500000,null,"x",0.25,"=",{"$f":"C120*F120","v":625000},"(assessed value)"]
[]
[null,null,"(assessed value) ",null,null,"(increase mill rate)",null,null,null,"(increase tax)"]
[null,"Result:",{"$f":"H120","v":625000},null,"x",{"$f":"H117","v":0.16025641025641027},"/",1000,"=",{"$f":"C123*F123/H123","v":100.16025641025642}]
[]
[null,"* * * * *"]
[null,"Impact of Total Mills on an Individual Home"]
[]
[null,"Example #4 and Formula"]
[]
[null,"To compute the impact of all mills to be levied against a specific home valuation, simply key in the \"value of the home\" green area with the home valuation, and the total mill rate in the \"total mill rate\" green area (number at bottom of 'Estimate Tax Rate' column on the budget summary page).  Remember, a computation using the above described information does not take into account taxes that may be levied by other municipalities.  "]
[]
[null,"Formula:"]
[null,null,"(value of the home)",null,null,"(residential %)",null,"(assessed value)"]
[null,"First Step:",100000,null,"x",0.115,"=",{"$f":"C134*F134","v":11500}]
[]
[null,null,"(assessed value)",null,null,"(total mill rate)",null,null,null,"(impact, total mills)"]
[null,"Second Step:",{"$f":"H134","v":11500},null,"x",52.869,"/",1000,"=",{"$f":"C137*F137/H137","v":607.99350000000004}]
[]
[null,"* * * * *"]
[null,"How to Achieve the Same Mill Rate as the Year Before"]
[]
[null,"Example #5 and Formula"]
[]
[null,"Maybe your governing body wants the budget to have the same mill rate as the year before.  This is not an unusual goal of municipality governing bodies.  To do so simply key in the desired mill rate in the first green box, the preliminary total assessed valuation in the second green box, and hit \"enter.\"  The result will be the amount in dollars that you must levy (total of all tax levy funds) in your proposed budget."]
[]
[null,"Formula:"]
[null,null,"(desired mill rate)",null,null,"(total assd. valuation)",null,null,null,"(total taxes levied)"]
[null,null,52.869,null,"x",312000000,"/",1000,"=",{"$f":"C148*(F148/1000)","v":16495128}]

{"sheet":"Helpful Links","index":29,"n_rows":40,"n_cols":1,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["Helpful Links"]
[]
["Municipal Services (Kansas Department of Administration, Accounts and Reports) – Budget forms, confirmation of payments, transfer statutes, non-budgeted fund statutes, etc."]
["http://www.da.ks.gov/ar/muniserv/"]
[]
[]
["State Debt Setoff Program (Kansas Department of Administration, Accounts and Reports) – Passive collection tool to assist municipalities with collection of unpaid utility bills, etc."]
["http://www.da.ks.gov/ar/setoff/"]
[]
[]
["League of Kansas Municipalities – City-County Highway Fund estimates"]
["http://www.lkm.org/resources/budgettips/"]
[]
[]
["League of Kansas Municipalities – Directory of Kansas Public Officials"]
["http://www.lkm.org/publications/dokpopop.html"]
[]
[]
["Kansas Legislature – Kansas Statutes (usually updated in January), House and Senate Bills, etc."]
["http://www.kslegislature.org/legsrv-statutes/index.do"]
[]
[]
["Kansas Attorney General Opinions"]
["http://ksag.washburnlaw.edu/"]
[]
[]
["Kansas State Treasurer – Municipal Distributions"]
["http://www.kansasstatetreasurer.com/prodweb/dist/index.php"]
[]
[]
["Kansas Department of Revenue"]
["http://www.ksrevenue.org/"]
[]
[]
["Kansas Department of Revenue – Property Valuation"]
["http://www.ksrevenue.org/pvd.htm"]
[]
[]
["Kansas Pooled Money Investment Board – Investment of Idle Funds in the Municipal Investment Pool"]
["https://www.pooledmoneyinvestmentboard.com/"]

{"sheet":"legend","index":30,"n_rows":187,"n_cols":1,"rows_kept":187,"cut":false,"hidden":false,"merged":[]}
["The following were changed to this spreadsheet on 2/2/12"]
["1. Instruction tab - line A7 add Library "]
["2. Instruction tab - add line #1c for ad valorem adjustments"]
["3. Instruction tab - add line #3b to indicate latest date for printing"]
["4. Instruction tab - add line #10 to explain about Library Grant Tab"]
["5. Instruction tab - add line #11a concerning changing the general fund page number due to library grant page"]
["6. Instruction tab - changed 11b, c, and d for new fund tables on fund pages, and 13b, c, and d for tables on Summary"]
["7. InputPrYr tab - add Library to the fund page list"]
["8. InputPrYr tab - added new table for adjusting ad valorem taxes if desired"]
["9. InputOth tab - under 'Computation of Delinquency', changed both narratives for %"]
["10. InputBudSum tab - added line D9 for latest date for printing and added hidden formulas for latest printing date"]
["11. InputBudSum tab - added spaces for official name and title "]
["12. Cert tab - added to 'Table of Contents' the Computation to Determine Library Grant and its page number"]
["13. Cert tab - added Library fund"]
["14. Cert tab - added place for \"Email\" address for person assitance on the budget"]
["15. Mvalloc tab - removed 'Slider' from table heading"]
["16. Mvalloc tab - removed slider column and under lying formulas"]
["17. Mvalloc tab - added Library fund"]
["18. TransfersStatutes tab - added KSA 80-1406c"]
["19. Debt-Lease tab - minor changes to first column heading and center form for printing"]
["20. Library Grant was added which computes if library qualifies for a grant"]
["21. Gen tab - added an if statement to page number to account for Library Grant page"]
["22. DebtSvs-Library tab - reduce debt service fund page and added new library fund page which is linked to Grant tab"]
["23. Summ tab - added library fund  and  linked the library fund page to the summary"]
["24. Summ tab - linked the official name and title from the inputbudsum page"]
["25. Summ tab - centered the heading for printing"]
["26. Nhood tab - added the library fund"]
["27. Mill Rate Computation tab - corrected the computations to agree with our web site"]
["28. All fund pages - changed the year headings"]
["29. All fund pages - removed slider and its link"]
[]
["The following were changed to this spreadsheet on 5/13/11"]
["1. Road tab cell c54 change ref from h1 to e1 so the Special Machinery date will reflect correctly"]
[]
["The following were changed to this spreadsheet on 5/4/11"]
["1. Gen tab cell B46 corrected the spelling of Resources"]
[]
["The following were changed to this spreadsheet on 4/19/11"]
["1. Summ tab changed proposed year expenditure column to 'Budget Authority for Expenditures'"]
[]
["The following were changed to this spreadsheet on 3/21/11"]
["1. General tab corrected cell G52 from E22 to E26"]
["2. Debt Service tab corrected cell G55 from E42 to E29"]
[]
["The following were changed to this spreadsheet on 10/13/10"]
["1. All pages removed the revision date"]
["2. All tax levy fund pages reduced the columns and revised the bottom of pages for see tabs"]
["3. Instruction tab added lines 11c (last year mill rate), 11d (desired mill rate), 10a(project carryover), 10b (Desired Carryover), 10g (project carryover Debt/road, and 14 (protection)"]
["4. Certificate tab change the 'Expenditure' heading by adding  'Budget Authority for Expenditures'"]
["5. Certificate tab add the year in the block for 'County Clerk Use Only'"]
["6. Gen tab added table for 'Projection of Cash Carryover'"]
["7. Gen tab added table for 'Desired Carryover'"]
["8. Gen tab redefine print que to not include tables"]
["9. Gen tab hid the comp for see tabs"]
["10. DebtService tab added table for 'Projected Carryover'"]
["11. DebtService tab redefine print que and hid comp for see tabs"]
["12. Levy page9 and page10 tab hid comp for see tabs"]
["13. Summ tab merged cells above the 'Township Officer' and center a name if used"]
["14. Summ tab changed proposed year expenditure column to 'Budget Authority (Includes Carryover)"]
["15. Summ tab added four tables to the right of the form"]
["16. Revised TransferStatutes and NonBudFunds tabs"]
["17. Added Mill Rate Computation tab"]
["18. Summ tab redefine print que"]
["19. Add Helpful Links tab"]
["20. Certificate page deleted state block"]
["21. Inputoth tab changed Actual Delinquency tax from -2 to -3"]
["22. All tax levy fund pages, changed 'Fund Page' to 'Fund Page for Funds with a Tax Levy'"]
["23. Remove w-2 infro from certificate page"]
[]
["The following were changed to this spreadsheet on 4/15/10"]
["1. Changed schedule of transfers statute column to allow for statute to pop-up if transfers are shown in current/proposed columns"]
[]
["The following were changed to this spreadsheet on 1/05/10"]
["1. Instruction tab added line 7b concerning schedule of transfers adjustments"]
["2. Transfers tab changed note so to identify current and proposed columns for non-budgeted funds transfers"]
["3. Transfers tab changed first two column heading adding 'expenditures' and 'receipts'"]
[]
["The following were changed to this spreadsheet on 12/28/09"]
["1. Nhood tab added note for computing table"]
[]
["The following were changed to this spreadsheet on 12/08/09"]
["1. Instruction tab, added step 3 for 'inputBudSum'"]
["2. Added tab 'inputBudSum'"]
["3. Changed Budget Summary replacing the green areas for date/time/location so info comes from inputBudSum tab"]
["4. Bud Summary delete a space and combine sentences 'Detail…' and 'and will' for where budget infor located at"]
[]
["The following were changed to this spreadsheet on 8/25/09"]
["1. Cert tab line 14, added 'If amended….'"]
["2. Mvalloc tab changed reference from 'D' to 'E'  in each cell of table"]
["3. Transfer tab line 13, changed General/Road to Road/Special Machinery"]
["4. Transfer tab changed second statute reference from 80-1406b to 80-122"]
["5. TransferStatute tab created"]
["6. Instructions tab added 6c for the TransferStatute tab"]
["7. Instruction tab added 9m to explain about Non-Budgeted Form"]
["8. Cert tab added Non-Budgeted Funds line A35"]
["9. Added nonbud tab for the Non-Budgeted Funds"]
["10. Summ tab added A34 for Non-Budgeted Funds"]
["11. Added Tabs A to E for violations"]
["12. Changed each fund page taking out the 'Yes' and 'No' and replacing them with See Tab when a possible violation occurrs"]
["13. NonBud tab changed Net Vaulation to July 1"]
["14. Certificate tab moved the Assisted By: and added more lines for governing body signatures"]
["15. Created NonBudFunds tab"]
[]
["The following were changed to this spreadsheet on 5/14/09"]
["1. Mvalloc tab, changed cell d10  to -2 vs -1 to reflect correct year to tax"]
["2. Mvalloc tab, changed cells d12-21 to add = in formula to prevent VALUE error - affects very few townships "]
[]
["The following were changed to this spreadsheet on 5/13/09"]
["1. Transfer tab, changed cells c12, d12, and e12 to reflect link on the gen tab transfer from 43 to 45"]
[]
["The following were changed to this spreadsheet on 5/5/09"]
["1. Summ tab, the special machinery's expenditure block B34 link was changed from C63 to B63"]
[]
["The following were changed to this spreadsheet on 4/3/09"]
["1. Corrected mvalloc column d for ad valorem tax as was picking up expenditures instead"]
["2. Corrected gen unencumbered cash balances for both actual and current columns"]
[]
["The following were changed to this spreadsheet on 3/19/09"]
["1. Certificat page changed fund name from Bond & Interest to Debt Service"]
["2. Debt Service fund page name from Bond & Interest to Debt Service"]
["3.Budget Summary changed fund name from Bond & Interest to Debt Service"]
[]
["The following were changed to this spreadsheet on 2/23/09"]
["1. Instruction under Submitting of Budget ….required electronic submission."]
["2. Input other tab line 45 change from Budget Summary to Budget Certificate."]
[]
["The following were changed to this spreadsheet on 2/02/09"]
["1. General fund cell c51formula changed to calulate the Unecumber Cash Balance correctly."]
[]
["The following were changed to this spreadsheet on 10/14/2008"]
["1. Input tab (inputPrYr) added column for the current year expenditures."]
["2. Added to all tax levy fund pages the miscellaneous receipt for the proposed year comparison takes into account the ad valorem taxes for the 10% Rule."]
["3. All tax levy funds and no tax levy funds fund pages made the following changes: "]
["3a. Made the total expenditures block for the actual and current year to turn 'Red' if violation occurs."]
["3b. Unencumbered Cash for the actual year turn 'Red' if violation occurs."]
["3c. In statements about violations, if no violation occurs, then a red 'No' will appear."]
["4. All tax levy fund pages abbreviated the non-appropriated, total expenditures/non-appropriated, and delinquency computation rate."]
["5. All no tax levy fund pages added to the proposed column unencumbered cash balance block will turn red and below will say in red 'Budget Violation' if the cash balance is negative."]
["6. Neighborhood Revitalization (nhood) took off the protection for the page number and made the estimate rebate round the figures to whole dollars."]
["7. Instruction page have changed all reference for Bond & Interest to Debt Service. "]
["8. Added to the instruction page lines 11a - 11c to provide a little more insight for the Neighborhood Revitalization rebate."]
["9. Added instruction line 2b to explain how to delete delinquency rate from tax levy fund pages."]
["10. Changed the Bond & Interest tab (B&I) to Debt Service tab (DebtService)."]
["11. Changed the revised date on all pages changed."]
["12. Added instruction lines 9g to 9l for additional edits for budget authority."]
["13. Allow the General Fund transfer of 25% to Special Machinery to include ad valorem taxes into the computation of the 25% limitation in the proposed column."]
["14. If road transfer funds to special machinery, the transfers are linked and to the Schedule of Transfers."]
["14a. Road transfer is checked to see if exceeds 25%, if so, then block turns red and below statement will appear 'Exceeds 25%'. "]
["14b. Special Machinery also has error message 'Exceeds 25% of Resources Available'."]
["14c. Schedule of Transfer has the transfers link and will show statute allowing for the transfer for actual year only."]
["15. Added transfers on the general fund page and questions pertaining to the transfers."]
["15a. The first transfer checks for if ad valorem taxes were levied. If so, then transfer block turns red and error message 'Not Authorized' appears."]
["15b. Second transfer checks to see if exceeds 25% limitation. If so, then transfer block turns red and error message 'Exceeds 25%' appears."]
["15c. Transfers are linked from general fund to special machinery and to Schedule of Transfers. Transfers for actual year will also have the statute reference shown."]
["16. Error messages will appear next to transfers for the special machinery transfers from the general fund if both transfer blocks indicate a transfer. A error message will appear 'Not Authorized Two Transfers - Only One'"]
["17. Deleted lines pertaining to the beginning and ending balance for the County Treasurer."]
[]
["The following were changed to this spreadsheet on 8/06/2007"]
["1. instruction were changed: POC change from Roger to armunis, got rid about us providing disk, took the input page and split to input prior budget information and input other, with more in-depth of forms and fund page, and more in-depth on the budget summary page."]
["2. All pages have a revision date."]
["3. Hard coded the Bond & Interest, and Road on Certificate and Summary pages. "]
["4.  All dates on the spreadsheet are controlled from input on the input Prior Year page. "]
["5. Computation to Determine Limit now has the debts amounts link within the spreadsheet."]
["6. Schedule of Transfers have the transfers totaled and link to the budget summary page."]
["7. Now have the indebtedness prior year added to the input page and link with the budget summary page. "]
["8. Added  LAVTR and Slider to the input page and to the General Fund page."]
["9. Changed the Budget Summary Heading to include Actual/Estimate/Proposed with the budget year."]
["10. Changed the delinquency rate formula for all levy funds."]
["11. Changed the Certificate page so the county name flows instead of having unneeded spaces."]
["12. Using the actual ad valorem rates from the Clerk's information versus from the Certificate page."]
["13. Delinquency rate for actual for 3 decimal and note that rate can be up to 5% over the actual rate."]
["14. Added column to show when debt retired on the Indebtedness page."]
["15. Budget Summary changed the sentence \"will meet…\" so the year automatically changes."]
["16. Resolution page has a space for a page number."]
["17. Added to instructions about non-appropriated funds limit of 5%."]
["18. Added warning \"Exceeds 5%\" on all fund pages for the non-appropriated balance."]
["19. Added Neighborhood Revitalization table and linked the tax levy fund pages."]
["20. Added Neighborhood Revitalization expenditures to all the tax levy fund pages."]
["21. Added Neighborhood Revitalization page number to the Certificate page table of content."]
["22. Added Slider to the Vehicle Allocation table and linked to fund pages."]
["23. Added to all budgeted fund pages the budget authority for the actual year, budget violation, and cash violation."]
["24. Added instruction on the addition for item 23."]
["25. Link the Road fund transfer to Special Machinery fund and check for exceeding 25%."]
["26. Added 'miscellaneous' category to the receipt/expenditure for all fund pages and set error message."]
["27. Added to the instruction about correct the error message for the miscellaneous."]
["28. Added 9a to the instruction to explain about County Treasurers Jan 1 and Dec 31 balances."]
["29. Added 'excluding oil, gas, and mobile homes' to lines 9 and 11 on Clerks budget info on tab inputoth."]

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

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