stat entry system - Fantasy Baseball Cafe 2014 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to Commissioner's Corner

stat entry system

Moderator: Baseball Moderators

Re: stat entry system

Postby Tavish » Tue Aug 10, 2010 12:25 pm

Pos(t)er wrote:After looking this over, it seems a little out of my league, as I know nothing about Excel or how to import files, etc. Would anyone be willing to just set up a template for me? I would be able to pay for your time. Once everything is set up, I would probably be able to update the file with current stats.

Standard 5X5 scoring?
Image

Bury me a Royal.
Tavish
Mod in Retirement
Mod in Retirement

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeCafe SpotterWeb Supporter
Posts: 11067
(Past Year: 25)
Joined: 3 May 2004
Home Cafe: Baseball

Re: stat entry system

Postby Pos(t)er » Tue Aug 10, 2010 12:30 pm

yep.

r / hr / rbi / sb / avg
w / k / sv / era / whip
Pos(t)er
Little League Legend
Little League Legend


Posts: 11
Joined: 29 Jul 2010
Home Cafe: Baseball

Re: stat entry system

Postby Tavish » Tue Aug 10, 2010 12:46 pm

Here you go. I haven't really tested it but everything should work but if not let me know.

http://barnstormbaseball.com/standing_rank.xls

*Edit - I guess some basic instructions would be good.

There are 3 sheets 1 with hitter stats, 1 with pitching stats, and one that pulls all the info together. Go through the hitters and pitchers stats and put the team number you want the player to be on in the first column. It should automagically update the team totals and the standings. I used a pretty basic standings formula so it might not work with 3-way or more ties.

*Edit 2 - If you want to update the stats later simply copy/paste the dougstat page into the stat page (starting with B1 just make sure you don't copy the pre open or pre close tag). Do a text to column delimited by the space character.
Image

Bury me a Royal.
Tavish
Mod in Retirement
Mod in Retirement

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeCafe SpotterWeb Supporter
Posts: 11067
(Past Year: 25)
Joined: 3 May 2004
Home Cafe: Baseball

Re: stat entry system

Postby Tavish » Tue Aug 10, 2010 1:06 pm

Doh, minor error in the ranking functions. Should be fixed now.
Image

Bury me a Royal.
Tavish
Mod in Retirement
Mod in Retirement

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeCafe SpotterWeb Supporter
Posts: 11067
(Past Year: 25)
Joined: 3 May 2004
Home Cafe: Baseball

Re: stat entry system

Postby Pos(t)er » Tue Aug 10, 2010 1:10 pm

Wow! Thank you so much! You made my day. Really appreciated. I'll add the info and see if there are any bugs. Seems to work really well so far. Again THANKS!
Pos(t)er
Little League Legend
Little League Legend


Posts: 11
Joined: 29 Jul 2010
Home Cafe: Baseball

Re: stat entry system

Postby Tavish » Tue Aug 10, 2010 1:16 pm

Pos(t)er wrote:Wow! Thank you so much! You made my day. Really appreciated. I'll add the info and see if there are any bugs. Seems to work really well so far. Again THANKS!

No problem. The bad part is that when you update the player stats you will have to reinput the teams since they will add new players to the list bumping your team assignments off. There are ways around that too, but that is waaay more work.
Image

Bury me a Royal.
Tavish
Mod in Retirement
Mod in Retirement

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeCafe SpotterWeb Supporter
Posts: 11067
(Past Year: 25)
Joined: 3 May 2004
Home Cafe: Baseball

Re: stat entry system

Postby mrmarley » Tue Aug 10, 2010 1:18 pm

That's pretty slick, Tavish. Was curious what could be put together in a short amt of time. Nicely done.
Image
mrmarley
Minor League Mentor
Minor League Mentor

User avatar

Posts: 717
Joined: 24 Dec 2002
Home Cafe: Baseball
Location: Ann Arbor, MI

Re: stat entry system

Postby Tavish » Tue Aug 10, 2010 1:21 pm

mrmarley wrote:That's pretty slick, Tavish. Was curious what could be put together in a short amt of time. Nicely done.

For the most part that is what I use for draft day, obviously using projections instead of current stats.
Image

Bury me a Royal.
Tavish
Mod in Retirement
Mod in Retirement

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeCafe SpotterWeb Supporter
Posts: 11067
(Past Year: 25)
Joined: 3 May 2004
Home Cafe: Baseball

Re: stat entry system

Postby wrveres » Tue Aug 10, 2010 1:23 pm

good solid work! ;-D
25                "Love the Padres"
Rafael

Dodgers FAIL|Mets FAIL|Canada FAIL
wrveres
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicFantasy ExpertCafe WriterEagle EyeInnovative MemberCafe Musketeer
Posts: 31778
(Past Year: 754)
Joined: 2 Mar 2003
Home Cafe: Baseball

Re: stat entry system

Postby Pos(t)er » Tue Aug 10, 2010 1:28 pm

No problem! This is perfect! Thanks again dude
Pos(t)er
Little League Legend
Little League Legend


Posts: 11
Joined: 29 Jul 2010
Home Cafe: Baseball

PreviousNext

Return to Commissioner's Corner

Who is online

Users browsing this forum: No registered users and 3 guests

Forums Articles & Tips Sleepers Rankings Leagues


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

Philadelphia at Atlanta
(1:10 pm)
NY Mets at Miami
(1:10 pm)
indoors
Boston at Tampa Bay
(1:10 pm)
indoors
Minnesota at Baltimore
(1:35 pm)
Pittsburgh at St. Louis
(2:15 pm)
Milwaukee at Chi Cubs
(2:20 pm)
Seattle at Oakland
(4:05 pm)
Detroit at Cleveland
(4:05 pm)
San Francisco at Colorado
(4:10 pm)
Arizona at San Diego
(4:10 pm)
Texas at Kansas City
(8:10 pm)
Washington at LA Dodgers
(8:10 pm)

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