Forum

Note: By default, pauses will not be taken into account. Please message me or post here if there were pauses the occurred during a match. Such matches/maps are be marked by (*). If I have accounted for a pause, it will be marked (**) Also comment any errors you see. Apart from the fact the medals aren’t working for most of the classes in the quotient columns and missing some mercs’/subs’ names. I know – conditional formatting hates me, and proky was bullying me for being slow to release.

Spreadsheet

Results, Logs, and Schedule:

Week 1: pl_upward
TORPEDO vs Super Dickmann’s KANNONEN!: 0-6
[ Round 1 | Round 2 | Combined ]
inVision vs kiti s bakenbardami: 4-2
[ Round 1 | Round 2 | Round 3 | Combined ]
JOEYOTECH Feila vs Tourettes Frenchclub: 6-0
[ Round 1 | Round 2 | Combined ]

Week 2: koth_warmtic_b6 & koth_product_rc9
TORPEDO vs JOEYOTECH Feila: 1-5
[ koth_warmtic_b6 | koth_product_rc9 | Combined ]
inVision vs Tourettes Frenchclub: 5-1
[ koth_warmtic_b6 | koth_product_rc9 | Combined ]
kiti s bakenbardami vs Super Dickmann’s KANNONEN! (**): 6-0
[ koth_warmtic_b6 | koth_product_rc9 | Combined ]

Week 3: cp_steel
TORPEDO vs Tourettes Frenchclub (**): 6-0
[ Round 1 | Round 2 | Combined ]
inVision vs Super Dickmann’s KANNONEN! (**): 4-2
[ Round 1 | Round 2 | Round 3 | Combined ]
JOEYOTECH Feila vs kiti s bakenbardami (**): 6-0
[ Round 1 | Round 2 | Combined ]

Week 4: cp_gullywash_final1 & koth_coalplant_b8
TORPEDO vs kiti s bakenbardami: 6-0
[ cp_gullywash_final1 | koth_coalplant_b8 | Combined ]
inVision vs JOEYOTECH Feila: 0-6
[ cp_gullywash_final1 | koth_coalplant_b8 | Combined ]
Super Dickmann’s KANNONEN! vs Tourettes Frenchclub: 6-0
[ cp_gullywash_final1 | koth_coalplant_b8 | Combined ]

Week 5: pl_badwater
TORPEDO vs inVision: 4-2
[ Round 1 | Round 2 | Round 3 | Combined ]
JOEYOTECH Feila vs Super Dickmann’s KANNONEN!: 0-6
[ Round 1 | Round 2 | Combined ]
kiti s bakenbardami vs Tourettes Frenchclub: 6-0
[ Default Win]

I have used and modified Ceejaey’s/Just1s’s (and proky’s team stats) statistics templates. Comment any suggestions or errors you see.
Changed include, but not limited to:
– Formatting the raw stats page differently [e.g. adding the scouts’ stats header]
– Changing medics’ damage stat heading to healing and putting medics’ damage stat at the bottom to total teams’ damage correcty
– Added spy picks stat to pyro

Original Spreadsheet taken from: http://etf2l.org/forum/general/topic-35098/
To Just1s/Prem Stats person: I have a blank copy of my template if you want/require it.

sss

zeman 1.8k DPM

I request demos

Quoted from Harry

[…]
Cheers. Ze Man was just my putting an extra digit in the raw stats cos it was 4am. Something like this is probably a mistake along those lines. Your DPM is correct.

https://puu.sh/C85sX.png
http://logs.tf/2162950

Not talking about my DPM but the team one. According to your spreadsheet we have 97 726 total damage but in our week 2 game alone we have more than that

Pela minha pátria e pelo nosso grande senhor El-Rey conquistarei esta tabela.

Quoted from mellow

How did you remove the pauses from the logs? I’m working on a tool that makes it easier to combine like 30-40 logs and get the data from them (for visualisations/graphs later on), but I’m not sure how to account for pauses to fix incorrect stats that are based on time.

Leaders would tell me if there was a pause, and if someone was streaming (and shoutout to Clark and anyone else who found the timestamp as well), and just looked at how long the pause lasted. Then just subtracted the time, and put that into the spreadsheet.

Sorry it’s not a script :/

lol adje u nerd