Design and Achievement of Work Measurement System Based on VBA

Abstract:

To improve the efficiency and accuracy of work measurement of IE, system using VBA language as well as Windows API function is developed on Excel platform. It can record data, eliminate abnormal value, determine measurement times, and calculate measurement periods automatically. And like record, calculation and analysis, these primitive handworks are replaced by work measurement system now. To compare data between measurements on spot and handworks, work measurement problem is solved efficiently and accurately at last.

• Periodical: Advanced Materials Research (Volumes 268-270)
• Pages: 2048-2053
• DOI: https://doi.org/10.4028/www.scientific.net/AMR.268-270.2048
• Online since: July 2011
• Authors: Di Liang, Feng Rong Zhang
• Keywords: API, Excel VBA, Work Measurement

References

[1] Yi Shuping, Guo Fu, Basic Industrial Engineering, Beijing: Mechanical Industry Press, 2006. 1, pp.36-48.

[2] Zhang Xun, Introduction to VBA and Typical Case, Tsinghua University Press, 2007. 8, pp.40-57.

[3] Zhang Like．Windows API Program Design Reference, Beijing: Posts & Telecom Press, 2006. 4, pp.15-40.

[4] Guo Fu，Zhang Guomin. Work Study Applied to Flow Production Line., Industrial Engineering and Management, vol. 10, no. 2, pp.120-124, 2005, 2.