Monthly Archives: November 2023

Python in Excel: Python User Defined Functions

Posted on November 6, 2023 by fastexcel

This post explores using Python in Excel to create Python User Defined Functions. The example used is a function to calculate Gini coefficients (see https://fastexcel.wordpress.com/2011/05/21/fast-gini/). Defining the UDF Python UDFs live in the workbook global Python space and must be … Continue reading →

Posted in Calculation, Excel, Python, UDF | Tagged , , , | Leave a comment

Python in Excel: Controlling Python Calculation

Posted on November 2, 2023 by fastexcel

Because Python calculations can be slow it is worth looking at ways of controlling Python calculation. Partial Calculation The calculation setting that used to be called “Automatic except Data Tables” has been renamed to “Partial”. Partial Calculation works like Automatic … Continue reading →

Posted in Calculation, Excel, Python, VBA | Tagged , , , | Leave a comment

Python in Excel: How do Excel and Python Formulas Work Together?

Posted on November 1, 2023 by fastexcel

In the previous post I showed how Python and Excel calculation methods are completely different: So when Excel formulas and Python formulas depend on one another how does this all work? Excel->Python->Excel->Python Lets look at a simple example of inter-dependent … Continue reading →

Posted in Calculation, Excel, Python | Tagged , | Leave a comment

Python in Excel: PY Calculation, Globals & Co-Volatility

Posted on November 1, 2023 by fastexcel

Python Calculation Python in Excel calculates all the PY cells in a workbook sheet by sheet, and row by row, starting at the top left PY cell. If you break this calculation sequence rule, by for instance moving cell E5 … Continue reading →

Posted in Calculation, Excel, Python | Tagged , , , | Leave a comment