Skip to main content
D
dipeshchauhan1-Visitor
1-Visitor
February 8, 2011
Question

Difference in results between excel and Mathcad

  • February 8, 2011
  • 11 replies
  • 6274 views

Hi ,

I have a Implicit equation to solve , but with the same set of the parameter value i am finding two different curve.

The way i am trying ,

  • Use Excel to iterate by resolving it's circular reference
  • Using Mathcad solver block (Given and find)

Please help me in that.

11 replies

D
dipeshchauhan1-VisitorAuthor
1-Visitor
February 8, 2011

Mathcad 11 ver. file attached

A
AlanStevens19-Tanzanite
19-Tanzanite
February 8, 2011

Your Mathcad formula was wrong - be very careful where you put your brackets!!

Alan

R
RichardJ19-Tanzanite
19-Tanzanite
February 8, 2011
Your Mathcad formula was wrong - be very careful where you put your brackets!!

The Mathcad one or the Eccel one? I found the same thing, but assumed that the one in Excel was probably wrong.

A
AlanStevens19-Tanzanite
19-Tanzanite
February 8, 2011

I think it's the Mathcad one that is wrong as the value of I at V=Voc should be zero. Also, there were differences in the values of Rp and ekt used between the Mathcad and Excel worksheets, though I think the misplaced brackets provided the major source of error.

Alan

D
dipeshchauhan1-VisitorAuthor
1-Visitor
February 9, 2011

Thanks Allan , My problem is solved now. It is "bracket" problem .

I should have notice it, but any way thanks .

M
MikeArmstrong1-Visitor
1-Visitor
February 9, 2011

DONT USE EXCEL !!!!!!!!!

http://communities.ptc.com/servlet/JiveServlet/showImage/38-1286-6356/thwack.gif

Mike

Terms & ConditionsAccessibility statement