{"text_format":"2","workbook":"xlsx","n_sheets":7,"sheets":["з","к","м","1","4","5","6"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[[21,0,21,1]]}
["Решить систему линейных уравнений методом Жордана-Гаусса: "]
[]
[1,2,3,2]
[2,3,4,3]
[3,4,6,5]
[]
["1)"]
[{"$f":"A3","v":1},{"$f":"B3","v":2},3,2]
[{"$f":"A3*-$A$4+A4","v":0},{"$f":"B3*-$A$4+B4","v":-1},-2,-1]
[{"$f":"A3*-$A$5+A5","v":0},{"$f":"B3*-$A$5+B5","v":-2},-3,-1]
[]
["2)"]
[{"$f":"A14*-$B$8+A8","v":1},{"$f":"B14*-$B$8+B8","v":0},-1,0]
[{"$f":"A9/$B$9","v":0},{"$f":"B9/$B$9","v":1},2,1]
[{"$f":"A14*-$B$10+A10","v":0},{"$f":"B14*-$B$10+B10","v":0},1,1]
[]
["3)"]
[{"$f":"A15*-$C$13+A13","v":1},{"$f":"B15*-$C$13+B13","v":0},0,1]
[{"$f":"A15*-$C$14+A14","v":0},{"$f":"B15*-$C$14+B14","v":1},0,-1]
[0,0,1,1]
[]
["Ответ:"]
["x1 =",{"$f":"D18","v":1}]
["x2 =",{"$f":"D19","v":-1}]
["x3 =",{"$f":"D20","v":1}]

{"sheet":"к","index":1,"n_rows":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":false,"merged":[[31,0,31,1]]}
["Решить систему линейных уравнений методом Жордана-Гаусса: "]
[]
[2,0,1,1,4]
[2,2,1,0,2]
[0,1,1,2,-4]
[0,1,2,1,0]
[]
["1)"]
[{"$f":"A3/$A$3","v":1},{"$f":"B3/$A$3","v":0},{"$f":"C3/$A$3","v":0.5},0.5,2]
[{"$f":"A9*-$A$4+A4","v":0},{"$f":"B9*-$A$4+B4","v":2},0,-1,-2]
[{"$f":"A$9*-$A5+A5","v":0},1,1,2,-4]
[{"$f":"A$9*-$A6+A6","v":0},1,2,1,0]
[]
["2)"]
[{"$f":"A$16*-$B9+A9","v":1},{"$f":"B$16*-$B9+B9","v":0},0.5,0.5,2]
[{"$f":"A10/$B$10","v":0},{"$f":"B10/$B$10","v":1},0,-0.5,-1]
[{"$f":"A$16*-$B11+A11","v":0},{"$f":"B$16*-$B11+B11","v":0},1,2.5,-3]
[{"$f":"A$16*-$B12+A12","v":0},0,2,1.5,1]
[]
["3)"]
[{"$f":"A$23*-$C15+A15","v":1},{"$f":"B$23*-$C15+B15","v":0},0,-0.75,3.5]
[{"$f":"A16","v":0},{"$f":"B16","v":1},0,-0.5,-1]
[{"$f":"A$16*-$B17+A17","v":0},{"$f":"B$16*-$B17+B17","v":0},1,2.5,-3]
[{"$f":"A$23*-$C18+A18","v":0},{"$f":"B$23*-$C18+B18","v":0},0,-3.5,7]
[]
["4)"]
[{"$f":"A$30*-$D21+A21","v":1},{"$f":"B$30*-$D21+B21","v":0},0,0,2]
[{"$f":"A$30*-$D22+A22","v":0},1,0,0,-2]
[{"$f":"A$30*-$D23+A23","v":0},{"$f":"B$30*-$D23+B23","v":0},1,0,2]
[{"$f":"A24/$D$24","v":0},{"$f":"B24/$D$24","v":0},0,1,-2]
[]
["Ответ:"]
["x1 =",{"$f":"E27","v":2}]
["x2 =",{"$f":"E28","v":-2}]
["x3 =",{"$f":"E29","v":2}]
["x4 =",-2]

{"sheet":"м","index":2,"n_rows":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":false,"merged":[[31,0,31,1]]}
["Решить систему линейных уравнений методом Жордана-Гаусса: "]
[]
[1,2,1,0,4]
[2,-1,-1,2,2]
[-2,0,1,0,-1]
[0,1,-1,-2,-2]
[]
["1)"]
[{"$f":"A3","v":1},{"$f":"B3","v":2},1,0,4]
[{"$f":"A$9*-$A4+A4","v":0},{"$f":"B$9*-$A4+B4","v":-5},-3,2,-6]
[{"$f":"A$9*-$A5+A5","v":0},4,3,0,7]
[{"$f":"A$9*-$A6+A6","v":0},1,-1,-2,-2]
[]
["2)"]
[{"$f":"A$16*-$B9+A9","v":1},{"$f":"B$16*-$B9+B9","v":0},-0.19999999999999996,0.8,1.6]
[{"$f":"A10/$B$10","v":0},{"$f":"B10/$B$10","v":1},0.6,-0.4,1.2]
[{"$f":"A$16*-$B11+A11","v":0},{"$f":"B$16*-$B11+B11","v":0},0.60000000000000009,1.6,2.2000000000000002]
[{"$f":"A$16*-$B12+A12","v":0},0,-1.6,-1.6,-3.2]
[]
["3)"]
[{"$f":"A$23*-$C15+A15","v":1},{"$f":"B$23*-$C15+B15","v":0},0,1.3333333333333333,2.333333333333333]
[{"$f":"A$23*-$C16+A16","v":0},1,0,-2,-0.99999999999999978]
[{"$f":"A17/$C$17","v":0},{"$f":"B17/$C$17","v":0},1,2.6666666666666665,3.6666666666666665]
[{"$f":"A$23*-$C18+A18","v":0},{"$f":"B$23*-$C18+B18","v":0},0,2.6666666666666665,2.666666666666667]
[]
["4)"]
[{"$f":"A$30*-$D21+A21","v":1},{"$f":"B$30*-$D21+B21","v":0},0,0,0.99999999999999956]
[{"$f":"A$30*-$D22+A22","v":0},1,0,0,1.0000000000000007]
[{"$f":"A$30*-$D23+A23","v":0},0,1,0,0.99999999999999956]
[{"$f":"A24/$D$24","v":0},{"$f":"B24/$D$24","v":0},0,1,1.0000000000000002]
[]
["Ответ:"]
["x1 =",{"$f":"E27","v":0.99999999999999956}]
["x2 =",{"$f":"E28","v":1.0000000000000007}]
["x3 =",{"$f":"E29","v":0.99999999999999956}]
["x4 =",1.0000000000000002]

{"sheet":"1","index":3,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[[21,0,21,1]]}
["Решить систему линейных уравнений методом Жордана-Гаусса: "]
[]
[-2,3,1,-4]
[3,6,2,6]
[1,2,1,3]
[]
["1)"]
[{"$f":"A3/$A$3","v":1},{"$f":"B3/$A$3","v":-1.5},-0.5,2]
[{"$f":"A$8*-$A4+A4","v":0},{"$f":"B$8*-$A4+B4","v":10.5},3.5,0]
[{"$f":"A$8*-$A5+A5","v":0},3.5,1.5,1]
[]
["2)"]
[{"$f":"A$14*-$B8+A8","v":1},{"$f":"B$14*-$B8+B8","v":0},0,2]
[{"$f":"A9/$B$9","v":0},{"$f":"B9/$B$9","v":1},0.33333333333333331,0]
[{"$f":"A$14*-$B10+A10","v":0},{"$f":"B$14*-$B10+B10","v":0},0.33333333333333348,1]
[]
["3)"]
[{"$f":"A$20*-$C13+A13","v":1},{"$f":"B$20*-$C13+B13","v":0},0,2]
[{"$f":"A$20*-$C14+A14","v":0},{"$f":"B$20*-$C14+B14","v":1},0,-0.99999999999999956]
[{"$f":"A15/$C$15","v":0},{"$f":"B15/$C$15","v":0},1,2.9999999999999987]
[]
["Ответ:"]
["x1 =",{"$f":"D18","v":2}]
["x2 =",{"$f":"D19","v":-0.99999999999999956}]
["x3 =",2.9999999999999987]

{"sheet":"4","index":4,"n_rows":47,"n_cols":5,"rows_kept":47,"cut":false,"hidden":false,"merged":[[42,0,42,1]]}
["Решить систему линейных уравнений методом Жордана-Гаусса: "]
[]
[3,1,2,5,-6]
[3,1,2,0,-10]
[6,4,11,11,-27]
[-3,-2,-2,-10,1]
[]
["1)"]
[{"$f":"A3/$A$3","v":1},{"$f":"B3/$A$3","v":0.33333333333333331},0.66666666666666663,1.6666666666666667,-2]
[{"$f":"A$9*-$A4+A4","v":0},{"$f":"B$9*-$A4+B4","v":0},0,-5,-4]
[{"$f":"A$9*-$A5+A5","v":0},2,7,1,-15]
[{"$f":"A$9*-$A6+A6","v":0},-1,0,-5,-5]
["x1","x2","x3","x4"]
[]
["2)"]
[{"$f":"A9","v":1},{"$f":"D9","v":1.6666666666666667},{"$f":"C9","v":0.66666666666666663},{"$f":"B9","v":0.33333333333333331},{"$f":"E9","v":-2}]
[{"$f":"A10","v":0},{"$f":"D10","v":-5},{"$f":"C10","v":0},{"$f":"B10","v":0},{"$f":"E10","v":-4}]
[0,1,{"$f":"C11","v":7},{"$f":"B11","v":2},-15]
[0,-5,{"$f":"C12","v":0},{"$f":"B12","v":-1},-5]
["x1","x4",{"$f":"C13","v":"x3"},{"$f":"B13","v":"x2"}]
[]
["3)"]
[{"$f":"A$24*-$B16+A16","v":1},{"$f":"B$24*-$B16+B16","v":0},0.66666666666666663,0.33333333333333331,-3.3333333333333335]
[{"$f":"A17/$B$17","v":0},{"$f":"B17/$B$17","v":1},0,0,0.8]
[{"$f":"A$24*-$B18+A18","v":0},{"$f":"B$24*-$B18+B18","v":0},7,2,-15.8]
[{"$f":"A$24*-$B19+A19","v":0},0,0,-1,-1]
[{"$f":"A20","v":"x1"},{"$f":"D20","v":"x2"},{"$f":"C20","v":"x3"},{"$f":"B20","v":"x4"}]
[]
["4)"]
[{"$f":"A$32*-$C23+A23","v":1},{"$f":"B$32*-$C23+B23","v":0},0,0.14285714285714285,-1.8285714285714287]
[{"$f":"A$32*-$C24+A24","v":0},1,0,0,0.8]
[{"$f":"A25/$C$25","v":0},{"$f":"B25/$C$25","v":0},1,0.2857142857142857,-2.2571428571428571]
[{"$f":"A$32*-$C26+A26","v":0},{"$f":"B$32*-$C26+B26","v":0},0,-1,-1]
[{"$f":"A27","v":"x1"},{"$f":"D27","v":"x4"},{"$f":"C27","v":"x3"},{"$f":"B27","v":"x2"}]
[]
["5)"]
[{"$f":"A$40*-$D30+A30","v":1},{"$f":"B$40*-$D30+B30","v":0},0,0,-1.9714285714285715]
[{"$f":"A$40*-$D31+A31","v":0},1,0,0,0.8]
[{"$f":"A$40*-$D32+A32","v":0},0,1,0,-2.5428571428571427]
[{"$f":"A33/$D$33","v":0},{"$f":"B33/$D$33","v":0},0,1,1]
[{"$f":"A34","v":"x1"},"x4","x3","x2"]
[]
["Ответ:"]
["x1 =",{"$f":"E37","v":-1.9714285714285715}]
["x2 =",{"$f":"E40","v":1}]
["x3 =",{"$f":"E39","v":-2.5428571428571427}]
["x4 =",{"$f":"E38","v":0.8}]

{"sheet":"5","index":5,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[16,0,16,2],[19,1,19,2],[20,1,20,2],[21,1,21,2]]}
["Решить систему линейных уравнений методом Жордана-Гаусса: "]
[]
[1,3,-1,0,-2,1]
[2,7,-4,-3,0,3]
[1,4,-3,-3,2,2]
[]
["1)"]
[{"$f":"A3","v":1},{"$f":"B3","v":3},-1,0,-2,1]
[{"$f":"A$8*-$A4+A4","v":0},{"$f":"B$8*-$A4+B4","v":1},-2,-3,4,1]
[{"$f":"A$8*-$A5+A5","v":0},1,-2,-3,4,1]
[]
["2)"]
[{"$f":"A$14*-$B8+A8","v":1},{"$f":"B$14*-$B8+B8","v":0},5,9,-14,-2]
[{"$f":"A9","v":0},{"$f":"B9","v":1},-2,-3,4,1]
[{"$f":"A$14*-$B10+A10","v":0},{"$f":"B$14*-$B10+B10","v":0},0,0,0,0]
[]
["Ответ"]
["x1 = ","(-2) - 5с1 - 9с2 + 14с3"]
["x2 = ","1 + 2с1 + 3с2 - 4с3"]
["x3 =","c1"]
["x4 =","c2"]
["x5 =","c3"]

{"sheet":"6","index":6,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[16,0,16,2],[19,1,19,2],[20,1,20,2],[21,1,21,2]]}
["Решить систему линейных уравнений методом Жордана-Гаусса: "]
[]
[1,-5,3,4,0,4]
[2,-9,2,0,1,7]
[1,-4,-1,-4,1,3]
[]
["1)"]
[{"$f":"A3/$A$3","v":1},-5,3,4,0,4]
[{"$f":"A$8*-$A4+A4","v":0},1,-4,-8,1,-1]
[0,1,-4,-8,1,-1]
[]
["2)"]
[{"$f":"A$14*-$B8+A8","v":1},0,-17,-36,5,-1]
[{"$f":"A9","v":0},{"$f":"B9","v":1},-4,-8,1,-1]
[{"$f":"A$14*-$B10+A10","v":0},{"$f":"B$14*-$B10+B10","v":0},0,0,0,0]
[]
["Ответ"]
["x1 = ","(-1) + 17с1 + 36с2 - 5с3"]
["x2 = ","(-1) + 4с1 +8с2 - с3"]
["x3 =","с1"]
["x4 =","с2"]
["x5 =","с3"]