Block references to/ from Excel® worksheet package

Block references to/ from Excel® worksheet package

Free 30-Day Trial, Y, M
OS:
Language:

Description

The ultimate package for batch processing Block references with the assistance of Microsoft® Excel® AutoFill.

The package combines 6 apps with some enhanced features that 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.  Support Multiple Visibility States dynamic blocks, which may be useful for managing devices' status in a device circuit.  Field attributes export/import are also supported.

Quick intro video

Detailed instruction

 

2. Batch attribute block ref. creation from the worksheet: The app can fill up to 24 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.

Quick intro video

Detailed instruction

 

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.

Quick intro video

Detailed instruction

 

4. 2-group intersection with order: Create and assign numbers to intersections between 2 groups of Polylines/Lines/SPLines. Insert block/point/text objects at intersections. Export results to Excel worksheet.

Quick intro video

Detailed instruction

 

5. Advanced Batch Plot: Plot/ Print multi drawings, multi Layouts, and multi sheets per Layout. The printing configuration of each drawing is automatically saved. Sheets may be auto-combined into one PDF file with Bookmarks. Auto turn on/ turn off paper space Viewports. Auto ignores null content sheets. Read the sheet list from Autodesk® AutoCAD®.DST and .DSD files.

Quick intro video

Detailed instruction

 

6. More block utilities: 

- A Batch dynamic block converter: Convert dynamic blocks of multi drawings to static blocks.  This tool may help users to protect precious, complicated dynamic blocks from unauthorized copy.

 Detailed instruction

 

- An advanced version of Block replace tool: Block with attributes and dynamic (custom) properties are replaced properly without errors.  Attributes, fields and custom properties of old block can be retained.  Only support active drawing. 

Detailed instruction

 

- A tool for copying entities across multi layouts: Overlapping entities at destination layouts may be erased at will.  Only support active drawing. 

Detailed instruction

 

Notes:

  1. For more information about how to use every single app in the package, please refer to the NTCL Soft website or NTCL published apps
  2. Users can use this App package with:
    • (a) A simple signing-in parent Autodesk application with a valid Autodesk ID that made 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 dependent on physical computer hardware. 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.
  3. While waiting for a new/renewed license file, this app still runs with full functions.
  4. Renew subscription: For a renewed license purchase, a signing-in Autodesk account is required until an offline license file is sent to the user.
  5. 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.
  6. The single app version can still work with the Paid package App. Please manually uninstall a single app version if necessary.
  7. 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.

About This Version

Version 2.1.0, 9/23/2024
Bugs fixed: (a) App Enhanced Block info to/from Excel shows some Vietnamese tooltips in English mode (b) App Advanced Batch Plot cannot properly read sheets from multi-subset levels sheet set file *** Improvements: (a) 3 mini tools added: Dynamic block converter, advanced block replace and copy across layouts (b) App Block (creation) from excel now double the number of attributes from 12 to 24; block rotation can read from Excel column (c) App Enhanced Block info to/from Excel now can export/import attribute fields


Customer Reviews

1 review
Get Technical Help
  • Good support
    Nguyen Thi Phuong Thao | April 12, 2024

    The publisher continues to add more Apps to the package.

    The new App Advanced Batch plot is interesting.  It helps users who often plot from Model like me.

    NTCL Main (Publisher) | April 16, 2024

    My first customer, thank you for your encouragement

Go top