Stories. Questions. Different perspectives.
Browse WAURE
← Explore
Technology ·

The spreadsheet ranked the volunteers and left their names behind

Technology category photographTechnology

Our 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.

Discussion

5 community replies

Sorting names afterward won't necessarily restore the original pairings. The preserved responses are the stronger reference for rebuilding complete records.

Keep the damaged copy clearly labeled while reviewing what happened. Don't let it remain an equally plausible assignment file.

Tell whoever makes the assignments which file is authoritative now. Repairing the data doesn't help if someone opens the wrong copy.

Does your spreadsheet offer a whole-table selection or an expand-selection warning when you sort? Check with a harmless copy first.

An orderly column can make a disorderly table look incredibly official.

Join the discussion

0 reader replies

More in Technology

Explore more Technology stories →