Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Using LINEST for non-linear curve fitting
- About Newton Excel Bach
- Cubic Splines
- Downloads
- Filling Blanks with Go To-Special (and local help rant)
- XLDennis, the MSDN Library, and VBA rant
- Linking Excel to C - 2
- The Conjugate Beam Method
- Daily Download 4: Continuous Beam Analysis
Recent Comments
Tag Archives: Excel
Numerical Integration With Tanh-Sinh Quadrature v 6.0
Graeme Dennes has updated his Tanh-Sinh Quadrature spreadsheet to V 6.0. The new version (including full open source code) may be downloaded from: Tanh-Sinh Quadrature Graeme’s summary of the new features in the spreadsheet: Note that the speed improvement is … Continue reading
Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Excel, numerical integration, on-sheet calculations, Tanh-Sinh Quadrature, UDFs.
Leave a comment
Cleaning Data – Sort functions and shortcuts
Back in 2020 I posted here on New sort functions and sorting to groups, looking at using the sort functions to clean data. Revisiting that post I found that the link to the sample spreadsheet was broken, and that is now … Continue reading
Posted in Computing - general, Excel
Tagged Excel, Excel and pdfs, Shortcuts for cleaner data, Sort Functions
Leave a comment
VBA polynomial functions update
Following several comments at an old post I have made updates to the Polynomial spreadsheet. The new files can be downloaded from: Polynomial.zip The changes are: SolvePoly was amended to accept numbers or signed cell addresses in the input. QuarticR, … Continue reading
Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs, VBA
Tagged Excel, high order simultaneous equations, Link to Python, Numpy, Polynomial equations, PyXLL, solve simultaneous equations, UDFs
Leave a comment
Passing 3D arrays to Excel with Python and pyxll
The previous post looked at options for displaying 1D or 2D arrays in Excel. This post will look at passing 3D arrays from Python to Excel as a cache object, using pyxll, and how to extract selected data from the … Continue reading
Posted in Arrays, Excel, Link to Python, Newton, PyXLL, UDFs
Tagged array functions, dynamic arrays, Excel, PyXLL, pyxll cache object, UDFs
1 Comment