### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Cubic Splines
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using LINEST for non-linear curve fitting
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Downloads by category
- Solving cubic and quartic equations with Excel
- ULS Design Functions - update for AS 3600

### 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