{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Sommaire","Représentant 1","Représentant 2","Représentant 3","Original"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":15,"comments":3,"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":"Sommaire","index":0,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,14],[1,1,1,14],[5,1,6,1],[5,2,6,2],[5,3,6,3],[5,4,6,4],[5,5,6,5],[5,6,6,6],[5,7,6,7],[5,8,6,8],[5,9,6,9],[5,10,6,10],[5,11,6,11],[5,12,6,12],[5,13,6,13],[5,14,6,14],[3,1,4,1],[3,14,4,14],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,4,8,4],[7,5,8,5],[7,6,8,6],[7,7,8,7],[7,8,8,8],[7,9,8,9],[7,10,8,10],[7,11,8,11],[7,12,8,12],[7,13,8,13],[7,14,8,14],[9,1,10,1],[9,2,10,2],[9,3,10,3],[9,4,10,4],[9,5,10,5],[9,11,10,11],[9,12,10,12],[9,13,10,13],[9,14,10,14],[9,6,10,6],[9,7,10,7],[9,8,10,8],[9,9,10,9],[9,10,10,10]]}
["Contrat","Compagnie"]
["Contrat",{"$f":"IF(A1=\"contrat\",\"Prévision des contrats\",IF(A1=\"Facture\",\"Facturation mensuelle\",IF(A1=\"Commission\",\"Commissions vendeurs\",IF(A1=\"commission à payer\",\"Commissions à payer\",\"\"))))","v":"Prévision des contrats"}]
["Facture"]
["Commission",null,"Septembre","Octobre","Novembre","Décembre","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Total"]
["Commission à payer",null,2018,{"$f":"IF(D4=\"janvier\",C5+1,C5)","v":2018},{"$f":"IF(E4=\"janvier\",D5+1,D5)","v":2018},2018,2019,2019,2019,2019,2019,2019,2019,2019]
["Tableau",{"$f":"'Représentant 2'!$A$2","v":"Représentant 2"},{"$f":"SUMIF('Représentant 2'!$C:$P,Sommaire!$A$1,'Représentant 2'!E:E)/2","v":28504.55},{"$f":"SUMIF('Représentant 2'!$C:$P,Sommaire!$A$1,'Représentant 2'!F:F)/2","v":90458.52},{"$f":"SUMIF('Représentant 2'!$C:$P,Sommaire!$A$1,'Représentant 2'!G:G)/2","v":29940.82},{"$f":"SUMIF('Représentant 2'!$C:$P,Sommaire!$A$1,'Représentant 2'!H:H)/2","v":28337.855},{"$f":"SUMIF('Représentant 2'!$C:$P,Sommaire!$A$1,'Représentant 2'!I:I)/2","v":16255.795},{"$f":"SUMIF('Représentant 2'!$C:$P,Sommaire!$A$1,'Représentant 2'!J:J)/2","v":45583},{"$f":"SUMIF('Représentant 2'!$C:$P,Sommaire!$A$1,'Représentant 2'!K:K)/2","v":49919.254999999997},{"$f":"SUMIF('Représentant 2'!$C:$P,Sommaire!$A$1,'Représentant 2'!L:L)/2","v":17879.5},{"$f":"SUMIF('Représentant 2'!$C:$P,Sommaire!$A$1,'Représentant 2'!M:M)/2","v":6828.8550000000005},{"$f":"SUMIF('Représentant 2'!$C:$P,Sommaire!$A$1,'Représentant 2'!N:N)/2","v":0},{"$f":"SUMIF('Représentant 2'!$C:$P,Sommaire!$A$1,'Représentant 2'!O:O)/2","v":0},{"$f":"SUMIF('Représentant 2'!$C:$P,Sommaire!$A$1,'Représentant 2'!P:P)/2","v":0},{"$f":"SUM(C6:N7)","v":313708.15000000002}]
[]
[null,{"$f":"'Représentant 3'!A2","v":"Représentant 3"},{"$f":"SUMIF('Représentant 3'!$C:$P,Sommaire!$A$1,'Représentant 3'!E:E)/2","v":22050},{"$f":"SUMIF('Représentant 3'!$C:$P,Sommaire!$A$1,'Représentant 3'!F:F)/2","v":4950},{"$f":"SUMIF('Représentant 3'!$C:$P,Sommaire!$A$1,'Représentant 3'!G:G)/2","v":1150},{"$f":"SUMIF('Représentant 3'!$C:$P,Sommaire!$A$1,'Représentant 3'!H:H)/2","v":1145},{"$f":"SUMIF('Représentant 3'!$C:$P,Sommaire!$A$1,'Représentant 3'!I:I)/2","v":0},{"$f":"SUMIF('Représentant 3'!$C:$P,Sommaire!$A$1,'Représentant 3'!J:J)/2","v":0},{"$f":"SUMIF('Représentant 3'!$C:$P,Sommaire!$A$1,'Représentant 3'!K:K)/2","v":0},{"$f":"SUMIF('Représentant 3'!$C:$P,Sommaire!$A$1,'Représentant 3'!L:L)/2","v":22295},{"$f":"SUMIF('Représentant 3'!$C:$P,Sommaire!$A$1,'Représentant 3'!M:M)/2","v":0},{"$f":"SUMIF('Représentant 3'!$C:$P,Sommaire!$A$1,'Représentant 3'!N:N)/2","v":0},{"$f":"SUMIF('Représentant 3'!$C:$P,Sommaire!$A$1,'Représentant 3'!O:O)/2","v":0},{"$f":"SUMIF('Représentant 3'!$C:$P,Sommaire!$A$1,'Représentant 3'!P:P)/2","v":0},{"$f":"SUM(C8:N9)","v":51590}]
[]
[null,{"$f":"'Représentant 1'!A2","v":"Représentant 1"},{"$f":"SUMIF('Représentant 1'!$C:$P,Sommaire!$A$1,'Représentant 1'!E:E)/2","v":0},{"$f":"SUMIF('Représentant 1'!$C:$P,Sommaire!$A$1,'Représentant 1'!F:F)/2","v":0},{"$f":"SUMIF('Représentant 1'!$C:$P,Sommaire!$A$1,'Représentant 1'!G:G)/2","v":900},{"$f":"SUMIF('Représentant 1'!$C:$P,Sommaire!$A$1,'Représentant 1'!H:H)/2","v":0},{"$f":"SUMIF('Représentant 1'!$C:$P,Sommaire!$A$1,'Représentant 1'!I:I)/2","v":0},{"$f":"SUMIF('Représentant 1'!$C:$P,Sommaire!$A$1,'Représentant 1'!J:J)/2","v":0},{"$f":"SUMIF('Représentant 1'!$C:$P,Sommaire!$A$1,'Représentant 1'!K:K)/2","v":0},{"$f":"SUMIF('Représentant 1'!$C:$P,Sommaire!$A$1,'Représentant 1'!L:L)/2","v":0},{"$f":"SUMIF('Représentant 1'!$C:$P,Sommaire!$A$1,'Représentant 1'!M:M)/2","v":0},{"$f":"SUMIF('Représentant 1'!$C:$P,Sommaire!$A$1,'Représentant 1'!N:N)/2","v":0},{"$f":"SUMIF('Représentant 1'!$C:$P,Sommaire!$A$1,'Représentant 1'!O:O)/2","v":0},{"$f":"SUMIF('Représentant 1'!$C:$P,Sommaire!$A$1,'Représentant 1'!P:P)/2","v":0},{"$f":"SUM(C10:N11)","v":900}]
[]
[null,"Total",{"$f":"SUM(C6:C11)","v":50554.55},95408.52,31990.82,29482.855,16255.795,45583,49919.254999999997,40174.5,6828.8550000000005,0,0,0,366198.15]

{"sheet":"Représentant 1","index":1,"n_rows":23,"n_cols":18,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,17],[1,0,1,17],[2,0,2,17],[19,0,22,1],[19,2,19,3],[20,2,20,3],[22,2,22,3],[21,2,21,3],[5,0,5,1],[5,2,5,3],[18,2,18,3],[12,2,12,3],[6,2,6,3],[14,2,14,3],[8,2,8,3],[12,0,17,0],[12,1,17,1],[6,1,10,1],[10,2,10,3],[17,2,17,3],[9,2,9,3],[16,2,16,3],[11,0,11,1],[11,2,11,3],[6,0,10,0],[3,0,4,0],[3,1,4,1],[3,2,4,3],[3,17,4,17]]}
[{"$f":"Sommaire!B1","v":"Compagnie"}]
["Représentant 1"]
[{"$f":"Sommaire!B2","v":"Prévision des contrats"}]
["Client","Nom du média\n# contrat",null,null,{"$f":"Sommaire!C4","v":"Septembre"},{"$f":"Sommaire!D4","v":"Octobre"},{"$f":"Sommaire!E4","v":"Novembre"},{"$f":"Sommaire!F4","v":"Décembre"},{"$f":"Sommaire!G4","v":"Janvier"},{"$f":"Sommaire!H4","v":"Février"},{"$f":"Sommaire!I4","v":"Mars"},{"$f":"Sommaire!J4","v":"Avril"},{"$f":"Sommaire!K4","v":"Mai"},{"$f":"Sommaire!L4","v":"Juin"},{"$f":"Sommaire!M4","v":"Juillet"},{"$f":"Sommaire!N4","v":"Août"},null,"Total"]
[null,null,null,null,{"$f":"Sommaire!C5","v":2018},{"$f":"Sommaire!D5","v":2018},{"$f":"Sommaire!E5","v":2018},{"$f":"Sommaire!F5","v":2018},{"$f":"Sommaire!G5","v":2019},{"$f":"Sommaire!H5","v":2019},{"$f":"Sommaire!I5","v":2019},{"$f":"Sommaire!J5","v":2019},{"$f":"Sommaire!K5","v":2019},{"$f":"Sommaire!L5","v":2019},{"$f":"Sommaire!M5","v":2019},{"$f":"Sommaire!N5","v":2019}]
[null,null,{"$f":"Sommaire!$A$1","v":"Contrat"}]
["Signature Boisbriand","Rédaction","Contrat",null,null,null,900,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E7:P7)","v":900}]
[null,null,"Facture",1,{"$f":"IF(E7=\"\",\"\",E7*$D8)","v":""},{"$f":"IF(F7=\"\",\"\",F7*$D8)","v":""},900,"","","","","","","","","",null,{"$f":"SUM(E8:Q8)","v":900}]
[null,null,"Date reçu"]
[null,null,"Date payée"]
[null,null,"Commission à payer",null,{"$f":"IF(E6=\"\",\"\",IF(E10>0,\"\",IF(E8>0,E9,\"\")))","v":""},{"$f":"IF(F6=\"\",\"\",IF(F10>0,\"\",IF(F8>0,F9,\"\")))","v":""},{"$f":"IF(G6=\"\",\"\",IF(G10>0,\"\",IF(G8>0,G9,\"\")))","v":""},{"$f":"IF(H6=\"\",\"\",IF(H10>0,\"\",IF(H8>0,H9,\"\")))","v":""},{"$f":"IF(I6=\"\",\"\",IF(I10>0,\"\",IF(I8>0,I9,\"\")))","v":""},{"$f":"IF(J6=\"\",\"\",IF(J10>0,\"\",IF(J8>0,J9,\"\")))","v":""},{"$f":"IF(K6=\"\",\"\",IF(K10>0,\"\",IF(K8>0,K9,\"\")))","v":""},{"$f":"IF(L6=\"\",\"\",IF(L10>0,\"\",IF(L8>0,L9,\"\")))","v":""},{"$f":"IF(M6=\"\",\"\",IF(M10>0,\"\",IF(M8>0,M9,\"\")))","v":""},{"$f":"IF(N6=\"\",\"\",IF(N10>0,\"\",IF(N8>0,N9,\"\")))","v":""},{"$f":"IF(O6=\"\",\"\",IF(O10>0,\"\",IF(O8>0,O9,\"\")))","v":""},{"$f":"IF(P6=\"\",\"\",IF(P10>0,\"\",IF(P8>0,P9,\"\")))","v":""},null,{"$f":"SUM(E11:Q11)","v":0}]
[null,null,{"$f":"Sommaire!$A$1","v":"Contrat"}]
[null,null,"Contrat",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E13:Q13)","v":0}]
[null,null,"Facture",0.15,{"$f":"IF(E13=\"\",\"\",E13*$D14)","v":""},"","","","","","","","","","","",null,{"$f":"SUM(E14:Q14)","v":0}]
[null,null,"Date reçu"]
[null,null,"Commission",0.1,{"$f":"IF(E13=\"\",\"\",E13*$D16)","v":""},"","","","","","","","","","","",null,{"$f":"SUM(E16:Q16)","v":0}]
[null,null,"Date payée"]
[null,null,"Commission à payer",null,{"$f":"IF(E13=\"\",\"\",IF(E17>0,\"\",IF(E15>0,E16,\"\")))","v":""},{"$f":"IF(F13=\"\",\"\",IF(F17>0,\"\",IF(F15>0,F16,\"\")))","v":""},{"$f":"IF(G13=\"\",\"\",IF(G17>0,\"\",IF(G15>0,G16,\"\")))","v":""},{"$f":"IF(H13=\"\",\"\",IF(H17>0,\"\",IF(H15>0,H16,\"\")))","v":""},{"$f":"IF(I13=\"\",\"\",IF(I17>0,\"\",IF(I15>0,I16,\"\")))","v":""},{"$f":"IF(J13=\"\",\"\",IF(J17>0,\"\",IF(J15>0,J16,\"\")))","v":""},{"$f":"IF(K13=\"\",\"\",IF(K17>0,\"\",IF(K15>0,K16,\"\")))","v":""},{"$f":"IF(L13=\"\",\"\",IF(L17>0,\"\",IF(L15>0,L16,\"\")))","v":""},{"$f":"IF(M13=\"\",\"\",IF(M17>0,\"\",IF(M15>0,M16,\"\")))","v":""},{"$f":"IF(N13=\"\",\"\",IF(N17>0,\"\",IF(N15>0,N16,\"\")))","v":""},{"$f":"IF(O13=\"\",\"\",IF(O17>0,\"\",IF(O15>0,O16,\"\")))","v":""},{"$f":"IF(P13=\"\",\"\",IF(P17>0,\"\",IF(P15>0,P16,\"\")))","v":""},null,{"$f":"SUM(E18:Q18)","v":0}]
[null,null,{"$f":"Sommaire!$A$1","v":"Contrat"}]
["Total",null,"Contrat",null,{"$f":"SUMIF($C$6:$C$19,$C20,E$6:E$19)","v":0},0,900,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(E20:Q20)","v":900}]
[null,null,"Facture",null,0,0,900,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(E21:Q21)","v":900}]
[null,null,"Commission",null,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q6:Q18)","v":0},{"$f":"SUM(E22:Q22)","v":0}]
[null,null,"Commission à payer",null,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q6:Q19)","v":0},{"$f":"SUM(E23:Q23)","v":0}]

{"sheet":"Représentant 2","index":2,"n_rows":95,"n_cols":17,"rows_kept":95,"cut":false,"hidden":false,"merged":[[86,2,86,3],[8,2,8,3],[14,2,14,3],[20,2,20,3],[27,2,27,3],[33,2,33,3],[40,2,40,3],[47,2,47,3],[53,2,53,3],[60,2,60,3],[66,2,66,3],[73,2,73,3],[79,2,79,3],[63,2,63,3],[68,2,68,3],[69,2,69,3],[58,1,63,1],[64,1,69,1],[58,2,58,3],[64,2,64,3],[51,1,56,1],[45,0,56,0],[45,2,45,3],[51,2,51,3],[62,2,62,3],[58,0,69,0],[35,2,35,3],[36,2,36,3],[31,2,31,3],[31,1,36,1],[25,0,36,0],[0,0,0,16],[1,0,1,16],[29,2,29,3],[30,2,30,3],[25,1,30,1],[6,2,6,3],[12,2,12,3],[18,2,18,3],[3,16,4,16],[2,0,2,16],[3,1,4,1],[3,0,4,0],[25,2,25,3],[70,0,70,1],[71,1,76,1],[77,1,82,1],[71,0,82,0],[91,0,94,1],[91,2,91,3],[92,2,92,3],[93,2,93,3],[94,2,94,3],[5,0,5,1],[5,2,5,3],[24,0,24,1],[24,2,24,3],[11,2,11,3],[6,1,11,1],[10,2,10,3],[16,2,16,3],[17,2,17,3],[12,1,17,1],[22,2,22,3],[23,2,23,3],[18,1,23,1],[6,0,23,0],[37,0,37,1],[37,2,37,3],[44,0,44,1],[44,2,44,3],[57,0,57,1],[57,2,57,3],[42,2,42,3],[43,2,43,3],[38,2,38,3],[38,1,43,1],[38,0,43,0],[49,2,49,3],[50,2,50,3],[55,2,55,3],[56,2,56,3],[45,1,50,1],[70,2,70,3],[83,0,83,1],[83,2,83,3],[90,0,90,1],[90,2,90,3],[84,0,89,0],[84,1,89,1],[88,2,88,3],[89,2,89,3],[84,2,84,3],[75,2,75,3],[76,2,76,3],[81,2,81,3],[82,2,82,3],[71,2,71,3],[77,2,77,3]]}
[{"$f":"Sommaire!B1","v":"Compagnie"}]
["Représentant 2"]
[{"$f":"Sommaire!B2","v":"Prévision des contrats"}]
["Client","Nom du média\n# contrat",null,null,{"$f":"Sommaire!C4","v":"Septembre"},{"$f":"Sommaire!D4","v":"Octobre"},{"$f":"Sommaire!E4","v":"Novembre"},{"$f":"Sommaire!F4","v":"Décembre"},{"$f":"Sommaire!G4","v":"Janvier"},{"$f":"Sommaire!H4","v":"Février"},{"$f":"Sommaire!I4","v":"Mars"},{"$f":"Sommaire!J4","v":"Avril"},{"$f":"Sommaire!K4","v":"Mai"},{"$f":"Sommaire!L4","v":"Juin"},{"$f":"Sommaire!M4","v":"Juillet"},{"$f":"Sommaire!N4","v":"Août"},"Total"]
[null,null,null,null,{"$f":"Sommaire!C5","v":2018},{"$f":"Sommaire!D5","v":2018},{"$f":"Sommaire!E5","v":2018},{"$f":"Sommaire!F5","v":2018},{"$f":"Sommaire!G5","v":2019},{"$f":"Sommaire!H5","v":2019},{"$f":"Sommaire!I5","v":2019},{"$f":"Sommaire!J5","v":2019},{"$f":"Sommaire!K5","v":2019},{"$f":"Sommaire!L5","v":2019},{"$f":"Sommaire!M5","v":2019},{"$f":"Sommaire!N5","v":2019}]
[null,null,{"$f":"Sommaire!$A$1","v":"Contrat"}]
["Habitations Trigone","TVA","Contrat",null,4711.84,26898.22,8360.65,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E7:P7)","v":39970.71}]
[null,null,"Facture",0.15,{"$f":"IF(E7=\"\",\"\",E7*$D8)","v":706.77599999999995},4034.7330000000002,1254.0974999999999,"","","","","","","","","",{"$f":"SUM(E8:P8)","v":5995.6064999999999}]
[null,null,"Date reçu"]
[null,null,"Commission",0.1,{"$f":"IF(E7=\"\",\"\",E7*$D10)","v":471.18400000000003},2689.8220000000001,836.06500000000005,"","","","","","","","","",{"$f":"SUM(E10:P10)","v":3997.0710000000004}]
[null,null,"Date payée"]
[null,null,"Commission à payer",null,{"$f":"IF(E7=\"\",\"\",IF(E11>0,\"\",IF(E9>0,E10,\"\")))","v":""},{"$f":"IF(F7=\"\",\"\",IF(F11>0,\"\",IF(F9>0,F10,\"\")))","v":""},{"$f":"IF(G7=\"\",\"\",IF(G11>0,\"\",IF(G9>0,G10,\"\")))","v":""},{"$f":"IF(H7=\"\",\"\",IF(H11>0,\"\",IF(H9>0,H10,\"\")))","v":""},{"$f":"IF(I7=\"\",\"\",IF(I11>0,\"\",IF(I9>0,I10,\"\")))","v":""},{"$f":"IF(J7=\"\",\"\",IF(J11>0,\"\",IF(J9>0,J10,\"\")))","v":""},{"$f":"IF(K7=\"\",\"\",IF(K11>0,\"\",IF(K9>0,K10,\"\")))","v":""},{"$f":"IF(L7=\"\",\"\",IF(L11>0,\"\",IF(L9>0,L10,\"\")))","v":""},{"$f":"IF(M7=\"\",\"\",IF(M11>0,\"\",IF(M9>0,M10,\"\")))","v":""},{"$f":"IF(N7=\"\",\"\",IF(N11>0,\"\",IF(N9>0,N10,\"\")))","v":""},{"$f":"IF(O7=\"\",\"\",IF(O11>0,\"\",IF(O9>0,O10,\"\")))","v":""},{"$f":"IF(P7=\"\",\"\",IF(P11>0,\"\",IF(P9>0,P10,\"\")))","v":""},{"$f":"SUM(E12:P12)","v":0}]
[null,"V Média","Contrat",null,10952.27,31566.799999999999,8360.67,null,4489,31087,{"$f":"7635+31799","v":39434},null,null,null,null,null,{"$f":"SUM(E13:P13)","v":125889.73999999999}]
[null,null,"Facture",0.15,{"$f":"IF(E13=\"\",\"\",E13*$D14)","v":1642.8405},4735.0199999999995,1254.1005,"",673.35,4663.05,5915.0999999999995,"","","","","",{"$f":"SUM(E14:P14)","v":18883.460999999999}]
[null,null,"Date reçu"]
[null,null,"Commission",0.1,{"$f":"IF(E13=\"\",\"\",E13*$D16)","v":1095.2270000000001},3156.6800000000003,836.06700000000001,"",448.90000000000003,3108.7000000000003,3943.4,"","","","","",{"$f":"SUM(E16:P16)","v":12588.974}]
[null,null,"Date payée"]
[null,null,"Commission à payer",null,{"$f":"IF(E13=\"\",\"\",IF(E17>0,\"\",IF(E15>0,E16,\"\")))","v":""},{"$f":"IF(F13=\"\",\"\",IF(F17>0,\"\",IF(F15>0,F16,\"\")))","v":""},{"$f":"IF(G13=\"\",\"\",IF(G17>0,\"\",IF(G15>0,G16,\"\")))","v":""},{"$f":"IF(H13=\"\",\"\",IF(H17>0,\"\",IF(H15>0,H16,\"\")))","v":""},{"$f":"IF(I13=\"\",\"\",IF(I17>0,\"\",IF(I15>0,I16,\"\")))","v":""},{"$f":"IF(J13=\"\",\"\",IF(J17>0,\"\",IF(J15>0,J16,\"\")))","v":""},{"$f":"IF(K13=\"\",\"\",IF(K17>0,\"\",IF(K15>0,K16,\"\")))","v":""},{"$f":"IF(L13=\"\",\"\",IF(L17>0,\"\",IF(L15>0,L16,\"\")))","v":""},{"$f":"IF(M13=\"\",\"\",IF(M17>0,\"\",IF(M15>0,M16,\"\")))","v":""},{"$f":"IF(N13=\"\",\"\",IF(N17>0,\"\",IF(N15>0,N16,\"\")))","v":""},{"$f":"IF(O13=\"\",\"\",IF(O17>0,\"\",IF(O15>0,O16,\"\")))","v":""},{"$f":"IF(P13=\"\",\"\",IF(P17>0,\"\",IF(P15>0,P16,\"\")))","v":""},{"$f":"SUM(E18:P18)","v":0}]
[null,"Nikko - tournage","Contrat",null,null,null,null,13400,null,null,null,null,null,null,null,null,{"$f":"SUM(E19:P19)","v":13400}]
[null,null,"Facture",1,{"$f":"IF(E19=\"\",\"\",E19*$D20)","v":""},"","",13400,"","","","","","","","",{"$f":"SUM(E20:P20)","v":13400}]
[null,null,"Date reçu"]
[null,null,"Commission",0.1,{"$f":"IF(E19=\"\",\"\",E19*$D22)","v":""},"","",1340,"","","","","","","","",{"$f":"SUM(E22:P22)","v":1340}]
[null,null,"Date payée"]
[null,null,"Commission à payer",null,{"$f":"IF(E19=\"\",\"\",IF(E23>0,\"\",IF(E21>0,E22,\"\")))","v":""},{"$f":"IF(F19=\"\",\"\",IF(F23>0,\"\",IF(F21>0,F22,\"\")))","v":""},{"$f":"IF(G19=\"\",\"\",IF(G23>0,\"\",IF(G21>0,G22,\"\")))","v":""},{"$f":"IF(H19=\"\",\"\",IF(H23>0,\"\",IF(H21>0,H22,\"\")))","v":""},{"$f":"IF(I19=\"\",\"\",IF(I23>0,\"\",IF(I21>0,I22,\"\")))","v":""},{"$f":"IF(J19=\"\",\"\",IF(J23>0,\"\",IF(J21>0,J22,\"\")))","v":""},{"$f":"IF(K19=\"\",\"\",IF(K23>0,\"\",IF(K21>0,K22,\"\")))","v":""},{"$f":"IF(L19=\"\",\"\",IF(L23>0,\"\",IF(L21>0,L22,\"\")))","v":""},{"$f":"IF(M19=\"\",\"\",IF(M23>0,\"\",IF(M21>0,M22,\"\")))","v":""},{"$f":"IF(N19=\"\",\"\",IF(N23>0,\"\",IF(N21>0,N22,\"\")))","v":""},{"$f":"IF(O19=\"\",\"\",IF(O23>0,\"\",IF(O21>0,O22,\"\")))","v":""},{"$f":"IF(P19=\"\",\"\",IF(P23>0,\"\",IF(P21>0,P22,\"\")))","v":""},{"$f":"SUM(E24:P24)","v":0}]
[null,null,{"$f":"Sommaire!$A$1","v":"Contrat"}]
["Coiteux Hyundai","Clasique 99,5 (#9467)","Contrat",null,2646,2646,2646,null,null,2646,2646,2646,null,null,null,null,{"$f":"SUM(E26:P26)","v":15876}]
[null,null,"Facture",0.15,{"$f":"IF(E26=\"\",\"\",E26*$D27)","v":396.9},396.9,396.9,"","",396.9,396.9,396.9,"","","","",{"$f":"SUM(E27:P27)","v":2381.4}]
[null,null,"Date reçu"]
[null,null,"Commission",0.1,{"$f":"IF(E26=\"\",\"\",E26*$D29)","v":264.60000000000002},264.60000000000002,264.60000000000002,"","",264.60000000000002,264.60000000000002,264.60000000000002,"","","","",{"$f":"SUM(E29:P29)","v":1587.6}]
[null,null,"Date payée"]
[null,null,"Commission à payer",null,{"$f":"IF(E26=\"\",\"\",IF(E30>0,\"\",IF(E28>0,E29,\"\")))","v":""},{"$f":"IF(F26=\"\",\"\",IF(F30>0,\"\",IF(F28>0,F29,\"\")))","v":""},{"$f":"IF(G26=\"\",\"\",IF(G30>0,\"\",IF(G28>0,G29,\"\")))","v":""},{"$f":"IF(H26=\"\",\"\",IF(H30>0,\"\",IF(H28>0,H29,\"\")))","v":""},{"$f":"IF(I26=\"\",\"\",IF(I30>0,\"\",IF(I28>0,I29,\"\")))","v":""},{"$f":"IF(J26=\"\",\"\",IF(J30>0,\"\",IF(J28>0,J29,\"\")))","v":""},{"$f":"IF(K26=\"\",\"\",IF(K30>0,\"\",IF(K28>0,K29,\"\")))","v":""},{"$f":"IF(L26=\"\",\"\",IF(L30>0,\"\",IF(L28>0,L29,\"\")))","v":""},{"$f":"IF(M26=\"\",\"\",IF(M30>0,\"\",IF(M28>0,M29,\"\")))","v":""},{"$f":"IF(N26=\"\",\"\",IF(N30>0,\"\",IF(N28>0,N29,\"\")))","v":""},{"$f":"IF(O26=\"\",\"\",IF(O30>0,\"\",IF(O28>0,O29,\"\")))","v":""},{"$f":"IF(P26=\"\",\"\",IF(P30>0,\"\",IF(P28>0,P29,\"\")))","v":""},{"$f":"SUM(E31:P31)","v":0}]
[null,"98,5 FM (#231775)","Contrat",null,11400,7600,7600,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E32:P32)","v":26600}]
[null,null,"Facture",0.15,{"$f":"IF(E32=\"\",\"\",E32*$D33)","v":1710},1140,1140,"","","","","","","","","",{"$f":"SUM(E33:P33)","v":3990}]
[null,null,"Date reçu"]
[null,null,"Commission",0.1,{"$f":"IF(E32=\"\",\"\",E32*$D35)","v":1140},760,760,"","","","","","","","","",{"$f":"SUM(E35:P35)","v":2660}]
[null,null,"Date payée"]
[null,null,"Commission à payer",null,{"$f":"IF(E32=\"\",\"\",IF(E36>0,\"\",IF(E34>0,E35,\"\")))","v":""},{"$f":"IF(F32=\"\",\"\",IF(F36>0,\"\",IF(F34>0,F35,\"\")))","v":""},{"$f":"IF(G32=\"\",\"\",IF(G36>0,\"\",IF(G34>0,G35,\"\")))","v":""},{"$f":"IF(H32=\"\",\"\",IF(H36>0,\"\",IF(H34>0,H35,\"\")))","v":""},{"$f":"IF(I32=\"\",\"\",IF(I36>0,\"\",IF(I34>0,I35,\"\")))","v":""},{"$f":"IF(J32=\"\",\"\",IF(J36>0,\"\",IF(J34>0,J35,\"\")))","v":""},{"$f":"IF(K32=\"\",\"\",IF(K36>0,\"\",IF(K34>0,K35,\"\")))","v":""},{"$f":"IF(L32=\"\",\"\",IF(L36>0,\"\",IF(L34>0,L35,\"\")))","v":""},{"$f":"IF(M32=\"\",\"\",IF(M36>0,\"\",IF(M34>0,M35,\"\")))","v":""},{"$f":"IF(N32=\"\",\"\",IF(N36>0,\"\",IF(N34>0,N35,\"\")))","v":""},{"$f":"IF(O32=\"\",\"\",IF(O36>0,\"\",IF(O34>0,O35,\"\")))","v":""},{"$f":"IF(P32=\"\",\"\",IF(P36>0,\"\",IF(P34>0,P35,\"\")))","v":""},{"$f":"SUM(E37:P37)","v":0}]
[null,null,{"$f":"Sommaire!$A$1","v":"Contrat"}]
["Kosmic","V Télé","Contrat",null,8988.8799999999992,51095,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E39:P39)","v":60083.88}]
[null,null,"Facture",0.15,{"$f":"IF(E39=\"\",\"\",E39*$D40)","v":1348.3319999999999},7664.25,"","","","","","","","","","",{"$f":"SUM(E40:P40)","v":9012.5820000000003}]
[null,null,"Date reçu"]
[null,null,"Commission",0.1,{"$f":"IF(E39=\"\",\"\",E39*$D42)","v":898.88799999999992},5109.5,"","","","","","","","","","",{"$f":"SUM(E42:P42)","v":6008.3879999999999}]
[null,null,"Date payée"]
[null,null,"Commission à payer",null,{"$f":"IF(E39=\"\",\"\",IF(E43>0,\"\",IF(E41>0,E42,\"\")))","v":""},{"$f":"IF(F39=\"\",\"\",IF(F43>0,\"\",IF(F41>0,F42,\"\")))","v":""},{"$f":"IF(G39=\"\",\"\",IF(G43>0,\"\",IF(G41>0,G42,\"\")))","v":""},{"$f":"IF(H39=\"\",\"\",IF(H43>0,\"\",IF(H41>0,H42,\"\")))","v":""},{"$f":"IF(I39=\"\",\"\",IF(I43>0,\"\",IF(I41>0,I42,\"\")))","v":""},{"$f":"IF(J39=\"\",\"\",IF(J43>0,\"\",IF(J41>0,J42,\"\")))","v":""},{"$f":"IF(K39=\"\",\"\",IF(K43>0,\"\",IF(K41>0,K42,\"\")))","v":""},{"$f":"IF(L39=\"\",\"\",IF(L43>0,\"\",IF(L41>0,L42,\"\")))","v":""},{"$f":"IF(M39=\"\",\"\",IF(M43>0,\"\",IF(M41>0,M42,\"\")))","v":""},{"$f":"IF(N39=\"\",\"\",IF(N43>0,\"\",IF(N41>0,N42,\"\")))","v":""},{"$f":"IF(O39=\"\",\"\",IF(O43>0,\"\",IF(O41>0,O42,\"\")))","v":""},{"$f":"IF(P39=\"\",\"\",IF(P43>0,\"\",IF(P41>0,P42,\"\")))","v":""},{"$f":"SUM(E44:P44)","v":0}]
[null,null,{"$f":"Sommaire!$A$1","v":"Contrat"}]
["Les Cafés V.P.","WEB","Contrat",null,null,null,null,null,null,20000,null,null,null,null,null,null,{"$f":"SUM(E46:P46)","v":20000}]
[null,null,"Facture",0.15,{"$f":"IF(E46=\"\",\"\",E46*$D47)","v":""},"","","","",3000,"","","","","","",{"$f":"SUM(E47:P47)","v":3000}]
[null,null,"Date reçu"]
[null,null,"Commission",0.1,{"$f":"IF(E46=\"\",\"\",E46*$D49)","v":""},"","","","",2000,"","","","","","",{"$f":"SUM(E49:P49)","v":2000}]
[null,null,"Date payée"]
[null,null,"Commission à payer",null,{"$f":"IF(E46=\"\",\"\",IF(E50>0,\"\",IF(E48>0,E49,\"\")))","v":""},{"$f":"IF(F46=\"\",\"\",IF(F50>0,\"\",IF(F48>0,F49,\"\")))","v":""},{"$f":"IF(G46=\"\",\"\",IF(G50>0,\"\",IF(G48>0,G49,\"\")))","v":""},{"$f":"IF(H46=\"\",\"\",IF(H50>0,\"\",IF(H48>0,H49,\"\")))","v":""},{"$f":"IF(I46=\"\",\"\",IF(I50>0,\"\",IF(I48>0,I49,\"\")))","v":""},{"$f":"IF(J46=\"\",\"\",IF(J50>0,\"\",IF(J48>0,J49,\"\")))","v":""},{"$f":"IF(K46=\"\",\"\",IF(K50>0,\"\",IF(K48>0,K49,\"\")))","v":""},{"$f":"IF(L46=\"\",\"\",IF(L50>0,\"\",IF(L48>0,L49,\"\")))","v":""},{"$f":"IF(M46=\"\",\"\",IF(M50>0,\"\",IF(M48>0,M49,\"\")))","v":""},{"$f":"IF(N46=\"\",\"\",IF(N50>0,\"\",IF(N48>0,N49,\"\")))","v":""},{"$f":"IF(O46=\"\",\"\",IF(O50>0,\"\",IF(O48>0,O49,\"\")))","v":""},{"$f":"IF(P46=\"\",\"\",IF(P50>0,\"\",IF(P48>0,P49,\"\")))","v":""},{"$f":"SUM(E51:P51)","v":0}]
[null,"Pub Interactive SG Inc.","Contrat",null,null,null,null,4500,4500,null,null,null,null,null,null,null,{"$f":"SUM(E52:P52)","v":9000}]
[null,null,"Facture",0.15,{"$f":"IF(E52=\"\",\"\",E52*$D53)","v":""},"","",675,675,"","","","","","","",{"$f":"SUM(E53:P53)","v":1350}]
[null,null,"Date reçu"]
[null,null,"Commission",0.1,{"$f":"IF(E52=\"\",\"\",E52*$D55)","v":""},"","",450,450,"","","","","","","",{"$f":"SUM(E55:P55)","v":900}]
[null,null,"Date payée"]
[null,null,"Commission à payer",null,{"$f":"IF(E52=\"\",\"\",IF(E56>0,\"\",IF(E54>0,E55,\"\")))","v":""},{"$f":"IF(F52=\"\",\"\",IF(F56>0,\"\",IF(F54>0,F55,\"\")))","v":""},{"$f":"IF(G52=\"\",\"\",IF(G56>0,\"\",IF(G54>0,G55,\"\")))","v":""},{"$f":"IF(H52=\"\",\"\",IF(H56>0,\"\",IF(H54>0,H55,\"\")))","v":""},{"$f":"IF(I52=\"\",\"\",IF(I56>0,\"\",IF(I54>0,I55,\"\")))","v":""},{"$f":"IF(J52=\"\",\"\",IF(J56>0,\"\",IF(J54>0,J55,\"\")))","v":""},{"$f":"IF(K52=\"\",\"\",IF(K56>0,\"\",IF(K54>0,K55,\"\")))","v":""},{"$f":"IF(L52=\"\",\"\",IF(L56>0,\"\",IF(L54>0,L55,\"\")))","v":""},{"$f":"IF(M52=\"\",\"\",IF(M56>0,\"\",IF(M54>0,M55,\"\")))","v":""},{"$f":"IF(N52=\"\",\"\",IF(N56>0,\"\",IF(N54>0,N55,\"\")))","v":""},{"$f":"IF(O52=\"\",\"\",IF(O56>0,\"\",IF(O54>0,O55,\"\")))","v":""},{"$f":"IF(P52=\"\",\"\",IF(P56>0,\"\",IF(P54>0,P55,\"\")))","v":""},{"$f":"SUM(E57:P57)","v":0}]
[null,null,{"$f":"Sommaire!$A$1","v":"Contrat"}]
["Institut Trebas Québec Inc.","Astral Affiche Voiture (#59719)","Contrat",null,null,null,13547,17683.599999999999,13262.7,null,9608.4500000000007,19216.89,9608.4500000000007,null,null,null,{"$f":"SUM(E59:P59)","v":82927.09}]
[null,null,"Facture",0.15,{"$f":"IF(E59=\"\",\"\",E59*$D60)","v":""},"",2032.05,2652.5399999999995,1989.405,"",1441.2675000000002,2882.5335,1441.2675000000002,"","","",{"$f":"SUM(E60:P60)","v":12439.063499999998}]
[null,null,"Date reçu"]
[null,null,"Commission",0.1,{"$f":"IF(E59=\"\",\"\",E59*$D62)","v":""},"",1354.7,1768.36,1326.2700000000002,"",960.84500000000014,1921.6890000000001,960.84500000000014,"","","",{"$f":"SUM(E62:P62)","v":8292.7090000000007}]
[null,null,"Date payée"]
[null,null,"Commission à payer",null,{"$f":"IF(E59=\"\",\"\",IF(E63>0,\"\",IF(E61>0,E62,\"\")))","v":""},{"$f":"IF(F59=\"\",\"\",IF(F63>0,\"\",IF(F61>0,F62,\"\")))","v":""},{"$f":"IF(G59=\"\",\"\",IF(G63>0,\"\",IF(G61>0,G62,\"\")))","v":""},{"$f":"IF(H59=\"\",\"\",IF(H63>0,\"\",IF(H61>0,H62,\"\")))","v":""},{"$f":"IF(I59=\"\",\"\",IF(I63>0,\"\",IF(I61>0,I62,\"\")))","v":""},{"$f":"IF(J59=\"\",\"\",IF(J63>0,\"\",IF(J61>0,J62,\"\")))","v":""},{"$f":"IF(K59=\"\",\"\",IF(K63>0,\"\",IF(K61>0,K62,\"\")))","v":""},{"$f":"IF(L59=\"\",\"\",IF(L63>0,\"\",IF(L61>0,L62,\"\")))","v":""},{"$f":"IF(M59=\"\",\"\",IF(M63>0,\"\",IF(M61>0,M62,\"\")))","v":""},{"$f":"IF(N59=\"\",\"\",IF(N63>0,\"\",IF(N61>0,N62,\"\")))","v":""},{"$f":"IF(O59=\"\",\"\",IF(O63>0,\"\",IF(O61>0,O62,\"\")))","v":""},{"$f":"IF(P59=\"\",\"\",IF(P63>0,\"\",IF(P61>0,P62,\"\")))","v":""},{"$f":"SUM(E64:P64)","v":0}]
[null,"Astral Métrovision/Azur (#59719)","Contrat",null,null,null,null,7692.11,5192.3900000000003,null,2870.06,{"$f":"5740.11+1230.8+1179.2","v":8150.11},{"$f":"2870.06+1179.2","v":4049.26},null,null,null,{"$f":"SUM(E65:P65)","v":27953.93}]
[null,null,"Facture",0.15,{"$f":"IF(E65=\"\",\"\",E65*$D66)","v":""},"","",1153.8164999999999,778.85850000000005,"",430.50899999999996,1222.5165,607.38900000000001,"","","",{"$f":"SUM(E66:P66)","v":4193.0895}]
[null,null,"Date reçu"]
[null,null,"Commission",0.1,{"$f":"IF(E65=\"\",\"\",E65*$D68)","v":""},"","",769.21100000000001,519.23900000000003,"",287.00600000000003,815.01099999999997,404.92600000000004,"","","",{"$f":"SUM(E68:P68)","v":2795.393}]
[null,null,"Date payée"]
[null,null,"Commission à payer",null,{"$f":"IF(E65=\"\",\"\",IF(E69>0,\"\",IF(E67>0,E68,\"\")))","v":""},{"$f":"IF(F65=\"\",\"\",IF(F69>0,\"\",IF(F67>0,F68,\"\")))","v":""},{"$f":"IF(G65=\"\",\"\",IF(G69>0,\"\",IF(G67>0,G68,\"\")))","v":""},{"$f":"IF(H65=\"\",\"\",IF(H69>0,\"\",IF(H67>0,H68,\"\")))","v":""},{"$f":"IF(I65=\"\",\"\",IF(I69>0,\"\",IF(I67>0,I68,\"\")))","v":""},{"$f":"IF(J65=\"\",\"\",IF(J69>0,\"\",IF(J67>0,J68,\"\")))","v":""},{"$f":"IF(K65=\"\",\"\",IF(K69>0,\"\",IF(K67>0,K68,\"\")))","v":""},{"$f":"IF(L65=\"\",\"\",IF(L69>0,\"\",IF(L67>0,L68,\"\")))","v":""},{"$f":"IF(M65=\"\",\"\",IF(M69>0,\"\",IF(M67>0,M68,\"\")))","v":""},{"$f":"IF(N65=\"\",\"\",IF(N69>0,\"\",IF(N67>0,N68,\"\")))","v":""},{"$f":"IF(O65=\"\",\"\",IF(O69>0,\"\",IF(O67>0,O68,\"\")))","v":""},{"$f":"IF(P65=\"\",\"\",IF(P69>0,\"\",IF(P67>0,P68,\"\")))","v":""},{"$f":"SUM(E70:P70)","v":0}]
[null,null,{"$f":"Sommaire!$A$1","v":"Contrat"}]
["Nathalie Brault, Syndic","Campagne internet","Contrat",null,null,null,null,null,null,3700,3200,3100,null,null,null,null,{"$f":"SUM(E72:P72)","v":10000}]
[null,null,"Facture",0.15,{"$f":"IF(E72=\"\",\"\",E72*$D73)","v":""},"","","","",555,480,465,"","","","",{"$f":"SUM(E73:P73)","v":1500}]
[null,null,"Date reçu"]
[null,null,"Commission",0.1,{"$f":"IF(E72=\"\",\"\",E72*$D75)","v":""},"","","","",370,320,310,"","","","",{"$f":"SUM(E75:P75)","v":1000}]
[null,null,"Date payée"]
[null,null,"Commission à payer",null,{"$f":"IF(E72=\"\",\"\",IF(E76>0,\"\",IF(E74>0,E75,\"\")))","v":""},{"$f":"IF(F72=\"\",\"\",IF(F76>0,\"\",IF(F74>0,F75,\"\")))","v":""},{"$f":"IF(G72=\"\",\"\",IF(G76>0,\"\",IF(G74>0,G75,\"\")))","v":""},{"$f":"IF(H72=\"\",\"\",IF(H76>0,\"\",IF(H74>0,H75,\"\")))","v":""},{"$f":"IF(I72=\"\",\"\",IF(I76>0,\"\",IF(I74>0,I75,\"\")))","v":""},{"$f":"IF(J72=\"\",\"\",IF(J76>0,\"\",IF(J74>0,J75,\"\")))","v":""},{"$f":"IF(K72=\"\",\"\",IF(K76>0,\"\",IF(K74>0,K75,\"\")))","v":""},{"$f":"IF(L72=\"\",\"\",IF(L76>0,\"\",IF(L74>0,L75,\"\")))","v":""},{"$f":"IF(M72=\"\",\"\",IF(M76>0,\"\",IF(M74>0,M75,\"\")))","v":""},{"$f":"IF(N72=\"\",\"\",IF(N76>0,\"\",IF(N74>0,N75,\"\")))","v":""},{"$f":"IF(O72=\"\",\"\",IF(O76>0,\"\",IF(O74>0,O75,\"\")))","v":""},{"$f":"IF(P72=\"\",\"\",IF(P76>0,\"\",IF(P74>0,P75,\"\")))","v":""},{"$f":"SUM(E77:P77)","v":0}]
[null,"Plaque de cuivre","Contrat",null,null,null,null,null,578.5,null,null,null,null,null,null,null,{"$f":"SUM(E78:P78)","v":578.5}]
[null,null,"Facture",1,{"$f":"IF(E78=\"\",\"\",E78*$D79)","v":""},"","","",578.5,"","","","","","","",{"$f":"SUM(E79:P79)","v":578.5}]
[null,null,"Date reçu"]
[null,null,"Commission",0.1,{"$f":"IF(E78=\"\",\"\",E78*$D81)","v":""},"","","",57.85,"","","","","","","",{"$f":"SUM(E81:P81)","v":57.85}]
[null,null,"Date payée"]
[null,null,"Commission à payer",null,{"$f":"IF(E78=\"\",\"\",IF(E82>0,\"\",IF(E80>0,E81,\"\")))","v":""},{"$f":"IF(F78=\"\",\"\",IF(F82>0,\"\",IF(F80>0,F81,\"\")))","v":""},{"$f":"IF(G78=\"\",\"\",IF(G82>0,\"\",IF(G80>0,G81,\"\")))","v":""},{"$f":"IF(H78=\"\",\"\",IF(H82>0,\"\",IF(H80>0,H81,\"\")))","v":""},{"$f":"IF(I78=\"\",\"\",IF(I82>0,\"\",IF(I80>0,I81,\"\")))","v":""},{"$f":"IF(J78=\"\",\"\",IF(J82>0,\"\",IF(J80>0,J81,\"\")))","v":""},{"$f":"IF(K78=\"\",\"\",IF(K82>0,\"\",IF(K80>0,K81,\"\")))","v":""},{"$f":"IF(L78=\"\",\"\",IF(L82>0,\"\",IF(L80>0,L81,\"\")))","v":""},{"$f":"IF(M78=\"\",\"\",IF(M82>0,\"\",IF(M80>0,M81,\"\")))","v":""},{"$f":"IF(N78=\"\",\"\",IF(N82>0,\"\",IF(N80>0,N81,\"\")))","v":""},{"$f":"IF(O78=\"\",\"\",IF(O82>0,\"\",IF(O80>0,O81,\"\")))","v":""},{"$f":"IF(P78=\"\",\"\",IF(P82>0,\"\",IF(P80>0,P81,\"\")))","v":""},{"$f":"SUM(E83:P83)","v":0}]
[null,null,{"$f":"Sommaire!$A$1","v":"Contrat"}]
[null,null,"Contrat",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E85:P85)","v":0}]
[null,null,"Facture",0.15,{"$f":"IF(E85=\"\",\"\",E85*$D86)","v":""},"","","","","","","","","","","",{"$f":"SUM(E86:P86)","v":0}]
[null,null,"Date reçu"]
[null,null,"Commission",0.1,{"$f":"IF(E85=\"\",\"\",E85*$D88)","v":""},"","","","","","","","","","","",{"$f":"SUM(E88:P88)","v":0}]
[null,null,"Date payée"]
[null,null,"Commission à payer",null,{"$f":"IF(E85=\"\",\"\",IF(E89>0,\"\",IF(E87>0,E88,\"\")))","v":""},{"$f":"IF(F85=\"\",\"\",IF(F89>0,\"\",IF(F87>0,F88,\"\")))","v":""},"","","","","","","","","","",{"$f":"SUM(E90:P90)","v":0}]
[null,null,{"$f":"Sommaire!$A$1","v":"Contrat"}]
["Total",null,"Contrat",null,{"$f":"SUMIF($C$5:$C$26,$C92,E$5:E$26)","v":18310.11},61111.020000000004,19367.32,13400,4489,33733,42080,2646,0,0,0,0,{"$f":"SUM(E92:P92)","v":195136.45}]
[null,null,"Facture",null,{"$f":"SUMIF($C$5:$C$91,$C93,E$5:E$91)","v":5804.8485000000001},{"$f":"SUMIF($C$5:$C$91,$C93,F$5:F$91)","v":17970.902999999998},6077.1480000000001,17881.356500000002,4695.1135000000004,8614.9500000000007,8663.7764999999999,4966.95,2048.6565000000001,0,0,0,{"$f":"SUM(E93:P93)","v":76723.702499999985}]
[null,null,"Commission",null,1566.4110000000001,5846.5020000000004,1672.1320000000001,1340,448.90000000000003,3108.7000000000003,3943.4,0,0,0,0,0,17926.045000000002]
[null,null,"Commission à payer",null,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Représentant 3","index":3,"n_rows":44,"n_cols":18,"rows_kept":44,"cut":false,"hidden":false,"merged":[[21,2,21,3],[15,2,15,3],[8,2,8,3],[33,2,33,3],[35,2,35,3],[37,2,37,3],[38,2,38,3],[28,2,28,3],[39,2,39,3],[10,2,10,3],[11,2,11,3],[6,1,11,1],[6,0,11,0],[32,2,32,3],[12,2,12,3],[17,2,17,3],[18,2,18,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[19,2,19,3],[13,2,13,3],[13,1,18,1],[19,1,24,1],[13,0,24,0],[30,2,30,3],[31,2,31,3],[26,2,26,3],[26,1,31,1],[33,0,38,0],[33,1,38,1],[6,2,6,3],[5,2,5,3],[3,0,4,0],[3,1,4,1],[3,2,4,3],[3,17,4,17],[0,0,0,17],[1,0,1,17],[2,0,2,17],[26,0,31,0],[40,0,43,1],[40,2,40,3],[41,2,41,3],[42,2,42,3],[43,2,43,3]]}
[{"$f":"Sommaire!B1","v":"Compagnie"}]
["Représentant 3"]
[{"$f":"Sommaire!B2","v":"Prévision des contrats"}]
["Client","Nom du média\n# contrat",null,null,{"$f":"Sommaire!C4","v":"Septembre"},{"$f":"Sommaire!D4","v":"Octobre"},{"$f":"Sommaire!E4","v":"Novembre"},{"$f":"Sommaire!F4","v":"Décembre"},{"$f":"Sommaire!G4","v":"Janvier"},{"$f":"Sommaire!H4","v":"Février"},{"$f":"Sommaire!I4","v":"Mars"},{"$f":"Sommaire!J4","v":"Avril"},{"$f":"Sommaire!K4","v":"Mai"},{"$f":"Sommaire!L4","v":"Juin"},{"$f":"Sommaire!M4","v":"Juillet"},{"$f":"Sommaire!N4","v":"Août"},null,"Total"]
[null,null,null,null,{"$f":"Sommaire!C5","v":2018},{"$f":"Sommaire!D5","v":2018},{"$f":"Sommaire!E5","v":2018},{"$f":"Sommaire!F5","v":2018},{"$f":"Sommaire!G5","v":2019},{"$f":"Sommaire!H5","v":2019},{"$f":"Sommaire!I5","v":2019},{"$f":"Sommaire!J5","v":2019},{"$f":"Sommaire!K5","v":2019},{"$f":"Sommaire!L5","v":2019},{"$f":"Sommaire!M5","v":2019},{"$f":"Sommaire!N5","v":2019}]
[null,null,{"$f":"Sommaire!$A$1","v":"Contrat"}]
["Centre Jardin Brossard","Affichage","Contrat",null,null,null,null,null,null,null,null,22295,null,null,null,null,null,{"$f":"SUM(E7:P7)","v":22295}]
[null,null,"Facture",0.15,{"$f":"IF(E7=\"\",\"\",E7*$D8)","v":""},"","","","","","",3344.25,"","","","",null,{"$f":"SUM(E8:P8)","v":3344.25}]
[null,null,"Date reçu"]
[null,null,"Commission",0.1,{"$f":"IF(E7=\"\",\"\",E7*$D10)","v":""},"","","","","","",2229.5,"","","","",null,{"$f":"SUM(E10:Q10)","v":2229.5}]
[null,null,"Date payée"]
[null,null,"Commission à payer",null,{"$f":"IF(E7=\"\",\"\",IF(E11>0,\"\",IF(E9>0,E10,\"\")))","v":""},{"$f":"IF(F7=\"\",\"\",IF(F11>0,\"\",IF(F9>0,F10,\"\")))","v":""},{"$f":"IF(G7=\"\",\"\",IF(G11>0,\"\",IF(G9>0,G10,\"\")))","v":""},{"$f":"IF(H7=\"\",\"\",IF(H11>0,\"\",IF(H9>0,H10,\"\")))","v":""},{"$f":"IF(I7=\"\",\"\",IF(I11>0,\"\",IF(I9>0,I10,\"\")))","v":""},{"$f":"IF(J7=\"\",\"\",IF(J11>0,\"\",IF(J9>0,J10,\"\")))","v":""},{"$f":"IF(K7=\"\",\"\",IF(K11>0,\"\",IF(K9>0,K10,\"\")))","v":""},{"$f":"IF(L7=\"\",\"\",IF(L11>0,\"\",IF(L9>0,L10,\"\")))","v":""},{"$f":"IF(M7=\"\",\"\",IF(M11>0,\"\",IF(M9>0,M10,\"\")))","v":""},{"$f":"IF(N7=\"\",\"\",IF(N11>0,\"\",IF(N9>0,N10,\"\")))","v":""},{"$f":"IF(O7=\"\",\"\",IF(O11>0,\"\",IF(O9>0,O10,\"\")))","v":""},{"$f":"IF(P7=\"\",\"\",IF(P11>0,\"\",IF(P9>0,P10,\"\")))","v":""},null,{"$f":"SUM(E12:Q12)","v":0}]
[null,null,{"$f":"Sommaire!$A$1","v":"Contrat"}]
["Fenplast","98,5 FM (#235696)","Contrat",null,{"$f":"16000+4100+850+1100","v":22050},{"$f":"4100+850","v":4950},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E14:P14)","v":27000}]
[null,null,"Facture",0.15,{"$f":"IF(E14=\"\",\"\",E14*$D15)","v":3307.5},742.5,"","","","","","","","","","",null,{"$f":"SUM(E15:P15)","v":4050}]
[null,null,"Date reçu"]
[null,null,"Commission",0.1,{"$f":"IF(E14=\"\",\"\",E14*$D17)","v":2205},495,"","","","","","","","","","",null,{"$f":"SUM(E17:Q17)","v":2700}]
[null,null,"Date payée"]
[null,null,"Commission à payer",null,{"$f":"IF(E14=\"\",\"\",IF(E18>0,\"\",IF(E16>0,E17,\"\")))","v":""},{"$f":"IF(F14=\"\",\"\",IF(F18>0,\"\",IF(F16>0,F17,\"\")))","v":""},{"$f":"IF(G14=\"\",\"\",IF(G18>0,\"\",IF(G16>0,G17,\"\")))","v":""},{"$f":"IF(H14=\"\",\"\",IF(H18>0,\"\",IF(H16>0,H17,\"\")))","v":""},{"$f":"IF(I14=\"\",\"\",IF(I18>0,\"\",IF(I16>0,I17,\"\")))","v":""},{"$f":"IF(J14=\"\",\"\",IF(J18>0,\"\",IF(J16>0,J17,\"\")))","v":""},{"$f":"IF(K14=\"\",\"\",IF(K18>0,\"\",IF(K16>0,K17,\"\")))","v":""},{"$f":"IF(L14=\"\",\"\",IF(L18>0,\"\",IF(L16>0,L17,\"\")))","v":""},{"$f":"IF(M14=\"\",\"\",IF(M18>0,\"\",IF(M16>0,M17,\"\")))","v":""},{"$f":"IF(N14=\"\",\"\",IF(N18>0,\"\",IF(N16>0,N17,\"\")))","v":""},{"$f":"IF(O14=\"\",\"\",IF(O18>0,\"\",IF(O16>0,O17,\"\")))","v":""},{"$f":"IF(P14=\"\",\"\",IF(P18>0,\"\",IF(P16>0,P17,\"\")))","v":""},null,{"$f":"SUM(E19:Q19)","v":0}]
[null,"Toile","Contrat",null,null,null,null,1145,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E20:P20)","v":1145}]
[null,null,"Facture",0.15,{"$f":"IF(E20=\"\",\"\",E20*$D21)","v":""},"","",171.75,"","","","","","","","",null,{"$f":"SUM(E21:P21)","v":171.75}]
[null,null,"Date reçu"]
[null,null,"Commission",0.1,{"$f":"IF(E20=\"\",\"\",E20*$D23)","v":""},"","",114.5,"","","","","","","","",null,{"$f":"SUM(E23:Q23)","v":114.5}]
[null,null,"Date payée"]
[null,null,"Commission à payer",null,{"$f":"IF(E20=\"\",\"\",IF(E24>0,\"\",IF(E22>0,E23,\"\")))","v":""},{"$f":"IF(F20=\"\",\"\",IF(F24>0,\"\",IF(F22>0,F23,\"\")))","v":""},{"$f":"IF(G20=\"\",\"\",IF(G24>0,\"\",IF(G22>0,G23,\"\")))","v":""},{"$f":"IF(H20=\"\",\"\",IF(H24>0,\"\",IF(H22>0,H23,\"\")))","v":""},{"$f":"IF(I20=\"\",\"\",IF(I24>0,\"\",IF(I22>0,I23,\"\")))","v":""},{"$f":"IF(J20=\"\",\"\",IF(J24>0,\"\",IF(J22>0,J23,\"\")))","v":""},{"$f":"IF(K20=\"\",\"\",IF(K24>0,\"\",IF(K22>0,K23,\"\")))","v":""},{"$f":"IF(L20=\"\",\"\",IF(L24>0,\"\",IF(L22>0,L23,\"\")))","v":""},{"$f":"IF(M20=\"\",\"\",IF(M24>0,\"\",IF(M22>0,M23,\"\")))","v":""},{"$f":"IF(N20=\"\",\"\",IF(N24>0,\"\",IF(N22>0,N23,\"\")))","v":""},{"$f":"IF(O20=\"\",\"\",IF(O24>0,\"\",IF(O22>0,O23,\"\")))","v":""},{"$f":"IF(P20=\"\",\"\",IF(P24>0,\"\",IF(P22>0,P23,\"\")))","v":""},null,{"$f":"SUM(E25:Q25)","v":0}]
[null,null,{"$f":"Sommaire!$A$1","v":"Contrat"}]
["Spiritueux Ungava","Zaralisée","Contrat",null,null,null,1150,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E27:P27)","v":1150}]
[null,null,"Facture",1,{"$f":"IF(E27=\"\",\"\",E27*$D28)","v":""},"",1150,"","","","","","","","","",null,{"$f":"SUM(E28:Q28)","v":1150}]
[null,null,"Date reçu"]
[null,null,"Commission",0.1,{"$f":"IF(E27=\"\",\"\",E27*$D30)","v":""},"",115,"","","","","","","","","",null,{"$f":"SUM(E30:Q30)","v":115}]
[null,null,"Date payée"]
[null,null,"Commission à payer",null,{"$f":"IF(E27=\"\",\"\",IF(E31>0,\"\",IF(E29>0,E30,\"\")))","v":""},{"$f":"IF(F27=\"\",\"\",IF(F31>0,\"\",IF(F29>0,F30,\"\")))","v":""},{"$f":"IF(G27=\"\",\"\",IF(G31>0,\"\",IF(G29>0,G30,\"\")))","v":""},{"$f":"IF(H27=\"\",\"\",IF(H31>0,\"\",IF(H29>0,H30,\"\")))","v":""},{"$f":"IF(I27=\"\",\"\",IF(I31>0,\"\",IF(I29>0,I30,\"\")))","v":""},{"$f":"IF(J27=\"\",\"\",IF(J31>0,\"\",IF(J29>0,J30,\"\")))","v":""},{"$f":"IF(K27=\"\",\"\",IF(K31>0,\"\",IF(K29>0,K30,\"\")))","v":""},{"$f":"IF(L27=\"\",\"\",IF(L31>0,\"\",IF(L29>0,L30,\"\")))","v":""},{"$f":"IF(M27=\"\",\"\",IF(M31>0,\"\",IF(M29>0,M30,\"\")))","v":""},{"$f":"IF(N27=\"\",\"\",IF(N31>0,\"\",IF(N29>0,N30,\"\")))","v":""},{"$f":"IF(O27=\"\",\"\",IF(O31>0,\"\",IF(O29>0,O30,\"\")))","v":""},{"$f":"IF(P27=\"\",\"\",IF(P31>0,\"\",IF(P29>0,P30,\"\")))","v":""},null,{"$f":"SUM(E32:Q32)","v":0}]
[null,null,{"$f":"Sommaire!$A$1","v":"Contrat"}]
[null,null,"Contrat",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E34:Q34)","v":0}]
[null,null,"Facture",0.15,{"$f":"IF(E34=\"\",\"\",E34*$D35)","v":""},"","","","","","","","","","","",null,{"$f":"SUM(E35:Q35)","v":0}]
[null,null,"Date reçu"]
[null,null,"Commission",0.1,{"$f":"IF(E34=\"\",\"\",E34*$D37)","v":""},"","","","","","","","","","","",null,{"$f":"SUM(E37:Q37)","v":0}]
[null,null,"Date payée"]
[null,null,"Commission à payer",null,{"$f":"IF(E34=\"\",\"\",IF(E38>0,\"\",IF(E36>0,E37,\"\")))","v":""},{"$f":"IF(F34=\"\",\"\",IF(F38>0,\"\",IF(F36>0,F37,\"\")))","v":""},"","","","","","","","","","",null,{"$f":"SUM(E39:Q39)","v":0}]
[null,null,{"$f":"Sommaire!$A$1","v":"Contrat"}]
["Total",null,"Contrat",null,{"$f":"SUMIF($C$7:$C$27,$C41,E$7:E$27)","v":22050},{"$f":"SUMIF($C$7:$C$27,$C41,F$7:F$27)","v":4950},{"$f":"SUMIF($C$7:$C$27,$C41,G$7:G$27)","v":1150},{"$f":"SUMIF($C$7:$C$27,$C41,H$7:H$27)","v":1145},{"$f":"SUMIF($C$7:$C$27,$C41,I$7:I$27)","v":0},{"$f":"SUMIF($C$7:$C$27,$C41,J$7:J$27)","v":0},{"$f":"SUMIF($C$7:$C$27,$C41,K$7:K$27)","v":0},{"$f":"SUMIF($C$7:$C$27,$C41,L$7:L$27)","v":22295},{"$f":"SUMIF($C$7:$C$27,$C41,M$7:M$27)","v":0},{"$f":"SUMIF($C$7:$C$27,$C41,N$7:N$27)","v":0},{"$f":"SUMIF($C$7:$C$27,$C41,O$7:O$27)","v":0},{"$f":"SUMIF($C$7:$C$27,$C41,P$7:P$27)","v":0},null,{"$f":"SUM(E41:Q41)","v":51590}]
[null,null,"Facture",null,{"$f":"SUMIF($C$7:$C$27,$C42,E$7:E$27)","v":3307.5},{"$f":"SUMIF($C$7:$C$27,$C42,F$7:F$27)","v":742.5},{"$f":"SUMIF($C$7:$C$27,$C42,G$7:G$27)","v":0},{"$f":"SUMIF($C$7:$C$27,$C42,H$7:H$27)","v":171.75},{"$f":"SUMIF($C$7:$C$27,$C42,I$7:I$27)","v":0},{"$f":"SUMIF($C$7:$C$27,$C42,J$7:J$27)","v":0},{"$f":"SUMIF($C$7:$C$27,$C42,K$7:K$27)","v":0},{"$f":"SUMIF($C$7:$C$27,$C42,L$7:L$27)","v":3344.25},{"$f":"SUMIF($C$7:$C$27,$C42,M$7:M$27)","v":0},{"$f":"SUMIF($C$7:$C$27,$C42,N$7:N$27)","v":0},{"$f":"SUMIF($C$7:$C$27,$C42,O$7:O$27)","v":0},{"$f":"SUMIF($C$7:$C$27,$C42,P$7:P$27)","v":0},null,{"$f":"SUM(E42:Q42)","v":7566}]
[null,null,"Commission",null,{"$f":"SUMIF($C$7:$C$27,$C43,E$7:E$27)","v":2205},{"$f":"SUMIF($C$7:$C$27,$C43,F$7:F$27)","v":495},{"$f":"SUMIF($C$7:$C$27,$C43,G$7:G$27)","v":0},{"$f":"SUMIF($C$7:$C$27,$C43,H$7:H$27)","v":114.5},{"$f":"SUMIF($C$7:$C$27,$C43,I$7:I$27)","v":0},{"$f":"SUMIF($C$7:$C$27,$C43,J$7:J$27)","v":0},{"$f":"SUMIF($C$7:$C$27,$C43,K$7:K$27)","v":0},{"$f":"SUMIF($C$7:$C$27,$C43,L$7:L$27)","v":2229.5},{"$f":"SUMIF($C$7:$C$27,$C43,M$7:M$27)","v":0},{"$f":"SUMIF($C$7:$C$27,$C43,N$7:N$27)","v":0},{"$f":"SUMIF($C$7:$C$27,$C43,O$7:O$27)","v":0},{"$f":"SUMIF($C$7:$C$27,$C43,P$7:P$27)","v":0},{"$f":"SUM(Q14:Q32)","v":0},{"$f":"SUM(E43:Q43)","v":5044}]
[null,null,"Commission à payer",null,{"$f":"SUMIF($C$7:$C$27,$C44,E$7:E$27)","v":0},{"$f":"SUMIF($C$7:$C$27,$C44,F$7:F$27)","v":0},{"$f":"SUMIF($C$7:$C$27,$C44,G$7:G$27)","v":0},{"$f":"SUMIF($C$7:$C$27,$C44,H$7:H$27)","v":0},{"$f":"SUMIF($C$7:$C$27,$C44,I$7:I$27)","v":0},{"$f":"SUMIF($C$7:$C$27,$C44,J$7:J$27)","v":0},{"$f":"SUMIF($C$7:$C$27,$C44,K$7:K$27)","v":0},{"$f":"SUMIF($C$7:$C$27,$C44,L$7:L$27)","v":0},{"$f":"SUMIF($C$7:$C$27,$C44,M$7:M$27)","v":0},{"$f":"SUMIF($C$7:$C$27,$C44,N$7:N$27)","v":0},{"$f":"SUMIF($C$7:$C$27,$C44,O$7:O$27)","v":0},{"$f":"SUMIF($C$7:$C$27,$C44,P$7:P$27)","v":0},{"$f":"SUM(Q14:Q33)","v":0},{"$f":"SUM(E44:Q44)","v":0}]

{"sheet":"Original","index":4,"n_rows":17,"n_cols":18,"rows_kept":17,"cut":false,"hidden":false,"merged":[[5,0,5,1],[5,2,5,3],[6,0,11,0],[6,1,11,1],[6,2,6,3],[8,2,8,3],[10,2,10,3],[11,2,11,3],[0,0,0,17],[1,0,1,17],[2,0,2,17],[3,0,4,0],[3,1,4,1],[3,2,4,3],[3,17,4,17],[13,0,16,1],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[12,2,12,3]]}
[{"$f":"Sommaire!B1","v":"Compagnie"}]
["Représentant: "]
[{"$f":"Sommaire!B2","v":"Prévision des contrats"}]
["Client","Nom du média\n# contrat",null,null,{"$f":"Sommaire!C4","v":"Septembre"},{"$f":"Sommaire!D4","v":"Octobre"},{"$f":"Sommaire!E4","v":"Novembre"},{"$f":"Sommaire!F4","v":"Décembre"},{"$f":"Sommaire!G4","v":"Janvier"},{"$f":"Sommaire!H4","v":"Février"},{"$f":"Sommaire!I4","v":"Mars"},{"$f":"Sommaire!J4","v":"Avril"},{"$f":"Sommaire!K4","v":"Mai"},{"$f":"Sommaire!L4","v":"Juin"},{"$f":"Sommaire!M4","v":"Juillet"},{"$f":"Sommaire!N4","v":"Août"},null,"Total"]
[null,null,null,null,{"$f":"Sommaire!C5","v":2018},{"$f":"Sommaire!D5","v":2018},{"$f":"Sommaire!E5","v":2018},{"$f":"Sommaire!F5","v":2018},{"$f":"Sommaire!G5","v":2019},{"$f":"Sommaire!H5","v":2019},{"$f":"Sommaire!I5","v":2019},{"$f":"Sommaire!J5","v":2019},{"$f":"Sommaire!K5","v":2019},{"$f":"Sommaire!L5","v":2019},{"$f":"Sommaire!M5","v":2019},{"$f":"Sommaire!N5","v":2019}]
[null,null,{"$f":"$A$3","v":"Prévision des contrats"}]
[null,null,"Contrat",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E7:Q7)","v":0}]
[null,null,"Facture",0.15,{"$f":"IF(E7=\"\",\"\",E7*$D8)","v":""},"","","","","","","","","","","",null,{"$f":"SUM(E8:Q8)","v":0}]
[null,null,"Date reçu"]
[null,null,"Commission",0.1,{"$f":"IF(E7=\"\",\"\",E7*$D10)","v":""},"","","","","","","","","","","",null,{"$f":"SUM(E10:Q10)","v":0}]
[null,null,"Date payée"]
[null,null,"Commission à payer",null,{"$f":"IF(E7=\"\",\"\",IF(E11>0,\"\",IF(E9>0,E10,\"\")))","v":""},{"$f":"IF(F7=\"\",\"\",IF(F11>0,\"\",IF(F9>0,F10,\"\")))","v":""},"","","","","","","","","","",null,{"$f":"SUM(E12:Q12)","v":0}]
[null,null,{"$f":"$A$3","v":"Prévision des contrats"}]
["Total",null,"Contrat",null,{"$f":"SUMIF($C$6:$C$13,$C14,E$6:E$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C14,F$6:F$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C14,G$6:G$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C14,H$6:H$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C14,I$6:I$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C14,J$6:J$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C14,K$6:K$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C14,L$6:L$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C14,M$6:M$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C14,N$6:N$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C14,O$6:O$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C14,P$6:P$13)","v":0},null,{"$f":"SUM(E14:Q14)","v":0}]
[null,null,"Facture",null,{"$f":"SUMIF($C$6:$C$13,$C15,E$6:E$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C15,F$6:F$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C15,G$6:G$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C15,H$6:H$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C15,I$6:I$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C15,J$6:J$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C15,K$6:K$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C15,L$6:L$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C15,M$6:M$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C15,N$6:N$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C15,O$6:O$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C15,P$6:P$13)","v":0},null,{"$f":"SUM(E15:Q15)","v":0}]
[null,null,"Commission",null,{"$f":"SUMIF($C$6:$C$13,$C16,E$6:E$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C16,F$6:F$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C16,G$6:G$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C16,H$6:H$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C16,I$6:I$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C16,J$6:J$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C16,K$6:K$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C16,L$6:L$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C16,M$6:M$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C16,N$6:N$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C16,O$6:O$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C16,P$6:P$13)","v":0},{"$f":"SUM(Q6:Q12)","v":0},{"$f":"SUM(E16:Q16)","v":0}]
[null,null,"Commission à payer",null,{"$f":"SUMIF($C$6:$C$13,$C17,E$6:E$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C17,F$6:F$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C17,G$6:G$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C17,H$6:H$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C17,I$6:I$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C17,J$6:J$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C17,K$6:K$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C17,L$6:L$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C17,M$6:M$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C17,N$6:N$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C17,O$6:O$13)","v":0},{"$f":"SUMIF($C$6:$C$13,$C17,P$6:P$13)","v":0},{"$f":"SUM(Q6:Q13)","v":0},{"$f":"SUM(E17:Q17)","v":0}]