{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Accueil","Informations personnelles","Informations de déplacement","Hôtel et Activités","Location de voiture","Informations d’urgence"],"not_rendered":{"images":19,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Accueil","index":0,"n_rows":34,"n_cols":22,"rows_kept":34,"merged":[[32,1,32,3],[32,6,32,8],[32,11,32,13],[32,16,32,18],[32,21,32,23],[33,1,33,3],[33,6,33,8],[33,11,33,13],[33,16,33,18],[33,21,33,23]]}
{"$rows_empty":32}
[null,{"$f":"PersonalEntry/TotalPersonnel","v":{"v":1,"d":"100%"}},{"$nulls":4},{"$f":"EntréeDéplacement/TotalDéplacement","v":{"v":0.65,"d":"65%"}},{"$nulls":4},{"$f":"EntréeHôtel/TotalHôtel","v":{"v":0.5384615384615384,"d":"54%"}},{"$nulls":4},{"$f":"IF('Location de voiture'!D4=\"Oui\",EntréeLocationVoiture/TotalLocationVoiture,1)","v":{"v":0.2857142857142857,"d":"29%"}},{"$nulls":4},{"$f":"EntréeEnCasUrgence/TotalEnCasUrgence","v":{"v":0.625,"d":"63%"}}]
[null,{"$f":"TEXT(B33,\"0% \"\"Complété\"\"\")","v":"100% Complété"},{"$nulls":4},{"$f":"TEXT(G33,\"0% \"\"Complété\"\"\")","v":"65% Complété"},{"$nulls":4},{"$f":"TEXT(L33,\"0% \"\"Complété\"\"\")","v":"54% Complété"},{"$nulls":4},{"$f":"TEXT(Q33,\"0% \"\"Complété\"\"\")","v":"29% Complété"},{"$nulls":4},{"$f":"TEXT(V33,\"0% \"\"Complété\"\"\")","v":"63% Complété"}]

{"sheet":"Informations personnelles","index":1,"n_rows":11,"n_cols":5,"rows_kept":11,"merged":[[4,2,5,2],[4,3,5,3],[4,4,5,4],[7,2,8,2],[7,3,8,3],[7,4,8,4],[17,1,17,4]]}
[]
[]
[{"$f":"IF(COUNTA(B4:B8)<1,\"*\",\"\")","v":""},"Noms et prénoms",{"$f":"IF(E3=\"\",1,\"\")","v":""},"Adresse personnelle","36 boulevard Émile Zola, 45 000 Orléans"]
[null,"Antoine Junca"]
[null,"Michelle Alexander",{"$f":"IF(E5=\"\",1,\"\")","v":""},"Téléphone du domicile"," 02 38 57 41 21"]
[null,"Sean P. Alexander"]
[]
[null,null,{"$f":"IF((E8=0)+(E8=\"\"),1,\"\")","v":""},"Téléphones portables","06 52 47 89 10"]
[]
[]
[{"$f":"PersonalEntry","v":3},{"$f":"IF(A11<>TotalPersonnel,\"Informations importantes manquantes\",\"Informations importantes complétées\")","v":"Informations importantes complétées"}]

{"sheet":"Informations de déplacement","index":2,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[23,1,23,5]]}
[]
[]
[null,"Détails concernant le départ",null,null,"Détails concernant le retour"]
[{"$f":"IF(C4=\"\",1,\"\")","v":""},"Date",{"$f":"TODAY()+45","v":"2013-09-14"},{"$f":"IF(F4=\"\",1,\"\")","v":""},"Date",{"$f":"TODAY()+51","v":"2013-09-20"}]
[{"$f":"IF(C5=\"\",1,\"\")","v":""},"Compagnie aérienne","Blue Yonder Airlines","","Compagnie aérienne","Blue Yonder Airlines"]
[{"$f":"IF(C6=\"\",1,\"\")","v":""},"Numéro de vol","WS192",1,"Numéro de vol"]
[{"$f":"IF(C7=\"\",1,\"\")","v":""},"De","Columbus","","De","Seattle"]
[{"$f":"IF(C8=\"\",1,\"\")","v":""},"Heure de départ","12:30:00",1,"Heure de départ"]
[null,"Terminal/Porte d’embarquement",null,1,"Terminal/Porte d’embarquement"]
[{"$f":"IF(C10=\"\",1,\"\")","v":""},"À","Seattle",1,"À"]
[{"$f":"IF(C11=\"\",1,\"\")","v":""},"Heure d’arrivée","12:32:00",1,"Heure d’arrivée"]
[null,"Durée du vol","6 heures",null,"Durée du vol"]
[{"$f":"IF(C13=\"\",1,\"\")","v":""},"Numéros de sièges","A1, A2, A3",{"$f":"IF(F13=\"\",1,\"\")","v":1},"Numéros de sièges"]
[{"$f":"IF(C14=\"\",1,\"\")","v":""},"Numéros de confirmation","Identique",{"$f":"IF(F14=\"\",1,\"\")","v":1},"Numéros de confirmation"]
[{"$f":"IF(C15=\"\",1,\"\")","v":""},"Repas","Pas de restrictions.",null,"Repas"]
[null,"Numéro de téléphone de la compagnie aérienne",1235550234,null,"Numéro de téléphone de la compagnie aérienne",1235550234]
[]
[{"$f":"EntréeDéplacement","v":13},{"$f":"IF(A18<>TotalDéplacement,\"Informations importantes manquantes\",\"Informations importantes complétées\")","v":"Informations importantes manquantes"}]

{"sheet":"Hôtel et Activités","index":3,"n_rows":15,"n_cols":7,"rows_kept":15,"merged":[[21,1,21,6]]}
[]
[]
[null,"Séjour à l’hôtel/détails de l’hébergement",{"$nulls":3},"Détails des activités de vacances"]
[{"$f":"IF(C4=\"\",1,\"\")","v":""},"Date de réservation",{"$f":"TODAY()+45","v":"2013-09-14"},null,null,"Activité 1","Ski"]
["","Nom de l’hôtel","Alpine Ski House",null,{"$f":"IF(AND($G$4<>\"\",G5=\"\"),1,\"\")","v":1},"Dates/Horaires"]
["","Adresse de l’hôtel","789 Main Street",null,{"$f":"IF(AND($G$4<>\"\",G6=\"\"),1,\"\")","v":1},"Date de réservation"]
["","Numéro de téléphone de l’hôtel","Seattle",null,{"$f":"IF(AND($G$4<>\"\",G7=\"\"),1,\"\")","v":1},"Numéro de confirmation"]
["","Jour/heure d’arrivée",{"$f":"TODAY()+45.5","v":"2013-09-14T12:00:00"},null,null,"Activité 2","Coho Vineyard & Winery"]
["","Jour/heure de départ",{"$f":"TODAY()+50.5","v":"2013-09-19T12:00:00"},null,{"$f":"IF(AND($G$8<>\"\",G9=\"\"),1,\"\")","v":1},"Dates/Horaires"]
["","Numéro de confirmation","CJ1234567",null,{"$f":"IF(AND($G$8<>\"\",G10=\"\"),1,\"\")","v":1},"Date de réservation"]
[{"$nulls":4},{"$f":"IF(AND($G$8<>\"\",G11=\"\"),1,\"\")","v":1},"Numéro de confirmation"]
[{"$f":"EntréeHôtel","v":7},{"$f":"IF(A12<>TotalHôtel,\"Informations importantes manquantes\",\"Informations importantes complétées\")","v":"Informations importantes manquantes"},{"$nulls":3},"Activité 3"]
[{"$nulls":4},{"$f":"IF(AND($G$12<>\"\",G13=\"\"),1,\"\")","v":""},"Dates/Horaires"]
[{"$nulls":4},{"$f":"IF(AND($G$12<>\"\",G14=\"\"),1,\"\")","v":""},"Date de réservation"]
[{"$nulls":4},{"$f":"IF(AND($G$12<>\"\",G15=\"\"),1,\"\")","v":""},"Numéro de confirmation"]

{"sheet":"Location de voiture","index":4,"n_rows":13,"n_cols":4,"rows_kept":13,"merged":[[18,0,18,4]]}
[]
[]
[null,null,"Informations sur la location de voiture"]
[null,null,"Location de voiture ?","Oui"]
[null,{"$f":"IF(AND($D$4=\"Oui\",D5=\"\"),1,\"\")","v":""},"Date de réservation",{"$f":"TODAY()+45","v":"2013-09-14"}]
[null,1,"Agence de location"]
[null,1,"Jour/heure de récupération"]
[null,1,"Jour/heure de restitution"]
[null,1,"Numéro de confirmation"]
[null,"","Type de véhicule","Économique"]
[null,1,"Numéro de téléphone"]
[]
[null,{"$f":"EntréeLocationVoiture","v":2},{"$f":"IF(B13<>TotalLocationVoiture,\"Informations importantes manquantes\",\"Informations importantes complétées\")","v":"Informations importantes manquantes"}]

{"sheet":"Informations d’urgence","index":5,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[3,4,4,4],[3,5,4,5],[3,6,4,6],[5,4,6,4],[5,5,6,5],[5,6,6,6],[7,5,8,5],[7,6,8,6],[16,1,16,6]]}
[]
[]
[null,"Détails de l’assurance",{"$nulls":3},"Contacts d’urgence"]
[{"$f":"IF(C4=\"\",1,\"\")","v":""},"Compagnie d’assurance","Humongous Insurance",null,{"$f":"IF(G4=\"\",1,\"\")","v":1},"Nom/Lien/Téléphone"]
["","Numéro de téléphone",1235550567]
["","Type d’assurance","1900-01-05",null,{"$f":"IF(G6=\"\",1,\"\")","v":1},"Nom/Lien/Téléphone"]
["","Numéro de confirmation","1900-01-05"]
["","Date d’achat",{"$f":"TODAY()","v":"2013-07-31"},null,null,"Nom/Lien/Téléphone"]
[1,"Dates d’assurance"]
[]
[{"$f":"EntréeEnCasUrgence","v":5},{"$f":"IF(A11<>TotalEnCasUrgence,\"Informations importantes manquantes\",\"Informations importantes complétées\")","v":"Informations importantes manquantes"}]