Building a Structural (Engineering) Design eWorkbook – Part 4

So as mentioned in state-of-play 2018/wk50  I got sidetracked using MSHTML to read data from html files, specifically the Chrome bookmarks file (the exported HTML not the main JSON formatted file). Also I started writing the state-of-play article on the thursday and got interrupted so completed today (19/12/2018). Now using VBScript doesn’t seem much of […]

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

Determination of Pressure Coefficients to Wind Loading Code

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

A Study Tour Wind Loading of Structures

The beginnings (eg. table of contents) of a  guided tour through various aspects of the wind loading of structures. Qualitative Overview Beaufort Windscale Chart The Recent Adelaide Wind Storms Related to Australian Wind Loading Code Design Wind Speeds for South Australia TechNote#006 Internal Pressure Coefficients Industrial/Commercial Buildings Quantitative Tools Wind Loading Risk Assessment Wind Loading BCA Importance Levels […]

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

Setting Up Spreadsheet Environment

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