The development of data collection tool on spreadsheet format

Abstract

Spreadsheet is one of types application that commonly used for various usages including data collection. Using spreadsheet has several advantages over other types of data collection applications (e.g., web-based form, e-form, manual form). The most visible advantage is that many people know how to use spreadsheet. In addition, spreadsheet has many features and capabilities related to data analysis and processing. Therefore, spreadsheet is often the primary choice in collecting and processing data. However, using spreadsheet as data collector, has several problems, such lack of support for: collaboration, input validation, and data retention. By creating an additional tool within the spreadsheet, we could propose a new means to collect the data using spreadsheet format and yet simpler and more efficient and effective.