Category Archives: Maths

Python for VBA users – 5; Using built in numpy functions

Posted on 13/10/2013 by dougaj4

Previous Python Post In previous posts in this series I have looked at translating VBA functions to solve quadratic and cubic equations, but the Python numpy library has a polyroots function that will solve polynomials of any degree, and will … Continue reading →

Posted in Arrays, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA | Tagged , , , , , , , , , , , | 5 Comments

Python for VBA users – 3

Posted on 01/10/2013 by dougaj4

In the previous post in this series I looked at translating a routine to solve quadratic equations from VBA to Python.  Using the same process I have also created Python code to solve Cubic equations.  The only added difficulty for the … Continue reading →

Posted in Excel, Link to Python, Maths, UDFs, VBA | Tagged , , , , , , | 2 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

Section properties for groups of defined shapes

Posted on 12/04/2013 by dougaj4

Following a discussion at Eng-Tips, I have modified the section properties spreadsheet (presented here) so that section properties can be found for groups of defined shapes, including provision for translation and rotation of each shape, and application of different E … Continue reading →

Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA | Tagged , , , | 13 Comments