HP Forums
Assemble matrices in spreadsheet - Printable Version

+- HP Forums (https://www.hpmuseum.org/forum)
+-- Forum: HP Calculators (and very old HP Computers) (/forum-3.html)
+--- Forum: HP Prime (/forum-5.html)
+--- Thread: Assemble matrices in spreadsheet (/thread-2268.html)



Assemble matrices in spreadsheet - toperos - 10-11-2014 04:46 PM

I have 4 matrices 2x2 in the spreadsheet. I wonder if there is any way to assemble them forming one matrix of 4x4, for them inverse it.

Or if there is any way to do that in the main menu.


RE: Assemble matrices in spreadsheet - Helge Gabert - 10-11-2014 07:55 PM

In CAS (is this what you call "main menu")?

CONCAT(M1,M2) -> M5
CONCAT(M3,M4) -> M6

mat2list(M5) -> L1
mat2list(M6) -> L2

CONCAT(L1,L2) -> L3

list2mat(L3,4) -> M7

M7^-1 -> M8

There may be a more elegant way to do this, however.


RE: Assemble matrices in spreadsheet - toperos - 10-11-2014 08:53 PM

Thanks! It helped me a lot.
A very ingenious way.