Why People Like Spreadsheets So Much

Business applications in use today are based on a variety of software platforms.  The primary business tool used for maintaining tabular datasets is clearly spreadsheets.  Web-based and thick-client applications offer better data integrity enforcement and change control, but often lack many of the benefits of spreadsheets.  The two primary reasons why users like spreadsheets, and are therefore willing to live without the data integrity enforcement and change control features of software applications, is the ability to sort data on multiple columns and the ability to update and/or add multiple records of data with a single “save” action.  Without these features, the workflow design is less-efficient and wastes end-user’s time

Thick-client application development is accomplished with a variety of grid control components that try to simulate a spreadsheet, but after displaying multiple records, they usually lack an ability to sort on multiple columns without a lot of customization.   Grid controls are usually read-only, require multiple clicks to edit a single record at a time , and hamper the efficiency of process automation.

Web-based applications usually have the same issues as their thick-client counterparts.  The DataGridView is read-only and multiple clicks are required to save changes on multiple records.  Web-based application development also does not typically include any ability to sort on multiple columns.

End-user support for spreadsheet applications is a challenge that can’t be solved by sharing files on a shared cloud space or server hard drive like Microsoft Sharepoint.  Sharing a spreadsheet file does not make it multi-user, and further complicates any attempt to enforce data integrity or manage change control of your tabular data.

Another feature of spreadsheets that drive users to them is the ability to copy multiple rows of data into new rows of data.  No thick-client and only ONE web-based application, Transaction Editor, allows a user to copy existing rows to create new rows of data in a data integrity-controlled environment.

Konduit’s Transaction Editor is unique in that it solves all of these problems with a single platform and support service.  It can replace your spreadsheets with a robust web-based application that offers a workflow design that reduces clicks to complete multi-record updates, allows multi-column sorting, and the ability to copy multiple rows of data to facilitate adding new data records.  Transaction Editor combines the ease-of-use of a spreadsheet with  the robust data integrity and change control management of  a truly multi-user database application.  It even supports multi-table relational data integrity backed by professional database development and design.

Leave a Reply

Your email address will not be published. Required fields are marked *