ࡱ> QSR u'\pyvonnea Ba=  =Kj8X@"1?Arial1?Arial1?Arial1?Arial1?Arial1?Arial1?Arial1?Arial10?Arial1?Arial1 ?Arial1$?Arial1?Arial10?Arial10?Arial1?Arial1?Arial1?Arial1?Arial1?Arial1?Arial1?Arial1?Arial1?Arial1Q?Tahoma1Q?Tahoma10?Tahoma""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00#""#,##0.00;[Red]\-""#,##0.005*0_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-,)'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=,8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-4+/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\)                + ) , *     ( "8 *8 *x (8 +x  h  8  8  ,  l  ( "8  8  8 "8   8  8  Q            `@ pennine pie source datauB1.bar per 100kN2.bar cross servicen3.bar comparison,Tzr8  3 A@@  +$TotalNurseDoctor Clinical Psychologist Educational Psychologist Social WorkerPsychotherapists CAF OT Family Therapist Other Qual Therapist Other Qual Other Unqual PMHW Managers Admin% each discipline England Population 15 per 100kactual wte clinicalPopulation 2005 estimates ONSgAppendix Staffing CAMHS Workforce Plan % each discpline XXX CAMHS Total EnglandTotal XXX CAMHS ABCDEFTurn to the three charts. They will have updated to show: 1. how your staff numbers compare with the rate of 15 per 100k population (NSF), 2. what proportion of each discipline are in each team/service, 3. how your staff mix compares with the average for England. Right click on the titles to replace XXX with the name of your CAMHS. Highlight and copy, then paste into your plan. It may be easier to control the size and placement of the chart in your Word document if you place it in a text box.$To put your own labels on the legendH1. Right click the chart, and then click Source Data on the Chart menu. 3. In the Name box, specify the worksheet cell you want to use as the legend text or data series name, by clicking the arrow. Then go to source data.H2. On the Series tab, click the data series name you want to change (A).hpage and select the name of your first service (in column B), press the red arrow again. Repeat for B-F *- - )\;cc  u'MLaserJet 2100 (3)4C odXXLetterDINU"4O "dXX??3` 4#` 4#0 0 3add 3QQ ; Q ;Q3_4E4D$% M=3O&Q4$% M=3O&Q4FA0; 3O 3" $% h=XM=3OQ '43_ M NM  MM< 444%  iXM<3O'Q '4% kXM<3O'Q '4%  XM<3Oga'Q '4% wd 8XM<3Ox'Q '4%  3XM<3OXA'Q ' 4% xoXM<3ON'Q ' 4% oXM<3O-'Q ' 4% XM<3O;'Q ' 4% BXM<3O('Q ' 4% XM<3OOS'Q '4% J XM<3Oa'Q '4%  =XM<3Oy'Q '4%  XM<3O)'Q '4% p XM<3O%'Q '44eNurseDoctor 5Clinical Psychologist =Educational Psychologist # Social Worker3Psychotherapists CAF OT +Family Therapist 1Other Qual Therapist Other Qual # Other Unqual  PMHW  Managers  AdmineIw6@Zt@~r!*@0d̥?;o1@" ?" ?v?" @ 6Q@ 4ގ` @ 6Q @ 0d̥@ <}?-@e> <}ad u' "$::  dMbP?_*+%MHP LaserJet 2100 (1)4C odXXLetterDINU"4O " dXX??U} $} $} I} I} } }  } $ } $ } I } $ "  @ @              $%%%%%%%%%%%%%             *??????@ -~ yA" %I$I@ DD" ^CR:@ DD *??????@~ @" %I$I@ DD" 6]$@ DD *??????@~ @" %I$I@ DD" h1^)@ DD *??????@~ P@" %I$I@ DD" e? DD *??????@~ @" %I$I@ DD" o?@ DD *??????@ ~ 8@" %I$I@ DD" u2i@ DD * ?????? @ ~ #@" %I$I@ D D" KT+ao? D D * ?????? @ ~ @" %I$I@ D D" d :@ D D  * ?????? @ ~ A@" %I$I@ D D" c R3@ D D  * ?????? @ ~ *@" %I$I@ D D" Gy @ D D  * ?????? @~ A:@" %I$I@ D D"  @ D D  *??????@~ !@" %I$I@ DD" 9I%F|@ DD  *??????@~ A3@" %I$I@ DD" YBwRj@ DD *??????@~ A" %I$I@ DD" /l/@ DD ,@ -d,@,@,@,@,@U@ ~ F<# X@ % # Y@ %    & &&      # "((((((((((( *!@!@!@!@!@!@#L@ %"Ծ"((((((((((( ) ?Dj@) ?Dj@) ?Dj@) ?Dj@) ?Dj@) ?Dj@# "@ %"((((((((((( ](@GDDDDDDD D D D D D](@GDDDDDDD D D D D D](@GDDDDDDD D D D D D](@GDDDDDDD D D D D D](@GDDDDDDD D D D D D](@GDDDDDDD D D D D D#N@ %"((((((((((("((((((((((( ''''''''''' ''''''''''' ''''''''''' ''''''''''' '''''''''''  BX&^e",  !   ! R (  ~  <p.XPP?3_]4@p.8* Sp@N2P9 H <Iyvonnea: Across this row replace A-F with the names of each service/team< 4  7H.~~  <$.XPP?3U_D]4@$.0 ęL)NT H <Iyvonnea: Across this row replace A-F with the names of each service/team< 4  7H+~~  <.XPP?3U_D]4@.7 \)@D,  L(<Myvonnea: Insert the population covered by each service (from ONS/PCT/SHA/LA)<(4  QKL~~  <8.XPP?3U_D]4@8.l> QNvC4u ` <ayvonnea: This will automatically calculate how many clinical staff you would have at 15 per 100k< 4  `~~  <P.XPP?3U_D]4@P.(E v4IDz1+[ T <Uyvonnea: This row will automatically update as you put your own figures in rows 4-15< 4  hTyvonneayvonneayvonneayvonneayvonnea>@   7 u' GFF  dMbP?_*+%MHP LaserJet 2100 (1)4C odXXLetterDINU"4O "dXX??U     * + )**** <  (  p  6MNN?@ ]d  u'"d??3` /` /$3d23 M NM4 3Q:  15 per 100kQ ;Q ;Q3_4E4 3Q: *actual wte clinicalQ ;Q ;Q3_4E4D $% M=3O&Q4$% M=3O&Q4FA 3O@iX 3 b#M43*#M! M4523  O43"  U3O U% M@ 3OQ44444e A A B B C C D D E Ee?(@?(@?(@?(@?(@e >@7 u' $dR6S  dMbP?_*+%MHP LaserJet 2100 (1)4C odXXLetterDINU"4O "dXX??U$ !"# , --- - !-" "-! #-#PP(  j  0NMM? ]`  u'"??3` E$` E$pr3d23 M NM4 3Q: AQ ;Q ;Q3_4E4 3Q: BQ ;Q ;Q3_4E4 3Q: CQ ;Q ;Q3_4E4 3Q: DQ ;Q ;Q3_4E4 3Q: EQ ;Q ;Q3_4E4 3Q: FQ ;Q ;Q3_4E4D $% M=3O&Q4$% M=3O&Q4FA-q 3OS 3 b#M-43*#M4% 2nmM3OKQ  Discipline'4% 5~MZ3OAQ No.WTE'4523  O43" 3O% M@ 3OQ44444eNurseNurseNurseNurseNurseNurseDoctor Doctor Doctor Doctor Doctor Doctor 5Clinical Psychologist 5Clinical Psychologist 5Clinical Psychologist 5Clinical Psychologist 5Clinical Psychologist 5Clinical Psychologist =Educational Psychologist =Educational Psychologist =Educational Psychologist =Educational Psychologist =Educational Psychologist =Educational Psychologist # Social Worker# Social Worker# Social Worker# Social Worker# Social Worker# Social Worker3Psychotherapists CAF 3Psychotherapists CAF 3Psychotherapists CAF 3Psychotherapists CAF 3Psychotherapists CAF 3Psychotherapists CAF OT OT OT OT OT OT +Family Therapist +Family Therapist +Family Therapist +Family Therapist +Family Therapist +Family Therapist 1Other Qual Therapist1Other Qual Therapist1Other Qual Therapist1Other Qual Therapist1Other Qual Therapist1Other Qual Therapist Other Qual   Other Qual   Other Qual   Other Qual   Other Qual   Other Qual # Other Unqual #  Other Unqual #  Other Unqual #  Other Unqual #  Other Unqual #  Other Unqual  PMHW  PMHW  PMHW  PMHW  PMHW  PMHW  Managers   Managers   Managers   Managers   Managers   Managers  Admin Admin Admin Admin Admin Admine?????????????????????????????????????????????????????? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?e >@% %% 7  u'MLaserJet 2100 (3)4C odXXLetterDINU"4O "dXX??3` 4#` 4#0 0 3add 3Q: 8% each discpline XXX CAMHSQ ; Q ;Q3_4E4 3Q: 6% each discipline EnglandQ ; Q ;Q3_4E4D$% M=3O&Q4$% M=3O&Q4FAT k 3O.C 3 b#M-43*#M! M4523  O43" , b3O, % M@ 3OQ44444eNurseNurseDoctor Doctor 5Clinical Psychologist 5Clinical Psychologist =Educational Psychologist =Educational Psychologist # Social Worker# Social Worker3Psychotherapists CAF 3Psychotherapists CAF OT OT +Family Therapist +Family Therapist 1Other Qual Therapist1Other Qual Therapist Other Qual   Other Qual # Other Unqual #  Other Unqual  PMHW  PMHW  Managers   Managers  Admin Admine%I$I@^CR:@%I$I@6]$@%I$I@h1^)@%I$I@e?%I$I@o?@%I$I@u2i@%I$I@KT+ao?%I$I@d :@%I$I@c R3@ %I$I@ Gy @ %I$I@  @ %I$I@ 9I%F|@ %I$I@ YBwRj@ %I$I@ /l/@e> /ad Oh+'0HP\l  syvonneaMicrosoft Excel@gX@k/Y@՜.+,0@ PXt | Durham Universitys  source data1.bar per 100k2.bar cross service pennine pie3.bar comparison  WorksheetsCharts  !"#$%&'()*+,-./0123456789:;<=>@ABCDEFHIJKLMNRoot Entry F@_6!Workbookq}SummaryInformation(?DocumentSummaryInformation8GRoot Entry F"T@Workbookq}SummaryInformation(?DocumentSummaryInformation8@  !"#$%&'()*+,-./0123456789:;<=>@ABCDEFU ՜.+,D՜.+,@ PXt | Durham Universitys  source data1.bar per 100k2.bar cross service pennine pie3.bar comparison  WorksheetsCharts@ X_AdHocReviewCycleID_EmailSubject _AuthorEmail_AuthorEmailDisplayName 39"website materials camhs workforceY.Anderson@hascas.org.ukYvonne Anderson