Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Cubic Splines
- About Newton Excel Bach
- The history of the theory of beam bending - Part 1
- Downloads
- Writing Arrays to the worksheet - VBA function
- Retrieving unique values from a range or array ...
- Filling Blanks with Go To-Special (and local help rant)
- The history of the theory of beam bending - Part 3
Recent Comments
Tag Archives: SciPy
Evaluating text and Integration with Python and ALGLIB
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 AlgLib, evaluation of text strings, Excel, Integration, Python, SciPy, VBA
1 Comment
Installing Python, Scipy and Pyxll
I have recently been experimenting with Pyxll, which after a few initial hiccoughs is proving to be an easy and efficient way to connect Excel to Python based scientific and maths applications, such as linear algebra routines and ODE solvers. … Continue reading
Posted in Excel, Link to dll, Link to Python
Tagged Anaconda, link Excel to Python, Python, PyXLL, SciPy
15 Comments