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

    Not at desk but think

    =sqrt(1-PF^2)

    (Where PF is the cell containing cos(th))

    will do the trick.

    Note that excel’s trig functions take radians as their inputs, just to catch you out (c;

    So to get the phase angle from PF=cos(th), you need =degrees(acos(PF))

    **Edited to correct formula!**

  • 0 in reply to Jam

    Ps should have said first that the reverse for PF from phase angle is =cos(radians(th))

  • 0 in reply to Jam

    Whoops, forgot a square root there. Edited.

Reply
  • 0 in reply to Jam

    Whoops, forgot a square root there. Edited.

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