VCT Tier 1 Franchised Stats Spreadsheet

#1

ariLMFAO

https://docs.google.com/spreadsheets/d/1uQCnxYMZiNr5hnCaZVU3QYmaOKbcHIdJekC0WWt29pw/edit?usp=sharing
Do what you will with this info. You can look back at my posts and see i made one with every player too if you want. There are some players who dont actually play for those teams but if the team has the same tag as a franchised team it will show up. A player (eg. 100T Hiko or SEN Shroud) will show up if their last team was that team on VLR
China is also missing on this fyi

upvote because this took me an hour to program

#2

n1cf

2

Frags

+

–

cned at 14 in rating and ppl call him washed 🥱

#3

z12

-2

Frags

+

–

i could bait my teammates and have a 7.0 rating too not impressive

#5

n1cf

0

Frags

+

–

that would be statpas

#8

z12

0

Frags

+

–

mb i confused them

#4

Hades_Loves_Rb

0

Frags

+

–

where yay? where Rb? where tacolilla?

#6

ariLMFAO

1

Frags

+

–

china isnt on the list

yay isnt currently on a franchised team

tacolilla isnt on a franchised team

#7

ariLMFAO

1

Frags

+

–

china teams will be put in soon

#9

windwine

0

Frags

+

–

aspas?

#10

Laundry

0

Frags

+

–

Agents are messed up, it says Leo plays smokes and Meteor plays duelist

#11

ariLMFAO

1

Frags

+

–

Meteor's number 1 agent is Jett. He used to main Duelist. Leo's #3 most played agent is Omen, not sure why it says Brim tho.

#12

windwine

0

Frags

+

–

bang has phx there

#13

scarlemange

0

Frags

+

–

Johnqt agents are raze jett chamber ?
This list is broken

#14

J0zza

0

Frags

+

–

N4RRATE is there twice

#15

ariLMFAO

0

Frags

+

–

soon to be fixed

#16

EseemedRes1180

0

Frags

+

–

PurpO as well in ratings

#17

ariLMFAO

0

Frags

+

–

Should I release the program i used for this?

#18

Denggysaurus

0

Frags

+

–

Is there a way to also calculate total number of maps played?

#19

ariLMFAO

0

Frags

+

–

Might be able to work something out for that. Is there a specific reason?

#20

Denggysaurus

0

Frags

+

–

I'm interested to see the average number of kills a player gets in a map! It's been something I've been trying to code up too but I don't see a way to do it without this
https://www.vlr.gg/418483/master-list-of-player-ids

or having a maps played added to the stats page of an event

#21

ariLMFAO

1

Frags

+

–

Got it. Ill get back to you

#22

ariLMFAO

0

Frags

+

–

I tried, but i looked at all unofficial VLR API and there isn't an endpoint for maps played or anything similar.

#23

Denggysaurus

0

Frags

+

–

Yeah that's what I thought damn :/

#24

Denggysaurus

0

Frags

+

–

https://docs.google.com/spreadsheets/d/1d-d7zpJ6zT5fNkyNRpji1_1kZ9MhYlHYjpxcq1n1tp0/edit?usp=sharing

you think using this data you could figure it out?