Similarity Index calculator

Document Sample
Similarity Index calculator Powered By Docstoc
					Before beginning: Click here to go to ESIS (http://esis.sc.egov.usda.gov/); select the ESD reference
community to which the sampled site will be compared.
To enter reference community data: (1) Hit Ctrl+m and Ctrl+e to delete all existing sample data and
reference community data in workbook. (See "Summary" Worksheet for a description of all macros
used in this workbook.) (2) Hit Ctrl+u to unprotect "Similarity Index" Worksheet and all group
worksheets. (3) In "Similarity Index" Worksheet, enter ESD name, ESD ID, and Plant community name
for the reference community; save workbook with a new filename denoting the ESD and reference
community. (4) Copy all reference community production data from ESD (Fig. 1); paste in "ESD data"
Worksheet (place cursor on Cell A1 when pasting); hit Ctrl+r to reformat worksheet. (5) Starting with
"Group 1" Worksheet, enter group name and production values for group, plant type, and community
(total) from "ESD data" Worksheet (or copy and paste; use Paste Special, Values when pasting data in
this workbook to maintain formatting). (6) In "ESD data" Worksheet, copy the 4-column-wide block of
data for all species in Group 1 (Fig. 2); paste in "Group 1" Worksheet (place cursor on Cell E10 when
pasting). (7) Repeat for remaining groups (total community production is filled in automatically as
group name is entered). (8) Hit Ctrl+p to protect "Similarity Index" Worksheet and all group worksheets;
save file.
To calculate Similarity Index: (1) Enter sampled site information in blue cells in "Similarity Index"
Worksheet. (2) Enter reconstructed sample weight in blue cells in group worksheets. Add sampling date
and location information to filename and save. Similarity Index is automatically calculated and


The "Reconstructor" Worksheet converts sampled plant weight to reconstructed annual production; the
climate reconstruction factor adjusts for the difference between the conditions under which sampled
plant weight was produced and representative value (RV) conditions (climate factor <100% for low
production years; climate factor >100% for high-production years). Production conditions may differ
among plant groups in the same year. For example, a year with a dry spring and a wet summer may be
a low-production year for cool-season grasses and a high-production year for warm-season grasses.
The group worksheets calculate allowable production for RV conditions by species and group.

       Hover cursor over cells with red triangle in upper right corner to reveal comment.
 SD reference


  sample data and
ption of all macros
 nd all group
ant community name
SD and reference                                                 break in image
 paste in "ESD data"
        Starting with
ype, and community
 when pasting data in
         wide block of
or on Cell E10 when
 automatically as
  all group worksheets;


Similarity Index"         Fig. 1. Selected block of ESD data to be copied and pasted into "ESD data" Worksheet.

ets. Add sampling date
alculated and


annual production; the
nder which sampled
 or <100% for low-
 nditions may differ
a wet summer may be
     season grasses.
es and group.

veal comment.             Fig. 2. Block of data in "ESD data" Worksheet to be pasted into "Group 1" Worksheet.
Historic Climax Plant Community Plant Species Composition:
              Grass/Grasslike                                                                 Annual Production
                                                                                              in Pounds Per Acre
Group            Group Name   Common Name                Scientific Name
1 - Dominant Mid Grasses
                              cane bluestem              Bothriochloa barbinodis
                              sideoats grama             Bouteloua curtipendula
                              plains lovegrass           Eragrostis intermedia

2 - Dominant Short Grasses
                              sprucetop grama            Bouteloua chondrosioides
                              black grama                Bouteloua eriopoda
                              blue grama                 Bouteloua gracilis
                              hairy grama                Bouteloua hirsuta
                              slender grama              Bouteloua repens
                              common wolfstail           Lycurus phleoides

3 - Shortlived Grasses
                              Rothrock grama             Bouteloua rothrockii
                              curly mesquite             Hilaria belangeri
                              Arizona muhly              Muhlenbergia arizonica
                              sand dropseed              Sporobolus cryptandrus

4 - Subdominant Mid Grasses
                              Arizona cottontop          Digitaria californica
                              tanglehead                 Heteropogon contortus
                              bush muhly                 Muhlenbergia porteri
                              plains bristlegrass        Setaria vulpiseta

5 - Perennial Threeawns
                              Santa Rita threeawn        Aristida californica var. glabrata
                              poverty threeawn           Aristida divaricata
                              Havard's threeawn          Aristida havardii
                              Wooton's threeawn          Aristida pansa
                              purple threeawn            Aristida purpurea
                              red threeawn               Aristida purpurea var. longiseta
                              Parish threeawn            Aristida purpurea var. parishii
                              Wright's threeawn          Aristida purpurea var. wrightii
                              spidergrass                Aristida ternipes
                              mesa threeawn              Aristida ternipes var. gentilis

6 - Miscellaneous Grasses
                              purple grama               Bouteloua radicosa
                              red grama                  Bouteloua trifida
                              fluffgrass                 Dasyochloa pulchella
                              fall witchgrass            Digitaria cognata
                              bottlebrush squirreltail   Elymus elymoides
                              spike pappusgrass          Enneapogon desvauxii
                              green sprangletop          Leptochloa dubia
                              Hall panicgrass            Panicum hallii
                              vine mesquite              Panicum obtusum
                              Pima pappusgrass           Pappophorum vaginatum
                                 tobosa                     Pleuraphis mutica
                                 burrograss                 Scleropogon brevifolius
                                 spike dropseed             Sporobolus contractus
                                 slim tridens               Tridens muticus

7 - Annual Grasses
                                 sixweeks threeawn          Aristida adscensionis
                                 prairie threeawn           Aristida oligantha
                                 sixweeks needle grama      Bouteloua aristidoides
                                 sixweeks grama             Bouteloua barbata
                                 Parry's grama              Bouteloua parryi
                                 Arizona brome              Bromus arizonicus
                                 feather fingergrass        Chloris virgata
                                 tapertip cupgrass          Eriochloa acuminata var. acuminata
                                 Mexican lovegrass          Eragrostis mexicana
                                 tufted lovegrass           Eragrostis pectinacea
                                 desert lovegrass           Eragrostis pectinacea var. miserrima
                                 Mexican sprangletop        Leptochloa fusca ssp. uninervia
                                 mucronate sprangeltop      Leptochloa panicea ssp. brachiata
                                 delicate muhly             Muhlenbergia fragilis
                                 littleseed muhly           Muhlenbergia microsperma
                                 witchgrass                 Panicum capillare
                                 Mexican panicgrass         Panicum hirticaule
                                 Bigelow's bluegrass        Poa bigelovii
                                 Arizona signalgrass        Urochloa arizonica
                                 sixweeks fescue            Vulpia octoflora

                     Forb                                                                      Annual Production
                                                                                               in Pounds Per Acre
Group               Group Name   Common Name                Scientific Name
8 - Perennial Forbs
                                 desert-holly               Acourtia nana
                                 pink perezia               Acourtia wrightii
                                 San Felipe dogweed         Adenophyllum porophylloides
                                 trailing four o'clock      Allionia incarnata
                                 slimleaf bursage           Ambrosia confertiflora
                                 Anoda                      Anoda
                                 desert anemone             Anemone tuberosa
                                 rockcress                  Arabis
                                 New Mexico silverbush      Argythamnia neomexicana
                                 pioneer rockcress          Arabis platysperma
                                 bluestem pricklypoppy      Argemone pleiacantha
                                 Watson's dutchman's pipe   Aristolochia watsonii
                                 shrubby ayenia             Ayenia microphylla
                                 hairyseed bahia            Bahia absinthifolia
                                 desert marigold            Baileya multiradiata
                                 lyreleaf greeneyes         Berlandiera lyrata
                                 climbing wartclub          Boerhavia scandens
                                 Arizona carlowrightia      Carlowrightia arizonica
                                 Castilleja                 Castilleja
                                 rose heath                 Chaetopappa ericoides
                                 leatherweed                Croton pottsii
                   fingerleaf gourd             Cucurbita digitata
                   coyote melon                 Cucurbita palmata
                   Cooley's bundleflower        Desmanthus cooleyi
                   desert larkspur              Delphinium parishii
                   bluedicks                    Dichelostemma capitatum
                   dogbane dyssodia             Dyssodia papposa
                   spreading snakeherb          Dyschoriste schiedeana var. decumbens
                   spreading fleabane           Erigeron divergens
                   hairy evolvulus              Evolvulus arizonicus
                   Arizona snakecotton          Froelichia arizonica
                   Gaura                        Gaura
                   small matweed                Guilleminea densa
                   hogpotato                    Hoffmannseggia glauca
                   slender janusia              Janusia gracilis
                   ragged nettlespurge          Jatropha macrorhiza
                   Greene deervetch             Lotus greenei
                   Wright deervetch             Lotus wrightii
                   Gila manroot                 Marah gilensis
                   variableleaf bushbean        Macroptilium gibbosifolium
                   spiny tansyaster             Machaeranthera pinnatifida
                   desert tobacco               Nicotiana obtusifolia
                   tufted evening-primrose      Oenothera caespitosa
                   orange talinum               Phemeranthus aurantiacus
                   yerba de venado              Porophyllum gracile
                   velvetseed milkwort          Polygala obscura
                   spiny milkwort               Polygala subspinosa
                   shrubby purslane             Portulaca suffrutescens
                   Arizona cudweed              Pseudognaphalium arizonicum
                   Wright's cudweed             Pseudognaphalium canescens ssp. canescens
                   slimflower scurfpea          Psoralidium tenuiflorum
                   canaigre                     Rumex hymenosepalus
                   twinleaf senna               Senna bauhinioides
                   Leiberg stonecrop            Sedum leibergii
                   Lemmon's ragwort             Senecio lemmonii
                   New Mexico sida              Sida neomexicana
                   silverleaf nightshade        Solanum elaeagnifolium
                   desert globemallow           Sphaeralcea ambigua
                   gooseberryleaf globemallow   Sphaeralcea grossulariifolia
                   brownplume wirelettuce       Stephanomeria pauciflora
                   big talinum                  Talinum paniculatum
                   Coulter's wrinklefruit       Tetraclea coulteri
                   pricklyleaf dogweed          Thymophylla acerosa
                   branched noseburn            Tragia ramosa
                   American vetch               Vicia americana
                   Louisiana vetch              Vicia ludoviciana
                   copper zephyrlily            Zephyranthes longifolia
                   Texas zinnia                 Zinnia grandiflora

9 - Annual forbs
                   New Mexico copperleaf        Acalypha neomexicana
                   carelessweed                 Amaranthus palmeri
                   western fiddleneck           Amsinckia tessellata
bluestem pricklypoppy         Argemone pleiacantha
Astralagus                    Astragalus
wheelscale saltbush           Atriplex elegans
fewflower beggarticks         Bidens leptocephala
Coulter spiderling            Boerhavia coulteri
hairy bowlesia                Bowlesia incana
fringed redmaids              Calandrinia ciliata
Camissonia                    Camissonia
sego lily                     Calochortus nuttallii
common lambsquarters          Chenopodium album
sensitive partridge pea       Chamaecrista nictitans
New Mexico thistle            Cirsium neomexicanum
miner's lettuce               Claytonia perfoliata ssp. perfoliata
golden corydalis              Corydalis aurea
Cryptantha                    Cryptantha
American wild carrot          Daucus pusillus
Wright dalea                  Dalea wrightii
sacred datura                 Datura wrightii
western tansymustard          Descurainia pinnata
wedgeleaf draba               Draba cuneifolia
western wallflower            Erysimum capitatum
miniature woollystar          Eriastrum diffusum
sorrel buckwheat              Eriogonum polycladon
bull filaree                  Erodium texanum
Mexican gold poppy            Eschscholzia californica ssp. mexicana
Euphorbia                     Euphorbia
Arizona blanketflower         Gaillardia arizonica
star gilia                    Gilia stellata
Gooding mock verbena          Glandularia gooddingii
pearly globe amaranth         Gomphrena nitida
Arizona gumweed               Grindelia arizonica
longleaf false goldeneye      Heliomeris longifolia var. annua
camphorweed                   Heterotheca subaxillaris
crestrib morning-glory        Ipomoea costellata
redstar                       Ipomoea coccinea
Thurber's morning-glory       Ipomoea thurberi
orange caltrop                Kallstroemia grandiflora
warty caltrop                 Kallstroemia parviflora
Gordon bladderpod             Lesquerella gordonii
shaggyfruit pepperweed        Lepidium lasiocarpum
intermediate pepperweed       Lepidium virginicum var. medium
Lewis blue flax               Linum lewisii
foothill deervetch            Lotus humistratus
coastal bird's-foot trefoil   Lotus salsuginosus var. brevivexillus
Arizona lupine                Lupinus arizonicus
Mojave lupine                 Lupinus sparsiflorus
hollowleaf annual lupine      Lupinus succulentus
Fendler desert-dandelion      Malacothrix fendleri
slender tansyaster            Machaeranthera gracilis
Tahoka tansyaster             Machaeranthera tanacetifolia
whitestem stickleaf           Mentzelia albicaulis
patota                        Monolepis nuttalliana
                                Pectocarya                 Pectocarya
                                manybristle cinchweed      Pectis papposa
                                tepary bean                Phaseolus acutifolius
                                Phacelia                   Phacelia
                                Phlox                      Phlox
                                Physalis                   Physalis
                                lipstick plant             Plagiobothrys arizonicus
                                desert Indianwheat         Plantago ovata
                                woolly Indianwheat         Plantago patagonica
                                Portulaca                  Portulaca
                                straighttube devilsclaw    Proboscidea althaeifolia
                                annual devilsclaw          Proboscidea parviflora
                                desert-chicory             Rafinesquia neomexicana
                                chia                       Salvia columbariae
                                sawtooth sage              Salvia subincisa
                                prostrate sida             Sida abutifolia
                                sleepy catchfly            Silene antirrhina
                                woolly tidestromia         Tidestromia lanuginosa
                                golden crownbeard          Verbesina encelioides

                   Shrub/Vine                                                                   Annual Production
                                                                                                in Pounds Per Acre
Group             Group Name    Common Name                Scientific Name
10 - Dominant Half-shrubs
                                false mesquite             Calliandra eriophylla
                                shrubby buckwheat          Eriogonum wrightii
                                range ratany               Krameria erecta
                                spreading ratany           Krameria lanceolata
                                desert zinnia              Zinnia acerosa

11 - Increaser Half-shrubs
                                turpentine bush            Ericameria laricifolia
                                threadleaf snakeweed       Gutierrezia microcephala
                                broom snakeweed            Gutierrezia sarothrae
                                burroweed                  Isocoma tenuisecta

12 - Miscellaneous Shrubs
                                whitethorn acacia          Acacia constricta
                                whitethorn acacia          Acacia constricta var. paucispina
                                catclaw acacia             Acacia greggii var. greggii
                                fourwing saltbush          Atriplex canescens
                                yerba de pasmo baccharis   Baccharis pteronioides
                                desert hackberry           Celtis ehrenbergiana
                                knifeleaf condalia         Condalia spathulata
                                Mexican crucillo           Condalia warnockii
                                Kearney's snakewood        Condalia warnockii var. kearneyana
                                rayless brittlebush        Encelia frutescens
                                longleaf Mormon tea        Ephedra trifurca
                                tarbush                    Flourensia cernua
                                ocotillo                   Fouquieria splendens
                                Lycium                     Lycium
                                rough menodora             Menodora scabra
                                           wait-a-bit                          Mimosa aculeaticarpa var. biuncifera
                                           velvetpod mimosa                    Mimosa dysocarpa
                                           sacahuista                          Nolina microcarpa
                                           whitestem paperflower               Psilostrophe cooperi
                                           threadleaf groundsel                Senecio flaccidus
                                           graythorn                           Ziziphus obtusifolia

13 - Succulents
                                           Palmer agave                        Agave palmeri
                                           Coryphantha                         Coryphantha
                                           pencil cholla                       Cylindropuntia arbuscula
                                           jumping cholla                      Cylindropuntia fulgida
                                           candle cholla                       Cylindropuntia kleiniae
                                           Christmas cholla                    Cylindropuntia leptocaulis
                                           cane cholla                         Cylindropuntia spinosior
                                           staghorn cholla                     Cylindropuntia versicolor
                                           Echinocereus                        Echinocereus
                                           rainbow cactus                      Echinocereus pectinatus var. pectinatus
                                           spinystar cactus                    Escobaria vivipara
                                           fishhook barrel cactus              Ferocactus wislizeni
                                           Mammillaria                         Mammillaria
                                           Engelmann pricklypear               Opuntia engelmannii
                                           purple pricklypear                  Opuntia macrocentra var. macrocentra
                                           tulip pricklypear                   Opuntia phaeacantha
                                           Santa Rita pricklypear              Opuntia santa-rita
                                           banana yucca                        Yucca baccata
                                           soaptree yucca                      Yucca elata

                     Tree                                                                                           Annual Production
                                                                                                                    in Pounds Per Acre
Group               Group Name             Common Name                         Scientific Name
14 - Trees
                                           oneseed juniper                     Juniperus monosperma
                                           Mexican palo verde                  Parkinsonia aculeata
                                           blue palo verde                     Parkinsonia florida
                                           western honey mesquite              Prosopis glandulosa var. torreyana
                                           velvet mesquite                     Prosopis velutina

Annual Production by Plant Type:
                  Annual Production (lbs/AC)
Plant Type                           Low                Representative Value
Forb                                   20                                 45
Grass/Grasslike                       546                               850
Shrub/Vine                             53                               100
Tree                                    0                                  5



Total:                               619                               1000
Annual Production
in Pounds Per Acre
       Low           High
       300           500
        50           200
       200           500
        50           200

       150           300
       50            100
       50            100
       50            250
        0             50
        0             50
        0             50

       20            150
       10             50
       10             50
        0             25
        0             50

       10            150
        5             50
        0             40
        0             50
        5             50

       50            100
        0             15
        5             30
        0             10
        0             10
        0             25
        5             50
        0             25
        0             10
        5             50
        5             50

        6            50
        0            20
        0            10
        0             5
        1            20
        5            50
        0             5
        0            20
        0             5
        0            20
        0            20
       0           25
       0           10
       0            5
       0            5

       10          100
        1           50
        1           20
        1           50
        1           25
        0           10
        0            5
        0           50
        0           25
        0           15
        0           20
        0           20
        0           20
        0           25
        0            5
        0           10
        0           10
        0           50
        0            5
        0           20
        1           50

Annual Production
in Pounds Per Acre
       Low         High
        5           75
        0            5
        0            5
        0            2
        0            5
        1           25
        0            5
        0            5
        0            5
        0            5
        0            5
        0            5
        0            5
        0           10
        0            5
        0            5
        0            2
        0            2
        0            5
        0            1
        0            2
        0           10
0     2
0     2
0     5
0     1
1    20
0     5
0    10
1    20
1    10
0     5
0     5
0     5
0    10
0    10
0     5
0     5
1    10
0     5
0     5
1    20
0     1
0     5
0     5
0     5
0     5
0     2
0     2
0     5
0     5
0     1
0     2
0     5
0     5
0     5
0    10
0     5
1    20
0     2
1    20
0     2
0     5
0     5
0     2
0     5
0     5
0     1
1    10

15   150
 0     5
 1    20
 0     5
0    2
1   20
0   15
0    2
1   20
0    5
0   10
0    5
1    2
1   20
1   50
1   15
0    5
0   10
0    5
1    5
0    5
0    5
1   20
0    5
0    2
0    5
1   10
0    5
0   15
0    5
0    5
0    5
0    5
0    5
0    5
1   50
0   25
1   20
0    2
0    5
0   25
0    2
0    5
0   15
0    5
0    5
0   15
0   15
0    5
0    5
0   20
0    2
1   25
1   25
0    5
0    5
       0            5
       0           10
       0           10
       0            5
       0            5
       0            5
       1           25
       1           20
       1           25
       0           10
       0            5
       0            5
       0            5
       0            2
       1            5
       1           15
       0            5
       0           10
       0            5

Annual Production
in Pounds Per Acre
       Low         High
        50         100
        20         100
        10          50
        20          50
         0          50
         0          50

       1           40
       0           10
       0           20
       1           30
       0           30

       0           20
       0            2
       0            5
       0            5
       0           10
       0            2
       0           10
       0            5
       0            2
       0            2
       0            1
       0            2
       0            2
       0            2
       0            2
       0            5
       0            5
       0            2
       0            5
       0            1
       0            1
       0            2

       2           50
       0            5
       0            5
       0            2
       0            5
       0            2
       0            5
       0            5
       0            5
       0            5
       0            1
       0            1
       1            5
       0            5
       1            5
       0            5
       0            5
       0            2
       0            5
       0            5

Annual Production
in Pounds Per Acre
       Low         High
        0           15
        0            2
        0            2
        0            2
        0            5
        0            5
          Ctrl+u unprotects "Similarity    Ctrl+p protects "Similarity      Ctrl+r reformats ESD reference
Macros    Index" Worksheet and all         Index" Worksheet and all         community data in "ESD data"
          group worksheets.                group worksheets.                Worksheet.


         Number of species in community = 257                                Production in ESD
                                                                                 reference
                All species in ESD reference community
                                                                                community
Group              Common name                     Scientific name          low # high # RV#
    12   whitethorn acacia               Acacia constricta                      0       2     1
    12   whitethorn acacia               Acacia constricta var. paucispina      0       5     1
    12   catclaw acacia                  Acacia greggii var. greggii            0       5     1
     9   New Mexico copperleaf           Acalypha neomexicana                   0       5     1
     8   dwarf desertpeony               Acourtia nana                          0       5     1
     8   brownfoot                       Acourtia wrightii                      0       5     1
     8   San Felipe dogweed              Adenophyllum porophylloides            0       2     0
    13   Palmer's century plant          Agave palmeri                          0       5     3
     8   trailing windmills              Allionia incarnata                     0       5     1
     9   carelessweed                    Amaranthus palmeri                     1      20     3
     8   weakleaf bur ragweed            Ambrosia confertiflora                 1      25     4
     9   bristly fiddleneck              Amsinckia tessellata                   0       5     1
     8   tuber anemone                   Anemone tuberosa                       0       5     1
     8   anoda                           Anoda                                  0       5     1
     8   rockcress                       Arabis                                 0       5     1
     8   pioneer rockcress               Arabis platysperma                     0       5     1
     8   southwestern pricklypoppy       Argemone pleiacantha                   0       5     1
     9   southwestern pricklypoppy       Argemone pleiacantha                   0       2     0
     8   New Mexico silverbush           Argythamnia neomexicana                0       5     1
     7   sixweeks threeawn               Aristida adscensionis                  1      50    20
     5   Santa Rita threeawn             Aristida californica var. glabrata     0      15     6
     5   poverty threeawn                Aristida divaricata                    5      30    14
     5   Havard's threeawn               Aristida havardii                      0      10     4
     7   prairie threeawn                Aristida oligantha                     1      20     8
     5   Wooton's threeawn               Aristida pansa                         0      10     4
     5   purple threeawn                 Aristida purpurea                      0      25     9
     5   Fendler threeawn                Aristida purpurea var. longiseta       5      50    22
     5   Parish's threeawn               Aristida purpurea var. parishii        0      25     9
     5   Wright's threeawn               Aristida purpurea var. wrightii        0      10     4
     5   spidergrass                     Aristida ternipes                      5      50    22
     5   spidergrass                     Aristida ternipes var. gentilis        5      50    22
     8   Watson's dutchman's pipe        Aristolochia watsonii                  0       5     1
     9   milkvetch                       Astragalus                             1      20     3
    12   fourwing saltbush               Atriplex canescens                     0      10     3
     9   wheelscale saltbush             Atriplex elegans                       0      15     2
     8   dense ayenia                    Ayenia microphylla                     0      10     1
    12   yerba de pasmo                  Baccharis pteronioides                 0       2     1
     8   hairyseed bahia                 Bahia absinthifolia                    0       5     1
     8   desert marigold                 Baileya multiradiata                   0       5     1
     8   lyreleaf greeneyes              Berlandiera lyrata                     0       2     0
     9   fewflower beggarticks           Bidens leptocephala                    0       2     0
     9   Coulter's spiderling            Boerhavia coulteri                     1      20     3
 8   climbing wartclub         Boerhavia scandens                     0     2     0
 1   cane bluestem             Bothriochloa barbinodis               50   200   107
 7   needle grama              Bouteloua aristidoides                 1    50    20
 7   sixweeks grama            Bouteloua barbata                      1    25    10
 2   sprucetop grama           Bouteloua chondrosioides              50   100    69
 1   sideoats grama            Bouteloua curtipendula               200   500   313
 2   black grama               Bouteloua eriopoda                    50   100    69
 2   blue grama                Bouteloua gracilis                    50   250   126
 2   hairy grama               Bouteloua hirsuta                      0    50    19
 7   Parry's grama             Bouteloua parryi                       0    10     4
 6   purple grama              Bouteloua radicosa                     0    20     8
 2   slender grama             Bouteloua repens                       0    50    19
 3   Rothrock's grama          Bouteloua rothrockii                  10    50    25
 6   red grama                 Bouteloua trifida                      0    10     4
 9   hoary bowlesia            Bowlesia incana                        0     5     1
 7   Arizona brome             Bromus arizonicus                      0     5     2
 9   fringed redmaids          Calandrinia ciliata                    0    10     1
10   fairyduster               Calliandra eriophylla                 20   100    44
 9   sego lily                 Calochortus nuttallii                  1     2     1
 9   suncup                    Camissonia                             0     5     1
 8   Arizona wrightwort        Carlowrightia arizonica                0     5     1
 8   Indian paintbrush         Castilleja                             0     1     0
12   spiny hackberry           Celtis ehrenbergiana                   0    10     3
 8   rose heath                Chaetopappa ericoides                  0     2     0
 9   sensitive partridge pea   Chamaecrista nictitans                 1    50     7
 9   lambsquarters             Chenopodium album                      1    20     3
 7   feather fingergrass       Chloris virgata                        0    50    19
 9   New Mexico thistle        Cirsium neomexicanum                   1    15     3
 9   miner's lettuce           Claytonia perfoliata ssp. perfoliata   0     5     1
12   knifeleaf condalia        Condalia spathulata                    0     5     1
12   Warnock's snakewood       Condalia warnockii                     0     2     1
12   Kearney's snakewood       Condalia warnockii var. kearneyana 0         2     1
 9   scrambled eggs            Corydalis aurea                        0    10     1
13   beehive cactus            Coryphantha                            0     5     3
 8   leatherweed               Croton pottsii                         0    10     1
 9   cryptantha                Cryptantha                             0     5     1
 8   fingerleaf gourd          Cucurbita digitata                     0     2     0
 8   coyote gourd              Cucurbita palmata                      0     2     0
13   Arizona pencil cholla     Cylindropuntia arbuscula               0     2     1
13   jumping cholla            Cylindropuntia fulgida                 0     5     3
13   candle cholla             Cylindropuntia kleiniae                0     2     1
13   Christmas cactus          Cylindropuntia leptocaulis             0     5     3
13   walkingstick cactus       Cylindropuntia spinosior               0     5     3
13   staghorn cholla           Cylindropuntia versicolor              0     5     3
 9   Wright's prairie clover   Dalea wrightii                         0     5     1
 6   low woollygrass           Dasyochloa pulchella                   0     5     2
 9   sacred thorn-apple        Datura wrightii                        0     5     1
 9   American wild carrot      Daucus pusillus                        1     5     1
 8   desert larkspur           Delphinium parishii                    0     1     0
 9   western tansymustard      Descurainia pinnata                    1    20     3
 8   Cooley's bundleflower     Desmanthus cooleyi                     0     5     1
 8   bluedicks                 Dichelostemma capitatum                1    20     3
 4   Arizona cottontop           Digitaria californica                5   50    22
 6   fall witchgrass             Digitaria cognata                    1   20     8
 9   wedgeleaf draba             Draba cuneifolia                     0    5     1
 8   spreading snakeherb                                              0
                                 Dyschoriste schiedeana var. decumbens 10        1
 8   fetid marigold              Dyssodia papposa                     0    5     1
13   hedgehog cactus             Echinocereus                         0    5     3
13   rainbow cactus                                                   0
                                 Echinocereus pectinatus var. pectinatus   1     1
 6   squirreltail                Elymus elymoides                     5   50    22
12   button brittlebush          Encelia frutescens                   0    1     0
 6   nineawn pappusgrass         Enneapogon desvauxii                 0    5     2
12   longleaf jointfir           Ephedra trifurca                     0    2     1
 1   plains lovegrass            Eragrostis intermedia               50  200   107
 7   Mexican lovegrass           Eragrostis mexicana                  0   15     6
 7   tufted lovegrass            Eragrostis pectinacea                0   20     8
 7   desert lovegrass            Eragrostis pectinacea var. miserrima 0   20     8
 9   miniature woollystar        Eriastrum diffusum                   0    5     1
11   turpentine bush             Ericameria laricifolia               0   10     3
 8   spreading fleabane          Erigeron divergens                   1   20     3
 7   tapertip cupgrass           Eriochloa acuminata var. acuminata 0     25     9
 9   sorrel buckwheat            Eriogonum polycladon                 1   10     2
10   bastardsage                 Eriogonum wrightii                  10   50    22
 9   Texas stork's bill          Erodium texanum                      0    5     1
 9   sanddune wallflower         Erysimum capitatum                   0    2     0
 9   California poppy                                                 0
                                 Eschscholzia californica ssp. mexicana   15     2
13   spinystar                   Escobaria vivipara                   0    1     1
 9   spurge                      Euphorbia                            0    5     1
 8   wild dwarf morning-glory    Evolvulus arizonicus                 1   10     2
13   candy barrelcactus          Ferocactus wislizeni                 1    5     3
12   American tarwort            Flourensia cernua                    0    2     1
12   ocotillo                    Fouquieria splendens                 0    2     1
 8   Arizona snakecotton         Froelichia arizonica                 0    5     1
 9   Arizona blanketflower       Gaillardia arizonica                 0    5     1
 8   beeblossom                  Gaura                                0    5     1
 9   star gilia                  Gilia stellata                       0    5     1
 9   southwestern mock vervain   Glandularia gooddingii               0    5     1
 9   pearly globe amaranth       Gomphrena nitida                     0    5     1
 9   Arizona gumweed             Grindelia arizonica                  0    5     1
 8   small matweed               Guilleminea densa                    0    5     1
11   threadleaf snakeweed        Gutierrezia microcephala             0   20     6
11   broom snakeweed             Gutierrezia sarothrae                1   30    10
 9   longleaf false goldeneye    Heliomeris longifolia var. annua     1   50     7
 4   tanglehead                  Heteropogon contortus                0   40    15
 9   camphorweed                 Heterotheca subaxillaris             0   25     3
 3   curly-mesquite              Hilaria belangeri                   10   50    25
 8   Indian rushpea              Hoffmannseggia glauca                0   10     1
 9   redstar                     Ipomoea coccinea                     0    2     0
 9   crestrib morning-glory      Ipomoea costellata                   1   20     3
 9   Thurber's morning-glory     Ipomoea thurberi                     0    5     1
11   burroweed                   Isocoma tenuisecta                   0   30     9
 8   slender janusia             Janusia gracilis                     0   10     1
 8   ragged nettlespurge         Jatropha macrorhiza                  0    5     1
14   oneseed juniper             Juniperus monosperma                 0    2     1
 9   Arizona poppy                  Kallstroemia grandiflora              0   25    3
 9   warty caltrop                  Kallstroemia parviflora               0    2    0
10   littleleaf ratany              Krameria erecta                      20   50   29
10   trailing krameria              Krameria lanceolata                   0   50   15
 9   shaggyfruit pepperweed         Lepidium lasiocarpum                  0   15    2
 9   intermediate pepperweed        Lepidium virginicum var. medium       0    5    1
 6   green sprangletop              Leptochloa dubia                      0   20    8
 7   Mexican sprangletop            Leptochloa fusca ssp. uninervia       0   20    8
 7   mucronate sprangeltop          Leptochloa panicea ssp. brachiata 0       25    9
 9   Gordon's bladderpod            Lesquerella gordonii                  0    5    1
 9   Lewis flax                     Linum lewisii                         0    5    1
 8   Greene's bird's-foot trefoil   Lotus greenei                         0    5    1
 9   foothill deervetch             Lotus humistratus                     0   15    2
 9   coastal bird's-foot trefoil    Lotus salsuginosus var. brevivexillus 0   15    2
 8   Wright's deervetch             Lotus wrightii                        1   10    2
 9   Arizona lupine                 Lupinus arizonicus                    0    5    1
 9   Coulter's lupine               Lupinus sparsiflorus                  0    5    1
 9   hollowleaf annual lupine       Lupinus succulentus                   0   20    2
12   desert-thorn                   Lycium                                0    2    1
 2   common wolfstail               Lycurus phleoides                     0   50   19
 9   slender goldenweed             Machaeranthera gracilis               1   25    4
 8   lacy tansyaster                Machaeranthera pinnatifida            1   20    3
 9   tanseyleaf tansyaster          Machaeranthera tanacetifolia          1   25    4
 8   variableleaf bushbean          Macroptilium gibbosifolium            0    5    1
 9   Fendler's desertdandelion      Malacothrix fendleri                  0    2    0
13   globe cactus                   Mammillaria                           0    5    3
 8   Gila manroot                   Marah gilensis                        0    5    1
12   rough menodora                 Menodora scabra                       0    5    1
 9   whitestem blazingstar          Mentzelia albicaulis                  0    5    1
12   catclaw mimosa                 Mimosa aculeaticarpa var. biuncifera 0     5    1
12   velvetpod mimosa               Mimosa dysocarpa                      0    2    1
 9   Nuttall's povertyweed          Monolepis nuttalliana                 0    5    1
 3   Arizona muhly                  Muhlenbergia arizonica                0   25    9
 7   delicate muhly                 Muhlenbergia fragilis                 0    5    2
 7   littleseed muhly               Muhlenbergia microsperma              0   10    4
 4   bush muhly                     Muhlenbergia porteri                  0   50   19
 8   desert tobacco                 Nicotiana obtusifolia                 0    1    0
12   sacahuista                     Nolina microcarpa                     0    5    1
 8   tufted evening primrose        Oenothera caespitosa                  0    5    1
13   cactus apple                   Opuntia engelmannii                   1    5    3
13   purple pricklypear             Opuntia macrocentra var. macrocentra  0    5    3
13   tulip pricklypear              Opuntia phaeacantha                   0    5    3
13   Santa Rita pricklypear         Opuntia santa-rita                    0    2    1
 7   witchgrass                     Panicum capillare                     0   10    4
 6   Hall's panicgrass              Panicum hallii                        0    5    2
 7   Mexican panicgrass             Panicum hirticaule                    0   50   19
 6   vine mesquite                  Panicum obtusum                       0   20    8
 6   whiplash pappusgrass           Pappophorum vaginatum                 0   20    8
14   Jerusalem thorn                Parkinsonia aculeata                  0    2    1
14   blue paloverde                 Parkinsonia florida                   0    2    1
 9   manybristle chinchweed         Pectis papposa                        0   10    1
 9   combseed                       Pectocarya                            0    5    1
 9   phacelia                     Phacelia                           0   5     1
 9   tepary bean                  Phaseolus acutifolius              0  10     1
 8   orange fameflower            Phemeranthus aurantiacus           0   5     1
 9   phlox                        Phlox                              0   5     1
 9   groundcherry                 Physalis                           0   5     1
 9   Arizona popcornflower        Plagiobothrys arizonicus           1  25     4
 9   desert Indianwheat           Plantago ovata                     1  20     3
 9   woolly plantain              Plantago patagonica                1  25     4
 6   tobosagrass                  Pleuraphis mutica                  0  25     9
 7   Bigelow's bluegrass          Poa bigelovii                      0   5     2
 8   velvetseed milkwort          Polygala obscura                   0   5     1
 8   spiny milkwort               Polygala subspinosa                0   2     0
 8   slender poreleaf             Porophyllum gracile                0   5     1
 9   purslane                     Portulaca                          0  10     1
 8   shrubby purslane             Portulaca suffrutescens            0   2     0
 9   desert unicorn-plant         Proboscidea althaeifolia           0   5     1
 9   doubleclaw                   Proboscidea parviflora             0   5     1
14   western honey mesquite       Prosopis glandulosa var. torreyana 0   5     2
14   velvet mesquite              Prosopis velutina                  0   5     2
 8   Arizona cudweed              Pseudognaphalium arizonicum        0   5     1
 8   Wright's cudweed                                                0   5
                                  Pseudognaphalium canescens ssp. canescens    1
12   whitestem paperflower        Psilostrophe cooperi               0   1     0
 8   slimflower scurfpea          Psoralidium tenuiflorum            0   1     0
 9   New Mexico plumeseed         Rafinesquia neomexicana            0   5     1
 8   canaigre dock                Rumex hymenosepalus                0   2     0
 9   chia                         Salvia columbariae                 0   2     0
 9   sawtooth sage                Salvia subincisa                   1   5     1
 6   burrograss                   Scleropogon brevifolius            0  10     4
 8   Leiberg stonecrop            Sedum leibergii                    0   5     1
12   threadleaf ragwort           Senecio flaccidus                  0   1     0
 8   Lemmon's ragwort             Senecio lemmonii                   0   5     1
 8   twinleaf senna               Senna bauhinioides                 0   5     1
 4   plains bristlegrass          Setaria vulpiseta                  5  50    22
 9   spreading fanpetals          Sida abutifolia                    1  15     3
 8   New Mexico fanpetals         Sida neomexicana                   0  10     1
 9   sleepy silene                Silene antirrhina                  0   5     1
 8   silverleaf nightshade        Solanum elaeagnifolium             0   5     1
 8   desert globemallow           Sphaeralcea ambigua                1  20     3
 8   gooseberryleaf globemallow   Sphaeralcea grossulariifolia       0   2     0
 6   spike dropseed               Sporobolus contractus              0   5     2
 3   sand dropseed                Sporobolus cryptandrus             0  50    19
 8   brownplume wirelettuce       Stephanomeria pauciflora           1  20     3
 8   jewels of Opar               Talinum paniculatum                0   2     0
 8   Coulter's wrinklefruit       Tetraclea coulteri                 0   5     1
 8   pricklyleaf dogweed          Thymophylla acerosa                0   5     1
 9   woolly tidestromia           Tidestromia lanuginosa             0  10     1
 8   branched noseburn            Tragia ramosa                      0   2     0
 6   slim tridens                 Tridens muticus                    0   5     2
 7   Arizona signalgrass          Urochloa arizonica                 0  20     8
 9   golden crownbeard            Verbesina encelioides              0   5     1
 8   American vetch               Vicia americana                    0   5     1
 8   Louisiana vetch              Vicia ludoviciana                  0   5     1
 7   sixweeks fescue         Vulpia octoflora          1   50   20
13   banana yucca            Yucca baccata             0    5    3
13   soaptree yucca          Yucca elata               0    5    3
 8   copper zephyrlily       Zephyranthes longifolia   0    1    0
10   desert zinnia           Zinnia acerosa            0   50   15
 8   Rocky Mountain zinnia   Zinnia grandiflora        1   10    2
12   lotebush                Ziziphus obtusifolia      0    2    1
reformats ESD reference      Ctrl+i consolidates ESD reference        Ctrl+m deletes ALL
unity data in "ESD data"     community and sample data from group     sample data in this
heet.                        worksheets and displays them below.      workbook.


                                  Totals from columns below                                  Number of sampled species =
                       2060          814           734          1010         100
                                                                                                             Sampled species
              Reconstructed Allowable in Allowable in              NRI
              sample weight    group        community    # Allowable % Allowable     Group
                          0                                         0          0         9
                          0                                         0          0         8
                          0                                         0          0         8
                          0                                         0          0         8
                          0                                         0          0         7
                          0                                         0          0         5
                          0                                         0          0         7
                          0                                         2          0         5
                          0                                         0          0         5
                         34             3             3             1          0         5
                         34             4             3             1          0        12
                          0                                         0          0         1
             trace                                                  0          0         7
                          0                                         0          0         7
             trace                                                  0          0         2
                          0                                         0          0         1
                          0                                         0          0         2
                          0                                         0          0         2
                          0                                         0          0         2
                         14           14              8             5          0         6
                          0                                         3          0         2
                         50           14            14              9          1         3
                          0                                         2          0        10
                          5             5             3             2          0         9
             trace                                                  2          0         7
                          0                                         6          1         9
                         57           22            22             13          1        13
                         22             9             9             6          1        13
                          0                                         2          0         9
                          0                                        13          1         4
                          0                                        13          1         6
                          0                                         0          0         6
                          0                                         1          0        12
                         18             3             3             1          0         1
                          0                                         1          0         8
                          0                                         0          0        10
                          0                                         0          0         9
                          0                                         0          0         8
                          0                                         0          0        13
                          0                                         0          0        11
                          0                                         0          0        11
                          0                                         1          0         9
          0                 0    0    3
        300   107   107    76    8   11
         89    20    11     5    0   14
         44    10     6     2    0   10
          8     8     8    44    4    7
        125   125   125   223   22    8
         12    12    12    44    4    9
         30    30    30    81    8    2
         25    19    19    12    1    3
          0                 1    0    4
trace                       2    0   12
         4     4     4     12    1   13
         4     4     4     22    2    6
         0                  1    0    9
         0                  0    0    6
         0                  0    0   14
         0                  0    0    4
        35    35    27     23    2    8
         0                  0    0    6
         0                  0    0    3
         0                  0    0    8
         0                  0    0    6
         0                  1    0    7
         0                  0    0   13
         0                  2    0   13
         8     3     3      1    0   10
trace                       4    0    8
         0                  1    0
         0                  0    0
         0                  0    0
         0                  0    0
         0                  0    0
         1     1     1      0    0
         0                  2    0
         0                  0    0
         0                  0    0
         0                  0    0
         0                  0    0
         0                  1    0
         2     2     2      2    0
         0                  1    0
trace                       2    0
         0                  2    0
         0                  2    0
         0                  0    0
         0                  0    0
         0                  0    0
         0                  0    0
         0                  0    0
         1     1     1      1    0
         0                  0    0
         0                  1    0
  2    2     2    18   2
  5    5     2     2   0
  0                0   0
  0                0   0
  0                0   0
  0                2   0
  0                0   0
 44   22    11     6   1
  0                0   0
  0                0   0
  5     1     1    0   0
400   107   107   76   8
  0                1   0
  0                2   0
  0                2   0
  0                0   0
  0                1   0
 34    3     3     1   0
  0                2   0
  0                1   0
 68   22    17    11   1
  0                0   0
  0                0   0
  1    1     1     1   0
  0                0   0
  0                0   0
  1    1     1     0   0
  9    3     3     2   0
  0                0   0
  0                0   0
  0                0   0
  0                0   0
  0                0   0
  0                0   0
  0                0   0
  0                0   0
  0                0   0
  0                0   0
  4    4     3     3   0
 15   10     8     4   0
  4    4     4     2   0
  0               12   1
  0                1   0
127   25    25    22   2
  0                0   0
  0                0   0
  0                1   0
  0                0   0
  2    2     2     4   0
  0                0   0
  0                0   0
  5    1     1     1   0
         0              1   0
         0              0   0
        24   24   19   15   1
         0              8   1
         0              1   0
         0              0   0
         0              2   0
         0              2   0
        35   9    5     2   0
         0              0   0
         0              0   0
         0              0   0
         0              1   0
         0              1   0
         5   2    2     0   0
         0              0   0
         0              0   0
        34   2    2     1   0
         0              0   0
trace                  12   1
         0              1   0
         0              1   0
         0              1   0
         0              0   0
         0              0   0
         0              2   0
         0              0   0
         0              0   0
         0              0   0
         0              0   0
         0              0   0
         0              0   0
        12   9    9     8   1
         0              0   0
         0              1   0
trace                  15   2
         0              0   0
         8   1    1     0   0
         0              0   0
         4   3    3     2   0
         0              2   0
         0              2   0
         0              1   0
         0              1   0
         0              0   0
         0              4   0
        56   8    4     2   0
         0              2   0
         0              1   0
         0              1   0
         0              0   0
         0              0   0
         0              0   0
         0              0   0
         0              0   0
         0              0   0
         0              0   0
         0              1   0
        15   3    3     1   0
         0              1   0
        15   9    5     2   0
         0              0   0
         0              0   0
         0              0   0
         0              0   0
         0              0   0
         0              0   0
         0              0   0
         0              0   0
         9   2    2     2   0
         0              2   0
         0              0   0
         0              0   0
         0              0   0
         0              0   0
         0              0   0
         0              0   0
         0              0   0
         0              0   0
         0              1   0
         0              0   0
         0              0   0
         0              0   0
         0              0   0
        59   22   22   18   2
         0              1   0
         0              0   0
         0              0   0
         0              0   0
        21   3    3     1   0
         0              0   0
         9    2    1    0   0
        34   19   19   17   2
trace                   1   0
        0               0   0
        0               0   0
        0               0   0
        0               0   0
        0               0   0
trace                   0   0
        0               2   0
        0               0   0
        0               0   0
        0               0   0
45   20   11   5   0
 1    1    1   2   0
 2    2    2   2   0
 0             0   0
 2   2    2    8   1
22   2    2    0   0
 0             0   0
                                 Ctrl+h unhides auxiliary reconstructor in
 Ctrl+e deletes ALL ESD
                                 "Reconstructor" Worksheet for cases where 2
 reference community data in
                                 different plot sizes were used to sample the
 this workbook.
                                 same community.

    Number of sampled species = 69                                 Production in ESD                     Totals from colum
                                                                       reference                 2060
                     Sampled species
                                                                      community         Reconstructed
          Common name                    Scientific name          low # high # RV#       sample weight
carelessweed                   Amaranthus palmeri                     1      20     3               34
weakleaf bur ragweed           Ambrosia confertiflora                 1      25     4               34
tuber anemone                  Anemone tuberosa                       0       5     1   trace
rockcress                      Arabis                                 0       5     1   trace
sixweeks threeawn              Aristida adscensionis                  1      50    20               14
poverty threeawn               Aristida divaricata                    5      30    14               50
prairie threeawn               Aristida oligantha                     1      20     8                5
Wooton's threeawn              Aristida pansa                         0      10     4   trace
Fendler threeawn               Aristida purpurea var. longiseta       5      50    22               57
Parish's threeawn              Aristida purpurea var. parishii        0      25     9               22
fourwing saltbush              Atriplex canescens                     0      10     3               18
cane bluestem                  Bothriochloa barbinodis               50    200    107             300
needle grama                   Bouteloua aristidoides                 1      50    20               89
sixweeks grama                 Bouteloua barbata                      1      25    10               44
sprucetop grama                Bouteloua chondrosioides              50    100     69                8
sideoats grama                 Bouteloua curtipendula               200    500    313             125
black grama                    Bouteloua eriopoda                    50    100     69               12
blue grama                     Bouteloua gracilis                    50    250    126               30
hairy grama                    Bouteloua hirsuta                      0      50    19               25
purple grama                   Bouteloua radicosa                     0      20     8   trace
slender grama                  Bouteloua repens                       0      50    19                4
Rothrock's grama               Bouteloua rothrockii                  10      50    25                4
fairyduster                    Calliandra eriophylla                 20    100     44               35
lambsquarters                  Chenopodium album                      1      20     3                8
feather fingergrass            Chloris virgata                        0      50    19   trace
scrambled eggs                 Corydalis aurea                        0      10     1                1
jumping cholla                 Cylindropuntia fulgida                 0       5     3                2
Christmas cactus               Cylindropuntia leptocaulis             0       5     3   trace
western tansymustard           Descurainia pinnata                    1      20     3                1
Arizona cottontop              Digitaria californica                  5      50    22                2
fall witchgrass                Digitaria cognata                      1      20     8                5
squirreltail                   Elymus elymoides                       5      50    22               44
longleaf jointfir              Ephedra trifurca                       0       2     1                5
plains lovegrass               Eragrostis intermedia                 50    200    107             400
spreading fleabane             Erigeron divergens                     1      20     3               34
bastardsage                    Eriogonum wrightii                    10      50    22               68
California poppy               Eschscholzia californica ssp. mexicana 0      15     2                1
wild dwarf morning-glory       Evolvulus arizonicus                   1      10     2                1
candy barrelcactus             Ferocactus wislizeni                   1       5     3                9
threadleaf snakeweed           Gutierrezia microcephala               0      20     6                4
broom snakeweed                Gutierrezia sarothrae                  1      30    10               15
longleaf false goldeneye       Heliomeris longifolia var. annua       1      50     7                4
curly-mesquite             Hilaria belangeri                    10   50   25           127
burroweed                  Isocoma tenuisecta                    0   30    9             2
oneseed juniper            Juniperus monosperma                  0    2    1             5
littleleaf ratany          Krameria erecta                      20   50   29            24
mucronate sprangeltop      Leptochloa panicea ssp. brachiata     0   25    9            35
Wright's deervetch         Lotus wrightii                        1   10    2             5
hollowleaf annual lupine   Lupinus succulentus                   0   20    2            34
common wolfstail           Lycurus phleoides                     0   50   19   trace
Arizona muhly              Muhlenbergia arizonica                0   25    9           12
bush muhly                 Muhlenbergia porteri                  0   50   19   trace
sacahuista                 Nolina microcarpa                     0    5    1            8
cactus apple               Opuntia engelmannii                   1    5    3            4
vine mesquite              Panicum obtusum                       0   20    8           56
desert Indianwheat         Plantago ovata                        1   20    3           15
tobosagrass                Pleuraphis mutica                     0   25    9           15
western honey mesquite     Prosopis glandulosa var. torreyana    0    5    2            9
plains bristlegrass        Setaria vulpiseta                     5   50   22           59
desert globemallow         Sphaeralcea ambigua                   1   20    3           21
spike dropseed             Sporobolus contractus                 0    5    2            9
sand dropseed              Sporobolus cryptandrus                0   50   19           34
brownplume wirelettuce     Stephanomeria pauciflora              1   20    3   trace
slim tridens               Tridens muticus                       0    5    2   trace
sixweeks fescue            Vulpia octoflora                      1   50   20           45
banana yucca               Yucca baccata                         0    5    3            1
soaptree yucca             Yucca elata                           0    5    3            2
desert zinnia              Zinnia acerosa                        0   50   15            2
Rocky Mountain zinnia      Zinnia grandiflora                    1   10    2           22
     Totals from columns below
         814          734        866          86
Allowable in Allowable in          NRI
    group      community # Allowable % Allowable
            3           3          1           0
            4           3          1           0
                                   0           0
                                   0           0
          14            8          5           0
          14           14          9           1
            5           3          2           0
                                   2           0
          22           22         13           1
            9           9          6           1
            3           3          1           0
         107          107         76           8
          20           11          5           0
          10            6          2           0
            8           8         44           4
         125          125        223          22
          12           12         44           4
          30           30         81           8
          19           19         12           1
                                   2           0
            4           4         12           1
            4           4         22           2
          35           27         23           2
            3           3          1           0
                                   4           0
            1           1          0           0
            2           2          2           0
                                   2           0
            1           1          1           0
            2           2         18           2
            5           2          2           0
          22           11          6           1
            1           1          0           0
         107          107         76           8
            3           3          1           0
          22           17         11           1
            1           1          1           0
            1           1          0           0
            3           3          2           0
            4           3          3           0
          10            8          4           0
            4           4          2           0
25   25   22   2
 2    2    4   0
 1    1    1   0
24   19   15   1
 9    5    2   0
 2    2    0   0
 2    2    1   0
          12   1
9    9     8   1
          15   2
 1    1    0   0
 3    3    2   0
 8    4    2   0
 3    3    1   0
 9    5    2   0
 2    2    2   0
22   22   18   2
 3    3    1   0
 2    1    0   0
19   19   17   2
           1   0
           0   0
20   11    5   0
 1    1    2   0
 2    2    2   0
 2    2    8   1
 2    2    0   0
Hover cursor over cells with red triangle in upper right corner to reveal
comment, starting with this one.
  Cover (%)                       Average   Plot 1   Plot 2   Plot 3   Plot 4   Plot 5   Plot 6   Plot 7   Plot 8   Plot 9 Plot 10   Enter number of
                                                                                                                                     sampled plots in
  canopy                               6      10        5       5     0   10
                                                                                                                                     blue cell below.
  litter                              33      30       10      25    40   60
  rock                                54      55       85      45    55   30
  bare ground                          7       5        0      25     5    0
  Total                              100     100      100     100 100 100                                                                 5
                                  Weight                      Estimated number of weight units                                          Double-sampled plots
             Species               unit     Plot 1   Plot 2   Plot 3   Plot 4   Plot 5   Plot 6   Plot 7   Plot 8   Plot 9 Plot 10 Estimated   Clipped

standing dead (all species)          1        2        4                 8        4                                                    8        10
Hairy Grama (BOHI2)                  1        9        9      4.5        6       15                                                    15        8
Blue grama (BOGR2)                   1                                           25                                                    25       30
Threeawn species (ARIST)             1       40                          5       10                                                    10       10
Sideoats grama (BOCU)                1                10                          5                                                    5         8
Mat muhly (MURI)                     1                15       25       10
Black grama (BOER4)                  1                                           60
New Mexico feathergrass (HENE5)      1       50       40       55       40       40                                                    40       70
Wolftail (common) (LYPH)             1        5                                  30                                                    30       24
Sand dropseed (SPCR)                 1                 5       10       10
Mesa dropseed (SPFL2)                1                 3
Small soapweed (YUGL)                1       31                          9       14
Broom snakeweed (GUSA2)              1                 3
Cacti spp. (OPUNT)                   1                50                50       75                                                    75       88
                               Plot size
                                                                          Units of weight
          Enter plot size in expressed in                                  expressed in
                                          Enter units of weight in 1 of
            1 of the blue         m2                                          grams.        Total reconstructed production
                                             the blue cells below.
            cells below.                                                                        of sampled community

                                  0.89                                        1.00
            m2         ft2                   grams         ounces
                                                                                                        1541
                  9.60                           1
Double-sampled plots            Conversion   Corrected                    Reconstruction factors                 Reconstructed
          Estimated   Clipped     factor      weight       Air Dry Wt       Ungrazed         Growth    Climate      weight

             4          6         1.33          48           100%             100%           100%      100%           48
             9          6         0.58          51            95%             100%           100%      100%           48
                                  1.20          60            95%             100%           100%      100%           57
                                  1.00         110            95%             100%           100%      100%          105
                                  1.60          48            95%             100%           100%      100%           46
                                               100            95%             100%           100%      100%           95
                                               120            95%             100%           100%      100%          114
            55         60         1.37         616            80%             100%           100%      100%          493
                                  0.80          56            95%             100%           100%      100%           53
                                                50            95%             100%           100%      100%           48
                                                 6            95%             100%           100%      100%           6
                                               108            75%             100%           100%      100%           81
                                                 6            95%             100%           100%      100%           6
                                  1.17         411            95%             100%           100%      100%          390
The data entered in this example represent five 9.6-ft2 plots. Samples were
measured in grams. Weight units (Column B) were not used. Some species were
double sampled once, some were double sampled twice, some weren't double
sampled at all. See the other 2 examples below.
      This example shows data that are very similar to that
      above, but in this case weight units were used.
      Double samples are shown in bold.




This example shows data from two 1/100th-acre plots.
Samples were measured in ounces, weight units were
used, and double sampling was not used.
If more than 10 plots of the same plot size are used to sample a pla
needed and average the results. Note: All sampled species in any "
Worksheets when averaging.


The example below shows one way to average results. The "Recon
copied (Columns A-W), and pasted into a new workbook (pasted in
references and formatting). The same block of data was then copie
"Reconstructor" Worksheet for Plots 11-15 was copied and pasted
copied and pasted over itself using Paste Special, Values; then cop
last block (Plots 11-15 in this example) was pasted twice (one block
data and used to average all plots. In this example, the formula "=A
average canopy cover for the site. That formula was then copied an
cover types, reconstructed weight by species, and total reconstructe
e plot size are used to sample a plant community, use the "Reconstructor" Worksheet as many times as
. Note: All sampled species in any "Reconstructor" Worksheet must be included on all "Reconstructor"



 way to average results. The "Reconstructor" Worksheet was completed for Plots 1-10 of 15 total plots,
sted into a new workbook (pasted in Cell A1 of Sheet 1; used "regular" Paste to maintain formula
   same block of data was then copied and pasted over itself using Paste Special, Values. The
Plots 11-15 was copied and pasted into Sheet 2 (Cell A1) of the same new workbook used for Plots 1-10;
 ing Paste Special, Values; then copied and pasted below Plots 1-10 in Sheet 1 using "regular" Paste. The
  ample) was pasted twice (one block below the other) in Sheet 1. The lower block was then cleared of
ots. In this example, the formula "=AVERAGE(B4,B29)" (without quotes) was entered in Cell B54 to
 te. That formula was then copied and pasted (Paste Special, Formulas) into the cells for the remaining
 ht by species, and total reconstructed production of community.
            ESD name      Loamy Upland 12-16" p.z.                   Cooperator     Rockin' Raindrop Ranch
                ESD ID    R041XC313AZ                             Conservationist   Pistol Pete
  Plant community name    Historic Climax Plant Community               Location    Center of Horse Pasture
                                                                            Date    30-Aug-08
   Similarity Index =     73%
  Group         Group
Reference     Allowable
Production Production      Group
   (#)            (#)     Number    Group Name
   376          338          1      1 - Dominant Mid Grasses
   207          73           2      2 - Dominant Short Grasses
   69           57           3      3 - Shortlived Grasses
   63           24           4      4 - Subdominant Mid Grasses
   69           46           5      5 - Perennial Threeawns
   23           23           6      6 - Miscellaneous Grasses
   44           44           7      7 - Annual Grasses
   14           14           8      8 - Perennial Forbs
   31           19           9      9 - Annual forbs
   65           65          10      10 - Dominant Half-shrubs
   13           13          11      11 - Increaser Half-shrubs
    6            5          12      12 - Miscellaneous Shrubs
   26           11          13      13 - Succulents
    5            2          14      14 - Trees
Rockin' Raindrop Ranch    Township     Range                 Section
Pistol Pete                 18S          32E           28 (SE 1/4 of SE 1/4)
Center of Horse Pasture               Latitude   3522639.8 UTM Northing Zone 12
30-Aug-08                            Longitude   682520.1 UTM Easting Zone 12
    Group Production (#)                    White cells - reference community values               ESD name
   low     high       RV                    Blue cells - reconstructed sample weight               ESD ID
   300     500       376                    Brown cells - calculated values                        Plant community name
                                                                                                   Plant group name
 Plant Type Production* (#)
   low      RV       high
  546       850      1350
                                            List ALL species in group (from ESD reference community)
    Community Total (#)                     Common name               Scientific name         low # high # RV#
   low    RV        high                    cane bluestem             Bothriochloa barbinodis     50   200   107
   619   1000       1800                    sideoats grama            Bouteloua curtipendula    200    500   313
                                            plains lovegrass          Eragrostis intermedia       50   200   107
 # = lb ac-1 yr-1

* If no values are listed in the ESD
under "Annual Production by Plant
Type," enter the sum of the low and
high group values for that plant type for
Plant Type Production low (Cell A7)
and high (Cell C7) values, and enter
the average of those values under RV
(Cell B7). Add these low, RV, and high
Plant Type Production values to
Community Total (Cells A11:C11) in
"Group 1" Worksheet.


Where RV is a calculated value
(brown cells), the relative proportions
of low, RV, and high values are
proportional to the low, RV, and high
Plant Type Production values.


If Plant Type Production RV<low,
RV>high, or RV=null, calculated RV
(#) values are the average of their
respective low and high values.
             Loamy Upland 12-16" p.z.
             R041XC313AZ
lant community name        Historic Climax Plant Community
lant group name            1 - Dominant Mid Grasses

                              Totals from columns below
                      825         338          338        376          37
            Reconstructed Allowable in Allowable in         NRI
            sample weight    group      community # Allowable % Allowable
                      300         107          107         76           8
                      125         125          125        223          22
                      400         107          107         76           8
    Group Production (#)                    White cells - reference community values                ESD name
   low     high       RV                    Blue cells - reconstructed sample weight                ESD ID
   150     300       207                    Brown cells - calculated values                         Plant community name
                                                                                                    Plant group name
 Plant Type Production* (#)
   low      RV       high
  546       850      1350
                                            List ALL species in group (from ESD reference community)
    Community Total (#)                     Common name               Scientific name          low # high # RV#
   low    RV        high                    sprucetop grama           Bouteloua chondrosioides     50   100    69
   619   1000       1800                    black grama               Bouteloua eriopoda           50   100    69
                                            blue grama                Bouteloua gracilis           50   250   126
 # = lb ac-1 yr-1
                                            hairy grama               Bouteloua hirsuta             0    50    19
* If no values are listed in the ESD
                                            slender grama             Bouteloua repens              0    50    19
under "Annual Production by Plant           common wolfstail          Lycurus phleoides             0    50    19
Type," enter the sum of the low and
high group values for that plant type for
Plant Type Production low (Cell A7)
and high (Cell C7) values, and enter
the average of those values under RV
(Cell B7). Add these low, RV, and high
Plant Type Production values to
Community Total (Cells A11:C11) in
"Group 1" Worksheet.


Where RV is a calculated value
(brown cells), the relative proportions
of low, RV, and high values are
proportional to the low, RV, and high
Plant Type Production values.


If Plant Type Production RV<low,
RV>high, or RV=null, calculated RV
(#) values are the average of their
respective low and high values.
             Loamy Upland 12-16" p.z.
             R041XC313AZ
lant community name        Historic Climax Plant Community
lant group name            2 - Dominant Short Grasses

                              Totals from columns below
                        79         73           73        207          20
            Reconstructed Allowable in Allowable in         NRI
             sample weight   group      community # Allowable % Allowable
                         8           8            8        44           4
                        12         12           12         44           4
                        30         30           30         81           8
                        25         19           19         12           1
                         4           4            4        12           1
            trace                                          12           1
    Group Production (#)                    White cells - reference community values              ESD name
   low     high       RV                    Blue cells - reconstructed sample weight              ESD ID
    20     150        69                    Brown cells - calculated values                       Plant community name
                                                                                                  Plant group name
 Plant Type Production* (#)
   low      RV       high
  546       850      1350
                                            List ALL species in group (from ESD reference community)
    Community Total (#)                     Common name               Scientific name        low # high # RV#
   low    RV        high                    Rothrock's grama          Bouteloua rothrockii       10    50    25
   619   1000       1800                    curly-mesquite            Hilaria belangeri          10    50    25
                                            Arizona muhly             Muhlenbergia arizonica      0    25     9
 # = lb ac-1 yr-1
                                            sand dropseed             Sporobolus cryptandrus      0    50    19
* If no values are listed in the ESD
under "Annual Production by Plant
Type," enter the sum of the low and
high group values for that plant type for
Plant Type Production low (Cell A7)
and high (Cell C7) values, and enter
the average of those values under RV
(Cell B7). Add these low, RV, and high
Plant Type Production values to
Community Total (Cells A11:C11) in
"Group 1" Worksheet.


Where RV is a calculated value
(brown cells), the relative proportions
of low, RV, and high values are
proportional to the low, RV, and high
Plant Type Production values.


If Plant Type Production RV<low,
RV>high, or RV=null, calculated RV
(#) values are the average of their
respective low and high values.
             Loamy Upland 12-16" p.z.
             R041XC313AZ
lant community name        Historic Climax Plant Community
lant group name            3 - Shortlived Grasses

                              Totals from columns below
                      177          57           57         69           7
            Reconstructed Allowable in Allowable in         NRI
            sample weight    group      community # Allowable % Allowable
                        4            4            4        22           2
                      127          25           25         22           2
                       12            9            9         8           1
                       34          19           19         17           2
    Group Production (#)                    White cells - reference community values              ESD name
   low     high       RV                    Blue cells - reconstructed sample weight              ESD ID
    10     150        63                    Brown cells - calculated values                       Plant community name
                                                                                                  Plant group name
 Plant Type Production* (#)
   low      RV       high
  546       850      1350
                                            List ALL species in group (from ESD reference community)
    Community Total (#)                     Common name               Scientific name        low # high # RV#
   low    RV        high                    Arizona cottontop         Digitaria californica       5    50    22
   619   1000       1800                    tanglehead                Heteropogon contortus       0    40    15
                                            bush muhly                Muhlenbergia porteri        0    50    19
 # = lb ac-1 yr-1
                                            plains bristlegrass       Setaria vulpiseta           5    50    22
* If no values are listed in the ESD
under "Annual Production by Plant
Type," enter the sum of the low and
high group values for that plant type for
Plant Type Production low (Cell A7)
and high (Cell C7) values, and enter
the average of those values under RV
(Cell B7). Add these low, RV, and high
Plant Type Production values to
Community Total (Cells A11:C11) in
"Group 1" Worksheet.


Where RV is a calculated value
(brown cells), the relative proportions
of low, RV, and high values are
proportional to the low, RV, and high
Plant Type Production values.


If Plant Type Production RV<low,
RV>high, or RV=null, calculated RV
(#) values are the average of their
respective low and high values.
             Loamy Upland 12-16" p.z.
             R041XC313AZ
lant community name        Historic Climax Plant Community
lant group name            4 - Subdominant Mid Grasses

                              Totals from columns below
                        61         24           24         63           6
            Reconstructed Allowable in Allowable in         NRI
             sample weight   group      community # Allowable % Allowable
                         2           2            2        18           2
                                                           12           1
            trace                                          15           2
                        59         22           22         18           2
    Group Production (#)                  White cells - reference community values                       ESD name
   low     high       RV                  Blue cells - reconstructed sample weight                       ESD ID
    50     100        69                  Brown cells - calculated values                                Plant community name
                                                                                                         Plant group name
 Plant Type Production* (#)
   low      RV       high
  546       850      1350
                                          List ALL species in group (from ESD reference community)
    Community Total (#)                   Common name               Scientific name                    low # high # RV#
   low    RV        high                  Santa Rita threeawn       Aristida californica var. glabrata      0    15     6
   619   1000       1800                  poverty threeawn          Aristida divaricata                     5    30    14
                                          Havard's threeawn         Aristida havardii                       0    10     4
  # = lb ac-1 yr-1
                                          Wooton's threeawn         Aristida pansa                          0    10     4
* If no values are listed in the ESD
                                          purple threeawn           Aristida purpurea                       0    25     9
under "Annual Production by Plant         Fendler threeawn          Aristida purpurea var. longiseta        5    50    22
Type," enter the sum of the low and       Parish's threeawn         Aristida purpurea var. parishii         0    25     9
high group values for that plant type for Wright's threeawn         Aristida purpurea var. wrightii         0    10     4
Plant Type Production low (Cell A7)
and high (Cell C7) values, and enter
                                          spidergrass               Aristida ternipes                       5    50    22
the average of those values under RV spidergrass                    Aristida ternipes var. gentilis         5    50    22
(Cell B7). Add these low, RV, and high
Plant Type Production values to
Community Total (Cells A11:C11) in
"Group 1" Worksheet.


Where RV is a calculated value
(brown cells), the relative proportions
of low, RV, and high values are
proportional to the low, RV, and high
Plant Type Production values.


If Plant Type Production RV<low,
RV>high, or RV=null, calculated RV
(#) values are the average of their
respective low and high values.
             Loamy Upland 12-16" p.z.
             R041XC313AZ
lant community name        Historic Climax Plant Community
lant group name            5 - Perennial Threeawns

                              Totals from columns below
                      129          46           46         69           7
            Reconstructed Allowable in Allowable in         NRI
             sample weight   group      community # Allowable % Allowable
                                                            3           0
                        50         14           14          9           1
                                                            2           0
            trace                                           2           0
                                                            6           1
                        57         22           22         13           1
                        22           9            9         6           1
                                                            2           0
                                                           13           1
                                                           13           1
    Group Production (#)                  White cells - reference community values             ESD name
   low     high       RV                  Blue cells - reconstructed sample weight             ESD ID
    6       50        23                  Brown cells - calculated values                      Plant community name
                                                                                               Plant group name
 Plant Type Production* (#)
   low      RV       high
  546       850      1350
                                          List ALL species in group (from ESD reference community)
    Community Total (#)                   Common name               Scientific name         low # high # RV#
   low    RV        high                  purple grama              Bouteloua radicosa           0    20     8
   619   1000       1800                  red grama                 Bouteloua trifida            0    10     4
             -1   -1                      low woollygrass           Dasyochloa pulchella         0     5     2
  # = lb ac yr
                                          fall witchgrass           Digitaria cognata            1    20     8
* If no values are listed in the ESD
                                          squirreltail              Elymus elymoides             5    50    22
under "Annual Production by Plant         nineawn pappusgrass       Enneapogon desvauxii         0     5     2
Type," enter the sum of the low and       green sprangletop         Leptochloa dubia             0    20     8
high group values for that plant type for Hall's panicgrass         Panicum hallii               0     5     2
Plant Type Production low (Cell A7)
and high (Cell C7) values, and enter
                                          vine mesquite             Panicum obtusum              0    20     8
the average of those values under RV      whiplash pappusgrass      Pappophorum vaginatum        0    20     8
(Cell B7). Add these low, RV, and high tobosagrass                  Pleuraphis mutica            0    25     9
Plant Type Production values to           burrograss                Scleropogon brevifolius      0    10     4
Community Total (Cells A11:C11) in
                                          spike dropseed            Sporobolus contractus        0     5     2
"Group 1" Worksheet.
                                          slim tridens              Tridens muticus              0     5     2

Where RV is a calculated value
(brown cells), the relative proportions
of low, RV, and high values are
proportional to the low, RV, and high
Plant Type Production values.


If Plant Type Production RV<low,
RV>high, or RV=null, calculated RV
(#) values are the average of their
respective low and high values.
             Loamy Upland 12-16" p.z.
             R041XC313AZ
lant community name        Historic Climax Plant Community
lant group name            6 - Miscellaneous Grasses

                              Totals from columns below
                      129          46           23         23           2
            Reconstructed Allowable in Allowable in         NRI
             sample weight   group      community # Allowable % Allowable
            trace                                           2           0
                                                            1           0
                                                            0           0
                         5           5            2         2           0
                        44         22           11          6           1
                                                            0           0
                                                            2           0
                                                            0           0
                        56           8            4         2           0
                                                            2           0
                        15           9            5         2           0
                                                            1           0
                         9           2            1         0           0
            trace                                           0           0
    Group Production (#)              White cells - reference community values                        ESD name
   low     high       RV              Blue cells - reconstructed sample weight                        ESD ID
    10     100        44              Brown cells - calculated values                                 Plant community name
                                                                                                      Plant group name
 Plant Type Production* (#)
   low      RV       high
  546       850      1350
                                          List ALL species in group (from ESD reference community)
    Community Total (#)                   Common name               Scientific name                 low # high # RV#
   low    RV        high                  sixweeks threeawn         Aristida adscensionis                1    50    20
   619   1000       1800                  prairie threeawn          Aristida oligantha                   1    20     8
             -1   -1                      needle grama              Bouteloua aristidoides               1    50    20
  # = lb ac yr
                                          sixweeks grama            Bouteloua barbata                    1    25    10
* If no values are listed in the ESD
                                          Parry's grama             Bouteloua parryi                     0    10     4
under "Annual Production by Plant         Arizona brome             Bromus arizonicus                    0     5     2
Type," enter the sum of the low and       feather fingergrass       Chloris virgata                      0    50    19
high group values for that plant type for tapertip cupgrass         Eriochloa acuminata var. acuminata 0      25     9
Plant Type Production low (Cell A7)
and high (Cell C7) values, and enter
                                          Mexican lovegrass         Eragrostis mexicana                  0    15     6
the average of those values under RV      tufted lovegrass          Eragrostis pectinacea                0    20     8
(Cell B7). Add these low, RV, and high desert lovegrass             Eragrostis pectinacea var. miserrima 0    20     8
Plant Type Production values to           Mexican sprangletop       Leptochloa fusca ssp. uninervia      0    20     8
Community Total (Cells A11:C11) in
                                          mucronate sprangeltop     Leptochloa panicea ssp. brachiata    0    25     9
"Group 1" Worksheet.
                                          delicate muhly            Muhlenbergia fragilis                0     5     2
                                          littleseed muhly          Muhlenbergia microsperma             0    10     4
Where RV is a calculated value            witchgrass                Panicum capillare                    0    10     4
(brown cells), the relative proportions
                                          Mexican panicgrass        Panicum hirticaule                   0    50    19
of low, RV, and high values are
proportional to the low, RV, and high     Bigelow's bluegrass       Poa bigelovii                        0     5     2
Plant Type Production values.             Arizona signalgrass       Urochloa arizonica                   0    20     8
                                          sixweeks fescue           Vulpia octoflora                     1    50    20

If Plant Type Production RV<low,
RV>high, or RV=null, calculated RV
(#) values are the average of their
respective low and high values.
             Loamy Upland 12-16" p.z.
             R041XC313AZ
lant community name        Historic Climax Plant Community
lant group name            7 - Annual Grasses

                              Totals from columns below
                      232          78           44         44           4
            Reconstructed Allowable in Allowable in         NRI
             sample weight   group      community # Allowable % Allowable
                        14         14             8         5           0
                         5           5            3         2           0
                        89         20           11          5           0
                        44         10             6         2           0
                                                            1           0
                                                            0           0
            trace                                           4           0
                                                            2           0
                                                            1           0
                                                            2           0
                                                            2           0
                                                            2           0
                        35           9            5         2           0
                                                            0           0
                                                            1           0
                                                            1           0
                                                            4           0
                                                            0           0
                                                            2           0
                        45         20           11          5           0
    Group Production (#)             White cells - reference community values                           ESD name
   low     high       RV             Blue cells - reconstructed sample weight                           ESD ID
    5       75        14             Brown cells - calculated values                                    Plant community name
                                                                                                        Plant group name
 Plant Type Production* (#)
   low      RV       high
    20      45       225
                                          List ALL species in group (from ESD reference community)
    Community Total (#)                   Common name                  Scientific name                low # high # RV#
   low    RV        high                  dwarf desertpeony            Acourtia nana                       0     5     1
   619   1000       1800                  brownfoot                    Acourtia wrightii                   0     5     1
             -1   -1                      San Felipe dogweed           Adenophyllum porophylloides         0     2     0
   # = lb ac yr
                                          trailing windmills           Allionia incarnata                  0     5     1
* If no values are listed in the ESD
                                          weakleaf bur ragweed         Ambrosia confertiflora              1    25     4
under "Annual Production by Plant         anoda                        Anoda                               0     5     1
Type," enter the sum of the low and       tuber anemone                Anemone tuberosa                    0     5     1
high group values for that plant type for rockcress                    Arabis                              0     5     1
Plant Type Production low (Cell A7)
and high (Cell C7) values, and enter
                                          New Mexico silverbush        Argythamnia neomexicana             0     5     1
the average of those values under RV      pioneer rockcress            Arabis platysperma                  0     5     1
(Cell B7). Add these low, RV, and high southwestern pricklypoppy       Argemone pleiacantha                0     5     1
Plant Type Production values to           Watson's dutchman's pipe     Aristolochia watsonii               0     5     1
Community Total (Cells A11:C11) in
                                          dense ayenia                 Ayenia microphylla                  0    10     1
"Group 1" Worksheet.
                                          hairyseed bahia              Bahia absinthifolia                 0     5     1
                                          desert marigold              Baileya multiradiata                0     5     1
Where RV is a calculated value            lyreleaf greeneyes           Berlandiera lyrata                  0     2     0
(brown cells), the relative proportions
                                          climbing wartclub            Boerhavia scandens                  0     2     0
of low, RV, and high values are
proportional to the low, RV, and high     Arizona wrightwort           Carlowrightia arizonica             0     5     1
Plant Type Production values.             Indian paintbrush            Castilleja                          0     1     0
                                          rose heath                   Chaetopappa ericoides               0     2     0
                                          leatherweed                  Croton pottsii                      0    10     1
If Plant Type Production RV<low,
                                          fingerleaf gourd             Cucurbita digitata                  0     2     0
RV>high, or RV=null, calculated RV
(#) values are the average of their
                                          coyote gourd                 Cucurbita palmata                   0     2     0
respective low and high values.           Cooley's bundleflower        Desmanthus cooleyi                  0     5     1
                                          desert larkspur              Delphinium parishii                 0     1     0
                                          bluedicks                    Dichelostemma capitatum             1    20     3
                                          fetid marigold               Dyssodia papposa                    0     5     1
                                          spreading snakeherb                                              0
                                                                       Dyschoriste schiedeana var. decumbens    10     1
                                          spreading fleabane           Erigeron divergens                  1    20     3
                                          wild dwarf morning-glory     Evolvulus arizonicus                1    10     2
                                          Arizona snakecotton          Froelichia arizonica                0     5     1
                                          beeblossom                   Gaura                               0     5     1
                                          small matweed                Guilleminea densa                   0     5     1
                                          Indian rushpea               Hoffmannseggia glauca               0    10     1
                                          slender janusia              Janusia gracilis                    0    10     1
                                          ragged nettlespurge          Jatropha macrorhiza                 0     5     1
                                          Greene's bird's-foot trefoil Lotus greenei                       0     5     1
                                          Wright's deervetch           Lotus wrightii                      1    10     2
                                          Gila manroot                 Marah gilensis                      0     5     1
                                          variableleaf bushbean        Macroptilium gibbosifolium          0     5     1
                                          lacy tansyaster              Machaeranthera pinnatifida          1    20     3
                                          desert tobacco               Nicotiana obtusifolia               0     1     0
                                          tufted evening primrose      Oenothera caespitosa                0     5     1
orange fameflower            Phemeranthus aurantiacus          0       5   1
slender poreleaf             Porophyllum gracile               0       5   1
velvetseed milkwort          Polygala obscura                  0       5   1
spiny milkwort               Polygala subspinosa               0       2   0
shrubby purslane             Portulaca suffrutescens           0       2   0
Arizona cudweed              Pseudognaphalium arizonicum       0       5   1
Wright's cudweed                                               0
                             Pseudognaphalium canescens ssp. canescens 5   1
slimflower scurfpea          Psoralidium tenuiflorum           0       1   0
canaigre dock                Rumex hymenosepalus               0       2   0
twinleaf senna               Senna bauhinioides                0       5   1
Leiberg stonecrop            Sedum leibergii                   0       5   1
Lemmon's ragwort             Senecio lemmonii                  0       5   1
New Mexico fanpetals         Sida neomexicana                  0     10    1
silverleaf nightshade        Solanum elaeagnifolium            0       5   1
desert globemallow           Sphaeralcea ambigua               1     20    3
gooseberryleaf globemallow   Sphaeralcea grossulariifolia      0       2   0
brownplume wirelettuce       Stephanomeria pauciflora          1     20    3
jewels of Opar               Talinum paniculatum               0       2   0
Coulter's wrinklefruit       Tetraclea coulteri                0       5   1
pricklyleaf dogweed          Thymophylla acerosa               0       5   1
branched noseburn            Tragia ramosa                     0       2   0
American vetch               Vicia americana                   0       5   1
Louisiana vetch              Vicia ludoviciana                 0       5   1
copper zephyrlily            Zephyranthes longifolia           0       1   0
Rocky Mountain zinnia        Zinnia grandiflora                1     10    2
             Loamy Upland 12-16" p.z.
             R041XC313AZ
lant community name        Historic Climax Plant Community
lant group name            8 - Perennial Forbs

                              Totals from columns below
                      117          16           14         14           1
            Reconstructed Allowable in Allowable in         NRI
             sample weight   group      community # Allowable % Allowable
                                                            0           0
                                                            0           0
                                                            0           0
                                                            0           0
                        34           4            3         1           0
                                                            0           0
            trace                                           0           0
            trace                                           0           0
                                                            0           0
                                                            0           0
                                                            0           0
                                                            0           0
                                                            0           0
                                                            0           0
                                                            0           0
                                                            0           0
                                                            0           0
                                                            0           0
                                                            0           0
                                                            0           0
                                                            0           0
                                                            0           0
                                                            0           0
                                                            0           0
                                                            0           0
                                                            1           0
                                                            0           0
                                                            0           0
                        34           3            3         1           0
                         1           1            1         0           0
                                                            0           0
                                                            0           0
                                                            0           0
                                                            0           0
                                                            0           0
                                                            0           0
                                                            0           0
                         5           2            2         0           0
                                                            0           0
                                                            0           0
                                                            1           0
                                                            0           0
                                                            0           0
                     0   0
                     0   0
                     0   0
                     0   0
                     0   0
                     0   0
                     0   0
                     0   0
                     0   0
                     0   0
                     0   0
                     0   0
                     0   0
                     0   0
        21   3   3   1   0
                     0   0
trace                1   0
                     0   0
                     0   0
                     0   0
                     0   0
                     0   0
                     0   0
                     0   0
        22   2   2   0   0
    Group Production (#)             White cells - reference community values                           ESD name
   low     high       RV             Blue cells - reconstructed sample weight                           ESD ID
    15     150        31             Brown cells - calculated values                                    Plant community name
                                                                                                        Plant group name
 Plant Type Production* (#)
   low      RV       high
    20      45       225
                                          List ALL species in group (from ESD reference community)
    Community Total (#)                   Common name               Scientific name                   low # high # RV#
   low    RV        high                  New Mexico copperleaf     Acalypha neomexicana                   0     5     1
   619   1000       1800                  carelessweed              Amaranthus palmeri                     1    20     3
             -1   -1                      bristly fiddleneck        Amsinckia tessellata                   0     5     1
   # = lb ac yr
                                          southwestern pricklypoppy Argemone pleiacantha                   0     2     0
* If no values are listed in the ESD
                                          milkvetch                 Astragalus                             1    20     3
under "Annual Production by Plant         wheelscale saltbush       Atriplex elegans                       0    15     2
Type," enter the sum of the low and       fewflower beggarticks     Bidens leptocephala                    0     2     0
high group values for that plant type for Coulter's spiderling      Boerhavia coulteri                     1    20     3
Plant Type Production low (Cell A7)
and high (Cell C7) values, and enter
                                          hoary bowlesia            Bowlesia incana                        0     5     1
the average of those values under RV      fringed redmaids          Calandrinia ciliata                    0    10     1
(Cell B7). Add these low, RV, and high suncup                       Camissonia                             0     5     1
Plant Type Production values to           sego lily                 Calochortus nuttallii                  1     2     1
Community Total (Cells A11:C11) in
                                          lambsquarters             Chenopodium album                      1    20     3
"Group 1" Worksheet.
                                          sensitive partridge pea   Chamaecrista nictitans                 1    50     7
                                          New Mexico thistle        Cirsium neomexicanum                   1    15     3
Where RV is a calculated value            miner's lettuce           Claytonia perfoliata ssp. perfoliata   0     5     1
(brown cells), the relative proportions
                                          scrambled eggs            Corydalis aurea                        0    10     1
of low, RV, and high values are
proportional to the low, RV, and high     cryptantha                Cryptantha                             0     5     1
Plant Type Production values.             American wild carrot      Daucus pusillus                        1     5     1
                                          Wright's prairie clover   Dalea wrightii                         0     5     1
                                          sacred thorn-apple        Datura wrightii                        0     5     1
If Plant Type Production RV<low,
                                          western tansymustard      Descurainia pinnata                    1    20     3
RV>high, or RV=null, calculated RV
(#) values are the average of their
                                          wedgeleaf draba           Draba cuneifolia                       0     5     1
respective low and high values.           sanddune wallflower       Erysimum capitatum                     0     2     0
                                          miniature woollystar      Eriastrum diffusum                     0     5     1
                                          sorrel buckwheat          Eriogonum polycladon                   1    10     2
                                          Texas stork's bill        Erodium texanum                        0     5     1
                                          California poppy          Eschscholzia californica ssp. mexicana 0    15     2
                                          spurge                    Euphorbia                              0     5     1
                                          Arizona blanketflower     Gaillardia arizonica                   0     5     1
                                          star gilia                Gilia stellata                         0     5     1
                                          southwestern mock vervain Glandularia gooddingii                 0     5     1
                                          pearly globe amaranth     Gomphrena nitida                       0     5     1
                                          Arizona gumweed           Grindelia arizonica                    0     5     1
                                          longleaf false goldeneye  Heliomeris longifolia var. annua       1    50     7
                                          camphorweed               Heterotheca subaxillaris               0    25     3
                                          crestrib morning-glory    Ipomoea costellata                     1    20     3
                                          redstar                   Ipomoea coccinea                       0     2     0
                                          Thurber's morning-glory   Ipomoea thurberi                       0     5     1
                                          Arizona poppy             Kallstroemia grandiflora               0    25     3
                                          warty caltrop             Kallstroemia parviflora                0     2     0
                                          Gordon's bladderpod       Lesquerella gordonii                   0     5     1
                                          shaggyfruit pepperweed    Lepidium lasiocarpum                   0    15     2
intermediate pepperweed       Lepidium virginicum var. medium       0    5   1
Lewis flax                    Linum lewisii                         0    5   1
foothill deervetch            Lotus humistratus                     0   15   2
coastal bird's-foot trefoil   Lotus salsuginosus var. brevivexillus 0   15   2
Arizona lupine                Lupinus arizonicus                    0    5   1
Coulter's lupine              Lupinus sparsiflorus                  0    5   1
hollowleaf annual lupine      Lupinus succulentus                   0   20   2
Fendler's desertdandelion     Malacothrix fendleri                  0    2   0
slender goldenweed            Machaeranthera gracilis               1   25   4
tanseyleaf tansyaster         Machaeranthera tanacetifolia          1   25   4
whitestem blazingstar         Mentzelia albicaulis                  0    5   1
Nuttall's povertyweed         Monolepis nuttalliana                 0    5   1
combseed                      Pectocarya                            0    5   1
manybristle chinchweed        Pectis papposa                        0   10   1
tepary bean                   Phaseolus acutifolius                 0   10   1
phacelia                      Phacelia                              0    5   1
phlox                         Phlox                                 0    5   1
groundcherry                  Physalis                              0    5   1
Arizona popcornflower         Plagiobothrys arizonicus              1   25   4
desert Indianwheat            Plantago ovata                        1   20   3
woolly plantain               Plantago patagonica                   1   25   4
purslane                      Portulaca                             0   10   1
desert unicorn-plant          Proboscidea althaeifolia              0    5   1
doubleclaw                    Proboscidea parviflora                0    5   1
New Mexico plumeseed          Rafinesquia neomexicana               0    5   1
chia                          Salvia columbariae                    0    2   0
sawtooth sage                 Salvia subincisa                      1    5   1
spreading fanpetals           Sida abutifolia                       1   15   3
sleepy silene                 Silene antirrhina                     0    5   1
woolly tidestromia            Tidestromia lanuginosa                0   10   1
golden crownbeard             Verbesina encelioides                 0    5   1
             Loamy Upland 12-16" p.z.
             R041XC313AZ
lant community name        Historic Climax Plant Community
lant group name            9 - Annual forbs

                              Totals from columns below
                       98          19           19         31           3
            Reconstructed Allowable in Allowable in         NRI
            sample weight    group      community # Allowable % Allowable
                                                            0           0
                       34            3            3         1           0
                                                            0           0
                                                            0           0
                                                            1           0
                                                            1           0
                                                            0           0
                                                            1           0
                                                            0           0
                                                            0           0
                                                            0           0
                                                            0           0
                        8            3            3         1           0
                                                            2           0
                                                            1           0
                                                            0           0
                        1            1            1         0           0
                                                            0           0
                                                            0           0
                                                            0           0
                                                            0           0
                        1            1            1         1           0
                                                            0           0
                                                            0           0
                                                            0           0
                                                            1           0
                                                            0           0
                        1            1            1         1           0
                                                            0           0
                                                            0           0
                                                            0           0
                                                            0           0
                                                            0           0
                                                            0           0
                        4            4            4         2           0
                                                            1           0
                                                            1           0
                                                            0           0
                                                            0           0
                                                            1           0
                                                            0           0
                                                            0           0
                                                            1           0
             0   0
             0   0
             1   0
             1   0
             0   0
             0   0
34   2   2   1   0
             0   0
             1   0
             1   0
             0   0
             0   0
             0   0
             0   0
             0   0
             0   0
             0   0
             0   0
             1   0
15   3   3   1   0
             1   0
             0   0
             0   0
             0   0
             0   0
             0   0
             0   0
             1   0
             0   0
             0   0
             0   0
    Group Production (#)                    White cells - reference community values              ESD name
   low     high       RV                    Blue cells - reconstructed sample weight              ESD ID
    50     100        65                    Brown cells - calculated values                       Plant community name
                                                                                                  Plant group name
 Plant Type Production* (#)
   low      RV       high
    53      100      210
                                            List ALL species in group (from ESD reference community)
    Community Total (#)                     Common name               Scientific name        low # high # RV#
   low    RV        high                    fairyduster               Calliandra eriophylla      20   100    44
   619   1000       1800                    bastardsage               Eriogonum wrightii         10    50    22
                                            littleleaf ratany         Krameria erecta            20    50    29
 # = lb ac-1 yr-1
                                            trailing krameria         Krameria lanceolata         0    50    15
* If no values are listed in the ESD
                                            desert zinnia             Zinnia acerosa              0    50    15
under "Annual Production by Plant
Type," enter the sum of the low and
high group values for that plant type for
Plant Type Production low (Cell A7)
and high (Cell C7) values, and enter
the average of those values under RV
(Cell B7). Add these low, RV, and high
Plant Type Production values to
Community Total (Cells A11:C11) in
"Group 1" Worksheet.


Where RV is a calculated value
(brown cells), the relative proportions
of low, RV, and high values are
proportional to the low, RV, and high
Plant Type Production values.


If Plant Type Production RV<low,
RV>high, or RV=null, calculated RV
(#) values are the average of their
respective low and high values.
             Loamy Upland 12-16" p.z.
             R041XC313AZ
lant community name        Historic Climax Plant Community
lant group name            10 - Dominant Half-shrubs

                              Totals from columns below
                      129          83           65         65           6
            Reconstructed Allowable in Allowable in         NRI
            sample weight    group      community # Allowable % Allowable
                       35          35           27         23           2
                       68          22           17         11           1
                       24          24           19         15           1
                                                            8           1
                        2            2            2         8           1
    Group Production (#)                    White cells - reference community values                ESD name
   low     high       RV                    Blue cells - reconstructed sample weight                ESD ID
    1       40        13                    Brown cells - calculated values                         Plant community name
                                                                                                    Plant group name
 Plant Type Production* (#)
   low      RV       high
    53      100      210
                                            List ALL species in group (from ESD reference community)
    Community Total (#)                     Common name               Scientific name          low # high # RV#
   low    RV        high                    turpentine bush           Ericameria laricifolia        0    10     3
   619   1000       1800                    threadleaf snakeweed      Gutierrezia microcephala      0    20     6
                                            broom snakeweed           Gutierrezia sarothrae         1    30    10
 # = lb ac-1 yr-1
                                            burroweed                 Isocoma tenuisecta            0    30     9
* If no values are listed in the ESD
under "Annual Production by Plant
Type," enter the sum of the low and
high group values for that plant type for
Plant Type Production low (Cell A7)
and high (Cell C7) values, and enter
the average of those values under RV
(Cell B7). Add these low, RV, and high
Plant Type Production values to
Community Total (Cells A11:C11) in
"Group 1" Worksheet.


Where RV is a calculated value
(brown cells), the relative proportions
of low, RV, and high values are
proportional to the low, RV, and high
Plant Type Production values.


If Plant Type Production RV<low,
RV>high, or RV=null, calculated RV
(#) values are the average of their
respective low and high values.
             Loamy Upland 12-16" p.z.
             R041XC313AZ
lant community name        Historic Climax Plant Community
lant group name            11 - Increaser Half-shrubs

                              Totals from columns below
                       21          16           13         13           1
            Reconstructed Allowable in Allowable in         NRI
            sample weight    group      community # Allowable % Allowable
                                                            1           0
                        4            4            3         3           0
                       15          10             8         4           0
                        2            2            2         4           0
    Group Production (#)              White cells - reference community values                         ESD name
   low     high       RV              Blue cells - reconstructed sample weight                         ESD ID
    0       20         6              Brown cells - calculated values                                  Plant community name
                                                                                                       Plant group name
 Plant Type Production* (#)
   low      RV       high
    53      100      210
                                          List ALL species in group (from ESD reference community)
    Community Total (#)                   Common name               Scientific name                  low # high # RV#
   low    RV        high                  whitethorn acacia         Acacia constricta                     0     2     1
   619   1000       1800                  whitethorn acacia         Acacia constricta var. paucispina     0     5     1
             -1   -1                      catclaw acacia            Acacia greggii var. greggii           0     5     1
  # = lb ac yr
                                          fourwing saltbush         Atriplex canescens                    0    10     3
* If no values are listed in the ESD
                                          yerba de pasmo            Baccharis pteronioides                0     2     1
under "Annual Production by Plant         spiny hackberry           Celtis ehrenbergiana                  0    10     3
Type," enter the sum of the low and       knifeleaf condalia        Condalia spathulata                   0     5     1
high group values for that plant type for Warnock's snakewood       Condalia warnockii                    0     2     1
Plant Type Production low (Cell A7)
                                          Kearney's snakewood       Condalia warnockii var. kearneyana 0        2     1
and high (Cell C7) values, and enter
the average of those values under RV      button brittlebush        Encelia frutescens                    0     1     0
(Cell B7). Add these low, RV, and high longleaf jointfir            Ephedra trifurca                      0     2     1
Plant Type Production values to           American tarwort          Flourensia cernua                     0     2     1
Community Total (Cells A11:C11) in
                                          ocotillo                  Fouquieria splendens                  0     2     1
"Group 1" Worksheet.
                                          desert-thorn              Lycium                                0     2     1
                                          rough menodora            Menodora scabra                       0     5     1
Where RV is a calculated value            catclaw mimosa            Mimosa aculeaticarpa var. biuncifera 0      5     1
(brown cells), the relative proportions
                                          velvetpod mimosa          Mimosa dysocarpa                      0     2     1
of low, RV, and high values are
proportional to the low, RV, and high     sacahuista                Nolina microcarpa                     0     5     1
Plant Type Production values.             whitestem paperflower     Psilostrophe cooperi                  0     1     0
                                          threadleaf ragwort        Senecio flaccidus                     0     1     0
                                          lotebush                  Ziziphus obtusifolia                  0     2     1
If Plant Type Production RV<low,
RV>high, or RV=null, calculated RV
(#) values are the average of their
respective low and high values.
             Loamy Upland 12-16" p.z.
             R041XC313AZ
lant community name        Historic Climax Plant Community
lant group name            12 - Miscellaneous Shrubs

                              Totals from columns below
                       31            5            5         6           1
            Reconstructed Allowable in Allowable in         NRI
            sample weight    group      community # Allowable % Allowable
                                                            0           0
                                                            0           0
                                                            0           0
                       18            3            3         1           0
                                                            0           0
                                                            1           0
                                                            0           0
                                                            0           0
                                                            0           0
                                                            0           0
                        5            1            1         0           0
                                                            0           0
                                                            0           0
                                                            0           0
                                                            0           0
                                                            0           0
                                                            0           0
                        8            1            1         0           0
                                                            0           0
                                                            0           0
                                                            0           0
    Group Production (#)              White cells - reference community values                        ESD name
   low     high       RV              Blue cells - reconstructed sample weight                        ESD ID
    2       50        26              Brown cells - calculated values                                 Plant community name
                                                                                                      Plant group name
 Plant Type Production* (#)
   low      RV       high

                                          List ALL species in group (from ESD reference community)
    Community Total (#)                   Common name               Scientific name                low # high # RV#
   low    RV        high                  Palmer's century plant    Agave palmeri                         0   5     3
   619   1000       1800                  beehive cactus            Coryphantha                           0   5     3
             -1   -1                      Arizona pencil cholla     Cylindropuntia arbuscula              0   2     1
  # = lb ac yr
                                          jumping cholla            Cylindropuntia fulgida                0   5     3
* If no values are listed in the ESD
                                          candle cholla             Cylindropuntia kleiniae               0   2     1
under "Annual Production by Plant         Christmas cactus          Cylindropuntia leptocaulis            0   5     3
Type," enter the sum of the low and       walkingstick cactus       Cylindropuntia spinosior              0   5     3
high group values for that plant type for staghorn cholla           Cylindropuntia versicolor             0   5     3
Plant Type Production low (Cell A7)
and high (Cell C7) values, and enter
                                          hedgehog cactus           Echinocereus                          0   5     3
the average of those values under RV      rainbow cactus                                                  0
                                                                    Echinocereus pectinatus var. pectinatus   1     1
(Cell B7). Add these low, RV, and high spinystar                    Escobaria vivipara                    0   1     1
Plant Type Production values to           candy barrelcactus        Ferocactus wislizeni                  1   5     3
Community Total (Cells A11:C11) in
                                          globe cactus              Mammillaria                           0   5     3
"Group 1" Worksheet.
                                          cactus apple              Opuntia engelmannii                   1   5     3
                                          purple pricklypear        Opuntia macrocentra var. macrocentra0     5     3
Where RV is a calculated value            tulip pricklypear         Opuntia phaeacantha                   0   5     3
(brown cells), the relative proportions
                                          Santa Rita pricklypear    Opuntia santa-rita                    0   2     1
of low, RV, and high values are
proportional to the low, RV, and high     banana yucca              Yucca baccata                         0   5     3
Plant Type Production values.             soaptree yucca            Yucca elata                           0   5     3


If Plant Type Production RV<low,
RV>high, or RV=null, calculated RV
(#) values are the average of their
respective low and high values.
             Loamy Upland 12-16" p.z.
             R041XC313AZ
lant community name        Historic Climax Plant Community
lant group name            13 - Succulents

                              Totals from columns below
                        18         11           11         26           3
            Reconstructed Allowable in Allowable in         NRI
             sample weight   group      community # Allowable % Allowable
                                                            2           0
                                                            2           0
                                                            1           0
                         2           2            2         2           0
                                                            1           0
            trace                                           2           0
                                                            2           0
                                                            2           0
                                                            2           0
                                                            0           0
                                                            0           0
                         9           3            3         2           0
                                                            2           0
                         4           3            3         2           0
                                                            2           0
                                                            2           0
                                                            1           0
                         1           1            1         2           0
                         2           2            2         2           0
    Group Production (#)                    White cells - reference community values                     ESD name
   low     high       RV                    Blue cells - reconstructed sample weight                     ESD ID
    0       15         5                    Brown cells - calculated values                              Plant community name
                                                                                                         Plant group name
 Plant Type Production* (#)
   low      RV       high
    0        5        15
                                            List ALL species in group (from ESD reference community)
    Community Total (#)                     Common name               Scientific name                 low # high # RV#
   low    RV        high                    oneseed juniper           Juniperus monosperma                 0     2     1
   619   1000       1800                    Jerusalem thorn           Parkinsonia aculeata                 0     2     1
                                            blue paloverde            Parkinsonia florida                  0     2     1
 # = lb ac-1 yr-1
                                            western honey mesquite    Prosopis glandulosa var. torreyana   0     5     2
* If no values are listed in the ESD
                                            velvet mesquite           Prosopis velutina                    0     5     2
under "Annual Production by Plant
Type," enter the sum of the low and
high group values for that plant type for
Plant Type Production low (Cell A7)
and high (Cell C7) values, and enter
the average of those values under RV
(Cell B7). Add these low, RV, and high
Plant Type Production values to
Community Total (Cells A11:C11) in
"Group 1" Worksheet.


Where RV is a calculated value
(brown cells), the relative proportions
of low, RV, and high values are
proportional to the low, RV, and high
Plant Type Production values.


If Plant Type Production RV<low,
RV>high, or RV=null, calculated RV
(#) values are the average of their
respective low and high values.
             Loamy Upland 12-16" p.z.
             R041XC313AZ
lant community name        Historic Climax Plant Community
lant group name            14 - Trees

                              Totals from columns below
                       14            2            2         5           0
            Reconstructed Allowable in Allowable in         NRI
            sample weight    group      community # Allowable % Allowable
                        5            1            1         1           0
                                                            1           0
                                                            1           0
                        9            2            2         2           0
                                                            2           0
    Group Production (#)                    White cells - reference community values              ESD name
   low     high       RV                    Blue cells - reconstructed sample weight              ESD ID
                                            Brown cells - calculated values                       Plant community name
                                                                                                  Plant group name
 Plant Type Production* (#)
   low      RV       high

                                            List ALL species in group (from ESD reference community)
    Community Total (#)                     Common name               Scientific name        low # high # RV#
   low    RV        high


 # = lb ac-1 yr-1

* If no values are listed in the ESD
under "Annual Production by Plant
Type," enter the sum of the low and
high group values for that plant type for
Plant Type Production low (Cell A7)
and high (Cell C7) values, and enter
the average of those values under RV
(Cell B7). Add these low, RV, and high
Plant Type Production values to
Community Total (Cells A11:C11) in
"Group 1" Worksheet.


Where RV is a calculated value
(brown cells), the relative proportions
of low, RV, and high values are
proportional to the low, RV, and high
Plant Type Production values.


If Plant Type Production RV<low,
RV>high, or RV=null, calculated RV
(#) values are the average of their
respective low and high values.
lant community name
lant group name

                             Totals from columns below

           Reconstructed Allowable in Allowable in        NRI
           sample weight    group     community # Allowable % Allowable
    Group Production (#)                    White cells - reference community values              ESD name
   low     high       RV                    Blue cells - reconstructed sample weight              ESD ID
                                            Brown cells - calculated values                       Plant community name
                                                                                                  Plant group name
 Plant Type Production* (#)
   low      RV       high

                                            List ALL species in group (from ESD reference community)
    Community Total (#)                     Common name               Scientific name        low # high # RV#
   low    RV        high


 # = lb ac-1 yr-1

* If no values are listed in the ESD
under "Annual Production by Plant
Type," enter the sum of the low and
high group values for that plant type for
Plant Type Production low (Cell A7)
and high (Cell C7) values, and enter
the average of those values under RV
(Cell B7). Add these low, RV, and high
Plant Type Production values to
Community Total (Cells A11:C11) in
"Group 1" Worksheet.


Where RV is a calculated value
(brown cells), the relative proportions
of low, RV, and high values are
proportional to the low, RV, and high
Plant Type Production values.


If Plant Type Production RV<low,
RV>high, or RV=null, calculated RV
(#) values are the average of their
respective low and high values.
lant community name
lant group name

                             Totals from columns below

           Reconstructed Allowable in Allowable in        NRI
           sample weight    group     community # Allowable % Allowable
    Group Production (#)                    White cells - reference community values              ESD name
   low     high       RV                    Blue cells - reconstructed sample weight              ESD ID
                                            Brown cells - calculated values                       Plant community name
                                                                                                  Plant group name
 Plant Type Production* (#)
   low      RV       high

                                            List ALL species in group (from ESD reference community)
    Community Total (#)                     Common name               Scientific name        low # high # RV#
   low    RV        high


 # = lb ac-1 yr-1

* If no values are listed in the ESD
under "Annual Production by Plant
Type," enter the sum of the low and
high group values for that plant type for
Plant Type Production low (Cell A7)
and high (Cell C7) values, and enter
the average of those values under RV
(Cell B7). Add these low, RV, and high
Plant Type Production values to
Community Total (Cells A11:C11) in
"Group 1" Worksheet.


Where RV is a calculated value
(brown cells), the relative proportions
of low, RV, and high values are
proportional to the low, RV, and high
Plant Type Production values.


If Plant Type Production RV<low,
RV>high, or RV=null, calculated RV
(#) values are the average of their
respective low and high values.
lant community name
lant group name

                             Totals from columns below

           Reconstructed Allowable in Allowable in        NRI
           sample weight    group     community # Allowable % Allowable
    Group Production (#)                    White cells - reference community values              ESD name
   low     high       RV                    Blue cells - reconstructed sample weight              ESD ID
                                            Brown cells - calculated values                       Plant community name
                                                                                                  Plant group name
 Plant Type Production* (#)
   low      RV       high

                                            List ALL species in group (from ESD reference community)
    Community Total (#)                     Common name               Scientific name        low # high # RV#
   low    RV        high


 # = lb ac-1 yr-1

* If no values are listed in the ESD
under "Annual Production by Plant
Type," enter the sum of the low and
high group values for that plant type for
Plant Type Production low (Cell A7)
and high (Cell C7) values, and enter
the average of those values under RV
(Cell B7). Add these low, RV, and high
Plant Type Production values to
Community Total (Cells A11:C11) in
"Group 1" Worksheet.


Where RV is a calculated value
(brown cells), the relative proportions
of low, RV, and high values are
proportional to the low, RV, and high
Plant Type Production values.


If Plant Type Production RV<low,
RV>high, or RV=null, calculated RV
(#) values are the average of their
respective low and high values.
lant community name
lant group name

                             Totals from columns below

           Reconstructed Allowable in Allowable in        NRI
           sample weight    group     community # Allowable % Allowable
          % Allowable                       White cells - reference community values              ESD name
   low       high     RV                    Blue cells - reconstructed sample weight              ESD ID
                                            Brown cells - calculated values                       Plant community name
                                                                                                  Plant group name
 Plant Type Production* (#)
   low      RV       high

                                            List ALL species in group (from ESD reference community)
    Community Total (#)                     Common name               Scientific name        low # high # RV#
   low    RV        high


 # = lb ac-1 yr-1

* If no values are listed in the ESD
under "Annual Production by Plant
Type," enter the sum of the low and
high group values for that plant type for
Plant Type Production low (Cell A7)
and high (Cell C7) values, and enter
the average of those values under RV
(Cell B7). Add these low, RV, and high
Plant Type Production values to
Community Total (Cells A11:C11) in
"Group 1" Worksheet.


Where RV is a calculated value
(brown cells), the relative proportions
of low, RV, and high values are
proportional to the low, RV, and high
Plant Type Production values.


If Plant Type Production RV<low,
RV>high, or RV=null, calculated RV
(#) values are the average of their
respective low and high values.
lant community name
lant group name

                             Totals from columns below

           Reconstructed Allowable in Allowable in        NRI
           sample weight    group     community # Allowable % Allowable
    Group Production (#)                    White cells - reference community values              ESD name
   low     high       RV                    Blue cells - reconstructed sample weight              ESD ID
                                            Brown cells - calculated values                       Plant community name
                                                                                                  Plant group name
 Plant Type Production* (#)
   low      RV       high

                                            List ALL species in group (from ESD reference community)
    Community Total (#)                     Common name               Scientific name        low # high # RV#
   low    RV        high


 # = lb ac-1 yr-1

* If no values are listed in the ESD
under "Annual Production by Plant
Type," enter the sum of the low and
high group values for that plant type for
Plant Type Production low (Cell A7)
and high (Cell C7) values, and enter
the average of those values under RV
(Cell B7). Add these low, RV, and high
Plant Type Production values to
Community Total (Cells A11:C11) in
"Group 1" Worksheet.


Where RV is a calculated value
(brown cells), the relative proportions
of low, RV, and high values are
proportional to the low, RV, and high
Plant Type Production values.


If Plant Type Production RV<low,
RV>high, or RV=null, calculated RV
(#) values are the average of their
respective low and high values.
lant community name
lant group name

                             Totals from columns below

           Reconstructed Allowable in Allowable in        NRI
           sample weight    group     community # Allowable % Allowable
    Group Production (#)                    White cells - reference community values              ESD name
   low     high       RV                    Blue cells - reconstructed sample weight              ESD ID
                                            Brown cells - calculated values                       Plant community name
                                                                                                  Plant group name
 Plant Type Production* (#)
   low      RV       high

                                            List ALL species in group (from ESD reference community)
    Community Total (#)                     Common name               Scientific name        low # high # RV#
   low    RV        high


 # = lb ac-1 yr-1

* If no values are listed in the ESD
under "Annual Production by Plant
Type," enter the sum of the low and
high group values for that plant type for
Plant Type Production low (Cell A7)
and high (Cell C7) values, and enter
the average of those values under RV
(Cell B7). Add these low, RV, and high
Plant Type Production values to
Community Total (Cells A11:C11) in
"Group 1" Worksheet.


Where RV is a calculated value
(brown cells), the relative proportions
of low, RV, and high values are
proportional to the low, RV, and high
Plant Type Production values.


If Plant Type Production RV<low,
RV>high, or RV=null, calculated RV
(#) values are the average of their
respective low and high values.
lant community name
lant group name

                             Totals from columns below

           Reconstructed Allowable in Allowable in        NRI
           sample weight    group     community # Allowable % Allowable
    Group Production (#)                    White cells - reference community values              ESD name
   low     high       RV                    Blue cells - reconstructed sample weight              ESD ID
                                            Brown cells - calculated values                       Plant community name
                                                                                                  Plant group name
 Plant Type Production* (#)
   low      RV       high

                                            List ALL species in group (from ESD reference community)
    Community Total (#)                     Common name               Scientific name        low # high # RV#
   low    RV        high


 # = lb ac-1 yr-1

* If no values are listed in the ESD
under "Annual Production by Plant
Type," enter the sum of the low and
high group values for that plant type for
Plant Type Production low (Cell A7)
and high (Cell C7) values, and enter
the average of those values under RV
(Cell B7). Add these low, RV, and high
Plant Type Production values to
Community Total (Cells A11:C11) in
"Group 1" Worksheet.


Where RV is a calculated value
(brown cells), the relative proportions
of low, RV, and high values are
proportional to the low, RV, and high
Plant Type Production values.


If Plant Type Production RV<low,
RV>high, or RV=null, calculated RV
(#) values are the average of their
respective low and high values.
lant community name
lant group name

                             Totals from columns below

           Reconstructed Allowable in Allowable in        NRI
           sample weight    group     community # Allowable % Allowable
    Group Production (#)                    White cells - reference community values              ESD name
   low     high       RV                    Blue cells - reconstructed sample weight              ESD ID
                                            Brown cells - calculated values                       Plant community name
                                                                                                  Plant group name
 Plant Type Production* (#)
   low      RV       high

                                            List ALL species in group (from ESD reference community)
    Community Total (#)                     Common name               Scientific name        low # high # RV#
   low    RV        high


 # = lb ac-1 yr-1

* If no values are listed in the ESD
under "Annual Production by Plant
Type," enter the sum of the low and
high group values for that plant type for
Plant Type Production low (Cell A7)
and high (Cell C7) values, and enter
the average of those values under RV
(Cell B7). Add these low, RV, and high
Plant Type Production values to
Community Total (Cells A11:C11) in
"Group 1" Worksheet.


Where RV is a calculated value
(brown cells), the relative proportions
of low, RV, and high values are
proportional to the low, RV, and high
Plant Type Production values.


If Plant Type Production RV<low,
RV>high, or RV=null, calculated RV
(#) values are the average of their
respective low and high values.
lant community name
lant group name

                             Totals from columns below

           Reconstructed Allowable in Allowable in        NRI
           sample weight    group     community # Allowable % Allowable
    Group Production (#)                    White cells - reference community values              ESD name
   low     high       RV                    Blue cells - reconstructed sample weight              ESD ID
                                            Brown cells - calculated values                       Plant community name
                                                                                                  Plant group name
 Plant Type Production* (#)
   low      RV       high

                                            List ALL species in group (from ESD reference community)
    Community Total (#)                     Common name               Scientific name        low # high # RV#
   low    RV        high


 # = lb ac-1 yr-1

* If no values are listed in the ESD
under "Annual Production by Plant
Type," enter the sum of the low and
high group values for that plant type for
Plant Type Production low (Cell A7)
and high (Cell C7) values, and enter
the average of those values under RV
(Cell B7). Add these low, RV, and high
Plant Type Production values to
Community Total (Cells A11:C11) in
"Group 1" Worksheet.


Where RV is a calculated value
(brown cells), the relative proportions
of low, RV, and high values are
proportional to the low, RV, and high
Plant Type Production values.


If Plant Type Production RV<low,
RV>high, or RV=null, calculated RV
(#) values are the average of their
respective low and high values.
lant community name
lant group name

                             Totals from columns below

           Reconstructed Allowable in Allowable in        NRI
           sample weight    group     community # Allowable % Allowable
    Group Production (#)                    White cells - reference community values              ESD name
   low     high       RV                    Blue cells - reconstructed sample weight              ESD ID
                                            Brown cells - calculated values                       Plant community name
                                                                                                  Plant group name
 Plant Type Production* (#)
   low      RV       high

                                            List ALL species in group (from ESD reference community)
    Community Total (#)                     Common name               Scientific name        low # high # RV#
   low    RV        high


 # = lb ac-1 yr-1

* If no values are listed in the ESD
under "Annual Production by Plant
Type," enter the sum of the low and
high group values for that plant type for
Plant Type Production low (Cell A7)
and high (Cell C7) values, and enter
the average of those values under RV
(Cell B7). Add these low, RV, and high
Plant Type Production values to
Community Total (Cells A11:C11) in
"Group 1" Worksheet.


Where RV is a calculated value
(brown cells), the relative proportions
of low, RV, and high values are
proportional to the low, RV, and high
Plant Type Production values.


If Plant Type Production RV<low,
RV>high, or RV=null, calculated RV
(#) values are the average of their
respective low and high values.
lant community name
lant group name

                             Totals from columns below

           Reconstructed Allowable in Allowable in        NRI
           sample weight    group     community # Allowable % Allowable
    Group Production (#)                    White cells - reference community values              ESD name
   low     high       RV                    Blue cells - reconstructed sample weight              ESD ID
                                            Brown cells - calculated values                       Plant community name
                                                                                                  Plant group name
 Plant Type Production* (#)
   low      RV       high

                                            List ALL species in group (from ESD reference community)
    Community Total (#)                     Common name               Scientific name        low # high # RV#
   low    RV        high


 # = lb ac-1 yr-1

* If no values are listed in the ESD
under "Annual Production by Plant
Type," enter the sum of the low and
high group values for that plant type for
Plant Type Production low (Cell A7)
and high (Cell C7) values, and enter
the average of those values under RV
(Cell B7). Add these low, RV, and high
Plant Type Production values to
Community Total (Cells A11:C11) in
"Group 1" Worksheet.


Where RV is a calculated value
(brown cells), the relative proportions
of low, RV, and high values are
proportional to the low, RV, and high
Plant Type Production values.


If Plant Type Production RV<low,
RV>high, or RV=null, calculated RV
(#) values are the average of their
respective low and high values.
lant community name
lant group name

                             Totals from columns below

           Reconstructed Allowable in Allowable in        NRI
           sample weight    group     community # Allowable % Allowable
    Group Production (#)                    White cells - reference community values              ESD name
   low     high       RV                    Blue cells - reconstructed sample weight              ESD ID
                                            Brown cells - calculated values                       Plant community name
                                                                                                  Plant group name
 Plant Type Production* (#)
   low      RV       high

                                            List ALL species in group (from ESD reference community)
    Community Total (#)                     Common name               Scientific name        low # high # RV#
   low    RV        high


 # = lb ac-1 yr-1

* If no values are listed in the ESD
under "Annual Production by Plant
Type," enter the sum of the low and
high group values for that plant type for
Plant Type Production low (Cell A7)
and high (Cell C7) values, and enter
the average of those values under RV
(Cell B7). Add these low, RV, and high
Plant Type Production values to
Community Total (Cells A11:C11) in
"Group 1" Worksheet.


Where RV is a calculated value
(brown cells), the relative proportions
of low, RV, and high values are
proportional to the low, RV, and high
Plant Type Production values.


If Plant Type Production RV<low,
RV>high, or RV=null, calculated RV
(#) values are the average of their
respective low and high values.
lant community name
lant group name

                             Totals from columns below

           Reconstructed Allowable in Allowable in        NRI
           sample weight    group     community # Allowable % Allowable
    Group Production (#)                    White cells - reference community values              ESD name
   low     high       RV                    Blue cells - reconstructed sample weight              ESD ID
                                            Brown cells - calculated values                       Plant community name
                                                                                                  Plant group name
 Plant Type Production* (#)
   low      RV       high

                                            List ALL species in group (from ESD reference community)
    Community Total (#)                     Common name               Scientific name        low # high # RV#
   low    RV        high


 # = lb ac-1 yr-1

* If no values are listed in the ESD
under "Annual Production by Plant
Type," enter the sum of the low and
high group values for that plant type for
Plant Type Production low (Cell A7)
and high (Cell C7) values, and enter
the average of those values under RV
(Cell B7). Add these low, RV, and high
Plant Type Production values to
Community Total (Cells A11:C11) in
"Group 1" Worksheet.


Where RV is a calculated value
(brown cells), the relative proportions
of low, RV, and high values are
proportional to the low, RV, and high
Plant Type Production values.


If Plant Type Production RV<low,
RV>high, or RV=null, calculated RV
(#) values are the average of their
respective low and high values.
lant community name
lant group name

                             Totals from columns below

           Reconstructed Allowable in Allowable in        NRI
           sample weight    group     community # Allowable % Allowable
    Group Production (#)                    White cells - reference community values              ESD name
   low     high       RV                    Blue cells - reconstructed sample weight              ESD ID
                                            Brown cells - calculated values                       Plant community name
                                                                                                  Plant group name
 Plant Type Production* (#)
   low      RV       high

                                            List ALL species in group (from ESD reference community)
    Community Total (#)                     Common name               Scientific name        low # high # RV#
   low    RV        high


 # = lb ac-1 yr-1

* If no values are listed in the ESD
under "Annual Production by Plant
Type," enter the sum of the low and
high group values for that plant type for
Plant Type Production low (Cell A7)
and high (Cell C7) values, and enter
the average of those values under RV
(Cell B7). Add these low, RV, and high
Plant Type Production values to
Community Total (Cells A11:C11) in
"Group 1" Worksheet.


Where RV is a calculated value
(brown cells), the relative proportions
of low, RV, and high values are
proportional to the low, RV, and high
Plant Type Production values.


If Plant Type Production RV<low,
RV>high, or RV=null, calculated RV
(#) values are the average of their
respective low and high values.
lant community name
lant group name

                             Totals from columns below

           Reconstructed Allowable in Allowable in        NRI
           sample weight    group     community # Allowable % Allowable
    Group Production (#)                    White cells - reference community values              ESD name
   low     high       RV                    Blue cells - reconstructed sample weight              ESD ID
                                            Brown cells - calculated values                       Plant community name
                                                                                                  Plant group name
 Plant Type Production* (#)
   low      RV       high

                                            List ALL species in group (from ESD reference community)
    Community Total (#)                     Common name               Scientific name        low # high # RV#
   low    RV        high


 # = lb ac-1 yr-1

* If no values are listed in the ESD
under "Annual Production by Plant
Type," enter the sum of the low and
high group values for that plant type for
Plant Type Production low (Cell A7)
and high (Cell C7) values, and enter
the average of those values under RV
(Cell B7). Add these low, RV, and high
Plant Type Production values to
Community Total (Cells A11:C11) in
"Group 1" Worksheet.


Where RV is a calculated value
(brown cells), the relative proportions
of low, RV, and high values are
proportional to the low, RV, and high
Plant Type Production values.


If Plant Type Production RV<low,
RV>high, or RV=null, calculated RV
(#) values are the average of their
respective low and high values.
lant community name
lant group name

                             Totals from columns below

           Reconstructed Allowable in Allowable in        NRI
           sample weight    group     community # Allowable % Allowable

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:12
posted:11/4/2011
language:English
pages:479