Automating sales spreadsheet program usability test.

Abstract

Nowadays, most data are multi-dimensional data which are complex, unconnected and undesired format. Employees take hours or even day in cleaning and transforming data into a desired format before generating a report. The automatic program enables reduce time consumption in completing tasks. Hence, the purpose of this research is to initiate and test usability of the automating sales spreadsheet program that helps employees to automatically turn data into a desired format. Research scope is comparing time taken in completing the assigned task between using the program and manual process. It has been proven that Microsoft Excel is an important tool in extracting data in order to get insight, especially add-in function which is called VBA. Moreover, a good program should pass through SDLC framework. Also usability test has to be conducted to assess quality of the program with real time user testing. The quantitative in term of experimentation design is used in this research. By developing the program and conduct usability test with 60 employees in a consumer goods company in order to do Paired T-test based on the two assumptions. As a result, the automatic program enables employees to significantly reduce time spent in completing tasks along with simplified work process. Whether employees are programmer or non-programmer, they can take the same amount of time just a few minutes in completing the same task.