{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["P7 (18 septembre au 15 octobre)"],"not_rendered":{"charts":0,"images":3,"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":"P7 (18 septembre au 15 octobre)","index":0,"n_rows":62,"n_cols":13,"rows_kept":62,"cut":false,"hidden":false,"merged":[[32,6,32,7],[34,6,34,7],[56,4,56,6],[56,7,56,8],[39,6,39,7]]}
["Période 7  (18 septembre au 15 octobre)"]
[]
["Date de référence","# Dossier","Nom du client","Territoire","Priorité","Client connu","Provenance de la demande","Motif de la demande","Statut","Date prise en charge","Nom de l'intervenant assigné","Autres","Délai d'attente"]
[null,null,null,null,null,null,null,null,{"$f":"IF(A4=\"\",\"\",IF(J4<=0,\"En attente\",\"Pris en charge\"))","v":""},null,null,null,{"$f":"IF(A4=\"\",\"\",(TODAY()-(A4+IF(E4=\"P1\",2,IF(E4=\"P2\",10,IF(E4=\"P3\",21,IF(E4=\"P4\",91,IF(E4=\"P5\",183))))))))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(A5=\"\",\"\",IF(J5<=0,\"En attente\",\"Pris en charge\"))","v":""},null,null,null,{"$f":"IF(A5=\"\",\"\",(TODAY()-(A5+IF(E5=\"P1\",2,IF(E5=\"P2\",10,IF(E5=\"P3\",21,IF(E5=\"P4\",91,IF(E5=\"P5\",183))))))))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(A6=\"\",\"\",IF(J6<=0,\"En attente\",\"Pris en charge\"))","v":""},null,null,null,{"$f":"IF(A6=\"\",\"\",(TODAY()-(A6+IF(E6=\"P1\",2,IF(E6=\"P2\",10,IF(E6=\"P3\",21,IF(E6=\"P4\",91,IF(E6=\"P5\",183))))))))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(A7=\"\",\"\",IF(J7<=0,\"En attente\",\"Pris en charge\"))","v":""},null,null,null,{"$f":"IF(A7=\"\",\"\",(TODAY()-(A7+IF(E7=\"P1\",2,IF(E7=\"P2\",10,IF(E7=\"P3\",21,IF(E7=\"P4\",91,IF(E7=\"P5\",183))))))))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(A8=\"\",\"\",IF(J8<=0,\"En attente\",\"Pris en charge\"))","v":""},null,null,null,{"$f":"IF(A8=\"\",\"\",(TODAY()-(A8+IF(E8=\"P1\",2,IF(E8=\"P2\",10,IF(E8=\"P3\",21,IF(E8=\"P4\",91,IF(E8=\"P5\",183))))))))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(A9=\"\",\"\",IF(J9<=0,\"En attente\",\"Pris en charge\"))","v":""},null,null,null,{"$f":"IF(A9=\"\",\"\",(TODAY()-(A9+IF(E9=\"P1\",2,IF(E9=\"P2\",10,IF(E9=\"P3\",21,IF(E9=\"P4\",91,IF(E9=\"P5\",183))))))))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(A10=\"\",\"\",IF(J10<=0,\"En attente\",\"Pris en charge\"))","v":""},null,null,null,{"$f":"IF(A10=\"\",\"\",(TODAY()-(A10+IF(E10=\"P1\",2,IF(E10=\"P2\",10,IF(E10=\"P3\",21,IF(E10=\"P4\",91,IF(E10=\"P5\",183))))))))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(A11=\"\",\"\",IF(J11<=0,\"En attente\",\"Pris en charge\"))","v":""},null,null,null,{"$f":"IF(A11=\"\",\"\",(TODAY()-(A11+IF(E11=\"P1\",2,IF(E11=\"P2\",10,IF(E11=\"P3\",21,IF(E11=\"P4\",91,IF(E11=\"P5\",183))))))))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(A12=\"\",\"\",IF(J12<=0,\"En attente\",\"Pris en charge\"))","v":""},null,null,null,{"$f":"IF(A12=\"\",\"\",(TODAY()-(A12+IF(E12=\"P1\",2,IF(E12=\"P2\",10,IF(E12=\"P3\",21,IF(E12=\"P4\",91,IF(E12=\"P5\",183))))))))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(A13=\"\",\"\",IF(J13<=0,\"En attente\",\"Pris en charge\"))","v":""},null,null,null,{"$f":"IF(A13=\"\",\"\",(TODAY()-(A13+IF(E13=\"P1\",2,IF(E13=\"P2\",10,IF(E13=\"P3\",21,IF(E13=\"P4\",91,IF(E13=\"P5\",183))))))))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(A14=\"\",\"\",IF(J14<=0,\"En attente\",\"Pris en charge\"))","v":""},null,null,null,{"$f":"IF(A14=\"\",\"\",(TODAY()-(A14+IF(E14=\"P1\",2,IF(E14=\"P2\",10,IF(E14=\"P3\",21,IF(E14=\"P4\",91,IF(E14=\"P5\",183))))))))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(A15=\"\",\"\",IF(J15<=0,\"En attente\",\"Pris en charge\"))","v":""},null,null,null,{"$f":"IF(A15=\"\",\"\",(TODAY()-(A15+IF(E15=\"P1\",2,IF(E15=\"P2\",10,IF(E15=\"P3\",21,IF(E15=\"P4\",91,IF(E15=\"P5\",183))))))))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(A16=\"\",\"\",IF(J16<=0,\"En attente\",\"Pris en charge\"))","v":""},null,null,null,{"$f":"IF(A16=\"\",\"\",(TODAY()-(A16+IF(E16=\"P1\",2,IF(E16=\"P2\",10,IF(E16=\"P3\",21,IF(E16=\"P4\",91,IF(E16=\"P5\",183))))))))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(A17=\"\",\"\",IF(J17<=0,\"En attente\",\"Pris en charge\"))","v":""},null,null,null,{"$f":"IF(A17=\"\",\"\",(TODAY()-(A17+IF(E17=\"P1\",2,IF(E17=\"P2\",10,IF(E17=\"P3\",21,IF(E17=\"P4\",91,IF(E17=\"P5\",183))))))))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(A18=\"\",\"\",IF(J18<=0,\"En attente\",\"Pris en charge\"))","v":""},null,null,null,{"$f":"IF(A18=\"\",\"\",(TODAY()-(A18+IF(E18=\"P1\",2,IF(E18=\"P2\",10,IF(E18=\"P3\",21,IF(E18=\"P4\",91,IF(E18=\"P5\",183))))))))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(A19=\"\",\"\",IF(J19<=0,\"En attente\",\"Pris en charge\"))","v":""},null,null,null,{"$f":"IF(A19=\"\",\"\",(TODAY()-(A19+IF(E19=\"P1\",2,IF(E19=\"P2\",10,IF(E19=\"P3\",21,IF(E19=\"P4\",91,IF(E19=\"P5\",183))))))))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(A20=\"\",\"\",IF(J20<=0,\"En attente\",\"Pris en charge\"))","v":""},null,null,null,{"$f":"IF(A20=\"\",\"\",(TODAY()-(A20+IF(E20=\"P1\",2,IF(E20=\"P2\",10,IF(E20=\"P3\",21,IF(E20=\"P4\",91,IF(E20=\"P5\",183))))))))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(A21=\"\",\"\",IF(J21<=0,\"En attente\",\"Pris en charge\"))","v":""},null,null,null,{"$f":"IF(A21=\"\",\"\",(TODAY()-(A21+IF(E21=\"P1\",2,IF(E21=\"P2\",10,IF(E21=\"P3\",21,IF(E21=\"P4\",91,IF(E21=\"P5\",183))))))))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(A22=\"\",\"\",IF(J22<=0,\"En attente\",\"Pris en charge\"))","v":""},null,null,null,{"$f":"IF(A22=\"\",\"\",(TODAY()-(A22+IF(E22=\"P1\",2,IF(E22=\"P2\",10,IF(E22=\"P3\",21,IF(E22=\"P4\",91,IF(E22=\"P5\",183))))))))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(A23=\"\",\"\",IF(J23<=0,\"En attente\",\"Pris en charge\"))","v":""},null,null,null,{"$f":"IF(A23=\"\",\"\",(TODAY()-(A23+IF(E23=\"P1\",2,IF(E23=\"P2\",10,IF(E23=\"P3\",21,IF(E23=\"P4\",91,IF(E23=\"P5\",183))))))))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(A24=\"\",\"\",IF(J24<=0,\"En attente\",\"Pris en charge\"))","v":""},null,null,null,{"$f":"IF(A24=\"\",\"\",(TODAY()-(A24+IF(E24=\"P1\",2,IF(E24=\"P2\",10,IF(E24=\"P3\",21,IF(E24=\"P4\",91,IF(E24=\"P5\",183))))))))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(A25=\"\",\"\",IF(J25<=0,\"En attente\",\"Pris en charge\"))","v":""},null,null,null,{"$f":"IF(A25=\"\",\"\",(TODAY()-(A25+IF(E25=\"P1\",2,IF(E25=\"P2\",10,IF(E25=\"P3\",21,IF(E25=\"P4\",91,IF(E25=\"P5\",183))))))))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(A26=\"\",\"\",IF(J26<=0,\"En attente\",\"Pris en charge\"))","v":""},null,null,null,{"$f":"IF(A26=\"\",\"\",(TODAY()-(A26+IF(E26=\"P1\",2,IF(E26=\"P2\",10,IF(E26=\"P3\",21,IF(E26=\"P4\",91,IF(E26=\"P5\",183))))))))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(A27=\"\",\"\",IF(J27<=0,\"En attente\",\"Pris en charge\"))","v":""},null,null,null,{"$f":"IF(A27=\"\",\"\",(TODAY()-(A27+IF(E27=\"P1\",2,IF(E27=\"P2\",10,IF(E27=\"P3\",21,IF(E27=\"P4\",91,IF(E27=\"P5\",183))))))))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(A28=\"\",\"\",IF(J28<=0,\"En attente\",\"Pris en charge\"))","v":""},null,null,null,{"$f":"IF(A28=\"\",\"\",(TODAY()-(A28+IF(E28=\"P1\",2,IF(E28=\"P2\",10,IF(E28=\"P3\",21,IF(E28=\"P4\",91,IF(E28=\"P5\",183))))))))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(A29=\"\",\"\",IF(J29<=0,\"En attente\",\"Pris en charge\"))","v":""},null,null,null,{"$f":"IF(A29=\"\",\"\",(TODAY()-(A29+IF(E29=\"P1\",2,IF(E29=\"P2\",10,IF(E29=\"P3\",21,IF(E29=\"P4\",91,IF(E29=\"P5\",183))))))))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(A30=\"\",\"\",IF(J30<=0,\"En attente\",\"Pris en charge\"))","v":""},null,null,null,{"$f":"IF(A30=\"\",\"\",(TODAY()-(A30+IF(E30=\"P1\",2,IF(E30=\"P2\",10,IF(E30=\"P3\",21,IF(E30=\"P4\",91,IF(E30=\"P5\",183))))))))","v":""}]
["Récapitulatif de la période 4"]
[]
[{"$f":"COUNTA(A4:A30)","v":0},"Total",null,null,null,null,"Total liste d'attente ",null,{"$f":"COUNTIF(I4:I30, \"En attente\")","v":0}]
[]
[{"$f":"A33-A37","v":0},"Nouvelles incriptions",null,null,null,null,"Prise en charge",null,{"$f":"COUNTIF(I4:I30, \"Pris en charge\")","v":0}]
[null,null,null,null,null,null,null," "]
[0,"Transfert de la liste d'attente Période 3"]
[]
[]
["Priorité 1",{"$f":"COUNTIF(E4:E30,\"P1\")","v":0},null,null,null,null,"NB de prise en charge par Intervenant"]
["Priorité 2",{"$f":"COUNTIF(E4:E30,\"P2\")","v":0},null,null,null,null,"Maria Pardo",{"$f":"COUNTIF(K4:K30,\"Pardo, Maria\")","v":0}]
["Priorité 3",{"$f":"COUNTIF(E4:E30,\"P3\")","v":0},null,null,null,null,"Lili-Fleur Blackburn",{"$f":"COUNTIF(K4:K30,\"Blackburn, Lili-Fleur\")","v":0}]
["Priorité 4",{"$f":"COUNTIF(E4:E30,\"P4\")","v":0},null,null,null,null,"Marie-Élaine Bourdon",{"$f":"COUNTIF(K5:K31,\"Bourdon, Marie-Élaine\")","v":0}]
["Priorité 5",{"$f":"COUNTIF(E4:E30,\"P5\")","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Priorité","Non connu","Territoire","Motif de la demande",null,null,"Intervenants"]
[null,"P1","Oui","Rosemont EST"]
[null,"P2","Non","Rosemont Ouest"]
[null,"P3",null,"Olivier-Guimonf"]
[null,"P4",null,"Hochelaga-Maisonneuve"]
[null,"P5"]