杉原条材积电算技术初探

Preliminary Discussion on Electronic Technology of Chinese Fir Log Volume

根据材积计算的实际需要,介绍了函数使用原则和相关函数的使用方法,并用Excel软件编制杉原条材积电子表,重点举例说明杉原条材积数据自动输入及求和的函数公式编制方法。应用表明:与传统方法相比,提高了材积计算的效率和准确性。

According to actual needs of calculating volume,the paper introduces the use principles and related application of the function in Excel software,and preparing the worksheet for Chinese fir log volume in Excel,and especially illustrates the methods preparing Excel function formula to auto-input and auto-sum up volume data of Chinese fir log.The result indicates that this methods increase the efficiency and accuracy of the volume’s calculation compared with the traditional methods.