• Become a Power user Intro to AutoHotkey Intermediate AutoHotkey Intermediate Objects GUIs are Easy w/AutoHotkey Painlessly switch from V1 to V2

Automate Excel graphs with AutoHotKey and SPSS; Automating pretty charts!

Automate Excel graphsAfter 20 years of doing multivariate statistics, doing analytics is very quick and easy for me.  Putting together the report which clients will think is “pretty” and convey the results is what really takes the time!  I have a ton of macros in SPSS which greatly simplify the front-end however I’ve always preferred Excel graphs to SPSS (because they don’t look like they were drawn with crayons).

Automate Excel graphs

In the below video I demonstrate how you how you can use AutoHotKey to easily automate Excel graphs that you’ll be proud to put your name on!

SPSS Syntax writer / Recoder using an Excel template

SPSS syntax

SPSS syntax

Writing (and re-writing) SPSS syntax can be mundane and time consuming.  Sometimes my data set has hundreds of variables which would take me quite some time to rename and relabel.  I created an Excel template which generates the necessary syntax and greatly helped automate the process.

The Excel file is available for download from here and the video below helps you see how easy it can be to use.  There is also a concatenation tab which allows you to add specific words as a prefix for your variables.

https://www.youtube.com/watch?v=Sqxa0_2Jwmw

Easily update Excel graphs; AutoHotKey saved me 100’s of repetitive clicks

Easily update Excel graphs

Easily update Excel graphs

In market research I used to spend a lot of time making sure my charts and graphs were beautiful visualizations that conveyed the data in an easy to understandable way.

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.

Automating email metrics w/AutoHotKey, Excel, & RegEx on the naming convention

Automating email metrics

Automating email metrics

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!

Automating email metrics