Account Dependencies

Using Analyze

Analyze drills down from the account line or the output line on the Accounts spreadsheet to see how the value is calculated. The heading displays the model name and current scenario as follows:

Analyze <model or file name>(<scenario name>)

To use Analyze:

1. From the Data grouping label, click Audit Trail.

2. Highlight an account or value.

3. Double-click the cell.

   Note:

   By default, if you do not click New or Current button, and then double-click on the value within the cell. The information display within the current dialog.

   If you click New or Current button, and then double-click on the value within the cell. The information display in a new analyze dialog.

4. Optional: Click a toolbar button to analyze different account elements:

   • Forecast—Access Forecast Method—See Accessing Forecast Methods.

   • User-Defined Accounts—Access User-Defined Accounts—See Using User-Defined Accounts.

   • Optional: Click Back to revert the changes performed on the Analyze dialog box.

   • Optional: Click New/Current to view the data in a separate dialog box.

   • Optional: Click Close All to exit the Analyze dialog box.

   • Optional: To find accounts, click Find Accounts.

   Note:

   When you drill down to Account Input, you can change historical and forecast values. Be sure to recalculate for input changes and save to retain the data.

   Note:

   Valid values in conditional statements are highlighted.

5. Close the initial Analyze dialog box.

Using Where Used

Where Used is a forward audit trail, identifying the accounts that depend on other accounts. You select accounts and calculate all scenarios, and Where Used tracks the accounts using the selected accounts.

To use Where Used to identify account dependencies:

1. From the Accounts spreadsheet, select Accounts, and then Where Used.

2. Optional: To list only financial accounts in Available Accounts, select Show Accounts Only.

   If this option is not selected, informational accounts such as Company Name and Default Currency are displayed.

3. In Available Accounts, select an account and click .

4. Optional: To limit the calculation to only the scenario currently selected in the model, select Calculate Current Scenario Only.

5. Click Run.

6. In Where Used, view dependent accounts.

7. Optional: To store the results as a .txt file, click Save.