Jump to content
Sign in to follow this  
MattG

Worksheet Rounding

Recommended Posts

I am trying to figure out the best way to round a value in a worksheet. I have a worksheet I have generated that creates a list of symbols with a given record and displays the fields I want in the order I want. I have two columns one labeled "=(xcoordinate)" and "=(ycoordinate)".

I typically like to have my units set to Feet and Inches with a precision of 1/8" or 1/16" of a inch. Now the exception is in this report I like to have it round to the nearest inch. I do not want fractional values in the document. My initial thought was to change my database header to "=round(xcoordinate)" & "=round(ycoordinate)". However this is rounding to the nearest foot.

My question after all of this is what do I need to put in my equation to have my values appear as rounded to the nearest inch without changing my units to have a precision lacking fractions.

Thanks,

Matt

Share this post


Link to post

Matt

I played around with this a while ago and wasn't able to come up with a great solution. (There's probably a simple solution that eludes me.)

This gets close:

=CONCAT(XCOORDINATE DIV 1, '''', ' ', ROUND(SQRT(((XCOORDINATE-(XCOORDINATE DIV 1))*12)*((XCOORDINATE-(XCOORDINATE DIV 1))*12))), '"')

It fails in two circumstances:

1. If the coordinate is between -1' and 0 it gives a positive value instead of negative.

2. If the coordinate is between x' 11 1/2" and( x+1)' it returns x' 12"

It's probably possible to If/Then around those cases, but I gave up.

example attached.

MK

Share this post


Link to post

This has been an issue I have had for some time. There should be a round up and round down with the ability to set rounding points.

Share this post


Link to post

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.

Sign in to follow this  

 

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.

×
×
  • Create New...