Stats pages - Anyone feel like testing :D

Discussion in 'General Discussion' started by walesy, Jan 20, 2016.

  1. Owen

    Owen Well-Known Member

    Joined:
    Jan 3, 2016
    Messages:
    432
    Likes Received:
    285
    Yeah leagues is much easier/simpler for me as I just copy straight into spreadsheets with formulas and the such (super time consuming to set up though). I have no coding ability to do otherwise, just good ol' excel and.

    A trade centre would be very cool, although the breakevens showing for each player is a good indication, could you have a smaller cash prediction graph like a spark line from excel next to each player?
     
  2. walesy

    walesy Administrator Staff Member

    Joined:
    Nov 30, 2015
    Messages:
    3,872
    Likes Received:
    2,565
    Might need to make it a donor thing- as I can see it getting pretty resource hungry if a bunch of people jump on. :D

    Will definitely aim to have it happening though.

    Yeah- At-a-glance type information might be the way to go to start with. Just need to come up with a good way to display the data so that it's more valuable than what's currently seen on the stats page. :D
     
    • Like Like x 1
  3. TheTassieHawk

    TheTassieHawk SC fanatic Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    7,622
    Likes Received:
    6,601
    Walesy in regards to a "trade centre" section what would be really powerful is something that lets you plan trades over multiple weeks - preferably through to Round 23, normally I start doing this around round 7 or 8 and update it weekly so something you can "save" and rollover which updates the weekly predicted "cash remaining" balance based on the previous rounds scoring would be the ultimate

    if you do this sort of planning yourself then no doubt you would have some idea of what type of functionality it needs, otherwise I can send you a spready with some examples from 2015
     
  4. walesy

    walesy Administrator Staff Member

    Joined:
    Nov 30, 2015
    Messages:
    3,872
    Likes Received:
    2,565
    I've always been meaning to, but have never gotten around to it, so if you feel like sharing, drop us an email.

    I know my old man Has a spready that he plans his future trades on and he's always been successful. :)

    Also, what is this ungodly hours that we are up at! Why does this even exist!
     
  5. Owen

    Owen Well-Known Member

    Joined:
    Jan 3, 2016
    Messages:
    432
    Likes Received:
    285
    That would be pretty handy. It could be a 3 or 4 week rolling thing through the season where you pick one or two trade in targets, a player or two to trade out, and it compares their predicted cash into future rounds using your salary prediction graphs/number crunching. It could predict automatically or you could enter their scores as well. This is what I do when planning future trades.
     
  6. TheTassieHawk

    TheTassieHawk SC fanatic Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    7,622
    Likes Received:
    6,601
    email sent
     
  7. TheTassieHawk

    TheTassieHawk SC fanatic Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    7,622
    Likes Received:
    6,601
    2 or 3 or 4 weeks would kick butt - anything longer lets you put ALL of your rookies in order of who you are looking to trade out quickly and who you are going to keep until midseason when you are looking to complete your team

    It sounds like Owen has a similar method to me to guessing how rookies will rise or fall but I just look at the next 3 predicted price rises, however rather than predicting scores directly I taking 75% of the first price rise and 50% of each of the next 2 price rises as I find it it is quicker to do this than plug all of the numbers in. If a rookie is predicted to lose cash I assume they will lose 100% of the amount predicted. Anything beyond 3 weeks is too uncertain so I pretty much take a stab in the dark knowing it will all change a week later anyway if one rookie scores 110 while another scores 40.

    The other part is figuring out how much you will be paying for premiums in future weeks which takes some educated guesses based on current prices and breakevens and again this changes from week to week, normally increasing when my rookies hit their average rather than underperform by quite a bit as factored into my calculations.
     
  8. walesy

    walesy Administrator Staff Member

    Joined:
    Nov 30, 2015
    Messages:
    3,872
    Likes Received:
    2,565
    Legend. I'll check it out when I get the chance.

    (am currently in the hospital with #4. Poor little tacker is now sans tonsils and adnoids)

    So, probably not until tomorrow
     
  9. TheTassieHawk

    TheTassieHawk SC fanatic Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    7,622
    Likes Received:
    6,601
    not a priority at all mate - hope the little one bounces back as well as can be expected
     
  10. TheTassieHawk

    TheTassieHawk SC fanatic Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    7,622
    Likes Received:
    6,601
    if anyone would be so kind to check these d.o.b's for me (for young players picked up in the ORFFF draft which has just been completed) on footywire or some other place I would much appreciate it - be warned I expect a lot of mistakes due to much of the data being sourced and copied late at night and/or while multitasking

    once confirmed or corrected I can start any updating and/or look up some of the remaining 1/1/1900 players

    Charlie Cameron ADE 05-Jul-94
    Riley Knight ADE 27-Mar-95
    Dean Gore ADE 26-Jun-96
    Harrison Wigg ADE 16-Oct-96
    Wayne Milera ADE 14-Sep-97
    Jarrad Jansen BRL 02-May-95
    Jaden McGrath BRL 15-Jun-96
    Harris Andrews BRL 11-Dec-96
    Rhys Mathieson BRL 10-Jan-97
    Josh Schache BRL 21-Aug-97
    Eric Hipwood BRL 13-Sep-97
    Ed Curnow CAR 07-Nov-89
    Nick Graham CAR 12-Jun-94
    Charlie Curnow CAR 03-Feb-97
    David Cuningham CAR 30-Mar-97
    Jacob Weitering CAR 23-Nov-97
    Mason Cox COL 14-Mar-91
    Jackson Ramsay COL 20-Nov-94
    Matthew Scharenberg COL 18-Sep-95
    Darcy Moore COL 25-Jan-96
    Tom Phillips COL 07-May-96
    Martin Gleeson ESS 25-Aug-94
    Orazio Fantasia ESS 14-Sep-95
    Ed Langdon FRE 01-Feb-96
    Lachie Weller FRE 23-Feb-96
    Connor Blakely FRE 02-Mar-96
    Darcy Tucker FRE 23-Jan-97
    Keegan Brooksby GCS 27-Apr-90
    Alex Sexton GCS 03-Dec-93
    Peter Wright GCS 08-Sep-96
    Callum Ah Chee GCS 09-Oct-97
    Sam Menegola GEE 07-Mar-92
    Cory Gregson GEE 04-Sep-96
    Daniel Lloyd GWS 18-Feb-92
    James Stewart GWS 04-Mar-94
    Lachie Whitfield GWS 18-Jul-94
    Cam McCarthy GWS 01-Apr-95
    Jake Barrett GWS 08-Nov-95
    Paul Ahern GWS 01-Aug-96
    Jarrod Pickett GWS 18-Aug-96
    Matthew Kennedy GWS 06-Apr-97
    Jonathan O'Rourke HAW 21-Apr-94
    James Sicily HAW 06-Jan-95
    Ryan Burton HAW 31-Jan-97
    Kieran Lovell HAW 16-May-97
    Dean Kent MEL 24-Feb-94
    Ben Kennedy MEL 03-Mar-94
    James Harmes MEL 05-Oct-95
    Alex Neal-Bullen MEL 09-Jan-96
    Mitchell King MEL 01-Jan-97
    Sam Weideman MEL 26-Jun-97
    Damien Cavka WCE RETIRED
    Taylor Garner NTH 08-Jan-94
    Trent Dumont NTH 30-Jun-95
    Kayne Turner NTH 31-Dec-95
    Mitchell Hibberd NTH 23-Sep-96
    Nathan Krakouer PTA 05-May-88
    Jimmy Toumpas PTA 02-Jan-94
    Karl Amon PTA 19-Aug-95
    Jesse Palmer PTA 17-Oct-96
    Billy Frampton PTA 20-Nov-96
    Riley Bonner PTA 07-Mar-97
    Nathan Broad RIC 15-Apr-93
    Corey Ellis RIC 09-Oct-96
    Daniel Rioli RIC 16-Apr-97
    Jack Sinclair STK 12-Feb-95
    Nathan Freeman STK 16-Jun-95
    Blake Acres STK 07-Oct-95
    Paddy McCartin STK 19-Apr-96
    Daniel McKenzie STK 17-May-96
    Jack Lonie STK 13-Aug-96
    Bailey Rice STK 10-Feb-97
    Jade Gresham STK 21-Aug-97
    Brandon Jack SYD 25-May-94
    Zak Jones SYD 15-Mar-95
    Marcus Adams WBD 30-Jun-93
    Nathan Hrovat WBD 07-Jun-94
    Tom Boyd WBD 22-Aug-95
    Toby McLean WBD 31-Jan-96
    Lukas Webb WBD 04-Mar-96
    Caleb Daniel WBD 07-Jul-96
    Bailey Dale WBD 22-Jul-96
    Josh Dunkley WBD 09-Jan-97
    Kieran Collins WBD 14-Dec-97
    Bailey Williams WBD 10-Oct-97
    Tom Barrass WCE 08-Oct-95
    Tom Lamb WCE 19-Oct-96
    Luke Partington WCE 05-Mar-97
     
    Last edited: Feb 15, 2016
  11. Len

    Len Cockburn Knightrider Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    10,574
    Likes Received:
    6,003
    Hi mate, just checked all the Giants players, all correct bar Matthew Kennedy , his b'day is the 6th not the 14th.

    Great job!
     
  12. walesy

    walesy Administrator Staff Member

    Joined:
    Nov 30, 2015
    Messages:
    3,872
    Likes Received:
    2,565
    Just noticed a bug that had the calculator displaying 2014 AA Team and AA Ground averages.

    Embarrassing! :D

    Also, DOB's are all updated. Thanks TTH
     
    • Like Like x 1
  13. TheTassieHawk

    TheTassieHawk SC fanatic Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    7,622
    Likes Received:
    6,601
    Walesy - is it possible to change the Age field to show to the nearest 0.1 of a year - the main reason I ask is that it seems to lump all 28 year olds together which means the 27.5 year olds (listed as 28) may be listed before the 28.4 year olds (also listed as 28) when the list is meant to be descending in age
     
    • Like Like x 1
  14. walesy

    walesy Administrator Staff Member

    Joined:
    Nov 30, 2015
    Messages:
    3,872
    Likes Received:
    2,565
    yes, I can do that. DB is now churning, will be ready soon. :d
     
    • Like Like x 1
  15. walesy

    walesy Administrator Staff Member

    Joined:
    Nov 30, 2015
    Messages:
    3,872
    Likes Received:
    2,565
    ok- age is now populated back to 1-1-2016.

    It'll rollover with each week.
     
    • Like Like x 2
  16. Jason

    Jason Moderator Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    3,810
    Likes Received:
    1,418
    Chief, not a major issue but for some reason the alerts when you are looking at the stats pages are in a font that is about twice as big as when you look at them from any other page:

    Capture.JPG

    Capture.JPG
     
    • Like Like x 1
  17. walesy

    walesy Administrator Staff Member

    Joined:
    Nov 30, 2015
    Messages:
    3,872
    Likes Received:
    2,565
    Yeah, originally they were way off the bottom of the screen! Getting them up to where they belong was a solid start- but I do need to revisit it. :D
     
  18. walesy

    walesy Administrator Staff Member

    Joined:
    Nov 30, 2015
    Messages:
    3,872
    Likes Received:
    2,565
    Has anyone noticed this button on the myTeam page?

    upload_2016-3-10_9-23-43.png

    It's a handy dandy new feature designed to allow you to plan out your future trading schedule

    Still a bit of a work in progress, but I reckon there's enough functionality there to open it up and get some feedback.

    Also, if everything goes to plan, there will be a report at the end of the year to compare your planned trades with your actual trades. :D
     
    • Like Like x 1
  19. walesy

    walesy Administrator Staff Member

    Joined:
    Nov 30, 2015
    Messages:
    3,872
    Likes Received:
    2,565
    Also, don't copy my backline. :D
     
    • Like Like x 1
  20. Len

    Len Cockburn Knightrider Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    10,574
    Likes Received:
    6,003
    Can't get to create one mate, LHS is prepopulated and I can't see where to edit, I hit save and nothing happened, then tried the RHS and got a "you shouldn't be here" error
     

Share This Page