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

Community Tip - Stay updated on what is happening on the PTC Community by subscribing to PTC Community Announcements. X

How do I do an iterative solve for a variable for 2000 data points contained in Excel?

ptc-5418103
1-Newbie

How do I do an iterative solve for a variable for 2000 data points contained in Excel?

I want pull data from excel (approx 2000 data points) for P1, then iterate P2 until it equals 5.67, continue until all P2's are found for each P1. This expression cannot be solved for P2.

8 REPLIES 8

And what is your concrete problem? The data import from Excel or some part in the calculation?

Your formula contains a capital K, I assume it should be lowercase.

I see no iteration formula, so what iteration would you like to apply?

You say you want to find P2 but you demand that P2 should be 5.67???

Which "expression" do you want to solve for P2? You can only solve an equation for a variable and there is no equation in your sheet.

The concrete problem is to figure out how to solve for P2 if I know, P1, k (and yes they all need to be lower case), and the expression is equal to 5.67. Then I want to do this for 2000 values of P1 (in the file I just put down a few).

So I think that the attached file should help

The file is blank...

Its in Prime3 format and probably you are using Prime2.

You didn't state which version you are using.

There is unfortunately no way to convert it back.

I attach a pdf print of the file.

Sweet, that's what I was looking for. Thanks.

How do I get do the "getP2(P1" with the arrow over the top?

Found it, vectorization under the operators menu...

Top Tags