Small tip for Excel & dougstats users - Fantasy Baseball Cafe 2014 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to Baseball Leftovers

Small tip for Excel & dougstats users

Moderator: Baseball Moderators

Small tip for Excel & dougstats users

Postby RugbyD » Sat Jan 15, 2011 2:58 pm

don't recall if i've posted this before, but when I download numbers from non-dougstats sites I find an easy way to make the different stats universally accessible is to convert the players' names into dougstats format. Here's the 2-step process:

1) Split the names into their separate parts by doing Data --> Text to Columns. You have to comb through and adjust for the rare guy who has more than 2 parts to his name. This will also separate out the pesky position and team IDs that sometimes are lumped in with names.
2) use this formula: =lower(left(concatenate(last,",",first),15)). the 'lower' part is unnecessary, but I like it for consistency purposes.

This won't work for Salty b/c doug doesn't put the comma after his name. Adjust accordingly.
TennCare rocks!!!!
Hall of Fame Hero
Hall of Fame Hero

User avatar
Cafe Ranker
Posts: 5591
Joined: 7 Dec 2004
Home Cafe: Baseball
Location: punting small dogs and being surly

Re: Small tip for Excel & dougstats users

Postby rookies and cream » Sat Jan 15, 2011 10:20 pm

This is something that I have to do with some of the websites when I do the MDP list. It's a great tip.
rookies and cream
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerGraphics ExpertMock(ing) DrafterWeb Supporter
Posts: 6487
(Past Year: 43)
Joined: 4 Apr 2007
Home Cafe: Baseball
Location: Long Island, NY

Re: Small tip for Excel & dougstats users

Postby West » Sun Jan 16, 2011 9:09 am

Thanks for the tip. I recently started using excel to formulate some simple statistics that fangraphs leaves off. It's been helpful but also frustrating at times...Excel just has a tough learning curve and is not very user friendly.
Major League Manager
Major League Manager

User avatar

Posts: 1518
(Past Year: 92)
Joined: 28 Feb 2004
Home Cafe: Baseball

Return to Baseball Leftovers

Who is online

Users browsing this forum: Armandopn, ensanimal, joiingds, unioreimi and 9 guests

Forums Articles & Tips Sleepers Rankings Leagues

Today's Games
Monday, Sep. 15
(All times are EST, weather icons show forecast for game time)

Toronto at Baltimore
(7:05 pm)
Washington at Atlanta
(7:10 pm)
Miami at NY Mets
(7:10 pm)
NY Yankees at Tampa Bay
(7:10 pm)
Cincinnati at Chi Cubs
(8:05 pm)
Detroit at Minnesota
(8:10 pm)
Chi White Sox at Kansas City
(8:10 pm)
Cleveland at Houston
(8:10 pm)
LA Dodgers at Colorado
(8:40 pm)
San Francisco at Arizona
(9:40 pm)
Seattle at LA Angels
(10:05 pm)
Philadelphia at San Diego
(10:10 pm)

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