Red Mosquito

cutuphalfdead wrote:And I can't seem to get the syntax down for that.

I think this should work:

=IF(B29>5.8,IF(E29<4,IF(N29=1,1, 0), 0),0)

I like doing all of my thinking now and not having to do any when I'm entering the stats.

Hot diggity

That worked perfectly. I had to change all the commas to semicolons for it to work with open office but the formula is the same.

Detroit Tigers at Kansas City Royals

Quarterfinals, Game 2

http://www.whatifsports.com/slb/Boxscor ... pbp=0&tf=0

Spoiler: show

Royals 3, Tigers 1
W - Davis, L - Trout, S - Quisenberry
HR - Martinez

Royals lead series, 2-0

I thought about doing a TB formula earlier but was just too lazy. Though it wasn't very difficult to come up with =(D2-J2-K2-L2)+(2*J2)+(3*K2)+(4*L2)

New York Yankees at St. Louis Cardinals

Quarterfinals, Game 2

http://www.whatifsports.com/slb/Boxscor ... pbp=0&tf=0

Spoiler: show

Yankees 5, Cardinals 3
W - Guidry, L - Gibson, S - Lyle

Series is tied, 1-1

Lament wrote:Detroit Tigers at Kansas City Royals

Quarterfinals, Game 2

http://www.whatifsports.com/slb/Boxscor ... pbp=0&tf=0

Spoiler: show

Royals 3, Tigers 1
W - Davis, L - Trout, S - Quisenberry
HR - Martinez

Royals lead series, 2-0

Two hitter by Saberhagen and the BP. The all time Royals aren't so different than the 2014 Royals.

philpritchard wrote:

cutuphalfdead wrote:And I can't seem to get the syntax down for that.

I think this should work:

=IF(B29>5.8,IF(E29<4,IF(N29=1,1, 0), 0),0)

I like doing all of my thinking now and not having to do any when I'm entering the stats.

Alright, updated template:

https://www.dropbox.com/s/1s84m09sc4pcu ... t.xls?dl=0

spike wrote:Two hitter by Saberhagen and the BP. The all time Royals aren't so different than the 2014 Royals.

So much #DevilMagic.

cutuphalfdead wrote:

philpritchard wrote:

cutuphalfdead wrote:And I can't seem to get the syntax down for that.

I think this should work:

=IF(B29>5.8,IF(E29<4,IF(N29=1,1, 0), 0),0)

I like doing all of my thinking now and not having to do any when I'm entering the stats.

Alright, updated template:

https://www.dropbox.com/s/1s84m09sc4pcu ... t.xls?dl=0

The All-Time Royals really are the 2014 Royals, aren't they?

They need to be stopped. This just isn't right.

Lament wrote:They need to be stopped. This just isn't right.

JUST HOW MUCH MONEY DO YOU HAVE INVESTED IN WHATIFSPORTS, MR. BRETT?

Lament wrote:New York Yankees at St. Louis Cardinals

Quarterfinals, Game 2

http://www.whatifsports.com/slb/Boxscor ... pbp=0&tf=0

Spoiler: show

Yankees 5, Cardinals 3
W - Guidry, L - Gibson, S - Lyle

Series is tied, 1-1

Kaius wrote:

Lament wrote:JUST HOW MUCH MONEY DO YOU HAVE INVESTED IN WHATIFSPORTS, MR. BRETT?

My life.

My lineup for game 3....

Amos Otis CF
Kevin Seitzer 3B
George Brett 1B
Carlos Beltran RF
Mike Sweeney C
Bo Jackson LF
Jay Bell SS
Frank White 2B
David Cone SP

I will decide on game 4 lineup after game 3

I wish I had benched Nettles earlier in the season. Stirnweiss was a 2B who played very little third during his career, but no errors over the last two games with him at the hot corner. His bat and speed are much nicer than Nettles's.
Nice to see the Yankees bats come alive for the first time in a while.
go royals