This is a database front-end for managing donations to WCBN-FM during the annual fundraiser pledge drive.
Guillotine is a Rails application which runs on a Postgres database. There must be a role guillotine, and the extension pg_trgm.
This application is on its way out. In the interim, I've created some monstrosity out of google sheets to hold the team over, which includes excel formulas like this:
=query({"pledger_id", "amount", "name";donations!B2:B,donations!D2:D,ARRAYFORMULA(IFERROR(VLOOKUP(donations!B2:B,pledgers!$A:$S, 19,0), ""))}, "select Col3, SUM(Col2) GROUP BY Col1, Col3 ORDER BY SUM(Col2) desc limit "&H5)
Good times 😎