How to Report¶
The software installs a series of Microsoft Excel workbook templates that can be used for detailed reporting of a forest description's optimized solution.
The templates have been developed specifically for assessing the physical metrics of the forest estate as well as determining its quantity and quality over the model's planning horizon.
Templates have been specifically developed to provide a standardized reporting format for professional forest valuation, be that for annual reporting or forest assets sales processes.
The standard reporting templates can be accessed from within the software by clicking the Tools/Templates menu option as shown below. This will open a directory containing all of the templates that are provided by the latest release of the software. These templates are updated and expanded with each new version of the software.
Using the Reporting Templates¶
The software's reporting templates have been provisioned with a data extraction routine that allows data to be quickly extracted and consolidated within the Microsoft Excel templates.
The process is straightforward and simply needs the end user to select an optimized forest description that they want to report on and then select a Group/Attribute filter to determine what part of the forest estate will be reported, i.e. everything or a subset of the overall estate. The reporting template is then updated with the user's selection.
This process is shown below in four simple steps.
1. Click Update Data¶
The Update Data button can be found in every reporting template on the worksheet Summary as shown below. Click this button to open the model selection window.
2. Select a Forest Description¶
The first requirement is to select a forest description. Only descriptions that have been successfully optimized can be used. The Group/Attribute data will be updated for each forest description that is selected.
3. Select a Group/Attribute¶
The combination of a Group and a selection of an Attribute from the Group forms a data filter. This allows certain combinations of plunits to underpin the data that is extracted and passed to the reporting template when it is updated. Normally all forest descriptions have a generic Group called All Plunits, and a single Attribute within this Group called All that has been allocated to every plunit in the forest description. Using the Group/Attribute combination All Plunits/All would return the data associated with every plunit within the forest description.
4. Start the Data Extraction¶
To begin the data extraction click the button titled Update Workbook Pivot Tables.
The solution data will be extracted from the forest descriptions SQL Server database and the templates pivot tables will be updated. This normally only takes a few seconds but is data dependent so extremely large models will be slower than smaller models.
Once the template workbook has refreshed then verification of the various solution extraction choices can be found on the Summary worksheet.
Changing the Origin Group¶
There is normally no need to change the default group that forms the Origin category in the reporting templates. By default this is always Origin as defined in Column F of the worksheet Plunits within a standard forest description. However it is possible to change the Origin category to be any Group defined on the Plunits worksheet of the underlying forest description.
To change the Group that defines the Origin category in the reporting templates then before clicking the Update Workbook Pivot Tables button, drop down the list box as shown below and select an alternative group to form the Origin summary category within the template.
The reporting templates have a predefined number of rows. Users will need to adjust the standard template if they select an Origin grouping that exceeds the existing number of rows in the workbook. Also, selecting groups that have a large number of unique attributes will increase the solution extraction time.
Exclude First Period Planting from Current Rotation¶
By default any planning unit that is planted in the first period of the forest estate model is considered part of the Current Rotation of forest. that is, a plunit that is Age 0 across Period 1 of the model will be considered part of the known forest description and therefore part of the current rotation of the estate.
If the portion of the forest estate that is Age 0 in Period 1 needs to be excluded from the Current Rotation and reported as being part of the Future Rotations of forest then the check box shown below can be unchecked.
If this check box is not checked then all Age 0 planning units in Period 1 will be excluded from the wood flows and cash flows that will be reported as being Current Rotation.
The Data Extraction Starting Period¶
A forest estate modelling horizon should last at least as long as two rotations of the most predominant species within the model. Typically in a southern hemisphere softwood environment where rotations lengths are around 27 to 30 years in duration forest estate models use a modelling horizon of 60 years (being 60 discreet modelling periods).
It is good practice to add another 10 years (10 periods) to the modelling horizon over and above the length determined by two rotations of the most predominant species.
This would give a modelling horizon of 70 years (for this example). This is good practice because it enables the data extraction starting point to be positioned at any of the first 10 periods of the optimization solution and still provide 60 periods of information.
Positioning the start of the data extraction in the future enables near-term wood flows and cash flows to be ignored and a summary created to represent the forest estate at a future point in time. Importantly, the Current Rotation summary will be consistent with the forest estate that is scheduled to exist at that same future point in time.
These types of data extraction roll-forwards are useful for understanding future forest asset value, perhaps coinciding with a predetermined date of exit from a forest investment.
The software default is not to have any roll-forward of the data extraction. That is, data extraction will always include the very first period of the optimization solution. As shown below the default Roll Forward value is 0 (zero).
Examples of Rolling-Forward the Data Extraction
A value of 1 (one) will roll-forward the data extraction by one period, so that the first actual period of the optimization solution will be excluded from the data extraction. This will result in the second period of the optimization solution occupying the first period of the standard template.
A value of 5 (five) will roll-forward the data extraction by five periods, so that the first five periods of the optimization solution will be excluded from the data extraction. This will result in the sixth period of the optimization solution occupying the first period of the standard template.
Importantly, the summary of the Current Rotation of forest will be correctly represented and appropriately aged in each scenario.