Write a report explaining the design of your spreadsheet and describe the graphs, which you should import.
Write a short description of the theory of buffer solutions and give examples of their applications.
The report should be a word document and an Excel spreadsheet. Describe the background theory and the methodology behind the construction of the simulation, and include the realisation of the system equations in Excel formulae. Graphs of pH against added solution over various ranges and around particular key points - such as the equivalence point or "end point".
The report should also include a discussion of the concept of buffer solutions and give examples of their use either in industrial processes or naturally occurring phenomena. Any sources should be appropriately referenced (Harvard).