Arrisca for Estimating Audit
What problems does Arrisca solve?
Arrisca will help any of these problems:
- You need to audit Excel spreadsheets, but lack the time
- Your spreadsheets might contain mistakes & risky assumptions
- You want to quickly understand how a spreadsheet was built
If you recognise these, take a look at Arrisca.
Arrisca will saves time and improves estimating accuracy. Arrisca will find the assumptions in Excel books that you need to know for price review, estimates & forecasts. Imagine the next time somebody presents a figure to you and asks for your approval. You don’t have time to go through every cell. So where do you focus your attention? Arrisca will quickly show you the top 20 drivers that make up the figure. By questioning the assumptions behind these, you establish credibility in the final figure. Furthermore, Arrisca allows you to adjust the inputs for ‘What-If’ analysis and heatmap Excel to check for mistakes.
Arrisca represents spreadsheet best practice. It is widely used to check Excel assumptions in estimate & price reviews. It is mandated for use by the Ministry of Defence (MOD) Cost Assurance and Analysis Service (CaaS) for all single-source price reviews.
How does Arrisca work?
Arrisca is risk analysis software that quickly unpicks a total figure (e.g. Price, estimate or forecast). It analyses the 20 cells with the greatest contribution to the total figure. At Amplio, we always use Arrisca to validate our Price to Win models. When we do a Price to Win, we don't want any single input driving more than 5% of the Price to Win. This is really important for accuracy and Arrisca is the quickest way to quality check our models.
Below: Arrisca quickly shows the top 20 drivers and allows ‘What If’ scenarios
Arrisca can also heat-map Excel for:
- Cells that contribute to the total figure
- Cells that do not contribute to the total figure
- One of the top 20 contributors to the total figure
This helps audit spreadsheet risk and identify mistakes. In the picture below, the top row was inserted after the formula was created. Therefore, it sits outside of the formula and is not contributing to the total. It shows up red to flag to the user a potential mistake.
Below: Arrisca allows you to heatmap Excel to check for mistakes
How can I try Arrisca?
- Identify the top 20 drivers in any spreadsheet
- Perform ‘What If’ analysis on any driver
- Heat-map the spreadsheet to check un-used or working cells