1 / 7

This presentation shows main features of the Dependency Auditor

This presentation shows main features of the Dependency Auditor.

lenore-hicks
Download Presentation

This presentation shows main features of the Dependency Auditor

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. This presentation shows main features of the Dependency Auditor The main purpose of Dependency Auditor – quickly analyze precedents and dependents in spreadsheet and show it a form of tree. Tree form allow easy navigation between levels, so you can drill down into calculations and see structure of your spreadsheet. This screenshot shows you list of precedents of the Output!C4 cell. You can navigate between all child levels of precedents. When you select cell in tree, corresponding cell is activated in Excel.

  2. In actual spreadsheet, list of dependent cells may be too long. You should not expand all levels to find needed cell. Dependency Auditor has Find command, so you can quickly type (or import from Excel) address you need and Dependency Auditor will search for a first occurrence of this range in tree.

  3. When you found dependency you need, you can save results for future review, reporting or printing. Dependency Auditor offers you to save: • All cells in the currently selected branch in tree • Path to root node if you need to find only path from one cell to another Both reports can be saved to: • New worksheet in this workbook • Text file. Dependency Auditor asks you for a file name and then saves data Saving options are present in right click menu in the tree or on the toolbar.

  4. “Format” command in the right click menu applies style to selected branch or path. So, you can mark all cells you found with a color, font, ... in one click. If you have a complex formula and need to know why formula produces this value – use “Evaluate Formula” command in right click menu or on toolbar.

  5. “Evaluate Formula” dialog shows each part of formula and you can drill into each argument, and analyze how other formulas affects to result of the selected one: If formula contains OFFSET function, Dependency Auditor shows range, which is a result of OFFSET function. Typically you does not know to which cell OFFSET actually refers, you see only starting cell and offset by rows and columns. Dependency Auditor shows, where the values comes from in this case. This is very useful feature for debugging formulas in spreadsheet.

  6. If you use extensible OFFSET and INDIRECT functions, input and output of your model are not linked directly. You can not see dependency between that by tracing usual dependents collection. Dependency Auditor shows indirect dependencies when you use trace dependents command: Rows colored with blue, are cells, which contains OFFSET function. In this example =OFFSET(Model!$B$354,0,$A24) formula in cell J24 returns reference to I354. So, it is present in the list of dependents for I354. This feature allows to see actual dependencies in your model. In complex models only Dependency Auditor shows dependency between input and output cells.

  7. If you have any question about our product or you are not sure how to solve your tasks with Dependency Auditor. Or if you need a feature which is not present in it – please contact us. We will quickly add new feature to our product. support@SpreadsheetTools.com www.SpreadsheetTools.com

More Related