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

Automate Excel graphsA white stress ball with the green AutoHotkey logo being held in a hand, with a laptop keyboard blurred in the backgroundAfter 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!

Two women smiling and looking at a computer screen together in a bright office, one pointing at the monitor.

Great use of GIS data to decide your next business location

GIS Data

Years ago I helped a company that worked in the financial industry review where their current locations are and where FDIC Banks were located.  The GIS data was available for free from the FDIC.  If you spend some time you can merged the files together and look at it longitudinally.   The below map was particularly helpful in deciding where a new branch/office should be located.  I also imported the locations of competitors however I cannot share this data as it is too revealing.

I used Microsoft’s MapPoint to create the below map.  It is no longer with us however this would be easy to repeat with Google Maps.

GIS data

Here’s a great book to get ideas on conveying data visually

Using Hotstrings to help utilized custom SPSS scripts

SPSS ScriptsUsing Hotstrings from AutoHotKey help write your code is a great, easy, way to greatly improve your speed!  This example demonstrates me using hotstrings for writing most of which are actually custom SPSS scripts) which typically affect the look of output.  The newer versions of AutoHotKey now utilized Python for their scripting.  Most of mine were written in SAX Basic.  I’d post the code but it is unlikely they will work for you.

Scripts are easy to use and adaptable to make output much more meaningful and in a format ready to be used. AutoHotKey helps write syntax to utilize the scripts.

SPSS Scripts

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

 

Sample Scripts Library | Raynald’s SPSS Tools

Visual Basic-like language, embedded into SPSS for Windows. Use scripts samples to solve tasks related to interface and output manipulation.

Free SPSS Scripts

Use this script to rename some or all of the variables in your spss dataset. This script uses search and replace for effective renaming. Rename all your variables  …