{"_id":"574d3415f520351900c5faef","githubsync":"","parentDoc":null,"user":"574a38c455098f0e00f065cc","category":{"_id":"574c1afbcf99610e00ef7d2b","__v":0,"project":"574a3bc0d1d1381900b73fab","version":"574a3bc0d1d1381900b73fae","sync":{"url":"","isSync":false},"reference":false,"createdAt":"2016-05-30T10:50:35.767Z","from_sync":false,"order":9999,"slug":"documentation-1","title":"1. Forest Description"},"version":{"_id":"574a3bc0d1d1381900b73fae","project":"574a3bc0d1d1381900b73fab","__v":7,"createdAt":"2016-05-29T00:45:52.939Z","releaseDate":"2016-05-29T00:45:52.939Z","categories":["574a3bc0d1d1381900b73faf","574be6d52aa7221700c51bed","574c0b6d281b010e00008f89","574c1afbcf99610e00ef7d2b","574d13b9a1f0be2000ae3803","574d14140db0870e0075382d","591eb3a72c1b1f0f000fa9f2"],"is_deprecated":false,"is_hidden":false,"is_beta":false,"is_stable":true,"codename":"","version_clean":"3517.0.0","version":"3517"},"__v":65,"project":"574a3bc0d1d1381900b73fab","updates":[],"next":{"pages":[],"description":""},"createdAt":"2016-05-31T06:49:57.363Z","link_external":false,"link_url":"","sync_unique":"","hidden":false,"api":{"results":{"codes":[]},"settings":"","auth":"required","params":[],"url":""},"isReference":false,"order":0,"body":"The Standard Forest Description workbook template contains a series of worksheets that describe the core data needed for a forest estate model and forest asset valuation.  The workbook has been designed to hold all such information and be easily understood and audited, or passed via email to other stakeholders with an interest in the modelling data.\n\nThe format is predefined for each worksheet.  The format must be followed for the forest description to be successfully converted into the normalized database for optimization of the model.  The software undertakes numerous error checks during different processing stages.  Common errors are reported for easy correction, although some errors will be more difficult to define as the total number of variables can be high.\n\nThe forest description workbook relies on end-users adhering to the required format and observing the recommended rules for building up the standard forest description of the assets being modelled.\n\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/NKXKFYraQfGcQhHHDN2X_tm-description.jpg\",\n        \"tm-description.jpg\",\n        \"1055\",\n        \"842\",\n        \"#2b455e\",\n        \"\"\n      ],\n      \"sizing\": \"full\",\n      \"caption\": \"\"\n    }\n  ]\n}\n[/block]\nA full example of the standard forest description (SFD) in Microsoft Excel format can be downloaded and examined from the following link.  Note that all possible worksheets are shown in this example, whereas smaller models do not need all worksheets to be present.\n[block:embed]\n{\n  \"html\": false,\n  \"url\": \"http://tigermoth.s3.amazonaws.com/examples/Description%20-%20Standard%20Forest%20Description%20with%20all%20worksheets.xlsb\",\n  \"title\": \"Download an example of the Standard Forest Description workbook\",\n  \"favicon\": null\n}\n[/block]\n<br />\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"The Standard Forest Description\"\n}\n[/block]\nThe standard forest description workbook can be most easily understood by considering it as a biological balance sheet.  It is a forest owner's best understanding of their existing forest assets at a particular point in time, being the date of the forest description.\n\nThe forest description workbook has been organized so that the worksheets flow from the physical forest data such as age and area on the left, through growth, yield, operational management, usage and finally market allocation and revenue on the right.\n\nThis logical layout also follows that the most static of data are located on the left and the most fluid data that are subject to change can be found on the right.\n\n##Physical Forestry Asset Information\n[block:parameters]\n{\n  \"data\": {\n    \"h-0\": \"Worksheet\",\n    \"h-1\": \"Type of Forest Description Information Contained on Worksheet\",\n    \"0-0\": \"[Plunits](doc:forest-information#worksheet-plunits)\",\n    \"1-0\": \"[Tending](doc:forest-information#worksheet-tending- -regime)\",\n    \"0-1\": \"The Planning Unit (Plunit) data that describe the area age-class structure of the entire forest estate as well as all other tabular attribute data for modelling constraints and reporting.\",\n    \"1-1\": \"Tree-Age dependent information normally associated with age based forest management silviculture and tending operations.\",\n    \"2-0\": \"[Regime](doc:forest-information#worksheet-tending- -regime)\",\n    \"3-0\": \"[Croptype](doc:forest-information#worksheet-croptype- -cost)\",\n    \"4-0\": \"[Cost](doc:forest-information#worksheet-croptype- -cost)\",\n    \"5-0\": \"[Carbon](doc:forest-information#worksheet-carbon)\",\n    \"2-1\": \"Tree-Age dependent information normally associated with production thinning based log product yield information.\",\n    \"3-1\": \"Clearfell-Age dependent information normally associated with yield tables that detail log out-turn.\",\n    \"4-1\": \"Clearfell-Age dependent information normally associated with the costs of clearfelling, loading, harvest roading and any marketing overheads and expenses.\",\n    \"5-1\": \"The carbon sequestration data for the individual pluntis within the model.  Information about the stem release and the decay release are also details on this worksheet.\",\n    \"6-0\": \"[Other](doc:forest-information#worksheet-other)\",\n    \"6-1\": \"A less structured worksheet that allows costs and non-timber revenues to be easily defined that only apply to discreet subsets of the forest estate.  Overheads costs normally defined.\"\n  },\n  \"cols\": 2,\n  \"rows\": 7\n}\n[/block]\n##Alternatives for Managing the Current Rotation\n[block:parameters]\n{\n  \"data\": {\n    \"h-0\": \"Worksheet\",\n    \"h-1\": \"Type of Forest Description Information Contained on Worksheet\",\n    \"0-0\": \"[Silviculture](doc:forest-management#worksheet-silviculture)\",\n    \"0-1\": \"Outlines all the possible management alternatives that can be considered by the optimization model for the estate that is defined at the beginning of the forest estate model. The alternatives are only valid for the current rotation areas and ages classes that exist as planning units at the outset of the forest estate model (beginning of modelling period 1).\"\n  },\n  \"cols\": 2,\n  \"rows\": 1\n}\n[/block]\n##Alternatives for Replanting the Future Rotations\n[block:parameters]\n{\n  \"data\": {\n    \"h-0\": \"Worksheet\",\n    \"h-1\": \"Type of Forest Description Information Contained on Worksheet\",\n    \"0-0\": \"[Replanting](doc:forest-management#worksheet-replanting)\",\n    \"0-1\": \"Outlines all the possible replanting alternatives that can be considered by the optimization model when planning units are clearfelled throughout the models planning horizon.  These alternatives represent the regenerated options for subsequent rotations of the forest estate. Replanting constraints can be applied and the time between clearfell and reestablishment can be defined.\"\n  },\n  \"cols\": 2,\n  \"rows\": 1\n}\n[/block]\n##Wood Flow Regulation and Harvest Planning\n[block:parameters]\n{\n  \"data\": {\n    \"h-0\": \"Worksheet\",\n    \"h-1\": \"Type of Forest Description Information Contained on Worksheet\",\n    \"0-0\": \"[Rotation](doc:woodflow-regulation#worksheet-rotation)\",\n    \"1-0\": \"[Harvesting](doc:woodflow-regulation#worksheet-harvesting)\",\n    \"2-0\": \"[Smoothing](doc:woodflow-regulation#worksheet-smoothing)\",\n    \"0-1\": \"Defines the minimum and maximum ages of clearfell.  These are core drivers of the avaliability of wood flow from the estate.\"\n  },\n  \"cols\": 2,\n  \"rows\": 3\n}\n[/block]\n##Log Transportation and Logistics\n[block:parameters]\n{\n  \"data\": {\n    \"h-0\": \"Worksheet\",\n    \"h-1\": \"Type of Forest Description Information Contained on Worksheet\",\n    \"0-0\": \"[Transport](doc:log-transportation#worksheet-transport)\",\n    \"1-0\": \"[Distance](doc:log-transportation#worksheet-distance)\",\n    \"2-0\": \"[Residue](doc:log-transportation#worksheet-residue)\",\n    \"0-1\": \"Defines the cost of delivering one unit of log volume from an origin (as defined on the worksheet 'Plunits') to a destination in the allocation model.  If an origin to destination combination is not valid, then no data should be entered for that combination in the transport matrix.\",\n    \"1-1\": \"Defines the lead distance from an origin (as defined on the worksheet 'Plunits') to a destination in the allocation model.\",\n    \"2-1\": \"Defines new log residue products that can be used in the allocation model to satisfy destination demands.  Log residue products arise from the conversion of log grade products at a destination.  This destination then becomes a supply origin with an associated transport cost.\"\n  },\n  \"cols\": 2,\n  \"rows\": 3\n}\n[/block]\n##Market Allocation Model and Log Sales Revenue\n[block:parameters]\n{\n  \"data\": {\n    \"h-0\": \"Worksheet\",\n    \"h-1\": \"Type of Forest Description Information Contained on Worksheet\",\n    \"0-0\": \"[Allocation](doc:allocation-model#worksheet-allocation)\",\n    \"1-0\": \"[Balancing](doc:allocation-model#worksheet-balancing)\",\n    \"2-0\": \"[Price](doc:allocation-model#worksheet-price)\",\n    \"3-0\": \"[Index](doc:allocation-model#worksheet-index)\"\n  },\n  \"cols\": 2,\n  \"rows\": 4\n}\n[/block]","excerpt":"An overview of the Standard Forest Description workbook","slug":"description-overview","type":"basic","title":"Overview"}

Overview

An overview of the Standard Forest Description workbook

The Standard Forest Description workbook template contains a series of worksheets that describe the core data needed for a forest estate model and forest asset valuation. The workbook has been designed to hold all such information and be easily understood and audited, or passed via email to other stakeholders with an interest in the modelling data. The format is predefined for each worksheet. The format must be followed for the forest description to be successfully converted into the normalized database for optimization of the model. The software undertakes numerous error checks during different processing stages. Common errors are reported for easy correction, although some errors will be more difficult to define as the total number of variables can be high. The forest description workbook relies on end-users adhering to the required format and observing the recommended rules for building up the standard forest description of the assets being modelled. [block:image] { "images": [ { "image": [ "https://files.readme.io/NKXKFYraQfGcQhHHDN2X_tm-description.jpg", "tm-description.jpg", "1055", "842", "#2b455e", "" ], "sizing": "full", "caption": "" } ] } [/block] A full example of the standard forest description (SFD) in Microsoft Excel format can be downloaded and examined from the following link. Note that all possible worksheets are shown in this example, whereas smaller models do not need all worksheets to be present. [block:embed] { "html": false, "url": "http://tigermoth.s3.amazonaws.com/examples/Description%20-%20Standard%20Forest%20Description%20with%20all%20worksheets.xlsb", "title": "Download an example of the Standard Forest Description workbook", "favicon": null } [/block] <br /> [block:api-header] { "type": "basic", "title": "The Standard Forest Description" } [/block] The standard forest description workbook can be most easily understood by considering it as a biological balance sheet. It is a forest owner's best understanding of their existing forest assets at a particular point in time, being the date of the forest description. The forest description workbook has been organized so that the worksheets flow from the physical forest data such as age and area on the left, through growth, yield, operational management, usage and finally market allocation and revenue on the right. This logical layout also follows that the most static of data are located on the left and the most fluid data that are subject to change can be found on the right. ##Physical Forestry Asset Information [block:parameters] { "data": { "h-0": "Worksheet", "h-1": "Type of Forest Description Information Contained on Worksheet", "0-0": "[Plunits](doc:forest-information#worksheet-plunits)", "1-0": "[Tending](doc:forest-information#worksheet-tending- -regime)", "0-1": "The Planning Unit (Plunit) data that describe the area age-class structure of the entire forest estate as well as all other tabular attribute data for modelling constraints and reporting.", "1-1": "Tree-Age dependent information normally associated with age based forest management silviculture and tending operations.", "2-0": "[Regime](doc:forest-information#worksheet-tending- -regime)", "3-0": "[Croptype](doc:forest-information#worksheet-croptype- -cost)", "4-0": "[Cost](doc:forest-information#worksheet-croptype- -cost)", "5-0": "[Carbon](doc:forest-information#worksheet-carbon)", "2-1": "Tree-Age dependent information normally associated with production thinning based log product yield information.", "3-1": "Clearfell-Age dependent information normally associated with yield tables that detail log out-turn.", "4-1": "Clearfell-Age dependent information normally associated with the costs of clearfelling, loading, harvest roading and any marketing overheads and expenses.", "5-1": "The carbon sequestration data for the individual pluntis within the model. Information about the stem release and the decay release are also details on this worksheet.", "6-0": "[Other](doc:forest-information#worksheet-other)", "6-1": "A less structured worksheet that allows costs and non-timber revenues to be easily defined that only apply to discreet subsets of the forest estate. Overheads costs normally defined." }, "cols": 2, "rows": 7 } [/block] ##Alternatives for Managing the Current Rotation [block:parameters] { "data": { "h-0": "Worksheet", "h-1": "Type of Forest Description Information Contained on Worksheet", "0-0": "[Silviculture](doc:forest-management#worksheet-silviculture)", "0-1": "Outlines all the possible management alternatives that can be considered by the optimization model for the estate that is defined at the beginning of the forest estate model. The alternatives are only valid for the current rotation areas and ages classes that exist as planning units at the outset of the forest estate model (beginning of modelling period 1)." }, "cols": 2, "rows": 1 } [/block] ##Alternatives for Replanting the Future Rotations [block:parameters] { "data": { "h-0": "Worksheet", "h-1": "Type of Forest Description Information Contained on Worksheet", "0-0": "[Replanting](doc:forest-management#worksheet-replanting)", "0-1": "Outlines all the possible replanting alternatives that can be considered by the optimization model when planning units are clearfelled throughout the models planning horizon. These alternatives represent the regenerated options for subsequent rotations of the forest estate. Replanting constraints can be applied and the time between clearfell and reestablishment can be defined." }, "cols": 2, "rows": 1 } [/block] ##Wood Flow Regulation and Harvest Planning [block:parameters] { "data": { "h-0": "Worksheet", "h-1": "Type of Forest Description Information Contained on Worksheet", "0-0": "[Rotation](doc:woodflow-regulation#worksheet-rotation)", "1-0": "[Harvesting](doc:woodflow-regulation#worksheet-harvesting)", "2-0": "[Smoothing](doc:woodflow-regulation#worksheet-smoothing)", "0-1": "Defines the minimum and maximum ages of clearfell. These are core drivers of the avaliability of wood flow from the estate." }, "cols": 2, "rows": 3 } [/block] ##Log Transportation and Logistics [block:parameters] { "data": { "h-0": "Worksheet", "h-1": "Type of Forest Description Information Contained on Worksheet", "0-0": "[Transport](doc:log-transportation#worksheet-transport)", "1-0": "[Distance](doc:log-transportation#worksheet-distance)", "2-0": "[Residue](doc:log-transportation#worksheet-residue)", "0-1": "Defines the cost of delivering one unit of log volume from an origin (as defined on the worksheet 'Plunits') to a destination in the allocation model. If an origin to destination combination is not valid, then no data should be entered for that combination in the transport matrix.", "1-1": "Defines the lead distance from an origin (as defined on the worksheet 'Plunits') to a destination in the allocation model.", "2-1": "Defines new log residue products that can be used in the allocation model to satisfy destination demands. Log residue products arise from the conversion of log grade products at a destination. This destination then becomes a supply origin with an associated transport cost." }, "cols": 2, "rows": 3 } [/block] ##Market Allocation Model and Log Sales Revenue [block:parameters] { "data": { "h-0": "Worksheet", "h-1": "Type of Forest Description Information Contained on Worksheet", "0-0": "[Allocation](doc:allocation-model#worksheet-allocation)", "1-0": "[Balancing](doc:allocation-model#worksheet-balancing)", "2-0": "[Price](doc:allocation-model#worksheet-price)", "3-0": "[Index](doc:allocation-model#worksheet-index)" }, "cols": 2, "rows": 4 } [/block]