cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can subscribe to a forum, label or individual post and receive email notifications when someone posts a new topic or reply. Learn more! X

Help with programming

yhuang-8
5-Regular Member

Help with programming

Hey I have a question. Since I am still quite new to this software, if you think my question is easy, please help me out. Suppose I have a value calculated at the end with different parameters. Wondering if there is any way that for each parameter, I can create a matrix or excel with two columns, one is the parameter number, and the other is the corresponding value, when keeping others constant. 

Thanks a lot!

8 REPLIES 8

Hi,

 

It is easy to do what you are after, but first -> which version are you using?

Cheers

yhuang-8
5-Regular Member
(To:terryhendicott)

I am using mathcad prime 2. Thanks!

Raiko
16-Pearl
(To:yhuang-8)

here we go.

I've added a MatCad 15 file that shows the idea.

Raiko

 

P.S.

 

had to edit, since I've uploaded wrong file.

yhuang-8
5-Regular Member
(To:Raiko)

Hi Thanks a lot for your reply!

The problem I have is that the outcome variable is not a simple equation and it's been calculated after 5 or 6 pages with many other parameters too (even though we can keep other parameters constant). Wondering how you solve the problem in this case?

Thanks again!

Its stabbing in the dark without seeing what you do, but I guess you would have to turn every calculation, which uses the parameters you would like to vary at the end, into functions dependent on those parameters.

With long winded calculations as you describe it this can be pretty cumbersome and result in a wild looking worksheet.

It has bee a long standing wish of the community to be able to turn a whole worksheet into a function of a number of selectable arguments but as development is running now, that kind of wishes never will be fulfilled.

 

While I don't like the approach - Raikos way to start with vectors of input values right from the start, vectorize the calculations to end up with a vector of result values should work with long winded calculations as well (and possibly will look cleaner compared to the suggested functional approach). Where do you see a problem with that?
Guess it would help if you post a worksheet to show what exactly you are trying to attempt (a simplified one showing only the important things would be preferred).

 

BTW, as you obviously could read Raikos MC15 worksheet, you seem to have MC15 installed along with Prime 2. Why do you bother to use Prime 2 when MC15 is at your hand?

yhuang-8
5-Regular Member
(To:Werner_E)

Thank you SO MUCH for your kind reply!

I am not quite sure if I want to continue in this way rather than simply manually get the results. One reason for me to hesitate is that for those long winded calculations, there are already matrices. I am afraid the vectorization of parameters would make the worksheet look too crazy. 

I will try to upload a worksheet I am working soon.

Thanks a lot again! 


that for those long winded calculations, there are already matrices. I am afraid the vectorization of parameters would make the worksheet look too crazy. 

Even worse! If your calcs already use matrices, then the approach with the vectors of input values and vectorization might not work at all, because vectorization is applied to ALL matrices in the vectorized expression.

 

yhuang-8
5-Regular Member
(To:Werner_E)

Thank you very much!

Top Tags