Tag Archives: Python

More on combined shear and bending design to AS 3600

Posted on 15/12/2022 by dougaj4

Further to the last post on this subject I have been looking at procedures to speed up design for shear to AS 3600 when the “refined” analysis procedure is used. The issues that need to be addressed are: I have … Continue reading →

Posted in Beam Bending, Concrete, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , , , | 4 Comments

Latex Maths Text in Excel

Posted on 27/11/2022 by dougaj4

There have been many posts here looking at alternative ways of working with functions entered as text on a spreadsheet, and working with units, most recently here. One drawback with this approach is that text in an Excel cell must … Continue reading →

Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , , , , , | Leave a comment

Linking to Python help from Excel

Posted on 06/11/2022 by dougaj4

The py_Numpy spreadsheet presented in the previous post has been updated: The new version can be downloaded from: py_Numpy.zip As before, the pyxll add-in is required for the connection from Excel to Python. All the available functions are listed on … Continue reading →

Posted in Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , | Leave a comment

Working with Python polynomials from Excel

Posted on 22/10/2022 by dougaj4

Python polynomial functions have several features that require manipulation of data passed from Excel: I have written 3 short Python functions to deal with passing arrays of complex numbers from and to Excel, using pyxll, or within Python code to … Continue reading →

Posted in Arrays, Excel, Link to Python, PyXLL, UDFs | Tagged , , , , , , , , , | Leave a comment

3D plots with the latest Matplotlib

Posted on 30/09/2022 by dougaj4

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 , , , , , , | 4 Comments