All-Time Franchise Baseball Tournament: RED SOX WIN IT ALL!

[philpritchard]

CHEATER!

[@SkitchP]

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

[Norah]

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.

[Norah]

[Norah]

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)

[Kaius]

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

[The Argonaut]

Someone go tell Alex that chud is the new me.

[Norah]

My spreadsheet is pretty awesome. You should use it.

[philpritchard]

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.

[EJ]

Will HBP improve OBP? I had 2 guys drilled in game 1 yesterday.

[philpritchard]

Will HBP improve OBP? I had 2 guys drilled in game 1 yesterday.

It will. And I added that too.

[Norah]

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.

[Norah]

Oh wait, do sac bunts even matter?

[Alex]

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

[philpritchard]

Oh wait, do sac bunts even matter?

No, they don't affect OBP... I don't have SF in mine, though.

[Norah]

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.

[@SkitchP]

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.

[Norah]

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.

[philpritchard]

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.

[@SkitchP]

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.