{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Data Entry","Set_up","Tax Rates","Waiver","Agreement","Withdrawal"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":14,"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":"Data Entry","index":0,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,5],[6,1,6,2],[6,4,6,5],[7,1,7,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[7,4,7,5],[8,4,8,5],[9,4,9,5],[10,4,10,5]]}
["Agreement for Settlement Worksheet"]
["Property Owner:",null,null,"Fiscal Year:"]
["Property Location:",null,null,"Docket #"]
["Parcel ID:",null,null,"Date:"]
["Telephone #:"]
[]
[null,"OWNER",null,null,"ATTORNEY / AGENT"]
["Name:"]
["Street Address:"]
[]
["City, ST, ZIP:"]
[]
[null,null,null,"Tax Rate","Value ABATED","Tax ABATED"]
["Res EX (y/n):",null,null,{"$f":"VLOOKUP(YEAR,RATE_SCHD,3)","v":{"$error":"#N/A"}}]
["Residential Value:",null,null,{"$f":"VLOOKUP(YEAR,RATE_SCHD,2)","v":{"$error":"#N/A"}},{"$f":"IF((B15+C15)>0,B15-C15,0)","v":0},{"$f":"IF(E15<>0,ROUND(E15*D15/1000,2),0)","v":0}]
["Commercial Value:",null,null,{"$f":"VLOOKUP(YEAR,RATE_SCHD,4)","v":{"$error":"#N/A"}},{"$f":"IF((B16+C16)>0,B16-C16,0)","v":0},{"$f":"IF(E16<>0,ROUND(E16*D16/1000,2),0)","v":0}]
["Res Exemption:",{"$f":"IF(B14=\"y\",-ROUND(MIN($D14,B15*0.9),0),0)","v":0},{"$f":"IF(C14=\"y\",-ROUND(MIN($D14,C15*0.9),0),0)","v":0},{"$f":"VLOOKUP(YEAR,RATE_SCHD,2)","v":{"$error":"#N/A"}},{"$f":"IF(B17<>C17,B17-C17,0)","v":0},{"$f":"IF(E17<>0,ROUND(E17*D17/1000,2),0)","v":0}]
["Taxable Value:",{"$f":"SUM(B15:B17)","v":0},{"$f":"SUM(C15:C17)","v":0},null,{"$f":"ROUND(+B19-C19,2)","v":{"$error":"#N/A"}},{"$f":"ROUND(SUM(F15:F17),2)","v":0}]
["Total Taxes:",{"$f":"ROUND(B15*$D15/1000,2)+ROUND(B16*$D16/1000,2)+ROUND(B17*$D17/1000,2)","v":{"$error":"#N/A"}},{"$f":"ROUND(C15*$D15/1000,2)+ROUND(C16*$D16/1000,2)+ROUND(C17*$D17/1000,2)","v":{"$error":"#N/A"}},null,{"$f":"SUM(E15:E17)","v":0},{"$f":"SUM(F15:F17)","v":0}]

{"sheet":"Set_up","index":1,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Jurisdiction","Auburn"]
["Type","Town"]
["Address1","Board of Assessors"]
["Address2","104 Central ST"]
["Address3"]
["City","Auburn"]
["State","MA"]
["ZIP","01501"]

{"sheet":"Tax Rates","index":2,"n_rows":48,"n_cols":5,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
[]
["FY","RO","Res-Ex-Amt","CIP","Res-Ex-Tax"]
[1982]
[1983]
[1984]
[1985]
[1986]
[1987]
[1988]
[1989]
[1990]
[1991]
[1992]
[1993]
[1994]
[1995]
[1996]
[1997]
[1998]
[1999]
[2000]
[2001]
[2002]
[2003]
[2004]
[2005]
[2006]
[2007]
[2008]
[2009]
[2010]
[2011]
[2012]
[2013]
[2014]
[2015]
[2016,null,null,null,{"$f":"B37*C37/1000","v":0}]
[2017,null,null,null,0]
[2018,null,null,null,0]
[2019,null,null,null,0]
[2020,null,null,null,0]
[2021,null,null,null,0]
[2022,null,null,null,0]
[2023,null,null,null,0]
[2024,null,null,null,0]
[2025,null,null,null,0]
[2026,null,null,null,0]
[2027,null,null,null,0]

{"sheet":"Waiver","index":3,"n_rows":44,"n_cols":6,"rows_kept":44,"cut":false,"hidden":false,"merged":[[6,0,6,5],[0,0,0,5],[1,0,1,5],[2,0,2,5],[3,0,3,5],[43,0,43,5],[10,1,10,5],[11,1,11,5],[12,1,12,5],[13,1,13,5],[17,0,17,5],[18,0,18,5],[20,0,20,5],[24,0,24,5],[42,0,42,5]]}
[{"$f":"UPPER(Type)&\" of \"&UPPER(Jurisdiction)","v":"TOWN of AUBURN"}]
[{"$f":"Address1","v":"Board of Assessors"}]
[{"$f":"IF(LEN(Address2)>0,PROPER(Address2),\"\")","v":"104 Central St"}]
[{"$f":"IF(LEN(Address3)>0,PROPER(Address3),PROPER(City)&\", \"&UPPER(State)&\" \"&ZIP)","v":"Auburn, MA 01501"}]
[{"$f":"IF(LEN(Address3)>0,City&\" ,\"&State&\" \"&ZIP,\"\")","v":""}]
[null,null,null,null,null,{"$f":"'Data Entry'!E4","v":"00:00:00"}]
["AGREEMENT for SETTLEMENT"]
["Owner:",{"$f":"'Data Entry'!B2","v":0}]
["Property Location:",{"$f":"'Data Entry'!B3","v":0},null,null,null,{"$f":"'Data Entry'!B4","v":0}]
[]
["Mail Address:",{"$f":"IF(ISTEXT('Data Entry'!E8)=TRUE,'Data Entry'!E8,IF(ISTEXT('Data Entry'!B8)=TRUE,'Data Entry'!B8,\"\"))","v":""}]
[null,{"$f":"IF(ISTEXT('Data Entry'!E9)=TRUE,'Data Entry'!E9,IF(ISTEXT('Data Entry'!B9)=TRUE,'Data Entry'!B9,\"\"))","v":""}]
[null,{"$f":"IF(ISTEXT('Data Entry'!E10)=TRUE,'Data Entry'!E10,IF(ISTEXT('Data Entry'!B10)=TRUE,'Data Entry'!B10,\"\"))","v":""}]
[null,{"$f":"IF(ISTEXT('Data Entry'!E11)=TRUE,'Data Entry'!E11,IF(ISTEXT('Data Entry'!B11)=TRUE,'Data Entry'!B11,\"\"))","v":""}]
[]
[]
[]
["In consideration of the terms for an abatement set forth below, the right to appeal to the"]
["Appellate Tax Board and/or County Board of Commissioners is hereby waived."]
[]
[{"$f":"\"This agreement is made between the applicant and the \"&PROPER(Jurisdiction)&\" Assessors as final settlement for FISCAL YEAR \"&TEXT(YEAR,0)","v":"This agreement is made between the applicant and the Auburn Assessors as final settlement for FISCAL YEAR 0"}]
[]
[]
[]
["TERMS"]
[]
[null,"Current",null,"Proposed",null,"Sum"]
[null,"Assessed Value",null,"Assessed Value",null,"Abated"]
["Residential:",{"$f":"'Data Entry'!B15","v":0}," ",{"$f":"'Data Entry'!C15","v":0},"=",{"$f":"B29-D29","v":0}]
["Commercial:",{"$f":"'Data Entry'!B16","v":0},"-",{"$f":"'Data Entry'!C16","v":0},"=",{"$f":"B30-D30","v":0}]
[null,{"$f":"'Data Entry'!B17","v":0},"-",{"$f":"'Data Entry'!C17","v":0},"=",{"$f":"B31-D31","v":0}]
["Taxable Value:",{"$f":"SUM(B29:B31)","v":0},"-",{"$f":"SUM(D29:D31)","v":0},"=",{"$f":"B32-D32","v":0}]
["Taxes:",{"$f":"'Data Entry'!B19","v":{"$error":"#N/A"}},"-",{"$f":"'Data Entry'!C19","v":{"$error":"#N/A"}},"=",{"$f":"B33-D33","v":{"$error":"#N/A"}}]
[]
[]
[]
[null,"Signature of Applicant",null,null,null,"Date"]
[]
[]
[]
[null,"Signature of Assessor",null,null,null,"Date"]
[]
["Please sign and return this document to the Board of Assessors within"]
["10 days. Your abatement will be processed upon receipt."]

{"sheet":"Agreement","index":4,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[[45,0,45,5],[46,0,46,5],[6,0,6,5],[20,0,20,5],[23,0,23,5],[27,0,27,5],[0,0,0,5],[1,0,1,5],[2,0,2,5],[3,0,3,5],[19,0,19,5],[10,1,10,5],[11,1,11,5],[12,1,12,5],[13,1,13,5],[17,0,17,5],[18,0,18,5]]}
[{"$f":"UPPER(Type)&\" of \"&UPPER(Jurisdiction)","v":"TOWN of AUBURN"}]
[{"$f":"Address1","v":"Board of Assessors"}]
[{"$f":"IF(LEN(Address2)>0,PROPER(Address2),\"\")","v":"104 Central St"}]
[{"$f":"IF(LEN(Address3)>0,PROPER(Address3),PROPER(City)&\", \"&UPPER(State)&\" \"&ZIP)","v":"Auburn, MA 01501"}]
[{"$f":"IF(LEN(Address3)>0,City&\" ,\"&State&\" \"&ZIP,\"\")","v":""}]
[null,null,null,null,null,{"$f":"'Data Entry'!E4","v":"00:00:00"}]
["AGREEMENT for SETTLEMENT"]
["Owner:",{"$f":"'Data Entry'!B2","v":0}]
["Property Location:",{"$f":"'Data Entry'!B3","v":0},null,null,null,{"$f":"'Data Entry'!B4","v":0}]
[]
["Mail Address:",{"$f":"IF(ISTEXT('Data Entry'!E8)=TRUE,'Data Entry'!E8,IF(ISTEXT('Data Entry'!B8)=TRUE,'Data Entry'!B8,\"\"))","v":""}]
[null,{"$f":"IF(ISTEXT('Data Entry'!E9)=TRUE,'Data Entry'!E9,IF(ISTEXT('Data Entry'!B9)=TRUE,'Data Entry'!B9,\"\"))","v":""}]
[null,{"$f":"IF(ISTEXT('Data Entry'!E10)=TRUE,'Data Entry'!E10,IF(ISTEXT('Data Entry'!B10)=TRUE,'Data Entry'!B10,\"\"))","v":""}]
[null,{"$f":"IF(ISTEXT('Data Entry'!E11)=TRUE,'Data Entry'!E11,IF(ISTEXT('Data Entry'!B11)=TRUE,'Data Entry'!B11,\"\"))","v":""}]
[]
[]
[]
[{"$f":"\"In consideration of the terms for an abatement set forth below, the \"&PROPER(Jurisdiction)&\" Board of\"","v":"In consideration of the terms for an abatement set forth below, the Auburn Board of"}]
["Assessors acknowledges your intent to withdraw an appeal pending before the Appllate"]
[{"$f":"\"Tax Board referred to as DOCKET NUMBER ..…\"&UPPER('Data Entry'!E3)","v":"Tax Board referred to as DOCKET NUMBER ..…"}]
[]
[]
[]
[{"$f":"\"This agreement is made between the applicant and the \"&PROPER(Jurisdiction)&\" Assessors as final settlement for FISCAL YEAR \"&TEXT(YEAR,0)","v":"This agreement is made between the applicant and the Auburn Assessors as final settlement for FISCAL YEAR 0"}]
[]
[]
[]
["TERMS"]
[]
[null,"Current",null,"Proposed",null,"Sum"]
[null,"Assessed Value",null,"Assessed Value",null,"Abated"]
["Residential:",{"$f":"'Data Entry'!B15","v":0}," ",{"$f":"'Data Entry'!C15","v":0},"=",{"$f":"B32-D32","v":0}]
["Commercial:",{"$f":"'Data Entry'!B16","v":0},"-",{"$f":"'Data Entry'!C16","v":0},"=",{"$f":"B33-D33","v":0}]
[null,{"$f":"'Data Entry'!B17","v":0},"-",{"$f":"'Data Entry'!C17","v":0},"=",{"$f":"B34-D34","v":0}]
["Taxable Value:",{"$f":"SUM(B32:B34)","v":0},"-",{"$f":"SUM(D32:D34)","v":0},"=",{"$f":"B35-D35","v":0}]
["Taxes:",{"$f":"'Data Entry'!B19","v":{"$error":"#N/A"}},"-",{"$f":"'Data Entry'!C19","v":{"$error":"#N/A"}},"=",{"$f":"B36-D36","v":{"$error":"#N/A"}}]
[]
[]
[null,"Signature of Applicant",null,null,null,"Date"]
[]
[]
[]
[]
[null,"Signature of Assessor",null,null,null,"Date"]
[]
["Please sign and return this document to the Board of Assessors within"]
["10 days. Your abatement will be processed upon receipt."]

{"sheet":"Withdrawal","index":5,"n_rows":39,"n_cols":6,"rows_kept":39,"cut":false,"hidden":false,"merged":[[41,0,41,5],[0,0,0,5],[3,0,3,5],[8,0,8,3],[15,0,15,4],[18,3,18,4],[19,3,19,4],[24,0,24,5],[32,0,32,5]]}
["The Commonwealth of Massachusetts"]
[]
[]
["APPELLATE TAX BOARD"]
[]
[]
[]
[]
["Docket Number:",null,null,null,null,{"$f":"UPPER(Docket)","v":""}]
[null,null,null,null,null,{"$f":"\"FY \"&YEAR","v":"FY "}]
[]
[]
[{"$f":"UPPER('Data Entry'!B2)","v":""},null,null,null,null,"(Appellant)"]
[]
[]
[{"$f":"\"BOARD of ASSESSORS of THE \"&UPPER(Type)&\" of \"&UPPER(Jurisdiction)","v":"BOARD of ASSESSORS of THE TOWN of AUBURN"},null,null,null,null,"(Appellee)"]
[]
[]
["Location of Property:",null,null,{"$f":"PROPER('Data Entry'!B3)","v":""}]
[null,null,null,{"$f":"PROPER('Data Entry'!B4)","v":""}]
[]
[]
[]
[]
["WITHDRAWAL"]
[]
[]
[]
[]
[]
[]
[]
["The above action is hereby withdrawn"]
[]
["Appellant"]
[null,{"$f":"PROPER(IF(ISTEXT('Data Entry'!E8)=TRUE,'Data Entry'!E8,'Data Entry'!B8))","v":""}]
["Address",{"$f":"PROPER(IF(ISTEXT('Data Entry'!E9)=TRUE,'Data Entry'!E9,'Data Entry'!B9))","v":""}]
[null,{"$f":"PROPER(IF(ISTEXT('Data Entry'!E11)=TRUE,'Data Entry'!E11,'Data Entry'!B11))","v":""}]
["Telephone",{"$f":"IF(ISTEXT('Data Entry'!B5)=TRUE,'Data Entry'!B5,\"\")","v":""}]