Spreadsheet help! - Fantasy Baseball Cafe 2014

Moderator: Baseball Moderators

Can anyone help me set up a projection spreadsheet for next year. I just want to do .5, .33. 17. My scoring categories look like this.

Scoring
Batters
R: 1
H: 1
2B: 1
3B: 2
HR: 3
RBI: 1
BB: 1
SO: -1
SB: 2
CS: 1
SAC: 1
GIDP: -1
E: -1
Pitchers:
IP: 1 per 1/3
W: 10
L: -5
SV: 10
BS: -5
CG: 5
SHO: 10
H: -1
BB: -1
K: 1
ER: -1
WP: -1
BK: -1
HBP: -1

Any help on how to set this up would be greatly appreciated. Unfortunately, I don't have any experience with spreadsheets.

Thanks
Music2004Man
Major League Manager

Posts: 1092
Joined: 22 Oct 2003
Home Cafe: Baseball

Thats a ton of calculations, especially since you would be looking at 3 yr averages for things like GIDP and Errors.

Overall, it shouldn't be that hard if you can find all of the necassary stats for all the players over the last 3 years, just very time consuming

The best thing to do is to just open up Excell and start playing around. Thats how most of us learned to use it. start with your simple formulas like BA or RC and then you will get the hang of "Cells, Rows and Columns" in no time.

If you need the last three years of stats, Try this link ..

http://www.dougstats.com/
`25                "Love the Padres"                              RafaelDodgers FAIL|Mets FAIL|Canada FAIL`
wrveres
Hall of Fame Hero

Posts: 31781
(Past Year: 757)
Joined: 2 Mar 2003
Home Cafe: Baseball

Music2004Man
Major League Manager

Posts: 1092
Joined: 22 Oct 2003
Home Cafe: Baseball

I would definitely not recommend using a spreadsheet for three year calculations. Spreadsheets are OK (but not ideal) for one year calculations, but for more than one year, you are going to want to go the way of a database. Using spreadsheets to do the all calculations for three years' worth of data is the equivalent of violating the <a href="http://www.stuart.iit.edu/courses/im510/database/1NF.htm">First Normal Form</a> (i.e. big no-no).

Not to mention, although it may seem daunting to learn how to program a database, it is really quite simple and easy to understand, and it will save you tons and tons of time and the headache of trying to get it to work in a spreadsheet. Microsoft Access is good if you're a DB novice. If you don't have Access and are willing to put in a bit more work, <a href="http://www.mysql.com">MySQL</a> is a (free!) DBMS with a great deal of the same features as commercial DBMS' like Oracle. <a href="http://www.w3schools.com/sql/">Here</a> is a tutorial if you plan on using MySQL.

Edit: Why the blankety-blank aren't the links showing up? Ugh.
Pedantic
Hall of Fame Hero

Posts: 6725
Joined: 5 Dec 2003
Home Cafe: Baseball
Location: Funny movie quote that everyone knows

I have Access and have never figured it out ...
I even downloaded that huge "baseball database", three or four times actually, but cannot figure out how to use it.
`25                "Love the Padres"                              RafaelDodgers FAIL|Mets FAIL|Canada FAIL`
wrveres
Hall of Fame Hero

Posts: 31781
(Past Year: 757)
Joined: 2 Mar 2003
Home Cafe: Baseball

wrveres wrote:I have Access and have never figured it out ...
I even downloaded that huge "baseball database", three or four times actually, but cannot figure out how to use it.

Once you get the hang of it, it's much easier and much more powerful than a spreadsheet. It's definitely worth the effort. If I had to do all the things in Excel that I've done in a database, I'd probably die.

For instance, instead of killing yourself with three-year totals on one spreadsheet, you would have three different tables, each with separate data for each particular year. Then, in one fell swoop (actually, in Access I think it'd have to be two steps, since it's not as powerful as full DBMS'), you could multiply the respective years by the respective numbers, add them up, and voila, you have your three-year calculations. Something like that would probably take five minutes or less in a DB once you know what you're doing. Not to mention, you'd have the ability to sort the new table by rank or filter for certain numbers or even positions or perform any number of complex calculations. Now think how long that would take in Excel. Yeah.
Pedantic
Hall of Fame Hero

Posts: 6725
Joined: 5 Dec 2003
Home Cafe: Baseball
Location: Funny movie quote that everyone knows

Pedantic wrote:
wrveres wrote:I have Access and have never figured it out ...
I even downloaded that huge "baseball database", three or four times actually, but cannot figure out how to use it.

Once you get the hang of it, it's much easier and much more powerful than a spreadsheet. It's definitely worth the effort. If I had to do all the things in Excel that I've done in a database, I'd probably die.

For instance, instead of killing yourself with three-year totals on one spreadsheet, you would have three different tables, each with separate data for each particular year. Then, in one fell swoop (actually, in Access I think it'd have to be two steps, since it's not as powerful as full DBMS'), you could multiply the respective years by the respective numbers, add them up, and voila, you have your three-year calculations. Something like that would probably take five minutes or less in a DB once you know what you're doing. Not to mention, you'd have the ability to sort the new table by rank or filter for certain numbers or even positions or perform any number of complex calculations. Now think how long that would take in Excel. Yeah.

Yeah no kidding ...

wrveres new years resolution ....
Learn Microsoft Access ...
`25                "Love the Padres"                              RafaelDodgers FAIL|Mets FAIL|Canada FAIL`
wrveres
Hall of Fame Hero

Posts: 31781
(Past Year: 757)
Joined: 2 Mar 2003
Home Cafe: Baseball

haha, oh man, so I've never even set up a spreadsheet before and now I'm going to try a database. This could be interesting. Have you set-up a database for 3 year stats, Pedantic?
Music2004Man
Major League Manager

Posts: 1092
Joined: 22 Oct 2003
Home Cafe: Baseball

I tried using Access and I got way too confused. I got the info in the database, I can run queries and stuff, but it doesn't really help more than Excel. How would I go about doing what you just said; like taking 3 year averages? It's not really what I'm looking to do, but it would be pretty much the same thing (only loking at more than 3 years).

How do you get more than one group of info into the database? As of now, I can only get one. Maybe a little beginner's guide would be nice; since you seem to know what you're doing, and know what we need to use Access for, I'm sure it wouldn't take too long to help us Access-illiterate excel users to learn how to properly use a database

"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

Posts: 9196
Joined: 1 Jul 2003
Home Cafe: Baseball
Location: The Hotel Yorba

Pedantic wrote:
wrveres wrote:I have Access and have never figured it out ...
I even downloaded that huge "baseball database", three or four times actually, but cannot figure out how to use it.

Once you get the hang of it, it's much easier and much more powerful than a spreadsheet. It's definitely worth the effort. If I had to do all the things in Excel that I've done in a database, I'd probably die.

For instance, instead of killing yourself with three-year totals on one spreadsheet, you would have three different tables, each with separate data for each particular year. Then, in one fell swoop (actually, in Access I think it'd have to be two steps, since it's not as powerful as full DBMS'), you could multiply the respective years by the respective numbers, add them up, and voila, you have your three-year calculations. Something like that would probably take five minutes or less in a DB once you know what you're doing. Not to mention, you'd have the ability to sort the new table by rank or filter for certain numbers or even positions or perform any number of complex calculations. Now think how long that would take in Excel. Yeah.

Pedantic, you can just use Excel as the frontend to the database. You can set all of your queries up in Excel to access your Access database (or any other database of you choosing). Instead of viewing it as one or the other look into using both.

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

Posts: 18800
Joined: 16 Mar 2004
Home Cafe: Baseball
Location: in Canada, toughening up figure skaters

Next

### Who is online

Users browsing this forum: No registered users and 9 guests

Forums Articles & Tips Sleepers Rankings Leagues

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

 • Cincinnati at Baltimore(7:05 pm)
 • Detroit at Cleveland(7:05 pm)
 • Boston at NY Yankees(7:05 pm)