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 3152 views
  • Users 0 members are here
Options
You may also be interested in
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can 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. 

  • 0

    Thanks, yes, I think that lines up with the way I think about it, for me the VD is the change in  phase to ground voltage, while  you are considering phase to phase voltage change.  I can see situations where either one or the other is more use, and any text needs to be clear which it is referring to.

    Mike

  • 0

    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.

    I can see that. I suppose it then depends on what you're doing with the result. Is it to see what the load actually experiences or is it just to verify some limit? If the latter, if the limit is defined in terms of 230V - e.g. 5% or 230V or 11.5V for example, then 1x would still give the same answer for balanced three phase as √3 times the voltage drop compared with 5% of 400V say (effectively both sides are multiplied by √3, so you can validly divide through by √3 and get the same result). Sometimes it's just simpler to think of 3-phase as just three single-phase loads (and neglect the N current).

    On the other hand I can see a possible flaw in that they seem to assume that a 3-phase circuit is completely balanced - which perhaps isn't always the case in reality (probably not in the majority of cases even). 3-phase distribution circuits are almost certain to feed some single phase loads. There may be some swings and roundabouts in terms of maximum current can sometimes only occur when at least some of the 3-phase loads are running, in which cases N currents may be relatively small, but in other cases having 100% load on just one phase might be entirely plausible.

       - Andy.

Community Rules & Guidelines