EXCEL MACROS FOR MULTIPLE SIMULATIONS
This macro is designed to work with the results from multiple simulations on the same landscape. The purpose is to enable comparisons between differences in simulations due to changes in the system logic or changes due to different management scenarios. It is not intended to compare different landscapes.
It does not work with a single simulation. It utilizes the file that contains
the results from a set(s) of multiple simulations.
This macro processes each data type (processes, species,
sizeclass / structure, and density separately. There is no
correlation between these values. If you want to process
specific combinations of species/sizeclass/density then use
the “all-states-report” and the “SIMPPLLE_Diversit-Matrix.xls”
The file that contains the results from multiple simulations has to be edited before running the macro. These are files that have the *ls.txt as part of their name.
Insert a row before each type of data block and label with the following so the macro
will be able to identify the following:
SIZECLASS (no space)
See the SIMPPLLE_macro_example_file_ls.txt
Within this file we have also inserted “END” at the end of each type of
data. This is not required.
Some “ls.txt” files will have multiple sets of each data type if the user is has made
the simulation choice to “track” “special areas” and or “ownership”. Make sure the labels for each type of data fully enclosed the data types.
USING THE MACRO
Open spreadsheet (Simpplle_Output_Macros.xls)
Enable macros in the opening
Select NEW DATA
Browse to find the desired “ -ls.txt” file(s)
Then select individual data types or all of them
After the macro is complete, save results as a spreadsheet *.xls, don’t save over the
This will put the results from each set of multiple simulations in a separate spreadsheet
with each data type being in a workbook. It calculates for each time step across all the number of simulations the following values:
A line plot of the values for each time step for each simulation is automatically created.
Two additional graphic displays can be selected.
The Maximum, Minimum and Average values for each attribute (each individual process, species, size class, or density) can be created. The values are for the entire set of time steps for the entire number of simulations. This graphic is generated using the “stock chart type”, using the High (Maximum), Low (Minimum) and
Close (Average, or Medium, or Mode) values. The user needs to specify what attributes from each type should be plotted as one will probably not want to see the graphic for all processes, species or sizeclass.
Column graphs for the percent (based on Average, Medium, or Mode) that each species, sizeclass, or density is of the total landscape acres by time step can be generated. This uses the average or medium or modal value as specified by the user. The user needs to specify what attributes from each type should be plotted as one will probably not want to see graphics for all processes, species or sizeclass.
If you want to save the results as a spreadsheet (don’t save by overriding the original *-ls.txt file), you have to specify that when you close the file. The saved results can be used later in the “OVERVIEW” option.
If you want to compare two or more sets of multiple simulations with the results from above
Open spreadsheet (Simpplle_Output_Macros.xls)
Enable macros in opening
Select CREATE OVERVIEW
Browse to find you’re saved *.xls files (results from NEW DATA option)
Select as many as you would like (two minimum)
Save (name must be in quotes!!)
The graphics automatically created in the OVERVIEW will only be line plot comparisons for each process, species, sizeclass and density. The user needs to select where the comparison is done with the Average, Medium, or Modal values.
An optional stacked column chart comparing the percent distribution of the fire process into its three components (stand replacing fire, mixed severity fire, and light severity fire) can be chosen. User can select if the Average across all time steps, all simulations in used, or if the Average for only the last time step of all simulations is used.
CHART OPTIONS - summary
Options vary by whether you are doing “basic processing” or the “overview” comparison.
Standard --- A line plot of each value of each data type, all time steps for each simulation.
Optional --- A Max, Min, Average (or Medium or Modal) plot for selected values
of selected data types. Values are taken from all time steps, all
A column chart showing percent of total landscape acres by time step
for selected species, sizeclass, or density values.
Standard --- A line plot that compares the average value over the time steps
between each set of multiple simulations. Plot is made for each value
for each data type(process, species, sizeclass and density)
Optional --- Change the above line plot to use Median or Modal value.
A stacked column chart using percent distribution of the fire
processes between the stand replacing fire, mixed severity fire, and
light severity fire. Within this choice, an option to display for all
time steps, or just the last time step. The percents are averages
across all time steps, all simulations, or just the last time step, across