INTEGRATED GROWTH MODELLING AND HARVEST SCHEDULING WITH SPREADSHEETS

概要

論文の詳細を見る
A diameter distribution growth and yield model for Caribbean pine and a linear programming (LP) harvest scheduling model were dynamically integrated so that they could be operated routinely through a mixture of macros and spreadsheets on a PC. The growth and yield model produces stock table estimates of log assortments via equations predicting net basal area/ha, maximum diameter at breast height outside bark, standard deviation of all diameters at breast height over bark and number of stems per hectare at any future age from inputs of basal area/ha, maximum diameter at breast height and side bark, standard deviation of diameters at breast height and stems/ha at a specified age, together with initial stocking and use of a Reverse Weibull probability density function. The LP model can be used to schedule harvests annually from numerous stands or blocks for up to seven years ahead subject to constraints on areas available, allowable logging methods, logging productivity, equipment and manpower productivity, market demands and storage capacities at ports or utilisation plants. The use of spreadsheets catered for sophisticated matrix generation and report-writing, while also providing a simple means of integrating the harvest scheduling model with outputs from the growth and yield model.
森林計画学会の論文