Panels and formulas

[CarrieHoffman02]

Please See Video Here

All I want to do is add the 3 phases of Amps/Phase together and then divide by 3. We have figured out that it isn't adding them correctly and I don't know what else could be wrong. 

Is there a way to see the formulas that the default parameters are using? For example: The Apparent Load Phase A adds all the load in Phase A. Current Phase A should equal Apparent Load Phase A /120. When working with the Revit panel our numbers seem a little off compared to our excel panels.

I noticed the panel numbers the circuits differently than we normally do (and different than an actual panel) Is there a way to put the odd circuits on one side and the evens on the other?

Thanks in Advance

Carrie

[CoreyDaun]

I don't know a solution at the moment, but I have heard that this is an existing problem. The latest I've heard about it is this post on AUGI.

[CarrieHoffman02]

Wow...Appears to be a bigger issue than I thought. If we aren't able to use the panel schedules efficiently, Is there a way to put an Excel table on a Revit sheet?

[CoreyDaun]

You cannot link documents into a Revit Project as far as I am aware. And who knows if it will ever be possible, or maybe Autodesk intends for users to use Revit exclusively without the implementation of and dependency on other programs like Microsoft Excel or Word.

[Lance.Coffey]

From what I have found, when testing using a default template, the issues you are seeing don't occur.
 

Are you able to reproduce this behavior when using one of the default templates? (If not, and it isn't too big, or confidential) it would help to have a copy of the template file to look at.)

[CarrieHoffman02]

This is a video of me trying to get the formula to work. I started with a blank out of the box template, using out of the box panels and receptacles (180va). I change the panel so that it will use the two columns, circuits down panel schedule that we would normally use. I added enough outlets for 3 circuits. If you notice the panel doesn't even add up the circuits correctly. Circuit 1 is correct, but circuit 2 should be 720va (4 outlets) and circuit 3 should be 360va. How is 360VA and 3A for the B column I will never know, but 11A+3A+0A=14A. Divide that by 3 and I get 4.7. 

I noticed the panel numbers the circuits differently than we normally do (and different than an actual panel) Is there a way to put the odd circuits on one side and the evens on the other?

Thanks 

Carrie

[CarrieHoffman02]

This is our normal panel template that we use showing the formulas at the bottom.

[eric_grey]

Hi Carrie,

You ran into a bug that has been fixed in the 2013 release.  This was an issue with the way circuits were assigned to each phase when using the Two Columns, Circuits Down panel configuration.  Basically the second circuit was assigned to phase A as it would be when using the Two Columns, Circuits Across configuration instead of phase B as it is now.  This would continue for each circuit.  I have attached an image of your panel schedule in 2013.  But in 2012, you should be able to fix it by moving the circuits and moving them back.  Regenerating the circuits should correct them.

To fix your formula, put parenthesis around the Current Phase A + Current Phase B + Current Phase C as you did in the Excel file. 

Also, to show the odd circuits on one side and the even circuits on the other, you will want to use the Two Columns, Circuits Across panel configuration. 

HTH,

Eric Grey

QA Analyst

[CarrieHoffman02]

I don't understand what you mean by " fix it by moving the circuits and moving them back". Where and I supposed to move them. Please clarify

Thanks

Carrie

[CoreyDaun]

I believe that he is referring to the controls to move the circuit around the Panel Schedule, which is available while editing a Panel Schedule.