The spreadsheet ranked the volunteers and left their names behind
TechnologyOur most experienced volunteer appeared at the bottom of the ranking. The scores beside the names looked plausible until she asked why hers had changed.
I'd sorted the score column without moving the rest of the table. The numbers were in order. The names were not attached to their original numbers anymore.
We hadn't sent assignments yet. I stopped editing and compared the sheet with the original responses. My colleague wanted to sort the names back into order, but I couldn't assume that would restore the original pairings.
We rebuilt the working table from the preserved responses and checked several complete rows together. Then we discarded the damaged working copy from the assignment process.
I had been trying to make a fair decision easier to read. For ten minutes, the neatest column on the screen was the reason the whole table couldn't be trusted.