{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["%","Charge Tech","Relevé des pannes et inconfort","FORMULAIRE"],"not_rendered":{"macros":1,"external_links":1,"defined_names":97,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"%","index":0,"n_rows":14,"n_cols":5,"rows_kept":14}
[]
[]
[]
[]
["Étiquettes de lignes","Somme de Durée de l'inconfort","Nombre de inconfort","Somme de Durée de la panne","Nombre de Panne"]
["2024-05-31T10:35:00","00:00:00",null,"00:37:00",1]
["PQ1,4 ENGRENAGE","00:00:00",null,"00:37:00",1]
["(vide)","00:00:00",null,"00:37:00",1]
["(vide)","00:00:00",null,"00:37:00",1]
["2024-06-11T08:22:00",1.10625,1,"00:00:00"]
["(vide)",1.10625,1,"00:00:00"]
["(vide)",1.10625,1,"00:00:00"]
["Tripode 2",1.10625,1,"00:00:00"]
["Total général",1.10625,1,"00:37:00",1]

{"sheet":"Charge Tech","index":1,"n_rows":7,"n_cols":4,"rows_kept":7}
[]
[]
["Somme de Durée de l'intervention + veille si réparation complexe","Étiquettes de colonnes"]
["Étiquettes de lignes","Technicien exploit","Technicien prod","Total général"]
["2024-05-31T11:12:00","00:35:00",null,"00:35:00"]
["2024-06-12T10:55:00",null,"01:20:00","01:20:00"]
["Total général","00:35:00","01:20:00","01:55:00"]

{"sheet":"Relevé des pannes et inconfort","index":2,"n_rows":10,"n_cols":19,"rows_kept":10,"merged":[[1,1,1,11],[3,0,3,1],[3,2,3,3],[3,4,3,6],[3,7,3,8],[3,9,3,14],[3,15,3,18]]}
[{"$f":"IF(A6=\"\",\"\",NOW())","v":45475.36088923611},"x"]
[{"$f":"NOW()","v":"2024-07-02T08:39:40.830"},"Outils de gestion des éléments muséologiques - Relevé des pannes ou inconforts des éléments"]
[]
["Constat",null,"Type",null,"Secteur / Elément concernée",{"$nulls":4},"Remise en service",{"$nulls":5},"CALCUL"]
["Intervenant Constat","Date du constat","Panne","Inconfort","Expositions permanentes","Expositions temporaires","Bâtiment","Descriptif de l'inconfort ou panne","Etat","Date Réparation","Intervenant Réparation","Durée de l'intervention + veille si réparation complexe","Colonne1","Colonne2","Réparations apportées","Panne2","Inconfort2","Durée de la panne","Durée de l'inconfort"]
["EXEMPLE: Sarah","2024-05-31T10:35:00","x",null,"PQ1,4 ENGRENAGE",null,null,"Engrenage fixe desolidarisé du mur en PMMA",{"$f":"IF(J6>B6,\"ok\",\"hs\")","v":"ok"},"2024-05-31T11:12:00","Technicien exploit","00:35:00",null,null,"Resserage et mise en place de frein filet fort sur roulement",{"$f":"IF(AND(C6=\"X\",N6>=0),\"Panne\",\" \")","v":"Panne"},{"$f":"IF(AND(D6=\"X\",N6>=0),\"Inconfort\",\" \")","v":" "},{"$f":"IF(C6=\"\",\"\",J6-B6)","v":"00:37:00"},{"$f":"IF(D6=\"\",\"\",J6-B6)","v":""}]
["KILLY Pirogue","2024-07-15T09:35:00","x",null,"fth",null,null,"ahhhhhhhhhhhh",{"$f":"IF(J7>B7,\"ok\",\"hs\")","v":"hs"},{"$nulls":6},{"$f":"IF(AND(C7=\"X\",N7>=0),\"Panne\",\" \")","v":"Panne"},{"$f":"IF(AND(D7=\"X\",N7>=0),\"Inconfort\",\" \")","v":" "},{"$f":"IF(C7=\"\",\"\",J7-B7)","v":-45488.399305555555},{"$f":"IF(D7=\"\",\"\",J7-B7)","v":""}]
["EXEMPLE: Sarah","2024-06-11T08:22:00","x",null,null,"S1A",null,"Bouton arraché                  ",{"$f":"IF(J8>B8,\"ok\",\"hs\")","v":"hs"},{"$nulls":6},{"$f":"IF(AND(C8=\"X\",N8>=0),\"Panne\",\" \")","v":"Panne"},{"$f":"IF(AND(D8=\"X\",N8>=0),\"Inconfort\",\" \")","v":" "},{"$f":"IF(C8=\"\",\"\",J8-B8)","v":-45454.34861111111},{"$f":"IF(D8=\"\",\"\",J8-B8)","v":""}]
["EXEMPLE: Sarah","2024-06-11T08:22:00",null,"x",null,null,"Tripode 2","Tripode qui ne tourne plus",{"$f":"IF(J9>B9,\"ok\",\"hs\")","v":"ok"},"2024-06-12T10:55:00","Technicien prod","01:20:00",null,null,"Démontage de l'axe, graissage,,,,,",{"$f":"IF(AND(C9=\"X\",N9>=0),\"Panne\",\" \")","v":" "},{"$f":"IF(AND(D9=\"X\",N9>=0),\"Inconfort\",\" \")","v":"Inconfort"},{"$f":"IF(C9=\"\",\"\",J9-B9)","v":""},{"$f":"IF(D9=\"\",\"\",J9-B9)","v":1.1062499999970896}]
["EXEMPLE: Sarah","2024-06-11T15:25:00","x",null,null,"S1A",null,"Bouton arraché",{"$f":"IF(J10>B10,\"ok\",\"hs\")","v":"hs"},{"$nulls":6},{"$f":"IF(AND(C10=\"X\",N10>=0),\"Panne\",\" \")","v":"Panne"},{"$f":"IF(AND(D10=\"X\",N10>=0),\"Inconfort\",\" \")","v":" "},{"$f":"IF(C10=\"\",\"\",J10-B10)","v":-45454.64236111111},{"$f":"IF(D10=\"\",\"\",J10-B10)","v":""}]

{"sheet":"FORMULAIRE","index":3,"n_rows":13,"n_cols":16,"rows_kept":13,"merged":[[0,1,0,7],[0,11,0,16]]}
[null,"FORMULAIRE DE CONSTAT",{"$nulls":9},"FORMULAIRE DE REPARATION"]
[]
[null,null,"Nom Prénom",null,null,"Date du constat 00/00/00 .. : ..",{"$nulls":6},"Nom Prénom du référent réparation",null,null,"Date du constat 00/00/00 .. : .."]
[]
[]
[{"$nulls":3},"Panne",null,"Inconfort"]
[{"$nulls":12},"Durée de l'intervention + veille si réparation complexe en heure .. : .."]
[]
[null,null,"Secteur / Référence de l'élément concernée"]
[null,null,"Exposition temporaire",null,"Exposition Permanente",null,"Bâtiment",{"$nulls":5},"Numéro de ligne de la panne/ inconfort"]
[]
[]
[null,null,"Descriptif de l'inconfort ou panne",{"$nulls":9},"Réparation apportées"]