ࡱ> 87 g2ɀ\pShelton Heather Ba==KJ8X@"1Arial1Calibri1Calibri1Calibri1Arial1Arial1Arial1Arial1Calibri1 Calibri1Calibri14Calibri1 Calibri1Calibri1Calibri1,8Calibri18Calibri18Calibri1>Calibri14Calibri1<Calibri1?Calibri1h8Cambria1Calibri1 Calibri1Arial1Arial1Arial""#,##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\)                                                                      ff + ) , *     P  P        `             a>       @       $    $@    $    @   $ @     $@      $   $@   $ "0  "0@  0    0 @  @     0   0@ "0  "0@ *0  *0@ "0    0 @ "0@  (  h@ @  #8@ @   `@ @   $@ @   ,@ @   (@ @   (@ @  "x@ @   (@ @  "<@ @  !8@ @  "<@ @  )8@ @  !8@ @  "<@ @  )8@ @  "<@ @   8@ @  !8@ @  "<@ @  (8@ @   "8@ @  ||sh}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef [$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L [$ -}A} 00_)23[$ -}A} 00_)23[$ -}A} 00_)23[$ -}A} 00_)23[$ -}A}  00_)23[$ -}A}! 00_)23 [$ -}A}" 00_)[$ -}A}# 00_)[$ -}A}$ 00_)[$ -}A}% 00_)[$ -}A}& 00_)[$ -}A}' 00_) [$ -}A}( 00_)[$ -}}) }00_)[$ -##0.  }}* 00_)[$ -???##0.??? ??? ???}-}/ 00_)}A}0 a00_)[$ -}A}1 00_)[$ -}A}2 00_)?[$ -}A}3 00_)23[$ -}-}4 00_)}}5 ??v00_)̙[$ -##0.  }A}6 }00_)[$ -}A}7 e00_)[$ -}x}900_)[$##  }}: ???00_)[$???## ???  ??? ???}-}< 00_)}U}= 00_)[$## }-}> 00_)}A}] 00_)[$}-}^ 00_)}(}_00_)}-}a 00_)}(}b 00_)}(}d 00_)}(}f 00_)}(}h 00_)}(}i 00_)}(}k 00_)}(}l 00_)}(}m 00_)}(}p 00_)}(}q 00_)}(}r 00_) 20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L渷 % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  Lմ % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23ږ % 60% - Accent3M( 60% - Accent3 23כ % 60% - Accent4M, 60% - Accent4 23 % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23 % "Accent1AAccent1 O % #Accent2A!Accent2 PM % $Accent3A%Accent3 Y % %Accent4A)Accent4 d % &Accent5A-Accent5 K % 'Accent6A1Accent6  F %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextG5Explanatory Text % 0Good;Good  a%1 Heading 1G Heading 1 I}%O2 Heading 2G Heading 2 I}%?3 Heading 3G Heading 3 I}%234 Heading 49 Heading 4 I}% 5InputuInput ̙ ??v% 6 Linked CellK Linked Cell }% 7NeutralANeutral  e%"Normal 8Normal 2 9Noteb Note   :OutputwOutput  ???%????????? ???;$Percent <Title1Title I}% =TotalMTotal %OO> Warning Text? Warning Text %XTableStyleMedium2PivotStyleLight16`" <Q1.excl medical and dental"eAQ1.medical and dental only EQ2 GQ4,CCommonTTrust Board Report 2018-2019Month 12 - Mar 19Supporting infostaff in postOrganisation Profile Analysis for Board Report as at 31 Mar 19 - with pivots.xlspivotspivot stabilitystability by staff grpheadcount by staff grpage profile healthcare opsage profile infoheadcount by band-staff grpFTE by staff groupFTE by pay bandby BU staff group N&M HeadcountSheet1Staff List FULLSIP for los pivot>1yr serviceMacro1 BU ref listYYYYYYYYYY Y Y Y Y YYZRecoverY# BusinessUnits<KKRecover: TableNameDummy82+DHeadcount as at 31 Mar 19 (excluding Medical and Dental Staff Group)Assignment CategoryFixed Term Temp Permanent Grand TotalAdd Prof Scientific and TechnicAdditional Clinical ServicesAdministrative and ClericalAllied Health ProfessionalsEstates and AncillaryHealthcare Scientists Nursing and Midwifery RegisteredStudents/Headcount - Medical and Dental staff group onlyRoleLocum ConsultantOther Staff Groupp2. Staff Cost - Total staff cost during the 2018/19 financial year split into permanent and non-permanent staff. CategoryTotalX4. Agency Spend - Total amount spent on agency staff in the 2018/19 financial year split into in Trusts staff groups (e.g. Medical, Nursing, Adin, AHP etc.) and speciality/grade (e.g. Consultants, GP, ICU Nurse, Acute Nurse, Occupational Therapists, Pharmacists, Health care Assistants, etc.) depending on how this is reported within the Trust.18/19 Expenditure '000Non Permanent (bank and agency) Staff TypeClinical StaffMedical ConsultantsCareer/Staff GradesTrainee GradesTotal Medical Staff Non-MedicalRegistered NursesSupport to Nursing StaffOther ST & T StaffTotal Non-Medical Staff Total Clinical Staff Non-Clinical StaffNHS Infrastructure SupportTotal Non-Clinical StaffTotal Agency Spend18-19 Expenditure '00026 679x:1;9ccB g2ɀ !=@  dMbP?_*+%&ffffff?'ffffff?(?)?"B333333?333333?r &<3U} $} $}  } } m} m } $} m        S UV WT M NX ?B?C`@D`@ EF5@G@H @ EFI@G̑@H@ EF@Gp@Hq@ E  F?Gy@Hy@ E  F@GC@HD@ E  F"@G`@H@ E ~ F@ G~ H@ I JW@Kȱ@L$@40*******4>@KJ  b(b(,Lf&3?ggD g2ɀ {BgD  dMbP?_*+%&ffffff?'ffffff?(?)?"333333?333333?̜&<3U} } } m }  } m   Y U [VQZ ? @ @ A OB(@C@Cg@Di@ PBf@C?CM@D@n@ IJ`h@K@Kn@L{@d,B00>@KJb(b(,Lf&3?ggD g2ɀ /FuG  dMbP?_*+%&ffffff?'ffffff?(?)?"333333?333333?̜&<3U} m!} m} $   , ,   , RRRRRRRRRR ] ^ _~ `A _~ `@ ]~ a AP*>@  ggD g2ɀ HL  dMbP?_*+%&ffffff?'ffffff?(?)?"333333?333333?&<3U} $} } H@      \\\\\\\\ b r* cd ef gh3}e@ g~ hw@ ih@ jk?o@ e  h i! hN`o@ i" h@_0~@ l# mS\U]@ n$ hE&@ nh o%p/Q58@ c&h i'hl9j@ q(pl9j@ b)k\8%ٻ@*h&     >@%"!!! ggD Oh+'0@H\t  Wood JulieShelton HeatherMicrosoft Excel@BaA@x[՜.+,0HP X`hp x  Q1.excl medical and dentalQ1.medical and dental onlyQ2Q4  Worksheets  !"#$%&()*+,-.0123456Root Entry FWorkbookMSummaryInformation('DocumentSummaryInformation8/