Spreadsheet: 852859d1702847993-anyone-knows-excel-and-chemistry-need-help-with-an-acid-base-calculator-for-students-final-ph-augmenting-for-mutiple-acids
Sheet: pH calculator (2)

the above selections are not yet coded nor active |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | this video https://www.youtube.com/watch?v=0uzC7QzwX_o, my calculator [NAME] all line up perfectly for H3PO4
Enter values in blue |  |  |  | For Acids |  |  | Calculations for acids |  |  |  |  | Quadratic equation for acid calculations |  |  |  | H value per dissassociation | Total H+/ A- value |  | Resulting values for acids |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ka = [H+][A-]/[HA]
Do you wish to use the Arrhenius (B(OH), B+)or Bronsted-Lowry names (B-, BH+) for the bases? |  |  |  | Chemical name or formula | H3PO4 |  | Enter the PKA values in blue, Table will self propigate |  |  |  |  | (a) volume | (b) Ka1 | C initial Molarity |  | X= | H+ |  | moles | Molar concentration (moles per L) | Acid type | H+ | OH- | pH | pOH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kb = [B+][OH-]/[BOH]
Do you want to calculate the water dissassociation constant? | YES |  |  | Enter grams of substance | 97.9952 |  | pKa 1 |  |  | pKb 1 |  |  |  |  | q= |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BOH=(B+)*(OH-)/KB)
Initial pH of the water,  (please tick the red triangle to see note) | 7 |  |  | Entered desired number of Liters | 0.5 |  | pKa 2 |  |  | pKb 2 |  | 1 |  |  | q=
Temprature correction in degrees C,  (tick the red triangle to see note) | 25 |  |  | Enter [NAME] | 97.9952 |  | pKa 3 |  |  | pKb 3 |  | 1 |  |  | q= |  |  |  |  |  |  |  |  |  |  | Total molar concentration
Displacement will affect the pH |  |  |  | Enter Purity of substance % | 100 |  | pKa 4 |  |  | pKb 4 |  | 1 |  |  | q=
are you adding the compound to a measured amount of water? i.e.30g of NaOH to 1 liter of water |  |  |  | Enter pKa 1 value | 2.125 |  | pKa 5 |  |  | pKb 5 |  | 1 |  |  | q= |  |  |  |  |  |  |  |  |  |  | Total Percent
 |  |  |  | Enter pKa 2 value | 7.21 |  | pKa 6 |  |  | pKb 6 |  | 1 |  |  | q=
are you adding water to the compound i.e. 30g of NaOH then adding sufficient water to make 1 Liter? |  |  |  | Enter pKa 3 value | 12.32 |  | Ka 1 |  |  | Kb 1
 |  |  |  | Enter pKa 4 value |  |  | [NAME] |  |  | Kb 2
 |  |  |  | Enter pKa 5 value |  |  | [NAME] |  |  | Kb 3
need to calculate the amount of water formed from the H+/OH- reaction and add it to the final volume |  |  |  | Enter pKa 6 value |  |  | [NAME] |  |  | Kb 4
 |  |  |  | Total weight of pure substance |  |  | Ka 5 |  |  | Kb 5
Moles calculation given molarity and volume for acids |  |  |  |  |  |  | Ka 6 |  |  | Kb 6
n=C*V
Concentration (M)   (C) | 2 | l
volume in ml | 1000 | ml |  | For Bases |  |  | Calculations for bases |  |  |  |  | Quadratic equation for base calculations |  |  |  | H value per dissassociation | Total OH- value |  | Resulting values for bases
volume in L    (V) |  | l |  | Chemical name or formula | NaOH |  | Enter the PKA values in blue, Table will self propigate |  |  |  |  | (a) volume | (b) Kb1 | C initial Molarity |  | X= OH- | OH- |  | moles | Molar concentration (moles per L) | Base type | OH- | H+ | pH | pOH
Mol (m)    (N) |  | moles |  | Enter grams of substance | 0.057195853 |  | pKa 1 |  |  | pKb 1 |  |  |  |  | q=
Molar mass |  |  |  | Entered desired number of Liters | 0.1 |  | pKa 2 |  |  | pKb 2 |  | 1 |  |  | q= |  |  |  | these 2 names are flip flopped
[NAME] of substance needed per Liter |  | grams/ L |  | Enter Atomic mass | 39.9971 |  | pKa 3 |  |  | pKb 3 |  | 1 |  |  | q= |  |  |  |  |  |  |  |  |  |  | Total molar concentration
Mg of substance needed per Liter |  | mg/L |  | Enter Purity of substance % | 100 |  | pKa 4 |  |  | pKb 4 |  | 1 |  |  | q= |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Arrhenius base names | pka 1 | B(OH) mole/L | [NAME] mole/L
 |  |  |  | Enter pKa 1 value | 13.8 |  | pKa 5 |  |  | pKb 5 |  | 1 |  |  | q= |  |  |  |  |  |  |  |  |  |  | % |  |  |  |  |  |  |  | B(OH) % | [NAME]
 |  |  |  | Enter pKa 2 value |  |  | pKa 6 |  |  | pKb 6 |  | 1 |  |  | q= |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | pka2 | B(OH)2 mole/L | B(OH)+ mole/L | B2+ mole/L
 |  |  |  | Enter pKa 3 value |  |  | Ka 1 |  |  | Kb 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B(OH)2 % | BOH+ % | B2+%
Moles calculation given molarity and volume for Base |  |  |  | Enter pKa 4 value |  |  | [NAME] |  |  | Kb 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | pka3 | B(OH)3 mole/L | B(OH)2+ mole/L | B2(OH)+ mole/L | B3+ mole/L
n=C*V |  |  |  | Enter pKa 5 value |  |  | [NAME] |  |  | Kb 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B(OH)3 % | B(OH)2+ % | B2(OH)+ % | B3+ %
Concentration (M)   (C) | 0.0143 | l |  | Enter pKa 6 value |  |  | [NAME] |  |  | Kb 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | pka4 | B(OH)4 mole/L | B(OH)3+ mole/L | B2(OH)2+ mole/L | B3(OH)+ mole/L | B4+ mole/L
volume in ml | 100 | ml |  | Total weight of pure substance in g |  |  | Ka 5 |  |  | Kb 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B(OH)4 % | B(OH)3+ % | B2(OH)2+ % | B3(OH)+ % | B4+ %
volume in L    (V) |  | l |  |  |  |  | Ka 6 |  |  | Kb 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | pka5 | B(OH)5 mole/L | B(OH)4+ mole/L | B2(OH)3+mole/L | B3 (OH)2+mole/L | B4(OH)+ mole/L | B5+ mole/L
Mol (m)    (N) |  | moles |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B(OH)5 % | B(OH)4+ % | B2(OH)3+% | B3 (OH)2+% | B4(OH)+ % | B5+ %
Molar mass |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | pka6 | B(OH)6 mole/L | B(OH)5+ mole/L | B2(OH)4+mole/L | B3(OH)3+mole/L | B4(OH)2+ mole/L | B5(OH)+ mole/L | B6+ mole/L
[NAME] of substance needed per Liter |  | grams/ L |  | For Acids |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B(OH)6 % | B(OH)5+ % | B2(OH)4+% | B3(OH)3+% | B4(OH)2+ % | B5(OH)+ % | B6+ %
Mg of substance needed per Liter |  | mg/L |  | Chemical name or formula | H3
 |  |  |  | Enter grams of substance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bronsted-Lowry base names | pka 1 | B - mole/L | BH+ mole/L
 |  |  |  | Entered desired number of Liters | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B - % | BH+ %
 |  |  |  | Enter Molar Mass | 19.0232 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | pka 2 | B - mole/L | BH+ mole/L | BH22+ mole/L
 |  |  |  | Enter Purity of substance % | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B - % | BH+ % | BH22+ %
 |  |  |  | Enter pKa 1 value | -1.74 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | pka 3 | B - mole/L | BH+ mole/L | BH22+ mole/L | BH33+ mole/L
 |  |  |  | Enter pKa 2 value |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B - % | BH+ % | BH22+ % | BH33+ %
 |  |  |  | Enter pKa 3 value |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | pka 4 | B - mole/L | BH+ mole/L | BH22+ mole/L | BH33+ mole/L | [NAME]
 |  |  |  | Enter pKa 4 value |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B - % | BH+ % | BH22+ % | BH33+ % | BH44+ %
 |  |  |  | Enter pKa 5 value |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | pka 5 | B - mole/L | BH+ mole/L | BH22+ mole/L | BH33+ mole/L | [NAME] | BH55+ mole/L
 |  |  |  | Enter pKa 6 value |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B - % | BH+ % | BH22+ % | BH33+ % | BH44+ % | BH55+ %
 |  |  |  | Total weight of pure substance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | pka 6 | B - mole/L | BH+ mole/L | BH22+ mole/L | BH33+ mole/L | [NAME] | BH55+ mole/L | BH66+ mole/L
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B - % | BH+ % | BH22+ % | BH33+ % | BH44+ % | BH55+ % | BH66+ %
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total molar concentration
 | . |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | %
 |  |  |  |  |  |  | Calculations for Acid and base mix |  |  |  |  |  |  |  |  | H value per dissassociation
 |  |  |  |  |  |  | Enter the PKA values in blue, Table will self propigate
 |  |  |  |  |  |  | pKa 1 |  |  | pKb 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.49 ph per chem buddy
 |  |  |  |  |  |  | pKa 2 |  |  | pKb 2 |  |  |  |  |  | 0.001023386053731955
 |  |  |  |  |  |  | pKa 3 |  |  | pKb 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total molar concentration
 |  |  |  |  |  |  | pKa 4 |  |  | pKb 4
 |  |  |  |  |  |  | pKa 5 |  |  | pKb 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Percent
 |  |  |  |  |  |  | pKa 6 |  |  | pKb 6
 |  |  |  |  |  |  | Ka 1 |  |  | Kb 1
 |  |  |  |  |  |  | [NAME] |  |  | Kb 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total molar concentration
 |  |  |  |  |  |  | [NAME] |  |  | Kb 3
 |  |  |  |  |  |  | [NAME] |  |  | Kb 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | %
 |  |  |  |  |  |  | Ka 5 |  |  | Kb 5
 |  |  |  |  |  |  | Ka 6 |  |  | Kb 6
 |  |  |  |  |  |  |  | 25ml of .3 H2SO4 mixed with [NAME] m [NAME] = a ph of 1.114 My calculator shows 2.629 Chem buddy says 2.49 https://www.youtube.com/watch?v=GlJ4LltZkSw
 |  |  |  |  |  |  |  | 50 ml of .1m H2SO4 is mixed with 25ml of .15m of NaOH = pH 1.08  my calculator says 2.185,  chem buddy calculator says 2.33 https://www.youtube.com/watch?v=xs-DDMXrjhQ&t=292s