Recent Comments
Category Archives: Newton
The hole through the middle of the Earth – revised transit time
In the previous post in this series I produced a table of acceleration due to gravity against depth from surface, based on the four layers of the Earth (Crust, Mantle, Outer Core, Inner Core), assuming a constant density for each layer. … Continue reading
Posted in Differential Equations, Excel, Newton, UDFs, VBA
Tagged Excel, hole through the middle of the earth, ODE Function, UDF, VBA
3 Comments
Update to CHSplineA Function
I have recently corrected the CHSplineA function included in the CSpline2 spreadsheet. The earlier version was returning incorrect values for the slope and curvature of the spline (with output option 2), if the spacing of the points defining the spline … Continue reading
Beam on Elastic Foundations Analysis
A previous post on laterally loaded piles used a finite difference analysis to analyse the deflections and forces in a vertical pile subject to a lateral load at the top. An alternative approach to the same problem is presented in “Programming the Finite … Continue reading
Posted in Excel, Finite Element Analysis, Geotechnical Engineering, Newton, UDFs, VBA
Tagged Beam on elastic foundations, Excel, laterally loaded piles, UDF, VBA
6 Comments
AlgLib Spline function update
Following a question at the AlgLib Forum I have added the Hermite spline fit function to the AL-Spline-Matrix collection. The revised spreadsheet, with full open source code is available for download in 2007/20010 version and pre-2007 version. Typical output of the … Continue reading
The hole through the middle of the Earth – acceleration
In my first go at modelling a ball falling through a hole through the middle of the Earth I assumed constant density, and hence the acceleration at any point was proportional to the distance from the centre. That is of course … Continue reading
Newton Excel Bach, not (just) an Excel Blog 