{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Transpose","Matrix","EXOMat","EXOMatCorr"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":3,"defined_names":47,"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":"Transpose","index":0,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["TRANSPOSE"]
[]
[]
[]
[1,18,null,"Naive Solution"]
[2,20,null,{"$f":"B5","v":18},{"$f":"B6","v":20}]
[3,2]
[4,24,null,"Transpose Function"]
[5,26]
[6,28]
[]
[null,null,null,"Cut and Paste"]
[]
[]
[]
[null,null,null,"Copy with right button"]
[]
[]
[null,null,null,"Index Function"]
[null,null,null,1,2,3,4,5,6]
[]
[]
[null,null,null,{"$f":"COLUMN(D23)","v":4},5,6,7,8,9]
[]
[null,null,null,"All in one formula"]

{"sheet":"Matrix","index":1,"n_rows":79,"n_cols":12,"rows_kept":79,"cut":false,"hidden":false,"merged":[]}
["MATRIX CALCULUS"]
[]
[null,null,null,"WHEN THE OUTPUT IS A MATRIX",null,null,null,"SELECT THE OUTPUT AREA"]
[null,null,null,null,null,null,null,"CAPTURE THE FORMULA *(WITH EQUAL SIGN)"]
[null,null,null,null,null,null,null,"ENTER THE FOLLOWING KEYS: shift + maj  and enter"]
[]
[]
["MATRIX ADDITION"]
[]
[null,null,"A",null,"+",null,"B",null,"=",null,"S"]
[]
[null,3,-2,6,null,4,0,4,null,{"$f":"B12+F12","v":7},-2,10]
[null,2,-7,-6,null,-6,1,0,null,-4,-6,-6]
[]
["MATRIX MULTIPLICATION BY A NUMBER"]
[]
[null,null,null,"a","x",null,"A",null,"=",null,"aA"]
[]
[null,null,null,5,null,3,-2,6,null,{"$f":"F19*$D$19","v":15},-10,30]
[null,null,null,null,null,2,-7,-6,null,10,-35,-30]
[]
["MATRIX DETERMINANT"]
[]
[null,null,"A",null,null,null,null,null,null,"DET(A)"]
[]
[null,3,-2,null,null,null,null,null,null,{"$f":"MDETERM(B26:C27)","v":-17}]
[null,2,-7]
[]
["MATRIX TRANSPOSITION"]
[]
[null,null,"A",null,null,null,null,null,null,"TA"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(B34:D35)","v":3},2]
[null,3,-2,6,null,null,null,null,null,-2,-7]
[null,2,-7,-6,null,null,null,null,null,6,-6]
[]
["MATRIX MULTIPLICATION"]
[]
[null,null,"A",null,null,null,"B",null,null,null,"AB"]
[]
[null,null,null,null,null,1,2,3]
[null,1,-2,3,null,-1,-2,-3,null,{"$f":"MMULT(B42:D43,F41:H43)","v":15},21,21]
[null,4,5,-6,null,4,5,4,null,-25,-32,-27]
[]
[]
["MATRIX INVERSION"]
[]
[null,null,"A",null,null,null,null,null,null,"A-1"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+MINVERSE(B51:D53)","v":-2.0761245674740483E-2},-6.9204152249134954E-2,0.16955017301038061]
[null,3,7,6,null,null,null,null,null,9.6885813148788927E-2,-1.038062283737024E-2,-0.1245674740484429]
[null,-8,-7,8,null,null,null,null,null,6.4013840830449822E-2,4.6712802768166091E-2,6.0553633217993084E-2]
[null,3,-2,4]
[]
["SCALAR PRODUCT"]
[]
[null,null,"A",null,null,"B",null,null,null,"AB"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"MMULT(B60:D60,F60:F62)","v":-4}]
[null,3,7,6,null,1]
[null,null,null,null,null,-1]
[null,null,null,null,null,0]
[]
["EXTERNAL PRODUCT"]
[]
[null,null,"B",null,null,"A",null,null,null,"BA"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"MMULT(C69:C71,E69:G69)","v":3},7,6]
[null,null,1,null,3,7,6,null,null,-3,-7,-6]
[null,null,-1,null,null,null,null,null,null,0,0,0]
[null,null,0]
[]
["PRODUCT OF A MATRIX"]
["WITH ITS TRANSPOSE"]
[null,null,"A",null,null,null,"ATA",null,null,null,"TAA"]
[]
[null,3,7,6,null,{"$f":"MMULT(B77:D79,TRANSPOSE(B77:D79))","v":94},-25,19,null,{"$f":"MMULT(TRANSPOSE(B77:D79),B77:D79)","v":82},71,-34]
[null,-8,-7,8,null,-25,177,22,null,71,102,-22]
[null,3,-2,4,null,19,22,29,null,-34,-22,116]

{"sheet":"EXOMat","index":2,"n_rows":65,"n_cols":11,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
["Matrix - Exercice"]
[]
[]
["MATRIX ADDITION"]
[]
[]
[null,15,-85,0,null,8,78,0,"OK",{"$f":"--AND(K7:M10=EXOMatCorr!J7:L10)","v":0}]
[null,0,55,6,null,88,0,6]
[null,-7,0,-33,null,4,1,5]
[null,2,-4,8,null,-7,-22,-77]
[]
["MATRIX MULTIPLICATION BY A NUMBER"]
[]
[null,15,-85,0,null,8,null,null,"OK",{"$f":"--AND(K14:M17=EXOMatCorr!J14:L17)","v":0}]
[null,0,55,6]
[null,-7,0,-33]
[null,2,-4,8]
[]
["MATRIX DETERMINANT"]
[]
[null,15,-85,0,5,null,null,null,"OK",{"$f":"--AND(K21=EXOMatCorr!J21)","v":0}]
[null,0,55,6,1]
[null,-7,0,-33,8]
[null,2,-4,8,7]
[]
["MATRIX TRANSPOSITION"]
[]
[null,15,-85,0,null,null,null,null,"OK",{"$f":"--AND(K28:N30=EXOMatCorr!J28:M30)","v":0}]
[null,0,55,6]
[null,-7,0,-33]
[null,2,-4,8]
[]
["MATRIX MULTIPLICATION"]
[]
[null,15,-85,0,null,8,78,0,"OK",{"$f":"--AND(K35:M38=EXOMatCorr!J35:L38)","v":0}]
[null,0,55,6,null,88,0,6]
[null,-7,0,-33,null,4,1,5]
[null,2,-4,8]
[]
["MATRIX INVERSION"]
[]
[null,15,-85,0,null,null,null,null,"OK",{"$f":"--AND(K42:M44=EXOMatCorr!J42:L44)","v":0}]
[null,5,55,6]
[null,-7,0,-33]
[]
["SCALAR PRODUCT"]
[]
[null,15,8,-7,14,null,1,null,"OK",{"$f":"--AND(K48=EXOMatCorr!J48)","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,5]
[null,null,null,null,null,null,3]
[]
["PRODUCT OF A MATRIX"]
["WITH ITS TRANSPOSE"]
[]
[null,15,-85,0,null,null,null,null,"OK",{"$f":"--AND(K56:M58=EXOMatCorr!J56:L58)","v":0}]
[null,5,55,6]
[null,-7,0,-33]
[]
[]
["SYSTEM RESOLUTION"]
[]
[null,4,"a+",9,"b+",3,"c=",7,"OK",{"$f":"--AND(L63:L65=EXOMatCorr!K62:K64)","v":0},"a="]
[null,5,"a+",-7,"b+",3,"c=",-8,null,null,"b="]
[null,-2,"a+",3,"b+",-7,"c=",2,null,null,"c="]

{"sheet":"EXOMatCorr","index":3,"n_rows":64,"n_cols":13,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
["Matrix - Exercice"]
[]
[]
[{"$f":"EXOMat!A4","v":"MATRIX ADDITION"}]
[]
[]
[null,15,-85,0,null,8,78,0,null,{"$f":"B7+F7","v":23},-7,0]
[null,0,55,6,null,88,0,6,null,88,55,12]
[null,-7,0,-33,null,4,1,5,null,-3,1,-28]
[null,2,-4,8,null,-7,-22,-77,null,-5,-26,-69]
[]
[{"$f":"EXOMat!A12","v":"MATRIX MULTIPLICATION BY A NUMBER"}]
[]
[null,15,-85,0,null,8,null,null,null,{"$f":"B14*$F$14","v":120},-680,0]
[null,0,55,6,null,null,null,null,null,0,440,48]
[null,-7,0,-33,null,null,null,null,null,-56,0,-264]
[null,2,-4,8,null,null,null,null,null,16,-32,64]
[]
[{"$f":"EXOMat!A19","v":"MATRIX DETERMINANT"}]
[]
[null,15,-85,0,5,null,null,null,null,{"$f":"MDETERM(B21:E24)","v":-212325}]
[null,0,55,6,1]
[null,-7,0,-33,8]
[null,2,-4,8,7]
[]
[{"$f":"EXOMat!A26","v":"MATRIX TRANSPOSITION"}]
[]
[null,15,-85,0,null,null,null,null,null,{"$f":"TRANSPOSE(B28:D31)","v":15},0,-7,2]
[null,0,55,6,null,null,null,null,null,-85,55,0,-4]
[null,-7,0,-33,null,null,null,null,null,0,6,-33,8]
[null,2,-4,8]
[]
[{"$f":"EXOMat!A33","v":"MATRIX MULTIPLICATION"}]
[]
[null,15,-85,0,null,8,78,0,null,{"$f":"MMULT(B35:D38,F35:H37)","v":-7360},1170,-510]
[null,0,55,6,null,88,0,6,null,4864,6,360]
[null,-7,0,-33,null,4,1,5,null,-188,-579,-165]
[null,2,-4,8,null,null,null,null,null,-304,164,16]
[]
[{"$f":"EXOMat!A40","v":"MATRIX INVERSION"}]
[]
[null,15,-85,0,null,null,null,null,null,{"$f":"MINVERSE(B42:D44)","v":4.8168789808917208E-2},7.444267515923568E-2,1.353503184713376E-2]
[null,5,55,6,null,null,null,null,null,-3.2643312101910825E-3,1.3136942675159238E-2,2.3885350318471341E-3]
[null,-7,0,-33,null,null,null,null,null,-1.0217622080679408E-2,-1.5790870488322718E-2,-3.3174097664543524E-2]
[]
[{"$f":"EXOMat!A46","v":"SCALAR PRODUCT"}]
[]
[null,15,8,-7,14,null,1,null,null,{"$f":"MMULT(B48:E48,G48:G51)","v":22}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,5]
[null,null,null,null,null,null,3]
[]
[{"$f":"EXOMat!A53","v":"PRODUCT OF A MATRIX"}]
[{"$f":"EXOMat!A54","v":"WITH ITS TRANSPOSE"}]
[]
[null,15,-85,0,null,null,null,null,null,{"$f":"MMULT((B56:D58),TRANSPOSE(B56:D58))","v":7450},-4600,-105]
[null,5,55,6,null,null,null,null,null,-4600,3086,-233]
[null,-7,0,-33,null,null,null,null,null,-105,-233,1138]
[]
[]
[{"$f":"EXOMat!A61","v":"SYSTEM RESOLUTION"}]
[null,{"$f":"[3]Exercices!B63","v":4},{"$f":"[3]Exercices!D63","v":9},{"$f":"[3]Exercices!F63","v":3},null,{"$f":"[3]Exercices!H63","v":7},null,null,null,null,{"$f":"MMULT(MINVERSE(B62:D64),F62:F64)","v":-0.47169811320754729}]
[null,{"$f":"[3]Exercices!B64","v":5},{"$f":"[3]Exercices!D64","v":-7},{"$f":"[3]Exercices!F64","v":3},null,{"$f":"[3]Exercices!H64","v":-8},null,null,null,null,0.90801886792452824]
[null,{"$f":"[3]Exercices!B65","v":-2},{"$f":"[3]Exercices!D65","v":3},{"$f":"[3]Exercices!F65","v":-7},null,{"$f":"[3]Exercices!H65","v":2},null,null,null,null,0.2382075471698113]