8 Replies Latest reply on Jan 20, 2009 5:46 PM by Christine Bickenbach

# tolerance / design table / drawing

Does anyone know if this will be changed in a service pack to come, or has it already?

When working with tolerance callouts in design tables for my drawings, I get: for example,

or symmetric;0.002000 instead of +/- .002

My boss hates it when I use the tolerance from the design table becuase of this. Manufacturing yells at me because of all those zero's... I try to tell them it's SW, but they just want me to change it. So, my only option up until now is manually type everything in....
with tons of configurations human error is bound to happen, not to mention the pain of manually typing everything in...

Any relief in sight??

• ###### tolerance / design table / drawing
If I understand correctly, you are concerned about how the design table looks in your drawing. For that you can covert the useful part of the text to a number. For example, for a symetrical tolerance, create another column and use the formual =VALUE(MID(A1,12,4)) where "A1" equals the cell where the tolerance appears. That will grab the tolerance to 3 places and convert it to a number value. You can then format the cell to what you want. Hide the column you don't want to see.
• ###### tolerance / design table / drawing
Hi Dwight,

This is starting to look good!! I still need a bit more help though..

Can I do the same with my bilateral values? if so how?

also

You said, "You can then format the cell to what you want".

Did you mean I can format the cell to get the +/- sign in that cell?? Or how would you recommend get the signs?

I'm not used to using excel, let alone tables and formulas...

below is a screen shot of how my table looks, as you can see I've converted the one symmetrical cell according to your instructions.. but need help with the bilateral and the signs...

thank you so much for your help!!

• ###### tolerance / design table / drawing
So where cell A1 contains . . .

BILATERAL;0.002000;-0.001000

make a cell containing . . .

=CONCATENATE("+",MID(A1,12,4))

and another containing . . .

=CONCATENATE("-",MID(A1,22,4))

I hope you can figure out the code, enough to make any changes you want.

• ###### tolerance / design table / drawing
Dwight,

Admit... it did take me a few and the assitance of a co-worker to figure out the code... LOL

I think I've got it now!! Looks much better than before.

Thank you very much for your help!!

Christine
• ###### tolerance / design table / drawing
YES......... Dwight!! You're a GENIUS!!!!

I got it...... with the formula...

=CONCATENATE("+",MID(E4,12,4),"/","-",MID(E4,22,4))

I even got everything in one cell!!!

Thank you!!!
• ###### tolerance / design table / drawing
By George, she's got it . . .
• ###### tolerance / design table / drawing
Can you post an example of the CONCATENATE you did for the bilateral tolerances in the design table? I think this will work for me, but I want to make sure before i spend the time. I need the tolerances to show up in one cell like you say this has done for you.

********************
Brandon
Designer
SW 2008 sp4.0
ATI 3350
• ###### tolerance / design table / drawing
Attached is a sample table.

Later I hid the column with the original tolerances.

Christine