{"text_format":"2","workbook":"xlsx","n_sheets":14,"sheets":["Key","Guidelines","Trigger Coding","Holiday Incentives","Shift Premium","Thanksgiving On","Holiday Off-Not Full Appt","Holiday Off-Full Appt-$$","Holiday Off-Full Appt-PTO","Hol Off-Full-Extra Hrs-$$","Hol Off-Full-Extra Hrs-PTO","Addl Hol Off-Full-$$","Addl Hol Off-Full-PTO","Thanksgiving Week Off-Ext. Sick"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":15,"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":"Key","index":0,"n_rows":41,"n_cols":5,"rows_kept":41,"cut":false,"hidden":false,"merged":[[39,4,39,11],[38,0,38,11],[40,4,40,11],[41,0,41,11],[29,0,29,11],[36,0,37,0],[36,1,37,1],[36,2,37,2],[36,3,37,3],[36,4,36,11],[37,4,37,11],[32,2,33,2],[32,3,33,3],[32,4,32,11],[33,4,33,11],[28,4,28,11],[27,4,27,11],[34,0,35,0],[34,1,35,1],[34,2,35,2],[34,3,35,3],[34,4,34,11],[35,4,35,11],[30,0,31,0],[30,1,31,1],[30,2,31,2],[30,3,31,3],[30,4,30,11],[31,4,31,11],[32,0,33,0],[32,1,33,1],[0,0,0,11],[1,4,1,11],[3,4,3,11],[5,4,5,11],[6,4,6,11],[4,0,4,11],[17,4,17,11],[18,4,18,11],[20,4,20,11],[7,4,7,11],[9,4,9,11],[10,4,10,11],[11,4,11,11],[12,4,12,11],[8,0,8,11],[19,0,19,11],[13,0,13,11],[16,0,16,11],[14,4,14,11],[15,4,15,11],[21,4,21,11],[22,0,22,11],[26,0,26,11],[23,1,25,1],[23,2,25,2],[23,3,25,3],[23,4,23,11],[24,4,24,11],[25,4,25,11],[23,0,25,0]]}
["Key for MNA Thanksgiving Holiday Scenarios"]
["TRC CODE","Rate of Pay","ONESTAFF CODE","BRIEF    DESC","DESCRIPTION"]
[]
["REG",1,"varies","REG PAY","Hours worked by direct care staff; Productive time;  paid at Regular rate"]
[]
["HOL",1,"H","HOL PAY","A shift Paid as a holiday; used when holiday is part of the appointment"]
[{"$nulls":4},"Non-productive time; paid at Regular rate; "]
[{"$nulls":4},"Does not count towards OT."]
[]
["HOM",1,"V","HOLOFFOA","A shift Paid as a holiday when the Holiday is not part of the appointment or"]
[{"$nulls":4},"to pay additional holiday pay hours to match holiday worked hours"]
[{"$nulls":4},"Non-productive time; paid at Regular rate; "]
[{"$nulls":4},"Does not count towards OT."]
[]
["HOP",1,"Y","HOLPTO","At employee’s request, in lieu of pay, holiday hours are to be added to"]
[{"$nulls":4},"PTO bank at Regular rate;  Non-productive time"]
[]
["HOR",1.5,"@","HOLPTO1.5","(MNA Only) At employee’s request, in lieu of pay, holiday hours are to be added to"]
[{"$nulls":4},"PTO bank at the 1.5 times rate of pay; Non-productive time"]
[]
["HWT",1.5,"h","HOL WORK ","Hours worked by direct care staff on designated holidays."]
[{"$nulls":4},"This code is entered at the time the payroll is done and is not used during the scheduling process;  In Staffer, after the dailies are printed and HPPD has been run, if hours are split between shifts, code all hours to the shift on which it is to be paid.  (for example, 12 hr day shift A splits 8 hrs shift 2 and 4 hrs shift 3;  change the A code to h code and then shift 3 to 2 so all house will be paid at the day shift rate).  Productive time; paid at Overtime rate.  Not to be used for unanticipated additional OT hours that are worked on the Holiday.\n**For MNA nurses on 12/25 only, h will interface into Mpathways as HWT and a rule will run to flip any HWT reported on 12/25 to HWD to pay double time**"]
[]
["Manual change to HWT or HWD","1.5 or 2.0","t","OT","Unanticipated additional hours worked by direct care staff on one of the"]
[{"$nulls":4},"designated holidays;  this code is entered into Staffer and is not used"]
[{"$nulls":4},"during the scheduling process.  Productive time;  paid at Overtime rate."]
[]
["OTR",1,"+","OA","Time worked in excess (OA) of the employee's schedule/appointment;   Productive; paid at a Regular rate."]
["OTP",1.5,"t","OT","Time worked in excess of a regular employee's schedule/appointment;  Productive; paid at Overtime rate"]
[]
["OTX",1.75,"(","OA COC","(MNA only) OA worked related to patient care safety, such as completing patient care, procedures, tests and transport will not be considered mandatory overtime and will not qualify for mandatory overtime pay premium"]
[{"$nulls":4},"OA hours worked in these situations will be paid at 1.75x hourly rate of pay"]
["OTZ",1.75,"Z","OT COC","(MNA Only) OT worked related to patient care safety, such as completing patient care, procedures, tests and transport will not be considered mandatory overtime and will not qualify for mandatory overtime pay premium"]
[{"$nulls":4},"OA hours worked in these situations will be paid at 1.75x hourly rate of pay"]
["OTE",2,"-","OA COC OR","(MNA only) OA worked related to patient care safety, such as completing patient care, procedures, tests and transport will not be considered mandatory overtime and will not qualify for mandatory overtime pay premium"]
[{"$nulls":4},"OA hours worked in these situations will be paid at 2.0x hourly rate of pay for OR/PACU/Proc. Only  "]
["OTF",2,"x","OT COC OR ","(MNA Only) OT worked related to patient care safety, such as completing patient care, procedures, tests and transport will not be considered mandatory overtime and will not qualify for mandatory overtime pay premium"]
[{"$nulls":4},"OA hours worked in these situations will be paid at 2.0x hourly rate of pay for OR/PACU.Proc. Only "]
[]
["OTW",2,"m                 ","OA EMERG","(MNA Only) OA Emergency Situations"]
["OTY",2,"M               ","OT EMERG","(MNA Only) OT Emergency Situations "]

{"sheet":"Guidelines","index":1,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[[6,1,6,12],[9,0,9,4],[0,1,0,12],[1,1,1,12],[2,1,2,12],[3,0,5,0],[3,1,3,12],[4,1,4,12],[5,1,5,12]]}
[null,"Guidelines for MNA Holidays"]
[1,"Employees that are canceled or that call in for an OA/OT shift are not allowed to use PTO to cover that shift (holiday week or other week)"]
[2,"If an employee calls in for an OA/OT shift, this is to be counted as an unscheduled absence occurrence.  Onestaff code \"X\" with a code reason could be used to track the absence."]
[3,"If an employee preschedules their full appt fraction during a holiday week (they are off on the holiday) then you must assign one of the shifts that week as a designated extra shift. The assignment of this designated extra shift is determined based upon unit need and discussion between the employee and the manager."]
[null,"If such employee is canceled on their designated extra shift they can still choose to take the option of 1.5 times PTO for the holiday or they can be paid straight time for the holiday."]
[null,"The canceled shift is not Assigned Time Off and should not be coded with (z . | W) voluntary/mandatory PTO or no pay codes.  All Holiday shifts are canceled opposed to being downstaffed.  Canceled Holiday shifts are marked on the Holiday Downstaffing Logs.  Canceled Holiday shifts can be tracked by using code \"X\" with a code reason.  "]
[4,"Reminder:  the default payment option for the holiday incentive is $$’s and the employee should have the option of changing from the PTO option to $$ option if their designated extra shift was canceled in the holiday week. "]
[]
[]
["Nursing Holiday Q&A"]

{"sheet":"Trigger Coding","index":2,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[[9,0,10,0],[9,1,9,12],[10,1,10,12],[0,1,0,12],[3,0,4,0],[3,1,3,12],[4,1,4,12],[6,0,7,0],[6,1,6,12],[7,1,7,12]]}
[null,"Trigger coding for MNA Holidays"]
[null,"SCENARIOS "]
[]
[1,"An RN is scheduled off the holiday but decides to pickup up a co-workers shift on the holiday. "]
[null,"                This extra shift be coded “h” (OT not included in the trigger)"]
[]
[2,"An RN is scheduled off the holiday but decides to pickup up an open shift on the holiday."]
[null,"                This extra shift be coded “h” (OT not included in the trigger)"]
[]
[3,"An RN  in a Non- OR/PACU/Proc. Area is scheduled on the holiday and ends up staying over for completion of care (unanticipated)  for all or part of another holiday shift due to unit need."]
[null,"                This extra shift be coded “Z\" (OT included in the trigger) and after Onestaff interfaces into Mpathways change from OTZ to HWT/HWD"]

{"sheet":"Holiday Incentives","index":3,"n_rows":22,"n_cols":1,"rows_kept":22,"cut":false,"hidden":false,"merged":[[16,0,16,11],[20,0,20,11],[0,0,0,11],[3,0,3,11],[6,0,6,11],[8,0,8,11],[11,0,11,11],[13,0,13,11]]}
["MNA Holiday Incentive Guidelines"]
[]
["Para 355"]
["Employees who are off on the holiday, but who request to be scheduled their full appointment fraction prior to schedule development and who work their full appointment fraction during a holiday week, may choose either:"]
["1)      Payment for the holiday at straight time, or"]
["2)      An equal number of hours added to their PTO bank at time and one half (1.5)(see Intent Note for Para 355), and"]
["3)      The employee will be exempt from assigned overtime for the designated extra shift, to be determined based upon unit need and discussion between the employee and the manager."]
["IMPORTANT:"]
["After determining which shift will be the designated extra shift, remember to designate the extra shift on the daily.  If this shift is canceled, remember not to use the voluntary/mandatory No Pay or PTO codes.  "]
["************************************************************************************************************************"]
["Para 355A"]
["Part-time employees who are off the holiday and who request to be scheduled for hours above their appointment fraction prior to scheduled development will receive time and one-half (1-1/2) pay for those over appointment hours worked during the holiday week."]
["IMPORTANT:  "]
["After determining which shift will be the designated extra shift, remember to designate the extra shift on the daily.  If this shift is canceled, remember not to use the voluntary/mandatory No Pay or PTO codes."]
["************************************************************************************************************************"]
["Para 355B"]
["During the schedule development, if an employee who was schedule to work the holiday and who volunteers or is assigned to take an additional holiday off, and is scheduled to work their full appointment fraction during the holiday week, the employee may choose either:"]
["1)      Payment for the holiday at straight time according to the hours of the usual shift length, or;"]
["2)      An equal number of hours added to their PTO bank and straight time, provided the full appointment is worked."]
["IMPORTANT:  "]
["After determining which shift will be the designated extra shift, remember to designate the extra shift on the daily.  If this shift is canceled, remember not to use the voluntary/mandatory No Pay or PTO codes."]
["************************************************************************************************************************"]

{"sheet":"Shift Premium","index":4,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,11]]}
["MNA Shift Premium Guidelines for Holidays"]
["Below is a quick cheat sheet for paying shift premium for RN holidays."]
[]
["Shift premium is paid on worked qualifying eves and nights codes:"]
[null,"HWT, HWD (h, d)"]
[]
["Shift premium is not paid on non-working holiday codes:"]
[null,"HOL (H), HOM (V), HOP (&), HOR (@)"]
[]
["************************************************************************************************************************"]

{"sheet":"Thanksgiving On","index":5,"n_rows":34,"n_cols":16,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,15],[1,0,1,15],[2,0,2,15],[3,0,3,15],[33,0,33,15]]}
["MNA THANKSGIVING HOLIDAY PAYROLL SCENARIOS"]
["Holiday On/No Extra Hours"]
["(Thanksgiving)"]
["Holiday (HOL and HOM) does not count in the calculation of OT"]
["FTE","Shift Lengths","Shifts Per Week",null,"SUN","MON","TUES","WEDS","THUR","FRI","SAT",null,"REG","HWT            1.5 Pay","HOL          1.0 Pay","HOM          1.0 Pay"]
[{"$nulls":8},"Holiday","Holiday",null,null,null,"h","H","V"]
[]
[1,"8hr (5)",5,null,null,8,8,8,"8 HOL    8 HWT","8 HOL    8 HWT",null,null,24,16,16]
[1,"8hr (2) and 12hr (2)",4,null,null,null,12,12,"8 HOL    8 HWT","8 HOL    8 HWT",null,null,24,16,16]
[1,"10hr (4)",4,null,null,null,10,10,"10 HOL 10 HWT","10 HOL 10 HWT",null,null,20,20,20]
[]
[0.9,"12hr (3)",3,{"$nulls":4},12,"12 HOL 12 HWT","12 HOL 12 HWT",null,null,12,24,24]
[0.9,"8hr (3) and  12hr (1)",4,null,null,null,12,8,"8 HOL    8 HWT","8 HOL    8 HWT",null,null,20,16,16]
[]
[0.8,"8hr (4)",4,null,null,null,8,8,"8 HOL    8 HWT","8 HOL    8 HWT",null,null,16,16,16]
[0.8,"8hr (1) and 12hr (2)",3,{"$nulls":4},12,"8 HOL    8 HWT","8 HOL    8 HWT",null,null,12,20,20]
[]
[0.7,"8hr (2) and 12hr (1)",3,{"$nulls":4},12,"8 HOL    8 HWT","8 HOL    8 HWT",null,null,12,16,16]
[0.7,"8hr (4) week 1                                       8 hr (3) week 2","4                                                            3",{"$nulls":4},8,"8 HOL    8 HWT","8 HOL    8 HWT",null,null,8,16,16]
[]
[0.75,"12hr (2) week 1                               12hr (3) week 2","2                                                                   3",{"$nulls":4},12,"12 HOL 12 HWT","12 HOL 12 HWT",null,null,12,24,24]
[]
[0.6,"8hr (3)",3,{"$nulls":4},8,"8 HOL    8 HWT","8 HOL    8 HWT",null,null,8,16,16]
[0.6,"12 (2)",2,{"$nulls":5},"12 HOL 12 HWT","12 HOL 12 HWT",null,null,0,24,24]
[]
[0.5,"8hr (1) and 12hr (1)",2,{"$nulls":5},"8 HOL    8 HWT","12 HOL    12 HWT",null,null,0,20,20]
[0.5,"10hr (2)",2,{"$nulls":5},"10 HOL 10 HWT","10 HOL 10 HWT",null,null,0,20,20]
[]
[0.4,"8 hr (2)",2,{"$nulls":5},"8 HOL    8 HWT","8 HOL    8 HWT",null,null,0,16,16]
[]
[0.3,"12hr (1)",1,{"$nulls":5},"12 HOL 12 HWT","12 HOM",null,null,0,12,12,12]
[]
[0.2,"8hr (1)  ",1,{"$nulls":5},"8 HOL    8 HWT","8 HOM",null,null,0,8,8,8]
["Designation of 8hr or 12hr holidays are decided by the unit."]

{"sheet":"Holiday Off-Not Full Appt","index":6,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,14],[1,0,1,14],[2,0,2,14],[33,0,33,13],[3,0,3,14]]}
["MNA THANKSGIVING HOLIDAY PAYROLL SCENARIOS"]
["Regular Holiday Off/Not Working Full Appt."]
["(Only Thursday used towards appt. fraction)"]
["Holiday (HOL and HOM) does not count in the calculation of OT"]
["FTE","Shift Lengths","Shifts Per Week",null,"SUN","MON","TUES","WEDS","THUR","FRI","SAT",null,"REG","HOL                               1.0 Pay"," HOM       1.0 Pay"]
[{"$nulls":8},"Holiday","Holiday",null,null,null,"H ","V"]
[]
[1,"8hr (5)",5,null,8,8,8,8,"8HOL","8HOM",null,null,32,8,8]
[1,"8hr (2) and 12hr (2)",4,null,null,8,12,8,"12HOL","8HOM",null,null,28,12,8]
[1,"10hr (4)",4,null,null,10,10,10,"10HOL","10HOM",null,null,30,10,10]
[]
[0.9,"12hr (3)",3,null,null,null,12,12,"12HOL","12HOM",null,null,24,12,12]
[0.9,"8hr (3) and  12hr (1)",4,null,null,8,8,8,"12HOL","8HOM",null,null,24,12,8]
[]
[0.8,"8hr (4)",4,null,null,8,8,8,"8HOL","8HOM",null,null,24,8,8]
[0.8,"8hr (1) and 12hr (2)",3,null,null,null,12,12,"8HOL","12HOM",null,null,24,8,12]
[]
[0.7,"8hr (2) and 12hr (1)",3,null,null,null,12,8,"8HOL","12HOM",null,null,20,8,12]
[0.7,"8hr (4) week 1                                       8 hr (3) week 2","4                                                            3",null,null,null,8,8,"8HOL","8HOM",null,null,16,8,8]
[]
[0.75,"12hr (2) week 1                            12hr (3) week 2","2                                    3",null,null,null,12,12,"12HOL","12HOM",null,null,24,12,12]
[]
[0.6,"8hr (3)",3,null,null,null,8,8,"8HOL","8HOM",null,null,16,8,8]
[0.6,"12 (2)",2,{"$nulls":4},12,"12HOL","12HOM",null,null,12,12,12]
[]
[0.5,"8hr (1) and 12hr (1)",2,{"$nulls":4},12,"8HOL","12HOM",null,null,12,8,12]
[0.5,"10hr (2)",2,{"$nulls":4},10,"10HOL","10HOM",null,null,10,10,10]
[]
[0.4,"8 hr (2)",2,{"$nulls":4},8,"8HOL","8HOM",null,null,8,8,8]
[]
[0.3,"12hr (1)",1,{"$nulls":5},"12HOL","12HOM",null,null,null,12,12]
[]
[0.2,"8hr (1)  ",1,{"$nulls":5},"8HOL","8HOM",null,null,null,8,8]
["Designation of 8hr or 12hr holidays are decided by the unit."]

{"sheet":"Holiday Off-Full Appt-$$","index":7,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[35,0,35,13],[0,0,0,13],[1,0,1,13],[2,0,2,13],[3,0,3,13],[33,0,33,13],[34,0,34,13]]}
["MNA THANKSGIVING HOLIDAY PAYROLL SCENARIOS"]
["Regular Holiday Off/Working Full Appt. (Prescheduled) - Para. 355"]
["Choosing Holiday Pay (Cash)"]
["Holiday (HOM) does not count towards the calculation of OT"]
["FTE","Shift Lengths","Shifts Per Week",null,"SUN","MON","TUES","WEDS","THUR","FRI","SAT",null,"REG","HOM               1.0 Pay"]
[{"$nulls":8},"Holiday","Holiday",null,null,null,"V"]
[]
[1,"8hr (5)",5,null,8,8,8,8,"8HOM","8HOM",8,null,40,16]
[1,"8hr (2) and 12hr (2)",4,null,8,12,8,12,"8HOM","12HOM",null,null,40,20]
[1,"10hr (4)",4,null,10,10,10,10,"10HOM","10HOM",null,null,40,20]
[]
[0.9,"12hr (3)",3,null,null,12,12,12,"12HOM","12HOM",null,null,36,24]
[0.9,"8hr (3) and  12hr (1)",4,null,8,8,8,12,"8HOM","8HOM",null,null,36,16]
[]
[0.8,"8hr (4)",4,null,8,8,8,8,"8HOM","8HOM",null,null,32,16]
[0.8,"8hr (1) and 12hr (2)",3,null,null,8,12,12,"8HOM","12HOM",null,null,32,20]
[]
[0.7,"8hr (2) and 12hr (1)",3,null,null,8,12,8,"8HOM","12HOM",null,null,28,20]
[0.7,"8hr (4) week 1                                       8 hr (3) week 2","4                                                            3",null,null,8,8,8,"8HOM","8HOM",null,null,24,16]
[]
[0.75,"12hr (2) week 1                            12hr (3) week 2","2                                    3",null,null,12,12,12,"12HOM","12HOM",null,null,36,24]
[]
[0.6,"8hr (3)",3,null,null,8,8,8,"8HOM","8HOM",null,null,24,16]
[0.6,"12 (2)",2,null,null,null,12,12,"12HOM","12HOM",null,null,24,24]
[]
[0.5,"8hr (1) and 12hr (1)",2,null,null,null,8,12,"8HOM","12HOM",null,null,20,20]
[0.5,"10hr (2)",2,null,null,null,10,10,"10HOM","10HOM",null,null,20,20]
[]
[0.4,"8 hr (2)",2,null,null,null,8,8,"8HOM","8HOM",null,null,16,16]
[]
[0.3,"12hr (1)",1,{"$nulls":4},12,"12HOM","12HOM",null,null,12,24]
[]
[0.2,"8hr (1)  ",1,{"$nulls":4},8,"8HOM","8HOM",null,null,8,16]
["Designation of 8hr or 12hr holidays are decided by the unit."]
["The extra shift will be determined based upon unit need and discussion between the employee and the manager."]
["Employee may choose $$ for both holidays, PTO for both holidays, or 1 holiday $$ and 1 holiday PTO."]

{"sheet":"Holiday Off-Full Appt-PTO","index":8,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[35,0,35,13],[0,0,0,13],[1,0,1,13],[2,0,2,13],[3,0,3,13],[33,0,33,13],[34,0,34,13]]}
["MNA THANKSGIVING HOLIDAY PAYROLL SCENARIOS"]
["Reg Holiday Off/Working Full Appt. (Prescheduled) - Para. 355"]
["Choosing Holiday PTO @ 1.5"]
["Holiday PTO (HOR) does not count in the calculation of OT"]
["FTE","Shift Lengths","Shifts Per Week",null,"SUN","MON","TUES","WEDS","THUR","FRI","SAT",null,"REG","HOR          1.5 PTO"]
[{"$nulls":8},"Holiday","Holiday",null,null,null,"@"]
[]
[1,"8hr (5)",5,null,8,8,8,8,"8HOR","8HOR",8,null,40,16]
[1,"8hr (2) and 12hr (2)",4,null,8,12,8,12,"8HOR","12HOR",null,null,40,20]
[1,"10hr (4)",4,null,10,10,10,10,"10HOR","10HOR",null,null,40,20]
[]
[0.9,"12hr (3)",3,null,null,12,12,12,"12HOR","12HOR",null,null,36,24]
[0.9,"8hr (3) and  12hr (1)",4,null,8,8,8,12,"8HOR","8HOR",null,null,36,16]
[]
[0.8,"8hr (4)",4,null,8,8,8,8,"8HOR","8HOR",null,null,32,16]
[0.8,"8hr (1) and 12hr (2)",3,null,null,8,12,12,"8HOR","12HOR",null,null,32,20]
[]
[0.7,"8hr (2) and 12hr (1)",3,null,null,8,8,12,"8HOR","12HOR",null,null,28,20]
[0.7,"8hr (4) week 1                                       8 hr (3) week 2","4                                                            3",null,null,8,8,8,"8HOR","8HOR",null,null,24,16]
[]
[0.75,"12hr (2) week 1                            12hr (3) week 2","2                                    3",null,null,12,12,12,"12HOR","12HOR",null,null,36,24]
[]
[0.6,"8hr (3)",3,null,null,8,8,8,"8HOR","8HOR",null,null,24,16]
[0.6,"12 (2)",2,null,null,null,12,12,"12HOR","12HOR",null,null,24,20]
[]
[0.5,"8hr (1) and 12hr (1)",2,null,null,null,8,12,"8HOR","12HOR",null,null,20,20]
[0.5,"10hr (2)",2,null,null,null,10,10,"10HOR","10HOR",null,null,20,20]
[]
[0.4,"8 hr (2)",2,null,null,null,8,8,"8HOR","8HOR",null,null,16,16]
[]
[0.3,"12hr (1)",1,{"$nulls":4},12,"12HOR","12HOR",null,null,12,24]
[]
[0.2,"8hr (1)  ",1,{"$nulls":4},8,"8HOR","8HOR",null,null,8,16]
["Designation of 8hr or 12hr holidays are decided by the unit."]
["The extra shift will be determined based upon unit need and discussion between the employee and the manager."]
["Employee may choose $$ for both holidays, PTO for both holidays, or 1 holiday $$ and 1 holiday PTO."]

{"sheet":"Hol Off-Full-Extra Hrs-$$","index":9,"n_rows":37,"n_cols":15,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,14],[1,0,1,14],[2,0,2,14],[3,0,3,14],[8,4,8,10],[9,4,9,10],[10,4,10,10],[4,0,4,14],[36,0,36,14],[34,0,34,14],[35,0,35,14]]}
["MNA THANKSGIVING HOLIDAY PAYROLL SCENARIOS"]
["Regular Holiday Off/Working Full Appt (Prescheduled)  PLUS  Extra OA Hours (Prescheduled) - Para. 355A"]
["Choosing Holiday Pay (Cash)"]
["Extra OA hrs worked above worked appt. fraction are paid as OT"]
["Holiday (HOM) does not count towards the calculation of OT"]
["FTE","Shift Lengths","Shifts Per Week",null,"SUN","MON","TUES","WEDS","THUR","FRI","SAT",null,"REG","OTP         1.5 Pay","HOM                      1.0 Pay"]
[{"$nulls":13},"t","V"]
[{"$nulls":8},"Holiday","Holiday"]
[1,"8hr (5)",5,null,"Not an option for 1.0 fte"]
[1,"8hr (2) and 12hr (2)",4,null,"Not an option for 1.0 fte"]
[1,"10hr (4)",4,null,"Not an option for 1.0 fte"]
[]
[0.9,"12hr (3)",3,null,"4extra",12,12,12,"12HOM","12HOM",null,null,36,4,24]
[0.9,"8hr (3) and  12hr (1)",4,null,8,8,8,12,"8HOM","8HOM","4extra",null,36,4,16]
[]
[0.8,"8hr (4)",4,null,8,8,8,8,"8HOM","8HOm","8extra",null,32,8,16]
[0.8,"8hr (1) and 12hr (2)",3,null,"8extra",8,12,12,"8HOM","12HOM",null,null,32,8,20]
[]
[0.7,"8hr (2) and 12hr (1)",3,null,"8extra",8,8,12,"8HOM","12HOM",null,null,28,8,20]
[0.7,"8hr (4) week 1                                       8 hr (3) week 2","4                                                            3",null,null,8,8,8,"8HOM","8HOM","8extra",null,24,8,16]
[]
[0.75,"12hr (2) week 1                            12hr (3) week 2","2                                    3",null,"4extra",12,12,12,"12HOM","12HOM",null,null,36,4,24]
[]
[0.6,"8hr (3)",3,null,null,8,8,8,"8HOM","8HOM","8extra",null,24,8,16]
[0.6,"12 (2)",2,null,null,"8extra",12,12,"12HOM","12HOM",null,null,24,8,24]
[]
[0.5,"8hr (1) and 12hr (1)",2,null,null,null,8,12,"8HOM","12HOM","8extra",null,20,8,20]
[0.5,"10hr (2)",2,null,null,"8extra",10,10,"10HOM","10HOM",null,null,20,8,20]
[]
[0.4,"8 hr (2)",2,null,null,"8extra",8,8,"8 HOM","8HOM",null,null,16,8,16]
[]
[0.3,"12hr (1)",1,null,null,null,"8extra",12,"12HOM","12HOM",null,null,12,8,24]
[]
[0.2,"8hr (1)  ",1,null,null,null,"8extra",8,"8HOM","8HOM",null,null,8,8,16]
["Designation of 8hr or 12hr holidays are decided by the unit."]
["The extra shift will be determined based upon unit need and discussion between the employee and the manager."]
["Employee may choose $$ for both holidays, PTO for both holidays, or 1 holiday $$ and 1 holiday PTO."]

{"sheet":"Hol Off-Full-Extra Hrs-PTO","index":10,"n_rows":37,"n_cols":15,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,14],[1,0,1,14],[2,0,2,14],[3,0,3,14],[36,0,36,14],[4,0,4,14],[34,0,34,14],[35,0,35,14],[8,4,8,10],[9,4,9,10],[10,4,10,10]]}
["MNA THANKSGIVING HOLIDAY PAYROLL SCENARIOS"]
["Regular Holiday Off/Working Full Appt (Prescheduled)  PLUS  Extra OA Hours (Prescheduled) - Para. 355A"]
["Choosing PTO @ 1.5"]
["Extra OA hrs worked above worked appt. fraction are paid as OT"]
["Holiday PTO (HOR) does not count towards the calculation of OT"]
["FTE","Shift Lengths","Shifts Per Week",null,"SUN","MON","TUES","WEDS","THUR","FRI","SAT",null,"REG","OTP         1.5 Pay","HOR          1.5 PTO"]
[{"$nulls":13},"t","@"]
[{"$nulls":8},"Holiday","Holiday"]
[1,"8hr (5)",5,null,"Not an option for 1.0 fte"]
[1,"8hr (2) and 12hr (2)",4,null,"Not an option for 1.0 fte"]
[1,"10hr (4)",4,null,"Not an option for 1.0 fte"]
[]
[0.9,"12hr (3)",3,null,"4extra",12,12,12,"12HOR","12HOR",null,null,36,4,24]
[0.9,"8hr (3) and  12hr (1)",4,null,12,8,8,8,"8HOR","8HOR","4extra",null,36,4,16]
[]
[0.8,"8hr (4)",4,null,8,8,8,8,"8HOR","8HOR","8extra",null,32,8,16]
[0.8,"8hr (1) and 12hr (2)",3,null,"8extra",8,12,12,"8HOR","12HOR",null,null,32,8,20]
[]
[0.7,"8hr (2) and 12hr (1)",3,null,null,8,8,12,"8HOR","12HOR","8extra",null,28,8,20]
[0.7,"8hr (4) week 1                                       8 hr (3) week 2","4                                                            3",null,"8extra",8,8,8,"8HOR","8HOR",null,null,24,8,16]
[]
[0.75,"12hr (2) week 1                            12hr (3) week 2","2                                    3",null,null,12,12,12,"12HOR","12HOR","4extra",null,36,4,24]
[]
[0.6,"8hr (3)",3,null,"8extra",8,8,8,"8HOR","8HOR",null,null,24,8,16]
[0.6,"12 (2)",2,null,null,null,12,12,"12HOR","12HOR","8extra",null,24,8,24]
[]
[0.5,"8hr (1) and 12hr (1)",2,null,null,"8extra",8,12,"8HOR","12HOR",null,null,20,8,20]
[0.5,"10hr (2)",2,null,null,null,10,10,"10HOR","10HOR","8extra",null,20,8,20]
[]
[0.4,"8 hr (2)",2,null,null,null,8,8,"8HOR","8HOR","8extra",null,16,8,16]
[]
[0.3,"12hr (1)",1,null,null,null,"8extra",12,"12HOR","12HOR",null,null,12,8,24]
[]
[0.2,"8hr (1)  ",1,{"$nulls":4},8,"8HOR","8HOR","8extra",null,8,8,16]
["Designation of 8h or 12hr holidays are decided by the unit."]
["The extra shift will be determined based upon unit need and discussion between the employee and the manager."]
["Employee may choose $$ for both holidays, PTO for both holidays, or 1 holiday $$ and 1 holiday PTO."]

{"sheet":"Addl Hol Off-Full-$$","index":11,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,0,37,13],[35,0,35,13],[36,0,36,13],[0,0,0,13],[1,0,1,13],[2,0,2,13],[3,0,3,13],[4,0,4,13],[34,0,34,13]]}
["MNA THANKSGIVING HOLIDAY PAYROLL SCENARIOS"]
["Additional Holiday Off - Offered and Accepted (Prescheduled) - Para. 355B"]
["Choosing Holiday Pay (Cash)"]
["Must be Prescheduled to Work Full Appt."]
["Holiday (HOM) does not count towards the calculation of OT"]
["FTE","Shift Lengths","Shifts Per Week",null,"SUN","MON","TUES","WEDS","THUR","FRI","SAT",null,"REG","HOM               1.0 Pay"]
[{"$nulls":8},"Holiday","Holiday",null,null,null,"V"]
[]
[1,"8hr (5)",5,null,8,8,8,8,"8HOM","8HOM",8,null,40,16]
[1,"8hr (2) and 12hr (2)",4,null,8,12,8,12,"8HOM","12HOM",null,null,40,20]
[1,"10hr (4)",4,null,10,10,10,10,"10HOM","10HOM",null,null,40,20]
[]
[0.9,"12hr (3)",3,null,null,12,12,12,"12HOM","12HOM",null,null,36,24]
[0.9,"8hr (3) and  12hr (1)",4,null,8,8,8,12,"8HOM","8HOM",null,null,36,16]
[]
[0.8,"8hr (4)",4,null,8,8,8,8,"8HOM","8HOM",null,null,32,16]
[0.8,"8hr (1) and 12hr (2)",3,null,null,8,12,12,"8HOM","12HOM",null,null,32,20]
[]
[0.7,"8hr (2) and 12hr (1)",3,null,null,8,12,8,"8HOM","12HOM",null,null,28,20]
[0.7,"8hr (4) week 1                                       8 hr (3) week 2","4                                                            3",null,null,8,8,8,"8HOM","8HOM",null,null,24,16]
[]
[0.75,"12hr (2) week 1                            12hr (3) week 2","2                                    3",null,null,12,12,12,"12HOM","12HOM",null,null,36,24]
[]
[0.6,"8hr (3)",3,null,null,8,8,8,"8HOM","8HOM",null,null,24,16]
[0.6,"12 (2)",2,null,null,null,12,12,"12HOM","12HOM",null,null,24,24]
[]
[0.5,"8hr (1) and 12hr (1)",2,null,null,null,8,12,"8HOM","12HOM",null,null,20,20]
[0.5,"10hr (2)",2,null,null,null,10,10,"10HOM","10HOM",null,null,20,20]
[]
[0.4,"8 hr (2)",2,null,null,null,8,8,"8HOM","8HOM",null,null,16,16]
[]
[0.3,"12hr (1)",1,{"$nulls":4},12,"12HOM","12HOM",null,null,12,24]
[]
[0.2,"8hr (1)  ",1,{"$nulls":4},8,"8HOM","8HOM",null,null,8,16]
["Designation of 8hr or 12hr holidays are decided by the unit.  "]
["In addition to voluntary additional holiday off, if mandated off and volunteer to work full appt fraction, then straight PTO is an option."]
["The extra shift will be determined based upon unit need and discussion between the employee and the manager."]
["Employee may choose $$ for both holidays, PTO for both holidays, or 1 holiday $$ and 1 holiday PTO."]

{"sheet":"Addl Hol Off-Full-PTO","index":12,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,0,37,13],[35,0,35,13],[36,0,36,13],[0,0,0,13],[1,0,1,13],[2,0,2,13],[3,0,3,13],[4,0,4,13],[34,0,34,13]]}
["MNA THANKSGIVING HOLIDAY PAYROLL SCENARIOS"]
["Add'l Holiday Off - Offered and Accepted (Prescheduled) - Para. 355B"]
["Choosing PTO @ 1.0"]
["Must be Prescheduled to Work Full Appt."]
["Holiday PTO (HOP) does not count towards the calculation of OT"]
["FTE","Shift Lengths","Shifts Per Week",null,"SUN","MON","TUES","WEDS","THUR","FRI","SAT",null,"REG","HOP         1.0 PTO"]
[{"$nulls":8},"Holiday","Holiday",null,null,null,"Y"]
[]
[1,"8hr (5)",5,null,8,8,8,8,"8HOP","8HOP",8,null,40,16]
[1,"8hr (2) and 12hr (2)",4,null,8,12,8,12,"8HOP","12HOP",null,null,40,20]
[1,"10hr (4)",4,null,10,10,10,10,"10HOP","10HOP",null,null,40,20]
[]
[0.9,"12hr (3)",3,null,null,12,12,12,"12HOP","12HOP",null,null,36,24]
[0.9,"8hr (3) and  12hr (1)",4,null,8,8,8,12,"8HOP","8HOP",null,null,36,16]
[]
[0.8,"8hr (4)",4,null,8,8,8,8,"8HOP","8HOP",null,null,32,16]
[0.8,"8hr (1) and 12hr (2)",3,null,null,8,12,12,"8HOP","12HOP",null,null,32,20]
[]
[0.7,"8hr (2) and 12hr (1)",3,null,null,8,8,12,"8HOP","12HOP",null,null,28,20]
[0.7,"8hr (4) week 1                                       8 hr (3) week 2","4                                                            3",null,null,8,8,8,"8HOP","8HOP",null,null,24,16]
[]
[0.75,"12hr (2) week 1                            12hr (3) week 2","2                                    3",null,null,12,12,12,"12HOP","12HOP",null,null,36,24]
[]
[0.6,"8hr (3)",3,null,null,8,8,8,"8HOP","8HOP",null,null,24,16]
[0.6,"12 (2)",2,null,null,null,12,12,"12HOP","12HOP",null,null,24,24]
[]
[0.5,"8hr (1) and 12hr (1)",2,null,null,null,8,12,"8HOP","12HOP",null,null,20,20]
[0.5,"10hr (2)",2,null,null,null,10,10,"10HOP","10HOP",null,null,20,20]
[]
[0.4,"8 hr (2)",2,null,null,null,8,8,"8HOP","8HOP",null,null,16,16]
[]
[0.3,"12hr (1)",1,{"$nulls":4},12,"12HOP","12HOP",null,null,12,24]
[]
[0.2,"8hr (1)  ",1,{"$nulls":4},8,"8HOP","8HOP",null,null,8,16]
["Designation of 8hr or 12hr holidays are decided by the unit."]
["In addition to voluntary additional holiday off, if mandated off and volunteer to work full appt fraction, then straight PTO is an option."]
["The extra shift will be determined based upon unit need and discussion between the employee and the manager."]
["Employee may choose $$ for both holidays, PTO for both holidays, or 1 holiday $$ and 1 holiday PTO."]

{"sheet":"Thanksgiving Week Off-Ext. Sick","index":13,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,15],[1,0,1,15],[2,0,2,15],[3,0,3,15],[33,0,33,15]]}
["MNA THANKSGIVING HOLIDAY PAYROLL SCENARIOS"]
["Holiday Week Off/Ext. Sick"]
["(Thanksgiving)"]
["Holiday (HOL and HOM) does not count in the calculation of OT"]
["FTE","Shift Lengths","Shifts Per Week",null,"SUN","MON","TUES","WEDS","THUR","FRI","SAT",null,"ESF           1.0 Pay","HOL          1.0 Pay","HOM          1.0 Pay"]
[{"$nulls":8},"Holiday","Holiday",null,null,"e","H","V"]
[]
[1,"8hr (5)",5,null,null,8,8,8,"8 HOL","8 HOL",null,null,24,16]
[1,"8hr (2) and 12hr (2)",4,null,null,8,8,8,"8 HOL","8 HOL",null,null,24,16]
[1,"10hr (4)",4,null,null,6.66,6.67,6.67,"10 HOL","10 HOL",null,null,20,20]
[]
[0.9,"12hr (3)",3,null,null,4,4,4,"12 HOL","12 HOL",null,null,12,24]
[0.9,"8hr (3) and  12hr (1)",4,null,null,5.33,5.33,5.34,"8 HOL","12 HOL",null,null,16,20]
[]
[0.8,"8hr (4)",4,null,null,5.33,5.33,5.34,"8 HOL","8 HOL",null,null,16,16]
[0.8,"8hr (1) and 12hr (2)",3,null,null,4,4,4,"8 HOL","12 HOL",null,null,12,20]
[]
[0.75,"12hr (2) week 1                               12hr (3) week 2","2                                                                   3 (holiday falls in wk 2)",null,null,4,4,4,"12 HOL","12 HOL",null,null,12,24]
[]
[0.7,"8hr (2) and 12hr (1)",3,null,null,2.66,2.67,2.67,"8 HOL","12 HOL",null,null,8,20]
[0.7,"8hr (4) week 1                                       8 hr (3) week 2","4                                                            3 (holiday falls in wk 2)",null,null,2.66,2.67,2.67,"8 HOL","8 HOL",null,null,8,16]
[]
[0.6,"8hr (3)",3,null,null,2.66,2.67,2.67,"8 HOL","8 HOL",null,null,8,16]
[0.6,"12 (2)",2,{"$nulls":5},"12 HOL","12 HOL",null,null,0,24]
[]
[0.5,"8hr (1) and 12hr (1)",2,{"$nulls":5},"8 HOL","12 HOL",null,null,0,20]
[0.5,"10hr (2)",2,{"$nulls":5},"10 HOL","10 HOL",null,null,0,20]
[]
[0.4,"8 hr (2)",2,{"$nulls":5},"8 HOL","8 HOL",null,null,0,16]
[]
[0.3,"12hr (1)",1,{"$nulls":5},"12 HOL","12HOM",null,null,0,12,12]
[]
[0.2,"8hr (1)  ",1,{"$nulls":5},"8 HOL","8 HOM",null,null,0,8,8]
["Designation of 8hr or 12hr holidays are decided by the unit."]