{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Accueil","Base","Vendeurs","Produits","Table finale","TCD","TCD pour analyse","Eléments calculés","Plan","Param"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":12,"comments":0,"pivot_tables":6},"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":"Accueil","index":0,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Les quatres grands DANGERS des TCD"]

{"sheet":"Base","index":1,"n_rows":267,"n_cols":6,"rows_kept":267,"cut":false,"hidden":false,"merged":[]}
["Clef","Date","No Vendeur","Code produit","Chiffre d'affaires","Unités vendues"]
[1,"2016-01-01",1,2,3132,157]
[2,"2016-01-01",1,3,776.1,78]
[3,"2016-01-01",2,3,1213.9000000000001,122]
[4,"2016-01-01",3,3,955.2,96]
[5,"2016-01-01",4,3,1273.5999999999999,128]
[6,"2016-01-01",5,3,547.25,55]
[12,"2016-02-01",1,2,3531.15,177]
[13,"2016-02-01",2,2,5067.3,254]
[14,"2016-02-01",3,2,4468.8,224]
[15,"2016-02-01",4,2,5386.5,270]
[16,"2016-02-01",5,2,2174.5500000000002,109]
[17,"2016-02-01",1,3,786.05,79]
[18,"2016-02-01",2,3,1094.5,110]
[19,"2016-02-01",3,3,1074.5999999999999,108]
[20,"2016-02-01",4,3,1452.7,146]
[21,"2016-02-01",5,3,597,60]
[27,"2016-03-01",1,2,3072.3,154]
[28,"2016-03-01",2,2,3970.05,199]
[29,"2016-03-01",3,2,3870.3,194]
[30,"2016-03-01",4,2,4468.8,224]
[31,"2016-03-01",5,2,1715.7,86]
[32,"2016-03-01",1,3,616.9,62]
[33,"2016-03-01",2,3,875.6,88]
[34,"2016-03-01",3,3,796,80]
[35,"2016-03-01",4,3,1014.9,102]
[36,"2016-03-01",5,3,398,40]
[42,"2016-04-01",1,2,2613.4499999999998,131]
[43,"2016-04-01",2,2,4289.25,215]
[44,"2016-04-01",3,2,3910.2,196]
[45,"2016-04-01",4,2,4369.05,219]
[46,"2016-04-01",5,2,1755.6,88]
[47,"2016-04-01",1,3,517.4,52]
[48,"2016-04-01",2,3,815.9,82]
[49,"2016-04-01",3,3,776.1,78]
[50,"2016-04-01",4,3,955.2,96]
[51,"2016-04-01",5,3,328.35,33]
[52,"2016-04-01",1,1,79.8,4]
[53,"2016-04-01",2,1,99.75,5]
[54,"2016-04-01",3,1,119.7,6]
[55,"2016-04-01",4,1,159.6,8]
[56,"2016-04-01",5,1,59.85,3]
[57,"2016-05-01",1,2,3511.2,176]
[58,"2016-05-01",2,2,5306.7,266]
[59,"2016-05-01",3,2,5107.2,256]
[60,"2016-05-01",4,2,5905.2,296]
[61,"2016-05-01",5,2,2573.5500000000002,129]
[62,"2016-05-01",1,3,756.2,76]
[63,"2016-05-01",2,3,985.05,99]
[64,"2016-05-01",3,3,1034.8,104]
[65,"2016-05-01",4,3,1253.7,126]
[66,"2016-05-01",5,3,527.35,53]
[67,"2016-05-01",1,1,99.75,5]
[68,"2016-05-01",2,1,139.65,7]
[69,"2016-05-01",3,1,119.7,6]
[70,"2016-05-01",4,1,179.55,9]
[71,"2016-05-01",5,1,59.85,3]
[72,"2016-06-01",1,2,6743.1,338]
[73,"2016-06-01",2,2,10234.35,513]
[74,"2016-06-01",3,2,8698.2000000000007,436]
[75,"2016-06-01",4,2,10194.450000000001,511]
[76,"2016-06-01",5,2,4249.3500000000004,213]
[77,"2016-06-01",1,3,1323.35,133]
[78,"2016-06-01",2,3,1681.55,169]
[79,"2016-06-01",3,3,1482.55,149]
[80,"2016-06-01",4,3,2109.4,212]
[81,"2016-06-01",5,3,716.4,72]
[82,"2016-06-01",1,1,179.55,9]
[83,"2016-06-01",2,1,239.4,12]
[84,"2016-06-01",3,1,239.4,12]
[85,"2016-06-01",4,1,319.2,16]
[86,"2016-06-01",5,1,119.7,6]
[87,"2016-07-01",1,2,7680.75,385]
[88,"2016-07-01",2,2,10693.2,536]
[89,"2016-07-01",3,2,9296.7000000000007,466]
[90,"2016-07-01",4,2,13286.7,666]
[91,"2016-07-01",5,2,4907.7,246]
[92,"2016-07-01",1,3,1492.5,150]
[93,"2016-07-01",2,3,1950.2,196]
[94,"2016-07-01",3,3,1860.65,187]
[95,"2016-07-01",4,3,2208.9,222]
[96,"2016-07-01",5,3,975.1,98]
[97,"2016-07-01",1,1,299.25,15]
[98,"2016-07-01",2,1,339.15,17]
[99,"2016-07-01",3,1,319.2,16]
[100,"2016-07-01",4,1,478.8,24]
[101,"2016-07-01",5,1,159.6,8]
[102,"2016-08-01",1,2,9177,460]
[103,"2016-08-01",2,2,13685.7,686]
[104,"2016-08-01",3,2,13027.35,653]
[105,"2016-08-01",4,2,14782.95,741]
[106,"2016-08-01",5,2,5805.45,291]
[107,"2016-08-01",1,3,1572.1,158]
[108,"2016-08-01",2,3,2039.75,205]
[109,"2016-08-01",3,3,1910.4,192]
[110,"2016-08-01",4,3,2198.9499999999998,221]
[111,"2016-08-01",5,3,945.25,95]
[112,"2016-08-01",1,1,379.05,19]
[113,"2016-08-01",2,1,498.75,25]
[114,"2016-08-01",3,1,399,20]
[115,"2016-08-01",4,1,578.54999999999995,29]
[116,"2016-08-01",5,1,239.4,12]
[117,"2016-09-01",1,2,11730.6,588]
[118,"2016-09-01",2,2,17935.05,899]
[119,"2016-09-01",3,2,14064.75,705]
[120,"2016-09-01",4,2,18274.2,916]
[121,"2016-09-01",5,2,7999.95,401]
[122,"2016-09-01",1,3,1562.15,157]
[123,"2016-09-01",2,3,2338.25,235]
[124,"2016-09-01",3,3,2019.85,203]
[125,"2016-09-01",4,3,2875.55,289]
[126,"2016-09-01",5,3,935.3,94]
[127,"2016-09-01",1,1,438.9,22]
[128,"2016-09-01",2,1,558.6,28]
[129,"2016-09-01",3,1,518.70000000000005,26]
[130,"2016-09-01",4,1,698.25,35]
[131,"2016-09-01",5,1,259.35000000000002,13]
[132,"2016-10-01",1,2,16199.4,812]
[133,"2016-10-01",2,2,25156.95,1261]
[134,"2016-10-01",3,2,20249.25,1015]
[135,"2016-10-01",4,2,27750.45,1391]
[136,"2016-10-01",5,2,10553.55,529]
[137,"2016-10-01",1,3,2278.5500000000002,229]
[138,"2016-10-01",2,3,3422.8,344]
[139,"2016-10-01",3,3,2646.7,266]
[140,"2016-10-01",4,3,4039.7,406]
[141,"2016-10-01",5,3,1562.15,157]
[142,"2016-10-01",1,1,578.54999999999995,29]
[143,"2016-10-01",2,1,817.95,41]
[144,"2016-10-01",3,1,738.15,37]
[145,"2016-10-01",4,1,1037.4000000000001,52]
[146,"2016-10-01",5,1,339.15,17]
[147,"2016-11-01",1,2,16438.8,824]
[148,"2016-11-01",2,2,21107.1,1058]
[149,"2016-11-01",3,2,20548.5,1030]
[150,"2016-11-01",4,2,22922.55,1149]
[151,"2016-11-01",5,2,8817.9,442]
[152,"2016-11-01",1,3,2427.8000000000002,244]
[153,"2016-11-01",2,3,3363.1,338]
[154,"2016-11-01",3,3,2577.0500000000002,259]
[155,"2016-11-01",4,3,3790.95,381]
[156,"2016-11-01",5,3,1512.4,152]
[157,"2016-11-01",1,1,658.35,33]
[158,"2016-11-01",2,1,997.5,50]
[159,"2016-11-01",3,1,877.8,44]
[160,"2016-11-01",4,1,1077.3,54]
[161,"2016-11-01",5,1,458.85,23]
[162,"2016-12-01",1,2,13266.75,665]
[163,"2016-12-01",2,2,17316.599999999999,868]
[164,"2016-12-01",3,2,15740.55,789]
[165,"2016-12-01",4,2,22683.15,1137]
[166,"2016-12-01",5,2,8797.9500000000007,441]
[167,"2016-12-01",1,3,2049.6999999999998,206]
[168,"2016-12-01",2,3,2686.5,270]
[169,"2016-12-01",3,3,2716.35,273]
[170,"2016-12-01",4,3,3402.9,342]
[171,"2016-12-01",5,3,1293.5,130]
[172,"2016-12-01",1,1,718.2,36]
[173,"2016-12-01",2,1,1017.45,51]
[174,"2016-12-01",3,1,837.9,42]
[175,"2016-12-01",4,1,1236.9000000000001,62]
[176,"2016-12-01",5,1,438.9,22]
[177,"2017-01-01",1,2,9097.2000000000007,456]
[178,"2017-01-01",2,2,13286.7,666]
[179,"2017-01-01",3,2,10773,540]
[180,"2017-01-01",4,2,13705.65,687]
[181,"2017-01-01",5,2,5685.75,285]
[182,"2017-01-01",1,3,1442.75,145]
[183,"2017-01-01",2,3,1830.8,184]
[184,"2017-01-01",3,3,1641.75,165]
[185,"2017-01-01",4,3,2159.15,217]
[186,"2017-01-01",5,3,815.9,82]
[187,"2017-01-01",1,1,598.5,30]
[188,"2017-01-01",2,1,698.25,35]
[189,"2017-01-01",3,1,638.4,32]
[190,"2017-01-01",4,1,897.75,45]
[191,"2017-01-01",5,1,339.15,17]
[192,"2017-02-01",1,2,9436.35,473]
[193,"2017-02-01",2,2,15142.05,759]
[194,"2017-02-01",3,2,12329.1,618]
[195,"2017-02-01",4,2,16538.55,829]
[196,"2017-02-01",5,2,6483.75,325]
[197,"2017-02-01",1,3,1442.75,145]
[198,"2017-02-01",2,3,2019.85,203]
[199,"2017-02-01",3,3,1800.95,181]
[200,"2017-02-01",4,3,2328.3000000000002,234]
[201,"2017-02-01",5,3,835.8,84]
[202,"2017-02-01",1,1,758.1,38]
[203,"2017-02-01",2,1,977.55,49]
[204,"2017-02-01",3,1,977.55,49]
[205,"2017-02-01",4,1,1236.9000000000001,62]
[206,"2017-02-01",5,1,518.70000000000005,26]
[207,"2017-03-01",1,2,8957.5499999999993,449]
[208,"2017-03-01",2,2,11970,600]
[209,"2017-03-01",3,2,10054.799999999999,504]
[210,"2017-03-01",4,2,14822.85,743]
[211,"2017-03-01",5,2,4807.95,241]
[212,"2017-03-01",1,3,935.3,94]
[213,"2017-03-01",2,3,1253.7,126]
[214,"2017-03-01",3,3,1174.0999999999999,118]
[215,"2017-03-01",4,3,1761.15,177]
[216,"2017-03-01",5,3,577.1,58]
[217,"2017-03-01",1,1,718.2,36]
[218,"2017-03-01",2,1,1077.3,54]
[219,"2017-03-01",3,1,917.7,46]
[220,"2017-03-01",4,1,1197,60]
[221,"2017-03-01",5,1,458.85,23]
[222,"2017-04-01",1,2,6822.9,342]
[223,"2017-04-01",2,2,10892.7,546]
[224,"2017-04-01",3,2,8897.7000000000007,446]
[225,"2017-04-01",4,2,12408.9,622]
[226,"2017-04-01",5,2,4269.3,214]
[227,"2017-04-01",1,3,905.45,91]
[228,"2017-04-01",2,3,1223.8499999999999,123]
[229,"2017-04-01",3,3,1074.5999999999999,108]
[230,"2017-04-01",4,3,1532.3,154]
[231,"2017-04-01",5,3,507.45,51]
[232,"2017-04-01",1,1,658.35,33]
[233,"2017-04-01",2,1,977.55,49]
[234,"2017-04-01",3,1,877.8,44]
[235,"2017-04-01",4,1,1236.9000000000001,62]
[236,"2017-04-01",5,1,399,20]
[237,"2017-05-01",1,2,9037.35,453]
[238,"2017-05-01",2,2,13685.7,686]
[239,"2017-05-01",3,2,12049.8,604]
[240,"2017-05-01",4,2,17137.05,859]
[241,"2017-05-01",5,2,6284.25,315]
[242,"2017-05-01",1,3,1004.95,101]
[243,"2017-05-01",2,3,1393,140]
[244,"2017-05-01",3,3,1462.65,147]
[245,"2017-05-01",4,3,1721.35,173]
[246,"2017-05-01",5,3,696.5,70]
[247,"2017-05-01",1,1,957.6,48]
[248,"2017-05-01",2,1,1396.5,70]
[249,"2017-05-01",3,1,1336.65,67]
[250,"2017-05-01",4,1,1536.15,77]
[251,"2017-05-01",5,1,698.25,35]
[252,"2017-06-01",1,2,18254.25,915]
[253,"2017-06-01",2,2,22264.2,1116]
[254,"2017-06-01",3,2,21326.55,1069]
[255,"2017-06-01",4,2,28289.1,1418]
[256,"2017-06-01",5,2,11850.3,594]
[257,"2017-06-01",1,3,1701.45,171]
[258,"2017-06-01",2,3,2577.0500000000002,259]
[259,"2017-06-01",3,3,2129.3000000000002,214]
[260,"2017-06-01",4,3,3054.65,307]
[261,"2017-06-01",5,3,1014.9,102]
[262,"2017-06-01",1,1,2094.75,105]
[263,"2017-06-01",2,1,2633.4,132]
[264,"2017-06-01",3,1,2394,120]
[265,"2017-06-01",4,1,3251.85,163]
[266,"2017-06-01",5,1,1197,60]
[267,"2017-07-01",1,2,20249.25,1015]
[268,"2017-07-01",2,2,32578.35,1633]
[269,"2017-07-01",3,2,28269.15,1417]
[270,"2017-07-01",4,2,32558.400000000001,1632]
[271,"2017-07-01",5,2,14124.6,708]
[272,"2017-07-01",1,3,1960.15,197]
[273,"2017-07-01",2,3,2835.75,285]
[274,"2017-07-01",3,3,2457.65,247]
[275,"2017-07-01",4,3,3383,340]
[276,"2017-07-01",5,3,1213.9000000000001,122]
[277,"2017-07-01",1,1,2314.1999999999998,116]
[278,"2017-07-01",2,1,3571.05,179]
[279,"2017-07-01",3,1,3231.9,162]
[280,"2017-07-01",4,1,4608.45,231]
[281,"2017-07-01",5,1,1436.4,72]

{"sheet":"Vendeurs","index":2,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["No","Nom","Région"]
[4,"Mme Bourguignon","Région Est"]
[3,"M. Desmol","Région Centre"]
[2,"M. Dupuis","Région Ouest"]
[1,"M. Lebon","Région Nord"]
[5,"Internet","Internet"]

{"sheet":"Produits","index":3,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Code produit","Description Produit"]
[1,"Produit B"]
[2,"Produit C"]
[3,"Produit A"]

{"sheet":"Table finale","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"TCD","index":5,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
["Années","Mois","Somme de Chiffre d'affaires",null,"Années","Mois","Somme de Chiffre d'affaires"]
["2016","janv",1273.5999999999999,null,"2016","janv",1213.9000000000001]
[null,"févr",6839.2,null,null,"févr",6161.8]
[null,"mars",5483.7,null,null,"mars",4845.6500000000005]
[null,"avr",5483.85,null,null,"avr",5204.8999999999996]
[null,"mai",7338.45,null,null,"mai",6431.4]
[null,"juin",12623.050000000001,null,null,"juin",12155.300000000001]
[null,"juil",15974.400000000001,null,null,"juil",12982.550000000001]
[null,"août",17560.45,null,null,"août",16224.2]
[null,"sept",21848,null,null,"sept",20831.899999999998]
[null,"oct",32827.550000000003,null,null,"oct",29397.7]
[null,"nov",27790.799999999999,null,null,"nov",25467.699999999997]
[null,"déc",27322.95,null,null,"déc",21020.55]
["Total 2016",null,182366,null,"Total 2016",null,161937.54999999999]
["Total général",null,182366,null,"Total général",null,161937.54999999999]
[]
[]
[]
[]
["Description Produit","Somme de Chiffre d'affaires",null,null,"Description Produit","Somme de Chiffre d'affaires"]
["Produit A",26576.450000000008,null,null,"Produit A",22467.1]
["Produit B",5765.55,null,null,"Produit B",4708.1999999999989]
["Produit C",150024,null,null,"Produit C",134762.25]
["Total général",182366,null,null,"Total général",161937.54999999999]

{"sheet":"TCD pour analyse","index":6,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Description Produit","(Tous)"]
["Années","(Plusieurs éléments)"]
[]
["Date","Chiffre d'affaires ","Unités vendues ","Prix Moyen de Vente Unitaire "]
["<01/01/2016","--","--","Calcul impossible"]
["janv",71508.749999999985,4222,16.937174324964467]
["févr",98459.400000000009,5612,17.544440484675697]
["mars",81482.10000000002,4558,17.876722246599389]
["avr",73533.950000000012,4121,17.843715117689882]
["mai",97957.2,5456,17.954032258064515]
["juin",172562.69999999998,9546,18.076964173475801]
["juil",210740.59999999998,11588,18.186106316879528]
["août",67239.649999999994,3807,17.662109272392957]
["sept",82209.450000000012,4611,17.828985035783997]
["oct",117370.69999999998,6586,17.821242028545395]
["nov",107575.95000000001,6081,17.690503206709426]
["déc",94203.299999999959,5334,17.66091113610798]
[">02/07/2017","--","--","Calcul impossible"]
["Total général",1274843.75,71522,17.824498056542033]

{"sheet":"Eléments calculés","index":7,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Année","Ventes",null,null,null,"Année"]
[2016,15,null,null,null,2016,2017,"2017-2016"]
[2016,12,null,null,"Somme de Ventes",69,160,91]
[2016,16]
[2016,12]
[2016,14]
[2017,25]
[2017,26]
[2017,25]
[2017,27]
[2017,28]
[2017,29]

{"sheet":"Plan","index":8,"n_rows":64,"n_cols":1,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[{"$f":"INDEX(A:A,Param!B1+1)","v":0}]
["10       UTILISATION AVANCÉE DES TCD"]
["10.1      CONNECTER PLUSIEURS TABLES AVEC POWERPIVOT"]
["10.2      FILTRER LES DONNÉES   "]
["10.2.1     AFFICHER LES FILTRES EN LIGNES (OPTIONS)"]
["10.2.2     FILTRER UN TCD DIRECTEMENT DANS LE TABLEAU"]
["10.2.3     AFFICHER LES 5 PREMIERS ÉLÉMENTS D'UNE LISTE"]
["10.2.4     EFFACER TOUS LES FILTRES"]
["10.2.5     MASQUER UNE CENTAINE D’ÉLÉMENTS"]
["10.2.6     ÉCLATER UN TCD EN FONCTION DES VALEURS D'UN CHAMP"]
["10.2.7     FILTRER À PARTIR DE LA SÉLECTION"]
["10.3      SEGMENTS ET CHRONOLOGIE "]
["10.3.1     AFFICHER LES SEGMENTS"]
["10.3.2     AFFICHER UNE CHRONOLOGIE"]
["10.3.3     PARAMÈTRES DES SEGMENTS"]
["10.3.4     LIER LES SEGMENTS, QUELQUES SUBTILITÉS"]
["10.3.5     AFFICHER PLUSIEURS COLONNES SUR UN SEGMENT"]
["10.3.6     ALIGNER RAPIDEMENT LES SEGMENTS"]
["10.4      TRIER LES DONNÉES   "]
["10.4.1     TRI CLASSIQUE"]
["10.4.2     FAIRE UN TRI PERSONNALISÉ AVEC DES LISTES"]
["10.5      GROUPEMENT DES DONNÉES ET DRILL DOWN"]
["10.5.1     GROUPEMENT DIRECT"]
["10.5.2     CRÉER DES TRANCHES D'ÂGE"]
["10.5.3     GROUPER DES DATES EN FONCTION DE L'ANNÉE, TRIMESTRE ET MOIS"]
["10.5.4     GROUPER DES DATES PAR SEMAINE"]
["10.5.5     LE GROUPEMENT PAR DATE NE FONCTIONNE PAS"]
["10.5.6     DANGER : NE PAS OUBLIER LES ANNÉES"]
["10.5.7     DRILL DOWN SUR UN CHAMP DE LIGNE OU DE COLONNE"]
["10.5.8     DRILL DOWN SUR UN CALCUL"]
["10.5.9     VBA : SUPPRIMER LA FEUILLE AFFICHANT LE DÉTAIL D'UN MONTANT"]
["10.5.10  VBA : AFFICHER LE RÉSULTAT DU DRILLDOWN SUR UN USERFORM"]
["10.6      CALCULS…"]
["10.6.1     % du…, cumul par…"]
["10.6.2     SOUS-TOTAUX"]
["10.6.3     CHAMPS CALCULÉS, QUELQUES SUBTILITÉS"]
["10.6.4     ÉLÉMENTS CALCULÉS, QUELQUES SUBTILITÉS"]
["10.6.5     COMPTER LE NOMBRE D'ÉLÉMENTS UNIQUES D'UNE COLONNE"]
["10.6.6     DÉSACTIVER LA FORMULE LIREDONNEESTABCROISDYNAMIQUE"]
["10.7      MISE EN FORME"]
["10.7.1     RÉORGANISATION DES ÉLÉMENTS"]
["10.7.2     MISE EN FORME DU CHAMP "]
["10.7.3     MISE EN FORME ET FILTRES"]
["10.7.4     ENLEVER LE \"SOMME DE\" DES DONNÉES"]
["10.7.5     GESTION DES STYLES DE TABLEAU CROISÉ DYNAMIQUE"]
["10.7.5.1    CRÉER UN STYLE"]
["10.7.5.2    APPLIQUER UN STYLE"]
["10.7.5.3    MODIFIER UN STYLE"]
["10.7.5.4    DUPLIQUER"]
["10.7.5.5    SUPPRIMER"]
["10.7.5.6    GESTION DES THÈMES"]
["10.7.7     QUELQUES OPTIONS SUPPLÉMENTAIRES DU TCD   "]
["10.7.7.1    AFFICHER/MASQUER LES TOTAUX"]
["10.7.7.2  LARGEUR DE COLONNE"]
["10.7.7.3    AFFICHER/MASQUER LES ÉLÉMENTS SANS DONNÉES"]
["10.7.7.4    FUSIONNER LES CELLULES D'ÉTIQUETTE"]
["10.7.7.5    RÉPÉTER LES ÉTIQUETTES À L'IMPRESSION EN CAS DE CHANGEMENT DE PAGE"]
["10.7.7.6    IMPRIMER AUTOMATIQUEMENT LES TITRES DU TCD SUR TOUTES LES PAGES"]
["10.7.7.7    AFFICHER DES \"---\" DANS LES CELLULES VIDES DU TCD"]
["10.7.7.8    REMPLACER UN MESSAGE D'ERREUR \"DIV/0!\" PAR \"ERREUR\""]
["10.8   ACTUALISATION DES DONNÉES"]
["10.8.1  ACTUALISATION DES DONNÉES DU TCD"]
["10.8.2  DIFFÉRENTES OPTIONS D’ACTUALISATION DES DONNÉES"]
["10.8.3  ACTUALISATION DES DONNÉES AU CHANGEMENT DE FEUILLES - VBA"]

{"sheet":"Param","index":9,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Règle en cours : ",65]