{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["xsymbol","xcolor","xwork","xWeiPara","xTauSonde","xCaptLin","Capt_Pt-Rh","Stat","Expr","Capa","AbsRel","FourCyl","Mobile-VQEc","ExpFonctions","Somme-Fraction","Ohms","Sphere-Creuse","Traction"],"not_rendered":{"charts":3,"images":16,"macros":1,"external_links":0,"defined_names":436,"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":"xwork","index":2,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,"FOUR 3","KIC",1,0.7,"MPa rac (m)"]
[null,null,null,null,null,null,"Profond",10,20,"µm"]
[null,null,null,null,null,null,null,{"$f":"H2/(SQRT(PI()*H3*0.000001))","v":178.41241161527711},{"$f":"I2/(SQRT(PI()*I3*0.000001))","v":88.309638270705591},"MPa"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OK"]
[null,null,null,null,null,"Pour l'exercice du four, question3: je fais sigma= K1c / racine( pi * a) = 178 MPa (comme en TD) et vous, vous trouvez 214 MPa"]
[]
[null,null,null,null,null,"Béton","Contrainte",66,12,"MPa "]
[null,null,null,null,null,null,"Profond",1.3,2,"mm"]
[null,null,null,null,null,null,null,{"$f":"H8*SQRT(PI()*H9/2/1000)","v":2.9824663349942679},{"$f":"I8*SQRT(PI()*I9/2/1000)","v":0.67259894596775149},"MPa rac (m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OK"]
[null,null,null,null,null,"Moi je trouve 2.98 pour une fissure de 1,3mm et une contrainte de 66MPa, mais je ne voie pas ou peut être mon erreur"]
[null,null,null,null,null,"=Res_Meca*RACINE(PI()*Long_Fiss/2/1000) = 2.98 MPa m1/2"]
[]
[null,null,null,null,null,"Traction","F",39,34,"N"]
[null,null,null,null,null,null,"d",3.5,7,"mm"]
[null,null,null,null,null,null,null,{"$f":"H15*1000/(PI()*H16^2/4)","v":4053.5789587486815},{"$f":"I15*1000/(PI()*I16^2/4)","v":883.47233716317419},null,null,null,null,null,null,"OK"]
[null,null,null,null,null,"Aussi, pour l'exercice de traction, pour la question a, je fais sigma= F/ S où F=39000N et S= (pi*3.5^2)/4 => sigma= 4054 MPa"]
[null,null,null,null,null,"Mais vous trouvez 497MPa"]
[]
[]
[]
[]
[null,null,null,null,null,"Enfin, pour le critère énergétique de Griffith, a correspond à la demi longueur mais je ne comprends pas ce que c'est. Par exemple, pour l'exercice 8, c'est 38µm /2?"]
[]
[]
[]
[null,null,null,null,null,"Contrainte","Ordre","ln sig exp","LN(-LN(1- Ordre /10))"]
[null,null,null,null,273,161,1,{"$f":"LN(E29)","v":5.6094717951849598},{"$f":"LN(-LN(1-G29/10))","v":-2.2503673273124454}]
[null,null,null,null,273,196,2,{"$f":"LN(E30)","v":5.6094717951849598},{"$f":"LN(-LN(1-G30/10))","v":-1.4999399867595158},null,{"$f":"LINEST(I29:I37,E29:E37,1,1)","v":2.602994841324183E-2},-8.9412071439722691]
[null,null,null,null,302,206,3,5.7104270173748697,-1.0309304331587228,null,2.1433388609543684E-3,0.69987152438433675]
[null,null,null,null,311,235,4,5.7397929121792339,-0.67172699209212194]
[null,null,null,null,334,262,5,5.8111409929767008,-0.36651292058166435,null,{"$f":"EXP(-L30/K30)","v":1.5094457599875115E+149}]
[null,null,null,null,344,276,6,5.8406416573733981,-8.7421571790755173E-2]
[null,null,null,null,351,296,7,5.8607862234658654,0.18562675886236557]
[null,null,null,null,358,321,8,5.8805329864007003,0.4758849953271107]
[null,null,null,null,376,347,9,5.9295891433898946,0.83403244524795594]

{"sheet":"xWeiPara","index":3,"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.3133543779371175},{"$f":"Contr_Rig*(1+Randm_Wei*RAND()/100)","v":5.328333747529971},-2,{"$f":"ROUND(EXP(RANDBETWEEN(ValMini_Wei*10^-SigDig_Wei, ValMaxi_Wei*10^-SigDig_Wei)/10^-SigDig_Wei),0)","v":204},null,"log Sig","MPa",null,1,{"$f":"(Proba_Wei-Ordonnee)/Module","v":5.32790087141702},{"$f":"LN(-LN(1-N2/10))","v":-2.2503673273124454},null,null,"pente","ordo"]
["Tag_Wei","WeiPara_Wei","    <question type=\"cloze\">",null,"V2._Wei",5.4824868727328226,5.4921115393921927,-2,242,null,"log Sig","MPa",null,2,{"$f":"(Proba_Wei-Ordonnee)/Module","v":5.4910372497980919},-1.4999399867595158,null,null,{"$f":"LINEST(P2:P10,O2:O10,1,1)","v":4.5999999999999988},-26.758711335830736,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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-210812.04"},{"$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.5630401205651427},{"$f":"Contr_Rig*(1+Randm_Wei*RAND()/100)","v":5.5941524534456741},-2,{"$f":"ROUND(EXP(RANDBETWEEN(ValMini_Wei*10^-SigDig_Wei, ValMaxi_Wei*10^-SigDig_Wei)/10^-SigDig_Wei),0)","v":268},null,"log Sig","MPa",null,3,{"$f":"(Proba_Wei-Ordonnee)/Module","v":5.59299584840696},-1.0309304331587228,null,null,2.6878861000665533E-15,1.5358917974916403E-14]
["points_Wei",1,"        <questiontext format=\"html\">",null,"V4._Wei",5.6216318311152955,5.6721479836483555,-2,281,null,"log Sig","MPa",null,4,5.6710835529866559,-0.67172699209212194,null,null,1,1.6281853524335584E-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 : 372, 347, 281, 268, 281, 327, 242, 351, 204 MPa. En deduire les param&egrave;tres de Weibull associ&eacute;s :</p><p><p>&nbsp;</p><p><p>Le module m={1:NUMERICAL:=4.60E+00:1.15E+00}</p><p><p>&nbsp;</p><p><p>&nbsp;</p><p><p>Lefacteur d'&eacute;chelle Ko={1:NUMERICAL:=3.23E+02:8.06E+01} MPa</p><p><p>&nbsp;</p><p></p>]]></text>"},null,"V5._Wei",5.63447890677622,5.7386118241777062,-2,281,null,"log Sig","MPa",null,5,5.7374344380976252,-0.36651292058166435,null,null,2.9288284903752072E+30,7]
["penalité_Wei",0.1,"        </questiontext>",null,"V6._Wei",5.7628881984296862,5.7988673190036577,-2,327,null,"log Sig","MPa",null,6,5.7981064704434742,-8.7421571790755173E-2,null,null,7.7642878402855118,1.8556912793154334E-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.7654805293819678,5.8584675393525165,-2,347,null,"log Sig","MPa",null,7,5.8574648031941532,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-210812.04</idnumber><tags><tag><text>WeiPara_Wei</text></tag></tags>"},null,"V8._Wei",5.8504918420840886,5.9209659089881468,-2,351,null,"log Sig","MPa",null,8,5.9205644198169232,0.4758849953271107,null,null,null,{"$f":"EXP(-T3/S3)","v":336.00000000000028}]
["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 : 372, 347, 281, 268, 281, 327, 242, 351, 204 MPa. En deduire les param&egrave;tres de Weibull associ&eacute;s :</p><p><p>&nbsp;</p><p><p>Le module m={1:NUMERICAL:=4.60E+00:1.15E+00}</p><p><p>&nbsp;</p><p><p>&nbsp;</p><p><p>Lefacteur d'&eacute;chelle Ko={1:NUMERICAL:=3.23E+02:8.06E+01} MPa</p><p><p>&nbsp;</p><p>"},"    </question>",null,"V9._Wei",5.8855996478077817,5.9986738997401066,-2,372,null,"log Sig","MPa",null,9,5.9984225611040642,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":336},"moyenne","log Sig","MPa"]
["HTML File ",{"$f":"CONCATENATE(categorie_Wei,\"_HTML.txt\")","v":"WeiPara_HTML.txt"}]
["Valide ? ",null,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.1000000000000001E-2}]
["https://html-online.com/editor/",null,null,null,"2-- Ordo",null,null,null,{"$f":"-Module*LN(V10._Wei)","v":-26.758711335830736},"ordonnée",null,"verif s",{"$f":"EXP(-I14/I15)","v":336},null,null,null,null,{"$f":"100*ABS(R17/R16)+ABS(S17/S16)","v":6.1119310621237606}]
[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":4.5999999999999996},"pente",null,"Extracted s",{"$f":"EXP(-Ordonnee/Module)","v":336},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.3181199938442161},{"$f":"P2","v":-2.2503673273124454},null,{"$f":"LINEST(P16:P24,O16:O24,1,1)","v":4.9472934340332939},-28.576330655171141]
["Res : ","$",2,null,"R1.Module_Wei",{"$f":"I15","v":4.5999999999999996},{"$f":" tolerance_Wei*ValMini_Wei","v":1.1499999999999999},1,{"$f":"CONCATENATE(\"{\",PointsQuestion_Wei,\":NUMERICAL:=\",TEXT(Cible_Wei,\"0.00E+00\"),\":\",TEXT(ABS(Tolere_Wei),\"0.00E+00\"),\"}\")","v":"{1:NUMERICAL:=4.60E+00:1.15E+00}"},null,null,null,null,null,5.4889377261566867,-1.4999399867595158,null,0.29943064835978822,1.7007977667971199]
[null,null,null,null,"R2.Exp_Wei",{"$f":"Facteur_Echelle","v":322.51652764786996},{"$f":" tolerance_Wei*ValMini_Wei","v":80.629131911967491},1,{"$f":"CONCATENATE(\"{\",PointsQuestion_Wei,\":NUMERICAL:=\",TEXT(Cible_Wei,\"0.00E+00\"),\":\",TEXT(ABS(Tolere_Wei),\"0.00E+00\"),\"}\")","v":"{1:NUMERICAL:=3.23E+02:8.06E+01}"},null,null,null,null,null,5.5909869805108565,-1.0309304331587228,null,0.97499888821997527,0.16652577157359355]
[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 : 372, 347, 281, 268,"},"<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.6383546693337454,-0.67172699209212194,null,272.98754861745141,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":" 281, 327, 242, 351, 204 MPa. En deduire les param&egrave;tres de Weibull associ&eacute;s :</p><p><p>&nbsp;</p><p><p>Le module m={1:NUMERICAL:=4.60E+00:1.15E+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.6383546693337454,-0.36651292058166435,null,7.5701720120982472,0.19411582818726458]
[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:=3.23E+02:8.06E+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.7899601708972535,-8.7421571790755173E-2]
[null,{"$f":"CONCATENATE(\"\")","v":""},"<p>&nbsp;</p>",null,null,null,null,null,null,null,null,null,null,null,5.8493247799468593,0.18562675886236557]
[null,{"$f":"CONCATENATE(\"\")","v":""},"<p>&nbsp;</p>",null,null,null,null,null,null,null,null,null,null,null,5.8607862234658654,0.4758849953271107,null,"Facteur Echelle",{"$f":"EXP(-S16/R16)","v":322.51652764786996}]
[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.9188938542731462,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 : 372, 347, 281, 268, 281, 327, 242, 351, 204 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=4.6}\\\\"}]
[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{323} MPa"}]

{"sheet":"xTauSonde","index":4,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["catégorie_Tau","Tau_Sonde",{"$f":"CONCATENATE(\" <!--  question XLQ \", titre_Tau, \"-->\")","v":" <!--  question XLQ Chercher_le_temps_caracteristique-->"},null,null,"Valeur Mini_Tau","Valeur Maxi_Tau","Sig. Digit_Tau","Val Choix_Tau"]
["titre_Tau","Chercher_le_temps_caracteristique",{"$f":"CONCATENATE(\" <question type=\",CHAR(34),\"category\",CHAR(34),\"><category><text>\", categorie_Tau,\"</text></category></question>)\")","v":" <question type=\"category\"><category><text>Tau_Sonde</text></category></question>)"},null,"V1.temps_Tau",1,100,0,{"$f":"RANDBETWEEN(ValMini_Tau*10^-SigDig_Tau, ValMaxi_Tau*10^-SigDig_Tau)/10^-SigDig_Tau","v":29}]
["Tag_Tau","Temps_Carac","    <question type=\"cloze\">",null,"V2.precision_Tau",1,10000,3,{"$f":"RANDBETWEEN(ValMini_Tau*10^-SigDig_Tau, ValMaxi_Tau*10^-SigDig_Tau)/10^-SigDig_Tau","v":5000}]
["idnumber_Tau",{"$f":"TEXT(NOW(),\"aammjj-hhmmss.00\")","v":"210710-210812.04"},{"$f":"CONCATENATE(\"     <name><text>\", titre_Tau, \"</text></name>\")","v":"     <name><text>Chercher_le_temps_caracteristique</text></name>"}]
["points_Tau",1,"    <questiontext format=\"html\">",null,null,"Cible_Tau","Tolér_Tau","Sig. Digit_Tau"]
["tolérance_Tau",0.05,{"$f":"CONCATENATE(\"     <text><![CDATA[<p>\", question_Tau, \"</p>]]></text>\")","v":"     <text><![CDATA[<p> <p>Une sonde a une constante de temps de 29 s. Au bout de combien de temps cette sonde donne-t-elle une r&eacute;ponse exacte &agrave; 1/5000 pr&egrave;s en valeur relative&nbsp;? &tau; = {1:NUMERICAL:=2.47E+02:1.23E+01}&nbsp;</p><p></p>]]></text>"},null,"R1.TempsCarac_Tau",{"$f":"V1.temps_Tau*LN(V2.precision_Tau)","v":246.99860255107092},{"$f":" tolerance_Tau*ValMini_Tau","v":12.349930127553547},null,{"$f":"CONCATENATE(\"{1:NUMERICAL:=\",TEXT(Cible_Tau,\"0.00E+00\"),\":\",TEXT(Tolere_Tau,\"0.00E+00\"),\"}\")","v":"{1:NUMERICAL:=2.47E+02:1.23E+01}"}]
["penalité_Tau",0.1,"    </questiontext>"]
["feedback_Tau","Temps_caracteristique",{"$f":"CONCATENATE(\"    <defaultgrade>\",points_Tau,\"</defaultgrade><generalfeedback><text>\",feedback_Tau,\"</text></generalfeedback><penalty>\",penalty_Tau,\"</penalty><hidden>0</hidden>)\")","v":"    <defaultgrade>1</defaultgrade><generalfeedback><text>Temps_caracteristique</text></generalfeedback><penalty>0.1</penalty><hidden>0</hidden>)"}]
["Cellule vides_Tau",{"$f":"COUNTBLANK(B1:B8)","v":0},{"$f":"CONCATENATE(\"    <idnumber>\",idnumber_Tau,\"</idnumber><tags><tag><text>\",Tag_Tau,\"</text></tag></tags>\")","v":"    <idnumber>210710-210812.04</idnumber><tags><tag><text>Temps_Carac</text></tag></tags>"}]
["question format HTML_Tau",{"$f":"CONCATENATE(\" \",C19,C20,C21,C22,C23)","v":" <p>Une sonde a une constante de temps de 29 s. Au bout de combien de temps cette sonde donne-t-elle une r&eacute;ponse exacte &agrave; 1/5000 pr&egrave;s en valeur relative&nbsp;? &tau; = {1:NUMERICAL:=2.47E+02:1.23E+01}&nbsp;</p><p>"},"   </question>"]
["Repere Var Rep","_Trac"]
["HTML File ","TempsCarac.HTML.txt"]
["https://html-online.com/editor/ "]
[]
[null,null,4]
["Var : ","#",2]
["Res : ","$",1]
[]
[null,null,{"$f":"CONCATENATE(\"<p>Une sonde a une constante de temps de \",V1.temps_Tau,\" s. Au \")","v":"<p>Une sonde a une constante de temps de 29 s. Au "}]
[null,null,{"$f":"CONCATENATE(\"bout de combien de temps cette sonde donne-t-elle \")","v":"bout de combien de temps cette sonde donne-t-elle "}]
[null,null,{"$f":"CONCATENATE(\"une r&eacute;ponse exacte &agrave; 1/\",V2.precision_Tau,\" pr&egrave;\")","v":"une r&eacute;ponse exacte &agrave; 1/5000 pr&egrave;"}]
[null,null,{"$f":"CONCATENATE(\"s en valeur relative&nbsp;? &tau; = \",R1.TempsCarac_Tau,\"&nbsp;</p><p\")","v":"s en valeur relative&nbsp;? &tau; = {1:NUMERICAL:=2.47E+02:1.23E+01}&nbsp;</p><p"}]
[null,null,{"$f":"CONCATENATE(\">\")","v":">"}]
[]
[]
[]
[]
[]
[null,{"$f":"question_Tau","v":" <p>Une sonde a une constante de temps de 29 s. Au bout de combien de temps cette sonde donne-t-elle une r&eacute;ponse exacte &agrave; 1/5000 pr&egrave;s en valeur relative&nbsp;? &tau; = {1:NUMERICAL:=2.47E+02:1.23E+01}&nbsp;</p><p>"}]

{"sheet":"xCaptLin","index":5,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["catégorie_Cparties","Capteur_Lin",{"$f":"CONCATENATE(\"<!--  question XLQ \", titre_Cparties, \"-->\")","v":"<!--  question XLQ Lin_par_parties-->"},null,null,"Valeur Mini_Cparties","Valeur Maxi_Cparties","Sig. Digit_Cparties","Val Choix_Cparties","DT",0.5]
["titre_Cparties","Lin_par_parties",{"$f":"CONCATENATE(\" <question type=\",CHAR(34),\"category\",CHAR(34),\"><category><text>\", categorie_Cparties,\"</text></category></question>)\")","v":" <question type=\"category\"><category><text>Capteur_Lin</text></category></question>)"},null,"V1._Cparties",{"$f":"RANDBETWEEN(1,1000)/1000","v":0.48799999999999999},{"$f":"F2+RANDBETWEEN(1,100)/100","v":1.468},-2,{"$f":"RANDBETWEEN(ValMini_Cparties*10^-SigDig_Cparties, ValMaxi_Cparties*10^-SigDig_Cparties)/10^-SigDig_Cparties","v":0.93}]
["Tag_Cparties","Lineaire","    <question type=\"cloze\">",null,"V2._Cparties",{"$f":"V1._Cparties+DT_Cparties","v":1.4300000000000002},{"$f":"F3+RANDBETWEEN(1,100)/100","v":2},-2,{"$f":"RANDBETWEEN(ValMini_Cparties*10^-SigDig_Cparties, ValMaxi_Cparties*10^-SigDig_Cparties)/10^-SigDig_Cparties","v":1.6}]
["idnumber_Cparties",{"$f":"TEXT(NOW(),\"aammjj-hhmmss.00\")","v":"210710-210812.04"},{"$f":"CONCATENATE(\"     <name><text>\", titre_Cparties, \"</text></name>\")","v":"     <name><text>Lin_par_parties</text></name>"},null,"V3._Cparties",{"$f":"V2._Cparties+DT_Cparties","v":2.1},{"$f":"F4+RANDBETWEEN(1,100)/100","v":3.02},-2,{"$f":"RANDBETWEEN(ValMini_Cparties*10^-SigDig_Cparties, ValMaxi_Cparties*10^-SigDig_Cparties)/10^-SigDig_Cparties","v":2.2200000000000002}]
["points_Cparties",1,"    <questiontext format=\"html\">",null,"V4.Ini_Cparties",200,2500,2,{"$f":"RANDBETWEEN(ValMini_Cparties*10^-SigDig_Cparties, ValMaxi_Cparties*10^-SigDig_Cparties)/10^-SigDig_Cparties","v":1400}]
["tolérance_Cparties",0.05,{"$f":"CONCATENATE(\"     <text><![CDATA[<p>\", question_Cparties, \"</p>]]></text>\")","v":"     <text><![CDATA[<p> <p>On dispose d'un capteur non lin&eacute;aire de temp&eacute;ratures dans la gamme 0-300&deg;C, de sensibilit&eacute; moyenne 0.93mV/&deg;C de 0 &agrave; 80 &deg;C, 1.6 mV/&deg;C de 80 &agrave; 180&deg;C, 2.22 mV/&deg;C de 180 &agrave; 300&deg;C. Ce capteur fournit une tension de 1400 mV &agrave; 0&deg;C.</p><p><p>Quelle est son indication &agrave; 300 &deg;C&nbsp;? {1:NUMERICAL:=1.90E+03:9.50E+01}</p><p><p>On d&eacute;sire convertir le signal de sortie avec un CAN &agrave; approximations successives. Quelle tension de r&eacute;f&eacute;rence conseillez-vous pour pouvoir r&eacute;aliser des mesures entre 0 et 300 &deg;C&nbsp;? {1:NUMERICAL:=2.00E+00:1.00E-01}</p><p><p>&nbsp;</p><p></p>]]></text>"}]
["penalité_Cparties",0,"    </questiontext>",null,null,"Cible_Cparties","Tolér_Cparties","Sig. Digit_Cparties"]
["feedback_Cparties","sensibilite",{"$f":"CONCATENATE(\"    <defaultgrade>\",points_Cparties,\"</defaultgrade><generalfeedback><text>\",feedback_Cparties,\"</text></generalfeedback><penalty>\",penalty_Cparties,\"</penalty><hidden>0</hidden>)\")","v":"    <defaultgrade>1</defaultgrade><generalfeedback><text>sensibilite</text></generalfeedback><penalty>0</penalty><hidden>0</hidden>)"},null,"R1._Cparties",{"$f":"V3.Ini_Cparties+V1._Cparties*80+V2._Cparties*100+V3._Cparties*120","v":1900.8000000000002},{"$f":" tolerance_Cparties*ValMini_Cparties","v":95.04000000000002},null,{"$f":"CONCATENATE(\"{1:NUMERICAL:=\",TEXT(Cible_Cparties,\"0.00E+00\"),\":\",TEXT(Tolere_Cparties,\"0.00E+00\"),\"}\")","v":"{1:NUMERICAL:=1.90E+03:9.50E+01}"}]
["Cellule vides_Trac",{"$f":"COUNTBLANK(B1:B8)","v":0},{"$f":"CONCATENATE(\"    <idnumber>\",idnumber_Cparties,\"</idnumber><tags><tag><text>\",Tag_Cparties,\"</text></tag></tags>\")","v":"    <idnumber>210710-210812.04</idnumber><tags><tag><text>Lineaire</text></tag></tags>"},null,"R2._Cparties",{"$f":"ROUNDUP(F8/1000,0)","v":2},{"$f":" tolerance_Cparties*ValMini_Cparties","v":0.1},null,{"$f":"CONCATENATE(\"{1:NUMERICAL:=\",TEXT(Cible_Cparties,\"0.00E+00\"),\":\",TEXT(Tolere_Cparties,\"0.00E+00\"),\"}\")","v":"{1:NUMERICAL:=2.00E+00:1.00E-01}"}]
["question format HTML_Cparties",{"$f":"CONCATENATE(\" \",B19,B20,B21,B22,B23,B24,B25,B26,B27,B28,B29,B30,B31)","v":" <p>On dispose d'un capteur non lin&eacute;aire de temp&eacute;ratures dans la gamme 0-300&deg;C, de sensibilit&eacute; moyenne 0.93mV/&deg;C de 0 &agrave; 80 &deg;C, 1.6 mV/&deg;C de 80 &agrave; 180&deg;C, 2.22 mV/&deg;C de 180 &agrave; 300&deg;C. Ce capteur fournit une tension de 1400 mV &agrave; 0&deg;C.</p><p><p>Quelle est son indication &agrave; 300 &deg;C&nbsp;? {1:NUMERICAL:=1.90E+03:9.50E+01}</p><p><p>On d&eacute;sire convertir le signal de sortie avec un CAN &agrave; approximations successives. Quelle tension de r&eacute;f&eacute;rence conseillez-vous pour pouvoir r&eacute;aliser des mesures entre 0 et 300 &deg;C&nbsp;? {1:NUMERICAL:=2.00E+00:1.00E-01}</p><p><p>&nbsp;</p><p>"},"   </question>"]
["Cases vides",{"$f":"COUNTBLANK(B1:B10)","v":0}]
["Repere Var Rep","_Cparties"]
["HTML File ","Capteur.HTML.txt"]
["https://html-online.com/editor/ "]
[null,null,5]
["Var : ","#",3]
["Res : ","$",1]
[]
[null,{"$f":"CONCATENATE(\"<p>On dispose d'un capteur non lin&eacute;aire de \")","v":"<p>On dispose d'un capteur non lin&eacute;aire de "},"<p>On dispose d'un capteur non lin&eacute;aire de temp&eacute;ratures dans la gamme 0-300&deg;C, de sensibilit&eacute; moyenne #1#mV/&deg;C de 0 &agrave; 80 &deg;C, #2# mV/&deg;C de 80 &agrave; 180&deg;C, #3# mV/&deg;C de 180 &agrave; 300&deg;C. Ce capteur fournit une tension de #4# mV &agrave; 0&deg;C.</p>"]
[null,{"$f":"CONCATENATE(\"temp&eacute;ratures dans la gamme 0-300&deg;C, de \")","v":"temp&eacute;ratures dans la gamme 0-300&deg;C, de "},"<p>Quelle est son indication &agrave; 300 &deg;C&nbsp;? $1$</p>"]
[null,{"$f":"CONCATENATE(\"sensibilit&eacute; moyenne \",V1._Cparties,\"mV/&deg;C de 0 &agra\")","v":"sensibilit&eacute; moyenne 0.93mV/&deg;C de 0 &agra"},"<p>On d&eacute;sire convertir le signal de sortie avec un CAN &agrave; approximations successives. Quelle tension de r&eacute;f&eacute;rence conseillez-vous pour pouvoir r&eacute;aliser des mesures entre 0 et 300 &deg;C&nbsp;? $2$</p>"]
[null,{"$f":"CONCATENATE(\"ve; 80 &deg;C, \",V2._Cparties,\" mV/&deg;C de 80 &agrave; 180&de\")","v":"ve; 80 &deg;C, 1.6 mV/&deg;C de 80 &agrave; 180&de"},"<p>&nbsp;</p>"]
[null,{"$f":"CONCATENATE(\"g;C, \",V3._Cparties,\" mV/&deg;C de 180 &agrave; 300&deg;C. Ce c\")","v":"g;C, 2.22 mV/&deg;C de 180 &agrave; 300&deg;C. Ce c"}]
[null,{"$f":"CONCATENATE(\"apteur fournit une tension de \",V4.Ini_Cparties,\" mV &agrave; 0&de\")","v":"apteur fournit une tension de 1400 mV &agrave; 0&de"}]
[null,{"$f":"CONCATENATE(\"g;C.</p><p><p>Quelle est son indication &agrave; 3\")","v":"g;C.</p><p><p>Quelle est son indication &agrave; 3"}]
[null,{"$f":"CONCATENATE(\"00 &deg;C&nbsp;? \",R1._Cparties,\"</p><p><p>On d&eacute;sire con\")","v":"00 &deg;C&nbsp;? {1:NUMERICAL:=1.90E+03:9.50E+01}</p><p><p>On d&eacute;sire con"}]
[null,{"$f":"CONCATENATE(\"vertir le signal de sortie avec un CAN &agrave; ap\")","v":"vertir le signal de sortie avec un CAN &agrave; ap"}]
[null,{"$f":"CONCATENATE(\"proximations successives. Quelle tension de r&eacu\")","v":"proximations successives. Quelle tension de r&eacu"}]
[null,{"$f":"CONCATENATE(\"te;f&eacute;rence conseillez-vous pour pouvoir r&e\")","v":"te;f&eacute;rence conseillez-vous pour pouvoir r&e"}]
[null,{"$f":"CONCATENATE(\"acute;aliser des mesures entre 0 et 300 &deg;C&nbs\")","v":"acute;aliser des mesures entre 0 et 300 &deg;C&nbs"}]
[null,{"$f":"CONCATENATE(\"p;? \",R2._Cparties,\"</p><p><p>&nbsp;</p><p>\")","v":"p;? {1:NUMERICAL:=2.00E+00:1.00E-01}</p><p><p>&nbsp;</p><p>"}]

{"sheet":"Capt_Pt-Rh","index":6,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["catégorie_PtRh","Capteur_PtRh",{"$f":"CONCATENATE(\"    <!--  question XLQ \", titre_PtRh, \"-->\")","v":"    <!--  question XLQ Capteur_PtRh-->"},null,null,"Valeur Mini_PtRh","Valeur Maxi_PtRh","Sig. Digit_PtRh","Val Choix_PtRh"]
["titre_PtRh","Capteur_PtRh",{"$f":"CONCATENATE(\"    <question type=\",CHAR(34),\"category\",CHAR(34),\"><category><text>\", categorie_PtRh,\"</text></category></question>)\")","v":"    <question type=\"category\"><category><text>Capteur_PtRh</text></category></question>)"},null,"V1.a_PtRh",-1.5,-1.3,-3,{"$f":"RANDBETWEEN(ValMini_PtRh*10^-SigDig_PtRh, ValMaxi_PtRh*10^-SigDig_PtRh)/10^-SigDig_PtRh","v":-1.4690000000000001}]
["Tag_PtRh","PtRh","    <question type=\"cloze\">",null,"V2.b_PtRh",101,121,-1,{"$f":"RANDBETWEEN(ValMini_PtRh*10^-SigDig_PtRh, ValMaxi_PtRh*10^-SigDig_PtRh)/10^-SigDig_PtRh","v":114.8}]
["idnumber_PtRh",{"$f":"TEXT(NOW(),\"aammjj-hhmmss.00\")","v":"210710-210812.04"},{"$f":"CONCATENATE(\"        <name><text>\", titre_PtRh, \"</text></name>\")","v":"        <name><text>Capteur_PtRh</text></name>"},null,"V3.c_PtRh",50,65,-1,{"$f":"RANDBETWEEN(ValMini_PtRh*10^-SigDig_PtRh, ValMaxi_PtRh*10^-SigDig_PtRh)/10^-SigDig_PtRh","v":55.3}]
["points_PtRh",2,"        <questiontext format=\"html\">"]
["tolérance_PtRh",0.5,{"$f":"CONCATENATE(\"            <text><![CDATA[<p>\", question_PtRh, \"</p>]]></text>\")","v":"            <text><![CDATA[<p> <p>Entre 630 et 1064&deg;C, la f.e.m. du thermocouple Pt-Rh 10% / Pt peut &ecirc;tre reli&eacute;e &agrave; la temp&eacute;rature au vingti&egrave;me de degr&eacute; pr&egrave;s par la fonction simple &Theta; =&nbsp;ae<sup>2</sup>&nbsp;+&nbsp;be&nbsp;+&nbsp;c o&ugrave; a&nbsp;=&nbsp;-1.469 , b&nbsp;=&nbsp;114.8 et c&nbsp;= 55.3. Dans cette formule, les f.e.m. sont en mV et les temp&eacute;ratures en &deg;C. Quelle est la sensibilit&eacute; du thermocouple Pt-Rh 10 % / Pt au voisinage de 1000 &deg;C&nbsp;? {2:NUMERICAL:=-2.82E+03:-1.41E+03}</p><p></p>]]></text>"},null,null,"Cible_PtRh","Toler_PtRh","PointsQuestion_PtRh"]
["penalité_PtRh",0.1,"        </questiontext>",null,"R1.sens_PtRh",{"$f":"2*V1.a_PtRh*1000+V2.b_PtRh","v":-2823.2},{"$f":" tolerance_PtRh*ValMini_PtRh","v":-1411.6},2,{"$f":"CONCATENATE(\"{\",PointsQuestion_PtRh,\":NUMERICAL:=\",TEXT(Cible_PtRh,\"0.00E+00\"),\":\",TEXT(Tolere_PtRh,\"0.00E+00\"),\"}\")","v":"{2:NUMERICAL:=-2.82E+03:-1.41E+03}"}]
["feedback_PtRh","Regardez_definition_de_la_sensibilite_cest_la_variation_relative_entre_entree_et_sortie",{"$f":"CONCATENATE(\"        <defaultgrade>\",points_PtRh,\"</defaultgrade><generalfeedback><text>\",feedback_PtRh,\"</text></generalfeedback><penalty>\",penalty_PtRh,\"</penalty><hidden>0</hidden>)\")","v":"        <defaultgrade>2</defaultgrade><generalfeedback><text>Regardez_definition_de_la_sensibilite_cest_la_variation_relative_entre_entree_et_sortie</text></generalfeedback><penalty>0.1</penalty><hidden>0</hidden>)"}]
["Cellule vides_PtRh",{"$f":"COUNTBLANK(B1:B8)","v":0},{"$f":"CONCATENATE(\"        <idnumber>\",idnumber_PtRh,\"</idnumber><tags><tag><text>\",Tag_PtRh,\"</text></tag></tags>\")","v":"        <idnumber>210710-210812.04</idnumber><tags><tag><text>PtRh</text></tag></tags>"}]
["question format HTML_PtRh",{"$f":"CONCATENATE(\" \",B19,B20,B21)","v":" <p>Entre 630 et 1064&deg;C, la f.e.m. du thermocouple Pt-Rh 10% / Pt peut &ecirc;tre reli&eacute;e &agrave; la temp&eacute;rature au vingti&egrave;me de degr&eacute; pr&egrave;s par la fonction simple &Theta; =&nbsp;ae<sup>2</sup>&nbsp;+&nbsp;be&nbsp;+&nbsp;c o&ugrave; a&nbsp;=&nbsp;-1.469 , b&nbsp;=&nbsp;114.8 et c&nbsp;= 55.3. Dans cette formule, les f.e.m. sont en mV et les temp&eacute;ratures en &deg;C. Quelle est la sensibilit&eacute; du thermocouple Pt-Rh 10 % / Pt au voisinage de 1000 &deg;C&nbsp;? {2:NUMERICAL:=-2.82E+03:-1.41E+03}</p><p>"},"    </question>"]
["Repere Var Rep","_PtRh"]
["HTML File "]
["https://html-online.com/editor/ "]
[]
[null,null,5,null,null,null,"Entre 630 et 1064°C, la f.e.m. du thermocouple Pt-Rh 10% / Pt peut être reliée à la température au vingtième de degré près par la fonction simple "]
["Var : ","#",3,null,null,null,"q = ae2 + be + c où a = -1,225 , b = 110,1 et c = 57,3. Dans cette formule, les f.e.m. sont en mV et les températures en °C. "]
["Res : ","$",1,null,null,null,"Quelle est la sensibilité du thermocouple Pt-Rh 10 % / Pt au voisinage de 1000 °C ?"]
[]
[null,{"$f":"CONCATENATE(\"<p>Entre 630 et 1064&deg;C, la f.e.m. du thermocouple Pt-Rh 10% / Pt peut &ecirc;tre reli&eacute;e &agrave; la temp&eacute;rature au vingti&egrave;me de degr&eacute; pr&egrave;s par la fonction simple &Theta; =&nbsp;ae<s\")","v":"<p>Entre 630 et 1064&deg;C, la f.e.m. du thermocouple Pt-Rh 10% / Pt peut &ecirc;tre reli&eacute;e &agrave; la temp&eacute;rature au vingti&egrave;me de degr&eacute; pr&egrave;s par la fonction simple &Theta; =&nbsp;ae<s"},"<p>Entre 630 et 1064&deg;C, la f.e.m. du thermocouple Pt-Rh 10% / Pt peut &ecirc;tre reli&eacute;e &agrave; la temp&eacute;rature au vingti&egrave;me de degr&eacute; pr&egrave;s par la fonction simple &Theta; =&nbsp;ae<sup>2</sup>&nbsp;+&nbsp;be&nbsp;+&nbsp;c o&ugrave; a&nbsp;=&nbsp;#1# , b&nbsp;=&nbsp;#2# et c&nbsp;= #3#. Dans cette formule, les f.e.m. sont en mV et les temp&eacute;ratures en &deg;C. Quelle est la sensibilit&eacute; du thermocouple Pt-Rh 10 % / Pt au voisinage de 1000 &deg;C&nbsp;? $1$</p>"]
[null,{"$f":"CONCATENATE(\"up>2</sup>&nbsp;+&nbsp;be&nbsp;+&nbsp;c o&ugrave; a&nbsp;=&nbsp;\",V1.a_PtRh,\" , b&nbsp;=&nbsp;\",V2.b_PtRh,\" et c&nbsp;= \",V3.c_PtRh,\". Dans cette formule, les f.e.m. sont en mV et les temp&eacute;ratures en &deg;C. Quelle est la sensibilit&eacute; du\")","v":"up>2</sup>&nbsp;+&nbsp;be&nbsp;+&nbsp;c o&ugrave; a&nbsp;=&nbsp;-1.469 , b&nbsp;=&nbsp;114.8 et c&nbsp;= 55.3. Dans cette formule, les f.e.m. sont en mV et les temp&eacute;ratures en &deg;C. Quelle est la sensibilit&eacute; du"}]
[null,{"$f":"CONCATENATE(\" thermocouple Pt-Rh 10 % / Pt au voisinage de 1000 &deg;C&nbsp;? \",R1.sens_PtRh,\"</p><p>\")","v":" thermocouple Pt-Rh 10 % / Pt au voisinage de 1000 &deg;C&nbsp;? {2:NUMERICAL:=-2.82E+03:-1.41E+03}</p><p>"}]

{"sheet":"Stat","index":7,"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":6.7},null,null,null,2,"#2  ;  "]
["Tag_Stat","M-STDV","    <question type=\"cloze\">",null,"V2._Stat",1,20,-1,14.8,null,null,null,3,"#3  ;  "]
["idnumber_Stat",{"$f":"TEXT(NOW(),\"aammjj-hhmmss.00\")","v":"210710-210812.04"},{"$f":"CONCATENATE(\"     <name><text>\", titre_Stat, \"</text></name>\")","v":"     <name><text>Moy_et_Ecart</text></name>"},null,"V3._Stat",1,30,-1,7.9,null,null,null,4,"#4  ;  "]
["points_Stat",1,"    <questiontext format=\"html\">",null,"V4._Stat",1,100,0,89,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 : 6.7  ;  14.8  ;  7.9  ;  89  ;  6.1  ;  86.6  ;  15.7  ;  23  ;  30  ;  11.9  ;  8.1  ;  11 , calculez la moyenne : {1:NUMERICAL:=2.59E+01:1.30E+00} et l'ecart type : {1:NUMERICAL:=2.98E+01:1.49E+00}<p></p>]]></text>"},null,"V5._Stat",6,16,-1,6.1,null,null,null,6,"#6  ;  "]
["penalité_Stat",0.1,"    </questiontext>",null,"V6._Stat",1,99,-1,86.6,null,null,null,7,"#7  ;  "]
["feedback_Stat","Cf._cours_de_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>Cf._cours_de_statistiques</text></generalfeedback><penalty>0.1</penalty><hidden>0</hidden>)"},null,"V7._Stat",1,22,-1,15.7,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-210812.04</idnumber><tags><tag><text>M-STDV</text></tag></tags>"},null,"V8._Stat",1,74,0,23,null,null,null,9,"#9  ;  "]
["question format HTML_Stat",{"$f":"CONCATENATE(C19, C20, C21, C22)","v":"Pour cet ensemble de valeurs : 6.7  ;  14.8  ;  7.9  ;  89  ;  6.1  ;  86.6  ;  15.7  ;  23  ;  30  ;  11.9  ;  8.1  ;  11 , calculez la moyenne : {1:NUMERICAL:=2.59E+01:1.30E+00} et l'ecart type : {1:NUMERICAL:=2.98E+01:1.49E+00}<p>"},"   </question>",null,"V9._Stat",5,35,1,30,null,null,null,10,"#10  ;  "]
["Repere Var Rep","_Stat",null,null,"V10._Stat",9,26,-1,11.9,null,null,null,11,"#11  ;  "]
["HTML File ","Stats.txt",null,null,"V11._Stat",3,12,-1,8.1,null,null,null,12,"#12  ;  "]
["Valide ? ",{"$f":"ISNUMBER(H18)","v":true},null,null,"V12._Stat",4,12,0,11]
["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":25.899999999999995},{"$f":" tolerance_Stat*ValMini_Stat","v":1.2949999999999999},1,{"$f":"CONCATENATE(\"{1:NUMERICAL:=\",TEXT(Cible_Stat,\"0.00E+00\"),\":\",TEXT(Tolere_Stat,\"0.00E+00\"),\"}\")","v":"{1:NUMERICAL:=2.59E+01:1.30E+00}"}]
["Res : ","$",2,null,"R2.Ecart_Stat",{"$f":"STDEV(I2:I13)","v":29.753685791542171},{"$f":" tolerance_Stat*ValMini_Stat","v":1.4876842895771087},1,{"$f":"CONCATENATE(\"{1:NUMERICAL:=\",TEXT(Cible_Stat,\"0.00E+00\"),\":\",TEXT(Tolere_Stat,\"0.00E+00\"),\"}\")","v":"{1:NUMERICAL:=2.98E+01:1.49E+00}"}]
[null,null,null,null,null,null,null,{"$f":"SUM(F16:H17)","v":60.436370081119271}]
["","",{"$f":"CONCATENATE(\"Pour cet ensemble de valeurs : \",V1._Stat,\"  ;  \",V2._Stat,\"  ;  \",V3._Stat,\"  ;\")","v":"Pour cet ensemble de valeurs : 6.7  ;  14.8  ;  7.9  ;"}]
["","",{"$f":"CONCATENATE(\"  \",V4._Stat,\"  ;  \",V5._Stat,\"  ;  \",V6._Stat,\"  ;  \",V7._Stat,\"  ;  \",V8._Stat,\"  ;  \",V9._Stat,\"  ;  \",V10._Stat,\"  ;\")","v":"  89  ;  6.1  ;  86.6  ;  15.7  ;  23  ;  30  ;  11.9  ;"}]
["","",{"$f":"CONCATENATE(\"  \",V11._Stat,\"  ;  \",V12._Stat,\" , calculez la moyenne : \",R1.Moy_Stat,\" et l'ecar\")","v":"  8.1  ;  11 , calculez la moyenne : {1:NUMERICAL:=2.59E+01:1.30E+00} et l'ecar"}]
["","",{"$f":"CONCATENATE(\"t type : \",R2.Ecart_Stat,\"<p>\")","v":"t type : {1:NUMERICAL:=2.98E+01:1.49E+00}<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":8,"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":5.0872663218502645E-7},{"$f":"ROUND(F2,1-INT(LOG10(ABS(M2))))","v":5.087E-7},null,null,-6,null,"DeltA_EPhy",{"$f":"F2*10^(-3*(RAND()+0.1))","v":2.7119876023350104E-9},{"$f":"ROUNDUP(M2,1-INT(LOG10(ABS(M2))))","v":2.8000000000000003E-9}]
["Tag_EPhy","Ecriture_correcte","    <question type=\"cloze\">",null,"VarB_EPhy",{"$f":"RAND()*10^(J3)","v":5.7520647806214118E-4},{"$f":"ROUND(F3,1-INT(LOG10(ABS(M3))))","v":5.7499999999999999E-4},null,null,-3,null,"DelB_EPhy",{"$f":"F3*10^(-3*(RAND()+0.1))","v":2.5402166878788666E-5},{"$f":"ROUNDUP(M3,1-INT(LOG10(ABS(M3))))","v":2.6000000000000002E-5}]
["idnumber_EPhy",{"$f":"TEXT(NOW(),\"aammjj-hhmmss.00\")","v":"210710-210812.04"},{"$f":"CONCATENATE(\"     <name><text>\", titre_EPhy, \"</text></name>\")","v":"     <name><text>Expr_Phys</text></name>"},null,"VarC_EPhy",{"$f":"RAND()*10^(J4)","v":13.007273025163911},{"$f":"ROUND(F4,1-INT(LOG10(ABS(M4))))","v":13.007},null,null,3,null,"DeltC_EPhy",{"$f":"F4*10^(-3*(RAND()+0.1))","v":1.3583443527691716E-2},{"$f":"ROUNDUP(M4,1-INT(LOG10(ABS(M4))))","v":1.3999999999999999E-2}]
["points_EPhy",1,"    <questiontext format=\"html\">",null,"VarD_EPhy",{"$f":"RAND()*10^(J5)","v":217247.31961735932},{"$f":"ROUND(F5,1-INT(LOG10(ABS(M5))))","v":217000},null,null,6,null,"DeltD_EPhy",{"$f":"F5*10^(-3*(RAND()+0.1))","v":34592.98093083335},{"$f":"ROUNDUP(M5,1-INT(LOG10(ABS(M5))))","v":35000}]
["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>127707693256.582+/-5531663612.31812={1:NUMERICAL:=127.7:12.77}+/-{1:NUMERICAL:=5.6:0.56}{1:SHORTANSWER:=G}<BR>217247.319617359+/-34592.9809308333={1:NUMERICAL:=217:21.7}+/-{1:NUMERICAL:=35:3.5}{1:SHORTANSWER:=k}<BR>13.0072730251639+/-0.0135834435276917={1:NUMERICAL:=13007:1300.7}+/-{1:NUMERICAL:=14:1.4}{1:SHORTANSWER:=m}<BR>0.000575206478062141+/-2.54021668787887E-05={1:NUMERICAL:=575:57.5}+/-{1:NUMERICAL:=26:2.6}{1:SHORTANSWER:=u}<BR>5.08726632185026E-07+/-2.71198760233501E-09={1:NUMERICAL:=508.7:50.87}+/-{1:NUMERICAL:=2.8:0.28}{1:SHORTANSWER:=n}<BR></li></ul></p>]]></text>"},null,"VarE_EPhy",{"$f":"RAND()*10^(J6)","v":127707693256.58238},{"$f":"ROUND(F6,1-INT(LOG10(ABS(M6))))","v":127700000000},null,null,12,null,"DeltE_EPhy",{"$f":"F6*10^(-3*(RAND()+0.1))","v":5531663612.3181162},{"$f":"ROUNDUP(M6,1-INT(LOG10(ABS(M6))))","v":5600000000}]
["penalité_EPhy",0.1,"    </questiontext>"]
["feedback_EPhy","Vous_avez_le_cours_ou_le_fichier_exce_de_demo_des_videos",{"$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>Vous_avez_le_cours_ou_le_fichier_exce_de_demo_des_videos</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-210812.04</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>127707693256.582+/-5531663612.31812={1:NUMERICAL:=127.7:12.77}+/-{1:NUMERICAL:=5.6:0.56}{1:SHORTANSWER:=G}<BR>217247.319617359+/-34592.9809308333={1:NUMERICAL:=217:21.7}+/-{1:NUMERICAL:=35:3.5}{1:SHORTANSWER:=k}<BR>13.0072730251639+/-0.0135834435276917={1:NUMERICAL:=13007:1300.7}+/-{1:NUMERICAL:=14:1.4}{1:SHORTANSWER:=m}<BR>0.000575206478062141+/-2.54021668787887E-05={1:NUMERICAL:=575:57.5}+/-{1:NUMERICAL:=26:2.6}{1:SHORTANSWER:=u}<BR>5.08726632185026E-07+/-2.71198760233501E-09={1:NUMERICAL:=508.7:50.87}+/-{1:NUMERICAL:=2.8:0.28}{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":"508.7"},{"$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.8"},{"$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":"5.08726632185026E-07+/-2.71198760233501E-09={1:NUMERICAL:=508.7:50.87}+/-{1:NUMERICAL:=2.8:0.28}{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":"575"},{"$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":"26"},{"$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.000575206478062141+/-2.54021668787887E-05={1:NUMERICAL:=575:57.5}+/-{1:NUMERICAL:=26:2.6}{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":"13007"},{"$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":"14"},{"$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":"m"},{"$f":"IF(ISNA(G16),\"\",TRIM(CONCATENATE(F4,\"+/-\",M4,\"={1:NUMERICAL:=\",F16,\":\",F16/10,\"}+/-{1:NUMERICAL:=\",G16,\":\",G16/10,\"}{1:SHORTANSWER:=\",H16,\"}<BR>\")))","v":"13.0072730251639+/-0.0135834435276917={1:NUMERICAL:=13007:1300.7}+/-{1:NUMERICAL:=14:1.4}{1:SHORTANSWER:=m}<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":"217"},{"$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":"35"},{"$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":"k"},{"$f":"IF(ISNA(G17),\"\",TRIM(CONCATENATE(F5,\"+/-\",M5,\"={1:NUMERICAL:=\",F17,\":\",F17/10,\"}+/-{1:NUMERICAL:=\",G17,\":\",G17/10,\"}{1:SHORTANSWER:=\",H17,\"}<BR>\")))","v":"217247.319617359+/-34592.9809308333={1:NUMERICAL:=217:21.7}+/-{1:NUMERICAL:=35:3.5}{1:SHORTANSWER:=k}<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":"127.7"},{"$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":"5.6"},{"$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":"127707693256.582+/-5531663612.31812={1:NUMERICAL:=127.7:12.77}+/-{1:NUMERICAL:=5.6:0.56}{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":"127707693256.582+/-5531663612.31812={1:NUMERICAL:=127.7:12.77}+/-{1:NUMERICAL:=5.6:0.56}{1:SHORTANSWER:=G}<BR>217247.319617359+/-34592.9809308333={1:NUMERICAL:=217:21.7}+/-{1:NUMERICAL:=35:3.5}{1:SHORTANSWER:=k}<BR>13.0072730251639+/-0.0135834435276917={1:NUMERICAL:=13007:1300.7}+/-{1:NUMERICAL:=14:1.4}{1:SHORTANSWER:=m}<BR>0.000575206478062141+/-2.54021668787887E-05={1:NUMERICAL:=575:57.5}+/-{1:NUMERICAL:=26:2.6}{1:SHORTANSWER:=u}<BR>5.08726632185026E-07+/-2.71198760233501E-09={1:NUMERICAL:=508.7:50.87}+/-{1:NUMERICAL:=2.8:0.28}{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":"Capa","index":9,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["catégorie_capa","ChargeCapa",{"$f":"CONCATENATE(\"    <!--  question XLQ \", titre_capa, \"-->\")","v":"    <!--  question XLQ ChargeCapa-->"},null,null,"Valeur Mini_capa","Valeur Maxi_capa","Sig. Digit_capa","Val Choix_capa"]
["titre_capa","ChargeCapa",{"$f":"CONCATENATE(\"    <question type=\",CHAR(34),\"category\",CHAR(34),\"><category><text>\", categorie_capa,\"</text></category></question>)\")","v":"    <question type=\"category\"><category><text>ChargeCapa</text></category></question>)"},null,"V1.Charge_capa",0.5,7.5,{"$f":"RANDBETWEEN(-2,0)","v":-1},{"$f":"RANDBETWEEN(ValMini_capa*10^-SigDig_capa, ValMaxi_capa*10^-SigDig_capa)/10^-SigDig_capa","v":7},"pF",{"$f":"10^(H2)","v":0.1}]
["Tag_capa","Condo","    <question type=\"cloze\">",null,"V2.Tension_capa",1,150,{"$f":"RANDBETWEEN(-1,0)","v":0},{"$f":"RANDBETWEEN(ValMini_capa*10^-SigDig_capa, ValMaxi_capa*10^-SigDig_capa)/10^-SigDig_capa","v":132},"kV",{"$f":"10^(H3)","v":1}]
["idnumber_capa",{"$f":"TEXT(NOW(),\"aammjj-hhmmss.00\")","v":"210710-210812.04"},{"$f":"CONCATENATE(\"        <name><text>\", titre_capa, \"</text></name>\")","v":"        <name><text>ChargeCapa</text></name>"}]
["points_capa",1,"        <questiontext format=\"html\">",null,null,"Cible_capa","Toler_capa","PointsQuestion_capa"]
["tolérance_capa",0.05,{"$f":"CONCATENATE(\"            <text><![CDATA[<p>\", question_capa, \"</p>]]></text>\")","v":"            <text><![CDATA[<p> <p>La charge d'un condensateur de capacit&eacute; C sous la tension U s'exprime Q = C.U. Si C = 7 pF et U = 132 kV, trouver Q = {1:NUMERICAL:=9.24E+02:4.62E+01} +/- {2:NUMERICAL:=2.02E+01:1.01E+00} C.</p><p></p>]]></text>"},null,"R1.Q_capa",{"$f":"V1.Charge_capa*V2.Tension_capa","v":924},{"$f":" tolerance_capa*ValMini_capa","v":46.2},1,{"$f":"CONCATENATE(\"{\",PointsQuestion_capa,\":NUMERICAL:=\",TEXT(Cible_capa,\"0.00E+00\"),\":\",TEXT(Tolere_capa,\"0.00E+00\"),\"}\")","v":"{1:NUMERICAL:=9.24E+02:4.62E+01}"}]
["penalité_capa",0.1,"        </questiontext>",null,"R2.DQ_capa",{"$f":"F6*(K2/V1.Charge_capa+K3/V2.Tension_capa)","v":20.200000000000003},{"$f":" tolerance_capa*ValMini_capa","v":1.0100000000000002},2,{"$f":"CONCATENATE(\"{\",PointsQuestion_capa,\":NUMERICAL:=\",TEXT(Cible_capa,\"0.00E+00\"),\":\",TEXT(Tolere_capa,\"0.00E+00\"),\"}\")","v":"{2:NUMERICAL:=2.02E+01:1.01E+00}"}]
["feedback_capa","Capacite",{"$f":"CONCATENATE(\"        <defaultgrade>\",points_capa,\"</defaultgrade><generalfeedback><text>\",feedback_capa,\"</text></generalfeedback><penalty>\",penalty_capa,\"</penalty><hidden>0</hidden>)\")","v":"        <defaultgrade>1</defaultgrade><generalfeedback><text>Capacite</text></generalfeedback><penalty>0.1</penalty><hidden>0</hidden>)"},null,null,{"$f":"F7/F6","v":2.1861471861471863E-2},null,{"$f":"SUM(F6:H7)","v":994.41000000000008}]
["Cellule vides_capa",{"$f":"COUNTBLANK(B1:B8)","v":0},{"$f":"CONCATENATE(\"        <idnumber>\",idnumber_capa,\"</idnumber><tags><tag><text>\",Tag_capa,\"</text></tag></tags>\")","v":"        <idnumber>210710-210812.04</idnumber><tags><tag><text>Condo</text></tag></tags>"}]
["question format HTML_capa",{"$f":"CONCATENATE(\" \",B19,B20)","v":" <p>La charge d'un condensateur de capacit&eacute; C sous la tension U s'exprime Q = C.U. Si C = 7 pF et U = 132 kV, trouver Q = {1:NUMERICAL:=9.24E+02:4.62E+01} +/- {2:NUMERICAL:=2.02E+01:1.01E+00} C.</p><p>"},"    </question>"]
["Repere Var Rep","_capa"]
["HTML File ",{"$f":"CONCATENATE(categorie_capa,\"_HTML.txt\")","v":"ChargeCapa_HTML.txt"}]
["Valide ? ",{"$f":"ISNUMBER(H8)","v":true}]
["https://html-online.com/editor/ "]
[null,null,4]
["Var : ","#",2]
["Res : ","$",2]
[]
[null,{"$f":"CONCATENATE(\"<p>La charge d'un condensateur de capacit&eacute; C sous la tension U s'exprime Q = C.U. Si C = \",V1.Charge_capa,\" pF et U = \",V2.Tension_capa,\" kV, trouver Q = \",R1.Q_capa,\" +/- \",R2.DQ_capa,\" C.</p><p>\")","v":"<p>La charge d'un condensateur de capacit&eacute; C sous la tension U s'exprime Q = C.U. Si C = 7 pF et U = 132 kV, trouver Q = {1:NUMERICAL:=9.24E+02:4.62E+01} +/- {2:NUMERICAL:=2.02E+01:1.01E+00} C.</p><p>"},"<p>La charge d'un condensateur de capacit&eacute; C sous la tension U s'exprime Q = C.U. Si C = #1# pF et U = #2# kV, trouver Q = $1$ +/- $2$.</p>"]
[null,{"$f":"CONCATENATE(\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"<p>La charge d'un condensateur de capacit&eacute; C sous la tension U s'exprime Q = C.U. Si C = \",V1.Charge_capa,\" pF et U = \",V2.Tension_capa,\" kV, trouver Q = \",R1.Q_capa,\" +/- \",R2.DQ_capa,\".</p><p>"]

{"sheet":"AbsRel","index":10,"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":13},{"$f":"I4","v":6},{"$f":"J2/V1._AbRe*100","v":46.153846153846153}]
["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":5},{"$f":"IncertAbsV1","v":6},{"$f":"J3/V1._AbRe*100","v":46.153846153846153}]
["idnumber_AbRe",{"$f":"TEXT(NOW(),\"aammjj-hhmmss.00\")","v":"210710-210812.04"},{"$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":6},null,{"$f":"(K3+K2)*V2._AbRe*V1._AbRe/100","v":60},{"$f":"G3*G2","v":8064},{"$f":"K4/L4","v":7.4404761904761901E-3}]
["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 = 13, B = 5.&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:=1.20E+01:6.00E-01}</td><td>{1:NUMERICAL:=4.32E+00:2.16E-01}</td><td>{1:NUMERICAL:=1.08E+02:5.40E+00}</td></tr><tr><td>Relative</td><td>{1:NUMERICAL:=6.67E-01:3.33E-02}</td><td>{1:NUMERICAL:=1.66E+00:8.31E-02}</td><td>{1:NUMERICAL:=1.66E+00:8.31E-02}</td></tr></tbody></table><p>&nbsp;</p></p>]]></text>"},null,"R1.AbsSomme_AbRe",{"$f":"IncertAbsV1+IncertAbsV2","v":12},{"$f":" tolerance_AbRe*ValMini_AbRe","v":0.60000000000000009},1,{"$f":"CONCATENATE(\"{\",SigDig_AbRe,\":NUMERICAL:=\",TEXT(Cible_AbRe,\"0.00E+00\"),\":\",TEXT(Tolere_AbRe,\"0.00E+00\"),\"}\")","v":"{1:NUMERICAL:=1.20E+01:6.00E-01}"}]
["penalité_AbRe",0.1,"    </questiontext>",null,"R2.AbsRatio_AbRe",{"$f":"(V1._AbRe/V2._AbRe)*(IncertAbsV1/V1._AbRe+IncertAbsV2/V2._AbRe)","v":4.3199999999999994},0.21599999999999997,1,"{1:NUMERICAL:=4.32E+00:2.16E-01}"]
["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":107.99999999999999},5.3999999999999995,1,"{1:NUMERICAL:=1.08E+02:5.40E+00}"]
["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-210812.04</idnumber><tags><tag><text>Incertitude</text></tag></tags>"},null,"R4.RelSomme_AbRe",{"$f":"(IncertAbsV1+IncertAbsV2)/(V2._AbRe+V1._AbRe)","v":0.66666666666666663},3.3333333333333333E-2,1,"{1:NUMERICAL:=6.67E-01:3.33E-02}"]
["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 = 13, B = 5.&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:=1.20E+01:6.00E-01}</td><td>{1:NUMERICAL:=4.32E+00:2.16E-01}</td><td>{1:NUMERICAL:=1.08E+02:5.40E+00}</td></tr><tr><td>Relative</td><td>{1:NUMERICAL:=6.67E-01:3.33E-02}</td><td>{1:NUMERICAL:=1.66E+00:8.31E-02}</td><td>{1:NUMERICAL:=1.66E+00:8.31E-02}</td></tr></tbody></table><p>&nbsp;</p>"},"   </question>",null,"R5.RelRatio_AbRe",{"$f":"IncertAbsV1/V1._AbRe+IncertAbsV2/V2._AbRe","v":1.6615384615384614},8.3076923076923076E-2,1,"{1:NUMERICAL:=1.66E+00:8.31E-02}"]
["Repere Var Rep","_AbRe",null,null,"R6.RelProd_AbRe",{"$f":"IncertAbsV1/V1._AbRe+IncertAbsV2/V2._AbRe","v":1.6615384615384614},8.3076923076923076E-2,1,"{1:NUMERICAL:=1.66E+00:8.31E-02}"]
["HTML File ","Delta.HTML.txt"]
["Valide ? ",{"$f":"ISNUMBER(H13)","v":true},null,null,null,null,null,{"$f":"SUM(F6:H11)","v":140.72523076923076}]
["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 = 13, B = 5.&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:=1.20E+01:6.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:=4.32E+00:2.16E-01}</td><td>{1:NUMERICAL:=1.08E+02:5.40E+00}</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:=6.67E-01:3.33E-02}</td><td>{1:NUMERICAL:=1.66E+00:8.31E-02}</td><td>{1:NUMERICAL:=1.66E+00:8.31E-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 = 13, B = 5.&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:=1.20E+01:6.00E-01}</td><td>{1:NUMERICAL:=4.32E+00:2.16E-01}</td><td>{1:NUMERICAL:=1.08E+02:5.40E+00}</td></tr><tr><td>Relative</td><td>{1:NUMERICAL:=6.67E-01:3.33E-02}</td><td>{1:NUMERICAL:=1.66E+00:8.31E-02}</td><td>{1:NUMERICAL:=1.66E+00:8.31E-02}</td></tr></tbody></table><p>&nbsp;</p>"}]

{"sheet":"FourCyl","index":11,"n_rows":58,"n_cols":79,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
["catégorie_FourC","Four_parabolique",{"$f":"CONCATENATE(\"    <!--  question XLQ \", titre_FourC, \"-->\")","v":"    <!--  question XLQ Four_parabolique-->"},null,null,"Valeur Mini_FourC","Valeur Maxi_FourC","Sig. Digit_FourC","Val Choix_FourC",null,"Milieu =",{"$f":"-V2._FourC/(2*V1._FourC)","v":11.790123456790123}," =-b/2a",null,null,{"$f":"CONCATENATE(\"<p>Dans un four cylindrique sym&eacute;trique et h\")","v":"<p>Dans un four cylindrique sym&eacute;trique et h"}]
["titre_FourC","Four_parabolique",{"$f":"CONCATENATE(\"    <question type=\",CHAR(34),\"category\",CHAR(34),\"><category><text>\", categorie_FourC,\"</text></category></question>)\")","v":"    <question type=\"category\"><category><text>Four_parabolique</text></category></question>)"},null,"V1._FourC",-0.9,-0.5,-2,{"$f":"RANDBETWEEN(ValMini_FourC*10^-SigDig_FourC, ValMaxi_FourC*10^-SigDig_FourC)/10^-SigDig_FourC","v":-0.81},"a","Temp Milieu",{"$f":"V1._FourC*L1^2+V2._FourC*L1+V3._FourC","v":583.59567901234573},null,null,null,{"$f":"CONCATENATE(\"orizontal, la temp&eacute;rature&nbsp;&Theta; est \")","v":"orizontal, la temp&eacute;rature&nbsp;&Theta; est "}]
["Tag_FourC","Four_parabolique","    <question type=\"cloze\">",null,"V2._FourC",12,24,-1,{"$f":"RANDBETWEEN(ValMini_FourC*10^-SigDig_FourC, ValMaxi_FourC*10^-SigDig_FourC)/10^-SigDig_FourC","v":19.100000000000001},"b","T faux",{"$f":"V1._FourC*(L1+V4._FourC)^2+V2._FourC*(L1+V4._FourC)+V3._FourC","v":580.35567901234572},null,null,null,{"$f":"CONCATENATE(\"donn&eacute;e en fonction de la position x dans le\")","v":"donn&eacute;e en fonction de la position x dans le"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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>Dans un four cylindrique sym&eacute;trique et horizontal, la temp&eacute;rature&nbsp;&Theta; est donn&eacute;e en fonction de la position x dans le four par la relation <strong>&Theta; =&nbsp;ax<sup>2</sup> + bx + c</strong>, avec a=#1#, b=#2# , c=#3#, o&ugrave; &Theta; est exprim&eacute;e en &deg;C et x en cm. Une pi&egrave;ce de petites dimensions est introduite au point le plus chaud (donc au centre du four), mais sa position n'est connue qu'&agrave; #4#cm pr&egrave;s.</p><p><p>- Quelle taille du four ? $1$ cm.</p><p><p>- Quelle est la temp&eacute;rature au milieu du four ? $2$&deg;C.</p><p><p>- Quelle est l'incertitude (induite par la g&eacute;om&eacute;trie) sur la mesure de la temp&eacute;rature &nbsp;? $3$&deg;C.</p><p><p>&nbsp;</p><p>"]
["idnumber_FourC",{"$f":"TEXT(NOW(),\"aammjj-hhmmss.00\")","v":"210710-210812.04"},{"$f":"CONCATENATE(\"        <name><text>\", titre_FourC, \"</text></name>\")","v":"        <name><text>Four_parabolique</text></name>"},null,"V3._FourC",400,550,0,{"$f":"RANDBETWEEN(ValMini_FourC*10^-SigDig_FourC, ValMaxi_FourC*10^-SigDig_FourC)/10^-SigDig_FourC","v":471},"c",null,null,null,null,null,{"$f":"CONCATENATE(\" four par la relation &Theta; =&nbsp;ax<sup>2</sup\")","v":" four par la relation &Theta; =&nbsp;ax<sup>2</sup"}]
["points_FourC",1,"        <questiontext format=\"html\">",null,"V4._FourC",2,7,0,{"$f":"RANDBETWEEN(ValMini_FourC*10^-SigDig_FourC, ValMaxi_FourC*10^-SigDig_FourC)/10^-SigDig_FourC","v":2},"Dx",null,null,null,null,null,{"$f":"CONCATENATE(\">&nbsp;+&nbsp;bx&nbsp;+&nbsp;c avec a&nbsp;= \",V1._FourC,\" ,\")","v":">&nbsp;+&nbsp;bx&nbsp;+&nbsp;c avec a&nbsp;= -0.81 ,"}]
["tolérance_FourC",0.05,{"$f":"CONCATENATE(\"            <text><![CDATA[<p>\", question_FourC, \"</p>]]></text>\")","v":"            <text><![CDATA[<p> <p>Dans un four cylindrique sym&eacute;trique et horizontal, la temp&eacute;rature&nbsp;&Theta; est donn&eacute;e en fonction de la position x dans le four par la relation <strong>&Theta; =&nbsp;ax<sup>2</sup>+ bx + c</strong>, avec a=-0.81, b=19.1 , c=471, o&ugrave; &Theta; est exprim&eacute;e en &deg;C et x en cm. Une pi&egrave;ce de petites dimensions est introduite au point le plus chaud (donc au centre du four), mais sa position n'est connue qu'&agrave; 2cm pr&egrave;s.</p><p><p>- Quelle taille du four ? {2:NUMERICAL:=2.36E+01:1.18E+00} cm.</p><p><p>- Quelle est la temp&eacute;rature au milieu du four ? {1:NUMERICAL:=5.84E+02:2.92E+01}&deg;C.</p><p><p>- Quelle est l'incertitude (induite par la g&eacute;om&eacute;trie) sur la mesure de la temp&eacute;rature &nbsp;? {2:NUMERICAL:=3.24E+00:1.62E-01}&deg;C.</p><p><p>&nbsp;</p><p></p>]]></text>"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\" b&nbsp;= \",V2._FourC,\" , c&nbsp;= \",V3._FourC,\", o&ugrave;&nbsp;&Thet\")","v":" b&nbsp;= 19.1 , c&nbsp;= 471, o&ugrave;&nbsp;&Thet"}]
["penalité_FourC",0.1,"        </questiontext>",null,null,"Cible_FourC","Tolér_FourC","Points_FourC","Question",null,null,null,null,null,null,{"$f":"CONCATENATE(\"a; est exprim&eacute;e en &deg;C et x en cm. Une p\")","v":"a; est exprim&eacute;e en &deg;C et x en cm. Une p"}]
["feedback_FourC","cest_une_parabole",{"$f":"CONCATENATE(\"        <defaultgrade>\",points_FourC,\"</defaultgrade><generalfeedback><text>\",feedback_FourC,\"</text></generalfeedback><penalty>\",penalty_FourC,\"</penalty><hidden>0</hidden>)\")","v":"        <defaultgrade>1</defaultgrade><generalfeedback><text>cest_une_parabole</text></generalfeedback><penalty>0.1</penalty><hidden>0</hidden>)"},null,"R1._FourC",{"$f":"2*L1","v":23.580246913580247},{"$f":" tolerance_FourC*ValMini_FourC","v":1.1790123456790125},2,{"$f":"CONCATENATE(\"{\",PointsQuestion_FourC,\":NUMERICAL:=\",TEXT(Cible_FourC,\"0.00E+00\"),\":\",TEXT(Tolere_FourC,\"0.00E+00\"),\"}\")","v":"{2:NUMERICAL:=2.36E+01:1.18E+00}"},null,null,"cm","taille four",null,null,{"$f":"CONCATENATE(\"i&egrave;ce de petites dimensions est introduite au milieu (au sommet de la parabole) j\")","v":"i&egrave;ce de petites dimensions est introduite au milieu (au sommet de la parabole) j"}]
["Cellule vides_FourC",{"$f":"COUNTBLANK(B1:B8)","v":0},{"$f":"CONCATENATE(\"        <idnumber>\",idnumber_FourC,\"</idnumber><tags><tag><text>\",Tag_FourC,\"</text></tag></tags>\")","v":"        <idnumber>210710-210812.04</idnumber><tags><tag><text>Four_parabolique</text></tag></tags>"},null,"R2._FourC",{"$f":"L2","v":583.59567901234573},{"$f":" tolerance_FourC*ValMini_FourC","v":29.179783950617288},1,{"$f":"CONCATENATE(\"{\",PointsQuestion_FourC,\":NUMERICAL:=\",TEXT(Cible_FourC,\"0.00E+00\"),\":\",TEXT(Tolere_FourC,\"0.00E+00\"),\"}\")","v":"{1:NUMERICAL:=5.84E+02:2.92E+01}"},null,null,"°C","Temp milieu",null,null,{"$f":"CONCATENATE(\"usqu'au centre du four, mais sa position n'est con\")","v":"usqu'au centre du four, mais sa position n'est con"}]
["question format HTML_FourC",{"$f":"CONCATENATE(\" \",B19,B20,B21,B22,B23,B24,B25,B26)","v":" <p>Dans un four cylindrique sym&eacute;trique et horizontal, la temp&eacute;rature&nbsp;&Theta; est donn&eacute;e en fonction de la position x dans le four par la relation <strong>&Theta; =&nbsp;ax<sup>2</sup>+ bx + c</strong>, avec a=-0.81, b=19.1 , c=471, o&ugrave; &Theta; est exprim&eacute;e en &deg;C et x en cm. Une pi&egrave;ce de petites dimensions est introduite au point le plus chaud (donc au centre du four), mais sa position n'est connue qu'&agrave; 2cm pr&egrave;s.</p><p><p>- Quelle taille du four ? {2:NUMERICAL:=2.36E+01:1.18E+00} cm.</p><p><p>- Quelle est la temp&eacute;rature au milieu du four ? {1:NUMERICAL:=5.84E+02:2.92E+01}&deg;C.</p><p><p>- Quelle est l'incertitude (induite par la g&eacute;om&eacute;trie) sur la mesure de la temp&eacute;rature &nbsp;? {2:NUMERICAL:=3.24E+00:1.62E-01}&deg;C.</p><p><p>&nbsp;</p><p>"},"    </question>",null,"R3._FourC",{"$f":"F9-L3","v":3.2400000000000091},{"$f":" tolerance_FourC*ValMini_FourC","v":0.16200000000000048},2,{"$f":"CONCATENATE(\"{\",PointsQuestion_FourC,\":NUMERICAL:=\",TEXT(Cible_FourC,\"0.00E+00\"),\":\",TEXT(Tolere_FourC,\"0.00E+00\"),\"}\")","v":"{2:NUMERICAL:=3.24E+00:1.62E-01}"},null,null,"cm","Delta Temp",null,null,{"$f":"CONCATENATE(\"nue qu'&agrave; \",V4._FourC,\" cm pr&egrave;s.</p><p>Quelle e\")","v":"nue qu'&agrave; 2 cm pr&egrave;s.</p><p>Quelle e"}]
["Repere Var Rep","_FourC",null,null,null,null,null,{"$f":"SUM(F8:H10)","v":645.93672222222233},null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"st la temp&eacute;rature au milieu du four ? \",R2._FourC,\"</\")","v":"st la temp&eacute;rature au milieu du four ? {1:NUMERICAL:=5.84E+02:2.92E+01}</"}]
["HTML File ","FourHTML.txt",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"p><p>Quelle taille du four ? \",R1._FourC,\"</p><p>Quel est l'\")","v":"p><p>Quelle taille du four ? {2:NUMERICAL:=2.36E+01:1.18E+00}</p><p>Quel est l'"}]
["Valide ? ",{"$f":"ISNUMBER(H11)","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"incertitude sur la mesure de la temp&eacute;rature\")","v":"incertitude sur la mesure de la temp&eacute;rature"}]
["https://html-online.com/editor/ ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"&nbsp;? R&eacute;ponse : \",R3._FourC,\"</p>\")","v":"&nbsp;? R&eacute;ponse : {2:NUMERICAL:=3.24E+00:1.62E-01}</p>"}]
[null,null,6]
["Var : ","#",4]
["Res : ","$",3]
[]
[null,{"$f":"CONCATENATE(\"<p>Dans un four cylindrique sym&eacute;trique et horizontal, la temp&eacute;rature&nbsp;&Theta; est donn&eacute;e en fonction de la position x dans le four par la relation <strong>&Theta; =&nbsp;ax<sup>2</sup>\")","v":"<p>Dans un four cylindrique sym&eacute;trique et horizontal, la temp&eacute;rature&nbsp;&Theta; est donn&eacute;e en fonction de la position x dans le four par la relation <strong>&Theta; =&nbsp;ax<sup>2</sup>"},"<p>Dans un four cylindrique sym&eacute;trique et horizontal, la temp&eacute;rature&nbsp;&Theta; est donn&eacute;e en fonction de la position x dans le four par la relation <strong>&Theta; =&nbsp;ax<sup>2</sup> + bx + c</strong>, avec a=#1#, b=#2# , c=#3#, o&ugrave; &Theta; est exprim&eacute;e en &deg;C et x en cm. Une pi&egrave;ce de petites dimensions est introduite au point le plus chaud (donc au centre du four), mais sa position n'est connue qu'&agrave; #4#cm pr&egrave;s.</p>"]
[null,{"$f":"CONCATENATE(\"+ bx + c</strong>, avec a=\",V1._FourC,\", b=\",V2._FourC,\" , c=\",V3._FourC,\", o&ugrave; &Theta; est exprim&eacute;e en &deg;C et x en cm. Une pi&egrave;ce de petites dimensions est introduite au point le plus chaud (donc au centre du\")","v":"+ bx + c</strong>, avec a=-0.81, b=19.1 , c=471, o&ugrave; &Theta; est exprim&eacute;e en &deg;C et x en cm. Une pi&egrave;ce de petites dimensions est introduite au point le plus chaud (donc au centre du"},"<p>- Quelle taille du four ? $1$ cm.</p>"]
[null,{"$f":"CONCATENATE(\" four), mais sa position n'est connue qu'&agrave; \",V4._FourC,\"cm pr&egrave;s.</p><p><p>- Quelle taille du four ? \",R1._FourC,\" cm.</p><p><p>- Quelle est la temp&eacute;rature au milieu du four ? \",R2._FourC,\"&deg;C.</p><p><p>- Quelle\")","v":" four), mais sa position n'est connue qu'&agrave; 2cm pr&egrave;s.</p><p><p>- Quelle taille du four ? {2:NUMERICAL:=2.36E+01:1.18E+00} cm.</p><p><p>- Quelle est la temp&eacute;rature au milieu du four ? {1:NUMERICAL:=5.84E+02:2.92E+01}&deg;C.</p><p><p>- Quelle"},"<p>- Quelle est la temp&eacute;rature au milieu du four ? $2$&deg;C.</p>"]
[null,{"$f":"CONCATENATE(\" est l'incertitude (induite par la g&eacute;om&eacute;trie) sur la mesure de la temp&eacute;rature &nbsp;? \",R3._FourC,\"&deg;C.</p><p><p>&nbsp;</p><p>\")","v":" est l'incertitude (induite par la g&eacute;om&eacute;trie) sur la mesure de la temp&eacute;rature &nbsp;? {2:NUMERICAL:=3.24E+00:1.62E-01}&deg;C.</p><p><p>&nbsp;</p><p>"},"<p>- Quelle est l'incertitude (induite par la g&eacute;om&eacute;trie) sur la mesure de la temp&eacute;rature &nbsp;? $3$&deg;C.</p>"]
[null,{"$f":"CONCATENATE(\"\")","v":""},"<p>&nbsp;</p>"]
[null,{"$f":"CONCATENATE(\"\")","v":""}]
[null,{"$f":"CONCATENATE(\"\")","v":""},null,null,{"$f":"MAX(G26:G58)","v":11.79012345679012},{"$f":"MAX(I26:I58)","v":583.59567901234573}]
[null,{"$f":"CONCATENATE(\"\")","v":""},null,null,null,null,{"$f":"IF(I26=$F$25,H26,0)","v":0},0,{"$f":"V1._FourC*H26*H26+V2._FourC*H26+V3._FourC","v":471}]
[null,null,null,null,null,null,0,{"$f":"H26+$L$1/15","v":0.78600823045267487},485.5123319615912]
[null,null,null,null,null,null,0,1.5720164609053497,499.0238134430727]
[null,null,null,null,null,null,0,2.3580246913580245,511.53444444444443]
[null,null,null,null,null,null,0,3.1440329218106995,523.04422496570646]
[null,null,null,null,null,null,0,3.9300411522633745,533.55315500685867]
[null,null,null,null,null,null,0,4.716049382716049,543.06123456790124]
[null,null,null,null,null,null,0,5.5020576131687235,551.56846364883404]
[null,null,null,null,null,null,0,6.2880658436213981,559.07484224965708]
[null,null,null,null,null,null,0,7.0740740740740726,565.58037037037036]
[null,null,null,null,null,null,0,7.8600823045267472,571.08504801097388]
[null,null,null,null,null,null,0,8.6460905349794217,575.58887517146775]
[null,null,null,null,null,null,0,9.4320987654320962,579.09185185185186]
[null,null,null,null,null,null,0,10.218106995884771,581.5939780521262]
[null,null,null,null,null,null,0,11.004115226337445,583.09525377229079]
[null,null,null,null,null,null,11.79012345679012,11.79012345679012,583.59567901234573]
[null,null,null,null,null,null,0,12.576131687242794,583.09525377229079]
[null,null,null,null,null,null,0,13.362139917695469,581.5939780521262]
[null,null,null,null,null,null,0,14.148148148148143,579.09185185185186]
[null,null,null,null,null,null,0,14.934156378600818,575.58887517146786]
[null,null,null,null,null,null,0,15.720164609053493,571.08504801097399]
[null,null,null,null,null,null,0,16.506172839506167,565.58037037037047]
[null,null,null,null,null,null,0,17.292181069958843,559.07484224965708]
[null,null,null,null,null,null,0,18.07818930041152,551.56846364883404]
[null,null,null,null,null,null,0,18.864197530864196,543.06123456790124]
[null,null,null,null,null,null,0,19.650205761316872,533.55315500685867]
[null,null,null,null,null,null,0,20.436213991769549,523.04422496570646]
[null,null,null,null,null,null,0,21.222222222222225,511.53444444444438]
[null,null,null,null,null,null,0,22.008230452674901,499.02381344307264]
[null,null,null,null,null,null,0,22.794238683127578,485.51233196159114]
[null,null,null,null,null,null,0,23.580246913580254,470.99999999999983]
[null,null,null,null,null,null,0,24.36625514403293,455.48681755829887]
[null,null,null,null,null,null,0,25.152263374485607,438.97278463648814]

{"sheet":"Mobile-VQEc","index":12,"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":527},"m",{"$f":"V1.distance_VQE*(1+V3.Deltad_VQE/100)","v":606.04999999999995},{"$f":"V1.distance_VQE*(1-V3.Deltad_VQE/100)","v":447.95},{"$f":"AVERAGE(K2,L2)","v":527},{"$f":"(K2-L2)/2","v":79.049999999999983},{"$f":"N2/M2","v":0.14999999999999997}]
["Tag_VQE","Mobile-VQEc_VQE","    <question type=\"cloze\">",null,"V2.temps_VQE",{"$f":"V1.distance_VQE/10","v":52.7},{"$f":"V1.distance_VQE/2","v":263.5},0,97,"s",{"$f":"V2.temps_VQE*(1+V4.Deltat_VQE/100)","v":100.88000000000001},{"$f":"V2.temps_VQE*(1-V4.Deltat_VQE/100)","v":93.11999999999999},{"$f":"AVERAGE(K3,L3)","v":97},{"$f":"(K3-L3)/2","v":3.8800000000000097},{"$f":"N3/M3","v":4.0000000000000098E-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-210812.04"},{"$f":"CONCATENATE(\"        <name><text>\", titre_VQE, \"</text></name>\")","v":"        <name><text>Mobile-VQEc_VQE</text></name>"},null,"V3.Deltad_VQE",{"$f":"G4/2","v":11.04},{"$f":"1+V1.distance_VQE/25","v":22.08},0,15,"%"]
["points_VQE",1,"        <questiontext format=\"html\">",null,"V4.Deltat_VQE",{"$f":"G5/3","v":1.95},{"$f":"1+V2.temps_VQE/20","v":5.85},0,4,"%"]
["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 = 527m <p>parcourue durant un intervalle de temps t : 97s. Les incertitudes sont<p>suppos&eacute;es ind&eacute;pendantes (de 15% et 4% respectivement).<p>Calculez les valeurs maximum Vmax={1:NUMERICAL:=6.51E+00:3.25E-01}m/s et minimum Vmin={1:NUMERICAL:=4.44E+00:2.22E-01}m/s de la vitesse, la vitess la plus probable {1:NUMERICAL:=5.43E+00:2.72E-01}m/s et son incertitude{2:NUMERICAL:=1.03E+00:5.16E-02}m/s.<p>Si la masse du mobile est m=77 +/- 11 kg, on peut en d&eacute;terminer la quantit&eacute; de mouvement p=mv = {1:NUMERICAL:=4.18E+02:2.09E+01} +/- {2:NUMERICAL:=1.39E+02:6.96E+00} kg.ms-1.<p>et son &eacute;nergie cin&eacute;tique: Ec=1/2 mv<sup>2</sup> =  {1:NUMERICAL:=1.14E+03:5.68E+01} +/- {2:NUMERICAL:=5.94E+02:2.97E+01} J.<p></p>]]></text>"},null,"V5.masse_VQE",10,100,0,77,"kg"]
["penalité_VQE",0.1,"        </questiontext>",null,"V6.Deltam_VQE",{"$f":"ROUND(V5.masse_VQE/10,0)","v":8},{"$f":"V5.masse_VQE/7","v":11},0,11,"kg",null,null,null,"V",{"$f":"M2/M3","v":5.4329896907216497},"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.19000000000000006}]
["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-210812.04</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.14285714285714285}]
["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 = 527m <p>parcourue durant un intervalle de temps t : 97s. Les incertitudes sont<p>suppos&eacute;es ind&eacute;pendantes (de 15% et 4% respectivement).<p>Calculez les valeurs maximum Vmax={1:NUMERICAL:=6.51E+00:3.25E-01}m/s et minimum Vmin={1:NUMERICAL:=4.44E+00:2.22E-01}m/s de la vitesse, la vitess la plus probable {1:NUMERICAL:=5.43E+00:2.72E-01}m/s et son incertitude{2:NUMERICAL:=1.03E+00:5.16E-02}m/s.<p>Si la masse du mobile est m=77 +/- 11 kg, on peut en d&eacute;terminer la quantit&eacute; de mouvement p=mv = {1:NUMERICAL:=4.18E+02:2.09E+01} +/- {2:NUMERICAL:=1.39E+02:6.96E+00} kg.ms-1.<p>et son &eacute;nergie cin&eacute;tique: Ec=1/2 mv<sup>2</sup> =  {1:NUMERICAL:=1.14E+03:5.68E+01} +/- {2:NUMERICAL:=5.94E+02:2.97E+01} J.<p>"},"    </question>",null,"R1.Vmax_VQE",{"$f":"K2/L3","v":6.5082689003436425},{"$f":" tolerance_VQE*ValMini_VQE","v":0.32541344501718217},1,{"$f":"CONCATENATE(\"{\",PointsQuestion_VQE,\":NUMERICAL:=\",TEXT(Cible_VQE,\"0.00E+00\"),\":\",TEXT(ABS(Tolere_VQE),\"0.00E+00\"),\"}\")","v":"{1:NUMERICAL:=6.51E+00:3.25E-01}"}]
["Repere Var Rep","_VQE",null,null,"R2.Vmin_VQE",{"$f":"L2/K3","v":4.4404242664551941},0.2220212133227597,1,"{1:NUMERICAL:=4.44E+00:2.22E-01}",null,null,null,null,"Delta Q",{"$f":"F15/F14","v":0.33285714285714291}]
["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":5.4329896907216497},0.27164948453608251,1,"{1:NUMERICAL:=5.43E+00:2.72E-01}",null,null,null,null,"Delta Ec",{"$f":"F17/F16","v":0.52285714285714291}]
["Valide ? ",{"$f":"AND(ISNUMBER(P32),P30<50)","v":true},null,null,"R4.DeltaVmoy_VQE",{"$f":"F12*DV","v":1.0322680412371137},5.161340206185569E-2,2,"{2:NUMERICAL:=1.03E+00:5.16E-02}"]
["https://html-online.com/editor/ ",null,null,null,"R5.QuMouv_VQE",{"$f":"Vmoy*V5.masse_VQE","v":418.34020618556701},20.917010309278353,1,"{1:NUMERICAL:=4.18E+02:2.09E+01}"]
[null,null,8,null,"R6.DeltaQ_VQE",{"$f":"F14*(DV+DM)","v":139.24752577319589},6.9623762886597946,2,"{2:NUMERICAL:=1.39E+02:6.96E+00}"]
["Var : ","#",6,null,"R7.EnergCin_VQE",{"$f":"0.5*V5.masse_VQE*Vmoy^2","v":1136.4190137102776},56.820950685513878,1,"{1:NUMERICAL:=1.14E+03:5.68E+01}"]
["Res : ","$",8,null,"R8.DeltaEc_VQE",{"$f":"F16*(DM+2*DV)","v":594.18479859708805},29.709239929854405,2,"{2:NUMERICAL:=5.94E+02:2.97E+01}"]
[]
[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 = 527m <p>parcourue durant un intervalle de temps t : 97s. Les incertitudes sont<p>suppos&eacute;es ind&eacute;pendantes (de 15% et 4% 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:=6.51E+00:3.25E-01}m/s et minimum Vmin={1:NUMERICAL:=4.44E+00:2.22E-01}m/s de la vitesse, la vitess la plus probable {1:NUMERICAL:=5.43E+00:2.72E-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:=1.03E+00:5.16E-02}m/s.<p>Si la masse du mobile est m=77 +/- 11 kg, on peut en d&eacute;terminer la quantit&eacute; de mouvement p=mv = {1:NUMERICAL:=4.18E+02:2.09E+01} +/- {2:NUMERICAL:=1.39E+02:6.96E+00} kg.ms-1.<p>et son &eacute;nergie cin&eacute;tique: Ec=1/2 mv<sup>2</sup> =  {1:NUMERICAL:=1.14E+03:5.68E+01} +/- {2:NUMERICAL:=5.94E+02:2.97E+01} 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":527},{"$f":"V3.Deltad_VQE","v":15},{"$f":"O25*100/N25","v":2.8462998102466792}]
[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":97},{"$f":"V4.Deltat_VQE","v":4},{"$f":"O26*100/N26","v":4.1237113402061851}]
[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":77},{"$f":"V6.Deltam_VQE","v":11},{"$f":"O27*100/N27","v":14.285714285714286}]
[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":5.4329896907216497},{"$f":"N28*P28/100","v":0.37867998724625351},{"$f":"P26+P25","v":6.9700111504528639}]
[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":418.34020618556701},{"$f":"P29*N29/100","v":77.014029121054307},{"$f":"P27+P26","v":18.40942562592047}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ec",{"$f":"0.5*N27*(N25/N26)^2","v":1136.4190137102776},{"$f":"P30*N30/100","v":320.76263733012814},{"$f":"P27+2*P28","v":28.225736586620016}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M25:P30)","v":2764.2084548241555}]

{"sheet":"ExpFonctions","index":13,"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.6},{"$f":" 1/POWER(10,LEN(I2)-LEN(INT(I2))-(I2<>INT(I2))*1)","v":0.1},"ln",{"$f":"J2/V1._Fon","v":0.16666666666666669},{"$f":"LN(V1._Fon+J2)","v":-0.35667494393873245},{"$f":"LN(V1._Fon-J2)","v":-0.69314718055994529},{"$f":"ABS(M2-N2)/2","v":0.16823611831060642}]
["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":59},{"$f":" 1/POWER(10,LEN(I3)-LEN(INT(I3))-(I3<>INT(I3))*1)","v":1},"cos",{"$f":"J3/V2._Fon","v":1.6949152542372881E-2},{"$f":"COS(RADIANS((V2._Fon+J3)))","v":0.50000000000000011},{"$f":"COS(RADIANS((V2._Fon-J3)))","v":0.5299192642332049},{"$f":"ABS(M3-N3)/2","v":1.4959632116602395E-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,"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-210812.04"},{"$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":45.5},{"$f":" 1/POWER(10,LEN(I4)-LEN(INT(I4))-(I4<>INT(I4))*1)","v":0.1},"sin",{"$f":"J4/V3._Fon","v":2.1978021978021978E-3},{"$f":"SIN(RADIANS((V3._Fon+J4)))","v":0.71447267963280336},{"$f":"SIN(RADIANS((V3._Fon-J4)))","v":0.7120260459909965},{"$f":"ABS(M4-N4)/2","v":1.2233168209034306E-3}]
["points_Fon",1,"        <questiontext format=\"html\">",null,"V4._Fon",-1,2,-2,{"$f":"IF(I6=0,RANDBETWEEN(0.1,0.77),I6)","v":0.78},{"$f":" 1/POWER(10,LEN(I5)-LEN(INT(I5))-(I5<>INT(I5))*1)","v":0.01},"exp",{"$f":"J5/V4._Fon","v":1.282051282051282E-2},{"$f":"EXP(V4._Fon+J5)","v":2.2033964262559369},{"$f":"EXP(V4._Fon-J5)","v":2.1597662537849152},{"$f":"ABS(M5-N5)/2","v":2.1815086235510872E-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.6) = {1:NUMERICAL:=-5.11E-01:2.55E-02} +/- {1:NUMERICAL:=1.67E-01:8.33E-03} <p>cos(59) = {1:NUMERICAL:=5.15E-01:2.58E-02} +/- {2:NUMERICAL:=1.50E-02:7.48E-04} <p>sin(45.5) = {1:NUMERICAL:=7.13E-01:3.57E-02} +/- {2:NUMERICAL:=1.22E-03:6.12E-05} <p>exp(0.78) = {1:NUMERICAL:=2.18E+00:1.09E-01} +/- {2:NUMERICAL:=2.18E-02:1.09E-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":0.78}]
["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":-0.51082562376599072},{"$f":" tolerance_Fon*ValMini_Fon","v":-2.5541281188299538E-2},1,{"$f":"CONCATENATE(\"{\",PointsQuestion_Fon,\":NUMERICAL:=\",TEXT(Cible_Fon,\"0.00E+00\"),\":\",TEXT(ABS(Tolere_Fon),\"0.00E+00\"),\"}\")","v":"{1:NUMERICAL:=-5.11E-01:2.55E-02}"},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-210812.04</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.4167098636384044E-3}]
["question format HTML_Fon",{"$f":"CONCATENATE(\" \",B19,B20)","v":" Exprimer correctement les resultats suivants : <p>ln(0.6) = {1:NUMERICAL:=-5.11E-01:2.55E-02} +/- {1:NUMERICAL:=1.67E-01:8.33E-03} <p>cos(59) = {1:NUMERICAL:=5.15E-01:2.58E-02} +/- {2:NUMERICAL:=1.50E-02:7.48E-04} <p>sin(45.5) = {1:NUMERICAL:=7.13E-01:3.57E-02} +/- {2:NUMERICAL:=1.22E-03:6.12E-05} <p>exp(0.78) = {1:NUMERICAL:=2.18E+00:1.09E-01} +/- {2:NUMERICAL:=2.18E-02:1.09E-03} <p>"},"    </question>",null,"R3._Fon",{"$f":"COS(RADIANS(V2._Fon))","v":0.51503807491005416},2.5751903745502708E-2,1,"{1:NUMERICAL:=5.15E-01:2.58E-02}",null,"cos"]
["Repere Var Rep","_Fon",null,null,"R4._Fon",{"$f":"ABS(SIN(RADIANS(V2._Fon)))*RADIANS(J3)","v":1.4960391637684162E-2},7.4801958188420818E-4,2,"{2:NUMERICAL:=1.50E-02:7.48E-04}",null,"D cos",{"$f":"F11","v":1.4960391637684162E-2},null,null,{"$f":"ABS((ABS(O3)-ABS(L11))/ABS(L11))","v":5.0768796710796998E-5}]
["HTML File ",{"$f":"CONCATENATE(categorie_Fon,\"_HTML.txt\")","v":"ExpFonctions_HTML.txt"},null,null,"R5._Fon",{"$f":"SIN(RADIANS(V3._Fon))","v":0.71325044915418156},3.5662522457709081E-2,1,"{1:NUMERICAL:=7.13E-01:3.57E-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.2233174419763546E-3},6.1165872098817737E-5,2,"{2:NUMERICAL:=1.22E-03:6.12E-05}",null,"D sin",{"$f":"F13","v":1.2233174419763546E-3},null,null,{"$f":"ABS((O4-L13)/L13)","v":5.0769563375889362E-7}]
["https://html-online.com/editor/",null,null,null,"R7._Fon",{"$f":"EXP(V4._Fon)","v":2.1814722654982011},0.10907361327491005,1,"{1:NUMERICAL:=2.18E+00:1.09E-01}",null,"exp"]
[null,null,6,null,"R8._Fon",{"$f":"ABS(EXP(V4._Fon))*J5","v":2.1814722654982011E-2},1.0907361327491007E-3,2,"{2:NUMERICAL:=2.18E-02:1.09E-03}",null,"D exp",{"$f":"F15","v":2.1814722654982011E-2},null,null,{"$f":"ABS((O5-L15)/L15)","v":1.6666750002334424E-5}]
["Var : ","#",4,null,null,null,null,null,null,null,null,{"$f":"SUM(L2:L15)","v":0.4032992326286638},"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.6) = {1:NUMERICAL:=-5.11E-01:2.55E-02} +/- {1:NUMERICAL:=1.67E-01:8.33E-03} <p>cos(59) = {1:NUMERICAL:=5.15E-01:2.58E-02} +/- {2:NUMERICAL:=1.50E-02:7.48E-04} <p>sin(45.5) = {1:NUMERICAL:=7.13E-01:3.57E-02} +/- {2:NUMERICAL:=1.22E-03:6.12E-05} <p>exp(0.78) = {1:NUMERICAL:=2.18E+00:1.09E-01} +/- {2:NUMERICAL:=2.18E-02:1.09E-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>"]

{"sheet":"Somme-Fraction","index":14,"n_rows":19,"n_cols":79,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["catégorie_Fra","Somme-Fraction_Fra",{"$f":"CONCATENATE(\"    <!--  question XLQ \", titre_Fra, \"-->\")","v":"    <!--  question XLQ Somme-Fraction_Fra-->"},null,null,"Valeur Mini_Fra","Valeur Maxi_Fra","Sig. Digit_Fra","Val Choix_Fra","Least significant",null,"rel","somme rel","total","moy","min","max","ratio max","ratio min","Delta"]
[null,"Somme-Fraction_Fra",{"$f":"CONCATENATE(\"    <question type=\",CHAR(34),\"category\",CHAR(34),\"><category><text>\", categorie_Fra,\"</text></category></question>)\")","v":"    <question type=\"category\"><category><text>Somme-Fraction_Fra</text></category></question>)"},null,"V1._Fra",2,13,-1,{"$f":"RANDBETWEEN(ValMini_Fra*10^-SigDig_Fra, ValMaxi_Fra*10^-SigDig_Fra)/10^-SigDig_Fra","v":9},{"$f":" 1/POWER(10,LEN(I2)-LEN(INT(I2))-(I2<>INT(I2))*1)","v":1},null,{"$f":"LeastSign/V1._Fra","v":0.1111111111111111},{"$f":"L2+L3","v":0.1267361111111111},null,{"$f":"V1._Fra/V2._Fra","v":1.40625},{"$f":"V1._Fra+J2","v":10},{"$f":"V1._Fra-J2","v":8},{"$f":"P2/Q3","v":1.5873015873015872},{"$f":"Q2/P3","v":1.2307692307692308},{"$f":"(R2-S2)/2","v":0.17826617826617819},{"$f":"T2*M2","v":2.2592762176095498E-2}]
["Tag_Fra","Somme-Fraction_Fra","    <question type=\"cloze\">",null,"V2._Fra",2,13,-1,{"$f":"RANDBETWEEN(ValMini_Fra*10^-SigDig_Fra, ValMaxi_Fra*10^-SigDig_Fra)/10^-SigDig_Fra","v":6.4},{"$f":" 1/POWER(10,LEN(I3)-LEN(INT(I3))-(I3<>INT(I3))*1)","v":0.1},null,{"$f":"LeastSign/V2._Fra","v":1.5625E-2},null,null,null,{"$f":"V2._Fra+J3","v":6.5},{"$f":"V2._Fra-J3","v":6.3000000000000007},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculer : #1#/#2# + #3#/#4# = $1$ +/- $2$<p>"]
["idnumber_Fra",{"$f":"TEXT(NOW(),\"aammjj-hhmmss.00\")","v":"210710-210812.04"},{"$f":"CONCATENATE(\"        <name><text>\", titre_Fra, \"</text></name>\")","v":"        <name><text>Somme-Fraction_Fra</text></name>"},null,"V3._Fra",2,13,-1,{"$f":"RANDBETWEEN(ValMini_Fra*10^-SigDig_Fra, ValMaxi_Fra*10^-SigDig_Fra)/10^-SigDig_Fra","v":10.3},{"$f":" 1/POWER(10,LEN(I4)-LEN(INT(I4))-(I4<>INT(I4))*1)","v":0.1},null,{"$f":"LeastSign/V3._Fra","v":9.7087378640776691E-3},{"$f":"L4+L5","v":2.5837770122142185E-2},null,{"$f":"V3._Fra/V4._Fra","v":1.6612903225806452},{"$f":"V3._Fra+J4","v":10.4},{"$f":"V3._Fra-J4","v":10.200000000000001},{"$f":"P4/Q5","v":1.7049180327868851},{"$f":"Q4/P5","v":1.6190476190476193},{"$f":"(R4-S4)/2","v":4.2935206869632925E-2},{"$f":"T4*M4","v":1.1093500052441955E-3}]
["points_Fra",1,"        <questiontext format=\"html\">",null,"V4._Fra",2,13,-1,{"$f":"RANDBETWEEN(ValMini_Fra*10^-SigDig_Fra, ValMaxi_Fra*10^-SigDig_Fra)/10^-SigDig_Fra","v":6.2},{"$f":" 1/POWER(10,LEN(I5)-LEN(INT(I5))-(I5<>INT(I5))*1)","v":0.1},null,{"$f":"LeastSign/V4._Fra","v":1.6129032258064516E-2},null,null,null,{"$f":"V4._Fra+J5","v":6.3},{"$f":"V4._Fra-J5","v":6.1000000000000005}]
["tolérance_Fra",0.05,{"$f":"CONCATENATE(\"            <text><![CDATA[<p>\", question_Fra, \"</p>]]></text>\")","v":"            <text><![CDATA[<p> Calculer : 9/6.4 + 10.3/6.2 = {1:NUMERICAL:=3.07E+00:1.53E-01} +/- {2:NUMERICAL:=7.27E-02:3.64E-03}<p></p>]]></text>"}]
["penalité_Fra",0.1,"        </questiontext>",null,null,"Cible_Fra","Toler_Fra","PointsQuestion_Fra",null,null,null,null,null,null,null,null,null,null,null,"Erreur ",{"$f":"SUM(U2:U4)","v":2.3702112181339694E-2}]
["feedback_Fra","_",{"$f":"CONCATENATE(\"        <defaultgrade>\",points_Fra,\"</defaultgrade><generalfeedback><text>\",feedback_Fra,\"</text></generalfeedback><penalty>\",penalty_Fra,\"</penalty><hidden>0</hidden>)\")","v":"        <defaultgrade>1</defaultgrade><generalfeedback><text>_</text></generalfeedback><penalty>0.1</penalty><hidden>0</hidden>)"},null,"R1._Fra",{"$f":"V1._Fra/V2._Fra+V3._Fra/V4._Fra","v":3.067540322580645},{"$f":" tolerance_Fra*ValMini_Fra","v":0.15337701612903226},1,{"$f":"CONCATENATE(\"{\",PointsQuestion_Fra,\":NUMERICAL:=\",TEXT(Cible_Fra,\"0.00E+00\"),\":\",TEXT(ABS(Tolere_Fra),\"0.00E+00\"),\"}\")","v":"{1:NUMERICAL:=3.07E+00:1.53E-01}"}]
["Cellule vides_Fra",{"$f":"COUNTBLANK(B1:B8)","v":0},{"$f":"CONCATENATE(\"        <idnumber>\",idnumber_Fra,\"</idnumber><tags><tag><text>\",Tag_Fra,\"</text></tag></tags>\")","v":"        <idnumber>210710-210812.04</idnumber><tags><tag><text>Somme-Fraction_Fra</text></tag></tags>"},null,"R2._Fra",{"$f":"F8*U7","v":7.2707184846589404E-2},{"$f":" tolerance_Fra*ValMini_Fra","v":3.6353592423294702E-3},2,{"$f":"CONCATENATE(\"{\",PointsQuestion_Fra,\":NUMERICAL:=\",TEXT(Cible_Fra,\"0.00E+00\"),\":\",TEXT(ABS(Tolere_Fra),\"0.00E+00\"),\"}\")","v":"{2:NUMERICAL:=7.27E-02:3.64E-03}"},null,null,{"$f":"SUM(L2:U5)","v":73.55962805226963}]
["question format HTML_Fra",{"$f":"CONCATENATE(\" \",B19)","v":" Calculer : 9/6.4 + 10.3/6.2 = {1:NUMERICAL:=3.07E+00:1.53E-01} +/- {2:NUMERICAL:=7.27E-02:3.64E-03}<p>"},"    </question>"]
["Repere Var Rep","_Fra"]
["HTML File ",{"$f":"CONCATENATE(categorie_Fra,\"_HTML.txt\")","v":"Somme-Fraction_Fra_HTML.txt"}]
["Valide ? ",{"$f":"ISNUMBER(L9)","v":true}]
["https://html-online.com/editor/"]
[null,null,6]
["Var : ","#",4]
["Res : ","$",2]
[]
[null,{"$f":"CONCATENATE(\"Calculer : \",V1._Fra,\"/\",V2._Fra,\" + \",V3._Fra,\"/\",V4._Fra,\" = \",R1._Fra,\" +/- \",R2._Fra,\"<p>\")","v":"Calculer : 9/6.4 + 10.3/6.2 = {1:NUMERICAL:=3.07E+00:1.53E-01} +/- {2:NUMERICAL:=7.27E-02:3.64E-03}<p>"},"Calculer : #1#/#2# + #3#/#4# = $1$ +/- $2$"]

{"sheet":"Ohms","index":15,"n_rows":24,"n_cols":79,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["catégorie_Ohm","Ohms_Ohm",{"$f":"CONCATENATE(\"    <!--  question XLQ \", titre_Ohm, \"-->\")","v":"    <!--  question XLQ Ohms_Ohm-->"},null,null,"Valeur Mini_Ohm","Valeur Maxi_Ohm","Sig. Digit_Ohm","Val Choix_Ohm"]
[null,"Ohms_Ohm",{"$f":"CONCATENATE(\"    <question type=\",CHAR(34),\"category\",CHAR(34),\"><category><text>\", categorie_Ohm,\"</text></category></question>)\")","v":"    <question type=\"category\"><category><text>Ohms_Ohm</text></category></question>)"},null,"V1.I_Ohm",12,53,-1,{"$f":"RANDBETWEEN(ValMini_Ohm*10^-SigDig_Ohm, ValMaxi_Ohm*10^-SigDig_Ohm)/10^-SigDig_Ohm","v":23.5},"mA","Di/i","DR/R"]
["Tag_Ohm","Ohms_Ohm","    <question type=\"cloze\">",null,"V2.DI_Ohm",{"$f":"V1.I_Ohm/20","v":1.175},{"$f":"F3*3","v":3.5250000000000004},-1,{"$f":"RANDBETWEEN(ValMini_Ohm*10^-SigDig_Ohm, ValMaxi_Ohm*10^-SigDig_Ohm)/10^-SigDig_Ohm","v":1.5},"D mA",{"$f":"V2.DI_Ohm/V1.I_Ohm","v":6.3829787234042548E-2},{"$f":"K3+K5","v":0.22662048490846115},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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>&nbsp;On &eacute;tudie une chute ohmique aux bornes d'une r&eacute;sistance. Le mesurage du courant traversant la<br />r&eacute;sistance et la tension aux bornes de celle-ci conduit &agrave; I = #1# +/- #2#mA et U = #3# +/- #4#V . Les incertitudes<br />sont ind&eacute;pendantes.<br />1. Calculez la valeur de la r&eacute;sistance R = $1$ +/- $2$ Ohms <br />2. Calculez la puissance (P = UI) dissip&eacute;e dans la r&eacute;sistance P = $3$ +/- $4$ W <br />3. Calculer P &agrave; partir de la relation P = RI =&gt; Delta P = $5$ +/- $6$ W</p>"]
["idnumber_Ohm",{"$f":"TEXT(NOW(),\"aammjj-hhmmss.00\")","v":"210710-210812.04"},{"$f":"CONCATENATE(\"        <name><text>\", titre_Ohm, \"</text></name>\")","v":"        <name><text>Ohms_Ohm</text></name>"},null,"V3.V_Ohm",20,53,-1,{"$f":"RANDBETWEEN(ValMini_Ohm*10^-SigDig_Ohm, ValMaxi_Ohm*10^-SigDig_Ohm)/10^-SigDig_Ohm","v":21.5},"V","DV/V","Dpu/Pu"]
["points_Ohm",1,"        <questiontext format=\"html\">",null,"V4.DV_Ohm",{"$f":"V1.I_Ohm/20","v":1.175},{"$f":"F5*3","v":3.5250000000000004},-1,{"$f":"RANDBETWEEN(ValMini_Ohm*10^-SigDig_Ohm, ValMaxi_Ohm*10^-SigDig_Ohm)/10^-SigDig_Ohm","v":3.5},"D  V",{"$f":"V4.DV_Ohm/V3.V_Ohm","v":0.16279069767441862},{"$f":"L3+K3","v":0.29045027214250368}]
["tolérance_Ohm",0.05,{"$f":"CONCATENATE(\"            <text><![CDATA[<p>\", question_Ohm, \"</p>]]></text>\")","v":"            <text><![CDATA[<p> <p>&nbsp;On &eacute;tudie une chute ohmique aux bornes d'une r&eacute;sistance. Le mesurage du courant traversant la<br />r&eacute;sistance et la tension aux bornes de celle-ci conduit &agrave; I = 23.5+/- 1.5mA et U = 21.5 +/- 3.5V . Les incertitudes<br />sont ind&eacute;pendantes.<br />1. Calculez la valeur de la r&eacute;sistance R = {1:NUMERICAL:=9.15E-01:4.57E-02} +/- {1:NUMERICAL:=2.07E-01:1.04E-02} Ohms <br />2. Calculez la puissance (P = UI) dissip&eacute;edans la r&eacute;sistance P = {1:NUMERICAL:=5.05E+02:2.53E+01} +/- {1:NUMERICAL:=1.15E+02:5.73E+00} W <br />3. Calculer P &agrave; partir de la relation P = RI<sup>2</sup> =&gt; Delta P = {1:NUMERICAL:=5.05E+02:2.53E+01} +/- {2:NUMERICAL:=1.47E+02:7.34E+00} W</p></p>]]></text>"}]
["penalité_Ohm",0.1,"        </questiontext>",null,null,"Cible_Ohm","Toler_Ohm","PointsQuestion_Ohm"]
["feedback_Ohm","_",{"$f":"CONCATENATE(\"        <defaultgrade>\",points_Ohm,\"</defaultgrade><generalfeedback><text>\",feedback_Ohm,\"</text></generalfeedback><penalty>\",penalty_Ohm,\"</penalty><hidden>0</hidden>)\")","v":"        <defaultgrade>1</defaultgrade><generalfeedback><text>_</text></generalfeedback><penalty>0.1</penalty><hidden>0</hidden>)"},null,"R1.R_Ohm",{"$f":"V3.V_Ohm/V1.I_Ohm","v":0.91489361702127658},{"$f":" tolerance_Ohm*ValMini_Ohm","v":4.5744680851063833E-2},1,{"$f":"CONCATENATE(\"{\",PointsQuestion_Ohm,\":NUMERICAL:=\",TEXT(Cible_Ohm,\"0.00E+00\"),\":\",TEXT(ABS(Tolere_Ohm),\"0.00E+00\"),\"}\")","v":"{1:NUMERICAL:=9.15E-01:4.57E-02}"},"Ohm","R = U/i"]
["Cellule vides_Ohm",{"$f":"COUNTBLANK(B1:B8)","v":0},{"$f":"CONCATENATE(\"        <idnumber>\",idnumber_Ohm,\"</idnumber><tags><tag><text>\",Tag_Ohm,\"</text></tag></tags>\")","v":"        <idnumber>210710-210812.04</idnumber><tags><tag><text>Ohms_Ohm</text></tag></tags>"},null,"R2.DR_Ohm",{"$f":"L3*F8","v":0.20733363512901765},1.0366681756450884E-2,1,"{1:NUMERICAL:=2.07E-01:1.04E-02}","Ohm"]
["question format HTML_Ohm",{"$f":"CONCATENATE(\" \",B19,B20,B21,B22,B23,B24)","v":" <p>&nbsp;On &eacute;tudie une chute ohmique aux bornes d'une r&eacute;sistance. Le mesurage du courant traversant la<br />r&eacute;sistance et la tension aux bornes de celle-ci conduit &agrave; I = 23.5+/- 1.5mA et U = 21.5 +/- 3.5V . Les incertitudes<br />sont ind&eacute;pendantes.<br />1. Calculez la valeur de la r&eacute;sistance R = {1:NUMERICAL:=9.15E-01:4.57E-02} +/- {1:NUMERICAL:=2.07E-01:1.04E-02} Ohms <br />2. Calculez la puissance (P = UI) dissip&eacute;edans la r&eacute;sistance P = {1:NUMERICAL:=5.05E+02:2.53E+01} +/- {1:NUMERICAL:=1.15E+02:5.73E+00} W <br />3. Calculer P &agrave; partir de la relation P = RI<sup>2</sup> =&gt; Delta P = {1:NUMERICAL:=5.05E+02:2.53E+01} +/- {2:NUMERICAL:=1.47E+02:7.34E+00} W</p>"},"    </question>",null,"R3.P_Ohm",{"$f":"V1.I_Ohm*V3.V_Ohm","v":505.25},25.262500000000003,1,"{1:NUMERICAL:=5.05E+02:2.53E+01}","W","P=Ui"]
["Repere Var Rep","_Ohm",null,null,"R4.DP_Ohm",{"$f":"F10*L3","v":114.5},5.7250000000000005,1,"{1:NUMERICAL:=1.15E+02:5.73E+00}","W"]
["HTML File ","sansaccent.txt",null,null,"R5.Pui_Ohm",{"$f":"F10","v":505.25},25.262500000000003,1,"{1:NUMERICAL:=5.05E+02:2.53E+01}","W","P=Ri"]
["Valide ? ",{"$f":"ISNUMBER(H15)","v":true},null,null,"R6.DPui_Ohm",{"$f":"F12*L5","v":146.75},7.3375000000000004,2,"{2:NUMERICAL:=1.47E+02:7.34E+00}","W"]
["https://html-online.com/editor/"]
[null,null,6,null,null,null,null,{"$f":"SUM(F8:H13)","v":1343.515838614758}]
["Var : ","#",4]
["Res : ","$",6]
[]
[null,{"$f":"CONCATENATE(\"<p>&nbsp;On &eacute;tudie une chute ohmique aux bornes d'une r&eacute;sistance. Le mesurage du courant traversant la<br />r&eacute;sistance et la tension aux bornes de celle-ci conduit &agrave; I = \",V1.I_Ohm,\"\")","v":"<p>&nbsp;On &eacute;tudie une chute ohmique aux bornes d'une r&eacute;sistance. Le mesurage du courant traversant la<br />r&eacute;sistance et la tension aux bornes de celle-ci conduit &agrave; I = 23.5"},"<p>&nbsp;On &eacute;tudie une chute ohmique aux bornes d'une r&eacute;sistance. Le mesurage du courant traversant la<br />r&eacute;sistance et la tension aux bornes de celle-ci conduit &agrave; I = #1# +/- #2#mA et U = #3# +/- #4#V . Les incertitudes<br />sont ind&eacute;pendantes.<br />1. Calculez la valeur de la r&eacute;sistance R = $1$ +/- $2$ Ohms <br />2. Calculez la puissance (P = UI) dissip&eacute;e dans la r&eacute;sistance P = $3$ +/- $4$ W <br />3. Calculer P &agrave; partir de la relation P = RI =&gt; Delta P = $5$ +/- $6$ W</p>"]
[null,{"$f":"CONCATENATE(\"+/- \",V2.DI_Ohm,\"mA et U = \",V3.V_Ohm,\" +/- \",V4.DV_Ohm,\"V . Les incertitudes<br />sont ind&eacute;pendantes.<br />1. Calculez la valeur de la r&eacute;sistance R = \",R1.R_Ohm,\" +/- \",R2.DR_Ohm,\" Ohms <br />2. Calculez la puissance (P = UI) dissip&eacute;e\")","v":"+/- 1.5mA et U = 21.5 +/- 3.5V . Les incertitudes<br />sont ind&eacute;pendantes.<br />1. Calculez la valeur de la r&eacute;sistance R = {1:NUMERICAL:=9.15E-01:4.57E-02} +/- {1:NUMERICAL:=2.07E-01:1.04E-02} Ohms <br />2. Calculez la puissance (P = UI) dissip&eacute;e"},"résistance et la tension aux bornes de celle-ci conduit à I = #1# +/- #2#mA et U = #3# +/- #4#V . Les incertitudes"]
[null,{"$f":"CONCATENATE(\"dans la r&eacute;sistance P = \",R3.P_Ohm,\" +/- \",R4.DP_Ohm,\" W <br />3. Calculer P &agrave; partir de la relation P = RI<sup>2</sup> =&gt; Delta P = \",R5.Pui_Ohm,\" +/- \",R6.DPui_Ohm,\" W</p>\")","v":"dans la r&eacute;sistance P = {1:NUMERICAL:=5.05E+02:2.53E+01} +/- {1:NUMERICAL:=1.15E+02:5.73E+00} W <br />3. Calculer P &agrave; partir de la relation P = RI<sup>2</sup> =&gt; Delta P = {1:NUMERICAL:=5.05E+02:2.53E+01} +/- {2:NUMERICAL:=1.47E+02:7.34E+00} W</p>"},"sont indépendantes."]
[null,{"$f":"CONCATENATE(\"\")","v":""},"1. Calculez la valeur de la résistance R = $1$ +/- $2$ Ohms "]
[null,{"$f":"CONCATENATE(\"\")","v":""},"2. Calculez la puissance (P = UI) dissipée dans la résistance P = $3$ +/- $4$ W "]
[null,{"$f":"CONCATENATE(\"\")","v":""},"3. Calculer P à partir de la relation P = RI => Delta P = $5$ +/- $6$ W "]

{"sheet":"Sphere-Creuse","index":16,"n_rows":41,"n_cols":79,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["catégorie_Sph","Sphere-Creuse",{"$f":"CONCATENATE(\"    <!--  question XLQ \", titre_Sph, \"-->\")","v":"    <!--  question XLQ Sphere-Creuse_Sph-->"},null,null,"Valeur Mini_Sph","Valeur Maxi_Sph","Sig. Digit_Sph","Val Choix_Sph","Least significant","V","Max","Min","DV","DV/V","DR/R"]
[null,"Sphere-Creuse_Sph",{"$f":"CONCATENATE(\"    <question type=\",CHAR(34),\"category\",CHAR(34),\"><category><text>\", categorie_Sph,\"</text></category></question>)\")","v":"    <question type=\"category\"><category><text>Sphere-Creuse</text></category></question>)"},null,"V1.R_Sph",11,49,1,{"$f":"RANDBETWEEN(ValMini_Sph*10^-SigDig_Sph, ValMaxi_Sph*10^-SigDig_Sph)/10^-SigDig_Sph+ROUND(RANDBETWEEN(1,9),0)","v":27},{"$f":" 1/POWER(10,LEN(I2)-LEN(INT(I2))-(I2<>INT(I2))*1)","v":1},{"$f":"4*PI()*(V1.R_Sph^3)","v":247343.87280243158},{"$f":"4*PI()*((V1.R_Sph+J2)^3)","v":275856.96772641258},{"$f":"4*PI()*((V1.R_Sph-J2)^3)","v":220866.52991797682},{"$f":"(L2-M2)/2","v":27495.21890421788},{"$f":"N2/K2","v":0.11116191637453644},{"$f":"J2/V1.R_Sph","v":3.7037037037037035E-2},{"$f":"O2/P2","v":3.0013717421124841}]
["Tag_Sph","Sphere-Creuse_Sph","    <question type=\"cloze\">",null,"V2.r_Sph",{"$f":"V1.R_Sph/50","v":0.54},{"$f":"V1.R_Sph/10","v":2.7},-1,{"$f":"RANDBETWEEN(ValMini_Sph*10^-SigDig_Sph, ValMaxi_Sph*10^-SigDig_Sph)/10^-SigDig_Sph","v":1.2},{"$f":" 1/POWER(10,LEN(I3)-LEN(INT(I3))-(I3<>INT(I3))*1)","v":0.1},{"$f":"4*PI()*(V2.r_Sph^3)","v":21.714688421612649},{"$f":"4*PI()*((V2.r_Sph+J3)^3)","v":27.608316239747108},{"$f":"4*PI()*((V2.r_Sph-J3)^3)","v":16.725839287712052},{"$f":"(L3-M3)/2","v":5.4412384760175279},{"$f":"N3/K3","v":0.250578703703704},{"$f":"J3/V2.r_Sph","v":8.3333333333333343E-2},{"$f":"O3/P3","v":3.0069444444444478},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 sphère creuse a pour rayon extérieur #1#cm ; <p>la cavité est également une sphère de rayon #2#cm. <p>Exprimez le volume de la partie pleine V= $1$ +/- $2$ cm3.<p>un volume de la partie pleine V= \"\",R1.S_Sph,\"\" +/- \"\",R2.DS_Sph,\"\" cm3.</p><p><p>"]
["idnumber_Sph",{"$f":"TEXT(NOW(),\"aammjj-hhmmss.00\")","v":"210710-210812.04"},{"$f":"CONCATENATE(\"        <name><text>\", titre_Sph, \"</text></name>\")","v":"        <name><text>Sphere-Creuse_Sph</text></name>"},null,null,null,null,null,{"$f":"RANDBETWEEN(ValMini_Sph*10^-SigDig_Sph, ValMaxi_Sph*10^-SigDig_Sph)/10^-SigDig_Sph","v":0}]
["points_Sph",1,"        <questiontext format=\"html\">",null,null,null,null,null,null,null,null,null,null,null,"V",{"$f":"K2-K3","v":247322.15811400997}]
["tolérance_Sph",0.05,{"$f":"CONCATENATE(\"            <text><![CDATA[<p>\", question_Sph, \"</p>]]></text>\")","v":"            <text><![CDATA[<p> Une sph&egrave;re creuse a pour rayon ext&eacute;rieur 27cm. La cavit&eacute; est &eacute;galement une sph&egrave;re de rayon 1.2cm. Exprimez le volume de la partie pleine V= {1:NUMERICAL:=2.47E+05:1.24E+04} +/- {2:NUMERICAL:=2.75E+04:1.38E+03} cm3.</p>]]></text>"},null,null,"Cible_Sph","Toler_Sph","PointsQuestion_Sph",null,null,null,null,null,null,"DV",{"$f":"N3+N2","v":27500.660142693898}]
["penalité_Sph",0.1,"        </questiontext>",null,"R1.S_Sph",{"$f":"K2-K3","v":247322.15811400997},{"$f":" tolerance_Sph*ValMini_Sph","v":12366.107905700499},1,{"$f":"CONCATENATE(\"{\",PointsQuestion_Sph,\":NUMERICAL:=\",TEXT(Cible_Sph,\"0.00E+00\"),\":\",TEXT(ABS(Tolere_Sph),\"0.00E+00\"),\"}\")","v":"{1:NUMERICAL:=2.47E+05:1.24E+04}"},null,null,null,null,null,null,{"$f":"P6/P5","v":0.11119367691275243}]
["feedback_Sph","_",{"$f":"CONCATENATE(\"        <defaultgrade>\",points_Sph,\"</defaultgrade><generalfeedback><text>\",feedback_Sph,\"</text></generalfeedback><penalty>\",penalty_Sph,\"</penalty><hidden>0</hidden>)\")","v":"        <defaultgrade>1</defaultgrade><generalfeedback><text>_</text></generalfeedback><penalty>0.1</penalty><hidden>0</hidden>)"},null,"R2.DS_Sph",{"$f":"P6","v":27500.660142693898},{"$f":" tolerance_Sph*ValMini_Sph","v":1375.033007134695},2,{"$f":"CONCATENATE(\"{\",PointsQuestion_Sph,\":NUMERICAL:=\",TEXT(Cible_Sph,\"0.00E+00\"),\":\",TEXT(ABS(Tolere_Sph),\"0.00E+00\"),\"}\")","v":"{2:NUMERICAL:=2.75E+04:1.38E+03}"}]
["Cellule vides_Sph",{"$f":"COUNTBLANK(B1:B8)","v":0},{"$f":"CONCATENATE(\"        <idnumber>\",idnumber_Sph,\"</idnumber><tags><tag><text>\",Tag_Sph,\"</text></tag></tags>\")","v":"        <idnumber>210710-210812.04</idnumber><tags><tag><text>Sphere-Creuse_Sph</text></tag></tags>"},null,null,null,null,null,{"$f":"SUM(F7:H8)","v":288566.95916953904}]
["question format HTML_Sph",{"$f":"CONCATENATE(\" \",B19,B20,B21)","v":" Une sph&egrave;re creuse a pour rayon ext&eacute;rieur 27cm. La cavit&eacute; est &eacute;galement une sph&egrave;re de rayon 1.2cm. Exprimez le volume de la partie pleine V= {1:NUMERICAL:=2.47E+05:1.24E+04} +/- {2:NUMERICAL:=2.75E+04:1.38E+03} cm3."},"    </question>"]
["Repere Var Rep","_Sph"]
["HTML File ",{"$f":"CONCATENATE(categorie_Sph,\"_HTML.txt\")","v":"Sphere-Creuse_HTML.txt"}]
["Valide ? ",{"$f":"ISNUMBER(I9)","v":true},null,null,null,"Pour ne pas que I2 se termine par \"0\" : +ARRONDI(ALEA.ENTRE.BORNES(1;9);0)"]
["https://html-online.com/editor/ "]
[null,null,5]
["Var : ","#",3,null,null,null,null,null,null,null,{"$f":"4*PI()*(32.5)^3","v":431379.94124604849}]
["Res : ","$",2,null,null,null,null,null,null,null,{"$f":"4*PI()*(0.2)^3","v":0.1005309649148734}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K16-K17","v":431379.84071508358}]
[null,{"$f":"CONCATENATE(\"Une sph&egrave;re creuse a pour rayon ext&eacute;rieur \",V1.R_Sph,\"cm. La cavit&eacute; est &eacute;galement une sph&egrave;re de rayon \",V2.r_Sph,\"cm. Exprimez le volume de la partie pleine V= \",R1.S_Sph,\" +/- \",R2.DS_Sph,\" cm3.\")","v":"Une sph&egrave;re creuse a pour rayon ext&eacute;rieur 27cm. La cavit&eacute; est &eacute;galement une sph&egrave;re de rayon 1.2cm. Exprimez le volume de la partie pleine V= {1:NUMERICAL:=2.47E+05:1.24E+04} +/- {2:NUMERICAL:=2.75E+04:1.38E+03} cm3."},"Une sphère creuse a pour rayon extérieur #1#cm ; "]
[null,null,"la cavité est également une sphère de rayon #2#cm. "]
[null,{"$f":"CONCATENATE(\"\")","v":""},"Exprimez le volume de la partie pleine V= $1$ +/- $2$ cm3."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"+/- \"\",R2.DS_Sph,\"\" cm3.</p><p><p>"]

{"sheet":"Traction","index":17,"n_rows":44,"n_cols":79,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["o","Traction",{"$f":"CONCATENATE(\"    <!--  question XLQ \", titre_Tra, \"-->\")","v":"    <!--  question XLQ Traction_Tra-->"},null,null,"Valeur Mini_Tra","Valeur Maxi_Tra","Sig. Digit_Tra","Val Choix_Tra"]
[null,"Traction_Tra",{"$f":"CONCATENATE(\"    <question type=\",CHAR(34),\"category\",CHAR(34),\"><category><text>\", categorie_Tra,\"</text></category></question>)\")","v":"    <question type=\"category\"><category><text>Traction</text></category></question>)"},null,"V1.Long_Tra",100,200,1,{"$f":"RANDBETWEEN(ValMini_Tra*10^-SigDig_Tra, ValMaxi_Tra*10^-SigDig_Tra)/10^-SigDig_Tra","v":160},"mm",150,null,null,null,null,null,null,null,null,"V1.Long_Tra",150]
["Tag_Tra","Traction_Tra","    <question type=\"cloze\">",null,"V.Diam_Tra",{"$f":"V1.Long_Tra/30","v":5.333333333333333},{"$f":"V1.Long_Tra/20","v":8},0,6,"mm",3.5,null,null,null,null,null,null,null,null,"V.Diam_Tra",10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 effectue un essai de traction sur une &eacute;prouvette de 10 mm de diam&egrave;tre et de #1# 150 mm de <br />longueur. On observe que : le diam&egrave;tre s'est r&eacute;duit de #2# 3,5 &micro;m sous une charge de #3# 6 kN durant <br />la d&eacute;formation &eacute;lastique; et que la limite d'&eacute;lasticit&eacute; est atteinte pour une <br />force de #4# 39 kN et un allongement total de #5# 1,36 mm. La force maximale que peut supporter <br />l'&eacute;prouvette est de #6# 43 kN.</p><p><p>a) Quelle est la limite conventionnelle d'&eacute;lasticit&eacute; (contrainte) ? R&eacute;ponse : $1$ MPa</p><p><p>b) Quelle est la r&eacute;sistance &agrave; la traction de ce mat&eacute;riau? $2$ MPa</p><p><p>c) Quelle est la limite &eacute;lastique de d&eacute;formation totale (en %) ? $3$%</p><p><p>d) Quel est le module d'Young de ce mat&eacute;riau ? $4$ MPa</p><p><p>e) Quel est le coefficient de Poisson de ce mat&eacute;riau ? $5$</p><p><p>f) Quelle est l'&eacute;nergie &eacute;lastique emmagasin&eacute;e dans l'&eacute;prouvette &agrave; la limite &eacute;lastique ? $6$</p><p><p>&nbsp;</p><p>"]
["idnumber_Tra",{"$f":"TEXT(NOW(),\"aammjj-hhmmss.00\")","v":"210710-210812.04"},{"$f":"CONCATENATE(\"        <name><text>\", titre_Tra, \"</text></name>\")","v":"        <name><text>Traction_Tra</text></name>"},null,"V2.Red_Dia_Tra",3,4,-1,3.7,"µm",3.5,null,null,null,null,null,null,null,null,"V2.Red_Dia_Tra",3.5]
["points_Tra",1,"        <questiontext format=\"html\">",null,"V3.Charge_Tra",4,9,0,4,"kN",6,null,null,null,null,null,null,null,null,"V3.Charge_Tra",6]
["tolérance_Tra",0.1,{"$f":"CONCATENATE(\"            <text><![CDATA[<p>\", question_Tra, \"</p>]]></text>\")","v":"            <text><![CDATA[<p> On effectue un essai de traction sur une &eacute;prouvette de 6 mm de diam&egrave;tre et de 160 mm de <br />longueur. On observe que : le diam&egrave;tre s'est r&eacute;duit de 3.7 &micro;m sous une charge de 4 kN durant <br />la d&eacute;formation &eacute;lastique; et que la limite d'&eacute;lasticit&eacute; est atteinte pour une <br />force de 42 kN et un allongement total de 1.09 mm. La force maximale que peut supporter <br />l'&eacute;prouvette est de 44 kN.</p><p><p>a) Quelle est la limite d'&eacute;lasticit&eacute; (contrainte) ? R&eacute;ponse : {1:NUMERICAL:=1.49E+03:1.49E+02}MPa</p><p><p>b) Quelle est la r&eacute;sistance &agrave; la traction de ce mat&eacute;riau? {2:NUMERICAL:=1.56E+03:1.56E+02} MPa</p><p><p>c) Quelle est la limite &eacute;lastique de d&eacute;formation  (en %) ? {2:NUMERICAL:=6.81E-01:6.81E-02}%</p><p><p>d) Quel est le module d'Young de ce mat&eacute;riau ? {3:NUMERICAL:=2.18E+05:2.18E+04} MPa</p><p><p>e) Quelle est l'&eacute;nergie &eacute;lastique emmagasin&eacute;e dans l'&eacute;prouvette &agrave; la limite &eacute;lastique ? {4:NUMERICAL:=5.06E+00:5.06E-01} J</p><p><p>&nbsp;</p><p></p>]]></text>"},null,"V4.Force_Elas_Tra",33,44,0,42,"kN",39,null,null,null,null,null,null,null,null,"V4.Force_Elas_Tra",39]
["penalité_Tra",0.1,"        </questiontext>",null,"V5.Allonge_Tra",1,2,-2,1.0900000000000001,"mm",1.36,null,null,null,null,null,null,null,null,"V5.Allonge_Tra",1.36]
["feedback_Tra","_",{"$f":"CONCATENATE(\"        <defaultgrade>\",points_Tra,\"</defaultgrade><generalfeedback><text>\",feedback_Tra,\"</text></generalfeedback><penalty>\",penalty_Tra,\"</penalty><hidden>0</hidden>)\")","v":"        <defaultgrade>1</defaultgrade><generalfeedback><text>_</text></generalfeedback><penalty>0.1</penalty><hidden>0</hidden>)"},null,"V6.Force_Max_Tra",{"$f":"V4.Force_Elas_Tra+2","v":44},{"$f":"F8+15","v":59},0,44,"kN",43,null,null,null,null,null,null,null,null,"V6.Force_Max_Tra",43]
["Cellule vides_Tra",{"$f":"COUNTBLANK(B1:B8)","v":0},{"$f":"CONCATENATE(\"        <idnumber>\",idnumber_Tra,\"</idnumber><tags><tag><text>\",Tag_Tra,\"</text></tag></tags>\")","v":"        <idnumber>210710-210812.04</idnumber><tags><tag><text>Traction_Tra</text></tag></tags>"},null,null,null,null,null,0]
["question format HTML_Tra",{"$f":"CONCATENATE(\" \",B19,B20,B21,B22,B23,B24,B25,B26,B27,B28,B29,B30)","v":" On effectue un essai de traction sur une &eacute;prouvette de 6 mm de diam&egrave;tre et de 160 mm de <br />longueur. On observe que : le diam&egrave;tre s'est r&eacute;duit de 3.7 &micro;m sous une charge de 4 kN durant <br />la d&eacute;formation &eacute;lastique; et que la limite d'&eacute;lasticit&eacute; est atteinte pour une <br />force de 42 kN et un allongement total de 1.09 mm. La force maximale que peut supporter <br />l'&eacute;prouvette est de 44 kN.</p><p><p>a) Quelle est la limite d'&eacute;lasticit&eacute; (contrainte) ? R&eacute;ponse : {1:NUMERICAL:=1.49E+03:1.49E+02}MPa</p><p><p>b) Quelle est la r&eacute;sistance &agrave; la traction de ce mat&eacute;riau? {2:NUMERICAL:=1.56E+03:1.56E+02} MPa</p><p><p>c) Quelle est la limite &eacute;lastique de d&eacute;formation  (en %) ? {2:NUMERICAL:=6.81E-01:6.81E-02}%</p><p><p>d) Quel est le module d'Young de ce mat&eacute;riau ? {3:NUMERICAL:=2.18E+05:2.18E+04} MPa</p><p><p>e) Quelle est l'&eacute;nergie &eacute;lastique emmagasin&eacute;e dans l'&eacute;prouvette &agrave; la limite &eacute;lastique ? {4:NUMERICAL:=5.06E+00:5.06E-01} J</p><p><p>&nbsp;</p><p>"},"    </question>",null,null,"Cible_Tra","Toler_Tra","PointsQuestion_Tra"]
["Repere Var Rep","_Tra",null,null,"R1.Lim_Elas_Tra",{"$f":"1000*V4.Force_Elas_Tra/(PI()*0.25*(V.Diam_Tra)^2)","v":1485.4461355243566},{"$f":" tolerance_Tra*ValMini_Tra","v":148.54461355243566},1,{"$f":"CONCATENATE(\"{\",PointsQuestion_Tra,\":NUMERICAL:=\",TEXT(Cible_Tra,\"0.00E+00\"),\":\",TEXT(ABS(Tolere_Tra),\"0.00E+00\"),\"}\")","v":"{1:NUMERICAL:=1.49E+03:1.49E+02}"},null,{"$f":"K6/(PI()*0.01^2/4)/1000","v":496.5634224467135},null,null,null,null,null,null,null,null,"R1.Lim_Elas_Tra"," 496,6 MPa "]
["HTML File ",{"$f":"CONCATENATE(categorie_Tra,\"_HTML.txt\")","v":"Traction_HTML.txt"},null,null,"R2.Resis_Meca_Tra",{"$f":"1000*V6.Force_Max_Tra/(PI()*(V.Diam_Tra)^2/4)","v":1556.181665787421},155.61816657874212,2,"{2:NUMERICAL:=1.56E+03:1.56E+02}",null,null,null,null,null,null,null,null,null,null,"R2.Resis_Meca_Tra"," 547,5 MPa "]
["Valide ? ",{"$f":"AND(ISNUMBER(I17))","v":true},null,null,"R3.Def_Ela_Tra",{"$f":"100*V5.Allonge_Tra/V1.Long_Tra","v":0.68125000000000013},6.8125000000000019E-2,2,"{2:NUMERICAL:=6.81E-01:6.81E-02}",null,null,null,null,null,null,null,null,null,null,"R3.Def_Ela_Tra","0,907 %"]
["https://html-online.com/editor/ ",null,null,null,"R4.Module_You_Tra",{"$f":"F11/(F13/100)","v":218047.13915953852},21804.713915953853,3,"{3:NUMERICAL:=2.18E+05:2.18E+04}",null,null,null,null,null,null,null,null,null,null,"R4.Module_You_Tra"," 70,2 GPa "]
[null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R5.Poisson_Tra","     0,32 "]
["Var : ","#",6,null,"R6.Ener_Elas_Tra",{"$f":"F13*F11/(2*100)","v":5.0598008991298409},0.50598008991298415,4,"{4:NUMERICAL:=5.06E+00:5.06E-01}",null,null,null,null,null,null,null,null,null,null,"R6.Ener_Elas_Tra"," 21,76 J "]
["Res : ","$",6,null,null,{"$f":"2*((F6*1000)^2*V1.Long_Tra/1000)/(PI()*F14*1000000000*10*0.001)","v":5.0871857142857147E-5},null,null,{"$f":"SUM(F11:H16)","v":243215.95881292436}]
[]
[null,{"$f":"CONCATENATE(\"On effectue un essai de traction sur une &eacute;prouvette de \",V.Diam_Tra,\" mm de diam&egrave;tre et de \",V1.Long_Tra,\" mm de <br />longueur. On observe que : le diam&egrave;tre s'est r&eacute;duit de \",V2.Red_Dia_Tra,\" &micro;m\")","v":"On effectue un essai de traction sur une &eacute;prouvette de 6 mm de diam&egrave;tre et de 160 mm de <br />longueur. On observe que : le diam&egrave;tre s'est r&eacute;duit de 3.7 &micro;m"},"<p>On effectue un essai de traction sur une &eacute;prouvette de 10 mm de diam&egrave;tre et de #1# 150 mm de <br />longueur. On observe que : le diam&egrave;tre s'est r&eacute;duit de #2# 3,5 &micro;m sous une charge de #3# 6 kN durant <br />la d&eacute;formation &eacute;lastique; et que la limite d'&eacute;lasticit&eacute; est atteinte pour une <br />force de #4# 39 kN et un allongement total de #5# 1,36 mm. La force maximale que peut supporter <br />l'&eacute;prouvette est de #6# 43 kN.</p>"]
[null,{"$f":"CONCATENATE(\" sous une charge de \",V3.Charge_Tra,\" kN durant <br />la d&eacute;formation &eacute;lastique; et que la limite d'&eacute;lasticit&eacute; est atteinte pour une <br />force de \",V4.Force_Elas_Tra,\" kN et un allongement total de \",V5.Allonge_Tra,\"\")","v":" sous une charge de 4 kN durant <br />la d&eacute;formation &eacute;lastique; et que la limite d'&eacute;lasticit&eacute; est atteinte pour une <br />force de 42 kN et un allongement total de 1.09"},"<p>a) Quelle est la limite conventionnelle d'&eacute;lasticit&eacute; (contrainte) ? R&eacute;ponse : $1$ MPa</p>"]
[null,{"$f":"CONCATENATE(\" mm. La force maximale que peut supporter <br />l'&eacute;prouvette est de \",V6.Force_Max_Tra,\" kN.</p><p><p>a) Quelle est la limite d'&eacute;lasticit&eacute; (contrainte) ? R&eacute;ponse : \",R1.Lim_Elas_Tra,\"\")","v":" mm. La force maximale que peut supporter <br />l'&eacute;prouvette est de 44 kN.</p><p><p>a) Quelle est la limite d'&eacute;lasticit&eacute; (contrainte) ? R&eacute;ponse : {1:NUMERICAL:=1.49E+03:1.49E+02}"},"<p>b) Quelle est la r&eacute;sistance &agrave; la traction de ce mat&eacute;riau? $2$ MPa</p>"]
[null,{"$f":"CONCATENATE(\"MPa</p><p><p>b) Quelle est la r&eacute;sistance &agrave; la traction de ce mat&eacute;riau? \",R2.Resis_Meca_Tra,\" MPa</p><p><p>c) Quelle est la limite &eacute;lastique de d&eacute;formation  (en %) ? \",R3.Def_Ela_Tra,\"%</p><p><p>d)\")","v":"MPa</p><p><p>b) Quelle est la r&eacute;sistance &agrave; la traction de ce mat&eacute;riau? {2:NUMERICAL:=1.56E+03:1.56E+02} MPa</p><p><p>c) Quelle est la limite &eacute;lastique de d&eacute;formation  (en %) ? {2:NUMERICAL:=6.81E-01:6.81E-02}%</p><p><p>d)"},"<p>c) Quelle est la limite &eacute;lastique de d&eacute;formation totale (en %) ? $3$%</p>"]
[null,{"$f":"CONCATENATE(\" Quel est le module d'Young de ce mat&eacute;riau ? \",R4.Module_You_Tra,\" MPa</p><p><p>e) Quelle est l'&eacute;nergie &eacute;lastique emmagasin&eacute;e\")","v":" Quel est le module d'Young de ce mat&eacute;riau ? {3:NUMERICAL:=2.18E+05:2.18E+04} MPa</p><p><p>e) Quelle est l'&eacute;nergie &eacute;lastique emmagasin&eacute;e"},"<p>d) Quel est le module d'Young de ce mat&eacute;riau ? $4$ MPa</p>"]
[null,{"$f":"CONCATENATE(\" dans l'&eacute;prouvette &agrave; la limite &eacute;lastique ? \",R6.Ener_Elas_Tra,\" J</p><p><p>&nbsp;</p><p>\")","v":" dans l'&eacute;prouvette &agrave; la limite &eacute;lastique ? {4:NUMERICAL:=5.06E+00:5.06E-01} J</p><p><p>&nbsp;</p><p>"},"<p>e) Quel est le coefficient de Poisson de ce mat&eacute;riau ? $5$</p>"]
[null,{"$f":"CONCATENATE(\"\")","v":""},"<p>f) Quelle est l'&eacute;nergie &eacute;lastique emmagasin&eacute;e dans l'&eacute;prouvette &agrave; la limite &eacute;lastique ? $6$</p>"]
[null,"","<p>&nbsp;</p>"]
[null,null,null,null,null,null,"eps","sig"]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,{"$f":"F13","v":0.68125000000000013},{"$f":"F11","v":1485.4461355243566},null,null,null,null,null,":%s/{.*}/\\\\minisol{\";;\"}"]
[null,null,null,null,null,null,1,{"$f":"F12","v":1556.181665787421},null,null,null,null,null,":%g/\";;\"/ s/^/=concatener(\"/",null,null,null,null,null,{"$f":"CONCATENATE(\"On effectue un essai de traction sur une éprouvette de \",V2.Red_Dia_Tra,\" mm de diamètre et de \",V1.Long_Tra,\" mm de\")","v":"On effectue un essai de traction sur une éprouvette de 3.7 mm de diamètre et de 160 mm de"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,":%g/\";;\"/ s/$/\")",null,null,null,null,null,{"$f":"CONCATENATE(\"longueur. On observe que : le diamètre s'est réduit de \",V2.Red_Dia_Tra,\" µm sous une charge de \",V3.Charge_Tra,\" kN durant\")","v":"longueur. On observe que : le diamètre s'est réduit de 3.7 µm sous une charge de 4 kN durant"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,":%s/=concatener(\"=concatener(\"/=concatener(\"/gie",null,null,null,null,null,{"$f":"CONCATENATE(\"la déformation élastique; et que la limite d'élasticité est atteinte pour une\")","v":"la déformation élastique; et que la limite d'élasticité est atteinte pour une"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,":%s/\")\")/\")/gie",null,null,null,null,null,{"$f":"CONCATENATE(\"force de \",V4.Force_Elas_Tra,\" kN et un allongement total de \",V5.Allonge_Tra,\" mm. La force maximale que peut supporter\")","v":"force de 42 kN et un allongement total de 1.09 mm. La force maximale que peut supporter"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"On réalise un essai de traction sur une éprouvette de \",V.Diam_Tra,\" mm de diamètre et de \",V1.Long_Tra,\" mm de \")","v":"On réalise un essai de traction sur une éprouvette de 6 mm de diamètre et de 160 mm de "},null,null,null,null,null,null,{"$f":"CONCATENATE(\"l'éprouvette est de \",V6.Force_Max_Tra,\" kN.\")","v":"l'éprouvette est de 44 kN."}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"longueur. Le diamètre se réduit de \",V2.Red_Dia_Tra,\" µm sous une charge de \",V3.Charge_Tra,\" kN, dans \")","v":"longueur. Le diamètre se réduit de 3.7 µm sous une charge de 4 kN, dans "}]
[null,null,null,null,null,null,null,null,null,null,null,null,"la déformation élastique et que la limite d'élasticité est atteinte pour une",null,null,null,null,null,null,{"$f":"CONCATENATE(\"a) Quelle est la limite d'élasticité (contrainte) ? \\minisol{\",ROUND(F11,0),\"} MPa}\")","v":"a) Quelle est la limite d'élasticité (contrainte) ? \\minisol{1485} MPa}"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"force de \",V4.Force_Elas_Tra,\" kN et un allongement total de \",V5.Allonge_Tra,\" mm. La force maximale que peut supporter \")","v":"force de 42 kN et un allongement total de 1.09 mm. La force maximale que peut supporter "},null,null,null,null,null,null,{"$f":"CONCATENATE(\"b) Quelle est la résistance à la traction de ce matériau ? \\minisol{\", ROUND(F12,0),\"} MPa\")","v":"b) Quelle est la résistance à la traction de ce matériau ? \\minisol{1556} MPa"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"l'éprouvette est de \",V6.Force_Max_Tra,\" kN.\\\\\")","v":"l'éprouvette est de 44 kN.\\\\"},null,null,null,null,null,null,{"$f":"CONCATENATE(\"c) Quelle est la limite élastique de déformation totale (en %) ?\",ROUND(F13,0),\"%\")","v":"c) Quelle est la limite élastique de déformation totale (en %) ?1%"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"d) Quel est le module d'Young de ce matériau ? \\minisol{\",ROUND(F14,0),\"} MPa\")","v":"d) Quel est le module d'Young de ce matériau ? \\minisol{218047} MPa"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"a) Quelle est la limite d'élasticité (contrainte nominale = $F/S_0$? \\formsol{$F_{el} / (\\pi d^2 /4)$}  \\minisol{\",ROUND(F11,0),\"} MPa\\\\\")","v":"a) Quelle est la limite d'élasticité (contrainte nominale = $F/S_0$? \\formsol{$F_{el} / (\\pi d^2 /4)$}  \\minisol{1485} MPa\\\\"},null,null,null,null,null,null,{"$f":"CONCATENATE(\"e) Quelle est l'énergie élastique emmagasinée dans l'éprouvette à la limite élastique ? \\minisol{\",ROUND(F16,0),\"J}\")","v":"e) Quelle est l'énergie élastique emmagasinée dans l'éprouvette à la limite élastique ? \\minisol{5J}"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"b) Quelle est la résistance à la traction de ce matériau? \\formsol{$F_{Max} / (\\pi d^2 / 4) $ } \\minisol{\",ROUND(F12,0),\"} MPa\\\\\")","v":"b) Quelle est la résistance à la traction de ce matériau? \\formsol{$F_{Max} / (\\pi d^2 / 4) $ } \\minisol{1556} MPa\\\\"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"c) Quelle est la limite élastique de déformation  (en \\%) ? \\formsol{$\\epsilon_{el} / L_0$} \\minisol{\",ROUND(F13,2),\"}\\%\\\\\")","v":"c) Quelle est la limite élastique de déformation  (en \\%) ? \\formsol{$\\epsilon_{el} / L_0$} \\minisol{0.68}\\%\\\\"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"d) Quel est le module d'Young de ce matériau ? \\formsol{$\\sigma_{el} / \\varepsilon_{el} $} \\minisol{\",ROUND(F14,-2),\"} MPa\\\\\")","v":"d) Quel est le module d'Young de ce matériau ? \\formsol{$\\sigma_{el} / \\varepsilon_{el} $} \\minisol{218000} MPa\\\\"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"e) Quelle est l'énergie élastique emmagasinée dans l'éprouvette à la limite élastique ? \\formsol{$\\sigma_{el} * \\varepsilon_{el} / (2 *100)$}\\minisol{\",ROUND(F16,1),\"} J\")","v":"e) Quelle est l'énergie élastique emmagasinée dans l'éprouvette à la limite élastique ? \\formsol{$\\sigma_{el} * \\varepsilon_{el} / (2 *100)$}\\minisol{5.1} J"}]