Lineup Maker Tool for Excel

Lineup Maker Tool for Excel

jwisenberg
Registered User
jwisenberg
Registered User
Joined: 14 Dec 2007, 23:25

01 Nov 2017, 14:55 #1

Wow no interest in this. never mind. Post deleted
Reply
Like

simarc
Registered User
simarc
Registered User
Joined: 05 Nov 2005, 14:34

05 Nov 2017, 14:06 #2

What does it do?  I've been off the board for about two weeks, so I didn't see the original post.
KOD26 - Teams that Crumbled or Faded - http://www.distantreplay.org/MLB/KOD26/
Reply
Like

jwisenberg
Registered User
jwisenberg
Registered User
Joined: 14 Dec 2007, 23:25

05 Nov 2017, 14:24 #3

Alright, I will give it another shot.  

So my favorite way to play baseball sims is to do draft leagues.  In doing so I find myself researching where the guys on the teams normally hit in the lineup, so I can create semi-realistic looking lineups as I do not like the game generated ones.  So I created a database using retrosheet data of every starting lineup that they have which pretty much covers 1910-2016 and a few seasons earlier than that.

I then created a spreadsheet that when you enter the guys you want to start it will then look at that data and give you the lineup.

Here is the link. 
https://www.dropbox.com/s/sjj0enwobb6oh ... .xlsx?dl=0
Reply
Like

samjjones
Registered User
samjjones
Registered User
Joined: 30 Oct 2002, 02:22

06 Nov 2017, 13:34 #4

It's definitely a neat thing.  I don't have time to play the baseball game much (despite my owning every season ever made), but when I retire in 20 years (and if I'm alive), maybe I'll have time to use it :)
Reply
Like

shoe67
Registered User
shoe67
Registered User
Joined: 07 Mar 2017, 11:33

06 Nov 2017, 17:39 #5

Thanks for doing this, JW.
I looked at it (it's a BIG file) and I can see where it could be helpful in past season draft leagues. 
Add-ons like this from the Action PC community are great. Wish we had more. Wish I was smart enough to come up with one. 

Actually, my eternal quest is to write an addendum to the baseball game manual, one that explains in plain English how to perform the most common tasks.
Things like, How to set up a draft league. How to find and add a free agent. How to make sure the exact lineup you want starts on that day. What to be aware of before you try to delete a game that has already been played. How to find the right ballpark photo. 
Things like that. 

Again, thanks for your lineup spreadsheet. 
Reply
Like

Skrabec1
Registered User
Skrabec1
Registered User
Joined: 29 Apr 2008, 01:53

07 Nov 2017, 01:11 #6

jwisenberg wrote: Alright, I will give it another shot.  

So my favorite way to play baseball sims is to do draft leagues.  In doing so I find myself researching where the guys on the teams normally hit in the lineup, so I can create semi-realistic looking lineups as I do not like the game generated ones.  So I created a database using retrosheet data of every starting lineup that they have which pretty much covers 1910-2016 and a few seasons earlier than that.

I then created a spreadsheet that when you enter the guys you want to start it will then look at that data and give you the lineup.

Here is the link. 
https://www.dropbox.com/s/sjj0enwobb6oh ... .xlsx?dl=0
Thank you so much for this!!!

Neil
Reply
Like

jwisenberg
Registered User
jwisenberg
Registered User
Joined: 14 Dec 2007, 23:25

07 Nov 2017, 01:54 #7

Thanks,

Glad some of you might find it useful. I realized I left in a sheet that needed to be removed causing the bloated file size.  I have removed it and also added the 2017 data to the file. The new link will follow.

https://www.dropbox.com/s/koz9sf1dgs4gm ... .xlsx?dl=0
Reply
Like

redsornats
Registered User
redsornats
Registered User
Joined: 21 Dec 2010, 12:23

11 Nov 2017, 15:25 #8

Pretty Interesting and looks like quite an effort went into this. I will use it to check my thoughts when creating lineups for decade, all-star type teams etc. Thanks for your effort!
Reply
Like