{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Angaben","Dialog","Tabelle","Steuerung","Listen"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":130,"comments":1,"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":31,"n_cols":13,"rows_kept":31,"cut":false,"hidden":false,"merged":[[26,6,26,8],[28,6,28,8],[30,6,30,8],[2,1,2,9],[8,1,8,5],[21,6,21,8],[20,6,20,8],[22,6,22,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 (538,01 € bis 2.000,00 €)"}]
[null,{"$f":"\"Beitragszeitraum: 01.01.\" & Zeitraum & \" - 31.12.\"& Zeitraum","v":"Beitragszeitraum: 01.01.2024 - 31.12.2024"}]
[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":0}]
[]
[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,"  Beitragsabschlag in der PV (ab dem 2. Kind)"]
[null,null,null,null,null,null,"  Höhe des Beitragsabschlags"]
[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.40899999999999997}]
[]
[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.7000000000000001E-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.6000000000000002E-2}]
[null,null,null,null,null,null,"  Beitragssatz Pflegeversicherung",null,null,{"$f":"IFERROR(nPV_Satz_Jahr/100,\"\")","v":3.4000000000000002E-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":11,"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 (538,01 € bis 2.000,00 €)"}]
[null,{"$f":"\"Beitragszeitraum: 01.01.\" & Zeitraum & \" - 31.12.\"& Zeitraum","v":"Beitragszeitraum: 01.01.2024 - 31.12.2024"}]
[]
[null,"Berechnungsgrundlagen:",null,null,null,"Aktive Sonderregelungen:",null,null,null,null,"ohne Sonderfall"]
[null,null,null,"Monatliches Arbeitsentgelt:",1000,"KV:","allgemeiner Beitragssatz"]
[]
[null,null,null,"Übergangsbereichsentgelt:",883.94,"RV:"]
[]
[null,null,null,"BE Arbeitnehmer: ",632.01,"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:",129.06,"KV:",82.92,"KV:",46.14,"KV:",0.14599999999999999]
[]
[null,{"$f":"IF(S_KV_PV_frei<>TRUE,\"Zusatz KV:\",\"\")","v":"Zusatz KV:"},null,{"$f":"B20","v":"Zusatz KV:"},null,{"$f":"B20","v":"Zusatz KV:"},null,{"$f":"B20","v":"Zusatz KV:"}]
[]
[null,"RV:",164.42,"RV:",105.63999999999999,"RV:",58.78,"RV:",0.18600000000000003]
[]
[null,"AV:",22.98,"AV:",14.76,"AV:",8.2200000000000006,"AV:",2.6000000000000002E-2]
[]
[null,"PV:",30.060000000000002,"PV:",19.32,"PV:",10.74,"PV:",3.4000000000000002E-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":346.52000000000004},"SV-Gesamt:",{"$f":"SUM(E18:E28)","v":222.64},"SV-Gesamt:",{"$f":"SUM(G18:G28)","v":123.88}]
[]
[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":153,"n_cols":8,"rows_kept":153,"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 538,01 € bis 2.000,00 €"}]
[null,null,"(§ 20 Abs.2 und Abs. 2a SGB IV, § 344 Abs.4 SGB III, § 226 Abs.4 SGB V, § 163 Abs. 7 SGB VI, § 58 Abs.5 SGB XI)"]
[]
[null,null,{"$f":"\"Beitragszeitraum: 01.01.\" & Zeitraum & \" - 31.12.\" & Zeitraum","v":"Beitragszeitraum: 01.01.2024 - 31.12.2024"}]
[null,null,"monatliches Arbeitsentgelt",{"$f":"\"Beitragsbemes-sungsgrundlage bei: \"&Steuerung!C7&\" %\"","v":"Beitragsbemes-sungsgrundlage bei: 40,9 %"},"Beitragspflichtige Einnahme Arbeitnehmer","monatliches Arbeitsentgelt",{"$f":"D6","v":"Beitragsbemes-sungsgrundlage bei: 40,9 %"},"Beitragspflichtige Einnahme Arbeitnehmer"]
[null,null,{"$f":"UGrenz+0.01","v":538.01},{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (C7 - UGrenz), 2)","v":368.33},{"$f":"ROUND((OGrenz / (OGrenz - UGrenz)) * (C7 - UGrenz), 2)","v":0.01},{"$f":"C61+5","v":810},{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F7 - UGrenz), 2)","v":671.88},{"$f":"ROUND((OGrenz / (OGrenz - UGrenz)) * (F7 - UGrenz), 2)","v":372.09}]
[null,null,{"$f":"UGrenz+2","v":540},370.55,2.74,{"$f":"F7+5","v":815},677.46,378.93]
[null,null,{"$f":"C8+5","v":545},376.13,9.58,{"$f":"F8+5","v":820},683.04,385.77]
[null,null,550,381.71,16.420000000000002,825,688.63,392.61]
[null,null,555,387.29,23.26,830,694.21,399.45]
[null,null,560,392.87,30.1,835,699.79,406.29]
[null,null,565,398.45,36.94,840,705.37,413.13]
[null,null,570,404.03,43.78,845,710.95,419.97]
[null,null,575,409.61,50.62,850,716.53,426.81]
[null,null,580,415.19,57.46,855,722.11,433.65]
[null,null,585,420.77,64.3,860,727.69,440.49]
[null,null,590,426.35,71.14,865,733.27,447.33]
[null,null,595,431.93,77.98,870,738.85,454.17]
[null,null,600,437.51,84.82,875,744.43,461.01]
[null,null,605,443.09,91.66,880,750.01,467.85]
[null,null,610,448.67,98.5,885,755.59,474.69]
[null,null,{"$f":"C22+5","v":615},454.25,105.34,890,761.17,481.53]
[null,null,620,459.83,112.18,895,766.75,488.37]
[null,null,625,465.41,119.02,900,772.33,495.21]
[null,null,630,470.99,125.85,905,777.91,502.05]
[null,null,635,476.57,132.69,910,783.49,508.89]
[null,null,640,482.15,139.53,915,789.07,515.73]
[null,null,645,487.73,146.37,920,794.65,522.57000000000005]
[null,null,{"$f":"C29+5","v":650},493.31,153.21,925,800.23,529.41]
[null,null,655,498.89,160.05000000000001,930,805.81,536.25]
[null,null,660,504.47,166.89,935,811.39,543.09]
[null,null,665,510.05,173.73,940,816.97,549.92999999999995]
[null,null,670,515.64,180.57,945,822.55,556.77]
[null,null,675,521.22,187.41,950,828.13,563.61]
[null,null,680,526.79999999999995,194.25,955,833.71,570.45000000000005]
[null,null,685,532.38,201.09,960,839.29,577.29]
[null,null,690,537.96,207.93,965,844.87,584.13]
[null,null,695,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (C39 - UGrenz), 2)","v":543.54},{"$f":"ROUND((OGrenz / (OGrenz - UGrenz)) * (C39 - UGrenz), 2)","v":214.77},970,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F39 - UGrenz), 2)","v":850.45},{"$f":"ROUND((OGrenz / (OGrenz - UGrenz)) * (F39 - UGrenz), 2)","v":590.97}]
[null,null,700,549.12,221.61,975,856.03,597.80999999999995]
[null,null,705,554.70000000000005,228.45,980,861.61,604.65]
[null,null,710,560.28,235.29,985,867.2,611.49]
[null,null,715,565.86,242.13,990,872.78,618.33000000000004]
[null,null,720,571.44000000000005,248.97,995,878.36,625.16999999999996]
[null,null,725,577.02,255.81,1000,883.94,632.01]
[null,null,{"$f":"C45+5","v":730},582.6,262.64999999999998,1005,889.52,638.85]
[null,null,{"$f":"C46+5","v":735},588.17999999999995,269.49,1010,895.1,645.69000000000005]
[null,null,740,593.76,276.33,1015,900.68,652.53]
[null,null,745,599.34,283.17,1020,906.26,659.37]
[null,null,750,604.91999999999996,290.01,1025,911.84,666.21]
[null,null,755,610.5,296.85000000000002,1030,917.42,673.05]
[null,null,760,616.08000000000004,303.69,1035,923,679.89]
[null,null,765,621.66,310.52999999999997,1040,928.58,686.73]
[null,null,770,627.24,317.37,1045,934.16,693.57]
[null,null,775,632.82000000000005,324.20999999999998,1050,939.74,700.41]
[null,null,780,638.4,331.05,1055,945.32,707.25]
[null,null,785,643.98,337.89,1060,950.9,714.09]
[null,null,790,649.55999999999995,344.73,1065,956.48,720.93]
[null,null,795,655.14,351.57,1070,962.06,727.77]
[null,null,800,660.72,358.41,1075,967.64,734.61]
[null,null,805,666.3,365.25,1080,973.22,741.45]
[null,null,{"$f":"F61+5","v":1085},978.8,748.29,{"$f":"C114+5","v":1350},1274.56,1110.81]
[null,null,1090,984.38,755.13,1355,1280.1400000000001,1117.6500000000001]
[null,null,1095,989.96,761.97,1360,1285.72,1124.49]
[null,null,1100,995.54,768.81,{"$f":"IF(F64+5<=OGrenz,F64+5,\"\")","v":1365},1291.3,1131.33]
[null,null,1105,1001.12,775.65,{"$f":"IF(F65+5<=OGrenz,F65+5,\"\")","v":1370},1296.8800000000001,1138.17]
[null,null,1110,1006.7,782.49,{"$f":"IF(F66+5<=OGrenz,F66+5,\"\")","v":1375},1302.46,1145.01]
[null,null,1115,1012.28,789.33,{"$f":"IF(F67+5<=OGrenz,F67+5,\"\")","v":1380},1308.04,1151.8499999999999]
[null,null,1120,1017.86,796.17,{"$f":"IF(F68+5<=OGrenz,F68+5,\"\")","v":1385},1313.62,1158.69]
[null,null,1125,1023.44,803.01,{"$f":"IFERROR(IF(F69+5<=OGrenz,F69+5,\"\"),\"\")","v":1390},1319.2,1165.53]
[null,null,1130,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (C71 - UGrenz), 2)","v":1029.02},{"$f":"ROUND((OGrenz / (OGrenz - UGrenz)) * (C71 - UGrenz), 2)","v":809.85},1395,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F71 - UGrenz), 2)","v":1324.78},{"$f":"ROUND((OGrenz / (OGrenz - UGrenz)) * (F71 - UGrenz), 2)","v":1172.3699999999999}]
[null,null,1135,1034.5999999999999,816.69,1400,1330.36,1179.21]
[null,null,1140,1040.19,823.53,1405,1335.94,1186.05]
[null,null,1145,1045.77,830.37,1410,1341.52,1192.8900000000001]
[null,null,1150,1051.3499999999999,837.21,1415,1347.1,1199.73]
[null,null,1155,1056.93,844.05,1420,1352.68,1206.57]
[null,null,1160,1062.51,850.89,1425,1358.26,1213.4100000000001]
[null,null,1165,1068.0899999999999,857.73,1430,1363.84,1220.25]
[null,null,1170,1073.67,864.57,1435,1369.42,1227.0899999999999]
[null,null,1175,1079.25,871.41,1440,1375,1233.93]
[null,null,1180,1084.83,878.25,1445,1380.58,1240.77]
[null,null,1185,1090.4100000000001,885.09,1450,1386.16,1247.6099999999999]
[null,null,1190,1095.99,891.93,1455,1391.75,1254.45]
[null,null,1195,1101.57,898.77,1460,1397.33,1261.29]
[null,null,1200,1107.1500000000001,905.61,1465,1402.91,1268.1300000000001]
[null,null,1205,1112.73,912.45,1470,1408.49,1274.97]
[null,null,1210,1118.31,919.29,1475,1414.07,1281.81]
[null,null,1215,1123.8900000000001,926.13,1480,1419.65,1288.6500000000001]
[null,null,1220,1129.47,932.97,1485,1425.23,1295.49]
[null,null,1225,1135.05,939.81,1490,1430.81,1302.33]
[null,null,1230,1140.6300000000001,946.65,1495,1436.39,1309.17]
[null,null,1235,1146.21,953.49,1500,1441.97,1316.01]
[null,null,1240,1151.79,960.33,1505,1447.55,1322.85]
[null,null,1245,1157.3699999999999,967.17,1510,1453.13,1329.69]
[null,null,1250,1162.95,974.01,1515,1458.71,1336.53]
[null,null,1255,1168.53,980.85,1520,1464.29,1343.37]
[null,null,1260,1174.1099999999999,987.69,1525,1469.87,1350.21]
[null,null,1265,1179.69,994.53,1530,1475.45,1357.05]
[null,null,1270,1185.27,1001.37,1535,1481.03,1363.89]
[null,null,1275,1190.8499999999999,1008.21,1540,1486.61,1370.73]
[null,null,1280,1196.43,1015.05,1545,1492.19,1377.56]
[null,null,1285,1202.01,1021.89,1550,1497.77,1384.4]
[null,null,1290,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (C103 - UGrenz), 2)","v":1207.5899999999999},{"$f":"ROUND((OGrenz / (OGrenz - UGrenz)) * (C103 - UGrenz), 2)","v":1028.73},1555,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F103 - UGrenz), 2)","v":1503.35},{"$f":"ROUND((OGrenz / (OGrenz - UGrenz)) * (F103 - UGrenz), 2)","v":1391.24}]
[null,null,1295,1213.18,1035.57,1560,1508.93,1398.08]
[null,null,1300,1218.76,1042.4100000000001,1565,1514.51,1404.92]
[null,null,1305,1224.3399999999999,1049.25,1570,1520.09,1411.76]
[null,null,1310,1229.92,1056.0899999999999,1575,1525.67,1418.6]
[null,null,1315,1235.5,1062.93,1580,1531.25,1425.44]
[null,null,1320,1241.08,1069.77,1585,1536.83,1432.28]
[null,null,1325,1246.6600000000001,1076.6099999999999,1590,1542.41,1439.12]
[null,null,{"$f":"C110+5","v":1330},1252.24,1083.45,1595,1547.99,1445.96]
[null,null,{"$f":"C111+5","v":1335},1257.82,1090.29,1600,1553.57,1452.8]
[null,null,{"$f":"C112+5","v":1340},1263.4000000000001,1097.1300000000001,1605,1559.15,1459.64]
[null,null,{"$f":"C113+5","v":1345},1268.98,1103.97,1610,1564.74,1466.48]
[null,null,{"$f":"F114+5","v":1615},1570.32,{"$f":"ROUND((OGrenz / (OGrenz - UGrenz)) * (C115 - UGrenz), 2)","v":1473.32},{"$f":"C153+5","v":1810},1787.95,1740.08]
[null,null,{"$f":"C115+5","v":1620},1575.9,{"$f":"ROUND((OGrenz / (OGrenz - UGrenz)) * (C116 - UGrenz), 2)","v":1480.16},{"$f":"F115+5","v":1815},1793.53,1746.92]
[null,null,{"$f":"C116+5","v":1625},1581.48,1487,{"$f":"F116+5","v":1820},1799.11,1753.76]
[null,null,1630,1587.06,1493.84,1825,1804.69,1760.6]
[null,null,1635,1592.64,1500.68,1830,1810.27,1767.44]
[null,null,1640,1598.22,1507.52,1835,1815.85,1774.28]
[null,null,1645,1603.8,1514.36,1840,1821.43,1781.12]
[null,null,1650,1609.38,1521.2,1845,1827.01,1787.96]
[null,null,1655,1614.96,1528.04,1850,1832.59,1794.8]
[null,null,1660,1620.54,1534.88,1855,1838.17,1801.64]
[null,null,1665,1626.12,1541.72,1860,1843.75,1808.48]
[null,null,1670,1631.7,1548.56,1865,1849.33,1815.32]
[null,null,1675,1637.28,1555.4,1870,1854.91,1822.16]
[null,null,1680,1642.86,1562.24,1875,1860.49,1829]
[null,null,1685,1648.44,1569.08,1880,1866.07,1835.84]
[null,null,1690,1654.02,1575.92,1885,1871.65,1842.68]
[null,null,1695,1659.6,1582.76,1890,1877.23,1849.52]
[null,null,1700,1665.18,1589.6,1895,1882.81,1856.36]
[null,null,1705,1670.76,1596.44,1900,1888.39,1863.2]
[null,null,1710,1676.34,1603.28,1905,1893.97,1870.04]
[null,null,1715,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (C135 - UGrenz), 2)","v":1681.92},1610.12,1910,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F135 - UGrenz), 2)","v":1899.55},1876.88]
[null,null,1720,1687.5,1616.96,1915,1905.13,1883.72]
[null,null,1725,1693.08,1623.8,1920,1910.71,1890.56]
[null,null,1730,1698.66,1630.64,1925,1916.3,1897.4]
[null,null,1735,1704.24,{"$f":"ROUND((OGrenz / (OGrenz - UGrenz)) * (C139 - UGrenz), 2)","v":1637.48},1930,1921.88,1904.24]
[null,null,{"$f":"C139+5","v":1740},1709.82,1644.32,1935,1927.46,1911.08]
[null,null,1745,1715.4,1651.16,1940,1933.04,1917.92]
[null,null,1750,1720.98,1658,1945,1938.62,1924.76]
[null,null,1755,1726.56,1664.84,1950,1944.2,1931.6]
[null,null,1760,1732.14,1671.68,1955,1949.78,1938.44]
[null,null,1765,1737.73,1678.52,1960,1955.36,1945.28]
[null,null,1770,1743.31,1685.36,1965,1960.94,1952.12]
[null,null,1775,1748.89,1692.2,1970,1966.52,1958.96]
[null,null,1780,1754.47,1699.04,1975,1972.1,1965.8]
[null,null,1785,1760.05,1705.88,1980,1977.68,1972.64]
[null,null,1790,1765.63,1712.72,1985,1983.26,1979.48]
[null,null,1795,1771.21,1719.56,1990,1988.84,1986.32]
[null,null,1800,1776.79,1726.4,1995,1994.42,1993.16]
[null,null,1805,1782.37,1733.24,2000,2000,2000]

{"sheet":"Steuerung","index":3,"n_rows":101,"n_cols":12,"rows_kept":101,"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":2024}]
["Beitragszeitraum",1,{"$f":"IFERROR(VLOOKUP(B3,Jahr,D3,0),\"Fehler\")","v":2024},{"$f":"SUMIF(Listen!$F$19:$U$20,A3,Listen!$F$20:$U$20)","v":2},null,"F","FÜ"]
["Untergrenze",{"$f":"B2","v":1},{"$f":"IF(B6,G4,F4)","v":538},{"$f":"SUMIF(Listen!$F$19:$U$20,A4,Listen!$F$20:$U$20)","v":11},null,{"$f":"VLOOKUP($B4,Jahr,$D4,0)","v":538},450]
["Obergrenze",{"$f":"B2","v":1},{"$f":"IF(B6,G5,F5)","v":2000},{"$f":"SUMIF(Listen!$F$19:$U$20,A5,Listen!$F$20:$U$20)","v":12},null,{"$f":"VLOOKUP($B5,Jahr,$D5,0)","v":2000},1300]
["Faktor",false,{"$f":"ROUND(IF(B6,G6/C7,F6/C7),4)","v":0.68459999999999999},null,null,28,30]
["Summe SV",{"$f":"B2","v":1},{"$f":"VLOOKUP(B7,Jahr,D7,0)","v":40.9},{"$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.6,{"$f":"SUMIF(Listen!$F$19:$U$20,A10,Listen!$F$20:$U$20)","v":6}]
["PV",{"$f":"B2","v":1},3.4,{"$f":"SUMIF(Listen!$F$19:$U$20,A11,Listen!$F$20:$U$20)","v":7}]
["Zusatz KV",{"$f":"B2","v":1},1.7,{"$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",1,{"$f":"IFERROR(VLOOKUP(B16,KV,2,0)*100,D16)","v":0},0.4,"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.2E-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":2.1999999999999999E-2},{"$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},null,"PV_Abschlag",2]
["U1 - Krankheitsfall",false,0,null,null,"PV_Abschlagshöhe","",{"$f":"IF(BS_PV_Ab=\"\",0,BS_PV_Ab)","v":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"]
["PV Sachsen",false]
["Frei RV",false]
["RV nur AG",false]
["RV Knappsch. ",false]
["nur  AV",0]
["Frei AV",false]
["Frei AV_AN",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":"S2_O1_O2_Zusatz"},{"$f":"SUM(C62:C70)","v":2}]
["Auswahl KV",null,{"$f":"SUM(C73:C75)","v":12}]
["Auswahl PV",null,{"$f":"SUM(C78:C80)","v":20}]
["Auswahl RV",null,{"$f":"SUM(C83:C87)","v":30}]
["Auswahl AV",null,{"$f":"SUM(C90:C92)","v":40}]
["PV Kinderzuschlag",{"$f":"IF(AND(S_KV_PV_frei<>TRUE,S_PV_Zu=1),TRUE)","v":false},{"$f":"IF(B46,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(B49),VALUE(B50))","v":0}]
["S2_O1_O2_Zusatz",{"$f":"IF(S_Sonder_2_Opt=2,\"/ \"&VALUE(B51)&\" 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(B62,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(B63,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(B64,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(B65,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(B66,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(B67,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(B68,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(B69,8,\"\")","v":""},null,8,"unter UnterGrenze und Teilmonat",null,"W","W","F","F"]
[null,null,{"$f":"SUM(C62:C69)","v":1},null,0,"nicht zulässig"]
[]
[]
["KV ohne Sonder",{"$f":"IF(S_KV_PV_frei<>TRUE,TRUE)","v":true},{"$f":"IF(B73,10,\"\")","v":10}]
["KV frei",{"$f":"IF(S_KV_PV_frei=TRUE,TRUE)","v":false},{"$f":"IF(B74,11,\"\")","v":""}]
["KV allg / ermäßigt",{"$f":"IF((S_KV_PV_frei<>TRUE),TRUE)","v":true},{"$f":"IF(B75,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(B78,20,\"\")","v":20}]
["PV frei",{"$f":"IF(S_KV_PV_frei=TRUE,TRUE)","v":false},{"$f":"IF(B79,21,\"\")","v":""}]
["PV Sachsen",{"$f":"IF(AND(S_KV_PV_frei<>TRUE,S_PV_Sachsen=TRUE),TRUE)","v":false},{"$f":"IF(B80,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(B83,30,\"\")","v":30}]
["RV frei",{"$f":"IF(S_RV_frei=TRUE,TRUE)","v":false},{"$f":"IF(B84,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(B85,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(B86,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(B87,34,\"\")","v":""}]
[]
[]
["AV ohne Sonder",{"$f":"IF(AND(S_AV_frei<>TRUE,S_AV_frei_AN<>TRUE),TRUE)","v":true},{"$f":"IF(B90,40,\"\")","v":40}]
["AV frei",{"$f":"IF(S_AV_frei=TRUE,TRUE)","v":false},{"$f":"IF(B91,41,\"\")","v":""},null,null,1200,18.600000000000001,{"$f":"F91*G91/100","v":223.2},{"$f":"H91/2","v":111.6}]
["Frei AV_AN",{"$f":"IF(S_AV_frei_AN=TRUE,TRUE)","v":false},{"$f":"IF(B92,42,\"\")","v":""},null,null,384.54,24.7,{"$f":"F92*G92/100","v":94.981380000000001},{"$f":"H92/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":"G97*G99","v":94.981380000000001},{"$f":"G97*G99*G100","v":189.96276},{"$f":"G98*G99","v":128.44},{"$f":"I101-J101","v":61.522760000000005},{"$f":"H101-K101","v":33.458619999999996}]

{"sheet":"Listen","index":4,"n_rows":112,"n_cols":46,"rows_kept":112,"cut":false,"hidden":true,"merged":[[1,1,1,2]]}
[null,"Stand: ","2023-12-21",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,"Mindest lohn","x 130","Gerinfügig keits grenze",null,"SUCH","SFall-Nr","Zeile","Spalte","Text","SFall",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,null,null,null,null,null,null,null,"n_W5_Bez","=Dialog!$D$5",{"$f":"MID(AQ2,2,FIND(\"!\",AQ2,1)-2)","v":"Dialog"},{"$f":"MID(AQ2,FIND(\"!\",AQ2,1)+2,FIND(\"$\",AQ2,FIND(\"!\",AQ2,1)+2)-FIND(\"!\",AQ2,1)-2)","v":"D"},{"$f":"VALUE(MID(AQ2,FIND(\"$\",AQ2,FIND(\"!\",AQ2,1)+2)+1,5))","v":5}]
[null,1,0,null,null,1,2024,{"$f":"I3+J3+K3+L3+N3","v":40.9},1.7,18.600000000000001,2.6,3.4,24.7,14.6,14,{"$f":"Y3","v":538},2000,1.2E-2,2.1999999999999999E-2,5.9999999999999995E-4,0.6,null,12.41,{"$f":"130*W3","v":1613.3},{"$f":"ROUNDUP(X3/3,0)","v":538},null,107,1,7,4,"Übergangsbereichsentgelt:","ohne Sonderfall",null,null,null,null,null,null,null,null,null,"n_W5","=Dialog!$E$5","Dialog","E",5]
[null,2,"manuelle Eingabe",null,null,{"$f":"F3+1","v":2},2023,{"$f":"I4+J4+K4+L4+N4","v":40.800000000000004},1.6,18.600000000000001,2.6,3.4,24.7,14.6,14,520,2000,1.2E-2,2.1999999999999999E-2,5.9999999999999995E-4,0.6,null,null,null,null,null,109,1,9,4,"BE Arbeitnehmer: ","ohne Sonderfall",null,null,null,null,null,null,null,null,null,"KV_Text","=Dialog!$G$5","Dialog","G",5]
[null,3,8.3999999999999995E-3,null,null,3,2022,{"$f":"I5+J5+K5+L5+N5","v":39.950000000000003},1.3,18.600000000000001,2.4,3.05,24.7,14.6,14,520,1600,1.025E-2,2.0250000000000001E-2,8.9999999999999998E-4,0.35,null,null,null,null,null,205,2,5,4,"Arbeitsentgelt für diese Tätigkeit","Mehrfachbeschäftigung",null,null,null,null,null,null,null,null,null,"S_Sonder_2_Stunden_Bez","=Dialog!$K$5","Dialog","K",5]
[null,4,8.9999999999999993E-3,null,null,4,2021,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,"Beitragsabschlag PV",null,null,null,207,2,7,4,"Übergangsbereichsentgelt für diese Tätigkeit:","Mehrfachbeschäftigung",null,null,null,null,null,null,null,null,null,"S_Sonder_2_Tage_Bez","=Dialog!$K$5","Dialog","K",5]
[null,5,9.7999999999999997E-3,null,null,5,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,209,2,9,4,"BE Arbeitnehmer für diese Tätigkeit: ","Mehrfachbeschäftigung",null,null,null,null,null,null,null,null,null,"S_Sonder_2_Stunden","=Dialog!$L$5","Dialog","L",5]
[null,6,0.01,null,null,6,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,1,0.25,null,null,221,2,21,11,"gesamtes monatliches Arbeitsentgelt:","Mehrfachbeschäftigung",null,null,null,null,null,null,null,null,null,"S_Sonder_2_Tage","=Dialog!$L$5","Dialog","L",5]
[null,7,1.09E-2,null,null,7,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,2,0.5,null,null,222,2,22,11,"gesamtes monatliches Übergangsbereichsentgelt:","Mehrfachbeschäftigung",null,null,null,null,null,null,null,null,null,"n_W7_Bez","=Dialog!$D$7","Dialog","D",7]
[null,8,1.0999999999999999E-2,null,null,8,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,3,0.75,null,null,{"$f":"AB10*100+AC10","v":305},3,5,4,"Teilmonatsentgelt:","teilmonatl. Arbeitsentgelt",null,null,null,null,null,null,null,null,null,"n_W7","=Dialog!$E$7","Dialog","E",7]
[null,9,1.15E-2,null,null,9,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,4,1,null,null,307,3,7,4,"Teil-Übergangsbereichsentgelt:","teilmonatl. Arbeitsentgelt",null,null,null,null,null,null,null,null,null,"RV_Text","=Dialog!$G$7","Dialog","G",7]
[null,10,1.2E-2,null,null,10,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,"Teil-BE Arbeitnehmer: ","teilmonatl. Arbeitsentgelt",null,null,null,null,null,null,null,null,null,"S_Sonder_2_WoStunden_Bez","=Dialog!$K$7","Dialog","K",7]
[null,11,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,321,3,21,11,"fiktives monatliches Arbeitsentgelt:","teilmonatl. Arbeitsentgelt",null,null,null,null,null,null,null,null,null,"S_Sonder_2_WoStunden","=Dialog!$L$7","Dialog","L",7]
[null,12,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,322,3,22,11,"fiktives monatliches Übergangsbereichsentgelt:","teilmonatl. Arbeitsentgelt",null,null,null,null,null,null,null,null,null,"n_W9_Bez","=Dialog!$D$9","Dialog","D",9]
[null,13,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,405,4,5,4,"Arbeitsentgelt gesamt:","monatliches Arbeitsentgelt plus Einmalzahlung",null,null,null,null,null,null,null,null,null,"n_W9","=Dialog!$E$9","Dialog","E",9]
[null,14,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,407,4,7,4,"Übergangsbereichsentgelt gesamt:","monatliches Arbeitsentgelt plus Einmalzahlung",null,null,null,null,null,null,null,null,null,"AV_Text","=Dialog!$G$9","Dialog","G",9]
[null,15,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,{"$f":"AB17*100+AC17","v":409},4,9,4,"BE Arbeitnehmer gesamt: ","monatliches Arbeitsentgelt plus Einmalzahlung",null,null,null,null,null,null,null,null,null,"n_W11_Bez","=Dialog!$D$11","Dialog","D",11]
[null,16,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,{"$f":"AB18*100+AC18","v":421},4,21,11,"monatliches Arbeitsentgelt:","monatliches Arbeitsentgelt plus Einmalzahlung",null,null,null,null,null,null,null,null,null,"n_W11","=Dialog!$E$11","Dialog","E",11]
[null,17,1.4500000000000001E-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,{"$f":"AB19*100+AC19","v":422},4,22,11,"Einmalzahlung","monatliches Arbeitsentgelt plus Einmalzahlung",null,null,null,null,null,null,null,null,null,"PV_Text","=Dialog!$G$11","Dialog","G",11]
[null,18,1.4800000000000001E-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,505,5,5,4,"Arbeitsentgelt für das zu bewertende BV:","Mehrfachbeschäftigung mit teilmonatl. Arbeitsentgelt",null,null,null,null,null,null,null,null,null,"S_Sonder_2_Stunden_B_Bez","=Dialog!$K$11","Dialog","K",11]
[null,19,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,507,5,7,4,"Übergangsbereichsentgelt für dieses BV:","Mehrfachbeschäftigung mit teilmonatl. Arbeitsentgelt",null,null,null,null,null,null,null,null,null,"S_Sonder_2_Stunden_B","=Dialog!$L$11","Dialog","L",11]
[null,20,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,{"$f":"AB22*100+AC22","v":509},5,9,4,"BE Arbeitnehmer für dieses BV:","Mehrfachbeschäftigung mit teilmonatl. Arbeitsentgelt",null,null,null,null,null,null,null,null,null,"n_W13_Bez","=Dialog!$D$13","Dialog","D",13]
[null,21,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,{"$f":"AB23*100+AC23","v":521},5,21,11,"gesamtes monatliches Übergangsbereichsentgelt:","Mehrfachbeschäftigung mit teilmonatl. Arbeitsentgelt",null,null,null,null,null,null,null,null,null,"n_W13","=Dialog!$E$13","Dialog","E",13]
[null,22,1.55E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB24*100+AC24","v":522},5,22,11,"gesamtes fiktives Arbeitsentgelt:","Mehrfachbeschäftigung mit teilmonatl. Arbeitsentgelt",null,null,null,null,null,null,null,null,null,"S_Text","=Dialog!$G$13","Dialog","G",13]
[null,23,1.5800000000000002E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB25*100+AC25","v":523},5,23,11,"gesamtes fiktives Übergangsbereichsentgelt:","Mehrfachbeschäftigung mit teilmonatl. Arbeitsentgelt",null,null,null,null,null,null,null,null,null,"S_Sonder_2_WoStunden_Bez_B","=Dialog!$K$13","Dialog","K",13]
[null,24,1.5900000000000001E-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,null,null,null,null,null,null,null,"S_Sonder_2_WoStunden_B","=Dialog!$L$13","Dialog","L",13]
[null,25,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,607,6,7,4,"Übergangsbereichsentgelt gesamt:","teilmonatl. Arbeitsentgelt plus Einmalzahlung",null,null,null,null,null,null,null,null,null,"n_W14_Bez","=Dialog!$D$14","Dialog","D",14]
[null,26,1.6500000000000001E-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,"BE Arbeitnehmer gesamt: ","teilmonatl. Arbeitsentgelt plus Einmalzahlung",null,null,null,null,null,null,null,null,null,"n_W14","=Dialog!$E$14","Dialog","E",14]
[null,27,1.6899999999999998E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,621,6,21,11,"fiktives monatliches Arbeitsentgelt:","teilmonatl. Arbeitsentgelt plus Einmalzahlung",null,null,null,null,null,null,null,null,null,"nKV_ges","=Dialog!$C$18","Dialog","C",18]
[null,28,1.7000000000000001E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,622,6,22,11,"fiktives monatliches Arbeitsentgelt gesamt:","teilmonatl. Arbeitsentgelt plus Einmalzahlung",null,null,null,null,null,null,null,null,null,"nKV_AG","=Dialog!$E$18","Dialog","E",18]
[null,29,1.7500000000000002E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,623,6,23,11,"Teilmonatsentgelt:","teilmonatl. Arbeitsentgelt plus Einmalzahlung",null,null,null,null,null,null,null,null,null,"nKV_AN","=Dialog!$G$18","Dialog","G",18]
[null,30,1.77E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,624,6,24,11,"Einmalzahlung:","teilmonatl. Arbeitsentgelt plus Einmalzahlung",null,null,null,null,null,null,null,null,null,"nKV_Satz","=Dialog!$I$18","Dialog","I",18]
[null,31,1.7999999999999999E-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,null,null,null,null,null,null,null,"nKV_Zu_ges","=Dialog!$C$26","Dialog","C",20]
[null,32,1.8499999999999999E-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,null,null,null,null,null,null,null,"nKV_Zu_AG","=Dialog!$E$26",{"$f":"MID(AQ34,2,FIND(\"!\",AQ34,1)-2)","v":"Dialog"},{"$f":"MID(AQ34,FIND(\"!\",AQ34,1)+2,FIND(\"$\",AQ34,FIND(\"!\",AQ34,1)+2)-FIND(\"!\",AQ34,1)-2)","v":"E"},20]
[null,33,1.89E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,709,7,9,4,"BE Arbeitnehmer: ","monatl. Arbeitseinkommen kleiner Untergrenze",null,null,null,null,null,null,null,null,null,"nKV_Zu_AN","=Dialog!$G$26","Dialog","G",20]
[null,34,1.9E-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,null,null,null,null,null,null,null,"nKV_Zu_Satz","=Dialog!$I$26","Dialog","I",20]
[null,35,1.9800000000000002E-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,null,null,null,null,null,null,null,"nRV_ges","=Dialog!$C$20","Dialog","C",22]
[null,36,1.9900000000000001E-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,"Teil-BE Arbeitnehmer: ","monatl. Arbeitseinkommen kleiner Untergrenze und mit teilmonatl. Arbeitsentgelt",null,null,null,null,null,null,null,null,null,"nRV_AG","=Dialog!$E$20","Dialog","E",22]
[null,37,0.02,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,21,11,"fiktives monatliches Arbeitsentgelt:","monatl. Arbeitseinkommen kleiner Untergrenze und mit teilmonatl. Arbeitsentgelt",null,null,null,null,null,null,null,null,null,"nRV_AN","=Dialog!$G$20","Dialog","G",22]
[null,38,2.1899999999999999E-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,22,11,"fiktives monatliches Übergangsbereichsentgelt:","monatl. Arbeitseinkommen kleiner Untergrenze und mit teilmonatl. Arbeitsentgelt",null,null,null,null,null,null,null,null,null,"nRV_Satz","=Dialog!$I$20","Dialog","I",22]
[null,39,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,914,9,24,11,"Beitragsbemessungsgrundlage für RV:","-",null,null,null,null,null,null,null,null,null,"nAV_ges","=Dialog!$C$22","Dialog","C",24]
[null,40,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,3214,32,14,null,"Beitragsbemessungsgrundlage für RV:","RV-Beitrag aus tatsächlichem Arbeitsentgelt",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,3214,32,14,null,"Beitragsbemessungsgrundlage für RV:","RV-Beitrag aus tatsächlichem Arbeitsentgelt",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,3414,34,14,null,"Beitragsbemessungsgrundlage für RV:","knappschaftl. RV-Beitrag aus tats. Arbeitsentgelt",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,3414,34,14,null,"Beitragsbemessungsgrundlage für RV:","knappschaftl. RV-Beitrag aus tats. Arbeitsentgelt",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,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,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,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,null,null,null,null,null,null,null,"nPV_Zu_ges","=Dialog!$C$28","Dialog","C",{"$f":"VALUE(MID(AQ49,FIND(\"$\",AQ49,FIND(\"!\",AQ49,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,null,null,null,null,null,null,null,"Jahr","=Listen!$F$3:$U$6",{"$f":"MID(AQ66,2,FIND(\"!\",AQ66,1)-2)","v":"Listen"},{"$f":"MID(AQ66,FIND(\"!\",AQ66,1)+2,FIND(\"$\",AQ66,FIND(\"!\",AQ66,1)+2)-FIND(\"!\",AQ66,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,null,null,null,null,null,null,null,"BS_KV_Zu","=Steuerung!$C$16","Steuerung","C",{"$f":"VALUE(MID(AQ81,FIND(\"$\",AQ81,FIND(\"!\",AQ81,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,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,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,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,null,null,null,null,null,null,null,"nPV_Sachsen_AN_Jahr","=Steuerung!$C$19",{"$f":"MID(AQ85,2,FIND(\"!\",AQ85,1)-2)","v":"Steuerung"},{"$f":"MID(AQ85,FIND(\"!\",AQ85,1)+2,FIND(\"$\",AQ85,FIND(\"!\",AQ85,1)+2)-FIND(\"!\",AQ85,1)-2)","v":"C"},{"$f":"VALUE(MID(AQ85,FIND(\"$\",AQ85,FIND(\"!\",AQ85,1)+2)+1,5))","v":19}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,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,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,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,null,null,null,null,null,null,null,"S_U2_Satz","=Steuerung!$C$22","Steuerung","C",22]
[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,null,null,null,null,null,null,null,"S_U3","=Steuerung!$B$23","Steuerung","B",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,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,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,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,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,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,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,null,null,null,null,null,null,null,"S_AV_nur","=Steuerung!$B$30",{"$f":"MID(AQ99,2,FIND(\"!\",AQ99,1)-2)","v":"Steuerung"},{"$f":"MID(AQ99,FIND(\"!\",AQ99,1)+2,FIND(\"$\",AQ99,FIND(\"!\",AQ99,1)+2)-FIND(\"!\",AQ99,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,null,null,null,null,null,null,null,"S_AV_frei","=Steuerung!$B$31",{"$f":"MID(AQ100,2,FIND(\"!\",AQ100,1)-2)","v":"Steuerung"},{"$f":"MID(AQ100,FIND(\"!\",AQ100,1)+2,FIND(\"$\",AQ100,FIND(\"!\",AQ100,1)+2)-FIND(\"!\",AQ100,1)-2)","v":"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,null,null,null,null,null,null,null,"S_SGB_III","=Steuerung!$B$32",{"$f":"MID(AQ101,2,FIND(\"!\",AQ101,1)-2)","v":"Steuerung"},{"$f":"MID(AQ101,FIND(\"!\",AQ101,1)+2,FIND(\"$\",AQ101,FIND(\"!\",AQ101,1)+2)-FIND(\"!\",AQ101,1)-2)","v":"B"},{"$f":"VALUE(MID(AQ101,FIND(\"$\",AQ101,FIND(\"!\",AQ101,1)+2)+1,5))","v":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,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,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,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,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,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,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,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,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,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,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,null,null,null,null,null,null,null,"S_Sonder_aktuell","=Steuerung!$C$69","Steuerung","C",69]