Standardized naming convention via SharePoint

Standardized naming conventionsStandardized naming conventions are a must for consistent email metrics.

In this post I demonstrated how I used a regular expression to automate email metrics.  I thought I’d create a short video demonstrating how we were able to use SharePoint to automate the creation of our campaign names.  Pre-SharePoint our clients would create and enter names manually.  This was a nightmare!

Standardized naming conventions

This video demonstrates how we managed to get SharePoint to ease the creation of our naming conventions.

Standardization of email naming convention

 

 

Venn diagram comparisons of sets- quick way to see overlap or lack there of

venn diagram

Venn diagram comparisons of sets

I often need to determine what items are in set A and Set B, in Set A and not in Set B and in B and not in Set A. Excel and other tools can do this but it takes time to open it up and configure the file. I wrote an AutoHotKey script which is very easy to get the Union, etc. and is very flexible.   The script can be downloaded below but I recommend first watching the video to understand exactly what is going on.

 

 

Venn Diagram / Compare sets Utility

Compare Sets Utility

 

Venn Diagram / AutoHotkey Compare Sets code

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.

Tweaking Graphs in Excel

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

Custom SPSS Scripts and AutoHotKey

 

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  …