{"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 (520,01 € bis 2.000,00 €)"}]
[null,{"$f":"\"Beitragszeitraum: 01.07.\" & Zeitraum & \" - 31.12.\"& Zeitraum","v":"Beitragszeitraum: 01.07.2023 - 31.12.2023"}]
[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.40800000000000003}]
[]
[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.6E-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 (520,01 € bis 2.000,00 €)"}]
[null,{"$f":"\"Beitragszeitraum: 01.07.\" & Zeitraum & \" - 31.12.\"& Zeitraum","v":"Beitragszeitraum: 01.07.2023 - 31.12.2023"}]
[]
[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:",891.85,"RV:"]
[]
[null,null,null,"BE Arbeitnehmer: ",648.65,"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:",130.22,"KV:",82.87,"KV:",47.35,"KV:",0.14599999999999999]
[]
[null,{"$f":"IF(S_KV_PV_frei<>TRUE,\"Zusatz KV:\",\"\")","v":"Zusatz KV:"},4.46,{"$f":"B20","v":"Zusatz KV:"},2.84,{"$f":"B20","v":"Zusatz KV:"},1.62,{"$f":"B20","v":"Zusatz KV:"},5.0000000000000001E-3]
[]
[null,"RV:",165.88,"RV:",105.56,"RV:",60.32,"RV:",0.18600000000000003]
[]
[null,"AV:",23.18,"AV:",14.75,"AV:",8.43,"AV:",2.6000000000000002E-2]
[]
[null,"PV:",30.32,"PV:",19.29,"PV:",11.03,"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":354.06},"SV-Gesamt:",{"$f":"SUM(E18:E28)","v":225.31},"SV-Gesamt:",{"$f":"SUM(G18:G28)","v":128.75}]
[]
[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":156,"n_cols":8,"rows_kept":156,"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 520,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.07.2023 - 31.12.2023\"","v":"Beitragszeitraum: 01.07.2023 - 31.12.2023"}]
[null,null,"monatliches Arbeitsentgelt",{"$f":"\"Beitragsbemes-sungsgrundlage bei: \"&Steuerung!C7&\" %\"","v":"Beitragsbemes-sungsgrundlage bei: 40,8 %"},"Beitragspflichtige Einnahme Arbeitnehmer","monatliches Arbeitsentgelt",{"$f":"D6","v":"Beitragsbemes-sungsgrundlage bei: 40,8 %"},"Beitragspflichtige Einnahme Arbeitnehmer"]
[null,null,{"$f":"UGrenz+0.01","v":520.01},{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (C7 - UGrenz), 2)","v":359.96},{"$f":"ROUND((OGrenz / (OGrenz - UGrenz)) * (C7 - UGrenz), 2)","v":0.01},{"$f":"C61+5","v":795},{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F7 - UGrenz), 2)","v":664.68},{"$f":"ROUND((OGrenz / (OGrenz - UGrenz)) * (F7 - UGrenz), 2)","v":371.62}]
[null,null,{"$f":"UGrenz+5","v":525},365.48,6.76,{"$f":"F7+5","v":800},670.22,378.38]
[null,null,{"$f":"C8+5","v":530},371.03,13.51,{"$f":"F8+5","v":805},675.77,385.14]
[null,null,535,376.57,20.27,810,681.31,391.89]
[null,null,540,382.11,27.03,815,686.85,398.65]
[null,null,545,387.65,33.78,820,692.39,405.41]
[null,null,550,393.19,40.54,825,697.93,412.16]
[null,null,555,398.73,47.3,830,703.47,418.92]
[null,null,560,404.27,54.05,835,709.01,425.68]
[null,null,565,409.81,60.81,840,714.55,432.43]
[null,null,570,415.35,67.569999999999993,845,720.09,439.19]
[null,null,575,420.89,74.319999999999993,850,725.63,445.95]
[null,null,580,426.43,81.08,855,731.17,452.7]
[null,null,585,431.97,87.84,860,736.71,459.46]
[null,null,590,437.51,94.59,865,742.25,466.22]
[null,null,595,443.05,101.35,870,747.8,472.97]
[null,null,{"$f":"C22+5","v":600},448.6,108.11,875,753.34,479.73]
[null,null,605,454.14,114.86,880,758.88,486.49]
[null,null,610,459.68,121.62,885,764.42,493.24]
[null,null,615,465.22,128.38,890,769.96,500]
[null,null,620,470.76,135.13999999999999,895,775.5,506.76]
[null,null,625,476.3,141.88999999999999,900,781.04,513.51]
[null,null,630,481.84,148.65,905,786.58,520.27]
[null,null,{"$f":"C29+5","v":635},487.38,155.41,910,792.12,527.03]
[null,null,640,492.92,162.16,915,797.66,533.78]
[null,null,645,498.46,168.92,920,803.2,540.54]
[null,null,650,504,175.68,925,808.74,547.29999999999995]
[null,null,655,509.54,182.43,930,814.28,554.04999999999995]
[null,null,660,515.08000000000004,189.19,935,819.82,560.80999999999995]
[null,null,665,520.63,195.95,940,825.37,567.57000000000005]
[null,null,670,526.16999999999996,202.7,945,830.91,574.32000000000005]
[null,null,675,531.71,209.46,950,836.45,581.08000000000004]
[null,null,680,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (C39 - UGrenz), 2)","v":537.25},{"$f":"ROUND((OGrenz / (OGrenz - UGrenz)) * (C39 - UGrenz), 2)","v":216.22},955,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F39 - UGrenz), 2)","v":841.99},{"$f":"ROUND((OGrenz / (OGrenz - UGrenz)) * (F39 - UGrenz), 2)","v":587.84}]
[null,null,685,542.79,222.97,960,847.53,594.59]
[null,null,690,548.33000000000004,229.73,965,853.07,601.35]
[null,null,695,553.87,236.49,970,858.61,608.11]
[null,null,700,559.41,243.24,975,864.15,614.86]
[null,null,705,564.95000000000005,250,980,869.69,621.62]
[null,null,710,570.49,256.76,985,875.23,628.38]
[null,null,{"$f":"C45+5","v":715},576.03,263.51,990,880.77,635.14]
[null,null,{"$f":"C46+5","v":720},581.57000000000005,270.27,995,886.31,641.89]
[null,null,725,587.11,277.02999999999997,1000,891.85,648.65]
[null,null,730,592.65,283.77999999999997,1005,897.39,655.41]
[null,null,735,598.20000000000005,290.54000000000002,1010,902.94,662.16]
[null,null,740,603.74,297.3,1015,908.48,668.92]
[null,null,745,609.28,304.05,1020,914.02,675.68]
[null,null,750,614.82000000000005,310.81,1025,919.56,682.43]
[null,null,755,620.36,317.57,1030,925.1,689.19]
[null,null,760,625.9,324.32,1035,930.64,695.95]
[null,null,765,631.44000000000005,331.08,1040,936.18,702.7]
[null,null,770,636.98,337.84,1045,941.72,709.46]
[null,null,775,642.52,344.59,1050,947.26,716.22]
[null,null,780,648.05999999999995,351.35,1055,952.8,722.97]
[null,null,785,653.6,358.11,1060,958.34,729.73]
[null,null,790,659.14,364.86,1065,963.88,736.49]
[null,null,{"$f":"F61+5","v":1070},969.42,743.24,{"$f":"C114+5","v":1335},1263.08,1101.3499999999999]
[null,null,1075,974.97,750,1340,1268.6199999999999,1108.1099999999999]
[null,null,1080,980.51,756.76,1345,1274.1600000000001,1114.8599999999999]
[null,null,1085,986.05,763.51,{"$f":"IF(F64+5<=OGrenz,F64+5,\"\")","v":1350},1279.71,1121.6199999999999]
[null,null,1090,991.59,770.27,{"$f":"IF(F65+5<=OGrenz,F65+5,\"\")","v":1355},1285.25,1128.3800000000001]
[null,null,1095,997.13,777.03,{"$f":"IF(F66+5<=OGrenz,F66+5,\"\")","v":1360},1290.79,1135.1400000000001]
[null,null,1100,1002.67,783.78,{"$f":"IF(F67+5<=OGrenz,F67+5,\"\")","v":1365},1296.33,1141.8900000000001]
[null,null,1105,1008.21,790.54,{"$f":"IF(F68+5<=OGrenz,F68+5,\"\")","v":1370},1301.8699999999999,1148.6500000000001]
[null,null,1110,1013.75,797.3,{"$f":"IFERROR(IF(F69+5<=OGrenz,F69+5,\"\"),\"\")","v":1375},1307.4100000000001,1155.4100000000001]
[null,null,1115,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (C71 - UGrenz), 2)","v":1019.29},{"$f":"ROUND((OGrenz / (OGrenz - UGrenz)) * (C71 - UGrenz), 2)","v":804.05},1380,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F71 - UGrenz), 2)","v":1312.95},{"$f":"ROUND((OGrenz / (OGrenz - UGrenz)) * (F71 - UGrenz), 2)","v":1162.1600000000001}]
[null,null,1120,1024.83,810.81,1385,1318.49,1168.92]
[null,null,1125,1030.3699999999999,817.57,1390,1324.03,1175.68]
[null,null,1130,1035.9100000000001,824.32,1395,1329.57,1182.43]
[null,null,1135,1041.45,831.08,1400,1335.11,1189.19]
[null,null,1140,1046.99,837.84,1405,1340.65,1195.95]
[null,null,1145,1052.54,844.59,1410,1346.19,1202.7]
[null,null,1150,1058.08,851.35,1415,1351.73,1209.46]
[null,null,1155,1063.6199999999999,858.11,1420,1357.28,1216.22]
[null,null,1160,1069.1600000000001,864.86,1425,1362.82,1222.97]
[null,null,1165,1074.7,871.62,1430,1368.36,1229.73]
[null,null,1170,1080.24,878.38,1435,1373.9,1236.49]
[null,null,1175,1085.78,885.14,1440,1379.44,1243.24]
[null,null,1180,1091.32,891.89,1445,1384.98,1250]
[null,null,1185,1096.8599999999999,898.65,1450,1390.52,1256.76]
[null,null,1190,1102.4000000000001,905.41,1455,1396.06,1263.51]
[null,null,1195,1107.94,912.16,1460,1401.6,1270.27]
[null,null,1200,1113.48,918.92,1465,1407.14,1277.03]
[null,null,1205,1119.02,925.68,1470,1412.68,1283.78]
[null,null,1210,1124.56,932.43,1475,1418.22,1290.54]
[null,null,1215,1130.1099999999999,939.19,1480,1423.76,1297.3]
[null,null,1220,1135.6500000000001,945.95,1485,1429.3,1304.05]
[null,null,1225,1141.19,952.7,1490,1434.85,1310.81]
[null,null,1230,1146.73,959.46,1495,1440.39,1317.57]
[null,null,1235,1152.27,966.22,1500,1445.93,1324.32]
[null,null,1240,1157.81,972.97,1505,1451.47,1331.08]
[null,null,1245,1163.3499999999999,979.73,1510,1457.01,1337.84]
[null,null,1250,1168.8900000000001,986.49,1515,1462.55,1344.59]
[null,null,1255,1174.43,993.24,1520,1468.09,1351.35]
[null,null,1260,1179.97,1000,1525,1473.63,1358.11]
[null,null,1265,1185.51,1006.76,1530,1479.17,1364.86]
[null,null,1270,1191.05,1013.51,1535,1484.71,1371.62]
[null,null,1275,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (C103 - UGrenz), 2)","v":1196.5899999999999},{"$f":"ROUND((OGrenz / (OGrenz - UGrenz)) * (C103 - UGrenz), 2)","v":1020.27},1540,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F103 - UGrenz), 2)","v":1490.25},{"$f":"ROUND((OGrenz / (OGrenz - UGrenz)) * (F103 - UGrenz), 2)","v":1378.38}]
[null,null,1280,1202.1300000000001,1027.03,1545,1495.79,1385.14]
[null,null,1285,1207.68,1033.78,1550,1501.33,1391.89]
[null,null,1290,1213.22,1040.54,1555,1506.88,1398.65]
[null,null,1295,1218.76,1047.3,1560,1512.42,1405.41]
[null,null,1300,1224.3,1054.05,1565,1517.96,1412.16]
[null,null,1305,1229.8399999999999,1060.81,1570,1523.5,1418.92]
[null,null,1310,1235.3800000000001,1067.57,1575,1529.04,1425.68]
[null,null,{"$f":"C110+5","v":1315},1240.92,1074.32,1580,1534.58,1432.43]
[null,null,{"$f":"C111+5","v":1320},1246.46,1081.08,1585,1540.12,1439.19]
[null,null,{"$f":"C112+5","v":1325},1252,1087.8399999999999,1590,1545.66,1445.95]
[null,null,{"$f":"C113+5","v":1330},1257.54,1094.5899999999999,1595,1551.2,1452.7]
[null,null,{"$f":"F114+5","v":1600},1556.74,{"$f":"ROUND((OGrenz / (OGrenz - UGrenz)) * (C115 - UGrenz), 2)","v":1459.46},{"$f":"C154+5","v":1800},1778.37,1729.73]
[null,null,{"$f":"C115+5","v":1605},1562.28,{"$f":"ROUND((OGrenz / (OGrenz - UGrenz)) * (C116 - UGrenz), 2)","v":1466.22},{"$f":"F115+5","v":1805},1783.91,1736.49]
[null,null,{"$f":"C116+5","v":1610},1567.82,1472.97,{"$f":"F116+5","v":1810},1789.45,1743.24]
[null,null,1615,1573.36,1479.73,1815,1794.99,1750]
[null,null,1620,1578.9,1486.49,1820,1800.53,1756.76]
[null,null,1625,1584.45,1493.24,1825,1806.07,1763.51]
[null,null,1630,1589.99,1500,1830,1811.62,1770.27]
[null,null,1635,1595.53,1506.76,1835,1817.16,1777.03]
[null,null,1640,1601.07,1513.51,1840,1822.7,1783.78]
[null,null,1645,1606.61,1520.27,1845,1828.24,1790.54]
[null,null,1650,1612.15,1527.03,1850,1833.78,1797.3]
[null,null,1655,1617.69,1533.78,1855,1839.32,1804.05]
[null,null,1660,1623.23,1540.54,1860,1844.86,1810.81]
[null,null,1665,1628.77,1547.3,1865,1850.4,1817.57]
[null,null,1670,1634.31,1554.05,1870,1855.94,1824.32]
[null,null,1675,1639.85,1560.81,1875,1861.48,1831.08]
[null,null,1680,1645.39,1567.57,1880,1867.02,1837.84]
[null,null,1685,1650.93,1574.32,1885,1872.56,1844.59]
[null,null,1690,1656.47,1581.08,1890,1878.1,1851.35]
[null,null,1695,1662.02,1587.84,1895,1883.64,1858.11]
[null,null,1700,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (C135 - UGrenz), 2)","v":1667.56},1594.59,1900,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F135 - UGrenz), 2)","v":1889.19},1864.86]
[null,null,1705,1673.1,1601.35,1905,1894.73,1871.62]
[null,null,1710,1678.64,1608.11,1910,1900.27,1878.38]
[null,null,1715,1684.18,1614.86,1915,1905.81,1885.14]
[null,null,1720,1689.72,{"$f":"ROUND((OGrenz / (OGrenz - UGrenz)) * (C139 - UGrenz), 2)","v":1621.62},1920,1911.35,1891.89]
[null,null,{"$f":"C139+5","v":1725},1695.26,1628.38,1925,1916.89,1898.65]
[null,null,1730,1700.8,1635.14,1930,1922.43,1905.41]
[null,null,1735,1706.34,1641.89,1935,1927.97,1912.16]
[null,null,1740,1711.88,1648.65,1940,1933.51,1918.92]
[null,null,1745,1717.42,1655.41,1945,1939.05,1925.68]
[null,null,1750,1722.96,1662.16,1950,1944.59,1932.43]
[null,null,1755,1728.5,1668.92,1955,1950.13,1939.19]
[null,null,1760,1734.04,1675.68,1960,1955.67,1945.95]
[null,null,1765,1739.59,1682.43,1965,1961.21,1952.7]
[null,null,1770,1745.13,1689.19,1970,1966.76,1959.46]
[null,null,1775,1750.67,1695.95,1975,1972.3,1966.22]
[null,null,1780,1756.21,1702.7,1980,1977.84,1972.97]
[null,null,1785,1761.75,1709.46,1985,1983.38,1979.73]
[null,null,1790,1767.29,1716.22,1990,1988.92,1986.49]
[null,null,1795,1772.83,1722.97,1995,1994.46,1993.24]
[]
[null,null,null,null,null,{"$f":"F154+5","v":2000},{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F156 - UGrenz), 2)","v":2000},{"$f":"ROUND((OGrenz / (OGrenz - UGrenz)) * (F156 - UGrenz), 2)","v":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":2023}]
["Beitragszeitraum",1,{"$f":"IFERROR(VLOOKUP(B3,Jahr,D3,0),\"Fehler\")","v":2023},{"$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":520},{"$f":"SUMIF(Listen!$F$19:$U$20,A4,Listen!$F$20:$U$20)","v":11},null,{"$f":"VLOOKUP($B4,Jahr,$D4,0)","v":520},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,0.69220000000000004,{"$f":"ROUND(IF(B6,G6/C7,F6/C7),4)","v":0.68630000000000002},null,28,30]
["Summe SV",{"$f":"B2","v":1},{"$f":"VLOOKUP(B7,Jahr,D7,0)","v":40.800000000000004},{"$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.6,{"$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",2,{"$f":"IFERROR(VLOOKUP(B16,KV,2,0)*100,D16)","v":0},0.5,"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: ","2022-12-20",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,"manuelle Eingabe",null,null,1,2023,{"$f":"I3+J3+K3+L3+N3","v":40.800000000000004},1.6,18.600000000000001,2.6,3.4,24.7,14.6,14,{"$f":"Y3","v":520},2000,1.2E-2,2.1999999999999999E-2,5.9999999999999995E-4,0.6,null,12,{"$f":"130*W3","v":1560},{"$f":"ROUNDUP(X3/3,0)","v":520},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,0,null,null,{"$f":"F3+1","v":2},2022,{"$f":"I4+J4+K4+L4+N4","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,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,3.0000000000000001E-3,null,null,3,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,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,4.0000000000000001E-3,null,null,4,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,"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,5.0000000000000001E-3,null,null,5,2019,39.65,0.9,18.600000000000001,2.5,3.05,24.7,14.6,14,450,1300,1.025E-2,null,5.9999999999999995E-4,0.25,null,null,null,null,null,209,2,9,4,"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,8.0000000000000002E-3,null,null,6,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,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,8.3999999999999995E-3,null,null,7,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,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,8.8000000000000005E-3,null,null,8,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,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,8.9999999999999993E-3,null,null,9,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,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,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,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.09E-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.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,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.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,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.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,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.2500000000000001E-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.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,{"$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.2999999999999999E-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.35E-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.3999999999999999E-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.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":"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.4499999999999999E-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.4800000000000001E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$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.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,{"$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.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,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.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,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.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,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.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,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.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,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.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,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.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,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.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,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.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,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.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,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.8000000000000002E-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.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,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.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,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.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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,914,9,24,11,"Beitragsbemessungsgrundlage für RV:","-",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,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]