arthwollipot
Observer of Phenomena, Pronouns: he/him
I know.There's yer problem.![]()
I honestly don't know how to do it better. And I've been thinking about it. A lot.
The template I'm referring to is what we call the Phone Button Template. It's used to set Lines and Speed Dials on desk phones, primarily for Executive Assistants and other staff who have the expansion module on their phones. Each button on the module can be set to either a Line (someone else's phone number that rings on your phone) or Speed Dials (numbers that you can dial with one button). We have a set number of configurations that we can set these to - four Lines then twenty SDs, or five Lines and fifteen SDs, etcetera. This is the first sticking point. They always want to arrange their Lines and SDs in ways our system will not allow. There is a big label at the top that says "KEEP LINES AND SPEED DIALS TOGETHER - THEY CANNOT BE INTERSPERSED" but who reads instructions anyway?
The second sticking point is that our phone numbers are listed in the format (12) 3456 7890 like regular Australian land line numbers. But in our VoIP system they are listed with only a five-digit extension number which is the last four digits of the phone number plus a single digit at the beginning indicating the state. So of course people give us the full numbers, and we have to do a find & replace to convert the full number to the five-digit extension before we can start entering them.
The third thing is that we ask them to highlight changes on the spreadsheet. If they want to modify their existing configuration, highlight the entries that you'd like changed. Simple, but again, who reads instructions?
The fourth thing is that they keep their spreadsheets and just amend them when they need changes, which means that when we get them they have titles like "Copy of Copy of Copy of Copy of Copy of John Smith Phone Button Template.xlsx" and it's an outdated version of the template that we updated three years ago.
What triggered my initial post is that we got a request to, among other things, change the last entry from a Speed Dial to a Line. But they had already specified that the Line be added higher up on the template. What they should have done is just delete that row from the spreadsheet. Instead, they left it, highlighted it, and added a comment saying "change from Speed Dial to Line". Unfortunately this involved changing their setup from 14 Lines to 15 Lines, which because of our nightmarish system meant I had to basically delete all their Lines, change their setup, then re-add the Lines. When I got to the last one I got an error saying that it had already been added. If they'd filled out the spreadsheet right, I could have just made the two changes they requested without having to change their setup at all. Hence, ten minutes of my valuable time wasted.