Excel表格在钢筋原材管理中的应用——以阿尔及利亚电厂项目为例

The Application of Excel Form in Reinforcement Raw Material Management--Taking Algeria Power Plant Project as an Example

Excel表格有强大的计算功能,深度挖掘其计算统计功能不仅可以提高数据统计的准确性,还可以做到及时与高效,与图表结合还可以实现可视化,本文利用Excel实现钢筋后台的发料、标签制作,月度的分类统计及季度、年度的汇总。同时对钢筋的超耗、库存实现适时查询。

Excel tables have powerful calculation functions.In-depth mining of its calculation and statistics functions can not only improve the accuracy of data statistics,but also be timely and efficient.It can also be combined with charts to achieve visualization.This article uses Excel to realize the release of steel bars in the background,Label production,monthly classified statistics and quarterly and annual summary.At the same time,timely query on the over-consumption and inventory of steel bars can be realized.