{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["INTRO","ENTER","Ledger","674DInfo"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":103,"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":[[9,2,11,2]]}
[]
[null,null,"WELCOME TO THE COVID-19 E-FMLA CALCULATOR"]
[null,null,"revised 08/21/2020"]
[null,null,"Please check to see if the calculator has been updated at:"]
[null,null,"https://www.sco.ca.gov/ppsd_efmla.html"]
[null,null,"The E-FMLA calculator should always be used in conjunction with all applicable laws, rules and bargaining unit contracts."]
[null,null,"The E-FMLA calculator will automatically compute E-FMLA benefits (full & partial months) for fulltime and fractional civil service employees."]
[null,null,"The calculator also computes the regular pay and leave supplementation requirements 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. "]

{"sheet":"ENTER","index":1,"n_rows":155,"n_cols":52,"rows_kept":155,"cut":false,"hidden":false,"merged":[[23,7,23,13],[23,15,23,21],[23,22,23,28],[23,29,23,35],[23,0,23,6],[36,34,37,39],[49,3,49,29],[39,6,39,9],[44,6,44,9],[34,29,34,32],[34,11,34,14],[34,17,34,20],[46,17,46,20],[46,22,46,27],[46,29,46,32],[39,29,39,32],[39,11,39,14],[39,17,39,20],[44,11,44,14],[37,6,37,9],[37,11,37,14],[47,8,47,21],[24,1,24,5],[31,2,32,5],[24,30,24,34],[25,23,25,27],[25,30,25,34],[28,23,28,27],[26,23,26,27],[27,23,27,27],[29,22,30,28],[25,15,25,21],[24,16,24,20],[1,33,1,34],[25,1,25,5],[27,0,29,6],[26,1,26,5],[26,7,26,13],[26,15,26,21],[27,7,29,21],[33,17,33,20],[34,6,34,9],[33,22,33,27],[33,11,33,14],[33,6,33,9],[34,22,34,27],[10,9,10,16],[29,29,30,35],[22,1,22,5],[22,7,22,13],[25,7,25,13],[24,7,24,8],[33,29,33,32],[31,22,31,27],[22,29,22,35],[22,22,22,28],[24,23,24,27],[0,13,0,22],[1,13,1,22],[2,25,2,32],[54,2,59,16],[44,29,44,32],[1,6,1,8],[1,10,1,12],[1,26,1,27],[8,25,8,32],[31,6,31,19],[1,28,1,29],[4,25,4,32],[10,25,10,32],[37,29,37,32],[35,29,35,32],[35,22,35,27],[1,30,1,32],[24,9,24,10],[24,11,24,12],[22,15,22,21],[8,9,8,16],[6,9,6,16],[4,9,4,16],[2,9,2,16],[35,34,35,39],[83,37,83,39],[83,40,83,41],[42,6,42,9],[42,11,42,14],[42,17,42,20],[42,22,42,27],[42,29,42,32],[63,31,63,36],[67,31,67,36],[83,33,83,34],[83,35,83,36],[55,31,55,36],[59,31,59,36],[46,6,46,9],[46,11,46,14],[44,22,44,27],[39,22,39,27],[44,17,44,20],[37,17,37,20],[37,22,37,27]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter Employee Information"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"-For monthly employees only-",null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,null,""]
[null,null,null,null,null,null,null,"Employee Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AWWS:",null,"N/A"]
[]
[null,null,null,null,null,null,null,"Employee SSN:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CBID:"]
[]
[null,null,null,null,null,null,null,"Unreduced Monthly Salary:",null,7000,null,null,null,null,null,null,null,null,null,null,null,null,null,"Supplementation:"]
[]
[null,null,null,null,null,null,null,"Reduced Monthly Salary:",null,6353.9,null,null,null,null,null,null,null,null,null,null,null,null,null,"TimeBase:",null,1]
[]
[null,null,null,null,null,null,null,"Pay Period:",null,"2020-08-01",null,null,null,null,null,null,null,null,null,null,null,null,null,"E-FMLA Received:",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"              In the calendar below:"]
[null,"1. Click or click & drag top row of cells to toggle on/off E-FMLA days paid at 2/3 salary. Omit the first two weeks of E-FMLA (unpaid)."]
[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,"4. To manually reduce Supplementation, edit time in the Supp. Days & Hours boxes below. This will adjust the supplementation pay & benefit dock."]
[]
[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,31,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,8,0,0,8,8,8,8,8,0,0,8,8,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"EFMLA_Hours&\" E-FMLA Hours\"","v":"72 E-FMLA Hours"}]
[null,0,0,0,0,0,0,0,0,0,0,0,0,0,8,8,0,0,8,8,8,8,8,0,0,8,8,8,8,8,0,0,8,{"$f":"Worked_Hours&\" Work/Holiday Hours\"","v":"104 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,"Benefit Days & Hours",null,null,null,null,null,{"$f":"\"Supp. Days & Hours\"","v":"Supp. Days & Hours"},null,null,null,null,null,null,null,{"$f":"\"Benefit Dock Days & Hours\"","v":"Benefit Dock Days & Hours"},null,null,null,null,null,null,"Work/Hol. Days & Hours",null,null,null,null,null,null,"True Dock Days & Hours"]
["Paid at unreduced monthly rate",null,null,null,null,null,null,"Paid at reduced monthly rate",null,null,null,null,null,null,null,"Docked at reduced 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,{"$f":"W36","v":"5 days, 5.26 hrs."},null,null,null,null,null,0,null,{"$f":"IF(SuppTime_Days>1,\" days\",\" day\")","v":" day"},null,0,null,{"$f":"IF(SuppTime_Hours=1,\" hr.\",\" hrs.\")","v":" hrs."},null,null,{"$f":"IF(Gross_Salary=\"\",\"\",BDockDays_Hidden&IF(BDockDays_Hidden=1,\" day, \",\" days, \")&BDockHours_Hidden&IF(BDockHours_Hidden=1,\" hr.\",\" hrs.\"))","v":"3 days, 2.74 hrs."},null,null,null,null,null,null,{"$f":"W43","v":"13 days, 0 hrs."},null,null,null,null,null,null,{"$f":"W47","v":"0 days, 0 hrs."}]
[null,{"$f":"AY148&AZ148","v":"45.26 hrs."},null,null,null,null,null,{"$f":"SuppTime_Days*(8*TimeBase)+SuppTime_Hours&IF(SuppTime_Days*(8*TimeBase)+SuppTime_Hours=1,\" hr.\",\" hrs.\")","v":"0 hrs."},null,null,null,null,null,null,null,{"$f":"AY150&AZ150","v":"26.74 hrs."},null,null,null,null,null,null,null,{"$f":"Worked_Hours&AU133","v":"104 hrs."},null,null,null,null,null,null,{"$f":"DockHours&AU117","v":"0 hrs."}]
[null,{"$f":"IF(Benefit_Pay+Benefits_Paid>10000,\"Total E-FMLA received will exceed $10,000. \",\"\")","v":""},null,null,null,null,null,"Note: Leave should be keyed in CLAS to the hundredth of an hour.",null,null,null,null,null,null,null,"Note: Dock should be keyed in DCK to the hundredth of an hour.",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,null,{"$f":"IF((AT146)+DockHours>IF(PayPeriodDays=22,(11*TimeBase*8),(10*TimeBase*8)),IF(PayPeriodDays=22,\"Note: A 715 transaction will be required since the sum of benefit dock time and true dock time exceeds 11 days.\",\"Note: A 715 transaction will be required since the sum of benefit dock time and true dock time exceeds 10 days.\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AV68&AW68&ABS(AX68)&AY68","v":"0 days, 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,{"$f":"ABS(AV69)&AW69","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,{"$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,"E-FMLA",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,"2/3 Benefit",{"$f":"Hours_NotExceedingMax &IF(Hours_NotExceedingMax=1,\" hr.\",\" hrs.\")&\" x (2/3)\"","v":"0 hrs. x (2/3)"},null,null,null,"=",{"$f":"ROUNDDOWN(Hours_NotExceedingMax*2/3,5) & IF((ROUNDDOWN(Hours_NotExceedingMax*2/3,5))=1,\" hr.\",\" hrs.\")","v":"0 hrs."},null,null,null,{"$f":"\"÷ \"&(8*TimeBase)","v":"÷ 8"},"=",{"$f":"ROUNDDOWN((Hours_NotExceedingMax*2/3)/(8*TimeBase),5)&IF(ROUNDDOWN((Hours_NotExceedingMax*2/3)/(8*TimeBase),5)=1,\" day\",\" days\")","v":"0 days"},null,null,null,"=",{"$f":"IF(Gross_Salary=\"\",\"\",AW136& IF(AW136=1,\" day, \",\" days, \")&ROUND(AW139,4)& IF(AW139=1,\" hr.\",\" hrs.\"))","v":"0 days, 0 hrs."},null,null,null,null,null,"=",{"$f":"Gross_Salary*TimeBase/PayPeriodDays/(8*TimeBase)*Hours_NotExceedingMax*2/3","v":0}]
[null,null,null,null,null,"Max Benefit*",{"$f":"ROUNDDOWN(Daily_max*2/3,3)&IF(ROUNDDOWN(Daily_max*2/3,3)=1,\" hr.\",\" hrs.\")&\" x \"&Days_ExceedingMax&IF(Days_ExceedingMax=1,\" day\",\" days\")","v":"5.028 hrs. x 9 days"},null,null,null,"=",{"$f":"ROUNDDOWN(Daily_max*2/3*Days_ExceedingMax,5) & IF(ROUNDDOWN(Daily_max*2/3*Days_ExceedingMax,5)=1,\" hr.\",\" hrs.\")","v":"45.25714 hrs."},null,null,null,{"$f":"\"÷ \"&(8*TimeBase)","v":"÷ 8"},"=",{"$f":"ROUNDDOWN(Daily_max*2/3*Days_ExceedingMax/(8*TimeBase),5)&IF(ROUNDDOWN(Daily_max*2/3*Days_ExceedingMax/(8*TimeBase),5)=1,\" day\",\" days\")","v":"5.65714 days"},null,null,null,"=",{"$f":"IF(Gross_Salary=\"\",\"\",AY136& IF(AY136=1,\" day, \",\" days, \")&ROUND(AY139,4)& IF(AY139=1,\" hr.\",\" hrs.\"))","v":"5 days, 5.2571 hrs."},null,null,null,null,null,"=",{"$f":"Gross_Salary*TimeBase/PayPeriodDays/(8*TimeBase)*(Daily_max*2/3*Days_ExceedingMax)","v":1799.9999999999998}]
[null,null,null,null,null,"Benefit Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Gross_Salary=\"\",\"\",AY142 &IF(AY142=1,\" day, \",\" days, \") & AY145 & IF(AY145=1,\" hr.\",\" hrs.\"))","v":"5 days, 5.26 hrs."},null,null,null,null,null,"=",{"$f":"Hourly_Rate*(AW143)","v":1800.1136363636363},null,null,null,null,"Total Pay to issue:"]
[null,null,null,null,null,null,null,null,null,null,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":"AD36+AD38+AD43+AD45","v":5554.6909090909094}]
[null,null,null,null,null,{"$f":"\"Supp.\"","v":"Supp."},{"$f":"IF(Custom_Supp,AT154&AT155,EFMLA_Hours&\" - \"&ROUND(AW142,3)&IF(ROUND(AW142,3)=1,\" hr.\",\" hrs.\"))","v":"0 hrs."},null,null,null,"=",{"$f":"ROUNDDOWN(AT154,5)&AT155","v":"0 hrs."},null,null,null,{"$f":"\"÷ \"&(8*TimeBase)","v":"÷ 8"},"=",{"$f":"ROUND(AT154/(8*TimeBase),5)&IF(ROUND(AT154/(8*TimeBase),5)=1,\" day\",\" days\")","v":"0 days"},null,null,null,"=",{"$f":"IF(Gross_Salary=\"\",\"\",SuppTime_Days&IF(SuppTime_Days=1,\" day, \",\" days, \")&SuppTime_Hours&IF(SuppTime_Hours=1,\" hr.\",\" hrs.\"))","v":"0 days, 0 hrs."},null,null,null,null,null,"=",{"$f":"HourlyRate_ReducedReg*AY149","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Gross_Salary*TimeBase","v":7000}]
[null,null,null,null,null,null,""]
[null,null,null,null,null,{"$f":"\"Benefit Dock\"","v":"Benefit Dock"},{"$f":"IF(Supp_State=FALSE,EFMLA_Hours&\" - \"&ROUND(AW142,3)&IF(ROUND(AW142,3)=1,\" hr.\",\" hrs.\"),\"\")","v":"72 - 45.257 hrs."},null,null,null,{"$f":"IF(Supp_State=FALSE,\"=\",\"\")","v":"="},{"$f":"AT146&IF(AT146=1,\" hr.\",\" hrs.\")","v":"26.74 hrs."},null,null,null,{"$f":"\"÷ \"&(8*TimeBase)","v":"÷ 8"},"=",{"$f":"ROUND(AT146/(8*TimeBase),4) &IF(ROUND(AT146/(8*TimeBase),4)=1,\" day\",\" days\")","v":"3.3425 days"},null,null,null,"=",{"$f":"IF(Gross_Salary=\"\",\"\",BDockDays_Hidden&IF(BDockDays_Hidden=1,\" day, \",\" days, \")&BDockHours_Hidden&IF(BDockHours_Hidden=1,\" hr.\",\" hrs.\"))","v":"3 days, 2.74 hrs."},null,null,null,null,null,"=",{"$f":"HourlyRate_ReducedReg*AT146","v":965.35957954545449}]
[]
[]
[null,null,null,null,null,"Wrk./Hol.",{"$f":"Worked_Hours & IF(Worked_Hours=1,\" hr.\",\" hrs.\")","v":"104 hrs."},null,null,null,"=",{"$f":"Worked_Hours &IF(Worked_Hours=1,\" hr.\",\" hrs.\")","v":"104 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":"13 days"},null,null,null,"=",{"$f":"IF(Gross_Salary=\"\",\"\",AP50&AQ50&AP52&AQ52)","v":"13 days, 0 hrs."},null,null,null,null,null,"=",{"$f":"HourlyRate_ReducedReg*Worked_Hours","v":3754.5772727272729},null,null,null,null,null,null,null,null,null,null,null,{"$f":"INT(Worked_Hours/(8*TimeBase))","v":13},{"$f":" IF(INT(Worked_Hours/(8*TimeBase))=1,\" day, \",\" days, \")","v":" days, "}]
[]
[null,null,null,null,null,"AWWS Offset",{"$f":"AWWS_Offset_HoursTotal & AW69","v":"0 hrs."},null,null,null,"=",{"$f":"G45","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&AW68&AWWS_Offset_Hours&AY68)","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,{"$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,{"$f":"Worked_Hours","v":104}]
[null,null,null,null,null,null,null,null,"Computation of Maximum Payment 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,{"$f":"8*TimeBase","v":8}]
[null,null,"*",{"$f":"\"The $200 daily max. equates to \" & ROUND(Daily_max*2/3,3) & \" hrs. of regular pay.\"","v":"The $200 daily max. equates to 5.029 hrs. of 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,{"$f":"AP47/AP48","v":13}]
[null,null,null,{"$f":"\n\"The $200 max. was met \" & COUNTIF(EFMLA:EFMLAEnd,\">=\"&(200/EFMLA_Hourly_Rate))&IF(COUNTIF(EFMLA:EFMLAEnd,\">=\"&(200/EFMLA_Hourly_Rate))=1,\" day\",\" days\")&\" of the pay period.\"&CHAR(10)&CHAR(10)&IF(Gross_Salary=\"\",\"\",\"Note: The $200 max. is met when the benefit hours per day are at or above \"& ROUNDDOWN(200/EFMLA_Hourly_Rate,4)& \", or $200 ÷ $\" & ROUNDDOWN(EFMLA_Hourly_Rate,3) & \" per hr.\")","v":"The $200 max. was met 9 days of the pay period.\n\nNote: The $200 max. is met when the benefit hours per day are at or above 7.5428, or $200 ÷ $26.515 per hr."},null,null,null,null,null,null,null,null,null,null,null,null,null,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(AP49)","v":13},{"$f":" IF(AP50=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,{"$f":"ROUND(AP47-AP50*(8*TimeBase),2)","v":0},{"$f":" IF(AP52=1,\" hr.\",\" hrs.\")","v":" hrs."}]
[]
[]
[null,null,"\"Save Info to Ledger\" saves the employee SSN, Name, E-FMLA benefits, and supplementation information to the Ledger tab. The calculator will automatically display the E-FMLA previously received when the same SSN is entered again."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"AD36+AD38+AD43","v":5554.6909090909094}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":7.5428571428571427}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":72},{"$f":"COUNTIF(EFMLA:EFMLAEnd,\">=\"&(200/EFMLA_Hourly_Rate))","v":9},null,null,null,{"$f":"PayPeriodDays*TimeBase*8","v":176}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":0},null,null,null,{"$f":"ROUNDDOWN(AWWS_Offset_HoursTotal/(8*TimeBase),0)","v":0},{"$f":"IF(ABS(AV68)=1,\" day, \",\" days, \")","v":" days, "},{"$f":"(AWWS_Offset_HoursTotal)-ROUNDDOWN(AWWS_Offset_HoursTotal/(8*TimeBase),0)*(8*TimeBase)","v":0},{"$f":"IF(ABS(AX68)=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":"AW66-AU112","v":0},{"$f":"IF(ABS(AV69)=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,AV71:AW86,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":8},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":2020},null,false,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":9},{"$f":"IF(INT(EFMLA_Hours/(8*TimeBase))=1,\" day, \",\" days, \")","v":" days, "},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-AR74*(8*TimeBase),2)","v":0},{"$f":"IF(MOD(EFMLA_Hours,(8*TimeBase))=1,\" hr.\",\" hrs.\")","v":" hrs."},72,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":72},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":"AR74&AS74&AR75&AS75","v":"9 days, 0 hrs."},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,"Supp","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,{"$f":"ROUNDUP(((Gross_Salary*TimeBase)/PayPeriodDays)/(8*TimeBase)*(EFMLA_Hours),2)-Hidden_Benefit_Pay","v":1063.6400000000003},{"$f":"getCompensableDays(AR72,AR73)","v":22},null,null,null,"9/8/80 Thursday B",9,null,null,{"$f":"Gross_Salary*TimeBase/(PayPeriodDays)","v":318.18181818181819}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(AR72,AR73)","v":"2020-07-31"},{"$f":"getLastDayOfPayPeriod(AR72,AR73)","v":"2020-08-31"},{"$f":"IF(AR80>$AS$80,\"\",DAY(AR80))","v":31},{"$f":"IF(TimeBase=\"\",0,getWorkHoursRequired(AR80,WorkSchedID)*TimeBase)","v":8},"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,{"$f":"IF(AND(SuppTime_Days=Hidden_SuppTime_Days,SuppTime_Hours=Hidden_SuppTime_Hours),FALSE,TRUE)","v":true},{"$f":"AR80+1","v":"2020-08-01"},null,1,{"$f":"IF(TimeBase=\"\",0,getWorkHoursRequired(AR81,WorkSchedID)*TimeBase)","v":0},"9/8/80 Friday B",11,null,null,{"$f":"AZ79/(8*TimeBase)","v":39.772727272727273}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"AR81+1","v":"2020-08-02"},null,2,{"$f":"IF(TimeBase=\"\",0,getWorkHoursRequired(AR82,WorkSchedID)*TimeBase)","v":0},"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":"AR82+1","v":"2020-08-03"},null,3,{"$f":"IF(TimeBase=\"\",0,getWorkHoursRequired(AR83,WorkSchedID)*TimeBase)","v":8},"4/10/40 Tuesday",13,null,null,{"$f":"Daily_Rate*2/3","v":212.12121212121212}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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","2020-08-04",null,4,{"$f":"IF(TimeBase=\"\",0,getWorkHoursRequired(AR84,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,{"$f":"IF(AZ81 = 0, 0,EFMLA_Hours-AW142)","v":26.742857142857147},"2020-08-05",null,5,{"$f":"IF(TimeBase=\"\",0,getWorkHoursRequired(AR85,WorkSchedID)*TimeBase)","v":8},"4/10/40 Thursday",15,null,null,{"$f":"AZ83/(8*TimeBase)","v":26.515151515151516}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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","2020-08-06",null,6,{"$f":"IF(TimeBase=\"\",0,getWorkHoursRequired(AR86,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,{"$f":"ROUNDDOWN(AQ85,2)","v":26.74},"2020-08-07",null,7,{"$f":"IF(TimeBase=\"\",0,getWorkHoursRequired(AR87,WorkSchedID)*TimeBase)","v":8},null,null,null,null,{"$f":"IF(Reduced_Rate>0,Reduced_Rate,Gross_Salary)*TimeBase/PayPeriodDays/(8*TimeBase)","v":36.101704545454545}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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","2020-08-08",null,8,{"$f":"IF(TimeBase=\"\",0,getWorkHoursRequired(AR88,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,{"$f":"AQ87/(8*TimeBase)","v":3.3424999999999998},"2020-08-09",null,9,{"$f":"IF(TimeBase=\"\",0,getWorkHoursRequired(AR89,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,"Days, no remainder","2020-08-10",null,10,{"$f":"IF(TimeBase=\"\",0,getWorkHoursRequired(AR90,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,{"$f":"INT(AQ89)","v":3},"2020-08-11",null,11,{"$f":"IF(TimeBase=\"\",0,getWorkHoursRequired(AR91,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,"Remainder Hours Formatted","2020-08-12",null,12,{"$f":"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,{"$f":"ROUND(AQ87-(AQ91*8*TimeBase),4)","v":2.74},"2020-08-13",null,13,{"$f":"IF(TimeBase=\"\",0,getWorkHoursRequired(AR93,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,"2020-08-14",null,14,{"$f":"IF(TimeBase=\"\",0,getWorkHoursRequired(AR94,WorkSchedID)*TimeBase)","v":8},"First",{"$f":"LEFT(EmployeeName,(IF(AW93=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,"2020-08-15",null,15,{"$f":"IF(TimeBase=\"\",0,getWorkHoursRequired(AR95,WorkSchedID)*TimeBase)","v":0},"Middle",{"$f":"TRIM(IF(AW93=2,MID(H12,FIND(\" \",H12,1),FIND(\" \",H12,FIND(\" \",H12,1)+1)-FIND(\" \",H12,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,"Remainder Hours Formatted","2020-08-16",null,16,{"$f":"IF(TimeBase=\"\",0,getWorkHoursRequired(AR96,WorkSchedID)*TimeBase)","v":0},"Last",{"$f":"TRIM(RIGHT(SUBSTITUTE(EmployeeName,\" \",REPT(\" \",255)),255))","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,"2020-08-17",null,17,{"$f":"IF(TimeBase=\"\",0,getWorkHoursRequired(AR97,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,"2020-08-18",null,18,{"$f":"IF(TimeBase=\"\",0,getWorkHoursRequired(AR98,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,"2020-08-19",null,19,{"$f":"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,"2020-08-20",null,20,{"$f":"IF(TimeBase=\"\",0,getWorkHoursRequired(AR100,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,"2020-08-21",null,21,{"$f":"IF(TimeBase=\"\",0,getWorkHoursRequired(AR101,WorkSchedID)*TimeBase)","v":8},{"$f":"IF(SuppPercent=\"\",\"ENTER\",CONCATENATE(TEXT(SuppPercent,\"#%\"),IF(OR(H47=#REF!,SuppPercent=0.5),\"\",\" & Sal Chg\")))","v":"ENTER"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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","2020-08-22",null,22,{"$f":"IF(TimeBase=\"\",0,getWorkHoursRequired(AR102,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,"2020-08-23",null,23,{"$f":"IF(TimeBase=\"\",0,getWorkHoursRequired(AR103,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,"2020-08-24",null,24,{"$f":"IF(TimeBase=\"\",0,getWorkHoursRequired(AR104,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,"2020-08-25",null,25,{"$f":"IF(TimeBase=\"\",0,getWorkHoursRequired(AR105,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,1800,"2020-08-26",null,26,{"$f":"IF(TimeBase=\"\",0,getWorkHoursRequired(AR106,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,{"$f":"IF(VALUE(SuppTime_Days)*(TimeBase*8)+VALUE(SuppTime_Hours)=VALUE(AQ91)*(TimeBase*8)+VALUE(AQ93),TRUE,FALSE)","v":false},"2020-08-27",null,27,{"$f":"IF(TimeBase=\"\",0,getWorkHoursRequired(AR107,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,"2020-08-28",null,28,{"$f":"IF(TimeBase=\"\",0,getWorkHoursRequired(AR108,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,"2020-08-29",null,29,{"$f":"IF(TimeBase=\"\",0,getWorkHoursRequired(AR109,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,"2020-08-30",null,30,{"$f":"IF(TimeBase=\"\",0,getWorkHoursRequired(AR110,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,"2020-08-31",null,31,{"$f":"IF(TimeBase=\"\",0,getWorkHoursRequired(AR111,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,null,null,null,{"$f":"SUM(AU80:AU111)-SUMIF(AT80:AT111,\"\",AU80:AU111)","v":176}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":2863.6363636363635},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,{"$f":"AF43/((Gross_Salary*TimeBase/PayPeriodDays)/8*TimeBase)","v":0},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,0,{"$f":"IF(AT117=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,104,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,{"$f":"SUM(B20:AG20)","v":72},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":"AR79","v":22},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":"0 Days, 0 Hours"},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,"Total Regular Hours",null,{"$f":"DuringEFMLA+BeforeAfterEFMLA","v":104},{"$f":"IF(AT133=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":"AT133/(8*TimeBase)","v":13},null,null,{"$f":"INT((Hours_NotExceedingMax*2/3)/(8*TimeBase))","v":0},null,{"$f":"INT((Daily_max*2/3*Days_ExceedingMax)/(8*TimeBase))","v":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,"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(AT136)","v":13},null,null,{"$f":"ROUNDUP(Hours_NotExceedingMax*2/3-AW136*(8*TimeBase),2)","v":0},null,{"$f":"ROUNDUP((Daily_max*2/3*Days_ExceedingMax)-AY136*(8*TimeBase),2)","v":5.26}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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-AW136*(8*TimeBase)","v":0},null,{"$f":"(Daily_max*2/3*Days_ExceedingMax)-AY136*(8*TimeBase)","v":5.2571428571428527}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(AT133-(AT138*8*TimeBase),4)","v":0},null,null,{"$f":"INT((Hours_NotExceedingMax*2/3+Daily_max*2/3*Days_ExceedingMax)/(8*TimeBase))","v":5},null,{"$f":"AW138+AY138","v":5.26}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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=\"\",\"\",AT138& IF(AT138=1,\" Day, \",\" Days, \")&AT140& IF(AT140=1,\" Hour\",\" Hours\"))","v":"13 Days, 0 Hours"},null,null,{"$f":"(AW136+AY136)*(8*TimeBase)+AW139+AY139","v":45.257142857142853},null,{"$f":"INT(AW142/(8*TimeBase))","v":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,null,null,null,{"$f":"ROUNDUP(AW142,2)","v":45.26},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":"AW142-AY142*(8*TimeBase)","v":5.2571428571428527}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(AY144,2)","v":5.26}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"AY150","v":26.74}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(AT146/(8*TimeBase))","v":3},null,null,null,null,{"$f":"ROUNDUP((Daily_max*Days_ExceedingMax+Hours_NotExceedingMax)*2/3,2)","v":45.26},{"$f":"IF(AY148=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,"Dock Hours Due to Partial Supp",null,null,null,null,{"$f":"ROUNDDOWN(SuppTime_Days*(8*TimeBase)+SuppTime_Hours,2)","v":0},{"$f":"IF(AY149=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":"ROUND(AT146-BDockDays_Hidden*(8*TimeBase),2)","v":2.74},null,null,null,null,{"$f":"ROUND(EFMLA_Hours-AY148-AY149,2)","v":26.74}," 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,"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,AQ85)","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(AT1523=1,\" hr.\",\" hrs.\")","v":" hrs."}]

{"sheet":"Ledger","index":2,"n_rows":1,"n_cols":11,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["SSN","Name","E-FMLA Gross Paid","E-FMLA Time","E-FMLA Supplementation Paid","Supplementation Time","E-FMLA Dock","E-FMLA Dock Time","Total E-FMLA Time","Pay Period","AWW Excess/Deficit"]

{"sheet":"674DInfo","index":3,"n_rows":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":true,"merged":[[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],[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]]}
["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":8}]
[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."]