+ Reply to Thread
Results 1 to 1 of 1

Anyone knows excel and Chemistry, need help with an acid base calculator for students

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

    Anyone knows excel and Chemistry, need help with an acid base calculator for students

    Hello Everyone

    It has been some time since my last post here and I thank everyone for their help.
    I have been working on my pH calculator I have been able to get the acids and base calculators to work independently very accurately of each other and anyone who I am permitting use license free of the attached book.

    However I need some help to get the acids and bases to work together to create a pH of an acid and base reaction, ergo I need someone to lend me a hand who is familiar with chemistry

    This is where I stand

    I have 500ml of 2M of H3PO4, this gives me a H+ concentration of .1188 which has a pH of .9253 Easy enough.

    I have a 100ml of 0.0143M of NaOH which gives me a OH- concentration of .01339 which has a pH of 12.1458 again easy enough.

    To me I should just be able to take the .1188 and subtract the .01339 which would give us an H+ excess of .1048 which would equate to a pH of .97970 however find with several calculators it reports the pH at .927- .93 which is more acidic. even IF I take into consideration the amount of water formed in the reaction which would make the solution more base than the .97970.

    What am I doing wrong? the challenge is here I do not want to use the moles value of the excess i.e. of the H3PO4 as there will be other multiproteic acids like EDTA added in to calculate the pH of multiple acids and bases.

    I want to be able to extend this out to use up to 24 different acids and bases, up to 12 acids and up to 12 bases. Hence WHY I prefer if possible to use the H+/OH- concentration rather than the individual chemicals and their reactions.

    Can anyone tell me what I am doing wrong and could lend a hand.
    Attached Files Attached Files

+ 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. Excel MiniSheet Calculator within a sheet / Flyout Calculator
    By Escavell in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-03-2020, 07:54 AM
  2. Replies: 1
    Last Post: 06-29-2020, 12:04 PM
  3. [SOLVED] Help creating a base calculator
    By kungfool in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-28-2013, 04:27 PM
  4. [SOLVED] Remove the Absent Students from the List of Failing Students
    By alyaahmed in forum Excel General
    Replies: 2
    Last Post: 03-28-2013, 01:40 PM
  5. [SOLVED] Hill notation/sort (chemistry) in Excel
    By MrShorty in forum Excel General
    Replies: 5
    Last Post: 06-09-2011, 12:33 PM
  6. chemistry lab help graph
    By momentthatisfate in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-26-2010, 12:16 PM
  7. [SOLVED] Integrated calculator in excel 07 instead of separate calculator
    By Wayne in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2006, 11:20 AM

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