{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Tabelle1","Tabelle2","Tabelle3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Tabelle1","index":0,"n_rows":45,"n_cols":22,"rows_kept":45,"cut":false,"hidden":false,"merged":[[18,1,21,1],[24,0,25,0],[24,1,25,1],[0,6,1,17],[0,0,1,0],[0,1,1,3],[3,4,4,5],[3,0,3,1],[3,2,3,3],[4,2,4,3],[5,2,5,3],[4,0,4,1],[5,0,7,0],[7,2,7,3],[10,6,11,9],[13,7,13,8],[5,4,5,5],[6,4,6,5],[6,2,6,3],[7,4,8,13],[8,0,8,1],[8,2,8,3],[12,13,12,14],[13,13,13,14],[14,13,14,14],[15,13,15,14],[14,7,14,8],[15,7,15,8],[12,9,12,10],[13,9,13,10],[14,9,14,10],[15,9,15,10],[12,7,12,8],[24,2,25,3],[24,4,25,5],[12,11,12,12],[13,11,13,12],[14,11,14,12],[15,11,15,12]]}
["Name Mitarbeiter/in:",null,null,null,null,null,"Nur auszufüllen, wenn die Arbeitszeit sich innerhalb der Stufe verändert hat (z.B. von Vollzeit zu Teilzeit):\nZur Berechnung bitte ALLE Felder einer Stufe ausfüllen (Auch Monate mit 169,5h)\nWird diese Berechnung genutzt, ersetzt der Wert in G5/G7 automatisch den Wert in C6/C7, auch wenn dieser bestehen bleibt"]
[]
[]
["Eintrittsmonat (Monat JJ):",null,"2018-01-01",null,"Anzahl ganze Entgeltfreie Monate pro Stufe (Monatserster - Monatsletzter):",null,"Stufe 1:","2020-01-01","2020-02-01","2020-03-01","2020-04-01","2020-05-01","2020-06-01","2020-07-01","2020-08-01","2020-09-01","2020-10-01","2020-11-01","2020-12-01","2021-01-01","2021-02-01","2021-03-01"]
["Summe Monate in LHO-Unternehmen vor Eintrittsdatum:\n(sollte ein MA mehr als 24 Monate Zugehörigkeit haben, bitte 24 eintragen. Bei MA ohne vorherige Zugehörigkeit bitte 0 eintragen)",null,null,null,null,null,{"$f":"IFERROR(AVERAGEIF(H5:V5,\"<>0\"),0)","v":0}]
["Anzahl Stunden Monat\n(max. 169,5)\n","01.01.2020 - 31.03.2021:",169.5,null,null,null,"Stufe 2:","2021-04-01","2021-05-01","2021-06-01","2021-07-01","2021-08-01","2021-09-01","2021-10-01"]
[null,"01.04.2021 - 31.10.2021:",169.5,null,null,null,{"$f":"IFERROR(AVERAGEIF(H7:V7,\"<>0\"),0)","v":0}]
[null,"ab 01.11.2021:",169.5,null,"Hinweis: Die Stundenzahl pro Monat beträgt unabhängig von der reellen Arbeitszeit maximal 169,5. Ein höherer Wert kann in die Felder nicht eingetragen werden\nFür geringfügig Beschäftigte sind für die monatliche Arbeitszeit folgende Werte einzutragen:\nStufe 1 (Zelle C6): 30\nStufe 2 (Zellen C7 & C8): 28,13"]
["Automatische Entgeltumwandlung (Bitte aus Dropdownmenü auswählen):",null,"Ja"]
[]
["Einmalzahlung (01.01.2020 - 31.10.2021)",null,null,null,null,null,"Fortlaufende Zahlung (ab 01.11.2021)"]
["Grunddaten BusRente Hessen"]
["Stufen","Arbeitgeberbeitrag","Autom. EntgUmw ArbN ","AG-Zuschuss","Gesamt",null,"Stufen","Arbeitgeberbeitrag",null,"Automat. EntgUmw ArbN ",null,"AG-Zuschuss",null,"Gesamt"]
["01.01.2020 - 31.03.2021",{"$f":"IF(C36<=25.43,C36,25.43)","v":25.43},"entfällt","entfällt",{"$f":"SUM(B14:C14)","v":25.43},null,"01.11.2021 - 30.06.2022",{"$f":"IF(B19<=44713,IF(C38<=54.24,C38,54.24),0)","v":54.24},null,{"$f":"IF(B19<=44713,IF($C$9=\"Ja\",20.34*C8/169.5,\"Nein\"),0)","v":20.34},null,{"$f":"IF(B19<=44713,IF($C$9=\"Ja\",J14*0.2,\"Nein\"),0)","v":4.0680000000000005},null,{"$f":"SUM(H14:M14)","v":78.647999999999996}]
["01.04.2021 - 31.10.2021",{"$f":"IF(C37<=54.24,C37,54.24)","v":54.24},"entfällt","entfällt",{"$f":"SUM(B15:C15)","v":54.24},null,"01.07.2022 - 30.09.2023",{"$f":"IF(B19<=45170,IF(C39<=84.92,C39,84.92),0)","v":84.92},null,{"$f":"IF(B19<=45170,IF($C$9=\"Ja\",21.23*C8/169.5,\"Nein\"),0)","v":21.23},null,{"$f":"IF(B19<=45170,IF($C$9=\"Ja\",J15*0.2,\"Nein\"),0)","v":4.2460000000000004},null,{"$f":"SUM(H15:M15)","v":110.396}]
[null,null,null,null,null,null,"ab 01.10.2023",{"$f":"IF(C40<=117.97,C40,117.97)","v":117.97},null,{"$f":"IF($C$9=\"Ja\",29.49*C8/169.5,\"Nein\")","v":29.489999999999995},null,{"$f":"IF($C$9=\"Ja\",J16*0.2,\"Nein\")","v":5.8979999999999997},null,{"$f":"SUM(H16:M16)","v":153.35799999999998}]
["Berechnung Einmalzahlung (01.01.2020 - 31.10.2021)"]
["Zeitraum","Anspruch bAV seit (tt.mm.jjjj)","Ende Zeitraum","Anzahl bezugsberechtigte Monate","Betrag"]
[" Stufe 1: 01.2020 bis 03.2021",{"$f":"IF(A37<A36,A36,A37)","v":"2020-01-01"},"2021-03-31",{"$f":"IFERROR(IF(A39>15,15,A39)-E6,0)","v":15},{"$f":"IFERROR(D19*E14,0)","v":381.45}]
["Stufe 2: 04.2021 bis 10.2021",null,"2021-10-31",{"$f":"(IFERROR(IF(A40>7,7,A40)-E7,0))","v":7},{"$f":"IFERROR(D20*E15,0)","v":379.68}]
["Summe",null,null,null,{"$f":"SUM(E19:E20)","v":761.13}]
["abzgl. Finanzierungsbeitrag",null,null,null,{"$f":"IF(G5>0,-54.24*G5/169.5,-54.24*C8/169.5)","v":-54.24}]
["Summe Einmalzahlung",null,null,null,{"$f":"IFERROR(IF(SUM(E21:E22)>0,SUM(E21:E22),0),0)","v":706.89}]
[]
["Pflichteingabe","Optionale Eingabe","in Meldeliste der SIGNAL IDUNA zu übertragen",null,"abzuführender Finanzierungsbeitrag auf Sonderkonto"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2020-01-01",null,{"$f":"IF(G5>0,25.43*G5/169.5,25.43*C6/169.5)","v":25.43}]
[{"$f":"DATE(YEAR(C4),MONTH(C4)+24-C5,DAY(C4))","v":"2020-01-01"},null,{"$f":"IF(G7>0,54.24*G7/169.5,54.24*C7/169.5)","v":54.24}]
[null,null,{"$f":"54.24*$C$8/169.5","v":54.24}]
[{"$f":"DATEDIF(B19,A43,\"m\")","v":15},null,{"$f":"84.92*$C$8/169.5","v":84.92}]
[{"$f":"DATEDIF(B19,A44,\"m\")","v":22},null,{"$f":"117.97*$C$8/169.5","v":117.97}]
[]
[]
["2021-04-01",null,"Ja"]
["2021-11-01",null,"Nein"]
["2021-12-01"]

{"sheet":"Tabelle2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Tabelle3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}