Friday, April 1, 2005

AutoCAD 2006 and formulas in fields, tables and the calculator

A great addition is formulas that can be used in fields, tables and the calculator. The question is what functions can be used? I've searched the documentation and found that the QuickCalc Calculator, CAL supports some standard numeric functions. Here is the list: abs,acos,asin,atan,cos,d2r,exp,exp10,ln,log,pi,r2d,round,sin,sqr,sqrt,tang,trunc as well as these operators: ^,*,/,+,-,(,). Even though it's not specifically documented these functions and operators can be used in formulas in fields and tables. When checking further on the formulas in fields I found that when you are editing a formula you can insert new fields. In the sample showed on the image I've grabbed the length of a line and rounded it to the nearest value that is a multiple of 5.

3 comments:

  1. JTB WorldAugust 02, 2008

    Restored comments

    Anonymous said...

    This is neat. I s there a way to round UP to the nearest value? Ie, parking spaces are based on sq ft. If I have 750 Sq Ft I need to divide that by 300 to get the required 3 parking spaces

    Please respond to
    skemp@eeis.net
    January 17, 2006
    JTB World said...

    round(750/300) should do it
    January 18, 2006
    JTB World said...

    round(750/300+0.5) is more correct
    round(750/300+0.5) gives 3
    round(725/300+0.5) also gives 3

    /Jimmy
    January 19, 2006
    Anonymous said...

    I want to round UP to the next highest 50, how would I do that? Please respond to cmwade77@gmail.com
    March 28, 2006
    JTB World said...

    I'm not sure if you can correctly round UP to next 50 like the Excel function CEILING. Might be possible combining ROUND and TRUNC somehow.
    March 29, 2006
    Anonymous said...

    Hi,

    Is it possible to use an if statement in the field expression. Such aa this; if steel is 2X2 *1.5 if 3X3 *2.0 etc. I use diff. rebar with diff. wts.

    Bill
    May 23, 2008
    JTB World said...

    "if" statements are unfortunately not supported.
    May 23, 2008
    JTB World said...

    If you want to round up a positive value to nearest integer it can be done using
    trunc(value+0.999999999999999)
    Example:
    10 is still 10
    10.01 or 10.99 is rounded up to 11
    June 18, 2008

    ReplyDelete
  2. StyphelusOctober 19, 2010

    So how would I make my pipe label round to the nearest the nearest 0.5?

    FOr example, if my pipe is 50.3m, it will read 50.5m and if it's 50.8m it will become 51.0m?

    ReplyDelete
  3. Hejazi.WNovember 13, 2019

    To round UP a number ("A" for example) to (5) you can use this formula:
    Round((A+2)/5)*5

    and Up to (0.5) you can use:
    Round((A+0.2)/0.5)*0.5

    Basically You can use This Formula to round Up to nearest (d):
    Round((A+0.4d)/d)*d

    ReplyDelete