{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Reduced Hours Report","Validations"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":11,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Reduced Hours Report","index":0,"n_rows":55,"n_cols":13,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,0,0,12],[14,1,14,12],[22,6,22,7],[7,1,7,12],[10,1,10,12],[8,1,8,12],[20,2,20,4],[12,1,12,12],[5,1,5,12],[6,1,6,12],[13,1,13,12],[9,1,9,12],[11,1,11,12],[54,0,54,12],[52,0,52,12],[40,2,40,12],[30,1,31,1],[35,11,35,12],[53,0,53,12],[42,0,42,12],[46,0,46,12],[32,10,33,12],[35,1,36,1],[27,8,27,9],[20,11,20,12],[16,0,16,12],[18,2,18,4],[18,7,18,9],[27,5,27,6],[20,6,20,9],[22,2,22,4]]}
["                                                       2023 REDUCED HOURS REPORT (RHR) for Individual Stipend Participants"]
[null,"All Regions - report Stipend Hours via the BEN code (TIME system) or Ben Hudnall Memorial Trust code (HRconnect)"]
[null,"ONLY use this RHR form for reporting  missing/unpaid stipend time from previous pay periods.  "]
[]
["Instructions (to be completed in Excel and submitted by fax by the Monday following the end of the pay period.  Handwritten RHRs will not be processed)"]
["1.","Enter your last and first name, and middle initial"]
["2.","Enter your employee number (as shown on your KP paystub.  Do not provide your NUID), preferred email address and daytime phone number."]
["3.","Select your KP region from the drop down list. (Note that SCal has two options depending on the start day of each pay period, Sunday or Monday)"]
["4.","Select the beginning date of the pay period from the drop down list. (Dates will not appear if you haven't selected the region)"]
["5.","Enter the Stipend Hours (hours not worked due to education and training reduction) under the appropriate day. Round to the nearest half hour.  Do not enter work hours or schedule here.   Do not report more than the maximum approved number of weekly stipend hours, even if more hours have been reduced for education and training.   If you work 10 or 12 hours shifts, you may change the Max. Approved Hrs/Wk, but don't report more than 16 stipend hours for the pay period.  Enter a comment about your schedule."]
["6.","Enter the KP Paid Hours under the appropriate day, including regular, OT, vacation, sick, PTO, jury duty, paid leave, etc.  Round to the nearest half hour.  Do not enter stipend hours here."]
["7.","Provide comments if appropriate."]
["8.","Print out the document, read the verification statement, then sign and date it, and obtain your manager's signature and date.  Also print the signer's name, phone number and email."]
["9.","E-mail the completed and signed Reduced Hours Report to BHMT Accounting at: LMP-Careers@kp.org.  Upon receipt, payment will be processed in the next check run."]
["10.","Please do not call or email for receipt confirmation.  Keep the original RHR for your records."]
[]
["Use the Tab keys to move between input cells"]
[]
[null,"Last Name:","Enter Here",null,null,null,"First Name:","Enter Here",null,null,null,"Middle Initial:","Enter Here"]
[]
[null,"Employee # (not NUID): ","Enter Here",null,null,"Email:","Enter Here",null,null,null,"Phone:","Enter Here"]
[]
[null,"Region:",null,null,null,"System:",{"$f":"IF(C23=0,\" \",VLOOKUP(C23,Validations!A5:C15,2,FALSE))","v":" "},null,null,null,"Pay Schedule:",{"$f":"IF(C23=0,\" \",VLOOKUP(C23,Validations!A5:C15,3,FALSE))","v":" "}]
[null,null,"Select from dropdown list"]
[null,null,"Choose SCAL based on start date of pay period"]
["KP Pay Period"]
[]
[null,null,"Max. Approved Hrs/Wk:",8,"From:",null,null,"To:",{"$f":"IF(F28=0,\" \",F28+13)","v":" "},null,null,"KP Pay Date:",{"$f":"IF(ISERROR(IF(L23=\"B\",I28+5,IF(OR(L23=\"A\",L23=\"D\"),I28+6,\" \"))),\"\",IF(L23=\"B\",I28+5,IF(OR(L23=\"A\",L23=\"D\"),I28+6,\" \")))","v":" "}]
[null,null,null,null,null,"Select from dropdown list"]
[]
[null,"Week 1",{"$f":"IF($F$28=0,\" \",F28)","v":" "},{"$f":"IF($F$28=0,\" \",C31+1)","v":" "}," "," "," "," "," "]
[null,null,{"$f":"C31","v":" "}," "," "," "," "," "," ","Total"]
[null,"Enter Stipend Hours",null,null,null,null,null,null,null,{"$f":"IF(SUM(C33:I33)>D28,\"Exceeds Max\",SUM(C33:I33))","v":0}," (Round Stipend and KP Paid Hours to the nearest half hour)"]
[null,"Enter KP Paid Hours",null,null,null,null,null,null,null,{"$f":"SUM(C34:I34)","v":0}]
[]
[null,"Week 2",{"$f":"IF($F$28=0,\" \",I31+1)","v":" "},{"$f":"IF($F$28=0,\" \",C36+1)","v":" "}," "," "," "," "," ",null,null,"For the Pay Period"]
[null,null,{"$f":"C36","v":" "}," "," "," "," "," "," ","Total",null,"Total Stipend","Total KP"]
[null,"Enter Stipend Hours",null,null,null,null,null,null,null,{"$f":"IF(SUM(C38:I38)>D28,\"Exceeds Max\",SUM(C38:I38))","v":0},null,"Hours*","Paid Hours"]
[null,"Enter KP Paid Hours",null,null,null,null,null,null,null,{"$f":"SUM(C39:I39)","v":0},null,{"$f":"IF(SUM(C33:I33,C38:I38)>16,\"Exceeds 16 hrs\",J33+J38)","v":0},{"$f":"+J34+J39","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"*May not exceed 16 hours "]
[null,"Comments:"]
[]
["By signing and submitting this RHR, I verify that I am currently enrolled in and attending a BHMT approved educational program and have reduced my regular work schedule by the indicated stipend hours. "]
[]
["Employee's Signature",null,null,null,null,null,null,null,"Date"]
[]
[{"$f":"IF(G23=\"TIME\",Validations!A46,Validations!A44)","v":"I have reviewed this RHR and confirm that the employee has reduced the indicated hours from the regular work schedule in order to participate in the stipend program."}]
[]
["Manager's Signature",null,null,null,null,null,null,null,"Date",null,"Mgr's Phone #"]
[]
["Print Manager's Name",null,null,null,null,null,null,null,"Mgr's Email"]
[]
["► For questions about filling out the Reduced Hours Report or your stipend payment, please call BHMT Accounting at 1-844-377-7849 or email LMP-Careers@kp.org"]
["► For questions about stipend applications or renewals, please call BHMT Applications at  510-625-5457 or email BHMT@kp.org"]
["► For questions about the stipend program policy or other concerns, please call BHMT Administration at 1-844-377-7849 or email BHMT@kp.org"]

{"sheet":"Validations","index":1,"n_rows":67,"n_cols":7,"rows_kept":67,"cut":false,"hidden":true,"merged":[]}
["Hidden Validation Worksheet"]
[]
[]
[null,null,null,null,"Beg. Payroll Period"]
["Regions","Timekeeping System","Payroll Schedule",null,"A","B","D"]
[]
["Colorado","HRConnect","D",null,"2022-12-04","2022-12-11","2022-12-12"]
["Georgia","TIME","B",null,{"$f":"+E7+14","v":"2022-12-18"},{"$f":"+F7+14","v":"2022-12-25"},{"$f":"+G7+14","v":"2022-12-26"}]
["Hawaii","TIME","B",null,{"$f":"+E8+14","v":"2023-01-01"},{"$f":"+F8+14","v":"2023-01-08"},{"$f":"+G8+14","v":"2023-01-09"}]
["Mid Atlantic","HRConnect","A",null,"2023-01-15","2023-01-22","2023-01-23"]
["Northern California","TIME","A",null,"2023-01-29","2023-02-05","2023-02-06"]
["Northwest","TIME","B",null,"2023-02-12","2023-02-19","2023-02-20"]
["S. California-Sunday start","TIME","B",null,"2023-02-26","2023-03-05","2023-03-06"]
["S. California-Monday start","TIME","D",null,"2023-03-12","2023-03-19","2023-03-20"]
["Washington","HRConnect","A",null,"2023-03-26","2023-04-02","2023-04-03"]
[null,null,null,null,"2023-04-09","2023-04-16","2023-04-17"]
[null,null,null,null,"2023-04-23","2023-04-30","2023-05-01"]
[null,4,null,null,"2023-05-07","2023-05-14","2023-05-15"]
[null,5,null,null,"2023-05-21","2023-05-28","2023-05-29"]
[null,6,null,null,"2023-06-04","2023-06-11","2023-06-12"]
[null,7,null,null,"2023-06-18","2023-06-25","2023-06-26"]
[null,8,null,null,"2023-07-02","2023-07-09","2023-07-10"]
[null,9,null,null,"2023-07-16","2023-07-23","2023-07-24"]
[null,10,null,null,"2023-07-30","2023-08-06","2023-08-07"]
[null,11,null,null,"2023-08-13","2023-08-20","2023-08-21"]
[null,12,null,null,"2023-08-27","2023-09-03","2023-09-04"]
[null,null,null,null,"2023-09-10","2023-09-17","2023-09-18"]
[null,null,null,null,"2023-09-24","2023-10-01","2023-10-02"]
[null,null,null,null,"2023-10-08","2023-10-15","2023-10-16"]
[null,null,null,null,"2023-10-22","2023-10-29","2023-10-30"]
[null,null,null,null,"2023-11-05","2023-11-12","2023-11-13"]
[null,null,null,null,"2023-11-19","2023-11-26","2023-11-27"]
[null,null,null,null,"2023-12-03","2023-12-10","2023-12-11"]
[null,null,null,null,"2023-12-17","2023-12-24","2023-12-25"]
[null,null,null,null,"2023-12-31","2024-01-07","2024-01-08"]
[null,null,null,null,"2024-01-14","2024-01-21","2024-01-22"]
[null,null,null,null,"2024-01-28","2024-02-04","2024-02-05"]
[null,null,null,null,"2024-02-11","2024-02-18","2024-02-19"]
[null,null,null,null,"2024-02-25","2024-03-03","2024-03-04"]
[null,null,null,null,"2024-03-10","2024-03-17","2024-03-18"]
[null,null,null,null,"2024-03-24","2024-03-31","2024-04-01"]
[null,null,null,null,"2024-04-07","2024-04-14","2024-04-15"]
[null,null,null,null,"2024-04-21","2024-04-28","2024-04-29"]
["I have reviewed this RHR and confirm that the employee has reduced the indicated hours from the regular work schedule in order to participate in the stipend program.",null,null,null,"2024-05-05","2024-05-12","2024-05-13"]
[null,null,null,null,"2024-05-19","2024-05-26","2024-05-27"]
["I have reviewed this RHR and confirm that the employee has reduced the indicated hours from the regular work schedule in order to participate in the stipend program , and that the stipend hours have been recorded in TIME using the \"BEN\" timekeeping code.",null,null,null,"2024-06-02","2024-06-09","2024-06-10"]
[null,null,null,null,"2024-06-16","2024-06-23","2024-06-24"]
[null,null,null,null,"2024-06-30","2024-07-07","2024-07-08"]
[null,null,null,null,"2024-07-14","2024-07-21","2024-07-22"]
[null,null,null,null,"2024-07-28","2024-08-04","2024-08-05"]
[null,null,null,null,"2024-08-11","2024-08-18","2024-08-19"]
[null,null,null,null,"2024-08-25","2024-09-01","2024-09-02"]
[null,null,null,null,"2024-09-08","2024-09-15","2024-09-16"]
[null,null,null,null,"2024-09-22","2024-09-29","2024-09-30"]
[null,null,null,null,"2024-10-06","2024-10-13","2024-10-14"]
[null,null,null,null,"2024-10-20","2024-10-27","2024-10-28"]
[null,null,null,null,"2024-11-03","2024-11-10","2024-11-11"]
[null,null,null,null,"2024-11-17","2024-11-24","2024-11-25"]
[null,null,null,null,"2024-12-01","2024-12-08","2024-12-09"]
[null,null,null,null,"2024-12-15","2024-12-22","2024-12-23"]
[null,null,null,null,"2024-12-29","2025-01-05","2025-01-06"]
[null,null,null,null,"2025-01-12","2025-01-19","2025-01-20"]
[null,null,null,null,"2025-01-26","2025-02-02","2025-02-03"]
[null,null,null,null,"2025-02-09","2025-02-16","2025-02-17"]
[null,null,null,null,"2025-02-23","2025-03-02","2025-03-03"]
[null,null,null,null,"2025-03-09","2025-03-16","2025-03-17"]
[null,null,null,null,"2025-03-23","2025-03-30","2025-03-31"]