Thanks everyone for all of your help. I've never done iterations schemes with Excel before. I am more accustomed to using Matlab for things like that.
I finally got it to work! This is my first post to these forums, and all I can say is that I wish I would have came here earlier! I am very...
Thanks... that's the direction that i'm headed. I would really like this 'code' to be hard wired in so I don't have to goal seek everytime I change some numbers.
Arrgh!!!... I forgot to add it in. I think that I've been staring at numbers for too long! P is a scalar that gets added into the Tasm equation. Here it is again:
Tasm=(J28*E28+J29*E29+J30*P*E30+J31*P*E31+J32*P*
E32+J35*P*E35+J36*P*E36+J37*P*E37+J38*P*...
Hello,
I have a long equation that I am trying solve for a particular variable so I can put it into Excel.
Background: The equation is for a tolerance allocation problem using an estimated mean shift model with user defined component deviations (6sigma or anything you like), and proportional...