You need a solution that logs your changes automatically so you can review them with confidence.
It’s time to grow and scale your models with ease, using automated scripts to edit and rerun scenarios and what-if analysis effortlessly.
You want full visibility of each incremental change, so that it’s easy to understand complex spreadsheets and share intricate results.
Lugano is an Excel add-in that tailors Excel to the advanced needs of analysts and modellers. It records model data—including formulas and changes to cells—in any worksheet within any open workbook. Lugano can log and chart all of your changes and results. Versions are created directly from the data in the model, then easily assembled to create scenarios.
Lugano is a no-code process for Excel scenario development. It is easier to use than the traditional method of adding complex cell formulas, data tables and programming in a model.
Lugano uses simple and intuitive techniques to build scenarios—visual interfaces, select and click and basic logic with drag-and-drop capabilities. And if you do need additional customization, Lugano also operates as a low-code environment. Simply initiate and execute your hand-coded VBA within Lugano.
It’s easy to get started with Lugano. Once installed, Lugano works seamlessly with your existing scenarios and dashboards.
Automated recording makes it easy to explain your process and support recommendations. Choose what to record, then reproduce your findings for supervisors and auditors.
Track and store versions, then drag and drop to reuse. Easily review your work, then replicate versions precisely.
Lugano records all of your initial values. Test new ideas, add alternatives to your master scenario and easily reset to the start.
With a clear record of the model and analysis, you can be confident every variable has been considered. Change, swap or replay your steps to investigate every scenario.
Bite-size steps are recorded at your chosen level of detail. The accuracy of each step can be easily explained, providing confidence that the overall result is correct.
Versions and scenarios can be added ‘as is’, with no programming required. Create as many versions or scenarios as you need, without any limit on size.
Drag and drop, hot-key based context menus.
Click to find ranges and source data.
Select what and how much to record.
Quickly access previous work.
Access complete version history.
Generate detailed visual results.
Protect sensitive data in separate workbooks.
Bring together collaborative work.
Audit using track and replay.