| OFFSET函数在统计连续测定温度数据中的应用 |
| |
| 引用本文： | 武占会,杨恩庶,齐艳花,于平彬,陈海丽,刘明池.OFFSET函数在统计连续测定温度数据中的应用[J].农业网络信息,2013(12):43-47. |
| |
| 作者姓名： | 武占会 杨恩庶 齐艳花 于平彬 陈海丽 刘明池 |
| |
| 作者单位： | [1]北京市农林科学院蔬菜研究中心,北京100097 [2]农业部都市农业（北方）重点实验室,北京100097 [3]北京市大兴区蔬菜技术推广站,北京102600 |
| |
| 基金项目： | 国家科技支撑计划资助项目（编号：2011BAD12B01）;国家“863”计划资助项目（编号：2013AA103005）;国家大宗蔬菜产业技术体系资助项目（编号：CARS-25-G-01）;北京市农林科学院科技创新基金资助项目（编号：CXJJ201306）. |
| |
| 摘 要： | 介绍了一种利用Excel软件的OFFSET函数，通过此函数来统计一定时期内连续测定温度数据的日变化，并做成了通用模板，这种方法将改变以往以繁琐为主的统计工作，从而使得统计工作变的轻松、愉快，且工作效率得到提高。
|
| 关 键 词： | Excel OFFSET函数 统计 连续测定 日变化 |
Application of OFFSET Function in the Statistics of Continuous Temperature Measurement |
| |
| WU Zhanhui,YANG Enshu,QI Yanhua,YU Pingbin,CHEN Hailing,LIU Mingchi.Application of OFFSET Function in the Statistics of Continuous Temperature Measurement[J].Agriculture Network Information,2013(12):43-47. |
| |
| Authors: | WU Zhanhui YANG Enshu QI Yanhua YU Pingbin CHEN Hailing LIU Mingchi |
| |
| Institution: | 1.Beijing Vegetable Research Center, Beijing Academy of Agriculture and Forestry Sciences, Beijing 100097 2.Key Laboratory of Urban Agriculture (North), Ministry of Agriculture, P.R.China, Beijing 100097; 3.Beijing Vegetable Technology Service Station of Daxing, Beijing 102600) |
| |
| Abstract: | This article introduced a kind of OFFSET function used of Excel software, through the function to count the continuous determination of the diurnal variation of the temperature data in certain period of time, and made the general template. This approach will change the statistical work of past into the statistical work of relaxed and happy, and the efficiency will be improved. |
| |
| Keywords: | Excel OFFSET function statistics continuous determination day change |
| 本文献已被 维普 等数据库收录！ |
