Design and Achievement of Work Measurement System Based on VBA
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.
D. Liang and F. R. Zhang, "Design and Achievement of Work Measurement System Based on VBA", Advanced Materials Research, Vols. 268-270, pp. 2048-2053, 2011