Excel help - Fantasy Baseball Cafe 2014 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to General Talk

Excel help

Moderator: Baseball Moderators

Re: Excel help

Postby kimchi_chigae » Thu Feb 07, 2008 8:09 pm

Chicks dig spreadsheets. ;-D
Free WR!
kimchi_chigae Beginner
Mod in Retirement
Mod in Retirement

User avatar
CafeholicFantasy ExpertCafe RankerGraphics ExpertMock(ing) DrafterEagle EyePick 3 Weekly WinnerLucky Ladders Weekly Winner
Posts: 14875
(Past Year: 608)
Joined: 27 May 2004
Home Cafe: Baseball
Location: Osaka Jail

Re: Excel help

Postby Big Pimpin » Thu Feb 07, 2008 8:31 pm

kimchi_chigae wrote:Chicks dig spreadsheets. ;-D


You'd be surprised, my friend... You'd be surprised.
Big Pimpin
Mod in Retirement
Mod in Retirement

User avatar
EditorCafeholicFantasy ExpertCafe WriterCafe RankerGraphics ExpertMock(ing) DrafterEagle EyeWeb SupporterMatchup Meltdown ChampionPick 3 Weekly WinnerLucky Ladders Weekly Winner
Posts: 13710
(Past Year: 5)
Joined: 20 Apr 2005
Home Cafe: Baseball
Location: Building a metric. And being ignorable and stupid.

Re: Excel help

Postby JTWood » Thu Feb 07, 2008 8:53 pm

Big Pimpin wrote:
bigh0rt wrote:Can you set up a condition in which if the cell reads #N/A it is replaced with "-" or " "?


Yep...

=IF(ISNA(Formula),"",Formula)

;-D

I prefer ISERROR... It works for a broader range of error outputs than ISNA.
Image
JTWood
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicCafe WriterEagle EyeWeb Supporter
Posts: 11508
Joined: 22 Jun 2004
Home Cafe: Baseball
Location: Unincorporated Heaven

Re: Excel help

Postby JTWood » Thu Feb 07, 2008 8:54 pm

kimchi_chigae wrote:Chicks dig spreadsheets. ;-D

Well, chicks dig money, and spreadsheets make me plenty of it, so...

I think you might actually be right. :-o :-o :-o
Image
JTWood
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicCafe WriterEagle EyeWeb Supporter
Posts: 11508
Joined: 22 Jun 2004
Home Cafe: Baseball
Location: Unincorporated Heaven

Re: Excel help

Postby RynMan » Thu Feb 07, 2008 9:11 pm

bigken117 wrote:I got this one!

Delete the formula from it ;-)


Great advice right there.

:-D

How did you guys learn so much about Excel? JT....BP?

Just by being old nerds? O:-)
Image
RynMan
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerAward-Winning Graphics ExpertMock(ing) DrafterEagle Eye
Posts: 8891
Joined: 4 Feb 2004
Home Cafe: Baseball
Location: Oztailia

Re: Excel help

Postby JTWood » Thu Feb 07, 2008 9:24 pm

Is 29 old? :-?

I learned a lot of the initial stuff I know about Excel by playing fantasy baseball. Seriously.

After that, my first accounting job required me to massage some data, and I happened to work with a guy that was very good at the actual functions in Excel. When I got promoted to my next position, I volunteered to automate some manual procedures that the finance department was wasting time on. To do that, I had to learn VBA. Excel is great because of that record macro button. I learned how VBA worked by recording myself doing repetitive tasks, and then I started expanding it.

Now, I actually get paid to work in Excel 75% of every day. I do everything from massaging raw data into reports for managers to writing VBA scripts to pull import and format raw XML straight from the web.

And all of this is possible because I am a fantasy baseball geek. !+)

On a related note, I have heard stories of high school classes springing up around the country where the entire class is based around fantasy sports. The teachers use it as a medium to teach the students statistics. Pretty cool, if you ask me (and I know you did).
Image
JTWood
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicCafe WriterEagle EyeWeb Supporter
Posts: 11508
Joined: 22 Jun 2004
Home Cafe: Baseball
Location: Unincorporated Heaven

Previous

Return to General Talk

Who is online

Users browsing this forum: unioreimi and 2 guests

Forums Articles & Tips Sleepers Rankings Leagues


Today's Games
Friday, Apr. 18
(All times are EST, weather icons show forecast for game time)

Toronto at Cleveland
(2:20 pm)
LA Angels at Detroit
(7:05 pm)
Milwaukee at Pittsburgh
(7:05 pm)
St. Louis at Washington
(7:05 pm)
Miami at Miami
(7:08 pm)
indoors
NY Yankees at Tampa Bay
(7:10 pm)
indoors
Seattle at Seattle
(7:10 pm)
Atlanta at NY Mets
(7:10 pm)
Baltimore at Boston
(7:10 pm)
Chi White Sox at Texas
(8:05 pm)
Minnesota at Kansas City
(8:10 pm)
Philadelphia at Colorado
(8:40 pm)
Houston at Oakland
(10:05 pm)
Arizona at LA Dodgers
(10:10 pm)
San Francisco at San Diego
(10:10 pm)

  • Fantasy Baseball
  • Article Submissions
  • Privacy Statement
  • Site Survey 
  • Contact