摘要
EXCEL已广泛用于水利水电工程概预算编制中。根据VLOOKUP函数功能,创建定额库,实现单价的自动分析、主要材料的工程量的自动计算。结合实例,使用VLOOKUP函数有效地提高概预算的编制效率。
Excel has been widely used in budget estimate of hydraulic and hydropower engineering. Quota base is created according to vlookup function to realise automatic analysis of unit price and au- tomatic calculation of main materials quantity. The use of VL00KUP function can increase the effi- ciency of budget estimate efficiently with the combination of examples.
出处
《水利科技与经济》
2014年第3期44-46,共3页
Water Conservancy Science and Technology and Economy
