Nurbs vs Polygon Area in VW Worksheer different? or not?

[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 (18m² 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

[Pat Stanford]

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

[matteoluigi]

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…

[Pat Stanford]

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.