Announcement

Collapse
No announcement yet.

TWDT-D Stats -- WEEK 2

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • TWDT-D Stats -- WEEK 2

    Originally posted by Ricko View Post
    is anyone doing the individual player stats number crunching for the season? Always fun to look at exactly who's doing what in each league
    I'm guessing you're interested in warbird, and they're the quickest to do, so here. No promises on updating them or doing other leagues. Maybe jav if people want, but def not base, as it's 10x more work.



    Last edited by ogron; 05-03-2017, 04:21 AM.
    top 100 basers list

  • #2
    i can do jav because its also pretty much just copy paste score boxes into excel, converting text into columns, and pulling data. wouldn't take longer than 10mins to make some sort of a table.

    base on the other hand is much more work and i wouldn't bother doing it myself.

    Comment


    • #3
      nice one, cheers claus! Hopefully we can keep this updating every week (if needs be someone else does it)
      TWL-J Season 11 Champion
      TWL-J Season 21 Champion
      TWL-B Season 21 Champion
      TWL-B Season 22 Finalist
      TWDT-D 2017 Champion
      TWDT-J 2017 Champion

      Comment


      • #4
        Originally posted by Turban View Post
        i can do jav because its also pretty much just copy paste score boxes into excel, converting text into columns, and pulling data. wouldn't take longer than 10mins to make some sort of a table.

        base on the other hand is much more work and i wouldn't bother doing it myself.

        If you want to copy my formatting, the Google Sheet is here: https://docs.google.com/spreadsheets...it?usp=sharing

        I actually just copy/paste the boxscores into Excel in the TWDT-D INPUT tab, then separate the data, do a quick cleanup, then c/p it to Google Sheets bc I find they look nicer.

        Excel Sheet is here: https://www.dropbox.com/s/kzk481wfie...tats.xlsx?dl=0
        top 100 basers list

        Comment


        • #5
          Originally posted by Ricko View Post
          nice one, cheers claus! Hopefully we can keep this updating every week (if needs be someone else does it)

          Depends on how well I do in wb :laugh:
          top 100 basers list

          Comment


          • #6
            Originally posted by Claushouse View Post
            Depends on how well I do in wb :laugh:
            Seeing that you don't have Ease to hide behind, I guess this is the first and last stat update that will be seen. Thanks for your effort (stayon said I should be more appreciative).....fag
            tmaC> 1:fireballz> im the greatest coordinator of all time
            capE> lucky he didnt say captain
            capE> LOL BURN

            Tapzu> tamzu vleane, we all know tou copied that nick from me

            1:merce> ima go take a shower and try to suk my own dick

            9:Fludd> guys, i want u all to know something..
            9:megaman89> fludd go play monopoly with children and dome

            1:Kentaro> nice gay name elven
            1:Kentaro> suits you well
            1:PUTAO> fuk urself fuk emo, ur mother suck mu penis all day screaming my name

            Comment


            • #7
              Thanks for this! Dont forget my week 1 stats 10-6
              British> my 18th tomoz $$
              Sol ^> 18 and scouse, so that two kids you have by now, brit? :)

              i.d.> I just farted and shit myself alittle bit

              Comment


              • #8
                Originally posted by Attacks View Post
                Thanks for this! Dont forget my week 1 stats 10-6

                Ya, sorry for that, I thought I'd caught all the data errors. Sometimes the Kill score doesn't separate in Excel, so your name is listed as "Attacks 10" and so the VLookup function in the other sheet doesn't register it as a game for you:




                I'm usually more thorough but I put it up rather hastily for Ricko, I'll double check it again and re-post an updated version. Let me know if you see any other mistakes.
                top 100 basers list

                Comment


                • #9
                  EDIT: Found a few more of those errors, Attacks

                  EDIT 2: Added vys

                  Attacks (10-6)
                  Geio (6-10)
                  Kira (9-10)
                  vys (14-5)

                  Those 3 scores have been added to the list (https://docs.google.com/spreadsheets...it?usp=sharing)

                  I think that should be all of them!
                  Last edited by ogron; 05-03-2017, 04:15 AM.
                  top 100 basers list

                  Comment


                  • #10
                    I'm sure I played 2 games in week 1. But only the first game is recorded
                    Best warbird to ever enter trenchwars

                    Comment


                    • #11
                      Originally posted by Vys View Post
                      I'm sure I played 2 games in week 1. But only the first game is recorded

                      Oh, ya, your name got cut-off in the c/p just below spezz:


                      https://gyazo.com/78b902ef2486524a65fbcd3719e6bb4b

                      Added it to the list, thanks
                      top 100 basers list

                      Comment


                      • #12
                        Updated
                        top 100 basers list

                        Comment


                        • #13
                          good shit claus

                          Comment

                          Working...
                          X