salaries_public_2010.xls

[wavygravy2k]

Is there anyone who has taken the time to turn the player name cells into clickable hyperlinks.

Example:
http://fantasygames.sportingnews.com/images/stratomatic/salaries/salaries_public_2010.xls

[wavygravy2k]

I think I found a way to do this for spreadsheets in Google docs at least. I don't have Microsoft Office.

I was wondering how people fill out their draft list? Do you use the Draft Center on SportingNews or do you use Excel or Google Docs? Some drawbacks to the SportingNews method:

1. It doesn't show how much you have spent on pitching.
2. You have to switch between the Draft List page and free agent page.
3. You have to purchase a team in advance in order to be able to use the tool.

I'm currently using Google Docs Spreadsheets when I'm planning my next team.

[keyzick]

I start out the season paying closer attention on an excel spreadsheet from the SOM player list download...but after 9-10 seasons with a set, I just do the rest the old fashioned way - reading the cards, try not to leave holes, balance offense/defense, etc.. In other words, I play too much and kinda commit the cards to memory. :?

[tjbraun]

[quote:643d3254dd="wavygravy2k"]I think I found a way to do this for spreadsheets in Google docs at least. I don't have Microsoft Office.

I was wondering how people fill out their draft list? Do you use the Draft Center on SportingNews or do you use Excel or Google Docs? Some drawbacks to the SportingNews method:

1. It doesn't show how much you have spent on pitching.
2. You have to switch between the Draft List page and free agent page.
3. You have to purchase a team in advance in order to be able to use the tool.

I'm currently using Google Docs Spreadsheets when I'm planning my next team.[/quote:643d3254dd]I fully admit that I'm a complete nerd. Every year I download the xls and each year I manipulate the data a little more each time. This year I added an analysis to compare defense more realistically based on http://strato.berce.us/fielding.htm This year I also designed a bunch of macros to take a raw strat card and evaluate it for BA/OBP/SLG/OPS/RC based on a specific ballpark (that I can choose each time I analyze a card), vs L, vs R and combined. I used to pull vs L/vs R stats from yahoo sports but I realized quickly that the "real" data didn't always fit what the strat card actually said. I also come up with a true base stealing ability number. Each team I construct has its own tab that cross references the player data to tell me my starting 9 RC, team salary and gives me good number to build my lineup to know where I have difficiencies. I hope to spend more time on pitching next year coming up with calcs that do a better job of predicting their value. I haven't spent much time with that because I haven't been able to figure out how to create metrics like FIP/WHIP from a card because its so hard to get to a per innings pitched # based on per batter faced strat card. I also track how I ranked my whole team each time to see where I should try to what players other people do/don't want and can remember that I can consistently get the DH I like by ranking him 19th or maybe I need to bump him up to 10th because I consistently lose out on someone I really want that I thought I could get at 15-18.

[Valen]

Ignore WHIP when you do your pitcher spreadsheet evaluation. Impossible to correlate. Instead treat it just like a hitters card. Calculate BA, OBP, SLG, RC just like for hitters. Just when you sort them reverse order as low is good.

I used to do the same thing with each 200x season and ATG. Everything about the cards was tracked. It was a little fun to identify and attempt to draft only batters with a H&R rating of B but after a few years decided it was too much work and had began to feel like a job. The more it felt that way the worse my teams were. So now I tend to wing it more and trust my experience/instincts.

[tjbraun]

[quote:d014bc6901="Valen"]Ignore WHIP when you do your pitcher spreadsheet evaluation. Impossible to correlate. Instead treat it just like a hitters card. Calculate BA, OBP, SLG, RC just like for hitters. Just when you sort them reverse order as low is good.

I used to do the same thing with each 200x season and ATG. Everything about the cards was tracked. It was a little fun to identify and attempt to draft only batters with a H&R rating of B but after a few years decided it was too much work and had began to feel like a job. The more it felt that way the worse my teams were. So now I tend to wing it more and trust my experience/instincts.[/quote:d014bc6901]I actually do have BA/OBP/SLG/OPS/RC for pitchers cards...but for some reason I just tend to go with my gut more on pitchers and once I find a combo that works, I stick with it.