kg ----> lb
kg ----> lb
(OP)
From thread559-87119
I am trying to have weight of the part displayed on the drawing to be "bilingual", that is lb and kg.
I would like to have it done "automatically" that is when the weight of the part changes, BOTH values to get updated.
To have one value (either kg or lb) is no problem - but how to do both ?
So far using the Design Table (using the hint given by meintsi) I have managed to do this:
A B C
1 Design Table for: My_Part
2 $prp@value_1 $prp@value_2
3 First "SW-Mass@@First@My_Part.SLDPRT" #VALUE!
The Formula in the cell C3 is: =B3 * 2.2
In the Properties I have:
Name Type Value/Expr Evaluated
------------------------------------------------------
Weight_kg Text $PRP:"value_1" 167
Weight_lb Text $PRP:"value_2" #VALUE!
By puting note on drawing $PRPSHEET:"Weight_kg" I get 167, which is correct weight in kg.
By puting note on drawing $PRPSHEET:"Weight_lb" I get #VALUE!
The problem lies in the Design Table - the formula in C3 evaluates to #VALUE! with a green triangle in top left corner.
No matter what I tried to do (formatting the cel C3 and B3 - both are (?) set to Number) I get what you see above ... Sigh
...
Can anybody help please.
Quote:
meintsi :13 Feb 04 9:49
You can use a design table to do the calculation and have it propagate a custom property for the value which can then be use to fill the note on the drawing.
I am trying to have weight of the part displayed on the drawing to be "bilingual", that is lb and kg.
I would like to have it done "automatically" that is when the weight of the part changes, BOTH values to get updated.
To have one value (either kg or lb) is no problem - but how to do both ?
So far using the Design Table (using the hint given by meintsi) I have managed to do this:
A B C
1 Design Table for: My_Part
2 $prp@value_1 $prp@value_2
3 First "SW-Mass@@First@My_Part.SLDPRT" #VALUE!
The Formula in the cell C3 is: =B3 * 2.2
In the Properties I have:
Name Type Value/Expr Evaluated
------------------------------------------------------
Weight_kg Text $PRP:"value_1" 167
Weight_lb Text $PRP:"value_2" #VALUE!
By puting note on drawing $PRPSHEET:"Weight_kg" I get 167, which is correct weight in kg.
By puting note on drawing $PRPSHEET:"Weight_lb" I get #VALUE!
The problem lies in the Design Table - the formula in C3 evaluates to #VALUE! with a green triangle in top left corner.
No matter what I tried to do (formatting the cel C3 and B3 - both are (?) set to Number) I get what you see above ... Sigh
Can anybody help please.






RE: kg ----> lb
Ken
RE: kg ----> lb
Of course - and I tried out that too ... The problem I had was - how to get that 'variable' (mass, weight - whatever) into the equation - I ALWAYS get "The syntax of the equation is incorrect" message.
RE: kg ----> lb
Just got a hint from my office Excell guru - SW probably uses the Excell Design Table as some kind of "Dumb Data Storage" area and only SW knows how to interpret the data in the cells - (for example you could write an lenghty article in the cell,)
but Excell does not know what to make out of:
"SW-Mass@@First@My_Part.SLDPRT" - only SW does.
So I guess, Design Table might not be the route to go - equation would be fine, but:
- How do I get the "SW-Mass" (or whatever) into the equation without getting the syntax error ??
RE: kg ----> lb
Instead of telling the DT where to look, let the DT populate itself with the property from the model. Then copy that value to an "out-of-DT-range" cell & use that to calculate the alternative weight.
ht
The new property can then be linked into a drawing note.
Helpful SW websites FAQ559-520
How to get answers to your SW questions FAQ559-1091
RE: kg ----> lb
Yes Sir, it works !!!
One little thing - Solid model units are lb 2 dec places - I do get kg with fifteen decimal places.
Any way to limit the decimal places ??
Thanks !!
RE: kg ----> lb
BTW, you should not have to "copy that value to an "out-of-DT-range" cell". I first tried using the value in cell B3 but for some reason it did not work, so I tried the solution posted which worked fine. I then tried again using B3 & it worked the way it should.???
Glad you're up & running anyway.
Helpful SW websites FAQ559-520
How to get answers to your SW questions FAQ559-1091
RE: kg ----> lb
Figured out myself - thanks for reply anyway.
BTW what you say does NOT work for me - yes, it does display 2 dec. digits but in Des Table ONLY !! The "Properties" and the drawing note still get 15 dec places
I got it working by puting in the "final" column a function:
= ROUND (F3,2)
where column F is the "intermediate" column.
Thanks everybody !!
RE: kg ----> lb
I just discovered that the Design Table does NOT get up-dated when doing CTRL-Q and has to be done "manually" that is Edit Design Table.
Am I correct ??
RE: kg ----> lb
Hopefully someone will be able to find it & repost or suggest a better alternative.
Helpful SW websites FAQ559-520
How to get answers to your SW questions FAQ559-1091
RE: kg ----> lb
RE: kg ----> lb
Have a great weekend.
Helpful SW websites FAQ559-520
How to get answers to your SW questions FAQ559-1091
RE: kg ----> lb
"Wildfires are dangerous, hard to control, and economically catastrophic."
Ben Loosli
Sr IS Technologist
L-3 Communications
RE: kg ----> lb
Does anyone know if it is possible to tell the Design table what units of mass are being used in the part, so that regardless of the unit used, the weight on drawing will be correct?
RE: kg ----> lb
You will have to set the models mass property to suit the UoM.
i.e. Weight-lb or Weight-kg being the "driving" property.
The models mass property will then populate the DT, be used in the conversion formula and then populate the alternative weight property of the model.
You will also have to adjust the conversion (lb to kg or kg to lb) in the DT accordingly.
Helpful SW websites FAQ559-520
How to get answers to your SW questions FAQ559-1091
RE: kg ----> lb
RE: kg ----> lb
Helpful SW websites FAQ559-520
How to get answers to your SW questions FAQ559-1091
RE: kg ----> lb
RE: kg ----> lb
Found out there is no need for an "intermediate" collumn - to get from kg ---> lb the following will do:
=ROUND((C3*2.2),0)
where collumn C is $PRP@Weight_kg. The 0 (or 1, or 2 ...) is the number od decimal places one wants to have displayed in the dwg note.