Tag Archives: UDF

Cubic Hermitic and Cardinal Splines

Posted on 14/05/2010 by dougaj4

In my previous post on splines I described a quick and dirty approach to adjusting a cubic spline to fit monotonic data, which did not meet with universal approval, so I have followed up Mike Woodhouse’s link: (http://en.wikipedia.org/wiki/Monotone_cubic_interpolation) which gives a … Continue reading →

Posted in Charts, Excel, Maths, UDFs, VBA | Tagged , , , , , , | 8 Comments

Automating chart scale limits

Posted on 28/04/2010 by dougaj4

Edit 22 Mar 2014:  Also see https://newtonexcelbach.wordpress.com/2012/11/25/automating-chart-scale-limits-update/ for improved version with download link, and example of plotting a chart from a formula entered as text. One of the more annoying things about Excel charts is that if you want to … Continue reading →

Posted in Charts, Excel, UDFs, VBA | Tagged , , , , | 8 Comments

Analysis of RC circular sections – theory and code

Posted on 25/04/2010 by dougaj4

The basic tasks involved in analysing the stresses and strains in a reinforced concrete section under combined bending and axial load are: Assuming a horizontal beam with the top of the beam in compression and the bottom in tension Find … Continue reading →

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

Reinforced concrete elastic analysis; Circular section

Posted on 24/04/2010 by dougaj4

Previous posts have presented the theoretical background to finding stresses and strains in a reinforced concrete section built up of trapezoidal layers and subject to combined bending and axial loads.  A spreadsheet with User Defined Functions (UDFs) and open source code … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , | 10 Comments

Calling a function as a variable – another example

Posted on 22/04/2010 by dougaj4

The recent posts on the Inverse Quadratic Method and Brent’s Method, and on calling a function as a variable, are leading towards a user defined function (UDF) to analyse circular reinforced concrete sections under combined bending and axial load, but since … Continue reading →

Posted in Concrete, Excel, Maths, UDFs, VBA | Tagged , , , , , | 3 Comments