{"_id":"57621544d3c70617006163a1","user":"574bfb9290d8b32000864973","project":"574a3bc0d1d1381900b73fab","githubsync":"","parentDoc":null,"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":96,"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"},"metadata":{"title":"","description":"","image":[]},"updates":[],"next":{"pages":[],"description":""},"createdAt":"2016-06-16T02:56:04.720Z","link_external":false,"link_url":"","sync_unique":"","hidden":false,"api":{"results":{"codes":[]},"settings":"","auth":"required","params":[],"url":""},"isReference":false,"order":5,"body":"The forest estate model solution produces log grade products and log residue products at the origins that were defined on the worksheet 'Plunits'.  Each planning unit has a mandatory origin, and this origin is the basis of allocating transport costs and distances.\n\nThe worksheet 'Transport' is a core data worksheet inasmuch as it defines all the possible destinations that can be referenced in the allocation model.  If a destination is not defined on the worksheet 'Transport' it cannot be referenced on the worksheet 'Allocation'.  The forest estate model transport costs, distances and any new log reside products are defined on the following worksheets:\n\n1. [Worksheet 'Transport'](doc:log-transportation#worksheet-transport)\n\n2. [Worksheet 'Distance'](doc:log-transportation#worksheet-distance)\n\n3. [Worksheet 'Residue'](doc:log-transportation#worksheet-residue)\n\n<br />\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Worksheet 'Transport'\"\n}\n[/block]\nThe worksheet 'Transport' defines the cost of delivering one unit of log grade volume from an origin (as defined on the worksheet 'Plunits') to a destination that has been configured to be part of 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[block:callout]\n{\n  \"type\": \"info\",\n  \"body\": \"The worksheet 'Transport' is an optional worksheet in the forest description workbook.\",\n  \"title\": \"Optional Worksheet\"\n}\n[/block]\nData always start at Cell 'B4', with Column 'B' and Row 4 being mandatory.  Users must not insert or delete rows or columns before Row 4 or Column 'B'.  The ordinal positioning of the worksheet needs to be the same as the example forest description.\n\nThe worksheet 'Transport' is configured as a matrix with all the origins that appear on the worksheet 'Plunits' needing to be entered in Column 'B', and the name of each and every destination that will be required in the allocation model entered across Row 4.\n\nThe cost of transporting one unit of volume from an origin to a destination is then entered in the matrix.  If the flow of volume from an origin to a destination is not allowed then leave the data blank for that particular matrix entry.  An entry of zero ($0) is a valid entry and simply means that the cost of the transportation for that option is zero.\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/Y8DIXms1RUWQq1M7EY1n_worksheet-transport.jpg\",\n        \"worksheet-transport.jpg\",\n        \"1124\",\n        \"634\",\n        \"#255549\",\n        \"\"\n      ],\n      \"sizing\": \"full\"\n    }\n  ]\n}\n[/block]\n<br />\n[block:callout]\n{\n  \"type\": \"danger\",\n  \"title\": \"Important\",\n  \"body\": \"Every planning unit origin that has been entered in Column 'F' on the worksheet 'Plunits' is required to be listed in Column 'B' of the worksheet 'Transport'.  In addition, origins and destinations can only be entered once in Column 'B' and Row 4, and duplicate entries will cause an error to be raised when the forest description is imported.\"\n}\n[/block]\n<br />\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Worksheet 'Distance'\"\n}\n[/block]\nThe worksheet 'Distance' is an exact copy of the worksheet 'Transport', with only the data being changed from the unit cost of transport to the actual lead distance from an origin to a destination.  The worksheet 'Distance' is used to work out the weighted average lead distances within the model.\n[block:callout]\n{\n  \"type\": \"info\",\n  \"title\": \"Optional Worksheet\",\n  \"body\": \"The worksheet 'Distance' is an optional worksheet in the forest description workbook.\"\n}\n[/block]\nThe worksheet 'Distance' is exactly the same format as worksheet 'Transport' and is a lead distance matrix.\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/IzAqqxJQRiewPk6ntiNW_worksheet-distance.jpg\",\n        \"worksheet-distance.jpg\",\n        \"1123\",\n        \"634\",\n        \"#244e3a\",\n        \"\"\n      ],\n      \"sizing\": \"full\"\n    }\n  ]\n}\n[/block]\n<br />\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Worksheet 'Residue'\"\n}\n[/block]\nIt is possible to defined new products that can be used in the allocation model to satisfy destination specific wood demand requirements.  These new products are called log residue products and arise from the conversion of the base log grade products defined in the forest description yield tables.   Examples of typical log residue products would be wood chips and sawdust residues that can be used to satisfy part of the total wood demand at destinations such as a Pulp Mills, MDF Facilities or Bio-Energy plants.\n\nLog residues arise from the conversion of the base log grade products allocated to a destination.  The destination becomes a new origin for the supply of log residue products.  A transport cost is assigned to represent the cost of delivering the log residue products from it's origin to the destinations where the log residue has been allocated.  Cash costs of production and sales revenues for log residue products can also be defined.\n[block:callout]\n{\n  \"type\": \"info\",\n  \"body\": \"The worksheet 'Residue' is an optional worksheet in the forest description workbook.\",\n  \"title\": \"Optional Worksheet\"\n}\n[/block]\nData always start at Cell 'B5'.  The Columns 'B' to 'K' are mandatory, and must be kept in the same structure and location as the standard forest description template defines.  Each row in the 'Residues' worksheet defines a time period across which a specific log residue product will be generated.\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/sAiQNYVJTwudPNYtXwdW_worksheet-residue.jpg\",\n        \"worksheet-residue.jpg\",\n        \"1124\",\n        \"634\",\n        \"#245543\",\n        \"\"\n      ],\n      \"sizing\": \"full\"\n    }\n  ]\n}\n[/block]\nA description of the data types and requirements for worksheet 'Residues' is below:\n[block:parameters]\n{\n  \"data\": {\n    \"h-0\": \"-Column-\",\n    \"0-0\": \"B & C\",\n    \"0-1\": \"'Start' & 'End'\",\n    \"h-1\": \"-Designation-\",\n    \"1-0\": \"D\",\n    \"1-1\": \"'Destination'\",\n    \"2-0\": \"E\",\n    \"2-1\": \"'Species'\",\n    \"3-0\": \"F\",\n    \"3-1\": \"'Product'\",\n    \"4-0\": \"G & H\",\n    \"5-0\": \"I\",\n    \"4-1\": \"'Min' & 'Max'\",\n    \"5-1\": \"'Factor'\",\n    \"6-0\": \"J\",\n    \"6-1\": \"'Name'\",\n    \"7-0\": \"K\",\n    \"7-1\": \"'Cash'\",\n    \"0-2\": \"The starting and ending periods that form a range across which the log residue product defined in the same worksheet row can arise.\",\n    \"1-2\": \"An existing destination within the forest estate model where the log grade product defined by Columns 'E' & 'F' is an allocated grade.  This destination becomes a supply origin for the resulting log residue product.\",\n    \"2-2\": \"The species of the log grade product that will be converted to a log residue product.  The species/product combination must already be defined as a log grade that can be delivered to the destination stated in Column 'D'.\",\n    \"3-2\": \"The log grade product that will be converted to a log residue product. The species/product combination must already be defined as a log grade that can be delivered to the destination stated in Column 'D'.\",\n    \"4-2\": \"The minimum and maximum age of wood, between which the log grade product that can be converted to the log residue product.  If the minimum and maximum age of wood is blank then any age is acceptable.\",\n    \"5-2\": \"The factor used to convert the volume of log grade product to log residue product.  For example, a factor of 0.36 means that for every 1 unit of log grade product delivered to the destination, then 0.36 units of the log residue product will arise.\",\n    \"6-2\": \"The name of the log residue product being produced.  This is subsequently used on both the 'Allocation' and the 'Price' worksheets when defining the allocation demand and selling price of the log residue product.\",\n    \"7-2\": \"A Cost of Production (CPROD) cash flow item that is calculated and summarised in the modelling cash flows.  This is applied on a converted basis, i.e. it is applied per unit of log residue product arising.\",\n    \"h-2\": \"-Description Data-\",\n    \"h-3\": \"\"\n  },\n  \"cols\": 3,\n  \"rows\": 8\n}\n[/block]\n\n[block:callout]\n{\n  \"type\": \"danger\",\n  \"title\": \"Important\",\n  \"body\": \"It is important to understand the economic effect of modelling log residue products.  Often the costs and revenues of these products are ignored, and only the volumes are considered.  The supply of log residue products in place of green roundwood log volume makes a demand easier to achieve.  However, the contribution margin of the log residue products needs to be carefully modelled and understood.  The total green roundwood equivalent (RWE) volume generated by the forest estate should not be attributed more economic margin than it otherwise should. That is, when using log residue products make sure that the net economic effect is not a double counting of the contribution margin of the log grade products that are converted to the log residue products.\"\n}\n[/block]\n<br />\n##Step 1 - Define Transport Costs and Distances\nOnce a log residue product has been defined on the 'Residues' worksheet the destination at which the conversion occurs itself becomes an origin from which the log residue product is supplied.\nTherefore all destinations at which a log residue product is created need to be added to the Transport and Distance worksheets as valid origins.\n\nThis is shown below, where in the example forest description data both the 'Plywood Mill' and the 'Saw Mill' destinations have been shown on the 'Residues' worksheet as destinations where log grade products are converted to log residue products.  Therefore both the  'Plywood Mill' and the 'Saw Mill' destinations (shown in Green) are also allocation model origins and need a cost and distance defined for the destinations that use the log residue products in any allocation model demands.\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/kFfxsIsSj2gBhF1RVNIZ_worksheet-residue-transport.jpg\",\n        \"worksheet-residue-transport.jpg\",\n        \"1124\",\n        \"634\",\n        \"#275541\",\n        \"\"\n      ],\n      \"sizing\": \"full\"\n    }\n  ]\n}\n[/block]\n<br />\n##Step 2 - Add Log Residue Products to Demands\nLog residue products can be used to satisfy the allocation model demands for wood supply at any Destination as long as a valid entry on the 'Transport' and 'Distance' worksheets have been defined.  They are used in exactly the same way as standard log grade products that are supplied in the underlying yield tables in the forest description.\n\nIn the example below the log residue product 'Woodchip' has been allocated to the 'Pulp Mill' destination and can be used alongside any existing log grade products to satisfy the demand at this allocation model Destination.\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/jQVWDVnRses3HS55ShzO_worksheet-residue-allocation.jpg\",\n        \"worksheet-residue-allocation.jpg\",\n        \"1124\",\n        \"634\",\n        \"#28524e\",\n        \"\"\n      ],\n      \"sizing\": \"full\"\n    }\n  ]\n}\n[/block]\n<br />\n##Step 3 - Add Revenues for Log Residue Products\nLog residue products are given a selling price at the allocation model destinations in exactly the same way as log grade products.  It is valid to make both the selling price and the transport cost equal to zero ($0) for on both the worksheets 'Price' and 'Transport'.  A zero entry is valid and will allow the log residue product to be used in the relevant allocation model demands.\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/olFaY9TPRum5jM4aZgWg_worksheet-residue-price.jpg\",\n        \"worksheet-residue-price.jpg\",\n        \"1124\",\n        \"634\",\n        \"#245247\",\n        \"\"\n      ],\n      \"sizing\": \"full\"\n    }\n  ]\n}\n[/block]\n<br />\nIn the example below the wood supply to the 'Pulp Mill' destination is shown.  The chart legend has been configured to show the modelling products, and the resulting chart shows the supply to the 'Pulp Mill' destination consists of both the 'Pulpwood' log grade product as well as 'Woodchip' log residue product.  The allocation demand has therefore been achieved by using both green roundwood logs and green roundwood equivalent (RWE) woodchips.\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/jnJMm0uTn2RCumaIOlXA_worksheet-residue-results.jpg\",\n        \"worksheet-residue-results.jpg\",\n        \"1107\",\n        \"781\",\n        \"#2288d0\",\n        \"\"\n      ],\n      \"sizing\": \"full\"\n    }\n  ]\n}\n[/block]","excerpt":"","slug":"log-transportation","type":"basic","title":"Log Transportation"}

Log Transportation


The forest estate model solution produces log grade products and log residue products at the origins that were defined on the worksheet 'Plunits'. Each planning unit has a mandatory origin, and this origin is the basis of allocating transport costs and distances. The worksheet 'Transport' is a core data worksheet inasmuch as it defines all the possible destinations that can be referenced in the allocation model. If a destination is not defined on the worksheet 'Transport' it cannot be referenced on the worksheet 'Allocation'. The forest estate model transport costs, distances and any new log reside products are defined on the following worksheets: 1. [Worksheet 'Transport'](doc:log-transportation#worksheet-transport) 2. [Worksheet 'Distance'](doc:log-transportation#worksheet-distance) 3. [Worksheet 'Residue'](doc:log-transportation#worksheet-residue) <br /> [block:api-header] { "type": "basic", "title": "Worksheet 'Transport'" } [/block] The worksheet 'Transport' defines the cost of delivering one unit of log grade volume from an origin (as defined on the worksheet 'Plunits') to a destination that has been configured to be part of 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. [block:callout] { "type": "info", "body": "The worksheet 'Transport' is an optional worksheet in the forest description workbook.", "title": "Optional Worksheet" } [/block] Data always start at Cell 'B4', with Column 'B' and Row 4 being mandatory. Users must not insert or delete rows or columns before Row 4 or Column 'B'. The ordinal positioning of the worksheet needs to be the same as the example forest description. The worksheet 'Transport' is configured as a matrix with all the origins that appear on the worksheet 'Plunits' needing to be entered in Column 'B', and the name of each and every destination that will be required in the allocation model entered across Row 4. The cost of transporting one unit of volume from an origin to a destination is then entered in the matrix. If the flow of volume from an origin to a destination is not allowed then leave the data blank for that particular matrix entry. An entry of zero ($0) is a valid entry and simply means that the cost of the transportation for that option is zero. [block:image] { "images": [ { "image": [ "https://files.readme.io/Y8DIXms1RUWQq1M7EY1n_worksheet-transport.jpg", "worksheet-transport.jpg", "1124", "634", "#255549", "" ], "sizing": "full" } ] } [/block] <br /> [block:callout] { "type": "danger", "title": "Important", "body": "Every planning unit origin that has been entered in Column 'F' on the worksheet 'Plunits' is required to be listed in Column 'B' of the worksheet 'Transport'. In addition, origins and destinations can only be entered once in Column 'B' and Row 4, and duplicate entries will cause an error to be raised when the forest description is imported." } [/block] <br /> [block:api-header] { "type": "basic", "title": "Worksheet 'Distance'" } [/block] The worksheet 'Distance' is an exact copy of the worksheet 'Transport', with only the data being changed from the unit cost of transport to the actual lead distance from an origin to a destination. The worksheet 'Distance' is used to work out the weighted average lead distances within the model. [block:callout] { "type": "info", "title": "Optional Worksheet", "body": "The worksheet 'Distance' is an optional worksheet in the forest description workbook." } [/block] The worksheet 'Distance' is exactly the same format as worksheet 'Transport' and is a lead distance matrix. [block:image] { "images": [ { "image": [ "https://files.readme.io/IzAqqxJQRiewPk6ntiNW_worksheet-distance.jpg", "worksheet-distance.jpg", "1123", "634", "#244e3a", "" ], "sizing": "full" } ] } [/block] <br /> [block:api-header] { "type": "basic", "title": "Worksheet 'Residue'" } [/block] It is possible to defined new products that can be used in the allocation model to satisfy destination specific wood demand requirements. These new products are called log residue products and arise from the conversion of the base log grade products defined in the forest description yield tables. Examples of typical log residue products would be wood chips and sawdust residues that can be used to satisfy part of the total wood demand at destinations such as a Pulp Mills, MDF Facilities or Bio-Energy plants. Log residues arise from the conversion of the base log grade products allocated to a destination. The destination becomes a new origin for the supply of log residue products. A transport cost is assigned to represent the cost of delivering the log residue products from it's origin to the destinations where the log residue has been allocated. Cash costs of production and sales revenues for log residue products can also be defined. [block:callout] { "type": "info", "body": "The worksheet 'Residue' is an optional worksheet in the forest description workbook.", "title": "Optional Worksheet" } [/block] Data always start at Cell 'B5'. The Columns 'B' to 'K' are mandatory, and must be kept in the same structure and location as the standard forest description template defines. Each row in the 'Residues' worksheet defines a time period across which a specific log residue product will be generated. [block:image] { "images": [ { "image": [ "https://files.readme.io/sAiQNYVJTwudPNYtXwdW_worksheet-residue.jpg", "worksheet-residue.jpg", "1124", "634", "#245543", "" ], "sizing": "full" } ] } [/block] A description of the data types and requirements for worksheet 'Residues' is below: [block:parameters] { "data": { "h-0": "-Column-", "0-0": "B & C", "0-1": "'Start' & 'End'", "h-1": "-Designation-", "1-0": "D", "1-1": "'Destination'", "2-0": "E", "2-1": "'Species'", "3-0": "F", "3-1": "'Product'", "4-0": "G & H", "5-0": "I", "4-1": "'Min' & 'Max'", "5-1": "'Factor'", "6-0": "J", "6-1": "'Name'", "7-0": "K", "7-1": "'Cash'", "0-2": "The starting and ending periods that form a range across which the log residue product defined in the same worksheet row can arise.", "1-2": "An existing destination within the forest estate model where the log grade product defined by Columns 'E' & 'F' is an allocated grade. This destination becomes a supply origin for the resulting log residue product.", "2-2": "The species of the log grade product that will be converted to a log residue product. The species/product combination must already be defined as a log grade that can be delivered to the destination stated in Column 'D'.", "3-2": "The log grade product that will be converted to a log residue product. The species/product combination must already be defined as a log grade that can be delivered to the destination stated in Column 'D'.", "4-2": "The minimum and maximum age of wood, between which the log grade product that can be converted to the log residue product. If the minimum and maximum age of wood is blank then any age is acceptable.", "5-2": "The factor used to convert the volume of log grade product to log residue product. For example, a factor of 0.36 means that for every 1 unit of log grade product delivered to the destination, then 0.36 units of the log residue product will arise.", "6-2": "The name of the log residue product being produced. This is subsequently used on both the 'Allocation' and the 'Price' worksheets when defining the allocation demand and selling price of the log residue product.", "7-2": "A Cost of Production (CPROD) cash flow item that is calculated and summarised in the modelling cash flows. This is applied on a converted basis, i.e. it is applied per unit of log residue product arising.", "h-2": "-Description Data-", "h-3": "" }, "cols": 3, "rows": 8 } [/block] [block:callout] { "type": "danger", "title": "Important", "body": "It is important to understand the economic effect of modelling log residue products. Often the costs and revenues of these products are ignored, and only the volumes are considered. The supply of log residue products in place of green roundwood log volume makes a demand easier to achieve. However, the contribution margin of the log residue products needs to be carefully modelled and understood. The total green roundwood equivalent (RWE) volume generated by the forest estate should not be attributed more economic margin than it otherwise should. That is, when using log residue products make sure that the net economic effect is not a double counting of the contribution margin of the log grade products that are converted to the log residue products." } [/block] <br /> ##Step 1 - Define Transport Costs and Distances Once a log residue product has been defined on the 'Residues' worksheet the destination at which the conversion occurs itself becomes an origin from which the log residue product is supplied. Therefore all destinations at which a log residue product is created need to be added to the Transport and Distance worksheets as valid origins. This is shown below, where in the example forest description data both the 'Plywood Mill' and the 'Saw Mill' destinations have been shown on the 'Residues' worksheet as destinations where log grade products are converted to log residue products. Therefore both the 'Plywood Mill' and the 'Saw Mill' destinations (shown in Green) are also allocation model origins and need a cost and distance defined for the destinations that use the log residue products in any allocation model demands. [block:image] { "images": [ { "image": [ "https://files.readme.io/kFfxsIsSj2gBhF1RVNIZ_worksheet-residue-transport.jpg", "worksheet-residue-transport.jpg", "1124", "634", "#275541", "" ], "sizing": "full" } ] } [/block] <br /> ##Step 2 - Add Log Residue Products to Demands Log residue products can be used to satisfy the allocation model demands for wood supply at any Destination as long as a valid entry on the 'Transport' and 'Distance' worksheets have been defined. They are used in exactly the same way as standard log grade products that are supplied in the underlying yield tables in the forest description. In the example below the log residue product 'Woodchip' has been allocated to the 'Pulp Mill' destination and can be used alongside any existing log grade products to satisfy the demand at this allocation model Destination. [block:image] { "images": [ { "image": [ "https://files.readme.io/jQVWDVnRses3HS55ShzO_worksheet-residue-allocation.jpg", "worksheet-residue-allocation.jpg", "1124", "634", "#28524e", "" ], "sizing": "full" } ] } [/block] <br /> ##Step 3 - Add Revenues for Log Residue Products Log residue products are given a selling price at the allocation model destinations in exactly the same way as log grade products. It is valid to make both the selling price and the transport cost equal to zero ($0) for on both the worksheets 'Price' and 'Transport'. A zero entry is valid and will allow the log residue product to be used in the relevant allocation model demands. [block:image] { "images": [ { "image": [ "https://files.readme.io/olFaY9TPRum5jM4aZgWg_worksheet-residue-price.jpg", "worksheet-residue-price.jpg", "1124", "634", "#245247", "" ], "sizing": "full" } ] } [/block] <br /> In the example below the wood supply to the 'Pulp Mill' destination is shown. The chart legend has been configured to show the modelling products, and the resulting chart shows the supply to the 'Pulp Mill' destination consists of both the 'Pulpwood' log grade product as well as 'Woodchip' log residue product. The allocation demand has therefore been achieved by using both green roundwood logs and green roundwood equivalent (RWE) woodchips. [block:image] { "images": [ { "image": [ "https://files.readme.io/jnJMm0uTn2RCumaIOlXA_worksheet-residue-results.jpg", "worksheet-residue-results.jpg", "1107", "781", "#2288d0", "" ], "sizing": "full" } ] } [/block]