{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","TIFA Identity","2014 Estimated TIF revenue","TIF small parcel exemption loss","Captured Millages","Tax Increment SmallTaxpayerLoss","Losses by millage"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":4,"comments":2,"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":105,"n_cols":10,"rows_kept":105,"cut":false,"hidden":false,"merged":[[76,3,76,5],[76,6,76,7]]}
["BASIS OF REPORT - PUBLIC ACT 86 OF 2014, MCL 123.1341"]
[]
["This report is mandatory if you are seeking reimbursement of tax increment financing revenue losses stemming from exemptions"]
["claimed by taxpayers pursuant to the \"small taxpayer exemption loss.\""]
[]
["Section 5 (y) \"Small taxpayer exemption loss\" means the 2013 taxable value of commercial personal property and industrial "]
["personal property minus the 2014 taxable value of commercial personal property and industrial personal property."]
[]
["Sec. 16a (1) Not later than June 15, 2014 and June 15, 2015, each municipality that is a tax increment finance authority shall"]
["calculate and report to the department the municipality’s tax increment small taxpayer loss for the current calendar year."]
[]
["Sec 16b (2) If a municipality that is a tax increment finance authority fails to make the calculation and report it to the department by the date "]
["provided in section 16a, the department may extend the calculation and reporting date upon good cause as determined by the department."]
[]
["For 2014, the calculation and reporting date is extended for all authorities to August 29, 2014."]
[]
[]
["GENERAL GUIDELINES"]
[]
["You will need to provide information from multiple sources to complete this form. Reimbursement is based on the lower of 2012 millage"]
["rates and millage rates from the year immediately preceding the claim year. In 2014, that means the lower of 2012 and 2013. Treasury"]
["has compiled the lower of the two rates for every tax levy in the state, and you will have to enter them on the \"Captured Millages\" page."]
["Reimbursement is for losses related to \"commercial personal property\" and \"industrial personal property\" as those terms are defined in "]
["MCL 123.1345 (e) and (o), respectively."]
[]
["MCL 123.1357 (2)"]
["In fiscal year 2014-2015 and fiscal year 2015-2016, the (Local Community Stabilization) authority shall distribute to municipalities those "]
["funds appropriated under subsection (1)(a). However, in fiscal year 2014-2015, if the authority is not able to make the distribution under "]
["this subsection, the (Treasury) department shall make the distribution under this subsection on behalf of the authority."]
[]
["The authority  is unable to make the distribution this year, so Treasury will do so on behalf of the authority. Reimbursements will be mailed."]
[]
["Blue","cells are for data entry throughout the form. ",null,null,null,"Yellow","cells are the values that drive the reimbursement calculations,"]
["and are computed from the entered data."]
[]
["TIFA Identity"]
[]
["This page is just to identify the TIFA claiming reimbursement. If the TIF district has small parcel exemption loss in more than one school district,"]
["a separate form must be filed for each school district. If the TIF district is in more than one school district but all the small parcel exemption loss"]
["is in one school district, there is no need to file for the school district that contains no small parcel exemption loss."]
["Please do not leave the e-mail address field blank!"]
[]
["2014 Estimated TIF revenue (not required of Brownfield Authorities) "]
[]
["Form 5176 requires the estimation of 2014 TIF revenue by property class. Some classes have \"negative capture\" from the decline in property"]
["values, which offsets the positive capture in classes that have property value growth,  and also offsets the amount of reimbursement due from "]
["small parcel exemption losses. Since \"negative capture\" is prohibited by 1996 PA 381, this step is not required on Form 5176BR."]
[]
["TIF small parcel exemption loss"]
[]
["The data on this page is used to calculate the loss in captured taxable value.  Enter the 2013 captured taxable value by class, then the 2014 captured"]
["taxable value by class. The small parcel exemption loss is defined as the 2013 captured taxable value minus the 2014 captured taxable value. "]
[]
[]
["The CTV losses are calculated by class of personal property--commercial vs. industrial, ad valorem vs. IFT, and IFT new vs. IFT replacement--"]
["due to the different tax rates in each class to compute tax increment revenue. TIF revenue loss attributable to small parcel loss is computed by "]
["property class, and the TIF revenues by each class are netted to determine reimbursement. Because of differing tax rates on different classes "]
["of property, different rates of reimbursement may occur in TIFAs with the same overall change in captured taxable value, but occurring in"]
["different proportions among the various classes of property."]
[]
[]
[]
["Captured Millages"]
[]
["This section will be the most time-consuming, and is very important in determining the correct reimbursement. On this sheet in cell A4,"]
["just above the \"Go to Instructions\" button, is the phrase, \"Lower of 2012 or 2013 Millage Levies\". This phrase is hyperlinked to a Treasury web page."]
["In the center of that web page beneath the phrase,\"As required by SB 821, Sec. 13(5)\" are five more hyperlinks to reports that compare 2012 and 2013 "]
["millage rates for every tax levied, and give the lower of the two rates."]
[]
["Each report is sorted in alpha order by county. In the County/City/Village/Township report, the county is listed first with a six-digit number ending in '0000'."]
["In each county, the county is followed by townships (3rd digit 1), cities (3rd digit 2) and villages (3rd digit 3). Only the allocated/charter millage goes in the first "]
["three lines on the worksheet; since they are relatively unique to each local unit, all other millages levied must be typed in on the extra-voted lines."]
["You must go through all five of these reports to find your millage rates and enter them on this sheet in the column labeled \"100% of ad valorem rates.\""]
[]
["The items in the reports are generally placed in the color-coded sections on the Captured Millages sheet:"]
[]
["County/City/Village/Township",null,null,"Authorities and Extra-Voted",null,null,"Community College",null,"ISD","Local School District"]
[]
["There are exceptions, though: some millages are relatively rare (community college debt and school district recreation, for example) and must be typed in "]
["the \"Extra-voted\" fields. When entering a millage in the extra-voted cells, please identify the jurisdiction levying it; e.g., County senior center or Village parks."]
["Do not enter ad valorem special assessments on this sheet; special assessments may not be captured by TIF districts and thus are not reimbursed. "]
[]
["Many TIFAs capture less than 100% of some or all millages levied, either as a result of provisions in the TIF plan or through various statutory prohibitions"]
["of the capture of certain millages. For instance, some TIFAs are prohibited by statute from capturing school taxes. Others may not capture debt millage."]
["In the \"Fixed rate foregone\" column you should enter, if applicable, any fixed millage rates the TIFA agrees not to capture. Some, for example, agree to not "]
["capture the first mill of a 1.6555 library millage. In that case, enter 1.0000 in this column."]
[]
["In the \"Percent Captured\" column, enter the percent of the captured value kept by the TIFA. Generally, this is 100% but some agree to take less, or are "]
["proscribed by law from capturing some millage. For instance, those TIFAs prohibited from capturing debt millage should enter a '0' in this column for all debt "]
["millages. Or, an LDFA 'Smart Zone' should enter 50% in this column for the school taxes if they are still in the 15-year period in which they may capture half "]
["the school taxes. Also, for any tax the TIFA does not capture, the % should be zero."]
[]
["The adjustments made in these columns are used to calculate the Adjusted Rate Captured in the yellow boxes. "]
[]
["Tax Increment Small Taxpayer Loss"]
[]
["There is no data entry required on this page. It calculates the revenue loss by personal property type based on the millage rates captured. The Adjusted Rates "]
["Captured from the Captured Millages sheet are further adjusted on this sheet to reflect the various exemptions for the different personal property classes"]
[" and applied to the loss in captured value attributable to small parcel exemption loss. "]
[]
[]
[]
["You should maintain a list of all parcels in the TIF district that received a small taxpayer exemption in 2014, including the 2013 taxable value of"]
["those parcels. In addition, maintain any internal records (like the tax increment financing plan that details the millages captured) in support of "]
["this request. These claims will be audited, and repayment may be required for unsubstantiated claims "]

{"sheet":"TIFA Identity","index":1,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[[13,7,13,9],[0,7,0,9],[36,9,39,9],[37,2,37,6],[11,7,11,9],[7,7,7,9],[15,7,15,9],[9,7,9,9],[17,7,17,9],[18,7,18,9],[39,4,39,7]]}
["Michigan Department of Treasury",null,null,null,null,null,null,"FOR CALENDAR YEAR 2014"]
["5176BR (6-14)"]
["Request for State Reimbursement of Tax Increment Finance Authority "]
["Tax Increment Small Taxpayer Loss for Brownfield Authorities (non-Brownfields Use Form 5176)"]
["Issued under Public Act 86 of 2014.  Filing is mandatory."]
["A SEPARATE REQUEST IS REQUIRED FOR EACH TAX INCREMENT FINANCING (TIF) DISTRICT and SCHOOL DISTRICT"]
[]
["Name of Municipality (County, City, Township, Village)"]
[]
["School District"]
[]
["Type of Authority ",null,null,null,null,null,null,"Brownfield Redevelopment Finance Authority"]
[]
["Authority Name/Identifier (optional)"]
[]
["E-mail address"]
[]
["Contact Person"]
["Telephone number"]
[]
["Did this TIF Plan also file the 2014 Form 4650"]
["Request for State Reimbursement of Tax Increment Revenue Decreases?"]
["(mark appropriate box with an 'X')"]
[null,null,null,null,null,null,null,"Yes",null,"No"]
[]
[]
[]
["Are any parcels in this Authority's TIF plan subject to a Renaissance Zone exemption?"]
["(mark appropriate box with an 'X')"]
[null,null,null,null,null,null,null,"Yes",null,"No"]
[]
[{"$f":"IF(G30=\"x\", \"Adjust all captured value on Renaissance Zone parcels to reflect the taxable portion.\",\"\")","v":""}]
[{"$f":"IF(G30=\"x\", \"The taxable portion may be 0%, 25%, 50% or 75% of the captured value.\",\"\")","v":""}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"THIS APPLICATION      IS DUE BY           JUNE 15, 2014"]
[]
[]
["UPON COMPLETION, E-MAIL TO: ",null,null,null,"Treas_LAFD@michigan.gov"]

{"sheet":"2014 Estimated TIF revenue","index":2,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["Michigan Department of Treasury"]
["XXXX (6-14)"]
[]
["PROPERTY TYPE",null,"2014 TAXABLE VALUE",null,"INITIAL YEAR TAXABLE VALUE",null,"2014 CAPTURED TAXABLE VALUE",null,"MILLAGES CAPTURED","ESTIMATED 2014 TIF REVENUE"]
[null,null,null,null,null,null,null,null,"(use 2013 rates to estimate )"]
["Ad valorem PRE real property",null,0,null,0,null,{"$f":"C6-E6","v":0},null,36,{"$f":"G6*I6/1000","v":0}]
["Ad valorem non-PRE real property",null,45000,null,65000,null,{"$f":"C7-E7","v":-20000},null,54,{"$f":"G7*I7/1000","v":-1080}]
["Ad valorem non-PRE commercial personal property",null,23500,null,32870,null,-9370,null,42,-393.54]
["Ad valorem non-PRE industrial personal property",null,0,null,10000,null,-10000,null,30,-300]
["Ad valorem utility personal property",null,0,null,0,null,0,null,0,0]
["Ad valorem other personal property",null,0,null,0,null,{"$f":"C11-E11","v":0},null,0,0]
["IFT New Facility real property, 0% SET exemption",null,0,null,0,null,{"$f":"C12-E12","v":0},null,30,0]
["IFT New Facility real property, 50% SET exemption",null,0,null,0,null,0,null,27,0]
["IFT New Facility real property, 100% SET exemption",null,0,null,0,null,{"$f":"C14-E14","v":0},null,24,0]
["IFT New Facility personal property on commercial class land",null,800,null,10000,null,{"$f":"C15-E15","v":-9200},null,21,-193.2]
["IFT New Facility personal property on industrial class land",null,4200,null,11400,null,{"$f":"C16-E16","v":-7200},null,15,-108]
["IFT New Facility personal property, all other",null,0,null,0,null,{"$f":"C17-E17","v":0},null,0,0]
["IFT Replacement Facility real property (frozen values)",null,0,null,0,null,0,null,54,0]
["IFT Replacement Facility personal property (frozen values)",null,6000,null,6500,null,-500,null,54,-27]
["CFT New Facility real and personal property",null,0,null,0,null,{"$f":"C20-E20","v":0},null,0,0]
["CFT Restored (frozen values)",null,0,null,0,null,{"$f":"C21-E21","v":0},null,0,0]
[]
[null,null,null,null,null,null,null,null,"Total TIF Revenue",{"$f":"SUM(J6:J21)","v":-2101.7399999999998}]
[]
[]
[{"$f":"CONCATENATE(\"Municipality:   \",IF('TIFA Identity'!H8=\"\",\"\",'TIFA Identity'!H8))","v":"Municipality:   "}]
[]
[{"$f":"CONCATENATE(\"School District:   \",IF('TIFA Identity'!H10=\"\",\"\",'TIFA Identity'!H10))","v":"School District:   "}]
[]
[{"$f":"CONCATENATE(\"Authority Type:   \",IF('TIFA Identity'!H12=\"\",\"\",'TIFA Identity'!H12))","v":"Authority Type:   Brownfield Redevelopment Finance Authority"}]
[]
[{"$f":"CONCATENATE(\"Authority Name:   \",IF('TIFA Identity'!H14=\"\",\"\",'TIFA Identity'!H14))","v":"Authority Name:   "}]

{"sheet":"TIF small parcel exemption loss","index":3,"n_rows":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":false,"merged":[[16,12,16,13],[19,12,19,13],[5,6,6,12],[0,12,0,13],[1,12,3,13],[8,12,8,13],[10,12,10,13],[13,12,13,13],[1,14,3,14],[1,16,3,16],[4,16,5,16],[19,9,19,10],[8,6,8,7],[10,6,10,7],[13,6,13,7],[16,6,16,7],[19,6,19,7],[13,9,13,10],[16,9,16,10],[8,14,8,15],[10,14,10,15],[13,14,13,15],[16,14,16,15],[19,14,19,15],[0,0,0,2],[10,9,10,10],[8,9,8,10],[0,6,0,7],[0,9,0,10],[1,6,3,7],[1,9,3,10],[1,0,1,2]]}
[{"$f":"'TIFA Identity'!A1","v":"Michigan Department of Treasury"},null,null,null,null,null,"A.",null,null,"B.",null,null,"C. (A-B)"]
[{"$f":"'TIFA Identity'!A2","v":"5176BR (6-14)"},null,null,null,null,null,"2013 captured value of personal property in Brownfield plan",null,null,"2014 captured value of personal property in Brownfield plan",null,null,"Personal Property total captured value loss (gain)"]
[null,"CAPTURED TAXABLE"]
[null," VALUE FROM:"]
[]
[null,null,null,null,null,null,"Minimum of 0 in captured value fields. \"Negative capture\" in a brownfield plan is prohibited by statute--MCL 125.2657 (2)"]
[]
[]
["1.","Ad valorem commercial personal property",null,null,null,null,null,null,null,null,null,null,{"$f":"G9-J9","v":0}]
[]
["2.","Ad valorem industrial personal property",null,null,null,null,null,null,null,null,null,null,{"$f":"G11-J11","v":0}]
[]
["3.","IFT New Facility personal property sited"]
[null,"on land classified commercial real property",null,null,null,null,null,null,null,null,null,null,{"$f":"G14-J14","v":0}]
[]
["4.","IFT New Facility personal property sited"]
[null,"on land classified industrial real property",null,null,null,null,null,null,null,null,null,null,{"$f":"G17-J17","v":0}]
[]
["5.","IFT Replacement Facility "]
[null,"personal property",null,null,null,null,null,null,null,null,null,null,{"$f":"G20-J20","v":0}]
[]
[]
[]
[{"$f":"CONCATENATE(\"Municipality:   \",IF('TIFA Identity'!H8=\"\",\"\",'TIFA Identity'!H8))","v":"Municipality:   "}]
[]
[{"$f":"CONCATENATE(\"School District:   \",IF('TIFA Identity'!H10=\"\",\"\",'TIFA Identity'!H10))","v":"School District:   "}]
[]
[{"$f":"CONCATENATE(\"Authority Type:   \",'TIFA Identity'!H12)","v":"Authority Type:   Brownfield Redevelopment Finance Authority"}]
[]
[{"$f":"CONCATENATE(\"Authority Name:   \",IF('TIFA Identity'!H14=\"\",\"\",'TIFA Identity'!H14))","v":"Authority Name:   "}]

{"sheet":"Captured Millages","index":4,"n_rows":127,"n_cols":9,"rows_kept":127,"cut":false,"hidden":false,"merged":[[2,2,3,8]]}
[{"$f":"'TIFA Identity'!A1","v":"Michigan Department of Treasury"}]
[{"$f":"'TIFA Identity'!A2","v":"5176BR (6-14)"}]
["Taxes Captured",null,"Enter 100% of all tax millage rates levied on the ad valorem roll. If you don't capture it (e.g., school taxes or debt millage), enter 0 in \"Percent Captured\". Do NOT enter ad valorem special assessments."]
["Lower of 2012 or 2013 Millage Levies"]
["you must click on this hyperlink to find your reimbursement millage rates",null,"100% of Ad Valorem Rate",null,"Fixed rate foregone (if any)",null,"Percent Captured",null,"Adjusted Rate Captured"]
[]
["County Alloc/Charter",null,0,null,0,null,0,null,{"$f":"(C7-E7)*G7","v":0}]
[]
["County extra voted - type in purpose",null,0,null,0,null,0,null,{"$f":"(C9-E9)*G9","v":0}]
[]
["County extra voted - type in purpose",null,0,null,0,null,0,null,{"$f":"(C11-E11)*G11","v":0}]
[]
["County extra voted - type in purpose",null,0,null,0,null,0,null,{"$f":"(C13-E13)*G13","v":0}]
[]
["County extra voted - type in purpose",null,0,null,0,null,0,null,{"$f":"(C15-E15)*G15","v":0}]
[]
["County extra voted - type in purpose",null,0,null,0,null,0,null,{"$f":"(C17-E17)*G17","v":0}]
[]
["County extra voted - type in purpose",null,0,null,0,null,0,null,{"$f":"(C19-E19)*G19","v":0}]
[]
["County extra voted - type in purpose",null,0,null,0,null,0,null,{"$f":"(C21-E21)*G21","v":0}]
[]
["County extra voted - type in purpose",null,0,null,0,null,0,null,{"$f":"(C23-E23)*G23","v":0}]
[]
["County extra voted - type in purpose",null,0,null,0,null,0,null,{"$f":"(C25-E25)*G25","v":0}]
[]
["County extra voted - type in purpose",null,0,null,0,null,0,null,{"$f":"(C27-E27)*G27","v":0}]
[]
["County extra voted - type in purpose",null,0,null,0,null,0,null,{"$f":"(C29-E29)*G29","v":0}]
[]
["County extra voted - type in purpose",null,0,null,0,null,0,null,{"$f":"(C31-E31)*G31","v":0}]
[]
["City/Township Alloc/Charter",null,0,null,0,null,0,null,{"$f":"(C33-E33)*G33","v":0}]
[]
["City/Township extra voted - type in purpose",null,0,null,0,null,0,null,{"$f":"(C35-E35)*G35","v":0}]
[]
["City/Township extra voted - type in purpose",null,0,null,0,null,0,null,{"$f":"(C37-E37)*G37","v":0}]
[]
["City/Township extra voted - type in purpose",null,0,null,0,null,0,null,{"$f":"(C39-E39)*G39","v":0}]
[]
["City/Township extra voted - type in purpose",null,0,null,0,null,0,null,{"$f":"(C41-E41)*G41","v":0}]
[]
["City/Township extra voted - type in purpose",null,0,null,0,null,0,null,{"$f":"(C43-E43)*G43","v":0}]
[]
["City/Township extra voted - type in purpose",null,0,null,0,null,0,null,{"$f":"(C45-E45)*G45","v":0}]
[]
["City/Township extra voted - type in purpose",null,0,null,0,null,0,null,{"$f":"(C47-E47)*G47","v":0}]
[]
["City/Township extra voted - type in purpose",null,0,null,0,null,0,null,{"$f":"(C49-E49)*G49","v":0}]
[]
["City/Township extra voted - type in purpose",null,0,null,0,null,0,null,{"$f":"(C51-E51)*G51","v":0}]
[]
["City/Township extra voted - type in purpose",null,0,null,0,null,0,null,{"$f":"(C53-E53)*G53","v":0}]
[]
["City/Township extra voted - type in purpose",null,0,null,0,null,0,null,{"$f":"(C55-E55)*G55","v":0}]
[]
["City/Township extra voted - type in purpose",null,0,null,0,null,0,null,{"$f":"(C57-E57)*G57","v":0}]
[]
["City/Township extra voted - type in purpose",null,0,null,0,null,0,null,{"$f":"(C59-E59)*G59","v":0}]
[]
["Village Alloc/Charter",null,0,null,0,null,0,null,{"$f":"(C61-E61)*G61","v":0}]
[]
["Village extra voted - type in purpose",null,0,null,0,null,0,null,{"$f":"(C63-E63)*G63","v":0}]
[]
["Village extra voted - type in purpose",null,0,null,0,null,0,null,{"$f":"(C65-E65)*G65","v":0}]
[]
["Village extra voted - type in purpose",null,0,null,0,null,0,null,{"$f":"(C67-E67)*G67","v":0}]
[]
["Village extra voted - type in purpose",null,0,null,0,null,0,null,{"$f":"(C69-E69)*G69","v":0}]
[]
["Village extra voted - type in purpose",null,0,null,0,null,0,null,{"$f":"(C71-E71)*G71","v":0}]
[]
["Village extra voted - type in purpose",null,0,null,0,null,0,null,{"$f":"(C73-E73)*G73","v":0}]
[]
["Local School non-homestead (non-PRE) operating tax",null,0,null,0,null,0,null,{"$f":"(C75-E75)*G75","v":0}]
[]
["Local School supplemental (hold-harmless) tax",null,0,null,0,null,0,null,{"$f":"(C77-E77)*G77","v":0}]
[]
["Local School sinking fund (Local tax for BRFAs, School tax for all others)",null,0,null,0,null,0,null,{"$f":"(C79-E79)*G79","v":0}]
[]
["Local School recreational (Local tax for BRFAs, School tax for all others)",null,0,null,0,null,0,null,{"$f":"(C81-E81)*G81","v":0}]
[]
["Local School debt",null,0,null,0,null,0,null,{"$f":"(C83-E83)*G83","v":0}]
[]
["State Education Tax",null,6,null,0,null,0,null,{"$f":"(C85-E85)*G85","v":0}]
[]
["Community College operating",null,0,null,0,null,0,null,{"$f":"(C87-E87)*G87","v":0}]
[]
["Community College debt",null,0,null,0,null,0,null,{"$f":"(C89-E89)*G89","v":0}]
[]
["ISD Allocated (Local tax for BRFAs, School tax for all others)",null,0,null,0,null,0,null,{"$f":"(C91-E91)*G91","v":0}]
[]
["ISD Special Education (Local tax for BRFAs, School tax for all others)",null,0,null,0,null,0,null,{"$f":"(C93-E93)*G93","v":0}]
[]
["ISD Vocational Education (Local tax for BRFAs, School tax for all others)",null,0,null,0,null,0,null,{"$f":"(C95-E95)*G95","v":0}]
[]
["ISD Enhancement (Local tax for BRFAs, School tax for all others)",null,0,null,0,null,0,null,{"$f":"(C97-E97)*G97","v":0}]
[]
["ISD debt (Local tax for BRFAs, School tax for all others)",null,0,null,0,null,0,null,{"$f":"(C99-E99)*G99","v":0}]
[]
["Special authorities - type in purpose",null,0,null,0,null,0,null,{"$f":"(C101-E101)*G101","v":0}]
[]
["Special authorities - type in purpose",null,0,null,0,null,0,null,{"$f":"(C103-E103)*G103","v":0}]
[]
["Special authorities - type in purpose",null,0,null,0,null,0,null,{"$f":"(C105-E105)*G105","v":0}]
[]
["Special authorities - type in purpose",null,0,null,0,null,0,null,{"$f":"(C107-E107)*G107","v":0}]
[]
["Special authorities - type in purpose",null,0,null,0,null,0,null,{"$f":"(C109-E109)*G109","v":0}]
[]
["Special authorities - type in purpose",null,0,null,0,null,0,null,{"$f":"(C111-E111)*G111","v":0}]
[]
["Special authorities - type in purpose",null,0,null,0,null,0,null,{"$f":"(C113-E113)*G113","v":0}]
[]
["Special authorities - type in purpose",null,0,null,0,null,0,null,{"$f":"(C115-E115)*G115","v":0}]
[]
[]
["TOTAL  MILLAGE CAPTURED FROM AD VALOREM TAXES",null,null,null,null,null,null,null,{"$f":"SUM(I7:I115)","v":0}]
[]
[]
[{"$f":"CONCATENATE(\"Municipality:   \",IF('TIFA Identity'!H8=\"\",\"\",'TIFA Identity'!H8))","v":"Municipality:   "}]
[]
[{"$f":"CONCATENATE(\"School District:   \",IF('TIFA Identity'!H10=\"\",\"\",'TIFA Identity'!H10))","v":"School District:   "}]
[]
[{"$f":"CONCATENATE(\"Authority Type:   \",IF('TIFA Identity'!H12=\"\",\"\",'TIFA Identity'!H12))","v":"Authority Type:   Brownfield Redevelopment Finance Authority"}]
[]
[{"$f":"CONCATENATE(\"Authority Name:   \",IF('TIFA Identity'!H14=\"\",\"\",'TIFA Identity'!H14))","v":"Authority Name:   "}]

{"sheet":"Tax Increment SmallTaxpayerLoss","index":5,"n_rows":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":false,"merged":[[4,7,4,8],[16,7,16,8],[19,7,19,8],[8,7,8,8],[10,7,10,8],[13,7,13,8]]}
[{"$f":"'TIFA Identity'!A1","v":"Michigan Department of Treasury"}]
[{"$f":"'TIFA Identity'!A2","v":"5176BR (6-14)"}]
["Tax Increment Small Taxpayer Loss"]
[]
[null,null,null,null,null,null,null,"Captured Value loss (gain) (from 'TIF small parcel exemption loss', Col. C)",null,null,"Captured Millage (from 'Captured Millages', adjusted for exemptions by class)",null,"personal property TIF revenue loss (gain)"]
[]
[]
[]
["1.","Ad valorem commercial personal property",null,null,null,null,null,{"$f":"'TIF small parcel exemption loss'!M9","v":0},null,"x",{"$f":"('Captured Millages'!I118-'Captured Millages'!I75+(('Captured Millages'!C75-12)*'Captured Millages'!G75))","v":0},"=",{"$f":"H9*K9/1000","v":0}]
[]
["2.","Ad valorem industrial personal property",null,null,null,null,null,{"$f":"'TIF small parcel exemption loss'!M11","v":0},null,"x",{"$f":"'Captured Millages'!I118-'Captured Millages'!I75-('Captured Millages'!I85)","v":0},"=",{"$f":"H11*K11/1000","v":0}]
[]
["3.","IFT New Facility personal property "]
[null,"sited on land classified commercial real property",null,null,null,null,null,{"$f":"'TIF small parcel exemption loss'!M14","v":0},null,"x",{"$f":"K9*0.5","v":0},"=",{"$f":"H14*K14/1000","v":0}]
[]
["4.","IFT New Facility personal property "]
[null,"sited on land classified industrial real property",null,null,null,null,null,{"$f":"'TIF small parcel exemption loss'!M17","v":0},null,"x",{"$f":"K11*0.5","v":0},"=",{"$f":"H17*K17/1000","v":0}]
[]
["5.","IFT Replacement Facility "]
[null,"personal property",null,null,null,null,null,{"$f":"'TIF small parcel exemption loss'!M20","v":0},null,"x",{"$f":"'Captured Millages'!I118","v":0},"=",{"$f":"H20*K20/1000","v":0}]
[]
[null,"TOTAL TAX INCREMENT SMALL TAXPAYER LOSS TO REIMBURSE",null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,SUM(M9:M20))","v":0}]
[]
[{"$f":"CONCATENATE(\"Municipality:   \",IF('TIFA Identity'!H8=\"\",\"\",'TIFA Identity'!H8))","v":"Municipality:   "}]
[]
[{"$f":"CONCATENATE(\"School District:   \",IF('TIFA Identity'!H10=\"\",\"\",'TIFA Identity'!H10))","v":"School District:   "}]
[]
[{"$f":"CONCATENATE(\"Authority Type:   \",IF('TIFA Identity'!H12=\"\",\"\",'TIFA Identity'!H12))","v":"Authority Type:   Brownfield Redevelopment Finance Authority"}]
[]
[{"$f":"CONCATENATE(\"Authority Name:   \",IF('TIFA Identity'!H14=\"\",\"\",'TIFA Identity'!H14))","v":"Authority Name:   "}]

{"sheet":"Losses by millage","index":6,"n_rows":127,"n_cols":26,"rows_kept":127,"cut":false,"hidden":true,"merged":[]}
["TIF Small Taxpayer Loss by Millage/Tax Roll",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'TIFA Identity'!H1","v":"FOR CALENDAR YEAR 2014"},null,null,null,null,null,null,null,null,null,null,"ortadata"]
[]
[null,null,"Adjusted Rate Captured",null,"Ad Valorem Commercial PP",null,"Ad Valorem Industrial PP",null,"IFT New Facility Commercial PP",null,"IFT New Facility Industrial PP",null,"IFT Replacement Facility PP",null,"TOTAL"]
[]
[]
[]
[{"$f":"'Captured Millages'!A7","v":"County Alloc/Charter"},null,{"$f":"'Captured Millages'!I7","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C7/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C7/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C7/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C7/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C7/1000","v":0},null,{"$f":"MAX(0,SUM(E7:N7))","v":0}]
[]
[{"$f":"'Captured Millages'!A9","v":"County extra voted - type in purpose"},null,{"$f":"'Captured Millages'!I9","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C9/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C9/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C9/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C9/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C9/1000","v":0},null,{"$f":"MAX(0,SUM(E9:N9))","v":0}]
[]
[{"$f":"'Captured Millages'!A11","v":"County extra voted - type in purpose"},null,{"$f":"'Captured Millages'!I11","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C11/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C11/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C11/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C11/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C11/1000","v":0},null,{"$f":"MAX(0,SUM(E11:N11))","v":0}]
[]
[{"$f":"'Captured Millages'!A13","v":"County extra voted - type in purpose"},null,{"$f":"'Captured Millages'!I13","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C13/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C13/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C13/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C13/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C13/1000","v":0},null,{"$f":"MAX(0,SUM(E13:N13))","v":0}]
[]
[{"$f":"'Captured Millages'!A15","v":"County extra voted - type in purpose"},null,{"$f":"'Captured Millages'!I15","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C15/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C15/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C15/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C15/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C15/1000","v":0},null,{"$f":"MAX(0,SUM(E15:N15))","v":0}]
[]
[{"$f":"'Captured Millages'!A17","v":"County extra voted - type in purpose"},null,{"$f":"'Captured Millages'!I17","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C17/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C17/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C17/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C17/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C17/1000","v":0},null,{"$f":"MAX(0,SUM(E17:N17))","v":0}]
[]
[{"$f":"'Captured Millages'!A19","v":"County extra voted - type in purpose"},null,{"$f":"'Captured Millages'!I19","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C19/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C19/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C19/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C19/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C19/1000","v":0},null,{"$f":"MAX(0,SUM(E19:N19))","v":0}]
[]
[{"$f":"'Captured Millages'!A21","v":"County extra voted - type in purpose"},null,{"$f":"'Captured Millages'!I21","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C21/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C21/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C21/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C21/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C21/1000","v":0},null,{"$f":"MAX(0,SUM(E21:N21))","v":0}]
[]
[{"$f":"'Captured Millages'!A23","v":"County extra voted - type in purpose"},null,{"$f":"'Captured Millages'!I23","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C23/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C23/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C23/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C23/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C23/1000","v":0},null,{"$f":"MAX(0,SUM(E23:N23))","v":0}]
[]
[{"$f":"'Captured Millages'!A25","v":"County extra voted - type in purpose"},null,{"$f":"'Captured Millages'!I25","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C25/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C25/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C25/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C25/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C25/1000","v":0},null,{"$f":"MAX(0,SUM(E25:N25))","v":0}]
[]
[{"$f":"'Captured Millages'!A27","v":"County extra voted - type in purpose"},null,{"$f":"'Captured Millages'!I27","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C27/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C27/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C27/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C27/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C27/1000","v":0},null,{"$f":"MAX(0,SUM(E27:N27))","v":0}]
[]
[{"$f":"'Captured Millages'!A29","v":"County extra voted - type in purpose"},null,{"$f":"'Captured Millages'!I29","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C29/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C29/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C29/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C29/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C29/1000","v":0},null,{"$f":"MAX(0,SUM(E29:N29))","v":0}]
[]
[{"$f":"'Captured Millages'!A31","v":"County extra voted - type in purpose"},null,{"$f":"'Captured Millages'!I31","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C31/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C31/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C31/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C31/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C31/1000","v":0},null,{"$f":"MAX(0,SUM(E31:N31))","v":0}]
[]
[{"$f":"'Captured Millages'!A33","v":"City/Township Alloc/Charter"},null,{"$f":"'Captured Millages'!I33","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C33/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C33/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C33/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C33/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C33/1000","v":0},null,{"$f":"MAX(0,SUM(E33:N33))","v":0}]
[]
[{"$f":"'Captured Millages'!A35","v":"City/Township extra voted - type in purpose"},null,{"$f":"'Captured Millages'!I35","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C35/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C35/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C35/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C35/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C35/1000","v":0},null,{"$f":"MAX(0,SUM(E35:N35))","v":0}]
[]
[{"$f":"'Captured Millages'!A37","v":"City/Township extra voted - type in purpose"},null,{"$f":"'Captured Millages'!I37","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C37/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C37/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C37/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C37/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C37/1000","v":0},null,{"$f":"MAX(0,SUM(E37:N37))","v":0}]
[]
[{"$f":"'Captured Millages'!A39","v":"City/Township extra voted - type in purpose"},null,{"$f":"'Captured Millages'!I39","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C39/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C39/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C39/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C39/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C39/1000","v":0},null,{"$f":"MAX(0,SUM(E39:N39))","v":0}]
[]
[{"$f":"'Captured Millages'!A41","v":"City/Township extra voted - type in purpose"},null,{"$f":"'Captured Millages'!I41","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C41/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C41/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C41/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C41/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C41/1000","v":0},null,{"$f":"MAX(0,SUM(E41:N41))","v":0}]
[]
[{"$f":"'Captured Millages'!A43","v":"City/Township extra voted - type in purpose"},null,{"$f":"'Captured Millages'!I43","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C43/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C43/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C43/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C43/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C43/1000","v":0},null,{"$f":"MAX(0,SUM(E43:N43))","v":0}]
[]
[{"$f":"'Captured Millages'!A45","v":"City/Township extra voted - type in purpose"},null,{"$f":"'Captured Millages'!I45","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C45/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C45/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C45/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C45/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C45/1000","v":0},null,{"$f":"MAX(0,SUM(E45:N45))","v":0}]
[]
[{"$f":"'Captured Millages'!A47","v":"City/Township extra voted - type in purpose"},null,{"$f":"'Captured Millages'!I47","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C47/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C47/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C47/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C47/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C47/1000","v":0},null,{"$f":"MAX(0,SUM(E47:N47))","v":0}]
[]
[{"$f":"'Captured Millages'!A49","v":"City/Township extra voted - type in purpose"},null,{"$f":"'Captured Millages'!I49","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C49/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C49/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C49/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C49/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C49/1000","v":0},null,{"$f":"MAX(0,SUM(E49:N49))","v":0}]
[]
[{"$f":"'Captured Millages'!A51","v":"City/Township extra voted - type in purpose"},null,{"$f":"'Captured Millages'!I51","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C51/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C51/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C51/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C51/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C51/1000","v":0},null,{"$f":"MAX(0,SUM(E51:N51))","v":0}]
[]
[{"$f":"'Captured Millages'!A53","v":"City/Township extra voted - type in purpose"},null,{"$f":"'Captured Millages'!I53","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C53/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C53/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C53/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C53/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C53/1000","v":0},null,{"$f":"MAX(0,SUM(E53:N53))","v":0}]
[]
[{"$f":"'Captured Millages'!A55","v":"City/Township extra voted - type in purpose"},null,{"$f":"'Captured Millages'!I55","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C55/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C55/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C55/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C55/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C55/1000","v":0},null,{"$f":"MAX(0,SUM(E55:N55))","v":0}]
[]
[{"$f":"'Captured Millages'!A57","v":"City/Township extra voted - type in purpose"},null,{"$f":"'Captured Millages'!I57","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C57/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C57/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C57/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C57/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C57/1000","v":0},null,{"$f":"MAX(0,SUM(E57:N57))","v":0}]
[]
[{"$f":"'Captured Millages'!A59","v":"City/Township extra voted - type in purpose"},null,{"$f":"'Captured Millages'!I59","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C59/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C59/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C59/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C59/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C59/1000","v":0},null,{"$f":"MAX(0,SUM(E59:N59))","v":0}]
[]
[{"$f":"'Captured Millages'!A61","v":"Village Alloc/Charter"},null,{"$f":"'Captured Millages'!I61","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C61/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C61/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C61/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C61/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C61/1000","v":0},null,{"$f":"MAX(0,SUM(E61:N61))","v":0}]
[]
[{"$f":"'Captured Millages'!A63","v":"Village extra voted - type in purpose"},null,{"$f":"'Captured Millages'!I63","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C63/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C63/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C63/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C63/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C63/1000","v":0},null,{"$f":"MAX(0,SUM(E63:N63))","v":0}]
[]
[{"$f":"'Captured Millages'!A65","v":"Village extra voted - type in purpose"},null,{"$f":"'Captured Millages'!I65","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C65/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C65/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C65/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C65/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C65/1000","v":0},null,{"$f":"MAX(0,SUM(E65:N65))","v":0}]
[]
[{"$f":"'Captured Millages'!A67","v":"Village extra voted - type in purpose"},null,{"$f":"'Captured Millages'!I67","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C67/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C67/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C67/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C67/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C67/1000","v":0},null,{"$f":"MAX(0,SUM(E67:N67))","v":0}]
[]
[{"$f":"'Captured Millages'!A69","v":"Village extra voted - type in purpose"},null,{"$f":"'Captured Millages'!I69","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C69/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C69/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C69/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C69/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C69/1000","v":0},null,{"$f":"MAX(0,SUM(E69:N69))","v":0}]
[]
[{"$f":"'Captured Millages'!A71","v":"Village extra voted - type in purpose"},null,{"$f":"'Captured Millages'!I71","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C71/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C71/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C71/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C71/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C71/1000","v":0},null,{"$f":"MAX(0,SUM(E71:N71))","v":0}]
[]
[{"$f":"'Captured Millages'!A73","v":"Village extra voted - type in purpose"},null,{"$f":"'Captured Millages'!I73","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C73/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C73/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C73/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C73/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C73/1000","v":0},null,{"$f":"MAX(0,SUM(E73:N73))","v":0}]
[]
[{"$f":"'Captured Millages'!A75","v":"Local School non-homestead (non-PRE) operating tax"},null,{"$f":"'Captured Millages'!I75","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*('Losses by millage'!C75-(12*'Captured Millages'!G75))/1000","v":0},null,0,null,{"$f":"'TIF small parcel exemption loss'!$M$14*('Losses by millage'!C75-(12*'Captured Millages'!G75))/1000*0.5","v":0},null,0,null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C75/1000","v":0},null,{"$f":"MAX(0,SUM(E75:N75))","v":0}]
[]
[{"$f":"'Captured Millages'!A77","v":"Local School supplemental (hold-harmless) tax"},null,{"$f":"'Captured Millages'!I77","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C77/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C77/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C77/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C77/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C77/1000","v":0},null,{"$f":"MAX(0,SUM(E77:N77))","v":0}]
[]
[{"$f":"'Captured Millages'!A79","v":"Local School sinking fund (Local tax for BRFAs, School tax for all others)"},null,{"$f":"'Captured Millages'!I79","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C79/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C79/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C79/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C79/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C79/1000","v":0},null,{"$f":"MAX(0,SUM(E79:N79))","v":0}]
[]
[{"$f":"'Captured Millages'!A81","v":"Local School recreational (Local tax for BRFAs, School tax for all others)"},null,{"$f":"'Captured Millages'!I81","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C81/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C81/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C81/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C81/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C81/1000","v":0},null,{"$f":"MAX(0,SUM(E81:N81))","v":0}]
[]
[{"$f":"'Captured Millages'!A83","v":"Local School debt"},null,{"$f":"'Captured Millages'!I83","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C83/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C83/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C83/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C83/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C83/1000","v":0},null,{"$f":"MAX(0,SUM(E83:N83))","v":0}]
[]
[{"$f":"'Captured Millages'!A85","v":"State Education Tax"},null,{"$f":"'Captured Millages'!I85","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C85/1000","v":0},null,0,null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C85/1000*0.5","v":0},null,0,null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C85/1000","v":0},null,{"$f":"MAX(0,SUM(E85:N85))","v":0}]
[]
[{"$f":"'Captured Millages'!A87","v":"Community College operating"},null,{"$f":"'Captured Millages'!I87","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C87/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C87/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C87/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C87/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C87/1000","v":0},null,{"$f":"MAX(0,SUM(E87:N87))","v":0}]
[]
[{"$f":"'Captured Millages'!A89","v":"Community College debt"},null,{"$f":"'Captured Millages'!I89","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C89/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C89/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C89/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C89/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C89/1000","v":0},null,{"$f":"MAX(0,SUM(E89:N89))","v":0}]
[]
[{"$f":"'Captured Millages'!A91","v":"ISD Allocated (Local tax for BRFAs, School tax for all others)"},null,{"$f":"'Captured Millages'!I91","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C91/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C91/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C91/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C91/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C91/1000","v":0},null,{"$f":"MAX(0,SUM(E91:N91))","v":0}]
[]
[{"$f":"'Captured Millages'!A93","v":"ISD Special Education (Local tax for BRFAs, School tax for all others)"},null,{"$f":"'Captured Millages'!I93","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C93/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C93/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C93/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C93/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C93/1000","v":0},null,{"$f":"MAX(0,SUM(E93:N93))","v":0}]
[]
[{"$f":"'Captured Millages'!A95","v":"ISD Vocational Education (Local tax for BRFAs, School tax for all others)"},null,{"$f":"'Captured Millages'!I95","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C95/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C95/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C95/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C95/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C95/1000","v":0},null,{"$f":"MAX(0,SUM(E95:N95))","v":0}]
[]
[{"$f":"'Captured Millages'!A97","v":"ISD Enhancement (Local tax for BRFAs, School tax for all others)"},null,{"$f":"'Captured Millages'!I97","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C97/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C97/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C97/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C97/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C97/1000","v":0},null,{"$f":"MAX(0,SUM(E97:N97))","v":0}]
[]
[{"$f":"'Captured Millages'!A99","v":"ISD debt (Local tax for BRFAs, School tax for all others)"},null,{"$f":"'Captured Millages'!I99","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C99/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C99/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C99/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C99/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C99/1000","v":0},null,{"$f":"MAX(0,SUM(E99:N99))","v":0}]
[]
[{"$f":"'Captured Millages'!A101","v":"Special authorities - type in purpose"},null,{"$f":"'Captured Millages'!I101","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C101/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C101/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C101/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C101/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C101/1000","v":0},null,{"$f":"MAX(0,SUM(E101:N101))","v":0}]
[]
[{"$f":"'Captured Millages'!A103","v":"Special authorities - type in purpose"},null,{"$f":"'Captured Millages'!I103","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C103/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C103/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C103/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C103/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C103/1000","v":0},null,{"$f":"MAX(0,SUM(E103:N103))","v":0}]
[]
[{"$f":"'Captured Millages'!A105","v":"Special authorities - type in purpose"},null,{"$f":"'Captured Millages'!I105","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C105/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C105/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C105/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C105/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C105/1000","v":0},null,{"$f":"MAX(0,SUM(E105:N105))","v":0}]
[]
[{"$f":"'Captured Millages'!A107","v":"Special authorities - type in purpose"},null,{"$f":"'Captured Millages'!I107","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C107/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C107/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C107/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C107/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C107/1000","v":0},null,{"$f":"MAX(0,SUM(E107:N107))","v":0}]
[]
[{"$f":"'Captured Millages'!A109","v":"Special authorities - type in purpose"},null,{"$f":"'Captured Millages'!I109","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C109/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C109/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C109/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C109/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C109/1000","v":0},null,{"$f":"MAX(0,SUM(E109:N109))","v":0}]
[]
[{"$f":"'Captured Millages'!A111","v":"Special authorities - type in purpose"},null,{"$f":"'Captured Millages'!I111","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C111/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C111/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C111/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C111/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C111/1000","v":0},null,{"$f":"MAX(0,SUM(E111:N111))","v":0}]
[]
[{"$f":"'Captured Millages'!A113","v":"Special authorities - type in purpose"},null,{"$f":"'Captured Millages'!I113","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C113/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C113/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C113/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C113/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C113/1000","v":0},null,{"$f":"MAX(0,SUM(E113:N113))","v":0}]
[]
[{"$f":"'Captured Millages'!A115","v":"Special authorities - type in purpose"},null,{"$f":"'Captured Millages'!I115","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$9*'Losses by millage'!C115/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$11*'Losses by millage'!C115/1000","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$14*'Losses by millage'!C115/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$17*'Losses by millage'!C115/1000*0.5","v":0},null,{"$f":"'TIF small parcel exemption loss'!$M$20*'Losses by millage'!C115/1000","v":0},null,{"$f":"MAX(0,SUM(E115:N115))","v":0}]
[]
[]
["TOTAL TIF REVENUE LOST TO MCL SMALL PARCEL EXEMPTIONS",null,null,null,{"$f":"SUM(E7:E115)","v":0},null,{"$f":"SUM(G7:G115)","v":0},null,{"$f":"SUM(I7:I115)","v":0},null,{"$f":"SUM(K7:K115)","v":0},null,{"$f":"SUM(M7:M115)","v":0},null,{"$f":"MAX(0,SUM(E118:N118))","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O7:O115)","v":0}]
[{"$f":"CONCATENATE(\"Municipality:   \",IF('TIFA Identity'!H8=\"\",\"\",'TIFA Identity'!H8))","v":"Municipality:   "}]
[]
[{"$f":"CONCATENATE(\"School District:   \",IF('TIFA Identity'!H10=\"\",\"\",'TIFA Identity'!H10))","v":"School District:   "}]
[]
[{"$f":"CONCATENATE(\"Authority Type:   \",IF('TIFA Identity'!H12=\"\",\"\",'TIFA Identity'!H12))","v":"Authority Type:   Brownfield Redevelopment Finance Authority"}]
[]
[{"$f":"CONCATENATE(\"Authority Name:   \",IF('TIFA Identity'!H14=\"\",\"\",'TIFA Identity'!H14))","v":"Authority Name:   "}]