+ Reply to Thread
Results 1 to 7 of 7

Simple pH to concentration and Concentration to pH calculator excel spread sheet FINISHED!

  1. #1
    Forum Contributor
    Join Date
    01-29-2018
    Location
    United states
    MS-Off Ver
    2019
    Posts
    242

    Simple pH to concentration and Concentration to pH calculator excel spread sheet FINISHED!

    First off I want to thank all those who made this possible. your patience and help have been outstanding with this.

    If any chem student or chemist wants a super accurate pH to concentration or Concentration to ph, please feel free to down load and use this for your work.

    I have tested it and it is accurate to +/- 2.5mg per 5 gallons. It uses a reverse quadratic formula. Now due to the sensitivity of the pH curve around 6 to 8 the values are off a little +/-20% but at a ph of 5.75 and 8.25 or higher or lower it is very accurate with acids. I have yet to try it with any bases if you do please let me know how it works for you.

    Please see attached excel sheet and thank you all once again for your help!

    Sincerely
    Brad

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Simple pH to concentration and Concentration to pH calculator excel spread sheet FINIS

    Thanks for sharing this this with us, Im sure many members will be able to use it.

    As such, Im going to move this to a better forum, more suited to this kind of post
    Tips and Tutorials
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Contributor
    Join Date
    01-29-2018
    Location
    United states
    MS-Off Ver
    2019
    Posts
    242
    You are more than welcome, i could not have done it without the community here, thanks every one!
    Quote Originally Posted by FDibbins View Post
    Thanks for sharing this this with us, Im sure many members will be able to use it.

    As such, Im going to move this to a better forum, more suited to this kind of post
    Tips and Tutorials

  4. #4
    Forum Contributor
    Join Date
    01-29-2018
    Location
    United states
    MS-Off Ver
    2019
    Posts
    242

    Re: Simple pH to concentration and Concentration to pH calculator excel spread sheet FINIS

    Just realized that the dropdown cell was locked, here is the unlocked version.

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Simple pH to concentration and Concentration to pH calculator excel spread sheet FINIS

    thanks for the update

  6. #6
    Registered User
    Join Date
    01-04-2023
    Location
    Germany
    MS-Off Ver
    MacOS
    Posts
    1

    Re: Simple pH to concentration and Concentration to pH calculator excel spread sheet FINIS

    Document is still mostly locked for me. Cheers

  7. #7
    Registered User
    Join Date
    02-21-2023
    Location
    London, UK
    MS-Off Ver
    Microsoft Office 2016 x64
    Posts
    10

    Re: Simple pH to concentration and Concentration to pH calculator excel spread sheet FINIS

    Thank you guys for this info!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 11-20-2018, 12:13 PM
  2. Replies: 4
    Last Post: 11-19-2018, 06:49 PM
  3. Challenge: creating Herfindahl index for patent concentration
    By Terence Bongolo in forum Excel General
    Replies: 10
    Last Post: 12-15-2017, 12:59 PM
  4. Replies: 5
    Last Post: 02-22-2017, 07:11 PM
  5. [SOLVED] concentration formula calculation
    By mazan2010 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-08-2016, 02:45 PM
  6. Remove units to express a concentration or strength as just a number
    By jgwhite in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-17-2012, 07:56 AM
  7. [SOLVED] Mergers - market concentration - math help
    By Duke Carey in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-02-2005, 08:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1