Calculating Titration Curves with a Spreadsheet

By now you should understand the chemistry that occurs at different stages of a precipitation titration, and you should know how to calculate the shape of a titration curve. We now introduce spreadsheet calculations that are more powerful than hand calculations and less prone to error. If a spreadsheet is not available, you can skip this section with no loss in continuity. Consider the addition of liters of cation M+ (whose initial concentration is C ) to liters of solution containing anion X- with a concentration C%. 

The total moles of added M (= C1 VM) must equal the moles of MJ in solution (= [MxJ(Vm + V ) plus the moles of precipitated MX(i). (This equality is called a mass balance, even though it is really a mole balance). In a similar manner, we can write a mass balance for X. 

Now equate mol MX(.v) from Equation 7-16 with mol MX(.v) from Equation 7-17  

---