Recent Comments
Author Archives: dougaj4
The hole through the middle of the Earth – filled with air
Three air molecules go into a hole, Well, I say three; could have been four or five. Could have been nine or ten, doesn’t matter. Could have been fifteen, twenty – fifty. Round it up. Hundred. Let’s go mad, eh … Continue reading
Posted in AlgLib, Differential Equations, Excel, Maths, Newton, UDFs, VBA
Tagged big numbers, Excel, hole through the middle of the earth, ODE Function, Perfect gas, UDF, VBA
4 Comments
Three blokes go into a pub …
“… Well, I say three; could have been four or five. Could have been nine or ten, doesn’t matter. Could have been fifteen, twenty – fifty. Round it up. Hundred. Let’s go mad, eh – two-fifty. Tell you what, double … Continue reading
AlgLib Complex Number Functions
The AlgLib module ap.bas includes complex number functions which can be called from other VBA routines, but they cannot be used as User Defined Functions (UDFs) because they use the user defined data type “Complex”: To call these functions from the … Continue reading
Posted in AlgLib, Excel, Maths, Newton, UDFs, VBA
Tagged AlgLib, complex numbers, Excel, math functions, UDF, VBA
2 Comments
Buckling of columns with varying cross section
Following a post in the Eng-Tips Forum about finding the buckling load of a stepped strut I have modified the Frame4 spreadsheet to carry out a buckling analysis of any straight member subject to axial load, including stepped or tapered cross … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, VBA
Tagged column buckling, Euler buckling, Excel, Frame Analysis, stepped column, tapered column, VBA, Vianello
27 Comments
A musical interlude …
… provided by my daughter’s latest music video with the excellent English band The Perishers:
