Recent Comments
Tag Archives: PyXLL
AS 3600 public comment draft and py_RC Design
A draft of the latest update to AS 3600 (the Australian code for concrete structures) was recently published for public comment (now closed). There are many significant changes to design procedures, and I have updated the py_RC Design spreadsheet to … Continue reading
py_RC Design with 3D Cache
Following my recent post on passing 3D arrays from Python to Excel I have now added a py_UmomC function to the py_RC Design spreadsheet. The new spreadsheet and Python code, along with related code, can be downloaded from: py_RC Design.zip … Continue reading
VBA polynomial functions update
Following several comments at an old post I have made updates to the Polynomial spreadsheet. The new files can be downloaded from: Polynomial.zip The changes are: SolvePoly was amended to accept numbers or signed cell addresses in the input. QuarticR, … Continue reading
Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs, VBA
Tagged Excel, high order simultaneous equations, Link to Python, Numpy, Polynomial equations, PyXLL, solve simultaneous equations, UDFs
Leave a comment
Passing 3D arrays to Excel with Python and pyxll
The previous post looked at options for displaying 1D or 2D arrays in Excel. This post will look at passing 3D arrays from Python to Excel as a cache object, using pyxll, and how to extract selected data from the … Continue reading
Posted in Arrays, Excel, Link to Python, Newton, PyXLL, UDFs
Tagged array functions, dynamic arrays, Excel, PyXLL, pyxll cache object, UDFs
1 Comment
