### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Using LINEST for non-linear curve fitting
- The angle between two vectors, Python version
- Fitting high order polynomials
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Fine as a Bee's wing
- Section Properties with MeshPY, including torsion and warping
- Cubic Splines
- About Newton Excel Bach

### Recent Comments

dougaj4 on Using Section Properties-… Mattias on Using Section Properties-… dougaj4 on Using Section Properties-… Mattias on Using Section Properties-… dougaj4 on ULS Design Functions – u… hadwao on ULS Design Functions – u… ULS Design Functions… on Concrete ULS spreadsheet … Working with dynamic… on Returning Arrays From VBA and… dougaj4 on Drawing in Excel – … J.D. on Drawing in Excel – … dougaj4 on The Largest Early World Map… Doug Glancy on The Largest Early World Map… Larry Schuster on How Reinforced Earth work… dougaj4 on ConBeamU 4.13 roshan_rai@hotmail.c… on ConBeamU 4.13

# Category Archives: Newton

## Numerical Integration; Tanh-Sinh Quadrature v. 4.42

Back to Newton and Excel. I recently received a new update to the Tanh-Sinh Quadrature spreadsheet from Graeme Dennes, which may be downloaded from: Tanh_Sinh Quadrature. From the Readme: The Tanh-Sinh quadrature workbook has been enhanced as follows: The Tanh-Sinh … Continue reading

Posted in Charts, Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Double Exponential, Excel, Gauss-Kronrod, numerical integration, Romberg, Tanh-Sinh method, Tanh-Sinh Quadrature, UDF, VBA
Leave a comment

## Sydney Opera House: the designs that didn’t make it

From the Guardian: In 1956, the New South Wales premier Joseph Cahill announced a competition – open to anyone – to design a national opera house at Bennelong Point in Sydney. There were more than 200 entries and the eventual … Continue reading

## Multiple Integration with Scipy

Scipy has 3 functions for multiple numerical integration in the scipy.integrate module: dblquad: Compute a double integral. tplquad: Compute a triple integral’ nquad: Integration over multiple variables. I have written six functions to call these functions from Excel, via Pyxll: Each … Continue reading

Posted in Excel, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, multiple integration, Python, PyXLL, SciPy, UDFs
6 Comments

## Another (very slow) way of computing pi

The previous post included 100 Python code one-liners for calculating pi that recalculates in a fraction of a second. The video below shows an alternative approach that is a little slower: How much slower? If you had a computer that would … Continue reading

## mpmath for Excel

mpmath has been mentioned in passing here before, but not in any detail. The mpmath site says: mpmath is a free (BSD licensed) Python library for real and complex floating-point arithmetic with arbitrary precision. It has been developed by Fredrik … Continue reading

Posted in Excel, Link to Python, Maths, PyXLL, UDFs, VBA, xlwings
Tagged evaluate pi, Excel, high precision maths, mpmath, Python, PyXLL, UDFs, VBA, xlwings
Leave a comment

## More updates to ArcSpline and IP2

I have uploaded version 2.18 of the IP2 spreadsheet to: IP2.zip The new version includes updates to the IP, IP_4, and ArcSpline functions, as described below. The download is free and includes full open-source code. The IP and IP_4 functions find … Continue reading

Posted in Arrays, Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA
Tagged arcspline, Array function entry, Automatic re-size array functions, Excel, IP2.xlsb, Line intersections, UDFs, VBA
Leave a comment

## More SciPy Solvers

The xlwings Scipy spreadsheet has been updated with a new example of the xl_SolveF function, that uses the Scipy Optimize root function. The new spreadsheet can be downloaded from: xlScipy3.zip The new example uses a python function ic_calc (included in the … Continue reading

Posted in Excel, Link to Python, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged bolt group, Excel, Python, SciPy, solvers, UDFs, VBA, xlwings
Leave a comment