Recent Comments
Tag Archives: Python
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
Monte Carlo simulation with Excel and Python
The pyxll blog has a post from last year on Monte Carlo Simulations in Excel with Python, with examples and full code going from the simplest implementation to more refined code allowing all the calculations to be set up on … Continue reading
Scipy-statistics with all distributions
Following the previous post the Scipy statistics functions have been updated to include all the distributions, including the discrete distributions. The input to the distribution functions has also been updated to allow arrays to be transferred either as Excel ranges … Continue reading
Posted in Arrays, Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Alternative data types, Distribution functions, Excel, Numpy, Python, PyXLL, pyxll get_type_converter, pyxll Union, SciPy, Scipy stats, statistics, UDFs
Leave a comment
Newton Excel Bach, not (just) an Excel Blog 