{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лагранж","Ньютон","Канонический"],"not_rendered":{"charts":3,"images":1,"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":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["i","x","y","P0(x)","P1(x)","P2(x)","P3(x)","P4(x)","P5(x)","L6(x)",null,"L6(x) VBA"]
[0,2,-10,{"$f":"(B2-$B$3)*(B2-$B$4)*(B2-$B$5)*(B2-$B$6)*(B2-$B$7)/(($B$2-$B$3)*($B$2-$B$4)*($B$2-$B$5)*($B$2-$B$6)*($B$2-$B$7))","v":1},{"$f":"(B2-$B$2)*(B2-$B$4)*(B2-$B$5)*(B2-$B$6)*(B2-$B$7)/(($B$3-$B$2)*($B$3-$B$4)*($B$3-$B$5)*($B$3-$B$6)*($B$3-$B$7))","v":0},{"$f":"(B2-$B$2)*(B2-$B$3)*(B2-$B$5)*(B2-$B$6)*(B2-$B$7)/(($B$4-$B$2)*($B$4-$B$3)*($B$4-$B$5)*($B$4-$B$6)*($B$4-$B$7))","v":0},{"$f":"(B2-$B$2)*(B2-$B$3)*(B2-$B$4)*(B2-$B$6)*(B2-$B$7)/(($B$5-$B$2)*($B$5-$B$3)*($B$5-$B$4)*($B$5-$B$6)*($B$5-$B$7))","v":0},{"$f":"(B2-$B$2)*(B2-$B$3)*(B2-$B$4)*(B2-$B$5)*(B2-$B$7)/(($B$6-$B$2)*($B$6-$B$3)*($B$6-$B$4)*($B$6-$B$5)*($B$6-$B$7))","v":0},{"$f":"(B2-$B$2)*(B2-$B$3)*(B2-$B$4)*(B2-$B$5)*(B2-$B$6)/(($B$7-$B$2)*($B$7-$B$3)*($B$7-$B$4)*($B$7-$B$5)*($B$7-$B$6))","v":0},{"$f":"$C$2*D2+$C$3*E2+$C$4*F2+$C$5*G2+$C$6*H2+$C$7*I2","v":-10},null,{"$f":"Lagrange($B$2:$B$7,$C$2:$C$7,B2)","v":-10}]
[1,3,-5,{"$f":"(B3-$B$3)*(B3-$B$4)*(B3-$B$5)*(B3-$B$6)*(B3-$B$7)/(($B$2-$B$3)*($B$2-$B$4)*($B$2-$B$5)*($B$2-$B$6)*($B$2-$B$7))","v":0},{"$f":"(B3-$B$2)*(B3-$B$4)*(B3-$B$5)*(B3-$B$6)*(B3-$B$7)/(($B$3-$B$2)*($B$3-$B$4)*($B$3-$B$5)*($B$3-$B$6)*($B$3-$B$7))","v":1},{"$f":"(B3-$B$2)*(B3-$B$3)*(B3-$B$5)*(B3-$B$6)*(B3-$B$7)/(($B$4-$B$2)*($B$4-$B$3)*($B$4-$B$5)*($B$4-$B$6)*($B$4-$B$7))","v":0},{"$f":"(B3-$B$2)*(B3-$B$3)*(B3-$B$4)*(B3-$B$6)*(B3-$B$7)/(($B$5-$B$2)*($B$5-$B$3)*($B$5-$B$4)*($B$5-$B$6)*($B$5-$B$7))","v":0},{"$f":"(B3-$B$2)*(B3-$B$3)*(B3-$B$4)*(B3-$B$5)*(B3-$B$7)/(($B$6-$B$2)*($B$6-$B$3)*($B$6-$B$4)*($B$6-$B$5)*($B$6-$B$7))","v":0},{"$f":"(B3-$B$2)*(B3-$B$3)*(B3-$B$4)*(B3-$B$5)*(B3-$B$6)/(($B$7-$B$2)*($B$7-$B$3)*($B$7-$B$4)*($B$7-$B$5)*($B$7-$B$6))","v":0},{"$f":"$C$2*D3+$C$3*E3+$C$4*F3+$C$5*G3+$C$6*H3+$C$7*I3","v":-5},null,-5]
[2,4,-2,0,0,1,0,0,0,-2,null,-2]
[3,5,0,0,0,0,1,0,0,0,null,0]
[4,6,-6,0,0,0,0,1,0,-6,null,-6]
[5,7,-5,0,0,0,0,0,1,-5,null,-5]
[]
[null,"x"]
[null,4,null,{"$f":"(B10-$B$3)*(B10-$B$4)*(B10-$B$5)*(B10-$B$6)*(B10-$B$7)/(($B$2-$B$3)*($B$2-$B$4)*($B$2-$B$5)*($B$2-$B$6)*($B$2-$B$7))","v":0},{"$f":"(B10-$B$2)*(B10-$B$4)*(B10-$B$5)*(B10-$B$6)*(B10-$B$7)/(($B$3-$B$2)*($B$3-$B$4)*($B$3-$B$5)*($B$3-$B$6)*($B$3-$B$7))","v":0},{"$f":"(B10-$B$2)*(B10-$B$3)*(B10-$B$5)*(B10-$B$6)*(B10-$B$7)/(($B$4-$B$2)*($B$4-$B$3)*($B$4-$B$5)*($B$4-$B$6)*($B$4-$B$7))","v":1},{"$f":"(B10-$B$2)*(B10-$B$3)*(B10-$B$4)*(B10-$B$6)*(B10-$B$7)/(($B$5-$B$2)*($B$5-$B$3)*($B$5-$B$4)*($B$5-$B$6)*($B$5-$B$7))","v":0},{"$f":"(B10-$B$2)*(B10-$B$3)*(B10-$B$4)*(B10-$B$5)*(B10-$B$7)/(($B$6-$B$2)*($B$6-$B$3)*($B$6-$B$4)*($B$6-$B$5)*($B$6-$B$7))","v":0},{"$f":"(B10-$B$2)*(B10-$B$3)*(B10-$B$4)*(B10-$B$5)*(B10-$B$6)/(($B$7-$B$2)*($B$7-$B$3)*($B$7-$B$4)*($B$7-$B$5)*($B$7-$B$6))","v":0},{"$f":"$C$2*D10+$C$3*E10+$C$4*F10+$C$5*G10+$C$6*H10+$C$7*I10","v":-2}]
[null,4.0999999999999996,null,4.5457499999999856E-3,-4.3391249999999874E-2,0.95460750000000028,0.10606749999999959,-2.5121249999999911E-2,3.2917499999999883E-3,-1.6034475000000015]
[null,4.2,null,8.0640000000000052E-3,-7.3920000000000041E-2,0.88703999999999983,0.22176000000000021,-4.9280000000000046E-2,6.3360000000000057E-3,-1.2211199999999993]
[null,4.3,null,1.0442249999999998E-2,-9.2373749999999977E-2,0.80057250000000024,0.34310249999999981,-7.0638749999999972E-2,8.8952499999999969E-3,-0.86434250000000068]
[null,4.4000000000000004,null,1.1648000000000002E-2,-9.9840000000000026E-2,0.69887999999999961,0.46592000000000039,-8.7360000000000035E-2,1.0752000000000005E-2,-0.5446399999999989]
[null,4.5,null,1.171875E-2,-9.765625E-2,0.5859375,0.5859375,-9.765625E-2,1.171875E-2,-0.2734375]
[null,4.5999999999999996,null,1.0752000000000006E-2,-8.7360000000000049E-2,0.4659200000000005,0.6988799999999995,-9.9839999999999998E-2,1.1648E-2,-6.1760000000000856E-2]
[null,4.7,null,8.8952499999999969E-3,-7.0638749999999959E-2,0.34310249999999981,0.80057250000000024,-9.2373749999999977E-2,1.0442249999999997E-2,8.0067500000000125E-2]
[null,4.8,null,6.3360000000000048E-3,-4.9280000000000046E-2,0.22176000000000018,0.88703999999999972,-7.3920000000000041E-2,8.0640000000000052E-3,0.14272000000000007]
[null,4.9000000000000004,null,3.2917499999999891E-3,-2.5121249999999911E-2,0.10606749999999959,0.95460750000000028,-4.339124999999986E-2,4.5457499999999856E-3,0.11817249999999971]
[null,5,null,0,0,0,1,0,0,0]

{"sheet":"Ньютон","index":1,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["i","x","y","/\\y","/\\2y","/\\3y","/\\4y","/\\5y",null,"N6(x)",null,"A"]
[0,2,-10,{"$f":"C3-C2","v":5},{"$f":"D3-D2","v":-2},1,-8,{"$f":"G3-G2","v":30},null,{"$f":"$M$2+$M$3*(B2-$B$2)+$M$4*(B2-$B$2)*(B2-$B$3)+$M$5*(B2-$B$2)*(B2-$B$3)*(B2-$B$4)+$M$6*(B2-$B$2)*(B2-$B$3)*(B2-$B$4)*(B2-$B$5)+$M$7*(B2-$B$2)*(B2-$B$3)*(B2-$B$4)*(B2-$B$5)*(B2-$B$6)","v":-10},null,0,{"$f":"C2","v":-10}]
[1,3,-5,{"$f":"C4-C3","v":3},-1,-7,22,null,null,-5,null,1,{"$f":"D2/FACT(L3)/$M$9","v":5}]
[2,4,-2,2,-8,15,null,null,null,-2,null,2,{"$f":"E2/FACT(L4)/$M$9","v":-1}]
[3,5,0,-6,7,null,null,null,null,0,null,3,{"$f":"F2/FACT(L5)/$M$9","v":0.16666666666666666}]
[4,6,-6,1,null,null,null,null,null,-6,null,4,{"$f":"G2/FACT(L6)/$M$9","v":-0.33333333333333331}]
[5,7,-5,null,null,null,null,null,null,-5,null,5,{"$f":"H2/FACT(L7)/$M$9","v":0.25}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"h=",1]
[null,"xн","N6(x)"]
[null,4,{"$f":"$M$2+$M$3*(B11-$B$2)+$M$4*(B11-$B$2)*(B11-$B$3)+$M$5*(B11-$B$2)*(B11-$B$3)*(B11-$B$4)+$M$6*(B11-$B$2)*(B11-$B$3)*(B11-$B$4)*(B11-$B$5)+$M$7*(B11-$B$2)*(B11-$B$3)*(B11-$B$4)*(B11-$B$5)*(B11-$B$6)","v":-2}]
[null,4.0999999999999996,{"$f":"$M$2+$M$3*(B12-$B$2)+$M$4*(B12-$B$2)*(B12-$B$3)+$M$5*(B12-$B$2)*(B12-$B$3)*(B12-$B$4)+$M$6*(B12-$B$2)*(B12-$B$3)*(B12-$B$4)*(B12-$B$5)+$M$7*(B12-$B$2)*(B12-$B$3)*(B12-$B$4)*(B12-$B$5)*(B12-$B$6)","v":-1.6034475000000015}]
[null,4.2,-1.2211200000000002]
[null,4.3,-0.86434249999999957]
[null,4.4000000000000004,-0.5446399999999989]
[null,4.5,-0.2734375]
[null,4.5999999999999996,-6.1760000000000537E-2]
[null,4.7,8.0067499999999292E-2]
[null,4.8,0.14272000000000085]
[null,4.9000000000000004,0.11817250000000001]
[null,5,0]

{"sheet":"Канонический","index":2,"n_rows":20,"n_cols":16,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,4,0,9],[0,15,0,19]]}
["i","x","y",null,"Матрица X",null,null,null,null,null,null,"Крамер",null,"P5(x)",null,"Совпадает с y0, следовательно, ошибок нет"]
[0,2,-10,null,{"$f":"B2^5","v":32},{"$f":"B2^4","v":16},{"$f":"B2^3","v":8},{"$f":"B2^2","v":4},{"$f":"B2","v":2},1,null,{"$f":"Kramer(E2:J7,C2:C7)","v":0.24999999999994568},null,{"$f":"ROUND($L$2*B2^5+$L$3*B2^4+$L$4*B2^3+$L$5*B2^2+$L$6*B2+$L$7,10)","v":-10},null,{"$f":"CanonCalc($B$2:$B$7,$C$2:$C$7,B2)","v":-9.9999999999994031}]
[1,3,-5,null,{"$f":"B3^5","v":243},81,27,9,3,1,null,-5.3333333333323729,null,{"$f":"ROUND($L$2*B3^5+$L$3*B3^4+$L$4*B3^3+$L$5*B3^2+$L$6*B3+$L$7,10)","v":-5}]
[2,4,-2,null,1024,256,64,16,4,1,null,43.583333333325207,null,-2]
[3,5,0,null,3125,625,125,25,5,1,null,-171.1666666666319,null,{"$f":"ROUND($L$2*B5^5+$L$3*B5^4+$L$4*B5^3+$L$5*B5^2+$L$6*B5+$L$7,10)","v":0}]
[4,6,-6,null,7776,1296,216,36,6,1,null,326.66666666659677,null,{"$f":"ROUND($L$2*B6^5+$L$3*B6^4+$L$4*B6^3+$L$5*B6^2+$L$6*B6+$L$7,10)","v":-6}]
[5,7,-5,null,16807,2401,343,49,7,1,null,-249.99999999994733,null,-5.0000000001]
[]
[null,"xn"]
[null,4,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND($L$2*B10^5+$L$3*B10^4+$L$4*B10^3+$L$5*B10^2+$L$6*B10+$L$7,10)","v":-2}]
[null,4.0999999999999996,null,null,null,null,null,null,null,null,null,null,null,-1.6034474999999999]
[null,4.2,null,null,null,null,null,null,null,null,null,null,null,-1.22112]
[null,4.3,null,null,null,null,null,null,null,null,null,null,null,-0.86434250000000001]
[null,4.4000000000000004,null,null,null,null,null,null,null,null,null,null,null,-0.54464000000000001]
[null,4.5,null,null,null,null,null,null,null,null,null,null,null,-0.2734375]
[null,4.5999999999999996,null,null,null,null,null,null,null,null,null,null,null,-6.1760000000000002E-2]
[null,4.7,null,null,null,null,null,null,null,null,null,null,null,8.00675E-2]
[null,4.8,null,null,null,null,null,null,null,null,null,null,null,0.14272000000000001]
[null,4.9000000000000004,null,null,null,null,null,null,null,null,null,null,null,0.1181725]
[null,5,null,null,null,null,null,null,null,null,null,null,null,0]