A. The procedures of block creation, in brief, can be divided into 4-7 steps:

Define a block (with or without attributes) then run this App.

Pre-selected data range (rows & columns) in Excel worksheet. Press "Activate Excel" to find out which instance is linked (usually the last open worksheet)

Select a block name or an Excel column that contains multi-block names.

Select macro mode (A) and match block refs. positioning parameters with Excel columns (B).

(Optional) Match attributes with Excel columns (C).

(Optional) Match dynamic properties with Excel columns (D).

Click "Insert block references" to see the results.

(Optional) Clone field attributes from source block references to other block references.

B. The procedures of block references properties extraction:

1. Start by opening an Excel worksheet, (Active drawing processing option only: remember to reserve 1 blank column at the active cell (values will be written downward)).
2. Press Alt+Tab to return to AutoCAD or its vertical products, and invoke the NTCL_BlockToExcel command. The user form will appear.
   • For the Active drawing processing option, on the user form, open a drawing.
   • For the Multi files processing option,  load the drawing list from folder/ from files/ from Excel files .... to the table.  Check the option:  Single worksheet if the user wants all exporting results from different drawings combined in one worksheet.
3. Select macro mode: 1 (Cad Block info => Excel worksheet) or 2 (Excel info => Cad Block update). Select additional options (block name, where to get block refs from, which information to export, and import). Mode 1 should run before Mode 2 unless you saved and re-use the results of Mode 1 before.
   • If you select mode 1, the block information will be exported to Excel. For the first export action, blank columns will be automatically added to the right side of the active cell
   • If you select mode 2, the block information will be imported from Excel. For the Active drawing processing option: Be sure to pre-select the data range in Excel first. The selected range must include a header row & a handle column.  For the Multi files processing option:  Be sure you have to write permission for drawings in List.
4. If you have multiple Excel instances already open, this App may tie to the last activated Excel instance but sometimes it does not. In such a case, please close all opening Excel instances; close (end task) any invisible Excel.exe process by Task Manager, and re-open only one Excel instance.

C. Batch inquiry Station, Offset / Northing, Easting values from alignment

1. Start by opening an Excel worksheet, fill in then pre-select a range of 2 input columns of (Station + Offset) or (Northing, Easting) values.
2. Press Alt+Tab to return to Autodesk® Civil 3D®, and invoke the NTCL_SONE command. A user form will appear.
3. On the user form, select your existing alignment then Select macro mode: 1 (Station, offset to Northing, Easting)  or 2 (Station, offset to Northing, Easting). Click the button SO=>NE or NE=>SO based on your desire. The results will be written in the next 2 columns in Excel.

D. 2-group intersection with order

1. Select Primary group and Secondary group.
2. Sort and number the objects in each group.
3. Insert temp objects at intersections.
4. Save the result and export intersection data.

E. Advanced Batch Plot

1. Active drawing plotting/printing.
2. Drawings plotting/printing. 
3. Print the previous list of frames.
4. Three levels of Page setup.
5. PDF combination mode.

The installer that ran when you downloaded this app/plug-in from the Autodesk App Store will start installing the app/plug-in. OR, simply double-click the downloaded installer to install the app/plugin.  You may need to restart the Autodesk product to activate the app/plug-in. To uninstall this plug-in, exit the Autodesk product if you are currently running it, simply rerun the installer, and select the "Uninstall" button. OR, click Control Panel > Programs > Programs and Features (Windows 7/8.1/10/11) and uninstall as you would any other application from your system.

1. If no Excel worksheet is opened 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.
2. This app only works with desktop versions of Excel. In case multiple Excel versions are installed, this app may work with the default version.
3. Users can terminate the app during the Excel interaction process by pressing the ESC key within the App dialog. ESC key cannot terminate the app if the key-pressed action occurs in the Excel interface.
4. The single App version can still work with the Paid package App. Please manually uninstall a single App version if necessary.
5. The app launched from a virtual machine will limit some features. Users will get a message if this App is launched from a virtual machine.

1. In some cases, this app cannot connect Excel® to Microsoft® 365 (Office® 365). The NTCL Error message: "Cannot open Microsoft® Excel®" appears 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

2. Excel OLE Table is printed with a black background and white text in AutoCAD 2022.  To avoid this, update to AutoCAD 2022 ver 1.1 or later.

3. Some third-party virtual printers may not be compatible with some versions of AutoCAD. A crash occurred when trying to initialize the ProgeCAD® 2022 virtual printer in Civil 3D® 2016

4. When trying to open newer-version drawing(s) in an older version of AutoCAD/AutoCAD verticals, a message box "This drawing was created with a newer version of ..." may appear and require the user to manually interact.