{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Tableau","Fiche"],"not_rendered":{"images":1,"macros":1,"defined_names":2,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Tableau","index":0,"n_rows":13,"n_cols":17,"rows_kept":13}
["Site","Immatriculation","Lib","Entretien à réaliser","Date prév. proch ent","DATE RDV","OBSERVATION","Etat","Fiche d'entretien"]
["CARCASSONNE","1234AA11","VOLKSWAGEN TRANSPORTER 4X4","CTRL REMORQUE","2015-05-03",null,null,{"$f":"IF(E2>=TODAY(),\"A réaliser\",IF(E2>=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())-15),\"Retard ≤ 15j\",\"Retard > 15j\"))","v":"Retard ≤ 15j"},{"$f":"CONCATENATE($Q$2,\"\",B2)","v":"Visualer la fiche du 1234AA11"},{"$nulls":7},"Visualer la fiche du "]
["PARIS","1234AA12","RENAULT_KANGOO","CONTRÔLE TECHNIQUE","2015-05-25",null,null,"A réaliser",{"$f":"CONCATENATE($Q$2,\"\",B3)","v":"Visualer la fiche du 1234AA12"}]
["MONTPELIER","1234AA13","RENAULT_MASTER","ENTRETIEN REVISION","2015-04-19",null,null,"Retard ≤ 15j","Visualer la fiche du 1234AA13"]
["LYON","1234AA14","PEUGEOT_BOXER","ENTRETIEN REVISION","2015-03-19","2015-03-22","Attente d'attestation","Retard > 15j","Visualer la fiche du 1234AA14"]
["PERPIGNAN","1234AA15","CITROEN_BERLINGO","COURROIE DE DISTRIBUTION","2015-04-12",null,null,"Retard > 15j","Visualer la fiche du 1234AA15"]
["DIJON","1234AA16","RENAULT_CLIO","COURROIE DE DISTRIBUTION","2015-04-23",null,null,"Retard ≤ 15j","Visualer la fiche du 1234AA16"]
["BESANCON","1234AA17","PEUGEOT_PARTNER","CONTROLE POLLUTION","2015-05-18",null,null,{"$f":"IF(E8>=TODAY(),\"A réaliser\",IF(E8>=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())-15),\"Retard ≤ 15j\",\"Retard > 15j\"))","v":"A réaliser"},"Visualer la fiche du 1234AA17"]
["MACON","1234AA18","PEUGEOT_EXPERT","ENTRETIEN REVISION","2015-03-03",null,null,{"$f":"IF(E9>=TODAY(),\"A réaliser\",IF(E9>=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())-15),\"Retard ≤ 15j\",\"Retard > 15j\"))","v":"Retard > 15j"},"Visualer la fiche du 1234AA18"]
["MULHOUSE","1234AA19","CITROEN_JUMPER","CONTROLE POLLUTION","2015-05-16",null,null,{"$f":"IF(E10>=TODAY(),\"A réaliser\",IF(E10>=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())-15),\"Retard ≤ 15j\",\"Retard > 15j\"))","v":"A réaliser"},"Visualer la fiche du 1234AA19"]
["NANCY","1234AA20","CITROEN_C 15","ENTRETIEN REVISION","2015-05-04","2015-05-03",null,{"$f":"IF(E11>=TODAY(),\"A réaliser\",IF(E11>=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())-15),\"Retard ≤ 15j\",\"Retard > 15j\"))","v":"A réaliser"},"Visualer la fiche du 1234AA20"]
["NANTES","1234AA21","NISSAN_TERRANO","ENTRETIEN REVISION","2015-05-11",null,null,{"$f":"IF(E12>=TODAY(),\"A réaliser\",IF(E12>=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())-15),\"Retard ≤ 15j\",\"Retard > 15j\"))","v":"A réaliser"},"Visualer la fiche du 1234AA21"]
["NIORD","1234AA22","MERCEDES SPRINTER 4X4","ENTRETIEN ANNUEL PORTE-ECHELLE","2015-04-14",null,null,{"$f":"IF(E13>=TODAY(),\"A réaliser\",IF(E13>=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())-15),\"Retard ≤ 15j\",\"Retard > 15j\"))","v":"Retard > 15j"},"Visualer la fiche du 1234AA22"]

{"sheet":"Fiche","index":1,"n_rows":23,"n_cols":4,"rows_kept":23,"hidden":true,"merged":[[0,2,0,3],[1,1,1,3],[2,0,2,3],[3,1,3,2],[4,0,6,0],[4,1,4,2],[4,3,6,3],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,0,8,3],[10,1,10,3],[20,1,20,3],[22,0,23,0],[22,1,25,3],[27,0,27,3]]}
[null,null,{"$f":"B15","v":"1234AA11"}]
[null,{"$f":"B21","v":0}]
["FICHE ENTRETIEN"]
["Date de la fiche",null,null,"N° fiche"]
[{"$f":"TODAY()","v":"2015-05-04"},"Cette fiche est à adresser à  :",null,654123654]
[null,"Mr DUPOND"]
[]
[null,"Unité  : ABCDCB"]
[]
[]
["Interlocuteur agence","Mr ROBERT / 01 11 11 11 11 / JEIJIJRIJE"]
[]
["Date de RDV","2015-05-25"]
[]
["Immatriculation","1234AA11"]
[]
["Kilometrage ( à saisir )"]
[]
["Convoyage","NON"]
[]
["Prestataire"]
[]
["Intervention à réaliser","CTRL REMORQUE"]