Block references to/ from Excel® worksheet package
The ultimate package for batch processing Block references with the assistance of Microsoft® Excel® AutoFill.
The package combines three NTCL-published apps with some enhanced features which are not available in the free version:
1. Enhanced Block info to/from the worksheet: 2-way (Read-Write) version of the classic Data Extraction command. Multi blocks per drawing\ multi drawings' info can be exported to just one worksheet, under a unique header row. Best for batch filling Title block attributes with the help of AUTOFILL. No more complicated Sheet set FIELDS are required. Support Multiple Visibility States dynamic blocks
2. Batch attribute block ref. creation from the worksheet: The app can fill up to 12 block attributes, 12 dynamic properties, and clone fields after block reference creation, work with Autodesk® Civil 3D® alignment, deal with alignment station equations, and possibly ignore hidden rows in Excel.
3. Alignment of SONE to worksheet: The app is now able to deal with station equation(s), and an option for blank columns is inserted automatically, the app can be terminated during processing with the ESC key.
Autodesk® AutoCAD® block is great, and the Excel worksheet autofill is also marvelous. Why don't we combine them?
NTLC Soft apps are designed to use both of these great features in one place. With our package, you can:
- Batch creates block references with attributes/dynamic properties read from an Excel worksheet. Each worksheet column can be set corresponding to an attribute tag; each worksheet row text data corresponds to a block reference attributes values.
- Batch query existing block references position, attributes, and dynamic properties from one or multi drawings; edit in Excel and then re-import those edited values into AutoCAD.
- Additional utilities: Batch query Civil 3D alignment station, offset/northing, easting, bearing values; Reverse 2D polyline direction.
The typical workflow is:
- Prepare a list of structures with positional data, descriptions, and comments in Excel.
- Batch creates attribute block references from Excel.
- Manually edit block references in AutoCAD if necessary;
- Batch export block references' attributes, and positional data to Excel;
- Convert coordinates value to the station, offset, and vice-versa if necessary;
- Edit attributes, positional data, and dynamic properties in Excel if necessary;
- Update existing block references with data from Excel;
- For more information about how to use every single app in the package, please refer to NTCL Soft website or NTCL published apps.
- User can use this App package with:
- (a) A simple signing-in parent Autodesk application with a valid Autodesk ID that did the purchase. In this way, the user can run this App package from any computer, provided that an internet connection is available; or
- (b) An offline license file, which is physical computer hardware dependent. After purchasing, please run this app, open the About... panel, and manually copy & send your registration info to the NTCL support email NTCLapp1@gmail.com. For more details, please refer to the License registration Guide.
- While waiting for a new/renewed license file, this app still runs with full functions.
- Renew subscription: For a renewed license purchase, a signing-in Autodesk account is required until an offline license file is sent to the user.
- For purchasing a volume of 50 or more licenses, assuming that all PCs work in the same local domain network, a specific domain-based license may be distributed instead of an individual license if required and such a domain-based license is technically feasible.
- The single app version can still work with Paid package App. Please manually uninstall a single app version if necessary.
- App launched from a virtual machine will limit some features. Users will get a message if this app is launched from a virtual machine.