{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Schnellrechner","Beitrag","Beitragstabelle pm1","Leistungen","Tabelle2"],"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],[17,9,17,10],[26,2,26,12],[15,5,15,10],[5,6,5,7],[5,9,5,13],[7,6,7,7],[9,6,9,7]]}
[]
[]
[null,"OLGAflex Schnellrechner",null,null,null,null,null,null,null,null,null,null,null,null,"Stand: 05.21"]
[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,1990,null,null,{"$f":"YEAR(G10)-G8","v":31},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,"2021-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,0,"≙",{"$f":"CONCATENATE(\"\",H18*30,\" € pro Monat\")","v":"0 € pro Monat"},null,null,{"$f":"Beitrag!I6","v":0},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,150,"≙",{"$f":"CONCATENATE(H20*30,\" € pro Monat\")","v":"4500 € pro Monat"},null,null,{"$f":"Beitrag!I7","v":10.500000000000002},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":10.500000000000002},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":false,"merged":[]}
["Alter","OLGAflex.AR","OLGAflex.Ri","Hinweis: bei BAP Beitrag auf Tab. ",null,null,null,"variable \nEingaben"]
[null,null,null,"\"Beitragstabelle pm1\" austauschen",null,null,"Alter",{"$f":"Schnellrechner!J8","v":31},{"$f":"YEAR(Schnellrechner!G10)","v":2021}]
[0,{"$f":"+'Beitragstabelle pm1'!$B$7","v":0.3},0,"und Beitrag bei Alter 61+ = 0,00 setzen"]
[1,{"$f":"+'Beitragstabelle pm1'!$B$7","v":0.3},0,null,null,null,"Pflegetageld OLGAflex",{"$f":"H6+H7","v":150}]
[2,{"$f":"+'Beitragstabelle pm1'!$B$7","v":0.3},0]
[3,{"$f":"+'Beitragstabelle pm1'!$B$7","v":0.3},0,null,null,null,"OLGAflex.AR",{"$f":"Schnellrechner!$H$18","v":0},{"$f":"IF(H6+H7>150,\"\",VLOOKUP(H2,A3:C93,2,FALSE)*H6)","v":0},{"$f":"VLOOKUP(H2,A3:C93,2,FALSE)*H4","v":127.5}]
[4,{"$f":"+'Beitragstabelle pm1'!$B$7","v":0.3},0,null,null,null,"OLGAflex.Ri",{"$f":"Schnellrechner!$H$20","v":150},{"$f":"IF(H6+H7>150,\"\",VLOOKUP(H2,A3:C93,3,FALSE)*H7)","v":10.500000000000002}]
[5,{"$f":"+'Beitragstabelle pm1'!$B$7","v":0.3},0,null,null,null,"Umstellungen",{"$f":"H7/10","v":15}]
[6,{"$f":"+'Beitragstabelle pm1'!$B$7","v":0.3},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":"+'Beitragstabelle pm1'!$B$7","v":0.3},0,null,null,null,{"$f":"H2","v":31},0,{"$f":"H7","v":150},null,null,null,null,null,{"$f":"I2","v":2021},{"$f":"\"ab \"&O10","v":"ab 2021"},{"$f":"I6+I7","v":10.500000000000002},null,null,{"$f":"J6","v":127.5}]
[8,{"$f":"+'Beitragstabelle pm1'!$B$7","v":0.3},0,null,null,null,{"$f":"IF((G10+5)<61,G10+5,61)","v":36},{"$f":"IF(H$8>1,10,I10)","v":10},{"$f":"I10-H11","v":140},{"$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":9.7000000000000011},{"$f":"O10+(G11-G10)","v":2026},{"$f":"\"ab \"&O11","v":"ab 2026"},{"$f":"Q10+N11","v":20.200000000000003},null,null,{"$f":"T10","v":127.5}]
[9,{"$f":"+'Beitragstabelle pm1'!$B$7","v":0.3},0,null,null,null,{"$f":"IF((G11+2)<61,G11+2,61)","v":38},{"$f":"IF(H$8>2,10,I11)","v":10},{"$f":"I11-H12","v":130},{"$f":"IF(G12>60,I11,H12)","v":10},1,1,{"$f":"J12*K12*L12","v":10},{"$f":"N37-N36","v":10.5},{"$f":"IF((G12-G11)=1,O11+(G12-G11),O11+2)","v":2028},"ab 2028",30.700000000000003,null,null,{"$f":"T11","v":127.5}]
[10,{"$f":"+'Beitragstabelle pm1'!$B$7","v":0.3},0,null,null,null,{"$f":"IF((G12+2)<61,G12+2,61)","v":40},{"$f":"IF(H$8>3,10,I12)","v":10},120,10,1,{"$f":"IF((G13-G10)=0,0,1)","v":1},10,11.499999999999993,{"$f":"IF((G13-G12)=1,O12+(G13-G12),O12+2)","v":2030},"ab 2030",42.199999999999996,null,null,127.5]
[11,{"$f":"+'Beitragstabelle pm1'!$B$7","v":0.3},0,null,null,null,42,{"$f":"IF(H$8>4,10,I13)","v":10},110,{"$f":"IF(G14>60,I13,H14)","v":10},1,1,10,12.500000000000007,2032,"ab 2032",54.7,null,null,127.5]
[12,{"$f":"+'Beitragstabelle pm1'!$B$7","v":0.3},0,null,null,null,44,{"$f":"IF(H$8>5,10,I14)","v":10},100,10,1,1,10,13.599999999999994,2034,"ab 2034",68.3,null,null,127.5]
[13,{"$f":"+'Beitragstabelle pm1'!$B$7","v":0.3},0,null,null,null,46,{"$f":"IF(H$8>6,10,I15)","v":10},90,10,1,1,10,14.799999999999997,2036,"ab 2036",83.1,null,null,127.5]
[14,{"$f":"+'Beitragstabelle pm1'!$B$7","v":0.3},0,null,null,null,48,{"$f":"IF(H$8>7,10,I16)","v":10},80,10,1,1,10,16.099999999999994,2038,"ab 2038",99.199999999999989,null,null,127.5]
[15,{"$f":"+'Beitragstabelle pm1'!$B$7","v":0.3},0,null,null,null,50,{"$f":"IF(H$8>8,10,I17)","v":10},70,10,{"$f":"IF((J17-J18)>9.9,0,1)","v":1},1,10,17.600000000000009,2040,"ab 2040",116.8,null,null,127.5]
[16,{"$f":"+'Beitragstabelle pm1'!$B$7","v":0.3},0,null,null,null,52,{"$f":"IF(H$8>9,10,I18)","v":10},60,10,1,1,10,27.59999999999998,2042,"ab 2042",144.39999999999998,null,null,127.5]
[17,{"$f":"+'Beitragstabelle pm1'!$B$8","v":0.18},0,null,null,null,54,{"$f":"IF(H$8>10,10,I19)","v":10},50,10,1,{"$f":"IF((G20-G17)=0,0,1)","v":1},10,19.599999999999994,2044,"ab 2044",163.99999999999997,null,null,127.5]
[18,{"$f":"+'Beitragstabelle pm1'!$B$8","v":0.18},0,null,null,null,56,{"$f":"IF(H$8>11,10,I20)","v":10},40,10,1,{"$f":"IF((G21-G18)=0,0,1)","v":1},10,21.699999999999989,2046,"ab 2046",185.69999999999996,null,null,127.5]
[19,{"$f":"+'Beitragstabelle pm1'!$B$8","v":0.18},0,null,null,null,58,{"$f":"IF(H$8>12,10,I21)","v":10},30,10,1,1,10,24,2048,"ab 2048",209.69999999999996,null,null,127.5]
[20,{"$f":"+'Beitragstabelle pm1'!$B$8","v":0.18},0,null,null,null,60,{"$f":"IF(H$8>13,10,I22)","v":10},20,10,1,1,10,26.69999999999996,2050,"ab 2050",236.39999999999992,null,null,127.5]
[21,{"$f":"+'Beitragstabelle pm1'!B9","v":0.57999999999999996},{"$f":"+'Beitragstabelle pm1'!C9","v":7.0000000000000007E-2},null,null,null,61,{"$f":"IF(H$8>14,10,I23)","v":10},10,20,1,1,20,56.199999999999989,2051,"ab 2051",292.59999999999991,null,null,127.5]
[22,{"$f":"+'Beitragstabelle pm1'!B10","v":0.61},{"$f":"+'Beitragstabelle pm1'!C10","v":7.0000000000000007E-2},null,null,null,61,{"$f":"IF(H$8>15,10,I24)","v":10},0,10,0,1,0,0,2053,"ab 2053",292.59999999999991,null,null,127.5]
[23,{"$f":"+'Beitragstabelle pm1'!B11","v":0.63},{"$f":"+'Beitragstabelle pm1'!C11","v":7.0000000000000007E-2},null,null,null,61,{"$f":"IF(H$8>16,10,I25)","v":0},0,0,0,1,0,0,2055,"ab 2055",292.59999999999991,null,null,127.5]
[24,{"$f":"+'Beitragstabelle pm1'!B12","v":0.65},{"$f":"+'Beitragstabelle pm1'!C12","v":7.0000000000000007E-2},null,null,null,61,{"$f":"IF(H$8>17,10,I26)","v":0},0,0,1,0,0,0,2057,"ab 2057",292.59999999999991,null,null,127.5]
[25,{"$f":"+'Beitragstabelle pm1'!B13","v":0.68},{"$f":"+'Beitragstabelle pm1'!C13","v":7.0000000000000007E-2},null,null,null,61,{"$f":"IF(H$8>18,10,I27)","v":0},0,0,1,0,0,0,2059,"ab 2059",292.59999999999991,null,null,127.5]
[26,{"$f":"+'Beitragstabelle pm1'!B14","v":0.7},{"$f":"+'Beitragstabelle pm1'!C14","v":7.0000000000000007E-2},null,null,null,61,{"$f":"IF(H$8>19,10,I28)","v":0},0,0,1,0,0,0,2061,"ab 2061",292.59999999999991,null,null,127.5]
[27,{"$f":"+'Beitragstabelle pm1'!B15","v":0.73},{"$f":"+'Beitragstabelle pm1'!C15","v":7.0000000000000007E-2}]
[28,{"$f":"+'Beitragstabelle pm1'!B16","v":0.76},{"$f":"+'Beitragstabelle pm1'!C16","v":7.0000000000000007E-2}]
[29,{"$f":"+'Beitragstabelle pm1'!B17","v":0.79},{"$f":"+'Beitragstabelle pm1'!C17","v":7.0000000000000007E-2}]
[30,{"$f":"+'Beitragstabelle pm1'!B18","v":0.82},{"$f":"+'Beitragstabelle pm1'!C18","v":7.0000000000000007E-2}]
[31,{"$f":"+'Beitragstabelle pm1'!B19","v":0.85},{"$f":"+'Beitragstabelle pm1'!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":"+'Beitragstabelle pm1'!B20","v":0.89},{"$f":"+'Beitragstabelle pm1'!C20","v":7.0000000000000007E-2},null,null,null,{"$f":"H2","v":31},{"$f":"H6","v":0},{"$f":"I6","v":0},{"$f":"H7","v":150},{"$f":"I7","v":10.500000000000002},null,null,{"$f":"I35+K35","v":10.500000000000002},null,null,{"$f":"IF(R35=\" \",\" \",O10)","v":2021},{"$f":"Q10","v":10.500000000000002},{"$f":"T10","v":127.5},null,{"$f":"H2","v":31},null,"Ri","AR"]
[33,{"$f":"+'Beitragstabelle pm1'!B21","v":0.92},{"$f":"+'Beitragstabelle pm1'!C21","v":7.0000000000000007E-2},null,null,null,{"$f":"IF((G35+5)<61,G35+5,61)","v":36},{"$f":"H35+L36","v":10},{"$f":"I35+M36","v":10.4},{"$f":"J35-L36","v":140},{"$f":"VLOOKUP(G36,A$3:D$64,3,FALSE)*J36","v":9.8000000000000007},{"$f":"M11","v":10},{"$f":"VLOOKUP(G36,A$3:D$64,2,FALSE)*L36","v":10.4},{"$f":"I36+K36","v":20.200000000000003},null,null,{"$f":"IF(R36=\" \",\" \",O10+1)","v":2022},{"$f":"IF(U36=51,V36,R35)","v":10.500000000000002},{"$f":"S35","v":127.5},null,{"$f":"U35+1","v":32},{"$f":"W36+X36","v":10.500000000000002},{"$f":"VLOOKUP(U36,A3:C93,3,FALSE)*H7","v":10.500000000000002},{"$f":"VLOOKUP(H2,A3:C93,2,FALSE)*H6","v":0}]
[34,{"$f":"+'Beitragstabelle pm1'!B22","v":0.96},{"$f":"+'Beitragstabelle pm1'!C22","v":7.0000000000000007E-2},null,null,null,{"$f":"IF((G36+2)<61,G36+2,61)","v":38},{"$f":"H36+L37","v":20},{"$f":"I36+M37","v":21.6},{"$f":"J36-L37","v":130},{"$f":"VLOOKUP(G37,A$3:D$64,3,FALSE)*J37","v":9.1000000000000014},{"$f":"M12","v":10},{"$f":"VLOOKUP(G37,A$3:D$64,2,FALSE)*L37","v":11.200000000000001},{"$f":"I37+K37","v":30.700000000000003},null,null,{"$f":"IF(R37=\" \",\" \",O10+2)","v":2023},{"$f":"IF(U37=51,V37,R36)","v":10.500000000000002},{"$f":"S36","v":127.5},null,{"$f":"U36+1","v":33},{"$f":"W37+X37","v":10.500000000000002},{"$f":"VLOOKUP(U37,A3:C93,3,FALSE)*H7","v":10.500000000000002},{"$f":"X36","v":0}]
[35,{"$f":"+'Beitragstabelle pm1'!B23","v":1},{"$f":"+'Beitragstabelle pm1'!C23","v":7.0000000000000007E-2},null,null,null,{"$f":"IF((G37+2)<61,G37+2,61)","v":40},{"$f":"H37+L38","v":30},33.799999999999997,{"$f":"J37-L38","v":120},{"$f":"VLOOKUP(G38,A$3:D$64,3,FALSE)*J38","v":8.4},{"$f":"M13","v":10},{"$f":"VLOOKUP(G38,A$3:D$64,2,FALSE)*L38","v":12.2},{"$f":"I38+K38","v":42.199999999999996},null,null,{"$f":"IF(R38=\" \",\" \",O10+3)","v":2024},10.500000000000002,127.5,null,34,10.500000000000002,{"$f":"VLOOKUP(U38,A3:C93,3,FALSE)*H7","v":10.500000000000002},{"$f":"X37","v":0}]
[36,{"$f":"+'Beitragstabelle pm1'!B24","v":1.04},{"$f":"+'Beitragstabelle pm1'!C24","v":7.0000000000000007E-2},null,null,null,42,40,47,110,{"$f":"VLOOKUP(G39,A$3:D$64,3,FALSE)*J39","v":7.7000000000000011},10,13.200000000000001,54.7,null,null,{"$f":"IF(R39=\" \",\" \",O10+4)","v":2025},10.500000000000002,127.5,null,35,10.500000000000002,{"$f":"VLOOKUP(U39,A3:C93,3,FALSE)*H7","v":10.500000000000002},{"$f":"X38","v":0}]
[37,{"$f":"+'Beitragstabelle pm1'!B25","v":1.08},{"$f":"+'Beitragstabelle pm1'!C25","v":7.0000000000000007E-2},null,null,null,44,50,61.3,100,7.0000000000000009,10,14.299999999999999,68.3,null,null,{"$f":"IF(R40=\"-\",\"-\",P11)","v":"ab 2026"},{"$f":"IF(Q11=R35,\"-\",IF(R35=\"-\",\"-\",Q11))","v":20.200000000000003},{"$f":"IF(R40=\"-\",\"-\",S35)","v":127.5}]
[38,{"$f":"+'Beitragstabelle pm1'!B26","v":1.1200000000000001},{"$f":"+'Beitragstabelle pm1'!C26","v":7.0000000000000007E-2},null,null,null,46,60,76.8,90,6.3000000000000007,10,15.5,83.1,null,null,{"$f":"IF(R41=\"-\",\"-\",P12)","v":"ab 2028"},{"$f":"IF(Q12=R40,\"-\",IF(R40=\"-\",\"-\",Q12))","v":30.700000000000003},{"$f":"IF(R41=\"-\",\"-\",S40)","v":127.5}]
[39,{"$f":"+'Beitragstabelle pm1'!B27","v":1.17},{"$f":"+'Beitragstabelle pm1'!C27","v":7.0000000000000007E-2},null,null,null,48,70,93.6,80,5.6000000000000005,10,16.8,99.199999999999989,null,null,{"$f":"IF(R42=\"-\",\"-\",P13)","v":"ab 2030"},{"$f":"IF(Q13=R41,\"-\",IF(R41=\"-\",\"-\",Q13))","v":42.199999999999996},{"$f":"IF(R42=\"-\",\"-\",S41)","v":127.5}]
[40,{"$f":"+'Beitragstabelle pm1'!B28","v":1.22},{"$f":"+'Beitragstabelle pm1'!C28","v":7.0000000000000007E-2},null,null,null,50,80,111.89999999999999,70,4.9000000000000004,10,18.3,116.8,null,null,{"$f":"IF(R43=\"-\",\"-\",P14)","v":"ab 2032"},{"$f":"IF(Q14=R42,\"-\",IF(R42=\"-\",\"-\",Q14))","v":54.7},{"$f":"IF(R43=\"-\",\"-\",S42)","v":127.5}]
[41,{"$f":"+'Beitragstabelle pm1'!B29","v":1.27},{"$f":"+'Beitragstabelle pm1'!C29","v":7.0000000000000007E-2},null,null,null,52,90,131.79999999999998,60,12.6,10,19.899999999999999,144.39999999999998,null,null,{"$f":"IF(R44=\"-\",\"-\",P15)","v":"ab 2034"},{"$f":"IF(Q15=R43,\"-\",IF(R43=\"-\",\"-\",Q15))","v":68.3},{"$f":"IF(R44=\"-\",\"-\",S43)","v":127.5}]
[42,{"$f":"+'Beitragstabelle pm1'!B30","v":1.32},{"$f":"+'Beitragstabelle pm1'!C30","v":7.0000000000000007E-2},null,null,null,54,100,153.49999999999997,50,10.5,10,21.7,163.99999999999997,null,null,"ab 2036",83.1,127.5]
[43,{"$f":"+'Beitragstabelle pm1'!B31","v":1.37},{"$f":"+'Beitragstabelle pm1'!C31","v":7.0000000000000007E-2},null,null,null,56,110,177.29999999999995,40,8.4,10,23.799999999999997,185.69999999999996,null,null,"ab 2038",99.199999999999989,127.5]
[44,{"$f":"+'Beitragstabelle pm1'!B32","v":1.43},{"$f":"+'Beitragstabelle pm1'!C32","v":7.0000000000000007E-2},null,null,null,58,120,203.39999999999995,30,6.3,10,26.099999999999998,209.69999999999996,null,null,"ab 2040",116.8,127.5]
[45,{"$f":"+'Beitragstabelle pm1'!B33","v":1.48},{"$f":"+'Beitragstabelle pm1'!C33","v":7.0000000000000007E-2},null,null,null,60,130,232.19999999999993,20,4.2,10,28.799999999999997,236.39999999999992,null,null,"ab 2042",144.39999999999998,127.5]
[46,{"$f":"+'Beitragstabelle pm1'!B34","v":1.55},{"$f":"+'Beitragstabelle pm1'!C34","v":7.0000000000000007E-2},null,null,null,61,150,292.59999999999991,0,0,20,60.4,292.59999999999991,null,null,"ab 2044",163.99999999999997,127.5]
[47,{"$f":"+'Beitragstabelle pm1'!B35","v":1.61},{"$f":"+'Beitragstabelle pm1'!C35","v":7.0000000000000007E-2},null,null,null,61,150,292.59999999999991,0,0,0,0,292.59999999999991,null,null,"ab 2046",185.69999999999996,127.5]
[48,{"$f":"+'Beitragstabelle pm1'!B36","v":1.68},{"$f":"+'Beitragstabelle pm1'!C36","v":7.0000000000000007E-2},null,null,null,61,150,292.59999999999991,0,0,0,0,292.59999999999991,null,null,"ab 2048",209.69999999999996,127.5]
[49,{"$f":"+'Beitragstabelle pm1'!B37","v":1.75},{"$f":"+'Beitragstabelle pm1'!C37","v":7.0000000000000007E-2},null,null,null,61,150,292.59999999999991,0,0,0,0,292.59999999999991,null,null,"ab 2050",236.39999999999992,127.5]
[50,{"$f":"+'Beitragstabelle pm1'!B38","v":1.83},{"$f":"+'Beitragstabelle pm1'!C38","v":7.0000000000000007E-2},null,null,null,61,150,292.59999999999991,0,0,0,0,292.59999999999991,null,null,"ab 2051",292.59999999999991,127.5]
[51,{"$f":"+'Beitragstabelle pm1'!B39","v":1.91},{"$f":"+'Beitragstabelle pm1'!C39","v":0.21},null,null,null,61,{"$f":"H53+L54","v":150},292.59999999999991,0,0,0,0,292.59999999999991,null,null,"-","-","-"]
[52,{"$f":"+'Beitragstabelle pm1'!B40","v":1.99},{"$f":"+'Beitragstabelle pm1'!C40","v":0.21}]
[53,{"$f":"+'Beitragstabelle pm1'!B41","v":2.08},{"$f":"+'Beitragstabelle pm1'!C41","v":0.21}]
[54,{"$f":"+'Beitragstabelle pm1'!B42","v":2.17},{"$f":"+'Beitragstabelle pm1'!C42","v":0.21}]
[55,{"$f":"+'Beitragstabelle pm1'!B43","v":2.27},{"$f":"+'Beitragstabelle pm1'!C43","v":0.21}]
[56,{"$f":"+'Beitragstabelle pm1'!B44","v":2.38},{"$f":"+'Beitragstabelle pm1'!C44","v":0.21}]
[57,{"$f":"+'Beitragstabelle pm1'!B45","v":2.4900000000000002},{"$f":"+'Beitragstabelle pm1'!C45","v":0.21}]
[58,{"$f":"+'Beitragstabelle pm1'!B46","v":2.61},{"$f":"+'Beitragstabelle pm1'!C46","v":0.21}]
[59,{"$f":"+'Beitragstabelle pm1'!B47","v":2.74},{"$f":"+'Beitragstabelle pm1'!C47","v":0.21}]
[60,{"$f":"+'Beitragstabelle pm1'!B48","v":2.88},{"$f":"+'Beitragstabelle pm1'!C48","v":0.21}]
[61,{"$f":"+'Beitragstabelle pm1'!B49","v":3.02},0]
[62,{"$f":"+'Beitragstabelle pm1'!B50","v":3.17},{"$f":"+'Beitragstabelle pm1'!C50","v":0}]
[63,{"$f":"+'Beitragstabelle pm1'!B51","v":3.34},{"$f":"+'Beitragstabelle pm1'!C51","v":0}]
[64,{"$f":"+'Beitragstabelle pm1'!B52","v":3.52},{"$f":"+'Beitragstabelle pm1'!C52","v":0}]
[65,{"$f":"+'Beitragstabelle pm1'!B53","v":3.72},{"$f":"+'Beitragstabelle pm1'!C53","v":0}]
[66,{"$f":"+'Beitragstabelle pm1'!B54","v":3.92},{"$f":"+'Beitragstabelle pm1'!C54","v":0}]
[67,{"$f":"+'Beitragstabelle pm1'!B55","v":4.1399999999999997},{"$f":"+'Beitragstabelle pm1'!C55","v":0}]
[68,{"$f":"+'Beitragstabelle pm1'!B56","v":4.38},{"$f":"+'Beitragstabelle pm1'!C56","v":0}]
[69,{"$f":"+'Beitragstabelle pm1'!B57","v":4.63},{"$f":"+'Beitragstabelle pm1'!C57","v":0}]
[70,{"$f":"+'Beitragstabelle pm1'!B58","v":4.91},{"$f":"+'Beitragstabelle pm1'!C58","v":0}]

{"sheet":"Beitragstabelle pm1","index":2,"n_rows":59,"n_cols":3,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
["Beiträge Tarif OLGAflex Einzelversicherung"]
[]
[]
["für 1 €","OLGAflex.AR","OLGAflex.Ri"]
["Stand","05.21","05.21"]
["Alter","€","€"]
["0-16",0.3,"-"]
["17-20",0.18,"-"]
[21,0.57999999999999996,7.0000000000000007E-2]
[22,0.61,7.0000000000000007E-2]
[23,0.63,7.0000000000000007E-2]
[24,0.65,7.0000000000000007E-2]
[25,0.68,7.0000000000000007E-2]
[26,0.7,7.0000000000000007E-2]
[27,0.73,7.0000000000000007E-2]
[28,0.76,7.0000000000000007E-2]
[29,0.79,7.0000000000000007E-2]
[30,0.82,7.0000000000000007E-2]
[31,0.85,7.0000000000000007E-2]
[32,0.89,7.0000000000000007E-2]
[33,0.92,7.0000000000000007E-2]
[34,0.96,7.0000000000000007E-2]
[35,1,7.0000000000000007E-2]
[36,1.04,7.0000000000000007E-2]
[37,1.08,7.0000000000000007E-2]
[38,1.1200000000000001,7.0000000000000007E-2]
[39,1.17,7.0000000000000007E-2]
[40,1.22,7.0000000000000007E-2]
[41,1.27,7.0000000000000007E-2]
[42,1.32,7.0000000000000007E-2]
[43,1.37,7.0000000000000007E-2]
[44,1.43,7.0000000000000007E-2]
[45,1.48,7.0000000000000007E-2]
[46,1.55,7.0000000000000007E-2]
[47,1.61,7.0000000000000007E-2]
[48,1.68,7.0000000000000007E-2]
[49,1.75,7.0000000000000007E-2]
[50,1.83,7.0000000000000007E-2]
[51,1.91,0.21]
[52,1.99,0.21]
[53,2.08,0.21]
[54,2.17,0.21]
[55,2.27,0.21]
[56,2.38,0.21]
[57,2.4900000000000002,0.21]
[58,2.61,0.21]
[59,2.74,0.21]
[60,2.88,0.21]
[61,3.02,0]
[62,3.17,0]
[63,3.34,0]
[64,3.52,0]
[65,3.72,0]
[66,3.92,0]
[67,4.1399999999999997,0]
[68,4.38,0]
[69,4.63,0]
[70,4.91,0]
[null,null,0]

{"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]

{"sheet":"Tabelle2","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}