topic Re: How do I do an iterative solve for a variable for 2000 data points contained in Excel? in Mathcad https://www.ptcusercommunity.com/t5/Mathcad/How-do-I-do-an-iterative-solve-for-a-variable-for-2000-data/m-p/278640#M108964 <HTML><HEAD></HEAD><BODY><P>So I think that the attached file should help</P></BODY></HTML> Sun, 08 Dec 2013 21:39:30 GMT Werner_E 2013-12-08T21:39:30Z How do I do an iterative solve for a variable for 2000 data points contained in Excel? https://www.ptcusercommunity.com/t5/Mathcad/How-do-I-do-an-iterative-solve-for-a-variable-for-2000-data/m-p/278637#M108961 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. Thu, 03 May 2018 16:39:01 GMT https://www.ptcusercommunity.com/t5/Mathcad/How-do-I-do-an-iterative-solve-for-a-variable-for-2000-data/m-p/278637#M108961 ptc-5418103 2018-05-03T16:39:01Z Re: How do I do an iterative solve for a variable for 2000 data points contained in Excel? https://www.ptcusercommunity.com/t5/Mathcad/How-do-I-do-an-iterative-solve-for-a-variable-for-2000-data/m-p/278638#M108962 <HTML><HEAD></HEAD><BODY><P>And what is your concrete problem? The data import from Excel or some part in the calculation?</P><P>Your formula contains a capital K, I assume it should be lowercase.</P><P>I see no iteration formula, so what iteration would you like to apply?</P><P>You say you want to find P2 but you demand that P2 should be 5.67???</P><P>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></BODY></HTML> Sun, 08 Dec 2013 21:33:07 GMT https://www.ptcusercommunity.com/t5/Mathcad/How-do-I-do-an-iterative-solve-for-a-variable-for-2000-data/m-p/278638#M108962 Werner_E 2013-12-08T21:33:07Z Re: How do I do an iterative solve for a variable for 2000 data points contained in Excel? https://www.ptcusercommunity.com/t5/Mathcad/How-do-I-do-an-iterative-solve-for-a-variable-for-2000-data/m-p/278639#M108963 <HTML><HEAD></HEAD><BODY><P>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).</P></BODY></HTML> Sun, 08 Dec 2013 21:36:12 GMT https://www.ptcusercommunity.com/t5/Mathcad/How-do-I-do-an-iterative-solve-for-a-variable-for-2000-data/m-p/278639#M108963 ptc-5418103 2013-12-08T21:36:12Z Re: How do I do an iterative solve for a variable for 2000 data points contained in Excel? https://www.ptcusercommunity.com/t5/Mathcad/How-do-I-do-an-iterative-solve-for-a-variable-for-2000-data/m-p/278640#M108964 <HTML><HEAD></HEAD><BODY><P>So I think that the attached file should help</P></BODY></HTML> Sun, 08 Dec 2013 21:39:30 GMT https://www.ptcusercommunity.com/t5/Mathcad/How-do-I-do-an-iterative-solve-for-a-variable-for-2000-data/m-p/278640#M108964 Werner_E 2013-12-08T21:39:30Z Re: How do I do an iterative solve for a variable for 2000 data points contained in Excel? https://www.ptcusercommunity.com/t5/Mathcad/How-do-I-do-an-iterative-solve-for-a-variable-for-2000-data/m-p/278641#M108965 <HTML><HEAD></HEAD><BODY><P>The file is blank...</P></BODY></HTML> Sun, 08 Dec 2013 21:52:49 GMT https://www.ptcusercommunity.com/t5/Mathcad/How-do-I-do-an-iterative-solve-for-a-variable-for-2000-data/m-p/278641#M108965 ptc-5418103 2013-12-08T21:52:49Z Re: How do I do an iterative solve for a variable for 2000 data points contained in Excel? https://www.ptcusercommunity.com/t5/Mathcad/How-do-I-do-an-iterative-solve-for-a-variable-for-2000-data/m-p/278642#M108966 <HTML><HEAD></HEAD><BODY><P>Its in Prime3 format and probably you are using Prime2.</P><P>You didn't state which version you are using.</P><P>There is unfortunately no way to convert it back.</P><P>I attach a pdf print of the file.</P></BODY></HTML> Sun, 08 Dec 2013 22:13:32 GMT https://www.ptcusercommunity.com/t5/Mathcad/How-do-I-do-an-iterative-solve-for-a-variable-for-2000-data/m-p/278642#M108966 Werner_E 2013-12-08T22:13:32Z Re: How do I do an iterative solve for a variable for 2000 data points contained in Excel? https://www.ptcusercommunity.com/t5/Mathcad/How-do-I-do-an-iterative-solve-for-a-variable-for-2000-data/m-p/278643#M108967 <HTML><HEAD></HEAD><BODY><P>Sweet, that's what I was looking for. Thanks.</P></BODY></HTML> Mon, 09 Dec 2013 00:25:59 GMT https://www.ptcusercommunity.com/t5/Mathcad/How-do-I-do-an-iterative-solve-for-a-variable-for-2000-data/m-p/278643#M108967 ptc-5418103 2013-12-09T00:25:59Z Re: How do I do an iterative solve for a variable for 2000 data points contained in Excel? https://www.ptcusercommunity.com/t5/Mathcad/How-do-I-do-an-iterative-solve-for-a-variable-for-2000-data/m-p/278644#M108968 <HTML><HEAD></HEAD><BODY><P>How do I get do the "getP2(P1" with the arrow over the top?</P></BODY></HTML> Mon, 09 Dec 2013 00:42:12 GMT https://www.ptcusercommunity.com/t5/Mathcad/How-do-I-do-an-iterative-solve-for-a-variable-for-2000-data/m-p/278644#M108968 ptc-5418103 2013-12-09T00:42:12Z Re: How do I do an iterative solve for a variable for 2000 data points contained in Excel? https://www.ptcusercommunity.com/t5/Mathcad/How-do-I-do-an-iterative-solve-for-a-variable-for-2000-data/m-p/278645#M108969 <HTML><HEAD></HEAD><BODY><P>Found it, vectorization under the operators menu...</P></BODY></HTML> Mon, 09 Dec 2013 01:02:52 GMT https://www.ptcusercommunity.com/t5/Mathcad/How-do-I-do-an-iterative-solve-for-a-variable-for-2000-data/m-p/278645#M108969 ptc-5418103 2013-12-09T01:02:52Z