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

    I think both Euclid and Pythagoras we’re in my trig class, but they sat at the front!
    Many thanks all. That’s a neat way of remembering the function Graham. Works perfectly on my calculator but haven’t tried on a cell input on Excel. 
    I am actually setting it up for the IS10101 2020 voltage drop formula. That standard, unlike BS7671 has no helpful voltage drop tables and one is forced to use the rather unwieldy method. However, it’s not that different to the methodology adopted in 7671 in that it takes account of load power factor, although not Ct.

    I will post it as a photo below. Note that the three-phase calculation is incorrect as it gives only the core voltage drop. 

  • 0 in reply to lyledunn

Reply 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