{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["INTRO","ENTER","674DInfo"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":107,"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":"INTRO","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[8,2,10,2]]}
[]
[null,null,"WELCOME TO THE SPSL CALCULATOR"]
[null,null,"revised 10/27/2022"]
[]
[null,null,"The SPSL calculator should always be used in conjunction with all applicable laws, rules and bargaining unit contracts."]
[null,null,"The SPSL calculator will automatically compute SPSL benefits (full & partial months) for fulltime and fractional civil service employees."]
[null,null,"The calculator also computes the regular pay and dock pay based solely on the data entered by the user. Employment history and payment history information are not used by the calculator."]
[null,null,"The calculator can only compute benefits based on monthly salary rates. "]
[null,null,"Enter Employee Info"]

{"sheet":"ENTER","index":1,"n_rows":190,"n_cols":52,"rows_kept":190,"cut":false,"hidden":false,"merged":[[72,37,72,39],[72,40,72,41],[31,6,31,9],[31,11,31,14],[31,17,31,20],[31,22,31,27],[31,29,31,32],[52,31,52,36],[56,31,56,36],[72,33,72,34],[72,35,72,36],[44,31,44,36],[48,31,48,36],[35,6,35,9],[0,13,0,22],[33,29,33,32],[27,6,27,19],[8,9,8,16],[6,9,6,16],[4,9,4,16],[2,9,2,16],[33,17,33,20],[1,1,1,34],[2,25,2,32],[29,17,29,20],[21,6,21,12],[22,6,22,12],[23,7,23,11],[27,33,27,39],[29,34,29,38],[24,7,24,11],[23,21,23,25],[39,2,44,15],[22,13,22,19],[6,25,6,32],[36,29,36,32],[33,6,33,9],[29,6,29,9],[26,23,26,27],[35,11,35,14],[33,22,33,27],[35,17,35,20],[35,22,35,27],[35,29,35,32],[33,11,33,14],[29,11,29,14],[29,22,29,27],[29,29,29,32],[31,35,31,36],[4,25,4,32],[27,22,27,27],[21,28,21,32],[23,28,23,32],[24,28,24,32],[25,27,25,33],[21,13,21,19],[23,14,23,18],[24,14,24,18],[22,20,22,26],[21,20,21,26],[24,21,24,25]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter Employee Information"]
[null,"For monthly employees only, January 1, 2022 to December 31, 2022"]
[null,null,null,null,null,null,null,"Employee Name:",null,"John",null,null,null,null,null,null,null,null,null,null,null,null,null,"Pay Period:",null,"2022-10-01"]
[]
[null,null,null,null,null,null,null,"Employee SSN:",null,"Doe",null,null,null,null,null,null,null,null,null,null,null,null,null,"AWWS:",null,"N/A"]
[]
[null,null,null,null,null,null,null,"Unreduced Monthly Salary:",null,5000,null,null,null,null,null,null,null,null,null,null,null,null,null,"TimeBase:",null,1]
[]
[null,null,null,null,null,null,null,"Reduced Monthly Salary:",null,4000]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"              In the calendar below:"]
[null,"1. Edit SPSL hours by typing the desired number of hours."]
[null,"2. Edit worked hours by typing the desired number of hours."]
[null,"3. Type the desired number of true dock hours into the true dock cells."]
[]
[]
[null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SPSL_Hours&\" SPSL Hours\"","v":"0 SPSL Hours"}]
[null,0,0,8,8,8,8,8,0,0,8,8,8,8,8,0,0,8,8,8,8,8,0,0,8,8,8,8,8,0,0,8,0,{"$f":"Worked_Hours&\" Work/Holiday Hours\"","v":"168 Work/Holiday Hours"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DockHours&\" True Dock Hours\"","v":"0 True Dock Hours"}]
[null,null,null,null,null,null,"SPSL Days & Hours",null,null,null,null,null,null,"Work/Hol. Days & Hours",null,null,null,null,null,null,"True Dock Days & Hours",null,null,null,null,null,null,null,{"$f":"\"AWW \"&IF(AWWS_Offset_HoursTotal<0,\"Excess Hours\",\"Deficit Hours\")","v":"AWW Deficit Hours"}]
[null,null,null,null,null,null,"Paid at unreduced monthly rate",null,null,null,null,null,null,"Paid at reduced monthly rate",null,null,null,null,null,null,"Docked at reduced monthly rate"]
[null,null,null,null,null,null,null,{"$f":"W30","v":"0 Days, 0 Hours"},null,null,null,null,null,null,{"$f":"W32","v":"21 days, 0 hrs."},null,null,null,null,null,null,{"$f":"W36","v":"0 days, 0 hrs."},null,null,null,null,null,null,{"$f":"AV57&AW57&ABS(AX57)&AY57","v":"0 days, 0 hrs."}]
[null,null,null,null,null,null,null,{"$f":"SPSL_Hours&AU147","v":"0 hrs."},null,null,null,null,null,null,{"$f":"Worked_Hours&AU122","v":"168 hrs."},null,null,null,null,null,null,{"$f":"DockHours&AU106","v":"0 hrs."},null,null,null,null,null,null,{"$f":"AWWS_Offset_HoursTotal&AW58","v":"0 hrs."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AWWS_Offset_HoursTotal<0,\"These excess hours go into the employee's leave bank.\"&CHAR(10)&\"See CalHR Manual 1503\",\"This must be used from the employee's leave bank.\"&CHAR(10)&\"See CalHR Manual 1503\")","v":"This must be used from the employee's leave bank.\nSee CalHR Manual 1503"}]
[]
[null,null,null,null,null,null,"Computation & Pay Period Hours Breakdown",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Days & Hours",null,null,null,null,null,null,null,null,null,null,"Total Pay To Issue"]
[]
[null,null,null,null,null,"SPSL",{"$f":"SPSL_Hours & IF(SPSL_Hours=1,\" hr.\",\" hrs.\")","v":"0 hrs."},null,null,null,"=",{"$f":"SPSL_Hours & IF(SPSL_Hours=1,\" hr.\",\" hrs.\")","v":"0 hrs."},null,null,null,{"$f":"\"÷ \"&(8*TimeBase)","v":"÷ 8"},"=",{"$f":"ROUND(SPSL_Hours/(8*TimeBase),4)&IF(ROUND(SPSL_Hours/(8*TimeBase),4)=1,\" day\",\" days\")","v":"0 days"},null,null,null,"=",{"$f":"IF(Gross_Salary=\"\",\"\",AT155)","v":"0 Days, 0 Hours"},null,null,null,null,null,"=",{"$f":"Hourly_Rate*SPSL_Hours","v":0},null,null,null,null,{"$f":"AD30+AD32+AD34","v":4000},null,null,null,null,null,null,null,null,null,{"$f":"Gross_Salary*TimeBase","v":5000}]
[]
[null,null,null,null,null,"Wrk./Hol.",{"$f":"Worked_Hours & IF(Worked_Hours=1,\" hr.\",\" hrs.\")","v":"168 hrs."},null,null,null,"=",{"$f":"Worked_Hours &IF(Worked_Hours=1,\" hr.\",\" hrs.\")","v":"168 hrs."},null,null,null,{"$f":"\"÷ \"&(8*TimeBase)","v":"÷ 8"},"=",{"$f":"ROUND(Worked_Hours/(8*TimeBase),4)&IF(ROUND(Worked_Hours/(8*TimeBase),4)=1,\" day\",\" days\")","v":"21 days"},null,null,null,"=",{"$f":"IF(Gross_Salary=\"\",\"\",AR39&AS39&AR51&AS51)","v":"21 days, 0 hrs."},null,null,null,null,null,"=",{"$f":"HourlyRate_ReducedReg*Worked_Hours","v":4000},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INT(Worked_Hours/(8*TimeBase))","v":21},{"$f":" IF(INT(Worked_Hours/(8*TimeBase))=1,\" day, \",\" days, \")","v":" days, "}]
[]
[null,null,null,null,null,"AWWS Offset",{"$f":"AWWS_Offset_HoursTotal & AW58","v":"0 hrs."},null,null,null,"=",{"$f":"G34","v":"0 hrs."},null,null,null,{"$f":"\"÷ \"&(8*TimeBase)","v":"÷ 8"},"=",{"$f":"ROUND(AWWS_Offset_HoursTotal/(8*TimeBase),4)&IF(ROUND(AWWS_Offset_HoursTotal/(8*TimeBase),4)=1,\" day\",\" days\")","v":"0 days"},null,null,null,"=",{"$f":"IF(Gross_Salary=\"\",\"\",AWWS_Offset_Days&AW57&AWWS_Offset_Hours&AY57)","v":"0 days, 0 hrs."},null,null,null,null,null,"=",{"$f":"HourlyRate_ReducedReg*AWWS_Offset_HoursTotal","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDDOWN(MOD(Worked_Hours,(8*TimeBase)),2)","v":0},{"$f":" IF(MOD(Worked_Hours,(8*TimeBase))=1,\" hr.\",\" hrs.\")","v":" hrs."}]
[null,null,null,null,null,"True Dock",{"$f":"DockHours & IF(DockHours=1,\" hr.\",\" hrs.\")","v":"0 hrs."},null,null,null,"=",{"$f":"DockHours &IF(DockHours=1,\" hr.\",\" hrs.\")","v":"0 hrs."},null,null,null,{"$f":"\"÷ \"&(8*TimeBase)","v":"÷ 8"},"=",{"$f":"ROUND(DockHours/(8*TimeBase),4)&IF(ROUND(DockHours/(8*TimeBase),4)=1,\" day\",\" days\")","v":"0 days"},null,null,null,"=",{"$f":"IF(Gross_Salary=\"\",\"\",INT(DockHours/(8*TimeBase))& IF(INT(DockHours/(8*TimeBase))=1,\" day, \",\" days, \")&MOD(DockHours,(8*TimeBase))& IF(MOD(DockHours,(8*TimeBase))=1,\" hr.\",\" hrs.\"))","v":"0 days, 0 hrs."},null,null,null,null,null,"=",{"$f":"HourlyRate_ReducedReg*DockHours","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Worked_Hours","v":168}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"8*TimeBase","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AR36/AR37","v":21}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INT(AR38)","v":21},{"$f":" IF(AR39=1,\" day, \",\" days, \")","v":" days, "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!+#REF!+AD32","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AR36-AR39*(8*TimeBase),2)","v":0},{"$f":" IF(AR51=1,\" hr.\",\" hrs.\")","v":" hrs."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Daily max"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Gross_Salary=\"\",0,200/EFMLA_Hourly_Rate)","v":10.08}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours exceeding daily max","Days exceeding daily max",null,null,null,"Hours in Standard Pay Period, no AWWS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(EFMLA:EFMLAEnd,\">=\"&(200/EFMLA_Hourly_Rate))","v":{"$error":"#REF!"}},{"$f":"COUNTIF(EFMLA:EFMLAEnd,\">=\"&(200/EFMLA_Hourly_Rate))","v":{"$error":"#REF!"}},null,null,null,{"$f":"PayPeriodDays*TimeBase*8","v":168}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours NOT exceeding daily max",null,null,null,"Offset"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"EFMLA_Hours-Hours_ExceedingMax","v":{"$error":"#REF!"}},null,null,null,{"$f":"ROUNDDOWN(AWWS_Offset_HoursTotal/(8*TimeBase),0)","v":0},{"$f":"IF(ABS(AV57)=1,\" day, \",\" days, \")","v":" days, "},{"$f":"(AWWS_Offset_HoursTotal)-ROUNDDOWN(AWWS_Offset_HoursTotal/(8*TimeBase),0)*(8*TimeBase)","v":0},{"$f":"IF(ABS(AX57)=1,\" hr.\",\" hrs.\")","v":" hrs."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AWWS=\"N/A\",0,ROUND(AW55-(Worked_Hours+SPSL_Hours),5))","v":0},{"$f":"IF(ABS(AV58)=1,\" hr.\",\" hrs.\")","v":" hrs."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(AWWS,AV60:AW75,2,FALSE)","v":1},null,"WorkScheduleDescription","WorkScheduleID"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pay Period Month/Year",null,1,null,"N/A",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MONTH(PayPeriod)","v":10},null,null,null,"9/8/80 Monday A",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"YEAR(PayPeriod)","v":2022},null,true,null,"9/8/80 Monday B",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INT(EFMLA_Hours/(8*TimeBase))","v":{"$error":"#REF!"}},{"$f":"IF(INT(EFMLA_Hours/(8*TimeBase))=1,\" day, \",\" days, \")","v":{"$error":"#REF!"}},false,null,"9/8/80 Tuesday A",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(EFMLA_Hours-AR63*(8*TimeBase),2)","v":{"$error":"#REF!"}},{"$f":"IF(MOD(EFMLA_Hours,(8*TimeBase))=1,\" hr.\",\" hrs.\")","v":{"$error":"#REF!"}},0,null,"9/8/80 Tuesday B",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(EFMLA:EFMLAEnd)","v":{"$error":"#REF!"}},null,"9/8/80 Wednesday A",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AR63&AS63&AR64&AS64","v":{"$error":"#REF!"}},null,"9/8/80 Wednesday B",7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Days In Pay Period",null,null,null,"9/8/80 Thursday A",8,null,null,"Daily Rate: Regular Pay"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"getCompensableDays(AR61,AR62)","v":21},null,null,null,"9/8/80 Thursday B",9,null,null,{"$f":"Gross_Salary*TimeBase/(PayPeriodDays)","v":238.0952380952381}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"getFirstDayOfPayPeriod(AR61,AR62)","v":"2022-10-01"},{"$f":"getLastDayOfPayPeriod(AR61,AR62)","v":"2022-10-31"},{"$f":"IF(AR69>$AS$69,\"\",DAY(AR69))","v":1},{"$f":"IF(AT69=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR69,WorkSchedID)*TimeBase))","v":0},"9/8/80 Friday A",10,null,null,"Hourly Rate: Regular Pay"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AR69+1","v":"2022-10-02"},null,2,{"$f":"IF(AT70=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR70,WorkSchedID)*TimeBase))","v":0},"9/8/80 Friday B",11,null,null,{"$f":"AZ68/(8*TimeBase)","v":29.761904761904763}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AR70+1","v":"2022-10-03"},null,3,{"$f":"IF(AT71=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR71,WorkSchedID)*TimeBase))","v":8},"4/10/40 Monday",12,null,null,"Daily Rate: E-FMLA (2/3)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AR71+1","v":"2022-10-04"},null,4,{"$f":"IF(AT72=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR72,WorkSchedID)*TimeBase))","v":8},"4/10/40 Tuesday",13,null,null,{"$f":"Daily_Rate*2/3","v":158.73015873015873}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-05",null,5,{"$f":"IF(AT73=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR73,WorkSchedID)*TimeBase))","v":8},"4/10/40 Wednesday",14,null,null,"Hourly Rate: E-FMLA (2/3)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-06",null,6,{"$f":"IF(AT74=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR74,WorkSchedID)*TimeBase))","v":8},"4/10/40 Thursday",15,null,null,{"$f":"AZ72/(8*TimeBase)","v":19.841269841269842}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-07",null,7,{"$f":"IF(AT75=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR75,WorkSchedID)*TimeBase))","v":8},"4/10/40 Friday",16,null,null,"Reduced Hourly Rate: Regular Pay"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-08",null,8,{"$f":"IF(AT76=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR76,WorkSchedID)*TimeBase))","v":0},null,null,null,null,{"$f":"IF(Reduced_Rate>0,Reduced_Rate,Gross_Salary)*TimeBase/PayPeriodDays/(8*TimeBase)","v":23.80952380952381}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-09",null,9,{"$f":"IF(AT77=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR77,WorkSchedID)*TimeBase))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-10",null,10,{"$f":"IF(AT78=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR78,WorkSchedID)*TimeBase))","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-11",null,11,{"$f":"IF(AT79=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR79,WorkSchedID)*TimeBase))","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-12",null,12,{"$f":"IF(AT80=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR80,WorkSchedID)*TimeBase))","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-13",null,13,{"$f":"IF(AT81=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR81,WorkSchedID)*TimeBase))","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-14",null,14,{"$f":"IF(AT82=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR82,WorkSchedID)*TimeBase))","v":8},null,{"$f":"LEN(EmployeeName)-LEN(SUBSTITUTE(EmployeeName,\" \",\"\"))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-15",null,15,{"$f":"IF(AT83=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR83,WorkSchedID)*TimeBase))","v":0},"First",{"$f":"LEFT(EmployeeName,(IF(AW82=0,1,FIND(\" \",EmployeeName,1))-1))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-16",null,16,{"$f":"IF(AT84=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR84,WorkSchedID)*TimeBase))","v":0},"Middle",{"$f":"TRIM(IF(AW82=2,MID(H11,FIND(\" \",H11,1),FIND(\" \",H11,FIND(\" \",H11,1)+1)-FIND(\" \",H11,1)),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-17",null,17,{"$f":"IF(AT85=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR85,WorkSchedID)*TimeBase))","v":8},"Last",{"$f":"TRIM(RIGHT(SUBSTITUTE(EmployeeName,\" \",REPT(\" \",255)),255))","v":"John"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-18",null,18,{"$f":"IF(AT86=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR86,WorkSchedID)*TimeBase))","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-19",null,19,{"$f":"IF(AT87=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR87,WorkSchedID)*TimeBase))","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-20",null,20,{"$f":"IF(AT88=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR88,WorkSchedID)*TimeBase))","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-21",null,21,{"$f":"IF(AT89=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR89,WorkSchedID)*TimeBase))","v":8},"Destination:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-22",null,22,{"$f":"IF(AT90=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR90,WorkSchedID)*TimeBase))","v":0},{"$f":"IF(SuppPercent=\"\",\"ENTER\",CONCATENATE(TEXT(SuppPercent,\"#%\"),IF(OR(H36=#REF!,SuppPercent=0.5),\"\",\" & Sal Chg\")))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-23",null,23,{"$f":"IF(AT91=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR91,WorkSchedID)*TimeBase))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-24",null,24,{"$f":"IF(AT92=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR92,WorkSchedID)*TimeBase))","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-25",null,25,{"$f":"IF(AT93=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR93,WorkSchedID)*TimeBase))","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-26",null,26,{"$f":"IF(AT94=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR94,WorkSchedID)*TimeBase))","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-27",null,27,{"$f":"IF(AT95=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR95,WorkSchedID)*TimeBase))","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-28",null,28,{"$f":"IF(AT96=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR96,WorkSchedID)*TimeBase))","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-29",null,29,{"$f":"IF(AT97=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR97,WorkSchedID)*TimeBase))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-30",null,30,{"$f":"IF(AT98=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR98,WorkSchedID)*TimeBase))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-31",null,31,{"$f":"IF(AT99=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR99,WorkSchedID)*TimeBase))","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-11-01",null,"",{"$f":"IF(AT100=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR100,WorkSchedID)*TimeBase))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AU69:AU100)-SUMIF(AT69:AT100,\"\",AU69:AU100)","v":168}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Gross_Salary/PayPeriodDays*(RegHoursPossible/(8))","v":0},null,null,null,"WorkScheduleDescription","WorkScheduleID"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9/8/80 Monday A",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"True Dock Hours: ",null,{"$f":"SUM(Dock:DockEnd)","v":0},{"$f":"IF(AT106=1,\" hr.\",\" hrs.\")","v":" hrs."},"9/8/80 Monday B",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"9/8/80 Tuesday A",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours WWO E-FMLA:           ",null,0,null,"9/8/80 Tuesday B",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"9/8/80 Wednesday A",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reg Hours not WWO:                         ",null,176,null,"9/8/80 Wednesday B",7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"9/8/80 Thursday A",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours During E-FMLA:",null,null,null,"9/8/80 Thursday B",9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,176,null,"9/8/80 Friday A",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Days in Pay Period:",null,null,null,"9/8/80 Friday B",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AR68","v":21},null,"4/10/40 Monday",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Intermittent E-FMLA",null,null,null,"4/10/40 Tuesday",13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"4/10/40 Wednesday",14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4/10/40 Thursday",15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Supplementation Time:",null,{"$f":"IF(Gross_Salary=\"\",\"\",SuppTime_Days& IF(SuppTime_Days=1,\" Day, \",\" Days, \")&SuppTime_Hours& IF(SuppTime_Hours=1,\" Hour\",\" Hours\"))","v":{"$error":"#REF!"}},null,"4/10/40 Friday",16]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Hours"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Regular Hours",null,{"$f":"SUM(Work:WorkEnd)","v":168},{"$f":"IF(AT122=1,\" hr.\",\" hrs.\")","v":" hrs."}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rounded Hours to Days",null,null,"2/3 Days",null,"maxed out Days"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Worked_Hours/(8*TimeBase)","v":21},null,null,{"$f":"INT((Hours_NotExceedingMax*2/3)/(8*TimeBase))","v":{"$error":"#REF!"}},null,{"$f":"INT((Daily_max*2/3*Days_ExceedingMax)/(8*TimeBase))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Days, no remainder",null,null,"2/3 Hours",null,"maxed out Hours"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INT(AT125)","v":21},null,null,{"$f":"ROUNDUP(Hours_NotExceedingMax*2/3-AW125*(8*TimeBase),2)","v":{"$error":"#REF!"}},null,{"$f":"ROUNDUP((Daily_max*2/3*Days_ExceedingMax)-AY125*(8*TimeBase),2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Remainder Hours Formatted",null,null,{"$f":"Hours_NotExceedingMax*2/3-AW125*(8*TimeBase)","v":{"$error":"#REF!"}},null,{"$f":"(Daily_max*2/3*Days_ExceedingMax)-AY125*(8*TimeBase)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AT122-(AT127*8*TimeBase),4)","v":0},null,null,{"$f":"INT((Hours_NotExceedingMax*2/3+Daily_max*2/3*Days_ExceedingMax)/(8*TimeBase))","v":{"$error":"#REF!"}},null,{"$f":"AW127+AY127","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Benefit Hours",null,"Total Benefit Days Portion"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regular Days ,Hours",null,{"$f":"IF(Gross_Salary=\"\",\"\",AT127& IF(AT127=1,\" Day, \",\" Days, \")&AT129& IF(AT129=1,\" Hour\",\" Hours\"))","v":"21 Days, 0 Hours"},null,null,{"$f":"(AW125+AY125)*(8*TimeBase)+AW128+AY128","v":{"$error":"#REF!"}},null,{"$f":"INT(AW131/(8*TimeBase))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(AW131,2)","v":{"$error":"#REF!"}},null,"Total Benefit Hours Portion"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AW131-AY131*(8*TimeBase)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dock Total Hours Due to Partial Supp",null,null,null,null,{"$f":"ROUNDUP(AY133,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AY139","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dock Days Due to Partial Supp"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INT(AT135/(8*TimeBase))","v":{"$error":"#REF!"}},null,null,null,"E-FMLA",{"$f":"ROUNDUP((Daily_max*Days_ExceedingMax+Hours_NotExceedingMax)*2/3,2)","v":{"$error":"#REF!"}},{"$f":"IF(AY137=1,\" hr.\",\" hrs.\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dock Hours Due to Partial Supp",null,null,null,"Supp",{"$f":"ROUNDDOWN(SuppTime_Days*(8*TimeBase)+SuppTime_Hours,2)","v":{"$error":"#REF!"}},{"$f":"IF(AY138=1,\" hr.\",\" hrs.\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AT135-BDockDays_Hidden*(8*TimeBase),2)","v":{"$error":"#REF!"}},null,null,null,"Dock",{"$f":"ROUND(EFMLA_Hours-AY137-AY138,2)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Supp Total Hrs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Custom_Supp,SuppTime_Days*(8*TimeBase)+SuppTime_Hours,AR168)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AT1512=1,\" hr.\",\" hrs.\")","v":" hrs."}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Hours"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EPSLA",null,{"$f":"SUM(B19:AG19)","v":0},{"$f":"IF(AT147=1,\" hr.\",\" hrs.\")","v":" hrs."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rounded Hours to Days"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SPSL_Hours/(8*TimeBase)","v":0},{"$f":"IF(INT(SPSL_Hours/(8*TimeBase))=1,\" day \",\" days \")","v":" days "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Days, no remainder"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INT(AT149)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Remainder Hours Formatted"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AT147-(AT151*8*TimeBase),4)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Gross_Salary=\"\",\"\",AT151& IF(AT151=1,\" Day, \",\" Days, \")&AT153& IF(AT153=1,\" Hour\",\" Hours\"))","v":"0 Days, 0 Hours"}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Supp"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(((Gross_Salary*TimeBase)/PayPeriodDays)/(8*TimeBase)*(EFMLA_Hours),2)-Hidden_Benefit_Pay","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(SuppTime_Days=Hidden_SuppTime_Days,SuppTime_Hours=Hidden_SuppTime_Hours),FALSE,TRUE)","v":{"$error":"#REF!"}}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Supp Hours"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AZ70 = 0, 0,EFMLA_Hours-AW131)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Supp Hours, Rounded"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDDOWN(AR168,2)","v":{"$error":"#REF!"}},null,{"$f":"IF(Supp_State=FALSE,0,SuppHours_Rounded)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rounded Hours to Days"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AR170/(8*TimeBase)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Days, no remainder"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INT(AR172)","v":{"$error":"#REF!"}},null,{"$f":"IF(Supp_State=FALSE,0,Hidden_SuppTime_Days)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Remainder Hours Formatted"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AR170-(AR174*8*TimeBase),4)","v":{"$error":"#REF!"}},null,{"$f":"IF(Supp_State=FALSE,0,Hidden_SuppTime_Hours)","v":{"$error":"#REF!"}}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Remainder Hours Formatted"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E-FMLA Benefit Pay"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VALUE(SuppTime_Days)*(TimeBase*8)+VALUE(SuppTime_Hours)=VALUE(AR174)*(TimeBase*8)+VALUE(AR176),TRUE,FALSE)","v":{"$error":"#REF!"}}]

{"sheet":"674DInfo","index":2,"n_rows":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":true,"merged":[[27,0,27,3],[3,0,3,3],[7,5,7,7],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[10,0,10,1],[9,0,9,1],[8,0,8,1],[11,0,13,0],[15,0,15,1],[16,0,17,0],[20,0,21,0],[26,0,26,3],[24,0,24,1],[1,0,1,3],[0,0,0,3],[14,0,14,1],[23,0,23,1],[22,0,22,1],[19,0,19,1],[18,0,18,1],[2,0,2,3]]}
["NOTE:  Only the information you enter here on this worksheet will be automatically entered onto the 674D. "]
["All other pertinent information required will have to be manually entered onto the 674D."]
["Verify that all required information has been entered on the 674D before sending to SCO."]
["ENTER 674D INFORMATION"]
["CBID",null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["SSN",null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["FIRST INITIAL",null,{"$f":"LEFT(#REF!,1)","v":{"$error":"#REF!"}}]
["MIDDLE INITIAL",null,{"$f":"LEFT(#REF!,1)","v":{"$error":"#REF!"}},null,null,"dashes"]
["LAST NAME",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,"16 chars?","4th char","8th char","13th char","Agency","Unit","Class","Serial"]
["POSITION NUMBER #1",null,{"$f":"IF(CONCATENATE(#REF!,\"-\",#REF!,\"-\",#REF!,\"-\",#REF!)=\"---\",\"\",CONCATENATE(#REF!,\"-\",#REF!,\"-\",#REF!,\"-\",#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(C10=\"\",\"\",IF(B33,C33,\"\"))","v":{"$error":"#REF!"}},{"$f":"IF(LEN(C10)=16,TRUE,FALSE)","v":{"$error":"#REF!"}},{"$f":"IF(MID(C10,4,1)=\"-\",TRUE, FALSE)","v":{"$error":"#REF!"}},{"$f":"IF(MID(C10,8,1)=\"-\",TRUE, FALSE)","v":{"$error":"#REF!"}},{"$f":"IF(MID(C10,13,1)=\"-\",TRUE, FALSE)","v":{"$error":"#REF!"}},{"$f":"MID(C10,1,3)","v":{"$error":"#REF!"}},{"$f":"MID(C10,5,3)","v":{"$error":"#REF!"}},{"$f":"MID(C10,9,4)","v":{"$error":"#REF!"}},{"$f":"MID(C10,14,3)","v":{"$error":"#REF!"}}]
["POSITION NUMBER #2",null,{"$f":"IF(CONCATENATE(#REF!,\"-\",#REF!,\"-\",#REF!,\"-\",#REF!)=\"---\",\"\",CONCATENATE(#REF!,\"-\",#REF!,\"-\",#REF!,\"-\",#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(C11=\"\",\"\",IF(B34,C34,\"\"))","v":{"$error":"#REF!"}},{"$f":"IF(LEN(C11)=16,TRUE,FALSE)","v":{"$error":"#REF!"}},{"$f":"IF(MID(C11,4,1)=\"-\",TRUE, FALSE)","v":{"$error":"#REF!"}},{"$f":"IF(MID(C11,8,1)=\"-\",TRUE, FALSE)","v":{"$error":"#REF!"}},{"$f":"IF(MID(C11,13,1)=\"-\",TRUE, FALSE)","v":{"$error":"#REF!"}},{"$f":"MID(C11,1,3)","v":{"$error":"#REF!"}},{"$f":"MID(C11,5,3)","v":{"$error":"#REF!"}},{"$f":"MID(C11,9,4)","v":{"$error":"#REF!"}},{"$f":"MID(C11,14,3)","v":{"$error":"#REF!"}}]
["PAY PERIOD","Type"]
[null,"Month",{"$f":"MONTH(ENTER!PayPeriod)","v":10}]
[null,"Year",{"$f":"YEAR(PayPeriod)","v":{"$error":"#NAME?"}},null,null,null,null,"Supplimentation Levels:",null,null,"Timebase Fraction"]
["SUPPLEMENTATION LEVEL",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,75,null,null,1]
["TIMEBASE FRACTION",null,{"$f":"TimeBase","v":{"$error":"#NAME?"}},null,null,null,null,100,null,null,0.2]
["EMPLOYEE ON NDI","From",null,null,null,null,null,null,null,null,0.4]
[null,"To",null,{"$f":"IF(B36,C36,\"\")","v":""},"before from date?",{"$f":"IF(C18<C17,TRUE,FALSE)","v":false},null,null,null,null,0.6]
["AVERAGE HOURS WORKED\nDURING PREVIOUS 18 MONTHS\nFOR INTERMITTENT EMPLOYEE",null,null,null,null,null,null,null,null,null,0.8]
["EMPLOYEE ON ANNUAL LEAVE PROGRAM",null,null,null,null,null,null,null,null,null,0.125]
["SUPPLEMENTATION\nAMOUNT","Days",{"$f":"IF(C15=50%,0,VLOOKUP(\"Days Needed To Supplement:\",INDIRECT(F26),2,0))","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,0.25]
[null,"Hours",{"$f":"IF(C15=50%,0,VLOOKUP(\"Hours Needed To Supplement:\",INDIRECT(F26),2,0))","v":{"$error":"#REF!"}},null,"Hours>8?",{"$f":"IF(C22>=8,TRUE, FALSE)","v":{"$error":"#REF!"}},null,null,null,null,0.375]
["CONTACT PERSON",null,null,null,null,null,null,null,null,null,0.5]
["TELEPHONE NUMBER",null,null,null,null,null,null,null,null,null,0.625]
["EMAIL ADDRESS",null,null,null,null,null,null,null,null,null,0.75]
[null,null,null,null,null,{"$f":"\"'\"&LinkLocation&\"'\"&\"!\"&\"A28:B30\"","v":{"$error":"#NAME?"}},null,null,null,null,0.875]
["GO BACK TO ENTER EMPLOYEE INFORMATION",null,null,null,null,null,null,null,null,null,0.7]
["GO TO THE STD. FORM 674D",null,null,null,null,null,null,null,null,null,0.9]
[]
[]
[]
[null,null,"Errors:"]
["Position #1",{"$f":"IF(AND(E10,F10, G10, H10), FALSE,TRUE)","v":{"$error":"#REF!"}},"Invalid position number. Example: 051-220-1337-930"]
["Position #2",{"$f":"IF(AND(E11,F11, G11, H11), FALSE,TRUE)","v":{"$error":"#REF!"}},"Invalid position number. Example: 051-220-1337-930"]
[]
["NDI dates",{"$f":"IF(C18 > 0, F18, FALSE)","v":false},"\"To\" date must be after \"From\" date."]