Home › Case study
Case study: about 250 hours a year of data entry, automated
A Utah fiber contractor had one person spend about one hour every working day moving job information from a spreadsheet into a website, then emailing the completed jobs. That work now runs without a person.
The numbers
| Measure | Before | After |
|---|---|---|
| Time each working day | About one hour | None |
| Time each year | About 250 hours | None |
| Who does it | A person, by typing | The automation |
| Time to build | About 6 hours of building and fine-tuning | |
The task before
The task had two parts. First, a person read job information from an Excel sheet and submitted staking information to a website, one job at a time. Second, the same person collected the completed jobs and sent them by email.
Nothing about it was hard. It was the same steps every working day, and it took about one hour each time.
What we built
Read the sheet
The automation opens the Excel sheet and reads the job information.
Submit to the website
It submits the staking information for each job to the website.
Collect the completed jobs
It gathers the jobs that are finished.
Send the email
It emails the completed jobs to the people who need them.
How long it took, and when it paid back
We spent about 6 hours building and fine-tuning the automation.
The task had been using about one hour a day. In about 6 working days, the old process used as many hours as the whole build took. After that, the time comes back every day.
If your office has a task like this
The pattern is a spreadsheet, a website that wants the same information, and a person in between. The right method depends on the website.
Common questions
How long does it take to build an automation like this?
This one took about 6 hours of building and fine-tuning. Other tasks take more or less time, depending on the number of steps, systems and exceptions.
How much time did it save?
About one hour each working day. At five working days a week, that is about 250 hours a year.
Why is the client not named?
We keep our clients' names private unless a client agrees to be named.
Can you do the same for our spreadsheet and website?
Probably, and we can tell you for certain once we see the task. Book a free consultation and show it to us.
Show us the task that takes too long
Book a free consultation: an in-person visit in Utah or a Google Meet call. Your booking goes to both partners.
Book a meeting