The best internal tool is usually a form and a table. This one replaced a scheduling spreadsheet that had grown four tabs and a macro.
Result
- One form instead of four tabs, with validation at the point of entry
- Automatic conflict detection on scheduling
- Two hours a week returned to the team that maintained it