{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Berechnung","KV"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":0,"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":"Berechnung","index":0,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,2,2,8],[12,7,12,8],[11,7,11,8],[9,7,10,8],[3,4,6,6],[7,5,8,5],[7,4,8,4],[7,6,8,6],[3,7,4,8],[7,7,7,8]]}
[]
[]
[null,null,"Berechnung der Sozialverversicherungsbeiträge"]
[null,null,"Vertragsgehalt",2000,"1. Geben Sie die sozialversicherungs-pflichtigen Einnahmen des Arbeitnehmers ein. 2. Wählen Sie die Krankenkasse aus.             3. Überprüfen Sie die weiteren Beitragssätze sowie die Beitragsbemessungsgrenzen.",null,null,"Eingabe der Zahlungen an den Arbeitnehmer"]
[null,null,"vermögenswirksame Leistung",39]
[null,null,"Ulaubs-/Weihnachtsgeld",200]
[null,null,"Sonderzahlungen",400]
[null,null,"Bruttogehalt",{"$f":"SUM(D4:D7)","v":2639},"Gesamtabzug","Beitragssatz in %","Beitrags- bemessungs- grenzen","Auswahl der Krankenkasse"]
[null,null,null,"Arbeitnehmer- anteil"]
[null,null,"Krankenversicherung",{"$f":"E10/2","v":176.81299999999999},{"$f":"IF($D$8<G10,$D$8*F10/100,G10*F10/100)","v":353.62599999999998},{"$f":"INDEX(KV!B5:C14,J10,2)","v":13.4},3450,"Eingabe der Beitragssätze zur Arbeitslosen-, Renten- und Pflegeversicherung",null,7]
[null,null,"Rentenversicherung",{"$f":"E11/2","v":257.30250000000001},{"$f":"IF($D$8<G11,$D$8*F11/100,G11*F11/100)","v":514.60500000000002},19.5,4250]
[null,null,"Arbeitslosenversicherung",{"$f":"E12/2","v":85.767499999999998},{"$f":"IF($D$8<G12,$D$8*F12/100,G12*F12/100)","v":171.535},6.5,4250]
[null,null,"Pflegeversicherung",{"$f":"E13/2","v":22.4315},{"$f":"IF($D$8<G13,$D$8*F13/100,G13*F13/100)","v":44.863},1.7,3450,"Beitragsbemessungsgrenzen"]
[null,null,"Sozialversicherung insgesamt",{"$f":"SUM(D10:D13)","v":542.31450000000007},{"$f":"SUM(E10:E13)","v":1084.6290000000001}]

{"sheet":"KV","index":1,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,2,3,2],[2,1,3,1]]}
[]
[]
[null,"Krankenkasse","Beitragssätze in %"]
[]
[null,"AOK",14.5]
[null,"DAK",13]
[null,"Barmer",13.2]
[null,"TKK",13.7]
[null,"Hamburg-Mannheimer",13.8]
[null,"Gothaer",14.2]
[null,"Kölner",13.4]
[null,"BHW",13.9]
[null,"DTAG",14.1]
[null,"Frankfurter",13.8]