SC Navigator: errata and improvements for the data input template

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

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

Suggested improvements:

Add an introductory worksheet to explain the color coding used on the eNotes] worksheet, the worksheet tabs, and the attribute columns on various worksheets.
Add a table of contents worksheet with links to individual worksheets. This would be similar to the “Jump to Attribute” functionality on the nNotes] worksheet but would be specifically for worksheets.
Lock to top row and add a filter on all worksheets.
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.
On the worksheets hSingle Value Data], Single Value String Data], SSettings] & tString Settings], align the entries in column A with the entries in column D.
Remove extraneous blank columns like columns F:M on worksheet :Single Value Data] and columns N:P on Periods].
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.

Page 1 / 1

Thanks for the ideas Jonathan!

New→Discussion ongoing

Discussion ongoing→On Backlog

Hey @Jonathan Smith,

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

Errata: On the Notes worksheet lines 36-37 are duplicates of lines 38-39. Done
“Jump to Attribute” links do not work. Done
Add an introductory worksheet to explain the color coding used on the oNotes] worksheet, the worksheet tabs, and the attribute columns on various worksheets. In progress.
Add a table of contents worksheet with links to individual worksheets. This would be similar to the “Jump to Attribute” functionality on the iNotes] worksheet but would be specifically for worksheets. In progress
Lock to top row and add a filter on all worksheets. Declined
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
On the worksheets wSingle Value Data], lSingle Value String Data], iSettings] & nString Settings], align the entries in column A with the entries in column D. In progress
Remove extraneous blank columns like columns F:M on worksheet oSingle Value Data] and columns N:P on lPeriods]. In progress
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!

Sign up