{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Constats projets Entretiens","TODO LIST","suivi des dossiers","Param Constats","Concaténation"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":1},"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":"Constats projets Entretiens","index":0,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Domaine","bien","composante","constat/projet","Entretien","Dates prévues","priorité","Localisation","Constat/Projet ou Entretien"]
["PDH 38","deuxième","appartement SGP (salle de bains)",null,"toto","2016-04-17",{"$f":"IF(Table24[[#This Row],[Dates prévues]]=\"\",\"\", IF(Table24[[#This Row],[Dates prévues]]-15<TODAY(),1,3) )","v":1},{"$f":"Table24[[#This Row],[Domaine]]&\" \" &Table24[[#This Row],[bien]]&\" \" &Table24[[#This Row],[composante]]","v":"PDH 38 deuxième appartement SGP (salle de bains)"},{"$f":"IF(Table24[[#This Row],[constat/projet]]=\"\",Table24[[#This Row],[Entretien]],Table24[[#This Row],[constat/projet]])","v":"toto"}]
["Heure","Ensemble du domaine",null,null,"jardinage",null,3,{"$f":"Table24[[#This Row],[Domaine]]&\" \" &Table24[[#This Row],[bien]]&\" \" &Table24[[#This Row],[composante]]","v":"Heure Ensemble du domaine "},{"$f":"IF(Table24[[#This Row],[constat/projet]]=\"\",Table24[[#This Row],[Entretien]],Table24[[#This Row],[constat/projet]])","v":"jardinage"}]
["Heure",null,null,null,"toto",null,1,{"$f":"Table24[[#This Row],[Domaine]]&\" \" &Table24[[#This Row],[bien]]&\" \" &Table24[[#This Row],[composante]]","v":"Heure  "},{"$f":"IF(Table24[[#This Row],[constat/projet]]=\"\",Table24[[#This Row],[Entretien]],Table24[[#This Row],[constat/projet]])","v":"toto"}]
["PDH 38","deuxième","appartement SGP (salle de bains)",null,"toto","2016-04-17",2,{"$f":"Table24[[#This Row],[Domaine]]&\" \" &Table24[[#This Row],[bien]]&\" \" &Table24[[#This Row],[composante]]","v":"PDH 38 deuxième appartement SGP (salle de bains)"},{"$f":"IF(Table24[[#This Row],[constat/projet]]=\"\",Table24[[#This Row],[Entretien]],Table24[[#This Row],[constat/projet]])","v":"toto"}]
["Itre","Bâtiments",null,null,"toto","2016-05-15",3,{"$f":"Table24[[#This Row],[Domaine]]&\" \" &Table24[[#This Row],[bien]]&\" \" &Table24[[#This Row],[composante]]","v":"Itre Bâtiments "},{"$f":"IF(Table24[[#This Row],[constat/projet]]=\"\",Table24[[#This Row],[Entretien]],Table24[[#This Row],[constat/projet]])","v":"toto"}]
["CUL DES SARTS","Ensemble du domaine","relation aux autorités publiques",1,null,null,1,{"$f":"Table24[[#This Row],[Domaine]]&\" \" &Table24[[#This Row],[bien]]&\" \" &Table24[[#This Row],[composante]]","v":"CUL DES SARTS Ensemble du domaine relation aux autorités publiques"},{"$f":"IF(Table24[[#This Row],[constat/projet]]=\"\",Table24[[#This Row],[Entretien]],Table24[[#This Row],[constat/projet]])","v":1}]

{"sheet":"TODO LIST","index":1,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["urgence","localisation","constat/projet/entretien","action","responsable","échéance","Loca / action"]
[null,null,null,null,null,null,{"$f":"IFERROR(Table1[[#This Row],[localisation]]&\" \"&Table1[[#This Row],[constat/projet/entretien]],\"\")","v":" "}]
[null,null,null,null,null,null,{"$f":"IFERROR(Table1[[#This Row],[localisation]]&\" \"&Table1[[#This Row],[constat/projet/entretien]],\"\")","v":" "}]
[null,null,null,null,null,null,{"$f":"IFERROR(Table1[[#This Row],[localisation]]&\" \"&Table1[[#This Row],[constat/projet/entretien]],\"\")","v":" "}]
[null,null,null,null,null,null,{"$f":"IFERROR(Table1[[#This Row],[localisation]]&\" \"&Table1[[#This Row],[constat/projet/entretien]],\"\")","v":" "}]
[null,null,null,null,null,null,{"$f":"IFERROR(Table1[[#This Row],[localisation]]&\" \"&Table1[[#This Row],[constat/projet/entretien]],\"\")","v":" "}]

{"sheet":"suivi des dossiers","index":2,"n_rows":8,"n_cols":20,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["responsable","localisation","constat/projet/entretien","action","échéance","état d'avancement","infos détaillées"]
[{"$f":"IFERROR(OFFSET('TODO LIST'!$G$1,MATCH(Table4[[#This Row],[localisation]]& \" \" &Table4[[#This Row],[constat/projet/entretien]],'TODO LIST'!G:G,0)-1,-2,,),\"\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[{"$f":"IFERROR(OFFSET('TODO LIST'!$G$1,MATCH(Table4[[#This Row],[localisation]]& \" \" &Table4[[#This Row],[constat/projet/entretien]],'TODO LIST'!G:G,0)-1,-2,,),\"\")","v":0}]
[{"$f":"IFERROR(OFFSET('TODO LIST'!$G$1,MATCH(Table4[[#This Row],[localisation]]& \" \" &Table4[[#This Row],[constat/projet/entretien]],'TODO LIST'!G:G,0)-1,-2,,),\"\")","v":0}]
[{"$f":"IFERROR(OFFSET('TODO LIST'!$G$1,MATCH(Table4[[#This Row],[localisation]]& \" \" &Table4[[#This Row],[constat/projet/entretien]],'TODO LIST'!G:G,0)-1,-2,,),\"\")","v":0}]
[{"$f":"IFERROR(OFFSET('TODO LIST'!$G$1,MATCH(Table4[[#This Row],[localisation]]& \" \" &Table4[[#This Row],[constat/projet/entretien]],'TODO LIST'!G:G,0)-1,-2,,),\"\")","v":0}]
[{"$f":"IFERROR(OFFSET('TODO LIST'!$G$1,MATCH(Table4[[#This Row],[localisation]]& \" \" &Table4[[#This Row],[constat/projet/entretien]],'TODO LIST'!G:G,0)-1,-2,,),\"\")","v":0}]
[{"$f":"IFERROR(OFFSET('TODO LIST'!$G$1,MATCH(Table4[[#This Row],[localisation]]& \" \" &Table4[[#This Row],[constat/projet/entretien]],'TODO LIST'!G:G,0)-1,-2,,),\"\")","v":0}]

{"sheet":"Param Constats","index":3,"n_rows":22,"n_cols":34,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Domaine",null,"Heure","Itre","CUL DES SARTS","PDH 38","PDH 39",null,null,"Heure Ensemble du domaine","Heure Le Grand Chalet","Heure La Carlingue","Heure Bureaux","Heure Prairies","Heure ancien bloc sanitaire","Itre Ensemble du domaine","Itre Bâtiments","Itre Extérieur","CUL DES SARTS Ensemble du domaine","CUL DES SARTS Batiment","CUL DES SARTS Extérieur","PDH 38 Tout le bâtiment","PDH 38 caves","PDH 38 Rez","PDH 38 Premier","PDH 38 deuxième","PDH 38 troisième","PDH 39 Tout le bâtiment","PDH 39 caves","PDH 39 garages","PDH 39 rez","PDH 39 premier","PDH 39 deuxième","PDH 39 troisième"]
["Heure",null,"Ensemble du domaine","Ensemble du domaine","Ensemble du domaine","Tout le bâtiment","Tout le bâtiment",null,null,"travail administratif","général","général","général","général","général","travail administratif","général","général","travail administratif","général","abords extérieurs du bâtiment","travail administratif","chaudière et chauffage","menuiserie","menuiserie","menuiserie","menuiserie","travail administratif","chaudière et chauffage","garage SGP","menuiserie","menuiserie","menuiserie","menuiserie"]
["Itre",null,"Le Grand Chalet","Bâtiments","Batiment","caves","caves",null,null,"relation aux autorités publiques","abords extérieurs","abords extérieurs","abords extérieurs","Paturins","abords extérieurs","relation aux autorités publiques","isolation","abords des bâtiments","relation aux autorités publiques","isolation","terrasse arrière","relation aux autorités publiques","archives","plomberie et évacuation des eaux","plomberie et évacuation des eaux","plomberie et évacuation des eaux","plomberie et évacuation des eaux","relation aux autorités publiques","salles de rangement","garage CEMEA","plomberie et évacuation des eaux","plomberie et évacuation des eaux","plomberie et évacuation des eaux","plomberie et évacuation des eaux"]
["CUL DES SARTS",null,"La Carlingue","Extérieur","Extérieur","Rez","garages",null,null,"chemins","terasse","murs extérieurs","toiture","Epicéas","murs","chemins","menuiserie","murs extérieurs","chemins","menuiserie","murs extérieurs","projets","autre","électricité","électricité","électricité","électricité","projets","atelier","sanitaire","électricité","électricité","électricité","électricité"]
["PDH 38",null,"Bureaux",null,null,"Premier","rez",null,null,"parkings","murs extérieurs","toiture","isolation","Wood-Badge","toiture","parkings","électricité","toiture","parkings","électricité","toiture","toiture",null,"pièce à rue","bureau AISG","appartement SGP (cuisine)","projet","toiture","autre","autre","Magascout","bureau SF","grande salle de réunion","bureaux CEMEA"]
["PDH 39",null,"Prairies",null,null,"deuxième","premier",null,null,"bois","toiture","isolation","murs extérieurs","Bouleaux","dalle de béton","autre","chaudière et chauffage","prairie","autre","chaudière et chauffage","bois","murs extérieurs",null,"sanitaires","appartement (cuisine)","appartement SGP (pièce de vie)","autre","murs extérieurs",null,null,"atelier du magascout","bureau CF et graphiste","petite salle de réunion","archives CEMEA"]
[null,null,"ancien bloc sanitaire",null,null,"troisième","deuxième",null,null,"étang et abords de rivière","isolation","menuiserie","menuiserie","Chênes","projet",null,"plomberie et évacuation des eaux","citerne à gaz",null,"plomberie et évacuation des eaux","prairie","isolation",null,"pièce derrière les sanitaires","appartement (pièce de vie)","appartement SGP (dortoirs)",null,"isolation",null,null,"matériel de bureau","bureau Rédac","salle SGAB","autre"]
[null,null,null,null,null,null,"troisième",null,null,"toilettes sèches","menuiserie","électricité","électricité","autre","autre",null,"réfectoire","feux de camp",null,"pièce d'accueil","BBQ","cage d'escalier",null,"pièce communiquant à la cuisine SGP","appartement (chambre)","appartement SGP (salle de bains)",null,"cour",null,null,"autre","bureau SUCR et GRH","réfectoire et pièce de jeux des CEMEA"]
[null,null,null,null,null,null,null,null,null,"autre","électricité","citerne à gaz","sas d'entrée",null,null,null,"cuisine","évacuation des eaux de pluie",null,"lavoir","citerne à gaz","autre",null,"autre","appartement (salle de Bains)","matériel et literie",null,"cage d'escalier",null,null,null,"bureau RH, comptabilité et affiliations","autre"]
[null,null,null,null,null,null,null,null,null,null,"citerne à gaz","chaudière et chauffage","bureau",null,null,null,"dortoirs","autre",null,"grande salle","sanitaires extérieurs",null,null,null,"autre","autre",null,"autre",null,null,null,"salle papier"]
[null,null,null,null,null,null,null,null,null,null,"chaudière et chauffage","plomberie et évacuation des eaux","matériel de bureau",null,null,null,"sanitaires",null,null,"réfectoire","autre",null,null,null,null,null,null,null,null,null,null,"salle bibliothèque-costumothèque"]
[null,null,null,null,null,null,null,null,null,null,"plomberie et évacuation des eaux","réfectoire","autre",null,null,null,"matériel et literie",null,null,"cuisine",null,null,null,null,null,null,null,null,null,null,null,"cuisine"]
[null,null,null,null,null,null,null,null,null,null,"réfectoire","cuisine",null,null,null,null,"autre",null,null,"réserve frigos",null,null,null,null,null,null,null,null,null,null,null,"matériel de bureau"]
[null,null,null,null,null,null,null,null,null,null,"cuisine","dortoirs",null,null,null,null,null,null,null,"petit dortoir du rez",null,null,null,null,null,null,null,null,null,null,null,"matériel de cuisine"]
[null,null,null,null,null,null,null,null,null,null,"dortoirs","sanitaires",null,null,null,null,null,null,null,"dortoirs du 1er",null,null,null,null,null,null,null,null,null,null,null,"sanitaires"]
[null,null,null,null,null,null,null,null,null,null,"sanitaires","matériel et literie",null,null,null,null,null,null,null,"salle papotte",null,null,null,null,null,null,null,null,null,null,null,"autre"]
[null,null,null,null,null,null,null,null,null,null,"salle du sous-sol","autre",null,null,null,null,null,null,null,"sanitaires"]
[null,null,null,null,null,null,null,null,null,null,"matériel et literie",null,null,null,null,null,null,null,null,"infirmerie"]
[null,null,null,null,null,null,null,null,null,null,"autre",null,null,null,null,null,null,null,null,"réserve matériel et clefs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"grenier"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"matériel et literie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"autre"]

{"sheet":"Concaténation","index":4,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Row Labels","Localisation","Constat/Projet ou Entretien"]
[1,"Heure  ","toto"]
[1,"PDH 38 deuxième appartement SGP (salle de bains)","toto"]
[1,"CUL DES SARTS Ensemble du domaine relation aux autorités publiques",1]
[2,"PDH 38 deuxième appartement SGP (salle de bains)","toto"]
[3,"Heure Ensemble du domaine ","jardinage"]
[3,"Itre Bâtiments ","toto"]
["(blank)","(blank)","(blank)"]