Typically I used to use SPSS to create tables then export them and graph them in Excel (because Excel makes darn pretty graphs!)
A few years back I wrote a script that would, automatically, take SPSS tables and create the graphs for me. This brought down my reporting time to minutes instead of hours! Using AutoHotKey I was able to take SPSS to Excel without embedding any macros. This is possible because AutoHotKey can connect via a COM object.
Our clients enter campaigns into a SharePoint page that need to be transferred to our CMS. Unfortunately the two systems are not tied in any way and there are no existing API Web Services that we can leverage.
There are over 250 items that might be selected which means we end up taking a lot of time to, manually, transfer the campaigns.
I always wanted to make complete use of the range of the graph and would have to, manually, update each one. I finally learned some object oriented programming and wrote an script in AutoHotKey to easily change the axis on scales in and easily update Excel graphs. The below video demonstrates how I can just hit a key combo and scroll up/down to adjust the scale.
I’ve written an AutoHotKey script that logs into our vendor website and uses web scraping exports the recent email campaigns then breaks them out by region, campaign type, Business Unit, etc. and links them back to our SharePoint site for more information.
What’s really cool is that I’m putting in formulas (not the static number) thus if some of the items that are not classified (someone incorrectly used our mailing name so the RegEx broke) they can go back and update the code and all the numbers will adjust!