필터 지우기
필터 지우기

generated "unvaforable zero" value from multiplying two matrices, how to solve/correct it?

조회 수: 3 (최근 30일)
for simplicity, i have a two matrices A and B generated by matlab like below. when i calculated manually by excel with the function mmult(A;B) the value of C is vaforable like this. even when i increasing the decimal. especially the value of cell matrix C at 3,1 it was definetly zero
but when i multiply them in matlab i got value of C like this
how to deal with this type of problem? any guidance will help me alot, because i got bunch of wild value zero like this :( thanks a lott.
the following attachments is my full code, matrix A is k_sup and matrix B is uaa, and matrix C is Fsupt in my line code. input3Dxlsx is my input.
P.S
i tried calculate separately with new script (like the following A*B bottom), copy those matrices from generated excel (so the value is accurate), and the generated value of matrix C is entirely different, like this:
here is the following matrix A and B i copy from generated excel
A = [-3710000000 0 0 0 0 0;
0 -12624305.56 0 0 0 75745833.33;
0 0 -2318750 0 -13912500 0;
0 0 0 -69358333.33 0 0;
0 0 13912500 0 55650000 0;
0 -75745833.33 0 0 0 302983333.3]
A = 6×6
1.0e+09 * -3.7100 0 0 0 0 0 0 -0.0126 0 0 0 0.0757 0 0 -0.0023 0 -0.0139 0 0 0 0 -0.0694 0 0 0 0 0.0139 0 0.0556 0 0 -0.0757 0 0 0 0.3030
B = [0
0
-0.025876011
0
0.004312668
0]
B = 6×1
0 0 -0.0259 0 0.0043 0
C = A*B
C = 6×1
1.0e+05 * 0 0 0.0000 0 -1.2000 0

답변 (0개)

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

제품


릴리스

R2019b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by