Situation and task, about 15 seconds: “In my retail-supervisor role, weekly rotas for 45 employees needed frequent correction. I wanted to make the input and checking process more reliable without changing managers' ownership of availability data.”
Action, about 50 seconds: “I first reviewed the correction pattern and mapped where data entered the rota. I proposed an Excel workbook using Tables, XLOOKUP, SUMIFS and validation, then tested it on one week rather than replacing the existing sheet immediately. The test exposed duplicate employee IDs causing incorrect lookups, so I added a uniqueness check before wider use. I trained two supervisors and maintained the workbook. When one preferred the old sheet, I asked them to test two shifts and used their feedback to simplify the input tab.”
Result/reflection, about 25 seconds: “Correction logs averaged 12 per month in the three months before and 5 in the next three. A staffing-policy change happened at the same time, so I would not attribute the full difference to the workbook. The useful lesson was to pilot the control with real users and treat resistance as workflow evidence; the duplicate-ID test became part of the ongoing check.”
Follow-up on measurement: no controlled comparison was run; logs and concurrent policy are the evidence limits. Avoid “I transformed scheduling” or “my system cut errors.”