{"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":[[46,2,46,5],[23,9,23,11],[22,2,22,6],[48,8,49,10],[52,3,52,6],[52,8,52,9],[54,1,54,11],[6,2,6,10],[12,4,12,6],[43,2,43,5],[44,2,44,5],[45,2,45,5]]}
[]
[]
[]
[]
[]
[]
[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/2023"]
[0,"0",null,"INFO:"]
[180,15830,null,"Tables aux 01/07/2023"]
[182,15963]
[190,16494]
[200,17158]
[209,17756]
[210,17823]
[218,18354]
[226,18885]
[230,19151]
[233,19350]
[239,19749]
[240,19815]
[245,20147]
[248,20347]
[250,20480]
[253,20679]
[255,20812]
[258,21011]
[260,21144]
[263,21343]
[265,21476]
[266,21542]
[270,21808]
[271,21874]
[273,22007]
[275,22140]
[280,22472]
[282,22605]
[283,22671]
[284,22738]
[285,22804]
[288,23004]
[292,23269]
[293,23336]
[295,23469]
[296,23535]
[300,23801]
[301,23867]
[302,23933]
[303,24000]
[304,24066]
[305,24133]
[308,24332]
[310,24465]
[313,24664]
[314,24731]
[315,24797]
[318,24996]
[319,25063]
[320,25129]
[321,25195]
[323,25328]
[324,25395]
[325,25461]
[327,25594]
[328,25660]
[330,25793]
[332,25926]
[333,25993]
[334,26059]
[335,26125]
[336,26192]
[337,26258]
[340,26457]
[342,26590]
[344,26723]
[345,26790]
[346,26856]
[347,26922]
[350,27122]
[351,27188]
[352,27255]
[353,27321]
[354,27387]
[355,27454]
[356,27520]
[360,27786]
[363,27985]
[364,28052]
[365,28118]
[366,28184]
[367,28251]
[370,28450]
[371,28517]
[372,28583]
[373,28649]
[374,28716]
[375,28782]
[378,28982]
[380,29114]
[381,29181]
[382,29247]
[383,29314]
[384,29380]
[385,29446]
[386,29513]
[388,29646]
[389,29712]
[390,29779]
[392,29911]
[394,30044]
[395,30111]
[396,30177]
[397,30244]
[399,30376]
[400,30443]
[404,30708]
[405,30775]
[406,30841]
[407,30908]
[408,30974]
[410,31107]
[411,31173]
[414,31373]
[415,31439]
[416,31506]
[417,31572]
[418,31638]
[420,31771]
[424,32037]
[425,32103]
[426,32170]
[430,32435]
[435,32768]
[437,32900]
[439,33033]
[440,33100]
[443,33299]
[445,33432]
[449,33697]
[450,33764]
[451,33830]
[455,34096]
[456,34162]
[459,34362]
[460,34428]
[461,34495]
[463,34627]
[465,34760]
[468,34960]
[470,35092]
[471,35159]
[473,35292]
[474,35358]
[475,35424]
[478,35624]
[480,35757]
[482,35889]
[483,35956]
[485,36089]
[487,36222]
[488,36288]
[489,36354]
[490,36421]
[491,36487]
[493,36620]
[495,36753]
[496,36819]
[498,36952]
[500,37085]
[501,37151]
[502,37218]
[503,37284]
[504,37351]
[505,37417]
[506,37484]
[510,37749]
[512,37882]
[514,38015]
[515,38081]
[517,38214]
[520,38413]
[522,38546]
[523,38613]
[525,38746]
[527,38878]
[530,39078]
[532,39211]
[533,39277]
[535,39410]
[540,39742]
[542,39875]
[543,39941]
[545,40074]
[548,40273]
[550,40406]
[553,40605]
[555,40738]
[556,40805]
[560,41070]
[562,41203]
[563,41270]
[564,41336]
[565,41402]
[570,41735]
[571,41801]
[572,41867]
[575,42067]
[579,42332]
[580,42399]
[585,42731]
[586,42797]
[587,42864]
[590,43063]
[594,43329]
[595,43395]
[596,43462]
[600,43727]
[601,43794]
[609,44325]
[610,44391]
[615,44724]
[617,44856]
[620,45056]
[625,45388]
[630,45720]
[635,46052]
[636,46118]
[640,46384]
[645,46716]
[650,47048]
[655,47380]
[660,47713]
[665,48045]
[670,48377]
[675,48709]
[680,49041]
[685,49373]
[690,49705]
[695,50037]
[700,50369]
[705,50702]
[710,51034]
[715,51366]
[720,51698]
[730,52362]
[735,52694]
[740,53026]
[750,53690]
[755,54023]
[760,54355]
[770,55019]
[775,55351]
[780,55683]
[785,56015]
[790,56347]
[795,56679]
[800,57012]
[810,57676]
[815,58008]
[820,58340]
[830,59004]
[836,59403]
[840,59668]
[855,60665]
[858,60864]
[869,61595]
[870,61661]
[880,62325]
[881,62392]
[892,63122]
[895,63322]
[900,63654]
[903,63853]
[914,64584]
[916,64717]
[925,65314]
[937,66111]
[940,66311]
[948,66842]
[959,67573]
[963,67838]
[970,68303]
[980,68968]
[985,69300]
[1000,70296]
[1004,70562]
[1016,71359]
[1020,71624]
[1038,72820]
[1040,72953]
[1058,74148]
[1078,75477]
[1080,75610]
[1086,76008]
[1115,77934]
[1138,79462]
[1139,79529]
[1140,79595]
[1164,81189]
[1180,82252]
[1182,82385]
[1190,82916]
[1198,83448]
[1217,84710]
[1242,86370]
[1245,86569]
[1270,88230]
[1302,90355]
[1305,90555]
[1309,90820]
[1320,91551]
[1330,92215]
[1340,92879]
[1356,93942]
[1362,94341]
[1369,94806]
[1375,95204]
[1502,103640]
[1505,103839]
[1588,109352]
[1635,112474]
[1667,114599]
[1761,120843]
[2028,138578]
[2069,141301]
[2079,141965]
[2110,144024]
[2151,146748]
[2192,149471]
[2233,152194]
[2272,154785]
[2274,154918]
[2291,156047]
[2292,156113]
[2315,157641]
[2356,160364]
[2372,161427]
[2397,163087]
[2413,164150]
[2438,165811]
[2454,166873]
[2479,168534]
[2495,169597]
[2504,170195]
[2520,171257]
[2536,172320]
[2561,173981]
[2577,175043]
[2602,176704]
[2618,177767]
[2643,179427]
[2644,179494]
[2659,180490]
[2685,182217]
[2700,183213]
[2726,184940]
[2741,185937]
[2767,187664]
[2782,188660]
[2808,190387]
[2823,191383]
[2849,193110]
[2890,195833]
[2916,197560]
[2931,198557]
[2957,200284]
[2972,201280]
[2998,203007]
[3013,204003]
[3039,205730]
[3080,208454]
[3121,211177]
[3162,213900]
[3203,216623]
[3229,218350]
[3270,221074]
[3311,223797]
[3352,226520]
[3393,229244]