{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["original","résultat voulu","après avoir exécuté macro","mais voudrais idéalement"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"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":"original","index":0,"n_rows":58,"n_cols":87,"rows_kept":58,"cut":false,"hidden":false,"merged":[[4,57,4,59],[0,48,1,56],[0,57,1,65],[0,66,1,74],[0,39,1,47],[2,39,3,42],[2,43,3,46],[2,47,3,47],[2,52,3,55],[2,56,3,56],[2,57,3,60],[2,61,3,64],[2,65,3,65],[2,29,3,29],[2,30,3,33],[2,34,3,37],[46,0,46,2],[0,0,3,2],[0,12,1,20],[0,21,1,29],[0,30,1,38],[2,38,3,38],[2,12,3,15],[2,16,3,19],[2,20,3,20],[2,21,3,24],[2,25,3,28],[2,84,3,84],[0,85,4,85],[48,1,48,2],[0,3,1,11],[0,75,1,79],[0,80,1,84],[2,3,3,6],[2,7,3,10],[2,11,3,11],[2,66,3,69],[2,70,3,73],[2,74,3,74],[2,75,3,78],[2,79,3,79],[2,80,3,83],[2,48,3,51]]}
["CREDITS TRIMESTRIELS\nOCTOBRE - NOVEMBRE - DECEMBRE 2015",null,null,"FOURN. A",null,null,null,null,null,null,null,null,"FOURN. B",null,null,null,null,null,null,null,null,"FOURN. C",null,null,null,null,null,null,null,null,"FOURN. D",null,null,null,null,null,null,null,null,"FOURN. E",null,null,null,null,null,null,null,null,"FOURN. F",null,null,null,null,null,null,null,null,"FOURN. G",null,null,null,null,null,null,null,null,"FOURN. H",null,null,null,null,null,null,null,null,"FOURN. I-A",null,null,null,null,"FOURN. I-B",null,null,null,null,"TOTAL CRÉDITS "]
[]
[null,null,null,"DIRECT",null,null,null,"INDIRECT",null,null,null,"CRÉDIT ","DIRECT",null,null,null,"INDIRECT",null,null,null,"CRÉDIT ","DIRECT",null,null,null,"INDIRECT",null,null,null,"CRÉDIT ","DIRECT",null,null,null,"INDIRECT",null,null,null,"CRÉDIT ","DIRECT",null,null,null,"INDIRECT",null,null,null,"CRÉDIT ","DIRECT",null,null,null,"INDIRECT",null,null,null,"CRÉDIT ","DIRECT",null,null,null,"INDIRECT",null,null,null,"CRÉDIT ","DIRECT",null,null,null,"INDIRECT",null,null,null,"CRÉDIT ","DIRECT",null,null,null,"CRÉDIT","DIRECT",null,null,null,"CRÉDIT"]
[]
["# CLIENT","Nom de la succursale/Store Name","Ville/City","OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL DIR","OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL  MCK",0.05,"OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL DIR","OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL  MCK",0.05,"OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL DIR","OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL  MCK",0.1,"OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL DIR","OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL  MCK",0.1,"OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL DIR","OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL  MCK",0.05,"OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL DIR","OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL  MCK",0.1,"OCT - NOV - DEC",null,null,"TOTAL DIR","OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL  MCK",0.05,"OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL DIR","OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL  MCK",0.1,"OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL  DIR","2,5%",{"$f":"BX5","v":"OCTOBRE"},"NOVEMBRE","DECEMBRE","TOTAL  DIR",0.05]
[3520,"Client A","Waterloo",null,null,null,{"$f":"SUM(D6:F6)","v":0},null,null,null,{"$f":"SUM(H6:J6)","v":0},{"$f":"(G6+K6)*0.05","v":0},null,null,null,{"$f":"SUM(M6:O6)","v":0},25.75,301.27,335.38,{"$f":"SUM(Q6:S6)","v":662.4},{"$f":"(P6+T6)*0.05","v":33.119999999999997},{"$f":"27.52+28.42+12.91","v":68.849999999999994},{"$f":"50.05+28.42+166.32","v":244.79},86.58,{"$f":"SUM(V6:X6)","v":400.21999999999997},12.32,null,null,{"$f":"SUM(Z6:AB6)","v":12.32},{"$f":"(Y6+AC6)*0.1","v":41.253999999999998},156.54,243.65,141.01,{"$f":"SUM(AE6:AG6)","v":541.20000000000005},54.866,62.29,73.010000000000005,{"$f":"SUM(AI6:AK6)","v":190.166},{"$f":"(AH6+AL6)*0.1","v":73.136600000000001},null,null,null,{"$f":"SUM(AN6:AP6)","v":0},null,null,null,{"$f":"SUM(AR6:AT6)","v":0},{"$f":"(AQ6+AU6)*0.05","v":0},null,null,null,{"$f":"SUM(AW6:AY6)","v":0},null,null,null,{"$f":"SUM(BA6:BC6)","v":0},{"$f":"(AZ6+BD6)*0.1","v":0},null,null,null,{"$f":"SUM(BF6:BH6)","v":0},null,null,null,{"$f":"SUM(BJ6:BL6)","v":0},{"$f":"(BI6+BM6)*0.05","v":0},null,null,null,{"$f":"SUM(BO6:BQ6)","v":0},null,null,null,{"$f":"SUM(BS6:BU6)","v":0},{"$f":"(BR6+BV6)*0.1","v":0},null,null,null,{"$f":"SUM(BX6:BZ6)","v":0},{"$f":"CA6*0.025","v":0},null,null,null,{"$f":"SUM(CC6:CE6)","v":0},{"$f":"CF6*0.05","v":0},{"$f":"L6+U6+AD6+AM6+AV6+BN6+BW6+BE6+CB6+CG6","v":147.51060000000001}]
[3510,"Client B","Windsor",null,null,null,0,null,null,null,0,0,null,null,null,0,86.99,864.04,117.09,1068.1199999999999,53.405999999999999,null,null,null,0,null,null,null,0,0,2477.6799999999998,-2048.79,647.45000000000005,1076.3399999999999,38.369999999999997,176.07999999999998,4.8000000000000007,219.25,129.559,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,210,null,210,173.8,51.8,225.5,451.1,33.055,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,216.02]
[3562,"Client C","Gatineau",null,null,null,0,null,null,null,0,0,null,null,null,0,32.6,40.909999999999997,46.08,119.58999999999999,5.9794999999999998,null,null,null,0,3.56,null,30.8,34.36,3.4359999999999999,173.37,null,504.54,677.91000000000008,107.6,34.67,65.5,207.76999999999998,88.568000000000012,null,null,null,0,null,null,null,0,0,{"$f":"-49+157","v":108},null,null,108,null,null,null,0,10.8,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,108.7835]
[3579,"Client D","St-Jean-de-Dieu",null,null,null,0,null,null,null,0,0,null,null,1255,1255,15.9,179.29,70.2,265.39,76.019499999999994,null,null,null,0,3.56,null,null,3.56,0.35600000000000004,null,null,null,0,73.430000000000007,312.75200000000007,129.57000000000002,515.75200000000007,51.575200000000009,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,127.9507]
[3583,"Client E","Québec",null,null,null,0,null,null,null,0,0,null,null,null,0,null,453.31,29.53,482.84000000000003,24.142000000000003,null,null,null,0,null,12.32,null,12.32,1.2320000000000002,null,null,null,0,null,81.13,71.97,153.1,15.31,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,9.1999999999999993,null,9.1999999999999993,0.45999999999999996,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,41.144000000000005]
[3585,"Client F","Montréal",null,null,null,0,null,null,null,0,0,null,null,null,0,1137.28,54.07,57.41,1248.76,62.438000000000002,null,null,null,0,null,7.12,null,7.12,0.71200000000000008,null,1.1399999999999999,null,1.1399999999999999,1341.1099999999997,43.46,26.68,1411.2499999999998,141.239,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,76,null,76,3.8000000000000003,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,208.18900000000002]
[3518,"Client G","Cantley",null,null,null,0,null,null,null,0,{"$f":"(G12+K12)*0.05","v":0},null,null,null,0,null,null,null,0,{"$f":"(P12+T12)*0.05","v":0},null,null,null,0,null,null,null,0,{"$f":"(Y12+AC12)*0.1","v":0},null,null,null,0,null,null,null,0,{"$f":"(AH12+AL12)*0.1","v":0},null,null,null,0,null,null,null,0,{"$f":"(AQ12+AU12)*0.05","v":0},null,null,null,0,null,null,null,0,{"$f":"(AZ12+BD12)*0.1","v":0},null,null,null,0,null,null,null,0,{"$f":"(BI12+BM12)*0.05","v":0},null,null,null,0,null,null,null,0,{"$f":"(BR12+BV12)*0.1","v":0},null,null,null,0,{"$f":"CA12*0.025","v":0},null,null,null,0,{"$f":"CF12*0.05","v":0},{"$f":"L12+U12+AD12+AM12+AV12+BN12+BW12+BE12+CB12+CG12","v":0}]
[3428,"Client H","St-Rémi",null,null,null,0,null,null,null,0,0,null,null,null,0,78.069999999999993,46.92,46.21,171.2,8.56,null,null,null,0,6.16,15.88,null,22.04,2.2040000000000002,null,null,1415.41,1415.41,26.852000000000004,38.43,7.4399999999999995,72.722000000000008,148.81320000000002,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,537.47,null,537.47,null,null,null,0,26.873500000000003,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,186.45070000000004]
[3281,"Client I","Pointe-aux-Trembles",null,null,null,0,null,null,null,0,0,null,null,null,0,-92.14,120.02,47.37,75.25,3.7625000000000002,null,null,null,0,null,null,null,0,0,2014.4,168.6,284.86,2467.86,151.15,51.83,132.11000000000001,335.09000000000003,280.29500000000002,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,315.3,null,null,315.3,15.765000000000001,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,299.82249999999999]
[3523,"Client J","St-Lambert",null,null,null,0,null,null,null,0,0,null,null,null,0,401.85,339.49,141.55000000000001,882.8900000000001,44.144500000000008,null,null,null,0,12.32,25.6,15.290000000000001,53.21,5.3210000000000006,null,null,596.27,596.27,125.15,98.660000000000011,122.79000000000002,346.6,94.287000000000006,null,null,null,0,null,null,null,0,0,193,139,{"$f":"100+361","v":461},793,null,null,null,0,79.300000000000011,null,null,null,0,4.5999999999999996,44.9,105.9,155.4,7.7700000000000005,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,230.82250000000002]
[3555,"Client K","Longueuil",null,null,null,0,null,null,36.44,36.44,1.8220000000000001,null,null,null,0,55.61,75.150000000000006,18.2,148.95999999999998,7.4479999999999995,null,null,null,0,null,null,2.91,2.91,0.29100000000000004,null,null,null,0,51.650000000000006,52.31,null,103.96000000000001,10.396000000000001,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,231,null,231,null,null,null,0,11.55,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,31.507000000000001]
[3345,"Client L","Shawinigan",null,null,null,0,null,null,null,0,0,null,null,null,0,25.42,20.5,16.5,62.42,3.1210000000000004,null,null,null,0,23,null,16.84,39.840000000000003,3.9840000000000004,125.89,-472.82,null,-346.93,4.95,null,14.88,19.830000000000002,-32.71,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,1660,null,1660,849,null,816,1665,166.25,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,140.64500000000001]
[3543,"Client M","Plessisville",null,null,null,0,null,null,null,0,0,null,null,null,0,485.48,391.48,71.08,948.04000000000008,47.402000000000008,null,null,null,0,27.52,null,24.64,52.16,5.2160000000000002,null,null,264.27,264.27,147.68600000000001,140.07,26.69,314.44599999999997,57.871599999999994,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,545,null,{"$f":"SUM(BG18:BH18)","v":545},null,553.5,38,591.5,56.825000000000003,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,167.31459999999998]
[3527,"Client N","St-Jean-sur-Richelieu",null,299.99,224.49,524.48,null,null,null,0,26.224000000000004,null,null,null,0,null,269.91000000000003,100.01,369.92,18.496000000000002,null,null,null,0,null,null,63.64,63.64,6.3640000000000008,null,564.66999999999996,743.64,1308.31,null,249.74199999999999,242.75,492.49199999999996,180.08019999999999,null,null,null,0,null,null,null,0,0,null,{"$f":"2940+153","v":3093},{"$f":"252+2467","v":2719},5812,null,null,null,0,581.20000000000005,null,null,null,{"$f":"SUM(BF19:BH19)","v":0},null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,3213.1,1305.1500000000001,4518.25,112.95625000000001,null,null,null,0,0,925.32044999999994]
[3133,"Client O","Matane",null,null,298.58999999999997,298.58999999999997,null,null,null,0,14.929499999999999,null,991,null,991,170.83,641.17999999999995,27.8,839.81,91.540500000000009,{"$f":"50.05+49.37+88.3","v":187.71999999999997},{"$f":"185.05+55.85","v":240.9},32.5,461.12,null,null,12.32,12.32,47.344000000000001,null,null,null,0,172.52,7.8,25.52,205.84000000000003,20.584000000000003,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,386,null,386,385.5,20,null,405.5,39.575000000000003,null,null,null,0,null,null,null,0,0,null,null,69,69,1.7250000000000001,null,null,null,0,0,215.69800000000001]
[3536,"Client P","Montréal",null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,1649.6,null,1649.6,null,null,null,0,82.48,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,82.48]
[3512,"Client Q","St-Jean-de-Matha",null,42.75,null,42.75,null,null,null,0,{"$f":"(G22+K22)*0.05","v":2.1375000000000002},1604,25,null,1629,526.38,467.42,19.84,1013.64,132.13200000000001,null,null,null,0,14.98,null,15.88,30.86,{"$f":"(Y22+AC22)*0.1","v":3.0860000000000003},425.44,null,863.82,1289.26,336.26,355.9,287.68299999999999,979.84299999999996,{"$f":"(AH22+AL22)*0.1","v":226.91030000000001},null,null,null,0,null,null,null,0,0,{"$f":"28+353.5+365.5","v":747},{"$f":"140+1514.5+197","v":1851.5},{"$f":"56+244.5","v":300.5},2899,null,null,null,0,289.90000000000003,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,138,null,null,138,3.45,null,null,null,0,0,657.61580000000004]
[3436,"Client R","St-Hyacinthe",null,105.33,118.38,223.70999999999998,null,null,null,0,11.185499999999999,null,null,null,0,null,13.68,20.37,34.049999999999997,{"$f":"(P23+T23)*0.05","v":1.7024999999999999},null,null,null,0,null,12.32,6.16,18.48,1.8480000000000001,null,null,456.32,456.32,null,63.25,42.52,105.77000000000001,56.209000000000003,null,null,null,0,null,null,null,0,{"$f":"(AQ23+AU23)*0.05","v":0},null,null,null,0,null,null,null,0,{"$f":"(AZ23+BD23)*0.1","v":0},null,1234.46,null,1234.46,null,457.6,881.6,1339.2,128.68299999999999,null,null,null,0,null,null,null,0,{"$f":"(BR23+BV23)*0.1","v":0},null,null,null,0,0,null,null,null,0,{"$f":"CF23*0.05","v":0},199.62799999999999]
[3521,"Client S","Montmagny",null,null,null,0,null,null,null,0,0,600,null,null,600,253.42,62.29,91.62,407.33,50.366500000000002,null,null,null,0,27.3,10.030000000000001,null,37.33,3.7330000000000001,167.29,569.29999999999995,486.07,1222.6599999999999,182.82000000000002,124.33000000000001,288.10000000000002,595.25,181.791,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,819.3,null,819.3,-268.64,null,null,-268.64,{"$f":"(BI24+BM24)*0.05","v":27.533000000000001},null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,{"$f":"L24+U24+AD24+AM24+AV24+BN24+BW24+BE24+CB24+CG24","v":263.42349999999999}]
[3199,"Client T","Jonquière",null,null,null,0,null,null,null,0,0,null,null,null,0,41.75,5.9,6.58,54.23,2.7115,null,null,null,0,null,null,6.16,6.16,0.6160000000000001,null,null,null,0,46.63,37.44,null,84.07,8.407,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,9.1999999999999993,9.1999999999999993,18.399999999999999,0.91999999999999993,null,null,null,0,null,null,null,0,0,null,null,null,0,{"$f":"CA25*0.025","v":0},null,null,null,0,0,12.654500000000001]
[3291,"Client U","St-Tite",null,null,null,0,null,null,null,0,0,null,null,null,0,89.5,456.55,125.55,671.59999999999991,33.58,null,null,90.36,90.36,3.56,3.56,8.82,15.940000000000001,10.63,945.58,null,null,945.58,167.54000000000002,301.39999999999998,31.009999999999998,499.95,144.553,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,188.76300000000001]
[3296,"Client V","Joliette",null,null,null,0,null,null,null,0,0,null,null,null,0,112.93,145.19999999999999,170.15,428.28,21.414000000000001,null,null,null,0,14.24,10.68,30.12,55.040000000000006,5.5040000000000013,427.49,858.01,661.53,1947.03,110.96000000000001,16.079999999999998,85.230000000000018,212.27000000000004,215.93000000000004,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,907.82,null,907.82,68.5,566.54999999999995,427.2,1062.25,98.503500000000017,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,341.35150000000004]
[195,"Client W","Sherbrooke",null,null,null,0,null,null,null,0,0,null,null,null,0,15.68,44,19.97,79.650000000000006,3.9825000000000004,null,null,null,0,null,18.48,null,18.48,1.8480000000000001,-1979.43,171.42,283.79000000000002,-1524.22,471.12,126.94999999999999,81.477999999999994,679.54799999999989,-84.46720000000002,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,23,null,23,null,null,13.8,13.8,1.8399999999999999,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,-76.796700000000016]
[3138,"Client X","Pierrefonds",null,null,null,0,null,null,null,0,0,null,660,null,660,null,20.7,17.05,37.75,34.887500000000003,null,null,null,0,null,6.16,12.32,18.48,1.8480000000000001,null,null,null,0,null,291.08,42.099999999999994,333.17999999999995,33.317999999999998,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,562.04999999999995,null,562.04999999999995,null,562.04999999999995,null,562.04999999999995,56.204999999999998,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,126.2585]
[3567,"Client Y","Gatineau",null,null,null,0,null,null,null,0,0,null,null,null,0,194.13,null,140.47,334.6,16.73,null,null,null,0,22.35,null,19.5,41.85,4.1850000000000005,null,null,null,0,21.22,59.839999999999996,17.25,98.31,9.8310000000000013,null,null,null,0,null,null,null,0,0,{"$f":"50+282","v":332},{"$f":"78+52","v":130},null,462,null,null,null,0,46.2,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,76.945999999999998]
[3580,"Client Z","Gatineau",null,null,null,0,null,null,null,0,0,null,null,null,0,9.1,149.94999999999999,17.05,176.1,8.8049999999999997,null,null,null,0,null,null,3.56,3.56,0.35600000000000004,null,73.48,null,73.48,158.18,6.31,168.07999999999998,332.57,40.605000000000004,null,null,null,0,null,null,null,0,0,null,null,78,78,null,null,null,0,7.8000000000000007,null,56,null,56,null,75.5,null,75.5,6.5750000000000002,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,64.141000000000005]
[3211,"Client AA","Laurier-Station",null,null,null,0,null,null,null,0,0,null,null,null,0,56.11,134.22,84.86,275.19,13.759500000000001,null,null,null,0,null,19.440000000000001,6.16,25.6,2.5600000000000005,768.47,null,null,768.47,129.94999999999999,232.84,335.334,698.12400000000002,146.65940000000001,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,38,76,114,5.7,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,168.6789]
[3392,"Client AB","Sept-Iles",null,null,null,0,null,null,null,0,0,null,555,null,555,78.900000000000006,145.54,36.6,261.04000000000002,40.802,null,null,null,0,12.32,12.32,null,24.64,2.4640000000000004,743.2,null,865.53,1608.73,902.63,215.72,134.46,1252.81,286.154,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,18.399999999999999,127.8,6.9,153.1,7.6550000000000002,null,null,null,0,null,null,null,0,0,948.5,1127.52,628.65,2704.67,67.61675000000001,null,64.75,null,64.75,3.2375000000000003,407.92925000000002]
[3496,"Client AC","Boucherville",null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,30,30,1.5,null,null,null,0,null,null,4,4,0.4,null,null,null,0,null,null,3,3,0.30000000000000004,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,2.2000000000000002]
[3329,"Client AD","St-Bruno",null,null,null,0,null,null,null,0,0,null,null,null,0,504.44,102.41,113.63,720.48,36.024000000000001,null,null,null,0,21.36,null,7.12,28.48,2.8480000000000003,null,null,null,0,175.24999999999997,306.01200000000006,148.63,629.89200000000005,62.989200000000011,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,-6.5,null,-6.5,163.6,316,51.8,531.4,26.245000000000001,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,128.1062]
[3335,"Client AE","Courcelette",null,null,null,0,null,null,null,0,0,null,null,null,0,45.5,null,64.75,110.25,5.5125000000000002,null,null,null,0,7.12,12.32,null,19.440000000000001,1.9440000000000002,798.12,-256.07,null,542.04999999999995,226.77,105.37,78.59,410.73,95.278000000000006,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,378.8,null,null,378.8,18.940000000000001,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,121.67450000000001]
[3530,"Client AF","Sherbrooke",null,null,null,0,null,null,null,0,0,null,395,null,395,322.25,246.55,161.47,730.27,56.263500000000001,null,null,null,0,3.56,null,6.16,9.7200000000000006,0.97200000000000009,207.88,194.83,null,402.71000000000004,null,34.655999999999999,37.120000000000005,71.77600000000001,47.448600000000006,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,267,null,267,13.8,67.900000000000006,null,81.7,17.434999999999999,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,122.1191]
[3352,"Client AG","Montréal",876.92,593.29,1541.95,3012.16,null,null,null,0,150.608,null,304,null,304,56.06,332.4,30.5,418.96,36.148000000000003,17.96,null,null,17.96,39.840000000000003,126.84,90.38,257.06,27.501999999999999,1589.06,-792.77,674.95,1471.24,110.57999999999998,196.39,78.42,385.39,185.66300000000001,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,56.25,null,56.25,13.8,103,20.7,137.5,9.6875,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,409.60850000000005]
[4062,"Client AH","Eastman",null,null,null,0,null,null,null,0,0,null,573,null,573,13.26,253,76,342.26,45.763000000000005,null,null,null,0,null,null,6.16,6.16,0.6160000000000001,1683.2,-1685.7,85.89,83.39,4.29,55.14,42.79,102.22,18.561000000000003,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,76,38,114,5.7,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,70.640000000000015]
[3148,"Client AI","Cap-aux-Meules",null,null,null,0,null,null,null,0,0,-89,2345,-510,1746,139.94999999999999,29.35,245.33,414.63,108.03150000000001,null,null,null,0,18.48,null,null,18.48,1.8480000000000001,867.19,-1328.89,570.45000000000005,108.75,18.57,71.819999999999993,33.69,124.07999999999998,23.283000000000001,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,152,152,7.6000000000000005,null,null,null,0,null,null,null,0,0,1250.0999999999999,751.81,755,2756.91,68.922749999999994,null,null,null,0,0,209.68525]
[3528,"Client AJ","Ferme-Neuve",24.62,null,null,24.62,null,37.18,null,37.18,3.09,16,null,null,16,null,93.5,111.5,205,11.05,null,null,null,0,null,18.48,null,18.48,1.8480000000000001,null,1360.91,null,1360.91,183.42200000000003,44.29,16.13,243.84200000000001,160.47520000000003,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,36.799999999999997,null,36.799999999999997,1.8399999999999999,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,178.30320000000003]
[3287,"Client AK","St-Zacharie",null,null,null,0,null,null,null,0,0,null,null,null,0,22.95,217.48,16,256.42999999999995,12.821499999999999,null,null,null,0,null,null,23,23,2.3000000000000003,null,null,null,0,56.030000000000008,57.08,46.77,159.88000000000002,15.988000000000003,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,31.109500000000004]
[3377,"Client AL","Lévis",null,null,null,0,null,null,null,0,0,null,null,null,0,22.27,18.82,79.12,120.21000000000001,6.0105000000000004,null,null,null,0,3.56,null,null,3.56,0.35600000000000004,-50.19,null,null,-50.19,27.82,28.21,41.513999999999996,97.543999999999997,4.7354000000000003,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,11.101900000000001]
[3381,"Client AM","Ste-Luce",null,null,null,0,null,null,null,0,0,null,null,null,0,5.12,89.35,37.58,132.05000000000001,6.6025000000000009,28.42,null,216.29,244.70999999999998,null,null,6.16,6.16,25.087,null,null,null,0,106.11,17.009999999999998,129.85,252.97,25.297000000000001,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,56.986500000000007]
[3576,"Client AN","Québec",null,null,null,0,null,null,null,0,0,null,null,null,0,18.2,40.6,169.05,227.85000000000002,11.392500000000002,null,null,null,0,null,null,null,0,0,null,null,null,0,8.69,89.673000000000002,3.87,102.233,10.223300000000002,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,10,null,10,null,38,null,38,2.4000000000000004,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,24.015800000000006]
[3548,"Client AO","Trois-Rivières",null,null,null,0,null,null,null,0,0,null,null,null,0,51.62,84.3,78.5,214.42,10.721,null,null,null,0,null,3.56,null,3.56,0.35600000000000004,null,-548.41,null,-548.41,37.750000000000007,51.36,22.049999999999997,111.16000000000001,-43.724999999999994,null,null,null,0,null,null,null,0,0,{"$f":"100+770+147","v":1017},124,null,1141,null,null,null,0,114.10000000000001,null,null,null,0,null,38,null,38,1.9000000000000001,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,83.352000000000004]
["TOTAL CRÉDITS À FACTURER AUX FOURNISSEURS",null,null,null,null,null,{"$f":"SUM(G6:G46)","v":4126.3099999999995},null,null,null,{"$f":"SUM(K6:K46)","v":73.62},{"$f":"SUM(L6:L46)","v":209.9965},null,null,null,{"$f":"SUM(P6:P46)","v":8724},null,null,null,15041.859999999999,1188.2929999999999,null,null,null,{"$f":"SUM(Y6:Y46)","v":1214.3699999999999},null,null,null,{"$f":"SUM(AC6:AC46)","v":1010.3199999999999},{"$f":"SUM(AD6:AD46)","v":222.46900000000008},null,null,null,{"$f":"SUM(AH6:AH46)","v":18159.54},null,null,null,13154.679999999997,3131.4219999999996,null,null,null,{"$f":"SUM(AQ6:AQ46)","v":0},null,null,null,{"$f":"SUM(AU6:AU46)","v":0},{"$f":"SUM(AV6:AV46)","v":0},null,null,null,{"$f":"SUM(AZ6:AZ46)","v":11293},null,null,null,{"$f":"SUM(BD6:BD46)","v":0},{"$f":"SUM(BE6:BE46)","v":1129.3},null,null,null,{"$f":"SUM(BI6:BI46)","v":9148.4499999999989},null,null,null,{"$f":"SUM(BM6:BM46)","v":8246.86},{"$f":"SUM(BN6:BN46)","v":869.7655000000002},null,null,null,{"$f":"SUM(BR6:BR46)","v":0},null,null,null,{"$f":"SUM(BV6:BV46)","v":0},{"$f":"SUM(BW6:BW46)","v":0},null,null,null,{"$f":"SUM(CA6:CA46)","v":10186.83},{"$f":"SUM(CB6:CB46)","v":254.67075},null,null,null,{"$f":"SUM(CF6:CF46)","v":64.75},{"$f":"SUM(CG6:CG46)","v":3.2375000000000003},null,{"$f":"SUM(CH6:CH47)","v":7009.1542499999996}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CG47+CB47+BE47+BW47+BN47+AV47+AM47+AD47+U47+L47","v":7009.1542499999996}]
[null,"Ventes totales par fournisseur "]
[null,"FOURN. A",{"$f":"G47+K47","v":4199.9299999999994}]
[null,"FOURN. B",{"$f":"P47+T47","v":23765.86}]
[null,"FOURN. C",{"$f":"Y47+AC47","v":2224.6899999999996}]
[null,"FOURN. D",{"$f":"AH47+AL47","v":31314.219999999998}]
[null,"FOURN. E",{"$f":"AQ47+AU47","v":0}]
[null,"FOURN. F",{"$f":"AZ47+BD47","v":11293}]
[null,"FOURN. G",{"$f":"BI47+BM47","v":17395.309999999998}]
[null,"FOURN. H",{"$f":"BR47+BV47","v":0}]
[null,"FOURN. I  A+B",{"$f":"CA47+CF47","v":10251.58}]

{"sheet":"résultat voulu","index":1,"n_rows":58,"n_cols":87,"rows_kept":58,"cut":false,"hidden":false,"merged":[[0,39,1,47],[2,3,3,6],[2,7,3,10],[2,11,3,11],[2,12,3,15],[0,0,3,2],[0,3,1,11],[0,12,1,20],[0,21,1,29],[0,30,1,38],[0,85,4,85],[2,52,3,55],[2,56,3,56],[2,57,3,60],[2,61,3,64],[0,48,1,56],[0,57,1,65],[0,66,1,74],[0,75,1,79],[0,80,1,84],[2,48,3,51],[2,16,3,19],[2,20,3,20],[2,21,3,24],[2,25,3,28],[2,29,3,29],[2,30,3,33],[2,80,3,83],[2,84,3,84],[4,57,4,59],[46,0,46,2],[48,1,48,2],[2,65,3,65],[2,66,3,69],[2,70,3,73],[2,74,3,74],[2,75,3,78],[2,79,3,79],[2,34,3,37],[2,38,3,38],[2,39,3,42],[2,43,3,46],[2,47,3,47]]}
["CREDITS TRIMESTRIELS\nOCTOBRE - NOVEMBRE - DECEMBRE 2015",null,null,"FOURN. A",null,null,null,null,null,null,null,null,"FOURN. B",null,null,null,null,null,null,null,null,"FOURN. C",null,null,null,null,null,null,null,null,"FOURN. D",null,null,null,null,null,null,null,null,"FOURN. E",null,null,null,null,null,null,null,null,"FOURN. F",null,null,null,null,null,null,null,null,"FOURN. G",null,null,null,null,null,null,null,null,"FOURN. H",null,null,null,null,null,null,null,null,"FOURN. I-A",null,null,null,null,"FOURN. I-B",null,null,null,null,"TOTAL CRÉDITS "]
[]
[null,null,null,"DIRECT",null,null,null,"INDIRECT",null,null,null,"CRÉDIT ","DIRECT",null,null,null,"INDIRECT",null,null,null,"CRÉDIT ","DIRECT",null,null,null,"INDIRECT",null,null,null,"CRÉDIT ","DIRECT",null,null,null,"INDIRECT",null,null,null,"CRÉDIT ","DIRECT",null,null,null,"INDIRECT",null,null,null,"CRÉDIT ","DIRECT",null,null,null,"INDIRECT",null,null,null,"CRÉDIT ","DIRECT",null,null,null,"INDIRECT",null,null,null,"CRÉDIT ","DIRECT",null,null,null,"INDIRECT",null,null,null,"CRÉDIT ","DIRECT",null,null,null,"CRÉDIT","DIRECT",null,null,null,"CRÉDIT"]
[]
["# CLIENT","Nom de la succursale/Store Name","Ville/City","OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL DIR","OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL  MCK",0.05,"OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL DIR","OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL  MCK",0.05,"OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL DIR","OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL  MCK",0.1,"OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL DIR","OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL  MCK",0.1,"OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL DIR","OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL  MCK",0.05,"OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL DIR","OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL  MCK",0.1,"OCT - NOV - DEC",null,null,"TOTAL DIR","OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL  MCK",0.05,"OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL DIR","OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL  MCK",0.1,"OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL  DIR","2,5%",{"$f":"BX5","v":"OCTOBRE"},"NOVEMBRE","DECEMBRE","TOTAL  DIR",0.05]
[3520,"Client A","Waterloo",null,null,null,{"$f":"SUM(D6:F6)","v":0},null,null,null,{"$f":"SUM(H6:J6)","v":0},{"$f":"(G6+K6)*0.05","v":0},null,null,null,{"$f":"SUM(M6:O6)","v":0},25.75,301.27,335.38,{"$f":"SUM(Q6:S6)","v":662.4},{"$f":"(P6+T6)*0.05","v":33.119999999999997},{"$f":"27.52+28.42+12.91","v":68.849999999999994},{"$f":"50.05+28.42+166.32","v":244.79},86.58,{"$f":"SUM(V6:X6)","v":400.21999999999997},12.32,null,null,{"$f":"SUM(Z6:AB6)","v":12.32},{"$f":"(Y6+AC6)*0.1","v":41.253999999999998},156.54,243.65,141.01,{"$f":"SUM(AE6:AG6)","v":541.20000000000005},54.866,62.29,73.010000000000005,{"$f":"SUM(AI6:AK6)","v":190.166},{"$f":"(AH6+AL6)*0.1","v":73.136600000000001},null,null,null,{"$f":"SUM(AN6:AP6)","v":0},null,null,null,{"$f":"SUM(AR6:AT6)","v":0},{"$f":"(AQ6+AU6)*0.05","v":0},null,null,null,{"$f":"SUM(AW6:AY6)","v":0},null,null,null,{"$f":"SUM(BA6:BC6)","v":0},{"$f":"(AZ6+BD6)*0.1","v":0},null,null,null,{"$f":"SUM(BF6:BH6)","v":0},null,null,null,{"$f":"SUM(BJ6:BL6)","v":0},{"$f":"(BI6+BM6)*0.05","v":0},null,null,null,{"$f":"SUM(BO6:BQ6)","v":0},null,null,null,{"$f":"SUM(BS6:BU6)","v":0},{"$f":"(BR6+BV6)*0.1","v":0},null,null,null,{"$f":"SUM(BX6:BZ6)","v":0},{"$f":"CA6*0.025","v":0},null,null,null,{"$f":"SUM(CC6:CE6)","v":0},{"$f":"CF6*0.05","v":0},{"$f":"L6+U6+AD6+AM6+AV6+BN6+BW6+BE6+CB6+CG6","v":147.51060000000001}]
[3510,"Client B","Windsor",null,null,null,0,null,null,null,0,0,null,null,null,0,86.99,864.04,117.09,1068.1199999999999,53.405999999999999,null,null,null,0,null,null,null,0,0,2477.6799999999998,-2048.79,647.45000000000005,1076.3399999999999,38.369999999999997,176.07999999999998,4.8000000000000007,219.25,129.559,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,210,null,210,173.8,51.8,225.5,451.1,33.055,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,216.02]
[3562,"Client C","Gatineau",null,null,null,0,null,null,null,0,0,null,null,null,0,32.6,40.909999999999997,46.08,119.58999999999999,5.9794999999999998,null,null,null,0,3.56,null,30.8,34.36,3.4359999999999999,173.37,null,504.54,677.91000000000008,107.6,34.67,65.5,207.76999999999998,88.568000000000012,null,null,null,0,null,null,null,0,0,{"$f":"-49+157","v":108},null,null,108,null,null,null,0,10.8,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,108.7835]
[3579,"Client D","St-Jean-de-Dieu",null,null,null,0,null,null,null,0,0,null,null,1255,1255,15.9,179.29,70.2,265.39,76.019499999999994,null,null,null,0,3.56,null,null,3.56,0.35600000000000004,null,null,null,0,73.430000000000007,312.75200000000007,129.57000000000002,515.75200000000007,51.575200000000009,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,127.9507]
[3583,"Client E","Québec",null,null,null,0,null,null,null,0,0,null,null,null,0,null,453.31,29.53,482.84000000000003,24.142000000000003,null,null,null,0,null,12.32,null,12.32,1.2320000000000002,null,null,null,0,null,81.13,71.97,153.1,15.31,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,9.1999999999999993,null,9.1999999999999993,0.45999999999999996,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,41.144000000000005]
[3585,"Client F","Montréal",null,null,null,0,null,null,null,0,0,null,null,null,0,1137.28,54.07,57.41,1248.76,62.438000000000002,null,null,null,0,null,7.12,null,7.12,0.71200000000000008,null,1.1399999999999999,null,1.1399999999999999,1341.1099999999997,43.46,26.68,1411.2499999999998,141.239,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,76,null,76,3.8000000000000003,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,208.18900000000002]
[3518,"Client G","Cantley",null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,0]
[3428,"Client H","St-Rémi",null,null,null,0,null,null,null,0,0,null,null,null,0,78.069999999999993,46.92,46.21,171.2,8.56,null,null,null,0,6.16,15.88,null,22.04,2.2040000000000002,null,null,1415.41,1415.41,26.852000000000004,38.43,7.4399999999999995,72.722000000000008,148.81320000000002,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,537.47,null,537.47,null,null,null,0,26.873500000000003,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,186.45070000000004]
[3281,"Client I","Pointe-aux-Trembles",null,null,null,0,null,null,null,0,0,null,null,null,0,-92.14,120.02,47.37,75.25,3.7625000000000002,null,null,null,0,null,null,null,0,0,2014.4,168.6,284.86,2467.86,151.15,51.83,132.11000000000001,335.09000000000003,280.29500000000002,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,315.3,null,null,315.3,15.765000000000001,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,299.82249999999999]
[3523,"Client J","St-Lambert",null,null,null,0,null,null,null,0,0,null,null,null,0,401.85,339.49,141.55000000000001,882.8900000000001,44.144500000000008,null,null,null,0,12.32,25.6,15.290000000000001,53.21,5.3210000000000006,null,null,596.27,596.27,125.15,98.660000000000011,122.79000000000002,346.6,94.287000000000006,null,null,null,0,null,null,null,0,0,193,139,{"$f":"100+361","v":461},793,null,null,null,0,79.300000000000011,null,null,null,0,4.5999999999999996,44.9,105.9,155.4,7.7700000000000005,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,230.82250000000002]
[3555,"Client K","Longueuil",null,null,null,0,null,null,36.44,36.44,1.8220000000000001,null,null,null,0,55.61,75.150000000000006,18.2,148.95999999999998,7.4479999999999995,null,null,null,0,null,null,2.91,2.91,0.29100000000000004,null,null,null,0,51.650000000000006,52.31,null,103.96000000000001,10.396000000000001,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,231,null,231,null,null,null,0,11.55,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,31.507000000000001]
[3345,"Client L","Shawinigan",null,null,null,0,null,null,null,0,0,null,null,null,0,25.42,20.5,16.5,62.42,3.1210000000000004,null,null,null,0,23,null,16.84,39.840000000000003,3.9840000000000004,125.89,-472.82,null,-346.93,4.95,null,14.88,19.830000000000002,-32.71,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,1660,null,1660,849,null,816,1665,166.25,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,140.64500000000001]
[3543,"Client M","Plessisville",null,null,null,0,null,null,null,0,0,null,null,null,0,485.48,391.48,71.08,948.04000000000008,47.402000000000008,null,null,null,0,27.52,null,24.64,52.16,5.2160000000000002,null,null,264.27,264.27,147.68600000000001,140.07,26.69,314.44599999999997,57.871599999999994,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,545,null,{"$f":"SUM(BG18:BH18)","v":545},null,553.5,38,591.5,56.825000000000003,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,167.31459999999998]
[3527,"Client N","St-Jean-sur-Richelieu",null,299.99,224.49,524.48,null,null,null,0,26.224000000000004,null,null,null,0,null,269.91000000000003,100.01,369.92,18.496000000000002,null,null,null,0,null,null,63.64,63.64,6.3640000000000008,null,564.66999999999996,743.64,1308.31,null,249.74199999999999,242.75,492.49199999999996,180.08019999999999,null,null,null,0,null,null,null,0,0,null,{"$f":"2940+153","v":3093},{"$f":"252+2467","v":2719},5812,null,null,null,0,581.20000000000005,null,null,null,{"$f":"SUM(BF19:BH19)","v":0},null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,3213.1,1305.1500000000001,4518.25,112.95625000000001,null,null,null,0,0,925.32044999999994]
[3133,"Client O","Matane",null,null,298.58999999999997,298.58999999999997,null,null,null,0,14.929499999999999,null,991,null,991,170.83,641.17999999999995,27.8,839.81,91.540500000000009,{"$f":"50.05+49.37+88.3","v":187.71999999999997},{"$f":"185.05+55.85","v":240.9},32.5,461.12,null,null,12.32,12.32,47.344000000000001,null,null,null,0,172.52,7.8,25.52,205.84000000000003,20.584000000000003,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,386,null,386,385.5,20,null,405.5,39.575000000000003,null,null,null,0,null,null,null,0,0,null,null,69,69,1.7250000000000001,null,null,null,0,0,215.69800000000001]
[3536,"Client P","Montréal",null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,1649.6,null,1649.6,null,null,null,0,82.48,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,82.48]
[3512,"Client Q","St-Jean-de-Matha",null,42.75,null,42.75,null,null,null,0,2.1375000000000002,1604,25,null,1629,526.38,467.42,19.84,1013.64,132.13200000000001,null,null,null,0,14.98,null,15.88,30.86,3.0860000000000003,425.44,null,863.82,1289.26,336.26,355.9,287.68299999999999,979.84299999999996,226.91030000000001,null,null,null,0,null,null,null,0,0,{"$f":"28+353.5+365.5","v":747},{"$f":"140+1514.5+197","v":1851.5},{"$f":"56+244.5","v":300.5},2899,null,null,null,0,289.90000000000003,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,138,null,null,138,3.45,null,null,null,0,0,657.61580000000004]
[3436,"Client R","St-Hyacinthe",null,105.33,118.38,223.70999999999998,null,null,null,0,11.185499999999999,null,null,null,0,null,13.68,20.37,34.049999999999997,1.7024999999999999,null,null,null,0,null,12.32,6.16,18.48,1.8480000000000001,null,null,456.32,456.32,null,63.25,42.52,105.77000000000001,56.209000000000003,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,1234.46,null,1234.46,null,457.6,881.6,1339.2,128.68299999999999,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,199.62799999999999]
[3521,"Client S","Montmagny",null,null,null,0,null,null,null,0,0,600,null,null,600,253.42,62.29,91.62,407.33,50.366500000000002,null,null,null,0,27.3,10.030000000000001,null,37.33,3.7330000000000001,167.29,569.29999999999995,486.07,1222.6599999999999,182.82000000000002,124.33000000000001,288.10000000000002,595.25,181.791,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,819.3,null,819.3,-268.64,null,null,-268.64,27.533000000000001,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,263.42349999999999]
[3199,"Client T","Jonquière",null,null,null,0,null,null,null,0,0,null,null,null,0,41.75,5.9,6.58,54.23,2.7115,null,null,null,0,null,null,6.16,6.16,0.6160000000000001,null,null,null,0,46.63,37.44,null,84.07,8.407,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,9.1999999999999993,9.1999999999999993,18.399999999999999,0.91999999999999993,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,12.654500000000001]
[3291,"Client U","St-Tite",null,null,null,0,null,null,null,0,0,null,null,null,0,89.5,456.55,125.55,671.59999999999991,33.58,null,null,90.36,90.36,3.56,3.56,8.82,15.940000000000001,10.63,945.58,null,null,945.58,167.54000000000002,301.39999999999998,31.009999999999998,499.95,144.553,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,188.76300000000001]
[3296,"Client V","Joliette",null,null,null,0,null,null,null,0,0,null,null,null,0,112.93,145.19999999999999,170.15,428.28,21.414000000000001,null,null,null,0,14.24,10.68,30.12,55.040000000000006,5.5040000000000013,427.49,858.01,661.53,1947.03,110.96000000000001,16.079999999999998,85.230000000000018,212.27000000000004,215.93000000000004,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,907.82,null,907.82,68.5,566.54999999999995,427.2,1062.25,98.503500000000017,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,341.35150000000004]
[195,"Client W","Sherbrooke",null,null,null,0,null,null,null,0,0,null,null,null,0,15.68,44,19.97,79.650000000000006,3.9825000000000004,null,null,null,0,null,18.48,null,18.48,1.8480000000000001,-1979.43,171.42,283.79000000000002,-1524.22,471.12,126.94999999999999,81.477999999999994,679.54799999999989,-84.46720000000002,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,23,null,23,null,null,13.8,13.8,1.8399999999999999,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,-76.796700000000016]
[3138,"Client X","Pierrefonds",null,null,null,0,null,null,null,0,0,null,660,null,660,null,20.7,17.05,37.75,34.887500000000003,null,null,null,0,null,6.16,12.32,18.48,1.8480000000000001,null,null,null,0,null,291.08,42.099999999999994,333.17999999999995,33.317999999999998,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,562.04999999999995,null,562.04999999999995,null,562.04999999999995,null,562.04999999999995,56.204999999999998,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,126.2585]
[3567,"Client Y","Gatineau",null,null,null,0,null,null,null,0,0,null,null,null,0,194.13,null,140.47,334.6,16.73,null,null,null,0,22.35,null,19.5,41.85,4.1850000000000005,null,null,null,0,21.22,59.839999999999996,17.25,98.31,9.8310000000000013,null,null,null,0,null,null,null,0,0,{"$f":"50+282","v":332},{"$f":"78+52","v":130},null,462,null,null,null,0,46.2,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,76.945999999999998]
[3580,"Client Z","Gatineau",null,null,null,0,null,null,null,0,0,null,null,null,0,9.1,149.94999999999999,17.05,176.1,8.8049999999999997,null,null,null,0,null,null,3.56,3.56,0.35600000000000004,null,73.48,null,73.48,158.18,6.31,168.07999999999998,332.57,40.605000000000004,null,null,null,0,null,null,null,0,0,null,null,78,78,null,null,null,0,7.8000000000000007,null,56,null,56,null,75.5,null,75.5,6.5750000000000002,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,64.141000000000005]
[3211,"Client AA","Laurier-Station",null,null,null,0,null,null,null,0,0,null,null,null,0,56.11,134.22,84.86,275.19,13.759500000000001,null,null,null,0,null,19.440000000000001,6.16,25.6,2.5600000000000005,768.47,null,null,768.47,129.94999999999999,232.84,335.334,698.12400000000002,146.65940000000001,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,38,76,114,5.7,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,168.6789]
[3392,"Client AB","Sept-Iles",null,null,null,0,null,null,null,0,0,null,555,null,555,78.900000000000006,145.54,36.6,261.04000000000002,40.802,null,null,null,0,12.32,12.32,null,24.64,2.4640000000000004,743.2,null,865.53,1608.73,902.63,215.72,134.46,1252.81,286.154,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,18.399999999999999,127.8,6.9,153.1,7.6550000000000002,null,null,null,0,null,null,null,0,0,948.5,1127.52,628.65,2704.67,67.61675000000001,null,64.75,null,64.75,3.2375000000000003,407.92925000000002]
[3496,"Client AC","Boucherville",null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,30,30,1.5,null,null,null,0,null,null,4,4,0.4,null,null,null,0,null,null,3,3,0.30000000000000004,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,2.2000000000000002]
[3329,"Client AD","St-Bruno",null,null,null,0,null,null,null,0,0,null,null,null,0,504.44,102.41,113.63,720.48,36.024000000000001,null,null,null,0,21.36,null,7.12,28.48,2.8480000000000003,null,null,null,0,175.24999999999997,306.01200000000006,148.63,629.89200000000005,62.989200000000011,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,-6.5,null,-6.5,163.6,316,51.8,531.4,26.245000000000001,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,128.1062]
[3335,"Client AE","Courcelette",null,null,null,0,null,null,null,0,0,null,null,null,0,45.5,null,64.75,110.25,5.5125000000000002,null,null,null,0,7.12,12.32,null,19.440000000000001,1.9440000000000002,798.12,-256.07,null,542.04999999999995,226.77,105.37,78.59,410.73,95.278000000000006,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,378.8,null,null,378.8,18.940000000000001,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,121.67450000000001]
[3530,"Client AF","Sherbrooke",null,null,null,0,null,null,null,0,0,null,395,null,395,322.25,246.55,161.47,730.27,56.263500000000001,null,null,null,0,3.56,null,6.16,9.7200000000000006,0.97200000000000009,207.88,194.83,null,402.71000000000004,null,34.655999999999999,37.120000000000005,71.77600000000001,47.448600000000006,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,267,null,267,13.8,67.900000000000006,null,81.7,17.434999999999999,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,122.1191]
[3352,"Client AG","Montréal",876.92,593.29,1541.95,3012.16,null,null,null,0,150.608,null,304,null,304,56.06,332.4,30.5,418.96,36.148000000000003,17.96,null,null,17.96,39.840000000000003,126.84,90.38,257.06,27.501999999999999,1589.06,-792.77,674.95,1471.24,110.57999999999998,196.39,78.42,385.39,185.66300000000001,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,56.25,null,56.25,13.8,103,20.7,137.5,9.6875,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,409.60850000000005]
[4062,"Client AH","Eastman",null,null,null,0,null,null,null,0,0,null,573,null,573,13.26,253,76,342.26,45.763000000000005,null,null,null,0,null,null,6.16,6.16,0.6160000000000001,1683.2,-1685.7,85.89,83.39,4.29,55.14,42.79,102.22,18.561000000000003,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,76,38,114,5.7,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,70.640000000000015]
[3148,"Client AI","Cap-aux-Meules",null,null,null,0,null,null,null,0,0,-89,2345,-510,1746,139.94999999999999,29.35,245.33,414.63,108.03150000000001,null,null,null,0,18.48,null,null,18.48,1.8480000000000001,867.19,-1328.89,570.45000000000005,108.75,18.57,71.819999999999993,33.69,124.07999999999998,23.283000000000001,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,152,152,7.6000000000000005,null,null,null,0,null,null,null,0,0,1250.0999999999999,751.81,755,2756.91,68.922749999999994,null,null,null,0,0,209.68525]
[3528,"Client AJ","Ferme-Neuve",24.62,null,null,24.62,null,37.18,null,37.18,3.09,16,null,null,16,null,93.5,111.5,205,11.05,null,null,null,0,null,18.48,null,18.48,1.8480000000000001,null,1360.91,null,1360.91,183.42200000000003,44.29,16.13,243.84200000000001,160.47520000000003,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,36.799999999999997,null,36.799999999999997,1.8399999999999999,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,178.30320000000003]
[3287,"Client AK","St-Zacharie",null,null,null,0,null,null,null,0,0,null,null,null,0,22.95,217.48,16,256.42999999999995,12.821499999999999,null,null,null,0,null,null,23,23,2.3000000000000003,null,null,null,0,56.030000000000008,57.08,46.77,159.88000000000002,15.988000000000003,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,31.109500000000004]
[3377,"Client AL","Lévis",null,null,null,0,null,null,null,0,0,null,null,null,0,22.27,18.82,79.12,120.21000000000001,6.0105000000000004,null,null,null,0,3.56,null,null,3.56,0.35600000000000004,-50.19,null,null,-50.19,27.82,28.21,41.513999999999996,97.543999999999997,4.7354000000000003,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,11.101900000000001]
[3381,"Client AM","Ste-Luce",null,null,null,0,null,null,null,0,0,null,null,null,0,5.12,89.35,37.58,132.05000000000001,6.6025000000000009,28.42,null,216.29,244.70999999999998,null,null,6.16,6.16,25.087,null,null,null,0,106.11,17.009999999999998,129.85,252.97,25.297000000000001,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,56.986500000000007]
[3576,"Client AN","Québec",null,null,null,0,null,null,null,0,0,null,null,null,0,18.2,40.6,169.05,227.85000000000002,11.392500000000002,null,null,null,0,null,null,null,0,0,null,null,null,0,8.69,89.673000000000002,3.87,102.233,10.223300000000002,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,10,null,10,null,38,null,38,2.4000000000000004,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,24.015800000000006]
[3548,"Client AO","Trois-Rivières",null,null,null,0,null,null,null,0,0,null,null,null,0,51.62,84.3,78.5,214.42,10.721,null,null,null,0,null,3.56,null,3.56,0.35600000000000004,null,-548.41,null,-548.41,37.750000000000007,51.36,22.049999999999997,111.16000000000001,-43.724999999999994,null,null,null,0,null,null,null,0,0,{"$f":"100+770+147","v":1017},124,null,1141,null,null,null,0,114.10000000000001,null,null,null,0,null,38,null,38,1.9000000000000001,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,83.352000000000004]
["TOTAL CRÉDITS À FACTURER AUX FOURNISSEURS",null,null,null,null,null,{"$f":"SUM(G6:G46)","v":4126.3099999999995},null,null,null,{"$f":"SUM(K6:K46)","v":73.62},{"$f":"SUM(L6:L46)","v":209.9965},null,null,null,{"$f":"SUM(P6:P46)","v":8724},null,null,null,15041.859999999999,1188.2929999999999,null,null,null,{"$f":"SUM(Y6:Y46)","v":1214.3699999999999},null,null,null,{"$f":"SUM(AC6:AC46)","v":1010.3199999999999},{"$f":"SUM(AD6:AD46)","v":222.46900000000008},null,null,null,{"$f":"SUM(AH6:AH46)","v":18159.54},null,null,null,13154.679999999997,3131.4219999999996,null,null,null,{"$f":"SUM(AQ6:AQ46)","v":0},null,null,null,{"$f":"SUM(AU6:AU46)","v":0},{"$f":"SUM(AV6:AV46)","v":0},null,null,null,{"$f":"SUM(AZ6:AZ46)","v":11293},null,null,null,{"$f":"SUM(BD6:BD46)","v":0},{"$f":"SUM(BE6:BE46)","v":1129.3},null,null,null,{"$f":"SUM(BI6:BI46)","v":9148.4499999999989},null,null,null,{"$f":"SUM(BM6:BM46)","v":8246.86},{"$f":"SUM(BN6:BN46)","v":869.7655000000002},null,null,null,{"$f":"SUM(BR6:BR46)","v":0},null,null,null,{"$f":"SUM(BV6:BV46)","v":0},{"$f":"SUM(BW6:BW46)","v":0},null,null,null,{"$f":"SUM(CA6:CA46)","v":10186.83},{"$f":"SUM(CB6:CB46)","v":254.67075},null,null,null,{"$f":"SUM(CF6:CF46)","v":64.75},{"$f":"SUM(CG6:CG46)","v":3.2375000000000003},null,{"$f":"SUM(CH6:CH47)","v":7009.1542499999996}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CG47+CB47+BE47+BW47+BN47+AV47+AM47+AD47+U47+L47","v":7009.1542499999996}]
[null,"Ventes totales par fournisseur "]
[null,"FOURN. A",{"$f":"G47+K47","v":4199.9299999999994}]
[null,"FOURN. B",{"$f":"P47+T47","v":23765.86}]
[null,"FOURN. C",{"$f":"Y47+AC47","v":2224.6899999999996}]
[null,"FOURN. D",{"$f":"AH47+AL47","v":31314.219999999998}]
[null,"FOURN. E",{"$f":"AQ47+AU47","v":0}]
[null,"FOURN. F",{"$f":"AZ47+BD47","v":11293}]
[null,"FOURN. G",{"$f":"BI47+BM47","v":17395.309999999998}]
[null,"FOURN. H",{"$f":"BR47+BV47","v":0}]
[null,"FOURN. I",{"$f":"CA47+CF47","v":10251.58}]

{"sheet":"après avoir exécuté macro","index":2,"n_rows":58,"n_cols":87,"rows_kept":58,"cut":false,"hidden":false,"merged":[[0,39,1,47],[2,3,3,6],[2,7,3,10],[2,11,3,11],[2,12,3,15],[0,0,3,2],[0,3,1,11],[0,12,1,20],[0,21,1,29],[0,30,1,38],[0,85,4,85],[2,52,3,55],[2,56,3,56],[2,57,3,60],[2,61,3,64],[0,48,1,56],[0,57,1,65],[0,66,1,74],[0,75,1,79],[0,80,1,84],[2,48,3,51],[2,16,3,19],[2,20,3,20],[2,21,3,24],[2,25,3,28],[2,29,3,29],[2,30,3,33],[2,80,3,83],[2,84,3,84],[4,57,4,59],[46,0,46,2],[48,1,48,2],[2,65,3,65],[2,66,3,69],[2,70,3,73],[2,74,3,74],[2,75,3,78],[2,79,3,79],[2,34,3,37],[2,38,3,38],[2,39,3,42],[2,43,3,46],[2,47,3,47]]}
["CREDITS TRIMESTRIELS\nOCTOBRE - NOVEMBRE - DECEMBRE 2015",null,null,"FOURN. A",null,null,null,null,null,null,null,null,"FOURN. B",null,null,null,null,null,null,null,null,"FOURN. C",null,null,null,null,null,null,null,null,"FOURN. D",null,null,null,null,null,null,null,null,"FOURN. E",null,null,null,null,null,null,null,null,"FOURN. F",null,null,null,null,null,null,null,null,"FOURN. G",null,null,null,null,null,null,null,null,"FOURN. H",null,null,null,null,null,null,null,null,"FOURN. I-A",null,null,null,null,"FOURN. I-B",null,null,null,null,"TOTAL CRÉDITS "]
[]
[null,null,null,"DIRECT",null,null,null,"INDIRECT",null,null,null,"CRÉDIT ","DIRECT",null,null,null,"INDIRECT",null,null,null,"CRÉDIT ","DIRECT",null,null,null,"INDIRECT",null,null,null,"CRÉDIT ","DIRECT",null,null,null,"INDIRECT",null,null,null,"CRÉDIT ","DIRECT",null,null,null,"INDIRECT",null,null,null,"CRÉDIT ","DIRECT",null,null,null,"INDIRECT",null,null,null,"CRÉDIT ","DIRECT",null,null,null,"INDIRECT",null,null,null,"CRÉDIT ","DIRECT",null,null,null,"INDIRECT",null,null,null,"CRÉDIT ","DIRECT",null,null,null,"CRÉDIT","DIRECT",null,null,null,"CRÉDIT"]
[]
["# CLIENT","Nom de la succursale/Store Name","Ville/City","OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL DIR","OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL  MCK",0.05,"OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL DIR","OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL  MCK",0.05,"OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL DIR","OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL  MCK",0.1,"OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL DIR","OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL  MCK",0.1,"OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL DIR","OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL  MCK",0.05,"OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL DIR","OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL  MCK",0.1,"OCT - NOV - DEC",null,null,"TOTAL DIR","OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL  MCK",0.05,"OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL DIR","OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL  MCK",0.1,"OCTOBRE","NOVEMBRE","DECEMBRE","TOTAL  DIR","2,5%",{"$f":"BX5","v":"OCTOBRE"},"NOVEMBRE","DECEMBRE","TOTAL  DIR",0.05]
[3520,"Client A","Waterloo",null,null,null,{"$f":"SUM(D6:F6)","v":0},null,null,null,{"$f":"SUM(H6:J6)","v":0},{"$f":"(G6+K6)*0.05","v":0},null,null,null,{"$f":"SUM(M6:O6)","v":0},25.75,301.27,335.38,{"$f":"SUM(Q6:S6)","v":662.4},{"$f":"(P6+T6)*0.05","v":33.119999999999997},{"$f":"27.52+28.42+12.91","v":68.849999999999994},{"$f":"50.05+28.42+166.32","v":244.79},86.58,{"$f":"SUM(V6:X6)","v":400.21999999999997},12.32,null,null,{"$f":"SUM(Z6:AB6)","v":12.32},{"$f":"(Y6+AC6)*0.1","v":41.253999999999998},156.54,243.65,141.01,{"$f":"SUM(AE6:AG6)","v":541.20000000000005},54.866,62.29,73.010000000000005,{"$f":"SUM(AI6:AK6)","v":190.166},{"$f":"(AH6+AL6)*0.1","v":73.136600000000001},null,null,null,{"$f":"SUM(AN6:AP6)","v":0},null,null,null,{"$f":"SUM(AR6:AT6)","v":0},{"$f":"(AQ6+AU6)*0.05","v":0},null,null,null,{"$f":"SUM(AW6:AY6)","v":0},null,null,null,{"$f":"SUM(BA6:BC6)","v":0},{"$f":"(AZ6+BD6)*0.1","v":0},null,null,null,{"$f":"SUM(BF6:BH6)","v":0},null,null,null,{"$f":"SUM(BJ6:BL6)","v":0},{"$f":"(BI6+BM6)*0.05","v":0},null,null,null,{"$f":"SUM(BO6:BQ6)","v":0},null,null,null,{"$f":"SUM(BS6:BU6)","v":0},{"$f":"(BR6+BV6)*0.1","v":0},null,null,null,{"$f":"SUM(BX6:BZ6)","v":0},{"$f":"CA6*0.025","v":0},null,null,null,{"$f":"SUM(CC6:CE6)","v":0},{"$f":"CF6*0.05","v":0},{"$f":"L6+U6+AD6+AM6+AV6+BN6+BW6+BE6+CB6+CG6","v":147.51060000000001}]
[3510,"Client B","Windsor",null,null,null,0,null,null,null,0,0,null,null,null,0,86.99,864.04,117.09,1068.1199999999999,53.405999999999999,null,null,null,0,null,null,null,0,0,2477.6799999999998,-2048.79,647.45000000000005,1076.3399999999999,38.369999999999997,176.07999999999998,4.8000000000000007,219.25,129.559,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,210,null,210,173.8,51.8,225.5,451.1,33.055,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,216.02]
[3562,"Client C","Gatineau",null,null,null,0,null,null,null,0,0,null,null,null,0,32.6,40.909999999999997,46.08,119.58999999999999,5.9794999999999998,null,null,null,0,3.56,null,30.8,34.36,3.4359999999999999,173.37,null,504.54,677.91000000000008,107.6,34.67,65.5,207.76999999999998,88.568000000000012,null,null,null,0,null,null,null,0,0,{"$f":"-49+157","v":108},null,null,108,null,null,null,0,10.8,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,108.7835]
[3579,"Client D","St-Jean-de-Dieu",null,null,null,0,null,null,null,0,0,null,null,1255,1255,15.9,179.29,70.2,265.39,76.019499999999994,null,null,null,0,3.56,null,null,3.56,0.35600000000000004,null,null,null,0,73.430000000000007,312.75200000000007,129.57000000000002,515.75200000000007,51.575200000000009,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,127.9507]
[3583,"Client E","Québec",null,null,null,0,null,null,null,0,0,null,null,null,0,null,453.31,29.53,482.84000000000003,24.142000000000003,null,null,null,0,null,12.32,null,12.32,1.2320000000000002,null,null,null,0,null,81.13,71.97,153.1,15.31,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,9.1999999999999993,null,9.1999999999999993,0.45999999999999996,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,41.144000000000005]
[3585,"Client F","Montréal",null,null,null,0,null,null,null,0,0,null,null,null,0,1137.28,54.07,57.41,1248.76,62.438000000000002,null,null,null,0,null,7.12,null,7.12,0.71200000000000008,null,1.1399999999999999,null,1.1399999999999999,1341.1099999999997,43.46,26.68,1411.2499999999998,141.239,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,76,null,76,3.8000000000000003,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,208.18900000000002]
[3518,"Client G","Cantley",null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,0]
[3428,"Client H","St-Rémi",null,null,null,0,null,null,null,0,0,null,null,null,0,78.069999999999993,46.92,46.21,171.2,8.56,null,null,null,0,6.16,15.88,null,22.04,2.2040000000000002,null,null,1415.41,1415.41,26.852000000000004,38.43,7.4399999999999995,72.722000000000008,148.81320000000002,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,537.47,null,537.47,null,null,null,0,26.873500000000003,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,186.45070000000004]
[3281,"Client I","Pointe-aux-Trembles",null,null,null,0,null,null,null,0,0,null,null,null,0,-92.14,120.02,47.37,75.25,3.7625000000000002,null,null,null,0,null,null,null,0,0,2014.4,168.6,284.86,2467.86,151.15,51.83,132.11000000000001,335.09000000000003,280.29500000000002,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,315.3,null,null,315.3,15.765000000000001,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,299.82249999999999]
[3523,"Client J","St-Lambert",null,null,null,0,null,null,null,0,0,null,null,null,0,401.85,339.49,141.55000000000001,882.8900000000001,44.144500000000008,null,null,null,0,12.32,25.6,15.290000000000001,53.21,5.3210000000000006,null,null,596.27,596.27,125.15,98.660000000000011,122.79000000000002,346.6,94.287000000000006,null,null,null,0,null,null,null,0,0,193,139,{"$f":"100+361","v":461},793,null,null,null,0,79.300000000000011,null,null,null,0,4.5999999999999996,44.9,105.9,155.4,7.7700000000000005,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,230.82250000000002]
[3555,"Client K","Longueuil",null,null,null,0,null,null,36.44,36.44,1.8220000000000001,null,null,null,0,55.61,75.150000000000006,18.2,148.95999999999998,7.4479999999999995,null,null,null,0,null,null,2.91,2.91,0.29100000000000004,null,null,null,0,51.650000000000006,52.31,null,103.96000000000001,10.396000000000001,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,231,null,231,null,null,null,0,11.55,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,31.507000000000001]
[3345,"Client L","Shawinigan",null,null,null,0,null,null,null,0,0,null,null,null,0,25.42,20.5,16.5,62.42,3.1210000000000004,null,null,null,0,23,null,16.84,39.840000000000003,3.9840000000000004,125.89,-472.82,null,-346.93,4.95,null,14.88,19.830000000000002,-32.71,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,1660,null,1660,849,null,816,1665,166.25,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,140.64500000000001]
[3543,"Client M","Plessisville",null,null,null,0,null,null,null,0,0,null,null,null,0,485.48,391.48,71.08,948.04000000000008,47.402000000000008,null,null,null,0,27.52,null,24.64,52.16,5.2160000000000002,null,null,264.27,264.27,147.68600000000001,140.07,26.69,314.44599999999997,57.871599999999994,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,545,null,{"$f":"SUM(BG18:BH18)","v":545},null,553.5,38,591.5,56.825000000000003,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,167.31459999999998]
[3527,"Client N","St-Jean-sur-Richelieu",null,299.99,224.49,524.48,null,null,null,0,26.224000000000004,null,null,null,0,null,269.91000000000003,100.01,369.92,18.496000000000002,null,null,null,0,null,null,63.64,63.64,6.3640000000000008,null,564.66999999999996,743.64,1308.31,null,249.74199999999999,242.75,492.49199999999996,180.08019999999999,null,null,null,0,null,null,null,0,0,null,{"$f":"2940+153","v":3093},{"$f":"252+2467","v":2719},5812,null,null,null,0,581.20000000000005,null,null,null,{"$f":"SUM(BF19:BH19)","v":0},null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,3213.1,1305.1500000000001,4518.25,112.95625000000001,null,null,null,0,0,925.32044999999994]
[3133,"Client O","Matane",null,null,298.58999999999997,298.58999999999997,null,null,null,0,14.929499999999999,null,991,null,991,170.83,641.17999999999995,27.8,839.81,91.540500000000009,{"$f":"50.05+49.37+88.3","v":187.71999999999997},{"$f":"185.05+55.85","v":240.9},32.5,461.12,null,null,12.32,12.32,47.344000000000001,null,null,null,0,172.52,7.8,25.52,205.84000000000003,20.584000000000003,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,386,null,386,385.5,20,null,405.5,39.575000000000003,null,null,null,0,null,null,null,0,0,null,null,69,69,1.7250000000000001,null,null,null,0,0,215.69800000000001]
[3536,"Client P","Montréal",null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,1649.6,null,1649.6,null,null,null,0,82.48,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,82.48]
[3512,"Client Q","St-Jean-de-Matha",null,42.75,null,42.75,null,null,null,0,2.1375000000000002,1604,25,null,1629,526.38,467.42,19.84,1013.64,132.13200000000001,null,null,null,0,14.98,null,15.88,30.86,3.0860000000000003,425.44,null,863.82,1289.26,336.26,355.9,287.68299999999999,979.84299999999996,226.91030000000001,null,null,null,0,null,null,null,0,0,{"$f":"28+353.5+365.5","v":747},{"$f":"140+1514.5+197","v":1851.5},{"$f":"56+244.5","v":300.5},2899,null,null,null,0,289.90000000000003,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,138,null,null,138,3.45,null,null,null,0,0,657.61580000000004]
[3436,"Client R","St-Hyacinthe",null,105.33,118.38,223.70999999999998,null,null,null,0,11.185499999999999,null,null,null,0,null,13.68,20.37,34.049999999999997,1.7024999999999999,null,null,null,0,null,12.32,6.16,18.48,1.8480000000000001,null,null,456.32,456.32,null,63.25,42.52,105.77000000000001,56.209000000000003,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,1234.46,null,1234.46,null,457.6,881.6,1339.2,128.68299999999999,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,199.62799999999999]
[3521,"Client S","Montmagny",null,null,null,0,null,null,null,0,0,600,null,null,600,253.42,62.29,91.62,407.33,50.366500000000002,null,null,null,0,27.3,10.030000000000001,null,37.33,3.7330000000000001,167.29,569.29999999999995,486.07,1222.6599999999999,182.82000000000002,124.33000000000001,288.10000000000002,595.25,181.791,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,819.3,null,819.3,-268.64,null,null,-268.64,27.533000000000001,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,263.42349999999999]
[3199,"Client T","Jonquière",null,null,null,0,null,null,null,0,0,null,null,null,0,41.75,5.9,6.58,54.23,2.7115,null,null,null,0,null,null,6.16,6.16,0.6160000000000001,null,null,null,0,46.63,37.44,null,84.07,8.407,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,9.1999999999999993,9.1999999999999993,18.399999999999999,0.91999999999999993,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,12.654500000000001]
[3291,"Client U","St-Tite",null,null,null,0,null,null,null,0,0,null,null,null,0,89.5,456.55,125.55,671.59999999999991,33.58,null,null,90.36,90.36,3.56,3.56,8.82,15.940000000000001,10.63,945.58,null,null,945.58,167.54000000000002,301.39999999999998,31.009999999999998,499.95,144.553,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,188.76300000000001]
[3296,"Client V","Joliette",null,null,null,0,null,null,null,0,0,null,null,null,0,112.93,145.19999999999999,170.15,428.28,21.414000000000001,null,null,null,0,14.24,10.68,30.12,55.040000000000006,5.5040000000000013,427.49,858.01,661.53,1947.03,110.96000000000001,16.079999999999998,85.230000000000018,212.27000000000004,215.93000000000004,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,907.82,null,907.82,68.5,566.54999999999995,427.2,1062.25,98.503500000000017,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,341.35150000000004]
[195,"Client W","Sherbrooke",null,null,null,0,null,null,null,0,0,null,null,null,0,15.68,44,19.97,79.650000000000006,3.9825000000000004,null,null,null,0,null,18.48,null,18.48,1.8480000000000001,-1979.43,171.42,283.79000000000002,-1524.22,471.12,126.94999999999999,81.477999999999994,679.54799999999989,-84.46720000000002,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,23,null,23,null,null,13.8,13.8,1.8399999999999999,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,-76.796700000000016]
[3138,"Client X","Pierrefonds",null,null,null,0,null,null,null,0,0,null,660,null,660,null,20.7,17.05,37.75,34.887500000000003,null,null,null,0,null,6.16,12.32,18.48,1.8480000000000001,null,null,null,0,null,291.08,42.099999999999994,333.17999999999995,33.317999999999998,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,562.04999999999995,null,562.04999999999995,null,562.04999999999995,null,562.04999999999995,56.204999999999998,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,126.2585]
[3567,"Client Y","Gatineau",null,null,null,0,null,null,null,0,0,null,null,null,0,194.13,null,140.47,334.6,16.73,null,null,null,0,22.35,null,19.5,41.85,4.1850000000000005,null,null,null,0,21.22,59.839999999999996,17.25,98.31,9.8310000000000013,null,null,null,0,null,null,null,0,0,{"$f":"50+282","v":332},{"$f":"78+52","v":130},null,462,null,null,null,0,46.2,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,76.945999999999998]
[3580,"Client Z","Gatineau",null,null,null,0,null,null,null,0,0,null,null,null,0,9.1,149.94999999999999,17.05,176.1,8.8049999999999997,null,null,null,0,null,null,3.56,3.56,0.35600000000000004,null,73.48,null,73.48,158.18,6.31,168.07999999999998,332.57,40.605000000000004,null,null,null,0,null,null,null,0,0,null,null,78,78,null,null,null,0,7.8000000000000007,null,56,null,56,null,75.5,null,75.5,6.5750000000000002,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,64.141000000000005]
[3211,"Client AA","Laurier-Station",null,null,null,0,null,null,null,0,0,null,null,null,0,56.11,134.22,84.86,275.19,13.759500000000001,null,null,null,0,null,19.440000000000001,6.16,25.6,2.5600000000000005,768.47,null,null,768.47,129.94999999999999,232.84,335.334,698.12400000000002,146.65940000000001,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,38,76,114,5.7,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,168.6789]
[3392,"Client AB","Sept-Iles",null,null,null,0,null,null,null,0,0,null,555,null,555,78.900000000000006,145.54,36.6,261.04000000000002,40.802,null,null,null,0,12.32,12.32,null,24.64,2.4640000000000004,743.2,null,865.53,1608.73,902.63,215.72,134.46,1252.81,286.154,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,18.399999999999999,127.8,6.9,153.1,7.6550000000000002,null,null,null,0,null,null,null,0,0,948.5,1127.52,628.65,2704.67,67.61675000000001,null,64.75,null,64.75,3.2375000000000003,407.92925000000002]
[3496,"Client AC","Boucherville",null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,30,30,1.5,null,null,null,0,null,null,4,4,0.4,null,null,null,0,null,null,3,3,0.30000000000000004,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,2.2000000000000002]
[3329,"Client AD","St-Bruno",null,null,null,0,null,null,null,0,0,null,null,null,0,504.44,102.41,113.63,720.48,36.024000000000001,null,null,null,0,21.36,null,7.12,28.48,2.8480000000000003,null,null,null,0,175.24999999999997,306.01200000000006,148.63,629.89200000000005,62.989200000000011,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,-6.5,null,-6.5,163.6,316,51.8,531.4,26.245000000000001,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,128.1062]
[3335,"Client AE","Courcelette",null,null,null,0,null,null,null,0,0,null,null,null,0,45.5,null,64.75,110.25,5.5125000000000002,null,null,null,0,7.12,12.32,null,19.440000000000001,1.9440000000000002,798.12,-256.07,null,542.04999999999995,226.77,105.37,78.59,410.73,95.278000000000006,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,378.8,null,null,378.8,18.940000000000001,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,121.67450000000001]
[3530,"Client AF","Sherbrooke",null,null,null,0,null,null,null,0,0,null,395,null,395,322.25,246.55,161.47,730.27,56.263500000000001,null,null,null,0,3.56,null,6.16,9.7200000000000006,0.97200000000000009,207.88,194.83,null,402.71000000000004,null,34.655999999999999,37.120000000000005,71.77600000000001,47.448600000000006,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,267,null,267,13.8,67.900000000000006,null,81.7,17.434999999999999,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,122.1191]
[3352,"Client AG","Montréal",876.92,593.29,1541.95,3012.16,null,null,null,0,150.608,null,304,null,304,56.06,332.4,30.5,418.96,36.148000000000003,17.96,null,null,17.96,39.840000000000003,126.84,90.38,257.06,27.501999999999999,1589.06,-792.77,674.95,1471.24,110.57999999999998,196.39,78.42,385.39,185.66300000000001,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,56.25,null,56.25,13.8,103,20.7,137.5,9.6875,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,409.60850000000005]
[4062,"Client AH","Eastman",null,null,null,0,null,null,null,0,0,null,573,null,573,13.26,253,76,342.26,45.763000000000005,null,null,null,0,null,null,6.16,6.16,0.6160000000000001,1683.2,-1685.7,85.89,83.39,4.29,55.14,42.79,102.22,18.561000000000003,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,76,38,114,5.7,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,70.640000000000015]
[3148,"Client AI","Cap-aux-Meules",null,null,null,0,null,null,null,0,0,-89,2345,-510,1746,139.94999999999999,29.35,245.33,414.63,108.03150000000001,null,null,null,0,18.48,null,null,18.48,1.8480000000000001,867.19,-1328.89,570.45000000000005,108.75,18.57,71.819999999999993,33.69,124.07999999999998,23.283000000000001,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,152,152,7.6000000000000005,null,null,null,0,null,null,null,0,0,1250.0999999999999,751.81,755,2756.91,68.922749999999994,null,null,null,0,0,209.68525]
[3528,"Client AJ","Ferme-Neuve",24.62,null,null,24.62,null,37.18,null,37.18,3.09,16,null,null,16,null,93.5,111.5,205,11.05,null,null,null,0,null,18.48,null,18.48,1.8480000000000001,null,1360.91,null,1360.91,183.42200000000003,44.29,16.13,243.84200000000001,160.47520000000003,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,36.799999999999997,null,36.799999999999997,1.8399999999999999,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,178.30320000000003]
[3287,"Client AK","St-Zacharie",null,null,null,0,null,null,null,0,0,null,null,null,0,22.95,217.48,16,256.42999999999995,12.821499999999999,null,null,null,0,null,null,23,23,2.3000000000000003,null,null,null,0,56.030000000000008,57.08,46.77,159.88000000000002,15.988000000000003,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,31.109500000000004]
[3377,"Client AL","Lévis",null,null,null,0,null,null,null,0,0,null,null,null,0,22.27,18.82,79.12,120.21000000000001,6.0105000000000004,null,null,null,0,3.56,null,null,3.56,0.35600000000000004,-50.19,null,null,-50.19,27.82,28.21,41.513999999999996,97.543999999999997,4.7354000000000003,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,11.101900000000001]
[3381,"Client AM","Ste-Luce",null,null,null,0,null,null,null,0,0,null,null,null,0,5.12,89.35,37.58,132.05000000000001,6.6025000000000009,28.42,null,216.29,244.70999999999998,null,null,6.16,6.16,25.087,null,null,null,0,106.11,17.009999999999998,129.85,252.97,25.297000000000001,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,56.986500000000007]
[3576,"Client AN","Québec",null,null,null,0,null,null,null,0,0,null,null,null,0,18.2,40.6,169.05,227.85000000000002,11.392500000000002,null,null,null,0,null,null,null,0,0,null,null,null,0,8.69,89.673000000000002,3.87,102.233,10.223300000000002,null,null,null,0,null,null,null,0,0,null,null,null,0,null,null,null,0,0,null,10,null,10,null,38,null,38,2.4000000000000004,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,24.015800000000006]
[3548,"Client AO","Trois-Rivières",null,null,null,0,null,null,null,0,0,null,null,null,0,51.62,84.3,78.5,214.42,10.721,null,null,null,0,null,3.56,null,3.56,0.35600000000000004,null,-548.41,null,-548.41,37.750000000000007,51.36,22.049999999999997,111.16000000000001,-43.724999999999994,null,null,null,0,null,null,null,0,0,{"$f":"100+770+147","v":1017},124,null,1141,null,null,null,0,114.10000000000001,null,null,null,0,null,38,null,38,1.9000000000000001,null,null,null,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,83.352000000000004]
["TOTAL CRÉDITS À FACTURER AUX FOURNISSEURS",null,null,null,null,null,{"$f":"SUM(G6:G46)","v":4126.3099999999995},null,null,null,{"$f":"SUM(K6:K46)","v":73.62},{"$f":"SUM(L6:L46)","v":209.9965},null,null,null,{"$f":"SUM(P6:P46)","v":8724},null,null,null,15041.859999999999,1188.2929999999999,null,null,null,{"$f":"SUM(Y6:Y46)","v":1214.3699999999999},null,null,null,{"$f":"SUM(AC6:AC46)","v":1010.3199999999999},{"$f":"SUM(AD6:AD46)","v":222.46900000000008},null,null,null,{"$f":"SUM(AH6:AH46)","v":18159.54},null,null,null,13154.679999999997,3131.4219999999996,null,null,null,{"$f":"SUM(AQ6:AQ46)","v":0},null,null,null,{"$f":"SUM(AU6:AU46)","v":0},{"$f":"SUM(AV6:AV46)","v":0},null,null,null,{"$f":"SUM(AZ6:AZ46)","v":11293},null,null,null,{"$f":"SUM(BD6:BD46)","v":0},{"$f":"SUM(BE6:BE46)","v":1129.3},null,null,null,{"$f":"SUM(BI6:BI46)","v":9148.4499999999989},null,null,null,{"$f":"SUM(BM6:BM46)","v":8246.86},{"$f":"SUM(BN6:BN46)","v":869.7655000000002},null,null,null,{"$f":"SUM(BR6:BR46)","v":0},null,null,null,{"$f":"SUM(BV6:BV46)","v":0},{"$f":"SUM(BW6:BW46)","v":0},null,null,null,{"$f":"SUM(CA6:CA46)","v":10186.83},{"$f":"SUM(CB6:CB46)","v":254.67075},null,null,null,{"$f":"SUM(CF6:CF46)","v":64.75},{"$f":"SUM(CG6:CG46)","v":3.2375000000000003},null,{"$f":"SUM(CH6:CH47)","v":7009.1542499999996}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CG47+CB47+BE47+BW47+BN47+AV47+AM47+AD47+U47+L47","v":7009.1542499999996}]
[null,"Ventes totales par fournisseur "]
[null,"FOURN. A",{"$f":"G47+K47","v":4199.9299999999994}]
[null,"FOURN. B",{"$f":"P47+T47","v":23765.86}]
[null,"FOURN. C",{"$f":"Y47+AC47","v":2224.6899999999996}]
[null,"FOURN. D",{"$f":"AH47+AL47","v":31314.219999999998}]
[null,"FOURN. E",{"$f":"AQ47+AU47","v":0}]
[null,"FOURN. F",{"$f":"AZ47+BD47","v":11293}]
[null,"FOURN. G",{"$f":"BI47+BM47","v":17395.309999999998}]
[null,"FOURN. H",{"$f":"BR47+BV47","v":0}]
[null,"FOURN. I  A+B",{"$f":"CA47+CF47","v":10251.58}]

{"sheet":"mais voudrais idéalement","index":3,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,3,1]]}
["CREDITS TRIMESTRIELS\nOCTOBRE - NOVEMBRE - DECEMBRE 2015"]
[]
[]
[]
["# client","Nom de la succursale","# item","Fournisseur","Montant"]
[3520,"Client A",1572,"Fourn. B 5%",33.119999999999997]
[3520,"Client A",1572,"Fourn. C 10%",41.25]
[3520,"Client A",1572,"Fourn. D 10%",73.14]
["SOUS-TOTAL CLIENT A",null,null,null,{"$f":"SUM(E6:E8)","v":147.51}]
[3510,"Client B",1572,"Fourn. B 5%",53.41]
[3510,"Client B",1572,"Fourn. D 10%",129.56]
[3510,"Client B",1572,"Fourn. G 5%",33.06]
["SOUS-TOTAL CLIENT B",null,null,null,{"$f":"SUM(E10:E12)","v":216.03}]
[3562,"Client C",1572,"Fourn. B 5%",5.98]
[3562,"Client C",1572,"Fourn. C 10%",3.44]
[3562,"Client C",1572,"Fourn. D 10%",88.57]
[3562,"Client C",1572,"Fourn. F 10%",10.8]
["SOUS-TOTAL CLIENT C",null,null,null,{"$f":"SUM(E14:E17)","v":108.78999999999999}]
["etc…. jusqu'à la ligne grise de la feuille Original qui contient du texte et non un numéro de client"]
["Mais d'autres clients peuvent se rajouter à la suite. Ce sera différent à chaque trimestre."]
["La colonne C ici n'est pas obligatoire, c'est juste le code de facturation. C'est le même tout le temps."]
["La facturation se fera à la main. Ce n'est pas un export de ce fichier vers un autre programme."]
["Et dans la colonne D ici, le % se retrouve à la ligne 5 de la feuille Original. Il pourrait tout aussi bien"]
["être dans une autre colonne. Mais il doit y être car il devra être écrit sur la facture."]