Spreadsheets are one of the most frequently used applications. They are used because they are easy to understand and values can be updated easily. However, many people try to use spreadsheets for problems beyond their intended scope and end up with errors and miscalculations. We present a new spreadsheet system which uses complex-values and equation code reuse to overcome the limitations of spreadsheets for complex problems. We also discuss the features necessary in order to make these enhancements useful and effective.
College and Department
Physical and Mathematical Sciences; Computer Science
BYU ScholarsArchive Citation
Whitmer, Brian C., "Improving Spreadsheets for Complex Problems" (2008). Theses and Dissertations. 1713.
spreadsheets, interactivity, usability, complex problems