Excel code for: Trading off nature for nature-based solutions: The bioeconomics of forest management for wildlife, timber and carbon

This dataset contains MS Excel spreadsheet code used to analyze an integrative model that illustrates the inherent trade-offs that will arise among the competing values for landscape space in a boreal forest ecosystem involving interactions among the main trophic compartments of an intact boreal ecosystem, aka “nature”. The model accounts for carbon accumulation via biomass growth of forest trees (timber), carbon loss due to controls from moose herbivory that varies with moose population density (hunting), and soil carbon inputs and release, which together determine net ecosystem productivity (NEP), a measure of carbon sink strength of the ecosystem. We examine how controls on carbon dynamics are altered by forest management for timber harvest, and by moose hunting. We link the ecological dynamics with an economic analysis by assigning a price to carbon stored within the intact boreal forest ecosystem. We then weigh these carbon impacts against the economic benefits of timber production..., The Excel spreadsheet converts the analytical model into code to numerically calculate carbon benefits. Data in the article figures are generated using the spread code., , # Excel code for: Trading off nature for nature-based solutions: The bioeconomics of forest management for wildlife, timber and carbon

[https://doi.org/10.5061/dryad.j0zpc86p1](https://doi.org/10.5061/dryad.j0zpc86p1)

CODE AND DATA FROM

Trading off nature for nature-based solutions: the bioeconomics of forest management for wildlife, timber and carbon

Jonah Ury, Matthew J. Kotchen, and Oswald J. Schmitz

School of the Environment, Yale University 195 Prospect Street, New Haven, CT 06511 USA

## Description of the data and file structure

Overview

This file and overview is supplemental material accompanying the article \"Trading off nature for nature-based solutions: the bioeconomics of forest management for wildlife, timber and carbon.\" The assumptions are outlined in detail in the article's Appendix S1, and all model parameters, functions, and their literature sources are presented in Table S1. The analysis presented in the excel spreadsheet examines the interrelationships betwee...

本数据集包含用于分析整合模型的微软Excel（MS Excel）电子表格代码。该模型阐释了完整北方森林生态系统（即所谓的“原生自然”）的主要营养级组分间相互作用下，寒带森林生态系统景观空间内各类竞争性价值之间固有的权衡关系。

模型核算了林木生物量增长（木材）带来的碳积累、随驼鹿种群密度变化的驼鹿啃食调控所导致的碳损失（狩猎），以及土壤碳输入与排放，上述过程共同决定了净生态系统生产力（Net Ecosystem Productivity, NEP）——这是衡量生态系统碳汇强度的指标。

本研究探讨了木材采伐的森林经营活动与驼鹿狩猎如何改变碳动态的调控机制。我们通过为完整北方森林生态系统中储存的碳赋予经济价值，将生态动态与经济分析相结合，进而权衡碳汇效益与木材生产的经济收益……本微软Excel电子表格将分析模型转化为可数值计算碳汇效益的代码。论文配图中的数据均通过该电子表格代码生成。

# 适用于以下研究的Excel代码：《以自然换取基于自然的解决方案：野生动物、木材与碳汇的森林经营生物经济学》

[https://doi.org/10.5061/dryad.j0zpc86p1] 数据与代码来源：《以自然换取基于自然的解决方案：野生动物、木材与碳汇的森林经营生物经济学》
作者：Jonah Ury、Matthew J. Kotchen、Oswald J. Schmitz
单位：耶鲁大学环境学院，美国康涅狄格州纽黑文市展望街195号，邮编06511

## 数据与文件结构说明
### 概述
本文件及概述为论文《以自然换取基于自然的解决方案：野生动物、木材与碳汇的森林经营生物经济学》的补充材料。论文的附录S1详细阐述了模型假设，表S1则列出了所有模型参数、函数及其文献来源。本Excel电子表格所开展的分析旨在探讨各类相互关系……（原文此处存在笔误截断）