ALL -STATES-REPORT - DIVERSITY-MATRIX
CREATING THE REPORT
The “all-states-report” was designed to provide the capability to track all
individual states, each combination of species / size class – structure /
density. The report is designed to identify
the “average”, maximum, minimum, and standard deviation for each state, the
results from multiple simulations. This
report requires an output file generated by SIMPPLLE and the use of an Excel
template. You must have Excel 2002 to
run the macros in the Report Template.
You must be using SIMPPLLE version 2.3 and a build date of 06 August. After installing the build, run the
executable for the update “
If the report is done on all individual states it may take a considerable time to complete. Most likely the report will be done on “groupings” of the states such as grouping used for the standard Regional Diversity Matrix.
To accomplish groupings we have not had the time to create a complete user interface to query the user for the desired grouping. Instead we have the system asking for the name of a text file (*.txt) that contains the information to create groups. Many text files for different groupings may be made.
Steps:
1. Create a text file that contains grouping information.
2A. Make multiple simulations and at the end under main menu of “reports” select “all states report”.
OR
2B. Reload the saved simulation that is the last one made in the sequence of multiple simulations and run the report
3. In running the report, provide the name of the text file that has the grouping information, and provide a name for the resulting output file that will also have a “.txt” extension
4. Open the output file into an excel spreadsheet (not the Report Template). It’s “delimited” by “comma”. Delete the first line that says “grouping”. Save the spreadsheet.
5. Open the Report Template spreadsheet. Make sure you chose to “enable macros”.
Make sure you have changed the properties after you copied it so it is not read only.
Go to the sheet “SIMPPLLE Data”. Do not delete any data in the “Simpplle Data” worksheet. You will be “pasting over it”. Deleting it will mess up the column references in the macros.
6. Go to the spreadsheet that you have just imported the output file into, select the upper left square to highlight all the data and “copy”.
7. Go back to the Report Template, into the SIMPPLLE Data Worksheet and with the same upper left corner selected, “paste” the results from the output into this sheet. You’re pasting over the original data.
8. Go back to the Instructions sheet of the Template and select “Build Reports”.
THE “GROUPING TXT FILE”
It’s easy to see if you have missed values in creating the groups because these individuals will show up in the reports in the Template.
All states report customization file format (the *.txt file):
Legal Keywords:
· SPECIES
· SIZE-CLASS
· DENSITY
· AGE
· HABITAT-TYPE-GROUP
· SPECIAL-AREA
· OWNERSHIP
{ and } server to illustrate format and are not part of it.
{< or >}{ITEM} means either < or > followed by ITEM (e.g. <9)
{comma} means insert a Comma.
There can be as many keywords as you like and each can be listed multiple
times.
Note as illustrated below Age have two possible formats: comma delimited
like the others or 1 item as noted above.
----------------File format
--------------------------------------------------
{BEGIN}{comma}{OPTIONAL DESCRIPTION}
{KEYWORD}{space}{OPTIONAL-DESCRIPTION}
{ITEM1}{comma}{ITEM2}{comma}{ITEM3}…
{KEYWORD}{space}{OPTIONAL-DESCRIPTION}
{ITEM1}{comma}{ITEM2}{comma}{ITEM3}…
{AGE}{space}{OPTIONAL-DESCRIPTION}
{ITEM1}{comma}{ITEM2}{comma}{ITEM3}…
{AGE}{space}{OPTIONAL-DESCRIPTION}
{< or >}{ITEM}
END
Example :
BEGIN
HABITAT-TYPE-GROUP For
A1,A2,B1,B2,B3,C1,C2,D1,D2,D3,E1,E2,F1,F2,G1,G2
HABITAT-TYPE-GROUP NonFor
NF1A,NF1B,NF1C,NF2A,NF2B,NF2C,NF2D,NF3A,NF3B,NF3C,NF3D,NF4A,NF4B,NF4C,NF4D,NF4E,NF5A,NF5B
SPECIES TASH
AF,ES,WB,MH,AF-ES-MH,ES-AF
SPECIES TGCH
GF,C,WH,WH-C,WH-C-GF
SPECIES IMXS
L-DF,L-DF-AF,L-DF-ES,L-DF-GF,L-DF-PP,L-DF-WP,L-DF-LP,L-DF-RRWP,L-ES,L-ES-AF,L-GF,L-LP,L-LP-GF,L-PP,L-PP-LP,L-RRWP-GF,L-WP,L-WP-GF,WB-ES-AF,AL,AL-AF,AL-WB-AF
SPECIES DF-PP-MIX
PP-DF,PF
SPECIES LP
LP,LP-AF,LP-GF
SPECIES DF
DF,DF-ES,DF-AF,DF-LP,DF-GF,DF-LP-AF,DF-LP-ES,DF-LP-GF,DF-PP-GF,DF-WP,DF-WP-GF,DF-RRWP,DF-RRWP-GF,DF-PP-GF,DF-PP-LP
SPECIES PP
PP
SPECIES WL
L
SPECIES UMD
QA,QA-MC
SPECIES RIPHD
CW,CW-MC
SPECIES GFS
ALPINE-GRASSES,ALTERED-GRASSES,NATIVE-FORBS
SPECIES MMS
MESIC-SHRUBS
SPECIES MXS
XERIC-SHRUBS
SIZE-CLASS 1-5
ss
SIZE-CLASS 5-9
pole,pts,pmu
SIZE-CLASS 9+
medium,mts,mmu,large,lmu,lts,very-large,vlmu,vlts
SIZE-CLASS
closed-herb,closed-low-shrub,clumped,open-herb,open-low-shrub,open-mid-shrub,open-tall-shrub,scattered,uniform
END
SPECIAL AREA --
OWNERSHIP FIELDS
The above provides the information across an entire *.area file. If you want the report by special area, ownership or groupings of the two then you will need either a separate txt file for each, or make multiple sets of keywords within one text file.
.
BEGIN
SPECIAL-AREA s
suitable
HABITAT-TYPE-GROUP For
A1,A2,B1,B2,B3,C1,C2,D1,D2,D3,E1,E2,F1,F2,G1,G2
HABITAT-TYPE-GROUP NonFor
NF1A,NF1B,NF1C,NF2A,NF2B,NF2C,NF2D,NF3A,NF3B,NF3C,NF3D,NF4A,NF4B,NF4C,NF4D,NF4E,NF5A,NF5B
SPECIES TASCH
AF,ES,WB,MH,AF-ES-MH,ES-AF
SPECIES TACH
GF,C,WH,WH-C,WH-C-GF
SPECIES IMXS
L-DF,L-DF-AF,L-DF-ES,L-DF-GF,L-DF-PP,L-DF-WP,L-DF-LP,L-DF-RRWP,L-ES,L-ES-AF,L-GF,L-LP,L-LP-GF,L-PP,L-PP-LP,L-RRWP-GF,L-WP,L-WP-GF,WB-ES-AF,AL,AL-AF,AL-WB-AF
SPECIES DF-PP-MIX
PP-DF,PF
SPECIES LP
LP,LP-AF,LP-GF
SPECIES DF
DF,DF-ES,DF-AF,DF-LP,DF-GF,DF-LP-AF,DF-LP-ES,DF-LP-GF,DF-PP-GF,DF-WP,DF-WP-GF,DF-RRWP,DF-RRWP-GF,DF-PP-GF,DF-PP-LP
SPECIES PP
PP
SPECIES WL
L
SPECIES UMD
QA,QA-MC
SPECIES RIPHD
CW,CW-MC
SPECIES GFS
ALPINE-GRASSES,ALTERED-GRASSES,NATIVE-FORBS
SPECIES MMS
MESIC-SHRUBS
SPECIES MXS
XERIC-SHRUBS
SIZE-CLASS 1-5
ss
SIZE-CLASS 5-9
pole,pts,pmu
SIZE-CLASS 9+
medium,mts,mmu,large,lmu,lts,very-large,vlmu,vlts
SIZE-CLASS
closed-herb,closed-low-shrub,clumped,open-herb,open-low-shrub,open-mid-shrub,open-tall-shrub,scattered,uniform
END
BEGIN
SPECIAL-AREA ns
UNKNOWN
HABITAT-TYPE-GROUP For
A1,A2,B1,B2,B3,C1,C2,D1,D2,D3,E1,E2,F1,F2,G1,G2
HABITAT-TYPE-GROUP NonFor
NF1A,NF1B,NF1C,NF2A,NF2B,NF2C,NF2D,NF3A,NF3B,NF3C,NF3D,NF4A,NF4B,NF4C,NF4D,NF4E,NF5A,NF5B
SPECIES TASCH
AF,ES,WB,MH,AF-ES-MH,ES-AF
SPECIES TACH
GF,C,WH,WH-C,WH-C-GF
SPECIES IMXS
L-DF,L-DF-AF,L-DF-ES,L-DF-GF,L-DF-PP,L-DF-WP,L-DF-LP,L-DF-RRWP,L-ES,L-ES-AF,L-GF,L-LP,L-LP-GF,L-PP,L-PP-LP,L-RRWP-GF,L-WP,L-WP-GF,WB-ES-AF,AL,AL-AF,AL-WB-AF
SPECIES DF-PP-MIX
PP-DF,PF
SPECIES LP
LP,LP-AF,LP-GF
SPECIES DF
DF,DF-ES,DF-AF,DF-LP,DF-GF,DF-LP-AF,DF-LP-ES,DF-LP-GF,DF-PP-GF,DF-WP,DF-WP-GF,DF-RRWP,DF-RRWP-GF,DF-PP-GF,DF-PP-LP
SPECIES PP
PP
SPECIES WL
L
SPECIES UMD
QA,QA-MC
SPECIES RIPHD
CW,CW-MC
SPECIES GFS
ALPINE-GRASSES,ALTERED-GRASSES,NATIVE-FORBS
SPECIES MMS
MESIC-SHRUBS
SPECIES MXS
XERIC-SHRUBS
SIZE-CLASS 1-5
ss
SIZE-CLASS 5-9
pole,pts,pmu
SIZE-CLASS 9+
medium,mts,mmu,large,lmu,lts,very-large,vlmu,vlts
SIZE-CLASS
closed-herb,closed-low-shrub,clumped,open-herb,open-low-shrub,open-mid-shrub,open-tall-shrub,scattered,uniform
END
Everything is the same within the two “BEGIN – END” except for the use of the “SPECIAL-AREA” keywork. In the first set of keywords it is for a designation of “suitable”, that we have labeled as “s”. In the second set it is for all the remaining parts of the landscape that we have designated as “unknown” in this field. For the report we have labeled this group “ns”.
The resulting output file will have these two groupings separated. When this file is opened within an excel spreadsheet they will be identified/separated by the special area grouping.
From this spreadsheet you will have to do two (or as many as special area groups you have) separate runs of the “SIMPPLLE Report Template. You will have to copy and paste (remember not to delete the data from the template, but paste over) each grouping into the Template making sure you remove the top row with the grouping identifier.