{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Instructions","Master Page","Seeding Plan","643 CREP CP23A Buffer","327 CREP CP2 Monarch Food Plot","327 CREP CP2 & CP23 Buffer","393 CREP CP21 Filter Strip ","657 CREP Wet-Sedge Meadow CP23A","657 CREP Emergent Fringe CP23A"],"not_rendered":{"charts":0,"images":17,"macros":1,"external_links":1,"defined_names":50,"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":"Instructions","index":0,"n_rows":21,"n_cols":1,"rows_kept":21,"cut":false,"hidden":false,"merged":[[17,0,17,9],[18,0,18,9],[19,0,19,9],[20,0,20,9],[14,0,14,9],[15,0,15,9],[12,0,12,9],[9,0,9,9],[16,0,16,9],[7,0,7,9],[13,0,13,9],[10,0,10,9],[11,0,11,9],[0,0,0,9],[1,0,1,9],[2,0,2,9],[3,0,3,9],[8,0,8,9],[4,0,4,9],[5,0,5,9],[6,0,6,9]]}
["INSTRUCTIONS"]
[]
["Step 1 -  Utilize the appropriate seed calculator spreadsheet (327, 643 etc) to design the proposed seed mixture. Additionally, fill in the following information on the design sheet:"]
["* Landowner Name"]
["* Planner Name"]
["* Tract and Farm Number as appropriate"]
["* Acreage to be seeded"]
[]
["Step 2 -  Upon validation that the mixture meets NRCS standards and specifications, Click the Green \"Copy to Seed Plan\" button in the upper right hand portion of the design spreadsheet."]
[]
["Step 3 - The Seeding Plan will be auto-populated with the selected species and quantities from the design spreadsheet as well as the information entered in Step 1. "]
["* Planner shall select the \"Type of Seeding\" from the drop down box. "]
["* If desired, unused rows may be hidden using the green \"Hide/Unhide Extra Rows\" button."]
[]
["Step 4 - Select the following recommendations from the appropriate drop down boxes."]
["* Seed Dates"]
["* Seeding Method and Site Preparation"]
["* Companion Crop"]
["* Fertilizer Recommendation (Introduced Grass/Legume Mixtures Only)"]
[]
["Step 5 - Select green \"Print\" button to print the seeding plan."]

{"sheet":"Master Page","index":1,"n_rows":179,"n_cols":13,"rows_kept":179,"cut":false,"hidden":true,"merged":[[166,5,167,12],[69,13,71,13],[73,4,73,12],[143,0,143,2],[150,0,150,12],[156,5,156,7],[158,5,158,7],[69,12,72,12],[15,0,15,2],[32,0,32,2],[68,8,68,9],[69,0,71,0],[69,6,71,6],[10,0,12,0],[10,12,12,12],[13,2,14,2],[13,6,14,6],[13,7,14,7],[13,8,14,11],[1,10,1,11],[4,1,4,4],[6,1,6,4],[9,0,9,2],[9,8,9,9]]}
[null,null,null,null,"643 TALLGRASS PRAIRIE"]
[null,null,null,null,"SEEDING DESIGN",null,null,null,null,"DATE",{"$f":"TODAY()","v":"2022-06-16"}]
[]
[]
["LANDOWNER","Drake Mallard",null,null,null,null,null,null,"Tract No.","120 / 12"]
[]
["PLANNER","Sonny Day",null,null,null,null,null,null,"Field No.",22]
[]
[]
[null,null,null,null,null,null,null,null,"Background Information"]
["GRASS SPECIES",null,"PLANNED %",null,"POUNDS","TOTAL SEEDS/","% BY SEEDS",null,null,"SEEDS/","COC","COC"]
[null,null,"OF GRASS COMPONENT BY",null,"PLS/AC.","SQ. FOOT","SQ./FT",null,null,"SQ. FOOT","Selected","Reference"]
[null,null,"SEEDS/SQ. FOOT",null,null,null,"1/","2/",null,"At 1 lb. Rate",null,"6/"]
["COMMON NAME","SCIENTIFIC NAME","Planned",null,null,null,"Can't Exceed","Planned %"]
[]
["WARM SEASON 7/"]
["Big Bluestem","Andropogon gerardii","0 to 25",null,1,{"$f":"J17*E17","v":4.0404040404040407},{"$f":"PRODUCT(F17/F59,100)","v":1.6334106728538287},{"$f":"IF(AND(26>G17),\"OK\",\"HIGH\")","v":"OK"},176000,{"$f":"PRODUCT(I17/43560)","v":4.0404040404040407},{"$f":"IF(E17=0,\"\",L17)","v":4},4]
["Blue Grama","Bouteloua gracilis","0 to 20",null,1,{"$f":"J18*E18","v":17.217630853994489},{"$f":"PRODUCT(F18/F59,100)","v":6.9605568445475647},{"$f":"IF(AND(21>G18),\"OK\",\"HIGH\")","v":"OK"},750000,17.217630853994489,8,8]
["Indiangrass","Sorgastrum nutans","0 to 25",null,1,4.4306703397612486,{"$f":"PRODUCT(F19/F59,100)","v":1.7911832946635735},{"$f":"IF(AND(26>G19),\"OK\",\"HIGH\")","v":"OK"},193000,4.4306703397612486,4,4]
["Little Bluestem","Schizachryrium scoparium","0 to 30",null,1,6.5656565656565657,{"$f":"PRODUCT(F20/F59,100)","v":2.6542923433874712},{"$f":"IF(AND(31>G20),\"OK\",\"HIGH\")","v":"OK"},286000,6.5656565656565657,5,5]
["Prairie Cordgrass","Spartina pectinata","0 to 5",null,1,4.2011019283746558,{"$f":"PRODUCT(F21/F59,100)","v":1.6983758700696059},{"$f":"IF(AND(6>G21),\"OK\",\"HIGH\")","v":"OK"},183000,4.2011019283746558,4,4]
["Prairie Dropseed","Sporopolus heterolepis","0 to 10",null,1,5.1423324150596876,{"$f":"PRODUCT(F22/F59,100)","v":2.0788863109048727},{"$f":"IF(AND(11>G22),\"OK\",\"HIGH\")","v":"OK"},224000,5.1423324150596876,9,9]
["Prairie Sandreed","Calamovilfa longifolia","0 to 30",null,1,6.3131313131313131,{"$f":"PRODUCT(F23/F59,100)","v":2.5522041763341075},{"$f":"IF(AND(31>G23),\"OK\",\"HIGH\")","v":"OK"},275000,6.3131313131313131,7,7]
["Rough Dropseed","Sporobolus compositus","0 to 10",null,1,11.019283746556473,{"$f":"PRODUCT(F24/F59,100)","v":4.4547563805104415},{"$f":"IF(AND(11>G24),\"OK\",\"HIGH\")","v":"OK"},480000,11.019283746556473,9,9]
["Sideoats Grama","Bouteloua curtipendula","0 to 30",null,1,4.1322314049586772,{"$f":"PRODUCT(F25/F59,100)","v":1.6705336426914155},{"$f":"IF(AND(31>G25),\"OK\",\"HIGH\")","v":"OK"},180000,4.1322314049586772,6,6]
["Switchgrass","Panicum virgatum","0 to 5",null,1,8.9531680440771346,{"$f":"PRODUCT(F26/F59,100)","v":3.6194895591647338},{"$f":"IF(AND(6>G26),\"OK\",\"HIGH\")","v":"OK"},390000,8.9531680440771346,5,5]
[null,null,"0 to 10",null,1,0,{"$f":"PRODUCT(F27/F59,100)","v":0},{"$f":"IF(AND(11>G27),\"OK\",\"HIGH\")","v":"OK"},null,0,0]
[null,null,"0 to 10",null,1,0,{"$f":"PRODUCT(F28/F59,100)","v":0},"OK",null,0,0]
[null,null,"0 to 10",null,1,0,{"$f":"PRODUCT(F29/F59,100)","v":0},"OK",null,0,0]
[null,null,"0 to 10",null,1,0,{"$f":"PRODUCT(F30/F59,100)","v":0},"OK",null,0,0]
[null,null,"0 to 10",null,1,0,{"$f":"PRODUCT(F31/F59,100)","v":0},"OK",null,{"$f":"PRODUCT(I31/43560)","v":0},{"$f":"IF(E31=0,\"\",L31)","v":0}]
[null,null,"0 to 10",null,null,0,{"$f":"PRODUCT(F32/F59,100)","v":0},"OK",null,{"$f":"PRODUCT(I32/43560)","v":0},{"$f":"IF(E32=0,\"\",L32)","v":""}]
["COOL SEASON 7/"]
["Canada Bluejoint","Calamagrostis canadensis","0 to 5",null,1,102.84664830119375,{"$f":"PRODUCT(F34/F59,100)","v":41.577726218097453},{"$f":"IF(AND(6>G34),\"OK\",\"HIGH\")","v":"HIGH"},4480000,{"$f":"PRODUCT(I34/43560)","v":102.84664830119375},{"$f":"IF(E34=0,\"\",L34)","v":5},5]
["Canada Wildrye","Elymus canadensis","0 to 10",null,1,2.6400367309458219,{"$f":"PRODUCT(F35/F59,100)","v":1.0672853828306268},{"$f":"IF(AND(11>G35),\"OK\",\"HIGH\")","v":"OK"},115000,2.6400367309458219,5,5]
["Green Needlegrass","Stipa viridula","0 to 10",null,1,4.1322314049586772,{"$f":"PRODUCT(F36/F59,100)","v":1.6705336426914155},{"$f":"IF(AND(11>G36),\"OK\",\"HIGH\")","v":"OK"},180000,4.1322314049586772,5,5]
["June grass","Koleria macrantha","0 to 5",null,1,53.145087235996328,{"$f":"PRODUCT(F37/F59,100)","v":21.484918793503486},{"$f":"IF(AND(6>G37),\"OK\",\"HIGH\")","v":"HIGH"},2315000,53.145087235996328,7,7]
["Kalms Brome","Bromus kalmii","0 to 10",null,1,2.9384756657483928,{"$f":"PRODUCT(F38/F59,100)","v":1.1879350348027844},{"$f":"IF(AND(11>G38),\"OK\",\"HIGH\")","v":"OK"},128000,2.9384756657483928,5,5]
["Porcupine grass ","Hesperostipa spartea","0 to 10",null,1,1.3085399449035813,{"$f":"PRODUCT(F39/F59,100)","v":0.52900232018561499},{"$f":"IF(AND(11>G39),\"OK\",\"HIGH\")","v":"OK"},57000,1.3085399449035813,6,6]
["Slender Wheatgrass","Agropyron caninum","0 to 10",null,1,3.5583103764921948,{"$f":"PRODUCT(F40/F59,100)","v":1.4385150812064968},{"$f":"IF(AND(11>G40),\"OK\",\"HIGH\")","v":"OK"},155000,3.5583103764921948,5,5]
["Virginia Wildrye","Elymus virginicus","0 to 10",null,1,2.2038567493112948,{"$f":"PRODUCT(F41/F59,100)","v":0.89095127610208835},{"$f":"IF(AND(11>G41),\"OK\",\"HIGH\")","v":"OK"},96000,2.2038567493112948,3,3]
["Western Wheatgrass","Agropyron smithii","0 to 10",null,1,2.5711662075298438,{"$f":"PRODUCT(F42/F59,100)","v":1.0394431554524364},{"$f":"IF(AND(11>G42),\"OK\",\"HIGH\")","v":"OK"},112000,2.5711662075298438,2,2]
[null,null,"0 to 10",null,1,0,{"$f":"PRODUCT(F43/F59,100)","v":0},"OK",null,0,0]
[null,null,"0 to 10",null,1,0,{"$f":"PRODUCT(F44/F59,100)","v":0},"OK",null,0,0]
[null,null,"0 to 10",null,1,0,{"$f":"PRODUCT(F45/F59,100)","v":0},"OK",null,0,0]
[null,null,"0 to 10",null,1,0,{"$f":"PRODUCT(F46/F59,100)","v":0},"OK",null,0,0]
[null,null,"0 to 10",null,1,0,{"$f":"PRODUCT(F47/F59,100)","v":0},{"$f":"IF(AND(11>G47),\"OK\",\"HIGH\")","v":"OK"},null,{"$f":"PRODUCT(I47/43560)","v":0},{"$f":"IF(E47=0,\"\",L47)","v":0}]
[null,null,"0 to 10",null,1,{"$f":"J48*E48","v":0},{"$f":"PRODUCT(F48/F69,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(11>G48),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},null,{"$f":"PRODUCT(I48/43560)","v":0},{"$f":"IF(E48=0,\"\",L48)","v":0}]
[null,null,"0 to 10",null,1,0,{"$f":"PRODUCT(F49/F69,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,0]
[null,null,"0 to 10",null,1,0,{"$f":"PRODUCT(F50/F69,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,0]
[null,null,"0 to 10",null,1,0,{"$f":"PRODUCT(F51/F69,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,0]
[null,null,"0 to 10",null,1,0,{"$f":"PRODUCT(F52/F69,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(11>G52),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},null,{"$f":"PRODUCT(I52/43560)","v":0},{"$f":"IF(E52=0,\"\",L52)","v":0}]
[null,null,"0 to 10",null,1,{"$f":"J53*E53","v":0},{"$f":"PRODUCT(F53/F69,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(11>G53),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},null,{"$f":"PRODUCT(I53/43560)","v":0},{"$f":"IF(E53=0,\"\",L53)","v":0}]
[null,null,"0 to 10",null,1,0,{"$f":"PRODUCT(F54/F69,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,0]
[null,null,"0 to 10",null,1,0,{"$f":"PRODUCT(F55/F69,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,0]
[null,null,"0 to 10",null,1,0,{"$f":"PRODUCT(F56/F69,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(11>G56),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},null,{"$f":"PRODUCT(I56/43560)","v":0},{"$f":"IF(E56=0,\"\",L56)","v":0}]
[null,null,"0 to 10",null,1,0,{"$f":"PRODUCT(F57/F59,100)","v":0},{"$f":"IF(AND(11>G57),\"OK\",\"HIGH\")","v":"OK"},null,{"$f":"PRODUCT(I57/43560)","v":0},{"$f":"IF(E57=0,\"\",L57)","v":0}]
[]
[null,null,"TOTAL Pounds PLS ",null,{"$f":"SUM(E17:E57)","v":39},{"$f":"SUM(F17:F57)","v":247.35996326905413},{"$f":"SUM(G17:G57)","v":{"$error":"#DIV/0!"}},null,null,"AVE COC GRASS",{"$f":"AVERAGE(K17:K57)","v":2.6666666666666665}]
[null,null,null,null,null,null,{"$f":"SUM(G34:G57)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,{"$f":"IF(AND(20.1>G60,G60<100),\"\",\"COOL SEASON GRASSES EXCEED 20% OF THE MIX BASED ON SEEDS/FT\")","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
["1/  ACTUAL SEEDS PER SQUARE FOOT SHALL BE WITHIN THE RANGE SPECIFIED IN PLANNED CONDITION"]
["2/  NO MORE THAN 20% OF THE MIXTURE SHALL BE COMPRISED OF COOL SEASON GRASSES BASED ON SEEDS PER SQUARE FOOT."]
[null,null,null,null,null,null,null,null,"Background Information"]
["FORB SPECIES",null,null,null,"OUNCES","TOTAL SEEDS/","% OF FORB MIX BY SEEDS/FT 3/",null,"SEEDS/oz","SEEDS/","COC","COC","Pollinator Monarch  Preferred (Blue)"]
[null,null,null,null,"PLS/AC.","SQ. FOOT",null,null,null,"SQ. FOOT","Selected","Reference"]
[null,null,null,null,null,null,null,null,null,"At 1 oz/ac Rate"]
["COMMON NAME","SCIENTIFIC NAME"]
["DRY"]
["Bush Clover","Lespedeza capitata",null,null,1,{"$f":"J75*E75","v":0.18365472910927455},{"$f":"PRODUCT(F75/F152,100)","v":0.38199650473198166},{"$f":"IF(AND(21>G75),\"OK\",\"HIGH\")","v":"OK"},8000,{"$f":"PRODUCT(I75/43560)","v":0.18365472910927455},{"$f":"IF(E75=0,\"\",L75)","v":3},3,"Late"]
["Culvers Root","Veronicastrum virg.",null,null,1,18.365472910927455,{"$f":"PRODUCT(F76/F152,100)","v":38.199650473198169},{"$f":"IF(AND(21>G76),\"OK\",\"HIGH\")","v":"HIGH"},800000,18.365472910927455,5,5,"Mid"]
["Dotted Blazingstar","(Liatris punctata)",null,null,1,0.16069788797061524,{"$f":"PRODUCT(F77/F152,100)","v":0.33424694164048396},"OK",7000,0.16069788797061524,8,8,"Mid"]
["Purple Coneflower, Narrow Leaved","(Echinacea pallida var. angustifolia)",null,null,null,0,{"$f":"PRODUCT(F78/F152,100)","v":0},"OK",7000,0.16069788797061524,"",8,"Mid"]
["Prairie Cinquefoil","(Potentilla arguta)",null,null,null,0,{"$f":"PRODUCT(F79/F152,100)","v":0},"OK",230000,5.2800734618916438,"",8,"Late"]
["Showy Penstemon","(Penstemon grandifloris)",null,null,null,0,{"$f":"PRODUCT(F80/F152,100)","v":0},"OK",14000,0.32139577594123048,"",5,"Early"]
["Stiff Sunflower","(Helianthus paucifloris)",null,null,null,0,{"$f":"PRODUCT(F81/F152,100)","v":0},{"$f":"IF(AND(21>G81),\"OK\",\"HIGH\")","v":"OK"},4000,{"$f":"PRODUCT(I81/43560)","v":9.1827364554637275E-2},"",5,"Mid"]
["Silky Aster","(Symphyotrichum sericeum)",null,null,null,0,{"$f":"PRODUCT(F82/F152,100)","v":0},"OK",26000,0.59687786960514233,"",10,"Late"]
["DRY to MESIC"]
["Butterfly Weed","(Asclepias tuberosa)",null,null,1,9.8714416896235072E-2,{"$f":"PRODUCT(F84/F152,100)","v":0.20532312129344013},{"$f":"IF(AND(21>G84),\"OK\",\"HIGH\")","v":"OK"},4300,{"$f":"PRODUCT(I84/43560)","v":9.8714416896235072E-2},{"$f":"IF(E84=0,\"\",L84)","v":6},6,"Mid"]
["Canada Milkvetch","(Astragalus canadensis)",null,null,1,0.39026629935720847,{"$f":"PRODUCT(F85/F152,100)","v":0.81174257255546123},{"$f":"IF(AND(21>G85),\"OK\",\"HIGH\")","v":"OK"},17000,{"$f":"PRODUCT(I85/43560)","v":0.39026629935720847},{"$f":"IF(E85=0,\"\",L85)","v":4},4,"Mid"]
["Compass Plant ","(Silphium laciniatum)",null,null,1,1.5151515151515152E-2,{"$f":"PRODUCT(F86/F152,100)","v":3.1514711640388493E-2},"OK",660,1.5151515151515152E-2,7,7,"Mid"]
["Evening Primrose","(Oenothera biennis)",null,null,1,2.0661157024793386,{"$f":"PRODUCT(F87/F152,100)","v":4.2974606782347937},"OK",90000,2.0661157024793386,4,4,"Mid"]
["Foxglove Beardtongue","(Penstemon digitalis)",null,null,1,2.9843893480257115,{"$f":"PRODUCT(F88/F152,100)","v":6.2074432018947023},{"$f":"IF(AND(21>G88),\"OK\",\"HIGH\")","v":"OK"},130000,2.9843893480257115,5,5,"Early"]
["Heart-leaved Alexander","(Zizia aptera)",null,null,1,0.27548209366391185,{"$f":"PRODUCT(F89/F152,100)","v":0.57299475709797254},"OK",12000,0.27548209366391185,8,8,"Early"]
["Heath Aster","(Symphyotrichum ericoides)",null,null,1,4.5913682277318637,{"$f":"PRODUCT(F90/F152,100)","v":9.5499126182995422},{"$f":"IF(AND(21>G90),\"OK\",\"HIGH\")","v":"OK"},200000,{"$f":"PRODUCT(I90/43560)","v":4.5913682277318637},3,3,"Late"]
["Hoary Vervain","(Verbena stricta)",null,null,1,0.64279155188246095,{"$f":"PRODUCT(F91/F152,100)","v":1.3369877665619359},"OK",28000,0.64279155188246095,1,1,"Mid"]
["Lance-leaved Coreopsis","(Coreopsis lanceolata)",null,null,1,0.4591368227731864,{"$f":"PRODUCT(F92/F152,100)","v":0.9549912618299542},"OK",20000,0.4591368227731864,5,5,"Early"]
["Leadplant","(Amorpha canescens)",null,null,1,0.3673094582185491,{"$f":"PRODUCT(F93/F152,100)","v":0.76399300946396331},"OK",16000,0.3673094582185491,8,8,"Mid"]
["Long -headed Coneflower","(Ratibida columnifera)",null,null,1,0.96418732782369143,{"$f":"PRODUCT(F94/F152,100)","v":2.0054816498429036},"OK",42000,0.96418732782369143,5,5,"Mid"]
["Ontario Blazingstar","(Liatris cylindracea)",null,null,1,0.32139577594123048,{"$f":"PRODUCT(F95/F152,100)","v":0.66849388328096793},{"$f":"IF(AND(21>G95),\"OK\",\"HIGH\")","v":"OK"},14000,{"$f":"PRODUCT(I95/43560)","v":0.32139577594123048},8,8,"Late"]
["Prairie Smoke","(Geum triflorum)",null,null,1,0.6198347107438017,{"$f":"PRODUCT(F96/F152,100)","v":1.2892382034704382},"OK",27000,0.6198347107438017,8,8,"Early"]
["Rough Blazingstar","(Liatris aspera)",null,null,1,0.3673094582185491,{"$f":"PRODUCT(F97/F152,100)","v":0.76399300946396331},"OK",16000,0.3673094582185491,8,8,"Late"]
["Showy Goldenrod","(Solidago speciosa)",null,null,1,2.1808999081726355,{"$f":"PRODUCT(F98/F152,100)","v":4.5362084936922829},"OK",95000,2.1808999081726355,7,7,"Late"]
["Smooth Aster","(Symphyotrichum laeva)",null,null,1,1.2626262626262625,{"$f":"PRODUCT(F99/F152,100)","v":2.6262259700323738},"OK",55000,1.2626262626262625,7,7,"Late"]
["Spotted Beebalm","(Monarda punctata)",null,null,1,1.6069788797061524,{"$f":"PRODUCT(F100/F152,100)","v":3.3424694164048399},"OK",70000,1.6069788797061524,6,6,"Mid"]
["Stiff Tickseed","(Coreopsis  palmata)",null,null,1,0.2295684113865932,{"$f":"PRODUCT(F101/F152,100)","v":0.4774956309149771},"OK",10000,0.2295684113865932,7,7,"Mid"]
["Thimbleweed","(Anemone cylindrica)",null,null,1,0.59687786960514233,{"$f":"PRODUCT(F102/F152,100)","v":1.2414886403789405},"OK",26000,0.59687786960514233,7,7,"Mid"]
["Whorled Milkweed","(Asclepias verticillata)",null,null,1,0.25252525252525254,{"$f":"PRODUCT(F103/F152,100)","v":0.52524519400647485},"OK",11000,0.25252525252525254,4,4,"Mid-Late"]
["Wild Blue Phlox","(Phlox divaricata)",null,null,1,0.28696051423324148,{"$f":"PRODUCT(F104/F152,100)","v":0.59686953864372139},{"$f":"IF(AND(21>G104),\"OK\",\"HIGH\")","v":"OK"},12500,{"$f":"PRODUCT(I104/43560)","v":0.28696051423324148},{"$f":"IF(E104=0,\"\",L104)","v":7},7,"Early"]
["Wild Columbine","(Aquilegia canadensis)",null,null,null,0,{"$f":"PRODUCT(F105/F152,100)","v":0},"OK",38000,0.87235996326905418,"",6,"Early"]
["MESIC to WET"]
["Blanketflower","(Gaillardia aristata)",null,null,null,0,{"$f":"PRODUCT(F107/F152,100)","v":0},{"$f":"IF(AND(21>G107),\"OK\",\"HIGH\")","v":"OK"},9813,{"$f":"PRODUCT(I107/43560)","v":0.22527548209366391},{"$f":"IF(E107=0,\"\",L107)","v":""},2,"Mid"]
["Canada Tick Trefoil","(Desmodium canadense)",null,null,1,0.12626262626262627,{"$f":"PRODUCT(F108/F152,100)","v":0.26262259700323742},"OK",5500,0.12626262626262627,6,6,"Mid"]
["Common Ox-eye","(Heliopsis helianthoides)",null,null,1,0.14462809917355371,{"$f":"PRODUCT(F109/F152,100)","v":0.30082224747643554},"OK",6300,0.14462809917355371,4,4,"Mid"]
["Giant Sunflower","(Helianthus giganteus)",null,null,1,0.2295684113865932,{"$f":"PRODUCT(F110/F152,100)","v":0.4774956309149771},"OK",10000,0.2295684113865932,5,5,"Late"]
["Golden Alexanders","(Zizia aurea)",null,null,1,0.25252525252525254,{"$f":"PRODUCT(F111/F152,100)","v":0.52524519400647485},"OK",11000,0.25252525252525254,6,6,"Early"]
["Great Blue Lobelia","(Lobelia siphilitica)",null,null,null,0,{"$f":"PRODUCT(F112/F152,100)","v":0},"OK",500000,11.478420569329661,"",3,"Late"]
["Ironweed","(Veronia fasticulata)",null,null,null,0,{"$f":"PRODUCT(F113/F152,100)","v":0},"OK",24000,0.55096418732782371,"",3,"Late"]
["Meadow Blazingstar","(Liatris ligulistylis)",null,null,null,0,{"$f":"PRODUCT(F114/F152,100)","v":0},{"$f":"IF(AND(21>G114),\"OK\",\"HIGH\")","v":"OK"},11000,0.25252525252525254,"",8,"Late"]
["Mountain Mint","(Pycnanthemum virginianum)",null,null,null,0,{"$f":"PRODUCT(F115/F152,100)","v":0},{"$f":"IF(AND(21>G115),\"OK\",\"HIGH\")","v":"OK"},220000,{"$f":"PRODUCT(I115/43560)","v":5.0505050505050502},"",8,"Mid"]
["Partridge Pea","(Cassia fasticulata)",null,null,null,0,{"$f":"PRODUCT(F116/F152,100)","v":0},"OK",2700,{"$f":"PRODUCT(I116/43560)","v":6.1983471074380167E-2},"",1,"Mid"]
["Rattlesnake Master","(Eryngium yuccifolium)",null,null,null,0,{"$f":"PRODUCT(F117/F152,100)","v":0},"OK",7500,0.17217630853994489,"",8,"Mid"]
["Sawtooth Sunflower","(Helianthus grosseserratus)",null,null,null,0,{"$f":"PRODUCT(F118/F152,100)","v":0},"OK",10000,0.2295684113865932,"",4,"Late"]
["Tall Blazingstar","(Liatris pycnostachya)",null,null,null,0,{"$f":"PRODUCT(F119/F152,100)","v":0},"OK",11000,0.25252525252525254,"",6,"Mid"]
["Virginia Bluebells","(Mertenias virginica)",null,null,null,0,{"$f":"PRODUCT(F120/F152,100)","v":0},{"$f":"IF(AND(21>G120),\"OK\",\"HIGH\")","v":"OK"},9700,{"$f":"PRODUCT(I120/43560)","v":0.22268135904499542},{"$f":"IF(E120=0,\"\",L120)","v":""},6,"Early"]
["Wild Bergamot","(Monarda fistulosa)",null,null,null,0,{"$f":"PRODUCT(F121/F152,100)","v":0},"OK",70000,1.6069788797061524,"",2,"Mid"]
["Yellow Coneflower","(Ratibida pinnata)",null,null,null,0,{"$f":"PRODUCT(F122/F152,100)","v":0},"OK",30000,0.68870523415977958,"",4,"Mid"]
["WET"]
["Blue Vervain","(Verbena hastata)",null,null,null,0,{"$f":"PRODUCT(F124/F152,100)","v":0},{"$f":"IF(AND(21>G124),\"OK\",\"HIGH\")","v":"OK"},93000,{"$f":"PRODUCT(I124/43560)","v":2.1349862258953167},{"$f":"IF(E124=0,\"\",L124)","v":""},3,"Mid"]
["Boneset","(Eupatorium perfoliatum)",null,null,null,0,{"$f":"PRODUCT(F125/F152,100)","v":0},"OK",160000,3.6730945821854912,"",6,"Late"]
["Cup Plant","(Silphium perfoliatum)",null,null,null,0,{"$f":"PRODUCT(F126/F152,100)","v":0},"OK",1400,3.2139577594123052E-2,"",1,"Mid"]
["Joe-pye Weed","(Eutrochium maculatum)",null,null,null,0,{"$f":"PRODUCT(F127/F152,100)","v":0},"OK",95000,2.1808999081726355,"",5,"Mid"]
["New England Aster","(Symphyotrichum novae-angliae)",null,null,null,0,{"$f":"PRODUCT(F128/F152,100)","v":0},"OK",66000,1.5151515151515151,"",3,"Late"]
["Panicled Aster","(Symphyotrichum lanceolatum)",null,null,null,0,{"$f":"PRODUCT(F129/F152,100)","v":0},"OK",156000,3.5812672176308542,"",4,"Late"]
["Sneezeweed","(Helenium autumnale)",null,null,null,0,{"$f":"PRODUCT(F130/F152,100)","v":0},{"$f":"IF(AND(21>G130),\"OK\",\"HIGH\")","v":"OK"},130000,{"$f":"PRODUCT(I130/43560)","v":2.9843893480257115},"",4,"Late"]
["Swamp Milkweed  ","(Asclepias incarnata)",null,null,null,0,{"$f":"PRODUCT(F131/F152,100)","v":0},"OK",4800,0.11019283746556474,"",4,"Mid"]
["DRY to WET"]
["Anise Hyssop","(Agastache foeniculum)",null,null,null,0,{"$f":"PRODUCT(F133/F152,100)","v":0},{"$f":"IF(AND(21>G133),\"OK\",\"HIGH\")","v":"OK"},91000,{"$f":"PRODUCT(I133/43560)","v":2.089072543617998},{"$f":"IF(E133=0,\"\",L133)","v":""},4,"Mid"]
["Black-eyed Susan","(Rudbeckia hirta)",null,null,null,0,{"$f":"PRODUCT(F134/F152,100)","v":0},{"$f":"IF(AND(21>G134),\"OK\",\"HIGH\")","v":"OK"},92000,{"$f":"PRODUCT(I134/43560)","v":2.1120293847566574},{"$f":"IF(E134=0,\"\",L134)","v":""},2,"Late"]
["Common Milkweed","(Asclepias syriaca)",null,null,null,0,{"$f":"PRODUCT(F135/F152,100)","v":0},{"$f":"IF(AND(21>G135),\"OK\",\"HIGH\")","v":"OK"},4000,{"$f":"PRODUCT(I135/43560)","v":9.1827364554637275E-2},"",1,"Mid"]
["Grassleaved Goldenrod","(Euthamia  graminifolia )",null,null,1,8.0348943985307617,{"$f":"PRODUCT(F136/F152,100)","v":16.712347082024198},{"$f":"IF(AND(21>G136),\"OK\",\"HIGH\")","v":"OK"},350000,{"$f":"PRODUCT(I136/43560)","v":8.0348943985307617},4,4,"Mid"]
["Illinois Bundleflower","(Desmanthus illinoensis)",null,null,null,0,{"$f":"PRODUCT(F137/F152,100)","v":0},"OK",4200,9.6418732782369149E-2,"",4,"Mid"]
["Purple Prairie Clover","(Petalostemum purpurum)",null,null,null,0,{"$f":"PRODUCT(F138/F152,100)","v":0},"OK",18000,0.41322314049586778,"",8,"Mid"]
["Maximillian Sunflower","(Helianthus maximiliani)",null,null,null,{"$f":"J139*E139","v":0},{"$f":"PRODUCT(F139/F152,100)","v":0},"OK",13000,0.29843893480257117,"",4,"Late"]
["Stiff Goldenrod","(Solidago rigida)",null,null,null,0,{"$f":"PRODUCT(F140/F152,100)","v":0},"OK",41000,0.94123048668503217,"",4,"Late"]
["White Prairie Clover","(Petalostemum candidum)",null,null,null,0,{"$f":"PRODUCT(F141/F152,100)","v":0},"OK",19000,0.43617998163452709,"",10,"Mid"]
["Yarrow","(Achillea millefolium)",null,null,null,0,{"$f":"PRODUCT(F142/F152,100)","v":0},{"$f":"IF(AND(21>G142),\"OK\",\"HIGH\")","v":"OK"},180000,{"$f":"PRODUCT(I142/43560)","v":4.1322314049586772},"",1,"Mid"]
["Yellow Giant Hyssop","(Agastache nepetoides )",null,null,null,0,{"$f":"PRODUCT(F143/F152,100)","v":0},{"$f":"IF(AND(21>G143),\"OK\",\"HIGH\")","v":"OK"},91000,{"$f":"PRODUCT(I143/43560)","v":2.089072543617998},"",4,"Late"]
["ADDITIONAL APPROVED FORBS 7/"]
[null,null,null,null,null,0,{"$f":"PRODUCT(F145/F152,100)","v":0},{"$f":"IF(AND(21>G145),\"OK\",\"HIGH\")","v":"OK"},null,{"$f":"PRODUCT(I145/43560)","v":0},{"$f":"IF(E145=0,\"\",L145)","v":""}]
[null,null,null,null,null,0,{"$f":"PRODUCT(F146/F152,100)","v":0},"OK",null,0,""]
[null,null,null,null,null,0,{"$f":"PRODUCT(F147/F152,100)","v":0},"OK",null,0,""]
[null,null,null,null,null,0,{"$f":"PRODUCT(F148/F152,100)","v":0},"OK",null,0,""]
[null,null,null,null,null,0,{"$f":"PRODUCT(F149/F152,100)","v":0},"OK",null,0,""]
[null,null,null,null,null,0,{"$f":"PRODUCT(F150/F152,100)","v":0},"OK",null,0,""]
[]
[null,null,"TOTAL OUNCES PLS",null,{"$f":"SUM(E75:E150)","v":29},{"$f":"SUM(F75:F150)","v":48.077594123048669},{"$f":"SUM(G75:G150)","v":99.999999999999986},null,null,"AVE COC FORB",{"$f":"AVERAGE(K75:K150)","v":5.7241379310344831}]
[]
[]
[null,null,null,null,null,"3/  Individual species not to exceed 20% of the forb component by seeds/ft"]
[]
[null,"TOTAL SEEDS/FT   4/",{"$f":"SUM(F59,F152)","v":295.4375573921028},null,{"$f":"IF(AND(35<C157),\"OK\",\"LOW\")","v":"OK"},"4/  Minimum 35-40 seeds/square foot"]
[]
[null,"PERCENT GRASS   5/",{"$f":"PRODUCT(F59/C157)*100","v":83.726647841445427},null,{"$f":"IF(AND(60>C159),\"\",\"HIGH\")","v":"HIGH"},"5/  Maximum 60% grasses "]
[]
[null,"PERCENT FLOWER",{"$f":"PRODUCT(F152/C157)*100","v":16.273352158554573},null,null,"6/ Assignment of Coefficients"]
[null,null,null,null,null,"0 to 3 : Plants with a high range of ecological tolerances/found in a variety of plant communities"]
[null,"AVE. COC - MIX",{"$f":"AVERAGE(K17:K57,K75:K150)","v":3.9705882352941178},null,null,"4 to 6 : Plants with an intermediate range of ecological tolerances/ associated with a specific plant community"]
[null,null,null,null,null,"7 to 8 : Plants with a poor range of ecological tolerances/associated with advanced successional stage"]
[null,"SPECIES RICHNESS",{"$f":"COUNT(K17:K57,K75:K150)","v":68},null,null,"9 to 10 : Plants with a high degree of fidelity to a narrow range of pristine habitats"]
[]
[null,null,null,null,null,"7/ Consult with the appropriate NRCS Area Resource Conservationist or Biologist for prior approval of additional species."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[" "]

{"sheet":"Seeding Plan","index":2,"n_rows":123,"n_cols":9,"rows_kept":123,"cut":false,"hidden":false,"merged":[[118,0,118,5],[122,0,124,5],[103,2,103,5],[104,2,104,5],[106,0,106,5],[110,0,110,5],[115,0,115,5],[91,0,91,5],[92,0,94,5],[96,0,96,1],[97,0,97,1],[102,0,102,5],[0,4,0,5],[5,1,5,2],[1,0,1,5],[9,1,11,1],[89,0,89,5],[2,0,2,5],[3,1,3,2],[14,0,14,5],[87,0,87,5],[88,0,88,5],[15,1,15,3],[9,0,10,0],[134,11,134,12],[132,11,132,12],[133,11,133,12],[125,11,125,12],[126,11,126,12],[130,10,131,10],[130,11,130,12],[131,11,131,12],[124,10,126,10],[127,11,127,12],[128,11,128,12]]}
[]
["Seeding Plan"]
[]
["Name ",null,null,null,"Date ",{"$f":"TODAY()","v":"2022-06-16"}]
[]
["Prepared by",null,null,null,"Tract No./ Field No.",null,null,null,"VISIBLE"]
[]
[]
[]
["Type of Seeding:",null,"Field Area (acres):"]
[]
[]
[]
[]
["Seeding Mix Summary"]
[]
["Grasses/     Sedges","Common Name","Scientific Name","PLS Lbs/Acre",null,"PLS Lbs"]
[1,null,null,null,null,{"$f":"IF(D18>0, D$10*D18,\" \")","v":" "}]
[2,null,null,null,null,{"$f":"IF(D19>0, D$10*D19,\" \")","v":" "}]
[3,null,null,null,null," "]
[4,null,null,null,null," "]
[5,null,null,null,null," "]
[6,null,null,null,null," "]
[7,null,null,null,null," ",null,"CREP CP-2 Establishment of Permanent Native Grass and Forbs"]
[8,null,null,null,null," ",null,"Monarch Food Plot (CP-2)"]
[9,null,null,null,null," ",null,"CREP CP-21 Filter Strip"]
[10,null,null,null,null," ",null,"CREP CP-23 Wetland Restoration - Floodplain"]
[11,null,null,null,null," ",null,"CREP CP-23 Wetland Restoration Buffer"]
[12,null,null,null,null," ",null,"CREP CP-23A Wetland Restoration - Non-Floodplain"]
[13,null,null,null,null," ",null,"CREP CP-23A Wetland Restoration Buffer"]
[14,null,null,null,null," "]
[15,null,null,null,null," "]
[16,null,null,null,null," "]
[17,null,null,null,null," "]
[18,null,null,null,null," ",null,"Cool Season Grasses and Legumes. North: Spring 4/1 -6/15.  Late Summer 7/15 - 9/1."]
[19,null,null,null,null," ",null,"Cool Season Grasses and Legumes. South: Spring 4/1 - 6/1.   Late Summer 8/1 - 9/10."]
[20,null,null,null,null," ",null,"Native Grasses and Forbs: Statewide 5/15 - 6/30 "]
[21,null,null,null,null," ",null,"Native Grasses and Forbs: Dormant 11/1 or a consistent soil temperature of <50 degrees F."]
[22,null,null,null,null," ",null,"Conventional or no-till drill into prepared seedbed:  Seedbed should be tilled and clean of all vegetation and weeds, packed and firm enough to make a 1/2' or less boot imprint."]
[23,null,null,null,null," "]
[24,null,null,null,null," ",null,"No-till drill into existing sod:  Seedbed preparation will vary from site to site.  Most common seedbed preparation methods can included heavy grazing, light tillage, herbicide application, or a combination.  Existing vegetation should be as severly suppresed for grass seeds to germinate and grow without excessive competition."]
[25,null,null,null,null," "]
[null,null,"SUBTOTAL GRASS/SEDGE",{"$f":"SUM(D18:D42)","v":0},null,{"$f":"SUM(F18:F42)","v":0},null,"Broadcasting via terrigator or vicon seeder:  Seedbed should be tilled and clean of all vegetation and weeds, packed and firm enough to make a 1/2' or less boot imprint.  Pack or light harrow following application to ensure proper seed to soil contact. Broadcast seed at 1.5 times the recommended drilled rate."]
[null,null,"DRILLED RATE1",null,null,null,null,"Ryegrass  < 2.5lbs/ac"]
["Forbs/\nLegumes","Common Name","Scientific Name","PLS Oz/Acre"," PLS Oz"," PLS Lbs",null,"Winter Wheat  1/2 BU/Ac"]
[1,null,null,null,{"$f":"IF(D46<>\"\",D46*$D$10,\"\")","v":""},{"$f":"IF(D46>0, D$10*D46/16,\" \")","v":" "},null,"Oats 3/4-1.25 BU/Ac"]
[2,null,null,null,{"$f":"IF(D47<>\"\",D47*$D$10,\"\")","v":""},{"$f":"IF(D47>0, D$10*D47/16,\" \")","v":" "},null,"Barley  1/2 - 1 BU/Ac"]
[3,null,null,null,""," ",null,"None"]
[4,null,null,null,""," "]
[5,null,null,null,""," "]
[6,null,null,null,""," "]
[7,null,null,null,""," "]
[8,null,null,null,""," "]
[9,null,null,null,""," "]
[10,null,null,null,""," "]
[11,null,null,null,""," "]
[12,null,null,null,""," "]
[13,null,null,null,""," "]
[14,null,null,null,""," "]
[15,null,null,null,""," "]
[16,null,null,null,""," "]
[17,null,null,null,""," "]
[18,null,null,null,""," "]
[19,null,null,null,""," "]
[20,null,null,null,""," "]
[21,null,null,null,""," "]
[22,null,null,null,""," "]
[23,null,null,null,""," "]
[24,null,null,null,""," "]
[25,null,null,null,""," "]
[26,null,null,null,""," "]
[27,null,null,null,""," "]
[28,null,null,null,""," "]
[29,null,null,null,""," "]
[30,null,null,null,""," "]
[31,null,null,null,""," "]
[32,null,null,null,""," "]
[33,null,null,null,""," "]
[34,null,null,null,""," "]
[35,null,null,null,""," "]
[36,null,null,null,""," "]
[37,null,null,null,""," "]
[38,null,null,null,""," "]
[39,null,null,null,""," "]
[40,null,null,null,""," "]
[null,null,"SUBTOTAL FORBS",{"$f":"SUM(D46:D85)","v":0},{"$f":"SUM(E46:E85)","v":0},{"$f":"SUM(F46:F85)","v":0}]
[null,null,"DRILLED RATE 1"]
["1/  Broadcast seeding rate is 1.5 times the drilled rate."]
["Seeding Dates"]
[]
[]
["Seeding Method and Seedbed Preparation"]
[]
[]
[]
[]
["Companion Crop"]
[]
[]
[]
[null,null,null,null,null,null,"HIDDEN"]
[null,null,null,null,null,"HIDDEN"]
["Nitrogen Recommended (units/ac)"]
["Grass w/Legume >20%",null,0]
["Grass w/Legume <20%",null,60]
[]
["Phosphorous Recommendations for Grass w/ >20% Legume (lb/ac)"]
["Bray","0-5","6-10","11-15","16-20","21+"]
["Olsen","0-3","4-7","8-11","12-15","16+"]
[null,35,25,15,0,0]
["Phosphorous Recommendations for Grass w/ <20% Legume (lb/ac)"]
["Bray","0-5","6-10","11-15","16-20","21+"]
["Olsen","0-3","4-7","8-11","12-15","16+"]
[null,40,30,20,10,0]
[]
["Potassium Recommendations for  Grass w/ >20% Legume (lb/ac)"]
["Soil Test Result","0-40","41-80","81-120","121-160","161+"]
[null,95,65,40,15,0]
["Potassium Recommendations for Grass w/ <20% Legume (lb/ac)"]
["Soil Test Result","0-40","41-80","81-120","121-160","161+"]
[null,90,60,30,0,0]
[]
["If soil tests are not available, fertilizer will be applied in equal amounts of Nitrogen-Phosphorus-Potassium (N-P-K) for grass and legume establishment.  An example fertilizer blend would be 60-60-60."]

{"sheet":"643 CREP CP23A Buffer","index":3,"n_rows":170,"n_cols":15,"rows_kept":170,"cut":false,"hidden":false,"merged":[[69,14,71,14],[150,0,150,14],[166,0,166,5],[10,0,12,0],[13,6,14,6],[160,0,162,0],[160,2,162,2],[161,5,162,12],[163,5,164,14],[165,5,165,14],[10,12,12,12],[154,5,154,7],[155,5,155,7],[69,13,71,13],[69,12,72,12],[13,7,14,7],[9,0,9,2],[9,8,9,9],[69,0,71,0],[32,0,32,2],[68,8,68,9],[69,6,71,6],[13,2,14,2],[15,0,15,2],[13,8,14,12],[10,6,12,6],[7,4,7,7],[0,0,0,14],[1,0,1,14],[4,1,4,2],[4,7,4,8],[6,1,6,2],[6,7,6,8]]}
["CREP 643 TALLGRASS PRAIRIE + MONARCH"]
["Seeding Design"]
[null,null,null,null,null,null,null,null,"DATE",{"$f":"TODAY()","v":"2022-06-16"}]
[]
["LANDOWNER",null,null,null,null,null,null,"TRACT/FIELD"]
[]
["PLANNER",null,null,null,null,null,null,"ACRES SEEDED"]
[]
[]
[null,null,null,null,null,null,null,null,"Background Information"]
["GRASS SPECIES",null,"PLANNED %",null,"POUNDS","TOTAL SEEDS/","% OF GRASS MIX BY SEEDS/FT 1/",null,null,"SEEDS/","COC","COC","Pounds PLS"]
[null,null,"OF GRASS COMPONENT BY",null,"PLS/AC.","SQ. FOOT",null,null,null,"SQ. FOOT","Selected","Reference"]
[null,null,"SEEDS/SQ. FOOT",null,null,null,null,null,null,"At 1 lb. Rate",null,"6/"]
[null,null,"Planned",null,null,null,"Can't Exceed","Planned %"]
[]
["WARM SEASON 7/"]
["Big Bluestem","Andropogon gerardii","0 to 25",null,0,{"$f":"PRODUCT(J17,E17)","v":0},{"$f":"PRODUCT(F17/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(26>G17),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},176000,{"$f":"PRODUCT(I17/43560)","v":4.0404040404040407},{"$f":"IF(E17=0,\"\",L17)","v":""},4,{"$f":"PRODUCT(J7*E17)","v":0}]
["Blue Grama","Bouteloua gracilis","0 to 20",null,0,0,{"$f":"PRODUCT(F18/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G18),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},750000,17.217630853994489,"",8,{"$f":"PRODUCT(J7*E18)","v":0}]
["Indiangrass","Sorgastrum nutans","0 to 25",null,0,0,{"$f":"PRODUCT(F19/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(26>G19),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},193000,4.4306703397612486,"",4,{"$f":"PRODUCT(J7*E19)","v":0}]
["Little Bluestem","Schizachryrium scoparium","0 to 30",null,0,0,{"$f":"PRODUCT(F20/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(31>G20),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},286000,6.5656565656565657,"",5,{"$f":"PRODUCT(J7*E20)","v":0}]
["Prairie Cordgrass","Spartina pectinata","0 to 5",null,0,0,{"$f":"PRODUCT(F21/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(6>G21),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},183000,4.2011019283746558,"",4,{"$f":"PRODUCT(J7*E21)","v":0}]
["Prairie Dropseed","Sporopolus heterolepis","0 to 10",null,0,0,{"$f":"PRODUCT(F22/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(11>G22),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},224000,5.1423324150596876,"",9,{"$f":"PRODUCT(J7*E22)","v":0}]
["Prairie Sandreed","Calamovilfa longifolia","0 to 30",null,0,0,{"$f":"PRODUCT(F23/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(31>G23),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},275000,6.3131313131313131,"",7,{"$f":"PRODUCT(J7*E23)","v":0}]
["Rough Dropseed","Sporobolus compositus","0 to 10",null,0,0,{"$f":"PRODUCT(F24/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(11>G24),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},480000,11.019283746556473,"",9,{"$f":"PRODUCT(J7*E24)","v":0}]
["Sideoats Grama","Bouteloua curtipendula","0 to 30",null,0,0,{"$f":"PRODUCT(F25/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(31>G25),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},180000,4.1322314049586772,"",6,{"$f":"PRODUCT(J7*E25)","v":0}]
["Switchgrass","Panicum virgatum","0 to 5",null,0,0,{"$f":"PRODUCT(F26/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(6>G26),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},390000,8.9531680440771346,"",5,{"$f":"PRODUCT(J7*E26)","v":0}]
[null,null,"0 to 10",null,0,0,{"$f":"PRODUCT(F27/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(11>G27),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},null,0,"",null,{"$f":"PRODUCT(J7*E27)","v":0}]
[null,null,"0 to 10",null,0,0,{"$f":"PRODUCT(F28/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,"",null,{"$f":"PRODUCT(J7*E28)","v":0}]
[null,null,"0 to 10",null,0,0,{"$f":"PRODUCT(F29/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,"",null,{"$f":"PRODUCT(J7*E29)","v":0}]
[null,null,"0 to 10",null,0,0,{"$f":"PRODUCT(F30/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,"",null,{"$f":"PRODUCT(J7*E30)","v":0}]
[null,null,"0 to 10",null,0,{"$f":"PRODUCT(J31,E31)","v":0},{"$f":"PRODUCT(F31/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$f":"PRODUCT(I31/43560)","v":0},{"$f":"IF(E31=0,\"\",L31)","v":""},null,{"$f":"PRODUCT(J7*E31)","v":0}]
[null,null,"0 to 10",null,0,{"$f":"PRODUCT(J32,E32)","v":0},{"$f":"PRODUCT(F32/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$f":"PRODUCT(I32/43560)","v":0},{"$f":"IF(E32=0,\"\",L32)","v":""},null,{"$f":"PRODUCT(J7*E32)","v":0}]
["COOL SEASON  2/  7/",null,null,null,"   "]
["Canada Bluejoint","Calamagrostis canadensis","0 to 5",null,0,{"$f":"PRODUCT(J34,E34)","v":0},{"$f":"PRODUCT(F34/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(6>G34),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},4480000,{"$f":"PRODUCT(I34/43560)","v":102.84664830119375},{"$f":"IF(E34=0,\"\",L34)","v":""},5,{"$f":"PRODUCT(J7*E34)","v":0}]
["Canada Wildrye","Elymus canadensis","0 to 10",null,0,0,{"$f":"PRODUCT(F35/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(11>G35),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},115000,2.6400367309458219,"",5,{"$f":"PRODUCT(J7*E35)","v":0}]
["Green Needlegrass","Stipa viridula","0 to 10",null,0,0,{"$f":"PRODUCT(F36/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(11>G36),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},180000,4.1322314049586772,"",5,{"$f":"PRODUCT(J7*E36)","v":0}]
["June grass","Koleria macrantha","0 to 5",null,0,0,{"$f":"PRODUCT(F37/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(6>G37),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},2315000,53.145087235996328,"",7,{"$f":"PRODUCT(J7*E37)","v":0}]
["Kalms Brome","Bromus kalmii","0 to 10",null,0,0,{"$f":"PRODUCT(F38/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(11>G38),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},128000,2.9384756657483928,"",5,{"$f":"PRODUCT(J7*E38)","v":0}]
["Porcupine grass ","Hesperostipa spartea","0 to 10",null,0,0,{"$f":"PRODUCT(F39/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(11>G39),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},57000,1.3085399449035813,"",6,{"$f":"PRODUCT(J7*E39)","v":0}]
["Slender Wheatgrass","Agropyron caninum","0 to 10",null,0,0,{"$f":"PRODUCT(F40/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(11>G40),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},155000,3.5583103764921948,"",5,{"$f":"PRODUCT(J7*E40)","v":0}]
["Virginia Wildrye","Elymus virginicus","0 to 10",null,0,0,{"$f":"PRODUCT(F41/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(11>G41),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},96000,2.2038567493112948,"",3,{"$f":"PRODUCT(J7*E41)","v":0}]
["Western Wheatgrass","Agropyron smithii","0 to 10",null,0,0,{"$f":"PRODUCT(F42/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(11>G42),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},112000,2.5711662075298438,"",2,{"$f":"PRODUCT(J7*E42)","v":0}]
[null,null,"0 to 10",null,0,0,{"$f":"PRODUCT(F43/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,"",null,{"$f":"PRODUCT(J7*E43)","v":0}]
[null,null,"0 to 10",null,0,0,{"$f":"PRODUCT(F44/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,"",null,{"$f":"PRODUCT(J7*E44)","v":0}]
[null,null,"0 to 10",null,0,0,{"$f":"PRODUCT(F45/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,"",null,{"$f":"PRODUCT(J7*E45)","v":0}]
[null,null,"0 to 10",null,0,0,{"$f":"PRODUCT(F46/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,"",null,{"$f":"PRODUCT(J7*E46)","v":0}]
[null,null,"0 to 10",null,0,{"$f":"PRODUCT(J47,E47)","v":0},{"$f":"PRODUCT(F47/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(11>G47),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},null,{"$f":"PRODUCT(I47/43560)","v":0},{"$f":"IF(E47=0,\"\",L47)","v":""},null,{"$f":"PRODUCT(J7*E47)","v":0}]
[null,null,"0 to 10",null,0,{"$f":"PRODUCT(J48,E48)","v":0},{"$f":"PRODUCT(F48/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(11>G48),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},null,{"$f":"PRODUCT(I48/43560)","v":0},{"$f":"IF(E48=0,\"\",L48)","v":""},null,{"$f":"Q72","v":0}]
[null,null,"0 to 10",null,0,0,{"$f":"PRODUCT(F49/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,"",null,{"$f":"PRODUCT(I13*E49)","v":0}]
[null,null,"0 to 10",null,0,0,{"$f":"PRODUCT(F50/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,"",null,{"$f":"PRODUCT(I13*E50)","v":0}]
[null,null,"0 to 10",null,0,0,{"$f":"PRODUCT(F51/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,"",null,{"$f":"PRODUCT(I14*E51)","v":0}]
[null,null,"0 to 10",null,0,0,{"$f":"PRODUCT(F52/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,"",null,{"$f":"PRODUCT(I16*E52)","v":0}]
[null,null,"0 to 10",null,0,0,{"$f":"PRODUCT(F53/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,"",null,{"$f":"PRODUCT(I16*E53)","v":0}]
[null,null,"0 to 10",null,0,0,{"$f":"PRODUCT(F54/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,"",null,{"$f":"PRODUCT(I16*E54)","v":0}]
[null,null,"0 to 10",null,0,0,{"$f":"PRODUCT(F55/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,"",null,{"$f":"PRODUCT(I16*E55)","v":0}]
[null,null,"0 to 10",null,0,{"$f":"PRODUCT(J56,E56)","v":0},{"$f":"PRODUCT(F56/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(11>G56),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},null,{"$f":"PRODUCT(I56/43560)","v":0},{"$f":"IF(E56=0,\"\",L56)","v":""},null,{"$f":"PRODUCT(I16*E56)","v":0}]
[null,null,"0 to 10",null,0,0,{"$f":"PRODUCT(F57/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,"",null,{"$f":"PRODUCT(I13*E57)","v":0}]
[null,null,null,null,"   "]
[null,null,"TOTAL Pounds PLS ",null,{"$f":"SUM(E17:E57)","v":0},{"$f":"SUM(F17:F57)","v":0},{"$f":"SUM(G17:G57)","v":{"$error":"#DIV/0!"}},null,null,"AVE COC GRASS",{"$f":"AVERAGE(K17:K57)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,{"$f":"SUM(G34:G57)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,{"$f":"IF(AND(20.1>G60,G60<100),\"\",\"COOL SEASON GRASSES EXCEED 20% OF THE MIX BASED ON SEEDS/FT\")","v":{"$error":"#DIV/0!"}}]
["1/  ACTUAL SEEDS PER SQUARE FOOT SHALL BE WITHIN THE RANGE SPECIFIED IN PLANNED CONDITION"]
["2/  NO MORE THAN 20% OF THE MIXTURE SHALL BE COMPRISED OF COOL SEASON GRASSES BASED ON SEEDS PER SQUARE FOOT."]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Background Information"]
["FORB SPECIES",null,null,null,"OUNCES","TOTAL SEEDS/","% OF FORB MIX BY SEEDS/FT 3/",null,"SEEDS/oz","SEEDS/","COC","COC","Pollinator Monarch  Preferred (X)","Bloom Period","Ounces PLS"]
[null,null,null,null,"PLS/AC.","SQ. FOOT",null,null,null,"SQ. FOOT","Selected","Reference"]
[null,null,null,null,null,null,null,null,null,"At 1 oz/ac Rate"]
[]
["DRY",null,null,null,null,null,null,null,null,null,null,null,"9/"]
["Bush Clover","Lespedeza capitata",null,null,0,{"$f":"PRODUCT(J75,E75)","v":0},{"$f":"PRODUCT(F75/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G75),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},8000,{"$f":"PRODUCT(I75/43560)","v":0.18365472910927455},{"$f":"IF(E75=0,\"\",L75)","v":""},3,null,"Late",{"$f":"PRODUCT(J7*E75)","v":0}]
["Culvers Root","Veronicastrum virginicum",null,null,0,0,{"$f":"PRODUCT(F76/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G76),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},800000,18.365472910927455,"",5,"H","Mid",{"$f":"PRODUCT(J7*E76)","v":0}]
["Dotted Blazingstar","Liatris punctata",null,null,0,0,{"$f":"PRODUCT(F77/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},7000,0.16069788797061524,"",8,"H","Mid",{"$f":"PRODUCT(J7*E77)","v":0}]
["Purple Coneflower, Narrow Leaved","Echinacea pallida var. angustifolia",null,null,0,0,{"$f":"PRODUCT(F78/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},7000,0.16069788797061524,"",8,"H","Mid",{"$f":"PRODUCT(J7*E78)","v":0}]
["Prairie Cinquefoil","Potentilla arguta",null,null,0,0,{"$f":"PRODUCT(F79/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},230000,5.2800734618916438,"",8,null,"Late",{"$f":"PRODUCT(J7*E79)","v":0}]
["Showy Penstemon","Penstemon grandifloris",null,null,0,0,{"$f":"PRODUCT(F80/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},14000,0.32139577594123048,"",5,null,"Early",{"$f":"PRODUCT(J7*E80)","v":0}]
["Stiff Sunflower","Helianthus paucifloris",null,null,0,0,{"$f":"PRODUCT(F81/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G81),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},4000,{"$f":"PRODUCT(I81/43560)","v":9.1827364554637275E-2},"",5,"H","Mid",{"$f":"PRODUCT(J7*E81)","v":0}]
["Silky Aster","Symphyotrichum sericeum",null,null,0,0,{"$f":"PRODUCT(F82/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},26000,0.59687786960514233,"",10,null,"Late",{"$f":"PRODUCT(J7*E82)","v":0}]
["DRY to MESIC",null,null,null,"   "]
["Butterfly Weed","Asclepias tuberosa",null,null,0,{"$f":"PRODUCT(J84,E84)","v":0},{"$f":"PRODUCT(F84/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G84),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},4300,{"$f":"PRODUCT(I84/43560)","v":9.8714416896235072E-2},{"$f":"IF(E84=0,\"\",L84)","v":""},6,"LH","Mid",{"$f":"PRODUCT(J7*E84)","v":0}]
["Canada Milkvetch","Astragalus canadensis","Legume",null,0,{"$f":"PRODUCT(J85,E85)","v":0},{"$f":"PRODUCT(F85/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G85),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},17000,{"$f":"PRODUCT(I85/43560)","v":0.39026629935720847},{"$f":"IF(E85=0,\"\",L85)","v":""},4,null,"Mid",{"$f":"PRODUCT(J7*E85)","v":0}]
["Compass Plant ","Silphium laciniatum",null,null,0,0,{"$f":"PRODUCT(F86/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},660,1.5151515151515152E-2,"",7,"H","Mid",{"$f":"PRODUCT(J7*E86)","v":0}]
["Evening Primrose","Oenothera biennis",null,null,0,0,{"$f":"PRODUCT(F87/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},90000,2.0661157024793386,"",4,null,"Mid",{"$f":"PRODUCT(J7*E87)","v":0}]
["Foxglove Beardtongue","Penstemon digitalis",null,null,0,{"$f":"PRODUCT(J88,E88)","v":0},{"$f":"PRODUCT(F88/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G88),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},130000,2.9843893480257115,"",5,null,"Early",{"$f":"PRODUCT(J7*E88)","v":0}]
["Heart-leaved Alexander","Zizia aptera",null,null,0,0,{"$f":"PRODUCT(F89/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},12000,0.27548209366391185,"",8,null,"Early",{"$f":"PRODUCT(J7*E89)","v":0}]
["Heath Aster","Symphyotrichum ericoides",null,null,0,0,{"$f":"PRODUCT(F90/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G90),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},200000,{"$f":"PRODUCT(I90/43560)","v":4.5913682277318637},"",3,null,"Late",{"$f":"PRODUCT(J7*E90)","v":0}]
["Hoary Vervain","Verbena stricta",null,null,0,0,{"$f":"PRODUCT(F91/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},28000,0.64279155188246095,"",1,"H","Mid",{"$f":"PRODUCT(J7*E91)","v":0}]
["Lance-leaved Coreopsis","Coreopsis lanceolata",null,null,0,0,{"$f":"PRODUCT(F92/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},20000,0.4591368227731864,"",5,"H","Early",{"$f":"PRODUCT(J7*E92)","v":0}]
["Leadplant","Amorpha canescens","Legume",null,0,0,{"$f":"PRODUCT(F93/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},16000,0.3673094582185491,"",8,"H","Mid",{"$f":"PRODUCT(J7*E93)","v":0}]
["Long -headed Coneflower","Ratibida columnifera",null,null,0,0,{"$f":"PRODUCT(F94/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},42000,0.96418732782369143,"",5,null,"Mid",{"$f":"PRODUCT(J7*E94)","v":0}]
["Ontario Blazingstar","Liatris cylindracea",null,null,0,0,{"$f":"PRODUCT(F95/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G95),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},14000,{"$f":"PRODUCT(I95/43560)","v":0.32139577594123048},"",8,"H","Late",{"$f":"PRODUCT(J7*E95)","v":0}]
["Prairie Smoke","Geum triflorum",null,null,0,0,{"$f":"PRODUCT(F96/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},27000,0.6198347107438017,"",8,null,"Early",{"$f":"PRODUCT(J7*E96)","v":0}]
["Rough Blazingstar","Liatris aspera",null,null,0,0,{"$f":"PRODUCT(F97/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},16000,0.3673094582185491,"",8,"VH","Late",{"$f":"PRODUCT(J7*E97)","v":0}]
["Showy Goldenrod","Solidago speciosa",null,null,0,0,{"$f":"PRODUCT(F98/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},95000,2.1808999081726355,"",7,"VH","Late",{"$f":"PRODUCT(J7*E98)","v":0}]
["Smooth Aster","Symphyotrichum laeva",null,null,0,0,{"$f":"PRODUCT(F99/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},55000,1.2626262626262625,"",7,"H","Late",{"$f":"PRODUCT(J7*E99)","v":0}]
["Spotted Beebalm","Monarda punctata",null,null,0,0,{"$f":"PRODUCT(F100/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},70000,1.6069788797061524,"",6,"H","Mid",{"$f":"PRODUCT(J7*E100)","v":0}]
["Stiff Tickseed","Coreopsis  palmata",null,null,0,0,{"$f":"PRODUCT(F101/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},10000,0.2295684113865932,"",7,"H","Mid",{"$f":"PRODUCT(J7*E101)","v":0}]
["Thimbleweed","Anemone cylindrica",null,null,0,0,{"$f":"PRODUCT(F102/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},26000,0.59687786960514233,"",7,null,"Mid",{"$f":"PRODUCT(J7*E102)","v":0}]
["Whorled Milkweed","Asclepias verticillata",null,null,0,0,{"$f":"PRODUCT(F103/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},11000,0.25252525252525254,"",4,"LH","Mid-Late",{"$f":"PRODUCT(J7*E103)","v":0}]
["Wild Blue Phlox","Phlox divaricata",null,null,0,{"$f":"PRODUCT(J104,E104)","v":0},{"$f":"PRODUCT(F104/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G104),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},12500,{"$f":"PRODUCT(I104/43560)","v":0.28696051423324148},{"$f":"IF(E104=0,\"\",L104)","v":""},7,"H","Early",{"$f":"PRODUCT(J7*E104)","v":0}]
["Wild Columbine","Aquilegia canadensis",null,null,0,0,{"$f":"PRODUCT(F105/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},38000,0.87235996326905418,"",6,null,"Early",{"$f":"PRODUCT(J7*E105)","v":0}]
["MESIC to WET",null,null,null,"   "]
["Blanketflower","Gaillardia aristata",null,null,0,{"$f":"PRODUCT(J107,E107)","v":0},{"$f":"PRODUCT(F107/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G107),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},9813,{"$f":"PRODUCT(I107/43560)","v":0.22527548209366391},{"$f":"IF(E107=0,\"\",L107)","v":""},2,null,"Mid",{"$f":"PRODUCT(J7*E107)","v":0}]
["Canada Tick Trefoil","Desmodium canadense","Legume",null,0,0,{"$f":"PRODUCT(F108/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},5500,0.12626262626262627,"",6,null,"Mid",{"$f":"PRODUCT(J7*E108)","v":0}]
["Common Ox-eye","Heliopsis helianthoides",null,null,0,0,{"$f":"PRODUCT(F109/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},6300,0.14462809917355371,"",4,"H","Mid",{"$f":"PRODUCT(J7*E109)","v":0}]
["Giant Sunflower","Helianthus giganteus",null,null,0,0,{"$f":"PRODUCT(F110/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},10000,0.2295684113865932,"",5,"H","Late",{"$f":"PRODUCT(J7*E110)","v":0}]
["Golden Alexanders","Zizia aurea",null,null,0,0,{"$f":"PRODUCT(F111/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},11000,0.25252525252525254,"",6,null,"Early",{"$f":"PRODUCT(J7*E111)","v":0}]
["Great Blue Lobelia","Lobelia siphilitica",null,null,0,0,{"$f":"PRODUCT(F112/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},500000,11.478420569329661,"",3,"H","Late",{"$f":"PRODUCT(J7*E112)","v":0}]
["Ironweed","Veronia fasticulata",null,null,0,0,{"$f":"PRODUCT(F113/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},24000,0.55096418732782371,"",3,"H","Late",{"$f":"PRODUCT(J7*E113)","v":0}]
["Meadow Blazingstar","Liatris ligulistylis",null,null,0,0,{"$f":"PRODUCT(F114/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G114),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},11000,0.25252525252525254,"",8,"VH","Late",{"$f":"PRODUCT(J7*E114)","v":0}]
["Mountain Mint","Pycnanthemum virginianum",null,null,0,0,{"$f":"PRODUCT(F115/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G115),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},220000,{"$f":"PRODUCT(I115/43560)","v":5.0505050505050502},"",8,null,"Mid",{"$f":"PRODUCT(J7*E115)","v":0}]
["Partridge Pea","Cassia fasticulata","Legume",null,0,0,{"$f":"PRODUCT(F116/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},2700,{"$f":"PRODUCT(I116/43560)","v":6.1983471074380167E-2},"",1,null,"Mid",{"$f":"PRODUCT(J7*E116)","v":0}]
["Rattlesnake Master","Eryngium yuccifolium",null,null,0,0,{"$f":"PRODUCT(F117/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},7500,0.17217630853994489,"",8,"H","Mid",{"$f":"PRODUCT(J7*E117)","v":0}]
["Sawtooth Sunflower","Helianthus grosseserratus",null,null,0,0,{"$f":"PRODUCT(F118/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},10000,0.2295684113865932,"",4,"H","Late",{"$f":"PRODUCT(J7*E118)","v":0}]
["Tall Blazingstar","Liatris pycnostachya",null,null,0,0,{"$f":"PRODUCT(F119/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},11000,0.25252525252525254,"",6,"H","Mid",{"$f":"PRODUCT(J7*E119)","v":0}]
["Virginia Bluebells","Mertenias virginica",null,null,0,{"$f":"PRODUCT(J120,E120)","v":0},{"$f":"PRODUCT(F120/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G120),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},9700,{"$f":"PRODUCT(I120/43560)","v":0.22268135904499542},{"$f":"IF(E120=0,\"\",L120)","v":""},6,"H","Early",{"$f":"PRODUCT(J7*E120)","v":0}]
["Wild Bergamot","Monarda fistulosa",null,null,0,0,{"$f":"PRODUCT(F121/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},70000,1.6069788797061524,"",2,"VH","Mid",{"$f":"PRODUCT(J7*E121)","v":0}]
["Yellow Coneflower","Ratibida pinnata",null,null,0,0,{"$f":"PRODUCT(F122/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},30000,0.68870523415977958,"",4,null,"Mid",{"$f":"PRODUCT(J7*E122)","v":0}]
["WET",null,null,null,"   "]
["Blue Vervain","Verbena hastata",null,null,0,{"$f":"PRODUCT(J124,E124)","v":0},{"$f":"PRODUCT(F124/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G124),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},93000,{"$f":"PRODUCT(I124/43560)","v":2.1349862258953167},{"$f":"IF(E124=0,\"\",L124)","v":""},3,null,"Mid",{"$f":"PRODUCT(J7*E124)","v":0}]
["Boneset","Eupatorium perfoliatum",null,null,0,0,{"$f":"PRODUCT(F125/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},160000,3.6730945821854912,"",6,"H","Late",{"$f":"PRODUCT(J7*E125)","v":0}]
["Cup Plant","Silphium perfoliatum",null,null,0,0,{"$f":"PRODUCT(F126/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},1400,3.2139577594123052E-2,"",1,"H","Mid",{"$f":"PRODUCT(J7*E126)","v":0}]
["Joe-pye Weed","Eutrochium maculatum",null,null,0,0,{"$f":"PRODUCT(F127/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},95000,2.1808999081726355,"",5,"VH","Mid",{"$f":"PRODUCT(J7*E127)","v":0}]
["New England Aster","Symphyotrichum novae-angliae",null,null,0,0,{"$f":"PRODUCT(F128/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},66000,1.5151515151515151,"",3,"VH","Late",{"$f":"PRODUCT(J7*E128)","v":0}]
["Panicled Aster","Symphyotrichum lanceolatum",null,null,0,0,{"$f":"PRODUCT(F129/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},156000,3.5812672176308542,"",4,null,"Late",{"$f":"PRODUCT(J7*E129)","v":0}]
["Sneezeweed","Helenium autumnale",null,null,0,0,{"$f":"PRODUCT(F130/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G130),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},130000,{"$f":"PRODUCT(I130/43560)","v":2.9843893480257115},"",4,null,"Late",{"$f":"PRODUCT(J7*E130)","v":0}]
["Swamp Milkweed  ","Asclepias incarnata",null,null,0,0,{"$f":"PRODUCT(F131/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},4800,0.11019283746556474,"",4,"LH","Mid",{"$f":"PRODUCT(J7*E131)","v":0}]
["DRY to WET",null,null,null,"   "]
["Anise Hyssop","Agastache foeniculum",null,null,0,{"$f":"PRODUCT(J133,E133)","v":0},{"$f":"PRODUCT(F133/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G133),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},91000,{"$f":"PRODUCT(I133/43560)","v":2.089072543617998},{"$f":"IF(E133=0,\"\",L133)","v":""},4,null,"Mid",{"$f":"PRODUCT(J7*E133)","v":0}]
["Black-eyed Susan","Rudbeckia hirta",null,null,0,{"$f":"PRODUCT(J134,E134)","v":0},{"$f":"PRODUCT(F134/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G134),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},92000,{"$f":"PRODUCT(I134/43560)","v":2.1120293847566574},{"$f":"IF(E134=0,\"\",L134)","v":""},2,"H","Late",{"$f":"PRODUCT(J7*E134)","v":0}]
["Common Milkweed","Asclepias syriaca",null,null,0,0,{"$f":"PRODUCT(F135/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G135),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},4000,{"$f":"PRODUCT(I135/43560)","v":9.1827364554637275E-2},"",1,"LH","Mid",{"$f":"PRODUCT(J7*E135)","v":0}]
["Grassleaved Goldenrod","Euthamia  graminifolia",null,null,0,0,{"$f":"PRODUCT(F136/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G136),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},350000,{"$f":"PRODUCT(I136/43560)","v":8.0348943985307617},"",4,"H","Mid",{"$f":"PRODUCT(J7*E136)","v":0}]
["Illinois Bundleflower","Desmanthus illinoensis",null,null,0,0,{"$f":"PRODUCT(F137/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},4200,9.6418732782369149E-2,"",4,null,"Mid",{"$f":"PRODUCT(J7*E137)","v":0}]
["Purple Prairie Clover","Petalostemum purpurum","Legume",null,0,0,{"$f":"PRODUCT(F138/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},18000,0.41322314049586778,"",8,null,"Mid",{"$f":"PRODUCT(J7*E138)","v":0}]
["Maximillian Sunflower","Helianthus maximiliani",null,null,0,0,{"$f":"PRODUCT(F139/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},13000,0.29843893480257117,"",4,"H","Late",{"$f":"PRODUCT(J7*E139)","v":0}]
["Stiff Goldenrod","Solidago rigida",null,null,0,0,{"$f":"PRODUCT(F140/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},41000,0.94123048668503217,"",4,"VH","Late",{"$f":"PRODUCT(J7*E140)","v":0}]
["White Prairie Clover","Petalostemum candidum","Legume",null,0,0,{"$f":"PRODUCT(F141/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},19000,0.43617998163452709,"",10,"H","Mid",{"$f":"PRODUCT(J7*E141)","v":0}]
["Yarrow","Achillea millefolium",null,null,0,0,{"$f":"PRODUCT(F142/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G142),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},180000,{"$f":"PRODUCT(I142/43560)","v":4.1322314049586772},"",1,null,"Mid",{"$f":"PRODUCT(J7*E142)","v":0}]
["Yellow Giant Hyssop","Agastache nepetoides ",null,null,0,0,{"$f":"PRODUCT(F143/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G143),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},91000,{"$f":"PRODUCT(I143/43560)","v":2.089072543617998},"",4,"H","Late",{"$f":"PRODUCT(J7*E143)","v":0}]
["ADDITIONAL APPROVED FORBS 7/",null,null,null,"   "]
[null,null,null,null,0,{"$f":"PRODUCT(J145,E145)","v":0},{"$f":"PRODUCT(F145/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G145),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},null,{"$f":"PRODUCT(I145/43560)","v":0},{"$f":"IF(E145=0,\"\",L145)","v":""},null,null,null,{"$f":"PRODUCT(J7*E145)","v":0}]
[null,null,null,null,0,0,{"$f":"PRODUCT(F146/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,"",null,null,null,{"$f":"PRODUCT(J7*E146)","v":0}]
[null,null,null,null,0,0,{"$f":"PRODUCT(F147/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,"",null,null,null,{"$f":"PRODUCT(J7*E147)","v":0}]
[null,null,null,null,0,0,{"$f":"PRODUCT(F148/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,"",null,null,null,{"$f":"PRODUCT(J7*E148)","v":0}]
[null,null,null,null,0,0,{"$f":"PRODUCT(F149/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,"",null,null,null,{"$f":"PRODUCT(J7*E149)","v":0}]
[null,null,null,null,0,0,{"$f":"PRODUCT(F150/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,"",null,null,null,{"$f":"PRODUCT(J7*E150)","v":0}]
[]
[null,null,"TOTAL OUNCES PLS",null,{"$f":"SUM(E75:E150)","v":0},{"$f":"SUM(F75:F150)","v":0},{"$f":"SUM(G75:G150)","v":{"$error":"#DIV/0!"}},null,null,"AVE COC ",{"$f":"AVERAGE(K75:K150)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,"3/  Individual species not to exceed 20% of the forb component by seeds/ft"]
["TOTAL SEEDS/FT4",null,{"$f":"SUM(F59,F152)","v":0},null,{"$f":"IF(AND(35<C155),\"OK\",\"LOW\")","v":"LOW"},"4/  Minimum 35-40 seeds/square foot"]
["PERCENT GRASS5",null,{"$f":"PRODUCT(F59/C155)*100","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AND(60>C156),\"\",\"HIGH\")","v":{"$error":"#DIV/0!"}},"5/  Maximum 60% grasses "]
["PERCENT FLOWER",null,{"$f":"PRODUCT(F152/C155)*100","v":{"$error":"#DIV/0!"}},null,null,"6/ Assignment of Coefficients"]
["AVE. COC - MIX",null,{"$f":"AVERAGE(K17:K57,K75:K150)","v":{"$error":"#DIV/0!"}},null,null,"0 to 3 : Plants with a high range of ecological tolerances/found in a variety of plant communities"]
["SPECIES RICHNESS",null,{"$f":"COUNT(K17:K57,K75:K150)","v":0},null,null,"4 to 6 : Plants with an intermediate range of ecological tolerances/ associated with a specific plant community"]
["MILKWEED %8",null,{"$f":"SUM((F84+F103+F131+F135)/C155)*100","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AND(1<C160),\"OK\",\"LOW\")","v":{"$error":"#DIV/0!"}},"7 to 8 : Plants with a poor range of ecological tolerances/associated with advanced successional stage"]
["% FORBS THAT ARE MONARCH PREFERRED9",null,{"$f":"PRODUCT(E168/E169)*100","v":{"$error":"#DIV/0!"}},null,null,"9 to 10 : Plants with a high degree of fidelity to a narrow range of pristine habitats"]
[null,null,null,null,null,"7/ Consult with the appropriate NRCS Area Resource Conservationist or Biologist for prior approval of additional species."]
[]
[null,null,null,null,null,"8/ A minimum 1% of the total mix(based on seeds/ft2) will be comprised of milkweeds. A. syriaca shall comprise at least 50% of milkweeds"]
[]
[null,null,null,null,null,"9/ A minimum 60% of the forbs must be Pollinator/Monarch preferred (Column M)."]
["Total Forb Species by Bloom Period"]
["Early Total",null,{"$f":"COUNTIF(E80, \">0\")+ COUNTIF(E88:E89, \">0\")+ COUNTIF(E92, \">0\") + COUNTIF(E96, \">0\")+ COUNTIF(E104:E105, \">0\") +COUNTIF(E111,\">0\") +COUNTIF(E120,\">0\")+COUNTIFS(E145:E150,\">0\",N145:N150,\"Early\")","v":0},{"$f":"COUNTIF(E76:E78, \">0\")+ COUNTIF(E81, \">0\")+ COUNTIF(E84, \">0\") + COUNTIF(E86, \">0\")+ COUNTIF(E91:E93, \">0\") +COUNTIF(E95,\">0\") +COUNTIF(E97:E101,\">0\")+COUNTIF(E103:E104,\">0\")+COUNTIFS(E109:E110,\">0\")+COUNTIFS(E112:E114,\">0\")+COUNTIFS(E117:E121,\">0\")+COUNTIFS(E125:E128,\">0\")+COUNTIFS(E131,\">0\")+COUNTIFS(E134:E136,\">0\")+COUNTIFS(E139:E141,\">0\")+COUNTIFS(E143,\">0\")+COUNTIFS(E145:E150,\">0\",M145:M150,\"X\")","v":0},{"$f":"COUNTIFS(E75:E150,\">0\",M75:M150,\"=H\")+COUNTIFS(E75:E150,\">0\",M75:M150,\"=VH\")+COUNTIFS(E75:E150,\">0\",M75:M150,\"=LH\")","v":0}]
["Mid Total",null,{"$f":"COUNTIF(E76:E78,\">0\")+COUNTIF(E81,\">0\")+COUNTIF(E84:E87,\">0\")+COUNTIF(E91,\">0\")+COUNTIF(E93:E94,\">0\")+COUNTIF(E100:E102,\">0\")+COUNTIF(E107:E109,\">0\")+COUNTIF(E115:E117,\">0\")+COUNTIF(E119,\">0\")+COUNTIF(E121:E124,\">0\")+COUNTIF(E126:E127,\">0\")+COUNTIF(E131:E133,\">0\")+COUNTIF(E135:E138,\">0\")+COUNTIF(E141:E142,\">0\")+COUNTIFS(E145:E150,\">0\",N145:N150,\"Mid\")","v":0},{"$f":"SUM(C168:C170)","v":0},{"$f":"SUM(C168,C169,C170)","v":0}]
["Late Total",null,{"$f":"COUNTIF(E75,\">0\") + COUNTIF(E79,\">0\") +COUNTIF(E82,\">0\") +COUNTIF(E90,\">0\") + COUNTIF(E95,\">0\") + COUNTIF(E97:E99,\">0\")+ COUNTIF(E103,\">0\") + COUNTIF(E110,\">0\") + COUNTIF(E112:E114,\">0\")+COUNTIF(E118,\">0\") +COUNTIF(E125,\">0\")+COUNTIF(E128:E130,\">0\")+COUNTIF(E134,\">0\")+COUNTIF(E139:E140,\">0\")+COUNTIF(E143,\">0\")+COUNTIFS(E145:E150,\">0\",N145:N150,\"Late\")","v":0}]

{"sheet":"327 CREP CP2 Monarch Food Plot","index":4,"n_rows":179,"n_cols":14,"rows_kept":179,"cut":false,"hidden":false,"merged":[[69,12,72,12],[69,13,72,13],[10,0,10,2],[10,8,10,9],[11,0,13,0],[11,10,13,10],[66,0,66,2],[58,0,58,2],[11,6,13,6],[124,0,124,1],[150,0,150,2],[151,0,151,2],[153,4,154,8],[68,8,68,9],[69,0,71,0],[69,6,71,6],[4,1,4,2],[4,7,4,8],[6,1,6,2],[6,7,6,8],[0,0,0,14],[1,0,1,14],[7,4,7,7],[9,5,9,9],[14,2,15,2],[14,6,15,6],[14,7,15,7],[14,8,15,10],[156,4,156,9],[157,4,157,9],[158,4,158,7],[159,1,161,1],[159,2,161,2],[160,4,160,12]]}
["CREP 327 CP-2  MONARCH FOOD PLOT"]
["Seeding Design"]
[null,null,null,null,null,null,null,null,"DATE",{"$f":"TODAY()","v":"2022-06-16"}]
[]
["LANDOWNER",null,null,null,null,null,null,"TRACT/FIELD"]
[]
["PLANNER",null,null,null,null,null,null,"ACRES SEEDED"]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Background Information"]
["GRASS SPECIES",null,"PLANNED %",null,"POUNDS","TOTAL SEEDS/","% OF GRASS MIX BY SEEDS/FT 1/",null,"SEEDS/lb.","SEEDS/","POUNDS PLS"]
[null,null,"OF GRASS COMPONENT BY",null,"PLS/AC.","SQ. FOOT",null,null,null,"SQ. FOOT"]
[null,null,"SEEDS/SQ. FOOT",null,"DRILL",null,null,null,null,"At 1 lb/ac Rate"]
[null,null,"Planned",null,null,null,"Can't Exceed","Planned %"]
[]
["Big Bluestem or Indiangrass",null,"0 to 25",null,0,{"$f":"PRODUCT(J17,E17)","v":0},{"$f":"PRODUCT(F17/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(26>G17),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},176000,{"$f":"PRODUCT(I17/43560)","v":4.0404040404040407},{"$f":"PRODUCT(J7,E17)","v":0}]
["Canada/Virginia Wildrye",null,"0 to 10",null,0,{"$f":"PRODUCT(J18,E18)","v":0},{"$f":"PRODUCT(F18/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(11>G18),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},96000,{"$f":"PRODUCT(I18/43560)","v":2.2038567493112948},{"$f":"PRODUCT(J7,E18)","v":0}]
["Little Bluestem","Schizachryrium scoparium","0 to 50",null,0,0,{"$f":"PRODUCT(F19/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(51>G19),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},286000,6.5656565656565657,{"$f":"PRODUCT(J7,E19)","v":0}]
["Prairie Dropseed","Sporopolus heterolepis","0 to 50",null,0,0,{"$f":"PRODUCT(F20/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(51>G20),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},224000,5.1423324150596876,{"$f":"PRODUCT(J7,E20)","v":0}]
["Rough Dropseed","Sporobolus compositus","0 to 25",null,0,0,{"$f":"PRODUCT(F21/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(26>G21),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},480000,11.019283746556473,{"$f":"PRODUCT(J7,E21)","v":0}]
["Side-oats grama","Bouteloua curtipendula","0 to 25",null,0,0,{"$f":"PRODUCT(F22/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(26>G22),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},180000,4.1322314049586772,{"$f":"PRODUCT(J7,E22)","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[]
["TOTAL - Pounds PLS Drill Seeding",null,null,null,{"$f":"SUM(E17:E22)","v":0},{"$f":"SUM(F17:F22)","v":0},{"$f":"SUM(G17:G22)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
["1/  ACTUAL SEEDS PER SQUARE FOOT SHALL BE WITHIN THE RANGE SPECIFIED IN PLANNED CONDITION"]
[null,null,null,null,null,null,null,null,"Background Information"]
["FORB SPECIES",null,null,null,"OUNCES","TOTAL SEEDS/","% OF FORB MIX BY SEEDS/FT 2/",null,"SEEDS/oz","SEEDS/","Bloom Period","BLOOM","MONARCH  ","OUNCES PLS"]
[null,null,null,null,"PLS/AC.","SQ. FOOT",null,null,null,"SQ. FOOT","Early = April-June","COLOR"]
[null,null,null,null,"DRILL",null,null,null,null,"At 1 oz/ac Rate","Mid = June-August"]
[null,null,null,null,null,null,null,null,null,null,"Late = August-Oct."]
["DRY TO MESIC",null,null,null,null,null,null,null,null,null,null,null,"4/"]
["Butterfly Weed","Asclepias tuberosa",null,null,0,{"$f":"PRODUCT(J75,E75)","v":0},{"$f":"PRODUCT(F75/F151,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G75),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},4300,{"$f":"PRODUCT(I75/43560)","v":9.8714416896235072E-2},"Mid","Orange","LH",{"$f":"PRODUCT(J7,E75)","v":0}]
["Compass Plant","Sliphium lactinatum",null,null,0,0,{"$f":"PRODUCT(F76/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},660,1.5151515151515152E-2,"Mid","Yellow","H",{"$f":"PRODUCT(J7,E76)","v":0}]
["Culvers Root","Veronicastrum virg.",null,null,0,0,{"$f":"PRODUCT(F77/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},800000,18.365472910927455,"Mid","White","H",{"$f":"PRODUCT(J7,E77)","v":0}]
["Dotted Blazingstar","Liatris punctata",null,null,0,0,{"$f":"PRODUCT(F78/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},7000,0.16069788797061524,"Mid","Rose ","H",{"$f":"PRODUCT(J7,E78)","v":0}]
["Foxglove Beardtongue","Penstemon digitalis",null,null,0,0,{"$f":"PRODUCT(F79/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},130000,2.9843893480257115,"Early","Yellow ",null,{"$f":"PRODUCT(J7,E79)","v":0}]
["Ground Plum","Astragalus crassicarpus",null,null,0,0,{"$f":"PRODUCT(F80/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},5200,0.11937557392102846,"Early","Purple",null,{"$f":"PRODUCT(J7,E80)","v":0}]
["Hoary Vervain","Verbena stricta",null,null,0,0,{"$f":"PRODUCT(F81/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},28000,0.64279155188246095,"Mid","Blue","H",{"$f":"PRODUCT(J7,E81)","v":0}]
["Lance-leaved Coreopsis","Coreopsis lanceolata",null,null,0,0,{"$f":"PRODUCT(F82/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},20000,0.4591368227731864,"Early","White","H",{"$f":"PRODUCT(J7,E82)","v":0}]
["Leadplant","Amorpha canescens","Legume",null,0,0,{"$f":"PRODUCT(F83/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},16000,0.3673094582185491,"Mid","Purple","H",{"$f":"PRODUCT(J7,E83)","v":0}]
["Ontario Blazingstar","Liatris cylindracea",null,null,0,0,{"$f":"PRODUCT(F84/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},14000,0.32139577594123048,"Late","Purple","H",{"$f":"PRODUCT(J7,E84)","v":0}]
["Purple Coneflower, Narrow Leaved","Echinacea angustifolia",null,null,0,0,{"$f":"PRODUCT(F85/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},7000,0.16069788797061524,"Mid","Pink","H",{"$f":"PRODUCT(J7,E85)","v":0}]
["Purple Coneflower, Eastern","Echinacea  purpurea",null,null,0,0,{"$f":"PRODUCT(F86/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},7000,0.16069788797061524,"Mid","Pink","VH",{"$f":"PRODUCT(J7,E86)","v":0}]
["Rough Blazingstar","Liatris aspera",null,null,0,0,{"$f":"PRODUCT(F87/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},16000,0.3673094582185491,"Late","Purple","VH",{"$f":"PRODUCT(J7,E87)","v":0}]
["Showy Goldenrod","Solidago speciosa",null,null,0,0,{"$f":"PRODUCT(F88/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},95000,2.1808999081726355,"Late","Yellow ","VH",{"$f":"PRODUCT(J7,E88)","v":0}]
["Large-flowered Penstemon","Penstemon grandifloris",null,null,0,0,{"$f":"PRODUCT(F89/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},14000,0.32139577594123048,"Early","Lavender",null,{"$f":"PRODUCT(J7,E89)","v":0}]
["Sky Blue Aster","Symphyotrichum oolentangiense",null,null,0,0,{"$f":"PRODUCT(F90/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},80000,1.8365472910927456,"Late","Blue","H",{"$f":"PRODUCT(J7,E90)","v":0}]
["Smooth Aster","Symphyotrichum laeva",null,null,0,0,{"$f":"PRODUCT(F91/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},55000,1.2626262626262625,"Late","Blue","H",{"$f":"PRODUCT(J7,E91)","v":0}]
["Spotted Beebalm","Monarda punctata",null,null,0,0,{"$f":"PRODUCT(F92/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},70000,1.6069788797061524,"Mid","Lavender","H",{"$f":"PRODUCT(J7,E92)","v":0}]
["Stiff Sunflower","Helianthus pacuifloris",null,null,0,0,{"$f":"PRODUCT(F93/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},4000,9.1827364554637275E-2,"Mid","Yellow","H",{"$f":"PRODUCT(J7,E93)","v":0}]
["Stiff Tickseed","Coreopsis  palmata",null,null,0,0,{"$f":"PRODUCT(F94/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},10000,0.2295684113865932,"Mid","Yellow ","H",{"$f":"PRODUCT(J7,E94)","v":0}]
["Wild Blue Phlox","Phlox divaricata",null,null,0,{"$f":"PRODUCT(J95,E95)","v":0},{"$f":"PRODUCT(F95/F151,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G95),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},12500,{"$f":"PRODUCT(I95/43560)","v":0.28696051423324148},"Early","Blue","H",{"$f":"PRODUCT(J7,E95)","v":0}]
["Wild Lupine","Lupinus perrenis","Legume",null,0,{"$f":"PRODUCT(J96,E96)","v":0},{"$f":"PRODUCT(F96/F151,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G96),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},1100,{"$f":"PRODUCT(I96/43560)","v":2.5252525252525252E-2},"Early","Lavender",null,{"$f":"PRODUCT(J7,E96)","v":0}]
["Wild White Indigo","Baptista leucantha","Legume",null,0,{"$f":"PRODUCT(J97,E97)","v":0},{"$f":"PRODUCT(F97/F151,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G97),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},1700,{"$f":"PRODUCT(I97/43560)","v":3.9026629935720848E-2},"Early","White",null,{"$f":"PRODUCT(J7,E97)","v":0}]
["Whorled Milkweed","Asclepias verticillata",null,null,0,{"$f":"PRODUCT(J98,E98)","v":0},{"$f":"PRODUCT(F98/F151,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G98),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},11000,{"$f":"PRODUCT(I98/43560)","v":0.25252525252525254},"Mid - Late","White","LH",{"$f":"PRODUCT(J7,E98)","v":0}]
["MESIC to WET MESIC",null,null,null,"  "]
["Common Ox-eye","Heliopsis helianthoides",null,null,0,{"$f":"PRODUCT(J100,E100)","v":0},{"$f":"PRODUCT(F100/F151,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G100),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},6300,{"$f":"PRODUCT(I100/43560)","v":0.14462809917355371},"Mid","Yellow","H",{"$f":"PRODUCT(J7,E100)","v":0}]
["Giant Sunflower","Helianthus giganteus",null,null,0,0,{"$f":"PRODUCT(F101/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},10000,0.2295684113865932,"Late","Yellow","H",{"$f":"PRODUCT(J7,E101)","v":0}]
["Great Blue Lobelia","Lobelia siphilitica",null,null,0,0,{"$f":"PRODUCT(F102/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},500000,11.478420569329661,"Late","Blue","H",{"$f":"PRODUCT(J7,E102)","v":0}]
["Ironweed","Veronia fasciculata",null,null,0,0,{"$f":"PRODUCT(F103/F151,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G103),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},24000,0.55096418732782371,"Late","Purple","H",{"$f":"PRODUCT(J7,E103)","v":0}]
["Meadow Blazingstar","Liatris ligulistylis",null,null,0,0,{"$f":"PRODUCT(F104/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},11000,0.25252525252525254,"Late","Purple","VH",{"$f":"PRODUCT(J7,E104)","v":0}]
["Rattlesnake Master","Eryngium yuccifolium",null,null,0,0,{"$f":"PRODUCT(F105/F151,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G105),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},7500,0.17217630853994489,"Mid","White","H",{"$f":"PRODUCT(J7,E105)","v":0}]
["Sawtooth Sunflower","Helianthus grosseserratus",null,null,0,0,{"$f":"PRODUCT(F106/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},10000,0.2295684113865932,"Late","Yellow","H",{"$f":"PRODUCT(J7,E106)","v":0}]
["Tall Blazingstar","Liatris pycnostachya",null,null,0,0,{"$f":"PRODUCT(F107/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},11000,0.25252525252525254,"Mid","Purple","H",{"$f":"PRODUCT(J7,E107)","v":0}]
["Virginia Bluebells","Mertensia virginica",null,null,0,0,{"$f":"PRODUCT(F108/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},9700,0.22268135904499542,"Early","Blue","H",{"$f":"PRODUCT(J7,E108)","v":0}]
["Wild Bergamot","Monarda fistulosa",null,null,0,0,{"$f":"PRODUCT(F109/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},70000,1.6069788797061524,"Mid","Lavender","VH",{"$f":"PRODUCT(J7,E109)","v":0}]
["WET",null,null,null,"  "]
["Boneset","Eupatorium perfoliatum",null,null,0,{"$f":"PRODUCT(J111,E111)","v":0},{"$f":"PRODUCT(F111/F151,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G111),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},160000,{"$f":"PRODUCT(I111/43560)","v":3.6730945821854912},"Late","White ","H",{"$f":"PRODUCT(J7,E111)","v":0}]
["Cup Plant","Silphium perfoliatum",null,null,0,{"$f":"PRODUCT(J112,E112)","v":0},{"$f":"PRODUCT(F112/F151,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G112),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},1400,{"$f":"PRODUCT(I112/43560)","v":3.2139577594123052E-2},"Mid","Yellow","H",{"$f":"PRODUCT(J7,E112)","v":0}]
["Joe-pye Weed","Eutrochium maculatum",null,null,0,{"$f":"PRODUCT(J113,E113)","v":0},{"$f":"PRODUCT(F113/F151,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G113),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},95000,{"$f":"PRODUCT(I113/43560)","v":2.1808999081726355},"Mid","Rose ","VH",{"$f":"PRODUCT(J7,E113)","v":0}]
["New England Aster","Symphyotrichum novae-angliae",null,null,0,{"$f":"PRODUCT(J114,E114)","v":0},{"$f":"PRODUCT(F114/F151,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G114),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},66000,{"$f":"PRODUCT(I114/43560)","v":1.5151515151515151},"Late","Purple","VH",{"$f":"PRODUCT(J7,E114)","v":0}]
["Swamp Milkweed  ","Asclepias incarnata",null,null,0,{"$f":"PRODUCT(J115,E115)","v":0},{"$f":"PRODUCT(F115/F151,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G115),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},4800,{"$f":"PRODUCT(I115/43560)","v":0.11019283746556474},"Mid","Red","LH",{"$f":"PRODUCT(J7,E115)","v":0}]
["DRY to WET MESIC",null,null,null,"  "]
["Black-eyed Susan","Rudbeckia hirta",null,null,0,{"$f":"PRODUCT(J117,E117)","v":0},{"$f":"PRODUCT(F117/F151,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G117),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},92000,{"$f":"PRODUCT(I117/43560)","v":2.1120293847566574},"Late","Yellow","H",{"$f":"PRODUCT(J7,E117)","v":0}]
["Common Milkweed","Asclepias syriaca",null,null,0,0,{"$f":"PRODUCT(F118/F151,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G118),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},4000,9.1827364554637275E-2,"Mid","Purple","LH",{"$f":"PRODUCT(J7,E118)","v":0}]
["Yellow Giant Hyssop","Agastache nepetoides ",null,null,0,0,{"$f":"PRODUCT(F119/F151,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G119),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},91000,2.089072543617998,"Late","Purple","H",{"$f":"PRODUCT(J7,E119)","v":0}]
["Grassleaved Goldenrod","Euthamia graminifolia",null,null,0,0,{"$f":"PRODUCT(F120/F151,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G120),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},350000,8.0348943985307617,"Mid","Yellow","H",{"$f":"PRODUCT(J7,E120)","v":0}]
["Maximillian Sunflower","Helianthus maximiliani",null,null,0,0,{"$f":"PRODUCT(F121/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},13000,0.29843893480257117,"Late","Yellow","H",{"$f":"PRODUCT(J7,E121)","v":0}]
["Spiderworts","Tradescantia spp.",null,null,0,0,{"$f":"PRODUCT(F122/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},10000,0.2295684113865932,"Early","Blue",null,{"$f":"PRODUCT(J7,E122)","v":0}]
["Stiff Goldenrod","Solidago rigida",null,null,0,0,{"$f":"PRODUCT(F123/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},41000,0.94123048668503217,"Late","Yellow","VH",{"$f":"PRODUCT(J7,E123)","v":0}]
["White Prairie Clover","Dalea candida","Legume",null,0,0,{"$f":"PRODUCT(F124/F151,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G124),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},19000,{"$f":"PRODUCT(I124/43560)","v":0.43617998163452709},"Mid","White","H",{"$f":"PRODUCT(J7,E124)","v":0}]
["ADDITIONAL APPROVED SPECIES 7/",null,null,null,"  "]
[null,null,null,null,0,{"$f":"PRODUCT(J126,E126)","v":0},{"$f":"PRODUCT(F126/F151,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G126),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},null,{"$f":"PRODUCT(I126/43560)","v":0},null,null,null,{"$f":"PRODUCT(J7,E126)","v":0}]
[null,null,null,null,0,0,{"$f":"PRODUCT(F127/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,null,null,null,{"$f":"PRODUCT(J7,E127)","v":0}]
[null,null,null,null,0,0,{"$f":"PRODUCT(F128/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,null,null,null,{"$f":"PRODUCT(J7,E128)","v":0}]
[null,null,null,null,0,0,{"$f":"PRODUCT(F129/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,null,null,null,{"$f":"PRODUCT(J9,E129)","v":0}]
[null,null,null,null,0,0,{"$f":"PRODUCT(F130/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,null,null,null,{"$f":"PRODUCT(J7,E130)","v":0}]
[null,null,null,null,0,0,{"$f":"PRODUCT(F131/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,null,null,null,{"$f":"PRODUCT(J7,E131)","v":0}]
[null,null,null,null,0,0,{"$f":"PRODUCT(F132/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,null,null,null,{"$f":"PRODUCT(J11,E132)","v":0}]
[null,null,null,null,0,0,{"$f":"PRODUCT(F133/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,null,null,null,{"$f":"PRODUCT(J11,E133)","v":0}]
[null,null,null,null,0,0,{"$f":"PRODUCT(F134/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,null,null,null,{"$f":"PRODUCT(J11,E134)","v":0}]
[null,null,null,null,0,0,{"$f":"PRODUCT(F135/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,null,null,null,{"$f":"PRODUCT(J11,E135)","v":0}]
[null,null,null,null,0,0,{"$f":"PRODUCT(F136/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,null,null,null,{"$f":"PRODUCT(J11,E136)","v":0}]
[null,null,null,null,0,0,{"$f":"PRODUCT(F137/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,null,null,null,{"$f":"PRODUCT(J11,E137)","v":0}]
[null,null,null,null,0,0,{"$f":"PRODUCT(F138/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,null,null,null,{"$f":"PRODUCT(J18,E138)","v":0}]
[null,null,null,null,0,0,{"$f":"PRODUCT(F139/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,null,null,null,{"$f":"PRODUCT(J18,E139)","v":0}]
[null,null,null,null,0,0,{"$f":"PRODUCT(F140/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,null,null,null,{"$f":"PRODUCT(J20,E140)","v":0}]
[null,null,null,null,0,0,{"$f":"PRODUCT(F141/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,null,null,null,{"$f":"PRODUCT(J18,E141)","v":0}]
[null,null,null,null,0,0,{"$f":"PRODUCT(F142/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,null,null,null,{"$f":"PRODUCT(J18,E142)","v":0}]
[null,null,null,null,0,0,{"$f":"PRODUCT(F143/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,null,null,null,{"$f":"PRODUCT(J22,E143)","v":0}]
[null,null,null,null,0,0,{"$f":"PRODUCT(F144/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,null,null,null,{"$f":"PRODUCT(J22,E144)","v":0}]
[null,null,null,null,0,0,{"$f":"PRODUCT(F145/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,null,null,null,{"$f":"PRODUCT(J22,E145)","v":0}]
[null,null,null,null,0,0,{"$f":"PRODUCT(F146/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,null,null,null,{"$f":"PRODUCT(J22,E146)","v":0}]
[null,null,null,null,0,0,{"$f":"PRODUCT(F147/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,null,null,null,{"$f":"PRODUCT(J22,E147)","v":0}]
[null,null,null,null,0,0,{"$f":"PRODUCT(F148/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,null,null,null,{"$f":"PRODUCT(J11,E148)","v":0}]
[null,null,null,null,0,0,{"$f":"PRODUCT(F149/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,null,null,null,{"$f":"PRODUCT(J11,E149)","v":0}]
[null,null,null,null,0,0,{"$f":"PRODUCT(F150/F151,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0,null,null,null,{"$f":"PRODUCT(J7,E150)","v":0}]
["TOTAL - OUNCES PLS Drill Seeding",null,null,null,{"$f":"SUM(E75:E150)","v":0},{"$f":"SUM(F75:F150)","v":0},{"$f":"SUM(G75:G150)","v":{"$error":"#DIV/0!"}},null,null,"Total Species by Bloom Period"]
[null,null,null,null,null,null,null,null,null,"Early Total",{"$f":"COUNTIF(E79:E80, \">0\")+ COUNTIF(E82, \">0\")  + COUNTIF(E89, \">0\")  +COUNTIF(E95:E97,\">0\")+COUNTIF(E108, \">0\") + COUNTIF(E122, \">0\")+COUNTIFS(E126:E150,\">0\",K126:K150,\"Early\")","v":0},{"$f":"COUNTIFS(E75:E150,\">0\",M75:M150,\"=H\")+COUNTIFS(E75:E150,\">0\",M75:M150,\"=VH\")+COUNTIFS(E75:E150,\">0\",M75:M150,\"=LH\")","v":0}]
[null,null,null,null,null,null,null,null,null,"Mid Total",{"$f":"COUNTIF(E75:E78, \">0\") + COUNTIF(E81, \">0\") + COUNTIF(E83,\">0\") + COUNTIF(E85:E86, \">0\")+ COUNTIF(E92:E94, \">0\") + COUNTIF(E100,\">0\") + COUNTIF(E105,\">0\") + COUNTIF(E107, \">0\") + COUNTIF(E109, \">0\")+ COUNTIF(E112:E113, \">0\") +COUNTIF(E115,\">0\") +COUNTIF(E118, \">0\") + COUNTIF(E120, \">0\")+COUNTIF(E124, \">0\")+COUNTIFS(E126:E150,\">0\",K126:K150,\"Mid\")","v":0},{"$f":"SUM(K152:K154)","v":0}]
[null,"TOTAL SEEDS/FT 6/",{"$f":"SUM(F59,F151)","v":0},null,"2/  Individual species not to exceed 20% of forb component by seeds/ft",null,null,null,null,"Late Total",{"$f":"COUNTIF(E84,\">0\")+COUNTIF(E87:E88,\">0\")+COUNTIF(E90:E91,\">0\")+COUNTIF(E98,\">0\")+COUNTIF(E101,\">0\")+COUNTIF(E102:E104,\">0\")+COUNTIF(E106,\">0\")+COUNTIF(E111,\">0\")+COUNTIF(E114,\">0\")+COUNTIF(E117,\">0\")+COUNTIF(E119,\">0\")+COUNTIF(E121,\">0\")+COUNTIF(E123,\">0\")+COUNTIFS(E126:E150,\">0\",K126:K150,\"Late\")","v":0}]
[]
[null,"PERCENT GRASS",{"$f":"PRODUCT(F59/C154)","v":{"$error":"#DIV/0!"}},null,"3/  75-80% forbs"]
[null,"PERCENT FORBS  3/",{"$f":"PRODUCT(F151/C154)","v":{"$error":"#DIV/0!"}},null,"4/  LH - Larval Host,  H - High Value Nectar,  VH - Very High Value Nectar"]
[null,"PERCENT MILKWEED 5/",{"$f":"SUM(F75,F98,F115,F118)/C154","v":{"$error":"#DIV/0!"}},null,"5/  Milkweeds shall comprise a minimum 1.5% of the total mixture"]
[null,null,null,null,"6/  Minimum 35-40 seeds/ft2"]
[null,"% FORBS THAT ARE MONARCH PREFERRED  8/",{"$f":"PRODUCT(L152/L153)*100","v":{"$error":"#DIV/0!"}},null,"7/ Consult appropriate NRCS Area Resource Conservationist or Biologist for prior approval"]
[null,null,null,null,"8/ A minimum 60% of the forbs must be monarch preferred (column M)."]
[]
[]
[]
[]
["Optional Trees and Shrubs",null,"Bloom Period"]
["American Plum","Prunus americana","April - May"]
["Black Willow","Salix nigra","April - May"]
["Button Bush","Cephalanthus occidentalis","June - August"]
["Common Chokecherry","Prunus virginiana","April - June"]
["Common Ninebark","Physocarpus opulifolius","May - July"]
["False Indigo*","Amorpha fruitcosa","June - August"]
["Fragrant False Indigo*","Amorpha nana","June - August"]
["New Jersey Tea","Ceanothus americanus","June - August"]
["Pussy Willow","Salix discolor","April - May"]
["Red Osier Dogwood","Cornus sericea","May - August"]
["Saskatoon Serviceberry","Amelanchier alnifolia","April - May"]
["Silky Dogwood","Cornus amomum","May - July"]
["Wild Rose","Rosea spp.","June -August"]

{"sheet":"327 CREP CP2 & CP23 Buffer","index":5,"n_rows":169,"n_cols":15,"rows_kept":169,"cut":false,"hidden":false,"merged":[[9,9,9,10],[143,0,143,2],[32,0,32,2],[69,0,71,0],[69,6,71,6],[13,2,14,2],[13,6,14,6],[13,7,14,7],[15,0,15,2],[9,0,9,2],[10,0,12,0],[10,6,12,6],[4,1,4,2],[6,1,6,2],[6,7,6,8],[0,0,0,14],[1,0,1,14],[69,14,71,14],[150,0,150,14],[155,5,155,8],[161,5,162,12],[10,13,12,13],[13,8,14,13],[32,4,32,13],[57,0,57,13],[68,9,68,10],[69,13,72,13]]}
["CREP 327 CONSERVATION COVER - NATIVE GRASS/FORBS"]
["Seeding Design"]
[null,null,null,null,null,null,null,null,"DATE",{"$f":"TODAY()","v":"2022-06-16"}]
[]
["LANDOWNER",null,null,null,null,null,null,null,"TRACT/FIELD"]
[]
["PLANNER",null,null,null,null,null,null,"ACRES SEEDED"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Background Information"]
["GRASS SPECIES",null,"PLANNED %",null,"POUNDS","TOTAL SEEDS/","% OF GRASS MIX BY SEEDS/FT 1/",null,null,null,"SEEDS/","COC","COC","Pounds PLS"]
[null,null,"OF GRASS COMPONENT BY",null,"PLS/AC.","SQ. FOOT",null,null,null,null,"SQ. FOOT","Selected","Reference"]
[null,null,"SEEDS/SQ. FOOT",null,null,null,null,null,null,null,"At 1 lb. Rate",null,"6/"]
[null,null,"Planned",null,null,null,"Can't Exceed","Planned %"]
[]
["WARM SEASON 7/"]
["Big Bluestem","Andropogon gerardii","0 to 30",null,0,{"$f":"PRODUCT(K17,E17)","v":0},{"$f":"PRODUCT(F17/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(31>G17),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},null,176000,{"$f":"PRODUCT(J17/43560)","v":4.0404040404040407},{"$f":"IF(E17=0,\"\",M17)","v":""},4,{"$f":"PRODUCT(J7*E17)","v":0}]
["Blue Grama","Bouteloua gracilis","0 to 20",null,0,0,{"$f":"PRODUCT(F18/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(21>G18),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},null,750000,17.217630853994489,"",8,{"$f":"PRODUCT(J7*E18)","v":0}]
["Indiangrass","Sorgastrum nutans","0 to 30",null,0,0,{"$f":"PRODUCT(F19/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(31>G19),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},null,193000,4.4306703397612486,"",4,{"$f":"PRODUCT(J7*E19)","v":0}]
["Little Bluestem","Schizachryrium scoparium","0 to 30",null,0,0,{"$f":"PRODUCT(F20/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(31>G20),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},null,286000,6.5656565656565657,"",5,{"$f":"PRODUCT(J7*E20)","v":0}]
["Prairie Cordgrass","Spartina pectinata","0 to 5",null,0,0,{"$f":"PRODUCT(F21/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(6>G21),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},null,183000,4.2011019283746558,"",4,{"$f":"PRODUCT(J7*E21)","v":0}]
["Prairie Dropseed","Sporopolus heterolepis","0 to 10",null,0,0,{"$f":"PRODUCT(F22/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(11>G22),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},null,224000,5.1423324150596876,"",9,{"$f":"PRODUCT(J7*E22)","v":0}]
["Prairie Sandreed","Calamovilfa longifolia","0 to 30",null,0,0,{"$f":"PRODUCT(F23/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(31>G23),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},null,275000,6.3131313131313131,"",7,{"$f":"PRODUCT(J7*E23)","v":0}]
["Rough Dropseed","Sporobolus compositus","0 to 10",null,0,0,{"$f":"PRODUCT(F24/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(11>G24),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},null,480000,11.019283746556473,"",9,{"$f":"PRODUCT(J7*E24)","v":0}]
["Sideoats Grama","Bouteloua curtipendula","0 to 30",null,0,0,{"$f":"PRODUCT(F25/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(31>G25),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},null,180000,4.1322314049586772,"",6,{"$f":"PRODUCT(J7*E25)","v":0}]
["Switchgrass","Panicum virgatum","0 to 10",null,0,0,{"$f":"PRODUCT(F26/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(11>G26),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},null,390000,8.9531680440771346,"",5,{"$f":"PRODUCT(J7*E26)","v":0}]
[null,null,"0 to 10",null,0,0,{"$f":"PRODUCT(F27/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,0,"",null,{"$f":"PRODUCT(J7*E27)","v":0}]
[null,null,"0 to 10",null,0,0,{"$f":"PRODUCT(F28/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,0,"",null,{"$f":"PRODUCT(J7*E28)","v":0}]
[null,null,"0 to 10",null,0,0,{"$f":"PRODUCT(F29/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,0,"",null,{"$f":"PRODUCT(J7*E29)","v":0}]
[null,null,"0 to 10",null,0,0,{"$f":"PRODUCT(F30/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,0,"",null,{"$f":"PRODUCT(J7*E30)","v":0}]
[null,null,"0 to 10",null,0,{"$f":"PRODUCT(K31,E31)","v":0},{"$f":"PRODUCT(F31/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,{"$f":"PRODUCT(J31/43560)","v":0},{"$f":"IF(E31=0,\"\",M31)","v":""},null,{"$f":"PRODUCT(J7*E31)","v":0}]
[null,null,"0 to 10",null,0,{"$f":"PRODUCT(K32,E32)","v":0},{"$f":"PRODUCT(F32/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,{"$f":"PRODUCT(J32/43560)","v":0},{"$f":"IF(E32=0,\"\",M32)","v":""},null,{"$f":"PRODUCT(J7*E32)","v":0}]
["COOL SEASON 2/  7/",null,null,null,"  "]
["Canada Bluejoint","Calamagrostis canadensis","0 to 5",null,0,{"$f":"PRODUCT(K34,E34)","v":0},{"$f":"PRODUCT(F34/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(6>G34),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},null,4480000,{"$f":"PRODUCT(J34/43560)","v":102.84664830119375},{"$f":"IF(E34=0,\"\",M34)","v":""},5,{"$f":"PRODUCT(J7*E34)","v":0}]
["Canada Wildrye","Elymus canadensis","0 to 10",null,0,0,{"$f":"PRODUCT(F35/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(11>G35),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},null,115000,{"$f":"PRODUCT(J35/43560)","v":2.6400367309458219},{"$f":"IF(E35=0,\"\",M35)","v":""},5,{"$f":"PRODUCT(J7*E35)","v":0}]
["Green Needlegrass","Stipa viridula","0 to 10",null,0,0,{"$f":"PRODUCT(F36/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(11>G36),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},null,180000,4.1322314049586772,"",5,{"$f":"PRODUCT(J7*E36)","v":0}]
["June grass","Koleria macrantha","0 to 5",null,0,0,{"$f":"PRODUCT(F37/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(6>G37),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},null,2315000,{"$f":"PRODUCT(J37/43560)","v":53.145087235996328},{"$f":"IF(E37=0,\"\",M37)","v":""},7,{"$f":"PRODUCT(J7*E37)","v":0}]
["Kalms Brome","Bromus kalmii","0 to 10",null,0,0,{"$f":"PRODUCT(F38/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(11>G38),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},null,128000,{"$f":"PRODUCT(J38/43560)","v":2.9384756657483928},{"$f":"IF(E38=0,\"\",M38)","v":""},5,{"$f":"PRODUCT(J7*E38)","v":0}]
["Porcupine grass ","Hesperostipa spartea","0 to 10",null,0,0,{"$f":"PRODUCT(F39/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,57000,1.3085399449035813,"",6,{"$f":"PRODUCT(J7*E39)","v":0}]
["Slender Wheatgrass","Agropyron caninum","0 to 10",null,0,0,{"$f":"PRODUCT(F40/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,155000,{"$f":"PRODUCT(J40/43560)","v":3.5583103764921948},{"$f":"IF(E40=0,\"\",M40)","v":""},5,{"$f":"PRODUCT(J7*E40)","v":0}]
["Virginia Wildrye","Elymus virginicus","0 to 10",null,0,0,{"$f":"PRODUCT(F41/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,96000,{"$f":"PRODUCT(J41/43560)","v":2.2038567493112948},{"$f":"IF(E41=0,\"\",M41)","v":""},3,{"$f":"PRODUCT(J7*E41)","v":0}]
["Western Wheatgrass","Agropyron smithii","0 to 10",null,0,0,{"$f":"PRODUCT(F42/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,112000,2.5711662075298438,"",2,{"$f":"PRODUCT(J7*E42)","v":0}]
[null,null,"0 to 10",null,0,0,{"$f":"PRODUCT(F43/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,0,"",null,{"$f":"PRODUCT(J7*E43)","v":0}]
[null,null,"0 to 10",null,0,0,{"$f":"PRODUCT(F44/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,0,"",null,{"$f":"PRODUCT(J7*E44)","v":0}]
[null,null,"0 to 10",null,0,0,{"$f":"PRODUCT(F45/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,0,"",null,{"$f":"PRODUCT(J7*E45)","v":0}]
[null,null,"0 to 10",null,0,0,{"$f":"PRODUCT(F46/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,0,"",null,{"$f":"PRODUCT(J7*E46)","v":0}]
[null,null,"0 to 10",null,0,{"$f":"PRODUCT(K47,E47)","v":0},{"$f":"PRODUCT(F47/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(11>G47),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},null,null,{"$f":"PRODUCT(J47/43560)","v":0},{"$f":"IF(E47=0,\"\",M47)","v":""},null,{"$f":"PRODUCT(J7*E47)","v":0}]
[null,null,"0 to 10",null,0,{"$f":"PRODUCT(K48,E48)","v":0},{"$f":"PRODUCT(F48/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(11>G48),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},null,null,{"$f":"PRODUCT(J48/43560)","v":0},{"$f":"IF(E48=0,\"\",M48)","v":""},null,{"$f":"PRODUCT(J7*E48)","v":0}]
[null,null,"0 to 10",null,0,0,{"$f":"PRODUCT(F49/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,0,"",null,{"$f":"PRODUCT(J7*E49)","v":0}]
[null,null,"0 to 10",null,0,0,{"$f":"PRODUCT(F50/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,0,"",null,{"$f":"PRODUCT(J7*E50)","v":0}]
[null,null,"0 to 10",null,0,0,{"$f":"PRODUCT(F51/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,0,"",null,{"$f":"PRODUCT(J7*E51)","v":0}]
[null,null,"0 to 10",null,0,0,{"$f":"PRODUCT(F52/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,0,"",null,{"$f":"PRODUCT(J7*E52)","v":0}]
[null,null,"0 to 10",null,0,0,{"$f":"PRODUCT(F53/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,0,"",null,{"$f":"PRODUCT(J7*E53)","v":0}]
[null,null,"0 to 10",null,0,{"$f":"PRODUCT(K54,E54)","v":0},{"$f":"PRODUCT(F54/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(11>G54),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},null,null,{"$f":"PRODUCT(J54/43560)","v":0},{"$f":"IF(E54=0,\"\",M54)","v":""},null,{"$f":"PRODUCT(J7*E54)","v":0}]
[null,null,"0 to 10",null,0,0,{"$f":"PRODUCT(F55/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,0,"",null,{"$f":"PRODUCT(J7*E55)","v":0}]
[null,null,"0 to 10",null,0,0,{"$f":"PRODUCT(F56/F59,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,0,"",null,{"$f":"PRODUCT(J7*E56)","v":0}]
[null,null,"0 to 10",null,0,{"$f":"PRODUCT(K57,E57)","v":0},{"$f":"PRODUCT(F57/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(11>G57),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},null,null,{"$f":"PRODUCT(J57/43560)","v":0},{"$f":"IF(E57=0,\"\",M57)","v":""},null,{"$f":"PRODUCT(J7*E57)","v":0}]
[]
[null,null,"TOTAL Pounds PLS ",null,{"$f":"SUM(E17:E57)","v":0},{"$f":"SUM(F17:F57)","v":0},{"$f":"SUM(G17:G57)","v":{"$error":"#DIV/0!"}},null,null,null,"AVE COC GRASS",{"$f":"AVERAGE(L17:L57)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,{"$f":"SUM(G34:G57)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,{"$f":"IF(AND(20.1>G60,G60<100),\"\",\"COOL SEASON GRASSES EXCEED 20% OF THE MIX BASED ON SEEDS/FT\")","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
["1/  ACTUAL SEEDS PER SQUARE FOOT SHALL BE WITHIN THE RANGE SPECIFIED IN PLANNED CONDITION"]
["2/  NO MORE THAN 20% OF THE MIXTURE SHALL BE COMPRISED OF COOL SEASON GRASSES BASED ON SEEDS PER SQUARE FOOT."]
[null,null,null,null,null,null,null,null,null,"Background Information"]
["FORB SPECIES",null,null,null,"OUNCES","TOTAL SEEDS/","% OF FORB MIX BY SEEDS/FT 3/",null,"% of mix","SEEDS/oz","SEEDS/","COC","COC","Pollinator Monarch Preferred Blue","Ounces PLS"]
[null,null,null,null,"PLS/AC.","SQ. FOOT",null,null,"by WEIGHT",null,"SQ. FOOT","Selected","Reference"]
[null,null,null,null,null,null,null,null,null,null,"At 1 oz/ac Rate"]
[]
["DRY"]
["Bush Clover","Lespedeza capitata",null,null,0,{"$f":"PRODUCT(K75,E75)","v":0},{"$f":"PRODUCT(F75/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(51>G75),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(E75/E152)*100","v":{"$error":"#DIV/0!"}},8000,{"$f":"PRODUCT(J75/43560)","v":0.18365472910927455},{"$f":"IF(E75=0,\"\",M75)","v":""},3,"Late",{"$f":"PRODUCT(J7*E75)","v":0}]
["Culvers Root","Veronicastrum virginicum",null,null,0,{"$f":"PRODUCT(K76,E76)","v":0},{"$f":"PRODUCT(F76/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E76/E152)*100","v":{"$error":"#DIV/0!"}},800000,18.365472910927455,"",5,"Mid",{"$f":"PRODUCT(J7*E76)","v":0}]
["Dotted Blazingstar","Liatris punctata",null,null,0,0,{"$f":"PRODUCT(F77/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E77/E152)*100","v":{"$error":"#DIV/0!"}},7000,0.16069788797061524,"",8,"Mid",{"$f":"PRODUCT(J7*E77)","v":0}]
["Purple Coneflower, Narrow Leaved","Echinacea pallida var. angustifolia",null,null,0,0,{"$f":"PRODUCT(F78/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E78/E152)*100","v":{"$error":"#DIV/0!"}},7000,0.16069788797061524,"",8,"Mid",{"$f":"PRODUCT(J7*E78)","v":0}]
["Prairie Cinquefoil","Potentilla arguta",null,null,0,0,{"$f":"PRODUCT(F79/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E79/E152)*100","v":{"$error":"#DIV/0!"}},230000,5.2800734618916438,"",8,"Late",{"$f":"PRODUCT(J7*E79)","v":0}]
["Showy Penstemon","Penstemon grandifloris",null,null,0,0,{"$f":"PRODUCT(F80/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E80/E152)*100","v":{"$error":"#DIV/0!"}},14000,0.32139577594123048,"",5,"Early",{"$f":"PRODUCT(J7*E80)","v":0}]
["Stiff Sunflower","Helianthus paucifloris",null,null,0,{"$f":"PRODUCT(K81,E81)","v":0},{"$f":"PRODUCT(F81/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E81/E152)*100","v":{"$error":"#DIV/0!"}},4000,{"$f":"PRODUCT(J81/43560)","v":9.1827364554637275E-2},"",5,"Mid",{"$f":"PRODUCT(J7*E81)","v":0}]
["Silky Aster","Symphyotrichum sericeum",null,null,0,0,{"$f":"PRODUCT(F82/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E82/E152)*100","v":{"$error":"#DIV/0!"}},26000,0.59687786960514233,"",10,"Late",{"$f":"PRODUCT(J7*E82)","v":0}]
["DRY to MESIC",null,null,null,"  "]
["Butterfly Weed","Asclepias tuberosa",null,null,0,{"$f":"PRODUCT(K84,E84)","v":0},{"$f":"PRODUCT(F84/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(51>G84),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(E84/E152)*100","v":{"$error":"#DIV/0!"}},4300,{"$f":"PRODUCT(J84/43560)","v":9.8714416896235072E-2},{"$f":"IF(E84=0,\"\",M84)","v":""},6,"Mid",{"$f":"PRODUCT(J7*E84)","v":0}]
["Canada Milkvetch","Astragalus canadensis","Legume",null,0,{"$f":"PRODUCT(K85,E85)","v":0},{"$f":"PRODUCT(F85/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(51>G85),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(E85/E152)*100","v":{"$error":"#DIV/0!"}},17000,{"$f":"PRODUCT(J85/43560)","v":0.39026629935720847},{"$f":"IF(E85=0,\"\",M85)","v":""},4,"Mid",{"$f":"PRODUCT(J7*E85)","v":0}]
["Compass Plant ","Silphium laciniatum",null,null,0,0,{"$f":"PRODUCT(F86/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E86/E152)*100","v":{"$error":"#DIV/0!"}},660,1.5151515151515152E-2,"",7,"Mid",{"$f":"PRODUCT(J7*E86)","v":0}]
["Evening Primrose","Oenothera biennis",null,null,0,0,{"$f":"PRODUCT(F87/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E87/E152)*100","v":{"$error":"#DIV/0!"}},90000,2.0661157024793386,"",4,"Mid",{"$f":"PRODUCT(J7*E87)","v":0}]
["Foxglove Beardtongue","Penstemon digitalis",null,null,0,{"$f":"PRODUCT(K88,E88)","v":0},{"$f":"PRODUCT(F88/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(51>G88),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(E88/E152)*100","v":{"$error":"#DIV/0!"}},130000,{"$f":"PRODUCT(J88/43560)","v":2.9843893480257115},{"$f":"IF(E88=0,\"\",M88)","v":""},4,"Early",{"$f":"PRODUCT(J7*E88)","v":0}]
["Heart-leaved Alexander","Zizia aptera",null,null,0,0,{"$f":"PRODUCT(F89/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E89/E152)*100","v":{"$error":"#DIV/0!"}},12000,0.27548209366391185,null,8,"Early",{"$f":"PRODUCT(J7*E89)","v":0}]
["Heath Aster","Symphyotrichum ericoides",null,null,0,{"$f":"PRODUCT(K90,E90)","v":0},{"$f":"PRODUCT(F90/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E90/E152)*100","v":{"$error":"#DIV/0!"}},200000,{"$f":"PRODUCT(J90/43560)","v":4.5913682277318637},null,3,"Late",{"$f":"PRODUCT(J7*E90)","v":0}]
["Hoary Vervain","Verbena stricta",null,null,0,0,{"$f":"PRODUCT(F91/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E91/E152)*100","v":{"$error":"#DIV/0!"}},28000,0.64279155188246095,"",1,"Mid",{"$f":"PRODUCT(J7*E91)","v":0}]
["Lance-leaved Coreopsis","Coreopsis lanceolata",null,null,0,{"$f":"PRODUCT(K92,E92)","v":0},{"$f":"PRODUCT(F92/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(51>G92),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(E92/E152)*100","v":{"$error":"#DIV/0!"}},20000,{"$f":"PRODUCT(J92/43560)","v":0.4591368227731864},{"$f":"IF(E92=0,\"\",M92)","v":""},1,"Early",{"$f":"PRODUCT(J7*E92)","v":0}]
["Leadplant","Amorpha canescens","Legume",null,0,0,{"$f":"PRODUCT(F93/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E93/E152)*100","v":{"$error":"#DIV/0!"}},16000,0.3673094582185491,"",5,"Mid",{"$f":"PRODUCT(J7*E93)","v":0}]
["Long -headed Coneflower","Ratibida columnifera",null,null,0,0,{"$f":"PRODUCT(F94/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E94/E152)*100","v":{"$error":"#DIV/0!"}},42000,0.96418732782369143,"",5,"Mid",{"$f":"PRODUCT(J7*E94)","v":0}]
["Ontario Blazingstar","Liatris cylindracea",null,null,0,{"$f":"PRODUCT(K95,E95)","v":0},{"$f":"PRODUCT(F95/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E95/E152)*100","v":{"$error":"#DIV/0!"}},14000,{"$f":"PRODUCT(J95/43560)","v":0.32139577594123048},{"$f":"IF(E95=0,\"\",M95)","v":""},8,"Late",{"$f":"PRODUCT(J7*E95)","v":0}]
["Prairie Smoke","Geum triflorum",null,null,0,0,{"$f":"PRODUCT(F96/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E96/E152)*100","v":{"$error":"#DIV/0!"}},27000,0.6198347107438017,"",8,"Early",{"$f":"PRODUCT(J7*E96)","v":0}]
["Rough Blazingstar","Liatris aspera",null,null,0,0,{"$f":"PRODUCT(F97/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E97/E152)*100","v":{"$error":"#DIV/0!"}},16000,0.3673094582185491,"",8,"Late",{"$f":"PRODUCT(J7*E97)","v":0}]
["Showy Goldenrod","Solidago speciosa",null,null,0,0,{"$f":"PRODUCT(F98/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E98/E152)*100","v":{"$error":"#DIV/0!"}},95000,2.1808999081726355,"",7,"Late",{"$f":"PRODUCT(J7*E98)","v":0}]
["Smooth Aster","Symphyotrichum laeva",null,null,0,0,{"$f":"PRODUCT(F99/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E99/E152)*100","v":{"$error":"#DIV/0!"}},55000,1.2626262626262625,"",7,"Late",{"$f":"PRODUCT(J7*E99)","v":0}]
["Spotted Beebalm","Monarda punctata",null,null,0,{"$f":"PRODUCT(K100,E100)","v":0},{"$f":"PRODUCT(F100/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(51>G100),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(E100/E152)*100","v":{"$error":"#DIV/0!"}},70000,{"$f":"PRODUCT(J100/43560)","v":1.6069788797061524},{"$f":"IF(E100=0,\"\",M100)","v":""},6,"Mid",{"$f":"PRODUCT(J7*E100)","v":0}]
["Stiff Tickseed","Coreopsis  palmata",null,null,0,0,{"$f":"PRODUCT(F101/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E101/E152)*100","v":{"$error":"#DIV/0!"}},10000,0.2295684113865932,"",7,"Mid",{"$f":"PRODUCT(J7*E101)","v":0}]
["Thimbleweed","Anemone cylindrica",null,null,0,0,{"$f":"PRODUCT(F102/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E102/E152)*100","v":{"$error":"#DIV/0!"}},26000,0.59687786960514233,"",7,"Mid",{"$f":"PRODUCT(J7*E102)","v":0}]
["Whorled Milkweed","Asclepias verticillata",null,null,0,{"$f":"PRODUCT(K103,E103)","v":0},{"$f":"PRODUCT(F103/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(51>G103),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(E103/E152)*100","v":{"$error":"#DIV/0!"}},11000,{"$f":"PRODUCT(J103/43560)","v":0.25252525252525254},{"$f":"IF(E103=0,\"\",M103)","v":""},4,"Mid-Late",{"$f":"PRODUCT(J7*E103)","v":0}]
["Wild Blue Phlox","Phlox divaricata",null,null,0,{"$f":"PRODUCT(K104,E104)","v":0},{"$f":"PRODUCT(F104/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(51>G104),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(E104/E152)*100","v":{"$error":"#DIV/0!"}},12500,{"$f":"PRODUCT(J104/43560)","v":0.28696051423324148},{"$f":"IF(E104=0,\"\",M104)","v":""},7,"Early",{"$f":"PRODUCT(J7*E104)","v":0}]
["Wild Columbine","Aquilegia canadensis",null,null,0,{"$f":"PRODUCT(K105,E105)","v":0},{"$f":"PRODUCT(F105/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(51>G105),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(E105/E152)*100","v":{"$error":"#DIV/0!"}},3800,{"$f":"PRODUCT(J105/43560)","v":8.7235996326905416E-2},{"$f":"IF(E105=0,\"\",M105)","v":""},6,"Early",{"$f":"PRODUCT(J7*E105)","v":0}]
["MESIC to WET",null,null,null,"  "]
["Blanketflower","Gaillardia aristata",null,null,0,{"$f":"PRODUCT(K107,E107)","v":0},{"$f":"PRODUCT(F107/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(51>G107),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(E107/E152)*100","v":{"$error":"#DIV/0!"}},9813,{"$f":"PRODUCT(J107/43560)","v":0.22527548209366391},{"$f":"IF(E107=0,\"\",M107)","v":""},2,"Mid",{"$f":"PRODUCT(J7*E107)","v":0}]
["Canada Tick Trefoil","Desmodium canadense","Legume",null,0,0,{"$f":"PRODUCT(F108/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E108/E152)*100","v":{"$error":"#DIV/0!"}},5500,0.12626262626262627,"",6,"Mid",{"$f":"PRODUCT(J7*E108)","v":0}]
["Common Ox-eye","Heliopsis helianthoides",null,null,0,0,{"$f":"PRODUCT(F109/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E109/E152)*100","v":{"$error":"#DIV/0!"}},6300,0.14462809917355371,"",4,"Mid",{"$f":"PRODUCT(J7*E109)","v":0}]
["Giant Sunflower","Helianthus giganteus",null,null,0,0,{"$f":"PRODUCT(F110/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E110/E152)*100","v":{"$error":"#DIV/0!"}},10000,0.2295684113865932,"",5,"Late",{"$f":"PRODUCT(J7*E110)","v":0}]
["Golden Alexanders","Zizia aurea",null,null,0,0,{"$f":"PRODUCT(F111/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E111/E152)*100","v":{"$error":"#DIV/0!"}},11000,0.25252525252525254,"",6,"Early",{"$f":"PRODUCT(J7*E111)","v":0}]
["Great Blue Lobelia","Lobelia siphilitica",null,null,0,{"$f":"PRODUCT(K112,E112)","v":0},{"$f":"PRODUCT(F112/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(51>G112),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(E112/E152)*100","v":{"$error":"#DIV/0!"}},500000,{"$f":"PRODUCT(J112/43560)","v":11.478420569329661},{"$f":"IF(E112=0,\"\",M112)","v":""},3,"Late",{"$f":"PRODUCT(J7*E112)","v":0}]
["Ironweed","Veronia fasticulata",null,null,0,0,{"$f":"PRODUCT(F113/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E113/E152)*100","v":{"$error":"#DIV/0!"}},24000,0.55096418732782371,"",3,"Late",{"$f":"PRODUCT(J7*E113)","v":0}]
["Meadow Blazingstar","Liatris ligulistylis",null,null,0,{"$f":"PRODUCT(K114,E114)","v":0},{"$f":"PRODUCT(F114/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E114/E152)*100","v":{"$error":"#DIV/0!"}},11000,0.25252525252525254,"",8,"Late",{"$f":"PRODUCT(J7*E114)","v":0}]
["Mountain Mint","Pycnanthemum virginianum",null,null,0,{"$f":"PRODUCT(K115,E115)","v":0},{"$f":"PRODUCT(F115/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E115/E152)*100","v":{"$error":"#DIV/0!"}},220000,{"$f":"PRODUCT(J115/43560)","v":5.0505050505050502},{"$f":"IF(E115=0,\"\",M115)","v":""},8,"Mid",{"$f":"PRODUCT(J7*E115)","v":0}]
["Partridge Pea","Cassia fasticulata","Legume",null,0,{"$f":"PRODUCT(K116,E116)","v":0},{"$f":"PRODUCT(F116/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E116/E152)*100","v":{"$error":"#DIV/0!"}},2700,{"$f":"PRODUCT(J116/43560)","v":6.1983471074380167E-2},{"$f":"IF(E116=0,\"\",M116)","v":""},4,"Mid",{"$f":"PRODUCT(J7*E116)","v":0}]
["Rattlesnake Master","Eryngium yuccifolium",null,null,0,0,{"$f":"PRODUCT(F117/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E117/E152)*100","v":{"$error":"#DIV/0!"}},7500,0.17217630853994489,"",8,"Mid",{"$f":"PRODUCT(J7*E117)","v":0}]
["Sawtooth Sunflower","Helianthus grosseserratus",null,null,0,{"$f":"PRODUCT(K118,E118)","v":0},{"$f":"PRODUCT(F118/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(51>G118),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(E118/E152)*100","v":{"$error":"#DIV/0!"}},10000,{"$f":"PRODUCT(J118/43560)","v":0.2295684113865932},{"$f":"IF(E118=0,\"\",M118)","v":""},8,"Late",{"$f":"PRODUCT(J7*E118)","v":0}]
["Tall Blazingstar","Liatris pycnostachya",null,null,0,0,{"$f":"PRODUCT(F119/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E119/E152)*100","v":{"$error":"#DIV/0!"}},11000,0.25252525252525254,"",6,"Mid",{"$f":"PRODUCT(J7*E119)","v":0}]
["Virginia Bluebells","Mertenias virginica",null,null,0,{"$f":"PRODUCT(K120,E120)","v":0},{"$f":"PRODUCT(F120/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(51>G120),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(E120/E152)*100","v":{"$error":"#DIV/0!"}},9700,{"$f":"PRODUCT(J120/43560)","v":0.22268135904499542},{"$f":"IF(E120=0,\"\",M120)","v":""},6,"Early",{"$f":"PRODUCT(J7*E120)","v":0}]
["Wild Bergamot","Monarda fistulosa",null,null,0,0,{"$f":"PRODUCT(F121/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E121/E152)*100","v":{"$error":"#DIV/0!"}},70000,1.6069788797061524,"",2,"Mid",{"$f":"PRODUCT(J7*E121)","v":0}]
["Yellow Coneflower","Ratibida pinnata",null,null,0,0,{"$f":"PRODUCT(F122/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E122/E152)*100","v":{"$error":"#DIV/0!"}},30000,0.68870523415977958,"",4,"Mid",{"$f":"PRODUCT(J7*E122)","v":0}]
["WET",null,null,null,"  "]
["Blue Vervain","Verbena hastata",null,null,0,{"$f":"PRODUCT(K124,E124)","v":0},{"$f":"PRODUCT(F124/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(51>G124),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(E124/E152)*100","v":{"$error":"#DIV/0!"}},93000,{"$f":"PRODUCT(J124/43560)","v":2.1349862258953167},{"$f":"IF(E124=0,\"\",M124)","v":""},3,"Mid",{"$f":"PRODUCT(J7*E124)","v":0}]
["Boneset","Eupatorium perfoliatum",null,null,0,0,{"$f":"PRODUCT(F125/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E125/E152)*100","v":{"$error":"#DIV/0!"}},160000,3.6730945821854912,"",6,"Late",{"$f":"PRODUCT(J7*E125)","v":0}]
["Cup Plant","Silphium perfoliatum",null,null,0,{"$f":"PRODUCT(K126,E126)","v":0},{"$f":"PRODUCT(F126/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E126/E152)*100","v":{"$error":"#DIV/0!"}},1400,3.2139577594123052E-2,{"$f":"IF(E126=0,\"\",M126)","v":""},1,"Mid",{"$f":"PRODUCT(J7*E126)","v":0}]
["Joe-pye Weed","Eutrochium maculatum",null,null,0,0,{"$f":"PRODUCT(F127/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E127/E152)*100","v":{"$error":"#DIV/0!"}},95000,2.1808999081726355,"",5,"Mid",{"$f":"PRODUCT(J7*E127)","v":0}]
["New England Aster","Symphyotrichum novae-angliae",null,null,0,0,{"$f":"PRODUCT(F128/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E128/E152)*100","v":{"$error":"#DIV/0!"}},66000,1.5151515151515151,"",3,"Late",{"$f":"PRODUCT(J7*E128)","v":0}]
["Panicled Aster","Symphyotrichum lanceolatum",null,null,0,0,{"$f":"PRODUCT(F129/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E129/E152)*100","v":{"$error":"#DIV/0!"}},156000,3.5812672176308542,"",4,"Late",{"$f":"PRODUCT(J7*E129)","v":0}]
["Sneezeweed","Helenium autumnale",null,null,0,{"$f":"PRODUCT(K130,E130)","v":0},{"$f":"PRODUCT(F130/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E130/E152)*100","v":{"$error":"#DIV/0!"}},130000,{"$f":"PRODUCT(J130/43560)","v":2.9843893480257115},"",4,"Late",{"$f":"PRODUCT(J7*E130)","v":0}]
["Swamp Milkweed  ","Asclepias incarnata",null,null,0,0,{"$f":"PRODUCT(F131/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E131/E152)*100","v":{"$error":"#DIV/0!"}},4800,0.11019283746556474,"",4,"Mid",{"$f":"PRODUCT(J7*E131)","v":0}]
["DRY to WET",null,null,null,"  "]
["Anise Hyssop","Agastache foeniculum",null,null,0,{"$f":"PRODUCT(K133,E133)","v":0},{"$f":"PRODUCT(F133/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(51>G133),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(E133/E152)*100","v":{"$error":"#DIV/0!"}},91000,{"$f":"PRODUCT(J133/43560)","v":2.089072543617998},{"$f":"IF(E133=0,\"\",M133)","v":""},4,"Mid",{"$f":"PRODUCT(J7*E133)","v":0}]
["Black-eyed Susan","Rudbeckia hirta",null,null,0,{"$f":"PRODUCT(K134,E134)","v":0},{"$f":"PRODUCT(F134/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(51>G134),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(E134/E152)*100","v":{"$error":"#DIV/0!"}},92000,{"$f":"PRODUCT(J134/43560)","v":2.1120293847566574},{"$f":"IF(E134=0,\"\",M134)","v":""},2,"Late",{"$f":"PRODUCT(J7*E134)","v":0}]
["Common Milkweed","Asclepias syriaca",null,null,0,{"$f":"PRODUCT(K135,E135)","v":0},{"$f":"PRODUCT(F135/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E135/E152)*100","v":{"$error":"#DIV/0!"}},4000,{"$f":"PRODUCT(J135/43560)","v":9.1827364554637275E-2},{"$f":"IF(E135=0,\"\",M135)","v":""},1,"Mid",{"$f":"PRODUCT(J7*E135)","v":0}]
["Grassleaved Goldenrod","Euthamia  graminifolia",null,null,0,{"$f":"PRODUCT(K136,E136)","v":0},{"$f":"PRODUCT(F136/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E136/E152)*100","v":{"$error":"#DIV/0!"}},350000,{"$f":"PRODUCT(J136/43560)","v":8.0348943985307617},{"$f":"IF(E136=0,\"\",M136)","v":""},4,"Mid",{"$f":"PRODUCT(J7*E136)","v":0}]
["Illinois Bundleflower","Desmanthus illinoensis",null,null,0,0,{"$f":"PRODUCT(F137/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E137/E152)*100","v":{"$error":"#DIV/0!"}},4200,9.6418732782369149E-2,"",4,"Mid",{"$f":"PRODUCT(J7*E137)","v":0}]
["Purple Prairie Clover","Petalostemum purpurum","Legume",null,0,0,{"$f":"PRODUCT(F138/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E138/E152)*100","v":{"$error":"#DIV/0!"}},18000,0.41322314049586778,"",8,"Mid",{"$f":"PRODUCT(J7*E138)","v":0}]
["Maximillian Sunflower","Helianthus maximiliani",null,null,0,0,{"$f":"PRODUCT(F139/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E139/E152)*100","v":{"$error":"#DIV/0!"}},13000,0.29843893480257117,"",4,"Late",{"$f":"PRODUCT(J7*E139)","v":0}]
["Stiff Goldenrod","Solidago rigida",null,null,0,0,{"$f":"PRODUCT(F140/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E140/E152)*100","v":{"$error":"#DIV/0!"}},41000,0.94123048668503217,"",4,"Late",{"$f":"PRODUCT(J7*E140)","v":0}]
["White Prairie Clover","Petalostemum candidum","Legume",null,0,0,{"$f":"PRODUCT(F141/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E141/E152)*100","v":{"$error":"#DIV/0!"}},19000,0.43617998163452709,"",10,"Mid",{"$f":"PRODUCT(J7*E141)","v":0}]
["Yarrow","Achillea millefolium",null,null,0,{"$f":"PRODUCT(K142,E142)","v":0},{"$f":"PRODUCT(F142/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(51>G142),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(E142/E152)*100","v":{"$error":"#DIV/0!"}},180000,{"$f":"PRODUCT(J142/43560)","v":4.1322314049586772},{"$f":"IF(E142=0,\"\",M142)","v":""},1,"Mid",{"$f":"PRODUCT(J7*E142)","v":0}]
["Yellow Giant Hyssop","Agastache nepetoides ",null,null,0,{"$f":"PRODUCT(K143,E143)","v":0},{"$f":"PRODUCT(F143/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(51>G143),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(E143/E152)*100","v":{"$error":"#DIV/0!"}},91000,{"$f":"PRODUCT(J143/43560)","v":2.089072543617998},{"$f":"IF(E143=0,\"\",M143)","v":""},4,"Late",{"$f":"PRODUCT(J7*E143)","v":0}]
["ADDITIONAL APPROVED FORBS 7/",null,null,null,"  "]
[null,null,null,null,0,{"$f":"PRODUCT(K145,E145)","v":0},{"$f":"PRODUCT(F145/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(51>G145),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(E145/E152)*100","v":{"$error":"#DIV/0!"}},null,{"$f":"PRODUCT(J145/43560)","v":0},{"$f":"IF(E145=0,\"\",M145)","v":""},null,null,{"$f":"PRODUCT(J7*E145)","v":0}]
[null,null,null,null,0,0,{"$f":"PRODUCT(F146/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E146/E152)*100","v":{"$error":"#DIV/0!"}},null,0,"",null,null,{"$f":"PRODUCT(J7*E146)","v":0}]
[null,null,null,null,0,0,{"$f":"PRODUCT(F147/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E147/E152)*100","v":{"$error":"#DIV/0!"}},null,0,"",null,null,{"$f":"PRODUCT(J7*E147)","v":0}]
[null,null,null,null,0,0,{"$f":"PRODUCT(F148/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E148/E152)*100","v":{"$error":"#DIV/0!"}},null,0,"",null,null,{"$f":"PRODUCT(J7*E148)","v":0}]
[null,null,null,null,0,0,{"$f":"PRODUCT(F149/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E149/E152)*100","v":{"$error":"#DIV/0!"}},null,0,"",null,null,{"$f":"PRODUCT(J7*E149)","v":0}]
[null,null,null,null,0,0,{"$f":"PRODUCT(F150/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"PRODUCT(E150/E152)*100","v":{"$error":"#DIV/0!"}},null,0,"",null,null,{"$f":"PRODUCT(J7*E150)","v":0}]
[]
[null,null,"TOTAL OUNCES PLS",null,{"$f":"SUM(E75:E150)","v":0},{"$f":"SUM(F75:F150)","v":0},{"$f":"SUM(G75:G150)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(I75:I150)","v":{"$error":"#DIV/0!"}},null,"AVE COC FORB",{"$f":"AVERAGE(L75:L150)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,"3/  Individual species not to exceed 50% of the forb component by seeds/ft"]
[null,"TOTAL SEEDS/FT   4/",{"$f":"SUM(F59,F152)","v":0},null,{"$f":"IF(AND(35<C155),\"OK\",\"LOW\")","v":"LOW"},"4/  Minimum 35-40 seeds/square foot"]
[null,"PERCENT GRASS   5/",{"$f":"PRODUCT(F59/C155)*100","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AND(90>C156),\"\",\"HIGH\")","v":{"$error":"#DIV/0!"}},"5/  Maximum 90% grasses "]
[null,"PERCENT FLOWER",{"$f":"PRODUCT(F152/C155)*100","v":{"$error":"#DIV/0!"}},null,null,"6/ Assignment of Coefficients"]
[null,"AVE. COC - MIX",{"$f":"AVERAGE(L17:L57,L75:L150)","v":{"$error":"#DIV/0!"}},null,null,"0 to 3 : Plants with a high range of ecological tolerances/found in a variety of plant communities"]
[null,"SPECIES RICHNESS",{"$f":"COUNT(L17:L57,L75:L150)","v":0},null,null,"4 to 6 : Plants with an intermediate range of ecological tolerances/ associated with a specific plant community"]
[null,null,null,null,null,"7 to 8 : Plants with a poor range of ecological tolerances/associated with advanced successional stage"]
[null,null,null,null,null,"9 to 10 : Plants with a high degree of fidelity to a narrow range of pristine habitats"]
[null,null,null,null,null,"7/  Consult with the appropriate NRCS Area Resource Conservationist or Biologist for prior approval of additional species."]
[]
[]
[]
[]
[]
[]
[" "]

{"sheet":"393 CREP CP21 Filter Strip ","index":6,"n_rows":158,"n_cols":11,"rows_kept":158,"cut":false,"hidden":false,"merged":[[0,0,0,13],[1,0,1,13],[14,4,14,10],[69,8,69,9],[70,0,72,0],[70,10,72,10],[4,1,4,2],[4,7,4,8],[6,1,6,2],[6,7,6,8],[10,0,10,2],[10,8,10,9],[11,0,13,0],[11,10,13,10],[11,6,13,6]]}
["CREP 393 FILTER STRIP - NATIVE GRASSES/FORBS"]
["Seeding Design"]
[null,null,null,null,null,null,null,null,"DATE",{"$f":"TODAY()","v":"2022-06-16"}]
[]
["LANDOWNER",null,null,null,null,null,null,"TRACT/FIELD"]
[]
["PLANNER",null,null,null,null,null,null,"ACRES SEEDED"]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Background Information"]
["GRASS SPECIES",null,"PLANNED %",null,"POUNDS","TOTAL SEEDS/","% OF GRASS MIX BY SEEDS/FT 1/",null,"Seeds/Pound","SEEDS/","POUNDS PLS"]
[null,null,"OF GRASS MIX BY",null,"PLS/AC.","SQ. FOOT",null,null,null,"SQ. FOOT"]
[null,null,"SEEDS/SQ. FOOT",null,null,null,null,null,null,"At 1 lb./Ac Rate"]
[null,null,"Planned"]
["Warm Season"]
["Big Bluestem","Andropogon gerardii","0 to 50",null,0,{"$f":"PRODUCT(J17,E17)","v":0},{"$f":"PRODUCT(F17/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(51>G17),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},176000,{"$f":"PRODUCT(I17/43560)","v":4.0404040404040407},{"$f":"PRODUCT(J7,E17)","v":0}]
["Blue Grama","Bouteloua gracilis","0 to 25",null,0,{"$f":"PRODUCT(J18,E18)","v":0},{"$f":"PRODUCT(F18/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(26>G18),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},750000,{"$f":"PRODUCT(I18/43560)","v":17.217630853994489},{"$f":"PRODUCT(J7,E18)","v":0}]
["Indiangrass","Sorgastrum nutans","0 to 25",null,0,{"$f":"PRODUCT(J19,E19)","v":0},{"$f":"PRODUCT(F19/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(26>G19),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},193000,{"$f":"PRODUCT(I19/43560)","v":4.4306703397612486},{"$f":"PRODUCT(J7,E19)","v":0}]
["Little Bluestem","Schizachryrium scoparium","0 to 25",null,0,{"$f":"PRODUCT(J20,E20)","v":0},{"$f":"PRODUCT(F20/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(26>G20),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},286000,{"$f":"PRODUCT(I20/43560)","v":6.5656565656565657},{"$f":"PRODUCT(J7,E20)","v":0}]
["Prairie Cordgrass","Spartina pectinata","0 to 100",null,0,{"$f":"PRODUCT(J21,E21)","v":0},{"$f":"PRODUCT(F21/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(101>G21),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},183000,{"$f":"PRODUCT(I21/43560)","v":4.2011019283746558},{"$f":"PRODUCT(J7,E21)","v":0}]
["Sideoats Grama","Bouteloua curtipendula","0 to 25",null,0,0,{"$f":"PRODUCT(F22/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(26>G22),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},180000,4.1322314049586772,{"$f":"PRODUCT(J7,E22)","v":0}]
["Switchgrass","Panicum virgatum","0 to 100",null,0,0,{"$f":"PRODUCT(F23/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(101>G23),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},390000,8.9531680440771346,{"$f":"PRODUCT(J7,E23)","v":0}]
["Cool Season",null,null,null,"  "]
["Canada Wildrye","Elymus canadensis","0 to 25",null,0,0,{"$f":"PRODUCT(F25/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(26>G25),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},115000,2.6400367309458219,{"$f":"PRODUCT(J7,E25)","v":0}]
["Fringed Brome","Bromub ciliatus","0 to 50",null,0,{"$f":"PRODUCT(J26,E26)","v":0},{"$f":"PRODUCT(F26/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(51>G26),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},160000,{"$f":"PRODUCT(I26/43560)","v":3.6730945821854912},{"$f":"PRODUCT(J7,E26)","v":0}]
["Green Needlegrass","Nassella viridula","0 to 25",null,0,{"$f":"PRODUCT(J27,E27)","v":0},{"$f":"PRODUCT(F27/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(26>G27),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},180000,{"$f":"PRODUCT(I27/43560)","v":4.1322314049586772},{"$f":"PRODUCT(J7,E27)","v":0}]
["Kalms Brome","Bromus kalmii","0 to 25",null,0,{"$f":"PRODUCT(J28,E28)","v":0},{"$f":"PRODUCT(F28/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(26>G28),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},128000,{"$f":"PRODUCT(I28/43560)","v":2.9384756657483928},{"$f":"PRODUCT(J7,E28)","v":0}]
["Slender Wheatgrass","Agropyron caninum","0 to 25",null,0,0,{"$f":"PRODUCT(F29/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(26>G29),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},155000,3.5583103764921948,{"$f":"PRODUCT(J7,E29)","v":0}]
["Virginia Wildrye","Elymus virginicus","0 to 25",null,0,0,{"$f":"PRODUCT(F30/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(26>G30),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},96000,2.2038567493112948,{"$f":"PRODUCT(J7,E30)","v":0}]
["Western Wheatgrass","Agropyron smithii","0 to 50",null,0,{"$f":"PRODUCT(J31,E31)","v":0},{"$f":"PRODUCT(F31/F59,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(51>G31),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},112000,{"$f":"PRODUCT(I31/43560)","v":2.5711662075298438},{"$f":"PRODUCT(J7,E31)","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[]
[null,null,"TOTAL POUNDS PLS",null,{"$f":"SUM(E17:E31)","v":0},{"$f":"SUM(F17:F31)","v":0},{"$f":"SUM(G17:G31)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["1/  ACTUAL SEEDS PER SQUARE FOOT SHALL BE WITHIN THE RANGE SPECIFIED IN PLANNED CONDITION"]
[null,null,null,null,null,null,null,null,"Background Information"]
["FORB SPECIES",null,null,null,"OUNCES","TOTAL SEEDS/","% FORBS BY SEEDS",null,"SEEDS/oz","SEEDS/","OUNCES PLS"]
[null,null,null,null,"PLS/AC.","SQ. FOOT","SQ./FT",null,null,"SQ. FOOT"]
[null,null,null,null,null,null,null,null,null,"At 1 oz/ac Rate"]
[]
["Canada Goldenrod","Solidago canadensis",null,null,0,{"$f":"PRODUCT(J75,E75)","v":0},{"$f":"PRODUCT(F75/F152,100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(50>G75),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},287500,{"$f":"PRODUCT(I75/43560)","v":6.6000918273645546},{"$f":"PRODUCT(J7,E75)","v":0}]
["Cup Plant","Silphium perfoliatum",null,null,0,0,{"$f":"PRODUCT(F76/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},1400,3.2139577594123052E-2,{"$f":"PRODUCT(J7,E76)","v":0}]
["Giant Hyssop","Agastache foeniculum",null,null,0,0,{"$f":"PRODUCT(F77/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},91000,2.089072543617998,{"$f":"PRODUCT(J7,E77)","v":0}]
["Giant/Late Goldenrod","Solidago gigantea",null,null,0,0,{"$f":"PRODUCT(F78/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},250000,5.7392102846648303,{"$f":"PRODUCT(J7,E78)","v":0}]
["Grass-leaved Goldenrod","Euthamia  graminifolia ",null,null,0,0,{"$f":"PRODUCT(F79/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},350000,8.0348943985307617,{"$f":"PRODUCT(J7,E79)","v":0}]
["Ironweed","Veronia fasticulata",null,null,0,0,{"$f":"PRODUCT(F80/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},24000,0.55096418732782371,{"$f":"PRODUCT(J7,E80)","v":0}]
["Joe-pye Weed","Eutrochium maculatum",null,null,0,0,{"$f":"PRODUCT(F81/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},95000,2.1808999081726355,{"$f":"PRODUCT(J7,E81)","v":0}]
["Mountain Mint","Pycnanthemum virginianum",null,null,0,{"$f":"PRODUCT(J82,E82)","v":0},{"$f":"PRODUCT(F82/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},220000,5.0505050505050502,{"$f":"PRODUCT(J7,E82)","v":0}]
["New England Aster","Symphyotrichum novae-angliae",null,null,0,0,{"$f":"PRODUCT(F83/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},66000,1.5151515151515151,{"$f":"PRODUCT(J7,E83)","v":0}]
["Sneezeweed","Helenium autumnale",null,null,0,0,{"$f":"PRODUCT(F84/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},130000,2.9843893480257115,{"$f":"PRODUCT(J7,E84)","v":0}]
["Stiff Goldenrod","Solidago rigida",null,null,0,0,{"$f":"PRODUCT(F85/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},41000,0.94123048668503217,{"$f":"PRODUCT(J7,E85)","v":0}]
["Panicled  Aster","Symphyotrichum lanceolatum",null,null,0,0,{"$f":"PRODUCT(F86/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},156000,3.5812672176308542,{"$f":"PRODUCT(J7,E86)","v":0}]
["Swamp Milkweed  ","Asclepias incarnata",null,null,0,0,{"$f":"PRODUCT(F87/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},4800,0.11019283746556474,{"$f":"PRODUCT(J7,E87)","v":0}]
["White Sage","Artemisia ludoviciana",null,null,0,0,{"$f":"PRODUCT(F88/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},4048000,92.929292929292927,{"$f":"PRODUCT(J7,E88)","v":0}]
["Wild Bergamot","Monarda fistulosa",null,null,0,0,{"$f":"PRODUCT(F89/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},70000,1.6069788797061524,{"$f":"PRODUCT(J7,E89)","v":0}]
["Yellow Coneflower","Ratibida pinnata",null,null,0,0,{"$f":"PRODUCT(F90/F152,100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},30000,0.68870523415977958,{"$f":"PRODUCT(J7,E90)","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[]
[null,null,"TOTAL OUNCES PLS",null,{"$f":"SUM(E75:E90)","v":0},{"$f":"SUM(F75:F90)","v":0},{"$f":"SUM(G75:G90)","v":{"$error":"#DIV/0!"}}]
[]
[]
["TOTAL SEEDS/FT2 ",null,{"$f":"SUM(F59,F152)","v":0},null,{"$f":"IF(AND(55<C155),\"OK\",\"LOW\")","v":"LOW"},"Minimum 55 seeds/square foot"]
[]
["PERCENT GRASS",null,{"$f":"(F59/C155)*100","v":{"$error":"#DIV/0!"}}]
["PERCENT FORBS",null,{"$f":"PRODUCT(F152/C155)*100","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AND(10.1>C158),\"OK\",\"HIGH\")","v":{"$error":"#DIV/0!"}},"Forbs - NTE 10% of mix"]

{"sheet":"657 CREP Wet-Sedge Meadow CP23A","index":7,"n_rows":158,"n_cols":10,"rows_kept":158,"cut":false,"hidden":false,"merged":[[4,1,4,5],[6,1,6,5],[12,7,12,8],[0,0,0,13],[1,0,1,13],[13,0,15,0],[13,2,15,3],[13,5,15,5],[13,6,15,6],[155,4,155,9],[13,9,15,9],[34,9,36,9],[71,0,73,0],[71,2,73,3],[71,5,73,5],[71,6,73,6],[71,9,73,9],[156,4,156,9],[34,0,36,0],[34,2,36,3],[34,5,36,5],[34,6,36,6]]}
["CREP 657 WET/SEDGE  MEADOW"]
["Seeding Design"]
[null,null,null,null,null,null,null,null,"DATE",{"$f":"TODAY()","v":"2022-06-16"}]
[]
["LANDOWNER",null,null,null,null,null,null,null,"TRACT/FIELD"]
[]
["PLANNER",null,null,null,null,null,null,null,"ACRES SEEDED"]
[]
[]
[]
[]
[]
[]
["GRASS SPECIES",null,null,null,"POUNDS","% OF GRASS COMPONENT","% OF TOTAL MIX","SEEDS/","SEEDS/","POUNDS PLS"]
[null,null,null,null,"PLS/AC.",null,null,"SQ. FOOT","SQ. FOOT"]
[null,null,null,null,"  ",null,null,"GRASS","At 1 lb/Ac Rate"]
["Big Bluestem","Andropogon gerardi",null,null,0,{"$f":"PRODUCT(H17/H33)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H17/B154)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(I17,E17)","v":0},4,{"$f":"PRODUCT(E17*J7)","v":0}]
["Fringed Brome","Bromus ciliata",null,null,0,{"$f":"PRODUCT(H18/H33)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H18/B154)*100","v":{"$error":"#DIV/0!"}},0,3.7,{"$f":"PRODUCT(E18*J7)","v":0}]
["Canada Bluejoint","Calamagrostis canadensis",null,null,0,{"$f":"PRODUCT(H19/H33)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H19/B154)*100","v":{"$error":"#DIV/0!"}},0,102.8,{"$f":"PRODUCT(E19*J7)","v":0}]
["Virginia Wildrye","Elymus virginicus",null,null,0,{"$f":"PRODUCT(H20/H33)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H20/B154)*100","v":{"$error":"#DIV/0!"}},0,2.2000000000000002,{"$f":"PRODUCT(E20*J7)","v":0}]
["Tall Manna Grass","Glyceria grandis",null,null,0,{"$f":"PRODUCT(H21/H33)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H21/B154)*100","v":{"$error":"#DIV/0!"}},0,29.38,{"$f":"PRODUCT(E21*J7)","v":0}]
["Fowl Manna Grass","Glyceria striata",null,null,0,{"$f":"PRODUCT(H22/H33)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H22/B154)*100","v":{"$error":"#DIV/0!"}},0,58.77,{"$f":"PRODUCT(E22*J7)","v":0}]
["Rice Cut Grass","Leersia oryzoides",null,null,0,{"$f":"PRODUCT(H23/H33)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H23/B154)*100","v":{"$error":"#DIV/0!"}},0,12.49,{"$f":"PRODUCT(E23*J7)","v":0}]
["Switchgrass","Panicum virgatum",null,null,0,{"$f":"PRODUCT(H24/H33)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H24/B154)*100","v":{"$error":"#DIV/0!"}},0,9,{"$f":"PRODUCT(E24*J7)","v":0}]
["Fowl Bluegrass","Poa palustris",null,null,0,{"$f":"PRODUCT(H25/H33)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H25/B154)*100","v":{"$error":"#DIV/0!"}},0,47.8,{"$f":"PRODUCT(E25*J7)","v":0}]
["Indiangrass","Sorgastrum nutans",null,null,0,{"$f":"PRODUCT(H26/H33)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H26/B154)*100","v":{"$error":"#DIV/0!"}},0,4.4000000000000004,{"$f":"PRODUCT(E26*J7)","v":0}]
["Prairie Cordgrass","Spartina pectinata",null,null,0,{"$f":"PRODUCT(H27/H33)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H27/B154)*100","v":{"$error":"#DIV/0!"}},0,4.2,{"$f":"PRODUCT(E27*J7)","v":0}]
[null,null,null,null,0,{"$f":"PRODUCT(H28/H33)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H28/B154)*100","v":{"$error":"#DIV/0!"}},0,null,{"$f":"PRODUCT(E28*J7)","v":0}]
[null,null,null,null,0,{"$f":"PRODUCT(H29/H33)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H29/B154)*100","v":{"$error":"#DIV/0!"}},0,null,{"$f":"PRODUCT(E29*J7)","v":0}]
[null,null,null,null,0,{"$f":"PRODUCT(H30/H33)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H30/B154)*100","v":{"$error":"#DIV/0!"}},0,null,{"$f":"PRODUCT(E30*J7)","v":0}]
[null,null,null,null,0,{"$f":"PRODUCT(H31/H33)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H31/B154)*100","v":{"$error":"#DIV/0!"}},0,null,{"$f":"PRODUCT(E31*J7)","v":0}]
[null,null,null,null,0,{"$f":"PRODUCT(H32/H33)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H32/B154)*100","v":{"$error":"#DIV/0!"}},0,null,{"$f":"PRODUCT(E32*J7)","v":0}]
["TOTAL POUNDS",{"$f":"SUM(E17:E32)","v":0},null,null,"  ","  ",null,{"$f":"SUM(H17:H32)","v":0}]
[null,null,null,null,"  ","  "]
["SEDGE/RUSH SPECIES",null,null,null,"POUNDS","% OF SEDGE COMPONENT","% OF TOTAL MIX","SEEDS/","SEEDS/","POUNDS PLS"]
[null,null,null,null,"PLS/AC.",null,null,"SQ. FOOT","SQ. FOOT"]
[null,null,null,null,"  ",null,null,"SEDGES","At 1 lb/Ac Rate"]
["Bebb's Sedge","Carex bebbii",null,null,0,{"$f":"PRODUCT(H38/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H38/B154)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(I38,E38)","v":0},12.5,{"$f":"PRODUCT(E38*J7)","v":0}]
["Bristly Sedge","Carex comosa",null,null,0,{"$f":"PRODUCT(H39/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H39/B154)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(I39,E39)","v":0},11.02,{"$f":"PRODUCT(E39*J7)","v":0}]
["Wooly Sedge","Carex pellita",null,null,0,{"$f":"PRODUCT(H40/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H40/B154)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(I40,E40)","v":0},10.28,{"$f":"PRODUCT(E40*J7)","v":0}]
["Retrosa Sedge","Carex retrorsa",null,null,0,{"$f":"PRODUCT(H41/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H41/B154)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(I41,E41)","v":0},4,{"$f":"PRODUCT(E41*J7)","v":0}]
["Pointed Broom Sedge","Carex scoparia",null,null,0,{"$f":"PRODUCT(H42/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H42/B154)*100","v":{"$error":"#DIV/0!"}},0,30.85,{"$f":"PRODUCT(E42*J7)","v":0}]
["Awl-fruited Sedge","Carex stipata",null,null,0,{"$f":"PRODUCT(H43/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H43/B154)*100","v":{"$error":"#DIV/0!"}},0,12.49,{"$f":"PRODUCT(E43*J7)","v":0}]
["Tussock Sedge","Carex stricta",null,null,0,{"$f":"PRODUCT(H44/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H44/B154)*100","v":{"$error":"#DIV/0!"}},0,19.47,{"$f":"PRODUCT(E44*J7)","v":0}]
["Fox Sedge","Carex vulpinoidea",null,null,0,{"$f":"PRODUCT(H45/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H45/B154)*100","v":{"$error":"#DIV/0!"}},0,36.729999999999997,{"$f":"PRODUCT(E45*J7)","v":0}]
["Spike-rush","Eleocharis acicularis",null,null,0,{"$f":"PRODUCT(H46/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H46/B154)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(I46,E46)","v":0},25.7,{"$f":"PRODUCT(E46*J7)","v":0}]
["Creeping spike-rush","Eleocharis palustris",null,null,0,{"$f":"PRODUCT(H47/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H47/B154)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(I47,E47)","v":0},18.7,{"$f":"PRODUCT(E47*J7)","v":0}]
["Knotted Rush","Juncus nodosus",null,null,0,{"$f":"PRODUCT(H48/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H48/B154)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(I48,E48)","v":0},679.9,{"$f":"PRODUCT(E48*J7)","v":0}]
["Path Rush","Juncus tenuis",null,null,0,{"$f":"PRODUCT(H49/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H49/B154)*100","v":{"$error":"#DIV/0!"}},0,367.31,{"$f":"PRODUCT(E49*J7)","v":0}]
["Torrey's Rush","Juncus torreyii",null,null,0,{"$f":"PRODUCT(H50/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H50/B154)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(I50,E50)","v":0},587.70000000000005,{"$f":"PRODUCT(E50*J7)","v":0}]
["Dark Green Bulrush","Scirpus atrovirens",null,null,0,{"$f":"PRODUCT(H51/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H51/B154)*100","v":{"$error":"#DIV/0!"}},0,168.96,{"$f":"PRODUCT(E51*J7)","v":0}]
["Woolgrass","Scirpus cypernius",null,null,0,{"$f":"PRODUCT(H52/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H52/B154)*100","v":{"$error":"#DIV/0!"}},0,624.42999999999995,{"$f":"PRODUCT(E52*J7)","v":0}]
[null,null,null,null,0,{"$f":"PRODUCT(H53/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H53/B154)*100","v":{"$error":"#DIV/0!"}},0,null,{"$f":"PRODUCT(E53*J7)","v":0}]
[null,null,null,null,0,{"$f":"PRODUCT(H54/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H54/B154)*100","v":{"$error":"#DIV/0!"}},0,null,{"$f":"PRODUCT(E54*J7)","v":0}]
[null,null,null,null,0,{"$f":"PRODUCT(H55/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H55/B154)*100","v":{"$error":"#DIV/0!"}},0,null,{"$f":"PRODUCT(E55*J7)","v":0}]
[null,null,null,null,0,{"$f":"PRODUCT(H56/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H56/B154)*100","v":{"$error":"#DIV/0!"}},0,null,{"$f":"PRODUCT(E56*J7)","v":0}]
[null,null,null,null,0,{"$f":"PRODUCT(H57/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H57/B154)*100","v":{"$error":"#DIV/0!"}},0,null,{"$f":"PRODUCT(E57*J7)","v":0}]
["TOTAL POUNDS",{"$f":"SUM(E38:E57)","v":0},null,null,"  ",null,null,{"$f":"SUM(H38:H57)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["FORB SPECIES",null,null,null,"OUNCES","% OF FORB COMPONENT","% OF TOTAL MIX","SEEDS/","SEEDS/","OUNCES PLS"]
[null,null,null,null,"PLS/AC.",null,null,"SQ. FOOT","SQ. FOOT"]
[null,null,null,null,"  ",null,null,"FORBS","At 1 oz/Ac Rate"]
["Blue Giant Hyssop","Agastache foeniculum",null,null,0,{"$f":"PRODUCT(H75/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H75/B154)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(I75,E75)","v":0},2.09,{"$f":"PRODUCT(E75*J7)","v":0}]
["Canada Anemone","Anemone canadensis",null,null,0,{"$f":"PRODUCT(H76/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H76/B154)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(I76,E76)","v":0},0.18,{"$f":"PRODUCT(E76*J7)","v":0}]
["Dogbane","Apocynum spp.",null,null,0,{"$f":"PRODUCT(H77/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H77/B154)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(I77,E77)","v":0},0.5,{"$f":"PRODUCT(E77*J7)","v":0}]
["Swamp Milkweed  ","Asclepias incarnata",null,null,0,{"$f":"PRODUCT(H78/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H78/B154)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(I78,E78)","v":0},0.11,{"$f":"PRODUCT(E78*J7)","v":0}]
["Beggar's Ticks","Bidens cernua",null,null,0,{"$f":"PRODUCT(H79/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H79/B154)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(I79,E79)","v":0},0.5,{"$f":"PRODUCT(E79*J7)","v":0}]
["Canada Tick Trefoil","Desmodium canadense",null,null,0,{"$f":"PRODUCT(H80/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H80/B154)*100","v":{"$error":"#DIV/0!"}},0,0.13,{"$f":"PRODUCT(E80*J7)","v":0}]
["Flat-topped/White Aster","Doellingeria umbellata",null,null,0,{"$f":"PRODUCT(H81/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H81/B154)*100","v":{"$error":"#DIV/0!"}},0,1.54,{"$f":"PRODUCT(E81*J7)","v":0}]
["Joe-pye Weed","Eutrochium maculatum",null,null,0,{"$f":"PRODUCT(H82/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H82/B154)*100","v":{"$error":"#DIV/0!"}},0,2.1800000000000002,{"$f":"PRODUCT(E82*J7)","v":0}]
["Boneset","Eupatorium perfoliatum",null,null,0,{"$f":"PRODUCT(H83/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H83/B154)*100","v":{"$error":"#DIV/0!"}},0,3.67,{"$f":"PRODUCT(E83*J7)","v":0}]
["Grass-leaved Goldenrod","Euthamia gramnifolia",null,null,0,{"$f":"PRODUCT(H84/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H84/B154)*100","v":{"$error":"#DIV/0!"}},0,8.0299999999999994,{"$f":"PRODUCT(E84*J7)","v":0}]
["Sneezeweed ","Helenium autumnale",null,null,0,{"$f":"PRODUCT(H85/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H85/B154)*100","v":{"$error":"#DIV/0!"}},0,2.98,{"$f":"PRODUCT(E85*J7)","v":0}]
["Sawtooth Sunflower","Helianthus grosseserratus",null,null,0,{"$f":"PRODUCT(H86/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H86/B154)*100","v":{"$error":"#DIV/0!"}},0,0.23,{"$f":"PRODUCT(E86*J7)","v":0}]
["Blue-flag Iris ","Iris versicolor",null,null,0,{"$f":"PRODUCT(H87/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H87/B154)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(I87,E87)","v":0},0.1,{"$f":"PRODUCT(E87*J7)","v":0}]
["Meadow Blazingstar","Liatris lingulistylis",null,null,0,{"$f":"PRODUCT(H88/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H88/B154)*100","v":{"$error":"#DIV/0!"}},0,0.25,{"$f":"PRODUCT(E88*J7)","v":0}]
["Tall Blazingstar","Liatris pycnostachya",null,null,0,{"$f":"PRODUCT(H89/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H89/B154)*100","v":{"$error":"#DIV/0!"}},0,0.25,{"$f":"PRODUCT(E89*J7)","v":0}]
["Great Blue Lobelia","Lobelia siphilitica",null,null,0,{"$f":"PRODUCT(H90/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H90/B154)*100","v":{"$error":"#DIV/0!"}},0,11.48,{"$f":"PRODUCT(E90*J7)","v":0}]
["Water Horehound","Lycopus americanus",null,null,0,{"$f":"PRODUCT(H91/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H91/B154)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(I91,E91)","v":0},2.98,{"$f":"PRODUCT(E91*J7)","v":0}]
["Blue Monkey Flower","Mimulus ringens",null,null,0,{"$f":"PRODUCT(H92/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H92/B154)*100","v":{"$error":"#DIV/0!"}},0,52.8,{"$f":"PRODUCT(E92*J7)","v":0}]
["Mountain Mint","Pycnanthmum virginianum",null,null,0,{"$f":"PRODUCT(H93/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H93/B154)*100","v":{"$error":"#DIV/0!"}},0,5.05,{"$f":"PRODUCT(E93*J7)","v":0}]
["Giant Goldenrod","Solidago gigantea",null,null,0,{"$f":"PRODUCT(H94/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H94/B154)*100","v":{"$error":"#DIV/0!"}},0,5.74,{"$f":"PRODUCT(E94*J7)","v":0}]
["Panicled Aster","Symphyotrichum lanceolatum",null,null,0,{"$f":"PRODUCT(H95/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H95/B154)*100","v":{"$error":"#DIV/0!"}},0,3.58,{"$f":"PRODUCT(E95*J7)","v":0}]
["New England Aster","Symphyotrichum novae-angliae",null,null,0,{"$f":"PRODUCT(H96/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H96/B154)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(I96,E96)","v":0},1.5,{"$f":"PRODUCT(E96*J7)","v":0}]
["Red-stemmed/Swamp Aster","Symphyotrichum puniceum",null,null,0,{"$f":"PRODUCT(H97/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H97/B154)*100","v":{"$error":"#DIV/0!"}},0,1.84,{"$f":"PRODUCT(E97*J7)","v":0}]
["Tall Meadow Rue","Thalictrum dasycarpum",null,null,0,{"$f":"PRODUCT(H98/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H98/B154)*100","v":{"$error":"#DIV/0!"}},0,0.25,{"$f":"PRODUCT(E98*J7)","v":0}]
["Blue Vervain","Verbena hastata",null,null,0,{"$f":"PRODUCT(H99/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H99/B154)*100","v":{"$error":"#DIV/0!"}},0,2.13,{"$f":"PRODUCT(E99*J7)","v":0}]
["Ironweed","Verona fasticulata",null,null,0,{"$f":"PRODUCT(H100/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H100/B154)*100","v":{"$error":"#DIV/0!"}},0,0.55000000000000004,{"$f":"PRODUCT(E100*J7)","v":0}]
["Culvers Root","Veronicastrum virginicum",null,null,0,{"$f":"PRODUCT(H101/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H101/B154)*100","v":{"$error":"#DIV/0!"}},0,18.37,{"$f":"PRODUCT(E101*J7)","v":0}]
["Golden Alexanders","Zizia aurea",null,null,0,{"$f":"PRODUCT(H102/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H102/B154)*100","v":{"$error":"#DIV/0!"}},0,0.25,{"$f":"PRODUCT(E102*J7)","v":0}]
[null,null,null,null,0,{"$f":"PRODUCT(H103/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H103/B154)*100","v":{"$error":"#DIV/0!"}},0,null,{"$f":"PRODUCT(E103*J7)","v":0}]
[null,null,null,null,0,{"$f":"PRODUCT(H104/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H104/B154)*100","v":{"$error":"#DIV/0!"}},0,null,{"$f":"PRODUCT(E104*J7)","v":0}]
[null,null,null,null,0,{"$f":"PRODUCT(H105/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H105/B154)*100","v":{"$error":"#DIV/0!"}},0,null,{"$f":"PRODUCT(E105*J7)","v":0}]
[null,null,null,null,0,{"$f":"PRODUCT(H106/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H106/B154)*100","v":{"$error":"#DIV/0!"}},0,null,{"$f":"PRODUCT(E106*J7)","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,"TOTAL OUNCES",null,null,{"$f":"SUM(E75:E150)","v":0},null,null,{"$f":"SUM(H75:H150)","v":0}]
[]
[]
["TOTAL SEEDS/FT",{"$f":"SUM(H33,H58,H151)","v":0},null,null,null,"110 - 200 seeds/ft2"]
[]
["PERCENT GRASS",{"$f":"PRODUCT(H33/B154)","v":{"$error":"#DIV/0!"}},null,null,"Recommended Percentage:  Wet Meadow 20 - 60%, Sedge Meadow 20 - 50%"]
["PERCENT SEDGE/RUSH",{"$f":"PRODUCT(H58/B154)","v":{"$error":"#DIV/0!"}},null,null,"Recommended Percentage: Wet Meadow  15 - 60%, Sedge Meadow 40 - 70%"]
["PERCENT FORB",{"$f":"PRODUCT(H151/B154)","v":{"$error":"#DIV/0!"}},null,null,"Recommended Percentage  15 - 35%"]

{"sheet":"657 CREP Emergent Fringe CP23A","index":8,"n_rows":158,"n_cols":10,"rows_kept":158,"cut":false,"hidden":false,"merged":[[157,5,157,7],[32,0,34,0],[32,2,34,3],[32,5,34,5],[32,6,34,6],[71,6,73,6],[156,5,156,7],[155,5,155,7],[71,0,73,0],[71,2,73,3],[71,5,73,5],[0,0,0,11],[1,0,1,11],[71,9,73,9],[4,1,4,5],[6,1,6,5],[12,7,12,8],[13,9,15,9],[32,9,34,9],[13,0,15,0],[13,2,15,3],[13,5,15,5],[13,6,15,6]]}
["CREP 657 EMERGENT WETLAND FRINGE"]
["Seeding Design"]
[null,null,null,null,null,null,null,null,"DATE",{"$f":"TODAY()","v":"2022-06-16"}]
[]
["LANDOWNER",null,null,null,null,null,null,null,"TRACT/FIELD"]
[]
["PLANNER",null,null,null,null,null,null,null,"ACRES SEEDED"]
[]
[]
[]
[]
[]
[]
["GRASS SPECIES",null,null,null,"POUNDS","% OF GRASS COMPONENT","% OF TOTAL MIX","SEEDS/","SEEDS/","POUNDS PLS"]
[null,null,null,null,"PLS/AC.",null,null,"SQ. FOOT","SQ. FOOT"]
[null,null,null,null,"  ",null,null,"GRASS","At 1 lb/Ac Rate"]
["American Sloughgrass","Beckmannia syzigachne",null,null,0,{"$f":"PRODUCT(H17/H26)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H17/B154)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(I17,E17)","v":0},18.399999999999999,{"$f":"PRODUCT(E17*J7)","v":0}]
["Canada Bluejoint","Calamagrostis canadensis",null,null,0,{"$f":"PRODUCT(H18/H26)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H18/B154)*100","v":{"$error":"#DIV/0!"}},0,102.8,{"$f":"PRODUCT(E18*J7)","v":0}]
["Tall Manna Grass","Glyceria grandis",null,null,0,{"$f":"PRODUCT(H19/H26)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H19/B154)*100","v":{"$error":"#DIV/0!"}},0,29.38,{"$f":"PRODUCT(E19*J7)","v":0}]
["Rattlesnake Manna Grass","Glyceria canadensis",null,null,0,{"$f":"PRODUCT(H20/H26)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H20/B154)*100","v":{"$error":"#DIV/0!"}},0,58.77,{"$f":"PRODUCT(E20*J7)","v":0}]
["Rice Cut Grass","Leersia oryzoides",null,null,0,{"$f":"PRODUCT(H21/H26)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H21/B154)*100","v":{"$error":"#DIV/0!"}},0,12.49,{"$f":"PRODUCT(E21*J7)","v":0}]
[null,null,null,null,0,{"$f":"PRODUCT(H22/H26)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H22/B154)*100","v":{"$error":"#DIV/0!"}},0,null,{"$f":"PRODUCT(E22*J7)","v":0}]
[null,null,null,null,0,{"$f":"PRODUCT(H23/H26)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H23/B154)*100","v":{"$error":"#DIV/0!"}},0,null,{"$f":"PRODUCT(E23*J7)","v":0}]
[null,null,null,null,0,{"$f":"PRODUCT(H24/H26)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H24/B154)*100","v":{"$error":"#DIV/0!"}},0,null,{"$f":"PRODUCT(E24*J7)","v":0}]
[null,null,null,null,0,{"$f":"PRODUCT(H25/H26)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H25/B154)*100","v":{"$error":"#DIV/0!"}},0,null,{"$f":"PRODUCT(E25*J7)","v":0}]
["TOTAL POUNDS",{"$f":"SUM(E17:E25)","v":0},null,null,"  ",null,null,{"$f":"SUM(H17:H25)","v":0}]
[null,null,null,null,"  "]
[null,null,null,null,"  "]
[null,null,null,null,"  "]
[null,null,null,null,"  "]
[null,null,null,null,"  "]
[null,null,null,null,"  "]
["SEDGE/RUSH SPECIES",null,null,null,"POUNDS","% OF SEDGE COMPONENT","% OF TOTAL MIX","SEEDS/","SEEDS/","POUNDS PLS"]
[null,null,null,null,"PLS/AC.",null,null,"SQ. FOOT","SQ. FOOT"]
[null,null,null,null,"  ",null,null,"SEDGES","At 1 lb/Ac Rate"]
["Slough sedge","Carex atherodes",null,null,0,{"$f":"PRODUCT(H36/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H36/B154)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(I36,E36)","v":0},10.65,{"$f":"PRODUCT(E36*J7)","v":0}]
["Bottlebrush sedge","Carex comosa",null,null,0,{"$f":"PRODUCT(H37/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H37/B154)*100","v":{"$error":"#DIV/0!"}},0,11.02,{"$f":"PRODUCT(E37*J7)","v":0}]
["Porcupine sedge","Carex hystericina",null,null,0,{"$f":"PRODUCT(H38/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H38/B154)*100","v":{"$error":"#DIV/0!"}},0,11.02,{"$f":"PRODUCT(E38*J7)","v":0}]
["Lake sedge","Carex lacustris",null,null,0,{"$f":"PRODUCT(H39/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H39/B154)*100","v":{"$error":"#DIV/0!"}},0,11.75,{"$f":"PRODUCT(E39*J7)","v":0}]
["Tussock sedge","Carex stricta",null,null,0,{"$f":"PRODUCT(H40/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H40/B154)*100","v":{"$error":"#DIV/0!"}},0,19.47,{"$f":"PRODUCT(E40*J7)","v":0}]
["Fox sedge","Carex vulpinoidea",null,null,0,{"$f":"PRODUCT(H41/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H41/B154)*100","v":{"$error":"#DIV/0!"}},0,36.729999999999997,{"$f":"PRODUCT(E41*J7)","v":0}]
["Least spike-rush","Eleocharis acicularis",null,null,0,{"$f":"PRODUCT(H42/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H42/B154)*100","v":{"$error":"#DIV/0!"}},0,25.71,{"$f":"PRODUCT(E42*J7)","v":0}]
["Marsh spike-rush","Eleocharis palustris",null,null,0,{"$f":"PRODUCT(H43/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H43/B154)*100","v":{"$error":"#DIV/0!"}},0,18.73,{"$f":"PRODUCT(E43*J7)","v":0}]
["Soft rush","Juncus effusus",null,null,0,{"$f":"PRODUCT(H44/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H44/B154)*100","v":{"$error":"#DIV/0!"}},0,367.31,{"$f":"PRODUCT(E44*J7)","v":0}]
["Knotted rush","Juncus nodosus",null,null,0,{"$f":"PRODUCT(H45/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H45/B154)*100","v":{"$error":"#DIV/0!"}},0,679.89,{"$f":"PRODUCT(E45*J7)","v":0}]
["Torrey’s rush","Juncus torreyi",null,null,0,{"$f":"PRODUCT(H46/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H46/B154)*100","v":{"$error":"#DIV/0!"}},0,587.70000000000005,{"$f":"PRODUCT(E46*J7)","v":0}]
["Hard-stem bulrush","Schoenoplectus acutus",null,null,0,{"$f":"PRODUCT(H47/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H47/B154)*100","v":{"$error":"#DIV/0!"}},0,4.74,{"$f":"PRODUCT(E47*J7)","v":0}]
["River bulrush","Schoenoplectus fluviatilis",null,null,0,{"$f":"PRODUCT(H48/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H48/B154)*100","v":{"$error":"#DIV/0!"}},0,1.58,{"$f":"PRODUCT(E48*J7)","v":0}]
["Three-square bulrush","Schoenoplectus pungens",null,null,0,{"$f":"PRODUCT(H49/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H49/B154)*100","v":{"$error":"#DIV/0!"}},0,4.41,{"$f":"PRODUCT(E49*J7)","v":0}]
["Soft-stem bulrush","Schoenoplectus tabernaemontani",null,null,0,{"$f":"PRODUCT(H50/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H50/B154)*100","v":{"$error":"#DIV/0!"}},0,11.39,{"$f":"PRODUCT(E50*J7)","v":0}]
["Woolgrass","Scirpus cyperinus",null,null,0,{"$f":"PRODUCT(H51/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H51/B154)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(I51,E51)","v":0},624.42999999999995,{"$f":"PRODUCT(E51*J7)","v":0}]
["Giant bur-reed","Sparganium eurycarpum",null,null,0,{"$f":"PRODUCT(H52/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H52/B154)*100","v":{"$error":"#DIV/0!"}},0,0.01,{"$f":"PRODUCT(E52*J7)","v":0}]
[null,null,null,null,0,{"$f":"PRODUCT(H53/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H53/B154)*100","v":{"$error":"#DIV/0!"}},0,null,{"$f":"PRODUCT(E53*J7)","v":0}]
[null,null,null,null,0,{"$f":"PRODUCT(H54/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H54/B154)*100","v":{"$error":"#DIV/0!"}},0,null,{"$f":"PRODUCT(E54*J7)","v":0}]
[null,null,null,null,0,{"$f":"PRODUCT(H55/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H55/B154)*100","v":{"$error":"#DIV/0!"}},0,null,{"$f":"PRODUCT(E55*J7)","v":0}]
[null,null,null,null,0,{"$f":"PRODUCT(H56/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H56/B154)*100","v":{"$error":"#DIV/0!"}},0,null,{"$f":"PRODUCT(E56*J7)","v":0}]
[null,null,null,null,0,{"$f":"PRODUCT(H57/H58)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H57/B154)*100","v":{"$error":"#DIV/0!"}},0,null,{"$f":"PRODUCT(E57*J7)","v":0}]
["TOTAL POUNDS",{"$f":"SUM(E36:E57)","v":0},null,null,"  ",null,null,{"$f":"SUM(H36:H57)","v":0}]
[null,null,null,null,"  "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"  "]
["FORB SPECIES",null,null,null,"OUNCES","% OF FORB COMPONENT","% OF TOTAL MIX","SEEDS/","SEEDS/","OUNCES PLS"]
[null,null,null,null,"PLS/AC.",null,null,"SQ. FOOT","SQ. FOOT"]
[null,null,null,null,"  ",null,null,"FORBS","At 1 oz/Ac Rate"]
["Sweet flag","Acorus americanus",null,null,0,{"$f":"PRODUCT(H75/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H75/B154)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(I75,E75)","v":0},0.15,{"$f":"PRODUCT(E75*J7)","v":0}]
["Water plantain","Alisma subcordatum",null,null,0,{"$f":"PRODUCT(H76/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H76/B154)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(I76,E76)","v":0},1.5,{"$f":"PRODUCT(E76*J7)","v":0}]
["Marsh milkweed","Asclepias incarnata",null,null,0,{"$f":"PRODUCT(H77/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H77/B154)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(I77,E77)","v":0},0.11,{"$f":"PRODUCT(E77*J7)","v":0}]
["Joe-pye weed","Eutrochium maculatum",null,null,0,{"$f":"PRODUCT(H78/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H78/B154)*100","v":{"$error":"#DIV/0!"}},0,2.1800000000000002,{"$f":"PRODUCT(E78*J7)","v":0}]
["Water smartweed","Polygonum amphibium",null,null,0,{"$f":"PRODUCT(H79/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H79/B154)*100","v":{"$error":"#DIV/0!"}},0,0.18,{"$f":"PRODUCT(E79*J7)","v":0}]
["Great water dock","Rumex orbiculatus",null,null,0,{"$f":"PRODUCT(H80/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H80/B154)*100","v":{"$error":"#DIV/0!"}},0,0.27,{"$f":"PRODUCT(E80*J7)","v":0}]
["Broad-leaved arrowhead","Sagittaria latifolia",null,null,0,{"$f":"PRODUCT(H81/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H81/B154)*100","v":{"$error":"#DIV/0!"}},0,1.4,{"$f":"PRODUCT(E81*J7)","v":0}]
[null,null,null,null,0,{"$f":"PRODUCT(H82/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H82/B154)*100","v":{"$error":"#DIV/0!"}},0,null,{"$f":"PRODUCT(E82*J7)","v":0}]
[null,null,null,null,0,{"$f":"PRODUCT(H83/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H83/B154)*100","v":{"$error":"#DIV/0!"}},0,null,{"$f":"PRODUCT(E83*J7)","v":0}]
[null,null,null,null,0,{"$f":"PRODUCT(H84/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H84/B154)*100","v":{"$error":"#DIV/0!"}},0,null,{"$f":"PRODUCT(E84*J7)","v":0}]
[null,null,null,null,0,{"$f":"PRODUCT(H85/H151)*100","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCT(H85/B154)*100","v":{"$error":"#DIV/0!"}},0,null,{"$f":"PRODUCT(E85*J7)","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,"TOTAL OUNCES",null,null,{"$f":"SUM(E75:E150)","v":0},null,null,{"$f":"SUM(H75:H150)","v":0}]
[]
[]
["TOTAL SEEDS/FT",{"$f":"SUM(H26,H58,H151)","v":0},null,null,null,"110 - 200 seeds/ft2"]
[]
["PERCENT GRASS",{"$f":"PRODUCT(H26/B154)","v":{"$error":"#DIV/0!"}},null,null,null,"Recommended Percentage  20 - 65%"]
["PERCENT SEDGE/RUSH",{"$f":"PRODUCT(H58/B154)","v":{"$error":"#DIV/0!"}},null,null,null,"Recommended Percentage  20 - 65%"]
["PERCENT FORB",{"$f":"PRODUCT(H151/B154)","v":{"$error":"#DIV/0!"}},null,null,null,"Recommended Percentage  15 - 30%"]