3ph load calc spread sheet

Status
Not open for further replies.

tortuga

Code Historian
Location
Oregon
Occupation
Electrical Design
Does anyone have any good spread sheets they use for 3 ph load calcs.
I am thinking of one for retail, kitchens, office and msc 120/208.
4 collums l1 l2 l3 N all added in form of amps.
thx
 
You need to be adding KVA, not amps due to the issue of how 2 pole loads are split between the lines in a 3phase system. Using amps could lead you to an incorrect result. The more 2 pole loads you have, the higher the error.
 
panel schedule

panel schedule

I utilize excel, and created a custom panel schedule with macros, and all that good stuff to automate my panel schedule totals for me then I create another spread sheet to total my building loads by type equipment, receptacle, lighting, etc to apply the correct demand factors and get a building total load, use excel and create a template save it and re-use it each time. The nice thing every time you come across something new you just add it to you schedule to keep it up to date, and you can link, export, etc data from excel to other programs.
 
Status
Not open for further replies.
Top