Jump to content
  • Sign in to follow this  

    Calculating Area of Spaces in Worksheets

    PVA - Jim

    When you are normally looking to calculate the area of an object, you can use the Area function (=area()). This will give you the area (Length x width) in the basic drawing unit of your document. So if the document in is inches, and you have a 10’ x10’ square, the worksheet will return 14400 or 14,400 Sq Inches. If you would like square feet, simply divide by 144 (12”x12”) to get 100 Sq Ft.


    Now this works for simple objects, but the space object is different, and you must use a different function.  The correct Space area function is: =('Space'.'11_Gross Area'). You can also get this from the Criteria wizard.  


    Click the small down arrow in the upper left side of the worksheet window. Then click Paste Criteria, and select the following values.


    Other popular functions:

    • Space Number
      • =('Space'.'11_Number')
    • Space Name
      • =('Space'.'11_Name')
    • Proposed Area for Space (Value entered by user)
      • =('Space'.'11_Proposed Area')

    Edited by JimW

      Report Article
    Sign in to follow this  

    User Feedback

    There are no comments to display.

    Create an account or sign in to comment

    You need to be a member in order to leave a comment

    Create an account

    Sign up for a new account in our community. It's easy!

    Register a new account

    Sign in

    Already have an account? Sign in here.

    Sign In Now


7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114


© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.