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!

Using AutoHotKey to Create Excel Graphs

Web Scraping and emailing data to client via Outlook

Web Scraping and emailing dataWeb Scraping and emailing data

Do you frequently  access a Web page / then have to write an email regarding the data you gathered?  I had to look at our SharePoint and then email clients based on what I found.   The email is sent via Outlook and is tailored, specifically, to my client.  Saves me a ton of time!

It is easy to use AutoHotKey to read various aspects of a SharePoint site and write custom emails tailored to the respondents.

Web Scraping and emailing data video demonstration

Using AutoHotKey to navigate SharePoint site and writing HTML emails

Using a strong Naming Convention & RegEx are keys to automating metrics!

naming conventions

Naming Convention and Regular Expression (RegEx)

Having a strong naming convention can make reporting on your metrics a breeze when you use a regular expression to break out-decrypt the naming scheme. This video shows how easy it is for us to extract: Region, Language, Campaign Type, etc. from our campaign names by using a regular expression. It also points out that there is no need to be stuck with poor acronyms for your reporting.

Naming Convention and Regular Expression

In my above example I use AutoHotKey with Excel.  If you add the function, Excel can do RegEx itself however (for some crazy reason) it isn’t built into it.

Automate sales emails with AutoHotKey and Excel

 

Automate Sales emailsAutomate sales emails

I know a lot of very hard-working, but non-technical, sales people.  They spend a lot of time writing personalized emails to clients and spend even more time trying to track the responses.

There some decent mail merge tools on the market however they can be somewhat technical to use (and easy to mess up). I built a short script in AutoHotKey which allows for automating of emails but allows fore proofing & tweaking before deployment.

Automating Sales emails