{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Arbeitszeittabelle"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Arbeitszeittabelle","index":0,"n_rows":33,"n_cols":12,"rows_kept":33,"merged":[[1,1,1,5],[1,6,1,11],[3,1,3,3],[3,6,3,7],[3,8,3,9],[4,1,4,3],[4,6,4,7],[4,8,4,9],[5,1,5,3],[5,6,5,7],[5,8,5,9],[6,1,6,3],[29,1,29,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[32,6,32,9],[32,10,32,11]]}
[]
[null,"ARBEITSZEITTABELLE",{"$nulls":4},"NOD PUBLISHERS"]
[]
[null,"222 2nd Ave",{"$nulls":4},"Mitarbeitername:",null,"Shir Rosenstein"]
[null,"Appartement 100",{"$nulls":4},"Name des Vorgesetzten:",null,"Naoki Kaneko"]
[null,"Bellevue, WA 54321",{"$nulls":4},"Beginn der Woche:",null,{"$f":"TODAY()","v":"2023-03-23"}]
[null,"(502) 555-0123"]
[]
[null,"Wochentag","Einstempelzeit","Pausen\n(Minuten)","Ausstempelzeit",null,"Gesamt\n[h]:mm","Regulär\n[h]:mm","Überstunden\n[h]:mm","Krank\n[h]:mm","Feiertag\n[h]:mm","Urlaub\n[h]:mm"]
[null,{"$f":"Beginn_der_Woche","v":"2023-03-23"},"09:05:00",15,"18:00:00",null,{"$f":"MROUND((IF(OR(C10=\"\",E10=\"\"),0,IF(E10<C10,E10+1-C10,E10-C10))-D10/1440),1/1440)","v":0.3611111111111111},0.3333333333333333,0.02777777777777779]
[null,{"$f":"B10+1","v":"2023-03-24"},"09:05:00",30,"17:45:00",null,{"$f":"MROUND((IF(OR(C11=\"\",E11=\"\"),0,IF(E11<C11,E11+1-C11,E11-C11))-D11/1440),1/1440)","v":0.3402777777777778},0.3333333333333333,0.006944444444444475]
[null,{"$f":"B11+1","v":"2023-03-25"},"09:00:00",45,"18:30:00",null,{"$f":"MROUND((IF(OR(C12=\"\",E12=\"\"),0,IF(E12<C12,E12+1-C12,E12-C12))-D12/1440),1/1440)","v":0.36458333333333337},0.3333333333333333,0.031250000000000056]
[null,"2023-03-26","09:00:00",45,"18:30:00",null,{"$f":"MROUND((IF(OR(C13=\"\",E13=\"\"),0,IF(E13<C13,E13+1-C13,E13-C13))-D13/1440),1/1440)","v":0.36458333333333337},0.3333333333333333,0.031250000000000056]
[null,"2023-03-27",{"$nulls":4},{"$f":"MROUND((IF(OR(C14=\"\",E14=\"\"),0,IF(E14<C14,E14+1-C14,E14-C14))-D14/1440),1/1440)","v":0},null,null,0.3333333333333333]
[null,"2023-03-28",{"$nulls":4},{"$f":"MROUND((IF(OR(C15=\"\",E15=\"\"),0,IF(E15<C15,E15+1-C15,E15-C15))-D15/1440),1/1440)","v":0}]
[null,"2023-03-29",{"$nulls":4},{"$f":"MROUND((IF(OR(C16=\"\",E16=\"\"),0,IF(E16<C16,E16+1-C16,E16-C16))-D16/1440),1/1440)","v":0}]
[{"$nulls":6},"Ergebnis",{"$f":"SUM(H10:H16)","v":1.3333333333333333},{"$f":"SUM(I10:I16)","v":0.09722222222222238},{"$f":"SUM(J10:J16)","v":0.3333333333333333},{"$f":"SUM(K10:K16)","v":0},{"$f":"SUM(L10:L16)","v":0}]
[]
[null,"Wochentag","Einstempelzeit","Pausen\n(Minuten)","Ausstempelzeit",null,"Gesamt\n[h]:mm","Regulär\n[h]:mm","Überstunden\n[h]:mm","Krank\n[h]:mm","Feiertag\n[h]:mm","Urlaub\n[h]:mm"]
[null,{"$f":"B16+1","v":"2023-03-30"},{"$nulls":4},{"$f":"MROUND((IF(OR(C20=\"\",E20=\"\"),0,IF(E20<C20,E20+1-C20,E20-C20))-D20/1440),1/1440)","v":0}]
[null,{"$f":"B20+1","v":"2023-03-31"},{"$nulls":4},{"$f":"MROUND((IF(OR(C21=\"\",E21=\"\"),0,IF(E21<C21,E21+1-C21,E21-C21))-D21/1440),1/1440)","v":0}]
[null,"2023-04-01",{"$nulls":4},0]
[null,"2023-04-02",{"$nulls":4},0]
[null,"2023-04-03",{"$nulls":4},0]
[null,"2023-04-04",{"$nulls":4},0]
[null,"2023-04-05",{"$nulls":4},0]
[{"$nulls":6},"Ergebnis",{"$f":"SUM(H20:H26)","v":0},{"$f":"SUM(I20:I26)","v":0},{"$f":"SUM(J20:J26)","v":0},{"$f":"SUM(K20:K26)","v":0},{"$f":"SUM(L20:L26)","v":0}]
[]
[{"$nulls":6}," ","Regulär","Überstunden","Krank","Feiertag","Urlaub"]
[{"$nulls":6},"Satz/Stunde:",{"v":15,"d":"15.00 "},{"$f":"1.5*H30","v":{"v":22.5,"d":"22.50 "}},{"v":15,"d":"15.00 "},{"v":15,"d":"15.00 "},{"v":15,"d":"15.00 "}]
[null,"Unterschrift des Arbeitnehmers",null,null,"Datum",null,"Gehalt gesamt:",{"$f":"ROUND((H27+H17)*24*H30,2)","v":{"v":480,"d":"480.00 "}},{"$f":"ROUND((I27+I17)*24*I30,2)","v":{"v":52.5,"d":"52.50 "}},{"$f":"ROUND((J27+J17)*24*J30,2)","v":{"v":120,"d":"120.00 "}},{"$f":"ROUND((K27+K17)*24*K30,2)","v":0},{"$f":"ROUND((L27+L17)*24*L30,2)","v":0}]
[]
[null,"Unterschrift des Vorgesetzten",null,null,"Datum",null,"Gesamtlohnsumme:",{"$nulls":3},{"$f":"SUM(H31:L31)","v":{"v":652.5,"d":"652.50 "}}]