Revit MEP 2011 & Up, Quantifying Spares in Table Schedule Views

[Bill.Knittle]

I have a customer interested in quantifying the number of Spares in all the Panelboards of a project. In testing the practicality of this, I noticed that scheduling Electrical Circuits yields no results as a Spare is not a true circuit of elements.However, scheduling the Electrcial Equipment with a Filter to find Panelboards in the building shows some promise when it comes to Spare current, demand, and connected load (Panel Summary stuff). Unfortunately, this too is not quantifying the number of spares. Is there something I'm missing???

[CoreyDaun]

While this is "possible", the work-around is a bit of a stretch and a little unreasonable.

First, I went to all of my Panel Schedules and for each Spare, I entered the load of 0.01VA. The number immediately reverts back to zero, which is correct. This miniscule amount has negligible and insignificant impact on load calculations.

Next, I create an Electrical Equipment Schedule using the fields Panel Name and Spare Connected. I set the Spare Connected Field as Hidden.

Finally, I created a Calculated Parameter (Number format) named "Number of Spares" with the formula " Spare Connected / 0.01 W ". Mark this field to "Calculate Totals", and this value now quantifies the number of Spares.

There are numerous problems with this including, but not limited to:

• Inability to recognize different ratings
• Inability to recognize multi-pole breakers
• If a Spare is used as a proxy load anywhere, this fails
• Ridiculous manual work to input the 0.01VA in every Spare.