The Prestige Model Project Topic

Since the last prestige calculation adjustment, which has been well over a year if I'm not mistaken, I'd say we now have enough data that would could figure out HD's prestige calculation formula.

Do any programmers out there have the chops to pull the data on this? We'd need to pull the "History" and "Drafted" pages from every team in the game into Excel.

From there, and using our best estimates for baseline prestige for each school, we'd try and replicate prestige calculation by adjusting the weights on the known prestige criteria and the "score ranges" for each grade.

I think this would be a fun project, but I wouldn't know where to begin with pulling the data. Anyone want in?
2/28/2014 3:54 PM
You don't need the drafted page. If your prestige rises as a result of player getting drafted, the history page prestige doesn't actually change. 
2/28/2014 4:03 PM
oh cool, never noticed that!
3/1/2014 1:19 AM
I believe you will also need to factor in coach changes as well. I have seen teams prestige go up or down when a new coach takes over and that does change on the history page.
3/1/2014 3:27 AM
its a lot of data jet, 10,000 teams with about 60-70 rows each (one per season). how would you be looking to receive said data? you'd need baseline prestige as well.
3/1/2014 12:47 PM
Posted by Weena on 3/1/2014 3:27:00 AM (view original):
I believe you will also need to factor in coach changes as well. I have seen teams prestige go up or down when a new coach takes over and that does change on the history page.
Good point, that's a pretty complex factor too.
3/1/2014 1:18 PM
Posted by gillispie1 on 3/1/2014 12:47:00 PM (view original):
its a lot of data jet, 10,000 teams with about 60-70 rows each (one per season). how would you be looking to receive said data? you'd need baseline prestige as well.
Yup, quite a lot. Something like csv format, 750,000 lines total
3/1/2014 1:21 PM
i have an excel spreadsheet with all of that.. but i last updated in november i think.  
i am a brute force ameteur at those kind of things... wish i knew how to do things more efficiently but i enjoy it just the same ...   the way i did it i think it took about 3 hours per world  to pull or scrape (or whateever the word is) the histories and sort them like i wanted. i mainly   actually it may have been 3 hours per each division of each world,  cant remember.  did alot of stuff with the the d3 data,  a little with d2  and hardly any with d1.

would love to help or be involved with the prestige thing if there is any way i can help or data i can provide

 this kind of stuff is almost more interesting to me than the game itself.  
and my abilities as a programmer or data analyst or statistician or whatever are very comparable to my abilities to coach a real life college hoops team.
3/1/2014 1:58 PM
i pull the history data when i run dynasty lists but its been ages. im not sure what format its saved in, ill check and get back to you

oldave that sounds so horrible i cannot possibly imagine going through that :O
3/1/2014 7:29 PM
Posted by jetwildcat on 3/1/2014 1:18:00 PM (view original):
Posted by Weena on 3/1/2014 3:27:00 AM (view original):
I believe you will also need to factor in coach changes as well. I have seen teams prestige go up or down when a new coach takes over and that does change on the history page.
Good point, that's a pretty complex factor too.
How much would its omission affect the results, do ya reckon?
3/1/2014 9:18 PM
It's really just a simple web scrape iterating over the entire list of teams in all worlds by their ID. It would probably take longer to run the program than to code it. If you know the range of the team IDs I could code something up pretty quickly.
3/2/2014 7:08 PM (edited)
Posted by gillispie1 on 3/1/2014 7:30:00 PM (view original):
i pull the history data when i run dynasty lists but its been ages. im not sure what format its saved in, ill check and get back to you

oldave that sounds so horrible i cannot possibly imagine going through that :O
i hope it didnt sound like i was manually cut and pasting one team at a time or something.  its just the function i was using for some reason glitches up after about 100 loops.  so ya gotta restart the macro alot and it probably does take 10-15 seconds to grab one team the way i do it and with my connection

maybe thats still  horrible though,

but to a worm in horseradish, the whole world is horseradish.


3/2/2014 7:30 PM
Posted by llamanunts on 3/1/2014 9:18:00 PM (view original):
Posted by jetwildcat on 3/1/2014 1:18:00 PM (view original):
Posted by Weena on 3/1/2014 3:27:00 AM (view original):
I believe you will also need to factor in coach changes as well. I have seen teams prestige go up or down when a new coach takes over and that does change on the history page.
Good point, that's a pretty complex factor too.
How much would its omission affect the results, do ya reckon?
Not much at all at D1, IMO, but it could be a big factor for some D3 and D2 schools. But overall I don't think it'll be a major impact .
3/2/2014 7:35 PM
Posted by stinenavy on 2/28/2014 4:03:00 PM (view original):
You don't need the drafted page. If your prestige rises as a result of player getting drafted, the history page prestige doesn't actually change. 
But you still have to factor the impact because let's say a school goes from a B+ to A- as a result of draft picks (which won't be reflected on the history page) and the next season has a season that if it were not for already being an A- would have kept the school at a B+, so the draft impacted the prestige bump that will show up in the history page. 

I feel like that example came off much more confusing then it was in my head. Lol.
3/2/2014 7:37 PM
Posted by theploww on 3/2/2014 7:08:00 PM (view original):
It's really just a simple web scrape iterating over the entire list of teams in all worlds by their ID. It would probably take longer to run the program than to code it. If you know the range of the team IDs I could code something up pretty quickly.
The range of team IDs appears to go from 11785 to 14736, although I think I may be missing some because that would total to a number not evenly divisible by the 10 worlds. With this range I could easily scrape the historical prestige information for each team, but the problem comes from the fact that the actual team name is nowhere in text on any of the team pages (the name at the top is an image) so it can't be scraped. If someone has a list of each team name/id combo I could combine that with the scraped prestiges to get exactly what you're looking for.
3/2/2014 8:36 PM
12 Next ▸
The Prestige Model Project Topic

Search Criteria

Terms of Use Customer Support Privacy Statement

© 1999-2026 WhatIfSports.com, Inc. All rights reserved. WhatIfSports is a trademark of WhatIfSports.com, Inc. SimLeague, SimMatchup and iSimNow are trademarks or registered trademarks of Electronic Arts, Inc. Used under license. The names of actual companies and products mentioned herein may be the trademarks of their respective owners.