+- International Simulation Football League (https://forums.sim-football.com)
+-- Forum: Community (https://forums.sim-football.com/forumdisplay.php?fid=5)
+--- Forum: Discussion (https://forums.sim-football.com/forumdisplay.php?fid=33)
+---- Forum: Suggestion Box (https://forums.sim-football.com/forumdisplay.php?fid=34)
+----- Forum: Archived Suggestions (https://forums.sim-football.com/forumdisplay.php?fid=349)
+----- Thread: TPE League Index (/showthread.php?tid=2561)
TPE League Index - Muford - 07-24-2017
In the previous leagues I was in, long ago it was something we had. Broke down players by position and team and had the top 10 for highest TPE earned.
http://z6.invisionfree.com/MSFL_Reborn/ind...showtopic=10021 is how it looked
Maybe we can do that here as well? Lets people see whats going on with the teams and put an average out there for the league to see it.
@Ballerstorm
TPE League Index - Admin - 07-24-2017
I'm willing to pay this as a job if somebody wants to keep it updated every week with updates.
TPE League Index - 37thchamber - 07-24-2017
I'm actually maintaining a googledocs sheet that tracks TPE and player stats... don't think I'm the only one either.
Gets tricky when there's more players though. Takes a while to update everything at the moment so I'm gonna write something to automatically calculate TPE from player attributes after the index is updated.
Let me get back to you in a couple days
TPE League Index - Noble - 07-24-2017
Ooh this would be fun!
TPE League Index - Muford - 07-24-2017
I'd be willing to do it, but might want a second person to do it so we can split the conferences.
TPE League Index - timeconsumer - 07-24-2017
(07-24-2017, 03:22 PM)37thchamber Wrote:I'm actually maintaining a googledocs sheet that tracks TPE and player stats... don't think I'm the only one either.
I have no idea who else would do such a thing....
TPE League Index - 37thchamber - 07-27-2017
So... as mentioned earlier, I tried to create a way to calculate TPE in spreadsheet form based on player attributes pasted from the sim (because then it's really easy to show the TPE leaders based on various criteria) but I'm seeing a lot of numbers that don't match up between the sim and update threads...
If updaters keep track of player stats (including fractional stats and banked TPE) in a central sheet, it's relatively easy to add a formula to that and get total TPE. Then add a separate lookup to calculate base TPE and find the difference.
This is the method I tried, but I don't have time to go through every player profile myself and update banked TPE and fractional stats, and I can't rely on taking stats as listed in the sim. Though I suppose my attempts have highlighted a few apparent errors in the listed stats in the sim. Adam Bennett, for example. He appears to have the wrong STR, INT, PBL and RBL stats listed in the sim.
This is a trimmed down version of what I have so far:
https://docs.google.com/spreadsheets/d/1CoT...dit?usp=sharing