{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Tout CAS 2","Avis Cas-2","Légende couleur"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"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":"Tout CAS 2","index":0,"n_rows":25,"n_cols":34,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Titre","Prénom","Nom","CoProprio","Appel","Adresse","Ville","Code Postal","CivDe","CivA","Gen","Lien","Voie","Nbr","BR inversé","Visite planifiée","1ère visite","2e visite","3e visite","Date AVIS envoyé","AVIS","Positionné","N/V","FERMÉ OK ","Fermé non-conforme","Modif OK","OK accepté","Refus ou aucun retour","À rappeler","Innondation avril 2017","RDV annulé par direction","Autre rendez-vous nécessaire","Observations","Notes"]
["Madame","Régina","Mills",null,"Madame","69 RUE TERREUR","Storybrook (Nowhere)","J8G 2N8",69,69,"RUE",null,"TERREUR",1]
["Madame","Fée","Clochette",null,"Madame","70 RUE MAGIE","Storybrook (Nowhere)","J8B 5E2",70,70,"RUE",null,"MAGIE",1,null,null,null,null,null,null,"X","F",null,null,null,null,null,null,"Le nouveau f",null,null,null,"Sump pump à installée et sortir à l'ext."]
[null,"Succession Marie Disparue",null,null,null,"71 RUE DE L'OUBLIETTE","Storybrook (Nowhere)","J8B 5E4",71,71,"RUE",null,"DE L'OUBLIETTE",1]
["Madame","Emma","Swan",null,"Madame","74 RUE SAUVEUSE","Storybrook (Nowhere)","J8B 5E2",74,74,"RUE",null,"SAUVEUSE",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BR ok - Pluvial et sanitaire"]
["Madame","Mary-Margaret","Blanchard",null,"Madame","75 RUE DE L'AMOUR","Storybrook (Nowhere)","J8B 5E4",75,75,"RUE",null,"DE L'AMOUR",1,null,null,null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"Sump pump raccordée au sanitaire"]
["Madame","Ruby","Scarlett",null,"Madame","77 RUE LOUP-GAROU","Storybrook (Nowhere)","J8B 5E4",77,77,"RUE",null,"LOUP-GAROU",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"laissé mess.22/08/17 cancellé RDV 23/08 7pm. Laissé mess boite v. 18 oct. Lg "]
["Madame","Cendrillon","Cendrillon",null,"Madame","79 RUE DU SOULIER","Storybrook (Nowhere)","J8B 5E4",79,79,"RUE",null,"DU SOULIER",1,null,null,null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"\"Caper\" tuyau 1 1/2\" vers le sanitaire et complété le BR du renvoi de sump pump vers l'ext./Drain fr. BR à l'ext."]
["Madame","Belle","Bois Dormant",null,"Madame","80 RUE SOMMEIL","Storybrook (Nowhere)","J8B 5E2",80,80,"RUE",null,"SOMMEIL",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BR ok - Pluvial et sanitaire"]
["Madame","Blanche","Neige",null,"Madame","3 RUE DU GRAND-FROID","Storybrook (Nowhere)","J8C 4X4",3,3,"RUE",null,"DU GRAND-FROID",1,null,null,null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"Sump pump raccordée au sanitaire"]
["Monsieur","Trucbine","Gold",null,"Monsieur","4 RUE BROCANTE","Storybrook (Nowhere)","J8C 4X4",4,4,"RUE",null,"BROCANTE",1]
["Monsieur","Kilian","Jones",null,"Monsieur","5 RUE DU BATEAU","Storybrook (Nowhere)","J8C 4X4",5,5,"RUE",null,"DU BATEAU",1,null,null,null,null,null,null,null,"F",null,null,null,null,null,null,null,null,null,null,"Sump pump raccordée au sanitaire"]
["Madame","Fraisinette","Des Baies",null,"Madame","6 RUE PAS-RAPPORT","Storybrook (Nowhere)","J8C 4X4",6,6,"RUE",null,"PAS-RAPPORT",1]
["Monsieur","Jiminy","Criquet",null,"Monsieur","7 RUE DU PSYCHOLOGUE","Storybrook (Nowhere)","J8C 4X4",7,7,"RUE",null,"DU PSYCHOLOGUE",1,null,null,null,null,null,null,"X","F",null,null,null,null,null,null,null,null,null,null,"Sump pump raccordée au sanitaire"]
["Madame","Eva","Cassidy",null,"Madame","8 RUE QUI-SUIS-JE","Storybrook (Nowhere)","J8C 4X4",8,8,"RUE",null,"QUI-SUIS-JE",1]
["Madame","Lucy","Mills",null,"Madame","9 RUE N'IMPORTE-QUOI","Storybrook (Nowhere)","J8C 4X4",9,9,"RUE",null,"N'IMPORTE-QUOI",1,null,null,null,null,null,null,"X","F",null,null,null,null,null,null,null,null,null,null,"Sump pump raccordée au sanitaire"]
["Madame","Jacinda","Des Loups",null,"Madame","10 RUE DU SOULIER","Storybrook (Nowhere)","J8C 4X4",10,10,"RUE",null,"DU SOULIER",1]
["Monsieur","Capitaine","Crochet",null,"Monsieur","12 RUE DU BATEAU","Storybrook (Nowhere)","J8C 4X4",12,12,"RUE",null,"DU BATEAU",1,null,null,null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"Sump pump raccordée au sanitaire"]
["Monsieur","Tenebreux","Rumplestiltskin",null,"Monsieur","15 RUE MAGIE","Storybrook (Nowhere)","J8C 4X5",15,15,"RUE",null,"MAGIE",1]
["Monsieur","August","Pinocchio",null,"Monsieur","20 Avenue EST FORÊT","Storybrook (Nowhere)","J8C 5T8",20,20,"Avenue EST",null,"FORÊT",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sump pump se déverse dans stationnement-OK"]
["Madame","Lady","Trémaine",null,"Madame","116 RUE SOMMEIL","Storybrook (Nowhere)","J8B 5C8",116,116,"RUE",null,"SOMMEIL",1,null,null,null,null,null,null,null,"F",null,null,null,null,null,null,null,null,null,null,"BR pluvial et Sanitaire OK."]
["Monsieur","Archie","Hopper",null,"Monsieur","118 RUE DU PSYCHOLOGUE","Storybrook (Nowhere)","J8B 5C8",118,118,"RUE",null,"DU PSYCHOLOGUE",1]
["Monsieur","Neal","Baelfire",null,"Monsieur","211 RUE SAUVEUSE","Storybrook (Nowhere)","J8B 5E5",211,211,"RUE",null,"SAUVEUSE",1,null,null,null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"Pompe à installer et sortir à l'ext."]
["Monsieur","Robin","Des Bois",null,"Monsieur","215 RUE MARIANNE","Storybrook (Nowhere)","J8B 5E5",215,215,"RUE",null,"MARIANNE",1]
["Monsieur","David","Nolan",null,"Monsieur","219 RUE PRINCE","Storybrook (Nowhere)","J8B 5E5",219,219,"RUE",null,"PRINCE",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pompe se déverse à l'ext."]

{"sheet":"Avis Cas-2","index":1,"n_rows":1,"n_cols":34,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Titre","Prénom","Nom","CoProprio","Appel","Adresse","Ville","Code Postal","CivDe","CivA","Gen","Lien","Voie","Nbr","BR inversé","Visite planifiée","1ère visite","2e visite","3e visite","Date AVIS envoyé","AVIS","Positionné","N/V","FERMÉ OK ","Fermé non-conforme","Modif OK","OK accepté","Refus ou aucun retour","À rappeler","Innondation avril 2017","RDV annulé par direction","Autre rendez-vous nécessaire","Observations","Notes"]

{"sheet":"Légende couleur","index":2,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[13,2,13,3]]}
[]
[]
[]
[null,null,"visite effectuées"]
[]
[null,null,"Refus de visite ou appels répétés aucun retour du citoyen / on laisse tombé la visite"]
[]
[null,null,"Visite prévue à l'agenda"]
[]
[null,null,"OK Accepté"]
[]
[null,null,"à rappeler ou ils vont rappeler"]
[]
[null,null,"Inondations avril 2017"]
[]
[null,null,"RDV Annulé par la direction "]