From a mirage of spreadsheets to one budget model
A rewards leader needed budget scenarios for the board, and the pay review tool couldn't model them.
Nilan Vagh is Associate Director, People Operations and Systems at Zip, and instead of another mirage of spreadsheets he built the budget model himself in Google Apps Script.
He walks through it live on a fictional 250 person company, from a compa ratio heat map that feeds straight into the budget scenarios to the audit trail that makes the model defensible.
What we get into
Why ChatGPT and Codex were the accelerant and not the architect, with the business logic coming from his rewards lead…
The skinny
The skinny isn't ready yet — notes appear once the transcript is processed.