{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["INTRO","ENTER","100%","100% & Sal Chg","75%","75% & Sal Chg","50%","674DInfo","674D"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":59,"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":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"WELCOME TO THE ENHANCED NDI (ENDI) CALCULATOR"]
[null,null,"The ENDI calculator should always be used in conjunction with all applicable laws, rules and bargaining unit contracts."]
[null,null,"The ENDI calculator will automatically compute ENDI benefits (full & partial months) for fulltime, fractional & AWW (50% NDI pay only) civil service employees who are annual leave participants. Additionally, the calculator includes a form 674D feature that can be used (strictly voluntary) to request ENDI payments that cannot be processed through the payroll input process (PIP). "]
[null,null,"The calculator cannot compute ENDI benefits for employees in classifications with hourly or daily established salary rates - it can only compute benefits based on monthly salary rates.  additionally, the calculator cannot compute leave supplementation requirements for intermittent employees - it can only calculate the 50% NDI pay."]
[null,null,"The calculator computes the NDI 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,"http://www.sco.ca.gov/ppsd/ppm/index.shtml"]
[null,null,"Go to Enter Employee Information"]

{"sheet":"ENTER","index":1,"n_rows":71,"n_cols":53,"rows_kept":71,"cut":false,"hidden":false,"merged":[[38,27,40,33],[35,16,35,23],[37,16,37,23],[34,26,37,33],[28,26,31,33],[32,26,33,33],[24,26,27,33],[29,16,29,23],[31,16,31,23],[14,26,15,33],[33,16,33,23],[25,16,25,23],[27,16,27,23],[16,26,17,33],[18,26,20,33],[21,26,23,33],[21,16,21,23],[19,16,19,23],[17,16,17,23],[23,16,23,23],[1,26,1,27],[1,28,1,29],[3,26,3,27],[3,28,3,29],[2,26,2,27],[2,28,2,29],[1,33,1,34],[2,33,2,34],[1,30,1,32],[2,30,2,32],[3,30,3,32],[3,33,3,34],[6,0,6,2],[7,0,7,2],[1,6,1,8],[1,10,1,12],[43,16,43,23],[1,14,2,22],[8,0,8,2],[9,0,9,2],[11,0,11,2],[41,16,41,23],[39,16,39,23],[10,0,10,2],[13,16,13,23],[15,16,15,23]]}
[]
[null,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,"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,"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,"Agency",null,"Unit",null,"Class",null,null,"Serial"]
[null,null,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,null,null,{"$f":"OFFSET(PayPeriod_Day1,D5,0)","v":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,""]
["Weekend",null,null,true,false,false,false,false,false,true,true,false,false,false,false,false,true,true,false,false,false,false,false,true,true,false,false,false,false,false,true,true,false,false]
["Holiday",null,null,false,true,false,false,false,false,false,false,false,false,false,false,false,false,false,true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
["NDI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\"Y\" for NDI"]
["Wrk./Hol.",null,null,0,8,8,8,8,8,0,0,8,8,8,8,8,0,0,8,8,8,8,8,0,0,8,8,8,8,8,0,0,8,8,0,"No. of Hours"]
["AWW 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,"No. of Leave Hours",null,null,null,null,null,null,null,null,null,"Work Sched. ID Selected",null,null,null,null,null,"WorkScheduleDescription","WorkScheduleID"]
["Dock",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No. of Hours",null,null,null,null,null,null,null,"Pay Period Month/Year",null,{"$f":"VLOOKUP(AlternateWorkWeek,AZ12:BA27,2,FALSE)","v":1},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":"MONTH(PayPeriod)","v":1},null,null,null,null,null,null,null,"9/8/80 Monday A",2]
[null,"Employee Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":2023},null,null,null,null,null,null,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,"Instructions:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9/8/80 Tuesday A",4]
[null,"Employee Social:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9/8/80 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,"In the Calendar Section:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9/8/80 Wednesday A",6]
[null,"CBID:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9/8/80 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,"1. Click the NDI cell or click & drag to populate NDI days.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Days In Pay Period",null,null,null,null,null,null,null,"9/8/80 Thursday A",8]
[null,"Pay Period:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-01",null,null,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(AR13,AR14)","v":22},null,null,null,"Weekend (Formula)","Holiday (Formula)","NDI",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,0,{"$f":"getFirstDayOfPayPeriod(AR13,AR14)","v":"2023-01-01"},{"$f":"getLastDayOfPayPeriod(AR13,AR14)","v":"2023-01-31"},{"$f":"IF(AR21>$AS$21,\"\",DAY(AR21))","v":1},{"$f":"IF(OR(TimeBase=\"\",OFFSET(Weekend,0,AQ21)=TRUE),0,getWorkHoursRequired(AR21,WorkSchedID)*TimeBase)","v":0},{"$f":"isWeekend(PayPeriodDate1)","v":true},{"$f":"isStateHoliday(PayPeriodDate1)","v":false},{"$f":"IF(OFFSET(NDI,0,AQ21) = \"Y\",TRUE,FALSE)","v":false},null,"9/8/80 Friday A",10]
[null,"Number of Approved NDI Calendar Days:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(D9:AI9,\"Y\")","v":0},null,null,null,null,null,null,null,null,null,"2. Enter hours that were worked, and/or dock ours.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"AR21+1","v":"2023-01-02"},null,2,{"$f":"IF(OR(TimeBase=\"\",OFFSET(Weekend,0,AQ22)=TRUE),0,getWorkHoursRequired(AR22,WorkSchedID)*TimeBase)","v":8},{"$f":"isWeekend(AR22)","v":false},{"$f":"isStateHoliday(AR22)","v":true},false,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,2,{"$f":"AR22+1","v":"2023-01-03"},null,3,{"$f":"IF(OR(TimeBase=\"\",OFFSET(Weekend,0,AQ23)=TRUE),0,getWorkHoursRequired(AR23,WorkSchedID)*TimeBase)","v":8},{"$f":"isWeekend(AR23)","v":false},{"$f":"isStateHoliday(AR23)","v":false},false,null,"4/10/40 Monday",12]
[null,"Monthly Salary Rate for NDI (not actual):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"2023-01-04",null,4,{"$f":"IF(OR(TimeBase=\"\",OFFSET(Weekend,0,AQ24)=TRUE),0,getWorkHoursRequired(AR24,WorkSchedID)*TimeBase)","v":8},false,false,false,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,"In the Employee Information Section:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"2023-01-05",null,5,{"$f":"IF(OR(TimeBase=\"\",OFFSET(Weekend,0,AQ25)=TRUE),0,getWorkHoursRequired(AR25,WorkSchedID)*TimeBase)","v":8},false,false,false,null,"4/10/40 Wednesday",14]
[null,"Monthly Salary Rate for Supplementation 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,5,"2023-01-06",null,6,{"$f":"IF(OR(TimeBase=\"\",OFFSET(Weekend,0,AQ26)=TRUE),0,getWorkHoursRequired(AR26,WorkSchedID)*TimeBase)","v":8},false,false,false,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,6,"2023-01-07",null,7,{"$f":"IF(OR(TimeBase=\"\",OFFSET(Weekend,0,AQ27)=TRUE),0,getWorkHoursRequired(AR27,WorkSchedID)*TimeBase)","v":0},true,false,false,null,"4/10/40 Friday",16]
[null,"Dock Hours: ",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,7,"2023-01-08",null,8,{"$f":"IF(OR(TimeBase=\"\",OFFSET(Weekend,0,AQ28)=TRUE),0,getWorkHoursRequired(AR28,WorkSchedID)*TimeBase)","v":0},true,false,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,"3. Complete all peach-colored cells (grey cells are protected and cannot be changed)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"2023-01-09",null,9,{"$f":"IF(OR(TimeBase=\"\",OFFSET(Weekend,0,AQ29)=TRUE),0,getWorkHoursRequired(AR29,WorkSchedID)*TimeBase)","v":8},false,false,false]
[null,"Regular Pay Hours POSSIBLE During NDI:",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,9,"2023-01-10",null,10,{"$f":"IF(OR(TimeBase=\"\",OFFSET(Weekend,0,AQ30)=TRUE),0,getWorkHoursRequired(AR30,WorkSchedID)*TimeBase)","v":8},false,false,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,10,"2023-01-11",null,11,{"$f":"IF(OR(TimeBase=\"\",OFFSET(Weekend,0,AQ31)=TRUE),0,getWorkHoursRequired(AR31,WorkSchedID)*TimeBase)","v":8},false,false,false]
[null,"Number of Days in Pay Period:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AR20","v":22},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"2023-01-12",null,12,{"$f":"IF(OR(TimeBase=\"\",OFFSET(Weekend,0,AQ32)=TRUE),0,getWorkHoursRequired(AR32,WorkSchedID)*TimeBase)","v":8},false,false,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,"4. Click “Go to Results”",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"2023-01-13",null,13,{"$f":"IF(OR(TimeBase=\"\",OFFSET(Weekend,0,AQ33)=TRUE),0,getWorkHoursRequired(AR33,WorkSchedID)*TimeBase)","v":8},false,false,false]
[null,"Hours Worked DURING NDI:           ",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,13,"2023-01-14",null,14,{"$f":"IF(OR(TimeBase=\"\",OFFSET(Weekend,0,AQ34)=TRUE),0,getWorkHoursRequired(AR34,WorkSchedID)*TimeBase)","v":0},true,false,false,null,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,"5. Click “Clear Form” button before entering data for a new calculation.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"2023-01-15",null,15,{"$f":"IF(OR(TimeBase=\"\",OFFSET(Weekend,0,AQ35)=TRUE),0,getWorkHoursRequired(AR35,WorkSchedID)*TimeBase)","v":0},true,false,false,null,"First",{"$f":"LEFT(EmployeeName,(IF(BA34=0,1,FIND(\" \",EmployeeName,1))-1))","v":""}]
[null,"Work & Holiday Hours BEFORE/AFTER NDI:                         ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,15,"2023-01-16",null,16,{"$f":"IF(OR(TimeBase=\"\",OFFSET(Weekend,0,AQ36)=TRUE),0,getWorkHoursRequired(AR36,WorkSchedID)*TimeBase)","v":8},false,true,false,null,"Middle",{"$f":"TRIM(IF(BA34=2,MID(Q14,FIND(\" \",Q14,1),FIND(\" \",Q14,FIND(\" \",Q14,1)+1)-FIND(\" \",Q14,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,16,"2023-01-17",null,17,{"$f":"IF(OR(TimeBase=\"\",OFFSET(Weekend,0,AQ37)=TRUE),0,getWorkHoursRequired(AR37,WorkSchedID)*TimeBase)","v":8},false,false,false,null,"Last",{"$f":"TRIM(SUBSTITUTE(RIGHT(EmployeeName,LEN(Q14)-IF(BA34=0,0,IF(BA34=1,FIND(BA35,EmployeeName,1)+LEN(BA35),FIND(BA36,EmployeeName,1)+LEN(BA36)))),\".\",\"\"))","v":""}]
[null,"Time Base:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,17,"2023-01-18",null,18,{"$f":"IF(OR(TimeBase=\"\",OFFSET(Weekend,0,AQ38)=TRUE),0,getWorkHoursRequired(AR38,WorkSchedID)*TimeBase)","v":8},false,false,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,"Note: Upon clearing, pay period defaults to current pay period.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"2023-01-19",null,19,{"$f":"IF(OR(TimeBase=\"\",OFFSET(Weekend,0,AQ39)=TRUE),0,getWorkHoursRequired(AR39,WorkSchedID)*TimeBase)","v":8},false,false,false]
[null,"Alternate Work Week:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"2023-01-20",null,20,{"$f":"IF(OR(TimeBase=\"\",OFFSET(Weekend,0,AQ40)=TRUE),0,getWorkHoursRequired(AR40,WorkSchedID)*TimeBase)","v":8},false,false,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,20,"2023-01-21",null,21,{"$f":"IF(OR(TimeBase=\"\",OFFSET(Weekend,0,AQ41)=TRUE),0,getWorkHoursRequired(AR41,WorkSchedID)*TimeBase)","v":0},true,false,false,null,"Destination:"]
[null,"Supplementation Perc. :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,"2023-01-22",null,22,{"$f":"IF(OR(TimeBase=\"\",OFFSET(Weekend,0,AQ42)=TRUE),0,getWorkHoursRequired(AR42,WorkSchedID)*TimeBase)","v":0},true,false,false,null,{"$f":"IF(SuppPercent=\"\",\"ENTER\",CONCATENATE(TEXT(SuppPercent,\"#%\"),IF(Q24=Q26,\"\",\" & 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,22,"2023-01-23",null,23,{"$f":"IF(OR(TimeBase=\"\",OFFSET(Weekend,0,AQ43)=TRUE),0,getWorkHoursRequired(AR43,WorkSchedID)*TimeBase)","v":8},false,false,false]
[null,"NDI - FCL:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,"2023-01-24",null,24,{"$f":"IF(OR(TimeBase=\"\",OFFSET(Weekend,0,AQ44)=TRUE),0,getWorkHoursRequired(AR44,WorkSchedID)*TimeBase)","v":8},false,false,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,24,"2023-01-25",null,25,{"$f":"IF(OR(TimeBase=\"\",OFFSET(Weekend,0,AQ45)=TRUE),0,getWorkHoursRequired(AR45,WorkSchedID)*TimeBase)","v":8},false,false,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,25,"2023-01-26",null,26,{"$f":"IF(OR(TimeBase=\"\",OFFSET(Weekend,0,AQ46)=TRUE),0,getWorkHoursRequired(AR46,WorkSchedID)*TimeBase)","v":8},false,false,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,26,"2023-01-27",null,27,{"$f":"IF(OR(TimeBase=\"\",OFFSET(Weekend,0,AQ47)=TRUE),0,getWorkHoursRequired(AR47,WorkSchedID)*TimeBase)","v":8},false,false,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,27,"2023-01-28",null,28,{"$f":"IF(OR(TimeBase=\"\",OFFSET(Weekend,0,AQ48)=TRUE),0,getWorkHoursRequired(AR48,WorkSchedID)*TimeBase)","v":0},true,false,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,28,"2023-01-29",null,29,{"$f":"IF(OR(TimeBase=\"\",OFFSET(Weekend,0,AQ49)=TRUE),0,getWorkHoursRequired(AR49,WorkSchedID)*TimeBase)","v":0},true,false,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,29,"2023-01-30",null,30,{"$f":"IF(OR(TimeBase=\"\",OFFSET(Weekend,0,AQ50)=TRUE),0,getWorkHoursRequired(AR50,WorkSchedID)*TimeBase)","v":8},false,false,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,30,"2023-01-31",null,31,{"$f":"IF(OR(TimeBase=\"\",OFFSET(Weekend,0,AQ51)=TRUE),0,getWorkHoursRequired(AR51,WorkSchedID)*TimeBase)","v":8},false,false,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,31,"2023-02-01",null,"",{"$f":"IF(OR(TimeBase=\"\",OFFSET(Weekend,0,AQ52)=TRUE),0,getWorkHoursRequired(AR52,WorkSchedID)*TimeBase)","v":8},false,false,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,null,null,null,null,null,null,"First Day"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IFERROR(\"AX\"&MATCH(TRUE,AX21:AX52,0)+20,\"\")","v":""},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,null,null,{"$f":"IFERROR(OFFSET(INDIRECT(AX55),0,-6),\"\")","v":""},null,"N/A",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Last Day",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,null,null,null,null,null,null,{"$f":"IFERROR(\"AX\"&LOOKUP(2,1/(AX21:AX52<>FALSE),ROW(AX21:AX52)),\"\")","v":""},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,null,null,null,null,null,null,{"$f":"IFERROR(OFFSET(INDIRECT(AX58),0,-6),\"\")","v":""},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,null,null,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,null,null,null,"9/8/80 Thursday B",9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,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,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,null,null,null,null,null,null,null,null,"4/10/40 Friday",16]

{"sheet":"100%","index":2,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,1],[30,0,30,1],[31,0,31,1]]}
["100% SUPPLEMENTATION"]
["EMPLOYEE NAME:",{"$f":"ENTER!S14","v":0}]
["Pay Period: ",{"$f":"IF(ENTER!Q20=\"\",\"\",ENTER!Q20)","v":"2023-01-01"}]
["Days In Pay Period:",{"$f":"IF(ENTER!Q32=\"\",\"\",ENTER!Q32)","v":22}]
["Hours In Pay Period:",{"$f":"IF(B4=22,176,IF(B4=21,168,\"\"))","v":176}]
["NDI Days Approved For Pay Period:",{"$f":"IF(ENTER!Q22=\"\",\"\",ENTER!Q22)","v":0}]
["Reduced Monthly Gross (Due To Dock Time):",{"$f":"IF(B10=\"\",\"\",SUM(B10*ENTER!Q38)-SUM(B10/B5)*ENTER!Q28)","v":""}]
["Monthly Salary Rate For NDI (Per Timebase): ",{"$f":"IF(ENTER!Q24=\"\",\"\",ENTER!Q24*ENTER!Q38)","v":""}]
["Supp. To Salary (100%):",{"$f":"IF(B8=\"\",\"\",ROUND(ENTER!Q24/B5*ENTER!Q30,2))","v":""}]
["Monthly Salary Rate For Regular Pay:",{"$f":"IF(ENTER!Q26=\"\",\"\",ENTER!Q26)","v":""}]
[""]
["Average Hourly NDI Rate:",{"$f":"IF(B8=\"\",\"\",TRUNC(TRUNC(B8/173.33,4)+0.005,2))","v":""}]
["Monthly NDI Benefit (50%):",{"$f":"IF(B12=\"\",\"\",TRUNC(SUM(B12*40*0.5/7)*B6,2))","v":""}]
[""]
["Regular Pay Gross During NDI Period (Includes Holidays):",{"$f":"IF(B6=\"\",\"\",ROUND(ENTER!Q26/B5*ENTER!Q34,2))","v":0}]
["Regular Pay Gross Outside NDI Period (Includes Holidays):",{"$f":"IF(B6=\"\",\"\",ROUND(ENTER!Q26/B5*ENTER!Q36,2))","v":0}]
["Total Regular Pay Gross For Pay Period:",{"$f":"IF(B15=\"\",\"\",ROUND(SUM(B15+B16),2))","v":0}]
["     Regular & NDI Pay Exceed Gross Pay By:",{"$f":"IF(B13=\"\",\"\",IF(SUM(B13+B17)<=SUM(B10*ENTER!Q38),0,IF(SUM(B13+B17)>SUM(B10*ENTER!Q38),SUM(B13+B17)-SUM(B10*ENTER!Q38))))","v":""}]
["Reduced Monthly NDI Benefit (50%):",{"$f":"IF(B18=\"\",\"\",IF(B18=0,\"N/A\",IF(SUM(B13-B18)<0,0,SUM(B13-B18))))","v":""}]
[""]
["Supplementation Amount:",{"$f":"IF(B9=\"\",\"\",IF(SUM(B9-B13-B15)<0,0,SUM(B9-B13-B15)))","v":""}]
["Total Gross For Pay Period:",{"$f":"IF(B13=\"\",\"\",SUM(B13+B17+B21))","v":""}]
["Amount Exceeding Normal Monthly Salary:",{"$f":"IF(B22=\"\",\"\",IF(B22<B7,0,SUM(B22-B7)))","v":""}]
["Reduced Monthly NDI Benefit (50%):",{"$f":"IF(B23=\"\",\"\",IF(AND(B25=\"N/A\",B23>0),SUM(B13-B23),\"N/A\"))","v":""}]
["Reduced Supplementation Amount:",{"$f":"IF(B21=0,\"N/A\",IF(B21=\"\",\"\",IF(B23=0,\"N/A\",IF(B21<B23,\"N/A\",SUM(B21-B23)))))","v":""}]
["Hourly Rate For Supplementation:",{"$f":"IF(B8=\"\",\"\",ROUND(SUM(ENTER!Q24/B5),2))","v":""}]
["Total Hours Needed To Supplement:",{"$f":"IF(B21=\"\",\"\",IF(OR(B25=\"N/A\",B25<0),ROUND(SUM(B21/B26),0),ROUND(SUM(B25/B26),0)))","v":""}]
["Days Needed To Supplement:",{"$f":"IF(B27=\"\",\"\",IF(ENTER!Q38=2,\"\",(TRUNC(SUM(B27/(SUM(ENTER!Q38*8)))))))","v":""}]
["Hours Needed To Supplement:",{"$f":"IF(B27=\"\",\"\",IF(ENTER!Q38=2,\"\",(B27-(SUM(ENTER!Q38*8)*B28))))","v":""}]
[null,null,null,null,{"$f":"PROPER(A30)","v":""}]
["GO BACK TO ENTER EMPLOYEE INFORMATION"]

{"sheet":"100% & Sal Chg","index":3,"n_rows":31,"n_cols":2,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,1],[30,0,30,1],[31,0,31,1]]}
["100% SUPPLEMENTATION                                                                             AND SALARY CHANGE AT BEGINNING OF THE PAY PERIOD"]
["Employee Name:",{"$f":"ENTER!S14","v":0}]
["Pay Period: ",{"$f":"IF(ENTER!Q20=\"\",\"\",ENTER!Q20)","v":"2023-01-01"}]
["Days In Pay Period:",{"$f":"IF(ENTER!Q32=\"\",\"\",ENTER!Q32)","v":22}]
["Hours In Pay Period:",{"$f":"IF(B4=22,176,IF(B4=21,168,\"\"))","v":176}]
["NDI Days Approved For Pay Period:",{"$f":"IF(ENTER!Q22=\"\",\"\",ENTER!Q22)","v":0}]
["Reduced Monthly Gross (Due To Dock Time):",{"$f":"IF(B10=\"\",\"\",SUM(B10*ENTER!Q38)-SUM(B10/B5)*ENTER!Q28)","v":""}]
["Monthly Salary Rate For NDI (Per Timebase): ",{"$f":"IF(ENTER!Q24=\"\",\"\",ENTER!Q24*ENTER!Q38)","v":""}]
["Supp. To Salary (100%):",{"$f":"IF(B10=\"\",\"\",ROUND(B10/B5*ENTER!Q30,2))","v":""}]
["Monthly Salary Rate For Regular Pay:",{"$f":"IF(ENTER!Q26=\"\",\"\",ENTER!Q26)","v":""}]
[]
["Average Hourly NDI Rate:",{"$f":"IF(B8=\"\",\"\",TRUNC(TRUNC(B8/173.33,4)+0.005,2))","v":""}]
["Monthly NDI Benefit (50%):",{"$f":"IF(B12=\"\",\"\",TRUNC(SUM(B12*40*0.5/7)*B6,2))","v":""}]
[]
["Regular Pay Gross During NDI Period (Includes Holidays):",{"$f":"IF(ENTER!Q26=\"\",\"\",ROUND(ENTER!Q26/B5*ENTER!Q34,2))","v":""}]
["Regular Pay Gross Outside NDI Period (Includes Holidays):",{"$f":"IF(ENTER!Q26=\"\",\"\",ROUND(ENTER!Q26/B5*ENTER!Q36,2))","v":""}]
["Total Regular Pay Gross For Pay Period:",{"$f":"IF(B15=\"\",\"\",ROUND(SUM(B15+B16),2))","v":""}]
["     Regular & NDI Pay Exceed Gross Pay By:",{"$f":"IF(B13=\"\",\"\",IF(SUM(B13+B17)<=SUM(B10*ENTER!Q38),0,IF(SUM(B13+B17)>SUM(B10*ENTER!Q38),SUM(B13+B17)-SUM(B10*ENTER!Q38))))","v":""}]
["Reduced Monthly NDI Benefit (50%):",{"$f":"IF(B18=\"\",\"\",IF(B18=0,\"N/A\",IF(SUM(B13-B18)<0,0,SUM(B13-B18))))","v":""}]
[]
["Supplementation Amount:",{"$f":"IF(B9=\"\",\"\",IF(SUM(B9-B13-B15)<0,0,SUM(B9-B13-B15)))","v":""}]
["Total Gross For Pay Period:",{"$f":"IF(B13=\"\",\"\",SUM(B13+B17+B21))","v":""}]
["Amount Exceeding Normal Monthly Salary:",{"$f":"IF(B22=\"\",\"\",IF(B22<B7,0,SUM(B22-B7)))","v":""}]
["Reduced Monthly NDI Benefit (50%):",{"$f":"IF(B23=\"\",\"\",IF(AND(B25=\"N/A\",B23>0),SUM(B13-B23),\"N/A\"))","v":""}]
["Reduced Supplementation Amount:",{"$f":"IF(B21=0,\"N/A\",IF(B21=\"\",\"\",IF(B23=0,\"N/A\",IF(B21<B23,\"N/A\",SUM(B21-B23)))))","v":""}]
["Hourly Rate For Supplementation:",{"$f":"IF(B8=\"\",\"\",ROUND(SUM(ENTER!Q26/B5),2))","v":""}]
["Total Hours Needed To Supplement:",{"$f":"IF(B21=\"\",\"\",IF(OR(B25=\"N/A\",B25<0),ROUND(SUM(B21/B26),0),ROUND(SUM(B25/B26),0)))","v":""}]
["Days Needed To Supplement:",{"$f":"IF(B27=\"\",\"\",IF(ENTER!Q38=2,\"\",(TRUNC(SUM(B27/(SUM(ENTER!Q38*8)))))))","v":""}]
["Hours Needed To Supplement:",{"$f":"IF(B27=\"\",\"\",IF(ENTER!Q38=2,\"\",(B27-(SUM(ENTER!Q38*8)*B28))))","v":""}]
[]
["GO BACK TO ENTER EMPLOYEE INFORMATION"]

{"sheet":"75%","index":4,"n_rows":32,"n_cols":31,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,1],[31,0,31,1],[32,0,32,1]]}
["75% SUPPLEMENTATION                                                                           "]
["Employee Name:",{"$f":"ENTER!S14","v":0}]
["Pay Period: ",{"$f":"IF(ENTER!Q20=\"\",\"\",ENTER!Q20)","v":"2023-01-01"}]
["Days In Pay Period:",{"$f":"IF(ENTER!Q32=\"\",\"\",ENTER!Q32)","v":22}]
["Hours In Pay Period:",{"$f":"IF(B4=22,176,IF(B4=21,168,\"\"))","v":176}]
["NDI Days Approved For Pay Period:",{"$f":"IF(ENTER!Q22=\"\",\"\",ENTER!Q22)","v":0}]
["Reduced Monthly Gross (Due To Dock Time):",{"$f":"IF(B11=\"\",\"\",SUM(B11*ENTER!Q38)-SUM(B11/B5)*ENTER!Q28)","v":""}]
["Monthly Salary Rate For NDI (Per Timebase): ",{"$f":"IF(ENTER!Q24=\"\",\"\",ENTER!Q24*ENTER!Q38)","v":""}]
["Supp. To Salary (100%):",{"$f":"IF(B8=\"\",\"\",ROUND(ENTER!Q24/B5*ENTER!Q30,2))","v":""}]
["Supp. To Salary (75%):",{"$f":"IF(B9=\"\",\"\",ROUND(SUM(B9*0.75),2))","v":""}]
["Monthly Salary Rate For Regular Pay:",{"$f":"IF(ENTER!Q26=\"\",\"\",ENTER!Q26)","v":""}]
[]
["Average Hourly NDI Rate:",{"$f":"IF(B8=\"\",\"\",TRUNC(TRUNC(B8/173.33,4)+0.005,2))","v":""}]
["Monthly NDI Benefit (50%):",{"$f":"IF(B13=\"\",\"\",TRUNC(SUM(B13*40*0.5/7)*B6,2))","v":""}]
[]
["Regular Pay Gross During NDI Period (Includes Holidays):",{"$f":"IF(ENTER!Q26=\"\",\"\",ROUND(ENTER!Q26/B5*ENTER!Q34,2))","v":""}]
["Regular Pay Gross Outside NDI Period (Includes Holidays):",{"$f":"IF(ENTER!Q26=\"\",\"\",ROUND(ENTER!Q26/B5*ENTER!Q36,2))","v":""}]
["Total Regular Pay Gross For Pay Period:",{"$f":"IF(B16=\"\",\"\",ROUND(SUM(B16+B17),2))","v":""}]
["     Regular & NDI Pay Exceed Gross Pay By:",{"$f":"IF(B18=\"\",\"\",IF(SUM(B14+B18)<=SUM(B11*ENTER!Q38*0.75),0,IF(SUM(B14+B18)>SUM(B11*ENTER!Q38*0.75),SUM(B14+B18)-SUM(B11*ENTER!Q38*0.75))))","v":""}]
["Reduced Monthly NDI Benefit (50%):",{"$f":"IF(B19=\"\",\"\",IF(B19=0,\"N/A\",IF(SUM(B14-B19)<0,0,SUM(B14-B19))))","v":""}]
[]
["Supplementation Amount:",{"$f":"IF(B10=\"\",\"\",IF(SUM(B10-B14-B16)<0,0, SUM(B10-B14-B16)))","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,{"$f":"B22","v":""},"div",{"$f":"B27","v":""},{"$f":"ROUNDUP(SUM(AB22/AD22),4)","v":{"$error":"#VALUE!"}}]
["Total Gross For Pay Period:",{"$f":"IF(B14=\"\",\"\",SUM(B14+B18+B22))","v":""}]
["Amount Exceeding Normal Monthly Salary:",{"$f":"IF(B23=\"\",\"\",IF(B23<B7,0,SUM(B23-B7)))","v":""}]
["Reduced Monthly NDI Benefit (50%):",{"$f":"IF(B24=\"\",\"\",IF(AND(B26=\"N/A\",B24>0),SUM(B14-B24),\"N/A\"))","v":""}]
["Reduced Supplementation Amount:",{"$f":"IF(B22=0,\"N/A\",IF(B22=\"\",\"\",IF(B24=0,\"N/A\",IF(B22<B24,\"N/A\",SUM(B22-B24)))))","v":""}]
["Hourly Rate For Supplementation:",{"$f":"IF(B8=\"\",\"\",ROUND(SUM(ENTER!Q24/B5),2))","v":""}]
["Total Hours Needed To Supplement:",{"$f":"IF(B22=\"\",\"\",IF(OR(B26=\"N/A\",B26<0),ROUND(SUM(B22/B27),0),ROUND(SUM(B26/B27),0)))","v":""}]
["Days Needed To Supplement:",{"$f":"IF(B28=\"\",\"\",IF(ENTER!Q38=2, \"\",(TRUNC(SUM(B28/(SUM(ENTER!Q38*8)))))))","v":""}]
["Hours Needed To Supplement:",{"$f":"IF(B28=\"\",\"\",IF(ENTER!Q38=2,\"\",(B28-(SUM(ENTER!Q38*8)*B29))))","v":""}]
[]
["GO BACK TO ENTER EMPLOYEE INFORMATION"]

{"sheet":"75% & Sal Chg","index":5,"n_rows":32,"n_cols":31,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,1],[31,0,31,1],[32,0,32,1]]}
["75% SUPPLEMENTATION                                                                                      AND SALARY CHANGE AT BEGINNING OF THE PAY PERIOD"]
["EMPLOYEE NAME:",{"$f":"ENTER!S14","v":0}]
["Pay Period: ",{"$f":"IF(ENTER!Q20=\"\",\"\",ENTER!Q20)","v":"2023-01-01"}]
["Days In Pay Period:",{"$f":"IF(ENTER!Q32=\"\",\"\",ENTER!Q32)","v":22}]
["Hours In Pay Period:",{"$f":"IF(B4=22,176,IF(B4=21,168,\"\"))","v":176}]
["NDI Days Approved For Pay Period:",{"$f":"IF(ENTER!Q22=\"\",\"\",ENTER!Q22)","v":0}]
["Reduced Monthly Gross (Due To Dock Time):",{"$f":"IF(B11=\"\",\"\",SUM(B11*ENTER!Q38)-SUM(B11/B5)*ENTER!Q28)","v":""}]
["Monthly Salary Rate For NDI (Per Timebase): ",{"$f":"IF(ENTER!Q24=\"\",\"\",ENTER!Q24*ENTER!Q38)","v":""}]
["Supp. To Salary (100%):",{"$f":"IF(B11=\"\",\"\",ROUND(B11/B5*ENTER!Q30,2))","v":""}]
["Supp. To Salary (75%):",{"$f":"IF(B9=\"\",\"\",SUM(B9*0.75))","v":""}]
["Monthly Salary Rate For Regular Pay:",{"$f":"IF(ENTER!Q26=\"\",\"\",ENTER!Q26)","v":""}]
[]
["Average Hourly NDI Rate:",{"$f":"IF(B8=\"\",\"\",TRUNC(TRUNC(B8/173.33,4)+0.005,2))","v":""}]
["Monthly NDI Benefit (50%):",{"$f":"IF(B13=\"\",\"\",TRUNC(SUM(B13*40*0.5/7)*B6,2))","v":""}]
[]
["Regular Pay Gross During NDI Period (Includes Holidays):",{"$f":"IF(B6=\"\",\"\",ROUND(ENTER!Q26/B5*ENTER!Q34,2))","v":0}]
["Regular Pay Gross Outside NDI Period (Includes Holidays):",{"$f":"IF(B6=\"\",\"\",ROUND(ENTER!Q26/B5*ENTER!Q36,2))","v":0}]
["Total Regular Pay Gross For Pay Period:",{"$f":"IF(B16=\"\",\"\",ROUND(SUM(B16+B17),2))","v":0}]
["     Regular & NDI Pay Exceed Gross Pay By:",{"$f":"IF(B14=\"\",\"\",IF(SUM(B14+B18)<=SUM(B11*ENTER!Q38*0.75),0,IF(SUM(B14+B18)>SUM(B11*ENTER!Q38*0.75),SUM(B14+B18)-SUM(B11*ENTER!Q38*0.75))))","v":""}]
["Reduced Monthly NDI Benefit (50%):",{"$f":"IF(B19=\"\",\"\",IF(B19=0,\"N/A\",IF(SUM(B14-B19)<0,0,SUM(B14-B19))))","v":""}]
[]
["Supplementation Amount:",{"$f":"IF(B10=\"\",\"\",IF(SUM(B10-B14-B16)<0,0, SUM(B10-B14-B16)))","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,{"$f":"B22","v":""},"div",{"$f":"B27","v":""},{"$f":"ROUNDUP(SUM(AB22/AD22),4)","v":{"$error":"#VALUE!"}}]
["Total Gross For Pay Period:",{"$f":"IF(B14=\"\",\"\",SUM(B14+B18+B22))","v":""}]
["Amount Exceeding Normal Monthly Salary:",{"$f":"IF(B23=\"\",\"\",IF(B23<B7,0,SUM(B23-B7)))","v":""}]
["Reduced Monthly NDI Benefit (50%):",{"$f":"IF(B24=\"\",\"\",IF(AND(B26=\"N/A\",B24>0),SUM(B14-B24),\"N/A\"))","v":""}]
["Reduced Supplementation Amount:",{"$f":"IF(B22=0,\"N/A\",IF(B22=\"\",\"\",IF(B24=0,\"N/A\",IF(B22<B24,\"N/A\",SUM(B22-B24)))))","v":""}]
["Hourly Rate For Supplementation:",{"$f":"IF(B8=\"\",\"\",ROUND(SUM(ENTER!Q26/B5),2))","v":""}]
["Total Hours Needed To Supplement:",{"$f":"IF(B22=\"\",\"\",IF(OR(B26=\"N/A\",B26<0),ROUND(SUM(B22/B27),0),ROUND(SUM(B26/B27),0)))","v":""}]
["Days Needed To Supplement:",{"$f":"IF(B28=\"\",\"\",IF(ENTER!Q38=2, \"\",(TRUNC(SUM(B28/(SUM(ENTER!Q38*8)))))))","v":""}]
["Hours Needed To Supplement:",{"$f":"IF(B28=\"\",\"\",IF(ENTER!Q38=2,\"\",(B28-(SUM(ENTER!Q38*8)*B29))))","v":""}]
[]
["GO BACK TO ENTER EMPLOYEE INFORMATION"]

{"sheet":"50%","index":6,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,1],[21,0,21,1],[22,0,22,1]]}
["NDI (50%) ONLY -  NO SUPPLEMENTATION                                                                             "]
["Employee Name:",{"$f":"ENTER!S14","v":0}]
["Pay Period: ",{"$f":"IF(ENTER!Q20=\"\",\"\",ENTER!Q20)","v":"2023-01-01"}]
["Days In Pay Period:",{"$f":"IF(ENTER!Q32=\"\",\"\",ENTER!Q32)","v":22}]
["Hours In Pay Period:",{"$f":"IF(B4=22,176,IF(B4=21,168,\"\"))","v":176}]
["NDI Days Approved For Pay Period:",{"$f":"IF(ENTER!Q22=\"\",\"\",ENTER!Q22)","v":0}]
["Reduced Monthly Gross (Due To Dock Time):",{"$f":"IF(B9=\"\",\"\",SUM(B9*ENTER!Q38)-SUM(B9/B5)*ENTER!Q28)","v":""}]
["Monthly Salary Rate For NDI (Per Timebase): ",{"$f":"IF(ENTER!Q24=\"\",\"\",ENTER!Q24*ENTER!Q38)","v":""}]
["Monthly Salary Rate For Regular Pay:",{"$f":"IF(ENTER!Q26=\"\",\"\",ENTER!Q26)","v":""}]
[]
["Regular Pay Gross During NDI Period (Includes Holidays):",{"$f":"IF(ENTER!Q26=\"\",\"\",ROUND(ENTER!Q26/B5*ENTER!Q34,2))","v":""}]
["Regular Pay Gross Outside NDI Period (Includes Holidays):",{"$f":"IF(ENTER!Q26=\"\",\"\",ROUND(ENTER!Q26/B5*ENTER!Q36,2))","v":""}]
["Total Regular Pay Gross For Pay Period:",{"$f":"IF(B11=\"\",\"\",ROUND(SUM(B11+B12),2))","v":""}]
[]
["Average Hourly NDI Rate:",{"$f":"IF(B8=\"\",\"\",TRUNC(TRUNC(B8/173.33,4)+0.005,2))","v":""}]
["Monthly NDI Benefit (50%):",{"$f":"IF(B15=\"\",\"\",TRUNC(SUM(B15*40*0.5/7)*B6,2))","v":""}]
[]
["Total Gross For Pay Period:",{"$f":"IF(B13=\"\",\"\",SUM(B13+B16))","v":""}]
["Amount Exceeding Normal Monthly Salary:",{"$f":"IF(B18=\"\",\"\",IF(B18<B7,0,SUM(B18-B7)))","v":""}]
["Reduced Monthly NDI Benefit (50%):",{"$f":"IF(B19=\"\",\"\",IF(B19=0,\"N/A\",IF(SUM(B16-B19)<0,0,SUM(B16-B19))))","v":""}]
[]
["GO BACK TO ENTER EMPLOYEE INFORMATION"]

{"sheet":"674DInfo","index":7,"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":"ENTER!Q18","v":0}]
["SSN",null,{"$f":"ENTER!Q16","v":0}]
["FIRST INITIAL",null,{"$f":"LEFT(ENTER!BA35,1)","v":""}]
["MIDDLE INITIAL",null,{"$f":"LEFT(ENTER!BA36,1)","v":""},null,null,"dashes"]
["LAST NAME",null,{"$f":"ENTER!BA37","v":""},null,"16 chars?","4th char","8th char","13th char","Agency","Unit","Class","Serial"]
["POSITION NUMBER #1",null,{"$f":"IF(CONCATENATE(ENTER!AA2,\"-\",ENTER!AC2,\"-\",ENTER!AE2,\"-\",ENTER!AH2)=\"---\",\"\",CONCATENATE(ENTER!AA2,\"-\",ENTER!AC2,\"-\",ENTER!AE2,\"-\",ENTER!AH2))","v":""},{"$f":"IF(C10=\"\",\"\",IF(B33,C33,\"\"))","v":""},{"$f":"IF(LEN(C10)=16,TRUE,FALSE)","v":false},{"$f":"IF(MID(C10,4,1)=\"-\",TRUE, FALSE)","v":false},{"$f":"IF(MID(C10,8,1)=\"-\",TRUE, FALSE)","v":false},{"$f":"IF(MID(C10,13,1)=\"-\",TRUE, FALSE)","v":false},{"$f":"MID(C10,1,3)","v":""},{"$f":"MID(C10,5,3)","v":""},{"$f":"MID(C10,9,4)","v":""},{"$f":"MID(C10,14,3)","v":""}]
["POSITION NUMBER #2",null,{"$f":"IF(CONCATENATE(ENTER!AA3,\"-\",ENTER!AC3,\"-\",ENTER!AE3,\"-\",ENTER!AH3)=\"---\",\"\",CONCATENATE(ENTER!AA3,\"-\",ENTER!AC3,\"-\",ENTER!AE3,\"-\",ENTER!AH3))","v":""},{"$f":"IF(C11=\"\",\"\",IF(B34,C34,\"\"))","v":""},{"$f":"IF(LEN(C11)=16,TRUE,FALSE)","v":false},{"$f":"IF(MID(C11,4,1)=\"-\",TRUE, FALSE)","v":false},{"$f":"IF(MID(C11,8,1)=\"-\",TRUE, FALSE)","v":false},{"$f":"IF(MID(C11,13,1)=\"-\",TRUE, FALSE)","v":false},{"$f":"MID(C11,1,3)","v":""},{"$f":"MID(C11,5,3)","v":""},{"$f":"MID(C11,9,4)","v":""},{"$f":"MID(C11,14,3)","v":""}]
["PAY PERIOD","Type"]
[null,"Month",{"$f":"MONTH([0]!PayPeriod)","v":1}]
[null,"Year",{"$f":"YEAR(PayPeriod)","v":2023},null,null,null,null,"Supplimentation Levels:",null,null,"Timebase Fraction"]
["SUPPLEMENTATION LEVEL",null,{"$f":"ENTER!Q42","v":0},null,null,null,null,75,null,null,1]
["TIMEBASE FRACTION",null,{"$f":"TimeBase","v":1},null,null,null,null,100,null,null,0.2]
["EMPLOYEE ON NDI","From",{"$f":"FirstDay","v":""},null,null,null,null,null,null,null,0.4]
[null,"To",{"$f":"LastDay","v":""},{"$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":"#N/A"}},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":"#N/A"}},null,"Hours>8?",{"$f":"IF(C22>=8,TRUE, FALSE)","v":{"$error":"#N/A"}},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":"'ENTER'!A28:B30"},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":true},"Invalid position number. Example: 051-220-1337-930"]
["Position #2",{"$f":"IF(AND(E11,F11, G11, H11), FALSE,TRUE)","v":true},"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."]

{"sheet":"674D","index":8,"n_rows":65,"n_cols":53,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,23,2,24],[62,0,63,54],[64,0,65,54],[21,31,22,33],[20,1,21,2],[20,4,21,15],[18,41,20,54],[21,45,22,47],[21,28,22,30],[18,28,20,30],[54,40,55,54],[57,40,57,54],[21,22,22,23],[21,20,22,21],[18,22,20,23],[23,11,24,16],[46,20,47,25],[46,31,47,33],[46,28,47,30],[59,40,59,54],[35,13,36,17],[18,38,20,38],[21,38,22,38],[27,20,28,21],[29,24,29,25],[15,0,15,18],[16,26,17,27],[17,28,17,30],[13,0,13,1],[15,40,15,54],[13,23,13,24],[13,21,13,22],[17,8,17,13],[17,22,17,23],[17,20,17,21],[17,24,17,25],[15,20,15,38],[17,15,17,18],[13,5,13,6],[13,2,13,4],[16,8,16,13],[16,15,16,18],[32,34,33,38],[49,34,50,38],[49,31,50,33],[42,20,43,25],[17,31,17,33],[16,38,17,38],[16,34,17,37],[16,28,16,33],[18,31,20,33],[16,20,16,25],[36,31,38,33],[42,31,43,33],[42,34,43,38],[27,24,28,25],[23,38,24,38],[25,38,26,38],[29,22,29,23],[29,20,29,21],[34,34,35,38],[36,34,38,38],[36,26,38,27],[36,28,38,30],[27,34,28,37],[29,28,29,30],[21,42,22,44],[56,9,56,15],[45,52,46,54],[48,40,48,54],[42,5,43,6],[33,0,36,0],[23,0,24,0],[23,31,24,33],[32,26,33,27],[32,28,33,33],[25,28,26,30],[23,28,24,30],[29,31,29,33],[27,31,28,33],[25,31,26,33],[40,1,41,2],[29,26,29,27],[27,26,28,27],[27,38,28,38],[56,34,56,38],[54,34,55,38],[54,31,55,33],[54,28,55,30],[34,31,35,33],[12,5,12,6],[25,34,26,37],[23,34,24,37],[21,34,22,37],[25,26,26,27],[5,52,5,54],[5,48,5,51],[5,45,5,47],[5,42,5,44],[6,45,7,47],[6,42,7,44],[8,42,8,44],[8,45,8,47],[8,27,8,28],[8,52,8,54],[8,48,8,51],[6,41,7,41],[6,52,7,54],[6,48,7,51],[8,29,8,38],[7,27,7,28],[8,0,8,6],[20,0,21,0],[12,2,12,4],[53,1,54,2],[48,8,48,13],[48,15,48,18],[51,26,53,27],[51,20,53,25],[23,22,24,23],[23,20,24,21],[32,20,33,25],[36,20,38,25],[25,22,26,23],[25,20,26,21],[48,20,48,25],[30,20,31,38],[49,8,50,13],[49,15,50,18],[54,26,55,27],[54,20,55,25],[29,34,29,37],[51,34,53,38],[51,31,53,33],[34,20,35,25],[34,28,35,30],[27,28,28,30],[27,22,28,23],[12,0,12,1],[18,24,20,25],[8,8,8,23],[11,9,11,54],[13,30,13,31],[12,30,12,31],[13,50,13,51],[12,50,12,51],[12,39,12,40],[13,26,13,27],[12,26,12,27],[8,25,8,26],[12,23,12,24],[12,21,12,22],[12,10,12,11],[13,10,13,11],[12,12,12,14],[13,12,13,14],[12,19,12,20],[13,19,13,20],[13,39,13,40],[10,0,10,6],[20,3,21,3],[18,34,20,37],[33,1,36,12],[23,26,24,27],[21,26,22,27],[18,26,20,27],[18,20,20,21],[23,1,24,10],[25,24,26,25],[23,24,24,25],[21,24,22,25],[31,8,32,13],[31,15,32,18],[35,40,42,54],[51,40,52,44],[51,45,52,54],[49,28,50,30],[49,26,50,27],[49,20,50,25],[44,28,45,30],[44,31,45,33],[44,34,45,38],[51,28,53,30],[34,26,35,27],[48,34,48,38],[48,31,48,33],[48,28,48,30],[48,26,48,27],[39,34,41,38],[39,31,41,33],[39,28,41,30],[39,26,41,27],[39,20,41,25],[42,26,43,27],[42,28,43,30],[45,40,46,50],[59,34,59,38],[59,31,59,33],[59,28,59,30],[59,26,59,27],[59,20,59,25],[43,52,43,54],[46,34,47,38],[46,26,47,27],[44,20,45,25],[44,26,45,27],[57,20,57,25],[57,26,57,27],[57,28,57,30],[57,31,57,33],[57,34,57,38],[58,20,58,25],[58,26,58,27],[58,28,58,30],[58,31,58,33],[58,34,58,38],[56,20,56,25],[56,26,56,27],[56,28,56,30],[56,31,56,33]]}
["STATE OF CALIFORNIA - CONTROLLER'S OFFICE"]
["INDUSTRIAL/NON-INDUSTRIAL DISABILITY/STATE DISABILITY PAY/ADJUSTEMENT REQUEST",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DOCUMENT NUMBER _______ OF _______"]
["STD. 674D (REV. 3/2022)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Amended",null,null,null,null,null,null,"Inquiry",null,null,null,null,"Separated"]
[]
["TO:  STATE CONTROLLER - PPSD / DISABILITY UNIT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.  POSITION NUMBER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AGENCY",null,null,"UNIT",null,null,"CLASS",null,null,null,"SERIAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.",{"$f":"ENTER!AA2","v":0},null,null,{"$f":"'674DInfo'!J10","v":""},null,null,{"$f":"'674DInfo'!K10","v":""},null,null,null,{"$f":"'674DInfo'!L10","v":""}]
["1.  CBID",null,null,null,null,null,null,null,"2.  SOCIAL SECURITY NUMBER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3. F.I.",null,"M.I.",null,"LAST NAME"]
[{"$f":"IF('674DInfo'!C5=\"\",\"\",UPPER('674DInfo'!C5))","v":"0"},null,null,null,null,null,null,null,{"$f":"IF('674DInfo'!C6=\"\",\"\",'674DInfo'!C6)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('674DInfo'!C7=\"\",\"\",UPPER('674DInfo'!C7))","v":""},null,{"$f":"IF('674DInfo'!C8=\"\",\"-\",UPPER('674DInfo'!C8))","v":"-"},null,{"$f":"IF('674DInfo'!C9=\"\",\"\",UPPER('674DInfo'!C9))","v":""},null,null,null,null,null,null,null,null,null,null,null,"2.",{"$f":"'674DInfo'!I11","v":""},null,null,{"$f":"'674DInfo'!J11","v":""},null,null,{"$f":"'674DInfo'!K11","v":""},null,null,null,{"$f":"'674DInfo'!L11","v":""}]
[]
["5. PAY  PERIOD",null,null,null,null,null,null,null,"6. ENTER NUMBER OF HOURS AND CODE",null,null,null,null,null,null,null,null,null,null,null,"Intervening activity/working while on Disability [W=Worked or leave used; C=Industrial Disability (IDL); L=Dock during the regular period of pay; F=NDI-FCL]"]
[null,null,null,null,null,null,null,null,null,"Please complete if employee is on alternate work schedule before, during, and after Disability."]
["T",null,"MO",null,null,"YR",null,null,null,{"$f":"ENTER!D6","v":1},{"$f":"ENTER!E6","v":2},null,{"$f":"ENTER!F6","v":3},null,null,{"$f":"ENTER!G6","v":4},{"$f":"ENTER!H6","v":5},{"$f":"ENTER!I6","v":6},{"$f":"ENTER!J6","v":7},{"$f":"ENTER!K6","v":8},null,{"$f":"ENTER!L6","v":9},null,{"$f":"ENTER!M6","v":10},null,{"$f":"ENTER!N6","v":11},{"$f":"ENTER!O6","v":12},null,{"$f":"ENTER!P6","v":13},{"$f":"ENTER!Q6","v":14},{"$f":"ENTER!R6","v":15},null,{"$f":"ENTER!S6","v":16},{"$f":"ENTER!T6","v":17},{"$f":"ENTER!U6","v":18},{"$f":"ENTER!V6","v":19},{"$f":"ENTER!W6","v":20},{"$f":"ENTER!X6","v":21},{"$f":"ENTER!Y6","v":22},{"$f":"ENTER!Z6","v":23},null,{"$f":"ENTER!AA6","v":24},{"$f":"ENTER!AB6","v":25},{"$f":"ENTER!AC6","v":26},{"$f":"ENTER!AD6","v":27},{"$f":"ENTER!AE6","v":28},{"$f":"ENTER!AF6","v":29},{"$f":"ENTER!AG6","v":30},{"$f":"ENTER!AH6","v":31},{"$f":"ENTER!AI6","v":""}]
[{"$f":"IF('674DInfo'!C12=\"\",\"\",'674DInfo'!C12)","v":""},null,{"$f":"IF('674DInfo'!C13=\"\",\"\",'674DInfo'!C13)","v":1},null,null,{"$f":"IF('674DInfo'!C14=\"\",\"\",'674DInfo'!C14)","v":2023},null,null,null,null,"\r\nH8",null,"\r\nW8",null,null,"\r\nW8","\r\nW8","\r\nW8",null,null,null,"\r\nW8",null,"\r\nW8",null,"\r\nW8","\r\nW8",null,"\r\nW8",null,null,null,"\r\nH8","\r\nW8","\r\nW8","\r\nW8","\r\nW8",null,null,"\r\nW8",null,"\r\nW8","\r\nW8","\r\nW8","\r\nW8",null,null,"\r\nW8","\r\nW8"]
[]
["7.  INDUSTRIAL DISABILITY (IDL)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9.  PAYMENT PER CONTROLLER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11.  ADDITIONAL INFORMATION"]
["a. ","EMPLOYEE ON IDL",null,null,null,null,null,null,"FROM:",null,null,null,null,null,null,"THROUGH:",null,null,null,null,"ISSUE DATE",null,null,null,null,null,"PT",null,"TIME WORKED",null,null,null,null,null,"WARRANT OR\nA/R NUMBER",null,null,null,"RET"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MO",null,"DY",null,"YR",null,null,null,"DAYS",null,null,"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,"EMPLOYEE SUPPLEMENTING UP TO "]
[]
["b.",null,null,null,"EMPLOYEE ENTITLED TO ENHANCED IDL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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('674DInfo'!C15=\"\",\"\",'674DInfo'!C15)","v":0},null,null,"LEVEL."]
[]
["c.","AVERAGE HOURS COMPUTED\nFOR INTERMITTENT EMPLOYEE:"]
[]
[]
[]
["8A. NON-INDUSTRIAL DISABILITY (NDI)"]
[]
["a. ","EMPLOYEE ON NDI",null,null,null,null,null,null,"a.1",{"$f":"IF(ENTER!Q44=\"Yes\",\"X\",\"\")","v":""}," NDI-FCL"]
[null,null,null,null,null,null,null,null,null,"FROM:",null,null,null,null,null,null,"THROUGH:",null,null,null,"10.  PAYMENT SHOULD BE"]
[null,null,null,null,null,null,null,null,{"$f":"IF('674DInfo'!C17=\"\",\"\",'674DInfo'!C17)","v":""},null,null,null,null,null,null,{"$f":"IF('674DInfo'!C18=\"\",\"\",'674DInfo'!C18)","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,"TIME WORKED"]
["b.\n\n","AVERAGE HOURS WORKED DURING\nPREVIOUS 18 MONTHS FOR\nINTERMITTENT EMPLOYEE WAS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TYPE",null,null,null,null,null,"PT",null,"DAYS",null,null,"HOURS",null,null,"TIMEBASE FRACTION"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('674DInfo'!C19=\"\",\"\",'674DInfo'!C19)","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,"I hereby certify that the employee named above is entitled to this pay based on the appropriate government codes and/or employee has been notified of the impending account receivable. Prior ro submitting this STD 674D, the employee was given a reasonable time to respond."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REGULAR",null,null,null,null,null,0,null,{"$f":"IF(ENTER!Q34=\"\",\"\",TRUNC(SUM(ENTER!Q34+ENTER!Q36)/SUM(ENTER!Q38*8),0))","v":22},null,null,{"$f":"IF(ENTER!Q34=\"\",\"\",(ENTER!Q34+ENTER!Q36)-(ENTER!Q38*8*AC37))","v":0},null,null,{"$f":"IF('674DInfo'!C16=\"\",\"\",'674DInfo'!C16)","v":1}]
[]
[]
[]
[null,"X"]
["c.",null,null,null,"EMPLOYEE ON ANNUAL LEAVE PROGRAM"]
[null,null,null,null,null,{"$f":"IF('674DInfo'!C15=\"\",\"\",'674DInfo'!C15)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SUPPLEMENTAL",null,null,null,null,null,null,null,{"$f":"IF('674DInfo'!C21=\"\",\"\",'674DInfo'!C21)","v":{"$error":"#N/A"}},null,null,{"$f":"IF('674DInfo'!C22=\"\",\"\",'674DInfo'!C22)","v":{"$error":"#N/A"}},null,null,{"$f":"IF('674DInfo'!C16=\"\",\"\",'674DInfo'!C16)","v":1}]
[null,"ELECTED",null,null,null,null,null," SUPPLEMENTATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12.  AUTHORIZED SIGNATURE",null,null,null,null,null,null,null,null,null,null,null,"DATE SIGNED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NDI",null,null,null,null,null,"T",null,{"$f":"IF(ENTER!Q22=\"\",\"\",ENTER!Q22)","v":0},null,null,null,null,null,{"$f":"IF('674DInfo'!C16=\"\",\"\",'674DInfo'!C16)","v":1}]
[]
["8B. STATE DISABILITY INSURANCE (SDI)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IDL FULL",null,null,null,null,null,6]
[]
["a.","EMPLOYEE ON SDI",null,null,null,null,null,null,"FROM:",null,null,null,null,null,null,"THROUGH:",null,null,null,null,"IDL 2/3",null,null,null,null,null,"N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IDL / S",null,null,null,null,null,"U",null,null,null,null,null,null,null,null,null,null,null,null,null,"(PRINT OR TYPE NAME)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SHIFT",null,null,null,null,null,null,null,"SHIFT\nCODE",null,null,"HOURS",null,null,"SHIFT RATE",null,null,null,null,null,"13.  CONTACT PERSON",null,null,null,null,"  (If other than authorized signature)"]
[]
[]
["b.",null,null,null,"EMPLOYEE ELECTED SUPPLEMENTATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REGULAR",null,null,null,null,null,2]
[]
["c.","SDI WEEKLY RATE: $",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IDL FULL",null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,"14.  TELEPHONE NUMBER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IDL 2/3",null,null,null,null,null,"N",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('674DInfo'!C24=\"\",\"\",'674DInfo'!C24)","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,"15. EMAIL ADDRESS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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('674DInfo'!C25=\"\",\"\",'674DInfo'!C25)","v":""}]
[]
[]
[]
[]
["Go to Enter Employee Information"]