New! List B Management Plan Web Database
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFG
1
Adams
*Don't forget to change out the County Name
2
Species Reported In County
Statewide Infested Acres
3
COUNTIF(BListAcres!D2:D,">0")sum(BListAcres!B2:B)Add = in front of code for google to calculate formula. Must be customized per county reference (see red). Replace red part w/ corresponding letter or number from the tab.
4
SpeciesInfested Acres
Statewide Infested Acres
# of Counties Impacted
Management Status
(View Containment Map)
Data Collection Year
5
Absinth wormwoodVLOOKUP(A5, BListAcres!A:BO, 4, FALSE)VLOOKUP(A5, BListAcres!A:BO, 2, FALSE)VLOOKUP(A5, BListAcres!A:BO, 3, FALSE)VLOOKUP(A5, BListPlans!A:BO, 4, FALSE)VLOOKUP(A5, BListPlans!A:BO, 2, FALSE)Enter Formula in brackets for first row (10), then copy down column for all rows.
6
Black henbane
7
Bouncingbet
8
Bull thistle
9
Canada thistle
10
Chamomiles**
11
Chinese clematis
12
Common tansy
13
Common teasel
14
Cutleaf teasel
15
Dalmatian toadflax
16
Dames rocket
17
Diffuse knapweed
18
Eurasian watermilfoil
19
Hoary cress
20
Houndstongue
21
Jointed goatgrass
22
Leafy spurge
23
Moth mullein
24
Musk thistle
25
Oxeye daisy
26
Perennial pepperweed
27
Plumeless thistle
28
Russian knapweed
29
Russian olive
30
Salt cedar
31
Scotch thistle
32
Spotted knapweed
33
Sulfur cinquefoil
34
Wild caraway
35
Yellow nutsedge
36
Yellow toadflax
37
38
Loading...
 
 
 
Template
BListAcres
BListPlans
Adams(D4)
Arapahoe(F6)
Alamosa(E5)
Archuleta(G7)
Baca(H8)
Bent(I9)
Boulder(J10)
Broomfield(K11)
Chaffee(L12)
Cheyenne(M13)
Clear Creek(N14)
Conejos(O15)
Costilla(P16)
Crowley(Q17)
Custer(R18)
Delta(S19)
Denver(T20)
Dolores(U21)
Douglas(V22)
Eagle(W23)
Elbert(X24)
El Paso(Y25)
Fremont(Z26)
Garfield(AA27)
Gilpin(AB28)
Gunnison(AD30)
Hinsdale(AE31)
Huerfano(AF32)
Jackson(AG33)
Jefferson(AH34)
Kiowa(AI35)
Kit Carson(AJ36)
La Plata(AK37)
Grand(AC29)
Lake(AL38)
Larimer(AM39)
Las Animas(AN40)
Lincoln(AO41)
Logan(AP42)
Mesa(AQ43)
Mineral(AR44)
Moffat(AS45)
Montezuma(AT46)
Montrose(AU47)
Morgan(AV48)
Otero(AW49)
Ouray(AX50)
Park(AY51)
Phillips(AZ52)
Pitkin(BA53)
Prowers(BB54)
Pueblo(BC55)
Rio Blanco(BD56)
Rio Grande(BE57)
Routt(BF58)
Saguache(BG59)
San Juan(BH60)
San Miguel(BI61)
Sedgwick(BJ62)
Summit(BK63)
Teller(BL64)
Washington(BM65)
Weld(BN66)
Yuma(BO67)