Lighting Pipe Weight Record

[Chris J Clarke]

I'm trying to get a Worksheet to total up the weight of my Lighting Pipes in a Drawing. I'm using the VW Spotlight Lighting Pipe Tool to vreate the pipes. (S235 Construction Material)

 

In the Worksheet shown in the image, it's seeing the different length pipes, and reporting the weight per pipe, but my total box isn't working. @Pat Stanford helped me create a String to try and extract the number only from the weight record of the pipe, as we suspect that record is held as text rather than a number, but it still won't report the total weight of that length of pipe. Does anyone know where the record is that stores that weight please? I can then look and see how that figure is being stored. You can see the formula string I'm using to try and extract the number only in the Worksheet image. I may well be misunderstanding how that is done too.

 

@markdd I bet this is somehting you might know?

[Pat Stanford]

Your need to move the *A2 to outside the Value command.

 

You have to convert the string to a number before you can do the multiplication.

 

=A2*Value(Substring(D2, 'k', 1))

 

[Chris J Clarke]

I tried that, but it changes it back to 

 

=VALUE(A2*SUBSTRING(D2, 'k', 1))

 

as soon as I press Enter.

[Pat Stanford]

Try and split it into two different columns.

 

Set Column E to =Value(Substring(D2, 'k', 1))

Set Column F to  A2*E2

 

Or post or DM me the file so I can take a look at what is happening.

[Pat Stanford]

=VALUE(SUBSTRING(D2, 'k', 1))*A2

works for me to do the conversion and the math.

 

There is also a hidden field ('Lighting Pipe'.'Weight') in the record that returns the weight of the pipe in grams as a number. You could use that and just do the conversion math.

 

Also, some parts of the world you must us a semicolon instead of a comma as the parameter separators in worksheet formulas. This is in areas that use the comma as the character for the decimal point.

HTH

[Chris J Clarke]

Thank you so much Pat, that's all working brilliantly now. Exactly what I wanted it to do.

 

I've save the file you edited somewhere safe, so in the event that I mess it up again, I have a working copy.

 

Thanks so much.