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: 211)
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: 4)
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: No registered users and 3 guests

Forums Articles & Tips Sleepers Rankings Leagues


Today's Games
Thursday, Jul. 31
(All times are EST, weather icons show forecast for game time)

Chi White Sox at Detroit
(1:08 pm)
Colorado at Chi Cubs
(2:20 pm)
St. Louis at San Diego
(3:40 pm)
Philadelphia at Washington
(7:05 pm)
Seattle at Cleveland
(7:05 pm)
LA Angels at Baltimore
(7:05 pm)
Cincinnati at Miami
(7:10 pm)
indoors
Toronto at Houston
(8:10 pm)
Minnesota at Kansas City
(8:10 pm)
Pittsburgh at Arizona
(9:40 pm)
Atlanta at LA Dodgers
(10:10 pm)

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