{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Лист1","Лист2","Лист3","Лист4"],"not_rendered":{"charts":3,"images":6,"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":"Лист1","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Лист2","index":1,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[[7,2,27,7],[0,0,0,7],[1,0,1,7],[2,2,2,7],[3,2,3,7],[5,0,5,7],[6,3,6,7]]}
["Задача №1"]
["Число оборотов двигателя y функционально зависит от температуры x. Вычислить число оборотов двигателя y(x) при температуре a и b. Построить график этой функциональной зависимости на интервале [a,b] с шагом 0,05l; l – длина отрезка [a,b]. "]
["a","b","y(x)"]
[-5.8339999999999996,0.32500000000000001]
[]
["Решение"]
["x","y",null,"Функциональная зависимость"]
[-5.8339999999999996,{"$f":"IF(A8<=-1*PI(),LN(COS(5*A8)-2*A8)+1,0.35*TAN(0.1*A8)-2*EXP(-0.1*A8))","v":3.4017968366462741}]
[{"$f":"A8+0.30795","v":-5.5260499999999997},{"$f":"IF(A9<=-1*PI(),LN(COS(5*A9)-2*A9)+1,0.35*TAN(0.1*A9)-2*EXP(-0.1*A9))","v":3.3275166818994109}]
[{"$f":"A9+0.30795","v":-5.2180999999999997},3.3989451342081334]
[-4.9101499999999998,3.3660921215152064]
[-4.6021999999999998,3.161126068422818]
[-4.2942499999999999,3.0438960224618663]
[-3.9863,3.1332444637444659]
[-3.67835,3.1106645405299802]
[-3.3704000000000001,2.8448067176227081]
[-3.0624500000000001,-2.8272973620486663]
[-2.7545000000000002,-2.7331685692155068]
[{"$f":"A18+0.30795","v":-2.4465500000000002},-2.6417408672639633]
[-2.1386000000000003,-2.552911920566713]
[-1.8306500000000003,-2.4665831560890736]
[-1.5227000000000004,-2.3826594587335514]
[-1.2147500000000004,-2.3010488906137669]
[-0.90680000000000049,-2.2216624299855674]
[-0.59885000000000055,-2.1444137260986293]
[-0.29090000000000055,-2.0692188666454556]
[1.7049999999999454E-2,-1.9959961547952885]
[0.32499999999999946,-1.9246658930218814]

{"sheet":"Лист3","index":2,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[[6,2,26,7],[0,0,0,7],[1,0,1,7],[2,0,2,7],[4,0,4,7],[5,2,5,7]]}
["Задача № 2"]
["Число оборотов f, как и в предыдущей задаче функционально зависит от температуры x. Требуется найти температуру, при которой число оборотов равно нулю, то есть найти все корни уравнения f(x)=0 на отрезке локализаци    [-5; 5] с точностью 0,00001."]
[]
[]
["Решение"]
["x","y","Схематичный график Функции"]
[-5,{"$f":"A7^4+4*A7^3-4*A7^2-16*A7-8","v":97}]
[{"$f":"A7+0.5","v":-4.5},{"$f":"A8^4+4*A8^3-4*A8^2-16*A8-8","v":28.5625}]
[-4.1462495041676659,-9.1652261802721569E-4]
[{"$f":"A9+0.5","v":-3.6462495041676659},-19.989447295962592]
[-3.1462495041676659,-23.845068754384258]
[-2.6462495041676659,-18.756529410386079]
[-2.1462495041676659,-10.412577776471039]
[-1.3178781087465801,-2.545266534177415E-4]
[-0.68217894096276377,1.0080999370387644E-4]
[-0.18217894096276377,-5.2409775587817773]
[0.2124687130319686,-11.539667476913714]
[0.71246871303196857,-19.725646747613638]
[1.2124687130319685,-23.988978738973461]
[1.7124687130319685,-18.442257311897286]
[2.1462645039378625,8.2613752425686471E-6]
[2.6462645039378625,44.81108683405823]
[3.1462645039378625,124.6328999047729]
[3.6462645039378625,251.15424098533288]
[4.1462645039378625,437.56390358755164]
[4.6462645039378625,698.5506812232428]

{"sheet":"Лист4","index":3,"n_rows":27,"n_cols":23,"rows_kept":27,"cut":false,"hidden":false,"merged":[[7,0,19,0],[1,0,1,23],[2,0,2,23],[0,0,0,23],[4,0,4,7]]}
["Задача №1"]
["Построить таблицу значений функции z(x,y) и ее отображение в виде поверхности на области   с шагом 0,1 по каждому направлению. "]
[]
[]
["решение"]
[null,null,-1,{"$f":"C6+0.1","v":-0.9},{"$f":"D6+0.1","v":-0.8},-0.70000000000000007,-0.60000000000000009,-0.50000000000000011,-0.40000000000000013,-0.30000000000000016,-0.20000000000000015,-0.10000000000000014,-1.3877787807814457E-16,9.9999999999999867E-2,0.19999999999999987,0.29999999999999988,0.39999999999999991,0.49999999999999989,0.59999999999999987,0.69999999999999984,{"$f":"T6+0.1","v":0.79999999999999982},0.8999999999999998,{"$f":"V6+0.1","v":0.99999999999999978}]
[null,-1,{"$f":"IF(C$6*$B7>0, SIN(PI()*C$6)+SIN(PI()*$B7),SIN(PI()*ABS(C$6))*SIN(PI()*$B7))","v":-2.45029690981724E-16},{"$f":"IF(D$6*$B7>0, SIN(PI()*D$6)+SIN(PI()*$B7),SIN(PI()*ABS(D$6))*SIN(PI()*$B7))","v":-0.30901699437494762},-0.58778525229247336,-0.80901699437494756,-0.95105651629515364,-1.0000000000000002,-0.95105651629515375,-0.80901699437494778,-0.58778525229247358,-0.30901699437494795,-5.5849840774194097E-16,-3.7859169319897205E-17,-7.201241936641964E-17,-9.911659206532823E-17,-1.1651854214697822E-16,-1.22514845490862E-16,-1.1651854214697825E-16,-9.9116592065328304E-17,-7.2012419366419739E-17,-3.7859169319897322E-17,-1.2382492922352861E-31]
[null,{"$f":"B7+0.1","v":-0.9},{"$f":"IF(C$6*$B8>0, SIN(PI()*C$6)+SIN(PI()*$B8),SIN(PI()*ABS(C$6))*SIN(PI()*$B8))","v":-0.30901699437494762},-0.61803398874989501,-0.89680224666742081,-1.1180339887498949,-1.2600735106701011,-1.3090169943749475,-1.2600735106701011,-1.1180339887498951,-0.89680224666742103,-0.61803398874989535,-0.30901699437494795,-9.5491502812526191E-2,-0.18163563200134017,-0.25,-0.29389262614623662,-0.30901699437494751,-0.29389262614623668,-0.25000000000000017,-0.18163563200134042,-9.5491502812526483E-2,-3.1232139504432063E-16]
[null,{"$f":"B8+0.1","v":-0.8},-0.58778525229247336,-0.89680224666742081,-1.1755705045849465,-1.3968022466674208,-1.5388417685876268,-1.5877852522924734,-1.538841768587627,-1.3968022466674208,-1.1755705045849467,-0.89680224666742103,-0.58778525229247369,-0.18163563200134,-0.34549150281252616,-0.47552825814757677,-0.55901699437494756,-0.58778525229247325,-0.55901699437494767,-0.4755282581475771,-0.34549150281252661,-0.18163563200134056,-5.9407059587058798E-16]
[null,-0.70000000000000007,-0.80901699437494756,-1.1180339887498949,-1.3968022466674208,-1.6180339887498949,-1.7600735106701011,-1.8090169943749475,-1.7600735106701011,-1.6180339887498951,-1.3968022466674208,-1.1180339887498953,-0.8090169943749479,-0.24999999999999967,-0.47552825814757654,-0.65450849718747361,-0.76942088429381339,-0.80901699437494745,-0.7694208842938135,-0.65450849718747406,-0.47552825814757715,-0.25000000000000044,-8.1766802763981415E-16]
[null,-0.60000000000000009,-0.95105651629515364,-1.2600735106701011,-1.5388417685876268,-1.7600735106701011,-1.9021130325903071,-1.9510565162951536,-1.9021130325903073,-1.7600735106701011,-1.538841768587627,-1.2600735106701013,-0.95105651629515398,-0.29389262614623618,-0.55901699437494712,-0.76942088429381317,-0.90450849718747361,-0.95105651629515353,-0.90450849718747384,-0.76942088429381361,-0.55901699437494778,-0.29389262614623707,-9.6122641583551404E-16]
[null,-0.50000000000000011,-1.0000000000000002,-1.3090169943749475,-1.5877852522924734,-1.8090169943749475,-1.9510565162951536,-2,-1.9510565162951536,-1.8090169943749477,-1.5877852522924734,-1.3090169943749479,-1.0000000000000004,-0.30901699437494701,-0.5877852522924728,-0.80901699437494723,-0.95105651629515353,-1,-0.95105651629515375,-0.80901699437494778,-0.58778525229247358,-0.30901699437494795,-1.0106932651909872E-15]
[null,-0.40000000000000013,-0.95105651629515375,-1.2600735106701011,-1.538841768587627,-1.7600735106701011,-1.9021130325903073,-1.9510565162951536,-1.9021130325903073,-1.7600735106701013,-1.538841768587627,-1.2600735106701015,-0.95105651629515409,-0.29389262614623618,-0.55901699437494712,-0.76942088429381317,-0.90450849718747373,-0.95105651629515364,-0.90450849718747395,-0.76942088429381372,-0.5590169943749479,-0.29389262614623707,-9.6122641583551423E-16]
[null,-0.30000000000000016,-0.80901699437494778,-1.1180339887498951,-1.3968022466674208,-1.6180339887498951,-1.7600735106701011,-1.8090169943749477,-1.7600735106701013,-1.6180339887498953,-1.3968022466674213,-1.1180339887498956,-0.80901699437494812,-0.24999999999999975,-0.47552825814757665,-0.65450849718747373,-0.7694208842938135,-0.80901699437494767,-0.76942088429381372,-0.65450849718747417,-0.47552825814757732,-0.2500000000000005,-8.1766802763981445E-16]
[null,-0.20000000000000015,-0.58778525229247358,-0.89680224666742103,-1.1755705045849467,-1.3968022466674208,-1.538841768587627,-1.5877852522924734,-1.538841768587627,-1.3968022466674213,-1.1755705045849469,-0.89680224666742125,-0.58778525229247391,-0.18163563200134009,-0.34549150281252627,-0.47552825814757693,-0.55901699437494767,-0.58778525229247347,-0.5590169943749479,-0.47552825814757727,-0.34549150281252677,-0.18163563200134064,-5.9407059587058827E-16]
[null,-0.10000000000000014,-0.30901699437494795,-0.61803398874989535,-0.89680224666742103,-1.1180339887498953,-1.2600735106701013,-1.3090169943749479,-1.2600735106701015,-1.1180339887498956,-0.89680224666742125,-0.61803398874989568,-0.30901699437494828,-9.5491502812526288E-2,-0.18163563200134036,-0.25000000000000028,-0.29389262614623696,-0.30901699437494784,-0.29389262614623701,-0.25000000000000044,-0.18163563200134061,-9.549150281252658E-2,-3.1232139504432098E-16]
[null,-1.3877787807814457E-16,-5.5849840774194097E-16,-0.30901699437494795,-0.58778525229247369,-0.8090169943749479,-0.95105651629515398,-1.0000000000000004,-0.95105651629515409,-0.80901699437494812,-0.58778525229247391,-0.30901699437494828,-8.7196712450215794E-16,-1.3472633000371104E-16,-2.5626470813312146E-16,-3.5271811112925062E-16,-4.1464500787646237E-16,-4.3598356225107897E-16,-4.1464500787646247E-16,-3.5271811112925087E-16,-2.562647081331218E-16,-1.3472633000371144E-16,-4.4064565010114103E-31]
[null,9.9999999999999867E-2,3.7859169319897205E-17,9.5491502812526191E-2,0.18163563200134,0.24999999999999967,0.29389262614623618,0.30901699437494701,0.29389262614623618,0.24999999999999975,0.18163563200134009,9.5491502812526288E-2,1.3472633000371104E-16,0.61803398874989401,0.89680224666741981,1.1180339887498942,1.2600735106701006,1.309016994374947,1.2600735106701006,1.1180339887498949,0.89680224666742059,0.6180339887498949,0.30901699437494801]
[null,0.19999999999999987,7.201241936641964E-17,0.18163563200134017,0.34549150281252616,0.47552825814757654,0.55901699437494712,0.5877852522924728,0.55901699437494712,0.47552825814757665,0.34549150281252627,0.18163563200134036,2.5626470813312146E-16,0.89680224666741981,1.1755705045849456,1.3968022466674199,1.5388417685876263,1.5877852522924729,{"$f":"IF(S$6*$B19>0, SIN(PI()*S$6)+SIN(PI()*$B19),SIN(PI()*ABS(S$6))*SIN(PI()*$B19))","v":1.5388417685876266},1.3968022466674206,1.1755705045849463,0.89680224666742081,0.5877852522924738]
[null,0.29999999999999988,9.911659206532823E-17,0.25,0.47552825814757677,0.65450849718747361,0.76942088429381317,0.80901699437494723,0.76942088429381317,0.65450849718747373,0.47552825814757693,0.25000000000000028,3.5271811112925062E-16,1.1180339887498942,1.3968022466674199,1.6180339887498945,1.7600735106701006,1.8090169943749472,1.7600735106701011,1.6180339887498949,1.3968022466674208,1.1180339887498951,0.80901699437494823]
[null,0.39999999999999991,1.1651854214697822E-16,0.29389262614623662,0.55901699437494756,0.76942088429381339,0.90450849718747361,0.95105651629515353,0.90450849718747373,0.7694208842938135,0.55901699437494767,0.29389262614623696,4.1464500787646237E-16,1.2600735106701006,1.5388417685876263,1.7600735106701006,1.9021130325903071,1.9510565162951536,1.9021130325903073,1.7600735106701013,1.538841768587627,1.2600735106701015,0.95105651629515453]
[null,0.49999999999999989,1.22514845490862E-16,0.30901699437494751,0.58778525229247325,0.80901699437494745,0.95105651629515353,1,0.95105651629515364,0.80901699437494767,0.58778525229247347,0.30901699437494784,4.3598356225107897E-16,1.309016994374947,1.5877852522924729,1.8090169943749472,1.9510565162951536,2,1.9510565162951536,1.8090169943749479,1.5877852522924736,1.3090169943749479,1.0000000000000011]
[null,0.59999999999999987,1.1651854214697825E-16,0.29389262614623668,0.55901699437494767,0.7694208842938135,0.90450849718747384,0.95105651629515375,0.90450849718747395,0.76942088429381372,0.5590169943749479,0.29389262614623701,4.1464500787646247E-16,1.2600735106701006,1.5388417685876266,1.7600735106701011,1.9021130325903073,1.9510565162951536,1.9021130325903075,1.7600735106701015,1.5388417685876274,1.2600735106701018,0.95105651629515475]
[null,0.69999999999999984,9.9116592065328304E-17,0.25000000000000017,0.4755282581475771,0.65450849718747406,0.76942088429381361,0.80901699437494778,0.76942088429381372,0.65450849718747417,0.47552825814757727,0.25000000000000044,3.5271811112925087E-16,1.1180339887498949,1.3968022466674206,1.6180339887498949,1.7600735106701013,1.8090169943749479,1.7600735106701015,1.6180339887498956,1.3968022466674213,1.1180339887498958,0.80901699437494878]
[null,0.79999999999999982,7.2012419366419739E-17,0.18163563200134042,0.34549150281252661,0.47552825814757715,0.55901699437494778,0.58778525229247358,0.5590169943749479,0.47552825814757732,0.34549150281252677,0.18163563200134061,2.562647081331218E-16,0.89680224666742059,1.1755705045849463,1.3968022466674208,1.538841768587627,1.5877852522924736,1.5388417685876274,1.3968022466674213,1.1755705045849472,0.89680224666742148,0.58778525229247458]
[null,0.8999999999999998,3.7859169319897322E-17,9.5491502812526483E-2,0.18163563200134056,0.25000000000000044,0.29389262614623707,0.30901699437494795,0.29389262614623707,0.2500000000000005,0.18163563200134064,9.549150281252658E-2,1.3472633000371144E-16,0.6180339887498949,0.89680224666742081,1.1180339887498951,1.2600735106701015,1.3090169943749479,1.2600735106701018,1.1180339887498958,0.89680224666742148,0.6180339887498959,0.30901699437494895]
[null,0.99999999999999978,1.2382492922352861E-31,3.1232139504432063E-16,5.9407059587058798E-16,8.1766802763981415E-16,9.6122641583551404E-16,1.0106932651909872E-15,9.6122641583551423E-16,8.1766802763981445E-16,5.9407059587058827E-16,3.1232139504432098E-16,4.4064565010114103E-31,0.30901699437494801,0.5877852522924738,0.80901699437494823,0.95105651629515453,1.0000000000000011,0.95105651629515475,0.80901699437494878,0.58778525229247458,0.30901699437494895,2.0213865303819745E-15]