{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Page d'accés","Feuil1","Feuil2","Feuil3","Feuil4","Feuille synthèse"],"not_rendered":{"charts":4,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":2},"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":"Page d'accés","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Feuil1","index":1,"n_rows":44,"n_cols":18,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["Numéro de transport","Départ","Transporteur","Chauffeur ","Nbr de tournées ","Numéro des tournées ","Date départ","Total palettes au sol","Total palettes","Total palettes europe","Total palettes rendues","Infos Client ","mois","Années","Compte transporteur","Palettes rendues","Mois rendues","Année rendues"]
[1,"Artmadis","Geodis AFF","Eric",2,157,"2017-11-18",1,1,1,0,"AUCHAN","novembre",2017,{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":"Geodis"},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":10},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":"2017-12-19"},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":"2017-12-19"}]
[1,"Artmadis","Geodis AFF","Eric",null,158,"2017-11-18",12,8,12,0,"SOFIDIS","novembre",2017,{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":"Schenker"},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":20},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":"2017-12-19"},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":"2017-12-19"}]
[2,"Artmadis","Geodis MESS","Kevin",1,12,"2017-11-28",12,12,12,0,"INTERMACHE","novembre",2017,{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":"Quil"},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":30},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":"2017-12-19"},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":"2017-12-19"}]
[3,"Artmadis","Geodis AFF","Thibaut",2,149,"2017-11-28",14,14,14,0,"LOUVROIL","novembre",2017,{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":"Geodis"},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":20},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":"2018-01-03"},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":"2018-01-03"}]
[3,"Artmadis","Geodis AFF","Thibaut",null,124,"2017-11-28",10,18,8,0,"TRAFIC","novembre",2017,{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":"Geodis AFF"},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":50},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":"2018-01-15"},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":"2018-01-15"}]
[4,"Artmadis","Geodis MESS","Jean-Michel",3,18574,"2017-12-02",10,10,10,0,"CORA COLMAR",{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2017-12-02"},{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2017-12-02"},{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":"Transinter"},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":20},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":"2018-01-15"},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":"2018-01-15"}]
[4,"Artmadis","Geodis MESS","Jean-Michel",null,18575,"2017-12-02",8,8,8,0,"EXEDENCE",{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2017-12-02"},{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2017-12-02"},{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":"Gilliers"},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":40},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":"2018-01-15"},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":"2018-01-15"}]
[4,"Artmadis","Geodis MESS","Jean-Michel",null,18576,"2017-12-02",5,5,5,0,"LEROY MERLIN",{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2017-12-02"},{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2017-12-02"},{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":0},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":""}]
[5,"Artmadis","Geodis MESS","Kevin",5,27847,"2017-02-12",10,10,10,0,"INTERMACHE ",{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2017-02-12"},{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2017-02-12"},{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":0},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":""}]
[5,"Artmadis","Geodis MESS","Kevin",null,27848,"2017-02-12",4,4,4,0,"BOULANGER",{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2017-02-12"},{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2017-02-12"},{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":0},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":""}]
[5,"Artmadis","Geodis MESS","Kevin",null,27849,"2017-02-12",12,12,12,0,"BUSSY LETTRE",{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2017-02-12"},{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2017-02-12"},{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":0},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":""}]
[5,"Artmadis","Geodis MESS","Kevin",null,27850,"2017-02-12",2,2,2,0,"PARIS",{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2017-02-12"},{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2017-02-12"},{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":0},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":""}]
[5,"Artmadis","Geodis MESS","Kevin",null,27851,"2017-02-12",3,3,3,0,"ROUEN",{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2017-02-12"},{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2017-02-12"},{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":0},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":""}]
[6,"Artmadis","Quil","Patrick",1,94741,"2018-08-02",54,54,54,0,"TRAFIC",{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2018-08-02"},{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2018-08-02"},{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":0},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":""}]
[7,"Artmadis","Schenker MESS","Sandrine",2,17484,"2017-12-02",8,8,8,0,"TRAFIC VALENCIENNES",{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2017-12-02"},{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2017-12-02"},{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":0},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":""}]
[7,"Artmadis","Schenker MESS","Sandrine",null,17485,"2017-12-02",4,4,4,0,"SPORT 2000",{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2017-12-02"},{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2017-12-02"},{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":0},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":""}]
[8,"Artmadis","Geodis AFF","Zizou",1,74847,"2017-12-02",21,21,21,0,"BUSSY LETTRE",{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2017-12-02"},{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2017-12-02"},{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":0},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":""}]
[9,"Artmadis","Geodis AFF","Sophie",1,74844,"2017-12-02",4,4,4,0,"AUCHAN LILLE",{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2017-12-02"},{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2017-12-02"},{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":0},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":""}]
[10,"Artmadis","Schenker MESS","Sophie",1,74844,"2017-12-02",4,4,4,0,"AUCHAN LILLE",{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2017-12-02"},{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2017-12-02"},{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":0},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":""}]
[11,"Artmadis","Geodis MESS","Anthony",1,18747,"2017-12-02",147,157,156,0,"SYSTEM U",{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2017-12-02"},{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2017-12-02"},{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":0},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":""}]
[12,"Artmadis","Quil","Cherubin",2,7474,"2018-09-02",14,14,14,0,"VIAPOST",{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2018-09-02"},{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2018-09-02"},{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":0},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":""}]
[12,"Artmadis","Quil","Cherubin",null,7475,"2018-09-02",12,12,12,0,"VIAPOST LESQUIN",{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2018-09-02"},{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2018-09-02"},{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":0},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":""}]
[13,"Artmadis","Geodis MESS","Cherubin",2,7484,"2017-12-02",14,14,14,0,"VIAPOST",{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2017-12-02"},{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2017-12-02"},{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":0},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":""}]
[13,"Artmadis","Geodis MESS","Cherubin",null,7485,"2017-12-02",12,12,12,0,"VIAPOST LESQUIN",{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2017-12-02"},{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2017-12-02"},{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":0},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":""}]
[14,"Artmadis","Quil","Eric",2,1774,"2018-02-22",12,12,12,0,"AUCHAN","décembre",2017,{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":0},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":""}]
[14,"Artmadis","Quil","Eric",null,1775,"2018-02-22",11,11,11,0,"SUPER U","décembre",2017,{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":0},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":""}]
[15,"Artmadis","Schenker MESS","Kevin",1,8741,"2017-12-18",2,2,2,0,"CARRFOUR","décembre",2017,{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":0},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":""}]
[16,"Artmadis","Geodis AFF","Geod",2,8747,"2018-01-15",10,10,10,0,"Lezennes","janvier",2017,{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":0},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":""}]
[16,"Artmadis","Geodis AFF","Geod",null,8748,"2018-01-15",6,6,6,0,"Roubaix","janvier",2017,{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":0},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":""}]
[17,"Artmadis","Schenker AFF","Goeffrey",1,8741,"2018-01-15",4,4,4,0,"Auchan","janvier",2017,{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":0},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":""}]
[18,"Artmadis","Gilliers","AZAZ",1,4741,"2018-01-15",1,1,1,0,"CRepin",{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2018-01-15"},{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2018-01-15"},{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":0},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":""}]
[19,"Artmadis","Geodis AFF","1",1,17474,"2018-01-15",12,12,12,0,"zedsd",{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2018-01-15"},{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2018-01-15"},{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":0},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":""}]
[20,"Artmadis","Maingret","tHIBAUT",2,444,"2018-01-15",66,66,66,0,"AZ",{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2018-01-15"},{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2018-01-15"},{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":0},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":""}]
[20,"Artmadis","Maingret","tHIBAUT",null,444,"2018-01-15",66,66,66,0,"AZ",{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2018-01-15"},{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2018-01-15"},{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":0},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":""}]
[21,"Artmadis","Quil","Didier",1,7414,"2018-01-18",14,14,14,0,"GTR",{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2018-01-18"},{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2018-01-18"},{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":0},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":""}]
[22,"Artmadis","Quil","Guillaume",1,1417,"2018-03-16",14,14,14,0,"GFV",{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2018-03-16"},{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2018-03-16"},{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":0},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":""}]
[23,"Artmadis","Quil","rf",1,4714,"2018-04-12",34,34,34,0,"gfg",{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2018-04-12"},{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2018-04-12"},{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":0},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":""}]
[24,"Artmadis","Quil","Thibaut",1,14174,"2018-05-17",57,57,57,0,"GGDFG",{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2018-05-17"},{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2018-05-17"},{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":0},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":""}]
[25,"Artmadis","Quil","erfd",1,7441,"2018-06-14",47,47,47,0,"gdfg",{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2018-06-14"},{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2018-06-14"},{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":0},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":""}]
[26,"Artmadis","Quil","dd",1,1714,"2018-07-27",15,15,15,0,"fsdf",{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2018-07-27"},{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2018-07-27"},{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":0},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":""}]
[27,"Artmadis","Quil","ZAZA",1,47411,"2018-10-17",10,10,10,0,"DF",{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2018-10-17"},{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2018-10-17"},{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":0},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":""}]
[28,"Artmadis","Quil","ZDZE",1,7471,"2018-11-15",49,49,49,0,"DFS",{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2018-11-15"},{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2018-11-15"},{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":0},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":""}]
[29,"Artmadis","Quil","FDD",1,1471,"2018-12-28",27,27,27,0,"FD",{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2018-12-28"},{"$f":"Tableau1[[#This Row],[Date départ]]","v":"2018-12-28"},{"$f":"IFERROR(Tableau3[[#This Row],[Transporteur]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Palettes europe rendues]],0)","v":0},{"$f":"IFERROR(Tableau3[[#This Row],[Mois]],\"\")","v":""},{"$f":"IFERROR(Tableau3[[#This Row],[Années]],\"\")","v":""}]

{"sheet":"Feuil2","index":2,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[{"$f":"TODAY()","v":"2018-01-18"}]
["Transporteur","Colonne1"]
["Quil",{"$f":"SUMIF(Feuil1!C:C,Tableau2[[#This Row],[Transporteur]],Feuil1!J:J)","v":370},"Numéro du transport en enregistrement ",{"$f":"MAX(Feuil1!A:A)+1","v":30}]
["Crepin",{"$f":"SUMIF(Feuil1!C:C,Tableau2[[#This Row],[Transporteur]],Feuil1!J:J)","v":0},"Nombre de transport actuel ",{"$f":"D3-1","v":29}]
["Geodis AFF",{"$f":"SUMIF(Feuil1!C:C,Tableau2[[#This Row],[Transporteur]],Feuil1!J:J)","v":88},"Total palettes europe envoyées",{"$f":"SUM(Feuil1!J2:J1048576)","v":861}]
["Geodis MESS",{"$f":"SUMIF(Feuil1!C:C,Tableau2[[#This Row],[Transporteur]],Feuil1!J:J)","v":248},"Total palettes europe reçues",{"$f":"SUM(Feuil3!C2:C1048576)","v":190}]
["Transinter",{"$f":"SUMIF(Feuil1!C:C,Tableau2[[#This Row],[Transporteur]],Feuil1!J:J)","v":0}]
["Cofistock NORD",{"$f":"SUMIF(Feuil1!C:C,Tableau2[[#This Row],[Transporteur]],Feuil1!J:J)","v":0}]
["Cofistock OUEST",{"$f":"SUMIF(Feuil1!C:C,Tableau2[[#This Row],[Transporteur]],Feuil1!J:J)","v":0}]
["Schenker MESS",{"$f":"SUMIF(Feuil1!C:C,Tableau2[[#This Row],[Transporteur]],Feuil1!J:J)","v":18}]
["Schenker AFF",{"$f":"SUMIF(Feuil1!C:C,Tableau2[[#This Row],[Transporteur]],Feuil1!J:J)","v":4}]
["Schenker MESS",{"$f":"SUMIF(Feuil1!C:C,Tableau2[[#This Row],[Transporteur]],Feuil1!J:J)","v":18}]
["Enlevement client",{"$f":"SUMIF(Feuil1!C:C,Tableau2[[#This Row],[Transporteur]],Feuil1!J:J)","v":0}]
["Maingret",{"$f":"SUMIF(Feuil1!C:C,Tableau2[[#This Row],[Transporteur]],Feuil1!J:J)","v":132}]
["Gilliers",{"$f":"SUMIF(Feuil1!C:C,Tableau2[[#This Row],[Transporteur]],Feuil1!J:J)","v":1}]

{"sheet":"Feuil3","index":3,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Transporteur","Date retour","Palettes europe rendues","Mois","Années"]
["Geodis","2017-12-19",10,{"$f":"Tableau3[[#This Row],[Date retour]]","v":"2017-12-19"},{"$f":"Tableau3[[#This Row],[Date retour]]","v":"2017-12-19"}]
["Schenker","2017-12-19",20,{"$f":"Tableau3[[#This Row],[Date retour]]","v":"2017-12-19"},{"$f":"Tableau3[[#This Row],[Date retour]]","v":"2017-12-19"}]
["Quil","2017-12-19",30,{"$f":"Tableau3[[#This Row],[Date retour]]","v":"2017-12-19"},{"$f":"Tableau3[[#This Row],[Date retour]]","v":"2017-12-19"}]
["Geodis","2018-01-03",20,{"$f":"Tableau3[[#This Row],[Date retour]]","v":"2018-01-03"},{"$f":"Tableau3[[#This Row],[Date retour]]","v":"2018-01-03"}]
["Geodis AFF","2018-01-15",50,{"$f":"Tableau3[[#This Row],[Date retour]]","v":"2018-01-15"},{"$f":"Tableau3[[#This Row],[Date retour]]","v":"2018-01-15"}]
["Transinter","2018-01-15",20,{"$f":"Tableau3[[#This Row],[Date retour]]","v":"2018-01-15"},{"$f":"Tableau3[[#This Row],[Date retour]]","v":"2018-01-15"}]
["Gilliers","2018-01-15",40,{"$f":"Tableau3[[#This Row],[Date retour]]","v":"2018-01-15"},{"$f":"Tableau3[[#This Row],[Date retour]]","v":"2018-01-15"}]

{"sheet":"Feuil4","index":4,"n_rows":20,"n_cols":22,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[" Palettes europe rendues","Transporteur",null,null,null,null,null,null,null,null,null,null,null,"Palettes europe données","Transporteur"]
["Année/Mois","Geodis","Geodis AFF","Gilliers","Quil","Schenker","Transinter","Total général",null,null,null,null,null,"Année/Mois","Geodis AFF","Geodis MESS","Gilliers","Maingret","Quil","Schenker AFF","Schenker MESS","Total général"]
["2017",null,null,null,null,null,null,null,null,null,null,null,null,"2017"]
["déc",10,null,null,30,20,null,60,null,null,null,null,null,"févr",null,31,null,null,null,null,null,31]
["2018",null,null,null,null,null,null,null,null,null,null,null,null,"nov",35,12,null,null,null,null,null,47]
["janv",20,50,40,null,null,20,130,null,null,null,null,null,"déc",25,205,null,null,null,null,18,248]
["Total général",30,50,40,30,20,20,190,null,null,null,null,null,"2018"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"janv",28,null,1,132,14,4,null,179]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"févr",null,null,null,null,23,null,null,23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"mars",null,null,null,null,14,null,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"avr",null,null,null,null,34,null,null,34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"mai",null,null,null,null,57,null,null,57]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"juin",null,null,null,null,47,null,null,47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"juil",null,null,null,null,15,null,null,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"août",null,null,null,null,54,null,null,54]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"sept",null,null,null,null,26,null,null,26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"oct",null,null,null,null,10,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"nov",null,null,null,null,49,null,null,49]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"déc",null,null,null,null,27,null,null,27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total général",88,248,1,132,370,4,18,861]

{"sheet":"Feuille synthèse","index":5,"n_rows":50,"n_cols":22,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,9,2,12]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q4:Q15)","v":370},{"$f":"SUM(R4:R15)","v":0},null,null,{"$f":"SUM(U4:U15)","v":1665},{"$f":"SUM(V4:V15)","v":0}]
[null,null,null,null,null,null,null,null,null,"Quil"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Palettes Europes données","Palettes Europe Rendues",null,null,"Palettes Europes données","Palettes Europe Rendues"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-01-01",14,0,null,{"$f":"IF(P4<>\"\",P4,\"\")","v":"2018-01-01"},{"$f":"4.5*Q4","v":63},{"$f":"R4*4.5","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-02-01",23,0,null,{"$f":"IF(P5<>\"\",P5,\"\")","v":"2018-02-01"},{"$f":"4.5*Q5","v":103.5},{"$f":"R5*4.5","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-03-01",14,0,null,"2018-03-01",63,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-04-01",34,0,null,"2018-04-01",153,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-05-01",57,0,null,"2018-05-01",256.5,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-06-01",47,0,null,"2018-06-01",211.5,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-07-01",15,0,null,"2018-07-01",67.5,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-08-01",54,0,null,"2018-08-01",243,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-09-01",26,0,null,"2018-09-01",117,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-10-01",10,0,null,"2018-10-01",45,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-11-01",49,0,null,"2018-11-01",220.5,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-12-01",27,0,null,"2018-12-01",121.5,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]