Spreadsheet engineering is the process of constructing fast, robust, modular, testable and re-usable spreadsheets. The spreadsheet is the most ubiquitous software in the world and we find it quite interesting that there is serious dearth of design principles or methodologies or best practices surrounding spreadsheets.

Old spreadsheets are often convoluted, undocumented and tend to break easily when even the smallest changes are made to them. Many companies now find themselves increasingly dependent on spreadsheets that have matured over time but whose internal logic and dependencies are neither formalized, consistent nor scalable. Popular due to their intuitive spatial interface, spreadsheets that have evolved into critical applications pose a serious risk to businesses everywhere.

The cost of Spreadsheet Engineering is geometric as the complexity of cell interdependencies increases. Referential dependencies within spreadsheets and hard-coded functions further complicate the matter. As the need to share spreadsheets becomes more acute, the time-consuming effort required to ensure validity and consistency becomes prohibitive.

Learn more about real-world examples of the risks behind using spreadsheets, particularly the financial risks.

Download our datasheet on the differences between spreadsheets and enterprise-class systems that act like a spreadsheet.

Contact us to learn more about topics like the following:

• Migrating excel spreadsheets to a database
• Modularizing spreadsheets for re-use
• Implementing spreadsheet version control
• Increasing the performance of heavy spreadsheets
• Reverse engineering spreadsheet logic