|
|||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
 |
|
|
LinkBack | Thread Tools | Search this Thread | Display Modes |
05-04-2007, 03:09 PM
|
#1 (permalink) |
|
All Star Starter
Join Date: Aug 2003
Location: Kenosha, Wisconsin
Posts: 1,812
|
Random Debut Database Creator Utility...
I have created a tool to create Random Debut Databases in the Lahman Format. It does require MS Access and MS Excel (w/analysis pack) to work but I have had a blast today bringing in different players today.
For those that want it I will clean it up a bit and see if PadreFan would like to host and I will also post it on F. Montoya's site also. I may also put up a folder with 10 different random debut databases for download and then you could select the one you want. The ACCESS database has a report for all the player's debut years also. This was basically the same thing I did for my OOTP5 Random Debut Database. I used Lahmans for this project but those who want to use another database as the base could very easily do it by importing the batting, pitching, fielding, fieldingOF files into the access database. Cheers! Regards, Sandman |
|
|
|
05-04-2007, 09:52 PM
|
#3 (permalink) | |
|
All Star Starter
Join Date: Aug 2003
Location: Kenosha, Wisconsin
Posts: 1,812
|
Quote:
I even made it real easy to use. Run two macros, import the excel table, run another macro, export tables back to csv files. I have been playing this non-stop today. I added another feature. It bothered me that all the old-time players would have the bad defensive ratings (FA) so I created a error adjustment table and used this to normalize all fielding across the board. Perhaps I may do this for pitching and hitting, but for now I think it is neat to see homerun hitters in the same league as deadball era hitters and pitchers.... |
|
|
|
|
|
05-07-2007, 02:38 AM
|
#5 (permalink) |
|
Hall Of Famer
Join Date: Dec 2001
Location: In a van, down by the river
Posts: 2,234
|
I don't think I got the intended results. When I imported the players, it only had 120 players available for the first draft. Any clue what I may have done wrong. I set the first year to 2001 and the last year was 2107 and then I imported the 2001 year. Any help?
__________________
Sometimes the best laid plans will never get you laid the way you plan. |
|
|
|
|
05-07-2007, 01:18 PM
|
#6 (permalink) | |
|
All Star Starter
Join Date: Aug 2003
Location: Kenosha, Wisconsin
Posts: 1,812
|
Quote:
What year does your league start? If you want to start in 2001 you must have the random debut setup for something like 1997 as the start year. Depending on how many players and how many teams you have. I did not put this in the read me because I assumed everyone would start in 1901 and use the defaults - my bad.. You should have about 160 players per year. If you use 4 years before the league starts as the start year the will give you 640 players or about 40 players for a 16 team league. If you need more players just start the debut year earlier..... Also, it is probably best to sim about 10 seasons before your actual league start. This will get more older players into the game. If you have only 4-5 years as the debut year then your players all fit between the 22-27 range. Sim some years and you will get a good mix of all player ages.....or if it doesnt bother you just start at the first year.... both work great. Hope this helps,. Regards, Sandman |
|
|
|
|
|
05-07-2007, 01:22 PM
|
#7 (permalink) | |
|
All Star Starter
Join Date: Aug 2003
Location: Kenosha, Wisconsin
Posts: 1,812
|
Quote:
Quick question - Did you find the utility easy to use? I want to make it as easy as possiblem, hence the macros. And did you use the key players debut query to see where the stars debut? Just curious. |
|
|
|
|
|
05-08-2007, 04:45 PM
|
#8 (permalink) |
|
All Star Reserve
Join Date: Dec 2001
Location: Carlsbad, CA
Posts: 627
|
Put this up on my site today...
__________________
XBL/PSN: Leadfoot5 Everywhere else: PadresFan104 PadresFan Adds-On Central Info:http://www.ootpdevelopments.com/boar...od-thread.html Text Sim Mod-File Website: http://www.padresfanmods.net |
|
|
|
05-08-2007, 05:58 PM
|
#11 (permalink) | |
|
All Star Starter
Join Date: Aug 2003
Location: Kenosha, Wisconsin
Posts: 1,812
|
Quote:
|
|
|
|
|
|
05-08-2007, 08:57 PM
|
#12 (permalink) |
|
Minors (Double A)
Join Date: Apr 2006
Location: Philadelphia
Posts: 175
|
Wow this is awesome, great job man. I can't wait untill Thursday when I'll really be able to get into this more deep, but from what I haev seen so far this is great.
Just curious also, Sandman, were you ever on Sports Crowd, or NFL Now, or other vast forums?
__________________
A Dynasty in the Making: Washington Nationals ^ My Nationals dynasty, comments welcome. 
|
|
|
|
|
05-09-2007, 03:33 AM
|
#14 (permalink) | |
|
Hall Of Famer
Join Date: Dec 2001
Location: In a van, down by the river
Posts: 2,234
|
Quote:
__________________
Sometimes the best laid plans will never get you laid the way you plan. |
|
|
|
|
|
05-09-2007, 08:12 AM
|
#15 (permalink) |
|
All Star Starter
Join Date: Aug 2003
Location: Kenosha, Wisconsin
Posts: 1,812
|
Important Info
Yes I forgot to put into the readme that the utility is expecting to be installed on the C:\ drive (root), so if you change this then the Macro will need to be updated to point to the newdebut.xls file or the new debut.xls file can be copied to the root directory.
Sorry about that.... Last edited by SandMan : 05-09-2007 at 08:15 AM. |
|
|
|
|
05-09-2007, 12:14 PM
|
#16 (permalink) |
|
Hall Of Famer
Join Date: Dec 2001
Location: In a van, down by the river
Posts: 2,234
|
No biggie. Just wanted to let you know. I'm going to give anotrher run at it today and see how it goes. Thanks for the help.
__________________
Sometimes the best laid plans will never get you laid the way you plan. |
|
|
|
|
05-14-2007, 06:43 PM
|
#17 (permalink) |
|
Major Leagues
Join Date: Apr 2007
Location: PA
Posts: 462
|
I'm totally lost on how to do this. What is a .RAR file anyway??
__________________
GREEN BAY PACKERS AND FLORIDA GATORS!! Hustling in the World Baseball Federation (1945- Baseball History (1871- Tampa Bay Rays: Destined for Greatness (2007- *Baseball from the Earliest Times (1850-1856) *Fictional League: EWMBL stopped! (2007-2021) |
|
|
|
|
05-14-2007, 07:07 PM
|
#18 (permalink) |
|
All Star Reserve
Join Date: Dec 2001
Location: Carlsbad, CA
Posts: 627
|
If you don't want to deal with a .RAR file, you can grab the .ZIP version from my website.
__________________
XBL/PSN: Leadfoot5 Everywhere else: PadresFan104 PadresFan Adds-On Central Info:http://www.ootpdevelopments.com/boar...od-thread.html Text Sim Mod-File Website: http://www.padresfanmods.net |
|
|
|
|
05-15-2007, 03:25 PM
|
#19 (permalink) |
|
Hall Of Famer
Join Date: Dec 2001
Location: In a van, down by the river
Posts: 2,234
|
The only complaint I have about this is that the ages of the players when they debut are a little high. For example, going by Sandman's advice, I had the players start coming in 1997 for the league to start in 2001. Manny ramirez is 31 in the league, though at most he should be 25. There are a few others that are a bit high for them coming in. Anyway I can fix this?
__________________
Sometimes the best laid plans will never get you laid the way you plan. |
|
|
|
|
05-15-2007, 04:45 PM
|
#20 (permalink) | |
|
All Star Starter
Join Date: Aug 2003
Location: Kenosha, Wisconsin
Posts: 1,812
|
Quote:
Haven't seen this in my tests. Can you zip the file and send it to me? PM me and I will give you my email. I just need the master file, the master_new table, and new_master table. OOPS... I figured it out.. read the next post please. Last edited by SandMan : 05-15-2007 at 05:27 PM. |
|
|
|
|
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
