Patent attributes
A computer software program for improving electronic spreadsheets to manage and control scenarios. The program provides methods for the user to record specific changes made to selected value of cells in the spreadsheet. Each recorded item can be dragged and re-ordered via a graphical user interface (GUI) to build up a scenario script. The script can be executed whereby the spreadsheet is updated with the recorded items. The method allows complex scenarios to be played back in step by incremental step, modified, re-ordered, corrected, and re-played while generating user-defined output reports & charts detailing each step change. The method provides a detailed information trail of all value changes made to the spreadsheet suitable for an independent third-party review. Different scenario components can be recorded in parallel by multiple users and then merged to produce a complete solution. The method is scalable and suitable for scenarios requiring thousands of cell value updates (subject to available computer memory, operating system limitations, and calculation time constraints).