Automatic calculations. PPT to Gravity and Gravity to PPT

[javichuteck]

Hello!
I have an Excel sheet, where I have a lot of aquarium data, and I have found myself in the need many times to want to know in a direct way how much is in gravity unit the value obtained from a measurement of a Hanna pencil (for example) in ppt.
And the other way around too, to have the reference that X units of gravity how many ppt would that be?

I have seen many online calculators that do this.
I have looked into them (source code) but the calculations are done on the server, and I have not been able to pull up the algorithm they use.
I would like to know the formula to use in my excel sheet (in both directions. ppt to gravity, and gravity to ppt).

Does anyone have this data?
Thank you very much!

 

[MnFish1]

Try this: https://www.theaquariumsolution.com/specific-gravity-salinity-and-its-measurement

 

[Randy Holmes-Farley Verified Community Expert]

Hello!
I have an Excel sheet, where I have a lot of aquarium data, and I have found myself in the need many times to want to know in a direct way how much is in gravity unit the value obtained from a measurement of a Hanna pencil (for example) in ppt.
And the other way around too, to have the reference that X units of gravity how many ppt would that be?

I have seen many online calculators that do this.
I have looked into them (source code) but the calculations are done on the server, and I have not been able to pull up the algorithm they use.
I would like to know the formula to use in my excel sheet (in both directions. ppt to gravity, and gravity to ppt).

Does anyone have this data?
Thank you very much!

A reasonably accurate assumption is that sg= 1.0264 = 35 ppt and sg = 1.000 = 0 ppt. Linearly interpolate in between and extend above 35 ppt.

 

[MnFish1]

A reasonably accurate assumption is that sg= 1.0264 = 35 ppt and sg = 1.000 = 0 ppt. Linearly interpolate in between and extend above 35 ppt.

With no offense - most people may not understand this - and - as a math major - neither do i...?

 

[Randy Holmes-Farley Verified Community Expert]

With no offense - most people may not understand this - and - as a math major - neither do i...?

Sg = 1.0xxx

Xxx = (salinity/35) x 264

 

[javichuteck]

Sg = 1.0xxx

Xxx = (salinity/35) x 264

I have doubts (I am not very good at math, equations, etc).

I don't understand how to use this.

Could you give me a couple of examples with 1.0264 and with (for example) 1.0249?

Just to understand how to use it and apply it to an automated Excel cell.

Thanks

 

[Johnd651]

I have doubts (I am not very good at math, equations, etc).

I don't understand how to use this.

Could you give me a couple of examples with 1.0264 and with (for example) 1.0249?

Just to understand how to use it and apply it to an automated Excel cell.

Thanks

Your excel formula would be (if sg is in cell A1), =((A1-1.0)/35)*264)

 

[Johnd651]

If ppt is in cell A2
=(((A2/264)×35)+1.0)

 

[KStatefan]

Specific Gravity = Salinity/35*.0264+1

 

[livinlifeinBKK]

With no offense - most people may not understand this - and - as a math major - neither do i...?

Since OP uses Excel and asked for a formula, I think the assumption is that he probably knows how to create a graph and plot points on a linear line. He may or may not.

 

[javichuteck]

Your excel formula would be (if sg is in cell A1), =((A1-1.0)/35)*264)

The calculations do not work. Practical example:

A1 = 1,0264

((1,0264-1.0)/35)*264)

(0,0264 / 35) * 264

0,000754285714286 * 264

0,199131428571429

This value does not refer to ppt for a sg with value 1.0264.

What am I doing wrong?

 

[KStatefan]

The calculations do not work. Practical example:

A1 = 1,0264

((1,0264-1.0)/35)*264)

(0,0264 / 35) * 264

0,000754285714286 * 264

0,199131428571429

This value does not refer to ppt for a sg with value 1.0264.

What am I doing wrong?

 

[livinlifeinBKK]

Do you know how to plot a graph with Excel?

 

[javichuteck]

Do you know how to plot a graph with Excel?

I do know how to trace it.
But now I am not at the time to generate graphs. I will see if I want to create a chart in the future.

I am now with the conversion of each measurement to its homonym.

 

[Johnd651]

The calculations do not work. Practical example:

A1 = 1,0264

((1,0264-1.0)/35)*264)

(0,0264 / 35) * 264

0,000754285714286 * 264

0,199131428571429

This value does not refer to ppt for a sg with value 1.0264.

What am I doing wrong?

I went off of the above formula to turn it into excel. I will need to look at it when I'm more awake. Quick comparison it might be a decimal point and parentheses shift.

 

[KStatefan]

I do know how to trace it.
But now I am not at the time to generate graphs. I will see if I want to create a chart in the future.

I am now with the conversion of each measurement to its homonym.

I guess I am not understanding what you are looking for. I thought the screen shot of excel above answered your question. Can you explain a different way what you are looking for?

 

[javichuteck]

I guess I am not understanding what you are looking for. I thought the screen shot of excel above answered your question. Can you explain a different way what you are looking for?

Yes, of course the Excel answer answered my question.

But another person has asked if it was to make a graph, and I have answered to you that it was not to make a graph (same time).

 

[javichuteck]

I have already applied this formula in my excel and everything comes out correctly.