Jump to content
David Dauphin

Total truss lenght in worksheet

Recommended Posts

Hello,

 

In my truss worksheet (with spotlight truss tool), I want to display total weight of the system, and total length. No problem for total weight, but the same formula can't calculate total length. The results are always the number of truss that have truss length record in database. And systematically, each row length field is followed by "mm". Perhaps, it is why sum can't be calculate?

If i build with symbols trusses instead of truss tool, there is no problem to calculate total length of system.

 

Worksheet with tool truss and error calculate total length :

924008801_tableau-truss-erreurtotallongueur.thumb.png.34167cd284f1d0fc3dbb305c0427fb65.png

 

Worksheet with symbol truss and total length good result :

1847001391_tableau-truss-erreurtotallongueurexsymbole.thumb.png.2171af99a094e8eb9f4bba64d54499d1.png

Share this post


Link to post

Can you post the files that have your worksheets?  I was able to make a simple worksheet database report of straight truss instances and sum the length column.

2118464667_ScreenShot2019-01-26at9_39_57AM.thumb.png.1a69ee10f0d9909a7ae5b8032b503e58.png

Share this post


Link to post
18 hours ago, Sam Jones said:

Can you post the files that have your worksheets?  I was able to make a simple worksheet database report of straight truss instances and sum the length column.

2118464667_ScreenShot2019-01-26at9_39_57AM.thumb.png.1a69ee10f0d9909a7ae5b8032b503e58.png

Hi Sam, here is my file. I'm working with metric length and VWX 2019 french version :Trusses-worksheet.vwx

Share this post


Link to post

I've done some tests.

 

first worksheet: I used in Lenght column database function =VALUE('Truss Record'.'Length'), but not fixed this problem

secound worksheet: I used in Lenght column database function ='TrussItem'.'Length', it fixed this problem

 

@David Dauphin Is this a solution for your problem? 

@Sam Jones Do you known difference between Truss Record and TrussItem?

 

852435265_Zrzutekranu(83).thumb.png.461effce739aa7e2fa0d96c363f3923d.png

 

 

Trusses-worksheet-sv.vwx

Share this post


Link to post
1 minute ago, David Dauphin said:

@Robert Janiak @Sam Jones thank you guys !

Yes Robert it solves my problem with 'trussitem' THANKS !!!

 

Me too I would like to know difference beetween TrussItem and Truss Record.

Another things :

Do you know how I can display my unit file after formula "=SOMME(G3)"

It's not good to add "suffix" because if unit changes then "suffix" you added don't change automatically.

It may be a field like FileUnit or something like that ? 

That's what I mean with "suffix" in a french version :

1444893356_Capturedcran2019-01-3110_33_47.thumb.png.fc255744d1e392bc71e9848073920595.png

Share this post


Link to post

@Robert Janiak Thanks Robert, yes this method is OK. But usually, I don't show unit mark in my drawings. That's why I would like to have function like 'UnitFile' in my worksheets. 

Share this post


Link to post

I named the truss in the truss creation dialogue but wish to count multiple instances with the same name. I am creating a quick rectangular truss grid over a studio. I dont want name each instance with a seperate name in the object info but want all truss created to be named Purple, then count just the instances of truss for Purple.

 

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

 

7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114

 

© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

×