{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Expanded Mace Form"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"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":"Expanded Mace Form","index":0,"n_rows":219,"n_cols":9,"rows_kept":219,"cut":false,"hidden":false,"merged":[[138,1,138,8],[139,1,139,8],[140,1,140,8],[99,1,99,5],[100,2,100,5],[101,2,101,5],[102,2,102,5],[133,1,133,6],[134,1,134,6],[136,1,136,6],[128,1,128,6],[130,1,130,5],[131,1,131,6],[132,1,132,6],[112,1,112,6],[114,1,114,5],[125,2,125,5],[126,5,126,6],[115,1,115,5],[116,2,116,5],[117,2,117,5],[118,2,118,5],[106,2,106,5],[107,2,107,5],[108,2,108,5],[124,2,124,5],[34,2,34,5],[36,5,36,6],[39,2,39,5],[40,5,40,6],[41,5,41,6],[105,1,105,5],[90,2,90,5],[91,2,91,5],[92,5,92,6],[119,5,119,6],[121,1,121,5],[122,2,122,5],[123,2,123,5],[94,1,94,6],[98,1,98,6],[83,2,83,5],[84,2,84,5],[85,5,85,6],[87,1,87,5],[88,2,88,5],[89,2,89,5],[76,2,76,5],[77,2,77,5],[78,5,78,6],[80,1,80,5],[81,2,81,5],[82,2,82,5],[68,2,68,5],[69,5,69,6],[73,1,73,5],[74,2,74,5],[75,2,75,5],[71,1,71,6],[62,2,62,5],[63,5,63,6],[65,1,65,5],[66,2,66,5],[67,2,67,5],[55,5,55,6],[57,1,57,5],[58,2,58,5],[59,2,59,5],[60,2,60,5],[61,2,61,5],[49,1,49,5],[50,1,50,5],[51,2,51,5],[52,2,52,5],[53,2,53,5],[54,2,54,5],[45,5,45,6],[47,1,47,6],[48,1,48,5],[38,2,38,5],[43,1,43,5],[44,2,44,5],[31,5,31,6],[13,1,13,5],[14,2,14,5],[19,2,19,5],[24,2,24,5],[25,5,25,6],[17,5,17,6],[15,2,15,5],[16,2,16,5],[20,2,20,5],[21,2,21,5],[22,5,22,6],[29,2,29,5],[96,2,96,6],[103,5,103,6],[0,0,0,3],[0,4,0,8],[1,0,1,8],[2,7,2,8],[3,0,3,3],[3,6,3,8],[7,0,7,3],[7,6,7,8],[8,0,8,8],[9,0,9,8],[11,1,11,5],[12,1,12,5],[10,0,10,8],[4,0,4,3],[4,6,4,8],[5,0,5,3],[5,6,5,8],[6,0,6,3],[6,6,6,8],[27,1,27,5],[28,2,28,5],[33,2,33,5]]}
["NRCS ",null,null,null,"Wildlife Habitat Evaluation Guide – Pollinator Habitat"]
[]
[null,null,null,null,null,null,null,"February 2012"]
["Owner/Operator:",null,null,null,null,"  District:"]
["County:",null,null,null,null,"  Field Office:"]
["Assisted By:",null,null,null,null,"  Acres:"]
["Location:",null,null,null,null,"  Date:"]
["Farm & Tract #:",null,null,null,null,"  Contract #:"]
[]
["General Information: Refer to the Colorado Pollinator Job Sheet at http://efotg.nrcs.usda.gov/references/public/CO/PollinatorJS.pdf for guidelines on polllinator plantings, and to Biology Technical Note Number 47 for more information about the role pollinators play in our environment. Program specific guidance (e.g. CRP) must also be followed where appropriate.\n"]
["Using this WHEG: Fill in the yellow boxes with the most appropriate response for the site. The spreadsheet will do the calculations. If the average scores in the orange boxes are below 0.5, you should plan practices to raise that score to 0.5 or higher. Note, if you are doing a manual calculation in the field, the maximum score for  Items  3b, 4a, and 4b is 1.0, regardless of the total factors counted."]
[]
[null,"Nesting Sites for Native Bees\nEnter your responses to the factors in the yellow boxes. The score will automatically be calculated and entered in the green boxes."]
[null,"1a) Sites for Ground-Nesting Bees",null,null,null,null,"Value","Before","After"]
[null,null,"Numerous areas of well-drained, bare soil or with sparse vegetationa",null,null,null,1]
[null,null,"Moderate number of areas",null,null,null,0.5]
[null,null,"Few areas",null,null,null,0.1]
[null,null,null,null,null,"Enter value here ------->",null," "," "]
[]
[null,null,"Numerous areas with sandy to sandy loam soilb",null,null,null,1]
[null,null,"Moderate number of areas",null,null,null,0.5]
[null,null,"Few areas",null,null,null,0.1]
[null,null,null,null,null,"Enter value here ------->",null," "," "]
[]
[null," ","No-till cropping system: 0.1 points for every 10% of area untilled",null,null,null,"0.0-1.0"," "," "]
[null,null,null,null,null,"Highest Value from 1a",null,{"$f":"MAX(H18,H23,H25)","v":0},{"$f":"MAX(I18,I23,I25)","v":0}]
[]
[null,"1b) Sites for Wood and Cavity-Nesting Beesc",null,null,null,null,"Value","Before","After"]
[null," ","Dead wood, brush piles, or snags present-numerous areas",null,null,null,1]
[null,null,"Moderate number of areas",null,null,null,0.5]
[null,null,"Few areas",null,null,null,0.1," "]
[null,null,null,null,null,"Enter value here ------->"]
[]
[null,null,"Pithy twigs (elderberry, cane fruit, sumac, etc.)-numerous plants",null,null,null,1]
[null,null,"Moderate number of plants",null,null,null,0.5]
[null," ","Few plants",null,null,null,0.1]
[null,null,null,null,null,"Enter value here ------->"]
[]
[null," ","Overgrown native bunch grasses (clump-forming) present",null,null,null,0.5," "]
[null,null,"Sod forming grasses or monocultures only",null,null,null,0.1]
[null,null,null,null,null,"Enter value here ------->"]
[null,null,null,null,null,"Highest Value from 1b",null,{"$f":"MAX(H32,H37,H41)","v":0},{"$f":"MAX(I32,I37,I41)","v":0}]
[]
[null,"1c )Supplementary Wood and Cavity-Nesting Sites. ",null,null,null,null,"Value","Before","After"]
[null,null,"Nest blocks: 0.1 point for every one placed in the field (at least 50 feet between blocks)",null,null,null,"0.0-1.0"]
[null,null,null,null,null,null,null,{"$f":"H45","v":0},{"$f":"I45","v":0}]
[]
[null,"1) Average of 1a & 1b plus 1c  ---------------------------------------------------------------------->",null,null,null,null,null,{"$f":"IF((AVERAGE(H26,H42)+H46)<1, AVERAGE(H26,H42)+H46, 1)","v":0},{"$f":"IF((AVERAGE(I26,I42)+I46)<1, AVERAGE(I26,I42)+I46, 1)","v":0}]
[]
[null,"Foraging Habitat\nEnter your response in the yellow boxes. Pick one response fo each subfactor (e.g. one response for 2a, one for 2b, etc.)"]
[null,"2a Percent of non-cropped vegetation within 1/2 mile of site",null,null,null,null,"Value","Before","After"]
[null,null,">30%",null,null,null,1]
[null,null,"20-30%",null,null,null,0.7]
[null,null,"5-19%",null,null,null,0.3]
[null,null,"<5%",null,null,null,0]
[null,null,null,null,null,"Enter value here ------->"]
[]
[null,"2b Dominant vegetation in non-cropped area within 1/2 mile of site",null,null,null,null,"Value","Before","After"]
[null,null,"Native plants",null,null,null,1]
[null,null,"Mix of native and naturalized (non-invasive) plants",null,null,null,0.7]
[null,null,"Naturalized flowering species (alfalfa, etc.)",null,null,null,0.5]
[null,null,"Invasive flowering weeds",null,null,null,0]
[null,null,"Sod-forming grasses or monocultures",null,null,null,0]
[null,null,null,null,null,"Enter value here ------->"]
[]
[null,"2c Percentage of vegetative cover (non-crop area) that is forbs or flowering shrubs within 1/2 mile of site",null,null,null,null,"Value","Before","After"]
[null,null,">9% cover",null,null,null,1]
[null,null,"5-9% cover",null,null,null,0.5]
[null,null,"<5% cover",null,null,null,0.1]
[null,null,null,null,null,"Enter value here ------->"]
[]
[null,"2-1) Average of 2a + 2b + 2c  ---------------------------------------------------------------------->",null,null,null,null,null,{"$f":"AVERAGE(H56,H64,H70)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(I56,I64,I70)","v":{"$error":"#DIV/0!"}}]
[]
[null,"2d Number of species of forbs and flowering shrubs on farm that bloom in spring (including crops)",null,null,null,null,"Value","Before","After"]
[null,null,"5+ species",null,null,null,1]
[null,null,"3-4 species",null,null,null,0.5]
[null,null,"1-2 species",null,null,null,0.3]
[null,null,"0 species",null,null,null,0]
[null,null,null,null,null,"Enter value here ------->"]
[]
[null,"2e Number of species of forbs and flowering shrubs on farm that bloom in summer (including crops)",null,null,null,null,"Value","Before","After"]
[null,null,"5+ species",null,null,null,1," "]
[null,null,"3-4 species",null,null,null,0.5]
[null,null,"1-2 species",null,null,null,0.3]
[null,null,"0 species",null,null,null,0]
[null,null,null,null,null,"Enter value here ------->"]
[]
[null,"2f  Number of species of forbs and flowering shrubs on farm that bloom in fall (including crops)",null,null,null,null,"Value","Before","After"]
[null,null,"5+ species",null,null,null,1]
[null,null,"3-4 species",null,null,null,0.5]
[null,null,"1-2 species",null,null,null,0.3]
[null,null,"0 species",null,null,null,0]
[null,null,null,null,null,"Enter value here ------->"]
[]
[null,"2-2) Minimum of 2d + 2e +2f  --------------------------------------------------------------------->",null,null,null,null,null,{"$f":"MIN(H79,H86,H93)","v":0},{"$f":"MIN(I79,I86,I93)","v":0}]
[]
[null,"2)","Minimum of 2-1 & 2-2",null,null,null,null,{"$f":"MIN(H72,H95)","v":{"$error":"#DIV/0!"}},{"$f":"MIN(I72,I95)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Landscape Features\nEnter your response in the yellow boxes. Pick one response fo each subfactor (e.g. one response for 2a, one for 2b, etc.)"]
[null,"3a) Percentage of field in pollinator plots",null,null,null,null,"Value","Before","After"]
[null,null,">9% of the field devoted to pollinator plots",null,null,null,1]
[null,null,"5-9% of the field in pollinator plots",null,null,null,0.5]
[null,null,"<5% of the field in pollinator plots",null,null,null,0.1]
[null,null,null,null,null,"Enter value here ------->"]
[]
[null,"3b Additional landscape features within one mile-Score all that apply-Maximum score of 1.0",null,null,null,null,"Value","Before","After"]
[null,null,"Riparian buffers: 0.1 points for every 20% of area within 25 feet of water feature that is vegetated",null,null,null,"0.0-0.5"]
[null,null,"Hedgerows or fencerows of diverse shrub species",null,null,null,0.5]
[null,null,"Flowering cover crops, bee pasture, bolting crops",null,null,null,0.5]
[null,null,"Source of clean surface water (non-contaminated)",null,null,null,0.3]
[null,null,null,null,null,null,null,0,0]
[]
[null,"3) Sum 3a + 3b (maximum 1.0) ------------------------------------------------------------------------>",null,null,null,null,null,{"$f":"IF(SUM(H104,H111)<1,SUM(H104,H111),1)","v":0},{"$f":"IF(SUM(I104,I111)<1,SUM(I104,I111),1)","v":0}]
[]
[null,"Farm Practices\nScore all that apply"]
[null,"4a) Use of pesticides",null,null,null,null,"Value","Before","After"]
[null,null,"No use of pesticides",null,null,null,1]
[null,null,"IPM plan to decrease pollinator direct contact risk is being applied ",null,null,null,1]
[null,null,"An IPM plan to decrease pollinator direct contact risk will be developed and applied",null,null,null,0.5]
[null,null,null,null,null,null,null,{"$f":"IF(SUM(H117,H118,H119)<1,SUM(H117,H118,H119),1)","v":0},{"$f":"IF(SUM(I117,I118,I119)<1,SUM(I117,I118,I119),1)","v":0}]
[]
[null,"4b) Land management techniques-Score all that apply-Maximum score of 1.0",null,null,null,null,"Value","Before","After"]
[null,null,"No more than 1/3 of area is burned, mowed, or hayed each year",null,null,null,1]
[null,null,"Grazing plan that encourages wildflower diversity/abundance",null,null,null,1]
[null,null,"Reduced cultivation for weed control (for ground nesting pollinators)",null,null,null,1]
[null,null,"No disturbance of field borders",null,null,null,0.5]
[null,null,null,null,null,null,null,{"$f":"IF(SUM(H123,H124,H125,H126)<1,SUM(H123,H124,H125,H126),1)","v":0},{"$f":"IF(SUM(I123,I124,I125,I126)<1,SUM(I123,I124,I125,I126),1)","v":0}]
[]
[null,"4) Sum 4a + 4b (maximum 1.0)  -------------------------------------------------------------------------->",null,null,null,null,null,{"$f":"IF(SUM(H120,H127)<1,SUM(H120,H127),1)","v":0},{"$f":"IF(SUM(I120,I127)<1,SUM(I120,I127),1)","v":0}]
[]
[null,"HSI Scores",null,null,null,null,null,"Before","After"]
[null,"Nesting, Overwintering, & Larval Host Sites -------------------------------------------------------->",null,null,null,null,null,{"$f":"H48","v":0},{"$f":"I48","v":0}]
[null,"Foraging Sites ------------------------------------------------------------------------------------------------->",null,null,null,null,null,{"$f":"H97","v":{"$error":"#DIV/0!"}},{"$f":"I97","v":{"$error":"#DIV/0!"}}]
[null,"Pesticide Protection  ---------------------------------------------------------------------------------------->",null,null,null,null,null,{"$f":"H113","v":0},{"$f":"I113","v":0}]
[null,"Overall Site Selection & Management ---------------------------------------------------------------->",null,null,null,null,null,{"$f":"H129","v":0},{"$f":"I129","v":0}]
[]
[null,"Overall HSI  ----------------------------------------------------------------------------------------------->",null,null,null,null,null,{"$f":"MIN(H132:H135)","v":{"$error":"#DIV/0!"}},{"$f":"MIN(I132:I135)","v":{"$error":"#DIV/0!"}}]
[]
[null,"a: Numerous/abundant equals a total of 25% or more bare ground, arranged so that soil erosion is not excessive. Moderate is 5-25% bare ground. Sparse is <5% bare ground."]
[null,"b: Numerous/abundant equals 50% of the area in these soils. 25-50% is moderate. Sparse is <25%."]
[null,"c: Numerous equals more than 5 patches or plants/acre. Moderate equals 2-5. Few equals 1."]
[null,null,"Service Center",null,"Counties","Conservation District"]
[null,null,"Akron",null,"ADAMS","Agate"]
[null,null,"Alamosa",null,"ALAMOSA","Baca County"]
[null,null,"Brighton",null,"ARAPAHOE","Bent County"]
[null,null,"Burlington",null,"ARCHULETA","Big Thompson"]
[null,null,"Byers",null,"BACA","Bookcliff"]
[null,null,"Canon City",null,"BENT","Boulder Valley"]
[null,null,"Center",null,"BOULDER","Branson-Trinchera"]
[null,null,"Cheyenne Wells",null,"BROOMFIELD","Burlington"]
[null,null,"Colorado Springs",null,"CHAFFEE","Centennial"]
[null,null,"Cortez",null,"CHEYENNE","Center"]
[null,null,"Craig",null,"CLEAR CREEK","Central Colorado"]
[null,null,"Delta",null,"CONEJOS","Cheyenne"]
[null,null,"Dove Creek",null,"COSTILLA","Colorado First"]
[null,null,"Durango",null,"CROWLEY","Conejos County"]
[null,null,"Eads",null,"CUSTER","Cope"]
[null,null,"Flagler",null,"DELTA","Costilla"]
[null,null,"Fort Collins",null,"DENVER","Custer County-Divide"]
[null,null,"Fort Morgan",null,"DOLORES","DeBeque-Plateau Valley"]
[null,null,"Franktown",null,"DOUGLAS","Deertrail"]
[null,null,"Glenwood Springs",null,"EAGLE","Delta"]
[null,null,"Grand Junction",null,"EL PASO","Dolores"]
[null,null,"Greeley",null,"ELBERT","Double El"]
[null,null,"Gunnison",null,"FREMONT","Douglas County"]
[null,null,"Holly",null,"GARFIELD","Douglas Creek"]
[null,null,"Holyoke",null,"GILPIN","Dove Creek"]
[null,null,"Hugo",null,"GRAND","Eagle County"]
[null,null,"Ignacio",null,"GUNNISON","East Adams"]
[null,null,"Julesburg",null,"HINSDALE","East Otero"]
[null,null,"Kremmling",null,"HUERFANO","El Paso "]
[null,null,"La Jara",null,"JACKSON","Flagler"]
[null,null,"Lamar",null,"JEFFERSON","Fort Collins"]
[null,null,"Las Animas",null,"KIOWA","Fremont"]
[null,null,"Longmont",null,"KIT CARSON","Gunnison"]
[null,null,"Meeker",null,"LA PLATA","Haxtun"]
[null,null,"Metro",null,"LAKE","High Plains"]
[null,null,"Monte Vista",null,"LARIMER","Jefferson"]
[null,null,"Montrose",null,"LAS ANIMAS","Kiowa"]
[null,null,"Northeast Prowers",null,"LINCOLN","Kiowa County"]
[null,null,"Norwood",null,"LOGAN","La Plata"]
[null,null,"Pagosa Springs",null,"MESA","Lake County"]
[null,null,"Pueblo",null,"MINERAL","Longmont"]
[null,null,"Rocky Ford",null,"MOFFAT","Mancos"]
[null,null,"Salida",null,"MONTEZUMA","Mesa"]
[null,null,"San Luis",null,"MONTROSE","Middle Park"]
[null,null,"Silvercliff",null,"MORGAN","Morgan"]
[null,null,"Simla",null,"OTERO","Mosca-Hooper"]
[null,null,"Springfield",null,"OURAY","Mount Sopris"]
[null,null,"Steamboat Springs",null,"PARK","North Park"]
[null,null,"Sterling",null,"PHILLIPS","Northeast Prowers"]
[null,null,"Towaoc",null,"PITKIN","Olney-Boone"]
[null,null,"Trinidad",null,"PROWERS","Pine River"]
[null,null,"Walden",null,"PUEBLO","Platte Valley"]
[null,null,"Walsenburg",null,"RIO BLANCO","Prairie"]
[null,null,"Woodland Park",null,"RIO GRANDE","Prowers"]
[null,null,"Wray",null,"ROUTT","Rio Grande"]
[null,null,"Yuma",null,"SAGUACHE","Routt County"]
[null,null,null,null,"SAN JUAN","San Juan"]
[null,null,null,null,"SAN MIGUEL","San Miguel Basin"]
[null,null,null,null,"SEDGWICK","Sedgwick County"]
[null,null,null,null,"SUMMIT","Shavano"]
[null,null,null,null,"TELLER","South Platte"]
[null,null,null,null,"WASHINGTON","South Pueblo County"]
[null,null,null,null,"WELD","South Side"]
[null,null,null,null,"YUMA","Southeast Weld"]
[null,null,null,null,null,"Spanish Peaks-Purgatorie River"]
[null,null,null,null,null,"Teller-Park"]
[null,null,null,null,null,"Turkey Creek"]
[null,null,null,null,null,"Upper Arkansas"]
[null,null,null,null,null,"Upper Huerfano"]
[null,null,null,null,null,"Washington County"]
[null,null,null,null,null,"West Adams"]
[null,null,null,null,null,"West Arapahoe"]
[null,null,null,null,null,"West Greeley"]
[null,null,null,null,null,"West Otero-Timpas"]
[null,null,null,null,null,"White River"]
[null,null,null,null,null,"Yuma"]
[null,null,null,null,null,"Yuma County"]