+- International Simulation Football League (https://forums.sim-football.com)
+-- Forum: Community (https://forums.sim-football.com/forumdisplay.php?fid=5)
+--- Forum: Media (https://forums.sim-football.com/forumdisplay.php?fid=37)
+---- Forum: Graded Statistical Analysis (https://forums.sim-football.com/forumdisplay.php?fid=153)
+---- Thread: *A buncha stuff (/showthread.php?tid=31912)
*A buncha stuff - Gragg9 - 05-07-2021
This is a shameless attempt to get a little paycheck for the various public use tools I’ve put together. These kinda projects don’t lend themselves to word count very well but aid in statistical analysis so hopefully they kinda sorta (not really) fit here.
Draft Order Sheet
https://docs.google.com/spreadsheets/d/1YKF9aYIbq6shbs1XnF3rFZkDeK28PPjRBoHAL7ycShA/edit#gid=1175564076
Takes the draft selections from the budget sheet and sorts them out into a draft order. Standing are set by the user so you can see how it changes as the season goes on. Accounts for all trades *except* ones that ask for the best/worst out of two picks. For now I manually sort those out on a tab included in the sheet.
Player Dashboard
https://docs.google.com/spreadsheets/d/13XCYQNLU9TE2LG5feNyuI_XwKJZ5EvZp47SiM0F4t9g/edit#gid=80750340
Fancy little dashboard that compiles TPE earning, index stats, bank info, build info, rank, and all that kinda stuff into one page. Currently only shows S28 people but is automatically updating and other season will be added soon.
Update Tracker
https://docs.google.com/spreadsheets/d/13XCYQNLU9TE2LG5feNyuI_XwKJZ5EvZp47SiM0F4t9g/edit#gid=106559196
For season 28 or younger. Weekly report on who’s earning what. Includes bank info, class rank, and stats on how each DSFL team is doing TPE-wise. (Minnesota Stronk)
Roster Duplicator
https://docs.google.com/spreadsheets/d/1Jm8pxpTJU2FezF3kSw9Al2EcRFNLbM5nv6hlxU-9oYI/edit#gid=249695295
For use in sim shenanigans. Provides up to date imports for sim testing or whatever ‘fun’ you come up with. See the Choccy Milk testing method to see how I use it.
Sim Interpreter
https://docs.google.com/spreadsheets/d/1I24uoPAxjXSBbtO91ccB2_NyihWhf6fx3t1O2l6JuGE/edit#gid=59109824
Another Sim thang. Takes the ‘_games’ file from the sim export and reads some basic info about how each team does. Useful when dealing with a large number of games/season.
There may be other things I’m forgetting and some I keep for private/team use. I understand if this doesn’t fit within the criteria for a paycheck but it’s worth a shot. Gotta catch up with Shrub’s bank account and I don’t think I could get away with 2000 words of quacking.
RE: A buncha stuff - Yeenoghu - 05-07-2021
This is all great, but what Pokemon am I?
RE: A buncha stuff - Gragg9 - 05-07-2021
(05-07-2021, 10:49 AM)Maglubiyet Wrote: This is all great, but what Pokemon am I?
Believe it or not I have a spreadsheet for that too. Bug @Painted about it.
RE: A buncha stuff - shrub02 - 05-10-2021
don't give this man a bonus!
RE: A buncha stuff - Gragg9 - 05-10-2021
(05-10-2021, 05:30 PM)shrub02 Wrote: don't give this man a bonus!
Thanks for the anti-curse lol
Though with my cursing powers did I just anti curse the anti curse or curse the anti curse? more importantly am I still cursed or not? Or perhaps I cursed your cursing and both you and the post are now uncursed?
RE: A buncha stuff - shrub02 - 05-10-2021
(05-10-2021, 06:46 PM)Gragg9 Wrote:(05-10-2021, 05:30 PM)shrub02 Wrote: don't give this man a bonus!
Thanks for the anti-curse lol
Though with my cursing powers did I just anti curse the anti curse or curse the anti curse? more importantly am I still cursed or not? Or perhaps I cursed your cursing and both you and the post are now uncursed?
This whole comment is cursed