{"text_format":"2","workbook":"xlsx","n_sheets":24,"sheets":["Key","Guidelines","Trigger Coding","Holiday Incentives","Shift Premium","Memorial Day,July4,LaborDay On","Christmas Holiday On","Hol on-Picks up Xtra After Schd","Holiday Off-Not Full Appt","Holiday Off-Full Appt-$$","Holiday Off-Full Appt-PTO","Addl Hol Off-Full-$$","Addl Hol Off-Full-PTO","Hol Off-Full-$$-Called In","Hol Off-Full-PTO-Called In","Addl Hol Off-Full-$-Called In","Addl Hol Off-Full-PTO-Called In","Holiday Off-Full-$$-Downstaffed","Holiday Off-Full-PTO-Downstaffd","Addl Hol Off-Full-$$-Downstaffd","Addl Hol Off-Full-PTO-Downstaff","Hol Off-Full-$$-PkUp Hol","Hol Off-Full-PTO-PkUP Hol","Holiday Off - Ext Sick"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":25,"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":[[6,4,6,11],[0,0,0,11],[1,4,1,11],[3,4,3,11],[4,0,4,11],[5,4,5,11],[18,4,18,11],[7,4,7,11],[8,0,8,11],[9,4,9,11],[10,4,10,11],[11,4,11,11],[12,4,12,11],[13,0,13,11],[14,4,14,11],[15,4,15,11],[16,0,16,11],[17,4,17,11],[19,0,19,11],[20,4,20,11],[21,4,21,11],[22,0,22,11],[23,0,25,0],[23,1,25,1],[23,2,25,2],[23,3,25,3],[23,4,23,11],[24,4,24,11],[25,4,25,11],[26,0,26,11],[27,4,27,11],[28,4,28,11],[29,0,29,11],[31,4,31,11],[32,0,33,0],[32,1,33,1],[32,2,33,2],[32,3,33,3],[32,4,32,11],[33,4,33,11],[30,0,31,0],[30,1,31,1],[30,2,31,2],[30,3,31,3],[30,4,30,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],[38,0,38,11],[39,4,39,11],[40,4,40,11],[41,0,41,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]]}
["Key for MNA Non-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":"Memorial Day,July4,LaborDay On","index":5,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,0,14],[32,0,32,14],[9,0,9,14],[12,0,12,14],[15,0,15,14],[18,0,18,14],[20,0,20,14],[23,0,23,14],[26,0,26,14],[28,0,28,14],[30,0,30,14],[1,0,1,14],[2,0,2,14]]}
["MNA HOLIDAY PAYROLL SCENARIOS"]
["Holiday On/No Extra Hours"]
["(New Year's, Memorial Day, July 4th, Labor Day)"]
["FTE","Shift Lengths","Shifts Per Week",null,"SUN","MON","TUES","WEDS","THUR","FRI","SAT",null,"REG","HWT            1.5 Pay","HOL          1.0 Pay"]
[{"$nulls":10},"Holiday",null,null,"h","H"]
[]
[1,"8hr (5)",5,null,null,null,8,8,8,8,"8HOL 8HWT",null,32,8,8]
[1,"8hr (2) and 12hr (2)",4,{"$nulls":4},12,12,8,"8HOL 8HWT",null,32,8,8]
[1,"10hr (4)",4,{"$nulls":4},10,10,10,"10HOL 10HWT",null,30,10,10]
[]
[0.9,"12hr (3)",3,{"$nulls":5},12,12,"12HOL 12HWT",null,24,12,12]
[0.9,"8hr (3) and  12hr (1)",4,{"$nulls":4},12,8,8,"8HOL 8HWT",null,28,8,8]
[]
[0.8,"8hr (4)",4,{"$nulls":4},8,8,8,"8HOL 8HWT",null,24,8,8]
[0.8,"8hr (1) and 12hr (2)",3,{"$nulls":5},12,12,"8HOL 8HWT",null,24,8,8]
[]
[0.7,"8hr (2) and 12hr (1)",3,{"$nulls":5},12,8,"8HOL 8HWT",null,20,8,8]
[0.7,"8hr (4) week 1                                       8 hr (3) week 2","4                                                            3",{"$nulls":5},8,8,"8HOL 8HWT",null,16,8,8]
[]
[0.75,"12hr (2) week 1                               12hr (3) week 2","2                                                                   3",{"$nulls":5},12,12,"12HOL 12 HWT",null,24,12,12]
[]
[0.6,"8hr (3)",3,{"$nulls":5},8,8,"8HOL 8HWT",null,16,8,8]
[0.6,"12 (2)",2,{"$nulls":6},12,"12HOL 12HWT",null,12,12,12]
[]
[0.5,"8hr (1) and 12hr (1)",2,{"$nulls":6},8,"12HOL 12 HWT",null,8,12,12]
[0.5,"10hr (2)",2,{"$nulls":6},10,"10HOL 10HWT",null,10,10,10]
[]
[0.4,"8 hr (2)",2,{"$nulls":6},8,"8HOL 8HWT",null,8,8,8]
[]
[0.3,"12hr (1)",1,{"$nulls":7},"12HOL 12HWT",null,0,12,12]
[]
[0.2,"8hr (1)  ",1,{"$nulls":7},"8HOL 8HWT",null,0,8,8]
["Designation of 8hr or 12hr holidays are decided by the unit."]

{"sheet":"Christmas Holiday On","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,14],[10,0,10,14],[13,0,13,14],[16,0,16,14],[19,0,19,14],[21,0,21,14],[24,0,24,14],[27,0,27,14],[29,0,29,14],[31,0,31,14],[3,0,3,14]]}
["MNA HOLIDAY PAYROLL SCENARIOS"]
["Holiday On/No Extra Hours"]
["(Christmas)"]
["**For MNA Nurses working on 12/25 only - h will interface into Mpathways as HWT and a rule will flip it to HWD**"]
["FTE","Shift Lengths","Shifts Per Week",null,"SUN","MON","TUES","WEDS","THUR","FRI","SAT",null,"REG","HWD**           2.0 Pay","HOL          1.0 Pay"]
[{"$nulls":10},"Holiday",null,null,"h**","H"]
[]
[1,"8hr (5)",5,null,null,null,8,8,8,8,"8HOL 8HWD",null,32,8,8]
[1,"8hr (2) and 12hr (2)",4,{"$nulls":4},12,12,8,"8HOL 8HWD",null,32,8,8]
[1,"10hr (4)",4,{"$nulls":4},10,10,10,"10HOL 10HWD",null,30,10,10]
[]
[0.9,"12hr (3)",3,{"$nulls":5},12,12,"12HOL 12HWD",null,24,12,12]
[0.9,"8hr (3) and  12hr (1)",4,{"$nulls":4},12,8,8,"8HOL 8HWD",null,28,8,8]
[]
[0.8,"8hr (4)",4,{"$nulls":4},8,8,8,"8HOL 8HWD",null,24,8,8]
[0.8,"8hr (1) and 12hr (2)",3,{"$nulls":5},12,12,"8HOL 8HWD",null,24,8,8]
[]
[0.7,"8hr (2) and 12hr (1)",3,{"$nulls":5},12,8,"8HOL 8HWD",null,20,8,8]
[0.7,"8hr (4) week 1                                       8 hr (3) week 2","4                                                            3",{"$nulls":5},8,8,"8HOL 8HWD",null,16,8,8]
[]
[0.75,"12hr (2) week 1                               12hr (3) week 2","2                                                                   3",{"$nulls":5},12,12,"12HOL 12HWD",null,24,12,12]
[]
[0.6,"8hr (3)",3,{"$nulls":5},8,8,"8HOL 8HWD",null,16,8,8]
[0.6,"12 (2)",2,{"$nulls":6},12,"12HOL 12HWD",null,12,12,12]
[]
[0.5,"8hr (1) and 12hr (1)",2,{"$nulls":6},8,"12HOL 12HWD",null,8,12,12]
[0.5,"10hr (2)",2,{"$nulls":6},10,"10HOL 10HWD",null,10,10,10]
[]
[0.4,"8 hr (2)",2,{"$nulls":6},8,"8HOL 8HWD",null,8,8,8]
[]
[0.3,"12hr (1)",1,{"$nulls":7},"12HOL 12HWD",null,0,12,12]
[]
[0.2,"8hr (1)  ",1,{"$nulls":7},"8HOL 8HWD",null,0,8,8]
["Designation of 8hr or 12hr holidays are decided by the unit."]

{"sheet":"Hol on-Picks up Xtra After Schd","index":7,"n_rows":33,"n_cols":17,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,0,16],[2,0,2,16],[1,0,1,16],[32,0,32,16],[9,0,9,16],[12,0,12,16],[15,0,15,16],[18,0,18,16],[20,0,20,16],[23,0,23,16],[26,0,26,16],[28,0,28,16],[30,0,30,16]]}
["MNA HOLIDAY PAYROLL SCENARIOS"]
["Holiday On/Picks Up Extra Hours After the Schedule is Posted"]
["(New Year's, Memorial Day, July 4, Labor Day)"]
["FTE","Shift Lengths","Shifts Per Week",null,"SUN","MON","TUES","WEDS","THUR","FRI","SAT",null,"REG","HWT            1.5 Pay","HOL          1.0 Pay","OTR            1.0 Pay","OTP            1.5 Pay"]
[{"$nulls":10},"Holiday",null,null,"h","H","+","t"]
[]
[1,"8hr (5)",5,null,null,"8extra",8,8,8,8,"8HOL 8HWT",null,32,8,8,null,8]
[1,"8hr (2) and 12hr (2)",4,null,null,null,"12extra",12,12,8,"8HOL 8HWT",null,32,8,8,null,12]
[1,"10hr (4)",4,null,null,null,10,10,"10extra",10,"10HOL 10HWT",null,30,10,10,null,10]
[]
[0.9,"12hr (3)",3,{"$nulls":4},"8extra",12,12,"12HOL 12HWT",null,24,12,12,4,4]
[0.9,"8hr (3) and  12hr (1)",4,null,null,null,8,12,"8extra",8,"8HOL 8HWT",null,28,8,8,4,4]
[]
[0.8,"8hr (4)",4,null,null,null,"12extra",8,8,8,"8HOL 8HWT",null,24,8,8,8,4]
[0.8,"8hr (1) and 12hr (2)",3,{"$nulls":4},12,"12extra",12,"8HOL 8HWT",null,24,8,8,8,4]
[]
[0.7,"8hr (2) and 12hr (1)",3,{"$nulls":4},"12extra",12,8,"8HOL 8HWT",null,20,8,8,12]
[0.7,"8hr (4) week 1                                       8 hr (3) week 2","4                                                            3",{"$nulls":4},8,8,"8extra","8HOL 8HWT",null,16,8,8,8]
[]
[0.75,"12hr (2) week 1                               12hr (3) week 2","2                                                                   3",{"$nulls":4},"8extra",12,12,"12HOL 12HWT",null,24,12,12,4,4]
[]
[0.6,"8hr (3)",3,{"$nulls":4},"12extra",8,8,"8HOL 8HWT",null,16,8,8,12]
[0.6,"12 (2)",2,{"$nulls":5},12,"12extra","12HOL 12 HWT",null,12,12,12,12]
[]
[0.5,"8hr (1) and 12hr (1)",2,{"$nulls":5},"8extra",8,"12HOL 12 HWT",null,8,12,12,8]
[0.5,"10hr (2)",2,{"$nulls":5},10,"10extra","10HOL 10HWT",null,10,10,10,10]
[]
[0.4,"8 hr (2)",2,{"$nulls":5},"12extra",8,"8HOL 8HWT",null,8,8,8,12]
[]
[0.3,"12hr (1)",1,{"$nulls":6},"12extra","12HOL 12HWT",null,0,12,12,12]
[]
[0.2,"8hr (1)  ",1,{"$nulls":6},"8extra","8HOL 8HWT",null,0,8,8,8]
["Designation of 8hr and 12hr holidays are decided by the unit."]

{"sheet":"Holiday Off-Not Full Appt","index":8,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,13],[1,0,1,13],[31,0,31,13],[8,0,8,13],[11,0,11,13],[14,0,14,13],[17,0,17,13],[19,0,19,13],[22,0,22,13],[25,0,25,13],[27,0,27,13],[29,0,29,13]]}
["MNA HOLIDAY PAYROLL SCENARIOS"]
["Regular Holiday Off/Not Working Full Appt."]
["FTE","Shift Lengths","Shifts Per Week",null,"SUN","MON","TUES","WEDS","THUR","FRI","SAT",null,"REG","HOL                               1.0 Pay"]
[{"$nulls":10},"Holiday",null,null,"H "]
[]
[1,"8hr (5)",5,null,null,null,8,8,8,8,"8HOL",null,32,8]
[1,"8hr (2) and 12hr (2)",4,{"$nulls":4},12,12,8,"8HOL",null,32,8]
[1,"10hr (4)",4,{"$nulls":4},10,10,10,"10HOL",null,30,10]
[]
[0.9,"12hr (3)",3,{"$nulls":5},12,12,"12HOL",null,24,12]
[0.9,"8hr (3) and  12hr (1)",4,null,null,null," ",8,8,8,"12HOL",null,24,12]
[]
[0.8,"8hr (4)",4,{"$nulls":4},8,8,8,"8HOL",null,24,8]
[0.8,"8hr (1) and 12hr (2)",3,{"$nulls":5},12,12,"8HOL",null,24,8]
[]
[0.7,"8hr (2) and 12hr (1)",3,{"$nulls":5},12,8,"8HOL",null,20,8]
[0.7,"8hr (4) week 1                                       8 hr (3) week 2","4                                                            3",{"$nulls":5},8,8,"8HOL",null,16,8]
[]
[0.75,"12hr (2) week 1                            12hr (3) week 2","2                                    3",{"$nulls":5},12,12,"12HOL",null,24,12]
[]
[0.6,"8hr (3)",3,{"$nulls":5},8,8,"8HOL",null,16,8]
[0.6,"12 (2)",2,{"$nulls":6},12,"12HOL",null,12,12]
[]
[0.5,"8hr (1) and 12hr (1)",2,{"$nulls":6},12,"8HOL",null,12,8]
[0.5,"10hr (2)",2,{"$nulls":6},10,"10HOL",null,10,10]
[]
[0.4,"8 hr (2)",2,{"$nulls":6},8,"8HOL",null,8,8]
[]
[0.3,"12hr (1)",1,{"$nulls":7},"12HOL",null,null,12]
[]
[0.2,"8hr (1)  ",1,{"$nulls":7},"8HOL",null,null,8]
["Designation of 8hr or 12hr holidays are decided by the unit."]

{"sheet":"Holiday Off-Full Appt-$$","index":9,"n_rows":35,"n_cols":14,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,0,34,13],[6,3,6,11],[33,0,33,13],[0,0,0,13],[1,0,1,13],[2,0,2,13],[3,0,3,13]]}
["MNA 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":10},"Holiday",null,null,"V"]
[null,null,null,"* = designated extra shift (may be canceled but exempt from assigned OT)"]
[1,"8hr (5)",5,null,null,8,"8*",8,8,8,"8HOM",null,40,8]
[1,"8hr (2) and 12hr (2)",4,null,null," ",8,"8*",12,12,"12HOM",null,40,12]
[1,"10hr (4)",4,null,null,null,10,10,"10*",10,"10HOM",null,40,10]
[]
[0.9,"12hr (3)",3,{"$nulls":4},12,12,"12*","12HOM  ",null,36,12]
[0.9,"8hr (3) and  12hr (1)",4,null,null,null,"8*",8,8,12,"8HOM",null,36,8]
[]
[0.8,"8hr (4)",4,null,null,null,8,"8*",8,8,"8HOM",null,32,8]
[0.8,"8hr (1) and 12hr (2)",3,{"$nulls":4},8,"12*",12,"12HOM",null,32,12]
[]
[0.7,"8hr (2) and 12hr (1)",3,{"$nulls":4},8,8,"12*","8HOM",null,28,8]
[0.7,"8hr (4) week 1                                       8 hr (3) week 2","4                                                            3",{"$nulls":4},"8*",8,8,"8HOM",null,24,8]
[]
[0.75,"12hr (2) week 1                            12hr (3) week 2","2                                    3",{"$nulls":4},12,"12*",12,"12HOM",null,36,12]
[]
[0.6,"8hr (3)",3,{"$nulls":4},8,8,"8*","8HOM",null,24,8]
[0.6,"12 (2)",2,{"$nulls":5},"12*",12,"12HOM",null,24,12]
[]
[0.5,"8hr (1) and 12hr (1)",2,{"$nulls":5},8,"12*","8HOM",null,20,8]
[0.5,"10hr (2)",2,{"$nulls":5},"10*",10,"10HOM",null,20,10]
[]
[0.4,"8 hr (2)",2,{"$nulls":5},8,"8*","8HOM",null,16,8]
[]
[0.3,"12hr (1)",1,{"$nulls":6},"12*","12HOM",null,12,12]
[]
[0.2,"8hr (1)  ",1,{"$nulls":6},"8*","8HOM",null,8,8]
["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."]

{"sheet":"Holiday Off-Full Appt-PTO","index":10,"n_rows":35,"n_cols":14,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,0,13],[1,0,1,13],[33,0,33,13],[2,0,2,13],[34,0,34,13],[6,3,6,11],[3,0,3,13]]}
["MNA 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":10},"Holiday",null,null,"@"]
[null,null,null,"* = designated extra shift (may be canceled but exempt from assigned OT)"]
[1,"8hr (5)",5,null,null,"8*",8,8,8,8,"8HOR",null,40,8]
[1,"8hr (2) and 12hr (2)",4,null,null,null,"8*",8,12,12,"12HOR",null,40,12]
[1,"10hr (4)",4,null,null,null,10,"10*",10,10,"10HOR",null,40,10]
[]
[0.9,"12hr (3)",3,{"$nulls":4},12,"12*",12,"12HOR",null,36,12]
[0.9,"8hr (3) and  12hr (1)",4,null,null,null,8,8,8,"12*","8HOR",null,36,8]
[]
[0.8,"8hr (4)",4,null,null,null,"8*",8,8,8,"8HOR",null,32,8]
[0.8,"8hr (1) and 12hr (2)",3,{"$nulls":4},"8*",12,12,"12HOR",null,32,12]
[]
[0.7,"8hr (2) and 12hr (1)",3,{"$nulls":4},8,"8*",12,"8HOR",null,28,8]
[0.7,"8hr (4) week 1                                       8 hr (3) week 2","4                                                            3",{"$nulls":4},8,8,"8*","8HOR",null,24,8]
[]
[0.75,"12hr (2) week 1                            12hr (3) week 2","2                                    3",{"$nulls":4},"12*",12,12,"12HOR",null,36,12]
[]
[0.6,"8hr (3)",3,{"$nulls":4},8,"8*",8,"8HOR",null,24,8]
[0.6,"12 (2)",2,{"$nulls":5},12,"12*","12HOR",null,24,12]
[]
[0.5,"8hr (1) and 12hr (1)",2,{"$nulls":5},"8*",12,"8HOR",null,20,8]
[0.5,"10hr (2)",2,{"$nulls":5},10,"10*","10HOR",null,20,10]
[]
[0.4,"8 hr (2)",2,{"$nulls":5},"8*",8,"8HOR",null,16,8]
[]
[0.3,"12hr (1)",1,{"$nulls":6},"12*","12HOR",null,12,12]
[]
[0.2,"8hr (1)  ",1,{"$nulls":6},"8*","8HOR",null,8,8]
["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."]

{"sheet":"Addl Hol Off-Full-$$","index":11,"n_rows":37,"n_cols":14,"rows_kept":37,"cut":false,"hidden":false,"merged":[[34,0,34,13],[35,0,35,13],[37,0,37,13],[0,0,0,13],[1,0,1,13],[2,0,2,13],[3,0,3,13],[4,0,4,13],[36,0,36,13],[7,3,7,11]]}
["MNA 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":10},"Holiday",null,null,"V"]
[null,null,null,"* = designated extra shift (may be canceled but exempt from assigned OT)"]
[1,"8hr (5)",5,null,null,"8*",8,8,8,8,"8HOM",null,40,8]
[1,"8hr (2) and 12hr (2)",4,null,null,null,"8*",8,12,12,"12HOM",null,40,12]
[1,"10hr (4)",4,null,null,null,10,"10*",10,10,"10HOM",null,40,10]
[]
[0.9,"12hr (3)",3,{"$nulls":4},12,"12*",12,"12HOM",null,36,12]
[0.9,"8hr (3) and  12hr (1)",4,null,null,null,8,8,8,"12*","12HOM",null,36,12]
[]
[0.8,"8hr (4)",4,null,null,null,"8*",8,8,8,"8HOM",null,32,8]
[0.8,"8hr (1) and 12hr (2)",3,{"$nulls":4},"8*",12,12,"12HOM",null,32,12]
[]
[0.7,"8hr (2) and 12hr (1)",3,{"$nulls":4},8,"8*",12,"8HOM",null,28,8]
[0.7,"8hr (4) week 1                                       8 hr (3) week 2","4                                                            3",{"$nulls":4},8,8,"8*","8HOM",null,24,8]
[]
[0.75,"12hr (2) week 1                            12hr (3) week 2","2                                    3",{"$nulls":4},"12*",12,12,"12HOM",null,36,12]
[]
[0.6,"8hr (3)",3,{"$nulls":4},8,"8*",8,"8HOM",null,24,8]
[0.6,"12 (2)",2,{"$nulls":5},12,"12*","12HOM",null,24,12]
[]
[0.5,"8hr (1) and 12hr (1)",2,{"$nulls":5},"8*",12,"8HOM",null,20,8]
[0.5,"10hr (2)",2,{"$nulls":5},10,"10*","10HOM",null,20,10]
[]
[0.4,"8 hr (2)",2,{"$nulls":5},"8*",8,"8HOM",null,16,8]
[]
[0.3,"12hr (1)",1,{"$nulls":6},"12*","12HOM",null,12,12]
[]
[0.2,"8hr (1)  ",1,{"$nulls":6},"8*","8HOM",null,8,8]
["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."]

{"sheet":"Addl Hol Off-Full-PTO","index":12,"n_rows":37,"n_cols":14,"rows_kept":37,"cut":false,"hidden":false,"merged":[[34,0,34,13],[35,0,35,13],[37,0,37,13],[0,0,0,13],[1,0,1,13],[2,0,2,13],[3,0,3,13],[36,0,36,13],[7,3,7,11],[4,0,4,13]]}
["MNA 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":10},"Holiday",null,null,"Y"]
[null,null,null,"* = designated extra shift (may be canceled but exempt from assigned OT)"]
[1,"8hr (5)",5,null,null,"8*",8,8,8,8,"8HOP",null,40,8]
[1,"8hr (2) and 12hr (2)",4,null,null,null,"8*",8,12,12,"12HOP",null,40,12]
[1,"10hr (4)",4,null,null,null,10,"10*",10,10,"10HOP",null,40,10]
[]
[0.9,"12hr (3)",3,{"$nulls":4},12,"12*",12,"12HOP",null,36,12]
[0.9,"8hr (3) and  12hr (1)",4,null,null,null,8,8,8,"12*","8HOP",null,36,8]
[]
[0.8,"8hr (4)",4,null,null,null,"8*",8,8,8,"8HOP",null,32,8]
[0.8,"8hr (1) and 12hr (2)",3,{"$nulls":4},"8*",12,12,"12HOP",null,32,12]
[]
[0.7,"8hr (2) and 12hr (1)",3,{"$nulls":4},8,"8*",12,"8HOP",null,28,8]
[0.7,"8hr (4) week 1                                       8 hr (3) week 2","4                                                            3",{"$nulls":4},8,8,"8*","8HOP",null,24,8]
[]
[0.75,"12hr (2) week 1                            12hr (3) week 2","2                                    3",{"$nulls":4},"12*",12,12,"12HOP",null,36,12]
[]
[0.6,"8hr (3)",3,{"$nulls":4},8,"8*",8,"8HOP",null,24,8]
[0.6,"12 (2)",2,{"$nulls":5},12,"12*","12HOP",null,24,12]
[]
[0.5,"8hr (1) and 12hr (1)",2,{"$nulls":5},"8*",12,"8HOP",null,20,8]
[0.5,"10hr (2)",2,{"$nulls":5},10,"10*","10HOP",null,20,10]
[]
[0.4,"8 hr (2)",2,{"$nulls":5},"8*",8,"8HOP",null,16,8]
[]
[0.3,"12hr (1)",1,{"$nulls":6},"12*","12HOP",null,12,12]
[]
[0.2,"8hr (1)  ",1,{"$nulls":6},"8*","8HOP",null,8,8]
["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."]

{"sheet":"Hol Off-Full-$$-Called In","index":13,"n_rows":38,"n_cols":16,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,0,37,15],[35,0,35,15],[36,0,36,15],[0,0,0,15],[1,0,1,15],[2,0,2,15],[3,0,3,15],[4,0,4,15],[34,0,34,15],[7,3,7,11]]}
["MNA HOLIDAY PAYROLL SCENARIOS"]
["Regular Holiday Off/Working Full Appt. (Prescheduled) - Para. 355"]
["Choosing Holiday Pay (Cash)"]
["CALLED IN on either regular shift or designated extra shift"]
["Holiday (HOM or HOL) does not count towards the calculation of OT"]
["FTE","Shift Lengths","Shifts Per Week",null,"SUN","MON","TUES","WEDS","THUR","FRI","SAT",null,"REG","PTU          1.0 PTO ","HOM               1.0 Pay","HOL               1.0 Pay"]
[{"$nulls":10},"Holiday",null,null,"w","V","H"]
[null,null,null,"* = designated extra shift (may be canceled but exempt from assigned OT)"]
[1,"8hr (5)",5,null,null,"8*",8,8,8,"8    CALL IN","8HOM",null,32,8,8]
[1,"8hr (2) and 12hr (2)",4,null,null," ",8,"8*",12,"12    CALL IN","12H0M",null,28,12,12]
[1,"10hr (4)",4,null,null,null,10,10,10,"10*   CALL IN","10HOL",null,30,null,null,10]
[]
[0.9,"12hr (3)",3,{"$nulls":4},12,"12*","12    CALL IN","12H0M",null,24,12,12]
[0.9,"8hr (3) and  12hr (1)",4,null,null,null,8,8,8,"12*  CALL IN","12H0L",null,24,null,null,12]
[]
[0.8,"8hr (4)",4,null,null,null,8,"8*",8,"8    CALL IN","8HOM",null,24,8,8]
[0.8,"8hr (1) and 12hr (2)",3,{"$nulls":4},8,12,"12*  CALL IN","12H0L",null,20,null,null,12]
[]
[0.7,"8hr (2) and 12hr (1)",3,{"$nulls":4},8,"8*","12    CALL IN","12H0M",null,16,12,12]
[0.7,"8hr (4) week 1                                       8 hr (3) week 2","4                                                            3",{"$nulls":4},8,8,"8*    CALL IN","8HOL",null,16,null,null,8]
[]
[0.75,"12hr (2) week 1                            12hr (3) week 2","2                                    3",{"$nulls":4},"12*",12,"12    CALL IN","12H0M",null,24,12,12]
[]
[0.6,"8hr (3)",3,{"$nulls":4},8,"8*","8    CALL IN","8HOM",null,16,8,8]
[0.6,"12 (2)",2,{"$nulls":5},12,"12*  CALL IN","12H0L",null,12,null,null,12]
[]
[0.5,"8hr (1) and 12hr (1)",2,{"$nulls":5},"8*","12    CALL IN","12H0M",null,8,12,12]
[0.5,"10hr (2)",2,{"$nulls":5},10,"10*  CALL IN","10HOL",null,10,null,null,10]
[]
[0.4,"8 hr (2)",2,{"$nulls":5},"8*","8    CALL IN","8HOM",null,8,8,8]
[]
[0.3,"12hr (1)",1,{"$nulls":6},"12*  CALL IN","12H0L",null,0,null,null,12]
[]
[0.2,"8hr (1)  ",1,{"$nulls":6},"8    CALL IN","8HOM",null,0,8,8]
["To be eligible for Holiday pay employees must work their last scheduled work day prior to and"]
["the first scheduled work day following the holiday, unless the employee's absence is excused.  See paragraph 352."]
["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."]

{"sheet":"Hol Off-Full-PTO-Called In","index":14,"n_rows":38,"n_cols":17,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,0,37,16],[36,0,36,16],[0,0,0,16],[1,0,1,16],[2,0,2,16],[3,0,3,16],[34,0,34,16],[35,0,35,16],[7,3,7,11],[4,0,4,16]]}
["MNA HOLIDAY PAYROLL SCENARIOS"]
["Regular Holiday Off/Working Full Appt. (Prescheduled) - Para. 355"]
["Choosing Holiday PTO @ 1.5"]
["CALLED IN on either regular shift or designated extra shift"]
["Holiday (HOM or HOL) does not count towards the calculation of OT"]
["FTE","Shift Lengths","Shifts Per Week",null,"SUN","MON","TUES","WEDS","THUR","FRI","SAT",null,"REG","PTU          1.0 PTO ","HOM          1.0 Pay","HOL               1.0 Pay","HOR              1.5 PTO"]
[{"$nulls":10},"Holiday",null,null,"w","V","H","@"]
[null,null,null,"* = designated extra shift (may be canceled but exempt from assigned OT)"]
[1,"8hr (5)",5,null,null,"8*",8,8,8,"8    CALL IN","8HOM",null,32,8,8,null,"not eligible"]
[1,"8hr (2) and 12hr (2)",4,null,null," ",8,"8*",12,"12    CALL IN","8HOM",null,28,12,12,null,"not eligible"]
[1,"10hr (4)",4,null,null,null,10,10,10,"10*   CALL IN","10HOL",null,30,null,null,10,"not eligible"]
[]
[0.9,"12hr (3)",3,{"$nulls":4},12,"12*","12    CALL IN","12HOM",null,24,12,12,null,"not eligible"]
[0.9,"8hr (3) and  12hr (1)",4,null,null,null,8,8,8,"12*  CALL IN","12HOL",null,24,null,null,12,"not eligible"]
[]
[0.8,"8hr (4)",4,null,null,null,8,"8*",8,"8    CALL IN","8HOM",null,24,8,8,null,"not eligible"]
[0.8,"8hr (1) and 12hr (2)",3,{"$nulls":4},8,12,"12*  CALL IN","12HOL",null,20,null,null,12,"not eligible"]
[]
[0.7,"8hr (2) and 12hr (1)",3,{"$nulls":4},8,"8*","12    CALL IN","12HOM",null,16,12,12,null,"not eligible"]
[0.7,"8hr (4) week 1                                       8 hr (3) week 2","4                                                            3",{"$nulls":4},8,8,"8*   CALL IN","8HOL",null,16,null,null,8,"not eligible"]
[]
[0.75,"12hr (2) week 1                            12hr (3) week 2","2                                    3",{"$nulls":4},"12*",12,"12    CALL IN","12HOM",null,24,12,12,null,"not eligible"]
[]
[0.6,"8hr (3)",3,{"$nulls":4},8,"8*","8    CALL IN","8HOM",null,16,8,8,null,"not eligible"]
[0.6,"12 (2)",2,{"$nulls":5},12,"12*  CALL IN","12HOL",null,12,null,null,12,"not eligible"]
[]
[0.5,"8hr (1) and 12hr (1)",2,{"$nulls":5},"8*","12    CALL IN","12HOM",null,8,12,12,null,"not eligible"]
[0.5,"10hr (2)",2,{"$nulls":5},10,"10*  CALL IN","10HOL",null,10,null,null,10,"not eligible"]
[]
[0.4,"8 hr (2)",2,{"$nulls":5},"8*","8    CALL IN","8HOM",null,8,8,8,null,"not eligible"]
[]
[0.3,"12hr (1)",1,{"$nulls":6},"12*  CALL IN","12HOL",null,0,null,null,12,"not eligible"]
[]
[0.2,"8hr (1)  ",1,{"$nulls":6},"8    CALL IN","8HOM",null,0,8,8,null,"not eligible"]
["To be eligible for Holiday pay employees must work their last scheduled work day prior to and"]
["the first scheduled work day following the holiday, unless the employee's absence is excused.  See paragraph 352."]
["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."]

{"sheet":"Addl Hol Off-Full-$-Called In","index":15,"n_rows":40,"n_cols":16,"rows_kept":40,"cut":false,"hidden":false,"merged":[[39,0,39,15],[0,0,0,15],[1,0,1,15],[2,0,2,15],[3,0,3,15],[4,0,4,15],[5,0,5,15],[35,0,35,15],[36,0,36,15],[37,0,37,15],[38,0,38,15],[8,3,8,11]]}
["MNA HOLIDAY PAYROLL SCENARIOS"]
["Additional Holiday Off - Offered and Accepted (Prescheduled) - Para. 355B"]
["Choosing Holiday Pay"]
["Must be Prescheduled to Work Full Appt"]
["CALLED IN on either regular shift or designated extra shift"]
["Holiday (HOM or HOL) does not count towards the calculation of OT"]
["FTE","Shift Lengths","Shifts Per Week",null,"SUN","MON","TUES","WEDS","THUR","FRI","SAT",null,"REG","PTU          1.0 PTO ","HOM               1.0 Pay","HOL               1.0 Pay"]
[{"$nulls":10},"Holiday",null,null,"w","V","H "]
[null,null,null,"* = designated extra shift (may be canceled but exempt from assigned OT)"]
[1,"8hr (5)",5,null,null,8,"8*",8,8,"8     CALL IN","8HOM",null,32,8,8]
[1,"8hr (2) and 12hr (2)",4,null,null,null,8,8,12,"12* CALL IN","12HOL",null,28,null,null,12]
[1,"10hr (4)",4,null,null,null,10,"10*",10,"10   CALL IN","10HOM",null,30,10,10]
[]
[0.9,"12hr (3)",3,{"$nulls":4},12,12,"12* CALL IN","12HOL",null,24,null,null,12]
[0.9,"8hr (3) and  12hr (1)",4,null,null,null,"8*",8,8,"12   CALL IN","12HOM",null,24,12,12]
[]
[0.8,"8hr (4)",4,null,null,null,8,"8*",8,"8     CALL IN","8HOM",null,24,8,8]
[0.8,"8hr (1) and 12hr (2)",3,{"$nulls":4},8,12,"12* CALL IN","12HOL",null,20,null,null,12]
[]
[0.7,"8hr (2) and 12hr (1)",3,{"$nulls":4},8,"8*","12   CALL IN","12HOM",null,16,12,12]
[0.7,"8hr (4) week 1                                       8 hr (3) week 2","4                                                            3",{"$nulls":4},8,8,"8*   CALL IN","8HOL",null,16,null,null,8]
[]
[0.75,"12hr (2) week 1                            12hr (3) week 2","2                                    3",{"$nulls":4},"12*",12,"12   CALL IN","12HOM",null,24,12,12]
[]
[0.6,"8hr (3)",3,{"$nulls":4},8,"8*","8     CALL IN","8HOM",null,16,8,8]
[0.6,"12 (2)",2,{"$nulls":5},12,"12*  CALL IN","12HOL",null,12,null,null,12]
[]
[0.5,"8hr (1) and 12hr (1)",2,{"$nulls":5},"8*","12   CALL IN","12HOM",null,8,12,12]
[0.5,"10hr (2)",2,{"$nulls":5},10,"10*  CALL IN","10HOL",null,10,null,null,10]
[]
[0.4,"8 hr (2)",2,{"$nulls":5},"8*","8     CALL IN","8HOM",null,8,8,8]
[]
[0.3,"12hr (1)",1,{"$nulls":6},"12* CALL IN","12HOL",{"$nulls":4},12]
[]
[0.2,"8hr (1)  ",1,{"$nulls":6},"8*   CALL IN","8HOL",{"$nulls":4},8]
["To be eligible for Holiday pay employees must work their last scheduled work day prior to and"]
["the first scheduled work day following the holiday, unless the employee's absence is excused.  See paragraph 352."]
["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."]

{"sheet":"Addl Hol Off-Full-PTO-Called In","index":16,"n_rows":40,"n_cols":17,"rows_kept":40,"cut":false,"hidden":false,"merged":[[5,0,5,16],[0,0,0,16],[1,0,1,16],[2,0,2,16],[3,0,3,16],[4,0,4,16],[35,0,35,16],[8,3,8,11],[39,0,39,16],[36,0,36,16],[37,0,37,16],[38,0,38,16]]}
["MNA HOLIDAY PAYROLL SCENARIOS"]
["Additional Holiday Off - Offered and Accepted (Prescheduled) - Para. 355B"]
["Choosing Holiday PTO @ 1.0"]
["Must be Prescheduled to Work Full Appt"]
["CALLED IN on either regular shift or designated extra shift"]
["Holiday (HOM or HOL) not counted towards the calculation of OT"]
["FTE","Shift Lengths","Shifts Per Week",null,"SUN","MON","TUES","WEDS","THUR","FRI","SAT",null,"REG","PTU          1.0 PTO ","HOM               1.0 Pay","HOL               1.0 Pay","HOP               1.0 PTO"]
[{"$nulls":10},"Holiday",null,null,"w","V","H ","Y"]
[null,null,null,"* = designated extra shift (may be canceled but exempt from assigned OT)"]
[1,"8hr (5)",5,null,null,8,"8*",8,8,"8     CALL IN","8HOM",null,32,8,8,null,"not eligible"]
[1,"8hr (2) and 12hr (2)",4,null,null,null,8,8,12,"12*  CALL IN","12HOL",null,28,null,null,12,"not eligible"]
[1,"10hr (4)",4,null,null,null,10,"10*",10,"10   CALL IN","10HOM",null,30,10,10,null,"not eligible"]
[]
[0.9,"12hr (3)",3,{"$nulls":4},12,12,"12*  CALL IN","12HOL",null,24,null,null,12,"not eligible"]
[0.9,"8hr (3) and  12hr (1)",4,null,null,null,"8*",8,8,"12   CALL IN","12HOM",null,24,12,12,null,"not eligible"]
[]
[0.8,"8hr (4)",4,null,null,null,8,"8*",8,"8     CALL IN","8HOM",null,24,8,8,null,"not eligible"]
[0.8,"8hr (1) and 12hr (2)",3,{"$nulls":4},8,12,"12*  CALL IN","12HOL",null,20,null,null,12,"not eligible"]
[]
[0.7,"8hr (2) and 12hr (1)",3,{"$nulls":4},8,"8*","12   CALL IN","12HOM",null,16,12,12,null,"not eligible"]
[0.7,"8hr (4) week 1                                       8 hr (3) week 2","4                                                            3",{"$nulls":4},8,8,"8*    CALL IN","8HOL",null,16,null,null,8,"not eligible"]
[]
[0.75,"12hr (2) week 1                            12hr (3) week 2","2                                    3",{"$nulls":4},"12*",12,"12   CALL IN","12HOM",null,24,12,12,null,"not eligible"]
[]
[0.6,"8hr (3)",3,{"$nulls":4},8,"8*","8     CALL IN","8HOM",null,16,8,8,null,"not eligible"]
[0.6,"12 (2)",2,{"$nulls":5},12,"12*  CALL IN","12HOL",null,12,null,null,12,"not eligible"]
[]
[0.5,"8hr (1) and 12hr (1)",2,{"$nulls":5},"8*","12   CALL IN","12HOM",null,8,12,12,null,"not eligible"]
[0.5,"10hr (2)",2,{"$nulls":5},10,"10*  CALL IN","10HOL",null,10,null,null,10,"not eligible"]
[]
[0.4,"8 hr (2)",2,{"$nulls":5},"8*","8     CALL IN","8HOM",null,8,8,8,null,"not eligible"]
[]
[0.3,"12hr (1)",1,{"$nulls":6},"12*  CALL IN","12HOL",{"$nulls":4},12,"not eligible"]
[]
[0.2,"8hr (1)  ",1,{"$nulls":6},"8*    CALL IN","8HOL",{"$nulls":4},8,"not eligible"]
["To be eligible for Holiday pay employees must work their last scheduled work day prior to and"]
["the first scheduled work day following the holiday, unless the employee's absence is excused.  See paragraph 352."]
["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."]

{"sheet":"Holiday Off-Full-$$-Downstaffed","index":17,"n_rows":36,"n_cols":17,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,16],[4,0,4,16],[7,3,7,11],[35,0,35,16],[34,0,34,16],[3,0,3,16],[2,0,2,16],[1,0,1,16]]}
["MNA HOLIDAY PAYROLL SCENARIOS"]
["Regular Holiday Off/Working Full Appt. Only (Prescheduled) - Para. 355"]
["Choosing Holiday Pay"]
["DOWNSTAFFED (either PTO or No Pay) on regular shifts or CANCELED on designated extra shifts"]
["Holiday (HOM or HOL) does not counts towards the calculation of OT"]
["FTE","Shift Lengths","Shifts Per Week",null,"SUN","MON","TUES","WEDS","THUR","FRI","SAT",null,"REG","PTA          1.0 PTO ","VET          0.0 Pay","HOM                     1.0 Pay","HOL               1.0 Pay"]
[{"$nulls":10},"Holiday",null,null,"W","z","V","H "]
[null,null,null,"* = designated extra shift (may be canceled but exempt from assigned OT)"]
[1,"8hr (5)",5,null,null,8,"8*",8,8,"8 Downstaffed","8HOM",null,32,8,null,8]
[1,"8hr (2) and 12hr (2)",4,null,null," ",8,"8*",12,"12 Downstaffed","12HOM",null,28,null,12,12]
[1,"10hr (4)",4,null,null,null,10,10,10,"10*    Canceled","10HOL",null,30,null,null,null,10]
[]
[0.9,"12hr (3)",3,{"$nulls":4},"12*",12,"12 Downstaffed","12HOM",null,24,12,null,12]
[0.9,"8hr (3) and  12hr (1)",4,null,null,null,8,8,8,"12*     Canceled","12HOL",null,24,null,null,null,12]
[]
[0.8,"8hr (4)",4,null,null,null,"8*",8,8,"8 Downstaffed","8HOM",null,24,null,8,8]
[0.8,"8hr (1) and 12hr (2)",3,{"$nulls":4},8,12,"12*     Canceled","12HOL",null,20,null,null,null,12]
[]
[0.7,"8hr (2) and 12hr (1)",3,{"$nulls":4},8,"8*","12 Downstaffed","8HOM",null,16,12,null,8]
[0.7,"8hr (4) week 1                                       8 hr (3) week 2","4                                                            3",{"$nulls":4},8,8,"8*      Canceled","8HOL",null,16,null,null,null,8]
[]
[0.75,"12hr (2) week 1                            12hr (3) week 2","2                                    3",{"$nulls":4},"12*",12,"12 Downstaffed","12HOM",null,24,null,12,12]
[]
[0.6,"8hr (3)",3,{"$nulls":4},8,8,"8*      Canceled","8HOL",null,16,null,null,null,8]
[0.6,"12 (2)",2,{"$nulls":5},"12*","12 Downstaffed","12HOM",null,12,12,null,12]
[]
[0.5,"8hr (1) and 12hr (1)",2,{"$nulls":5},8,"12*     Canceled","12HOL",null,8,null,null,null,12]
[0.5,"10hr (2)",2,{"$nulls":5},"10*","10 Downstaffed","10HOM",null,10,null,10,10]
[]
[0.4,"8 hr (2)",2,{"$nulls":5},8,"8*      Canceled","8HOL",null,8,null,null,null,8]
[]
[0.3,"12hr (1)",1,{"$nulls":6},"12*     Canceled","12HOL",{"$nulls":5},12]
[]
[0.2,"8hr (1)  ",1,{"$nulls":6},"8*      Canceled","8HOL",{"$nulls":5},8]
["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."]

{"sheet":"Holiday Off-Full-PTO-Downstaffd","index":18,"n_rows":36,"n_cols":16,"rows_kept":36,"cut":false,"hidden":false,"merged":[[35,0,35,15],[7,3,7,11],[4,0,4,15],[0,0,0,15],[1,0,1,15],[2,0,2,15],[3,0,3,15],[34,0,34,15]]}
["MNA HOLIDAY PAYROLL SCENARIOS"]
["Regular Holiday Off/Working Full Appt. Only (Prescheduled) - Para. 355"]
["Choosing Holiday PTO @ 1.5"]
["DOWNSTAFFED (either PTO or No Pay) on regular shifts or CANCELED on designated extra shifts"]
["Holiday PTO (HOR) is not counted towards the calculation of OT"]
["FTE","Shift Lengths","Shifts Per Week",null,"SUN","MON","TUES","WEDS","THUR","FRI","SAT",null,"REG","PTA          1.0 PTO","VET          0.0 Pay","HOR          1.5 PTO"]
[{"$nulls":10},"Holiday",null,null,"W","z","@"]
[null,null,null,"* = designated extra shift (may be canceled but exempt from assigned OT)"]
[1,"8hr (5)",5,null,null,8,"8*",8,8,"8 Downstaffed","8HOR",null,32,8,null,8]
[1,"8hr (2) and 12hr (2)",4,null,null," ",8,"8*",12,"12 Downstaffed","12HOR",null,28,null,12,12]
[1,"10hr (4)",4,null,null,null,10,10,10,"10*     Canceled","10HOR",null,30,null,null,10]
[]
[0.9,"12hr (3)",3,{"$nulls":4},"12*",12,"12 Downstaffed","12HOR",null,24,null,12,12]
[0.9,"8hr (3) and  12hr (1)",4,null,null,null,8,8,8,"12*     Canceled","8HOR",null,24,null,null,8]
[]
[0.8,"8hr (4)",4,null,null,null,"8*",8,8,"8 Downstaffed","8HOR",null,24,8,null,8]
[0.8,"8hr (1) and 12hr (2)",3,{"$nulls":4},8,12,"12*     Canceled","12HOR",null,20,null,null,12]
[]
[0.7,"8hr (2) and 12hr (1)",3,{"$nulls":4},8,"8*","12 Downstaffed","8HOR",null,16,12,null,8]
[0.7,"8hr (4) week 1                                       8 hr (3) week 2","4                                                            3",{"$nulls":4},8,8,"8*     Canceled","8HOR",null,16,null,null,8]
[]
[0.75,"12hr (2) week 1                            12hr (3) week 2","2                                    3",{"$nulls":4},"12*",12,"12 Downstaffed","12HOR",null,24,12,null,12]
[]
[0.6,"8hr (3)",3,{"$nulls":4},8,8,"8*     Canceled","8HOR",null,16,null,null,8]
[0.6,"12 (2)",2,{"$nulls":5},"12*","12 Downstaffed","12HOR",null,12,12,null,12]
[]
[0.5,"8hr (1) and 12hr (1)",2,{"$nulls":5},8,"12*     Canceled","12HOR",null,8,null,null,12]
[0.5,"10hr (2)",2,{"$nulls":5},"10*","10 Downstaffed","10HOR",null,10,10,null,10]
[]
[0.4,"8 hr (2)",2,{"$nulls":5},8,"8*     Canceled","8HOR",null,8,null,null,8]
[]
[0.3,"12hr (1)",1,{"$nulls":6},"12*     Canceled","12HOR",{"$nulls":4},12]
[]
[0.2,"8hr (1)  ",1,{"$nulls":6},"8*     Canceled","8HOR",{"$nulls":4},8]
["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."]

{"sheet":"Addl Hol Off-Full-$$-Downstaffd","index":19,"n_rows":38,"n_cols":17,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,0,16],[2,0,2,16],[3,0,3,16],[37,0,37,16],[4,0,4,16],[35,0,35,16],[36,0,36,16],[5,0,5,16],[1,0,1,16],[8,3,8,11]]}
["MNA HOLIDAY PAYROLL SCENARIOS"]
["Additional Holiday Off - Offered and Accepted (Prescheduled) - Para. 355B"]
["Choosing Holiday Pay"]
["Prescheduled to Work Full Appt"]
["DOWNSTAFFED (either PTO or No Pay) on regular shifts or CANCELED on designated extra shifts"]
["Holiday (HOM or HOL) does not count towards the calculation of OT"]
["FTE","Shift Lengths","Shifts Per Week",null,"SUN","MON","TUES","WEDS","THUR","FRI","SAT",null,"REG","PTA          1.0 PTO ","VET          0.0 Pay ","HOM                      1.0 Pay","HOL                      1.0 Pay"]
[{"$nulls":10},"Holiday",null,null,"W","z","V","H"]
[null,null,null,"* = designated extra shift (may be canceled but exempt from assigned OT)"]
[1,"8hr (5)",5,null,null,"8*",8,8,8,"8 Downstaffed","8HOM",null,32,8,null,8]
[1,"8hr (2) and 12hr (2)",4,null,null,null,"8*",8,12,"12 Downstaffed","12HOM",null,28,null,12,12]
[1,"10hr (4)",4,null,null,null,10,"10*",10,"10 Downstaffed","10HOM",null,30,10,null,10]
[]
[0.9,"12hr (3)",3,{"$nulls":4},12,"12*","12 Downstaffed","12HOM",null,24,null,12,12]
[0.9,"8hr (3) and  12hr (1)",4,null,null,null,8,8,8,"12*    Canceled","12HOL",null,24,null,null,null,12]
[]
[0.8,"8hr (4)",4,null,null,null,"8*",8,8,"8 Downstaffed","8HOM",null,24,8,null,8]
[0.8,"8hr (1) and 12hr (2)",3,{"$nulls":4},"8*",12,"12 Downstaffed","12HOM",null,20,null,12,12]
[]
[0.7,"8hr (2) and 12hr (1)",3,{"$nulls":4},8,"8*","12 Downstaffed","8HOM",null,16,12,null,8]
[0.7,"8hr (4) week 1                                       8 hr (3) week 2","4                                                            3",{"$nulls":4},8,8,"8*      Canceled","8HOL",null,16,null,null,null,8]
[]
[0.75,"12hr (2) week 1                            12hr (3) week 2","2                                    3",{"$nulls":4},"12*",12,"12 Downstaffed","12HOM",null,24,null,12,12]
[]
[0.6,"8hr (3)",3,{"$nulls":4},8,"8*","8 Downstaffed","8HOM",null,16,8,null,8]
[0.6,"12 (2)",2,{"$nulls":5},12,"12*    Canceled","12HOL",null,12,null,null,null,12]
[]
[0.5,"8hr (1) and 12hr (1)",2,{"$nulls":5},"8*","12 Downstaffed","12HOM",null,8,null,12,12]
[0.5,"10hr (2)",2,{"$nulls":5},10,"10*    Canceled","10HOL",null,10,null,null,null,10]
[]
[0.4,"8 hr (2)",2,{"$nulls":5},"8*","8 Downstaffed","8HOM",null,8,8,null,8]
[]
[0.3,"12hr (1)",1,{"$nulls":6},"12*    Canceled","12HOL",{"$nulls":5},12]
[]
[0.2,"8hr (1)  ",1,{"$nulls":6},"8*      Canceled","8HOL",{"$nulls":5},8]
["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."]

{"sheet":"Addl Hol Off-Full-PTO-Downstaff","index":20,"n_rows":38,"n_cols":16,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,0,37,15],[36,0,36,15],[0,0,0,15],[1,0,1,15],[2,0,2,15],[4,0,4,15],[35,0,35,15],[8,3,8,11],[3,0,3,15],[5,0,5,15]]}
["MNA HOLIDAY PAYROLL SCENARIOS"]
["Additional Holiday Off - Offered and Accepted (Prescheduled) - Para. 355B"]
["Choosing Holiday PTO @ 1.0"]
["Prescheduled to Work Full Appt"]
["DOWNSTAFFED (either PTO or No Pay) on regular shifts or CANCELED on designated extra shifts"]
["Holiday PTO (HOP) is not counted towards the calculation of OT"]
["FTE","Shift Lengths","Shifts Per Week",null,"SUN","MON","TUES","WEDS","THUR","FRI","SAT",null,"REG","PTA        1.0 PTO","VET         0.0 Pay","HOP         1.0 PTO"]
[{"$nulls":10},"Holiday",null,null,"W","z","Y"]
[null,null,null,"* = designated extra shift (may be canceled but exempt from assigned OT)"]
[1,"8hr (5)",5,null,null,"8*",8,8,8,"8    Downstaffed","8HOP",null,32,8,null,8]
[1,"8hr (2) and 12hr (2)",4,null,null,null,"8*",8,12,"12 Downstaffed","12HOP",null,28,null,12,12]
[1,"10hr (4)",4,null,null,null,10,"10*",10,"10 Downstaffed","10HOP",null,30,10,null,10]
[]
[0.9,"12hr (3)",3,{"$nulls":4},12,"12*","12 Downstaffed","12HOP",null,24,null,12,12]
[0.9,"8hr (3) and  12hr (1)",4,null,null,null,8,8,8,"12*      Canceled","12HOP",null,24,null,null,12]
[]
[0.8,"8hr (4)",4,null,null,null,"8*",8,8,"8    Downstaffed","8HOP",null,24,8,null,8]
[0.8,"8hr (1) and 12hr (2)",3,{"$nulls":4},"8*",12,"12 Downstaffed","12HOP",null,20,null,12,12]
[]
[0.7,"8hr (2) and 12hr (1)",3,{"$nulls":4},8,"8*","12 Downstaffed","8HOP",null,16,12,null,8]
[0.7,"8hr (4) week 1                                       8 hr (3) week 2","4                                                            3",{"$nulls":4},8,8,"8*        Canceled","8HOP",null,16,null,null,8]
[]
[0.75,"12hr (2) week 1                            12hr (3) week 2","2                                    3",{"$nulls":4},"12*",12,"12 Downstaffed","12HOP",null,24,null,12,12]
[]
[0.6,"8hr (3)",3,{"$nulls":4},8,"8*","8    Downstaffed","8HOP",null,16,8,null,8]
[0.6,"12 (2)",2,{"$nulls":5},12,"12*      Canceled","12HOP",null,12,null,null,12]
[]
[0.5,"8hr (1) and 12hr (1)",2,{"$nulls":5},"8*","12 Downstaffed","12HOP",null,8,null,12,12]
[0.5,"10hr (2)",2,{"$nulls":5},10,"10*      Canceled","10HOP",null,10,null,null,10]
[]
[0.4,"8 hr (2)",2,{"$nulls":5},"8*","8    Downstaffed","8HOP",null,8,8,null,8]
[]
[0.3,"12hr (1)",1,{"$nulls":6},"12*      Canceled","12HOP",{"$nulls":4},12]
[]
[0.2,"8hr (1)  ",1,{"$nulls":6},"8*        Canceled","8HOP",{"$nulls":4},8]
["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."]

{"sheet":"Hol Off-Full-$$-PkUp Hol","index":21,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[[36,0,36,15],[35,0,35,15],[4,0,4,15],[0,0,0,15],[1,0,1,15],[2,0,2,15],[3,0,3,15],[8,3,8,11],[5,0,5,15]]}
["MNA HOLIDAY PAYROLL SCENARIOS"]
["Regular Holiday Off/Working Full Appt. Only (Prescheduled) - Para. 355"]
["Choosing Holiday Pay (Cash)"]
["Picks up the holiday AFTER schedule development - (Open Unit shift or for Another Employee)"]
["Holiday (HOM) does not count towards OT"]
["Hours worked on the Holiday do 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","HWT            1.5 Pay","OTH            0.5 Pay"]
[{"$nulls":10},"Holiday",null,null,"V","h","manual entry"]
[null,null,null,"* = designated extra shift (may be canceled but exempt from assigned OT)"]
[1,"8hr (5)",5,null,null,"8*",8,8,8,8,"8HOM 8HWT",null,40,8,8,8]
[1,"8hr (2) and 12hr (2)",4,null,null," ",8,"8*",12,12,"8HOM  8HWT",null,40,8,8,8]
[1,"10hr (4)",4,null,null,null,10,10,10,"10*","10HOM  10HWT",null,40,10,10,10]
[]
[0.9,"12hr (3)",3,{"$nulls":4},"12*",12,12,"12HOM    12HWT",null,36,12,12,8]
[0.9,"8hr (3) and  12hr (1)",4,null,null,null,8,8,8,"12*","8HOM   8HWT",null,36,8,8,4]
[]
[0.8,"8hr (4)",4,null,null,null,"8*",8,8,8,"8HOM  8HWT",null,32,8,8]
[0.8,"8hr (1) and 12hr (2)",3,{"$nulls":4},8,"12*",12,"8HOM  8HWT",null,32,8,8]
[]
[0.7,"8hr (2) and 12hr (1)",3,{"$nulls":4},8,8,"12*","8HOM  8HWT",null,28,8,8]
[0.7,"8hr (4) week 1                                       8 hr (3) week 2","4                                                            3",{"$nulls":4},"8*",8,8,"8HOM  8HWT",null,24,8,8]
[]
[0.75,"12hr (2) week 1                            12hr (3) week 2","2                                    3",{"$nulls":4},12,"12*",12,"12HOM   12HWT",null,36,12,12,8]
[]
[0.6,"8hr (3)",3,{"$nulls":4},8,8,"8*","8HOM  8HWT",null,24,8,8]
[0.6,"12 (2)",2,{"$nulls":5},"12*",12,"12HOM  12HWT",null,24,12,12]
[]
[0.5,"8hr (1) and 12hr (1)",2,{"$nulls":5},8,"12*","8HOM  8HWT",null,20,8,8]
[0.5,"10hr (2)",2,{"$nulls":5},"10*",10,"10HOM  10HWT",null,20,10,10]
[]
[0.4,"8 hr (2)",2,{"$nulls":5},8,"8*","8HOM  8HWT",null,16,8,8]
[]
[0.3,"12hr (1)",1,{"$nulls":6},"12*","12HOM  12HWT",null,12,12,12]
[]
[0.2,"8hr (1)  ",1,{"$nulls":6},"8*","8HOM  8HWT",null,8,8,8]
["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."]

{"sheet":"Hol Off-Full-PTO-PkUP Hol","index":22,"n_rows":37,"n_cols":17,"rows_kept":37,"cut":false,"hidden":false,"merged":[[36,0,36,16],[35,0,35,16],[4,0,4,16],[1,0,1,16],[0,0,0,16],[2,0,2,16],[3,0,3,16],[8,3,8,11],[5,0,5,16]]}
["MNA HOLIDAY PAYROLL SCENARIOS"]
["Regular Holiday Off/Working Full Appt. Only (Prescheduled) - Para. 355"]
["Choosing Holiday PTO @ 1.5"]
["Picks up the holiday AFTER schedule development - (Open Unit shift or for Another Employee)"]
["Holiday (HOM) does not count towards OT"]
["Hours worked on the holiday do 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","HWT            1.5 Pay","OTH            0.5 Pay","HOR          1.5 PTO"]
[{"$nulls":10},"Holiday",null,null,"V","h","manual entry","@"]
[null,null,null,"* = designated extra shift (may be canceled but exempt from assigned OT)"]
[1,"8hr (5)",5,null,null,"8*",8,8,8,8,"8HOM 8HWT",null,40,8,8,8,"not elig."]
[1,"8hr (2) and 12hr (2)",4,null,null," ",8,"8*",12,12,"8HOM  8HWT",null,40,8,8,8,"not elig."]
[1,"10hr (4)",4,null,null,null,10,10,10,"10*","10HOM  10HWT",null,40,10,10,10,"not elig."]
[]
[0.9,"12hr (3)",3,{"$nulls":4},"12*",12,12,"12HOM    12HWT",null,36,12,12,8,"not elig."]
[0.9,"8hr (3) and  12hr (1)",4,null,null,null,8,8,8,"12*","8HOM   8HWT",null,36,8,8,4,"not elig."]
[]
[0.8,"8hr (4)",4,null,null,null,"8*",8,8,8,"8HOM  8HWT",null,32,8,8,null,"not elig."]
[0.8,"8hr (1) and 12hr (2)",3,{"$nulls":4},8,"12*",12,"8HOM  8HWT",null,32,8,8,null,"not elig."]
[]
[0.7,"8hr (2) and 12hr (1)",3,{"$nulls":4},8,8,"12*","8HOM  8HWT",null,28,8,8,null,"not elig."]
[0.7,"8hr (4) week 1                                       8 hr (3) week 2","4                                                            3",{"$nulls":4},"8*",8,8,"8HOM  8HWT",null,24,8,8,null,"not elig."]
[]
[0.75,"12hr (2) week 1                            12hr (3) week 2","2                                    3",{"$nulls":4},12,"12*",12,"12HOM   12HWT",null,36,12,12,8,"not elig."]
[]
[0.6,"8hr (3)",3,{"$nulls":4},8,8,"8*","8HOM  8HWT",null,24,8,8,null,"not elig."]
[0.6,"12 (2)",2,{"$nulls":5},"12*",12,"12HOM  12HWT",null,24,12,12,null,"not elig."]
[]
[0.5,"8hr (1) and 12hr (1)",2,{"$nulls":5},8,"12*","8HOM  8HWT",null,20,8,8,null,"not elig."]
[0.5,"10hr (2)",2,{"$nulls":5},"10*",10,"10HOM  10HWT",null,20,10,10,null,"not elig."]
[]
[0.4,"8 hr (2)",2,{"$nulls":5},8,"8*","8HOM  8HWT",null,16,8,8,null,"not elig."]
[]
[0.3,"12hr (1)",1,{"$nulls":6},"12*","12HOM  12HWT",null,12,12,12,null,"not elig."]
[]
[0.2,"8hr (1)  ",1,{"$nulls":6},"8*","8HOM  8HWT",null,8,8,8,null,"not elig."]
["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."]

{"sheet":"Holiday Off - Ext Sick","index":23,"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 HOLIDAY PAYROLL SCENARIOS"]
["Holiday Week Off/Ext. Sick"]
["(Non-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":9},"Holiday",null,null,"e","H","V"]
[]
[1,"8hr (5)",5,null,null,8,8,8,8,"8 HOL",null,null,24,16]
[1,"8hr (2) and 12hr (2)",4,null,null,8,8,8,8,"8 HOL",null,null,24,16]
[1,"10hr (4)",4,null,null,7.5,7.5,7.5,7.5,"10 HOL",null,null,30,10]
[]
[0.9,"12hr (3)",3,null,null,6,6,6,6,"12 HOL",null,null,24,12]
[0.9,"8hr (3) and  12hr (1)",4,null,null,7,7,7,7,"8 HOL",null,null,28,8]
[]
[0.8,"8hr (4)",4,null,null,6,6,6,6,"8 HOL",null,null,24,8]
[0.8,"8hr (1) and 12hr (2)",3,null,null,5,5,5,5,"12 HOL",null,null,20,12]
[]
[0.75,"12hr (2) week 1                               12hr (3) week 2","2                                                                   3 (holiday falls in wk 2)",null,null,4.5,4.5,4.5,4.5,"12 HOL",null,null,18,12]
[]
[0.7,"8hr (2) and 12hr (1)",3,null,null,4,4,4,4,"12 HOL",null,null,16,12]
[0.7,"8hr (4) week 1                                       8 hr (3) week 2","4                                                            3 (holiday falls in wk 2)",null,null,5,5,5,5,"8 HOL",null,null,20,8]
[]
[0.6,"8hr (3)",3,null,null,4,4,4,4,"8 HOL",null,null,16,8]
[0.6,"12 (2)",2,null,null,3,3,3,3,"12 HOL",null,null,12,12]
[]
[0.5,"8hr (1) and 12hr (1)",2,null,null,2,2,2,2,"12 HOL",null,null,8,12]
[0.5,"10hr (2)",2,null,null,2.5,2.5,2.5,2.5,"10 HOL",null,null,10,10]
[]
[0.4,"8 hr (2)",2,null,null,2,2,2,2,"8 HOL",null,null,8,8]
[]
[0.3,"12hr (1)",1,{"$nulls":6},"12 HOL",null,null,0,12]
[]
[0.2,"8hr (1)  ",1,{"$nulls":6},"8 HOL",null,null,0,8]
["Designation of 8hr or 12hr holidays are decided by the unit."]