Electrical Load Summary

[Anonymous]

I am looking to create a load summary that I can use for the entire electrical system. I am looking for some help in doing so. I have tried creating a schedules and using connected loads but I am not finding a way to add in the appropriate calculations. I have also tried to create my own panel schedule template but again no luck.  I have a screen shot of what kind of Load Summary we currently use in excel. I would like to replicate this directly into Revit. I want to use the power of revit to have this automate the calculation so I do not have to take time to reference excel for the calculation. If any one has some insight or ideas that can help me accomplish this I would greatly appreciate it.

[Scott_D_]

Most of that information is available in the OOTB panel schedules, the load classification, connected load, demand factor and adjusted load.

What does the Added and Removed bit mean?

Which bits can you not get to work properly?

[Anonymous]

So the picture above is what we use in excel to show a complete load summary of an existing building. Removed loads are existing loads that were demolished and added loads would be loads that were new and added during construction. What I want to happen is make that exact load summary in Revit. Maybe the better question is:

        "Is there a way to have excel like schedules in Revit, where I can make calculations with out being constrained by columns and rows?" 

[Anonymous]

You won't be able to have the "removed" data at all - once something is demolished in Revit, it's well and truly demolished, and panel schedules don't have phases.

But getting the new load info with demand calcs is pretty simple - it's already in the panel schedule.  The existing loads will be too, if you bother to model them correctly.

But if you want to document how much load is demolished during a renovation you'll have to model all of the existing conditions exactly, save that model separately, then demolish and add as required by the project, and compare the two in XL.  

[Scott_D_]

Demolished loads would not be present as the Panel Schedules are 'live' documents at any given point in time.

The answer to your question would be no unfortunately but all of the rest of it is easily possible.

[Anonymous]

So what about having a schedule, not a panel schedule, that list the loads of the all devices and fixtures set to demolished phase?

[Anonymous]

You could do that, sort of.  You'd have to use a multi-category schedule, filter by something that indicates an electrical connection present, then filter by Phase Demolished.  I don't think you could extract the demand factors without manually entering them into each family though - demand factors are a circuit property assigned based on load classification, not something associated directly with each model object. And that's not even getting into however you figure out the receptacle load including demand factor for the receptacles being removed.

I'm not really sure what value you're getting from documenting the loads you're removing anyway - unless there's a specific purpose (AHJ, owner requirement, energy incentive, etc.) I'd recommend abandoning that practice entirely.  You could figure out a way to approximate it with Revit, but it'll be an enormous PITA and likely never perfectly capture what you want it to anyway.

[Anonymous]

The reason we do this is because you have to provide a load summary for every panel that is affected by your work. So this would go all the way up to the service entrance and all the way down to the branch panel that you're adding to. in many cases, if you have existing loads or old panel schedules you don't need a load summary. The panel schedule covers it, but when you don't on an existing building. You have to show how much load you're adding and taking away. 

So what I have done thus far is I have created a schedule that list out the Electrical Fixtures and their corresponding loads filter to show only demo phase. I then added a count column to give me totals. They are group by load classification. The one issue I am running into now it is calculating the total. Which I am not too concerned with because it is just a simple multiplication. I have linked what I have thus far. I made a separate schedule for Lighting fixtures. Would I be able to combine them using multi category schedule?

Device

[Anonymous]

[Anonymous]

****, what jurisdiction requires that?  I've only ever been required to provide a load summary at the service entrance for the utility company.

You can indeed use a multi-category schedule to merge your lighting, HVAC, receptacle, and other miscellaneous equipment loads into one schedule.  But before you do that you'll have to add a parameter indicating that an electrical connection exists in the family so you don't end up including a bunch of duct, air terminals, pipe, etc. in the schedule.  

[Anonymous]

I have ran a crossed a few that do require it. We just made it a thing that we do, to cover our basis. Anyways below is what I have created to show my demo loads, it is filtered in a way where anything that should have a load associated to it is shown. Then I will be be able to check that every demo fixture has a load inserted. Unfortunately some of these categories are from other disciplines I want to filter to show only electrical devices. How would I do that?  

[Anonymous]

" I want to filter to show only electrical devices. How would I do that?  "

In the schedule properties you can set up filters using any parameter included in the schedule.  Because not everything you are supplying power to will be a lighting fixture or electrical fixture, I'd suggest creating a yes/no shared parameter identifying whether the object has a line voltage circuit connected to it.  This should capture all lights, receptacles, HVAC/P/FP equipment, etc.  It'll be something of a pain in the neck to set it all up, but once you get it done the schedule will effectively create itself as you proceed with your design.

[BriCircuitBIM]

We typically create a commercial load summary for all renovations (and new buildings.) It is a must when you do not have metered information on the equipment with the changed loads. It's essentially how you verify your overcurrent protection or rating of the panelboard that you are adding load and any equipment upstream.