Skip to main content
P
ptc-54181031-Visitor
1-Visitor
December 8, 2013
Question

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

  • December 8, 2013
  • 8 replies
  • 5042 views

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

Werner_E
Werner_E25-Diamond I
25-Diamond I
December 8, 2013

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.

P
ptc-54181031-VisitorAuthor
1-Visitor
December 8, 2013

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).

Werner_E
Werner_E25-Diamond I
25-Diamond I
December 8, 2013

So I think that the attached file should help

Terms & ConditionsAccessibility statement