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

Topic Options
Rate This Topic
#128158 - 08/15/02 11:59 AM scott35 spreadsheets for 120/208 1p 3w
CAB Offline
Junior Member
Registered: 07/31/02
Posts: 6
Loc: Brooksville, FL, USA
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 )
cb

btw: this post is also under general discussion, sorry for the repetition.
cb
Top
Tools for Electricians:
#128159 - 08/17/02 11:19 AM Re: scott35 spreadsheets for 120/208 1p 3w
Bjarney Offline
Moderator
Registered: 04/10/02
Posts: 2527
Loc: West-Southern Inner-Northeast ...
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 E-C.net 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).]
Top
#128160 - 08/17/02 03:46 PM Re: scott35 spreadsheets for 120/208 1p 3w
Scott35 Offline

Broom Pusher and
Member
Registered: 10/19/00
Posts: 2707
Loc: Anaheim, CA. USA
Bjarney,

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

I really want to build a better mouse trap 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!
Top
#128161 - 08/17/02 10:30 PM Re: scott35 spreadsheets for 120/208 1p 3w
Scott35 Offline

Broom Pusher and
Member
Registered: 10/19/00
Posts: 2707
Loc: Anaheim, CA. USA
P.S.
To contact me via E-Mail, use this address:

dtbigred@pacbell.net

Scott S.E.T.
_________________________
Scott " 35 " Thompson
Just Say NO To Green Eggs And Ham!
Top

Member Spotlight
Member Since: 11/17/00
Posts: 2232
New in the Gallery:
SE cable question
Featured:

2017 NEC and Related
2017 NEC
Now Available!

Shout Box


Who's Online
0 registered (), 58 Guests and 8 Spiders online.
Key: Admin, Global Mod, Mod
 
New in the Gallery:
SE cable question
 
Top Posters (30 Days)
Admin 49
HotLine1 43
gfretwell 18
Ruben Rocha 12
Trumpy 9
 
Newest Members
Freecrowder, clee512, Jdscott2005, FAIZAN, Regitest2

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