{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["personnel","Récapitulatif","n° Versement"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":5,"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":"personnel","index":0,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Bourbonnais"]
["Dubourg"]
["Grillet"]
["Lacroix"]
["Miralles"]
["Savigny"]

{"sheet":"Récapitulatif","index":1,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Ordre","n° versement","Travaillé dessus","date de réception","Jours"]
[{"$f":"IF(B2<>\"\",ROW()-1,\"\")","v":1},{"$f":"IFERROR(INDEX('n° Versement'!$D:$D,_xlfn.AGGREGATE(15,6,ROW($3:$370)/(('n° Versement'!$D$3:$D$7<>\"\")*(ISNA(MATCH('n° Versement'!$D$3:$D$7,Récapitulatif!$B$1:B1,0)))),1),),\"\")","v":"DE/2024/ZO/23"},{"$f":"SUBSTITUTE(_xlfn.CONCAT(IF('n° Versement'!$D$3:$D$7=B2,'n° Versement'!$C$3:$C$7&\", \",\"\")),\",\",\"\")","v":"Dubourg Miralles "},{"$f":"IFERROR(INDEX('n° Versement'!$E:$E,_xlfn.AGGREGATE(15,6,ROW($3:$370)/(('n° Versement'!$D$3:$D$7<>\"\")*(ISNA(MATCH('n° Versement'!$D$3:$D$7,Récapitulatif!$B$1:B1,0)))),1),),\"\")","v":"2024-07-27"},{"$f":"IF(B2<>\"\",SUMPRODUCT(('n° Versement'!$F$3:$G$7)*('n° Versement'!$D$3:$D$7=Récapitulatif!B2))/2,\"\")","v":9.5},null,null,1,"DE/2024/ZO/23","Dubourg, Miralles","2024-07-26",9.5]
[{"$f":"IF(B3<>\"\",ROW()-1,\"\")","v":2},{"$f":"IFERROR(INDEX('n° Versement'!$D:$D,_xlfn.AGGREGATE(15,6,ROW($3:$370)/(('n° Versement'!$D$3:$D$7<>\"\")*(ISNA(MATCH('n° Versement'!$D$3:$D$7,Récapitulatif!$B$1:B2,0)))),1),),\"\")","v":"DE/2024/ZO/18"},{"$f":"SUBSTITUTE(_xlfn.CONCAT(IF('n° Versement'!$D$3:$D$7=B3,'n° Versement'!$C$3:$C$7&\", \",\"\")),\",\",\"\")","v":"Savigny "},{"$f":"IFERROR(INDEX('n° Versement'!$E:$E,_xlfn.AGGREGATE(15,6,ROW($3:$370)/(('n° Versement'!$D$3:$D$7<>\"\")*(ISNA(MATCH('n° Versement'!$D$3:$D$7,Récapitulatif!$B$1:B2,0)))),1),),\"\")","v":"2024-05-22"},{"$f":"IF(B3<>\"\",SUMPRODUCT(('n° Versement'!$F$3:$G$7)*('n° Versement'!$D$3:$D$7=Récapitulatif!B3))/2,\"\")","v":7},null,null,2,"DE/2024/ZO/18","Savigny","2024-05-22",7]
[3,{"$f":"IFERROR(INDEX('n° Versement'!$D:$D,_xlfn.AGGREGATE(15,6,ROW($3:$370)/(('n° Versement'!$D$3:$D$7<>\"\")*(ISNA(MATCH('n° Versement'!$D$3:$D$7,Récapitulatif!$B$1:B3,0)))),1),),\"\")","v":"699/V/04E"},{"$f":"SUBSTITUTE(_xlfn.CONCAT(IF('n° Versement'!$D$3:$D$7=B4,'n° Versement'!$C$3:$C$7&\", \",\"\")),\",\",\"\")","v":"Bourbonnais "},{"$f":"IFERROR(INDEX('n° Versement'!$E:$E,_xlfn.AGGREGATE(15,6,ROW($3:$370)/(('n° Versement'!$D$3:$D$7<>\"\")*(ISNA(MATCH('n° Versement'!$D$3:$D$7,Récapitulatif!$B$1:B3,0)))),1),),\"\")","v":"2022-02-03"},{"$f":"IF(B4<>\"\",SUMPRODUCT(('n° Versement'!$F$3:$G$7)*('n° Versement'!$D$3:$D$7=Récapitulatif!B4))/2,\"\")","v":3},null,null,3,"699/V/04E","Bourbonnais","2022-02-03",3]
[4,{"$f":"IFERROR(INDEX('n° Versement'!$D:$D,_xlfn.AGGREGATE(15,6,ROW($3:$370)/(('n° Versement'!$D$3:$D$7<>\"\")*(ISNA(MATCH('n° Versement'!$D$3:$D$7,Récapitulatif!$B$1:B4,0)))),1),),\"\")","v":"DE/2012/ZO/02"},{"$f":"SUBSTITUTE(_xlfn.CONCAT(IF('n° Versement'!$D$3:$D$7=B5,'n° Versement'!$C$3:$C$7&\", \",\"\")),\",\",\"\")","v":"Dubourg "},{"$f":"IFERROR(INDEX('n° Versement'!$E:$E,_xlfn.AGGREGATE(15,6,ROW($3:$370)/(('n° Versement'!$D$3:$D$7<>\"\")*(ISNA(MATCH('n° Versement'!$D$3:$D$7,Récapitulatif!$B$1:B4,0)))),1),),\"\")","v":"2012-09-20"},{"$f":"IF(B5<>\"\",SUMPRODUCT(('n° Versement'!$F$3:$G$7)*('n° Versement'!$D$3:$D$7=Récapitulatif!B5))/2,\"\")","v":4.5}]
["",{"$f":"IFERROR(INDEX('n° Versement'!$D:$D,_xlfn.AGGREGATE(15,6,ROW($3:$370)/(('n° Versement'!$D$3:$D$7<>\"\")*(ISNA(MATCH('n° Versement'!$D$3:$D$7,Récapitulatif!$B$1:B5,0)))),1),),\"\")","v":""},{"$f":"SUBSTITUTE(_xlfn.CONCAT(IF('n° Versement'!$D$3:$D$7=B6,'n° Versement'!$C$3:$C$7&\", \",\"\")),\",\",\"\")","v":""},{"$f":"IFERROR(INDEX('n° Versement'!$E:$E,_xlfn.AGGREGATE(15,6,ROW($3:$370)/(('n° Versement'!$D$3:$D$7<>\"\")*(ISNA(MATCH('n° Versement'!$D$3:$D$7,Récapitulatif!$B$1:B5,0)))),1),),\"\")","v":""},{"$f":"IF(B6<>\"\",SUMPRODUCT(('n° Versement'!$F$3:$G$7)*('n° Versement'!$D$3:$D$7=Récapitulatif!B6))/2,\"\")","v":""}]
["",{"$f":"IFERROR(INDEX('n° Versement'!$D:$D,_xlfn.AGGREGATE(15,6,ROW($3:$370)/(('n° Versement'!$D$3:$D$7<>\"\")*(ISNA(MATCH('n° Versement'!$D$3:$D$7,Récapitulatif!$B$1:B6,0)))),1),),\"\")","v":""},{"$f":"SUBSTITUTE(_xlfn.CONCAT(IF('n° Versement'!$D$3:$D$7=B7,'n° Versement'!$C$3:$C$7&\", \",\"\")),\",\",\"\")","v":""},{"$f":"IFERROR(INDEX('n° Versement'!$E:$E,_xlfn.AGGREGATE(15,6,ROW($3:$370)/(('n° Versement'!$D$3:$D$7<>\"\")*(ISNA(MATCH('n° Versement'!$D$3:$D$7,Récapitulatif!$B$1:B6,0)))),1),),\"\")","v":""},{"$f":"IF(B7<>\"\",SUMPRODUCT(('n° Versement'!$F$3:$G$7)*('n° Versement'!$D$3:$D$7=Récapitulatif!B7))/2,\"\")","v":""}]
["",{"$f":"IFERROR(INDEX('n° Versement'!$D:$D,_xlfn.AGGREGATE(15,6,ROW($3:$370)/(('n° Versement'!$D$3:$D$7<>\"\")*(ISNA(MATCH('n° Versement'!$D$3:$D$7,Récapitulatif!$B$1:B7,0)))),1),),\"\")","v":""},{"$f":"SUBSTITUTE(_xlfn.CONCAT(IF('n° Versement'!$D$3:$D$7=B8,'n° Versement'!$C$3:$C$7&\", \",\"\")),\",\",\"\")","v":""},{"$f":"IFERROR(INDEX('n° Versement'!$E:$E,_xlfn.AGGREGATE(15,6,ROW($3:$370)/(('n° Versement'!$D$3:$D$7<>\"\")*(ISNA(MATCH('n° Versement'!$D$3:$D$7,Récapitulatif!$B$1:B7,0)))),1),),\"\")","v":""},{"$f":"IF(B8<>\"\",SUMPRODUCT(('n° Versement'!$F$3:$G$7)*('n° Versement'!$D$3:$D$7=Récapitulatif!B8))/2,\"\")","v":""},null,null,"Ordre","N° Versement","Participants","Date de réception","Jours"]
["",{"$f":"IFERROR(INDEX('n° Versement'!$D:$D,_xlfn.AGGREGATE(15,6,ROW($3:$370)/(('n° Versement'!$D$3:$D$7<>\"\")*(ISNA(MATCH('n° Versement'!$D$3:$D$7,Récapitulatif!$B$1:B8,0)))),1),),\"\")","v":""},{"$f":"SUBSTITUTE(_xlfn.CONCAT(IF('n° Versement'!$D$3:$D$7=B9,'n° Versement'!$C$3:$C$7&\", \",\"\")),\",\",\"\")","v":""},{"$f":"IFERROR(INDEX('n° Versement'!$E:$E,_xlfn.AGGREGATE(15,6,ROW($3:$370)/(('n° Versement'!$D$3:$D$7<>\"\")*(ISNA(MATCH('n° Versement'!$D$3:$D$7,Récapitulatif!$B$1:B8,0)))),1),),\"\")","v":""},{"$f":"IF(B9<>\"\",SUMPRODUCT(('n° Versement'!$F$3:$G$7)*('n° Versement'!$D$3:$D$7=Récapitulatif!B9))/2,\"\")","v":""},null,null,1,"DE/2024/ZO/23","Dubourg, Miralles","2024-07-27",9.5]
["",{"$f":"IFERROR(INDEX('n° Versement'!$D:$D,_xlfn.AGGREGATE(15,6,ROW($3:$370)/(('n° Versement'!$D$3:$D$7<>\"\")*(ISNA(MATCH('n° Versement'!$D$3:$D$7,Récapitulatif!$B$1:B9,0)))),1),),\"\")","v":""},{"$f":"SUBSTITUTE(_xlfn.CONCAT(IF('n° Versement'!$D$3:$D$7=B10,'n° Versement'!$C$3:$C$7&\", \",\"\")),\",\",\"\")","v":""},{"$f":"IFERROR(INDEX('n° Versement'!$E:$E,_xlfn.AGGREGATE(15,6,ROW($3:$370)/(('n° Versement'!$D$3:$D$7<>\"\")*(ISNA(MATCH('n° Versement'!$D$3:$D$7,Récapitulatif!$B$1:B9,0)))),1),),\"\")","v":""},{"$f":"IF(B10<>\"\",SUMPRODUCT(('n° Versement'!$F$3:$G$7)*('n° Versement'!$D$3:$D$7=Récapitulatif!B10))/2,\"\")","v":""},null,null,2,"DE/2024/ZO/18","Savigny","2024-05-22",7]
["",{"$f":"IFERROR(INDEX('n° Versement'!$D:$D,_xlfn.AGGREGATE(15,6,ROW($3:$370)/(('n° Versement'!$D$3:$D$7<>\"\")*(ISNA(MATCH('n° Versement'!$D$3:$D$7,Récapitulatif!$B$1:B10,0)))),1),),\"\")","v":""},{"$f":"SUBSTITUTE(_xlfn.CONCAT(IF('n° Versement'!$D$3:$D$7=B11,'n° Versement'!$C$3:$C$7&\", \",\"\")),\",\",\"\")","v":""},{"$f":"IFERROR(INDEX('n° Versement'!$E:$E,_xlfn.AGGREGATE(15,6,ROW($3:$370)/(('n° Versement'!$D$3:$D$7<>\"\")*(ISNA(MATCH('n° Versement'!$D$3:$D$7,Récapitulatif!$B$1:B10,0)))),1),),\"\")","v":""},{"$f":"IF(B11<>\"\",SUMPRODUCT(('n° Versement'!$F$3:$G$7)*('n° Versement'!$D$3:$D$7=Récapitulatif!B11))/2,\"\")","v":""},null,null,3,"699/V/04E","Bourbonnais","2022-02-03",3]
["",{"$f":"IFERROR(INDEX('n° Versement'!$D:$D,_xlfn.AGGREGATE(15,6,ROW($3:$370)/(('n° Versement'!$D$3:$D$7<>\"\")*(ISNA(MATCH('n° Versement'!$D$3:$D$7,Récapitulatif!$B$1:B11,0)))),1),),\"\")","v":""},null,{"$f":"IFERROR(INDEX('n° Versement'!$E:$E,_xlfn.AGGREGATE(15,6,ROW($3:$370)/(('n° Versement'!$D$3:$D$7<>\"\")*(ISNA(MATCH('n° Versement'!$D$3:$D$7,Récapitulatif!$B$1:B11,0)))),1),),\"\")","v":""},{"$f":"IF(B12<>\"\",SUMPRODUCT(('n° Versement'!$F$3:$G$7)*('n° Versement'!$D$3:$D$7=Récapitulatif!B12))/2,\"\")","v":""},null,null,4,"DE/2012/ZO/02","Dubourg","2012-09-20",4.5]
[null,{"$f":"IFERROR(INDEX('n° Versement'!$D:$D,_xlfn.AGGREGATE(15,6,ROW($3:$370)/(('n° Versement'!$D$3:$D$7<>\"\")*(ISNA(MATCH('n° Versement'!$D$3:$D$7,Récapitulatif!$B$1:B12,0)))),1),),\"\")","v":""},null,null,{"$f":"IF(B13<>\"\",SUMPRODUCT(('n° Versement'!$F$3:$G$7)*('n° Versement'!$D$3:$D$7=Récapitulatif!B13))/2,\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('n° Versement'!$D:$D,_xlfn.AGGREGATE(15,6,ROW($3:$370)/(('n° Versement'!$D$3:$D$7<>\"\")*(ISNA(MATCH('n° Versement'!$D$3:$D$7,Récapitulatif!$B$1:B13,0)))),1),),\"\")","v":""},null,null,{"$f":"IF(B14<>\"\",SUMPRODUCT(('n° Versement'!$F$3:$G$7)*('n° Versement'!$D$3:$D$7=Récapitulatif!B14))/2,\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('n° Versement'!$D:$D,_xlfn.AGGREGATE(15,6,ROW($3:$370)/(('n° Versement'!$D$3:$D$7<>\"\")*(ISNA(MATCH('n° Versement'!$D$3:$D$7,Récapitulatif!$B$1:B14,0)))),1),),\"\")","v":""},null,null,{"$f":"IF(B15<>\"\",SUMPRODUCT(('n° Versement'!$F$3:$G$7)*('n° Versement'!$D$3:$D$7=Récapitulatif!B15))/2,\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('n° Versement'!$D:$D,_xlfn.AGGREGATE(15,6,ROW($3:$370)/(('n° Versement'!$D$3:$D$7<>\"\")*(ISNA(MATCH('n° Versement'!$D$3:$D$7,Récapitulatif!$B$1:B15,0)))),1),),\"\")","v":""},null,null,{"$f":"IF(B16<>\"\",SUMPRODUCT(('n° Versement'!$F$3:$G$7)*('n° Versement'!$D$3:$D$7=Récapitulatif!B16))/2,\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('n° Versement'!$D:$D,_xlfn.AGGREGATE(15,6,ROW($3:$370)/(('n° Versement'!$D$3:$D$7<>\"\")*(ISNA(MATCH('n° Versement'!$D$3:$D$7,Récapitulatif!$B$1:B16,0)))),1),),\"\")","v":""},null,null,{"$f":"IF(B17<>\"\",SUMPRODUCT(('n° Versement'!$F$3:$G$7)*('n° Versement'!$D$3:$D$7=Récapitulatif!B17))/2,\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('n° Versement'!$D:$D,_xlfn.AGGREGATE(15,6,IF('n° Versement'!$D$3:$D$7<>\"\",IF(ISNA(MATCH('n° Versement'!$D$3:$D$7,Récapitulatif!$C$2:C18,0)),ROW($3:$370))),ROW(A17)),),\"\")","v":""},null,null,{"$f":"IF(B18<>\"\",SUMPRODUCT(('n° Versement'!$F$3:$G$7)*('n° Versement'!$D$3:$D$7=Récapitulatif!B18))/2,\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('n° Versement'!$D:$D,_xlfn.AGGREGATE(15,6,IF('n° Versement'!$D$3:$D$7<>\"\",IF(ISNA(MATCH('n° Versement'!$D$3:$D$7,Récapitulatif!$C$2:C19,0)),ROW($3:$370))),ROW(A18)),),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('n° Versement'!$D:$D,_xlfn.AGGREGATE(15,6,IF('n° Versement'!$D$3:$D$7<>\"\",IF(ISNA(MATCH('n° Versement'!$D$3:$D$7,Récapitulatif!$C$2:C20,0)),ROW($3:$370))),ROW(A19)),),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('n° Versement'!$D:$D,_xlfn.AGGREGATE(15,6,IF('n° Versement'!$D$3:$D$7<>\"\",IF(ISNA(MATCH('n° Versement'!$D$3:$D$7,Récapitulatif!$C$2:C21,0)),ROW($3:$370))),ROW(A20)),),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('n° Versement'!$D:$D,_xlfn.AGGREGATE(15,6,IF('n° Versement'!$D$3:$D$7<>\"\",IF(ISNA(MATCH('n° Versement'!$D$3:$D$7,Récapitulatif!$C$2:C22,0)),ROW($3:$370))),ROW(A21)),),\"\")","v":""}]

{"sheet":"n° Versement","index":2,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
["Début","Fin","Nom","N° Versement","Date de réception","Matin","Après-midi"]
["2024-07-26","2024-08-09","Dubourg","DE/2024/ZO/23","2024-07-27",5,5]
["2024-07-26","2024-08-06","Miralles","DE/2024/ZO/23","2024-07-27",4,5]
["2024-08-03","2024-08-23","Savigny","DE/2024/ZO/18","2024-05-22",7,7]
["2024-08-06","2024-08-16","Bourbonnais","699/V/04E","2022-02-03",3,3]
["2024-08-10","2024-08-18","Dubourg","DE/2012/ZO/02","2012-09-20",4,5]