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
- About Newton Excel Bach
- Filling Blanks with Go To-Special (and local help rant)
- XLDennis, the MSDN Library, and VBA rant
- Daily Download 4: Continuous Beam Analysis
- Downloads
- Linking Excel to C - 2
- Writing Arrays to the worksheet - VBA function
Recent Comments
Author Archives: dougaj4
Mini-tours of India – 1
Following a 17 day tour of the Rajasthan region of India, the next few days will feature selected photographs of the places visited on route, starting with the city of Agra, the Agra Fort, and the Taj Mahal:
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
7 Comments