Understand Your Compute Models

Faster and Easier Than Ever

NewGif

More than Pretty Pictures

Getting the most out of any model starts with understanding how it works. Let the software do the talking. Rather than spending all day tracing or color coding formulas, let ClearFactr's built in explanation tools help you and your users faster than ever.

 

Natural Language Formulas

Give your brain a break and let ClearFactr self-describe your model’s business logic using your own words: those words need to be there anyway... put them to best use! Simply name rows and columns and ClearFactr will do the rest.

 

the__final__gif
ClearFactr-CellTypes-1

Cell Type Highlighting

Stop hand-coloring cells! Let the software show you where the model starts, and where it ends. In a few clicks, you can see:

  1. All the input or "root" cells
  2. All the output or "terminal" cells
  3. All the cells that transform cell values into others (i.e., the compute graph of the model)
  4. Any cells that have connections to external data
  5. Any cells that have special permissions attached to them.

Table of Contents Report

Get a physical roadmap of your model with one click. Instantly see where all of your data and transformation is, even between entire sheets. Discover hidden complexity and risk-inducing duplication.

ClearFactr-TableOfContents-1
ClearFactr-CellAncestry-2

Cell Ancestry Tools

From start to finish, discover and explore calculation chains with ease. No more memorizing, hunting, pecking, searching and scrolling. ClearFactr explains it all in living color.

Function Finder

What functions drive your model? Find them all with a click and fine-tune things for maximum performance. Click on any function in the report and see all the cells which use it. Click on any of those and ClearFactr immediately takes you there.

ClearFactr-FunctionFinder-1
ClearFactr-Doppler-1

Doppler Tool

It's the cell ancestry tool to the nth power. Blue cells are coming towards you, red cells moving away (high school physics anyone?). Everything's heat mapped, automatically. The two tables at the bottom allow you to effortlessly navigation up and down the calculation chains, across sheets as needed.

Versioning Tools

ClearFactr shows you who did what, when, and how, from wholesale model changes down to the single cell. Compare versions and see both the changes, and their downstream effects. Review cell audit history in legacy syntax, or Natural Language.

 

  • ClearFactr-VersionsTool
  • ClearFactr-VersionsCompare-Drivers
  • ClearFactr-VersionsCompare-All
  • ClearFactr-CellHistory-Legacy
  • ClearFactr-CellHistory-NaturalLanguage

onward!

Learn more about our built-in analytics.