Lucio Liberi Posted November 14, 2014 Share Posted November 14, 2014 Hello! I'm user since Minicad 4.5... and I'm stil waiting to read the Xtrd value in a worksheet. My problem is that I have a large # of extruded beams (wood beams) and I need to compute them, by extrude value. Someone could help me, please? Thank you L. PS I've tried using =Volume/Area, but sometime it failed... Quote Link to comment
michaelk Posted November 15, 2014 Share Posted November 15, 2014 (edited) You're on the right track. The worksheet can call the volume, but it doesn't have a call to get the area of the profile object of the extrude. So the call is =volume / (area of profile of extrude) In the attached example I added fields for the nominal dimensions of the beam and called those cells to get the area. If you don't want to see those fields you can make them white text on a white background or put them in a row or column with a 0 height or width. hth mk ps excuse the confusing math to convert inches to feet! Edited November 15, 2014 by michaelk Quote Link to comment
michaelk Posted November 15, 2014 Share Posted November 15, 2014 There's another thread about if/then statements. It occurs to me that you could hard code an if/then statement to do the math. Here's an example that mixes all the beams in one database and uses an if/then statement to apply different math to each class. hth mk Quote Link to comment
Lucio Liberi Posted November 17, 2014 Author Share Posted November 17, 2014 Thank you michael k! You have been so kind and 'clear' to explain your solution. But, as I wrote, it's almost 20 years, I ask to Nemetscheck that we be given the opportunity to read DIRECTLY the extrude value, that is a NATIVE value, editable in obj info palette. I love Vectorworks, but I have to say that's a very stupid issue and I (we) need it could be fixed! It's stupid that in 2014 (as year) or, if you prefer, in 2015 release I have to write by hand the proper dimension of a prismatic solid. Now, I understood why a space shuttle can explode because of a 5cent o-ring... I hope that Nemetscheck will forgive me for hard words, but it's because I LOVE Vectorworks and I'd want it near to perfection... :-) and because I use to say what I think! Thank you again! L. Quote Link to comment
Lucio Liberi Posted November 17, 2014 Author Share Posted November 17, 2014 Here's what I mean... L. https://dl.dropboxusercontent.com/u/24199273/what_I_mean.jpg Quote Link to comment
Lucio Liberi Posted November 17, 2014 Author Share Posted November 17, 2014 (edited) Here's a very, very simple steel frame I need to compute... https://dl.dropboxusercontent.com/u/24199273/Tav.pdf I'd like to compute the total length of each type (HEA, IPE...) Today, in 2014 (2015 release) I simply CAN'T !!! L. The file: https://dl.dropboxusercontent.com/u/24199273/SteelFrame.vwx What I mean... https://dl.dropboxusercontent.com/u/24199273/%234.jpg Edited November 17, 2014 by Lucio Liberi Quote Link to comment
Lucio Liberi Posted November 17, 2014 Author Share Posted November 17, 2014 (edited) https://dl.dropboxusercontent.com/u/24199273/%234.jpg I don't know why this link is inactive... Please, copy it and paste into your browser... Thank you As you can see, that the extrude value is 450 (cm) but in the report, I get 4499,915(mm). Why? L. Edited November 17, 2014 by Lucio Liberi Quote Link to comment
Miguel Barrera Posted November 17, 2014 Share Posted November 17, 2014 Because the internal units are mm even when the display units are cm. 1 cm = 10 mm so just divide the result by 10, which would give you 449.9915 and rounded up is 450 cm. Quote Link to comment
Lucio Liberi Posted November 17, 2014 Author Share Posted November 17, 2014 No, Miguel, units are no matter! I multiply to 1000 (units for volume and area are in sqm) because the steel workers wants unit in mm... The question is: if I did extrude a shape for 450 cm, why I get 499,9915? I know, I can round up, but why? I have no words! Anyway, thank you for your reply! :-) L. Quote Link to comment
Miguel Barrera Posted November 17, 2014 Share Posted November 17, 2014 I multiply to 1000 (units for volume and area are in sqm) That is exactly what I am talking about. Your display units may be cubic & square meters but internally, it is calculated as cubic & square millimeters. So volume/area will give you linear millimeters, and in your case it is 4500 mm = 450 cm. Quote Link to comment
Lucio Liberi Posted November 17, 2014 Author Share Posted November 17, 2014 Ok, Miguel... What I want to say is that I expect to read 4500, instead 4499,9915... Just because I performed an extrusion of 450 cm!, Not 449,99.... So, it does means that the internal precision is an opinion! :-) I wrote 450, but I get 449,... It doesn't make sense! What I see is that the function of spreadsheet are the same since 1992! Can you imagine? At that time, I was working on a 68k motorola Mac... So, it seems that time is never pass! Anyway, what I'd like is to read the xtrd valute. Just a value that is LIVING on the database of VW: I'm not asking about some else, but just for a value that already EXIST! As, length for lines... and so on... Have a nice day, Miguel! :-) L. Quote Link to comment
michaelk Posted November 18, 2014 Share Posted November 18, 2014 the opportunity to read DIRECTLY the extrude value, that is a NATIVE value, editable in obj info palette. I agree. I would like to see ANYTHING in the OIP or in any 'Settings' dialog box reportable and editable in worksheets. That includes, layer, class, delta x, delta y, rotation, line weight, line and fill color, X/Y/Z coordinates, etc. As well as the extrude value and, in EAPs, the length of the nurbs curve object. mk Quote Link to comment
Lucio Liberi Posted November 19, 2014 Author Share Posted November 19, 2014 Oh! Finally! Someone who understand me!!! Now, I feel better! :-) Thank you Michael!!! L. Quote Link to comment
Lucio Liberi Posted February 15, 2016 Author Share Posted February 15, 2016 ...no words... We speak about BIM, but not about extrude... that's ridiculous! L. 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.