{"text_format":"3","workbook":"xlsx","n_sheets":15,"sheets":["Startseite","Eingaben","Berechnung","Beispiel","Parameter_Intern","Hilfe","LSTBerechnung2023_07","Berechnung_Alt","LSTBerechnung2023","Berechnung_Gleitzone","LSTBerechnung2021","LSTBerechnung2020","LSTBerechnung2015","LSTBerechnung2014","__Goal_Metadata"],"not_rendered":{"images":5,"macros":1,"external_links":2,"defined_names":43,"comments":4},"read":"whole","date_system":"1900"}

{"sheet":"Startseite","index":0,"n_rows":41,"n_cols":14,"rows_kept":41,"merged":[[10,6,14,7],[11,12,11,13],[16,3,16,4]]}
[]
[]
[]
[{"$nulls":9},"Startseite"]
[null,"Lohnsteuer-Rechner 2023"]
[]
[]
[]
[{"$nulls":3},"Tabellenblätter",{"$nulls":8},"Tabellenblatt",1]
[{"$nulls":6},"Info"]
[{"$nulls":6},{"$f":"INDEX(Parameter_Intern!C5:D8,Startseite!N9,2)","v":"Hier machen Sie die Angaben zur Berechnung der LSt, der Sozialversicherungsbeiträge und zur Netto-Auszahlung."},{"$nulls":5},{"$f":"+N9/2","v":0.5},{"$f":"+ROUND(N9/2,0)","v":1}]
[{"$nulls":12},{"$f":"IF(M11=N11,1,2)","v":2}]
[]
[]
[]
[]
[{"$nulls":3},{"$f":"\"Bei einem Klick auf \"&H17&\" kommen Sie direkt zum entsprechenden Arbeitsblatt\"","v":"Bei einem Klick auf Eingaben kommen Sie direkt zum entsprechenden Arbeitsblatt"},{"$nulls":3},{"$f":"+HYPERLINK(VLOOKUP($N$9,Parameter_Intern!$B$5:$E$30,4,FALSE),VLOOKUP($N$9,Parameter_Intern!$B$5:$E$30,2,FALSE))","v":"Eingaben"}]
{"$rows_empty":21}
[null,"© 2023 by mediaforwork - ein Unternehmensbereich der Verlag für die Deutsche Wirtschaft AG"]
[null,"Die Vervielfältigung, Verbreitung oder Veräußerung der Daten oder Texte ist unzulässig und"]
[null,"ausdrücklich nur mit Genehmigung des Verlags gestattet."]

{"sheet":"Eingaben","index":1,"n_rows":41,"n_cols":24,"rows_kept":41,"merged":[[2,1,2,13],[8,7,8,8],[17,3,17,5],[17,7,17,8],[36,1,36,3]]}
[]
[{"$nulls":13},"Eingaben"]
[null,"Lohnsteuer-Rechner 2023 - Eingaben"]
[]
[{"$nulls":3},"Steuerpflichtiger Arbeitslohn in Euro",{"$nulls":6},{"$f":"+IF(ISNUMBER(H5),\"\",\"Wert eingeben\")","v":"Wert eingeben"},{"$f":"+H5","v":{"v":0,"d":"0.00"}},{"$nulls":5},"Liste für Altersentlastungsbetrag",null,"Wahl",null,{"$f":"+IF(ISNUMBER(H5),1,0)","v":0}]
[{"$nulls":3},"Für welchen Zeitraum soll die LSt berechnet werden?",{"$nulls":6},{"$f":"+IF(H6=\"\",\"Wert eingeben\",\"\")","v":"Wert eingeben"},{"$f":"+P6","v":1},{"$nulls":3},{"$f":"+IF(H6=\"Jahr\",1,IF(H6=\"Monat\",2,IF(H6=\"Woche\",3,IF(H6=\"Tag\",4,1))))","v":1},null,"Geboren vor 1941",1,{"$f":"IF($H$18=R6,S6,\"\")","v":""},null,{"$f":"+IF(H6=\"\",0,1)","v":0}]
[{"$nulls":3},"Steuerklasse",{"$nulls":6},{"$f":"+IF(ISNUMBER(H7),\"\",\"Wert eingeben\")","v":"Wert eingeben"},1,{"$nulls":3},{"$f":"+IF(ISNUMBER(H7),H7,1)","v":1},null,"Geboren 1941",2,{"$f":"IF($H$18=R7,S7,\"\")","v":""},null,{"$f":"+IF(H7=\"\",0,1)","v":0}]
[{"$nulls":3},"Ehegattenfaktor (3 Nachkommastellen) nur für StKl IV",{"$nulls":3},0.555,null,null,{"$f":"IF(H7<>4,\"\",IF(ISNUMBER(H8),\"\",\"Wert eingeben\"))","v":""},0.555,{"$nulls":3},{"$f":"+IF(ISNUMBER(H8),H8,1)","v":0.555},null,"Geboren 1942",3,"",null,{"$f":"+IF(AND(H7=4,H8=\"\"),0,1)","v":1}]
[{"$nulls":3},"allgemeine oder besondere LSt-Tabelle",{"$nulls":6},{"$f":"+IF(H9=\"\",\"LSt-Tabelle wählen\",\"\")","v":"LSt-Tabelle wählen"},0,{"$nulls":3},{"$f":"+IF(H9=\"Allgemeine LSt-Tabelle\",0,IF(H9=\"Besondere LSt-Tabelle\",1,0))","v":0},null,"Geboren 1943",4,"",null,{"$f":"+IF(H9=\"\",0,1)","v":0}]
[{"$nulls":3},"Kinderfreibetrag",{"$nulls":6},{"$f":"+IF(ISNUMBER(H10),\"\",\"Wert eingeben\")","v":"Wert eingeben"},0,{"$nulls":3},{"$f":"+IF(ISNUMBER(H10),H10,0)","v":0},null,"Geboren 1944",5,"",null,{"$f":"+IF(ISNUMBER(H10),1,0)","v":0}]
[{"$nulls":3},"Kirchensteuer in Prozent",{"$nulls":6},{"$f":"+IF(ISNUMBER(H11),\"\",\"Wert eingeben\")","v":"Wert eingeben"},{"$f":"+P11","v":0},{"$nulls":3},{"$f":"+IF(ISNUMBER(H11),H11*100,0)","v":0},null,"Geboren 1945",6,"",null,{"$f":"+IF(ISNUMBER(H11),1,0)","v":0}]
[{"$nulls":3},"Krankenversicherungssatz, bzw. PKV-Basisprämie in €",{"$nulls":6},{"$f":"+IF(ISNUMBER(H12),\"\",\"Wert eingeben\")","v":"Wert eingeben"},15.5,{"$nulls":3},{"$f":"+IF(ISNUMBER(H12),H12,15.5)","v":15.5},null,"Geboren 1946",7,"",null,{"$f":"+IF(ISNUMBER(H12),1,0)","v":0}]
[{"$nulls":3},"Krankenkassen-Zusatzbeitragsatz (d. Arbeitnehmers)",{"$nulls":6},{"$f":"+IF(H13=\"\",\"Wert eingeben\",\"\")","v":"Wert eingeben"},{"$nulls":4},{"$f":"+IF(H13=\"Ja\",1,0)","v":0},null,"Geboren 1947",8,"",null,{"$f":"+IF(H13=\"\",0,1)","v":0}]
[{"$nulls":3},"Arbeitgeberzuschuss zur privaten KV",{"$nulls":6},{"$f":"+IF(H14=\"\",\"Ja oder Nein wählen\",\"\")","v":"Ja oder Nein wählen"},{"$nulls":4},{"$f":"+IF(H14=\"Ja\",1,0)","v":0},null,"Geboren 1948",9,"",null,0]
[{"$nulls":3},"Anzahl Kinder für Pflegeversicherung",{"$nulls":6},{"$f":"+IF(H15=\"\",\"Anzahl Kinder für PV ?\",\"\")","v":"Anzahl Kinder für PV ?"},{"$f":"+P15","v":0},{"$nulls":3},{"$f":"+H15","v":0},null,"Geboren 1949",10,"",null,0]
[{"$nulls":3},"Arbeitsstelle in Ostdeutschland",{"$nulls":6},{"$f":"+IF(H16=\"\",\"Ja oder Nein wählen\",\"\")","v":"Ja oder Nein wählen"},0,{"$nulls":3},{"$f":"+IF(H16=\"Ja\",1,0)","v":0},null,"Geboren 1950",11,"",null,0]
[{"$nulls":3},{"$f":"+IF(P16=1,\"  Arbeitsort in Sachsen?\",\"  Arbeitsort liegt nicht in Sachsen\")","v":"  Arbeitsort liegt nicht in Sachsen"},{"$nulls":6},{"$f":"+IF(AND(H16=\"Ja\",H17=\"\"),\"Ja oder Nein wählen\",\"\")","v":""},0,{"$nulls":3},{"$f":"+IF(P16=0,0,IF(H17=\"Ja\",1,0))","v":0},null,"Geboren 1951",12,"",null,0]
[{"$nulls":3},"Altersentlastungsbetrag",{"$nulls":6},{"$f":"+IF(H18=\"\",\"Geburtsjahr wählen\",\"\")","v":"Geburtsjahr wählen"},0,{"$nulls":3},{"$f":"IF(ISERROR(VLOOKUP(H18,R6:S13,2,FALSE)),0,VLOOKUP(H18,R6:S13,2,FALSE))","v":0},null,"Geboren 1952",13,"",null,0]
[{"$nulls":3},"(Jahres)Hinzurechnungen",{"$nulls":6},{"$f":"+IF(ISNUMBER(H19),\"\",\"Wert eingeben\")","v":"Wert eingeben"},{"v":0,"d":"0.00"},{"$nulls":3},{"$f":"+IF(ISNUMBER(H19),H19,0)","v":0},null,"Geboren 1953",14,"",null,{"$f":"+IF(ISNUMBER(H19),1,0)","v":0}]
[{"$nulls":3},"(Jahres)lohnsteuerfreibetrag auf LSt-Karte",{"$nulls":6},{"$f":"+IF(ISNUMBER(H20),\"\",\"Wert eingeben\")","v":"Wert eingeben"},{"v":0,"d":"0.00"},{"$nulls":3},{"$f":"+IF(ISNUMBER(H20),H20,0)","v":0},null,"Geboren 1954",15,"",null,{"$f":"+IF(ISNUMBER(H20),1,0)","v":0}]
[{"$nulls":3},{"$f":"IF(AND(AND(L8>0,L8<1),L7=4),\"Ehegattenfaktor von \" & L8 & \" berücksichtigt\",\"\")","v":""},{"$nulls":13},"Geboren 1955",16,""]
[{"$nulls":17},"Geboren 1956",17,""]
[{"$nulls":17},"Geboren 1957",18,""]
[{"$nulls":17},"Geboren 1958",19,""]
[{"$nulls":17},"Geboren nach 1958",20,""]
[{"$nulls":19},{"$f":"IF(ISERROR(SUM(T6:T25)),0,SUM(T6:T25))","v":0}]
{"$rows_empty":7}
[{"$nulls":22},{"$f":"15+IF(H7=\"\",0,1)","v":15},{"$f":"IF(ISERROR(IF(V35=W34,1,0)),0,IF(V35=W34,1,0))","v":0}]
[{"$nulls":21},{"$f":"+SUM(V5:V20)","v":1}]
[]
[null,"<< Startseite",null,null,"Beispiel","Hilfe?"]
[]
[null,"© 2023 by mediaforwork - ein Unternehmensbereich der Verlag für die Deutsche Wirtschaft AG"]
[null,"Die Vervielfältigung, Verbreitung oder Veräußerung der Daten oder Texte ist unzulässig und"]
[null,"ausdrücklich nur mit Genehmigung des Verlags gestattet."]

{"sheet":"Berechnung","index":2,"n_rows":45,"n_cols":18,"rows_kept":45,"merged":[[3,1,3,13],[5,3,5,8],[12,7,12,8],[21,3,21,5],[21,7,21,8],[25,3,25,5],[40,1,40,3]]}
[]
[{"$nulls":15},{"$f":"+Eingaben!X34","v":0}]
[{"$nulls":13},"Berechnung"]
[null,"Lohnsteuer-Rechner 2023 - Berechnung"]
[]
[{"$nulls":3},{"$f":"+IF(P2=0,\"Es fehlen noch Angaben im Arbeitblatt Eingaben\",\"Alle erforderlichen Eingaben wurden gemacht\")","v":"Es fehlen noch Angaben im Arbeitblatt Eingaben"}]
[]
[{"$nulls":3},"Steuerpflichtiger Arbeitslohn in Euro",{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(Eingaben!H5=\"\",\"\",Eingaben!H5))","v":""},{"$nulls":3},{"$f":"+H8","v":""},{"$nulls":5},{"$f":"+L8","v":""}]
[{"$nulls":3},"Für welchen Zeitraum soll die LSt berechnet werden?",{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(Eingaben!H6=\"\",\"\",Eingaben!H6))","v":""},{"$nulls":3},{"$f":"+P9","v":1},{"$nulls":3},{"$f":"+IF(H9=\"Jahr\",1,IF(H9=\"Monat\",2,IF(H9=\"Woche\",3,IF(H9=\"Tag\",4,1))))","v":1},null,{"$f":"+P9","v":1}]
[]
[{"$nulls":3},"Steuerklasse",{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(Eingaben!H7=\"\",\"\",Eingaben!H7))","v":""},{"$nulls":3},1,{"$nulls":3},{"$f":"+IF(ISNUMBER(H11),H11,1)","v":1},null,{"$f":"+P11","v":1}]
[{"$nulls":3},"Ehegattenfaktor (3 Nachkommastellen) nur für StKl IV",{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(H11<>4,\"\",IF(Eingaben!H8=\"\",0,Eingaben!H8)))","v":""},{"$nulls":3},{"v":0,"d":"0.000"},{"$nulls":3},{"$f":"+IF(ISNUMBER(H12),H12,0)","v":0},null,{"$f":"+P12","v":0}]
[{"$nulls":3},"allgemeine oder besondere LSt-Tabelle",{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(Eingaben!H9=\"\",\"\",Eingaben!H9))","v":""},{"$f":"+IF(Eingaben!I9=\"\",\"\",Eingaben!I9)","v":""},null,null,0,{"$nulls":3},{"$f":"+IF(H13=\"Allgemeine LSt-Tabelle\",0,IF(H13=\"Besondere LSt-Tabelle\",1,0))","v":0},null,{"$f":"+P13","v":0}]
[{"$nulls":3},"Kinderfreibetrag",{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(Eingaben!H10=\"\",\"\",Eingaben!H10))","v":""},{"$nulls":3},0,{"$nulls":3},{"$f":"+IF(ISNUMBER(H14),H14,0)","v":0},null,{"$f":"+P14","v":0}]
[{"$nulls":3},"Kirchensteuer",{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(Eingaben!H11=\"\",\"\",Eingaben!H11))","v":""},{"$nulls":3},0,{"$nulls":3},{"$f":"+IF(ISNUMBER(H15),H15,0)","v":0},null,{"$f":"+P15*100","v":0}]
[{"$nulls":3},"Krankenversicherungssatz, bzw. PKV-Basisprämie in €",{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(Eingaben!H12=\"\",\"\",Eingaben!H12))","v":""},{"$nulls":3},15.5,{"$nulls":3},{"$f":"+IF(ISNUMBER(H16),H16,15.5)","v":15.5},null,{"$f":"P16","v":15.5}]
[{"$nulls":3},"Krankenkassen-Zusatzbeitragsatz (d. Arbeitnehmers)",{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(Eingaben!H13=\"\",\"\",IF(H16>20,0,Eingaben!H13)))","v":""},{"$nulls":3},{"$f":"+P17","v":""},{"$nulls":3},{"$f":"+H17","v":""},null,{"$f":"+P17","v":""}]
[{"$nulls":3},"Arbeitgeberzuschuss zur privaten KV",{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(Eingaben!H14=\"\",\"\",Eingaben!H14))","v":""},{"$nulls":7},{"$f":"+IF(H18=\"Ja\",1,0)","v":0}]
[{"$nulls":3},"Anzahl Kinder für Pflegeversicherung",{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(Eingaben!H15=\"\",\"\",Eingaben!H15))","v":""},{"$nulls":3},"",{"$nulls":3},{"$f":"+H19","v":""},null,{"$f":"+P19","v":""}]
[{"$nulls":3},"Arbeitsstelle in Ostdeutschland",{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(Eingaben!H16=\"\",\"\",Eingaben!H16))","v":""},{"$nulls":3},0,{"$nulls":3},{"$f":"+IF(H20=\"Ja\",1,0)","v":0},null,0]
[{"$nulls":3},{"$f":"+IF(P20=1,\"  Arbeitsort in Sachsen?\",\"  Arbeitsort liegt nicht in Sachsen\")","v":"  Arbeitsort liegt nicht in Sachsen"},{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(Eingaben!H17=\"\",\"\",Eingaben!H17))","v":""},{"$nulls":3},0,{"$nulls":3},{"$f":"+IF(P20=0,0,IF(H21=\"Ja\",1,0))","v":0},null,0]
[{"$nulls":3},"Altersentlastungsbetrag",{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(Eingaben!H18=\"\",\"\",Eingaben!H18))","v":""},{"$f":"+IF(Eingaben!I18=\"\",\"\",Eingaben!I18)","v":""},null,null,0,{"$nulls":3},{"$f":"IF(ISERROR(VLOOKUP(H22,Eingaben!R6:S25,2,FALSE)),0,VLOOKUP(H22,Eingaben!R6:S25,2,FALSE))","v":0},null,0]
[{"$nulls":3},"(Jahres)Hinzurechnungen",{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(Eingaben!H19=\"\",\"\",Eingaben!H19))","v":""},{"$nulls":3},{"v":0,"d":"0.00"},{"$nulls":3},{"$f":"+IF(ISNUMBER(H23),H23,0)","v":0},null,0]
[{"$nulls":3},"(Jahres)lohnsteuerfreibetrag auf LSt-Karte",{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(Eingaben!H20=\"\",\"\",Eingaben!H20))","v":""},{"$nulls":3},{"v":0,"d":"0.00"},{"$nulls":3},{"$f":"+IF(ISNUMBER(H24),H24,0)","v":0},null,0]
[{"$nulls":3},{"$f":"IF(AND(AND(L12>0,L12<1),L11=4),\"Ehegattenfaktor von \" & L12 & \" berücksichtigt\",\"\")","v":""}]
[{"$nulls":3},"Berechnungsergebnisse:"]
[]
[{"$nulls":3},"Lohnsteuer",{"$nulls":3},{"$f":"IF($P$2=0,\"\",LSTBerechnung2023_07!C54/100)","v":""}]
[{"$nulls":3},"Solidaritätszuschlag",{"$nulls":3},{"$f":"IF($P$2=0,\"\",LSTBerechnung2023_07!C66/100)","v":""}]
[{"$nulls":3},"Kirchensteuer",{"$nulls":3},{"$f":"IF($P$2=0,\"\",ROUNDDOWN(LSTBerechnung2023_07!C68*Berechnung!R15/10000,2))","v":""}]
[]
[{"$nulls":3},"Rentenversicherung",{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(P13=0,ROUND(IF(P9=1,\nIF(H8>LSTBerechnung2023_07!C9,LSTBerechnung2023_07!C9,H8),IF(P9=2,\nIF(H8>(LSTBerechnung2023_07!C9/12),(LSTBerechnung2023_07!C9/12),H8),\nIF(P9=3,\nIF(H8>(LSTBerechnung2023_07!C9/360*7),(LSTBerechnung2023_07!C9/360*7),H8),\nIF(H8>(LSTBerechnung2023_07!C9/360),(LSTBerechnung2023_07!C9/360),H8))))*0.093,2),0))","v":""}]
[{"$nulls":3},"Krankenversicherung",{"$nulls":3},{"$f":"IF(ISERROR(IF(H16>20,IF(P18=0,H16*LSTBerechnung2023_07!$C$69,MAX(H16/2*LSTBerechnung2023_07!$C$69,(H16-(LSTBerechnung2023_07!G11*LSTBerechnung2023_07!F17/12))*LSTBerechnung2023_07!$C$69)),IF(H16=0,0,ROUND(IF(P9=1,IF(H8>LSTBerechnung2023_07!F17,LSTBerechnung2023_07!F17,H8),IF(P9=2,IF(H8>(LSTBerechnung2023_07!F17/12),(LSTBerechnung2023_07!F17/12),H8),IF(P9=3,IF(H8>(LSTBerechnung2023_07!F17/360*7),(LSTBerechnung2023_07!F17/360*7),H8),IF(H8>(LSTBerechnung2023_07!F17/360),(LSTBerechnung2023_07!F17/360),H8))))*((H16+H17)/2*0.01),2)))),\"\",IF(H16>20,IF(P18=0,H16*LSTBerechnung2023_07!$C$69,MAX(H16/2*LSTBerechnung2023_07!$C$69,(H16-(LSTBerechnung2023_07!G11*LSTBerechnung2023_07!F17/12))*LSTBerechnung2023_07!$C$69)),IF(H16=0,0,ROUND(IF(P9=1,IF(H8>LSTBerechnung2023_07!F17,LSTBerechnung2023_07!F17,H8),IF(P9=2,IF(H8>(LSTBerechnung2023_07!F17/12),(LSTBerechnung2023_07!F17/12),H8),IF(P9=3,IF(H8>(LSTBerechnung2023_07!F17/360*7),(LSTBerechnung2023_07!F17/360*7),H8),IF(H8>(LSTBerechnung2023_07!F17/360),(LSTBerechnung2023_07!F17/360),H8))))*((H16+H17)/2*0.01),2))))","v":""}]
[{"$nulls":3},"Pflegeversicherung",{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(P16>20,0,IF(P16=0,0,ROUND(IF(P9=1,IF(H8>LSTBerechnung2023_07!F17,LSTBerechnung2023_07!F17,H8),IF(P9=2,IF(H8>(LSTBerechnung2023_07!F17/12),(LSTBerechnung2023_07!F17/12),H8),IF(P9=3,IF(H8>(LSTBerechnung2023_07!F17/360*7),(LSTBerechnung2023_07!F17/360*7),H8),IF(H8>(LSTBerechnung2023_07!F17/360),(LSTBerechnung2023_07!F17/360),H8)))),2)))*LSTBerechnung2023_07!C11)","v":""}]
[{"$nulls":3},"Arbeitslosenversicherung",{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(P13=0,ROUND(IF(P9=1,IF(H8>LSTBerechnung2023_07!C9,LSTBerechnung2023_07!C9,H8),IF(P9=2,IF(H8>(LSTBerechnung2023_07!C9/12),(LSTBerechnung2023_07!C9/12),H8),IF(P9=3,IF(H8>(LSTBerechnung2023_07!C9/360*7),(LSTBerechnung2023_07!C9/360*7),H8),IF(H8>(LSTBerechnung2023_07!C9/360),(LSTBerechnung2023_07!C9/360),H8))))*LSTBerechnung2023_07!G6,2),0))","v":""}]
[]
[{"$nulls":3},"Abzüge",{"$nulls":3},{"$f":"IF($P$2=0,\"\",SUM(H28:H35))","v":""}]
[{"$nulls":3},"Nettolohn",{"$nulls":3},{"$f":"IF(H8=\"\",\"\",L8-H37)","v":""}]
[]
[]
[null,"<< Startseite",null,null,"Beispiel","Hilfe?"]
[]
[null,"© 2023 by mediaforwork - ein Unternehmensbereich der Verlag für die Deutsche Wirtschaft AG"]
[null,"Die Vervielfältigung, Verbreitung oder Veräußerung der Daten oder Texte ist unzulässig und"]
[null,"ausdrücklich nur mit Genehmigung des Verlags gestattet."]

{"sheet":"Beispiel","index":3,"n_rows":67,"n_cols":19,"rows_kept":67,"merged":[[62,1,62,3]]}
[]
[{"$nulls":13},"Beispiel"]
[]
[]
[]
[{"$nulls":15},2]
[{"$nulls":15},"Ja"]
[{"$nulls":15},1]
[{"$nulls":15},0.907]
[{"$nulls":15},0]
[{"$nulls":15},0]
[{"$nulls":15},9,null,"Liste für Altersentlastungsbetrag"]
[{"$nulls":15},15.5,null,"Geboren vor 1941",1]
[{"$nulls":15},1,null,"Geboren 1941",2]
[{"$nulls":15},0,null,"Geboren 1942",3]
[{"$nulls":15},0,null,"Geboren 1943",4]
[{"$nulls":15},2,null,"Geboren 1944",5]
[{"$nulls":15},0,null,"Geboren 1945",6]
[{"$nulls":15},0,null,"Geboren 1946",7]
[{"$nulls":17},"Geboren nach 1946",0]
{"$rows_empty":42}
[null,"<< Startseite",null,null,"Hilfe?"]
[]
[null,"© 2023 by mediaforwork - ein Unternehmensbereich der Verlag für die Deutsche Wirtschaft AG"]
[null,"Die Vervielfältigung, Verbreitung oder Veräußerung der Daten oder Texte ist unzulässig und"]
[null,"ausdrücklich nur mit Genehmigung des Verlags gestattet."]

{"sheet":"Parameter_Intern","index":4,"n_rows":35,"n_cols":5,"rows_kept":35,"hidden":true}
[]
[]
[]
[null,"Nr","Tabellenblatt","Hinweise","Hyperlink"]
[null,1,"Eingaben","Hier machen Sie die Angaben zur Berechnung der LSt, der Sozialversicherungsbeiträge und zur Netto-Auszahlung.","#Eingaben!B3"]
[null,2,"Berechnung","Hier werden Ihnen die Ergebnisse der Berechnung angezeigt.","#Berechnung!B3"]
[null,3,"Beispiel","Hier finden Sie ein Beispiel für den LSt-Rechner.","#Beispiel!B3"]
[null,4,"Hilfe","Hier finden Sie nähere Informationen über die Anwendung.","#Hilfe!B3"]
{"$rows_empty":24}
[null,"© BWRmed!a, ein Unternehmensbereich der VNR Verlag für die Deutsche Wirtschaft AG - HRexperten24.de"]
[null,"Die Vervielfältigung, Verbreitung oder Veräußerung der Daten oder Texte ist unzulässig und"]
[null,"ausdrücklich nur mit Genehmigung des Verlags gestattet."]

{"sheet":"Hilfe","index":5,"n_rows":20,"n_cols":6,"rows_kept":20,"merged":[[2,1,2,5],[15,1,15,3]]}
[]
[{"$nulls":5},"Hilfe"]
[null,"Lohnsteuer-Rechner 2023 - Hilfe"]
[]
[{"$nulls":3},"Allgemeine Hinweise"]
[]
[]
[]
[{"$nulls":3},"Hinweise zum Lohnsteuer-Rechner"]
[]
[]
[]
[]
[]
[]
[null,"<< Starseite"]
[]
[null,"© 2023 by mediaforwork - ein Unternehmensbereich der Verlag für die Deutsche Wirtschaft AG"]
[null,"Die Vervielfältigung, Verbreitung oder Veräußerung der Daten oder Texte ist unzulässig und"]
[null,"ausdrücklich nur mit Genehmigung des Verlags gestattet."]

{"sheet":"LSTBerechnung2023_07","index":6,"n_rows":69,"n_cols":21,"rows_kept":69,"hidden":true,"merged":[[0,8,0,12],[0,14,0,15],[1,14,1,15],[2,14,2,15],[3,14,3,15],[4,14,4,15],[5,14,5,15],[6,14,6,15]]}
["LST",2023,null,null,{"$f":"\"SOZ-VS-BEITRAGSSÄTZE  \"&BearbJahr","v":"SOZ-VS-BEITRAGSSÄTZE  2023"},{"$nulls":3},"Altersentlastungsbetrag",{"$nulls":5},"Pflegeversicherung",null,"Kinder","AN","AG","AN Sachsen","AN Sachsen"]
["MPARA","ZKF",{"$f":"IF(Berechnung!P11>4,0,Berechnung!P14)","v":0},null,"Bezeichnung","SATZ","Berechnet",null,"Geburtsjahr","Jahr","Nummer","TAB4","TAB5",null,"Mitglieder ohne Kinder ",null,0,{"v":0.023,"d":"2.30%"},{"v":0.017,"d":"1.70%"},{"v":0.028,"d":"2.80%"},{"v":0.012,"d":"1.20%"}]
[null,"LZZ",{"$f":"Berechnung!P9","v":1},null,"KVSATZ",{"v":0.146,"d":"14.600%"},{"$f":"F3/2+F4","v":{"v":0.073,"d":"7.300%"}},{"$nulls":3},0,0,0,null,"Mitglieder mit 1 Kind",null,1,{"v":0.017,"d":"1.70%"},{"v":0.017,"d":"1.70%"},{"v":0.022000000000000002,"d":"2.20%"},{"v":0.012,"d":"1.20%"}]
[null,"KRV",{"$f":"Berechnung!P13","v":0},null,"KV_Zusatz",{"$f":"Eingaben!H13/100","v":{"v":0,"d":"0.00%"}},{"$f":"F4/2+0.07","v":{"v":0.07,"d":"7.000%"}},null,"vor 1941","bis 2005",1,{"v":0.4,"d":"0.400"},1900,null,"Mitglieder mit 2 Kindern",null,2,{"v":0.014499999999999999,"d":"1.45%"},{"v":0.017,"d":"1.70%"},{"v":0.0195,"d":"1.95%"},{"v":0.012,"d":"1.20%"}]
[null,"ZRE4J",{"$f":"ROUNDDOWN(IF(C3=1,Berechnung!H8*100,IF(C3=2,(Berechnung!H8*100)*12,IF(C3=3,((Berechnung!H8*100)*360)/7,(Berechnung!H8*100)*360))),2)","v":{"$error":"#VALUE!"}},null,"RV_Satz",{"v":0.186,"d":"18.60%"},{"$f":"F5/2","v":{"v":0.093,"d":"9.300%"}},null,1941,2006,2,0.384,1824,null,"Mitglieder mit 3 Kindern",null,3,{"v":0.012,"d":"1.20%"},{"v":0.017,"d":"1.70%"},{"v":0.017,"d":"1.70%"},{"v":0.012,"d":"1.20%"}]
[null,"STKL",{"$f":"+Berechnung!P11","v":1},null,"AV_Satz",{"v":0.026,"d":"2.60%"},{"$f":"F6/2","v":{"v":0.013,"d":"1.300%"}},null,1942,2007,3,0.368,1748,null,"Mitglieder mit 4 Kindern",null,4,{"v":9.499999999999998E-3,"d":"0.95%"},{"v":0.017,"d":"1.70%"},{"v":0.014499999999999999,"d":"1.45%"},{"v":0.012,"d":"1.20%"}]
[null,"JLHINZU",{"$f":"IF(C6=6,0,Berechnung!P23*100)","v":0},null,"PV_Satz",{"$f":"+SUM(Q12:Q13)","v":{"v":0.04,"d":"4.00%"}},{"$f":"+Q12","v":{"v":0.023,"d":"2.300%"}},"ohne / mit Kind",1943,2008,4,0.352,1672,null,"Mitglieder mit 5 und mehr Kindern",null,5,{"v":0.006999999999999999,"d":"0.70%"},{"v":0.017,"d":"1.70%"},{"v":0.012,"d":"1.20%"},{"v":0.012,"d":"1.20%"}]
[null,"JLFREIB",{"$f":"Berechnung!P24*100","v":0},null,"PV_Satz Sachsen",{"$f":"+Q12","v":{"v":0.023,"d":"2.300%"}},null,null,1944,2009,5,0.336,1596]
[null,"BBGRV",{"$f":"IF(Berechnung!P20=0,F15,F16)","v":{"v":87600,"d":"87,600"}},null,"PV_Satz Sachsen",{"v":0,"d":"0.000%"},null,null,1945,2010,6,{"v":0.32,"d":"0.320"},1520,null,"Anzahl Kinder für Pflegeversicherung",null,{"$f":"IF(ISNUMBER(Berechnung!P19),Berechnung!P19,0)","v":0}]
[null,"PKV",{"$f":"IF(Eingaben!H12>20,MAX($C$31,ROUNDDOWN(Eingaben!H12*12,2)-IF(Eingaben!P14=1,IF(Eingaben!P16=1,SUM(F11,F7,-F8),SUM(F11,F7/2))*MIN(C5/100,F17),0)),0)","v":0},null,"KV ZUSATZ Schnitt",{"v":0.016,"d":"1.600%"},null,null,1946,2011,7,0.304,1444,null,"Arbeitsort in Sachsen",null,{"$f":"IF(ISNUMBER(Berechnung!P21),Berechnung!P21,0)","v":0}]
[null,"PV%",{"$f":"+Q12","v":{"v":0.023,"d":"0.02300"}},null,"KVSATZ AG",{"v":0.078,"d":"7.80%"},{"$f":"F3/2+F7-G7+F10/2","v":{"v":0.098,"d":"9.800%"}},"KV plus PV AG",1947,2012,8,0.288,1368]
[null,"FAKTOR F",{"$f":"IF(OR(OR(Berechnung!P12=0,Berechnung!P12>1),Berechnung!P11<>4),1,Berechnung!P12)","v":{"v":1,"d":"1.00"}},{"$nulls":5},1948,2013,9,0.272,1292,null,"Wert für Pflegeversicherung - AN",null,{"$f":"+IF(Q10=0,VLOOKUP(Q9,Q2:R7,2,FALSE),VLOOKUP(Q9,Q2:T7,4,FALSE))","v":{"v":0.023,"d":"2.30%"}}]
["MRE4ALTE","TAB4",{"$f":"VLOOKUP(Eingaben!T26,K3:L23,2,FALSE)","v":0},null,"BMF - PAP - ANGABEN",{"$nulls":3},1949,2014,10,0.256,1216,null,"Wert für Pflegeversicherung - AG",null,{"$f":"+IF(Q10=0,VLOOKUP(Q9,Q2:S7,3,FALSE),VLOOKUP(Q9,Q2:U7,5,FALSE))","v":{"v":0.017,"d":"1.70%"}}]
[null,"TAB5",{"$f":"VLOOKUP(Eingaben!T26,K3:M23,3,FALSE)*100","v":0},null,"Name","WERT","Bereich",null,1950,2015,11,{"v":0.24,"d":"0.240"},1140]
[null,"ALTEANTEIL",{"$f":"C14","v":0},null,"BBGRV",{"v":87600,"d":"87,600"},"MPARA",null,1951,2016,12,0.224,1064]
[null,"ALTE",{"$f":"IF(Berechnung!P22=0,0,IF((C5*C13)>C15,C15,C5*C13))","v":0},null,"BBGRV",{"v":85200,"d":"85,200"},null,null,1952,2017,13,0.208,988]
[null,"ZRE4",{"$f":"C5-C8+C7-C16","v":{"$error":"#VALUE!"}},null,"BBGKVPV",{"v":59850,"d":"59,850"},null,null,1953,2018,14,0.192,912]
[null,"ZRE4VP",{"$f":"C5","v":{"$error":"#VALUE!"}},null,"KVSATZAG",{"v":0.07800000000000001,"d":"0.07800"},null,null,1954,2019,15,0.176,836,null,{"$f":"0.008+0.07","v":0.07800000000000001}]
[{"$nulls":4},"TBSVORV",{"v":1,"d":"1.00"},null,null,1955,2020,16,{"v":0.16,"d":"0.160"},760]
["MRE4","ZRE4",{"$f":"C17/100","v":{"$error":"#VALUE!"}},null,"W1STKL5",{"v":12485,"d":"12,485"},null,null,1956,2021,17,0.152,722]
[null,"ZRE4VP",{"$f":"C18/100","v":{"$error":"#VALUE!"}},null,"W2STKL5",{"v":31404,"d":"31,404"},null,null,1957,2022,18,0.144,684]
[{"$nulls":4},"W3STKL5",{"v":222260,"d":"222,260"},null,null,1958,2023,19,0.136,646]
["MZTABFB","KZTAB",{"$f":"IF(C6=3,2,1)","v":1},null,"GFB",{"v":10908,"d":"10,908"},null,null,1959,2024,20]
[null,"ANP",{"$f":"F25","v":{"v":1230,"d":"1,230"}},null,"SOLZFREI",{"v":17543,"d":"17,543.00"},null,null,1960,2025,21,{"v":0.12,"d":"0.120"},570]
[null,"EFA",{"$f":"IF(C6=2,F26,0)","v":0},null,"ANP",{"v":1230,"d":"1,230"},"MZTABFB",null,1961,2026,22,0.112,532]
[null,"SAP",{"$f":"IF(C6>5,0,F27)","v":36},null,"EFA",{"v":4260,"d":"4,260"},null,null,1962,2027,23,0.104,494,null,"NEU","Änderung noch nicht im Ablaufpan"]
[null,"KFB",{"$f":"IF(C6<4,C2*F28,IF(C6=4,C2*F28/2,0))","v":0},null,"SAP",36,null,null,1963,2028,24,0.096,456]
[null,"ZTABFB",{"$f":"IF(C6=6,0,C24+C25+C26)","v":{"v":1266,"d":"1,266"}},null,"KFB",{"v":8952,"d":"8,952"},null,null,1964,2029,25,0.088,418]
["UPEVP","ZRE4VP",{"$f":"MIN(C9,C21)","v":{"$error":"#VALUE!"}},null,"VHB / VSP2",{"v":1900,"d":"1,900"},"UPEVP",null,1965,2030,26,{"v":0.08,"d":"0.080"},380,null,"ANP",{"v":1230,"d":"1,230"}]
[null,"VSP1",{"$f":"IF(C4=1,0,ROUNDDOWN(F19*C29*G5,2))","v":{"$error":"#VALUE!"}},null,"VHB / VSP2",{"v":3000,"d":"3,000"},null,null,1966,2031,27,0.072,342,null,"EFA",{"v":4260,"d":"4,260"}]
[null,"VHB",{"$f":"IF(C23=1,F29,F30)","v":{"v":1900,"d":"1,900.00"}},null,null,0.42,"MST5-6",null,1967,2032,28,0.064,304]
[null,"VSP2",{"$f":"MIN(C31,ROUNDDOWN(0.12*C29,2))","v":{"$error":"#VALUE!"}},null,null,0.45,null,null,1968,2033,29,0.056,266]
[null,{"$f":"IF(Eingaben!H12=0,\"KVSatz=0\",(Eingaben!H12 +Eingaben!H13)/2 & \" % + PV\")","v":"KVSatz=0"},{"$f":"IF(Berechnung!P16=0,0,G4+C11)","v":{"v":0.093,"d":"0.09300"}},null,"SOLI",{"v":5.5,"d":"5.50"},"MSOLZ",null,1969,2034,30,0.048,228]
[null,"KV",{"$f":"IF(C10>0,IF(C6=6,0,C10),ROUNDDOWN(MIN(C21,F17)*C33*100,0)/100)","v":{"$error":"#VALUE!"}},null,null,{"v":11.9,"d":"11.90"},"SOLZMIN F",null,1970,2035,31,{"v":0.04,"d":"0.040"},190]
[null,"KV>VHB?",{"$f":"IF(C34>C31,C34,C32)","v":{"$error":"#VALUE!"}},null,null,{"v":16000,"d":"16,000"},"UPTAB23",null,1971,2036,32,0.032,152]
[null,"VSPN",{"$f":"ROUNDUP(C30+C35,0)","v":{"$error":"#VALUE!"}},null,null,{"v":62810,"d":"62,810"},null,null,1972,2037,33,0.024,114]
["UMVSP","ZVE",{"$f":"ROUNDDOWN(C20-C28-C36,0)","v":{"$error":"#VALUE!"}},null,null,{"v":277826,"d":"277,826"},null,null,1973,2038,34,0.016,76]
[null,"ZZX",{"$f":"MAX(0,ROUNDDOWN(C37/C23,0))","v":{"$error":"#VALUE!"}},null,null,192.59,null,null,1974,2039,35,0.008,38]
["UPTAB16","ST",{"$f":"IF(C38<=F23,0,IF(C38<=F35,INT((F41*(C38-F23)/10000+F42)*(C38-F23)/10000),IF(C38<=F36,INT((F38*(C38-F35)/10000+F39)*(C38-F35)/10000+F40),IF(C38<F37,INT(C38*F31-F43),INT(C38*F32-F44)))))*C23","v":{"$error":"#VALUE!"}},null,null,{"v":2397,"d":"2,397"},null,null,1975,2040,36,{"v":0,"d":"0.000"},0]
["MST5-6","X",{"$f":"MIN(F21,C38)*1.25","v":{"$error":"#VALUE!"}},null,null,966.53]
[null,"ST1",{"$f":"IF(C40<=F23,0,IF(C40<=F35,INT((F41*(C40-F23)/10000+F42)*(C40-F23)/10000),IF(C40<=F36,INT((F38*(C40-F35)/10000+F39)*(C40-F35)/10000+F40),IF(C40<=F37,INT(C40*F31-F43),INT(C40*F32-F44)))))","v":{"$error":"#VALUE!"}},null,null,979.18]
[null,"X",{"$f":"MIN(F21,C38)*0.75","v":{"$error":"#VALUE!"}},null,null,{"v":1400,"d":"1,400"}]
[null,"ST2",{"$f":"IF(C42<=F23,0,IF(C42<=F35,INT((F41*(C42-F23)/10000+F42)*(C42-F23)/10000),IF(C42<F36,INT((F38*(C42-F35)/10000+F39)*(C42-F35)/10000+F40),IF(C42<F37,INT(C42*F31-F43),INT(C42*F32-F44)))))","v":{"$error":"#VALUE!"}},null,null,{"v":9972.98,"d":"9,972.98"}]
[null,"DIFF",{"$f":"(C41-C43)*2","v":{"$error":"#VALUE!"}},null,null,{"v":18307.73,"d":"18,307.73"}]
[null,"MIST",{"$f":"ROUNDDOWN(MIN(C38,F21)*0.14,0)","v":{"$error":"#VALUE!"}}]
[null,"ST",{"$f":"MAX(C44,C45)","v":{"$error":"#VALUE!"}}]
[null,"ST",{"$f":"IF(C38>F22,(F22 - F21)*F31 + C46,ROUNDDOWN(MAX(C38-F21,0)*F31+C46,0))","v":{"$error":"#VALUE!"}}]
[null,"VERGL",{"$f":"IF(AND(C38>F20,C38<=F21),C46,0)","v":{"$error":"#VALUE!"}}]
[null,"ST",{"$f":"ROUNDDOWN(F20*0.14,0)","v":{"v":1747,"d":"1,747"}}]
[null,"ST",{"$f":" MIN(ROUNDDOWN(MAX(C38-F20,0)*F31+C49,0),C47)","v":{"$error":"#VALUE!"}}]
[null,"MIT REICHST",{"$f":"ROUNDDOWN(MAX(C38-F22,0)*F32+C50,0)","v":{"$error":"#VALUE!"}}]
[null,"LSTJAHR",{"$f":"ROUNDDOWN(IF(C6<5,C39,C51)*C12,0)","v":{"$error":"#VALUE!"}}]
[null,"JW",{"$f":"C52*100","v":{"$error":"#VALUE!"}}]
["MLSTJAHR","LSTLZZ",{"$f":"IF(C3=1,C53,IF(C3=2,ROUNDDOWN(C53/12,0),IF(C3=3,ROUNDDOWN((C53*7)/360,0),ROUNDDOWN(C53/360,0))))","v":{"$error":"#VALUE!"}}]
[null,"ZTABFB",{"$f":"C27+C28","v":{"v":1266,"d":"1,266"}}]
[null,"ZVE",{"$f":"C20-C36-C55","v":{"$error":"#VALUE!"}}]
[null,"ZVE, X",{"$f":"IF(C56<36,0,ROUNDDOWN(C56/C23,0))","v":{"$error":"#VALUE!"}}]
[null,"ST",{"$f":"IF(C57<=F23,0,IF(C57<=F35,INT((F41*(C57-F23)/10000+F42)*(C57-F23)/10000),IF(C57<=F36,INT((F38*(C57-F35)/10000+F39)*(C57-F35)/10000+F40),IF(C57<F37,INT(C57*F31-F43),INT(C57*F32-F44)))))*C23","v":{"$error":"#VALUE!"}}]
[null,"JBMG",{"$f":"IF(C2>0,ROUNDDOWN(C58*C12,0),C52)","v":{"$error":"#VALUE!"}}]
["MSOLZ","SOLZFREI",{"$f":"(F24)*C23","v":17543}]
[null,"SOLZJ",{"$f":"ROUNDDOWN((C59*F33)/100,2)","v":{"$error":"#VALUE!"}}]
[null,"SOLZMIN",{"$f":"((C59-C60)*F34)/100","v":{"$error":"#VALUE!"}}]
[null,"SOLZJ",{"$f":"MIN(C62,C61)","v":{"$error":"#VALUE!"}}]
[null,"JW",{"$f":"C63*100","v":{"$error":"#VALUE!"}}]
["SOLZ","ANTEIL1",{"$f":"ROUNDDOWN(IF(C3=1,C64,IF(C3=2,C64/12,IF(C3=3,(C64*7)/360,C64/360))),0)","v":{"$error":"#VALUE!"}}]
[null,"SOLZLZZ",{"$f":"IF(C59>C60,C65,0)","v":{"$error":"#VALUE!"}}]
[null,"JW",{"$f":"C59*100","v":{"$error":"#VALUE!"}}]
["BK","BK",{"$f":"ROUNDDOWN(IF(C3=1,C67,IF(C3=2,C67/12,IF(C3=3,(C67*7)/360,C67/360))),0)","v":{"$error":"#VALUE!"}}]
["FAKTOR LZZ","FLZZ",{"$f":"IF(C3=1,12,IF(C3=2,1,IF(C3=3,84/360,12/360)))","v":{"v":12,"d":"12.00000000"}}]

{"sheet":"Berechnung_Alt","index":7,"n_rows":45,"n_cols":18,"rows_kept":45,"hidden":true,"merged":[[3,1,3,13],[5,3,5,8],[12,7,12,8],[21,3,21,5],[21,7,21,8],[25,3,25,5],[40,1,40,3]]}
[]
[{"$nulls":15},{"$f":"+Eingaben!X34","v":0}]
[{"$nulls":13},"Berechnung"]
[null,"Lohnsteuer-Rechner 2023 - Berechnung"]
[]
[{"$nulls":3},{"$f":"+IF(P2=0,\"Es fehlen noch Angaben im Arbeitblatt Eingaben\",\"Alle erforderlichen Eingaben wurden gemacht\")","v":"Es fehlen noch Angaben im Arbeitblatt Eingaben"}]
[]
[{"$nulls":3},"Steuerpflichtiger Arbeitslohn in Euro",{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(Eingaben!H5=\"\",\"\",Eingaben!H5))","v":""},{"$nulls":3},{"$f":"+H8","v":""},{"$nulls":5},{"$f":"+L8","v":""}]
[{"$nulls":3},"Für welchen Zeitraum soll die LSt berechnet werden?",{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(Eingaben!H6=\"\",\"\",Eingaben!H6))","v":""},{"$nulls":3},{"$f":"+P9","v":1},{"$nulls":3},{"$f":"+IF(H9=\"Jahr\",1,IF(H9=\"Monat\",2,IF(H9=\"Woche\",3,IF(H9=\"Tag\",4,1))))","v":1},null,{"$f":"+P9","v":1}]
[]
[{"$nulls":3},"Steuerklasse",{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(Eingaben!H7=\"\",\"\",Eingaben!H7))","v":""},{"$nulls":3},1,{"$nulls":3},{"$f":"+IF(ISNUMBER(H11),H11,1)","v":1},null,{"$f":"+P11","v":1}]
[{"$nulls":3},"Ehegattenfaktor (3 Nachkommastellen) nur für StKl IV",{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(H11<>4,\"\",IF(Eingaben!H8=\"\",0,Eingaben!H8)))","v":""},{"$nulls":3},{"v":0,"d":"0.000"},{"$nulls":3},{"$f":"+IF(ISNUMBER(H12),H12,0)","v":0},null,{"$f":"+P12","v":0}]
[{"$nulls":3},"allgemeine oder besondere LSt-Tabelle",{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(Eingaben!H9=\"\",\"\",Eingaben!H9))","v":""},{"$f":"+IF(Eingaben!I9=\"\",\"\",Eingaben!I9)","v":""},null,null,0,{"$nulls":3},{"$f":"+IF(H13=\"Allgemeine LSt-Tabelle\",0,IF(H13=\"Besondere LSt-Tabelle\",1,0))","v":0},null,{"$f":"+P13","v":0}]
[{"$nulls":3},"Kinderfreibetrag",{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(Eingaben!H10=\"\",\"\",Eingaben!H10))","v":""},{"$nulls":3},0,{"$nulls":3},{"$f":"+IF(ISNUMBER(H14),H14,0)","v":0},null,{"$f":"+P14","v":0}]
[{"$nulls":3},"Kirchensteuer",{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(Eingaben!H11=\"\",\"\",Eingaben!H11))","v":""},{"$nulls":3},0,{"$nulls":3},{"$f":"+IF(ISNUMBER(H15),H15,0)","v":0},null,{"$f":"+P15*100","v":0}]
[{"$nulls":3},"Krankenversicherungssatz, bzw. PKV-Basisprämie in €",{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(Eingaben!H12=\"\",\"\",Eingaben!H12))","v":""},{"$nulls":3},15.5,{"$nulls":3},{"$f":"+IF(ISNUMBER(H16),H16,15.5)","v":15.5},null,{"$f":"P16","v":15.5}]
[{"$nulls":3},"Krankenkassen-Zusatzbeitragsatz (d. Arbeitnehmers)",{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(Eingaben!H13=\"\",\"\",IF(H16>20,0,Eingaben!H13)))","v":""},{"$nulls":3},{"$f":"+P17","v":""},{"$nulls":3},{"$f":"+H17","v":""},null,{"$f":"+P17","v":""}]
[{"$nulls":3},"Arbeitgeberzuschuss zur privaten KV",{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(Eingaben!H14=\"\",\"\",Eingaben!H14))","v":""},{"$nulls":7},{"$f":"+IF(H18=\"Ja\",1,0)","v":0}]
[{"$nulls":3},"Sonderabgabe zur Pflegeversicherung",{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(Eingaben!H15=\"\",\"\",Eingaben!H15))","v":""},{"$nulls":3},0,{"$nulls":3},{"$f":"+IF(H19=\"Ja\",1,0)","v":0},null,{"$f":"+P19","v":0}]
[{"$nulls":3},"Arbeitsstelle in Ostdeutschland",{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(Eingaben!H16=\"\",\"\",Eingaben!H16))","v":""},{"$nulls":3},0,{"$nulls":3},{"$f":"+IF(H20=\"Ja\",1,0)","v":0},null,0]
[{"$nulls":3},{"$f":"+IF(P20=1,\"  Arbeitsort in Sachsen?\",\"  Arbeitsort liegt nicht in Sachsen\")","v":"  Arbeitsort liegt nicht in Sachsen"},{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(Eingaben!H17=\"\",\"\",Eingaben!H17))","v":""},{"$nulls":3},0,{"$nulls":3},{"$f":"+IF(P20=0,0,IF(H21=\"Ja\",1,0))","v":0},null,0]
[{"$nulls":3},"Altersentlastungsbetrag",{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(Eingaben!H18=\"\",\"\",Eingaben!H18))","v":""},{"$f":"+IF(Eingaben!I18=\"\",\"\",Eingaben!I18)","v":""},null,null,0,{"$nulls":3},{"$f":"IF(ISERROR(VLOOKUP(H22,Eingaben!R6:S25,2,FALSE)),0,VLOOKUP(H22,Eingaben!R6:S25,2,FALSE))","v":0},null,0]
[{"$nulls":3},"(Jahres)Hinzurechnungen",{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(Eingaben!H19=\"\",\"\",Eingaben!H19))","v":""},{"$nulls":3},{"v":0,"d":"0.00"},{"$nulls":3},{"$f":"+IF(ISNUMBER(H23),H23,0)","v":0},null,0]
[{"$nulls":3},"(Jahres)lohnsteuerfreibetrag auf LSt-Karte",{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(Eingaben!H20=\"\",\"\",Eingaben!H20))","v":""},{"$nulls":3},{"v":0,"d":"0.00"},{"$nulls":3},{"$f":"+IF(ISNUMBER(H24),H24,0)","v":0},null,0]
[{"$nulls":3},{"$f":"IF(AND(AND(L12>0,L12<1),L11=4),\"Ehegattenfaktor von \" & L12 & \" berücksichtigt\",\"\")","v":""}]
[{"$nulls":3},"Berechnungsergebnisse:"]
[]
[{"$nulls":3},"Lohnsteuer",{"$nulls":3},{"$f":"IF($P$2=0,\"\",LSTBerechnung2023!C54/100)","v":""}]
[{"$nulls":3},"Solidaritätszuschlag",{"$nulls":3},{"$f":"IF($P$2=0,\"\",LSTBerechnung2023!C66/100)","v":""}]
[{"$nulls":3},"Kirchensteuer",{"$nulls":3},{"$f":"IF($P$2=0,\"\",ROUNDDOWN(LSTBerechnung2023!C68*Berechnung_Alt!R15/10000,2))","v":""}]
[]
[{"$nulls":3},"Rentenversicherung",{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(P13=0,ROUND(IF(P9=1,\nIF(H8>LSTBerechnung2023!C9,LSTBerechnung2023!C9,H8),IF(P9=2,\nIF(H8>(LSTBerechnung2023!C9/12),(LSTBerechnung2023!C9/12),H8),\nIF(P9=3,\nIF(H8>(LSTBerechnung2023!C9/360*7),(LSTBerechnung2023!C9/360*7),H8),\nIF(H8>(LSTBerechnung2023!C9/360),(LSTBerechnung2023!C9/360),H8))))*0.093,2),0))","v":""}]
[{"$nulls":3},"Krankenversicherung",{"$nulls":3},{"$f":"IF(ISERROR(IF(H16>20,IF(P18=0,H16*LSTBerechnung2023!$C$69,MAX(H16/2*LSTBerechnung2023!$C$69,(H16-(LSTBerechnung2023!G11*LSTBerechnung2023!F17/12))*LSTBerechnung2023!$C$69)),IF(H16=0,0,ROUND(IF(P9=1,IF(H8>LSTBerechnung2023!F17,LSTBerechnung2023!F17,H8),IF(P9=2,IF(H8>(LSTBerechnung2023!F17/12),(LSTBerechnung2023!F17/12),H8),IF(P9=3,IF(H8>(LSTBerechnung2023!F17/360*7),(LSTBerechnung2023!F17/360*7),H8),IF(H8>(LSTBerechnung2023!F17/360),(LSTBerechnung2023!F17/360),H8))))*((H16+H17)/2*0.01),2)))),\"\",IF(H16>20,IF(P18=0,H16*LSTBerechnung2023!$C$69,MAX(H16/2*LSTBerechnung2023!$C$69,(H16-(LSTBerechnung2023!G11*LSTBerechnung2023!F17/12))*LSTBerechnung2023!$C$69)),IF(H16=0,0,ROUND(IF(P9=1,IF(H8>LSTBerechnung2023!F17,LSTBerechnung2023!F17,H8),IF(P9=2,IF(H8>(LSTBerechnung2023!F17/12),(LSTBerechnung2023!F17/12),H8),IF(P9=3,IF(H8>(LSTBerechnung2023!F17/360*7),(LSTBerechnung2023!F17/360*7),H8),IF(H8>(LSTBerechnung2023!F17/360),(LSTBerechnung2023!F17/360),H8))))*((H16+H17)/2*0.01),2))))","v":""},{"$nulls":7},{"$f":"IF(ISERROR(IF(P16=0,\"Privat Krankenversichert ohne Nachweis\",IF(P16>20,\"Basisprämie KV, AG-Anteil abgezogen\",(P16+P17)/2 & \" % Krankenversicherungsbeitrag\"))),\"14,6 % Krankenversicherung\",IF(P16=0,\"Privat Krankenversichert ohne Nachweis\",IF(P16>20,\"Basisprämie KV, AG-Anteil abgezogen\",(P16+P17)/2 & \" % Krankenversicherungsbeitrag\")))","v":"14,6 % Krankenversicherung"}]
[{"$nulls":3},"Pflegeversicherung",{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(P16>20,0,IF(P16=0,0,ROUND(IF(P9=1,IF(H8>LSTBerechnung2023!F17,LSTBerechnung2023!F17,H8),IF(P9=2,IF(H8>(LSTBerechnung2023!F17/12),(LSTBerechnung2023!F17/12),H8),IF(P9=3,IF(H8>(LSTBerechnung2023!F17/360*7),(LSTBerechnung2023!F17/360*7),H8),IF(H8>(LSTBerechnung2023!F17/360),(LSTBerechnung2023!F17/360),H8)))),2)))*LSTBerechnung2023!C11)","v":""},{"$nulls":7},{"$f":"IF(P21=1,2.025,1.525) + IF(P19=1,0.25,0) & \" % Pflegeversicherung\"","v":"1,525 % Pflegeversicherung"}]
[{"$nulls":3},"Arbeitslosenversicherung",{"$nulls":3},{"$f":"IF($P$2=0,\"\",IF(P13=0,ROUND(IF(P9=1,IF(H8>LSTBerechnung2023!C9,LSTBerechnung2023!C9,H8),IF(P9=2,IF(H8>(LSTBerechnung2023!C9/12),(LSTBerechnung2023!C9/12),H8),IF(P9=3,IF(H8>(LSTBerechnung2023!C9/360*7),(LSTBerechnung2023!C9/360*7),H8),IF(H8>(LSTBerechnung2023!C9/360),(LSTBerechnung2023!C9/360),H8))))*LSTBerechnung2023!G6,2),0))","v":""}]
[]
[{"$nulls":3},"Abzüge",{"$nulls":3},{"$f":"IF($P$2=0,\"\",SUM(H28:H35))","v":""}]
[{"$nulls":3},"Nettolohn",{"$nulls":3},{"$f":"IF(H8=\"\",\"\",L8-H37)","v":""}]
[]
[]
[null,"<< Startseite",null,null,"Beispiel","Hilfe?"]
[]
[null,"© 2023 by mediaforwork - ein Unternehmensbereich der Verlag für die Deutsche Wirtschaft AG"]
[null,"Die Vervielfältigung, Verbreitung oder Veräußerung der Daten oder Texte ist unzulässig und"]
[null,"ausdrücklich nur mit Genehmigung des Verlags gestattet."]

{"sheet":"LSTBerechnung2023","index":8,"n_rows":69,"n_cols":16,"rows_kept":69,"hidden":true,"merged":[[0,8,0,12]]}
["LST",2022,null,null,{"$f":"\"SOZ-VS-BEITRAGSSÄTZE  \"&BearbJahr","v":"SOZ-VS-BEITRAGSSÄTZE  2022"},{"$nulls":3},"Altersentlastungsbetrag"]
["MPARA","ZKF",{"$f":"IF(Berechnung!P11>4,0,Berechnung!P14)","v":0},null,"Bezeichnung","SATZ","Berechnet",null,"Geburtsjahr","Jahr","Nummer","TAB4","TAB5"]
[null,"LZZ",{"$f":"Berechnung!P9","v":1},null,"KVSATZ",{"v":0.146,"d":"14.600%"},{"$f":"F3/2+F4","v":{"v":0.073,"d":"7.300%"}},{"$nulls":3},0,0,0]
[null,"KRV",{"$f":"Berechnung!P13","v":0},null,"KV_Zusatz",{"$f":"Eingaben!H13/100","v":{"v":0,"d":"0.00%"}},{"$f":"F4/2+0.07","v":{"v":0.07,"d":"7.000%"}},null,"vor 1941","bis 2005",1,{"v":0.4,"d":"0.400"},1900]
[null,"ZRE4J",{"$f":"ROUNDDOWN(IF(C3=1,Berechnung!H8*100,IF(C3=2,(Berechnung!H8*100)*12,IF(C3=3,((Berechnung!H8*100)*360)/7,(Berechnung!H8*100)*360))),2)","v":{"$error":"#VALUE!"}},null,"RV_Satz",{"v":0.186,"d":"18.60%"},{"$f":"F5/2","v":{"v":0.093,"d":"9.300%"}},null,1941,2006,2,0.384,1824]
[null,"STKL",{"$f":"+Berechnung!P11","v":1},null,"AV_Satz",{"v":0.026,"d":"2.60%"},{"$f":"F6/2","v":{"v":0.013,"d":"1.300%"}},null,1942,2007,3,0.368,1748]
[null,"JLHINZU",{"$f":"IF(C6=6,0,Berechnung!P23*100)","v":0},null,"PV_Satz",{"v":0.0305,"d":"3.05%"},{"$f":"IF(AND(Eingaben!P15=1,Eingaben!P17),F8+F9,IF(Eingaben!P15=1,F8,IF(AND(Eingaben!P10=0,Eingaben!P15=1),F7/2+F9,F7/2)))","v":{"v":0.01525,"d":"1.525%"}},"ohne / mit Kind",1943,2008,4,0.352,1672]
[null,"JLFREIB",{"$f":"Berechnung!P24*100","v":0},null,"PV_Satz Sachsen",{"v":0.02025,"d":"2.025%"},null,null,1944,2009,5,0.336,1596]
[null,"BBGRV",{"$f":"IF(Berechnung!P20=0,F15,F16)","v":{"v":87600,"d":"87,600"}},null,"PV_Satz Sachsen",{"v":0.0035,"d":"0.350%"},null,null,1945,2010,6,{"v":0.32,"d":"0.320"},1520]
[null,"PKV",{"$f":"IF(Eingaben!H12>20,MAX($C$31,ROUNDDOWN(Eingaben!H12*12,2)-IF(Eingaben!P14=1,IF(Eingaben!P16=1,SUM(F11,F7,-F8),SUM(F11,F7/2))*MIN(C5/100,F17),0)),0)","v":0},null,"KV ZUSATZ Schnitt",{"v":0.016,"d":"1.600%"},null,null,1946,2011,7,0.304,1444]
[null,"PV%",{"$f":"IF(AND(Berechnung!P19=1,Berechnung!P21=1),F8+F9,IF(Berechnung!P21=1,F8,IF(AND(Berechnung!P14=0,Berechnung!P19=1),F7/2+F9,F7/2)))","v":0.01525},null,"KVSATZ AG",{"v":0.078,"d":"7.80%"},{"$f":"F3/2+F7-G7+F10/2","v":{"v":0.09625,"d":"9.625%"}},"KV plus PV AG",1947,2012,8,0.288,1368]
[null,"FAKTOR F",{"$f":"IF(OR(OR(Berechnung!P12=0,Berechnung!P12>1),Berechnung!P11<>4),1,Berechnung!P12)","v":{"v":1,"d":"1.00"}},{"$nulls":5},1948,2013,9,0.272,1292]
["MRE4ALTE","TAB4",{"$f":"VLOOKUP(Eingaben!T26,K3:L23,2,FALSE)","v":0},null,"BMF - PAP - ANGABEN",{"$nulls":3},1949,2014,10,0.256,1216,null,null,{"$f":"2005-64","v":1941}]
[null,"TAB5",{"$f":"VLOOKUP(Eingaben!T26,K3:M23,3,FALSE)*100","v":0},null,"Name","WERT","Bereich",null,1950,2015,11,{"v":0.24,"d":"0.240"},1140]
[null,"ALTEANTEIL",{"$f":"C14","v":0},null,"BBGRV",{"v":87600,"d":"87,600"},"MPARA",null,1951,2016,12,0.224,1064]
[null,"ALTE",{"$f":"IF(Berechnung!P22=0,0,IF((C5*C13)>C15,C15,C5*C13))","v":0},null,"BBGRV",{"v":85200,"d":"85,200"},null,null,1952,2017,13,0.208,988]
[null,"ZRE4",{"$f":"C5-C8+C7-C16","v":{"$error":"#VALUE!"}},null,"BBGKVPV",{"v":59850,"d":"59,850"},null,null,1953,2018,14,0.192,912]
[null,"ZRE4VP",{"$f":"C5","v":{"$error":"#VALUE!"}},null,"KVSATZAG",{"v":0.07800000000000001,"d":"0.07800"},null,null,1954,2019,15,0.176,836,null,{"$f":"0.008+0.07","v":0.07800000000000001}]
[{"$nulls":4},"TBSVORV",{"v":1,"d":"1.00"},null,null,1955,2020,16,{"v":0.16,"d":"0.160"},760]
["MRE4","ZRE4",{"$f":"C17/100","v":{"$error":"#VALUE!"}},null,"W1STKL5",{"v":12485,"d":"12,485"},null,null,1956,2021,17,0.152,722]
[null,"ZRE4VP",{"$f":"C18/100","v":{"$error":"#VALUE!"}},null,"W2STKL5",{"v":31404,"d":"31,404"},null,null,1957,2022,18,0.144,684]
[{"$nulls":4},"W3STKL5",{"v":222260,"d":"222,260"},null,null,1958,2023,19,0.136,646]
["MZTABFB","KZTAB",{"$f":"IF(C6=3,2,1)","v":1},null,"GFB",{"v":10908,"d":"10,908"},null,null,1959,2024,20]
[null,"ANP",{"$f":"F25","v":{"v":1230,"d":"1,230"}},null,"SOLZFREI",{"v":17543,"d":"17,543.00"},null,null,1960,2025,21,{"v":0.12,"d":"0.120"},570]
[null,"EFA",{"$f":"IF(C6=2,F26,0)","v":0},null,"ANP",{"v":1230,"d":"1,230"},"MZTABFB",null,1961,2026,22,0.112,532]
[null,"SAP",{"$f":"IF(C6>5,0,F27)","v":36},null,"EFA",{"v":4260,"d":"4,260"},null,null,1962,2027,23,0.104,494,null,"NEU","Änderung noch nicht im Ablaufpan"]
[null,"KFB",{"$f":"IF(C6<4,C2*F28,IF(C6=4,C2*F28/2,0))","v":0},null,"SAP",36,null,null,1963,2028,24,0.096,456]
[null,"ZTABFB",{"$f":"IF(C6=6,0,C24+C25+C26)","v":{"v":1266,"d":"1,266"}},null,"KFB",{"v":8952,"d":"8,952"},null,null,1964,2029,25,0.088,418]
["UPEVP","ZRE4VP",{"$f":"MIN(C9,C21)","v":{"$error":"#VALUE!"}},null,"VHB / VSP2",{"v":1900,"d":"1,900"},"UPEVP",null,1965,2030,26,{"v":0.08,"d":"0.080"},380,null,"ANP",{"v":1230,"d":"1,230"}]
[null,"VSP1",{"$f":"IF(C4=1,0,ROUNDDOWN(F19*C29*G5,2))","v":{"$error":"#VALUE!"}},null,"VHB / VSP2",{"v":3000,"d":"3,000"},null,null,1966,2031,27,0.072,342,null,"EFA",{"v":4260,"d":"4,260"}]
[null,"VHB",{"$f":"IF(C23=1,F29,F30)","v":{"v":1900,"d":"1,900.00"}},null,null,0.42,"MST5-6",null,1967,2032,28,0.064,304]
[null,"VSP2",{"$f":"MIN(C31,ROUNDDOWN(0.12*C29,2))","v":{"$error":"#VALUE!"}},null,null,0.45,null,null,1968,2033,29,0.056,266]
[null,{"$f":"IF(Eingaben!H12=0,\"KVSatz=0\",(Eingaben!H12 +Eingaben!H13)/2 & \" % + PV\")","v":"KVSatz=0"},{"$f":"IF(Berechnung!P16=0,0,G4+C11)","v":0.08525},null,"SOLI",{"v":5.5,"d":"5.50"},"MSOLZ",null,1969,2034,30,0.048,228]
[null,"KV",{"$f":"IF(C10>0,IF(C6=6,0,C10),ROUNDDOWN(MIN(C21,F17)*C33*100,0)/100)","v":{"$error":"#VALUE!"}},null,null,{"v":11.9,"d":"11.90"},"SOLZMIN F",null,1970,2035,31,{"v":0.04,"d":"0.040"},190]
[null,"KV>VHB?",{"$f":"IF(C34>C31,C34,C32)","v":{"$error":"#VALUE!"}},null,null,{"v":16000,"d":"16,000"},"UPTAB23",null,1971,2036,32,0.032,152]
[null,"VSPN",{"$f":"ROUNDUP(C30+C35,0)","v":{"$error":"#VALUE!"}},null,null,{"v":62810,"d":"62,810"},null,null,1972,2037,33,0.024,114]
["UMVSP","ZVE",{"$f":"ROUNDDOWN(C20-C28-C36,0)","v":{"$error":"#VALUE!"}},null,null,{"v":277826,"d":"277,826"},null,null,1973,2038,34,0.016,76]
[null,"ZZX",{"$f":"MAX(0,ROUNDDOWN(C37/C23,0))","v":{"$error":"#VALUE!"}},null,null,192.59,null,null,1974,2039,35,0.008,38]
["UPTAB16","ST",{"$f":"IF(C38<=F23,0,IF(C38<=F35,INT((F41*(C38-F23)/10000+F42)*(C38-F23)/10000),IF(C38<=F36,INT((F38*(C38-F35)/10000+F39)*(C38-F35)/10000+F40),IF(C38<F37,INT(C38*F31-F43),INT(C38*F32-F44)))))*C23","v":{"$error":"#VALUE!"}},null,null,{"v":2397,"d":"2,397"},null,null,1975,2040,36,{"v":0,"d":"0.000"},0]
["MST5-6","X",{"$f":"MIN(F21,C38)*1.25","v":{"$error":"#VALUE!"}},null,null,966.53]
[null,"ST1",{"$f":"IF(C40<=F23,0,IF(C40<=F35,INT((F41*(C40-F23)/10000+F42)*(C40-F23)/10000),IF(C40<=F36,INT((F38*(C40-F35)/10000+F39)*(C40-F35)/10000+F40),IF(C40<=F37,INT(C40*F31-F43),INT(C40*F32-F44)))))","v":{"$error":"#VALUE!"}},null,null,979.18]
[null,"X",{"$f":"MIN(F21,C38)*0.75","v":{"$error":"#VALUE!"}},null,null,{"v":1400,"d":"1,400"}]
[null,"ST2",{"$f":"IF(C42<=F23,0,IF(C42<=F35,INT((F41*(C42-F23)/10000+F42)*(C42-F23)/10000),IF(C42<F36,INT((F38*(C42-F35)/10000+F39)*(C42-F35)/10000+F40),IF(C42<F37,INT(C42*F31-F43),INT(C42*F32-F44)))))","v":{"$error":"#VALUE!"}},null,null,{"v":9972.98,"d":"9,972.98"}]
[null,"DIFF",{"$f":"(C41-C43)*2","v":{"$error":"#VALUE!"}},null,null,{"v":18307.73,"d":"18,307.73"}]
[null,"MIST",{"$f":"ROUNDDOWN(MIN(C38,F21)*0.14,0)","v":{"$error":"#VALUE!"}}]
[null,"ST",{"$f":"MAX(C44,C45)","v":{"$error":"#VALUE!"}}]
[null,"ST",{"$f":"IF(C38>F22,(F22 - F21)*F31 + C46,ROUNDDOWN(MAX(C38-F21,0)*F31+C46,0))","v":{"$error":"#VALUE!"}}]
[null,"VERGL",{"$f":"IF(AND(C38>F20,C38<=F21),C46,0)","v":{"$error":"#VALUE!"}}]
[null,"ST",{"$f":"ROUNDDOWN(F20*0.14,0)","v":{"v":1747,"d":"1,747"}}]
[null,"ST",{"$f":" MIN(ROUNDDOWN(MAX(C38-F20,0)*F31+C49,0),C47)","v":{"$error":"#VALUE!"}}]
[null,"MIT REICHST",{"$f":"ROUNDDOWN(MAX(C38-F22,0)*F32+C50,0)","v":{"$error":"#VALUE!"}}]
[null,"LSTJAHR",{"$f":"ROUNDDOWN(IF(C6<5,C39,C51)*C12,0)","v":{"$error":"#VALUE!"}}]
[null,"JW",{"$f":"C52*100","v":{"$error":"#VALUE!"}}]
["MLSTJAHR","LSTLZZ",{"$f":"IF(C3=1,C53,IF(C3=2,ROUNDDOWN(C53/12,0),IF(C3=3,ROUNDDOWN((C53*7)/360,0),ROUNDDOWN(C53/360,0))))","v":{"$error":"#VALUE!"}}]
[null,"ZTABFB",{"$f":"C27+C28","v":{"v":1266,"d":"1,266"}}]
[null,"ZVE",{"$f":"C20-C36-C55","v":{"$error":"#VALUE!"}}]
[null,"ZVE, X",{"$f":"IF(C56<36,0,ROUNDDOWN(C56/C23,0))","v":{"$error":"#VALUE!"}}]
[null,"ST",{"$f":"IF(C57<=F23,0,IF(C57<=F35,INT((F41*(C57-F23)/10000+F42)*(C57-F23)/10000),IF(C57<=F36,INT((F38*(C57-F35)/10000+F39)*(C57-F35)/10000+F40),IF(C57<F37,INT(C57*F31-F43),INT(C57*F32-F44)))))*C23","v":{"$error":"#VALUE!"}}]
[null,"JBMG",{"$f":"IF(C2>0,ROUNDDOWN(C58*C12,0),C52)","v":{"$error":"#VALUE!"}}]
["MSOLZ","SOLZFREI",{"$f":"(F24)*C23","v":17543}]
[null,"SOLZJ",{"$f":"ROUNDDOWN((C59*F33)/100,2)","v":{"$error":"#VALUE!"}}]
[null,"SOLZMIN",{"$f":"((C59-C60)*F34)/100","v":{"$error":"#VALUE!"}}]
[null,"SOLZJ",{"$f":"MIN(C62,C61)","v":{"$error":"#VALUE!"}}]
[null,"JW",{"$f":"C63*100","v":{"$error":"#VALUE!"}}]
["SOLZ","ANTEIL1",{"$f":"ROUNDDOWN(IF(C3=1,C64,IF(C3=2,C64/12,IF(C3=3,(C64*7)/360,C64/360))),0)","v":{"$error":"#VALUE!"}}]
[null,"SOLZLZZ",{"$f":"IF(C59>C60,C65,0)","v":{"$error":"#VALUE!"}}]
[null,"JW",{"$f":"C59*100","v":{"$error":"#VALUE!"}}]
["BK","BK",{"$f":"ROUNDDOWN(IF(C3=1,C67,IF(C3=2,C67/12,IF(C3=3,(C67*7)/360,C67/360))),0)","v":{"$error":"#VALUE!"}}]
["FAKTOR LZZ","FLZZ",{"$f":"IF(C3=1,12,IF(C3=2,1,IF(C3=3,84/360,12/360)))","v":{"v":12,"d":"12.00000000"}}]

{"sheet":"Berechnung_Gleitzone","index":9,"n_rows":22,"n_cols":12,"rows_kept":22,"hidden":true}
[]
[]
[null,"Tats. Arbeitsentgelt",{"v":1000,"d":"1,000.00 €"},{"$nulls":6},{"$f":"+IF(ISNUMBER(C3),1,0)","v":1}]
[null,"Faktor \"F\"",{"v":0.6922,"d":"0.692200"},{"$nulls":6},{"$f":"+IF(ISNUMBER(C4),1,0)","v":1}]
[null,"Formel > 520",{"$f":"IF(C3>450,ROUND(C4*520+((2000/(2000-520))-(520/(2000-520))*C4)*(C3-520),2))","v":891.85},{"$nulls":6},{"$f":"+IF(ISNUMBER(C5),1,0)","v":1}]
[null,"Voller Satz in RV","Nein",null,{"$f":"ROUND($C$3*$C13/2,2)","v":{"v":93,"d":"93.00 €"}},{"$f":"ROUND($C$5*$C13,2)-ROUND($C$3*$C13/2,2)","v":{"v":72.88,"d":"72.88 €"}},{"$nulls":3},{"$f":"+IF(C6=\"\",0,1)","v":1}]
[]
[null,"Versicherung","Werte",null,"Summe","AG","AN"]
[null,"KV",{"v":0.146,"d":"14.60%"},null,{"$f":"IF($L$15=1,ROUND($C$5*$C9,2),\"\")","v":{"v":130.21,"d":"130.21 €"}},{"$f":"IF($L$15=1,ROUND($C$3*$C9/2,2),\"\")","v":{"v":73,"d":"73.00 €"}},{"$f":"IF($L$15=1,E9-F9,\"\")","v":{"v":57.21000000000001,"d":"57.21 €"}}]
[null,"KV - Zusatzbeitrag",{"v":0.008,"d":"0.80%"},null,{"$f":"IF($L$15=1,ROUND($C$5*$C10,2),\"\")","v":{"v":7.13,"d":"7.13 €"}},{"$f":"IF($L$15=1,ROUND($C$3*$C10/2,2),\"\")","v":{"v":4,"d":"4.00 €"}},{"$f":"IF($L$15=1,E10-F10,\"\")","v":{"v":3.13,"d":"3.13 €"}}]
[null,"PV",{"v":0.0305,"d":"3.05%"},null,{"$f":"IF($L$15=1,ROUND($C$5*$C11,2),\"\")","v":{"v":27.2,"d":"27.20 €"}},{"$f":"IF($L$15=1,ROUND($C$3*$C11/2,2),\"\")","v":{"v":15.25,"d":"15.25 €"}},{"$f":"IF($L$15=1,E11-F11,\"\")","v":{"v":11.95,"d":"11.95 €"}}]
[null,"PV - Beitragszuschlag",{"$f":"+IF(Berechnung!H19=\"Ja\",LSTBerechnung2020!F9,0)","v":{"v":0,"d":"0.000%"}},null,{"$f":"IF($L$15=1,ROUND($C$5*$C12,2),\"\")","v":{"v":0,"d":"0.00 €"}},null,{"$f":"IF($L$15=1,E12-F12,\"\")","v":{"v":0,"d":"0.00 €"}}]
[null,"RV",{"v":0.186,"d":"18.60%"},null,{"$f":"IF($L$15=1,SUM(F13:G13),\"\")","v":{"v":165.88,"d":"165.88 €"}},{"$f":"IF($L$15=1,ROUND($C$3*$C13/2,2),\"\")","v":{"v":93,"d":"93.00 €"}},{"$f":"IF($L$15=1,IF(C6=\"Ja\",E6,F6),\"\")","v":{"v":72.88,"d":"72.88 €"}}]
[null,"AV",{"v":0.026,"d":"2.60%"},null,{"$f":"IF($L$15=1,ROUND($C$5*$C14,2),\"\")","v":{"v":23.19,"d":"23.19 €"}},{"$f":"IF($L$15=1,ROUND($C$3*$C14/2,2),\"\")","v":{"v":13,"d":"13.00 €"}},{"$f":"IF($L$15=1,E14-F14,\"\")","v":{"v":10.190000000000001,"d":"10.19 €"}}]
[null,"Summe",null,null,{"$f":"IF($L$15=1,SUM(E9:E14),\"\")","v":{"v":353.60999999999996,"d":"353.61 €"}},{"$f":"IF($L$15=1,SUM(F9:F14),\"\")","v":{"v":198.25,"d":"198.25 €"}},{"$f":"IF($L$15=1,SUM(G9:G14),\"\")","v":{"v":155.36,"d":"155.36 €"}},null,null,{"$f":"+SUM(J3:J14)","v":4},4,{"$f":"+IF(J15=K15,1,0)","v":1}]
[]
[]
[]
[]
[]
[null,"Rechner ist nur gültig bis Brutto 2000."]
[null,"Liegt das Gehalt darüber, den normalen Rechner benutzen"]

{"sheet":"LSTBerechnung2021","index":10,"n_rows":69,"n_cols":13,"rows_kept":69,"hidden":true,"merged":[[0,8,0,12]]}
["LST",2021,null,null,{"$f":"\"SOZ-VS-BEITRAGSSÄTZE  \"&BearbJahr","v":"SOZ-VS-BEITRAGSSÄTZE  2021"},{"$nulls":3},"Altersentlastungsbetrag"]
["MPARA","ZKF",{"$f":"IF(Berechnung!P11>4,0,Berechnung!P14)","v":0},null,"Bezeichnung","SATZ","Berechnet",null,"Geburtsjahr","Jahr","Nummer","TAB4","TAB5"]
[null,"LZZ",{"$f":"Berechnung!P9","v":1},null,"KVSATZ",{"v":0.146,"d":"14.600%"},{"$f":"F3/2+F4","v":{"v":0.086,"d":"8.600%"}},{"$nulls":3},0,0,0]
[null,"KRV",{"$f":"Berechnung!P13","v":0},null,"KV_Zusatz",{"v":0.013,"d":"1.30%"},{"$f":"F4/2+0.07","v":{"v":0.07650000000000001,"d":"7.650%"}},null,"vor 1941","bis 2005",1,0.4,1900]
[null,"ZRE4J",{"$f":"ROUNDDOWN(IF(C3=1,Berechnung!H8*100,IF(C3=2,(Berechnung!H8*100)*12,IF(C3=3,((Berechnung!H8*100)*360)/7,(Berechnung!H8*100)*360))),2)","v":{"$error":"#VALUE!"}},null,"RV_Satz",{"v":0.186,"d":"18.60%"},{"$f":"F5/2","v":{"v":0.093,"d":"9.300%"}},null,1941,2006,2,0.384,1824]
[null,"STKL",{"$f":"+Berechnung!P11","v":1},null,"AV_Satz",{"v":0.024,"d":"2.40%"},{"$f":"F6/2","v":{"v":0.012,"d":"1.200%"}},null,1942,2007,3,0.368,1748]
[null,"JLHINZU",{"$f":"IF(C6=6,0,Berechnung!P23*100)","v":0},null,"PV_Satz",{"v":0.0305,"d":"3.05%"},{"$f":"IF(AND(Eingaben!P15=1,Eingaben!P17),F8+F9,IF(Eingaben!P15=1,F8,IF(AND(Eingaben!P10=0,Eingaben!P15=1),F7/2+F9,F7/2)))","v":{"v":0.01525,"d":"1.525%"}},"ohne / mit Kind",1943,2008,4,0.352,1672]
[null,"JLFREIB",{"$f":"Berechnung!P24*100","v":0},null,"PV_Satz Sachsen",{"v":0.02025,"d":"2.025%"},null,null,1944,2009,5,0.336,1596]
[null,"BBGRV",{"$f":"IF(Berechnung!P20=0,F15,F16)","v":{"v":85200,"d":"85,200"}},null,"PV_Satz Sachsen",{"v":0.0025,"d":"0.250%"},null,null,1945,2010,6,0.32,1520]
[null,"PKV",{"$f":"IF(Eingaben!H12>20,MAX($C$31,ROUNDDOWN(Eingaben!H12*12,2)-IF(Eingaben!P14=1,IF(Eingaben!P16=1,SUM(F11,F7,-F8),SUM(F11,F7/2))*MIN(C5/100,F17),0)),0)","v":0},null,"KV ZUSATZ Schnitt",{"v":0.013,"d":"1.300%"},null,null,1946,2011,7,0.304,1444]
[null,"PV%",{"$f":"IF(AND(Berechnung!P19=1,Berechnung!P21=1),F8+F9,IF(Berechnung!P21=1,F8,IF(AND(Berechnung!P14=0,Berechnung!P19=1),F7/2+F9,F7/2)))","v":0.01525},null,"KVSATZ AG",{"v":0.0765,"d":"7.65%"},{"$f":"F3/2+F7-G7+F10/2","v":{"v":0.09475,"d":"9.475%"}},"KV plus PV AG",1947,2012,8,0.288,1368]
[null,"FAKTOR F",{"$f":"IF(OR(OR(Berechnung!P12=0,Berechnung!P12>1),Berechnung!P11<>4),1,Berechnung!P12)","v":{"v":1,"d":"1.00"}},{"$nulls":5},1948,2013,9,0.272,1292]
["MRE4ALTE","TAB4",{"$f":"VLOOKUP(Eingaben!T26,K3:L20,2,FALSE)","v":0},null,"BMF - PAP - ANGABEN",{"$nulls":3},1949,2014,10,0.256,1216]
[null,"TAB5",{"$f":"VLOOKUP(Eingaben!T26,K3:M20,3,FALSE)*100","v":0},null,"Name","WERT","Bereich",null,1950,2015,11,0.24,1140]
[null,"ALTEANTEIL",{"$f":"C14","v":0},null,"BBGRV",{"v":85200,"d":"85,200"},"MPARA",null,1951,2016,12,0.224,1064]
[null,"ALTE",{"$f":"IF(Berechnung!P22=0,0,IF((C5*C13)>C15,C15,C5*C13))","v":0},null,"BBGRV",{"v":80400,"d":"80,400"},null,null,1952,2017,13,0.208,988]
[null,"ZRE4",{"$f":"C5-C8+C7-C16","v":{"$error":"#VALUE!"}},null,"BBGKVPV",{"v":58050,"d":"58,050"},null,null,1953,2018,14,0.192,912]
[null,"ZRE4VP",{"$f":"C5","v":{"$error":"#VALUE!"}},null,"KVSATZAG",{"v":0.0765,"d":"0.07650"},null,null,1954,2019,15,0.176,836]
[{"$nulls":4},"TBSVORV",0.84,null,null,1955,2020,16,0.16,760]
["MRE4","ZRE4",{"$f":"C17/100","v":{"$error":"#VALUE!"}},null,"W1STKL5",{"v":11237,"d":"11,237"},null,null,1956,2021,17,0.152,722]
[null,"ZRE4VP",{"$f":"C18/100","v":{"$error":"#VALUE!"}},null,"W2STKL5",{"v":28959,"d":"28,959"},null,null,1957,2022,18,0.144,684]
[{"$nulls":4},"W3STKL5",{"v":219690,"d":"219,690"},null,null,1958,2023,19,0.136,646]
["MZTABFB","KZTAB",{"$f":"IF(C6=3,2,1)","v":1},null,"GFB",{"v":9744,"d":"9,744"},null,null,1959,2024,20,0.128,608]
[null,"ANP",{"$f":"F25","v":{"v":1000,"d":"1,000"}},null,"SOLZFREI",{"v":16956,"d":"16,956.00"},null,null,1960,2025,21,0.12,570]
[null,"EFA",{"$f":"IF(C6=2,F26,0)","v":0},null,"ANP",{"v":1000,"d":"1,000"},"MZTABFB",null,1961,2026,22,0.112,532]
[null,"SAP",{"$f":"IF(C6>5,0,F27)","v":36},null,"EFA",{"v":1908,"d":"1,908"},null,null,1962,2027,23,0.104,494]
[null,"KFB",{"$f":"IF(C6<4,C2*F28,IF(C6=4,C2*F28/2,0))","v":0},null,"SAP",36,null,null,1963,2028,24,0.096,456]
[null,"ZTABFB",{"$f":"IF(C6=6,0,C24+C25+C26)","v":{"v":1036,"d":"1,036"}},null,"KFB",{"v":8388,"d":"8,388"},null,null,1964,2029,25,0.088,418]
["UPEVP","ZRE4VP",{"$f":"MIN(C9,C21)","v":{"$error":"#VALUE!"}},null,"VHB / VSP2",{"v":1900,"d":"1,900"},"UPEVP",null,1965,2030,26,0.08,380]
[null,"VSP1",{"$f":"IF(C4=1,0,ROUNDDOWN(F19*C29*G5,2))","v":{"$error":"#VALUE!"}},null,"VHB / VSP2",{"v":3000,"d":"3,000"},null,null,1966,2031,27,0.072,342]
[null,"VHB",{"$f":"IF(C23=1,F29,F30)","v":{"v":1900,"d":"1,900.00"}},null,null,0.42,"MST5-6",null,1967,2032,28,0.064,304]
[null,"VSP2",{"$f":"MIN(C31,ROUNDDOWN(0.12*C29,2))","v":{"$error":"#VALUE!"}},null,null,0.45,null,null,1968,2033,29,0.056,266]
[null,{"$f":"IF(Eingaben!H12=0,\"KVSatz=0\",(Eingaben!H12 +Eingaben!H13)/2 & \" % + PV\")","v":"KVSatz=0"},{"$f":"IF(Berechnung!P16=0,0,G4+C11)","v":{"v":0.09175000000000001,"d":"0.09175"}},null,"SOLI",{"v":5.5,"d":"5.50"},"MSOLZ",null,1969,2034,30,0.048,228]
[null,"KV",{"$f":"IF(C10>0,IF(C6=6,0,C10),ROUNDDOWN(MIN(C21,F17)*C33*100,0)/100)","v":{"$error":"#VALUE!"}},null,null,{"v":11.9,"d":"11.90"},"SOLZMIN F",null,1970,2035,31,0.04,190]
[null,"KV>VHB?",{"$f":"IF(C34>C31,C34,C32)","v":{"$error":"#VALUE!"}},null,null,{"v":14753,"d":"14,753"},"UPTAB21",null,1971,2036,32,0.032,152]
[null,"VSPN",{"$f":"ROUNDUP(C30+C35,0)","v":{"$error":"#VALUE!"}},null,null,{"v":57918,"d":"57,918"},null,null,1972,2037,33,0.024,114]
["UMVSP","ZVE",{"$f":"ROUNDDOWN(C20-C28-C36,0)","v":{"$error":"#VALUE!"}},null,null,{"v":274613,"d":"274,613"},null,null,1973,2038,34,0.016,76]
[null,"ZZX",{"$f":"MAX(0,ROUNDDOWN(C37/C23,0))","v":{"$error":"#VALUE!"}},null,null,208.85,null,null,1974,2039,35,0.008,38]
["UPTAB16","ST",{"$f":"IF(C38<=F23,0,IF(C38<=F35,INT((F41*(C38-F23)/10000+F42)*(C38-F23)/10000),IF(C38<=F36,INT((F38*(C38-F35)/10000+F39)*(C38-F35)/10000+F40),IF(C38<F37,INT(C38*F31-F43),INT(C38*F32-F44)))))*C23","v":{"$error":"#VALUE!"}},null,null,{"v":2397,"d":"2,397"},null,null,1975,2040,36,0,0]
["MST5-6","X",{"$f":"MIN(F21,C38)*1.25","v":{"$error":"#VALUE!"}},null,null,950.96]
[null,"ST1",{"$f":"IF(C40<=F23,0,IF(C40<=F35,INT((F41*(C40-F23)/10000+F42)*(C40-F23)/10000),IF(C40<=F36,INT((F38*(C40-F35)/10000+F39)*(C40-F35)/10000+F40),IF(C40<=F37,INT(C40*F31-F43),INT(C40*F32-F44)))))","v":{"$error":"#VALUE!"}},null,null,995.21]
[null,"X",{"$f":"MIN(F21,C38)*0.75","v":{"$error":"#VALUE!"}},null,null,{"v":1400,"d":"1,400"}]
[null,"ST2",{"$f":"IF(C42<=F23,0,IF(C42<=F35,INT((F41*(C42-F23)/10000+F42)*(C42-F23)/10000),IF(C42<F36,INT((F38*(C42-F35)/10000+F39)*(C42-F35)/10000+F40),IF(C42<F37,INT(C42*F31-F43),INT(C42*F32-F44)))))","v":{"$error":"#VALUE!"}},null,null,{"v":9136.63,"d":"9,136.63"}]
[null,"DIFF",{"$f":"(C41-C43)*2","v":{"$error":"#VALUE!"}},null,null,{"v":17374.99,"d":"17,374.99"}]
[null,"MIST",{"$f":"ROUNDDOWN(MIN(C38,F21)*0.14,0)","v":{"$error":"#VALUE!"}}]
[null,"ST",{"$f":"MAX(C44,C45)","v":{"$error":"#VALUE!"}}]
[null,"ST",{"$f":"IF(C38>F22,(F22 - F21)*F31 + C46,ROUNDDOWN(MAX(C38-F21,0)*F31+C46,0))","v":{"$error":"#VALUE!"}}]
[null,"VERGL",{"$f":"IF(AND(C38>F20,C38<=F21),C46,0)","v":{"$error":"#VALUE!"}}]
[null,"ST",{"$f":"ROUNDDOWN(F20*0.14,0)","v":{"v":1573,"d":"1,573"}}]
[null,"ST",{"$f":" MIN(ROUNDDOWN(MAX(C38-F20,0)*F31+C49,0),C47)","v":{"$error":"#VALUE!"}}]
[null,"MIT REICHST",{"$f":"ROUNDDOWN(MAX(C38-F22,0)*F32+C50,0)","v":{"$error":"#VALUE!"}}]
[null,"LSTJAHR",{"$f":"ROUNDDOWN(IF(C6<5,C39,C51)*C12,0)","v":{"$error":"#VALUE!"}}]
[null,"JW",{"$f":"C52*100","v":{"$error":"#VALUE!"}}]
["MLSTJAHR","LSTLZZ",{"$f":"IF(C3=1,C53,IF(C3=2,ROUNDDOWN(C53/12,0),IF(C3=3,ROUNDDOWN((C53*7)/360,0),ROUNDDOWN(C53/360,0))))","v":{"$error":"#VALUE!"}}]
[null,"ZTABFB",{"$f":"C27+C28","v":{"v":1036,"d":"1,036"}}]
[null,"ZVE",{"$f":"C20-C36-C55","v":{"$error":"#VALUE!"}}]
[null,"ZVE, X",{"$f":"IF(C56<36,0,ROUNDDOWN(C56/C23,0))","v":{"$error":"#VALUE!"}}]
[null,"ST",{"$f":"IF(C57<=F23,0,IF(C57<=F35,INT((F41*(C57-F23)/10000+F42)*(C57-F23)/10000),IF(C57<=F36,INT((F38*(C57-F35)/10000+F39)*(C57-F35)/10000+F40),IF(C57<F37,INT(C57*F31-F43),INT(C57*F32-F44)))))*C23","v":{"$error":"#VALUE!"}}]
[null,"JBMG",{"$f":"IF(C2>0,ROUNDDOWN(C58*C12,0),C52)","v":{"$error":"#VALUE!"}}]
["MSOLZ","SOLZFREI",{"$f":"(F24)*C23","v":16956}]
[null,"SOLZJ",{"$f":"ROUNDDOWN((C59*F33)/100,2)","v":{"$error":"#VALUE!"}}]
[null,"SOLZMIN",{"$f":"((C59-C60)*F34)/100","v":{"$error":"#VALUE!"}}]
[null,"SOLZJ",{"$f":"MIN(C62,C61)","v":{"$error":"#VALUE!"}}]
[null,"JW",{"$f":"C63*100","v":{"$error":"#VALUE!"}}]
["SOLZ","ANTEIL1",{"$f":"ROUNDDOWN(IF(C3=1,C64,IF(C3=2,C64/12,IF(C3=3,(C64*7)/360,C64/360))),0)","v":{"$error":"#VALUE!"}}]
[null,"SOLZLZZ",{"$f":"IF(C59>C60,C65,0)","v":{"$error":"#VALUE!"}}]
[null,"JW",{"$f":"C59*100","v":{"$error":"#VALUE!"}}]
["BK","BK",{"$f":"ROUNDDOWN(IF(C3=1,C67,IF(C3=2,C67/12,IF(C3=3,(C67*7)/360,C67/360))),0)","v":{"$error":"#VALUE!"}}]
["FAKTOR LZZ","FLZZ",{"$f":"IF(C3=1,12,IF(C3=2,1,IF(C3=3,84/360,12/360)))","v":{"v":12,"d":"12.00000000"}}]

{"sheet":"LSTBerechnung2020","index":11,"n_rows":69,"n_cols":8,"rows_kept":69,"hidden":true}
["LST",2020,null,null,{"$f":"\"SOZ-VS-BEITRAGSSÄTZE  \"&BearbJahr","v":"SOZ-VS-BEITRAGSSÄTZE  2020"}]
["MPARA","ZKF",{"$f":"IF(Berechnung!P11>4,0,Berechnung!P14)","v":0},null,"Bezeichnung","SATZ","Berechnet"]
[null,"LZZ",{"$f":"Berechnung!P9","v":1},null,"KVSATZ",{"v":0.146,"d":"14.600%"},{"$f":"F3/2+Berechnung!P17/200","v":{"$error":"#VALUE!"}},"Mit Zusatzbeitrag"]
[null,"KRV",{"$f":"Berechnung!P13","v":0},null,"KV_Zusatz",{"$f":"Berechnung!P17/100","v":{"$error":"#VALUE!"}},{"$f":"F4/2+0.07","v":{"$error":"#VALUE!"}}]
[null,"ZRE4J",{"$f":"ROUNDDOWN(IF(C3=1,Berechnung!H8*100,IF(C3=2,(Berechnung!H8*100)*12,IF(C3=3,((Berechnung!H8*100)*360)/7,(Berechnung!H8*100)*360))),2)","v":{"$error":"#VALUE!"}},null,"RV_Satz",{"v":0.186,"d":"18.60%"},{"$f":"F5/2","v":{"v":0.093,"d":"9.300%"}}]
[null,"STKL",{"$f":"+Berechnung!P11","v":1},null,"AV_Satz",{"v":0.024,"d":"2.40%"},{"$f":"F6/2","v":{"v":0.012,"d":"1.200%"}}]
[null,"JLHINZU",{"$f":"IF(C6=6,0,Berechnung!P23*100)","v":0},null,"PV_Satz",{"v":0.0305,"d":"3.05%"},{"$f":"IF(AND(Berechnung!P19=1,Berechnung!P21=1),F8+F9,IF(Berechnung!P21=1,F8,IF(AND(Berechnung!P14=0,Berechnung!P19=1),F7/2+F9,F7/2)))","v":{"v":0.01525,"d":"1.525%"}},"ohne / mit Kind"]
[null,"JLFREIB",{"$f":"Berechnung!P24*100","v":0},null,"PV_Satz Sachsen",{"v":0.02025,"d":"2.025%"}]
[null,"BBGRV",{"$f":"IF(Berechnung!P20=0,F15,F16)","v":{"v":82800,"d":"82,800"}},null,"ZUSATZ Kinderlos",{"v":0.0025,"d":"0.250%"}]
[null,"PKV",{"$f":"IF(Berechnung!H16>20,MAX($C$31,ROUNDDOWN(Berechnung!H16*12,2)-IF(Berechnung!P17=1,IF(Berechnung!P20=1,SUM(F11,F7,-F8),SUM(F11,F7/2))*MIN(C5/100,F17),0)),0)","v":{"$error":"#VALUE!"}},null,"ZUSATZ KV Durschn.",{"v":0.011,"d":"1.100%"}]
[null,"PV%",{"$f":"IF(AND(Berechnung!P19=1,Berechnung!P21=1),F8+F9,IF(Berechnung!P21=1,F8,IF(AND(Berechnung!P14=0,Berechnung!P19=1),F7/2+F9,F7/2)))","v":0.01525},null,"KVSATZ AG",{"v":0.0745,"d":"7.45%"},{"$f":"F3/2+F7-G7+F10/2","v":{"v":0.09375,"d":"9.375%"}},"KV plus PV AG"]
[null,"FAKTOR F",{"$f":"IF(OR(OR(Berechnung!P12=0,Berechnung!P12>1),Berechnung!P11<>4),1,Berechnung!P12)","v":{"v":1,"d":"1.00"}}]
["MRE4ALTE","TAB4",{"$f":"IF(Berechnung!P22=1,0.4,IF(Berechnung!P22=2,0.384,IF(Berechnung!P22=3,0.368,IF(Berechnung!P22=4,0.352,IF(Berechnung!P22=5,0.336,IF(Berechnung!P22=6,0.32,IF(Berechnung!P22=7,0.304,IF(Berechnung!P22=8,0.288,0)))))))) + IF(Berechnung!P22=9,0.272,IF(Berechnung!P22=10,0.256,IF(Berechnung!P22=11,0.24,IF(Berechnung!P22=12,0.224,IF(Berechnung!P22=13,0.208,IF(Berechnung!P22=14,0.192,IF(Berechnung!P22=15,0.176,0))))))) + IF(Berechnung!P22=16,0.16,0)","v":0},null,"BMF - PAP - ANGABEN"]
[null,"TAB5",{"$f":"IF(Berechnung!P22=1,190000,IF(Berechnung!P22=2,182400,IF(Berechnung!P22=3,174800,IF(Berechnung!P22=4,167200,IF(Berechnung!P22=5,159600,IF(Berechnung!P22=6,152000,IF(Berechnung!P22=7,144400,IF(Berechnung!P22=8,136800,0))))))))+IF(Berechnung!P22=9,129200,IF(Berechnung!P22=10,121600,IF(Berechnung!P22=11,114000,IF(Berechnung!P22=12,106400,IF(Berechnung!P22=13,98800,IF(Berechnung!P22=14,91200,IF(Berechnung!P22=15,83600,0)))))))+IF(Berechnung!P22=16,76000,0)","v":0},null,"Name","WERT","Bereich"]
[null,"ALTEANTEIL",{"$f":"C14","v":0},null,"BBGRV",{"v":82800,"d":"82,800"},"MPARA"]
[null,"ALTE",{"$f":"IF(Berechnung!P22=0,0,IF((C5*C13)>C15,C15,C5*C13))","v":0},null,"BBGRV",{"v":77400,"d":"77,400"}]
[null,"ZRE4",{"$f":"C5-C8+C7-C16","v":{"$error":"#VALUE!"}},null,"BBGKVPV",{"v":56250,"d":"56,250"}]
[null,"ZRE4VP",{"$f":"C5","v":{"$error":"#VALUE!"}},null,"KVSATZAG",{"v":0.0745,"d":"0.07450"}]
[{"$nulls":4},"TBSVORV",{"v":0.8,"d":"0.80"}]
["MRE4","ZRE4",{"$f":"C17/100","v":{"$error":"#VALUE!"}},null,"W1STKL5",{"v":10898,"d":"10,898"}]
[null,"ZRE4VP",{"$f":"C18/100","v":{"$error":"#VALUE!"}},null,"W2STKL5",{"v":28526,"d":"28,526"}]
[{"$nulls":4},"W3STKL5",{"v":216400,"d":"216,400"}]
["MZTABFB","KZTAB",{"$f":"IF(C6=3,2,1)","v":1},null,"GFB",{"v":9408,"d":"9,408"}]
[null,"ANP",{"$f":"F25","v":{"v":1000,"d":"1,000"}},null,"SOLZFREI",{"v":972,"d":"972.00"}]
[null,"EFA",{"$f":"IF(C6=2,F26,0)","v":0},null,"ANP",{"v":1000,"d":"1,000"},"MZTABFB"]
[null,"SAP",{"$f":"IF(C6>5,0,F27)","v":36},null,"EFA",{"v":1908,"d":"1,908"}]
[null,"KFB",{"$f":"IF(C6<4,C2*F28,IF(C6=4,C2*F28/2,0))","v":0},null,"SAP",36]
[null,"ZTABFB",{"$f":"IF(C6=6,0,C24+C25+C26)","v":{"v":1036,"d":"1,036"}},null,"KFB",{"v":7812,"d":"7,812"}]
["UPEVP","ZRE4VP",{"$f":"MIN(C9,C21)","v":{"$error":"#VALUE!"}},null,"VHB / VSP2",{"v":1900,"d":"1,900"},"UPEVP"]
[null,"VSP1",{"$f":"IF(C4=1,0,ROUNDDOWN(F19*C29*G5,2))","v":{"$error":"#VALUE!"}},null,"VHB / VSP2",{"v":3000,"d":"3,000"}]
[null,"VHB",{"$f":"IF(C23=1,F29,F30)","v":{"v":1900,"d":"1,900.00"}},null,null,0.42,"MST5-6"]
[null,"VSP2",{"$f":"MIN(C31,ROUNDDOWN(0.12*C29,2))","v":{"$error":"#VALUE!"}},null,null,0.45]
[null,{"$f":"IF(Berechnung!P16=0,\"KVSatz=0\",(Berechnung!P16 + Berechnung!P17)/2 & \" % + PV\")","v":{"$error":"#VALUE!"}},{"$f":"IF(Berechnung!P16=0,0,G4+C11)","v":{"$error":"#VALUE!"}},null,"SOLI",{"v":5.5,"d":"5.50"},"MSOLZ"]
[null,"KV",{"$f":"IF(C10>0,IF(C6=6,0,C10),ROUNDDOWN(MIN(C21,F17)*C33*100,0)/100)","v":{"$error":"#VALUE!"}}]
[null,"KV>VHB?",{"$f":"IF(C34>C31,C34,C32)","v":{"$error":"#VALUE!"}},null,null,{"v":14532,"d":"14,532"},"UPTAB19"]
[null,"VSPN",{"$f":"ROUNDUP(C30+C35,0)","v":{"$error":"#VALUE!"}},null,null,{"v":57051,"d":"57,051"}]
["UMVSP","ZVE",{"$f":"ROUNDDOWN(C20-C28-C36,0)","v":{"$error":"#VALUE!"}},null,null,{"v":270501,"d":"270,501"}]
[null,"ZZX",{"$f":"MAX(0,ROUNDDOWN(C37/C23,0))","v":{"$error":"#VALUE!"}},null,null,212.02]
["UPTAB16","ST",{"$f":"IF(C38<=F23,0,IF(C38<=F35,INT((F41*(C38-F23)/10000+F42)*(C38-F23)/10000),IF(C38<=F36,INT((F38*(C38-F35)/10000+F39)*(C38-F35)/10000+F40),IF(C38<F37,INT(C38*F31-F43),INT(C38*F32-F44)))))*C23","v":{"$error":"#VALUE!"}},null,null,{"v":2397,"d":"2,397"}]
["MST5-6","X",{"$f":"MIN(F21,C38)*1.25","v":{"$error":"#VALUE!"}},null,null,972.79]
[null,"ST1",{"$f":"IF(C40<=F23,0,IF(C40<=F35,INT((F41*(C40-F23)/10000+F42)*(C40-F23)/10000),IF(C40<=F36,INT((F38*(C40-F35)/10000+F39)*(C40-F35)/10000+F40),IF(C40<=F37,INT(C40*F31-F43),INT(C40*F32-F44)))))","v":{"$error":"#VALUE!"}},null,null,972.87]
[null,"X",{"$f":"MIN(F21,C38)*0.75","v":{"$error":"#VALUE!"}},null,null,{"v":1400,"d":"1,400"}]
[null,"ST2",{"$f":"IF(C42<=F23,0,IF(C42<=F35,INT((F41*(C42-F23)/10000+F42)*(C42-F23)/10000),IF(C42<F36,INT((F38*(C42-F35)/10000+F39)*(C42-F35)/10000+F40),IF(C42<F37,INT(C42*F31-F43),INT(C42*F32-F44)))))","v":{"$error":"#VALUE!"}},null,null,{"v":8963.74,"d":"8,963.74"}]
[null,"DIFF",{"$f":"(C41-C43)*2","v":{"$error":"#VALUE!"}},null,null,{"v":17078.74,"d":"17,078.74"}]
[null,"MIST",{"$f":"ROUNDDOWN(MIN(C38,F21)*0.14,0)","v":{"$error":"#VALUE!"}}]
[null,"ST",{"$f":"MAX(C44,C45)","v":{"$error":"#VALUE!"}}]
[null,"ST",{"$f":"IF(C38>F22,(F22 - F21)*F31 + C46,ROUNDDOWN(MAX(C38-F21,0)*F31+C46,0))","v":{"$error":"#VALUE!"}}]
[null,"VERGL",{"$f":"IF(AND(C38>F20,C38<=F21),C46,0)","v":{"$error":"#VALUE!"}}]
[null,"ST",{"$f":"ROUNDDOWN(F20*0.14,0)","v":{"v":1525,"d":"1,525"}}]
[null,"ST",{"$f":" MIN(ROUNDDOWN(MAX(C38-F20,0)*F31+C49,0),C47)","v":{"$error":"#VALUE!"}}]
[null,"MIT REICHST",{"$f":"ROUNDDOWN(MAX(C38-F22,0)*F32+C50,0)","v":{"$error":"#VALUE!"}}]
[null,"LSTJAHR",{"$f":"ROUNDDOWN(IF(C6<5,C39,C51)*C12,0)","v":{"$error":"#VALUE!"}}]
[null,"JW",{"$f":"C52*100","v":{"$error":"#VALUE!"}}]
["MLSTJAHR","LSTLZZ",{"$f":"IF(C3=1,C53,IF(C3=2,ROUNDDOWN(C53/12,0),IF(C3=3,ROUNDDOWN((C53*7)/360,0),ROUNDDOWN(C53/360,0))))","v":{"$error":"#VALUE!"}}]
[null,"ZTABFB",{"$f":"C27+C28","v":{"v":1036,"d":"1,036"}}]
[null,"ZVE",{"$f":"C20-C36-C55","v":{"$error":"#VALUE!"}}]
[null,"ZVE, X",{"$f":"IF(C56<36,0,ROUNDDOWN(C56/C23,0))","v":{"$error":"#VALUE!"}}]
[null,"ST",{"$f":"IF(C57<=F23,0,IF(C57<=F35,INT((F41*(C57-F23)/10000+F42)*(C57-F23)/10000),IF(C57<=F36,INT((F38*(C57-F35)/10000+F39)*(C57-F35)/10000+F40),IF(C57<F37,INT(C57*F31-F43),INT(C57*F32-F44)))))*C23","v":{"$error":"#VALUE!"}}]
[null,"JBMG",{"$f":"IF(C2>0,ROUNDDOWN(C58*C12,0),C52)","v":{"$error":"#VALUE!"}}]
["MSOLZ","SOLZFREI",{"$f":"(F24)*C23","v":972}]
[null,"SOLZJ",{"$f":"ROUNDDOWN((C59*5.5)/100,2)","v":{"$error":"#VALUE!"}}]
[null,"SOLZMIN",{"$f":"((C59-C60)*20)/100","v":{"$error":"#VALUE!"}}]
[null,"SOLZJ",{"$f":"MIN(C62,C61)","v":{"$error":"#VALUE!"}}]
[null,"JW",{"$f":"C63*100","v":{"$error":"#VALUE!"}}]
["SOLZ","ANTEIL1",{"$f":"ROUNDDOWN(IF(C3=1,C64,IF(C3=2,C64/12,IF(C3=3,(C64*7)/360,C64/360))),0)","v":{"$error":"#VALUE!"}}]
[null,"SOLZLZZ",{"$f":"IF(C59>C60,C65,0)","v":{"$error":"#VALUE!"}}]
[null,"JW",{"$f":"C59*100","v":{"$error":"#VALUE!"}}]
["BK","BK",{"$f":"ROUNDDOWN(IF(C3=1,C67,IF(C3=2,C67/12,IF(C3=3,(C67*7)/360,C67/360))),0)","v":{"$error":"#VALUE!"}}]
["FAKTOR LZZ","FLZZ",{"$f":"IF(C3=1,12,IF(C3=2,1,IF(C3=3,84/360,12/360)))","v":{"v":12,"d":"12.00000000"}}]

{"sheet":"LSTBerechnung2015","index":12,"n_rows":92,"n_cols":11,"rows_kept":92,"hidden":true}
[]
["LST 2015",{"$nulls":6},"LST 2015"]
["ALTER1",{"$f":"Berechnung!R22","v":{"v":0,"d":"0.00"}},null,"Werte der Zellen B3-B15 und B40 werden von der Eingabe-Mappe geholt",{"$nulls":3},"ALTER1",{"v":0,"d":"0.00"},null,"Werte der Zellen B3-B15 und B40 werden von der Eingabe-Mappe geholt"]
["ZKF",{"$f":"IF(Berechnung!R11>4,0,Berechnung!R14)","v":0},null,"Bei Übernahme in eigenes Programm enstprechend anpassen",{"$nulls":3},"ZKF",0,null,"Bei Übernahme in eigenes Programm enstprechend anpassen"]
["LZZ",{"$f":"Berechnung!R9","v":1},{"$nulls":5},"LZZ",2]
["KRV",{"$f":"Berechnung!R13","v":0},{"$nulls":5},"KRV",0]
["ZRE4J",{"$f":"ROUNDDOWN(IF(B5=1,Berechnung!R8*100,IF(B5=2,(Berechnung!R8*100)*12,IF(B5=3,((Berechnung!R8*100)*360)/7,(Berechnung!R8*100)*360))),2)","v":{"$error":"#VALUE!"}},{"$nulls":5},"ZRE4J",4200000]
["STKL",{"$f":"Berechnung!R11","v":1},{"$nulls":5},"STKL",1]
["JLFREIB",{"$f":"Berechnung!R24*100","v":0}," ",{"$nulls":4},"JLFREIB",0," "]
["JLHINZU",{"$f":"IF(B8=6,0,Berechnung!R23*100)","v":0},{"$nulls":5},"JLHINZU",0]
["RV-BEMES",{"$f":"IF(Berechnung!R20=0,72600,62400)","v":72600},null,"RV-Bemessungsgrenzen Ost/West",{"$nulls":3},"BBGRV",72600]
["PKV",{"$f":"IF(Berechnung!R17>20,ROUNDDOWN(IF(B5=1,Berechnung!R17*100,IF(B5=2,(Berechnung!R17*100)*12,IF(B5=3,((Berechnung!R17*100)*360)/7,(Berechnung!R17*100)*360)))/100,2),0)","v":{"$error":"#VALUE!"}},{"$nulls":5},"PKV",{"v":0,"d":"0.00"}]
["PV%",{"$f":"IF(Berechnung!R21=0,0.01175,0.01675)+IF(AND(Berechnung!R19=1,Berechnung!R14=0),0.0025,0)","v":0.01175},{"$nulls":5},"PV%",0.01175]
["FAKTOR F",{"$f":"IF(OR(OR(Berechnung!R12=0,Berechnung!R12>1),Berechnung!R11<>4),1,Berechnung!R12)","v":{"v":1,"d":"1.00"}},{"$nulls":5},"FAKTOR F",{"v":1,"d":"1.00"}]
["MRE4ALTE",{"$nulls":6},"MRE4ALTE"]
["TAB4",{"$f":"IF(B3=1,0.4,IF(B3=2,0.384,IF(B3=3,0.368,IF(B3=4,0.352,IF(B3=5,0.336,IF(B3=6,0.32,IF(B3=7,0.304,IF(B3=8,0.288,0)))))))) + IF(B3=9,0.272,IF(B3=10,0.256,IF(B3=11,0.24,0)))","v":{"v":0,"d":"0.000"}},{"$nulls":5},"TAB4",{"$f":"IF(I3=1,0.4,IF(I3=2,0.384,IF(I3=3,0.368,IF(I3=4,0.352,IF(I3=5,0.336,IF(I3=6,0.32,IF(I3=7,0.304,IF(I3=8,0.288,0)))))))) + IF(I3=9,0.272,IF(I3=10,0.256,IF(I3=11,0.24,0)))","v":{"v":0,"d":"0.000"}}]
["TAB5",{"$f":"IF(B3=1,190000,IF(B3=2,182400,IF(B3=3,174800,IF(B3=4,167200,IF(B3=5,159600,IF(B3=6,152000,IF(B3=7,144400,IF(B3=8,136800,0))))))))+IF(B3=9,129200,IF(B3=10,121600,IF(B3=11,114000,0)))","v":0},{"$nulls":5},"TAB5",{"$f":"IF(I3=1,190000,IF(I3=2,182400,IF(I3=3,174800,IF(I3=4,167200,IF(I3=5,159600,IF(I3=6,152000,IF(I3=7,144400,IF(I3=8,136800,0))))))))+IF(I3=9,129200,IF(I3=10,121600,IF(I3=11,114000,0)))","v":0}]
["ALTEANTEIL",{"$f":" B17","v":0},{"$nulls":5},"ALTEANTEIL",{"$f":" I17","v":0}]
["ALTE",{"$f":"IF(B3=0,0,IF((B7*B16)>B18,B18,B7*B16))","v":0},{"$nulls":5},"ALTE",{"$f":"IF(I3=0,0,IF((I7*I16)>I18,I18,I7*I16))","v":0}]
["ZRE4",{"$f":"B7-B9+B10-B19","v":{"$error":"#VALUE!"}},{"$nulls":3},{"$f":"Berechnung!R17","v":""},null,"ZRE4",{"$f":"I7-I9+I10-I19","v":4200000}]
["ZRE4VP",{"$f":"B7","v":{"$error":"#VALUE!"}},{"$nulls":5},"ZRE4VP",{"$f":"I7","v":4200000}]
[]
["MRE4",{"$nulls":6},"MRE4"]
["ZRE4",{"$f":"B20/100","v":{"$error":"#VALUE!"}},{"$nulls":5},"ZRE4",{"$f":"I20/100","v":{"v":42000,"d":"42000.00"}}]
["ZRE4VP",{"$f":"B21/100","v":{"$error":"#VALUE!"}},{"$nulls":5},"ZRE4VP",{"$f":"I21/100","v":{"v":42000,"d":"42000.00"}}]
[]
["MZTABFB",{"$nulls":6},"MZTABFB"]
["KZTAB",{"$f":"IF(B8=3,2,1)","v":1},{"$nulls":5},"KZTAB",{"$f":"IF(I8=3,2,1)","v":1}]
["ANP",1000,{"$nulls":5},"ANP",1000]
["EFA",{"$f":"IF(B8=2,1308,0)","v":0},{"$nulls":5},"EFA",{"$f":"IF(I8=2,1308,0)","v":0}]
["SAP",{"$f":"IF(B8>5,0,36)","v":36},{"$nulls":5},"SAP",{"$f":"IF(I8>5,0,36)","v":36}]
["KFB",{"$f":"IF(B8<4,B4*7008,IF(B8=4,B4*3504,0))","v":0},{"$nulls":5},"KFB",{"$f":"IF(I8<4,I4*7008,IF(I8=4,I4*3504,0))","v":0}]
["ZTABFB",{"$f":"IF(B8=6,0,B29+B30+B31)","v":1036},{"$nulls":5},"ZTABFB",{"$f":"IF(I8=6,0,I29+I30+I31)","v":1036}]
[]
["UPEVP",{"$nulls":6},"UPEVP"]
["ZRE4VP",{"$f":"MIN(B11,B25)","v":{"$error":"#VALUE!"}},{"$nulls":5},"ZRE4VP",{"$f":"MIN(I11,I25)","v":{"v":42000,"d":"42000.00"}}]
["VSP1",{"$f":"IF(B6=1,0,ROUNDDOWN(0.6*B36*0.0935,2))","v":{"$error":"#VALUE!"}},{"$nulls":5},"VSP1",{"$f":"IF(I6=1,0,ROUNDDOWN(0.6*I36*0.0935,2))","v":{"v":2356.2,"d":"2356.20"}}]
["VHB",{"$f":"IF(B28=1,1900,3000)","v":{"v":1900,"d":"1900.00"}},{"$nulls":5},"VHB",{"$f":"IF(I28=1,1900,3000)","v":{"v":1900,"d":"1900.00"}}]
["VSP2",{"$f":"MIN(B38,ROUNDDOWN(0.12*B36,2))","v":{"$error":"#VALUE!"}},{"$nulls":5},"VSP2",{"$f":"MIN(I38,ROUNDDOWN(0.12*I36,2))","v":{"v":1900,"d":"1900.00"}}]
[{"$f":" IF(Berechnung!R16=0,\"KVSatz=0\",7 + Berechnung!R17 & \" % + PV\")","v":{"$error":"#VALUE!"}},{"$f":"IF(Berechnung!R16=0,0,0.07+Berechnung!R17/100+B13)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(B40=0,\"\",\"Vorsorgepauschale berücksichtigt: 7,0% (=reduzierter Beitragssatz) + Zusatzbeitrag: \" & Berechnung!R17 & \"% + \" & B13 & \" (PV)\")","v":{"$error":"#VALUE!"}},{"$nulls":3},"7,9 % + PV",{"v":0.09075000000000001,"d":"0.09075"}]
["KV",{"$f":"IF(B12>0,B12,ROUNDDOWN(MIN(B25,49500)*B40*100,0)/100)","v":{"$error":"#VALUE!"}},{"$nulls":5},"KV",{"$f":"IF(I12>0,I12,ROUNDDOWN(MIN(I25,49500)*I40*100,0)/100)","v":{"v":3811.5,"d":"3811.50"}}]
["KV>VHB?",{"$f":"IF(B41>B39,B41,B39)","v":{"$error":"#VALUE!"}},{"$nulls":5},"KV>VHB?",{"$f":"IF(I41>I39,I41,I39)","v":{"v":3811.5,"d":"3811.50"}}]
["VSPN",{"$f":"ROUNDUP(B37+B42,0)","v":{"$error":"#VALUE!"}},{"$nulls":5},"VSPN",{"$f":"ROUNDUP(I37+I42,0)","v":{"v":6168,"d":"6168.00"}}]
[]
["UMVSP",{"$nulls":6},"UMVSP"]
["ZVE",{"$f":"ROUNDDOWN(B24-B33-B43,0)","v":{"$error":"#VALUE!"}},{"$nulls":5},"ZVE",{"$f":"ROUNDDOWN(I24-I33-I43,0)","v":34796}]
["ZZX",{"$f":"MAX(0,ROUNDDOWN(B46/B28,0))","v":{"$error":"#VALUE!"}},{"$nulls":5},"ZZX",{"$f":"MAX(0,ROUNDDOWN(I46/I28,0))","v":34796}]
[]
["UPTAB13",{"$nulls":6},"UPTAB14"]
["ST",{"$f":"IF(B47<=8354,0,IF(B47<=13469,INT((974.58*(B47-8354)/10000+1400)*(B47-8354)/10000),IF(B47<=52881,INT((228.74*(B47-13469)/10000+2397)*(B47-13469)/10000+971),IF(B47<=250730,INT(B47*0.42-8239),INT(B47*0.45-15761)))))*B28","v":{"$error":"#VALUE!"}},{"$nulls":5},"ST",{"$f":"IF(I47<=8354,0,IF(I47<=13469,INT((974.58*(I47-8354)/10000+1400)*(I47-8354)/10000),IF(I47<=52881,INT((228.74*(I47-13469)/10000+2397)*(I47-13469)/10000+971),IF(I47<=250730,INT(I47*0.42-8239),INT(I47*0.45-15761)))))*I28","v":7123}]
[]
["MST5-6",{"$nulls":6},"MST5-6"]
[]
["X",{"$f":"MIN(26441,B47)*1.25","v":{"$error":"#VALUE!"}},{"$nulls":5},"X",{"$f":"MIN(26441,I47)*1.25","v":{"v":33051.25,"d":"33051"}}]
["ST1",{"$f":"IF(B54<=8354,0,IF(B54<=13469,INT((974.58*(B54-8354)/10000+1400)*(B54-8354)/10000),IF(B54<=52881,INT((228.74*(B54-13469)/10000+2397)*(B54-13469)/10000+971),IF(B54<=250730,INT(B54*0.42-8239),INT(B54*0.45-15761)))))","v":{"$error":"#VALUE!"}},{"$nulls":5},"ST1",{"$f":"IF(I54<=8354,0,IF(I54<=13469,INT((974.58*(I54-8354)/10000+1400)*(I54-8354)/10000),IF(I54<=52881,INT((228.74*(I54-13469)/10000+2397)*(I54-13469)/10000+971),IF(I54<=250730,INT(I54*0.42-8239),INT(I54*0.45-15761)))))","v":6542}]
["X",{"$f":"MIN(26441,B47)*0.75","v":{"$error":"#VALUE!"}},{"$nulls":5},"X",{"$f":"MIN(26441,I47)*0.75","v":{"v":19830.75,"d":"19831"}}]
["ST2",{"$f":"IF(B56<=8354,0,IF(B56<=13469,INT((974.58*(B56-8354)/10000+1400)*(B56-8354)/10000),IF(B56<=52881,INT((228.74*(B56-13469)/10000+2397)*(B56-13469)/10000+971),IF(B56<=250730,INT(B56*0.42-8239),INT(B56*0.45-15761)))))","v":{"$error":"#VALUE!"}},{"$nulls":5},"ST2",{"$f":"IF(I56<=8354,0,IF(I56<=13469,INT((974.58*(I56-8354)/10000+1400)*(I56-8354)/10000),IF(I56<=52881,INT((228.74*(I56-13469)/10000+2397)*(I56-13469)/10000+971),IF(I56<=250730,INT(I56*0.42-8239),INT(I56*0.45-15761)))))","v":2588}]
["DIFF",{"$f":"(B55-B57)*2","v":{"$error":"#VALUE!"}},{"$nulls":5},"DIFF",{"$f":"(I55-I57)*2","v":7908}]
["MIST",{"$f":"ROUNDDOWN(MIN(B47,26441)*0.14,0)","v":{"$error":"#VALUE!"}},{"$nulls":5},"MIST",{"$f":"ROUNDDOWN(MIN(I47,26441)*0.14,0)","v":3701}]
["ST",{"$f":"MAX(B58,B59)","v":{"$error":"#VALUE!"}},{"$nulls":5},"ST",{"$f":"MAX(I58,I59)","v":7908}]
["ST",{"$f":"IF(B47>200584,(200584 - 26441)*0.42 + B60,ROUNDDOWN(MAX(B47-26441,0)*0.42+B60,0))","v":{"$error":"#VALUE!"}},{"$nulls":5},"ST",{"$f":"IF(I47>200584,(200584 - 26441)*0.42 + I60,ROUNDDOWN(MAX(I47-26441,0)*0.42+I60,0))","v":11417}]
["VERGL",{"$f":"IF(AND(B47>9763,B47<=26441),B60,0)","v":{"$error":"#VALUE!"}},{"$nulls":5},"VERGL",{"$f":"IF(AND(I47>9763,I47<=26441),I60,0)","v":0}]
["ST",1366,null,"=9763*1.25=12.203 davon ST = 683* 2 = 1366 bzw. auch 9763 * 14% = 1366",{"$nulls":3},"ST",1366,null,"=9763*1.25=12.203 davon ST = 683* 2 = 1366 bzw. auch 9763 * 14% = 1366"]
["ST",{"$f":" MIN(ROUNDDOWN(MAX(B47-9763,0)*0.42+B63,0),B61)","v":{"$error":"#VALUE!"}},{"$nulls":5},"ST",{"$f":" MIN(ROUNDDOWN(MAX(I47-9763,0)*0.42+I63,0),I61)","v":11417}]
["MIT REICHST",{"$f":"ROUNDDOWN(MAX(B47-200584,0)*0.45+B64,0)","v":{"$error":"#VALUE!"}},{"$nulls":5},"MIT REICHST",{"$f":"ROUNDDOWN(MAX(I47-200584,0)*0.45+I64,0)","v":11417}]
["LSTJAHR",{"$f":"ROUNDDOWN(IF(B8<5,B50,B65)*B14,0)","v":{"$error":"#VALUE!"}},null,"Ehegattenfaktorenverfahren",{"$nulls":3},"LSTJAHR",{"$f":"ROUNDDOWN(IF(I8<5,I50,I65)*I14,0)","v":7123},null,"Ehegattenfaktorenverfahren"]
["JW",{"$f":"B66*100","v":{"$error":"#VALUE!"}},null,"Zell B67 mit Faktor multiplizieren (für Lohnsteuer)",{"$nulls":3},"JW",{"$f":"I66*100","v":712300},null,"Zell B67 mit Faktor multiplizieren (für Lohnsteuer)"]
[{"$nulls":3},"Nur wenn StKl 4 gewählt und Hinzurechnungsbetrag=0!",{"$nulls":6},"Nur wenn StKl 4 gewählt und Hinzurechnungsbetrag=0!"]
["MLSTJAHR",{"$nulls":6},"MLSTJAHR"]
[]
["LSTLZZ",{"$f":"IF(B5=1,B67,IF(B5=2,ROUNDDOWN(B67/12,0),IF(B5=3,ROUNDDOWN((B67*7)/360,0),ROUNDDOWN(B67/360,0))))","v":{"$error":"#VALUE!"}},{"$nulls":5},"LSTLZZ",{"$f":"IF(I5=1,I67,IF(I5=2,ROUNDDOWN(I67/12,0),IF(I5=3,ROUNDDOWN((I67*7)/360,0),ROUNDDOWN(I67/360,0))))","v":59358}]
["ZTABFB",{"$f":"B32+B33","v":1036},{"$nulls":5},"ZTABFB",{"$f":"I32+I33","v":1036}]
["ZVE",{"$f":"B24-B43-B72","v":{"$error":"#VALUE!"}},{"$nulls":5},"ZVE",{"$f":"I24-I43-I72","v":34796}]
["ZVE, X",{"$f":"IF(B73<36,0,ROUNDDOWN(B73/B28,0))","v":{"$error":"#VALUE!"}},{"$nulls":5},"ZVE, X",{"$f":"IF(I73<36,0,ROUNDDOWN(I73/I28,0))","v":34796}]
["ST",{"$f":"IF(B74<=8354,0,IF(B74<=13469,INT((974.58*(B74-8354)/10000+1400)*(B74-8354)/10000),IF(B74<=52881,INT((228.74*(B74-13469)/10000+2397)*(B74-13469)/10000+971),IF(B74<=250730,INT(B74*0.42-8239),INT(B74*0.45-15761)))))*B28","v":{"$error":"#VALUE!"}},null,"Ehegattenfaktorenverfahren",{"$nulls":3},"ST",{"$f":"IF(I74<=8354,0,IF(I74<=13469,INT((974.58*(I74-8354)/10000+1400)*(I74-8354)/10000),IF(I74<=52881,INT((228.74*(I74-13469)/10000+2397)*(I74-13469)/10000+971),IF(I74<=250730,INT(I74*0.42-8239),INT(I74*0.45-15761)))))*I28","v":7123},null,"Ehegattenfaktorenverfahren"]
["JBMG",{"$f":"IF(B4>0,ROUNDDOWN(B75*B14,0),B66)","v":{"$error":"#VALUE!"}},null,"Zell B76 mit Faktor multiplizieren (für Soli und Kirchensteuer)",{"$nulls":3},"JBMG",{"$f":"IF(I4>0,ROUNDDOWN(I75*I14,0),I66)","v":7123},null,"Zell B76 mit Faktor multiplizieren (für Soli und Kirchensteuer)"]
[]
["MSOLZ",{"$nulls":6},"MSOLZ"]
["SOLZFREI",{"$f":"972*B28","v":972},{"$nulls":5},"SOLZFREI",{"$f":"972*I28","v":972}]
["SOLZJ",{"$f":"ROUNDDOWN((B76*5.5)/100,2)","v":{"$error":"#VALUE!"}},{"$nulls":5},"SOLZJ",{"$f":"ROUNDDOWN((I76*5.5)/100,2)","v":391.76}]
["SOLZMIN",{"$f":"((B76-B79)*20)/100","v":{"$error":"#VALUE!"}},{"$nulls":5},"SOLZMIN",{"$f":"((I76-I79)*20)/100","v":{"v":1230.2,"d":"1230.20"}}]
["SOLZJ",{"$f":"MIN(B81,B80)","v":{"$error":"#VALUE!"}},{"$nulls":5},"SOLZJ",{"$f":"MIN(I81,I80)","v":391.76}]
["JW",{"$f":"B82*100","v":{"$error":"#VALUE!"}},{"$nulls":5},"JW",{"$f":"I82*100","v":39176}]
[]
["SOLZ",{"$nulls":6},"SOLZ"]
["ANTEIL1",{"$f":"ROUNDDOWN(IF(B5=1,B83,IF(B5=2,B83/12,IF(B5=3,(B83*7)/360,B83/360))),0)","v":{"$error":"#VALUE!"}},{"$nulls":5},"ANTEIL1",{"$f":"ROUNDDOWN(IF(I5=1,I83,IF(I5=2,I83/12,IF(I5=3,(I83*7)/360,I83/360))),0)","v":3264}]
["SOLZLZZ",{"$f":"IF(B76>B79,B86,0)","v":{"$error":"#VALUE!"}},{"$nulls":5},"SOLZLZZ",{"$f":"IF(I76>I79,I86,0)","v":3264}]
["JW",{"$f":"B76*100","v":{"$error":"#VALUE!"}},{"$nulls":5},"JW",{"$f":"I76*100","v":712300}]
[]
["BK",{"$nulls":6},"BK"]
["ANTEIL1",{"$f":"ROUNDDOWN(IF(B5=1,B88,IF(B5=2,B88/12,IF(B5=3,(B88*7)/360,B88/360))),0)","v":{"$error":"#VALUE!"}},{"$nulls":5},"ANTEIL1",{"$f":"ROUNDDOWN(IF(I5=1,I88,IF(I5=2,I88/12,IF(I5=3,(I88*7)/360,I88/360))),0)","v":59358}]
["BK",{"$f":"B91","v":{"$error":"#VALUE!"}},{"$nulls":5},"BK",{"$f":"I91","v":59358}]

{"sheet":"LSTBerechnung2014","index":13,"n_rows":92,"n_cols":12,"rows_kept":92,"hidden":true}
[]
["LST 2014",{"$nulls":7},"LST 2014"]
["ALTER1",{"$f":"Berechnung!R22","v":{"v":0,"d":"0.00"}},null,"Werte der Zellen B3-B15 und B40 werden von der Eingabe-Mappe geholt",{"$nulls":4},"ALTER1",{"v":0,"d":"0.00"},null,{"$f":"+B3-J3","v":{"v":0,"d":"0.00"}}]
["ZKF",{"$f":"IF(Berechnung!R11>4,0,Berechnung!R14)","v":0},null,"Bei Übernahme in eigenes Programm enstprechend anpassen",{"$nulls":4},"ZKF",0,null,{"$f":"+B4-J4","v":{"v":0,"d":"0.00"}}]
["LZZ",{"$f":"Berechnung!R9","v":1},{"$nulls":6},"LZZ",2,null,{"v":-1,"d":"-1.00"}]
["KRV",{"$f":"Berechnung!R13","v":0},{"$nulls":6},"KRV",1,null,{"v":-1,"d":"-1.00"}]
["ZRE4J",{"$f":"ROUNDDOWN(IF(B5=1,Berechnung!R8*100,IF(B5=2,(Berechnung!R8*100)*12,IF(B5=3,((Berechnung!R8*100)*360)/7,(Berechnung!R8*100)*360))),2)","v":{"$error":"#VALUE!"}},{"$nulls":6},"ZRE4J",2400000,null,{"$error":"#VALUE!"}]
["STKL",{"$f":"Berechnung!R11","v":1},{"$nulls":6},"STKL",1,null,{"v":0,"d":"0.00"}]
["JLFREIB",{"$f":"Berechnung!R24*100","v":0}," ",{"$nulls":5},"JLFREIB",0,null,{"v":0,"d":"0.00"}]
["JLHINZU",{"$f":"IF(B8=6,0,Berechnung!R23*100)","v":0},{"$nulls":6},"JLHINZU",0,null,{"v":0,"d":"0.00"}]
["RV-BEMES",{"$f":"IF(Berechnung!R20=0,71400,60000)","v":71400},null,"RV-Bemessungsgrenzen Ost/West",{"$nulls":4},"RV-BEMES",71400,null,{"v":0,"d":"0.00"}]
["PKV",{"$f":"IF(Berechnung!R17>20,ROUNDDOWN(IF(B5=1,Berechnung!R17*100,IF(B5=2,(Berechnung!R17*100)*12,IF(B5=3,((Berechnung!R17*100)*360)/7,(Berechnung!R17*100)*360)))/100,2),0)","v":{"$error":"#VALUE!"}},{"$nulls":6},"PKV",{"v":0,"d":"0.00"},null,{"$error":"#VALUE!"}]
["PV%",{"$f":"IF(Berechnung!R21=0,0.01025,0.01525)+IF(AND(Berechnung!R19=1,Berechnung!R14=0),0.0025,0)","v":0.01025},{"$nulls":6},"PV%",{"v":0.012750000000000001,"d":"0.01275"},null,{"v":-2.5000000000000005E-3,"d":"-0.00"}]
["FAKTOR F",{"$f":"IF(OR(OR(Berechnung!R12=0,Berechnung!R12>1),Berechnung!R11<>4),1,Berechnung!R12)","v":{"v":1,"d":"1.00"}},{"$nulls":6},"FAKTOR F",{"v":1,"d":"1.00"},null,{"v":0,"d":"0.00"}]
["MRE4ALTE",{"$nulls":7},"MRE4ALTE",null,null,{"v":0,"d":"0.00"}]
["TAB4",{"$f":"IF(B3=1,0.4,IF(B3=2,0.384,IF(B3=3,0.368,IF(B3=4,0.352,IF(B3=5,0.336,IF(B3=6,0.32,IF(B3=7,0.304,IF(B3=8,0.288,0)))))))) + IF(B3=9,0.272,IF(B3=10,0.276,0))","v":{"v":0,"d":"0.000"}},{"$nulls":6},"TAB4",{"v":0,"d":"0.000"},null,{"v":0,"d":"0.00"}]
["TAB5",{"$f":"IF(B3=1,190000,IF(B3=2,182400,IF(B3=3,174800,IF(B3=4,167200,IF(B3=5,159600,IF(B3=6,152000,IF(B3=7,144400,IF(B3=8,136800,0))))))))+IF(B3=9,129200,IF(B3=10,121600,0))","v":0},{"$nulls":6},"TAB5",0,null,{"v":0,"d":"0.00"}]
["ALTEANTEIL",{"$f":" B17","v":0},{"$nulls":6},"ALTEANTEIL",0,null,{"v":0,"d":"0.00"}]
["ALTE",{"$f":"IF(B3=0,0,IF((B7*B16)>B18,B18,B7*B16))","v":0},{"$nulls":6},"ALTE",0,null,{"v":0,"d":"0.00"}]
["ZRE4",{"$f":"B7-B9+B10-B19","v":{"$error":"#VALUE!"}},{"$nulls":3},{"$f":"Berechnung!R17","v":""},null,null,"ZRE4",2400000,null,{"$error":"#VALUE!"}]
["ZRE4VP",{"$f":"B7","v":{"$error":"#VALUE!"}},{"$nulls":6},"ZRE4VP",2400000,null,{"$error":"#VALUE!"}]
[{"$nulls":11},{"v":0,"d":"0.00"}]
["MRE4",{"$nulls":7},"MRE4",null,null,{"v":0,"d":"0.00"}]
["ZRE4",{"$f":"B20/100","v":{"$error":"#VALUE!"}},{"$nulls":6},"ZRE4",{"v":24000,"d":"24000.00"},null,{"$error":"#VALUE!"}]
["ZRE4VP",{"$f":"B21/100","v":{"$error":"#VALUE!"}},{"$nulls":6},"ZRE4VP",{"v":24000,"d":"24000.00"},null,{"$error":"#VALUE!"}]
[{"$nulls":11},{"v":0,"d":"0.00"}]
["MZTABFB",{"$nulls":7},"MZTABFB",null,null,{"v":0,"d":"0.00"}]
["KZTAB",{"$f":"IF(B8=3,2,1)","v":1},{"$nulls":6},"KZTAB",1,null,{"v":0,"d":"0.00"}]
["ANP",1000,{"$nulls":6},"ANP",1000,null,{"v":0,"d":"0.00"}]
["EFA",{"$f":"IF(B8=2,1308,0)","v":0},{"$nulls":6},"EFA",0,null,{"v":0,"d":"0.00"}]
["SAP",{"$f":"IF(B8>5,0,36)","v":36},{"$nulls":6},"SAP",36,null,{"v":0,"d":"0.00"}]
["KFB",{"$f":"IF(B8<4,B4*7008,IF(B8=4,B4*3504,0))","v":0},{"$nulls":6},"KFB",0,null,{"v":0,"d":"0.00"}]
["ZTABFB",{"$f":"IF(B8=6,0,B29+B30+B31)","v":1036},{"$nulls":6},"ZTABFB",1036,null,{"v":0,"d":"0.00"}]
[{"$nulls":11},{"v":0,"d":"0.00"}]
["UPEVP",{"$nulls":7},"UPEVP",null,null,{"v":0,"d":"0.00"}]
["ZRE4VP",{"$f":"MIN(B11,B25)","v":{"$error":"#VALUE!"}},{"$nulls":6},"ZRE4VP",{"v":24000,"d":"24000.00"},null,{"$error":"#VALUE!"}]
["VSP1",{"$f":"IF(B6=1,0,ROUNDDOWN(0.56*B36*0.0945,2))","v":{"$error":"#VALUE!"}},{"$nulls":6},"VSP1",{"v":0,"d":"0.00"},null,{"$error":"#VALUE!"}]
["VHB",{"$f":"IF(B28=1,1900,3000)","v":{"v":1900,"d":"1900.00"}},{"$nulls":6},"VHB",{"v":1900,"d":"1900.00"},null,{"v":0,"d":"0.00"}]
["VSP2",{"$f":"MIN(B38,ROUNDDOWN(0.12*B36,2))","v":{"$error":"#VALUE!"}},{"$nulls":6},"VSP2",{"v":1900,"d":"1900.00"},null,{"$error":"#VALUE!"}]
[{"$f":" IF(Berechnung!R16=0,\"KVSatz=0\",7 + Berechnung!R17 & \" % + PV\")","v":{"$error":"#VALUE!"}},{"$f":"IF(Berechnung!R16=0,0,0.07+Berechnung!R17/100+B13)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(B40=0,\"\",\"Vorsorgepauschale berücksichtigt: 7,0% (=reduzierter Beitragssatz) + Zusatzbeitrag: \" & Berechnung!R17 & \"% + \" & B13 & \" (PV)\")","v":{"$error":"#VALUE!"}},{"$nulls":4},"7,9 % + PV",{"v":0.09175000000000001,"d":"0.09175"},null,{"$error":"#VALUE!"}]
["KV",{"$f":"IF(B12>0,B12,ROUNDDOWN(MIN(B25,48600)*B40*100,0)/100)","v":{"$error":"#VALUE!"}},{"$nulls":6},"KV",{"v":2202,"d":"2202.00"},null,{"$error":"#VALUE!"}]
["KV>VHB?",{"$f":"IF(B41>B39,B41,B39)","v":{"$error":"#VALUE!"}},{"$nulls":6},"KV>VHB?",{"v":2202,"d":"2202.00"},null,{"$error":"#VALUE!"}]
["VSPN",{"$f":"ROUNDUP(B37+B42,0)","v":{"$error":"#VALUE!"}},{"$nulls":6},"VSPN",{"v":2202,"d":"2202.00"},null,{"$error":"#VALUE!"}]
[{"$nulls":11},{"v":0,"d":"0.00"}]
["UMVSP",{"$nulls":7},"UMVSP",null,null,{"v":0,"d":"0.00"}]
["ZVE",{"$f":"ROUNDDOWN(B24-B33-B43,0)","v":{"$error":"#VALUE!"}},{"$nulls":6},"ZVE",20762,null,{"$error":"#VALUE!"}]
["ZZX",{"$f":"MAX(0,ROUNDDOWN(B46/B28,0))","v":{"$error":"#VALUE!"}},{"$nulls":6},"ZZX",20762,null,{"$error":"#VALUE!"}]
[{"$nulls":11},{"v":0,"d":"0.00"}]
["UPTAB13",{"$nulls":7},"UPTAB13",null,null,{"v":0,"d":"0.00"}]
["ST",{"$f":"IF(B47<=8354,0,IF(B47<=13469,INT((974.58*(B47-8354)/10000+1400)*(B47-8354)/10000),IF(B47<=52881,INT((228.74*(B47-13469)/10000+2397)*(B47-13469)/10000+971),IF(B47<=250730,INT(B47*0.42-8239),INT(B47*0.45-15761)))))*B28","v":{"$error":"#VALUE!"}},{"$nulls":6},"ST",2840,null,{"$error":"#VALUE!"}]
[{"$nulls":11},{"v":0,"d":"0.00"}]
["MST5-6",{"$nulls":7},"MST5-6",null,null,{"v":0,"d":"0.00"}]
[{"$nulls":11},{"v":0,"d":"0.00"}]
["X",{"$f":"MIN(26441,B47)*1.25","v":{"$error":"#VALUE!"}},{"$nulls":6},"X",{"v":25952.5,"d":"25953"},null,{"$error":"#VALUE!"}]
["ST1",{"$f":"IF(B54<=8354,0,IF(B54<=13469,INT((974.58*(B54-8354)/10000+1400)*(B54-8354)/10000),IF(B54<=52881,INT((228.74*(B54-13469)/10000+2397)*(B54-13469)/10000+971),IF(B54<=250730,INT(B54*0.42-8239),INT(B54*0.45-15761)))))","v":{"$error":"#VALUE!"}},{"$nulls":6},"ST1",4319,null,{"$error":"#VALUE!"}]
["X",{"$f":"MIN(26441,B47)*0.75","v":{"$error":"#VALUE!"}},{"$nulls":6},"X",{"v":15571.5,"d":"15572"},null,{"$error":"#VALUE!"}]
["ST2",{"$f":"IF(B56<=8354,0,IF(B56<=13469,INT((974.58*(B56-8354)/10000+1400)*(B56-8354)/10000),IF(B56<=52881,INT((228.74*(B56-13469)/10000+2397)*(B56-13469)/10000+971),IF(B56<=250730,INT(B56*0.42-8239),INT(B56*0.45-15761)))))","v":{"$error":"#VALUE!"}},{"$nulls":6},"ST2",1485,null,{"$error":"#VALUE!"}]
["DIFF",{"$f":"(B55-B57)*2","v":{"$error":"#VALUE!"}},{"$nulls":6},"DIFF",5668,null,{"$error":"#VALUE!"}]
["MIST",{"$f":"ROUNDDOWN(MIN(B47,26441)*0.14,0)","v":{"$error":"#VALUE!"}},{"$nulls":6},"MIST",2906,null,{"$error":"#VALUE!"}]
["ST",{"$f":"MAX(B58,B59)","v":{"$error":"#VALUE!"}},{"$nulls":6},"ST",5668,null,{"$error":"#VALUE!"}]
["ST",{"$f":"IF(B47>200584,(200584 - 26441)*0.42 + B60,ROUNDDOWN(MAX(B47-26441,0)*0.42+B60,0))","v":{"$error":"#VALUE!"}},{"$nulls":6},"ST",5668,null,{"$error":"#VALUE!"}]
["VERGL",{"$f":"IF(AND(B47>9763,B47<=26441),B60,0)","v":{"$error":"#VALUE!"}},{"$nulls":6},"VERGL",5668,null,{"$error":"#VALUE!"}]
["ST",1366,null,"=9763*1.25=12.203 davon ST = 683* 2 = 1366 bzw. auch 9763 * 14% = 1366",{"$nulls":4},"ST",1366,null,{"v":0,"d":"0.00"}]
["ST",{"$f":" MIN(ROUNDDOWN(MAX(B47-9763,0)*0.42+B63,0),B61)","v":{"$error":"#VALUE!"}},{"$nulls":6},"ST",5668,null,{"$error":"#VALUE!"}]
["MIT REICHST",{"$f":"ROUNDDOWN(MAX(B47-200584,0)*0.45+B64,0)","v":{"$error":"#VALUE!"}},{"$nulls":6},"MIT REICHST",5668,null,{"$error":"#VALUE!"}]
["LSTJAHR",{"$f":"ROUNDDOWN(IF(B8<5,B50,B65)*B14,0)","v":{"$error":"#VALUE!"}},null,"Ehegattenfaktorenverfahren",{"$nulls":4},"LSTJAHR",2840,null,{"$error":"#VALUE!"}]
["JW",{"$f":"B66*100","v":{"$error":"#VALUE!"}},null,"Zell B67 mit Faktor multiplizieren (für Lohnsteuer)",{"$nulls":4},"JW",284000,null,{"$error":"#VALUE!"}]
[{"$nulls":3},"Nur wenn StKl 4 gewählt und Hinzurechnungsbetrag=0!",{"$nulls":7},{"$f":"+B68-J68","v":{"v":0,"d":"0.00"}}]
["MLSTJAHR",{"$nulls":7},"MLSTJAHR",null,null,{"v":0,"d":"0.00"}]
[{"$nulls":11},{"v":0,"d":"0.00"}]
["LSTLZZ",{"$f":"IF(B5=1,B67,IF(B5=2,ROUNDDOWN(B67/12,0),IF(B5=3,ROUNDDOWN((B67*7)/360,0),ROUNDDOWN(B67/360,0))))","v":{"$error":"#VALUE!"}},{"$nulls":6},"LSTLZZ",23666,null,{"$error":"#VALUE!"}]
["ZTABFB",{"$f":"B32+B33","v":1036},{"$nulls":6},"ZTABFB",1036,null,{"v":0,"d":"0.00"}]
["ZVE",{"$f":"B24-B43-B72","v":{"$error":"#VALUE!"}},{"$nulls":6},"ZVE",20762,null,{"$error":"#VALUE!"}]
["ZVE, X",{"$f":"IF(B73<36,0,ROUNDDOWN(B73/B28,0))","v":{"$error":"#VALUE!"}},{"$nulls":6},"ZVE, X",20762,null,{"$error":"#VALUE!"}]
["ST",{"$f":"IF(B74<=8354,0,IF(B74<=13469,INT((974.58*(B74-8354)/10000+1400)*(B74-8354)/10000),IF(B74<=52881,INT((228.74*(B74-13469)/10000+2397)*(B74-13469)/10000+971),IF(B74<=250730,INT(B74*0.42-8239),INT(B74*0.45-15761)))))","v":{"$error":"#VALUE!"}},null,"Ehegattenfaktorenverfahren",{"$nulls":4},"ST",2840,null,{"$error":"#VALUE!"}]
["JBMG",{"$f":"IF(B4>0,ROUNDDOWN(B75*B14,0),B66)","v":{"$error":"#VALUE!"}},null,"Zell B76 mit Faktor multiplizieren (für Soli und Kirchensteuer)",{"$nulls":4},"JBMG",2840,null,{"$error":"#VALUE!"}]
[{"$nulls":11},{"v":0,"d":"0.00"}]
["MSOLZ",{"$nulls":7},"MSOLZ",null,null,{"v":0,"d":"0.00"}]
["SOLZFREI",{"$f":"972*B28","v":972},{"$nulls":6},"SOLZFREI",972,null,{"v":0,"d":"0.00"}]
["SOLZJ",{"$f":"ROUNDDOWN((B76*5.5)/100,2)","v":{"$error":"#VALUE!"}},{"$nulls":6},"SOLZJ",{"v":156.2,"d":"156.20"},null,{"$error":"#VALUE!"}]
["SOLZMIN",{"$f":"((B76-B79)*20)/100","v":{"$error":"#VALUE!"}},{"$nulls":6},"SOLZMIN",{"v":373.6,"d":"373.60"},null,{"$error":"#VALUE!"}]
["SOLZJ",{"$f":"MIN(B81,B80)","v":{"$error":"#VALUE!"}},{"$nulls":6},"SOLZJ",{"v":156.2,"d":"156.20"},null,{"$error":"#VALUE!"}]
["JW",{"$f":"B82*100","v":{"$error":"#VALUE!"}},{"$nulls":6},"JW",15620,null,{"$error":"#VALUE!"}]
[{"$nulls":11},{"v":0,"d":"0.00"}]
["SOLZ",{"$nulls":7},"SOLZ",null,null,{"v":0,"d":"0.00"}]
["ANTEIL1",{"$f":"ROUNDDOWN(IF(B5=1,B83,IF(B5=2,B83/12,IF(B5=3,(B83*7)/360,B83/360))),0)","v":{"$error":"#VALUE!"}},{"$nulls":6},"ANTEIL1",1301,null,{"$error":"#VALUE!"}]
["SOLZLZZ",{"$f":"IF(B76>B79,B86,0)","v":{"$error":"#VALUE!"}},{"$nulls":6},"SOLZLZZ",1301,null,{"$error":"#VALUE!"}]
["JW",{"$f":"B76*100","v":{"$error":"#VALUE!"}},{"$nulls":6},"JW",284000,null,{"$error":"#VALUE!"}]
[{"$nulls":11},{"v":0,"d":"0.00"}]
["BK",{"$nulls":7},"BK",null,null,{"v":0,"d":"0.00"}]
["ANTEIL1",{"$f":"ROUNDDOWN(IF(B5=1,B88,IF(B5=2,B88/12,IF(B5=3,(B88*7)/360,B88/360))),0)","v":{"$error":"#VALUE!"}},{"$nulls":6},"ANTEIL1",23666,null,{"$error":"#VALUE!"}]
["BK",{"$f":"B91","v":{"$error":"#VALUE!"}},{"$nulls":6},"BK",23666,null,{"$error":"#VALUE!"}]

{"sheet":"__Goal_Metadata","index":14,"n_rows":2,"n_cols":2,"rows_kept":2,"hidden":true}
["_KAW999934","J"]
["_KAW999929","bb6f94e9-3d72-4b2e-87b9-0e4507023c5a"]