Impact Discovery (Reverse of Drill Down)

Impact Discovery (Reverse of Drill Down)

Concept: You have entered an adjustment in a cell, you wish to see what line items, cells, items, etc. that are dependent on the entry or are impacted by it. 

Simply taking the referenced by information and displaying the equations that pull the value and how they change the value (+/-, T/F, Text Change, etc.)

Benefits: significantly easier to research and identify an anomaly deep in the web of equations and allows for continuous drilling to identify what makes up the result.

2 Comments
traynham
Contributor

This would be extremely helpful in reducing impacts found after development (in unit testing or UAT) by giving a modeler the ability to proactively understand/assess impacted areas.

wwood
Occasional Contributor

Another vote for this functionality, this would be extremely useful.