{"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,"Übergangsbereichsrechner"]
[]
[null,{"$f":"IFERROR(CONCATENATE(\" Beitragsberechnung vers.pflichtiger Beschäftigter innerhalb des Übergangsbereichs (\",UGrenz+0.01,\" € bis \",TEXT(OGrenz,\"0.000,00\"),\" €)\"),\"Beitragsberechnung vers.pfl. Beschäftigter innerhalb der Gleitzone \")","v":" Beitragsberechnung vers.pflichtiger Beschäftigter innerhalb des Übergangsbereichs (450,01 € bis 1.300,00 €)"}]
[null,{"$f":"\"Beitragszeitraum:   2. Halbjahr \" & Zeitraum","v":"Beitragszeitraum:   2. 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 des Übergangsbereichs (\",UGrenz+0.01,\" € bis \",TEXT(OGrenz,\"0.000,00\"),\" €)\")","v":" Beitragsberechnung vers.pfl. Beschäftigter innerhalb des Übergangsbereichs (450,01 € bis 1.300,00 €)"}]
[null,{"$f":"\"Beitragszeitraum:   2. Halbjahr \" & Zeitraum","v":"Beitragszeitraum:   2. Halbjahr 2019"}]
[]
[null,"Berechnungsgrundlagen:",null,null,null,"Aktive Sonderregelungen:",null,null,null,null,"Mehrfachbeschäftigung"]
[null,null,null,"Arbeitsentgelt für diese Tätigkeit",1200,"KV:"]
[]
[null,null,null,"Übergangsbereichsentgelt für diese Tätigkeit:",1187.1099999999999,"RV:"]
[]
[null,null,null,"gesamtes monatliches Arbeitsentgelt:",1600,"AV:"]
[]
[null,null,null,"gesamtes monatliches Übergangsbereichsentgelt:","-  ","PV:"]
[]
[null,null,null,null,null,"Sonderfälle:","Mehrfachbeschäftigung"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Teilarbeitsentgelt für die Hauptbeschäftigung",1200]
[null,"Voller SV-Beitrag:",null,"Arbeitgeberanteile:",null,"Arbeitnehmeranteile:",null,"Beitragssatz:",null,null,"Übergangsbereichsentgelt für die Hauptbeschäftigung",1187.1099999999999]
[null,"KV:",0,"KV:",0,"KV:",0,"KV:",0,null,"Teilarbeitsentgelt für die Nebenbeschäftigung",400]
[]
[null,{"$f":"IF(AND(S_KV_PV_frei<>TRUE,BS_KV_Zu<>0),\"Zusatz KV:\",\"\")","v":"Zusatz KV:"},null,{"$f":"B20","v":"Zusatz KV:"},null,{"$f":"B20","v":"Zusatz KV:"},null,{"$f":"B20","v":"Zusatz KV:"}]
[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:",29.68,"AV:",15,"AV:",14.68,"AV:",2.5000000000000001E-2]
[]
[null,"PV:","-  ","PV:","-  ","PV:","-  ","PV:","-  "]
[]
[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":29.68},"SV-Gesamt:",{"$f":"SUM(E18:E28)","v":15},"SV-Gesamt:",{"$f":"SUM(G18:G28)","v":14.68}]
[]
[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":93,"n_cols":7,"rows_kept":93,"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 \",TEXT(OGrenz,\"0.000,00\"),\" €\")","v":"innerhalb des Übergangsbereichs von 450,01 € bis 1.300,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":"\"Beitragszeitraum:   2. Halbjahr \" & Zeitraum","v":"Beitragszeitraum:   2. 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":"C56+5","v":700},{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F7 - UGrenz), 2)","v":622.67999999999995}]
[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.11},null,{"$f":"F7+5","v":705},{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F8 - UGrenz), 2)","v":628.33000000000004}]
[null,null,{"$f":"C8+5","v":460},{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (C9 - UGrenz), 2)","v":351.76},null,{"$f":"F8+5","v":710},{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F9 - UGrenz), 2)","v":633.97}]
[null,null,465,357.4,null,715,639.62]
[null,null,470,363.05,null,720,645.26]
[null,null,475,368.69,null,725,650.91]
[null,null,480,374.34,null,730,656.55]
[null,null,485,379.98,null,735,662.19]
[null,null,490,385.62,null,740,667.84]
[null,null,495,391.27,null,745,673.48]
[null,null,500,396.91,null,750,679.13]
[null,null,505,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (C18 - UGrenz), 2)","v":402.56},null,755,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F18 - UGrenz), 2)","v":684.77}]
[null,null,510,408.2,null,760,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F19 - UGrenz), 2)","v":690.42}]
[null,null,515,413.85,null,765,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F20 - UGrenz), 2)","v":696.06}]
[null,null,520,419.49,null,770,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F21 - UGrenz), 2)","v":701.7}]
[null,null,525,425.13,null,775,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F22 - UGrenz), 2)","v":707.35}]
[null,null,{"$f":"C22+5","v":530},430.78,null,780,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F23 - UGrenz), 2)","v":712.99}]
[null,null,535,436.42,null,785,718.64]
[null,null,540,442.07,null,790,724.28]
[null,null,545,447.71,null,795,729.93]
[null,null,550,453.36,null,800,735.57]
[null,null,555,459,null,805,741.21]
[null,null,560,464.64,null,{"$f":"F28+5","v":810},{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F29 - UGrenz), 2)","v":746.86}]
[null,null,{"$f":"C29+5","v":565},470.29,null,{"$f":"F29+5","v":815},{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F30 - UGrenz), 2)","v":752.5}]
[null,null,570,475.93,null,{"$f":"F30+5","v":820},{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F31 - UGrenz), 2)","v":758.15}]
[null,null,575,481.58,null,825,763.79]
[null,null,580,487.22,null,830,769.44]
[null,null,585,492.87,null,835,775.08]
[null,null,590,498.51,null,840,780.72]
[null,null,595,504.15,null,845,786.37]
[null,null,600,509.8,null,850,792.01]
[null,null,605,515.44000000000005,null,855,797.66]
[null,null,610,521.09,null,860,803.3]
[null,null,615,526.73,null,865,808.95]
[null,null,620,532.38,null,870,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F41 - UGrenz), 2)","v":814.59}]
[null,null,625,538.02,null,875,820.24]
[null,null,630,543.66,null,880,825.88]
[null,null,635,549.30999999999995,null,885,831.52]
[null,null,640,554.95000000000005,null,890,837.17]
[null,null,{"$f":"C45+5","v":645},560.6,null,{"$f":"F45+5","v":895},842.81]
[null,null,{"$f":"C46+5","v":650},{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (C47 - UGrenz), 2)","v":566.24},null,{"$f":"F46+5","v":900},{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F47 - UGrenz), 2)","v":848.46}]
[null,null,655,571.89,null,905,854.1]
[null,null,660,577.53,null,910,859.75]
[null,null,665,583.16999999999996,null,915,865.39]
[null,null,670,588.82000000000005,null,920,871.03]
[null,null,675,594.46,null,925,876.68]
[null,null,680,600.11,null,930,882.32]
[null,null,685,605.75,null,935,887.97]
[null,null,690,611.4,null,940,893.61]
[null,null,695,617.04,null,945,899.26]
[]
[null,null,{"$f":"F56+5","v":950},904.9,null,{"$f":"C93+5","v":1130},1108.0899999999999]
[null,null,955,910.54,null,1135,1113.74]
[null,null,960,916.19,null,1140,1119.3800000000001]
[null,null,965,921.83,null,1145,1125.03]
[null,null,970,927.48,null,1150,1130.67]
[null,null,975,933.12,null,1155,1136.32]
[null,null,980,938.77,null,1160,1141.96]
[null,null,985,944.41,null,1165,1147.5999999999999]
[null,null,990,950.05,null,1170,1153.25]
[null,null,995,955.7,null,1175,1158.8900000000001]
[null,null,1000,961.34,null,1180,1164.54]
[null,null,1005,966.99,null,1185,1170.18]
[null,null,1010,972.63,null,1190,1175.83]
[null,null,1015,978.28,null,1195,1181.47]
[null,null,1020,983.92,null,1200,1187.1099999999999]
[null,null,1025,989.56,null,1205,1192.76]
[null,null,1030,995.21,null,1210,1198.4000000000001]
[null,null,1035,1000.85,null,1215,1204.05]
[null,null,1040,1006.5,null,1220,1209.69]
[null,null,1045,1012.14,null,1225,1215.3399999999999]
[null,null,1050,1017.79,null,1230,1220.98]
[null,null,1055,1023.43,null,1235,1226.6199999999999]
[null,null,1060,1029.07,null,1240,1232.27]
[null,null,1065,1034.72,null,1245,1237.9100000000001]
[null,null,1070,1040.3599999999999,null,1250,1243.56]
[null,null,1075,1046.01,null,1255,1249.2]
[null,null,1080,1051.6500000000001,null,1260,1254.8499999999999]
[null,null,1085,1057.3,null,1265,1260.49]
[null,null,1090,1062.94,null,1270,1266.1300000000001]
[null,null,{"$f":"C86+5","v":1095},{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (C87 - UGrenz), 2)","v":1068.58},null,{"$f":"F86+5","v":1275},{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F87 - UGrenz), 2)","v":1271.78}]
[null,null,1100,1074.23,null,1280,1277.42]
[null,null,1105,1079.8699999999999,null,1285,1283.07]
[null,null,1110,1085.52,null,1290,1288.71]
[null,null,{"$f":"C90+5","v":1115},{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (C91 - UGrenz), 2)","v":1091.1600000000001},null,{"$f":"F90+5","v":1295},{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F91 - UGrenz), 2)","v":1294.3599999999999}]
[null,null,1120,1096.81,null,1300,1300]
[null,null,1125,1102.45]

{"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":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":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.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",14,{"$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",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. ",false]
["nur  AV",11]
["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: ","2019-09-13",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,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,1300,1.025E-2,null,5.9999999999999995E-4,0.25,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},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,null,"KV_Text","=Dialog!$G$5","Dialog","G",5]
[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,"Übergangsbereichsentgelt für diese Tätigkeit:","Mehrfachbeschäftigung",null,null,"S_Sonder_2_Stunden_Bez","=Dialog!$K$5","Dialog","K",5]
[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,null,"S_Sonder_2_Tage_Bez","=Dialog!$K$5","Dialog","K",5]
[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 Übergangsbereichsentgelt:","Mehrfachbeschäftigung",null,null,"S_Sonder_2_Stunden","=Dialog!$L$5","Dialog","L",5]
[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,null,"S_Sonder_2_Tage","=Dialog!$L$5","Dialog","L",5]
[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-Übergangsbereichsentgelt:","teilmonatl. Arbeitsentgelt",null,null,"n_W7_Bez","=Dialog!$D$7","Dialog","D",7]
[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,null,"n_W7","=Dialog!$E$7","Dialog","E",7]
[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 Übergangsbereichsentgelt:","teilmonatl. Arbeitsentgelt",null,null,"RV_Text","=Dialog!$G$7","Dialog","G",7]
[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,null,"S_Sonder_2_WoStunden_Bez","=Dialog!$K$7","Dialog","K",7]
[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,"Übergangsbereichsentgelt gesamt:","monatliches Arbeitsentgelt plus Einmalzahlung",null,null,"S_Sonder_2_WoStunden","=Dialog!$L$7","Dialog","L",7]
[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,null,"n_W9_Bez","=Dialog!$D$9","Dialog","D",9]
[null,13,8.8999999999999999E-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,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,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,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,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,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,509,5,9,4,"gesamtes monatliches Übergangsbereichsentgelt:","Mehrfachbeschäftigung mit teilmonatl. Arbeitsentgelt",null,null,"n_W11","=Dialog!$E$11","Dialog","E",11]
[null,17,9.9000000000000008E-3,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,0.01,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.0500000000000001E-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.06E-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.0800000000000001E-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.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,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.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,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.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,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.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,705,7,5,4,"Monatliches Arbeitsentgelt:","monatl. Arbeitseinkommen kleiner Untergrenze",null,null,"n_W14_Bez","=Dialog!$D$14","Dialog","D",14]
[null,26,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,707,7,7,4,"Übergangsbereichsentgelt:","monatl. Arbeitseinkommen kleiner Untergrenze",null,null,"n_W14","=Dialog!$E$14","Dialog","E",14]
[null,27,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,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.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,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.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,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.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,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.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,914,9,14,4,"Beitragsbemessungsgrundlage für RV:","-",null,null,"nKV_Zu_ges","=Dialog!$C$26","Dialog","C",20]
[null,32,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,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,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_AN","=Dialog!$G$26","Dialog","G",20]
[null,34,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,"nKV_Zu_Satz","=Dialog!$I$26","Dialog","I",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,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]