Price: Free Description: A collection of spreadsheets (MS Excel/VBA) with various approaches for working with bill of materials (BoM) for assemblies. Includes: schBOMStructureTreeStage1.xls bomStructureTreeStage3.xls mrpBOMv2.xls Stage 1. Is a manually written indented Bill of materials , with macros to scan down the list and calculate aggregate quantities. the examples are for a cold-formed steel shed, with […]
Drawing Framing Plans Using MS Excel Shapes
Experimental Spreadsheet (MS Excel/VBA) which provides the foundations for drawing framing plans, elevations and typical section using Excel shapes. Download: ExcelShapes.zip StartPreviousDimension & GeometryNextEnd PreviousSpreadsheet BundleNext
Draw 3D Stick framing for Barn Style Shed
A spreadsheet (MS Excel/VBA) which uses DesignCAD (V15) COM automation to draw a 3D stick diagram for an American Barn Style shed. The shed or building is defined by 4 bents, Each bent comprises of one column and one rafter, these either point to the left of the right. The bents can be included or […]
Spreadsheet for Drawing Shed Framing Plans
A spreadsheet (Excel/VBA) which generates Acad LT script file to draw framing plans, elevations and typical section for a cold-formed steel shed. The main drawings are created in model space with all the text created in paperspace. Various options available to control how many views are shown on a sheet. The scale of the views […]
Simplified Geographical Information System
An MS Excel spreadsheet for working with geographical data. Map references from the adelaide UBD street directory are converted to Australian Map Grid (AMG) references, and then Acad Lt script generated so that can be plotted in Acad. The example has grid coordinates of shed suppliers (A table was manually created using online yellow pages […]
Abstract Data Structures in VBA
A collection of MS Excel workbooks using Visual Basic for Applications (VBA) to experiment with abstract data structures. Includes: stacks, queues linked lists binary trees. Download: dataStruct.zip With binary trees used to represent a bill of materials (BoM), with single level BoM’s being used to expand or explode the complete BoM for an assembly PreviousProgrammingNext […]
Experiments with VBA Class Objects
A collection of MS Excel workbooks, illustrating the use of VBA classes and objects. Includes classes for point coordinates, and material and section properties. Download: vbaObjects.zip PreviousVBA ProgrammingNext PreviousSpreadsheet BundleNext
Spreadsheet Automation Using VBA
A collection of spreadsheets providing simple introduction to office automation using MS Excel and VBA. The focus is reading and writing files, and generating scripts for Acad LT. One of primary programming tasks in engineering design is taking data from one application program and changing for use with another application. Having done that also useful if can […]
Automating CADD with Scripts
A collection of spreadsheet (Excel/vba), which shows approaches for automating Acad LT through the use of Acad script files (.scr), and automatically loading and running the script, by calling Acad LT from the command line and passing the script. The typical approach taken is to write the scripts to a default location, and to run […]
Spreadsheet tools for working with DXF files
A collection of spreadsheets with Excel/vba code for working with Acad DXF files. It provides the basic building blocks for finding and extracting entity information from a DXF file. Its typical use has been to either simply extract information, or otherwise modify Acad drawings. Another approach taken has been to extract information and use that […]