{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Biweekly time sheet"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Biweekly time sheet","index":0,"n_rows":31,"n_cols":9,"rows_kept":31,"merged":[[3,2,3,6],[3,7,3,8],[4,4,4,5],[5,4,5,5],[6,4,6,5]]}
[]
[null,null,"Dream Pipes Plumbing",{"$nulls":5},"333 3rd Avenue, Seattle, WA 89101"]
[]
[]
[null,null,"Employee: ",null,"Luca Richter",null,"Employee phone:",null,"640-555-0164"]
[null,null,"Employee e-mail:",null,"luca@example.com",null,"Pay period start date:",null,{"$f":"TODAY()","v":"2023-10-09"}]
[null,null,"Manager:",null,"Elizabeth Moore",null,"Pay period end date:",null,{"$f":"IF($I$6=\"\",\"\",$I$6+13)","v":"2023-10-22"}]
[]
[null,null,"Day","Date","Regular hours","Overtime hours","Sick","Vacation","Total"]
[null,null,{"$f":"IF($I$6=\"\",\"\",TEXT(TimeSheet[[#This Row],[Date]],\"aaaa\"))","v":"Monday"},{"$f":"I6","v":"2023-10-09"},{"v":8,"d":"8.00"},{"$nulls":3},{"$f":"IFERROR(SUM(E10:H10), \"\")","v":{"v":8,"d":"8.00"}}]
[null,null,{"$f":"IF($I$6=\"\",\"\",TEXT(TimeSheet[[#This Row],[Date]],\"aaaa\"))","v":"Tuesday"},{"$f":"IF($I$6=\"\",\"\",$I$6+1)","v":"2023-10-10"},{"v":8,"d":"8.00"},{"v":2,"d":"2.00"},null,null,{"$f":"IFERROR(SUM(E11:H11), \"\")","v":{"v":10,"d":"10.00"}}]
[null,null,{"$f":"IF($I$6=\"\",\"\",TEXT(TimeSheet[[#This Row],[Date]],\"aaaa\"))","v":"Wednesday"},{"$f":"IF($I$6=\"\",\"\",$I$6+2)","v":"2023-10-11"},null,null,{"v":8,"d":"8.00"},null,{"v":8,"d":"8.00"}]
[null,null,{"$f":"IF($I$6=\"\",\"\",TEXT(TimeSheet[[#This Row],[Date]],\"aaaa\"))","v":"Thursday"},{"$f":"IF($I$6=\"\",\"\",$I$6+3)","v":"2023-10-12"},{"$nulls":3},{"v":8,"d":"8.00"},{"v":8,"d":"8.00"}]
[null,null,{"$f":"IF($I$6=\"\",\"\",TEXT(TimeSheet[[#This Row],[Date]],\"aaaa\"))","v":"Friday"},{"$f":"IF($I$6=\"\",\"\",$I$6+4)","v":"2023-10-13"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,null,{"$f":"IF($I$6=\"\",\"\",TEXT(TimeSheet[[#This Row],[Date]],\"aaaa\"))","v":"Saturday"},{"$f":"IF($I$6=\"\",\"\",$I$6+5)","v":"2023-10-14"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,null,{"$f":"IF($I$6=\"\",\"\",TEXT(TimeSheet[[#This Row],[Date]],\"aaaa\"))","v":"Sunday"},{"$f":"IF($I$6=\"\",\"\",$I$6+6)","v":"2023-10-15"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,null,{"$f":"IF($I$6=\"\",\"\",TEXT(TimeSheet[[#This Row],[Date]],\"aaaa\"))","v":"Monday"},{"$f":"IF($I$6=\"\",\"\",$I$6+7)","v":"2023-10-16"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,null,{"$f":"IF($I$6=\"\",\"\",TEXT(TimeSheet[[#This Row],[Date]],\"aaaa\"))","v":"Tuesday"},{"$f":"IF($I$6=\"\",\"\",$I$6+8)","v":"2023-10-17"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,null,{"$f":"IF($I$6=\"\",\"\",TEXT(TimeSheet[[#This Row],[Date]],\"aaaa\"))","v":"Wednesday"},{"$f":"IF($I$6=\"\",\"\",$I$6+9)","v":"2023-10-18"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,null,{"$f":"IF($I$6=\"\",\"\",TEXT(TimeSheet[[#This Row],[Date]],\"aaaa\"))","v":"Thursday"},{"$f":"IF($I$6=\"\",\"\",$I$6+10)","v":"2023-10-19"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,null,{"$f":"IF($I$6=\"\",\"\",TEXT(TimeSheet[[#This Row],[Date]],\"aaaa\"))","v":"Friday"},{"$f":"IF($I$6=\"\",\"\",$I$6+11)","v":"2023-10-20"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,null,{"$f":"IF($I$6=\"\",\"\",TEXT(TimeSheet[[#This Row],[Date]],\"aaaa\"))","v":"Saturday"},{"$f":"IF($I$6=\"\",\"\",$I$6+12)","v":"2023-10-21"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,null,{"$f":"IF($I$6=\"\",\"\",TEXT(TimeSheet[[#This Row],[Date]],\"aaaa\"))","v":"Sunday"},{"$f":"IF($I$6=\"\",\"\",$I$6+13)","v":"2023-10-22"},{"$nulls":4},{"v":0,"d":"0.00"}]
[{"$nulls":3},"Total",{"$f":"SUBTOTAL(109,TimeSheet[Regular hours])","v":{"v":16,"d":"16.00"}},{"$f":"SUBTOTAL(109,TimeSheet[Overtime hours])","v":{"v":2,"d":"2.00"}},{"$f":"SUBTOTAL(109,TimeSheet[Sick])","v":{"v":8,"d":"8.00"}},{"$f":"SUBTOTAL(109,TimeSheet[Vacation])","v":{"v":8,"d":"8.00"}},{"$f":"SUBTOTAL(109,TimeSheet[Total])","v":{"v":34,"d":"34.00"}}]
[{"$nulls":3},"Rate per hour",{"v":10,"d":"$10.00"},{"$f":"E25*1.5","v":{"v":15,"d":"$15.00"}},{"$f":"E25","v":{"v":10,"d":"$10.00"}},{"$f":"E25","v":{"v":10,"d":"$10.00"}}]
[{"$nulls":3},"Total pay",{"$f":"IFERROR(SUM(E25*TimeSheet[[#Totals],[Regular hours]]), \"\")","v":{"v":160,"d":"$160.00"}},{"$f":"IFERROR(SUM(F25*TimeSheet[[#Totals],[Overtime hours]]), \"\")","v":{"v":30,"d":"$30.00"}},{"$f":"IFERROR(SUM(G25*TimeSheet[[#Totals],[Sick]]), \"\")","v":{"v":80,"d":"$80.00"}},{"$f":"IFERROR(SUM(H25*TimeSheet[[#Totals],[Vacation]]), \"\")","v":{"v":80,"d":"$80.00"}},{"$f":"IFERROR(SUM(E26:H26), \"\")","v":{"v":350,"d":"$350.00"}}]
[]
[]
[null,null,"Employee signature",{"$nulls":4},"Date"]
[]
[null,null,"Manager signature",{"$nulls":4},"Date"]