{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["RÉCAPITULATIF DU REPORTING","2022","2021","2020","2019","2018","2017","2016","2015","2014","2013","2012","2011","2010","2009","source","DonnéesDeGraphique"],"not_rendered":{"charts":2,"images":2,"macros":1,"external_links":0,"defined_names":55,"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":"RÉCAPITULATIF DU REPORTING","index":0,"n_rows":28,"n_cols":5,"rows_kept":28,"cut":false,"hidden":false,"merged":[[26,2,26,3],[5,5,5,6],[6,5,6,6],[7,5,7,6],[1,4,1,6],[4,3,4,4],[3,5,3,6],[4,5,4,6],[2,4,2,6],[2,1,2,3]]}
[null,null,null,null,"Dépenses détaillées"]
[null,"NPAI FLASH",null,"suivi des Npai"]
[null,"INFORMATIONS SUR LE PROJET",null,null,2020]
[null,"Nom du Reporting",null,"Reporting NPAI"]
[null,"Description du Reporting",null,"Gestion des NPAI arrivant sur site"]
[null,"Année",null,{"$f":"YEAR(TODAY())","v":2022}]
[null,"Mois",null,"Juillet"]
[]
[null,"CHIFFRES"]
[null,"au mois"]
[null,"Npai Flashé au Mois",{"$f":"VLOOKUP(D7,INDIRECT(\"'\"&E3&\"'!B4:C16\"),2,FALSE)","v":0}]
[null,"N° de Carton Début du Mois",{"$f":"VLOOKUP(D7,INDIRECT(\"'\"&E3&\"'!B4:D16\"),3,FALSE)","v":837}]
[null,"N° de Carton Fin du Mois",{"$f":"VLOOKUP(D7,INDIRECT(\"'\"&E3&\"'!B4:E16\"),4,FALSE)","v":837}]
[null,"Nombre de Carton au Mois",{"$f":"VLOOKUP(D7,INDIRECT(\"'\"&E3&\"'!B4:F16\"),5,FALSE)","v":0}]
[null,"à l'année"]
[null,"Npai Flashé à L'Année",{"$f":"INDIRECT(\"'\"&E3&\"'!C17\")","v":56085}]
[null,"N° de Carton Début de L'Année",{"$f":"INDIRECT(\"'\"&E3&\"'!D4\")","v":739}]
[null,"N° de Carton Fin de L'Année",{"$f":"INDIRECT(\"'\"&E3&\"'!E15\")","v":879}]
[null,"Nombre de Carton à L'Année",{"$f":"INDIRECT(\"'\"&E3&\"'!F17\")","v":140}]
[null,"Mois le plus important",{"$f":"MAX(source!E6:E17)","v":16069},{"$f":"_xlfn.XLOOKUP(C20,source!E6:E17,source!D6:D17,0)","v":"Juin"}]
[null,"Mois le moins important",{"$f":"MIN(source!E6:E17)","v":0},{"$f":"_xlfn.XLOOKUP(C21,source!E6:E17,source!D6:D17,0)","v":"Avril"}]
[null,"les 4 dernières années"]
[null,2019,{"$f":"'2019'!C17","v":45398}]
[null,2020,{"$f":"'2020'!C17","v":56085}]
[null,2021,{"$f":"'2021'!C17","v":33022}]
[null,2022,{"$f":"'2022'!C17","v":24472}]
[null,"Nombre Total de NPAI",{"$f":"SUM('2022:2009'!C17)","v":531636}]
[null,"soit en moyenne / année",{"$f":"source!B21","v":37974}]

{"sheet":"2022","index":1,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"  "]
[null,null,null,null,null,null,{"$f":"MID(CELL(\"nomfichier\",B1),FIND(\"]\",CELL(\"nomfichier\",B1))+1,LEN(CELL(\"nomfichier\",B1))-FIND(\"]\",CELL(\"nomfichier\",B1)))","v":"2022"}]
[null,"Mois","Npai Flashé","N° de Carton de Début","N° de Carton de Fin","Total"]
[null,"Janvier",8605,946,963,{"$f":"MAX(0,E4-D4)","v":17}]
[null,"Février",0,{"$f":"E4","v":963},963,{"$f":"MAX(0,E5-D5)","v":0}]
[null,"Mars",1369,963,965,{"$f":"MAX(0,E6-D6)","v":2}]
[null,"Avril",4,965,965,{"$f":"MAX(0,E7-D7)","v":0}]
[null,"Mai",187,{"$f":"E7","v":965},965,0]
[null,"Juin",10641,965,989,24]
[null,"Juillet",107,989,989,0,null,null,null,null," "]
[null,"Août",0,989,989,0]
[null,"Septembre",0,989,989,0]
[null,"Octobre",3559,989,998,9]
[null,"Novembre",null,998,null,0]
[null,"Décembre",null,0,null,0]
[]
[null,"Total",{"$f":"SUM(C4:C15)","v":24472},{"$f":"D4","v":946},{"$f":"E15","v":0},{"$f":"SUM(F4:F15)","v":52}]

{"sheet":"2021","index":2,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"  "]
[null,null,null,null,null,null,{"$f":"MID(CELL(\"nomfichier\",B1),FIND(\"]\",CELL(\"nomfichier\",B1))+1,LEN(CELL(\"nomfichier\",B1))-FIND(\"]\",CELL(\"nomfichier\",B1)))","v":"2021"}]
[null,"Mois","Npai Flashé","N° de Carton de Début","N° de Carton de Fin","Total"]
[null,"Janvier",9347,879,897,{"$f":"E4-D4","v":18}]
[null,"Février",506,{"$f":"E4","v":897},898,{"$f":"E5-D5","v":1}]
[null,"Mars",354,898,899,{"$f":"E6-D6","v":1}]
[null,"Avril",398,899,900,{"$f":"E7-D7","v":1}]
[null,"Mai",901,900,902,{"$f":"E8-D8","v":2}]
[null,"Juin",0,902,902,0]
[null,"Juillet",10155,902,921,19]
[null,"Août",31,921,921,0]
[null,"Septembre",0,921,921,0]
[null,"Octobre",3,921,921,0]
[null,"Novembre",0,921,921,0]
[null,"Décembre",11327,921,946,25]
[]
[null,"Total",{"$f":"SUM(C4:C15)","v":33022},{"$f":"D4","v":879},{"$f":"E15","v":946},{"$f":"SUM(F4:F15)","v":67}]

{"sheet":"2020","index":3,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"  "]
[null,null,null,null,null,null,{"$f":"MID(CELL(\"nomfichier\",B1),FIND(\"]\",CELL(\"nomfichier\",B1))+1,LEN(CELL(\"nomfichier\",B1))-FIND(\"]\",CELL(\"nomfichier\",B1)))","v":"2020"}]
[null,"Mois","Npai Flashé","N° de Carton de Début","N° de Carton de Fin","Total"]
[null,"Janvier",8544,739,760,{"$f":"E4-D4","v":21}]
[null,"Février",10240,{"$f":"E4","v":760},786,{"$f":"E5-D5","v":26}]
[null,"Mars",2002,786,792,{"$f":"E6-D6","v":6}]
[null,"Avril",0,792,792,{"$f":"E7-D7","v":0}]
[null,"Mai",682,792,794,{"$f":"E8-D8","v":2}]
[null,"Juin",16069,794,837,43]
[null,"Juillet",0,837,837,0]
[null,"Août",2,837,837,0]
[null,"Septembre",0,837,837,0]
[null,"Octobre",1819,837,842,5]
[null,"Novembre",10264,842,865,23]
[null,"Décembre",6463,865,879,14]
[]
[null,"Total",{"$f":"SUM(C4:C15)","v":56085},{"$f":"D4","v":739},{"$f":"E15","v":879},{"$f":"SUM(F4:F15)","v":140}]

{"sheet":"2019","index":4,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"  "]
[null,null,null,null,null,null,{"$f":"MID(CELL(\"nomfichier\",B1),FIND(\"]\",CELL(\"nomfichier\",B1))+1,LEN(CELL(\"nomfichier\",B1))-FIND(\"]\",CELL(\"nomfichier\",B1)))","v":"2019"}]
[null,"Mois","Npai Flashé","N° de Carton de Début","N° de Carton de Fin","Total"]
[null,"Janvier",5188,664,675,{"$f":"E4-D4","v":11}]
[null,"Février",6279,{"$f":"E4","v":675},688,{"$f":"E5-D5","v":13}]
[null,"Mars",70,688,689,{"$f":"E6-D6","v":1}]
[null,"Avril",2670,689,693,{"$f":"E7-D7","v":4}]
[null,"Mai",5245,693,701,{"$f":"E8-D8","v":8}]
[null,"Juin",14104,701,722,21]
[null,"Juillet",3546,722,727,5]
[null,"Août",7371,727,738,11]
[null,"Septembre",107,738,738,0]
[null,"Octobre",288,738,738,0]
[null,"Novembre",530,738,739,1]
[null,"Décembre",0,739,739,0]
[]
[null,"Total",{"$f":"SUM(C4:C15)","v":45398},{"$f":"D4","v":664},{"$f":"E15","v":739},{"$f":"SUM(F4:F15)","v":75}]

{"sheet":"2018","index":5,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"  "]
[null,null,null,null,null,null,{"$f":"MID(CELL(\"nomfichier\",B1),FIND(\"]\",CELL(\"nomfichier\",B1))+1,LEN(CELL(\"nomfichier\",B1))-FIND(\"]\",CELL(\"nomfichier\",B1)))","v":"2018"}]
[null,"Mois","Npai Flashé","N° de Carton de Début","N° de Carton de Fin","Total"]
[null,"Janvier",0,579,579,{"$f":"E4-D4","v":0}]
[null,"Février",11534,{"$f":"E4","v":579},608,{"$f":"E5-D5","v":29}]
[null,"Mars",622,608,610,{"$f":"E6-D6","v":2}]
[null,"Avril",105,610,610,{"$f":"E7-D7","v":0}]
[null,"Mai",8564,610,625,{"$f":"E8-D8","v":15}]
[null,"Juin",7992,625,641,16]
[null,"Juillet",9673,641,658,17,null,null,null,null,4]
[null,"Août",1790,658,660,2]
[null,"Septembre",2265,660,661,1]
[null,"Octobre",663,661,663,2]
[null,"Novembre",0,663,663,0]
[null,"Décembre",1529,663,664,1]
[]
[null,"Total",{"$f":"SUM(C4:C15)","v":44737},{"$f":"D4","v":579},{"$f":"E15","v":664},{"$f":"SUM(F4:F15)","v":85}]

{"sheet":"2017","index":6,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"  "]
[null,null,null,null,null,null,{"$f":"MID(CELL(\"nomfichier\",B1),FIND(\"]\",CELL(\"nomfichier\",B1))+1,LEN(CELL(\"nomfichier\",B1))-FIND(\"]\",CELL(\"nomfichier\",B1)))","v":"2017"}]
[null,"Mois","Npai Flashé","N° de Carton de Début","N° de Carton de Fin","Total"]
[null,"Janvier",128,525,525,{"$f":"E4-D4","v":0}]
[null,"Février",7150,{"$f":"E4","v":525},543,{"$f":"E5-D5","v":18}]
[null,"Mars",2151,543,547,{"$f":"E6-D6","v":4}]
[null,"Avril",543,547,548,{"$f":"E7-D7","v":1}]
[null,"Mai",7516,548,564,{"$f":"E8-D8","v":16}]
[null,"Juin",5524,564,575,11]
[null,"Juillet",709,575,575,0]
[null,"Août",685,575,577,2]
[null,"Septembre",14,577,577,0]
[null,"Octobre",246,577,577,0]
[null,"Novembre",198,577,578,1]
[null,"Décembre",701,578,579,1]
[]
[null,"Total",{"$f":"SUM(C4:C15)","v":25565},{"$f":"D4","v":525},{"$f":"E15","v":579},{"$f":"SUM(F4:F15)","v":54}]

{"sheet":"2016","index":7,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"  "]
[null,null,null,null,null,null,{"$f":"MID(CELL(\"nomfichier\",B1),FIND(\"]\",CELL(\"nomfichier\",B1))+1,LEN(CELL(\"nomfichier\",B1))-FIND(\"]\",CELL(\"nomfichier\",B1)))","v":"2016"}]
[null,"Mois","Npai Flashé","N° de Carton de Début","N° de Carton de Fin","Total"]
[null,"Janvier",8609,461,483,{"$f":"E4-D4","v":22}]
[null,"Février",1299,{"$f":"E4","v":483},486,{"$f":"E5-D5","v":3}]
[null,"Mars",338,486,487,{"$f":"E6-D6","v":1}]
[null,"Avril",404,487,488,{"$f":"E7-D7","v":1}]
[null,"Mai",11716,488,513,{"$f":"E8-D8","v":25}]
[null,"Juin",2943,513,520,7]
[null,"Juillet",318,520,521,1]
[null,"Août",80,521,521,0]
[null,"Septembre",0,521,521,0]
[null,"Octobre",148,521,521,0]
[null,"Novembre",29,521,521,0]
[null,"Décembre",1604,521,525,4]
[]
[null,"Total",{"$f":"SUM(C4:C15)","v":27488},{"$f":"D4","v":461},{"$f":"E15","v":525},{"$f":"SUM(F4:F15)","v":64}]

{"sheet":"2015","index":8,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"  "]
[null,null,null,null,null,null,{"$f":"MID(CELL(\"nomfichier\",B1),FIND(\"]\",CELL(\"nomfichier\",B1))+1,LEN(CELL(\"nomfichier\",B1))-FIND(\"]\",CELL(\"nomfichier\",B1)))","v":"2015"}]
[null,"Mois","Npai Flashé","N° de Carton de Début","N° de Carton de Fin","Total"]
[null,"Janvier",4614,422,437,{"$f":"E4-D4","v":15}]
[null,"Février",736,{"$f":"E4","v":437},439,{"$f":"E5-D5","v":2}]
[null,"Mars",98,439,439,{"$f":"E6-D6","v":0}]
[null,"Avril",0,439,439,{"$f":"E7-D7","v":0}]
[null,"Mai",3539,439,445,{"$f":"E8-D8","v":6}]
[null,"Juin",6362,445,457,12]
[null,"Juillet",100,457,457,0]
[null,"Août",747,457,458,1]
[null,"Septembre",0,458,458,0]
[null,"Octobre",460,458,459,1]
[null,"Novembre",19,459,459,0]
[null,"Décembre",555,459,460,1]
[]
[null,"Total",{"$f":"SUM(C4:C15)","v":17230},{"$f":"D4","v":422},{"$f":"E15","v":460},{"$f":"SUM(F4:F15)","v":38}]

{"sheet":"2014","index":9,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"  "]
[null,null,null,null,null,null,{"$f":"MID(CELL(\"nomfichier\",B1),FIND(\"]\",CELL(\"nomfichier\",B1))+1,LEN(CELL(\"nomfichier\",B1))-FIND(\"]\",CELL(\"nomfichier\",B1)))","v":"2014"}]
[null,"Mois","Npai Flashé","N° de Carton de Début","N° de Carton de Fin","Total"]
[null,"Janvier",0,345,345,{"$f":"E4-D4","v":0}]
[null,"Février",3622,{"$f":"E4","v":345},350,{"$f":"E5-D5","v":5}]
[null,"Mars",3658,350,357,{"$f":"E6-D6","v":7}]
[null,"Avril",256,357,357,{"$f":"E7-D7","v":0}]
[null,"Mai",5,357,357,{"$f":"E8-D8","v":0}]
[null,"Juin",4053,357,366,9]
[null,"Juillet",12454,366,393,27]
[null,"Août",118,393,393,0]
[null,"Septembre",131,393,393,0]
[null,"Octobre",2466,393,396,3]
[null,"Novembre",6114,396,401,5]
[null,"Décembre",6225,401,422,21]
[]
[null,"Total",{"$f":"SUM(C4:C15)","v":39102},{"$f":"D4","v":345},{"$f":"E15","v":422},{"$f":"SUM(F4:F15)","v":77}]

{"sheet":"2013","index":10,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"  "]
[null,null,null,null,null,null,{"$f":"MID(CELL(\"nomfichier\",B1),FIND(\"]\",CELL(\"nomfichier\",B1))+1,LEN(CELL(\"nomfichier\",B1))-FIND(\"]\",CELL(\"nomfichier\",B1)))","v":"2013"}]
[null,"Mois","Npai Flashé","N° de Carton de Début","N° de Carton de Fin","Total"]
[null,"Janvier",1616,265,267,{"$f":"E4-D4","v":2}]
[null,"Février",3511,{"$f":"E4","v":267},273,{"$f":"E5-D5","v":6}]
[null,"Mars",1706,273,276,{"$f":"E6-D6","v":3}]
[null,"Avril",163,276,276,{"$f":"E7-D7","v":0}]
[null,"Mai",2,276,276,{"$f":"E8-D8","v":0}]
[null,"Juin",1049,276,279,3]
[null,"Juillet",14310,279,309,30]
[null,"Août",68,309,309,0]
[null,"Septembre",204,309,310,1]
[null,"Octobre",14932,310,343,33]
[null,"Novembre",432,343,344,1]
[null,"Décembre",281,344,344,0]
[]
[null,"Total",{"$f":"SUM(C4:C15)","v":38274},{"$f":"D4","v":265},{"$f":"E15","v":344},{"$f":"SUM(F4:F15)","v":79}]

{"sheet":"2012","index":11,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"  "]
[null,null,null,null,null,null,{"$f":"MID(CELL(\"nomfichier\",B1),FIND(\"]\",CELL(\"nomfichier\",B1))+1,LEN(CELL(\"nomfichier\",B1))-FIND(\"]\",CELL(\"nomfichier\",B1)))","v":"2012"}]
[null,"Mois","Npai Flashé","N° de Carton de Début","N° de Carton de Fin","Total"]
[null,"Janvier",2556,213,217,{"$f":"E4-D4","v":4}]
[null,"Février",3049,{"$f":"E4","v":217},223,{"$f":"E5-D5","v":6}]
[null,"Mars",138,223,223,{"$f":"E6-D6","v":0}]
[null,"Avril",24,223,223,{"$f":"E7-D7","v":0}]
[null,"Mai",0,223,223,{"$f":"E8-D8","v":0}]
[null,"Juin",0,223,223,0]
[null,"Juillet",17974,223,258,35]
[null,"Août",38,258,258,0]
[null,"Septembre",53,258,258,0]
[null,"Octobre",2662,258,263,5]
[null,"Novembre",466,263,264,1]
[null,"Décembre",68,264,265,1]
[]
[null,"Total",{"$f":"SUM(C4:C15)","v":27028},{"$f":"D4","v":213},{"$f":"E15","v":265},{"$f":"SUM(F4:F15)","v":52}]

{"sheet":"2011","index":12,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"  "]
[null,null,null,null,null,null,{"$f":"MID(CELL(\"nomfichier\",B1),FIND(\"]\",CELL(\"nomfichier\",B1))+1,LEN(CELL(\"nomfichier\",B1))-FIND(\"]\",CELL(\"nomfichier\",B1)))","v":"2011"}]
[null,"Mois","Npai Flashé","N° de Carton de Début","N° de Carton de Fin","Total"]
[null,"Janvier",56,140,140,{"$f":"E4-D4","v":0}]
[null,"Février",6406,{"$f":"E4","v":140},151,{"$f":"E5-D5","v":11}]
[null,"Mars",8819,151,166,{"$f":"E6-D6","v":15}]
[null,"Avril",4118,166,173,{"$f":"E7-D7","v":7}]
[null,"Mai",2807,173,179,{"$f":"E8-D8","v":6}]
[null,"Juin",10674,179,199,20]
[null,"Juillet",3102,199,205,6]
[null,"Août",131,205,206,1]
[null,"Septembre",46,206,206,0]
[null,"Octobre",0,206,206,0]
[null,"Novembre",2933,206,212,6]
[null,"Décembre",112,212,212,0]
[]
[null,"Total",{"$f":"SUM(C4:C15)","v":39204},{"$f":"D4","v":140},{"$f":"E15","v":212},{"$f":"SUM(F4:F15)","v":72}]

{"sheet":"2010","index":13,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"  "]
[null,null,null,null,null,null,{"$f":"MID(CELL(\"nomfichier\",B1),FIND(\"]\",CELL(\"nomfichier\",B1))+1,LEN(CELL(\"nomfichier\",B1))-FIND(\"]\",CELL(\"nomfichier\",B1)))","v":"2010"}]
[null,"Mois","Npai Flashé","N° de Carton de Début","N° de Carton de Fin","Total"]
[null,"Janvier",9499,54,70,{"$f":"E4-D4","v":16}]
[null,"Février",4085,{"$f":"E4","v":70},76,{"$f":"E5-D5","v":6}]
[null,"Mars",5368,76,82,{"$f":"E6-D6","v":6}]
[null,"Avril",1676,82,84,{"$f":"E7-D7","v":2}]
[null,"Mai",29716,84,88,{"$f":"E8-D8","v":4}]
[null,"Juin",7351,88,101,13]
[null,"Juillet",5724,101,112,11]
[null,"Août",801,112,114,2]
[null,"Septembre",102,114,114,0]
[null,"Octobre",2452,114,118,4]
[null,"Novembre",10443,118,137,19]
[null,"Décembre",1342,137,140,3]
[]
[null,"Total",{"$f":"SUM(C4:C15)","v":78559},{"$f":"D4","v":54},{"$f":"E15","v":140},{"$f":"SUM(F4:F15)","v":86}]

{"sheet":"2009","index":14,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"  "]
[null,null,null,null,null,null,{"$f":"MID(CELL(\"nomfichier\",B1),FIND(\"]\",CELL(\"nomfichier\",B1))+1,LEN(CELL(\"nomfichier\",B1))-FIND(\"]\",CELL(\"nomfichier\",B1)))","v":"2009"}]
[null,"Mois","Npai Flashé","N° de Carton de Début","N° de Carton de Fin","Total"]
[null,"Janvier",718,0,0,{"$f":"E4-D4","v":0}]
[null,"Février",3373,{"$f":"E4","v":0},0,{"$f":"E5-D5","v":0}]
[null,"Mars",674,0,0,{"$f":"E6-D6","v":0}]
[null,"Avril",2266,0,4,{"$f":"E7-D7","v":4}]
[null,"Mai",5147,4,11,{"$f":"E8-D8","v":7}]
[null,"Juin",17127,11,40,29]
[null,"Juillet",1680,40,44,4]
[null,"Août",216,44,44,0]
[null,"Septembre",42,44,44,0]
[null,"Octobre",0,44,44,0]
[null,"Novembre",658,44,46,2]
[null,"Décembre",3571,46,53,7]
[]
[null,"Total",{"$f":"SUM(C4:C15)","v":35472},{"$f":"D4","v":0},{"$f":"E15","v":53},{"$f":"SUM(F4:F15)","v":53}]

{"sheet":"source","index":15,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[{"$f":"YEAR(TODAY())","v":2022}]
[2008]
[2009,{"$f":"'2009'!$C$17","v":35472}]
[2010,{"$f":"'2010'!$C$17","v":78559}]
[2011,{"$f":"'2011'!$C$17","v":39204},null,"Mois","NPAI FLASHER","N°de Carton de Début","N°de Carton de Fin","Total","Rang"]
[2012,{"$f":"'2012'!$C$17","v":27028},null,"Janvier",{"$f":"VLOOKUP(D6,INDIRECT(\"'\"&'RÉCAPITULATIF DU REPORTING'!$E$3&\"'!B4:C16\"),2,FALSE)","v":8544},{"$f":"VLOOKUP(D6,INDIRECT(\"'\"&'RÉCAPITULATIF DU REPORTING'!$E$3&\"'!B4:D16\"),3,FALSE)","v":739},{"$f":"VLOOKUP(D6,INDIRECT(\"'\"&'RÉCAPITULATIF DU REPORTING'!$E$3&\"'!B4:F16\"),4,FALSE)","v":760},{"$f":"G6-F6","v":21},{"$f":"IF(OR(E6=MAX($E$6:$E$17),E6=MIN($E$6:$E$17)),E6,NA())","v":{"$error":"#N/A"}}]
[2013,{"$f":"'2013'!$C$17","v":38274},null,"Février",{"$f":"VLOOKUP(D7,INDIRECT(\"'\"&'RÉCAPITULATIF DU REPORTING'!$E$3&\"'!B4:C16\"),2,FALSE)","v":10240},{"$f":"VLOOKUP(D7,INDIRECT(\"'\"&'RÉCAPITULATIF DU REPORTING'!$E$3&\"'!B4:D16\"),3,FALSE)","v":760},{"$f":"VLOOKUP(D7,INDIRECT(\"'\"&'RÉCAPITULATIF DU REPORTING'!$E$3&\"'!B4:F16\"),4,FALSE)","v":786},{"$f":"G7-F7","v":26},{"$f":"IF(OR(E7=MAX($E$6:$E$17),E7=MIN($E$6:$E$17)),E7,NA())","v":{"$error":"#N/A"}}]
[2014,{"$f":"'2014'!$C$17","v":39102},null,"Mars",{"$f":"VLOOKUP(D8,INDIRECT(\"'\"&'RÉCAPITULATIF DU REPORTING'!$E$3&\"'!B4:C16\"),2,FALSE)","v":2002},{"$f":"VLOOKUP(D8,INDIRECT(\"'\"&'RÉCAPITULATIF DU REPORTING'!$E$3&\"'!B4:D16\"),3,FALSE)","v":786},{"$f":"VLOOKUP(D8,INDIRECT(\"'\"&'RÉCAPITULATIF DU REPORTING'!$E$3&\"'!B4:F16\"),4,FALSE)","v":792},{"$f":"G8-F8","v":6},{"$error":"#N/A"}]
[2015,{"$f":"'2015'!$C$17","v":17230},null,"Avril",{"$f":"VLOOKUP(D9,INDIRECT(\"'\"&'RÉCAPITULATIF DU REPORTING'!$E$3&\"'!B4:C16\"),2,FALSE)","v":0},{"$f":"VLOOKUP(D9,INDIRECT(\"'\"&'RÉCAPITULATIF DU REPORTING'!$E$3&\"'!B4:D16\"),3,FALSE)","v":792},{"$f":"VLOOKUP(D9,INDIRECT(\"'\"&'RÉCAPITULATIF DU REPORTING'!$E$3&\"'!B4:F16\"),4,FALSE)","v":792},{"$f":"G9-F9","v":0},0]
[2016,{"$f":"'2016'!$C$17","v":27488},null,"Mai",{"$f":"VLOOKUP(D10,INDIRECT(\"'\"&'RÉCAPITULATIF DU REPORTING'!$E$3&\"'!B4:C16\"),2,FALSE)","v":682},{"$f":"VLOOKUP(D10,INDIRECT(\"'\"&'RÉCAPITULATIF DU REPORTING'!$E$3&\"'!B4:D16\"),3,FALSE)","v":792},{"$f":"VLOOKUP(D10,INDIRECT(\"'\"&'RÉCAPITULATIF DU REPORTING'!$E$3&\"'!B4:F16\"),4,FALSE)","v":794},2,{"$error":"#N/A"}]
[2017,{"$f":"'2017'!$C$17","v":25565},null,"Juin",{"$f":"VLOOKUP(D11,INDIRECT(\"'\"&'RÉCAPITULATIF DU REPORTING'!$E$3&\"'!B4:C16\"),2,FALSE)","v":16069},{"$f":"VLOOKUP(D11,INDIRECT(\"'\"&'RÉCAPITULATIF DU REPORTING'!$E$3&\"'!B4:D16\"),3,FALSE)","v":794},{"$f":"VLOOKUP(D11,INDIRECT(\"'\"&'RÉCAPITULATIF DU REPORTING'!$E$3&\"'!B4:F16\"),4,FALSE)","v":837},43,16069]
[2018,{"$f":"'2018'!$C$17","v":44737},null,"Juillet",{"$f":"VLOOKUP(D12,INDIRECT(\"'\"&'RÉCAPITULATIF DU REPORTING'!$E$3&\"'!B4:C16\"),2,FALSE)","v":0},{"$f":"VLOOKUP(D12,INDIRECT(\"'\"&'RÉCAPITULATIF DU REPORTING'!$E$3&\"'!B4:D16\"),3,FALSE)","v":837},{"$f":"VLOOKUP(D12,INDIRECT(\"'\"&'RÉCAPITULATIF DU REPORTING'!$E$3&\"'!B4:F16\"),4,FALSE)","v":837},0,0]
[2019,{"$f":"'2019'!$C$17","v":45398},null,"Août",{"$f":"VLOOKUP(D13,INDIRECT(\"'\"&'RÉCAPITULATIF DU REPORTING'!$E$3&\"'!B4:C16\"),2,FALSE)","v":2},{"$f":"VLOOKUP(D13,INDIRECT(\"'\"&'RÉCAPITULATIF DU REPORTING'!$E$3&\"'!B4:D16\"),3,FALSE)","v":837},{"$f":"VLOOKUP(D13,INDIRECT(\"'\"&'RÉCAPITULATIF DU REPORTING'!$E$3&\"'!B4:F16\"),4,FALSE)","v":837},0,{"$error":"#N/A"}]
[2020,{"$f":"'2020'!$C$17","v":56085},null,"Septembre",{"$f":"VLOOKUP(D14,INDIRECT(\"'\"&'RÉCAPITULATIF DU REPORTING'!$E$3&\"'!B4:C16\"),2,FALSE)","v":0},{"$f":"VLOOKUP(D14,INDIRECT(\"'\"&'RÉCAPITULATIF DU REPORTING'!$E$3&\"'!B4:D16\"),3,FALSE)","v":837},{"$f":"VLOOKUP(D14,INDIRECT(\"'\"&'RÉCAPITULATIF DU REPORTING'!$E$3&\"'!B4:F16\"),4,FALSE)","v":837},0,0]
[2021,{"$f":"'2021'!$C$17","v":33022},null,"Octobre",{"$f":"VLOOKUP(D15,INDIRECT(\"'\"&'RÉCAPITULATIF DU REPORTING'!$E$3&\"'!B4:C16\"),2,FALSE)","v":1819},{"$f":"VLOOKUP(D15,INDIRECT(\"'\"&'RÉCAPITULATIF DU REPORTING'!$E$3&\"'!B4:D16\"),3,FALSE)","v":837},{"$f":"VLOOKUP(D15,INDIRECT(\"'\"&'RÉCAPITULATIF DU REPORTING'!$E$3&\"'!B4:F16\"),4,FALSE)","v":842},5,{"$error":"#N/A"}]
[2022,{"$f":"'2022'!$C$17","v":24472},null,"Novembre",{"$f":"VLOOKUP(D16,INDIRECT(\"'\"&'RÉCAPITULATIF DU REPORTING'!$E$3&\"'!B4:C16\"),2,FALSE)","v":10264},{"$f":"VLOOKUP(D16,INDIRECT(\"'\"&'RÉCAPITULATIF DU REPORTING'!$E$3&\"'!B4:D16\"),3,FALSE)","v":842},{"$f":"VLOOKUP(D16,INDIRECT(\"'\"&'RÉCAPITULATIF DU REPORTING'!$E$3&\"'!B4:F16\"),4,FALSE)","v":865},23,{"$error":"#N/A"}]
[2023,null,null,"Décembre",{"$f":"VLOOKUP(D17,INDIRECT(\"'\"&'RÉCAPITULATIF DU REPORTING'!$E$3&\"'!B4:C16\"),2,FALSE)","v":6463},{"$f":"VLOOKUP(D17,INDIRECT(\"'\"&'RÉCAPITULATIF DU REPORTING'!$E$3&\"'!B4:D16\"),3,FALSE)","v":865},{"$f":"VLOOKUP(D17,INDIRECT(\"'\"&'RÉCAPITULATIF DU REPORTING'!$E$3&\"'!B4:F16\"),4,FALSE)","v":879},14,{"$error":"#N/A"}]
[2024]
[null,null,null,"Total",{"$f":"SUM(E6:E17)","v":56085},{"$f":"SUM(F6:F17)","v":9718},null,{"$f":"SUM(H6:H17)","v":140}]
["total",{"$f":"SUM(B3:B18)","v":531636}]
["moyenne",{"$f":"B20/14","v":37974}]
[]
[]
[{"$f":"YEAR(TODAY())","v":2022}]

{"sheet":"DonnéesDeGraphique","index":16,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Cette feuille doit rester masquée."]
["Étiquettes de graphique"]
[{"$f":"RéceptionEmployeeAnnée&\": \"&TEXT(FondsUtilisés,\"# ##0,00 €\")&\" (\"&TEXT(FondsUtilisés/SUM(FondsUtilisés:FondsRestants),\"0%\")&\")\"","v":{"$error":"#NAME?"}}]
[{"$f":"TotalAnnée&\": \"&TEXT(FondsRestants,\"# ##0,00 €\")&\" (\"&TEXT(FondsRestants/SUM(FondsUtilisés:FondsRestants),\"0%\")&\")\"","v":{"$error":"#NAME?"}}]