Lineup Maker Tool for Excel

Lineup Maker Tool for Excel

jwisenberg
Registered User
jwisenberg
Registered User
Joined: December 14th, 2007, 11:25 pm

November 1st, 2017, 2:55 pm #1

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

simarc
Registered User
simarc
Registered User
Joined: November 5th, 2005, 2:34 pm

November 5th, 2017, 2:06 pm #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
Share

jwisenberg
Registered User
jwisenberg
Registered User
Joined: December 14th, 2007, 11:25 pm

November 5th, 2017, 2:24 pm #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
Share

samjjones
Registered User
samjjones
Registered User
Joined: October 30th, 2002, 2:22 am

November 6th, 2017, 1:34 pm #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
Share

shoe67
Registered User
shoe67
Registered User
Joined: March 7th, 2017, 11:33 am

November 6th, 2017, 5:39 pm #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
Share

Skrabec1
Registered User
Skrabec1
Registered User
Joined: April 29th, 2008, 1:53 am

November 7th, 2017, 1:11 am #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
Share

jwisenberg
Registered User
jwisenberg
Registered User
Joined: December 14th, 2007, 11:25 pm

November 7th, 2017, 1:54 am #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
Share

redsornats
Registered User
redsornats
Registered User
Joined: December 21st, 2010, 12:23 pm

November 11th, 2017, 3:25 pm #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
Share