{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Récap","Coach"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"Récap","index":0,"n_rows":88,"n_cols":21,"rows_kept":88,"cut":false,"hidden":false,"merged":[]}
["Nbre Date Validée",{"$f":"SUMPRODUCT(COUNTIF(A5:A103,\"oui\"))","v":22},"Nbre Pax",{"$f":"SUM(J5:J103)","v":0},null,"CA",{"$f":"SUM(K5:K103)","v":0}]
["Nbre Date Non Validée",{"$f":"SUMPRODUCT(COUNTIF(A5:A104,\"non\"))","v":8}]
["Total ",{"$f":"SUM(B1:B2)","v":30}]
["Validé","Date","Horaire Début","Horaire Fin","Ville","Lieu","Agence","Client Final","Activité","Nbre Pax","Prix","Prix / Pax","Coach 1","Coach 2","Coach 3","Coach 4","Coach 5","Coach 6","Coach 7","Coach 8","commentaires"]
["oui","2016-06-01",null,null,null,null,null,null,null,null,null,null,"Alain R"]
["non","2016-06-02",null,null,null,null,null,null,null,null,null,null,"John Kikouta","Manu VINCE","Kevon","wesley SEME",null,null,null,null,"DATE ANNULEE"]
["oui","2016-06-03",null,null,null,null,null,null,null,null,null,null,"Olivier","Soane","Stéphane C","Sandro","Sidi"]
["oui","2016-06-03",null,null,null,null,null,null,null,null,null,null,"Alain R","Aurelie","Stéphane B","Sébastien L","Sidi","William AYENI"]
["non","2016-06-06",null,null,null,null,null,null,null,null,null,null,"Alain R","Olivier"]
["oui","2016-06-07",null,null,null,null,null,null,null,null,null,null,"Alain R"]
["oui","2016-06-08",null,null,null,null,null,null,null,null,null,null,"Olivier","Guillaume Kervel","Stéphane Bénac"]
["oui","2016-06-08",null,null,null,null,null,null,null,null,null,null,"John Kikouta"]
["oui","2016-06-09",null,null,null,null,null,null,null,null,null,null,"Soane","Stéphane C","Sidi"]
["oui","2016-06-09",null,null,null,null,null,null,null,null,null,null,"Alain R"]
["oui","2016-06-10",null,null,null,null,null,null,null,null,null,null,"Olivier","Sandro","Aurelie","Grizzly"]
["oui","2016-06-10",null,null,null,null,null,null,null,null,null,null,"Olivier","Sandro","Aurelie","Grizzly"]
["oui","2016-06-14",null,null,null,null,null,null,null,null,null,null,"Soane","Stéphane C","Romain"]
["non","2016-06-15",null,null,null,null,null,null,null,null,null,null,"2 COACHES"]
["non","2016-06-15",null,null,null,null,null,null,null,null,null,null,"Michel WEELEN","Bakary","Junior"]
["oui","2016-06-15",null,null,null,null,null,null,null,null,null,null,"Olivier","Aurelie","Grizzly"]
["oui","2016-06-16",null,null,null,null,null,null,null,null,null,null,"Alain R","Olivier","Junior"]
["oui","2016-06-17",null,null,null,null,null,null,null,null,null,null,"Olivier","Grizzly"]
["oui","2016-06-22",null,null,null,null,null,null,null,null,null,null,"Soane","Stéphane CUFFEL"]
["oui","2016-06-22",null,null,null,null,null,null,null,null,null,null,"Olivier"]
["non","2016-06-22",null,null,null,null,null,null,null,null,null,null,null,"Aurelie"]
["oui","2016-06-23",null,null,null,null,null,null,null,null,null,null,"Soane","Stéphane CUFFEL","Sidi"]
["non","2016-06-24"]
["oui","2016-06-27",null,null,null,null,null,null,null,null,null,null,"Olivier","John Kikouta","Aurelie","Cécile ","Rosalie H","Alain R"]
["non","2016-06-28"]
["non","2016-06-28"]
["oui","2016-06-29",null,null,null,null,null,null,null,null,null,null,"Soane","Stéphane CUFFEL","Sidi","Romain"]
["oui","2016-06-30",null,null,null,null,null,null,null,null,null,null,"Soane","Stéphane CUFFEL"]
["oui","2016-06-30",null,null,null,null,null,null,null,null,null,null,"Soane"]
["oui","2016-06-30",null,null,null,null,null,null,null,null,null,null,"Olivier"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"K43/J43","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"K70/J70","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]

{"sheet":"Coach","index":1,"n_rows":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Coach2","Nbre Dates",{"$f":"SUM(B2:B10)","v":19}]
["Alain R",{"$f":"COUNTIF(Coaches,A2)","v":7},null,"2016-06-01","2016-06-03","2016-06-06","2016-06-07","2016-06-09","2016-06-16","2016-06-27"]
["Aurelie",6,null,"2016-06-03","2016-06-10","2016-06-10","2016-06-15","2016-06-22","2016-06-27"]
["Bakary",1,null,"2016-06-15"]
["Cécile ",1,null,"2016-06-27"]
["Grizzly",4,null,"2016-06-10","2016-06-10","2016-06-15","2016-06-17"]