# Worksheet, wall record, wall length..

## Recommended Posts

Is there a simple way to get a list of walls length and surface?

The wall record specify length and height but I did no how to make the real length of the wall to appear there automatically.

The purpose is to make a quantity list.

TIA

Udi Mann

You have a few choices for culling the herd:

Declarations as (T)Type = Wall , ©Class=Wall Class, (N)Name = Wall name,(S)Symbol=Wall Symbol, (L)layer= Wall layer, etc.. Often you need to use a combo of descriptors to get what you want.

Wall Class & Wall Layer followed by functions offer the best solution.

In all versions of VectorWorks, you can use the LENGTH() function to return the wall length in worksheets.

In VectorWorks 12, you additionally have the following functions for walls:

WALLAREA_GROSS -- returns the surface area of the wall center line

WALLAREA_NET -- returns the surface ares of the wall centerline, not including area of inserted symbols or objects

WALLAVERAGEHEIGHT -- returns the average height of the wall (this is the actual wall area taking into account "wall peaks" divided by the length of the wall).

WALLTHICKNESS, and

WALLSTYLENAME

Hi,

I start on this thread because the main "worksheet" thread turned out as a private discussion...eh eh

I am trying to use more and more worksheets, went ok with window/door schedule, using database headers and so on..

Then I intended to use some quantity report for roof and wall. However I can't understand what is calculated by the "WallArea_Gross", "WallArea_Net"...

Example:

I have a wall of 7.9m x 2.65m with two french door of 1.8m x 2.1 m

Area gross=7.9x2.65=20.935 sqm but VW value =23.427 sqm ???

Area Net=20.935 -(2x1.8x2.1) = 13.375 but VW value =18.095 sqm ???

I tried to work it out but it's just doesn't make sense to me,

Am I wasting my time using this worksheet, I need to order some building material shortly...

Both AreaGross and AreaNet will include the surfaces of the sides from walls and openings. Try using the formula VOLUME/WALLTHICKNESS, which will give the quantity I guess you're looking for.

but what with the openings??? calculate them manually? normally those commands have to work. try to reach you're result on different way's and compare those, that's the way i mostly find the error

WALLAREA_GROSS -- returns the surface area of the wall center line

WALLAREA_NET -- returns the surface ares of the wall centerline, not including area of inserted symbols or objects

So These definition are wrong, who knows the real definition of these codes ??

I tried the formula volume/wallthickness doesn't work.... the volume function returns me 0.00 for some wall (I think those one that have no opening..)

A real waste of time, I stopped digging...

Having access to only the Dutch version right now, my syntax may be wrong - in which case I apologize. So, VOLUME may be known as VOL in the US version ?

i tried some stuff about the walls and i found some stuff but let me tell you first about a bug in VW 11.5 that i found a year ago:

if you make a connection between 3 walls with an L and a T connection, the volume calculated in the worksheet gives you 0,000000000xxx. so that was the big problem in my calculation program i tried to make.

this problem is solved in VW 12, although there is still something wrong with it! that's what i found out now, so here it comes:

*if all your walls are not joined in any way, the result is correct.

*if you join walls from the same thickness in any way, the result is correct.

*if you join walls from different thickness in any way, the result is not the same. although the difference is minimal

so the fact is that there is no bug or a faulty thing in it.

it is just how those functions calculate. if you take the volume/thickness, you'll get the correct result. the functions like wallarea_gross etc. uses the center line of your wall, and if you look at the connection between walls, you'll notice that the end and begin points change when you make your connections. the worst is with a 3way join with walls of different thickness. so the minimal difference between the results of volume/thickness and wallarea_net is because of wallarea_net uses the center line from begin to endpoint.

i hope it's understandeble.

maybe you could send the file to me? then i can take a look at it?

Thanks very much for your time someonenamedlink, I have no time now, I will check on my side your analysis and when I get a chance I ll get back to you.

Cheers !

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

×   Pasted as rich text.   Restore formatting

Only 75 emoji are allowed.

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×