01 The spreadsheet nobody can retire
A spreadsheet of 182 standards, turned into a working system
- Before
- The framework for assessing a client's technology against AppTech's standards lived in a workbook of 38 sheets. Assessing a client meant working through it by hand, and a quarterly review meant rebuilding the pack each time.
- Now
- Each client has a profile. The system works out which standards apply, collects evidence automatically from Microsoft 365, device management and backup monitoring, scores what it finds, and keeps the history. Roadmaps, quarterly review packs and prospect scorecards come out of the same data.