{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["титульный","Лист1","Лист2","Задача 1","Задача 2","Задача 3"],"not_rendered":{"charts":3,"images":8,"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":[[0,0,1048575,16383]]}

{"sheet":"Лист1","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Лист2","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Задача 1","index":3,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[[7,2,7,3],[0,0,0,3],[3,3,5,3],[1,0,1,3],[6,0,6,3],[3,0,5,0],[3,1,5,1],[3,2,5,2]]}
["ЗАДАЧА 1"]
["Число оборотов двигателя y функционально зависит от температуры x. Вычислить число оборотов двигателя y(x) при температуре a и b. Построить график этой функциональной зависимости на интервале [a,b] с шагом 0,05l; l – длина отрезка [a,b]. "]
["№ варианта","y(x)","a","b"]
[5,null,-1.976,2.052]
[]
[]
["Решение"]
["x","y","Функциональная зависимость"]
[-1.976,{"$f":"IF(ABS(A9)>1,0,0.75*A9+(SIN(A9)/(A9^2-4)))","v":0}]
[-1.7746,0]
[-1.5731999999999999,0]
[-1.3717999999999999,0]
[-1.1703999999999999,0]
[-0.96899999999999986,{"$f":"IF(ABS(A14)>1,0,0.75*A14+(SIN(A14)/(A14^2-4)))","v":-0.45745581542453911}]
[-0.76759999999999984,{"$f":"IF(ABS(A15)>1,0,0.75*A15+(SIN(A15)/(A15^2-4)))","v":-0.3721078114033094}]
[-0.56619999999999981,-0.27885819250829769]
[-0.36479999999999979,-0.18133991341500333]
[-0.16339999999999977,-8.1608255344923442E-2]
[3.8000000000000256E-2,1.899885625537406E-2]
[0.23940000000000028,0.11940833965514967]
[0.4408000000000003,0.21848825965861124]
[0.64220000000000033,0.31469658136270939]
[0.84360000000000035,0.40552112744934787]
[1.0450000000000004,0]
[1.2464000000000004,0]
[1.4478000000000009,0]
[1.6492000000000004,0]
[1.8506000000000005,0]
[2.0520000000000005,0]

{"sheet":"Задача 2","index":4,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,0,1,3],[0,0,0,3]]}
["Задача №2"]
["Число оборотов f, как и в предыдущей задаче функционально зависит от температуры x. Требуется найти температуру, при которой число оборотов равно нулю, то есть найти все корни уравнения f(x)=0 на отрезке локализации [-3;2] с точностью 0,0001. "]
["№ варианта","Уравнение  ","Отрезок локализации","Точность"]
[3,null,"[-4; 4]",1E-4]
[-4,{"$f":"A5^3-3*A5^2-4*A5+1","v":-95}]
[-3.6,{"$f":"A6^3-3*A6^2-4*A6+1","v":-70.135999999999996}]
[-3.2,-49.688000000000017]
[-2.8,-33.271999999999991]
[-2.4,-20.503999999999998]
[-2,-11]
[-1.6,-4.376000000000003]
[-1.1659840953042429,2.0222279839732238E-4]
[-0.39999999999999991,2.056]
[0,1]
[0.21716077368024442,1.2154224962090954E-4]
[0.79999999999999982,-3.6079999999999988]
[1.2000000000000002,-6.3920000000000012]
[1.5999999999999996,-8.9839999999999982]
[2,-11]
[2.4000000000000004,-12.056000000000001]
[2.8,-11.768000000000001]
[3.5,-6.875]
[3.5999999999999996,-5.6240000000000094]
[3.9488387022532176,{"$f":"A24^3-3*A24^2-4*A24+1","v":1.9743695745688683E-4}]
[4,1]

{"sheet":"Задача 3","index":5,"n_rows":28,"n_cols":23,"rows_kept":28,"cut":false,"hidden":false,"merged":[[7,0,27,0],[3,1,3,22],[0,0,0,22],[1,0,1,22],[2,0,2,22],[4,0,4,22],[5,2,5,22]]}
["Задача №3"]
["Построить таблицу значений функции z(x,y) и ее отображение в виде поверхности на области (x,y)є[-1..1,-1..1]  с шагом 0,1 по каждому направлению."]
[]
[3]
["Решение"]
[null,null,"Ось Ox"]
[null,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]
["Ось Oy",-1,{"$f":"IF($B8>0,C$7^2+2*SIN(3.14*$B8),C$7^2-C$7*$B8* 2.7182818284^ABS($B8+0.5))","v":-0.64872127068222163},{"$f":"IF($B8>0,D$7^2+2*SIN(3.14*$B8),D$7^2-D$7*$B8* 2.7182818284^ABS($B8+0.5))","v":-0.6738491436139995},-0.67897701654577736,-0.66410488947755497,-0.6292327624093329,-0.57436063534111081,-0.49948850827288871,-0.40461638120466648,-0.28974425413644433,-0.15487212706822218,0,0.17487212706822219,0.36974425413644441,0.58461638120466641,0.81948850827288877,1.0743606353411108,1.3492327624093328,1.644104889477555,{"$f":"IF($B8>0,U$7^2+2*SIN(3.14*$B8),U$7^2-U$7*$B8* 2.7182818284^ABS($B8+0.5))","v":1.9589770165457776},2.2938491436139996,2.6487212706822216]
[null,-0.9,{"$f":"IF($B9>0,C$7^2+2*SIN(3.14*$B9),C$7^2-C$7*$B9* 2.7182818284^ABS($B9+0.5))","v":-0.34264222786547771},-0.39837800507892984,-0.43411378229238218,-0.44984955950583444,-0.44558533671928668,-0.42132111393273886,-0.37705689114619112,-0.31279266835964337,-0.22852844557309557,-0.12426422278654778,0,0.1442642227865478,0.30852844557309556,0.4927926683596433,0.69705689114619118,0.92132111393273886,1.1655853367192868,{"$f":"IF($B9>0,T$7^2+2*SIN(3.14*$B9),T$7^2-T$7*$B9* 2.7182818284^ABS($B9+0.5))","v":1.4298495595058343},1.7141137822923824,2.0183780050789299,2.3426422278654777]
[null,-0.8,-7.9887046053765509E-2,-0.16189834144838899,-0.22390963684301246,-0.26592093223763585,-0.28793222763225934,-0.28994352302688275,-0.27195481842150626,-0.23396611381612967,-0.17597740921075314,-9.7988704605376564E-2,0,0.11798870460537658,0.25597740921075318,0.41396611381612969,0.59195481842150632,0.78994352302688275,1.0079322276322593,1.2459209322376357,1.5039096368430127,1.7818983414483891,2.0798870460537655]
[null,-0.7,0.14501806929159544,4.0516262362435995E-2,-4.3985544566723433E-2,-0.10848735149588312,-0.15298915842504268,-0.17749096535420228,-0.18199277228336175,-0.16649457921252134,-0.13099638614168088,-7.5498193070840436E-2,0,9.5498193070840454E-2,0.2109963861416809,0.34649457921252136,0.50199277228336181,0.67749096535420228,0.87298915842504266,1.088487351495883,1.3239855445667237,1.5794837376375641,1.8549819307084046]
[null,-0.6,0.3368974491560518,0.21320770424044666,0.10951795932484165,2.5828214409236216E-2,-3.7861530506368923E-2,-8.1551275421974101E-2,-0.10524102033757921,-0.10893076525318446,-9.262051016878961E-2,-5.6310255084394807E-2,0,7.6310255084394818E-2,0.17262051016878963,0.28893076525318445,0.42524102033757927,0.58155127542197405,0.75786153050636895,0.95417178559076365,1.1704820406751586,1.4067922957595536,1.6631025508439481]
[null,-0.5,0.5,0.36000000000000004,0.2400000000000001,0.13999999999999996,0.06,0,-3.999999999999998E-2,-0.06,-0.06,-0.04,0,6.0000000000000005E-2,0.14000000000000001,0.24,0.36000000000000004,0.5,0.65999999999999992,0.83999999999999986,1.04,1.26,1.5]
[null,-0.4,0.55793163277070112,0.41213846949363109,0.28634530621656101,0.18055214293949079,9.475897966242075E-2,2.896581638535059E-2,-1.6827346891719525E-2,-4.2620510168789622E-2,-4.841367344585977E-2,-3.4206836722929887E-2,0,5.4206836722929891E-2,0.1284136734458598,0.22262051016878961,0.33682734689171956,0.47103418361464944,0.62524102033757922,0.79944785706050903,0.99365469378343918,1.2078615305063689,1.4420683672292989]
[null,-0.3,0.6335791725535409,0.48022125529818682,0.34686333804283287,0.2335054207874786,0.14014750353212455,6.6789586276770452E-2,1.3431669021416404E-2,-1.9926248233937724E-2,-3.3284165489291806E-2,-2.6642082744645905E-2,0,4.6642082744645909E-2,0.11328416548929182,0.19992624823393773,0.30656833097858366,0.43321041372322955,0.5798524964678754,0.74649457921252127,0.93313666195716738,1.1397787447018133,1.3664208274464591]
[null,-0.2,0.73002823848655862,0.56702541463790279,0.42402259078924698,0.30101976694059102,0.19801694309193518,0.11501411924327934,5.2011295394623472E-2,9.0084715459675946E-3,-1.3994352302688272E-2,-1.6997176151344138E-2,0,3.6997176151344138E-2,9.3994352302688294E-2,0.1709915284540324,0.2679887046053766,0.38498588075672069,0.52198305690806479,0.6789802330594088,0.85597740921075327,1.0529745853620973,1.2699717615134414]
[null,-0.1,0.85081753023716911,0.67573577721345224,0.52065402418973539,0.38557227116601833,0.27049051814230146,0.17540876511858455,0.10032701209486768,4.5245259071150741E-2,1.016350604743383E-2,-4.9182469762830867E-3,0,2.4918246976283091E-2,6.9836493952566192E-2,0.13475474092884926,0.2196729879051324,0.32459123488141545,0.44950948185769851,0.59442772883398154,0.75934597581026486,0.94426422278654787,1.1491824697628308]
[null,0,1,0.81,0.64000000000000012,0.48999999999999994,0.36,0.25,0.16000000000000003,0.09,4.0000000000000008E-2,1.0000000000000002E-2,0,1.0000000000000002E-2,4.0000000000000008E-2,0.09,0.16000000000000003,0.25,{"$f":"IF($B18>0,S$7^2+2*SIN(3.14*$B18),S$7^2-S$7*$B18* 2.7182818284^ABS($B18+0.5))","v":0.36},0.48999999999999994,0.64000000000000012,0.81,1]
[null,0.1,1.6177310401978644,1.4277310401978645,1.2577310401978645,1.1077310401978644,0.97773104019786439,0.8677310401978644,0.77773104019786443,0.70773104019786437,0.65773104019786444,0.62773104019786441,0.6177310401978644,0.62773104019786441,0.65773104019786444,0.70773104019786437,0.77773104019786443,0.8677310401978644,0.97773104019786439,1.1077310401978644,1.2577310401978645,1.4277310401978645,1.6177310401978644]
[null,0.2,2.1750550514277842,1.985055051427784,1.8150550514277841,1.665055051427784,1.5350550514277841,1.425055051427784,1.3350550514277839,1.2650550514277841,1.215055051427784,1.185055051427784,1.175055051427784,1.185055051427784,1.215055051427784,1.2650550514277841,1.3350550514277839,1.425055051427784,1.5350550514277841,1.665055051427784,1.8150550514277841,1.985055051427784,2.1750550514277842]
[null,0.3,2.6174721211062604,2.4274721211062604,2.2574721211062605,2.1074721211062601,1.9774721211062602,1.8674721211062604,1.7774721211062605,1.7074721211062605,1.6574721211062604,1.6274721211062604,1.6174721211062604,1.6274721211062604,1.6574721211062604,1.7074721211062605,1.7774721211062605,1.8674721211062604,1.9774721211062602,2.1074721211062601,2.2574721211062605,2.4274721211062604,2.6174721211062604]
[null,0.4,2.9017189210129399,2.71171892101294,2.5417189210129401,2.3917189210129397,2.2617189210129398,2.1517189210129399,2.0617189210129401,1.99171892101294,1.94171892101294,1.9117189210129399,1.9017189210129399,1.9117189210129399,1.94171892101294,1.99171892101294,2.0617189210129401,2.1517189210129399,2.2617189210129398,2.3917189210129397,2.5417189210129401,2.71171892101294,2.9017189210129399]
[null,0.5,2.999999365863669,2.8099993658636695,2.6399993658636696,2.4899993658636692,2.3599993658636693,2.249999365863669,2.1599993658636691,2.0899993658636693,2.039999365863669,2.0099993658636692,1.9999993658636692,2.0099993658636692,2.039999365863669,2.0899993658636693,2.1599993658636691,2.249999365863669,2.3599993658636693,2.4899993658636692,2.6399993658636696,2.8099993658636695,2.999999365863669]
[null,0.6,2.9027027524676572,{"$f":"IF($B24>0,D$7^2+2*SIN(3.14*$B24),D$7^2-D$7*$B24* 2.7182818284^ABS($B24+0.5))","v":2.7127027524676572},2.5427027524676573,2.392702752467657,2.2627027524676571,2.1527027524676572,2.0627027524676573,1.9927027524676573,1.9427027524676572,1.9127027524676572,1.9027027524676572,1.9127027524676572,1.9427027524676572,1.9927027524676573,2.0627027524676573,2.1527027524676572,2.2627027524676571,2.392702752467657,2.5427027524676573,2.7127027524676572,2.9027027524676572]
[null,0.7,2.6193435765543285,2.4293435765543285,2.2593435765543286,2.1093435765543282,1.9793435765543284,1.8693435765543285,1.7793435765543286,1.7093435765543286,1.6593435765543285,1.6293435765543285,1.6193435765543285,1.6293435765543285,1.6593435765543285,1.7093435765543286,1.7793435765543286,1.8693435765543285,1.9793435765543284,2.1093435765543282,2.2593435765543286,2.4293435765543285,2.6193435765543285]
[null,0.8,2.1776311239355897,1.9876311239355899,1.81763112393559,1.6676311239355899,1.53763112393559,1.4276311239355899,1.3376311239355898,1.26763112393559,1.2176311239355899,1.1876311239355899,1.1776311239355899,1.1876311239355899,1.2176311239355899,1.26763112393559,1.3376311239355898,1.4276311239355899,1.53763112393559,1.6676311239355899,1.81763112393559,1.9876311239355899,2.1776311239355897]
[null,0.9,1.6207598193440833,1.4307598193440834,1.2607598193440834,1.1107598193440833,0.98075981934408329,0.87075981934408331,0.78075981934408334,0.71075981934408328,0.66075981934408334,0.63075981934408332,0.62075981934408331,0.63075981934408332,0.66075981934408334,0.71075981934408328,0.78075981934408334,0.87075981934408331,0.98075981934408329,1.1107598193440833,1.2607598193440834,1.4307598193440834,1.6207598193440833]
[null,1,1.0031853058329736,0.81318530583297366,0.64318530583297373,0.4931853058329736,0.36318530583297365,0.25318530583297366,0.16318530583297369,9.3185305832973658E-2,4.3185305832973662E-2,1.3185305832973658E-2,3.1853058329736565E-3,1.3185305832973658E-2,4.3185305832973662E-2,9.3185305832973658E-2,0.16318530583297369,0.25318530583297366,0.36318530583297365,0.4931853058329736,0.64318530583297373,0.81318530583297366,1.0031853058329736]