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