Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- About Newton Excel Bach
- Cubic Splines
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Downloads
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- Frame Analysis with Excel
- Frame Analysis with Excel 1 - Single beam
- Writing Arrays to the worksheet - VBA function
Recent Comments
Author Archives: dougaj4
Scarborough Fair
Scarborough Fair is a very old song, according to Wikipedia dating back at least to 1670, and probably much earlier. Here are three versions from the mid-sixties. The first from Martin Carthy was released in 1965, on his first album: The … Continue reading
Posted in Bach
Tagged Marianne Faithful, Martin Carthy, Scarborough Fair, Simon and Garfunkel
2 Comments
More updates to ArcSpline and IP2
I have uploaded version 2.18 of the IP2 spreadsheet to: IP2.zip The new version includes updates to the IP, IP_4, and ArcSpline functions, as described below. The download is free and includes full open-source code. The IP and IP_4 functions find … Continue reading
Posted in Arrays, Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA
Tagged arcspline, Array function entry, Automatic re-size array functions, Excel, IP2.xlsb, Line intersections, UDFs, VBA
2 Comments
More SciPy Solvers
The xlwings Scipy spreadsheet has been updated with a new example of the xl_SolveF function, that uses the Scipy Optimize root function. The new spreadsheet can be downloaded from: xlScipy3.zip The new example uses a python function ic_calc (included in the … Continue reading
Posted in Excel, Link to Python, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged bolt group, Excel, Python, SciPy, solvers, UDFs, VBA, xlwings
Leave a comment
Solid Air – Norma Waterson
I don’t know how I missed this, but I just discovered yesterday: More about the album: The Very Thought of You On her second solo album the Grande Dame of British folk is presenting us with a surprising, inspired selection … Continue reading
Posted in Bach
Tagged Danny Thompson, John Martyn, Martin Carthy, Norma Waterson, Richard Thompson
Leave a comment
Python Problems
I have recently returned to using Pyxll to link Excel to Python (of which more later), which required the installation of a 32 bit version of Python 3.7. First trials after installation returned the message: “AttributeError: ‘module’ object has no … Continue reading
Posted in Computing - general, Link to Python, NumPy and SciPy
Tagged CLSIDToPackageMap, installation, Python, py_gen
Leave a comment