Change unit of value in table

[HugoP69]

Hello

I have a table with many indications about a threading including the helix angle. my part and the drawing are in mm and degrees°, but for a supplier we need the have the angle in degree minute second in the table. I looked at the information page with all the &parameter and didn't find how to change the unit just for this value (not the whole file).

I think it may be &parameter[something here] just as the number of decimals.

Do you know how to do it please ?

What I want :

What I have :

  

[tbraxton]

To change the display of a single value in the table there are two options I can see.

1) Manually enter a string in the table cell with DMS format. This will be static and not driven by the model.

2) Use relations to convert decimal degree values to DMS format. Define new parameters via relations editor for the deg min sec using the algorithm shown in the pic below. Once these values are calculated you can use them in the table cell, and they will be driven by the decimal angle value in your model. Note that Creo does not have an integer function for relations, so you have to follow the workaround detailed here to get the integer value.

https://resources.rand3d.com/creo-tips/creo-parametric-3-0-tip-how-to-convert-a-real-number-parameter-to-an-integer#:~:text=First%2C%20go%20to%20Tools%3EParameters%20and%20create%20your%20real,a%20value%20of%201%20for%20the%20integer%20parameter. 

[HugoP69]

Thanks a lot, as the document is a template for many parts, I will try the second choice. Thanks for your help

[tbraxton]

If you have Mathcad, there is probably a conversion function available, and you could embed that in the model/template which may be easier. 

[Dale_Rosema]

Wouldn't the second equation be:

m = int((angleparam - d) x 60)

Third:

s = ((angle param - d - m)/60) x 3600

At least for use if more than one result needs to be calculated.

[KenFarley · Accepted solution]

To put this in a table, it would probably be best to build a string that is then referenced. So, for sick fun, I tried to do that with the example value given above. Here's the code:

angdms  = ITOS ( floor ( angdecimal ) ) + "<degree sign>"
angfrac = angdecimal - floor ( angdecimal )
angdms  = angdms + ITOS ( floor ( angfrac * 60 ) ) + "' "
angfrac = angfrac - floor ( angfrac * 60 ) / 60
angdms  = angdms + ITOS ( angfrac * 3600 ) + '"'

Note that I couldn't paste the degree sign in that Creo uses, so I put in <degree sign>. Note also that the double quote for seconds has to be enclosed in single quotes to work.

The only time I've been forced to work with these angular units lately is when using a very large manual rotary table. What a trip. At least it's not gradients...