{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Recap","Cumul","001000 L8 269682001","001000 L8 269710000","001000 L8 269576000","001000 L8 269701111","444510920","Infos"],"not_rendered":{"charts":6,"macros":1,"defined_names":2,"comments":3},"read":"whole","date_system":"1900"}

{"sheet":"Recap","index":0,"n_rows":10,"n_cols":11,"rows_kept":10,"merged":[[0,4,0,5],[1,4,1,5]]}
[{"$nulls":4},"      Contrats "]
[{"$nulls":4},"au  19 mai 2025"]
[]
[null,"Assureur","Reference","Produit","Souscripteur","Date","Investissement","Valorisation","+ / - Value","Performance","Tx Moyen Annuel"]
[null,{"$f":"'001000 L8 269576000'!B2","v":"MonAvenir"},{"$f":"'001000 L8 269576000'!C2","v":"001000 L8 269576000"},{"$f":"'001000 L8 269576000'!B5","v":"AVENIR +"},{"$f":"'001000 L8 269576000'!C5","v":"Anne"},{"$f":"'001000 L8 269576000'!B8","v":"2022-06-15"},{"v":55000,"d":"55,000"},{"v":65295.22,"d":"65,295"},{"$f":"tbl_Recap[[#This Row],[Valorisation]]-tbl_Recap[[#This Row],[Investissement]]","v":{"v":10295.220000000001,"d":"10,295"}},{"$f":"tbl_Recap[[#This Row],[+ / - Value]]/tbl_Recap[[#This Row],[Investissement]]","v":{"v":0.1871858181818182,"d":"18.7%"}},{"v":0.0703370201216659,"d":"7.0%"}]
[null,{"$f":"'001000 L8 269701111'!B2","v":"MonAvenir"},{"$f":"'001000 L8 269701111'!C2","v":"001000 L8 269701111"},{"$f":"'001000 L8 269701111'!B5","v":"AVENIR *"},{"$f":"'001000 L8 269701111'!C5","v":"Anne"},{"$f":"'001000 L8 269701111'!B8","v":"2022-08-24"},{"v":70000,"d":"70,000"},{"v":81494.87,"d":"81,495"},{"$f":"tbl_Recap[[#This Row],[Valorisation]]-tbl_Recap[[#This Row],[Investissement]]","v":{"v":11494.869999999995,"d":"11,495"}},{"$f":"tbl_Recap[[#This Row],[+ / - Value]]/tbl_Recap[[#This Row],[Investissement]]","v":{"v":0.1642124285714285,"d":"16.4%"}},{"v":0.06054296608946606,"d":"6.1%"}]
[null,{"$f":"'001000 L8 269682001'!B2","v":"MonAvenir"},{"$f":"'001000 L8 269682001'!C2","v":"001000 L8 269682001"},{"$f":"'001000 L8 269682001'!B5","v":"AVENIR +"},{"$f":"'001000 L8 269682001'!C5","v":"Pierre"},{"$f":"'001000 L8 269682001'!B8","v":"2022-08-08"},{"v":65000,"d":"65,000"},{"v":70428.1,"d":"70,428"},{"$f":"tbl_Recap[[#This Row],[Valorisation]]-tbl_Recap[[#This Row],[Investissement]]","v":{"v":5428.100000000006,"d":"5,428"}},{"$f":"tbl_Recap[[#This Row],[+ / - Value]]/tbl_Recap[[#This Row],[Investissement]]","v":{"v":0.08350923076923086,"d":"8.4%"}},{"v":0.038415055744062086,"d":"3.8%"}]
[null,{"$f":"'001000 L8 269710000'!B2","v":"MonAvenir"},{"$f":"'001000 L8 269710000'!C2","v":"001000 L8 269710000"},{"$f":"'001000 L8 269710000'!B5","v":"AVENIR +"},{"$f":"'001000 L8 269710000'!C5","v":"Pierre"},{"$f":"tbl_Histo_AVENIR2_JL2[[#This Row],[Date]]","v":"2022-08-29"},{"v":70000,"d":"70,000"},{"v":80415.25,"d":"80,415"},{"$f":"tbl_Recap[[#This Row],[Valorisation]]-tbl_Recap[[#This Row],[Investissement]]","v":{"v":10415.25,"d":"10,415"}},{"$f":"tbl_Recap[[#This Row],[+ / - Value]]/tbl_Recap[[#This Row],[Investissement]]","v":{"v":0.1487892857142857,"d":"14.9%"}},{"v":0.05513511602610587,"d":"5.5%"}]
[null,{"$f":"'444510920'!B2","v":"Abeille"},{"$f":"'444510920'!C2","v":444510920},{"$f":"'444510920'!B5","v":"Miel  2"},{"$f":"'444510920'!C5","v":"Pierre / Anne"},{"$f":"'444510920'!B8","v":"2022-06-27"},{"v":60000,"d":"60,000"},{"v":66697.68,"d":"66,698"},{"$f":"tbl_Recap[[#This Row],[Valorisation]]-tbl_Recap[[#This Row],[Investissement]]","v":{"v":6697.679999999993,"d":"6,698"}},{"$f":"tbl_Recap[[#This Row],[+ / - Value]]/tbl_Recap[[#This Row],[Investissement]]","v":{"v":0.11162799999999988,"d":"11.2%"}},{"v":0.03541487201031447,"d":"3.5%"}]
[null,"Total",{"$nulls":4},{"$f":"SUBTOTAL(109,tbl_Recap[Investissement])","v":{"v":320000,"d":"320,000"}},{"$f":"SUBTOTAL(109,tbl_Recap[Valorisation])","v":{"v":364331.12,"d":"364,331"}},{"$f":"SUBTOTAL(109,tbl_Recap[+ / - Value])","v":{"v":44331.119999999995,"d":"44,331"}},{"$f":"tbl_Recap[[#Totals],[+ / - Value]]/tbl_Recap[[#Totals],[Investissement]]","v":{"v":0.13853474999999998,"d":"13.9%"}}]

{"sheet":"Cumul","index":1,"n_rows":11,"n_cols":35,"rows_kept":11}
[]
[]
["CONTRATS CUMULÉS"]
["Date","Net Investi","Valorisation","+/- Value","Rapport",null,null,"Bissextile","Date","Opération","Net Investi","Valorisation","+/- Value","Performance","TMA net","Invest. Moyen","Jours/Période","Ans Cumul.",{"$nulls":5},"Date","Cntrat","Net Investi","Valorisation","+ / -  Value","Rapport"]
[{"$f":"'001000 L8 269576000'!B9","v":"2022-12-31"},{"$f":"'001000 L8 269576000'!D9+'001000 L8 269701111'!D9+'001000 L8 269682001'!D9+'001000 L8 269710000'!D9+'444510920'!D9","v":{"v":315000,"d":"315,000.00"}},{"$f":"'001000 L8 269576000'!E9+'001000 L8 269701111'!E9+'001000 L8 269682001'!E9+'001000 L8 269710000'!E9+'444510920'!E9","v":{"v":304206.99,"d":"304,206.99"}},{"$f":"C5-B5","v":{"v":-10793.01000000001,"d":"-10,793.01"}},{"$f":"D5/B5","v":{"v":-0.03426352380952384,"d":"-3%"}},{"$nulls":18},"2022-06-01",1,1000,1100,{"$f":"AA5-Z5","v":100},{"$f":"AB5/Z5","v":{"v":0.1,"d":"10%"}}]
[{"$f":"'001000 L8 269576000'!B10","v":"2023-12-31"},{"$f":"'001000 L8 269576000'!D10+'001000 L8 269701111'!D10+'001000 L8 269682001'!D10+'001000 L8 269710000'!D10+'444510920'!D11","v":{"v":296000,"d":"296,000.00"}},{"$f":"'001000 L8 269576000'!E10+'001000 L8 269701111'!E10+'001000 L8 269682001'!E10+'001000 L8 269710000'!E10+'444510920'!E11","v":{"v":313728.13,"d":"313,728.13"}},{"$f":"C6-B6","v":{"v":17728.130000000005,"d":"17,728.13"}},{"$f":"D6/B6","v":{"v":0.0598923310810811,"d":"6%"}},{"$nulls":18},"2022-12-01",1,1000,1105,{"$f":"AA6-Z6","v":105},{"$f":"AB6/Z6","v":{"v":0.105,"d":"11%"}}]
[{"$f":"'001000 L8 269576000'!B11","v":"2024-12-31"},{"$f":"'001000 L8 269576000'!D11+'001000 L8 269701111'!D11+'001000 L8 269682001'!D11+'001000 L8 269710000'!D11+'444510920'!D12","v":{"v":296000,"d":"296,000.00"}},{"$f":"'001000 L8 269576000'!E11+'001000 L8 269701111'!E11+'001000 L8 269682001'!E11+'001000 L8 269710000'!E11+'444510920'!E12","v":{"v":344218.86,"d":"344,218.86"}},{"$f":"C7-B7","v":{"v":48218.859999999986,"d":"48,218.86"}},{"$f":"D7/B7","v":{"v":0.16290155405405402,"d":"16%"}},{"$nulls":18},"2022-12-01",2,3000,3200,{"$f":"AA7-Z7","v":200},{"$f":"AB7/Z7","v":{"v":0.06666666666666667,"d":"7%"}}]
[{"$f":"'001000 L8 269576000'!B12","v":"2025-02-14"},{"$f":"'001000 L8 269576000'!D13+'001000 L8 269701111'!D12+'001000 L8 269682001'!D13+'001000 L8 269710000'!D12+'444510920'!D13","v":{"v":320000,"d":"320,000.00"}},{"$f":"'001000 L8 269576000'!E13+'001000 L8 269701111'!E12+'001000 L8 269682001'!E13+'001000 L8 269710000'!E12+'444510920'!E14","v":{"v":364331.12,"d":"364,331.12"}},{"$f":"C8-B8","v":{"v":44331.119999999995,"d":"44,331.12"}},{"$f":"D8/B8","v":{"v":0.13853474999999998,"d":"14%"}},{"$nulls":18},"2022-08-01",3,5000,5500,{"$f":"AA8-Z8","v":500},{"$f":"AB8/Z8","v":{"v":0.1,"d":"10%"}}]
[{"$nulls":29},"2022-12-01",3,5000,5600,{"$f":"AG9-AF9","v":600},{"$f":"AH9/AF9","v":{"v":0.12,"d":"12%"}}]
[{"$nulls":29},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"AG10-AF10","v":{"$error":"#REF!"}},{"$f":"AH10/AF10","v":{"$error":"#REF!"}}]
[{"$nulls":29},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]

{"sheet":"001000 L8 269682001","index":2,"n_rows":13,"n_cols":12,"rows_kept":13,"merged":[[0,2,0,3],[0,5,0,7],[1,2,1,3]]}
[null,"Assureur","Référence"]
[null,"MonAvenir","001000 L8 269682001"]
[]
[null,"Produit","Souscripteur"]
[null,"AVENIR +","Pierre"]
[{"$nulls":4},{"$f":"B5 &\" - \" &C5 &\" - \" &TEXT(B8,\"jj mmm aaaa\")","v":"AVENIR + - Pierre - 08 août 2022"}]
["Bissextile","Date","Opération","Net Investi","Valorisation","+/- Value","Performance","TMA net","Invest. Moyen","Jours/Période","Ans Cumul.","Nb"]
[{"$f":"IF(OR(MOD(YEAR(tbl_Histo_AVENIR2_JL1[[#This Row],[Date]]),400)=0,AND(MOD(YEAR(tbl_Histo_AVENIR2_JL1[[#This Row],[Date]]),4)=0,MOD(YEAR(tbl_Histo_AVENIR2_JL1[[#This Row],[Date]]),100)<>0)),366,365)","v":365},"2022-08-08",{"v":50000,"d":"50,000.00"},{"$f":"IFERROR(D7+tbl_Histo_AVENIR2_JL1[[#This Row],[Opération]],tbl_Histo_AVENIR2_JL1[[#This Row],[Opération]])","v":{"v":50000,"d":"50,000.00"}},{"v":50000,"d":"50,000.00"},{"$f":"tbl_Histo_AVENIR2_JL1[[#This Row],[Valorisation]]-tbl_Histo_AVENIR2_JL1[[#This Row],[Net Investi]]","v":{"v":0,"d":"0.00"}},{"$f":"tbl_Histo_AVENIR2_JL1[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_JL1[[#This Row],[Net Investi]]","v":{"v":0,"d":"0%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_JL1[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_JL1[[#This Row],[Ans Cumul.]]/tbl_Histo_AVENIR2_JL1[[#This Row],[Invest. Moyen]],0)","v":{"v":0,"d":"0%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_JL1[[#This Row],[Nb]]/tbl_Histo_AVENIR2_JL1[[#This Row],[Bissextile]]/tbl_Histo_AVENIR2_JL1[[#This Row],[Ans Cumul.]],0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(DATEDIF(B7,tbl_Histo_AVENIR2_JL1[[#This Row],[Date]],\"D\"),0)","v":0},{"$f":"DATEDIF($B$8,tbl_Histo_AVENIR2_JL1[[#This Row],[Date]],\"d\")/tbl_Histo_AVENIR2_JL1[[#This Row],[Bissextile]]","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(D7*tbl_Histo_AVENIR2_JL1[[#This Row],[Jours/Période]]+L7,0)","v":{"v":0,"d":"0.00"}}]
[{"$f":"IF(OR(MOD(YEAR(tbl_Histo_AVENIR2_JL1[[#This Row],[Date]]),400)=0,AND(MOD(YEAR(tbl_Histo_AVENIR2_JL1[[#This Row],[Date]]),4)=0,MOD(YEAR(tbl_Histo_AVENIR2_JL1[[#This Row],[Date]]),100)<>0)),366,365)","v":365},"2022-12-31",null,{"$f":"IFERROR(D8+tbl_Histo_AVENIR2_JL1[[#This Row],[Opération]],tbl_Histo_AVENIR2_JL1[[#This Row],[Opération]])","v":{"v":50000,"d":"50,000.00"}},{"v":46770.92,"d":"46,770.92"},{"$f":"tbl_Histo_AVENIR2_JL1[[#This Row],[Valorisation]]-tbl_Histo_AVENIR2_JL1[[#This Row],[Net Investi]]","v":{"v":-3229.0800000000017,"d":"-3,229.08"}},{"$f":"tbl_Histo_AVENIR2_JL1[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_JL1[[#This Row],[Net Investi]]","v":{"v":-0.06458160000000003,"d":"-6%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_JL1[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_JL1[[#This Row],[Ans Cumul.]]/tbl_Histo_AVENIR2_JL1[[#This Row],[Invest. Moyen]],0)","v":{"v":-0.16256747586206907,"d":"-16%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_JL1[[#This Row],[Nb]]/tbl_Histo_AVENIR2_JL1[[#This Row],[Bissextile]]/tbl_Histo_AVENIR2_JL1[[#This Row],[Ans Cumul.]],0)","v":{"v":50000,"d":"50,000.00"}},{"$f":"IFERROR(DATEDIF(B8,tbl_Histo_AVENIR2_JL1[[#This Row],[Date]],\"D\"),0)","v":145},{"$f":"DATEDIF($B$8,tbl_Histo_AVENIR2_JL1[[#This Row],[Date]],\"d\")/tbl_Histo_AVENIR2_JL1[[#This Row],[Bissextile]]","v":{"v":0.3972602739726027,"d":"0.40"}},{"$f":"IFERROR(D8*tbl_Histo_AVENIR2_JL1[[#This Row],[Jours/Période]]+L8,0)","v":{"v":7250000,"d":"7,250,000.00"}}]
[{"$f":"IF(OR(MOD(YEAR(tbl_Histo_AVENIR2_JL1[[#This Row],[Date]]),400)=0,AND(MOD(YEAR(tbl_Histo_AVENIR2_JL1[[#This Row],[Date]]),4)=0,MOD(YEAR(tbl_Histo_AVENIR2_JL1[[#This Row],[Date]]),100)<>0)),366,365)","v":365},"2023-12-31",null,{"$f":"IFERROR(D9+tbl_Histo_AVENIR2_JL1[[#This Row],[Opération]],tbl_Histo_AVENIR2_JL1[[#This Row],[Opération]])","v":{"v":50000,"d":"50,000.00"}},{"v":51836.94,"d":"51,836.94"},{"$f":"tbl_Histo_AVENIR2_JL1[[#This Row],[Valorisation]]-tbl_Histo_AVENIR2_JL1[[#This Row],[Net Investi]]","v":{"v":1836.9400000000023,"d":"1,836.94"}},{"$f":"tbl_Histo_AVENIR2_JL1[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_JL1[[#This Row],[Net Investi]]","v":{"v":0.036738800000000044,"d":"4%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_JL1[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_JL1[[#This Row],[Ans Cumul.]]/tbl_Histo_AVENIR2_JL1[[#This Row],[Invest. Moyen]],0)","v":{"v":0.026293454901960816,"d":"3%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_JL1[[#This Row],[Nb]]/tbl_Histo_AVENIR2_JL1[[#This Row],[Bissextile]]/tbl_Histo_AVENIR2_JL1[[#This Row],[Ans Cumul.]],0)","v":{"v":50000,"d":"50,000.00"}},{"$f":"IFERROR(DATEDIF(B9,tbl_Histo_AVENIR2_JL1[[#This Row],[Date]],\"D\"),0)","v":365},{"$f":"DATEDIF($B$8,tbl_Histo_AVENIR2_JL1[[#This Row],[Date]],\"d\")/tbl_Histo_AVENIR2_JL1[[#This Row],[Bissextile]]","v":{"v":1.3972602739726028,"d":"1.40"}},{"$f":"IFERROR(D9*tbl_Histo_AVENIR2_JL1[[#This Row],[Jours/Période]]+L9,0)","v":{"v":25500000,"d":"25,500,000.00"}}]
[{"$f":"IF(OR(MOD(YEAR(tbl_Histo_AVENIR2_JL1[[#This Row],[Date]]),400)=0,AND(MOD(YEAR(tbl_Histo_AVENIR2_JL1[[#This Row],[Date]]),4)=0,MOD(YEAR(tbl_Histo_AVENIR2_JL1[[#This Row],[Date]]),100)<>0)),366,365)","v":366},"2024-12-31",null,{"$f":"IFERROR(D10+tbl_Histo_AVENIR2_JL1[[#This Row],[Opération]],tbl_Histo_AVENIR2_JL1[[#This Row],[Opération]])","v":{"v":50000,"d":"50,000.00"}},{"v":56236,"d":"56,236.00"},{"$f":"tbl_Histo_AVENIR2_JL1[[#This Row],[Valorisation]]-tbl_Histo_AVENIR2_JL1[[#This Row],[Net Investi]]","v":{"v":6236,"d":"6,236.00"}},{"$f":"tbl_Histo_AVENIR2_JL1[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_JL1[[#This Row],[Net Investi]]","v":{"v":0.12472,"d":"12%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_JL1[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_JL1[[#This Row],[Ans Cumul.]]/tbl_Histo_AVENIR2_JL1[[#This Row],[Invest. Moyen]],0)","v":{"v":0.05210904109589041,"d":"5%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_JL1[[#This Row],[Nb]]/tbl_Histo_AVENIR2_JL1[[#This Row],[Bissextile]]/tbl_Histo_AVENIR2_JL1[[#This Row],[Ans Cumul.]],0)","v":{"v":50000,"d":"50,000.00"}},{"$f":"IFERROR(DATEDIF(B10,tbl_Histo_AVENIR2_JL1[[#This Row],[Date]],\"D\"),0)","v":366},{"$f":"DATEDIF($B$8,tbl_Histo_AVENIR2_JL1[[#This Row],[Date]],\"d\")/tbl_Histo_AVENIR2_JL1[[#This Row],[Bissextile]]","v":{"v":2.3934426229508197,"d":"2.39"}},{"$f":"IFERROR(D10*tbl_Histo_AVENIR2_JL1[[#This Row],[Jours/Période]]+L10,0)","v":{"v":43800000,"d":"43,800,000.00"}}]
[{"$f":"IF(OR(MOD(YEAR(tbl_Histo_AVENIR2_JL1[[#This Row],[Date]]),400)=0,AND(MOD(YEAR(tbl_Histo_AVENIR2_JL1[[#This Row],[Date]]),4)=0,MOD(YEAR(tbl_Histo_AVENIR2_JL1[[#This Row],[Date]]),100)<>0)),366,365)","v":365},"2025-02-14",{"v":15000,"d":"15,000.00"},{"$f":"IFERROR(D11+tbl_Histo_AVENIR2_JL1[[#This Row],[Opération]],tbl_Histo_AVENIR2_JL1[[#This Row],[Opération]])","v":{"v":65000,"d":"65,000.00"}},{"v":73500,"d":"73,500.00"},{"$f":"tbl_Histo_AVENIR2_JL1[[#This Row],[Valorisation]]-tbl_Histo_AVENIR2_JL1[[#This Row],[Net Investi]]","v":{"v":8500,"d":"8,500.00"}},{"$f":"tbl_Histo_AVENIR2_JL1[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_JL1[[#This Row],[Net Investi]]","v":{"v":0.13076923076923078,"d":"13%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_JL1[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_JL1[[#This Row],[Ans Cumul.]]/tbl_Histo_AVENIR2_JL1[[#This Row],[Invest. Moyen]],0)","v":{"v":0.06737242128121608,"d":"7%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_JL1[[#This Row],[Nb]]/tbl_Histo_AVENIR2_JL1[[#This Row],[Bissextile]]/tbl_Histo_AVENIR2_JL1[[#This Row],[Ans Cumul.]],0)","v":{"v":50000,"d":"50,000.00"}},{"$f":"IFERROR(DATEDIF(B11,tbl_Histo_AVENIR2_JL1[[#This Row],[Date]],\"D\"),0)","v":45},{"$f":"DATEDIF($B$8,tbl_Histo_AVENIR2_JL1[[#This Row],[Date]],\"d\")/tbl_Histo_AVENIR2_JL1[[#This Row],[Bissextile]]","v":{"v":2.5232876712328767,"d":"2.52"}},{"$f":"IFERROR(D11*tbl_Histo_AVENIR2_JL1[[#This Row],[Jours/Période]]+L11,0)","v":{"v":46050000,"d":"46,050,000.00"}}]
[{"$f":"IF(OR(MOD(YEAR(tbl_Histo_AVENIR2_JL1[[#This Row],[Date]]),400)=0,AND(MOD(YEAR(tbl_Histo_AVENIR2_JL1[[#This Row],[Date]]),4)=0,MOD(YEAR(tbl_Histo_AVENIR2_JL1[[#This Row],[Date]]),100)<>0)),366,365)","v":365},"2025-05-10",null,{"$f":"IFERROR(D12+tbl_Histo_AVENIR2_JL1[[#This Row],[Opération]],tbl_Histo_AVENIR2_JL1[[#This Row],[Opération]])","v":{"v":65000,"d":"65,000.00"}},{"v":70428.1,"d":"70,428.10"},{"$f":"tbl_Histo_AVENIR2_JL1[[#This Row],[Valorisation]]-tbl_Histo_AVENIR2_JL1[[#This Row],[Net Investi]]","v":{"v":5428.100000000006,"d":"5,428.10"}},{"$f":"tbl_Histo_AVENIR2_JL1[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_JL1[[#This Row],[Net Investi]]","v":{"v":0.08350923076923086,"d":"8%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_JL1[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_JL1[[#This Row],[Ans Cumul.]]/tbl_Histo_AVENIR2_JL1[[#This Row],[Invest. Moyen]],0)","v":{"v":0.038415055744062086,"d":"4%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_JL1[[#This Row],[Nb]]/tbl_Histo_AVENIR2_JL1[[#This Row],[Bissextile]]/tbl_Histo_AVENIR2_JL1[[#This Row],[Ans Cumul.]],0)","v":{"v":51267.39562624255,"d":"51,267.40"}},{"$f":"IFERROR(DATEDIF(B12,tbl_Histo_AVENIR2_JL1[[#This Row],[Date]],\"D\"),0)","v":85},{"$f":"DATEDIF($B$8,tbl_Histo_AVENIR2_JL1[[#This Row],[Date]],\"d\")/tbl_Histo_AVENIR2_JL1[[#This Row],[Bissextile]]","v":{"v":2.756164383561644,"d":"2.76"}},{"$f":"IFERROR(D12*tbl_Histo_AVENIR2_JL1[[#This Row],[Jours/Période]]+L12,0)","v":{"v":51575000,"d":"51,575,000.00"}}]

{"sheet":"001000 L8 269710000","index":3,"n_rows":12,"n_cols":12,"rows_kept":12,"merged":[[0,2,0,3],[0,5,0,7],[1,2,1,3]]}
[null,"Assureur","Référence"]
[null,"MonAvenir","001000 L8 269710000"]
[]
[null,"Produit","Souscripteur"]
[null,"AVENIR +","Pierre"]
[{"$nulls":4},{"$f":"B5 &\" - \" &C5 &\" - \" &TEXT(B8,\"jj mmm aaaa\")","v":"AVENIR + - Pierre - 29 août 2022"}]
["Bissextile","Date","Opération","Net Investi","Valorisation","+/- Value","Performance","TMA net","Invest. Moyen","Jours/Période","Ans Cumul.","Nb Cumul"]
[{"$f":"IF(OR(MOD(YEAR(tbl_Histo_AVENIR2_JL2[[#This Row],[Date]]),400)=0,AND(MOD(YEAR(tbl_Histo_AVENIR2_JL2[[#This Row],[Date]]),4)=0,MOD(YEAR(tbl_Histo_AVENIR2_JL2[[#This Row],[Date]]),100)<>0)),366,365)","v":365},"2022-08-29",{"v":70000,"d":"70,000.00"},{"$f":"IFERROR(D7+tbl_Histo_AVENIR2_JL2[[#This Row],[Opération]],tbl_Histo_AVENIR2_JL2[[#This Row],[Opération]])","v":{"v":70000,"d":"70,000.00"}},{"v":70000,"d":"70,000.00"},{"$f":"tbl_Histo_AVENIR2_JL2[[#This Row],[Valorisation]]-tbl_Histo_AVENIR2_JL2[[#This Row],[Net Investi]]","v":{"v":0,"d":"0.00"}},{"$f":"tbl_Histo_AVENIR2_JL2[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_JL2[[#This Row],[Net Investi]]","v":{"v":0,"d":"0%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_JL2[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_JL2[[#This Row],[Ans Cumul.]]/tbl_Histo_AVENIR2_JL2[[#This Row],[Invest. Moyen]],0)","v":{"v":0,"d":"0%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_JL2[[#This Row],[Nb Cumul]]/tbl_Histo_AVENIR2_JL2[[#This Row],[Bissextile]]/tbl_Histo_AVENIR2_JL2[[#This Row],[Ans Cumul.]],0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(DATEDIF(B7,tbl_Histo_AVENIR2_JL2[[#This Row],[Date]],\"D\"),0)","v":0},{"$f":"DATEDIF($B$8,tbl_Histo_AVENIR2_JL2[[#This Row],[Date]],\"d\")/tbl_Histo_AVENIR2_JL2[[#This Row],[Bissextile]]","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(D7*tbl_Histo_AVENIR2_JL2[[#This Row],[Jours/Période]]+L7,0)","v":{"v":0,"d":"0.00"}}]
[{"$f":"IF(OR(MOD(YEAR(tbl_Histo_AVENIR2_JL2[[#This Row],[Date]]),400)=0,AND(MOD(YEAR(tbl_Histo_AVENIR2_JL2[[#This Row],[Date]]),4)=0,MOD(YEAR(tbl_Histo_AVENIR2_JL2[[#This Row],[Date]]),100)<>0)),366,365)","v":365},"2022-12-31",null,{"$f":"IFERROR(D8+tbl_Histo_AVENIR2_JL2[[#This Row],[Opération]],tbl_Histo_AVENIR2_JL2[[#This Row],[Opération]])","v":{"v":70000,"d":"70,000.00"}},{"v":68053.95,"d":"68,053.95"},{"$f":"tbl_Histo_AVENIR2_JL2[[#This Row],[Valorisation]]-tbl_Histo_AVENIR2_JL2[[#This Row],[Net Investi]]","v":{"v":-1946.050000000003,"d":"-1,946.05"}},{"$f":"tbl_Histo_AVENIR2_JL2[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_JL2[[#This Row],[Net Investi]]","v":{"v":-0.027800714285714328,"d":"-3%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_JL2[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_JL2[[#This Row],[Ans Cumul.]]/tbl_Histo_AVENIR2_JL2[[#This Row],[Invest. Moyen]],0)","v":{"v":-0.08183274769585266,"d":"-8%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_JL2[[#This Row],[Nb Cumul]]/tbl_Histo_AVENIR2_JL2[[#This Row],[Bissextile]]/tbl_Histo_AVENIR2_JL2[[#This Row],[Ans Cumul.]],0)","v":{"v":70000,"d":"70,000.00"}},{"$f":"IFERROR(DATEDIF(B8,tbl_Histo_AVENIR2_JL2[[#This Row],[Date]],\"D\"),0)","v":124},{"$f":"DATEDIF($B$8,tbl_Histo_AVENIR2_JL2[[#This Row],[Date]],\"d\")/tbl_Histo_AVENIR2_JL2[[#This Row],[Bissextile]]","v":{"v":0.33972602739726027,"d":"0.34"}},{"$f":"IFERROR(D8*tbl_Histo_AVENIR2_JL2[[#This Row],[Jours/Période]]+L8,0)","v":{"v":8680000,"d":"8,680,000.00"}}]
[{"$f":"IF(OR(MOD(YEAR(tbl_Histo_AVENIR2_JL2[[#This Row],[Date]]),400)=0,AND(MOD(YEAR(tbl_Histo_AVENIR2_JL2[[#This Row],[Date]]),4)=0,MOD(YEAR(tbl_Histo_AVENIR2_JL2[[#This Row],[Date]]),100)<>0)),366,365)","v":365},"2023-12-31",null,{"$f":"IFERROR(D9+tbl_Histo_AVENIR2_JL2[[#This Row],[Opération]],tbl_Histo_AVENIR2_JL2[[#This Row],[Opération]])","v":{"v":70000,"d":"70,000.00"}},{"v":74444.12,"d":"74,444.12"},{"$f":"tbl_Histo_AVENIR2_JL2[[#This Row],[Valorisation]]-tbl_Histo_AVENIR2_JL2[[#This Row],[Net Investi]]","v":{"v":4444.119999999995,"d":"4,444.12"}},{"$f":"tbl_Histo_AVENIR2_JL2[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_JL2[[#This Row],[Net Investi]]","v":{"v":0.0634874285714285,"d":"6%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_JL2[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_JL2[[#This Row],[Ans Cumul.]]/tbl_Histo_AVENIR2_JL2[[#This Row],[Invest. Moyen]],0)","v":{"v":0.047388366929593875,"d":"5%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_JL2[[#This Row],[Nb Cumul]]/tbl_Histo_AVENIR2_JL2[[#This Row],[Bissextile]]/tbl_Histo_AVENIR2_JL2[[#This Row],[Ans Cumul.]],0)","v":{"v":70000,"d":"70,000.00"}},{"$f":"IFERROR(DATEDIF(B9,tbl_Histo_AVENIR2_JL2[[#This Row],[Date]],\"D\"),0)","v":365},{"$f":"DATEDIF($B$8,tbl_Histo_AVENIR2_JL2[[#This Row],[Date]],\"d\")/tbl_Histo_AVENIR2_JL2[[#This Row],[Bissextile]]","v":{"v":1.3397260273972602,"d":"1.34"}},{"$f":"IFERROR(D9*tbl_Histo_AVENIR2_JL2[[#This Row],[Jours/Période]]+L9,0)","v":{"v":34230000,"d":"34,230,000.00"}}]
[{"$f":"IF(OR(MOD(YEAR(tbl_Histo_AVENIR2_JL2[[#This Row],[Date]]),400)=0,AND(MOD(YEAR(tbl_Histo_AVENIR2_JL2[[#This Row],[Date]]),4)=0,MOD(YEAR(tbl_Histo_AVENIR2_JL2[[#This Row],[Date]]),100)<>0)),366,365)","v":366},"2024-12-31",null,{"$f":"IFERROR(D10+tbl_Histo_AVENIR2_JL2[[#This Row],[Opération]],tbl_Histo_AVENIR2_JL2[[#This Row],[Opération]])","v":{"v":70000,"d":"70,000.00"}},{"v":80854,"d":"80,854.00"},{"$f":"tbl_Histo_AVENIR2_JL2[[#This Row],[Valorisation]]-tbl_Histo_AVENIR2_JL2[[#This Row],[Net Investi]]","v":{"v":10854,"d":"10,854.00"}},{"$f":"tbl_Histo_AVENIR2_JL2[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_JL2[[#This Row],[Net Investi]]","v":{"v":0.15505714285714287,"d":"16%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_JL2[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_JL2[[#This Row],[Ans Cumul.]]/tbl_Histo_AVENIR2_JL2[[#This Row],[Invest. Moyen]],0)","v":{"v":0.06637533834586468,"d":"7%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_JL2[[#This Row],[Nb Cumul]]/tbl_Histo_AVENIR2_JL2[[#This Row],[Bissextile]]/tbl_Histo_AVENIR2_JL2[[#This Row],[Ans Cumul.]],0)","v":{"v":70000,"d":"70,000.00"}},{"$f":"IFERROR(DATEDIF(B10,tbl_Histo_AVENIR2_JL2[[#This Row],[Date]],\"D\"),0)","v":366},{"$f":"DATEDIF($B$8,tbl_Histo_AVENIR2_JL2[[#This Row],[Date]],\"d\")/tbl_Histo_AVENIR2_JL2[[#This Row],[Bissextile]]","v":{"v":2.3360655737704916,"d":"2.34"}},{"$f":"IFERROR(D10*tbl_Histo_AVENIR2_JL2[[#This Row],[Jours/Période]]+L10,0)","v":{"v":59850000,"d":"59,850,000.00"}}]
[{"$f":"IF(OR(MOD(YEAR(tbl_Histo_AVENIR2_JL2[[#This Row],[Date]]),400)=0,AND(MOD(YEAR(tbl_Histo_AVENIR2_JL2[[#This Row],[Date]]),4)=0,MOD(YEAR(tbl_Histo_AVENIR2_JL2[[#This Row],[Date]]),100)<>0)),366,365)","v":365},"2025-05-10",null,{"$f":"IFERROR(D11+tbl_Histo_AVENIR2_JL2[[#This Row],[Opération]],tbl_Histo_AVENIR2_JL2[[#This Row],[Opération]])","v":{"v":70000,"d":"70,000.00"}},{"v":80415.25,"d":"80,415.25"},{"$f":"tbl_Histo_AVENIR2_JL2[[#This Row],[Valorisation]]-tbl_Histo_AVENIR2_JL2[[#This Row],[Net Investi]]","v":{"v":10415.25,"d":"10,415.25"}},{"$f":"tbl_Histo_AVENIR2_JL2[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_JL2[[#This Row],[Net Investi]]","v":{"v":0.1487892857142857,"d":"15%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_JL2[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_JL2[[#This Row],[Ans Cumul.]]/tbl_Histo_AVENIR2_JL2[[#This Row],[Invest. Moyen]],0)","v":{"v":0.05513511602610587,"d":"6%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_JL2[[#This Row],[Nb Cumul]]/tbl_Histo_AVENIR2_JL2[[#This Row],[Bissextile]]/tbl_Histo_AVENIR2_JL2[[#This Row],[Ans Cumul.]],0)","v":{"v":70000,"d":"70,000.00"}},{"$f":"IFERROR(DATEDIF(B11,tbl_Histo_AVENIR2_JL2[[#This Row],[Date]],\"D\"),0)","v":130},{"$f":"DATEDIF($B$8,tbl_Histo_AVENIR2_JL2[[#This Row],[Date]],\"d\")/tbl_Histo_AVENIR2_JL2[[#This Row],[Bissextile]]","v":{"v":2.6986301369863015,"d":"2.70"}},{"$f":"IFERROR(D11*tbl_Histo_AVENIR2_JL2[[#This Row],[Jours/Période]]+L11,0)","v":{"v":68950000,"d":"68,950,000.00"}}]

{"sheet":"001000 L8 269576000","index":4,"n_rows":13,"n_cols":12,"rows_kept":13,"merged":[[0,2,0,3],[0,5,0,7],[1,2,1,3]]}
[null,"Assureur","Référence"]
[null,"MonAvenir","001000 L8 269576000"]
[]
[null,"Produit","Souscripteur"]
[null,"AVENIR +","Anne"]
[{"$nulls":4},{"$f":"B5 &\" - \" &C5 &\" - \" &TEXT(B8,\"jj mmm aaaa\")","v":"AVENIR + - Anne - 15 juin 2022"}]
["Bissextile","Date","Opération","Net Investi","Valorisation","+/- Value","Performance","TMA net","Invest. Moyen","Jours/Période","Ans Cumul.","Nb Cumul"]
[{"$f":"IF(OR(MOD(YEAR(tbl_Histo_AVENIR2_CH1[[#This Row],[Date]]),400)=0,AND(MOD(YEAR(tbl_Histo_AVENIR2_CH1[[#This Row],[Date]]),4)=0,MOD(YEAR(tbl_Histo_AVENIR2_CH1[[#This Row],[Date]]),100)<>0)),366,365)","v":365},"2022-06-15",{"v":50000,"d":"50,000.00"},{"$f":"IFERROR(D7+tbl_Histo_AVENIR2_CH1[[#This Row],[Opération]],tbl_Histo_AVENIR2_CH1[[#This Row],[Opération]])","v":{"v":50000,"d":"50,000.00"}},{"v":50000,"d":"50,000.00"},{"$f":"tbl_Histo_AVENIR2_CH1[[#This Row],[Valorisation]]-tbl_Histo_AVENIR2_CH1[[#This Row],[Net Investi]]","v":{"v":0,"d":"0.00"}},{"$f":"tbl_Histo_AVENIR2_CH1[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_CH1[[#This Row],[Net Investi]]","v":{"v":0,"d":"0%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_CH1[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_CH1[[#This Row],[Ans Cumul.]]/tbl_Histo_AVENIR2_CH1[[#This Row],[Invest. Moyen]],0)","v":{"v":0,"d":"0%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_CH1[[#This Row],[Nb Cumul]]/tbl_Histo_AVENIR2_CH1[[#This Row],[Bissextile]]/tbl_Histo_AVENIR2_CH1[[#This Row],[Ans Cumul.]],0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(DATEDIF(B7,tbl_Histo_AVENIR2_CH1[[#This Row],[Date]],\"D\"),0)","v":0},{"$f":"DATEDIF($B$8,tbl_Histo_AVENIR2_CH1[[#This Row],[Date]],\"d\")/tbl_Histo_AVENIR2_CH1[[#This Row],[Bissextile]]","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(D7*tbl_Histo_AVENIR2_CH1[[#This Row],[Jours/Période]]+L7,0)","v":{"v":0,"d":"0.00"}}]
[{"$f":"IF(OR(MOD(YEAR(tbl_Histo_AVENIR2_CH1[[#This Row],[Date]]),400)=0,AND(MOD(YEAR(tbl_Histo_AVENIR2_CH1[[#This Row],[Date]]),4)=0,MOD(YEAR(tbl_Histo_AVENIR2_CH1[[#This Row],[Date]]),100)<>0)),366,365)","v":365},"2022-12-31",null,{"$f":"IFERROR(D8+tbl_Histo_AVENIR2_CH1[[#This Row],[Opération]],tbl_Histo_AVENIR2_CH1[[#This Row],[Opération]])","v":{"v":50000,"d":"50,000.00"}},{"v":50455.28,"d":"50,455.28"},{"$f":"tbl_Histo_AVENIR2_CH1[[#This Row],[Valorisation]]-tbl_Histo_AVENIR2_CH1[[#This Row],[Net Investi]]","v":{"v":455.27999999999884,"d":"455.28"}},{"$f":"tbl_Histo_AVENIR2_CH1[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_CH1[[#This Row],[Net Investi]]","v":{"v":0.009105599999999976,"d":"1%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_CH1[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_CH1[[#This Row],[Ans Cumul.]]/tbl_Histo_AVENIR2_CH1[[#This Row],[Invest. Moyen]],0)","v":{"v":0.016701226130653224,"d":"2%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_CH1[[#This Row],[Nb Cumul]]/tbl_Histo_AVENIR2_CH1[[#This Row],[Bissextile]]/tbl_Histo_AVENIR2_CH1[[#This Row],[Ans Cumul.]],0)","v":{"v":50000,"d":"50,000.00"}},{"$f":"IFERROR(DATEDIF(B8,tbl_Histo_AVENIR2_CH1[[#This Row],[Date]],\"D\"),0)","v":199},{"$f":"DATEDIF($B$8,tbl_Histo_AVENIR2_CH1[[#This Row],[Date]],\"d\")/tbl_Histo_AVENIR2_CH1[[#This Row],[Bissextile]]","v":{"v":0.5452054794520548,"d":"0.55"}},{"$f":"IFERROR(D8*tbl_Histo_AVENIR2_CH1[[#This Row],[Jours/Période]]+L8,0)","v":{"v":9950000,"d":"9,950,000.00"}}]
[{"$f":"IF(OR(MOD(YEAR(tbl_Histo_AVENIR2_CH1[[#This Row],[Date]]),400)=0,AND(MOD(YEAR(tbl_Histo_AVENIR2_CH1[[#This Row],[Date]]),4)=0,MOD(YEAR(tbl_Histo_AVENIR2_CH1[[#This Row],[Date]]),100)<>0)),366,365)","v":365},"2023-12-31",null,{"$f":"IFERROR(D9+tbl_Histo_AVENIR2_CH1[[#This Row],[Opération]],tbl_Histo_AVENIR2_CH1[[#This Row],[Opération]])","v":{"v":50000,"d":"50,000.00"}},{"v":55302.23,"d":"55,302.23"},{"$f":"tbl_Histo_AVENIR2_CH1[[#This Row],[Valorisation]]-tbl_Histo_AVENIR2_CH1[[#This Row],[Net Investi]]","v":{"v":5302.230000000003,"d":"5,302.23"}},{"$f":"tbl_Histo_AVENIR2_CH1[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_CH1[[#This Row],[Net Investi]]","v":{"v":0.10604460000000006,"d":"11%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_CH1[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_CH1[[#This Row],[Ans Cumul.]]/tbl_Histo_AVENIR2_CH1[[#This Row],[Invest. Moyen]],0)","v":{"v":0.0686281542553192,"d":"7%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_CH1[[#This Row],[Nb Cumul]]/tbl_Histo_AVENIR2_CH1[[#This Row],[Bissextile]]/tbl_Histo_AVENIR2_CH1[[#This Row],[Ans Cumul.]],0)","v":{"v":49999.99999999999,"d":"50,000.00"}},{"$f":"IFERROR(DATEDIF(B9,tbl_Histo_AVENIR2_CH1[[#This Row],[Date]],\"D\"),0)","v":365},{"$f":"DATEDIF($B$8,tbl_Histo_AVENIR2_CH1[[#This Row],[Date]],\"d\")/tbl_Histo_AVENIR2_CH1[[#This Row],[Bissextile]]","v":{"v":1.5452054794520549,"d":"1.55"}},{"$f":"IFERROR(D9*tbl_Histo_AVENIR2_CH1[[#This Row],[Jours/Période]]+L9,0)","v":{"v":28200000,"d":"28,200,000.00"}}]
[{"$f":"IF(OR(MOD(YEAR(tbl_Histo_AVENIR2_CH1[[#This Row],[Date]]),400)=0,AND(MOD(YEAR(tbl_Histo_AVENIR2_CH1[[#This Row],[Date]]),4)=0,MOD(YEAR(tbl_Histo_AVENIR2_CH1[[#This Row],[Date]]),100)<>0)),366,365)","v":366},"2024-12-31",null,{"$f":"IFERROR(D10+tbl_Histo_AVENIR2_CH1[[#This Row],[Opération]],tbl_Histo_AVENIR2_CH1[[#This Row],[Opération]])","v":{"v":50000,"d":"50,000.00"}},{"v":60996,"d":"60,996.00"},{"$f":"tbl_Histo_AVENIR2_CH1[[#This Row],[Valorisation]]-tbl_Histo_AVENIR2_CH1[[#This Row],[Net Investi]]","v":{"v":10996,"d":"10,996.00"}},{"$f":"tbl_Histo_AVENIR2_CH1[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_CH1[[#This Row],[Net Investi]]","v":{"v":0.21992,"d":"22%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_CH1[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_CH1[[#This Row],[Ans Cumul.]]/tbl_Histo_AVENIR2_CH1[[#This Row],[Invest. Moyen]],0)","v":{"v":0.08654916129032258,"d":"9%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_CH1[[#This Row],[Nb Cumul]]/tbl_Histo_AVENIR2_CH1[[#This Row],[Bissextile]]/tbl_Histo_AVENIR2_CH1[[#This Row],[Ans Cumul.]],0)","v":{"v":50000,"d":"50,000.00"}},{"$f":"IFERROR(DATEDIF(B10,tbl_Histo_AVENIR2_CH1[[#This Row],[Date]],\"D\"),0)","v":366},{"$f":"DATEDIF($B$8,tbl_Histo_AVENIR2_CH1[[#This Row],[Date]],\"d\")/tbl_Histo_AVENIR2_CH1[[#This Row],[Bissextile]]","v":{"v":2.540983606557377,"d":"2.54"}},{"$f":"IFERROR(D10*tbl_Histo_AVENIR2_CH1[[#This Row],[Jours/Période]]+L10,0)","v":{"v":46500000,"d":"46,500,000.00"}}]
[{"$f":"IF(OR(MOD(YEAR(tbl_Histo_AVENIR2_CH1[[#This Row],[Date]]),400)=0,AND(MOD(YEAR(tbl_Histo_AVENIR2_CH1[[#This Row],[Date]]),4)=0,MOD(YEAR(tbl_Histo_AVENIR2_CH1[[#This Row],[Date]]),100)<>0)),366,365)","v":365},"2025-02-14",{"v":5000,"d":"5,000.00"},{"$f":"IFERROR(D11+tbl_Histo_AVENIR2_CH1[[#This Row],[Opération]],tbl_Histo_AVENIR2_CH1[[#This Row],[Opération]])","v":{"v":55000,"d":"55,000.00"}},{"v":67900,"d":"67,900.00"},{"$f":"tbl_Histo_AVENIR2_CH1[[#This Row],[Valorisation]]-tbl_Histo_AVENIR2_CH1[[#This Row],[Net Investi]]","v":{"v":12900,"d":"12,900.00"}},{"$f":"tbl_Histo_AVENIR2_CH1[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_CH1[[#This Row],[Net Investi]]","v":{"v":0.23454545454545456,"d":"23%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_CH1[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_CH1[[#This Row],[Ans Cumul.]]/tbl_Histo_AVENIR2_CH1[[#This Row],[Invest. Moyen]],0)","v":{"v":0.0965846153846154,"d":"10%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_CH1[[#This Row],[Nb Cumul]]/tbl_Histo_AVENIR2_CH1[[#This Row],[Bissextile]]/tbl_Histo_AVENIR2_CH1[[#This Row],[Ans Cumul.]],0)","v":{"v":50000,"d":"50,000.00"}},{"$f":"IFERROR(DATEDIF(B11,tbl_Histo_AVENIR2_CH1[[#This Row],[Date]],\"D\"),0)","v":45},{"$f":"DATEDIF($B$8,tbl_Histo_AVENIR2_CH1[[#This Row],[Date]],\"d\")/tbl_Histo_AVENIR2_CH1[[#This Row],[Bissextile]]","v":{"v":2.671232876712329,"d":"2.67"}},{"$f":"IFERROR(D11*tbl_Histo_AVENIR2_CH1[[#This Row],[Jours/Période]]+L11,0)","v":{"v":48750000,"d":"48,750,000.00"}}]
[{"$f":"IF(OR(MOD(YEAR(tbl_Histo_AVENIR2_CH1[[#This Row],[Date]]),400)=0,AND(MOD(YEAR(tbl_Histo_AVENIR2_CH1[[#This Row],[Date]]),4)=0,MOD(YEAR(tbl_Histo_AVENIR2_CH1[[#This Row],[Date]]),100)<>0)),366,365)","v":365},"2025-05-10",null,{"$f":"IFERROR(D12+tbl_Histo_AVENIR2_CH1[[#This Row],[Opération]],tbl_Histo_AVENIR2_CH1[[#This Row],[Opération]])","v":{"v":55000,"d":"55,000.00"}},{"v":65295.22,"d":"65,295.22"},{"$f":"tbl_Histo_AVENIR2_CH1[[#This Row],[Valorisation]]-tbl_Histo_AVENIR2_CH1[[#This Row],[Net Investi]]","v":{"v":10295.220000000001,"d":"10,295.22"}},{"$f":"tbl_Histo_AVENIR2_CH1[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_CH1[[#This Row],[Net Investi]]","v":{"v":0.1871858181818182,"d":"19%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_CH1[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_CH1[[#This Row],[Ans Cumul.]]/tbl_Histo_AVENIR2_CH1[[#This Row],[Invest. Moyen]],0)","v":{"v":0.0703370201216659,"d":"7%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_CH1[[#This Row],[Nb Cumul]]/tbl_Histo_AVENIR2_CH1[[#This Row],[Bissextile]]/tbl_Histo_AVENIR2_CH1[[#This Row],[Ans Cumul.]],0)","v":{"v":50400.943396226416,"d":"50,400.94"}},{"$f":"IFERROR(DATEDIF(B12,tbl_Histo_AVENIR2_CH1[[#This Row],[Date]],\"D\"),0)","v":85},{"$f":"DATEDIF($B$8,tbl_Histo_AVENIR2_CH1[[#This Row],[Date]],\"d\")/tbl_Histo_AVENIR2_CH1[[#This Row],[Bissextile]]","v":{"v":2.904109589041096,"d":"2.90"}},{"$f":"IFERROR(D12*tbl_Histo_AVENIR2_CH1[[#This Row],[Jours/Période]]+L12,0)","v":{"v":53425000,"d":"53,425,000.00"}}]

{"sheet":"001000 L8 269701111","index":5,"n_rows":12,"n_cols":12,"rows_kept":12,"merged":[[0,2,0,3],[0,5,0,7],[1,2,1,3]]}
[null,"Assureur","Référence"]
[null,"MonAvenir","001000 L8 269701111"]
[]
[null,"Produit","Souscripteur"]
[null,"AVENIR *","Anne"]
[{"$nulls":4},{"$f":"B5 &\" - \" &C5 &\" - \" &TEXT(B8,\"jj mmm aaaa\")","v":"AVENIR * - Anne - 24 août 2022"}]
["Bissextile","Date","Opération","Net Investi","Valorisation","+/- Value","Performance","TMA net","Invest. Moyen","Jours/Période","Ans Cumul.","Nb Cumul"]
[{"$f":"IF(OR(MOD(YEAR(tbl_Histo_AVENIR2_CH2[[#This Row],[Date]]),400)=0,AND(MOD(YEAR(tbl_Histo_AVENIR2_CH2[[#This Row],[Date]]),4)=0,MOD(YEAR(tbl_Histo_AVENIR2_CH2[[#This Row],[Date]]),100)<>0)),366,365)","v":365},"2022-08-24",{"v":70000,"d":"70,000.00"},{"$f":"IFERROR(D7+tbl_Histo_AVENIR2_CH2[[#This Row],[Opération]],tbl_Histo_AVENIR2_CH2[[#This Row],[Opération]])","v":{"v":70000,"d":"70,000.00"}},{"v":70000,"d":"70,000.00"},{"$f":"tbl_Histo_AVENIR2_CH2[[#This Row],[Valorisation]]-tbl_Histo_AVENIR2_CH2[[#This Row],[Net Investi]]","v":{"v":0,"d":"0.00"}},{"$f":"tbl_Histo_AVENIR2_CH2[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_CH2[[#This Row],[Net Investi]]","v":{"v":0,"d":"0%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_CH2[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_CH2[[#This Row],[Ans Cumul.]]/tbl_Histo_AVENIR2_CH2[[#This Row],[Invest. Moyen]],0)","v":{"v":0,"d":"0%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_CH2[[#This Row],[Nb Cumul]]/tbl_Histo_AVENIR2_CH2[[#This Row],[Bissextile]]/tbl_Histo_AVENIR2_CH2[[#This Row],[Ans Cumul.]],0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(DATEDIF(B7,tbl_Histo_AVENIR2_CH2[[#This Row],[Date]],\"D\"),0)","v":0},{"$f":"DATEDIF($B$8,tbl_Histo_AVENIR2_CH2[[#This Row],[Date]],\"D\")/tbl_Histo_AVENIR2_CH2[[#This Row],[Bissextile]]","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(D7*tbl_Histo_AVENIR2_CH2[[#This Row],[Jours/Période]]+L7,0)","v":0}]
[{"$f":"IF(OR(MOD(YEAR(tbl_Histo_AVENIR2_CH2[[#This Row],[Date]]),400)=0,AND(MOD(YEAR(tbl_Histo_AVENIR2_CH2[[#This Row],[Date]]),4)=0,MOD(YEAR(tbl_Histo_AVENIR2_CH2[[#This Row],[Date]]),100)<>0)),366,365)","v":365},"2022-12-31",null,{"$f":"IFERROR(D8+tbl_Histo_AVENIR2_CH2[[#This Row],[Opération]],tbl_Histo_AVENIR2_CH2[[#This Row],[Opération]])","v":{"v":70000,"d":"70,000.00"}},{"v":67584.97,"d":"67,584.97"},{"$f":"tbl_Histo_AVENIR2_CH2[[#This Row],[Valorisation]]-tbl_Histo_AVENIR2_CH2[[#This Row],[Net Investi]]","v":{"v":-2415.029999999999,"d":"-2,415.03"}},{"$f":"tbl_Histo_AVENIR2_CH2[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_CH2[[#This Row],[Net Investi]]","v":{"v":-0.03450042857142856,"d":"-3%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_CH2[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_CH2[[#This Row],[Ans Cumul.]]/tbl_Histo_AVENIR2_CH2[[#This Row],[Invest. Moyen]],0)","v":{"v":-0.09761749169435212,"d":"-10%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_CH2[[#This Row],[Nb Cumul]]/tbl_Histo_AVENIR2_CH2[[#This Row],[Bissextile]]/tbl_Histo_AVENIR2_CH2[[#This Row],[Ans Cumul.]],0)","v":{"v":70000,"d":"70,000.00"}},{"$f":"IFERROR(DATEDIF(B8,tbl_Histo_AVENIR2_CH2[[#This Row],[Date]],\"D\"),0)","v":129},{"$f":"DATEDIF($B$8,tbl_Histo_AVENIR2_CH2[[#This Row],[Date]],\"D\")/tbl_Histo_AVENIR2_CH2[[#This Row],[Bissextile]]","v":{"v":0.35342465753424657,"d":"0.35"}},{"$f":"IFERROR(D8*tbl_Histo_AVENIR2_CH2[[#This Row],[Jours/Période]]+L8,0)","v":{"v":9030000,"d":"9,030,000"}}]
[{"$f":"IF(OR(MOD(YEAR(tbl_Histo_AVENIR2_CH2[[#This Row],[Date]]),400)=0,AND(MOD(YEAR(tbl_Histo_AVENIR2_CH2[[#This Row],[Date]]),4)=0,MOD(YEAR(tbl_Histo_AVENIR2_CH2[[#This Row],[Date]]),100)<>0)),366,365)","v":365},"2023-12-31",null,{"$f":"IFERROR(D9+tbl_Histo_AVENIR2_CH2[[#This Row],[Opération]],tbl_Histo_AVENIR2_CH2[[#This Row],[Opération]])","v":{"v":70000,"d":"70,000.00"}},{"v":73905.52,"d":"73,905.52"},{"$f":"tbl_Histo_AVENIR2_CH2[[#This Row],[Valorisation]]-tbl_Histo_AVENIR2_CH2[[#This Row],[Net Investi]]","v":{"v":3905.520000000004,"d":"3,905.52"}},{"$f":"tbl_Histo_AVENIR2_CH2[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_CH2[[#This Row],[Net Investi]]","v":{"v":0.055793142857142916,"d":"6%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_CH2[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_CH2[[#This Row],[Ans Cumul.]]/tbl_Histo_AVENIR2_CH2[[#This Row],[Invest. Moyen]],0)","v":{"v":0.041223678426836365,"d":"4%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_CH2[[#This Row],[Nb Cumul]]/tbl_Histo_AVENIR2_CH2[[#This Row],[Bissextile]]/tbl_Histo_AVENIR2_CH2[[#This Row],[Ans Cumul.]],0)","v":{"v":70000,"d":"70,000.00"}},{"$f":"IFERROR(DATEDIF(B9,tbl_Histo_AVENIR2_CH2[[#This Row],[Date]],\"D\"),0)","v":365},{"$f":"DATEDIF($B$8,tbl_Histo_AVENIR2_CH2[[#This Row],[Date]],\"D\")/tbl_Histo_AVENIR2_CH2[[#This Row],[Bissextile]]","v":{"v":1.3534246575342466,"d":"1.35"}},{"$f":"IFERROR(D9*tbl_Histo_AVENIR2_CH2[[#This Row],[Jours/Période]]+L9,0)","v":{"v":34580000,"d":"34,580,000"}}]
[{"$f":"IF(OR(MOD(YEAR(tbl_Histo_AVENIR2_CH2[[#This Row],[Date]]),400)=0,AND(MOD(YEAR(tbl_Histo_AVENIR2_CH2[[#This Row],[Date]]),4)=0,MOD(YEAR(tbl_Histo_AVENIR2_CH2[[#This Row],[Date]]),100)<>0)),366,365)","v":366},"2024-12-31",null,{"$f":"IFERROR(D10+tbl_Histo_AVENIR2_CH2[[#This Row],[Opération]],tbl_Histo_AVENIR2_CH2[[#This Row],[Opération]])","v":{"v":70000,"d":"70,000.00"}},{"v":81905,"d":"81,905.00"},{"$f":"tbl_Histo_AVENIR2_CH2[[#This Row],[Valorisation]]-tbl_Histo_AVENIR2_CH2[[#This Row],[Net Investi]]","v":{"v":11905,"d":"11,905.00"}},{"$f":"tbl_Histo_AVENIR2_CH2[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_CH2[[#This Row],[Net Investi]]","v":{"v":0.17007142857142857,"d":"17%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_CH2[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_CH2[[#This Row],[Ans Cumul.]]/tbl_Histo_AVENIR2_CH2[[#This Row],[Invest. Moyen]],0)","v":{"v":0.07237923588039867,"d":"7%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_CH2[[#This Row],[Nb Cumul]]/tbl_Histo_AVENIR2_CH2[[#This Row],[Bissextile]]/tbl_Histo_AVENIR2_CH2[[#This Row],[Ans Cumul.]],0)","v":{"v":70000,"d":"70,000.00"}},{"$f":"IFERROR(DATEDIF(B10,tbl_Histo_AVENIR2_CH2[[#This Row],[Date]],\"D\"),0)","v":366},{"$f":"DATEDIF($B$8,tbl_Histo_AVENIR2_CH2[[#This Row],[Date]],\"D\")/tbl_Histo_AVENIR2_CH2[[#This Row],[Bissextile]]","v":{"v":2.349726775956284,"d":"2.35"}},{"$f":"IFERROR(D10*tbl_Histo_AVENIR2_CH2[[#This Row],[Jours/Période]]+L10,0)","v":{"v":60200000,"d":"60,200,000"}}]
[{"$f":"IF(OR(MOD(YEAR(tbl_Histo_AVENIR2_CH2[[#This Row],[Date]]),400)=0,AND(MOD(YEAR(tbl_Histo_AVENIR2_CH2[[#This Row],[Date]]),4)=0,MOD(YEAR(tbl_Histo_AVENIR2_CH2[[#This Row],[Date]]),100)<>0)),366,365)","v":365},"2025-05-10",null,{"$f":"IFERROR(D11+tbl_Histo_AVENIR2_CH2[[#This Row],[Opération]],tbl_Histo_AVENIR2_CH2[[#This Row],[Opération]])","v":{"v":70000,"d":"70,000.00"}},{"v":81494.87,"d":"81,494.87"},{"$f":"tbl_Histo_AVENIR2_CH2[[#This Row],[Valorisation]]-tbl_Histo_AVENIR2_CH2[[#This Row],[Net Investi]]","v":{"v":11494.869999999995,"d":"11,494.87"}},{"$f":"tbl_Histo_AVENIR2_CH2[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_CH2[[#This Row],[Net Investi]]","v":{"v":0.1642124285714285,"d":"16%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_CH2[[#This Row],[+/- Value]]/tbl_Histo_AVENIR2_CH2[[#This Row],[Ans Cumul.]]/tbl_Histo_AVENIR2_CH2[[#This Row],[Invest. Moyen]],0)","v":{"v":0.06054296608946606,"d":"6%"}},{"$f":"IFERROR(tbl_Histo_AVENIR2_CH2[[#This Row],[Nb Cumul]]/tbl_Histo_AVENIR2_CH2[[#This Row],[Bissextile]]/tbl_Histo_AVENIR2_CH2[[#This Row],[Ans Cumul.]],0)","v":{"v":70000,"d":"70,000.00"}},{"$f":"IFERROR(DATEDIF(B11,tbl_Histo_AVENIR2_CH2[[#This Row],[Date]],\"D\"),0)","v":130},{"$f":"DATEDIF($B$8,tbl_Histo_AVENIR2_CH2[[#This Row],[Date]],\"D\")/tbl_Histo_AVENIR2_CH2[[#This Row],[Bissextile]]","v":{"v":2.712328767123288,"d":"2.71"}},{"$f":"IFERROR(D11*tbl_Histo_AVENIR2_CH2[[#This Row],[Jours/Période]]+L11,0)","v":{"v":69300000,"d":"69,300,000"}}]

{"sheet":"444510920","index":6,"n_rows":14,"n_cols":12,"rows_kept":14,"merged":[[0,5,0,7],[3,2,3,3]]}
[null,"Assureur","Référence"]
[null,"Abeille",444510920]
[]
[null,"Produit","Souscripteur"]
[null,"Miel  2","Pierre / Anne"]
[{"$nulls":4},{"$f":"B5 &\" - \" &C5 &\" - \" &TEXT(B8,\"jj mmm aaaa\")","v":"Miel  2 - Pierre / Anne - 27 juin 2022"}]
["Bissextile","Date","Opération","Net Investi","Valorisation","  +/- Value","Performance","TMA net","Invest. Moyen","Jours/Période","Ans Cumul.","Nb Cumul"]
[{"$f":"IF(OR(MOD(YEAR(tbl_Histo_SPIRIT2[[#This Row],[Date]]),400)=0,AND(MOD(YEAR(tbl_Histo_SPIRIT2[[#This Row],[Date]]),4)=0,MOD(YEAR(tbl_Histo_SPIRIT2[[#This Row],[Date]]),100)<>0)),366,365)","v":365},"2022-06-27",{"v":75000,"d":"75,000.00"},{"$f":"IFERROR(D7+tbl_Histo_SPIRIT2[[#This Row],[Opération]],tbl_Histo_SPIRIT2[[#This Row],[Opération]])","v":{"v":75000,"d":"75,000.00"}},{"v":75000,"d":"75,000.00"},{"$f":"tbl_Histo_SPIRIT2[[#This Row],[Valorisation]]-tbl_Histo_SPIRIT2[[#This Row],[Net Investi]]","v":{"v":0,"d":"0.00"}},{"$f":"tbl_Histo_SPIRIT2[[#This Row],[  +/- Value]]/tbl_Histo_SPIRIT2[[#This Row],[Net Investi]]","v":{"v":0,"d":"0%"}},{"$f":"IFERROR(tbl_Histo_SPIRIT2[[#This Row],[  +/- Value]]/tbl_Histo_SPIRIT2[[#This Row],[Ans Cumul.]]/tbl_Histo_SPIRIT2[[#This Row],[Invest. Moyen]],0)","v":{"v":0,"d":"0%"}},{"$f":"IFERROR(tbl_Histo_SPIRIT2[[#This Row],[Nb Cumul]]/tbl_Histo_SPIRIT2[[#This Row],[Bissextile]]/tbl_Histo_SPIRIT2[[#This Row],[Ans Cumul.]],0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(DATEDIF(B7,tbl_Histo_SPIRIT2[[#This Row],[Date]],\"D\"),0)","v":0},{"$f":"DATEDIF($B$8,tbl_Histo_SPIRIT2[[#This Row],[Date]],\"D\")/tbl_Histo_SPIRIT2[[#This Row],[Bissextile]]","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(D7*tbl_Histo_SPIRIT2[[#This Row],[Jours/Période]]+L7,0)","v":0}]
[{"$f":"IF(OR(MOD(YEAR(tbl_Histo_SPIRIT2[[#This Row],[Date]]),400)=0,AND(MOD(YEAR(tbl_Histo_SPIRIT2[[#This Row],[Date]]),4)=0,MOD(YEAR(tbl_Histo_SPIRIT2[[#This Row],[Date]]),100)<>0)),366,365)","v":365},"2022-12-31",null,{"$f":"IFERROR(D8+tbl_Histo_SPIRIT2[[#This Row],[Opération]],tbl_Histo_SPIRIT2[[#This Row],[Opération]])","v":{"v":75000,"d":"75,000.00"}},{"v":71341.87,"d":"71,341.87"},{"$f":"tbl_Histo_SPIRIT2[[#This Row],[Valorisation]]-tbl_Histo_SPIRIT2[[#This Row],[Net Investi]]","v":{"v":-3658.1300000000047,"d":"-3,658.13"}},{"$f":"tbl_Histo_SPIRIT2[[#This Row],[  +/- Value]]/tbl_Histo_SPIRIT2[[#This Row],[Net Investi]]","v":{"v":-0.04877506666666673,"d":"-5%"}},{"$f":"IFERROR(tbl_Histo_SPIRIT2[[#This Row],[  +/- Value]]/tbl_Histo_SPIRIT2[[#This Row],[Ans Cumul.]]/tbl_Histo_SPIRIT2[[#This Row],[Invest. Moyen]],0)","v":{"v":-0.09520267023172917,"d":"-10%"}},{"$f":"IFERROR(tbl_Histo_SPIRIT2[[#This Row],[Nb Cumul]]/tbl_Histo_SPIRIT2[[#This Row],[Bissextile]]/tbl_Histo_SPIRIT2[[#This Row],[Ans Cumul.]],0)","v":{"v":75000,"d":"75,000.00"}},{"$f":"IFERROR(DATEDIF(B8,tbl_Histo_SPIRIT2[[#This Row],[Date]],\"D\"),0)","v":187},{"$f":"DATEDIF($B$8,tbl_Histo_SPIRIT2[[#This Row],[Date]],\"D\")/tbl_Histo_SPIRIT2[[#This Row],[Bissextile]]","v":{"v":0.5123287671232877,"d":"0.51"}},{"$f":"IFERROR(D8*tbl_Histo_SPIRIT2[[#This Row],[Jours/Période]]+L8,0)","v":{"v":14025000,"d":"14,025,000"}}]
[{"$f":"IF(OR(MOD(YEAR(tbl_Histo_SPIRIT2[[#This Row],[Date]]),400)=0,AND(MOD(YEAR(tbl_Histo_SPIRIT2[[#This Row],[Date]]),4)=0,MOD(YEAR(tbl_Histo_SPIRIT2[[#This Row],[Date]]),100)<>0)),366,365)","v":365},"2023-12-06",{"v":-19000,"d":"(19,000.00)"},{"$f":"IFERROR(D9+tbl_Histo_SPIRIT2[[#This Row],[Opération]],tbl_Histo_SPIRIT2[[#This Row],[Opération]])","v":{"v":56000,"d":"56,000.00"}},{"v":57547.16,"d":"57,547.16"},{"$f":"tbl_Histo_SPIRIT2[[#This Row],[Valorisation]]-tbl_Histo_SPIRIT2[[#This Row],[Net Investi]]","v":{"v":1547.1600000000035,"d":"1,547.16"}},{"$f":"tbl_Histo_SPIRIT2[[#This Row],[  +/- Value]]/tbl_Histo_SPIRIT2[[#This Row],[Net Investi]]","v":{"v":0.027627857142857204,"d":"3%"}},{"$f":"IFERROR(tbl_Histo_SPIRIT2[[#This Row],[  +/- Value]]/tbl_Histo_SPIRIT2[[#This Row],[Ans Cumul.]]/tbl_Histo_SPIRIT2[[#This Row],[Invest. Moyen]],0)","v":{"v":0.01428749905123343,"d":"1%"}},{"$f":"IFERROR(tbl_Histo_SPIRIT2[[#This Row],[Nb Cumul]]/tbl_Histo_SPIRIT2[[#This Row],[Bissextile]]/tbl_Histo_SPIRIT2[[#This Row],[Ans Cumul.]],0)","v":{"v":75000,"d":"75,000.00"}},{"$f":"IFERROR(DATEDIF(B9,tbl_Histo_SPIRIT2[[#This Row],[Date]],\"D\"),0)","v":340},{"$f":"DATEDIF($B$8,tbl_Histo_SPIRIT2[[#This Row],[Date]],\"D\")/tbl_Histo_SPIRIT2[[#This Row],[Bissextile]]","v":{"v":1.4438356164383561,"d":"1.44"}},{"$f":"IFERROR(D9*tbl_Histo_SPIRIT2[[#This Row],[Jours/Période]]+L9,0)","v":{"v":39525000,"d":"39,525,000"}}]
[{"$f":"IF(OR(MOD(YEAR(tbl_Histo_SPIRIT2[[#This Row],[Date]]),400)=0,AND(MOD(YEAR(tbl_Histo_SPIRIT2[[#This Row],[Date]]),4)=0,MOD(YEAR(tbl_Histo_SPIRIT2[[#This Row],[Date]]),100)<>0)),366,365)","v":365},"2023-12-31",null,{"$f":"IFERROR(D10+tbl_Histo_SPIRIT2[[#This Row],[Opération]],tbl_Histo_SPIRIT2[[#This Row],[Opération]])","v":{"v":56000,"d":"56,000.00"}},{"v":58239.32,"d":"58,239.32"},{"$f":"tbl_Histo_SPIRIT2[[#This Row],[Valorisation]]-tbl_Histo_SPIRIT2[[#This Row],[Net Investi]]","v":{"v":2239.3199999999997,"d":"2,239.32"}},{"$f":"tbl_Histo_SPIRIT2[[#This Row],[  +/- Value]]/tbl_Histo_SPIRIT2[[#This Row],[Net Investi]]","v":{"v":0.03998785714285714,"d":"4%"}},{"$f":"IFERROR(tbl_Histo_SPIRIT2[[#This Row],[  +/- Value]]/tbl_Histo_SPIRIT2[[#This Row],[Ans Cumul.]]/tbl_Histo_SPIRIT2[[#This Row],[Invest. Moyen]],0)","v":{"v":0.019971943799633473,"d":"2%"}},{"$f":"IFERROR(tbl_Histo_SPIRIT2[[#This Row],[Nb Cumul]]/tbl_Histo_SPIRIT2[[#This Row],[Bissextile]]/tbl_Histo_SPIRIT2[[#This Row],[Ans Cumul.]],0)","v":{"v":74139.49275362318,"d":"74,139.49"}},{"$f":"IFERROR(DATEDIF(B10,tbl_Histo_SPIRIT2[[#This Row],[Date]],\"D\"),0)","v":25},{"$f":"DATEDIF($B$8,tbl_Histo_SPIRIT2[[#This Row],[Date]],\"D\")/tbl_Histo_SPIRIT2[[#This Row],[Bissextile]]","v":{"v":1.5123287671232877,"d":"1.51"}},{"$f":"IFERROR(D10*tbl_Histo_SPIRIT2[[#This Row],[Jours/Période]]+L10,0)","v":{"v":40925000,"d":"40,925,000"}}]
[{"$f":"IF(OR(MOD(YEAR(tbl_Histo_SPIRIT2[[#This Row],[Date]]),400)=0,AND(MOD(YEAR(tbl_Histo_SPIRIT2[[#This Row],[Date]]),4)=0,MOD(YEAR(tbl_Histo_SPIRIT2[[#This Row],[Date]]),100)<>0)),366,365)","v":366},"2024-12-31",null,{"$f":"IFERROR(D11+tbl_Histo_SPIRIT2[[#This Row],[Opération]],tbl_Histo_SPIRIT2[[#This Row],[Opération]])","v":{"v":56000,"d":"56,000.00"}},{"v":64227.86,"d":"64,227.86"},{"$f":"tbl_Histo_SPIRIT2[[#This Row],[Valorisation]]-tbl_Histo_SPIRIT2[[#This Row],[Net Investi]]","v":{"v":8227.86,"d":"8,227.86"}},{"$f":"tbl_Histo_SPIRIT2[[#This Row],[  +/- Value]]/tbl_Histo_SPIRIT2[[#This Row],[Net Investi]]","v":{"v":0.14692607142857145,"d":"15%"}},{"$f":"IFERROR(tbl_Histo_SPIRIT2[[#This Row],[  +/- Value]]/tbl_Histo_SPIRIT2[[#This Row],[Ans Cumul.]]/tbl_Histo_SPIRIT2[[#This Row],[Invest. Moyen]],0)","v":{"v":0.0490287810358021,"d":"5%"}},{"$f":"IFERROR(tbl_Histo_SPIRIT2[[#This Row],[Nb Cumul]]/tbl_Histo_SPIRIT2[[#This Row],[Bissextile]]/tbl_Histo_SPIRIT2[[#This Row],[Ans Cumul.]],0)","v":{"v":66907.4074074074,"d":"66,907.41"}},{"$f":"IFERROR(DATEDIF(B11,tbl_Histo_SPIRIT2[[#This Row],[Date]],\"D\"),0)","v":366},{"$f":"DATEDIF($B$8,tbl_Histo_SPIRIT2[[#This Row],[Date]],\"D\")/tbl_Histo_SPIRIT2[[#This Row],[Bissextile]]","v":{"v":2.5081967213114753,"d":"2.51"}},{"$f":"IFERROR(D11*tbl_Histo_SPIRIT2[[#This Row],[Jours/Période]]+L11,0)","v":{"v":61421000,"d":"61,421,000"}}]
[{"$f":"IF(OR(MOD(YEAR(tbl_Histo_SPIRIT2[[#This Row],[Date]]),400)=0,AND(MOD(YEAR(tbl_Histo_SPIRIT2[[#This Row],[Date]]),4)=0,MOD(YEAR(tbl_Histo_SPIRIT2[[#This Row],[Date]]),100)<>0)),366,365)","v":365},"2025-02-17",{"v":4000,"d":"4,000.00"},{"$f":"IFERROR(D12+tbl_Histo_SPIRIT2[[#This Row],[Opération]],tbl_Histo_SPIRIT2[[#This Row],[Opération]])","v":{"v":60000,"d":"60,000.00"}},{"v":70507.39,"d":"70,507.39"},{"$f":"tbl_Histo_SPIRIT2[[#This Row],[Valorisation]]-tbl_Histo_SPIRIT2[[#This Row],[Net Investi]]","v":{"v":10507.39,"d":"10,507.39"}},{"$f":"tbl_Histo_SPIRIT2[[#This Row],[  +/- Value]]/tbl_Histo_SPIRIT2[[#This Row],[Net Investi]]","v":{"v":0.17512316666666666,"d":"18%"}},{"$f":"IFERROR(tbl_Histo_SPIRIT2[[#This Row],[  +/- Value]]/tbl_Histo_SPIRIT2[[#This Row],[Ans Cumul.]]/tbl_Histo_SPIRIT2[[#This Row],[Invest. Moyen]],0)","v":{"v":0.059823072423528675,"d":"6%"}},{"$f":"IFERROR(tbl_Histo_SPIRIT2[[#This Row],[Nb Cumul]]/tbl_Histo_SPIRIT2[[#This Row],[Bissextile]]/tbl_Histo_SPIRIT2[[#This Row],[Ans Cumul.]],0)","v":{"v":66365.42443064183,"d":"66,365.42"}},{"$f":"IFERROR(DATEDIF(B12,tbl_Histo_SPIRIT2[[#This Row],[Date]],\"D\"),0)","v":48},{"$f":"DATEDIF($B$8,tbl_Histo_SPIRIT2[[#This Row],[Date]],\"D\")/tbl_Histo_SPIRIT2[[#This Row],[Bissextile]]","v":{"v":2.6465753424657534,"d":"2.65"}},{"$f":"IFERROR(D12*tbl_Histo_SPIRIT2[[#This Row],[Jours/Période]]+L12,0)","v":{"v":64109000,"d":"64,109,000"}}]
[{"$f":"IF(OR(MOD(YEAR(tbl_Histo_SPIRIT2[[#This Row],[Date]]),400)=0,AND(MOD(YEAR(tbl_Histo_SPIRIT2[[#This Row],[Date]]),4)=0,MOD(YEAR(tbl_Histo_SPIRIT2[[#This Row],[Date]]),100)<>0)),366,365)","v":365},"2025-05-10",null,{"$f":"IFERROR(D13+tbl_Histo_SPIRIT2[[#This Row],[Opération]],tbl_Histo_SPIRIT2[[#This Row],[Opération]])","v":{"v":60000,"d":"60,000.00"}},{"v":66697.68,"d":"66,697.68"},{"$f":"tbl_Histo_SPIRIT2[[#This Row],[Valorisation]]-tbl_Histo_SPIRIT2[[#This Row],[Net Investi]]","v":{"v":6697.679999999993,"d":"6,697.68"}},{"$f":"tbl_Histo_SPIRIT2[[#This Row],[  +/- Value]]/tbl_Histo_SPIRIT2[[#This Row],[Net Investi]]","v":{"v":0.11162799999999988,"d":"11%"}},{"$f":"IFERROR(tbl_Histo_SPIRIT2[[#This Row],[  +/- Value]]/tbl_Histo_SPIRIT2[[#This Row],[Ans Cumul.]]/tbl_Histo_SPIRIT2[[#This Row],[Invest. Moyen]],0)","v":{"v":0.03541487201031447,"d":"4%"}},{"$f":"IFERROR(tbl_Histo_SPIRIT2[[#This Row],[Nb Cumul]]/tbl_Histo_SPIRIT2[[#This Row],[Bissextile]]/tbl_Histo_SPIRIT2[[#This Row],[Ans Cumul.]],0)","v":{"v":65867.36641221373,"d":"65,867.37"}},{"$f":"IFERROR(DATEDIF(B13,tbl_Histo_SPIRIT2[[#This Row],[Date]],\"D\"),0)","v":82},{"$f":"DATEDIF($B$8,tbl_Histo_SPIRIT2[[#This Row],[Date]],\"D\")/tbl_Histo_SPIRIT2[[#This Row],[Bissextile]]","v":{"v":2.871232876712329,"d":"2.87"}},{"$f":"IFERROR(D13*tbl_Histo_SPIRIT2[[#This Row],[Jours/Période]]+L13,0)","v":{"v":69029000,"d":"69,029,000"}}]

{"sheet":"Infos","index":7,"n_rows":11,"n_cols":2,"rows_kept":11}
[]
[null,"FISCALITE"]
{"$rows_empty":8}
[null,"INFORMATIONS"]