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: 94)
Joined: 28 Feb 2004
Home Cafe: Baseball

Return to Baseball Leftovers

Who is online

Users browsing this forum: No registered users and 7 guests

Forums Articles & Tips Sleepers Rankings Leagues

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

Houston at NY Yankees
(1:05 pm)
Cleveland at Minnesota
(1:10 pm)
Detroit at Tampa Bay
(1:10 pm)
Arizona at Washington
(4:05 pm)
LA Angels at Boston
(7:10 pm)
Atlanta at Cincinnati
(7:10 pm)
San Francisco at Chi Cubs
(8:05 pm)
San Diego at LA Dodgers
(10:10 pm)

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