{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Utilisation du simulateur","Simulateur","Table taux","Simulateur 2","Indice"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":2,"comments":0,"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":"Utilisation du simulateur","index":0,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,14],[17,1,17,14],[25,1,25,14],[26,1,26,14],[15,1,15,14],[16,1,16,14],[19,1,19,14],[20,1,20,14]]}
[]
[null,"Simulateur de rachat des études supérieures"]
[]
[]
[null,"1. Source"]
[]
[null,"Les règles de détermination des trimestres d'études supérieures rachetables sont définies par le décret n°2003-1308 du 26 décembre 2003."]
[]
[null,"2. Utilisation du simulateur"]
[]
[null,"1ère étape, Bloc \"Votre Situation\":"]
[null,"Saisissez votre âge au moment du rachat et votre indice actuel."]
[]
[]
[null,"2ème étape, Bloc \"Calcul du coût\":"]
[null,"Saisissez le nombre de trimestres que vous souhaitez racheter, le coût afférent à chaque type de rachat apparait instantanément."]

{"sheet":"Simulateur","index":1,"n_rows":60,"n_cols":15,"rows_kept":60,"cut":false,"hidden":true,"merged":[[54,1,54,11],[6,2,6,10],[12,4,12,6],[43,2,43,5],[44,2,44,5],[45,2,45,5],[46,2,46,5],[23,9,23,11],[22,2,22,6],[48,8,49,10],[52,3,52,6],[52,8,52,9]]}
[]
[]
[]
[]
[]
[]
[null,null,"Simulateur de rachat des études supérieures"]
[]
[null,null,"1 - Votre situation:  "]
[]
[null,null,"Saisissez votre âge et votre traitement de référence"]
[]
[null,null,"Votre âge:",null,"                           Votre traitement de référence:",null,null,null,"Euros"]
[]
[null,null,{"$f":"IF(D13=\"\",\"\",IF(D13<20,\"Attention, l'âge saisie doit être compris entre 20 et 59 ans.\",IF(D13>59,\"Attention, l'âge saisie doit être compris entre 20 et 59 ans.\",\"\")))","v":""}]
[]
[null,null,"2 - Trimestres à racheter"]
[]
[null,null,"Saisissez vos dates d'études ainsi que les trimestres cotisées durant ces périodes"]
[]
[null,null,"Avez-vous déjà racheter des trimestres dans le passé? Si oui, combien: ",null,null,null,null,0]
[]
[]
[null,null,null,null,null,null,null,null,"Rachetables","Nombre de trimestres déjà rachetés**:",null,null,null,"Disponibles","Rachetables"]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR((IF(G25-H25<0,\"\",IF(H25=\"\",\"\",INT(G25-H25)))),\"\")","v":""},null,null,null,null,{"$f":"IF(H25=\"\",\"\",IF(G25-H25<0,0,G25-H25))","v":""},{"$f":"IF(N25=\"\",\"\",IF(N25>=G25,G25,N25))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR((IF(G26-H26<0,\"\",IF(H26=\"\",\"\",INT(G26-H26)))),\"\")","v":""},null,null,null,null,{"$f":"IF(F26=\"\",\"\",IF(G26-H26<0,0,G26-H26))","v":""},{"$f":"IF(N26=\"\",\"\",IF(N26>=G26,INT(G26),INT(N26)))","v":""}]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,"",null,null,null,null,"",""]
[null,null,null,null,null,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":"IF(E32-D32<0,\"\",IF(AND(C32<>\"\",D32<>\"\",E32<>\"\"),E32-D32+1,\"\"))","v":""},{"$f":"IF(F32=\"\",\"\",ROUNDDOWN((F32/90),0))","v":""},null,"",null,null,null,null,"",""]
[null,null,null,null,null,{"$f":"IF(E33-D33<0,\"\",IF(AND(C33<>\"\",D33<>\"\",E33<>\"\"),E33-D33+1,\"\"))","v":""},{"$f":"IF(F33=\"\",\"\",ROUNDDOWN((F33/90),0))","v":""},null,"",null,null,null,null,"",""]
[null,null,null,null,null,null,{"$f":"IF(F34=\"\",\"\",ROUNDDOWN((F34/90),0))","v":""},null,{"$f":"INT(O34)","v":0},null,null,null,null,"",{"$f":"SUM(O25:O33)","v":0}]
[null,null,{"$f":"IF(E25=\"\",\"\",IF(OR(E25<D25,E26<D26,E27<D27,E28<D28,E29<D29,E30<D30,E31<D31,E32<D32,E33<D33),\"Attention, la date de fin doit être supérieure à la date de début\",\"\"))","v":""},null,null,null,null,"Total",{"$f":"IF((SUM((IF(SUM(I25:I33)>12,12,SUM((I25:I33))))-K26))>0,(SUM((IF(SUM(I25:I33)>12,12,SUM((I25:I33))))-K26)),0)","v":0},null,null,null,null,null,{"$f":"IF(O34<=12,O34,12)","v":0}]
[]
[]
[null,null,"3 - Calcul du coût: "]
[]
[null,null,"Nombre de trimestres que vous pouvez racheter",null,null,null,{"$f":"I35","v":0},{"$f":"IF(G40>12,\"Le nombre de trimestres doit être compris entre 1 et 12 \",\"\")","v":""}]
[]
[null,null,"Répartissez le nombre de trimestres que vous pouvez racheter"]
[]
[null,null,"Les coûts sont données en Euros",null,null,null,"Traitement","x      Taux","Coût unitaire",null,"Total"]
[null,null,"Option 1: Augmentation du taux de liquidation***",null,null,null,{"$f":"IFERROR(H13,\"\")","v":0},{"$f":"IF(H13=\"\",\"\",IFERROR(VLOOKUP(D13,'Table taux'!A3:B42,2,),\"\"))","v":""},{"$f":"IFERROR(SUM(G45*H45),\"\")","v":""},null,{"$f":"IFERROR(I45*J45,\"\")","v":""}]
[null,null,"Option 2: Augmentation de la durée d'assurance***",null,null,null,{"$f":"IFERROR(H13,\"\")","v":0},{"$f":"IF(H13=\"\",\"\",IFERROR(VLOOKUP(D13,'Table taux'!A3:C42,3,),\"\"))","v":""},{"$f":"IFERROR(SUM(G46*H46),\"\")","v":""},null,{"$f":"IFERROR(I46*J46,\"\")","v":""}]
[null,null,"Option 3: Augmentation taux de Liquidation et durée d'assurance** * ",null,null,null,{"$f":"IFERROR(H13,\"\")","v":0},{"$f":"IF(H13=\"\",\"\",IFERROR(VLOOKUP(D13,'Table taux'!A3:D42,4,),\"\"))","v":""},{"$f":"IFERROR(SUM(G47*H47),\"\")","v":""},null,{"$f":"IFERROR(I47*J47,\"\")","v":""}]
[null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(J45:J47)","v":0},{"$f":"IFERROR(SUM(K45:K47),\"\")","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(J48<G40,\"\",IF(J48=G40,\"\",\"Le total de la répartition doit être inférieur ou égal au nombre de trimestres à racheter\"))","v":""}]
[]
[]
[]
[null,null,null,"Le coût de votre rachat sera donc de",null,null,null,{"$f":"K48","v":0},"Euros"]
[]
[null,"Ce calcul est réalisé sur la base de renseignements que vous avez saisis. Le résultat est donné à titre indicatif et sans engagement du Groupe Caisse des Dépôts."]
[]
[null,"AIDE"]
[null,"(*)","Il s'agit des trimestres d'études pour lesquelles vous avez cotisé."]
[null,"(**)","Saisir la totalité des trimestes rachetés dans le passé (toute période confondue)"]
[null,"(***)","Article 3.B du décret 2003-1308 du 26 décembre 2003"]

{"sheet":"Table taux","index":2,"n_rows":42,"n_cols":4,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
[]
["Age","T1","T2","T3"]
[20,3.1E-2,6.4000000000000001E-2,9.5000000000000001E-2]
[21,3.2000000000000001E-2,6.7000000000000004E-2,0.1]
[22,3.4000000000000002E-2,7.0999999999999994E-2,0.105]
[23,3.5000000000000003E-2,7.3999999999999996E-2,0.11]
[24,3.6999999999999998E-2,7.6999999999999999E-2,0.115]
[25,3.7999999999999999E-2,8.1000000000000003E-2,0.12]
[26,0.04,8.4000000000000005E-2,0.125]
[27,4.2000000000000003E-2,8.7999999999999995E-2,0.13]
[28,4.3999999999999997E-2,9.1999999999999998E-2,0.13600000000000001]
[29,4.4999999999999998E-2,9.5000000000000001E-2,0.14099999999999999]
[30,4.7E-2,9.9000000000000005E-2,0.14699999999999999]
[31,4.9000000000000002E-2,0.10299999999999999,0.153]
[32,5.0999999999999997E-2,0.107,0.158]
[33,5.2999999999999999E-2,0.111,0.16400000000000001]
[34,5.5E-2,0.115,0.17]
[35,5.7000000000000002E-2,0.11899999999999999,0.17599999999999999]
[36,5.8000000000000003E-2,0.123,0.182]
[37,0.06,0.127,0.188]
[38,6.2E-2,0.13100000000000001,0.19400000000000001]
[39,6.4000000000000001E-2,0.13500000000000001,0.2]
[40,6.6000000000000003E-2,0.13900000000000001,0.20599999999999999]
[41,6.8000000000000005E-2,0.14299999999999999,0.21199999999999999]
[42,7.0000000000000007E-2,0.14699999999999999,0.218]
[43,7.1999999999999995E-2,0.151,0.224]
[44,7.3999999999999996E-2,0.155,0.22900000000000001]
[45,7.5999999999999998E-2,0.159,0.23499999999999999]
[46,7.6999999999999999E-2,0.16300000000000001,0.24099999999999999]
[47,7.9000000000000001E-2,0.16600000000000001,0.247]
[48,8.1000000000000003E-2,0.17,0.252]
[49,8.3000000000000004E-2,0.17399999999999999,0.25800000000000001]
[50,8.5000000000000006E-2,0.17799999999999999,0.26300000000000001]
[51,8.5999999999999993E-2,0.18099999999999999,0.26800000000000002]
[52,8.7999999999999995E-2,0.185,0.27400000000000002]
[53,8.8999999999999996E-2,0.188,0.27900000000000003]
[54,9.0999999999999998E-2,0.191,0.28399999999999997]
[55,9.2999999999999999E-2,0.19500000000000001,0.28799999999999998]
[56,9.4E-2,0.19800000000000001,0.29299999999999998]
[57,9.6000000000000002E-2,0.20100000000000001,0.29699999999999999]
[58,9.7000000000000003E-2,0.20399999999999999,0.30199999999999999]
[59,9.8000000000000004E-2,0.20599999999999999,0.30599999999999999]

{"sheet":"Simulateur 2","index":3,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,1,32,11],[24,2,24,5],[25,2,25,5],[26,8,27,10],[6,2,6,10],[22,2,22,5],[23,2,23,5],[12,5,12,6]]}
[]
[]
[]
[]
[]
[]
[null,null,"Simulateur de rachat des études supérieures"]
[]
[null,null,"1 - Votre situation:  "]
[]
[null,null,"Saisissez votre âge et votre indice"]
[]
[null,null,"Votre âge:",99,null,"              Votre indice:…..    ",null,750]
[null,null,{"$f":"IF(D13=\"\",\"\",IF(D13<20,\"Attention, l'âge saisi doit être compris entre 20 et 59 ans.\",IF(D13>59,\"Attention, l'âge saisi doit être compris entre 20 et 59 ans.\",\"\")))","v":"Attention, l'âge saisi doit être compris entre 20 et 59 ans."},null,null,null,null,{"$f":"IF(AND(H13>0,G24=\"\"),\"Veuillez saisir un indice valide\",\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IFERROR((VLOOKUP(H13,Indice!A2:B927,2,FALSE)),\"\")","v":55449}]
[]
[null,null,"2 - Calcul du coût: "]
[]
[null,null,"Nombre de trimestres que vous souhaitez racheter",null,null,null,4,{"$f":"IF(G19=\"\",\"\",IF(G19>12,\"Le nombre de trimestres rachetable ne peut être supérieur à 12\",\"\"))","v":""}]
[]
[null,null,"Répartissez le nombre de trimestres que vous pouvez racheter"]
[]
[null,null,"Les coûts sont donnés en Euros",null,null,null,"Traitement","x      Taux","Coût unitaire","Nombre de trimestres","Total (€)"]
[null,null,"Option 1: Augmentation du taux de liquidation",null,null,null,{"$f":"IFERROR(H$15,\"\")","v":55449},{"$f":"IF(H13=\"\",\"\",IFERROR(VLOOKUP(D13,'Table taux'!A3:B42,2,),\"\"))","v":""},{"$f":"IFERROR(SUM(G24*H24),\"\")","v":""},{"$f":"G19","v":4},{"$f":"IFERROR(I24*J24,\"\")","v":""}]
[null,null,"Option 2: Augmentation de la durée d'assurance",null,null,null,{"$f":"IFERROR(H$15,\"\")","v":55449},{"$f":"IF(H13=\"\",\"\",IFERROR(VLOOKUP(D13,'Table taux'!A3:C42,3,),\"\"))","v":""},{"$f":"IFERROR(SUM(G25*H25),\"\")","v":""},{"$f":"G19","v":4},{"$f":"IFERROR(I25*J25,\"\")","v":""}]
[null,null,"Option 3: Augmentation du taux de liquidation et durée d'assurance",null,null,null,{"$f":"IFERROR(H$15,\"\")","v":55449},{"$f":"IF(H13=\"\",\"\",IFERROR(VLOOKUP(D13,'Table taux'!A3:D42,4,),\"\"))","v":""},{"$f":"IFERROR(SUM(G26*H26),\"\")","v":""},{"$f":"G19","v":4},{"$f":"IFERROR(I26*J26,\"\")","v":""}]
[]
[]
[]
[]
[null,"Ce calcul est réalisé sur la base des renseignements que vous avez saisis. Le résultat est donné à titre indicatif et sans engagement du Groupe Caisse des Dépôts."]

{"sheet":"Indice","index":4,"n_rows":372,"n_cols":4,"rows_kept":372,"cut":false,"hidden":true,"merged":[]}
["INDICE","MONTANT ANNUEL 01/07/2025",null,"L'indice du minimum de pension est l'indice 182 au 1er avril 2007 "]
[0,0,null,"revalorisé ensuite selon le barème des pensions."]
[180,16348,null,"Valeur du minimum de pension au 01/11/2024  = 17 115,60 €                                                                                           "]
[182,16486]
[190,17034]
[200,17720]
[209,18338]
[210,18406]
[218,18955]
[226,19504]
[230,19778]
[233,19984]
[239,20396]
[240,20464]
[245,20807]
[248,21013]
[250,21150]
[253,21356]
[255,21493]
[258,21699]
[260,21836]
[263,22042]
[265,22179]
[266,22248]
[270,22522]
[271,22591]
[273,22728]
[275,22865]
[280,23208]
[282,23345]
[283,23414]
[284,23483]
[285,23551]
[288,23757]
[292,24031]
[293,24100]
[295,24237]
[296,24306]
[300,24580]
[301,24649]
[302,24717]
[303,24786]
[304,24854]
[305,24923]
[308,25129]
[310,25266]
[313,25472]
[314,25540]
[315,25609]
[318,25815]
[319,25883]
[320,25952]
[321,26021]
[323,26158]
[324,26226]
[325,26295]
[327,26432]
[328,26501]
[330,26638]
[332,26775]
[333,26844]
[334,26912]
[335,26981]
[336,27050]
[337,27118]
[340,27324]
[342,27461]
[344,27598]
[345,27667]
[346,27736]
[347,27804]
[350,28010]
[351,28079]
[352,28147]
[353,28216]
[354,28284]
[355,28353]
[356,28422]
[360,28696]
[363,28902]
[364,28970]
[365,29039]
[366,29108]
[367,29176]
[370,29382]
[371,29450]
[372,29519]
[373,29588]
[374,29656]
[375,29725]
[378,29931]
[380,30068]
[381,30136]
[382,30205]
[383,30274]
[384,30342]
[385,30411]
[386,30479]
[388,30617]
[389,30685]
[390,30754]
[392,30891]
[394,31028]
[395,31097]
[396,31165]
[397,31234]
[399,31371]
[400,31440]
[404,31714]
[405,31783]
[406,31851]
[407,31920]
[408,31989]
[410,32126]
[411,32194]
[414,32400]
[415,32469]
[416,32537]
[417,32606]
[418,32675]
[420,32812]
[424,33086]
[425,33155]
[426,33223]
[430,33498]
[435,33841]
[437,33978]
[439,34115]
[440,34184]
[443,34389]
[445,34527]
[449,34801]
[450,34870]
[451,34938]
[455,35213]
[456,35281]
[459,35487]
[460,35556]
[461,35624]
[463,35761]
[465,35899]
[468,36104]
[470,36242]
[471,36310]
[473,36447]
[474,36516]
[475,36585]
[478,36790]
[480,36928]
[482,37065]
[483,37133]
[485,37271]
[487,37408]
[488,37476]
[489,37545]
[490,37614]
[491,37682]
[493,37819]
[495,37957]
[496,38025]
[498,38162]
[500,38300]
[501,38368]
[502,38437]
[503,38505]
[504,38574]
[505,38643]
[506,38711]
[510,38986]
[512,39123]
[514,39260]
[515,39328]
[517,39466]
[520,39671]
[522,39809]
[523,39877]
[525,40014]
[527,40152]
[530,40357]
[532,40495]
[533,40563]
[535,40700]
[540,41043]
[542,41181]
[543,41249]
[545,41386]
[548,41592]
[550,41729]
[553,41935]
[555,42072]
[556,42141]
[560,42415]
[562,42553]
[563,42621]
[564,42690]
[565,42758]
[570,43101]
[571,43170]
[572,43239]
[575,43444]
[579,43719]
[580,43787]
[585,44130]
[586,44199]
[587,44267]
[590,44473]
[594,44748]
[595,44816]
[596,44885]
[600,45159]
[601,45228]
[609,45777]
[610,45845]
[615,46188]
[617,46325]
[620,46531]
[625,46874]
[630,47217]
[635,47560]
[636,47629]
[640,47903]
[645,48246]
[650,48589]
[655,48932]
[660,49275]
[665,49618]
[670,49961]
[675,50304]
[680,50647]
[685,50990]
[690,51333]
[695,51676]
[700,52019]
[705,52362]
[710,52705]
[715,53048]
[720,53391]
[730,54077]
[735,54420]
[740,54763]
[750,55449]
[755,55792]
[760,56135]
[770,56821]
[775,57164]
[780,57507]
[785,57850]
[790,58193]
[795,58536]
[800,58879]
[810,59565]
[815,59908]
[820,60251]
[830,60937]
[836,61348]
[840,61623]
[855,62652]
[858,62857]
[869,63612]
[870,63681]
[880,64366]
[881,64435]
[892,65190]
[895,65395]
[900,65738]
[903,65944]
[914,66699]
[916,66836]
[925,67453]
[937,68277]
[940,68482]
[948,69031]
[959,69786]
[963,70060]
[970,70540]
[980,71226]
[985,71569]
[1000,72598]
[1004,72873]
[1016,73696]
[1020,73970]
[1038,75205]
[1040,75342]
[1058,76577]
[1078,77949]
[1080,78086]
[1086,78498]
[1115,80487]
[1138,82065]
[1139,82133]
[1140,82202]
[1164,83848]
[1180,84946]
[1182,85083]
[1190,85632]
[1198,86180]
[1217,87484]
[1242,89199]
[1245,89404]
[1270,91119]
[1302,93315]
[1305,93520]
[1309,93795]
[1320,94549]
[1330,95235]
[1340,95921]
[1356,97019]
[1362,97430]
[1369,97911]
[1375,98322]
[1502,107034]
[1505,107240]
[1588,112933]
[1635,116157]
[1667,118353]
[1761,124801]
[2028,143116]
[2069,145929]
[2079,146615]
[2110,148741]
[2151,151554]
[2192,154366]
[2233,157179]
[2272,159854]
[2274,159991]
[2291,161157]
[2292,161226]
[2315,162804]
[2356,165616]
[2372,166714]
[2397,168429]
[2413,169526]
[2438,171241]
[2454,172339]
[2479,174053]
[2495,175151]
[2504,175768]
[2520,176866]
[2536,177964]
[2561,179678]
[2577,180776]
[2602,182491]
[2618,183589]
[2643,185303]
[2644,185372]
[2659,186401]
[2685,188185]
[2700,189213]
[2726,190997]
[2741,192026]
[2767,193809]
[2782,194838]
[2808,196622]
[2823,197651]
[2849,199434]
[2890,202247]
[2916,204030]
[2931,205059]
[2957,206843]
[2972,207872]
[2998,209655]
[3013,210684]
[3039,212468]
[3080,215280]
[3121,218093]
[3162,220905]
[3203,223718]
[3229,225501]
[3270,228314]
[3311,231126]
[3352,233939]
[3393,236751]