5

VCT '25 foldy sheet

Comments:
Threaded Linear
#1
mangotan

hi all!

i originally come from watching LoL esports and one thing I loved that they do is this thing called the "foldy sheet", where the stats people behind LEC/LCS create a spreadsheet dictating the effects of matches on playoff contention.

i saw there was a lot of confusion on the implications of future games, so i figured i'd share it here!

ps: please someone send it to sliggy's chat he was so confused earlier

https://docs.google.com/spreadsheets/d/1Hfk0U-67j0tEh5O6zN3wPJXsdYJ8zfcj-QkXUWFXOcY/edit?gid=644536619#gid=644536619

feedback is welcome!

#2
aiber
0
Frags
+

how do i read this

#3
mangotan
0
Frags
+

the matches are all lined up and then each team's final placement in the group (1st - 6th) is on the right side. Beside the team's code is their final record

#4
serot
1
Frags
+

would be easier if you just summarized each remaining match's effects atp
ts is not reader friendly at all

#5
mangotan
1
Frags
+

fair enough! i can do that too :D

appreciate the feedback - yeah i was just using it to track for myself but i get needing to make it more userfriendly to read

#6
Shiv9
0
Frags
+

is this saying if 2g wins 100t wins and loud or eg wins then 100t get first seed

#7
mangotan
0
Frags
+

so on the sheet, the only two scenarios where 100T get 1st seed are dependent on:

A) 2G beating SEN
B) 100T beating KRU

in this case, 100T would be the only team on 4-1 (both KRU and SEN would be 3-2, so they would be 1st seed without any tiebreakers or weird H2H rules)

so yes you are right! EG/LOUD game doesnt matter so long as the other two matches go towards 2G and 100T

#8
Shiv9
0
Frags
+

pretty sure if its a 3 way tie and all team are even in head to head then it goes to map diff so even if 100t i think 2-0 or 2-1 they will have a better map diff than sen and kru so 100t get first place

#9
mangotan
0
Frags
+

yes you are partially correct - there's no chance there will be a 3 way tie because 100T and KRU play against one another so one of the teams will have a 4-1 record the other will have a 3-2 record

but yes, if we assumed KRU beat EG, there were a couple more scenarios where 100T could finish as the top seed based on map diff

#10
femboyenjoyer
0
Frags
+

good work bro

#13
mangotan
0
Frags
+

ty femboyenjoyer

any feedback?

#11
ggd12345
1
Frags
+

this is really nice! would be cool to have the results colored (to easily see where your team is)

#12
mangotan
1
Frags
+

good suggestion! i will change it shortly jujst gotta wrap up studying for this exam lol

#14
whoaskedbruh
0
Frags
+

WHERE is the better region. aka EMEA.

#15
mangotan
0
Frags
+

i was planning on opening it before wednesday, but i can open them after the games today if thats ok?

#16
whoaskedbruh
1
Frags
+

nothing is urgent no worry bro, do ur thing whenever u want.

#19
mangotan
0
Frags
+

lucky for u emea is pretty set with APK GX and KOI all being 0-3 most of the results are pretty straightforward.

but... i did say that for KRU > EG this week and look how that turned out LMFAO

#20
whoaskedbruh
0
Frags
+

I don't think so the KC group is quite open, worst with M8 vs BBL (if M8 wins it) ... it's gonna be a shit show

#17
gluesniffer
0
Frags
+

Damn the dedication is insane - ofc this comes from an 100t fan ;)

Did you use sheets functions or is this manual?

#18
mangotan
0
Frags
+

used an algorithm which did most of the hard work but to format it i had to do it manually ofc

#21
gluesniffer
0
Frags
+

Bump

  • Preview
  • Edit
› check that that your post follows the forum rules and guidelines or get formatting help
Sign up or log in to post a comment