I Need Help

[TheodoreM.Bones]

How can I transfer a long matrix table to a Data Input display without hand copying? A short simple example matrix is:

10 5
15 4
20 3

I want to display it in the usual Data Table form. What steps are needed?

Thanks.

[AlvaroDíaz]

Hope this helps.

Regards. Alvaro.

[TheodoreM.Bones]

That form works OK, but I can't transfer the data file to another worksheet in the approved form it provides. Saving it and then accessing it gives the original matrix form, not the Data Table form.

MANY THANKS 11

Theodore

[Fred_Kohlhepp]

On 1/22/2010 5:56:44 AM, study wrote:
>That form works OK, but I
>can't transfer the data file
>to another worksheet in the
>approved form it provides.
>Saving it and then accessing
>it gives the original matrix
>form, not the Data Table form.
>

If you set the results format box as shown without anything on the worksheet selected, then ALL of your matrices will display as tables (even the ones you don't want to.

Fred Kohlhepp
fkohlhepp@sikorsky.com

[TheodoreM.Bones]

Thanks a million, just what I wanted. Always wondered how other Forum members managed to post a shortened column of data to save space on the worksheet. Sometimes I stack data files and have a 151 row of data that I can�t or won't display.

Personally I am very fond of Mr. Sikorsky. He came down here in 1954 to dedicate our 1-strip airport BLF.

Study

[ptc-1368288]

On 1/22/2010 6:40:15 AM, fkohlhepp wrote:
>On 1/22/2010 5:56:44 AM, study wrote:
>>That form works OK, but I
>>can't transfer the data file
>>to another worksheet in the
>>approved form it provides.
>>Saving it and then accessing
>>it gives the original matrix
>>form, not the Data Table form.
>>
>
>If you set the results format box as
>shown without anything on the worksheet
>selected, then ALL of your matrices will
>display as tables (even the ones you
>don't want to.
>
>Fred Kohlhepp
>fkohlhepp@sikorsky.com
______________________________

Theodore, you will understand what I'm doing.
Your point seems here:

"That form works OK, but I
>>can't transfer the data file
>>to another worksheet in the
>>approved form it provides.
>>Saving it and then accessing
>>it gives the original matrix
>>form, not the Data Table form."

If you have arrays of different size and different names, resulting from a complete work sheet... you can spool to file IN-OUT [==> ... <==] *.PRN ... as the image shown in the example.

Having spooled (saved) to file, you can recall (read) from another work sheet. The trick is to create an indexed single vector that collects all the individual arrays like just shown below Marlett.

If you have a lot of data array from a work sheet, collect them all and extract only the ones you want. This is what the module CELL illustrates. You can collect only the ones you have interest.

About the display as a data table, just type the name = ... If "too large to display" or "matrix too large", try to vectorize as exemplified for Dog.

That's about what I understood from your visit. Quite a mighty tip to collect plots of same nature [2D, 3D, images, data tables ...] and spool to files. The limit being in fact the PRN, no collab have ever mentioned any limit ... could you fill a hard drive of 100 GIG as *.PRN ? I wish knowing the limit, but so what if can stay ignorant of that !

RESUME:
1. Name a vector
2. For each index, plug the array
3. WRITEPRN
4. READPRN

From the other sheet where you would read, you can read from a list box, or simply if you don't like scripted components, just have an identifier piece of text that will tell what is what. If for instance, you would have only photos (images), you can view all of them back as IrfanView or Photoshop ...

Happy new year Theodore.

Jean

[ptc-1368288]

On 1/22/2010 6:40:15 AM, fkohlhepp wrote:
>On 1/22/2010 5:56:44 AM, study wrote:
>>That form works OK, but I
>>can't transfer the data file
>>to another worksheet in the
>>approved form it provides.
>>Saving it and then accessing
>>it gives the original matrix
>>form, not the Data Table form.
>>
>
>If you set the results format box as
>shown without anything on the worksheet
>selected, then ALL of your matrices will
>display as tables (even the ones you
>don't want to.
>
>Fred Kohlhepp
>fkohlhepp@sikorsky.com
_______________________

Default or table is same,
I leave it default and never force to "Matrix", why ?

Lot of work are in scalar mode and the only distinction is that when you press = if it shows cols/rows numbered, you know the result is vector/matrix. If it shows cols/rows not numbered, you know it is still at the kernel level as a scalar form and it's where the user has to properly address for a rows/cols numbered, i.e: an export. Many projects need be carried in the hybrid forms: scalar or discrete and the distinction is important. If it can be carried all scalar, much faster than transforming too early in discrete mode, because the scalar form keeps running at the kernel level.

Just a general tip for advanced Mathcaders.

jmG

[ptc-1368288]

... disambiguation as per my previous thread.
A simple example of the revealing display and hybrid structure.

jmG

[TheodoreM.Bones]

The essential point on all this is that saving any Data Table form (scalar) to the clipboard and later accessing it from the clipboard on a new worksheet doesn�t work. That�s all. Staying in MC14.
WRITEPRN & READPRN work OK on matrices, but what is the use of having to hand copy data into the Data Table. That is, what is the utter use of the Data Table input anyway if you have the data in hand?

I think some Data Tables printed elsewhere on pdf pages can be sent to the clipboard and saved.

Elsewhere I obtain raw data and save it to WordPad under a name, then READPRN it on a new worksheet.

That SilverLight process on Microsoft XP ought to serve as inspiration for a better clipboard function.

Study

[ptc-1368288]

On 1/22/2010 2:19:24 PM, study wrote:
>The essential point on all
>this is that saving any Data
>Table form (scalar) to the
>clipboard and later accessing
>it from the clipboard on a new
>worksheet doesn�t work.
>That�s all.
...

>Study
___________________________

That's what I pointed:
Scalar operation are at the kernel level, therefore not user exportable values. Thus excluding WRITEPRN/READPRN. Nothing you can do unless the Mathcad structure would be designed accordingly. Personally, I don't see any justification, no such feature has ever been mentioned.

In some instance, you can try to vectorize the scalar in the WRITEPRN. It should work, but have no example in mind. You can make one quick.

Jean

[AlvaroDíaz]

On 1/22/2010 5:56:44 AM, study wrote:

>That form works OK, but I
>can't transfer the data file
>to another worksheet in the
>approved form it provides.

I report as bug that in mathcad 14 copy/paste procedure lost the user format in the tables. See

http://collab.mathsoft.com/read?131481,99

>Saving it and then accessing
>it gives the original matrix
>form, not the Data Table form.

That's happen down saving from mathcad 14 to mathcad 11, reported as bug in the same post. I assume that nobody go to correct this, because mathcad 14 is the last version that can save as mathcad 11, isn't?

Regards. Alvaro.