Published July 8, 2024 | Version v1.0.2_excel
Software Open

woodValuationDE: Wood Valuation Germany (MS Excel version)

Authors/Creators

  • 1. Forest Resources Management, Institute of Terrestrial Ecosystems, Department of Environmental Systems Science, ETH Zurich
  • 2. Department of Forest Economics and Sustainable Land-use Planning, University of Göttingen
  • 3. Federal Forest Service HessenForst
  • 4. Department of Forest Economics, University of Göttingen
  • 5. Bavarian State Forest Enterprise
  • 6. Department of Forest Growth, Northwest German Forest Research Institute
  • 7. ARGUS Forstplanung
  • 8. Forestry Consultant
  • 9. Centre of Biodiversity and Sustainable Land Use, University of Göttingen

Description

woodValuationDE is an R package available at https://cran.r-project.org/package=woodValuationDE (released CRAN package) and https://github.com/Forest-Economics-Goettingen/woodValuationDE (devel, README). This file provides an example how the underlying models can be implemented as wood valuation framework in MS EXCEL. Please note that the functionalities/options of the EXCEL implementation may not cover all functionalities of the R package and that the current, stable version of the package may only be provided in R.

woodValuationDE EXCEL version:
v1.0.2_excel

Package version used for this implemenation:
v1.0.2

Package description:
Monetary valuation of wood in German forests (stumpage values), including estimations of harvest quantities, wood revenues, and harvest costs. The functions are sensitive to tree species, mean diameter of the harvested trees, stand quality, and logging method. The functions include estimations for the consequences of disturbances on revenues and costs.
The underlying assortment tables are taken from Offer and Staupendahl (2018) with corresponding functions for salable and skidded volume derived in Fuchs et al. (2023). Wood revenue and harvest cost functions were taken from v. Bodelschwingh (2018). The consequences of disturbances refer to Dieter (2001), Möllmann and Möhring (2017), and Fuchs et al. (2022a, 2022b). For the full references see documentation of the functions, package README, and Fuchs et al. (2023). Apart from Dieter (2001) and Möllmann and Möhring (2017), all functions and factors are based on data from HessenForst, the forest administration of the Federal State of Hesse in Germany.

For further information and the limitations see:
technical note:
Fuchs, Jasper M.; Husmann, Kai; v. Bodelschwingh, Hilmar; Koster, Roman; Staupendahl, Kai; Offer, Armin; Möhring, Bernhard; Paul, Carola (2023): woodValuationDE: A consistent framework for calculating stumpage values in Germany (technical note). Allg. Forst- u. J.-Ztg. 193 (1/2), p. 16-29. doi: 10.23765/afjz0002090.
package README:
https://github.com/Forest-Economics-Goettingen/woodValuationDE

Recommended citation:
Fuchs, Jasper M.; Husmann, Kai; v. Bodelschwingh, Hilmar; Koster, Roman; Staupendahl, Kai; Offer, Armin; Möhring, Bernhard; Paul, Carola (2023): woodValuationDE: A consistent framework for calculating stumpage values in Germany (technical note). Allg. Forst- u. J.-Ztg. 193 (1/2), p. 16-29. doi: 10.23765/afjz0002090.
For details on the applied models and underlying assumptions, such as assumptions on the economic consequences of disturbances, please also cite the original publication(s).

Version history
v1.0.1_excel: initial upload
v1.0.2_excel: updated citation information, technical note

Notes

This work is part of a PhD project by J.F., partly financed by the University of Göttingen and supported by the Graduate School Forest and Agricultural Sciences Göttingen. J.F. further acknowledges partial funding through the Federal Ministry of Education and Research Germany (BMBF) in the 2019-2020 BiodivERsA joint call for research proposals, under the BiodivClim ERA-Net COFUND programme, and with the funding organisations Academy of Finland (decision no. 344722), ANR (France, project ANR-20-EBI5-0005-03), and Federal Ministry of Education and Research (Germany, grant no. 16LC2021A).

Files

Files (140.6 kB)

Name Size Download all
md5:0b51ca0cb3ce10a7bbe0b1d7a3b5733e
140.6 kB Download

Additional details

Related works

Is described by
Software: https://github.com/Forest-Economics-Goettingen/woodValuationDE (URL)
Technical note: 10.23765/afjz0002090 (DOI)
Is supplement to
Software: https://cran.r-project.org/package=woodValuationDE (URL)

References

  • AfL (ed.) (2014): AfL-Info 2014/15. Richtpreise, Tarife, Kalkulationen, Adressen. [Reference prices, tariffs, calculations, addresses]. AfL Niedersachsen e.V. Hannover: Deutscher Landwirtschaftsverlag.
  • Curtis, Robert O., Marshall, David D. (2000): Technical Note: Why Quadratic Mean Diameter? West. J. Appl. For. 15 (3), S. 137-139. https://doi.org/10.1093/wjaf/15.3.137.
  • Deutscher Forstwirtschaftsrat e.V.; Deutscher Holzwirtschaftsrat e.V. (2020): Rahmenvereinbarung für den Rohholzhandel in Deutschland (RVR). [Master Agreement for Raw Wood Trading in Germany]. 3rd ed. Fachagentur Nachwachsende Rohstoffe e.V. (FNR). Guelzow-Pruezen. Online available at https://mediathek.fnr.de/rahmenvereinbarung-fuer-den-rohholzhandel-rvr.html.
  • Dieter, Matthias (2001): Land expectation values for spruce and beech calculated with Monte Carlo modelling techniques. For. Policy Econ. 2 (2), S. 157-166. https://doi.org/10.1016/S1389-9341(01)00045-4.
  • Fischer, Christoph; Schoenfelder, Egbert (2017): A modified growth function with interpretable parameters applied to the age–height relationship of individual trees. Can. J. For. Res. 47, S. 166–173. https://doi.org/10.1139/cjfr-2016-0317.
  • Fuchs, Jasper M., Hittenbeck, Anika, Brandl, Susanne, Schmidt, Matthias, Paul, Carola (2022a): Adaptation Strategies for Spruce Forests - Economic Potential of Bark Beetle Management and Douglas Fir Cultivation in Future Tree Species Portfolios. Forestry 95 (2), S. 229-246. https://doi.org/10.1093/forestry/cpab040
  • Fuchs, Jasper M., v. Bodelschwingh, Hilmar, Paul, Carola, Husmann, Kai (2022b): Quantifying the consequences of disturbances on wood revenues with Impulse Response Functions. For. Policy Econ. 140, art. 102738. https://doi.org/10.1016/j.forpol.2022.102738.
  • KWF (ed.) (2006): Holzernteverfahren - Vergleichende Erhebung und Beurteilung, Daten CD mit Beschreibung der Ernteverfahren und Kalkulationen. [Wood harvesting methods - Comparative survey and assessment, data CD with description of harvesting methods and calculations.]. Groß-Umstadt: KWF.
  • Moellmann, Torsten B.; Moehring, Bernhard (2017): A practical way to integrate risk in forest management decisions. Ann. For. Sci. 74 (4), S. 75.
  • Offer, Armin; Staupendahl, Kai (2008): Neue Bestandessortentafeln für die Waldbewertung und ihr Einsatz in der Bewertungspraxis. [New stand assortment tables for forest valuation and their application in valuation practice.]. Wertermittlungsforum 26 (4), S. 146-154.
  • Offer, Armin; Staupendahl, Kai (2009): Neue Bestandessortentafeln für die Waldbewertung und ihr Einsatz in der Bewertungspraxis. [New stand assortment tables for forest valuation and their application in valuation practice.]. Forst und Holz 64 (5), S. 16–25.
  • Offer, Armin and Staupendahl, Kai (2018): Holzwerbungskosten- und Bestandessortentafeln (Wood Harvest Cost and Assortment Tables). Kassel: HessenForst (publisher).
  • Schoepfer, W., Kaendler, G., Stoehr, D. (2003): Entscheidungshilfen für die Forst- und Holzwirtschaft - Zur Abschlussversion von HOLZERNTE. [Decision Support for Forestry and Wood Industry - The Final Version of HOLZERNTE]. Forst und Holz 58 (18), S. 545–550.
  • v. Bodelschwingh, Hilmar (2018): Oekonomische Potentiale von Waldbestaenden. Konzeption und Abschaetzung im Rahmen einer Fallstudie in hessischen Staatswaldflaechen [Economic Potentials of Forest Stands and Their Consideration in Strategic Decisions]. Bad Orb: J.D. Sauerlaender`s Verlag (Schriften zur Forst- und Umweltoekonomie, 47).
  • Fuchs, Jasper M., Husmann, Kai, v. Bodelschwingh, Hilmar, Koster, Roman, Staupendahl, Kai, Offer, Armin, Möhring, Bernhard, Paul, Carola (2023): woodValuationDE: A consistent framework for calculating stumpage values in Germany (technical note). Allg. Forst- u. J.-Ztg. 193 (1/2), p. 16-29. https://doi.org/10.23765/afjz0002090.