
Course introduction.
A brief overview of the topics within this section. "Part list.xlsx" & "Flange table.xlsx" should be downloaded for this section.
How to find a function in Excel.
How to perform basic arithmetic in Excel.
Using the ROUND, ROUNDUP, ROUNDDOWN, MAX, MIN & AVERAGE function.
This is lesson covers the IF function and conditional formatting.
How create drop down lists, sort and transpose data. The "Flange table.xlsx" should be used from this point.
Extracting data using the VLOOKUP function.
Using the IF function within conditional formatting.
How to use the CONCATENATE function.
How to build and test a script in Excel. Part 1
Use attached "CAD_template.dwt" for the build and test process. This template contains the necessary line and dimension styles needed.
How to build and test a script in Excel. Part 2
How to build and test a script in Excel. Part 3
Comparison of Draftsight & AutoCAD command sequence.
How to add a macro into your spreadsheet.
How to customise the user interface in Draftsight and command macro syntax. Syntax is the same for both Draftsight & AutoCAD.
How to customise the user interface in AutoCAD.
The End...
See attached complete workbook with the macro added. You may need to enable the macro after opening. Use the "CAD_template..dwt" file which has the necessary dimension & line styles added.
A unique approach to CAD automation. This course is aimed at any Draftsight or AutoCAD user wanting to automate drawings or tasks. No programming or even Excel experience is required.
This course gives you an easy Excel based approach to CAD automation. Most CAD users are under the impression that coding or programming experience is required to automate drawings. This method uses one basic VBA code which is already written and provided. Adding this code is a simple copy and paste exercise.
Basic CAD knowledge is required but beginner CAD users should easily be able to follow along and even experienced CAD users will likely learn something new. Every Excel function needed to automate CAD is covered. CAD automation is often associated with high-cost CAD packages, but the approach taken in this course is affordable to all small businesses and even individuals. The software used in this course can generally be run on most computers and requires no special hardware requirements. FREE 30 day trial versions are available for both CAD packages. See system requirements for each within the respective website.
Real world examples and practical applications are shown so you can take the knowledge gained and apply it to your day to day working life. All content has been compiled by a CAD user, for the CAD user.