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


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



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