Jump to content

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

Link to comment

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

Link to comment
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

Link to comment
  • 3 weeks later...
  • 5 years later...
On 1/31/2019 at 12:57 AM, Robert Janiak said:

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

Hi, I am new to Vectorworks, how did you put the kg?

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.

Guest
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...