{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"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":"Sheet1","index":0,"n_rows":39,"n_cols":13,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,12],[1,0,1,12],[2,0,2,12],[30,3,30,6],[24,2,25,3],[24,1,25,1],[15,0,15,6],[5,0,5,6],[7,0,7,4],[3,3,3,6]]}
["INVOICE "]
["FOR: Reimbursable RIM/CREP Easement Acquisition Services"]
["AND/OR Reimbursable RIM/CREP Wetland Restoration Technical Assistance"]
["Click Here to Select SWCD",null,null,"Work Order #:"]
[]
["Part A - Easement Acquisition Services",null,null,null,null,null,null,null,null,null,null,null," BWSR"]
["Phase 1:  Funded application through title clearing",null,null,null,null,null,1000,null,null,null,null,null,"USE ONLY"]
["Phase 2:  Title clearing through easement recording",null,null,null,null,null,500]
["Phase 3: Preparation & implementation of ",null,null,null,null,null,500]
["conservation plans."]
["X"]
["Easement #","Phase 1","Phase 2","Phase 3","Column4","Column5","Column6","Column7","Column8","Column9","Column10","Column11","Part A Totals:"]
[null,null,null,null,null,null,null,{"$f":"IF(Table3[[#This Row],[Phase 1]]=\"X\",$G$7,0)","v":0},{"$f":"IF(Table3[[#This Row],[Phase 2]]=\"X\",$G$8,0)","v":0},{"$f":"IF(Table3[[#This Row],[Phase 3]]=\"X\",$G$9,0)","v":0},null,null,{"$f":"SUM(Sheet1!$H13:$J13)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(Table3[[#This Row],[Phase 1]]=\"X\",$G$7,0)","v":0},{"$f":"IF(Table3[[#This Row],[Phase 2]]=\"X\",$G$8,0)","v":0},{"$f":"IF(Table3[[#This Row],[Phase 3]]=\"X\",$G$9,0)","v":0},null,null,{"$f":"SUM(Sheet1!$H14:$J14)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(Table3[[#This Row],[Phase 1]]=\"X\",$G$7,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Table3[[#This Row],[Phase 2]]=\"X\",$G$8,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Table3[[#This Row],[Phase 3]]=\"X\",$G$9,0)","v":{"$error":"#VALUE!"}}]
["Part B - Technical Assistance",null,null,null,null,null,null,0,0,0,0,0]
["Section 1:  Restoration Plan Development"]
["Restoration plan development",null,null,null,null,null,500]
[]
["Section 2:  Construction Implementation"]
["(staking/layout, oversight, inspection, final check, as-built plan)"]
["(a) SWCD plays extensive role in simple project",null,null,null,null,null,1500]
["(b) SWCD plays extensive role in complex project",null,null,null,null,null,3000]
[]
[null,"Restoration  Plan Dev.","Construction Implementation"]
["Column1",null,null,null,null,"B5","Column2",null,"Column4","Column5","Column6","Column7"]
["Easement #XX","S. 1","S. 2(a)","S. 2(b)","Column6","Column4","Column5","Column8","06","07","08","Column7","Part B Totals:"]
[null,null,null,null,null,null,null,null,{"$f":"IF(B28=\"X\",$G$18,0)","v":0},{"$f":"IF(C28=\"X\",$G$22,0)","v":0},{"$f":"IF(D28=\"X\",$G$23,0)","v":0},null,{"$f":"IF(AND(Sheet1!$C28=Sheet1!$D28,Sheet1!$C28<>\"\"),\"INVALID ENTRY\",SUM(Sheet1!$I28:$L28))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(B29=\"X\",$G$18,0)","v":0},{"$f":"IF(C29=\"X\",$G$22,0)","v":0},{"$f":"IF(D29=\"X\",$G$23,0)","v":0},null,{"$f":"IF(AND(Sheet1!$C29=Sheet1!$D29,Sheet1!$C29<>\"\"),\"INVALID ENTRY\",SUM(Sheet1!$I29:$L29))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(B30=\"X\",$G$18,0)","v":0},{"$f":"IF(C30=\"X\",$G$22,0)","v":0},{"$f":"IF(D30=\"X\",$G$23,0)","v":0},null,{"$f":"IF(AND(Sheet1!$C30=Sheet1!$D30,Sheet1!$C30<>\"\"),\"INVALID ENTRY\",SUM(Sheet1!$I30:$L30))","v":0}]
[null,null,null,"GRAND TOTAL:",null,null,null,null,null,null,null,null,{"$f":"SUM($M$12:M30)","v":0}]
[{"$f":"IF(COUNTIF(M13:M30,\"*\" & \"INVALID\" & \"*\"),\"INVALID ENTRY, DO NOT SIGN\",\"\")","v":""},null,null,"_____________"]
["SWCD Representative",null,null,"Date"]
[]
[null,null,null,"_____________"]
["BWSR Engineering Approval",null,null,"Date"]
[]
[null,null,null,"_____________"]
["BWSR Easement Section Approval",null,null,"Date"]

{"sheet":"Sheet2","index":1,"n_rows":91,"n_cols":1,"rows_kept":91,"cut":false,"hidden":true,"merged":[]}
["Aitkin SWCD"]
["Anoka CD"]
["Becker SWCD"]
["Beltrami SWCD"]
["Benton SWCD"]
["Big Stone SWCD"]
["Blue Earth County SWCD"]
["Brown SWCD"]
["Carlton SWCD"]
["Carver SWCD"]
["Cass SWCD"]
["Chippewa SWCD"]
["Chisago SWCD"]
["Clay SWCD"]
["Clearwater SWCD"]
["Cook SWCD"]
["Cottonwood SWCD"]
["Crow Wing SWCD"]
["Dakota SWCD"]
["Dodge SWCD"]
["Douglas SWCD"]
["Faribault County SWCD"]
["Fillmore SWCD"]
["Freeborn SWCD"]
["Goodhue SWCD"]
["Grant SWCD"]
["Hennepin County ES"]
["Hubbard SWCD"]
["Isanti SWCD"]
["Itasca SWCD"]
["Jackson SWCD"]
["Kanabec SWCD"]
["Kandiyohi SWCD"]
["Kittson SWCD"]
["Koochiching SWCD"]
["Lac qui Parle SWCD"]
["Lake SWCD"]
["Lake of the Woods SWCD"]
["Le Sueur County SWCD"]
["Lincoln SWCD"]
["Lyon SWCD"]
["Mahnomen SWCD"]
["Marshall SWCD"]
["Martin SWCD"]
["McLeod SWCD"]
["Meeker SWCD"]
["Mille Lacs SWCD"]
["Morrison SWCD"]
["Mower County SWCD"]
["Murray SWCD"]
["Nicollet SWCD"]
["Nobles SWCD"]
["Norman SWCD"]
["Olmsted SWCD"]
["Otter Tail, East SWCD"]
["Ottertail, West SWCD"]
["Pennington SWCD"]
["Pine SWCD"]
["Pipestone SWCD"]
["Polk, East SWCD"]
["Polk, West SWCD"]
["Pope SWCD"]
["Ramsey CD"]
["Red Lake SWCD"]
["Redwood SWCD"]
["Renville SWCD"]
["Rice SWCD"]
["Rock SWCD"]
["Root River SWCD"]
["Roseau SWCD"]
["Scott SWCD"]
["Sherburne SWCD"]
["Sibley SWCD"]
["St Louis, North SWCD"]
["St. Louis, South SWCD"]
["Stearns SWCD"]
["Steele County SWCD"]
["Stevens SWCD"]
["Swift SWCD"]
["Todd SWCD"]
["Traverse SWCD"]
["Wabasha SWCD"]
["Wadena SWCD"]
["Waseca SWCD"]
["Waseca SWCD"]
["Washington CD"]
["Watonwan SWCD"]
["Wilkin SWCD"]
["Winona County SWCD"]
["Wright SWCD"]
["Yellow Medicine SWCD"]