Recent Comments
Author Archives: dougaj4
Finding Circle Centres in 3D
In 2 new functions for IP.xls I described two Excel User Defined Functions (UDFs) to find the radius and centre of a circle defined by 3D coordinates for either 3 points on the circumference, or for two tangent points and the … Continue reading
Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA
Tagged 3D coordinates, Center, Circle Centre, direction cosines, Excel, IP2.xls, Radius, UDF, VBA
5 Comments
Continuous beam with specified end conditions …
… and/or support displacements. The previous post in this series derived cubic splines with specified end conditions; either a specified curvature or a specified end slope. I have adapted the splinebeam function to allow input of specified end conditions (either a … Continue reading
Posted in Arrays, Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Maths, Newton, UDFs, VBA
Tagged bending moments, continuous beam analysis, Cubic spline, deflections, Excel, shear forces, UDF, VBA
1 Comment
Climate change and political opportunism
Senator Steve Fielding is the leader of a small political party in Australia and a member of the the Federal Senate (the Australian upper house). For some reason he sends me occasional e-mails, which usually go straight in the bin, … Continue reading
From the Ridiculous to the Sublime
Our previous musical interlude featured a positively Pythonic Wizz Jones battling the Newquay Urban District Council, but now for something completely different. On Sunday the cellists Emma-Jane Murphy and Daniel Yeadon treated us to performances of Bach’s 1st and 5th Suites … Continue reading
Using Goal Seek on Multiple Cells
The Excel “goal seek” function is useful and powerful, but the procedure for using it on multiple cells is painfully slow. The spreadsheet GSeek.xls provides a simple macro to allow Goal Seek to be automatically applied to a range of … Continue reading
