Report Generation- Crank out automated reports!

report generation

Report Generation

In market research I would very frequently have to crank out a ton of different versions of reports for a given study.  In the corporate world, like it or not, PowerPoint is still king.  🙁   By building a generic template I was able to drastically speed-up my report generation.

Setting up the template takes a little time at first however, in the long run, it will save you an amazing amount of time!

There is a lot more I automated however having a flexible template is always a great place to start!

Report Generation- Crank out automated reports!



Autocorrect replace text- Use abbreviations to automate writing!

autocorrect replace text

Autocorrect replace text

Hotstrings from AutoHotKey are an amazing time saver! If you’re not using them now, stop what you’re doing because they are very easy to use and save you a lot of time on a daily basis!

You’ve probably used Microsoft Word’s autocorrect to replace misspellings or perhaps the Copyright sign ©.   Imagine if, instead of replacing one word, you could replace three pre-defined letters with paragraphs of text!   Simply one of the best ways to crank-up your productivity in a very short time!

Hotstrings (Auto-replace text in any program)

Another video I did demonstrating the usefulness of Hotstrings can be seen here where I demonstrate how I use it with SPSS to crank-out reports.

AutoHotKeyHotstrings and SPSS


Ms-office – Word – Use AutoText Or Don’tIt’s Your Choice Tutorials

AutoCorrect’s “Replace text as you type” feature is great for fixing typos, but you can save much more time by creating AutoCorrect entries for text items that you …

Windows autocorrect- Auto-replace text in any Windows program with a Hotstring from AutoHotKey

windows autocorrect Windows Autocorrect– Auto-replace an abbreviation with full text in any windows program

Years ago I realized I was frequently typing the same thing over and over. For a while I used autocorrect in Microsoft Word which was helpful but had limitations (one huge one is that it only worked in Word). AutoHotKey is a free scripting program that allows you to do an amazing amount of things; one of which is how to use Hotstrings to autocorrect text in any windows program via Hotstrings.

I have hundreds of Hotstrings which allow me to type a few letters and have them, automatically, replaced with the full word, sentence, paragraph, etc.   Below is a simple example where I want to type my main website domain.  Instead of typing the entiere thing out I just type tac. which is quickly replaced with

The second example is one where I want to have line-breaks inserted (This is my template when starting a new AutoHotKey script.)  I simply type tst.  and the following “magically” appears in its place via windows autocorrect.

The below video outlines how I use hotstrings to reduce the amount of mundane work that I have to do.  It is amazing how much time you can save once you get used to using them!  Remember your Hotstrings (windows autocorrect) will work in any Windows program!  Did I mention it was free?  What more could you ask for?

Hotstrings (Auto-replace text in any program)

Windows autocorrect is just one of many amazing things you can do with AutoHotKey however hotstrings is a great, easy, way to start down the path of automation and efficiency!


Automate Unicode character encoding for HTML

Unicode character encoding

Our CMS does not support Unicode text thus when we need to search-replace for characters like the and © symbols. This takes a fair amount of time and is easy to miss so I wrote a script in AutoHotKey to automatically handle the Unicode character encoding.

Now I can highlight the word and click a button and  Whamo!  Instant replacement with HTML equivalents!  No more trying to scan text and find illegal characters.

replace unicode characters with HTML equivalent

Unicode character encoding

Here is the AutoHotKey code I use.  My code first grabs the highlighted text and copies it to the clipboard, where it manipulates it, then sends it back to the active program I was working in. No more need for Unicode character encoding!