{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Récap","Coach","Prix Presta","Agence","Activité","Lieu","Date","Horaire","Autres","Feuil3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"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":17,"n_cols":37,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Nbre Date Validée",{"$f":"SUMPRODUCT(COUNTIF(A3:A100,\"oui\"))","v":9},"Total  Date",{"$f":"B1+B2","v":14},null,null,"Nbre Pax",{"$f":"SUM(L4:L102)","v":0},"CA TTC",{"$f":"(J2*K1)+J2","v":0},0.2]
["Nbre Date Non Validée",{"$f":"SUMPRODUCT(COUNTIF(A3:A101,\"non\"))","v":5},null,null,null,null,null,null,"CA HT",{"$f":"SUM(M4:M102)","v":0},null,"Marge HT",{"$f":"SUM(AJ:AJ)","v":0},{"$f":"M2/J2","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE4:AE102)","v":0}]
["Validé","Date","Horaire Début","Horaire Fin","Activité 1","Activité 2","Ville","Lieu","Agence","Chef de Projet","Client Final","Nbre Pax","Prix HT","Prix par Pax","Coach 1","Paie","Coach 2","Paie","Coach 3","Paie","Coach 4","Paie","Coach 5","Paie","Coach 6","Paie","Coach 7","Paie","Coach 8","Paie","Cout Paie","Vidéo","Cout Transport","Cout Autre","Total €","Marge","Commentaires"]
["non","2016-07-01","13:00:00","17:00:00"]
["non","2016-07-03","18:00:00","22:00:00",null,null,null,null,null,null,null,null,null,null,"Stéphane BOUTINAUD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AU BLACK"]
["oui","2016-07-04",null,null,null,null,null,null,null,null,null,null,null,null,"Olivier",450,"Aurelie",250,"Grizzly",180,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VIDEO FLORIAN 600€"]
["oui","2016-07-04","18:00:00","20:00:00",null,null,null,null,null,null,null,null,null,null,"Alain R",350,"Olivier",250,"Nicolas OLMEDO",100,"Franck LOPEPE",100,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 junor + Camion 100€ black"]
["non","2016-07-05","13:00:00"]
["oui","2016-07-05","13:00:00","17:00:00",null,null,null,null,null,null,null,null,null,null,"Olivier",450,"Grizzly",200,"Franck LOPEPE",100,"Nicolas OLMEDO",100,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sono en plus 120€  . 705+505+120+80+240= 1650€ ht"]
["oui","2016-07-06","21:00:00",1,null,null,null,null,null,null,null,null,null,null,"OLIVIER",300,"Sandro",150,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"presta MAELIA Excellencia pour 2 musiciens et 1 danseuse."]
["oui","2016-07-07","09:00:00","18:00:00",null,null,null,null,null,null,null,null,null,null,"Olivier",400,"Grizzly",230,"Sandro",230,"Franck LOPEPE",100]
["oui","2016-07-08","11:00:00","15:00:00",null,null,null,null,null,null,null,null,null,null,"Olivier",300]
["non","2016-07-11"]
["oui","2016-07-11","18:00:00","20:00:00",null,null,null,null,null,null,null,null,null,null,"Olivier",300,"Grizzly",200,"Franck LOPEPE",100]
["non","2016-07-12",null,null,null,null,null,null,null,null,null,null,null,null,"Olivier",400,"Aurelie",200,"Sandro",200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AVEC SHOW DES ZICOS EN DEBUT DE DANCE FLOOR"]
["oui","2016-07-12",null,null,null,null,null,null,null,null,null,null,null,null,"Alain R",300,"Olivier",250]
["oui","2016-07-21","13:00:00","18:00:00",null,null,null,null,null,null,null,null,null,null,"Olivier",400,"John KIKOUTA",260,"Rosalie H",250,"Alain R",200,null,null,null,null,null,null,null,null,null,"FLORIAN",null,null,null,null,"SONOS EN PLUS (1200€)"]

{"sheet":"Coach","index":1,"n_rows":37,"n_cols":23,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Coach","Nbre Dates","Total Paies",{"$f":"SUM(B2:B107)","v":31},{"$f":"SUM(C2:C173)","v":6700},{"$f":"E1*2","v":13400},{"$f":"Récap!AE2-Coach!F1","v":-13400}]
["??",{"$f":"COUNTIF(Coaches,A2)","v":0},{"$f":"SUMIF(Récap!O:O,A2,Récap!P:P)+SUMIF(Récap!Q:Q,A2,Récap!R:R)+SUMIF(Récap!S:S,A2,Récap!T:T)+SUMIF(Récap!U:U,A2,Récap!V:V)+SUMIF(Récap!W:W,A2,Récap!X:X)+SUMIF(Récap!Y:Y,A2,Récap!Z:Z)","v":0}]
["Alain R",3,{"$f":"SUMIF(Récap!O:O,A3,Récap!P:P)+SUMIF(Récap!Q:Q,A3,Récap!R:R)+SUMIF(Récap!S:S,A3,Récap!T:T)+SUMIF(Récap!U:U,A3,Récap!V:V)+SUMIF(Récap!W:W,A3,Récap!X:X)+SUMIF(Récap!Y:Y,A3,Récap!Z:Z)","v":850},"2016-07-04",350,"2016-07-12",300,"2016-07-21",200]
["Aurelie",2,{"$f":"SUMIF(Récap!O:O,A4,Récap!P:P)+SUMIF(Récap!Q:Q,A4,Récap!R:R)+SUMIF(Récap!S:S,A4,Récap!T:T)+SUMIF(Récap!U:U,A4,Récap!V:V)+SUMIF(Récap!W:W,A4,Récap!X:X)+SUMIF(Récap!Y:Y,A4,Récap!Z:Z)","v":450},"2016-07-04",250,"2016-07-12",200]
["Bakary",0,{"$f":"SUMIF(Récap!O:O,A5,Récap!P:P)+SUMIF(Récap!Q:Q,A5,Récap!R:R)+SUMIF(Récap!S:S,A5,Récap!T:T)+SUMIF(Récap!U:U,A5,Récap!V:V)+SUMIF(Récap!W:W,A5,Récap!X:X)+SUMIF(Récap!Y:Y,A5,Récap!Z:Z)","v":0}]
["Bruce Allan VILMEN ",0,{"$f":"SUMIF(Récap!O:O,A6,Récap!P:P)+SUMIF(Récap!Q:Q,A6,Récap!R:R)+SUMIF(Récap!S:S,A6,Récap!T:T)+SUMIF(Récap!U:U,A6,Récap!V:V)+SUMIF(Récap!W:W,A6,Récap!X:X)+SUMIF(Récap!Y:Y,A6,Récap!Z:Z)","v":0}]
["Cécile ",0,{"$f":"SUMIF(Récap!O:O,A7,Récap!P:P)+SUMIF(Récap!Q:Q,A7,Récap!R:R)+SUMIF(Récap!S:S,A7,Récap!T:T)+SUMIF(Récap!U:U,A7,Récap!V:V)+SUMIF(Récap!W:W,A7,Récap!X:X)+SUMIF(Récap!Y:Y,A7,Récap!Z:Z)","v":0}]
["Cristina ABAD GARCIA ",0,{"$f":"SUMIF(Récap!O:O,A8,Récap!P:P)+SUMIF(Récap!Q:Q,A8,Récap!R:R)+SUMIF(Récap!S:S,A8,Récap!T:T)+SUMIF(Récap!U:U,A8,Récap!V:V)+SUMIF(Récap!W:W,A8,Récap!X:X)+SUMIF(Récap!Y:Y,A8,Récap!Z:Z)","v":0}]
["Dominique CLERENCE",0,{"$f":"SUMIF(Récap!O:O,A9,Récap!P:P)+SUMIF(Récap!Q:Q,A9,Récap!R:R)+SUMIF(Récap!S:S,A9,Récap!T:T)+SUMIF(Récap!U:U,A9,Récap!V:V)+SUMIF(Récap!W:W,A9,Récap!X:X)+SUMIF(Récap!Y:Y,A9,Récap!Z:Z)","v":0}]
["Franck LOPEPE",4,null,"2016-07-04",100,"2016-07-05",100,"2016-07-07",100,"2016-07-11",100]
["Grizzly",4,{"$f":"SUMIF(Récap!O:O,A11,Récap!P:P)+SUMIF(Récap!Q:Q,A11,Récap!R:R)+SUMIF(Récap!S:S,A11,Récap!T:T)+SUMIF(Récap!U:U,A11,Récap!V:V)+SUMIF(Récap!W:W,A11,Récap!X:X)+SUMIF(Récap!Y:Y,A11,Récap!Z:Z)","v":810},"2016-07-04",180,"2016-07-05",200,"2016-07-07",230,"2016-07-11",200]
["Guillaume KERVEL",0,{"$f":"SUMIF(Récap!O:O,A12,Récap!P:P)+SUMIF(Récap!Q:Q,A12,Récap!R:R)+SUMIF(Récap!S:S,A12,Récap!T:T)+SUMIF(Récap!U:U,A12,Récap!V:V)+SUMIF(Récap!W:W,A12,Récap!X:X)+SUMIF(Récap!Y:Y,A12,Récap!Z:Z)","v":0}]
["John KIKOUTA",1,{"$f":"SUMIF(Récap!O:O,A13,Récap!P:P)+SUMIF(Récap!Q:Q,A13,Récap!R:R)+SUMIF(Récap!S:S,A13,Récap!T:T)+SUMIF(Récap!U:U,A13,Récap!V:V)+SUMIF(Récap!W:W,A13,Récap!X:X)+SUMIF(Récap!Y:Y,A13,Récap!Z:Z)","v":260},"2016-07-21",260]
["Julien VARIN",0]
["Junior",0,{"$f":"SUMIF(Récap!O:O,A15,Récap!P:P)+SUMIF(Récap!Q:Q,A15,Récap!R:R)+SUMIF(Récap!S:S,A15,Récap!T:T)+SUMIF(Récap!U:U,A15,Récap!V:V)+SUMIF(Récap!W:W,A15,Récap!X:X)+SUMIF(Récap!Y:Y,A15,Récap!Z:Z)","v":0}]
["Kevon",0,{"$f":"SUMIF(Récap!O:O,A16,Récap!P:P)+SUMIF(Récap!Q:Q,A16,Récap!R:R)+SUMIF(Récap!S:S,A16,Récap!T:T)+SUMIF(Récap!U:U,A16,Récap!V:V)+SUMIF(Récap!W:W,A16,Récap!X:X)+SUMIF(Récap!Y:Y,A16,Récap!Z:Z)","v":0}]
["Laurent AVENARD-KOHLER",0]
["Loic SOULAT",0]
["Manu VINCE",0,{"$f":"SUMIF(Récap!O:O,A19,Récap!P:P)+SUMIF(Récap!Q:Q,A19,Récap!R:R)+SUMIF(Récap!S:S,A19,Récap!T:T)+SUMIF(Récap!U:U,A19,Récap!V:V)+SUMIF(Récap!W:W,A19,Récap!X:X)+SUMIF(Récap!Y:Y,A19,Récap!Z:Z)","v":0}]
["Marlene",0,{"$f":"SUMIF(Récap!O:O,A20,Récap!P:P)+SUMIF(Récap!Q:Q,A20,Récap!R:R)+SUMIF(Récap!S:S,A20,Récap!T:T)+SUMIF(Récap!U:U,A20,Récap!V:V)+SUMIF(Récap!W:W,A20,Récap!X:X)+SUMIF(Récap!Y:Y,A20,Récap!Z:Z)","v":0}]
["Matthieu DEVAUX",0,{"$f":"SUMIF(Récap!O:O,A21,Récap!P:P)+SUMIF(Récap!Q:Q,A21,Récap!R:R)+SUMIF(Récap!S:S,A21,Récap!T:T)+SUMIF(Récap!U:U,A21,Récap!V:V)+SUMIF(Récap!W:W,A21,Récap!X:X)+SUMIF(Récap!Y:Y,A21,Récap!Z:Z)","v":0}]
["Michel WEELEN",0,{"$f":"SUMIF(Récap!O:O,A22,Récap!P:P)+SUMIF(Récap!Q:Q,A22,Récap!R:R)+SUMIF(Récap!S:S,A22,Récap!T:T)+SUMIF(Récap!U:U,A22,Récap!V:V)+SUMIF(Récap!W:W,A22,Récap!X:X)+SUMIF(Récap!Y:Y,A22,Récap!Z:Z)","v":0}]
["Nicolas OLMEDO",2,null,"2016-07-04",100,"2016-07-05",100]
["Olivier",10,{"$f":"SUMIF(Récap!O:O,A24,Récap!P:P)+SUMIF(Récap!Q:Q,A24,Récap!R:R)+SUMIF(Récap!S:S,A24,Récap!T:T)+SUMIF(Récap!U:U,A24,Récap!V:V)+SUMIF(Récap!W:W,A24,Récap!X:X)+SUMIF(Récap!Y:Y,A24,Récap!Z:Z)","v":3500},"2016-07-04",450,"2016-07-04",250,"2016-07-05",450,"2016-07-06",300,"2016-07-07",400,"2016-07-08",300,"2016-07-11",300,"2016-07-12",400,"2016-07-12",250,"2016-07-21",400]
["Rémi HENNAUT",0]
["Romain",0,{"$f":"SUMIF(Récap!O:O,A26,Récap!P:P)+SUMIF(Récap!Q:Q,A26,Récap!R:R)+SUMIF(Récap!S:S,A26,Récap!T:T)+SUMIF(Récap!U:U,A26,Récap!V:V)+SUMIF(Récap!W:W,A26,Récap!X:X)+SUMIF(Récap!Y:Y,A26,Récap!Z:Z)","v":0}]
["Rosalie H",1,{"$f":"SUMIF(Récap!O:O,A27,Récap!P:P)+SUMIF(Récap!Q:Q,A27,Récap!R:R)+SUMIF(Récap!S:S,A27,Récap!T:T)+SUMIF(Récap!U:U,A27,Récap!V:V)+SUMIF(Récap!W:W,A27,Récap!X:X)+SUMIF(Récap!Y:Y,A27,Récap!Z:Z)","v":250},"2016-07-21",250]
["Sandro",3,{"$f":"SUMIF(Récap!O:O,A28,Récap!P:P)+SUMIF(Récap!Q:Q,A28,Récap!R:R)+SUMIF(Récap!S:S,A28,Récap!T:T)+SUMIF(Récap!U:U,A28,Récap!V:V)+SUMIF(Récap!W:W,A28,Récap!X:X)+SUMIF(Récap!Y:Y,A28,Récap!Z:Z)","v":580},"2016-07-06",150,"2016-07-07",230,"2016-07-12",200]
["Sébastien L",0,{"$f":"SUMIF(Récap!O:O,A29,Récap!P:P)+SUMIF(Récap!Q:Q,A29,Récap!R:R)+SUMIF(Récap!S:S,A29,Récap!T:T)+SUMIF(Récap!U:U,A29,Récap!V:V)+SUMIF(Récap!W:W,A29,Récap!X:X)+SUMIF(Récap!Y:Y,A29,Récap!Z:Z)","v":0}]
["Sidi",0,{"$f":"SUMIF(Récap!O:O,A30,Récap!P:P)+SUMIF(Récap!Q:Q,A30,Récap!R:R)+SUMIF(Récap!S:S,A30,Récap!T:T)+SUMIF(Récap!U:U,A30,Récap!V:V)+SUMIF(Récap!W:W,A30,Récap!X:X)+SUMIF(Récap!Y:Y,A30,Récap!Z:Z)","v":0}]
["Soane",0,{"$f":"SUMIF(Récap!O:O,A31,Récap!P:P)+SUMIF(Récap!Q:Q,A31,Récap!R:R)+SUMIF(Récap!S:S,A31,Récap!T:T)+SUMIF(Récap!U:U,A31,Récap!V:V)+SUMIF(Récap!W:W,A31,Récap!X:X)+SUMIF(Récap!Y:Y,A31,Récap!Z:Z)","v":0}]
["Stéphane BENAC",0,{"$f":"SUMIF(Récap!O:O,A32,Récap!P:P)+SUMIF(Récap!Q:Q,A32,Récap!R:R)+SUMIF(Récap!S:S,A32,Récap!T:T)+SUMIF(Récap!U:U,A32,Récap!V:V)+SUMIF(Récap!W:W,A32,Récap!X:X)+SUMIF(Récap!Y:Y,A32,Récap!Z:Z)","v":0}]
["Stéphane BOUTINAUD",1,{"$f":"SUMIF(Récap!O:O,A33,Récap!P:P)+SUMIF(Récap!Q:Q,A33,Récap!R:R)+SUMIF(Récap!S:S,A33,Récap!T:T)+SUMIF(Récap!U:U,A33,Récap!V:V)+SUMIF(Récap!W:W,A33,Récap!X:X)+SUMIF(Récap!Y:Y,A33,Récap!Z:Z)","v":0},"2016-07-03","mnt absent"]
["Stéphane CUFFEL",0,{"$f":"SUMIF(Récap!O:O,A34,Récap!P:P)+SUMIF(Récap!Q:Q,A34,Récap!R:R)+SUMIF(Récap!S:S,A34,Récap!T:T)+SUMIF(Récap!U:U,A34,Récap!V:V)+SUMIF(Récap!W:W,A34,Récap!X:X)+SUMIF(Récap!Y:Y,A34,Récap!Z:Z)","v":0}]
["stéphane JUMEL",0,{"$f":"SUMIF(Récap!O:O,A35,Récap!P:P)+SUMIF(Récap!Q:Q,A35,Récap!R:R)+SUMIF(Récap!S:S,A35,Récap!T:T)+SUMIF(Récap!U:U,A35,Récap!V:V)+SUMIF(Récap!W:W,A35,Récap!X:X)+SUMIF(Récap!Y:Y,A35,Récap!Z:Z)","v":0}]
["Wesley SEME",0,{"$f":"SUMIF(Récap!O:O,A36,Récap!P:P)+SUMIF(Récap!Q:Q,A36,Récap!R:R)+SUMIF(Récap!S:S,A36,Récap!T:T)+SUMIF(Récap!U:U,A36,Récap!V:V)+SUMIF(Récap!W:W,A36,Récap!X:X)+SUMIF(Récap!Y:Y,A36,Récap!Z:Z)","v":0}]
["William AYENI",0,{"$f":"SUMIF(Récap!O:O,A37,Récap!P:P)+SUMIF(Récap!Q:Q,A37,Récap!R:R)+SUMIF(Récap!S:S,A37,Récap!T:T)+SUMIF(Récap!U:U,A37,Récap!V:V)+SUMIF(Récap!W:W,A37,Récap!X:X)+SUMIF(Récap!Y:Y,A37,Récap!Z:Z)","v":0}]

{"sheet":"Prix Presta","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Agence","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Activité","index":4,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Agence","Nbre","Total",{"$f":"SUM(B2:B39)","v":0}]
["AGENCE",{"$f":"COUNTIF(Activité,A2)","v":0}]
["AUTRES",0]
["BATUCADA",0]
["BODY PERC",0]
["BOOM WHAKERS",0]
["CALYPSO",0]
["CHORUS",0]
["COUNTRY ",0]
["CUP SONG",0]
["DJEMBE",0]
["FLASH MOB",0]
["GUM BOOTS",0]
["HAKA",0]
["MUSIC CLIP",0]
["PERCU CORPO",0]
["SING STUDIO",0]
["SYMPHO ROCK",0]
["TAP TAP",0]
["URBAN",0]
["VIDEO",0]
["VOCAL COACHING",0]
["SHOW MUSICAL",0]
["SHOW DANSE",0]

{"sheet":"Lieu","index":5,"n_rows":28,"n_cols":2,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Lieu","Nbre"]
["???",{"$f":"COUNTIF(Lieu,A2)","v":0}]
["Ambassade de Nouvelle Z",0]
["Ambassade de Nouvelle Z",0]
["Atlantic",0]
["Business Village",0]
["centre du port royal",0]
["Chalet des Iles",0]
["Châteauform",0]
["Chesnaie du Roi",0]
["Domaine de Frémigny",0]
["Domaine de Rebetz ",0]
["Les Erables ",0]
["presqu'ile de Giens",0]
["siège BNP Paribas",0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]

{"sheet":"Date","index":6,"n_rows":31,"n_cols":1,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["2016-07-01"]
["2016-07-02"]
["2016-07-03"]
["2016-07-04"]
["2016-07-05"]
["2016-07-06"]
["2016-07-07"]
["2016-07-08"]
["2016-07-09"]
["2016-07-10"]
["2016-07-11"]
["2016-07-12"]
["2016-07-13"]
["2016-07-14"]
["2016-07-15"]
["2016-07-16"]
["2016-07-17"]
["2016-07-18"]
["2016-07-19"]
["2016-07-20"]
["2016-07-21"]
["2016-07-22"]
["2016-07-23"]
["2016-07-24"]
["2016-07-25"]
["2016-07-26"]
["2016-07-27"]
["2016-07-28"]
["2016-07-29"]
["2016-07-30"]
["2016-07-31"]

{"sheet":"Horaire","index":7,"n_rows":19,"n_cols":1,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
["07:00:00"]
["08:00:00"]
["09:00:00"]
["10:00:00"]
["11:00:00"]
["12:00:00"]
["13:00:00"]
["14:00:00"]
["15:00:00"]
["16:00:00"]
["17:00:00"]
["18:00:00"]
["19:00:00"]
["20:00:00"]
["21:00:00"]
["22:00:00"]
["23:00:00"]
[1]

{"sheet":"Autres","index":8,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["oui"]
["non"]
["Annulée"]

{"sheet":"Feuil3","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}