Recent Comments
Category Archives: Excel
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
Office 2010; Installation problems and solutions
I installed Office 2010 a couple of weeks ago, and I have just succeeded in getting the help system to work. After pressing F1, or clicking the Help icon, I was getting a screen saying that the help system was … 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
Newton Excel Bach, not (just) an Excel Blog 