MiScion Home

Small family structural design and technical services business, comprising of father (Roy) and son (Conrad). The business was formed in 1994 and operated in the northern suburbs of Adelaide, South Australia, in particular in the Tea Tree Gully (TTG) area and surrounds, until 2014 when we moved everything to Maitland on the Yorke Peninsula. The trading name was solely Roy Harrison & Associates until 2009 when we registered the company name MiScion Pty Ltd: now the name alternates between the two.


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


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


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



Spreadsheet Bundle for Cold-formed Steel Structures Design

Price: name your price Design of cold-formed steel structures to AS4600.  Contains:  Materials library Technical library add-in Quick Calculator Workbook for member checks Bolt capacity tables Example of using spreadsheet iteration to calculate effective section modulus for cold-formed c-section. The technical library contains functions to obtain effective section modulus directly so do not need the […]


Spreadsheet Bundle

Price: Sponsored Product Description: Single zip file package of spreadsheets otherwise available from my ExcelCalcs profile, Warning: The spreadsheet bundle is just a convenient reference for the spreadsheets uploaded to ExcelCalcs. It will only be updated at the end of each year, if and only if the spreadsheets on ExcelCalcs are updated. The spreadsheets will only […]


Footing Calculator using Rutledge Formula

Rutledge formula for flag pole footing design

Price: Name Your Price Description: Simple spreadsheet calculator to check footing design using Rutledge formula.   Previous Footing Design Next


Frame Selection Charts for Cold-formed Steel Sheds

Design charts for gable frame sheds, terrain category 3

Height versus span selection charts for fixed based portal frame sheds, with frames at 3m centres, made from cold-formed steel c-sections, for wind terrain category 3. The pitch of the doubly pitched roof is 10 degrees. Shed Industry Shed Design Next


Spreadsheet Bundle for Steel Structures Design

Price: (name your price) : As a start consider your own hourly rate and the time it is likely to take to create such workbook and the time needed to learn how to use. For students the hourly rate is zero therefore price is zero, for consultants working on multimillion dollar buildings a reasonable price […]