Page 18 of 26 FirstFirst ... 8141516171819202122 ... LastLast
Results 171 to 180 of 257
Like Tree72Likes

Thread: Revit Formulas for "everyday" usage

  1. #171
    Moderator
    "Mark Twain"
    mdradvies's Avatar
    Join Date
    December 16, 2010
    Location
    Boxtel, Netherlands
    Posts
    4,552
    Current Local Time
    04:46 AM
    Quote Originally Posted by ekkonap View Post
    Attachment 8467

    tested?

    Again, any improvement is a bonus, by all means keep trying. I just can't replicate your result.
    Well, that's weird. Me neither... I must have done something wrong in my initial test.

  2. #172
    Senior Member alexo4141's Avatar
    Join Date
    May 25, 2011
    Location
    Québec, Canada
    Posts
    536
    Current Local Time
    12:46 AM
    Ok, this is something that I already posted in another post but I thought it could be useful for somebody else... This i a way to round an array integer without using the "round [up or down]" function that is only available from 2012 version.

    Quote Originally Posted by me in the original thread View Post
    Imagine you want a max. spacing of 36" and that you use that formula : (Array length / 36") + 1
    If you have 37", you'll get 2 (which is the not right answer)

    By adding 1.49, Revit will round it up if it's not an exact number.
    37/36=1.03
    1.03+1.49=2.52
    Revit rounds up to 3

    If the number you are dividing is exact, Revit will automatically round it down.
    72/36=2
    2+1.49=3.49
    Revit rounds it down to 3 because it stills under the 0.5 rounding limit.

    Hope it makes sense...
    A formula to round an integer for an array quantity could now be read this way:
    (Array length / 36") + 1.49
    Last edited by alexo4141; June 21st, 2012 at 03:43 PM.

  3. #173
    Forum Co-Founder Alfredo Medina's Avatar
    Join Date
    December 7, 2010
    Location
    Miami, FL, USA | info@planta1.com
    Posts
    1,925
    Current Local Time
    12:46 AM
    I thought this would be a useful addition to this thread on formulas. This applies to titleblock families:

    Creating any 'A' sheet standard size by formula

    Parameters:

    X = horizontal side of the sheet; length parameter
    Y = vertical side of the sheet; length parameter
    A# = number of the 'A' size sheet. This parameter drives the height and width dimensions of the sheet; integer parameter.

    Formulas:

    X = Y / sqrt(2)
    Y = 841 mm / sqrt(2) ^ (A# - 1)

    Usage:

    In a titleblock family, set the length units to millimeters. Create the 3 parameters, X,Y, and A#. Set the width of the titleblock to the X parameter. Set the height of the titleblock to the Y parameter. Now simply change the value of the integer parameter to obtain any 'A' size. It is not necessary to know in advance all the different sizes for the "A" sheet system. The formula will do that. The integer number matches the number of the "A" standard size. For example: you need a A1 size, then set the integer to 1. Since the value of the integer matches the name of the sheet size, its value can be used to drive other parameters in the family. See illustration.

    Other ISO series

    With a small variation in the formula for "Y", the same math works for obtaining all the sheet sizes of the B and C series, like this:

    Series name
    Y =
    A Series 841 mm / sqrt(2) ^ (A# - 1)
    B Series 1000 mm / sqrt(2) ^ (A# - 1)
    C Series 917 mm / sqrt(2) ^ (A# - 1)
    Attached Thumbnails Attached Thumbnails Revit Formulas for "everyday" usage-a_sizes_formula.jpg  
    Last edited by Alfredo Medina; August 8th, 2012 at 05:02 PM. Reason: Added series B and C

  4. #174
    Moderator snowyweston's Avatar
    Join Date
    December 21, 2010
    Location
    C.LONDON
    Posts
    2,345
    Current Local Time
    05:46 AM
    Welcome to the forum Martin, since you will have better luck posting this in the open forum I moved your post HERE.
    Last edited by snowyweston; August 8th, 2012 at 09:10 AM.

  5. #175
    Member ekkonap's Avatar
    Join Date
    May 23, 2011
    Location
    Netherlands
    Posts
    317
    Current Local Time
    06:46 AM
    Quote Originally Posted by Alfredo Medina View Post
    I thought this would be a useful addition to this thread on formulas. This applies to titleblock families:

    Creating any 'A' sheet standard size by formula

    Parameters:

    X = horizontal side of the sheet; length parameter
    Y = vertical side of the sheet; length parameter
    A# = number of the 'A' size sheet. This parameter drives the height and width dimensions of the sheet; integer parameter.

    Formulas:

    X = Y / sqrt(2)
    Y = 841 mm / sqrt(2) ^ (A# - 1)
    The thing is, once ISO comes to town, math goes out the window. Compare the following formula and its results with the table in Paper size - Wikipedia, the free encyclopedia

    X = round(1000/(2^(1/4+1/2*A#)))
    Y = round(1000*(2^(1/4-1/2*A#))) edit (sorry about that)

    A1 and A2 differ.
    Last edited by ekkonap; August 8th, 2012 at 05:53 PM.

  6. #176
    Forum Co-Founder Alfredo Medina's Avatar
    Join Date
    December 7, 2010
    Location
    Miami, FL, USA | info@planta1.com
    Posts
    1,925
    Current Local Time
    12:46 AM
    Quote Originally Posted by ekkonap View Post
    The thing is, once ISO comes to town, math goes out the window. Compare the following formula and its results with the table in Paper size - Wikipedia, the free encyclopedia

    X = round(1000/(2^(1/4+1/2*A#)))
    Y = round(1000/(2^(1/4-1/2*A#)))

    A1 and A2 differ.
    Ekko, if you refer to differences such as "594.7" different from "594", well, that is because the official ISO "A" list simply dropped the decimals, instead of rounding up or down in a consistent way, like the "round" formula in Revit does. But even like that, the results obtained by the formulas that I posted above comply with the standard, because the standards allow some tolerances in the range of 1.5 to 3 mm. depending on the size of the sheet. In this case, the differences between the results of the formula and the official rounded value are all of them less than one millimeter.

    By the way, I did not understand how to use the formulas that you posted. It gives me the correct size for X, but not for Y.

  7. #177
    Member ekkonap's Avatar
    Join Date
    May 23, 2011
    Location
    Netherlands
    Posts
    317
    Current Local Time
    06:46 AM
    Alfredo, the values obtained are indeed well within the tolerances, but that is not what tolerances are for IMO. If you're doing it by math ,why settle for tolerances? I did not know what caused the difference. Are you sure about dropping the last digit? That would result in 840 in stead of 841.

    Sorry, formula edited. Zigged when I should have zagged.

    dropping the last digit...

    value - (value - rounddown(value))

    Anyway, a little tweaking does the trick:
    X=rounddown(1000.3/(2^(1/4+1/2*A#)))
    Y=rounddown(1000.3*(2^(1/4-1/2*A#)))
    that'll go straight into my next titleblock, tnx Alf!

    Who knows, maybe the square meter was measured on a hot summer day. There's bound to be a story behind this.
    Last edited by ekkonap; August 8th, 2012 at 06:42 PM.

  8. #178
    Forum Co-Founder Alfredo Medina's Avatar
    Join Date
    December 7, 2010
    Location
    Miami, FL, USA | info@planta1.com
    Posts
    1,925
    Current Local Time
    12:46 AM
    Quote Originally Posted by ekkonap View Post
    • If you're doing it by math ,why settle for tolerances?
    • I did not know what caused the difference. Are you sure about dropping the last digit? That would result in 840 in stead of 841.
    • Well, to keep the formulas simple.
    • No, I was not referring to dropping the last integer, but dropping any decimals and keeping the integers exactly as they are. I see that it might be possible to fix it with "rounddown" but I prefer to keep the formulas simple, as shown above; that gives the integer portion of the sizes exactly as they are listed in the official ISO series A,B, and C.
    Last edited by Alfredo Medina; August 9th, 2012 at 02:50 AM.

  9. #179
    Member AHutchinson's Avatar
    Join Date
    September 19, 2011
    Location
    Spokane, WA
    Posts
    229
    Current Local Time
    09:46 PM
    Hey Guys! I was wondering if someone has figured up a way to return a string of text to relate a dimension to block module yet.

    I'd like to have a parameter that says "Module" or "NOT" to make it easier on myself. I've figured out something that will work but it's time intensive and doesn't work totally parametric. See below. Please help!

    Revit Formulas for "everyday" usage-capture.jpg

    After I wrote this up, I tried another way, and made it work. Posting the result if anyone wants to see it.

    Revit Formulas for "everyday" usage-capture1.jpg

    I used a Number parameter for Calc, and an Integer parameter for CALC. The number will only be an integer if it is module, therefore CMU Module will return a desired result, whereas when it's a decimal it wont be the same, thus the NOT...
    Last edited by AHutchinson; September 7th, 2012 at 11:26 PM.

  10. #180
    New Member
    Join Date
    February 14, 2012
    Posts
    1
    Current Local Time
    05:46 AM
    I'm having trouble implementing an 'if' formula in my window schedule.

    I have a yes/no parameter in the schedule for a roller blind. This feature affects the S.O height, so i want to report the So.Height based on this yes/no parameter.

    i have tried using
    if(C = yes, A, B)

    C is a yes/no parameter
    A and B are a length parameter

    I get an error saying that 'yes' is not a valid schedule.

    Do the parameters need to be shared? i would have thought not as it is just calculating something from the schedule....

    Any ideas?

    Thanks in advance....

LinkBacks (?)

  1. February 28th, 2012, 03:07 PM
  2. January 10th, 2012, 01:31 PM
  3. January 2nd, 2012, 06:57 PM
  4. December 2nd, 2011, 11:31 AM
  5. November 4th, 2011, 08:59 AM

Similar Threads

  1. Fórmulas de Revit para el "uso diario"
    By Munkholm in forum Foro Español
    Replies: 8
    Last Post: June 7th, 2011, 11:43 AM
  2. Slab slope discrepancy btw "Slope arrow" and "Define Slope"
    By jh75 in forum Structure - General Questions
    Replies: 3
    Last Post: May 6th, 2011, 08:39 PM
  3. Revit 2011 - "Black rendering" with Non-English Win XP
    By Munkholm in forum Tutorials, Tips & Tricks
    Replies: 0
    Last Post: January 10th, 2011, 08:15 AM
  4. Replies: 2
    Last Post: January 7th, 2011, 06:19 PM
  5. Replies: 2
    Last Post: January 7th, 2011, 06:19 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •