{This is something I wrote a few years back. It was an exercise of “killing two birds with one stone”. I was writing VBA macros to export chunks of Excel worksheets to HTML, and I wanted to extend it to include pictures. I also had an idea of writing an article on the problems simple […]
Structural Design of Traffic Signs
{This is a re-posting of commentary I originally posted in my state-of-play posts. I have given it its own post, so I can extend and revise as needed.} Now road signs are established technologies, there must be hundreds of them all over the world. We don’t expect them to fail, and certainly don’t expect them […]
Caravan and Residential Parks and Population Density
So as I have tended to point out here and elsewhere on the net, humans have legs and are meant to be mobile, they are not plants anchored to the earth and trapped in one place. However humans cannot remain permanently in motion, they need to rest, and a place to rest. Whilst the minimum […]
Structural Design and Calculations
As you may have noticed elsewhere I try to avoid the use of the word “engineering”, this is because for me engineering takes place at the frontiers of science and technology. I don’t operate at the frontiers and most people don’t want their projects at the frontiers. Most people simply want “tried and tested” adapted […]
Engineering Calculations and Approval
{This is a edited version of an email I sent this week (2019/week 14) attempting to explain nature of calculations and the approval of calculations. The problem I was attempting to deal with is the Queensland legislation. Being edited it has some client specific references removed, and also extends on what I was attempting to […]
Residential Slabs and Footings
For the most part residential slabs and footings shouldn’t require any “engineering”. AS2870 Residential slabs and footings is mostly a prescriptive code like volume 2 of the National Construction Code (NCC or BCA {Building Code of Australia} ), and the residential timber framing code AS1684.2. As such building designers, builders and concrete contractors should be […]
Building a Structural (Engineering) Design eWorkbook – Part 8
Seems going to be a delay for a while, whilst make some major changes to the VBA code. Relative to existing workbooks the following are of importance: Workbook Design Engine The designEngine workbook has two user forms as illustrated here. The main form contains options to: Analyse gable frame (Kleinlogel Frame III) Produce Height vs […]
Building a Structural (Engineering) Design eWorkbook – Part 7
So taking a look at the workbook primary data tables. The table comprises of fields: group, description, block Name, value, units, edit field, editValue, CalcValue, isParameter. Block name, is carry over from Quattro Pro where group of cells referred to as a block rather than a range. In the main it is just the name […]
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 […]
Building a Structural (Engineering) Design eWorkbook – Part 5
So in part 3 I made use of various DBMS to store input data and calculated results. the data stored in tables, each row of the table is a record and each column of each record is a field. High level programming languages allow data structures to be defined collecting all the fields together into a […]