ࡱ> 465 u'ɀ\pOXP User Ba= =x[,!8X@"1?Arial1?Arial1?Arial1?Arial1?Arial10?Arial10?Tahoma1?Arial1?Arial1?Arial1?Arial1?Arial1?Arial1Q?Tahoma1Q?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_-;_-* "-"??_-;_-@_- #,##0.0                + ) , *   ( (8  #x   ( #|  ,  #8  +8 #8  ,   , #|   8  8  (8   ( ` Source dataM2 Bar chart,TZR3 A@@  $#Total White British White Irish White otherMixed white black africanMixed white and asian Other mixedIndian Pakistani Bangladeshi Other AsianChineseAfrican Caribbean Other black Other ethnicMixed white black caribbean%!! Total CAMHS Appendix Ethnicity source data CAMHS Workforce Plan .Total population% CAMHS % population Service/team Turn to the worksheet "Bar chart". It will have updated to show how the ethnicity of your CAMHS caseload compares to the proportions of those groups in the population. Right click on the title to add the name of your CAMHS then highlight and copy. 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.BCDEFcA CAMHS Workforce Plan Leave the demonstration figures (usually 1)in the cells, do not delete. Take your own CAMHS data from the mapping return. Highlight a row and insert your own figures.Find your population figures from ONS and do the same. The calculations will automatically update.* 9 t 2  u'ɀ (:$:')6)@)f)  dMbP?_*+%MLaserJet 2100 (3)4C odXXLetterDINU"4O " dXX??U} $} } m} } } I} m} } } } I } I} } } m} } m} I} } $ :@e      !!!!!!! "" """"""""""!!!!!!!""""""""""" #                       $!T????????????? ??.@  -d $f????????????????0@ $f????????????????0@ $f????????????????0@ $f????????????????0@ $ f????????????????0@8+ f ???????????????? 0@   " @  D D " @  D D " @  D D " @  D D " @  D D " @  D D " @  D D " @ D D " @ D D " @ D D " @ D D " @ D D " @  D D " @  D D " @  D D " @  D D  Y@  " @  D D " @  D D " @  D D " @  D D " @  D D " @  D D " @  D D " @ D D " @ D D " @ D D " @ D D " @ D D " @  D D " @  D D " @  D D " @  D D  Y@  f  ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?#  0@  %  ~ @ A  D " pc0@  D D( ~ V@  A  D " :53@  D D " """"""""""~ *@ 5 A  D"+q2@  DD"""""""""""~ @P]A  D" i{I9@  DD"""""""""""~ @@ A  D"'CN3@  DD"""""""""""#33333=@  % #0A  % #X@  % """""""""""***2#P8ww .. !"#./0189:;? *!*"*#.*/*0*18*9*:*;? ... ... ...@ABCDEFP*@*A*BCD*E*FP... ..||lT(  ~  <d.XPP?G"]4@d.[  /G0S>_ 8 <9yvonnea: Replace A-F with the names of each team/service< 4  8~~  <.XPP?G ]4@.\ -v@t<=9 Q <Ryvonnea: The total for each ethnic group across all teams will appear in this row< 4 NQ (~~  <|.XPP?G UD]4@|.] Z?O'IQTN) D <Eyvonnea: This row will show the % of each ethnic group seen in CAMHS< 4 'D~~  <.XPP?G UD]4@.^ d@7  u'ɀMLaserJet 2100 (3)4C odXXLetterDINU"4O "dXX??3` 4#` 4# ` 4# ` 4# 0 0 3add 3Q: % CAMHSQ ; Q ;Q3_4E4 3Q:  % populationQ ; Q ;Q3_4E4D$% M=3O&Q4$% M=3O& Q4FAAu ! 3O 3 b#M-43*#M! M4% qM3Oq& Q $ONS Ethnic group'4% 2Ie^MZ3O& Q %'4523  O43"  3O % M@ 3OQ4444% QHM03OT& Q Z+XXX CAMHS ethnicity excluding White British'44e White Irish White Irish White other White other;Mixed white black african;Mixed white black african?Mixed white black caribbean?Mixed white black caribbean3Mixed white and asian3Mixed white and asian Other mixed Other mixedIndianIndian Pakistani Pakistani Bangladeshi Bangladeshi Other Asian  Other Asian Chinese Chinese Caribbean  Caribbean African African Other black  Other black! Other ethnic! Other ethnice@@@@@@@@@@@@@@@@@@ @ @ @ @ @ @ @ @ @ @@@@@e> ad Oh+'0HP`p yvonneayvonneaMicrosoft Excel@@H4j@՜.+,0 PXd lt| HAS  Source data Bar chart  WorksheetsCharts  !#$%&'()+,-./01Root Entry F#!WorkbookBSummaryInformation("DocumentSummaryInformation8*Root Entry FP7WorkbookBSummaryInformation("DocumentSummaryInformation8  !#$%&'()8 ՜.+,D՜.+,0 PXd lt| HAS  Source data Bar chart  WorksheetsCharts@ X_AdHocReviewCycleID_EmailSubject _AuthorEmail_AuthorEmailDisplayName Fs"website materials camhs workforceY.Anderson@hascas.org.ukYvonne Anderson