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

Discuss your hatred for the Yankees here.
Post Reply
User avatar
philpritchard
Rank This Poster
Posts: 4155
Joined: Thu January 03, 2013 3:45 pm

Re: All-Time Franchise Baseball Tournament: QUARTERFINALS!

Post by philpritchard »

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.
Kaius
I've been POOSSTTIiiEEnngeeaahh
Posts: 11136
Joined: Fri November 15, 2013 6:14 am

Re: All-Time Franchise Baseball Tournament: QUARTERFINALS!

Post by Kaius »

Hot diggity
User avatar
Norah
Poster of the Year
Posts: 37454
Joined: Tue January 01, 2013 2:04 pm
Location: September 2020 Poster of the Month

Re: All-Time Franchise Baseball Tournament: QUARTERFINALS!

Post by Norah »

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.
Last edited by Norah on Fri November 07, 2014 4:27 pm, edited 1 time in total.
Kaius
I've been POOSSTTIiiEEnngeeaahh
Posts: 11136
Joined: Fri November 15, 2013 6:14 am

Re: All-Time Franchise Baseball Tournament: QUARTERFINALS!

Post by Kaius »

Image
User avatar
Lament
Commissioner
Posts: 11792
Joined: Wed March 13, 2013 12:48 am

Re: All-Time Franchise Baseball Tournament: QUARTERFINALS!

Post by Lament »

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
TEAM HARMLESS FOREVER...
User avatar
Norah
Poster of the Year
Posts: 37454
Joined: Tue January 01, 2013 2:04 pm
Location: September 2020 Poster of the Month

Re: All-Time Franchise Baseball Tournament: QUARTERFINALS!

Post by Norah »

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)
User avatar
Lament
Commissioner
Posts: 11792
Joined: Wed March 13, 2013 12:48 am

Re: All-Time Franchise Baseball Tournament: QUARTERFINALS!

Post by Lament »

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
TEAM HARMLESS FOREVER...
User avatar
spike
The Master
Posts: 35957
Joined: Wed January 02, 2013 4:18 am

Re: All-Time Franchise Baseball Tournament: QUARTERFINALS!

Post by spike »

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.
User avatar
Norah
Poster of the Year
Posts: 37454
Joined: Tue January 01, 2013 2:04 pm
Location: September 2020 Poster of the Month

Re: All-Time Franchise Baseball Tournament: QUARTERFINALS!

Post by Norah »

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
User avatar
Lament
Commissioner
Posts: 11792
Joined: Wed March 13, 2013 12:48 am

Re: All-Time Franchise Baseball Tournament: QUARTERFINALS!

Post by Lament »

spike wrote:Two hitter by Saberhagen and the BP. The all time Royals aren't so different than the 2014 Royals.
So much #DevilMagic.
TEAM HARMLESS FOREVER...
User avatar
philpritchard
Rank This Poster
Posts: 4155
Joined: Thu January 03, 2013 3:45 pm

Re: All-Time Franchise Baseball Tournament: QUARTERFINALS!

Post by philpritchard »

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
:thumbsup:
User avatar
philpritchard
Rank This Poster
Posts: 4155
Joined: Thu January 03, 2013 3:45 pm

Re: All-Time Franchise Baseball Tournament: QUARTERFINALS!

Post by philpritchard »

The All-Time Royals really are the 2014 Royals, aren't they?
User avatar
Lament
Commissioner
Posts: 11792
Joined: Wed March 13, 2013 12:48 am

Re: All-Time Franchise Baseball Tournament: QUARTERFINALS!

Post by Lament »

They need to be stopped. This just isn't right.
TEAM HARMLESS FOREVER...
User avatar
BigRedLedbetter
Rank This Poster
Posts: 5401
Joined: Sat June 07, 2014 5:38 pm
Location: The town of Lincoln, Nebraska

Re: All-Time Franchise Baseball Tournament: QUARTERFINALS!

Post by BigRedLedbetter »

Lament wrote:They need to be stopped. This just isn't right.
Image :wave:
"My balls feels like they're in a French press." ~ bodysnatcher
User avatar
Lament
Commissioner
Posts: 11792
Joined: Wed March 13, 2013 12:48 am

Re: All-Time Franchise Baseball Tournament: QUARTERFINALS!

Post by Lament »

JUST HOW MUCH MONEY DO YOU HAVE INVESTED IN WHATIFSPORTS, MR. BRETT?
TEAM HARMLESS FOREVER...
Kaius
I've been POOSSTTIiiEEnngeeaahh
Posts: 11136
Joined: Fri November 15, 2013 6:14 am

Re: All-Time Franchise Baseball Tournament: QUARTERFINALS!

Post by Kaius »

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
Image
User avatar
Lament
Commissioner
Posts: 11792
Joined: Wed March 13, 2013 12:48 am

Re: All-Time Franchise Baseball Tournament: QUARTERFINALS!

Post by Lament »

Kaius wrote:Image
Image
TEAM HARMLESS FOREVER...
User avatar
BigRedLedbetter
Rank This Poster
Posts: 5401
Joined: Sat June 07, 2014 5:38 pm
Location: The town of Lincoln, Nebraska

Re: All-Time Franchise Baseball Tournament: QUARTERFINALS!

Post by BigRedLedbetter »

Lament wrote:JUST HOW MUCH MONEY DO YOU HAVE INVESTED IN WHATIFSPORTS, MR. BRETT?
My life.
"My balls feels like they're in a French press." ~ bodysnatcher
User avatar
BigRedLedbetter
Rank This Poster
Posts: 5401
Joined: Sat June 07, 2014 5:38 pm
Location: The town of Lincoln, Nebraska

Re: All-Time Franchise Baseball Tournament: QUARTERFINALS!

Post by BigRedLedbetter »

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 :thumbsup:
"My balls feels like they're in a French press." ~ bodysnatcher
User avatar
The Argonaut
I've been POOSSTTIiiEEnngeeaahh
Posts: 11939
Joined: Tue January 01, 2013 1:53 pm
Location: in the air tonight

Re: All-Time Franchise Baseball Tournament: QUARTERFINALS!

Post by The Argonaut »

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
Please consider voting for me
Post Reply