Announcement

Collapse
No announcement yet.

Unofficial stats for TWL

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

  • Unofficial stats for TWL

    Updated to include entire season + playoffs - any voided rounds.

    Since the TWL site has not been finished yet I took it upon myself to get this done. It ain't pretty but there it is.

    Thanks to Joe_ for assisting me with some of the data entry first week. And Markmrw for helping me learn google sheet related stuff'n things.

    ~Update october 8th, 2020~
    Separated season and playoffs by request

    SEASON:
    https://docs.google.com/spreadsheets...it?usp=sharing

    PLAYOFFS:
    https://docs.google.com/spreadsheets...it?usp=sharing
    Last edited by Nipple Nibbler; 10-08-2020, 03:05 AM.
    If you're going to do a thing you should to it to the best of your ability or don't do it at all.

  • #2
    Nice nice, I am missing a game though
    1:waven> u challenge
    1:waven> if i challenge it looks too scary

    Originally posted by MHz
    Hope you contract ebola from your, no doubt cheap, Easter Egg, you fucking shit-jav, pug-faced cunt.

    Comment


    • #3
      Tiny but you haven't played, you're not even on a TWL roster?
      If you're going to do a thing you should to it to the best of your ability or don't do it at all.

      Comment


      • #4
        Good to see creature back and in good form
        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


        • #5
          Originally posted by Nipple Nibbler View Post
          Tiny but you haven't played, you're not even on a TWL roster?
          Kicker
          1:waven> u challenge
          1:waven> if i challenge it looks too scary

          Originally posted by MHz
          Hope you contract ebola from your, no doubt cheap, Easter Egg, you fucking shit-jav, pug-faced cunt.

          Comment


          • #6
            Ok but why are we still sorting everyone by gp and calling it stats.

            Comment


            • #7
              Rab I did set up sorting filters but for some reason only people with edit access can see them. If you are aware of a workaround for that let me know, I am still new to google sheets. The default at the moment is sorted by kills for wb/jav/spider and deaths for terr. So I can see how that can appear to be sorted by gp.

              There are a few other things I want to put in, team names next to the player names, deaths per 30 mins for terr. Kills per 30 for spider. I want to do up a sheet for the thankless job of shark, I only have access to limited stats for them though. If staff could grant me access to other stats (if possible) I am willing to put in the effort and get more stats available.

              I am also going to fix the div/0 next to midoent.

              I might get ambitious and make "top 10" lists for stuff n things from the data as the season goes on. I am starting out simple to make sure I don't screw anything up .
              Last edited by Nipple Nibbler; 05-05-2020, 04:24 AM. Reason: Don't want to triple post lol
              If you're going to do a thing you should to it to the best of your ability or don't do it at all.

              Comment


              • #8
                Tiny Typo in data had one of your games as klicker haha, ty corrected. I was so focussed on getting the data right and not so much on the names. Let me know if you find any other errors.

                (Besides the casing of players names, you are all getting lower case to make it fair and literally save me hours of work. Some people have weird-ass nAmEseS)
                Last edited by Nipple Nibbler; 05-05-2020, 04:27 AM.
                If you're going to do a thing you should to it to the best of your ability or don't do it at all.

                Comment


                • #9
                  ~BUMP~

                  -Updated to show week 2.
                  -Added team column next to player names.
                  -Added a simple "last update" date to each page, and will change it to "currently updating" so people don't panic if things look weird while im updating.
                  -Added shark page.
                  -came up with an estimated shark rpd. I only have access to the actual rpd stat not rep count. So I went with rpd x deaths to get an estimated rep count for each game. Summed up those estimated reps, then divided by total deaths. Unless someone suggest a better idea I will stick with that.
                  -fixed div/0 problem with certain players
                  -added kills and deaths per game, per min, per 30mins (per 10 for ld/jd instead of 30)
                  Last edited by Nipple Nibbler; 05-11-2020, 10:49 AM.
                  If you're going to do a thing you should to it to the best of your ability or don't do it at all.

                  Comment


                  • #10
                    Thanks Rage

                    Comment


                    • #11
                      Thx for this rage. wish we had some more people writing about the games, with how active the game has been would be nice. Base looking pretty crazy atm

                      Comment


                      • #12
                        -added some basic highscores, shows the top player in a few categories for each ship.

                        zidane if you could do me a favour, let me know if any games are going to be replayed, I'll make sure they don't get added in.
                        If you're going to do a thing you should to it to the best of your ability or don't do it at all.

                        Comment


                        • #13
                          Originally posted by zidane View Post
                          Thx for this rage. wish we had some more people writing about the games, with how active the game has been would be nice. Base looking pretty crazy atm
                          If videos of all of the games are available, I can write HoN tonight. Do you know where I can find the remaining games? All I see are:

                          Spastic vs. gun, rapid vs. spastic..
                          Last edited by Pressure; 05-11-2020, 01:14 PM.

                          Comment


                          • #14
                            https://twl.trenchwars.com/matches

                            games are all on the twl site

                            Comment


                            • #15
                              Originally posted by Pressure View Post

                              If all of the games are available, I can write HoN tonight. Do you know where I can find the remaining games? All I see are:

                              Spastic vs. gun, rapid vs. spastic..
                              https://www.twitch.tv/heafin/videos?...ives&sort=time

                              Comment

                              Working...
                              X