{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet3","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":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,12],[1,0,1,12],[2,0,2,12],[27,3,27,6],[13,0,13,6],[5,0,5,6],[7,0,7,4],[4,3,4,6],[15,0,15,4],[20,0,20,4],[6,0,6,3],[3,0,3,12]]}
["INVOICE "]
["FOR: Reimbursable RIM/CREP Easement Acquisition Services "]
["AND/OR Reimbursable RIM/CREP Wetland Restoration Technical Assistance"]
["*Please utilize this form for work orders made under the newest master contract expiring in 2025"]
["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 receipt of title commitment",null,null,null,null,null,1000,null,null,null,null,null,"USE ONLY"]
["Phase 2:  Title clearing through recording of easement and implementation of conservation plan",null,null,null,null,null,1000]
["X"]
["Easement #","Phase 1","Phase 2","Column1","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},null,null,null,{"$f":"SUM(Table3[[#This Row],[Column7]:[Column8]])","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},null,null,null,{"$f":"SUM(Table3[[#This Row],[Column7]:[Column8]])","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!"}}]
["Part B - Technical Assistance",null,null,null,null,null,null,0,0,0,0,0]
["Section 1:  Wetland Restoration General Duties"]
["(review maps/photos, coordinate project w/ cooperators, assist with permits, permissions, authorizations, & contractor bidding/selection)"]
["Level 1: No Technical Assistance Provided",null,null,null,null,null,0]
["Level 2: General Duties provided",null,null,null,null,null,500]
[]
["Section 2:  Optional Technical Assistance Duties"]
["(assist w/ on-site data collection and assessments, construction staking/layout, project design, & perform/assist construction oversight, project close out & preparation of construction as-builts)"]
["Level 3:  General Duties & Partial Technical Assistance",null,null,null,null,null,2000]
["Level 4: General Duties & Extensive Technical Assistance",null,null,null,null,null,3500]
[]
["Easement #XX","Level of Assistance","Column1","Column2","Column6","Column4","Column5","Column8","06","07","08","Column7","Part B Totals:"]
[null,null,null,null,null,null,null,null,{"$f":"IF(B26=\"LEVEL 1\",$G$18,0)","v":0},{"$f":"IF(C26=\"X\",$G$22,0)","v":0},{"$f":"IF(D26=\"X\",$G$23,0)","v":0},null,{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Level of Assistance]],Sheet3!$A$2:$B$4,2,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(B27=\"LEVEL 1\",$G$18,0)","v":0},{"$f":"IF(C27=\"X\",$G$22,0)","v":0},{"$f":"IF(D27=\"X\",$G$23,0)","v":0},null,{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Level of Assistance]],Sheet3!$A$2:$B$4,2,FALSE),0)","v":0}]
[null,null,null,"GRAND TOTAL:",null,null,null,null,null,null,null,null,{"$f":"SUM($M$10:M27)","v":0}]
[null,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":"Sheet3","index":1,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Level","Amount"]
["Level 2",500]
["Level 3",2000]
["Level 4",3500]

{"sheet":"Sheet2","index":2,"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"]