{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["CEFW Tax Assessed","Projects"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":3,"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":"CEFW Tax Assessed","index":0,"n_rows":44,"n_cols":26,"rows_kept":44,"cut":false,"hidden":false,"merged":[[3,2,3,29],[10,28,10,29],[5,5,5,15],[6,5,6,15],[5,16,5,26],[6,16,6,26],[9,25,9,27],[9,20,9,22],[9,4,9,6],[9,8,9,10],[10,4,10,6],[10,20,10,22],[10,8,10,10],[4,7,4,24],[8,4,8,6],[8,7,8,27],[43,2,43,4],[14,8,14,10],[18,4,18,6],[18,8,18,10],[18,20,18,22],[14,4,14,6],[16,4,16,6],[16,8,16,10],[16,20,16,22],[39,3,39,28],[41,3,41,21],[41,25,41,27],[31,25,31,27],[31,20,31,22],[34,20,34,22],[34,25,34,27],[20,4,20,6],[20,8,20,10],[20,20,20,22],[20,25,20,27],[10,25,10,27],[12,20,12,22],[14,20,14,22],[18,25,18,27],[12,4,12,6],[12,25,12,27],[14,25,14,27],[16,25,16,27],[12,8,12,10],[30,20,30,22],[30,16,30,18],[26,4,26,6],[26,8,26,10],[26,20,26,22],[28,4,28,6],[28,8,28,10],[28,20,28,22],[28,25,28,27],[26,25,26,27],[24,20,24,22],[24,25,24,27],[22,4,22,6],[22,8,22,10],[22,20,22,22],[22,25,22,27],[24,4,24,6],[24,8,24,10]]}
[]
[]
[]
[null,null,"STATE OF MINNESOTA CONSERVATION EASEMENT"]
[null,null,null,null,null,null,null,"Conservation Easement Financial Worksheet (CEFW) Tax Assessed Calculation"]
[null,null,null,null,null,"Landowner Name:",null,null,null,null,null,null,null,null,null,null,"County/SWCD Office:"]
[]
[]
[null,null,null,null,"Easement Type"]
[null,null,null,null,"Assessor's Land Value",null,null,null,"Assessor's Acres (nearest hundredth)",null,null,null,"Per Acre Value",null,null,null,"Per Acre Value (60%)",null,null,null,"Easement Acres (nearest tenth)*",null,null,null,null,"Easement Payment*"]
[null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E11),\"\",IF(ISBLANK(I11),\"\",ROUND(E11/I11,2)))","v":""},null,"X 60% =",null,{"$f":"IF(M11=\"\",\"\",ROUND(M11*0.6,2))","v":""},null,"X",null,null,null,null,null,"=",{"$f":"IF(Q11=\"\",\"\",IF(U11=\"\",\"\",ROUND(Q11*U11,2)))","v":""}]
[]
[null,null,null,2,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E13),\"\",IF(ISBLANK(I13),\"\",ROUND(E13/I13,2)))","v":""},null,"X 60% =",null,{"$f":"IF(M13=\"\",\"\",ROUND(M13*0.6,2))","v":""},null,"X",null,null,null,null,null,"=",{"$f":"IF(Q13=\"\",\"\",IF(U13=\"\",\"\",ROUND(Q13*U13,2)))","v":""}]
[]
[null,null,null,3,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E15),\"\",IF(ISBLANK(I15),\"\",ROUND(E15/I15,2)))","v":""},null,"X 60% =",null,{"$f":"IF(M15=\"\",\"\",ROUND(M15*0.6,2))","v":""},null,"X",null,null,null,null,null,"=",{"$f":"IF(Q15=\"\",\"\",IF(U15=\"\",\"\",ROUND(Q15*U15,2)))","v":""}]
[]
[null,null,null,4,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E17),\"\",IF(ISBLANK(I17),\"\",ROUND(E17/I17,2)))","v":""},null,"X 60% =",null,{"$f":"IF(M17=\"\",\"\",ROUND(M17*0.6,2))","v":""},null,"X",null,null,null,null,null,"=",{"$f":"IF(Q17=\"\",\"\",IF(U17=\"\",\"\",ROUND(Q17*U17,2)))","v":""}]
[]
[null,null,null,5,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E19),\"\",IF(ISBLANK(I19),\"\",ROUND(E19/I19,2)))","v":""},null,"X 60% =",null,{"$f":"IF(M19=\"\",\"\",ROUND(M19*0.6,2))","v":""},null,"X",null,null,null,null,null,"=",{"$f":"IF(Q19=\"\",\"\",IF(U19=\"\",\"\",ROUND(Q19*U19,2)))","v":""}]
[]
[null,null,null,6,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E21),\"\",IF(ISBLANK(I21),\"\",ROUND(E21/I21,2)))","v":""},null,"X 60% =",null,{"$f":"IF(M21=\"\",\"\",ROUND(M21*0.6,2))","v":""},null,"X",null,null,null,null,null,"=",{"$f":"IF(Q21=\"\",\"\",IF(U21=\"\",\"\",ROUND(Q21*U21,2)))","v":""}]
[]
[null,null,null,7,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E23),\"\",IF(ISBLANK(I23),\"\",ROUND(E23/I23,2)))","v":""},null,"X 60% =",null,{"$f":"IF(M23=\"\",\"\",ROUND(M23*0.6,2))","v":""},null,"X",null,null,null,null,null,"=",{"$f":"IF(Q23=\"\",\"\",IF(U23=\"\",\"\",ROUND(Q23*U23,2)))","v":""}]
[]
[null,null,null,8,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E25),\"\",IF(ISBLANK(I25),\"\",ROUND(E25/I25,2)))","v":""},null,"X 60% =",null,{"$f":"IF(M25=\"\",\"\",ROUND(M25*0.6,2))","v":""},null,"X",null,null,null,null,null,"=",{"$f":"IF(Q25=\"\",\"\",IF(U25=\"\",\"\",ROUND(Q25*U25,2)))","v":""}]
[]
[null,null,null,9,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E27),\"\",IF(ISBLANK(I27),\"\",ROUND(E27/I27,2)))","v":""},null,"X 60% =",null,{"$f":"IF(M27=\"\",\"\",ROUND(M27*0.6,2))","v":""},null,"X",null,null,null,null,null,"=",{"$f":"IF(Q27=\"\",\"\",IF(U27=\"\",\"\",ROUND(Q27*U27,2)))","v":""}]
[]
[null,null,null,10,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E29),\"\",IF(ISBLANK(I29),\"\",ROUND(E29/I29,2)))","v":""},null,"X 60% =",null,{"$f":"IF(M29=\"\",\"\",ROUND(M29*0.6,2))","v":""},null,"X",null,null,null,null,null,"=",{"$f":"IF(Q29=\"\",\"\",IF(U29=\"\",\"\",ROUND(Q29*U29,2)))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Donated Acres ="]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL EASEMENT ACRES*",null,null,null,null,"TOTAL EASEMENT PAYMENT*"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U11,U13,U15,U17,U19,U21,U23,U25,U27,U29,U31)","v":0},null,null,null,null,{"$f":"SUM(Z11,Z13,Z15,Z17,Z19,Z21,Z23,Z25,Z27,Z29)","v":0}]
[]
[]
[]
[null,null,null,null,"SWCD/LGU Acknowledgement"]
[null,null,null,"I attest that to the best of my knowledge, the information on this form is accurate, that it has been reviewed and discussed with the landowner, and that the landowner understands and acknowledges the financial obligations herein represented."]
[]
[null,null,null,"SWCD/LGU Signature",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
[]
[null,null,"2020-01-08"]

{"sheet":"Projects","index":1,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["Easement Type","Minnesota Laws","Appropriation_id"]
["Critical Shorelands: Crow Wing River Watershed Becker County (CWF)","M.L. 2017","CT17"]
["Critical Shorelands: Pine River Watershed Cass and Crow Wing counties (CWF)","M.L. 2015","CT15"]
["Critical Shorelands: Rum River Watershed (CWF)","M.L. 2019","CTS9"]
["Mississippi Headwaters Habitat Corridor (OHF)","multiple","L__H"]
["Protecting North-Central Minnesota Lakes: Aitkin and Pine counties (ENRTF)","M.L. 2018","CRWG"]
["Wild Rice Shoreland Protection (OHF)","multiple","L__W"]