Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- About Newton Excel Bach
- XLDennis, the MSDN Library, and VBA rant
- Cubic Splines
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Automating chart scale limits - update
- Filling Blanks with Go To-Special (and local help rant)
- Frame Analysis with Excel - 3, Continuous beam or frame
- Downloads
- The history of the theory of beam bending - Part 1
Recent Comments
Author Archives: dougaj4
3D plots with the latest Matplotlib
Installing Python on a new computer, I found I had to downgrade Matplotlib to release 3.5.2 to get my 3D plotting functions to work. Further investigation found that the problem was the Axes3D function. Changing: ax = axes3d.Axes3D(fig)to: … Continue reading
Posted in Animation, Coordinate Geometry, Drawing, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, MatPlotlib, Plot 3D images, Python, PyXLL, Rotate 3D images, UDFs
4 Comments
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
2 Comments
Australasian Engineering Heritage Conference 2022
The Australasian Engineering Heritage Conference will be held at the Engineers Australia Sydney offices at 44 Market Street, Sydney on 12-13 October 2022. The theme of the conference is: Transport and Communications: Looking Forward – Looking Back‘. In addition to a wide … Continue reading
RC Design Functions 9.02; DevLength function
The RC Design Functions spreadsheet has now been updated to Version 9.02, and is available for free download from: RC Design Functions9.zip Changes in the new version include: The new DevLength function returns reinforcement development length to AS 3600, AS … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged array functions, AS 3600, AS 5100, BS 5400, Devlength, Eurocode 2, Excel, RC Design Functions, UDF, UMom, VBA
Leave a comment
Stereograms
Stereograms, when looked at the right way, reveal a hidden 3D image, or perhaps a hidden message. The example above was created at: Easy Stereogram Builder As well as a very simple tool to create your own stereograms, there are … Continue reading