Question - I run the Care Net Report for each month and put the numbers in a spreadsheet, then at the end of the year run the Care Net Report for the whole year. But, it seems the totals that I have in my spreadsheet "Totals" page never add up to the Care Net Report totals for the whole year. Why is that?
Answer - First of all, the Care Net Report is designed for Care Net's use. As such, the calculations and statistics produced are specified by Care Net and may not be exactly what your Center is looking for in certain situations. We have other reports that may be better suited.
Now for the explanation: The Care Net Report removes DUPLICATE visits for the same Client and Case. For example, say Darla Smith visits the center in January. It's her first visit ever, so her Case Number is 1. Nobody else comes in January (slow month). You run the Care Net Report for January and it says you served one Caucasian female, age 18-25.
In February, Darla comes back for a follow-up appointment, but nobody else comes in February. You run the Care Net Report for February, and it says you served one Caucasian female, age 18-25.
Now you decide to run the Care Net report for Jan 1st through Feb 28. Guess what? It says you served one Caucasian female, age 18-25. Not two? But wait, January said 1 and February said 1, why doesn't the total for both months show 2? That is because for the Jan-Feb time period, you SERVED ONLY ONE CLIENT - Darla. The DUPLICATES are removed.
So, statistically the January report is CORRECT, the February report is CORRECT, and the January through February report IS CORRECT. You just can't add up the individual months to correspond to the total. It is all in the "perspective" of how you are reporting the data.