Help on exel
Author
Discussion

Vipers

Original Poster:

33,525 posts

259 months

Monday 8th October 2018
quotequote all
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.

James_B

12,642 posts

288 months

Monday 8th October 2018
quotequote all
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.

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.

mike_knott

344 posts

255 months

Monday 8th October 2018
quotequote all
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.

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...

Vipers

Original Poster:

33,525 posts

259 months

Monday 8th October 2018
quotequote all
Thanks guys, but that isn't the answer I was expecting, I will post more tomorrow, bear with me on this one.

sgrimshaw

7,587 posts

281 months

Monday 8th October 2018
quotequote all
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 ?

Vipers

Original Poster:

33,525 posts

259 months

Tuesday 9th October 2018
quotequote all
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 ?
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. beer 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.

sgrimshaw

7,587 posts

281 months

Tuesday 9th October 2018
quotequote all
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. beer 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 wink




Edited by sgrimshaw on Tuesday 9th October 10:26

Vipers

Original Poster:

33,525 posts

259 months

Tuesday 9th October 2018
quotequote all
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. beer 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 wink




Edited by sgrimshaw on Tuesday 9th October 10:26
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. beer

sgrimshaw

7,587 posts

281 months

Tuesday 9th October 2018
quotequote all
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. beer
Not at all wink

Your initial post intrigued me smile

I found it here, and the formula was more obvious:

http://www.dtic.mil/dtic/tr/fulltext/u2/a227673.pd...

Vipers

Original Poster:

33,525 posts

259 months

Tuesday 9th October 2018
quotequote all
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. beer
Not at all wink

Your initial post intrigued me smile

I found it here, and the formula was more obvious:

http://www.dtic.mil/dtic/tr/fulltext/u2/a227673.pd...
Amazing, I have that in my data base, but it's not a good copy, much better here -

http://archive.rubicon-foundation.org/xmlui/bitstr...

Problem was I didnt appreciate that bit that meant to the power of.