The Electrical Contractor Network

ECN Electrical Forum
Discussion Forums for Electricians, Inspectors and Related Professionals

Books, Tools and Test Equipment for Electrical and Construction Trades

Register Now!

Register Now!

We want your input!


2017 NEC and Related
2017 NEC
Now Available!

Recent Posts
International Wire Colour Codes
by Texas_Ranger
Today at 08:24 AM
Son of Sparky
by HotLine1
10/20/16 07:43 PM
Speaking of Plugmold ...
by gfretwell
10/17/16 02:37 PM
Broken battery charger? Check for cobwebs!
by gfretwell
10/17/16 02:30 PM
230 or 345 kV transmission lines?
by annemarie1
10/12/16 01:23 PM
New in the Gallery:
12.5A through 0.75mm˛ flex (just out of curiosity)
Shout Box

Top Posters (30 Days)
gfretwell 11
renosteinke 6
HotLine1 6
ghost307 5
Potseal 4
Who's Online
0 registered (), 253 Guests and 5 Spiders online.
Key: Admin, Global Mod, Mod
Topic Options
Rate This Topic
#39306 - 06/16/04 01:24 PM Panel Schedules & Feeder Tables
Macman Offline
Junior Member

Registered: 06/16/04
Posts: 3
Loc: Omaha, NE USA
Greetings Everyone! I just joined the ECN forum and wanted to post a message concerning some free items I have available on my web site. I've been doing electrical work in Nebraska since 1984. I received a Class B Journeyman license in 1988, a Class A Journeyman license in 1989, a Class A Master's license in 1990, an Electrical Contractor license in 1998, and engineer intern registration in 1999, and a professional registered electrical engineer license in 2002.

In the course of my career, I've created many items of interest to electricians on computers. The latest group of them is available on my web site at This is what is available:

1) An Excel spreadsheet based feeder calculator that determines the minimum size conduit for most common wire types in almost any type of conduit.

2) Pre-made feeder tables in PDF that show number of conductors, conduit, and ground (if needed) for single and three phase services, feeders, and motors.

3) 1-phase and 3-phase panel schedules with convenient check boxes for voltage, subfeed lugs, feed thru lugs, top feed, bottom feed, and many other fields in PDF. Perfect for keeping written records of panels during field survey of existing conditions.

4) An Excel spreadsheet based version of the panel schedules mentioned above. More than just an electronic schedule, these spreadsheets perform load calculations and can link panels together so that you can "model" the load of an entire installation. Add circuits to any panel and see the resulting load change on the MDP.

5) CAD sizing chart in PDF. Just a handy little chart of paper and text sizes if you dabble in computer aided drafting.

6) Design & Construction Engineers' electrical symbol legend in PDF. Drawn from industry and local Midwestern standards, these can form a basis for creating your own standard.

7) OPPD (the local utility in Omaha, Nebraska) and ANSI transformer information in PDF showing common sizes, weights, and short circuit information. There is also a page explaining OPPD's transformer marking codes.

I hope you find these tools to be of interest and use to you. My contact information is available on the web site if you have comments or questions concerning the files.

Todd Stahlnecker

[This message has been edited by Macman (edited 06-16-2004).]

Work Gear for Electricians and the Trades

Work Gear for Electricians and the Trades
Work Gear for Electricians and the Trades
Arc Flash Clothing, Gloves, KneePads, Tool Belts, Pouches, Tool Carriers, etc. etc....

#39307 - 06/16/04 05:45 PM Re: Panel Schedules & Feeder Tables
Nick Offline

Registered: 08/13/01
Posts: 603
Loc: Riverside, CA
I just tried your excel panel schedule and all I have to say is WOW! That is awesom. I have been looking for something like this for a long time. It OLE's into CAD very well too. My only comment is that the CAD insert page should show the loads too shouldn't it? Most building Departments would want to see that info on the construction documents. Or do you show that somewhere else?
My hats off to you! Great job.

#39308 - 06/17/04 12:12 PM Re: Panel Schedules & Feeder Tables
Macman Offline
Junior Member

Registered: 06/16/04
Posts: 3
Loc: Omaha, NE USA

Believe me, that question got debated quite a bit during the development of the spreadsheet. In the end, we decided that we would not put the loads on the construction documents for the following reasons:

1) It would make the schedule larger. Right now, they will fit onto 8.5x11 and we didn't want to make it so large that it was not possible to show changes to it on an 8.5x11 sketch.

2) Showing the circuit loads would require more sketches to be issued when change orders were made. Right now, we can add several receptacles to a circuit and not have to show changes to the panel.

3) We figure that we can send the whole panel printout to a code official if they question our sizing. Sort of a "let sleeping dogs lie" approach. If they don't ask, don't tell them, and that means fewer things for them to challenge.

I think that the one thing that I would consider putting on the drawings would be the load calc table found in cells K26...S41. I haven’t tried but OLE should be able to show that pretty easily.

Todd Stahlnecker


ECN Electrical Forums - sponsored by Electrical Contractor Network - Electrical and Code Related Discussion for Electrical Contractors, Electricians, Inspectors, Instructors, Engineers and other related Professionals