Spreadsheet to Matrix

[Luke Setzer]

I vaguely recall the TI-89 Titanium having the power to store an
entire spreadsheet under a single variable name.

The calculator application could then recall that variable and treat
it as a matrix.

How can I get the TI-Nspire to do the same?

[Nelson Sousa]

I think you can't do that automatically on Nspire.

You can name the columns,convert them to matrices, using the list>mat function and then use augment to concatenate all column matrices in one single matrix, but it has to be done by hand.

Nelson

[Daniel Dudley]

Please don’t put words in here that we have to look up.  I am a simple hick and don’t know such words as concatenate.  Thank goodness for Dictionary.com.

 

Just kidding, please feel free to expand my vocabulary, I can’t wait to use the word in class and see the glazed eyes, oh wait I get that anyway without new words.

 

Dan

[Nelson Sousa]

well, then do this one:

"Hello"&" "&"World!" ;)

Nelson

[developerzero]

Here is a function that will take two lists (i.e. two columns from the
list & spreadsheet editor) and turn them into a 2XLength matrix (make
sure you use two lists of the same length):

list2mat(x,y):=augment(list->mat(x,1),list->mat(y,1))

Replace -> with the solid right triangle (available in the character
map (ctrl-catalog) on the top right, or you can insert the list->mat
function from the catalog).

I'm working on writing a generic version that takes a list of lists,
and combines them into a matrix. I'll post my results when I get it
done.

-Ryan

On Oct 27, 2:40 am, "Nelson Sousa" <nso...@gmail.com> wrote:
> I think you can't do that automatically on Nspire.You can name the

> > How can I get the TI-Nspire to do the same?- Hide quoted text -
>
> - Show quoted text -

[developerzero]

Okay, scratch everything that has been said, there is a really easy
way to do this.

1) Put your data into the L&S app. Be sure to name every list (like
list1, list 2, etc.)
2) Open the calculator app.
3) Enter the lists as a list of lists (i.e. {list1,list2,etc.} ). This
returns a MATRIX consisting of rows made of the lists (i.e. the first
row is list1, the second is list 2, etc.)
4) (Optional) If you want the matrix in vertical format instead, just
add a transpose at the end of the list (menu-7-1, or in the catalog)
(i.e. {list1,list2,etc}T - note: this should be the transpose symbol
(floating T) but I can't find any way to add one on Google Groups).

Hope this helps,

-Ryan

> > - Show quoted text -- Hide quoted text -