Most jobs are entered twice, in the tool and in the spreadsheet
The service desk and billing keep their own spreadsheet because the Friday workbook is built from it. Field scheduling does not re-enter jobs, because the tool is the only way to get a visit plan, but it still fills in the Friday sheet by hand. Where a second route exists, it is the one that feeds the report.
“Half my team update the job in the tool and half update the spreadsheet we've always had, and a few do both.”Team lead, service desk, 6 years in role
Show all 4 quotes and their conversations
-
“Half my team update the job in the tool and half update the spreadsheet we've always had, and a few do both.”
Team lead, service desk, 6 years in role
Open the conversation
LontraTo start, how does your team use the new tool on a normal day?
Team leadMostly to log new requests. Someone rings, it becomes a job, the job goes in the tool. Where it gets messy is after that. Half my team update the job in the tool and half update the spreadsheet we've always had, and a few do both.
LontraWhen you say a few do both, how many jobs is that in a day?
Team leadOf the thirty or so jobs a coordinator handles, I'd say most end up in both. Because Friday's report comes off the spreadsheet, so it has to be in the spreadsheet. And the tool is what I'm told is the real one. So both.
LontraWhat does that cost your team?
Team leadAbout forty minutes each a day, I worked it out once. Times twelve people. I haven't told anyone that number because I'm not sure what I'd be asking for.
LontraTwo people on your team joined after go-live. How did they learn the tool?
Team leadSat next to someone. There was a ninety minute session before go-live but the two who've joined since only got whatever the person next to them knew. And that person is busy.
LontraWhen something in the tool doesn't work the way your team needs, who do you go to?
Team leadThe project team did that for the first couple of months, there was a mailbox. It's still there but I'm not sure anyone reads it. I asked for one field to be changed back in the spring and I'm still waiting.
LontraIf you could change one thing first, what would it be?
Team leadPick one. Tell us which one counts and switch the other off. I don't mind which, I mind that we're doing both.
-
“I can do a sheet filter in two seconds. In the tool it's four clicks and a spinner.”
Service coordinator, 5 years with the company
Open the conversation
LontraTake the last job you logged. What happened from the phone ringing?
Service coordinatorA caller rang, a lift had stopped. I open a new job, caller and site are easy. Then the form wants an asset ID, a contract code and a priority from a list. Callers don't know their asset ID. So I look it up in the contracts system, in another window, and copy it across. That's a couple of minutes with someone waiting on the line.
LontraWhat do you do when you can't find the asset ID?
Service coordinatorPut 0000 in. It lets you save. Then scheduling ring us to ask for the real one. Most of us do it, I'm not proud of it.
LontraHow often is that?
Service coordinatorMaybe one call in four.
LontraOnce the job is in the tool, what else do you do with it?
Service coordinatorPut it in our sheet.
LontraWhat does the sheet give you that the tool doesn't?
Service coordinatorMy team lead looks at it for the Friday numbers. And I can do a sheet filter in two seconds. In the tool it's four clicks and a spinner.
LontraIf you could change one thing about the tool, what would it be?
Service coordinatorLet me save the job without the asset ID and chase it after the call.
-
“I fill it in by hand because the tool's version doesn't split missed visits by reason, and he wants that.”
Team lead, field scheduling, 2 years in role
Open the conversation
LontraHow does your team use the tool in a normal day?
Team leadAll day. We plan the engineers' visits in it, so it's open from half seven. It's the only place the visit plan exists.
LontraWhat happens to a job that isn't in the tool?
Team leadIt doesn't get planned. Simple as that. So the service desk has to get it in, and then I get a job with half of it missing and I'm ringing them to ask.
LontraHow often does that happen?
Team leadA few times a day. I'd say one in five arrive missing something. Asset ID is the main one. It's mandatory on our side but the desk don't always have it when the caller rings.
LontraWhy do you think your team uses it fully when you hear other teams don't?
Team leadBecause it's the only way we get our plan. Nobody chose it, we had no other route. If I could still plan off the spreadsheet I'd probably have gone back to it by the second month, to be honest.
LontraWhat do you send up the line each week?
Team leadA Friday sheet for the regional manager. I fill it in by hand because the tool's version doesn't split missed visits by reason, and he wants that.
LontraDid anyone ask for that split to be added to the tool?
Team leadI mentioned it to someone on the project. I don't know what happened to it. The engineers on my visits mostly show up as the van login anyway, same name against twenty jobs a day.
-
“Then I do the invoice run from my sheet.”
Billing administrator, 3 years in role
Open the conversation
LontraHow do you use the tool?
Billing administratorTo close jobs for invoicing. When they're done.
LontraWhat do you do there?
Billing administratorCheck they're complete. Then I do the invoice run from my sheet.
LontraWhy from your sheet?
Billing administratorAlways done it that way.
LontraIs there anything in the tool that would make that easier?
Billing administratorNot sure. I haven't really looked.
LontraIs there anything you'd want the project team to know?
Billing administratorIt's okay. It's just another thing to fill in.