Forums >> Revit Building >> Technical Support >> Scheduling Issues - rounding up

bradleymatthew

active

Joined: Fri, Jul 21, 2006
59 Posts
No Rating

I have generated a schedule to determine the quantity of different items from their length.  For instance: a countertop can only come in 8' lengths - for sake of argument - and I have many different lengths and modeled quantities.  I tried simply creating a calculated formula that adds all lengths and divides by 8', but it's not accurate and won't round up.  I tried using the +.4999 on the end (so the formula is now: Length/8' +.499), but that really threw the counts off because of the number of small counters I have (my best guess is that it was adding the .499 to each object, cause my counts to nearly double).

What am i doing wrong.  I need to create this similar type of schedule for several other things and it has to be accurate - if not dead-on, then over by 1....never ever under.

-----------------------------------
Bradley

This user is offline

View Website

qthdad

active

Joined: Mon, Dec 10, 2007
64 Posts

You would probably need to be creative since there are only limited functions available in Revit for formula.

Here's one method that came to mind.

Create three PARAMETERS:

Actual_Length as Length

Length_Rounded_Up as Length

B as Integer

B = Actual_Length / 1'

Length_Rounded_Up = IF(B * 1' < Actual_Length, B * 1' + 1', B * 1')

Attached Images

This user is offline

bradleymatthew

active

Joined: Fri, Jul 21, 2006
59 Posts
No Rating

qthdad - what I'm really looking for is a quantity of the 8' counters.  I like your idea of creating a paramater that generates length as an integer - that at least lets me know what I'm working with, but it all goes funky when I start to generate quantities within the schedule.

I really could make this work if I could simply take the overall sum of the length of all counters and divide that by the 8' to get me a total quantity of counters, but Revit won't let me.....what am I missing?

-----------------------------------
Bradley

This user is offline

View Website

qthdad

active

Joined: Mon, Dec 10, 2007
64 Posts

You don't need to adding .499 to each object. That's probably what's throwing your numbers out of whack. You can probably take the "trick" I did and use it in a calculated field within the schedule that is based on the objects' actual length.

This user is offline

bradleymatthew

active

Joined: Fri, Jul 21, 2006
59 Posts
No Rating

-----------------------------------
Bradley

This user is offline

View Website

qthdad

active

Joined: Mon, Dec 10, 2007
64 Posts

So, you are saying this:

If Q < 1, then Q = 1

else just keep the current value (Q = Q) 

How about

Q = if(Quantity<1, Quantity +1, Quantity)

This user is offline

bradleymatthew

active

Joined: Fri, Jul 21, 2006
59 Posts
No Rating

Yes, exactly.  I gave that a whirl and I'm still getting higher #'s than I should.  Revit's applying that formula to each individual piece rather than the sum of all pieces, which throws my numbers off.  I think that right there is my problem - Revit cannot use the total sum of one parameter or calculated value in another calculated value - it applies the formula to each instance and THEN calculates the sum.....

If I know that a counter only come in 8' lengths, I know that I can use that one piece to make several small counters.  Traditional math would simply suggest that you add all the lengths together & divide by the known length (8') to find out how many 8' counters you would need to order.  This is different than what I'm trying to tell Revit to do - Revit is taking each small counter and trying to confirm if it fits the formula (Q = if(Quantity<1, Quantity +1, Quantity)).  If there is a piece that is under 1, it will add 1 (quantity being an 8' pieces of counter).  You can see how this will quickly throw the numbers completely off because Revit is adding (1) 8' counter for ever piece that's smaller than 1.

-----------------------------------
Bradley

This user is offline

View Website

Rounding in Formulas

4

Dimension Rounding

4

Area Tags - Rounding refuses to change

2

Rounding Issue in Schedules

3

Issues in Scheduling parts

10