{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["xsymbol","xcolor","La-Chaine","Griffith","WeiPara","Stat","Expr","AbsRel","Mobile-VQEc","ExpFonctions"],"not_rendered":{"charts":1,"images":10,"macros":1,"external_links":0,"defined_names":280,"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":"xsymbol","index":0,"n_rows":66,"n_cols":18,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,"SYMBOLE","CODE CLAVIER","CODE HTML ISO","CODE HTML NOMMÉ","DESCRIPTION"]
[null,null,"&alpha;","$\\\\alpha\\\\$",{"$f":"CONCATENATE(\":%s/\",C6,\"/\",D6,\"/gie\")","v":":%s/&alpha;/$\\\\alpha\\\\$/gie"},"&#945;","&alpha;","Alpha minuscule",null,null,null,"SYMBOLE","CODE CLAVIER","CODE HTML ISO","CODE HTML NOMMÉ","DESCRIPTION"]
[null,null,"&beta;","$\\\\beta\\\\$",":%s/&beta;/$\\\\beta\\\\$/gie","&#946;","&beta;","Beta minuscule",null,null,null,"!","Alt+ 33","&#33;","aucun","Point d'exclamation",null,{"$f":"CONCATENATE(\":%s/\",N7,\"/\",L7,\"/gie\")","v":":%s/&#33;/!/gie"}]
[null,null,"&gamma;","$\\\\gamma\\\\$",":%s/&gamma;/$\\\\gamma\\\\$/gie","&#947;","&gamma;","Gamma minuscule",null,null,null,"\"","Alt+ 34","&#34;","&quot;","Guillemets à l'anglaise",null,":%s/&#34;/\"/gie"]
[null,null,"&delta;","$\\\\delta\\\\$",":%s/&delta;/$\\\\delta\\\\$/gie","&#948;","&delta;","Delta minuscule",null,null,null,"#","Alt+ 35","&#35;","aucun","Dièse / Numéro",null,":%s/&#35;/#/gie"]
[null,null,"&epsilon;","$\\\\epsilon\\\\$",":%s/&epsilon;/$\\\\epsilon\\\\$/gie","&#949;","&epsilon;","Epsilon minuscule",null,null,null,"$","Alt+ 36","&#36;","&dollar;","Dollar",null,":%s/&#36;/$/gie"]
[null,null,"&zeta;","$\\\\zeta\\\\$",":%s/&zeta;/$\\\\zeta\\\\$/gie","&#950;","&zeta;","Zeta minuscule",null,null,null,"\\\\%","Alt+ 37","&#37;","aucun","Pourcent",null,":%s/&#37;/\\\\%/gie"]
[null,null,"&eta;","$\\\\eta\\\\$",":%s/&eta;/$\\\\eta\\\\$/gie","&#951;","&eta;","Eta minuscule",null,null,null,"\\\\&","Alt+ 38","&#38;","&amp;","Esperluette",null,":%s/&#38;/\\\\&/gie"]
[null,null,"&theta;","$\\\\theta\\\\$",":%s/&theta;/$\\\\theta\\\\$/gie","&#952;","&theta;","Theta minuscule",null,null,null,"'","Alt+ 39","&#39;","&apos;","Apostrophe",null,":%s/&#39;/'/gie"]
[null,null,"&iota;","$\\\\iota\\\\$",":%s/&iota;/$\\\\iota\\\\$/gie","&#953;","&iota;","Iota minuscule",null,null,null,"(","Alt+ 40","&#40;","aucun","Parenthèse gauche",null,":%s/&#40;/(/gie"]
[null,null,"&kappa;","$\\\\kappa\\\\$",":%s/&kappa;/$\\\\kappa\\\\$/gie","&#954;","&kappa;","Kappa minuscule",null,null,null,")","Alt+ 41","&#41;","aucun","Parenthèse droite",null,":%s/&#41;/)/gie"]
[null,null,"&lambda;","$\\\\lambda\\\\$",":%s/&lambda;/$\\\\lambda\\\\$/gie","&#955;","&lambda;","Lambda minuscule",null,null,null,"*","Alt+ 42","&#42;","aucun","Astérisque",null,":%s/&#42;/*/gie"]
[null,null,"&mu;","$\\\\mu\\\\$",":%s/&mu;/$\\\\mu\\\\$/gie","&#956;","&mu;","Mu minuscule",null,null,null,"+","Alt+ 43","&#43;","aucun","Plus",null,":%s/&#43;/+/gie"]
[null,null,"&nu;","$\\\\nu\\\\$",":%s/&nu;/$\\\\nu\\\\$/gie","&#957;","&nu;","Nu minuscule",null,null,null,",","Alt+ 44","&#44;","aucun","Virgule",null,":%s/&#44;/,/gie"]
[null,null,"&xi;","$\\\\xi\\\\$",":%s/&xi;/$\\\\xi\\\\$/gie","&#958;","&xi;","Xi minuscule",null,null,null,"-","Alt+ 45","&#45;","aucun","Moins",null,":%s/&#45;/-/gie"]
[null,null,"&omicron;","$\\\\omicron\\\\$",":%s/&omicron;/$\\\\omicron\\\\$/gie","&#959;","&omicron;","Omicron minuscule",null,null,null,".","Alt+ 46","&#46;","aucun","Point",null,":%s/&#46;/./gie"]
[null,null,"&pi;","$\\\\pi\\\\$",":%s/&pi;/$\\\\pi\\\\$/gie","&#960;","&pi;","Pi minuscule",null,null,null,"\\/","Alt+ 47","&#47;","aucun","Barre oblique (slash)",null,":%s/&#47;/\\//gie"]
[null,null,"&rho;","$\\\\rho\\\\$",":%s/&rho;/$\\\\rho\\\\$/gie","&#961;","&rho;","Rho minuscule",null,null,null,":","Alt+ 58","&#58;","aucun","Double point",null,":%s/&#58;/:/gie"]
[null,null,"&sigma;","$\\\\sigma\\\\$",":%s/&sigma;/$\\\\sigma\\\\$/gie","&#963;","&sigma;","Sigma minuscule",null,null,null,";","Alt+ 59","&#59;","aucun","Point-virgule",null,":%s/&#59;/;/gie"]
[null,null,"&tau;","$\\\\tau\\\\$",":%s/&tau;/$\\\\tau\\\\$/gie","&#964;","&tau;","Tau minuscule",null,null,null,"<","Alt+ 60","&#60;","&lt;","Signe inférieur",null,":%s/&#60;/</gie"]
[null,null,"&upsilon;","$\\\\upsilon\\\\$",":%s/&upsilon;/$\\\\upsilon\\\\$/gie","&#965;","&upsilon;","Upsilon minuscule",null,null,null,"=","Alt+ 60","&#61;","aucun","Égal",null,":%s/&#61;/=/gie"]
[null,null,"&phi;","$\\\\phi\\\\$",":%s/&phi;/$\\\\phi\\\\$/gie","&#966;","&phi;","Phi minuscule",null,null,null,">","Alt+ 62","&#62;","&gt;","Signe supérieur",null,":%s/&#62;/>/gie"]
[null,null,"&chi;","$\\\\chi\\\\$",":%s/&chi;/$\\\\chi\\\\$/gie","&#967;","&chi;","Chi minuscule",null,null,null,"?","Alt+ 63","&#63;","aucun","Point d'interrogation",null,":%s/&#63;/?/gie"]
[null,null,"&psi;","$\\\\psi\\\\$",":%s/&psi;/$\\\\psi\\\\$/gie","&#968;","&psi;","Psi minuscule",null,null,null,"@","Alt+ 64","&#64;","aucun","Arobase",null,":%s/&#64;/@/gie"]
[null,null,"&omega;","$\\\\omega\\\\$",":%s/&omega;/$\\\\omega\\\\$/gie","&#969;","&omega;","Omega minuscule",null,null,null,"[","Alt+ 91","&#91;","aucun","Crochet gauche",null,":%s/&#91;/[/gie"]
[null,null,"&Alpha;","$\\\\Alpha\\\\$",":%s/&Alpha;/$\\\\Alpha\\\\$/gie","&#913;","&Alpha;","Alpha majuscule",null,null,null,"\\\\","Alt+ 92","&#92;","aucun","Barre oblique inversée",null,":%s/&#92;/\\\\/gie"]
[null,null,"&Beta;","$\\\\Beta\\\\$",":%s/&Beta;/$\\\\Beta\\\\$/gie","&#914;","&Beta;","Beta majuscule",null,null,null,"]","Alt+ 93","&#93;","aucun","Crochet droit",null,":%s/&#93;/]/gie"]
[null,null,"&Gamma;","$\\\\Gamma\\\\$",":%s/&Gamma;/$\\\\Gamma\\\\$/gie","&#915;","&Gamma;","Gamma majuscule",null,null,null,"^","Alt+ 94","&#94;","aucun","Accent circonflexe",null,":%s/&#94;/^/gie"]
[null,null,"&Delta;","$\\\\Delta\\\\$",":%s/&Delta;/$\\\\Delta\\\\$/gie","&#916;","&Delta;","Delta majuscule",null,null,null,"\\_","Alt+ 95","&#95;","aucun","Tiret bas (underscore)",null,":%s/&#95;/\\_/gie"]
[null,null,"&Epsilon;","$\\\\Epsilon\\\\$",":%s/&Epsilon;/$\\\\Epsilon\\\\$/gie","&#917;","&Epsilon;","Epsilon majuscule",null,null,null,"`","Alt+ 96","&#96;","aucun","Accent grave",null,":%s/&#96;/`/gie"]
[null,null,"&Zeta;","$\\\\Zeta\\\\$",":%s/&Zeta;/$\\\\Zeta\\\\$/gie","&#918;","&Zeta;","Zeta majuscule",null,null,null,"{","Alt+ 123","&#123;","aucun","Accolade gauche",null,":%s/&#123;/{/gie"]
[null,null,"&Eta;","$\\\\Eta\\\\$",":%s/&Eta;/$\\\\Eta\\\\$/gie","&#919;","&Eta;","Eta majuscule",null,null,null,"|","Alt+ 124","&#124;","aucun","Barre verticale",null,":%s/&#124;/|/gie"]
[null,null,"&Theta;","$\\\\Theta\\\\$",":%s/&Theta;/$\\\\Theta\\\\$/gie","&#920;","&Theta;","Theta majuscule",null,null,null,"}","Alt+ 125","&#125;","aucun","Accolade droite",null,":%s/&#125;/}/gie"]
[null,null,"&Iota;","$\\\\Iota\\\\$",":%s/&Iota;/$\\\\Iota\\\\$/gie","&#921;","&Iota;","Iota majuscule",null,null,null,"~","Alt+ 126","&#126;","aucun","Tilde",null,":%s/&#126;/~/gie"]
[null,null,"&Kappa;","$\\\\Kappa\\\\$",":%s/&Kappa;/$\\\\Kappa\\\\$/gie","&#922;","&Kappa;","Kappa majuscule",null,null,null,"¡","Alt+ 161","&#161;","&iexcl;","Point d'exclamation inversé",null,{"$f":"CONCATENATE(\":%s/\",N39,\"/\",L39,\"/gie\")","v":":%s/&#161;/¡/gie"}]
[null,null,"&Lambda;","$\\\\Lambda\\\\$",":%s/&Lambda;/$\\\\Lambda\\\\$/gie","&#923;","&Lambda;","Lambda majuscule",null,null,null,"¦","Alt+ 166","&#166;","&brvbar;","Barre cassée verticale",null,":%s/&#166;/¦/gie"]
[null,null,"&Mu;","$\\\\Mu\\\\$",":%s/&Mu;/$\\\\Mu\\\\$/gie","&#924;","&Mu;","Mu majuscule",null,null,null,"§","Alt+ 167","&#167;","&sect;","Paragraphe",null,":%s/&#167;/§/gie"]
[null,null,"&Nu;","$\\\\Nu\\\\$",":%s/&Nu;/$\\\\Nu\\\\$/gie","&#925;","&Nu;","Nu majuscule",null,null,null,"¨","Alt+ 168","&#168;","&uml;","Diaérèse",null,":%s/&#168;/¨/gie"]
[null,null,"&Xi;","$\\\\Xi\\\\$",":%s/&Xi;/$\\\\Xi\\\\$/gie","&#926;","&Xi;","Xi majuscule",null,null,null,"©","Alt+ 169","&#169;","&copy;","Signe de copyright",null,":%s/&#169;/©/gie"]
[null,null,"&Omicron;","$\\\\Omicron\\\\$",":%s/&Omicron;/$\\\\Omicron\\\\$/gie","&#927;","&Omicron;","Omicron majuscule",null,null,null,"ª","Alt+ 170","&#170;","&ordf;","Indicateur ordinal féminin",null,":%s/&#170;/ª/gie"]
[null,null,"&Pi;","$\\\\Pi\\\\$",":%s/&Pi;/$\\\\Pi\\\\$/gie","&#928;","&Pi;","Pi majuscule",null,null,null,"«","Alt+ 171","&#171;","&laquo;","Guillemets à la française (ouverts)",null,":%s/&#171;/«/gie"]
[null,null,"&Rho;","$\\\\Rho\\\\$",":%s/&Rho;/$\\\\Rho\\\\$/gie","&#929;","&Rho;","Rho majuscule",null,null,null,"®","Alt+ 174","&#174;","&reg;","Signe de marque déposée (Registered)",null,":%s/&#174;/®/gie"]
[null,null,"&Sigma;","$\\\\Sigma\\\\$",":%s/&Sigma;/$\\\\Sigma\\\\$/gie","&#931;","&Sigma;","Sigma majuscule",null,null,null,"¯","Alt+ 175","&#175;","&macr;","Macron",null,":%s/&#175;/¯/gie"]
[null,null,"&Tau;","$\\\\Tau\\\\$",":%s/&Tau;/$\\\\Tau\\\\$/gie","&#932;","&Tau;","Tau majuscule",null,null,null,"°","Alt+ 176","&#176;","&deg;","Degré",null,":%s/&#176;/°/gie"]
[null,null,"&Upsilon;","$\\\\Upsilon\\\\$",":%s/&Upsilon;/$\\\\Upsilon\\\\$/gie","&#933;","&Upsilon;","Upsilon majuscule",null,null,null,"±","Alt+ 177","&#177;","&plusmn;","Signe plus-moins",null,":%s/&#177;/±/gie"]
[null,null,"&Phi;","$\\\\Phi\\\\$",":%s/&Phi;/$\\\\Phi\\\\$/gie","&#934;","&Phi;","Phi majuscule",null,null,null,"²","Alt+ 178","&#178;","&sup2;","Exposant deux",null,":%s/&#178;/²/gie"]
[null,null,"&Chi;","$\\\\Chi\\\\$",":%s/&Chi;/$\\\\Chi\\\\$/gie","&#935;","&Chi;","Chi majuscule",null,null,null,"³","Alt+ 179","&#179;","&sup3;","Exposant trois",null,":%s/&#179;/³/gie"]
[null,null,"&Psi;","$\\\\Psi\\\\$",":%s/&Psi;/$\\\\Psi\\\\$/gie","&#936;","&Psi;","Psi majuscule",null,null,null,"´","Alt+ 180","&#180;","&aigu;","Accent aigu",null,":%s/&#180;/´/gie"]
[null,null,"&Omega;","$\\\\Omega\\\\$",":%s/&Omega;/$\\\\Omega\\\\$/gie","&#937;","&Omega;","Omega majuscule",null,null,null,"µ","Alt+ 181","&#181;","&micro;","Micro",null,":%s/&#181;/µ/gie"]
[null,null,null,null,null,null,null,null,null,null,null,"·","Alt+ 183","&#183;","&middot;","Point médian",null,":%s/&#183;/·/gie"]
[null,null,null,null,null,null,null,null,null,null,null,"¹","Alt+ 185","&#185;","&sup1;","Exposant un",null,":%s/&#185;/¹/gie"]
[null,null,null,null,null,null,null,null,null,null,null,"º","Alt+ 186","&#186;","&ordm;","Indicateur ordinal masculin",null,":%s/&#186;/º/gie"]
[null,null,null,null,null,null,null,null,null,null,null,"»","Alt+ 187","&#187;","&raquo;","Guillemets à la française (fermés)",null,":%s/&#187;/»/gie"]
[null,null,null,null,null,null,null,null,null,null,null,"¼","Alt+ 188","&#188;","&frac14;","Fraction un quart",null,":%s/&#188;/¼/gie"]
[null,null,null,null,null,null,null,null,null,null,null,"½","Alt+ 189","&#189;","&frac12;","Fraction un demi",null,":%s/&#189;/½/gie"]
[null,null,null,null,null,null,null,null,null,null,null,"¾","Alt+ 190","&#190;","&frac34;","Fraction trois quarts",null,":%s/&#190;/¾/gie"]
[null,null,null,null,null,null,null,null,null,null,null,"¿","Alt+ 191","&#191","&iquest;","Point d'interrogation inversé",null,":%s/&#191/¿/gie"]
[null,null,null,null,null,null,null,null,null,null,null,"×","Alt+ 215","&#215","&times;","Signe de multiplication",null,":%s/&#215/×/gie"]
[null,null,null,null,null,null,null,null,null,null,null,"÷","Alt+ 247","&#247","&divide;","Signe de division",null,":%s/&#247/÷/gie"]
[null,null,null,null,null,null,null,null,null,null,null,"∞","Alt+ 8734","&#8734;","&infin;","Infini",null,":%s/&#8734;/∞/gie"]
[null,null,null,null,null,null,null,null,null,null,null,"‰","Alt+ 8240","&#8240;","&permil;","Pour mille",null,":%s/&#8240;/‰/gie"]
[null,null,null,null,null,null,null,null,null,null,null,"\\\\textsuperscript{TM}","Alt+ 8482","&#8482;","&trade;","Signe de marque déposée (Registered Trademark)",null,":%s/&#8482;/\\\\textsuperscript{TM}/gie"]

{"sheet":"xcolor","index":1,"n_rows":67,"n_cols":34,"rows_kept":67,"cut":false,"hidden":false,"merged":[[24,17,25,18],[26,17,26,18]]}
[1,29,null,1,{"$f":"CHAR( D1)","v":"\u0001"},34,{"$f":"CHAR( F1)","v":"\""},67,{"$f":"CHAR( H1)","v":"C"},100,{"$f":"CHAR( J1)","v":"d"},133,{"$f":"CHAR( L1)","v":"…"},166,{"$f":"CHAR( N1)","v":"¦"},199,{"$f":"CHAR( P1)","v":"Ç"},232,{"$f":"CHAR( R1)","v":"è"},"POUR VIM : ","Accent","Aspect","LaTeX","HTML","méta","compose",null,null,null,"Nom de l'accent","Lettre","HTML"]
[2,30,null,2,"\u0002",35,{"$f":"CHAR( F2)","v":"#"},68,{"$f":"CHAR( H2)","v":"D"},101,{"$f":"CHAR( J2)","v":"e"},134,{"$f":"CHAR( L2)","v":"†"},167,{"$f":"CHAR( N2)","v":"§"},200,{"$f":"CHAR( P2)","v":"È"},233,{"$f":"CHAR( R2)","v":"é"},{"$f":"CONCATENATE(\":%s/\",V2,\"/\\\",W2,\"/ge\")","v":":%s/\u0015/\\/ge"},"paragraphe","\u0015",null,"&para;","M-'","C s o",null,null,null,"a accent grave","à","&agrave;","à",{"$f":"CONCATENATE(\":%s/\",AF2,\"/\",AG2,\"/gie\")","v":":%s/&agrave;/à/gie"}]
[3,31,null,3,"\u0003",36,{"$f":"CHAR( F3)","v":"$"},69,"E",102,{"$f":"CHAR( J3)","v":"f"},135,{"$f":"CHAR( L3)","v":"‡"},168,{"$f":"CHAR( N3)","v":"¨"},201,{"$f":"CHAR( P3)","v":"É"},234,"ê",{"$f":"CONCATENATE(\":%s/\",V3,\"/\\\",W3,\"/ge\")","v":":%s/«/\\<</ge"},"guillemet français ouvrant","«","<<","&laquo;","M-+","C < <",null,null,null,"A accent grave","À","&Agrave;","À",{"$f":"CONCATENATE(\":%s/\",AF3,\"/\",AG3,\"/gie\")","v":":%s/&Agrave;/À/gie"}]
[4,32,null,4,"\u0004",37,"%",70,"F",103,{"$f":"CHAR( J4)","v":"g"},136,{"$f":"CHAR( L4)","v":"ˆ"},169,{"$f":"CHAR( N4)","v":"©"},202,{"$f":"CHAR( P4)","v":"Ê"},235,"ë",":%s/»/\\>>/ge","guillemet français fermant","»",">>","&raquo;","M-;","C > >",null,null,null,"a accent aigu","á","&aacute;","á",":%s/&aacute;/á/gie"]
[5,33,null,5,"\u0005",38,"&",71,"G",104,{"$f":"CHAR( J5)","v":"h"},137,{"$f":"CHAR( L5)","v":"‰"},170,{"$f":"CHAR( N5)","v":"ª"},203,{"$f":"CHAR( P5)","v":"Ë"},236,"ì",":%s/á/\\\\'a/ge","a accent aigu","á","\\'a","&aacute;","M-a","C ' a",null,null,null,"A accent aigu","Á","&Aacute;","Á",":%s/&Aacute;/Á/gie"]
[6,34,null,6,"\u0006",39,"'",72,"H",105,{"$f":"CHAR( J6)","v":"i"},138,{"$f":"CHAR( L6)","v":"Š"},171,{"$f":"CHAR( N6)","v":"«"},204,{"$f":"CHAR( P6)","v":"Ì"},237,"í",":%s/à/\\\\`a/ge","a accent grave","à","\\`a","&agrave;","M-`","C ` a",null,null,null,"a accent circonflexe","â","&acirc;","â",":%s/&acirc;/â/gie"]
[7,35,null,7,"\u0007",40,"(",73,"I",106,{"$f":"CHAR( J7)","v":"j"},139,{"$f":"CHAR( L7)","v":"‹"},172,{"$f":"CHAR( N7)","v":"¬"},205,{"$f":"CHAR( P7)","v":"Í"},238,"î",":%s/â/\\\\^a/ge","a accent circonflexe","â","\\^a","&acirc;","M-b","C ^ a",null,null,null,"A accent circonflexe","Â","&Acirc;","Â",":%s/&Acirc;/Â/gie"]
[8,36,null,8,"\b",41,")",74,"J",107,{"$f":"CHAR( J8)","v":"k"},140,{"$f":"CHAR( L8)","v":"Œ"},173,{"$f":"CHAR( N8)","v":"­"},206,{"$f":"CHAR( P8)","v":"Î"},239,"ï",":%s/ä/\\\\\"a/ge","a tréma","ä","\\\"a","&auml;","M-d","C \" a",null,null,null,"a tilde","ã","&atilde;","ã",":%s/&atilde;/ã/gie"]
[9,37,null,9,"\t",42,"*",75,"K",108,{"$f":"CHAR( J9)","v":"l"},141,{"$f":"CHAR( L9)","v":"\u008d"},174,{"$f":"CHAR( N9)","v":"®"},207,{"$f":"CHAR( P9)","v":"Ï"},240,"ð",":%s/Ä/\\\\\"A/ge","A tréma","Ä","\\\"A","&Auml;","M-D","C \" A",null,null,null,"A tilde","Ã","&Atilde;","Ã",":%s/&Atilde;/Ã/gie"]
[10,38,null,10,"\n",43,"+",76,"L",109,{"$f":"CHAR( J10)","v":"m"},142,{"$f":"CHAR( L10)","v":"Ž"},175,{"$f":"CHAR( N10)","v":"¯"},208,{"$f":"CHAR( P10)","v":"Ð"},241,"ñ",":%s/å/\\\\aa/ge","a rond","å","\\aa","&aring;","M-e","C * a",null,null,null,"a tréma","ä","&auml;","ä",":%s/&auml;/ä/gie"]
[11,39,null,11,"\u000b",44,",",77,"M",110,{"$f":"CHAR( J11)","v":"n"},143,{"$f":"CHAR( L11)","v":"\u008f"},176,{"$f":"CHAR( N11)","v":"°"},209,{"$f":"CHAR( P11)","v":"Ñ"},242,"ò",":%s/Å/\\\\AA/ge","A rond","Å","\\AA","&Aring;","M-E","C * A",null,null,null,"A tréma","Ä","&Auml;","Ä",":%s/&Auml;/Ä/gie"]
[12,40,null,12,"\f",45,"-",78,"N",111,{"$f":"CHAR( J12)","v":"o"},144,{"$f":"CHAR( L12)","v":"\u0090"},177,{"$f":"CHAR( N12)","v":"±"},210,{"$f":"CHAR( P12)","v":"Ò"},243,"ó",":%s/æ/\\\\ae/ge","ae ligaturé","æ","\\ae","&aelig;","M-f","C a e",null,null,null,"a rond","å","&aring;","å",":%s/&aring;/å/gie"]
[13,41,null,13,"\r",46,".",79,"O",112,{"$f":"CHAR( J13)","v":"p"},145,{"$f":"CHAR( L13)","v":"‘"},178,{"$f":"CHAR( N13)","v":"²"},211,{"$f":"CHAR( P13)","v":"Ó"},244,"ô",":%s/Æ/\\\\AE/ge","AE ligaturé","Æ","\\AE","&AElig;","M-F","C A E",null,null,null,"A rond","Å","&Aring;","Å",":%s/&Aring;/Å/gie"]
[14,42,null,14,"\u000e",47,"/",80,"P",113,{"$f":"CHAR( J14)","v":"q"},146,{"$f":"CHAR( L14)","v":"’"},179,{"$f":"CHAR( N14)","v":"³"},212,{"$f":"CHAR( P14)","v":"Ô"},245,"õ",":%s/c/\\/ge","copyright","c",null,"&copy;","M-)","C c 0",null,null,null,"ae ligaturé","æ","&aelig;","æ",":%s/&aelig;/æ/gie"]
[15,43,null,15,"\u000f",48,"0",81,"Q",114,{"$f":"CHAR( J15)","v":"r"},147,{"$f":"CHAR( L15)","v":"“"},180,{"$f":"CHAR( N15)","v":"´"},213,{"$f":"CHAR( P15)","v":"Õ"},246,"ö",":%s/ç/\\\\c c/ge","c cédille","ç","\\c c","&ccedil;","M-g","C , c",null,null,null,"AE ligaturé","Æ","&AElig;","Æ",":%s/&AElig;/Æ/gie"]
[16,44,null,16,"\u0010",49,"1",82,"R",115,{"$f":"CHAR( J16)","v":"s"},148,{"$f":"CHAR( L16)","v":"”"},181,{"$f":"CHAR( N16)","v":"µ"},214,{"$f":"CHAR( P16)","v":"Ö"},247,"÷",":%s/Ç/\\\\c C/ge","C cédille","Ç","\\c C","&Ccedil;","M-G","C , C",null,null,null,"e accent grave","è","&egrave;","è",":%s/&egrave;/è/gie"]
[17,45,null,17,"\u0011",50,"2",83,"S",116,{"$f":"CHAR( J17)","v":"t"},149,{"$f":"CHAR( L17)","v":"•"},182,{"$f":"CHAR( N17)","v":"¶"},215,{"$f":"CHAR( P17)","v":"×"},248,"ø",":%s/E/\\\\\"E/ge","E tréma","E","\\\"E","&Euml;","M-K","C \" E",null,null,null,"E accent grave","È","&Egrave;","È",":%s/&Egrave;/È/gie"]
[18,46,null,18,{"$f":"CHAR( D18)","v":"\u0012"},51,"3",84,"T",117,{"$f":"CHAR( J18)","v":"u"},150,{"$f":"CHAR( L18)","v":"–"},183,{"$f":"CHAR( N18)","v":"·"},216,{"$f":"CHAR( P18)","v":"Ø"},249,"ù",":%s/é/\\\\'e/ge","e accent aigu","é","\\'e","&eacute;","M-i","C ' e",null,null,null,"e accent aigu","é","&eacute;","é",":%s/&eacute;/é/gie"]
[19,47,null,19,{"$f":"CHAR( D19)","v":"\u0013"},52,"4",85,"U",118,{"$f":"CHAR( J19)","v":"v"},151,{"$f":"CHAR( L19)","v":"—"},184,{"$f":"CHAR( N19)","v":"¸"},217,{"$f":"CHAR( P19)","v":"Ù"},250,"ú",":%s/É/\\\\'E/ge","E accent aigu","É","\\'E","&Eacute;","M-I","C ' E",null,null,null,"E accent aigu","É","&Eacute;","É",":%s/&Eacute;/É/gie"]
[20,48,null,20,"\u0014",53,"5",86,"V",119,{"$f":"CHAR( J20)","v":"w"},152,{"$f":"CHAR( L20)","v":"˜"},185,{"$f":"CHAR( N20)","v":"¹"},218,{"$f":"CHAR( P20)","v":"Ú"},251,"û",":%s/è/\\\\`e/ge","e accent grave","è","\\`e","&egrave;","M-h","C ` e",null,null,null,"e accent circonflexe","ê","&ecirc;","ê",":%s/&ecirc;/ê/gie"]
[21,49,null,21,"\u0015",54,"6",87,"W",120,{"$f":"CHAR( J21)","v":"x"},153,{"$f":"CHAR( L21)","v":"™"},186,{"$f":"CHAR( N21)","v":"º"},219,{"$f":"CHAR( P21)","v":"Û"},252,"ü",":%s/ê/\\\\^e/ge","e accent circonflexe","ê","\\^e","&ecirc;","M-j","C ^ e",null,null,null,"E accent circonflexe","Ê","&Ecirc;","Ê",":%s/&Ecirc;/Ê/gie"]
[22,50,null,22,"\u0016",55,"7",88,"X",121,{"$f":"CHAR( J22)","v":"y"},154,{"$f":"CHAR( L22)","v":"š"},187,{"$f":"CHAR( N22)","v":"»"},220,{"$f":"CHAR( P22)","v":"Ü"},253,"ý",":%s/ë/\\\\\"e/ge","e tréma","ë","\\\"e","&euml;","M-k","C \" e",null,null,null,"e tréma","ë","&euml;","ë",":%s/&euml;/ë/gie"]
[23,51,null,23,"\u0017",56,"8",89,"Y",122,{"$f":"CHAR( J23)","v":"z"},155,{"$f":"CHAR( L23)","v":"›"},188,{"$f":"CHAR( N23)","v":"¼"},221,{"$f":"CHAR( P23)","v":"Ý"},254,"þ",":%s/í/\\\\'i/ge","i accent aigu","í","\\'i","&iacute;","M-m","C ' i",null,null,null,"E tréma","Ë","&Euml;","Ë",":%s/&Euml;/Ë/gie"]
[24,52,null,24,"\u0018",57,"9",90,"Z",123,{"$f":"CHAR( J24)","v":"{"},156,{"$f":"CHAR( L24)","v":"œ"},189,{"$f":"CHAR( N24)","v":"½"},222,{"$f":"CHAR( P24)","v":"Þ"},255,"ÿ",":%s/ì/\\\\`i/ge","i accent grave","ì","\\`i","&igrave;","M-l","C ` i",null,null,null,"i accent grave","ì","&igrave;","ì",":%s/&igrave;/ì/gie"]
[25,53,null,25,"\u0019",58,":",91,"[",124,{"$f":"CHAR( J25)","v":"|"},157,{"$f":"CHAR( L25)","v":"\u009d"},190,{"$f":"CHAR( N25)","v":"¾"},223,{"$f":"CHAR( P25)","v":"ß"},"255 lettres de l'alphabet :",null,":%s/î/\\\\^i/ge","i accent circonflexe","î","\\^i","&icirc;","M-n","C ^ i",null,null,null,"I accent grave","Ì","&Igrave;","Ì",":%s/&Igrave;/Ì/gie"]
[26,54,null,26,"\u001a",59,";",92,"\\",125,{"$f":"CHAR( J26)","v":"}"},158,{"$f":"CHAR( L26)","v":"ž"},191,{"$f":"CHAR( N26)","v":"¿"},224,{"$f":"CHAR( P26)","v":"à"},null,null,":%s/ï/\\\\\"i/ge","i tréma","ï","\\\"i","&iuml;","M-o","C \" i",null,null,null,"i accent aigu","í","&iacute;","í",":%s/&iacute;/í/gie"]
[27,55,null,27,"\u001b",60,"<",93,"]",126,{"$f":"CHAR( J27)","v":"~"},159,{"$f":"CHAR( L27)","v":"Ÿ"},192,{"$f":"CHAR( N27)","v":"À"},225,{"$f":"CHAR( P27)","v":"á"},null,null,":%s/ñ/\\\\~n/ge","n tilde","ñ","\\~n","&ntilde;","M-q","C ~ n",null,null,null,"I accent aigu","Í","&Iacute;","Í",":%s/&Iacute;/Í/gie"]
[28,56,null,28,{"$f":"CHAR( D28)","v":"\u001c"},61,"=",94,"^",127,{"$f":"CHAR( J28)","v":"\u007f"},160,{"$f":"CHAR( L28)","v":" "},193,{"$f":"CHAR( N28)","v":"Á"},226,{"$f":"CHAR( P28)","v":"â"},"VBA :","CHR",":%s/Ñ/\\\\~N/ge","N tilde","Ñ","\\~N","&Ntilde;","M-Q","C ~ N",null,null,null,"i accent circonflexe","î","&icirc;","î",":%s/&icirc;/î/gie"]
[null,null,null,29,"\u001d",62,">",95,"_",128,{"$f":"CHAR( J29)","v":"€"},161,{"$f":"CHAR( L29)","v":"¡"},194,{"$f":"CHAR( N29)","v":"Â"},227,{"$f":"CHAR( P29)","v":"ã"},null,null,":%s/ó/\\\\'o/ge","o accent aigu","ó","\\'o","&oacute;","M-s","C ' o",null,null,null,"I accent circonflexe","Î","&Icirc;","Î",":%s/&Icirc;/Î/gie"]
[null,null,null,30,"\u001e",63,"?",96,"`",129,{"$f":"CHAR( J30)","v":"\u0081"},162,{"$f":"CHAR( L30)","v":"¢"},195,{"$f":"CHAR( N30)","v":"Ã"},228,{"$f":"CHAR( P30)","v":"ä"},"Excel Fr :","CAR(i)",":%s/ò/\\\\`o/ge","o accent grave","ò","\\`o","&ograve;","M-r","C ` o",null,null,null,"i tréma","ï","&iuml;","ï",":%s/&iuml;/ï/gie"]
[null,null,null,31,"\u001f",64,"@",97,"a",130,{"$f":"CHAR( J31)","v":"‚"},163,{"$f":"CHAR( L31)","v":"£"},196,{"$f":"CHAR( N31)","v":"Ä"},229,{"$f":"CHAR( P31)","v":"å"},"Excel GB : ","CHAR(i) ",":%s/ô/\\\\^o/ge","o accent circonflexe","ô","\\^o","&ocirc;","M-t","C ^ o",null,null,null,"I tréma","Ï","&Iuml;","Ï",":%s/&Iuml;/Ï/gie"]
[null,null,null,32," ",65,"A",98,"b",131,{"$f":"CHAR( J32)","v":"ƒ"},164,{"$f":"CHAR( L32)","v":"¤"},197,{"$f":"CHAR( N32)","v":"Å"},230,{"$f":"CHAR( P32)","v":"æ"},null,null,":%s/ö/\\\\\"o/ge","o tréma","ö","\\\"o","&ouml;","M-v","C \" o",null,null,null,"o accent grave","ò","&ograve;","ò",":%s/&ograve;/ò/gie"]
[null,null,null,33,"!",66,"B",99,"c",132,{"$f":"CHAR( J33)","v":"„"},165,{"$f":"CHAR( L33)","v":"¥"},198,{"$f":"CHAR( N33)","v":"Æ"},231,{"$f":"CHAR( P33)","v":"ç"},null,null,":%s/Ö/\\\\\"O/ge","O tréma","Ö","\\\"O","&Ouml;","M-V","C \" O",null,null,null,"O accent grave","Ò","&Ograve;","Ò",":%s/&Ograve;/Ò/gie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":%s/ß/\\\\ss/ge","double s allemand","ß","\\ss","&szlig;","M-_","C s s",null,null,null,"o accent aigu","ó","&oacute;","ó",":%s/&oacute;/ó/gie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":%s/ú/\\\\'u/ge","u accent aigu","ú","\\'u","&uacute;","M-z","C ' u",null,null,null,"O accent aigu","Ó","&Oacute;","Ó",":%s/&Oacute;/Ó/gie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":%s/ù/\\\\`u/ge","u accent grave","ù","\\`u","&ugrave;","M-y","C ` u",null,null,null,"o accent circonflexe","ô","&ocirc;","ô",":%s/&ocirc;/ô/gie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":%s/û/\\\\^u/ge","u accent circonflexe","û","\\^u","&ucirc;","M-{","C ^ u",null,null,null,"O accent circonflexe","Ô","&Ocirc;","Ô",":%s/&Ocirc;/Ô/gie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":%s/ü/\\\\\"u/ge","u tréma","ü","\\\"u","&uuml;","M-|","C \" u",null,null,null,"o tilde","õ","&otilde;","õ",":%s/&otilde;/õ/gie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":%s/Ü/\\\\\"/ge","U tréma","Ü","\\\"","&Uuml;","M-\\","C \" U",null,null,null,"O tilde","Õ","&Otilde;","Õ",":%s/&Otilde;/Õ/gie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"o tréma","ö","&ouml;","ö",":%s/&ouml;/ö/gie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"O tréma","Ö","&Ouml;","Ö",":%s/&Ouml;/Ö/gie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"o barré","ø","&oslash;","ø",":%s/&oslash;/ø/gie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"O barré","Ø","&Oslash;","Ø",":%s/&Oslash;/Ø/gie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"u accent grave","ù","&ugrave;","ù",":%s/&ugrave;/ù/gie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U accent grave","Ù","&Ugrave;","Ù",":%s/&Ugrave;/Ù/gie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"u accent aigu","ú","&uacute;","ú",":%s/&uacute;/ú/gie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U accent aigu","Ú","&Uacute;","Ú",":%s/&Uacute;/Ú/gie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"u accent circonflexe","û","&ucirc;","û",":%s/&ucirc;/û/gie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U accent circonflexe","Û","&Ucirc;","Û",":%s/&Ucirc;/Û/gie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"u tréma","ü","&uuml;","ü",":%s/&uuml;/ü/gie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U tréma","Ü","&Uuml;","Ü",":%s/&Uuml;/Ü/gie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n tilde","ñ","&ntilde;","ñ",":%s/&ntilde;/ñ/gie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N tilde","Ñ","&Ntilde;","Ñ",":%s/&Ntilde;/Ñ/gie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c cédille","ç","&ccedil;","ç",":%s/&ccedil;/ç/gie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C cédille","Ç","&Ccedil;","Ç",":%s/&Ccedil;/Ç/gie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"y accent aigu","ý","&yacute;","ý",":%s/&yacute;/ý/gie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y accent aigu","Ý","&Yacute;","Ý",":%s/&Yacute;/Ý/gie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"double s allemand","ß","&szlig;","ß",":%s/&szlig;/ß/gie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"guillemet français ouvrant","«","&laquo;","«",":%s/&laquo;/«/gie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"guillemet français fermant","»","&raquo;","»",":%s/&raquo;/»/gie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"esperluette","&","&amp;","&",":%s/&amp;/&/gie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"inférieur","<","&lt;","<",":%s/&lt;/</gie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"supérieur","<","&gt;","<",":%s/&gt;/</gie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"guillemet double","\"","&quot;","\"",":%s/&quot;/\"/gie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"paragraphe","§","&para;","§",":%s/&para;/§/gie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"copyright","©","&copy;","©",":%s/&copy;/©/gie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"espace blanc"," ","&nbsp;",null,{"$f":"CONCATENATE(\":%s/\",AF67,\"/ /gie\")","v":":%s/&nbsp;/ /gie"}]

{"sheet":"La-Chaine","index":2,"n_rows":41,"n_cols":79,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["catégorie_Cha","La-Chaine",{"$f":"CONCATENATE(\"    <!--  question XLQ \", titre_Cha, \"-->\")","v":"    <!--  question XLQ La-Chaine_Cha-->"},null,null,"Valeur Mini_Cha","Valeur Maxi_Cha","Sig. Digit_Cha","Val Choix_Cha"]
[null,"La-Chaine_Cha",{"$f":"CONCATENATE(\"    <question type=\",CHAR(34),\"category\",CHAR(34),\"><category><text>\", categorie_Cha,\"</text></category></question>)\")","v":"    <question type=\"category\"><category><text>La-Chaine</text></category></question>)"},null,"V1.LongA_Cha",1,10,0,{"$f":"RANDBETWEEN(ValMini_Cha*10^-SigDig_Cha, ValMaxi_Cha*10^-SigDig_Cha)/10^-SigDig_Cha+ROUND(RAND()/3,1)","v":10.199999999999999}]
["Tag_Cha","La-Chaine_Cha","    <question type=\"cloze\">",null,"V2.ProbaA_Cha",0.1,0.9,-1,{"$f":"RANDBETWEEN(ValMini_Cha*10^-SigDig_Cha, ValMaxi_Cha*10^-SigDig_Cha)/10^-SigDig_Cha","v":0.2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<p>Une chaine de longueur #1#m &agrave; une probabilit&eacute; de rupture de #2#. En d&eacute;duire la probabilit&eacute; de rupture de cette une m&ecirc;me chaine avec une longueur de #3#m. R&eacute;ponse : $1$</p><p><p>&nbsp;</p><p>"]
["idnumber_Cha",{"$f":"TEXT(NOW(),\"aammjj-hhmmss.00\")","v":"210710-212021.20"},{"$f":"CONCATENATE(\"        <name><text>\", titre_Cha, \"</text></name>\")","v":"        <name><text>La-Chaine_Cha</text></name>"},null,"V3.LongB_Cha",2,10,0,{"$f":"RANDBETWEEN(ValMini_Cha*10^-SigDig_Cha, ValMaxi_Cha*10^-SigDig_Cha)/10^-SigDig_Cha-ROUND(RAND()/3,1)-0.1","v":1.7999999999999998}]
["points_Cha",1,"        <questiontext format=\"html\">"]
["tolérance_Cha",0.05,{"$f":"CONCATENATE(\"            <text><![CDATA[<p>\", question_Cha, \"</p>]]></text>\")","v":"            <text><![CDATA[<p> Une chaine de longueur 10.2m &agrave; une probabilit&eacute; de rupture de 0.2. En d&eacute;duire la probabilit&eacute; de rupture de cette une m&ecirc;me chaine avec une longueur de 1.8m. R&eacute;ponse: {1:NUMERICAL:=3.86E-02:1.93E-03}</p><p><p>&nbsp;</p><p></p>]]></text>"},null,null,"Cible_Cha","Toler_Cha","PointsQuestion_Cha"]
["penalité_Cha",0.1,"        </questiontext>",null,"R1.ProbaB_Cha",{"$f":"1-(1-V2.ProbaA_Cha)^(V3.LongB_Cha/V1.LongA_Cha)","v":3.8613027111566445E-2},{"$f":" tolerance_Cha*ValMini_Cha","v":1.9306513555783222E-3},1,{"$f":"CONCATENATE(\"{\",PointsQuestion_Cha,\":NUMERICAL:=\",TEXT(Cible_Cha,\"0.00E+00\"),\":\",TEXT(ABS(Tolere_Cha),\"0.00E+00\"),\"}\")","v":"{1:NUMERICAL:=3.86E-02:1.93E-03}"}]
["feedback_Cha","_",{"$f":"CONCATENATE(\"        <defaultgrade>\",points_Cha,\"</defaultgrade><generalfeedback><text>\",feedback_Cha,\"</text></generalfeedback><penalty>\",penalty_Cha,\"</penalty><hidden>0</hidden>)\")","v":"        <defaultgrade>1</defaultgrade><generalfeedback><text>_</text></generalfeedback><penalty>0.1</penalty><hidden>0</hidden>)"},null,null,null,null,null,{"$f":"SUM(F7:H7)","v":1.0405436784671447}]
["Cellule vides_Cha",{"$f":"COUNTBLANK(B1:B8)","v":0},{"$f":"CONCATENATE(\"        <idnumber>\",idnumber_Cha,\"</idnumber><tags><tag><text>\",Tag_Cha,\"</text></tag></tags>\")","v":"        <idnumber>210710-212021.20</idnumber><tags><tag><text>La-Chaine_Cha</text></tag></tags>"}]
["question format HTML_Cha",{"$f":"CONCATENATE(\" \",B19,B20,B21)","v":" Une chaine de longueur 10.2m &agrave; une probabilit&eacute; de rupture de 0.2. En d&eacute;duire la probabilit&eacute; de rupture de cette une m&ecirc;me chaine avec une longueur de 1.8m. R&eacute;ponse: {1:NUMERICAL:=3.86E-02:1.93E-03}</p><p><p>&nbsp;</p><p>"},"    </question>"]
["Repere Var Rep","_Cha"]
["HTML File ",{"$f":"CONCATENATE(categorie_Cha,\"_HTML.txt\")","v":"La-Chaine_HTML.txt"}]
["Valide ? ",{"$f":"AND(ISNUMBER(I8),V1.LongA_Cha<>V3.LongB_Cha)","v":true}]
["https://html-online.com/editor/ "]
[null,null,5]
["Var : ","#",3]
["Res : ","$",1]
[]
[null,{"$f":"CONCATENATE(\"Une chaine de longueur \",V1.LongA_Cha,\"m &agrave; une probabilit&eacute; de rupture de \",V2.ProbaA_Cha,\". En d&eacute;duire la probabilit&eacute; de rupture de cette une m&ecirc;me chaine avec une longueur de \",V3.LongB_Cha,\"m. R&eacute;ponse\")","v":"Une chaine de longueur 10.2m &agrave; une probabilit&eacute; de rupture de 0.2. En d&eacute;duire la probabilit&eacute; de rupture de cette une m&ecirc;me chaine avec une longueur de 1.8m. R&eacute;ponse"},"<p>Une chaine de longueur #1#m &agrave; une probabilit&eacute; de rupture de #2#. En d&eacute;duire la probabilit&eacute; de rupture de cette une m&ecirc;me chaine avec une longueur de #3#m. R&eacute;ponse : $1$</p>"]
[null,{"$f":"CONCATENATE(\": \",R1.ProbaB_Cha,\"</p><p><p>&nbsp;</p><p>\")","v":": {1:NUMERICAL:=3.86E-02:1.93E-03}</p><p><p>&nbsp;</p><p>"},"<p>&nbsp;</p>"]
[null,{"$f":"CONCATENATE(\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Une chaine de longueur \",V1.LongA_Cha,\"m à une probabilité de rupture de \",V2.ProbaA_Cha,\". En déduire la probabilité de rupture de cette une même chaine avec une longueur de \",V3.LongB_Cha,\"m. Réponse\")","v":"Une chaine de longueur 10.2m à une probabilité de rupture de 0.2. En déduire la probabilité de rupture de cette une même chaine avec une longueur de 1.8m. Réponse"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"  \\formsol{$1-(1-p_A)^{(L_B/L_A)}$} \\minisol{\",ROUND(F7,3),\"}\")","v":"  \\formsol{$1-(1-p_A)^{(L_B/L_A)}$} \\minisol{0.039}"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,": \",R1.ProbaB_Cha,\"</p><p><p>&nbsp;</p><p>"]

{"sheet":"Griffith","index":3,"n_rows":32,"n_cols":79,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["feedback_Gri","Griffith",{"$f":"CONCATENATE(\"    <!--  question XLQ \", titre_Gri, \"-->\")","v":"    <!--  question XLQ Griffith_Gri-->"},null,null,"Valeur Mini_Gri","Valeur Maxi_Gri","Sig. Digit_Gri","Val Choix_Gri"]
[null,"Griffith_Gri",{"$f":"CONCATENATE(\"    <question type=\",CHAR(34),\"category\",CHAR(34),\"><category><text>\", categorie_Gri,\"</text></category></question>)\")","v":"    <question type=\"category\"><category><text>Griffith</text></category></question>)"},null,"V1.E_Gri",65,75,0,{"$f":"RANDBETWEEN(ValMini_Gri*10^-SigDig_Gri, ValMaxi_Gri*10^-SigDig_Gri)/10^-SigDig_Gri","v":75},"Gpa",74,null,null,null,null,70,null,"E=",70000000000,"Pa"]
["Tag_Gri","Griffith_Gri","    <question type=\"cloze\">",null,"V2.Rm_Gri",50,90,0,52,"Mpa",75,null,null,null,null,66,null,"Energie surf",0.2,"J/m2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Une plaque est réalisée en verre ordinaire dont les propriétés sont les suivantes :<p>E = #1# GPa ; Rm = #2# MPa ; gammas = 0,2 J/m2<p>Cette plaque est rectangulaire de dimension :<p>Hauteur = #3# mm; Largeur = #4# mm, Epaisseur = #5# mm;<p>Elle contient, à sa surface, une fissure grossière de caracteristique :<p>profondeur = #6# mm; rayon de courbure en tête de fissure = #7# nm<p>a. Dans ces conditions de chargement de la plaque entaillée calculer la contrainte maximale tolérable selon le critère énergétique de Griffith : \\formsol{$$}\\minisol{} MPa<p>b. Quelle est la concentration de contrainte induite par l'entaille ? \\formsol{$$}\\minisol{} [SD]<p>c. Quelle est la contrainte tolérable selon le critère mécanique de Griffith ? \\formsol{$$}\\minisol{} MPa<p>d. Sous quelle force verticale aura lieu la rupture ? \\formsol{$$}\\minisol{} kN.<p>Une plaque est réalisée en verre ordinaire dont les propriétés sont les suivantes :<p>E = \"\",V1.E_Gri,\"\" GPa ; Rm = \"\",V2.Rm_Gri,\"\" MPa ; γS = 0,2 J/m2<p>Cette plaque est rectangulaire de dimension :<p>Hauteur = \"\",V3.Gamma_Gri,\"\" mm; Largeur<p>"]
["idnumber_Gri",{"$f":"TEXT(NOW(),\"aammjj-hhmmss.00\")","v":"210710-212021.20"},{"$f":"CONCATENATE(\"        <name><text>\", titre_Gri, \"</text></name>\")","v":"        <name><text>Griffith_Gri</text></name>"},null,"V3.Gamma_Gri",0.1,0.3,-1,0.1,"J/m2",0.2,null,null,null,null,0.2,null,"prof",6.0000000000000001E-3,"m"]
["points_Gri",1,"        <questiontext format=\"html\">",null,"V4.Larg_Gri",70,150,1,120,"mm",80,null,null,null,null,100,null,null,{"$f":"SQRT(2*S2*S3/(PI()*S4))/1000000","v":1.2187887985719086},"Mpa"]
["tolérance_Gri",0.05,{"$f":"CONCATENATE(\"            <text><![CDATA[<p>\", question_Gri, \"</p>]]></text>\")","v":"            <text><![CDATA[<p> Une plaque est r&eacute;alis&eacute;e en verre ordinaire dont les propri&eacute;t&eacute;s sont les suivantes :<br />E = 75 GPa ; Rm = 52 MPa ; &gamma;<sub>S</sub> = 0,2 J/m2</p><p><p>Cette plaque est rectangulaire de dimension : <br />Hauteur = 200 mm; Largeur = 120 mm, Epaisseur = 9 mm;</p><p><p>Elle contient, &agrave; sa surface, une fissure grossi&egrave;re de caracteristique : <br/> profondeur = 43 microns; rayon de courbure en t&ecirc;te de fissure = 1 nm</p><p><p>a. Dans ces conditions de chargement de la plaque entaill&eacute;e calculer la contrainte maximale tol&eacute;rable selon le crit&egrave;re &eacute;nerg&eacute;tique de Griffith : {2:NUMERICAL:=1.05E+01:5.27E-01}MPa <br />b. Quelle est la concentration de contrainte induite par l'entaille ? {2:NUMERICAL:=4.15E+02:2.07E+01} [SD]<br />c. Quelle est la contrainte tol&eacute;rable selon le crit&egrave;re m&eacute;canique de Griffith ? {3:NUMERICAL:=1.81E+01:9.04E-01} MPa<br />d. Sous quelle force verticale aura lieu la rupture ? {4:NUMERICAL:=4.48E+02:2.24E+01} kN.</p>]]></text>"},null,"V5.Epais_Gri",5,25,0,9,"mm",17,null,null,null,null,11]
["penalité_Gri",0.1,"        </questiontext>",null,"V6.Profond_Gri",10,60,0,43,"µm",38,null,null,null,null,3000,null," RACINE(2*mod*Energie_surf/(PI()*prof))"]
["feedback_Gri","_",{"$f":"CONCATENATE(\"        <defaultgrade>\",points_Gri,\"</defaultgrade><generalfeedback><text>\",feedback_Gri,\"</text></generalfeedback><penalty>\",penalty_Gri,\"</penalty><hidden>0</hidden>)\")","v":"        <defaultgrade>1</defaultgrade><generalfeedback><text>_</text></generalfeedback><penalty>0.1</penalty><hidden>0</hidden>)"},null,"V7.rho_Gri",1,5,0,1,"nm",2,null,null,null,null,4]
["Cellule vides_Gri",{"$f":"COUNTBLANK(B1:B8)","v":0},{"$f":"CONCATENATE(\"        <idnumber>\",idnumber_Gri,\"</idnumber><tags><tag><text>\",Tag_Gri,\"</text></tag></tags>\")","v":"        <idnumber>210710-212021.20</idnumber><tags><tag><text>Griffith_Gri</text></tag></tags>"},null,null,null,null,null,0,null,null,null,{"$f":"SQRT(2*mod*Energie_surf/(PI()*prof))","v":{"$error":"#NAME?"}}]
["question format HTML_Gri",{"$f":"CONCATENATE(\" \",B19,B20,B21,B22,B23,B24,B25,B26,B27,B28,B29)","v":" Une plaque est r&eacute;alis&eacute;e en verre ordinaire dont les propri&eacute;t&eacute;s sont les suivantes :<br />E = 75 GPa ; Rm = 52 MPa ; &gamma;<sub>S</sub> = 0,2 J/m2</p><p><p>Cette plaque est rectangulaire de dimension : <br />Hauteur = 200 mm; Largeur = 120 mm, Epaisseur = 9 mm;</p><p><p>Elle contient, &agrave; sa surface, une fissure grossi&egrave;re de caracteristique : <br/> profondeur = 43 microns; rayon de courbure en t&ecirc;te de fissure = 1 nm</p><p><p>a. Dans ces conditions de chargement de la plaque entaill&eacute;e calculer la contrainte maximale tol&eacute;rable selon le crit&egrave;re &eacute;nerg&eacute;tique de Griffith : {2:NUMERICAL:=1.05E+01:5.27E-01}MPa <br />b. Quelle est la concentration de contrainte induite par l'entaille ? {2:NUMERICAL:=4.15E+02:2.07E+01} [SD]<br />c. Quelle est la contrainte tol&eacute;rable selon le crit&egrave;re m&eacute;canique de Griffith ? {3:NUMERICAL:=1.81E+01:9.04E-01} MPa<br />d. Sous quelle force verticale aura lieu la rupture ? {4:NUMERICAL:=4.48E+02:2.24E+01} kN."},"    </question>",null,null,"Cible_Gri","Toler_Gri","PointsQuestion_Gri",null,null,null,null,null,null,null,40.700000000000003]
["Repere Var Rep","_Gri",null,null,"R1.SigEner_Gri",{"$f":"ROUND(SQRT((2*V1.E_Gri*1000000000*V3.Gamma_Gri)/(PI()*V6.Profond_Gri*0.000001)),-2)/1000000","v":10.5375},{"$f":" tolerance_Gri*ValMini_Gri","v":0.52687499999999998},2,{"$f":"CONCATENATE(\"{\",PointsQuestion_Gri,\":NUMERICAL:=\",TEXT(Cible_Gri,\"0.00E+00\"),\":\",TEXT(ABS(Tolere_Gri),\"0.00E+00\"),\"}\")","v":"{2:NUMERICAL:=1.05E+01:5.27E-01}"},null,null,null,null,null,null,70.710678118654741]
["HTML File ",{"$f":"CONCATENATE(categorie_Gri,\"_HTML.txt\")","v":"Griffith_HTML.txt"},null,null,"R2.KT_Gri",{"$f":"2*SQRT(V6.Profond_Gri*0.000001/(V7.rho_Gri*0.000000001))","v":414.7288270665544},{"$f":" tolerance_Gri*ValMini_Gri","v":20.73644135332772},2,{"$f":"CONCATENATE(\"{\",PointsQuestion_Gri,\":NUMERICAL:=\",TEXT(Cible_Gri,\"0.00E+00\"),\":\",TEXT(ABS(Tolere_Gri),\"0.00E+00\"),\"}\")","v":"{2:NUMERICAL:=4.15E+02:2.07E+01}"},null,null,null,null,null,null,91.923881554251196]
["Valide ? ",{"$f":"ISNUMBER(F15)","v":true},null,null,"R3.SigMec_Gri",{"$f":"(1000*V1.E_Gri/10)/(F12)","v":18.084105831390456},{"$f":" tolerance_Gri*ValMini_Gri","v":0.9042052915695229},3,{"$f":"CONCATENATE(\"{\",PointsQuestion_Gri,\":NUMERICAL:=\",TEXT(Cible_Gri,\"0.00E+00\"),\":\",TEXT(ABS(Tolere_Gri),\"0.00E+00\"),\"}\")","v":"{3:NUMERICAL:=1.81E+01:9.04E-01}"},null,null,null,null,null,null,101.11626970967633]
["https://html-online.com/editor/",null,null,null,"R4.Force_Gri",{"$f":"MAX(F13,F12)*V4.Larg_Gri*V5.Epais_Gri/1000","v":447.90713323187879},{"$f":" tolerance_Gri*ValMini_Gri","v":22.39535666159394},4,{"$f":"CONCATENATE(\"{\",PointsQuestion_Gri,\":NUMERICAL:=\",TEXT(Cible_Gri,\"0.00E+00\"),\":\",TEXT(ABS(Tolere_Gri),\"0.00E+00\"),\"}\")","v":"{4:NUMERICAL:=4.48E+02:2.24E+01}"}]
[null,null,9,null,null,{"$f":"SUM(F11:H14)","v":946.8204444363148}]
["Var : ","#",7]
["Res : ","$",4]
[]
[null,{"$f":"CONCATENATE(\"Une plaque est r&eacute;alis&eacute;e en verre ordinaire dont les propri&eacute;t&eacute;s sont les suivantes :<br />E = \",V1.E_Gri,\" GPa ; Rm = \",V2.Rm_Gri,\" MPa ; &gamma;<sub>S</sub> = 0,2 J/m2</p><p><p>Cette\")","v":"Une plaque est r&eacute;alis&eacute;e en verre ordinaire dont les propri&eacute;t&eacute;s sont les suivantes :<br />E = 75 GPa ; Rm = 52 MPa ; &gamma;<sub>S</sub> = 0,2 J/m2</p><p><p>Cette"},null,null,null,null,null,null,null," ",{"$f":"CONCATENATE(\"Une plaque est réalisée en verre ordinaire dont les propriétés sont les suivantes : \\\\E = \",V1.E_Gri,\" GPa ; Rm = \",V2.Rm_Gri,\" MPa ; $\\gamma_s $= 0,2 J/m2 \\\\ Cette plaque est rectangulaire de dimension :\\\\Hauteur = 10cm;\")","v":"Une plaque est réalisée en verre ordinaire dont les propriétés sont les suivantes : \\\\E = 75 GPa ; Rm = 52 MPa ; $\\gamma_s $= 0,2 J/m2 \\\\ Cette plaque est rectangulaire de dimension :\\\\Hauteur = 10cm;"}]
[null,{"$f":"CONCATENATE(\" plaque est rectangulaire de dimension : <br />Hauteur = 200 mm; Largeur = \",V4.Larg_Gri,\" mm, Epaisseur = \",V5.Epais_Gri,\" mm;</p><p><p>Elle contient, &agrave; sa surface, une fissure grossi&egrave;re de caracteristique : <br\")","v":" plaque est rectangulaire de dimension : <br />Hauteur = 200 mm; Largeur = 120 mm, Epaisseur = 9 mm;</p><p><p>Elle contient, &agrave; sa surface, une fissure grossi&egrave;re de caracteristique : <br"},"Une plaque est réalisée en verre ordinaire dont les propriétés sont les suivantes :",null,null,null,null,null,null," ",{"$f":"CONCATENATE(\"Largeur = \",V4.Larg_Gri,\" mm, Epaisseur = \",V5.Epais_Gri,\" mm; \\\\ Elle contient, à sa surface, une fissure grossière de caracteristique :\\\\profondeur = \",V6.Profond_Gri,\" µm; rayon de courbure en tête de fissure = \",V7.rho_Gri,\" nm\\\\a. Dans ces conditions\")","v":"Largeur = 120 mm, Epaisseur = 9 mm; \\\\ Elle contient, à sa surface, une fissure grossière de caracteristique :\\\\profondeur = 43 µm; rayon de courbure en tête de fissure = 1 nm\\\\a. Dans ces conditions"}]
[null,{"$f":"CONCATENATE(\"/> profondeur = \",V6.Profond_Gri,\" microns; rayon de courbure en t&ecirc;te de fissure = \",V7.rho_Gri,\" nm</p><p><p>a. Dans ces conditions de chargement de la plaque entaill&eacute;e calculer la contrainte maximale tol&eacute;rable selon\")","v":"/> profondeur = 43 microns; rayon de courbure en t&ecirc;te de fissure = 1 nm</p><p><p>a. Dans ces conditions de chargement de la plaque entaill&eacute;e calculer la contrainte maximale tol&eacute;rable selon"},"E = #1# GPa ; Rm = #2# MPa ; gammas = 0,2 J/m2",null,null,null,null,null,null," ",{"$f":"CONCATENATE(\"de chargement de la plaque entaillée calculer la contrainte maximale tolérable selon le critère énergétique de Griffith : \\formsol{$\\sigma _{nom}  \\ge \\sqrt {\\frac{{2E\\gamma _s }}{{\\pi a}}}$}\\minisol{\",ROUND(F11,0),\"} MPa \\\\b. Quelle est la concentration de contrainte induite\")","v":"de chargement de la plaque entaillée calculer la contrainte maximale tolérable selon le critère énergétique de Griffith : \\formsol{$\\sigma _{nom}  \\ge \\sqrt {\\frac{{2E\\gamma _s }}{{\\pi a}}}$}\\minisol{11} MPa \\\\b. Quelle est la concentration de contrainte induite"}]
[null,{"$f":"CONCATENATE(\" le crit&egrave;re &eacute;nerg&eacute;tique de Griffith : \",R1.SigEner_Gri,\"MPa <br />b. Quelle est la concentration de contrainte induite par l'entaille ? \",R2.KT_Gri,\" [SD]<br />c. Quelle est la contrainte tol&eacute;rable selon\")","v":" le crit&egrave;re &eacute;nerg&eacute;tique de Griffith : {2:NUMERICAL:=1.05E+01:5.27E-01}MPa <br />b. Quelle est la concentration de contrainte induite par l'entaille ? {2:NUMERICAL:=4.15E+02:2.07E+01} [SD]<br />c. Quelle est la contrainte tol&eacute;rable selon"},null,null,null,null,null,null,null," ",{"$f":"CONCATENATE(\"par l'entaille ? \\formsol{$K_t=2\\sqrt{\\frac{a}{\\rho}}$}\\minisol{\",ROUND(F12,0),\"} [SD]\\\\c. Quelle est la contrainte tolérable selon le critère mécanique de Griffith ? \\formsol{$\\sigma_{loc} = Rm => \\sigma_{mac} = RmTH / Kt $}\\minisol{\",ROUND(F13,0),\"} MPa\\\\d. Sous quelle force verticale aura lieu la rupture\")","v":"par l'entaille ? \\formsol{$K_t=2\\sqrt{\\frac{a}{\\rho}}$}\\minisol{415} [SD]\\\\c. Quelle est la contrainte tolérable selon le critère mécanique de Griffith ? \\formsol{$\\sigma_{loc} = Rm => \\sigma_{mac} = RmTH / Kt $}\\minisol{18} MPa\\\\d. Sous quelle force verticale aura lieu la rupture"}]
[null,{"$f":"CONCATENATE(\" le crit&egrave;re m&eacute;canique de Griffith ? \",R3.SigMec_Gri,\" MPa<br />d. Sous quelle force verticale aura lieu la rupture ? \",R4.SigTot_Gri,\" kN.\")","v":" le crit&egrave;re m&eacute;canique de Griffith ? {3:NUMERICAL:=1.81E+01:9.04E-01} MPa<br />d. Sous quelle force verticale aura lieu la rupture ? {4:NUMERICAL:=4.48E+02:2.24E+01} kN."},"Cette plaque est rectangulaire de dimension :",null,null,null,null,null,null," ",{"$f":"CONCATENATE(\"? \\formsol{$F = \\sigma \\times S_0$}\\minisol{\",ROUND(F14,0),\"} kN.\")","v":"? \\formsol{$F = \\sigma \\times S_0$}\\minisol{448} kN."}]
[null,null,"Hauteur = #3# mm; Largeur = #4# mm, Epaisseur = #5# mm;"]
[null,{"$f":"CONCATENATE(\"\")","v":""}]
[null,{"$f":"CONCATENATE(\"\")","v":""},"Elle contient, à sa surface, une fissure grossière de caracteristique :"]
[null,{"$f":"CONCATENATE(\"\")","v":""},"profondeur = #6# mm; rayon de courbure en tête de fissure = #7# nm"]
[null,{"$f":"CONCATENATE(\"\")","v":""}]
[null,{"$f":"CONCATENATE(\"\")","v":""},"a. Dans ces conditions de chargement de la plaque entaillée calculer la contrainte maximale tolérable selon le critère énergétique de Griffith : \\formsol{$$}\\minisol{} MPa"]
[null,null,"b. Quelle est la concentration de contrainte induite par l'entaille ? \\formsol{$$}\\minisol{} [SD]"]
[null,null,"c. Quelle est la contrainte tolérable selon le critère mécanique de Griffith ? \\formsol{$$}\\minisol{} MPa"]
[null,null,"d. Sous quelle force verticale aura lieu la rupture ? \\formsol{$$}\\minisol{} kN."]

{"sheet":"WeiPara","index":4,"n_rows":29,"n_cols":79,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["catégorie_Wei","WeiPara",{"$f":"CONCATENATE(\"    <!--  question XLQ \", titre_Wei, \"-->\")","v":"    <!--  question XLQ WeiPara_Wei-->"},null,null,"Valeur Mini_Wei","Valeur Maxi_Wei","Sig. Digit_Wei","Val Choix_Wei",null,null,null,null,null,"rigoureux contrainte","ln(-ln(1-p))"]
[null,"WeiPara_Wei",{"$f":"CONCATENATE(\"    <question type=\",CHAR(34),\"category\",CHAR(34),\"><category><text>\", categorie_Wei,\"</text></category></question>)\")","v":"    <question type=\"category\"><category><text>WeiPara</text></category></question>)"},null,"V1._Wei",{"$f":"Contr_Rig*(1-Randm_Wei*RAND())","v":5.2594443590505273},{"$f":"Contr_Rig*(1+Randm_Wei*RAND()/100)","v":5.2944930532081971},-2,{"$f":"ROUND(EXP(RANDBETWEEN(ValMini_Wei*10^-SigDig_Wei, ValMaxi_Wei*10^-SigDig_Wei)/10^-SigDig_Wei),0)","v":196},null,"log Sig","MPa",null,1,{"$f":"(Proba_Wei-Ordonnee)/Module","v":5.2941510868205848},{"$f":"LN(-LN(1-N2/10))","v":-2.2503673273124454},null,null,"pente","ordo"]
["Tag_Wei","WeiPara_Wei","    <question type=\"cloze\">",null,"V2._Wei",5.3079214925329756,5.3704055582439754,-2,213,null,"log Sig","MPa",null,2,{"$f":"(Proba_Wei-Ordonnee)/Module","v":5.3699518282905778},-1.4999399867595158,null,null,{"$f":"LINEST(P2:P10,O2:O10,1,1)","v":9.8999999999999915},-54.662463086836176,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<p>On r&eacute;alise des exp&eacute;riences traction sur un mat&eacute;riau fragile. On obtient un ensemble de contraintes &agrave; rupture suivant : \"\";V9._Wei;\"\", \"\";V7._Wei;\"\", \"\";V5._Wei;\"\", \"\";V3._Wei;\"\", \"\";V4._Wei;\"\", \"\";V6._Wei;\"\", \"\";V2._Wei;\"\", \"\";V8._Wei;\"\", \"\";V1._Wei;\"\" MPa. En deduire les param&egrave;tres de Weibull associ&eacute;s :</p><p><p>&nbsp;</p><p><p>Le module m=\"\";Module;\"\"</p><p><p>&nbsp;</p><p><p>&nbsp;</p><p><p>Le facteur d'&eacute;chelle Ko=\"\";Facteur_Echelle;\"\" MPa</p><p><p>&nbsp;</p><p>"]
["idnumber_Wei",{"$f":"TEXT(NOW(),\"aammjj-hhmmss.00\")","v":"210710-212021.20"},{"$f":"CONCATENATE(\"        <name><text>\", titre_Wei, \"</text></name>\")","v":"        <name><text>WeiPara_Wei</text></name>"},null,"V3._Wei",{"$f":"Contr_Rig*(1-Randm_Wei*RAND())","v":5.338983913498911},{"$f":"Contr_Rig*(1+Randm_Wei*RAND()/100)","v":5.4184368362848314},-2,{"$f":"ROUND(EXP(RANDBETWEEN(ValMini_Wei*10^-SigDig_Wei, ValMaxi_Wei*10^-SigDig_Wei)/10^-SigDig_Wei),0)","v":217},null,"log Sig","MPa",null,3,{"$f":"(Proba_Wei-Ordonnee)/Module","v":5.4173265306744964},-1.0309304331587228,null,null,1.1250185540157749E-14,6.1569509148543269E-14]
["points_Wei",1,"        <questiontext format=\"html\">",null,"V4._Wei",5.3749666320809455,5.4541566951752918,-2,217,null,"log Sig","MPa",null,4,5.453609706539809,-0.67172699209212194,null,null,1,3.1664694624936063E-15]
["tolérance_Wei",0.25,{"$f":"CONCATENATE(\"            <text><![CDATA[<p>\", question_Wei, \"</p>]]></text>\")","v":"            <text><![CDATA[<p> On r&eacute;alise des exp&eacute;riences traction sur un mat&eacute;riau fragile. On obtient un ensemble de contraintes &agrave; rupture suivantes : 268, 242, 240, 217, 217, 245, 213, 250, 196 MPa. En deduire les param&egrave;tres de Weibull associ&eacute;s :</p><p><p>&nbsp;</p><p><p>Le module m={1:NUMERICAL:=9.90E+00:2.48E+00}</p><p><p>&nbsp;</p><p><p>&nbsp;</p><p><p>Lefacteur d'&eacute;chelle Ko={1:NUMERICAL:=2.43E+02:6.07E+01} MPa</p><p><p>&nbsp;</p><p></p>]]></text>"},null,"V5._Wei",5.4102766337636439,5.4854634096876671,-2,240,null,"log Sig","MPa",null,5,5.4844394107327856,-0.36651292058166435,null,null,7.7437445711222441E+29,7]
["penalité_Wei",0.1,"        </questiontext>",null,"V6._Wei",5.4255721826920329,5.5128856667044515,-2,245,null,"log Sig","MPa",null,6,5.5126304560652004,-8.7421571790755173E-2,null,null,7.7642878402855118,7.0185701998331843E-29]
["feedback_Wei","_",{"$f":"CONCATENATE(\"        <defaultgrade>\",points_Wei,\"</defaultgrade><generalfeedback><text>\",feedback_Wei,\"</text></generalfeedback><penalty>\",penalty_Wei,\"</penalty><hidden>0</hidden>)\")","v":"        <defaultgrade>1</defaultgrade><generalfeedback><text>_</text></generalfeedback><penalty>0.1</penalty><hidden>0</hidden>)"},null,"V7._Wei",5.4705582054049682,5.5409240001032245,-2,242,null,"log Sig","MPa",null,7,5.5402110955251116,0.18562675886236557]
["Cellule vides_Wei",{"$f":"COUNTBLANK(B1:B8)","v":0},{"$f":"CONCATENATE(\"        <idnumber>\",idnumber_Wei,\"</idnumber><tags><tag><text>\",Tag_Wei,\"</text></tag></tags>\")","v":"        <idnumber>210710-212021.20</idnumber><tags><tag><text>WeiPara_Wei</text></tag></tags>"},null,"V8._Wei",5.5121826567232786,5.569956063110884,-2,250,null,"log Sig","MPa",null,8,5.5695301093094294,0.4758849953271107,null,null,null,{"$f":"EXP(-T3/S3)","v":249.99999999999969}]
["question format HTML_Wei",{"$f":"CONCATENATE(\" \",B19,B20,B21,B22,B23,B24)","v":" On r&eacute;alise des exp&eacute;riences traction sur un mat&eacute;riau fragile. On obtient un ensemble de contraintes &agrave; rupture suivantes : 268, 242, 240, 217, 217, 245, 213, 250, 196 MPa. En deduire les param&egrave;tres de Weibull associ&eacute;s :</p><p><p>&nbsp;</p><p><p>Le module m={1:NUMERICAL:=9.90E+00:2.48E+00}</p><p><p>&nbsp;</p><p><p>&nbsp;</p><p><p>Lefacteur d'&eacute;chelle Ko={1:NUMERICAL:=2.43E+02:6.07E+01} MPa</p><p><p>&nbsp;</p><p>"},"    </question>",null,"V9._Wei",5.550598802677257,5.6065960821861234,-2,268,null,"log Sig","MPa",null,9,5.6057066194024436,0.83403244524795594]
["Repere Var Rep","_Wei",null,null,"1-- V10._Wei",250,350,0,{"$f":"RANDBETWEEN(ValMini_Wei*10^-SigDig_Wei, ValMaxi_Wei*10^-SigDig_Wei)/10^-SigDig_Wei","v":250},"moyenne","log Sig","MPa"]
["HTML File ",{"$f":"CONCATENATE(categorie_Wei,\"_HTML.txt\")","v":"WeiPara_HTML.txt"}]
["Valide ? ",{"$f":"ISNUMBER(V10._Wei)","v":true},null,null,"alea",1.8,2.5,-1,{"$f":"RANDBETWEEN(ValMini_Wei*10^-SigDig_Wei, ValMaxi_Wei*10^-SigDig_Wei)/10^-SigDig_Wei/100","v":2.3E-2}]
["https://html-online.com/editor/",null,null,null,"2-- Ordo",null,null,null,{"$f":"-Module*LN(V10._Wei)","v":-54.66246308683624},"ordonnée",null,"verif s",{"$f":"EXP(-I14/I15)","v":249.99999999999989},null,null,null,null,{"$f":"100*ABS(R17/R16)+ABS(S17/S16)","v":9.5245434078773741}]
[null,null,9,null,"1 --m",1,10,-1,{"$f":"RANDBETWEEN(ValMini_Wei*10^-SigDig_Wei, ValMaxi_Wei*10^-SigDig_Wei)/10^-SigDig_Wei","v":9.9},"pente",null,"Extracted s",{"$f":"EXP(-Ordonnee/Module)","v":249.99999999999989},null,"sig exp","ln exp",null,"pente","ordo"]
["Var : ","#",7,null,null,"Cible_Wei","Toler_Wei","PointsQuestion_Wei",null,null,null,null,null,null,{"$f":"LN(I2)","v":5.2781146592305168},{"$f":"P2","v":-2.2503673273124454},null,{"$f":"LINEST(P16:P24,O16:O24,1,1)","v":9.75546969366901},-53.58427733869312]
["Res : ","$",2,null,"R1.Module_Wei",{"$f":"I15","v":9.9},{"$f":" tolerance_Wei*ValMini_Wei","v":2.4750000000000001},1,{"$f":"CONCATENATE(\"{\",PointsQuestion_Wei,\":NUMERICAL:=\",TEXT(Cible_Wei,\"0.00E+00\"),\":\",TEXT(ABS(Tolere_Wei),\"0.00E+00\"),\"}\")","v":"{1:NUMERICAL:=9.90E+00:2.48E+00}"},null,null,null,null,null,5.3612921657094255,-1.4999399867595158,null,0.92004632849110157,5.0080717794279428]
[null,null,null,null,"R2.Exp_Wei",{"$f":"Facteur_Echelle","v":242.9223683058876},{"$f":" tolerance_Wei*ValMini_Wei","v":60.7305920764719},1,{"$f":"CONCATENATE(\"{\",PointsQuestion_Wei,\":NUMERICAL:=\",TEXT(Cible_Wei,\"0.00E+00\"),\":\",TEXT(ABS(Tolere_Wei),\"0.00E+00\"),\"}\")","v":"{1:NUMERICAL:=2.43E+02:6.07E+01}"},null,null,null,null,null,5.3798973535404597,-1.0309304331587228,null,0.9413875957182628,0.25497439026991109]
[null,{"$f":"CONCATENATE(\"On r&eacute;alise des exp&eacute;riences traction sur un mat&eacute;riau fragile. On obtient un ensemble de contraintes &agrave; rupture suivantes : \",V9._Wei,\", \",V7._Wei,\", \",V5._Wei,\", \",V3._Wei,\",\")","v":"On r&eacute;alise des exp&eacute;riences traction sur un mat&eacute;riau fragile. On obtient un ensemble de contraintes &agrave; rupture suivantes : 268, 242, 240, 217,"},"<p>On r&eacute;alise des exp&eacute;riences traction sur un mat&eacute;riau fragile. On obtient un ensemble de contraintes &agrave; rupture suivant : \";V9._Wei;\", \";V7._Wei;\", \";V5._Wei;\", \";V3._Wei;\", \";V4._Wei;\", \";V6._Wei;\", \";V2._Wei;\", \";V8._Wei;\", \";V1._Wei;\" MPa. En deduire les param&egrave;tres de Weibull associ&eacute;s :</p>",null,null,null,null,null,null,null,null,null,null,null,5.3798973535404597,-0.67172699209212194,null,112.42864459803609,7]
[null,{"$f":"CONCATENATE(\" \",V4._Wei,\", \",V6._Wei,\", \",V2._Wei,\", \",V8._Wei,\", \",V1._Wei,\" MPa. En deduire les param&egrave;tres de Weibull associ&eacute;s :</p><p><p>&nbsp;</p><p><p>Le module m=\",R1.Module_Wei,\"</p><p><p>&nbsp;</p><p><p>&nbsp;</p><p><p>Le\")","v":" 217, 245, 213, 250, 196 MPa. En deduire les param&egrave;tres de Weibull associ&eacute;s :</p><p><p>&nbsp;</p><p><p>Le module m={1:NUMERICAL:=9.90E+00:2.48E+00}</p><p><p>&nbsp;</p><p><p>&nbsp;</p><p><p>Le"},"<p>&nbsp;</p>",null,null,null,null,null,null,null,null,null,null,null,5.4806389233419912,-0.36651292058166435,null,7.3092042624309208,0.45508357785459053]
[null,{"$f":"CONCATENATE(\"facteur d'&eacute;chelle Ko=\",R2.Exp_Wei,\" MPa</p><p><p>&nbsp;</p><p>\")","v":"facteur d'&eacute;chelle Ko={1:NUMERICAL:=2.43E+02:6.07E+01} MPa</p><p><p>&nbsp;</p><p>"},"<p>Le module m=\";Module;\"</p>",null,null,null,null,null,null,null,null,null,null,null,5.5012582105447274,-8.7421571790755173E-2]
[null,{"$f":"CONCATENATE(\"\")","v":""},"<p>&nbsp;</p>",null,null,null,null,null,null,null,null,null,null,null,5.4889377261566867,0.18562675886236557]
[null,{"$f":"CONCATENATE(\"\")","v":""},"<p>&nbsp;</p>",null,null,null,null,null,null,null,null,null,null,null,5.521460917862246,0.4758849953271107,null,"Facteur Echelle",{"$f":"EXP(-S16/R16)","v":242.9223683058876}]
[null,{"$f":"CONCATENATE(\"\")","v":""},"<p>Le facteur d'&eacute;chelle Ko=\";Facteur_Echelle;\" MPa</p>",null,null,null,null,null,null,null,null,null,null,null,5.5909869805108565,0.83403244524795594]
[null,null,"<p>&nbsp;</p>"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"On réalise des expériences traction sur un matériau fragile. On obtient un ensemble de contraintes à rupture suivant : \",V9._Wei,\", \",V7._Wei,\", \",V5._Wei,\", \",V3._Wei,\", \",V4._Wei,\", \",V6._Wei,\", \",V2._Wei,\", \",V8._Wei,\", \",V1._Wei,\" MPa. En deduire les paramètres de Weibull associés :\\\\\")","v":"On réalise des expériences traction sur un matériau fragile. On obtient un ensemble de contraintes à rupture suivant : 268, 242, 240, 217, 217, 245, 213, 250, 196 MPa. En deduire les paramètres de Weibull associés :\\\\"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Le module \\minisol{m=\",Module,\"}\\\\\")","v":"Le module \\minisol{m=9.9}\\\\"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Le facteur d'échelle Ko=\\minisol{\",ROUND(Facteur_Echelle,0),\"} MPa\")","v":"Le facteur d'échelle Ko=\\minisol{243} MPa"}]

{"sheet":"Stat","index":5,"n_rows":985,"n_cols":16,"rows_kept":985,"cut":false,"hidden":false,"merged":[]}
["catégorie_Stat","Incert_Stat",{"$f":"CONCATENATE(\" <!--  question XLQ \", titre_Stat, \"-->\")","v":" <!--  question XLQ Moy_et_Ecart-->"},null,null,"Valeur Mini_Stat","Valeur Maxi_Stat","Sig. Digit_Stat","Val Choix_Stat",null,null,null,1,{"$f":"CONCATENATE(\"#\",M1,\"  ;  \")","v":"#1  ;  "}]
["titre_Stat","Moy_et_Ecart",{"$f":"CONCATENATE(\" <question type=\",CHAR(34),\"category\",CHAR(34),\"><category><text>\", categorie_Stat,\"</text></category></question>)\")","v":" <question type=\"category\"><category><text>Incert_Stat</text></category></question>)"},null,"V1._Stat",1,10,-1,{"$f":"RANDBETWEEN(ValMini_Stat*10^-SigDig_Stat, ValMaxi_Stat*10^-SigDig_Stat)/10^-SigDig_Stat","v":1.3},null,null,null,2,"#2  ;  "]
["Tag_Stat","M-STDV","    <question type=\"cloze\">",null,"V2._Stat",1,20,-1,12.8,null,null,null,3,"#3  ;  "]
["idnumber_Stat",{"$f":"TEXT(NOW(),\"aammjj-hhmmss.00\")","v":"210710-212021.19"},{"$f":"CONCATENATE(\"     <name><text>\", titre_Stat, \"</text></name>\")","v":"     <name><text>Moy_et_Ecart</text></name>"},null,"V3._Stat",1,30,-1,19.7,null,null,null,4,"#4  ;  "]
["points_Stat",1,"    <questiontext format=\"html\">",null,"V4._Stat",1,100,0,42,null,null,null,5,"#5  ;  "]
["tolérance_Stat",0.05,{"$f":"CONCATENATE(\"     <text><![CDATA[<p>\", question_Stat, \"</p>]]></text>\")","v":"     <text><![CDATA[<p>Pour cet ensemble de valeurs : 1.3  ;  12.8  ;  19.7  ;  42  ;  9  ;  24.2  ;  17.5  ;  12  ;  20  ;  14.5  ;  3.8  ;  6 , calculez la moyenne : {1:NUMERICAL:=1.52E+01:7.62E-01} et l'ecart type : {1:NUMERICAL:=1.09E+01:5.46E-01}<p></p>]]></text>"},null,"V5._Stat",6,16,-1,9,null,null,null,6,"#6  ;  "]
["penalité_Stat",0.1,"    </questiontext>",null,"V6._Stat",1,99,-1,24.2,null,null,null,7,"#7  ;  "]
["feedback_Stat","Statistiques",{"$f":"CONCATENATE(\"    <defaultgrade>\",points_Stat,\"</defaultgrade><generalfeedback><text>\",feedback_Stat,\"</text></generalfeedback><penalty>\",penalty_Stat,\"</penalty><hidden>0</hidden>)\")","v":"    <defaultgrade>1</defaultgrade><generalfeedback><text>Statistiques</text></generalfeedback><penalty>0.1</penalty><hidden>0</hidden>)"},null,"V7._Stat",1,22,-1,17.5,null,null,null,8,"#8  ;  "]
["Cellule vides_Stat",{"$f":"COUNTBLANK(B1:B8)","v":0},{"$f":"CONCATENATE(\"    <idnumber>\",idnumber_Stat,\"</idnumber><tags><tag><text>\",Tag_Stat,\"</text></tag></tags>\")","v":"    <idnumber>210710-212021.19</idnumber><tags><tag><text>M-STDV</text></tag></tags>"},null,"V8._Stat",1,74,0,12,null,null,null,9,"#9  ;  "]
["question format HTML_Stat",{"$f":"CONCATENATE(C19, C20, C21, C22)","v":"Pour cet ensemble de valeurs : 1.3  ;  12.8  ;  19.7  ;  42  ;  9  ;  24.2  ;  17.5  ;  12  ;  20  ;  14.5  ;  3.8  ;  6 , calculez la moyenne : {1:NUMERICAL:=1.52E+01:7.62E-01} et l'ecart type : {1:NUMERICAL:=1.09E+01:5.46E-01}<p>"},"   </question>",null,"V9._Stat",5,35,1,20,null,null,null,10,"#10  ;  "]
["Repere Var Rep","_Stat",null,null,"V10._Stat",9,26,-1,14.5,null,null,null,11,"#11  ;  "]
["HTML File ","Stats.txt",null,null,"V11._Stat",3,12,-1,3.8,null,null,null,12,"#12  ;  "]
["Valide ? ",{"$f":"ISNUMBER(H18)","v":true},null,null,"V12._Stat",4,12,0,6]
["https://html-online.com/editor/ ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Pour cet ensemble de valeurs : \",N1,N2,N3,N4,N5,N6,N7,N8,N9,N10,N11,N12,\", calculez la moyenne : $1 et l'ecart type : $2.\")","v":"Pour cet ensemble de valeurs : #1  ;  #2  ;  #3  ;  #4  ;  #5  ;  #6  ;  #7  ;  #8  ;  #9  ;  #10  ;  #11  ;  #12  ;  , calculez la moyenne : $1 et l'ecart type : $2."}]
["https://html5-editor.net/",null,14,null,null,"Cible_Stat","Tolér_Stat","Sig. Digit_Stat",null,null,null,null,"Pour cet ensemble de valeurs : #1  ;  #2  ;  #3  ;  #4  ;  #5  ;  #6  ;  #7  ;  #8  ;  #9  ;  #10  ;  #11  ;  #12 , calculez la moyenne : $1 et l'ecart type : $2"]
["Var : ","#",12,null,"R1.Moy_Stat",{"$f":"AVERAGE(I2:I13)","v":15.233333333333334},{"$f":" tolerance_Stat*ValMini_Stat","v":0.76166666666666671},1,{"$f":"CONCATENATE(\"{1:NUMERICAL:=\",TEXT(Cible_Stat,\"0.00E+00\"),\":\",TEXT(Tolere_Stat,\"0.00E+00\"),\"}\")","v":"{1:NUMERICAL:=1.52E+01:7.62E-01}"}]
["Res : ","$",2,null,"R2.Ecart_Stat",{"$f":"STDEV(I2:I13)","v":10.915154880284843},{"$f":" tolerance_Stat*ValMini_Stat","v":0.54575774401424215},1,{"$f":"CONCATENATE(\"{1:NUMERICAL:=\",TEXT(Cible_Stat,\"0.00E+00\"),\":\",TEXT(Tolere_Stat,\"0.00E+00\"),\"}\")","v":"{1:NUMERICAL:=1.09E+01:5.46E-01}"}]
[null,null,null,null,null,null,null,{"$f":"SUM(F16:H17)","v":29.455912624299085}]
["","",{"$f":"CONCATENATE(\"Pour cet ensemble de valeurs : \",V1._Stat,\"  ;  \",V2._Stat,\"  ;  \",V3._Stat,\"  ;\")","v":"Pour cet ensemble de valeurs : 1.3  ;  12.8  ;  19.7  ;"}]
["","",{"$f":"CONCATENATE(\"  \",V4._Stat,\"  ;  \",V5._Stat,\"  ;  \",V6._Stat,\"  ;  \",V7._Stat,\"  ;  \",V8._Stat,\"  ;  \",V9._Stat,\"  ;  \",V10._Stat,\"  ;\")","v":"  42  ;  9  ;  24.2  ;  17.5  ;  12  ;  20  ;  14.5  ;"}]
["","",{"$f":"CONCATENATE(\"  \",V11._Stat,\"  ;  \",V12._Stat,\" , calculez la moyenne : \",R1.Moy_Stat,\" et l'ecar\")","v":"  3.8  ;  6 , calculez la moyenne : {1:NUMERICAL:=1.52E+01:7.62E-01} et l'ecar"}]
["","",{"$f":"CONCATENATE(\"t type : \",R2.Ecart_Stat,\"<p>\")","v":"t type : {1:NUMERICAL:=1.09E+01:5.46E-01}<p>"}]
["","",null,null,7.8,19.899999999999999,19.3,82,14.2,80.099999999999994,10.4,72,10,22.8,8.4,9]
["",null,null,null,{"$f":"AVERAGE(E23:P23)","v":29.658333333333331}]
["","",null,null,{"$f":"STDEV(E23:P23)","v":29.663490211287545}]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]

{"sheet":"Expr","index":6,"n_rows":32,"n_cols":18,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["catégorie_EPhy","Expr_Phys",{"$f":"CONCATENATE(\" <!--  question XLQ \", titre_EPhy, \"-->\")","v":" <!--  question XLQ Expr_Phys-->"},null,null,"Valeur Mini","Valeur Maxi","Sig. Digit","Val Choix","ODG",null,null,null,null,null,"u"]
["titre_EPhy","Expr_Phys",{"$f":"CONCATENATE(\" <question type=\",CHAR(34),\"category\",CHAR(34),\"><category><text>\", categorie_EPhy,\"</text></category></question>)\")","v":" <question type=\"category\"><category><text>Expr_Phys</text></category></question>)"},null,"VarA_EPhy",{"$f":"RAND()*10^(J2)","v":6.4606186351972066E-7},{"$f":"ROUND(F2,1-INT(LOG10(ABS(M2))))","v":6.4610000000000005E-7},null,null,-6,null,"DeltA_EPhy",{"$f":"F2*10^(-3*(RAND()+0.1))","v":2.0915882899726073E-9},{"$f":"ROUNDUP(M2,1-INT(LOG10(ABS(M2))))","v":2.1000000000000002E-9}]
["Tag_EPhy","Ecriture_correcte","    <question type=\"cloze\">",null,"VarB_EPhy",{"$f":"RAND()*10^(J3)","v":6.2038799704726996E-4},{"$f":"ROUND(F3,1-INT(LOG10(ABS(M3))))","v":6.2E-4},null,null,-3,null,"DelB_EPhy",{"$f":"F3*10^(-3*(RAND()+0.1))","v":2.0547564606886078E-4},{"$f":"ROUNDUP(M3,1-INT(LOG10(ABS(M3))))","v":2.1000000000000001E-4}]
["idnumber_EPhy",{"$f":"TEXT(NOW(),\"aammjj-hhmmss.00\")","v":"210710-212021.19"},{"$f":"CONCATENATE(\"     <name><text>\", titre_EPhy, \"</text></name>\")","v":"     <name><text>Expr_Phys</text></name>"},null,"VarC_EPhy",{"$f":"RAND()*10^(J4)","v":942.56189715182472},{"$f":"ROUND(F4,1-INT(LOG10(ABS(M4))))","v":940},null,null,3,null,"DeltC_EPhy",{"$f":"F4*10^(-3*(RAND()+0.1))","v":125.53032828988661},{"$f":"ROUNDUP(M4,1-INT(LOG10(ABS(M4))))","v":130}]
["points_EPhy",1,"    <questiontext format=\"html\">",null,"VarD_EPhy",{"$f":"RAND()*10^(J5)","v":207238.51958729644},{"$f":"ROUND(F5,1-INT(LOG10(ABS(M5))))","v":207240},null,null,6,null,"DeltD_EPhy",{"$f":"F5*10^(-3*(RAND()+0.1))","v":721.29216522751403},{"$f":"ROUNDUP(M5,1-INT(LOG10(ABS(M5))))","v":730}]
["tolérance_EPhy",0.05,{"$f":"CONCATENATE(\"     <text><![CDATA[<p>\", question_EPhy, \"</p>]]></text>\")","v":"     <text><![CDATA[<p><p>Exprimer correctement ces r&eacute;sultats num&eacute;riques (valeur, incertitude et pr&eacute;fixe : f,n,u,m,-,k,M,G,T) :</p><ul><li>203229312576.579+/-10551759595.7798={1:NUMERICAL:=203:20.3}+/-{1:NUMERICAL:=11:1.1}{1:SHORTANSWER:=G}<BR>207238.519587296+/-721.292165227514={1:NUMERICAL:=207240:20724}+/-{1:NUMERICAL:=730:73}{1:SHORTANSWER:=-}<BR>942.561897151825+/-125.530328289887={1:NUMERICAL:=940:94}+/-{1:NUMERICAL:=130:13}{1:SHORTANSWER:=-}<BR>0.00062038799704727+/-0.000205475646068861={1:NUMERICAL:=620:62}+/-{1:NUMERICAL:=210:21}{1:SHORTANSWER:=u}<BR>6.46061863519721E-07+/-2.09158828997261E-09={1:NUMERICAL:=646.1:64.61}+/-{1:NUMERICAL:=2.1:0.21}{1:SHORTANSWER:=n}<BR></li></ul></p>]]></text>"},null,"VarE_EPhy",{"$f":"RAND()*10^(J6)","v":203229312576.5795},{"$f":"ROUND(F6,1-INT(LOG10(ABS(M6))))","v":203000000000},null,null,12,null,"DeltE_EPhy",{"$f":"F6*10^(-3*(RAND()+0.1))","v":10551759595.77977},{"$f":"ROUNDUP(M6,1-INT(LOG10(ABS(M6))))","v":11000000000}]
["penalité_EPhy",0.1,"    </questiontext>"]
["feedback_EPhy","revoir_le_cours",{"$f":"CONCATENATE(\"    <defaultgrade>\",points_EPhy,\"</defaultgrade><generalfeedback><text>\",feedback_EPhy,\"</text></generalfeedback><penalty>\",penalty_EPhy,\"</penalty><hidden>0</hidden>)\")","v":"    <defaultgrade>1</defaultgrade><generalfeedback><text>revoir_le_cours</text></generalfeedback><penalty>0.1</penalty><hidden>0</hidden>)"}]
["Cellule vides_Ephys",{"$f":"COUNTBLANK(B1:B8)","v":0},{"$f":"CONCATENATE(\"    <idnumber>\",idnumber_EPhy,\"</idnumber><tags><tag><text>\",Tag_EPhy,\"</text></tag></tags>\")","v":"    <idnumber>210710-212021.19</idnumber><tags><tag><text>Ecriture_correcte</text></tag></tags>"}]
["question format HTML_EPhy",{"$f":"CONCATENATE(\"<p>Exprimer correctement ces r&eacute;sultats num&eacute;riques (valeur, incertitude et pr&eacute;fixe : f,n,u,m,-,k,M,G,T) :</p><ul><li>\",TRIM(I20),\"</li></ul>\")","v":"<p>Exprimer correctement ces r&eacute;sultats num&eacute;riques (valeur, incertitude et pr&eacute;fixe : f,n,u,m,-,k,M,G,T) :</p><ul><li>203229312576.579+/-10551759595.7798={1:NUMERICAL:=203:20.3}+/-{1:NUMERICAL:=11:1.1}{1:SHORTANSWER:=G}<BR>207238.519587296+/-721.292165227514={1:NUMERICAL:=207240:20724}+/-{1:NUMERICAL:=730:73}{1:SHORTANSWER:=-}<BR>942.561897151825+/-125.530328289887={1:NUMERICAL:=940:94}+/-{1:NUMERICAL:=130:13}{1:SHORTANSWER:=-}<BR>0.00062038799704727+/-0.000205475646068861={1:NUMERICAL:=620:62}+/-{1:NUMERICAL:=210:21}{1:SHORTANSWER:=u}<BR>6.46061863519721E-07+/-2.09158828997261E-09={1:NUMERICAL:=646.1:64.61}+/-{1:NUMERICAL:=2.1:0.21}{1:SHORTANSWER:=n}<BR></li></ul>"},"   </question>"," "]
["Repere Var Rep","_Ephys"]
["HTML File ","Expression.HTML.txt"]
["Valide ? ",{"$f":"ISNUMBER(G19)","v":true},null,null,null,"Resltat X","Delta X"]
["https://html-online.com/editor/ ",null,null,null,"ResA_EPhy",{"$f":"CONCATENATE(\nIF(N2<1000000000000000,IF(N2>=1000000000000,CONCATENATE(ABS(G2)/1000000000000,\"\"),\"\"),\"\"),\nIF(N2<1000000000000,IF(N2>=1000000000,CONCATENATE(ABS(G2)/1000000000,\"\"),\"\"),\"\"),\nIF(N2<1000000000,IF(N2>=1000000,CONCATENATE(ABS(G2)/1000000,\"\"),\"\"),\"\"),\nIF(N2<1000000,IF(N2>=1000,CONCATENATE(ABS(G2)/1000,\"\"),\"\"),\"\"),\nIF(N2<1000,IF(N2>=1,CONCATENATE(ABS(G2)/1,\"\"),\"\"),\"\"),\nIF(N2<1,IF(N2>=0.001,CONCATENATE(ABS(G2)/0.001,\"\"),\"\"),\"\"),\nIF(N2<0.001,IF(N2>=0.000001,CONCATENATE(ABS(G2)/0.000001,\"\"),\"\"),\"\"),\nIF(N2<0.000001,IF(N2>=0.000000001,CONCATENATE(ABS(G2)/0.000000001,\"\"),\"\"),\"\"),\nIF(N2<0.000000001,IF(N2>=0.000000000001,CONCATENATE(ABS(G2)/0.000000000001,\"\"),\"\"),\"\"))","v":"646.1"},{"$f":"CONCATENATE(\nIF(N2<1000000000000000,IF(N2>=1000000000000,CONCATENATE(ABS(N2)/1000000000000,\"\"),\"\"),\"\"),\nIF(N2<1000000000000,IF(N2>=1000000000,CONCATENATE(ABS(N2)/1000000000,\"\"),\"\"),\"\"),\nIF(N2<1000000000,IF(N2>=1000000,CONCATENATE(ABS(N2)/1000000,\"\"),\"\"),\"\"),\nIF(N2<1000000,IF(N2>=1000,CONCATENATE(ABS(N2)/1000,\"\"),\"\"),\"\"),\nIF(N2<1000,IF(N2>=1,CONCATENATE(ABS(N2)/1,\"\"),\"\"),\"\"),\nIF(N2<1,IF(N2>=0.001,CONCATENATE(ABS(N2)/0.001,\"\"),\"\"),\"\"),\nIF(N2<0.001,IF(N2>=0.000001,CONCATENATE(ABS(N2)/0.000001,\"\"),\"\"),\"\"),\nIF(N2<0.000001,IF(N2>=0.000000001,CONCATENATE(ABS(N2)/0.000000001,\"\"),\"\"),\"\"),\nIF(N2<0.000000001,IF(N2>=0.000000000001,CONCATENATE(ABS(N2)/0.000000000001,\"\"),\"\"),\"\"),\n)","v":"2.1"},{"$f":"CONCATENATE(\nIF(N2<1000000000000000,IF(N2>=1000000000000,\"T\",\"\"),\"\"),\nIF(N2<1000000000000,IF(N2>=1000000000,\"G\",\"\"),\"\"),\nIF(N2<1000000000,IF(N2>=1000000,\"M\",\"\"),\"\"),\nIF(N2<1000000,IF(N2>=1000,\"k\",\"\"),\"\"),\nIF(N2<1000,IF(N2>=1,\"-\",\"\"),\"\"),\nIF(N2<1,IF(N2>=0.001,\"m\",\"\"),\"\"),\nIF(N2<0.001,IF(N2>=0.000001,\"u\",\"\"),\"\"),\nIF(N2<0.000001,IF(N2>=0.000000001,\"n\",\"\"),\"\"),\nIF(N2<0.000000001,IF(N2>=0.000000000001,\"p\",\"\"),\"\"),\n)","v":"n"},{"$f":"IF(ISNA(G14),\"\",TRIM(CONCATENATE(F2,\"+/-\",M2,\"={1:NUMERICAL:=\",F14,\":\",F14/10,\"}+/-{1:NUMERICAL:=\",G14,\":\",G14/10,\"}{1:SHORTANSWER:=\",H14,\"}<BR>\")))","v":"6.46061863519721E-07+/-2.09158828997261E-09={1:NUMERICAL:=646.1:64.61}+/-{1:NUMERICAL:=2.1:0.21}{1:SHORTANSWER:=n}<BR>"}]
[null,null,3,null,"ResB_EPhy",{"$f":"CONCATENATE(\nIF(N3<1000000000000000,IF(N3>=1000000000000,CONCATENATE(ABS(G3)/1000000000000,\"\"),\"\"),\"\"),\nIF(N3<1000000000000,IF(N3>=1000000000,CONCATENATE(ABS(G3)/1000000000,\"\"),\"\"),\"\"),\nIF(N3<1000000000,IF(N3>=1000000,CONCATENATE(ABS(G3)/1000000,\"\"),\"\"),\"\"),\nIF(N3<1000000,IF(N3>=1000,CONCATENATE(ABS(G3)/1000,\"\"),\"\"),\"\"),\nIF(N3<1000,IF(N3>=1,CONCATENATE(ABS(G3)/1,\"\"),\"\"),\"\"),\nIF(N3<1,IF(N3>=0.001,CONCATENATE(ABS(G3)/0.001,\"\"),\"\"),\"\"),\nIF(N3<0.001,IF(N3>=0.000001,CONCATENATE(ABS(G3)/0.000001,\"\"),\"\"),\"\"),\nIF(N3<0.000001,IF(N3>=0.000000001,CONCATENATE(ABS(G3)/0.000000001,\"\"),\"\"),\"\"),\nIF(N3<0.000000001,IF(N3>=0.000000000001,CONCATENATE(ABS(G3)/0.000000000001,\"\"),\"\"),\"\"))","v":"620"},{"$f":"CONCATENATE(\nIF(N3<1000000000000000,IF(N3>=1000000000000,CONCATENATE(ABS(N3)/1000000000000,\"\"),\"\"),\"\"),\nIF(N3<1000000000000,IF(N3>=1000000000,CONCATENATE(ABS(N3)/1000000000,\"\"),\"\"),\"\"),\nIF(N3<1000000000,IF(N3>=1000000,CONCATENATE(ABS(N3)/1000000,\"\"),\"\"),\"\"),\nIF(N3<1000000,IF(N3>=1000,CONCATENATE(ABS(N3)/1000,\"\"),\"\"),\"\"),\nIF(N3<1000,IF(N3>=1,CONCATENATE(ABS(N3)/1,\"\"),\"\"),\"\"),\nIF(N3<1,IF(N3>=0.001,CONCATENATE(ABS(N3)/0.001,\"\"),\"\"),\"\"),\nIF(N3<0.001,IF(N3>=0.000001,CONCATENATE(ABS(N3)/0.000001,\"\"),\"\"),\"\"),\nIF(N3<0.000001,IF(N3>=0.000000001,CONCATENATE(ABS(N3)/0.000000001,\"\"),\"\"),\"\"),\nIF(N3<0.000000001,IF(N3>=0.000000000001,CONCATENATE(ABS(N3)/0.000000000001,\"\"),\"\"),\"\"),\n)","v":"210"},{"$f":"CONCATENATE(\nIF(N3<1000000000000000,IF(N3>=1000000000000,\"T\",\"\"),\"\"),\nIF(N3<1000000000000,IF(N3>=1000000000,\"G\",\"\"),\"\"),\nIF(N3<1000000000,IF(N3>=1000000,\"M\",\"\"),\"\"),\nIF(N3<1000000,IF(N3>=1000,\"k\",\"\"),\"\"),\nIF(N3<1000,IF(N3>=1,\"-\",\"\"),\"\"),\nIF(N3<1,IF(N3>=0.001,\"m\",\"\"),\"\"),\nIF(N3<0.001,IF(N3>=0.000001,\"u\",\"\"),\"\"),\nIF(N3<0.000001,IF(N3>=0.000000001,\"n\",\"\"),\"\"),\nIF(N3<0.000000001,IF(N3>=0.000000000001,\"p\",\"\"),\"\"),\n)","v":"u"},{"$f":"IF(ISNA(G15),\"\",TRIM(CONCATENATE(F3,\"+/-\",M3,\"={1:NUMERICAL:=\",F15,\":\",F15/10,\"}+/-{1:NUMERICAL:=\",G15,\":\",G15/10,\"}{1:SHORTANSWER:=\",H15,\"}<BR>\")))","v":"0.00062038799704727+/-0.000205475646068861={1:NUMERICAL:=620:62}+/-{1:NUMERICAL:=210:21}{1:SHORTANSWER:=u}<BR>"}]
["Var : ","#",0,null,"ResC_EPhy",{"$f":"CONCATENATE(\nIF(N4<1000000000000000,IF(N4>=1000000000000,CONCATENATE(ABS(G4)/1000000000000,\"\"),\"\"),\"\"),\nIF(N4<1000000000000,IF(N4>=1000000000,CONCATENATE(ABS(G4)/1000000000,\"\"),\"\"),\"\"),\nIF(N4<1000000000,IF(N4>=1000000,CONCATENATE(ABS(G4)/1000000,\"\"),\"\"),\"\"),\nIF(N4<1000000,IF(N4>=1000,CONCATENATE(ABS(G4)/1000,\"\"),\"\"),\"\"),\nIF(N4<1000,IF(N4>=1,CONCATENATE(ABS(G4)/1,\"\"),\"\"),\"\"),\nIF(N4<1,IF(N4>=0.001,CONCATENATE(ABS(G4)/0.001,\"\"),\"\"),\"\"),\nIF(N4<0.001,IF(N4>=0.000001,CONCATENATE(ABS(G4)/0.000001,\"\"),\"\"),\"\"),\nIF(N4<0.000001,IF(N4>=0.000000001,CONCATENATE(ABS(G4)/0.000000001,\"\"),\"\"),\"\"),\nIF(N4<0.000000001,IF(N4>=0.000000000001,CONCATENATE(ABS(G4)/0.000000000001,\"\"),\"\"),\"\"))","v":"940"},{"$f":"CONCATENATE(\nIF(N4<1000000000000000,IF(N4>=1000000000000,CONCATENATE(ABS(N4)/1000000000000,\"\"),\"\"),\"\"),\nIF(N4<1000000000000,IF(N4>=1000000000,CONCATENATE(ABS(N4)/1000000000,\"\"),\"\"),\"\"),\nIF(N4<1000000000,IF(N4>=1000000,CONCATENATE(ABS(N4)/1000000,\"\"),\"\"),\"\"),\nIF(N4<1000000,IF(N4>=1000,CONCATENATE(ABS(N4)/1000,\"\"),\"\"),\"\"),\nIF(N4<1000,IF(N4>=1,CONCATENATE(ABS(N4)/1,\"\"),\"\"),\"\"),\nIF(N4<1,IF(N4>=0.001,CONCATENATE(ABS(N4)/0.001,\"\"),\"\"),\"\"),\nIF(N4<0.001,IF(N4>=0.000001,CONCATENATE(ABS(N4)/0.000001,\"\"),\"\"),\"\"),\nIF(N4<0.000001,IF(N4>=0.000000001,CONCATENATE(ABS(N4)/0.000000001,\"\"),\"\"),\"\"),\nIF(N4<0.000000001,IF(N4>=0.000000000001,CONCATENATE(ABS(N4)/0.000000000001,\"\"),\"\"),\"\"),\n)","v":"130"},{"$f":"CONCATENATE(\nIF(N4<1000000000000000,IF(N4>=1000000000000,\"T\",\"\"),\"\"),\nIF(N4<1000000000000,IF(N4>=1000000000,\"G\",\"\"),\"\"),\nIF(N4<1000000000,IF(N4>=1000000,\"M\",\"\"),\"\"),\nIF(N4<1000000,IF(N4>=1000,\"k\",\"\"),\"\"),\nIF(N4<1000,IF(N4>=1,\"-\",\"\"),\"\"),\nIF(N4<1,IF(N4>=0.001,\"m\",\"\"),\"\"),\nIF(N4<0.001,IF(N4>=0.000001,\"u\",\"\"),\"\"),\nIF(N4<0.000001,IF(N4>=0.000000001,\"n\",\"\"),\"\"),\nIF(N4<0.000000001,IF(N4>=0.000000000001,\"p\",\"\"),\"\"),\n)","v":"-"},{"$f":"IF(ISNA(G16),\"\",TRIM(CONCATENATE(F4,\"+/-\",M4,\"={1:NUMERICAL:=\",F16,\":\",F16/10,\"}+/-{1:NUMERICAL:=\",G16,\":\",G16/10,\"}{1:SHORTANSWER:=\",H16,\"}<BR>\")))","v":"942.561897151825+/-125.530328289887={1:NUMERICAL:=940:94}+/-{1:NUMERICAL:=130:13}{1:SHORTANSWER:=-}<BR>"}]
["Res : ","$",10,null,"ResD_EPhy",{"$f":"CONCATENATE(\nIF(N5<1000000000000000,IF(N5>=1000000000000,CONCATENATE(ABS(G5)/1000000000000,\"\"),\"\"),\"\"),\nIF(N5<1000000000000,IF(N5>=1000000000,CONCATENATE(ABS(G5)/1000000000,\"\"),\"\"),\"\"),\nIF(N5<1000000000,IF(N5>=1000000,CONCATENATE(ABS(G5)/1000000,\"\"),\"\"),\"\"),\nIF(N5<1000000,IF(N5>=1000,CONCATENATE(ABS(G5)/1000,\"\"),\"\"),\"\"),\nIF(N5<1000,IF(N5>=1,CONCATENATE(ABS(G5)/1,\"\"),\"\"),\"\"),\nIF(N5<1,IF(N5>=0.001,CONCATENATE(ABS(G5)/0.001,\"\"),\"\"),\"\"),\nIF(N5<0.001,IF(N5>=0.000001,CONCATENATE(ABS(G5)/0.000001,\"\"),\"\"),\"\"),\nIF(N5<0.000001,IF(N5>=0.000000001,CONCATENATE(ABS(G5)/0.000000001,\"\"),\"\"),\"\"),\nIF(N5<0.000000001,IF(N5>=0.000000000001,CONCATENATE(ABS(G5)/0.000000000001,\"\"),\"\"),\"\"))","v":"207240"},{"$f":"CONCATENATE(\nIF(N5<1000000000000000,IF(N5>=1000000000000,CONCATENATE(ABS(N5)/1000000000000,\"\"),\"\"),\"\"),\nIF(N5<1000000000000,IF(N5>=1000000000,CONCATENATE(ABS(N5)/1000000000,\"\"),\"\"),\"\"),\nIF(N5<1000000000,IF(N5>=1000000,CONCATENATE(ABS(N5)/1000000,\"\"),\"\"),\"\"),\nIF(N5<1000000,IF(N5>=1000,CONCATENATE(ABS(N5)/1000,\"\"),\"\"),\"\"),\nIF(N5<1000,IF(N5>=1,CONCATENATE(ABS(N5)/1,\"\"),\"\"),\"\"),\nIF(N5<1,IF(N5>=0.001,CONCATENATE(ABS(N5)/0.001,\"\"),\"\"),\"\"),\nIF(N5<0.001,IF(N5>=0.000001,CONCATENATE(ABS(N5)/0.000001,\"\"),\"\"),\"\"),\nIF(N5<0.000001,IF(N5>=0.000000001,CONCATENATE(ABS(N5)/0.000000001,\"\"),\"\"),\"\"),\nIF(N5<0.000000001,IF(N5>=0.000000000001,CONCATENATE(ABS(N5)/0.000000000001,\"\"),\"\"),\"\"),\n)","v":"730"},{"$f":"CONCATENATE(\nIF(N5<1000000000000000,IF(N5>=1000000000000,\"T\",\"\"),\"\"),\nIF(N5<1000000000000,IF(N5>=1000000000,\"G\",\"\"),\"\"),\nIF(N5<1000000000,IF(N5>=1000000,\"M\",\"\"),\"\"),\nIF(N5<1000000,IF(N5>=1000,\"k\",\"\"),\"\"),\nIF(N5<1000,IF(N5>=1,\"-\",\"\"),\"\"),\nIF(N5<1,IF(N5>=0.001,\"m\",\"\"),\"\"),\nIF(N5<0.001,IF(N5>=0.000001,\"u\",\"\"),\"\"),\nIF(N5<0.000001,IF(N5>=0.000000001,\"n\",\"\"),\"\"),\nIF(N5<0.000000001,IF(N5>=0.000000000001,\"p\",\"\"),\"\"),\n)","v":"-"},{"$f":"IF(ISNA(G17),\"\",TRIM(CONCATENATE(F5,\"+/-\",M5,\"={1:NUMERICAL:=\",F17,\":\",F17/10,\"}+/-{1:NUMERICAL:=\",G17,\":\",G17/10,\"}{1:SHORTANSWER:=\",H17,\"}<BR>\")))","v":"207238.519587296+/-721.292165227514={1:NUMERICAL:=207240:20724}+/-{1:NUMERICAL:=730:73}{1:SHORTANSWER:=-}<BR>"}]
[null,null,null,null,"ResE_EPhy",{"$f":"CONCATENATE(\nIF(N6<1000000000000000,IF(N6>=1000000000000,CONCATENATE(ABS(G6)/1000000000000,\"\"),\"\"),\"\"),\nIF(N6<1000000000000,IF(N6>=1000000000,CONCATENATE(ABS(G6)/1000000000,\"\"),\"\"),\"\"),\nIF(N6<1000000000,IF(N6>=1000000,CONCATENATE(ABS(G6)/1000000,\"\"),\"\"),\"\"),\nIF(N6<1000000,IF(N6>=1000,CONCATENATE(ABS(G6)/1000,\"\"),\"\"),\"\"),\nIF(N6<1000,IF(N6>=1,CONCATENATE(ABS(G6)/1,\"\"),\"\"),\"\"),\nIF(N6<1,IF(N6>=0.001,CONCATENATE(ABS(G6)/0.001,\"\"),\"\"),\"\"),\nIF(N6<0.001,IF(N6>=0.000001,CONCATENATE(ABS(G6)/0.000001,\"\"),\"\"),\"\"),\nIF(N6<0.000001,IF(N6>=0.000000001,CONCATENATE(ABS(G6)/0.000000001,\"\"),\"\"),\"\"),\nIF(N6<0.000000001,IF(N6>=0.000000000001,CONCATENATE(ABS(G6)/0.000000000001,\"\"),\"\"),\"\"))","v":"203"},{"$f":"CONCATENATE(\nIF(N6<1000000000000000,IF(N6>=1000000000000,CONCATENATE(ABS(N6)/1000000000000,\"\"),\"\"),\"\"),\nIF(N6<1000000000000,IF(N6>=1000000000,CONCATENATE(ABS(N6)/1000000000,\"\"),\"\"),\"\"),\nIF(N6<1000000000,IF(N6>=1000000,CONCATENATE(ABS(N6)/1000000,\"\"),\"\"),\"\"),\nIF(N6<1000000,IF(N6>=1000,CONCATENATE(ABS(N6)/1000,\"\"),\"\"),\"\"),\nIF(N6<1000,IF(N6>=1,CONCATENATE(ABS(N6)/1,\"\"),\"\"),\"\"),\nIF(N6<1,IF(N6>=0.001,CONCATENATE(ABS(N6)/0.001,\"\"),\"\"),\"\"),\nIF(N6<0.001,IF(N6>=0.000001,CONCATENATE(ABS(N6)/0.000001,\"\"),\"\"),\"\"),\nIF(N6<0.000001,IF(N6>=0.000000001,CONCATENATE(ABS(N6)/0.000000001,\"\"),\"\"),\"\"),\nIF(N6<0.000000001,IF(N6>=0.000000000001,CONCATENATE(ABS(N6)/0.000000000001,\"\"),\"\"),\"\"),\n)","v":"11"},{"$f":"CONCATENATE(\nIF(N6<1000000000000000,IF(N6>=1000000000000,\"T\",\"\"),\"\"),\nIF(N6<1000000000000,IF(N6>=1000000000,\"G\",\"\"),\"\"),\nIF(N6<1000000000,IF(N6>=1000000,\"M\",\"\"),\"\"),\nIF(N6<1000000,IF(N6>=1000,\"k\",\"\"),\"\"),\nIF(N6<1000,IF(N6>=1,\"-\",\"\"),\"\"),\nIF(N6<1,IF(N6>=0.001,\"m\",\"\"),\"\"),\nIF(N6<0.001,IF(N6>=0.000001,\"u\",\"\"),\"\"),\nIF(N6<0.000001,IF(N6>=0.000000001,\"n\",\"\"),\"\"),\nIF(N6<0.000000001,IF(N6>=0.000000000001,\"p\",\"\"),\"\"),\n)","v":"G"},{"$f":"IF(ISNA(G18),\"\",TRIM(CONCATENATE(F6,\"+/-\",M6,\"={1:NUMERICAL:=\",F18,\":\",F18/10,\"}+/-{1:NUMERICAL:=\",G18,\":\",G18/10,\"}{1:SHORTANSWER:=\",H18,\"}<BR>\")))","v":"203229312576.579+/-10551759595.7798={1:NUMERICAL:=203:20.3}+/-{1:NUMERICAL:=11:1.1}{1:SHORTANSWER:=G}<BR>"}]
[null,null,"<p>Exprimer correctement ces résultats numériques :</p><ul><li>#1 +/- #6  =  $1 +/- $6 </li><li>#2 +/- #7  =  $2 +/- $7</li><li>#3 +/- #8  =  $3 +/- $8 </li><li>#4 +/- #9  =  $4 +/- $9 </li><li>#5 +/- #10  =  $5 +/- $10 </li></ul>",null,null,null,{"$f":"SUM(F14:G18)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(TRIM(ResE_EPhy),TRIM(ResD_EPhy),TRIM(ResC_EPhy),TRIM(ResB_EPhy),TRIM(ResA_EPhy))","v":"203229312576.579+/-10551759595.7798={1:NUMERICAL:=203:20.3}+/-{1:NUMERICAL:=11:1.1}{1:SHORTANSWER:=G}<BR>207238.519587296+/-721.292165227514={1:NUMERICAL:=207240:20724}+/-{1:NUMERICAL:=730:73}{1:SHORTANSWER:=-}<BR>942.561897151825+/-125.530328289887={1:NUMERICAL:=940:94}+/-{1:NUMERICAL:=130:13}{1:SHORTANSWER:=-}<BR>0.00062038799704727+/-0.000205475646068861={1:NUMERICAL:=620:62}+/-{1:NUMERICAL:=210:21}{1:SHORTANSWER:=u}<BR>6.46061863519721E-07+/-2.09158828997261E-09={1:NUMERICAL:=646.1:64.61}+/-{1:NUMERICAL:=2.1:0.21}{1:SHORTANSWER:=n}<BR>"}]
[]
[null,null,null,null,null,null,null,null," 12.4/10.1 + 7.5/3.7 "]
[]
[null,null,null,null,null,null,null,"val","D","%"]
[null,null,null,null,null,null,"A",12.4,{"$f":" 1/POWER(10,LEN(H25)-LEN(INT(H25))-(H25<>INT(H25))*1)","v":0.1},{"$f":"I25/H25","v":8.0645161290322578E-3},null,null,null,null,"Favorable",":",5,"voix"]
[null,null,null,null,null,null,"B",10.1,{"$f":" 1/POWER(10,LEN(H26)-LEN(INT(H26))-(H26<>INT(H26))*1)","v":0.1},{"$f":"I26/H26","v":9.9009900990099011E-3},null,null,null,null,"Défavorable",":",0,"voix"]
[null,null,null,null,null,null,"C",7.5,{"$f":" 1/POWER(10,LEN(H27)-LEN(INT(H27))-(H27<>INT(H27))*1)","v":0.1},{"$f":"I27/H27","v":1.3333333333333334E-2},null,null,null,null,"Abstention",":",1,"voix"]
[null,null,null,null,null,null,"D",3.7,{"$f":" 1/POWER(10,LEN(H28)-LEN(INT(H28))-(H28<>INT(H28))*1)","v":0.1},{"$f":"I28/H28","v":2.7027027027027029E-2}]
[null,null,null,null,null,null,"A/B",{"$f":"H25/H26","v":1.2277227722772277},{"$f":"H29*J29","v":0.22056661111655718},{"$f":"J25/I25+J26/I26","v":0.17965506228042158}]
[null,null,null,null,null,null,"C/D",{"$f":"H27/H28","v":2.0270270270270268},{"$f":"H30*J30","v":0.81811541271000721},{"$f":"J27/I27+J28/I28","v":0.40360360360360359}]
[null,null,null,null,null,null,"Moy",{"$f":"H25/H26+H27/H28","v":3.2547497993042542}]
[null,null,null,null,null,null,"Ratio"]

{"sheet":"AbsRel","index":7,"n_rows":32,"n_cols":13,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["catégorie_AbRe","Rel_abs",{"$f":"CONCATENATE(\" <!--  question XLQ \", titre_AbRe, \"-->\")","v":" <!--  question XLQ Rel_abs-->"},null,null,"Valeur Mini_AbRe","Valeur Maxi_AbRe","Sig. Digit_AbRe","Val Choix_AbRe"]
["titre_AbRe","Rel_abs",{"$f":"CONCATENATE(\" <question type=\",CHAR(34),\"category\",CHAR(34),\"><category><text>\", categorie_AbRe,\"</text></category></question>)\")","v":" <question type=\"category\"><category><text>Rel_abs</text></category></question>)"},null,"V1._AbRe",1,63,null,{"$f":"RANDBETWEEN(ValMini_AbRe*10^-SigDig_AbRe, ValMaxi_AbRe*10^-SigDig_AbRe)/10^-SigDig_AbRe","v":32},{"$f":"I4","v":4},{"$f":"J2/V1._AbRe*100","v":12.5}]
["Tag_AbRe","Incertitude","    <question type=\"cloze\">",null,"V2._AbRe",1,128,null,{"$f":"RANDBETWEEN(ValMini_AbRe*10^-SigDig_AbRe, ValMaxi_AbRe*10^-SigDig_AbRe)/10^-SigDig_AbRe","v":53},{"$f":"IncertAbsV1","v":4},{"$f":"J3/V1._AbRe*100","v":12.5}]
["idnumber_AbRe",{"$f":"TEXT(NOW(),\"aammjj-hhmmss.00\")","v":"210710-212021.19"},{"$f":"CONCATENATE(\"     <name><text>\", titre_AbRe, \"</text></name>\")","v":"     <name><text>Rel_abs</text></name>"},null,"V3._AbRe",1,6,0,{"$f":"RANDBETWEEN(ValMini_AbRe*10^-SigDig_AbRe, ValMaxi_AbRe*10^-SigDig_AbRe)/10^-SigDig_AbRe","v":4},null,{"$f":"(K3+K2)*V2._AbRe*V1._AbRe/100","v":424},{"$f":"G3*G2","v":8064},{"$f":"K4/L4","v":5.257936507936508E-2}]
["points_AbRe",1,"    <questiontext format=\"html\">",null,null,"Cible_AbRe","Tolér_AbRe","Sig. Digit_AbRe"]
["tolérance_AbRe",0.05,{"$f":"CONCATENATE(\"     <text><![CDATA[<p>\", question_AbRe, \"</p>]]></text>\")","v":"     <text><![CDATA[<p> <p>Calculer les <strong>incertitudes</strong> relative et absolue sur le produit p = A.B, le quotient q = A/B et la somme A+B, dont chaque terme est&nbsp;connu &agrave; une unit&eacute; pr&egrave;s. Application num&eacute;rique, A = 32, B = 53.&nbsp;</p><table><tbody><tr><td>&nbsp;</td><td>Somme</td><td>Ratio</td><td>Produit</td></tr><tr><td>Absolue</td><td>{1:NUMERICAL:=8.00E+00:4.00E-01}</td><td>{1:NUMERICAL:=1.21E-01:6.05E-03}</td><td>{1:NUMERICAL:=3.40E+02:1.70E+01}</td></tr><tr><td>Relative</td><td>{1:NUMERICAL:=9.41E-02:4.71E-03}</td><td>{1:NUMERICAL:=2.00E-01:1.00E-02}</td><td>{1:NUMERICAL:=2.00E-01:1.00E-02}</td></tr></tbody></table><p>&nbsp;</p></p>]]></text>"},null,"R1.AbsSomme_AbRe",{"$f":"IncertAbsV1+IncertAbsV2","v":8},{"$f":" tolerance_AbRe*ValMini_AbRe","v":0.4},1,{"$f":"CONCATENATE(\"{\",SigDig_AbRe,\":NUMERICAL:=\",TEXT(Cible_AbRe,\"0.00E+00\"),\":\",TEXT(Tolere_AbRe,\"0.00E+00\"),\"}\")","v":"{1:NUMERICAL:=8.00E+00:4.00E-01}"}]
["penalité_AbRe",0.1,"    </questiontext>",null,"R2.AbsRatio_AbRe",{"$f":"(V1._AbRe/V2._AbRe)*(IncertAbsV1/V1._AbRe+IncertAbsV2/V2._AbRe)","v":0.12103951584193662},6.0519757920968311E-3,1,"{1:NUMERICAL:=1.21E-01:6.05E-03}"]
["feedback_AbRe","Propagation",{"$f":"CONCATENATE(\"    <defaultgrade>\",points_AbRe,\"</defaultgrade><generalfeedback><text>\",feedback_AbRe,\"</text></generalfeedback><penalty>\",penalty_AbRe,\"</penalty><hidden>0</hidden>)\")","v":"    <defaultgrade>1</defaultgrade><generalfeedback><text>Propagation</text></generalfeedback><penalty>0.1</penalty><hidden>0</hidden>)"},null,"R3.AbsProd_AbRe",{"$f":"V2._AbRe*V1._AbRe*(IncertAbsV1/V1._AbRe+IncertAbsV2/V2._AbRe)","v":340},17,1,"{1:NUMERICAL:=3.40E+02:1.70E+01}"]
["Cellule vides_Trac",{"$f":"COUNTBLANK(B1:B8)","v":0},{"$f":"CONCATENATE(\"    <idnumber>\",idnumber_AbRe,\"</idnumber><tags><tag><text>\",Tag_AbRe,\"</text></tag></tags>\")","v":"    <idnumber>210710-212021.19</idnumber><tags><tag><text>Incertitude</text></tag></tags>"},null,"R4.RelSomme_AbRe",{"$f":"(IncertAbsV1+IncertAbsV2)/(V2._AbRe+V1._AbRe)","v":9.4117647058823528E-2},4.7058823529411769E-3,1,"{1:NUMERICAL:=9.41E-02:4.71E-03}"]
["question format HTML_AbRe",{"$f":"CONCATENATE(\" \",C19,C20,C21,C22,C23,C24,C25,C26,C27,C28)","v":" <p>Calculer les <strong>incertitudes</strong> relative et absolue sur le produit p = A.B, le quotient q = A/B et la somme A+B, dont chaque terme est&nbsp;connu &agrave; une unit&eacute; pr&egrave;s. Application num&eacute;rique, A = 32, B = 53.&nbsp;</p><table><tbody><tr><td>&nbsp;</td><td>Somme</td><td>Ratio</td><td>Produit</td></tr><tr><td>Absolue</td><td>{1:NUMERICAL:=8.00E+00:4.00E-01}</td><td>{1:NUMERICAL:=1.21E-01:6.05E-03}</td><td>{1:NUMERICAL:=3.40E+02:1.70E+01}</td></tr><tr><td>Relative</td><td>{1:NUMERICAL:=9.41E-02:4.71E-03}</td><td>{1:NUMERICAL:=2.00E-01:1.00E-02}</td><td>{1:NUMERICAL:=2.00E-01:1.00E-02}</td></tr></tbody></table><p>&nbsp;</p>"},"   </question>",null,"R5.RelRatio_AbRe",{"$f":"IncertAbsV1/V1._AbRe+IncertAbsV2/V2._AbRe","v":0.20047169811320753},1.0023584905660377E-2,1,"{1:NUMERICAL:=2.00E-01:1.00E-02}"]
["Repere Var Rep","_AbRe",null,null,"R6.RelProd_AbRe",{"$f":"IncertAbsV1/V1._AbRe+IncertAbsV2/V2._AbRe","v":0.20047169811320753},1.0023584905660377E-2,1,"{1:NUMERICAL:=2.00E-01:1.00E-02}"]
["HTML File ","Delta.HTML.txt"]
["Valide ? ",{"$f":"ISNUMBER(H13)","v":true},null,null,null,null,null,{"$f":"SUM(F6:H11)","v":372.04690558708359}]
["https://html-online.com/editor/ "]
[null,null,4]
["Var : ","#",2]
["Res : ","$",6,null,null,null,null,"12.4/10.1 + 7.5/3.7 "]
[]
[null,null,{"$f":"CONCATENATE(\"<p>Calculer les <strong>incertitudes</strong> relative et absolue s\")","v":"<p>Calculer les <strong>incertitudes</strong> relative et absolue s"}]
[null,null,{"$f":"CONCATENATE(\"ur le produit p = A.B, le quotient q = A/B et la s\")","v":"ur le produit p = A.B, le quotient q = A/B et la s"}]
[null,null,{"$f":"CONCATENATE(\"omme A+B, dont chaque terme est&nbsp;connu &agrave\")","v":"omme A+B, dont chaque terme est&nbsp;connu &agrave"}]
[null,null,{"$f":"CONCATENATE(\"; une unit&eacute; pr&egrave;s. Application num&ea\")","v":"; une unit&eacute; pr&egrave;s. Application num&ea"}]
[null,null,{"$f":"CONCATENATE(\"cute;rique, A = \",V1._AbRe,\", B = \",V2._AbRe,\".&nbsp;</p><table><tbody\")","v":"cute;rique, A = 32, B = 53.&nbsp;</p><table><tbody"}]
[null,null,{"$f":"CONCATENATE(\"><tr><td>&nbsp;</td><td>Somme</td><td>Ratio</td><t\")","v":"><tr><td>&nbsp;</td><td>Somme</td><td>Ratio</td><t"}]
[null,null,{"$f":"CONCATENATE(\"d>Produit</td></tr><tr><td>Absolue</td><td>\",R1.AbsSomme_AbRe,\"</td>\")","v":"d>Produit</td></tr><tr><td>Absolue</td><td>{1:NUMERICAL:=8.00E+00:4.00E-01}</td>"}]
[null,null,{"$f":"CONCATENATE(\"<td>\",R2.AbsRatio_AbRe,\"</td><td>\",R3.AbsProd_AbRe,\"</td></tr><tr><td>Relative</td><t\")","v":"<td>{1:NUMERICAL:=1.21E-01:6.05E-03}</td><td>{1:NUMERICAL:=3.40E+02:1.70E+01}</td></tr><tr><td>Relative</td><t"}]
[null,null,{"$f":"CONCATENATE(\"d>\",R4.RelSomme_AbRe,\"</td><td>\",R5.RelRatio_AbRe,\"</td><td>\",R5.RelRatio_AbRe,\"</td></tr></tbody></tabl\")","v":"d>{1:NUMERICAL:=9.41E-02:4.71E-03}</td><td>{1:NUMERICAL:=2.00E-01:1.00E-02}</td><td>{1:NUMERICAL:=2.00E-01:1.00E-02}</td></tr></tbody></tabl"}]
[null,null,{"$f":"CONCATENATE(\"e><p>&nbsp;</p>\")","v":"e><p>&nbsp;</p>"}]
[]
[]
[]
[null,{"$f":"question_AbRe","v":" <p>Calculer les <strong>incertitudes</strong> relative et absolue sur le produit p = A.B, le quotient q = A/B et la somme A+B, dont chaque terme est&nbsp;connu &agrave; une unit&eacute; pr&egrave;s. Application num&eacute;rique, A = 32, B = 53.&nbsp;</p><table><tbody><tr><td>&nbsp;</td><td>Somme</td><td>Ratio</td><td>Produit</td></tr><tr><td>Absolue</td><td>{1:NUMERICAL:=8.00E+00:4.00E-01}</td><td>{1:NUMERICAL:=1.21E-01:6.05E-03}</td><td>{1:NUMERICAL:=3.40E+02:1.70E+01}</td></tr><tr><td>Relative</td><td>{1:NUMERICAL:=9.41E-02:4.71E-03}</td><td>{1:NUMERICAL:=2.00E-01:1.00E-02}</td><td>{1:NUMERICAL:=2.00E-01:1.00E-02}</td></tr></tbody></table><p>&nbsp;</p>"}]

{"sheet":"Mobile-VQEc","index":8,"n_rows":32,"n_cols":79,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["catégorie_VQE","Mobile-VQEc_VQE",{"$f":"CONCATENATE(\"    <!--  question XLQ \", titre_VQE, \"-->\")","v":"    <!--  question XLQ Mobile-VQEc_VQE-->"},null,null,"Valeur Mini_VQE","Valeur Maxi_VQE","Sig. Digit_VQE","Val Choix_VQE",null,"max","min","Moy","Delta","Delta Rel"]
[null,"Mobile-VQEc_VQE",{"$f":"CONCATENATE(\"    <question type=\",CHAR(34),\"category\",CHAR(34),\"><category><text>\", categorie_VQE,\"</text></category></question>)\")","v":"    <question type=\"category\"><category><text>Mobile-VQEc_VQE</text></category></question>)"},null,"V1.distance_VQE",250,750,0,{"$f":"RANDBETWEEN(ValMini_VQE*10^-SigDig_VQE, ValMaxi_VQE*10^-SigDig_VQE)/10^-SigDig_VQE","v":357},"m",{"$f":"V1.distance_VQE*(1+V3.Deltad_VQE/100)","v":392.70000000000005},{"$f":"V1.distance_VQE*(1-V3.Deltad_VQE/100)","v":321.3},{"$f":"AVERAGE(K2,L2)","v":357},{"$f":"(K2-L2)/2","v":35.700000000000017},{"$f":"N2/M2","v":0.10000000000000005}]
["Tag_VQE","Mobile-VQEc_VQE","    <question type=\"cloze\">",null,"V2.temps_VQE",{"$f":"V1.distance_VQE/10","v":35.700000000000003},{"$f":"V1.distance_VQE/2","v":178.5},0,143,"s",{"$f":"V2.temps_VQE*(1+V4.Deltat_VQE/100)","v":147.29},{"$f":"V2.temps_VQE*(1-V4.Deltat_VQE/100)","v":138.71},{"$f":"AVERAGE(K3,L3)","v":143},{"$f":"(K3-L3)/2","v":4.289999999999992},{"$f":"N3/M3","v":2.9999999999999943E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Afin d'accéder à la vitesse v d'un mobile, on mesure la distance d = #1# <p>parcourue durant un intervalle de temps t : #2#. Les incertitudes sont<p>supposées indépendantes (de #3#% et #4#% respectivement). <p>On cherche à connaitre la vitesse de ce mobile : <p>En calculant pour les valeurs maximum Vmax=$1$ et minimum Vmin=$2$ de la vitesse, on peut déduire la vitess la plus probable $3$ et son incertitude $4$.<p>Si la masse du mobile est m=#5# +/- #6# kg, on peut en déterminer la quantité de mouvement $p=mv$ = $5$ +/- $6$ kg.ms-1.<p>et son énergie cinétique : $Ec=1/2 mv2$ ^=  $7$ +/- $8$ J.<p>"]
["idnumber_VQE",{"$f":"TEXT(NOW(),\"aammjj-hhmmss.00\")","v":"210710-212021.19"},{"$f":"CONCATENATE(\"        <name><text>\", titre_VQE, \"</text></name>\")","v":"        <name><text>Mobile-VQEc_VQE</text></name>"},null,"V3.Deltad_VQE",{"$f":"G4/2","v":7.64},{"$f":"1+V1.distance_VQE/25","v":15.28},0,10,"%"]
["points_VQE",1,"        <questiontext format=\"html\">",null,"V4.Deltat_VQE",{"$f":"G5/3","v":2.7166666666666668},{"$f":"1+V2.temps_VQE/20","v":8.15},0,3,"%"]
["tolérance_VQE",0.05,{"$f":"CONCATENATE(\"            <text><![CDATA[<p>\", question_VQE, \"</p>]]></text>\")","v":"            <text><![CDATA[<p> Afin d'acc&eacute;der &agrave; la vitesse v d'un mobile, on mesure la distance d = 357m <p>parcourue durant un intervalle de temps t : 143s. Les incertitudes sont<p>suppos&eacute;es ind&eacute;pendantes (de 10% et 3% respectivement).<p>Calculez les valeurs maximum Vmax={1:NUMERICAL:=2.83E+00:1.42E-01}m/s et minimum Vmin={1:NUMERICAL:=2.18E+00:1.09E-01}m/s de la vitesse, la vitess la plus probable {1:NUMERICAL:=2.50E+00:1.25E-01}m/s et son incertitude{2:NUMERICAL:=3.25E-01:1.62E-02}m/s.<p>Si la masse du mobile est m=36 +/- 5 kg, on peut en d&eacute;terminer la quantit&eacute; de mouvement p=mv = {1:NUMERICAL:=8.99E+01:4.49E+00} +/- {2:NUMERICAL:=2.42E+01:1.21E+00} kg.ms-1.<p>et son &eacute;nergie cin&eacute;tique: Ec=1/2 mv<sup>2</sup> =  {1:NUMERICAL:=1.12E+02:5.61E+00} +/- {2:NUMERICAL:=4.47E+01:2.24E+00} J.<p></p>]]></text>"},null,"V5.masse_VQE",10,100,0,36,"kg"]
["penalité_VQE",0.1,"        </questiontext>",null,"V6.Deltam_VQE",{"$f":"ROUND(V5.masse_VQE/10,0)","v":4},{"$f":"V5.masse_VQE/7","v":5.1428571428571432},0,5,"kg",null,null,null,"V",{"$f":"M2/M3","v":2.4965034965034967},"m/s"]
["feedback_VQE","_",{"$f":"CONCATENATE(\"        <defaultgrade>\",points_VQE,\"</defaultgrade><generalfeedback><text>\",feedback_VQE,\"</text></generalfeedback><penalty>\",penalty_VQE,\"</penalty><hidden>0</hidden>)\")","v":"        <defaultgrade>1</defaultgrade><generalfeedback><text>_</text></generalfeedback><penalty>0.1</penalty><hidden>0</hidden>)"},null,null,null,null,null,0,null,null,null,null,"Delta V",{"$f":"O2+O3","v":0.13}]
["Cellule vides_VQE",{"$f":"COUNTBLANK(B1:B8)","v":0},{"$f":"CONCATENATE(\"        <idnumber>\",idnumber_VQE,\"</idnumber><tags><tag><text>\",Tag_VQE,\"</text></tag></tags>\")","v":"        <idnumber>210710-212021.19</idnumber><tags><tag><text>Mobile-VQEc_VQE</text></tag></tags>"},null,null,"Cible_VQE","Toler_VQE","PointsQuestion_VQE",null,null,null,null,null,"Delta m",{"$f":"V6.Deltam_VQE/V5.masse_VQE","v":0.1388888888888889}]
["question format HTML_VQE",{"$f":"CONCATENATE(\" \",B19,B20,B21,B22,B23,B24,B25)","v":" Afin d'acc&eacute;der &agrave; la vitesse v d'un mobile, on mesure la distance d = 357m <p>parcourue durant un intervalle de temps t : 143s. Les incertitudes sont<p>suppos&eacute;es ind&eacute;pendantes (de 10% et 3% respectivement).<p>Calculez les valeurs maximum Vmax={1:NUMERICAL:=2.83E+00:1.42E-01}m/s et minimum Vmin={1:NUMERICAL:=2.18E+00:1.09E-01}m/s de la vitesse, la vitess la plus probable {1:NUMERICAL:=2.50E+00:1.25E-01}m/s et son incertitude{2:NUMERICAL:=3.25E-01:1.62E-02}m/s.<p>Si la masse du mobile est m=36 +/- 5 kg, on peut en d&eacute;terminer la quantit&eacute; de mouvement p=mv = {1:NUMERICAL:=8.99E+01:4.49E+00} +/- {2:NUMERICAL:=2.42E+01:1.21E+00} kg.ms-1.<p>et son &eacute;nergie cin&eacute;tique: Ec=1/2 mv<sup>2</sup> =  {1:NUMERICAL:=1.12E+02:5.61E+00} +/- {2:NUMERICAL:=4.47E+01:2.24E+00} J.<p>"},"    </question>",null,"R1.Vmax_VQE",{"$f":"K2/L3","v":2.8310864393338622},{"$f":" tolerance_VQE*ValMini_VQE","v":0.14155432196669313},1,{"$f":"CONCATENATE(\"{\",PointsQuestion_VQE,\":NUMERICAL:=\",TEXT(Cible_VQE,\"0.00E+00\"),\":\",TEXT(ABS(Tolere_VQE),\"0.00E+00\"),\"}\")","v":"{1:NUMERICAL:=2.83E+00:1.42E-01}"}]
["Repere Var Rep","_VQE",null,null,"R2.Vmin_VQE",{"$f":"L2/K3","v":2.1814108221875212},0.10907054110937607,1,"{1:NUMERICAL:=2.18E+00:1.09E-01}",null,null,null,null,"Delta Q",{"$f":"F15/F14","v":0.2688888888888889}]
["HTML File ",{"$f":"CONCATENATE(categorie_VQE,\"_HTML.txt\")","v":"Mobile-VQEc_VQE_HTML.txt"},null,null,"R3.Vmoy_VQE",{"$f":"V1.distance_VQE/V2.temps_VQE","v":2.4965034965034967},0.12482517482517484,1,"{1:NUMERICAL:=2.50E+00:1.25E-01}",null,null,null,null,"Delta Ec",{"$f":"F17/F16","v":0.3988888888888889}]
["Valide ? ",{"$f":"AND(ISNUMBER(P32),P30<50)","v":true},null,null,"R4.DeltaVmoy_VQE",{"$f":"F12*DV","v":0.32454545454545458},1.6227272727272729E-2,2,"{2:NUMERICAL:=3.25E-01:1.62E-02}"]
["https://html-online.com/editor/ ",null,null,null,"R5.QuMouv_VQE",{"$f":"Vmoy*V5.masse_VQE","v":89.87412587412588},4.4937062937062944,1,"{1:NUMERICAL:=8.99E+01:4.49E+00}"]
[null,null,8,null,"R6.DeltaQ_VQE",{"$f":"F14*(DV+DM)","v":24.166153846153851},1.2083076923076925,2,"{2:NUMERICAL:=2.42E+01:1.21E+00}"]
["Var : ","#",6,null,"R7.EnergCin_VQE",{"$f":"0.5*V5.masse_VQE*Vmoy^2","v":112.18553474497533},5.6092767372487664,1,"{1:NUMERICAL:=1.12E+02:5.61E+00}"]
["Res : ","$",8,null,"R8.DeltaEc_VQE",{"$f":"F16*(DM+2*DV)","v":44.749563303829049},2.2374781651914524,2,"{2:NUMERICAL:=4.47E+01:2.24E+00}"]
[]
[null,{"$f":"CONCATENATE(\"Afin d'acc&eacute;der &agrave; la vitesse v d'un mobile, on mesure la distance d = \",V1.distance_VQE,\"m <p>parcourue durant un intervalle de temps t : \",V2.temps_VQE,\"s. Les incertitudes sont<p>suppos&eacute;es ind&eacute;pendantes (de \",V3.Deltad_VQE,\"% et \",V4.Deltat_VQE,\"% respectivement).\")","v":"Afin d'acc&eacute;der &agrave; la vitesse v d'un mobile, on mesure la distance d = 357m <p>parcourue durant un intervalle de temps t : 143s. Les incertitudes sont<p>suppos&eacute;es ind&eacute;pendantes (de 10% et 3% respectivement)."},"Afin d'accéder à la vitesse v d'un mobile, on mesure la distance d = #1# "]
[null,{"$f":"CONCATENATE(\"<p>Calculez les valeurs maximum Vmax=\",R1.Vmax_VQE,\"m/s et minimum Vmin=\",R2.Vmin_VQE,\"m/s de la vitesse, la vitess la plus probable \",R3.Vmoy_VQE,\"m/s et son incertitude\")","v":"<p>Calculez les valeurs maximum Vmax={1:NUMERICAL:=2.83E+00:1.42E-01}m/s et minimum Vmin={1:NUMERICAL:=2.18E+00:1.09E-01}m/s de la vitesse, la vitess la plus probable {1:NUMERICAL:=2.50E+00:1.25E-01}m/s et son incertitude"},"parcourue durant un intervalle de temps t : #2#. Les incertitudes sont"]
[null,{"$f":"CONCATENATE(\"\",R4.DeltaVmoy_VQE,\"m/s.<p>Si la masse du mobile est m=\",V5.masse_VQE,\" +/- \",V6.Deltam_VQE,\" kg, on peut en d&eacute;terminer la quantit&eacute; de mouvement p=mv = \",R5.QuMouv_VQE,\" +/- \",R6.DeltaQ_VQE,\" kg.ms-1.<p>et son &eacute;nergie cin&eacute;tique: Ec=1/2 mv<sup>2</sup> =  \",R7.EnergCin_VQE,\" +/- \",R8.DeltaEc_VQE,\" J.<p>\")","v":"{2:NUMERICAL:=3.25E-01:1.62E-02}m/s.<p>Si la masse du mobile est m=36 +/- 5 kg, on peut en d&eacute;terminer la quantit&eacute; de mouvement p=mv = {1:NUMERICAL:=8.99E+01:4.49E+00} +/- {2:NUMERICAL:=2.42E+01:1.21E+00} kg.ms-1.<p>et son &eacute;nergie cin&eacute;tique: Ec=1/2 mv<sup>2</sup> =  {1:NUMERICAL:=1.12E+02:5.61E+00} +/- {2:NUMERICAL:=4.47E+01:2.24E+00} J.<p>"},"supposées indépendantes (de #3#% et #4#% respectivement). "]
[null,{"$f":"CONCATENATE(\"\")","v":""},null,null,null,"val","delta","%"]
[null,{"$f":"CONCATENATE(\"\")","v":""},"On cherche à connaitre la vitesse de ce mobile : ",null,"d",357,{"$f":"H23*F23/100","v":24.99},7]
[null,{"$f":"CONCATENATE(\"\")","v":""},null,null,"t",135,{"$f":"H24*F24/100","v":5.4},4,null,null,null,null,null,"val","delta","%"]
[null,{"$f":"CONCATENATE(\"\")","v":""},"En calculant pour les valeurs maximum Vmax=$1$ et minimum Vmin=$2$ de la vitesse, on peut déduire la vitess la plus probable $3$ et son incertitude $4$.",null,"m",37,5,{"$f":"G25*100/F25","v":13.513513513513514},null,null,null,null,"d",{"$f":"V1.distance_VQE","v":357},{"$f":"V3.Deltad_VQE","v":10},{"$f":"O25*100/N25","v":2.8011204481792715}]
[null,null,null,null,"v",{"$f":"F23/F24","v":2.6444444444444444},{"$f":"F26*H26/100","v":0.29088888888888886},{"$f":"H24+H23","v":11},null,null,null,null,"t",{"$f":"V2.temps_VQE","v":143},{"$f":"V4.Deltat_VQE","v":3},{"$f":"O26*100/N26","v":2.0979020979020979}]
[null,null,"Si la masse du mobile est m=#5# +/- #6# kg, on peut en déterminer la quantité de mouvement $p=mv$ = $5$ +/- $6$ kg.ms-1.",null,"p",{"$f":"F25*F26","v":97.844444444444449},{"$f":"H27*F27/100","v":17.136000000000003},{"$f":"H25+H24","v":17.513513513513516},null,null,null,null,"m",{"$f":"V5.masse_VQE","v":36},{"$f":"V6.Deltam_VQE","v":5},{"$f":"O27*100/N27","v":13.888888888888889}]
[null,null,null,null,"Ec",{"$f":"0.5*F25*(F23/F24)^2","v":129.3720987654321},{"$f":"H28*F28/100","v":45.944577777777774},{"$f":"H25+2*H26","v":35.513513513513516},null,null,null,null,"v",{"$f":"N25/N26","v":2.4965034965034967},{"$f":"N28*P28/100","v":0.12230426915741602},{"$f":"P26+P25","v":4.899022546081369}]
[null,null,"et son énergie cinétique : $Ec=1/2 mv2$ ^=  $7$ +/- $8$ J.",null,null,null,null,null,null,null,null,null,"p",{"$f":"N27*N28","v":89.87412587412588},{"$f":"P29*N29/100","v":14.367988654701945},{"$f":"P27+P26","v":15.986790986790988}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ec",{"$f":"0.5*N27*(N25/N26)^2","v":112.18553474497533},{"$f":"P30*N30/100","v":26.573313551332038},{"$f":"P27+2*P28","v":23.686933981051627}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M25:P30)","v":862.98042953969036}]

{"sheet":"ExpFonctions","index":9,"n_rows":41,"n_cols":79,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["catégorie_Fon","ExpFonctions",{"$f":"CONCATENATE(\"    <!--  question XLQ \", titre_Fon, \"-->\")","v":"    <!--  question XLQ ExpFonctions_Fon-->"},null,null,"Valeur Mini_Fon","Valeur Maxi_Fon","Sig. Digit_Fon","Val Choix_Fon","Least significant",null,null,"maxi","mini","Delta"]
[null,"ExpFonctions_Fon",{"$f":"CONCATENATE(\"    <question type=\",CHAR(34),\"category\",CHAR(34),\"><category><text>\", categorie_Fon,\"</text></category></question>)\")","v":"    <question type=\"category\"><category><text>ExpFonctions</text></category></question>)"},null,"V1._Fon",0.02,0.97,-2,{"$f":"RANDBETWEEN(ValMini_Fon*10^-SigDig_Fon, ValMaxi_Fon*10^-SigDig_Fon)/10^-SigDig_Fon","v":0.06},{"$f":" 1/POWER(10,LEN(I2)-LEN(INT(I2))-(I2<>INT(I2))*1)","v":0.01},"ln",{"$f":"J2/V1._Fon","v":0.16666666666666669},{"$f":"LN(V1._Fon+J2)","v":-2.6592600369327783},{"$f":"LN(V1._Fon-J2)","v":-2.9957322735539913},{"$f":"ABS(M2-N2)/2","v":0.16823611831060648}]
["Tag_Fon","ExpFonctions_Fon","    <question type=\"cloze\">",null,"V2._Fon",25,75,0,{"$f":"RANDBETWEEN(ValMini_Fon*10^-SigDig_Fon, ValMaxi_Fon*10^-SigDig_Fon)/10^-SigDig_Fon","v":30},{"$f":" 1/POWER(10,LEN(I3)-LEN(INT(I3))-(I3<>INT(I3))*1)","v":1},"cos",{"$f":"J3/V2._Fon","v":3.3333333333333333E-2},{"$f":"COS(RADIANS((V2._Fon+J3)))","v":0.85716730070211233},{"$f":"COS(RADIANS((V2._Fon-J3)))","v":0.87461970713939574},{"$f":"ABS(M3-N3)/2","v":8.7262032186417038E-3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Exprimer les résultats suivants : <p>ln(#1#) = $1$ +/- $2$ <p>cos(#2#) = $3$ +/- $4$ <p>sin(#3#) = $5$ +/- $6$ <p>exp(#4#) = $7$ +/- $8$ <p>"]
["idnumber_Fon",{"$f":"TEXT(NOW(),\"aammjj-hhmmss.00\")","v":"210710-212021.19"},{"$f":"CONCATENATE(\"        <name><text>\", titre_Fon, \"</text></name>\")","v":"        <name><text>ExpFonctions_Fon</text></name>"},null,"V3._Fon",38,73,-1,{"$f":"RANDBETWEEN(ValMini_Fon*10^-SigDig_Fon, ValMaxi_Fon*10^-SigDig_Fon)/10^-SigDig_Fon","v":53.7},{"$f":" 1/POWER(10,LEN(I4)-LEN(INT(I4))-(I4<>INT(I4))*1)","v":0.1},"sin",{"$f":"J4/V3._Fon","v":1.8621973929236499E-3},{"$f":"SIN(RADIANS((V3._Fon+J4)))","v":0.80696031214380193},{"$f":"SIN(RADIANS((V3._Fon-J4)))","v":0.80489379735591404},{"$f":"ABS(M4-N4)/2","v":1.0332573939439427E-3}]
["points_Fon",1,"        <questiontext format=\"html\">",null,"V4._Fon",-1,2,-2,{"$f":"IF(I6=0,RANDBETWEEN(0.1,0.77),I6)","v":1.36},{"$f":" 1/POWER(10,LEN(I5)-LEN(INT(I5))-(I5<>INT(I5))*1)","v":0.01},"exp",{"$f":"J5/V4._Fon","v":7.3529411764705881E-3},{"$f":"EXP(V4._Fon+J5)","v":3.9353506954704733},{"$f":"EXP(V4._Fon-J5)","v":3.8574255306969745},{"$f":"ABS(M5-N5)/2","v":3.8962582386749434E-2}]
["tolérance_Fon",0.05,{"$f":"CONCATENATE(\"            <text><![CDATA[<p>\", question_Fon, \"</p>]]></text>\")","v":"            <text><![CDATA[<p> Exprimer correctement les resultats suivants : <p>ln(0.06) = {1:NUMERICAL:=-2.81E+00:1.41E-01} +/- {1:NUMERICAL:=1.67E-01:8.33E-03} <p>cos(30) = {1:NUMERICAL:=8.66E-01:4.33E-02} +/- {2:NUMERICAL:=8.73E-03:4.36E-04} <p>sin(53.7) = {1:NUMERICAL:=8.06E-01:4.03E-02} +/- {2:NUMERICAL:=1.03E-03:5.17E-05} <p>exp(1.36) = {1:NUMERICAL:=3.90E+00:1.95E-01} +/- {2:NUMERICAL:=3.90E-02:1.95E-03} <p></p>]]></text>"},null,null,{"$f":"F5","v":-1},{"$f":"G5","v":2},{"$f":"H5","v":-2},{"$f":"RANDBETWEEN(ValMini_Fon*10^-SigDig_Fon, ValMaxi_Fon*10^-SigDig_Fon)/10^-SigDig_Fon+0.1","v":1.36}]
["penalité_Fon",0.1,"        </questiontext>",null,null,"Cible_Fon","Toler_Fon","PointsQuestion_Fon"]
["feedback_Fon","_",{"$f":"CONCATENATE(\"        <defaultgrade>\",points_Fon,\"</defaultgrade><generalfeedback><text>\",feedback_Fon,\"</text></generalfeedback><penalty>\",penalty_Fon,\"</penalty><hidden>0</hidden>)\")","v":"        <defaultgrade>1</defaultgrade><generalfeedback><text>_</text></generalfeedback><penalty>0.1</penalty><hidden>0</hidden>)"},null,"R1._Fon",{"$f":"LN(V1._Fon)","v":-2.8134107167600364},{"$f":" tolerance_Fon*ValMini_Fon","v":-0.14067053583800182},1,{"$f":"CONCATENATE(\"{\",PointsQuestion_Fon,\":NUMERICAL:=\",TEXT(Cible_Fon,\"0.00E+00\"),\":\",TEXT(ABS(Tolere_Fon),\"0.00E+00\"),\"}\")","v":"{1:NUMERICAL:=-2.81E+00:1.41E-01}"},null,"ln"]
["Cellule vides_Fon",{"$f":"COUNTBLANK(B1:B8)","v":0},{"$f":"CONCATENATE(\"        <idnumber>\",idnumber_Fon,\"</idnumber><tags><tag><text>\",Tag_Fon,\"</text></tag></tags>\")","v":"        <idnumber>210710-212021.19</idnumber><tags><tag><text>ExpFonctions_Fon</text></tag></tags>"},null,"R2._Fon",{"$f":"ABS(J2/V1._Fon)","v":0.16666666666666669},8.333333333333335E-3,1,"{1:NUMERICAL:=1.67E-01:8.33E-03}",null,"D ln",{"$f":"F9","v":0.16666666666666669},null,null,{"$f":"ABS((O2-L9)/L9)","v":9.4167098636387375E-3}]
["question format HTML_Fon",{"$f":"CONCATENATE(\" \",B19,B20)","v":" Exprimer correctement les resultats suivants : <p>ln(0.06) = {1:NUMERICAL:=-2.81E+00:1.41E-01} +/- {1:NUMERICAL:=1.67E-01:8.33E-03} <p>cos(30) = {1:NUMERICAL:=8.66E-01:4.33E-02} +/- {2:NUMERICAL:=8.73E-03:4.36E-04} <p>sin(53.7) = {1:NUMERICAL:=8.06E-01:4.03E-02} +/- {2:NUMERICAL:=1.03E-03:5.17E-05} <p>exp(1.36) = {1:NUMERICAL:=3.90E+00:1.95E-01} +/- {2:NUMERICAL:=3.90E-02:1.95E-03} <p>"},"    </question>",null,"R3._Fon",{"$f":"COS(RADIANS(V2._Fon))","v":0.86602540378443871},4.330127018922194E-2,1,"{1:NUMERICAL:=8.66E-01:4.33E-02}",null,"cos"]
["Repere Var Rep","_Fon",null,null,"R4._Fon",{"$f":"ABS(SIN(RADIANS(V2._Fon)))*RADIANS(J3)","v":8.726646259971646E-3},4.3633231299858234E-4,2,"{2:NUMERICAL:=8.73E-03:4.36E-04}",null,"D cos",{"$f":"F11","v":8.726646259971646E-3},null,null,{"$f":"ABS((ABS(O3)-ABS(L11))/ABS(L11))","v":5.0768796711104119E-5}]
["HTML File ",{"$f":"CONCATENATE(categorie_Fon,\"_HTML.txt\")","v":"ExpFonctions_HTML.txt"},null,null,"R5._Fon",{"$f":"SIN(RADIANS(V3._Fon))","v":0.80592828224851587},4.0296414112425794E-2,1,"{1:NUMERICAL:=8.06E-01:4.03E-02}",null,"sin"]
["Valide ? ",{"$f":"AND(ISNUMBER(L16),SUM(O9:O15<0.1))","v":true},null,null,"R6._Fon",{"$f":"ABS(COS(RADIANS(V3._Fon)))*RADIANS(J4)","v":1.033257918524427E-3},5.1662895926221349E-5,2,"{2:NUMERICAL:=1.03E-03:5.17E-05}",null,"D sin",{"$f":"F13","v":1.033257918524427E-3},null,null,{"$f":"ABS((O4-L13)/L13)","v":5.0769558587282753E-7}]
["https://html-online.com/editor/",null,null,null,"R7._Fon",{"$f":"EXP(V4._Fon)","v":3.8961933017952148},0.19480966508976075,1,"{1:NUMERICAL:=3.90E+00:1.95E-01}",null,"exp"]
[null,null,6,null,"R8._Fon",{"$f":"ABS(EXP(V4._Fon))*J5","v":3.8961933017952151E-2},1.9480966508976076E-3,2,"{2:NUMERICAL:=3.90E-02:1.95E-03}",null,"D exp",{"$f":"F15","v":3.8961933017952151E-2},null,null,{"$f":"ABS((O5-L15)/L15)","v":1.6666750003999413E-5}]
["Var : ","#",4,null,null,null,null,null,null,null,null,{"$f":"SUM(L2:L15)","v":0.4246036424325092},"Vérifie que ça fonctionne"]
["Res : ","$",8,null,null,"https://www.excel-pratique.com/fr/index_des_fonctions/traduction_formule "]
[]
[null,{"$f":"CONCATENATE(\"Exprimer correctement les resultats suivants : <p>ln(\",V1._Fon,\") = \",R1._Fon,\" +/- \",R2._Fon,\" <p>cos(\",V2._Fon,\") = \",R3._Fon,\" +/- \",R4._Fon,\" <p>sin(\",V3._Fon,\") = \",R5._Fon,\" +/- \",R6._Fon,\" <p>exp(\",V4._Fon,\") = \",R7._Fon,\" +/- \",R8._Fon,\" <p>\")","v":"Exprimer correctement les resultats suivants : <p>ln(0.06) = {1:NUMERICAL:=-2.81E+00:1.41E-01} +/- {1:NUMERICAL:=1.67E-01:8.33E-03} <p>cos(30) = {1:NUMERICAL:=8.66E-01:4.33E-02} +/- {2:NUMERICAL:=8.73E-03:4.36E-04} <p>sin(53.7) = {1:NUMERICAL:=8.06E-01:4.03E-02} +/- {2:NUMERICAL:=1.03E-03:5.17E-05} <p>exp(1.36) = {1:NUMERICAL:=3.90E+00:1.95E-01} +/- {2:NUMERICAL:=3.90E-02:1.95E-03} <p>"},"Exprimer les résultats suivants : "]
[null,{"$f":"CONCATENATE(\"\")","v":""}]
[null,null,"ln(#1#) = $1$ +/- $2$ "]
[]
[null,null,"cos(#2#) = $3$ +/- $4$ "]
[null,null,null,null,null,null,null,null,null,2.1215000000000002,{"$f":" 1/POWER(10,LEN(J24)-LEN(INT(J24))-(J24<>INT(J24))*1)","v":1E-4}]
[null,null,"sin(#3#) = $5$ +/- $6$ "]
[]
[null,null,"exp(#4#) = $7$ +/- $8$ "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Exprimer les résultats suivants : <p>ln(\",V1._Fon,\") = \",R1._Fon,\" +/- \",R2._Fon,\" <p>cos(\",V2._Fon,\") = \",R3._Fon,\" +/- \",R4._Fon,\" <p>sin(\",V3._Fon,\") = \",R5._Fon,\" +/- \",R6._Fon,\" <p>exp(\",V4._Fon,\") = \",R7._Fon,\" +/- \",R8._Fon,\" <p>"]