3? Load Calculator

[Smart $]

I cant speak for that web page but I know 600Y/347 is used nearly everywhere we find 480/277

Do you use it?

If not, I'll wait until someone else request's it.

Another possibility is, I can post a tutorial on how to change or add any voltage system desired.

 

[mbrooke]

Do you use it?

If not, I'll wait until someone else request's it.

Another possibility is, I can post a tutorial on how to change or add any voltage system desired.

Sometimes, but if its to much a burden don't worry about it

 

[Smart $]

Sometimes, but if its to much a burden don't worry about it

Instructions (so anyone can add; also serves as an example for other configs)....

On one of the worksheet tabs, right click and choose "Unhide...".

"Index Tables" will already be selected in the pop-up dialog, so just OK out of dialog.

Right-click on [Excel's] column header "D" and select Insert on local menu.

Enter in column "D" cells starting at row 1:
600/347V 3? 4W
=600/sqrt(3)
300
300
300
=600/sqrt(3)
=600/sqrt(3)
=600/sqrt(3)
Note: You can copy and paste the above (best to use match destination formatting option but not required).

Open Name Manager (on Formulas ribbon).

Select "SysVol_Y" in Name column.

In "Refers to:" reference, change "C" (tip: highlight letter with mouse) to "D" and press Enter key.

Select "Multipliers_Y" in Name Column.

In "Refers to:" reference, change "C" (Tip: highlight letter with mouse) to "D" and press Enter key.

Close Name Manager.

Hide "Index Tables" worksheet.

Done.

Let me know if it's too much of a burden... :angel:

 

[mbrooke]

Will give it a try

Btw, just asking, I came across this excel in post #6. Is it any good?

http://forums.mikeholt.com/showthread.php?t=133354

Im thinking of adding it along with yours to my calc library.

In any case I really like yours

 

[Smart $]

Will give it a try

Let me know if you have any problems...

Just a reminder... Save As a different file name before endeavoring JIC... :happyyes: ...though I suppose you could just download a new copy if you mess up. :angel:

Btw, just asking, I came across this excel in post #6. Is it any good?

http://forums.mikeholt.com/showthread.php?t=133354

IDK. The only time I can even think of having to convert unbalanced line currents to phase currents is when one has a borderline transformer... and I don't like having borderline transformers. :happyno:

In any case I really like yours

Thanks

 

[mbrooke]

Ive got bordlines :angel:



Anyways I will give it a spin. The phase angles will not change since the voltage is different?

 

[Smart $]

Ive got bordlines :angel:

Good luck with that...

Anyways I will give it a spin. The phase angles will not change since the voltage is different?

Nope.

 

[Phil Corso]

To all using this calc method...

If EXCEL program uses ATAN function, then substitute ATAN2 !

Regards, Phil

 

[mbrooke]

Good luck with that...



Nope.

Im trying :lol:

 

[mbrooke]

Bump (cause this one is so awesome)

 

[Phil Corso]

Gentlemen,

Interesting list, but why isn't 830/480Y in the list?

Phil Corso

 

[don_resqcapt19]

Gentlemen,

Interesting list, but why isn't 830/480Y in the list?

Phil Corso

Where is that commonly used at?

 

[Phil Corso]

The "Oil Patch"!

 

[Smart $]

"Multipliers_Y"

Gentlemen,

Interesting list, but why isn't 830/480Y in the list?

Phil Corso

Where is that commonly used at?

The "Oil Patch"!

Because it is not a common configuration.

Instructions to add a configuration, or rather an example using 600/347V 3? 4W, is in post#43. You can add as many configurations as you want. Just increase the named ranges "SysVol_Y" and "Multipliers_Y" and insert the appropriate values (which you should be able to glean from the existing values). Same can be done for delta configurations ? self-indicating names, different ranges.

Let me know if you need help...

 

[Phil Corso]

Short ?

Obiously, you don't know an Oil-Patch electrician!


Pill Corso

 

[Smart $]

Who or what is Short?

And you are correct. I do not know any Oil-Patch electricians. There's probably some floating around the area in which I reside, but I'm not an outgoing social person and I don't work in my area of residence much anymore.

http://www.wksu.org/news/story/35781

 

[Phil Corso]

Exactly my sentiments!

 

[Smart $]

New version...
https://drive.google.com/file/d/0By0rzU3UuNh7Rl9oSEVvN00wdTA/view?usp=sharing

Includes automated circuit numbering and a macro-driven panel directory.

Please provide feedback.

Note: With a macro being involved, it is not possible (AFAIK) to convert to type which functions in other spreadsheet programs, at least not with the panel directory sheet. Let me know if you would like it converted without the panel directory sheet and I'll give it a go.