Projects
Things I have shipped, not things I have opinions about.
Everything here is public and free. The Excel work is free to use and free to modify, the AI tooling is open source, and the debt function is verified against an independently prepared debt schedule rather than against my own spreadsheet.
Excel LAMBDA · Municipal finance
Sizing a bond issue to a coverage test
Par comes out as an output rather than going in as a guess. Verified to the cent against an independent debt schedule.
- Tax-exempt par, matched exactly
- $5,941,235,000
- Taxable par, matched exactly
- $5,963,525,000
- Maturities off by
- Zero
- LAMBDA
- Dynamic arrays
- Debt capacity
Open source · Python
Teaching an AI assistant to do finance work properly
Skills that give Claude Code real competence in Excel finance work, rather than plausible-sounding guesses.
- Claude Code
- AI workflows
- Open source
Excel add-in · Free to use, free to modify
XL Edge: a LAMBDA library that lives in the ribbon plus more
Store, search, edit and share custom LAMBDA functions from a ribbon group instead of Name Manager — plus panel charts, Monte Carlo simulation from distributions to finished charts, and years of productivity macros.
- Excel add-in
- VBA
- LAMBDA
- Charts
- Monte Carlo
Excel LAMBDA · Free to use, free to modify
Distribution LAMBDAs for Monte Carlo Simulations
Thirty-nine Monte Carlo distributions, five copulas for correlated inputs, risk measures and chart data as native Excel LAMBDA functions. Each one spills every trial from a single cell, gives the same answer on every recalculation, and needs no legacy or expensive Monte Carlo add-in to open.
- LAMBDA
- Monte Carlo
- Dynamic arrays
- Statistics
Excel LAMBDA · Free to use, free to modify
Finding the outliers that break a forecast
Five small functions for z-score outlier detection and reading which members a CUBE slicer actually has applied.
- LAMBDA
- Statistics
- CUBE functions