Make Design Spreadsheet with AutoCAD Block

Click For Summary
SUMMARY

The discussion focuses on developing an application in AutoCAD that utilizes blocks as design spreadsheets, similar to Microsoft Excel. Users can create blocks with attributes as variables and incorporate custom formulas using a text editor. This functionality allows for dynamic updates of attributes and properties when changes are made. Despite concerns about AutoCAD's declining popularity, the application aims to enhance productivity for engineers still using the software.

PREREQUISITES
  • Familiarity with AutoCAD software and its block functionality
  • Understanding of attributes and dynamic properties in AutoCAD
  • Basic knowledge of VBA (Visual Basic for Applications) for customization
  • Experience with creating and using formulas in design applications
NEXT STEPS
  • Explore AutoCAD block attributes and dynamic properties in detail
  • Learn how to implement VBA in AutoCAD for enhanced functionality
  • Research parametric design tables as alternatives to AutoCAD
  • Investigate Mathcad and its integration with AutoCAD for engineering applications
USEFUL FOR

Engineers, AutoCAD users, and developers interested in enhancing AutoCAD capabilities through custom applications and those looking to integrate spreadsheet functionalities into design processes.

linhoreka
Messages
5
Reaction score
0
I am developing an application in AutoCAD. Here is how the AutoCAD Block - Design Spreadsheet works:
http://www.youtube.com/watch?v=ZPqcwg0lzJo"
https://www.youtube.com/watch?v=http://www.youtube.com/watch?v=ZPqcwg0lzJo

Here is the How-to-create tutorial video:
http://www.youtube.com/watch?v=OI977Qw2G-4"

The idea is making AutoCAD block acts as a design spreadsheet (like Microsolf Excel):
1. You create the block with attributes as variables
2. You add your custom formulas to the block with a text editor.

Then, everytime you edit an attribute, other attributes and the block's dynamic properties would change accordingly as the formulas executed.

Here is the demo version http://www.mediafire.com/?0hrzdab76ce92yv

If there is anyone interest in my application, please let me know and give me some advise. Then we can share the application once it is done !
Thanks in advance !
 
Last edited by a moderator:
Engineering news on Phys.org
Commercially I can't see there being any demand for this. AutoCAD is on it's way out and is being replaced by parametric design tables. However there are still many engineers out there that still use AutoCAD daily (including me) that this would be a nice feature.

The use of blocks to act as a parametric design sheet is pretty neat. I like how it does the bending moment and shear plots (and other stuff) for you. I use Mathcad with the Roarks plug into achieve for the same thing.

You've done a really good job, it's got to be useful for someone out there.
 
Thanks, I am trying to make the best out of AutoCAD and VBA. Hope AutoCAD would never really out and replaced.
 

Similar threads

  • Sticky
  • · Replies 13 ·
Replies
13
Views
8K
  • · Replies 1 ·
Replies
1
Views
4K
  • · Replies 2 ·
Replies
2
Views
8K
  • · Replies 1 ·
Replies
1
Views
4K
  • · Replies 2 ·
Replies
2
Views
3K
Replies
4
Views
3K
  • · Replies 48 ·
2
Replies
48
Views
23K
  • · Replies 1 ·
Replies
1
Views
2K
  • · Replies 25 ·
Replies
25
Views
6K
  • · Replies 20 ·
Replies
20
Views
3K