{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["FED Leave Calc"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"FED Leave Calc","index":0,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Federal Emergency Paid Sick Leave\nCalculator to Determine Leave Needed to Supplement 2/3 Pay\nEnter Information in the Highlighted Cells"]
[]
["Enter Total Hourly Rate (Base Pay + Add-ons)"]
["Enter Normally Scheduled Hours for the Day"]
[]
["Total Daily Regular Rate of Pay (hourly rate x normally scheduled hours)",{"$f":"B3*B4","v":0}]
[]
["Enter Total Hours Worked\n(if using other paid leave during the day, but are NOT using it to supplement your Federal Emergency Sick Leave, include those hours here too)",0]
["Enter Total Hours of Federal Emergency Sick Leave Used (paid at 2/3 of Regular Rate, up to $200/day)",0]
[]
["Estimated Total Pay for Day if No Supplemental Leave Used",{"$f":"ROUNDUP(B3*B8,2)+MIN(ROUNDUP(0.6667*B3*B9,2),200)","v":0},{"$f":"IF((B8+B9)>B4, \"Total Hours Worked + Total Hours of Emergency Sick Leave are greater than your normally scheduled hours for the day.  Please adjust.\", \"\")","v":""}]
[]
["Supplemental Leave Hours Needed to Fully Attain Total Regular Pay for the Day",{"$f":"IF(OR(B3=0,B4=0),0,IF(AND(B8=0,B9=0),0,IF((B6-B11)/B3<0,0,ROUNDUP((B6-B11)/B3,2))))","v":0}]
[]
["Enter the Number of Supplemental Leave Hours You Choose to Use for the Day\nMay not exceed the calculated amount shown in the cell above",0]
[]
["Estimated Total Amount to be Paid (hours worked + federal emergency sick leave + supplemental leave). ",{"$f":"(B3*B8)+MIN(ROUNDUP(B3*0.6667*B9,2),200)+(B15*B3)","v":0},"Actual pay may differ slightly due to rounding."]
[null,{"$f":"MAX(B17-B6,0)","v":0},"Amount over regular pay. Permitted only for the smallest leave increment needed to reach at least regular pay."]
[null,{"$f":"IF(OR(B3=0,B4=0),0,IF(AND(B8=0,B9=0),0,MAX(B6-B17,0)))","v":0},"Amount under regular pay.  Partial supplementation is permitted."]