how to separate wire sizes in wire properties as well in panel schedule?

[Ankitmehta508]

how to separate wire sizes in wire properties as well in panel schedule? please see attached images 

I want separate columns in panel schedule according to wire sizes.

  

[fabiosato]

Hello,

As far as I know, it is not possible.

[J.Wehmer]

If you create a calculated parameter, you can use a formula to do if-then calculations for the wire sizes. I have seen it done and it worked well.

[Ankitmehta508]

Thanks for replying me ,

i have no idea about how to calculate wire size in Revit and its condition. if you had already fixed this issue,then please provide me step by step method. it will be really helpful to me.

[J.Wehmer · Accepted solution]

In Manage<Panel Schedule Templates<Edit Template, add a Calculated Parameter (Discipline=Common, Type=Text), and use the formula below. This is not the exact formula I have seen in the past, just a remake of it, so it may require some minor tweaking.

-When opening the Panel Template, click a column where you want to insert the "WIRE" value, this will 'un-grey' your calc param box. (The button it greyed out because I am already in the dialog box)

if(Rating > 200 A, "ALERT", if(Rating > 175 A, "#3/0", if(Rating > 150 A, "#2/0", if(Rating > 130 A, "#1/0", if(Rating > 115 A, "#1", if(Rating > 100 A, "#2", if(Rating > 85 A, "#3", if(Rating > 65 A, "#4", if(Rating > 50 A, "#6", if(Rating > 30 A, "#8", if(Rating > 20 A, "#10", "#12")))))))))))

This will pull info from your Rating parameter, to "schedule" a Wire size without splitting up all the wires in a run. If you do not have a Rating parameter, you will need to add a column, then assign it a parameter function from the drop down menu on the left side.

**Be aware this is not a substitute for wire sizing and scheduling. Simply a work-around. Verify all wire sizes produced by formula.**

[Ankitmehta508]

Thank you for your response. I got what i want. 

[Anonymous]

hey is there a way to get this to work in a wire tag?

[fabiosato]

Hello,

I suggest you to create 3 shared parameters for each size and use Dynamo routine to make it.