Projects
Things I have shipped, not things I have opinions about.
Everything here is public and free. The Excel work is MIT licensed, the AI tooling is open source, and the debt function is verified against published benchmarks 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 two published benchmarks.
- 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 · MIT licensed · Free
A LAMBDA library that lives in the ribbon
Store, search, edit and share custom LAMBDA functions from a ribbon group instead of Name Manager.
- Excel add-in
- VBA
- LAMBDA
Excel LAMBDA · MIT licensed
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