{"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":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Domaine","bien","composante","constat/projet","Entretien","Dates prévues","priorité","Localisation","Constat/Projet ou Entretien"]
["Heure","Ensemble du domaine","relation aux autorités publiques","dossier bourgmestre",null,null,2,{"$f":"Table24[[#This Row],[Domaine]]&\" \" &Table24[[#This Row],[bien]]&\" \" &Table24[[#This Row],[composante]]","v":"Heure 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":"dossier bourgmestre"}]
["Heure","Le Grand Chalet","menuiserie",null,"nettoyage des vitres","2016-04-20",{"$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":"Heure Le Grand Chalet menuiserie"},{"$f":"IF(Table24[[#This Row],[constat/projet]]=\"\",Table24[[#This Row],[Entretien]],Table24[[#This Row],[constat/projet]])","v":"nettoyage des vitres"}]
["Heure","Prairies","Paturins",null,"tondre","2016-06-09",{"$f":"IF(Table24[[#This Row],[Dates prévues]]=\"\",\"\", IF(Table24[[#This Row],[Dates prévues]]-15<TODAY(),1,3) )","v":3},{"$f":"Table24[[#This Row],[Domaine]]&\" \" &Table24[[#This Row],[bien]]&\" \" &Table24[[#This Row],[composante]]","v":"Heure Prairies Paturins"},{"$f":"IF(Table24[[#This Row],[constat/projet]]=\"\",Table24[[#This Row],[Entretien]],Table24[[#This Row],[constat/projet]])","v":"tondre"}]
["Itre","Bâtiments","électricité","court circuit",null,null,2,{"$f":"Table24[[#This Row],[Domaine]]&\" \" &Table24[[#This Row],[bien]]&\" \" &Table24[[#This Row],[composante]]","v":"Itre Bâtiments électricité"},{"$f":"IF(Table24[[#This Row],[constat/projet]]=\"\",Table24[[#This Row],[Entretien]],Table24[[#This Row],[constat/projet]])","v":"court circuit"}]
["PDH 38","troisième","projet","création d'un appart",null,null,1,{"$f":"Table24[[#This Row],[Domaine]]&\" \" &Table24[[#This Row],[bien]]&\" \" &Table24[[#This Row],[composante]]","v":"PDH 38 troisième projet"},{"$f":"IF(Table24[[#This Row],[constat/projet]]=\"\",Table24[[#This Row],[Entretien]],Table24[[#This Row],[constat/projet]])","v":"création d'un appart"}]
["CUL DES SARTS","Extérieur","BBQ","retaper le bbq",null,null,2,{"$f":"Table24[[#This Row],[Domaine]]&\" \" &Table24[[#This Row],[bien]]&\" \" &Table24[[#This Row],[composante]]","v":"CUL DES SARTS Extérieur BBQ"},{"$f":"IF(Table24[[#This Row],[constat/projet]]=\"\",Table24[[#This Row],[Entretien]],Table24[[#This Row],[constat/projet]])","v":"retaper le bbq"}]
["CUL DES SARTS","Ensemble du domaine","travail administratif","prévoir vente",null,null,1,{"$f":"Table24[[#This Row],[Domaine]]&\" \" &Table24[[#This Row],[bien]]&\" \" &Table24[[#This Row],[composante]]","v":"CUL DES SARTS Ensemble du domaine travail administratif"},{"$f":"IF(Table24[[#This Row],[constat/projet]]=\"\",Table24[[#This Row],[Entretien]],Table24[[#This Row],[constat/projet]])","v":"prévoir vente"}]
["PDH 39","caves","chaudière et chauffage","chaudière s'éteint",null,null,1,{"$f":"Table24[[#This Row],[Domaine]]&\" \" &Table24[[#This Row],[bien]]&\" \" &Table24[[#This Row],[composante]]","v":"PDH 39 caves chaudière et chauffage"},{"$f":"IF(Table24[[#This Row],[constat/projet]]=\"\",Table24[[#This Row],[Entretien]],Table24[[#This Row],[constat/projet]])","v":"chaudière s'éteint"}]
["PDH 39","caves","chaudière et chauffage",null,"entretien annuel","2016-05-25",{"$f":"IF(Table24[[#This Row],[Dates prévues]]=\"\",\"\", IF(Table24[[#This Row],[Dates prévues]]-15<TODAY(),1,3) )","v":3},{"$f":"Table24[[#This Row],[Domaine]]&\" \" &Table24[[#This Row],[bien]]&\" \" &Table24[[#This Row],[composante]]","v":"PDH 39 caves chaudière et chauffage"},{"$f":"IF(Table24[[#This Row],[constat/projet]]=\"\",Table24[[#This Row],[Entretien]],Table24[[#This Row],[constat/projet]])","v":"entretien annuel"}]
[null,null,null,null,null,null,{"$f":"IF(Table24[[#This Row],[Dates prévues]]=\"\",\"\", IF(Table24[[#This Row],[Dates prévues]]-15<TODAY(),1,3) )","v":""},{"$f":"Table24[[#This Row],[Domaine]]&\" \" &Table24[[#This Row],[bien]]&\" \" &Table24[[#This Row],[composante]]","v":"  "},{"$f":"IF(Table24[[#This Row],[constat/projet]]=\"\",Table24[[#This Row],[Entretien]],Table24[[#This Row],[constat/projet]])","v":0}]

{"sheet":"TODO LIST","index":1,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["urgence","localisation","constat/projet/entretien","action","responsable","échéance","Loca / action"]
[1,"PDH 39 caves chaudière et chauffage","chaudière s'éteint",null,null,{"$f":"IFERROR(IF(OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)=\"\",\"\",OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)),\"\")","v":"2016-05-25"},{"$f":"IFERROR(Table1[[#This Row],[localisation]]&\" \"&Table1[[#This Row],[constat/projet/entretien]],\"\")","v":"PDH 39 caves chaudière et chauffage chaudière s'éteint"}]
[1,"Heure Le Grand Chalet menuiserie","nettoyage des vitres","appeler société nettoyage","milos",{"$f":"IFERROR(IF(OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)=\"\",\"\",OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)),\"\")","v":"2016-06-09"},{"$f":"IFERROR(Table1[[#This Row],[localisation]]&\" \"&Table1[[#This Row],[constat/projet/entretien]],\"\")","v":"Heure Le Grand Chalet menuiserie nettoyage des vitres"}]
[1,"CUL DES SARTS Ensemble du domaine travail administratif","prévoir vente",null,null,{"$f":"IFERROR(IF(OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)=\"\",\"\",OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)),\"\")","v":""},{"$f":"IFERROR(Table1[[#This Row],[localisation]]&\" \"&Table1[[#This Row],[constat/projet/entretien]],\"\")","v":"CUL DES SARTS Ensemble du domaine travail administratif prévoir vente"}]
[1,"PDH 38 troisième projet","création d'un appart","monter dossier","greg",{"$f":"IFERROR(IF(OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)=\"\",\"\",OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)),\"\")","v":""},{"$f":"IFERROR(Table1[[#This Row],[localisation]]&\" \"&Table1[[#This Row],[constat/projet/entretien]],\"\")","v":"PDH 38 troisième projet création d'un appart"}]
[2,"Heure Ensemble du domaine relation aux autorités publiques","dossier bourgmestre",null,null,{"$f":"IFERROR(IF(OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)=\"\",\"\",OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)),\"\")","v":"2016-04-20"},{"$f":"IFERROR(Table1[[#This Row],[localisation]]&\" \"&Table1[[#This Row],[constat/projet/entretien]],\"\")","v":"Heure Ensemble du domaine relation aux autorités publiques dossier bourgmestre"}]
[2,"Itre Bâtiments électricité","court circuit",null,null,{"$f":"IFERROR(IF(OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)=\"\",\"\",OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)),\"\")","v":""},{"$f":"IFERROR(Table1[[#This Row],[localisation]]&\" \"&Table1[[#This Row],[constat/projet/entretien]],\"\")","v":"Itre Bâtiments électricité court circuit"}]
[2,"CUL DES SARTS Extérieur BBQ","retaper le bbq",null,null,{"$f":"IFERROR(IF(OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)=\"\",\"\",OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)),\"\")","v":""},{"$f":"IFERROR(Table1[[#This Row],[localisation]]&\" \"&Table1[[#This Row],[constat/projet/entretien]],\"\")","v":"CUL DES SARTS Extérieur BBQ retaper le bbq"}]
[3,"PDH 39 caves chaudière et chauffage","entretien annuel",null,null,{"$f":"IFERROR(IF(OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)=\"\",\"\",OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)),\"\")","v":"2016-05-25"},{"$f":"IFERROR(Table1[[#This Row],[localisation]]&\" \"&Table1[[#This Row],[constat/projet/entretien]],\"\")","v":"PDH 39 caves chaudière et chauffage entretien annuel"}]
[3,"Heure Prairies Paturins","tondre",null,null,{"$f":"IFERROR(IF(OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)=\"\",\"\",OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)),\"\")","v":""},{"$f":"IFERROR(Table1[[#This Row],[localisation]]&\" \"&Table1[[#This Row],[constat/projet/entretien]],\"\")","v":"Heure Prairies Paturins tondre"}]
[null,null,null,null,null,{"$f":"IFERROR(IF(OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)=\"\",\"\",OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)),\"\")","v":""},{"$f":"IFERROR(Table1[[#This Row],[localisation]]&\" \"&Table1[[#This Row],[constat/projet/entretien]],\"\")","v":" "}]
[null,null,null,null,null,{"$f":"IFERROR(IF(OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)=\"\",\"\",OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)),\"\")","v":""},{"$f":"IFERROR(Table1[[#This Row],[localisation]]&\" \"&Table1[[#This Row],[constat/projet/entretien]],\"\")","v":" "}]
[null,null,null,null,null,{"$f":"IFERROR(IF(OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)=\"\",\"\",OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)),\"\")","v":""},{"$f":"IFERROR(Table1[[#This Row],[localisation]]&\" \"&Table1[[#This Row],[constat/projet/entretien]],\"\")","v":" "}]
[null,null,null,null,null,{"$f":"IFERROR(IF(OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)=\"\",\"\",OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)),\"\")","v":""},{"$f":"IFERROR(Table1[[#This Row],[localisation]]&\" \"&Table1[[#This Row],[constat/projet/entretien]],\"\")","v":" "}]
[null,null,null,null,null,{"$f":"IFERROR(IF(OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)=\"\",\"\",OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)),\"\")","v":""},{"$f":"IFERROR(Table1[[#This Row],[localisation]]&\" \"&Table1[[#This Row],[constat/projet/entretien]],\"\")","v":" "}]
[null,null,null,null,null,{"$f":"IFERROR(IF(OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)=\"\",\"\",OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)),\"\")","v":""},{"$f":"IFERROR(Table1[[#This Row],[localisation]]&\" \"&Table1[[#This Row],[constat/projet/entretien]],\"\")","v":" "}]
[null,null,null,null,null,{"$f":"IFERROR(IF(OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)=\"\",\"\",OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)),\"\")","v":""},{"$f":"IFERROR(Table1[[#This Row],[localisation]]&\" \"&Table1[[#This Row],[constat/projet/entretien]],\"\")","v":" "}]
[null,null,null,null,null,{"$f":"IFERROR(IF(OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)=\"\",\"\",OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)),\"\")","v":""},{"$f":"IFERROR(Table1[[#This Row],[localisation]]&\" \"&Table1[[#This Row],[constat/projet/entretien]],\"\")","v":" "}]
[null,null,null,null,null,{"$f":"IFERROR(IF(OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)=\"\",\"\",OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)),\"\")","v":""},{"$f":"IFERROR(Table1[[#This Row],[localisation]]&\" \"&Table1[[#This Row],[constat/projet/entretien]],\"\")","v":" "}]
[null,null,null,null,null,{"$f":"IFERROR(IF(OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)=\"\",\"\",OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)),\"\")","v":""},{"$f":"IFERROR(Table1[[#This Row],[localisation]]&\" \"&Table1[[#This Row],[constat/projet/entretien]],\"\")","v":" "}]
[null,null,null,null,null,{"$f":"IFERROR(IF(OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)=\"\",\"\",OFFSET('Constats projets Entretiens'!$A$1,MATCH(Table1[[#This Row],[localisation]],'Constats projets Entretiens'!H:H,0),5)),\"\")","v":""},{"$f":"IFERROR(Table1[[#This Row],[localisation]]&\" \"&Table1[[#This Row],[constat/projet/entretien]],\"\")","v":" "}]

{"sheet":"suivi des dossiers","index":2,"n_rows":10,"n_cols":7,"rows_kept":10,"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},"CUL DES SARTS Ensemble du domaine travail administratif","prévoir vente"]
[{"$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},"PDH 39 caves chaudière et chauffage","chaudière s'éteint"]
[{"$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},"Itre Bâtiments électricité","court circuit"]
[{"$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},"Heure Ensemble du domaine relation aux autorités publiques","dossier bourgmestre"]
[{"$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},"CUL DES SARTS Extérieur BBQ","retaper le bbq"]
[{"$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},"Heure Prairies Paturins","tondre"]
[{"$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},"PDH 39 caves chaudière et chauffage","entretien annuel"]
[{"$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":"greg"},"PDH 38 troisième projet","création d'un appart","monter dossier"]
[{"$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":"milos"},"Heure Le Grand Chalet menuiserie","nettoyage des vitres","appeler société nettoyage"]

{"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":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Row Labels","Localisation","Constat/Projet ou Entretien"]
[1,"Heure Le Grand Chalet menuiserie","nettoyage des vitres"]
[1,"PDH 38 troisième projet","création d'un appart"]
[1,"CUL DES SARTS Ensemble du domaine travail administratif","prévoir vente"]
[1,"PDH 39 caves chaudière et chauffage","chaudière s'éteint"]
[2,"Itre Bâtiments électricité","court circuit"]
[2,"Heure Ensemble du domaine relation aux autorités publiques","dossier bourgmestre"]
[2,"CUL DES SARTS Extérieur BBQ","retaper le bbq"]
[3,"Heure Prairies Paturins","tondre"]
[3,"PDH 39 caves chaudière et chauffage","entretien annuel"]
["(blank)","(blank)","(blank)"]