Round off Bundle/Cable/Wire length

[vijkopgan]

Hello Experts,

Is there any option to round of the bundle length values to nearest 10's. i.e 1674 to be 1670.

Able to control only decimal places in repeat region.

Please advise if anyone know the option.

Thanks,

Vijay K G

[MartinHanak]

Hi,

I hope you can achieve your goal, if you implement repeat region relations.

Please upload example files. I will create relations for you, if you want.

Use How to Attach a File to a Discussion Reply procedure to upload data.

MH

[vijkopgan]

Hi,

Thank you for your time and interest.

Request you to create relation for this subject. Attaching herewith sample harness drawing with spool table.

Below is the default values which getting from the harness file.

I would like to have length values in 10's as follows,

146 -> 150

134 -> 130

147 -> 150

Thanks,

Vijay K G

[HamsterNL]

First, I would not recommend to ROUND DOWN on any cable length...you will be hitting your head against a wall if your cable is too short.

The calculation (ROUNDING UP) is simple:

CABLE_LENGTH = 144

ROUNDOFF = 10

CABLE_LENGTH_COR = CEIL(CABLE_LENGTH/ROUNDOFF)*ROUNDOFF

[HamsterNL]

Or if you realy want to use a ROUND function:

CABLE_LENGTH = 145.556371

ROUNDOFF = 10

CABLE_LENGTH_COR = FLOOR((CABLE_LENGTH+ROUNDOFF/2)/ROUNDOFF)*ROUNDOFF

This also works if you want to round to a decimal value, just change the "10" to "0.1" for example.

[vijkopgan]

Thank you. You are correct.

I practice this way, since we already has some allowance in routing and dimensions are in mm.

I'm good with 'rounding up' the value.

I tried the relation which you advised here. I can't able to achieve the results.

If you could help me, please check with my sample file (Creo 3.0 M090) and show me the relations or updates table file.

Thanks,

Vijay K G

[vijkopgan]

Hi,

Mr, Martin Hanak‌ helped me by sending the updated files with the same option you mentioned here.

I missed to call the relation parameter. Now I got it...

Thank you very much for your timely support.

Thanks,

Vijay K G

[MartinHanak · Accepted solution]

Hi,

I added new drawing version to your dataset. I slightly modified repeat region relations and repeat region table. I used Creo 3.0 M100.

MH

[vijkopgan]

Hi,

Excellent! I was looking for this solution only.

Thank you very much for your time and support.

Regards,

Vijay K G

[SMMV]

Hi Vijay,

I wanted to round off the harness value. Can you please write the relation.?  Secondly, how to show the P1 and P2 in 2 pin connector? How to call out bundle length in drawing? What is the parameter drives the value?

Thanks

Best Regards

Mickle