Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.
I can't say I've ever had to recover from spring break due to shoveling/snowblowing too much, but I guess there's a first.
The Lab 3 assignment of refactoring the code was especially timely. For the last month I have been working on recreating excel vba macros, and an access database, after making significant changes to the way we take work into the department. It was great in that it finally gave me the change to create the code from the ground up, after struggling for the past year with hand-me down processes. On the other hand, I had completely underestimated the amount of time it would take to accomplish this.
Almost three weeks over due, I got the tools back up just in time for our quarter close. As streamlined as I tried to make it - it's still a messy process.
We have a website where we can go to pull reports - there are 10 reports that have to be pulled every hour. I'm using HP's QuickTest Pro to automatically pull these.
Those 10 reports get sent to an email account and I have Outlook VBA that grabs the file attachments and saves them with the correct file names.
Those 10 reports then have to get run through the ringer of consolidating the data and determining all sorts of turn-around-time and processing metrics. I created my own Excel Add-Inn that is able to accomplish this.
Then, everything gets pulled in to an Access Database, crunched through a number of queries and key data points get spit back out as another excel file.
Then I've got a software called Automate that copies the charts out of excel and pastes them into MS Paint as jpg files that are displayed on two large flat screens in the department and through an intranet accessible website.
Automate also is what we use to tie all of these pieces together and set up the hourly schedule.
It's a ridiculous assortment of programming and automation softwares that were a pain to put together, but work beautifully now that I can set my watch, sit back, and watch work without my touching a thing.
Remember Me