{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Tableau de suivi","Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Tableau de suivi","index":0,"n_rows":46,"n_cols":13,"rows_kept":46,"cut":false,"hidden":false,"merged":[[2,8,2,12],[3,9,3,11],[44,1,44,4],[11,1,12,1],[13,8,13,11],[16,8,16,11],[17,8,17,11]]}
[]
[]
[null,null,null,null,null,null,null,null,"Barème compensation 2020"]
[null,null,null,null,null,null,null,"Chevaux fiscaux","Jusqu’à 5 000 km","De 5 001 km à 20 000 km",null,null,"Au-delà de 20 000 km"]
[null,"Entreprise",null,null,null,null,null,"3 CV et moins",0.45600000000000002,0.27300000000000002,"+",915,0.318]
[null,"Nom",null,null,null,null,null,"4 CV",0.52300000000000002,0.29399999999999998,"+",1147,0.35199999999999998]
[null,"Type de véhicule","7 CV et plus",null,null,null,null,"5 CV ",0.54800000000000004,0.308,"+",1200,0.36799999999999999]
[null,"Année",2021,null,null,null,null,"6 CV",0.57399999999999995,0.32300000000000001,"+",1256,0.38600000000000001]
[null,null,null,null,null,null,null,"7 CV et plus",0.60099999999999998,0.34,"+",1301,0.40500000000000003]
[]
[]
[null,"Date","Trajet",null,"Commentaire"]
[null,null,"(De où à où)",null,"(Ex: Client, Projet, Réunion…)","Distance"]
[null,"2021-04-01","Paris","Berck",null,{"$f":"IFERROR(VALUE(SUBSTITUTE(LEFT(Data!C2,FIND(\" km\",Data!C2)),\",\",\"\")),\"\")","v":228}]
[null,"2021-04-02","Paris","Berck",null,{"$f":"IFERROR(VALUE(SUBSTITUTE(LEFT(Data!C3,FIND(\" km\",Data!C3)),\",\",\"\")),\"\")","v":228}]
[null,"2021-04-03","PARIS","Vincennes",null,{"$f":"IFERROR(VALUE(SUBSTITUTE(LEFT(Data!C4,FIND(\" km\",Data!C4)),\",\",\"\")),\"\")","v":8}]
[null,"2021-04-04","paris","choisy le roi",null,{"$f":"IFERROR(VALUE(SUBSTITUTE(LEFT(Data!C5,FIND(\" km\",Data!C5)),\",\",\"\")),\"\")","v":16}]
[null,"2021-04-05",null,null,null,{"$f":"IFERROR(VALUE(SUBSTITUTE(LEFT(Data!C6,FIND(\" km\",Data!C6)),\",\",\"\")),\"\")","v":""}]
[null,"2021-04-06",null,null,null,{"$f":"IFERROR(VALUE(SUBSTITUTE(LEFT(Data!C7,FIND(\" km\",Data!C7)),\",\",\"\")),\"\")","v":""}]
[null,"2021-04-07",null,null,null,{"$f":"IFERROR(VALUE(SUBSTITUTE(LEFT(Data!C8,FIND(\" km\",Data!C8)),\",\",\"\")),\"\")","v":""}]
[null,"2021-04-08",null,null,null,{"$f":"IFERROR(VALUE(SUBSTITUTE(LEFT(Data!C9,FIND(\" km\",Data!C9)),\",\",\"\")),\"\")","v":""}]
[null,"2021-04-09",null,null,null,{"$f":"IFERROR(VALUE(SUBSTITUTE(LEFT(Data!C10,FIND(\" km\",Data!C10)),\",\",\"\")),\"\")","v":""}]
[null,"2021-04-10",null,null,null,{"$f":"IFERROR(VALUE(SUBSTITUTE(LEFT(Data!C11,FIND(\" km\",Data!C11)),\",\",\"\")),\"\")","v":""}]
[null,"2021-04-11",null,null,null,{"$f":"IFERROR(VALUE(SUBSTITUTE(LEFT(Data!C12,FIND(\" km\",Data!C12)),\",\",\"\")),\"\")","v":""}]
[null,"2021-04-12",null,null,null,{"$f":"IFERROR(VALUE(SUBSTITUTE(LEFT(Data!C13,FIND(\" km\",Data!C13)),\",\",\"\")),\"\")","v":""}]
[null,"2021-04-13",null,null,null,{"$f":"IFERROR(VALUE(SUBSTITUTE(LEFT(Data!C14,FIND(\" km\",Data!C14)),\",\",\"\")),\"\")","v":""}]
[null,"2021-04-14",null,null,null,{"$f":"IFERROR(VALUE(SUBSTITUTE(LEFT(Data!C15,FIND(\" km\",Data!C15)),\",\",\"\")),\"\")","v":""}]
[null,"2021-04-15",null,null,null,{"$f":"IFERROR(VALUE(SUBSTITUTE(LEFT(Data!C16,FIND(\" km\",Data!C16)),\",\",\"\")),\"\")","v":""}]
[null,"2021-04-16",null,null,null,{"$f":"IFERROR(VALUE(SUBSTITUTE(LEFT(Data!C17,FIND(\" km\",Data!C17)),\",\",\"\")),\"\")","v":""}]
[null,"2021-04-17",null,null,null,{"$f":"IFERROR(VALUE(SUBSTITUTE(LEFT(Data!C18,FIND(\" km\",Data!C18)),\",\",\"\")),\"\")","v":""}]
[null,"2021-04-18",null,null,null,{"$f":"IFERROR(VALUE(SUBSTITUTE(LEFT(Data!C19,FIND(\" km\",Data!C19)),\",\",\"\")),\"\")","v":""}]
[null,"2021-04-19","paris ","choisy le roi","mr matthieu nexity",{"$f":"IFERROR(VALUE(SUBSTITUTE(LEFT(Data!C20,FIND(\" km\",Data!C20)),\",\",\"\")),\"\")","v":16}]
[null,"2021-04-19","PARIS","Vincennes","Mr Yuri",{"$f":"IFERROR(VALUE(SUBSTITUTE(LEFT(Data!C21,FIND(\" km\",Data!C21)),\",\",\"\")),\"\")","v":8}]
[null,"2021-04-21",null,null,null,{"$f":"IFERROR(VALUE(SUBSTITUTE(LEFT(Data!C22,FIND(\" km\",Data!C22)),\",\",\"\")),\"\")","v":""}]
[null,"2021-04-22",null,null,null,{"$f":"IFERROR(VALUE(SUBSTITUTE(LEFT(Data!C23,FIND(\" km\",Data!C23)),\",\",\"\")),\"\")","v":""}]
[null,"2021-04-23",null,null,null,{"$f":"IFERROR(VALUE(SUBSTITUTE(LEFT(Data!C24,FIND(\" km\",Data!C24)),\",\",\"\")),\"\")","v":""}]
[null,"2021-04-24",null,null,null,{"$f":"IFERROR(VALUE(SUBSTITUTE(LEFT(Data!C25,FIND(\" km\",Data!C25)),\",\",\"\")),\"\")","v":""}]
[null,"2021-04-25",null,null,null,{"$f":"IFERROR(VALUE(SUBSTITUTE(LEFT(Data!C26,FIND(\" km\",Data!C26)),\",\",\"\")),\"\")","v":""}]
[null,"2021-04-26",null,null,null,{"$f":"IFERROR(VALUE(SUBSTITUTE(LEFT(Data!C27,FIND(\" km\",Data!C27)),\",\",\"\")),\"\")","v":""}]
[null,"2021-04-27",null,null,null,{"$f":"IFERROR(VALUE(SUBSTITUTE(LEFT(Data!C28,FIND(\" km\",Data!C28)),\",\",\"\")),\"\")","v":""}]
[null,"2021-04-28",null,null,null,{"$f":"IFERROR(VALUE(SUBSTITUTE(LEFT(Data!C29,FIND(\" km\",Data!C29)),\",\",\"\")),\"\")","v":""}]
[null,"2021-04-29",null,null,null,{"$f":"IFERROR(VALUE(SUBSTITUTE(LEFT(Data!C30,FIND(\" km\",Data!C30)),\",\",\"\")),\"\")","v":""}]
[null,"2021-04-30",null,null,null,{"$f":"IFERROR(VALUE(SUBSTITUTE(LEFT(Data!C31,FIND(\" km\",Data!C31)),\",\",\"\")),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VALUE(SUBSTITUTE(LEFT(Data!C32,FIND(\" km\",Data!C32)),\",\",\"\")),\"\")","v":""}]
[null,"Total",null,null,null,{"$f":"SUM(F14:F44)","v":504}]
[null,null,null,null,null,{"$f":"IF(F45=0,\"\",IF(F45>=20000,F45*VLOOKUP(C7,H5:M9,6,0),IF(F45>5000,F45*VLOOKUP(C7,H5:M9,3,0)+VLOOKUP(C7,H5:M9,5,0),F45*VLOOKUP(C7,H5:M9,2,0))))","v":302.904}]

{"sheet":"Data","index":1,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Ville de \ndépart","Ville de destination","Distance"]
[{"$f":"IF('Tableau de suivi'!C14=\"\",\"\",'Tableau de suivi'!C14)","v":"Paris"},{"$f":"IF('Tableau de suivi'!D14=\"\",\"\",'Tableau de suivi'!D14)","v":"Berck"},"228 km"]
[{"$f":"IF('Tableau de suivi'!C15=\"\",\"\",'Tableau de suivi'!C15)","v":"Paris"},{"$f":"IF('Tableau de suivi'!D15=\"\",\"\",'Tableau de suivi'!D15)","v":"Berck"},"228 km"]
[{"$f":"IF('Tableau de suivi'!C16=\"\",\"\",'Tableau de suivi'!C16)","v":"PARIS"},{"$f":"IF('Tableau de suivi'!D16=\"\",\"\",'Tableau de suivi'!D16)","v":"Vincennes"},"8 km"]
[{"$f":"IF('Tableau de suivi'!C17=\"\",\"\",'Tableau de suivi'!C17)","v":"paris"},{"$f":"IF('Tableau de suivi'!D17=\"\",\"\",'Tableau de suivi'!D17)","v":"choisy le roi"},"16 km"]
[{"$f":"IF('Tableau de suivi'!C18=\"\",\"\",'Tableau de suivi'!C18)","v":""},{"$f":"IF('Tableau de suivi'!D18=\"\",\"\",'Tableau de suivi'!D18)","v":""}]
[{"$f":"IF('Tableau de suivi'!C19=\"\",\"\",'Tableau de suivi'!C19)","v":""},{"$f":"IF('Tableau de suivi'!D19=\"\",\"\",'Tableau de suivi'!D19)","v":""}]
[{"$f":"IF('Tableau de suivi'!C20=\"\",\"\",'Tableau de suivi'!C20)","v":""},{"$f":"IF('Tableau de suivi'!D20=\"\",\"\",'Tableau de suivi'!D20)","v":""}]
[{"$f":"IF('Tableau de suivi'!C21=\"\",\"\",'Tableau de suivi'!C21)","v":""},{"$f":"IF('Tableau de suivi'!D21=\"\",\"\",'Tableau de suivi'!D21)","v":""}]
[{"$f":"IF('Tableau de suivi'!C22=\"\",\"\",'Tableau de suivi'!C22)","v":""},{"$f":"IF('Tableau de suivi'!D22=\"\",\"\",'Tableau de suivi'!D22)","v":""}]
[{"$f":"IF('Tableau de suivi'!C23=\"\",\"\",'Tableau de suivi'!C23)","v":""},{"$f":"IF('Tableau de suivi'!D23=\"\",\"\",'Tableau de suivi'!D23)","v":""}]
[{"$f":"IF('Tableau de suivi'!C24=\"\",\"\",'Tableau de suivi'!C24)","v":""},{"$f":"IF('Tableau de suivi'!D24=\"\",\"\",'Tableau de suivi'!D24)","v":""}]
[{"$f":"IF('Tableau de suivi'!C25=\"\",\"\",'Tableau de suivi'!C25)","v":""},{"$f":"IF('Tableau de suivi'!D25=\"\",\"\",'Tableau de suivi'!D25)","v":""}]
[{"$f":"IF('Tableau de suivi'!C26=\"\",\"\",'Tableau de suivi'!C26)","v":""},{"$f":"IF('Tableau de suivi'!D26=\"\",\"\",'Tableau de suivi'!D26)","v":""}]
[{"$f":"IF('Tableau de suivi'!C27=\"\",\"\",'Tableau de suivi'!C27)","v":""},{"$f":"IF('Tableau de suivi'!D27=\"\",\"\",'Tableau de suivi'!D27)","v":""}]
[{"$f":"IF('Tableau de suivi'!C28=\"\",\"\",'Tableau de suivi'!C28)","v":""},{"$f":"IF('Tableau de suivi'!D28=\"\",\"\",'Tableau de suivi'!D28)","v":""}]
[{"$f":"IF('Tableau de suivi'!C29=\"\",\"\",'Tableau de suivi'!C29)","v":""},{"$f":"IF('Tableau de suivi'!D29=\"\",\"\",'Tableau de suivi'!D29)","v":""}]
[{"$f":"IF('Tableau de suivi'!C30=\"\",\"\",'Tableau de suivi'!C30)","v":""},{"$f":"IF('Tableau de suivi'!D30=\"\",\"\",'Tableau de suivi'!D30)","v":""}]
[{"$f":"IF('Tableau de suivi'!C31=\"\",\"\",'Tableau de suivi'!C31)","v":""},{"$f":"IF('Tableau de suivi'!D31=\"\",\"\",'Tableau de suivi'!D31)","v":""}]
[{"$f":"IF('Tableau de suivi'!C32=\"\",\"\",'Tableau de suivi'!C32)","v":"paris "},{"$f":"IF('Tableau de suivi'!D32=\"\",\"\",'Tableau de suivi'!D32)","v":"choisy le roi"},"16 km"]
[{"$f":"IF('Tableau de suivi'!C33=\"\",\"\",'Tableau de suivi'!C33)","v":"PARIS"},{"$f":"IF('Tableau de suivi'!D33=\"\",\"\",'Tableau de suivi'!D33)","v":"Vincennes"},"8 km"]
[{"$f":"IF('Tableau de suivi'!C34=\"\",\"\",'Tableau de suivi'!C34)","v":""},{"$f":"IF('Tableau de suivi'!D34=\"\",\"\",'Tableau de suivi'!D34)","v":""}]
[{"$f":"IF('Tableau de suivi'!C35=\"\",\"\",'Tableau de suivi'!C35)","v":""},{"$f":"IF('Tableau de suivi'!D35=\"\",\"\",'Tableau de suivi'!D35)","v":""}]
[{"$f":"IF('Tableau de suivi'!C36=\"\",\"\",'Tableau de suivi'!C36)","v":""},{"$f":"IF('Tableau de suivi'!D36=\"\",\"\",'Tableau de suivi'!D36)","v":""}]
[{"$f":"IF('Tableau de suivi'!C37=\"\",\"\",'Tableau de suivi'!C37)","v":""},{"$f":"IF('Tableau de suivi'!D37=\"\",\"\",'Tableau de suivi'!D37)","v":""}]
[{"$f":"IF('Tableau de suivi'!C38=\"\",\"\",'Tableau de suivi'!C38)","v":""},{"$f":"IF('Tableau de suivi'!D38=\"\",\"\",'Tableau de suivi'!D38)","v":""}]
[{"$f":"IF('Tableau de suivi'!C39=\"\",\"\",'Tableau de suivi'!C39)","v":""},{"$f":"IF('Tableau de suivi'!D39=\"\",\"\",'Tableau de suivi'!D39)","v":""}]
[{"$f":"IF('Tableau de suivi'!C40=\"\",\"\",'Tableau de suivi'!C40)","v":""},{"$f":"IF('Tableau de suivi'!D40=\"\",\"\",'Tableau de suivi'!D40)","v":""}]
[{"$f":"IF('Tableau de suivi'!C41=\"\",\"\",'Tableau de suivi'!C41)","v":""},{"$f":"IF('Tableau de suivi'!D41=\"\",\"\",'Tableau de suivi'!D41)","v":""}]
[{"$f":"IF('Tableau de suivi'!C42=\"\",\"\",'Tableau de suivi'!C42)","v":""},{"$f":"IF('Tableau de suivi'!D42=\"\",\"\",'Tableau de suivi'!D42)","v":""}]
[{"$f":"IF('Tableau de suivi'!C43=\"\",\"\",'Tableau de suivi'!C43)","v":""},{"$f":"IF('Tableau de suivi'!D43=\"\",\"\",'Tableau de suivi'!D43)","v":""}]
[{"$f":"IF('Tableau de suivi'!C44=\"\",\"\",'Tableau de suivi'!C44)","v":""},{"$f":"IF('Tableau de suivi'!D44=\"\",\"\",'Tableau de suivi'!D44)","v":""}]