TWDT-D Stats -- WEEK 2

[ogron]

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.

[Turban]

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.

[Ricko]

nice one, cheers claus! Hopefully we can keep this updating every week (if needs be someone else does it)

[ogron]

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

[ogron]

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:

[Tanzu]

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

[Attacks]

Thanks for this! Dont forget my week 1 stats 10-6

[ogron]

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.

[ogron]

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!

[Vys]

I'm sure I played 2 games in week 1. But only the first game is recorded

[ogron]

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

[ogron]

Updated

[Omega Red]

good shit claus