smartwater101
Valuable Member
- Review score
- +0 /0 /-0
R2R Supporter
Build Thread Contributor
For those of you who use something like google sheets, I made this to include the margin of error in my spreadsheet. (row 4 is what you want to be looking at, row 5 is just an example) It also makes it so the range can't go negative. Just drop your Hanna results into A4 and you're good to go!
B4) =A4*3.066/1000
C4) =MAX(ROUND(((A4-5)*3.066/1000)*0.95,3) , 0 )&" - "&MAX(ROUND(((A4+5)*3.066/1000)*1.05,3) , 0 )
Enjoy!![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
![VqEKnin.jpg](/proxy.php?image=https%3A%2F%2Fi.imgur.com%2FVqEKnin.jpg&hash=1e48bab3d586c18a21567ed0e5add664)
B4) =A4*3.066/1000
C4) =MAX(ROUND(((A4-5)*3.066/1000)*0.95,3) , 0 )&" - "&MAX(ROUND(((A4+5)*3.066/1000)*1.05,3) , 0 )
Enjoy!