Simply a smarter spreadsheet.
Spreadsheets are powerful tools for helping make decisions, but complexity and errors are all too common. Sumwise was designed to make models easier to create and understand, and to solve the problem of errors in spreadsheets.
And once a Sumwise model has been built, it is much easier and safer for users of this model to make changes like adding new rows and columns, or even changing formulas and logic. Unlike traditional spreadsheets, Sumwise models are structured to anticipate and allow these kinds of changes.
Sets of rows or columns that can be defined once and then used in multiple places throughout your model.
For example your business might have products A and B. Instead of typing these line items every time you need this level of detail, you can define the set named Products and then apply this to any node (row or column) in your model.
Now any changes to these items (insertions, deletions, reordering, etc) are automatically reflected everywhere in your model where this modelet is used.View Video
Structure and nest your rows and columns
to reflect the logic of your model.
In Sumwise this structure is not just visual—rows and columns can be referenced by their structural positions, e.g., Children, Siblings, and Parent.
Add up all the columns under Q1 by saying =SUM(C[Children]).See it in action
Tag rows and columns with keywords, and reference these tags directly in your formulas.
Sumwise lets you add meaningful metadata, in the form of tags, to your rows and columns. For example, Q1 can be tagged as a Quarter, and Jan, Feb, Mar can be tagged as Months. You can then use these tags to write powerful formulas.
You can refer to the previous month as =[@Month-1].See it in action
Group cells together logically to let them share a common formula and formatting.
Quickly and easily define groups of cells which go together logically, e.g., you may want all rows tagged as Subtotals to have the same formula.
Grouping these cells saves you from potentially error prone copy and pasting, and allows you to maintain the consistency and accuracy of these cells.
You can also easily extend your model by adding new rows and columns; the new cells will automatically get the correct formulas and formatting from the cell groups.See it in action
You decide what to call your rows and columns,
and use these names to reference cells.
Imagine a typical spreadsheet formula =X9-X10. What does this mean? Is it correct? In Sumwise, formulas say what they mean, and mean what they say.
=[Revenue]-[Cost of sales] is easier to understand, and easier to check.See it in action