Skip to main content

Alignment SONE to worksheet

NTCL Soft

Alignment SONE to worksheet

NTCL Soft

Batch inquiry and export Autodesk® Civil 3D® alignment Station (S), Offset (O) / Northing (N), Easting (E) to Microsoft® Excel® worksheet, based on pre-selected cells value.

Free

QUICK INTRO VIDEO

This app aims to batch inquiry Autodesk® Civil 3D® alignment Station, Offset (SO) based on pre-selected Northing, Easting (NE) values and vice versa. Results are directly exported to Microsoft® Excel® worksheet.

Input (SO or NE) and output (NE or SO) values are taken from and returned to the Excel® worksheet for further processing. This tool may help ease the process of enumerating/ sorting structures located along horizontal alignments such as culverts, signs, abutments, and piers... The structure location list in Excel can be saved and reused to create attribute block instances later.

A more advanced version of this App, which supports the Station equation can be found in Block references to/ from Excel® worksheet package App.

Details

Operating system

win64-platform-icon

Release date

Mar 20, 2022


Last updated

Sep 3, 2024


Version

1.0.6.0


Language

English

Compatible with

CIV3D-icon

CIV3D

2020, 2021, 2022, 2023, 2024, 2025

Certifications

Digitally signed

Digitally signed

Capabilities

Data extraction

Tags

Reporting

Road design

Frequently asked questions (FAQs)

  1. Be aware that unsaved values that are overwritten in the Excel® worksheet by this app cannot be undone in Excel®. It is recommended to save the Excel® worksheet & reserve at least 2 blank columns next to the selected range before running this app;
  2. If no results are returned to Excel, please check: (a) Input values are correct, sometimes SO, NE values may be outside alignment range (b) App is being tied to an invisible running Excel.exe process. In such cases, please close all Excel® instances, including those invisible Excel.exe process
  3. If no Excel® worksheet is open before, this app will try to open a blank worksheet.  Your input must be copied to this blank worksheet.  In case you want to use input values from an existing worksheet, just close the app and the blank worksheet, and pre-open the existing worksheet before running this app;
  4. This app only works with desktop versions of Microsoft® Excel®.  In case multiple Microsoft® Excel® versions are installed, this app may work with the default version.

In some cases, this App cannot connect Excel® in Microsoft® 365 (Office® 365).  The NTCL Error message: "Cannot open Microsoft® Excel®" may appear right after the App is called.

This error can be fixed by running "Quick Repair" on Microsoft® 365 (Office® 365).

For more information, please refer to: https://www.NTCLSoft.com/home/troubleshooting

For questions/comments/suggestions/bug reports etc please send an email to NTCLApp1@gmail.com

Found an issue?

Report a problem