Skip to main content
Therap HomeTherap Home

 Posts Tagged ‘Utah’

More Excel Geekery

Running the last login report gives you the recent logins, however, it does not reveal those who have not logged in. This is the way to run an exception report.

  1. Run the Last Login Report under AGENCY REPORTS and export it to Excel.
  2. Under the ADMIN tab, click LIST next to USER, and export the User List to Excel as well.

Now you have two Excel spreadsheets.

  1. In the USER LIST spreadsheet, delete columns B through F. Column A should remain as is with the login name.
  2. In the LAST LOGIN REPORT spreadsheet, delete column D (Title). Copy columns C and D and paste them into the USER LIST spreadsheet into columns D and E.

Now you have the one spreadsheet you will use. What the formula will do is compare the entire user list to the list of logins and find those who have failed to login during the time period you chose when you ran the LAST LOGIN REPORT.

The formula is constructed this way: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

Lookup Value=what are you looking for=login name

Table Array=where are you looking for the login name to compare to the user list

Column Index=which column in the table array matters=login name

Range Lookup=find out who didn’t login and tell me=find the names in the big list that don’t appear in the login list

So, do this:

  1. Click cell B2 and then in the formula bar, type: =VLOOKUP(
  2. Click cell A2 and then the formula will look like: =VLOOKUP(A2
  3. Type a comma after “A2” and then highlight cells D2 through the end of the list in E## and the formula will look something like this: =VLOOKUP(A2, D2:E## (the number symbols reflect the last row in the E column)
  4. Type a comma after the E## and the following so it looks like this: =VLOOKUP(A2, D2:E##,1,FALSE)
  5. Click Enter and in cell B2 you will either see #N/A or the login name listed. Keep B2 highlighted and drag the lower right corner down through the column to copy the formula all the way down the column so it checks each login name against the login report.

The #N/A means that the user has not logged in during the time period selected. If the login name appears, that user has logged in during the given report period.

Clever, no? Thanks, Eddie! More Excel Geekery icon wink


Utah User Group

Utah User Group i rpx9hL8 M

There is a Utah User Group coming up on July 22 at 10AM.

We will be at RISE Services: 6150 South Redwood Road, Taylorsville, UT.

Drop me a note if you’re coming by!!

And, as with Washington, it is *never* too late to hang with the cool kids!


Nerdiness X2!

Nerdiness X2! i 74kGLpJ M

Eddie Fung is the Director of Therap and Quality Assurance for TURN Community Services in Salt Lake City, UT.

In this session, Eddie reviews some handy freakin’ awesome Excel tools to work with exports from Therap.

This is not the live session presented originally. A GoToWebinar error corrupted the recording MUCH to my dismay.

Eddie re-recorded this for us because HE IS THE MOST AWESOME IN THE WORLD. (And he loves me!…That, too!)  ;)

Watch it HERE!

Thanks, Eddie!



TLord! i 74kGLpJ M

Welcome, Eddie Fung, to our growing list of certified Therap nerds. Here is some information about my friend, Eddie:

Since TURN Community Services began using Therap in October 2010, Eddie has been actively involved in learning the system, testing new modules, communicating with Therap’s technical support team, and serving as a resource for other TURN staff.  In July 2012, he became the Director of Therap and Quality Assurance for the agency, though some of his co-workers informally call him “T-Lord.”

A TURN employee since 2000, Eddie was a Program Coordinator until 2006, and then served as Director of Program Services up until July 2012. Eddie went to TURN after a career in the oil industry.  He has a degree in Chemical Engineering and worked for Exxon Mobil Corporation at oil refineries in New Jersey, Alberta, and Montana. He says that it wasn’t the right fit for him. “As a 21-year old college graduate in the oil industry, I was making more money than I am making today!  But I’m happier and loving my job, and I love working at TURN!”

Eddie currently lives in Salt Lake City with his husband, William, and 2 hybrid cars.  He was born in Hong Kong and lived in Ecuador for a couple of years. In the US, he grew up mostly on Long Island, New York and moved to New Jersey to work for Exxon.  He is an admitted tennis addict and plays 4-5 times per week. Traveling is another passionate hobby and he has plans to visit Slovenia, Croatia, Italy, and Switzerland this year.

(Maybe he can find some agencies in Switzerland for me to go train! –Allison)

Utah User Group

Utah User Group i ZK22b4h M

The first scheduled Utah User Group of 2014 is on MARCH 24 at 11AM MDT.
All existing Utah Therap users have received an invitation to the web conference.
Some suggested topics include:
1. Support Coordinator access to Therap
2. Individual access to Therap
3. System interface with Utah
4. Conference in October
4. Onsite User Group Agenda: 7/22/2014 at Rise Services
5. Anything and Everything Else
Please let me know if you have any questions.
Hugs and Tlogs,

2014 User Groups…Thus Far!

2014 User Groups...Thus Far! i pD8HhHB L

A gratuitous picture of Archie (and his Auntie Barb) to get your attention...He is also known to show up in Oregon and Washington here and there!



2/7/2014 at 10AM AKST

5/16/2014 at 10AM AKDT

8/22/2014 at 10AM AKDT

12/5/2014 at 10AM AKDT

The Alaska User Group meets quarterly using GoToMeeting. All current Alaska users will receive the login information prior to each meeting. Please be in touch with me if you need any information.

(“What is a user group?” you ask. A user group is a group of Therap users in the same state who meet to troubleshoot, network, discuss statewide issues, and get the lowdown on any new Therap releases. They also can contain training on any portion of Therap’s system.)



2/19/2014 at 10AM PST

Location: Pathway Enterprises, 1600 Sky Park Drive, Medford, OR

Phone: 541-973-2728

3/6/2014 at 10AM PST

Location: Alvord-Taylor Independent Living Services, 72 Centennial Loop, Eugene, OR

Phone: 541-736-3442

4/22/2014 at 10AM PDT

Location: Pendleton City Hall, 500 SW Dorion Ave, Pendleton, OR

There is no cost associated with these groups that are conducted onsite at a given agency. All users in Oregon are invited to any of the scheduled meetings.

Please RSVP to me with the number of attendees your agency will be sending. Users should also feel free to invite anyone who may be interested in Therap as well. These meetings usually run a couple of hours.



3/24/2014 at 11AM MDT ONLINE

This meeting will be conducted online using GoToMeeting. All current Utah users will receive the login information prior to each meeting.

Please be in touch with Allison Dudo if you need any information. This is the first of several more meetings to be held in 2014, both online and onsite in Salt Lake City.

Keep an eye out for more groups in Oregon, Washington, Utah, Arizona, and Nevada..I’m still scheduling!



At the request of some fabulous Therap users, I’m coming to see you in Salt Lake City.

I’ll be at TURN on December 6 at 10AM to discuss a variety of things, and all that you bring to the table to discuss as well.

Among some topics of interest:

1. New Therap things
2. Support Coordinators’ access to respective Therap systems in UT
3. ISP Data and Billing
4. Therap’s interface with the State of UT
5. Planning 2014 user groups
6. Any questions you have…

The meeting, as always, promises to be more of the above and things unimagined by any of us until we get there. Utahhhhhhhhh! icon smile

TURN’S address is 423 West 800 South, Suite A200, Salt Lake City, UT 84101 and here is their number: (801) 359-8876.

Please drop me a note and let me know how many people you will be sending so we can give our host an idea of how many people will be taking over their office. Utahhhhhhhhh! icon smile

I look forward to seeing you all again!!


Utahhhhhhh! i L6HCTfW M

I spent the first half of the week in Utah with Therap users in Salt Lake City and St. George with Danvill-ains, TURN-ites, and created all sorts of madness and mayhem. The meeting in Salt Lake City ran over three hours and I got to see User Groups in action as the providers shared their ideas, workarounds, and discussed the access they are granting their support coordinators. It really was a helpful and productive meeting. St. George was more intimate but, as with the first, was beneficial for all involved.

I’m still getting over a WICKED (take note, Maine-iacs) cold. Hopefully, being back home and getting caught up will finally knock it out…

Next week: Bend, Oregon.


Utah User Groups!

Utah User Groups! i MK2z8wq M

There will be two Utah user groups held in April. They will be onsite in Salt Lake City and St. George, UT. There is no cost associated with these groups. All current users in Utah will receive an emailed invitation. If you are interested in more information, please contact me.

Salt Lake City User Group

April 23, 2013, at 10AM 

This is in-person and will be held at the following location:

TURN Community Services

423 West 800 South, Bldg A (North Building)

Salt Lake City, UT

TURN’s number: 801-359-8876


St. George User Group

April 24, 2013, at 10AM

This is in-person and will be held at the following location:

Danville Services of Utah

Southern Region

145 North 400 West

St. George, UT

Danville’s number: (435) 634-1704


Hey, Utahhhhhhhhhh!

The Annual Utah Provider Conference is rapidly approaching. Have you registered yet? Its not too late, we still have spaces available! Check out  the information below and then get registered. The EARLY BIRD discount ends TOMORROW!

Regional Conference in Salt Lake City, Utah, October 3-4, 2012

The conference is a good place for Therap users to learn about individual support documentation and reporting, electronic health records (EHR) and training management from Therap. If you are an agency who has not yet decided on an Electronic Documentation system for your agency, we welcome you to attend and take the chance to talk to us and experience Therap first-hand. Contact us if you have questions.Hey, Utahhhhhhhhhh! register orange

Event highlights include:

  • Hands-on training on different Therap modules including incident reportshealth tracking and billing
  • Sessions focused on implementation and effective use
  • Interactive discussions
  • Utah user group meeting and discussions

Registration Fee: $85
Note: Register by September 19, 2012 for
the Early Bird Discount and pay $75 only.
Click here to register for this event

Information Flyer
Preliminary Schedule (in black & white)

For more information about how Therap is being used in Utah, visit our
Therap in Utah page.

Venue & Accommodation:
Holiday Inn Hotel & Suites
5001 W. Wiley Post Way,
Salt Lake City, Utah 84116