{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["TCD","BD","SAUVEGARDE","DONNEES","DISPATCH"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"TCD","index":0,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Étiquettes de lignes"," Immeuble"," Chambre"," Aérien"," Facade"," PLP"," Abonné"," Infra"," Nb","Somme de Montant"]
["Cyrille",0,0,4,1,6,2,1,0,0]
["Djamel",16,0,1,0,4,3,1,1,90]
["Madebo",2,1,1,1,5,6,1,0,0]
["Neji",11,1,0,0,4,5,3,1,105]
["Nibenson",6,1,0,1,10,3,0,1,70]
["Nico ",3,2,4,1,11,0,1,0,75]
["Riwan",4,3,0,1,10,0,0,0,90]
["Zakaria",4,1,5,1,5,0,3,0,120]
["Total général",46,9,15,6,55,19,10,3,550]

{"sheet":"BD","index":1,"n_rows":300,"n_cols":31,"rows_kept":300,"cut":false,"hidden":false,"merged":[[0,10,0,11],[1,15,1,16],[2,15,2,16],[3,15,3,16],[0,12,0,13],[30,14,30,19],[0,15,0,16],[0,19,0,21],[22,14,26,16],[1,19,1,21],[18,26,19,27],[21,19,22,21],[20,19,20,21],[18,22,19,23],[29,14,29,19]]}
[null,{"$f":"TODAY()","v":"2021-12-12"},"INTERVENTIONS TECHNICIENS",null,null,null,null,null,null,null,"ECHECS",null,"SAMEDIS",null,null,"TOTAL INTERS MS",null,{"$f":"SUM(E300:L300)","v":160},null,"% REUSSITE :",null,null,{"$f":"SUM(100-Y1)","v":88.125},"%",{"$f":"SUM(R3*100/R1)","v":11.875},14,null,null,"Ne Pas toucher "]
[null,"Date","Tech","Départ","Immeuble","Chambre","Facade","Aérien","PLP","Colonne1","Abonné","Infra","Nb","Montant",null,"Total PLP :",null,{"$f":"SUM(I300)","v":55},null,"% PLP :",null,null,{"$f":"SUM(R2*100/R1)","v":34.375},"%",null,26,null,null,13,"CYRILLE",1]
[null,"mercredi 1 déc 21","Madebo",29,"","","",1,"",0,1,"","","",null,"Total échec abonné :",null,{"$f":"SUM(K300)","v":19},null,null,null,null,null,null,null,null,null,null,{"$f":"AC2*100/R1","v":8.125},"DJAMEL",2]
[null,"mercredi 1 déc 21","Neji",29,3,"","","","",0,5,"","","",null,"Total échec infra :",null,{"$f":"SUM(L300)","v":10},null,null,null,null,null,null,null,null,null,null,null,"ERIC",3]
[null,"jeudi 2 déc 21","Madebo",29,"","",1,"",1,0,5,"","","",null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANAS",4]
[null,"jeudi 2 déc 21","Riwan",29,"","","","",2,0,"","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MADEBO",5]
[null,"jeudi 2 déc 21","Zakaria",29,"",1,"","",1,0,"","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RIWAN"]
[null,"jeudi 2 déc 21","Nibenson",29,1,"","","",1,0,1,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TARAK"]
[null,"vendredi 3 déc 21","Zakaria",29,1,"","",1,"",0,"",1,"",""]
[null,"vendredi 3 déc 21","Djamel",29,1,"","",1,1,0,1,"","",""]
[null,"vendredi 3 déc 21","Nico ",29,"","","","",2,0,"","","",""]
[null,"vendredi 3 déc 21","Neji",29,1,"","","",1,0,"","","",""]
[null,"samedi 4 déc 21","Djamel","------------",2,"","","",1,0,"","",1,90]
[null,"samedi 4 déc 21","Nibenson","------------",2,"","","",5,0,1,"",1,70]
[null,"samedi 4 déc 21","Neji","------------",3,"","","","",0,"",3,1,105]
[null,"lundi 6 déc 21","Riwan",29,"","","","",4,0,"","","","",null,null,null,null,null,null,null,null,{"$f":"SUM(Y7:Y10)","v":0}]
[null,"lundi 6 déc 21","Nico ",29,1,"","",2,1,0,"","","",""]
[null,"lundi 6 déc 21","Cyrille",29,"","","",1,2,0,"","","",""]
[null,"lundi 6 déc 21","Djamel",29,4,"","","","",0,"","","",""]
[null,"lundi 6 déc 21","Zakaria",29,"","","",2,1,0,"","","",""]
[null,"lundi 6 déc 21","Nibenson",29,"","",1,"",1,0,1,"","",""]
[null,"lundi 6 déc 21","Madebo",29,"","","","",3,0,"","","",""]
[null,"mardi 7 déc 21","Zakaria",29,"","","",1,"",0,"",2,"",""]
[null,"mardi 7 déc 21","Riwan",29,1,1,"","","",0,"","","",""]
[null,"mardi 7 déc 21","Djamel",29,3,"","","","",0,0,1,"",""]
[null,"mardi 7 déc 21","Nico ",29,"","",1,1,1,0,"","","",""]
[null,"mardi 7 déc 21","Madebo",29,"","","","",1,0,"","","",""]
[null,"mardi 7 déc 21","Cyrille",29,"","","",2,"",0,"","","",""]
[null,"mardi 7 déc 21","Nibenson",29,2,"","","",1,0,"","","",""]
[null,"mercredi 8 déc 21","Cyrille",29,"","","","",1,0,1,1,"",""]
[null,"mercredi 8 déc 21","Zakaria",29,1,0,0,1,0,0,0,0,0,0]
[null,"mercredi 8 déc 21","Djamel",29,3,"","","","",0,"","","",""]
[null,"mercredi 8 déc 21","Riwan",29,"",1,"","","",0,"","","",""]
[null,"mercredi 8 déc 21","Neji",29,2,"","","","",0,"","","",""]
[null,"mercredi 8 déc 21","Nico ",29,"",1,"",1,1,0,"","","",""]
[null,"mercredi 8 déc 21","Madebo",29,"",1,"","","",0,"","","",""]
[null,"mercredi 8 déc 21","Nibenson",29,1,1,"","",2,0,"","","",""]
[null,"jeudi 9 déc 21","Djamel",29,2,"","","",1,0,1,"","",""]
[null,"jeudi 9 déc 21","Nico ",29,1,"","","",2,0,"","","",""]
[null,"jeudi 9 déc 21","Neji",29,2,1,"","","",0,"","","",""]
[null,"jeudi 9 déc 21","Riwan",29,1,1,"","",2,0,"","","",""]
[null,"jeudi 9 déc 21","Cyrille",29,"","",1,1,"",0,1,"","",""]
[null,"jeudi 9 déc 21","Madebo",29,2,"","","","",0,"",1,"",""]
[null,"vendredi 10 déc 21","Djamel",29,1,"","","",1,0,1,"","",""]
[null,"vendredi 10 déc 21","Cyrille",29,"","","","",3,0,"","","",""]
[null,"vendredi 10 déc 21","Zakaria",29,"","","","",3,0,"","","",""]
[null,"vendredi 10 déc 21","Neji",29,"","","","",3,0,"","","",""]
[null,"vendredi 10 déc 21","Riwan",29,"","",1,"",1,0,"","","",""]
[null,"vendredi 10 déc 21","Nico ",29,"",1,"","",2,0,"","","",""]
[null,"samedi 11 déc 21","Zakaria",29,2,"",1,"","",0,"","","",120]
[null,"samedi 11 déc 21","Nico ",29,1,"","","",2,0,"",1,"",75]
[null,"samedi 11 déc 21","Riwan",29,2,"","","",1,0,"","","",90]
[null,"dimanche 12 déc 21","------------",0,"","","","","",0,"","","",""]
[]
[null,null,null,null,"","","","","",null,"","","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"VLOOKUP(C300:C596,DONNEES!A299:B348,2,0)","v":{"$error":"#N/A"}},46,9,6,15,55,null,19,10,3,550,null,{"$f":"SUM(Tableau1[[#This Row],[Immeuble]:[PLP]])","v":131}]

{"sheet":"SAUVEGARDE","index":2,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[14,0,25,0],[1,0,13,0]]}
[null,"MOIS","Nb INTERS","Nb PLP","Nb ECHEC","TAUX REUSSITE",null,"SAMEDI","MONTANT"]
[{"$f":"YEAR(TODAY())","v":2021}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I2:I12)","v":0}]

{"sheet":"DONNEES","index":3,"n_rows":1001,"n_cols":14,"rows_kept":1001,"cut":false,"hidden":false,"merged":[]}
["DEP - 29",null,1,1]
["------------",null,null,2]
["Anas",29,null,3]
["Cyrille",29,null,4]
["Eduart",29,null,5]
["Eric",29]
["Karim",29]
["Madebo",29]
["Neji",29]
["Nibenson",29]
["Nicolas",29]
["Riwan",29]
["Zakaria",29]
[null,29,null,5]
[null,29]
[null,29]
[null,29]
[null,29]
[null,29]
[null,29]
[null,29]
[null,29]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,0,0,0,0,0,null,0,0,0,0]

{"sheet":"DISPATCH","index":4,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,7,0]]}
[null,"Immeuble"]
[null,"Chambre"]
[null,"Facade",null,null,"Nb samedis","Montants"]
[null,"Aerien"]
[null,"PLP"]
[]
[null,"Echec abonné"]
[null,"Echec infra"]