3? Load Calculator

Status
Not open for further replies.
Smart $

Smart $

Esteemed Member
Location
Ohio
3Oslashloadcalculator.gif
 
Smart $

Smart $

Esteemed Member
Location
Ohio
Being just out of the blocks, I ask users to scrutinize the results. With all the formulas and considerations involved, it is not inconceivable that there may be errors... :happyno:
 
Smart $

Smart $

Esteemed Member
Location
Ohio
BTW, it's not just for 208/120. Also can select 480/277 on the WYE tab. A second tab (worksheet) covers 240/120 and 480/240 delta high leg. If one is careful, can also be used for 120/208 and 120/240 1?.
 
Besoeker

Besoeker

Senior Member
Location
UK
Smart $

Smart $

Esteemed Member
Location
Ohio
Dennis Alwon said:
Both worked however I can't figure out how to input data

I was thinking of the old question about a 3 phase panel with single phase 208 loads

3- single phase loads at 4500 watts for instance
Click to expand...
On three separate lines enter in the AMPERES column "=4500/120/sqrt(3)" without quotes (NOTE: you could enter "=4500/208", but it will give some rounding error because I use the technical value of 120*sqrt(3) for the calculations).

Then assign AB, BC, and CA (in any order) to the lines in CONNECTION column (cells use Data Validation; click cell, click drop arrow, select CONNECTION).

Also assign a PF of 1 to each.
 
Dennis Alwon

Dennis Alwon

Moderator
Staff member
Location
Chapel Hill, NC
Occupation
Retired Electrical Contractor
Thanks Smart- that worked. One issue I saw is it would not let me enter ab, bc, ac and I to change the ac to ca but all is good .. Thanks
 
Smart $

Smart $

Esteemed Member
Location
Ohio
Dennis Alwon said:
Thanks Smart- that worked. One issue I saw is it would not let me enter ab, bc, ac and I to change the ac to ca but all is good .. Thanks
Click to expand...

Dennis Alwon said:
I just figured to use neutral calcs you type AN. You need instructions for some of us..:D
Click to expand...
The calculations rely on specific entries (e.g. CA vs. AC). That's why I used Data Validation for those entries. Drop box is a clue when those cells are selected. PF also uses Data Validation (values must be from -1.00 to +1.00) but no drop box. I enabled Error message for it, but not the others.

Write up instructions??? Not me! At least not comprehensive instructions. I'll provide bit-by-bit instructions, as needed, in my postings.
 
Dennis Alwon

Dennis Alwon

Moderator
Staff member
Location
Chapel Hill, NC
Occupation
Retired Electrical Contractor
Smart $ said:
The calculations rely on specific entries (e.g. CA vs. AC). That's why I used Data Validation for those entries. Drop box is a clue when those cells are selected. PF also uses Data Validation (values must be from -1.00 to +1.00) but no drop box. I enabled Error message for it, but not the others.

Write up instructions??? Not me! At least not comprehensive instructions. I'll provide bit-by-bit instructions, as needed, in my postings.
Click to expand...

Thank you- I was not serious about writing instructions. With your help here there is no need. Thanks
 
Smart $

Smart $

Esteemed Member
Location
Ohio
I'm now thinking there is another [major] error in the vector calculation. Watching NFC Championship right now... will get to it later and verify.
 
Smart $

Smart $

Esteemed Member
Location
Ohio
Smart $ said:
I'm now thinking there is another [major] error in the vector calculation. Watching NFC Championship right now... will get to it later and verify.
Click to expand...
Unbelievable finish!!!

Anyway, on the error I mentioned, I'm now thinking I messed up on the pf shift. I usually use a different angle convention for my calculations. I based this calculator on a previous one I developed for another member here, using the opposite direction. In my normal method I subtract the power factor angle... and in this calculator I should have added. At least this is what I'm thinking. I will verify, revise, and post if my thinking is correct....
 
Status
Not open for further replies.
Top