With Lugano, analysts can easily create, test and rerun scenarios, no matter how complex.

Add scenarios quickly – without changing your model.

Record and replay all your changes.

Create reports for auditing and approval.

Show results as simple, bite-size steps for better understanding.

Create and save versions of your data

Versions represent the values of the cells grouped in a selected range name. They are the building blocks for your scenarios. Capture your versions when you update your data. Version data is protected to prevent accidental changes. You can easily navigate back through previous versions and select to view the data. Versions are also used to define the cells (ranges) that should be included in your reports.

  • Create versions directly while updating the model with new version data.
  • Create multiple versions as required. The number of versions is only limited by the available memory and processor speed.
  • Specify the size and location of versions. Select any range in any open workbook.
  • Choose to include constants and/or formulas in your version.
  • Auto-suggest version labels based on model text labels and/or date. Select the version and go to the source data and target range in the model.
  • Change the range name size of existing versions in the model and scenarios.
  • Update existing version data.
  • Save your version data to the model workbook or to separate dedicated scenario workbooks.
  • Review your version data in the scenario workbook.
  • Directly edit your version data.
  • Delete or rename versions, rename range names, add, or edit labels and descriptions.
  • Auto-identify and select range names by simple cell selection.
  • Use existing range names or create new range names on the fly
  • Use the Names Navigation form to list and locate all range names in open workbooks.
  • Filter or search the list of range names. Tag, range names directly in the workbook using boxes and labels.

Create as many scenarios as you need

Scenarios are created to effortlessly manage what-if analysis. A scenario is a collection of versions or commands. When a scenario is executed, each version or command is executed sequentially as a step change. The relevant ranges are then replaced with the saved version data. Different versions can be quickly combined to create new scenarios. You can easily execute multiple scenarios to test different theories and understand impacts. Simply drag and drop different versions to compare, review and adjust in minutes.

  • Create as many scenarios as required. The number of scenarios is only limited by your computer’s processing speed and available memory.
  • Collate your versions into scenarios using drag and drop.
  • Build complex scenarios with powerful reporting commands.
  • Execute scenarios and create reports as specified.
  • Step through a scenario, pausing the process at any point to explore the models during intermediate steps.
  • Set scenarios as subroutines.
  • Add, delete, move and copy versions and commands within the scenario.
  • Add, delete, move and copy scenarios.
  • Add or edit labels and descriptions.
  • Merge scenario files.
  • Get comprehensive validation and error reporting of mistakes or missing files.
  • Run scenarios in a protected sandbox environment targeting disposable workbook copies.
  • Protect your work, save and backup all active scenarios and open workbooks with one click.
  • You can choose where to save your active work and archive backups.
  • Versions may be saved automatically or manually.
  • Access saved data to reproduce your workings for later review or distribution.

Use commands to control scenario execution

Commands are actions which control scenario execution or create spreadsheet reports of input and output data. Lugano harnesses a comprehensive suite of commands. Commands are easy to insert using mouse clicks, drop down context menus and hot keys.

  • Control calculation mode.
  • Activate and deactivate commands, versions or reports.
  • Stop execution.
  • Call and execute scenario subroutines.
  • Call and run user defined VBA code.
  • Create reports.
  • Control iterative calculation mode.
  • Update versions with calculated model results.
  • Target alternate workbooks.

Create reports and visualise outcomes

Reports are workbook files containing the results of the scenario calculation. They may be created automatically, either after every step or after any step you define. After the scenario runs, reports are automatically updated to match any changes made.

Use reports to share your process and outcomes. You can select variables to watch and include these in waterfall charts. This lets you track how each step in the scenario affects the final watch value. Add as many as you want, whenever you need. Reports ensure you can elucidate the outcomes of complex spreadsheets.

  • Create log reports of input changes and output ranges.
  • Create charts of user defined inputs and/or outputs ranges.
  • See differential values between the current and last reported change.
  • Define all output ranges in reports and charts.
  • Create waterfall charts of any user-selected cell value after any step.
  • Create difference worksheet reports of any worksheet to show the values in the worksheet before, after and the difference after any step change.
  • Use reports commands to copy intermediate or final model values to your reports.
  • Export inputs, outputs, and chart reports to PowerPoint slides.

Create snapshots of the worksheet changes

During your analysis, you can trace the impact of each variable by watching difference worksheets which can isolate the impact of a single change. Use Lugano to record your snapshots.

  • Snapshot worksheets are difference worksheets inserted in the model which can be reset to show the impact of model changes on the worksheet values.
  • Add difference worksheets to any or all worksheets in your model.
  • Rebuild or reset difference worksheets to visually track the change made to your model.
  • Automate the snapshot feature into your scenarios and reports, or use it manually to check your models.

Process variations without waiting

Some models need to be run multiple times, testing a number of parameters. Lugano’s powerful scripting feature lets you set up your process in advance, then run all the iterations as a batch process.

While you work on other things, Lugano will create all the individual reports required. It’s easy to set up, easy to update and you get a full audit trail of all the activities in the scenario. Scripts can also be developed collaboratively. Each collaborator can create a portion of the script, with the sections then being merged to create a complete script for processing.

  • Run multiple iterations of the same scenario with different inputs.
  • Set up and call repetitive actions as subroutines.
  • Free up your time. Run multiple scenarios automatically in the background.
  • Create complex scenarios with collaborators and merge these into one.
  • Delegate tasks among your collaborators: create versions, create scenarios, merge scenarios, run scenarios in the background, and review reports.

What sets Lugano apart?

You’re probably using your own formulas, tailoring Excel to suit your work. Lugano is a no-code scenario development environment.
Find out how Lugano compares to custom-built structures using no-code solutions. No-code model development employs visual interfaces, basic logic and drag-and-drop capabilities. This requires no computer programming or VBA coding.

Features Custom-built structures
No-code
Lugano
No-code
Versions may include constants and formulas.
Scope to any worksheet in any open workbook
Version Data saved to model workbook
Version Data saved to external workbook. Reduces model bloat.
Confidential versions are separable from the model with no visible links
No model changes or build required.
Systematic and consistent framework to evaluating scenarios.
Scenario size has no impact on model.
Edit scenarios using visual interfaces, context menus, basic logic and drag-and-drop capabilities.
Create scenario scripts and control the execution of your scenario.
Call powerful built-in commands for creating customised reports, charts, and snapshots of your scenario outcomes.
Automatically log every step change. Customise the level of aggregation required.
Automated reporting of any range after any or all steps. Only limited by available memory and processor speed.
Audit your scenarios.
Scenario scripts are available for review, editing, testing and validation by independent reviewers.
Audit your results.
Automatic log of customized reports of all inputs, outputs, and differences are available for independent review.
Single Step scenario execution. Perform a “live” review after each step and identify any inconsistencies or issues in the model.
Execute repetitive steps as subroutines. Call these subroutines from other scenarios. Subroutines may be nested.
Execute and log outputs from user defined VBA code.
Collaboration without uploading.
Scenarios are created separately and concurrently and then merged.
Avoids the pitfall of unspecified edits or upload failures.
AutoSave may be set to “Off”.

 

Say goodbye to manually logging changes.

Let Lugano do the hard work for you.

Start a Free Trial

Get full access to Lugano for 30 days.