{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["privat","Sorgeberechtigter","Quarantäne"],"not_rendered":{"charts":0,"images":10,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"privat","index":0,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Berechnung                                                                                                             *)"]
["privat Versicherter AN                         ",null,"BMG","BMG",null,"Zuschuss",null,null,"Entgeltabrechnung im Juli 2022"]
[{"$nulls":5},"normalerweise"]
["BBG",4837.5]
[0.14599999999999999,{"$f":"SUM(A5:A7)","v":0.159},null,{"$f":"B4","v":4837.5},null,{"$f":"(B4*A5)/2","v":353.13749999999999}]
[1.2999999999999999E-2,{"$f":"(A5+A6)/2","v":7.9500000000000001E-2},null,null,null,{"$f":"(B4*A6)/2","v":31.443749999999998}]
["Gesamt",{"$nulls":4},{"$f":"SUM(F5:F6)","v":384.58125000000001}]
[]
["Entgeltkürzung"]
["lfd. Entgelt - Gehalt",4000]
["abzüglich Kürzung",-1290.32]
["Summe inkl. Kürzung / Gesamtentgelt",{"$f":"SUM(B10:B11)","v":2709.6800000000003}]
[]
["Zuschuss-Berechnung",{"$f":"B12","v":2709.6800000000003},{"$f":"A5/2","v":7.2999999999999995E-2},null,null,{"$f":"B14*C14","v":197.80664000000002}]
["im Entschädigungsfall",null,{"$f":"A6/2","v":6.4999999999999997E-3},null,null,{"$f":"B14*C15","v":17.612920000000003}]
[]
[{"$nulls":5},{"$f":"SUM(F14:F16)","v":215.41956000000002}]
[]
["*) durchschnittlicher Zusatzbeitrag",{"$nulls":7},"erfasste Werte"]

{"sheet":"Sorgeberechtigter","index":1,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Berechnung                                                                                                             *)"]
["Freiwillig versicherter AN - Sorgeberechtigte",null,"BMG","BMG",null,"Zuschuss","Beitrag","Entgeltabrechnung im Juli 2022"]
[{"$nulls":6},"normal"]
["BBG",4837.5]
[0.14599999999999999,{"$f":"SUM(A5:A7)","v":0.157},null,{"$f":"B4","v":4837.5},null,{"$f":"(B4*A5)/2","v":353.13749999999999},{"$f":"B4*A5","v":706.27499999999998}]
[1.0999999999999999E-2,{"$f":"(A5+A6)/2","v":7.85E-2},null,null,null,{"$f":"(B4*A6)/2","v":26.606249999999999},{"$f":"B4*A6","v":53.212499999999999}]
["Gesamt",{"$nulls":4},{"$f":"SUM(F5:F6)","v":379.74374999999998},{"$f":"SUM(G5:G6)","v":759.48749999999995}]
[]
["Verhältnis-Rechnung"]
["Feststellung der dem Grunde nach beitragspflichtigen Einnahme"]
["lfd. Entgelt - Gehalt",6000]
["abzüglich Kürzung",-2000]
["Summe inkl. Kürzung / restl. laufendes Entgelt",{"$f":"SUM(B11:B12)","v":4000}]
["beitragspflichtiger Anteil für lfd. Brutto: "]
["Entgelt mit Kürzung",{"$f":"B13","v":4000}]
["geteilt durch Gesamtentgelt",{"$f":"B11","v":6000}]
["x BBG",{"$f":"B4","v":4837.5},null,null,{"$f":"B15/B16*B17","v":3225}]
[]
["beitragspflichtiger Anteil für Ausfallbrutto"]
["Ausfallbrutto",{"$f":"-(B12)","v":2000}]
["geteilt durch Gesamtentgelt",{"$f":"B11","v":6000}]
["x BBG (x 80% wegen Sorgeberechtigte)",{"$f":"B4","v":4837.5},0.8]
["ergibt",null,null,{"$f":"B20/B21*B22","v":1612.5},{"$f":"D23*C22","v":1290},null,null,"erfasste Werte"]
[]
["Beitragsberechnung mit Beitragsherabsetzung"]
[null,{"$f":"E17","v":3225},{"$f":"A5","v":0.14599999999999999},null,null,null,{"$f":"B26*C26","v":470.84999999999997}]
[null,null,{"$f":"A6","v":1.0999999999999999E-2},null,null,null,{"$f":"B26*C27","v":35.475000000000001}]
[]
[null,{"$f":"E23","v":1290},{"$f":"C26","v":0.14599999999999999},null,null,null,{"$f":"B29*C29","v":188.33999999999997}]
[null,null,{"$f":"C27","v":1.0999999999999999E-2},null,null,null,{"$f":"B29*C30","v":14.19}]
[{"$nulls":6},{"$f":"SUM(G26:G30)","v":708.85500000000002}]
[]
["Zuschuss-Berechnung",{"$f":"B13","v":4000},{"$f":"A5/2","v":7.2999999999999995E-2},null,null,{"$f":"B33*C33","v":292}]
[null,null,{"$f":"A6/2","v":5.4999999999999997E-3},null,null,{"$f":"B33*C34","v":22}]
[]
[{"$nulls":5},{"$f":"SUM(F33:F35)","v":314}]
[]
["*) kassenindividueller Zusatzbeitrag (IKK gesund)"]

{"sheet":"Quarantäne","index":2,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[[13,0,13,6]]}
["Berechnung                                                                                                             *)"]
["Freiwillig versicherter AN - Quarantäne ",null,"BMG","BMG",null,"Zuschuss","Beitrag",null,"Entgeltabrechnung im Juli 2022"]
[{"$nulls":5},"normal","normal"]
["BBG",4837.5]
[0.14599999999999999,{"$f":"SUM(A5:A7)","v":0.157},null,{"$f":"B4","v":4837.5},null,{"$f":"(B4*A5)/2","v":353.13749999999999},{"$f":"B4*A5","v":706.27499999999998}]
[1.0999999999999999E-2,{"$f":"(A5+A6)/2","v":7.85E-2},null,null,null,{"$f":"(B4*A6)/2","v":26.606249999999999},{"$f":"B4*A6","v":53.212499999999999}]
["Gesamt",{"$nulls":4},{"$f":"SUM(F5:F6)","v":379.74374999999998},{"$f":"SUM(G5:G6)","v":759.48749999999995}]
[]
["Feststellung der dem Grunde nach beitragspflichtigen Einnahme"]
["lfd. Entgelt - Gehalt",6000]
["abzüglich Kürzung",-2000]
["restliches laufendes Entgelt (nach Kürzung)",{"$f":"SUM(B10:B11)","v":4000}]
[]
["keine Beitragsherabsetzung möglich!"]
[]
[]
["Zuschuss-Berechnung",{"$f":"B12","v":4000},{"$f":"A5/2","v":7.2999999999999995E-2},null,null,{"$f":"B17*C17","v":292}]
[null,null,{"$f":"A6/2","v":5.4999999999999997E-3},null,null,{"$f":"B17*C18","v":22}]
[]
[{"$nulls":5},{"$f":"SUM(F17:F19)","v":314}]
[]
["*) kassenindividueller Zusatzbeitrag (IKK gesund)"]
[{"$nulls":8},"erfasste Werte:"]