Test the impact of each variable by making changes to the cell ranges. Use Lugano to record each of these versions.
Quickly find previous versions and select to view the data.
Combine versions to create new scenarios. Resequence your versions to better communicate your findings. Compare, review and adjust in minutes.
Create waterfall charts to see how each variable in each scenario affects the final result. Make as many as you want, whenever you need.
Quickly execute multiple scenarios to test theories and impacts.
Create reports so you can easily find the information you need when presenting to managers or executives. If there are changes, automatically update reports to match.
Lugano is a COM add-in for Microsoft Office Excel.
Scenarios require continuous time-consuming modifying of the model with pre-loaded lookup values and indirect structures. Continuously reworking models increases the validation effort and the risk of introducing errors. With Lugano you record new version values directly into the model, change any cell at its logical location, create versions on the fly, and then collate your version to create scenarios.
No more impenetrable black-box outputs from all-in-one go calculations. Lugano simplifies the interpretation of complex outcomes by reducing them to simple bite size changes. Lugano’s step-by-step approach makes it easy to demonstrably validate complex and counter-intuitive results. Lugano’s reports will provide the assurance to satisfy management.
No manual preparation of data logs. Manual processes are slow and unreliable. Lugano logs all your changes automatically. You can check and review all the changes with confidence. No more omissions. Full audit logs are created automatically.
No more idiosyncratic scenario structures which only the author can fathom. Lugano applies a systematic method to scenarios. New users will know what to expect. Users can replay scenarios and follow their dynamic evolution.
Chop and change versions, edit data and rerun your scenarios effortlessly. Your automated scripts will faithfully replay all your steps and re-create your outputs. No longer will so called “small changes” delay and tangle up your analysis.
No more bloated models. As layers of scenarios are inserted, the models become filled with earlier assumptions and the logic confusing. Lugano’s method and tools allow scenarios to grow and scale up with ease. Lugano will handle hundreds of scenarios or version with thousands of cells. Your will only be limited by your ingenuity, available memory, and processor speed.
No programming required. Powerful reporting commands create reports and charts with ease. Capture the data of any section of your model at any point for reporting or analysis.
With Lugano you can add scenarios quickly without changing your model, record & report all your changes, create reports for auditing and approval. Break down the results of the scenario into simple bite size steps for intuitive understanding. Specific features include:
Versions represent the values of the cells grouped in a selected range name. They are the building blocks for scenarios. Your versions are captured, by you, when you update your data. Versions are also used to define the cells/ranges the user wished to include in their outputs.
A scenario is a collection of versions or commands. During scenarios execution each version or commands is executed sequentially as a step change. The relevant ranges are then replaced with the saved version data.
Commands are inserted into scenarios.
Reports are workbook files which contain the results of the scenario calculation. Reports are created automatically after every step or any step as defined by the user.
|Lugano||Excel Scenario Manager||Purpose built|
|No model changes required. Add scenarios & versions to the Models as is.||No model changes required. Add scenarios & versions to the Models as is.||Purpose build using XLOOKUP(), OFFSET() or equivalent functions and/or VBA code.
Requires: more model building, constant rework, more time, and more validation.
|Systematic and consistent approach to evaluating scenarios.||Systematic and consistent approach to evaluating scenarios.||Scenarios are idiosyncratic to each model.|
|Versions include constants and formulas.||Versions include constant only.||Versions include constants and formulas.|
|Scope to any worksheet in any open workbook.||Scope to active worksheet only.||Scope to any worksheet in any open workbook.|
|Number of versions and scenarios limited by available memory and processor speed.||Only 32 cells are allowed in any scenario.||Practical limitation. Adding ever increasing amounts of version structures to the models becomes cumbersome and ineffective. The scenario logic becomes opaque.|
|Version data may be saved outside of the model. Data may be stored either in the model or in separate Scenario Workbooks.||Versions and scenarios embedded in the worksheet.||Version could be structured to be in either the model or in separate workbooks.|
|Edit & update versions and scenarios using drag & drop and context drop down menus.||Not available.||Practical limitation. Requires rework and additional data space or VBA code. No quick easy tool.|
|Create scenario scripts, specify reporting/charting commands, take snapshots of worksheets with intermediate values.||Not available.||Requires VBA code.|
|Execute & log user defined VBA code.||Not available.||Requires VBA code.|
|Single Step execution of scenarios. You can review intermediate values and check for any problems.||Not available.||Requires VBA code.|
|Automatic log report of all inputs, outputs, and differences.||Not available.||Requires VBA code.|
|Includes difference values in reports and charts.||Not available.||Requires VBA code.|
|Automated static reporting of any range after any step. Only limited by available memory and processor speed.||Only 32 cells, per scenario, may be included in the static summary report. All scenarios are reported which produces inflexible and opaque reports.||Requires VBA code to copy dynamic outputs to static worksheets.|
|Automated static charting of any range after any step. Only limited by available memory and processor speed.||Not available.||Requires VBA code to copy dynamic outputs to static worksheets.|
|Collaboration: scenarios created separately and concurrently can easily be merged to the master scenario.||Scenarios created separately and concurrently can be merged but will always be applied to the active worksheet regardless of its original scope.||Collaboration: requires Co-Authoring and model uploading. Exposes users to issues arising from AutoSave On (cannot quit without saving) and Upload Failed (conflict/unsupported change) requiring manual fixes.|