{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Numération D ceinture","Numération N ceinture","plages"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":3,"comments":1,"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":"Numération D ceinture","index":0,"n_rows":67,"n_cols":106,"rows_kept":67,"cut":false,"hidden":false,"merged":[[0,17,0,18],[0,22,0,28],[31,20,31,22],[34,14,34,15],[22,22,22,24],[24,22,24,24],[25,20,25,22],[26,20,26,22],[30,20,30,22],[15,16,16,16],[25,17,30,17],[10,19,12,21]]}
[null,"1. Range en ordre croissant. Ecris sous chaque nombre son n° d'ordre.   … / 8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Taille des nombres",null,"Fiche",175,null,"EFFECTUER LE REGLAGE SUIVANT DANS LES OPTIONS EXCEL."]
[null,{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":11.976000000000001},"-",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":23.286000000000001},"-",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":3.3},"-",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":9.782},"-",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":28.177},"-",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":9.8719999999999999},"-",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":15.09},"-",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":4.3570000000000002},1,"min",3,null,3]
[null,"……….",null,"……….",null,"……….",null,"……….",null,"……….",null,"……….",null,"……….",null,"……….",null,"max",30]
[]
[null,"2. Range en ordre décroissant. Ecris sous chaque nombre son n° d'ordre.    … / 8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Partie décimale en millièmes."]
[null,{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":13.414999999999999},"-",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":4.3330000000000002},"-",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":24.19},"-",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":10.913},"-",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":15.436999999999999},"-",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":22.638000000000002},"-",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":8.5920000000000005},"-",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":30.376000000000001}]
[null,"……….",null,"……….",null,"……….",null,"……….",null,"……….",null,"……….",null,"……….",null,"………."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"3. Compare.    … / 8"]
[null,{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":5.5},"…",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":29.475000000000001},null,{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":17.03},"…",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":10.151999999999999},null,{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":7.8730000000000002},"…",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":20.446999999999999},null,{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":16.673999999999999},"…",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":17.292000000000002},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,null,null,null,null,"La droite sera graduée en millièmes."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"← F9 du clavier pour renouveler les exercices."]
[null,{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":7.5720000000000001},"…",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":6.7930000000000001},null,{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":27.341000000000001},"…",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":3.0459999999999998},null,{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":29.324000000000002},"…",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":25.356999999999999},null,{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":4.335},"…",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":18.436},null,5]
[]
[null,"4. Continue la série.   … / 3"]
[null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":29},"-",{"$f":"B15+S15","v":29.3},"-","……….","-","……….","-","……….","-","……….","-","……….","-","……….",null,"pas",0.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,"5. Continue la série.   … / 3"]
[null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":24},"-",{"$f":"B18-S18","v":23.5},"-","……….","-","……….","-","……….","-","……….","-","……….","-","……….",null,"pas",0.5,null,null,null,"La partie décimale est volontairement limitée à 3 décimales."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dans ce type d'exercices, il n'est pas utile de tirer des grands nombres. Choisir max < 100."]
[null,"6. Ecris en chiffres. … / 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Les exercices 4 & 5 commencent par un nombre entier pour faciliter le calcul de la série."]
[null,{"$f":"CONCATENATE(NumText(S21,\"\",\"\",$U$2,\"virgule \"), \"→\")","v":"quatorze virgule six cent dix-huit  →"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":14.618},null,null,null,"Pour ne faire varier que la partie décimale, choisir min = max."]
[null,{"$f":"CONCATENATE(NumText(S22,\"\",\"\",$U$2,\"virgule \"), \"→\")","v":"vingt-cinq virgule sept cent deux  →"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":25.702000000000002},null,null,null,"Choisir dans la liste déroulante, pour les exercices 7 & 8, une valeur en adéquation avec votre choix concernant la taille de la partie décimale. On ne peut arrondir au centième si on a demandé des nombres en dixièmes..."]
[null,"trente virgule cinq cent quatre-vingt-dix  →",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30.59]
[null,"six virgule cent cinquante-deux  →",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.1520000000000001]
[null,{"$f":" CONCATENATE(\"7. Encadre \",U27,\" près.   … / 8\")","v":"7. Encadre au dixième près.   … / 8"}]
[null,null,null,"……….","<",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":26.431999999999999},"<","……….",null,null,null,"……….","<",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":24.295000000000002},"<","……….",null,4,null,null,0.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(U26,plages!$D$1:$E$3,2,FALSE)","v":"au dixième"}]
[null,null,null,"……….","<",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":26.920999999999999},"<","……….",null,null,null,"……….","<",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":26.292999999999999},"<","………."]
[]
[null,{"$f":" CONCATENATE(\"8. Arrondis \",U32,IF(U31=1,\" la plus proche.   … / 8\",\" le plus proche.   … / 8\"))","v":"8. Arrondis au dixième le plus proche.   … / 8"}]
[null,{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":11.430999999999999},"®","……….",null,{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":21.742999999999999},"®","……….",null,{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":19.068000000000001},"®","……….",null,{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":18.390999999999998},"®","……….",null,null,null,null,0.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(U31,plages!$D$1:$E$3,2,FALSE)","v":"au dixième"}]
[null,{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":25.248000000000001},"®","……….",null,{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":4.7009999999999996},"®","……….",null,{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":4.6059999999999999},"®","……….",null,{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":12.208},"®","………."]
[]
[null,{"$f":"B1","v":"1. Range en ordre croissant. Ecris sous chaque nombre son n° d'ordre.   … / 8"},null,null,null,null,null,null,null,null,null,null,null,null,"CORRECTION"]
[null,11.976000000000001,"-",23.286000000000001,"-",3.3,"-",9.782,"-",28.177,"-",9.8719999999999999,"-",15.09,"-",4.3570000000000002]
[null,{"$f":"RANK(B36,$B$36:$P$36,1)","v":5},null,{"$f":"RANK(D36,$B$36:$P$36,1)","v":7},null,{"$f":"RANK(F36,$B$36:$P$36,1)","v":1},null,{"$f":"RANK(H36,$B$36:$P$36,1)","v":3},null,{"$f":"RANK(J36,$B$36:$P$36,1)","v":8},null,{"$f":"RANK(L36,$B$36:$P$36,1)","v":4},null,{"$f":"RANK(N36,$B$36:$P$36,1)","v":6},null,{"$f":"RANK(P36,$B$36:$P$36,1)","v":2}]
[]
[null,{"$f":"B5","v":"2. Range en ordre décroissant. Ecris sous chaque nombre son n° d'ordre.    … / 8"}]
[null,13.414999999999999,"-",4.3330000000000002,"-",24.19,"-",10.913,"-",15.436999999999999,"-",22.638000000000002,"-",8.5920000000000005,"-",30.376000000000001]
[null,{"$f":"RANK(B40,$B$40:$P$40,0)","v":5},null,{"$f":"RANK(D40,$B$40:$P$40,0)","v":8},null,{"$f":"RANK(F40,$B$40:$P$40,0)","v":2},null,{"$f":"RANK(H40,$B$40:$P$40,0)","v":6},null,{"$f":"RANK(J40,$B$40:$P$40,0)","v":4},null,{"$f":"RANK(L40,$B$40:$P$40,0)","v":3},null,{"$f":"RANK(N40,$B$40:$P$40,0)","v":7},null,{"$f":"RANK(P40,$B$40:$P$40,0)","v":1}]
[]
[null,{"$f":"B9","v":"3. Compare.    … / 8"}]
[null,{"$f":"B10","v":5.5},{"$f":"IF(B44<D44,\"<\",\">\")","v":"<"},{"$f":"D10","v":29.475000000000001},null,{"$f":"F10","v":17.03},{"$f":"IF(F44<H44,\"<\",\">\")","v":">"},{"$f":"H10","v":10.151999999999999},null,{"$f":"J10","v":7.8730000000000002},{"$f":"IF(J44<L44,\"<\",\">\")","v":"<"},{"$f":"L10","v":20.446999999999999},null,{"$f":"N10","v":16.673999999999999},{"$f":"IF(N44<P44,\"<\",\">\")","v":"<"},{"$f":"P10","v":17.292000000000002}]
[]
[null,{"$f":"B12","v":7.5720000000000001},{"$f":"IF(B46<D46,\"<\",\">\")","v":">"},6.7930000000000001,null,27.341000000000001,{"$f":"IF(F46<H46,\"<\",\">\")","v":">"},3.0459999999999998,null,29.324000000000002,{"$f":"IF(J46<L46,\"<\",\">\")","v":">"},25.356999999999999,null,4.335,{"$f":"IF(N46<P46,\"<\",\">\")","v":"<"},18.436]
[]
[null,{"$f":"B14","v":"4. Continue la série.   … / 3"}]
[null,{"$f":"B15","v":29},{"$f":"C15","v":"-"},{"$f":"D15","v":29.3},{"$f":"E15","v":"-"},{"$f":"D49+$S$15","v":29.6},{"$f":"G15","v":"-"},{"$f":"F49+$S$15","v":29.9},{"$f":"I15","v":"-"},{"$f":"H49+$S$15","v":30.2},{"$f":"K15","v":"-"},{"$f":"J49+$S$15","v":30.5},{"$f":"M15","v":"-"},{"$f":"L49+$S$15","v":30.8},{"$f":"O15","v":"-"},{"$f":"N49+$S$15","v":31.1}]
[]
[null,{"$f":"B17","v":"5. Continue la série.   … / 3"}]
[null,{"$f":"B18","v":24},{"$f":"C18","v":"-"},{"$f":"D18","v":23.5},{"$f":"E18","v":"-"},{"$f":"D52+$S$18","v":24},{"$f":"G18","v":"-"},{"$f":"F52-$S$18","v":23.5},{"$f":"I18","v":"-"},{"$f":"H52-$S$18","v":23},{"$f":"K18","v":"-"},{"$f":"J52-$S$18","v":22.5},{"$f":"M18","v":"-"},{"$f":"L52-$S$18","v":22},{"$f":"O18","v":"-"},{"$f":"N52-$S$18","v":21.5}]
[]
[null,{"$f":"B20","v":"6. Ecris en chiffres. … / 4"}]
[null,{"$f":"CONCATENATE(B21,\" \",TEXT(S21,\"###, ##0\"))","v":"quatorze virgule six cent dix-huit  → 14,618"}]
[null,{"$f":"CONCATENATE(B22,\" \",TEXT(S22,\"###, ##0\"))","v":"vingt-cinq virgule sept cent deux  → 25,702"}]
[null,"trente virgule cinq cent quatre-vingt-dix  → 30,590"]
[null,"six virgule cent cinquante-deux  → 6,152"]
[null,{"$f":"B25","v":"7. Encadre au dixième près.   … / 8"}]
[null,null,null,{"$f":"INT(F26/$U$26)*$U$26","v":26.4},{"$f":"E26","v":"<"},{"$f":"F26","v":26.431999999999999},{"$f":"G26","v":"<"},{"$f":"D60+$U$26","v":26.5},null,null,null,{"$f":"INT(N26/$U$26)*$U$26","v":24.2},{"$f":"M26","v":"<"},{"$f":"N26","v":24.295000000000002},{"$f":"O26","v":"<"},{"$f":"L60+$U$26","v":24.3}]
[]
[null,null,null,{"$f":"INT(F28/$U$26)*$U$26","v":26.9},{"$f":"E28","v":"<"},{"$f":"F28","v":26.920999999999999},{"$f":"G28","v":"<"},{"$f":"D62+$U$26","v":27},null,null,null,{"$f":"INT(N28/$U$26)*$U$26","v":26.2},{"$f":"M28","v":"<"},{"$f":"N28","v":26.292999999999999},{"$f":"O28","v":"<"},{"$f":"L62+$U$26","v":26.3}]
[]
[null,{"$f":"B30","v":"8. Arrondis au dixième le plus proche.   … / 8"}]
[null,{"$f":"B31","v":11.430999999999999},"®",{"$f":"ROUND(B65,-LOG($U$31))","v":11.4},null,{"$f":"F31","v":21.742999999999999},"®",{"$f":"ROUND(F65,-LOG($U$31))","v":21.7},null,{"$f":"J31","v":19.068000000000001},"®",{"$f":"ROUND(J65,-LOG($U$31))","v":19.100000000000001},null,{"$f":"N31","v":18.390999999999998},"®",{"$f":"ROUND(N65,-LOG($U$31))","v":18.399999999999999}]
[]
[null,{"$f":"B33","v":25.248000000000001},"®",{"$f":"ROUND(B67,-LOG($U$31))","v":25.2},null,{"$f":"F33","v":4.7009999999999996},"®",{"$f":"ROUND(F67,-LOG($U$31))","v":4.7},null,{"$f":"J33","v":4.6059999999999999},"®",{"$f":"ROUND(J67,-LOG($U$31))","v":4.5999999999999996},null,{"$f":"N33","v":12.208},"®",{"$f":"ROUND(N67,-LOG($U$31))","v":12.2}]

{"sheet":"Numération N ceinture","index":1,"n_rows":67,"n_cols":21,"rows_kept":67,"cut":false,"hidden":false,"merged":[[31,20,31,22],[34,14,34,15],[21,22,21,24],[22,22,22,24],[24,22,24,24],[25,20,25,22],[26,20,26,22],[30,20,30,22]]}
[null,"1. Range en ordre croissant. Ecris sous chaque nombre son n° d'ordre.   … / 8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fiche",266]
[null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":862429},"-",{"$f":"RANDBETWEEN($S$2,$S$3)","v":615300},"-",{"$f":"RANDBETWEEN($S$2,$S$3)","v":671046},"-",{"$f":"RANDBETWEEN($S$2,$S$3)","v":407854},"-",{"$f":"RANDBETWEEN($S$2,$S$3)","v":841286},"-",{"$f":"RANDBETWEEN($S$2,$S$3)","v":934174},"-",{"$f":"RANDBETWEEN($S$2,$S$3)","v":702057},"-",{"$f":"RANDBETWEEN($S$2,$S$3)","v":436942},null,"min",400000]
[null,"……….",null,"……….",null,"……….",null,"……….",null,"……….",null,"……….",null,"……….",null,"……….",null,"max",1000000]
[]
[null,"2. Range en ordre décroissant. Ecris sous chaque nombre son n° d'ordre.    … / 8"]
[null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":710511},"-",{"$f":"RANDBETWEEN($S$2,$S$3)","v":682335},"-",{"$f":"RANDBETWEEN($S$2,$S$3)","v":891625},"-",{"$f":"RANDBETWEEN($S$2,$S$3)","v":482818},"-",{"$f":"RANDBETWEEN($S$2,$S$3)","v":586032},"-",{"$f":"RANDBETWEEN($S$2,$S$3)","v":760571},"-",{"$f":"RANDBETWEEN($S$2,$S$3)","v":922141},"-",{"$f":"RANDBETWEEN($S$2,$S$3)","v":549146}]
[null,"……….",null,"……….",null,"……….",null,"……….",null,"……….",null,"……….",null,"……….",null,"………."]
[]
[null,"3. Compare.    … / 8"]
[null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":934523},"…",{"$f":"RANDBETWEEN($S$2,$S$3)","v":771926},null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":987533},"…",{"$f":"RANDBETWEEN($S$2,$S$3)","v":432475},null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":644319},"…",{"$f":"RANDBETWEEN($S$2,$S$3)","v":540073},null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":810140},"…",{"$f":"RANDBETWEEN($S$2,$S$3)","v":942365}]
[]
[null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":664272},"…",{"$f":"RANDBETWEEN($S$2,$S$3)","v":894629},null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":937911},"…",{"$f":"RANDBETWEEN($S$2,$S$3)","v":841235},null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":456031},"…",{"$f":"RANDBETWEEN($S$2,$S$3)","v":450153},null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":928780},"…",{"$f":"RANDBETWEEN($S$2,$S$3)","v":756946}]
[]
[null,"4. Continue la série.   … / 3"]
[null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":563360},"-",{"$f":"B15+S15","v":564360},"-","……….","-","……….","-","……….","-","……….","-","……….","-","……….",null,"pas",1000]
[]
[null,"5. Continue la série.   … / 3"]
[null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":819449},"-",{"$f":"B18-S18","v":809449},"-","……….","-","……….","-","……….","-","……….","-","……….","-","……….",null,"pas",10000]
[]
[null,"6. Ecris en chiffres. … / 4"]
[null,{"$f":"CONCATENATE(NumText(S21), \"→\")","v":"cinq cent vingt-deux mille cent dix-sept  →"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":522117}]
[null,{"$f":"CONCATENATE(NumText(S22), \"→\")","v":"neuf cent vingt-huit mille neuf cent cinquante-et-un  →"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":928951}]
[null,{"$f":"CONCATENATE(NumText(S23), \"→\")","v":"neuf cent vingt mille sept cent quatre-vingt-treize  →"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":920793}]
[null,{"$f":"CONCATENATE(NumText(S24), \"→\")","v":"sept cent quatre-vingt-sept mille cent trois  →"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":787103}]
[null,{"$f":" CONCATENATE(\"7. Encadre \",U27,\" près.   … / 8\")","v":"7. Encadre à la dizaine près.   … / 8"}]
[null,null,null,"……….","<",{"$f":"RANDBETWEEN($S$2,$S$3)","v":572187},"<","……….",null,null,null,"……….","<",{"$f":"RANDBETWEEN($S$2,$S$3)","v":714172},"<","……….",7,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(U26,plages!$A$1:$B$9,2,FALSE)","v":"à la dizaine"}]
[null,null,null,"……….","<",{"$f":"RANDBETWEEN($S$2,$S$3)","v":853275},"<","……….",null,null,null,"……….","<",{"$f":"RANDBETWEEN($S$2,$S$3)","v":925864},"<","………."]
[]
[null,{"$f":" CONCATENATE(\"8. Arrondis \",U32,\"  la plus proche.   … / 8\")","v":"8. Arrondis à la dizaine  la plus proche.   … / 8"}]
[null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":795106},"®","……….",null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":979242},"®","……….",null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":722540},"®","……….",null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":568726},"®","……….",8,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(U31,plages!$A$1:$B$9,2,FALSE)","v":"à la dizaine"}]
[null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":480978},"®","……….",null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":468952},"®","……….",null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":629034},"®","……….",null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":946381},"®","………."]
[]
[null,{"$f":"B1","v":"1. Range en ordre croissant. Ecris sous chaque nombre son n° d'ordre.   … / 8"},null,null,null,null,null,null,null,null,null,null,null,null,"CORRECTION"]
[null,862429,"-",615300,"-",671046,"-",407854,"-",841286,"-",934174,"-",702057,"-",436942]
[null,{"$f":"RANK(B36,$B$36:$P$36,1)","v":7},null,{"$f":"RANK(D36,$B$36:$P$36,1)","v":3},null,{"$f":"RANK(F36,$B$36:$P$36,1)","v":4},null,{"$f":"RANK(H36,$B$36:$P$36,1)","v":1},null,{"$f":"RANK(J36,$B$36:$P$36,1)","v":6},null,{"$f":"RANK(L36,$B$36:$P$36,1)","v":8},null,{"$f":"RANK(N36,$B$36:$P$36,1)","v":5},null,{"$f":"RANK(P36,$B$36:$P$36,1)","v":2}]
[]
[null,{"$f":"B5","v":"2. Range en ordre décroissant. Ecris sous chaque nombre son n° d'ordre.    … / 8"}]
[null,710511,"-",682335,"-",891625,"-",482818,"-",586032,"-",760571,"-",922141,"-",549146]
[null,{"$f":"RANK(B40,$B$40:$P$40,0)","v":4},null,{"$f":"RANK(D40,$B$40:$P$40,0)","v":5},null,{"$f":"RANK(F40,$B$40:$P$40,0)","v":2},null,{"$f":"RANK(H40,$B$40:$P$40,0)","v":8},null,{"$f":"RANK(J40,$B$40:$P$40,0)","v":6},null,{"$f":"RANK(L40,$B$40:$P$40,0)","v":3},null,{"$f":"RANK(N40,$B$40:$P$40,0)","v":1},null,{"$f":"RANK(P40,$B$40:$P$40,0)","v":7}]
[]
[null,{"$f":"B9","v":"3. Compare.    … / 8"}]
[null,{"$f":"B10","v":934523},{"$f":"IF(B44<D44,\"<\",\">\")","v":">"},{"$f":"D10","v":771926},null,{"$f":"F10","v":987533},{"$f":"IF(F44<H44,\"<\",\">\")","v":">"},{"$f":"H10","v":432475},null,{"$f":"J10","v":644319},{"$f":"IF(J44<L44,\"<\",\">\")","v":">"},{"$f":"L10","v":540073},null,{"$f":"N10","v":810140},{"$f":"IF(N44<P44,\"<\",\">\")","v":"<"},{"$f":"P10","v":942365}]
[]
[null,{"$f":"B12","v":664272},{"$f":"IF(B46<D46,\"<\",\">\")","v":"<"},894629,null,937911,{"$f":"IF(F46<H46,\"<\",\">\")","v":">"},841235,null,456031,{"$f":"IF(J46<L46,\"<\",\">\")","v":">"},450153,null,928780,{"$f":"IF(N46<P46,\"<\",\">\")","v":">"},756946]
[]
[null,{"$f":"B14","v":"4. Continue la série.   … / 3"}]
[null,{"$f":"B15","v":563360},{"$f":"C15","v":"-"},{"$f":"D15","v":564360},{"$f":"E15","v":"-"},{"$f":"D49+$S$15","v":565360},{"$f":"G15","v":"-"},{"$f":"F49+$S$15","v":566360},{"$f":"I15","v":"-"},{"$f":"H49+$S$15","v":567360},{"$f":"K15","v":"-"},{"$f":"J49+$S$15","v":568360},{"$f":"M15","v":"-"},{"$f":"L49+$S$15","v":569360},{"$f":"O15","v":"-"},{"$f":"N49+$S$15","v":570360}]
[]
[null,{"$f":"B17","v":"5. Continue la série.   … / 3"}]
[null,{"$f":"B18","v":819449},{"$f":"C18","v":"-"},{"$f":"D18","v":809449},{"$f":"E18","v":"-"},{"$f":"D52+$S$18","v":819449},{"$f":"G18","v":"-"},{"$f":"F52-$S$18","v":809449},{"$f":"I18","v":"-"},{"$f":"H52-$S$18","v":799449},{"$f":"K18","v":"-"},{"$f":"J52-$S$18","v":789449},{"$f":"M18","v":"-"},{"$f":"L52-$S$18","v":779449},{"$f":"O18","v":"-"},{"$f":"N52-$S$18","v":769449}]
[]
[null,{"$f":"B20","v":"6. Ecris en chiffres. … / 4"}]
[null,{"$f":"CONCATENATE(B21,TEXT(S21,\"### ##0\"))","v":"cinq cent vingt-deux mille cent dix-sept  →522 117"}]
[null,{"$f":"CONCATENATE(B22,TEXT(S22,\"### ##0\"))","v":"neuf cent vingt-huit mille neuf cent cinquante-et-un  →928 951"}]
[null,{"$f":"CONCATENATE(B23,TEXT(S23,\"### ##0\"))","v":"neuf cent vingt mille sept cent quatre-vingt-treize  →920 793"}]
[null,{"$f":"CONCATENATE(B24,TEXT(S24,\"### ##0\"))","v":"sept cent quatre-vingt-sept mille cent trois  →787 103"}]
[null,{"$f":"B25","v":"7. Encadre à la dizaine près.   … / 8"}]
[null,null,null,{"$f":"INT(F26/$U$26)*$U$26","v":572180},{"$f":"E26","v":"<"},{"$f":"F26","v":572187},{"$f":"G26","v":"<"},{"$f":"D60+$U$26","v":572190},null,null,null,{"$f":"INT(N26/$U$26)*$U$26","v":714170},{"$f":"M26","v":"<"},{"$f":"N26","v":714172},{"$f":"O26","v":"<"},{"$f":"L60+$U$26","v":714180}]
[]
[null,null,null,{"$f":"INT(F28/$U$26)*$U$26","v":853270},{"$f":"E28","v":"<"},{"$f":"F28","v":853275},{"$f":"G28","v":"<"},{"$f":"D62+$U$26","v":853280},null,null,null,{"$f":"INT(N28/$U$26)*$U$26","v":925860},{"$f":"M28","v":"<"},{"$f":"N28","v":925864},{"$f":"O28","v":"<"},{"$f":"L62+$U$26","v":925870}]
[]
[null,{"$f":"B30","v":"8. Arrondis à la dizaine  la plus proche.   … / 8"}]
[null,{"$f":"B31","v":795106},"®",{"$f":"ROUND(B65,-LOG($U$31))","v":795110},null,{"$f":"F31","v":979242},"®",{"$f":"ROUND(F65,-LOG($U$31))","v":979240},null,{"$f":"J31","v":722540},"®",{"$f":"ROUND(J65,-LOG($U$31))","v":722540},null,{"$f":"N31","v":568726},"®",{"$f":"ROUND(N65,-LOG($U$31))","v":568730}]
[]
[null,{"$f":"B33","v":480978},"®",{"$f":"ROUND(B67,-LOG($U$31))","v":480980},null,{"$f":"F33","v":468952},"®",{"$f":"ROUND(F67,-LOG($U$31))","v":468950},null,{"$f":"J33","v":629034},"®",{"$f":"ROUND(J67,-LOG($U$31))","v":629030},null,{"$f":"N33","v":946381},"®",{"$f":"ROUND(N67,-LOG($U$31))","v":946380}]

{"sheet":"plages","index":2,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[1,"à l'unité",null,1,"à l'unité"]
[10,"à la dizaine",null,0.1,"au dixième"]
[100,"à la centaine",null,0.01,"au centième"]
[1000,"à l'unité de mille"]
[10000,"à la dizaine de mille"]
[100000,"à la centaine de mille"]
[1000000,"à l'unité de millions"]
[10000000,"à la dizaine de millions"]
[100000000,"à la centaine de millions"]
[]
[]
[]
[]
[]
[]
["ConvNumberLetter()",480000400,"quatre cent quatre-vingts millions et quatre cents"]
["chiffrelettre()",480000400,{"$f":"chiffrelettre(B17)","v":"quatre cent quatre-vingts millions quatre cents Euros "}]
["NumText()",480000400,{"$f":"NumText(B18)","v":"quatre cent quatre-vingts millions quatre cents  "}]
["ConvNumberLetter()",76.58,"soixante-seize virgule cinquante-huit"]
["chiffrelettre()",76.58,{"$f":"chiffrelettre(B20)","v":"soixante seize Euros cinquante huit centimes"}]
["NumText()",76.58,{"$f":"NumText(B21)","v":"soixante-seize  "}]
["ConvNumberLetter()",800.8,"huit cents virgule quatre-vingts"]
["chiffrelettre()",800.8,{"$f":"chiffrelettre(B23)","v":"huit cents Euros quatre-vingts centimes"}]
["NumText()",800.8,{"$f":"NumText(B24)","v":"huit cents  "}]
["ConvNumberLetter()",480000400,"quatre cent quatre-vingts millions et quatre cents"]
["chiffrelettre()",480000400,{"$f":"chiffrelettre(B26)","v":"quatre cent quatre-vingts millions quatre cents Euros "}]
["NumText()",480000400,{"$f":"NumText(B27)","v":"quatre cent quatre-vingts millions quatre cents  "}]
["ConvNumberLetter()",480000400,"quatre cent quatre-vingts millions et quatre cents"]
["chiffrelettre()",480000400,{"$f":"chiffrelettre(B29)","v":"quatre cent quatre-vingts millions quatre cents Euros "}]
["NumText()",480000400,{"$f":"NumText(B30)","v":"quatre cent quatre-vingts millions quatre cents  "}]
["ConvNumberLetter()",480000400,"quatre cent quatre-vingts millions et quatre cents"]