{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Титульный лист","задача 1","задача 2","задача 3"],"not_rendered":{"charts":3,"images":7,"macros":1,"external_links":0,"defined_names":0,"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":"Титульный лист","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"задача 1","index":1,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2],[5,0,5,2]]}
["Задача №1 Вариант 1"]
["Число оборотов двигателя y функционально зависит от температуры x. Вычислить число оборотов двигателя y(x) при температуре a и b. Построить график этой функциональной зависимости на интервале [a,b] с шагом 0,05l; l – длина отрезка [a,b]. "]
["a","b","y(x)"]
[-2.7509999999999999,0.26900000000000002]
[]
["Решение"]
["x","y","Функциональная зависимость"]
[-2.7509999999999999,{"$f":"IF(A8<-1,-3*A8+2+SIN(A8),IF(-1<=A8<0,ABS(A8),A8*LN(A8+1)))","v":9.8722635010027311}]
[-2.6,{"$f":"IF(A9<-1,-3*A9+2+SIN(A9),IF(-1<=A9<0,ABS(A9),A9*LN(A9+1)))","v":9.284498628178536}]
[-2.4489999999999998,{"$f":"IF(A10<-1,-3*A10+2+SIN(A10),IF(-1<=A10<0,ABS(A10),A10*LN(A10+1)))","v":8.7084653856221443}]
[-2.298,{"$f":"IF(A11<-1,-3*A11+2+SIN(A11),IF(-1<=A11<0,ABS(A11),A11*LN(A11+1)))","v":8.1469637280790153}]
[-2.1469999999999998,7.6024629047099026]
[-1.996,7.077045264636741]
[-1.845,6.5723588674470381]
[-1.694,6.08957997713319]
[-1.5429999999999999,{"$f":"IF(A16<-1,-3*A16+2+SIN(A16),IF(-1<=A16<0,ABS(A16),A16*LN(A16+1)))","v":5.6293862930186993}]
[-1.3919999999999999,{"$f":"IF(A17<-1,-3*A17+2+SIN(A17),IF(-1<=A17<0,ABS(A17),A17*LN(A17+1)))","v":5.1919415268741016}]
[-1.2410000000000001,{"$f":"IF(A18<-1,-3*A18+2+SIN(A18),IF(-1<=A18<0,ABS(A18),A18*LN(A18+1)))","v":4.7768916772121157}]
[-1.0900000000000001,{"$f":"IF(A19<-1,-3*A19+2+SIN(A19),IF(-1<=A19<0,ABS(A19),A19*LN(A19+1)))","v":4.3833730855505131}]
[-0.93899999999999995,2.6262716485054867]
[-0.78800000000000003,{"$f":"IF(A21<-1,-3*A21+2+SIN(A21),IF(-1<=A21<0,ABS(A21),A21*LN(A21+1)))","v":1.2223211753963783}]
[-0.63700000000000001,{"$f":"IF(A22<-1,-3*A22+2+SIN(A22),IF(-1<=A22<0,ABS(A22),A22*LN(A22+1)))","v":0.64550550728491141}]
[-0.48599999999999999,{"$f":"IF(A23<-1,-3*A23+2+SIN(A23),IF(-1<=A23<0,ABS(A23),A23*LN(A23+1)))","v":0.32344855857410831}]
[-0.33500000000000002,{"$f":"IF(A24<-1,-3*A24+2+SIN(A24),IF(-1<=A24<0,ABS(A24),A24*LN(A24+1)))","v":0.13666935983930478}]
[-0.184,{"$f":"IF(A25<-1,-3*A25+2+SIN(A25),IF(-1<=A25<0,ABS(A25),A25*LN(A25+1)))","v":3.7414730019317513E-2}]
[-3.2999999999999897E-2,{"$f":"IF(A26<-1,-3*A26+2+SIN(A26),IF(-1<=A26<0,ABS(A26),A26*LN(A26+1)))","v":1.1073738564518038E-3}]
[0.11799999999999999,{"$f":"IF(A27<-1,-3*A27+2+SIN(A27),IF(-1<=A27<0,ABS(A27),A27*LN(A27+1)))","v":1.3161882218483063E-2}]
[0.26900000000000002,{"$f":"IF(A28<-1,-3*A28+2+SIN(A28),IF(-1<=A28<0,ABS(A28),A28*LN(A28+1)))","v":6.4083651768975444E-2}]

{"sheet":"задача 2","index":2,"n_rows":39,"n_cols":3,"rows_kept":39,"cut":false,"hidden":false,"merged":[[4,0,4,2],[0,0,0,2],[1,0,1,2],[2,0,2,2]]}
["Задача №2"]
["Число оборотов f, как и в предыдущей задаче функционально зависит от температуры x. Требуется найти температуру, при которой число оборотов равно нулю, то есть найти все корни уравнения f(x)=0 на отрезке локализации [-4;4] с точностью 0,0001. "]
[]
[]
["Решение"]
["x","y","Схематичный график функции"]
[-4,{"$f":"A7^3-3*A7^2-13*A7-7","v":-67}]
[-3.75,{"$f":"A8^3-3*A8^2-13*A8-7","v":-53.171875}]
[-3.5,{"$f":"A9^3-3*A9^2-13*A9-7","v":-41.125}]
[-3.25,-30.765625]
[-3,-22]
[-2.75,-14.734375]
[-2.5,-8.875]
[-2.25,-4.328125]
[-2,{"$f":"A15^3-3*A15^2-13*A15-7","v":-1}]
[-1.75,1.203125]
[-1.5,2.375]
[-1.25,2.609375]
[-1,2]
[-0.75,0.640625]
[-0.5,{"$f":"A21^3-3*A21^2-13*A21-7","v":-1.375}]
[-0.25,{"$f":"A22^3-3*A22^2-13*A22-7","v":-3.953125}]
[0,{"$f":"A23^3-3*A23^2-13*A23-7","v":-7}]
[0.25,-10.421875]
[0.5,-14.125]
[0.75,-18.015625]
[1,-22]
[1.25,-25.984375]
[1.5,-29.875]
[1.75,-33.578125]
[2,{"$f":"A31^3-3*A31^2-13*A31-7","v":-37}]
[2.25,{"$f":"A32^3-3*A32^2-13*A32-7","v":-40.046875}]
[2.5,{"$f":"A33^3-3*A33^2-13*A33-7","v":-42.625}]
[2.75,-44.640625]
[3,-46]
[3.25,-46.609375]
[3.5,-46.375]
[3.75,-45.203125]
[4,-43]

{"sheet":"задача 3","index":3,"n_rows":28,"n_cols":23,"rows_kept":28,"cut":false,"hidden":false,"merged":[[6,0,26,0],[5,2,5,22],[1,0,1,22],[0,0,0,22],[2,0,2,22],[4,0,4,22]]}
["Задача №3"]
["Построить таблицу значений функции z(x,y) и ее отображение в виде поверхности на области (x,y)є[-1..1,-1..1]  с шагом 0,1 по каждому направлению."]
[]
[]
["Решение"]
[null,null,"Ось Ox"]
["Ось Oy",null,-1,-0.9,-0.8,-0.7,-0.6,-0.5,-0.4,-0.3,-0.2,-0.1,0,0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9,1]
[null,-1,{"$f":"IF(C$7>0,$B8*SIN(PI()*C$7)^2,C$7*SIN(PI()*$B8)^2)","v":-1.5009887365649789E-32},{"$f":"IF(D$7>0,$B8*SIN(PI()*D$7)^2,D$7*SIN(PI()*$B8)^2)","v":-1.350889862908481E-32},{"$f":"IF(E$7>0,$B8*SIN(PI()*E$7)^2,E$7*SIN(PI()*$B8)^2)","v":-1.2007909892519831E-32},-1.0506921155954852E-32,-9.0059324193898735E-33,-7.5049436828248946E-33,-6.0039549462599157E-33,-4.5029662096949368E-33,-3.0019774731299578E-33,-1.5009887365649789E-33,0,-9.5491502812526274E-2,-0.34549150281252627,-0.65450849718747373,-0.90450849718747361,-1,-0.90450849718747384,-0.65450849718747373,-0.34549150281252644,-9.5491502812526344E-2,-1.5009887365649789E-32]
[null,-0.9,{"$f":"IF(C$7>0,$B9*SIN(PI()*C$7)^2,C$7*SIN(PI()*$B9)^2)","v":-9.5491502812526344E-2},-8.5942352531273705E-2,-7.6393202250021081E-2,-6.6844051968768442E-2,-5.7294901687515803E-2,-4.7745751406263172E-2,-3.819660112501054E-2,-2.8647450843757902E-2,-1.909830056250527E-2,-9.5491502812526351E-3,0,-8.594235253127365E-2,-0.31094235253127367,-0.58905764746872635,-0.81405764746872622,-0.9,-0.81405764746872644,-0.58905764746872635,-0.31094235253127378,-8.5942352531273705E-2,-1.350889862908481E-32]
[null,-0.8,-0.34549150281252644,-0.31094235253127378,-0.27639320225002117,-0.24184405196876849,-0.20729490168751585,-0.17274575140626322,-0.13819660112501059,-0.10364745084375793,-6.9098300562505294E-2,-3.4549150281252647E-2,0,-7.6393202250021025E-2,-0.27639320225002101,-0.52360679774997898,-0.72360679774997894,-0.8,-0.72360679774997916,-0.52360679774997898,-0.27639320225002117,-7.6393202250021081E-2,-1.2007909892519831E-32]
[null,-0.7,-0.65450849718747373,-0.58905764746872635,-0.52360679774997898,-0.45815594803123155,-0.39270509831248424,-0.32725424859373686,-0.26180339887498949,-0.19635254915624212,-0.13090169943749475,-6.5450849718747373E-2,0,-6.6844051968768387E-2,-0.24184405196876838,-0.45815594803123155,-0.63315594803123154,-0.7,-0.63315594803123165,-0.45815594803123155,-0.24184405196876849,-6.6844051968768442E-2,-1.0506921155954852E-32]
[null,-0.6,-0.90450849718747384,-0.81405764746872644,-0.72360679774997916,-0.63315594803123165,-0.54270509831248426,-0.45225424859373692,-0.36180339887498958,-0.27135254915624213,-0.18090169943749479,-9.0450849718747395E-2,0,-5.7294901687515762E-2,-0.20729490168751577,-0.39270509831248424,-0.54270509831248415,-0.6,-0.54270509831248426,-0.39270509831248424,-0.20729490168751585,-5.7294901687515803E-2,-9.0059324193898735E-33]
[null,-0.5,-1,-0.9,-0.8,-0.7,-0.6,-0.5,-0.4,-0.3,-0.2,-0.1,0,-4.7745751406263137E-2,-0.17274575140626314,-0.32725424859373686,-0.45225424859373681,-0.5,-0.45225424859373692,-0.32725424859373686,-0.17274575140626322,-4.7745751406263172E-2,-7.5049436828248946E-33]
[null,-0.4,-0.90450849718747361,-0.81405764746872622,-0.72360679774997894,-0.63315594803123154,-0.54270509831248415,-0.45225424859373681,-0.36180339887498947,-0.27135254915624207,-0.18090169943749473,-9.0450849718747367E-2,0,-3.8196601125010513E-2,-0.1381966011250105,-0.26180339887498949,-0.36180339887498947,-0.4,-0.36180339887498958,-0.26180339887498949,-0.13819660112501059,-3.819660112501054E-2,-6.0039549462599157E-33]
[null,-0.3,-0.65450849718747373,-0.58905764746872635,-0.52360679774997898,-0.45815594803123155,-0.39270509831248424,-0.32725424859373686,-0.26180339887498949,-0.19635254915624212,-0.13090169943749475,-6.5450849718747373E-2,0,-2.8647450843757881E-2,-0.10364745084375789,-0.19635254915624212,-0.27135254915624207,-0.3,-0.27135254915624213,-0.19635254915624212,-0.10364745084375793,-2.8647450843757902E-2,-4.5029662096949368E-33]
[null,-0.2,-0.34549150281252627,-0.31094235253127367,-0.27639320225002101,-0.24184405196876838,-0.20729490168751577,-0.17274575140626314,-0.1381966011250105,-0.10364745084375789,-6.9098300562505252E-2,-3.4549150281252626E-2,0,-1.9098300562505256E-2,-6.9098300562505252E-2,-0.13090169943749475,-0.18090169943749473,-0.2,-0.18090169943749479,-0.13090169943749475,-6.9098300562505294E-2,-1.909830056250527E-2,-3.0019774731299578E-33]
[null,-0.1,-9.5491502812526274E-2,-8.594235253127365E-2,-7.6393202250021025E-2,-6.6844051968768387E-2,-5.7294901687515762E-2,-4.7745751406263137E-2,-3.8196601125010513E-2,-2.8647450843757881E-2,-1.9098300562505256E-2,-9.5491502812526281E-3,0,-9.5491502812526281E-3,-3.4549150281252626E-2,-6.5450849718747373E-2,-9.0450849718747367E-2,-0.1,-9.0450849718747395E-2,-6.5450849718747373E-2,-3.4549150281252647E-2,-9.5491502812526351E-3,-1.5009887365649789E-33]
[null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,0.1,-9.5491502812526274E-2,-8.594235253127365E-2,-7.6393202250021025E-2,-6.6844051968768387E-2,-5.7294901687515762E-2,-4.7745751406263137E-2,-3.8196601125010513E-2,-2.8647450843757881E-2,-1.9098300562505256E-2,-9.5491502812526281E-3,0,9.5491502812526281E-3,3.4549150281252626E-2,6.5450849718747373E-2,9.0450849718747367E-2,0.1,9.0450849718747395E-2,6.5450849718747373E-2,3.4549150281252647E-2,9.5491502812526351E-3,1.5009887365649789E-33]
[null,0.2,-0.34549150281252627,-0.31094235253127367,-0.27639320225002101,-0.24184405196876838,-0.20729490168751577,-0.17274575140626314,-0.1381966011250105,-0.10364745084375789,-6.9098300562505252E-2,-3.4549150281252626E-2,0,1.9098300562505256E-2,6.9098300562505252E-2,0.13090169943749475,0.18090169943749473,0.2,0.18090169943749479,0.13090169943749475,6.9098300562505294E-2,1.909830056250527E-2,3.0019774731299578E-33]
[null,0.3,-0.65450849718747373,-0.58905764746872635,-0.52360679774997898,-0.45815594803123155,-0.39270509831248424,-0.32725424859373686,-0.26180339887498949,-0.19635254915624212,-0.13090169943749475,-6.5450849718747373E-2,{"$f":"IF(M$7>0,$B21*SIN(PI()*M$7)^2,M$7*SIN(PI()*$B21)^2)","v":0},2.8647450843757881E-2,0.10364745084375789,0.19635254915624212,0.27135254915624207,0.3,0.27135254915624213,0.19635254915624212,0.10364745084375793,2.8647450843757902E-2,4.5029662096949368E-33]
[null,0.4,-0.90450849718747361,-0.81405764746872622,-0.72360679774997894,-0.63315594803123154,-0.54270509831248415,-0.45225424859373681,-0.36180339887498947,-0.27135254915624207,-0.18090169943749473,-9.0450849718747367E-2,0,3.8196601125010513E-2,0.1381966011250105,0.26180339887498949,0.36180339887498947,0.4,0.36180339887498958,0.26180339887498949,0.13819660112501059,3.819660112501054E-2,6.0039549462599157E-33]
[null,0.5,-1,-0.9,-0.8,-0.7,-0.6,-0.5,-0.4,-0.3,-0.2,-0.1,0,4.7745751406263137E-2,0.17274575140626314,0.32725424859373686,0.45225424859373681,0.5,0.45225424859373692,0.32725424859373686,0.17274575140626322,4.7745751406263172E-2,7.5049436828248946E-33]
[null,0.6,-0.90450849718747384,-0.81405764746872644,-0.72360679774997916,-0.63315594803123165,-0.54270509831248426,-0.45225424859373692,-0.36180339887498958,-0.27135254915624213,-0.18090169943749479,-9.0450849718747395E-2,0,5.7294901687515762E-2,0.20729490168751577,0.39270509831248424,0.54270509831248415,0.6,0.54270509831248426,0.39270509831248424,0.20729490168751585,5.7294901687515803E-2,9.0059324193898735E-33]
[null,0.7,-0.65450849718747373,-0.58905764746872635,-0.52360679774997898,-0.45815594803123155,-0.39270509831248424,-0.32725424859373686,-0.26180339887498949,-0.19635254915624212,-0.13090169943749475,-6.5450849718747373E-2,0,6.6844051968768387E-2,0.24184405196876838,0.45815594803123155,0.63315594803123154,0.7,0.63315594803123165,0.45815594803123155,0.24184405196876849,6.6844051968768442E-2,1.0506921155954852E-32]
[null,0.8,-0.34549150281252644,-0.31094235253127378,-0.27639320225002117,-0.24184405196876849,-0.20729490168751585,-0.17274575140626322,-0.13819660112501059,-0.10364745084375793,-6.9098300562505294E-2,-3.4549150281252647E-2,0,7.6393202250021025E-2,0.27639320225002101,0.52360679774997898,0.72360679774997894,0.8,0.72360679774997916,0.52360679774997898,0.27639320225002117,7.6393202250021081E-2,1.2007909892519831E-32]
[null,0.9,-9.5491502812526344E-2,-8.5942352531273705E-2,-7.6393202250021081E-2,-6.6844051968768442E-2,-5.7294901687515803E-2,-4.7745751406263172E-2,-3.819660112501054E-2,-2.8647450843757902E-2,-1.909830056250527E-2,-9.5491502812526351E-3,0,8.594235253127365E-2,0.31094235253127367,0.58905764746872635,0.81405764746872622,0.9,0.81405764746872644,0.58905764746872635,0.31094235253127378,8.5942352531273705E-2,1.350889862908481E-32]
[null,1,-1.5009887365649789E-32,-1.350889862908481E-32,-1.2007909892519831E-32,-1.0506921155954852E-32,-9.0059324193898735E-33,-7.5049436828248946E-33,-6.0039549462599157E-33,-4.5029662096949368E-33,-3.0019774731299578E-33,-1.5009887365649789E-33,0,9.5491502812526274E-2,0.34549150281252627,0.65450849718747373,0.90450849718747361,1,0.90450849718747384,0.65450849718747373,0.34549150281252644,9.5491502812526344E-2,1.5009887365649789E-32]