Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- About Newton Excel Bach
- Filling Blanks with Go To-Special (and local help rant)
- Cubic Splines
- Writing Arrays to the worksheet - VBA function
- XLDennis, the MSDN Library, and VBA rant
- Daily Download 5: Frame Analysis
- Daily Download 3: ULS design of reinforced concrete sections
- Worksheetfunction.Transpose - changed behaviour in Excel 2013 and 2016
Recent Comments
Category Archives: Maths
A Loopy Link (and three more)
For some reason Doug Glancy’s Excel Blog has escaped my attention up till now, but having a browse today, I discovered this loopy animation: which would not have been out of place in Douglas Hofstadter’s “I am a Strange Loop” I really … Continue reading
Posted in Animation, Computing - general, Excel, Maths, Newton, VBA
Tagged Doug Clancy, Douglas Hofstadter, links, Multi-threding in VBA, Statistics. Financial Modelling, Sumbuddy
2 Comments
A mystery curve links to Jupyter
Reviewing some of my less visited links recently, I was intrigued by a post at The Math Less Travelled: The previous post at the site provides more details of the source of the curve, and some links to an interactive … Continue reading
Posted in Charts, Charts, Excel, Maths, Newton
Tagged curve generator, Excel, Jupyter, Maths, parametric curve, Python, Scatter chart
2 Comments
Section Properties – Lunes and Groups
Following a discussion at Eng-Tips and resulting comments I have updated my Section Properties spreadsheet to include calculation of the area and centroid of a “Lune” (the shape of a crescent moon). I have also added a “Re-draw Shape” button because … Continue reading
Posted in Drawing, Excel, Maths, Newton, VBA
Tagged Excel, group properties, Lune, section properties, VBA
2 Comments
xlSciPy 1.01
The xlSciPy spreadsheet, introduced here, has been updated with many new functions. The new version, including full open source code (VBA and Python) can be downloaded from: xlSciPy.zip The spreadsheet requires Python to be installed, including NumPy and SciPy. It … Continue reading
Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA
Tagged Excel. VBA, ExcelPython, Fast Fourier Transform, Python, SciPy distance functions, sparse solvers, UDF
Leave a comment