Tag Archives: Excel

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

Editing Charts with the mouse

Posted on 13/09/2015 by dougaj4

When editing chart ranges, to either change the limits of the range, or select a new column, I have been in the habit of either selecting a range and editing the text in the Formula Edit Bar, or right clicking, … Continue reading →

Posted in Charts, Excel | Tagged , , | 4 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

Filling Blanks with Go To-Special (and local help rant)

Posted on 10/08/2015 by dougaj4

Recently a thread at the Eng-Tips forum prompted me to look for help on the Go To-Special function in Excel.  Pressing F5-Alt S, then clicking the help icon in the dialog box brought up: It seems that the offline help … Continue reading →

Posted in Excel, VBA | Tagged , , , , , , | 13 Comments