Log Update ( 4,459 hours) - CQC Tracker for the Community - see desc)
21 Oct 2018Evolution
It's been just over 2 months since my last update and I've spent a lot of time in CQC
I've now reached Prestige 4 and have increased my win/loss ratio above 1.0, as I'd planned.
To measure CQC performance going back over the last 3 years and after many nights and weekends effort, I've recently created a CQC Stats spreadsheet that I'm glad to share with the community
.-
It's essentially to compare:
- Time / XP / Credits / Matches / Wins / Losses / Kills / Assists and Deaths.
-
By entering 8 bits of info it automatically shows:
- All the averages vs each other, plus your performance at each stage vs the last.
- Graphs for the average + performance of:
XP per Match, Credits per Match,
Wins per Match, Wins per Loss,
Kills per Match, Kills per Death,
Assists per Death and Deaths per Match. - A sheet called Prestige (image below) which shows all the Levels and Prestige, what you've earnt, how much is left, plus how many matches it will take from your actual performance stats. You'll see the large Prestige Icon change to your level, when you've typed in you XP to the main sheet)
Please note, depending on your browser, the spreadsheet may not open on the first click, but if you click again it should open.
Here's my version to show how it works o7
(The yellow cells and sections in the graphs show estimated numbers to fill in the gaps, where some screenshots didn't have all the info. So those yellow parts aren't in the blank version.).
Here's a blank version on Google Drive which you can copy o7
The Stat sheet has 9 main tables. You just need to type the 8 bits of info into the three columns that are white and where I've put comments and typed in ones (D, S & AE)…. and that's it!
Then as you add more, it'll populate the graphs so you can see how it's going and what you'd like to focus on o7.
I've split mine into groups of 40 matches but you can obviously split yours however you'd like.
I hope this is useful. Fly safe.
EDIT - 31st May 2020. The spreadsheets below have been updated to the most recent versions. If you use them with excel, you will get more functionality compared to using Google sheets.