I will preface my request by stating that I know a little about excel and formulas, but I know very little to the programming/macro side of things.
I want to import the following information, if anyone knows of a better source I'm open:
Power Ranking: http://espn.go.com/mlb/powerrankings
I want to create a spreadsheet or report that will import certain data from the web. In my mind it look like this:
Date Teams Starting Pitchers FIB ERA Series Line Road Average FIB Home Average FIB 7/26/2012 Mets Harvey 0 +xxx Diamondbacks Miley 3.39 3.09 -yyy 7/27/2012 Mets Niese xxx xxx Power Ranking Road Average ERA Home Average ERA Diamondbacks Collmenter yyy yyy 7/28/2012 Mets Young xxx xxx Diamondbacks Kennedy yyy yyy 7/29/2012 Mets Dickey xxx xxx Diamondbacks Saunders yyy yyy