{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["3x3 System","5x5 System","10x10 System"],"not_rendered":{"charts":0,"images":23,"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":"3x3 System","index":0,"n_rows":29,"n_cols":51,"rows_kept":29,"cut":false,"hidden":false,"merged":[[6,44,6,46],[6,47,6,50],[14,1,14,8],[23,1,23,8],[17,19,17,21],[7,26,7,28],[7,35,7,37],[7,44,7,46],[6,26,6,28],[6,29,6,32],[6,35,6,37],[6,38,6,41],[1,27,1,29],[4,1,4,10],[8,8,10,8],[17,4,17,6],[17,9,17,11],[17,14,17,16]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"source","http://www.numerical-methods.com/Excel_VBA/LU.xlsm",null,null,null,null,null,null,null,null,null,null,null,null,"www.numerical-methods.com"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"guide","http://www.numerical-methods.com/lineq/LU factorisation and forward and back substitution_Excel.htm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"User group","Spreadsheets in Science and Engineering"]
[null,"Finding the solution of a 3x3 matrix-vector equation by LU factorisation"]
[]
[null,null,null,null,"Test Data 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Default Test Data 1",null,null,"Pivotting not necessary",null,null,null,null,null,"Test Data 2",null,null,"Pivotting required",null,null,null,null,null,"Test Data 3",null,null,"Singular matrix"]
[null,null,null,null,"A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A",null,null,null,"b",null,"x",null,null,"A",null,null,null,"b",null,"x",null,null,"A",null,null,null,"b",null,"x"]
["Matrix (A) and vector (b) - ",null,null,null,1,2,2,null,"x",null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,2,null,5,null,-1,null,null,0,4,-3,null,8,null,-1,null,null,0,4,-3,null,8,null,"*"]
["place in yellow area",null,null,null,1,0,1,null,null,null,"=",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0,1,null,1,null,1,null,null,1,2,-1,null,3,null,2,null,null,1,2,-1,null,3,null,"*"]
[null,null,null,null,1,2,1,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,1,null,3,null,2,null,null,-2,0,1,null,2,null,0,null,null,1,6,-4,null,12,null,"*"]
[]
[]
[]
[null,"LU factorisation"]
[]
[]
[null,null,"P index",null,"L",null,null,null,null,"U",null,null,null,null,"LU",null,null,null,null,"P^TLU"]
[null,null,1,null,1,0,0,null,null,1,2,2,null,null,{"$f":"MMULT(E19:G21,J19:L21)","v":1},2,2,null,null,1,2,2]
[null,null,2,null,1,1,0,null,null,0,-2,-1,null,null,1,0,1,null,null,1,0,1]
[null,null,3,null,1,0,1,null,null,0,0,-1,null,null,1,2,1,null,null,1,2,1]
[]
[]
[null,"Forward and Backward Substitution"]
[]
[]
[null,null,-1]
[null,null,1]
[null,null,2]

{"sheet":"5x5 System","index":1,"n_rows":33,"n_cols":52,"rows_kept":33,"cut":false,"hidden":false,"merged":[[24,2,24,9],[16,20,16,24],[4,4,4,8],[16,27,16,31],[2,1,2,12],[5,10,9,10],[13,2,13,4],[16,6,16,10],[16,13,16,17],[5,12,9,12],[3,22,3,28],[4,22,4,26]]}
[]
[]
[null,"Finding the solution of a 5x5 matrix-vector equation by LU factorisation",null,null,null,null,null,null,null,null,null,null,null,null,null,"www.numerical-methods.com"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Default Test Data"]
[null,null,null,null,"A",null,null,null,null,null,null,null,null,"b",null,null,null,null,null,null,null,null,"A",null,null,null,null,null,"b",null,"x"]
["Matrix (A) and vector (b) - ",null,null,null,1,-1,0,2,1,null,"x",null,"=",-3,null,null,null,null,null,null,null,null,1,-1,0,2,1,null,-3,null,-1]
["place in yellow area",null,null,null,3,0,3,-1,2,null,null,null,null,-8,null,null,null,null,null,null,null,null,3,0,3,-1,2,null,-8,null,2]
[null,null,null,null,-2,2,-1,0,3,"X",null,null,null,0,null,null,null,null,null,null,null,null,-2,2,-1,0,3,null,0,null,0]
[null,null,null,null,1,-1,0,3,0,null,null,null,null,0,null,null,null,null,null,null,null,null,1,-1,0,3,0,null,0,null,1]
[null,null,null,null,2,0,2,-1,1,null,null,null,null,-5,null,null,null,null,null,null,null,null,2,0,2,-1,1,null,-5,null,-2]
[]
[]
[]
[null,null,"LU factorisation"]
[]
[]
[null,null,"P index",null,null,null,"L",null,null,null,null,null,null,"U",null,null,null,null,null,null,"LU",null,null,null,null,null,null,"P^TLU"]
[null,null,2,null,null,null,1,0,0,0,0,null,null,3,0,3,-1,2,null,null,{"$f":"MMULT(G18:K22,N18:R22)","v":3},0,3,-1,2,null,null,1,-1,0,2,1]
[null,null,3,null,null,null,-0.66666666666666663,1,0,0,0,null,null,0,2,1,-0.66666666666666663,4.333333333333333,null,null,-2,2,-1,0,3,null,null,3,0,3,-1,2]
[null,null,1,null,null,null,0.33333333333333331,-0.5,1,0,0,null,null,0,0,-0.5,2,2.5,null,null,1,-1,0,2,1,null,null,-2,2,-1,0,3]
[null,null,4,null,null,null,0.33333333333333331,-0.5,1,1,0,null,null,0,0,0,1,-1,null,null,1,-1,0,3,0,null,null,1,-1,0,3,0]
[null,null,5,null,null,null,0.66666666666666663,0,0,-0.33333333333333337,1,null,null,0,0,0,0,-0.66666666666666652,null,null,2,0,2,-1,1,null,null,2,0,2,-1,1]
[]
[]
[null,null,"Forward and Backward Substitution"]
[]
[]
[null,null,-1]
[null,null,2]
[null,null,0]
[null,null,1]
[null,null,-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"10x10 System","index":2,"n_rows":47,"n_cols":52,"rows_kept":47,"cut":false,"hidden":false,"merged":[[34,2,34,9],[21,30,21,39],[21,42,21,51],[2,1,2,17],[18,2,18,4],[21,6,21,15],[21,18,21,22],[5,15,14,15],[5,17,14,17],[4,25,4,34],[3,25,3,38]]}
[]
[]
[null,"Finding the solution of a 10x10 matrix-vector equation by LU factorisation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"www.numerical-methods.com"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Default test data"]
[null,null,null,null,"A",null,null,null,null,null,null,null,null,null,null,null,"x",null,"b",null,null,null,null,null,null,"A",null,null,null,null,null,null,null,null,null,null,"b",null,"x"]
["Matrix (A) and vector (b) - ",null,null,null,0,-2,1,1,-2,1,2,3,1,-4,null,"x",null,"=",12,null,null,null,null,null,null,0,-2,1,1,-2,1,2,3,1,-4,null,12,null,-4]
["place in yellow area",null,null,null,4,-1,3,-3,0,-4,0,4,4,1,null,null,null,null,-39,null,null,null,null,null,null,4,-1,3,-3,0,-4,0,4,4,1,null,-39,null,4]
[null,null,null,null,2,2,4,3,-4,-3,0,3,4,1,null,null,null,null,-15,null,null,null,null,null,null,2,2,4,3,-4,-3,0,3,4,1,null,-15,null,-1]
[null,null,null,null,-3,-2,4,-2,1,-2,0,3,-3,1,null,null,null,null,-21,null,null,null,null,null,null,-3,-2,4,-2,1,-2,0,3,-3,1,null,-21,null,0]
[null,null,null,null,3,1,1,-3,4,0,3,-4,-4,2,"X",null,null,null,-18,null,null,null,null,null,null,3,1,1,-3,4,0,3,-4,-4,2,null,-18,null,0]
[null,null,null,null,-2,-3,-4,2,-3,-2,3,-3,3,4,null,null,null,null,-12,null,null,null,null,null,null,-2,-3,-4,2,-3,-2,3,-3,3,4,null,-12,null,4]
[null,null,null,null,4,1,-2,-1,-4,-1,4,0,3,2,null,null,null,null,-12,null,null,null,null,null,null,4,1,-2,-1,-4,-1,4,0,3,2,null,-12,null,1]
[null,null,null,null,-1,-2,-2,-2,-2,-2,-2,1,-2,1,null,null,null,null,-21,null,null,null,null,null,null,-1,-2,-2,-2,-2,-2,-2,1,-2,1,null,-21,null,-1]
[null,null,null,null,-3,-3,3,0,4,4,2,1,-1,-2,null,null,null,null,20,null,null,null,null,null,null,-3,-3,3,0,4,4,2,1,-1,-2,null,20,null,2]
[null,null,null,null,3,-1,1,-3,3,1,-1,-2,4,0,null,null,null,null,-4,null,null,null,null,null,null,3,-1,1,-3,3,1,-1,-2,4,0,null,-4,null,-4]
[]
[]
[]
[null,null,"LU factorisation"]
[]
[]
[null,null,"P index",null,null,null,"L",null,null,null,null,null,null,null,null,null,null,null,"U",null,null,null,null,null,null,null,null,null,null,null,"LU",null,null,null,null,null,null,null,null,null,null,null,"P^TLU"]
[null,null,2,null,null,null,1,0,0,0,0,0,0,0,0,0,null,null,4,-1,3,-3,0,-4,0,4,4,1,null,null,{"$f":"MMULT(G23:P32,S23:AB32)","v":4},-1,3,-3,0,-4,0,4,4,1,null,null,0,-2,1,0.99999999999999967,-2,1,2,3,1,-4]
[null,null,9,null,null,null,-0.75,1,0,0,0,0,0,0,0,0,null,null,0,-3.75,5.25,-2.25,4,1,2,4,2,-1.25,null,null,-3,-3,3,0,4,4,2,1,-1,-2,null,null,4,-1,3,-3,0,-4,0,4,4,1]
[null,null,6,null,null,null,-0.5,0.93333333333333335,1,0,0,0,0,0,0,0,null,null,0,0,-7.4,2.6,-6.7333333333333334,-4.9333333333333336,1.1333333333333333,-4.7333333333333334,3.1333333333333333,5.666666666666667,null,null,-2,-3,-4,2,-3,-2,3,-3,3,4,null,null,2,2,4,3,-3.9999999999999996,-3.0000000000000004,0,3,4,1]
[null,null,3,null,null,null,0.5,-0.66666666666666663,-0.81081081081081074,1,0,0,0,0,0,0,null,null,0,0,0,5.1081081081081079,-6.7927927927927918,-4.3333333333333339,2.2522522522522523,-0.1711711711711712,5.8738738738738734,4.2612612612612617,null,null,2,2,4,3,-3.9999999999999996,-3.0000000000000004,0,3,4,1,null,null,-3,-2,4,-2,1,-1.9999999999999991,0,3,-3,1]
[null,null,4,null,null,null,-0.75,0.73333333333333328,-0.32432432432432434,-0.34391534391534395,1,0,0,0,0,0,null,null,0,0,0,0,-6.4532627865961203,-8.8236331569664905,-0.32451499118165761,1.4726631393298062,1.5696649029982366,5.9700176366843039,null,null,-3,-2,4,-2,1,-1.9999999999999991,0,3,-3,1,null,null,3,1,1,-3,4,0,3,-4,-4,2]
[null,null,7,null,null,null,1,-0.53333333333333333,0.29729729729729731,5.2910052910052803E-3,-2.6509975403115525E-2,1,0,0,0,0,null,null,0,0,0,0,0,4.7890133916370594,4.7092101667122162,-0.41951352828641714,-0.85433178464061266,-1.2156326865263734,null,null,4,1,-2,-1,-4,-1,3.9999999999999996,0,3,2,null,null,-2,-3,-4,2,-3,-2,3,-3,3,4]
[null,null,5,null,null,null,0.75,-0.46666666666666667,-0.16216216216216217,-0.26984126984126988,-0.4558622574473899,-0.52724990013125583,1,0,0,0,null,null,0,0,0,0,0,0,7.0598641785082457,-5.4969468698282258,-3.7084403355589792,4.8160132397420536,null,null,3,1,1,-3,4,0,3,-4,-4,2,null,null,4,1,-2,-1,-4,-1,3.9999999999999996,0,3,2]
[null,null,10,null,null,null,0.75,6.6666666666666666E-2,0.21621621621621623,-0.22751322751322756,-0.40967477452855966,8.3376134223591872E-2,-0.19710613531646595,1,0,0,null,null,0,0,0,0,0,0,0,-4.7273785466009208,1.5088998464150034,2.5739875515318085,null,null,3,-1,1,-3,3,1,-1,-2,4,0,null,null,-1,-2,-2.0000000000000004,-2,-1.9999999999999996,-2.0000000000000004,-1.9999999999999996,1,-2,1]
[null,null,8,null,null,null,-0.25,0.6,0.59459459459459463,-0.57671957671957685,0.66848865810330682,0.57062146892655319,-0.71463099183574452,0.49872611247144405,1,0,null,null,0,0,0,0,0,0,0,0,-4.6399822852687276,-5.1082034937006471E-2,null,null,-1,-2,-2.0000000000000004,-2,-1.9999999999999996,-2.0000000000000004,-1.9999999999999996,1,-2,1,null,null,-3,-3,3,0,4,4,2,1,-1,-2]
[null,null,1,null,null,null,0,0.53333333333333333,0.2432432432432432,0.30687830687830686,6.367860071057678E-2,0.74302345488786192,-0.49744563899442257,9.4334363842797364E-2,0.88009977988430799,1,null,null,0,0,0,0,0,0,0,0,0,-3.2984725304976137,null,null,0,-2,1,0.99999999999999967,-2,1,2,3,1,-4,null,null,3,-1,1,-3,3,1,-1,-2,4,0]
[]
[]
[null,null,"Forward and Backward Substitution"]
[]
[null,null,"x"]
[null,null,-3.999999999999996]
[null,null,3.9999999999999978]
[null,null,-0.99999999999999878]
[null,null,6.9550479426253199E-16]
[null,null,-2.7526491608088057E-15]
[null,null,4.0000000000000027]
[null,null,0.99999999999999878]
[null,null,-0.99999999999999967]
[null,null,1.9999999999999984]
[null,null,-3.9999999999999982]