David Dauphin Posted January 25, 2019 Share Posted January 25, 2019 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 : Worksheet with symbol truss and total length good result : Quote Link to comment
Sam Jones Posted January 26, 2019 Share Posted January 26, 2019 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. Quote Link to comment
David Dauphin Posted January 27, 2019 Author Share Posted January 27, 2019 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. Hi Sam, here is my file. I'm working with metric length and VWX 2019 french version :Trusses-worksheet.vwx Quote Link to comment
David Dauphin Posted January 30, 2019 Author Share Posted January 30, 2019 @Sam Jones Hi Sam, Have you test my file? may I have yours to compare it whith mine? Thanks. Quote Link to comment
Robert Janiak Posted January 30, 2019 Share Posted January 30, 2019 @David Dauphin I have no pc right now but try =VALUE() function. May be this is a text field. Quote Link to comment
Sam Jones Posted January 30, 2019 Share Posted January 30, 2019 David, I threw that example away, but I made another one. However, I opened your file, and I saw what you see which is very strange. My file is attached here. Truss Length Sum Test.vwx Quote Link to comment
Robert Janiak Posted January 30, 2019 Share Posted January 30, 2019 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? Trusses-worksheet-sv.vwx Quote Link to comment
David Dauphin Posted January 31, 2019 Author Share Posted January 31, 2019 @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. Quote Link to comment
David Dauphin Posted January 31, 2019 Author Share Posted January 31, 2019 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 : Quote Link to comment
Robert Janiak Posted January 31, 2019 Share Posted January 31, 2019 @David Dauphin I have no idea how do that. I am looking answer too. It is very strange that lenght have no suffix even if enabled in unit setup. Quote Link to comment
Robert Janiak Posted February 1, 2019 Share Posted February 1, 2019 @David Dauphin I found it. You sould set unit and show unit mark in Unit dialog box then set Dimmension cell format in worksheet. 1 Quote Link to comment
David Dauphin Posted February 5, 2019 Author Share Posted February 5, 2019 @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. Quote Link to comment
John Paul Szczepanski Posted February 21, 2019 Share Posted February 21, 2019 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. Quote Link to comment
Regie Posted March 20 Share Posted March 20 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? Trusses-worksheet-sv.vwx Hi, I am new to Vectorworks, how did you put the kg? Quote Link to comment
Recommended Posts
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.