Disc_4 - 3. Open Solver 4. For "Set target...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
CEE 320 Disc #4 Feb. 15, 2010 This spreadsheet is meant to assist you in learning to solve equilibrium equations using  general spreadsheet techniques or Solver.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Knowns: Kw 0 Ka1 0 Ka2 0 Kh 0.03 M/atm PCO2 2 atm T 298 pH [H+] [OH-] [H2CO3*] [HCO3-] [CO32-] EN -2 100 0 0.07 0 0 100 -1 10 0 0.07 0 0 10 0 1 0 0.07 0 0 1 1 0.1 0 0.07 0 0 0.1 2 0.01 0 0.07 0 0 0.01 3 0 0 0.07 0 0 0 4 0 0 0.07 0 0 0 5 0 0 0.07 0 0 0 6 0 0 0.07 0.03 0 -0.03 7 0 0 0.07 0.3 0 -0.3 8 0 0 0.07 3.04 0.01 -3.07 9 0 0 0.07 30.37 1.42 -33.22 10 0 0 0.07 303.74 142.07 -587.89 11 0 0 0.07 3037.45 14207.21 -31451.88 12 0 0.01 0.07 30374.48 1420721.37 -2871817.23 13 0 0.1 0.07 303744.84 142072136.9 ### 14 0 1 0.07 3037448.43 ### ### 3 0 0 0.07 0 0 0 3.1 0 0 0.07 0 0 0 3.2 0 0 0.07 0 0 0 3.3 0 0 0.07 0 0 0 3.4 0 0 0.07 0 0 0 3.5 0 0 0.07 0 0 0 3.6 0 0 0.07 0 0 0 3.7 0 0 0.07 0 0 0 3.8 0 0 0.07 0 0 0 3.9 0 0 0.07 0 0 0 4 0 0 0.07 0 0 0 3.7 0 0 0.07 0 0 0 3.71 0 0 0.07 0 0 0 3.72 0 0 0.07 0 0 0 3.73 0 0 0.07 0 0 0 3.74 0 0 0.07 0 0 0 3.75 0 0 0.07 0 0 0 3.76 0 0 0.07 0 0 0 3.77 0 0 0.07 0 0 0 3.78 0 0 0.07 0 0 0 3.79 0 0 0.07 0 0 0 3.8 0 0 0.07 0 0 0
Background image of page 2
Knowns: Kw 0 Ka1 0 Ka2 0 Kh 0.03 M/atm PCO2 2 atm T 298 [H+] EN #DIV/0! pH Solver Instructions 1. Select a cell that will represent [H+] (B9) 2. Generate EN equation where only [H+] is unknown
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 3. Open Solver 4. For "Set target cell", we want to select cell B10 because that is the EN equation (EN=0) 5. Set the target cell to a "value of" and enter 0. 6. Then select the [H+] concentration to be the value that is changed to solve for EN=0 (select B9) 7. Hit solve....
View Full Document

Page1 / 3

Disc_4 - 3. Open Solver 4. For "Set target...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online