Skip to main content

The file “Template SC Navigator.xlsx” would benefit from the following changes:

Errata: On the [Notes] worksheet lines 36-37 are duplicates of lines 34-35 and the “Jump to Attribute” links do not work.

Suggested improvements:

  1. Add an introductory worksheet to explain the color coding used on the [Notes] worksheet, the worksheet tabs, and the attribute columns on various worksheets.
  2. Add a table of contents worksheet with links to individual worksheets. This would be similar to the “Jump to Attribute” functionality on the [Notes] worksheet but would be specifically for worksheets.
  3. Lock to top row and add a filter on all worksheets.
  4. Wrap text and change column widths so that field names and descriptions have more space and can be read without having to select the cell.
  5. On the worksheets [Single Value Data], [Single Value String Data], [Settings] & [String Settings], align the entries in column A with the entries in column D.
  6. Remove extraneous blank columns like columns F:M on worksheet [Single Value Data] and columns N:P on [Periods].
  7. Use the Outline feature to group the Attribute columns on worksheets and permit the columns to be easily hidden so the descriptions to the right can be easily read.

 

Here is a version of the template that includes these improvements. 
Template SC Navigator_with ToC.xlsx

Here is a version that also has macros to facilitate navigating the workbook. 
Template SC Navigator_with ToC.xlsm

 

Note: The Table of Contents was created with an Excel add-in called ASAP Utilities.

 

Thanks for the ideas Jonathan!


NewDiscussion ongoing

Discussion ongoingOn Backlog

Hey @Jonathan Smith,

I’d like to update you and the community on the ideas you listed above:

  1. Errata: On the Notes worksheet lines 36-37 are duplicates of lines 38-39. Done
  2. “Jump to Attribute” links do not work. Done
  3. Add an introductory worksheet to explain the color coding used on the [Notes] worksheet, the worksheet tabs, and the attribute columns on various worksheets. In progress.
  4. Add a table of contents worksheet with links to individual worksheets. This would be similar to the “Jump to Attribute” functionality on the [Notes] worksheet but would be specifically for worksheets. In progress
  5. Lock to top row and add a filter on all worksheets. Declined
  6. Wrap text and change column widths so that field names and descriptions have more space and can be read without having to select the cell. In progress
  7. On the worksheets [Single Value Data], [Single Value String Data], [Settings] & [String Settings], align the entries in column A with the entries in column D. In progress
  8. Remove extraneous blank columns like columns F:M on worksheet [Single Value Data] and columns N:P on [Periods]. In progress
  9. Use the Outline feature to group the Attribute columns on worksheets and permit the columns to be easily hidden so the descriptions to the right can be easily read. Declined

Thanks!


On BacklogImplemented

Didn't find what you were looking for? Try searching on our documentation pages:

AIMMS Developer & PRO | AIMMS How-To | AIMMS SC Navigator