Category Archives: Newton

Solving non-linear equations with two or more unknowns – 1

Posted on 30/09/2015 by dougaj4

Newton’s Method is a well known iterative solution for non-linear equations with one unknown.  That is, if some value Y depends on a variable X, then we can use Newton’s Method to find X for any given value of Y.  … Continue reading →

Posted in Beam Bending, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , , | 2 Comments

IP2 and IP2_py

Posted on 11/09/2015 by dougaj4

The IP2 spreadsheet provides functions to calculate: Intersection points of 2D lines or polylines Intersection points of 2 circles, or a line and a circle Intersection circle of two spheres and intersection points of 3 spheres 3D centre point of … Continue reading →

Posted in Coordinate Geometry, Excel, Link to Python, Maths, Newton, UDFs, VBA | Tagged , , , , , , , , , , , | 5 Comments

Reinforced Concrete Moment Curvature – Development over time

Posted on 28/08/2015 by dougaj4

I recently noticed that in the RC Design Functions spreadsheet the TimeCurve function had stopped working.  The function calculates the development of reinforced concrete section curvature over time, and was previously presented in Reinforced Concrete Moment-Curvature – 3; Restrained Shrinkage and Creep and Reinforced … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , , , , | Leave a comment

A Loopy Link (and three more)

Posted on 23/08/2015 by dougaj4

For some reason Doug Glancy’s Excel Blog has escaped my attention up till now, but having a browse today, I discovered this loopy animation: which would not have been out of place in Douglas Hofstadter’s “I am a Strange Loop” I really … Continue reading →

Posted in Animation, Computing - general, Excel, Maths, Newton, VBA | Tagged , , , , , | 2 Comments

There is No Planet B

Posted on 19/08/2015 by dougaj4

My latest (and final) President’s column from the Concrete in Australia Magazine: Some responsibilities of engineers are universally recognised. Everyone accepts that we have a duty to carry out design and construction so that structures will be serviceable, strong and … Continue reading →

Posted in Concrete, Newton | Tagged , , , | Leave a comment