In Practice

In Practice is a library of working reference builds and studies.

Each of the items below includes the workbook and the accompanying documentation. There is no login, no form and no fee.

The workbooks are interactive but locked in their public version. They allow users to navigate the tools, change the intended inputs and review the outputs. They are a demonstration of method, not a transfer of it.

The documentation explains the purpose, the logic, the limitations and the use cases. It is written for the person evaluating the work, not only for the person using it.

This is where the delivery standard becomes visible. The reference builds and studies give you a clear feel for how I approach a problem, structure the logic and keep the work practical to use. They are not meant to be scaled as they are.

Every business has problems that are specific to it. That is what the bespoke work is for. That is where the same logic is adapted to real files, real users, real rules and real decisions.

Below is the current library of reference builds. Each entry explains the work, what is included and how to access the files. Where available, a short video is also included to introduce the build and show how the solution is configured and used in practice.

A data-backed comparative case study examining how selected equity and commodity ETFs behaved during the first 90 trading days of the Global Financial Crisis, COVID-19 and Operation Epic Fury. A common day one baseline allows the direction, magnitude and recovery of each market path to be compared consistently across the three events.

The value is in making complex behaviour visible. The study shows where the ETFs moved together, where they separated and which instruments amplified each shock. It turns raw price data into a comprehensive analytical story, while keeping the limits of the evidence explicit. The same approach can be applied to a company’s own data to reveal patterns, pressure points and questions that may otherwise remain unanswered .

Included: Data-backed comparative case study PDF.

Access: Via this link.

A technical case study and Excel workbook built around Wikipedia’s worked logistic regression example. Python in Excel checks the fitted coefficients. Native Excel then rebuilds the same result using LET functions, row level log likelihood calculations and Solver.

The result is not treated as a black box. The workbook shows the route from data to probability, likelihood and fitted coefficients.

Included: Case study PDF and Excel workbook.

Access: Via this link.

These files are hosted in the public Phronesis shared folder. Excel workbooks should be downloaded and opened in Microsoft Excel.
Google Sheets preview may show errors, as Python in Excel, Solver, dynamic formulas and interactive workbook elements are not supported there.

An Excel workbook built around Eurostat’s monthly unemployment dataset. Power Query transforms the raw source into structured tables. A dynamic interface then lets users select countries, population groups and time periods, with results shown through a chart and a country level summary table.

The data arrives in its published form. This solution makes it ready to work with.

Included: Workbook, Eurostat source data and user guide.

Access: Via this link.

These files are hosted in the public Phronesis shared folder. Excel workbooks should be downloaded and opened in Microsoft Excel.
Google Sheets preview may show errors, as some formulas, macros and interactive elements are not supported there.

An Excel workbook built around a budget allocation problem. VBA generates all feasible whole number combinations under a budget cap and minimum unit requirement. A LET formula then returns the closest valid option within the selected budget, with the full option space available for review in a separate table.

The problem looks simple until the combinations grow. This solution makes the feasible choices visible.

Included: Workbook and user guide.

Access: Via this link.

Important: If Excel shows a pink security warning saying that macros have been blocked because the file source is untrusted, please refer to the Workbook Info tab for guidance on how to proceed.

These files are hosted in the public Phronesis shared folder. Excel workbooks should be downloaded and opened in Microsoft Excel.
Google Sheets preview may show errors, as some formulas, macros and interactive elements are not supported there.

An Excel workbook that searches across multiple tables at once and identifies where selected keywords appear. It gives users a controlled first filter before the manual review begins.

Most of the work is in knowing where to look. This solution does that part.

Included: Workbook, sample data and user guide.

Access: Via this link.

These files are hosted in the public Phronesis shared folder. Excel workbooks should be downloaded and opened in Microsoft Excel.
Google Sheets preview may show errors, as some formulas, queries and interactive elements are not supported there.

An Excel workbook that examines π in two ways. Power Query searches for a selected 6-digit sequence inside a structured table containing the first 1 million decimal digits of π. VBA then runs a live Monte Carlo simulation, generating 2,000 random points to show how π can be approximated through sampling.

This solution shows how Excel can search large ordered datasets and run controlled simulations inside a workbook teams already know.

Included: Workbook, source data and user guide.

Access: Via this link.

Important: If Excel shows a pink security warning saying that macros have been blocked because the file source is untrusted, please refer to the Workbook Info tab for guidance on how to proceed.

These files are hosted in the public Phronesis shared folder. Excel workbooks should be downloaded and opened in Microsoft Excel.
Google Sheets preview may show errors, as some formulas, queries, macros and interactive elements are not supported there.