| 注册
首页|期刊导航|渔业现代化|基于Excel的标准化水产养殖场工程概算编制方法

基于Excel的标准化水产养殖场工程概算编制方法

王健 吴凡 程果锋

渔业现代化2011,Vol.38Issue(2):32-36,5.
渔业现代化2011,Vol.38Issue(2):32-36,5.

基于Excel的标准化水产养殖场工程概算编制方法

Compilation method for budget and budget estimate of standardized aquafarm base on excel

王健 1吴凡 2程果锋1

作者信息

  • 1. 农业部渔业装备与工程重点开放实验室,上海,200092
  • 2. 中国水产科学研究院渔业机械仪器研究所,上海,200092
  • 折叠

摘要

Abstract

The cost of the modification project for standardized aquafarm in Shanghai City is mainly analyzed with calculator by manual work at present, which is time-consuming with high error rate. On account of this problem, we used Excel, which has powerful data-handing capacity and provides various functions, such as ROUND, COUNT, and so on. Excel was used to build sophisticated data channel to make a clear worksheet,which can achieve the automatic transformation of engineering designing data and budgetary estimation, and autonomously finish the checking between the designing data of planning chart and the criterion of standardized aquafarm. It improved the adjustability of the sheet, and once the designing data of the planning chart was input, the budgetary estimation of the project investment can be achieved immediately, and so did the cheek results. The result showed the intellectualization of the project budgetary estimation was preliminarily realized,which improved the work efficiency and accuracy in computation, and saved time for design of standardized aquafarm.

关键词

标准化水产养殖场/工程概算/Excel/函数

Key words

budget estimate/ Excel/ function/ standardized aquafarm

分类

农业科技

引用本文复制引用

王健,吴凡,程果锋..基于Excel的标准化水产养殖场工程概算编制方法[J].渔业现代化,2011,38(2):32-36,5.

渔业现代化

OA北大核心

1007-9580

访问量0
|
下载量0
段落导航相关论文