{"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":109,"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 12/18/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":204,"n_cols":52,"rows_kept":204,"cut":false,"hidden":false,"merged":[[37,34,38,39],[52,3,52,29],[86,37,86,39],[86,40,86,41],[45,6,45,9],[45,11,45,14],[45,17,45,20],[45,22,45,27],[45,29,45,32],[66,31,66,36],[70,31,70,36],[86,33,86,34],[86,35,86,36],[58,31,58,36],[62,31,62,36],[49,6,49,9],[49,11,49,14],[47,22,47,27],[47,17,47,20],[49,17,49,20],[49,22,49,27],[49,29,49,32],[40,29,40,32],[40,11,40,14],[0,13,0,22],[1,13,1,22],[2,25,2,32],[57,2,62,16],[47,29,47,32],[1,6,1,8],[1,10,1,12],[1,26,1,27],[8,25,8,32],[32,6,32,19],[1,28,1,29],[4,25,4,32],[10,25,10,32],[38,29,38,32],[36,29,36,32],[36,22,36,27],[1,30,1,32],[25,9,25,10],[25,11,25,12],[23,15,23,21],[8,9,8,16],[6,9,6,16],[4,9,4,16],[2,9,2,16],[34,17,34,20],[35,6,35,9],[34,22,34,27],[34,11,34,14],[34,6,34,9],[35,22,35,27],[10,9,10,16],[30,29,31,35],[23,1,23,5],[23,7,23,13],[26,7,26,13],[25,7,25,8],[34,29,34,32],[32,22,32,27],[23,29,23,35],[25,30,25,34],[26,15,26,21],[25,16,25,20],[35,17,35,20],[1,33,1,34],[26,1,26,5],[28,0,30,6],[27,1,27,5],[27,7,27,13],[27,15,27,21],[28,7,30,21],[24,7,24,13],[24,15,24,21],[24,29,24,35],[24,0,24,6],[40,17,40,20],[47,11,47,14],[38,6,38,9],[38,11,38,14],[38,17,38,20],[38,22,38,27],[43,6,43,9],[43,11,43,14],[43,17,43,20],[50,8,50,21],[25,1,25,5],[32,2,33,5],[26,30,26,34],[43,22,43,27],[43,29,43,32],[24,36,24,42],[23,36,23,42],[26,37,26,41],[23,22,23,28],[24,22,24,28],[25,23,25,27],[26,23,26,27],[25,37,25,41],[29,23,29,27],[27,23,27,27],[28,23,28,27],[30,22,31,28],[36,34,36,39],[40,22,40,27],[40,6,40,9],[47,6,47,9],[35,29,35,32],[35,11,35,14]]}
[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,null,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,null,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-12-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. Edit EPSLA (if applicable) and EFMLA 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,"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,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":"EPSLA_Hours&\" EPSLA Hours\"","v":"0 EPSLA 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":"EFMLA_Hours & \" E-FMLA Hours\"","v":"0 E-FMLA Hours"}]
[null,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,8,8,8,0,0,{"$f":"Worked_Hours&\" Work/Holiday Hours\"","v":"176 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,"EPSLA 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,{"$f":"\"Paid at \"&IF(PayPeriod<DATE(2020,12,1),\"reduced\",\"unreduced\")&\" monthly rate\"","v":"Paid at unreduced monthly rate"},null,null,null,null,null,null,null,{"$f":"\"Paid at \"&IF(PayPeriod<DATE(2020,12,1),\"reduced\",\"unreduced\")&\" monthly rate\"","v":"Paid at unreduced monthly rate"},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,{"$f":"W37","v":""},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":""},null,null,null,null,null,null,{"$f":"W44","v":""},null,null,null,null,null,null,{"$f":"W46","v":""},null,null,null,null,null,null,{"$f":"W50","v":""}]
[null,{"$f":"AY151&AZ151","v":"0 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":"AY153&AZ153","v":"0 hrs."},null,null,null,null,null,null,null,{"$f":"EPSLA_Hours&AU161","v":"0 hrs."},null,null,null,null,null,null,{"$f":"Worked_Hours&AU136","v":"176 hrs."},null,null,null,null,null,null,{"$f":"DockHours&AU120","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((AT149)+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":"AV71&AW71&ABS(AX71)&AY71","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(AV72)&AW72","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=\"\",\"\",AW139& IF(AW139=1,\" day, \",\" days, \")&ROUND(AW142,4)& IF(AW142=1,\" hr.\",\" hrs.\"))","v":""},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":"0 hrs. x 0 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":"0 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":"0 days"},null,null,null,"=",{"$f":"IF(Gross_Salary=\"\",\"\",AY139& IF(AY139=1,\" day, \",\" days, \")&ROUND(AY142,4)& IF(AY142=1,\" hr.\",\" hrs.\"))","v":""},null,null,null,null,null,"=",{"$f":"Gross_Salary*TimeBase/PayPeriodDays/(8*TimeBase)*(Daily_max*2/3*Days_ExceedingMax)","v":0}]
[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=\"\",\"\",AY145 &IF(AY145=1,\" day, \",\" days, \") & AY148 & IF(AY148=1,\" hr.\",\" hrs.\"))","v":""},null,null,null,null,null,"=",{"$f":"Hourly_Rate*(AW146)","v":0},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":"AD37+AD39+AD46+AD48+AD44","v":0}]
[null,null,null,null,null,{"$f":"\"Supp.\"","v":"Supp."},{"$f":"IF(Custom_Supp,AT157&AT158,EFMLA_Hours&\" - \"&ROUND(AW145,3)&IF(ROUND(AW145,3)=1,\" hr.\",\" hrs.\"))","v":"0 - 0 hrs."},null,null,null,"=",{"$f":"ROUNDDOWN(AT157,5)&AT158","v":"0 hrs."},null,null,null,{"$f":"\"÷ \"&(8*TimeBase)","v":"÷ 8"},"=",{"$f":"ROUND(AT157/(8*TimeBase),5)&IF(ROUND(AT157/(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":""},null,null,null,null,null,"=",{"$f":"IF(PayPeriod<DATE(2020,12,1),HourlyRate_ReducedReg,Hourly_Rate)*AY152","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Gross_Salary*TimeBase","v":0}]
[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(AW145,3)&IF(ROUND(AW145,3)=1,\" hr.\",\" hrs.\"),\"\")","v":""},null,null,null,{"$f":"IF(Supp_State=FALSE,\"=\",\"\")","v":""},{"$f":"AT149&IF(AT149=1,\" hr.\",\" hrs.\")","v":"0 hrs."},null,null,null,{"$f":"\"÷ \"&(8*TimeBase)","v":"÷ 8"},"=",{"$f":"ROUND(AT149/(8*TimeBase),4) &IF(ROUND(AT149/(8*TimeBase),4)=1,\" day\",\" days\")","v":"0 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":""},null,null,null,null,null,"=",{"$f":"IF(PayPeriod<DATE(2020,12,1),HourlyRate_ReducedReg,Hourly_Rate)*AT149","v":0}]
[]
[]
[null,null,null,null,null,"EPSLA",{"$f":"EPSLA_Hours & IF(EPSLA_Hours=1,\" hr.\",\" hrs.\")","v":"0 hrs."},null,null,null,"=",{"$f":"EPSLA_Hours & IF(EPSLA_Hours=1,\" hr.\",\" hrs.\")","v":"0 hrs."},null,null,null,{"$f":"\"÷ \"&(8*TimeBase)","v":"÷ 8"},"=",{"$f":"ROUND(EPSLA_Hours/(8*TimeBase),4)&IF(ROUND(EPSLA_Hours/(8*TimeBase),4)=1,\" day\",\" days\")","v":"0 days"},null,null,null,"=",{"$f":"IF(Gross_Salary=\"\",\"\",AT169)","v":""},null,null,null,null,null,"=",{"$f":"Hourly_Rate*EPSLA_Hours","v":0}]
[]
[null,null,null,null,null,"Wrk./Hol.",{"$f":"Worked_Hours & IF(Worked_Hours=1,\" hr.\",\" hrs.\")","v":"176 hrs."},null,null,null,"=",{"$f":"Worked_Hours &IF(Worked_Hours=1,\" hr.\",\" hrs.\")","v":"176 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":"22 days"},null,null,null,"=",{"$f":"IF(Gross_Salary=\"\",\"\",AR53&AS53&AR65&AS65)","v":""},null,null,null,null,null,"=",{"$f":"HourlyRate_ReducedReg*Worked_Hours","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INT(Worked_Hours/(8*TimeBase))","v":22},{"$f":" IF(INT(Worked_Hours/(8*TimeBase))=1,\" day, \",\" days, \")","v":" days, "}]
[]
[null,null,null,null,null,"AWWS Offset",{"$f":"AWWS_Offset_HoursTotal & AW72","v":"0 hrs."},null,null,null,"=",{"$f":"G48","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&AW71&AWWS_Offset_Hours&AY71)","v":""},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":""},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":176}]
[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,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 0 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,null,null,{"$f":"AR50/AR51","v":22}]
[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 0 days of the pay period.\n\n"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(AR52)","v":22},{"$f":" IF(AR53=1,\" day, \",\" days, \")","v":" days, "}]
[]
[]
[]
[]
[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":"AD37+AD39+AD46","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":"ROUND(AR50-AR53*(8*TimeBase),2)","v":0},{"$f":" IF(AR65=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":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,"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":0},{"$f":"COUNTIF(EFMLA:EFMLAEnd,\">=\"&(200/EFMLA_Hourly_Rate))","v":0},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(AV71)=1,\" day, \",\" days, \")","v":" days, "},{"$f":"(AWWS_Offset_HoursTotal)-ROUNDDOWN(AWWS_Offset_HoursTotal/(8*TimeBase),0)*(8*TimeBase)","v":0},{"$f":"IF(ABS(AX71)=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":"AW69-AU115","v":0},{"$f":"IF(ABS(AV72)=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,AV74:AW89,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":12},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,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":0},{"$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-AR77*(8*TimeBase),2)","v":0},{"$f":"IF(MOD(EFMLA_Hours,(8*TimeBase))=1,\" hr.\",\" hrs.\")","v":" hrs."},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":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,null,null,{"$f":"AR77&AS77&AR78&AS78","v":"0 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,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(AR75,AR76)","v":22},null,null,null,"9/8/80 Thursday B",9,null,null,{"$f":"Gross_Salary*TimeBase/(PayPeriodDays)","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":"getFirstDayOfPayPeriod(AR75,AR76)","v":"2020-12-02"},{"$f":"getLastDayOfPayPeriod(AR75,AR76)","v":"2020-12-31"},{"$f":"IF(AR83>$AS$83,\"\",DAY(AR83))","v":2},{"$f":"IF(AT83=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR83,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,null,{"$f":"AR83+1","v":"2020-12-03"},null,3,{"$f":"IF(AT84=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR84,WorkSchedID)*TimeBase))","v":8},"9/8/80 Friday B",11,null,null,{"$f":"AZ82/(8*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,{"$f":"AR84+1","v":"2020-12-04"},null,4,{"$f":"IF(AT85=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR85,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":"AR85+1","v":"2020-12-05"},null,5,{"$f":"IF(AT86=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR86,WorkSchedID)*TimeBase))","v":0},"4/10/40 Tuesday",13,null,null,{"$f":"Daily_Rate*2/3","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-12-06",null,6,{"$f":"IF(AT87=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR87,WorkSchedID)*TimeBase))","v":0},"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,"2020-12-07",null,7,{"$f":"IF(AT88=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR88,WorkSchedID)*TimeBase))","v":8},"4/10/40 Thursday",15,null,null,{"$f":"AZ86/(8*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-12-08",null,8,{"$f":"IF(AT89=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR89,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,"2020-12-09",null,9,{"$f":"IF(AT90=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR90,WorkSchedID)*TimeBase))","v":8},null,null,null,null,{"$f":"IF(Reduced_Rate>0,Reduced_Rate,Gross_Salary)*TimeBase/PayPeriodDays/(8*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-12-10",null,10,{"$f":"IF(AT91=\"\",\"\",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,null,"2020-12-11",null,11,{"$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,"2020-12-12",null,12,{"$f":"IF(AT93=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR93,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-12-13",null,13,{"$f":"IF(AT94=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR94,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-12-14",null,14,{"$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,"2020-12-15",null,15,{"$f":"IF(AT96=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR96,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-12-16",null,16,{"$f":"IF(AT97=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR97,WorkSchedID)*TimeBase))","v":8},"First",{"$f":"LEFT(EmployeeName,(IF(AW96=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-12-17",null,17,{"$f":"IF(AT98=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR98,WorkSchedID)*TimeBase))","v":8},"Middle",{"$f":"TRIM(IF(AW96=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,null,"2020-12-18",null,18,{"$f":"IF(AT99=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR99,WorkSchedID)*TimeBase))","v":8},"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-12-19",null,19,{"$f":"IF(AT100=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR100,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-12-20",null,20,{"$f":"IF(AT101=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR101,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-12-21",null,21,{"$f":"IF(AT102=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR102,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-12-22",null,22,{"$f":"IF(AT103=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR103,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-12-23",null,23,{"$f":"IF(AT104=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR104,WorkSchedID)*TimeBase))","v":8},{"$f":"IF(SuppPercent=\"\",\"ENTER\",CONCATENATE(TEXT(SuppPercent,\"#%\"),IF(OR(H50=#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,null,"2020-12-24",null,24,{"$f":"IF(AT105=\"\",\"\",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,null,"2020-12-25",null,25,{"$f":"IF(AT106=\"\",\"\",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,null,"2020-12-26",null,26,{"$f":"IF(AT107=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR107,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-12-27",null,27,{"$f":"IF(AT108=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR108,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-12-28",null,28,{"$f":"IF(AT109=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR109,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-12-29",null,29,{"$f":"IF(AT110=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR110,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-12-30",null,30,{"$f":"IF(AT111=\"\",\"\",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,"2020-12-31",null,31,{"$f":"IF(AT112=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR112,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,"2021-01-01",null,"",{"$f":"IF(AT113=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR113,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,"2021-01-02",null,"",{"$f":"IF(AT114=\"\",\"\",IF(TimeBase=\"\",0,getWorkHoursRequired(AR114,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(AU83:AU114)-SUMIF(AT83:AT114,\"\",AU83:AU114)","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":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,{"$f":"AF46/((Gross_Salary*TimeBase/PayPeriodDays)/8*TimeBase)","v":{"$error":"#DIV/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,{"$f":"SUM(Dock:DockEnd)","v":0},{"$f":"IF(AT120=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,{"$f":"SUM(B21:AG21)","v":0},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":"AR82","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":""},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":176},{"$f":"IF(AT136=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":22},null,null,{"$f":"INT((Hours_NotExceedingMax*2/3)/(8*TimeBase))","v":0},null,{"$f":"INT((Daily_max*2/3*Days_ExceedingMax)/(8*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,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(AT139)","v":22},null,null,{"$f":"ROUNDUP(Hours_NotExceedingMax*2/3-AW139*(8*TimeBase),2)","v":0},null,{"$f":"ROUNDUP((Daily_max*2/3*Days_ExceedingMax)-AY139*(8*TimeBase),2)","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,{"$f":"Hours_NotExceedingMax*2/3-AW139*(8*TimeBase)","v":0},null,{"$f":"(Daily_max*2/3*Days_ExceedingMax)-AY139*(8*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,null,null,{"$f":"ROUND(AT136-(AT141*8*TimeBase),4)","v":0},null,null,{"$f":"INT((Hours_NotExceedingMax*2/3+Daily_max*2/3*Days_ExceedingMax)/(8*TimeBase))","v":0},null,{"$f":"AW141+AY141","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,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=\"\",\"\",AT141& IF(AT141=1,\" Day, \",\" Days, \")&AT143& IF(AT143=1,\" Hour\",\" Hours\"))","v":""},null,null,{"$f":"(AW139+AY139)*(8*TimeBase)+AW142+AY142","v":0},null,{"$f":"INT(AW145/(8*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,null,null,null,null,null,{"$f":"ROUNDUP(AW145,2)","v":0},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":"AW145-AY145*(8*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,null,null,"Dock Total Hours Due to Partial Supp",null,null,null,null,{"$f":"ROUNDUP(AY147,2)","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":"AY153","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,"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(AT149/(8*TimeBase))","v":0},null,null,null,"E-FMLA",{"$f":"ROUNDUP((Daily_max*Days_ExceedingMax+Hours_NotExceedingMax)*2/3,2)","v":0},{"$f":"IF(AY151=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,"Supp",{"$f":"ROUNDDOWN(SuppTime_Days*(8*TimeBase)+SuppTime_Hours,2)","v":0},{"$f":"IF(AY152=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(AT149-BDockDays_Hidden*(8*TimeBase),2)","v":0},null,null,null,"Dock",{"$f":"ROUND(EFMLA_Hours-AY151-AY152,2)","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,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,AR182)","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(AT1526=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(B20:AG20)","v":0},{"$f":"IF(AT161=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":"EPSLA_Hours/(8*TimeBase)","v":0},{"$f":"IF(INT(EPSLA_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(AT163)","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(AT161-(AT165*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=\"\",\"\",AT165& IF(AT165=1,\" Day, \",\" Days, \")&AT167& IF(AT167=1,\" Hour\",\" Hours\"))","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,"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":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(AND(SuppTime_Days=Hidden_SuppTime_Days,SuppTime_Hours=Hidden_SuppTime_Hours),FALSE,TRUE)","v":false}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(AZ84 = 0, 0,EFMLA_Hours-AW145)","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,"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(AR182,2)","v":0},null,{"$f":"IF(Supp_State=FALSE,0,SuppHours_Rounded)","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,"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":"AR184/(8*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,"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(AR186)","v":0},null,{"$f":"IF(Supp_State=FALSE,0,Hidden_SuppTime_Days)","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,"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(AR184-(AR188*8*TimeBase),4)","v":0},null,{"$f":"IF(Supp_State=FALSE,0,Hidden_SuppTime_Hours)","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,"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(AR188)*(TimeBase*8)+VALUE(AR190),TRUE,FALSE)","v":true}]

{"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":[[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":12}]
[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."]