Projection Software

[pgbridge2000]

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

[Amazinz]

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.

[kimchi_chigae]

this thread should be helpful

http://www.fantasybaseballcafe.com/forums/viewtopic.php?t=88985

[trevisc]

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

[LBJackal]

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

[SHOCKandAWE]

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.

[Amazinz]

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.