AnalystPro helps teams make faster, data-driven decisions by automating complex tasks and providing visual audit trails. With AnalystPro, recommendations are made 30x faster, unlocking the data needed to streamline processes.
AnalystPro | Improve trust & productivity in driving decisions
To access AnalystPro Excel/Google Sheets Extension:
Trace the workbook to find all the dependencies between cells. This action is required to start using other features in the tool.
The “Drivers” action tests sensitivities between the inputs and the output to identify key drivers. Simply select a cell with a value and click “Drivers” on the Home page.
Once you find drivers, you can click on “Visualise” to explore how values connect through a visual flow. There are 3 different layers:
Use View settings and filters to get the most of audit trail visualisation. You can share the visualisation with public or private link.
Run "What If" scenarios on any traced cell, set constraints on the drivers you want to flex, and instantly see the highest, lowest, and original outcomes side by side.
Set a target for any traced cell, constrain the drivers that can move, and let AnalystPro find the driver combinations that get you there, with the closest solutions ranked side by side.
Set a percentage range of change, apply it across every driver, or just the ones you choose. See exactly how much each assumption moves your result, all in one table.
If you need to quickly explore all dependents and precedents of a cell, use the "Related Cells" button on the Home page to instantly see all the connections and dependencies.
Get a written review of any traced cell. It covers the result, ranks the drivers behind it, tests their sensitivity and pulls out the key findings, all in a new sheet.
Weighting is a numeric measure of a value’s relative impact on the output. In the Audit Trail visualisation you can see how different drivers have different shades of blue: the darker it gets, the more weighting the value has. Think of it as a heat map that helps you see the entire picture quickly.
Drivers are key inputs that significantly influence the output. These are typically numerical values, assumptions, or variables that directly affect the calculations in the model.
Other inputs are characterized by having a 0% weight. Depending on the data, other inputs are classified as Constant, Date, Redundant, Blank, Zero, or Text.
Constants can be defined automatically by AI (for example, 12 month) or by you through manual process. It helps to reduce visual noise and keep the Audit Trail visualisation clean and accurate.
Cells formatted as DateTime. They have no weight but can be relevant to the model logic. This is why they are separated into their own group.
Non-DateTime numerical inputs with no weight, such as those being cancelled out (e.g., if an input is referenced in SUMIF but isn’t triggered).
Cells with a text string of “”.
Cells with a value of 0 and a weight below 0.01%.
Cells containing text.
In case you have any questions, please, contact support via [email protected]
For a full list of FAQs visit: