Structural Design Services in Maitland Yorke Peninsula

Operating from 62 Robert Street, Maitland, Yorke Peninsula, South Australia. We can be found in the following building: Send an email Enquiry, check Price list for services, or the web store for downloadable software and reports. With Roy’s qualifications in building, civil engineering and structural engineering, and Conrad’s qualifications in industrial engineering, manufacturing engineering and mechanical […]

Technical Services – Effort Level 3

Large projects present uncertainty for both the buyer and seller: the buyer doesn’t know what they are going to get, and the seller doesn’t know if they will get paid. Such projects are therefore best tackled in small incremental steps, produce something of use and then get paid. Though the usage may not be directly […]

Exploded Bill of Materials for Assembly

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 […]

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 […]

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 […]