{"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:",null,null,"              Votre indice:…..    "]
[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,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":0}]
[]
[null,null,"2 - Calcul du coût: "]
[]
[null,null,"Nombre de trimestres que vous souhaitez racheter",null,null,null,null,{"$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ées 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":0},{"$f":"IF(H13=\"\",\"\",IFERROR(VLOOKUP(D13,'Table taux'!A3:B42,2,),\"\"))","v":""},{"$f":"IFERROR(SUM(G24*H24),\"\")","v":""},{"$f":"G19","v":0},{"$f":"IFERROR(I24*J24,\"\")","v":""}]
[null,null,"Option 2: Augmentation de la durée d'assurance",null,null,null,{"$f":"IFERROR(H$15,\"\")","v":0},{"$f":"IF(H13=\"\",\"\",IFERROR(VLOOKUP(D13,'Table taux'!A3:C42,3,),\"\"))","v":""},{"$f":"IFERROR(SUM(G25*H25),\"\")","v":""},{"$f":"G19","v":0},{"$f":"IFERROR(I25*J25,\"\")","v":""}]
[null,null,"Option 3: Augmentation taux de Liquidation et durée d'assurance",null,null,null,{"$f":"IFERROR(H$15,\"\")","v":0},{"$f":"IF(H13=\"\",\"\",IFERROR(VLOOKUP(D13,'Table taux'!A3:D42,4,),\"\"))","v":""},{"$f":"IFERROR(SUM(G26*H26),\"\")","v":""},{"$f":"G19","v":0},{"$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/2024"]
[0,0,null,"INFO:"]
[180,16147,null,"Tables aux 01/07/2024"]
[182,16282]
[190,16824]
[200,17502]
[209,18111]
[210,18179]
[218,18721]
[226,19263]
[230,19534]
[233,19737]
[239,20144]
[240,20212]
[245,20550]
[248,20754]
[250,20889]
[253,21092]
[255,21228]
[258,21431]
[260,21567]
[263,21770]
[265,21905]
[266,21973]
[270,22244]
[271,22312]
[273,22447]
[275,22583]
[280,22922]
[282,23057]
[283,23125]
[284,23193]
[285,23260]
[288,23464]
[292,23735]
[293,23802]
[295,23938]
[296,24006]
[300,24277]
[301,24344]
[302,24412]
[303,24480]
[304,24548]
[305,24615]
[308,24819]
[310,24954]
[313,25157]
[314,25225]
[315,25293]
[318,25496]
[319,25564]
[320,25632]
[321,25699]
[323,25835]
[324,25903]
[325,25970]
[327,26106]
[328,26174]
[330,26309]
[332,26445]
[333,26512]
[334,26580]
[335,26648]
[336,26716]
[337,26783]
[340,26987]
[342,27122]
[344,27258]
[345,27325]
[346,27393]
[347,27461]
[350,27664]
[351,27732]
[352,27800]
[353,27867]
[354,27935]
[355,28003]
[356,28071]
[360,28342]
[363,28545]
[364,28613]
[365,28680]
[366,28748]
[367,28816]
[370,29019]
[371,29087]
[372,29155]
[373,29222]
[374,29290]
[375,29358]
[378,29561]
[380,29697]
[381,29764]
[382,29832]
[383,29900]
[384,29968]
[385,30035]
[386,30103]
[388,30239]
[389,30306]
[390,30374]
[392,30510]
[394,30645]
[395,30713]
[396,30781]
[397,30848]
[399,30984]
[400,31052]
[404,31323]
[405,31390]
[406,31458]
[407,31526]
[408,31594]
[410,31729]
[411,31797]
[414,32000]
[415,32068]
[416,32136]
[417,32203]
[418,32271]
[420,32407]
[424,32678]
[425,32745]
[426,32813]
[430,33084]
[435,33423]
[437,33558]
[439,33694]
[440,33762]
[443,33965]
[445,34100]
[449,34371]
[450,34439]
[451,34507]
[455,34778]
[456,34846]
[459,35049]
[460,35117]
[461,35184]
[463,35320]
[465,35455]
[468,35659]
[470,35794]
[471,35862]
[473,35997]
[474,36065]
[475,36133]
[478,36336]
[480,36472]
[482,36607]
[483,36675]
[485,36810]
[487,36946]
[488,37014]
[489,37081]
[490,37149]
[491,37217]
[493,37352]
[495,37488]
[496,37556]
[498,37691]
[500,37827]
[501,37894]
[502,37962]
[503,38030]
[504,38098]
[505,38165]
[506,38233]
[510,38504]
[512,38640]
[514,38775]
[515,38843]
[517,38978]
[520,39182]
[522,39317]
[523,39385]
[525,39520]
[527,39656]
[530,39859]
[532,39995]
[533,40062]
[535,40198]
[540,40537]
[542,40672]
[543,40740]
[545,40875]
[548,41079]
[550,41214]
[553,41417]
[555,41553]
[556,41621]
[560,41892]
[562,42027]
[563,42095]
[564,42163]
[565,42230]
[570,42569]
[571,42637]
[572,42705]
[575,42908]
[579,43179]
[580,43247]
[585,43585]
[586,43653]
[587,43721]
[590,43924]
[594,44195]
[595,44263]
[596,44331]
[600,44602]
[601,44669]
[609,45211]
[610,45279]
[615,45618]
[617,45753]
[620,45957]
[625,46296]
[630,46634]
[635,46973]
[636,47041]
[640,47312]
[645,47651]
[650,47989]
[655,48328]
[660,48667]
[665,49006]
[670,49344]
[675,49683]
[680,50022]
[685,50361]
[690,50699]
[695,51038]
[700,51377]
[705,51716]
[710,52054]
[715,52393]
[720,52732]
[730,53409]
[735,53748]
[740,54087]
[750,54764]
[755,55103]
[760,55442]
[770,56119]
[775,56458]
[780,56797]
[785,57136]
[790,57474]
[795,57813]
[800,58152]
[810,58829]
[815,59168]
[820,59507]
[830,60184]
[836,60591]
[840,60862]
[855,61878]
[858,62081]
[869,62827]
[870,62894]
[880,63572]
[881,63640]
[892,64385]
[895,64588]
[900,64927]
[903,65130]
[914,65875]
[916,66011]
[925,66621]
[937,67434]
[940,67637]
[948,68179]
[959,68924]
[963,69195]
[970,69669]
[980,70347]
[985,70686]
[1000,71702]
[1004,71973]
[1016,72786]
[1020,73057]
[1038,74276]
[1040,74412]
[1058,75631]
[1078,76986]
[1080,77122]
[1086,77528]
[1115,79493]
[1138,81051]
[1139,81119]
[1140,81187]
[1164,82813]
[1180,83897]
[1182,84032]
[1190,84574]
[1198,85116]
[1217,86404]
[1242,88097]
[1245,88301]
[1270,89994]
[1302,92163]
[1305,92366]
[1309,92637]
[1320,93382]
[1330,94060]
[1340,94737]
[1356,95821]
[1362,96228]
[1369,96702]
[1375,97108]
[1502,105713]
[1505,105916]
[1588,111539]
[1635,114723]
[1667,116891]
[1761,123260]
[2028,141349]
[2069,144127]
[2079,144805]
[2110,146905]
[2151,149683]
[2192,152460]
[2233,155238]
[2272,157880]
[2274,158016]
[2291,159168]
[2292,159235]
[2315,160794]
[2356,163571]
[2372,164655]
[2397,166349]
[2413,167433]
[2438,169127]
[2454,170211]
[2479,171905]
[2495,172989]
[2504,173598]
[2520,174682]
[2536,175766]
[2561,177460]
[2577,178544]
[2602,180238]
[2618,181322]
[2643,183016]
[2644,183083]
[2659,184100]
[2685,185861]
[2700,186878]
[2726,188639]
[2741,189655]
[2767,191417]
[2782,192433]
[2808,194195]
[2823,195211]
[2849,196972]
[2890,199750]
[2916,201512]
[2931,202528]
[2957,204289]
[2972,205306]
[2998,207067]
[3013,208083]
[3039,209845]
[3080,212623]
[3121,215400]
[3162,218178]
[3203,220956]
[3229,222717]
[3270,225495]
[3311,228273]
[3352,231051]
[3393,233829]