{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["OOH Program Staffing Summary","Instructions","list-do not delete"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":13,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"OOH Program Staffing Summary","index":0,"n_rows":42,"n_cols":24,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,12,3,22],[4,12,4,22],[5,12,5,22],[6,12,6,22],[6,9,6,11]]}
[]
[]
[]
["Date:","2016-07-01",null,null,"Contract period:","7/1/2016-6/30/2018",null,null,"Ctrl m","= 1st shift",null,null,"Add/insert rows with formula at the bottom of each section only (see instructions). Delete rows as necessary. "]
["Agency Name:","Agency ABC",null,null,"Report Type:","Please select",null,null,"Ctrl a","= 2nd shift",null,null,"*Other Programs-Please include names of any other programs this staff person is scheduled to work."]
["Program Name:","Program 1",null,null,"Program IOS:","RTC",null,null,"Ctrl y","= 3rd shift",null,null,"**Demonstrate program’s ability to ensure staffing ratio whenever youth are present at the home during weekday school hours, including during school breaks and youth absences from school."]
["Contract #:","17XXXX",null,null,"Provider #:","0123456",null,null,"Ctrl e","=additional coverage 1st shift weekday **",null,null,"***Weekly hours will total automatically"]
["Contracted staff/ youth ratio:","1:4",null,null,"Contracted LOS:",5,null,null,"Ctrl n","= no fill"]
["Staff name","Title","Highest degree","Area of study","Qualifications (licenses, certifications, years of applicable exp.)","Functional job duties (including any supervision)","FT/PT (hours)","% of hours to this program","Other programs*","Sun   start","Sun     End","Mon start","Mon End","Tues Start","Tues End","Wed Start","Wed End","Thurs Start","Thurs End","Fri Start","Fri End","Sat Start","Sat End","Weekly total hours**"]
["DIRECT CARE"]
["John Smith","Direct care milieu","BA","Psychology","3 years exp.",null,"FT (40)",1,"n/a",null,null,null,null,null,null,"07:00:00","15:00:00","07:00:00","15:00:00",null,null,null,null,{"$f":"MOD(K11-J11,1)*24+MOD(M11-L11,1)*24+MOD(O11-N11,1)*24+MOD(Q11-P11,1)*24+MOD(S11-R11,1)*24+MOD(U11-T11,1)*24+MOD(W11-V11,1)*24","v":16}]
["Sue Sunshine","Direct care milieu","BA","Social Work","5 years exp.",null,"PT (24)",1,"n/a",null,null,null,null,null,null,null,null,"15:00:00","23:00:00",null,null,null,null,{"$f":"MOD(K12-J12,1)*24+MOD(M12-L12,1)*24+MOD(O12-N12,1)*24+MOD(Q12-P12,1)*24+MOD(S12-R12,1)*24+MOD(U12-T12,1)*24+MOD(W12-V12,1)*24","v":7.9999999999999929}]
["Ted Smith","Direct care milieu","BA","Sociology","1 year exp.",null,"PT (24)",1,"n/a",null,null,null,null,null,null,"23:00:00",1.2916666666666701,null,null,null,null,null,null,{"$f":"MOD(K13-J13,1)*24+MOD(M13-L13,1)*24+MOD(O13-N13,1)*24+MOD(Q13-P13,1)*24+MOD(S13-R13,1)*24+MOD(U13-T13,1)*24+MOD(W13-V13,1)*24","v":8.0000000000002096}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MOD(K19-J19,1)*24+MOD(M19-L19,1)*24+MOD(O19-N19,1)*24+MOD(Q19-P19,1)*24+MOD(S19-R19,1)*24+MOD(U19-T19,1)*24+MOD(W19-V19,1)*24","v":0}]
[null,null,null,null,null,null,null,null,"Direct Care Subtotal:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Direct_Care)","v":32.000000000000199}]
["CASE MANAGEMENT"]
["Lynn Wall","Case Manager","BA","Psychology","3 years exp.","Direct care staff supervisor","FT (40)",1,"n/a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MOD(K22-J22,1)*24+MOD(M22-L22,1)*24+MOD(O22-N22,1)*24+MOD(Q22-P22,1)*24+MOD(S22-R22,1)*24+MOD(U22-T22,1)*24+MOD(W22-V22,1)*24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MOD(K23-J23,1)*24+MOD(M23-L23,1)*24+MOD(O23-N23,1)*24+MOD(Q23-P23,1)*24+MOD(S23-R23,1)*24+MOD(U23-T23,1)*24+MOD(W23-V23,1)*24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MOD(K24-J24,1)*24+MOD(M24-L24,1)*24+MOD(O24-N24,1)*24+MOD(Q24-P24,1)*24+MOD(S24-R24,1)*24+MOD(U24-T24,1)*24+MOD(W24-V24,1)*24","v":0}]
["CLINICAL CARE"]
["Jane Smith","Clinician","MSW",null,"LCSW. 1 year exp.",null,"FT (40)",0.5,"Program 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MOD(K26-J26,1)*24+MOD(M26-L26,1)*24+MOD(O26-N26,1)*24+MOD(Q26-P26,1)*24+MOD(S26-R26,1)*24+MOD(U26-T26,1)*24+MOD(W26-V26,1)*24","v":0}]
["Karen Williams","Allied Therapist","MFA","Music","LSW. 5 years exp.",null,"PT (20)",0.25,"Program 2, Program 3, Program 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["ADMINISTRATIVE"]
["Joe Smith","Program Director","MSW",null,"3 years exp.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MOD(K33-J33,1)*24+MOD(M33-L33,1)*24+MOD(O33-N33,1)*24+MOD(Q33-P33,1)*24+MOD(S33-R33,1)*24+MOD(U33-T33,1)*24+MOD(W33-V33,1)*24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["OTHER"]
["James Scott","Psychiatrist","MD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MOD(K37-J37,1)*24+MOD(M37-L37,1)*24+MOD(O37-N37,1)*24+MOD(Q37-P37,1)*24+MOD(S37-R37,1)*24+MOD(U37-T37,1)*24+MOD(W37-V37,1)*24","v":0}]
["Donna Harris","Nurse","HS","n/a","LPN. 1 year exp.","Under direct supervision of RN","PT (10)",0.25,"Program 2, Program 3, Program 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Ted Williams","Dietician","BS","Pre-med'","RDN",".5 hours per child @ intake",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Total Hours:  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(X20:X41)","v":32.000000000000199}]

{"sheet":"Instructions","index":1,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,3,1]]}
["Department of Children & Families - Children's System of Care\nOOH Program Staffing Summary Report\nINSTRUCTIONS"]
[]
[]
[]
["1:","If the agency is contracted to provide 5 programs and a social worker works in all of these programs, also include this person on the Core Agency Personnel sheet (section 1.3)  If this is an amendment to your Section 1.3 , then include this change with any others in an updated Section 1.3 (w/ track changes or revisions highlighted) with your Annex A Attestation (Attachment B)."]
["2:","List all full-time and part-time positions dedicated to this program. Include contracted and sub-contracted positions that are part of the treatment team."]
["3:","Add/insert additional rows from the last row in each staff category - to do this, right click on the row number to insert. After row is inserted, click on the cell in the \"Weekly Total Hours\" column and either copy/paste or use the shortcut Control d to copy formula into cell."]
["4:","Include title, education, degree type, qualifications and functional job duties for each staff name."]
["5:","FT/PT hours are general, and not specific to the program."]
["6:","% hours to the program = % of FT/PT general hours"]
["7:","If a staff member works across multiple programs, please list those in the \"other programs\" column."]
["8:","If a staff member is dedicated <100% to program, list only the shifts/hours dedicated this program ie. if Full-time Allied Clinician (40 hours) is dedicated 20% to this program, the weekly total hours on the schedule should equal 8."]
["9:","Use the drop down list in each cell to select the begin and end time for each shift (e.g. 11AM-8PM). Please round to the nearest 1/2 hour."]
["10:","Indicate 1st, 2nd, 3rd shift if applicable using Ctrl m, Ctrl a, Ctrl y, to add shading (remove if necessary with Ctrl n for no shading). "]
["11:","Weekly and total hours will calculate automatically."]

{"sheet":"list-do not delete","index":2,"n_rows":49,"n_cols":4,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
[]
["07:00:00","15:00:00"]
["08:00:00","16:00:00"]
["09:00:00","17:00:00"]
["10:00:00","18:00:00"]
["11:00:00","19:00:00"]
["12:00:00","20:00:00"]
["13:00:00","21:00:00"]
["14:00:00","22:00:00"]
["15:00:00","23:00:00"]
["16:00:00",1]
["17:00:00",1.0416666666666701]
["18:00:00",1.0833333333333299]
["19:00:00",1.125,null,"Please select"]
["20:00:00",1.1666666666666701,null,"Initial"]
["21:00:00",1.2083333333333399,null,"Contract Modification"]
["22:00:00",1.25,null,"Report Year 2"]
["23:00:00",1.2916666666666701,null,"Report Year 3"]
[0.999999999999994,1.3333333333333399,null,"Report Year 4"]
[1.0416666666666601,1.375,null,"Report Year 5"]
[1.0833333333333299,1.4166666666666701]
[1.12499999999999,1.4583333333333399]
[1.1666666666666601,1.50000000000001]
[1.2083333333333299,1.5416666666666701]
[1.24999999999999,1.5833333333333399]
["07:30:00","15:30:00"]
["08:30:00","16:30:00"]
["09:30:00","17:30:00"]
["10:30:00","18:30:00"]
["11:30:00","19:30:00"]
["12:30:00","20:30:00"]
["13:30:00","21:30:00"]
["14:30:00","22:30:00"]
["15:30:00","23:30:00"]
["16:30:00",1.0208333333333299]
["17:30:00",1.0625]
["18:30:00",1.1041666666666701]
["19:30:00",1.1458333333333399]
["20:30:00",1.1875]
["21:30:00",1.2291666666666701]
["22:30:00",1.2708333333333399]
["23:30:00",1.3125]
[1.0208333333333299,1.3541666666666701]
[1.0625,1.3958333333333399]
[1.1041666666666601,1.4375]
[1.1458333333333299,1.4791666666666701]
[1.1875,1.5208333333333399]
[1.2291666666666601,1.5625]
[1.2708333333333499,1.6041666666666701]