ECN Electrical Forum - Discussion Forums for Electricians, Inspectors and Related Professionals
ECN Shout Chat
ShoutChat Box
Recent Posts
Pool Lights?
by Papa - 09/18/20 05:26 PM
Ever been afflicted by Gout?
by mbhydro - 09/15/20 05:50 PM
Questioning the electrical norms
by gfretwell - 09/13/20 01:17 PM
120/208 gives 240? please clarify
by NORCAL - 09/13/20 01:08 AM
Lock-down Thread
by Trumpy - 09/11/20 11:17 PM
New in the Gallery:
Facebook follies, bad wiring
FPE in Germany pt.2
Who's Online Now
0 registered members (), 15 guests, and 9 spiders.
Key: Admin, Global Mod, Mod
Previous Thread
Next Thread
Print Thread
Rate Thread
scott35 spreadsheets for 120/208 1p 3w #128158 08/15/02 02:59 PM
Joined: Jul 2002
Posts: 6
CAB Offline OP
Junior Member
Can anyone suggest how the scott35 excel spreadsheet for single phase 120/240 could be modified to correctly calculate the load for a 120/208 panel? Also unsure of the use of abbreviations on the following columns: LTG, REC, MSC, BKR, LCL, BUS. Final question, would say a single phase compressor running at 208v and 24.4 amps be listed under columns A and B on the same row or on successive rows in order for the spreadsheet to correctly tabulate amperage?

Thanx in advance [Linked Image])

btw: this post is also under general discussion, sorry for the repetition.

Tools for Electricians:
Re: scott35 spreadsheets for 120/208 1p 3w #128159 08/17/02 02:19 PM
Joined: Apr 2002
Posts: 2,527
Bjarney Offline
So that we're on the same page, answers here refer to '1ph3.xls' in Psched1.exe.

Looks like LTG - lighting, REC – receptacle, MSC - miscellaneous, BKR – breaker (size), CKT – circuit number (odd-left/even-right), BUS – Aø or Bø bus connection.

The summed per-phase loads should work for a 120/208V 3w bus and ø-n or ø-ø connected loads, but they do not cancel [worst case] in the feeder ‘neutral’ lead like that of 120/240V 3w circuits. {Has nothing to do with harmonics, BTW.} If, for example, there were two 120V 16A loads connected Aø-N and Bø-N then the feeder neutral would also see [worst case] 16 amperes. A 208V 24A load connected Aø-Bø would reflect no neutral current. {duh.}

Although Scott’s schedules apply to most panelboards and switchboards, be aware that 1- or 2-pole molded-case breakers in "I-line" boards don’t fit the usual bussing-sequence rules.

Scott35, you have provided members with a very worthwhile set of spreadsheets, that can be modified to fit specific needs. You have done the hard part…thanks!

[This message has been edited by Bjarney (edited 08-17-2002).]

Re: scott35 spreadsheets for 120/208 1p 3w #128160 08/17/02 06:46 PM
Joined: Oct 2000
Posts: 2,721
Scott35 Offline
Broom Pusher and

Thanks for the kind words!!!
You covered the answers correctly, plus the other related items!

I really want to build a better mouse trap [Linked Image] for the Panel Schedules.
When I get them finished and Debugged, I'll add them to ECN.

CAB, I posted a reply to this in the General Discussion area, so feel free to view that message if needed.

Scott S.E.T.

Scott " 35 " Thompson
Just Say NO To Green Eggs And Ham!
Re: scott35 spreadsheets for 120/208 1p 3w #128161 08/18/02 01:30 AM
Joined: Oct 2000
Posts: 2,721
Scott35 Offline
Broom Pusher and
To contact me via E-Mail, use this address:

Scott S.E.T.

Scott " 35 " Thompson
Just Say NO To Green Eggs And Ham!


2020 National Electrical Code
2020 National Electrical
Code (NEC)

* * * * * * *

2017 Master Electrician Exam Preparation Combos
2017 NEC Electrician
Exam Prep Combos:
Master / Journeyman


Member Spotlight
Portland, Oregon, United States
Posts: 404
Joined: March 2007
Show All Member Profiles 
Top Posters(30 Days)
Trumpy 8
Popular Topics(Views)
269,932 Are you busy
204,358 Re: Forum
192,577 Need opinion
Powered by UBB.threads™ PHP Forum Software 7.7.3