Jump to content
  • 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

    User Feedback

    There are no comments to display.

    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.

    Add a comment...

    ×   Pasted as rich text.   Restore formatting

      Only 75 emoji are allowed.

    ×   Your link has been automatically embedded.   Display as a link instead

    ×   Your previous content has been restored.   Clear editor

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

  • Create New...