[mathcad] Re: Saving results

Author: Mike Austin Posted: Wed, 14 Sep 2005 23:02:13 +0100

Laurent Muller "muller" writes

>On small data sets, it is possible to define a new matrix by cutting
>and pasting the result of previous calculations to this matrix, delete
>all computations above this new matrix, and then use the newly defined
>matrix for plotting (would be equivalent to "paste values" in Excel).
>But cut and paste does not seem to work for a larger data set.
>
>Any way to do this beside export/import via a .prn file?

Try using submatrix and pasting the results in separate places. Adjust
the size of the submatrices so they are within the dimension limits.

--
Mike Austin
Gistar Ltd

[mathcad] Re: Saving results

Author: Laurent Muller Posted: Thu, 15 Sep 2005 05:59:03 -0500

Mike,

Thanks for the tip.

I was hesitant to use the .prn route because I was not familiar with the
procedure, but with a customer waiting for results, I had no choice. Did
not realize how easy it was! And worked great too.

Am working with an older, relatively slow PC with only 512 MB memory (and
quite a bit less actually available). Opening the MCad document containing
the test data internally in a matrix takes a long time (several minutes),
while reading the same data from a .prn is a matter of seconds.

Is this generally true?

If it is the case, it seems that keeping large data set in external files
should be the preferred solution?

Laurent Muller.

At 05:02 PM 9/14/2005, you wrote:
>Laurent Muller "muller" writes
>
>>On small data sets, it is possible to define a new matrix by cutting and
>>pasting the result of previous calculations to this matrix, delete all
>>computations above this new matrix, and then use the newly defined matrix
>>for plotting (would be equivalent to "paste values" in Excel). But cut
>>and paste does not seem to work for a larger data set.
>>
>>Any way to do this beside export/import via a .prn file?
>
>Try using submatrix and pasting the results in separate places. Adjust the
>size of the submatrices so they are within the dimension limits.
>
>--
>Mike Austin
>Gistar Ltd
>

[mathcad] RE: Saving results

Author: Leslie Bondaryk Posted: Fri, 16 Sep 2005 14:08:41 -0400

Laurent,

You should be able to view large matrices in a data table. Right click
on the topmost left corner of the table, choose "Select All", then
choose "Copy Selection". Then create a new Data Table by choosing
"Table" from the Insert > Data menu. Select the first cell, right click
on it, and choose "Paste Table".

You should now have a complete copy of your matrix defined in the
document for saving and subsequent use.

Hope this helps,

Leslie Bondaryk

~************************************************~
Leslie Bondaryk
Technical Project Manager
Mathsoft Engineering and Education, Inc.
101 Main Street Cambridge, MA 02142
"lbondaryk"
TEL: 617-444-8176 FAX: 617-444-8177
www.mathcad.com

> From: Laurent Muller "mailto:muller"
> Sent: Wednesday, September 14, 2005 3:42 AM
> To: Mathcad Discussion List
> Subject: [mathcad] Saving results
>
> Am using MCad 2001 to plot a set of recorded test data with
> too many points to plot.
>
> My small trimming routine takes forever to run and I'd like
> to avoid recalculating every times the MCad document is opened.
>
> Is there a simple way to save the Matrix of the trimmed data,
> so it can be used directly for plotting, without having to
> rerun the routine on the original data?

[mathcad] Re: Saving results

Author: Eden Mei Posted: Thu, 22 Sep 2005 12:20:42 -0700

The only real issue I see is that separation of the data and the worksheet
is fairly common, so that's a serious negative in terms of configuration
management.

TTFN,
Eden

From: "Laurent Muller" "muller"
To: "Mathcad Discussion List" "mathcad"
Sent: Thursday, September 15, 2005 3:59 AM
Subject: [mathcad] Re: Saving results
>
> If it is the case, it seems that keeping large data set in external files
> should be the preferred solution?

[mathcad] Re: Saving results

Author: Mike Austin Posted: Thu, 22 Sep 2005 20:10:28 +0100

Laurent Muller "muller" writes

>Am working with an older, relatively slow PC with only 512 MB memory
>(and quite a bit less actually available). Opening the MCad document
>containing the test data internally in a matrix takes a long time
>(several minutes), while reading the same data from a .prn is a matter
>of seconds.
>
>Is this generally true?

You need to compare like with like - i.e. add the time it takes to load
Mathcad onto the time it takes to read the file. If it is still slower,
then I don't know why.

--
Mike Austin

[mathcad] Re: Saving results

Author: Laurent Muller Posted: Thu, 29 Sep 2005 17:54:44 -0500

>
> You need to compare like with like - i.e. add the time it takes to
> load
> Mathcad onto the time it takes to read the file. If it is still
> slower,
> then I don't know why.
>
> --
With MathCad 2001 open, the file with the data table takes 1 min 40 sec to open. The file with a READPRN for the same data takes 3 sec.
As recommended by Eden tough, I will still archive the file with the embedded data table. READPRN is a time saver while working on the file (at least on my system. Seems to be same on my Win 2000 at work and XP Pro at home)

Laurent Muller

[mathcad] RE: Saving results

Author: Laurent Muller Posted: Thu, 29 Sep 2005 16:57:41 -0500

From: Leslie Bondaryk "lbondaryk"
Date: Friday, September 16, 2005 1:08 pm

> Laurent,
>
> You should be able to view large matrices in a data table. Right
> clickon the topmost left corner of the table, choose "Select All",
> thenchoose "Copy Selection". Then create a new Data Table by choosing
> "Table" from the Insert > Data menu. Select the first cell, right
> clickon it, and choose "Paste Table".
>
> You should now have a complete copy of your matrix defined in the
> document for saving and subsequent use.
>
> Hope this helps,
>
> Leslie Bondaryk
>

Our mail servers were moved around ahead of Rita here in Houston and I am only now reading your message.
Yr method worked like a charm...and fast! Thanks.
Did not have "Table" in the "Insert" menu in my 2001 license, but got there using "component..."

Thanks again for the help.

Laurent Muller

Previous by date: [mathcad] Re: Upgrade to Mathcad 12.1 Crash, Mike Austin
Next by date: [mathcad] Re: Upgrade to Mathcad 12.1 Crash, Dave Powley
Previous thread: [mathcad] Re: Help with VBscript, Mike Austin
Next thread: [mathcad] Re: Upgrade to Mathcad 12.1 Crash, Mike Austin

Ready to buy?

For more pricing information:
Visit our webstore, call us on +1 800 724 8380 or email us at info@adeptscience.com

Featured Downloads

Mathcad 14 demo

Mathcad 14 Brochure

Mathcad or Excel?

Mathcad Customer Story: Man B&W Diesel

Mathcad Customer Story: Stork Fokker Aerospace

Mathcad White Paper - Moving beyond the limitations of spreadsheets

Product Reviews

"Our work ranges from complex medical imaging research to large-scale mapping and diagrams and we need a tool that is able to handle anything we investigate. With Mathcad, we are able to manipulate and analyse our data quickly while at the same time documenting our work, for sharing and publication. We also use it for pilot studies conducted in support of research grant applications. It is an end-to-end tool for research and development."
Dr. Kenneth Castleman, President of Advanced Digital Imaging Research (ADIR), Houston, Texas

"Mathcad is an integral product for my work... With Mathcad, itís easy to disseminate design calculations because the documents look like real math. Thereís very little I canít do in Mathcad. The main benefits come from the format, which resemble a typed set of calculations. These programs are easier to develop by engineers and easier for others to follow and review since the logic is expressed in a familiar manner. The format is what places Mathcad head and shoulders above other programs of a similar function."
Andre Pavlov, Structural Engineer, Florida Department of Transportation