Revit Architecture

Reply
Member
jverdugt
Posts: 3
Registered: ‎08-12-2008
Message 1 of 11 (1,119 Views)
Accepted Solution

Sorting in Revit Schedules

1119 Views, 10 Replies
12-09-2011 09:16 AM

I am wanting to sort by more than 4 parameters in a single schedule.  Revit 2012 only has 4 options.  Can more be added?

Thanks for the reply.  We were able to figure out a way to work around this to the accuracy we needed. 

*Expert Elite*
Alfredo_Medina
Posts: 2,856
Registered: ‎06-11-2009
Message 2 of 11 (1,111 Views)

Re: Sorting in Revit Schedules

12-09-2011 09:57 AM in reply to: jverdugt

No. Any more info on what you are trying to do?

-----------------------------------------------------------------------------------------------------------------
Planta1 Revit Online Consulting | info@planta1.com | my Twitter | The Planta1 Blog
Product Support
alan.quinn
Posts: 631
Registered: ‎09-08-2010
Message 3 of 11 (1,077 Views)

Re: Sorting in Revit Schedules

12-12-2011 10:29 AM in reply to: jverdugt

Just following up on Alfredo’s post. Without more information it’s impossible to make recommendations and/or suggestions.



Alan Quinn
Support Specialist
Product Support
Autodesk, Inc.
Member
jverdugt
Posts: 3
Registered: ‎08-12-2008
Message 4 of 11 (1,058 Views)

Re: Sorting in Revit Schedules

12-13-2011 01:41 PM in reply to: jverdugt

Thanks for the reply.  We were able to figure out a way to work around this to the accuracy we needed. 

Member
lena.v
Posts: 3
Registered: ‎11-12-2012
Message 5 of 11 (911 Views)

Re: Sorting in Revit Schedules

11-12-2012 08:02 AM in reply to: jverdugt


Hi, how did you solve this? We have the same problem.

 

We have a schedule listing window information, e.g. Window Type F01.

We sort our Schedule by:

Type Mark, then by:

SwingDirection, then by:

FireClass, then by:

SoundClass.

 

And we need to add by:

SecurityClass

 

But Revit has by default only 4 levels or sorting.

Any ideas how we can go about adding more sorting parameters?

 

Thanks,

Lena

*Expert Elite*
CADastrophe
Posts: 3,420
Registered: ‎08-28-2009
Message 6 of 11 (900 Views)

Re: Sorting in Revit Schedules

11-12-2012 08:53 AM in reply to: lena.v

I have accomplished this in the past by creating a Calculated Value that combined two of the fields for the purposes of establishing a sort order for our Light Fixture Schedule. I already had the top two "Sort Slots" used, so I had to combine LampWattage and LampQuantity (to be sorted in respective order) into a single sort. This is a rough summary of my scenario:

 

Name                  Type                       Units        

LampWattage     Parameter               Watts

LampQuantity     Parameter               Integer

LampSort            Calculated Value    Number

 

The formula for LampSort is: =(LampWattage / 1 W) + (LampQuantity / 100)

 

The above formula will combine the two to produce a number such as 32.03 (32W, 3-Lamp) or 54.01 (54W,1-Lamp), which allows for proper sorting.

 


 

As for your specific situation, I would assume that your Parameters "SwingDirection", "FireClass", and "SoundClass" are all Text Parameters, correct?

It may still be possible to combine them using this method, but could you elaborate on your parameters a little bit, specifically, are there a large number of possible values for these parameters? I'm thinking there are aren't many possibilities for "SwingDirection", but what about the other two?

Corey D.                                                                                                                  ADSK_Logo_EE_2013.png    AutoCAD 2014 User  Revit 2014 User
──────────────────────────────────────────────────────────────────────
⁞|⁞ Please use Mark Solutions!.Accept as Solution and Give Kudos!Give Kudos as appropriate to further enhance these forums. Thank you!
Member
lena.v
Posts: 3
Registered: ‎11-12-2012
Message 7 of 11 (892 Views)

Re: Sorting in Revit Schedules

11-12-2012 09:08 AM in reply to: CADastrophe

 

Great, that sounds like an idea!

 

You're right though, my parameters are texts.

 

Is it possible to combine two text strings to one?

 

 

*Expert Elite*
CADastrophe
Posts: 3,420
Registered: ‎08-28-2009
Message 8 of 11 (886 Views)

Re: Sorting in Revit Schedules

11-12-2012 09:34 AM in reply to: lena.v

Unfortunately, Revit is incapable of the simple task of combining text strings, which is responsible for the forehead-shaped damage to my desk. banghead.gif

 

Spoiler

My questions earlier about the number of possible values is important to this method - the more values, the more complicated it becomes. Example:

 

I want to combine BoxSize and BoxColor, which are both Text parameters. I would first have to create a Calculated Value for each of these that will convert the value to an Integer. Here is the formula for the respective Calculated Values:

 

BoxSizeSort = if(BoxSize = "Small", 1,if(BoxSize = "Medium", 2, 3))

BoxColorSort = if(BoxColor = "Blue", 1, if(BoxColor = "Green", 2, if(BoxColor = "Orange", 3, if(BoxColor = "Red", 4, 5)))

 

**The above formulas must include ALL possibilities, so if there are limitless options, then this is not possible.

 

Finally, a third Calculated Value is needed to combine the other two: BoxSort = BoxSizeSort + (BoxColorSort / 10)

Edit: Nevermind the above in the spoiler - I had forgotten that Revit does not allow a String to be used in a conditional statement... More banghead.gif

Corey D.                                                                                                                  ADSK_Logo_EE_2013.png    AutoCAD 2014 User  Revit 2014 User
──────────────────────────────────────────────────────────────────────
⁞|⁞ Please use Mark Solutions!.Accept as Solution and Give Kudos!Give Kudos as appropriate to further enhance these forums. Thank you!
Member
lena.v
Posts: 3
Registered: ‎11-12-2012
Message 9 of 11 (881 Views)

Re: Sorting in Revit Schedules

11-12-2012 09:46 AM in reply to: CADastrophe

 

Ok, thank you for helping out!

 

Maybe the conversion to text may be too elaborate for this project.

 

How ever, the calculated value idea makes me think we will have to combine two parameters into one to simplify matters. Hope Autodesk will give us more control in future versions though.

 

Thank you for quick replies!

/Lena

*Expert Elite*
CADastrophe
Posts: 3,420
Registered: ‎08-28-2009
Message 10 of 11 (876 Views)

Re: Sorting in Revit Schedules

11-12-2012 09:55 AM in reply to: lena.v

Unfortunately, with all of the parameters being Text, I believe that you will have to combine them outside the schedule. I'll post if think of any other possibilities...

Corey D.                                                                                                                  ADSK_Logo_EE_2013.png    AutoCAD 2014 User  Revit 2014 User
──────────────────────────────────────────────────────────────────────
⁞|⁞ Please use Mark Solutions!.Accept as Solution and Give Kudos!Give Kudos as appropriate to further enhance these forums. Thank you!
Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Do you have 60 seconds to spare? The Autodesk Community Team is revamping our site ranking system and we want your feedback! Please click here to launch the 5 question survey. As always your input is greatly appreciated.