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

WANG Jian1,2,WU Fan1,2,CHENG Guo-feng1,2(1 Key Laboratory of Fishery Equipment and Engineering,Ministry of Agriculture,2 Fishery Machinery and Instrument Research Institute,Chinese Academyof Fishery Sciences,Shanghai 200092,China)

budget estimate;Excel;function;standardized aquafarm

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 check 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.