Recent Comments
Tag Archives: Python
Transferring different data types to/from Python with pyxll
When a user defined function (UDF) is created in Excel with Python and pyxll the data type of each argument can be specified, either in the @xl_func decorator, or with a separate @xl_arg decorator for each argument. I prefer the … Continue reading
Posted in Arrays, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Alternative data types, Excel, Numpy, Python, PyXLL, pyxll get_type_converter, pyxll Union, SciPy, Scipy stats, UDFs
1 Comment
Scipy-statistics with distributions
The Scipy statistics functions last presented here have now been updated with the addition of links to the numerous distribution functions. The py_Stats spreadsheet, with associated Python code in PythonStatsFuncs3.py and pyScipy3.py, and also minor updates to the pyNumpy.py code, … Continue reading
Posted in Arrays, Excel, Link to Python, Maths, Newton, NumPy and SciPy, Python Pandas, PyXLL, UDFs
Tagged Distribution functions, Excel, Help function, Pandas, Python, PyXLL, SciPy, Scipy.Stats, statistics, UDF
Leave a comment
2DFrame-py
… and 3DFrame-py update. I have added code to the 3DFrame-py module to allow simplified input for 2D frame analysis. The revised code and example spreadsheets can be downloaded from: 3DFrame-py.zip There are also miscellaneous minor revisions to the 3DFrame … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, PyXLL, Strand7, UDFs
Tagged 2D Frame analysis, compare to Strand7, Excel, Frame Analysis, MatPlotlib, Numba, PyPardiso, Python, PyXLL
Leave a comment
Continuous beam animations with VBA and Python
Following a lengthy discussion at Eng-Tips I have developed several functions to generate animations of the effects of applied moving loads. The Python code and examples have been added to the py_ConBeamU.zip file which can be downloaded from: py_ConBeamU.zip Starting … Continue reading
Posted in Animation, Beam Bending, Charts, Excel, Frame Analysis, Link to Python, Newton, PyXLL, UDFs, VBA
Tagged animations, beam analysis, Excel, Fixed-end moments, MatPlotlib, Moving load analysis, Python, PyXLL, py_Conbeamu, Restrained End Moments, UDFs
1 Comment
py_ConBeamU and Strand7 check updates
Following the previous post, I have updated the py_ConBeamU spreadsheet, and the associated check against Strand7 results. The new files can be downloaded from: py_ConBeamU.zip The download file now includes: py_ConBeamU.xlsb: The complete spreadsheet, including examples of all functions py_ConBeamU-Check25-2.xlsb: … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Link to Python, Newton, PyXLL, UDFs
Tagged beam analysis, Excel, Fixed-end moments, Python, PyXLL, py_Conbeamu, Restrained End Moments, UDFs
1 Comment
