this post was submitted on 30 Jun 2023
55 points (100.0% liked)
Moving to: m/AskMbin!
63 readers
9 users here now
### We are moving! **Join us in our new journey as we take a new direction towards the future for this community at mbin, find our new community here and read this post to know more about why we are moving. Thank you and we hope to see you there!**
founded 1 year ago
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
I had a manager at work who did not handle tech well. He had a period of unavailability every Friday as he had to do a weekly report.
I walked in on him doing that report, which took been two and four hours, because he be was manually copying hundreds of numbers from a csv file to a report document. By hand!
He was writing down each number in a notepad, using a pen, then switched to the reporting doc and wrote it back, one line at a time.
It took me less than 5 minutes to write an excel macro that did his weekly report automatically, with extra bells and whistles to boot.
This was the absolute worst example of work hard not smart I've ever seen.
In a 200 person company, I made friends with some peeps in the marketing department.
Yep, their workflows have tons of automation potential. They are definitely doing hours of work that can be done in minutes. Companies really should have rotations where a dev just sits and watches sales and marketing do any data input work.
I have to enter data into payroll for when a teacher covers a class for an absent teacher. Usually, there are 5 teachers who I pay for one hour each. Each teacher has an ID number.
To pay one teacher I have to enter their ID number. Select their job code from a drop down list, tell the database I am adding to it by choosing or entering A in a box. Then I have to pull the date from a drop down list. Then I enter the digit 1 (to pay 1 hour). Then I enter the ID number of the absent teacher. Then I enter the sub request number created by the absent teacher. Then I click "change."
I have to do this for all 5 teachers that covered the class. One-at-an-effing-time.
If I had a "dev" handy, I would say, let me enter the ID, date, and job number for the absent teacher. Let me list the 5 substituting teacher id numbers, and the 1 hour should be the default.
Of course there will never be a 'dev' around because my county purchased the payroll software and no one who is anywhere near using it gets to make the purchasing decisions.