{"text_format":"3","workbook":"xlsx","n_sheets":14,"sheets":["LEGEND","Tableau de Bord","FI#000","FI#001","FI#002","FI#003","FI#004","FI#005","FI#006","FI#007","FI#008","FI#009","FI#010","DATA"],"not_rendered":{"images":2,"defined_names":5,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"LEGEND","index":0,"n_rows":18,"n_cols":6,"rows_kept":18}
[]
[null,"Case 01",null,123,null,"Entrée de données manuelle"]
[]
[null,"Case 02",null,123,null,"Données finales calculées"]
[]
[null,"Case 03",null,123,null,"Calcul automatisé"]
[]
[null,"Case 04",null,123,null,"Chiffres modulables"]
[]
[null,"Case 05",null,"ABC",null,"Liste à choix multiples"]
[]
[null,"Case 06",null,"ABC",null,"Structure, titre et dénominations"]
[]
[null,"Case 07",null,"ABC",null,"Annotation temporaire /Données facultatives"]
[]
[null,"Onglet  01",{"$nulls":3},"Légendes, Feuilles de données"]
[]
[null,"Onglet 02",{"$nulls":3},"Feuille principale de calcul"]

{"sheet":"Tableau de Bord","index":1,"n_rows":15,"n_cols":17,"rows_kept":15,"merged":[[1,2,1,4],[1,7,1,8],[1,10,1,11],[2,7,2,8],[2,10,2,11]]}
[]
[null,"Nom du Client :",{"$nulls":3},"Date de début CPS :","2018-10-01","Adresse du client",null,"Personne de contact","Téléphone / Email"]
[null,"Référence CPS :",null,"Nombre d'heures :",20,"Date de fin CPS : ",{"$f":"(E3*DATA!Q3)+G2","v":"2018-12-10"}]
[]
[null,"# Intervention","Date de la demande \nd'intervention","Demande émise par","Date de validation de la demande","Demande validée par","Mode de réception","Réceptionné par","Date d'intervention","Type d'intervention","Mode d'intervention","Heure de début","Heure de fin","Résolution","Nombre d'heures \nconsommées","Nombre d'heures \nrestantes","Actions Spécifiques"]
[null,1,{"$f":"'FI#001'!C11","v":"00:00:00"},{"$f":"'FI#001'!C12","v":0},{"$f":"'FI#001'!C13","v":"00:00:00"},{"$f":"'FI#001'!C14","v":0},{"$f":"'FI#001'!C15","v":0},{"$f":"'FI#001'!C16","v":0},{"$f":"'FI#001'!C18","v":"00:00:00"},{"$f":"'FI#001'!C19","v":0},{"$f":"'FI#001'!C20","v":0},{"$f":"'FI#001'!C22","v":"00:00:00"},{"$f":"'FI#001'!C23","v":"00:00:00"},{"$f":"'FI#001'!C24","v":0},{"$f":"'FI#001'!C26","v":0},{"$f":"E3-O6","v":20}]
[null,2,{"$f":"'FI#002'!C11","v":"00:00:00"},{"$f":"'FI#002'!C12","v":0},{"$f":"'FI#002'!C13","v":"00:00:00"},{"$f":"'FI#002'!C14","v":0},{"$f":"'FI#002'!C15","v":0},{"$f":"'FI#002'!C16","v":0},{"$f":"'FI#002'!C18","v":"00:00:00"},{"$f":"'FI#002'!C19","v":0},{"$f":"'FI#002'!C20","v":0},{"$f":"'FI#002'!C22","v":"00:00:00"},{"$f":"'FI#002'!C23","v":"00:00:00"},{"$f":"'FI#002'!C24","v":0},{"$f":"'FI#002'!C26","v":0},{"$f":"P6-O7","v":20}]
[null,3,{"$f":"'FI#003'!C11","v":"00:00:00"},{"$f":"'FI#003'!C12","v":0},{"$f":"'FI#003'!C13","v":"00:00:00"},{"$f":"'FI#003'!C14","v":0},{"$f":"'FI#003'!C15","v":0},{"$f":"'FI#003'!C16","v":0},{"$f":"'FI#003'!C18","v":"00:00:00"},{"$f":"'FI#003'!C19","v":0},{"$f":"'FI#003'!C20","v":0},{"$f":"'FI#003'!C22","v":"00:00:00"},{"$f":"'FI#003'!C23","v":"00:00:00"},{"$f":"'FI#003'!C24","v":0},{"$f":"'FI#003'!C26","v":0},20]
[null,4,{"$f":"'FI#004'!C11","v":"00:00:00"},{"$f":"'FI#004'!C12","v":0},{"$f":"'FI#004'!C13","v":"00:00:00"},{"$f":"'FI#004'!C14","v":0},{"$f":"'FI#004'!C15","v":0},{"$f":"'FI#004'!C16","v":0},{"$f":"'FI#004'!C18","v":"00:00:00"},{"$f":"'FI#004'!C19","v":0},{"$f":"'FI#004'!C20","v":0},{"$f":"'FI#004'!C22","v":"00:00:00"},{"$f":"'FI#004'!C23","v":"00:00:00"},{"$f":"'FI#004'!C24","v":0},{"$f":"'FI#004'!C26","v":0},20]
[null,5,{"$f":"'FI#005'!C11","v":"00:00:00"},{"$f":"'FI#005'!C12","v":0},{"$f":"'FI#005'!C13","v":"00:00:00"},{"$f":"'FI#005'!C14","v":0},{"$f":"'FI#005'!C15","v":0},{"$f":"'FI#005'!C16","v":0},{"$f":"'FI#005'!C18","v":"00:00:00"},{"$f":"'FI#005'!C19","v":0},{"$f":"'FI#005'!C20","v":0},{"$f":"'FI#005'!C22","v":"00:00:00"},{"$f":"'FI#005'!C23","v":"00:00:00"},{"$f":"'FI#005'!C24","v":0},{"$f":"'FI#005'!C26","v":0},20]
[null,6,{"$f":"'FI#006'!C11","v":"00:00:00"},{"$f":"'FI#006'!C12","v":0},{"$f":"'FI#006'!C13","v":"00:00:00"},{"$f":"'FI#006'!C14","v":0},{"$f":"'FI#006'!C15","v":0},{"$f":"'FI#006'!C16","v":0},{"$f":"'FI#006'!C18","v":"00:00:00"},{"$f":"'FI#006'!C19","v":0},{"$f":"'FI#006'!C20","v":0},{"$f":"'FI#006'!C22","v":"00:00:00"},{"$f":"'FI#006'!C23","v":"00:00:00"},{"$f":"'FI#006'!C24","v":0},{"$f":"'FI#006'!C26","v":0},20]
[null,7,{"$f":"'FI#007'!C11","v":"00:00:00"},{"$f":"'FI#007'!C12","v":0},{"$f":"'FI#007'!C13","v":"00:00:00"},{"$f":"'FI#007'!C14","v":0},{"$f":"'FI#007'!C15","v":0},{"$f":"'FI#007'!C16","v":0},{"$f":"'FI#007'!C18","v":"00:00:00"},{"$f":"'FI#007'!C19","v":0},{"$f":"'FI#007'!C20","v":0},{"$f":"'FI#007'!C22","v":"00:00:00"},{"$f":"'FI#007'!C23","v":"00:00:00"},{"$f":"'FI#007'!C24","v":0},{"$f":"'FI#007'!C26","v":0},20]
[null,8,{"$f":"'FI#008'!C11","v":"00:00:00"},{"$f":"'FI#008'!C12","v":0},{"$f":"'FI#008'!C13","v":"00:00:00"},{"$f":"'FI#008'!C14","v":0},{"$f":"'FI#008'!C15","v":0},{"$f":"'FI#008'!C16","v":0},{"$f":"'FI#008'!C18","v":"00:00:00"},{"$f":"'FI#008'!C19","v":0},{"$f":"'FI#008'!C20","v":0},{"$f":"'FI#008'!C22","v":"00:00:00"},{"$f":"'FI#008'!C23","v":"00:00:00"},{"$f":"'FI#008'!C24","v":0},{"$f":"'FI#008'!C26","v":0},20]
[null,9,{"$f":"'FI#009'!C11","v":"00:00:00"},{"$f":"'FI#009'!C12","v":0},{"$f":"'FI#009'!C13","v":"00:00:00"},{"$f":"'FI#009'!C14","v":0},{"$f":"'FI#009'!C15","v":0},{"$f":"'FI#009'!C16","v":0},{"$f":"'FI#009'!C18","v":"00:00:00"},{"$f":"'FI#009'!C19","v":0},{"$f":"'FI#009'!C20","v":0},{"$f":"'FI#009'!C22","v":"00:00:00"},{"$f":"'FI#009'!C23","v":"00:00:00"},{"$f":"'FI#009'!C24","v":0},{"$f":"'FI#009'!C26","v":0},20]
[null,10,{"$f":"'FI#010'!C11","v":"00:00:00"},{"$f":"'FI#010'!C12","v":0},{"$f":"'FI#010'!C13","v":"00:00:00"},{"$f":"'FI#010'!C14","v":0},{"$f":"'FI#010'!C15","v":0},{"$f":"'FI#010'!C16","v":0},{"$f":"'FI#010'!C18","v":"00:00:00"},{"$f":"'FI#010'!C19","v":0},{"$f":"'FI#010'!C20","v":0},{"$f":"'FI#010'!C22","v":"00:00:00"},{"$f":"'FI#010'!C23","v":"00:00:00"},{"$f":"'FI#010'!C24","v":0},{"$f":"'FI#010'!C26","v":0},20]

{"sheet":"FI#000","index":2,"n_rows":49,"n_cols":6,"rows_kept":49,"hidden":true,"merged":[[1,1,2,5],[5,4,5,6],[6,5,6,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[21,5,23,5],[27,1,27,5],[28,1,35,5],[37,1,37,5],[38,1,43,5],[46,2,46,3],[47,2,47,3],[47,5,48,5],[48,2,48,3]]}
[]
[null,"FICHE D'INTERVENTION"]
[]
[]
[]
[null,null,"Données",null,"Nos Coordonnées "]
[null,"# Fiche d'intervention",0,null,{"$f":"DATA!N5","v":"…"},{"$f":"DATA!L3","v":"My Own Tools"}]
[null,"Numéro de contrat CPS",{"$f":"'Tableau de Bord'!C3","v":0},null,null,{"$f":"DATA!L4","v":"Red Star IT"}]
[null,"Nom du client",{"$f":"'Tableau de Bord'!C2:E2","v":0},null,{"$f":"DATA!N6","v":"ü"},{"$f":"DATA!L5","v":"Adresse 1"}]
[{"$nulls":5},{"$f":"DATA!L6","v":"Adresse 2"}]
[null,"Date de la demande d'intervention","2017-03-20",null,null,{"$f":"DATA!L7","v":"CP - VILLE"}]
[null,"Demande émise par","Client",null,{"$f":"DATA!N4","v":"È"},{"$f":"DATA!L8","v":"(+33) xxx xxx xxx"}]
[null,"Date de validation de la demande","2017-03-22",null,{"$f":"DATA!N3","v":"*"},{"$f":"DATA!L9","v":"x@y.z"}]
[null,"Demande validée par","Personne de contact"]
[null,"Mode de réception","Demande sur place"]
[null,"Réceptionné par","Personnel"]
[]
[null,"Date d'intervention","2017-04-01"]
[null,"Type d'intervention","Opération planifiée"]
[null,"Mode d'intervention","Sur site",null,null,"Date et Signature"]
[null,"Nom de l'intervenant","Personnel"]
[null,"Heure de début","09:05:00"]
[null,"Heure de fin","15:18:00"]
[null,"Résolution","Résolu"]
[]
[null,"Nombre d'heures consommées",{"$f":"IF(C20=\"Sur site\",ROUNDUP(((C23-C22)*1440)/60,0)+1,ROUNDUP(((C23-C22)*1440)/60,0))","v":8},null,"le :","2017-04-01"]
[]
[null,"Description des travaux"]
[null,"* Ensemble d'opérations décrites avec assez de précisions pour que le client soit informé de ce qui a été fait chez lui (soit sur site, soit à distance).\n* Faire court et concis."]
{"$rows_empty":8}
[null,"Observations du client"]
[null,"* Zone dans laquelle le client peut faire part de ses observations, remarques, critiques ou éventuellement demandes complémentaires"]
[]
[]
[]
[]
[]
[]
[{"$nulls":5},"Signature Client"]
[null,"A :","Lieu de l'intervention"]
[null,"Validé le :","2017-04-01"]
[null,"Par :",{"$f":"'Tableau de Bord'!J3","v":0}]

{"sheet":"FI#001","index":3,"n_rows":49,"n_cols":6,"rows_kept":49,"merged":[[1,1,2,5],[5,4,5,6],[6,5,6,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[21,5,23,5],[27,1,27,5],[28,1,35,5],[37,1,37,5],[38,1,43,5],[46,2,46,3],[47,2,47,3],[47,5,48,5],[48,2,48,3]]}
[]
[null,"FICHE D'INTERVENTION"]
[]
[]
[]
[null,null,"Données",null,"Nos Coordonnées "]
[null,"# Fiche d'intervention",1,null,null,{"$f":"DATA!L3","v":"My Own Tools"}]
[null,"Numéro de contrat CPS",{"$f":"'Tableau de Bord'!C3","v":0},null,null,{"$f":"DATA!L4","v":"Red Star IT"}]
[null,"Nom du client",{"$f":"'Tableau de Bord'!C2:E2","v":0},null,{"$f":"DATA!N6","v":"ü"},{"$f":"DATA!L5","v":"Adresse 1"}]
[{"$nulls":5},{"$f":"DATA!L6","v":"Adresse 2"}]
[null,"Date de la demande d'intervention",{"$nulls":3},{"$f":"DATA!L7","v":"CP - VILLE"}]
[null,"Demande émise par",null,null,{"$f":"DATA!N4","v":"È"},{"$f":"DATA!L8","v":"(+33) xxx xxx xxx"}]
[null,"Date de validation de la demande",null,null,{"$f":"DATA!N3","v":"*"},{"$f":"DATA!L9","v":"x@y.z"}]
[null,"Demande validée par"]
[null,"Mode de réception"]
[null,"Réceptionné par"]
[]
[null,"Date d'intervention"]
[null,"Type d'intervention"]
[null,"Mode d'intervention",{"$nulls":3},"Date et Signature"]
[null,"Nom de l'intervenant"]
[null,"Heure de début"]
[null,"Heure de fin"]
[null,"Résolution"]
[]
[null,"Nombre d'heures consommées",{"$f":"IF(C20=\"Sur site\",ROUNDUP(((C23-C22)*1440)/60,0)+1,ROUNDUP(((C23-C22)*1440)/60,0))","v":0},null,"le :"]
[]
[null,"Description des travaux"]
{"$rows_empty":9}
[null,"Observations du client"]
{"$rows_empty":7}
[{"$nulls":5},"Signature Client"]
[null,"A :"]
[null,"Validé le :"]
[null,"Par :",{"$f":"'Tableau de Bord'!J3","v":0}]

{"sheet":"FI#002","index":4,"n_rows":49,"n_cols":6,"rows_kept":49,"merged":[[1,1,2,5],[5,4,5,6],[6,5,6,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[21,5,23,5],[27,1,27,5],[28,1,35,5],[37,1,37,5],[38,1,43,5],[46,2,46,3],[47,2,47,3],[47,5,48,5],[48,2,48,3]]}
[]
[null,"FICHE D'INTERVENTION"]
[]
[]
[]
[null,null,"Données",null,"Nos Coordonnées "]
[null,"# Fiche d'intervention",2,null,null,{"$f":"DATA!L3","v":"My Own Tools"}]
[null,"Numéro de contrat CPS",{"$f":"'Tableau de Bord'!C3","v":0},null,null,{"$f":"DATA!L4","v":"Red Star IT"}]
[null,"Nom du client",{"$f":"'Tableau de Bord'!C2:E2","v":0},null,{"$f":"DATA!N6","v":"ü"},{"$f":"DATA!L5","v":"Adresse 1"}]
[{"$nulls":5},{"$f":"DATA!L6","v":"Adresse 2"}]
[null,"Date de la demande d'intervention",{"$nulls":3},{"$f":"DATA!L7","v":"CP - VILLE"}]
[null,"Demande émise par",null,null,{"$f":"DATA!N4","v":"È"},{"$f":"DATA!L8","v":"(+33) xxx xxx xxx"}]
[null,"Date de validation de la demande",null,null,{"$f":"DATA!N3","v":"*"},{"$f":"DATA!L9","v":"x@y.z"}]
[null,"Demande validée par"]
[null,"Mode de réception"]
[null,"Réceptionné par"]
[]
[null,"Date d'intervention"]
[null,"Type d'intervention"]
[null,"Mode d'intervention",{"$nulls":3},"Date et Signature"]
[null,"Nom de l'intervenant"]
[null,"Heure de début"]
[null,"Heure de fin"]
[null,"Résolution"]
[]
[null,"Nombre d'heures consommées",{"$f":"IF(C20=\"Sur site\",ROUNDUP(((C23-C22)*1440)/60,0)+1,ROUNDUP(((C23-C22)*1440)/60,0))","v":0},null,"le :"]
[]
[null,"Description des travaux"]
{"$rows_empty":9}
[null,"Observations du client"]
{"$rows_empty":7}
[{"$nulls":5},"Signature Client"]
[null,"A :"]
[null,"Validé le :"]
[null,"Par :",{"$f":"'Tableau de Bord'!J3","v":0}]

{"sheet":"FI#003","index":5,"n_rows":49,"n_cols":6,"rows_kept":49,"merged":[[1,1,2,5],[5,4,5,6],[6,5,6,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[21,5,23,5],[27,1,27,5],[28,1,35,5],[37,1,37,5],[38,1,43,5],[46,2,46,3],[47,2,47,3],[47,5,48,5],[48,2,48,3]]}
[]
[null,"FICHE D'INTERVENTION"]
[]
[]
[]
[null,null,"Données",null,"Nos Coordonnées "]
[null,"# Fiche d'intervention",3,null,null,{"$f":"DATA!L3","v":"My Own Tools"}]
[null,"Numéro de contrat CPS",{"$f":"'Tableau de Bord'!C3","v":0},null,null,{"$f":"DATA!L4","v":"Red Star IT"}]
[null,"Nom du client",{"$f":"'Tableau de Bord'!C2:E2","v":0},null,{"$f":"DATA!N6","v":"ü"},{"$f":"DATA!L5","v":"Adresse 1"}]
[{"$nulls":5},{"$f":"DATA!L6","v":"Adresse 2"}]
[null,"Date de la demande d'intervention",{"$nulls":3},{"$f":"DATA!L7","v":"CP - VILLE"}]
[null,"Demande émise par",null,null,{"$f":"DATA!N4","v":"È"},{"$f":"DATA!L8","v":"(+33) xxx xxx xxx"}]
[null,"Date de validation de la demande",null,null,{"$f":"DATA!N3","v":"*"},{"$f":"DATA!L9","v":"x@y.z"}]
[null,"Demande validée par"]
[null,"Mode de réception"]
[null,"Réceptionné par"]
[]
[null,"Date d'intervention"]
[null,"Type d'intervention"]
[null,"Mode d'intervention",{"$nulls":3},"Date et Signature"]
[null,"Nom de l'intervenant"]
[null,"Heure de début"]
[null,"Heure de fin"]
[null,"Résolution"]
[]
[null,"Nombre d'heures consommées",{"$f":"IF(C20=\"Sur site\",ROUNDUP(((C23-C22)*1440)/60,0)+1,ROUNDUP(((C23-C22)*1440)/60,0))","v":0},null,"le :"]
[]
[null,"Description des travaux"]
{"$rows_empty":9}
[null,"Observations du client"]
{"$rows_empty":7}
[{"$nulls":5},"Signature Client"]
[null,"A :"]
[null,"Validé le :"]
[null,"Par :",{"$f":"'Tableau de Bord'!J3","v":0}]

{"sheet":"FI#004","index":6,"n_rows":49,"n_cols":6,"rows_kept":49,"merged":[[1,1,2,5],[5,4,5,6],[6,5,6,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[21,5,23,5],[27,1,27,5],[28,1,35,5],[37,1,37,5],[38,1,43,5],[46,2,46,3],[47,2,47,3],[47,5,48,5],[48,2,48,3]]}
[]
[null,"FICHE D'INTERVENTION"]
[]
[]
[]
[null,null,"Données",null,"Nos Coordonnées "]
[null,"# Fiche d'intervention",4,null,null,{"$f":"DATA!L3","v":"My Own Tools"}]
[null,"Numéro de contrat CPS",{"$f":"'Tableau de Bord'!C3","v":0},null,null,{"$f":"DATA!L4","v":"Red Star IT"}]
[null,"Nom du client",{"$f":"'Tableau de Bord'!C2:E2","v":0},null,{"$f":"DATA!N6","v":"ü"},{"$f":"DATA!L5","v":"Adresse 1"}]
[{"$nulls":5},{"$f":"DATA!L6","v":"Adresse 2"}]
[null,"Date de la demande d'intervention",{"$nulls":3},{"$f":"DATA!L7","v":"CP - VILLE"}]
[null,"Demande émise par",null,null,{"$f":"DATA!N4","v":"È"},{"$f":"DATA!L8","v":"(+33) xxx xxx xxx"}]
[null,"Date de validation de la demande",null,null,{"$f":"DATA!N3","v":"*"},{"$f":"DATA!L9","v":"x@y.z"}]
[null,"Demande validée par"]
[null,"Mode de réception"]
[null,"Réceptionné par"]
[]
[null,"Date d'intervention"]
[null,"Type d'intervention"]
[null,"Mode d'intervention",{"$nulls":3},"Date et Signature"]
[null,"Nom de l'intervenant"]
[null,"Heure de début"]
[null,"Heure de fin"]
[null,"Résolution"]
[]
[null,"Nombre d'heures consommées",{"$f":"IF(C20=\"Sur site\",ROUNDUP(((C23-C22)*1440)/60,0)+1,ROUNDUP(((C23-C22)*1440)/60,0))","v":0},null,"le :"]
[]
[null,"Description des travaux"]
{"$rows_empty":9}
[null,"Observations du client"]
{"$rows_empty":7}
[{"$nulls":5},"Signature Client"]
[null,"A :"]
[null,"Validé le :"]
[null,"Par :",{"$f":"'Tableau de Bord'!J3","v":0}]

{"sheet":"FI#005","index":7,"n_rows":49,"n_cols":6,"rows_kept":49,"merged":[[1,1,2,5],[5,4,5,6],[6,5,6,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[21,5,23,5],[27,1,27,5],[28,1,35,5],[37,1,37,5],[38,1,43,5],[46,2,46,3],[47,2,47,3],[47,5,48,5],[48,2,48,3]]}
[]
[null,"FICHE D'INTERVENTION"]
[]
[]
[]
[null,null,"Données",null,"Nos Coordonnées "]
[null,"# Fiche d'intervention",5,null,null,{"$f":"DATA!L3","v":"My Own Tools"}]
[null,"Numéro de contrat CPS",{"$f":"'Tableau de Bord'!C3","v":0},null,null,{"$f":"DATA!L4","v":"Red Star IT"}]
[null,"Nom du client",{"$f":"'Tableau de Bord'!C2:E2","v":0},null,{"$f":"DATA!N6","v":"ü"},{"$f":"DATA!L5","v":"Adresse 1"}]
[{"$nulls":5},{"$f":"DATA!L6","v":"Adresse 2"}]
[null,"Date de la demande d'intervention",{"$nulls":3},{"$f":"DATA!L7","v":"CP - VILLE"}]
[null,"Demande émise par",null,null,{"$f":"DATA!N4","v":"È"},{"$f":"DATA!L8","v":"(+33) xxx xxx xxx"}]
[null,"Date de validation de la demande",null,null,{"$f":"DATA!N3","v":"*"},{"$f":"DATA!L9","v":"x@y.z"}]
[null,"Demande validée par"]
[null,"Mode de réception"]
[null,"Réceptionné par"]
[]
[null,"Date d'intervention"]
[null,"Type d'intervention"]
[null,"Mode d'intervention",{"$nulls":3},"Date et Signature"]
[null,"Nom de l'intervenant"]
[null,"Heure de début"]
[null,"Heure de fin"]
[null,"Résolution"]
[]
[null,"Nombre d'heures consommées",{"$f":"IF(C20=\"Sur site\",ROUNDUP(((C23-C22)*1440)/60,0)+1,ROUNDUP(((C23-C22)*1440)/60,0))","v":0},null,"le :"]
[]
[null,"Description des travaux"]
{"$rows_empty":9}
[null,"Observations du client"]
{"$rows_empty":7}
[{"$nulls":5},"Signature Client"]
[null,"A :"]
[null,"Validé le :"]
[null,"Par :",{"$f":"'Tableau de Bord'!J3","v":0}]

{"sheet":"FI#006","index":8,"n_rows":49,"n_cols":6,"rows_kept":49,"merged":[[1,1,2,5],[5,4,5,6],[6,5,6,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[21,5,23,5],[27,1,27,5],[28,1,35,5],[37,1,37,5],[38,1,43,5],[46,2,46,3],[47,2,47,3],[47,5,48,5],[48,2,48,3]]}
[]
[null,"FICHE D'INTERVENTION"]
[]
[]
[]
[null,null,"Données",null,"Nos Coordonnées "]
[null,"# Fiche d'intervention",6,null,null,{"$f":"DATA!L3","v":"My Own Tools"}]
[null,"Numéro de contrat CPS",{"$f":"'Tableau de Bord'!C3","v":0},null,null,{"$f":"DATA!L4","v":"Red Star IT"}]
[null,"Nom du client",{"$f":"'Tableau de Bord'!C2:E2","v":0},null,{"$f":"DATA!N6","v":"ü"},{"$f":"DATA!L5","v":"Adresse 1"}]
[{"$nulls":5},{"$f":"DATA!L6","v":"Adresse 2"}]
[null,"Date de la demande d'intervention",{"$nulls":3},{"$f":"DATA!L7","v":"CP - VILLE"}]
[null,"Demande émise par",null,null,{"$f":"DATA!N4","v":"È"},{"$f":"DATA!L8","v":"(+33) xxx xxx xxx"}]
[null,"Date de validation de la demande",null,null,{"$f":"DATA!N3","v":"*"},{"$f":"DATA!L9","v":"x@y.z"}]
[null,"Demande validée par"]
[null,"Mode de réception"]
[null,"Réceptionné par"]
[]
[null,"Date d'intervention"]
[null,"Type d'intervention"]
[null,"Mode d'intervention",{"$nulls":3},"Date et Signature"]
[null,"Nom de l'intervenant"]
[null,"Heure de début"]
[null,"Heure de fin"]
[null,"Résolution"]
[]
[null,"Nombre d'heures consommées",{"$f":"IF(C20=\"Sur site\",ROUNDUP(((C23-C22)*1440)/60,0)+1,ROUNDUP(((C23-C22)*1440)/60,0))","v":0},null,"le :"]
[]
[null,"Description des travaux"]
{"$rows_empty":9}
[null,"Observations du client"]
{"$rows_empty":7}
[{"$nulls":5},"Signature Client"]
[null,"A :"]
[null,"Validé le :"]
[null,"Par :",{"$f":"'Tableau de Bord'!J3","v":0}]

{"sheet":"FI#007","index":9,"n_rows":49,"n_cols":6,"rows_kept":49,"merged":[[1,1,2,5],[5,4,5,6],[6,5,6,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[21,5,23,5],[27,1,27,5],[28,1,35,5],[37,1,37,5],[38,1,43,5],[46,2,46,3],[47,2,47,3],[47,5,48,5],[48,2,48,3]]}
[]
[null,"FICHE D'INTERVENTION"]
[]
[]
[]
[null,null,"Données",null,"Nos Coordonnées "]
[null,"# Fiche d'intervention",7,null,null,{"$f":"DATA!L3","v":"My Own Tools"}]
[null,"Numéro de contrat CPS",{"$f":"'Tableau de Bord'!C3","v":0},null,null,{"$f":"DATA!L4","v":"Red Star IT"}]
[null,"Nom du client",{"$f":"'Tableau de Bord'!C2:E2","v":0},null,{"$f":"DATA!N6","v":"ü"},{"$f":"DATA!L5","v":"Adresse 1"}]
[{"$nulls":5},{"$f":"DATA!L6","v":"Adresse 2"}]
[null,"Date de la demande d'intervention",{"$nulls":3},{"$f":"DATA!L7","v":"CP - VILLE"}]
[null,"Demande émise par",null,null,{"$f":"DATA!N4","v":"È"},{"$f":"DATA!L8","v":"(+33) xxx xxx xxx"}]
[null,"Date de validation de la demande",null,null,{"$f":"DATA!N3","v":"*"},{"$f":"DATA!L9","v":"x@y.z"}]
[null,"Demande validée par"]
[null,"Mode de réception"]
[null,"Réceptionné par"]
[]
[null,"Date d'intervention"]
[null,"Type d'intervention"]
[null,"Mode d'intervention",{"$nulls":3},"Date et Signature"]
[null,"Nom de l'intervenant"]
[null,"Heure de début"]
[null,"Heure de fin"]
[null,"Résolution"]
[]
[null,"Nombre d'heures consommées",{"$f":"IF(C20=\"Sur site\",ROUNDUP(((C23-C22)*1440)/60,0)+1,ROUNDUP(((C23-C22)*1440)/60,0))","v":0},null,"le :"]
[]
[null,"Description des travaux"]
{"$rows_empty":9}
[null,"Observations du client"]
{"$rows_empty":7}
[{"$nulls":5},"Signature Client"]
[null,"A :"]
[null,"Validé le :"]
[null,"Par :",{"$f":"'Tableau de Bord'!J3","v":0}]

{"sheet":"FI#008","index":10,"n_rows":49,"n_cols":6,"rows_kept":49,"merged":[[1,1,2,5],[5,4,5,6],[6,5,6,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[21,5,23,5],[27,1,27,5],[28,1,35,5],[37,1,37,5],[38,1,43,5],[46,2,46,3],[47,2,47,3],[47,5,48,5],[48,2,48,3]]}
[]
[null,"FICHE D'INTERVENTION"]
[]
[]
[]
[null,null,"Données",null,"Nos Coordonnées "]
[null,"# Fiche d'intervention",8,null,null,{"$f":"DATA!L3","v":"My Own Tools"}]
[null,"Numéro de contrat CPS",{"$f":"'Tableau de Bord'!C3","v":0},null,null,{"$f":"DATA!L4","v":"Red Star IT"}]
[null,"Nom du client",{"$f":"'Tableau de Bord'!C2:E2","v":0},null,{"$f":"DATA!N6","v":"ü"},{"$f":"DATA!L5","v":"Adresse 1"}]
[{"$nulls":5},{"$f":"DATA!L6","v":"Adresse 2"}]
[null,"Date de la demande d'intervention",{"$nulls":3},{"$f":"DATA!L7","v":"CP - VILLE"}]
[null,"Demande émise par",null,null,{"$f":"DATA!N4","v":"È"},{"$f":"DATA!L8","v":"(+33) xxx xxx xxx"}]
[null,"Date de validation de la demande",null,null,{"$f":"DATA!N3","v":"*"},{"$f":"DATA!L9","v":"x@y.z"}]
[null,"Demande validée par"]
[null,"Mode de réception"]
[null,"Réceptionné par"]
[]
[null,"Date d'intervention"]
[null,"Type d'intervention"]
[null,"Mode d'intervention",{"$nulls":3},"Date et Signature"]
[null,"Nom de l'intervenant"]
[null,"Heure de début"]
[null,"Heure de fin"]
[null,"Résolution"]
[]
[null,"Nombre d'heures consommées",{"$f":"IF(C20=\"Sur site\",ROUNDUP(((C23-C22)*1440)/60,0)+1,ROUNDUP(((C23-C22)*1440)/60,0))","v":0},null,"le :"]
[]
[null,"Description des travaux"]
{"$rows_empty":9}
[null,"Observations du client"]
{"$rows_empty":7}
[{"$nulls":5},"Signature Client"]
[null,"A :"]
[null,"Validé le :"]
[null,"Par :",{"$f":"'Tableau de Bord'!J3","v":0}]

{"sheet":"FI#009","index":11,"n_rows":49,"n_cols":6,"rows_kept":49,"merged":[[1,1,2,5],[5,4,5,6],[6,5,6,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[21,5,23,5],[27,1,27,5],[28,1,35,5],[37,1,37,5],[38,1,43,5],[46,2,46,3],[47,2,47,3],[47,5,48,5],[48,2,48,3]]}
[]
[null,"FICHE D'INTERVENTION"]
[]
[]
[]
[null,null,"Données",null,"Nos Coordonnées "]
[null,"# Fiche d'intervention",9,null,null,{"$f":"DATA!L3","v":"My Own Tools"}]
[null,"Numéro de contrat CPS",{"$f":"'Tableau de Bord'!C3","v":0},null,null,{"$f":"DATA!L4","v":"Red Star IT"}]
[null,"Nom du client",{"$f":"'Tableau de Bord'!C2:E2","v":0},null,{"$f":"DATA!N6","v":"ü"},{"$f":"DATA!L5","v":"Adresse 1"}]
[{"$nulls":5},{"$f":"DATA!L6","v":"Adresse 2"}]
[null,"Date de la demande d'intervention",{"$nulls":3},{"$f":"DATA!L7","v":"CP - VILLE"}]
[null,"Demande émise par",null,null,{"$f":"DATA!N4","v":"È"},{"$f":"DATA!L8","v":"(+33) xxx xxx xxx"}]
[null,"Date de validation de la demande",null,null,{"$f":"DATA!N3","v":"*"},{"$f":"DATA!L9","v":"x@y.z"}]
[null,"Demande validée par"]
[null,"Mode de réception"]
[null,"Réceptionné par"]
[]
[null,"Date d'intervention"]
[null,"Type d'intervention"]
[null,"Mode d'intervention",{"$nulls":3},"Date et Signature"]
[null,"Nom de l'intervenant"]
[null,"Heure de début"]
[null,"Heure de fin"]
[null,"Résolution"]
[]
[null,"Nombre d'heures consommées",{"$f":"IF(C20=\"Sur site\",ROUNDUP(((C23-C22)*1440)/60,0)+1,ROUNDUP(((C23-C22)*1440)/60,0))","v":0},null,"le :"]
[]
[null,"Description des travaux"]
{"$rows_empty":9}
[null,"Observations du client"]
{"$rows_empty":7}
[{"$nulls":5},"Signature Client"]
[null,"A :"]
[null,"Validé le :"]
[null,"Par :",{"$f":"'Tableau de Bord'!J3","v":0}]

{"sheet":"FI#010","index":12,"n_rows":49,"n_cols":6,"rows_kept":49,"merged":[[1,1,2,5],[5,4,5,6],[6,5,6,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[21,5,23,5],[27,1,27,5],[28,1,35,5],[37,1,37,5],[38,1,43,5],[46,2,46,3],[47,2,47,3],[47,5,48,5],[48,2,48,3]]}
[]
[null,"FICHE D'INTERVENTION"]
[]
[]
[]
[null,null,"Données",null,"Nos Coordonnées "]
[null,"# Fiche d'intervention",10,null,null,{"$f":"DATA!L3","v":"My Own Tools"}]
[null,"Numéro de contrat CPS",{"$f":"'Tableau de Bord'!C3","v":0},null,null,{"$f":"DATA!L4","v":"Red Star IT"}]
[null,"Nom du client",{"$f":"'Tableau de Bord'!C2:E2","v":0},null,{"$f":"DATA!N6","v":"ü"},{"$f":"DATA!L5","v":"Adresse 1"}]
[{"$nulls":5},{"$f":"DATA!L6","v":"Adresse 2"}]
[null,"Date de la demande d'intervention",{"$nulls":3},{"$f":"DATA!L7","v":"CP - VILLE"}]
[null,"Demande émise par",null,null,{"$f":"DATA!N4","v":"È"},{"$f":"DATA!L8","v":"(+33) xxx xxx xxx"}]
[null,"Date de validation de la demande",null,null,{"$f":"DATA!N3","v":"*"},{"$f":"DATA!L9","v":"x@y.z"}]
[null,"Demande validée par"]
[null,"Mode de réception"]
[null,"Réceptionné par"]
[]
[null,"Date d'intervention"]
[null,"Type d'intervention"]
[null,"Mode d'intervention",{"$nulls":3},"Date et Signature"]
[null,"Nom de l'intervenant"]
[null,"Heure de début"]
[null,"Heure de fin"]
[null,"Résolution"]
[]
[null,"Nombre d'heures consommées",{"$f":"IF(C20=\"Sur site\",ROUNDUP(((C23-C22)*1440)/60,0)+1,ROUNDUP(((C23-C22)*1440)/60,0))","v":0},null,"le :"]
[]
[null,"Description des travaux"]
{"$rows_empty":9}
[null,"Observations du client"]
{"$rows_empty":7}
[{"$nulls":5},"Signature Client"]
[null,"A :"]
[null,"Validé le :"]
[null,"Par :",{"$f":"'Tableau de Bord'!J3","v":0}]

{"sheet":"DATA","index":13,"n_rows":9,"n_cols":17,"rows_kept":9,"hidden":true,"merged":[[1,15,1,16]]}
[]
[null,"lstTypeIntervention",null,"lstModeIntervention",null,"lstResolution",null,"lstModeReception",null,"lstReception",null,"Coordonnées",null,"Symbol",null,"CPS"]
[null,"Maintenance Curative",null,"A distance",null,"Résolu",null,"Téléphone",null,"Personnel",null,"My Own Tools",null,"*",null,"Ratio",3.5]
[null,"Maintenance Préventive",null,"Sur site",null,"Non-résolu",null,"E-mail",null,"Standard",null,"Red Star IT",null,"È"]
[null,"Opération planifiée",null,"Continuité d'intervention",null,"En attente du client",null,"Demande sur place",null,"Functional Mailbox",null,"Adresse 1",null,"…"]
[null,"Urgence",{"$nulls":3},"En attente d'un tiers",null,"Autres",{"$nulls":3},"Adresse 2",null,"ü"]
[{"$nulls":5},"Reporté",{"$nulls":5},"CP - VILLE"]
[{"$nulls":5},"Nouvelle Intervention",{"$nulls":5},"(+33) xxx xxx xxx"]
[{"$nulls":5},"A terminer",{"$nulls":5},"x@y.z"]