Rules and Guidelines
Want to participate in the discussions? Please read our Community Rules and Guidelines. Need some help? Visit Support and Answers.

  • State Suggested Answer
  • Locked Locked
  • Replies 12 replies
  • Helpful Answers 1 Helpful answer
  • Subscribers 37 subscribers
  • Views 2908 views
  • Users 0 members are here
Options
You may also be interested in
This discussion is locked.
You cannot post a reply to this discussion. If you have a question start a new discussion

Excel input for 7671 calculation

lyledunn

Could any one assist this old duffer? I have successfully put together a fairly comprehensive circuit calculation spreadsheet in Excel for circuits up to and including 16mm2. However, can anyone advise how I can enter a cell instruction to convert Cos theta to the sine of the angle. For example power factor is 0.8 and sine of same angle is 0.6. All I want to do is enter 0.8 into a cell and the corresponding cell correctly inputs 0.6. 

Parents
  • 0

    Good to see that we all agree on pythag.

    But could you explain your 'core drop' comment please ?

    Do we need to consider neutral drop ? surely only for an out of balance term ?

    or is it a star/delta thing ?

    Say if we have a 230/400V 3 phase supply,  with a balanced 10V drop,

    I would read that to be 10V off each phase,(so a drop of 1/23) so it becomes 220/ 382 .

    Do others  understand it to be   a 10V drop phase-phase (so a drop of 1/40) so 226 /390?

    M

  • 0 in reply to mapj1

    If you run through the formula it gives the voltage drop in volts along one straight length of single core cable. Thus the coefficient b that they refer to needs to be multiplied by 2 for single phase. Now they say it only needs to be multiplied by 1 to get the three phase voltage drop. That would only be the voltage drop along the single core and the line voltage would be root 3 that value.

Reply
  • 0 in reply to mapj1

    If you run through the formula it gives the voltage drop in volts along one straight length of single core cable. Thus the coefficient b that they refer to needs to be multiplied by 2 for single phase. Now they say it only needs to be multiplied by 1 to get the three phase voltage drop. That would only be the voltage drop along the single core and the line voltage would be root 3 that value.

Children
No Data

Join us to get the best from IET EngX.

Joining EngX lets you personalise your experience so you stay up to date on the topics that interest you, plus you’ll be able to make connections who are looking to collaborate, exchange ideas and more.

Join us Not now

Community Rules & Guidelines