Building a Structural (Engineering) Design eWorkbook – Part 6

In part 5 I briefly covered classes, whilst in part 3 I covered the use of DBMS to store and retrieve data. One approach for the tables was a table with a record structure: characteristic, value, units, isParameter. For which purpose I wrote a function getCharacteristic and subroutine setCharacteristic to get and set the data […]

Using Technical Library and Database for Cold-Formed Steel Design to AS4600

As I mentioned in Building a Structural (Engineering) Design eWorkbook – Part 4  a calculation of section and member moment capacity to AS4600 can be relatively simple, with my original illustration of such being presented here: On Calculations and Software Part 1. Using such technical library , and materials library, it is possible to generate simple member capacity tables […]

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

State of Play 2018/wk50

Health Last week of phase 2 heart rehab. Last session thursday (13/12/2018), at the start of next year will start on phase 3 maintenance. So today repeated the 6 minute test, as did at the start of the programme. Showed improvement. Past few sessions also increased time on treadmill from 5 minutes to 15 minutes […]

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

State of Play 2018/wk48

As at week 48 day (25/11/2018 Sunday). At some point between week 43 and now, experimented with VBA editor objects and extracting data from VBA project. Typically experimenting with VBA techniques to sever structural calculations from MS Excel, starting by shifting some data to database management system (DBMS), and converting worksheet calculations to VBA code. […]

State of Play 2018/wk42

Health So went to see the cardiologist in Wallaroo. Nurse measured weight, height and blood pressure and also took ECG, after which I saw the cardiologist. Dad drove me there from Maitland, mum and dad went shopping whilst I was at the doctors, on the way back they suggested we visit centrelink. So did that. […]

State of Play 2018/wk41

Times passed quickly, though seemed slow, since had the heart attack. When came out of hospital put into a routine of getting an INR (international normalised ratio) check each day to determine adjustments for Warfarin medication. A nurse pricks my finger and draws blood,  a device with a small replaceable card is then used to […]