Projection Software - Fantasy Baseball Cafe 2015 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to Baseball Leftovers

Projection Software

Moderator: Baseball Moderators

Projection Software

Postby pgbridge2000 » Sun Dec 05, 2004 11:48 pm

I was trying to put together a projection spreadsheet through excel and I ran into some blocks when I was trying to work with combining the weighted statistics from each year that I had (because there were different numbers of people causing different orders each year) Therefore my questions are as follows: Is there a better way to do this than excel? If not, how can I make this work on excel (like is there a place that can give me spreadsheets of the players statistics for the previous 3 years listed in the same row)?
Thanks
There are 3 ways to do things, the right way, the wrong way, and the Max Power way!
Image
pgbridge2000
Softball Supervisor
Softball Supervisor

User avatar

Posts: 98
Joined: 20 Sep 2004
Home Cafe: Baseball
Location: My Computer

Postby Amazinz » Mon Dec 06, 2004 2:27 am

There is an easier way if you're comfortable with Access or SQL. Download the Lahman database and write a query that pulls the data into Excel in the format that you want it.
Image
Maine has a good swing for a pitcher but on anything that moves, he has no chance. And if it's a fastball, it has to be up in the zone. Basically, the pitcher has to hit his bat. - Mike Pelfrey
Amazinz
Mod in Retirement
Mod in Retirement

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeWeb SupporterPick 3 Weekly WinnerSweet 16 SurvivorLucky Ladders Weekly Winner
Posts: 18800
Joined: 16 Mar 2004
Home Cafe: Baseball
Location: in Canada, toughening up figure skaters

Postby kimchi_chigae » Mon Dec 06, 2004 7:12 am

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: 194)
Joined: 27 May 2004
Home Cafe: Baseball
Location: Osaka Jail

Postby trevisc » Mon Dec 06, 2004 9:34 am

My private collection of software the i've created was done in Visual Basic .NET using either Access as the database or in one case XML so I can eventually post results as a webpage. Excel is awesome at doing complex calculations but i'm more comfortable using .NET since i've been using it for over 2 years now
trevisc
Hall of Fame Hero
Hall of Fame Hero

User avatar
Fantasy ExpertCafe Ranker
Posts: 11271
Joined: 6 Jan 2003
Home Cafe: Baseball
Location: Fantasy Baseball Cafe 2004,2005 Keeper League Champion

Postby LBJackal » Mon Dec 06, 2004 1:32 pm

Hey, trev's back! Just in time for the LOTR ROTK expanded DVD set :-D
Image

"Jack, will you call me, if you're able?"

"I've got your phone number written, in the back of my Bible."
LBJackal
Hall of Fame Hero
Hall of Fame Hero

User avatar
Pick 3 Weekly Winner
Posts: 9196
Joined: 1 Jul 2003
Home Cafe: Baseball
Location: The Hotel Yorba

Postby SHOCKandAWE » Mon Dec 06, 2004 1:59 pm

I have my own system and spreadsheet that I use in excel. Tons of macros and so forth but be good. I recommend reading Henry Lee book if you get a chance. I like how he sets up his spreadsheets.
Image
SHOCKandAWE
General Manager
General Manager

User avatar
CafeholicCafe RankerCafe MusketeerPick 3 Weekly WinnerLucky Ladders Weekly Winner
Posts: 3522
Joined: 8 Feb 2004
Home Cafe: Baseball
Location: Pennsylvania

Postby Amazinz » Mon Dec 06, 2004 2:00 pm

trevisc wrote:My private collection of software the i've created was done in Visual Basic .NET using either Access as the database or in one case XML so I can eventually post results as a webpage. Excel is awesome at doing complex calculations but i'm more comfortable using .NET since i've been using it for over 2 years now

Do you by any chance use the VS.NET Tools for Office? If so what do you think of it? I do a lot of coding in C# but when it comes to Excel/Access I still do most of my work in VBA. I've been considering getting the .NET tools for Office but since I can't get it through work I'll have to buy it myself.
Image
Maine has a good swing for a pitcher but on anything that moves, he has no chance. And if it's a fastball, it has to be up in the zone. Basically, the pitcher has to hit his bat. - Mike Pelfrey
Amazinz
Mod in Retirement
Mod in Retirement

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeWeb SupporterPick 3 Weekly WinnerSweet 16 SurvivorLucky Ladders Weekly Winner
Posts: 18800
Joined: 16 Mar 2004
Home Cafe: Baseball
Location: in Canada, toughening up figure skaters


Return to Baseball Leftovers

Who is online

Users browsing this forum: No registered users and 9 guests

Forums Articles & Tips Sleepers Rankings Leagues


Get Ready...
The 2015 MLB season starts in 15:45 hours
(and 92 days)

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