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 […]
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 […]
More Comparing Calculation Tools
Before continuing with Building a Structural Engineering Design eWorkbook, I thought I would backtrack and extend the comparison of calculation tools. In the first article I compared some computer based calculators, Computer Algebra Systems (CAS) and simple scripting languages. ATCalc Calc98 SMath (cf. MathCAD) FreeMat (cf. MatLAB) Python VBScript (WSH) JScript (WSH) FreeBasic LibreOffice Calc […]
Work Measurement and Time Study
Amongst other things, being an industrial engineer (MIIE(Aust) resigned 2014) I don’t dismiss time casually, so when I say we don’t sell time it doesn’t mean we don’t pay attention to time. When conducting a time study, it is typically done using a decimal minute stopwatch (if you can find one in SA), so instead […]