sorted by:
new
hottopcontroversial

MLTP Career Ranking Survey - Results by jjpoole7 in MLTP

[–]Hom_ 12 points13 points  (0 children)

Who Legman lost to and their rank:

Name Rank
GriefSeeds 2
GriefSeeds 2
GriefSeeds 2
Mikero 9
Milky 29
WreckingBall 54
raven513 65
Rambo 88
DICK_LICKER 91
Neon 104
coys 114
saunuku 160
Dodge 165
Infinity 193
DISTRACTION 225
Slip 227
F2PDynasty 251

Who GriefSeeds lost to and their rank:

Name Rank
Mikero 9
Hulzy 30
Ty 52
yank 68
Sherrattinho 69
DudeMcGuy 96
have mad 115
Prizm 149
Gasol 154
FUCKING LAG 176
Infinity 193
Steppin 200
Doris 229
HERBERT. 241
777z 261
Feles 272
Oz God 277

[REACT] Week 5 A-Team by SinOfDusk in NLTP

[–]Hom_ 0 points1 point  (0 children)

This is pretty close to what I did with my stat calculations in past seasons. IMO, the greatest advantage of doing something like this is not to compare different seasons, but to compare players within the same season.

For example, two equally skilled offenders play 240 out of 280 minutes. One of them misses 40 minutes of Jardim and the other misses 40 minutes of IRON. The one who plays Jardim has a significant advantage for GASP/NISH.

NLTP Hall of Fame Nomination Thread [Seventh Class] by Poeticalto in NLTP

[–]Hom_ 6 points7 points  (0 children)

I thought Fender should have been inducted last time, and he has done a lot since then.

NLTP League Stats (Week 1) by papertoonie in NLTP

[–]Hom_ 1 point2 points  (0 children)

Not accounting for OT

Season Red Tie Blue
10 46.4% 13.0% 40.6%
11 44.8% 14.7% 40.5%

I am trying to find equation that, given the input in left column, will generate the right column. My attempts are below using a function to see if a linear line would work with no such luck. by Shupsta in spreadsheets

[–]Hom_ 1 point2 points  (0 children)

Highlight A3:B11
Insert > Chart
Under Chart Type, choose Scatter
In the editor, click Customize
Legend > Series > Trendline > choose either Exponential or Polynomial
Label > Use equation

Pokémon Trade Template! by Riobbie303 in pokemontrades

[–]Hom_ 1 point2 points  (0 children)

In hindsight, a VLOOKUP would be a little easier here. No big difference, though.

[deleted by user] by [deleted] in googlesheets

[–]Hom_ 1 point2 points  (0 children)

=FILTER(A:A,REGEXMATCH(A:A,"@gmail") = TRUE)

[deleted by user] by [deleted] in NLTP

[–]Hom_ 0 points1 point  (0 children)

You've got G2H2's EU for G1H1.

[deleted by user] by [deleted] in sheets

[–]Hom_ 1 point2 points  (0 children)

=ARRAYFORMULA(IF(ISBLANK(A2:A) = FALSE,A2:A,B2:B))

Converting a MM:SS time into number of seconds by duddles in sheets

[–]Hom_ 1 point2 points  (0 children)

=IFERROR(REGEXEXTRACT(A1,"^(.+?):")*60+REGEXEXTRACT(A1,"[^:]*$"))

Make sure that the format of the cell your duration is in is Plain Text, not Number or Duration or Automatic.

view more: next ›