that's beyond my limited computer skills. need a dummies guide. any offfers. never done excel before.
i'll have a try, but think i'll be brown bread before i've sussed it. took me a fortnight to learn how to copy and paste without gumming up the keyboard with solvite.
For those with an android mobile try this app
https://play.google.com/store/apps/details?id=com.procerts.adiabatic
Or for those with those i things it's more expensive
https://itunes.apple.com/gb/app/the-adiabatic-equation/id505845690?mt=8
but it costs 69p
https://play.google.com/store/apps/details?id=com.procerts.adiabatic
Or for those with those i things it's more expensive
https://itunes.apple.com/gb/app/the-adiabatic-equation/id505845690?mt=8
but it costs 69p
K
Knobhead
You forgot two sets of brackets.
I've used excel for so long I struggle to write conventional formula.
=SQRT(((A1*A1)*A2)/A3)
I tried all the combinations and I already had one additional set fo brackets and found that the answer works each time correctly.
I think Excel is applying Bodmas correctly.
I used =SQRT((A1^2*A2)/A3)
Unless I'm misreading BGB 543.1.3, don't you take the square root of I²t before dividing by k, not after?
It doesn't need them, it applies bodmas correctly.
Also, (A1*A1)*A2 is exactly the same as A1*A1*A2.
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:
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:
K
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.
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.
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!
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.
K
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.
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.
K
Knobhead
Went to the doctors for a blood pressure test this morning. Invitation came out of the blue. Must be getting old.
OFFICIAL SPONSORS
These Official Forum Sponsors May Provide Discounts to Regular Forum Members - If you would like to sponsor us then CLICK HERE and post a thread with who you are, and we'll send you some stats etc
Advert
Thread Information
Advert
Thread statistics
Advert
TrueNAS JBOD Storage Server
-
-
Understanding TrueNAS JBOD Servers: A Comprehensive Guide- Started by Dan
- Replies: 8
-
