Discussion
Hoping there are some clever chappies out there. I am trying to figure out how to work a calculation out in excel, but I am not that clever at square brackets or not sure when there is no mathematical sign shown.
This is it-
UEXD = [(0.1574.D1 + 6.197)0.5 - 1]/(0.0787) shown exactly in a paper I was reading.
I am trying to work this out in simple terms, for example what does this mean:-
0.1574.D1, if D1 was 600, does this mean 0.1574 x D1? Or does the decimal before D1 mean something else?
What does it mean when it shows [(0.1574.D1 + 6.197)0.5 -1]
Does the 0.5 mean after [(0.1574.D1 + 6.197) you multiply it by 0.5
So would it be the same as [(0.1574 x 600 + 6.197)*0.5-1]/0.0787. I don’t understand why the end bit /0.0780 is in brackets, doesn’t need to be does it?
I often use (( )) in excel but not sure what [(......)] means, does the square brackets mean something else?
If D1 was 600 what will UEXD be?
Cheers guys.
This is it-
UEXD = [(0.1574.D1 + 6.197)0.5 - 1]/(0.0787) shown exactly in a paper I was reading.
I am trying to work this out in simple terms, for example what does this mean:-
0.1574.D1, if D1 was 600, does this mean 0.1574 x D1? Or does the decimal before D1 mean something else?
What does it mean when it shows [(0.1574.D1 + 6.197)0.5 -1]
Does the 0.5 mean after [(0.1574.D1 + 6.197) you multiply it by 0.5
So would it be the same as [(0.1574 x 600 + 6.197)*0.5-1]/0.0787. I don’t understand why the end bit /0.0780 is in brackets, doesn’t need to be does it?
I often use (( )) in excel but not sure what [(......)] means, does the square brackets mean something else?
If D1 was 600 what will UEXD be?
Cheers guys.
Vipers said:
Hoping there are some clever chappies out there. I am trying to figure out how to work a calculation out in excel, but I am not that clever at square brackets or not sure when there is no mathematical sign shown.
This is it-
UEXD = [(0.1574.D1 + 6.197)0.5 - 1]/(0.0787) shown exactly in a paper I was reading.
I am trying to work this out in simple terms, for example what does this mean:-
0.1574.D1, if D1 was 600, does this mean 0.1574 x D1? Or does the decimal before D1 mean something else?
What does it mean when it shows [(0.1574.D1 + 6.197)0.5 -1]
Does the 0.5 mean after [(0.1574.D1 + 6.197) you multiply it by 0.5
So would it be the same as [(0.1574 x 600 + 6.197)*0.5-1]/0.0787. I don’t understand why the end bit /0.0780 is in brackets, doesn’t need to be does it?
I often use (( )) in excel but not sure what [(......)] means, does the square brackets mean something else?
If D1 was 600 what will UEXD be?
Cheers guys.
The dot means times. The number immediately after the bracket means times too.This is it-
UEXD = [(0.1574.D1 + 6.197)0.5 - 1]/(0.0787) shown exactly in a paper I was reading.
I am trying to work this out in simple terms, for example what does this mean:-
0.1574.D1, if D1 was 600, does this mean 0.1574 x D1? Or does the decimal before D1 mean something else?
What does it mean when it shows [(0.1574.D1 + 6.197)0.5 -1]
Does the 0.5 mean after [(0.1574.D1 + 6.197) you multiply it by 0.5
So would it be the same as [(0.1574 x 600 + 6.197)*0.5-1]/0.0787. I don’t understand why the end bit /0.0780 is in brackets, doesn’t need to be does it?
I often use (( )) in excel but not sure what [(......)] means, does the square brackets mean something else?
If D1 was 600 what will UEXD be?
Cheers guys.
So you multiply D1 by 0.1574, you then ad 6.197 and divide the result by two. You then subtract one, and divide the whole lot by 0.0787.
Square brackets and round brackets don’t tend to mean anything different to each other in calculations like this.
James_B said:
The dot means times. The number immediately after the bracket means times too.
So you multiply D1 by 0.1574, you then ad 6.197 and divide the result by two. You then subtract one, and divide the whole lot by 0.0787.
Square brackets and round brackets don’t tend to mean anything different to each other in calculations like this.
This.So you multiply D1 by 0.1574, you then ad 6.197 and divide the result by two. You then subtract one, and divide the whole lot by 0.0787.
Square brackets and round brackets don’t tend to mean anything different to each other in calculations like this.
The square and round brackets are there to make it easier to read the pairs. There is no need for the brackets around 0.0787
So if you were to put the number 600 in cell D1 in excel and type the following in another cell...
=((0.1574*D1+6.197)*0.5-1)/0.0787
...you get UEXD = 626.6645
Mike...
sgrimshaw said:
Vipers said:
Thanks guys, but that isn't the answer I was expecting, I will post more tomorrow, bear with me on this one.
We're you expecting something more like 114.76 ?Then I rememberd it was written in superscript, like this :-
=((0.1574*600+6.197)^0.5-1)/((0.0787))
So instead of what I thought was )*0.5-1, was really )to the power of 0.5-1, that gives an answer of 114.7624.
So looks like you sussed it out, clever you.
I was too tired last night to take in your suggestion of 114.76.Thanks to the other guys for their help as well, cheers guys.
Vipers said:
The paper said the answer was 115. Anyway as it does, the little grey cells ticked over all night, even kept me awake, and finally the penny dropped. As I was unaware of the significance of a dot instead of multiplication, and lack of a sign after the closed bracked was also multiplication, I assumed the part of the calc which was 0.5-1 was just that.
Then I rememberd it was written in superscript, like this :-
=((0.1574*600+6.197)^0.5-1)/((0.0787))
So instead of what I thought was )*0.5-1, was really )to the power of 0.5-1, that gives an answer of 114.7624.
So looks like you sussed it out, clever you.
I was too tired last night to take in your suggestion of 114.76.
Thanks to the other guys for their help as well, cheers guys.
The original US Navy document was easier to read than the paper I suspect you read Then I rememberd it was written in superscript, like this :-
=((0.1574*600+6.197)^0.5-1)/((0.0787))
So instead of what I thought was )*0.5-1, was really )to the power of 0.5-1, that gives an answer of 114.7624.
So looks like you sussed it out, clever you.
I was too tired last night to take in your suggestion of 114.76.Thanks to the other guys for their help as well, cheers guys.

Edited by sgrimshaw on Tuesday 9th October 10:26
sgrimshaw said:
Vipers said:
The paper said the answer was 115. Anyway as it does, the little grey cells ticked over all night, even kept me awake, and finally the penny dropped. As I was unaware of the significance of a dot instead of multiplication, and lack of a sign after the closed bracked was also multiplication, I assumed the part of the calc which was 0.5-1 was just that.
Then I rememberd it was written in superscript, like this :-
=((0.1574*600+6.197)^0.5-1)/((0.0787))
So instead of what I thought was )*0.5-1, was really )to the power of 0.5-1, that gives an answer of 114.7624.
So looks like you sussed it out, clever you.
I was too tired last night to take in your suggestion of 114.76.
Thanks to the other guys for their help as well, cheers guys.
The original US Navy document was easier to read than the paper I suspect you read Then I rememberd it was written in superscript, like this :-
=((0.1574*600+6.197)^0.5-1)/((0.0787))
So instead of what I thought was )*0.5-1, was really )to the power of 0.5-1, that gives an answer of 114.7624.
So looks like you sussed it out, clever you.
I was too tired last night to take in your suggestion of 114.76.Thanks to the other guys for their help as well, cheers guys.

Edited by sgrimshaw on Tuesday 9th October 10:26
I have been involved in commercial diving for over 40 years hence my interest in this. Good to see you know something about it as well.

Vipers said:
Same thing I think, the paper was by Thalman, published by the Undersea Biomedical Research in 1989.
I have been involved in commercial diving for over 40 years hence my interest in this. Good to see you know something about it as well.
Not at all I have been involved in commercial diving for over 40 years hence my interest in this. Good to see you know something about it as well.


Your initial post intrigued me

I found it here, and the formula was more obvious:
http://www.dtic.mil/dtic/tr/fulltext/u2/a227673.pd...
sgrimshaw said:
Vipers said:
Same thing I think, the paper was by Thalman, published by the Undersea Biomedical Research in 1989.
I have been involved in commercial diving for over 40 years hence my interest in this. Good to see you know something about it as well.
Not at all I have been involved in commercial diving for over 40 years hence my interest in this. Good to see you know something about it as well.


Your initial post intrigued me

I found it here, and the formula was more obvious:
http://www.dtic.mil/dtic/tr/fulltext/u2/a227673.pd...
http://archive.rubicon-foundation.org/xmlui/bitstr...
Problem was I didnt appreciate that bit that meant to the power of.
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff


