Reef Central Online Community

Go Back   Reef Central Online Community > General Interest Forums > The Reef Chemistry Forum
Blogs FAQ Calendar Mark Forums Read

Notices

User Tag List

Reply
Thread Tools
Unread 05/21/2018, 06:17 PM   #1
smartwater101
Registered Member
 
smartwater101's Avatar
 
Join Date: Aug 2012
Location: Los Angeles
Posts: 382
Post need help: spreadsheet to convert Phosphorus - Phosphate W/ the Hanna margin of error

This is both a math and a Google Spreadsheet question: I want to convert Phosphorus to Phosphate....

the math to convert is easy enough.

12ppb phosphorus reading would =

12x3.066 = 36.792 part per billion phosphate

divide by 1000 = 0.037ppm phosphate

wich I have set up already



https://i.imgur.com/bMOVRjE.png

BUT The Hanna checker has an accuracy range of ±5 ppb ±5% of reading

And this is where my spreadsheet skills fall apart. Can anyone help?


__________________
160 mixed reef: Hippo tang, Foxface, clownfish, 25+ nano gobies/blennies/cardinals
smartwater101 is offline   Reply With Quote
Unread 05/21/2018, 11:44 PM   #2
bertoni
RC Mod
 
Join Date: Mar 2002
Location: Mountain View, CA, USA
Posts: 88,616
Well, I can't even do that much, but if you don't find an answer, let me know, and I'll try to do some research.


__________________
Jonathan Bertoni
bertoni is offline   Reply With Quote
Unread 05/22/2018, 04:55 AM   #3
RobZilla04
Registered Member
 
RobZilla04's Avatar
 
Join Date: Sep 2016
Location: St. Augustine, FL
Posts: 1,857
You need to account for the range in the ppb prior to the math converting to ppm.

Thus 12 = range of 7-17. Use an additional two lines, one (B4) for B3 +5ppb(or 5%) and one (B5) for B3 -5ppb(or 5%). Then run the same formula for each of those to convert to ppm.

At least that is my simpleton understanding.....


__________________
90g Mixed Reef
RobZilla04 is offline   Reply With Quote
Unread 05/22/2018, 05:31 AM   #4
homer1475
Registered Member
 
homer1475's Avatar
 
Join Date: Mar 2015
Location: Upstate NY
Posts: 5,313
EDIt:
NVM I understand what your trying to do now.


__________________
80G SCA Build: http://reefcentral.com/forums/showthread.php?t=2560256

Originally posted by der_wille_zur_macht:

"He's just taking his lunch to work"
homer1475 is offline   Reply With Quote
Unread 05/22/2018, 10:07 AM   #5
smartwater101
Registered Member
 
smartwater101's Avatar
 
Join Date: Aug 2012
Location: Los Angeles
Posts: 382
Quote:
Originally Posted by RobZilla04 View Post

Thus 12 = range of 7-17. Use an additional two lines, one (B4) for B3 +5ppb(or 5%) and one (B5) for B3 -5ppb(or 5%). Then run the same formula for each of those to convert to ppm.
That sounds like the right track but I believe it's 5 ppb AND 5% (not either/or). So I probably need to sneak a little more math in there.


__________________
160 mixed reef: Hippo tang, Foxface, clownfish, 25+ nano gobies/blennies/cardinals
smartwater101 is offline   Reply With Quote
Unread 05/22/2018, 11:21 AM   #6
bertoni
RC Mod
 
Join Date: Mar 2002
Location: Mountain View, CA, USA
Posts: 88,616
It is 5% and 5 ppb, unfortunately. So you need to take the measurement, subtract 5 and 5% from it to compute the low. The high would be adding 5 ppb ad 5%. You'd probably want to clamp the low at zero, and avoid showing negative numbers.


__________________
Jonathan Bertoni
bertoni is offline   Reply With Quote
Unread 05/22/2018, 11:23 AM   #7
RobZilla04
Registered Member
 
RobZilla04's Avatar
 
Join Date: Sep 2016
Location: St. Augustine, FL
Posts: 1,857
Sorry for the confusion, I'm new to the ULR as well.


__________________
90g Mixed Reef
RobZilla04 is offline   Reply With Quote
Unread 05/22/2018, 01:10 PM   #8
smartwater101
Registered Member
 
smartwater101's Avatar
 
Join Date: Aug 2012
Location: Los Angeles
Posts: 382
Thumbs up I figured it out!!



Okay so I got it working.

In case you're wonder how to set it up:

Cell B4: Enter your reading from the test

Cell C4: =B4*3.066/1000

Cell D4: =ROUND(((B4-5)*3.066/1000)*0.95,3)&" - "&ROUND(((B4+5)*3.066/1000)*1.05,3)

Thats it!


__________________
160 mixed reef: Hippo tang, Foxface, clownfish, 25+ nano gobies/blennies/cardinals
smartwater101 is offline   Reply With Quote
Unread 05/22/2018, 01:25 PM   #9
smartwater101
Registered Member
 
smartwater101's Avatar
 
Join Date: Aug 2012
Location: Los Angeles
Posts: 382
Thumbs up

An alternative formula: This will keep the reading out of the negative so no going below zero


Cell D4: =MAX(ROUND(((B4-5)*3.066/1000)*0.95,3) , 0 )&" - "&MAX(ROUND(((B4+5)*3.066/1000)*1.05,3) , 0 )


__________________
160 mixed reef: Hippo tang, Foxface, clownfish, 25+ nano gobies/blennies/cardinals
smartwater101 is offline   Reply With Quote
Unread 05/23/2018, 04:28 AM   #10
RobZilla04
Registered Member
 
RobZilla04's Avatar
 
Join Date: Sep 2016
Location: St. Augustine, FL
Posts: 1,857
Very cool, thx for sharing.


__________________
90g Mixed Reef
RobZilla04 is offline   Reply With Quote
Unread 06/01/2018, 12:37 PM   #11
smartwater101
Registered Member
 
smartwater101's Avatar
 
Join Date: Aug 2012
Location: Los Angeles
Posts: 382
Quote:
Originally Posted by RobZilla04 View Post
Very cool, thx for sharing.
No problem! Hopefully it will be of use for some random Googler in the future.


__________________
160 mixed reef: Hippo tang, Foxface, clownfish, 25+ nano gobies/blennies/cardinals
smartwater101 is offline   Reply With Quote
Unread 10/17/2018, 03:22 PM   #12
Daddyrawg
Registered Member
 
Join Date: May 2018
Posts: 814
Quote:
Originally Posted by smartwater101 View Post
No problem! Hopefully it will be of use for some random Googler in the future.
YUP like myself.. Thanks BUD


Daddyrawg is offline   Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On



All times are GMT -6. The time now is 08:43 AM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Powered by Searchlight © 2024 Axivo Inc.
Use of this web site is subject to the terms and conditions described in the user agreement.
Reef CentralTM Reef Central, LLC. Copyright ©1999-2022
User Alert System provided by Advanced User Tagging v3.3.0 (Pro) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.