Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Using LINEST for non-linear curve fitting
- Scipy linear algebra functions in Excel
- Cubic Splines
- Latex Maths Text in Excel
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Using LinEst() on data with gaps
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Section Properties of Defined Shapes - Spreadsheet
- Commenting a block of code in VBA
Recent Comments
Category Archives: Numerical integration
Installing Python and pyxll from scratch
Updated 28th September 2022. Matplotlib latest version OK. I recently installed Python and pyxll (plus the required additional libraries) on a new computer, which raised a few problems with incompatible versions, so here is a summary of what worked (as … Continue reading
Posted in Animation, Arrays, Charts, Coordinate Geometry, Differential Equations, Excel, Finite Element Analysis, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, Python Pandas, PyXLL, UDFs
Tagged Excel, installation, kaleido, MatPlotlib, mpmath, Numba, Numpy, Pint, plotly, PyPardiso, Python, PyXLL, SciPy, sectionproperties, Sympy
Leave a comment
SectionProperties update
In late 2017 I posted Section Properties with MeshPY, including torsion and warping which looked at an Excel front end for Robbie van Leeuwen’s SectionProperties program, which provides facilities for calculation of section properties of complex shapes, including torsion and warping constants. … Continue reading
Posted in Charts, Excel, Finite Element Analysis, Link to Python, Newton, Numerical integration, NumPy and SciPy, PyXLL, Strand7
Tagged Excel, Python, PyXLL, Section-Properties, Torsion
1 Comment
Tanh-Sinh Quadrature v. 5.03
Following some recent comments Graeme Dennes has released the latest version the Tanh-Sinh Quadrature spreadsheet with some corrections to the test function documentation. The new file is located (as before) at: Tanh-Sinh Quadrature For more information on the last major release … Continue reading
Tanh-Sinh Quadrature update
Following some comments here Graeme Dennes and I have modified the start-up code for the Tanh-Sinh Quadrature spreadsheet to avoid problems opening the file when first downloaded, or copied to a new computer. The new file is located (as before) … Continue reading
Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Excel, Tanh-Sinh Quadrature, UDFs, VBA
Leave a comment
Numerical Integration With Tanh-Sinh Quadrature v 5.0
Graeme Dennes has updated his Tanh-Sinh Quadrature spreadsheet to V 5.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: The Tanh-Sinh quadrature workbook has been … Continue reading
Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Excel, numerical integration, on-sheet calculations, Tanh-Sinh Quadrature, UDFs
13 Comments