I present a new software that links a program for image analysis (SigmaScan), one for spreadsheets (Excel) and one for statistical analysis (R) for applications of tree-ring analysis. The first macro measures ring width marked by the user on scanned images, stores raw and detrended data in Excel and calculates the distance to the pith and inter-series correlations. A second macro measures darkness along a defined path to identify latewood–earlywood transition in conifers, and a third shows the potential for automatic detection of boundaries. Written in Visual Basic for Applications, the code makes use of the advantages of existing programs and is consequently very economic and relatively simple to adjust to the requirements of specific projects or to expand making use of already available code.

中文翻译：

---

使用 Excel、R 和 SigmaScan 测量和分析树轮的简单程序

我展示了一个新软件，它链接了一个图像分析程序 (SigmaScan)、一个用于电子表格 (Excel) 的程序和一个用于树轮分析应用程序的统计分析 (R)。第一个宏测量用户在扫描图像上标记的环宽度，将原始数据和去趋势数据存储在 Excel 中，并计算到髓的距离和系列间相关性。第二个宏沿着定义的路径测量黑暗，以识别针叶树中的晚材-早材过渡，第三个显示自动检测边界的潜力。该代码使用 Visual Basic for Applications 编写，利用了现有程序的优点，因此非常经济且相对简单，可以根据特定项目的要求进行调整或扩展利用现有代码。