matteoluigi Posted May 2 Share Posted May 2 Hi, I attached a file with surfaces which I did extract from a 3D geometry. First I drew polygons with automatic allignment on the geometry, then I did extract Nurbs Surfaces from the geometry. Then I named the objects with numbers. XX-a for a polygon, XX-b for a Nurbs Surface and read the surface from all objects in a worksheet. as you can see, I attached the original VW file and an excel-sheet (exported from Vetorworks) The area sum of all polygons and all nurbs-areas in Vectorworks is completely different (18m2 difference) The sum of all Nurbs-areas and all Polygons seems to be the same, when done in Excel. Can anybody imagine where the difference might come from? (the solid original is also included in the drawing) Nurbs vs Polygon.xlsx Nurbs vs Polygon.vwx Quote Link to comment
0 Pat Stanford Posted May 5 Share Posted May 5 The NO values in the D column are being counted as 1 in the VW version. Change your formula to put the NO or blank in a separate column and it will total correctly. Or manually subtract NO from the total 1 Quote Link to comment
0 matteoluigi Posted May 5 Author Share Posted May 5 You’re joking? you mean, VW counts the numeric area of all polygons and adds the number of them? Whyy? Normally it should be either the sum of all areas or the number of all polygons, not both… strange worksheet… Quote Link to comment
0 Pat Stanford Posted May 5 Share Posted May 5 The "Value" of a non-blank cell in a VW Spreadsheet is either 1 if it is a non-numeric value or it is the numeric value. When you SUM those values, the non-numeric "1"s get added into the total. That is why you can use COUNT on non-numeric values. 1 Quote Link to comment
Question
matteoluigi
Hi,
I attached a file with surfaces which I did extract from a 3D geometry.
First I drew polygons with automatic allignment on the geometry,
then I did extract Nurbs Surfaces from the geometry.
Then I named the objects with numbers.
XX-a for a polygon, XX-b for a Nurbs Surface and read the surface from all objects in a worksheet.
as you can see, I attached the original VW file and an excel-sheet (exported from Vetorworks)
The area sum of all polygons and all nurbs-areas in Vectorworks is completely different (18m2 difference)
The sum of all Nurbs-areas and all Polygons seems to be the same, when done in Excel.
Can anybody imagine where the difference might come from?
(the solid original is also included in the drawing)
Nurbs vs Polygon.xlsx Nurbs vs Polygon.vwx
Link to comment
3 answers to this question
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.