{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Déc16","TARIFS"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":"Déc16","index":0,"n_rows":76,"n_cols":7,"rows_kept":76,"cut":false,"hidden":false,"merged":[[63,1,63,2],[63,4,63,5],[44,3,44,4],[59,4,59,5],[60,4,60,5],[61,4,61,5],[62,4,62,5],[69,0,69,6],[1,1,2,3],[3,1,3,3],[4,1,5,1],[6,0,6,6],[50,0,50,6],[51,0,51,6],[52,4,52,5],[55,4,55,5],[54,4,54,5],[53,4,53,5],[56,4,56,5],[57,4,57,5],[58,4,58,5]]}
[]
[]
[]
[null,{"$f":"\"du \" & TEXT($A$10,\"jj/mm/aa\") & \" au \" & TEXT(A43,\"jj/mm/aa\")","v":"du 01/12/16 au 31/12/16"}]
[null,"Tarifs",25,{"$f":"ROUND(1/24,5)","v":"01:00:00.288"}]
[null,null,30,{"$f":"ROUND(1.5/24,5)","v":"01:30:00"}]
["Toute séance non annulée par le client au plus tard 1h avant sera facturée"]
[]
["Date","Prof","Elève","Début","Fin","Durée"]
["2016-12-01","Clem","S","17:00:00","18:00:00",{"$f":"ROUND(E10-D10,5)","v":"01:00:00.288"}]
["2016-12-03","Clem","S","15:30:00","17:00:00",{"$f":"ROUND(E11-D11,5)","v":"01:30:00"}]
["2016-12-05","Clem","R","17:30:00","19:00:00","01:30:00"]
["2016-12-06","Clem","SG","07:00:00","08:00:00","01:00:00.288"]
["2016-12-06","Clem","R","17:00:00","18:30:00","01:30:00"]
["2016-12-08","Clem","R","15:30:00","17:00:00","01:30:00"]
["2016-12-09","Clem","SG","07:30:00","08:30:00","01:00:00.288"]
["2016-12-09","Clem","R","16:00:00","17:00:00","01:00:00.288"]
["2016-12-09","Clem","S","17:00:00","18:30:00",{"$f":"ROUND(E18-D18,5)","v":"01:30:00"}]
["2016-12-10","Clem","R","16:30:00","18:00:00","01:30:00"]
["2016-12-12","Clem","R","16:30:00","17:30:00","01:00:00.288"]
["2016-12-13","Clem","SG","07:30:00","08:30:00","01:00:00.288"]
["2016-12-13","Clem","R","16:30:00","18:00:00","01:30:00"]
["2016-12-13","Clem","S","17:00:00","18:30:00","01:30:00"]
["2016-12-16","Clem","SG","07:30:00","08:30:00","01:00:00.288"]
["2016-12-16","Clem","S","17:00:00","18:30:00","01:30:00"]
["2016-12-17","x","SA","18:00:00","19:30:00",{"$f":"ROUND(E26-D26,5)","v":"01:30:00"}]
["2016-12-21","Clem","SG","07:30:00","08:30:00","01:00:00.288"]
["2016-12-21","Clem","S","17:00:00","18:30:00","01:30:00"]
["2016-12-22","Clem","S","17:00:00","18:30:00","01:30:00"]
["2016-12-23","Clem","SG","07:30:00","08:30:00","01:00:00.288"]
["2016-12-23","Clem","S","08:30:00","10:00:00","01:30:00"]
["2016-12-24","Clem","S","10:15:00","11:15:00","01:00:00.288"]
["2016-12-26","Clem","S","17:00:00","18:30:00","01:30:00"]
["2016-12-26","Clem","SA","18:30:00","20:00:00","01:30:00"]
["2016-12-27","Clem","SG","07:30:00","08:30:00","01:00:00.288"]
["2016-12-27","Clem","S","17:00:00","18:30:00","01:30:00"]
["2016-12-27","Clem","SA","18:30:00","20:00:00","01:30:00"]
["2016-12-28","Clem","S","17:00:00","18:30:00","01:30:00"]
["2016-12-28","Clem","S","18:30:00","20:00:00","01:30:00"]
["2016-12-29","Clem","SG","07:30:00","08:30:00","01:00:00.288"]
["2016-12-29","Clem","S","17:00:00","18:30:00","01:30:00"]
["2016-12-30","Clem","S","17:00:00","18:30:00","01:30:00"]
["2016-12-31","Clem","S + SA","10:30:00","12:00:00","01:30:00"]
[]
[null,null,null,"TOTAL d'heures",null,{"$f":"SUM(F10:F44)","v":1.8750400000000003}]
[]
[]
[]
[]
[]
[]
["Tarifs remisés"]
["séance individuelle","nombre","tarif unité","total","tarif remisé",null,"TOTAL"]
["1h00",null,{"$f":"TARIFS!C3","v":25},{"$f":"B54*C54","v":0},null,null,{"$f":"E54*B54","v":0}]
["1h30",null,{"$f":"TARIFS!C5","v":30},{"$f":"B55*C55","v":0},null,null,{"$f":"E55*B55","v":0}]
["2h00",null,{"$f":"TARIFS!C7","v":40},{"$f":"B56*C56","v":0},null,null,0]
["séance groupée","nombre","tarif unité","total","tarif remisé",null,"TOTAL"]
["2 pers / 1h00",null,50,{"$f":"C58*B58","v":0},{"$f":"TARIFS!D12","v":45},null,{"$f":"E58*B58","v":0}]
["2 pers / 1h30",null,60,{"$f":"C59*B59","v":0},{"$f":"TARIFS!D14","v":55},null,{"$f":"E59*B59","v":0}]
["2 pers / 2h00",null,80,0,{"$f":"TARIFS!D16","v":75},null,0]
["3 pers / 1h00",null,75,0,{"$f":"TARIFS!E12","v":60},null,0]
["3 pers / 1h30",null,90,0,{"$f":"TARIFS!E14","v":75},null,0]
["3 pers / 2h00",null,120,0,{"$f":"TARIFS!E16","v":105},null,0]
[null,"TOTAL",null,{"$f":"SUM(D54:D56)+SUM(D58:D63)","v":0},"TOTAL avec remise",null,{"$f":"SUM(G54:G56)+SUM(G58:G63)","v":0}]
[]
[]
[]
["Soit la somme de ",{"$f":"[1]!ConvNumberLetter(G64,1)","v":" Euro "}]
[]
["Répartition "]
["Elève","Durée",null,null,"Prof","Montant"]
["R",{"$f":"SUMIF($C$10:$C$44,$A72,$F$10:$F$44)","v":"09:30:00.576"},null,null,"x",{"$f":"SUMIF($B$10:$B$44,$E72,$G$44:$G$44)","v":0}]
["SG",{"$f":"SUMIF($C$10:$C$44,$A73,$F$10:$F$44)","v":"08:00:02.304"},null,null,"Clem",{"$f":"SUMIF($B$10:$B$44,$E73,$G$44:$G$44)","v":0}]
["S",{"$f":"SUMIF($C$10:$C$44,$A74,$F$10:$F$44)","v":"21:30:00.576"}]
["SA",{"$f":"SUMIF($C$10:$C$44,$A75,$F$10:$F$44)","v":"04:30:00"}]
["TOTAL",{"$f":"SUM(B72:B75)","v":1.8125399999999998},null,null,"TOTAL",{"$f":"SUM(G72:G74)","v":0}]

{"sheet":"TARIFS","index":1,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[15,1,16,1],[0,1,0,4],[9,1,9,4],[11,1,12,1],[13,1,14,1],[2,1,3,1],[4,1,5,1],[6,1,7,1]]}
[null,"Tarifs séances individuelles"]
[null,null,"La séance","10 séances","20 séances"]
[null,"1H00",25,24,23.5]
[null,null,null,"par séance","par séance"]
[null,"1H30",30,29,28.5]
[null,null,null,"par séance","par séance"]
[null,"2h00",40,39,38.5]
[null,null,null,"par séance","par séance"]
[]
[null,"Tarifs séances groupées"]
[null,null,"1 personne","2 personnes","3 personnes"]
[null,"1H00",25,45,60]
[null,null,null,"Soit 22,50€ / pers","Soit 20€ / pers"]
[null,"1H30",30,55,75]
[null,null,null,"Soit 27,50€ / pers","Soit 25€ / pers"]
[null,"2h00",40,75,105]
[null,null,null,"Soit 37,50€ / pers","Soit 35,00€ / pers"]