Prime Example of weird Excel Read In

Forum|Forum|14 years ago
March 9, 2012
2 replies
3541 views

Hello Folks,

I gave MathCad Prome this morning a try to check whether I might be able to replicate my work which I so far have done with MC 15. (64 bit Win 7 machine).

However, I was stopped right at the beginning by this weird readin behaviour.

The data file I'm reading in contains mixed characters and data (to have them both in one array is great!) but, alas, it doesn't read it in properly. Does anybody has an idea what's the culprit?

Thanks in advance

Raiko

P.S.

Attached files are MAthCad Prime 1.0 and an Excel 2007.

2_Prime-Example-mcdx.zip

1_Values.xlsx

Statistics_Analysis

Best answer by Raiko

Hello Andy,

thanks for answering. As I said, I gave MC Prime a try but I won't use it any time soon. Based on what I read and my current experience I think it is much safer that way

Cheers

Raiko

A

AndyWesterman

12-Amethyst

Hi Raiko,

I think that it is some oddity in prime1.0,

I opened the file in prime 2.0 & saw the same answer as you see in 1.0, hitting <ctrl> <F9> to re-run the sheet gave a correct answer & a saved version works every time.

I've tried the same in prime 1.0 & it always fails.

Definitely an improvement but so much that mathcad 15 will do that prime can't that I'm only looking at it as an academic exercise at the moment

Regards

Andy

R

Raiko

AuthorAnswer

17-Peridot

Hello Andy,

thanks for answering. As I said, I gave MC Prime a try but I won't use it any time soon. Based on what I read and my current experience I think it is much safer that way

Cheers

Raiko

V

VladimirN