Commission calculator
An insurance company
Real project- The problem
- Commissions were worked out through a long spreadsheet process that took about a week each pay cycle, and only a couple of people knew how to run it.
- What I built
- A web tool that takes the CSV export from their system and does the whole commission calculation, start to finish.
- Before
- About a week of spreadsheet work every pay cycle
- After
- Drop in the CSV export, get every payout
- Result
- The week-long run became a file upload with the results on screen.
