Reef Central Online Community

Home Forum Here you can view your subscribed threads, work with private messages and edit your profile and preferences View New Posts View Today's Posts

Find other members Frequently Asked Questions Search Reefkeeping ...an online magazine for marine aquarists Support our sponsors and mention Reef Central

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

Notices

User Tag List

Reply
Thread Tools
Old 05/21/2018, 07:17 PM   #1
smartwater101
Registered Member
 
smartwater101's Avatar
 
Join Date: Aug 2012
Location: Los Angeles
Posts: 387
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?


__________________
180 reef: Hippo tang. Foxface. 2 clownfish. 30+ nano gobies\blennies\cardinals

70 agro: Catalufa popeye soldier. Barred moray. Snowflake moray. Atlantic longnose butterfly. Flame hawk. Future add:
smartwater101 is offline   Reply With Quote
Old 05/22/2018, 12:44 AM   #2
bertoni
RC Mod
 
Join Date: Mar 2002
Location: Mountain View, CA, USA
Posts: 87,420
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
Old 05/22/2018, 05:55 AM   #3
RobZilla04
Registered Member
 
RobZilla04's Avatar
 
Join Date: Sep 2016
Location: St. Augustine, FL
Posts: 1,839
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
Old 05/22/2018, 06:31 AM   #4
homer1475
Registered Member
 
homer1475's Avatar
 
Join Date: Mar 2015
Location: Upstate NY
Posts: 5,195
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 online now   Reply With Quote
Old 05/22/2018, 11:07 AM   #5
smartwater101
Registered Member
 
smartwater101's Avatar
 
Join Date: Aug 2012
Location: Los Angeles
Posts: 387
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.


__________________
180 reef: Hippo tang. Foxface. 2 clownfish. 30+ nano gobies\blennies\cardinals

70 agro: Catalufa popeye soldier. Barred moray. Snowflake moray. Atlantic longnose butterfly. Flame hawk. Future add:
smartwater101 is offline   Reply With Quote
Old 05/22/2018, 12:21 PM   #6
bertoni
RC Mod
 
Join Date: Mar 2002
Location: Mountain View, CA, USA
Posts: 87,420
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
Old 05/22/2018, 12:23 PM   #7
RobZilla04
Registered Member
 
RobZilla04's Avatar
 
Join Date: Sep 2016
Location: St. Augustine, FL
Posts: 1,839
Sorry for the confusion, I'm new to the ULR as well.


__________________
90g Mixed Reef
RobZilla04 is offline   Reply With Quote
Old 05/22/2018, 02:10 PM   #8
smartwater101
Registered Member
 
smartwater101's Avatar
 
Join Date: Aug 2012
Location: Los Angeles
Posts: 387
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!


__________________
180 reef: Hippo tang. Foxface. 2 clownfish. 30+ nano gobies\blennies\cardinals

70 agro: Catalufa popeye soldier. Barred moray. Snowflake moray. Atlantic longnose butterfly. Flame hawk. Future add:
smartwater101 is offline   Reply With Quote
Old 05/22/2018, 02:25 PM   #9
smartwater101
Registered Member
 
smartwater101's Avatar
 
Join Date: Aug 2012
Location: Los Angeles
Posts: 387
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 )


__________________
180 reef: Hippo tang. Foxface. 2 clownfish. 30+ nano gobies\blennies\cardinals

70 agro: Catalufa popeye soldier. Barred moray. Snowflake moray. Atlantic longnose butterfly. Flame hawk. Future add:
smartwater101 is offline   Reply With Quote
Old 05/23/2018, 05:28 AM   #10
RobZilla04
Registered Member
 
RobZilla04's Avatar
 
Join Date: Sep 2016
Location: St. Augustine, FL
Posts: 1,839
Very cool, thx for sharing.


__________________
90g Mixed Reef
RobZilla04 is offline   Reply With Quote
Old 06/01/2018, 01:37 PM   #11
smartwater101
Registered Member
 
smartwater101's Avatar
 
Join Date: Aug 2012
Location: Los Angeles
Posts: 387
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.


__________________
180 reef: Hippo tang. Foxface. 2 clownfish. 30+ nano gobies\blennies\cardinals

70 agro: Catalufa popeye soldier. Barred moray. Snowflake moray. Atlantic longnose butterfly. Flame hawk. Future add:
smartwater101 is offline   Reply With Quote
Old 10/17/2018, 04:22 PM   #12
Daddyrawg
Registered Member
 
Join Date: May 2018
Posts: 359
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 online now   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

Forum Jump


All times are GMT -6. The time now is 06:54 PM.


TapaTalk Enabled

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Powered by Searchlight © 2018 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-2014
User Alert System provided by Advanced User Tagging v3.3.0 (Pro) - vBulletin Mods & Addons Copyright © 2018 DragonByte Technologies Ltd.