{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Sheet1","index":0,"n_rows":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Unit name:",null,null,"Submission Date:"]
["Chair:",null,null,"Data dates: "]
["Clinical Nursing Director/Supervisor:"]
[null,null,"Required "]
[null,"X when complete","Staffing/Workload Monthly Report","Threshold","Actual"]
[1,null,"Open Positions (filled/budgeted=percentage filled) Manager supplied info","5% vacancy or greater","%"]
[2,null,"Orientation ( \"O\"  column, divide by 40/4) NP-ND form in Tableau","Orientees, time lines associated with end of orientation, time line for passing boards","FTE/wk"]
[3,null,"Leaves (EST, Childbirth and Parental leave) (\"e\", \"*\" and \"J\") (column divide by 40/4) NP/ND Tableau","5% of productive hours","FTE/wk"]
[4,null,"Scheduled PTO (\"o\" column divided by 40/4 to see FTE per week average) ) NP/ND form Tableau","Prospective Usage =","FTE/wk"]
[5,null,"Unscheduled PTO- (\"w\" columns divide by 40/4) NP/ND form Tableau","Looking for trends ","FTE/wk"]
[6,null,"Unit Business Time (#, B) (Add \"#\", \"B\" and \"=\", \"!\" then divide by 40/4) NP/ND report Tableau",null,"FTE/wk"]
[7,null,"Excused Absences (NO PAY - S) NP/ND form in Tableau","Actual hours per month","Hrs/mon"]
[8,null,"Unexcused Absences resulting in no pay (U)- NP/ND report in Tableau","Actual hours per month","Hrs/mon"]
[9,null,"Turnover-(Turnover data quarterly)",0.05,"%"]
[10,null,"CSR (Regular and Temp)-Trigger report Tableau","10% of productive hours","%"]
[11,null,"Per Diem and/or CSR Temps- Trigger report Tableau","# hours worked per month","Hrs/mon"]
[12,null,"Travelers- Manager will supply info if any used","5% of productive hours","%"]
[13,null,"Unsafe Practice Documents/ADO forms","# of unsafe practice documents received in a month"]
[14,null,"Unit specific initiatives/seasonal changes (presenting @ conferences, educational  meetings)"]
[15,null,"Trigger- Trigger report in Tableau","< 4%","%"]
[16,null,"Overappointment hours worked- Trigger report Tableau"]
[17,null,"Overtime hours worked- Trigger report Tableau"]
[null,null,"FVR report","Any need to implement on-call program/incentives"]
[18,null,"Completion of Care hours",null,"Hrs/mon"]
[null,null,"Recommended  (Variable activity)","NOTES"]
[1,null,"HPPD year to date, patient visits, surgical hours (productivity report) (look at YTD and period #'s)","Budgeted- "]
[2,null,"Occupancy - (Patient days/365/number of beds on unit)(Productivity report) (Look at YTD and period #'s)","Budgeted- "]
[3,null,"Anticipated absences (EST, Childbirth and parental leave, sched PTO)"]
[5,null,"Holidays"]
[6,null,"Institutional initiatives (New units & expansions)"]
[7,null,"Skill mix (experienced vs novice RN's)"]
[8,null,"Hospital Business Time (HB)"]
[9,null,"Other"]
[]
[]
["Action Plan:"]