Spreadsheet Widget

When modelling a business case, users must be able to specify input parameters flexibly. This is what they can do in Excel. In Lean-Case, we provide you maximum flexibility for entering assumptions with what -we-call the spreadsheet widget. Wherever you see this table icon next to a parameter in Lean-Case you can use the Spreadsheet Widget.

The purpose of the Spreadsheet Widget is to capture a data series with varying numbers over time which cannot be easily created using other Lean-Case widgets, e.g. to

  • increase the price for a seasonal time
  • reflect a decreasing churn rate over time
  • enter a one-time expense
  • enter a hiring plan capture a new revenue stream or
  • capture actuals

The Spreadsheet Widget provides high flexibility to enter a series of data over time:

  1. 1
    create a data series
  2. 2
    upload a data series
  3. 3
    edit a series

Widget Controls

In order to look at the data, there are three major controls

  • Monthly / Quartely / Yearly Selection
  • Values / Increments / Percentage View
  • Editing / Viewing Mode

Simply select for which of the 3 time periods you want to look at your data series. The data is cumulated. 

The second control helps you to look at the data series in 3 different views

  • the Value View shows the absolute values of your data series