{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Betreungszeit","Beschreibung"],"read":"whole","date_system":"1900"}

{"sheet":"Betreungszeit","index":0,"n_rows":48,"n_cols":24,"rows_kept":48,"merged":[[0,0,0,14],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[8,0,8,14],[9,3,9,4],[9,5,9,6],[9,7,9,8],[9,9,9,10],[9,11,9,12],[9,13,9,14],[9,19,9,20],[21,0,21,3],[21,4,21,8],[23,5,30,5]]}
["Formular zur wöchentlichen Erfassung der Arbeitszeiten in der 24h - Betreuung"]
["Angaben zur Arbeitnehmerin/zum Arbeitnehmer:"]
["Name",{"$nulls":3},"Vereinbarte wöchentliche Arbeitszeit in Stunden"]
["Vorname",{"$nulls":3},"massgeblicher Stundenlohn"]
["Adresse",{"$nulls":3},"anwendbarer Präsenzstundenlohn"]
["PLZ Ort",{"$nulls":3},"Naturallohnabzug gemäss Art. 11 AHVV"]
[{"$nulls":5},"Eingabefelder"]
[]
["Zeiterfassung pro Woche"]
[null,"täglicher Betreuungs- und Arbeitszeitraum","Pausen pro Tag\n(unbezahlt)\n","aktiver Arbeitseinsatz I",null,"aktiver Arbeitseinsatz II",null,"aktiver Arbeitseinsatz III",null,"aktiver Arbeitseinsatz IV",null,"aktiver Arbeitseinsatz V",null,"aktiver Arbeitseinsatz VI",{"$nulls":5},"Nachtzeitraum"]
["Datum","Angabe in Std ","Angabe in Std (0.25 genau, ganzer Tag)","von","bis","von","bis","von","bis","von","bis","von","bis","von","bis",null,"Einsatz I","Einsatz II","Einsatz III","Morgen","Abend","Einsatz IV","Einsatz V","Einsatz VI"]
[{"$nulls":16},{"$f":"IF(OR(D12=\"\",E12=\"\"),,IF(AND(D12<$T$12,E12>$U$12),SUM(($T$12-D12)+(E12-$U$12)),IF(D12>=$U$12,E12-D12,IF($U$12<E12,E12-$U$12,IF(E12<=$T$12,E12-D12,IF(D12>=$T$12,,$T$12-D12))))))","v":"00:00:00"},{"$f":"IF(OR(F12=\"\",G12=\"\"),,IF(AND(F12<$T$12,G12>$U$12),SUM(($T$12-F12)+(G12-$U$12)),IF(F12>=$U$12,G12-F12,IF($U$12<G12,G12-$U$12,IF(G12<=$T$12,G12-F12,IF(F12>=$T$12,,$T$12-F12))))))","v":"00:00:00"},{"$f":"IF(OR(H12=\"\",I12=\"\"),,IF(AND(H12<$T$12,I12>$U$12),SUM(($T$12-H12)+(I12-$U$12)),IF(H12>=$U$12,I12-H12,IF($U$12<I12,I12-$U$12,IF(I12<=$T$12,I12-H12,IF(H12>=$T$12,,$T$12-H12))))))","v":"00:00:00"},"06:00:00","23:00:00",{"$f":"IF(OR(J12=\"\",K12=\"\"),,IF(AND(J12<$T$12,K12>$U$12),SUM(($T$12-J12)+(K12-$U$12)),IF(J12>=$U$12,K12-J12,IF($U$12<K12,K12-$U$12,IF(K12<=$T$12,K12-J12,IF(J12>=$T$12,,$T$12-J12))))))","v":"00:00:00"},{"$f":"IF(OR(L12=\"\",M12=\"\"),,IF(AND(L12<$T$12,M12>$U$12),SUM(($T$12-L12)+(M12-$U$12)),IF(L12>=$U$12,M12-L12,IF($U$12<M12,M12-$U$12,IF(M12<=$T$12,M12-L12,IF(L12>=$T$12,,$T$12-L12))))))","v":"00:00:00"},{"$f":"IF(OR(N12=\"\",O12=\"\"),,IF(AND(N12<$T$12,O12>$U$12),SUM(($T$12-N12)+(O12-$U$12)),IF(N12>=$U$12,O12-N12,IF($U$12<O12,O12-$U$12,IF(O12<=$T$12,O12-N12,IF(N12>=$T$12,,$T$12-N12))))))","v":"00:00:00"}]
[{"$nulls":16},{"$f":"IF(OR(D13=\"\",E13=\"\"),,IF(AND(D13<$T$12,E13>$U$12),SUM(($T$12-D13)+(E13-$U$12)),IF(D13>=$U$12,E13-D13,IF($U$12<E13,E13-$U$12,IF(E13<=$T$12,E13-D13,IF(D13>=$T$12,,$T$12-D13))))))","v":"00:00:00"},{"$f":"IF(OR(F13=\"\",G13=\"\"),,IF(AND(F13<$T$12,G13>$U$12),SUM(($T$12-F13)+(G13-$U$12)),IF(F13>=$U$12,G13-F13,IF($U$12<G13,G13-$U$12,IF(G13<=$T$12,G13-F13,IF(F13>=$T$12,,$T$12-F13))))))","v":"00:00:00"},{"$f":"IF(OR(H13=\"\",I13=\"\"),,IF(AND(H13<$T$12,I13>$U$12),SUM(($T$12-H13)+(I13-$U$12)),IF(H13>=$U$12,I13-H13,IF($U$12<I13,I13-$U$12,IF(I13<=$T$12,I13-H13,IF(H13>=$T$12,,$T$12-H13))))))","v":"00:00:00"},null,null,{"$f":"IF(OR(J13=\"\",K13=\"\"),,IF(AND(J13<$T$12,K13>$U$12),SUM(($T$12-J13)+(K13-$U$12)),IF(J13>=$U$12,K13-J13,IF($U$12<K13,K13-$U$12,IF(K13<=$T$12,K13-J13,IF(J13>=$T$12,,$T$12-J13))))))","v":"00:00:00"},{"$f":"IF(OR(L13=\"\",M13=\"\"),,IF(AND(L13<$T$12,M13>$U$12),SUM(($T$12-L13)+(M13-$U$12)),IF(L13>=$U$12,M13-L13,IF($U$12<M13,M13-$U$12,IF(M13<=$T$12,M13-L13,IF(L13>=$T$12,,$T$12-L13))))))","v":"00:00:00"},{"$f":"IF(OR(N13=\"\",O13=\"\"),,IF(AND(N13<$T$12,O13>$U$12),SUM(($T$12-N13)+(O13-$U$12)),IF(N13>=$U$12,O13-N13,IF($U$12<O13,O13-$U$12,IF(O13<=$T$12,O13-N13,IF(N13>=$T$12,,$T$12-N13))))))","v":"00:00:00"}]
[{"$nulls":16},"00:00:00","00:00:00","00:00:00",null,null,"00:00:00","00:00:00","00:00:00"]
[{"$nulls":16},"00:00:00","00:00:00","00:00:00",null,null,"00:00:00","00:00:00","00:00:00"]
[{"$nulls":16},"00:00:00","00:00:00","00:00:00",null,null,"00:00:00","00:00:00","00:00:00"]
[{"$nulls":16},"00:00:00","00:00:00","00:00:00",null,null,"00:00:00","00:00:00","00:00:00"]
[{"$nulls":16},"00:00:00","00:00:00","00:00:00",null,null,"00:00:00","00:00:00","00:00:00"]
[{"$nulls":16},"00:00:00","00:00:00","00:00:00",null,null,"00:00:00","00:00:00","00:00:00"]
[]
[]
["Aktive Arbeitszeit",{"$nulls":3},"Lohn"]
["Datum","Total Std","Tagesarbeit     in Std","Nachtarbeit in Std (+25%)","Lohn aktive Arbeitseinsätze pro Tag","Lohnzuschlag Überstunden (Total +25%)","Lohn Präsenz proTag (Std. = abzügl. Total aktive Std und Pausen)","Abzügl. Naturallohn","Total Lohn"]
[{"$f":"IF(A12=\"\",\"\",A12)","v":""},{"$f":"IF(A24=\"\",\"\",IF(AND(D12=\"\",E12=\"\",F12=\"\",G12=\"\",H12=\"\",I12=\"\",J12=\"\",K12=\"\"),0,SUM(E12-D12)*24+SUM(G12-F12)*24+SUM(I12-H12)*24+SUM(K12-J12)*24+SUM(M12-L12)*24+SUM(O12-N12)*24))","v":""},{"$f":"IF(B24=\"\",\"\",IF(D24=\"\",SUM(B24),SUM(B24-D24)))","v":""},{"$f":"IF(AND(D12=\"\",E12=\"\",F12=\"\",G12=\"\",H12=\"\",I12=\"\",J12=\"\",K12=\"\",L12=\"\",M12=\"\",N12=\"\",O12=\"\"),\"\",SUM(Q12,R12,S12,V12,W12,X12)*24)","v":""},{"$f":"IF(OR(B24=\"\",B24=0),\"\",SUM(C24*$J$4)+(D24*$J$4)*125%)","v":""},null,{"$f":"IF(OR(B12=\"\",B24=\"\",B12<SUM(B24,C12)),\"\",IF(AND($I$5=\"\",$J$5=\"\"),\"\",IF(AND($I$5<>\"\",$J$5<>\"\"),IF(SUM(((B12-B24-C12)*$J$4)*$J$5)>SUM(((B12-B24-C12)*$I$5)),SUM(((B12-B24-C12)*$J$4)*$J$5),SUM(((B12-B24-C12)*$I$5))),IF($I$5=\"\",SUM((B12-B24-C12)*$J$4)*$J$5,SUM((B12-B24-C12))*$I$5))))","v":""},{"$f":"IF(OR(B24=0,B24=\"\"),\"\",SUM($J$6*-1))","v":""},{"$f":"IF(E24=\"\",\"\",SUM(E24:H24))","v":""}]
[{"$f":"IF(A13=\"\",\"\",A13)","v":""},{"$f":"IF(A25=\"\",\"\",IF(AND(D13=\"\",E13=\"\",F13=\"\",G13=\"\",H13=\"\",I13=\"\",J13=\"\",K13=\"\"),0,SUM(E13-D13)*24+SUM(G13-F13)*24+SUM(I13-H13)*24+SUM(K13-J13)*24+SUM(M13-L13)*24+SUM(O13-N13)*24))","v":""},{"$f":"IF(B25=\"\",\"\",IF(D25=\"\",SUM(B25),SUM(B25-D25)))","v":""},"",{"$f":"IF(OR(B25=\"\",B25=0),\"\",SUM(C25*$J$4)+(D25*$J$4)*125%)","v":""},null,{"$f":"IF(OR(B13=\"\",B25=\"\",B13<SUM(B25,C13)),\"\",IF(AND($I$5=\"\",$J$5=\"\"),\"\",IF(AND($I$5<>\"\",$J$5<>\"\"),IF(SUM(((B13-B25-C13)*$J$4)*$J$5)>SUM(((B13-B25-C13)*$I$5)),SUM(((B13-B25-C13)*$J$4)*$J$5),SUM(((B13-B25-C13)*$I$5))),IF($I$5=\"\",SUM((B13-B25-C13)*$J$4)*$J$5,SUM((B13-B25-C13))*$I$5))))","v":""},{"$f":"IF(OR(B25=0,B25=\"\"),\"\",SUM($J$6*-1))","v":""},{"$f":"IF(E25=\"\",\"\",SUM(E25:H25))","v":""}]
["","","","","",null,"","",""]
["","","","","",null,"","",""]
["","","","","",null,"","",""]
["","","","","",null,"","",""]
["","","","","",null,"","",""]
["","","","","",null,"","",""]
["Total / Woche",{"$f":"SUM(B24:B31)","v":0},{"$f":"SUM(C24:C31)","v":0},{"v":0,"d":"0.00"},0,{"$f":"IF($J$3>B32,,SUM(B32-$J$3)*$J$4*25%)","v":0},0,0,{"$f":"ROUND(SUM(E32:H32)*2,1)/2","v":0}]
[]
[]
[]
["Hinweise:","1 1/2 Tage frei pro Woche"]
[]
["Lohn pro Woche ",null,{"$f":"I32","v":0}]
[]
[]
[]
["Name",{"$f":"IF(B3=\"\",\"\",B3)","v":""},"Vorname",{"$f":"IF(B4=\"\",\"\",B4)","v":""}]
[]
[]
["Datum",{"$f":"TODAY()","v":"2020-09-02"},"Unterschrift Arbeitnehmer / in"]
[]
[]
[null,null,"Unterschrift Arbeitgeber / in"]

{"sheet":"Beschreibung","index":1,"n_rows":29,"n_cols":9,"rows_kept":29,"merged":[[0,0,0,9],[5,5,5,6],[6,5,6,6],[7,5,7,6],[8,5,8,6],[12,4,12,5],[15,4,15,5]]}
["Erklärungen zum Formular Erfassung der Arbeitszeit"]
[]
[null,"rosa markierte Felder sind Eingabefelder (alle anderen Felder sind gesperrt)"]
["Stunden werden mit Dezimalstellen angegeben (5.5 Stunden) Uhrzeiten mit Doppelpunkt (8:30 Uhr)"]
[]
["Vereinbarte wöchentliche Arbeitszeit in Stunden",{"$nulls":3},10,"Hier kann die im Arbeitsvertrag vereinbarte wöchentliche aktive Arbeitszeit* in Stunden eingegeben oder ausgewählt werden. z.B. 44 (5.5x8) oder 56 (7x8 Std). Das sind die Stunden, die zum vereinbarten Stundenlohn abgegolten werden."]
["massgeblicher Stundenlohn",{"$nulls":3},{"v":20,"d":"CHF 20.00"},"Hier kann der Stundenlohn der aktiven Arbeitszeit** in CHF eingegeben werden. "]
["anwendbarer Präsenzstundenlohn",{"$nulls":3},{"v":0.5,"d":"50%"},"Hier kann der Präsenzstundenlohn in % des massgeblichen Stundenlohns (rechtes Feld) oder ein fixer Betrag in CHF (linkes Feld) eingegeben werden."]
["Naturallohnabzug gemäss Art. 11 AHVV",{"$nulls":3},{"v":30,"d":"CHF 30.00"},"Hier kann der Naturallohnabzug in CHF eingegeben werden (für Unterkunft und Verpflegung). Maximal CHF 33, wenn alle Mahlzeiten im Haushalt eingenommen werden"]
[]
[]
[]
[null,"täglicher Betreuungs- und Arbeitszeitraum","Pausen pro Tag\n(unbezahlt)",null,"aktiver Arbeitseinsatz I"]
["Datum","Angabe in Std ","Angabe in Std (0.25 genau, ganzer Tag)",null,"von","bis"]
["2019-08-01",24,2]
[null,"Zeitrahmen der täglichen Anwesenheit für jegliche Arbeiten (Betreuungszeit und Haushalttätigkeiten) = aktive Arbeitszeit plus Präsenzzeit und unbezahlte oder bezahlte Pausen. Z.B. 24 Std / 12 Std./ 8 Std.","Eingabe aller Pausen ohne Betreuungszeit, ohne Präsenzzeit, daher unbezahlt",null,"Eingabe der aktiven Arbeitseinsätze im Format z.B. 08:25. \nZeiten vor 06:00 oder nach 23:00 Uhr werden rot eingefärbt. Für diese Stunden wird ein Zuschlag von 25% vom Stundenlohn berechnet."]
[]
[]
[]
["Datum","Total Std","Tagesarbeit in Std","Nachtarbeit in Std (+25%)","Lohn Arbeitseinsätze pro Tag","Lohnzuschlag Überstunden (Total +25%)","Lohn Präsenz pro Tag abzügl. Total Arbeitseinsätze und Pausen","Abzügl. Naturallohn","Total Lohn"]
["2019-08-01",12,11,1,{"v":245,"d":"CHF 245.00"},{"v":10,"d":"CHF 10.00"},{"v":100,"d":"CHF 100.00"},{"v":-30,"d":"CHF -30.00"},{"$f":"SUM(E21:H21)","v":{"v":325,"d":"CHF 325.00"}}]
[null,"Total ALLER aktiven Arbeitseinsätze pro Tag/Zeile ","Total Tagesstunden (zwischen 06:00 und 23:00 Uhr) aller aktiven Arbeitseinsätze pro Tag/Zeile","Total Nachtstunden (vor 06:00 Uhr und nach 23:00 Uhr) aller aktiven Arbeitseinsätze pro Tag/Zeile","Total Std x Std-Lohn + Nacht-Std x 25% vom Std-Lohn aller Einsätze pro Tag/Zeile","Total Std pro Woche (z.B. 12), abzügl. vereinbarte wöchentliche Std. (z.B. 10), ergibt 2 Std x 25% vom Std-Lohn CHF 20.- ergibt CHF 10.-","Präsenzstunden (z.B. 24) abzügl. Total Std 12 abzügl. Pause 2 = 10 x Präsenzstundenlohn (Std-Lohn in % oder fixer Betrag). Angewendet wird das höhere Ergebnis: 10 x CHF 10.- = 100.-"]
["*)"]
["Es ist nicht möglich, jemanden nur für Präsenzzeiten anzustellen. Die aktive Arbeitszeit muss mind. 1/3 der gesamten Anwesenheit betragen."]
["**)"]
["Die Mindestlöhne gemäss nationalem NAV Hauswirtschaft betragen seit 01.01.2020 neu: "]
["CHF 19.20 (ungelernt)  "]
["CHF 21.10 (gelernt mit EBA oder ungelernt mit mind. 4 Jahren Berufserfahrung)  "]
["CHF 23.20 (gelernt mit EFZ)"]