Codes Points and Figures Tools AddOn

We’ve released a major update to three of our powerful and integrated Spreadsheet Tools.

Codes Points and Figures Tools AddOn

Release 7 Framework InstantOn and Jump Kit customers should check their respective download pages for the new Codes Points and Figures Tools AddOn. It’s free.
The Spreadsheet Tools are not supplied with any versions of Templates Only.

The AddOn supplies updated Framework Spreadsheet Tools for:

• Survey Codes Tool
• Description Key Set Tools for both NCS 5 and NCS 5 AIA classic utility layers
• Figure Db Tools for both NCS 5 and NCS 5 AIA classic utility layers

The supplied Release 7 Spreadsheet Tools replace and update the previously supplied Spreadsheet Tools, but do not overwrite previously supplied spreadsheets.

The supplied Release 7 Spreadsheet Tools support any Release 7 Framework for Civil 3D products in any of the multiple supported releases of Civil 3D.

The Codes Points and Figures Tools AddOn includes updated Layers lists supplied in NCS 5 Layer Standards AddOns released earlier.

The Codes Points and Figures Tools AddOn also intentionally does not replace other supplied InstantOn and Jump Kit resources.

Survey Codes Tool

See the updated Spreadsheet Tools help section in Members on the website for in-depth details, Spreadsheet Tool use, and workflow mechanics.

The Survey Codes Tool produces Code lists for use in the Description Key Set Tool, Figure Db Tool, and Survey Queries Tool.

Additional new Survey Codes are included for:

• Traffic signaling with code support for pole, sized-masts, and head assemblies
• Street lighting with code support for pole, sized-masts
• Additional sized utility vaults

The new version of the Survey Codes Tool supports:

• Easier point code and figure testing
• Additional built in Filter columns
• Better testing of complex Codes including more powerful and complex Not Keys and BESTWay type survey point code and figure patterns and structures.
• Ability to test, compare and optionally force Survey Code translations
• Improved and easier to use Survey Code match list and Translator Key Set construction
• New Reverse Translator Key Set is now automatically produced

Matched Description Key Set Tools and Figure Db Tools

See the updated Spreadsheet Tools help section in Members on the website for in-depth details, Spreadsheet Tool use, and workflow mechanics.

The Description Key Set Tools and Figure Db Tools include updated Layers lists supplied in NCS 5 Layer Standards AddOns released earlier.

Both Framework standard utility (UT@@) and classic AIA utility Layer Standard versions of these different and separate Spreadsheet Tools are supplied. In other words, the new Description Key Set Tools and Figure Db Tools are supplied in matched pairs based on the Layer scheme.

Description Key Set Tools:

• Include New Description Key Set creation sheets with both Layer and Point Style picklists
• Fast Copy and Paste Key Set construction
• Test and validate Layers where that applies
• Test and validate Point Styles where that applies
• Built-in Description Key Set PDF documentation capability
• AIA version left in a pre-update state to clarify required Layer changes

Note that Description Key Set Layer assignments can be updated with Layer rename scripts supplied in the Layer Standards Spreadsheet Tools and AddOns.

You can also post process publication drawings with Layer rename scripts supplied in the Layer Standards Spreadsheet Tools and AddOns to revise Layer assignments.

Figure Db Tools:

• Include New Figure Db records creation sheets with both Layer and Figure Style picklists
• Fast Copy and Paste Figure details construction
• Built-in Breakline and Lot Line data validation
• Test and validate Layers where that applies
• Test and validate Figure Styles where that applies
• AIA version left in a pre-update state to clarify required Layer changes

Note that Figure Prefix Db Layer assignments cannot be updated with Layer rename scripts supplied in the Layer Standards Spreadsheet Tools and AddOns. The individual records must be updated if the referenced layer scheme or details changes.

You can also post process publication drawings with Layer rename scripts supplied in the Layer Standards Spreadsheet Tools and AddOns to revise Layer assignments.