Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Downloads
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Writing Arrays to the worksheet - VBA function
- Contour plots with Excel and Matplotlib
- Latex Maths Text in Excel
- About Newton Excel Bach
- Converting from global to local coordinates (and vice versa)
- Linking Excel to C - 2
Recent Comments
Category Archives: Newton
High definition Mandelbrot
There have been several posts here about generating animations of the Mandelbrot set, most recently at Display Matplotlib animations in Excel, but using standard 64 bit floats you rapidly run out of precision. However, using arbitrary precision arithmetic, and with sufficient … Continue reading
Posted in Bach, Computing - general, Newton
Tagged Arbitrary precision, Beethoven, Mandelbrot animation, Mandelbrot Set
Leave a comment
py_RC Elastic update 2
Following the previous post, I have added a further new function, and in the process discovered that the py_Estress function was not handling tensile axial loads correctly. That has now been fixed, and the updated spreadsheet and Python files can … Continue reading
Posted in Beam Bending, Concrete, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Concrete creep and shrinkage, Creep and shrinkage development, Excel, Python, PyXLL, Reinforced Concrete, SciPy, UDF
Leave a comment
py_RC Elastic update
Following the previous post I have updated the py_RC Elastic spreadsheet and code to work with the new solver function, and also add new functionality. The updated files can be downloaded from: py_RC Elastic.zip For details of the pyxll app … Continue reading
Posted in Concrete, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Concrete creep and shrinkage, Eurocode 2 concrete properties, Excel, Python, PyXLL, RC moment-curvature, UDFs.
Leave a comment
Scipy solver update
The py_SolveFS function calls the Scipy optimize.root function to solve multi-variable equations. Examples are found on the py_Solvers spreadsheet, see Scipy Functions with Excel and pyxll 4 – Solvers 2. One problem with using this function is that the input data … Continue reading
Posted in Excel, Link to Python, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, Python, PyXLL, py_SolveFS, SciPy, Scipy root function, Solver functions, UDFs
Leave a comment
Pale Blue Dot
34 years ago Carl Sagan presented an image of the Earth taken from outer space, known as the pale blue dot. An event very different from a 13 year old boy singing a song he had written himself, but the … Continue reading