{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Schnellrechner","Beitrag","Beitrag PM2","Leistungen"],"not_rendered":{"charts":2,"images":3,"macros":1,"external_links":1,"defined_names":15,"comments":2,"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":"Schnellrechner","index":0,"n_rows":56,"n_cols":18,"rows_kept":56,"cut":false,"hidden":false,"merged":[[55,2,55,14],[40,2,40,12],[19,9,19,10],[22,8,22,10],[0,0,0,9],[17,9,17,10],[15,5,15,10],[5,6,5,7],[5,9,5,13],[7,6,7,7],[9,6,9,7],[26,2,26,12]]}
[]
[]
[null,"OLGAflex/Gruppe Schnellrechner",null,null,null,null,null,null,null,null,null,null,null,null,"Stand: 05.23"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PTG Ri","PTG AR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($J$8>60,#REF!,R5)","v":0},0]
[null,null,"Vorname und Nachname",null,null,null,"Max",null,null,"Muster",null,null,null,null,null,null,{"$f":"IF($J$8>60,#REF!,R6)","v":5},5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($J$8>60,#REF!,R7)","v":10},10]
[null,null,"Geburtsjahr",null,null,null,1980,null,null,{"$f":"YEAR(G10)-G8","v":43},null,null,null,null,null,null,{"$f":"IF($J$8>60,#REF!,R8)","v":15},15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($J$8>60,#REF!,R9)","v":20},20]
[null,null,"Versicherungsbeginn",null,null,null,"2023-05-01",null,null,null,null,null,null,null,null,null,{"$f":"IF($J$8>60,#REF!,R10)","v":25},25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($J$8>60,#REF!,R11)","v":30},30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($J$8>60,#REF!,R12)","v":35},35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($J$8>60,#REF!,R13)","v":45},45]
[null,null,"Gewünschte Absicherung wählen:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($J$8>60,#REF!,R14)","v":50},50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($J$8>60,#REF!,R15)","v":55},55]
[null,null,"Tarif",null,null,"Pflegetagegeld",null,null,null,null,null,null,"Beitrag",null,null,null,{"$f":"IF($J$8>60,#REF!,R16)","v":60},60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($J$8>60,#REF!,R17)","v":65},65]
[null,null,"OLGAflex.AR",null," i",null,null,50,"≙",{"$f":"CONCATENATE(\"\",H18*30,\" € pro Monat\")","v":"1500 € pro Monat"},null,null,{"$f":"Beitrag!I6","v":76},null,null,null,{"$f":"IF($J$8>60,#REF!,R18)","v":70},70]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($J$8>60,#REF!,R19)","v":75},75]
[null,null,"OLGAflex.Ri",null," i",null,null,100,"≙",{"$f":"CONCATENATE(H20*30,\" € pro Monat\")","v":"3000 € pro Monat"},null,null,{"$f":"Beitrag!I7","v":7.0000000000000009},null,null,null,{"$f":"IF($J$8>60,#REF!,R20)","v":80},80]
[null,null,{"$f":"IF(J8>60,\"ab Alter 61 kann nur noch die Tarifstufe OLGAflex.AR abgeschlossen werden\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($J$8>60,#REF!,R21)","v":85},85]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($J$8>60,#REF!,R22)","v":90},90]
[null,null,"Gesamt",null,null,null,{"$f":"IF(H18+H20>150,\"Abbruch: \",\"\")","v":""},{"$f":"IF((H18+H20)>150,\"Höchsttagegeld\",H18+H20)","v":150},{"$f":"IF((H18+H20)>150,\"überschritten!\",CONCATENATE(\"≙ \",(H18+H20)*30,\" € pro Monat\"))","v":"≙ 4500 € pro Monat"},null,null,null,{"$f":"M18+M20","v":83},null,null,null,{"$f":"IF($J$8>60,#REF!,R23)","v":95},95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($J$8>60,#REF!,R24)","v":100},100]
[]
[]
[null,null,"Überblick der monatlichen Leistungen aus OLGAflex:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($J$8>60,#REF!,R39)","v":105},105]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($J$8>60,#REF!,R40)","v":110},110]
[null,null,"Mit dieser Kombination entwickelt sich der OLGAflex-Beitrag folgendermaßen:",null,null,null,null,null,null,null,null,null,null,"i",null,null,{"$f":"IF($J$8>60,#REF!,R41)","v":115},115]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($J$8>60,#REF!,R42)","v":120},120]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($J$8>60,#REF!,R43)","v":125},125]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($J$8>60,#REF!,R44)","v":130},130]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($J$8>60,#REF!,R45)","v":135},135]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($J$8>60,#REF!,R46)","v":140},140]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($J$8>60,#REF!,R47)","v":145},145]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($J$8>60,#REF!,R48)","v":150},150]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Beitragsänderungen aufgrund von Beitragsanpassungen oder Pflegegeld-Dynamisierungen sind nicht berücksichtigt."]

{"sheet":"Beitrag","index":1,"n_rows":73,"n_cols":24,"rows_kept":73,"cut":false,"hidden":true,"merged":[]}
["Alter","OLGAflex.AR","OLGAflex.Ri",null,null,null,null,"variable \nEingaben"]
[null,null,null,null,null,null,"Alter",{"$f":"Schnellrechner!J8","v":43},{"$f":"YEAR(Schnellrechner!G10)","v":2023}]
[0,{"$f":"+'Beitrag PM2'!$B$7","v":0.39},0]
[1,{"$f":"+'Beitrag PM2'!$B$7","v":0.39},0,null,null,null,"Pflegetageld OLGAflex",{"$f":"H6+H7","v":150}]
[2,{"$f":"+'Beitrag PM2'!$B$7","v":0.39},0]
[3,{"$f":"+'Beitrag PM2'!$B$7","v":0.39},0,null,null,null,"OLGAflex.AR",{"$f":"Schnellrechner!$H$18","v":50},{"$f":"IF(H6+H7>150,\"\",VLOOKUP(H2,A3:C93,2,FALSE)*H6)","v":76},{"$f":"VLOOKUP(H2,A3:C93,2,FALSE)*H4","v":228}]
[4,{"$f":"+'Beitrag PM2'!$B$7","v":0.39},0,null,null,null,"OLGAflex.Ri",{"$f":"Schnellrechner!$H$20","v":100},{"$f":"IF(H6+H7>150,\"\",VLOOKUP(H2,A3:C93,3,FALSE)*H7)","v":7.0000000000000009}]
[5,{"$f":"+'Beitrag PM2'!$B$7","v":0.39},0,null,null,null,"Umstellungen",{"$f":"H7/10","v":10}]
[6,{"$f":"+'Beitrag PM2'!$B$7","v":0.39},0,null,null,null,"Alter",null,null,null,null,null,"Umstellung","Mehrbeitrag","Jahr",null,"Gesamtbeitrag OLGAflex",null,null,"Vergleichs-beitrag ohne Föba"]
[7,{"$f":"+'Beitrag PM2'!$B$7","v":0.39},0,null,null,null,{"$f":"H2","v":43},0,{"$f":"H7","v":100},null,null,null,null,null,{"$f":"I2","v":2023},{"$f":"\"ab \"&O10","v":"ab 2023"},{"$f":"I6+I7","v":83},null,null,{"$f":"J6","v":228}]
[8,{"$f":"+'Beitrag PM2'!$B$7","v":0.39},0,null,null,null,{"$f":"IF((G10+5)<61,G10+5,61)","v":48},{"$f":"IF(H$8>1,10,I10)","v":10},{"$f":"I10-H11","v":90},{"$f":"IF(G11>60,I10,H11)","v":10},{"$f":"IF((J10-J11)>9.9,0,1)","v":1},1,{"$f":"J11*K11*L11","v":10},{"$f":"N36-N35","v":17.799999999999997},{"$f":"O10+(G11-G10)","v":2028},{"$f":"\"ab \"&O11","v":"ab 2028"},{"$f":"Q10+N11","v":100.8},null,null,{"$f":"T10","v":228}]
[9,{"$f":"+'Beitrag PM2'!$B$7","v":0.39},0,null,null,null,{"$f":"IF((G11+2)<61,G11+2,61)","v":50},{"$f":"IF(H$8>2,10,I11)","v":10},{"$f":"I11-H12","v":80},{"$f":"IF(G12>60,I11,H12)","v":10},1,1,{"$f":"J12*K12*L12","v":10},{"$f":"N37-N36","v":19.399999999999991},{"$f":"IF((G12-G11)=1,O11+(G12-G11),O11+2)","v":2030},"ab 2030",120.19999999999999,null,null,{"$f":"T11","v":228}]
[10,{"$f":"+'Beitrag PM2'!$B$7","v":0.39},0,null,null,null,{"$f":"IF((G12+2)<61,G12+2,61)","v":52},{"$f":"IF(H$8>3,10,I12)","v":10},70,10,1,{"$f":"IF((G13-G10)=0,0,1)","v":1},10,31,{"$f":"IF((G13-G12)=1,O12+(G13-G12),O12+2)","v":2032},"ab 2032",151.19999999999999,null,null,228]
[11,{"$f":"+'Beitrag PM2'!$B$7","v":0.39},0,null,null,null,54,{"$f":"IF(H$8>4,10,I13)","v":10},60,{"$f":"IF(G14>60,I13,H14)","v":10},1,1,10,21.800000000000011,2034,"ab 2034",173,null,null,228]
[12,{"$f":"+'Beitrag PM2'!$B$7","v":0.39},0,null,null,null,56,{"$f":"IF(H$8>5,10,I14)","v":10},50,10,1,1,10,24,2036,"ab 2036",197,null,null,228]
[13,{"$f":"+'Beitrag PM2'!$B$7","v":0.39},0,null,null,null,58,{"$f":"IF(H$8>6,10,I15)","v":10},40,10,1,1,10,26.400000000000006,2038,"ab 2038",223.4,null,null,228]
[14,{"$f":"+'Beitrag PM2'!$B$7","v":0.39},0,null,null,null,60,{"$f":"IF(H$8>7,10,I16)","v":10},30,10,1,1,10,29.300000000000011,2040,"ab 2040",252.70000000000002,null,null,228]
[15,{"$f":"+'Beitrag PM2'!$B$7","v":0.39},0,null,null,null,61,{"$f":"IF(H$8>8,10,I17)","v":10},20,30,{"$f":"IF((J17-J18)>9.9,0,1)","v":1},1,30,{"$error":"#VALUE!"},2041,"ab 2041",{"$error":"#VALUE!"},null,null,228]
[16,{"$f":"+'Beitrag PM2'!$B$7","v":0.39},0,null,null,null,61,{"$f":"IF(H$8>9,10,I18)","v":10},10,20,0,1,0,{"$error":"#VALUE!"},2043,"ab 2043",{"$error":"#VALUE!"},null,null,228]
[17,{"$f":"+'Beitrag PM2'!$B$8","v":0.23},0,null,null,null,61,{"$f":"IF(H$8>10,10,I19)","v":10},0,10,0,{"$f":"IF((G20-G17)=0,0,1)","v":1},0,{"$error":"#VALUE!"},2045,"ab 2045",{"$error":"#VALUE!"},null,null,228]
[18,{"$f":"+'Beitrag PM2'!$B$8","v":0.23},0,null,null,null,61,{"$f":"IF(H$8>11,10,I20)","v":0},0,0,0,{"$f":"IF((G21-G18)=0,0,1)","v":0},0,{"$error":"#VALUE!"},2047,"ab 2047",{"$error":"#VALUE!"},null,null,228]
[19,{"$f":"+'Beitrag PM2'!$B$8","v":0.23},0,null,null,null,61,{"$f":"IF(H$8>12,10,I21)","v":0},0,0,1,0,0,{"$error":"#VALUE!"},2049,"ab 2049",{"$error":"#VALUE!"},null,null,228]
[20,{"$f":"+'Beitrag PM2'!$B$8","v":0.23},0,null,null,null,61,{"$f":"IF(H$8>13,10,I22)","v":0},0,0,1,0,0,{"$error":"#VALUE!"},2051,"ab 2051",{"$error":"#VALUE!"},null,null,228]
[21,{"$f":"+'Beitrag PM2'!B9","v":0.66},{"$f":"+'Beitrag PM2'!C9","v":7.0000000000000007E-2},null,null,null,61,{"$f":"IF(H$8>14,10,I23)","v":0},0,0,1,0,0,{"$error":"#VALUE!"},2053,"ab 2053",{"$error":"#VALUE!"},null,null,228]
[22,{"$f":"+'Beitrag PM2'!B10","v":0.68},{"$f":"+'Beitrag PM2'!C10","v":7.0000000000000007E-2},null,null,null,61,{"$f":"IF(H$8>15,10,I24)","v":0},0,0,1,0,0,{"$error":"#VALUE!"},2055,"ab 2055",{"$error":"#VALUE!"},null,null,228]
[23,{"$f":"+'Beitrag PM2'!B11","v":0.71},{"$f":"+'Beitrag PM2'!C11","v":7.0000000000000007E-2},null,null,null,61,{"$f":"IF(H$8>16,10,I25)","v":0},0,0,1,0,0,{"$error":"#VALUE!"},2057,"ab 2057",{"$error":"#VALUE!"},null,null,228]
[24,{"$f":"+'Beitrag PM2'!B12","v":0.73},{"$f":"+'Beitrag PM2'!C12","v":7.0000000000000007E-2},null,null,null,61,{"$f":"IF(H$8>17,10,I26)","v":0},0,0,1,0,0,{"$error":"#VALUE!"},2059,"ab 2059",{"$error":"#VALUE!"},null,null,228]
[25,{"$f":"+'Beitrag PM2'!B13","v":0.76},{"$f":"+'Beitrag PM2'!C13","v":7.0000000000000007E-2},null,null,null,61,{"$f":"IF(H$8>18,10,I27)","v":0},0,0,1,0,0,{"$error":"#VALUE!"},2061,"ab 2061",{"$error":"#VALUE!"},null,null,228]
[26,{"$f":"+'Beitrag PM2'!B14","v":0.79},{"$f":"+'Beitrag PM2'!C14","v":7.0000000000000007E-2},null,null,null,61,{"$f":"IF(H$8>19,10,I28)","v":0},0,0,1,0,0,{"$error":"#VALUE!"},2063,"ab 2063",{"$error":"#VALUE!"},null,null,228]
[27,{"$f":"+'Beitrag PM2'!B15","v":0.82},{"$f":"+'Beitrag PM2'!C15","v":7.0000000000000007E-2}]
[28,{"$f":"+'Beitrag PM2'!B16","v":0.85},{"$f":"+'Beitrag PM2'!C16","v":7.0000000000000007E-2}]
[29,{"$f":"+'Beitrag PM2'!B17","v":0.88},{"$f":"+'Beitrag PM2'!C17","v":7.0000000000000007E-2}]
[30,{"$f":"+'Beitrag PM2'!B18","v":0.92},{"$f":"+'Beitrag PM2'!C18","v":7.0000000000000007E-2}]
[31,{"$f":"+'Beitrag PM2'!B19","v":0.95},{"$f":"+'Beitrag PM2'!C19","v":7.0000000000000007E-2},null,null,null,"Alter","TG AR","Beitrag AR","TG Ri","Beitrag Ri","Umstellung","Mehrbeitrag in AR","Summe Beitrag AR plus Ri",null,null,"ab Jahr","OLGAflex","Vergleichsbeitrag (ab Beginn 100 % OLGAflex.AR)",null,"Alter"]
[32,{"$f":"+'Beitrag PM2'!B20","v":0.99},{"$f":"+'Beitrag PM2'!C20","v":7.0000000000000007E-2},null,null,null,{"$f":"H2","v":43},{"$f":"H6","v":50},{"$f":"I6","v":76},{"$f":"H7","v":100},{"$f":"I7","v":7.0000000000000009},null,null,{"$f":"I35+K35","v":83},null,null,{"$f":"IF(R35=\" \",\" \",O10)","v":2023},{"$f":"Q10","v":83},{"$f":"T10","v":228},null,{"$f":"H2","v":43},null,"Ri","AR"]
[33,{"$f":"+'Beitrag PM2'!B21","v":1.03},{"$f":"+'Beitrag PM2'!C21","v":7.0000000000000007E-2},null,null,null,{"$f":"IF((G35+5)<61,G35+5,61)","v":48},{"$f":"H35+L36","v":60},{"$f":"I35+M36","v":94.5},{"$f":"J35-L36","v":90},{"$f":"VLOOKUP(G36,A$3:D$64,3,FALSE)*J36","v":6.3000000000000007},{"$f":"M11","v":10},{"$f":"VLOOKUP(G36,A$3:D$64,2,FALSE)*L36","v":18.5},{"$f":"I36+K36","v":100.8},null,null,{"$f":"IF(R36=\" \",\" \",O10+1)","v":2024},{"$f":"IF(U36=51,V36,R35)","v":83},{"$f":"S35","v":228},null,{"$f":"U35+1","v":44},{"$f":"W36+X36","v":83},{"$f":"VLOOKUP(U36,A3:C93,3,FALSE)*H7","v":7.0000000000000009},{"$f":"VLOOKUP(H2,A3:C93,2,FALSE)*H6","v":76}]
[34,{"$f":"+'Beitrag PM2'!B22","v":1.07},{"$f":"+'Beitrag PM2'!C22","v":7.0000000000000007E-2},null,null,null,{"$f":"IF((G36+2)<61,G36+2,61)","v":50},{"$f":"H36+L37","v":70},{"$f":"I36+M37","v":114.6},{"$f":"J36-L37","v":80},{"$f":"VLOOKUP(G37,A$3:D$64,3,FALSE)*J37","v":5.6000000000000005},{"$f":"M12","v":10},{"$f":"VLOOKUP(G37,A$3:D$64,2,FALSE)*L37","v":20.099999999999998},{"$f":"I37+K37","v":120.19999999999999},null,null,{"$f":"IF(R37=\" \",\" \",O10+2)","v":2025},{"$f":"IF(U37=51,V37,R36)","v":83},{"$f":"S36","v":228},null,{"$f":"U36+1","v":45},{"$f":"W37+X37","v":83},{"$f":"VLOOKUP(U37,A3:C93,3,FALSE)*H7","v":7.0000000000000009},{"$f":"X36","v":76}]
[35,{"$f":"+'Beitrag PM2'!B23","v":1.1100000000000001},{"$f":"+'Beitrag PM2'!C23","v":7.0000000000000007E-2},null,null,null,{"$f":"IF((G37+2)<61,G37+2,61)","v":52},{"$f":"H37+L38","v":80},136.5,{"$f":"J37-L38","v":70},{"$f":"VLOOKUP(G38,A$3:D$64,3,FALSE)*J38","v":14.7},{"$f":"M13","v":10},{"$f":"VLOOKUP(G38,A$3:D$64,2,FALSE)*L38","v":21.9},{"$f":"I38+K38","v":151.19999999999999},null,null,{"$f":"IF(R38=\" \",\" \",O10+3)","v":2026},83,228,null,46,83,{"$f":"VLOOKUP(U38,A3:C93,3,FALSE)*H7","v":7.0000000000000009},{"$f":"X37","v":76}]
[36,{"$f":"+'Beitrag PM2'!B24","v":1.1599999999999999},{"$f":"+'Beitrag PM2'!C24","v":7.0000000000000007E-2},null,null,null,54,90,160.4,60,12.6,10,23.900000000000002,173,null,null,{"$f":"IF(R39=\" \",\" \",O10+4)","v":2027},83,228,null,47,83,{"$f":"VLOOKUP(U39,A3:C93,3,FALSE)*H7","v":7.0000000000000009},{"$f":"X38","v":76}]
[37,{"$f":"+'Beitrag PM2'!B25","v":1.2},{"$f":"+'Beitrag PM2'!C25","v":7.0000000000000007E-2},null,null,null,56,100,186.5,50,10.5,10,26.099999999999998,197,null,null,{"$f":"IF(R40=\"-\",\"-\",P11)","v":"ab 2028"},{"$f":"IF(Q11=R35,\"-\",IF(R35=\"-\",\"-\",Q11))","v":100.8},{"$f":"IF(R40=\"-\",\"-\",S35)","v":228}]
[38,{"$f":"+'Beitrag PM2'!B26","v":1.25},{"$f":"+'Beitrag PM2'!C26","v":7.0000000000000007E-2},null,null,null,58,110,215,40,8.4,10,28.5,223.4,null,null,{"$f":"IF(R41=\"-\",\"-\",P12)","v":"ab 2030"},{"$f":"IF(Q12=R40,\"-\",IF(R40=\"-\",\"-\",Q12))","v":120.19999999999999},{"$f":"IF(R41=\"-\",\"-\",S40)","v":228}]
[39,{"$f":"+'Beitrag PM2'!B27","v":1.3},{"$f":"+'Beitrag PM2'!C27","v":7.0000000000000007E-2},null,null,null,60,120,246.4,30,6.3,10,31.400000000000002,252.70000000000002,null,null,{"$f":"IF(R42=\"-\",\"-\",P13)","v":"ab 2032"},{"$f":"IF(Q13=R41,\"-\",IF(R41=\"-\",\"-\",Q13))","v":151.19999999999999},{"$f":"IF(R42=\"-\",\"-\",S41)","v":228}]
[40,{"$f":"+'Beitrag PM2'!B28","v":1.35},{"$f":"+'Beitrag PM2'!C28","v":7.0000000000000007E-2},null,null,null,61,150,345.1,0,{"$error":"#VALUE!"},30,98.7,{"$error":"#VALUE!"},null,null,{"$f":"IF(R43=\"-\",\"-\",P14)","v":"ab 2034"},{"$f":"IF(Q14=R42,\"-\",IF(R42=\"-\",\"-\",Q14))","v":173},{"$f":"IF(R43=\"-\",\"-\",S42)","v":228}]
[41,{"$f":"+'Beitrag PM2'!B29","v":1.4},{"$f":"+'Beitrag PM2'!C29","v":7.0000000000000007E-2},null,null,null,61,150,345.1,0,{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},null,null,{"$f":"IF(R44=\"-\",\"-\",P15)","v":"ab 2036"},{"$f":"IF(Q15=R43,\"-\",IF(R43=\"-\",\"-\",Q15))","v":197},{"$f":"IF(R44=\"-\",\"-\",S43)","v":228}]
[42,{"$f":"+'Beitrag PM2'!B30","v":1.46},{"$f":"+'Beitrag PM2'!C30","v":7.0000000000000007E-2},null,null,null,61,150,345.1,0,{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},null,null,"ab 2038",223.4,228]
[43,{"$f":"+'Beitrag PM2'!B31","v":1.52},{"$f":"+'Beitrag PM2'!C31","v":7.0000000000000007E-2},null,null,null,61,150,345.1,0,{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},null,null,"ab 2040",252.70000000000002,228]
[44,{"$f":"+'Beitrag PM2'!B32","v":1.58},{"$f":"+'Beitrag PM2'!C32","v":7.0000000000000007E-2},null,null,null,61,150,345.1,0,{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[45,{"$f":"+'Beitrag PM2'!B33","v":1.64},{"$f":"+'Beitrag PM2'!C33","v":7.0000000000000007E-2},null,null,null,61,150,345.1,0,{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[46,{"$f":"+'Beitrag PM2'!B34","v":1.71},{"$f":"+'Beitrag PM2'!C34","v":7.0000000000000007E-2},null,null,null,61,150,345.1,0,{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[47,{"$f":"+'Beitrag PM2'!B35","v":1.78},{"$f":"+'Beitrag PM2'!C35","v":7.0000000000000007E-2},null,null,null,61,150,345.1,0,{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[48,{"$f":"+'Beitrag PM2'!B36","v":1.85},{"$f":"+'Beitrag PM2'!C36","v":7.0000000000000007E-2},null,null,null,61,150,345.1,0,{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[49,{"$f":"+'Beitrag PM2'!B37","v":1.93},{"$f":"+'Beitrag PM2'!C37","v":7.0000000000000007E-2},null,null,null,61,150,345.1,0,{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[50,{"$f":"+'Beitrag PM2'!B38","v":2.0099999999999998},{"$f":"+'Beitrag PM2'!C38","v":7.0000000000000007E-2},null,null,null,61,150,345.1,0,{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[51,{"$f":"+'Beitrag PM2'!B39","v":2.1},{"$f":"+'Beitrag PM2'!C39","v":0.21},null,null,null,61,{"$f":"H53+L54","v":150},345.1,0,{"$error":"#VALUE!"},0,0,{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[52,{"$f":"+'Beitrag PM2'!B40","v":2.19},{"$f":"+'Beitrag PM2'!C40","v":0.21}]
[53,{"$f":"+'Beitrag PM2'!B41","v":2.2799999999999998},{"$f":"+'Beitrag PM2'!C41","v":0.21}]
[54,{"$f":"+'Beitrag PM2'!B42","v":2.39},{"$f":"+'Beitrag PM2'!C42","v":0.21}]
[55,{"$f":"+'Beitrag PM2'!B43","v":2.4900000000000002},{"$f":"+'Beitrag PM2'!C43","v":0.21}]
[56,{"$f":"+'Beitrag PM2'!B44","v":2.61},{"$f":"+'Beitrag PM2'!C44","v":0.21}]
[57,{"$f":"+'Beitrag PM2'!B45","v":2.73},{"$f":"+'Beitrag PM2'!C45","v":0.21}]
[58,{"$f":"+'Beitrag PM2'!B46","v":2.85},{"$f":"+'Beitrag PM2'!C46","v":0.21}]
[59,{"$f":"+'Beitrag PM2'!B47","v":2.99},{"$f":"+'Beitrag PM2'!C47","v":0.21}]
[60,{"$f":"+'Beitrag PM2'!B48","v":3.14},{"$f":"+'Beitrag PM2'!C48","v":0.21}]
[61,{"$f":"+'Beitrag PM2'!B49","v":3.29},{"$f":"+'Beitrag PM2'!C49","v":"-"}]
[62,{"$f":"+'Beitrag PM2'!B50","v":3.46},{"$f":"+'Beitrag PM2'!C50","v":"-"}]
[63,{"$f":"+'Beitrag PM2'!B51","v":3.64},{"$f":"+'Beitrag PM2'!C51","v":"-"}]
[64,{"$f":"+'Beitrag PM2'!B52","v":3.83},{"$f":"+'Beitrag PM2'!C52","v":"-"}]
[65,{"$f":"+'Beitrag PM2'!B53","v":4.04},{"$f":"+'Beitrag PM2'!C53","v":"-"}]
[66,{"$f":"+'Beitrag PM2'!B54","v":4.26},{"$f":"+'Beitrag PM2'!C54","v":"-"}]
[67,{"$f":"+'Beitrag PM2'!B55","v":4.49},{"$f":"+'Beitrag PM2'!C55","v":"-"}]
[68,{"$f":"+'Beitrag PM2'!B56","v":4.74},{"$f":"+'Beitrag PM2'!C56","v":"-"}]
[69,{"$f":"+'Beitrag PM2'!B57","v":5.01},{"$f":"+'Beitrag PM2'!C57","v":"-"}]
[70,{"$f":"+'Beitrag PM2'!B58","v":5.31},{"$f":"+'Beitrag PM2'!C58","v":"-"}]

{"sheet":"Beitrag PM2","index":2,"n_rows":87,"n_cols":3,"rows_kept":87,"cut":false,"hidden":true,"merged":[]}
["Beiträge Tarif OLGAflex Gruppenversicherung"]
[]
[]
["für 1 €","OLGAflex.AR","OLGAflex.Ri"]
["Stand","05.23","05.23"]
["Alter","€","€"]
["0-16",0.39,"-"]
["17-20",0.23,"-"]
[21,0.66,7.0000000000000007E-2]
[22,0.68,7.0000000000000007E-2]
[23,0.71,7.0000000000000007E-2]
[24,0.73,7.0000000000000007E-2]
[25,0.76,7.0000000000000007E-2]
[26,0.79,7.0000000000000007E-2]
[27,0.82,7.0000000000000007E-2]
[28,0.85,7.0000000000000007E-2]
[29,0.88,7.0000000000000007E-2]
[30,0.92,7.0000000000000007E-2]
[31,0.95,7.0000000000000007E-2]
[32,0.99,7.0000000000000007E-2]
[33,1.03,7.0000000000000007E-2]
[34,1.07,7.0000000000000007E-2]
[35,1.1100000000000001,7.0000000000000007E-2]
[36,1.1599999999999999,7.0000000000000007E-2]
[37,1.2,7.0000000000000007E-2]
[38,1.25,7.0000000000000007E-2]
[39,1.3,7.0000000000000007E-2]
[40,1.35,7.0000000000000007E-2]
[41,1.4,7.0000000000000007E-2]
[42,1.46,7.0000000000000007E-2]
[43,1.52,7.0000000000000007E-2]
[44,1.58,7.0000000000000007E-2]
[45,1.64,7.0000000000000007E-2]
[46,1.71,7.0000000000000007E-2]
[47,1.78,7.0000000000000007E-2]
[48,1.85,7.0000000000000007E-2]
[49,1.93,7.0000000000000007E-2]
[50,2.0099999999999998,7.0000000000000007E-2]
[51,2.1,0.21]
[52,2.19,0.21]
[53,2.2799999999999998,0.21]
[54,2.39,0.21]
[55,2.4900000000000002,0.21]
[56,2.61,0.21]
[57,2.73,0.21]
[58,2.85,0.21]
[59,2.99,0.21]
[60,3.14,0.21]
[61,3.29,"-"]
[62,3.46,"-"]
[63,3.64,"-"]
[64,3.83,"-"]
[65,4.04,"-"]
[66,4.26,"-"]
[67,4.49,"-"]
[68,4.74,"-"]
[69,5.01,"-"]
[70,5.31,"-"]
[71,5.63]
[72,5.98]
[73,6.35]
[74,6.77]
[75,7.22]
[76,7.71]
[77,8.25]
[78,8.84]
[79,9.48]
[80,10.17]
[81,10.93]
[82,11.75]
[83,12.63]
[84,13.59]
[85,14.61]
[86,15.7]
[87,16.87]
[88,18.11]
[89,19.420000000000002]
[90,20.81]
[91,22.28]
[92,23.81]
[93,25.42]
[94,27.09]
[95,28.82]
[96,30.6]
[97,32.42]
[98,34.270000000000003]
[99,36.130000000000003]

{"sheet":"Leistungen","index":3,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
["Pflegetageld OLGAflex",{"$f":"IF(Beitrag!H4>150,\"\",Beitrag!H4)","v":150}]
[]
[null,"Ambulant","Stationär"]
["Pflegegrad 1","10 %*","10 %*"]
["Pflegegrad 2","30 %*","100 %*"]
["Pflegegrad 3","70 %*","100 %*"]
["Pflegegrad 4","100 %*","100 %*"]
["Pflegegrad 5","100 %*","100 %*"]
[]
[null,"Ambulant","Stationär"]
["Pflegegrad 1",0.1,0.1]
["Pflegegrad 2",0.3,1]
["Pflegegrad 3",0.7,1]
["Pflegegrad 4",1,1]
["Pflegegrad 5",1,1]
[]
[null,"Ambulant","Stationär"]
["Pflegegrad 1",{"$f":"B14*$B$4*30","v":450},{"$f":"C14*$B$4*30","v":450}]
["Pflegegrad 2",{"$f":"B15*$B$4*30","v":1350},4500]
["Pflegegrad 3",3150,4500]
["Pflegegrad 4",4500,4500]
["Pflegegrad 5",4500,4500]