| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Baseball help. GRAPHS
I imported XML data from the MLB's site and made a scatter plot. The
data however doesn't match up with other pics. Seems like its fliped of rotated. Also, How can i plot a pitch location. I have the coordantes but its to find where the strikezone should be. thanks for anyhelp |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Baseball help. GRAPHS
Help us here. What's the data look like? How is it supposed to look?
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ wrote in message oups.com... I imported XML data from the MLB's site and made a scatter plot. The data however doesn't match up with other pics. Seems like its fliped of rotated. Also, How can i plot a pitch location. I have the coordantes but its to find where the strikezone should be. thanks for anyhelp |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Baseball help. GRAPHS
Sorry
here;s the link to the actual data http://gd2.mlb.com/components/game/m...lmlb_1/inning/ the actual innig XMl incudle pitch location. heres what others have came up with http://www.hardballtimes.com/main/ar...anced-gameday/ Thanks On Jun 4, 4:30 pm, "Jon Peltier" wrote: Help us here. What's the data look like? How is it supposed to look? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ wrote in message oups.com... I imported XML data from the MLB's site and made a scatter plot. The data however doesn't match up with other pics. Seems like its fliped of rotated. Also, How can i plot a pitch location. I have the coordantes but its to find where the strikezone should be. thanks for anyhelp- Hide quoted text - - Show quoted text - |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Baseball help. GRAPHS
This is interesting. I've watched the gameday (and the ESPN equivalent) on
the internet, and it's interesting to see the data stream. I separated the pitches into three categories (three series): balls, called strikes, and swings. The series are somewhat grouped together, but not in any pattern I could discern. Nothing resembling a strike zone. I'm not sure what the measurements are, either. X ranges from 59 to 122. If those are inches, then it's 5 to 10 feet; if centimeters, then it's 2 to 4 feet, which might be reasonable. Y ranges from 90 to 175, which if that's inches relates to 7.5 to 14.5 feet, or if it's cm it's 3 to 5.75 feet, reasonable though the lower end is high. I think you're going to have to do a bit of research. Go to Google or to the GameDay blogs, or contact the writers at The Hardball Times, and see how they translate these numbers into pitch locations. Good luck, it looks like fun. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ wrote in message ups.com... Sorry here;s the link to the actual data http://gd2.mlb.com/components/game/m...lmlb_1/inning/ the actual innig XMl incudle pitch location. heres what others have came up with http://www.hardballtimes.com/main/ar...anced-gameday/ Thanks On Jun 4, 4:30 pm, "Jon Peltier" wrote: Help us here. What's the data look like? How is it supposed to look? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ wrote in message oups.com... I imported XML data from the MLB's site and made a scatter plot. The data however doesn't match up with other pics. Seems like its fliped of rotated. Also, How can i plot a pitch location. I have the coordantes but its to find where the strikezone should be. thanks for anyhelp- Hide quoted text - - Show quoted text - |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Baseball help. GRAPHS
This might be a reasonable starting point:
http://www.friarwatch.com/2007/04/23...-gameday-data/ - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jon Peltier" wrote in message ... This is interesting. I've watched the gameday (and the ESPN equivalent) on the internet, and it's interesting to see the data stream. I separated the pitches into three categories (three series): balls, called strikes, and swings. The series are somewhat grouped together, but not in any pattern I could discern. Nothing resembling a strike zone. I'm not sure what the measurements are, either. X ranges from 59 to 122. If those are inches, then it's 5 to 10 feet; if centimeters, then it's 2 to 4 feet, which might be reasonable. Y ranges from 90 to 175, which if that's inches relates to 7.5 to 14.5 feet, or if it's cm it's 3 to 5.75 feet, reasonable though the lower end is high. I think you're going to have to do a bit of research. Go to Google or to the GameDay blogs, or contact the writers at The Hardball Times, and see how they translate these numbers into pitch locations. Good luck, it looks like fun. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ wrote in message ups.com... Sorry here;s the link to the actual data http://gd2.mlb.com/components/game/m...lmlb_1/inning/ the actual innig XMl incudle pitch location. heres what others have came up with http://www.hardballtimes.com/main/ar...anced-gameday/ Thanks On Jun 4, 4:30 pm, "Jon Peltier" wrote: Help us here. What's the data look like? How is it supposed to look? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ wrote in message oups.com... I imported XML data from the MLB's site and made a scatter plot. The data however doesn't match up with other pics. Seems like its fliped of rotated. Also, How can i plot a pitch location. I have the coordantes but its to find where the strikezone should be. thanks for anyhelp- Hide quoted text - - Show quoted text - |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Baseball help. GRAPHS
I've tried contacting but no one responded. Thanks I look at the site.
btw- X and y go from 0 to 250 On Jun 4, 8:50 pm, "Jon Peltier" wrote: This might be a reasonable starting point: http://www.friarwatch.com/2007/04/23...-gameday-data/ - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ "Jon Peltier" wrote in message ... This is interesting. I've watched the gameday (and the ESPN equivalent) on the internet, and it's interesting to see the data stream. I separated the pitches into three categories (three series): balls, called strikes, and swings. The series are somewhat grouped together, but not in any pattern I could discern. Nothing resembling a strike zone. I'm not sure what the measurements are, either. X ranges from 59 to 122. If those are inches, then it's 5 to 10 feet; if centimeters, then it's 2 to 4 feet, which might be reasonable. Y ranges from 90 to 175, which if that's inches relates to 7.5 to 14.5 feet, or if it's cm it's 3 to 5.75 feet, reasonable though the lower end is high. I think you're going to have to do a bit of research. Go to Google or to the GameDay blogs, or contact the writers at The Hardball Times, and see how they translate these numbers into pitch locations. Good luck, it looks like fun. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ wrote in message oups.com... Sorry here;s the link to the actual data http://gd2.mlb.com/components/game/m...06/day_02/gid_... the actual innig XMl incudle pitch location. heres what others have came up with http://www.hardballtimes.com/main/ar...anced-gameday/ Thanks On Jun 4, 4:30 pm, "Jon Peltier" wrote: Help us here. What's the data look like? How is it supposed to look? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ wrote in message egroups.com... I imported XML data from the MLB's site and made a scatter plot. The data however doesn't match up with other pics. Seems like its fliped of rotated. Also, How can i plot a pitch location. I have the coordantes but its to find where the strikezone should be. thanks for anyhelp- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| baseball Statistics spreadsheet | Excel Discussion (Misc queries) | |||
| Baseball Stat Problem | Excel Discussion (Misc queries) | |||
| Baseball statistics | Excel Discussion (Misc queries) | |||
| Is there a way to make P=1, C=2, as in baseball and then add them | Excel Discussion (Misc queries) | |||
| Baseball Stat Keeping | Excel Discussion (Misc queries) | |||
Hybrid Mode
