Heatmap Cell Relationships

The calculation chain for any given cell can be visualized via a heat-mapping tool called "Relationships Mode." Computational Parents and Children are categorized by the number generation levels away they are from the current cell. Relationships Mode is somewhat like a safer “F2” in Excel: It shows you the computational chain in -- but in both directions -- without putting the current cell into Edit mode.

Turn on Relationships Mode

Click a cell in the model and click this button in the toolbar:


Once enabled, the tool will enable an additional control mechanism for the number of generations like this:


You may now see something like this around your current cell:


Moving the “current cell” with the mouse or arrow keys will cause the parent/children highlighting to move as well. As you navigate, take note of the associated indicator in the bottom left footer region of the app:


The indicator describes at a glance that the current cell has two Parent cells and one Child cell. Those two Parents are now highlighted in purple, and the Child is in red. This indicator will always be there, even if Relationships Mode is turned off.

Increasing the number of generations will make the visualization grow, like this:


How many steps you’ll want to use depends on how far back or forward in the calculation chain you want to explore.

The number of generations can also be controlled with the legend at the lower right portion of the app footer:


Mouse over the number of generations you want of either type, or press Command-Click (or Alt-Click) to set the same number of both types.

Relationships Mode can draw your attention to the following issues:

First,Knowing that a cell has at least one Child cell means that deleting this cell could cause a calculation or integrity error downstream.
Second,You may notice inconsistent patterns in the colors as you navigate across a dimension of the plan -- left to right on a row, or top to bottom on a column. This could represent some kind of logic error.

Any inconsistencies in the relationships should be corrected, either in Excel (followed by another import), or within ClearFactr directly.

Note that after editing within ClearFactr, you can export a native Excel file from ClearFactr. More on that later...