### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- The angle between two vectors, Python version
- Cubic Splines
- Downloads by category
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using LINEST for non-linear curve fitting
- Drawing in Excel 7 - Creating drawings from coordinates
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Fitting high order polynomials

### Recent Comments

Peak Warming Man on Australian Greenhouse Gas… AS 3600 and RC Desig… on New AS 3600 and RC Design Func… dougaj4 on Brent’s Method and a daf… Craig on Brent’s Method and a daf… Craig on Brent’s Method and a daf… dougaj4 on Solving Quadratic, Cubic, Quar… brian on Solving Quadratic, Cubic, Quar… brian on Solving Quadratic, Cubic, Quar… metroxx on Using Section Properties-… dougaj4 on Using Section Properties-… More iterative solve… on Iterative solvers and arr… metroxx on Using Section Properties-… Craig on Arc-spline update dougaj4 on Arc-spline update Craig on Arc-spline update

# Author Archives: dougaj4

## AS 3600 and RC Design Functions 8.01

The updated RC Design Functions spreadsheet (presented here) included an updated UMom function to find the ultimate strength of a rectangular section under combined bending and axial load; but I omitted to include the revisions to the alpha2 and Gamma … Continue reading

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged AS 3600, Excel, Rectangular stress block factors, Reinforced Concrete Design Functions, UDF, ULS design, VBA
Leave a comment

## Falling feathers and hammers

It is well known that at the end of the Apollo 15 Moon landing, Commander David Scott dropped a hammer and a feather to demonstrate that they would accelerate at the same rate, and land on the ground together: What is … Continue reading

## More iterative solvers

Following the recent post on using Brent’s Method solvers on an array (Iterative solvers and arrays), here is another example with an engineering related problem. The example is included in the xlScipy3 spreadsheet, which can be downloaded from: xlScipy3.zip The depth … Continue reading

Posted in Arrays, Beam Bending, Concrete, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged Brents method, depth of neutral axis, Excel, Python, Reinforced Concrete, SciPy, UDFs, VBA, xlwings
Leave a comment

## Quite Good

This song has actually appeared here before, but it was a bit buried, so here it is again; Robin Williamson with a quite good interpretation of Like a Rolling Stone:

## Iterative solvers and arrays

A recent thread at Eng-Tips was looking for a solution to the problem described below: The solutions to this problem described below can be downloaded from: ItSolve.zip and xlScipy3.zip The ItSolve.xlsb spreadsheet contains a user defined function (UDF) to solve iterative … Continue reading

## Australian Greenhouse Gas Emissions

What the Australian Government says: PM claims Australia will meet Paris target ‘in a canter’ despite emissions climbing. Morrison says rate of increase not as high as previous years and renewables investment will ensure Australia meets commitment pm-claims-australia-will-meet-paris-target-in-a-canter-despite-emissions-climbing What the … Continue reading

## Time in hours and minutes between two dates

Dates and times in Excel are stored as a date number, which is the number of days since 1 January 1900, with the value after the decimal point representing the time of day. To calculate the number of hours between … Continue reading

Posted in Excel
Tagged Excel, format times, greater than 24 hours, Text function, time difference
4 Comments