{"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":25,"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","salaire","Coach 2","Salaire","Coach 3","Salaire","Coach 4","Salaire","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",10,null,10,null,10,null,10]
["non","2016-06-02",null,null,null,null,null,null,null,null,null,null,"John Kikouta",20,"Manu VINCE",20,"Kevon",20,"wesley SEME",20,null,null,null,null,"DATE ANNULEE"]
["oui","2016-06-03",null,null,null,null,null,null,null,null,null,null,"Olivier",30,"Soane",30,"Stéphane C",30,"Sandro",30,"Sidi"]
["oui","2016-06-03",null,null,null,null,null,null,null,null,null,null,"Alain R",40,"Aurelie",40,"Stéphane B",40,"Sébastien L",40,"Sidi","William AYENI"]
["non","2016-06-06",null,null,null,null,null,null,null,null,null,null,"Alain R",50,"Olivier",50,null,50,null,50]
["oui","2016-06-07",null,null,null,null,null,null,null,null,null,null,"Alain R",60,null,60,null,60,null,60]
["oui","2016-06-08",null,null,null,null,null,null,null,null,null,null,"Olivier",70,"Guillaume Kervel",70,"Stéphane Bénac",70,null,70]
["oui","2016-06-08",null,null,null,null,null,null,null,null,null,null,"John Kikouta",80,null,80,null,80,null,80]
["oui","2016-06-09",null,null,null,null,null,null,null,null,null,null,"Soane",90,"Stéphane C",90,"Sidi",90,null,90]
["oui","2016-06-09",null,null,null,null,null,null,null,null,null,null,"Alain R",100,null,100,null,100,null,100]
["oui","2016-06-10",null,null,null,null,null,null,null,null,null,null,"Olivier",110,"Sandro",110,"Aurelie",110,"Grizzly",110]
["oui","2016-06-10",null,null,null,null,null,null,null,null,null,null,"Olivier",120,"Sandro",120,"Aurelie",120,"Grizzly",120]
["oui","2016-06-14",null,null,null,null,null,null,null,null,null,null,"Soane",130,"Stéphane C",130,"Romain",130,null,130]
["non","2016-06-15",null,null,null,null,null,null,null,null,null,null,"2 COACHES",140,null,140,null,140,null,140]
["non","2016-06-15",null,null,null,null,null,null,null,null,null,null,"Michel WEELEN",150,"Bakary",150,"Junior",150,null,150]
["oui","2016-06-15",null,null,null,null,null,null,null,null,null,null,"Olivier",160,"Aurelie",160,"Grizzly",160,null,160]
["oui","2016-06-16",null,null,null,null,null,null,null,null,null,null,"Alain R",170,"Olivier",170,"Junior",170,null,170]
["oui","2016-06-17",null,null,null,null,null,null,null,null,null,null,"Olivier",180,"Grizzly",180,null,180,null,180]
["oui","2016-06-22",null,null,null,null,null,null,null,null,null,null,"Soane",190,"Stéphane CUFFEL",190,null,190,null,190]
["oui","2016-06-22",null,null,null,null,null,null,null,null,null,null,"Olivier",200,null,200,null,200,null,200]
["non","2016-06-22",null,null,null,null,null,null,null,null,null,null,null,210,"Aurelie",210,null,210,null,210]
["oui","2016-06-23",null,null,null,null,null,null,null,null,null,null,"Soane",220,"Stéphane CUFFEL",220,"Sidi",220,null,220]
["non","2016-06-24",null,null,null,null,null,null,null,null,null,null,null,230,null,230,null,230,null,230]
["oui","2016-06-27",null,null,null,null,null,null,null,null,null,null,"Olivier",240,"John Kikouta",240,"Aurelie",240,"Cécile ",240,"Rosalie H","Alain R"]
["non","2016-06-28",null,null,null,null,null,null,null,null,null,null,null,250,null,250,null,250,null,250]
["non","2016-06-28",null,null,null,null,null,null,null,null,null,null,null,260,null,260,null,260,null,260]
["oui","2016-06-29",null,null,null,null,null,null,null,null,null,null,"Soane",270,"Stéphane CUFFEL",270,"Sidi",270,"Romain",270]
["oui","2016-06-30",null,null,null,null,null,null,null,null,null,null,"Soane",280,"Stéphane CUFFEL",280,null,280,null,280]
["oui","2016-06-30",null,null,null,null,null,null,null,null,null,null,"Soane",290,null,290,null,290,null,290]
["oui","2016-06-30",null,null,null,null,null,null,null,null,null,null,"Olivier",300,null,300,null,300,null,300]
[]
[]
[]
[]
[]
[]
[]
[]
[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":7,"n_cols":25,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Coach2","Nbre Dates",{"$f":"SUM(B2:B10)","v":30}]
["Alain R",{"$f":"COUNTIF(Coaches,A2)","v":7},null,"2016-06-01",10,"2016-06-03",40,"2016-06-06",50,"2016-06-07",60,"2016-06-09",100,"2016-06-16",170,"2016-06-27"]
["Aurelie",6,null,"2016-06-03",40,"2016-06-10",110,"2016-06-10",120,"2016-06-15",160,"2016-06-22",210,"2016-06-27",240]
["Bakary",1,null,"2016-06-15",150]
["Cécile ",1,null,"2016-06-27",240]
["Grizzly",4,null,"2016-06-10",110,"2016-06-10",120,"2016-06-15",160,"2016-06-17",180]
["Olivier",11,null,"2016-06-03",30,"2016-06-06",50,"2016-06-08",70,"2016-06-10",110,"2016-06-10",120,"2016-06-15",160,"2016-06-16",170,"2016-06-17",180,"2016-06-22",200,"2016-06-27",240,"2016-06-30",300]