{"_id":"580f343817899037007075f3","__v":9,"initVersion":{"_id":"574a3bc0d1d1381900b73fae","version":"3517"},"project":"574a3bc0d1d1381900b73fab","user":{"_id":"574bfb9290d8b32000864973","username":"","name":"Tigermoth Support"},"metadata":{"title":"","description":"","image":[]},"createdAt":"2016-10-25T10:30:16.706Z","changelog":[{"_id":"580f343817899037007075f5","update":"- The templates for reporting forest value now automatically include all the items that have been modelled using the ‘Other’ worksheet.  Functionality has been added that allows the selection of an entity or entities that are shown on the ‘Other’ worksheet.  In addition a setting to toggle the inclusion of these cash flows on or off has been added to the Summary worksheet.","type":"added"},{"_id":"580f343817899037007075f4","update":"- A switch to toggle the inclusion of cash flows from tertiary residue products such as wood chip and sawdust residues has been added.  Only the workbook called ‘Valuation – Large format all rotations with multiple thinnings.xlsb’ can report these residue cash flows.","type":"added"},{"_id":"580f34d07567d725004986e3","update":"- The two original spread-back templates have been removed and replaced with a single new template that can toggle between the spread-back of Current and Future rotation volumes and cash flows","type":"added"},{"_id":"580f3536b825d60f00d2666b","update":"- The ‘revenue from other operations’ on the Current, Future and Perpetual worksheets of the large format forest valuation workbook has been moved to be below (and so excluded from) the calculation of operating margin.","type":"improved"},{"_id":"580f37c3b01c672500586064","update":"- If a user-defined pivot table is added to a new worksheet in a forest valuation workbook, then if the pivot table name is prefixed with IGNORE the ConnectionString of the pivot table will be updated to the model that is selected by the user but the CommandText of the pivot table will not be changed from that defined by the user.  Example “IGNORE My Pivot Table”.","type":"improved"},{"_id":"580f38c017899037007075fa","update":"- If a user-defined pivot table is added to a new worksheet in a forest valuation workbook, then if the pivot table name is prefixed with USERDEFINED then neither the ConnectionString or the CommandText of the pivot table will not be changed from that defined by the user.  Example “USREDEFINED My Pivot Table”.","type":"improved"},{"_id":"580f38f9b01c672500586065","update":"- Where additional overhead costs can be defined in the valuation workbook, such as percentage of operational expenditure and additional costs per cubic meter harvested, the underlying formula has been changed to =MIN( 0 , COST ) so that a positive number cannot be generated.  These additional overhead costs can now not be a positive number unless the user changes this formula.","type":"added"},{"_id":"580f39a6b01c672500586066","update":"- A series of additional checks and balances have been added to reconcile the sum totals of operational expenditure and other cost items directly with the values presented in the raw pivot tables.  These have only been added in the large scale valuation workbook.","type":"added"},{"_id":"580f39fc9b8f791b00e40f4e","update":"- The template for reporting the carbon stocks and sequestration within the forest estate model has been re-developed and improved.  Standing carbon calculations have been expanded and clarified, and end users are free to add addition functionality to the carbon template based on the calculated stocks of CO2 equivalent within the estate.","type":"added"},{"_id":"580f3b12b825d60f00d26672","update":"","type":"added"}],"body":"Additions, changes and corrections available in this build:","slug":"3517100606128","title":"3517.10060.6128"}

3517.10060.6128


Additions, changes and corrections available in this build:
added
- The templates for reporting forest value now automatically include all the items that have been modelled using the ‘Other’ worksheet. Functionality has been added that allows the selection of an entity or entities that are shown on the ‘Other’ worksheet. In addition a setting to toggle the inclusion of these cash flows on or off has been added to the Summary worksheet.
added
- A switch to toggle the inclusion of cash flows from tertiary residue products such as wood chip and sawdust residues has been added. Only the workbook called ‘Valuation – Large format all rotations with multiple thinnings.xlsb’ can report these residue cash flows.
added
- The two original spread-back templates have been removed and replaced with a single new template that can toggle between the spread-back of Current and Future rotation volumes and cash flows
improved
- The ‘revenue from other operations’ on the Current, Future and Perpetual worksheets of the large format forest valuation workbook has been moved to be below (and so excluded from) the calculation of operating margin.
improved
- If a user-defined pivot table is added to a new worksheet in a forest valuation workbook, then if the pivot table name is prefixed with IGNORE the ConnectionString of the pivot table will be updated to the model that is selected by the user but the CommandText of the pivot table will not be changed from that defined by the user. Example “IGNORE My Pivot Table”.
improved
- If a user-defined pivot table is added to a new worksheet in a forest valuation workbook, then if the pivot table name is prefixed with USERDEFINED then neither the ConnectionString or the CommandText of the pivot table will not be changed from that defined by the user. Example “USREDEFINED My Pivot Table”.
added
- Where additional overhead costs can be defined in the valuation workbook, such as percentage of operational expenditure and additional costs per cubic meter harvested, the underlying formula has been changed to =MIN( 0 , COST ) so that a positive number cannot be generated. These additional overhead costs can now not be a positive number unless the user changes this formula.
added
- A series of additional checks and balances have been added to reconcile the sum totals of operational expenditure and other cost items directly with the values presented in the raw pivot tables. These have only been added in the large scale valuation workbook.
added
- The template for reporting the carbon stocks and sequestration within the forest estate model has been re-developed and improved. Standing carbon calculations have been expanded and clarified, and end users are free to add addition functionality to the carbon template based on the calculated stocks of CO2 equivalent within the estate.