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 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) : 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. Divide the estimated cost by 1000 as that is the maximum number of units expect will ever be downloaded. For students […]


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.   License and Support Free Personal Business


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. — Summary Price List Sponsor Development


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. Divide the estimated cost by 1000 as that is the maximum number of units expect will ever be downloaded. For students […]