Recent Comments
Category Archives: Newton
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
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
Update to Frame4.xls
It was recently pointed out to me that the non-uniform load calculation in Frame4.xls gave incorrect results. The code for the non-uniform load has now been fixed, and the spreadsheet can be downloaded from Frame4.zip
Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, VBA
Tagged Excel, Frame Analysis, VBA
1 Comment
Newton Excel Bach, not (just) an Excel Blog 