{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Donnée","Variable","Liste complété"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"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":"Donnée","index":0,"n_rows":87,"n_cols":25,"rows_kept":87,"cut":false,"hidden":false,"merged":[[4,0,4,1],[5,0,5,1],[0,3,5,3],[0,5,1,7],[0,12,0,18],[1,11,1,18],[2,6,4,6]]}
[{"$f":"\"2014 Dossier à inspecter - \"&COUNTIFS($B$9:$B$1204,\"*2014-*\",$K$9:$K$1204,\"*inspecter*\")","v":"2014 Dossier à inspecter - 0"},null,{"$f":"\"Dossier en traitement - \"&COUNTIFS($B$9:$B$1204,\"*2014-*\",$K$9:$K$1204,\"<>*complété*\",$K$9:$K$1204,\"<>*inspecter*\")","v":"Dossier en traitement - 0"},{"$f":"\"Nombre de dossier total en traitement \" &COUNTIFS($B$9:$B$1204,\"*2014-*\",$K$9:$K$1204,\"<>*complété*\",$K$9:$K$1204,\"<>*inspecter*\")+COUNTIFS($B$9:$B$1204,\"*2015-*\",$K$9:$K$1204,\"<>*complété*\",$K$9:$K$1204,\"<>*inspecter*\")+COUNTIFS($B$9:$B$1204,\"*2016-*\",$K$9:$K$1204,\"<>*complété*\",$K$9:$K$1204,\"<>*inspecter*\")+COUNTIFS($B$9:$B$1204,\"*2017-*\",$K$9:$K$1204,\"<>*complété*\",$K$9:$K$1204,\"<>*inspecter*\")+COUNTIFS($B$9:$B$1204,\"*2018-*\",$K$9:$K$1204,\"<>*complété*\",$K$9:$K$1204,\"<>*inspecter*\")+COUNTIFS($B$9:$B$1204,\"*2019-*\",$K$9:$K$1204,\"<>*complété*\",$K$9:$K$1204,\"<>*inspecter*\")","v":"Nombre de dossier total en traitement 0"}]
[{"$f":"\"2015 Dossier à inspecter - \"&COUNTIFS($B$9:$B$1204,\"*2015-*\",$K$9:$K$1204,\"*inspecter*\")","v":"2015 Dossier à inspecter - 0"},null,{"$f":"\"Dossier en traitement - \"&COUNTIFS($B$9:$B$1204,\"*2015-*\",$K$9:$K$1204,\"<>*complété*\",$K$9:$K$1204,\"<>*inspecter*\")","v":"Dossier en traitement - 0"}]
[{"$f":"\"2016 Dossier à inspecter - \"&COUNTIFS($B$9:$B$1204,\"*2016-*\",$K$9:$K$1204,\"*inspecter*\")","v":"2016 Dossier à inspecter - 0"},null,{"$f":"\"Dossier en traitement - \"&COUNTIFS($B$9:$B$1204,\"*2016-*\",$K$9:$K$1204,\"<>*complété*\",$K$9:$K$1204,\"<>*inspecter*\")","v":"Dossier en traitement - 0"},null,null,null,{"$f":"\"Selectionner le N°\ndu permis avant\nl'impression\"","v":"Selectionner le N°\ndu permis avant\nl'impression"}]
[{"$f":"\"2017 Dossier à inspecter - \"&COUNTIFS($B$9:$B$1204,\"*2017-*\",$K$9:$K$1204,\"*inspecter*\")","v":"2017 Dossier à inspecter - 0"},null,{"$f":"\"Dossier en traitement - \"&COUNTIFS($B$9:$B$1204,\"*2017-*\",$K$9:$K$1204,\"<>*complété*\",$K$9:$K$1204,\"<>*inspecter*\")","v":"Dossier en traitement - 0"}]
[{"$f":"\"2018 Dossier à inspecter - \"&COUNTIFS($B$9:$B$1204,\"*2018-*\",$K$9:$K$1204,\"*inspecter*\")","v":"2018 Dossier à inspecter - 0"},null,{"$f":"\"Dossier en traitement - \"&COUNTIFS($B$9:$B$1204,\"*2018-*\",$K$9:$K$1204,\"<>*complété*\",$K$9:$K$1204,\"<>*inspecter*\")","v":"Dossier en traitement - 0"}]
[{"$f":"\"2019 Dossier à inspecter - \"&COUNTIFS($B$9:$B$1204,\"*2019-*\",$K$9:$K$1204,\"*inspecter*\")","v":"2019 Dossier à inspecter - 0"},null,{"$f":"\"Dossier en traitement - \"&COUNTIFS($B$9:$B$1204,\"*2019-*\",$K$9:$K$1204,\"<>*complété*\",$K$9:$K$1204,\"<>*inspecter*\")","v":"Dossier en traitement - 0"}]
[]
["N° Dossier","N° Permis","Rue","ville","C.P","Titre","Nom Propriétaire","Responsable","Dépôt de garantie","Date achat terrain","Statut","notes","Arbre","Stationement","Crépis","Gazon","Revêtement","Certificat de localisation","Date fin délais","Date rappel","Colonne2","Délai expirer","Hivernal","Adresse de corespondance","Rappel"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"Complété"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"À inspecter"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Requête à créer"]
[null,null,null,null,null,null,null,null,null,null,"Requête à créer"]
[null,null,null,null,null,null,null,null,null,null,"Requête à créer"]

{"sheet":"Variable","index":1,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Liste des classification dossier"]
[null,null,"À inspecter"]
[null,null,"Complété"]
[null,null,"Rappel envoyé"]
[null,null,"Requête à créer"]
[null,null,"Avis d'infraction à envoyé"]
[null,null,"Constat d'infraction à envoyé"]

{"sheet":"Liste complété","index":2,"n_rows":3,"n_cols":25,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
["N° Dossier","N° Permis","Rue","ville","C.P","Titre","Nom Propriétaire","Responsable","Dépôt de garantie","Date achat terrain","Statut","notes","Arbre","Stationement","Crépis","Gazon","Revêtement","Certificat de localisation","Date fin délais","Date rappel","Colonne2","Délai expirer","Hivernal","Adresse de corespondance","Rappel"]