{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Angaben","Dialog","Tabelle","Steuerung","Listen"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":117,"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":28,"n_cols":13,"rows_kept":28,"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,"Übergangsbereichsrechner"]
[]
[null,{"$f":"IFERROR(CONCATENATE(\" Beitragsberechnung vers.pflichtiger Beschäftigter innerhalb des Übergangsbereichs (\",UGrenz+0.01,\" € bis 520,00 €)\"),\"Beitragsberechnung vers.pfl. Beschäftigter innerhalb der Gleitzone \")","v":" Beitragsberechnung vers.pflichtiger Beschäftigter innerhalb des Übergangsbereichs (450,01 € bis 520,00 €)"}]
[null,{"$f":"\"Beitragszeitraum:  ab 1. Oktober 2022\"","v":"Beitragszeitraum:  ab 1. Oktober 2022"}]
[null,"Zutreffende Sonderregelungen:",null,null,null,null,"Individuelle Angaben:",null,null,null,null,null," Auswahl des individuellen KV-Zusatzbeitragssatzes"]
[]
[null,null,null,null,null,null,"  Angabe des individuellen KV-Zusatzbeitragssatzes:",null,null,{"$f":"IF(AND(LC_Liste_KV_Zu=1,BS_KV_Zu_man=\"\"),\"\",BS_KV_Zu/100)","v":1.3500000000000002E-2}]
[]
[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.39950000000000002}]
[]
[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":1.3000000000000001E-2}]
[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.4E-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}]

{"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 des Übergangsbereichs (\",UGrenz+0.01,\" € bis 520,00 €)\")","v":" Beitragsberechnung vers.pfl. Beschäftigter innerhalb des Übergangsbereichs (450,01 € bis 520,00 €)"}]
[null,{"$f":"\"Beitragszeitraum:  ab 1. Oktober 2022\"","v":"Beitragszeitraum:  ab 1. Oktober 2022"}]
[]
[null,"Berechnungsgrundlagen:",null,null,null,"Aktive Sonderregelungen:",null,null,null,null,"ohne Sonderfall"]
[null,null,null,"Monatliches Arbeitsentgelt:",510,"KV:","allgemeiner Beitragssatz"]
[]
[null,null,null,"Übergangsbereichsentgelt:",405.82,"RV:","keine Beschäftigung im Haushalt"]
[]
[null,null,null,null,null,"AV:"]
[]
[null,null,null,null,null,"PV:"]
[]
[null,null,null,null,null,"Sonderfälle:"]
[]
[]
[]
[null,"Voller SV-Beitrag:",null,"Arbeitgeberanteile:",null,"Arbeitnehmeranteile:",null,"Beitragssatz:"]
[null,"KV:",59.24,"KV:",37.229999999999997,"KV:",22.010000000000005,"KV:",0.14599999999999999]
[]
[null,{"$f":"IF(AND(S_KV_PV_frei<>TRUE,BS_KV_Zu<>0),\"Zusatz KV:\",\"\")","v":"Zusatz KV:"},5.48,{"$f":"B20","v":"Zusatz KV:"},3.44,{"$f":"B20","v":"Zusatz KV:"},2.0400000000000005,{"$f":"B20","v":"Zusatz KV:"},1.3500000000000002E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L21*3","v":0}]
[null,"RV:","-  ","RV:","-  ","RV:","-  ","RV:","-  "]
[]
[null,"AV:",9.74,"AV:",6.12,"AV:",3.62,"AV:",2.4E-2]
[]
[null,"PV:",12.38,"PV:",7.78,"PV:",4.6000000000000005,"PV:",3.0499999999999999E-2]
[]
[null,{"$f":"IF(S_PV_Zu=1,\"Zuschl. PV:\",\"\")","v":""},null,{"$f":"B28","v":""},null,{"$f":"B28","v":""},null,{"$f":"B28","v":""}]
[]
[null,"SV-Gesamt:",{"$f":"SUM(C18:C28)","v":86.839999999999989},"SV-Gesamt:",{"$f":"SUM(E18:E28)","v":54.569999999999993},"SV-Gesamt:",{"$f":"SUM(G18:G28)","v":32.270000000000003}]
[]
[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":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,null,"Beitragspflichtige Einnahmen und Beitragsberechnung versicherungspfl. Beschäftigter"]
[null,null,{"$f":"CONCATENATE(\"innerhalb des Übergangsbereichs von \",UGrenz+0.01,\" € bis 520,00 €\")","v":"innerhalb des Übergangsbereichs von 450,01 € bis 520,00 €"}]
[null,null,"(§ 20 Abs.2 SGB IV, § 134 SGB IV, § 344 Abs.4 SGB III, § 226 Abs.4 SGB V, § 276b SGB VI, § 58 Abs.5 SGB XI)"]
[]
[null,null,{"$f":"\"Beitragszeitraum:  \" & Zeitraum","v":"Beitragszeitraum:  2022"}]
[null,null,"monatliches Arbeitsentgelt",{"$f":"\"Beitragsbemes-sungsgrundlage bei: \"&Steuerung!C7&\" %\"","v":"Beitragsbemes-sungsgrundlage bei: 39,95 %"}]
[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":337.92}]
[null,null,{"$f":"UGrenz+5","v":455},{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (C8 - UGrenz), 2)","v":343.56}]
[null,null,{"$f":"C8+5","v":460},{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (C9 - UGrenz), 2)","v":349.22}]
[null,null,465,354.88]
[null,null,470,360.54]
[null,null,475,366.2]
[null,null,480,371.86]
[null,null,485,377.52]
[null,null,490,383.18]
[null,null,495,388.84]
[null,null,500,394.5]
[null,null,505,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (C18 - UGrenz), 2)","v":400.16}]
[null,null,510,405.82]
[null,null,515,411.48]
[null,null,520,417.14]

{"sheet":"Steuerung","index":3,"n_rows":100,"n_cols":12,"rows_kept":100,"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":2022}]
["Beitragszeitraum",1,{"$f":"IFERROR(VLOOKUP(B3,Jahr,D3,0),\"Fehler\")","v":2022},{"$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":1300},{"$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.75090000000000001}]
["Summe SV",{"$f":"B2","v":1},{"$f":"VLOOKUP(B7,Jahr,D7,0)","v":39.950000000000003},{"$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.4,{"$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},1.3,{"$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",21,{"$f":"IFERROR(VLOOKUP(B16,KV,2,0)*100,D16)","v":1.35},1.7,"manuell","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",2,{"$f":"IF(S_PV_Zu=1,VLOOKUP(B2,Jahr,D20,0),0)","v":0},{"$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",false]
["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":false},{"$f":"IF(B45,50,\"\")","v":""}]
[]
[]
["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":""},null,null,1200,18.600000000000001,{"$f":"F90*G90/100","v":223.2},{"$f":"H90/2","v":111.6}]
[null,null,null,null,null,384.54,24.7,{"$f":"F91*G91/100","v":94.981380000000001},{"$f":"H91/2","v":47.490690000000001}]
[]
[null,null,null,null,null,null,null,"AG = ÜE * Satz - ((ÜE * Satz * Faktor)- (AE * Satz))"]
[]
[null,null,null,null,null,null,null," ÜE * Satz","ÜE * Satz * Faktor","AE * Satz"," ((ÜE * Satz * Faktor)- (AE * Satz))","AG"]
[null,null,null,null,null,"ÜE",384.54]
[null,null,null,null,null,"AE",520]
[null,null,null,null,null,"Satz",0.247]
[null,null,null,null,null,"Faktor",2]
[null,null,null,null,null,null,null,{"$f":"G96*G98","v":94.981380000000001},{"$f":"G96*G98*G99","v":189.96276},{"$f":"G97*G98","v":128.44},{"$f":"I100-J100","v":61.522760000000005},{"$f":"H100-K100","v":33.458619999999996}]

{"sheet":"Listen","index":4,"n_rows":111,"n_cols":39,"rows_kept":111,"cut":false,"hidden":true,"merged":[[1,1,1,2]]}
[null,"Stand: ","2022-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,null,"Name","Bezug","Blatt","Spalte","Zeile"]
[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,null,"n_W5_Bez","=Dialog!$D$5",{"$f":"MID(AJ2,2,FIND(\"!\",AJ2,1)-2)","v":"Dialog"},{"$f":"MID(AJ2,FIND(\"!\",AJ2,1)+2,FIND(\"$\",AJ2,FIND(\"!\",AJ2,1)+2)-FIND(\"!\",AJ2,1)-2)","v":"D"},{"$f":"VALUE(MID(AJ2,FIND(\"$\",AJ2,FIND(\"!\",AJ2,1)+2)+1,5))","v":5}]
[null,1,"manuelle Eingabe",null,null,1,2022,{"$f":"I3+J3+K3+L3+N3","v":39.950000000000003},1.3,18.600000000000001,2.4,3.05,24.7,14.6,14,450,1300,1.025E-2,null,8.9999999999999998E-4,0.35,null,null,null,null,null,107,1,7,4,"Übergangsbereichsentgelt:","ohne Sonderfall",null,null,"n_W5","=Dialog!$E$5","Dialog","E",5]
[null,2,3.0000000000000001E-3,null,null,{"$f":"F3+1","v":2},2021,{"$f":"I4+J4+K4+L4+N4","v":39.950000000000003},1.3,18.600000000000001,2.4,3.05,24.7,14.6,14,450,1300,1.025E-2,null,1.1999999999999999E-3,0.25,null,null,null,null,null,205,2,5,4,"Arbeitsentgelt für diese Tätigkeit","Mehrfachbeschäftigung",null,null,"KV_Text","=Dialog!$G$5","Dialog","G",5]
[null,3,3.5000000000000001E-3,null,null,3,2020,39.75,1.1000000000000001,18.600000000000001,2.4,3.05,24.7,14.6,14,450,1300,1.025E-2,null,5.9999999999999995E-4,0.25,null,null,null,null,null,207,2,7,4,"Übergangsbereichsentgelt für diese Tätigkeit:","Mehrfachbeschäftigung",null,null,"S_Sonder_2_Stunden_Bez","=Dialog!$K$5","Dialog","K",5]
[null,4,4.0000000000000001E-3,null,null,4,2019,39.65,0.9,18.600000000000001,2.5,3.05,24.7,14.6,14,450,1300,1.025E-2,null,5.9999999999999995E-4,0.25,null,null,null,null,null,209,2,9,4,"gesamtes monatliches Arbeitsentgelt:","Mehrfachbeschäftigung",null,null,"S_Sonder_2_Tage_Bez","=Dialog!$K$5","Dialog","K",5]
[null,5,5.0000000000000001E-3,null,null,5,2018,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,211,2,11,4,"gesamtes monatliches Übergangsbereichsentgelt:","Mehrfachbeschäftigung",null,null,"S_Sonder_2_Stunden","=Dialog!$L$5","Dialog","L",5]
[null,6,6.4999999999999997E-3,null,null,6,2017,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,{"$f":"AB8*100+AC8","v":305},3,5,4,"Teilmonatsentgelt:","teilmonatl. Arbeitsentgelt",null,null,"S_Sonder_2_Tage","=Dialog!$L$5","Dialog","L",5]
[null,7,6.8999999999999999E-3,null,null,7,2016,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,307,3,7,4,"Teil-Übergangsbereichsentgelt:","teilmonatl. Arbeitsentgelt",null,null,"n_W7_Bez","=Dialog!$D$7","Dialog","D",7]
[null,8,7.0000000000000001E-3,null,null,8,2015,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,309,3,9,4,"fiktives monatliches Arbeitsentgelt:","teilmonatl. Arbeitsentgelt",null,null,"n_W7","=Dialog!$E$7","Dialog","E",7]
[null,9,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,311,3,11,4,"fiktives monatliches Übergangsbereichsentgelt:","teilmonatl. Arbeitsentgelt",null,null,"RV_Text","=Dialog!$G$7","Dialog","G",7]
[null,10,8.3999999999999995E-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,null,"S_Sonder_2_WoStunden_Bez","=Dialog!$K$7","Dialog","K",7]
[null,11,8.8000000000000005E-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,"Übergangsbereichsentgelt gesamt:","monatliches Arbeitsentgelt plus Einmalzahlung",null,null,"S_Sonder_2_WoStunden","=Dialog!$L$7","Dialog","L",7]
[null,12,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,409,4,9,4,"monatliches Arbeitsentgelt:","monatliches Arbeitsentgelt plus Einmalzahlung",null,null,"n_W9_Bez","=Dialog!$D$9","Dialog","D",9]
[null,13,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,411,4,11,4,"Einmalzahlung","monatliches Arbeitsentgelt plus Einmalzahlung",null,null,"n_W9","=Dialog!$E$9","Dialog","E",9]
[null,14,0.01,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,null,"AV_Text","=Dialog!$G$9","Dialog","G",9]
[null,15,1.0999999999999999E-2,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,"Übergangsbereichsentgelt für dieses BV","Mehrfachbeschäftigung mit teilmonatl. Arbeitsentgelt",null,null,"n_W11_Bez","=Dialog!$D$11","Dialog","D",11]
[null,16,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,509,5,9,4,"gesamtes monatliches Übergangsbereichsentgelt:","Mehrfachbeschäftigung mit teilmonatl. Arbeitsentgelt",null,null,"n_W11","=Dialog!$E$11","Dialog","E",11]
[null,17,1.2500000000000001E-2,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,null,"PV_Text","=Dialog!$G$11","Dialog","G",11]
[null,18,1.2800000000000001E-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 Übergangsbereichsentgelt:","Mehrfachbeschäftigung mit teilmonatl. Arbeitsentgelt",null,null,"S_Sonder_2_Stunden_B_Bez","=Dialog!$K$11","Dialog","K",11]
[null,19,1.29E-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,null,"S_Sonder_2_Stunden_B","=Dialog!$L$11","Dialog","L",11]
[null,20,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,607,6,7,4,"Übergangsbereichsentgelt gesamt:","teilmonatl. Arbeitsentgelt plus Einmalzahlung",null,null,"n_W13_Bez","=Dialog!$D$13","Dialog","D",13]
[null,21,1.35E-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,null,"n_W13","=Dialog!$E$13","Dialog","E",13]
[null,22,1.38E-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,null,"S_Text","=Dialog!$G$13","Dialog","G",13]
[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,null,"S_Sonder_2_WoStunden_Bez_B","=Dialog!$K$13","Dialog","K",13]
[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,null,"S_Sonder_2_WoStunden_B","=Dialog!$L$13","Dialog","L",13]
[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,null,"n_W14_Bez","=Dialog!$D$14","Dialog","D",14]
[null,26,1.4500000000000001E-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,"Übergangsbereichsentgelt:","monatl. Arbeitseinkommen kleiner Untergrenze",null,null,"n_W14","=Dialog!$E$14","Dialog","E",14]
[null,27,1.4800000000000001E-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,null,"nKV_ges","=Dialog!$C$18","Dialog","C",18]
[null,28,1.49E-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-Übergangsbereichsentgelt:","monatl. Arbeitseinkommen kleiner Untergrenze und mit teilmonatl. Arbeitsentgelt",null,null,"nKV_AG","=Dialog!$E$18","Dialog","E",18]
[null,29,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,809,8,9,4,"fiktives monatliches Arbeitsentgelt:","monatl. Arbeitseinkommen kleiner Untergrenze und mit teilmonatl. Arbeitsentgelt",null,null,"nKV_AN","=Dialog!$G$18","Dialog","G",18]
[null,30,1.54E-2,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 Übergangsbereichsentgelt:","monatl. Arbeitseinkommen kleiner Untergrenze und mit teilmonatl. Arbeitsentgelt",null,null,"nKV_Satz","=Dialog!$I$18","Dialog","I",18]
[null,31,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,914,9,14,4,"Beitragsbemessungsgrundlage für RV:","-",null,null,"nKV_Zu_ges","=Dialog!$C$26","Dialog","C",20]
[null,32,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,3214,32,14,null,"Beitragsbemessungsgrundlage für RV:","RV-Beitrag aus tatsächlichem Arbeitsentgelt",null,null,"nKV_Zu_AG","=Dialog!$E$26",{"$f":"MID(AJ34,2,FIND(\"!\",AJ34,1)-2)","v":"Dialog"},{"$f":"MID(AJ34,FIND(\"!\",AJ34,1)+2,FIND(\"$\",AJ34,FIND(\"!\",AJ34,1)+2)-FIND(\"!\",AJ34,1)-2)","v":"E"},20]
[null,33,2.1999999999999999E-2,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,"nKV_Zu_AN","=Dialog!$G$26","Dialog","G",20]
[null,34,2.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,3414,34,14,null,"Beitragsbemessungsgrundlage für RV:","knappschaftl. RV-Beitrag aus tats. Arbeitsentgelt",null,null,"nKV_Zu_Satz","=Dialog!$I$26","Dialog","I",20]
[null,35,2.5000000000000001E-2,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,"nRV_ges","=Dialog!$C$20","Dialog","C",22]
[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,null,null,null,null,null,null,null,null,"nRV_AG","=Dialog!$E$20","Dialog","E",22]
[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,null,null,null,null,null,null,null,null,"nRV_AN","=Dialog!$G$20","Dialog","G",22]
[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,null,null,null,null,null,null,null,null,"nRV_Satz","=Dialog!$I$20","Dialog","I",22]
[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,null,null,null,null,null,null,null,null,"nAV_ges","=Dialog!$C$22","Dialog","C",24]
[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,null,null,null,null,null,null,null,null,"nAV_AG","=Dialog!$E$22","Dialog","E",24]
[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,null,null,null,null,null,null,null,null,"nAV_AN","=Dialog!$G$22","Dialog","G",24]
[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,null,null,null,null,null,null,null,null,"nAV_Satz","=Dialog!$I$22","Dialog","I",24]
[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,null,null,null,null,null,null,null,null,"nPV_ges","=Dialog!$C$24","Dialog","C",26]
[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,null,null,null,null,null,null,null,null,"nPV_AG","=Dialog!$E$24","Dialog","E",26]
[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,null,null,null,null,null,null,null,null,"nPV_AN","=Dialog!$G$24","Dialog","G",26]
[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,null,null,null,null,null,null,null,null,"nPV_Satz","=Dialog!$I$24","Dialog","I",26]
[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,null,null,null,null,null,null,null,null,"nPV_Zu_ges","=Dialog!$C$28","Dialog","C",{"$f":"VALUE(MID(AJ49,FIND(\"$\",AJ49,FIND(\"!\",AJ49,1)+2)+1,5))","v":28}]
[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,null,null,null,null,null,null,null,null,"nPV_Zu_AG","=Dialog!$E$28","Dialog","E",28]
[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,null,null,null,null,null,null,null,null,"nPV_Zu_AN","=Dialog!$G$28","Dialog","G",28]
[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,null,null,null,null,null,null,null,null,"nPV_Zu_Satz","=Dialog!$I$28","Dialog","I",28]
[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,null,null,null,null,null,null,null,null,"nU1_ges","=Dialog!$C$32","Dialog","C",32]
[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,null,null,null,null,null,null,null,null,"nU1_AG","=Dialog!$E$32","Dialog","E",32]
[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,null,null,null,null,null,null,null,null,"nU1_Satz","=Dialog!$I$32","Dialog","I",32]
[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,null,null,null,null,null,null,null,null,"nU2_ges","=Dialog!$C$33","Dialog","C",33]
[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,null,null,null,null,null,null,null,null,"nU2_AG","=Dialog!$E$33","Dialog","E",33]
[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,null,null,null,null,null,null,null,null,"nU2_Satz","=Dialog!$I$33","Dialog","I",33]
[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,null,null,null,null,null,null,null,null,"nU3_ges","=Dialog!$C$34","Dialog","C",34]
[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,null,null,null,null,null,null,null,null,"nU3_AG","=Dialog!$E$34","Dialog","E",34]
[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,null,null,null,null,null,null,null,null,"nU3_Satz","=Dialog!$I$34","Dialog","I",34]
[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,null,null,null,null,null,null,null,null,"Druckbereich","=Listen!$A$1:$A$83","Listen","A",{"$error":"#VALUE!"}]
[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,null,null,null,null,null,null,null,null,"Liste_Bezeichnung","=Listen!$AA$1:$AJ$44","Listen","AA",{"$error":"#VALUE!"}]
[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,null,null,null,null,null,null,null,null,"KV","=Listen!$B$3:$C$83","Listen","B",{"$error":"#VALUE!"}]
[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,null,null,null,null,null,null,null,null,"drop_KV","=Listen!$C$3:$C$44","Listen","C",{"$error":"#VALUE!"}]
[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,null,null,null,null,null,null,null,null,"Jahr","=Listen!$F$3:$U$6",{"$f":"MID(AJ66,2,FIND(\"!\",AJ66,1)-2)","v":"Listen"},{"$f":"MID(AJ66,FIND(\"!\",AJ66,1)+2,FIND(\"$\",AJ66,FIND(\"!\",AJ66,1)+2)-FIND(\"!\",AJ66,1)-2)","v":"F"},{"$error":"#VALUE!"}]
[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,null,null,null,null,null,null,null,null,"drop_Jahr","=Listen!$G$3:$G$3","Listen","G",{"$error":"#VALUE!"}]
[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,null,null,null,null,null,null,null,null,"Gew_Jahr","=Steuerung!$C$2","Steuerung","C",2]
[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,null,null,null,null,null,null,null,null,"LC_Liste_Jahr","=Steuerung!$B$3","Steuerung","B",3]
[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,null,null,null,null,null,null,null,null,"Zeitraum","=Steuerung!$C$3","Steuerung","C",3]
[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,null,null,null,null,null,null,null,null,"UGrenz","=Steuerung!$C$4","Steuerung","C",4]
[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,null,null,null,null,null,null,null,null,"OGrenz","=Steuerung!$C$5","Steuerung","C",5]
[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,null,null,null,null,null,null,null,null,"Faktor","=Steuerung!$C$6","Steuerung","C",6]
[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,null,null,null,null,null,null,null,null,"nRV_Satz_Jahr","=Steuerung!$C$9","Steuerung","C",9]
[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,null,null,null,null,null,null,null,null,"nAV_Satz_Jahr","=Steuerung!$C$10","Steuerung","C",10]
[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,null,null,null,null,null,null,null,null,"nPV_Satz_Jahr","=Steuerung!$C$11","Steuerung","C",11]
[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,null,null,null,null,null,null,null,null,"S_KV_allg_erm.BS","=Steuerung!$B$15","Steuerung","B",15]
[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,null,null,null,null,null,null,null,null,"BS_KV_allg","=Steuerung!$C$15","Steuerung","C",15]
[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,null,null,null,null,null,null,null,null,"S_BS_allg","=Steuerung!$G$15","Steuerung","G",15]
[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,null,null,null,null,null,null,null,null,"LC_Liste_KV_Zu","=Steuerung!$B$16","Steuerung","B",16]
[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,null,null,null,null,null,null,null,null,"BS_KV_Zu","=Steuerung!$C$16","Steuerung","C",{"$f":"VALUE(MID(AJ81,FIND(\"$\",AJ81,FIND(\"!\",AJ81,1)+2)+1,5))","v":16}]
[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,null,null,null,null,null,null,null,null,"S_BS_ermäßigt","=Steuerung!$G$16","Steuerung","G",16]
[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,null,null,null,null,null,null,null,null,"nRV_Knapp_Jahr","=Steuerung!$C$17","Steuerung","C",17]
[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,null,null,null,null,null,null,null,null,"nPV_Sachsen_AG_Jahr","=Steuerung!$C$18","Steuerung","C",18]
[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,null,null,null,null,null,null,null,null,"S_PV_Zu","=Steuerung!$B$20","Steuerung","B",20]
[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,null,null,null,null,null,null,null,null,"BS_PV_Zu","=Steuerung!$C$20","Steuerung","C",20]
[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,null,null,null,null,null,null,null,null,"S_U1","=Steuerung!$B$21","Steuerung","B",21]
[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,null,null,null,null,null,null,null,null,"S_U1_Satz","=Steuerung!$C$21","Steuerung","C",21]
[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,null,null,null,null,null,null,null,null,"S_U2","=Steuerung!$B$22","Steuerung","B",22]
[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,null,null,null,null,null,null,null,null,"S_U2_Satz","=Steuerung!$C$22","Steuerung","C",22]
[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,null,null,null,null,null,null,null,null,"S_U3","=Steuerung!$B$23","Steuerung","B",23]
[null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},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,null,null,null,null,null,"S_U3_Satz","=Steuerung!$C$23","Steuerung","C",23]
[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,null,null,null,null,null,null,null,null,"S_KV_PV_frei","=Steuerung!$B$25","Steuerung","B",25]
[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,null,null,null,null,null,null,null,null,"S_PV_Sachsen","=Steuerung!$B$26","Steuerung","B",26]
[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,null,null,null,null,null,null,null,null,"S_RV_frei","=Steuerung!$B$27","Steuerung","B",27]
[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,null,null,null,null,null,null,null,null,"S_RV_aus_t.E.","=Steuerung!$B$28","Steuerung","B",28]
[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,null,null,null,null,null,null,null,null,"S_RV_Knapp","=Steuerung!$B$29","Steuerung","B",29]
[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,null,null,null,null,null,null,null,null,"S_AV_nur","=Steuerung!$B$30",{"$f":"MID(AJ98,2,FIND(\"!\",AJ98,1)-2)","v":"Steuerung"},{"$f":"MID(AJ98,FIND(\"!\",AJ98,1)+2,FIND(\"$\",AJ98,FIND(\"!\",AJ98,1)+2)-FIND(\"!\",AJ98,1)-2)","v":"B"},30]
[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,null,null,null,null,null,null,null,null,"S_AV_frei","=Steuerung!$B$31","Steuerung","B",31]
[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,null,null,null,null,null,null,null,null,"S_SGB_III","=Steuerung!$B$32","Steuerung","B",32]
[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,null,null,null,null,null,null,null,null,"S_Sonder_1","=Steuerung!$B$33","Steuerung","B",33]
[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,null,null,null,null,null,null,null,null,"S_Sonder_2","=Steuerung!$B$34","Steuerung","B",34]
[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,null,null,null,null,null,null,null,null,"S_Sonder_2_Opt","=Steuerung!$B$35","Steuerung","B",35]
[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,null,null,null,null,null,null,null,null,"S_Sonder_2_Opt1","=Steuerung!$G$35","Steuerung","G",35]
[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,null,null,null,null,null,null,null,null,"S_Mehrfach","=Steuerung!$B$36","Steuerung","B",36]
[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,null,null,null,null,null,null,null,null,"S_Sonder_2_Opt2","=Steuerung!$G$36","Steuerung","G",36]
[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,null,null,null,null,null,null,null,null,"S_Sonder_4","=Steuerung!$B$37","Steuerung","B",37]
[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,null,null,null,null,null,null,null,null,"S_Sonder_5","=Steuerung!$B$38","Steuerung","B",38]
[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,null,null,null,null,null,null,null,null,"nAuswahl_Sonder","=Steuerung!$C$40","Steuerung","C",40]
[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,null,null,null,null,null,null,null,null,"S_Sonder_3_Quot","=Steuerung!$B$55","Steuerung","B",55]
[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,null,null,null,null,null,null,null,null,"S_Sonder_aktuell","=Steuerung!$C$69","Steuerung","C",69]