{"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],[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],[4,17,4,19]]}
[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",676,null,"EFFECTUER LE REGLAGE SUIVANT DANS LES OPTIONS EXCEL."]
[null,{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":14.741},"-",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":27.753},"-",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":27.06},"-",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":9.1969999999999992},"-",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":18.873000000000001},"-",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":3.2770000000000001},"-",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":27.113},"-",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":3.3820000000000001},1,"min",3,null,3,"chiffres\naprès la virgule"]
[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":21.161000000000001},"-",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":13.198},"-",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":17.006},"-",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":24.914999999999999},"-",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":10.15},"-",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":7.67},"-",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":7.2779999999999996},"-",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":29.936}]
[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":14.343},"…",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":23.277000000000001},null,{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":28.021999999999998},"…",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":21.631},null,{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":28.611000000000001},"…",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":19.189},null,{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":24.661999999999999},"…",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":25.352},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":20.766999999999999},"…",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":11.689},null,{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":14.657},"…",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":16.533000000000001},null,{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":7.0439999999999996},"…",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":10.097},null,{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":21.216999999999999},"…",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":4.117},null,5]
[]
[null,"4. Continue la série.   … / 3"]
[null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":28},"-",{"$f":"B15+S15","v":28.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":22},"-",{"$f":"B18-S18","v":21.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":"trois virgule neuf cent cinquante-six  →"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":3.956},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-sept virgule six cent quatorze  →"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":27.614000000000001},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."]
[null,"vingt-sept virgule six cent vingt-quatre  →",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27.623999999999999,null,null,null,"On ne peut pas arrondir au centième si on a demandé des nombres en dixièmes… par exemple."]
[null,"dix-sept virgule zéro quatre-vingt-dix-huit  →",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17.097999999999999]
[null,{"$f":" CONCATENATE(\"7. Encadre \",U27,\" près.   … / 8\")","v":"7. Encadre à l'unité près.   … / 8"}]
[null,null,null,"……….","<",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":12.387},"<","……….",null,null,null,"……….","<",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":13.422000000000001},"<","……….",null,4,null,null,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":"à l'unité"}]
[null,null,null,"……….","<",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":5.0350000000000001},"<","……….",null,null,null,"……….","<",{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":23.050999999999998},"<","………."]
[]
[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":15.773},"®","……….",null,{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":27.097000000000001},"®","……….",null,{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":4.4409999999999998},"®","……….",null,{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":22.556999999999999},"®","……….",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":7.4779999999999998},"®","……….",null,{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":28.318000000000001},"®","……….",null,{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":10.146000000000001},"®","……….",null,{"$f":"RANDBETWEEN($S$2,$S$3)+RAND()","v":26.783000000000001},"®","………."]
[]
[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,14.741,"-",27.753,"-",27.06,"-",9.1969999999999992,"-",18.873000000000001,"-",3.2770000000000001,"-",27.113,"-",3.3820000000000001]
[null,{"$f":"RANK(B36,$B$36:$P$36,1)","v":4},null,{"$f":"RANK(D36,$B$36:$P$36,1)","v":8},null,{"$f":"RANK(F36,$B$36:$P$36,1)","v":6},null,{"$f":"RANK(H36,$B$36:$P$36,1)","v":3},null,{"$f":"RANK(J36,$B$36:$P$36,1)","v":5},null,{"$f":"RANK(L36,$B$36:$P$36,1)","v":1},null,{"$f":"RANK(N36,$B$36:$P$36,1)","v":7},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,21.161000000000001,"-",13.198,"-",17.006,"-",24.914999999999999,"-",10.15,"-",7.67,"-",7.2779999999999996,"-",29.936]
[null,{"$f":"RANK(B40,$B$40:$P$40,0)","v":3},null,{"$f":"RANK(D40,$B$40:$P$40,0)","v":5},null,{"$f":"RANK(F40,$B$40:$P$40,0)","v":4},null,{"$f":"RANK(H40,$B$40:$P$40,0)","v":2},null,{"$f":"RANK(J40,$B$40:$P$40,0)","v":6},null,{"$f":"RANK(L40,$B$40:$P$40,0)","v":7},null,{"$f":"RANK(N40,$B$40:$P$40,0)","v":8},null,{"$f":"RANK(P40,$B$40:$P$40,0)","v":1}]
[]
[null,{"$f":"B9","v":"3. Compare.    … / 8"}]
[null,{"$f":"B10","v":14.343},{"$f":"IF(B44<D44,\"<\",\">\")","v":"<"},{"$f":"D10","v":23.277000000000001},null,{"$f":"F10","v":28.021999999999998},{"$f":"IF(F44<H44,\"<\",\">\")","v":">"},{"$f":"H10","v":21.631},null,{"$f":"J10","v":28.611000000000001},{"$f":"IF(J44<L44,\"<\",\">\")","v":">"},{"$f":"L10","v":19.189},null,{"$f":"N10","v":24.661999999999999},{"$f":"IF(N44<P44,\"<\",\">\")","v":"<"},{"$f":"P10","v":25.352}]
[]
[null,{"$f":"B12","v":20.766999999999999},{"$f":"IF(B46<D46,\"<\",\">\")","v":">"},11.689,null,14.657,{"$f":"IF(F46<H46,\"<\",\">\")","v":"<"},16.533000000000001,null,7.0439999999999996,{"$f":"IF(J46<L46,\"<\",\">\")","v":"<"},10.097,null,21.216999999999999,{"$f":"IF(N46<P46,\"<\",\">\")","v":">"},4.117]
[]
[null,{"$f":"B14","v":"4. Continue la série.   … / 3"}]
[null,{"$f":"B15","v":28},{"$f":"C15","v":"-"},{"$f":"D15","v":28.3},{"$f":"E15","v":"-"},{"$f":"D49+$S$15","v":28.6},{"$f":"G15","v":"-"},{"$f":"F49+$S$15","v":28.9},{"$f":"I15","v":"-"},{"$f":"H49+$S$15","v":29.2},{"$f":"K15","v":"-"},{"$f":"J49+$S$15","v":29.5},{"$f":"M15","v":"-"},{"$f":"L49+$S$15","v":29.8},{"$f":"O15","v":"-"},{"$f":"N49+$S$15","v":30.1}]
[]
[null,{"$f":"B17","v":"5. Continue la série.   … / 3"}]
[null,{"$f":"B18","v":22},{"$f":"C18","v":"-"},{"$f":"D18","v":21.5},{"$f":"E18","v":"-"},{"$f":"D52+$S$18","v":22},{"$f":"G18","v":"-"},{"$f":"F52-$S$18","v":21.5},{"$f":"I18","v":"-"},{"$f":"H52-$S$18","v":21},{"$f":"K18","v":"-"},{"$f":"J52-$S$18","v":20.5},{"$f":"M18","v":"-"},{"$f":"L52-$S$18","v":20},{"$f":"O18","v":"-"},{"$f":"N52-$S$18","v":19.5}]
[]
[null,{"$f":"B20","v":"6. Ecris en chiffres. … / 4"}]
[null,{"$f":"CONCATENATE(B21,\" \",TEXT(S21,\"###, ###\"))","v":"trois virgule neuf cent cinquante-six  → 3,956"}]
[null,{"$f":"CONCATENATE(B22,\" \",TEXT(S22,\"###, ###\"))","v":"vingt-sept virgule six cent quatorze  → 27,614"}]
[null,{"$f":"CONCATENATE(B23,\" \",TEXT(S23,\"###, ###\"))","v":"vingt-sept virgule six cent vingt-quatre  → 27,624"}]
[null,{"$f":"CONCATENATE(B24,\" \",TEXT(S24,\"###, ###\"))","v":"dix-sept virgule zéro quatre-vingt-dix-huit  → 17,098"}]
[null,{"$f":"B25","v":"7. Encadre à l'unité près.   … / 8"}]
[null,null,null,{"$f":"INT(F26/$U$26)*$U$26","v":12},{"$f":"E26","v":"<"},{"$f":"F26","v":12.387},{"$f":"G26","v":"<"},{"$f":"D60+$U$26","v":13},null,null,null,{"$f":"INT(N26/$U$26)*$U$26","v":13},{"$f":"M26","v":"<"},{"$f":"N26","v":13.422000000000001},{"$f":"O26","v":"<"},{"$f":"L60+$U$26","v":14}]
[]
[null,null,null,{"$f":"INT(F28/$U$26)*$U$26","v":5},{"$f":"E28","v":"<"},{"$f":"F28","v":5.0350000000000001},{"$f":"G28","v":"<"},{"$f":"D62+$U$26","v":6},null,null,null,{"$f":"INT(N28/$U$26)*$U$26","v":23},{"$f":"M28","v":"<"},{"$f":"N28","v":23.050999999999998},{"$f":"O28","v":"<"},{"$f":"L62+$U$26","v":24}]
[]
[null,{"$f":"B30","v":"8. Arrondis au dixième le plus proche.   … / 8"}]
[null,{"$f":"B31","v":15.773},"®",{"$f":"ROUND(B65,-LOG($U$31))","v":15.8},null,{"$f":"F31","v":27.097000000000001},"®",{"$f":"ROUND(F65,-LOG($U$31))","v":27.1},null,{"$f":"J31","v":4.4409999999999998},"®",{"$f":"ROUND(J65,-LOG($U$31))","v":4.4000000000000004},null,{"$f":"N31","v":22.556999999999999},"®",{"$f":"ROUND(N65,-LOG($U$31))","v":22.6}]
[]
[null,{"$f":"B33","v":7.4779999999999998},"®",{"$f":"ROUND(B67,-LOG($U$31))","v":7.5},null,{"$f":"F33","v":28.318000000000001},"®",{"$f":"ROUND(F67,-LOG($U$31))","v":28.3},null,{"$f":"J33","v":10.146000000000001},"®",{"$f":"ROUND(J67,-LOG($U$31))","v":10.1},null,{"$f":"N33","v":26.783000000000001},"®",{"$f":"ROUND(N67,-LOG($U$31))","v":26.8}]

{"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":739767},"-",{"$f":"RANDBETWEEN($S$2,$S$3)","v":605145},"-",{"$f":"RANDBETWEEN($S$2,$S$3)","v":876734},"-",{"$f":"RANDBETWEEN($S$2,$S$3)","v":639581},"-",{"$f":"RANDBETWEEN($S$2,$S$3)","v":869900},"-",{"$f":"RANDBETWEEN($S$2,$S$3)","v":548693},"-",{"$f":"RANDBETWEEN($S$2,$S$3)","v":415216},"-",{"$f":"RANDBETWEEN($S$2,$S$3)","v":602717},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":756998},"-",{"$f":"RANDBETWEEN($S$2,$S$3)","v":838808},"-",{"$f":"RANDBETWEEN($S$2,$S$3)","v":935069},"-",{"$f":"RANDBETWEEN($S$2,$S$3)","v":721445},"-",{"$f":"RANDBETWEEN($S$2,$S$3)","v":420816},"-",{"$f":"RANDBETWEEN($S$2,$S$3)","v":467000},"-",{"$f":"RANDBETWEEN($S$2,$S$3)","v":546131},"-",{"$f":"RANDBETWEEN($S$2,$S$3)","v":451426}]
[null,"……….",null,"……….",null,"……….",null,"……….",null,"……….",null,"……….",null,"……….",null,"………."]
[]
[null,"3. Compare.    … / 8"]
[null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":505932},"…",{"$f":"RANDBETWEEN($S$2,$S$3)","v":837926},null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":690374},"…",{"$f":"RANDBETWEEN($S$2,$S$3)","v":966356},null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":819742},"…",{"$f":"RANDBETWEEN($S$2,$S$3)","v":725485},null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":978961},"…",{"$f":"RANDBETWEEN($S$2,$S$3)","v":703625}]
[]
[null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":810891},"…",{"$f":"RANDBETWEEN($S$2,$S$3)","v":677639},null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":894973},"…",{"$f":"RANDBETWEEN($S$2,$S$3)","v":956054},null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":687866},"…",{"$f":"RANDBETWEEN($S$2,$S$3)","v":439968},null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":615699},"…",{"$f":"RANDBETWEEN($S$2,$S$3)","v":775519}]
[]
[null,"4. Continue la série.   … / 3"]
[null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":574143},"-",{"$f":"B15+S15","v":575143},"-","……….","-","……….","-","……….","-","……….","-","……….","-","……….",null,"pas",1000]
[]
[null,"5. Continue la série.   … / 3"]
[null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":445964},"-",{"$f":"B18-S18","v":435964},"-","……….","-","……….","-","……….","-","……….","-","……….","-","……….",null,"pas",10000]
[]
[null,"6. Ecris en chiffres. … / 4"]
[null,{"$f":"CONCATENATE(NumText(S21), \"→\")","v":"neuf cent soixante-et-onze mille cinquante-trois  →"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":971053}]
[null,{"$f":"CONCATENATE(NumText(S22), \"→\")","v":"huit cent trois mille quatre cent seize  →"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":803416}]
[null,{"$f":"CONCATENATE(NumText(S23), \"→\")","v":"quatre cent vingt-trois mille neuf 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)","v":423918}]
[null,{"$f":"CONCATENATE(NumText(S24), \"→\")","v":"sept cent treize mille deux cent quatre-vingt-six  →"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":713286}]
[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":721207},"<","……….",null,null,null,"……….","<",{"$f":"RANDBETWEEN($S$2,$S$3)","v":973646},"<","……….",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":768353},"<","……….",null,null,null,"……….","<",{"$f":"RANDBETWEEN($S$2,$S$3)","v":734863},"<","………."]
[]
[null,{"$f":" CONCATENATE(\"8. Arrondis \",U32,\"  la plus proche.   … / 8\")","v":"8. Arrondis à la centaine de mille  la plus proche.   … / 8"}]
[null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":773334},"®","……….",null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":472461},"®","……….",null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":603670},"®","……….",null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":680371},"®","……….",8,null,null,null,100000]
[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 centaine de mille"}]
[null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":446484},"®","……….",null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":776317},"®","……….",null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":687456},"®","……….",null,{"$f":"RANDBETWEEN($S$2,$S$3)","v":771971},"®","………."]
[]
[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,739767,"-",605145,"-",876734,"-",639581,"-",869900,"-",548693,"-",415216,"-",602717]
[null,{"$f":"RANK(B36,$B$36:$P$36,1)","v":6},null,{"$f":"RANK(D36,$B$36:$P$36,1)","v":4},null,{"$f":"RANK(F36,$B$36:$P$36,1)","v":8},null,{"$f":"RANK(H36,$B$36:$P$36,1)","v":5},null,{"$f":"RANK(J36,$B$36:$P$36,1)","v":7},null,{"$f":"RANK(L36,$B$36:$P$36,1)","v":2},null,{"$f":"RANK(N36,$B$36:$P$36,1)","v":1},null,{"$f":"RANK(P36,$B$36:$P$36,1)","v":3}]
[]
[null,{"$f":"B5","v":"2. Range en ordre décroissant. Ecris sous chaque nombre son n° d'ordre.    … / 8"}]
[null,756998,"-",838808,"-",935069,"-",721445,"-",420816,"-",467000,"-",546131,"-",451426]
[null,{"$f":"RANK(B40,$B$40:$P$40,0)","v":3},null,{"$f":"RANK(D40,$B$40:$P$40,0)","v":2},null,{"$f":"RANK(F40,$B$40:$P$40,0)","v":1},null,{"$f":"RANK(H40,$B$40:$P$40,0)","v":4},null,{"$f":"RANK(J40,$B$40:$P$40,0)","v":8},null,{"$f":"RANK(L40,$B$40:$P$40,0)","v":6},null,{"$f":"RANK(N40,$B$40:$P$40,0)","v":5},null,{"$f":"RANK(P40,$B$40:$P$40,0)","v":7}]
[]
[null,{"$f":"B9","v":"3. Compare.    … / 8"}]
[null,{"$f":"B10","v":505932},{"$f":"IF(B44<D44,\"<\",\">\")","v":"<"},{"$f":"D10","v":837926},null,{"$f":"F10","v":690374},{"$f":"IF(F44<H44,\"<\",\">\")","v":"<"},{"$f":"H10","v":966356},null,{"$f":"J10","v":819742},{"$f":"IF(J44<L44,\"<\",\">\")","v":">"},{"$f":"L10","v":725485},null,{"$f":"N10","v":978961},{"$f":"IF(N44<P44,\"<\",\">\")","v":">"},{"$f":"P10","v":703625}]
[]
[null,{"$f":"B12","v":810891},{"$f":"IF(B46<D46,\"<\",\">\")","v":">"},677639,null,894973,{"$f":"IF(F46<H46,\"<\",\">\")","v":"<"},956054,null,687866,{"$f":"IF(J46<L46,\"<\",\">\")","v":">"},439968,null,615699,{"$f":"IF(N46<P46,\"<\",\">\")","v":"<"},775519]
[]
[null,{"$f":"B14","v":"4. Continue la série.   … / 3"}]
[null,{"$f":"B15","v":574143},{"$f":"C15","v":"-"},{"$f":"D15","v":575143},{"$f":"E15","v":"-"},{"$f":"D49+$S$15","v":576143},{"$f":"G15","v":"-"},{"$f":"F49+$S$15","v":577143},{"$f":"I15","v":"-"},{"$f":"H49+$S$15","v":578143},{"$f":"K15","v":"-"},{"$f":"J49+$S$15","v":579143},{"$f":"M15","v":"-"},{"$f":"L49+$S$15","v":580143},{"$f":"O15","v":"-"},{"$f":"N49+$S$15","v":581143}]
[]
[null,{"$f":"B17","v":"5. Continue la série.   … / 3"}]
[null,{"$f":"B18","v":445964},{"$f":"C18","v":"-"},{"$f":"D18","v":435964},{"$f":"E18","v":"-"},{"$f":"D52+$S$18","v":445964},{"$f":"G18","v":"-"},{"$f":"F52-$S$18","v":435964},{"$f":"I18","v":"-"},{"$f":"H52-$S$18","v":425964},{"$f":"K18","v":"-"},{"$f":"J52-$S$18","v":415964},{"$f":"M18","v":"-"},{"$f":"L52-$S$18","v":405964},{"$f":"O18","v":"-"},{"$f":"N52-$S$18","v":395964}]
[]
[null,{"$f":"B20","v":"6. Ecris en chiffres. … / 4"}]
[null,{"$f":"CONCATENATE(B21,TEXT(S21,\"### ##0\"))","v":"neuf cent soixante-et-onze mille cinquante-trois  →971 053"}]
[null,{"$f":"CONCATENATE(B22,TEXT(S22,\"### ##0\"))","v":"huit cent trois mille quatre cent seize  →803 416"}]
[null,{"$f":"CONCATENATE(B23,TEXT(S23,\"### ##0\"))","v":"quatre cent vingt-trois mille neuf cent dix-huit  →423 918"}]
[null,{"$f":"CONCATENATE(B24,TEXT(S24,\"### ##0\"))","v":"sept cent treize mille deux cent quatre-vingt-six  →713 286"}]
[null,{"$f":"B25","v":"7. Encadre à la dizaine près.   … / 8"}]
[null,null,null,{"$f":"INT(F26/$U$26)*$U$26","v":721200},{"$f":"E26","v":"<"},{"$f":"F26","v":721207},{"$f":"G26","v":"<"},{"$f":"D60+$U$26","v":721210},null,null,null,{"$f":"INT(N26/$U$26)*$U$26","v":973640},{"$f":"M26","v":"<"},{"$f":"N26","v":973646},{"$f":"O26","v":"<"},{"$f":"L60+$U$26","v":973650}]
[]
[null,null,null,{"$f":"INT(F28/$U$26)*$U$26","v":768350},{"$f":"E28","v":"<"},{"$f":"F28","v":768353},{"$f":"G28","v":"<"},{"$f":"D62+$U$26","v":768360},null,null,null,{"$f":"INT(N28/$U$26)*$U$26","v":734860},{"$f":"M28","v":"<"},{"$f":"N28","v":734863},{"$f":"O28","v":"<"},{"$f":"L62+$U$26","v":734870}]
[]
[null,{"$f":"B30","v":"8. Arrondis à la centaine de mille  la plus proche.   … / 8"}]
[null,{"$f":"B31","v":773334},"®",{"$f":"ROUND(B65,-LOG($U$31))","v":800000},null,{"$f":"F31","v":472461},"®",{"$f":"ROUND(F65,-LOG($U$31))","v":500000},null,{"$f":"J31","v":603670},"®",{"$f":"ROUND(J65,-LOG($U$31))","v":600000},null,{"$f":"N31","v":680371},"®",{"$f":"ROUND(N65,-LOG($U$31))","v":700000}]
[]
[null,{"$f":"B33","v":446484},"®",{"$f":"ROUND(B67,-LOG($U$31))","v":400000},null,{"$f":"F33","v":776317},"®",{"$f":"ROUND(F67,-LOG($U$31))","v":800000},null,{"$f":"J33","v":687456},"®",{"$f":"ROUND(J67,-LOG($U$31))","v":700000},null,{"$f":"N33","v":771971},"®",{"$f":"ROUND(N67,-LOG($U$31))","v":800000}]

{"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"]