Building a Structural (Engineering) Design eWorkbook – Part 3

Note that I am using VBScript because it belongs to a family of languages, and capability basically increases from VBScript, VBA to VB, to VB.net. Whilst software may support COM automation or whatever the .net equivalent is called, not all software hosts VBA. For example Multiframe structural analysis and DesignCAD have object models which are […]

Building a Structural (Engineering) Design eWorkbook – Part 2

So not going to jump straight into using MS Excel or LibreOffice Calc, rather going to start with VBScript, then move onto Excel/VBA. The reason is Basic in LibreOffice Calc doesn’t have an immediate window, and so all output has to be in  pop-up message boxes, or we have to start writing directly to spreadsheet […]

Determining the pressure coefficients on the surfaces of a structure using the wind loading code AS1170.2 is not an easy task, as the code has very little coverage of real world buildings, and thus is a relatively deficient code, and little wind loading research is being done to fill in the gaps. So the following […]

Design Wind Speeds for South Australia

BASIC REGIONAL WIND SPEED Typical Building/Structure V[R] = 45 m/s [162 km/h] mean return period 500 years 5% risk of exceedance for 25 year design life Post Disaster Building/Structure V[R] = 48 m/s [173 km/h] mean return period 2000 years 1.25% risk of exceedance for 25 year design life These wind speeds are typically as […]

General instructions for setting up environment for use of my spreadsheet collection, either downloaded from here or from ExcelCalcs. To test the installation, I create a new limited user account on MS Windows. I have done this previously for Windows XP, and Windows 7. The current process was on Windows 10, which is an upgrade of […]

Ten Types of Spreadsheet or eWorkBook Applications

TYPE 1: Reference Library These eWorkBooks are databases or tables of data which are largely constant, and used as lookup values for calculations. They include such things as materials libraries, properties of chemical elements and such things. {MS Access or other DBMS potentially the better tool for this} TYPE 2: Data Collection These are eWorkBooks […]

Geography of the Yorke Peninsula District Council Area

As indicated in earlier posts, now that outside the Adelaide metropolitan area looking for a simple means of continuing to use Excel/VBA and Acad LT as simple geographical information system(GIS). For such purpose I am not overly concerned about geographical features such as coastlines and roads. What I do need are simple rectangular map grid coordinates […]

Independent Technical Review

A truly independent technical should not require access to the designers notes and decision making process, and thus should not require any submission of calculations. An independent review should only require access to the specification-of-intent. With a complete specification, it should be possible to send it to the other side of the world and get […]

Doubly Pitched, Gable Roof Structures, enclosed buildings and canopies.

Introduction Simple doubly pitched roof. Two structural members and three joints, with two of the joints as supports. The basic connection options for joints is pinned that is having no moment restraint, or fully fixed in which case has moment restraint. If have moment restraint then joint can resist forces which tend to cause rotation […]