Increased Productivity

Spreadsheet Pain

‘Simple’ changes often require many manual operations
- Huge numbers of cell formulas
- Inserting and deleting cells, rows and columns, editing and copying formulas, re-laying worksheets
Modelers must frequently look up the meanings of cell addresses
- Formulas are expressed with cell addresses, not named variables
Modelers must act at cell level
- Though key concepts are at higher level of variables
- Dependent and precedent cells, not variables

Automates manual cell-level operations such as roll-ups, thus saving time
Readable symbolic variables and formulas reduces time spent in understanding existing models
Uses far fewer formulas which reduces the need to write and check cell-level formulas
Re-usable Dimensions and time series cut down repetitive tasks
Partial automation of sheet layout and automatic layout adjustments save time

This view shows the web worksheet in ModelSheet.

The table below compares how to insert quarterly sums in Excel and in ModelSheet.

Insert Quarterly Sums in Excel	Insert Quarterly Sums in ModelSheet
Insert a new column for each quarter in each table on each sheet. Do not disturb other tables. Type in header titles for each new column. Insert summation formulas in each cell in the new columns. Find and fix all formulas that assume a row consists of all monthly cells.	In tab “Overview” for the workbook, click on button “Styles.” Apply style “year sums”.

Microsoft, Excel and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.