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

Community Tip - New to the community? Learn how to post a question and get help from PTC and industry experts! X

Match error?

Dumitru
1-Newbie

Match error?

The attached shows a strange behaviour for match..there are two matrices (epsilon_c and sigma_c) with the same size and the same condition imposed in the function called MAX. The maximum values are correct in each case. The problem is that the indexes for the position (row) where those values appear are correct only for sigma_c and not for epsilon_c (should all be listed as 49 - last position in matrice). Further checking on my behalf lead to nothing.

Can anyone provide help?

Kind regards, D.

1 ACCEPTED SOLUTION

Accepted Solutions
MikeArmstrong
5-Regular Member
(To:Dumitru)

Like the attached?

There seems to be something wrong with matches ability when dealing with small numbers.

Mike

http://communities.ptc.com/servlet/JiveServlet/showImage/2-149416-2532/bar_anim.gif

View solution in original post

3 REPLIES 3
MikeArmstrong
5-Regular Member
(To:Dumitru)

Like the attached?

There seems to be something wrong with matches ability when dealing with small numbers.

Mike

http://communities.ptc.com/servlet/JiveServlet/showImage/2-149416-2532/bar_anim.gif

"Like" as in "similar to" or as for "personal taste"? Your sheet is better than mine, still - all values for first row in epsilon_c must be 49 (last value, maximum). Isn't there a way to fix it? (i.e., MAX for epsilon_c lists a matrice - simply delete subscript zero for v_j and see the result - while for sigma_c it calculates correctly everything - value and position in the matrice)

Modified from 10 to 100 - seems to work

MikeArmstrong
5-Regular Member
(To:Dumitru)

Isn't there a way to fix it?

Yes.

By the way I made a mistake in my first post - there was no problem with the match function it was failing to return the expected results due to the worksheet settings.

Change the Convergence and Constraint settings:-

  • tools
  • worksheet options

And increase the number of decimal places.

Mike

http://communities.ptc.com/servlet/JiveServlet/showImage/2-149416-2532/bar_anim.gif

Top Tags