3 ms·
I think a lot of people would be happy to implement this if they had the opportunity. In one office job I had a while back, I let my superiors know that I could
by Chathamization 9y ago
I think a lot of people would be happy to implement this if they had the opportunity. In one office job I had a while back, I let my superiors know that I could write scripts to automate repetitive tasks, and they were more than happy to help me work with people to automate a lot of the processes.
I'm talking about very simple operations. For instance, 100 different clients send in information in individual Excel spreadsheets, and the company wants to have a master file with all the info. So they literally have someone open one document, copy all the info on page 1 and paste it to a master file, then copy all the information from page 2 and paste it to the master file, etc. For each page and each file. This is something that's simple to automate, and less prone to error than copy and pasting hundreds of sections by hand. And once a script is made to automate it, it's a simple thing to run it each year.
It's not even that organizations don't want to or try to automate stuff like this - check out how some of them multi-nested Excel formula then end up using in an effort to have some kind of automation. They just aren't familiar with much beyond Excel formula's (or perhaps some clunky proprietary software they struggle with).
Like I said, in my experience organizations are happy to use automation if you can show them what it can do, but they often simply aren't aware of how much it can accomplish. And you need someone comfortable enough to run the script and make basic changes to it, and if that person leaves they're probably back to doing things by hand.
It would be nice if people were taught at least enough about programming that they were able to write scripts to automate simple repetitive tasks.