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
- Downloads
- About Newton Excel Bach
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- Linking Excel to C - 2
- Downloads by category
- Writing Arrays to the worksheet - VBA function
Recent Comments
Author Archives: dougaj4
ACO, Pekka Kuusisto, Sam Amidon, Pentangle and Wedding Dress
Murder and Redemption, the current ACO concert series, led by guest musical director Pekka Kuusisto and folk musician Sam Amidon, combines American and British folk songs with the works of Janáček and John Adams. Here Pekka Kuusisto talks of performing the … Continue reading
Posted in Bach
Tagged ACO, Murder and Redemption, Pekka Kuusisto, Pentangle, Sam Amidon, Wedding Dress
Leave a comment
Christy Moore sings Beeswing
Back in 2011 I posted a link to Richard Thompson’s song Beeswing, sung by The Little Unsaid. That post still brings a trickle of visitors to his site, which led me to this version by Christy Moore: and Christy Moore’s … Continue reading
Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
Least squares linear regression in Excel is easy. That’s what the Linest and Trend functions do. That is, they find the coefficients of a straight line (or higher dimension shape) so that the sum of the squares of the distances of … Continue reading
Posted in AlgLib, Curve fitting, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA
Tagged AlgLib, Linest, Python, SciPy, UDF, VBA, Weighted least squares regression
9 Comments
Debugging with xlwings and PyCharm
The xlwings documentation covers de-bugging, but it is very brief and it took me some time to get everything working, so this article covers the process in a bit more detail. The details are affected by the editor being used, … Continue reading
Posted in Excel, Link to Python, UDFs, VBA
Tagged debugging xlwings, Excel, PyCharm, Python, UDF, VBA, xlwings
Leave a comment
Some thoughts on Magic …
… from Alana Hicks, Leonard Cohen, and Buffy St Marie. Alana Hicks is a friend of my daughter’s. This is her story: … which reminded me of a song I heard once on the radio over 40 years ago, and … Continue reading
Posted in Bach
Tagged Alana Hicks, Buffy Sainte-Marie, Leonard Cohen, Magic, Magic is Afoot, Smoke and Fire
2 Comments