Microsoft excel formula for the adiabatic equation?

[spud1]

Does anyone know the Microsoft Excel 2010 formula entry to achieve the adiabatic equation?

Where, for example cell A1 is the prospective fault current, cell A2 is the disconnection time, cell A3 is the k factor and cell A5 is the resultant minimum c.p.c size?

Thanks

Spud

 

[Richard Burns]

I must admit I have now tried the various brackets and got it wrong each time so I do not know what I was doing before.
Last time it worked but this time when I re opened the spreadsheet it was the same as D Skelton's version and the various brackets did not work.
Must have been asleep (or am asleep now):dozey:

 

[Knobhead]

I'm too set in my ways.

It makes deconstructing formula easier. For complex formula I tend to use hidden cells to calculate small sections then put them together.

Its how I’ve worked for 35 years. I started on Lotus 123, that was a bitch. Before that it was a spreadsheet, a 10' long roll of paper.

 

[D Skelton]

For complex formula I tend to use hidden cells to calculate small sections then put them together.

Me too, for complex formula this definitely works. It makes calculations easier to tweak this way!

For my accounting spreadsheet for example I have single cell formulae that are hundreds of characters long which can be a PITA to tweak when the need arises!

 

[HandySparks]

Sorry no

If that's a reply to this:
Unless I'm misreading BGB 543.1.3, don't you take the square root of I²t before dividing by k, not after?

How do others here interpret the formula in the BGB?

 

[D Skelton]

If that's a reply to this:
Unless I'm misreading BGB 543.1.3, don't you take the square root of I²t before dividing by k, not after?

How do others here interpret the formula in the BGB?

S is equal to... the square root of I²t... Which is then divided by k.

In other words, the square root of I²t is divided by k to get S.

k does not form part of the equation which is square rooted.

 

[Knobhead]

If it gets beyond this then I will break it up.

D34=SQRT(((B37*B37)+(B38*B38)+(B39*B39))-((B37*B38)+(B37*B39)+(B38*B39)))

D34=SQRT(G34-H34)
G34=((B37*B37)+(B38*B38)+(B39*B39))
H34=((B37*B38)+(B37*B39)+(B38*B39))

It all goes back to doing manual spreadsheets, some may find it confusing.

 

[HandySparks]

S is equal to... the square root of I²t... Which is then divided by k.

In other words, the square root of I²t is divided by k to get S.

k does not form part of the equation which is square rooted.

Thanks, we seem to agree.

What's Tony up to then?

 

[Knobhead]

Thanks, we seem to agree.

What's Tony up to then?

Realising he's made a bog up

=(SQRT((A1*A1)*A2))/A3

 

[Silly Sausage]

S = sqrt(t)*I/k

 

[Knobhead]

Someone should tell NAPIT, they've got it wrong!

 

[Knobhead]

To hell with this I'm going doing something enjoyable. 7 blood tests at 15:30 :-(

 

[HandySparks]

To hell with this I'm going doing something enjoyable. 7 blood tests at 15:30 :-(

Went to the doctors for a blood pressure test this morning. Invitation came out of the blue. Must be getting old.