Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Using LINEST for non-linear curve fitting
- Downloads
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Downloads by category
- 3DFrame - 3D Frame analysis for Excel
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Beam actions and deflections by Macaulay's Method
- About Newton Excel Bach
- Using Linest for non-linear curve fitting, examples, hints and warnings
Recent Comments
Tag Archives: hole through the middle of the earth
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
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
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
Using the AlgLib ODE (Runge-Kutta) Solver with Excel
Or to be more correct, the AlgLib Cash-Karp Solver, Cash-Karp being a refinement of the Runge-Kutta method of solving ordinary differential equations. Solution of differential equations is an iterative process requiring the repeated application of the solver routine followed by evaluation of … Continue reading
Posted in AlgLib, Beam Bending, Differential Equations, Excel, Maths, Newton, UDFs, VBA
Tagged AlgLib, buckling, Cash-Karp, differential equations, Excel. VBA, hole through the middle of the earth, Runge-Kutta, SHM, UDF
8 Comments