I'm using Mathcad 15 M030 for analysing data. I got the "out of memory" error message if I paste the file I have attached in a mathcad table.
I know that the topic has been already discussed in this forum but I didn't find any workaround.
Is there in the meantime a new solution?
Thank-you very much for your support.
Thank-you for your reply.
It is better now but I still have out of memory error message if the table is bigger (73000 x 3).
Is there any way to work with "big" data without this problem?
One method would be to read in the data using one of Mathcads READ.... functions.
But as you are using real Mathcad and not crappy Prime, you can copy the data from your text file (Ctrl-C), go to Menu - Insert - Data - Table, highlight the first three columns in the first row of the data table which was just created and insert the copied data (Ctrl-V).
It should work without highlighting the top three cells but it doesn't for me.
I attach a worksheet with the inserted data.
> I still have out of memory error message if the table is bigger (73000 x 3).
> Is there any way to work with "big" data without this problem?
Thats not really "big" data for Mathcad and sure should work OK. You may consider not to copy the data but rather read it in from your text file in case the data changes now and there.
> All data must be on the right. Something is wrong with the central column (B).
No, nothing wrong with the data. Its just your European installation of Excel which expects a comma as decimal separator rather than the decimal point provided in the text file. So the data 0.17 is interpreted as text by your Excel and not as a number and so it not right-, but left-justified.
It works, thanks a lot.
Mathcad is still consuming much memory 1.5Gb but I get no error message anymore.
Can't imagine why Mathcad should take up that much memory for a matrix that small !?? Hard to believe!
I have looked at the release notes of the current Mathcad 15 M050 (see attached) and could not find any note that a memory leak would have been fixed, but there are some other bug fixes after M030 which may be of interest:
Vladimir, do you also know where you can download mathcad 15M050? The link goes to matcad 15M045.
I don't think there is any public place where you can download M050. That was the first bugfix after PTC switched to subscription only, so I think is it available only on a subscription license. I am working under the assumption that MC15 045 is the last version of Mathcad I will ever have (not including some versions of Prime that I never use)
Without seeing your Mathcad worksheet I have to guess. But, as you say, this has come up before, many times, so it's an educated guess.
How can such a small amount of data lead to such huge memory requirements? The answer is probably that you are creating many copies of the data in the worksheet. Take this simple example, where A is your data:
B, C, and D are all copies of your data, and all are stored internally, because Mathcad has to be able to display them at any time. You might think that overwriting A is a solution:
It's not. Each new A is still held internally in memory. The second A can't overwrite the first A because Mathcad has to be able to display both, depending on where in the worksheet you put an evaluation.
Creating a long series of static calculations is a bad way of doing things in Mathcad. There are many reasons why that is true, and this is one of them (especially when it comes to data analysis).
Instead, define a function:
This takes negligible memory, and has the advantage of being reusable throughout the worksheet.
Then you can do
All the intermediate results, which you likely didn't need to look at anyway, are gone, along with the memory required to store them.