Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Downloads
- XLDennis, the MSDN Library, and VBA rant
- About Newton Excel Bach
- Filling Blanks with Go To-Special (and local help rant)
- Cubic Splines
- Frame Analysis with Excel - 3, Continuous beam or frame
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Writing Arrays to the worksheet - VBA function
Recent Comments
Author Archives: dougaj4
Two sources of perpetual motion
The buttered cat phenomenon: The pulling-yourself-up-by-your-boot-straps technique:
Plotting Charts With Gaps …
“How do you get VB6 to initialize doubles with +infinity, -infinity and NaN”… and various sorts of Not a Number. Back in 2012 (When is an xy chart not an xy chart) I concluded that it was not possible to … Continue reading
Posted in Arrays, Charts, Charts, Excel, UDFs, VBA
Tagged Chart, NaN, plot blank, XY chart with gaps
7 Comments
More circle fitting options with Scipy
A comment on the first post on this topic found that the method used did not work well for short arcs of large radius circles. An example of the problem can be seen in the screen shots below: The function … Continue reading
Posted in Coordinate Geometry, Curve fitting, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged curve fitting, Excel, least squares, Numpy, ODR, Python, SciPy, VBA
Leave a comment
Seven -Up
A very nice version of John Renbourn’s “Seven Up” recently discovered on You Tube: … which led me to another piece by the same artist: … and a live version of Sweet Potato by Renbourn himself.
Year 10 Report
Last years’ statistics for this blog are now uploaded to Onedrive, and since this is now 10 years since the blog started, I have also included statistics since the start. The link to each post is preserved in the spreadsheet, … Continue reading