End user doing a lot more work to avoid a little bit of work

Posted by Geno0wl@reddit | talesfromtechsupport | View on Reddit | 43 comments

Every day the office manager is supposed to finalize the shift and then export that to Excel and drop it into a shared folder for the Dispatch team to reference(Dispatch doesn't have direct access to our database due to domain design choices years ago).

As part of that finalization step the office manager is supposed to mark what vehicles, if any, were assigned to each person. So if any issues arise, like a ticket from a speed camera, we know who was supposed to be driving that car on that day.

It is also notable that the availability export to an excel sheet is locked with a password so it can not be edited. You have to put the vehicle number into the scheduling software to have it properly show up on the sheet. Or so we thought.

We had a supervisor call trying to find out which car was driven on a particular day. Went into the system and pulled the report for their location, and all of the vehicle fields were blank, not only for that day but every day. Which didn't make sense, as Dispatch needs those car numbers and would have complained if they didn't have those.

Tried figuring out what was wrong and why it wasn't saving, because that surely must be the issue, but it was a fruitless endeavor. So I looked at the folder snapshots from the day before and noticed something...that Location's schedule export was a PDF file, not an Excel sheet like every other file. When I opened the file I saw that the vehicle numbers were handwritten.

The office manager was printing off the sheet(which is frequently multiple pages), hand writing in the assigned vehicles, then scanning that back to her e-mail, before dropping that into the file share.

When we asked her why she was doing that exactly, she said "I can just write faster than I can type".