Team Stats

[PSUColonel]

I know you can view team stats, but the problem is how it's setup. I am looking for a way to view team stats in a sortable way....e.g. team runs scored, team runs against, team OPS etc...

Is there anyway to do this? I ask because I'd like to know how my team ranks compared to other clubs in the league. If there isn't a way, isn't this really something OOTP should have? To mean this is sort of a biggie, as it's tough to gauge where you need help. I know you can see how you rank within your League, but I want to see how my teams ranks in the MLB, not just the NL.

[homerj]

I don't believe you can, you can go into "team stats" and see the numbers, but everything is sorted by division or subleague as you said.

What you want(and I would love as well), is just to have a report that's "here's every team's batting average". Because although the game will tell you may be 4th or whatever, you have no idea where everyone else is easily.

[swoboda]

I have asked for this on the wishlist thread in the past. I don't think it can be done right now.
Sortable team stats. !!

[PSUColonel]

Originally Posted by swoboda

I have asked for this on the wishlist thread in the past. I don't think it can be done right now.
Sortable team stats. !!

Why not? It's already being done on some level.

[Bluenoser]

If you open the Batting/Pitching/Fielding "Report", you can sort by header but it still only does by division. Would be nice to be able to sort by entire league, but doing by division you can sort the divisions and then eyeball where you are at least.

[NoOne]

you can see your team ranks in team info.. team stats shows it all but you cannot sort, and it is by sub-league as with the team info.

you could make a spreadsheet to automate the process. it will update itself upon opening if linked to a csv dump file. you can make it as pretty as you wish or something basic. just open it up, click update, and see all the stats you want in any way you want to contruct them from the data given. you can definitely do what you want to do.

[PSUColonel]

Originally Posted by NoOne

you can see your team ranks in team info.. team stats shows it all but you cannot sort, and it is by sub-league as with the team info.

you could make a spreadsheet to automate the process. it will update itself upon opening if linked to a csv dump file. you can make it as pretty as you wish or something basic. just open it up, click update, and see all the stats you want in any way you want to contruct them from the data given. you can definitely do what you want to do.

Could you give me step by step instruction on how to accomplish this? Sorry, I have never played around with those functions.

Thanks

[RonCo]

You can, of course, write a thousand such reports from the csv files if you have that time, or the technical know-how. Or, for sorting team stats one time, you can simply open a batting/pitching/fielding report in a browser and copy it over into an Excel sheet and sort to your heart's content.

All of these are pains in the tail, though.

[homerj]

This is something that MAY be doable via a report template. But I haven't dug around in there in ages. Last time I did was to fix their javascript sorting so "Tied" wouldn't go to the top or bottom of a list.

Documentation is kind of sketchy at best what all you can do with templates, if there's some sort of updated documentation, I'll have a look at it.

[NoOne]

Originally Posted by PSUColonel

Could you give me step by step instruction on how to accomplish this? Sorry, I have never played around with those functions.

Thanks

for a quick fix do what ronco says.

google: "openoffice calc" with these individual terms "Average()" "sum()" "how to fill formulas", "import from file" "How to sort" etc... anything i mention, use the keyword along with app name (i don't use excel, there may be some semantical differences).

so, you export the csv data. open a spreadsheet and import data from a file to a new worksheet. once you create this link, it will always ask to "update links" when you open the spreadsheet. now, anytime you export data it will update with that new data when you open your spreadsheet file. also, if sorting will help you do anything, make use of it. maybe sort by teamID

on a clean worksheet, start organizing your thoughts. what kind of stats do you want, if beyond by team. if you don't want anything more or want to add to it later, do what ron suggested. just think of the stats tables you saw in the sports page growing up or on espn.com... make it look similar.

so, make some labels for each team and stat. lets jsut say team BA, for example. i'd make a table called TEAM BA across top, then 2 columns below for each team name and the batting average.

in the cell next to the team label for the various stat, type "=Formula"

for batting average, you want to do an =Average(cell1:cell2) ...

after you type "=average(" click the worksheet with the data, go to that team's ID#, highlight all the fields. after that you should see the starting cell and the ending cell inside the parenthese. hit enter or continue with your formula if more sophisticated by closing the ")" and typing more.

when you do a "=forumla.." you can do more than simple stuff. you can make your own functions, you can take that average divide it by era average if you want ... not htat you would... but if you make proper use of parentheses just like you learned in algebra, you can figure it out becasue of relative experiences in the past.

there are team stat exports, so i don't think you'll have much heavy lifting beyond summing, averageing or other basic stuff. i don't think you'll have to make use of If statements and such.

[PSUColonel]

will "open office calc" work with mac? I have numbers, which works much the same way as Excel.