help with spreadsheets - Fantasy Baseball Cafe 2014 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to Baseball Leftovers

help with spreadsheets

Moderator: Baseball Moderators

help with spreadsheets

Postby longbombers1 » Mon Feb 14, 2005 6:45 pm

how do i make a spreadsheet? and what is the most accurate formula to project stats?
longbombers1
Softball Supervisor
Softball Supervisor

User avatar

Posts: 60
Joined: 29 Jan 2005
Home Cafe: Baseball

Re: help with spreadsheets

Postby Tavish » Mon Feb 14, 2005 6:51 pm

longbombers1 wrote:how do i make a spreadsheet? and what is the most accurate formula to project stats?


Use a spreadsheet program such as Excel or Calc. There is no "most accurate" formula for projections, they all are only best guesses. Most big-name projection formulas are proprietary designs so you won't be able to run them and they honestly are not much better than using 3-year averages and adjusting them for park changes/injuries/changes in playing time. Good luck.
Image

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

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

Postby longbombers1 » Mon Feb 14, 2005 7:02 pm

how do i get excel?
longbombers1
Softball Supervisor
Softball Supervisor

User avatar

Posts: 60
Joined: 29 Jan 2005
Home Cafe: Baseball

Postby Tavish » Mon Feb 14, 2005 7:07 pm

Buy it as part of the M$ Office Suite. Calc is part of OpenOffice and can be downloaded for free.
Image

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

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

Postby longbombers1 » Mon Feb 14, 2005 7:26 pm

where can i download calc from?
longbombers1
Softball Supervisor
Softball Supervisor

User avatar

Posts: 60
Joined: 29 Jan 2005
Home Cafe: Baseball

Postby shpuck » Mon Feb 14, 2005 7:53 pm

A simple google search found this:

http://www.openoffice.org/

Download the suite and you should be good to go. I must admit I don't use it though so don't ask me any particulars on the program.

If you have any questions, I"m sure you can google "FAQ Open Office Calc" and peruse the hits.
shpuck
Minor League Mentor
Minor League Mentor

User avatar
Pick 3 Weekly Winner
Posts: 469
Joined: 13 Apr 2003
Home Cafe: Baseball
Location: Goleta, CA

Postby Cooner » Mon Feb 14, 2005 8:01 pm

shpuck wrote:A simple google search found this:

http://www.openoffice.org/

Download the suite and you should be good to go. I must admit I don't use it though so don't ask me any particulars on the program.

If you have any questions, I"m sure you can google "FAQ Open Office Calc" and peruse the hits.


calc is easy to use- basically everything you want to do in calc is the same as in excel. A couple things are different (pivot tables have a different name, but are otherwise the same) but they're all pretty advanced topics... definitely not needed for projections. I'm using calc exclusively now and haven't found anything i could do in excel that i can't make work in calc with little to no adaptation.
Cooner
Major League Manager
Major League Manager

User avatar

Posts: 1028
Joined: 2 May 2004
Home Cafe: Baseball
Location: my home is in NYC, my heart is in PNC Park


Return to Baseball Leftovers

Who is online

Users browsing this forum: apz, germani40, Ray Zorback, slink, wingman3110 and 14 guests

Forums Articles & Tips Sleepers Rankings Leagues


Today's Games
Saturday, Apr. 19
(All times are EST, weather icons show forecast for game time)

Chi Cubs at Chi Cubs
(1:05 pm)
Minnesota at Kansas City
(1:05 pm)
Cincinnati at Cincinnati
(1:08 pm)
Houston at Oakland
(1:35 pm)
Milwaukee at Pittsburgh
(2:10 pm)
NY Yankees at Tampa Bay
(2:20 pm)
indoors
Seattle at Miami
(4:05 pm)
indoors
NY Mets at NY Mets
(7:05 pm)
Atlanta at Atlanta
(7:10 pm)
Philadelphia at Colorado
(7:10 pm)
Chi White Sox at Texas
(7:10 pm)
LA Dodgers at LA Dodgers
(8:05 pm)
Arizona at Arizona
(8:10 pm)
San Diego at San Diego
(8:10 pm)
San Francisco at San Francisco
(8:40 pm)

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