{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["xsymbol","xcolor","xwork","La-Chaine","Independants","Alumine","Tenac_Beton","Pizza","Traction","VerreSimple","Griffith","WeiPara"],"not_rendered":{"charts":2,"images":20,"macros":1,"external_links":0,"defined_names":260,"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":"La-Chaine","index":3,"n_rows":41,"n_cols":79,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["catégorie_Cha","La-Chaine",{"$f":"CONCATENATE(\"    <!--  question XLQ \", titre_Cha, \"-->\")","v":"    <!--  question XLQ La-Chaine_Cha-->"},null,null,"Valeur Mini_Cha","Valeur Maxi_Cha","Sig. Digit_Cha","Val Choix_Cha"]
[null,"La-Chaine_Cha",{"$f":"CONCATENATE(\"    <question type=\",CHAR(34),\"category\",CHAR(34),\"><category><text>\", categorie_Cha,\"</text></category></question>)\")","v":"    <question type=\"category\"><category><text>La-Chaine</text></category></question>)"},null,"V1.LongA_Cha",1,10,0,{"$f":"RANDBETWEEN(ValMini_Cha*10^-SigDig_Cha, ValMaxi_Cha*10^-SigDig_Cha)/10^-SigDig_Cha+ROUND(RAND()/3,1)","v":7.3}]
["Tag_Cha","La-Chaine_Cha","    <question type=\"cloze\">",null,"V2.ProbaA_Cha",0.1,0.9,-1,{"$f":"RANDBETWEEN(ValMini_Cha*10^-SigDig_Cha, ValMaxi_Cha*10^-SigDig_Cha)/10^-SigDig_Cha","v":0.4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<p>Une chaine de longueur #1#m &agrave; une probabilit&eacute; de rupture de #2#. En d&eacute;duire la probabilit&eacute; de rupture de cette une m&ecirc;me chaine avec une longueur de #3#m. R&eacute;ponse : $1$</p><p><p>&nbsp;</p><p>"]
["idnumber_Cha",{"$f":"TEXT(NOW(),\"aammjj-hhmmss.00\")","v":"210710-210925.17"},{"$f":"CONCATENATE(\"        <name><text>\", titre_Cha, \"</text></name>\")","v":"        <name><text>La-Chaine_Cha</text></name>"},null,"V3.LongB_Cha",2,10,0,{"$f":"RANDBETWEEN(ValMini_Cha*10^-SigDig_Cha, ValMaxi_Cha*10^-SigDig_Cha)/10^-SigDig_Cha-ROUND(RAND()/3,1)-0.1","v":3.9}]
["points_Cha",1,"        <questiontext format=\"html\">"]
["tolérance_Cha",0.05,{"$f":"CONCATENATE(\"            <text><![CDATA[<p>\", question_Cha, \"</p>]]></text>\")","v":"            <text><![CDATA[<p> Une chaine de longueur 7.3m &agrave; une probabilit&eacute; de rupture de 0.4. En d&eacute;duire la probabilit&eacute; de rupture de cette une m&ecirc;me chaine avec une longueur de 3.9m. R&eacute;ponse: {1:NUMERICAL:=2.39E-01:1.19E-02}</p><p><p>&nbsp;</p><p></p>]]></text>"},null,null,"Cible_Cha","Toler_Cha","PointsQuestion_Cha"]
["penalité_Cha",0.1,"        </questiontext>",null,"R1.ProbaB_Cha",{"$f":"1-(1-V2.ProbaA_Cha)^(V3.LongB_Cha/V1.LongA_Cha)","v":0.23883630573585779},{"$f":" tolerance_Cha*ValMini_Cha","v":1.194181528679289E-2},1,{"$f":"CONCATENATE(\"{\",PointsQuestion_Cha,\":NUMERICAL:=\",TEXT(Cible_Cha,\"0.00E+00\"),\":\",TEXT(ABS(Tolere_Cha),\"0.00E+00\"),\"}\")","v":"{1:NUMERICAL:=2.39E-01:1.19E-02}"}]
["feedback_Cha","_",{"$f":"CONCATENATE(\"        <defaultgrade>\",points_Cha,\"</defaultgrade><generalfeedback><text>\",feedback_Cha,\"</text></generalfeedback><penalty>\",penalty_Cha,\"</penalty><hidden>0</hidden>)\")","v":"        <defaultgrade>1</defaultgrade><generalfeedback><text>_</text></generalfeedback><penalty>0.1</penalty><hidden>0</hidden>)"},null,null,null,null,null,{"$f":"SUM(F7:H7)","v":1.2507781210226507}]
["Cellule vides_Cha",{"$f":"COUNTBLANK(B1:B8)","v":0},{"$f":"CONCATENATE(\"        <idnumber>\",idnumber_Cha,\"</idnumber><tags><tag><text>\",Tag_Cha,\"</text></tag></tags>\")","v":"        <idnumber>210710-210925.17</idnumber><tags><tag><text>La-Chaine_Cha</text></tag></tags>"}]
["question format HTML_Cha",{"$f":"CONCATENATE(\" \",B19,B20,B21)","v":" Une chaine de longueur 7.3m &agrave; une probabilit&eacute; de rupture de 0.4. En d&eacute;duire la probabilit&eacute; de rupture de cette une m&ecirc;me chaine avec une longueur de 3.9m. R&eacute;ponse: {1:NUMERICAL:=2.39E-01:1.19E-02}</p><p><p>&nbsp;</p><p>"},"    </question>"]
["Repere Var Rep","_Cha"]
["HTML File ",{"$f":"CONCATENATE(categorie_Cha,\"_HTML.txt\")","v":"La-Chaine_HTML.txt"}]
["Valide ? ",{"$f":"AND(ISNUMBER(I8),V1.LongA_Cha<>V3.LongB_Cha)","v":true}]
["https://html-online.com/editor/ "]
[null,null,5]
["Var : ","#",3]
["Res : ","$",1]
[]
[null,{"$f":"CONCATENATE(\"Une chaine de longueur \",V1.LongA_Cha,\"m &agrave; une probabilit&eacute; de rupture de \",V2.ProbaA_Cha,\". En d&eacute;duire la probabilit&eacute; de rupture de cette une m&ecirc;me chaine avec une longueur de \",V3.LongB_Cha,\"m. R&eacute;ponse\")","v":"Une chaine de longueur 7.3m &agrave; une probabilit&eacute; de rupture de 0.4. En d&eacute;duire la probabilit&eacute; de rupture de cette une m&ecirc;me chaine avec une longueur de 3.9m. R&eacute;ponse"},"<p>Une chaine de longueur #1#m &agrave; une probabilit&eacute; de rupture de #2#. En d&eacute;duire la probabilit&eacute; de rupture de cette une m&ecirc;me chaine avec une longueur de #3#m. R&eacute;ponse : $1$</p>"]
[null,{"$f":"CONCATENATE(\": \",R1.ProbaB_Cha,\"</p><p><p>&nbsp;</p><p>\")","v":": {1:NUMERICAL:=2.39E-01:1.19E-02}</p><p><p>&nbsp;</p><p>"},"<p>&nbsp;</p>"]
[null,{"$f":"CONCATENATE(\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Une chaine de longueur \",V1.LongA_Cha,\"m à une probabilité de rupture de \",V2.ProbaA_Cha,\". En déduire la probabilité de rupture de cette une même chaine avec une longueur de \",V3.LongB_Cha,\"m. Réponse\")","v":"Une chaine de longueur 7.3m à une probabilité de rupture de 0.4. En déduire la probabilité de rupture de cette une même chaine avec une longueur de 3.9m. Réponse"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"  \\formsol{$1-(1-p_A)^{(L_B/L_A)}$} \\minisol{\",ROUND(F7,3),\"}\")","v":"  \\formsol{$1-(1-p_A)^{(L_B/L_A)}$} \\minisol{0.239}"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,": \",R1.ProbaB_Cha,\"</p><p><p>&nbsp;</p><p>"]

{"sheet":"Independants","index":4,"n_rows":23,"n_cols":79,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["catégorie_Ind","Independants",{"$f":"CONCATENATE(\"    <!--  question XLQ \", titre_Ind, \"-->\")","v":"    <!--  question XLQ Independants_Ind-->"},null,null,"Valeur Mini_Ind","Valeur Maxi_Ind","Sig. Digit_Ind","Val Choix_Ind"]
[null,"Independants_Ind",{"$f":"CONCATENATE(\"    <question type=\",CHAR(34),\"category\",CHAR(34),\"><category><text>\", categorie_Ind,\"</text></category></question>)\")","v":"    <question type=\"category\"><category><text>Independants</text></category></question>)"},null,"V1.ProbA_Ind",0.1,0.9,-1,{"$f":"RANDBETWEEN(ValMini_Ind*10^-SigDig_Ind, ValMaxi_Ind*10^-SigDig_Ind)/10^-SigDig_Ind","v":0.7}]
["Tag_Ind","Independants_Ind","    <question type=\"cloze\">",null,"V2.ProbaB_Ind",0.1,0.9,-1,{"$f":"RANDBETWEEN(ValMini_Ind*10^-SigDig_Ind, ValMaxi_Ind*10^-SigDig_Ind)/10^-SigDig_Ind","v":0.7},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 un s&eacute;rie de tests probabilistes avec des &eacute;v&eacute;nements r&eacute;put&eacute;s ind&eacute;pendants, A, B, C et D avec des probablit&eacute; de r&eacute;alisation P(A)=#1#, P(B)=#2#, P(C)=#3# et P(D)=#4#. Calculez la probabilit&eacute; que A et B se r&eacute;alisent tous les deux : P(A,B)=$1$, de m&ecirc;me pour P(B,C,D)=$2$.</p><p><p>&nbsp;</p><p>"]
["idnumber_Ind",{"$f":"TEXT(NOW(),\"aammjj-hhmmss.00\")","v":"210710-210925.17"},{"$f":"CONCATENATE(\"        <name><text>\", titre_Ind, \"</text></name>\")","v":"        <name><text>Independants_Ind</text></name>"},null,"V3.ProbaC_Ind",0.1,0.9,-1,{"$f":"RANDBETWEEN(ValMini_Ind*10^-SigDig_Ind, ValMaxi_Ind*10^-SigDig_Ind)/10^-SigDig_Ind","v":0.7}]
["points_Ind",1,"        <questiontext format=\"html\">",null,"V4.ProbaD_Ind",0.1,0.9,-1,{"$f":"RANDBETWEEN(ValMini_Ind*10^-SigDig_Ind, ValMaxi_Ind*10^-SigDig_Ind)/10^-SigDig_Ind","v":0.2}]
["tolérance_Ind",0.1,{"$f":"CONCATENATE(\"            <text><![CDATA[<p>\", question_Ind, \"</p>]]></text>\")","v":"            <text><![CDATA[<p> On r&eacute;alise un s&eacute;rie de tests probabilistes avec des &eacute;v&eacute;nements r&eacute;put&eacute;s ind&eacute;pendants, A, B, C et D avec des probablit&eacute; de r&eacute;alisation P(A)=0.7, P(B)=0.7, P(C)=0.7 et P(D)=0.2. Calculez la probabilit&eacute; que A et B se r&eacute;alisent tous les deux : P(A,B)={1:NUMERICAL:=4.90E-01:4.90E-02}, de m&ecirc;me pour P(B,C,D)={1:NUMERICAL:=9.80E-02:9.80E-03}.</p><p><p>&nbsp;</p><p></p>]]></text>"}]
["penalité_Ind",0.1,"        </questiontext>",null,null,"Cible_Ind","Toler_Ind","PointsQuestion_Ind"]
["feedback_Ind","_",{"$f":"CONCATENATE(\"        <defaultgrade>\",points_Ind,\"</defaultgrade><generalfeedback><text>\",feedback_Ind,\"</text></generalfeedback><penalty>\",penalty_Ind,\"</penalty><hidden>0</hidden>)\")","v":"        <defaultgrade>1</defaultgrade><generalfeedback><text>_</text></generalfeedback><penalty>0.1</penalty><hidden>0</hidden>)"},null,"R1.ProbaAB_Ind",{"$f":"V1.ProbA_Ind*V2.ProbaB_Ind","v":0.48999999999999994},{"$f":" tolerance_Ind*ValMini_Ind","v":4.8999999999999995E-2},1,{"$f":"CONCATENATE(\"{\",PointsQuestion_Ind,\":NUMERICAL:=\",TEXT(Cible_Ind,\"0.00E+00\"),\":\",TEXT(ABS(Tolere_Ind),\"0.00E+00\"),\"}\")","v":"{1:NUMERICAL:=4.90E-01:4.90E-02}"}]
["Cellule vides_Ind",{"$f":"COUNTBLANK(B1:B8)","v":0},{"$f":"CONCATENATE(\"        <idnumber>\",idnumber_Ind,\"</idnumber><tags><tag><text>\",Tag_Ind,\"</text></tag></tags>\")","v":"        <idnumber>210710-210925.17</idnumber><tags><tag><text>Independants_Ind</text></tag></tags>"},null,"R2.ProbaBCD_Ind",{"$f":"V2.ProbaB_Ind*V3.ProbaC_Ind*V4.ProbaD_Ind","v":9.799999999999999E-2},{"$f":" tolerance_Ind*ValMini_Ind","v":9.7999999999999997E-3},1,{"$f":"CONCATENATE(\"{\",PointsQuestion_Ind,\":NUMERICAL:=\",TEXT(Cible_Ind,\"0.00E+00\"),\":\",TEXT(ABS(Tolere_Ind),\"0.00E+00\"),\"}\")","v":"{1:NUMERICAL:=9.80E-02:9.80E-03}"}]
["question format HTML_Ind",{"$f":"CONCATENATE(\" \",B19,B20,B21,B22)","v":" On r&eacute;alise un s&eacute;rie de tests probabilistes avec des &eacute;v&eacute;nements r&eacute;put&eacute;s ind&eacute;pendants, A, B, C et D avec des probablit&eacute; de r&eacute;alisation P(A)=0.7, P(B)=0.7, P(C)=0.7 et P(D)=0.2. Calculez la probabilit&eacute; que A et B se r&eacute;alisent tous les deux : P(A,B)={1:NUMERICAL:=4.90E-01:4.90E-02}, de m&ecirc;me pour P(B,C,D)={1:NUMERICAL:=9.80E-02:9.80E-03}.</p><p><p>&nbsp;</p><p>"},"    </question>"]
["Repere Var Rep","_Ind",null,null,null,null,null,{"$f":"SUM(F8:H9)","v":2.6467999999999998}]
["HTML File ",{"$f":"CONCATENATE(categorie_Ind,\"_HTML.txt\")","v":"Independants_HTML.txt"}]
["Valide ? ",{"$f":"ISNUMBER(H11)","v":true}]
["https://html-online.com/editor/"]
[null,null,6]
["Var : ","#",4]
["Res : ","$",2]
[]
[null,{"$f":"CONCATENATE(\"On r&eacute;alise un s&eacute;rie de tests probabilistes avec des &eacute;v&eacute;nements r&eacute;put&eacute;s ind&eacute;pendants, A, B, C et D avec des probablit&eacute; de r&eacute;alisation P(A)=\",V1.ProbA_Ind,\",\")","v":"On r&eacute;alise un s&eacute;rie de tests probabilistes avec des &eacute;v&eacute;nements r&eacute;put&eacute;s ind&eacute;pendants, A, B, C et D avec des probablit&eacute; de r&eacute;alisation P(A)=0.7,"},"<p>On r&eacute;alise un s&eacute;rie de tests probabilistes avec des &eacute;v&eacute;nements r&eacute;put&eacute;s ind&eacute;pendants, A, B, C et D avec des probablit&eacute; de r&eacute;alisation P(A)=#1#, P(B)=#2#, P(C)=#3# et P(D)=#4#. Calculez la probabilit&eacute; que A et B se r&eacute;alisent tous les deux : P(A,B)=$1$, de m&ecirc;me pour P(B,C,D)=$2$.</p>"]
[null,{"$f":"CONCATENATE(\" P(B)=\",V2.ProbaB_Ind,\", P(C)=\",V3.ProbaC_Ind,\" et P(D)=\",V4.ProbaD_Ind,\". Calculez la probabilit&eacute; que A et B se r&eacute;alisent tous les deux : P(A,B)=\",R1.ProbaAB_Ind,\", de m&ecirc;me pour P(B,C,D)=\",R2.ProbaBCD_Ind,\".</p><p><p>&nbsp;</p><p>\")","v":" P(B)=0.7, P(C)=0.7 et P(D)=0.2. Calculez la probabilit&eacute; que A et B se r&eacute;alisent tous les deux : P(A,B)={1:NUMERICAL:=4.90E-01:4.90E-02}, de m&ecirc;me pour P(B,C,D)={1:NUMERICAL:=9.80E-02:9.80E-03}.</p><p><p>&nbsp;</p><p>"},"<p>&nbsp;</p>"]
[null,{"$f":"CONCATENATE(\"\")","v":""}]
[null,{"$f":"CONCATENATE(\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"On réalise un série de tests probabilistes avec des événements réputés indépendants, A, B, C et D avec des probablité de réalisation P(A)=\",V1.ProbA_Ind,\",\")","v":"On réalise un série de tests probabilistes avec des événements réputés indépendants, A, B, C et D avec des probablité de réalisation P(A)=0.7,"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"P(B)=\",V2.ProbaB_Ind,\", P(C)=\",V3.ProbaC_Ind,\" et P(D)=\",V4.ProbaD_Ind,\". Calculez la probabilité que A et B se réalisent tous les deux : P(A,B)= \\formsol{pa x pb} \\minisol{\",ROUND(F8,3),\"}, de même pour P(B,C,D)\\formsol{pb x pc x pd} \\minisol{\",ROUND(F9,3),\"}.\")","v":"P(B)=0.7, P(C)=0.7 et P(D)=0.2. Calculez la probabilité que A et B se réalisent tous les deux : P(A,B)= \\formsol{pa x pb} \\minisol{0.49}, de même pour P(B,C,D)\\formsol{pb x pc x pd} \\minisol{0.098}."}]

{"sheet":"Alumine","index":5,"n_rows":25,"n_cols":79,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["catégorie_AlO","Alumine",{"$f":"CONCATENATE(\"    <!--  question XLQ \", titre_AlO, \"-->\")","v":"    <!--  question XLQ Alumine_AlO-->"},null,null,"Valeur Mini_AlO","Valeur Maxi_AlO","Sig. Digit_AlO","Val Choix_AlO"]
[null,"Alumine_AlO",{"$f":"CONCATENATE(\"    <question type=\",CHAR(34),\"category\",CHAR(34),\"><category><text>\", categorie_AlO,\"</text></category></question>)\")","v":"    <question type=\"category\"><category><text>Alumine</text></category></question>)"},null,"V1.KIC_AlO",0.5,4,-1,{"$f":"RANDBETWEEN(ValMini_AlO*10^-SigDig_AlO, ValMaxi_AlO*10^-SigDig_AlO)/10^-SigDig_AlO","v":2.4},"MPa  m1/2",null,3]
["Tag_AlO","Alumine_AlO","    <question type=\"cloze\">",null,"V2.Profond_AlO",10,100,1,{"$f":"RANDBETWEEN(ValMini_AlO*10^-SigDig_AlO, ValMaxi_AlO*10^-SigDig_AlO)/10^-SigDig_AlO","v":70},"µm",null,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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>Al2O3 &agrave; une t&eacute;nacit&eacute; de KIC proche de #1# 3MPa. m1/2. Un ensemble d'&eacute;chantillon pr&eacute;sente des fissures de surface de #2# 30 &micro;m estimez<br />la contrainte &agrave; rupture en traction Rm=$1$ MPa.</p><p>Al2O3 à une ténacité de KIC proche de #i# 3MPa. m1/2. Un ensemble d'échantillon présente des fissures de surface de #i# 30 µm estimez<p>la contrainte à rupture en traction Rm=$1$ MPa.<p>Al2O3 à une ténacité de KIC proche de #i# 3MPa. m1/2. Un ensemble d'échantillon présente des fissures de surface de #i# 30 µm estimez<p>la contrainte à rupture en traction Rm=\"\",R1.ResMeca_AlO,\"\" MPa.<p><p>"]
["idnumber_AlO",{"$f":"TEXT(NOW(),\"aammjj-hhmmss.00\")","v":"210710-210925.17"},{"$f":"CONCATENATE(\"        <name><text>\", titre_AlO, \"</text></name>\")","v":"        <name><text>Alumine_AlO</text></name>"},null,null,null,null,null,{"$f":"RANDBETWEEN(ValMini_AlO*10^-SigDig_AlO, ValMaxi_AlO*10^-SigDig_AlO)/10^-SigDig_AlO","v":0}]
["points_AlO",1,"        <questiontext format=\"html\">",null,null,"Cible_AlO","Toler_AlO","PointsQuestion_AlO"]
["tolérance_AlO",0.3,{"$f":"CONCATENATE(\"            <text><![CDATA[<p>\", question_AlO, \"</p>]]></text>\")","v":"            <text><![CDATA[<p> Si la t&eacute;nacit&eacute; Al2O3 (KIC) est proche de 2.4 MPa.m1/2, et qu'un &eacute;chantillon pr&eacute;sente un ensemble des fissures de surface de 70 &micro;m estimez la contrainte &agrave; rupture en traction Rm={2:NUMERICAL:=1.62E+02:4.86E+01} MPa.</p></p>]]></text>"},null,"R1.ResMeca_AlO",{"$f":"V1.KIC_AlO/SQRT(PI()*V2.Profond_AlO*0.000001)","v":161.84052752273649},{"$f":" tolerance_AlO*ValMini_AlO","v":48.552158256820945},2,{"$f":"CONCATENATE(\"{\",PointsQuestion_AlO,\":NUMERICAL:=\",TEXT(Cible_AlO,\"0.00E+00\"),\":\",TEXT(ABS(Tolere_AlO),\"0.00E+00\"),\"}\")","v":"{2:NUMERICAL:=1.62E+02:4.86E+01}"},null,null,{"$f":"L2/SQRT(PI()*L3*0.000001)","v":309.01936161855173}]
["penalité_AlO",0.1,"        </questiontext>",null,null,{"$f":"SUM(F6:H6)","v":212.39268577955744}]
["feedback_AlO","_",{"$f":"CONCATENATE(\"        <defaultgrade>\",points_AlO,\"</defaultgrade><generalfeedback><text>\",feedback_AlO,\"</text></generalfeedback><penalty>\",penalty_AlO,\"</penalty><hidden>0</hidden>)\")","v":"        <defaultgrade>1</defaultgrade><generalfeedback><text>_</text></generalfeedback><penalty>0.1</penalty><hidden>0</hidden>)"}]
["Cellule vides_AlO",{"$f":"COUNTBLANK(B1:B8)","v":0},{"$f":"CONCATENATE(\"        <idnumber>\",idnumber_AlO,\"</idnumber><tags><tag><text>\",Tag_AlO,\"</text></tag></tags>\")","v":"        <idnumber>210710-210925.17</idnumber><tags><tag><text>Alumine_AlO</text></tag></tags>"}]
["question format HTML_AlO",{"$f":"CONCATENATE(\" \",B19,B20,B21,B22,B23,B24,B25)","v":" Si la t&eacute;nacit&eacute; Al2O3 (KIC) est proche de 2.4 MPa.m1/2, et qu'un &eacute;chantillon pr&eacute;sente un ensemble des fissures de surface de 70 &micro;m estimez la contrainte &agrave; rupture en traction Rm={2:NUMERICAL:=1.62E+02:4.86E+01} MPa.</p>"},"    </question>"]
["Repere Var Rep","_AlO"]
["HTML File ",{"$f":"CONCATENATE(categorie_AlO,\"_HTML.txt\")","v":"Alumine_HTML.txt"}]
["Valide ? ",{"$f":"ISNUMBER(F7)","v":true}]
["https://html-online.com/editor/"]
[null,null,4]
["Var : ","#",2]
["Res : ","$",1]
[]
[null,{"$f":"CONCATENATE(\"Si la t&eacute;nacit&eacute; Al2O3 (KIC) est proche de \",V1.KIC_AlO,\" MPa.m1/2, et qu'un &eacute;chantillon pr&eacute;sente un ensemble des fissures de surface de \",V2.Profond_AlO,\" &micro;m estimez la contrainte &agrave;\")","v":"Si la t&eacute;nacit&eacute; Al2O3 (KIC) est proche de 2.4 MPa.m1/2, et qu'un &eacute;chantillon pr&eacute;sente un ensemble des fissures de surface de 70 &micro;m estimez la contrainte &agrave;"},"<p>Al2O3 &agrave; une t&eacute;nacit&eacute; de KIC proche de #1# 3MPa. m1/2. Un ensemble d'&eacute;chantillon pr&eacute;sente des fissures de surface de #2# 30 &micro;m estimez<br />la contrainte &agrave; rupture en traction Rm=$1$ MPa.</p>"]
[null,{"$f":"CONCATENATE(\" rupture en traction Rm=\",R1.ResMeca_AlO,\" MPa.</p>\")","v":" rupture en traction Rm={2:NUMERICAL:=1.62E+02:4.86E+01} MPa.</p>"},"Al2O3 à une ténacité de KIC proche de #i# 3MPa. m1/2. Un ensemble d'échantillon présente des fissures de surface de #i# 30 µm estimez"]
[null,null,"la contrainte à rupture en traction Rm=$1$ MPa.",null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Si la ténacité $Al_2O_3$ (KIC) est proche de \",V1.KIC_AlO,\" \\MpaRac{}, et qu'un échantillon présente un ensemble des fissures de surface de \",V2.Profond_AlO,\" µm estimez la contrainte à\")","v":"Si la ténacité $Al_2O_3$ (KIC) est proche de 2.4 \\MpaRac{}, et qu'un échantillon présente un ensemble des fissures de surface de 70 µm estimez la contrainte à"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\" rupture en traction Rm= \\formsol{$\\sigma = K_{IC} / \\sqrt{\\pi a}$} \\minisol{\",ROUND(F6,0),\"} MPa.\")","v":" rupture en traction Rm= \\formsol{$\\sigma = K_{IC} / \\sqrt{\\pi a}$} \\minisol{162} MPa."}]
[null,{"$f":"CONCATENATE(\"\")","v":""}]
[null,{"$f":"CONCATENATE(\"\")","v":""}]
[null,{"$f":"CONCATENATE(\"\")","v":""}]

{"sheet":"Tenac_Beton","index":6,"n_rows":22,"n_cols":79,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["catégorie_Btn","Tenac_Beton",{"$f":"CONCATENATE(\"    <!--  question XLQ \", titre_Btn, \"-->\")","v":"    <!--  question XLQ Tenac_Beton_Btn-->"},null,null,"Valeur Mini_Btn","Valeur Maxi_Btn","Sig. Digit_Btn","Val Choix_Btn"]
[null,"Tenac_Beton_Btn",{"$f":"CONCATENATE(\"    <question type=\",CHAR(34),\"category\",CHAR(34),\"><category><text>\", categorie_Btn,\"</text></category></question>)\")","v":"    <question type=\"category\"><category><text>Tenac_Beton</text></category></question>)"},null,"V1.Module_Btn",60,75,0,{"$f":"RANDBETWEEN(ValMini_Btn*10^-SigDig_Btn, ValMaxi_Btn*10^-SigDig_Btn)/10^-SigDig_Btn","v":71},"Gpa",50]
["Tag_Btn","Tenac_Beton_Btn","    <question type=\"cloze\">",null,"V2.Res_Meca_Btn",10,30,0,{"$f":"RANDBETWEEN(ValMini_Btn*10^-SigDig_Btn, ValMaxi_Btn*10^-SigDig_Btn)/10^-SigDig_Btn","v":15},"Mpa",6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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>Un b&eacute;ton poss&egrave;de un module E = #1# 50 GPa. En traction, on observe un comportement fragile et une rupture<br />pour une contrainte de #1# 6 MPa. Sachant que la longueur des plus grandes fissures au sein de ce<br />mat&eacute;riau est proche de #3# 7mm, d&eacute;terminer la t&eacute;nacit&eacute; de la matrice ciment&eacute;e. R&eacute;ponse : $1$ MPa. m1/2.</p><p><p>&nbsp;</p><p>"]
["idnumber_Btn",{"$f":"TEXT(NOW(),\"aammjj-hhmmss.00\")","v":"210710-210925.17"},{"$f":"CONCATENATE(\"        <name><text>\", titre_Btn, \"</text></name>\")","v":"        <name><text>Tenac_Beton_Btn</text></name>"},null,"V3.Long_Fiss_Btn",0.5,2,-1,{"$f":"RANDBETWEEN(ValMini_Btn*10^-SigDig_Btn, ValMaxi_Btn*10^-SigDig_Btn)/10^-SigDig_Btn","v":1.4},"mm",7]
["points_Btn",1,"        <questiontext format=\"html\">"]
["tolérance_Btn",0.1,{"$f":"CONCATENATE(\"            <text><![CDATA[<p>\", question_Btn, \"</p>]]></text>\")","v":"            <text><![CDATA[<p> Un b&eacute;ton poss&egrave;de un module E = 71 GPa. En traction, on observe un comportement fragile et une rupture<br />pour une contrainte de 15 MPa. Sachant que la longueur des plus grandes fissures au sein de ce<br />mat&eacute;riau est proche de 1.4 mm, d&eacute;terminer la t&eacute;nacit&eacute; de la matrice ciment&eacute;e. R&eacute;ponse : {2:NUMERICAL:=7.03E-01:7.03E-02} MPa. m1/2.</p><p><p>&nbsp;</p>]]></text>"},null,null,"Cible_Btn","Toler_Btn","PointsQuestion_Btn",null,null,"Attention MPa racine(m)"]
["penalité_Btn",0.1,"        </questiontext>",null,"R1.Tenacite_Btn",{"$f":"V2.Res_Meca_Btn*SQRT(PI()*V3.Long_Fiss_Btn/2/1000)","v":0.7034208149752128},{"$f":" tolerance_Btn*ValMini_Btn","v":7.0342081497521289E-2},2,{"$f":"CONCATENATE(\"{\",PointsQuestion_Btn,\":NUMERICAL:=\",TEXT(Cible_Btn,\"0.00E+00\"),\":\",TEXT(ABS(Tolere_Btn),\"0.00E+00\"),\"}\")","v":"{2:NUMERICAL:=7.03E-01:7.03E-02}"}]
["feedback_Btn","_",{"$f":"CONCATENATE(\"        <defaultgrade>\",points_Btn,\"</defaultgrade><generalfeedback><text>\",feedback_Btn,\"</text></generalfeedback><penalty>\",penalty_Btn,\"</penalty><hidden>0</hidden>)\")","v":"        <defaultgrade>1</defaultgrade><generalfeedback><text>_</text></generalfeedback><penalty>0.1</penalty><hidden>0</hidden>)"},null,null,null,null,{"$f":"SUM(F7:H7,F2:H4)","v":179.27376289647273}]
["Cellule vides_Btn",{"$f":"COUNTBLANK(B1:B8)","v":0},{"$f":"CONCATENATE(\"        <idnumber>\",idnumber_Btn,\"</idnumber><tags><tag><text>\",Tag_Btn,\"</text></tag></tags>\")","v":"        <idnumber>210710-210925.17</idnumber><tags><tag><text>Tenac_Beton_Btn</text></tag></tags>"}]
["question format HTML_Btn",{"$f":"CONCATENATE(\" \",B19,B20,B21,B22)","v":" Un b&eacute;ton poss&egrave;de un module E = 71 GPa. En traction, on observe un comportement fragile et une rupture<br />pour une contrainte de 15 MPa. Sachant que la longueur des plus grandes fissures au sein de ce<br />mat&eacute;riau est proche de 1.4 mm, d&eacute;terminer la t&eacute;nacit&eacute; de la matrice ciment&eacute;e. R&eacute;ponse : {2:NUMERICAL:=7.03E-01:7.03E-02} MPa. m1/2.</p><p><p>&nbsp;"},"    </question>"]
["Repere Var Rep","_Btn"]
["HTML File ",{"$f":"CONCATENATE(categorie_Btn,\"_HTML.txt\")","v":"Tenac_Beton_HTML.txt"}]
["Valide ? ",{"$f":"ISNUMBER(H8)","v":true}]
["https://html-online.com/editor/"]
[null,null,5]
["Var : ","#",3]
["Res : ","$",1]
[]
[null,{"$f":"CONCATENATE(\"Un b&eacute;ton poss&egrave;de un module E = \",V1.Module_Btn,\" GPa. En traction, on observe un comportement fragile et une rupture<br />pour une contrainte de \",V2.Res_Meca_Btn,\" MPa. Sachant que la longueur des plus grandes\")","v":"Un b&eacute;ton poss&egrave;de un module E = 71 GPa. En traction, on observe un comportement fragile et une rupture<br />pour une contrainte de 15 MPa. Sachant que la longueur des plus grandes"},"<p>Un b&eacute;ton poss&egrave;de un module E = #1# 50 GPa. En traction, on observe un comportement fragile et une rupture<br />pour une contrainte de #1# 6 MPa. Sachant que la longueur des plus grandes fissures au sein de ce<br />mat&eacute;riau est proche de #3# 7mm, d&eacute;terminer la t&eacute;nacit&eacute; de la matrice ciment&eacute;e. R&eacute;ponse : $1$ MPa. m1/2.</p>"]
[null,{"$f":"CONCATENATE(\" fissures au sein de ce<br />mat&eacute;riau est proche de \",V3.Long_Fiss_Btn,\" mm, d&eacute;terminer la t&eacute;nacit&eacute; de la matrice ciment&eacute;e. R&eacute;ponse : \",R1.Tenacite_Btn,\" MPa. m1/2.</p><p><p>&nbsp;\")","v":" fissures au sein de ce<br />mat&eacute;riau est proche de 1.4 mm, d&eacute;terminer la t&eacute;nacit&eacute; de la matrice ciment&eacute;e. R&eacute;ponse : {2:NUMERICAL:=7.03E-01:7.03E-02} MPa. m1/2.</p><p><p>&nbsp;"},"<p>&nbsp;</p>"]
[null,{"$f":"CONCATENATE(\"\")","v":""}]
[null,{"$f":"CONCATENATE(\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Un béton possède un module E = \",V1.Module_Btn,\" GPa. En traction, on observe un comportement fragile et une rupture pour une contrainte de \",V2.Res_Meca_Btn,\" MPa. Sachant que la longueur des plus grandes fissures au sein de ce matériau est proche de \",V3.Long_Fiss_Btn,\" mm, déterminer la ténacité de la matrice cimentée. Réponse : \\formsol{$ K_{IC} = \\sigma  \\sqrt{\\pi a}$}  \\minisol{\",ROUND(F7,1),\"} \\MpaRac{}.\")","v":"Un béton possède un module E = 71 GPa. En traction, on observe un comportement fragile et une rupture pour une contrainte de 15 MPa. Sachant que la longueur des plus grandes fissures au sein de ce matériau est proche de 1.4 mm, déterminer la ténacité de la matrice cimentée. Réponse : \\formsol{$ K_{IC} = \\sigma  \\sqrt{\\pi a}$}  \\minisol{0.7} \\MpaRac{}."}]

{"sheet":"Pizza","index":7,"n_rows":40,"n_cols":79,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["catégorie_Piz","Pizza",{"$f":"CONCATENATE(\"    <!--  question XLQ \", titre_Piz, \"-->\")","v":"    <!--  question XLQ Pizza_Piz-->"},null,null,"Valeur Mini_Piz","Valeur Maxi_Piz","Sig. Digit_Piz","Val Choix_Piz"]
[null,"Pizza_Piz",{"$f":"CONCATENATE(\"    <question type=\",CHAR(34),\"category\",CHAR(34),\"><category><text>\", categorie_Piz,\"</text></category></question>)\")","v":"    <question type=\"category\"><category><text>Pizza</text></category></question>)"},null,"V1.Rmt_Piz",50,100,0,{"$f":"RANDBETWEEN(ValMini_Piz*10^-SigDig_Piz, ValMaxi_Piz*10^-SigDig_Piz)/10^-SigDig_Piz","v":91},"MPa","Rm, TH",{"$f":"V4.E_Piz/10","v":7.5},"GPa",60]
["Tag_Piz","Pizza_Piz","    <question type=\"cloze\">",null,"V2.Rmc_Piz",250,400,1,400,"MPa","Kt",{"$f":"L2*1000/V1.Rmt_Piz","v":82.417582417582423},null,300,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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>Un four &agrave; gaz est muni d'une fen&ecirc;tre afin de permettre un contr&ocirc;le visuel de l'&eacute;tats de cuisson. Cette fen&ecirc;tre pr&eacute;sente un &eacute;l&eacute;ment fragile sous la forme d'un disque &eacute;pais de verre, dont le montage le laisse libre de se dilater radialement. Lors des mises en marche du four, la face interne du disque (celle &agrave; l'int&eacute;rieur du four) subit une brusque &eacute;l&eacute;vation de temp&eacute;rature, alors que la face externe reste &agrave; la temp&eacute;rature ambiante de 20&deg;C. Le verre utilis&eacute; a les propri&eacute;t&eacute;s m&eacute;caniques et physiques suivantes :</p><ul><li>Rmt =#1# MPa (traction)</li><li>Rmc = #2# MPa (compression)</li><li>nu = #3#</li><li>E = #4# GPa</li><li>alpha = #5#</li><li>KIC = #6# MPa.m1/2</li></ul><p>1. Quel est le facteur de concentration de contrainte associ&eacute; au d&eacute;faut le plus s&eacute;v&egrave;re dans le mat&eacute;riau ? $1$ [SD]</p><p>2. Quelle temp&eacute;rature maximale peut atteindre le disque sans risquer de se rompre au cours d'un choc thermique infiniment s&eacute;v&egrave;re ? $2$ &deg;C</p><p>Les faces du disque sont ray&eacute;es au cours de son utilisation, par des fissures aigu&euml;s. La profondeur de ces fissures est de #7# &micro;m.</p><p>3. Quelle est alors la r&eacute;sistance &agrave; la traction du verre ray&eacute; ? $3$ MPa</p><p>4. Quelle temp&eacute;rature maximale peut atteindre ce disque ray&eacute; au cours d'un choc thermique infiniment s&eacute;v&egrave;re ? $4$ C</p>"]
["idnumber_Piz",{"$f":"TEXT(NOW(),\"aammjj-hhmmss.00\")","v":"210710-210925.17"},{"$f":"CONCATENATE(\"        <name><text>\", titre_Piz, \"</text></name>\")","v":"        <name><text>Pizza_Piz</text></name>"},null,"V3.nu_Piz",0.15,0.5,-2,0.5,null,"@RT",20,"°C",0.27,null,null,"Kt =",{"$f":"(V4.E_Piz*1000)/(10*V1.Rmt_Piz)","v":82.417582417582423}]
["points_Piz",1,"        <questiontext format=\"html\">",null,"V4.E_Piz",65,75,0,75,"GPa",null,null,null,70]
["tolérance_Piz",0.1,{"$f":"CONCATENATE(\"            <text><![CDATA[<p>\", question_Piz, \"</p>]]></text>\")","v":"            <text><![CDATA[<p> Un four &agrave; gaz est muni d'une fen&ecirc;tre afin de permettre un contr&ocirc;le visuel de l'&eacute;tats de cuisson. Cette fen&ecirc;tre pr&eacute;sente un &eacute;l&eacute;ment fragile sous la forme d'un disque &eacute;pais de verre, dont le montage le laisse libre de se dilater radialement. Lors des mises en marche du four, la face interne du disque (celle &agrave; l'int&eacute;rieur du four) subit une brusque &eacute;l&eacute;vation de temp&eacute;rature, alors que la face externe reste &agrave; la temp&eacute;rature ambiante de 20&deg;C. Le verre utilis&eacute; a les propri&eacute;t&eacute;s m&eacute;caniques et physiques suivantes :</p><ul><li>Rmt =91 MPa (traction)</li><li>Rmc = 400 MPa (compression)</li><li>nu = 0.5</li><li>E = 75 GPa</li><li>alpha = 6&micro;m / m / K</li><li>KIC = 0.4 MPa.m1/2</li></ul><p>1. Quel est le facteur de concentration de contrainte associ&eacute; au d&eacute;faut le plus s&eacute;v&egrave;re dans le mat&eacute;riau ? {1:NUMERICAL:=8.24E+01:8.24E+00} [SD]</p><p>2. Quelle temp&eacute;rature maximale peut atteindre le disque sans risquer de se rompre au cours d'un choc thermique infiniment s&eacute;v&egrave;re ? {2:NUMERICAL:=2.22E+02:2.22E+01} &deg;C</p><p>Les faces du disque sont ray&eacute;es au cours de son utilisation, par des fissures aigu&euml;s. La profondeur de ces fissures est de 40 &micro;m.</p><p>3. Quelle est alors la r&eacute;sistance &agrave; la traction du verre ray&eacute; ? {1:NUMERICAL:=3.57E+01:3.57E+00} MPa</p><p>4. Quelle temp&eacute;rature maximale peut atteindre ce disque ray&eacute; au cours d'un choc thermique infiniment s&eacute;v&egrave;re ? {3:NUMERICAL:=9.93E+01:9.93E+00} &deg;C</p>]]></text>"},null,"V5.alpha_Piz",5,8,0,6,"µm/ m / K",null,null,null,5]
["penalité_Piz",0.1,"        </questiontext>",null,"V6.KIC_Piz",0.3,1.5,-1,0.4,"Mpa m1/2",null,null,null,0.8]
["feedback_Piz","_",{"$f":"CONCATENATE(\"        <defaultgrade>\",points_Piz,\"</defaultgrade><generalfeedback><text>\",feedback_Piz,\"</text></generalfeedback><penalty>\",penalty_Piz,\"</penalty><hidden>0</hidden>)\")","v":"        <defaultgrade>1</defaultgrade><generalfeedback><text>_</text></generalfeedback><penalty>0.1</penalty><hidden>0</hidden>)"},null,"V7.profond_Piz",10,50,1,40,"µm",null,null,null,80]
["Cellule vides_Piz",{"$f":"COUNTBLANK(B1:B8)","v":0},{"$f":"CONCATENATE(\"        <idnumber>\",idnumber_Piz,\"</idnumber><tags><tag><text>\",Tag_Piz,\"</text></tag></tags>\")","v":"        <idnumber>210710-210925.17</idnumber><tags><tag><text>Pizza_Piz</text></tag></tags>"},null,null,null,null,null,0]
["question format HTML_Piz",{"$f":"CONCATENATE(\" \",B19,B20,B21,B22,B23,B24,B25,B26,B27,B28,B29,B30,B31,B32,B33,B34)","v":" Un four &agrave; gaz est muni d'une fen&ecirc;tre afin de permettre un contr&ocirc;le visuel de l'&eacute;tats de cuisson. Cette fen&ecirc;tre pr&eacute;sente un &eacute;l&eacute;ment fragile sous la forme d'un disque &eacute;pais de verre, dont le montage le laisse libre de se dilater radialement. Lors des mises en marche du four, la face interne du disque (celle &agrave; l'int&eacute;rieur du four) subit une brusque &eacute;l&eacute;vation de temp&eacute;rature, alors que la face externe reste &agrave; la temp&eacute;rature ambiante de 20&deg;C. Le verre utilis&eacute; a les propri&eacute;t&eacute;s m&eacute;caniques et physiques suivantes :</p><ul><li>Rmt =91 MPa (traction)</li><li>Rmc = 400 MPa (compression)</li><li>nu = 0.5</li><li>E = 75 GPa</li><li>alpha = 6&micro;m / m / K</li><li>KIC = 0.4 MPa.m1/2</li></ul><p>1. Quel est le facteur de concentration de contrainte associ&eacute; au d&eacute;faut le plus s&eacute;v&egrave;re dans le mat&eacute;riau ? {1:NUMERICAL:=8.24E+01:8.24E+00} [SD]</p><p>2. Quelle temp&eacute;rature maximale peut atteindre le disque sans risquer de se rompre au cours d'un choc thermique infiniment s&eacute;v&egrave;re ? {2:NUMERICAL:=2.22E+02:2.22E+01} &deg;C</p><p>Les faces du disque sont ray&eacute;es au cours de son utilisation, par des fissures aigu&euml;s. La profondeur de ces fissures est de 40 &micro;m.</p><p>3. Quelle est alors la r&eacute;sistance &agrave; la traction du verre ray&eacute; ? {1:NUMERICAL:=3.57E+01:3.57E+00} MPa</p><p>4. Quelle temp&eacute;rature maximale peut atteindre ce disque ray&eacute; au cours d'un choc thermique infiniment s&eacute;v&egrave;re ? {3:NUMERICAL:=9.93E+01:9.93E+00} &deg;C"},"    </question>",null,null,"Cible_Piz","Toler_Piz","PointsQuestion_Piz"]
["Repere Var Rep","_Piz",null,null,"R1.ConcContr_Piz",{"$f":"L3","v":82.417582417582423},{"$f":" tolerance_Piz*ValMini_Piz","v":8.2417582417582427},1,{"$f":"CONCATENATE(\"{\",PointsQuestion_Piz,\":NUMERICAL:=\",TEXT(Cible_Piz,\"0.00E+00\"),\":\",TEXT(ABS(Tolere_Piz),\"0.00E+00\"),\"}\")","v":"{1:NUMERICAL:=8.24E+01:8.24E+00}"},null,null,null,null,116.66666666666667]
["HTML File ","Enonce_Pizza.txt",null,null,"R2.DeltaT_Non_Ray_Piz",{"$f":"RoomTemp+V1.Rmt_Piz/(V4.E_Piz*1000*V5.alpha_Piz*0.000001)","v":222.22222222222223},{"$f":" tolerance_Piz*ValMini_Piz","v":22.222222222222225},2,{"$f":"CONCATENATE(\"{\",PointsQuestion_Piz,\":NUMERICAL:=\",TEXT(Cible_Piz,\"0.00E+00\"),\":\",TEXT(ABS(Tolere_Piz),\"0.00E+00\"),\"}\")","v":"{2:NUMERICAL:=2.22E+02:2.22E+01}"},null,null,null,null,191.42857142857144]
["Valide ? ",{"$f":"AND(ISNUMBER(F16),G16,H16,G17,H17)","v":false},null,null,"R3.Rm_T_Ray_Piz",{"$f":"V6.KIC_Piz/(SQRT(PI()*V7.profond_Piz*0.000001))","v":35.682482323055424},{"$f":" tolerance_Piz*ValMini_Piz","v":3.5682482323055424},1,{"$f":"CONCATENATE(\"{\",PointsQuestion_Piz,\":NUMERICAL:=\",TEXT(Cible_Piz,\"0.00E+00\"),\":\",TEXT(ABS(Tolere_Piz),\"0.00E+00\"),\"}\")","v":"{1:NUMERICAL:=3.57E+01:3.57E+00}"},null,null,{"$f":"RoomTemp+F13/(V4.E_Piz*1000*V5.alpha_Piz*0.000001)","v":99.294405162345399},null,50.462650440403202]
["https://html-online.com/editor/ ",null,null,null,"R4.DeltaT_Ray_Piz",{"$f":"MIN(F12,L13)","v":99.294405162345399},{"$f":" tolerance_Piz*ValMini_Piz","v":9.9294405162345409},3,{"$f":"CONCATENATE(\"{\",PointsQuestion_Piz,\":NUMERICAL:=\",TEXT(Cible_Piz,\"0.00E+00\"),\":\",TEXT(ABS(Tolere_Piz),\"0.00E+00\"),\"}\")","v":"{3:NUMERICAL:=9.93E+01:9.93E+00}"},null,null,null,null,50.462650440403202]
[null,null,9]
["Var : ","#",7,null,null,{"$f":"SUM(F11:H14)","v":490.57836133772605},{"$f":"F12<1000","v":true},{"$f":"F12>150","v":true}]
["Res : ","$",4,null,null,null,{"$f":"L13<1000","v":true},{"$f":"L13>100","v":false}]
[null,null,null,null,null,null,null,null,null," "]
[null,{"$f":"CONCATENATE(\"Un four &agrave; gaz est muni d'une fen&ecirc;tre afin de permettre un contr&ocirc;le visuel de l'&eacute;tats de cuisson. Cette fen&ecirc;tre pr&eacute;sente un &eacute;l&eacute;ment fragile sous la\")","v":"Un four &agrave; gaz est muni d'une fen&ecirc;tre afin de permettre un contr&ocirc;le visuel de l'&eacute;tats de cuisson. Cette fen&ecirc;tre pr&eacute;sente un &eacute;l&eacute;ment fragile sous la"},"<p>Un four &agrave; gaz est muni d'une fen&ecirc;tre afin de permettre un contr&ocirc;le visuel de l'&eacute;tats de cuisson. Cette fen&ecirc;tre pr&eacute;sente un &eacute;l&eacute;ment fragile sous la forme d'un disque &eacute;pais de verre, dont le montage le laisse libre de se dilater radialement. Lors des mises en marche du four, la face interne du disque (celle &agrave; l'int&eacute;rieur du four) subit une brusque &eacute;l&eacute;vation de temp&eacute;rature, alors que la face externe reste &agrave; la temp&eacute;rature ambiante de 20&deg;C. Le verre utilis&eacute; a les propri&eacute;t&eacute;s m&eacute;caniques et physiques suivantes :</p>",null,null,null,null,null,null," "]
[null,{"$f":"CONCATENATE(\" forme d'un disque &eacute;pais de verre, dont le montage le laisse libre de se dilater radialement. Lors des mises en marche du four, la face interne du disque (celle &agrave; l'int&eacute;rieur du four)\")","v":" forme d'un disque &eacute;pais de verre, dont le montage le laisse libre de se dilater radialement. Lors des mises en marche du four, la face interne du disque (celle &agrave; l'int&eacute;rieur du four)"},"<ul>",null,null,null,null,null,null," "]
[null,{"$f":"CONCATENATE(\" subit une brusque &eacute;l&eacute;vation de temp&eacute;rature, alors que la face externe reste &agrave; la temp&eacute;rature ambiante de 20&deg;C. Le verre utilis&eacute; a les propri&eacute;t&eacute;s\")","v":" subit une brusque &eacute;l&eacute;vation de temp&eacute;rature, alors que la face externe reste &agrave; la temp&eacute;rature ambiante de 20&deg;C. Le verre utilis&eacute; a les propri&eacute;t&eacute;s"},"<li>Rmt =#1# MPa (traction)</li>",null,null,null,null,null,null," "]
[null,{"$f":"CONCATENATE(\" m&eacute;caniques et physiques suivantes :</p><ul><li>Rmt =\",V1.Rmt_Piz,\" MPa (traction)</li><li>Rmc = \",V2.Rmc_Piz,\" MPa (compression)</li><li>nu = \",V3.nu_Piz,\"</li><li>E = \",V4.E_Piz,\" GPa</li><li>alpha = \",V5.alpha_Piz,\"&micro;m / m / K</li><li>KIC = \",V6.KIC_Piz,\" MPa.m1/2</li></ul><p>1.\")","v":" m&eacute;caniques et physiques suivantes :</p><ul><li>Rmt =91 MPa (traction)</li><li>Rmc = 400 MPa (compression)</li><li>nu = 0.5</li><li>E = 75 GPa</li><li>alpha = 6&micro;m / m / K</li><li>KIC = 0.4 MPa.m1/2</li></ul><p>1."},"<li>Rmc = #2# MPa (compression)</li>",null,null,null,null,null,null," "]
[null,{"$f":"CONCATENATE(\" Quel est le facteur de concentration de contrainte associ&eacute; au d&eacute;faut le plus s&eacute;v&egrave;re dans le mat&eacute;riau ? \",R1.ConcContr_Piz,\" [SD]</p><p>2. Quelle temp&eacute;rature maximale peut atteindre\")","v":" Quel est le facteur de concentration de contrainte associ&eacute; au d&eacute;faut le plus s&eacute;v&egrave;re dans le mat&eacute;riau ? {1:NUMERICAL:=8.24E+01:8.24E+00} [SD]</p><p>2. Quelle temp&eacute;rature maximale peut atteindre"},"<li>nu = #3#</li>",null,null,null,null,null,null," "]
[null,{"$f":"CONCATENATE(\" le disque sans risquer de se rompre au cours d'un choc thermique infiniment s&eacute;v&egrave;re ? \",R2.DeltaT_Non_Ray_Piz,\" &deg;C</p><p>Les faces du disque sont ray&eacute;es au cours de son utilisation, par des fissures\")","v":" le disque sans risquer de se rompre au cours d'un choc thermique infiniment s&eacute;v&egrave;re ? {2:NUMERICAL:=2.22E+02:2.22E+01} &deg;C</p><p>Les faces du disque sont ray&eacute;es au cours de son utilisation, par des fissures"},"<li>E = #4# GPa</li>",null,null,null,null,null,null," ","Un four à gaz est muni d'une fenêtre afin de permettre un contrôle visuel de l'états de cuisson. Cette fenêtre présente un élément fragile sous la forme d'un disque épais de verre, dont le montage le laisse libre de se dilater radialement. Lors des mises en marche du four, la face interne du disque (celle à l'intérieur du four) subit une brusque élévation de température, alors que la face externe reste à la température ambiante de 20°C. Le verre utilisé a les propriétés mécaniques et physiques suivantes :"]
[null,{"$f":"CONCATENATE(\" aigu&euml;s. La profondeur de ces fissures est de \",V7.profond_Piz,\" &micro;m.</p><p>3. Quelle est alors la r&eacute;sistance &agrave; la traction du verre ray&eacute; ? \",R3.Rm_T_Ray_Piz,\" MPa</p><p>4. Quelle temp&eacute;rature maximale\")","v":" aigu&euml;s. La profondeur de ces fissures est de 40 &micro;m.</p><p>3. Quelle est alors la r&eacute;sistance &agrave; la traction du verre ray&eacute; ? {1:NUMERICAL:=3.57E+01:3.57E+00} MPa</p><p>4. Quelle temp&eacute;rature maximale"},"<li>alpha = #5#</li>",null,null,null,null,null,null," "]
[null,{"$f":"CONCATENATE(\" peut atteindre ce disque ray&eacute; au cours d'un choc thermique infiniment s&eacute;v&egrave;re ? \",R4.DeltaT_Ray_Piz,\" &deg;C\")","v":" peut atteindre ce disque ray&eacute; au cours d'un choc thermique infiniment s&eacute;v&egrave;re ? {3:NUMERICAL:=9.93E+01:9.93E+00} &deg;C"},"<li>KIC = #6# MPa.m1/2</li>",null,null,null,null,null,null," ",{"$f":"CONCATENATE(\"Rmt =\",ROUND(V1.Rmt_Piz,0),\" MPa (traction)\\\\\")","v":"Rmt =91 MPa (traction)\\\\"}]
[null,{"$f":"CONCATENATE(\"\")","v":""},"</ul>",null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Rmc = \",ROUND(V2.Rmc_Piz,0),\" MPa (compression)\\\\\")","v":"Rmc = 400 MPa (compression)\\\\"}]
[null,"","<p>1. Quel est le facteur de concentration de contrainte associ&eacute; au d&eacute;faut le plus s&eacute;v&egrave;re dans le mat&eacute;riau ? $1$ [SD]</p>",null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"$\\nu$ = \",ROUND(V3.nu_Piz,2),\" [SD]\\\\\")","v":"$\\nu$ = 0.5 [SD]\\\\"}]
[null,"","<p>2. Quelle temp&eacute;rature maximale peut atteindre le disque sans risquer de se rompre au cours d'un choc thermique infiniment s&eacute;v&egrave;re ? $2$ &deg;C</p>",null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"E = \",ROUND(V4.E_Piz,0),\" GPa\\\\\")","v":"E = 75 GPa\\\\"}]
[null,"","<p>Les faces du disque sont ray&eacute;es au cours de son utilisation, par des fissures aigu&euml;s. La profondeur de ces fissures est de #7# &micro;m.</p>",null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"$\\alpha$ = \",ROUND(V5.alpha_Piz,0),\" µm/m/K\\\\\")","v":"$\\alpha$ = 6 µm/m/K\\\\"}]
[null,"","<p>3. Quelle est alors la r&eacute;sistance &agrave; la traction du verre ray&eacute; ? $3$ MPa</p>",null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"$K_{IC}$ = \",ROUND(V6.KIC_Piz,0),\" \\MpaRac{}\\\\\")","v":"$K_{IC}$ = 0 \\MpaRac{}\\\\"}]
[null,"","<p>4. Quelle temp&eacute;rature maximale peut atteindre ce disque ray&eacute; au cours d'un choc thermique infiniment s&eacute;v&egrave;re ? $4$ C</p>"]
[null,"","<p>&nbsp;</p>",null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"1. Quel est le facteur de concentration de contrainte associé au défaut le plus sévère dans le matériau ? \\formsol{$\\frac{E_Piz*1000}{{10*Rmt}}$} \\minisol{\",ROUND(F11,0),\"} [SD]\\\\\")","v":"1. Quel est le facteur de concentration de contrainte associé au défaut le plus sévère dans le matériau ? \\formsol{$\\frac{E_Piz*1000}{{10*Rmt}}$} \\minisol{82} [SD]\\\\"}]
[null,"","<p>&nbsp;</p>",null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"2. Quelle température maximale peut atteindre le disque sans risquer de se rompre au cours d'un choc thermique infiniment sévère ? \\formsol{TR + Rm1 / E $\\alpha$} \\minisol{\",ROUND(F12,0),\"} °C\\\\\")","v":"2. Quelle température maximale peut atteindre le disque sans risquer de se rompre au cours d'un choc thermique infiniment sévère ? \\formsol{TR + Rm1 / E $\\alpha$} \\minisol{222} °C\\\\"}]
[null,null,"Les faces du disque sont rayées au cours de son tulisation, par des fissures aiguës. La profondeur de ces fissures est de #7# µm.",null,null,null,"KIC",1.3,"Mpa.m1/2",null,{"$f":"CONCATENATE(\"Les faces du disque sont rayées au cours de son utilisation, par des fissures aiguës. La profondeur de ces fissures est de \",ROUND(V7.profond_Piz,0),\"  µm.\\\\\")","v":"Les faces du disque sont rayées au cours de son utilisation, par des fissures aiguës. La profondeur de ces fissures est de 40  µm.\\\\"}]
[null,null,null,null,null,null,"Profond",10,"µm",null,{"$f":"CONCATENATE(\"3. Quelle est alors la résistance à la traction du verre rayé ? \\formsol{$Rm2=\\frac{K_{IC}}{\\sqrt{\\pi a}}$} \\minisol{\",ROUND(F13,0),\"} MPa\\\\\")","v":"3. Quelle est alors la résistance à la traction du verre rayé ? \\formsol{$Rm2=\\frac{K_{IC}}{\\sqrt{\\pi a}}$} \\minisol{36} MPa\\\\"}]
[null,null,null,null,null,null,null,{"$f":"H35/(SQRT(PI()*H36*0.000001))","v":231.93613509986028},null,null,{"$f":"CONCATENATE(\"4. Quelle température maximale peut atteindre ce disque rayé au cours d'un choc thermique infiniment sévère ? \\formsol{min(\\formsol{TR + Rm1 / E $\\alpha$} ; \\formsol{TR + Rm2 / E $\\alpha$})} \\minisol{\",ROUND(F14,0),\"} °C\\\\\")","v":"4. Quelle température maximale peut atteindre ce disque rayé au cours d'un choc thermique infiniment sévère ? \\formsol{min(\\formsol{TR + Rm1 / E $\\alpha$} ; \\formsol{TR + Rm2 / E $\\alpha$})} \\minisol{99} °C\\\\"}]
[null,null,"Quelle est alors la résistance à la traction du verre rayé ? $3$ MPa"]
[]
[null,null,"Quelle  température  maximale  peut  atteindre  ce  disque  rayé  au  cours  d'un  choc  thermique  infiniment sévère ? $4$ C"]

{"sheet":"Traction","index":8,"n_rows":44,"n_cols":79,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["catégorie_Tra","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":110},"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":3.6666666666666665},{"$f":"V1.Long_Tra/20","v":5.5},0,4,"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-210925.17"},{"$f":"CONCATENATE(\"        <name><text>\", titre_Tra, \"</text></name>\")","v":"        <name><text>Traction_Tra</text></name>"},null,"V2.Red_Dia_Tra",3,4,-1,3.6,"µ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,6,"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 4 mm de diam&egrave;tre et de 110 mm de <br />longueur. On observe que : le diam&egrave;tre s'est r&eacute;duit de 3.6 &micro;m sous une charge de 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 36 kN et un allongement total de 1.64 mm. La force maximale que peut supporter <br />l'&eacute;prouvette est de 39 kN.</p><p><p>a) Quelle est la limite d'&eacute;lasticit&eacute; (contrainte) ? R&eacute;ponse : {1:NUMERICAL:=2.86E+03:2.86E+02}MPa</p><p><p>b) Quelle est la r&eacute;sistance &agrave; la traction de ce mat&eacute;riau? {2:NUMERICAL:=3.10E+03:3.10E+02} MPa</p><p><p>c) Quelle est la limite &eacute;lastique de d&eacute;formation  (en %) ? {2:NUMERICAL:=1.49E+00:1.49E-01}%</p><p><p>d) Quel est le module d'Young de ce mat&eacute;riau ? {3:NUMERICAL:=1.92E+05:1.92E+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:=2.14E+01:2.14E+00} J</p><p><p>&nbsp;</p><p></p>]]></text>"},null,"V4.Force_Elas_Tra",33,44,0,36,"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.64,"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":38},{"$f":"F8+15","v":53},0,39,"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-210925.17</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 4 mm de diam&egrave;tre et de 110 mm de <br />longueur. On observe que : le diam&egrave;tre s'est r&eacute;duit de 3.6 &micro;m sous une charge de 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 36 kN et un allongement total de 1.64 mm. La force maximale que peut supporter <br />l'&eacute;prouvette est de 39 kN.</p><p><p>a) Quelle est la limite d'&eacute;lasticit&eacute; (contrainte) ? R&eacute;ponse : {1:NUMERICAL:=2.86E+03:2.86E+02}MPa</p><p><p>b) Quelle est la r&eacute;sistance &agrave; la traction de ce mat&eacute;riau? {2:NUMERICAL:=3.10E+03:3.10E+02} MPa</p><p><p>c) Quelle est la limite &eacute;lastique de d&eacute;formation  (en %) ? {2:NUMERICAL:=1.49E+00:1.49E-01}%</p><p><p>d) Quel est le module d'Young de ce mat&eacute;riau ? {3:NUMERICAL:=1.92E+05:1.92E+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:=2.14E+01:2.14E+00} 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":2864.7889756541163},{"$f":" tolerance_Tra*ValMini_Tra","v":286.47889756541161},1,{"$f":"CONCATENATE(\"{\",PointsQuestion_Tra,\":NUMERICAL:=\",TEXT(Cible_Tra,\"0.00E+00\"),\":\",TEXT(ABS(Tolere_Tra),\"0.00E+00\"),\"}\")","v":"{1:NUMERICAL:=2.86E+03:2.86E+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":3103.5213902919591},310.35213902919594,2,"{2:NUMERICAL:=3.10E+03:3.10E+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":1.490909090909091},0.14909090909090911,2,"{2:NUMERICAL:=1.49E+00:1.49E-01}",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":192150.48007436143},19215.048007436144,3,"{3:NUMERICAL:=1.92E+05:1.92E+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":21.355699636694322},2.1355699636694321,4,"{4:NUMERICAL:=2.14E+01:2.14E+00}",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":3.9688000000000004E-5},null,null,{"$f":"SUM(F11:H16)","v":217967.80075393862}]
[]
[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 4 mm de diam&egrave;tre et de 110 mm de <br />longueur. On observe que : le diam&egrave;tre s'est r&eacute;duit de 3.6 &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 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 36 kN et un allongement total de 1.64"},"<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 39 kN.</p><p><p>a) Quelle est la limite d'&eacute;lasticit&eacute; (contrainte) ? R&eacute;ponse : {1:NUMERICAL:=2.86E+03:2.86E+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:=3.10E+03:3.10E+02} MPa</p><p><p>c) Quelle est la limite &eacute;lastique de d&eacute;formation  (en %) ? {2:NUMERICAL:=1.49E+00:1.49E-01}%</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:=1.92E+05:1.92E+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:=2.14E+01:2.14E+00} 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":1.490909090909091},{"$f":"F11","v":2864.7889756541163},null,null,null,null,null,":%s/{.*}/\\\\minisol{\";;\"}"]
[null,null,null,null,null,null,1,{"$f":"F12","v":3103.5213902919591},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.6 mm de diamètre et de 110 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.6 µm sous une charge de 6 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 36 kN et un allongement total de 1.64 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 4 mm de diamètre et de 110 mm de "},null,null,null,null,null,null,{"$f":"CONCATENATE(\"l'éprouvette est de \",V6.Force_Max_Tra,\" kN.\")","v":"l'éprouvette est de 39 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.6 µm sous une charge de 6 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{2865} 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 36 kN et un allongement total de 1.64 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{3104} 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 39 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{192150} 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{2865} 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{21J}"}]
[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{3104} 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{1.49}\\%\\\\"}]
[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{192200} 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{21.4} J"}]

{"sheet":"VerreSimple","index":9,"n_rows":32,"n_cols":79,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["catégorie_Vsi","VerreSimple",{"$f":"CONCATENATE(\"    <!--  question XLQ \", titre_Vsi, \"-->\")","v":"    <!--  question XLQ VerreSimple_Vsi-->"},null,null,"Valeur Mini_Vsi","Valeur Maxi_Vsi","Sig. Digit_Vsi","Val Choix_Vsi"]
[null,"VerreSimple_Vsi",{"$f":"CONCATENATE(\"    <question type=\",CHAR(34),\"category\",CHAR(34),\"><category><text>\", categorie_Vsi,\"</text></category></question>)\")","v":"    <question type=\"category\"><category><text>VerreSimple</text></category></question>)"},null,"V1.Module_Vsi",65,75,0,{"$f":"RANDBETWEEN(ValMini_Vsi*10^-SigDig_Vsi, ValMaxi_Vsi*10^-SigDig_Vsi)/10^-SigDig_Vsi","v":67},"Gpa",null,70]
["Tag_Vsi","VerreSimple_Vsi","    <question type=\"cloze\">",null,"V2.Rm_Vsi",50,90,0,{"$f":"RANDBETWEEN(ValMini_Vsi*10^-SigDig_Vsi, ValMaxi_Vsi*10^-SigDig_Vsi)/10^-SigDig_Vsi","v":67},"Mpa",null,70,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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>Mat&eacute;riau fragile, le verre ordinaire a un module d'Young E &eacute;gal &agrave; #1#GPa<br />1. Si le verre &eacute;tait un mat&eacute;riau parfait, quelle serait la valeur (en MPa) de sa r&eacute;sistance &agrave; la traction ? $1$ MPa \\formsol{$$} \\minisol{\"\";arrondi(I2;0);\"\"}<br />2. Quelle serait la d&eacute;formation (en %) que ce verre pourrait supporter avant de se rompre ? $2$ % \\formsol{$$} \\minisol{\"\";arrondi(I2;0);\"\"}</p><p><p>N'&eacute;tant pas un mat&eacute;riau parfait, le verre ordinaire a une r&eacute;sistance &agrave; la traction Rm proche de #2# MPa.</p><p><p>3. Quel est l'allongement &agrave; rupture d'un tel mat&eacute;riau ? $3$ % \\formsol{$$} \\minisol{\"\";arrondi(I2;0);\"\"}</p><p><p>4. Quelle est la valeur du facteur de concentration de contrainte Kt associ&eacute;e au micro d&eacute;faut le plus s&eacute;v&egrave;re qui existe dans ce verre ? $4$ \\formsol{$$} \\minisol{\"\";arrondi(I2;0);\"\"}</p><p><p>On observe en microscopie &eacute;l&eacute;ectronique des micro-d&eacute;fauts superficiels assimilables &agrave; des fissures semi-elliptiques dont la profondeur a = #3# &micro;m.<br />5. Quelle est la valeur (en nm) du rayon de courbure du micro-d&eacute;faut le plus s&eacute;v&egrave;re qui a entra&icirc;n&eacute; la rupture de l'&eacute;prouvette de traction ? $5$ \\formsol{$$} \\minisol{\"\";arrondi(I2;0);\"\"}</p><p><p>&nbsp;</p><p>N'étant pas un matériau parfait, le verre ordinaire a une résistance à la traction Rm proche de #2# MPa.<p>3. Quel est l'allongement à rupture d'un tel matériau ? $3$ % \\formsol{$$} \\minisol{;;}<p>4. Quelle est la valeur du facteur de concentration de contrainte Kt associée au micro défaut le plus sévère qui existe dans ce verre ? $4$ \\formsol{$$} \\minisol{;;}<p>On observe en microscopie éléectronique des micro-défauts superficiels assimilables à des fissures semi-elliptiques dont la profondeur a = #3# µm.<p>5. Quelle est la valeur (en nm) du rayon de courbure du micro-défaut le plus sévère qui a entraîné la rupture de l'éprouvette de traction ? $5$ \\formsol{$$} \\minisol{;;}<p>"]
["idnumber_Vsi",{"$f":"TEXT(NOW(),\"aammjj-hhmmss.00\")","v":"210710-210925.17"},{"$f":"CONCATENATE(\"        <name><text>\", titre_Vsi, \"</text></name>\")","v":"        <name><text>VerreSimple_Vsi</text></name>"},null,"V3.Profond_Vsi",0.1,2.7,-1,{"$f":"RANDBETWEEN(ValMini_Vsi*10^-SigDig_Vsi, ValMaxi_Vsi*10^-SigDig_Vsi)/10^-SigDig_Vsi","v":1.2},"µm",null,1]
["points_Vsi",1,"        <questiontext format=\"html\">",null,null,null,null,null,{"$f":"RANDBETWEEN(ValMini_Vsi*10^-SigDig_Vsi, ValMaxi_Vsi*10^-SigDig_Vsi)/10^-SigDig_Vsi","v":0}]
["tolérance_Vsi",0.05,{"$f":"CONCATENATE(\"            <text><![CDATA[<p>\", question_Vsi, \"</p>]]></text>\")","v":"            <text><![CDATA[<p> Mat&eacute;riau fragile, le verre ordinaire a un module d'Young E &eacute;gal &agrave; 67GPa<br />1. Si le verre &eacute;tait un mat&eacute;riau parfait, quelle serait la valeur (en MPa) de sa r&eacute;sistance &agrave; la traction ? {1:NUMERICAL:=6.70E+03:3.35E+02} MPa <br />2. Quelle serait la d&eacute;formation (en %) que ce verre pourrait supporter avant de se rompre ? {1:NUMERICAL:=1.00E+01:5.00E-01} % </p><p><p>N'&eacute;tant pas un mat&eacute;riau parfait, le verre ordinaire a une r&eacute;sistance &agrave; la traction Rm proche de 67 MPa.</p><p><p>3. Quel est l'allongement &agrave; rupture d'un tel mat&eacute;riau ? {1:NUMERICAL:=1.00E+00:5.00E-02}% .</p><p><p>4. Quelle est la valeur du facteur de concentration de contrainte Kt associ&eacute;e au micro d&eacute;faut le plus s&eacute;v&egrave;re qui existe dans ce verre ? {2:NUMERICAL:=1.00E+02:5.00E+00} </p><p><p>On observe en microscopie &eacute;l&eacute;ectronique des micro-d&eacute;fauts superficiels assimilables &agrave; des fissures semi-elliptiques dont la profondeur a = 1.2 &micro;m.<br />5. Quelle est la valeur (en nm) du rayon de courbure du micro-d&eacute;faut le plus s&eacute;v&egrave;re qui a entra&icirc;n&eacute; la rupture de l'&eacute;prouvette de traction ? {3:NUMERICAL:=4.80E-01:2.40E-02} </p><p><p>&nbsp;</p></p>]]></text>"},null,null,"Cible_Vsi","Toler_Vsi","PointsQuestion_Vsi"]
["penalité_Vsi",0.1,"        </questiontext>",null,"R1.RmTH_Vsi",{"$f":"V1.Module_Vsi*1000/10","v":6700},{"$f":" tolerance_Vsi*ValMini_Vsi","v":335},1,{"$f":"CONCATENATE(\"{\",PointsQuestion_Vsi,\":NUMERICAL:=\",TEXT(Cible_Vsi,\"0.00E+00\"),\":\",TEXT(ABS(Tolere_Vsi),\"0.00E+00\"),\"}\")","v":"{1:NUMERICAL:=6.70E+03:3.35E+02}"},null,null,7000]
["feedback_Vsi","_",{"$f":"CONCATENATE(\"        <defaultgrade>\",points_Vsi,\"</defaultgrade><generalfeedback><text>\",feedback_Vsi,\"</text></generalfeedback><penalty>\",penalty_Vsi,\"</penalty><hidden>0</hidden>)\")","v":"        <defaultgrade>1</defaultgrade><generalfeedback><text>_</text></generalfeedback><penalty>0.1</penalty><hidden>0</hidden>)"},null,"R2.eps_TH_Vsi",{"$f":"10","v":10},{"$f":" tolerance_Vsi*ValMini_Vsi","v":0.5},1,{"$f":"CONCATENATE(\"{\",PointsQuestion_Vsi,\":NUMERICAL:=\",TEXT(Cible_Vsi,\"0.00E+00\"),\":\",TEXT(ABS(Tolere_Vsi),\"0.00E+00\"),\"}\")","v":"{1:NUMERICAL:=1.00E+01:5.00E-01}"},null,null,0.1]
["Cellule vides_Vsi",{"$f":"COUNTBLANK(B1:B8)","v":0},{"$f":"CONCATENATE(\"        <idnumber>\",idnumber_Vsi,\"</idnumber><tags><tag><text>\",Tag_Vsi,\"</text></tag></tags>\")","v":"        <idnumber>210710-210925.17</idnumber><tags><tag><text>VerreSimple_Vsi</text></tag></tags>"},null,"R3.EpsVrai_Vsi",{"$f":"100*V2.Rm_Vsi/F7","v":1},{"$f":" tolerance_Vsi*ValMini_Vsi","v":0.05},1,{"$f":"CONCATENATE(\"{\",PointsQuestion_Vsi,\":NUMERICAL:=\",TEXT(Cible_Vsi,\"0.00E+00\"),\":\",TEXT(ABS(Tolere_Vsi),\"0.00E+00\"),\"}\")","v":"{1:NUMERICAL:=1.00E+00:5.00E-02}"},null,null,7.0000000000000007E-2]
["question format HTML_Vsi",{"$f":"CONCATENATE(\" \",B19,B20,B21,B22,B23,B24,B25,B26,B27,B28,B29,B30,B31,B32,B33,B34,B35,B36,B37,B38,B39)","v":" Mat&eacute;riau fragile, le verre ordinaire a un module d'Young E &eacute;gal &agrave; 67GPa<br />1. Si le verre &eacute;tait un mat&eacute;riau parfait, quelle serait la valeur (en MPa) de sa r&eacute;sistance &agrave; la traction ? {1:NUMERICAL:=6.70E+03:3.35E+02} MPa <br />2. Quelle serait la d&eacute;formation (en %) que ce verre pourrait supporter avant de se rompre ? {1:NUMERICAL:=1.00E+01:5.00E-01} % </p><p><p>N'&eacute;tant pas un mat&eacute;riau parfait, le verre ordinaire a une r&eacute;sistance &agrave; la traction Rm proche de 67 MPa.</p><p><p>3. Quel est l'allongement &agrave; rupture d'un tel mat&eacute;riau ? {1:NUMERICAL:=1.00E+00:5.00E-02}% .</p><p><p>4. Quelle est la valeur du facteur de concentration de contrainte Kt associ&eacute;e au micro d&eacute;faut le plus s&eacute;v&egrave;re qui existe dans ce verre ? {2:NUMERICAL:=1.00E+02:5.00E+00} </p><p><p>On observe en microscopie &eacute;l&eacute;ectronique des micro-d&eacute;fauts superficiels assimilables &agrave; des fissures semi-elliptiques dont la profondeur a = 1.2 &micro;m.<br />5. Quelle est la valeur (en nm) du rayon de courbure du micro-d&eacute;faut le plus s&eacute;v&egrave;re qui a entra&icirc;n&eacute; la rupture de l'&eacute;prouvette de traction ? {3:NUMERICAL:=4.80E-01:2.40E-02} </p><p><p>&nbsp;</p>"},"    </question>",null,"R4.KT_Vsi",{"$f":"(1000*V1.Module_Vsi)/(10*V2.Rm_Vsi)","v":100},{"$f":" tolerance_Vsi*ValMini_Vsi","v":5},2,{"$f":"CONCATENATE(\"{\",PointsQuestion_Vsi,\":NUMERICAL:=\",TEXT(Cible_Vsi,\"0.00E+00\"),\":\",TEXT(ABS(Tolere_Vsi),\"0.00E+00\"),\"}\")","v":"{2:NUMERICAL:=1.00E+02:5.00E+00}"},null,null,116]
["Repere Var Rep","_Vsi",null,null,"R5.rho_Vsi",{"$f":"1000000000*4*(V3.Profond_Vsi*0.000001)*((V2.Rm_Vsi/F7)^2)","v":0.48000000000000004},{"$f":" tolerance_Vsi*ValMini_Vsi","v":2.4000000000000004E-2},3,{"$f":"CONCATENATE(\"{\",PointsQuestion_Vsi,\":NUMERICAL:=\",TEXT(Cible_Vsi,\"0.00E+00\"),\":\",TEXT(ABS(Tolere_Vsi),\"0.00E+00\"),\"}\")","v":"{3:NUMERICAL:=4.80E-01:2.40E-02}"},null,null,0.3]
["HTML File ",{"$f":"CONCATENATE(categorie_Vsi,\"_HTML.txt\")","v":"VerreSimple_HTML.txt"}]
["Valide ? ",{"$f":"AND(ISNUMBER(F13),F11>0.2)","v":true},null,null,null,{"$f":"SUM(F7:G11)","v":7152.0540000000001}]
["https://html-online.com/editor/"]
[null,null,5]
["Var : ","#",3]
["Res : ","$",5]
[null,null,null,null,null,null,null,null,null," "]
[null,{"$f":"CONCATENATE(\"Mat&eacute;riau fragile, le verre ordinaire a un module d'Young E &eacute;gal &agrave; \",V1.Module_Vsi,\"GPa<br />1. Si le verre &eacute;tait un mat&eacute;riau parfait, quelle serait la valeur (en MPa) de sa r&eacute;sistance\")","v":"Mat&eacute;riau fragile, le verre ordinaire a un module d'Young E &eacute;gal &agrave; 67GPa<br />1. Si le verre &eacute;tait un mat&eacute;riau parfait, quelle serait la valeur (en MPa) de sa r&eacute;sistance"},"<p>Mat&eacute;riau fragile, le verre ordinaire a un module d'Young E &eacute;gal &agrave; #1#GPa<br />1. Si le verre &eacute;tait un mat&eacute;riau parfait, quelle serait la valeur (en MPa) de sa r&eacute;sistance &agrave; la traction ? $1$ MPa \\formsol{$$} \\minisol{\";arrondi(I2;0);\"}<br />2. Quelle serait la d&eacute;formation (en %) que ce verre pourrait supporter avant de se rompre ? $2$ % \\formsol{$$} \\minisol{\";arrondi(I2;0);\"}</p>",null,null,null,null,null,null," "]
[null,{"$f":"CONCATENATE(\" &agrave; la traction ? \",R1.RmTH_Vsi,\" MPa <br />2. Quelle serait la d&eacute;formation (en %) que ce verre pourrait supporter avant de se rompre ? \",R2.eps_TH_Vsi,\" % </p><p><p>N'&eacute;tant\")","v":" &agrave; la traction ? {1:NUMERICAL:=6.70E+03:3.35E+02} MPa <br />2. Quelle serait la d&eacute;formation (en %) que ce verre pourrait supporter avant de se rompre ? {1:NUMERICAL:=1.00E+01:5.00E-01} % </p><p><p>N'&eacute;tant"},"<p>N'&eacute;tant pas un mat&eacute;riau parfait, le verre ordinaire a une r&eacute;sistance &agrave; la traction Rm proche de #2# MPa.</p>",null,null,null,null,null,null," "]
[null,{"$f":"CONCATENATE(\" pas un mat&eacute;riau parfait, le verre ordinaire a une r&eacute;sistance &agrave; la traction Rm proche de \",V2.Rm_Vsi,\" MPa.</p><p><p>3. Quel est l'allongement &agrave; rupture d'un tel mat&eacute;riau ? \",R3.EpsVrai_Vsi,\"\")","v":" pas un mat&eacute;riau parfait, le verre ordinaire a une r&eacute;sistance &agrave; la traction Rm proche de 67 MPa.</p><p><p>3. Quel est l'allongement &agrave; rupture d'un tel mat&eacute;riau ? {1:NUMERICAL:=1.00E+00:5.00E-02}"},"<p>3. Quel est l'allongement &agrave; rupture d'un tel mat&eacute;riau ? $3$ % \\formsol{$$} \\minisol{\";arrondi(I2;0);\"}</p>",null,null,null,null,null,null," "]
[null,{"$f":"CONCATENATE(\"% .</p><p><p>4. Quelle est la valeur du facteur de concentration de contrainte Kt associ&eacute;e au micro d&eacute;faut le plus s&eacute;v&egrave;re qui existe\")","v":"% .</p><p><p>4. Quelle est la valeur du facteur de concentration de contrainte Kt associ&eacute;e au micro d&eacute;faut le plus s&eacute;v&egrave;re qui existe"},"<p>4. Quelle est la valeur du facteur de concentration de contrainte Kt associ&eacute;e au micro d&eacute;faut le plus s&eacute;v&egrave;re qui existe dans ce verre ? $4$ \\formsol{$$} \\minisol{\";arrondi(I2;0);\"}</p>",null,null,null,null,null,null," ",{"$f":"CONCATENATE(\"Matériau fragile, le verre ordinaire a un module d'Young E égal à \",V1.Module_Vsi,\" GPa\\\\\")","v":"Matériau fragile, le verre ordinaire a un module d'Young E égal à 67 GPa\\\\"}]
[null,{"$f":"CONCATENATE(\" dans ce verre ? \",R4.KT_Vsi,\" </p><p><p>On observe en microscopie &eacute;l&eacute;ectronique des micro-d&eacute;fauts superficiels assimilables &agrave; des fissures semi-elliptiques\")","v":" dans ce verre ? {2:NUMERICAL:=1.00E+02:5.00E+00} </p><p><p>On observe en microscopie &eacute;l&eacute;ectronique des micro-d&eacute;fauts superficiels assimilables &agrave; des fissures semi-elliptiques"},"<p>On observe en microscopie &eacute;l&eacute;ectronique des micro-d&eacute;fauts superficiels assimilables &agrave; des fissures semi-elliptiques dont la profondeur a = #3# &micro;m.<br />5. Quelle est la valeur (en nm) du rayon de courbure du micro-d&eacute;faut le plus s&eacute;v&egrave;re qui a entra&icirc;n&eacute; la rupture de l'&eacute;prouvette de traction ? $5$ \\formsol{$$} \\minisol{\";arrondi(I2;0);\"}</p>",null,null,null,null,null,null," ",{"$f":"CONCATENATE(\"1. Si le verre était un matériau parfait, quelle serait la valeur (en MPa) de sa résistance à la traction ? \\formsol{$E/10$} \\minisol{\",ROUND(F7,0),\"}\\\\ \")","v":"1. Si le verre était un matériau parfait, quelle serait la valeur (en MPa) de sa résistance à la traction ? \\formsol{$E/10$} \\minisol{6700}\\\\ "}]
[null,{"$f":"CONCATENATE(\" dont la profondeur a = \",V3.Profond_Vsi,\" &micro;m.<br />5. Quelle est la valeur (en nm) du rayon de courbure du micro-d&eacute;faut le plus s&eacute;v&egrave;re qui a entra&icirc;n&eacute; la rupture de l'&eacute;prouvette\")","v":" dont la profondeur a = 1.2 &micro;m.<br />5. Quelle est la valeur (en nm) du rayon de courbure du micro-d&eacute;faut le plus s&eacute;v&egrave;re qui a entra&icirc;n&eacute; la rupture de l'&eacute;prouvette"},"<p>&nbsp;</p>",null,null,null,null,null,null," ",{"$f":"CONCATENATE(\"2. Quelle serait la déformation (en \\%) que ce verre pourrait supporter avant de se rompre ?  \\formsol{$10\\%$} \\minisol{\",ROUND(100*F8,0),\"\\%} \\\\\")","v":"2. Quelle serait la déformation (en \\%) que ce verre pourrait supporter avant de se rompre ?  \\formsol{$10\\%$} \\minisol{1000\\%} \\\\"}]
[null,{"$f":"CONCATENATE(\" de traction ? \",R5.rho_Vsi,\" </p><p><p>&nbsp;</p>\")","v":" de traction ? {3:NUMERICAL:=4.80E-01:2.40E-02} </p><p><p>&nbsp;</p>"},"N'étant pas un matériau parfait, le verre ordinaire a une résistance à la traction Rm proche de #2# MPa.",null,null,null,null,null,null," ",{"$f":"CONCATENATE(\"N'étant pas un matériau parfait, le verre ordinaire a une résistance à la traction Rm proche de \",V2.Rm_Vsi,\" MPa.\\\\ \")","v":"N'étant pas un matériau parfait, le verre ordinaire a une résistance à la traction Rm proche de 67 MPa.\\\\ "}]
[null,null,null,null,null,null,null,null,null," ",{"$f":"CONCATENATE(\"3. Quel est l'allongement à rupture d'un tel matériau ?  \\formsol{$Rm/RmTH$} \\minisol{\",ROUND(F9,3),\"} \\% \\\\ 4. Quelle est la valeur du facteur de concentration de contrainte Kt associée au micro défaut le plus sévère qui existe\")","v":"3. Quel est l'allongement à rupture d'un tel matériau ?  \\formsol{$Rm/RmTH$} \\minisol{1} \\% \\\\ 4. Quelle est la valeur du facteur de concentration de contrainte Kt associée au micro défaut le plus sévère qui existe"}]
[null,null,"3. Quel est l'allongement à rupture d'un tel matériau ? $3$ % \\formsol{$$} \\minisol{;;}",null,null,null,null,null,null," ",{"$f":"CONCATENATE(\"dans ce verre ?  \\formsol{$Kt = Rth/Rm$ (deuxieme critere de Griffith) } \\minisol{\",ROUND(F10,0),\"} \\\\On observe en microscopie éléectronique des micro-défauts superficiels assimilables à des fissures semi-elliptiques\")","v":"dans ce verre ?  \\formsol{$Kt = Rth/Rm$ (deuxieme critere de Griffith) } \\minisol{100} \\\\On observe en microscopie éléectronique des micro-défauts superficiels assimilables à des fissures semi-elliptiques"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"dont la profondeur a = \",V3.Profond_Vsi,\" µm. \\\\5. Quelle est la valeur (en nm) du rayon de courbure du micro-défaut le plus sévère qui a entraîné la rupture de l'éprouvette\")","v":"dont la profondeur a = 1.2 µm. \\\\5. Quelle est la valeur (en nm) du rayon de courbure du micro-défaut le plus sévère qui a entraîné la rupture de l'éprouvette"}]
[null,null,"4. Quelle est la valeur du facteur de concentration de contrainte Kt associée au micro défaut le plus sévère qui existe dans ce verre ? $4$ \\formsol{$$} \\minisol{;;}",null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"de traction ?  \\formsol{$\\rho \\approx 4a\\left( {\\frac{{R_{m,pr} }}{{R_{m,th} }}} \\right)^2$} \\minisol{\",ROUND(F11,2),\"} nm\")","v":"de traction ?  \\formsol{$\\rho \\approx 4a\\left( {\\frac{{R_{m,pr} }}{{R_{m,th} }}} \\right)^2$} \\minisol{0.48} nm"}]
[]
[null,null,"On observe en microscopie éléectronique des micro-défauts superficiels assimilables à des fissures semi-elliptiques dont la profondeur a = #3# µm."]
[null,null,"5. Quelle est la valeur (en nm) du rayon de courbure du micro-défaut le plus sévère qui a entraîné la rupture de l'éprouvette de traction ? $5$ \\formsol{$$} \\minisol{;;}"]

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

{"sheet":"WeiPara","index":11,"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.2396216272864997},{"$f":"Contr_Rig*(1+Randm_Wei*RAND()/100)","v":5.3238633778018549},-2,{"$f":"ROUND(EXP(RANDBETWEEN(ValMini_Wei*10^-SigDig_Wei, ValMaxi_Wei*10^-SigDig_Wei)/10^-SigDig_Wei),0)","v":192},null,"log Sig","MPa",null,1,{"$f":"(Proba_Wei-Ordonnee)/Module","v":5.3233168163744145},{"$f":"LN(-LN(1-N2/10))","v":-2.2503673273124454},null,null,"pente","ordo"]
["Tag_Wei","WeiPara_Wei","    <question type=\"cloze\">",null,"V2._Wei",5.4770558249837435,5.4833196149242855,-2,240,null,"log Sig","MPa",null,2,{"$f":"(Proba_Wei-Ordonnee)/Module","v":5.4829822079814212},-1.4999399867595158,null,null,{"$f":"LINEST(P2:P10,O2:O10,1,1)","v":4.7},-27.269956364272197,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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-210925.17"},{"$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.5768434091742822},{"$f":"Contr_Rig*(1+Randm_Wei*RAND()/100)","v":5.5828996226645167},-2,{"$f":"ROUND(EXP(RANDBETWEEN(ValMini_Wei*10^-SigDig_Wei, ValMaxi_Wei*10^-SigDig_Wei)/10^-SigDig_Wei),0)","v":265},null,"log Sig","MPa",null,3,{"$f":"(Proba_Wei-Ordonnee)/Module","v":5.5827714747049946},-1.0309304331587228,null,null,3.0759758234545161E-15,1.7536928908085579E-14]
["points_Wei",1,"        <questiontext format=\"html\">",null,"V4._Wei",5.609544190365126,5.6602280388883939,-2,284,null,"log Sig","MPa",null,4,5.6591977387617183,-0.67172699209212194,null,null,1,1.8236264113335053E-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 : 376, 344, 293, 265, 284, 324, 240, 365, 192 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.70E+00:1.18E+00}</p><p><p>&nbsp;</p><p><p>&nbsp;</p><p><p>Lefacteur d'&eacute;chelle Ko={1:NUMERICAL:=3.26E+02:8.14E+01} MPa</p><p><p>&nbsp;</p><p></p>]]></text>"},null,"V5._Wei",5.6786232593711281,5.7251881820084627,-2,293,null,"log Sig","MPa",null,5,5.7241369029128792,-0.36651292058166435,null,null,2.3346935339829605E+30,7]
["penalité_Wei",0.1,"        </questiontext>",null,"V6._Wei",5.764854676786249,5.7835604808511274,-2,324,null,"log Sig","MPa",null,6,5.7835180409534974,-8.7421571790755173E-2,null,null,7.7642878402855118,2.3279293016791836E-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.7707407026198343,5.8423861196589302,-2,344,null,"log Sig","MPa",null,7,5.8416134304541618,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-210925.17</idnumber><tags><tag><text>WeiPara_Wei</text></tag></tags>"},null,"V8._Wei",5.8844834476430909,5.9035989211808868,-2,365,null,"log Sig","MPa",null,8,5.9033705020424057,0.4758849953271107,null,null,null,{"$f":"EXP(-T3/S3)","v":331}]
["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 : 376, 344, 293, 265, 284, 324, 240, 365, 192 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.70E+00:1.18E+00}</p><p><p>&nbsp;</p><p><p>&nbsp;</p><p><p>Lefacteur d'&eacute;chelle Ko={1:NUMERICAL:=3.26E+02:8.14E+01} MPa</p><p><p>&nbsp;</p><p>"},"    </question>",null,"V9._Wei",5.9134173256010163,5.9803900223951407,-2,376,null,"log Sig","MPa",null,9,5.9795720871319471,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":331},"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":-27.269956364272197},"ordonnée",null,"verif s",{"$f":"EXP(-I14/I15)","v":331},null,null,null,null,{"$f":"100*ABS(R17/R16)+ABS(S17/S16)","v":4.4042360478996176}]
[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.7},"pente",null,"Extracted s",{"$f":"EXP(-Ordonnee/Module)","v":331},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.2574953720277815},{"$f":"P2","v":-2.2503673273124454},null,{"$f":"LINEST(P16:P24,O16:O24,1,1)","v":4.5153084579959577},-26.126006299593332]
["Res : ","$",2,null,"R1.Module_Wei",{"$f":"I15","v":4.7},{"$f":" tolerance_Wei*ValMini_Wei","v":1.175},1,{"$f":"CONCATENATE(\"{\",PointsQuestion_Wei,\":NUMERICAL:=\",TEXT(Cible_Wei,\"0.00E+00\"),\":\",TEXT(ABS(Tolere_Wei),\"0.00E+00\"),\"}\")","v":"{1:NUMERICAL:=4.70E+00:1.18E+00}"},null,null,null,null,null,5.4806389233419912,-1.4999399867595158,null,0.19693122560249127,1.1188093804561088]
[null,null,null,null,"R2.Exp_Wei",{"$f":"Facteur_Echelle","v":325.73871668328258},{"$f":" tolerance_Wei*ValMini_Wei","v":81.434679170820644},1,{"$f":"CONCATENATE(\"{\",PointsQuestion_Wei,\":NUMERICAL:=\",TEXT(Cible_Wei,\"0.00E+00\"),\":\",TEXT(ABS(Tolere_Wei),\"0.00E+00\"),\"}\")","v":"{1:NUMERICAL:=3.26E+02:8.14E+01}"},null,null,null,null,null,5.579729825986222,-1.0309304331587228,null,0.98685962555349616,0.12072734897385703]
[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 : 376, 344, 293, 265,"},"<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.6489742381612063,-0.67172699209212194,null,525.70932487486596,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":" 284, 324, 240, 365, 192 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.70E+00:1.18E+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.6801726090170677,-0.36651292058166435,null,7.6622621907537232,0.10202564953178821]
[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.26E+02:8.14E+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.780743515792329,-8.7421571790755173E-2]
[null,{"$f":"CONCATENATE(\"\")","v":""},"<p>&nbsp;</p>",null,null,null,null,null,null,null,null,null,null,null,5.8406416573733981,0.18562675886236557]
[null,{"$f":"CONCATENATE(\"\")","v":""},"<p>&nbsp;</p>",null,null,null,null,null,null,null,null,null,null,null,5.8998973535824915,0.4758849953271107,null,"Facteur Echelle",{"$f":"EXP(-S16/R16)","v":325.73871668328258}]
[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.9295891433898946,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 : 376, 344, 293, 265, 284, 324, 240, 365, 192 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.7}\\\\"}]
[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{326} MPa"}]