{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["SEM 1","SEM 2","SEM 3","SEM 4","SEM 5","JANVIER","SEM 5+"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":12},"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":"SEM 1","index":0,"n_rows":41,"n_cols":33,"rows_kept":41,"cut":false,"hidden":false,"merged":[[9,1,16,1],[17,1,24,1],[25,1,32,1],[33,1,40,1],[1,0,8,0],[9,0,16,0],[17,0,24,0],[25,0,32,0],[33,0,40,0],[1,1,8,1]]}
["JOUR","DATE","CODE","Heure","Départ / Retour","Départ","ADRESSE 1","Arrivée","ADRESSE 2","Km Parcourus","Transporteur","Type de camions","Emission CO2","Facturable","N° bon\nV-HA","N° bon\nV-MAT","N° Facture transporteur","Nombre de transport","Facturé sur VMAT","Commande hors délai et/ou rajout","Tarif refacturé aux chantiers","Tarif transporteur",null,"Commentaires"]
["Lundi ","2016-01-02",null,"07H00","DEPART","ADOMA",{"$f":"+IFERROR(VLOOKUP(F2,#REF!,2),\"\")","v":""},"BLANCHE CASTILLE",{"$f":"+IFERROR(HLOOKUP(H2,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G2,#REF!,0),MATCH('SEM 1'!$I2,#REF!,0)),\"\")","v":""},"LOISEAU",null,null,"Facturable",null,null,null,4,"OUI","RAJOUT",null,null,null,null,null,"Transporteurs","Somme de Km Parcourus","Somme de Nombre de transport",null,"TOTAL refacturation par Transporteur","Facturé sur VMAT"]
[null,null,null,"07H30","DEPART","BLANCHE CASTILLE",{"$f":"+IFERROR(VLOOKUP(F3,#REF!,2),\"\")","v":""},"CIVAUX DUS ",{"$f":"+IFERROR(HLOOKUP(H3,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G3,#REF!,0),MATCH('SEM 1'!$I3,#REF!,0)),\"\")","v":""},"BRANGEON",null,null,"Facturable",null,null,null,1,"NON","RAJOUT",null,null,null,null,null,"BRANGEON",169,1,null,"Transporteurs","OUI","NON","Total général"]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F4,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H4,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G4,#REF!,0),MATCH('SEM 1'!$I4,#REF!,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOISEAU",106,4,null,"BRANGEON"]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F5,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H5,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G5,#REF!,0),MATCH('SEM 1'!$I5,#REF!,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total général",275,5,null,"LOISEAU"]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F6,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H6,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G6,#REF!,0),MATCH('SEM 1'!$I6,#REF!,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total général"]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F7,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H7,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G7,#REF!,0),MATCH('SEM 1'!$I7,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F8,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H8,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G8,#REF!,0),MATCH('SEM 1'!$I8,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F9,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H9,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G9,#REF!,0),MATCH('SEM 1'!$I9,#REF!,0)),\"\")","v":""}]
["Mardi ","2016-01-03",null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F10,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H10,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G10,#REF!,0),MATCH('SEM 1'!$I10,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F11,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H11,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G11,#REF!,0),MATCH('SEM 1'!$I11,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F12,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H12,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G12,#REF!,0),MATCH('SEM 1'!$I12,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F13,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H13,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G13,#REF!,0),MATCH('SEM 1'!$I13,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F14,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H14,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G14,#REF!,0),MATCH('SEM 1'!$I14,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F15,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H15,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G15,#REF!,0),MATCH('SEM 1'!$I15,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F16,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H16,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G16,#REF!,0),MATCH('SEM 1'!$I16,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F17,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H17,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G17,#REF!,0),MATCH('SEM 1'!$I17,#REF!,0)),\"\")","v":""}]
["Mercredi ","2016-01-04",null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F18,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H18,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G18,#REF!,0),MATCH('SEM 1'!$I18,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F19,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H19,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G19,#REF!,0),MATCH('SEM 1'!$I19,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F20,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H20,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G20,#REF!,0),MATCH('SEM 1'!$I20,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F21,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H21,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G21,#REF!,0),MATCH('SEM 1'!$I21,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F22,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H22,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G22,#REF!,0),MATCH('SEM 1'!$I22,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F23,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H23,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G23,#REF!,0),MATCH('SEM 1'!$I23,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F24,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H24,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G24,#REF!,0),MATCH('SEM 1'!$I24,#REF!,0)),\"\")","v":""}]
["Jeudi ",null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F25,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H25,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G25,#REF!,0),MATCH('SEM 1'!$I25,#REF!,0)),\"\")","v":""}]
["Jeudi ","2016-01-05",null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F26,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H26,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G26,#REF!,0),MATCH('SEM 1'!$I26,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F27,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H27,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G27,#REF!,0),MATCH('SEM 1'!$I27,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F28,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H28,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G28,#REF!,0),MATCH('SEM 1'!$I28,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F29,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H29,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G29,#REF!,0),MATCH('SEM 1'!$I29,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F30,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H30,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G30,#REF!,0),MATCH('SEM 1'!$I30,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F31,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H31,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G31,#REF!,0),MATCH('SEM 1'!$I31,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F32,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H32,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G32,#REF!,0),MATCH('SEM 1'!$I32,#REF!,0)),\"\")","v":""}]
["Vendredi ",null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F33,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H33,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G33,#REF!,0),MATCH('SEM 1'!$I33,#REF!,0)),\"\")","v":""}]
["Vendredi ","2016-01-06",null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F34,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H34,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G34,#REF!,0),MATCH('SEM 1'!$I34,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F35,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H35,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G35,#REF!,0),MATCH('SEM 1'!$I35,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F36,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H36,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G36,#REF!,0),MATCH('SEM 1'!$I36,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F37,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H37,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G37,#REF!,0),MATCH('SEM 1'!$I37,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F38,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H38,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G38,#REF!,0),MATCH('SEM 1'!$I38,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F39,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H39,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G39,#REF!,0),MATCH('SEM 1'!$I39,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F40,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H40,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G40,#REF!,0),MATCH('SEM 1'!$I40,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F41,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H41,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 1'!$G41,#REF!,0),MATCH('SEM 1'!$I41,#REF!,0)),\"\")","v":""}]

{"sheet":"SEM 2","index":1,"n_rows":41,"n_cols":33,"rows_kept":41,"cut":false,"hidden":false,"merged":[[25,0,32,0],[25,1,32,1],[33,0,40,0],[33,1,40,1],[1,0,8,0],[1,1,8,1],[9,0,16,0],[9,1,16,1],[17,0,24,0],[17,1,24,1]]}
["JOUR","DATE","CODE","Heure","Départ / Retour","Départ","ADRESSE 1","Arrivée","ADRESSE 2","Km Parcourus","Transporteur","Type de camions","Emission CO2","Facturable","N° bon\nV-HA","N° bon\nV-MAT","N° Facture transporteur","Nombre de transport","Facturé sur VMAT","Commande hors délai et/ou rajout","Tarif refacturé aux chantiers","Tarif transporteur",null,"Commentaires"]
["Lundi ","2016-01-09",null,"07H00","DEPART","ADOMA",{"$f":"+IFERROR(VLOOKUP(F2,#REF!,2),\"\")","v":""},"BLANCHE CASTILLE",{"$f":"+IFERROR(HLOOKUP(H2,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G2,#REF!,0),MATCH('SEM 2'!$I2,#REF!,0)),\"\")","v":""},"LOISEAU",null,null,"Facturable",null,null,null,4,"OUI","RAJOUT",null,null,null,null,null,"Transporteurs","Somme de Km Parcourus","Somme de Nombre de transport",null,"TOTAL refacturation par Transporteur","Facturé sur VMAT"]
[null,null,null,"07H30","DEPART","BLANCHE CASTILLE",{"$f":"+IFERROR(VLOOKUP(F3,#REF!,2),\"\")","v":""},"CIVAUX DUS ",{"$f":"+IFERROR(HLOOKUP(H3,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G3,#REF!,0),MATCH('SEM 2'!$I3,#REF!,0)),\"\")","v":""},"BRANGEON",null,null,"Facturable",null,null,null,1,"NON","RAJOUT",null,null,null,null,null,"BRANGEON",169,1,null,"Transporteurs","OUI","NON","Total général"]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F4,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H4,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G4,#REF!,0),MATCH('SEM 2'!$I4,#REF!,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOISEAU",106,4,null,"BRANGEON"]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F5,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H5,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G5,#REF!,0),MATCH('SEM 2'!$I5,#REF!,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total général",275,5,null,"LOISEAU"]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F6,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H6,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G6,#REF!,0),MATCH('SEM 2'!$I6,#REF!,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total général"]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F7,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H7,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G7,#REF!,0),MATCH('SEM 2'!$I7,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F8,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H8,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G8,#REF!,0),MATCH('SEM 2'!$I8,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F9,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H9,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G9,#REF!,0),MATCH('SEM 2'!$I9,#REF!,0)),\"\")","v":""}]
["Mardi ","2016-01-10",null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F10,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H10,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G10,#REF!,0),MATCH('SEM 2'!$I10,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F11,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H11,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G11,#REF!,0),MATCH('SEM 2'!$I11,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F12,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H12,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G12,#REF!,0),MATCH('SEM 2'!$I12,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F13,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H13,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G13,#REF!,0),MATCH('SEM 2'!$I13,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F14,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H14,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G14,#REF!,0),MATCH('SEM 2'!$I14,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F15,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H15,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G15,#REF!,0),MATCH('SEM 2'!$I15,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F16,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H16,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G16,#REF!,0),MATCH('SEM 2'!$I16,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F17,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H17,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G17,#REF!,0),MATCH('SEM 2'!$I17,#REF!,0)),\"\")","v":""}]
["Mercredi ","2016-01-11",null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F18,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H18,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G18,#REF!,0),MATCH('SEM 2'!$I18,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F19,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H19,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G19,#REF!,0),MATCH('SEM 2'!$I19,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F20,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H20,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G20,#REF!,0),MATCH('SEM 2'!$I20,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F21,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H21,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G21,#REF!,0),MATCH('SEM 2'!$I21,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F22,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H22,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G22,#REF!,0),MATCH('SEM 2'!$I22,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F23,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H23,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G23,#REF!,0),MATCH('SEM 2'!$I23,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F24,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H24,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G24,#REF!,0),MATCH('SEM 2'!$I24,#REF!,0)),\"\")","v":""}]
["Jeudi ",null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F25,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H25,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G25,#REF!,0),MATCH('SEM 2'!$I25,#REF!,0)),\"\")","v":""}]
["Jeudi ","2016-01-12",null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F26,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H26,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G26,#REF!,0),MATCH('SEM 2'!$I26,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F27,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H27,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G27,#REF!,0),MATCH('SEM 2'!$I27,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F28,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H28,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G28,#REF!,0),MATCH('SEM 2'!$I28,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F29,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H29,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G29,#REF!,0),MATCH('SEM 2'!$I29,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F30,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H30,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G30,#REF!,0),MATCH('SEM 2'!$I30,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F31,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H31,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G31,#REF!,0),MATCH('SEM 2'!$I31,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F32,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H32,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G32,#REF!,0),MATCH('SEM 2'!$I32,#REF!,0)),\"\")","v":""}]
["Vendredi ",null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F33,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H33,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G33,#REF!,0),MATCH('SEM 2'!$I33,#REF!,0)),\"\")","v":""}]
["Vendredi ","2016-01-13",null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F34,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H34,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G34,#REF!,0),MATCH('SEM 2'!$I34,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F35,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H35,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G35,#REF!,0),MATCH('SEM 2'!$I35,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F36,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H36,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G36,#REF!,0),MATCH('SEM 2'!$I36,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F37,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H37,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G37,#REF!,0),MATCH('SEM 2'!$I37,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F38,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H38,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G38,#REF!,0),MATCH('SEM 2'!$I38,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F39,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H39,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G39,#REF!,0),MATCH('SEM 2'!$I39,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F40,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H40,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G40,#REF!,0),MATCH('SEM 2'!$I40,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F41,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H41,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 2'!$G41,#REF!,0),MATCH('SEM 2'!$I41,#REF!,0)),\"\")","v":""}]

{"sheet":"SEM 3","index":2,"n_rows":41,"n_cols":33,"rows_kept":41,"cut":false,"hidden":false,"merged":[[25,0,32,0],[25,1,32,1],[33,0,40,0],[33,1,40,1],[1,0,8,0],[1,1,8,1],[9,0,16,0],[9,1,16,1],[17,0,24,0],[17,1,24,1]]}
["JOUR","DATE","CODE","Heure","Départ / Retour","Départ","ADRESSE 1","Arrivée","ADRESSE 2","Km Parcourus","Transporteur","Type de camions","Emission CO2","Facturable","N° bon\nV-HA","N° bon\nV-MAT","N° Facture transporteur","Nombre de transport","Facturé sur VMAT","Commande hors délai et/ou rajout","Tarif refacturé aux chantiers","Tarif transporteur",null,"Commentaires"]
["Lundi ","2016-01-16",null,"07H00","DEPART","ADOMA",{"$f":"+IFERROR(VLOOKUP(F2,#REF!,2),\"\")","v":""},"BLANCHE CASTILLE",{"$f":"+IFERROR(HLOOKUP(H2,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G2,#REF!,0),MATCH('SEM 3'!$I2,#REF!,0)),\"\")","v":""},"LOISEAU",null,null,"Facturable",null,null,null,4,"OUI","RAJOUT",null,null,null,null,null,"Transporteurs","Somme de Km Parcourus","Somme de Nombre de transport",null,"TOTAL refacturation par Transporteur","Facturé sur VMAT"]
[null,null,null,"07H30","DEPART","BLANCHE CASTILLE",{"$f":"+IFERROR(VLOOKUP(F3,#REF!,2),\"\")","v":""},"CIVAUX DUS ",{"$f":"+IFERROR(HLOOKUP(H3,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G3,#REF!,0),MATCH('SEM 3'!$I3,#REF!,0)),\"\")","v":""},"BRANGEON",null,null,"Facturable",null,null,null,1,"NON","RAJOUT",null,null,null,null,null,"BRANGEON",169,1,null,"Transporteurs","OUI","NON","Total général"]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F4,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H4,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G4,#REF!,0),MATCH('SEM 3'!$I4,#REF!,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOISEAU",106,4,null,"BRANGEON"]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F5,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H5,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G5,#REF!,0),MATCH('SEM 3'!$I5,#REF!,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total général",275,5,null,"LOISEAU"]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F6,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H6,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G6,#REF!,0),MATCH('SEM 3'!$I6,#REF!,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total général"]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F7,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H7,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G7,#REF!,0),MATCH('SEM 3'!$I7,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F8,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H8,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G8,#REF!,0),MATCH('SEM 3'!$I8,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F9,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H9,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G9,#REF!,0),MATCH('SEM 3'!$I9,#REF!,0)),\"\")","v":""}]
["Mardi ","2016-01-17",null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F10,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H10,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G10,#REF!,0),MATCH('SEM 3'!$I10,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F11,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H11,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G11,#REF!,0),MATCH('SEM 3'!$I11,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F12,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H12,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G12,#REF!,0),MATCH('SEM 3'!$I12,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F13,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H13,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G13,#REF!,0),MATCH('SEM 3'!$I13,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F14,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H14,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G14,#REF!,0),MATCH('SEM 3'!$I14,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F15,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H15,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G15,#REF!,0),MATCH('SEM 3'!$I15,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F16,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H16,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G16,#REF!,0),MATCH('SEM 3'!$I16,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F17,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H17,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G17,#REF!,0),MATCH('SEM 3'!$I17,#REF!,0)),\"\")","v":""}]
["Mercredi ","2016-01-18",null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F18,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H18,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G18,#REF!,0),MATCH('SEM 3'!$I18,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F19,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H19,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G19,#REF!,0),MATCH('SEM 3'!$I19,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F20,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H20,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G20,#REF!,0),MATCH('SEM 3'!$I20,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F21,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H21,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G21,#REF!,0),MATCH('SEM 3'!$I21,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F22,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H22,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G22,#REF!,0),MATCH('SEM 3'!$I22,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F23,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H23,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G23,#REF!,0),MATCH('SEM 3'!$I23,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F24,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H24,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G24,#REF!,0),MATCH('SEM 3'!$I24,#REF!,0)),\"\")","v":""}]
["Jeudi ",null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F25,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H25,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G25,#REF!,0),MATCH('SEM 3'!$I25,#REF!,0)),\"\")","v":""}]
["Jeudi ","2016-01-19",null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F26,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H26,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G26,#REF!,0),MATCH('SEM 3'!$I26,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F27,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H27,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G27,#REF!,0),MATCH('SEM 3'!$I27,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F28,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H28,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G28,#REF!,0),MATCH('SEM 3'!$I28,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F29,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H29,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G29,#REF!,0),MATCH('SEM 3'!$I29,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F30,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H30,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G30,#REF!,0),MATCH('SEM 3'!$I30,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F31,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H31,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G31,#REF!,0),MATCH('SEM 3'!$I31,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F32,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H32,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G32,#REF!,0),MATCH('SEM 3'!$I32,#REF!,0)),\"\")","v":""}]
["Vendredi ",null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F33,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H33,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G33,#REF!,0),MATCH('SEM 3'!$I33,#REF!,0)),\"\")","v":""}]
["Vendredi ","2016-01-20",null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F34,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H34,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G34,#REF!,0),MATCH('SEM 3'!$I34,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F35,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H35,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G35,#REF!,0),MATCH('SEM 3'!$I35,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F36,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H36,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G36,#REF!,0),MATCH('SEM 3'!$I36,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F37,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H37,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G37,#REF!,0),MATCH('SEM 3'!$I37,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F38,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H38,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G38,#REF!,0),MATCH('SEM 3'!$I38,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F39,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H39,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G39,#REF!,0),MATCH('SEM 3'!$I39,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F40,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H40,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G40,#REF!,0),MATCH('SEM 3'!$I40,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F41,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H41,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 3'!$G41,#REF!,0),MATCH('SEM 3'!$I41,#REF!,0)),\"\")","v":""}]

{"sheet":"SEM 4","index":3,"n_rows":41,"n_cols":33,"rows_kept":41,"cut":false,"hidden":false,"merged":[[25,0,32,0],[25,1,32,1],[33,0,40,0],[33,1,40,1],[1,0,8,0],[1,1,8,1],[9,0,16,0],[9,1,16,1],[17,0,24,0],[17,1,24,1]]}
["JOUR","DATE","CODE","Heure","Départ / Retour","Départ","ADRESSE 1","Arrivée","ADRESSE 2","Km Parcourus","Transporteur","Type de camions","Emission CO2","Facturable","N° bon\nV-HA","N° bon\nV-MAT","N° Facture transporteur","Nombre de transport","Facturé sur VMAT","Commande hors délai et/ou rajout","Tarif refacturé aux chantiers","Tarif transporteur",null,"Commentaires"]
["Lundi ","2016-01-23",null,"07H00","DEPART","ADOMA",{"$f":"+IFERROR(VLOOKUP(F2,#REF!,2),\"\")","v":""},"BLANCHE CASTILLE",{"$f":"+IFERROR(HLOOKUP(H2,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G2,#REF!,0),MATCH('SEM 4'!$I2,#REF!,0)),\"\")","v":""},"LOISEAU",null,null,"Facturable",null,null,null,4,"OUI","RAJOUT",null,null,null,null,null,"Transporteurs","Somme de Km Parcourus","Somme de Nombre de transport",null,"TOTAL refacturation par Transporteur","Facturé sur VMAT"]
[null,null,null,"07H30","DEPART","BLANCHE CASTILLE",{"$f":"+IFERROR(VLOOKUP(F3,#REF!,2),\"\")","v":""},"CIVAUX DUS ",{"$f":"+IFERROR(HLOOKUP(H3,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G3,#REF!,0),MATCH('SEM 4'!$I3,#REF!,0)),\"\")","v":""},"BRANGEON",null,null,"Facturable",null,null,null,1,"NON","RAJOUT",null,null,null,null,null,"BRANGEON",169,1,null,"Transporteurs","OUI","NON","Total général"]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F4,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H4,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G4,#REF!,0),MATCH('SEM 4'!$I4,#REF!,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOISEAU",106,4,null,"BRANGEON"]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F5,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H5,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G5,#REF!,0),MATCH('SEM 4'!$I5,#REF!,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total général",275,5,null,"LOISEAU"]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F6,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H6,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G6,#REF!,0),MATCH('SEM 4'!$I6,#REF!,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total général"]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F7,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H7,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G7,#REF!,0),MATCH('SEM 4'!$I7,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F8,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H8,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G8,#REF!,0),MATCH('SEM 4'!$I8,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F9,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H9,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G9,#REF!,0),MATCH('SEM 4'!$I9,#REF!,0)),\"\")","v":""}]
["Mardi ","2016-01-24",null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F10,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H10,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G10,#REF!,0),MATCH('SEM 4'!$I10,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F11,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H11,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G11,#REF!,0),MATCH('SEM 4'!$I11,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F12,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H12,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G12,#REF!,0),MATCH('SEM 4'!$I12,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F13,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H13,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G13,#REF!,0),MATCH('SEM 4'!$I13,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F14,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H14,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G14,#REF!,0),MATCH('SEM 4'!$I14,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F15,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H15,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G15,#REF!,0),MATCH('SEM 4'!$I15,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F16,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H16,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G16,#REF!,0),MATCH('SEM 4'!$I16,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F17,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H17,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G17,#REF!,0),MATCH('SEM 4'!$I17,#REF!,0)),\"\")","v":""}]
["Mercredi ","2016-01-25",null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F18,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H18,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G18,#REF!,0),MATCH('SEM 4'!$I18,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F19,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H19,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G19,#REF!,0),MATCH('SEM 4'!$I19,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F20,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H20,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G20,#REF!,0),MATCH('SEM 4'!$I20,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F21,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H21,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G21,#REF!,0),MATCH('SEM 4'!$I21,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F22,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H22,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G22,#REF!,0),MATCH('SEM 4'!$I22,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F23,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H23,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G23,#REF!,0),MATCH('SEM 4'!$I23,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F24,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H24,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G24,#REF!,0),MATCH('SEM 4'!$I24,#REF!,0)),\"\")","v":""}]
["Jeudi ",null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F25,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H25,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G25,#REF!,0),MATCH('SEM 4'!$I25,#REF!,0)),\"\")","v":""}]
["Jeudi ","2016-01-26",null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F26,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H26,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G26,#REF!,0),MATCH('SEM 4'!$I26,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F27,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H27,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G27,#REF!,0),MATCH('SEM 4'!$I27,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F28,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H28,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G28,#REF!,0),MATCH('SEM 4'!$I28,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F29,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H29,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G29,#REF!,0),MATCH('SEM 4'!$I29,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F30,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H30,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G30,#REF!,0),MATCH('SEM 4'!$I30,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F31,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H31,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G31,#REF!,0),MATCH('SEM 4'!$I31,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F32,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H32,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G32,#REF!,0),MATCH('SEM 4'!$I32,#REF!,0)),\"\")","v":""}]
["Vendredi ",null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F33,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H33,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G33,#REF!,0),MATCH('SEM 4'!$I33,#REF!,0)),\"\")","v":""}]
["Vendredi ","2016-01-27",null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F34,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H34,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G34,#REF!,0),MATCH('SEM 4'!$I34,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F35,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H35,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G35,#REF!,0),MATCH('SEM 4'!$I35,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F36,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H36,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G36,#REF!,0),MATCH('SEM 4'!$I36,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F37,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H37,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G37,#REF!,0),MATCH('SEM 4'!$I37,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F38,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H38,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G38,#REF!,0),MATCH('SEM 4'!$I38,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F39,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H39,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G39,#REF!,0),MATCH('SEM 4'!$I39,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F40,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H40,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G40,#REF!,0),MATCH('SEM 4'!$I40,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F41,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H41,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 4'!$G41,#REF!,0),MATCH('SEM 4'!$I41,#REF!,0)),\"\")","v":""}]

{"sheet":"SEM 5","index":4,"n_rows":41,"n_cols":33,"rows_kept":41,"cut":false,"hidden":false,"merged":[[25,0,32,0],[25,1,32,1],[33,0,40,0],[33,1,40,1],[1,0,8,0],[1,1,8,1],[9,0,16,0],[9,1,16,1],[17,0,24,0],[17,1,24,1]]}
["JOUR","DATE","CODE","Heure","Départ / Retour","Départ","ADRESSE 1","Arrivée","ADRESSE 2","Km Parcourus","Transporteur","Type de camions","Emission CO2","Facturable","N° bon\nV-HA","N° bon\nV-MAT","N° Facture transporteur","Nombre de transport","Facturé sur VMAT","Commande hors délai et/ou rajout","Tarif refacturé aux chantiers","Tarif transporteur",null,"Commentaires"]
["Lundi ","2016-01-30",null,"07H00","DEPART","ADOMA",{"$f":"+IFERROR(VLOOKUP(F2,#REF!,2),\"\")","v":""},"BLANCHE CASTILLE",{"$f":"+IFERROR(HLOOKUP(H2,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G2,#REF!,0),MATCH('SEM 5'!$I2,#REF!,0)),\"\")","v":""},"LOISEAU",null,null,"Facturable",null,null,null,4,"OUI","RAJOUT",null,null,null,null,null,"Transporteurs","Somme de Km Parcourus","Somme de Nombre de transport",null,"TOTAL refacturation par Transporteur","Facturé sur VMAT"]
[null,null,null,"07H30","DEPART","BLANCHE CASTILLE",{"$f":"+IFERROR(VLOOKUP(F3,#REF!,2),\"\")","v":""},"CIVAUX DUS ",{"$f":"+IFERROR(HLOOKUP(H3,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G3,#REF!,0),MATCH('SEM 5'!$I3,#REF!,0)),\"\")","v":""},"BRANGEON",null,null,"Facturable",null,null,null,1,"NON","RAJOUT",null,null,null,null,null,"BRANGEON",169,1,null,"Transporteurs","OUI","NON","Total général"]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F4,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H4,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G4,#REF!,0),MATCH('SEM 5'!$I4,#REF!,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOISEAU",106,4,null,"BRANGEON"]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F5,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H5,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G5,#REF!,0),MATCH('SEM 5'!$I5,#REF!,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total général",275,5,null,"LOISEAU"]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F6,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H6,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G6,#REF!,0),MATCH('SEM 5'!$I6,#REF!,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total général"]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F7,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H7,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G7,#REF!,0),MATCH('SEM 5'!$I7,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F8,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H8,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G8,#REF!,0),MATCH('SEM 5'!$I8,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F9,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H9,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G9,#REF!,0),MATCH('SEM 5'!$I9,#REF!,0)),\"\")","v":""}]
["Mardi ","2016-01-31",null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F10,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H10,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G10,#REF!,0),MATCH('SEM 5'!$I10,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F11,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H11,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G11,#REF!,0),MATCH('SEM 5'!$I11,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F12,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H12,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G12,#REF!,0),MATCH('SEM 5'!$I12,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F13,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H13,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G13,#REF!,0),MATCH('SEM 5'!$I13,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F14,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H14,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G14,#REF!,0),MATCH('SEM 5'!$I14,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F15,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H15,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G15,#REF!,0),MATCH('SEM 5'!$I15,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F16,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H16,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G16,#REF!,0),MATCH('SEM 5'!$I16,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F17,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H17,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G17,#REF!,0),MATCH('SEM 5'!$I17,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F18,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H18,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G18,#REF!,0),MATCH('SEM 5'!$I18,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F19,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H19,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G19,#REF!,0),MATCH('SEM 5'!$I19,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F20,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H20,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G20,#REF!,0),MATCH('SEM 5'!$I20,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F21,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H21,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G21,#REF!,0),MATCH('SEM 5'!$I21,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F22,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H22,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G22,#REF!,0),MATCH('SEM 5'!$I22,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F23,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H23,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G23,#REF!,0),MATCH('SEM 5'!$I23,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F24,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H24,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G24,#REF!,0),MATCH('SEM 5'!$I24,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F25,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H25,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G25,#REF!,0),MATCH('SEM 5'!$I25,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F26,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H26,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G26,#REF!,0),MATCH('SEM 5'!$I26,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F27,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H27,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G27,#REF!,0),MATCH('SEM 5'!$I27,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F28,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H28,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G28,#REF!,0),MATCH('SEM 5'!$I28,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F29,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H29,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G29,#REF!,0),MATCH('SEM 5'!$I29,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F30,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H30,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G30,#REF!,0),MATCH('SEM 5'!$I30,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F31,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H31,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G31,#REF!,0),MATCH('SEM 5'!$I31,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F32,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H32,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G32,#REF!,0),MATCH('SEM 5'!$I32,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F33,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H33,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G33,#REF!,0),MATCH('SEM 5'!$I33,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F34,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H34,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G34,#REF!,0),MATCH('SEM 5'!$I34,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F35,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H35,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G35,#REF!,0),MATCH('SEM 5'!$I35,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F36,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H36,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G36,#REF!,0),MATCH('SEM 5'!$I36,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F37,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H37,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G37,#REF!,0),MATCH('SEM 5'!$I37,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F38,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H38,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G38,#REF!,0),MATCH('SEM 5'!$I38,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F39,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H39,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G39,#REF!,0),MATCH('SEM 5'!$I39,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F40,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H40,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G40,#REF!,0),MATCH('SEM 5'!$I40,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F41,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H41,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5'!$G41,#REF!,0),MATCH('SEM 5'!$I41,#REF!,0)),\"\")","v":""}]

{"sheet":"JANVIER","index":5,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Transporteurs","Somme de Km Parcourus","Somme de Nombre de transport"]
["BRANGEON",169,1]

{"sheet":"SEM 5+","index":6,"n_rows":41,"n_cols":33,"rows_kept":41,"cut":false,"hidden":false,"merged":[[25,0,32,0],[25,1,32,1],[33,0,40,0],[33,1,40,1],[1,0,8,0],[1,1,8,1],[9,0,16,0],[9,1,16,1],[17,0,24,0],[17,1,24,1]]}
["JOUR","DATE","CODE","Heure","Départ / Retour","Départ","ADRESSE 1","Arrivée","ADRESSE 2","Km Parcourus","Transporteur","Type de camions","Emission CO2","Facturable","N° bon\nV-HA","N° bon\nV-MAT","N° Facture transporteur","Nombre de transport","Facturé sur VMAT","Commande hors délai et/ou rajout","Tarif refacturé aux chantiers","Tarif transporteur",null,"Commentaires"]
["Lundi ",null,null,"07H00","DEPART","ADOMA",{"$f":"+IFERROR(VLOOKUP(F2,#REF!,2),\"\")","v":""},"BLANCHE CASTILLE",{"$f":"+IFERROR(HLOOKUP(H2,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G2,#REF!,0),MATCH('SEM 5+'!$I2,#REF!,0)),\"\")","v":""},"LOISEAU",null,null,"Facturable",null,null,null,4,"OUI","RAJOUT",null,null,null,null,null,"Transporteurs","Somme de Km Parcourus","Somme de Nombre de transport",null,"TOTAL refacturation par Transporteur","Facturé sur VMAT"]
[null,null,null,"07H30","DEPART","BLANCHE CASTILLE",{"$f":"+IFERROR(VLOOKUP(F3,#REF!,2),\"\")","v":""},"CIVAUX DUS ",{"$f":"+IFERROR(HLOOKUP(H3,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G3,#REF!,0),MATCH('SEM 5+'!$I3,#REF!,0)),\"\")","v":""},"BRANGEON",null,null,"Facturable",null,null,null,1,"NON","RAJOUT",null,null,null,null,null,"BRANGEON",169,1,null,"Transporteurs","OUI","NON","Total général"]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F4,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H4,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G4,#REF!,0),MATCH('SEM 5+'!$I4,#REF!,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOISEAU",106,4,null,"BRANGEON"]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F5,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H5,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G5,#REF!,0),MATCH('SEM 5+'!$I5,#REF!,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total général",275,5,null,"LOISEAU"]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F6,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H6,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G6,#REF!,0),MATCH('SEM 5+'!$I6,#REF!,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total général"]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F7,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H7,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G7,#REF!,0),MATCH('SEM 5+'!$I7,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F8,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H8,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G8,#REF!,0),MATCH('SEM 5+'!$I8,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F9,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H9,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G9,#REF!,0),MATCH('SEM 5+'!$I9,#REF!,0)),\"\")","v":""}]
["Mardi ",null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F10,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H10,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G10,#REF!,0),MATCH('SEM 5+'!$I10,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F11,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H11,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G11,#REF!,0),MATCH('SEM 5+'!$I11,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F12,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H12,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G12,#REF!,0),MATCH('SEM 5+'!$I12,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F13,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H13,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G13,#REF!,0),MATCH('SEM 5+'!$I13,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F14,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H14,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G14,#REF!,0),MATCH('SEM 5+'!$I14,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F15,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H15,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G15,#REF!,0),MATCH('SEM 5+'!$I15,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F16,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H16,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G16,#REF!,0),MATCH('SEM 5+'!$I16,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F17,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H17,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G17,#REF!,0),MATCH('SEM 5+'!$I17,#REF!,0)),\"\")","v":""}]
["Mercredi","2017-02-01",null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F18,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H18,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G18,#REF!,0),MATCH('SEM 5+'!$I18,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F19,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H19,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G19,#REF!,0),MATCH('SEM 5+'!$I19,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F20,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H20,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G20,#REF!,0),MATCH('SEM 5+'!$I20,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F21,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H21,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G21,#REF!,0),MATCH('SEM 5+'!$I21,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F22,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H22,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G22,#REF!,0),MATCH('SEM 5+'!$I22,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F23,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H23,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G23,#REF!,0),MATCH('SEM 5+'!$I23,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F24,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H24,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G24,#REF!,0),MATCH('SEM 5+'!$I24,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F25,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H25,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G25,#REF!,0),MATCH('SEM 5+'!$I25,#REF!,0)),\"\")","v":""}]
["Jeudi","2017-02-02",null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F26,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H26,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G26,#REF!,0),MATCH('SEM 5+'!$I26,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F27,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H27,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G27,#REF!,0),MATCH('SEM 5+'!$I27,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F28,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H28,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G28,#REF!,0),MATCH('SEM 5+'!$I28,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F29,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H29,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G29,#REF!,0),MATCH('SEM 5+'!$I29,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F30,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H30,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G30,#REF!,0),MATCH('SEM 5+'!$I30,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F31,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H31,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G31,#REF!,0),MATCH('SEM 5+'!$I31,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F32,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H32,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G32,#REF!,0),MATCH('SEM 5+'!$I32,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F33,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H33,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G33,#REF!,0),MATCH('SEM 5+'!$I33,#REF!,0)),\"\")","v":""}]
["Vendredi","2017-02-03",null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F34,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H34,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G34,#REF!,0),MATCH('SEM 5+'!$I34,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F35,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H35,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G35,#REF!,0),MATCH('SEM 5+'!$I35,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F36,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H36,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G36,#REF!,0),MATCH('SEM 5+'!$I36,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F37,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H37,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G37,#REF!,0),MATCH('SEM 5+'!$I37,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F38,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H38,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G38,#REF!,0),MATCH('SEM 5+'!$I38,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F39,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H39,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G39,#REF!,0),MATCH('SEM 5+'!$I39,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F40,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H40,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G40,#REF!,0),MATCH('SEM 5+'!$I40,#REF!,0)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"+IFERROR(VLOOKUP(F41,#REF!,2),\"\")","v":""},null,{"$f":"+IFERROR(HLOOKUP(H41,#REF!,2),\"\")","v":""},{"$f":"+IFERROR(INDEX(#REF!,MATCH('SEM 5+'!$G41,#REF!,0),MATCH('SEM 5+'!$I41,#REF!,0)),\"\")","v":""}]