Fax8"*?(8@EACTaEACT1`f$<_́`======CONSERVE=======@EACT Enonc ,8"*?(8@RUNMATTEXT148xLa boite de consevea bUn industiel souhaite fabique des botes de conseve dun volume de 850 cm3. Le couvecle et le fond sont d coup s dans une bande de m tal ainsi que la paoi lat ale.Afin dutilise le moins de mati e pemi e (le m tal) nous chechons quelles sont les dimensions  donne  la bote de conseve. (Aide: notons h la hauteu de la bote de conseve et son ayon.)cho@EACT Remarqueګt8"*?(8@RUNMATTEXT1 Afin de determiner les dimensions optimales de la boite, nous allons cr er  l'aide de l'outil tableur, une feuille dynamique avec en colonne respectivement le rayon de la boite, sa hauteur, l'aire lat rale, l'aire des couvercles et l'aire totale.@EACT Calculs8"*?(8@RUNMATHTEXT14(DtЂs Volume total = r2h d'o : 850=r2h et donc h=850(r2)Aire lat rale = 2rh d Aire des couvercles = 2r285 Aire totale = 2(r2rh)2Aire totale uniquement en fonction de r =n 2(r2r850(r2)) fo[ = 2r2 1700r@SSHEETDim. optimalesYP"@ n,*?(8@SSHEETYd@SNAME( SHEET4Y0 SHEET% X d @ 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p    0 @ P ` p  !!! !0!@!P!`!p!!""" "0"@"P"`"p""### #0#@#P#`#p##$$$ $0$@$P$`$p$$(8b!T W4iYfpfW07qw%@hsxrVpirXs""efhtCaaYFgWU`$ISPAi!`IEFtE@uWQA6(Wf72g3($X)$(h% v6E!GEypBv`P"b A2Rg"RVpiH)U4sedHBTfWv`gr74hsGdRD`8@#fV&ycRUF8WHHDew9A7itH3Uv'd)eUt%V$!Tt`u4 6`$ b#h $GG'H1wt5sY@6u)TEyI#wT2ys`0FFie eqevssawgX1aW)S9GI5QUFfBydd8Xt 74& Hv04G9&B&f"PB'eX33gpE06vhX 7sF2hXa2S$Q52yiE$yVh$Yugiw3qx5g@4d 60`v4V&uWCR8Q5HQ 2"Dc7@vQr%6 95R3h`)9a%112S!EGaYSftD &3y0VQY PP7 EV8 f h(4s )H W%% S&  Cw vh 8Cpv e"D ayF #Rf dg#Gw GP@C  82RU q(D`aG 3 u$h' $i Wyet y7S %AE C(  H(X g( q )7TA IwG ScpT x wbDS9 @$a1h BBcW dfqR &2gY #83B QT@& A88 v$Yb 8b0"F 3 cD4R" %ppG 5!sE PAt 4gaEg ub 8BppW Y#3333335#3&yfy#3 &eb&#3spD#3!14#3hV5#27(d#2dD c9#2vB)#2ta4'(R#2ha%$#2aY&C1#2U`qt#2HX EvU#2Bc#25X"g#2)R"#2"Ybb#29x#2 aRx#2P#1d#1q5#1h6e#1w S5'#1ps1s#1d&2#1Wy #1Q2`S"#1D%F0U#18@YEA#110S#1%Hq9Qg#17Hs#1X'Ei#1Cqs#0hsR#0$Pg#0B#06X)#0sa#0gIe0#0aW3y#0TcsqA#0H!U8#0AxC#056ruU9#0('2#0"S0"S2#04#0 p79#0000#)D #)I v#) '4#)wiaY#)q)Uwu#)d t#)XQPyI#)R%6#)Esd4#)95(8Yq#)28#)&Y0fh#) !hP#)1u!y#)G1 #)1TcR#(shBR#(7)#(AX#(ue&x9#(i)b64#(b!A#(VYESU#(P$E6#(CHSd#(7U#(1 `#($e#(S(S'#()9#(d`a#'SiGq6#' vT2#'RE#'V0T7s#'t$3U#'gYy#'aa@F#'U)Q%%#'H4D#'BhGvW#'67Xb#'01a4#'#w(XQw#'GIuD#'&d#'dW#&YX9#&0v0w#&#&ysb #&sEv `5#&gS#&`)wX#&TbsG#&H5yyd(#&Bp #&5&pS#&)UA&h#&#)hr#&vRW#&x@Ef#&RbuA##%'B $#%E9s#%wrfb#%yS##%s((#%gB#%`!#%TWgP#%H48cg#%B3#@#%5QgFA#%)e3#%#C`5h#%!ID#%cfA#%xr(#$Vb9rG#$5G@#$V7#$ya)#$ssDyFQ#$gS$gS%#$a3($`#$UUG#$H7Rb#$Bt`1#$6Uyy`#$07u(#$$F'#$%U0#$ii#$d# R##Fcas##)&h##VD!cBVIA!cHDa0`!cU8Q'I!cayq !ch!39!ctbI7@!cR!cEwgT!cYFg!d)UP!dqc!dIf)!dVP$!d%b!d2A Y'!d84!dE&ts!dQip%`!dXxAAy!ddU8!i!dp2e)!dwByr`!d7hCa!d0x3!dsqvv!e8!e ads!eQT(!e"PSXS!e(!$H!e59YA!eA1IR!eH)PWY!eTt@)8!ea!d!egdCd!et xI&!eU%eSW!e8C!eFWg!eBTb!f89!fIB!f0rRQ!f%we#X!f2#U4Y!f8p`Y!fEC#G!fQcsP!fXqxA!fdW0q!fq@ !fwRA@!f(C1!fGPR!f#C&#!gC 5c&!g c!g9(B!g"BRVV!g)5xqHA!g5'G!gB2y##!gHbh!gU0IR!gayHc$!gh(Yt73!gtwu!g' avb!gviA!g&1ups!hvc4!h%g!huq9i!h &#C!h&v)Qp!h3&fv!h9wXV!hF'xB!hRxSi!hY)ACcf!heAQ4!hr1Tr!hxy8C!h4d`!hgQI!h70B1!i #!i@!iW$!i$Eu' !i03I!i7Iq$9!iD"iT!iPTv9!iWb!ic`Pr#!ipQ2 !ivfeXD!i!'!is0pa6!i&e!pF 2g!p 4"cc!ptX!p"BBB!p('f9u!p5PTG%y!pBuS!pHYEx!pU)f!pah7!ph#wW!ptxy!y!p3!p!3Q!pDa#f!qp!qUxtv!qV5'1!q gFRAS!q'#I&E!q3ydVa!q@5CfA!qF25E!qSHh !q`QDde!qfb)X$!qs (Hh!qyv#U6%!q398S!qgyQ!qHu !rb)#`!rc(9)p!r!Q!r%x)3!r27 0%!r8E!rESG9!rR!rXpBV!re) Xq!rqxQ@!rxFTV!rC!rewr!r$1$)!ss'(!sC'e$u0v$uw1(#9$ueW@u$uSB2$uBdG$u195G$u D&Fv$u!$0$u617$tF$tg!($ts $tdw!$tVRtE$tI%u&$tBR$t5&@V$t(c8"$t"xIW$tAG$te)$tr`$t8b$s#(D$sE$spb$s3q$s@2h$su$s%gU$syuPV$sxbQ$sw &$swICx$swIhU$swaYy$sxc"x$syvP!T$s'B@$sr$sB$W$s5$s)Y$sF#iD$s"sx$t6xBt$t6$twEPy$t$t"h)$t(ih$t5pP$tA $tHV6$tVP4i&$td90$tre`$t(YH$t)A$tgVi$u CY%$uUch$u0b$u@4$uRf6$ucy$uuy#S$uD8d$v$v&$v'G1$vA2!$vUU&V$vpq($v(v$wD`#$wv5e$w2#ca$wHhW1$wePWT$wib$x%i"s$xwi3$x6H$xU$xt9&$x`5$y8e$y3Sxd$yTWdc$yt&RE$y8$)$9Ys$bu@$sIs$SXg$1G$U0S%E$yPpf$b$)0Q5$T1qA$y$#$gY3$2C $Y @1"$4&$xEs$AqYQ$ip$V $'Sd$Vb%P$VtS$cBu$GcTc$w7R$ bea$@U7U2$rD`D$p1S$72G&$p14@$fG$77Ua$qE9v$c`I$@p$f$u!x$@SY$G0t$V2$ C`c$WX$QF$2"($p03C$s$GSvhC$idF$&"5y$fFG"$5cX$FI$iq$)%qS$py4$ $UAC $0<HT`lx ,8DP\ht(4@LXdp| $0<HT`lx ,8DP\ht(4@LXdp| $0<HT`lx=A10.001=A20.001=A30.001=A40.001=A50.001=A60.001=A70.001=A80.001=A90.001=A100.001=A110.001=A120.001=A130.001=A140.001=A150.001=A160.001=A170.001=A180.001=A190.001=A200.001=A210.001=A220.001=A230.001=A240.001=A250.001=A260.001=A270.001=A280.001=A290.001=A300.001=A310.001=A320.001=A330.001=A340.001=A350.001=A360.001=A370.001=A380.001=A390.001=A400.001=A410.001=A420.001=A430.001=A440.001=A450.001=A460.001=A470.001=A480.001=A490.001=A500.001=A510.001=A520.001=A530.001=A540.001=A550.001=A560.001=A570.001=A580.001=A590.001=A600.001=A610.001=A620.001=A630.001=A640.001=A650.001=A660.001=A670.001=A680.001=A690.001=A700.001=A710.001=A720.001=A730.001=A740.001=A750.001=A760.001=A770.001=A780.001=A790.001=A800.001=A810.001=A820.001=A830.001=A840.001=A850.001=A860.001=A870.001=A880.001=A890.001=A900.001=A910.001=A920.001=A930.001=A940.001=A950.001=A960.001=A970.001=A980.001=A990.001=A1000.001=A1010.001=A1020.001=A1030.001=A1040.001=A1050.001=A1060.001=A1070.001=A1080.001=A1090.001=A1100.001=A1110.001=A1120.001=A1130.001=A1140.001=A1150.001=A1160.001=A1170.001=A1180.001=A1190.001=A1200.001=A1210.001=A1220.001=A1230.001=A1240.001=A1250.001=A1260.001=A1270.001=A1280.001=A1290.001=A1300.001=A1310.001=A1320.001=A1330.001=A1340.001=A1350.001=A1360.001=A1370.001=A1380.001=A1390.001=A1400.001=A1410.001=A1420.001=A1430.001=A1440.001=A1450.001=A1460.001=A1470.001=A1480.001=A1490.001 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p    0 @ P=850(A12)=850(A22)v$=850(A32)v$=850(A42)v$=850(A52)v$=850(A62)v$=850(A72)v$=850(A82)v$=850(A92)v$=850(A102)$=850(A112)$=850(A122)$=850(A132)$=850(A142)$=850(A152)$=850(A162)$=850(A172)$=850(A182)$=850(A192)$=850(A202)$=850(A212)$=850(A222)$=850(A232)$=850(A242)$=850(A252)$=850(A262)$=850(A272)$=850(A282)$=850(A292)$=850(A302)$=850(A312)$=850(A322)$=850(A332)$=850(A342)$=850(A352)$=850(A362)$=850(A372)$=850(A382)$=850(A392)$=850(A402)$=850(A412)$=850(A422)$=850(A432)$=850(A442)$=850(A452)$=850(A462)$=850(A472)$=850(A482)$=850(A492)$=850(A502)$=850(A512)$=850(A522)$=850(A532)$=850(A542)$=850(A552)$=850(A562)$=850(A572)$=850(A582)$=850(A592)$=850(A602)$=850(A612)$=850(A622)$=850(A632)$=850(A642)$=850(A652)$=850(A662)$=850(A672)$=850(A682)$=850(A692)$=850(A702)$=850(A712)$=850(A722)$=850(A732)$=850(A742)$=850(A752)$=850(A762)$=850(A772)$=850(A782)$=850(A792)$=850(A802)$=850(A812)$=850(A822)$=850(A832)$=850(A842)$=850(A852)$=850(A862)$=850(A872)$=850(A882)$=850(A892)$=850(A902)$=850(A912)$=850(A922)$=850(A932)$=850(A942)$=850(A952)$=850(A962)$=850(A972)$=850(A982)$=850(A992)$=850(A1002)=850(A1012)=850(A1022)=850(A1032)=850(A1042)=850(A1052)=850(A1062)=850(A1072)=850(A1082)=850(A1092)=850(A1102)=850(A1112)=850(A1122)=850(A1132)=850(A1142)=850(A1152)=850(A1162)=850(A1172)=850(A1182)=850(A1192)=850(A1202)=850(A1212)=850(A1222)=850(A1232)=850(A1242)=850(A1252)=850(A1262)=850(A1272)=850(A1282)=850(A1292)=850(A1302)=850(A1312)=850(A1322)=850(A1332)=850(A1342)=850(A1352)=850(A1362)=850(A1372)=850(A1382)=850(A1392)=850(A1402)=850(A1412)=850(A1422)=850(A1432)=850(A1442)=850(A1452)=850(A1462)=850(A1472)=850(A1482)=850(A1492)=850(A1502) $0<HT`l| ,<L\l| ,<L\l| ,<L\l| ,<L\l| ,<L\l| ,<L\l| ,<L\l| ,<L\l|   ,=2ЩA1B1=2ЩA2B2=2ЩA3B3=2ЩA4B4=2ЩA5B5=2ЩA6B6=2ЩA7B7=2ЩA8B8=2ЩA9B9=2ЩA10B10v$=2ЩA11B11v$=2ЩA12B12v$=2ЩA13B13v$=2ЩA14B14v$=2ЩA15B15v$=2ЩA16B16v$=2ЩA17B17v$=2ЩA18B18v$=2ЩA19B19v$=2ЩA20B20v$=2ЩA21B21v$=2ЩA22B22v$=2ЩA23B23v$=2ЩA24B24v$=2ЩA25B25v$=2ЩA26B26v$=2ЩA27B27v$=2ЩA28B28v$=2ЩA29B29v$=2ЩA30B30v$=2ЩA31B31v$=2ЩA32B32v$=2ЩA33B33v$=2ЩA34B34v$=2ЩA35B35v$=2ЩA36B36v$=2ЩA37B37v$=2ЩA38B38v$=2ЩA39B39v$=2ЩA40B40v$=2ЩA41B41v$=2ЩA42B42v$=2ЩA43B43v$=2ЩA44B44v$=2ЩA45B45v$=2ЩA46B46v$=2ЩA47B47v$=2ЩA48B48v$=2ЩA49B49v$=2ЩA50B50v$=2ЩA51B51v$=2ЩA52B52v$=2ЩA53B53v$=2ЩA54B54v$=2ЩA55B55v$=2ЩA56B56v$=2ЩA57B57v$=2ЩA58B58v$=2ЩA59B59v$=2ЩA60B60v$=2ЩA61B61v$=2ЩA62B62v$=2ЩA63B63v$=2ЩA64B64v$=2ЩA65B65v$=2ЩA66B66v$=2ЩA67B67v$=2ЩA68B68v$=2ЩA69B69v$=2ЩA70B70v$=2ЩA71B71v$=2ЩA72B72v$=2ЩA73B73v$=2ЩA74B74v$=2ЩA75B75v$=2ЩA76B76v$=2ЩA77B77v$=2ЩA78B78v$=2ЩA79B79v$=2ЩA80B80v$=2ЩA81B81v$=2ЩA82B82v$=2ЩA83B83v$=2ЩA84B84v$=2ЩA85B85v$=2ЩA86B86v$=2ЩA87B87v$=2ЩA88B88v$=2ЩA89B89v$=2ЩA90B90v$=2ЩA91B91v$=2ЩA92B92v$=2ЩA93B93v$=2ЩA94B94v$=2ЩA95B95v$=2ЩA96B96v$=2ЩA97B97v$=2ЩA98B98v$=2ЩA99B99v$=2ЩA100B100$=2ЩA101B101$=2ЩA102B102$=2ЩA103B103$=2ЩA104B104$=2ЩA105B105$=2ЩA106B106$=2ЩA107B107$=2ЩA108B108$=2ЩA109B109$=2ЩA110B110$=2ЩA111B111$=2ЩA112B112$=2ЩA113B113$=2ЩA114B114$=2ЩA115B115$=2ЩA116B116$=2ЩA117B117$=2ЩA118B118$=2ЩA119B119$=2ЩA120B120$=2ЩA121B121$=2ЩA122B122$=2ЩA123B123$=2ЩA124B124$=2ЩA125B125$=2ЩA126B126$=2ЩA127B127$=2ЩA128B128$=2ЩA129B129$=2ЩA130B130$=2ЩA131B131$=2ЩA132B132$=2ЩA133B133$=2ЩA134B134$=2ЩA135B135$=2ЩA136B136$=2ЩA137B137$=2ЩA138B138$=2ЩA139B139$=2ЩA140B140$=2ЩA141B141$=2ЩA142B142$=2ЩA143B143$=2ЩA144B144$=2ЩA145B145$=2ЩA146B146$=2ЩA147B147$=2ЩA148B148$=2ЩA149B149$=2ЩA150B150$ $0<HT`lx ,8DP\ht(4@LXdp| $0<HT`lx ,8DP\ht(4@LXdp| $0<HT`lx=2ЩA12=2ЩA22Q=2ЩA32Q=2ЩA42Q=2ЩA52Q=2ЩA62Q=2ЩA72Q=2ЩA82Q=2ЩA92Q=2ЩA102=2ЩA112=2ЩA122=2ЩA132=2ЩA142=2ЩA152=2ЩA162=2ЩA172=2ЩA182=2ЩA192=2ЩA202=2ЩA212=2ЩA222=2ЩA232=2ЩA242=2ЩA252=2ЩA262=2ЩA272=2ЩA282=2ЩA292=2ЩA302=2ЩA312=2ЩA322=2ЩA332=2ЩA342=2ЩA352=2ЩA362=2ЩA372=2ЩA382=2ЩA392=2ЩA402=2ЩA412=2ЩA422=2ЩA432=2ЩA442=2ЩA452=2ЩA462=2ЩA472=2ЩA482=2ЩA492=2ЩA502=2ЩA512=2ЩA522=2ЩA532=2ЩA542=2ЩA552=2ЩA562=2ЩA572=2ЩA582=2ЩA592=2ЩA602=2ЩA612=2ЩA622=2ЩA632=2ЩA642=2ЩA652=2ЩA662=2ЩA672=2ЩA682=2ЩA692=2ЩA702=2ЩA712=2ЩA722=2ЩA732=2ЩA742=2ЩA752=2ЩA762=2ЩA772=2ЩA782=2ЩA792=2ЩA802=2ЩA812=2ЩA822=2ЩA832=2ЩA842=2ЩA852=2ЩA862=2ЩA872=2ЩA882=2ЩA892=2ЩA902=2ЩA912=2ЩA922=2ЩA932=2ЩA942=2ЩA952=2ЩA962=2ЩA972=2ЩA982=2ЩA992=2ЩA1002=2ЩA1012=2ЩA1022=2ЩA1032=2ЩA1042=2ЩA1052=2ЩA1062=2ЩA1072=2ЩA1082=2ЩA1092=2ЩA1102=2ЩA1112=2ЩA1122=2ЩA1132=2ЩA1142=2ЩA1152=2ЩA1162=2ЩA1172=2ЩA1182=2ЩA1192=2ЩA1202=2ЩA1212=2ЩA1222=2ЩA1232=2ЩA1242=2ЩA1252=2ЩA1262=2ЩA1272=2ЩA1282=2ЩA1292=2ЩA1302=2ЩA1312=2ЩA1322=2ЩA1332=2ЩA1342=2ЩA1352=2ЩA1362=2ЩA1372=2ЩA1382=2ЩA1392=2ЩA1402=2ЩA1412=2ЩA1422=2ЩA1432=2ЩA1442=2ЩA1452=2ЩA1462=2ЩA1472=2ЩA1482=2ЩA1492=2ЩA1502 (08@HT`lx ,8DP\ht(4@LXdp| $0<HT`lx ,8DP\ht(4@LXdp| $0<HT`lx=C1D1=C2D2#=C3D3#=C4D4#=C5D5#=C6D6#=C7D7#=C8D8#=C9D9#=C10D10Q=C11D11Q=C12D12Q=C13D13Q=C14D14Q=C15D15Q=C16D16Q=C17D17Q=C18D18Q=C19D19Q=C20D20Q=C21D21Q=C22D22Q=C23D23Q=C24D24Q=C25D25Q=C26D26Q=C27D27Q=C28D28Q=C29D29Q=C30D30Q=C31D31Q=C32D32Q=C33D33Q=C34D34Q=C35D35Q=C36D36Q=C37D37Q=C38D38Q=C39D39Q=C40D40Q=C41D41Q=C42D42Q=C43D43Q=C44D44Q=C45D45Q=C46D46Q=C47D47Q=C48D48Q=C49D49Q=C50D50Q=C51D51Q=C52D52Q=C53D53Q=C54D54Q=C55D55Q=C56D56Q=C57D57Q=C58D58Q=C59D59Q=C60D60Q=C61D61Q=C62D62Q=C63D63Q=C64D64Q=C65D65Q=C66D66Q=C67D67Q=C68D68Q=C69D69Q=C70D70Q=C71D71Q=C72D72Q=C73D73Q=C74D74Q=C75D75Q=C76D76Q=C77D77Q=C78D78Q=C79D79Q=C80D80Q=C81D81Q=C82D82Q=C83D83Q=C84D84Q=C85D85Q=C86D86Q=C87D87Q=C88D88Q=C89D89Q=C90D90Q=C91D91Q=C92D92Q=C93D93Q=C94D94Q=C95D95Q=C96D96Q=C97D97Q=C98D98Q=C99D99Q=C100D100=C101D101=C102D102=C103D103=C104D104=C105D105=C106D106=C107D107=C108D108=C109D109=C110D110=C111D111=C112D112=C113D113=C114D114=C115D115=C116D116=C117D117=C118D118=C119D119=C120D120=C121D121=C122D122=C123D123=C124D124=C125D125=C126D126=C127D127=C128D128=C129D129=C130D130=C131D131=C132D132=C133D133=C134D134=C135D135=C136D136=C137D137=C138D138=C139D139=C140D140=C141D141=C142D142=C143D143=C144D144=C145D145=C146D146=C147D147=C148D148=C149D149=C150D150@EACT Solutions׫8"*?(8@RUNMATTEXT1LPPar lecture de la feuille dynamique du tableur :ar Pour r=5,133cm; h=10,269cm; Aire totale=496,738cm2our