{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["5 exo différents","5 exo différents (double)","5 exo différents (triple)","5 exo différents (quadruple)","5 exos identiques","5 exos différents type mélangé","5 exos différents type méla (2)","Formules"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"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":"5 exo différents","index":0,"n_rows":44,"n_cols":14,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,0,0,7],[0,8,0,17],[28,0,28,3],[28,8,28,9],[37,0,37,3],[37,8,37,9],[1,12,1,13],[10,12,10,13],[19,12,19,13],[28,12,28,13],[37,12,37,13],[1,0,1,3],[1,8,1,9],[10,0,10,3],[10,8,10,9],[19,0,19,3],[19,8,19,9]]}
["SAVOIR UTILISER LES MOTS  MOITIE / DOUBLE - TIERS / TRIPLE - QUART / QUADRUPLE",null,null,null,null,null,null,null,"Ne modifier que les cellules en violet en faisant attention à ce que la borne inf soit inférieure à la borne sup."]
["A. Complète :",null,null,null,null,null,null,null,"Bornes",null,null,null,"Bornes"]
[null,null,null,null,null,null,null,null,"inf","sup",null,null,"inf","sup"]
["a) ",{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quelle est la moitié de \",\"Quel est le tiers de \",\"Quel est le quart de \") & (RANDBETWEEN(I4,J4)*12) & \" ? \"","v":"Quelle est la moitié de 12 ? "},"→","…………………","f) ",{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quelle est la moitié de \",\"Quel est le tiers de \",\"Quel est le quart de \") & (RANDBETWEEN(M4,N4)*12) & \" ? \"","v":"Quel est le tiers de 120 ? "},{"$f":"C4","v":"→"},"…………………",1,2,null,null,9,10]
["b) ",{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quelle est la moitié de \",\"Quel est le tiers de \",\"Quel est le quart de \") & (RANDBETWEEN(I5,J5)*12) & \" ? \"","v":"Quelle est la moitié de 36 ? "},"→","…………………","g) ",{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quelle est la moitié de \",\"Quel est le tiers de \",\"Quel est le quart de \") & (RANDBETWEEN(M5,N5)*12) & \" ? \"","v":"Quel est le tiers de 84 ? "},{"$f":"C5","v":"→"},"…………………",3,4,null,null,7,8]
["c) ",{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quelle est la moitié de \",\"Quel est le tiers de \",\"Quel est le quart de \") & (RANDBETWEEN(I6,J6)*12) & \" ? \"","v":"Quel est le quart de 60 ? "},"→","…………………","h) ","Quelle est la moitié de 84 ? ","→","…………………",5,6,null,null,6,7]
["d) ",{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quelle est la moitié de \",\"Quel est le tiers de \",\"Quel est le quart de \") & (RANDBETWEEN(I7,J7)*12) & \" ? \"","v":"Quel est le quart de 96 ? "},"→","…………………","i) ","Quel est le quart de 60 ? ","→","…………………",7,8,null,null,5,6]
["e) ",{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quelle est la moitié de \",\"Quel est le tiers de \",\"Quel est le quart de \") & (RANDBETWEEN(I8,J8)*12) & \" ? \"","v":"Quelle est la moitié de 108 ? "},"→","…………………","j) ","Quel est le tiers de 48 ? ","→","…………………",9,10,null,null,4,5]
[]
[]
["B. Complète :",null,null,null,null,null,null,null,"Bornes",null,null,null,"Bornes"]
[null,null,null,null,null,null,null,null,"inf","sup",null,null,"inf","sup"]
[{"$f":"A4","v":"a) "},{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quel est le double de \",\"Quel est le triple de \",\"Quel est le quadruple de \") & (RANDBETWEEN(I13,J13)*12) & \" ? \"","v":"Quel est le quadruple de 12 ? "},"→","…………………",{"$f":"E4","v":"f) "},{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quel est le double de \",\"Quel est le triple de \",\"Quel est le quadruple de \") & (RANDBETWEEN(M13,N13)*12) & \" ? \"","v":"Quel est le double de 108 ? "},{"$f":"C13","v":"→"},"…………………",1,2,null,null,9,10]
["b) ",{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quel est le double de \",\"Quel est le triple de \",\"Quel est le quadruple de \") & (RANDBETWEEN(I14,J14)*12) & \" ? \"","v":"Quel est le double de 36 ? "},"→","…………………","g) ",{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quel est le double de \",\"Quel est le triple de \",\"Quel est le quadruple de \") & (RANDBETWEEN(M14,N14)*12) & \" ? \"","v":"Quel est le quadruple de 96 ? "},{"$f":"C14","v":"→"},"…………………",3,4,null,null,7,8]
["c) ",{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quel est le double de \",\"Quel est le triple de \",\"Quel est le quadruple de \") & (RANDBETWEEN(I15,J15)*12) & \" ? \"","v":"Quel est le triple de 72 ? "},"→","…………………","h) ",{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quel est le double de \",\"Quel est le triple de \",\"Quel est le quadruple de \") & (RANDBETWEEN(M15,N15)*12) & \" ? \"","v":"Quel est le double de 84 ? "},"→","…………………",5,6,null,null,6,7]
["d) ",{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quel est le double de \",\"Quel est le triple de \",\"Quel est le quadruple de \") & (RANDBETWEEN(I16,J16)*12) & \" ? \"","v":"Quel est le double de 96 ? "},"→","…………………","i) ",{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quel est le double de \",\"Quel est le triple de \",\"Quel est le quadruple de \") & (RANDBETWEEN(M16,N16)*12) & \" ? \"","v":"Quel est le triple de 60 ? "},"→","…………………",7,8,null,null,5,6]
["e) ",{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quel est le double de \",\"Quel est le triple de \",\"Quel est le quadruple de \") & (RANDBETWEEN(I17,J17)*12) & \" ? \"","v":"Quel est le double de 108 ? "},"→","…………………","j) ",{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quel est le double de \",\"Quel est le triple de \",\"Quel est le quadruple de \") & (RANDBETWEEN(M17,N17)*12) & \" ? \"","v":"Quel est le triple de 60 ? "},"→","…………………",9,10,null,null,4,5]
[]
[]
["C. Complète :",null,null,null,null,null,null,null,"Bornes",null,null,null,"Bornes"]
[null,null,null,null,null,null,null,null,"inf","sup",null,null,"inf","sup"]
[{"$f":"A4","v":"a) "},{"$f":" (RANDBETWEEN(I22,J22)*12) & CHOOSE(INT(RAND()*3)+1,\" est la moitié de ?  \",\" est le tiers de ?  \",\" est le quart de ?  \")","v":"24 est la moitié de ?  "},"→","…………………",{"$f":"E4","v":"f) "},{"$f":" (RANDBETWEEN(M22,N22)*12) & CHOOSE(INT(RAND()*3)+1,\" est la moitié de ?  \",\" est le tiers de ?  \",\" est le quart de ?  \")","v":"108 est le tiers de ?  "},{"$f":"C22","v":"→"},"…………………",1,2,null,null,9,10]
["b) ",{"$f":" (RANDBETWEEN(I23,J23)*12) & CHOOSE(INT(RAND()*3)+1,\" est la moitié de ?  \",\" est le tiers de ?  \",\" est le quart de ?  \")","v":"36 est la moitié de ?  "},"→","…………………","g) ",{"$f":" (RANDBETWEEN(M23,N23)*12) & CHOOSE(INT(RAND()*3)+1,\" est la moitié de ?  \",\" est le tiers de ?  \",\" est le quart de ?  \")","v":"96 est la moitié de ?  "},{"$f":"C23","v":"→"},"…………………",3,4,null,null,7,8]
["c) ",{"$f":" (RANDBETWEEN(I24,J24)*12) & CHOOSE(INT(RAND()*3)+1,\" est la moitié de ?  \",\" est le tiers de ?  \",\" est le quart de ?  \")","v":"72 est le tiers de ?  "},"→","…………………","h) ",{"$f":" (RANDBETWEEN(M24,N24)*12) & CHOOSE(INT(RAND()*3)+1,\" est la moitié de ?  \",\" est le tiers de ?  \",\" est le quart de ?  \")","v":"72 est le quart de ?  "},"→","…………………",5,6,null,null,6,7]
["d) ",{"$f":" (RANDBETWEEN(I25,J25)*12) & CHOOSE(INT(RAND()*3)+1,\" est la moitié de ?  \",\" est le tiers de ?  \",\" est le quart de ?  \")","v":"96 est le tiers de ?  "},"→","…………………","i) ",{"$f":" (RANDBETWEEN(M25,N25)*12) & CHOOSE(INT(RAND()*3)+1,\" est la moitié de ?  \",\" est le tiers de ?  \",\" est le quart de ?  \")","v":"72 est le quart de ?  "},"→","…………………",7,8,null,null,5,6]
["e) ",{"$f":" (RANDBETWEEN(I26,J26)*12) & CHOOSE(INT(RAND()*3)+1,\" est la moitié de ?  \",\" est le tiers de ?  \",\" est le quart de ?  \")","v":"108 est le tiers de ?  "},"→","…………………","j) ",{"$f":" (RANDBETWEEN(M26,N26)*12) & CHOOSE(INT(RAND()*3)+1,\" est la moitié de ?  \",\" est le tiers de ?  \",\" est le quart de ?  \")","v":"48 est la moitié de ?  "},"→","…………………",9,10,null,null,4,5]
[]
[]
["D. Complète :",null,null,null,null,null,null,null,"Bornes",null,null,null,"Bornes"]
[null,null,null,null,null,null,null,null,"inf","sup",null,null,"inf","sup"]
[{"$f":"A4","v":"a) "},{"$f":" (RANDBETWEEN(I31,J31)*12) & CHOOSE(INT(RAND()*3)+1,\" est le double de ?  \",\" est le triple de ?  \",\" est le quadruple de ?  \")","v":"24 est le triple de ?  "},"→","…………………",{"$f":"E4","v":"f) "},{"$f":" (RANDBETWEEN(M31,N31)*12) & CHOOSE(INT(RAND()*3)+1,\" est le double de ?  \",\" est le triple de ?  \",\" est le quadruple de ?  \")","v":"108 est le triple de ?  "},{"$f":"C31","v":"→"},"…………………",1,2,null,null,9,10]
["b) ",{"$f":" (RANDBETWEEN(I32,J32)*12) & CHOOSE(INT(RAND()*3)+1,\" est le double de ?  \",\" est le triple de ?  \",\" est le quadruple de ?  \")","v":"36 est le quadruple de ?  "},"→","…………………","g) ",{"$f":" (RANDBETWEEN(M32,N32)*12) & CHOOSE(INT(RAND()*3)+1,\" est le double de ?  \",\" est le triple de ?  \",\" est le quadruple de ?  \")","v":"96 est le triple de ?  "},{"$f":"C32","v":"→"},"…………………",3,4,null,null,7,8]
["c) ",{"$f":" (RANDBETWEEN(I33,J33)*12) & CHOOSE(INT(RAND()*3)+1,\" est le double de ?  \",\" est le triple de ?  \",\" est le quadruple de ?  \")","v":"60 est le double de ?  "},"→","…………………","h) ",{"$f":" (RANDBETWEEN(M33,N33)*12) & CHOOSE(INT(RAND()*3)+1,\" est le double de ?  \",\" est le triple de ?  \",\" est le quadruple de ?  \")","v":"72 est le triple de ?  "},"→","…………………",5,6,null,null,6,7]
["d) ",{"$f":" (RANDBETWEEN(I34,J34)*12) & CHOOSE(INT(RAND()*3)+1,\" est le double de ?  \",\" est le triple de ?  \",\" est le quadruple de ?  \")","v":"96 est le double de ?  "},"→","…………………","i) ",{"$f":" (RANDBETWEEN(M34,N34)*12) & CHOOSE(INT(RAND()*3)+1,\" est le double de ?  \",\" est le triple de ?  \",\" est le quadruple de ?  \")","v":"60 est le quadruple de ?  "},"→","…………………",7,8,null,null,5,6]
["e) ",{"$f":" (RANDBETWEEN(I35,J35)*12) & CHOOSE(INT(RAND()*3)+1,\" est le double de ?  \",\" est le triple de ?  \",\" est le quadruple de ?  \")","v":"108 est le double de ?  "},"→","…………………","j) ",{"$f":" (RANDBETWEEN(M35,N35)*12) & CHOOSE(INT(RAND()*3)+1,\" est le double de ?  \",\" est le triple de ?  \",\" est le quadruple de ?  \")","v":"48 est le double de ?  "},"→","…………………",9,10,null,null,4,5]
[]
[]
["E. Complète :",null,null,null,null,null,null,null,"Bornes",null,null,null,"Bornes"]
[null,null,null,null,null,null,null,null,"inf","sup",null,null,"inf","sup"]
[{"$f":"A4","v":"a) "},{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quelle est la moitié de \",\"Quel est le tiers de \",\"Quel est le quart de \") & (RANDBETWEEN(I40,J40)*12) & \" ? \"","v":"Quelle est la moitié de 24 ? "},"→","…………………",{"$f":"E4","v":"f) "},{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quelle est la moitié de \",\"Quel est le tiers de \",\"Quel est le quart de \") & (RANDBETWEEN(M40,N40)*12) & \" ? \"","v":"Quel est le tiers de 108 ? "},{"$f":"C40","v":"→"},"…………………",1,2,null,null,9,10]
["b) ",{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quel est le double de \",\"Quel est le triple de \",\"Quel est le quadruple de \") & (RANDBETWEEN(I41,J41)*12) & \" ? \"","v":"Quel est le triple de 36 ? "},"→","…………………","g) ",{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quel est le double de \",\"Quel est le triple de \",\"Quel est le quadruple de \") & (RANDBETWEEN(M41,N41)*12) & \" ? \"","v":"Quel est le quadruple de 96 ? "},{"$f":"C41","v":"→"},"…………………",3,4,null,null,7,8]
["c) ",{"$f":" (RANDBETWEEN(I42,J42)*12) & CHOOSE(INT(RAND()*3)+1,\" est la moitié de ?  \",\" est le tiers de ?  \",\" est le quart de ?  \")","v":"72 est le quart de ?  "},"→","…………………","h) ",{"$f":" (RANDBETWEEN(M42,N42)*12) & CHOOSE(INT(RAND()*3)+1,\" est la moitié de ?  \",\" est le tiers de ?  \",\" est le quart de ?  \")","v":"72 est la moitié de ?  "},"→","…………………",5,6,null,null,6,7]
["d) ",{"$f":" (RANDBETWEEN(I43,J43)*12) & CHOOSE(INT(RAND()*3)+1,\" est le double de ?  \",\" est le triple de ?  \",\" est le quadruple de ?  \")","v":"84 est le triple de ?  "},"→","…………………","i) ",{"$f":" (RANDBETWEEN(M43,N43)*12) & CHOOSE(INT(RAND()*3)+1,\" est le double de ?  \",\" est le triple de ?  \",\" est le quadruple de ?  \")","v":"60 est le triple de ?  "},"→","…………………",7,8,null,null,5,6]
["e) ",{"$f":" (RANDBETWEEN(I44,J44)*12) & CHOOSE(INT(RAND()*3)+1,\" est le double de ?  \",\" est le triple de ?  \",\" est le quadruple de ?  \")","v":"120 est le quadruple de ?  "},"→","…………………","j) ",{"$f":" (RANDBETWEEN(M44,N44)*12) & CHOOSE(INT(RAND()*3)+1,\" est le double de ?  \",\" est le triple de ?  \",\" est le quadruple de ?  \")","v":"48 est le triple de ?  "},"→","…………………",9,10,null,null,4,5]

{"sheet":"5 exo différents (double)","index":1,"n_rows":88,"n_cols":14,"rows_kept":88,"cut":false,"hidden":false,"merged":[[37,0,37,3],[37,8,37,9],[37,12,37,13],[19,0,19,3],[19,8,19,9],[19,12,19,13],[28,0,28,3],[28,8,28,9],[28,12,28,13],[10,0,10,3],[10,8,10,9],[10,12,10,13],[0,0,0,7],[0,8,0,17],[1,0,1,3],[1,8,1,9],[1,12,1,13],[81,0,81,3],[44,0,44,7],[45,0,45,3],[54,0,54,3],[63,0,63,3],[72,0,72,3]]}
["SAVOIR UTILISER LES MOTS  MOITIE / DOUBLE",null,null,null,null,null,null,null,"Ne modifier que les cellules en violet en faisant attention à ce que la borne inf soit inférieure à la borne sup."]
["A. Complète :",null,null,null,null,null,null,null,"Bornes",null,null,null,"Bornes"]
[null,null,null,null,null,null,null,null,"inf","sup",null,null,"inf","sup"]
["a) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est la moitié de \") & (RANDBETWEEN(I4,J4)*2) & \" ? \"","v":"Quelle est la moitié de 4 ? "},"→",{"$f":"(1*(MID(B4,MATCH(0,(ISERROR(MID(B4,ROW(INDIRECT(\"1:\"&LEN(B4))),1)*1)*1),\n0),LEN(B4)-SUM((ISERROR(MID(B4,ROW(INDIRECT(\"1:\"&LEN(B4))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",B4))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B4))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B4))),\"4\"))))))","v":2},"f) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est la moitié de \") & (RANDBETWEEN(M4,N4)*2) & \" ? \"","v":"Quelle est la moitié de 20 ? "},{"$f":"C4","v":"→"},{"$f":"(1*(MID(F4,MATCH(0,(ISERROR(MID(F4,ROW(INDIRECT(\"1:\"&LEN(F4))),1)*1)*1),\n0),LEN(F4)-SUM((ISERROR(MID(F4,ROW(INDIRECT(\"1:\"&LEN(F4))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",F4))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F4))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F4))),\"4\"))))))","v":10},1,2,null,null,9,10]
["b) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quel est le double de \") & (RANDBETWEEN(I5,J5)*2) & \" ? \"","v":"Quel est le double de 6 ? "},"→",{"$f":"(1*(MID(B5,MATCH(0,(ISERROR(MID(B5,ROW(INDIRECT(\"1:\"&LEN(B5))),1)*1)*1),0),\nLEN(B5)-SUM((ISERROR(MID(B5,ROW(INDIRECT(\"1:\"&LEN(B5))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"double\",B5))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B5))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B5))),\"4\"))))))","v":12},"g) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quel est le double de \") & (RANDBETWEEN(M5,N5)*2) & \" ? \"","v":"Quel est le double de 16 ? "},{"$f":"C5","v":"→"},{"$f":"(1*(MID(F5,MATCH(0,(ISERROR(MID(F5,ROW(INDIRECT(\"1:\"&LEN(F5))),1)*1)*1),\n0),LEN(F5)-SUM((ISERROR(MID(F5,ROW(INDIRECT(\"1:\"&LEN(F5))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"double\",F5))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F5))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F5))),\"4\"))))))","v":32},3,4,null,null,7,8]
["c) ",{"$f":" (RANDBETWEEN(I6,J6)*2) & CHOOSE(INT(RAND()*1)+1,\" est la moitié de ?  \")","v":"12 est la moitié de ?  "},"→",{"$f":"(1*(MID(B6,MATCH(0,(ISERROR(MID(B6,ROW(INDIRECT(\"1:\"&LEN(B6))),1)*1)*1),\n0),LEN(B6)-SUM((ISERROR(MID(B6,ROW(INDIRECT(\"1:\"&LEN(B6))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",B6))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B6))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B6))),\"4\"))))))","v":24},"h) ",{"$f":" (RANDBETWEEN(M6,N6)*2) & CHOOSE(INT(RAND()*1)+1,\" est le double de ?  \")","v":"12 est le double de ?  "},"→",{"$f":"(1*(MID(F6,MATCH(0,(ISERROR(MID(F6,ROW(INDIRECT(\"1:\"&LEN(F6))),1)*1)*1),\n0),LEN(F6)-SUM((ISERROR(MID(F6,ROW(INDIRECT(\"1:\"&LEN(F6))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"double\",F6))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F6))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F6))),\"4\"))))))","v":6},5,6,null,null,6,7]
["d) ",{"$f":" (RANDBETWEEN(I7,J7)*2) & CHOOSE(INT(RAND()*1)+1,\" est la moitié de ?  \")","v":"16 est la moitié de ?  "},"→",{"$f":"(1*(MID(B7,MATCH(0,(ISERROR(MID(B7,ROW(INDIRECT(\"1:\"&LEN(B7))),1)*1)*1),\n0),LEN(B7)-SUM((ISERROR(MID(B7,ROW(INDIRECT(\"1:\"&LEN(B7))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",B7))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B7))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B7))),\"4\"))))))","v":32},"i) ",{"$f":" (RANDBETWEEN(M7,N7)*2) & CHOOSE(INT(RAND()*1)+1,\" est la moitié de ?  \")","v":"10 est la moitié de ?  "},"→",{"$f":"(1*(MID(F7,MATCH(0,(ISERROR(MID(F7,ROW(INDIRECT(\"1:\"&LEN(F7))),1)*1)*1),\n0),LEN(F7)-SUM((ISERROR(MID(F7,ROW(INDIRECT(\"1:\"&LEN(F7))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",F7))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F7))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F7))),\"4\"))))))","v":20},7,8,null,null,5,6]
["e) ",{"$f":" (RANDBETWEEN(I8,J8)*2) & CHOOSE(INT(RAND()*1)+1,\" est le double de ?  \")","v":"20 est le double de ?  "},"→",{"$f":"(1*(MID(B8,MATCH(0,(ISERROR(MID(B8,ROW(INDIRECT(\"1:\"&LEN(B8))),1)*1)*1),\n0),LEN(B8)-SUM((ISERROR(MID(B8,ROW(INDIRECT(\"1:\"&LEN(B8))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"double\",B8))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B8))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B8))),\"4\"))))))","v":10},"j) ",{"$f":" (RANDBETWEEN(M8,N8)*2) & CHOOSE(INT(RAND()*1)+1,\" est la moitié de ?  \")","v":"8 est la moitié de ?  "},"→",{"$f":"(1*(MID(F8,MATCH(0,(ISERROR(MID(F8,ROW(INDIRECT(\"1:\"&LEN(F8))),1)*1)*1),\n0),LEN(F8)-SUM((ISERROR(MID(F8,ROW(INDIRECT(\"1:\"&LEN(F8))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",F8))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F8))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F8))),\"4\"))))))","v":16},9,10,null,null,4,5]
[]
[]
["B. Complète :",null,null,null,null,null,null,null,"Bornes",null,null,null,"Bornes"]
[null,null,null,null,null,null,null,null,"inf","sup",null,null,"inf","sup"]
["a) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est la moitié de \") & (RANDBETWEEN(I13,J13)*2) & \" ? \"","v":"Quelle est la moitié de 8 ? "},"→",{"$f":"(1*(MID(B13,MATCH(0,(ISERROR(MID(B13,ROW(INDIRECT(\"1:\"&LEN(B13))),1)*1)*1),\n0),LEN(B13)-SUM((ISERROR(MID(B13,ROW(INDIRECT(\"1:\"&LEN(B13))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",B13))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B13))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B13))),\"4\"))))))","v":4},"f) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est la moitié de \") & (RANDBETWEEN(M13,N13)*2) & \" ? \"","v":"Quelle est la moitié de 24 ? "},{"$f":"C13","v":"→"},{"$f":"(1*(MID(F13,MATCH(0,(ISERROR(MID(F13,ROW(INDIRECT(\"1:\"&LEN(F13))),1)*1)*1),\n0),LEN(F13)-SUM((ISERROR(MID(F13,ROW(INDIRECT(\"1:\"&LEN(F13))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",F13))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F13))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F13))),\"4\"))))))","v":12},2,4,null,null,12,14]
["b) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quel est le double de \") & (RANDBETWEEN(I14,J14)*2) & \" ? \"","v":"Quel est le double de 8 ? "},"→",{"$f":"(1*(MID(B14,MATCH(0,(ISERROR(MID(B14,ROW(INDIRECT(\"1:\"&LEN(B14))),1)*1)*1),0),\nLEN(B14)-SUM((ISERROR(MID(B14,ROW(INDIRECT(\"1:\"&LEN(B14))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"double\",B14))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B14))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B14))),\"4\"))))))","v":16},"g) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quel est le double de \") & (RANDBETWEEN(M14,N14)*2) & \" ? \"","v":"Quel est le double de 28 ? "},{"$f":"C14","v":"→"},{"$f":"(1*(MID(F14,MATCH(0,(ISERROR(MID(F14,ROW(INDIRECT(\"1:\"&LEN(F14))),1)*1)*1),\n0),LEN(F14)-SUM((ISERROR(MID(F14,ROW(INDIRECT(\"1:\"&LEN(F14))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"double\",F14))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F14))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F14))),\"4\"))))))","v":56},4,6,null,null,14,16]
["c) ",{"$f":" (RANDBETWEEN(I15,J15)*2) & CHOOSE(INT(RAND()*1)+1,\" est la moitié de ?  \")","v":"16 est la moitié de ?  "},"→",{"$f":"(1*(MID(B15,MATCH(0,(ISERROR(MID(B15,ROW(INDIRECT(\"1:\"&LEN(B15))),1)*1)*1),\n0),LEN(B15)-SUM((ISERROR(MID(B15,ROW(INDIRECT(\"1:\"&LEN(B15))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",B15))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B15))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B15))),\"4\"))))))","v":32},"h) ",{"$f":" (RANDBETWEEN(M15,N15)*2) & CHOOSE(INT(RAND()*1)+1,\" est le double de ?  \")","v":"34 est le double de ?  "},"→",{"$f":"(1*(MID(F15,MATCH(0,(ISERROR(MID(F15,ROW(INDIRECT(\"1:\"&LEN(F15))),1)*1)*1),\n0),LEN(F15)-SUM((ISERROR(MID(F15,ROW(INDIRECT(\"1:\"&LEN(F15))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"double\",F15))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F15))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F15))),\"4\"))))))","v":17},6,8,null,null,16,18]
["d) ",{"$f":" (RANDBETWEEN(I16,J16)*2) & CHOOSE(INT(RAND()*1)+1,\" est la moitié de ?  \")","v":"20 est la moitié de ?  "},"→",{"$f":"(1*(MID(B16,MATCH(0,(ISERROR(MID(B16,ROW(INDIRECT(\"1:\"&LEN(B16))),1)*1)*1),\n0),LEN(B16)-SUM((ISERROR(MID(B16,ROW(INDIRECT(\"1:\"&LEN(B16))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",B16))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B16))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B16))),\"4\"))))))","v":40},"i) ",{"$f":" (RANDBETWEEN(M16,N16)*2) & CHOOSE(INT(RAND()*1)+1,\" est la moitié de ?  \")","v":"36 est la moitié de ?  "},"→",{"$f":"(1*(MID(F16,MATCH(0,(ISERROR(MID(F16,ROW(INDIRECT(\"1:\"&LEN(F16))),1)*1)*1),\n0),LEN(F16)-SUM((ISERROR(MID(F16,ROW(INDIRECT(\"1:\"&LEN(F16))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",F16))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F16))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F16))),\"4\"))))))","v":72},8,10,null,null,18,20]
["e) ",{"$f":" (RANDBETWEEN(I17,J17)*2) & CHOOSE(INT(RAND()*1)+1,\" est le double de ?  \")","v":"20 est le double de ?  "},"→",{"$f":"(1*(MID(B17,MATCH(0,(ISERROR(MID(B17,ROW(INDIRECT(\"1:\"&LEN(B17))),1)*1)*1),\n0),LEN(B17)-SUM((ISERROR(MID(B17,ROW(INDIRECT(\"1:\"&LEN(B17))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"double\",B17))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B17))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B17))),\"4\"))))))","v":10},"j) ",{"$f":" (RANDBETWEEN(M17,N17)*2) & CHOOSE(INT(RAND()*1)+1,\" est la moitié de ?  \")","v":"40 est la moitié de ?  "},"→",{"$f":"(1*(MID(F17,MATCH(0,(ISERROR(MID(F17,ROW(INDIRECT(\"1:\"&LEN(F17))),1)*1)*1),\n0),LEN(F17)-SUM((ISERROR(MID(F17,ROW(INDIRECT(\"1:\"&LEN(F17))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",F17))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F17))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F17))),\"4\"))))))","v":80},10,12,null,null,20,22]
[]
[]
["C. Complète :",null,null,null,null,null,null,null,"Bornes",null,null,null,"Bornes"]
[null,null,null,null,null,null,null,null,"inf","sup",null,null,"inf","sup"]
["a) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est la moitié de \") & (RANDBETWEEN(I22,J22)*2) & \" ? \"","v":"Quelle est la moitié de 42 ? "},"→",{"$f":"(1*(MID(B22,MATCH(0,(ISERROR(MID(B22,ROW(INDIRECT(\"1:\"&LEN(B22))),1)*1)*1),\n0),LEN(B22)-SUM((ISERROR(MID(B22,ROW(INDIRECT(\"1:\"&LEN(B22))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",B22))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B22))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B22))),\"4\"))))))","v":21},"f) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est la moitié de \") & (RANDBETWEEN(M22,N22)*2) & \" ? \"","v":"Quelle est la moitié de 64 ? "},{"$f":"C22","v":"→"},{"$f":"(1*(MID(F22,MATCH(0,(ISERROR(MID(F22,ROW(INDIRECT(\"1:\"&LEN(F22))),1)*1)*1),\n0),LEN(F22)-SUM((ISERROR(MID(F22,ROW(INDIRECT(\"1:\"&LEN(F22))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",F22))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F22))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F22))),\"4\"))))))","v":32},20,22,null,null,30,32]
["b) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quel est le double de \") & (RANDBETWEEN(I23,J23)*2) & \" ? \"","v":"Quel est le double de 46 ? "},"→",{"$f":"(1*(MID(B23,MATCH(0,(ISERROR(MID(B23,ROW(INDIRECT(\"1:\"&LEN(B23))),1)*1)*1),0),\nLEN(B23)-SUM((ISERROR(MID(B23,ROW(INDIRECT(\"1:\"&LEN(B23))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"double\",B23))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B23))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B23))),\"4\"))))))","v":92},"g) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quel est le double de \") & (RANDBETWEEN(M23,N23)*2) & \" ? \"","v":"Quel est le double de 68 ? "},{"$f":"C23","v":"→"},{"$f":"(1*(MID(F23,MATCH(0,(ISERROR(MID(F23,ROW(INDIRECT(\"1:\"&LEN(F23))),1)*1)*1),\n0),LEN(F23)-SUM((ISERROR(MID(F23,ROW(INDIRECT(\"1:\"&LEN(F23))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"double\",F23))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F23))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F23))),\"4\"))))))","v":136},22,24,null,null,32,34]
["c) ",{"$f":" (RANDBETWEEN(I24,J24)*2) & CHOOSE(INT(RAND()*1)+1,\" est la moitié de ?  \")","v":"52 est la moitié de ?  "},"→",{"$f":"(1*(MID(B24,MATCH(0,(ISERROR(MID(B24,ROW(INDIRECT(\"1:\"&LEN(B24))),1)*1)*1),\n0),LEN(B24)-SUM((ISERROR(MID(B24,ROW(INDIRECT(\"1:\"&LEN(B24))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",B24))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B24))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B24))),\"4\"))))))","v":104},"h) ",{"$f":" (RANDBETWEEN(M24,N24)*2) & CHOOSE(INT(RAND()*1)+1,\" est le double de ?  \")","v":"68 est le double de ?  "},"→",{"$f":"(1*(MID(F24,MATCH(0,(ISERROR(MID(F24,ROW(INDIRECT(\"1:\"&LEN(F24))),1)*1)*1),\n0),LEN(F24)-SUM((ISERROR(MID(F24,ROW(INDIRECT(\"1:\"&LEN(F24))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"double\",F24))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F24))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F24))),\"4\"))))))","v":34},24,26,null,null,34,36]
["d) ",{"$f":" (RANDBETWEEN(I25,J25)*2) & CHOOSE(INT(RAND()*1)+1,\" est la moitié de ?  \")","v":"52 est la moitié de ?  "},"→",{"$f":"(1*(MID(B25,MATCH(0,(ISERROR(MID(B25,ROW(INDIRECT(\"1:\"&LEN(B25))),1)*1)*1),\n0),LEN(B25)-SUM((ISERROR(MID(B25,ROW(INDIRECT(\"1:\"&LEN(B25))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",B25))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B25))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B25))),\"4\"))))))","v":104},"i) ",{"$f":" (RANDBETWEEN(M25,N25)*2) & CHOOSE(INT(RAND()*1)+1,\" est la moitié de ?  \")","v":"72 est la moitié de ?  "},"→",{"$f":"(1*(MID(F25,MATCH(0,(ISERROR(MID(F25,ROW(INDIRECT(\"1:\"&LEN(F25))),1)*1)*1),\n0),LEN(F25)-SUM((ISERROR(MID(F25,ROW(INDIRECT(\"1:\"&LEN(F25))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",F25))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F25))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F25))),\"4\"))))))","v":144},26,28,null,null,36,38]
["e) ",{"$f":" (RANDBETWEEN(I26,J26)*2) & CHOOSE(INT(RAND()*1)+1,\" est le double de ?  \")","v":"58 est le double de ?  "},"→",{"$f":"(1*(MID(B26,MATCH(0,(ISERROR(MID(B26,ROW(INDIRECT(\"1:\"&LEN(B26))),1)*1)*1),\n0),LEN(B26)-SUM((ISERROR(MID(B26,ROW(INDIRECT(\"1:\"&LEN(B26))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"double\",B26))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B26))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B26))),\"4\"))))))","v":29},"j) ",{"$f":" (RANDBETWEEN(M26,N26)*2) & CHOOSE(INT(RAND()*1)+1,\" est la moitié de ?  \")","v":"78 est la moitié de ?  "},"→",{"$f":"(1*(MID(F26,MATCH(0,(ISERROR(MID(F26,ROW(INDIRECT(\"1:\"&LEN(F26))),1)*1)*1),\n0),LEN(F26)-SUM((ISERROR(MID(F26,ROW(INDIRECT(\"1:\"&LEN(F26))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",F26))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F26))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F26))),\"4\"))))))","v":156},28,30,null,null,38,40]
[]
[]
["D. Complète :",null,null,null,null,null,null,null,"Bornes",null,null,null,"Bornes"]
[null,null,null,null,null,null,null,null,"inf","sup",null,null,"inf","sup"]
["a) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est la moitié de \") & (RANDBETWEEN(I31,J31)*2) & \" ? \"","v":"Quelle est la moitié de 82 ? "},"→",{"$f":"(1*(MID(B31,MATCH(0,(ISERROR(MID(B31,ROW(INDIRECT(\"1:\"&LEN(B31))),1)*1)*1),\n0),LEN(B31)-SUM((ISERROR(MID(B31,ROW(INDIRECT(\"1:\"&LEN(B31))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",B31))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B31))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B31))),\"4\"))))))","v":41},"f) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est la moitié de \") & (RANDBETWEEN(M31,N31)*2) & \" ? \"","v":"Quelle est la moitié de 100 ? "},{"$f":"C31","v":"→"},{"$f":"(1*(MID(F31,MATCH(0,(ISERROR(MID(F31,ROW(INDIRECT(\"1:\"&LEN(F31))),1)*1)*1),\n0),LEN(F31)-SUM((ISERROR(MID(F31,ROW(INDIRECT(\"1:\"&LEN(F31))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",F31))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F31))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F31))),\"4\"))))))","v":50},40,42,null,null,50,52]
["b) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quel est le double de \") & (RANDBETWEEN(I32,J32)*2) & \" ? \"","v":"Quel est le double de 88 ? "},"→",{"$f":"(1*(MID(B32,MATCH(0,(ISERROR(MID(B32,ROW(INDIRECT(\"1:\"&LEN(B32))),1)*1)*1),0),\nLEN(B32)-SUM((ISERROR(MID(B32,ROW(INDIRECT(\"1:\"&LEN(B32))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"double\",B32))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B32))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B32))),\"4\"))))))","v":176},"g) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quel est le double de \") & (RANDBETWEEN(M32,N32)*2) & \" ? \"","v":"Quel est le double de 108 ? "},{"$f":"C32","v":"→"},{"$f":"(1*(MID(F32,MATCH(0,(ISERROR(MID(F32,ROW(INDIRECT(\"1:\"&LEN(F32))),1)*1)*1),\n0),LEN(F32)-SUM((ISERROR(MID(F32,ROW(INDIRECT(\"1:\"&LEN(F32))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"double\",F32))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F32))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F32))),\"4\"))))))","v":216},42,44,null,null,52,54]
["c) ",{"$f":" (RANDBETWEEN(I33,J33)*2) & CHOOSE(INT(RAND()*1)+1,\" est la moitié de ?  \")","v":"92 est la moitié de ?  "},"→",{"$f":"(1*(MID(B33,MATCH(0,(ISERROR(MID(B33,ROW(INDIRECT(\"1:\"&LEN(B33))),1)*1)*1),\n0),LEN(B33)-SUM((ISERROR(MID(B33,ROW(INDIRECT(\"1:\"&LEN(B33))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",B33))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B33))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B33))),\"4\"))))))","v":184},"h) ",{"$f":" (RANDBETWEEN(M33,N33)*2) & CHOOSE(INT(RAND()*1)+1,\" est le double de ?  \")","v":"110 est le double de ?  "},"→",{"$f":"(1*(MID(F33,MATCH(0,(ISERROR(MID(F33,ROW(INDIRECT(\"1:\"&LEN(F33))),1)*1)*1),\n0),LEN(F33)-SUM((ISERROR(MID(F33,ROW(INDIRECT(\"1:\"&LEN(F33))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"double\",F33))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F33))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F33))),\"4\"))))))","v":55},44,46,null,null,54,56]
["d) ",{"$f":" (RANDBETWEEN(I34,J34)*2) & CHOOSE(INT(RAND()*1)+1,\" est la moitié de ?  \")","v":"96 est la moitié de ?  "},"→",{"$f":"(1*(MID(B34,MATCH(0,(ISERROR(MID(B34,ROW(INDIRECT(\"1:\"&LEN(B34))),1)*1)*1),\n0),LEN(B34)-SUM((ISERROR(MID(B34,ROW(INDIRECT(\"1:\"&LEN(B34))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",B34))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B34))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B34))),\"4\"))))))","v":192},"i) ",{"$f":" (RANDBETWEEN(M34,N34)*2) & CHOOSE(INT(RAND()*1)+1,\" est la moitié de ?  \")","v":"114 est la moitié de ?  "},"→",{"$f":"(1*(MID(F34,MATCH(0,(ISERROR(MID(F34,ROW(INDIRECT(\"1:\"&LEN(F34))),1)*1)*1),\n0),LEN(F34)-SUM((ISERROR(MID(F34,ROW(INDIRECT(\"1:\"&LEN(F34))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",F34))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F34))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F34))),\"4\"))))))","v":228},46,48,null,null,56,58]
["e) ",{"$f":" (RANDBETWEEN(I35,J35)*2) & CHOOSE(INT(RAND()*1)+1,\" est le double de ?  \")","v":"96 est le double de ?  "},"→",{"$f":"(1*(MID(B35,MATCH(0,(ISERROR(MID(B35,ROW(INDIRECT(\"1:\"&LEN(B35))),1)*1)*1),\n0),LEN(B35)-SUM((ISERROR(MID(B35,ROW(INDIRECT(\"1:\"&LEN(B35))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"double\",B35))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B35))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B35))),\"4\"))))))","v":48},"j) ",{"$f":" (RANDBETWEEN(M35,N35)*2) & CHOOSE(INT(RAND()*1)+1,\" est la moitié de ?  \")","v":"116 est la moitié de ?  "},"→",{"$f":"(1*(MID(F35,MATCH(0,(ISERROR(MID(F35,ROW(INDIRECT(\"1:\"&LEN(F35))),1)*1)*1),\n0),LEN(F35)-SUM((ISERROR(MID(F35,ROW(INDIRECT(\"1:\"&LEN(F35))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",F35))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F35))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F35))),\"4\"))))))","v":232},48,50,null,null,58,60]
[]
[]
["E. Complète :",null,null,null,null,null,null,null,"Bornes",null,null,null,"Bornes"]
[null,null,null,null,null,null,null,null,"inf","sup",null,null,"inf","sup"]
["a) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est la moitié de \") & (RANDBETWEEN(I40,J40)*2) & \" ? \"","v":"Quelle est la moitié de 80 ? "},"→",{"$f":"(1*(MID(B40,MATCH(0,(ISERROR(MID(B40,ROW(INDIRECT(\"1:\"&LEN(B40))),1)*1)*1),\n0),LEN(B40)-SUM((ISERROR(MID(B40,ROW(INDIRECT(\"1:\"&LEN(B40))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",B40))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B40))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B40))),\"4\"))))))","v":40},"f) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est la moitié de \") & (RANDBETWEEN(M40,N40)*2) & \" ? \"","v":"Quelle est la moitié de 26 ? "},{"$f":"C40","v":"→"},{"$f":"(1*(MID(F40,MATCH(0,(ISERROR(MID(F40,ROW(INDIRECT(\"1:\"&LEN(F40))),1)*1)*1),\n0),LEN(F40)-SUM((ISERROR(MID(F40,ROW(INDIRECT(\"1:\"&LEN(F40))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",F40))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F40))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F40))),\"4\"))))))","v":13},30,40,null,null,10,20]
["b) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quel est le double de \") & (RANDBETWEEN(I41,J41)*2) & \" ? \"","v":"Quel est le double de 40 ? "},"→",{"$f":"(1*(MID(B41,MATCH(0,(ISERROR(MID(B41,ROW(INDIRECT(\"1:\"&LEN(B41))),1)*1)*1),0),\nLEN(B41)-SUM((ISERROR(MID(B41,ROW(INDIRECT(\"1:\"&LEN(B41))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"double\",B41))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B41))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B41))),\"4\"))))))","v":80},"g) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quel est le double de \") & (RANDBETWEEN(M41,N41)*2) & \" ? \"","v":"Quel est le double de 60 ? "},{"$f":"C41","v":"→"},{"$f":"(1*(MID(F41,MATCH(0,(ISERROR(MID(F41,ROW(INDIRECT(\"1:\"&LEN(F41))),1)*1)*1),\n0),LEN(F41)-SUM((ISERROR(MID(F41,ROW(INDIRECT(\"1:\"&LEN(F41))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"double\",F41))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F41))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F41))),\"4\"))))))","v":120},20,30,null,null,20,30]
["c) ",{"$f":" (RANDBETWEEN(I42,J42)*2) & CHOOSE(INT(RAND()*1)+1,\" est la moitié de ?  \")","v":"36 est la moitié de ?  "},"→",{"$f":"(1*(MID(B42,MATCH(0,(ISERROR(MID(B42,ROW(INDIRECT(\"1:\"&LEN(B42))),1)*1)*1),\n0),LEN(B42)-SUM((ISERROR(MID(B42,ROW(INDIRECT(\"1:\"&LEN(B42))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",B42))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B42))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B42))),\"4\"))))))","v":72},"h) ",{"$f":" (RANDBETWEEN(M42,N42)*2) & CHOOSE(INT(RAND()*1)+1,\" est le double de ?  \")","v":"64 est le double de ?  "},"→",{"$f":"(1*(MID(F42,MATCH(0,(ISERROR(MID(F42,ROW(INDIRECT(\"1:\"&LEN(F42))),1)*1)*1),\n0),LEN(F42)-SUM((ISERROR(MID(F42,ROW(INDIRECT(\"1:\"&LEN(F42))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"double\",F42))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F42))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F42))),\"4\"))))))","v":32},10,20,null,null,30,40]
["d) ",{"$f":" (RANDBETWEEN(I43,J43)*2) & CHOOSE(INT(RAND()*1)+1,\" est la moitié de ?  \")","v":"34 est la moitié de ?  "},"→",{"$f":"(1*(MID(B43,MATCH(0,(ISERROR(MID(B43,ROW(INDIRECT(\"1:\"&LEN(B43))),1)*1)*1),\n0),LEN(B43)-SUM((ISERROR(MID(B43,ROW(INDIRECT(\"1:\"&LEN(B43))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",B43))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B43))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B43))),\"4\"))))))","v":68},"i) ",{"$f":" (RANDBETWEEN(M43,N43)*2) & CHOOSE(INT(RAND()*1)+1,\" est la moitié de ?  \")","v":"96 est la moitié de ?  "},"→",{"$f":"(1*(MID(F43,MATCH(0,(ISERROR(MID(F43,ROW(INDIRECT(\"1:\"&LEN(F43))),1)*1)*1),\n0),LEN(F43)-SUM((ISERROR(MID(F43,ROW(INDIRECT(\"1:\"&LEN(F43))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",F43))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F43))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F43))),\"4\"))))))","v":192},10,20,null,null,40,50]
["e) ",{"$f":" (RANDBETWEEN(I44,J44)*2) & CHOOSE(INT(RAND()*1)+1,\" est le double de ?  \")","v":"120 est le double de ?  "},"→",{"$f":"(1*(MID(B44,MATCH(0,(ISERROR(MID(B44,ROW(INDIRECT(\"1:\"&LEN(B44))),1)*1)*1),\n0),LEN(B44)-SUM((ISERROR(MID(B44,ROW(INDIRECT(\"1:\"&LEN(B44))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"double\",B44))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B44))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B44))),\"4\"))))))","v":60},"j) ",{"$f":" (RANDBETWEEN(M44,N44)*2) & CHOOSE(INT(RAND()*1)+1,\" est la moitié de ?  \")","v":"108 est la moitié de ?  "},"→",{"$f":"(1*(MID(F44,MATCH(0,(ISERROR(MID(F44,ROW(INDIRECT(\"1:\"&LEN(F44))),1)*1)*1),\n0),LEN(F44)-SUM((ISERROR(MID(F44,ROW(INDIRECT(\"1:\"&LEN(F44))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",F44))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F44))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F44))),\"4\"))))))","v":216},60,70,null,null,50,60]
[{"$f":"A1","v":"SAVOIR UTILISER LES MOTS  MOITIE / DOUBLE"},0,0,0,0,0,0,0]
["A. Complète :",0,0,0]
[]
["a) ","Quelle est la moitié de 4 ? ","→","…………………","f) ","Quelle est la moitié de 20 ? ","→","…………………"]
["b) ","Quel est le double de 6 ? ","→","…………………","g) ","Quel est le double de 16 ? ","→","…………………"]
["c) ","12 est la moitié de ?  ","→","…………………","h) ","12 est le double de ?  ","→","…………………"]
["d) ","16 est la moitié de ?  ","→","…………………","i) ","10 est la moitié de ?  ","→","…………………"]
["e) ","20 est le double de ?  ","→","…………………","j) ","8 est la moitié de ?  ","→","…………………"]
[]
[]
[{"$f":"A11","v":"B. Complète :"},0,0,0]
[]
["a) ","Quelle est la moitié de 8 ? ","→","…………………","f) ","Quelle est la moitié de 24 ? ","→","…………………"]
["b) ","Quel est le double de 8 ? ","→","…………………","g) ","Quel est le double de 28 ? ","→","…………………"]
["c) ","16 est la moitié de ?  ","→","…………………","h) ","34 est le double de ?  ","→","…………………"]
["d) ","20 est la moitié de ?  ","→","…………………","i) ","36 est la moitié de ?  ","→","…………………"]
["e) ","20 est le double de ?  ","→","…………………","j) ","40 est la moitié de ?  ","→","…………………"]
[]
[]
["C. Complète :",0,0,0]
[]
[{"$f":"A22","v":"a) "},"Quelle est la moitié de 42 ? ","→","…………………","f) ","Quelle est la moitié de 64 ? ","→","…………………"]
["b) ","Quel est le double de 46 ? ","→","…………………","g) ","Quel est le double de 68 ? ","→","…………………"]
["c) ","52 est la moitié de ?  ","→","…………………","h) ","68 est le double de ?  ","→","…………………"]
["d) ","52 est la moitié de ?  ","→","…………………","i) ","72 est la moitié de ?  ","→","…………………"]
["e) ","58 est le double de ?  ","→","…………………","j) ","78 est la moitié de ?  ","→","…………………"]
[]
[]
["D. Complète :",0,0,0]
[]
[{"$f":"A31","v":"a) "},"Quelle est la moitié de 82 ? ","→","…………………","f) ","Quelle est la moitié de 100 ? ","→","…………………"]
["b) ","Quel est le double de 88 ? ","→","…………………","g) ","Quel est le double de 108 ? ","→","…………………"]
["c) ","92 est la moitié de ?  ","→","…………………","h) ","110 est le double de ?  ","→","…………………"]
["d) ","96 est la moitié de ?  ","→","…………………","i) ","114 est la moitié de ?  ","→","…………………"]
["e) ","96 est le double de ?  ","→","…………………","j) ","116 est la moitié de ?  ","→","…………………"]
[]
[]
["E. Complète :",0,0,0]
[]
["a) ","Quelle est la moitié de 80 ? ","→","…………………","f) ","Quelle est la moitié de 26 ? ","→","…………………"]
[{"$f":"A41","v":"b) "},"Quel est le double de 40 ? ","→","…………………","g) ","Quel est le double de 60 ? ","→","…………………"]
["c) ","36 est la moitié de ?  ","→","…………………","h) ","64 est le double de ?  ","→","…………………"]
["d) ","34 est la moitié de ?  ","→","…………………","i) ","96 est la moitié de ?  ","→","…………………"]
["e) ","120 est le double de ?  ","→","…………………","j) ","108 est la moitié de ?  ","→","…………………"]

{"sheet":"5 exo différents (triple)","index":2,"n_rows":88,"n_cols":14,"rows_kept":88,"cut":false,"hidden":false,"merged":[[63,0,63,3],[72,0,72,3],[81,0,81,3],[37,0,37,3],[37,8,37,9],[37,12,37,13],[44,0,44,7],[45,0,45,3],[54,0,54,3],[19,0,19,3],[19,8,19,9],[19,12,19,13],[28,0,28,3],[28,8,28,9],[28,12,28,13],[10,0,10,3],[10,8,10,9],[10,12,10,13],[0,0,0,7],[0,8,0,17],[1,0,1,3],[1,8,1,9],[1,12,1,13]]}
["SAVOIR UTILISER LES MOTS  TIERS / TRIPLE",null,null,null,null,null,null,null,"Ne modifier que les cellules en violet en faisant attention à ce que la borne inf soit inférieure à la borne sup."]
["A. Complète :",null,null,null,null,null,null,null,"Bornes",null,null,null,"Bornes"]
[null,null,null,null,null,null,null,null,"inf","sup",null,null,"inf","sup"]
["a) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est le tiers de \") & (RANDBETWEEN(I4,J4)*3) & \" ? \"","v":"Quelle est le tiers de 6 ? "},"→",{"$f":"(1*(MID(B4,MATCH(0,(ISERROR(MID(B4,ROW(INDIRECT(\"1:\"&LEN(B4))),1)*1)*1),\n0),LEN(B4)-SUM((ISERROR(MID(B4,ROW(INDIRECT(\"1:\"&LEN(B4))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",B4))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B4))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B4))),\"4\"))))))","v":2},"f) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est le tiers de \") & (RANDBETWEEN(M4,N4)*3) & \" ? \"","v":"Quelle est le tiers de 30 ? "},{"$f":"C4","v":"→"},{"$f":"(1*(MID(F4,MATCH(0,(ISERROR(MID(F4,ROW(INDIRECT(\"1:\"&LEN(F4))),1)*1)*1),\n0),LEN(F4)-SUM((ISERROR(MID(F4,ROW(INDIRECT(\"1:\"&LEN(F4))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",F4))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F4))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F4))),\"4\"))))))","v":10},1,2,null,null,9,10]
["b) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est le triple de \") & (RANDBETWEEN(I5,J5)*3) & \" ? \"","v":"Quelle est le triple de 9 ? "},"→",{"$f":"(1*(MID(B5,MATCH(0,(ISERROR(MID(B5,ROW(INDIRECT(\"1:\"&LEN(B5))),1)*1)*1),0),\nLEN(B5)-SUM((ISERROR(MID(B5,ROW(INDIRECT(\"1:\"&LEN(B5))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"double\",B5))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B5))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B5))),\"4\"))))))","v":27},"g) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quel est le triple de \") & (RANDBETWEEN(M5,N5)*3) & \" ? \"","v":"Quel est le triple de 21 ? "},{"$f":"C5","v":"→"},{"$f":"(1*(MID(F5,MATCH(0,(ISERROR(MID(F5,ROW(INDIRECT(\"1:\"&LEN(F5))),1)*1)*1),\n0),LEN(F5)-SUM((ISERROR(MID(F5,ROW(INDIRECT(\"1:\"&LEN(F5))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"double\",F5))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F5))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F5))),\"4\"))))))","v":63},3,4,null,null,7,8]
["c) ",{"$f":" (RANDBETWEEN(I6,J6)*3) & CHOOSE(INT(RAND()*1)+1,\" est le tiers de ?  \")","v":"18 est le tiers de ?  "},"→",{"$f":"(1*(MID(B6,MATCH(0,(ISERROR(MID(B6,ROW(INDIRECT(\"1:\"&LEN(B6))),1)*1)*1),\n0),LEN(B6)-SUM((ISERROR(MID(B6,ROW(INDIRECT(\"1:\"&LEN(B6))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",B6))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B6))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B6))),\"4\"))))))","v":54},"h) ",{"$f":" (RANDBETWEEN(M6,N6)*3) & CHOOSE(INT(RAND()*1)+1,\" est le triple de ?  \")","v":"21 est le triple de ?  "},"→",{"$f":"(1*(MID(F6,MATCH(0,(ISERROR(MID(F6,ROW(INDIRECT(\"1:\"&LEN(F6))),1)*1)*1),\n0),LEN(F6)-SUM((ISERROR(MID(F6,ROW(INDIRECT(\"1:\"&LEN(F6))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"double\",F6))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F6))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F6))),\"4\"))))))","v":7},5,6,null,null,6,7]
["d) ",{"$f":" (RANDBETWEEN(I7,J7)*3) & CHOOSE(INT(RAND()*1)+1,\" est le tiers de ?  \")","v":"21 est le tiers de ?  "},"→",{"$f":"(1*(MID(B7,MATCH(0,(ISERROR(MID(B7,ROW(INDIRECT(\"1:\"&LEN(B7))),1)*1)*1),\n0),LEN(B7)-SUM((ISERROR(MID(B7,ROW(INDIRECT(\"1:\"&LEN(B7))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",B7))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B7))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B7))),\"4\"))))))","v":63},"i) ",{"$f":" (RANDBETWEEN(M7,N7)*3) & CHOOSE(INT(RAND()*1)+1,\" est le tiers de ?  \")","v":"15 est le tiers de ?  "},"→",{"$f":"(1*(MID(F7,MATCH(0,(ISERROR(MID(F7,ROW(INDIRECT(\"1:\"&LEN(F7))),1)*1)*1),\n0),LEN(F7)-SUM((ISERROR(MID(F7,ROW(INDIRECT(\"1:\"&LEN(F7))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",F7))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F7))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F7))),\"4\"))))))","v":45},7,8,null,null,5,6]
["e) ",{"$f":" (RANDBETWEEN(I8,J8)*3) & CHOOSE(INT(RAND()*1)+1,\" est le triple de ?  \")","v":"27 est le triple de ?  "},"→",{"$f":"(1*(MID(B8,MATCH(0,(ISERROR(MID(B8,ROW(INDIRECT(\"1:\"&LEN(B8))),1)*1)*1),\n0),LEN(B8)-SUM((ISERROR(MID(B8,ROW(INDIRECT(\"1:\"&LEN(B8))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"double\",B8))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B8))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B8))),\"4\"))))))","v":9},"j) ",{"$f":" (RANDBETWEEN(M8,N8)*3) & CHOOSE(INT(RAND()*1)+1,\" est le tiers de ?  \")","v":"15 est le tiers de ?  "},"→",{"$f":"(1*(MID(F8,MATCH(0,(ISERROR(MID(F8,ROW(INDIRECT(\"1:\"&LEN(F8))),1)*1)*1),\n0),LEN(F8)-SUM((ISERROR(MID(F8,ROW(INDIRECT(\"1:\"&LEN(F8))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",F8))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F8))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F8))),\"4\"))))))","v":45},9,10,null,null,4,5]
[]
[]
["B. Complète :",null,null,null,null,null,null,null,"Bornes",null,null,null,"Bornes"]
[null,null,null,null,null,null,null,null,"inf","sup",null,null,"inf","sup"]
["a) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est le tiers de \") & (RANDBETWEEN(I13,J13)*3) & \" ? \"","v":"Quelle est le tiers de 9 ? "},"→",{"$f":"(1*(MID(B13,MATCH(0,(ISERROR(MID(B13,ROW(INDIRECT(\"1:\"&LEN(B13))),1)*1)*1),\n0),LEN(B13)-SUM((ISERROR(MID(B13,ROW(INDIRECT(\"1:\"&LEN(B13))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",B13))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B13))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B13))),\"4\"))))))","v":3},"f) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est le tiers de \") & (RANDBETWEEN(M13,N13)*3) & \" ? \"","v":"Quelle est le tiers de 42 ? "},{"$f":"C13","v":"→"},{"$f":"(1*(MID(F13,MATCH(0,(ISERROR(MID(F13,ROW(INDIRECT(\"1:\"&LEN(F13))),1)*1)*1),\n0),LEN(F13)-SUM((ISERROR(MID(F13,ROW(INDIRECT(\"1:\"&LEN(F13))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",F13))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F13))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F13))),\"4\"))))))","v":14},2,4,null,null,12,14]
["b) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est le triple de \") & (RANDBETWEEN(I14,J14)*3) & \" ? \"","v":"Quelle est le triple de 18 ? "},"→",{"$f":"(1*(MID(B14,MATCH(0,(ISERROR(MID(B14,ROW(INDIRECT(\"1:\"&LEN(B14))),1)*1)*1),0),\nLEN(B14)-SUM((ISERROR(MID(B14,ROW(INDIRECT(\"1:\"&LEN(B14))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"double\",B14))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B14))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B14))),\"4\"))))))","v":54},"g) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quel est le triple de \") & (RANDBETWEEN(M14,N14)*3) & \" ? \"","v":"Quel est le triple de 48 ? "},{"$f":"C14","v":"→"},{"$f":"(1*(MID(F14,MATCH(0,(ISERROR(MID(F14,ROW(INDIRECT(\"1:\"&LEN(F14))),1)*1)*1),\n0),LEN(F14)-SUM((ISERROR(MID(F14,ROW(INDIRECT(\"1:\"&LEN(F14))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"double\",F14))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F14))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F14))),\"4\"))))))","v":144},4,6,null,null,14,16]
["c) ",{"$f":" (RANDBETWEEN(I15,J15)*3) & CHOOSE(INT(RAND()*1)+1,\" est le tiers de ?  \")","v":"24 est le tiers de ?  "},"→",{"$f":"(1*(MID(B15,MATCH(0,(ISERROR(MID(B15,ROW(INDIRECT(\"1:\"&LEN(B15))),1)*1)*1),\n0),LEN(B15)-SUM((ISERROR(MID(B15,ROW(INDIRECT(\"1:\"&LEN(B15))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",B15))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B15))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B15))),\"4\"))))))","v":72},"h) ",{"$f":" (RANDBETWEEN(M15,N15)*3) & CHOOSE(INT(RAND()*1)+1,\" est le triple de ?  \")","v":"51 est le triple de ?  "},"→",{"$f":"(1*(MID(F15,MATCH(0,(ISERROR(MID(F15,ROW(INDIRECT(\"1:\"&LEN(F15))),1)*1)*1),\n0),LEN(F15)-SUM((ISERROR(MID(F15,ROW(INDIRECT(\"1:\"&LEN(F15))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"double\",F15))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F15))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F15))),\"4\"))))))","v":17},6,8,null,null,16,18]
["d) ",{"$f":" (RANDBETWEEN(I16,J16)*3) & CHOOSE(INT(RAND()*1)+1,\" est le tiers de ?  \")","v":"27 est le tiers de ?  "},"→",{"$f":"(1*(MID(B16,MATCH(0,(ISERROR(MID(B16,ROW(INDIRECT(\"1:\"&LEN(B16))),1)*1)*1),\n0),LEN(B16)-SUM((ISERROR(MID(B16,ROW(INDIRECT(\"1:\"&LEN(B16))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",B16))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B16))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B16))),\"4\"))))))","v":81},"i) ",{"$f":" (RANDBETWEEN(M16,N16)*3) & CHOOSE(INT(RAND()*1)+1,\" est le tiers de ?  \")","v":"57 est le tiers de ?  "},"→",{"$f":"(1*(MID(F16,MATCH(0,(ISERROR(MID(F16,ROW(INDIRECT(\"1:\"&LEN(F16))),1)*1)*1),\n0),LEN(F16)-SUM((ISERROR(MID(F16,ROW(INDIRECT(\"1:\"&LEN(F16))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",F16))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F16))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F16))),\"4\"))))))","v":171},8,10,null,null,18,20]
["e) ",{"$f":" (RANDBETWEEN(I17,J17)*3) & CHOOSE(INT(RAND()*1)+1,\" est le triple de ?  \")","v":"33 est le triple de ?  "},"→",{"$f":"(1*(MID(B17,MATCH(0,(ISERROR(MID(B17,ROW(INDIRECT(\"1:\"&LEN(B17))),1)*1)*1),\n0),LEN(B17)-SUM((ISERROR(MID(B17,ROW(INDIRECT(\"1:\"&LEN(B17))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"double\",B17))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B17))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B17))),\"4\"))))))","v":11},"j) ",{"$f":" (RANDBETWEEN(M17,N17)*3) & CHOOSE(INT(RAND()*1)+1,\" est le tiers de ?  \")","v":"60 est le tiers de ?  "},"→",{"$f":"(1*(MID(F17,MATCH(0,(ISERROR(MID(F17,ROW(INDIRECT(\"1:\"&LEN(F17))),1)*1)*1),\n0),LEN(F17)-SUM((ISERROR(MID(F17,ROW(INDIRECT(\"1:\"&LEN(F17))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",F17))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F17))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F17))),\"4\"))))))","v":180},10,12,null,null,20,22]
[]
[]
["C. Complète :",null,null,null,null,null,null,null,"Bornes",null,null,null,"Bornes"]
[null,null,null,null,null,null,null,null,"inf","sup",null,null,"inf","sup"]
["a) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est le tiers de \") & (RANDBETWEEN(I22,J22)*3) & \" ? \"","v":"Quelle est le tiers de 63 ? "},"→",{"$f":"(1*(MID(B22,MATCH(0,(ISERROR(MID(B22,ROW(INDIRECT(\"1:\"&LEN(B22))),1)*1)*1),\n0),LEN(B22)-SUM((ISERROR(MID(B22,ROW(INDIRECT(\"1:\"&LEN(B22))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",B22))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B22))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B22))),\"4\"))))))","v":21},"f) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est le tiers de \") & (RANDBETWEEN(M22,N22)*3) & \" ? \"","v":"Quelle est le tiers de 90 ? "},{"$f":"C22","v":"→"},{"$f":"(1*(MID(F22,MATCH(0,(ISERROR(MID(F22,ROW(INDIRECT(\"1:\"&LEN(F22))),1)*1)*1),\n0),LEN(F22)-SUM((ISERROR(MID(F22,ROW(INDIRECT(\"1:\"&LEN(F22))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",F22))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F22))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F22))),\"4\"))))))","v":30},20,22,null,null,30,32]
["b) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est le triple de \") & (RANDBETWEEN(I23,J23)*3) & \" ? \"","v":"Quelle est le triple de 69 ? "},"→",{"$f":"(1*(MID(B23,MATCH(0,(ISERROR(MID(B23,ROW(INDIRECT(\"1:\"&LEN(B23))),1)*1)*1),0),\nLEN(B23)-SUM((ISERROR(MID(B23,ROW(INDIRECT(\"1:\"&LEN(B23))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"double\",B23))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B23))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B23))),\"4\"))))))","v":207},"g) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quel est le triple de \") & (RANDBETWEEN(M23,N23)*3) & \" ? \"","v":"Quel est le triple de 99 ? "},{"$f":"C23","v":"→"},{"$f":"(1*(MID(F23,MATCH(0,(ISERROR(MID(F23,ROW(INDIRECT(\"1:\"&LEN(F23))),1)*1)*1),\n0),LEN(F23)-SUM((ISERROR(MID(F23,ROW(INDIRECT(\"1:\"&LEN(F23))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"double\",F23))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F23))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F23))),\"4\"))))))","v":297},22,24,null,null,32,34]
["c) ",{"$f":" (RANDBETWEEN(I24,J24)*3) & CHOOSE(INT(RAND()*1)+1,\" est le tiers de ?  \")","v":"75 est le tiers de ?  "},"→",{"$f":"(1*(MID(B24,MATCH(0,(ISERROR(MID(B24,ROW(INDIRECT(\"1:\"&LEN(B24))),1)*1)*1),\n0),LEN(B24)-SUM((ISERROR(MID(B24,ROW(INDIRECT(\"1:\"&LEN(B24))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",B24))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B24))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B24))),\"4\"))))))","v":225},"h) ",{"$f":" (RANDBETWEEN(M24,N24)*3) & CHOOSE(INT(RAND()*1)+1,\" est le triple de ?  \")","v":"105 est le triple de ?  "},"→",{"$f":"(1*(MID(F24,MATCH(0,(ISERROR(MID(F24,ROW(INDIRECT(\"1:\"&LEN(F24))),1)*1)*1),\n0),LEN(F24)-SUM((ISERROR(MID(F24,ROW(INDIRECT(\"1:\"&LEN(F24))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"double\",F24))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F24))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F24))),\"4\"))))))","v":35},24,26,null,null,34,36]
["d) ",{"$f":" (RANDBETWEEN(I25,J25)*3) & CHOOSE(INT(RAND()*1)+1,\" est le tiers de ?  \")","v":"81 est le tiers de ?  "},"→",{"$f":"(1*(MID(B25,MATCH(0,(ISERROR(MID(B25,ROW(INDIRECT(\"1:\"&LEN(B25))),1)*1)*1),\n0),LEN(B25)-SUM((ISERROR(MID(B25,ROW(INDIRECT(\"1:\"&LEN(B25))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",B25))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B25))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B25))),\"4\"))))))","v":243},"i) ",{"$f":" (RANDBETWEEN(M25,N25)*3) & CHOOSE(INT(RAND()*1)+1,\" est le tiers de ?  \")","v":"114 est le tiers de ?  "},"→",{"$f":"(1*(MID(F25,MATCH(0,(ISERROR(MID(F25,ROW(INDIRECT(\"1:\"&LEN(F25))),1)*1)*1),\n0),LEN(F25)-SUM((ISERROR(MID(F25,ROW(INDIRECT(\"1:\"&LEN(F25))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",F25))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F25))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F25))),\"4\"))))))","v":342},26,28,null,null,36,38]
["e) ",{"$f":" (RANDBETWEEN(I26,J26)*3) & CHOOSE(INT(RAND()*1)+1,\" est le triple de ?  \")","v":"84 est le triple de ?  "},"→",{"$f":"(1*(MID(B26,MATCH(0,(ISERROR(MID(B26,ROW(INDIRECT(\"1:\"&LEN(B26))),1)*1)*1),\n0),LEN(B26)-SUM((ISERROR(MID(B26,ROW(INDIRECT(\"1:\"&LEN(B26))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"double\",B26))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B26))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B26))),\"4\"))))))","v":28},"j) ",{"$f":" (RANDBETWEEN(M26,N26)*3) & CHOOSE(INT(RAND()*1)+1,\" est le tiers de ?  \")","v":"117 est le tiers de ?  "},"→",{"$f":"(1*(MID(F26,MATCH(0,(ISERROR(MID(F26,ROW(INDIRECT(\"1:\"&LEN(F26))),1)*1)*1),\n0),LEN(F26)-SUM((ISERROR(MID(F26,ROW(INDIRECT(\"1:\"&LEN(F26))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",F26))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F26))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F26))),\"4\"))))))","v":351},28,30,null,null,38,40]
[]
[]
["D. Complète :",null,null,null,null,null,null,null,"Bornes",null,null,null,"Bornes"]
[null,null,null,null,null,null,null,null,"inf","sup",null,null,"inf","sup"]
["a) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est le tiers de \") & (RANDBETWEEN(I31,J31)*3) & \" ? \"","v":"Quelle est le tiers de 60 ? "},"→",{"$f":"(1*(MID(B31,MATCH(0,(ISERROR(MID(B31,ROW(INDIRECT(\"1:\"&LEN(B31))),1)*1)*1),\n0),LEN(B31)-SUM((ISERROR(MID(B31,ROW(INDIRECT(\"1:\"&LEN(B31))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",B31))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B31))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B31))),\"4\"))))))","v":20},"f) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est le tiers de \") & (RANDBETWEEN(M31,N31)*3) & \" ? \"","v":"Quelle est le tiers de 93 ? "},{"$f":"C31","v":"→"},{"$f":"(1*(MID(F31,MATCH(0,(ISERROR(MID(F31,ROW(INDIRECT(\"1:\"&LEN(F31))),1)*1)*1),\n0),LEN(F31)-SUM((ISERROR(MID(F31,ROW(INDIRECT(\"1:\"&LEN(F31))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",F31))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F31))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F31))),\"4\"))))))","v":31},20,22,null,null,30,32]
["b) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est le triple de \") & (RANDBETWEEN(I32,J32)*3) & \" ? \"","v":"Quelle est le triple de 69 ? "},"→",{"$f":"(1*(MID(B32,MATCH(0,(ISERROR(MID(B32,ROW(INDIRECT(\"1:\"&LEN(B32))),1)*1)*1),0),\nLEN(B32)-SUM((ISERROR(MID(B32,ROW(INDIRECT(\"1:\"&LEN(B32))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"double\",B32))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B32))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B32))),\"4\"))))))","v":207},"g) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quel est le triple de \") & (RANDBETWEEN(M32,N32)*3) & \" ? \"","v":"Quel est le triple de 99 ? "},{"$f":"C32","v":"→"},{"$f":"(1*(MID(F32,MATCH(0,(ISERROR(MID(F32,ROW(INDIRECT(\"1:\"&LEN(F32))),1)*1)*1),\n0),LEN(F32)-SUM((ISERROR(MID(F32,ROW(INDIRECT(\"1:\"&LEN(F32))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"double\",F32))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F32))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F32))),\"4\"))))))","v":297},22,24,null,null,32,34]
["c) ",{"$f":" (RANDBETWEEN(I33,J33)*3) & CHOOSE(INT(RAND()*1)+1,\" est le tiers de ?  \")","v":"72 est le tiers de ?  "},"→",{"$f":"(1*(MID(B33,MATCH(0,(ISERROR(MID(B33,ROW(INDIRECT(\"1:\"&LEN(B33))),1)*1)*1),\n0),LEN(B33)-SUM((ISERROR(MID(B33,ROW(INDIRECT(\"1:\"&LEN(B33))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",B33))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B33))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B33))),\"4\"))))))","v":216},"h) ",{"$f":" (RANDBETWEEN(M33,N33)*3) & CHOOSE(INT(RAND()*1)+1,\" est le triple de ?  \")","v":"108 est le triple de ?  "},"→",{"$f":"(1*(MID(F33,MATCH(0,(ISERROR(MID(F33,ROW(INDIRECT(\"1:\"&LEN(F33))),1)*1)*1),\n0),LEN(F33)-SUM((ISERROR(MID(F33,ROW(INDIRECT(\"1:\"&LEN(F33))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"double\",F33))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F33))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F33))),\"4\"))))))","v":36},24,26,null,null,34,36]
["d) ",{"$f":" (RANDBETWEEN(I34,J34)*3) & CHOOSE(INT(RAND()*1)+1,\" est le tiers de ?  \")","v":"78 est le tiers de ?  "},"→",{"$f":"(1*(MID(B34,MATCH(0,(ISERROR(MID(B34,ROW(INDIRECT(\"1:\"&LEN(B34))),1)*1)*1),\n0),LEN(B34)-SUM((ISERROR(MID(B34,ROW(INDIRECT(\"1:\"&LEN(B34))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",B34))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B34))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B34))),\"4\"))))))","v":234},"i) ",{"$f":" (RANDBETWEEN(M34,N34)*3) & CHOOSE(INT(RAND()*1)+1,\" est le tiers de ?  \")","v":"114 est le tiers de ?  "},"→",{"$f":"(1*(MID(F34,MATCH(0,(ISERROR(MID(F34,ROW(INDIRECT(\"1:\"&LEN(F34))),1)*1)*1),\n0),LEN(F34)-SUM((ISERROR(MID(F34,ROW(INDIRECT(\"1:\"&LEN(F34))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",F34))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F34))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F34))),\"4\"))))))","v":342},26,28,null,null,36,38]
["e) ",{"$f":" (RANDBETWEEN(I35,J35)*3) & CHOOSE(INT(RAND()*1)+1,\" est le triple de ?  \")","v":"90 est le triple de ?  "},"→",{"$f":"(1*(MID(B35,MATCH(0,(ISERROR(MID(B35,ROW(INDIRECT(\"1:\"&LEN(B35))),1)*1)*1),\n0),LEN(B35)-SUM((ISERROR(MID(B35,ROW(INDIRECT(\"1:\"&LEN(B35))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"double\",B35))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B35))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B35))),\"4\"))))))","v":30},"j) ",{"$f":" (RANDBETWEEN(M35,N35)*3) & CHOOSE(INT(RAND()*1)+1,\" est le tiers de ?  \")","v":"114 est le tiers de ?  "},"→",{"$f":"(1*(MID(F35,MATCH(0,(ISERROR(MID(F35,ROW(INDIRECT(\"1:\"&LEN(F35))),1)*1)*1),\n0),LEN(F35)-SUM((ISERROR(MID(F35,ROW(INDIRECT(\"1:\"&LEN(F35))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",F35))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F35))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F35))),\"4\"))))))","v":342},28,30,null,null,38,40]
[]
[]
["E. Complète :",null,null,null,null,null,null,null,"Bornes",null,null,null,"Bornes"]
[null,null,null,null,null,null,null,null,"inf","sup",null,null,"inf","sup"]
["a) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est le tiers de \") & (RANDBETWEEN(I40,J40)*3) & \" ? \"","v":"Quelle est le tiers de 60 ? "},"→",{"$f":"(1*(MID(B40,MATCH(0,(ISERROR(MID(B40,ROW(INDIRECT(\"1:\"&LEN(B40))),1)*1)*1),\n0),LEN(B40)-SUM((ISERROR(MID(B40,ROW(INDIRECT(\"1:\"&LEN(B40))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",B40))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B40))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B40))),\"4\"))))))","v":20},"f) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est le tiers de \") & (RANDBETWEEN(M40,N40)*3) & \" ? \"","v":"Quelle est le tiers de 93 ? "},{"$f":"C40","v":"→"},{"$f":"(1*(MID(F40,MATCH(0,(ISERROR(MID(F40,ROW(INDIRECT(\"1:\"&LEN(F40))),1)*1)*1),\n0),LEN(F40)-SUM((ISERROR(MID(F40,ROW(INDIRECT(\"1:\"&LEN(F40))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",F40))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F40))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F40))),\"4\"))))))","v":31},20,22,null,null,30,32]
["b) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est le triple de \") & (RANDBETWEEN(I41,J41)*3) & \" ? \"","v":"Quelle est le triple de 66 ? "},"→",{"$f":"(1*(MID(B41,MATCH(0,(ISERROR(MID(B41,ROW(INDIRECT(\"1:\"&LEN(B41))),1)*1)*1),0),\nLEN(B41)-SUM((ISERROR(MID(B41,ROW(INDIRECT(\"1:\"&LEN(B41))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"double\",B41))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B41))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B41))),\"4\"))))))","v":198},"g) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quel est le triple de \") & (RANDBETWEEN(M41,N41)*3) & \" ? \"","v":"Quel est le triple de 99 ? "},{"$f":"C41","v":"→"},{"$f":"(1*(MID(F41,MATCH(0,(ISERROR(MID(F41,ROW(INDIRECT(\"1:\"&LEN(F41))),1)*1)*1),\n0),LEN(F41)-SUM((ISERROR(MID(F41,ROW(INDIRECT(\"1:\"&LEN(F41))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"double\",F41))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F41))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F41))),\"4\"))))))","v":297},22,24,null,null,32,34]
["c) ",{"$f":" (RANDBETWEEN(I42,J42)*3) & CHOOSE(INT(RAND()*1)+1,\" est le tiers de ?  \")","v":"78 est le tiers de ?  "},"→",{"$f":"(1*(MID(B42,MATCH(0,(ISERROR(MID(B42,ROW(INDIRECT(\"1:\"&LEN(B42))),1)*1)*1),\n0),LEN(B42)-SUM((ISERROR(MID(B42,ROW(INDIRECT(\"1:\"&LEN(B42))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",B42))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B42))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B42))),\"4\"))))))","v":234},"h) ",{"$f":" (RANDBETWEEN(M42,N42)*3) & CHOOSE(INT(RAND()*1)+1,\" est le triple de ?  \")","v":"108 est le triple de ?  "},"→",{"$f":"(1*(MID(F42,MATCH(0,(ISERROR(MID(F42,ROW(INDIRECT(\"1:\"&LEN(F42))),1)*1)*1),\n0),LEN(F42)-SUM((ISERROR(MID(F42,ROW(INDIRECT(\"1:\"&LEN(F42))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"double\",F42))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F42))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F42))),\"4\"))))))","v":36},24,26,null,null,34,36]
["d) ",{"$f":" (RANDBETWEEN(I43,J43)*3) & CHOOSE(INT(RAND()*1)+1,\" est le tiers de ?  \")","v":"81 est le tiers de ?  "},"→",{"$f":"(1*(MID(B43,MATCH(0,(ISERROR(MID(B43,ROW(INDIRECT(\"1:\"&LEN(B43))),1)*1)*1),\n0),LEN(B43)-SUM((ISERROR(MID(B43,ROW(INDIRECT(\"1:\"&LEN(B43))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",B43))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B43))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B43))),\"4\"))))))","v":243},"i) ",{"$f":" (RANDBETWEEN(M43,N43)*3) & CHOOSE(INT(RAND()*1)+1,\" est le tiers de ?  \")","v":"108 est le tiers de ?  "},"→",{"$f":"(1*(MID(F43,MATCH(0,(ISERROR(MID(F43,ROW(INDIRECT(\"1:\"&LEN(F43))),1)*1)*1),\n0),LEN(F43)-SUM((ISERROR(MID(F43,ROW(INDIRECT(\"1:\"&LEN(F43))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",F43))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F43))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F43))),\"4\"))))))","v":324},26,28,null,null,36,38]
["e) ",{"$f":" (RANDBETWEEN(I44,J44)*3) & CHOOSE(INT(RAND()*1)+1,\" est le triple de ?  \")","v":"84 est le triple de ?  "},"→",{"$f":"(1*(MID(B44,MATCH(0,(ISERROR(MID(B44,ROW(INDIRECT(\"1:\"&LEN(B44))),1)*1)*1),\n0),LEN(B44)-SUM((ISERROR(MID(B44,ROW(INDIRECT(\"1:\"&LEN(B44))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"double\",B44))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B44))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B44))),\"4\"))))))","v":28},"j) ",{"$f":" (RANDBETWEEN(M44,N44)*3) & CHOOSE(INT(RAND()*1)+1,\" est le tiers de ?  \")","v":"114 est le tiers de ?  "},"→",{"$f":"(1*(MID(F44,MATCH(0,(ISERROR(MID(F44,ROW(INDIRECT(\"1:\"&LEN(F44))),1)*1)*1),\n0),LEN(F44)-SUM((ISERROR(MID(F44,ROW(INDIRECT(\"1:\"&LEN(F44))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",F44))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F44))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F44))),\"4\"))))))","v":342},28,30,null,null,38,40]
[{"$f":"A1","v":"SAVOIR UTILISER LES MOTS  TIERS / TRIPLE"},0,0,0,0,0,0,0]
["A. Complète :",0,0,0]
[]
["a) ","Quelle est le tiers de 6 ? ","→","…………………","f) ","Quelle est le tiers de 30 ? ","→","…………………"]
["b) ","Quelle est le triple de 9 ? ","→","…………………","g) ","Quel est le triple de 21 ? ","→","…………………"]
["c) ","18 est le tiers de ?  ","→","…………………","h) ","21 est le triple de ?  ","→","…………………"]
["d) ","21 est le tiers de ?  ","→","…………………","i) ","15 est le tiers de ?  ","→","…………………"]
["e) ","27 est le triple de ?  ","→","…………………","j) ","15 est le tiers de ?  ","→","…………………"]
[]
[]
[{"$f":"A11","v":"B. Complète :"},0,0,0]
[]
["a) ","Quelle est le tiers de 9 ? ","→","…………………","f) ","Quelle est le tiers de 42 ? ","→","…………………"]
["b) ","Quelle est le triple de 18 ? ","→","…………………","g) ","Quel est le triple de 48 ? ","→","…………………"]
["c) ","24 est le tiers de ?  ","→","…………………","h) ","51 est le triple de ?  ","→","…………………"]
["d) ","27 est le tiers de ?  ","→","…………………","i) ","57 est le tiers de ?  ","→","…………………"]
["e) ","33 est le triple de ?  ","→","…………………","j) ","60 est le tiers de ?  ","→","…………………"]
[]
[]
["C. Complète :",0,0,0]
[]
[{"$f":"A22","v":"a) "},"Quelle est le tiers de 63 ? ","→","…………………","f) ","Quelle est le tiers de 90 ? ","→","…………………"]
["b) ","Quelle est le triple de 69 ? ","→","…………………","g) ","Quel est le triple de 99 ? ","→","…………………"]
["c) ","75 est le tiers de ?  ","→","…………………","h) ","105 est le triple de ?  ","→","…………………"]
["d) ","81 est le tiers de ?  ","→","…………………","i) ","114 est le tiers de ?  ","→","…………………"]
["e) ","84 est le triple de ?  ","→","…………………","j) ","117 est le tiers de ?  ","→","…………………"]
[]
[]
["D. Complète :",0,0,0]
[]
[{"$f":"A31","v":"a) "},"Quelle est le tiers de 60 ? ","→","…………………","f) ","Quelle est le tiers de 93 ? ","→","…………………"]
["b) ","Quelle est le triple de 69 ? ","→","…………………","g) ","Quel est le triple de 99 ? ","→","…………………"]
["c) ","72 est le tiers de ?  ","→","…………………","h) ","108 est le triple de ?  ","→","…………………"]
["d) ","78 est le tiers de ?  ","→","…………………","i) ","114 est le tiers de ?  ","→","…………………"]
["e) ","90 est le triple de ?  ","→","…………………","j) ","114 est le tiers de ?  ","→","…………………"]
[]
[]
["E. Complète :",0,0,0]
[]
["a) ","Quelle est le tiers de 60 ? ","→","…………………","f) ","Quelle est le tiers de 93 ? ","→","…………………"]
["b) ","Quelle est le triple de 66 ? ","→","…………………","g) ","Quel est le triple de 99 ? ","→","…………………"]
["c) ","78 est le tiers de ?  ","→","…………………","h) ","108 est le triple de ?  ","→","…………………"]
["d) ","81 est le tiers de ?  ","→","…………………","i) ","108 est le tiers de ?  ","→","…………………"]
["e) ","84 est le triple de ?  ","→","…………………","j) ","114 est le tiers de ?  ","→","…………………"]

{"sheet":"5 exo différents (quadruple)","index":3,"n_rows":88,"n_cols":14,"rows_kept":88,"cut":false,"hidden":false,"merged":[[63,0,63,3],[72,0,72,3],[81,0,81,3],[37,0,37,3],[37,8,37,9],[37,12,37,13],[44,0,44,7],[45,0,45,3],[54,0,54,3],[19,0,19,3],[19,8,19,9],[19,12,19,13],[28,0,28,3],[28,8,28,9],[28,12,28,13],[10,0,10,3],[10,8,10,9],[10,12,10,13],[0,0,0,7],[0,8,0,17],[1,0,1,3],[1,8,1,9],[1,12,1,13]]}
["SAVOIR UTILISER LES MOTS  QUART / QUADRUPLE",null,null,null,null,null,null,null,"Ne modifier que les cellules en violet en faisant attention à ce que la borne inf soit inférieure à la borne sup."]
["A. Complète :",null,null,null,null,null,null,null,"Bornes",null,null,null,"Bornes"]
[null,null,null,null,null,null,null,null,"inf","sup",null,null,"inf","sup"]
["a) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est le quart de \") & (RANDBETWEEN(I4,J4)*4) & \" ? \"","v":"Quelle est le quart de 4 ? "},"→",{"$f":"(1*(MID(B4,MATCH(0,(ISERROR(MID(B4,ROW(INDIRECT(\"1:\"&LEN(B4))),1)*1)*1),\n0),LEN(B4)-SUM((ISERROR(MID(B4,ROW(INDIRECT(\"1:\"&LEN(B4))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",B4))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B4))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B4))),\"4\"))))))","v":1},"f) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est le quart de \") & (RANDBETWEEN(M4,N4)*4) & \" ? \"","v":"Quelle est le quart de 40 ? "},{"$f":"C4","v":"→"},{"$f":"(1*(MID(F4,MATCH(0,(ISERROR(MID(F4,ROW(INDIRECT(\"1:\"&LEN(F4))),1)*1)*1),\n0),LEN(F4)-SUM((ISERROR(MID(F4,ROW(INDIRECT(\"1:\"&LEN(F4))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",F4))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F4))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F4))),\"4\"))))))","v":10},1,2,null,null,9,10]
["b) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est le quadruple de \") & (RANDBETWEEN(I5,J5)*4) & \" ? \"","v":"Quelle est le quadruple de 12 ? "},"→",{"$f":"(1*(MID(B5,MATCH(0,(ISERROR(MID(B5,ROW(INDIRECT(\"1:\"&LEN(B5))),1)*1)*1),0),\nLEN(B5)-SUM((ISERROR(MID(B5,ROW(INDIRECT(\"1:\"&LEN(B5))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"double\",B5))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B5))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B5))),\"4\"))))))","v":48},"g) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quel est le quadruple de \") & (RANDBETWEEN(M5,N5)*4) & \" ? \"","v":"Quel est le quadruple de 28 ? "},{"$f":"C5","v":"→"},{"$f":"(1*(MID(F5,MATCH(0,(ISERROR(MID(F5,ROW(INDIRECT(\"1:\"&LEN(F5))),1)*1)*1),\n0),LEN(F5)-SUM((ISERROR(MID(F5,ROW(INDIRECT(\"1:\"&LEN(F5))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"double\",F5))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F5))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F5))),\"4\"))))))","v":112},3,4,null,null,7,8]
["c) ",{"$f":" (RANDBETWEEN(I6,J6)*4) & CHOOSE(INT(RAND()*1)+1,\" est le quart de ?  \")","v":"24 est le quart de ?  "},"→",{"$f":"(1*(MID(B6,MATCH(0,(ISERROR(MID(B6,ROW(INDIRECT(\"1:\"&LEN(B6))),1)*1)*1),\n0),LEN(B6)-SUM((ISERROR(MID(B6,ROW(INDIRECT(\"1:\"&LEN(B6))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",B6))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B6))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B6))),\"4\"))))))","v":96},"h) ",{"$f":" (RANDBETWEEN(M6,N6)*4) & CHOOSE(INT(RAND()*1)+1,\" est le quadruple de ?  \")","v":"28 est le quadruple de ?  "},"→",{"$f":"(1*(MID(F6,MATCH(0,(ISERROR(MID(F6,ROW(INDIRECT(\"1:\"&LEN(F6))),1)*1)*1),\n0),LEN(F6)-SUM((ISERROR(MID(F6,ROW(INDIRECT(\"1:\"&LEN(F6))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"double\",F6))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F6))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F6))),\"4\"))))))","v":7},5,6,null,null,6,7]
["d) ",{"$f":" (RANDBETWEEN(I7,J7)*4) & CHOOSE(INT(RAND()*1)+1,\" est le quart de ?  \")","v":"28 est le quart de ?  "},"→",{"$f":"(1*(MID(B7,MATCH(0,(ISERROR(MID(B7,ROW(INDIRECT(\"1:\"&LEN(B7))),1)*1)*1),\n0),LEN(B7)-SUM((ISERROR(MID(B7,ROW(INDIRECT(\"1:\"&LEN(B7))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",B7))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B7))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B7))),\"4\"))))))","v":112},"i) ",{"$f":" (RANDBETWEEN(M7,N7)*4) & CHOOSE(INT(RAND()*1)+1,\" est le quart de ?  \")","v":"20 est le quart de ?  "},"→",{"$f":"(1*(MID(F7,MATCH(0,(ISERROR(MID(F7,ROW(INDIRECT(\"1:\"&LEN(F7))),1)*1)*1),\n0),LEN(F7)-SUM((ISERROR(MID(F7,ROW(INDIRECT(\"1:\"&LEN(F7))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",F7))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F7))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F7))),\"4\"))))))","v":80},7,8,null,null,5,6]
["e) ",{"$f":" (RANDBETWEEN(I8,J8)*4) & CHOOSE(INT(RAND()*1)+1,\" est le quadruple de ?  \")","v":"40 est le quadruple de ?  "},"→",{"$f":"(1*(MID(B8,MATCH(0,(ISERROR(MID(B8,ROW(INDIRECT(\"1:\"&LEN(B8))),1)*1)*1),\n0),LEN(B8)-SUM((ISERROR(MID(B8,ROW(INDIRECT(\"1:\"&LEN(B8))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"double\",B8))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B8))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B8))),\"4\"))))))","v":10},"j) ",{"$f":" (RANDBETWEEN(M8,N8)*4) & CHOOSE(INT(RAND()*1)+1,\" est le quart de ?  \")","v":"20 est le quart de ?  "},"→",{"$f":"(1*(MID(F8,MATCH(0,(ISERROR(MID(F8,ROW(INDIRECT(\"1:\"&LEN(F8))),1)*1)*1),\n0),LEN(F8)-SUM((ISERROR(MID(F8,ROW(INDIRECT(\"1:\"&LEN(F8))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",F8))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F8))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F8))),\"4\"))))))","v":80},9,10,null,null,4,5]
[]
[]
["B. Complète :",null,null,null,null,null,null,null,"Bornes",null,null,null,"Bornes"]
[null,null,null,null,null,null,null,null,"inf","sup",null,null,"inf","sup"]
["a) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est le quart de \") & (RANDBETWEEN(I13,J13)*4) & \" ? \"","v":"Quelle est le quart de 16 ? "},"→",{"$f":"(1*(MID(B13,MATCH(0,(ISERROR(MID(B13,ROW(INDIRECT(\"1:\"&LEN(B13))),1)*1)*1),\n0),LEN(B13)-SUM((ISERROR(MID(B13,ROW(INDIRECT(\"1:\"&LEN(B13))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",B13))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B13))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B13))),\"4\"))))))","v":4},"f) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est le quart de \") & (RANDBETWEEN(M13,N13)*4) & \" ? \"","v":"Quelle est le quart de 56 ? "},{"$f":"C13","v":"→"},{"$f":"(1*(MID(F13,MATCH(0,(ISERROR(MID(F13,ROW(INDIRECT(\"1:\"&LEN(F13))),1)*1)*1),\n0),LEN(F13)-SUM((ISERROR(MID(F13,ROW(INDIRECT(\"1:\"&LEN(F13))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",F13))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F13))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F13))),\"4\"))))))","v":14},2,4,null,null,12,14]
["b) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est le quadruple de \") & (RANDBETWEEN(I14,J14)*4) & \" ? \"","v":"Quelle est le quadruple de 16 ? "},"→",{"$f":"(1*(MID(B14,MATCH(0,(ISERROR(MID(B14,ROW(INDIRECT(\"1:\"&LEN(B14))),1)*1)*1),0),\nLEN(B14)-SUM((ISERROR(MID(B14,ROW(INDIRECT(\"1:\"&LEN(B14))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"double\",B14))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B14))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B14))),\"4\"))))))","v":64},"g) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quel est le quadruple de \") & (RANDBETWEEN(M14,N14)*4) & \" ? \"","v":"Quel est le quadruple de 64 ? "},{"$f":"C14","v":"→"},{"$f":"(1*(MID(F14,MATCH(0,(ISERROR(MID(F14,ROW(INDIRECT(\"1:\"&LEN(F14))),1)*1)*1),\n0),LEN(F14)-SUM((ISERROR(MID(F14,ROW(INDIRECT(\"1:\"&LEN(F14))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"double\",F14))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F14))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F14))),\"4\"))))))","v":256},4,6,null,null,14,16]
["c) ",{"$f":" (RANDBETWEEN(I15,J15)*4) & CHOOSE(INT(RAND()*1)+1,\" est le quart de ?  \")","v":"28 est le quart de ?  "},"→",{"$f":"(1*(MID(B15,MATCH(0,(ISERROR(MID(B15,ROW(INDIRECT(\"1:\"&LEN(B15))),1)*1)*1),\n0),LEN(B15)-SUM((ISERROR(MID(B15,ROW(INDIRECT(\"1:\"&LEN(B15))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",B15))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B15))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B15))),\"4\"))))))","v":112},"h) ",{"$f":" (RANDBETWEEN(M15,N15)*4) & CHOOSE(INT(RAND()*1)+1,\" est le quadruple de ?  \")","v":"64 est le quadruple de ?  "},"→",{"$f":"(1*(MID(F15,MATCH(0,(ISERROR(MID(F15,ROW(INDIRECT(\"1:\"&LEN(F15))),1)*1)*1),\n0),LEN(F15)-SUM((ISERROR(MID(F15,ROW(INDIRECT(\"1:\"&LEN(F15))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"double\",F15))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F15))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F15))),\"4\"))))))","v":16},6,8,null,null,16,18]
["d) ",{"$f":" (RANDBETWEEN(I16,J16)*4) & CHOOSE(INT(RAND()*1)+1,\" est le quart de ?  \")","v":"32 est le quart de ?  "},"→",{"$f":"(1*(MID(B16,MATCH(0,(ISERROR(MID(B16,ROW(INDIRECT(\"1:\"&LEN(B16))),1)*1)*1),\n0),LEN(B16)-SUM((ISERROR(MID(B16,ROW(INDIRECT(\"1:\"&LEN(B16))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",B16))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B16))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B16))),\"4\"))))))","v":128},"i) ",{"$f":" (RANDBETWEEN(M16,N16)*4) & CHOOSE(INT(RAND()*1)+1,\" est le quart de ?  \")","v":"72 est le quart de ?  "},"→",{"$f":"(1*(MID(F16,MATCH(0,(ISERROR(MID(F16,ROW(INDIRECT(\"1:\"&LEN(F16))),1)*1)*1),\n0),LEN(F16)-SUM((ISERROR(MID(F16,ROW(INDIRECT(\"1:\"&LEN(F16))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",F16))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F16))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F16))),\"4\"))))))","v":288},8,10,null,null,18,20]
["e) ",{"$f":" (RANDBETWEEN(I17,J17)*4) & CHOOSE(INT(RAND()*1)+1,\" est le quadruple de ?  \")","v":"44 est le quadruple de ?  "},"→",{"$f":"(1*(MID(B17,MATCH(0,(ISERROR(MID(B17,ROW(INDIRECT(\"1:\"&LEN(B17))),1)*1)*1),\n0),LEN(B17)-SUM((ISERROR(MID(B17,ROW(INDIRECT(\"1:\"&LEN(B17))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"double\",B17))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B17))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B17))),\"4\"))))))","v":11},"j) ",{"$f":" (RANDBETWEEN(M17,N17)*4) & CHOOSE(INT(RAND()*1)+1,\" est le quart de ?  \")","v":"80 est le quart de ?  "},"→",{"$f":"(1*(MID(F17,MATCH(0,(ISERROR(MID(F17,ROW(INDIRECT(\"1:\"&LEN(F17))),1)*1)*1),\n0),LEN(F17)-SUM((ISERROR(MID(F17,ROW(INDIRECT(\"1:\"&LEN(F17))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",F17))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F17))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F17))),\"4\"))))))","v":320},10,12,null,null,20,22]
[]
[]
["C. Complète :",null,null,null,null,null,null,null,"Bornes",null,null,null,"Bornes"]
[null,null,null,null,null,null,null,null,"inf","sup",null,null,"inf","sup"]
["a) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est le quart de \") & (RANDBETWEEN(I22,J22)*4) & \" ? \"","v":"Quelle est le quart de 84 ? "},"→",{"$f":"(1*(MID(B22,MATCH(0,(ISERROR(MID(B22,ROW(INDIRECT(\"1:\"&LEN(B22))),1)*1)*1),\n0),LEN(B22)-SUM((ISERROR(MID(B22,ROW(INDIRECT(\"1:\"&LEN(B22))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",B22))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B22))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B22))),\"4\"))))))","v":21},"f) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est le quart de \") & (RANDBETWEEN(M22,N22)*4) & \" ? \"","v":"Quelle est le quart de 124 ? "},{"$f":"C22","v":"→"},{"$f":"(1*(MID(F22,MATCH(0,(ISERROR(MID(F22,ROW(INDIRECT(\"1:\"&LEN(F22))),1)*1)*1),\n0),LEN(F22)-SUM((ISERROR(MID(F22,ROW(INDIRECT(\"1:\"&LEN(F22))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",F22))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F22))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F22))),\"4\"))))))","v":31},20,22,null,null,30,32]
["b) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est le quadruple de \") & (RANDBETWEEN(I23,J23)*4) & \" ? \"","v":"Quelle est le quadruple de 96 ? "},"→",{"$f":"(1*(MID(B23,MATCH(0,(ISERROR(MID(B23,ROW(INDIRECT(\"1:\"&LEN(B23))),1)*1)*1),0),\nLEN(B23)-SUM((ISERROR(MID(B23,ROW(INDIRECT(\"1:\"&LEN(B23))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"double\",B23))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B23))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B23))),\"4\"))))))","v":384},"g) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quel est le quadruple de \") & (RANDBETWEEN(M23,N23)*4) & \" ? \"","v":"Quel est le quadruple de 136 ? "},{"$f":"C23","v":"→"},{"$f":"(1*(MID(F23,MATCH(0,(ISERROR(MID(F23,ROW(INDIRECT(\"1:\"&LEN(F23))),1)*1)*1),\n0),LEN(F23)-SUM((ISERROR(MID(F23,ROW(INDIRECT(\"1:\"&LEN(F23))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"double\",F23))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F23))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F23))),\"4\"))))))","v":544},22,24,null,null,32,34]
["c) ",{"$f":" (RANDBETWEEN(I24,J24)*4) & CHOOSE(INT(RAND()*1)+1,\" est le quart de ?  \")","v":"100 est le quart de ?  "},"→",{"$f":"(1*(MID(B24,MATCH(0,(ISERROR(MID(B24,ROW(INDIRECT(\"1:\"&LEN(B24))),1)*1)*1),\n0),LEN(B24)-SUM((ISERROR(MID(B24,ROW(INDIRECT(\"1:\"&LEN(B24))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",B24))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B24))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B24))),\"4\"))))))","v":400},"h) ",{"$f":" (RANDBETWEEN(M24,N24)*4) & CHOOSE(INT(RAND()*1)+1,\" est le quadruple de ?  \")","v":"140 est le quadruple de ?  "},"→",{"$f":"(1*(MID(F24,MATCH(0,(ISERROR(MID(F24,ROW(INDIRECT(\"1:\"&LEN(F24))),1)*1)*1),\n0),LEN(F24)-SUM((ISERROR(MID(F24,ROW(INDIRECT(\"1:\"&LEN(F24))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"double\",F24))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F24))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F24))),\"4\"))))))","v":35},24,26,null,null,34,36]
["d) ",{"$f":" (RANDBETWEEN(I25,J25)*4) & CHOOSE(INT(RAND()*1)+1,\" est le quart de ?  \")","v":"104 est le quart de ?  "},"→",{"$f":"(1*(MID(B25,MATCH(0,(ISERROR(MID(B25,ROW(INDIRECT(\"1:\"&LEN(B25))),1)*1)*1),\n0),LEN(B25)-SUM((ISERROR(MID(B25,ROW(INDIRECT(\"1:\"&LEN(B25))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",B25))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B25))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B25))),\"4\"))))))","v":416},"i) ",{"$f":" (RANDBETWEEN(M25,N25)*4) & CHOOSE(INT(RAND()*1)+1,\" est le quart de ?  \")","v":"148 est le quart de ?  "},"→",{"$f":"(1*(MID(F25,MATCH(0,(ISERROR(MID(F25,ROW(INDIRECT(\"1:\"&LEN(F25))),1)*1)*1),\n0),LEN(F25)-SUM((ISERROR(MID(F25,ROW(INDIRECT(\"1:\"&LEN(F25))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",F25))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F25))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F25))),\"4\"))))))","v":592},26,28,null,null,36,38]
["e) ",{"$f":" (RANDBETWEEN(I26,J26)*4) & CHOOSE(INT(RAND()*1)+1,\" est le quadruple de ?  \")","v":"120 est le quadruple de ?  "},"→",{"$f":"(1*(MID(B26,MATCH(0,(ISERROR(MID(B26,ROW(INDIRECT(\"1:\"&LEN(B26))),1)*1)*1),\n0),LEN(B26)-SUM((ISERROR(MID(B26,ROW(INDIRECT(\"1:\"&LEN(B26))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"double\",B26))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B26))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B26))),\"4\"))))))","v":30},"j) ",{"$f":" (RANDBETWEEN(M26,N26)*4) & CHOOSE(INT(RAND()*1)+1,\" est le quart de ?  \")","v":"152 est le quart de ?  "},"→",{"$f":"(1*(MID(F26,MATCH(0,(ISERROR(MID(F26,ROW(INDIRECT(\"1:\"&LEN(F26))),1)*1)*1),\n0),LEN(F26)-SUM((ISERROR(MID(F26,ROW(INDIRECT(\"1:\"&LEN(F26))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",F26))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F26))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F26))),\"4\"))))))","v":608},28,30,null,null,38,40]
[]
[]
["D. Complète :",null,null,null,null,null,null,null,"Bornes",null,null,null,"Bornes"]
[null,null,null,null,null,null,null,null,"inf","sup",null,null,"inf","sup"]
["a) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est le quart de \") & (RANDBETWEEN(I31,J31)*4) & \" ? \"","v":"Quelle est le quart de 160 ? "},"→",{"$f":"(1*(MID(B31,MATCH(0,(ISERROR(MID(B31,ROW(INDIRECT(\"1:\"&LEN(B31))),1)*1)*1),\n0),LEN(B31)-SUM((ISERROR(MID(B31,ROW(INDIRECT(\"1:\"&LEN(B31))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",B31))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B31))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B31))),\"4\"))))))","v":40},"f) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est le quart de \") & (RANDBETWEEN(M31,N31)*4) & \" ? \"","v":"Quelle est le quart de 124 ? "},{"$f":"C31","v":"→"},{"$f":"(1*(MID(F31,MATCH(0,(ISERROR(MID(F31,ROW(INDIRECT(\"1:\"&LEN(F31))),1)*1)*1),\n0),LEN(F31)-SUM((ISERROR(MID(F31,ROW(INDIRECT(\"1:\"&LEN(F31))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",F31))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F31))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F31))),\"4\"))))))","v":31},40,42,null,null,30,32]
["b) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est le quadruple de \") & (RANDBETWEEN(I32,J32)*4) & \" ? \"","v":"Quelle est le quadruple de 168 ? "},"→",{"$f":"(1*(MID(B32,MATCH(0,(ISERROR(MID(B32,ROW(INDIRECT(\"1:\"&LEN(B32))),1)*1)*1),0),\nLEN(B32)-SUM((ISERROR(MID(B32,ROW(INDIRECT(\"1:\"&LEN(B32))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"double\",B32))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B32))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B32))),\"4\"))))))","v":672},"g) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quel est le quadruple de \") & (RANDBETWEEN(M32,N32)*4) & \" ? \"","v":"Quel est le quadruple de 128 ? "},{"$f":"C32","v":"→"},{"$f":"(1*(MID(F32,MATCH(0,(ISERROR(MID(F32,ROW(INDIRECT(\"1:\"&LEN(F32))),1)*1)*1),\n0),LEN(F32)-SUM((ISERROR(MID(F32,ROW(INDIRECT(\"1:\"&LEN(F32))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"double\",F32))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F32))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F32))),\"4\"))))))","v":512},42,44,null,null,32,34]
["c) ",{"$f":" (RANDBETWEEN(I33,J33)*4) & CHOOSE(INT(RAND()*1)+1,\" est le quart de ?  \")","v":"176 est le quart de ?  "},"→",{"$f":"(1*(MID(B33,MATCH(0,(ISERROR(MID(B33,ROW(INDIRECT(\"1:\"&LEN(B33))),1)*1)*1),\n0),LEN(B33)-SUM((ISERROR(MID(B33,ROW(INDIRECT(\"1:\"&LEN(B33))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",B33))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B33))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B33))),\"4\"))))))","v":704},"h) ",{"$f":" (RANDBETWEEN(M33,N33)*4) & CHOOSE(INT(RAND()*1)+1,\" est le quadruple de ?  \")","v":"136 est le quadruple de ?  "},"→",{"$f":"(1*(MID(F33,MATCH(0,(ISERROR(MID(F33,ROW(INDIRECT(\"1:\"&LEN(F33))),1)*1)*1),\n0),LEN(F33)-SUM((ISERROR(MID(F33,ROW(INDIRECT(\"1:\"&LEN(F33))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"double\",F33))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F33))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F33))),\"4\"))))))","v":34},44,46,null,null,34,36]
["d) ",{"$f":" (RANDBETWEEN(I34,J34)*4) & CHOOSE(INT(RAND()*1)+1,\" est le quart de ?  \")","v":"188 est le quart de ?  "},"→",{"$f":"(1*(MID(B34,MATCH(0,(ISERROR(MID(B34,ROW(INDIRECT(\"1:\"&LEN(B34))),1)*1)*1),\n0),LEN(B34)-SUM((ISERROR(MID(B34,ROW(INDIRECT(\"1:\"&LEN(B34))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",B34))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B34))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B34))),\"4\"))))))","v":752},"i) ",{"$f":" (RANDBETWEEN(M34,N34)*4) & CHOOSE(INT(RAND()*1)+1,\" est le quart de ?  \")","v":"144 est le quart de ?  "},"→",{"$f":"(1*(MID(F34,MATCH(0,(ISERROR(MID(F34,ROW(INDIRECT(\"1:\"&LEN(F34))),1)*1)*1),\n0),LEN(F34)-SUM((ISERROR(MID(F34,ROW(INDIRECT(\"1:\"&LEN(F34))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",F34))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F34))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F34))),\"4\"))))))","v":576},46,48,null,null,36,38]
["e) ",{"$f":" (RANDBETWEEN(I35,J35)*4) & CHOOSE(INT(RAND()*1)+1,\" est le quadruple de ?  \")","v":"192 est le quadruple de ?  "},"→",{"$f":"(1*(MID(B35,MATCH(0,(ISERROR(MID(B35,ROW(INDIRECT(\"1:\"&LEN(B35))),1)*1)*1),\n0),LEN(B35)-SUM((ISERROR(MID(B35,ROW(INDIRECT(\"1:\"&LEN(B35))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"double\",B35))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B35))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B35))),\"4\"))))))","v":48},"j) ",{"$f":" (RANDBETWEEN(M35,N35)*4) & CHOOSE(INT(RAND()*1)+1,\" est le quart de ?  \")","v":"152 est le quart de ?  "},"→",{"$f":"(1*(MID(F35,MATCH(0,(ISERROR(MID(F35,ROW(INDIRECT(\"1:\"&LEN(F35))),1)*1)*1),\n0),LEN(F35)-SUM((ISERROR(MID(F35,ROW(INDIRECT(\"1:\"&LEN(F35))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",F35))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F35))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F35))),\"4\"))))))","v":608},48,50,null,null,38,40]
[]
[]
["E. Complète :",null,null,null,null,null,null,null,"Bornes",null,null,null,"Bornes"]
[null,null,null,null,null,null,null,null,"inf","sup",null,null,"inf","sup"]
["a) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est le quart de \") & (RANDBETWEEN(I40,J40)*4) & \" ? \"","v":"Quelle est le quart de 144 ? "},"→",{"$f":"(1*(MID(B40,MATCH(0,(ISERROR(MID(B40,ROW(INDIRECT(\"1:\"&LEN(B40))),1)*1)*1),\n0),LEN(B40)-SUM((ISERROR(MID(B40,ROW(INDIRECT(\"1:\"&LEN(B40))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",B40))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B40))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B40))),\"4\"))))))","v":36},"f) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est le quart de \") & (RANDBETWEEN(M40,N40)*4) & \" ? \"","v":"Quelle est le quart de 124 ? "},{"$f":"C40","v":"→"},{"$f":"(1*(MID(F40,MATCH(0,(ISERROR(MID(F40,ROW(INDIRECT(\"1:\"&LEN(F40))),1)*1)*1),\n0),LEN(F40)-SUM((ISERROR(MID(F40,ROW(INDIRECT(\"1:\"&LEN(F40))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",F40))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F40))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F40))),\"4\"))))))","v":31},30,40,null,null,30,32]
["b) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quelle est le quadruple de \") & (RANDBETWEEN(I41,J41)*4) & \" ? \"","v":"Quelle est le quadruple de 100 ? "},"→",{"$f":"(1*(MID(B41,MATCH(0,(ISERROR(MID(B41,ROW(INDIRECT(\"1:\"&LEN(B41))),1)*1)*1),0),\nLEN(B41)-SUM((ISERROR(MID(B41,ROW(INDIRECT(\"1:\"&LEN(B41))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"double\",B41))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B41))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B41))),\"4\"))))))","v":400},"g) ",{"$f":"CHOOSE(INT(RAND()*1)+1,\"Quel est le quadruple de \") & (RANDBETWEEN(M41,N41)*4) & \" ? \"","v":"Quel est le quadruple de 132 ? "},{"$f":"C41","v":"→"},{"$f":"(1*(MID(F41,MATCH(0,(ISERROR(MID(F41,ROW(INDIRECT(\"1:\"&LEN(F41))),1)*1)*1),\n0),LEN(F41)-SUM((ISERROR(MID(F41,ROW(INDIRECT(\"1:\"&LEN(F41))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"double\",F41))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F41))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F41))),\"4\"))))))","v":528},20,30,null,null,32,34]
["c) ",{"$f":" (RANDBETWEEN(I42,J42)*4) & CHOOSE(INT(RAND()*1)+1,\" est le quart de ?  \")","v":"80 est le quart de ?  "},"→",{"$f":"(1*(MID(B42,MATCH(0,(ISERROR(MID(B42,ROW(INDIRECT(\"1:\"&LEN(B42))),1)*1)*1),\n0),LEN(B42)-SUM((ISERROR(MID(B42,ROW(INDIRECT(\"1:\"&LEN(B42))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",B42))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B42))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B42))),\"4\"))))))","v":320},"h) ",{"$f":" (RANDBETWEEN(M42,N42)*4) & CHOOSE(INT(RAND()*1)+1,\" est le quadruple de ?  \")","v":"144 est le quadruple de ?  "},"→",{"$f":"(1*(MID(F42,MATCH(0,(ISERROR(MID(F42,ROW(INDIRECT(\"1:\"&LEN(F42))),1)*1)*1),\n0),LEN(F42)-SUM((ISERROR(MID(F42,ROW(INDIRECT(\"1:\"&LEN(F42))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"double\",F42))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F42))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F42))),\"4\"))))))","v":36},10,20,null,null,34,36]
["d) ",{"$f":" (RANDBETWEEN(I43,J43)*4) & CHOOSE(INT(RAND()*1)+1,\" est le quart de ?  \")","v":"52 est le quart de ?  "},"→",{"$f":"(1*(MID(B43,MATCH(0,(ISERROR(MID(B43,ROW(INDIRECT(\"1:\"&LEN(B43))),1)*1)*1),\n0),LEN(B43)-SUM((ISERROR(MID(B43,ROW(INDIRECT(\"1:\"&LEN(B43))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",B43))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B43))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B43))),\"4\"))))))","v":208},"i) ",{"$f":" (RANDBETWEEN(M43,N43)*4) & CHOOSE(INT(RAND()*1)+1,\" est le quart de ?  \")","v":"152 est le quart de ?  "},"→",{"$f":"(1*(MID(F43,MATCH(0,(ISERROR(MID(F43,ROW(INDIRECT(\"1:\"&LEN(F43))),1)*1)*1),\n0),LEN(F43)-SUM((ISERROR(MID(F43,ROW(INDIRECT(\"1:\"&LEN(F43))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",F43))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F43))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F43))),\"4\"))))))","v":608},10,20,null,null,36,38]
["e) ",{"$f":" (RANDBETWEEN(I44,J44)*4) & CHOOSE(INT(RAND()*1)+1,\" est le quadruple de ?  \")","v":"264 est le quadruple de ?  "},"→",{"$f":"(1*(MID(B44,MATCH(0,(ISERROR(MID(B44,ROW(INDIRECT(\"1:\"&LEN(B44))),1)*1)*1),\n0),LEN(B44)-SUM((ISERROR(MID(B44,ROW(INDIRECT(\"1:\"&LEN(B44))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"double\",B44))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B44))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B44))),\"4\"))))))","v":66},"j) ",{"$f":" (RANDBETWEEN(M44,N44)*4) & CHOOSE(INT(RAND()*1)+1,\" est le quart de ?  \")","v":"152 est le quart de ?  "},"→",{"$f":"(1*(MID(F44,MATCH(0,(ISERROR(MID(F44,ROW(INDIRECT(\"1:\"&LEN(F44))),1)*1)*1),\n0),LEN(F44)-SUM((ISERROR(MID(F44,ROW(INDIRECT(\"1:\"&LEN(F44))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",F44))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F44))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F44))),\"4\"))))))","v":608},60,70,null,null,38,40]
[{"$f":"A1","v":"SAVOIR UTILISER LES MOTS  QUART / QUADRUPLE"},0,0,0,0,0,0,0]
["A. Complète :",0,0,0]
[]
["a) ","Quelle est le quart de 4 ? ","→","…………………","f) ","Quelle est le quart de 40 ? ","→","…………………"]
["b) ","Quelle est le quadruple de 12 ? ","→","…………………","g) ","Quel est le quadruple de 28 ? ","→","…………………"]
["c) ","24 est le quart de ?  ","→","…………………","h) ","28 est le quadruple de ?  ","→","…………………"]
["d) ","28 est le quart de ?  ","→","…………………","i) ","20 est le quart de ?  ","→","…………………"]
["e) ","40 est le quadruple de ?  ","→","…………………","j) ","20 est le quart de ?  ","→","…………………"]
[]
[]
[{"$f":"A11","v":"B. Complète :"},0,0,0]
[]
["a) ","Quelle est le quart de 16 ? ","→","…………………","f) ","Quelle est le quart de 56 ? ","→","…………………"]
["b) ","Quelle est le quadruple de 16 ? ","→","…………………","g) ","Quel est le quadruple de 64 ? ","→","…………………"]
["c) ","28 est le quart de ?  ","→","…………………","h) ","64 est le quadruple de ?  ","→","…………………"]
["d) ","32 est le quart de ?  ","→","…………………","i) ","72 est le quart de ?  ","→","…………………"]
["e) ","44 est le quadruple de ?  ","→","…………………","j) ","80 est le quart de ?  ","→","…………………"]
[]
[]
["C. Complète :",0,0,0]
[]
[{"$f":"A22","v":"a) "},"Quelle est le quart de 84 ? ","→","…………………","f) ","Quelle est le quart de 124 ? ","→","…………………"]
["b) ","Quelle est le quadruple de 96 ? ","→","…………………","g) ","Quel est le quadruple de 136 ? ","→","…………………"]
["c) ","100 est le quart de ?  ","→","…………………","h) ","140 est le quadruple de ?  ","→","…………………"]
["d) ","104 est le quart de ?  ","→","…………………","i) ","148 est le quart de ?  ","→","…………………"]
["e) ","120 est le quadruple de ?  ","→","…………………","j) ","152 est le quart de ?  ","→","…………………"]
[]
[]
["D. Complète :",0,0,0]
[]
[{"$f":"A31","v":"a) "},"Quelle est le quart de 160 ? ","→","…………………","f) ","Quelle est le quart de 124 ? ","→","…………………"]
["b) ","Quelle est le quadruple de 168 ? ","→","…………………","g) ","Quel est le quadruple de 128 ? ","→","…………………"]
["c) ","176 est le quart de ?  ","→","…………………","h) ","136 est le quadruple de ?  ","→","…………………"]
["d) ","188 est le quart de ?  ","→","…………………","i) ","144 est le quart de ?  ","→","…………………"]
["e) ","192 est le quadruple de ?  ","→","…………………","j) ","152 est le quart de ?  ","→","…………………"]
[]
[]
["E. Complète :",0,0,0]
[]
["a) ","Quelle est le quart de 144 ? ","→","…………………","f) ","Quelle est le quart de 124 ? ","→","…………………"]
["b) ","Quelle est le quadruple de 100 ? ","→","…………………","g) ","Quel est le quadruple de 132 ? ","→","…………………"]
["c) ","80 est le quart de ?  ","→","…………………","h) ","144 est le quadruple de ?  ","→","…………………"]
["d) ","52 est le quart de ?  ","→","…………………","i) ","152 est le quart de ?  ","→","…………………"]
["e) ","264 est le quadruple de ?  ","→","…………………","j) ","152 est le quart de ?  ","→","…………………"]

{"sheet":"5 exos identiques","index":4,"n_rows":44,"n_cols":14,"rows_kept":44,"cut":false,"hidden":false,"merged":[[37,0,37,3],[37,8,37,9],[37,12,37,13],[19,0,19,3],[19,8,19,9],[19,12,19,13],[28,0,28,3],[28,8,28,9],[28,12,28,13],[10,0,10,3],[10,8,10,9],[10,12,10,13],[0,0,0,7],[0,8,0,17],[1,0,1,3],[1,8,1,9],[1,12,1,13]]}
["SAVOIR UTILISER LES MOTS  MOITIE / DOUBLE - TIERS / TRIPLE - QUART / QUADRUPLE",null,null,null,null,null,null,null,"Ne modifier que les cellules en violet en faisant attention à ce que la borne inf soit inférieure à la borne sup."]
["Complète :",null,null,null,null,null,null,null,"Bornes",null,null,null,"Bornes"]
[null,null,null,null,null,null,null,null,"inf","sup",null,null,"inf","sup"]
[{"$f":"'5 exo différents'!A40","v":"a) "},{"$f":"'5 exo différents'!B40","v":"Quelle est la moitié de 24 ? "},{"$f":"'5 exo différents'!C40","v":"→"},{"$f":"'5 exo différents'!D40","v":"…………………"},{"$f":"'5 exo différents'!E40","v":"f) "},{"$f":"'5 exo différents'!F40","v":"Quel est le tiers de 108 ? "},{"$f":"'5 exo différents'!G40","v":"→"},{"$f":"'5 exo différents'!H40","v":"…………………"},1,2,null,null,9,10]
[{"$f":"'5 exo différents'!A41","v":"b) "},{"$f":"'5 exo différents'!B41","v":"Quel est le triple de 36 ? "},{"$f":"'5 exo différents'!C41","v":"→"},{"$f":"'5 exo différents'!D41","v":"…………………"},{"$f":"'5 exo différents'!E41","v":"g) "},{"$f":"'5 exo différents'!F41","v":"Quel est le quadruple de 96 ? "},{"$f":"'5 exo différents'!G41","v":"→"},{"$f":"'5 exo différents'!H41","v":"…………………"},3,4,null,null,7,8]
[{"$f":"'5 exo différents'!A42","v":"c) "},{"$f":"'5 exo différents'!B42","v":"72 est le quart de ?  "},{"$f":"'5 exo différents'!C42","v":"→"},{"$f":"'5 exo différents'!D42","v":"…………………"},{"$f":"'5 exo différents'!E42","v":"h) "},{"$f":"'5 exo différents'!F42","v":"72 est la moitié de ?  "},{"$f":"'5 exo différents'!G42","v":"→"},{"$f":"'5 exo différents'!H42","v":"…………………"},5,6,null,null,6,7]
[{"$f":"'5 exo différents'!A43","v":"d) "},{"$f":"'5 exo différents'!B43","v":"84 est le triple de ?  "},{"$f":"'5 exo différents'!C43","v":"→"},{"$f":"'5 exo différents'!D43","v":"…………………"},{"$f":"'5 exo différents'!E43","v":"i) "},{"$f":"'5 exo différents'!F43","v":"60 est le triple de ?  "},{"$f":"'5 exo différents'!G43","v":"→"},{"$f":"'5 exo différents'!H43","v":"…………………"},7,8,null,null,5,6]
[{"$f":"'5 exo différents'!A44","v":"e) "},{"$f":"'5 exo différents'!B44","v":"120 est le quadruple de ?  "},{"$f":"'5 exo différents'!C44","v":"→"},{"$f":"'5 exo différents'!D44","v":"…………………"},{"$f":"'5 exo différents'!E44","v":"j) "},{"$f":"'5 exo différents'!F44","v":"48 est le triple de ?  "},{"$f":"'5 exo différents'!G44","v":"→"},{"$f":"'5 exo différents'!H44","v":"…………………"},9,10,null,null,4,5]
[]
[]
[{"$f":"$A$2","v":"Complète :"},null,null,null,null,null,null,null,"Bornes",null,null,null,"Bornes"]
[null,null,null,null,null,null,null,null,"inf","sup",null,null,"inf","sup"]
[{"$f":"'5 exo différents'!A40","v":"a) "},{"$f":"'5 exo différents'!B40","v":"Quelle est la moitié de 24 ? "},{"$f":"'5 exo différents'!C40","v":"→"},{"$f":"'5 exo différents'!D40","v":"…………………"},{"$f":"'5 exo différents'!E40","v":"f) "},{"$f":"'5 exo différents'!F40","v":"Quel est le tiers de 108 ? "},{"$f":"'5 exo différents'!G40","v":"→"},{"$f":"'5 exo différents'!H40","v":"…………………"},1,2,null,null,9,10]
[{"$f":"'5 exo différents'!A41","v":"b) "},{"$f":"'5 exo différents'!B41","v":"Quel est le triple de 36 ? "},{"$f":"'5 exo différents'!C41","v":"→"},{"$f":"'5 exo différents'!D41","v":"…………………"},{"$f":"'5 exo différents'!E41","v":"g) "},{"$f":"'5 exo différents'!F41","v":"Quel est le quadruple de 96 ? "},{"$f":"'5 exo différents'!G41","v":"→"},{"$f":"'5 exo différents'!H41","v":"…………………"},3,4,null,null,7,8]
[{"$f":"'5 exo différents'!A42","v":"c) "},{"$f":"'5 exo différents'!B42","v":"72 est le quart de ?  "},{"$f":"'5 exo différents'!C42","v":"→"},{"$f":"'5 exo différents'!D42","v":"…………………"},{"$f":"'5 exo différents'!E42","v":"h) "},{"$f":"'5 exo différents'!F42","v":"72 est la moitié de ?  "},{"$f":"'5 exo différents'!G42","v":"→"},{"$f":"'5 exo différents'!H42","v":"…………………"},5,6,null,null,6,7]
[{"$f":"'5 exo différents'!A43","v":"d) "},{"$f":"'5 exo différents'!B43","v":"84 est le triple de ?  "},{"$f":"'5 exo différents'!C43","v":"→"},{"$f":"'5 exo différents'!D43","v":"…………………"},{"$f":"'5 exo différents'!E43","v":"i) "},{"$f":"'5 exo différents'!F43","v":"60 est le triple de ?  "},{"$f":"'5 exo différents'!G43","v":"→"},{"$f":"'5 exo différents'!H43","v":"…………………"},7,8,null,null,5,6]
[{"$f":"'5 exo différents'!A44","v":"e) "},{"$f":"'5 exo différents'!B44","v":"120 est le quadruple de ?  "},{"$f":"'5 exo différents'!C44","v":"→"},{"$f":"'5 exo différents'!D44","v":"…………………"},{"$f":"'5 exo différents'!E44","v":"j) "},{"$f":"'5 exo différents'!F44","v":"48 est le triple de ?  "},{"$f":"'5 exo différents'!G44","v":"→"},{"$f":"'5 exo différents'!H44","v":"…………………"},9,10,null,null,4,5]
[]
[]
["Complète :",null,null,null,null,null,null,null,"Bornes",null,null,null,"Bornes"]
[null,null,null,null,null,null,null,null,"inf","sup",null,null,"inf","sup"]
[{"$f":"'5 exo différents'!A40","v":"a) "},{"$f":"'5 exo différents'!B40","v":"Quelle est la moitié de 24 ? "},{"$f":"'5 exo différents'!C40","v":"→"},{"$f":"'5 exo différents'!D40","v":"…………………"},{"$f":"'5 exo différents'!E40","v":"f) "},{"$f":"'5 exo différents'!F40","v":"Quel est le tiers de 108 ? "},{"$f":"'5 exo différents'!G40","v":"→"},{"$f":"'5 exo différents'!H40","v":"…………………"},1,2,null,null,9,10]
[{"$f":"'5 exo différents'!A41","v":"b) "},{"$f":"'5 exo différents'!B41","v":"Quel est le triple de 36 ? "},{"$f":"'5 exo différents'!C41","v":"→"},{"$f":"'5 exo différents'!D41","v":"…………………"},{"$f":"'5 exo différents'!E41","v":"g) "},{"$f":"'5 exo différents'!F41","v":"Quel est le quadruple de 96 ? "},{"$f":"'5 exo différents'!G41","v":"→"},{"$f":"'5 exo différents'!H41","v":"…………………"},3,4,null,null,7,8]
[{"$f":"'5 exo différents'!A42","v":"c) "},{"$f":"'5 exo différents'!B42","v":"72 est le quart de ?  "},{"$f":"'5 exo différents'!C42","v":"→"},{"$f":"'5 exo différents'!D42","v":"…………………"},{"$f":"'5 exo différents'!E42","v":"h) "},{"$f":"'5 exo différents'!F42","v":"72 est la moitié de ?  "},{"$f":"'5 exo différents'!G42","v":"→"},{"$f":"'5 exo différents'!H42","v":"…………………"},5,6,null,null,6,7]
[{"$f":"'5 exo différents'!A43","v":"d) "},{"$f":"'5 exo différents'!B43","v":"84 est le triple de ?  "},{"$f":"'5 exo différents'!C43","v":"→"},{"$f":"'5 exo différents'!D43","v":"…………………"},{"$f":"'5 exo différents'!E43","v":"i) "},{"$f":"'5 exo différents'!F43","v":"60 est le triple de ?  "},{"$f":"'5 exo différents'!G43","v":"→"},{"$f":"'5 exo différents'!H43","v":"…………………"},7,8,null,null,5,6]
[{"$f":"'5 exo différents'!A44","v":"e) "},{"$f":"'5 exo différents'!B44","v":"120 est le quadruple de ?  "},{"$f":"'5 exo différents'!C44","v":"→"},{"$f":"'5 exo différents'!D44","v":"…………………"},{"$f":"'5 exo différents'!E44","v":"j) "},{"$f":"'5 exo différents'!F44","v":"48 est le triple de ?  "},{"$f":"'5 exo différents'!G44","v":"→"},{"$f":"'5 exo différents'!H44","v":"…………………"},9,10,null,null,4,5]
[]
[]
["Complète :",null,null,null,null,null,null,null,"Bornes",null,null,null,"Bornes"]
[null,null,null,null,null,null,null,null,"inf","sup",null,null,"inf","sup"]
[{"$f":"'5 exo différents'!A40","v":"a) "},{"$f":"'5 exo différents'!B40","v":"Quelle est la moitié de 24 ? "},{"$f":"'5 exo différents'!C40","v":"→"},{"$f":"'5 exo différents'!D40","v":"…………………"},{"$f":"'5 exo différents'!E40","v":"f) "},{"$f":"'5 exo différents'!F40","v":"Quel est le tiers de 108 ? "},{"$f":"'5 exo différents'!G40","v":"→"},{"$f":"'5 exo différents'!H40","v":"…………………"},1,2,null,null,9,10]
[{"$f":"'5 exo différents'!A41","v":"b) "},{"$f":"'5 exo différents'!B41","v":"Quel est le triple de 36 ? "},{"$f":"'5 exo différents'!C41","v":"→"},{"$f":"'5 exo différents'!D41","v":"…………………"},{"$f":"'5 exo différents'!E41","v":"g) "},{"$f":"'5 exo différents'!F41","v":"Quel est le quadruple de 96 ? "},{"$f":"'5 exo différents'!G41","v":"→"},{"$f":"'5 exo différents'!H41","v":"…………………"},3,4,null,null,7,8]
[{"$f":"'5 exo différents'!A42","v":"c) "},{"$f":"'5 exo différents'!B42","v":"72 est le quart de ?  "},{"$f":"'5 exo différents'!C42","v":"→"},{"$f":"'5 exo différents'!D42","v":"…………………"},{"$f":"'5 exo différents'!E42","v":"h) "},{"$f":"'5 exo différents'!F42","v":"72 est la moitié de ?  "},{"$f":"'5 exo différents'!G42","v":"→"},{"$f":"'5 exo différents'!H42","v":"…………………"},5,6,null,null,6,7]
[{"$f":"'5 exo différents'!A43","v":"d) "},{"$f":"'5 exo différents'!B43","v":"84 est le triple de ?  "},{"$f":"'5 exo différents'!C43","v":"→"},{"$f":"'5 exo différents'!D43","v":"…………………"},{"$f":"'5 exo différents'!E43","v":"i) "},{"$f":"'5 exo différents'!F43","v":"60 est le triple de ?  "},{"$f":"'5 exo différents'!G43","v":"→"},{"$f":"'5 exo différents'!H43","v":"…………………"},7,8,null,null,5,6]
[{"$f":"'5 exo différents'!A44","v":"e) "},{"$f":"'5 exo différents'!B44","v":"120 est le quadruple de ?  "},{"$f":"'5 exo différents'!C44","v":"→"},{"$f":"'5 exo différents'!D44","v":"…………………"},{"$f":"'5 exo différents'!E44","v":"j) "},{"$f":"'5 exo différents'!F44","v":"48 est le triple de ?  "},{"$f":"'5 exo différents'!G44","v":"→"},{"$f":"'5 exo différents'!H44","v":"…………………"},9,10,null,null,4,5]
[]
[]
["Complète :",null,null,null,null,null,null,null,"Bornes",null,null,null,"Bornes"]
[null,null,null,null,null,null,null,null,"inf","sup",null,null,"inf","sup"]
[{"$f":"'5 exo différents'!A40","v":"a) "},{"$f":"'5 exo différents'!B40","v":"Quelle est la moitié de 24 ? "},{"$f":"'5 exo différents'!C40","v":"→"},{"$f":"'5 exo différents'!D40","v":"…………………"},{"$f":"'5 exo différents'!E40","v":"f) "},{"$f":"'5 exo différents'!F40","v":"Quel est le tiers de 108 ? "},{"$f":"'5 exo différents'!G40","v":"→"},{"$f":"'5 exo différents'!H40","v":"…………………"},1,2,null,null,9,10]
[{"$f":"'5 exo différents'!A41","v":"b) "},{"$f":"'5 exo différents'!B41","v":"Quel est le triple de 36 ? "},{"$f":"'5 exo différents'!C41","v":"→"},{"$f":"'5 exo différents'!D41","v":"…………………"},{"$f":"'5 exo différents'!E41","v":"g) "},{"$f":"'5 exo différents'!F41","v":"Quel est le quadruple de 96 ? "},{"$f":"'5 exo différents'!G41","v":"→"},{"$f":"'5 exo différents'!H41","v":"…………………"},3,4,null,null,7,8]
[{"$f":"'5 exo différents'!A42","v":"c) "},{"$f":"'5 exo différents'!B42","v":"72 est le quart de ?  "},{"$f":"'5 exo différents'!C42","v":"→"},{"$f":"'5 exo différents'!D42","v":"…………………"},{"$f":"'5 exo différents'!E42","v":"h) "},{"$f":"'5 exo différents'!F42","v":"72 est la moitié de ?  "},{"$f":"'5 exo différents'!G42","v":"→"},{"$f":"'5 exo différents'!H42","v":"…………………"},5,6,null,null,6,7]
[{"$f":"'5 exo différents'!A43","v":"d) "},{"$f":"'5 exo différents'!B43","v":"84 est le triple de ?  "},{"$f":"'5 exo différents'!C43","v":"→"},{"$f":"'5 exo différents'!D43","v":"…………………"},{"$f":"'5 exo différents'!E43","v":"i) "},{"$f":"'5 exo différents'!F43","v":"60 est le triple de ?  "},{"$f":"'5 exo différents'!G43","v":"→"},{"$f":"'5 exo différents'!H43","v":"…………………"},7,8,null,null,5,6]
[{"$f":"'5 exo différents'!A44","v":"e) "},{"$f":"'5 exo différents'!B44","v":"120 est le quadruple de ?  "},{"$f":"'5 exo différents'!C44","v":"→"},{"$f":"'5 exo différents'!D44","v":"…………………"},{"$f":"'5 exo différents'!E44","v":"j) "},{"$f":"'5 exo différents'!F44","v":"48 est le triple de ?  "},{"$f":"'5 exo différents'!G44","v":"→"},{"$f":"'5 exo différents'!H44","v":"…………………"},9,10,null,null,4,5]

{"sheet":"5 exos différents type mélangé","index":5,"n_rows":88,"n_cols":17,"rows_kept":88,"cut":false,"hidden":false,"merged":[[10,0,10,3],[10,8,10,9],[10,12,10,13],[0,0,0,7],[0,8,0,17],[1,0,1,3],[1,8,1,9],[1,12,1,13],[37,12,37,13],[44,0,44,7],[45,0,45,3],[54,0,54,3],[19,0,19,3],[19,8,19,9],[19,12,19,13],[28,0,28,3],[28,8,28,9],[28,12,28,13],[63,0,63,3],[72,0,72,3],[81,0,81,3],[37,0,37,3],[37,8,37,9]]}
["SAVOIR UTILISER LES MOTS  MOITIE / DOUBLE - TIERS / TRIPLE - QUART / QUADRUPLE",null,null,null,null,null,null,null,"Ne modifier que les cellules en violet en faisant attention à ce que la borne inf soit inférieure à la borne sup."]
["A. Complète :",null,null,null,null,null,null,null,"Bornes",null,null,null,"Bornes"]
[null,null,null,null,null,null,null,null,"inf","sup",null,null,"inf","sup"]
["a) ",{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quelle est la moitié de \",\"Quel est le tiers de \",\"Quel est le quart de \") & (RANDBETWEEN(I4,J4)*12) & \" ? \"","v":"Quel est le quart de 120 ? "},"→",{"$f":"(1*(MID(B4,MATCH(0,(ISERROR(MID(B4,ROW(INDIRECT(\"1:\"&LEN(B4))),1)*1)*1),\n0),LEN(B4)-SUM((ISERROR(MID(B4,ROW(INDIRECT(\"1:\"&LEN(B4))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",B4))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B4))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B4))),\"4\"))))))","v":30},"f) ",{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quelle est la moitié de \",\"Quel est le tiers de \",\"Quel est le quart de \") & (RANDBETWEEN(M4,N4)*12) & \" ? \"","v":"Quel est le tiers de 24 ? "},{"$f":"C4","v":"→"},{"$f":"(1*(MID(F4,MATCH(0,(ISERROR(MID(F4,ROW(INDIRECT(\"1:\"&LEN(F4))),1)*1)*1),\n0),LEN(F4)-SUM((ISERROR(MID(F4,ROW(INDIRECT(\"1:\"&LEN(F4))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",F4))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F4))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F4))),\"4\"))))))","v":8},9,10,null,null,1,2]
["b) ",{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quel est le double de \",\"Quel est le triple de \",\"Quel est le quadruple de \") & (RANDBETWEEN(I5,J5)*12) & \" ? \"","v":"Quel est le quadruple de 96 ? "},"→",{"$f":"(IF(NOT(ISERROR(SEARCH(\"double\",B5))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B5))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B5))),\"4\"))))*\n1*(MID(B5,MATCH(0,(ISERROR(MID(B5,ROW(INDIRECT(\"1:\"&LEN(B5))),1)*1)*1),\n0),LEN(B5)-SUM((ISERROR(MID(B5,ROW(INDIRECT(\"1:\"&LEN(B5))),1)*1)*1)))\n)","v":384},"g) ",{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quel est le double de \",\"Quel est le triple de \",\"Quel est le quadruple de \") & (RANDBETWEEN(M5,N5)*12) & \" ? \"","v":"Quel est le double de 36 ? "},{"$f":"C5","v":"→"},{"$f":"(IF(NOT(ISERROR(SEARCH(\"double\",F5))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F5))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F5))),\"4\"))))*\n1*(MID(F5,MATCH(0,(ISERROR(MID(F5,ROW(INDIRECT(\"1:\"&LEN(F5))),1)*1)*1),\n0),LEN(F5)-SUM((ISERROR(MID(F5,ROW(INDIRECT(\"1:\"&LEN(F5))),1)*1)*1)))\n)","v":72},7,8,null,null,3,4,null,"FICHE",599]
["c) ",{"$f":" (RANDBETWEEN(I6,J6)*12) & CHOOSE(INT(RAND()*3)+1,\" est la moitié de ?  \",\" est le tiers de ?  \",\" est le quart de ?  \")","v":"72 est la moitié de ?  "},"→",{"$f":"(1*(MID(B6,MATCH(0,(ISERROR(MID(B6,ROW(INDIRECT(\"1:\"&LEN(B6))),1)*1)*1),\n0),LEN(B6)-SUM((ISERROR(MID(B6,ROW(INDIRECT(\"1:\"&LEN(B6))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",B6))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B6))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B6))),\"4\"))))))","v":144},"h) ",{"$f":" (RANDBETWEEN(M6,N6)*12) & CHOOSE(INT(RAND()*3)+1,\" est la moitié de ?  \",\" est le tiers de ?  \",\" est le quart de ?  \")","v":"60 est la moitié de ?  "},"→",{"$f":"(1*(MID(F6,MATCH(0,(ISERROR(MID(F6,ROW(INDIRECT(\"1:\"&LEN(F6))),1)*1)*1),\n0),LEN(F6)-SUM((ISERROR(MID(F6,ROW(INDIRECT(\"1:\"&LEN(F6))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",F6))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F6))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F6))),\"4\"))))))","v":120},6,7,null,null,5,6]
["d) ",{"$f":" (RANDBETWEEN(I7,J7)*12) & CHOOSE(INT(RAND()*3)+1,\" est le double de ?  \",\" est le triple de ?  \",\" est le quadruple de ?  \")","v":"72 est le quadruple de ?  "},"→",{"$f":"1*(MID(B7,MATCH(0,(ISERROR(MID(B7,ROW(INDIRECT(\"1:\"&LEN(B7))),1)*1)*1),\n0),LEN(B7)-SUM((ISERROR(MID(B7,ROW(INDIRECT(\"1:\"&LEN(B7))),1)*1)*1)))\n)/(IF(NOT(ISERROR(SEARCH(\"double\",B7))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B7))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B7))),\"4\"))))","v":18},"i) ",{"$f":" (RANDBETWEEN(M7,N7)*12) & CHOOSE(INT(RAND()*3)+1,\" est le double de ?  \",\" est le triple de ?  \",\" est le quadruple de ?  \")","v":"96 est le triple de ?  "},"→",{"$f":"1*(MID(F7,MATCH(0,(ISERROR(MID(F7,ROW(INDIRECT(\"1:\"&LEN(F7))),1)*1)*1),\n0),LEN(F7)-SUM((ISERROR(MID(F7,ROW(INDIRECT(\"1:\"&LEN(F7))),1)*1)*1)))\n)/(IF(NOT(ISERROR(SEARCH(\"double\",F7))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F7))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F7))),\"4\"))))","v":32},5,6,null,null,7,8]
["e) ",{"$f":" (RANDBETWEEN(I8,J8)*12) & CHOOSE(INT(RAND()*3)+1,\" est le double de ?  \",\" est le triple de ?  \",\" est le quadruple de ?  \")","v":"48 est le triple de ?  "},"→",{"$f":"1*(MID(B8,MATCH(0,(ISERROR(MID(B8,ROW(INDIRECT(\"1:\"&LEN(B8))),1)*1)*1),\n0),LEN(B8)-SUM((ISERROR(MID(B8,ROW(INDIRECT(\"1:\"&LEN(B8))),1)*1)*1)))\n)/(IF(NOT(ISERROR(SEARCH(\"double\",B8))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B8))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B8))),\"4\"))))","v":16},"j) ",{"$f":" (RANDBETWEEN(M8,N8)*12) & CHOOSE(INT(RAND()*3)+1,\" est le double de ?  \",\" est le triple de ?  \",\" est le quadruple de ?  \")","v":"108 est le triple de ?  "},"→",{"$f":"1*(MID(F8,MATCH(0,(ISERROR(MID(F8,ROW(INDIRECT(\"1:\"&LEN(F8))),1)*1)*1),\n0),LEN(F8)-SUM((ISERROR(MID(F8,ROW(INDIRECT(\"1:\"&LEN(F8))),1)*1)*1)))\n)/(IF(NOT(ISERROR(SEARCH(\"double\",F8))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F8))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F8))),\"4\"))))","v":36},4,5,null,null,9,10]
[]
[]
["B. Complète :",null,null,null,null,null,null,null,"Bornes",null,null,null,"Bornes"]
[null,null,null,null,null,null,null,null,"inf","sup",null,null,"inf","sup"]
[{"$f":"A4","v":"a) "},{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quelle est la moitié de \",\"Quel est le tiers de \",\"Quel est le quart de \") & (RANDBETWEEN(I13,J13)*12) & \" ? \"","v":"Quelle est la moitié de 24 ? "},"→",{"$f":"(1*(MID(B13,MATCH(0,(ISERROR(MID(B13,ROW(INDIRECT(\"1:\"&LEN(B13))),1)*1)*1),\n0),LEN(B13)-SUM((ISERROR(MID(B13,ROW(INDIRECT(\"1:\"&LEN(B13))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",B13))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B13))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B13))),\"4\"))))))","v":12},{"$f":"E4","v":"f) "},{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quelle est la moitié de \",\"Quel est le tiers de \",\"Quel est le quart de \") & (RANDBETWEEN(M13,N13)*12) & \" ? \"","v":"Quelle est la moitié de 108 ? "},{"$f":"C13","v":"→"},{"$f":"(1*(MID(F13,MATCH(0,(ISERROR(MID(F13,ROW(INDIRECT(\"1:\"&LEN(F13))),1)*1)*1),\n0),LEN(F13)-SUM((ISERROR(MID(F13,ROW(INDIRECT(\"1:\"&LEN(F13))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",F13))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F13))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F13))),\"4\"))))))","v":54},1,2,null,null,9,10]
["b) ",{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quel est le double de \",\"Quel est le triple de \",\"Quel est le quadruple de \") & (RANDBETWEEN(I14,J14)*12) & \" ? \"","v":"Quel est le quadruple de 48 ? "},"→",{"$f":"(IF(NOT(ISERROR(SEARCH(\"double\",B14))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B14))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B14))),\"4\"))))*\n1*(MID(B14,MATCH(0,(ISERROR(MID(B14,ROW(INDIRECT(\"1:\"&LEN(B14))),1)*1)*1),\n0),LEN(B14)-SUM((ISERROR(MID(B14,ROW(INDIRECT(\"1:\"&LEN(B14))),1)*1)*1)))\n)","v":192},"g) ",{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quel est le double de \",\"Quel est le triple de \",\"Quel est le quadruple de \") & (RANDBETWEEN(M14,N14)*12) & \" ? \"","v":"Quel est le quadruple de 96 ? "},{"$f":"C14","v":"→"},{"$f":"(IF(NOT(ISERROR(SEARCH(\"double\",F14))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F14))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F14))),\"4\"))))*\n1*(MID(F14,MATCH(0,(ISERROR(MID(F14,ROW(INDIRECT(\"1:\"&LEN(F14))),1)*1)*1),\n0),LEN(F14)-SUM((ISERROR(MID(F14,ROW(INDIRECT(\"1:\"&LEN(F14))),1)*1)*1)))\n)","v":384},3,4,null,null,7,8]
["c) ",{"$f":" (RANDBETWEEN(I15,J15)*12) & CHOOSE(INT(RAND()*3)+1,\" est la moitié de ?  \",\" est le tiers de ?  \",\" est le quart de ?  \")","v":"60 est le tiers de ?  "},"→",{"$f":"(1*(MID(B15,MATCH(0,(ISERROR(MID(B15,ROW(INDIRECT(\"1:\"&LEN(B15))),1)*1)*1),\n0),LEN(B15)-SUM((ISERROR(MID(B15,ROW(INDIRECT(\"1:\"&LEN(B15))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",B15))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B15))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B15))),\"4\"))))))","v":180},"h) ",{"$f":" (RANDBETWEEN(M15,N15)*12) & CHOOSE(INT(RAND()*3)+1,\" est la moitié de ?  \",\" est le tiers de ?  \",\" est le quart de ?  \")","v":"84 est le tiers de ?  "},"→",{"$f":"(1*(MID(F15,MATCH(0,(ISERROR(MID(F15,ROW(INDIRECT(\"1:\"&LEN(F15))),1)*1)*1),\n0),LEN(F15)-SUM((ISERROR(MID(F15,ROW(INDIRECT(\"1:\"&LEN(F15))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",F15))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F15))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F15))),\"4\"))))))","v":252},5,6,null,null,6,7]
["d) ",{"$f":" (RANDBETWEEN(I16,J16)*12) & CHOOSE(INT(RAND()*3)+1,\" est le double de ?  \",\" est le triple de ?  \",\" est le quadruple de ?  \")","v":"96 est le triple de ?  "},"→",{"$f":"1*(MID(B16,MATCH(0,(ISERROR(MID(B16,ROW(INDIRECT(\"1:\"&LEN(B16))),1)*1)*1),\n0),LEN(B16)-SUM((ISERROR(MID(B16,ROW(INDIRECT(\"1:\"&LEN(B16))),1)*1)*1)))\n)/(IF(NOT(ISERROR(SEARCH(\"double\",B16))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B16))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B16))),\"4\"))))","v":32},"i) ",{"$f":" (RANDBETWEEN(M16,N16)*12) & CHOOSE(INT(RAND()*3)+1,\" est le double de ?  \",\" est le triple de ?  \",\" est le quadruple de ?  \")","v":"60 est le triple de ?  "},"→",{"$f":"1*(MID(F16,MATCH(0,(ISERROR(MID(F16,ROW(INDIRECT(\"1:\"&LEN(F16))),1)*1)*1),\n0),LEN(F16)-SUM((ISERROR(MID(F16,ROW(INDIRECT(\"1:\"&LEN(F16))),1)*1)*1)))\n)/(IF(NOT(ISERROR(SEARCH(\"double\",F16))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F16))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F16))),\"4\"))))","v":20},7,8,null,null,5,6]
["e) ",{"$f":" (RANDBETWEEN(I17,J17)*12) & CHOOSE(INT(RAND()*3)+1,\" est le double de ?  \",\" est le triple de ?  \",\" est le quadruple de ?  \")","v":"108 est le double de ?  "},"→",{"$f":"1*(MID(B17,MATCH(0,(ISERROR(MID(B17,ROW(INDIRECT(\"1:\"&LEN(B17))),1)*1)*1),\n0),LEN(B17)-SUM((ISERROR(MID(B17,ROW(INDIRECT(\"1:\"&LEN(B17))),1)*1)*1)))\n)/(IF(NOT(ISERROR(SEARCH(\"double\",B17))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B17))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B17))),\"4\"))))","v":54},"j) ",{"$f":" (RANDBETWEEN(M17,N17)*12) & CHOOSE(INT(RAND()*3)+1,\" est le double de ?  \",\" est le triple de ?  \",\" est le quadruple de ?  \")","v":"48 est le quadruple de ?  "},"→",{"$f":"1*(MID(F17,MATCH(0,(ISERROR(MID(F17,ROW(INDIRECT(\"1:\"&LEN(F17))),1)*1)*1),\n0),LEN(F17)-SUM((ISERROR(MID(F17,ROW(INDIRECT(\"1:\"&LEN(F17))),1)*1)*1)))\n)/(IF(NOT(ISERROR(SEARCH(\"double\",F17))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F17))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F17))),\"4\"))))","v":12},9,10,null,null,4,5]
[]
[]
["C. Complète :",null,null,null,null,null,null,null,"Bornes",null,null,null,"Bornes"]
[null,null,null,null,null,null,null,null,"inf","sup",null,null,"inf","sup"]
[{"$f":"A4","v":"a) "},{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quelle est la moitié de \",\"Quel est le tiers de \",\"Quel est le quart de \") & (RANDBETWEEN(I22,J22)*12) & \" ? \"","v":"Quel est le quart de 108 ? "},"→",{"$f":"(1*(MID(B22,MATCH(0,(ISERROR(MID(B22,ROW(INDIRECT(\"1:\"&LEN(B22))),1)*1)*1),\n0),LEN(B22)-SUM((ISERROR(MID(B22,ROW(INDIRECT(\"1:\"&LEN(B22))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",B22))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B22))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B22))),\"4\"))))))","v":27},{"$f":"E4","v":"f) "},{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quelle est la moitié de \",\"Quel est le tiers de \",\"Quel est le quart de \") & (RANDBETWEEN(M22,N22)*12) & \" ? \"","v":"Quel est le tiers de 60 ? "},{"$f":"C22","v":"→"},{"$f":"(1*(MID(F22,MATCH(0,(ISERROR(MID(F22,ROW(INDIRECT(\"1:\"&LEN(F22))),1)*1)*1),\n0),LEN(F22)-SUM((ISERROR(MID(F22,ROW(INDIRECT(\"1:\"&LEN(F22))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",F22))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F22))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F22))),\"4\"))))))","v":20},9,10,null,null,4,10]
["b) ",{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quel est le double de \",\"Quel est le triple de \",\"Quel est le quadruple de \") & (RANDBETWEEN(I23,J23)*12) & \" ? \"","v":"Quel est le double de 48 ? "},"→",{"$f":"(IF(NOT(ISERROR(SEARCH(\"double\",B23))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B23))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B23))),\"4\"))))*\n1*(MID(B23,MATCH(0,(ISERROR(MID(B23,ROW(INDIRECT(\"1:\"&LEN(B23))),1)*1)*1),\n0),LEN(B23)-SUM((ISERROR(MID(B23,ROW(INDIRECT(\"1:\"&LEN(B23))),1)*1)*1)))\n)","v":96},"g) ",{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quel est le double de \",\"Quel est le triple de \",\"Quel est le quadruple de \") & (RANDBETWEEN(M23,N23)*12) & \" ? \"","v":"Quel est le triple de 108 ? "},{"$f":"C23","v":"→"},{"$f":"(IF(NOT(ISERROR(SEARCH(\"double\",F23))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F23))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F23))),\"4\"))))*\n1*(MID(F23,MATCH(0,(ISERROR(MID(F23,ROW(INDIRECT(\"1:\"&LEN(F23))),1)*1)*1),\n0),LEN(F23)-SUM((ISERROR(MID(F23,ROW(INDIRECT(\"1:\"&LEN(F23))),1)*1)*1)))\n)","v":324},2,5,null,null,8,9]
["c) ",{"$f":" (RANDBETWEEN(I24,J24)*12) & CHOOSE(INT(RAND()*3)+1,\" est la moitié de ?  \",\" est le tiers de ?  \",\" est le quart de ?  \")","v":"84 est le quart de ?  "},"→",{"$f":"(1*(MID(B24,MATCH(0,(ISERROR(MID(B24,ROW(INDIRECT(\"1:\"&LEN(B24))),1)*1)*1),\n0),LEN(B24)-SUM((ISERROR(MID(B24,ROW(INDIRECT(\"1:\"&LEN(B24))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",B24))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B24))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B24))),\"4\"))))))","v":336},"h) ",{"$f":" (RANDBETWEEN(M24,N24)*12) & CHOOSE(INT(RAND()*3)+1,\" est la moitié de ?  \",\" est le tiers de ?  \",\" est le quart de ?  \")","v":"84 est le tiers de ?  "},"→",{"$f":"(1*(MID(F24,MATCH(0,(ISERROR(MID(F24,ROW(INDIRECT(\"1:\"&LEN(F24))),1)*1)*1),\n0),LEN(F24)-SUM((ISERROR(MID(F24,ROW(INDIRECT(\"1:\"&LEN(F24))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",F24))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F24))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F24))),\"4\"))))))","v":252},4,7,null,null,7,7]
["d) ",{"$f":" (RANDBETWEEN(I25,J25)*12) & CHOOSE(INT(RAND()*3)+1,\" est le double de ?  \",\" est le triple de ?  \",\" est le quadruple de ?  \")","v":"36 est le double de ?  "},"→",{"$f":"1*(MID(B25,MATCH(0,(ISERROR(MID(B25,ROW(INDIRECT(\"1:\"&LEN(B25))),1)*1)*1),\n0),LEN(B25)-SUM((ISERROR(MID(B25,ROW(INDIRECT(\"1:\"&LEN(B25))),1)*1)*1)))\n)/(IF(NOT(ISERROR(SEARCH(\"double\",B25))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B25))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B25))),\"4\"))))","v":18},"i) ",{"$f":" (RANDBETWEEN(M25,N25)*12) & CHOOSE(INT(RAND()*3)+1,\" est le double de ?  \",\" est le triple de ?  \",\" est le quadruple de ?  \")","v":"72 est le quadruple de ?  "},"→",{"$f":"1*(MID(F25,MATCH(0,(ISERROR(MID(F25,ROW(INDIRECT(\"1:\"&LEN(F25))),1)*1)*1),\n0),LEN(F25)-SUM((ISERROR(MID(F25,ROW(INDIRECT(\"1:\"&LEN(F25))),1)*1)*1)))\n)/(IF(NOT(ISERROR(SEARCH(\"double\",F25))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F25))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F25))),\"4\"))))","v":18},3,6,null,null,6,6]
["e) ",{"$f":" (RANDBETWEEN(I26,J26)*12) & CHOOSE(INT(RAND()*3)+1,\" est le double de ?  \",\" est le triple de ?  \",\" est le quadruple de ?  \")","v":"24 est le double de ?  "},"→",{"$f":"1*(MID(B26,MATCH(0,(ISERROR(MID(B26,ROW(INDIRECT(\"1:\"&LEN(B26))),1)*1)*1),\n0),LEN(B26)-SUM((ISERROR(MID(B26,ROW(INDIRECT(\"1:\"&LEN(B26))),1)*1)*1)))\n)/(IF(NOT(ISERROR(SEARCH(\"double\",B26))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B26))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B26))),\"4\"))))","v":12},"j) ",{"$f":" (RANDBETWEEN(M26,N26)*12) & CHOOSE(INT(RAND()*3)+1,\" est le double de ?  \",\" est le triple de ?  \",\" est le quadruple de ?  \")","v":"60 est le triple de ?  "},"→",{"$f":"1*(MID(F26,MATCH(0,(ISERROR(MID(F26,ROW(INDIRECT(\"1:\"&LEN(F26))),1)*1)*1),\n0),LEN(F26)-SUM((ISERROR(MID(F26,ROW(INDIRECT(\"1:\"&LEN(F26))),1)*1)*1)))\n)/(IF(NOT(ISERROR(SEARCH(\"double\",F26))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F26))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F26))),\"4\"))))","v":20},1,8,null,null,5,5]
[]
[]
["D. Complète :",null,null,null,null,null,null,null,"Bornes",null,null,null,"Bornes"]
[null,null,null,null,null,null,null,null,"inf","sup",null,null,"inf","sup"]
[{"$f":"A4","v":"a) "},{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quelle est la moitié de \",\"Quel est le tiers de \",\"Quel est le quart de \") & (RANDBETWEEN(I31,J31)*12) & \" ? \"","v":"Quel est le quart de 12 ? "},"→",{"$f":"(1*(MID(B31,MATCH(0,(ISERROR(MID(B31,ROW(INDIRECT(\"1:\"&LEN(B31))),1)*1)*1),\n0),LEN(B31)-SUM((ISERROR(MID(B31,ROW(INDIRECT(\"1:\"&LEN(B31))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",B31))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B31))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B31))),\"4\"))))))","v":3},{"$f":"E4","v":"f) "},{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quelle est la moitié de \",\"Quel est le tiers de \",\"Quel est le quart de \") & (RANDBETWEEN(M31,N31)*12) & \" ? \"","v":"Quel est le tiers de 72 ? "},{"$f":"C31","v":"→"},{"$f":"(1*(MID(F31,MATCH(0,(ISERROR(MID(F31,ROW(INDIRECT(\"1:\"&LEN(F31))),1)*1)*1),\n0),LEN(F31)-SUM((ISERROR(MID(F31,ROW(INDIRECT(\"1:\"&LEN(F31))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",F31))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F31))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F31))),\"4\"))))))","v":24},1,1,null,null,6,6]
["b) ",{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quel est le double de \",\"Quel est le triple de \",\"Quel est le quadruple de \") & (RANDBETWEEN(I32,J32)*12) & \" ? \"","v":"Quel est le double de 24 ? "},"→",{"$f":"(IF(NOT(ISERROR(SEARCH(\"double\",B32))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B32))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B32))),\"4\"))))*\n1*(MID(B32,MATCH(0,(ISERROR(MID(B32,ROW(INDIRECT(\"1:\"&LEN(B32))),1)*1)*1),\n0),LEN(B32)-SUM((ISERROR(MID(B32,ROW(INDIRECT(\"1:\"&LEN(B32))),1)*1)*1)))\n)","v":48},"g) ",{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quel est le double de \",\"Quel est le triple de \",\"Quel est le quadruple de \") & (RANDBETWEEN(M32,N32)*12) & \" ? \"","v":"Quel est le double de 84 ? "},{"$f":"C32","v":"→"},{"$f":"(IF(NOT(ISERROR(SEARCH(\"double\",F32))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F32))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F32))),\"4\"))))*\n1*(MID(F32,MATCH(0,(ISERROR(MID(F32,ROW(INDIRECT(\"1:\"&LEN(F32))),1)*1)*1),\n0),LEN(F32)-SUM((ISERROR(MID(F32,ROW(INDIRECT(\"1:\"&LEN(F32))),1)*1)*1)))\n)","v":168},2,2,null,null,7,7]
["c) ",{"$f":" (RANDBETWEEN(I33,J33)*12) & CHOOSE(INT(RAND()*3)+1,\" est la moitié de ?  \",\" est le tiers de ?  \",\" est le quart de ?  \")","v":"36 est le quart de ?  "},"→",{"$f":"(1*(MID(B33,MATCH(0,(ISERROR(MID(B33,ROW(INDIRECT(\"1:\"&LEN(B33))),1)*1)*1),\n0),LEN(B33)-SUM((ISERROR(MID(B33,ROW(INDIRECT(\"1:\"&LEN(B33))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",B33))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B33))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B33))),\"4\"))))))","v":144},"h) ",{"$f":" (RANDBETWEEN(M33,N33)*12) & CHOOSE(INT(RAND()*3)+1,\" est la moitié de ?  \",\" est le tiers de ?  \",\" est le quart de ?  \")","v":"96 est le quart de ?  "},"→",{"$f":"(1*(MID(F33,MATCH(0,(ISERROR(MID(F33,ROW(INDIRECT(\"1:\"&LEN(F33))),1)*1)*1),\n0),LEN(F33)-SUM((ISERROR(MID(F33,ROW(INDIRECT(\"1:\"&LEN(F33))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",F33))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F33))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F33))),\"4\"))))))","v":384},3,3,null,null,8,8]
["d) ",{"$f":" (RANDBETWEEN(I34,J34)*12) & CHOOSE(INT(RAND()*3)+1,\" est le double de ?  \",\" est le triple de ?  \",\" est le quadruple de ?  \")","v":"48 est le triple de ?  "},"→",{"$f":"1*(MID(B34,MATCH(0,(ISERROR(MID(B34,ROW(INDIRECT(\"1:\"&LEN(B34))),1)*1)*1),\n0),LEN(B34)-SUM((ISERROR(MID(B34,ROW(INDIRECT(\"1:\"&LEN(B34))),1)*1)*1)))\n)/(IF(NOT(ISERROR(SEARCH(\"double\",B34))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B34))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B34))),\"4\"))))","v":16},"i) ",{"$f":" (RANDBETWEEN(M34,N34)*12) & CHOOSE(INT(RAND()*3)+1,\" est le double de ?  \",\" est le triple de ?  \",\" est le quadruple de ?  \")","v":"108 est le triple de ?  "},"→",{"$f":"1*(MID(F34,MATCH(0,(ISERROR(MID(F34,ROW(INDIRECT(\"1:\"&LEN(F34))),1)*1)*1),\n0),LEN(F34)-SUM((ISERROR(MID(F34,ROW(INDIRECT(\"1:\"&LEN(F34))),1)*1)*1)))\n)/(IF(NOT(ISERROR(SEARCH(\"double\",F34))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F34))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F34))),\"4\"))))","v":36},4,4,null,null,9,9]
["e) ",{"$f":" (RANDBETWEEN(I35,J35)*12) & CHOOSE(INT(RAND()*3)+1,\" est le double de ?  \",\" est le triple de ?  \",\" est le quadruple de ?  \")","v":"60 est le triple de ?  "},"→",{"$f":"1*(MID(B35,MATCH(0,(ISERROR(MID(B35,ROW(INDIRECT(\"1:\"&LEN(B35))),1)*1)*1),\n0),LEN(B35)-SUM((ISERROR(MID(B35,ROW(INDIRECT(\"1:\"&LEN(B35))),1)*1)*1)))\n)/(IF(NOT(ISERROR(SEARCH(\"double\",B35))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B35))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B35))),\"4\"))))","v":20},"j) ",{"$f":" (RANDBETWEEN(M35,N35)*12) & CHOOSE(INT(RAND()*3)+1,\" est le double de ?  \",\" est le triple de ?  \",\" est le quadruple de ?  \")","v":"120 est le triple de ?  "},"→",{"$f":"1*(MID(F35,MATCH(0,(ISERROR(MID(F35,ROW(INDIRECT(\"1:\"&LEN(F35))),1)*1)*1),\n0),LEN(F35)-SUM((ISERROR(MID(F35,ROW(INDIRECT(\"1:\"&LEN(F35))),1)*1)*1)))\n)/(IF(NOT(ISERROR(SEARCH(\"double\",F35))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F35))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F35))),\"4\"))))","v":40},5,5,null,null,10,10]
[]
[]
["E. Complète :",null,null,null,null,null,null,null,"Bornes",null,null,null,"Bornes"]
[null,null,null,null,null,null,null,null,"inf","sup",null,null,"inf","sup"]
[{"$f":"A4","v":"a) "},{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quelle est la moitié de \",\"Quel est le tiers de \",\"Quel est le quart de \") & (RANDBETWEEN(I40,J40)*12) & \" ? \"","v":"Quelle est la moitié de 24 ? "},"→",{"$f":"(1*(MID(B40,MATCH(0,(ISERROR(MID(B40,ROW(INDIRECT(\"1:\"&LEN(B40))),1)*1)*1),\n0),LEN(B40)-SUM((ISERROR(MID(B40,ROW(INDIRECT(\"1:\"&LEN(B40))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",B40))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B40))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B40))),\"4\"))))))","v":12},{"$f":"E4","v":"f) "},{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quelle est la moitié de \",\"Quel est le tiers de \",\"Quel est le quart de \") & (RANDBETWEEN(M40,N40)*12) & \" ? \"","v":"Quel est le tiers de 84 ? "},{"$f":"C40","v":"→"},{"$f":"(1*(MID(F40,MATCH(0,(ISERROR(MID(F40,ROW(INDIRECT(\"1:\"&LEN(F40))),1)*1)*1),\n0),LEN(F40)-SUM((ISERROR(MID(F40,ROW(INDIRECT(\"1:\"&LEN(F40))),1)*1)*1)))\n/(IF(NOT(ISERROR(SEARCH(\"moitié\",F40))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F40))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F40))),\"4\"))))))","v":28},2,2,null,null,7,7]
["b) ",{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quel est le double de \",\"Quel est le triple de \",\"Quel est le quadruple de \") & (RANDBETWEEN(I41,J41)*12) & \" ? \"","v":"Quel est le quadruple de 36 ? "},"→",{"$f":"(IF(NOT(ISERROR(SEARCH(\"double\",B41))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B41))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B41))),\"4\"))))*\n1*(MID(B41,MATCH(0,(ISERROR(MID(B41,ROW(INDIRECT(\"1:\"&LEN(B41))),1)*1)*1),\n0),LEN(B41)-SUM((ISERROR(MID(B41,ROW(INDIRECT(\"1:\"&LEN(B41))),1)*1)*1)))\n)","v":144},"g) ",{"$f":"CHOOSE(INT(RAND()*3)+1,\"Quel est le double de \",\"Quel est le triple de \",\"Quel est le quadruple de \") & (RANDBETWEEN(M41,N41)*12) & \" ? \"","v":"Quel est le double de 96 ? "},{"$f":"C41","v":"→"},{"$f":"(IF(NOT(ISERROR(SEARCH(\"double\",F41))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F41))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F41))),\"4\"))))*\n1*(MID(F41,MATCH(0,(ISERROR(MID(F41,ROW(INDIRECT(\"1:\"&LEN(F41))),1)*1)*1),\n0),LEN(F41)-SUM((ISERROR(MID(F41,ROW(INDIRECT(\"1:\"&LEN(F41))),1)*1)*1)))\n)","v":192},3,3,null,null,8,8]
["c) ",{"$f":" (RANDBETWEEN(I42,J42)*12) & CHOOSE(INT(RAND()*3)+1,\" est la moitié de ?  \",\" est le tiers de ?  \",\" est le quart de ?  \")","v":"48 est le quart de ?  "},"→",{"$f":"(1*(MID(B42,MATCH(0,(ISERROR(MID(B42,ROW(INDIRECT(\"1:\"&LEN(B42))),1)*1)*1),\n0),LEN(B42)-SUM((ISERROR(MID(B42,ROW(INDIRECT(\"1:\"&LEN(B42))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",B42))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",B42))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",B42))),\"4\"))))))","v":192},"h) ",{"$f":" (RANDBETWEEN(M42,N42)*12) & CHOOSE(INT(RAND()*3)+1,\" est la moitié de ?  \",\" est le tiers de ?  \",\" est le quart de ?  \")","v":"108 est le tiers de ?  "},"→",{"$f":"(1*(MID(F42,MATCH(0,(ISERROR(MID(F42,ROW(INDIRECT(\"1:\"&LEN(F42))),1)*1)*1),\n0),LEN(F42)-SUM((ISERROR(MID(F42,ROW(INDIRECT(\"1:\"&LEN(F42))),1)*1)*1)))\n*(IF(NOT(ISERROR(SEARCH(\"moitié\",F42))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"tiers\",F42))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quart\",F42))),\"4\"))))))","v":324},4,4,null,null,9,9]
["d) ",{"$f":" (RANDBETWEEN(I43,J43)*12) & CHOOSE(INT(RAND()*3)+1,\" est le double de ?  \",\" est le triple de ?  \",\" est le quadruple de ?  \")","v":"60 est le quadruple de ?  "},"→",{"$f":"1*(MID(B43,MATCH(0,(ISERROR(MID(B43,ROW(INDIRECT(\"1:\"&LEN(B43))),1)*1)*1),\n0),LEN(B43)-SUM((ISERROR(MID(B43,ROW(INDIRECT(\"1:\"&LEN(B43))),1)*1)*1)))\n)/(IF(NOT(ISERROR(SEARCH(\"double\",B43))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B43))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B43))),\"4\"))))","v":15},"i) ",{"$f":" (RANDBETWEEN(M43,N43)*12) & CHOOSE(INT(RAND()*3)+1,\" est le double de ?  \",\" est le triple de ?  \",\" est le quadruple de ?  \")","v":"120 est le quadruple de ?  "},"→",{"$f":"1*(MID(F43,MATCH(0,(ISERROR(MID(F43,ROW(INDIRECT(\"1:\"&LEN(F43))),1)*1)*1),\n0),LEN(F43)-SUM((ISERROR(MID(F43,ROW(INDIRECT(\"1:\"&LEN(F43))),1)*1)*1)))\n)/(IF(NOT(ISERROR(SEARCH(\"double\",F43))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F43))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F43))),\"4\"))))","v":30},5,5,null,null,10,10]
["e) ",{"$f":" (RANDBETWEEN(I44,J44)*12) & CHOOSE(INT(RAND()*3)+1,\" est le double de ?  \",\" est le triple de ?  \",\" est le quadruple de ?  \")","v":"12 est le quadruple de ?  "},"→",{"$f":"1*(MID(B44,MATCH(0,(ISERROR(MID(B44,ROW(INDIRECT(\"1:\"&LEN(B44))),1)*1)*1),\n0),LEN(B44)-SUM((ISERROR(MID(B44,ROW(INDIRECT(\"1:\"&LEN(B44))),1)*1)*1)))\n)/(IF(NOT(ISERROR(SEARCH(\"double\",B44))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",B44))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",B44))),\"4\"))))","v":3},"j) ",{"$f":" (RANDBETWEEN(M44,N44)*12) & CHOOSE(INT(RAND()*3)+1,\" est le double de ?  \",\" est le triple de ?  \",\" est le quadruple de ?  \")","v":"72 est le triple de ?  "},"→",{"$f":"1*(MID(F44,MATCH(0,(ISERROR(MID(F44,ROW(INDIRECT(\"1:\"&LEN(F44))),1)*1)*1),\n0),LEN(F44)-SUM((ISERROR(MID(F44,ROW(INDIRECT(\"1:\"&LEN(F44))),1)*1)*1)))\n)/(IF(NOT(ISERROR(SEARCH(\"double\",F44))),\"2\",\nIF(NOT(ISERROR(SEARCH(\"triple\",F44))),\"3\",\nIF(NOT(ISERROR(SEARCH(\"quadruple\",F44))),\"4\"))))","v":24},1,1,null,null,6,6]
[{"$f":"A1","v":"SAVOIR UTILISER LES MOTS  MOITIE / DOUBLE - TIERS / TRIPLE - QUART / QUADRUPLE"},0,0,0,0,0,0,0]
[{"$f":"$A$2","v":"A. Complète :"}]
[]
["a) ","Quel est le quart de 120 ? ","→","…………………","f) ","Quel est le tiers de 24 ? ","→","…………………"]
["b) ","Quel est le quadruple de 96 ? ","→","…………………","g) ","Quel est le double de 36 ? ","→","…………………"]
["c) ","72 est la moitié de ?  ","→","…………………","h) ","60 est la moitié de ?  ","→","…………………"]
["d) ","72 est le quadruple de ?  ","→","…………………","i) ","96 est le triple de ?  ","→","…………………"]
["e) ","48 est le triple de ?  ","→","…………………","j) ","108 est le triple de ?  ","→","…………………"]
[]
[]
[{"$f":"A11","v":"B. Complète :"},0,0,0]
[]
["a) ","Quelle est la moitié de 24 ? ","→","…………………","f) ","Quelle est la moitié de 108 ? ","→","…………………"]
["b) ","Quel est le quadruple de 48 ? ","→","…………………","g) ","Quel est le quadruple de 96 ? ","→","…………………"]
["c) ","60 est le tiers de ?  ","→","…………………","h) ","84 est le tiers de ?  ","→","…………………"]
["d) ","96 est le triple de ?  ","→","…………………","i) ","60 est le triple de ?  ","→","…………………"]
["e) ","108 est le double de ?  ","→","…………………","j) ","48 est le quadruple de ?  ","→","…………………"]
[]
[]
["C. Complète :",0,0,0]
[]
[{"$f":"A22","v":"a) "},"Quel est le quart de 108 ? ","→","…………………","f) ","Quel est le tiers de 60 ? ","→","…………………"]
["b) ","Quel est le double de 48 ? ","→","…………………","g) ","Quel est le triple de 108 ? ","→","…………………"]
["c) ","84 est le quart de ?  ","→","…………………","h) ","84 est le tiers de ?  ","→","…………………"]
["d) ","36 est le double de ?  ","→","…………………","i) ","72 est le quadruple de ?  ","→","…………………"]
["e) ","24 est le double de ?  ","→","…………………","j) ","60 est le triple de ?  ","→","…………………"]
[]
[]
["D. Complète :",0,0,0]
[]
[{"$f":"A31","v":"a) "},"Quel est le quart de 12 ? ","→","…………………","f) ","Quel est le tiers de 72 ? ","→","…………………"]
["b) ","Quel est le double de 24 ? ","→","…………………","g) ","Quel est le double de 84 ? ","→","…………………"]
["c) ","36 est le quart de ?  ","→","…………………","h) ","96 est le quart de ?  ","→","…………………"]
["d) ","48 est le triple de ?  ","→","…………………","i) ","108 est le triple de ?  ","→","…………………"]
["e) ","60 est le triple de ?  ","→","…………………","j) ","120 est le triple de ?  ","→","…………………"]
[]
[]
["E. Complète :",0,0,0]
[]
["a) ","Quelle est la moitié de 24 ? ","→","…………………","f) ","Quel est le tiers de 84 ? ","→","…………………"]
["b) ","Quel est le quadruple de 36 ? ","→","…………………","g) ","Quel est le double de 96 ? ","→","…………………"]
["c) ","48 est le quart de ?  ","→","…………………","h) ","108 est le tiers de ?  ","→","…………………"]
["d) ","60 est le quadruple de ?  ","→","…………………","i) ","120 est le quadruple de ?  ","→","…………………"]
["e) ","12 est le quadruple de ?  ","→","…………………","j) ","72 est le triple de ?  ","→","…………………"]

{"sheet":"5 exos différents type méla (2)","index":6,"n_rows":88,"n_cols":20,"rows_kept":88,"cut":false,"hidden":false,"merged":[[10,0,10,6],[10,14,10,15],[10,18,10,19],[0,0,0,13],[0,14,0,23],[1,0,1,6],[1,14,1,15],[1,18,1,19],[37,18,37,19],[44,0,44,13],[45,0,45,6],[54,0,54,6],[19,0,19,6],[19,14,19,15],[19,18,19,19],[28,0,28,6],[28,14,28,15],[28,18,28,19],[63,0,63,6],[72,0,72,6],[81,0,81,6],[37,0,37,6],[37,14,37,15]]}
["CALCUL MENTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,"Ne modifier que les cellules en violet en faisant attention à ce que la borne inf soit inférieure à la borne sup."]
["A. Complète :",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bornes",null,null,null,"Bornes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"inf","sup",null,null,"inf","sup"]
["a) ",{"$f":"RANDBETWEEN(O4,P4)","v":2},"X",{"$f":"RANDBETWEEN(S4,T4)","v":3},"=",{"$f":"B4*D4","v":6},null,"f) ",{"$f":"RANDBETWEEN(O4,P4)","v":2},"X",{"$f":"RANDBETWEEN(S4,T4)","v":19},"=",{"$f":"I4*K4","v":38},null,2,2,null,null,0,50]
["b) ",{"$f":"RANDBETWEEN(O5,P5)","v":3},"X",{"$f":"RANDBETWEEN(S5,T5)","v":3},"=",{"$f":"B5*D5","v":9},null,"g) ",{"$f":"RANDBETWEEN(O5,P5)","v":3},"X",{"$f":"RANDBETWEEN(S5,T5)","v":3},"=",{"$f":"I5*K5","v":9},null,3,3,null,null,3,3]
["c) ",{"$f":"D6*F6","v":16},"=",{"$f":"RANDBETWEEN(O6,P6)","v":4},"X",{"$f":"RANDBETWEEN(S6,T6)","v":4},null,"h) ",{"$f":"K6*M6","v":16},"=",{"$f":"RANDBETWEEN(O6,P6)","v":4},"X",{"$f":"RANDBETWEEN(S6,T6)","v":4},null,4,4,null,null,4,4]
["d) ",{"$f":"D7*F7","v":25},"=",{"$f":"RANDBETWEEN(O7,P7)","v":5},"X",{"$f":"RANDBETWEEN(S7,T7)","v":5},null,"i) ",{"$f":"K7*M7","v":25},"=",{"$f":"RANDBETWEEN(O7,P7)","v":5},"X",{"$f":"RANDBETWEEN(S7,T7)","v":5},null,5,5,null,null,5,5]
["e) ",{"$f":"RANDBETWEEN(O8,P8)","v":6},"X",{"$f":"RANDBETWEEN(S8,T8)","v":6},"=",{"$f":"B8*D8","v":36},null,"j) ",{"$f":"RANDBETWEEN(O8,P8)","v":6},"X",{"$f":"RANDBETWEEN(S8,T8)","v":6},"=",{"$f":"I8*K8","v":36},null,6,6,null,null,6,6]
[]
[]
["B. Complète :",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bornes",null,null,null,"Bornes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"inf","sup",null,null,"inf","sup"]
[{"$f":"A4","v":"a) "},{"$f":"RANDBETWEEN(O13,P13)","v":2},"X",{"$f":"RANDBETWEEN(S13,T13)","v":10},"=",{"$f":"B13*D13","v":20},null,{"$f":"H4","v":"f) "},{"$f":"RANDBETWEEN(O13,P13)","v":2},"X",{"$f":"RANDBETWEEN(S13,T13)","v":9},"=",{"$f":"I13*K13","v":18},null,1,2,null,null,9,10]
["b) ",{"$f":"RANDBETWEEN(O14,P14)","v":4},"X",{"$f":"RANDBETWEEN(S14,T14)","v":7},"=",{"$f":"B14*D14","v":28},null,"g) ",{"$f":"RANDBETWEEN(O14,P14)","v":3},"X",{"$f":"RANDBETWEEN(S14,T14)","v":8},"=",{"$f":"I14*K14","v":24},null,3,4,null,null,7,8]
["c) ",{"$f":"D15*F15","v":30},"=",{"$f":"RANDBETWEEN(O15,P15)","v":5},"X",{"$f":"RANDBETWEEN(S15,T15)","v":6},null,"h) ",{"$f":"K15*M15","v":30},"=",{"$f":"RANDBETWEEN(O15,P15)","v":5},"X",{"$f":"RANDBETWEEN(S15,T15)","v":6},null,5,6,null,null,6,7]
["d) ",{"$f":"D16*F16","v":35},"=",{"$f":"RANDBETWEEN(O16,P16)","v":7},"X",{"$f":"RANDBETWEEN(S16,T16)","v":5},null,"i) ",{"$f":"K16*M16","v":35},"=",{"$f":"RANDBETWEEN(O16,P16)","v":7},"X",{"$f":"RANDBETWEEN(S16,T16)","v":5},null,7,8,null,null,5,6]
["e) ",{"$f":"RANDBETWEEN(O17,P17)","v":9},"X",{"$f":"RANDBETWEEN(S17,T17)","v":4},"=",{"$f":"B17*D17","v":36},null,"j) ",{"$f":"RANDBETWEEN(O17,P17)","v":9},"X",{"$f":"RANDBETWEEN(S17,T17)","v":4},"=",{"$f":"I17*K17","v":36},null,9,10,null,null,4,5]
[]
[]
["C. Complète :",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bornes",null,null,null,"Bornes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"inf","sup",null,null,"inf","sup"]
[{"$f":"A4","v":"a) "},{"$f":"RANDBETWEEN(O22,P22)","v":10},"X",{"$f":"RANDBETWEEN(S22,T22)","v":5},"=",{"$f":"B22*D22","v":50},null,{"$f":"H4","v":"f) "},{"$f":"RANDBETWEEN(O22,P22)","v":9},"X",{"$f":"RANDBETWEEN(S22,T22)","v":7},"=",{"$f":"I22*K22","v":63},null,9,10,null,null,4,10]
["b) ",{"$f":"RANDBETWEEN(O23,P23)","v":2},"X",{"$f":"RANDBETWEEN(S23,T23)","v":8},"=",{"$f":"B23*D23","v":16},null,"g) ",{"$f":"RANDBETWEEN(O23,P23)","v":3},"X",{"$f":"RANDBETWEEN(S23,T23)","v":8},"=",{"$f":"I23*K23","v":24},null,2,5,null,null,8,9]
["c) ",{"$f":"D24*F24","v":35},"=",{"$f":"RANDBETWEEN(O24,P24)","v":5},"X",{"$f":"RANDBETWEEN(S24,T24)","v":7},null,"h) ",{"$f":"K24*M24","v":28},"=",{"$f":"RANDBETWEEN(O24,P24)","v":4},"X",{"$f":"RANDBETWEEN(S24,T24)","v":7},null,4,7,null,null,7,7]
["d) ",{"$f":"D25*F25","v":30},"=",{"$f":"RANDBETWEEN(O25,P25)","v":5},"X",{"$f":"RANDBETWEEN(S25,T25)","v":6},null,"i) ",{"$f":"K25*M25","v":30},"=",{"$f":"RANDBETWEEN(O25,P25)","v":5},"X",{"$f":"RANDBETWEEN(S25,T25)","v":6},null,3,6,null,null,6,6]
["e) ",{"$f":"RANDBETWEEN(O26,P26)","v":1},"X",{"$f":"RANDBETWEEN(S26,T26)","v":5},"=",{"$f":"B26*D26","v":5},null,"j) ",{"$f":"RANDBETWEEN(O26,P26)","v":6},"X",{"$f":"RANDBETWEEN(S26,T26)","v":5},"=",{"$f":"I26*K26","v":30},null,1,8,null,null,5,5]
[]
[]
["D. Complète :",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bornes",null,null,null,"Bornes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"inf","sup",null,null,"inf","sup"]
[{"$f":"A4","v":"a) "},{"$f":"RANDBETWEEN(O31,P31)","v":1},"X",{"$f":"RANDBETWEEN(S31,T31)","v":6},"=",{"$f":"B31*D31","v":6},null,{"$f":"H4","v":"f) "},{"$f":"RANDBETWEEN(O31,P31)","v":1},"X",{"$f":"RANDBETWEEN(S31,T31)","v":6},"=",{"$f":"I31*K31","v":6},null,1,1,null,null,6,6]
["b) ",{"$f":"RANDBETWEEN(O32,P32)","v":2},"X",{"$f":"RANDBETWEEN(S32,T32)","v":7},"=",{"$f":"B32*D32","v":14},null,"g) ",{"$f":"RANDBETWEEN(O32,P32)","v":2},"X",{"$f":"RANDBETWEEN(S32,T32)","v":7},"=",{"$f":"I32*K32","v":14},null,2,2,null,null,7,7]
["c) ",{"$f":"D33*F33","v":24},"=",{"$f":"RANDBETWEEN(O33,P33)","v":3},"X",{"$f":"RANDBETWEEN(S33,T33)","v":8},null,"h) ",{"$f":"K33*M33","v":24},"=",{"$f":"RANDBETWEEN(O33,P33)","v":3},"X",{"$f":"RANDBETWEEN(S33,T33)","v":8},null,3,3,null,null,8,8]
["d) ",{"$f":"D34*F34","v":36},"=",{"$f":"RANDBETWEEN(O34,P34)","v":4},"X",{"$f":"RANDBETWEEN(S34,T34)","v":9},null,"i) ",{"$f":"K34*M34","v":36},"=",{"$f":"RANDBETWEEN(O34,P34)","v":4},"X",{"$f":"RANDBETWEEN(S34,T34)","v":9},null,4,4,null,null,9,9]
["e) ",{"$f":"RANDBETWEEN(O35,P35)","v":5},"X",{"$f":"RANDBETWEEN(S35,T35)","v":10},"=",{"$f":"B35*D35","v":50},null,"j) ",{"$f":"RANDBETWEEN(O35,P35)","v":5},"X",{"$f":"RANDBETWEEN(S35,T35)","v":10},"=",{"$f":"I35*K35","v":50},null,5,5,null,null,10,10]
[]
[]
["E. Complète :",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bornes",null,null,null,"Bornes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"inf","sup",null,null,"inf","sup"]
[{"$f":"A4","v":"a) "},{"$f":"RANDBETWEEN(O40,P40)","v":2},"X",{"$f":"RANDBETWEEN(S40,T40)","v":7},"=",{"$f":"B40*D40","v":14},null,{"$f":"H4","v":"f) "},{"$f":"RANDBETWEEN(O40,P40)","v":2},"X",{"$f":"RANDBETWEEN(S40,T40)","v":7},"=",{"$f":"I40*K40","v":14},null,2,2,null,null,7,7]
["b) ",{"$f":"RANDBETWEEN(O41,P41)","v":3},"X",{"$f":"RANDBETWEEN(S41,T41)","v":8},"=",{"$f":"B41*D41","v":24},null,"g) ",{"$f":"RANDBETWEEN(O41,P41)","v":3},"X",{"$f":"RANDBETWEEN(S41,T41)","v":8},"=",{"$f":"I41*K41","v":24},null,3,3,null,null,8,8]
["c) ",{"$f":"D42*F42","v":36},"=",{"$f":"RANDBETWEEN(O42,P42)","v":4},"X",{"$f":"RANDBETWEEN(S42,T42)","v":9},null,"h) ",{"$f":"K42*M42","v":36},"=",{"$f":"RANDBETWEEN(O42,P42)","v":4},"X",{"$f":"RANDBETWEEN(S42,T42)","v":9},null,4,4,null,null,9,9]
["d) ",{"$f":"D43*F43","v":50},"=",{"$f":"RANDBETWEEN(O43,P43)","v":5},"X",{"$f":"RANDBETWEEN(S43,T43)","v":10},null,"i) ",{"$f":"K43*M43","v":50},"=",{"$f":"RANDBETWEEN(O43,P43)","v":5},"X",{"$f":"RANDBETWEEN(S43,T43)","v":10},null,5,5,null,null,10,10]
["e) ",{"$f":"RANDBETWEEN(O44,P44)","v":1},"X",{"$f":"RANDBETWEEN(S44,T44)","v":6},"=",{"$f":"B44*D44","v":6},null,"j) ",{"$f":"RANDBETWEEN(O44,P44)","v":1},"X",{"$f":"RANDBETWEEN(S44,T44)","v":6},"=",{"$f":"I44*K44","v":6},null,1,1,null,null,6,6]
[{"$f":"A1","v":"CALCUL MENTAL"}]
[{"$f":"$A$2","v":"A. Complète :"}]
[]
[{"$f":"A4","v":"a) "},2,"X",3,"=",6,0,"f) ",2,"X",19,"=",38]
[{"$f":"A5","v":"b) "},3,"X",3,"=",9,0,"g) ",3,"X",3,"=",9]
[{"$f":"A6","v":"c) "},16,"=",4,"X",4,0,"h) ",16,"=",4,"X",4]
[{"$f":"A7","v":"d) "},25,"=",5,"X",5,0,"i) ",25,"=",5,"X",5]
[{"$f":"A8","v":"e) "},6,"X",6,"=",36,0,"j) ",6,"X",6,"=",36]
[]
[]
[{"$f":"A11","v":"B. Complète :"},0,null,null,null,0,0]
[]
[{"$f":"A13","v":"a) "},2,"X",10,"=",20,0,"f) ",2,"X",9,"=",18]
[{"$f":"A14","v":"b) "},4,"X",7,"=",28,0,"g) ",3,"X",8,"=",24]
[{"$f":"A15","v":"c) "},30,"=",5,"X",6,0,"h) ",30,"=",5,"X",6]
[{"$f":"A16","v":"d) "},35,"=",7,"X",5,0,"i) ",35,"=",7,"X",5]
[{"$f":"A17","v":"e) "},9,"X",4,"=",36,0,"j) ",9,"X",4,"=",36]
[]
[]
["C. Complète :",0,null,null,null,0,0]
[]
[{"$f":"A22","v":"a) "},10,"X",5,"=",50,0,"f) ",9,"X",7,"=",63]
[{"$f":"A23","v":"b) "},2,"X",8,"=",16,0,"g) ",3,"X",8,"=",24]
[{"$f":"A24","v":"c) "},35,"=",5,"X",7,0,"h) ",28,"=",4,"X",7]
[{"$f":"A25","v":"d) "},30,"=",5,"X",6,0,"i) ",30,"=",5,"X",6]
[{"$f":"A26","v":"e) "},1,"X",5,"=",5,0,"j) ",6,"X",5,"=",30]
[]
[]
[{"$f":"A29","v":"D. Complète :"},0,null,null,null,0,0]
[]
[{"$f":"A31","v":"a) "},1,"X",6,"=",6,0,"f) ",1,"X",6,"=",6]
[{"$f":"A32","v":"b) "},2,"X",7,"=",14,0,"g) ",2,"X",7,"=",14]
[{"$f":"A33","v":"c) "},24,"=",3,"X",8,0,"h) ",24,"=",3,"X",8]
[{"$f":"A34","v":"d) "},36,"=",4,"X",9,0,"i) ",36,"=",4,"X",9]
[{"$f":"A35","v":"e) "},5,"X",10,"=",50,0,"j) ",5,"X",10,"=",50]
[]
[]
[{"$f":"A38","v":"E. Complète :"},0,null,null,null,0,0]
[]
[{"$f":"A40","v":"a) "},2,"X",7,"=",14,0,"f) ",2,"X",7,"=",14]
[{"$f":"A41","v":"b) "},3,"X",8,"=",24,0,"g) ",3,"X",8,"=",24]
[{"$f":"A42","v":"c) "},36,"=",4,"X",9,0,"h) ",36,"=",4,"X",9]
[{"$f":"A43","v":"d) "},50,"=",5,"X",10,0,"i) ",50,"=",5,"X",10]
[{"$f":"A44","v":"e) "},1,"X",6,"=",6,0,"j) ",1,"X",6,"=",6]

{"sheet":"Formules","index":7,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["formule 34",{"$f":"1*(MID(A1,MATCH(0,(ISERROR(MID(A1,ROW(INDIRECT(\"1:\"&LEN(A1))),1)*1)*1),0),LEN(A1)-SUM((ISERROR(MID(A1,ROW(INDIRECT(\"1:\"&LEN(A1))),1)*1)*1))))","v":34}]
["formule 35 à valider avec crl+ majuscule + entrée",{"$f":"1*(MID(A2,MATCH(0,(ISERROR(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1)*1)*1),0),LEN(A2)-SUM((ISERROR(MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1)*1)*1))))","v":35}]