Jump to content

Fixture Weight Field drop the lbs? - Worksheets


Recommended Posts

I have been okay doing this in the past but am noticing an issue now in 2021 but unfortunately have not been doing as much lighting in VW these days with the pandemic.  


It appears I am having trouble dropping the "lbs" from the fixture weight in a worksheet that pulls the data from the lighting device criteria.  


I used to be able to do =Value() and it would bring back the number, and my secret if I wanted it there was that I could then just put the lbs in the cell formatting as a suffix, but everything I have tried seems to be unable to dump the lbs suffix off that. 


Any help is appreciated.

I feel like @Pat Stanford has probably already solved this...... 🤣🤣




Link to comment

=Value(Substring(XXXX,YYYY,1) is your friend.


XXXX is the string value that includes the Lbs.

YYY is what separates the number from the Lbs. In this case a space (' '   Single quote, space character, single quote)

1 is that you want the first piece of the substring.


Also, check and see if there is not a different field that returns the value as a number instead of giving your the string formatted with the units.


On deadline now. I will double check this later if I don't see you post that it worked.  


This is from memory, so it may be wrong.  Do a search for post from me that include Substring and you should find what you need.




  • Like 1
Link to comment

Man this program drives me nuts sometimes.  Thanks!


I did a dummy report with every field hoping to find the secret field that may store the units but no luck.  Just really odd.  I do that using some of the braceworks stuff to make custom things manipulating that data, but it seems really odd that is a hard value.


Either way for now that works.  


Thanks as always.



Link to comment
2 hours ago, Pat Stanford said:

Submit a wish to have an alternate field added that is the numeric version of whatever the Styled Text output is. 


I think I did that for Doors and Windows a few years ago.


I think I requested if for all PIOs, but obviously that has not happened yet.


For lighting devices, you can get the field Weightdouble. It returns the weight in grams regardless of units, so you have to hard-code in the unit conversion in the formula.

  • Like 2
Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...