Page 24 of 184
Re: All-Time Franchise Baseball Tournament: FINISH YOUR ROST
Posted: Mon October 06, 2014 7:00 pm
by philpritchard
CHEATER!
Re: All-Time Franchise Baseball Tournament: FINISH YOUR ROST
Posted: Mon October 06, 2014 9:37 pm
by @SkitchP
cutuphalfdead wrote:Hey guys. I made this spreadsheet for tracking the stats of my Red Sox team.
https://www.dropbox.com/s/cs9l3qkg3pehh ... s.xls?dl=0
If you download the file and open it up in Excel, you should be able to easily replace the players with your own, and add/delete rows when necessary, to set it up for your own team. In the fields where I have it doing math, you should be able to just extend the cell by the corner to copy the adjusted formula into newly created rows (if your pitcher/hitter breakdown isn't the same as mine).
I'm about to use it as a template for my Expos team as well.
You can set the number of places of places after the decimal by formatting the cell(s). I just did this for the YTD stuff though. Same with ERA, etc.
and after I saw Joel Zumayas crazy K/9 I realized 1.2 innings is actually 1.66
Re: All-Time Franchise Baseball Tournament: FINISH YOUR ROST
Posted: Mon October 06, 2014 9:48 pm
by Norah
@SkitchP wrote:cutuphalfdead wrote:Hey guys. I made this spreadsheet for tracking the stats of my Red Sox team.
https://www.dropbox.com/s/cs9l3qkg3pehh ... s.xls?dl=0
If you download the file and open it up in Excel, you should be able to easily replace the players with your own, and add/delete rows when necessary, to set it up for your own team. In the fields where I have it doing math, you should be able to just extend the cell by the corner to copy the adjusted formula into newly created rows (if your pitcher/hitter breakdown isn't the same as mine).
I'm about to use it as a template for my Expos team as well.
You can set the number of places of places after the decimal by formatting the cell(s). I just did this for the YTD stuff though. Same with ERA, etc.
and after I saw Joel Zumayas crazy K/9 I realized 1.2 innings is actually 1.66
To keep everything simple I'm entiring in .3 for a third of an inning and .7 for two thirds.
Re: All-Time Franchise Baseball Tournament: FINISH YOUR ROST
Posted: Mon October 06, 2014 9:52 pm
by Norah
Re: All-Time Franchise Baseball Tournament: FINISH YOUR ROST
Posted: Mon October 06, 2014 11:34 pm
by Norah
cutuphalfdead wrote:@SkitchP wrote:cutuphalfdead wrote:Hey guys. I made this spreadsheet for tracking the stats of my Red Sox team.
https://www.dropbox.com/s/cs9l3qkg3pehh ... s.xls?dl=0
If you download the file and open it up in Excel, you should be able to easily replace the players with your own, and add/delete rows when necessary, to set it up for your own team. In the fields where I have it doing math, you should be able to just extend the cell by the corner to copy the adjusted formula into newly created rows (if your pitcher/hitter breakdown isn't the same as mine).
I'm about to use it as a template for my Expos team as well.
You can set the number of places of places after the decimal by formatting the cell(s). I just did this for the YTD stuff though. Same with ERA, etc.
and after I saw Joel Zumayas crazy K/9 I realized 1.2 innings is actually 1.66
To keep everything simple I'm entiring in .3 for a third of an inning and .7 for two thirds.
Actually I'm just entering partial innings like so: =6+(2/3)
Re: All-Time Franchise Baseball Tournament: FINISH YOUR ROST
Posted: Tue October 07, 2014 1:50 am
by Kaius
Lament wrote:Hey Kaius, are you going with a four man rotation? Cause if you are, and assuming Bob Gibson is your #1 starter, then game one on day three would appear to be
VS.
at
.
Yes I am, sorry.
Gibson
King
Cooper
Tudor
Re: All-Time Franchise Baseball Tournament: FINISH YOUR ROST
Posted: Tue October 07, 2014 2:38 pm
by The Argonaut
Someone go tell Alex that chud is the new me.
Re: All-Time Franchise Baseball Tournament: FINISH YOUR ROST
Posted: Tue October 07, 2014 4:39 pm
by Norah
My spreadsheet is pretty awesome. You should use it.
Re: All-Time Franchise Baseball Tournament: FINISH YOUR ROST
Posted: Tue October 07, 2014 5:03 pm
by philpritchard
cutuphalfdead wrote:My spreadsheet is pretty awesome. You should use it.
It is awesome!
I stole it, then added OBP, OPS, SB, W, L... because I'm a giant stats nerd.
Re: All-Time Franchise Baseball Tournament: FINISH YOUR ROST
Posted: Tue October 07, 2014 5:13 pm
by EJ
Will HBP improve OBP? I had 2 guys drilled in game 1 yesterday.
Re: All-Time Franchise Baseball Tournament: FINISH YOUR ROST
Posted: Tue October 07, 2014 5:18 pm
by philpritchard
EJ wrote:Will HBP improve OBP? I had 2 guys drilled in game 1 yesterday.
It will. And I added that too.
Re: All-Time Franchise Baseball Tournament: FINISH YOUR ROST
Posted: Tue October 07, 2014 5:24 pm
by Norah
philpritchard wrote:cutuphalfdead wrote:My spreadsheet is pretty awesome. You should use it.
It is awesome!
I stole it, then added OBP, OPS, SB, W, L... because I'm a giant stats nerd.
I was going to add OBP but I wasn't sure how accurate it would be. At the bottom of whatif's boxscore it tells you sac flys but you have to go into the game log to find sac bunts, and that seemed like a lot of work.
Re: All-Time Franchise Baseball Tournament: FINISH YOUR ROST
Posted: Tue October 07, 2014 5:26 pm
by Norah
Oh wait, do sac bunts even matter?
Re: All-Time Franchise Baseball Tournament: FINISH YOUR ROST
Posted: Tue October 07, 2014 5:26 pm
by Alex
cutuphalfdead wrote:philpritchard wrote:cutuphalfdead wrote:My spreadsheet is pretty awesome. You should use it.
It is awesome!
I stole it, then added OBP, OPS, SB, W, L... because I'm a giant stats nerd.
I was going to add OBP but I wasn't sure how accurate it would be. At the bottom of whatif's boxscore it tells you sac flys but you have to go into the game log to find sac bunts, and that seemed like a lot of work.
come on bro, get blazed and scour for sac facts
Re: All-Time Franchise Baseball Tournament: FINISH YOUR ROST
Posted: Tue October 07, 2014 5:32 pm
by philpritchard
cutuphalfdead wrote:Oh wait, do sac bunts even matter?
No, they don't affect OBP... I don't have SF in mine, though.
Re: All-Time Franchise Baseball Tournament: FINISH YOUR ROST
Posted: Tue October 07, 2014 5:43 pm
by Norah
philpritchard wrote:cutuphalfdead wrote:Oh wait, do sac bunts even matter?
No, they don't affect OBP... I don't have SF in mine, though.
Well then your OBP is inaccurate.
Re: All-Time Franchise Baseball Tournament: FINISH YOUR ROST
Posted: Tue October 07, 2014 5:45 pm
by @SkitchP
cutuphalfdead wrote:philpritchard wrote:cutuphalfdead wrote:Oh wait, do sac bunts even matter?
No, they don't affect OBP... I don't have SF in mine, though.
Well then your OBP is inaccurate.
which makes your OPS inaccurate.
Re: All-Time Franchise Baseball Tournament: FINISH YOUR ROST
Posted: Tue October 07, 2014 5:47 pm
by Norah
@SkitchP wrote:cutuphalfdead wrote:philpritchard wrote:cutuphalfdead wrote:Oh wait, do sac bunts even matter?
No, they don't affect OBP... I don't have SF in mine, though.
Well then your OBP is inaccurate.
which makes your OPS inaccurate.
I just added SF, HPB, OBP, and OPS to my Red Sox score sheet. I'll update my Expos one later.
Re: All-Time Franchise Baseball Tournament: FINISH YOUR ROST
Posted: Tue October 07, 2014 5:48 pm
by philpritchard
cutuphalfdead wrote:philpritchard wrote:cutuphalfdead wrote:Oh wait, do sac bunts even matter?
No, they don't affect OBP... I don't have SF in mine, though.
Well then your OBP is inaccurate.
It is. And I really don't care that much, so I'm ok with it the way it is.
Re: All-Time Franchise Baseball Tournament: FINISH YOUR ROST
Posted: Tue October 07, 2014 5:48 pm
by @SkitchP
cutuphalfdead wrote:@SkitchP wrote:cutuphalfdead wrote:philpritchard wrote:cutuphalfdead wrote:Oh wait, do sac bunts even matter?
No, they don't affect OBP... I don't have SF in mine, though.
Well then your OBP is inaccurate.
which makes your OPS inaccurate.
I just added SF, HPB, OBP, and OPS to my Red Sox score sheet. I'll update my Expos one later.
Stolen Bases? Caught Stealing? Wins and Losses?
Let me know if youre updating more before i spend time changing all the names.
