Thanks for your response Martin. I'll start plugging some numbers into your spreadsheet and see how it all comes together.
Edit: When entering the water information in your spreadsheet and indicating a pale ale, it appears all I would need to do is add about .5gram/gal of calcium chloride...