{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":[" Client Info & Instr","Crop","Grass","HdgRow","Riparian","Shallow Water","Wetland","WoodsWetland","Woods","Sum","Sum-Multi"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":11,"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":" Client Info & Instr","index":0,"n_rows":58,"n_cols":2,"rows_kept":58,"cut":false,"hidden":false,"merged":[[38,0,38,3],[28,0,28,3],[47,0,47,3],[33,0,33,3],[45,0,45,3],[46,0,46,3],[44,0,44,3],[42,0,42,3],[41,0,41,3],[40,0,40,3],[43,0,43,3],[39,0,39,3],[29,0,29,3],[30,0,30,3],[37,0,37,3],[36,0,36,3],[24,0,24,3],[35,0,35,3],[7,3,8,3],[25,0,25,3],[23,0,23,3],[22,0,22,3],[21,0,21,3],[32,0,32,3],[26,0,26,3],[27,0,27,3],[31,0,31,3],[34,0,34,3]]}
[]
[]
[null,"Client Information"]
[]
["Name:"]
["Name (additional person, if applicable):"]
["Address (street address):  "]
["Address (city, state, zip):  "]
["Phone:"]
["Farm No.:"]
["Tract No.:"]
["County:"]
["Practice/s:"]
["Assisted By:"]
["Date:"]
[]
[]
[]
[null,"HABITAT SUITABILITY INDEX (HSI)"]
[null," WORKBOOK INSTRUCTIONS "]
[]
["INTRODUCTION\n"]
["The HSI Workbook is a tool to help planners identify habitat limitations and determine the change in habitat quality based on conservation practice implementation.  NRCS policy (Section 511.04, (c), 190-V-NBM, July, 2003) requires an HSI score of 0.5 to meet minimum Planning Criteria for Resource Management System (RMS) planning. \n"]
["In order to measure the degree to which the resource management system meets the planning criteria, a method of evaluation is required. If the evaluation determines that the current habitat quality is less than 0.5 (on a scale of 0 to 1), recommendations will be made to improve the existing habitat so that the planned (future) condition will have a quality rating of 0.5 or greater. If the evaluation determines that the existing condition is equal to or greater than 0.5, recommendations should be made to maintain the existing habitat in its present condition or to improve it toward optimum conditions (if that is the producer’s objective).\n\n"]
["NOTE:  For some programs or other purposes, a specific index score higher than 0.5 may be required to meet objectives.   \n"]
[]
["USING THIS WORKBOOK"]
["There are 10 worksheets in this workbook. Depending on the size of your computer's screen, you may need to use the slide bar at the bottom of the screen to view the entire lineup. You will only be allowed to enter data or modify data in selected cells. The cells with yellow shading are the \"fillable\" cells."]
["Use the \"Print Form\" button at the bottom of each form to do a quick print \n"]
["Below the \"Print Form\" button on each sheet, there is a \"Clear Form & Start Over\" button. This clears everything you entered on that sheet, except the items automatically pulled from the Client Information Sheet. Warning!! Do not clear the data until you have filled out all the applicable worksheets and printed your Summary sheet. There's no \"Undo\" available after you hit this button, so be sure you really want to clear the form!\n"]
["Worksheets are as follows:"]
["Client Info & Instructions Worksheet (this worksheet) - Enter the producer's information. This information will be transferred to the other worksheets in this workbook. \n\n"]
["Wildlife Habitat Evaluation Worksheets (eight worksheets) - Complete these for each program application and CTA plan that contains wildlife practices.\n"]
["1.  Select the appropriate worksheet for the land use (e.g., cropland, pasture, woodland) or habitat type (e.g., riparian area, shallow water habitat, wetland habitat) for which one or more conservation practices will be applied. For most situations, select the appropriate sheet based on the habitat the producer wants for the planned condition. Note: If the planned condition involves conversion of a higher value habitat (e.g., woodland) to a lower value habitat (e.g., cropland), consult the State Resource Conservationist for instructions concerning evaluating this situation. "]
["● Use one worksheet per management system, which may include one or more fields."]
["● Crop fields with the same crop rotation and management practices should be grouped together for habitat evaluation."]
["● Fields that are managed primarily as permanent hayland should be evaluated separately from fields managed primarily for pasture."]
["2.  Evaluate the benchmark condition and the planned condition. If the landowner has destroyed or altered habitat to a lesser value, the benchmark condition will be evaluated based on the original habitat.\n   \n"]
["● Record the point score that most closely fits each item. If the habitat condition is in between two described scenarios, you can record a score between the two values. \n    "]
["● The points for the benchmark and planned conditions are automatically totaled and divided by their maximum possible scores to determine the benchmark and planned HSI values.\n"]
["3.  If you are evaluating more than one system or habitat type, record the results from each worksheet on the summary worksheet. \n   "]
["● Use the summary worksheet to calculate the net effect of the conservation plan (overall planned index minus the overall benchmark index) for the planning area."]
["Habitat Suitability Index Summary Worksheet - The summary worksheet provides a total weighted value for the benchmark and planned conditions. The information entered on each of the Habitat Evaluation worksheets is linked to a table on the bottom of the Summary Sheet. Use the dropdown boxes in column A to choose the Habitat Type (Land Use) and the information will be transferred onto the Summary Sheet. Make sure you enter a total acre figure in the yellow shaded box at the bottom of the form or you will get a \"can't divide by zero error\" message. To clear the Summary Sheet, use the clear button.  To clear the information linked to the table on the bottom of the Summary Sheet, you must clear the individual Evaluation Worksheets. "]
["DOCUMENTATION"]
["File the completed worksheet(s) and associated information in the customer folder:\n\n"]
["● Habitat Suitability Index Worksheets (whichever ones are applicable), including completed Client Information (data entry on first worksheet).\n● Plan map (aerial photo) showing location of the practice(s)\n● Soil map marked with the location of the proposed practice(s)"]
[]
[]
[]
[]
[]
[]
[]
["County","State & County Code"]
[]
["Kent","DE - Kent - 001"]
["New Castle","DE - New Castle - 003"]
["Sussex","DE - Sussex - 005"]

{"sheet":"Crop","index":1,"n_rows":58,"n_cols":9,"rows_kept":58,"cut":false,"hidden":false,"merged":[[14,0,14,1],[6,3,6,4],[7,3,7,4],[0,0,0,4],[1,0,1,4],[2,3,2,4],[3,3,3,4],[4,2,4,4],[5,2,5,4],[35,3,38,3],[35,4,38,4],[15,0,15,1],[16,0,16,1],[19,0,19,1],[20,0,20,1],[19,3,22,3],[19,4,22,4],[30,3,33,3],[30,4,33,4],[24,3,27,3],[27,0,27,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[41,3,44,3],[41,4,44,4],[9,0,9,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[12,3,16,3],[12,4,16,4],[21,0,21,1],[23,0,23,1],[24,4,27,4],[36,0,36,1],[18,0,18,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[34,0,34,1],[35,0,35,1],[49,0,49,1],[43,0,43,1],[44,0,44,1],[37,0,37,1],[38,0,38,1],[40,0,40,1],[41,0,41,1],[42,0,42,1],[47,0,47,1]]}
["WILDLIFE HABITAT EVALUATION WORKSHEET"]
["CROPLAND"]
["Name:",{"$f":"' Client Info & Instr'!$B$5","v":0},"Farm No.:",{"$f":"' Client Info & Instr'!$B$10","v":0}]
[null,{"$f":"' Client Info & Instr'!$B$6","v":0},"Tract No.:",{"$f":"' Client Info & Instr'!$B$11","v":0}]
["Address:",{"$f":"' Client Info & Instr'!$B$7","v":0}]
[null,{"$f":"' Client Info & Instr'!$B$8","v":0}]
["Date:",{"$f":"' Client Info & Instr'!$B$15","v":"00:00:00"},"Field No.:"]
["Evaluated by:  ",{"$f":"' Client Info & Instr'!$B$14","v":0},"Acres:"]
[]
["CROPLAND HABITAT INDEX",null,"POINTS","BENCHMARK","PLANNED"]
[]
["Crop residue management"]
["Over-winter residue >50%, and cover crop planted by Sept. 1st",null,10]
["Over-winter residue >50%, or over-winter residue 10-50% and cover crop planted by Sept. 15th",null,7]
["Over-winter residue 10-50% or cover crop planted by Sept. 15th",null,5]
["Over-winter residue <10%; fall cover crop or small grain",null,3]
["Over-winter residue <10%; no fall crop",null,1]
[]
["Crop rotation"]
["Row crop or small grain, with hay",null,10]
["Row crop-small grain",null,5]
["Continuous row crops (no small grain or hay)",null,3]
[]
["Crop management"]
[">10% unharvested crop or food plots",null,10]
["1-10% unharvested crop",null,7]
["Total crop harvested, with weeds present",null,4]
["Total crop harvested; no weeds present",null,1]
[]
["Size of field"]
["< 5 acres",null,10]
["5 – 10 acres",null,5]
["> 10 acres",null,1]
[]
["Percent of field perimeter with a field edge border (min. 35' wide) of trees, shrubs, and/or herbaceous vegetation not mowed or disturbed between 4/15 & 8/15"]
["75-100%",null,10,null,null,null,null,null," "]
["50-74%",null,7]
["25-49%",null,5]
["<25%, or no border",null,1]
[]
["Minimum distance (measured from the center of the field) to the nearest wildlife habitat that provides suitable nesting and/or protective cover."]
["<100 feet",null,10]
["100 – 300 feet",null,7]
["301 – 500 feet",null,3]
[">500 feet",null,1]
[]
[]
["(A) Total Cropland Habitat Points (60 maximum)",null,null,{"$f":"SUM(D13:D45)","v":0},{"$f":"SUM(E13:E45)","v":0}]
[]
["(B) Cropland Habitat Index (Total Points/60)",null,null,{"$f":"D48/60","v":0},{"$f":"E48/60","v":0}]
[]
["Conservation practices that may be used to improve habitat:"]
["Conservation Crop Rotation (328)"]
["Field Border (386)"]
["Hedgerow Planting (422)"]
["Residue and Tillage Mgt., No Till (329)"]
["Residue and Tillage Mgt., Reduced Till (345)"]
["Upland Wildlife Habitat Mgt. (645)"]

{"sheet":"Grass","index":2,"n_rows":58,"n_cols":5,"rows_kept":58,"cut":false,"hidden":false,"merged":[[30,0,30,1],[23,0,23,1],[24,0,24,1],[29,0,29,1],[0,0,0,4],[1,0,1,4],[2,3,2,4],[3,3,3,4],[9,0,9,1],[6,3,6,4],[7,3,7,4],[4,2,4,4],[5,2,5,4],[21,0,21,1],[27,0,27,1],[28,0,28,1],[26,0,26,1],[22,0,22,1],[11,0,11,1],[12,0,12,1],[16,0,16,1],[19,0,19,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[17,0,17,1],[39,0,39,1],[36,0,36,1],[12,3,17,3],[12,4,17,4],[20,3,24,3],[20,4,24,4],[27,3,31,3],[27,4,31,4],[34,3,37,3],[34,4,37,4],[33,0,33,1],[31,0,31,1],[34,0,34,1],[35,0,35,1],[37,0,37,1],[20,0,20,1],[46,0,46,1],[48,0,48,1],[40,3,43,3],[40,4,43,4],[40,0,40,1],[41,0,41,1],[42,0,42,1],[43,0,43,1]]}
["WILDLIFE HABITAT EVALUATION WORKSHEET"]
["GRASSLAND, PASTURELAND, HAYLAND, OR FALLOW HERBACEOUS LAND"]
["Name:",{"$f":"' Client Info & Instr'!$B$5","v":0},"Farm No.:",{"$f":"' Client Info & Instr'!$B$10","v":0}]
[null,{"$f":"' Client Info & Instr'!$B$6","v":0},"Tract No.:",{"$f":"' Client Info & Instr'!$B$11","v":0}]
["Address:",{"$f":"' Client Info & Instr'!$B$7","v":0}]
[null,{"$f":"' Client Info & Instr'!$B$8","v":0}]
["Date:",{"$f":"' Client Info & Instr'!$B$15","v":"00:00:00"},"Field No.:"]
["Evaluated by:  ",{"$f":"' Client Info & Instr'!$B$14","v":0},"Acres:"]
[]
["GRASSLAND, PASTURELAND, or HAYLAND HABITAT INDEX",null,"POINTS","BENCHMARK","PLANNED"]
[]
["Plant composition"]
["Mixture of native grasses and forbs",null,10]
["Mixture of non-native grasses and forbs",null,8]
["Native grass(es) w/ no forbs",null,6]
["Single species non-native grass w/ no forbs, or legumes alone",null,4]
["Tall fescue mixed with other species  (<50% tall fescue)",null,2]
["Predominantly tall fescue  (>50% tall fescue), or no perennial vegetation (e.g., cropland)",null,1]
[]
["Mowing or haying management"]
["Not mowed/cut April 15 to August 15, and at least 8\" winter height for CSGs and 18\" for native WSGs",null,10]
["Not mowed/cut April 15 to August 15, and <8\" winter height for CSGs and <18\" for native WSGs ",null,7]
["Mowed/cut occasionally between April 15  & August 15, and at least 8\" winter height for CSGs and 18\" for native WSGs",null,5]
["Mowed/cut occasionally between April 15  & August 15, and <8\" winter height for CSGs and <18\" for native WSGs ",null,3]
["Mowed/cut frequently April 15 to August 15, and <8\" winter height for CSGs and <18\" for native WSGs, or no perennial vegetation (e.g., cropland)",null,1]
[]
["Use by domestic animals or humans"]
["No or minimal disturbance; >95% cover",null,10]
["Light grazing pressure, with min. grazing height 6\"; 85 - 95% cover",null,8]
["Moderate grazing pressure; 75 - 84% cover",null,6]
["Heavy grazing pressure; <75% cover",null,2]
["Frequent human disturbance (e.g., lawn, ballfield), or no perennial vegetation (e.g., cropland)",null,1]
[]
["Percent of field perimeter with a field edge border (min. 35' wide) of trees, shrubs, and/or herbaceous vegetation not mowed or disturbed between 4/15 & 8/15"]
["75-100%",null,10]
["50-74",null,7]
["25-49%",null,5]
["<25%, or no border",null,1]
[]
["Minimum distance (measured from the center of the field) to the nearest wildlife habitat that provides suitable nesting and/or protective cover."]
["<100 feet",null,10]
["100 – 300 feet",null,7]
["301 – 500 feet",null,3]
[">500 feet",null,1]
[]
[]
["(A) Total Grassland/Hayland Habitat Points (50 maximum)",null,null,{"$f":"SUM(D13:D44)","v":0},{"$f":"SUM(E13:E44)","v":0}]
[]
["(B) Grassland/Hayland Habitat Index (Total Points/50)",null,null,{"$f":"D47/50","v":0},{"$f":"E47/50","v":0}]
[]
["Conservation practices that may be used to improve habitat:"]
["Prescribed Grazing (528)"]
["Forage and Biomass Planting (512)"]
["Conservation Cover (327)"]
["Field Border (386)"]
["Forage Harvest Mgt. (511)"]
["Hedgerow Planting (422)"]
["Upland Wildlife Habitat Mgt. (645)"]

{"sheet":"HdgRow","index":3,"n_rows":51,"n_cols":5,"rows_kept":51,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4],[2,3,2,4],[3,3,3,4],[9,0,9,1],[4,2,4,4],[5,2,5,4],[12,0,12,1],[6,3,6,4],[7,3,7,4],[12,3,16,3],[12,4,16,4],[11,0,11,1],[22,0,22,1],[23,0,23,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[21,0,21,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[19,4,23,4],[38,3,39,3],[38,4,39,4],[26,3,29,3],[26,4,29,4],[32,3,35,3],[32,4,35,4],[42,0,42,1],[44,0,44,1],[38,0,38,1],[39,0,39,1],[19,3,23,3],[37,0,37,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[35,0,35,1],[25,0,25,1],[26,0,26,1],[28,0,28,1],[29,0,29,1],[27,0,27,1]]}
["WILDLIFE HABITAT EVALUATION WORKSHEET"]
["HEDGEROW"]
["Name:",{"$f":"' Client Info & Instr'!$B$5","v":0},"Farm No.:",{"$f":"' Client Info & Instr'!$B$10","v":0}]
[null,{"$f":"' Client Info & Instr'!$B$6","v":0},"Tract No.:",{"$f":"' Client Info & Instr'!$B$11","v":0}]
["Address:",{"$f":"' Client Info & Instr'!$B$7","v":0}]
[null,{"$f":"' Client Info & Instr'!$B$8","v":0}]
["Date:",{"$f":"' Client Info & Instr'!$B$15","v":"00:00:00"},"Field No.:"]
["Evaluated by:  ",{"$f":"' Client Info & Instr'!$B$14","v":0},"Acres:"]
[]
["HEDGEROW HABITAT INDEX",null,"POINTS","BENCHMARK","PLANNED"]
[]
["Composition"]
["Mix of hardwoods, conifer, and shrubs",null,20]
["Mix of hardwoods and conifers with few or no shrubs",null,15]
["Mix of hardwoods or conifers or shrubs",null,10]
["Single species of hardwoods or shrubs, or unmanaged herbaceous idle area at least 12\" in height",null,5]
["Single species of conifers, or minimal to no woody cover",null,1]
[]
["Width (or number of rows)"]
["> 50 feet wide (or more than 4 rows, if planted)",null,10]
["35 - 50 feet wide (or 4 rows, if planted)",null,7]
["25 - 34 feet wide (or 3 rows, if planted)",null,5]
["20 - 24 feet wide (or 2 rows, if planted)",null,3]
["< 20 feet wide (or 1 row, if planted), or minimal to no woody cover",null,1]
[]
["Winter cover"]
["At least 25% conifers, in blocks at least 400 SF in size",null,10]
["At least 25% shrubs, in blocks at least 400 SF in size",null,6]
["At least 25% conifers and shrubs, scattered, not in blocks, or unmanaged herbaceous idle area at least 12\" in height",null,3]
["Less than 25% conifers or shrubs, or minimal to no woody cover ",null,1]
[]
["Minimum distance (measured from the center of the field) to the nearest wildlife habitat that provides suitable nesting and/or protective cover."]
["< 100 feet",null,10]
["100 - 300 feet",null,7]
["301 - 500 feet",null,3]
["> 500 feet",null,1]
[]
["Hedgerow connects two or more areas that provide suitable habitat for nesting and/or protective cover (provides travel corridor - minimum 50 feet wide)"]
["Yes",null,10]
["No (hedgerow does not provide a suitable travel corridor, or no hedgerow)",null,1]
[]
[]
["(A)  Total Hedgerow Habitat Points (60 maximum)",null,null,{"$f":"SUM(D13:D40)","v":0},{"$f":"SUM(E13:E40)","v":0}]
[]
["(B)  Hedgerow Habitat Index (Total points/60)",null,null,{"$f":"D43/60","v":0},{"$f":"E43/60","v":0}]
[]
["Conservation practices that may be used to improve habitat:"]
["Hedgerow Planting (422)"]
["Conservation Cover (327)"]
["Field Border (386)"]
["Upland Wildlife Habitat Mgt. (645)"]

{"sheet":"Riparian","index":4,"n_rows":48,"n_cols":5,"rows_kept":48,"cut":false,"hidden":false,"merged":[[6,3,6,4],[0,0,0,4],[1,0,1,4],[2,3,2,4],[3,3,3,4],[4,2,4,4],[5,2,5,4],[18,0,18,1],[13,0,13,1],[7,3,7,4],[9,0,9,1],[11,0,11,1],[12,0,12,1],[12,3,14,3],[12,4,14,4],[14,0,14,1],[16,0,16,1],[17,0,17,1],[26,0,26,1],[19,0,19,1],[32,0,32,1],[33,0,33,1],[35,0,35,1],[21,0,21,1],[34,0,34,1],[27,0,27,1],[24,0,24,1],[39,0,39,1],[41,0,41,1],[17,3,19,3],[17,4,19,4],[33,3,36,3],[33,4,36,4],[36,0,36,1],[22,3,24,3],[22,4,24,4],[27,3,30,3],[28,0,28,1],[29,0,29,1],[27,4,30,4],[22,0,22,1],[23,0,23,1],[30,0,30,1]]}
["WILDLIFE HABITAT EVALUATION WORKSHEET"]
["RIPARIAN CORRIDOR"]
["Name:",{"$f":"' Client Info & Instr'!$B$5","v":0},"Farm No.:",{"$f":"' Client Info & Instr'!$B$10","v":0}]
[null,{"$f":"' Client Info & Instr'!$B$6","v":0},"Tract No.:",{"$f":"' Client Info & Instr'!$B$11","v":0}]
["Address:",{"$f":"' Client Info & Instr'!$B$7","v":0}]
[null,{"$f":"' Client Info & Instr'!$B$8","v":0}]
["Date:",{"$f":"' Client Info & Instr'!$B$15","v":"00:00:00"},"Field No.:"]
["Evaluated by:  ",{"$f":"' Client Info & Instr'!$B$14","v":0},"Acres:"]
[]
["RIPARIAN CORRIDOR HABITAT INDEX",null,"POINTS","BENCHMARK","PLANNED"]
[]
["Condition of stream channel and banks "]
["Minimally disturbed:  generally stable channel & banks; mostly natural conditions and natural vegetation",null,10]
["Moderately disturbed:  some streambank erosion, and/or replacement of natural vegetation with non-native species",null,5]
["Significantly disturbed: severe bank erosion/gullies, streambanks poorly vegetated, streambanks armored, and/or stream recently channelized",null,1]
[]
["Water quality"]
["Good:  minimal pollution by sediment, nutrients, contaminants, etc.",null,10]
["Fair:  moderate sediment loading & turbidity during storm events; some algae during low flows",null,5]
["Poor:  pollution by sediment, nutrients, contaminants are evident (e.g., heavy sedimentation, excessive algae, chemical spills)",null,1]
[]
["Plant composition in the riparian buffer (min. 35 feet wide)"]
["Predominantly trees and/or shrubs",null,10]
["Predominantly perennial herbaceous plants",null,5]
["Predominantly row crops, other annual plants, or bare ground",null,1]
[]
["Management of the riparian buffer"]
["Generally undisturbed by humans or domestic animals",null,10]
["Not mowed/disturbed April 15 to August 15",null,7]
["Mowed/disturbed occasionally between April 15 and August 15",null,4]
["Mowed/disturbed frequently between April 15 and August 15, or no permanently vegetated buffer",null,1]
[]
["Buffer width"]
["300 feet wide, or more",null,10]
["100-299 feet wide",null,7]
["35-99 feet wide",null,4]
["<35 feet wide, or no permanently vegetated buffer",null,1]
[]
[]
["(A)  Total Riparian Corridor Habitat Points (50 maximum)",null,null,{"$f":"SUM(D13:D37)","v":0},{"$f":"SUM(E13:E37)","v":0}]
[]
["(B)  Riparian Corridor Habitat Index (Total points/50)",null,null,{"$f":"D40/50","v":0},{"$f":"E40/50","v":0}]
[]
["Conservation practices that may be used to improve habitat:"]
["Riparian Herbaceous Cover (390)"]
["Riparian Forest Buffer (391)"]
["Streambank and Shoreline Protection (580)"]
["Upland Wildlife Habitat Mgt. (645)"]

{"sheet":"Shallow Water","index":5,"n_rows":60,"n_cols":5,"rows_kept":60,"cut":false,"hidden":false,"merged":[[12,3,16,3],[12,4,16,4],[14,0,14,1],[17,0,17,1],[12,0,12,1],[13,0,13,1],[16,0,16,1],[15,0,15,1],[18,0,18,1],[19,0,19,1],[19,3,22,3],[19,4,22,4],[20,0,20,1],[21,0,21,1],[22,0,22,1],[0,0,0,4],[1,0,1,4],[2,3,2,4],[3,3,3,4],[11,0,11,1],[9,0,9,1],[6,3,6,4],[7,3,7,4],[4,2,4,4],[5,2,5,4],[25,4,29,4],[32,3,35,3],[31,0,31,1],[35,0,35,1],[25,3,29,3],[34,0,34,1],[29,0,29,1],[32,0,32,1],[30,0,30,1],[32,4,35,4],[33,0,33,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[28,0,28,1],[27,0,27,1],[38,3,41,3],[38,4,41,4],[39,0,39,1],[40,0,40,1],[49,0,49,1],[44,3,47,3],[44,4,47,4],[45,0,45,1],[46,0,46,1],[47,0,47,1],[51,0,51,1],[43,0,43,1],[44,0,44,1],[37,0,37,1],[38,0,38,1],[41,0,41,1]]}
["WILDLIFE HABITAT EVALUATION WORKSHEET"]
["SHALLOW WATER AREA MANAGED FOR WATERFOWL HABITAT"]
["Name:",{"$f":"' Client Info & Instr'!$B$5","v":0},"Farm No.:",{"$f":"' Client Info & Instr'!$B$10","v":0}]
[null,{"$f":"' Client Info & Instr'!$B$6","v":0},"Tract No.:",{"$f":"' Client Info & Instr'!$B$11","v":0}]
["Address:",{"$f":"' Client Info & Instr'!$B$7","v":0}]
[null,{"$f":"' Client Info & Instr'!$B$8","v":0}]
["Date:",{"$f":"' Client Info & Instr'!$B$15","v":"00:00:00"},"Field No.:"]
["Evaluated by:  ",{"$f":"' Client Info & Instr'!$B$14","v":0},"Acres:"]
[]
["SHALLOW WATER HABITAT INDEX",null,"POINTS","BENCHMARK","PLANNED"]
[]
["Habitat diversity in the water area"]
["Hummocks and coarse large woody debris (tree trunks, limbs, etc.)",null,20]
["Hummocks or coarse large woody debris (tree trunks, limbs, etc.)",null,10]
["Irregular bottom and edge only",null,5]
["Generally smooth bottom",null,3]
["Not a shallow water habitat (e.g., PC cropland)",null,1]
[]
["Size of the water area, at seasonal high water"]
["Greater than 5 acres",null,10]
["3-5 acres",null,7]
["1-2.9 acres",null,5]
["Less than 1 acre, or no surface water ",null,1]
[]
["Composition and management of vegetation in the water area"]
["Naturally-occurring wetland plants; occasional mowing to control woody vegetation, or little to no management",null,10]
["Naturally-occurring wetland plants; moist soil management (disking every 2-3 years to encourage the re-establishment of seed-producing annuals)",null,7]
["Periodic control of cattails or other invasive species",null,5]
["Annual planting of grain crops (e.g., corn, soybeans, sorghum, millets, etc.); crop is not harvested",null,3]
["Predominantly unvegetated, or non-wetland plants with minimal seed production or crop is harvested",null,1]
[]
["Presence of a permanently vegetated buffer (min. 35’ wide) around the water's edge"]
["75-100% of water’s edge is buffered",null,5]
["50-74 % buffered",null,4]
["25-49% buffered",null,2]
["<25% buffered, or no permanently vegetated buffer",null,1]
[]
["Management of a permanently vegetated buffer"]
["Generally undisturbed by humans or domestic animals",null,5]
["Not mowed/disturbed April 15 to August 15",null,4]
["Mowed/disturbed occasionally between April 15  & August 15",null,2]
["Mowed/disturbed frequently April 15 to August 15, or no permanently vegetated buffer",null,1]
[]
["Minimum distance (measured from the center of the field) to the nearest wildlife habitat that provides suitable nesting and/or protective cover."]
["<100 feet",null,10]
["100 – 300 feet",null,7]
["301 – 500 feet",null,3]
[">500 feet",null,1]
[]
["(A) Total Shallow Water/Wetland Habitat Points (60 maximum)",null,null,{"$f":"SUM(D12:D48)","v":0},{"$f":"SUM(E12:E48)","v":0}]
[]
["(B) Shallow Water/Wetland Habitat Index (Total Points/60)",null,null,{"$f":"D50/60","v":0},{"$f":"E50/60","v":0}]
[]
["Conservation practices that may be used to improve habitat:"]
["Shallow Water Area Development and Management (646)"]
["Dike (356)"]
["Structure for Water Control (587)"]
["Riparian Herbaceous Cover (390)"]
["Riparian Forest Buffer (391)"]
["Wetland Wildlife Habitat Mgt. (644)"]

{"sheet":"Wetland","index":6,"n_rows":66,"n_cols":5,"rows_kept":66,"cut":false,"hidden":false,"merged":[[49,0,49,1],[38,0,38,1],[39,0,39,1],[24,0,24,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[30,0,30,1],[46,0,46,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[35,0,35,1],[40,0,40,1],[31,4,35,4],[25,0,25,1],[0,0,0,4],[1,0,1,4],[9,0,9,1],[12,0,12,1],[11,0,11,1],[2,3,2,4],[3,3,3,4],[6,3,6,4],[7,3,7,4],[4,2,4,4],[5,2,5,4],[12,4,16,4],[13,0,13,1],[14,0,14,1],[55,0,55,1],[57,0,57,1],[50,3,53,3],[50,4,53,4],[51,0,51,1],[52,0,52,1],[50,0,50,1],[53,0,53,1],[38,4,41,4],[19,4,22,4],[34,0,34,1],[44,0,44,1],[37,0,37,1],[25,3,28,3],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[19,3,22,3],[44,4,47,4],[25,4,28,4],[41,0,41,1],[43,0,43,1],[45,0,45,1],[18,0,18,1],[12,3,16,3],[44,3,47,3],[47,0,47,1],[38,3,41,3],[31,3,35,3],[16,0,16,1],[15,0,15,1]]}
["WILDLIFE HABITAT EVALUATION WORKSHEET"]
["WETLAND (Benchmark not woodland)"]
["Name:",{"$f":"' Client Info & Instr'!$B$5","v":0},"Farm No.:",{"$f":"' Client Info & Instr'!$B$10","v":0}]
[null,{"$f":"' Client Info & Instr'!$B$6","v":0},"Tract No.:",{"$f":"' Client Info & Instr'!$B$11","v":0}]
["Address:",{"$f":"' Client Info & Instr'!$B$7","v":0}]
[null,{"$f":"' Client Info & Instr'!$B$8","v":0}]
["Date:",{"$f":"' Client Info & Instr'!$B$15","v":"00:00:00"},"Field No.:"]
["Evaluated by:  ",{"$f":"' Client Info & Instr'!$B$14","v":0},"Acres:"]
[]
["WETLAND HABITAT INDEX",null,"POINTS","BENCHMARK","PLANNED"]
[]
["Site characteristics"]
["100% is a natural wetland, or is restored to the wetland type that naturally occurred on the site",null,10]
["Up to 30% is shallow emergent/open water, with the remainder as a natural wetland type",null,7]
["31-50% is shallow emergent/open water, with the remainder as a natural wetland type",null,5]
["75-100% is emergent/shallow open water (not a natural wetland type for the site)",null,3]
["Site is not a wetland (e.g., PC cropland)",null,1]
[]
["Size of wetland"]
["More than 5 acres",null,10]
["3-5 acres",null,7]
["1-2.9 acres",null,5]
["Less than 1 acre, or no surface water ",null,1]
[]
["Water regimes"]
["3 or more water regimes (e.g., permanent, semiperminent, seasonal, saturated)",null,10]
["2 water regimes",null,7]
["1 water regime",null,4]
["No wetland hydrology (i.e., wetland hydrology has been removed by drainage, fill, etc.)",null,1]
[]
["Composition and management of vegetation in the wetland"]
["Natural wetland community; little to no mgt.; natural succession allowed",null,10]
["Natural wetland community; occasional mgt. to suppress natural succession",null,7]
["Natural wetland community; frequently disturbed, such as by mowing/grazing",null,5]
["Natural plant community dominated by upland species",null,3]
["Predominantly row crops, other annual plants, or bare ground",null,1]
[]
["Presence of a permanently vegetated buffer (min. 35’ wide) around the wetland"]
["75-100% of wetland’s edge is buffered",null,5]
["50-74 % buffered",null,4]
["25-49% buffered",null,2]
["<25% buffered, or no permanently vegetated buffer",null,1]
[]
["Management of a permanently vegetated buffer"]
["Generally undisturbed by humans or domestic animals",null,5]
["Not mowed/disturbed April 15 to August 15",null,4]
["Mowed/disturbed occasionally between April 15  & August 15",null,2]
["Mowed/disturbed frequently April 15 to August 15, or no permanently vegetated buffer",null,1]
[]
["Minimum distance (measured from the center of the field) to the nearest wildlife habitat that provides suitable nesting and/or protective cover."]
["<100 feet",null,10]
["100 – 300 feet",null,7]
["301 – 500 feet",null,3]
[">500 feet",null,1]
[]
["(A) Wetland Habitat Points (60 maximum)",null,null,{"$f":"SUM(D13:D54)","v":0},{"$f":"SUM(E13:E54)","v":0}]
[]
["(B) Wetland Habitat Index (Total Points/60)",null,null,{"$f":"D56/60","v":0},{"$f":"E56/60","v":0}]
[]
["Conservation practices that may be used to improve habitat:"]
["Wetland Restoration (657)"]
["Dike (356)"]
["Structure for Water Control (587)"]
["Riparian Herbaceous Cover (390)"]
["Riparian Forest Buffer (391)"]
["Wetland Wildlife Habitat Mgt. (644)"]

{"sheet":"WoodsWetland","index":7,"n_rows":71,"n_cols":5,"rows_kept":71,"cut":false,"hidden":false,"merged":[[17,0,17,1],[7,3,7,4],[9,0,9,1],[18,0,18,1],[18,3,21,3],[18,4,21,4],[19,0,19,1],[20,0,20,1],[11,0,11,1],[12,0,12,1],[12,3,15,3],[12,4,15,4],[13,0,13,1],[14,0,14,1],[15,0,15,1],[24,4,28,4],[25,0,25,1],[27,0,27,1],[28,0,28,1],[26,0,26,1],[24,3,28,3],[62,0,62,1],[47,0,47,1],[56,0,56,1],[57,0,57,1],[58,0,58,1],[54,0,54,1],[55,0,55,1],[48,0,48,1],[60,0,60,1],[45,0,45,1],[36,3,39,3],[37,0,37,1],[39,0,39,1],[21,0,21,1],[31,3,33,3],[31,0,31,1],[32,0,32,1],[33,0,33,1],[35,0,35,1],[36,0,36,1],[44,0,44,1],[23,0,23,1],[24,0,24,1],[30,0,30,1],[0,0,0,4],[1,0,1,4],[2,3,2,4],[3,3,3,4],[6,3,6,4],[4,2,4,4],[5,2,5,4],[31,4,33,4],[38,0,38,1],[55,3,58,3],[55,4,58,4],[50,0,50,1],[48,4,52,4],[49,0,49,1],[51,0,51,1],[52,0,52,1],[36,4,39,4],[42,4,45,4],[41,0,41,1],[42,0,42,1],[42,3,45,3],[48,3,52,3],[43,0,43,1]]}
["WILDLIFE HABITAT EVALUATION WORKSHEET"]
["WOODLAND - WETLAND RESTORATION"]
["Name:",{"$f":"' Client Info & Instr'!$B$5","v":0},"Farm No.:",{"$f":"' Client Info & Instr'!$B$10","v":0}]
[null,{"$f":"' Client Info & Instr'!$B$6","v":0},"Tract No.:",{"$f":"' Client Info & Instr'!$B$11","v":0}]
["Address:",{"$f":"' Client Info & Instr'!$B$7","v":0}]
[null,{"$f":"' Client Info & Instr'!$B$8","v":0}]
["Date:",{"$f":"' Client Info & Instr'!$B$15","v":"00:00:00"},"Field No.:"]
["Evaluated by:  ",{"$f":"' Client Info & Instr'!$B$14","v":0},"Acres:"]
[]
["WOODLAND - WETLAND RESTORATION HABITAT INDEX",null,"POINTS","BENCHMARK","PLANNED"]
[]
["Canopy composition"]
["6 or more native tree species predominate; several size classes",null,10]
["3-5 native species predominate; several size classes",null,7]
["2 native tree species predominate",null,3]
["1 native tree species predominates, or primarily invasives, or cut-over woodland",null,1]
[]
["Snags and cavity trees (10 inches DBH or larger)"]
["> 4 snags or cavity trees per acre",null,5]
["2-4 snags or cavity trees per acre",null,3]
["1 snag or cavity tree per acre",null,2]
["No snags or cavity trees present",null,1]
[]
["Understory composition"]
["> 90% of understory is comprised of native shrubs, vines, and/or herbaceous plants",null,10]
["75-90% of understory is comprised of native shrubs, vines, and/or herbaceous plants",null,7]
["50-74% understory is comprised of native shrubs, vines, and/or herbaceous plants",null,4]
["25-49% understory is comprised of native shrubs, vines, and/or herbaceous plants",null,2]
["< 25% understory is comprised of native shrubs, vines, and/or herbaceous plants; site is dominated by invasive species (e.g., multiflora rose, Japanese honeysuckle, etc.)  ",null,1]
[]
["Food plots"]
["No food plot",null,5]
["Food plots less than 5% of the restored area; no food plot greater than 1/2 acre",null,3]
["Food plots not meeting criteria above",null,1]
[]
["Wetland hydrology characteristics"]
["> 75% has natural wetland hydrology (includes restoration to the wetland type that naturally occurred on the site",null,20]
["50-75% has natural wetland hydrology",null,14]
["25-49% has natural wetland hydrology",null,6]
["< 25% has natural wetland hydrology",null,2]
[]
["Water regimes"]
["3 or more water regimes (e.g., permanent, semiperminent, seasonal, saturated)",null,10]
["2 water regimes",null,7]
["1 water regime",null,3]
["No wetland hydrology (i.e., wetland hydrology has been removed by drainage, fill, etc.)",null,1]
[]
["Size of wetland (do not include acreage where hydrology is significantly degraded or removed) "]
["More than 50 acres",null,10]
["35-50 acres",null,8]
["20-34.9 acres",null,5]
["5-19.9 acres",null,3]
["Less than 5 acres",null,1]
[]
["Proximity of the site to other lands that provide suitable wildlife habitat for nesting and/or protective cover"]
["<100 feet",null,10]
["100 – 300 feet",null,7]
["301 – 500 feet",null,3]
[">500 feet",null,1]
[]
["(A)  Total Woodland - Wetland Restoration Habitat Points (80 maximum)",null,null,{"$f":"SUM(D13:D59)","v":0},{"$f":"SUM(E13:E59)","v":0}]
[]
["(B)  Woodland - Wetland Restoration Habitat Index (Total points/80)",null,null,{"$f":"D61/80","v":0},{"$f":"E61/80","v":0}]
[]
["Conservation practices that may be used to improve habitat:"]
["Wetland Restoration (657)"]
["Dike (356)"]
["Structure for Water Control (587)"]
["Forest Stand Improvement (666)"]
["Tree/Shrub Establishment (612)"]
["Wetland Wildlife Habitat Mgt. (644)"]

{"sheet":"Woods","index":8,"n_rows":58,"n_cols":5,"rows_kept":58,"cut":false,"hidden":false,"merged":[[13,0,13,1],[14,0,14,1],[15,0,15,1],[17,0,17,1],[11,0,11,1],[12,0,12,1],[0,0,0,4],[1,0,1,4],[2,3,2,4],[3,3,3,4],[9,0,9,1],[6,3,6,4],[7,3,7,4],[5,2,5,4],[4,2,4,4],[18,0,18,1],[19,0,19,1],[20,0,20,1],[23,0,23,1],[21,0,21,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[35,0,35,1],[28,0,28,1],[30,0,30,1],[31,0,31,1],[33,0,33,1],[32,0,32,1],[45,0,45,1],[46,0,46,1],[36,3,40,3],[36,4,40,4],[37,0,37,1],[38,0,38,1],[39,0,39,1],[40,0,40,1],[36,0,36,1],[31,3,33,3],[31,4,33,4],[49,0,49,1],[51,0,51,1],[12,3,15,3],[12,4,15,4],[18,3,21,3],[18,4,21,4],[24,3,28,3],[24,4,28,4],[24,0,24,1],[42,0,42,1],[43,0,43,1],[43,3,46,3],[43,4,46,4],[44,0,44,1]]}
["WILDLIFE HABITAT EVALUATION WORKSHEET"]
["WOODLAND"]
["Name:",{"$f":"' Client Info & Instr'!$B$5","v":0},"Farm No.:",{"$f":"' Client Info & Instr'!$B$10","v":0}]
[null,{"$f":"' Client Info & Instr'!$B$6","v":0},"Tract No.:",{"$f":"' Client Info & Instr'!$B$11","v":0}]
["Address:",{"$f":"' Client Info & Instr'!$B$7","v":0}]
[null,{"$f":"' Client Info & Instr'!$B$8","v":0}]
["Date:",{"$f":"' Client Info & Instr'!$B$15","v":"00:00:00"},"Field No.:"]
["Evaluated by:  ",{"$f":"' Client Info & Instr'!$B$14","v":0},"Acres:"]
[]
["WOODLAND HABITAT INDEX",null,"POINTS","BENCHMARK","PLANNED"]
[]
["Composition"]
["6 or more native tree species predominate; several size classes",null,10]
["3-5 native species predominate; several size classes",null,7]
["2 native tree species predominate",null,3]
["1 native tree species predominates, or primarily invasives, or cut-over woodland, or not woodland",null,1]
[]
["Snags and Cavity Trees (10 inches DBH or larger)"]
["> 4 snags or cavity trees per acre",null,10]
["2-4 snags or cavity trees per acre",null,7]
["1 snag or cavity tree per acre",null,3]
["No snags or cavity trees present",null,1]
[]
["Understory Composition"]
["> 90% of understory is comprised of native shrubs, vines, and/or herbaceous plants",null,10]
["75-90% of understory is comprised of native shrubs, vines, and/or herbaceous plants",null,7]
["50-74% understory is comprised of native shrubs, vines, and/or herbaceous plants",null,4]
["25-49% understory is comprised of native shrubs, vines, and/or herbaceous plants",null,2]
["< 25% understory is comprised of native shrubs, vines, and/or herbaceous plants (site is dominated by invasive species, e.g., multiflora rose, Japanese honeysuckle, etc.), or not woodland   ",null,1]
[]
["Food Plots"]
["No food plot",null,5]
["Food plots less than 5% of the woodland area; no food plot greater than 1/2 acre",null,3]
["Food plots not meeting criteria above, or not woodland",null,1]
[]
["Use by domestic animals or humans"]
["No or minimal disturbance; > 95% ground cover (i.e., leaf litter, duff layer)",null,10]
["Light grazing pressure; 85 - 95% ground cover",null,8]
["Moderate grazing pressure; 75 - 84% ground cover",null,6]
["Heavy grazing pressure; < 75% ground cover",null,2]
["Frequent human disturbance (e.g., recreational area), or not woodland",null,1]
[]
["Size of woodland"]
["100 acres or greater",null,10]
["50 - 99 acres",null,7]
["25 - 49 acres",null,5]
["< 25 acres, or not woodland",null,1]
[]
[]
["(A)  Total Woodland Habitat Points (55 maximum)",null,null,{"$f":"SUM(D13:D47)","v":0},{"$f":"SUM(E13:E47)","v":0}]
[]
["(B)  Woodland Habitat Index (Total points/55)",null,null,{"$f":"D50/55","v":0},{"$f":"E50/55","v":0}]
[]
["Conservation practices that may be used to improve habitat: "]
["Forest Stand Improvement (666)"]
["Tree/Shrub Establishment (612)"]
["Tree/Shrub Site Preparation (490) "]
["Upland Wildlife Habitat Mgt. (645)"]

{"sheet":"Sum","index":9,"n_rows":67,"n_cols":9,"rows_kept":67,"cut":false,"hidden":false,"merged":[[55,0,56,2],[55,3,56,5],[55,6,56,8],[9,6,10,8],[30,2,30,5],[31,2,31,5],[32,2,32,5],[9,0,10,2],[9,3,10,5],[0,0,0,8],[1,0,1,8],[2,1,2,5],[2,7,2,8],[7,1,7,5],[3,7,3,8],[6,7,6,8],[7,7,7,8],[3,1,3,5],[4,1,4,5],[5,1,5,5],[6,1,6,5],[4,6,4,8],[5,6,5,8]]}
["HABITAT SUITABILITY INDEX WORKSHEET"]
["SUMMARY"]
["Name:",{"$f":"' Client Info & Instr'!$B$5","v":0},null,null,null,null,"Farm No.:",{"$f":"' Client Info & Instr'!$B$10","v":0}]
[null,{"$f":"' Client Info & Instr'!$B$6","v":0},null,null,null,null,"Tract No.:",{"$f":"' Client Info & Instr'!$B$11","v":0}]
["Address:",{"$f":"' Client Info & Instr'!$B$7","v":0}]
[null,{"$f":"' Client Info & Instr'!$B$8","v":0}]
["Date:",{"$f":"' Client Info & Instr'!$B$15","v":"00:00:00"},null,null,null,null,"County:",{"$f":"' Client Info & Instr'!$B$12","v":0}]
["Evaluated by:  ",{"$f":"' Client Info & Instr'!$B$14","v":0}]
[]
[null,null,null,"BENCHMARK (BEFORE) CONDITION",null,null,"PLANNED (AFTER) CONDITION"]
[]
["(a)","(b)","(c)","(d)","(e)","(f)","(g)","(h)","(i)"]
["HABITAT TYPE\n(LAND USE)","FIELD NO.","ACRES","(HSI)","WEIGHTED INDEX ","OVERALL INDEX","(HSI)","WEIGHTED INDEX ","OVERALL INDEX"]
[null,null,null,null,"(Column c  X Column d)","(Total Column e /  Total Column c)",null,"(Column c  X Column g)","(Total Column h  /  Total Column c)"]
[null,{"$f":"VLOOKUP($A15,$A$59:$I$67,2,FALSE)","v":0},{"$f":"VLOOKUP($A15,$A$59:$I$67,3,FALSE)","v":0},{"$f":"VLOOKUP($A15,$A$59:$I$67,4,FALSE)","v":0},{"$f":"IF(C15=0,\"  \",C15*D15)","v":"  "},null,{"$f":"VLOOKUP($A15,$A$59:$I$67,7,FALSE)","v":0},{"$f":"IF(C15=0,\"  \",C15*G15)","v":"  "}]
[null,0,0,0,{"$f":"IF(C16=0,\"  \",C16*D16)","v":"  "},null,0,{"$f":"IF(C16=0,\"  \",C16*G16)","v":"  "}]
[null,0,0,0,"  ",null,0,{"$f":"IF(C17=0,\"  \",C17*G17)","v":"  "}]
[null,0,0,0,"  ",null,0,"  "]
[null,0,0,0,"  ",null,0,"  "]
[null,0,0,0,"  ",null,0,"  "]
[null,0,0,0,"  ",null,0,"  "]
[null,0,0,0,"  ",null,0,"  "]
[null,0,0,0,"  ",null,0,"  "]
[null,0,0,0,"  ",null,0,"  "]
[null,0,0,0,"  ",null,0,"  "]
[null,0,0,0,"  ",null,0,"  "]
[null,0,0,0,"  ",null,0,"  "]
[null,0,0,0,"  ",null,0,"  "]
[null,0,0,0,"  ",null,0,"  "]
["TOTALS",null,null,null,{"$f":"IF(SUM(E15:E29)=0,\"  \", SUM(E15:E29))","v":"  "},{"$f":"IF(SUM(E15:E29)=0,\" \",E30/C30)","v":" "},null,{"$f":"IF(SUM(H15:H29)=0,\"  \", SUM(H15:H29))","v":"  "},{"$f":"IF(SUM(H15:H29)=0, \"  \",H30/C30)","v":"  "}]
[]
[null,null,"Habitat Suitability Index"]
[null,null,"Net Effect of Plan"]
[]
[{"$f":"I30","v":"  "},"(Overall Index Planned)   -",null,{"$f":"F30","v":" "},"(Overall Index Benchmark)   = ",null,{"$f":"IF(SUM(C15:C29)=0, \"  \",I30-F30)","v":"  "}," (Net Effect of Plan)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"BENCHMARK (BEFORE) CONDITION",null,null,"PLANNED (AFTER) CONDITION"]
[]
["Habitat Type","Field No.","Acres","(HSI)","Weighted Index","Overall Index","(HSI)","Weighted Index","Overall Index"]
[0,0,0,0,0,0,0,0,0]
["Cropland",{"$f":"Crop!$D$7","v":0},{"$f":"Crop!$D$8","v":0},{"$f":"Crop!$D$50","v":0},null,null,{"$f":"Crop!$E$50","v":0}]
["Grass/Past/Hay",{"$f":"Grass!$D$7","v":0},{"$f":"Grass!$D$8","v":0},{"$f":"Grass!$D$49","v":0},null,null,{"$f":"Grass!$E$49","v":0}]
["Hedgerow",{"$f":"HdgRow!$D$7","v":0},{"$f":"HdgRow!$D$8","v":0},{"$f":"HdgRow!$D$45","v":0},null,null,{"$f":"HdgRow!$E$45","v":0}]
["Riparian Corridor",{"$f":"Riparian!$D$7","v":0},{"$f":"Riparian!$D$8","v":0},{"$f":"Riparian!$D$42","v":0},null,null,{"$f":"Riparian!$E$42","v":0}]
["Shallow Water",{"$f":"'Shallow Water'!$D$7","v":0},{"$f":"'Shallow Water'!$D$8","v":0},{"$f":"'Shallow Water'!$D$52","v":0},null,null,{"$f":"'Shallow Water'!$E$52","v":0}]
["Wetland",{"$f":"Wetland!$D$7","v":0},{"$f":"Wetland!$D$8","v":0},{"$f":"Wetland!$D$58","v":0},null,null,{"$f":"Wetland!$E$58","v":0}]
["Woodland",{"$f":"Woods!$D$7","v":0},{"$f":"Woods!$D$8","v":0},{"$f":"Woods!$D$52","v":0},null,null,{"$f":"Woods!$E$52","v":0}]
["Woodland-Wetland",{"$f":"WoodsWetland!$D$7","v":0},{"$f":"WoodsWetland!$D$8","v":0},{"$f":"WoodsWetland!$D$63","v":0},null,null,{"$f":"WoodsWetland!$E$63","v":0}]

{"sheet":"Sum-Multi","index":10,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":true,"merged":[[1,11,1,13],[2,11,10,13],[0,0,0,9],[1,0,1,9],[2,1,2,5],[2,8,2,9],[3,1,3,5],[3,8,3,9],[4,1,4,5],[5,1,5,5],[6,1,6,5],[6,8,6,9],[4,7,4,9],[5,7,5,9],[31,0,31,9],[7,1,7,5],[7,8,7,9],[9,0,10,2],[9,3,10,5],[9,7,10,9],[30,2,30,5]]}
["HABITAT SUITABILITY INDEX WORKSHEET"]
["MULTI-LAND CLASSIFICATION SUMMARY",null,null,null,null,null,null,null,null,null,null,"Instructions"]
["Name:",{"$f":"' Client Info & Instr'!$B$5","v":0},null,null,null,null,null,"Farm No.:",{"$f":"' Client Info & Instr'!$B$10","v":0},null,null,"Use the completed Evaluation\nWorksheets to fill in the green\nand yellow boxes for the before\n(benchmark) and (after) planned conditions for each land use.\nDifferentiate all land uses by entering the applicable field numbers.\nThe weighted (HSI) for all the acres of planned land uses will be displayed."]
[null,{"$f":"' Client Info & Instr'!$B$6","v":0},null,null,null,null,null,"Tract No.:",{"$f":"' Client Info & Instr'!$B$11","v":0}]
["Address:",{"$f":"' Client Info & Instr'!$B$7","v":0}]
[null,{"$f":"' Client Info & Instr'!$B$8","v":0}]
["Date:",{"$f":"' Client Info & Instr'!$B$15","v":"00:00:00"},null,null,null,null,null,"County:",{"$f":"' Client Info & Instr'!$B$12","v":0}]
["Evaluated by:  ",{"$f":"' Client Info & Instr'!$B$14","v":0}]
[]
[null,null,null,"BENCHMARK (BEFORE) CONDITION",null,null,null,"PLANNED (AFTER) CONDITION"]
[]
["(a)","(b)","(c)","(d)","(e)","(f)","(g)","(h)","(i)","(j)"]
["HABITAT TYPE\n(LAND USE)","FIELD\nNUMBERS","ACRES","(HSI)","WEIGHTED INDEX ","OVERALL INDEX","HABITAT TYPE\n(LAND USE)","(HSI)","WEIGHTED INDEX ","NET INDEX (Each)\nCol (h) - Col (d)"]
["BENCHMARK\nCONDITION",null,null,null,"Column (c)  x Column (d)","(Total Column e /  Total Column c)","PLANNED\nCONDITION",null,"Column (c)  x Column (h)","OVERALL INDEX\nTot Col (h) / \nTot Col (c)"]
[null,null,null,null,{"$f":"IF(C15=0,\" \",C15*D15)","v":" "},null,null,null,{"$f":"IF(C15=0,\" \",C15*H15)","v":" "},{"$f":"H15-D15","v":0},null,"Habitat Type"]
[null,null,null,null,{"$f":"IF(C16=0,\" \",C16*D16)","v":" "},null,null,null,{"$f":"IF(C16=0,\" \",C16*H16)","v":" "},{"$f":"H16-D16","v":0},null,0]
[null,null,null,null," ",null,null,null," ",0,null,"Cropland"]
[null,null,null,null," ",null,null,null," ",0,null,"Grass/Past/Hay"]
[null,null,null,null," ",null,null,null," ",0,null,"Hedgerow"]
[null,null,null,null," ",null,null,null," ",0,null,"Riparian Corridor"]
[null,null,null,null," ",null,null,null," ",0,null,"Shallow Water"]
[null,null,null,null," ",null,null,null," ",0,null,"Wetland"]
[null,null,null,null," ",null,null,null," ",0,null,"Woodland"]
[null,null,null,null," ",null,null,null," ",0,null,"Woodland-Wetland"]
[null,null,null,null," ",null,null,null," ",0]
[null,null,null,null," ",null,null,null," ",0]
[null,null,null,null," ",null,null,null," ",0]
[null,null,null,null," ",null,null,null," ",0]
[null,null,null,null," ",null,null,null," ",0]
["TOTALS",null,{"$f":"SUM(C15:C29)","v":0},null,{"$f":"IF(SUM(E15:E29)=0,\"  \", SUM(E15:E29))","v":"  "},{"$f":"IF(SUM(E15:E29)=0,\" \",E30/C30)","v":" "},null,null,{"$f":"IF(SUM(I15:I29)=0,\"  \", SUM(I15:I29))","v":"  "},{"$f":"IF(SUM(I15:I29)=0, \"  \",I30/C30)","v":"  "}]
[]
["Habitat Suitability Index Net Effect of Plan"]
[]
[{"$f":"J30","v":"  "},"(Overall Index Planned)   -",null,{"$f":"F30","v":" "},"(Overall Index Benchmark)   = ",null,null,{"$f":"IF(SUM(C15:C29)=0, \"  \",J30-F30)","v":"  "}," (Net Effect of Plan)"]