Thursday, October 23, 2014

Central Desktop Webinar: Collabosphere Best Practices Applied

Sherrie, Kelly, and Neil will be participating in the Central Desktop webinar scheduled today. Kelly and Jeanette attended Collabosphere and this should be a great synopsis of those collaboration sessions.  This should be a helpful webinar and details are available below for those that wish to register for the one hour training.  Katie Gaston of Central Desktop does an excellent job leading the webinars.  Jeanette plans to watch the recorded webinar session since she is in meetings in Eastern Washington during the webinar.

October Community Discussion: Collabosphere Best Practices Applied

Wed October 22, 2014 at 10:00 am PDT 

Register for community call here:

Central Desktop is a project management and great collaboration tool!  Go to:

Wednesday, October 22, 2014

Eastern Washington EMR Product Evaluation

Jerry Schneider and Jeanette Griffin are on-site this week with a large mental health provider in Eastern Washington, helping them evaluate EMR (electronic medical record) software and consulting on best practices for using a data warehouse to export data to their RSN (Washington State Regional Support Network). They will be working with provider staff to evaluate how well CoCentrix’s (UNI/CARE) latest EMR product will meet their needs.

JCS has created and helped fine tune data warehouses for several customers to make the exporting of data to RSNs and other payers easier and provide a more useful reporting platform. 

Tuesday, October 21, 2014

Netsmart Connections 2014 attended by Jeanette, Jerry, and Shayne

Jeanette Griffin, Jerry Schneider, and Shayne Spratt just returned from Connections 2014, the Netsmart/Avatar software conference in Anaheim, California. No pun intended, many "connections" were made there with Netsmart customers as well as officers and support within Netsmart itself.

The conference provided many interesting insights into the direction NetSmart believes the industry is headed. Netsmart presented extensive development on a care management product that sits above the traditional behavioral health direct care model and treatment plan.  Netsmart is also working to expand data shared with HIE (Heath Information Exchanges) and is always looking for ways to improve experiences for clinical providers and consumers of behavioral health services. Some hard questions were asked, and it seems Avatar is improving issues with data conversion customers have experienced in the past.

JCS intends to continue providing electronic medical record, state reporting, HIPAA standard transactions, and data warehouse support to agencies converting to Avatar (Netsmart), CCP (CoCENTRIX, formerly UnicareSys), Psychconsult (Askesis), as their vendor of choice.  JCS also continues to support agencies using Netsmart's MIS (formerly CMHC Systems, Inc.) software as they have for over 20 years.

Collabosphere 2014 - Kelly & Jeanette

Jeanette and Kelly attended the Central Desktop annual collaboration conference on September 9, 2014 in Long Beach, CA.  Although Collabosphere was shorter this year than last, the single day of events was jam packed with helpful hints.  The annual event provided opportunities to network with project managers, implementation specialists, and forward-thinking collaborators similar to those on the Jet Computer Support team. 

Central Desktop (aka Social Bridge) provides a great, reasonably priced and cloud-based project management collaboration tool!  Go to:

Contact us today and we can help you:

  • implement or document your Central Desktop
  • manage your project using a workspace we set-up for you with our Central Desktop account

Tuesday, April 22, 2014

Shayne & Jeanette attend Netsmart (CMHC) MIS Summit/NUG

Shayne and Jeanette attended the Netsmart National User Group (NUG) summit April 1st and 2nd in Kansas City.  Shayne continued meetings on Thursday with the MIS NUG Board.

Netsmart provided helpful demonstrations and comparisons for three products:  myAvatar, Tier, and myEvolv.  Updates were provided for ICD-10 with federal implementation being delayed until October, 2015.  Netsmart strongly recommends not waiting until 2015 but using the extra time for clinicians to become comfortable with the changes from ICD-9 to ICD-10.

Contact Shayne or Jeanette for more information about the summit.

Excel Tips - Calculate Age and Age Category

Excel Tips – Calculating Age and Age Category
by Kelly Nortrom
Many people are intimidated by Microsoft Excel and miss out on some of the great tools Excel provides that make it easy to analyze and make sense of your data.  Here are a few easy and intermediate tips using formulas to make your data more useful.

1.    Age Calculation in Years

Let’s say that you have some basic demographic data for that includes birth date.  You need to determine the age as of today and separate them into age classifications to coordinate with special population specialists (Kids = under age 18, Elders = age 60 and older).  This will mean that we are calculating the difference between two dates with the result being a number.

I start with adding the headers on the new columns that I will create (“Age”, “Age Class”) and also add a cell with Today’s date so that we have a “point-in-time” where we are calculating the age.

To calculate the age, we click on cell E2 and enter this formula:


We have to divide the difference between the two dates by 365.25 (the number of days in a year adjusted for leap years) to get the result to convert to the number of years.  I then highlight column E, right click, and select Format Cells.  I select Number and change the decimal places to 2.  In order to make the formula above be able to copy down to the additional cells in column E, we need to make the reference to the date in cell H1 a constant (our point-in-time date).  To do this, click back on cell E2, and in the formula field, manually change it to add a dollar sign ($) in two places like this:


You can now either click and drag that formula down column E or you can Fill Down.

Click and Drag method:
Click on cell E2, hover your mouse over the lower right corner until you get a cross symbol, click and drag your mouse down to the last entry in column E, then release.

Click and Drag Method

Fill Down method:
Click on cell E2, hold the shift key down and then click on the last cell in column E to copy the formula to (in this case, E7).  Select the Home tab, click on the fill icon  in the Editing section, and select Down.  This method is especially helpful when populating cells in very large Excel spreadsheets.

2.    Age Category Using =IF statement

Now that we have determined our client’s ages, we need to set up a formula using IF statements to classify them into age groups.  I find it easiest to start with either the youngest group or the eldest group so that the formula is less complex.  To keep things simple, we are going to start by seeing what our formula would look like if we only classified our clients by either “Kid” versus “Adult”.  IF statements in Excel have this syntax:

=IF([logical test],[what to do if logical test is true],[what to do if logical test is false])

So following that syntax, I enter this formula into cell F2:


You would then copy this formula down column F by using either the click and drag method or the Fill Down method explained above.

3.    Multiple Age Categories using Nested =IF statements

In our situation, we need to distinguish between three different scenarios (Kid, Adult, Elder) which will require us to do a more advanced formula called a nested IF statement.  This means that the beginning portion of our IF statement can remain the same, but our “what to do if logical test is false” needs to be another IF statement to evaluate against the last two possible age categories.

There are several right ways to do our nested IF statement, but I’m going to just show one here.  Please see the end of this blog entry for other examples of how to get to the same result.  In cell F2, I enter this formula:


You would then copy this formula down the column as you have done before.  Essentially this IF statement broken down is saying,

If the age is less than 18, then enter “Kid”, otherwise if the age is over age 59.99, enter “Elder”, and everything else enter “Adult”.

Here is what your result should look like:

Other nested IF statements that would work for this situation:


I hope that this is helpful to you and stay tuned for more blog entries with helpful hints!