Hi everyone,



Ok my situation is a bit tricky and I'm not sure what to do here, so if anyone has any suggestions let me know.

The Scenario:

I have 80+ vegetation sites, all with listed species that correspond to an upper stratum (U1), upper stratum (U2), middle stratum (M1), middle stratum M2) & a lower stratum (G). The values listed in the stratum fields are percentages of "cover" for each respective stratum for each respective specie.

Ie.
Specie U1 U2 M1 M2 L
Eucalyptus alba 43 18

Now, each of these vegetation sites belong to a "Land Unit" ie Land Unit 1a, 2, 3, 5a, 5b, 6, 7, 8, etc. Land Unit 5a contains 3 sites for example. Site 39, Site 56, and Site 70.

Basically I was wondering if there was an easy way to work out the average stratum cover values (U1/U2, M1/M2, L) over the entire Land Unit. So in this case. You have Site 39, 56, and 70. The specie "Eucalyptus alba" appears at all 3 sites in the U1/U2 stratums. Therefore they will have to be summed and divided by the sum of sites for the respective Land Unit.

There is also the case of Occurrence as well. I need to know what the average occurence for each specie for each stratum for the respective land unit is. For example. Eucalyptus alba appears in the U1 stratum in 2 sites out of 3, giving it a 66% occurrence over the land unit as an average. Eucalyptus alba also appears in the U2 stratum, but this time only in 1 site making it 33%.

Then I have the issue of splitting all this up into seperate cover values in a table format into a word document (hopefully from a report or something)

Something like this for example:

Upper Stratum 1
Specie Avg Cover Occurrence
Eucalyptus alba 14.3% 33%
Eucalyptus grandifolia 8.6% 66%
Erythrophleum chlorostachys 7.8% 100%

Upper Stratum 2

Eucalyptus sp 19% 66%

U2, M1, M2, etc.

Also, I'd have to split it even further by grouping the split results.

Ie.

Lower Stratum
Specie Avg Cover Occurrence
Chrysopogon fallax, Grevillea sp, <1% 33%
Acacia sp, Enneapogon sp, another,
another, another, another, etc.

All of those results would have to be in a table format that could be copied (and possibly modified a bit) into Microsoft Word. The versions used will be Microsoft Office 2003.

Hopefully that makes sense lol. Just trying to work out the quickest way to do this to recalculate the species of these Land Units. The database/client we use at work is a piece of crap and doesn't allow us to enter in the data properly, nor does it allow us to produce a lot of detailed reports. I would pretty much have to enter in all the species again for all the sites to achieve this but if someone can come up with a way that it will work out all the averages for each stratum for each specie, work out the occurrence for each specie across each stratum, and group results with similar values (ie < 1% coverage) into the same cell of the table, then I might be willing to do it :P

Thanks in advance!