Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Filling Blanks with Go To-Special (and local help rant)
- About Newton Excel Bach
- XLDennis, the MSDN Library, and VBA rant
- Downloads
- The history of the theory of beam bending - Part 1
- The history of the theory of beam bending - Part 2
- Units for Excel
Recent Comments
Author Archives: dougaj4
Jørn Utzon and David Moore
Tomorrow (9th April 2018) is the centenary of the birth of Jørn Utzon, the architect of the Sydney Opera House, which is celebrated in an article at the Sydney-Morning Herald. The article quotes a grand-son of Utson, Mika Utzon Popov, … Continue reading
Posted in Arch structures, Bach, Newton
Tagged construction photographs, David Moore, Jorn Utzon, Sydney Opera House
Leave a comment
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.