{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Véhicules+Passage MAL","Resumé Lavage","Plan Remisage"],"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":"Véhicules+Passage MAL","index":0,"n_rows":31,"n_cols":12,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,11,0,13]]}
[null,"CARROS.","GABARIT","NUMERO DE PARC ANCIEN","NUMERO DE PARC IDFM","LIGNE","MARQUE","MODELE","IMMATRICULATION","PASSAGE MAL",null,"Double clic dans \"Passage MAL\" pour date du jour"]
[1,"BUS","STD",211105,211105,null,"IVECO","URBANWAY 12 GNV","GB198QW","2022-07-14"]
[2,"BUS","STD",211106,211106,null,"IVECO","URBANWAY 12 GNV","GB328QW","2022-07-14"]
[3,"BUS","STD",211107,211107,null,"IVECO","URBANWAY 12 GNV","GB866RS","2022-07-14"]
[4,"BUS","STD",211108,211108,null,"IVECO","URBANWAY 12 GNV","GB011RT","2022-07-14"]
[5,"BUS","STD",211109,211109,null,"IVECO","URBANWAY 12 GNV","GB679RS","2022-07-14"]
[6,"BUS","STD",211110,211110,null,"IVECO","URBANWAY 12 GNV","GB581RS","2022-07-14"]
[7,"BUS","MDB",213010,213010,null,"HEULIEZ","GX 137","GD769PM","2022-07-14"]
[8,"BUS","MDB",213011,213011,null,"HEULIEZ","GX 137","GD373PP","2022-07-14"]
[9,"BUS","MDB",213012,213012,null,"HEULIEZ","GX 137","GD703PP","2022-07-14"]
[10,"BUS","MDB",213013,213013,null,"HEULIEZ","GX 137","GD803PP","2022-07-14"]
[11,"BUS","MDB",213014,213014,null,"HEULIEZ","GX 137","GD883PP","2022-07-14"]
[12,"BUS","STD",664,221059,null,"HEULIEZ","GX 327","BD223FB","2022-07-14"]
[13,"BUS","STD",665,221060,null,"HEULIEZ","GX 327","BS159DK","2022-07-14"]
[14,"BUS","STD",666,221061,null,"HEULIEZ","GX 327","CJ289DK","2022-07-14"]
[15,"BUS","STD",670,221062,null,"HEULIEZ","GX 327","DB389PN","2022-07-14"]
[16,"BUS","STD",671,221063,null,"HEULIEZ","GX 337","DH621PL","2022-07-14"]
[17,"BUS","STD",672,221064,null,"HEULIEZ","GX 337","DH733PL","2022-07-14"]
[18,"BUS","STD",673,221065,null,"HEULIEZ","GX 337","DH491PL","2022-07-14"]
[19,"BUS","MDB",662,223001,null,"HEULIEZ","GX 127","AW522TT","2022-07-14"]
[20,"BUS","MDB",663,223002,null,"HEULIEZ","GX 127","AW980TT","2022-07-14"]
[21,"BUS","MDB",667,223003,null,"HEULIEZ","GX 127","CJ267ER","2022-07-14"]
[22,"BUS","MDB",668,223004,null,"HEULIEZ","GX 127","DA165SR","2022-07-14"]
[23,"BUS","MDB",669,223005,null,"HEULIEZ","GX 127","DA700SQ","2022-07-14"]
[24,"BUS","MDB",674,223006,null,"HEULIEZ","GX 137","DT795KJ","2022-07-14"]
[25,"BUS","MDB",675,223007,null,"HEULIEZ","GX 137","DT917KJ","2022-07-14"]
[26,"BUS","MDB",676,223008,null,"HEULIEZ","GX 137","DT558KJ","2022-07-14"]
[27,"BUS","MDB",705,223009,null,"HEULIEZ","GX 137 L","FL549TN","2022-07-14"]
[28,"BUS","MDB",708,223010,null,"HEULIEZ","GX 137 L","FS472GD","2022-07-14"]
[29,"BUS","MDB",709,223011,null,"HEULIEZ","GX 137 L","FS558GD","2022-07-14"]
[30,"BUS","MDB",710,223012,null,"HEULIEZ","GX 137 L","FS697GD","2022-07-14"]

{"sheet":"Resumé Lavage","index":1,"n_rows":31,"n_cols":15,"rows_kept":31,"cut":false,"hidden":false,"merged":[[4,4,6,4],[4,5,6,5],[4,6,6,6],[0,7,1,11],[4,0,6,0],[4,1,6,1],[4,2,6,2],[0,2,0,3],[1,0,1,3],[2,0,2,3]]}
[null,null,"Date du jour :",null,{"$f":"TODAY()","v":"2022-07-15"},null,null,"Double cliquer sur un numéro de parc pour réinitialiser la date de dernier passage à la date du jour.",null,null,null,null,{"$f":"IF('Véhicules+Passage MAL'!E1=\"\",\"\",'Véhicules+Passage MAL'!E1)","v":"NUMERO DE PARC IDFM"},{"$f":"IF('Véhicules+Passage MAL'!J1=\"\",\"\",'Véhicules+Passage MAL'!J1)","v":"PASSAGE MAL"},"Véhicule sélectionné:"]
["Nombre de jour avant orange :",null,null,null,3,null,null,null,null,null,null,null,211105,{"$f":"IF('Véhicules+Passage MAL'!J2=\"\",\"\",'Véhicules+Passage MAL'!J2)","v":"2022-07-14"},211105]
["Nombre de jour avant rouge :",null,null,null,7,null,null,null,null,null,null,null,211106,{"$f":"IF('Véhicules+Passage MAL'!J3=\"\",\"\",'Véhicules+Passage MAL'!J3)","v":"2022-07-14"},"Véhicule existant:"]
[null,null,null,null,null,null,null,null,null,null,null,null,211107,{"$f":"IF('Véhicules+Passage MAL'!J4=\"\",\"\",'Véhicules+Passage MAL'!J4)","v":"2022-07-14"},{"$f":"IFERROR(VLOOKUP(O2,M2:M31,1,FALSE),\"ERREUR\")","v":211105}]
["N° de parc","Dernier passage","Nbre de jour sans lavage",null,"N° de parc","Dernier passage","Nbre de jour sans lavage",null,null,null,null,null,211108,{"$f":"IF('Véhicules+Passage MAL'!J5=\"\",\"\",'Véhicules+Passage MAL'!J5)","v":"2022-07-14"}]
[null,null,null,null,null,null,null,null,null,null,null,null,211109,{"$f":"IF('Véhicules+Passage MAL'!J6=\"\",\"\",'Véhicules+Passage MAL'!J6)","v":"2022-07-14"}]
[null,null,null,null,null,null,null,null,null,null,null,null,211110,{"$f":"IF('Véhicules+Passage MAL'!J7=\"\",\"\",'Véhicules+Passage MAL'!J7)","v":"2022-07-14"}]
[{"$f":"M2","v":211105},"2022-07-14",{"$f":"IFERROR($E$1-B8,\"\")","v":1},null,{"$f":"M17","v":221063},"2022-07-14",{"$f":"IFERROR($E$1-F8,\"\")","v":1},null,null,null,null,null,213010,{"$f":"IF('Véhicules+Passage MAL'!J8=\"\",\"\",'Véhicules+Passage MAL'!J8)","v":"2022-07-14"}]
[{"$f":"M3","v":211106},"2022-07-14",{"$f":"IFERROR($E$1-B9,\"\")","v":1},null,{"$f":"M18","v":221064},"2022-07-14",{"$f":"IFERROR($E$1-F9,\"\")","v":1},null,null,null,null,null,213011,{"$f":"IF('Véhicules+Passage MAL'!J9=\"\",\"\",'Véhicules+Passage MAL'!J9)","v":"2022-07-14"}]
[{"$f":"M4","v":211107},"2022-07-14",{"$f":"IFERROR($E$1-B10,\"\")","v":1},null,{"$f":"M19","v":221065},"2022-07-14",{"$f":"IFERROR($E$1-F10,\"\")","v":1},null,null,null,null,null,213012,{"$f":"IF('Véhicules+Passage MAL'!J10=\"\",\"\",'Véhicules+Passage MAL'!J10)","v":"2022-07-14"}]
[{"$f":"M5","v":211108},"2022-07-14",{"$f":"IFERROR($E$1-B11,\"\")","v":1},null,223001,"2022-07-14",{"$f":"IFERROR($E$1-F11,\"\")","v":1},null,null,null,null,null,213013,{"$f":"IF('Véhicules+Passage MAL'!J11=\"\",\"\",'Véhicules+Passage MAL'!J11)","v":"2022-07-14"}]
[211109,"2022-07-14",1,null,223002,"2022-07-14",1,null,null,null,null,null,213014,{"$f":"IF('Véhicules+Passage MAL'!J12=\"\",\"\",'Véhicules+Passage MAL'!J12)","v":"2022-07-14"}]
[211110,"2022-07-14",1,null,223003,"2022-07-14",1,null,null,null,null,null,221059,{"$f":"IF('Véhicules+Passage MAL'!J13=\"\",\"\",'Véhicules+Passage MAL'!J13)","v":"2022-07-14"}]
[213010,"2022-07-14",1,null,223004,"2022-07-14",1,null,null,null,null,null,221060,{"$f":"IF('Véhicules+Passage MAL'!J14=\"\",\"\",'Véhicules+Passage MAL'!J14)","v":"2022-07-14"}]
[213011,"2022-07-14",1,null,223005,"2022-07-14",1,null,null,null,null,null,221061,{"$f":"IF('Véhicules+Passage MAL'!J15=\"\",\"\",'Véhicules+Passage MAL'!J15)","v":"2022-07-14"}]
[213012,"2022-07-14",1,null,223006,"2022-07-14",1,null,null,null,null,null,221062,{"$f":"IF('Véhicules+Passage MAL'!J16=\"\",\"\",'Véhicules+Passage MAL'!J16)","v":"2022-07-14"}]
[213013,"2022-07-14",1,null,223007,"2022-07-14",1,null,null,null,null,null,221063,{"$f":"IF('Véhicules+Passage MAL'!J17=\"\",\"\",'Véhicules+Passage MAL'!J17)","v":"2022-07-14"}]
[213014,"2022-07-14",1,null,223008,"2022-07-14",1,null,null,null,null,null,221064,{"$f":"IF('Véhicules+Passage MAL'!J18=\"\",\"\",'Véhicules+Passage MAL'!J18)","v":"2022-07-14"}]
[221059,"2022-07-14",1,null,223009,"2022-07-14",1,null,null,null,null,null,221065,{"$f":"IF('Véhicules+Passage MAL'!J19=\"\",\"\",'Véhicules+Passage MAL'!J19)","v":"2022-07-14"}]
[221060,"2022-07-14",1,null,223010,"2022-07-14",1,null,null,null,null,null,223001,{"$f":"IF('Véhicules+Passage MAL'!J20=\"\",\"\",'Véhicules+Passage MAL'!J20)","v":"2022-07-14"}]
[{"$f":"M15","v":221061},"2022-07-14",1,null,223011,"2022-07-14",1,null,null,null,null,null,223002,{"$f":"IF('Véhicules+Passage MAL'!J21=\"\",\"\",'Véhicules+Passage MAL'!J21)","v":"2022-07-14"}]
[{"$f":"M16","v":221062},"2022-07-14",{"$f":"IFERROR($E$1-B22,\"\")","v":1},null,223012,"2022-07-14",{"$f":"IFERROR($E$1-F22,\"\")","v":1},null,null,null,null,null,223003,{"$f":"IF('Véhicules+Passage MAL'!J22=\"\",\"\",'Véhicules+Passage MAL'!J22)","v":"2022-07-14"}]
[null,null,null,null,null,null,null,null,null,null,null,null,223004,{"$f":"IF('Véhicules+Passage MAL'!J23=\"\",\"\",'Véhicules+Passage MAL'!J23)","v":"2022-07-14"}]
[null,null,null,null,null,null,null,null,null,null,null,null,223005,{"$f":"IF('Véhicules+Passage MAL'!J24=\"\",\"\",'Véhicules+Passage MAL'!J24)","v":"2022-07-14"}]
[null,null,null,null,null,null,null,null,null,null,null,null,223006,{"$f":"IF('Véhicules+Passage MAL'!J25=\"\",\"\",'Véhicules+Passage MAL'!J25)","v":"2022-07-14"}]
[null,null,null,null,null,null,null,null,null,null,null,null,223007,{"$f":"IF('Véhicules+Passage MAL'!J26=\"\",\"\",'Véhicules+Passage MAL'!J26)","v":"2022-07-14"}]
[null,null,null,null,null,null,null,null,null,null,null,null,223008,{"$f":"IF('Véhicules+Passage MAL'!J27=\"\",\"\",'Véhicules+Passage MAL'!J27)","v":"2022-07-14"}]
[null,null,null,null,null,null,null,null,null,null,null,null,223009,{"$f":"IF('Véhicules+Passage MAL'!J28=\"\",\"\",'Véhicules+Passage MAL'!J28)","v":"2022-07-14"}]
[null,null,null,null,null,null,null,null,null,null,null,null,223010,{"$f":"IF('Véhicules+Passage MAL'!J29=\"\",\"\",'Véhicules+Passage MAL'!J29)","v":"2022-07-14"}]
[null,null,null,null,null,null,null,null,null,null,null,null,223011,{"$f":"IF('Véhicules+Passage MAL'!J30=\"\",\"\",'Véhicules+Passage MAL'!J30)","v":"2022-07-14"}]
[null,null,null,null,null,null,null,null,null,null,null,null,223012,{"$f":"IF('Véhicules+Passage MAL'!J31=\"\",\"\",'Véhicules+Passage MAL'!J31)","v":"2022-07-14"}]

{"sheet":"Plan Remisage","index":2,"n_rows":35,"n_cols":35,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,2,3,6],[1,13,1,20],[1,27,1,30],[1,22,1,26],[2,22,2,26],[3,22,3,26],[2,7,3,12],[2,13,3,20],[2,27,2,30],[3,27,3,30],[6,4,6,6],[6,10,6,12],[8,4,8,6],[10,4,10,6],[12,4,12,6],[26,4,26,6],[28,4,28,6],[30,4,30,6],[32,4,32,6],[14,4,14,6],[16,4,16,6],[18,4,18,6],[20,4,20,6],[22,4,22,6],[34,4,34,6],[8,10,8,12],[10,10,10,12],[12,10,12,12],[14,10,14,12],[16,10,16,12],[18,10,18,12],[20,10,20,12],[22,10,22,12],[24,10,24,12],[26,10,26,12],[28,10,28,12],[30,10,30,12],[32,10,32,12],[34,10,34,12],[24,4,24,6]]}
[]
[null,null,"RECHERCHE",null,null,null,null,"N° de parc :",null,null,null,null,null,"Place de garage :",null,null,null,null,null,null,null,null,"Véhicule diponible",null,null,null,null,null,null,null,null,null,null,null,211105]
[null,null,null,null,null,null,null,211110,null,null,null,null,null,{"$f":"IFERROR(IFERROR(INDEX(C7:E35,MATCH(H3,E7:E35,0),1),INDEX(I7:I35,MATCH(H3,K7:K35,0),1)),\"Absent\")","v":"Absent"},null,null,null,null,null,null,null,null,"Réservation maintenance",null,null,null,null,null,null,null,null,null,null,null,211106]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Véhicule immobilisé",null,null,null,null,null,null,null,null,null,null,null,211107]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,211108]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,211109]
[null,null,"P1",null,213011,null,null,null,"P16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,211110]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,213010]
[null,null,"P2",null,null,null,null,null,"P17",null,223008,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,213011]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,213012]
[null,null,"P3",null,211105,null,null,null,"P18",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,213013]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,213014]
[null,null,"P4",null,null,null,null,null,"P19",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,221059]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,221060]
[null,null,"P5",null,null,null,null,null,"P20",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,221061]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,221062]
[null,null,"P6",null,null,null,null,null,"P21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,221063]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,221064]
[null,null,"P7",null,null,null,null,null,"P22",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,221065]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,223001]
[null,null,"P8",null,null,null,null,null,"P23",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,223002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,223003]
[null,null,"P9",null,null,null,null,null,"P24",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,223004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,223005]
[null,null,"P10",null,null,null,null,null,"P25",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,223006]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,223007]
[null,null,"P11",null,null,null,null,null,"P26",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,223008]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,223009]
[null,null,"P12",null,null,null,null,null,"P27",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,223010]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,223011]
[null,null,"P13",null,null,null,null,null,"P28",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,223012]
[]
[null,null,"P14",null,null,null,null,null,"P29"]
[]
[null,null,"P15",null,null,null,null,null,"P30"]