About Pat Watt

This author has not yet filled in any details.
So far Pat Watt has created 7 blog entries.

Therap Webinars – Where Are You?

Do you ever feel really stupid?  Well I am today.

I was feeling really frustrated this morning.  I missed Allison’s CCHIT webinar (couldn’t find it anywhere on the Therap website) and now I hadRob Sterling’s webinar in my calendar for 10am (AK time) today.  Couldn’t find the link to that one either.  Checked the list of Certified Trainer webinars, yes it’s on there.

Didn’t think I’m too stupid to miss an obvious link somewhere in the Therap website, but maybe….

Indeed I am.  Sent a quick message to Rob and he said (smile) go to the Therap Home page and the list is right there.  Do I have egg on my face or what…….

By |2012-06-04T15:41:16+00:00June 4th, 2012|Categories: Pat Watt's Posts|Tags: |1 Comment

Writer’s Block

Oh dear, it’s over a month since I wrote a blog post….  Allison will be after me….  What shall I write about…

I’m sure other Certified Trainers are as busy as I am, so busy is no excuse.  Time to make space in Quadrant II.  There we go – write about Quadrant II, Pat.  So here goes….

One of my most abiding self-helpers is the notion I internalized many years ago after reading Stephen Covey’s Seven Habits of Highly Effective People.  His third habit is entitled “Principles of Personal Management” – which dovetails with my notion that one of the top ten leadership qualities is that of Self Mastery.   Covey frames the lead-in to his third habit with a quote by Goethe:

Things which matter most must never be at the mercy of things which matter least.

In a nutshell, think of your time as being spent in one of four quadrants.  Quadrant I is things that are urgent and important.  Quadrant II is activities that are important, but not urgent.  Quadrant III are those tasks that are urgent but not really important.  And Quadrant IV are the things that we do that are neither urgent nor important.

Picture of Quadrant

Covey says that we are reactive when we deal with urgent matters.  Important matters, on the other hand require us to be pro-active, they have to do with achieving results.  People who are change agents live in Quadrant II.  No matter how busy they are, they build space into their days, and their lives, that keep them focused on the activities that truly matter – to them as an individual, to their spouse and family, to their community, and to the place they work.

By |2016-11-03T10:15:41+00:00May 22nd, 2012|Categories: Pat Watt's Posts|Tags: |Comments Off on Writer’s Block

GERs – Grrrrrrrrr

I sat in on Kim (Champney’s) monthly Therap Brown Bag lunch today. The subject was GER’s. Talk about confusion. Let’s take a situation where a client falls down but is not injured. Keeping track of  falls is important in our agency. To record this event, you have to select one of 6 choices in the GER screen:

Screenshot of the GER event button

OK:  the client wasn’t injured, so it wasn’t an Injury.  It wasn’t a Medication Error. It wasn’t a Restraint Related to Behavior, or Restraint Other  (why do we need to distinguish these?), it wasn’t Death (why does that warrant it’s own button?), so it must be Other.  So we pick Other  and in the required description box we type “fall”, or “Fall” or “client fell down”, or something to that effect.  Oh, dear that won’t work for tracking falls – due to inconsistent labeling  we won’t be able to pull out all the falls from the GER report.  Back to the drawing board.

This time select the Injury button (even though there was no injury), and again we have to select “Other” as the Event Type – so what do we put in the required description box?  Oh I see, I have to type in “No injury.”

I feel like I’m in the twilight zone.

Therap – you can do better than this…..


By |2016-11-03T10:15:43+00:00April 12th, 2012|Categories: Pat Watt's Posts|Tags: , |4 Comments

The Canvas Community Art Studio and Gallery

REACH has an awesome program for our clients – the Canvas Community Art Studio and Gallery.  Watch this video to learn more.  It is a Day Hab program for persons with developmental disabilities and a sandbox for community members.  If you live in Juneau, drop by – or visit the Canvas website. Clients make some fabulous art projects, and we’ll soon be selling them on line as well as notecards displaying their talents.

Video on the Canvas Community Art Studio and Gallery

By |2016-11-03T10:15:43+00:00April 4th, 2012|Categories: Pat Watt's Posts|Comments Off on The Canvas Community Art Studio and Gallery

Tailoring Therap Excel Downloads

Sometimes the data you download into an Excel spreadsheet doesn’t have everything you need on it.  One of our programs wanted to be able to analyze ISP Data according to the Case Manager for each client.  However, Case Manager names are not kept in ISP Data records – only DSPs.

Here’s how we solved it:

1.  Create a new tab in your Excel file opened from the Therap download

2.  Name that new tab (sheet)  “Lookup”.

3.  In the Lookup sheet, copy a table/list of clients and case managers into the first two columns – with client names on the left hand column and case managers on the right.  NOTE:  Client names have to match exactly what’s in the Therap download.

4.  It would look like this:

Barley, Mow Freeman, Rebecca
Briney, Cream Eckerson, David
Sailing, Ship Harper, Stacey
Lovely, Girl Freeman, Rebecca
Sweek, Pea Freeman, Rebecca
Chocolate, Pie Freeman, Rebecca
Loveable, Harry Eckerson, David
Smith, John Harper, Stacey
Brown, Jane Eckerson, David
Fir, Tree Harper, Stac

5. Now in the Data sheet downloaded from Therap, click on any cell except the column header, and do Insert >> Table.
6. Next, insert a column to the right of the client’s name and label the column “Case Manager”.
7. In the first vacant cell in the Case Manager column, type the following formula:

=VLOOKUP(B2,Lookup!$A$YY:$B$XX,2,FALSE) where B2 is the cell holding the first client name in the Therap download, and in the lookup table “YY” is the row number of the first row of the client/case manager list and “XX” is the row number of the last row of this little table with client/case manager names.

This should automatically fill up the Case Manager column with the proper Case Manager names.
8. Now create a Pivot Table and go have fun. 

[You have learned how to do Pivot Tables haven’t you?]
By |2016-11-03T10:15:44+00:00March 29th, 2012|Categories: Pat Watt's Posts|Tags: , |1 Comment

Need Help?

I am amazed at how the amount of help available to Therap users has mushroomed in the 2+ years since I’ve been using it. If you have a problem, try the following sources of assistance:

  • Go to The Help and Support Page and type a few key words into the Search box at the top of the page
  • Try browsing through the FAQs
  • Check out one of the User Guides on the Help and Support Page
  • Use the new and improved Chat feature identified at the bottom of each Therap Page by clicking on the Live Help icon
  • Check out the Therap Services channel on Youtube
  • Visit the Therap Training Page for Interactive and Automated Training options
  • Sign up for one of the many Webinars available by Therap staff and Certified Trainers.  You can revisit a Webinar later if you missed the live one.
  • And of course, browse through the Therap Certified Trainer and staff blogs.
  • Send an SComm to Therap Customer Support
  • And don’t forget to call up one of the many Therap users you met at a recent Conference – incredibly useful places to learn Therap tips and network with other users and Therap staff

One of these sources will surely yield the answer to your question.

By |2016-11-03T10:15:45+00:00February 24th, 2012|Categories: Pat Watt's Posts|Tags: |Comments Off on Need Help?


The recent Provider Admin conference in East Hanover provided much food for thought.  Kim Champney and I from REACH had fun doing our Pivot Table demo.  We are still amazed at how easy it is to drill down through masses of Therap data downloaded into Excel to find pictures, patterns, outliers – and how easy it is for people to learn once they realize that Pivot Tables are for BEGINNERS!!!

Try this YouTube video to get an idea of how simple this tool is.

Video on how to Create a Pivot Table in Excel 2007 For Dummies

One other thing we learned at the Conference is that, depending on how your operating system and Excel are configured, you might have to save an Excel download from Therap, first, before you can use Pivot Tables. Don’t ask me why.

By |2012-02-16T01:04:12+00:00February 16th, 2012|Categories: Pat Watt's Posts|Comments Off on Pivoting!
Go to Top