Downloadable Stats/Abilities

[wichart]

I'm looking for a tool that will allow me to dump stats and attributes to an Excel spreadsheet rather than HTML files like MVPSavReader does. Is anyone interested in developing such a thing? I'm particularly interested in having an easy way to output player info combined with at least some of the data from the Edit Player pages (like star potential, movement, control, and speed of pitches); and of course salary info for players from all teams. I would also like to be able to get a player's stats from each level of play during the season. One of the problems with tracking player stats in MVP is that I can't see the MLB stats of a player who got demoted to AAA at the end of the year, and the Career Stats page only shows a small sample of the actual career stats. That boggles my mind, especially at the non-MLB levels where I know they have to track all the stats, but they just aren't displaying them (for example, TB is necessary in order to calculate SLG, but only one of those stats is displayed, and it's on the Player Info page rather than the Batting Stats page. Bizarre.).

I would be more than happy to do the work myself, but I code at about a 5th grade level, so even if I knew where to start it would probably take me 5 years. MVPSavReader is quite helpful for gathering contract info, but it's missing some of the abilities I want, and it doesn't seem to offer pages that list player stats or abilities for the whole league (or at least a whole team at a time). Also, it has some problems with overwriting team pages since the 3-letter codes it uses are not unique (for example, COL for Colorado Rockies, Colorado Springs Rock Hounds (?), and Columbus Clippers). I'm willing to pay if you're reasonably priced. It takes about a month for me to manually type out all the info I'm trying to record each season). (yes, I'm a huge stats geek)

[tywiggins]

I'm looking for a tool that will allow me to dump stats and attributes to an Excel spreadsheet rather than HTML files like MVPSavReader does. Is anyone interested in developing such a thing? I'm particularly interested in having an easy way to output player info combined with at least some of the data from the Edit Player pages (like star potential, movement, control, and speed of pitches); and of course salary info for players from all teams. I would also like to be able to get a player's stats from each level of play during the season. One of the problems with tracking player stats in MVP is that I can't see the MLB stats of a player who got demoted to AAA at the end of the year, and the Career Stats page only shows a small sample of the actual career stats. That boggles my mind, especially at the non-MLB levels where I know they have to track all the stats, but they just aren't displaying them (for example, TB is necessary in order to calculate SLG, but only one of those stats is displayed, and it's on the Player Info page rather than the Batting Stats page. Bizarre.).

I would be more than happy to do the work myself, but I code at about a 5th grade level, so even if I knew where to start it would probably take me 5 years. MVPSavReader is quite helpful for gathering contract info, but it's missing some of the abilities I want, and it doesn't seem to offer pages that list player stats or abilities for the whole league (or at least a whole team at a time). Also, it has some problems with overwriting team pages since the 3-letter codes it uses are not unique (for example, COL for Colorado Rockies, Colorado Springs Rock Hounds (?), and Columbus Clippers). I'm willing to pay if you're reasonably priced. It takes about a month for me to manually type out all the info I'm trying to record each season). (yes, I'm a huge stats geek)

What would you consider "reasonably priced"?

[wichart]

Without knowing approximately how much time/effort it would take, it's hard to say what's reasonable. I'd be willing to part with a couple hundred dollars for it though. Maybe more if that's too low.

You may want more complete specs than what I listed above. I can email or post samples of the spreadsheets I've been creating manually if that would help.

[tywiggins]

Without knowing approximately how much time/effort it would take, it's hard to say what's reasonable. I'd be willing to part with a couple hundred dollars for it though. Maybe more if that's too low.

You may want more complete specs than what I listed above. I can email or post samples of the spreadsheets I've been creating manually if that would help.

Yeah. Show me some samples. $200 sounds fine for what you want done. I'm willing to do it for that price.

[DJEagles]

WTF????

[DylanBradbury]

Yeah. Show me some samples. $200 sounds fine for what you want done. I'm willing to do it for that price.

If I had Ty's programming ability, I'd deliver it by hand for that price.

[MarkB]

If we're seriously considering someone creating a program for this for $200, I have to wonder why someone doesn't just write a basic script that exports the data from the HTML page generated from MVPSavReader, then put that into a spreadsheet, rather than writing a whole new program for it, at an exorbitant cost.

[MarkB]

wichart, can you post a link to a HTML page generated by MVPSavReader? I've never used it and don't have MVP installed on a system where I am right now.

[wichart]

This would be the place to start if you want to look at the excel sheets I put together by hand, and also the HTML files that get generated by MVPSavReader.

http://www.public.asu.edu/~wichart/MVPSavReaderInfo/excelfiles.htm

On the stats spreadsheets, look for a tab that says 2008. The other tabs have things like season stats for all active MLB players (just started on the pitching stats). I use these to load into an Access database so that I can compile full career stats reports (that's why I have the "true" and "false" fields for awards too).

I wouldn't expect any output from a program to be formatted. I just want the raw data. If possible, I'd be interested in the output including splits for people who were traded or demoted during the season. For example, if a player batted on the MLB level for Detroit, then got traded to Arizona, batted at the MLB level there, then got demoted to Reno, I would want the output to list one row for Detroit and one for Arizona. I don't care about minor league stats.

MarkB, MVPSavReader doesn't appear to include one of the pieces of data I'm interested in... the "ratings" for each pitcher's individual pitches. I had posted something (though not in the Mod Request section) a couple of months ago about my desire to have a program to output these things to Excel, but I never got a response. I figured I might get better results by offering some incentive. It takes me about 100 hours per season to gather this info by hand, so $200 is a small price to save that much time.

[MarkB]

Hmmm...I'm wondering if the pitch ratings could be obtained and exported by other means, in addition to MVPSavReader, like by reading the .dat files and writing to a spreadsheet from there. I'm way too tired to figure it out just now, but here's a few links I came across while searching last night. They may help, they may not.

http://office.microsoft.com/en-us/excel/HA010450851033.aspx

http://www.webdeveloper.com/forum/showthread.php?t=187527

http://www.codetoad.com/forum/16_23220.asp

[wichart]

BTW, is there a mod out there for MVP 2008 to have correct schedules? Teams are supposed to play their division opponents 18 times, but my team is only scheduled to play each of them 12 times.

[krawhitham]

If I had Ty's programming ability, I'd deliver it by hand for that price.

You would be bankrupt in no time taking jobs like this, and real tired

2253 miles one way

http://tinyurl.com/2vnxcvt

Lets assume your car gets 50 miles per gallon (I must say you have a damn nice car)

average gas price is $2.834 http://www.eia.doe.gov/oil_gas/petroleum/data_publications/wrgp/mogas_home_page.html

(4506 miles / 50) * 2.834

so it would cost you $255.40 to deliver it by hand and take 74 hours (assuming you need no sleep) to do it

[DJEagles]

You would be bankrupt in no time taking jobs like this, and real tired

2253 miles one way

http://tinyurl.com/2vnxcvt

Lets assume your car gets 50 miles per gallon (I must say you have a damn nice car)

average gas price is $2.834 http://www.eia.doe.gov/oil_gas/petroleum/data_publications/wrgp/mogas_home_page.html

(4506 miles / 50) * 2.834

so it would cost you $255.40 to deliver it by hand and take 74 hours (assuming you need no sleep) to do it

LOL. That's a funny post.

[DylanBradbury]

You would be bankrupt in no time taking jobs like this, and real tired

2253 miles one way

http://tinyurl.com/2vnxcvt

Lets assume your car gets 50 miles per gallon (I must say you have a damn nice car)

average gas price is $2.834 http://www.eia.doe.g..._home_page.html

(4506 miles / 50) * 2.834

so it would cost you $255.40 to deliver it by hand and take 74 hours (assuming you need no sleep) to do it

Haha.

Well since I can't drive and don't have a car, I'd probably end up walking.

[MysteriousGuy]

I can't open the first two databases.

[MarkB]

I can't open the first two databases.

I hope I'm not alone in having absolutely no idea what you're talking about.

[Yankee4Life]

I hope I'm not alone in having absolutely no idea what you're talking about.

There are two databases and he can't open up both of them.

I got your back my pal.

[MarkB]

Indeed, but...which databases? Where?

[Yankee4Life]

Indeed, but...which databases? Where?

This is where I bail on you man. I have no idea. :)

[DylanBradbury]

This is where I bail on you man. I have no idea.

The databases in this post:

http://www.mvpmods.com/index.php?showtopic=46041&view=findpost&p=601098

[MarkB]

That's what I was thinking at first, but those are spreadsheets. :blink:

[DylanBradbury]

That's what I was thinking at first, but those are spreadsheets.

I think that's what he meant by databases. If not, then I have no idea.

[MarkB]

God, I hope not. :lol:

[wichart]

Ty has withdrawn from this project. Is anyone else interested? The $200 offer still stands.

Or, can anyone tell me how one would open the .sav file in a readable format? I work with a bunch of programmers. If I could just tell them how to get to the info that's stored in the .sav file, I'm sure one of them could write an application that would output the data to a .csv file for me.