Category Archives: Maths

Evaluating text and Integration with Python and ALGLIB

Posted on 07/07/2014 by dougaj4

Following the previous post on evaluating mathematical functions entered as text on the spreadsheet, I have now written a spreadsheet with similar functionality using Python functions, and the Excel-Python add-in.  Also included are integration functions using the SciPy Python library, … Continue reading →

Posted in AlgLib, Arrays, Excel, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, UDFs, VBA | Tagged , , , , , , | 1 Comment

Evaluating text – update

Posted on 28/06/2014 by dougaj4

One disadvantage of the spreadsheet style interface is that even simple formulae are difficult to check.  For instance, the deflection of a cantilever loaded at the end is given by: F*L^3/(3*E*I) which is much easier to read than the Excel … Continue reading →

Posted in AlgLib, Excel, Maths, Newton, Numerical integration, UDFs, VBA | Tagged , , , , , , , | 5 Comments

Feet and inches, and other units

Posted on 31/05/2014 by dougaj4

Following a query at Eng-tips I have had a look at options in Excel for converting metres to feet and inches, with the inches displayed as a fraction rather than a decimal. Converting from metres to feet or inches is … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , | 1 Comment

Python Matrix Functions with ExcelPython – 2

Posted on 28/05/2014 by dougaj4

Following the previous ExcelPython post I have modified the VBA and Python code for improved performance and to simplify the Python coding.  The main change is that where Numpy Arrays are required in the Python code, these are now created … Continue reading →

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

Linking to Python with Excel-Python, and Python matrix functions

Posted on 22/05/2014 by dougaj4

I have been experimenting for a few weeks with a new package linking Excel to Python, by the name of ExcelPython.  Here is what the author says about it: “ExcelPython is a lightweight, easily distributable library for interfacing Excel and … Continue reading →

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