Category Archives: Newton

Python for VBA users – 2

Posted on 29/09/2013 by dougaj4

This post will look in more detail at translating the VBA Quadratic function (described in Python for VBA users – 1) into a Python function, linked to Excel via PyXll.  For the purposes of this exercise I created a new Python … Continue reading →

Posted in Excel, Link to Python, NumPy and SciPy, UDFs, VBA | Tagged , , , , , , | 11 Comments

EvalA update and examples

Posted on 06/08/2013 by dougaj4

The EvalA User Defined Function (UDF) has been included in the Eval2 and Eval-Integration spreadsheets for some time, but was not documented.  That has now been fixed, and both spreadsheets can be downloaded from Eval2.Zip (including full open-source code). The … Continue reading →

Posted in Arrays, Charts, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , | Leave a comment

SelectAv Function

Posted on 30/07/2013 by dougaj4

Suppose you have a spreadsheet range containing numerical data, and would like to find the average for a number of the most recent values, ignoring the highest (and/or lowest) values from the selected set. If you like using long array … Continue reading →

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

Using RC Design Functions 4 – Umom and new MaxAx function

Posted on 21/07/2013 by dougaj4

Previous post in this series. Download latest version of RC Design Functions6. Previous posts in this series have looked at elastic design functions.  We now move on to functions for ultimate limit state (ULS) analysis of reinforced concrete sections: UMom: … Continue reading →

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

Concrete ULS spreadsheet update-2

Posted on 17/07/2013 by dougaj4

The concrete ULS design spreadsheet last posted at: Concrete ULS spreadsheet update has been updated to fix a problem encountered with non-symmetrical reinforcement using the Eurocode 2 rectangular stress block. Download from ULS Design Functions. Typical input and output interaction diagram are … Continue reading →

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