Need a new search?

If you didn't find what you were looking for, try a new search!

Having fun with pivot tables

By |2016-11-03T04:23:52-05:00February 15th, 2012|Categories: Excel|Tags: , , |


One of the things that made me smile most at the National Conference was the number of times I overheard people having conversations about the joys of Pivot Tables in Excel.

To add to this, Pat Watt from REACH in Alaska has posted about this on the Certified Trained blog.

You can also look at previous post I have written on the subject by clicking here.

If you have been using Therap for any length of time I can’t emphasize how much you will learn by taking some searches, exporitng them to Excel, and then looking at them in a Pivot Table.

:: Justin ::

As Requested, All you ever wanted to know about Pivot Tables

By |2016-11-03T04:24:31-05:00March 8th, 2010|Categories: Webinars|Tags: , , |

Using Pivot Tables to analyze and work with your Therap Data

Exporting data to Excel from Therap is easy, but what do you do with it once it gets there?

Original Picture is Unavailable

Justin Brockie of Therap will give a walkthrough on using Pivot Tables to unleash the power of your data and Pete Ratekin of Occazio in New Castle, Indiana will show how he has been able to automate many of these processes

Title: Using Pivot Tables to analyze and work with your Therap Data
Date: Thursday, March 25, 2010
Time: 10:00 AM – 12:00 PM EDT

Space is limited.
Reserve your Webinar seat now at:

The Joy of Pivot Tables

By |2016-11-03T04:24:31-05:00March 3rd, 2010|Categories: Training, Web|Tags: , |

The other day, I was on Facebook, and what did I come across by an entry entitled “The Beauty of Pivot Tables“!  This is for me I thought!

The link was to the Microsoft Office Facebook page. From there it was off to the delightfully named Crabby Office Lady blog.

Then, this morning when I was looking for the above link to share with you I came across this:

Woah! It’s a guy with a funny accent talking about pivot tables! (I just watched it and learned a bunch of stuff)


:: Justin ::

Don't miss Therap's Learning Lunch Webinar Series

By |2016-11-03T04:23:28-05:00June 4th, 2014|Categories: Webinars|Tags: , |

Therap staff as subject matter experts will be hosting a Learning Lunch Webinar Series throughout the summer months. Topics will vary week to week and are developed for provider agency and state system staff in a variety of professional roles to enhance their use of Therap and to improve quality of documentation. Check in regularly and be sure to note the time zone as we are representing various regions of the U.S.

To register, click on the dates of the events you want to attend.



To YouTube or not to YouTube

By |2016-11-03T04:23:45-05:00August 10th, 2012|Categories: Web|Tags: |


One of the great things about using Therap is we don’t tell you how to do your job (though we do get fairley opinionated about how best to use Therap).

Some agencies choose to have very strict internet access policies and other leave things much more open.  There are great arguments for and against each.

One of the things I am coming across a lot now is the use of .

As you know, we use it a lot as it is easy (and free) to host stuff on and very easy to watch on just about any device.

So if you want to learn about Incident Reporting in Montana


or Respite Services in Nebraska


or how to work with […]

Friday in Ohio

By |2016-11-03T04:23:52-05:00February 24th, 2012|Categories: Ohio|Tags: , |


This is running at Cleveland Airport – It’s awesome!

This morning I attended an Ohio User Group meeting very generouly hosted by Starcher Family Home.  I feel like I have known them for years (maybe because I have), but this was my first time onsite.

We looked as all sorts of things including Individual Home, Managment Summaries, MARs, Billing, and more.

Of course we also had some fun with pivot tables.

Then this afternoon, Calum and I visited Oberlin Consevatory for a meet and greet before tomorrow’s interview/audition.

All in all a very fine day!

:: Justin ::

Looking back at the 2012 Therap National Conference

By |2016-11-03T04:23:53-05:00February 10th, 2012|Categories: Provider Admin Conference|Tags: , , , |

Now that I have (almost) recovered from three days of intense Therap-ing it’s quite remarkable to look back on what went on.

I think probably the most remarkable thing is how little I was personally involved in.  With 16 sessions running in parallel it just wasn’t possible.  What I did hear though as I walked the corridors was how impressed everyone was with the level and quality of presentations both by Therap staff and Therap users.  Several times I heard from my colleagues (and the same would be true for myself) that they had learned things from the attendees at a session.

There are now many, many people at Therap conferences who know more about Excel and pivot tables than I do! […]

More progress in New Mexico

By |2016-11-03T04:24:02-05:00September 20th, 2011|Categories: New Mexico|Tags: , , , |

Video on eCHAT Preview for New Mexico


I spent the last couple of days in New Mexico working with them on the latest updates to the eCHAT (Electronic Comprehensive Health Assessment Tool) and the upcoming state-wide implementation of General Event Reports. The next set of updates are going to be very exciting. We’ll have some functionality and data changes based on what we have learned so far and look to be taking advantage of Individual Unification to provide some very cool sharing capabilities.

Based on the work we did, providers in New Mexico should look forward to receiving extra guidance in using the eCHAT, using Health Tracking, and transferring individuals in the next week or so.

It is very exciting […]