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
Parking lot pole light swap....
by gfretwell
10/24/16 08:46 PM
International Wire Colour Codes
by Tjia1981
10/23/16 12:08 PM
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
New in the Gallery:
12.5A through 0.75mm˛ flex (just out of curiosity)
Shout Box

Top Posters (30 Days)
gfretwell 14
HotLine1 7
ghost307 7
renosteinke 6
Potseal 4
Who's Online
0 registered (), 340 Guests and 4 Spiders online.
Key: Admin, Global Mod, Mod
Topic Options
Rate This Topic
#12757 - 08/15/02 11:57 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 )

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....

#12758 - 08/17/02 03:12 PM Re: scott35 spreadsheets for 120/208 1p 3w
Scott35 Offline

Broom Pusher and

Registered: 10/19/00
Posts: 2724
Loc: Anaheim, CA. USA

Is this 120/208 VAC panel a 3 phase 4 wire panel? If so, try the spreadsheet for that type of panel.

If the panel is 1 phase 3 wire @ 120/208, then simply edit the cell with the voltage reference and make it "208" instead of "240".
That "Basic" version of the spreadsheet will use the new voltage value for calcs.

The abbreviations are as follows:
  • LTG = Lighting,
  • REC = Receptacles,
  • MSC = Misc.,
  • BKR = Breaker (Trip rating and number of poles),
  • LCL = Long - Continuous Loads (AKA 3 hours or more). This shows the amount of LCL added to the circuits' in the schedule,
  • BUS = Bus bar which has the listed load or identified circuit. The bus which the breaker is landed to.

When listing the Volt-Amps for L-L loads, list this in both rows / columns as necessary - list the load VA in the cells for line A and line B per circuit position
(example: L-L compressor 10.0 amps @ 208 VAC 1 phase connected to CKTs. 1/3. CKT 1 position = "Compressor" in the description cell and "2080" in the cell for "A". Do the same for CKT 3, except place the "2080" in the cell for "B")

Feel free to contact me if you need further assistance.

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


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