Jump to content





Bleacher Nation is on Facebook, and you should totally "Like" us:
 


Bleacher Nation is also on Twitter, and you should totally follow us:




Upcoming Calendar Events

There are no forthcoming calendar events

Today's birthdays

No members are celebrating a birthday today

Photo

Women in Baseball?


  • Please log in to reply
606 replies to this topic

#481 MichiganGoat

MichiganGoat

    Give me a BEER

  • Moderators
  • 3,798 posts
  • Twitter:MichiganGoat
  • Facebook:michigangoat
  • LocationGrand Rapids, MI

Posted 02 April 2013 - 07:01 AM

Posted Image

MichiganGoat on Twitter

"There are a lot of guys who are respected but not liked" - Ron Santo


#482 Cubbie Blues

Cubbie Blues

    The Engineer

  • Members
  • PipPipPipPip
  • 3,365 posts
  • Twitter:@timhall76
  • LocationBloomington, IN

Posted 02 April 2013 - 07:05 AM

I think this thread has turned into the apropo of nothing thread.

"It's not the dress that makes you look fat, it's the fat that makes you look fat." - Al Bundy

 

"Ow" - Dylan Bundy


#483 MichiganGoat

MichiganGoat

    Give me a BEER

  • Moderators
  • 3,798 posts
  • Twitter:MichiganGoat
  • Facebook:michigangoat
  • LocationGrand Rapids, MI

Posted 02 April 2013 - 07:25 AM

I think this thread has turned into the apropo of nothing thread.

This has become even more non sequitur than that thread

MichiganGoat on Twitter

"There are a lot of guys who are respected but not liked" - Ron Santo


#484 hansman1982

hansman1982

    King Regent of The Calendar Trivia Empire

  • Members
  • PipPipPip
  • 2,938 posts
  • Twitter:JoeHansman
  • LocationDes Moines, IA

Posted 02 April 2013 - 07:36 AM

ymwftr? "you must work for the rooftops"

--just some fun with BN acronym ad hominem


Awesome, just awesome.

#485 hansman1982

hansman1982

    King Regent of The Calendar Trivia Empire

  • Members
  • PipPipPip
  • 2,938 posts
  • Twitter:JoeHansman
  • LocationDes Moines, IA

Posted 02 April 2013 - 07:38 AM


I think this thread has turned into the apropo of nothing thread.

This has become even more non sequitur than that thread


Posted Image

I have no idea what you are talking about...

#486 hansman1982

hansman1982

    King Regent of The Calendar Trivia Empire

  • Members
  • PipPipPip
  • 2,938 posts
  • Twitter:JoeHansman
  • LocationDes Moines, IA

Posted 02 April 2013 - 07:47 AM

I'll throw this here because, why not.

I am creating a spreadsheet with the top 30 free agents from 2006-2012 (based on total amount of the contract) trying to determine how effective FA spending is in getting WAR.

It's a fairly simple task (mostly data entry); however, I am stumped on how to properly value the WAR cost of guys who achieved negative WAR during their contract. I first thought about just using the total value of their contract; however, then they are "penalized" worse than guys who got a fraction of a WAR (for reference, in 2006 there was a FA who got .1 WAR over his contract of $20M, giving him a $200M per WAR cost).

In reality, they cost their teams an infinite amount per WAR, just it's kinda hard to factor that in. I don't want to give them the benefit of having a negative WAR, but I have to assign them something.

Any ideas?

#487 Cubbie Blues

Cubbie Blues

    The Engineer

  • Members
  • PipPipPipPip
  • 3,365 posts
  • Twitter:@timhall76
  • LocationBloomington, IN

Posted 02 April 2013 - 08:46 AM

Deleted double post. Not sure what happened there.

"It's not the dress that makes you look fat, it's the fat that makes you look fat." - Al Bundy

 

"Ow" - Dylan Bundy


#488 Cubbie Blues

Cubbie Blues

    The Engineer

  • Members
  • PipPipPipPip
  • 3,365 posts
  • Twitter:@timhall76
  • LocationBloomington, IN

Posted 02 April 2013 - 08:46 AM

I'll throw this here because, why not.

I am creating a spreadsheet with the top 30 free agents from 2006-2012 (based on total amount of the contract) trying to determine how effective FA spending is in getting WAR.

It's a fairly simple task (mostly data entry); however, I am stumped on how to properly value the WAR cost of guys who achieved negative WAR during their contract. I first thought about just using the total value of their contract; however, then they are "penalized" worse than guys who got a fraction of a WAR (for reference, in 2006 there was a FA who got .1 WAR over his contract of $20M, giving him a $200M per WAR cost).

In reality, they cost their teams an infinite amount per WAR, just it's kinda hard to factor that in. I don't want to give them the benefit of having a negative WAR, but I have to assign them something.

Any ideas?

=IF(A2>0,A2,"Suck")

A2=WAR value

"It's not the dress that makes you look fat, it's the fat that makes you look fat." - Al Bundy

 

"Ow" - Dylan Bundy


#489 hansman1982

hansman1982

    King Regent of The Calendar Trivia Empire

  • Members
  • PipPipPip
  • 2,938 posts
  • Twitter:JoeHansman
  • LocationDes Moines, IA

Posted 02 April 2013 - 09:04 AM


I'll throw this here because, why not.

I am creating a spreadsheet with the top 30 free agents from 2006-2012 (based on total amount of the contract) trying to determine how effective FA spending is in getting WAR.

It's a fairly simple task (mostly data entry); however, I am stumped on how to properly value the WAR cost of guys who achieved negative WAR during their contract. I first thought about just using the total value of their contract; however, then they are "penalized" worse than guys who got a fraction of a WAR (for reference, in 2006 there was a FA who got .1 WAR over his contract of $20M, giving him a $200M per WAR cost).

In reality, they cost their teams an infinite amount per WAR, just it's kinda hard to factor that in. I don't want to give them the benefit of having a negative WAR, but I have to assign them something.

Any ideas?

=IF(A2>0,A2,"Suck")

A2=WAR value


I tired this, but Excel crashed when I got to Milton Bradley.

#490 Cubbie Blues

Cubbie Blues

    The Engineer

  • Members
  • PipPipPipPip
  • 3,365 posts
  • Twitter:@timhall76
  • LocationBloomington, IN

Posted 02 April 2013 - 09:10 AM



I'll throw this here because, why not.

I am creating a spreadsheet with the top 30 free agents from 2006-2012 (based on total amount of the contract) trying to determine how effective FA spending is in getting WAR.

It's a fairly simple task (mostly data entry); however, I am stumped on how to properly value the WAR cost of guys who achieved negative WAR during their contract. I first thought about just using the total value of their contract; however, then they are "penalized" worse than guys who got a fraction of a WAR (for reference, in 2006 there was a FA who got .1 WAR over his contract of $20M, giving him a $200M per WAR cost).

In reality, they cost their teams an infinite amount per WAR, just it's kinda hard to factor that in. I don't want to give them the benefit of having a negative WAR, but I have to assign them something.

Any ideas?

=IF(A2>0,A2,"Suck")

A2=WAR value


I tired this, but Excel crashed when I got to Milton Bradley.

=IF(Milton Bradley,=IF(A2>0,A2,"Suck"),"Douche Nozzle")

"It's not the dress that makes you look fat, it's the fat that makes you look fat." - Al Bundy

 

"Ow" - Dylan Bundy


#491 hansman1982

hansman1982

    King Regent of The Calendar Trivia Empire

  • Members
  • PipPipPip
  • 2,938 posts
  • Twitter:JoeHansman
  • LocationDes Moines, IA

Posted 02 April 2013 - 09:19 AM




I'll throw this here because, why not.

I am creating a spreadsheet with the top 30 free agents from 2006-2012 (based on total amount of the contract) trying to determine how effective FA spending is in getting WAR.

It's a fairly simple task (mostly data entry); however, I am stumped on how to properly value the WAR cost of guys who achieved negative WAR during their contract. I first thought about just using the total value of their contract; however, then they are "penalized" worse than guys who got a fraction of a WAR (for reference, in 2006 there was a FA who got .1 WAR over his contract of $20M, giving him a $200M per WAR cost).

In reality, they cost their teams an infinite amount per WAR, just it's kinda hard to factor that in. I don't want to give them the benefit of having a negative WAR, but I have to assign them something.

Any ideas?

=IF(A2>0,A2,"Suck")

A2=WAR value


I tired this, but Excel crashed when I got to Milton Bradley.

=IF(Milton Bradley,=IF(A2>0,A2,"Suck"),"Douche Nozzle")


I think you mean

=IF(Milton Bradley,"Douche Nozzle",=IF(A2>0,A2,"Suck")

Otherwise it would still fail since it would look at A2 only if it were Milton Bradley and call everyone else Douche Nozzle.

#492 Cubbie Blues

Cubbie Blues

    The Engineer

  • Members
  • PipPipPipPip
  • 3,365 posts
  • Twitter:@timhall76
  • LocationBloomington, IN

Posted 02 April 2013 - 09:21 AM





I'll throw this here because, why not.

I am creating a spreadsheet with the top 30 free agents from 2006-2012 (based on total amount of the contract) trying to determine how effective FA spending is in getting WAR.

It's a fairly simple task (mostly data entry); however, I am stumped on how to properly value the WAR cost of guys who achieved negative WAR during their contract. I first thought about just using the total value of their contract; however, then they are "penalized" worse than guys who got a fraction of a WAR (for reference, in 2006 there was a FA who got .1 WAR over his contract of $20M, giving him a $200M per WAR cost).

In reality, they cost their teams an infinite amount per WAR, just it's kinda hard to factor that in. I don't want to give them the benefit of having a negative WAR, but I have to assign them something.

Any ideas?

=IF(A2>0,A2,"Suck")

A2=WAR value


I tired this, but Excel crashed when I got to Milton Bradley.

=IF(Milton Bradley,=IF(A2>0,A2,"Suck"),"Douche Nozzle")


I think you mean

=IF(Milton Bradley,"Douche Nozzle",=IF(A2>0,A2,"Suck")

Otherwise it would still fail since it would look at A2 only if it were Milton Bradley and call everyone else Douche Nozzle.

You are correct, I reversed my True/False variables.

"It's not the dress that makes you look fat, it's the fat that makes you look fat." - Al Bundy

 

"Ow" - Dylan Bundy


#493 hansman1982

hansman1982

    King Regent of The Calendar Trivia Empire

  • Members
  • PipPipPip
  • 2,938 posts
  • Twitter:JoeHansman
  • LocationDes Moines, IA

Posted 02 April 2013 - 09:45 AM

Ya, sadly, I am an Excel Nerd...

#494 MichiganGoat

MichiganGoat

    Give me a BEER

  • Moderators
  • 3,798 posts
  • Twitter:MichiganGoat
  • Facebook:michigangoat
  • LocationGrand Rapids, MI

Posted 02 April 2013 - 09:50 AM

So now women in baseball is advanced sabermetrics?

MichiganGoat on Twitter

"There are a lot of guys who are respected but not liked" - Ron Santo


#495 hansman1982

hansman1982

    King Regent of The Calendar Trivia Empire

  • Members
  • PipPipPip
  • 2,938 posts
  • Twitter:JoeHansman
  • LocationDes Moines, IA

Posted 02 April 2013 - 10:22 AM

So now women in baseball is advanced sabermetrics?


It's the never-ending-non-sequiter-twisty-turny-turvey road of BN.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

Bleacher Nation is not affiliated in any way with Major League Baseball or the Chicago National League Ballclub (that's the Cubs).