Spreadsheet logarithm concentration diagram

Below we will show how such equilibria can be visualized in logarithmic concentration diagrams. The corresponding spreadsheets are often very useful for pH calculations. 

In order to answer the above question regarding the pH of 0.1 M acetic acid, we consult the logarithmic concentration diagram for a monoprotic weak acid with C= 0.1 M and Ka 10-4 76 M, and find the pH for which (4.2-2) is satisfied. Below we will use the spreadsheet to find that pH. 

Now we are ready to make the corresponding logarithmic concentration diagram. We will use the IF statement of the spreadsheet to determine whether or not a precipitate will be present, and let the calculation selfadjust accordingly. 

---