{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Angaben","Dialog","Tabelle","Steuerung","Listen"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":116,"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":"Angaben","index":0,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[[25,6,25,8],[27,6,27,8],[29,6,29,8],[2,1,2,9],[8,1,8,5],[20,6,20,8],[19,6,19,8],[21,6,21,8]]}
[null,"Gleitzonenrechner"]
[]
[null,{"$f":"IFERROR(CONCATENATE(\" Beitragsberechnung vers.pflichtiger Beschäftigter innerhalb der Gleitzone (\",UGrenz+0.01,\" € bis \",TEXT(OGrenz,\"000,00\"),\" €)\"),\"Beitragsberechnung vers.pfl. Beschäftigter innerhalb der Gleitzone \")","v":" Beitragsberechnung vers.pflichtiger Beschäftigter innerhalb der Gleitzone (450,01 € bis 850,00 €)"}]
[null,{"$f":"\"Beitragsjahr: 1. Halbjahr \" & Gew_Jahr","v":"Beitragsjahr: 1. Halbjahr 2019"}]
[null,"Zutreffende Sonderregelungen:",null,null,null,null,"Individuelle Angaben:"]
[]
[null,null,null,null,null,null,"  Angabe des individuellen KV-Zusatzbeitragssatzes:",null,null,{"$f":"BS_KV_Zu/100","v":8.9999999999999993E-3}]
[]
[null,null,null,null,null,null,"  Gültiger KV-Beitragssatz:",null,null,{"$f":"IFERROR(BS_KV_allg/100,\"\")","v":0.14599999999999999}]
[]
[]
[null,null,null,null,null,null,"  Beitragszuschlag wegen Kinderlosigkeit in der PV:"]
[]
[null,null,null,null,null,null,"  Allgemeine Beitragssätze der Sozialversicherung:"]
[]
[null,null,null,null,null,null,"  Durchschnittlicher Gesamtsozialversicherungsbeitragssatz",null,null,{"$f":"IFERROR(Steuerung!C7/100,\"\")","v":0.39649999999999996}]
[]
[null,null,null,null,null,null,"  allgemeiner Beitragssatz Krankenversicherung",null,null,{"$f":"IFERROR(Steuerung!C8/100,\"\")","v":0.14599999999999999}]
[null,null,null,null,null,null,"  durchschnittl. Zusatzbeitragssatz Krankenversicherung",null,null,{"$f":"IFERROR(Steuerung!C12/100,\"\")","v":9.0000000000000011E-3}]
[null,null,null,null,null,null,"  Beitragssatz Rentenversicherung",null,null,{"$f":"IFERROR(nRV_Satz_Jahr/100,\"\")","v":0.18600000000000003}]
[null,null,null,null,null,null,"  Beitragssatz Arbeitslosenversicherung",null,null,{"$f":"IFERROR(nAV_Satz_Jahr/100,\"\")","v":2.5000000000000001E-2}]
[null,null,null,null,null,null,"  Beitragssatz Pflegeversicherung",null,null,{"$f":"IFERROR(nPV_Satz_Jahr/100,\"\")","v":3.0499999999999999E-2}]
[]
[null,null,null,null,null,null,"  Zutreffende Arbeitgeber-Umlagen"]
[]
[null,null,null,null,null,null,"           U1 - Krankheitsfall",null,null,{"$f":"S_U1_Satz","v":0}]
[]
[null,null,null,null,null,null,"           U2 - Mutterschaft",null,null,{"$f":"S_U2_Satz","v":0}]
[]
[null,null,null,null,null,null,"           Insolvenzumlage",null,null,{"$f":"IFERROR(S_U3_Satz,\"\")","v":0}]

{"sheet":"Dialog","index":1,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":false,"merged":[[16,1,16,2],[16,3,16,4],[16,5,16,6],[0,1,0,8],[3,5,3,8],[12,6,13,8],[6,6,7,8],[8,6,9,8]]}
[null,{"$f":"CONCATENATE(\" Beitragsberechnung vers.pfl. Beschäftigter innerhalb der Gleitzone (\",UGrenz+0.01,\" € bis \",TEXT(OGrenz,\"000,00\"),\" €)\")","v":" Beitragsberechnung vers.pfl. Beschäftigter innerhalb der Gleitzone (450,01 € bis 850,00 €)"}]
[null,{"$f":"\"Beitragsjahr: 1. Halbjahr \"&Zeitraum","v":"Beitragsjahr: 1. Halbjahr 2019"}]
[]
[null,"Berechnungsgrundlagen:",null,null,null,"Aktive Sonderregelungen:",null,null,null,null,"ohne Sonderfall"]
[null,null,null,"Monatliches Arbeitsentgelt:",null,"KV:","allgemeiner Beitragssatz"]
[]
[null,null,null,"Gleitzonenentgelt:",null,"RV:"]
[]
[null,null,null,null,null,"AV:"]
[]
[null,null,null,null,null,"PV:"," Zuschlag wegen Kinderlosigkeit"]
[]
[null,null,null,null,null,"Sonderfälle:"]
[]
[]
[]
[null,"Voller SV-Beitrag:",null,"Arbeitgeberanteile:",null,"Arbeitnehmeranteile:",null,"Beitragssatz:"]
[null,"KV:",null,"KV:",null,"KV:",null,"KV:"]
[]
[null,"RV:",null,"RV:",null,"RV:",null,"RV:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L21*3","v":0}]
[null,"AV:",null,"AV:",null,"AV:",null,"AV:"]
[]
[null,"PV:",null,"PV:",null,"PV:",null,"PV:"]
[]
[null,{"$f":"IF(AND(S_KV_PV_frei<>TRUE,BS_KV_Zu<>0),\"Zusatz KV:\",\"\")","v":"Zusatz KV:"},null,{"$f":"B26","v":"Zusatz KV:"},null,{"$f":"B26","v":"Zusatz KV:"},null,{"$f":"B26","v":"Zusatz KV:"}]
[]
[null,{"$f":"IF(S_PV_Zu=1,\"Zuschl. PV:\",\"\")","v":"Zuschl. PV:"},null,{"$f":"B28","v":"Zuschl. PV:"},null,{"$f":"B28","v":"Zuschl. PV:"},null,{"$f":"B28","v":"Zuschl. PV:"}]
[]
[null,"SV-Gesamt:",{"$f":"SUM(C18:C28)","v":0},"SV-Gesamt:",{"$f":"SUM(E18:E28)","v":0},"SV-Gesamt:",{"$f":"SUM(G18:G28)","v":0}]
[]
[null,{"$f":"IF(S_U1=TRUE,\"U1:\",\"\")","v":""},null,{"$f":"B32","v":""},null,null,null,{"$f":"B32","v":""}]
[null,{"$f":"IF(S_U2=TRUE,\"U2:\",\"\")","v":""},null,{"$f":"B33","v":""},null,null,null,{"$f":"B33","v":""}]
[null,{"$f":"IF(S_U3=TRUE,\"Insolvenzuml.:\",\"\")","v":""},null,{"$f":"B34","v":""},null,null,null,{"$f":"B34","v":""}]
[]
[null,{"$f":"IF(OR(S_U1=TRUE,S_U2=TRUE,S_U3=TRUE),\"Uml.-Gesamt:\",\"\")","v":""},{"$f":"IF(OR(S_U1=TRUE,S_U2=TRUE,S_U3=TRUE),SUM(C32:C34),\"\")","v":""},{"$f":"B36","v":""},{"$f":"IF(OR(S_U1=TRUE,S_U2=TRUE,S_U3=TRUE),SUM(E32:E35),\"\")","v":""}]
[]
[null,{"$f":"IF(OR(S_U1=TRUE,S_U2=TRUE,S_U3=TRUE),\"Insgesamt:\",\"\")","v":""},{"$f":"IF(OR(S_U1=TRUE,S_U2=TRUE,S_U3=TRUE),SUM(C30:C34),\"\")","v":""},{"$f":"B38","v":""},{"$f":"IF(OR(S_U1=TRUE,S_U2=TRUE,S_U3=TRUE),SUM(E30:E34),\"\")","v":""},{"$f":"B38","v":""},{"$f":"IF(OR(S_U1=TRUE,S_U2=TRUE,S_U3=TRUE),SUM(G30:G34),\"\")","v":""}]

{"sheet":"Tabelle","index":2,"n_rows":47,"n_cols":7,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[null,null,"Beitragspflichtige Einnahmen und Beitragsberechnung versicherungspfl. Beschäftigter"]
[null,null,{"$f":"CONCATENATE(\"innerhalb der Gleitzone von \",UGrenz+0.01,\" € bis \",TEXT(OGrenz,\"000,00\"),\" €\")","v":"innerhalb der Gleitzone von 450,01 € bis 850,00 €"}]
[null,null,"(§ 20 Abs.2 SGB IV, § 344 Abs.4 SGB III, § 226 Abs.4 SGB V, § 163 Abs.10 SGB VI, § 58 Abs.5 SGB XI)"]
[]
[null,null,{"$f":"\"Beitragsjahr: 1. Halbjahr \" & Gew_Jahr","v":"Beitragsjahr: 1. Halbjahr 2019"}]
[null,null,"monatliches Arbeitsentgelt",{"$f":"\"Beitragsbemes-sungsgrundlage bei: \"&Steuerung!C7&\" %\"","v":"Beitragsbemes-sungsgrundlage bei: 39,65 %"},null,"monatliches Arbeitsentgelt",{"$f":"D6","v":"Beitragsbemes-sungsgrundlage bei: 39,65 %"}]
[null,null,{"$f":"UGrenz+0.01","v":450.01},{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (C7 - UGrenz), 2)","v":340.48},null,{"$f":"C47+5","v":655},{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F7 - UGrenz), 2)","v":601.6}]
[null,null,{"$f":"UGrenz+5","v":455},{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (C8 - UGrenz), 2)","v":346.84},null,{"$f":"F7+5","v":660},{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F8 - UGrenz), 2)","v":607.97}]
[null,null,{"$f":"C8+5","v":460},{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (C9 - UGrenz), 2)","v":353.21},null,{"$f":"F8+5","v":665},{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F9 - UGrenz), 2)","v":614.34}]
[null,null,465,359.58,null,670,620.71]
[null,null,470,365.95,null,675,627.08000000000004]
[null,null,475,372.32,null,680,633.45000000000005]
[null,null,480,378.68,null,685,639.82000000000005]
[null,null,485,385.05,null,690,646.19000000000005]
[null,null,490,391.42,null,695,652.55999999999995]
[null,null,495,397.79,null,700,658.93]
[null,null,500,404.16,null,705,665.3]
[null,null,505,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (C18 - UGrenz), 2)","v":410.53},null,710,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F18 - UGrenz), 2)","v":671.66}]
[null,null,510,416.9,null,715,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F19 - UGrenz), 2)","v":678.03}]
[null,null,515,423.27,null,720,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F20 - UGrenz), 2)","v":684.4}]
[null,null,520,429.64,null,725,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F21 - UGrenz), 2)","v":690.77}]
[null,null,525,436.01,null,730,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F22 - UGrenz), 2)","v":697.14}]
[null,null,{"$f":"C22+5","v":530},442.38,null,735,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F23 - UGrenz), 2)","v":703.51}]
[null,null,535,448.75,null,740,709.88]
[null,null,540,455.11,null,745,716.25]
[null,null,545,461.48,null,750,722.62]
[null,null,550,467.85,null,755,728.99]
[null,null,555,474.22,null,760,735.36]
[null,null,560,480.59,null,{"$f":"F28+5","v":765},{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F29 - UGrenz), 2)","v":741.72}]
[null,null,{"$f":"C29+5","v":565},486.96,null,{"$f":"F29+5","v":770},{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F30 - UGrenz), 2)","v":748.09}]
[null,null,570,493.33,null,{"$f":"F30+5","v":775},{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F31 - UGrenz), 2)","v":754.46}]
[null,null,575,499.7,null,780,760.83]
[null,null,580,506.07,null,785,767.2]
[null,null,585,512.44000000000005,null,790,773.57]
[null,null,590,518.80999999999995,null,795,779.94]
[null,null,595,525.16999999999996,null,800,786.31]
[null,null,600,531.54,null,805,792.68]
[null,null,605,537.91,null,810,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F38 - UGrenz), 2)","v":799.05}]
[null,null,610,544.28,null,815,805.42]
[null,null,615,550.65,null,820,811.79]
[null,null,620,557.02,null,825,818.15]
[null,null,625,563.39,null,830,824.52]
[null,null,630,569.76,null,835,830.89]
[null,null,635,576.13,null,840,837.26]
[null,null,640,582.5,null,845,843.63]
[null,null,{"$f":"C45+5","v":645},588.87,null,850,850]
[null,null,{"$f":"C46+5","v":650},{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (C47 - UGrenz), 2)","v":595.24}]

{"sheet":"Steuerung","index":3,"n_rows":90,"n_cols":11,"rows_kept":90,"cut":false,"hidden":true,"merged":[]}
["Bezeichnung","Rückgabe","Wert","TabellenSpalte"]
["Gewähltes Jahr",{"$f":"LC_Liste_Jahr","v":1},{"$f":"VALUE(RIGHT(VLOOKUP(B2,Jahr,2,0),4))","v":2019}]
["Beitragszeitraum",1,{"$f":"IFERROR(VLOOKUP(B3,Jahr,D3,0),\"Fehler\")","v":2019},{"$f":"SUMIF(Listen!$F$19:$U$20,A3,Listen!$F$20:$U$20)","v":2}]
["Untergrenze",{"$f":"B2","v":1},{"$f":"VLOOKUP($B4,Jahr,$D4,0)","v":450},{"$f":"SUMIF(Listen!$F$19:$U$20,A4,Listen!$F$20:$U$20)","v":11}]
["Obergrenze",{"$f":"B2","v":1},{"$f":"VLOOKUP($B5,Jahr,$D5,0)","v":850},{"$f":"SUMIF(Listen!$F$19:$U$20,A5,Listen!$F$20:$U$20)","v":12}]
["Faktor",null,{"$f":"ROUND(30/$C$7,4)","v":0.75660000000000005}]
["Summe SV",{"$f":"B2","v":1},{"$f":"VLOOKUP(B7,Jahr,D7,0)","v":39.65},{"$f":"SUMIF(Listen!$F$19:$U$20,A7,Listen!$F$20:$U$20)","v":3}]
["KV allg",{"$f":"B2","v":1},14.6,{"$f":"SUMIF(Listen!$F$19:$U$20,A8,Listen!$F$20:$U$20)","v":9}]
["RV",{"$f":"B2","v":1},18.600000000000001,{"$f":"SUMIF(Listen!$F$19:$U$20,A9,Listen!$F$20:$U$20)","v":5}]
["AV",{"$f":"B2","v":1},2.5,{"$f":"SUMIF(Listen!$F$19:$U$20,A10,Listen!$F$20:$U$20)","v":6}]
["PV",{"$f":"B2","v":1},3.05,{"$f":"SUMIF(Listen!$F$19:$U$20,A11,Listen!$F$20:$U$20)","v":7}]
["Zusatz KV",{"$f":"B2","v":1},0.9,{"$f":"SUMIF(Listen!$F$19:$U$20,A12,Listen!$F$20:$U$20)","v":4}]
["KV erm",{"$f":"B2","v":1},{"$f":"VLOOKUP(B13,Jahr,D13,0)","v":14},{"$f":"SUMIF(Listen!$F$19:$U$20,A13,Listen!$F$20:$U$20)","v":10}]
["KV allg",{"$f":"B2","v":1},{"$f":"VLOOKUP(B14,Jahr,D14,0)","v":14.6},{"$f":"SUMIF(Listen!$F$19:$U$20,A14,Listen!$F$20:$U$20)","v":9}]
["KV Beitragssatz",{"$f":"IF(S_BS_allg,1,2)","v":1},{"$f":"IF(S_KV_allg_erm.BS=2,C13,C14)","v":14.6},null,null,"S_BS_allg",true]
["KV individueller ZusatzBS",13,{"$f":"VLOOKUP(B16,KV,2,0)*100","v":0.89999999999999991},null,null,"S_BS_ermäßigt",false]
["RV Knappsch. ",{"$f":"B2","v":1},{"$f":"VLOOKUP(B17,Jahr,D17,0)","v":24.7},{"$f":"SUMIF(Listen!$F$19:$U$20,A17,Listen!$F$20:$U$20)","v":8}]
["AG-Ant. Sachsen",{"$f":"B2","v":1},{"$f":"VLOOKUP(B18,Jahr,D18,0)","v":1.025E-2},{"$f":"SUMIF(Listen!$F$19:$U$20,A18,Listen!$F$20:$U$20)","v":13}]
["AN-Ant. Sachsen",{"$f":"B2","v":1},{"$f":"VLOOKUP(B19,Jahr,D19,0)","v":0},{"$f":"SUMIF(Listen!$F$19:$U$20,A19,Listen!$F$20:$U$20)","v":14}]
["Zuschlag wg Kinderlosigkeit",1,{"$f":"IF(S_PV_Zu=1,VLOOKUP(B2,Jahr,D20,0),0)","v":0.25},{"$f":"SUMIF(Listen!$F$19:$U$20,A20,Listen!$F$20:$U$20)","v":16}]
["U1 - Krankheitsfall",false,0]
["U2 - Mutterschaft",false,0]
["Insolvenzgeld",false,{"$f":"IF(S_U3=TRUE,VLOOKUP(B5,Jahr,D23,0),0)","v":0},{"$f":"SUMIF(Listen!$F$19:$U$20,A23,Listen!$F$20:$U$20)","v":15}]
[]
["Frei KV/PV",false]
["PV Sachsen",false]
["Frei RV"]
["RV nur AG",false]
["RV Knappsch. "]
["nur  AV",0]
["Frei AV",false]
[]
["Sonderfall 1",false]
["Sonderfall 2",false]
["Sonderfall2 Option",{"$f":"IF(S_Sonder_2_Opt1,1,2)","v":2},null,null,null,"S_Sonder_2_Opt1",null,null,{"$f":"IF(S_Sonder_2_Opt1,1,2)","v":2}]
["Mehrfachbesch.",false,null,null,null,"S_Sonder_2_Opt2"]
["Sonderfall 4",false]
["Azubi"]
[]
["Auswahl Sonderfall",{"$f":"INDIRECT(\"Steuerung!A\"&58+nAuswahl_Sonder)","v":0},{"$f":"SUM(C61:C69)","v":2}]
["Auswahl KV",null,{"$f":"SUM(C72:C74)","v":12}]
["Auswahl PV",null,{"$f":"SUM(C77:C79)","v":20}]
["Auswahl RV",null,{"$f":"SUM(C82:C86)","v":30}]
["Auswahl AV",null,{"$f":"SUM(C89:C91)","v":40}]
["PV Kinderzuschlag",{"$f":"IF(AND(S_KV_PV_frei<>TRUE,S_PV_Zu=1),TRUE)","v":true},{"$f":"IF(B45,50,\"\")","v":50}]
[]
[]
["Opt_Sond2_Tage"]
["Opt_Sond2_Stunden"]
["Opt_Sond2_Wostu"]
["Opt_Sond2_Entgelt"]
["AE"]
["Sond3_Entgelt"]
["Sond3_Sonstentgelt"]
["Sond3_Quotient",0.27272727272727271]
[]
["S2_O1_O2",{"$f":"IF(S_Sonder_2_Opt=1,\" Tagen\",\" geleist. h \")","v":" geleist. h "}]
["Anzahl_S2_O1_O2",{"$f":"IF(S_Sonder_2_Opt=1,VALUE(B48),VALUE(B49))","v":0}]
["S2_O1_O2_Zusatz",{"$f":"IF(S_Sonder_2_Opt=2,\"/ \"&VALUE(B50)&\" h wtl. Regel-AZ\",\"\")","v":"/ 0 h wtl. Regel-AZ"},null,null,null,null,null,"S_Sonder_1","S_Sonder_2","S_Mehrfach","S_Sonder_4"]
[null,null,null,null,null,null,null,{"$f":"S_Sonder_1","v":false},{"$f":"S_Sonder_2","v":false},{"$f":"S_Mehrfach","v":false},{"$f":"S_Sonder_4","v":false}]
["AE ohne Sonder",{"$f":"IF(AND(S_Sonder_1<>TRUE,S_Sonder_2<>TRUE,S_Mehrfach<>TRUE,S_Sonder_4<>TRUE),TRUE)","v":true},{"$f":"IF(B61,1,\"\")","v":1},null,1,"OHNE",null,"F","F","F","F"]
["Mehrfachbesch.",{"$f":"IF(AND(S_Sonder_1<>TRUE,S_Sonder_2<>TRUE,S_Mehrfach=TRUE,S_Sonder_4<>TRUE),TRUE)","v":false},{"$f":"IF(B62,2,\"\")","v":""},null,2,"Mehrfach",null,"F","F","W","F"]
["Teilmonate",{"$f":"IF(AND(S_Sonder_1<>TRUE,S_Sonder_2=TRUE,S_Mehrfach<>TRUE,S_Sonder_4<>TRUE),TRUE)","v":false},{"$f":"IF(B63,3,\"\")","v":""},null,3,"Teil monat",null,"F","W","F","F"]
["mit Einmalzahlung",{"$f":"IF(AND(S_Sonder_1<>TRUE,S_Sonder_2<>TRUE,S_Mehrfach<>TRUE,S_Sonder_4=TRUE),TRUE)","v":false},{"$f":"IF(B64,4,\"\")","v":""},null,4,"Einmal zahlung",null,"F","F","F","W"]
["Teilmonat bei Mehrfach",{"$f":"IF(AND(S_Sonder_1<>TRUE,S_Sonder_2=TRUE,S_Mehrfach=TRUE,S_Sonder_4<>TRUE),TRUE)","v":false},{"$f":"IF(B65,5,\"\")","v":""},null,5,"Teilmonat bei Mehrfach beschäftigung",null,"F","W","W","F"]
["Einmalzahlung bei Teilmonat",{"$f":"IF(AND(S_Sonder_1<>TRUE,S_Sonder_2=TRUE,S_Mehrfach<>TRUE,S_Sonder_4=TRUE),TRUE)","v":false},{"$f":"IF(B66,6,\"\")","v":""},null,6,"Einmalzahlung bei Teilmonat",null,"F","W","F","W"]
["AE unter UGrenze",{"$f":"IF(AND(S_Sonder_1=TRUE,S_Sonder_2<>TRUE,S_Mehrfach<>TRUE,S_Sonder_4<>TRUE),TRUE)","v":false},{"$f":"IF(B67,7,\"\")","v":""},null,7,"unter UnterGrenze",null,"W","F","F","F"]
["AE unter UGrenze und Teilmonat",{"$f":"IF(AND(S_Sonder_1=TRUE,S_Sonder_2=TRUE,S_Mehrfach<>TRUE,S_Sonder_4<>TRUE),TRUE)","v":false},{"$f":"IF(B68,8,\"\")","v":""},null,8,"unter UnterGrenze und Teilmonat",null,"W","W","F","F"]
[null,null,{"$f":"SUM(C61:C68)","v":1},null,0,"nicht zulässig"]
[]
[]
["KV ohne Sonder",{"$f":"IF(S_KV_PV_frei<>TRUE,TRUE)","v":true},{"$f":"IF(B72,10,\"\")","v":10}]
["KV frei",{"$f":"IF(S_KV_PV_frei=TRUE,TRUE)","v":false},{"$f":"IF(B73,11,\"\")","v":""}]
["KV allg / ermäßigt",{"$f":"IF((S_KV_PV_frei<>TRUE),TRUE)","v":true},{"$f":"IF(B74,S_KV_allg_erm.BS+1,\"\")","v":2}]
[]
[]
["PV ohne Sonder",{"$f":"IF(AND(S_KV_PV_frei<>TRUE,S_PV_Sachsen<>TRUE),TRUE)","v":true},{"$f":"IF(B77,20,\"\")","v":20}]
["PV frei",{"$f":"IF(S_KV_PV_frei=TRUE,TRUE)","v":false},{"$f":"IF(B78,21,\"\")","v":""}]
["PV Sachsen",{"$f":"IF(AND(S_KV_PV_frei<>TRUE,S_PV_Sachsen=TRUE),TRUE)","v":false},{"$f":"IF(B79,22,\"\")","v":""}]
[]
[]
["RV ohne Sonder",{"$f":"IF(AND(S_RV_frei<>TRUE,S_RV_aus_t.E.<>TRUE,S_RV_Knapp<>TRUE),TRUE)","v":true},{"$f":"IF(B82,30,\"\")","v":30}]
["RV frei",{"$f":"IF(S_RV_frei=TRUE,TRUE)","v":false},{"$f":"IF(B83,31,\"\")","v":""}]
["RV nur AG",{"$f":"IF(AND(S_RV_frei<>TRUE,S_RV_aus_t.E.=TRUE,S_RV_Knapp<>TRUE),TRUE)","v":false},{"$f":"IF(B84,32,\"\")","v":""}]
["RV Knappschaft",{"$f":"IF(AND(S_RV_frei<>TRUE,S_RV_aus_t.E.<>TRUE,S_RV_Knapp=TRUE),TRUE)","v":false},{"$f":"IF(B85,33,\"\")","v":""}]
["RV nur AG und Knappschaft",{"$f":"IF(AND(S_RV_frei<>TRUE,S_RV_aus_t.E.=TRUE,S_RV_Knapp=TRUE),TRUE)","v":false},{"$f":"IF(B86,34,\"\")","v":""}]
[]
[]
["AV ohne Sonder",{"$f":"IF(S_AV_frei<>TRUE,TRUE)","v":true},{"$f":"IF(B89,40,\"\")","v":40}]
["AV frei",{"$f":"IF(S_AV_frei=TRUE,TRUE)","v":false},{"$f":"IF(B90,41,\"\")","v":""}]

{"sheet":"Listen","index":4,"n_rows":92,"n_cols":32,"rows_kept":92,"cut":false,"hidden":true,"merged":[[1,1,1,2]]}
[null,"Stand: ","2019-01-07",null,null,null,"Jahr",null,"Zusatz KV","RV","AV","PV","RV Knappsch. ","KV allg","KV erm","Untergrenze","Obergrenze","AG-Ant. Sachsen","AN-Ant. Sachsen","Insolvenzgeld","Zuschlag wg Kinderlosigkeit",null,null,null,null,null,"SUCH","SFall-Nr","Zeile","Spalte","Text","SFall"]
[null,"KV",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB2*100+AC2","v":105},1,5,4,"Monatliches Arbeitsentgelt:","ohne Sonderfall"]
[null,1,2E-3,null,null,1,2019,{"$f":"I3+J3+K3+L3+N3","v":39.65},0.9,18.600000000000001,2.5,3.05,24.7,14.6,14,450,850,1.025E-2,null,5.9999999999999995E-4,0.25,null,null,null,null,null,107,1,7,4,"Gleitzonenentgelt:","ohne Sonderfall"]
[null,2,3.0000000000000001E-3,null,null,{"$f":"F3+1","v":2},2018,{"$f":"I4+J4+K4+L4+N4","v":39.75},1,18.600000000000001,3,2.5499999999999998,24.7,14.6,14,450,850,7.7499999999999999E-3,null,5.9999999999999995E-4,0.25,null,null,null,null,null,205,2,5,4,"Arbeitsentgelt für diese Tätigkeit","Mehrfachbeschäftigung"]
[null,3,3.5000000000000001E-3,null,null,{"$f":"F4+1","v":3},2017,{"$f":"I5+J5+K5+L5+N5","v":39.950000000000003},1.1000000000000001,18.7,3,2.5499999999999998,24.8,14.6,14,450,850,7.7499999999999999E-3,null,8.9999999999999998E-4,0.25,null,null,null,null,null,207,2,7,4,"Gleitzonenentgelt für diese Tätigkeit:","Mehrfachbeschäftigung"]
[null,4,3.8999999999999998E-3,null,null,{"$f":"F5+1","v":4},2016,{"$f":"I6+J6+K6+L6+N6","v":39.75},1.1000000000000001,18.7,3,2.35,24.8,14.6,14,450,850,6.7499999999999999E-3,1.6750000000000001E-2,1.1999999999999999E-3,0.25,null,null,null,null,null,209,2,9,4,"gesamtes monatliches Arbeitsentgelt:","Mehrfachbeschäftigung"]
[null,5,4.0000000000000001E-3,null,null,{"$f":"F6+1","v":5},2015,{"$f":"I7+J7+K7+L7+N7","v":39.549999999999997},0.9,18.7,3,2.35,24.8,14.6,14,450,850,6.7499999999999999E-3,1.6750000000000001E-2,1.5E-3,0.25,null,null,null,null,null,211,2,11,4,"gesamtes monatliches Gleitzonenentgelt:","Mehrfachbeschäftigung"]
[null,6,4.4000000000000003E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB8*100+AC8","v":305},3,5,4,"Teilmonatsentgelt:","teilmonatl. Arbeitsentgelt"]
[null,7,5.0000000000000001E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,307,3,7,4,"Teil-Gleitzonenentgelt:","teilmonatl. Arbeitsentgelt"]
[null,8,6.0000000000000001E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,309,3,9,4,"fiktives monatliches Arbeitsentgelt:","teilmonatl. Arbeitsentgelt"]
[null,9,6.4999999999999997E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,311,3,11,4,"fiktives monatliches Gleitzonenentgelt:","teilmonatl. Arbeitsentgelt"]
[null,10,7.0000000000000001E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,405,4,5,4,"Arbeitsentgelt gesamt:","monatliches Arbeitsentgelt plus Einmalzahlung"]
[null,11,7.9000000000000008E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,407,4,7,4,"Gleitzonenentgelt gesamt:","monatliches Arbeitsentgelt plus Einmalzahlung"]
[null,12,8.0000000000000002E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,409,4,9,4,"monatliches Arbeitsentgelt:","monatliches Arbeitsentgelt plus Einmalzahlung"]
[null,13,8.9999999999999993E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,411,4,11,4,"Einmalzahlung","monatliches Arbeitsentgelt plus Einmalzahlung"]
[null,14,9.4000000000000004E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,505,5,5,4,"Arbeitsentgelt für das zu bewertende BV","Mehrfachbeschäftigung mit teilmonatl. Arbeitsentgelt"]
[null,15,9.7999999999999997E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,507,5,7,4,"Gleitzonenentgelt für dieses BV","Mehrfachbeschäftigung mit teilmonatl. Arbeitsentgelt"]
[null,16,9.9000000000000008E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,509,5,9,4,"gesamtes monatliches Gleitzonenentgelt:","Mehrfachbeschäftigung mit teilmonatl. Arbeitsentgelt"]
[null,17,0.01,null,null,"Auswahl","Beitragszeitraum","Summe SV","Zusatz KV","RV","AV","PV","RV Knappsch. ","KV allg","KV erm","Untergrenze","Obergrenze","AG-Ant. Sachsen","AN-Ant. Sachsen","Insolvenzgeld","Zuschlag wg Kinderlosigkeit",null,null,null,null,null,511,5,11,4,"gesamtes fiktives Arbeitsentgelt:","Mehrfachbeschäftigung mit teilmonatl. Arbeitsentgelt"]
[null,18,1.0999999999999999E-2,null,null,1,{"$f":"F20+1","v":2},{"$f":"G20+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,null,null,null,null,null,513,5,13,4,"gesamtes fiktives Gleitzonenentgelt:","Mehrfachbeschäftigung mit teilmonatl. Arbeitsentgelt"]
[null,19,1.15E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,605,6,5,4,"Arbeitsentgelt gesamt:","teilmonatl. Arbeitsentgelt plus Einmalzahlung"]
[null,20,1.2E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,607,6,7,4,"Gleitzonenentgelt gesamt:","teilmonatl. Arbeitsentgelt plus Einmalzahlung"]
[null,21,1.2999999999999999E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,609,6,9,4,"fiktives monatliches Arbeitsentgelt:","teilmonatl. Arbeitsentgelt plus Einmalzahlung"]
[null,22,1.34E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,611,6,11,4,"fiktives monatliches Arbeitsentgelt gesamt:","teilmonatl. Arbeitsentgelt plus Einmalzahlung"]
[null,23,1.3899999999999999E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,613,6,13,4,"Teilmonatsentgelt:","teilmonatl. Arbeitsentgelt plus Einmalzahlung"]
[null,24,1.4E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,614,6,14,4,"Einmalzahlung:","teilmonatl. Arbeitsentgelt plus Einmalzahlung"]
[null,25,1.44E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,705,7,5,4,"Monatliches Arbeitsentgelt:","monatl. Arbeitseinkommen kleiner Untergrenze"]
[null,26,1.4999999999999999E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,707,7,7,4,"Gleitzonenentgelt:","monatl. Arbeitseinkommen kleiner Untergrenze"]
[null,27,1.6E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,805,8,5,4,"Teilmonatsentgelt:","monatl. Arbeitseinkommen kleiner Untergrenze und mit teilmonatl. Arbeitsentgelt"]
[null,28,1.7000000000000001E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,807,8,7,4,"Teil-Gleitzonenentgelt:","monatl. Arbeitseinkommen kleiner Untergrenze und mit teilmonatl. Arbeitsentgelt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,809,8,9,4,"fiktives monatliches Arbeitsentgelt:","monatl. Arbeitseinkommen kleiner Untergrenze und mit teilmonatl. Arbeitsentgelt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,811,8,11,4,"fiktives monatliches Gleitzonenentgelt:","monatl. Arbeitseinkommen kleiner Untergrenze und mit teilmonatl. Arbeitsentgelt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,914,9,14,4,"Beitragsbemessungsgrundlage für RV:","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3214,32,14,null,"Beitragsbemessungsgrundlage für RV:","RV-Beitrag aus tatsächlichem Arbeitsentgelt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3214,32,14,null,"Beitragsbemessungsgrundlage für RV:","RV-Beitrag aus tatsächlichem Arbeitsentgelt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3414,34,14,null,"Beitragsbemessungsgrundlage für RV:","knappschaftl. RV-Beitrag aus tats. Arbeitsentgelt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3414,34,14,null,"Beitragsbemessungsgrundlage für RV:","knappschaftl. RV-Beitrag aus tats. Arbeitsentgelt"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]