stats sheet
INSTRUCTIONS:
- Click the 'Stats Sheet' button below
- When the Sheet is open, click 'File' in the top left and look for 'Make a copy'
- In the pop up, rename your file to whatever name you want, then select 'Make a copy'
- You should now be able to edit your own Stats Sheet
- If you need guidance, see the specific page instructions below
Hey,
As I was the one who put this all together, it's easy for me to visualise what to do and what's important. But I understand that it could look very complex to people seeing it for the first time.
This page will hopefully help guide you when navigating the Stats Sheet. And if you're struggling to find what you need in the haystack below, if there is a specific piece of information you need help with, it will all be in this guide, so remember to use 'CTRL+F' and search this page for the exact thing you're looking for from the Stats Sheet.
You may only want it to see your K/Ds or which Hardpoint Maps you're doing well on and which Hills need work. Use as much or as little of the Sheet as you want. If you do need any further help though, just DM me on Twitter @Kinetic_Leagues and I'll do my best to help you!
Rob
As I was the one who put this all together, it's easy for me to visualise what to do and what's important. But I understand that it could look very complex to people seeing it for the first time.
This page will hopefully help guide you when navigating the Stats Sheet. And if you're struggling to find what you need in the haystack below, if there is a specific piece of information you need help with, it will all be in this guide, so remember to use 'CTRL+F' and search this page for the exact thing you're looking for from the Stats Sheet.
You may only want it to see your K/Ds or which Hardpoint Maps you're doing well on and which Hills need work. Use as much or as little of the Sheet as you want. If you do need any further help though, just DM me on Twitter @Kinetic_Leagues and I'll do my best to help you!
Rob
GENERAL NOTES:
- If the section is in Red, do not make changes to that area.
- If the section is in Green, you are free to make changes.
- When you make changes to Green sections, the Red sections will automatically update.
- Generally speaking, the top section on any page that refers to the 'Overall' stats are not the be touched. There are pre-set restrictions so Teams don't incorrectly edit anything. You can make changes to these sections, such as rename things or change colors, but a warning will come up first to make sure you are making an intentional change.
- There are 2 pages that you don't need to make any changes to. They are 'Map Ranks' and 'Function Sheet'.
FIRST STEPS:
CHANGING PLAYER NAMES:
BEFORE YOUR FIRST SCRIM/MATCH:
Follow the instructions below for each page when entering stats.
CHANGING PLAYER NAMES:
- Step 1) Press 'CTRL+H'
- Step 2) In the 'Find' box, enter 'Player 1'
- Step 3) In the 'Replace' box, enter the Players Name
- Step 4) Make sure the 'Search' is set to 'All Sheets' and check the box for 'Match entire cell contents'
- Step 5) Click 'Replace all'
- Step 6) Repeat Steps 1-5 for each Player
BEFORE YOUR FIRST SCRIM/MATCH:
- Step 1) Go to the 'Scrim Log' page
- Step 2) Enter the names of the opponents for your first Scrim or Match. I'd recommend that you display it as follows, 'Scrim vs Name / Name / Name / Name' and copy it with 'CTRL+C'
- Step 3) Press 'CTRL+H' to open the Find and Replace box
- Step 4) In the 'Find' box, enter 'Scrim 1'. In the 'Replace' box, press 'CTRL+V' to paste the Scrim Name in
- Step 5) Make sure the 'Search' is set to 'All Sheets' and check the box for 'Match entire cell contents'
- Step 6) Click 'Replace all' then 'Done'
Follow the instructions below for each page when entering stats.
OVERALL K/D:
Overall K/D (Total Kills):
SCRIM 1, 2, 3… 50:
Overall K/D (Total Kills):
- Displays the total Kills and Deaths for each player across all Maps and Modes
- Where is says 'K/D' at the bottom of the box, you will see each players overall K/D across every Scrim and Match played
SCRIM 1, 2, 3… 50:
- Enter the Kills and Deaths from each Map into the relevant cell
- You will be able to see your K/D from each individual Scrim at the bottom of each box
DETAILED K/D:
K/D PER:
In the Green boxes, make sure you enter the exact number of Scrims or Maps you have played so the correct data can be displayed
K/D PER:
- SCRIM - Players K/D for every Scrim
- HARDPOINT - Players K/D for Hardpoint only
- SEARCH AND DESTROY - Players K/D for Search and Destroy only
- CONTROL - Players K/D for Control only
- MAP - Every players K/D for every single Map and Mode
In the Green boxes, make sure you enter the exact number of Scrims or Maps you have played so the correct data can be displayed
HARDPOINT:
TOTAL TIME PER HILL:
AVERAGE TIME PER HILL / PER SCRIM:
SCORES PER MAP:
TOTAL TIME PER HILL:
- Shows the total time for all Hills on all Hardpoint Maps
AVERAGE TIME PER HILL / PER SCRIM:
- Shows the average time FOR and AGAINST that your Team gets for all Hills on all Hardpoint Maps
SCORES PER MAP:
- TOTAL - Shows your total score for each Hardpoint across all Scrims
- AVERAGE SCORE - Shows the average score your Team gets on each Map across all Scrims
- HILL RANKS - Automatically updates and displays your best and worst Hill for each Map
- In the Green boxes, enter the exact number of times played, and Record
'MAP NAME' - HP:
PAGES:
NOTES:
PAGES:
- Invasion - HP
- Karachi - HP
- Skidrow - HP
- Sub Base - HP
- Terminal - HP
NOTES:
- Do not make any changes to the top box. It will display the total Hill time for each Hill on that specific Map
- In the 'Scrim 1, 2, 3... 50' boxes, enter the exact Hill Time for each Hill. Use the 'Scrim Notes' page to help you find the exact scores.
SEARCH AND DESTROY:
OVERALL ROUND SCORE:
SCRIM 1, 2, 3... 50:
OVERALL ROUND SCORE:
- You do not need to make any changes to this box
- TOTAL - Shows the total number of Round Wins and Losses for all Scrims
- TIMES PLAYED - Shows the total number of times a Map has been played
- AVERAGE SCORE - Shows your average score for each Map
- ATTACKING/DEFENDING - Shows how many ATT/DEF Rounds you have played and won
- WIN RATE - Shows your win percentage in attack and defence
- RECORD - Shows your total Map Wins and Losses for all Scrims
SCRIM 1, 2, 3... 50:
- TOTAL - Simply enter the exact score from the Map
- TIMES PLAYED - If the Map was played, just enter the number 1 into the box
- AVERAGE SCORE - Do not touch
- ATTACKING/DEFENDING - Enter how many ATT/DEF Rounds you played and won during a Map
- WIN RATE - Do not touch
- RECORD - Enter the number 1 under Won or Lost depending on the result of the Map
FIRST BLOOD:
FIRST BLOOD STATS:
SCRIM 1, 2, 3... 50:
FIRST BLOOD STATS:
- ROUNDS PLAYED - The total number of SnD Rounds your Team has played
- FIRST BLOODS - The total number of First Bloods your Team has Won and Lost
- FB RATE - Shows how often your Team gets First Blood for each Map
- QUICK TRADE - The total number of 'Quick Trades' your Team has
- TRADE RATE - Shows how often you quickly trade back on each Map
- W/L WITH FIRST BLOOD - Shows the total number of Wins and Losses when your Team got First Blood
- W/L WITHOUT FIRST BLOOD - Shows the total number of Wins and Losses when your Team did not get First Blood
- WIN RATE - Shows how often you win when you kill first or die first on each Map
SCRIM 1, 2, 3... 50:
- ROUNDS PLAYED - Do not touch
- FIRST BLOODS - Enter how many times First Blood went FOR or AGAINST your Team in the Map
- FB RATE - Do not touch
- QUICK TRADE - Enter the number of times your Team got a 'Quick Trade' on the Map. Each Team can define this differently but my interpretation of this is how many times you trade for a teammate after they died. I would also determine it as a quick trade if the trade was made while the Player vs Player tally still appears on screen after a death
- TRADE RATE - Do not touch
- W/L WITH FIRST BLOOD - Enter how many Rounds you Won and Lost when you did have First Blood for that Map
- W/L WITHOUT FIRST BLOOD - Enter how many Rounds you Won and Lost when you did not have First Blood for that Map
- WIN RATE - Do not touch
CONTROL:
OVERALL ROUND SCORE:
SCRIM 1, 2, 3... 50:
OVERALL ROUND SCORE:
- TOTAL - The total number of Rounds FOR and AGAINST on each Map
- TIMES PLAYED - The total number of times each Map has been played
- AVERAGE SCORE - The average Rounds FOR and AGAINST for each Map
- ATTACKING/DEFENDING - The total number of times your Team has been on ATT/DEF and won
- WIN RATE - Shows how often you win when on attack of defence for each Map
- RECORD - The overall Win and Loss for each Map
SCRIM 1, 2, 3... 50:
- TOTAL - Enter the result of the Map
- TIMES PLAYED - If the Map was played, just enter the number 1
- AVERAGE SCORE - Do not touch
- ATTACKING/DEFENDING - Enter how many times you attacked and defended, as well as how many times you won on that side
- WIN RATE - Do not touch
- RECORD - Enter the number 1 under Won or Lost depending on the result of the Map
TICKS & LIVES:
OVERALL ROUND SCORE:
SCRIM 1, 2, 3... 50:
OVERALL ROUND SCORE:
- TICKS - Shows the total number of Ticks your Team has FOR and AGAINST on each Map
- DIFFERENCE - Shows if you have a positive or negative Tick difference for each Map
- LIVES - Shows the total number of Lives your Team has FOR and AGAINST on each Map
- DIFFERENCE - Shows if you have a positive or negative Life difference for each Map
SCRIM 1, 2, 3... 50:
- TICKS - Enter the total number of Ticks FOR and AGAINST for the Map
- DIFFERENCE - Do not touch
- LIVES - Enter the total number of Lives FOR and AGAINST for the Map
- DIFFERENCE - Do not touch
MAP RANKS:
HARDPOINT / SEARCH AND DESTROY / CONTROL:
IDEAL MAP ROTATION:
HARDPOINT / SEARCH AND DESTROY / CONTROL:
- Do not touch, these sections will automatically update
- Ranking is based off which Map has the better average score difference in Hardpoint, and Round difference in SnD and Control
IDEAL MAP ROTATION:
- This will automatically place in your 5 best Maps
- 1st and 2nd from Hardpoint and Search and Destroy
- 1st from Control
SCRIM LOG:
- SCRIM - Only there to show you how many Scrims/Matches you've played, so you don't need to keep counting. If you scroll up to FIRST STEPS > BEFORE YOUR FIRST SCRIM/MATCH, the pre-set numbers will help with that step
- DATE - I trust you to make the right decision on this one!
- OPPONENTS - Display this however you'd like, but I'd suggest that you write the players names exactly as they were in game. It can be labelled as a Scrim, Match, Challengers Cup or Major. Whatever you need it to be for
- NOTES - Again, use this how you'd like, but it's there to help recall any details of the Scrim. Such as what Maps and Modes you did or didn't play, or if certain players may have been cheating etc.
- VOD Link - Use this to place the Twitch, Kick, YouTube etc. stream link to be able to find the VOD later on
FUNCTION SHEET:
- Do not touch
- This page exists only to help draw and relay data to and from other pages
- This page won't be helpful with reading information
SCRIM NOTES:
- Do not touch the 'Score by Hill' section
- This page will be useful when trying to input the exact scores from each Hill
- Next to where it says P1, 2, 3, 4 & 5, simply enter what the score was FOR and AGAINST at the end of that Hill
- The Red section to the right will show you the exact scores for each Hill, which you can then use for the Hardpoint Map pages
- PRO TIP - If you place the VOD and Sheet side by side, you can skip to the end of each Hill and then input the score into the Sheet. Or a very kind Teammate can help you with it