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 “06 to 09 Aug update” (or a later Build).

 

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.