{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["CEFW Tax Assessed","Programs","SWCD"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":3,"comments":1,"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":45,"n_cols":26,"rows_kept":45,"cut":false,"hidden":false,"merged":[[3,2,3,29],[11,28,11,29],[5,5,5,15],[6,5,6,15],[5,16,5,26],[6,16,6,26],[10,25,10,27],[10,20,10,22],[10,4,10,6],[10,8,10,10],[11,4,11,6],[11,20,11,22],[11,8,11,10],[4,7,4,24],[8,4,8,6],[8,7,8,27],[44,2,44,4],[15,8,15,10],[19,4,19,6],[19,8,19,10],[19,20,19,22],[15,4,15,6],[17,4,17,6],[17,8,17,10],[17,20,17,22],[40,3,40,28],[42,3,42,21],[42,25,42,27],[32,25,32,27],[32,20,32,22],[35,20,35,22],[35,25,35,27],[13,20,13,22],[15,20,15,22],[19,25,19,27],[13,4,13,6],[13,25,13,27],[15,25,15,27],[17,25,17,27],[13,8,13,10],[31,20,31,22],[31,16,31,18],[27,4,27,6],[27,8,27,10],[27,20,27,22],[29,4,29,6],[29,8,29,10],[29,20,29,22],[9,4,9,27],[29,25,29,27],[27,25,27,27],[25,20,25,22],[25,25,25,27],[23,4,23,6],[23,8,23,10],[23,20,23,22],[23,25,23,27],[25,4,25,6],[25,8,25,10],[21,4,21,6],[21,8,21,10],[21,20,21,22],[21,25,21,27],[11,25,11,27]]}
[]
[]
[]
[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,"*Select Easement Type before entering values and acres below"]
[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,{"$f":"IF(H9=\"RIM Grazing\",\"Per Acre Value (50%)\",\nIF(H9=\"RIM Drinking Water DWSMA (Limited)\",\"Per Acre Value (75%)\",\nIF(H9=\"RIM Drinking Water DWSMA (Perpetual)\",\"Per Acre Value (120%)\",\nIF(H9=\"RIM Drinking Water (Perpetual)\",\"Per Acre Value (90%)\",\n\"Per Acre Value (60%)\"))))","v":"Per Acre Value (60%)"},null,null,null,"Easement Acres (nearest tenth)*",null,null,null,null,"Easement Payment*"]
[null,null,null,1,null,null,null,10,null,null,null,null,{"$f":"IF(ISBLANK(E12),\"\",IF(ISBLANK(I12),\"\",ROUND(E12/I12,2)))","v":""},null,{"$f":"IF($H$9=\"RIM Grazing\",\"X 50% =\",\nIF($H$9=\"RIM Drinking Water DWSMA (Limited)\",\"X 75% =\",\nIF($H$9=\"RIM Drinking Water DWSMA (Perpetual)\",\"X 120% =\",\nIF($H$9=\"RIM Drinking Water (Perpetual)\",\"X 90% =\",\n(\"X 60% =\")))))","v":"X 60% ="},null,{"$f":"IF(M12=\"\",\"\",\nIF($H$9=\"\",\"\",\nIF($H$9=\"RIM Grazing\",ROUND(M12*0.5,2),\nIF($H$9=\"RIM Drinking Water DWSMA (Limited)\",ROUND(M12*0.75,2),\nIF($H$9=\"RIM Drinking Water DWSMA (Perpetual)\",ROUND(M12*1.2,2),\nIF($H$9=\"RIM Drinking Water (Perpetual)\",ROUND(M12*0.9,2),\nROUND(M12*0.6,2)))))))","v":""},null,"X",null,null,null,null,null,"=",{"$f":"IF(Q12=\"\",\"\",IF(U12=\"\",\"\",ROUND(Q12*U12,2)))","v":""}]
[]
[null,null,null,2,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E14),\"\",IF(ISBLANK(I14),\"\",ROUND(E14/I14,2)))","v":""},null,{"$f":"IF($H$9=\"RIM Grazing\",\"X 50% =\",\nIF($H$9=\"RIM Drinking Water DWSMA (Limited)\",\"X 75% =\",\nIF($H$9=\"RIM Drinking Water DWSMA (Perpetual)\",\"X 120% =\",\nIF($H$9=\"RIM Drinking Water (Perpetual)\",\"X 90% =\",\n(\"X 60% =\")))))","v":"X 60% ="},null,{"$f":"IF(M14=\"\",\"\",\nIF($H$9=\"\",\"\",\nIF($H$9=\"RIM Grazing\",ROUND(M14*0.5,2),\nIF($H$9=\"RIM Drinking Water DWSMA (Limited)\",ROUND(M14*0.75,2),\nIF($H$9=\"RIM Drinking Water DWSMA (Perpetual)\",ROUND(M14*1.2,2),\nIF($H$9=\"RIM Drinking Water (Perpetual)\",ROUND(M14*0.9,2),\nROUND(M14*0.6,2)))))))","v":""},null,"X",null,null,null,null,null,"=",{"$f":"IF(Q14=\"\",\"\",IF(U14=\"\",\"\",ROUND(Q14*U14,2)))","v":""}]
[]
[null,null,null,3,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E16),\"\",IF(ISBLANK(I16),\"\",ROUND(E16/I16,2)))","v":""},null,{"$f":"IF($H$9=\"RIM Grazing\",\"X 50% =\",\nIF($H$9=\"RIM Drinking Water DWSMA (Limited)\",\"X 75% =\",\nIF($H$9=\"RIM Drinking Water DWSMA (Perpetual)\",\"X 120% =\",\nIF($H$9=\"RIM Drinking Water (Perpetual)\",\"X 90% =\",\n(\"X 60% =\")))))","v":"X 60% ="},null,{"$f":"IF(M16=\"\",\"\",\nIF($H$9=\"\",\"\",\nIF($H$9=\"RIM Grazing\",ROUND(M16*0.5,2),\nIF($H$9=\"RIM Drinking Water DWSMA (Limited)\",ROUND(M16*0.75,2),\nIF($H$9=\"RIM Drinking Water DWSMA (Perpetual)\",ROUND(M16*1.2,2),\nIF($H$9=\"RIM Drinking Water (Perpetual)\",ROUND(M16*0.9,2),\nROUND(M16*0.6,2)))))))","v":""},null,"X",null,null,null,null,null,"=",{"$f":"IF(Q16=\"\",\"\",IF(U16=\"\",\"\",ROUND(Q16*U16,2)))","v":""}]
[]
[null,null,null,4,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E18),\"\",IF(ISBLANK(I18),\"\",ROUND(E18/I18,2)))","v":""},null,{"$f":"IF($H$9=\"RIM Grazing\",\"X 50% =\",\nIF($H$9=\"RIM Drinking Water DWSMA (Limited)\",\"X 75% =\",\nIF($H$9=\"RIM Drinking Water DWSMA (Perpetual)\",\"X 120% =\",\nIF($H$9=\"RIM Drinking Water (Perpetual)\",\"X 90% =\",\n(\"X 60% =\")))))","v":"X 60% ="},null,{"$f":"IF(M18=\"\",\"\",\nIF($H$9=\"\",\"\",\nIF($H$9=\"RIM Grazing\",ROUND(M18*0.5,2),\nIF($H$9=\"RIM Drinking Water DWSMA (Limited)\",ROUND(M18*0.75,2),\nIF($H$9=\"RIM Drinking Water DWSMA (Perpetual)\",ROUND(M18*1.2,2),\nIF($H$9=\"RIM Drinking Water (Perpetual)\",ROUND(M18*0.9,2),\nROUND(M18*0.6,2)))))))","v":""},null,"X",null,null,null,null,null,"=",{"$f":"IF(Q18=\"\",\"\",IF(U18=\"\",\"\",ROUND(Q18*U18,2)))","v":""}]
[]
[null,null,null,5,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E20),\"\",IF(ISBLANK(I20),\"\",ROUND(E20/I20,2)))","v":""},null,{"$f":"IF($H$9=\"RIM Grazing\",\"X 50% =\",\nIF($H$9=\"RIM Drinking Water DWSMA (Limited)\",\"X 75% =\",\nIF($H$9=\"RIM Drinking Water DWSMA (Perpetual)\",\"X 120% =\",\nIF($H$9=\"RIM Drinking Water (Perpetual)\",\"X 90% =\",\n(\"X 60% =\")))))","v":"X 60% ="},null,{"$f":"IF(M20=\"\",\"\",\nIF($H$9=\"\",\"\",\nIF($H$9=\"RIM Grazing\",ROUND(M20*0.5,2),\nIF($H$9=\"RIM Drinking Water DWSMA (Limited)\",ROUND(M20*0.75,2),\nIF($H$9=\"RIM Drinking Water DWSMA (Perpetual)\",ROUND(M20*1.2,2),\nIF($H$9=\"RIM Drinking Water (Perpetual)\",ROUND(M20*0.9,2),\nROUND(M20*0.6,2)))))))","v":""},null,"X",null,null,null,null,null,"=",{"$f":"IF(Q20=\"\",\"\",IF(U20=\"\",\"\",ROUND(Q20*U20,2)))","v":""}]
[]
[null,null,null,6,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E22),\"\",IF(ISBLANK(I22),\"\",ROUND(E22/I22,2)))","v":""},null,{"$f":"IF($H$9=\"RIM Grazing\",\"X 50% =\",\nIF($H$9=\"RIM Drinking Water DWSMA (Limited)\",\"X 75% =\",\nIF($H$9=\"RIM Drinking Water DWSMA (Perpetual)\",\"X 120% =\",\nIF($H$9=\"RIM Drinking Water (Perpetual)\",\"X 90% =\",\n(\"X 60% =\")))))","v":"X 60% ="},null,{"$f":"IF(M22=\"\",\"\",\nIF($H$9=\"\",\"\",\nIF($H$9=\"RIM Grazing\",ROUND(M22*0.5,2),\nIF($H$9=\"RIM Drinking Water DWSMA (Limited)\",ROUND(M22*0.75,2),\nIF($H$9=\"RIM Drinking Water DWSMA (Perpetual)\",ROUND(M22*1.2,2),\nIF($H$9=\"RIM Drinking Water (Perpetual)\",ROUND(M22*0.9,2),\nROUND(M22*0.6,2)))))))","v":""},null,"X",null,null,null,null,null,"=",{"$f":"IF(Q22=\"\",\"\",IF(U22=\"\",\"\",ROUND(Q22*U22,2)))","v":""}]
[]
[null,null,null,7,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E24),\"\",IF(ISBLANK(I24),\"\",ROUND(E24/I24,2)))","v":""},null,{"$f":"IF($H$9=\"RIM Grazing\",\"X 50% =\",\nIF($H$9=\"RIM Drinking Water DWSMA (Limited)\",\"X 75% =\",\nIF($H$9=\"RIM Drinking Water DWSMA (Perpetual)\",\"X 120% =\",\nIF($H$9=\"RIM Drinking Water (Perpetual)\",\"X 90% =\",\n(\"X 60% =\")))))","v":"X 60% ="},null,{"$f":"IF(M24=\"\",\"\",\nIF($H$9=\"\",\"\",\nIF($H$9=\"RIM Grazing\",ROUND(M24*0.5,2),\nIF($H$9=\"RIM Drinking Water DWSMA (Limited)\",ROUND(M24*0.75,2),\nIF($H$9=\"RIM Drinking Water DWSMA (Perpetual)\",ROUND(M24*1.2,2),\nIF($H$9=\"RIM Drinking Water (Perpetual)\",ROUND(M24*0.9,2),\nROUND(M24*0.6,2)))))))","v":""},null,"X",null,null,null,null,null,"=",{"$f":"IF(Q24=\"\",\"\",IF(U24=\"\",\"\",ROUND(Q24*U24,2)))","v":""}]
[]
[null,null,null,8,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E26),\"\",IF(ISBLANK(I26),\"\",ROUND(E26/I26,2)))","v":""},null,{"$f":"IF($H$9=\"RIM Grazing\",\"X 50% =\",\nIF($H$9=\"RIM Drinking Water DWSMA (Limited)\",\"X 75% =\",\nIF($H$9=\"RIM Drinking Water DWSMA (Perpetual)\",\"X 120% =\",\nIF($H$9=\"RIM Drinking Water (Perpetual)\",\"X 90% =\",\n(\"X 60% =\")))))","v":"X 60% ="},null,{"$f":"IF(M26=\"\",\"\",\nIF($H$9=\"\",\"\",\nIF($H$9=\"RIM Grazing\",ROUND(M26*0.5,2),\nIF($H$9=\"RIM Drinking Water DWSMA (Limited)\",ROUND(M26*0.75,2),\nIF($H$9=\"RIM Drinking Water DWSMA (Perpetual)\",ROUND(M26*1.2,2),\nIF($H$9=\"RIM Drinking Water (Perpetual)\",ROUND(M26*0.9,2),\nROUND(M26*0.6,2)))))))","v":""},null,"X",null,null,null,null,null,"=",{"$f":"IF(Q26=\"\",\"\",IF(U26=\"\",\"\",ROUND(Q26*U26,2)))","v":""}]
[]
[null,null,null,9,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E28),\"\",IF(ISBLANK(I28),\"\",ROUND(E28/I28,2)))","v":""},null,{"$f":"IF($H$9=\"RIM Grazing\",\"X 50% =\",\nIF($H$9=\"RIM Drinking Water DWSMA (Limited)\",\"X 75% =\",\nIF($H$9=\"RIM Drinking Water DWSMA (Perpetual)\",\"X 120% =\",\nIF($H$9=\"RIM Drinking Water (Perpetual)\",\"X 90% =\",\n(\"X 60% =\")))))","v":"X 60% ="},null,{"$f":"IF(M28=\"\",\"\",\nIF($H$9=\"\",\"\",\nIF($H$9=\"RIM Grazing\",ROUND(M28*0.5,2),\nIF($H$9=\"RIM Drinking Water DWSMA (Limited)\",ROUND(M28*0.75,2),\nIF($H$9=\"RIM Drinking Water DWSMA (Perpetual)\",ROUND(M28*1.2,2),\nIF($H$9=\"RIM Drinking Water (Perpetual)\",ROUND(M28*0.9,2),\nROUND(M28*0.6,2)))))))","v":""},null,"X",null,null,null,null,null,"=",{"$f":"IF(Q28=\"\",\"\",IF(U28=\"\",\"\",ROUND(Q28*U28,2)))","v":""}]
[]
[null,null,null,10,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E30),\"\",IF(ISBLANK(I30),\"\",ROUND(E30/I30,2)))","v":""},null,{"$f":"IF($H$9=\"RIM Grazing\",\"X 50% =\",\nIF($H$9=\"RIM Drinking Water DWSMA (Limited)\",\"X 75% =\",\nIF($H$9=\"RIM Drinking Water DWSMA (Perpetual)\",\"X 120% =\",\nIF($H$9=\"RIM Drinking Water (Perpetual)\",\"X 90% =\",\n(\"X 60% =\")))))","v":"X 60% ="},null,{"$f":"IF(M30=\"\",\"\",\nIF($H$9=\"\",\"\",\nIF($H$9=\"RIM Grazing\",ROUND(M30*0.5,2),\nIF($H$9=\"RIM Drinking Water DWSMA (Limited)\",ROUND(M30*0.75,2),\nIF($H$9=\"RIM Drinking Water DWSMA (Perpetual)\",ROUND(M30*1.2,2),\nIF($H$9=\"RIM Drinking Water (Perpetual)\",ROUND(M30*0.9,2),\nROUND(M30*0.6,2)))))))","v":""},null,"X",null,null,null,null,null,"=",{"$f":"IF(Q30=\"\",\"\",IF(U30=\"\",\"\",ROUND(Q30*U30,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(U12,U14,U16,U18,U20,U22,U24,U26,U28,U30,U32)","v":0},null,null,null,null,{"$f":"SUM(Z12,Z14,Z16,Z18,Z20,Z22,Z24,Z26,Z28,Z30)","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,"2025-07-01"]

{"sheet":"Programs","index":1,"n_rows":15,"n_cols":1,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["Easement Type"]
["Army Compatible Use Buffer"]
["Critical Shorelands"]
["Kettle and Snake River Watershed Riparian Habitat Protection"]
["Mississippi Headwaters Habitat Corridor"]
["Pine and Leech Watershed Shoreland Protection"]
["Protecting North Central Lakes: Crow Wing and Aitkin"]
["RIM Drinking Water (Limited)"]
["RIM Drinking Water (Perpetual)"]
["RIM Drinking Water DWSMA (Limited)"]
["RIM Drinking Water DWSMA (Perpetual)"]
["RIM Grazing"]
["RIM Integrating Clean Water and Habitat (1W1P)"]
["RIM Reforestation"]
["Wild Rice Shoreland Protection"]

{"sheet":"SWCD","index":2,"n_rows":91,"n_cols":2,"rows_kept":91,"cut":false,"hidden":true,"merged":[]}
["SWCD_CODE","SWCD_DESC"]
[1,"Aitkin"]
[2,"Anoka"]
[3,"Becker"]
[4,"Beltrami"]
[5,"Benton"]
[6,"Big Stone"]
[7,"Blue Earth"]
[8,"Brown"]
[9,"Carlton"]
[10,"Carver"]
[11,"Cass"]
[12,"Chippewa"]
[13,"Chisago"]
[14,"Clay"]
[15,"Clearwater"]
[16,"Cook"]
[17,"Cottonwood"]
[18,"Crow Wing"]
[19,"Dakota"]
[20,"Dodge"]
[21,"Douglas"]
[22,"Faribault"]
[23,"Fillmore"]
[24,"Freeborn"]
[25,"Goodhue"]
[26,"Grant"]
[27,"Hennepin"]
[28,"Root River"]
[29,"Hubbard"]
[30,"Isanti"]
[31,"Itasca"]
[32,"Jackson"]
[33,"Kanabec"]
[34,"Kandiyohi"]
[35,"Kittson"]
[36,"Koochiching"]
[37,"Lac Qui Parle"]
[38,"Lake"]
[39,"Lake of the Woods"]
[40,"Le Sueur"]
[41,"Lincoln"]
[42,"Lyon"]
[43,"McLeod"]
[44,"Mahnomen"]
[45,"Marshall"]
[46,"Martin"]
[47,"Meeker"]
[48,"Mille Lacs"]
[49,"Morrison"]
[50,"Mower"]
[51,"Murray"]
[52,"Nicollet"]
[53,"Nobles"]
[54,"Norman"]
[55,"Olmsted"]
["56EOT","East Ottertail"]
["56WOT","West Ottertail"]
[57,"Pennington"]
[58,"Pine"]
[59,"Pipestone"]
["60EP","East Polk"]
["60WP","West Polk"]
[61,"Pope"]
[62,"Ramsey"]
[63,"Red Lake"]
[64,"Redwood"]
[65,"Renville"]
[66,"Rice"]
[67,"Rock"]
[68,"Roseau"]
["69NSL","North St. Louis"]
["69SSL","South St. Louis"]
[70,"Scott"]
[71,"Sherburne"]
[72,"Sibley"]
[73,"Stearns"]
[74,"Steele"]
[75,"Stevens"]
[76,"Swift"]
[77,"Todd"]
[78,"Traverse"]
[79,"Wabasha"]
[80,"Wadena"]
[81,"Waseca"]
[82,"Washington"]
[83,"Watonwan"]
[84,"Wilkin"]
[85,"Winona"]
[86,"Wright"]
[87,"Yellow Medicine"]