{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Angaben","Dialog","Tabelle","Steuerung","Listen"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":122,"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":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":false,"merged":[[25,6,25,8],[27,6,27,8],[29,6,29,8],[2,1,2,9],[8,1,8,5],[20,6,20,8],[19,6,19,8],[21,6,21,8]]}
[null,"Übergangsbereichsrechner"]
[]
[null,{"$f":"IFERROR(CONCATENATE(\" Beitragsberechnung vers.pflichtiger Beschäftigter innerhalb des Übergangsbereichs (\",UGrenz+0.01,\" € bis \",TEXT(OGrenz,\"0.000,00\"),\" €)\"),\"Beitragsberechnung vers.pfl. Beschäftigter innerhalb der Gleitzone \")","v":" Beitragsberechnung vers.pflichtiger Beschäftigter innerhalb des Übergangsbereichs (520,01 € bis 1.600,00 €)"}]
[null,{"$f":"\"Beitragszeitraum:   ab Oktober \" & Zeitraum","v":"Beitragszeitraum:   ab Oktober 2022"}]
[null,"Zutreffende Sonderregelungen:",null,null,null,null,"Individuelle Angaben:",null,null,null,null,null," Auswahl des individuellen KV-Zusatzbeitragssatzes"]
[]
[null,null,null,null,null,null,"  Angabe des individuellen KV-Zusatzbeitragssatzes:",null,null,{"$f":"IF(AND(LC_Liste_KV_Zu=1,BS_KV_Zu_man=\"\"),\"\",BS_KV_Zu/100)","v":1.3500000000000002E-2}]
[]
[null,null,null,null,null,null,"  Gültiger KV-Beitragssatz:",null,null,{"$f":"IFERROR(BS_KV_allg/100,\"\")","v":0.14599999999999999}]
[]
[]
[null,null,null,null,null,null,"  Beitragszuschlag wegen Kinderlosigkeit in der PV:"]
[]
[null,null,null,null,null,null,"  Allgemeine Beitragssätze der Sozialversicherung:"]
[]
[null,null,null,null,null,null,"  Durchschnittlicher Gesamtsozialversicherungsbeitragssatz",null,null,{"$f":"IFERROR(Steuerung!C7/100,\"\")","v":0.39950000000000002}]
[]
[null,null,null,null,null,null,"  allgemeiner Beitragssatz Krankenversicherung",null,null,{"$f":"IFERROR(Steuerung!C8/100,\"\")","v":0.14599999999999999}]
[null,null,null,null,null,null,"  durchschnittl. Zusatzbeitragssatz Krankenversicherung",null,null,{"$f":"IFERROR(Steuerung!C12/100,\"\")","v":1.3000000000000001E-2}]
[null,null,null,null,null,null,"  Beitragssatz Rentenversicherung",null,null,{"$f":"IFERROR(nRV_Satz_Jahr/100,\"\")","v":0.18600000000000003}]
[null,null,null,null,null,null,"  Beitragssatz Arbeitslosenversicherung",null,null,{"$f":"IFERROR(nAV_Satz_Jahr/100,\"\")","v":2.4E-2}]
[null,null,null,null,null,null,"  Beitragssatz Pflegeversicherung",null,null,{"$f":"IFERROR(nPV_Satz_Jahr/100,\"\")","v":3.0499999999999999E-2}]
[]
[null,null,null,null,null,null,"  Zutreffende Arbeitgeber-Umlagen"]
[]
[null,null,null,null,null,null,"           U1 - Krankheitsfall",null,null,{"$f":"S_U1_Satz","v":0}]
[]
[null,null,null,null,null,null,"           U2 - Mutterschaft",null,null,{"$f":"S_U2_Satz","v":0}]
[]
[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":15,"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 1.600,00 €)"}]
[null,{"$f":"\"Beitragszeitraum:   ab Oktober \" & Zeitraum","v":"Beitragszeitraum:   ab Oktober 2022"}]
[]
[null,"Berechnungsgrundlagen:",null,null,null,"Aktive Sonderregelungen:",null,null,null,null,"Mehrfachbeschäftigung"]
[null,null,null,"Arbeitsentgelt für diese Tätigkeit",432,"KV:","allgemeiner Beitragssatz"]
[]
[null,null,null,"Übergangsbereichsentgelt für diese Tätigkeit:",420.81,"RV:"]
[]
[null,null,null,"BE Arbeitnehmer für diese Tätigkeit: ",394.57,"AV:"]
[]
[null,null,null,null,null,"PV:"," Zuschlag wegen Kinderlosigkeit"]
[]
[null,null,null,null,null,"Sonderfälle:","Mehrfachbeschäftigung"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Teilarbeitsentgelt für die Hauptbeschäftigung",432]
[null,"Voller SV-Beitrag:",null,"Arbeitgeberanteile:",null,"Arbeitnehmeranteile:",null,"Beitragssatz:",null,null,null,null,null,null,-130.37]
[null,"KV:",61.44,"KV:",32.64,"KV:",28.8,"KV:",0.14599999999999999,null,"Teilarbeitsentgelt für die Nebenbeschäftigung",924]
[]
[null,{"$f":"IF(AND(S_KV_PV_frei<>TRUE,BS_KV_Zu<>0),\"Zusatz KV:\",\"\")","v":"Zusatz KV:"},5.68,{"$f":"B20","v":"Zusatz KV:"},3.0199999999999996,{"$f":"B20","v":"Zusatz KV:"},2.66,{"$f":"B20","v":"Zusatz KV:"},1.3500000000000002E-2]
[null,null,null,null,null,null,null,null,null,null,"gesamtes monatliches Arbeitsentgelt:",1356]
[null,"RV:",78.28,"RV:",41.58,"RV:",36.700000000000003,"RV:",0.18600000000000003,null,"gesamtes monatliches Übergangsbereichsentgelt:",1320.86]
[]
[null,"AV:",10.1,"AV:",5.3699999999999992,"AV:",4.7300000000000004,"AV:",2.4E-2]
[]
[null,"PV:",12.84,"PV:",6.82,"PV:",6.02,"PV:",3.0499999999999999E-2]
[]
[null,{"$f":"IF(S_PV_Zu=1,\"Zuschl. PV:\",\"\")","v":"Zuschl. PV:"},1.47,{"$f":"B28","v":"Zuschl. PV:"},"-  ",{"$f":"B28","v":"Zuschl. PV:"},1.47,{"$f":"B28","v":"Zuschl. PV:"},3.4999999999999996E-3]
[]
[null,"SV-Gesamt:",{"$f":"SUM(C18:C28)","v":169.81},"SV-Gesamt:",{"$f":"SUM(E18:E28)","v":89.43},"SV-Gesamt:",{"$f":"SUM(G18:G28)","v":80.38}]
[]
[null,{"$f":"IF(S_U1=TRUE,\"U1:\",\"\")","v":""},8.42,{"$f":"B32","v":""},8.42,null,null,{"$f":"B32","v":""},0.02]
[null,{"$f":"IF(S_U2=TRUE,\"U2:\",\"\")","v":""},1.89,{"$f":"B33","v":""},1.89,null,null,{"$f":"B33","v":""},4.5000000000000005E-3]
[null,{"$f":"IF(S_U3=TRUE,\"Insolvenzuml.:\",\"\")","v":""},0.38,{"$f":"B34","v":""},0.38,null,null,{"$f":"B34","v":""},8.9999999999999998E-4]
[]
[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":117,"n_cols":8,"rows_kept":117,"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 1.600,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:   ab Oktober \" & Zeitraum","v":"Beitragszeitraum:   ab Oktober 2022"}]
[null,null,"monatliches Arbeitsentgelt",{"$f":"\"Beitragsbemes-sungsgrundlage bei: \"&Steuerung!C7&\" %\"","v":"Beitragsbemes-sungsgrundlage bei: 39,95 %"},"Beitragspflichtige Einnahme Arbeitnehmer","monatliches Arbeitsentgelt",{"$f":"D6","v":"Beitragsbemes-sungsgrundlage bei: 39,95 %"},"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":364.48},{"$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":679.07},{"$f":"ROUND((OGrenz / (OGrenz - UGrenz)) * (F7 - UGrenz), 2)","v":407.41}]
[null,null,{"$f":"UGrenz+5","v":525},{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (C8 - UGrenz), 2)","v":370.19},7.41,{"$f":"F7+5","v":800},{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F8 - UGrenz), 2)","v":684.79},414.81]
[null,null,{"$f":"C8+5","v":530},{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (C9 - UGrenz), 2)","v":375.91},14.81,{"$f":"F8+5","v":805},{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F9 - UGrenz), 2)","v":690.51},422.22]
[null,null,535,381.63,22.22,810,696.23,429.63]
[null,null,540,387.35,29.63,815,701.95,437.04]
[null,null,545,393.07,37.04,820,707.67,444.44]
[null,null,550,398.79,44.44,825,713.39,451.85]
[null,null,555,404.51,51.85,830,719.11,459.26]
[null,null,560,410.23,59.26,835,724.83,466.67]
[null,null,565,415.95,66.67,840,730.55,474.07]
[null,null,570,421.67,74.069999999999993,845,736.27,481.48]
[null,null,575,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (C18 - UGrenz), 2)","v":427.39},81.48,850,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F18 - UGrenz), 2)","v":741.99},488.89]
[null,null,580,433.11,88.89,855,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F19 - UGrenz), 2)","v":747.71},496.3]
[null,null,585,438.83,96.3,860,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F20 - UGrenz), 2)","v":753.43},503.7]
[null,null,590,444.55,103.7,865,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F21 - UGrenz), 2)","v":759.15},511.11]
[null,null,595,450.27,111.11,870,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F22 - UGrenz), 2)","v":764.87},518.52]
[null,null,{"$f":"C22+5","v":600},455.99,118.52,875,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F23 - UGrenz), 2)","v":770.59},525.92999999999995]
[null,null,605,461.71,125.93,880,776.31,533.33000000000004]
[null,null,610,467.43,133.33000000000001,885,782.03,540.74]
[null,null,615,473.15,140.74,890,787.75,548.15]
[null,null,620,478.87,148.15,895,793.47,555.55999999999995]
[null,null,625,484.59,155.56,900,799.19,562.96]
[null,null,630,490.31,162.96,905,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F29 - UGrenz), 2)","v":804.91},570.37]
[null,null,{"$f":"C29+5","v":635},496.03,170.37,910,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F30 - UGrenz), 2)","v":810.63},577.78]
[null,null,640,501.75,177.78,915,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F31 - UGrenz), 2)","v":816.35},585.19000000000005]
[null,null,645,507.47,185.19,920,822.07,592.59]
[null,null,650,513.19000000000005,192.59,925,827.79,600]
[null,null,655,518.91,200,930,833.51,607.41]
[null,null,660,524.63,207.41,935,839.23,614.80999999999995]
[null,null,665,530.35,214.81,940,844.95,622.22]
[null,null,670,536.07000000000005,222.22,945,850.67,629.63]
[null,null,675,541.79,229.63,950,856.39,637.04]
[null,null,680,547.51,{"$f":"ROUND((OGrenz / (OGrenz - UGrenz)) * (C39 - UGrenz), 2)","v":237.04},955,862.11,{"$f":"ROUND((OGrenz / (OGrenz - UGrenz)) * (F39 - UGrenz), 2)","v":644.44000000000005}]
[null,null,685,553.23,244.44,960,867.83,651.85]
[null,null,690,558.95000000000005,251.85,965,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F41 - UGrenz), 2)","v":873.55},659.26]
[null,null,695,564.66999999999996,259.26,970,879.27,666.67]
[null,null,700,570.39,266.67,975,884.99,674.07]
[null,null,705,576.11,274.07,980,890.71,681.48]
[null,null,710,581.83000000000004,281.48,985,896.43,688.89]
[null,null,{"$f":"C45+5","v":715},587.54999999999995,288.89,990,902.15,696.3]
[null,null,{"$f":"C46+5","v":720},{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (C47 - UGrenz), 2)","v":593.27},296.3,995,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F47 - UGrenz), 2)","v":907.87},703.7]
[null,null,725,598.99,303.7,1000,913.59,711.11]
[null,null,730,604.71,311.11,1005,919.31,718.52]
[null,null,735,610.42999999999995,318.52,1010,925.03,725.93]
[null,null,740,616.15,325.93,1015,930.75,733.33]
[null,null,745,621.87,333.33,1020,936.47,740.74]
[null,null,750,627.59,340.74,1025,942.19,748.15]
[null,null,755,633.30999999999995,348.15,1030,947.91,755.56]
[null,null,760,639.03,355.56,1035,953.63,762.96]
[null,null,765,644.75,362.96,1040,959.35,770.37]
[null,null,770,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (C57 - UGrenz), 2)","v":650.47},370.37,1045,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F57 - UGrenz), 2)","v":965.07},777.78]
[null,null,775,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (C58 - UGrenz), 2)","v":656.19},377.78,1050,{"$f":"ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F58 - UGrenz), 2)","v":970.79},785.19]
[null,null,780,661.91,385.19,1055,976.51,792.59]
[null,null,785,667.63,392.59,1060,982.23,800]
[null,null,790,673.35,400,1065,987.95,807.41]
[null,null,{"$f":"F61+5","v":1070},993.67,814.81,{"$f":"C114+5","v":1335},1296.8399999999999,1207.4100000000001]
[null,null,1075,999.39,822.22,1340,1302.56,1214.81]
[null,null,1080,1005.11,829.63,1345,1308.28,1222.22]
[null,null,1085,1010.83,837.04,{"$f":"IF(F64+5<=OGrenz,F64+5,\"\")","v":1350},1314,1229.6300000000001]
[null,null,1090,1016.55,844.44,{"$f":"IF(F65+5<=OGrenz,F65+5,\"\")","v":1355},1319.72,1237.04]
[null,null,1095,1022.27,851.85,{"$f":"IF(F66+5<=OGrenz,F66+5,\"\")","v":1360},1325.44,1244.44]
[null,null,1100,1027.99,859.26,{"$f":"IF(F67+5<=OGrenz,F67+5,\"\")","v":1365},1331.16,1251.8499999999999]
[null,null,1105,1033.71,866.67,{"$f":"IF(F68+5<=OGrenz,F68+5,\"\")","v":1370},1336.88,1259.26]
[null,null,1110,1039.43,874.07,{"$f":"IFERROR(IF(F69+5<=OGrenz,F69+5,\"\"),\"\")","v":1375},{"$f":"IFERROR(ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F70 - UGrenz), 2),\"\")","v":1342.6},1266.67]
[null,null,1115,1045.1500000000001,{"$f":"ROUND((OGrenz / (OGrenz - UGrenz)) * (C71 - UGrenz), 2)","v":881.48},1380,1348.32,{"$f":"ROUND((OGrenz / (OGrenz - UGrenz)) * (F71 - UGrenz), 2)","v":1274.07}]
[null,null,1120,1050.8699999999999,888.89,1385,1354.04,1281.48]
[null,null,1125,1056.5899999999999,896.3,1390,1359.76,1288.8900000000001]
[null,null,1130,1062.31,903.7,1395,1365.48,1296.3]
[null,null,1135,1068.03,911.11,1400,1371.2,1303.7]
[null,null,1140,1073.75,918.52,1405,1376.92,1311.11]
[null,null,1145,1079.47,925.93,1410,1382.64,1318.52]
[null,null,1150,1085.2,933.33,1415,1388.36,1325.93]
[null,null,1155,1090.92,940.74,1420,1394.08,1333.33]
[null,null,1160,1096.6400000000001,948.15,1425,1399.8,1340.74]
[null,null,1165,1102.3599999999999,955.56,1430,1405.52,1348.15]
[null,null,1170,1108.08,962.96,1435,1411.24,1355.56]
[null,null,1175,1113.8,970.37,1440,1416.96,1362.96]
[null,null,1180,1119.52,977.78,1445,1422.68,1370.37]
[null,null,1185,1125.24,985.19,1450,1428.4,1377.78]
[null,null,1190,1130.96,992.59,1455,1434.12,1385.19]
[null,null,1195,1136.68,1000,1460,1439.84,1392.59]
[null,null,1200,1142.4000000000001,1007.41,1465,1445.56,1400]
[null,null,1205,1148.1199999999999,1014.81,1470,1451.28,1407.41]
[null,null,1210,1153.8399999999999,1022.22,1475,1457,1414.81]
[null,null,1215,1159.56,1029.6300000000001,1480,1462.72,1422.22]
[null,null,1220,1165.28,1037.04,1485,1468.44,1429.63]
[null,null,1225,1171,1044.44,1490,1474.16,1437.04]
[null,null,1230,1176.72,1051.8499999999999,1495,1479.88,1444.44]
[null,null,1235,1182.44,1059.26,1500,1485.6,1451.85]
[null,null,1240,1188.1600000000001,1066.67,1505,1491.32,1459.26]
[null,null,1245,1193.8800000000001,1074.07,1510,1497.04,1466.67]
[null,null,1250,1199.5999999999999,1081.48,1515,1502.76,1474.07]
[null,null,1255,1205.32,1088.8900000000001,1520,1508.48,1481.48]
[null,null,1260,1211.04,1096.3,1525,1514.2,1488.89]
[null,null,1265,1216.76,1103.7,1530,1519.92,1496.3]
[null,null,1270,1222.48,1111.1099999999999,1535,1525.64,1503.7]
[null,null,1275,1228.2,{"$f":"ROUND((OGrenz / (OGrenz - UGrenz)) * (C103 - UGrenz), 2)","v":1118.52},1540,1531.36,{"$f":"ROUND((OGrenz / (OGrenz - UGrenz)) * (F103 - UGrenz), 2)","v":1511.11}]
[null,null,1280,1233.92,1125.93,1545,1537.08,1518.52]
[null,null,1285,1239.6400000000001,1133.33,1550,1542.8,1525.93]
[null,null,1290,1245.3599999999999,1140.74,1555,1548.52,1533.33]
[null,null,1295,1251.08,1148.1500000000001,1560,1554.24,1540.74]
[null,null,1300,1256.8,1155.56,1565,1559.96,1548.15]
[null,null,1305,1262.52,1162.96,1570,1565.68,1555.56]
[null,null,1310,1268.24,1170.3699999999999,1575,1571.4,1562.96]
[null,null,{"$f":"C110+5","v":1315},1273.96,1177.78,1580,1577.12,1570.37]
[null,null,1320,1279.68,1185.19,1585,1582.84,1577.78]
[null,null,1325,1285.4000000000001,1192.5899999999999,1590,1588.56,1585.19]
[null,null,1330,1291.1199999999999,1200,1595,1594.28,1592.59]
[]
[]
[null,null,null,null,null,1600,{"$f":"IFERROR(ROUND(Faktor * UGrenz + ((OGrenz / (OGrenz - UGrenz))\n                           - (UGrenz / (OGrenz - UGrenz)) * Faktor)\n                        * (F117 - UGrenz), 2),\"\")","v":1600},{"$f":"ROUND((OGrenz / (OGrenz - UGrenz)) * (F117 - UGrenz), 2)","v":1600}]

{"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":2022}]
["Beitragszeitraum",1,{"$f":"IFERROR(VLOOKUP(B3,Jahr,D3,0),\"Fehler\")","v":2022},{"$f":"SUMIF(Listen!$F$19:$U$20,A3,Listen!$F$20:$U$20)","v":2},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":1600},{"$f":"SUMIF(Listen!$F$19:$U$20,A5,Listen!$F$20:$U$20)","v":12},null,{"$f":"VLOOKUP($B5,Jahr,$D5,0)","v":1600},1300]
["Faktor",false,{"$f":"ROUND(IF(B6,G6/C7,F6/C7),4)","v":0.70089999999999997},null,null,28,30]
["Summe SV",{"$f":"B2","v":1},{"$f":"VLOOKUP(B7,Jahr,D7,0)","v":39.950000000000003},{"$f":"SUMIF(Listen!$F$19:$U$20,A7,Listen!$F$20:$U$20)","v":3}]
["KV allg",{"$f":"B2","v":1},14.6,{"$f":"SUMIF(Listen!$F$19:$U$20,A8,Listen!$F$20:$U$20)","v":9}]
["RV",{"$f":"B2","v":1},18.600000000000001,{"$f":"SUMIF(Listen!$F$19:$U$20,A9,Listen!$F$20:$U$20)","v":5}]
["AV",{"$f":"B2","v":1},2.4,{"$f":"SUMIF(Listen!$F$19:$U$20,A10,Listen!$F$20:$U$20)","v":6}]
["PV",{"$f":"B2","v":1},3.05,{"$f":"SUMIF(Listen!$F$19:$U$20,A11,Listen!$F$20:$U$20)","v":7}]
["Zusatz KV",{"$f":"B2","v":1},1.3,{"$f":"SUMIF(Listen!$F$19:$U$20,A12,Listen!$F$20:$U$20)","v":4}]
["KV erm",{"$f":"B2","v":1},{"$f":"VLOOKUP(B13,Jahr,D13,0)","v":14},{"$f":"SUMIF(Listen!$F$19:$U$20,A13,Listen!$F$20:$U$20)","v":10}]
["KV allg",{"$f":"B2","v":1},{"$f":"VLOOKUP(B14,Jahr,D14,0)","v":14.6},{"$f":"SUMIF(Listen!$F$19:$U$20,A14,Listen!$F$20:$U$20)","v":9}]
["KV Beitragssatz",{"$f":"IF(S_BS_allg,1,2)","v":1},{"$f":"IF(S_KV_allg_erm.BS=2,C13,C14)","v":14.6},null,null,"S_BS_allg",true]
["KV individueller ZusatzBS",21,{"$f":"IFERROR(VLOOKUP(B16,KV,2,0)*100,D16)","v":1.35},1.22,"manuell","S_BS_ermäßigt",false]
["RV Knappsch. ",{"$f":"B2","v":1},{"$f":"VLOOKUP(B17,Jahr,D17,0)","v":24.7},{"$f":"SUMIF(Listen!$F$19:$U$20,A17,Listen!$F$20:$U$20)","v":8}]
["AG-Ant. Sachsen",{"$f":"B2","v":1},{"$f":"VLOOKUP(B18,Jahr,D18,0)","v":1.025E-2},{"$f":"SUMIF(Listen!$F$19:$U$20,A18,Listen!$F$20:$U$20)","v":13}]
["AN-Ant. Sachsen",{"$f":"B2","v":1},{"$f":"VLOOKUP(B19,Jahr,D19,0)","v":2.0250000000000001E-2},{"$f":"SUMIF(Listen!$F$19:$U$20,A19,Listen!$F$20:$U$20)","v":14}]
["Zuschlag wg Kinderlosigkeit",1,{"$f":"IF(S_PV_Zu=1,VLOOKUP(B2,Jahr,D20,0),0)","v":0.35},{"$f":"SUMIF(Listen!$F$19:$U$20,A20,Listen!$F$20:$U$20)","v":16}]
["U1 - Krankheitsfall",false,0]
["U2 - Mutterschaft",false,0]
["Insolvenzgeld",false,{"$f":"IF(S_U3=TRUE,VLOOKUP(B5,Jahr,D23,0),0)","v":0},{"$f":"SUMIF(Listen!$F$19:$U$20,A23,Listen!$F$20:$U$20)","v":15}]
[]
["Frei KV/PV",false]
["PV Sachsen",false]
["Frei RV",false]
["RV nur AG"]
["RV Knappsch. "]
["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":true},{"$f":"IF(B46,50,\"\")","v":50}]
[]
[]
["Opt_Sond2_Tage"]
["Opt_Sond2_Stunden"]
["Opt_Sond2_Wostu"]
["Opt_Sond2_Entgelt"]
["AE"]
["Sond3_Entgelt"]
["Sond3_Sonstentgelt"]
["Sond3_Quotient",0.27272727272727271]
[]
["S2_O1_O2",{"$f":"IF(S_Sonder_2_Opt=1,\" Tagen\",\" geleist. h \")","v":" geleist. h "}]
["Anzahl_S2_O1_O2",{"$f":"IF(S_Sonder_2_Opt=1,VALUE(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-01-07",null,null,null,"Jahr",null,"Zusatz KV","RV","AV","PV","RV Knappsch. ","KV allg","KV erm","Untergrenze","Obergrenze","AG-Ant. Sachsen","AN-Ant. Sachsen","Insolvenzgeld","Zuschlag wg Kinderlosigkeit",null,"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,2022,{"$f":"I3+J3+K3+L3+N3","v":39.950000000000003},1.3,18.600000000000001,2.4,3.05,24.7,14.6,14,{"$f":"Y3","v":520},1600,1.025E-2,2.0250000000000001E-2,8.9999999999999998E-4,0.35,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,3.0000000000000001E-3,null,null,{"$f":"F3+1","v":2},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,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.5000000000000001E-3,null,null,3,2020,39.75,1.1000000000000001,18.600000000000001,2.4,3.05,24.7,14.6,14,450,1300,1.025E-2,null,5.9999999999999995E-4,0.25,null,null,null,null,null,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,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,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,2018,39.75,1,18.600000000000001,3,2.5499999999999998,24.7,14.6,14,450,850,7.7499999999999999E-3,null,5.9999999999999995E-4,0.25,null,null,null,null,null,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,6.4999999999999997E-3,null,null,6,2017,39.950000000000003,1.1000000000000001,18.7,3,2.5499999999999998,24.8,14.6,14,450,850,7.7499999999999999E-3,null,8.9999999999999998E-4,0.25,null,null,null,null,null,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,6.8999999999999999E-3,null,null,7,2016,39.75,1.1000000000000001,18.7,3,2.35,24.8,14.6,14,450,850,6.7499999999999999E-3,1.6750000000000001E-2,1.1999999999999999E-3,0.25,null,null,null,null,null,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,7.0000000000000001E-3,null,null,8,2015,39.549999999999997,0.9,18.7,3,2.35,24.8,14.6,14,450,850,6.7499999999999999E-3,1.6750000000000001E-2,1.5E-3,0.25,null,null,null,null,null,{"$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.0000000000000002E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,8.3999999999999995E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,8.8000000000000005E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,8.9999999999999993E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,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,0.01,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.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,{"$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.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,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.2500000000000001E-2,null,null,"Auswahl","Beitragszeitraum","Summe SV","Zusatz KV","RV","AV","PV","RV Knappsch. ","KV allg","KV erm","Untergrenze","Obergrenze","AG-Ant. Sachsen","AN-Ant. Sachsen","Insolvenzgeld","Zuschlag wg Kinderlosigkeit",null,null,null,null,null,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.2800000000000001E-2,null,null,1,{"$f":"F20+1","v":2},{"$f":"G20+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,null,null,null,null,null,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.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,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.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,{"$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.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,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.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,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.3899999999999999E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.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,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.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,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.4500000000000001E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.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,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.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,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.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,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.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,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.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,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.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,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,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,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,2.4E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,809,8,9,4,"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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,809,8,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,811,8,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","Steuerung","B",31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]