Jump to content

Space - Rounding a formula


Recommended Posts

Hi

I'm trying to get to grips with the space tool and would like to use it to display both sqm area and the sq ft area. The only way I can think to do this is to use a formula in the additional data section.

I have successfully managed to get it to calculate the area using the formula:

=(#Net Area#*10.7639)

but I was hoping to round the figure up to the nearest whole foot. I have tried using the vectorworks function =round(#Net Area#*10.7639) but have been unsuccessful.

Is anyone able to help me with the correct formula? Or is there a better way to accomplish my needs?

Many thanks!

Link to comment

Face, I can get what you want in a worksheet. Just use the formula:

=(('Space'.'Area')/10.7639)

to get the metric equivalent of the area.

On the other hand, I can't get even your formula (=(#Net Area#*10.7639)) in the Additional Data area to give me anything more than the same text back. How did you do that? Are you getting this Additional Data on your Space Label at all?

If the 'round' function is anything like Excel, it has to be given the desire degree of rounding desired as in round(cell_location,-2). The -2 indicates that you want the number to round up to hundreds, if I remember correctly.

Link to comment

Thanks for your help Mitch & Michael

You are correct Mitch: "You are trying to get both imperial and metric areas showing on the spaces' labels, i.e. on your floor plan, and in a worksheet, right?"

However I work in the UK so I work in metres for area but my client is from pre-metric days so prefers to work in feet.

This is a screenshot of what I did to get the space label to show both measurements: https://dl.dropboxusercontent.com/u/17200339/spaces.jpg You can see the space labels in the background.

Mitch, I thought the same about the round function too but the VW's help doesn't mention anything about specifying the degree the number needs to round to:

"round(number)- Rounds the specified number to the nearest whole number - =round(D11)

(returns the value in cell D11 rounded to the nearest whole number)"

Michael, thanks for the pointer for the other thread. My metre dimensions are working fine to whole metres as I've set that in the document preferences. The problem I think is that my feet are done using a formula so VW doesn't recognise them as a dimension unit and therefore doesn't round them off.

I'd also like to roll this out across the whole office so don't really want to rely on a script which needs to be recalculated each time.

Link to comment
  • 10 months later...

Hello,

I know this thread has been inactive for a while, but I have a question about this space tool. First of all I do not see a "space tool" under my space planning toolset. I have a Raum Tool CW which whenever I try to use pops up this message;

"error occurred while opening plug-in. Make sure that there is a "Plug-ins" folder in the same folder as the application."

The Raum Tool shows up as a .vwr document rather than as a .vso like other vectorworks plug-in objects in the VectorWorks file directory. Not sure if that is related but it's a piece of information.

Other than that, how can I turn a rectangle or a polyline into a space object I guess? I'm using this particular file in 2D.

Thank you very much.

Edited by sle7en7
Link to comment
  • Vectorworks, Inc Employee

With a polygonal object selected, you should be able to use Modify > Convert > Create Objects from Shapes. Some other workspaces have it listed under AEC > Create objects from shapes (or Landmark> or Spotlight>)

You should be able to add the Space tool back to the workspace via the workspace editor, unless you have a localized copy that does not include it:

http://kbase.vectorworks.net/questions/745/Workspace+Editor

(I do not know if any localized versions omit the Space tool by default.)

Link to comment

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.

Guest
Reply to this topic...

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