{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":17,"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":100,"n_cols":17,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
["X","Y1","Y2","Аппроксимация1","Аппроксимация2",10,9,8,7,6,5,4,3,2,1,0,"Корреляция"]
[0.84155706294845189,1.1791924529941379E-2,0.162134296944593,{"$f":"(A2^10)*F$2+(A2^9)*G$2+(A2^8)*H$2+(A2^7)*I$2+(A2^6)*J$2+(A2^5)*K$2+(A2^4)*L$2+(A2^3)*M$2+(A2^2)*N$2+A2*O$2+P$2","v":0.98572902332697576},{"$f":"D2*F$3+G$3","v":3.5934121682089426E-2},0,0,-4.997916161851928E-15,-9.1533690538394217E-14,-7.1040104843126507E-10,3.4583170286575889E-11,-3.8751767708925256E-13,1.5747726317029564E-5,-2.9559546992999716E-4,1.1038870483588714E-3,0.98499999999999999,{"$f":"CORREL(C2:C100,E2:E100)","v":0.86626966406039407}]
[1.1018998052932241,8.281348857095315E-2,0.10374458736622412,{"$f":"(A3^10)*F$2+(A3^9)*G$2+(A3^8)*H$2+(A3^7)*I$2+(A3^6)*J$2+(A3^5)*K$2+(A3^4)*L$2+(A3^3)*M$2+(A3^2)*N$2+A3*O$2+P$2","v":0.98587853367184963},2.9050900534741686E-2,{"$f":"SLOPE(C2:C100,D2:D100)","v":-46.038427328628337},{"$f":"INTERCEPT(C2:C100,D2:D100)","v":45.417348127840853}]
[1.2290091965296139,5.2632280406004595E-2,8.1428928945310591E-2,0.98593943244709603,2.6247216696155817E-2]
[1.3197665072398885,4.5300519938103592E-2,4.5281529020264964E-2,0.98597820623486931,2.4462132485496113E-2,"В ячейке R2C17 - кэф корреляции"]
[1.3905046942430361,3.6961761038079237E-2,2.2792792994146702E-2,0.98600575882453911,2.3193654588268942E-2,"Ячейки R6-R16 - кэфы при степенях полинома (от 10 до нулевой)"]
[1.4501014460938646,3.5933981046687755E-2,1.2239736421326386E-2,0.98602718436700854,2.2207256308313106E-2,"В столбцах Аппроксимация1 и Аппроксимация 2 - расчетные значения функции Y2 при данном значении Х (фактические значения функций в столбцах Y1 и Y2)"]
[1.5034051428285387,2.4414840835742725E-2,-5.848875932841298E-3,0.98604498001121055,2.1387972835952951E-2,"Аппроксимация 2 - линейное преобразование, кэфы меняются по функциям эксель 9см. Ячейки R3C7 и К3С8)"]
[1.556142038214049,6.5481493751315834E-3,-5.9254082528365417E-3,0.98606133022748033,2.0635234592411678E-2,"В столбце Х - значения переменной"]
[1.6051376492099498,1.8233858744949996E-2,-7.603478854435991E-3,0.98607541298356827,1.9986886649668634E-2]
[1.6509587301392592,1.0879958753229835E-2,-4.6913156715978899E-3,0.9860876279840316,1.9424527238520284E-2]
[1.6934874715731156,4.6907597636665615E-3,-2.8895615316775832E-3,0.98609814721776168,1.894023826088187E-2]
[1.7337931245697078,5.0611664538146289E-3,6.9620686061971655E-3,0.98610739639173284,1.8514420837163925E-2,null,null,null,"a"]
[1.772505084768228,1.2218252746623106E-2,-5.2417589532862061E-3,0.9861156258374737,1.8135550097468922E-2]
[1.8076780957944099,1.5687307083022201E-2,-4.7363431785517529E-3,0.98612255199142951,1.7816680861905354E-2]
[1.8422532740043123,1.6765798308415382E-2,1.4754418906713467E-3,0.9861288532327811,1.7526581619861759E-2]
[1.8765378151410603,1.167328300559042E-2,-5.3471961388487374E-3,0.98613460883346715,1.7261602815942467E-2]
[1.9099284523222828,8.7191226622606623E-3,-1.4549192043384257E-2,0.98613974641247126,1.7025076758315549E-2]
[1.940060484095635,1.5658100095210618E-2,-7.430066215483447E-3,0.98614398916732093,1.682974699749451E-2]
[1.9755848312965136,6.7205890138616661E-3,-3.6013365122547062E-3,0.98614851536834536,1.6621367820562227E-2]
[2.0040406878421342,9.0376005547946284E-3,-1.2255111373988856E-2,0.98615177223053307,1.647142700741E-2]
[2.0347202273141285,9.53035916062012E-3,-4.0177147853641421E-3,0.98615491884108453,1.6326562006206302E-2]
[2.0666448014066385,3.3055576317438752E-2,-1.2751161325112222E-3,0.9861577941662405,1.6194186557967782E-2]
[2.0945320061950343,2.7223528407143677E-2,1.3781023280133198E-3,0.98615997524132137,1.6093773291359526E-2]
[2.1239796279485104,3.2343047964048792E-2,3.9307599342144965E-4,0.98616194605037999,1.6003040341736607E-2]
[2.1536698834552781,3.3061271489996158E-2,1.0416805663100484E-2,0.98616358990238273,1.5927359980764777E-2]
[2.1803407096339718,4.0501256426160655E-2,2.8961552354089789E-3,0.98616477477446007,1.5872810333739551E-2]
[2.2085167289130805,2.4216054447725489E-2,2.9505267725451053E-3,0.9861657285645099,1.5828899339844327E-2]
[2.2373033320320315,1.3996226654021393E-2,-5.6922749620577136E-3,0.9861663890117679,1.5798493386753876E-2]
[2.264664813697097,8.0390207265447771E-4,-7.8701495411871193E-4,0.98616672458448229,1.5783044146729708E-2]
[2.2932501145848341,-7.1543442700103084E-3,-1.390693110154414E-2,0.98616677312658441,1.5780809344690283E-2]
[2.3220181183025046,-8.2716165423395577E-3,-7.764871555115023E-3,0.9861665125443273,1.5792806141995186E-2]
[2.3489849413788062,-8.4765132417772907E-3,-5.8701190671144304E-3,0.98616598837572467,1.5816938040117634E-2]
[2.3771150374301455,-1.7214787726178009E-3,4.6178598103312927E-3,0.98616515498563706,{"$f":"D34*F$3+G$3","v":1.58553060091009E-2}]
[2.4052441154446482,1.7316604209134813E-3,-1.0978079538962222E-2,0.98616403102962336,1.5907051176355935E-2]
[2.433276536965415,7.4844804508168742E-3,-2.7112842100467374E-3,0.98616262390520915,1.597183297144511E-2]
[2.4616928258139459,3.6053607534268796E-3,-9.8893546197949128E-3,0.98616090717248972,1.605086864599059E-2]
[2.4920159534642514,3.620934011825673E-3,-1.1012785728991423E-2,0.98615875524744101,1.6149939890958365E-2]
[2.5173330606993876,2.1676149602714708E-3,-1.5714332212422081E-2,0.98615670735157956,1.6244221795751912E-2]
[2.5461778883899591,-1.7537602346585288E-3,-2.0169655402489952E-3,0.98615409751631478,1.6364374506935064E-2]
[2.5739641699849876,5.7862822459010437E-3,-2.8630300284297914E-3,0.98615130687875696,1.6492851071340908E-2]
[2.6010269537791317,1.2949271382781614E-2,2.9929492215437885E-3,0.98614832993095902,1.6629905066196216E-2]
[2.6296524864516693,1.4109520427508413E-2,2.9039637850745174E-3,0.98614490502284669,1.6787582449431682E-2]
[2.6595210676273653,1.5980894004070715E-2,3.5686867743737762E-3,0.98614103115033602,1.6965929447493977E-2]
[2.6901277098458256,2.6347757473728833E-2,1.0299171344777144E-2,0.9861367460289302,1.7163209697933723E-2]
[2.7187616055708328,1.447232984817568E-2,1.4372340952710339E-2,0.98613245028329299,1.7360979071270322E-2]
[2.7481550231843621,2.1221393129967691E-2,7.6079819153100792E-3,0.98612775453109269,1.7577164117696498E-2]
[2.7776836477407256,1.0402000154845929E-2,1.5821375830609059E-2,0.98612274772630382,1.7807669536118453E-2]
[2.8073923911144849,1.07967424417937E-2,2.4676039065663128E-2,0.98611742001426705,1.8052949019555342E-2]
[2.8380590024110028,4.9342665235552934E-3,1.8494017492134637E-2,0.98611161760991817,1.8320082590498998E-2]
[2.8683722012166406,5.4294092349417566E-3,1.3252411374069956E-2,0.98610558223790534,1.8597941626310899E-2]
[2.8985922970042566,-4.9270757191136622E-3,2.3197462996071855E-2,0.98609927124849373,1.8888489653711815E-2]
[2.9294749926087329,1.079053895905431E-2,1.6570771922915881E-2,0.98609252111189716,1.919925532687472E-2]
[2.9631169757104723,1.0767368150297236E-2,8.7665169571051853E-3,0.98608482503936101,1.955357040304051E-2]
[2.996457496305724,1.0544441321967709E-2,1.9673985581251142E-3,0.98607684859471911,1.9920793370026502E-2]
[3.0271436123708306,4.4988769782017711E-3,5.0998712170442417E-3,0.98606920280978072,2.0272793284284774E-2]
[3.0635717017097788,9.3179675989860915E-3,8.7363487465094963E-3,0.98605975135554969,2.0707923373052495E-2]
[3.0975730321785373,-1.3366116778413234E-2,1.0103773653919458E-2,0.98605056595154872,2.1130804927636859E-2]
[3.1318879068904235,-1.7716926909525667E-2,6.3907035248175811E-3,0.98604094368194128,2.1573799087690304E-2]
[3.1664551740505824,-1.8456852177597363E-2,2.8837179108605959E-2,0.98603089670083743,2.2036346297113596E-2]
[3.2023860949382579,-8.6870153659744202E-3,1.7881013186167097E-2,0.98602008090572835,2.2534288494242105E-2]
[3.2395117921060015,-1.8104326014863434E-2,2.5360339306829703E-2,0.98600851110737331,2.3066943815017282E-2]
[3.2788130971645764,1.0700801892413278E-3,2.6634406588615128E-2,0.98599583173602723,2.3650682131311385E-2]
[3.3183542350137261,-3.4782253312200527E-4,3.1352057696505994E-2,0.98598263258033514,2.4258350501440873E-2]
[3.3592775090513696,4.5012737598582415E-3,2.4662102424915577E-2,0.9859685107735725,2.4908496275827474E-2]
[3.4034035533807647,1.1893367961410189E-2,4.3903308359644233E-2,0.9859527651466391,{"$f":"D66*F$3+G$3","v":2.5633400177149213E-2}]
[3.4451237284975917,2.2090563438390543E-2,3.3177390932985648E-2,{"$f":"(A67^10)*F$2+(A67^9)*G$2+(A67^8)*H$2+(A67^7)*I$2+(A67^6)*J$2+(A67^5)*K$2+(A67^4)*L$2+(A67^3)*M$2+(A67^2)*N$2+A67*O$2+P$2","v":0.98593738998871372},2.6341248267961248E-2]
[3.4895510825189473,1.2809993680231386E-2,4.7352613230672892E-2,0.98592050320587266,2.7118689192604961E-2]
[3.5318801860464553,2.0474907918844303E-2,5.345159266925692E-2,0.98590392798254256,2.7881786407341735E-2]
[3.578143851131069,1.9306417186607382E-2,5.184867239204579E-2,0.98588527791807712,2.8740406044910571E-2]
[3.6263478623068974,1.2641996945737127E-2,5.5783923874756412E-2,0.98586526160889054,2.9661925440784387E-2]
[3.6777986482426575,2.7931258252959813E-3,5.6691999075251534E-2,0.98584325078232793,3.0675269279925033E-2]
[3.7274805714159545,-4.5287721876605099E-3,6.1422001182563392E-2,0.98582137462413055,3.1682413199327186E-2]
[3.7791075533329739,-1.1836647218491151E-2,7.0445748850450851E-2,0.98579800648093763,3.2758245761520755E-2]
[3.8392200164744033,-1.876240982119834E-3,6.0474003095674522E-2,0.98576999760857564,3.4047730196313353E-2]
[3.897545772068097,5.8361091177912688E-3,5.9603086283501402E-2,0.98574201615541879,3.533595229402664E-2]
[3.9585951597109337,2.1690409630009073E-2,7.500855627252509E-2,0.98571189824108085,3.6722533704562466E-2]
[4.0161995662114274,3.4893169811774719E-2,6.3907447254640232E-2,0.98568271961901444,3.806587157611574E-2]
[4.0833897446123038,5.3242316096637335E-2,7.317480528498016E-2,0.98564777596652808,3.9674622381703273E-2]
[4.1498442382770016,4.2819497666104468E-2,7.9578648638726421E-2,0.98561227673140561,4.1308951338116628E-2]
[4.2235307313297765,3.5735087253158229E-2,7.5184055488889581E-2,0.98557185498711564,4.3169904875107079E-2]
[4.3014344180780455,2.2151081660527042E-2,7.9239678830491184E-2,0.98552794634237517,4.5191389825085082E-2]
[4.3829936398112999,2.2905772635820734E-2,7.5537600258576254E-2,0.98548072939196907,4.7365183965034419E-2]
[4.4708600602133339,1.432985616692809E-2,5.2876764877055629E-2,0.98542848628347557,4.9770374518836036E-2]
[4.5654041478057446,1.009902503359968E-2,5.6412699297231736E-2,0.98537074630614563,5.242863226909833E-2]
[4.6653934338049297,9.4395184811494146E-3,5.1506756383382299E-2,0.98530803844206194,5.5315603712649875E-2]
[4.7768434141387583,1.9224710836685626E-2,5.3519548763824622E-2,0.98523625679821913,5.862031770623588E-2]
[4.9002122267383612,1.3897032742633366E-2,6.1860484880967959E-2,0.98515461796824455,6.2378841047213029E-2]
[5.0296842284005656,1.8449275887266095E-2,8.2364401298200191E-2,0.9850666448504023,6.642898503987027E-2]
[5.1799631100368915,4.3079367328194354E-2,8.8406050018115606E-2,0.98496182332316684,7.125480330397238E-2]
[5.3530212625758926,4.1243675357998069E-2,0.10868523534823357,0.98483785602364349,7.6962062814203591E-2]
[5.5495772461564368,4.111622614971501E-2,0.10222760426802198,0.9846933439115404,8.3615173185371816E-2]
[5.7776129589707983,5.6461361803980738E-2,0.11550225129730826,0.98452151673610389,9.1525826114789766E-2]
[6.0433169326339478,5.9604770919025482E-2,0.11885922102134976,0.98431684582248713,0.10094855309761641]
[6.3563376668731655,5.1534593488170431E-2,0.13898027313334915,0.98407143621067716,0.11224682567667799]
[6.7556229119139539,7.3968929591833293E-2,0.13623411970844618,0.98375508122951327,0.12681131148703884]
[7.3263173565349069,9.2444294693811588E-2,0.1580176062200695,0.98330471967343991,0.14754524925793078]
[8.1356399810473849,0.10238158806292955,0.18034965901071895,0.98269063621491337,{"$f":"D98*F$3+G$3","v":0.17581668593701494}]
[9.5866421087761182,0.14186564704584484,0.20865940092227742,0.98174106623064383,0.21953339465125765]
[16.406568604643063,0.13026496318548494,0.25917265011128476,0.97922021866526809,0.33558925209635504]