Formula Breakdown & Insights

Formulas are the heart and brain of a spreadsheet. Understanding the model is key to properly use and maintain a spreadsheet, as well as knowing the input sources of your calculations. PerfectXL provides several tools to help you with this, such as formula overview, constants overview and formula breakdown.

Formula Overview

A list of unique formulas in your spreadsheet is an excellent way to assess the size and complexity of your model. Exceptionally large formulas are easily noticed. The overview lets you know you if any of the formulas used in the spreadsheet are specified at a low, medium or high risk level and where exactly they are to be found (worksheet and cell). Filters help you navigate to precisely the formula you may wish to investigate. Once you find a formula that needs more attention, you just click it to go straight to its breakdown.

Spreadsheet Formula Overview :: PerfectXL

Formula Breakdown

Sometimes you just need to be sure about a calculation. That’s why we created the Formula Breakdown feature as part of PerfectXL. This revolutionary tool lets you review the workings of a formula by traversing the tree of cell references all the way back to the source. Ranges are split up into its significant constituent components and both risks and underlying risks are presented along the way. This is the tool if you want to be certain about any calculation in your spreadsheets. It gives you a clear insight into problems that might take weeks to discover manually (if discovered at all).

Spreadsheet Formula Breakdown Feature :: PerfectXL

Constants Overview

Curious which constants are used by formulas throughout your spreadsheet? Visit the Constants section of PerfectXL for an elegant overview of all referred constants. The schedule shows you the value and the exact location (worksheet and cell) as well as the location of the formula or formulas in which they are used. 

Spreadsheet Constants Overview :: PerfectXL