Generating Reports

One of the highly valued features of this system is that it allows the user (organisation or individual) to review the therapy work and create summary reports quickly and easily because all the information is organised into excel spreadsheets.
 
ATTENDANCE AND USAGE REPORTS - numbers of sessions attended, missed etc are all formatted together in one sheet
 
Client ID Site Gen Age Counsellor Start Date NSess Type DNA Canc Lt Canc Absent closed
32782 Site 1 F 31 Mike 20/09/2012 5 telephone 0 0 0 0 20/12/2012
39011 Site 1 M 34 Maria 24/09/2012 7 telephone 0 0 0 0 07/11/2012
39021 Site 1 F 45 Mitch 19/09/2012 5 telephone 1 0 0 0 22/10/2012
39061 Site 1 F 34 Mandy 30/11/2012 8 telephone 0 0 0 0 07/02/2013
39062 Site 1 F 48 Mike 19/12/2012 8 telephone 4 0 0 0 13/06/2013
39063 Site 1 F 30 Maria 28/11/2012 3 facetoface 2 0 2 0 25/02/2013
39064 Site 1 F 21 Mitch 13/12/2012 7 facetoface 0 0 1 0 18/02/2013
39065 Site 1 M 21 Mandy 14/12/2012 8 facetoface 0 0 0 0 27/02/2013
89066 Site 2 F 48 Mike 14/01/2013 8 facetoface 0 0 0 0 22/04/2013
89067 Site 2 M 30 Maria 15/01/2013 2 facetoface 0 0 0 0 22/01/2013
89068 Site 2 F 29 Mitch 21/01/2013 5 facetoface 2 0 1 0 11/03/2013
89069 Site 2 F 21 Mandy 15/01/2013 1 facetoface 0 0 0 0 28/01/2013
89070 Site 2 F 30 Mike 29/01/2013 7 facetoface 0 0 1 0 16/04/2013
89071 Site 2 M 37 Maria 28/02/2013 8 facetoface 0 0 0 0 30/05/2013
89072 Site 2 M 29 Mitch 04/03/2013 8 facetoface 0 0 0 0 04/06/2013
89075 Site 2 M 29 Mandy 06/03/2013 6 facetoface 1 0 1 0 28/05/2013
89076 Site 2 M 41 Mike 04/03/2013 8 telephone 0 0 0 0 05/06/2013
89077 Site 2 F 33 Maria 21/03/2013 1 telephone 0 0 0 0 27/03/2013
89078 Site 2 F 25 Mitch 15/04/2013 8 telephone 0 0 0 0 05/06/2013
 
 
MEASURING CHANGE REPORTS: using a pre-and-post measurement this can be summarised into reports
 
ID SITE GENDER AGE OPEN DATE CLOSE DATE No Sessions TYPE Counsellor First Date First core34 Last Date Last core34 Diff core
32782 Site 1 F 31 19/08/2013 20/12/2012 5 telephone Mike 20/09/2012 28 23/08/2013 10 18
39011 Site 1 M 34 25/09/2012 07/11/2012 7 telephone Maria 24/09/2012 19 07/11/2012 6 13
39021 Site 1 F 45 18/09/2012 22/10/2012 6 telephone Mitch 19/09/2012 20 22/10/2012 13 7
39061 Site 1 F 34 23/11/2012 07/02/2013 8 telephone Mandy 30/11/2012 16 07/02/2013 6 10
39062 Site 1 F 48 14/12/2012 13/06/2013 12 telephone Mike 19/12/2012 20 28/03/2013 7 13
39063 Site 1 F 30 23/11/2012 25/02/2013 7 facetoface Maria 28/11/2012 16 15/02/2013 3 13
39064 Site 1 F 21 11/12/2012 18/02/2013 8 facetoface Mitch 13/12/2012 22 18/02/2013 11 11
39065 Site 1 M 21 11/12/2012 27/02/2013 8 facetoface Mandy 14/12/2012 25 27/02/2013 9 16
89066 Site 2 F 48 19/12/2012 22/04/2013 8 facetoface Mike 14/01/2013 18 22/04/2013 7 11
89067 Site 2 M 30 09/01/2013 22/01/2013 2 facetoface Maria 15/01/2013 27 22/01/2013 5 22
89068 Site 2 F 29 08/01/2013 11/03/2013 8 facetoface Mitch 21/01/2013 23 11/03/2013 6 17
89069 Site 2 F 21 10/01/2013 28/01/2013 1 facetoface Mandy 15/01/2013 30 15/01/2013 6 24
89070 Site 2 F 30 29/01/2013 16/04/2013 8 facetoface Mike 29/01/2013 20 16/04/2013 12 8
 
 
DEMOGRAPHIC REPORTS – examining how the service is used by different groups within a community
 
Site 1 32782 Mike 31 White/Brit female 5 Self Heterosexual Nurse English Jewish Family
Site 1 39011 Maria 34 Chinese male 7 GP Not known Teacher English None Bereavement
Site 1 39021 Mitch 45 Asian female 6 GP Bisexual Social worker English Christian Self-harm
Site 1 39061 Mandy 34 Asian/Brit male 8 CPN Heterosexual Unemployed English Christian Bullying
Site 1 39062 Mike 48 Polish female 12 Social Services Heterosexual Carer English None Depression
Site 1 39063 Maria 30 French male 7 Self Heterosexual Engineer English Other Self-worth
Site 1 39064 Mitch 21 African female 8 Employer Gay/Lesbian Plumber English Muslim Anxiety
Site 1 39065 Mandy 21 African/Brit male 8 Self Gay/Lesbian Nursery Worker English Not known Panic attacks
Site 2 89066 Mike 48 White/Brit female 8 Hospital Bisexual Shop Assist English Buddhist Stress
Site 2 89067 Maria 30 Chinese male 2 Employer Bisexual HR Worker English Christian Abuse
Site 2 89068 Mitch 29 Asian female 8 Psychology Heterosexual Nurse English Jewish Marriage Problems
Site 2 89069 Mandy 21 Asian/Brit male 1 Self Heterosexual Teacher English None Family
Site 2 89070 Mike 30 Polish female 8 GP Heterosexual Social worker English Christian Bereavement
Site 2 89071 Maria 37 French male 8 GP Heterosexual Unemployed English Christian Self-harm
Site 2 89072 Mitch 29 African female 8 CPN Bisexual Carer English None Bullying
Site 2 89075 Mandy 29 African/Brit male 8 Social Services Heterosexual Engineer English Other Depression
Site 2 89076 Mike 41 White/Brit female 8 School Heterosexual Plumber English Muslim Self-worth
Site 2 89077 Maria 33 Chinese male 1 Employer Heterosexual Nursery Worker English Not known Anxiety
Site 2 89078 Mitch 25 Asian female 8 Self Heterosexual Shop Assist English Buddhist Panic attacks
Site 2 89079 Mandy 25 Asian/Brit male 8 Hospital Gay/Lesbian HR Worker English Christian Stress
Site 2 89080 Mike 33 Polish female 8 Self Heterosexual Nurse English Jewish Abuse
Site 2 89081 Maria 38 French male 8 Psychology Heterosexual Teacher English None Marriage Problems
Site 2 89082 Mitch 22 African female 8 Self Heterosexual Social worker English Christian Family
Site 2 89083 Mandy 55 African/Brit male 7 GP Heterosexual Unemployed English Christian Bereavement

RESEARCH

Sincharta stores anonymised data from all users. If users wish to contribute their set of data to the Sincharta pool they are able to do this and on that basis they can use this data pool to benchmark their service. This offers a rich source of data about counselling: demographics of clients, effectiveness of service based on outcome measures, type of counselling, attendance and service use. This data set offers a very promising resource for research and benchmarking of services. Since the data sets are stored anonymously there is no threat to confidentiality while allowing for in-depth investigation of all aspects of therapeutic interventions
© Copyright 2024 Sincharta LimitedWeb Design By Toolkit Websites