Red Mosquito

@SkitchP wrote:

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.

I'm undecided on those. I don't really care about SB and CS that much. And Win/Loss is meh.

Ok, apparently I did care. I now have SF and CS, which I think means I have everything except sac bunts, which would only make me want to fire my manager anyway.

someone go wake up lament

Hey, it's letting me post in here today!

I'm gonna start running the games shortly.

Just found a huge error in my total stats section of the red sox based spreadsheet. For the counting stats each game is separated by 40 cells, so it should look something like =B4+B44+B84...

Row 4 started B4+B43+B83... so I deleted the formulas from that row and redragged them from the row above which adjusted them correctly.

Then I started inspecting some of the other formulas in the totals section and there were a few random entries that were off by 1 number. (eg. H46+H85+H126+H146+H185...)

To fix this I'm going back to the first player's At Bat column and making sure that's right, and once it is I'll drag them down to all the other players and other stat columns which will adjust each number and letter accordingly.

The percentage stats in the totals section are fine because those pull from the other columns in the totals section and aren't added from the individual games.

I'll be checking the Expos one once I have this sorted.

cutuphalfdead wrote:Just found a huge error in my total stats section of the red sox based spreadsheet. For the counting stats each game is separated by 40 cells, so it should look something like =B4+B44+B84...

Row 4 started B4+B43+B83... so I deleted the formulas from that row and redragged them from the row above which adjusted them correctly.

Then I started inspecting some of the other formulas in the totals section and there were a few random entries that were off by 1 number. (eg. H46+H85+H126+H146+H185...)

To fix this I'm going back to the first player's At Bat column and making sure that's right, and once it is I'll drag them down to all the other players and other stat columns which will adjust each number and letter accordingly.

The percentage stats in the totals section are fine because those pull from the other columns in the totals section and aren't added from the individual games.

goddamn it pete.

@SkitchP wrote:

cutuphalfdead wrote:Just found a huge error in my total stats section of the red sox based spreadsheet. For the counting stats each game is separated by 40 cells, so it should look something like =B4+B44+B84...

Row 4 started B4+B43+B83... so I deleted the formulas from that row and redragged them from the row above which adjusted them correctly.

Then I started inspecting some of the other formulas in the totals section and there were a few random entries that were off by 1 number. (eg. H46+H85+H126+H146+H185...)

To fix this I'm going back to the first player's At Bat column and making sure that's right, and once it is I'll drag them down to all the other players and other stat columns which will adjust each number and letter accordingly.

The percentage stats in the totals section are fine because those pull from the other columns in the totals section and aren't added from the individual games.

goddamn it pete.

Here's a correct template:

https://www.dropbox.com/s/cs9l3qkg3pehh ... s.xls?dl=0

cutuphalfdead wrote:

@SkitchP wrote:

cutuphalfdead wrote:Just found a huge error in my total stats section of the red sox based spreadsheet. For the counting stats each game is separated by 40 cells, so it should look something like =B4+B44+B84...

Row 4 started B4+B43+B83... so I deleted the formulas from that row and redragged them from the row above which adjusted them correctly.

Then I started inspecting some of the other formulas in the totals section and there were a few random entries that were off by 1 number. (eg. H46+H85+H126+H146+H185...)

To fix this I'm going back to the first player's At Bat column and making sure that's right, and once it is I'll drag them down to all the other players and other stat columns which will adjust each number and letter accordingly.

The percentage stats in the totals section are fine because those pull from the other columns in the totals section and aren't added from the individual games.

goddamn it pete.

Here's a correct template:

https://www.dropbox.com/s/cs9l3qkg3pehh ... s.xls?dl=0

*scrolls all the way through 30 games... again*

I use Open Office instead of Excel so when I export it as a .xls file to share with you guys it doesn't save the alternating row color shading.

I almost had a heart attack when I first saw it, but it turned out to be easier to fix than I feared.

Real quick, these are the pitching match ups I have slated for today...

Tigers - Astros
at Detroit: Mullin (R) vs. Hampton (L) , at Houston: Lolich (L) vs. Ryan (R)

Rangers - Cardinals
at Texas: Ryan (R) vs. Copper (R), at St. Louis: Darvish (R) vs. Tudor (L)

White Sox - Blue Jays
at Chicago: Cicotte (R) vs. Stieb (R), at Toronto: Faber (R) vs. Hentgen (R)

Reds - Expos
at Cincinatti: Rhines (R) vs. Martinez (R), at Montreal: Luque (R) vs. Vasquez (R)

Royals - Red Sox
at Kansas City: Appier (R) vs. Clemens (R), at Boston: Cone (R) vs. Grove (L)

Cubs - Mariners
at Chicago: Vaughn (L) vs. Fleming (L), at Seattle: Maddux (R) vs. Iwakuma (R)

Yankees - Indians
at New York: Gomez (L) vs. Coveleski (R), at Cleveland: Chandler (R) vs. Gregg (L)

Orioles - Pirates
at Baltimore: Cuellar (L) vs. Veale (L), at Pittsburgh: McNally (L) vs. Law (R)


I'm gonna ask now so I don't forget...chud and numbers, are you guys going with a six man rotation for the Red Sox? Cause I don't have any rotation marked down other than your list of six starters. Also, Skitch, I'm still just using the default whatif starts in order for the Reds. Are you just gonna roll with that? Cause I don't have a Reds rotation for you either.

Lament wrote:

I'm gonna ask now so I don't forget...chud and numbers, are you guys going with a six man rotation for the Red Sox? Cause I don't have any rotation marked down other than your list of six starters. Also, Skitch, I'm still just using the default whatif starts in order for the Reds. Are you just gonna roll with that? Cause I don't have a Reds rotation for you either.

Yeah, thats fine.

Lament wrote:Real quick, these are the pitching match ups I have slated for today...

Tigers - Astros
at Detroit: Mullin (R) vs. Hampton (L) , at Houston: Lolich (L) vs. Ryan (R)

Rangers - Cardinals
at Texas: Ryan (R) vs. Copper (R), at St. Louis: Darvish (R) vs. Tudor (L)

White Sox - Blue Jays
at Chicago: Cicotte (R) vs. Stieb (R), at Toronto: Faber (R) vs. Hentgen (R)

Reds - Expos
at Cincinatti: Rhines (R) vs. Martinez (R), at Montreal: Luque (R) vs. Vasquez (R)

Royals - Red Sox
at Kansas City: Appier (R) vs. Clemens (R), at Boston: Cone (R) vs. Grove (L)

Cubs - Mariners
at Chicago: Vaughn (L) vs. Fleming (L), at Seattle: Maddux (R) vs. Iwakuma (R)

Yankees - Indians
at New York: Gomez (L) vs. Coveleski (R), at Cleveland: Chandler (R) vs. Gregg (L)

Orioles - Pirates
at Baltimore: Cuellar (L) vs. Veale (L), at Pittsburgh: McNally (L) vs. Law (R)


I'm gonna ask now so I don't forget...chud and numbers, are you guys going with a six man rotation for the Red Sox? Cause I don't have any rotation marked down other than your list of six starters. Also, Skitch, I'm still just using the default whatif starts in order for the Reds. Are you just gonna roll with that? Cause I don't have a Reds rotation for you either.

Yeah we're gonna go with a 6 man to start, but that might drop to a 4 man rotation halfway through the season if a pitcher or 2 just aren't cutting it.

Lament wrote:Real quick, these are the pitching match ups I have slated for today...

Tigers - Astros
at Detroit: Mullin (R) vs. Hampton (L) , at Houston: Lolich (L) vs. Ryan (R)

Rangers - Cardinals
at Texas: Ryan (R) vs. Copper (R), at St. Louis: Darvish (R) vs. Tudor (L)

White Sox - Blue Jays
at Chicago: Cicotte (R) vs. Stieb (R), at Toronto: Faber (R) vs. Hentgen (R)

Reds - Expos
at Cincinatti: Rhines (R) vs. Martinez (R), at Montreal: Luque (R) vs. Vasquez (R)

Royals - Red Sox
at Kansas City: Appier (R) vs. Clemens (R), at Boston: Cone (R) vs. Grove (L)

Cubs - Mariners
at Chicago: Vaughn (L) vs. Fleming (L), at Seattle: Maddux (R) vs. Iwakuma (R)

Yankees - Indians
at New York: Gomez (L) vs. Coveleski (R), at Cleveland: Chandler (R) vs. Gregg (L)

Orioles - Pirates
at Baltimore: Cuellar (L) vs. Veale (L), at Pittsburgh: McNally (L) vs. Law (R)


I'm gonna ask now so I don't forget...chud and numbers, are you guys going with a six man rotation for the Red Sox? Cause I don't have any rotation marked down other than your list of six starters. Also, Skitch, I'm still just using the default whatif starts in order for the Reds. Are you just gonna roll with that? Cause I don't have a Reds rotation for you either.

I believe we are going with a 5 man of Young, Pedro, Grove, Clemens and Ruth.

Maybe we should have talked about this...

@SkitchP wrote:

Lament wrote:

I'm gonna ask now so I don't forget...chud and numbers, are you guys going with a six man rotation for the Red Sox? Cause I don't have any rotation marked down other than your list of six starters. Also, Skitch, I'm still just using the default whatif starts in order for the Reds. Are you just gonna roll with that? Cause I don't have a Reds rotation for you either.

Yeah, thats fine.

Well just the top 4.

I just learned in the last tournament that I want to have a 5th available if needed so I can move around starters more without wasting my "2 days between" options.

Young, Pedro, Grove, Clemens, Ruth, Lee

So that means we should have Grove in game 3 today and Clemens in game 4.

Is that ok with you, numbers?

Yea that's fine.