Sabitlenmiş Tweet
dave
2.7K posts

dave
@daveVLRT
LFT | ex rrq, ghost | [email protected]
Katılım Mayıs 2019
288 Takip Edilen712 Takipçiler
dave retweetledi
dave retweetledi

🚨 BREAKING
✅ Max Verstappen said YES to Mercedes.
‼️The issue is, Mercedes did not ask him anything.
Max Argento 🇦🇷@MaxArgento33
🚨 | Max Verstappen le da el SI a Mercedes. 👉 Desde este fin de semana MV3 ya NO estará en Red Bull, se subirá al Mercedes.
English

Joined @QorGaming. Excited to work with the team 🙏
QorGaming@QorGaming
The big brains are here. 😼 Welcome to the fam, @codyvalo !!! Lets get this party started.
English

@ElevatedSpeaks All of the match info + player stats are pulled via scrimsense, I then just put it into my sheet and my formulas take it from there
English

Over the years my ways of tracking data have elevated higher and higher, I am now at the point to where I do not need to use spreadsheets to hold my stats anymore. With that being said I will be releasing my most recent spreadsheet to the public as well as instructions on how to use the sheet to get the most value out of it.
Another important detail, the main tracker I use is based off the foundation of @ScrimSense so for users who do not have the organizational funds to pay for scrim sense, I have a tracker that can be used off in-game screenshots.
🔗docs.google.com/spreadsheets/d… (Scrim Sense Tracker)
🔗docs.google.com/spreadsheets/d… (Basic Tracker)
If anyone has any questions please drop a comment and don't be afraid to reach out to my dms!
⬇️ More info in replies ⬇️
English

3️⃣ There are multiple key macro's that I use to make flow for this sheet flow smoothly
K - Your team got a kill
D - Opponent got a kill
OR - Opponent rez (Clove And/Or Sage)
TR - Team rez (Clove And/Or Sage)
This system goes interaction by interaction and each box is the round state, and even shows the ending (+/-) Advantage for your team so you can see for an entire scrim.

English

2️⃣ The next feature is my custom XvX tracker that tracks round state as well as ult cycling.
This is the most in depth part of the entire sheet due to the fact that it is unconventional in the way that XvX is usually tracked.
In a standard way of tracking most people will take the interaction and if they win the round that then turns into a +% which results in double dipping in all of the stats. For my XvX tracking, this takes each interaction at face value and tells you the % of times you are winning that fight specifically.
For example if your team has a 75% in 2v3s that means in a 2v3 you are highly favored to win that, even with the odds stacked against you. Due to the nature of how your team preforms you can determine what scenarios you have to consider working on.
Rounds like low% 5vX 4vX in Anti-Ecos would show that you are having problems transitioning guns from your Anti-Eco to the enemy teams FBR.

English

1️⃣ The main page "Overview" should be fairly easy to understand
Info - Match information
Stats - WA/LA/WD/LD (Won/Lost on ATK/DEF) These 4 auto-calculates into the RW/RL (Round Wins/Lost). On top of that AP/DP (ATK/DEF Pistol) as well as URW/URL (Ult Round Wins/Losses) that come from the XvX sheet.
Comp - Auto transposes the agent for each player and shows icons for an ease of access to see what comps you are running easily.
Then for each player it has the basic K/D/A Stats and then the more detailed stats like FK:FD, TFK/TFD, UK/UD, KAST%.
This overview sheet is the driver for the entire sheet.

English
dave retweetledi
dave retweetledi















