Combining Parameters in Schedules

[Anonymous]

Can I combine two or more parameters when creating a schedule so the I can have multiple sets of data in one column of my schedule? For ecample, if I created a Circuit column, could I include both 'panel' and 'circuit number'?

thanks

[CoreyDaun]

This is yet another requested function. To be able to control the schedule via string functions (i.e. Concatenate to combine two strings) would be a huge plus. They have that ability with Labels and within the Panel Schedules (limited). I am disappointed by the limitations of Calculated Values and the inability to link formatting with other fields.

[Anonymous]

What I'd like to be able to do in creating schedules I am able to do when creating panel schedules, so I guess my question is, can I make the parameter I created in a panel schedule available to use inside a regular schedule? I don't necessarily need to combine parameters while creating the schedule, but can a combined parameter be created before the schedule is created, so that it is available as a "single" parameter?

[CoreyDaun]

Combining the parameters is more of just a formatting method rather than any kind of parameter. Essentially, I believe you would have to be able to schedule schedules to have any hope of achieving that, since panel schedules are, of course, schedules. Currently, there is no straightforward way so far to combine parameters beforehand in the way you are looking for. But maybe there is a work-around; what information are you looking to combine?

This Link was given to me by a Revit Support Specialist in this forum. There you can submit your request(s) and possibly help get this functionality in future releases or updates.

[Anonymous]

Specifically, I'm looking to be able to have a column in my schedule such as BRANCH CIRCUIT WIRING. In this column, the data would be organized 'CONDUIT: # OF WIRES: WIRE DIAMETER' all in one cell of the schedule.

I'll keep digging, but thanks for the link, I'll definitely submit a request if nothing can be found.

[CoreyDaun]

With those specific parameters, I don't see much of a chance. If they were all parameters derived from the family (such as voltage and poles) maybe it would be possible to create a reference-able shared parameter, but it wouldn't be simple.

If it is for aesthetic purposes and you just need it to appear as if it were one column, you could:

(WARNING: The following solution may be painful)

Spoiler

1. Create a separate schedule for those parameters only, ensuring the same sort order as the master schedule,

2. Change the formatting of that schedule to include no grid lines and blank headers and format as desired,

3. Create a blank field in the master schedule, via dummy project parameter, and change the header to the desired field,

4. Underlay the secondary schedule with the master schedule so they line up and the data appears in the blank column.

This solution is not a solid one and does not achieve the true goal, but it is the best way to create the look. At least it is the best way that I know of currently.

[Anonymous]

Do you think that if they were parameters derived from the family, it could work?

[CoreyDaun]

If you are at all savvy about creating parameters and assigning formulas, then I could post an example and show you if you would like. This method only works when there is a reasonably small number of overall possibilities between the desired parameters.

[Anonymous]

Please do

[CoreyDaun]

The attached is a mystical fantasy electrical device, a post that is either 120V or 277V, can host up to a three-gang device, and has a conduit size of either 3/4" or 1/2".

**Note that this was created in Revit 2010 hence there is no conduit connector.

The parameter named "Scheduled Value" should be a shared parameter.

**Note that the inches symbol is actually two apostrophes, as a quote symbol would not work in the formula.

Through a series of yes/no parameters, I have the desired combined parameters even though some are instance and some are type. The total number of parameters you must create is the total possibilities of combinations. For this example, Voltage is 2, Gangs is 3, and Conduit is 2, so 2 x 3 x 2 = 12. This can get overwhelming quickly with a lot of options.

**IF ALL OF THE DESIRED PARAMETERS ARE TYPE PARAMETERS, YOU CAN JUST SKIP THIS AND ENTER A VALUE FOR EACH INDIVIDUAL TYPE. THIS METHOD AUTOMATICALLY FAILS IF THERE IS A PARAMETER (SUCH AS PANEL NAME) WITH A LIMITLESS NUMBER OF OPTIONS.