Troubleshooting

Account Management

ExcelAuditing

Visualization Tools

Quickly identify formula errors and inconsistencies in large numbers of cells at once, eliminating the need to check each cell individually and tediously.

Uniformulas

You probably—and often—key the familiar F2 > Escape > Arrow sequence repeatedly to inspect formulas in adjacent cells for consistency. The Uniformulas tool performs a similar check in far fewer keystrokes by highlighting adjacent cells with the same formulaic structure and in the same contiguous range as the audited cell.

Ctrl

Q

In the example below, we perform the Uniformulas operation on the cell computing gross margin in the first period. This selects adjacent cells in the same contiguous range with the same formulaic structure, as shown. The cell computing EBIT margin in the third period is not selected, however, because its formulaic structure differs from that of adjacent cells. This could (and in this case, does) indicate a formula error.

The Uniformulas tool is best accessed via shortcut keystroke, but can also be accessed via the Macabacus > Visualize > Uniformulas button. You can set the Uniformulas tool to enter Edit Mode on the audited cell (as shown above)—similar to keying F2—from the Application Settings dialog. When this feature is set, the Uniformulas tool behaves like an enhanced version of the familiar F2 > Escape auditing sequence.

Formula Flow

Formula Flow helps you visualize the formula structure of your spreadsheets to quickly identify errors and other inconsistencies. Formula Flow uses the following rules to apply the turquoise patterns shown in the example below:

Uninterrupted horizontal line patterns in a contiguous range of cells indicate that formulas are consistent across columns.

Uninterrupted vertical line patterns in a contiguous range of cells indicate that formulas are consistent down rows.

Uninterrupted horizontal and vertical line (i.e., crosshatched) patterns in a contiguous range of cells indicate that formulas are consistent both horizontally and vertically.

Darker turquoise shading indicates a formulaic inconsistency within the inspected range (you can sometimes see Excel's green "inconsistent formula" indicators in the corner of these cells, too).

As you change the contents of cells visualized using Formula Flow, the visualization updates automatically. Access this tool from the Macabacus > Visualize menu. Remove this visualization by performing an Undo operation, or click the Clear Visualizations button on this menu.

Dependency Density

Dependency Density allows you to visualize link density as measured by the relative number of dependents for each cell in the selection. It accomplishes this by shading cells orange based on how many dependents each cell in the selection has—the darker the shading, the more dependents. In financial modeling, horizontally adjacent cells often have the same number of dependents. Thus, you would expect the Dependency Density visualizer to generally produce the same orange shading intensity within a row of cells.

Access this tool from the Macabacus > Visualize menu. Remove this visualization by performing an Undo operation, or click the Clear Visualizations button on this menu.

Magnitude Map

Magnitude Map is an improvement on Excel's native conditional formatting color scale that utilizes more intuitive coloring when working with data containing both positive and negative numbers. This tool is great for identifying outliers, as cells with the largest magnitudes (positive or negative) are shaded darker.

Access this tool from the Macabacus > Visualize menu. Remove this visualization by performing an Undo operation, or click the Clear Visualizations button on this menu.

This documentation refers to Macabacus version 8.9.17. Some features and descriptions of these features may notapply to older versions of Macabacus. Update your Macabacus software to take advantage of the latest features.

The leading Microsoft Office productivityadd-ins for finance and other professionals