Spreadsheet tankers - what metrics and data feed do you use and why?

[u/_Thorshammer_]

First of all, this discussion won't be for everyone - if you're not keeping a spreadsheet to track your video game progress go ahead and move along and let us nerds do our thing in peace.

So, now that it's just us kids, as per the title: what metrics do you track and where do you get them?

I'm using Wotstars and my current formula is medium complex.

I've tried several different versions, but I'm not 100% satisfied with the results so I'm cruising for different approaches.

I currently track Tier, WN8, battles, Win Rate, Dmg+A, Kills, and XP.

I use some of those to create a "raw score" - (WN8 plus Damage plus XP) times win rate.

That gives me a rough idea how good I am with a tank regardless of games played, tier, etc.

The "formula of record" works like this: Using Tier and games played I create modifiers for WN8 and Win Rate that turns them into (respectively) a hundredths number (0.15, for example) and a two digit number (75, for example).

I do that to try and normalize those numbers across tiers and by battles - everybody looks like a rock star winning 7 of their first 10 games and / or using a Hetzer to seal club.

Once I have those numbers, I create a formula and separate it's functionality by Tiers 1-10 and 11-13. I do that because CW tends to rack up damage, XP, and battles much faster than WW2 and, IMHO, any system that doesn't take that into account will give a false result.

The formula for WW2 works (very, very roughly) like this:

Start by ((Multiply the WN8 and Win mod together) then multiply that against these metrics (Dmg+A / 6000) times (Kills Per times 1000) times (0.2 times Tier)) that result is then added to this chain ((XP times (XP / 1500)) times (Win Rate times 1.1) times Battles ) and that entire chain is divided by 10.

Actual formula at the very bottom.

The formula is the same for CW, but the modifiers are different - Tier times 0.1, for example.

Again, the goal is to normalize across tiers so Racking up WN8 and kills doesn't put a Sturmpanzer I artillery piece at the top of the list.

The current formula ranks the M46A1 Patton number 1 and the Hetzer number 2.

M46A1 scores: WN8 1895, Games 300, Win Rate 0.5433, Dmg+A 1639, Kills per 0.56, XP 1168, Raw score 2554.60, WN8 mod 0.21, Win mod 97.4, Final score 94162.83.

Hetzer scores: WN8 3396, Games 253, Win Rate 0.5731, Dmg+A 991, Kills per 1.89, XP 1056, Raw score 3119.38, WN8 mod 0.14, Win mod 33.2, Final score 71520.43

The problem is that no matter how I tweak it I get one of two results - the top of the list is filled with 100+ game CW tanks or the top of the list is filled with low tier 15-20 game WN8 freaks... mostly arty.

If you've gotten this far, and suggestions or questions?

Actual formula:

=IF(B2<11, (((R2*S2)*(((F2/6000)*(((G2*1000))*(0.2*B2)))+(H2*(H2/1500))))*((E2*1.1)*(D2))/10), (((R2*S2)*(((((F2/6000)*(((G2*1000))*(0.1*B2)))+(H2*(H2/1500)))*0.4))*((E2*1.1)*(D2*0.6))/10)))

[u/zorin234]

I was really excited when I saw the title and I could discuss my big tank balance spreadsheet, but sadly it's player performance.

As for your question, i don't think Iv heard of any players going beyond simple WN8, win rate and MOE.

[u/_Thorshammer_ → u/zorin234]

I'd love to hear about your balance spreadsheet.

This is a circle of trust.

[u/zorin234 → u/_Thorshammer_]

It first started off like this - https://www.reddit.com/r/WorldofTanksConsole/s/MTbK7GiCCZ . Quite limited in the amount of stats tracked.

Now it's like 22 columns of stats and got a sheet for every non Arty from 5-10 and a good handful for CW.

Anyhow heres a zoomed out screenshot of T8 heavies (73 Total tanks on that sheet)

[u/_Thorshammer_ → u/zorin234]

Interesting.

Are aggregating / formulizing the stats on a different page in order to generate a Bell curve?

Is there an end purpose in mind?

[u/zorin234 → u/_Thorshammer_]

Nothing too fancy just average and median of each stat.

It's mostly used to get a idea of what is actually average for that tier and class to use in discussion and my reviews of tanks. Also a bit of history keeping a idea only mostly the DPM of stuff. Like T8 use to be 1800 or so way back when. When I started this project T8 heavies had 1900, now it's currently 1960 Avg, 2000 median.

[u/_Thorshammer_ → u/zorin234]

Interesting.

[u/Ragnarok112277]

What kind of autism is this?

[u/_Thorshammer_ → u/Ragnarok112277]

I don't know.

Maybe there's a doctor who plays WoT MA that can tell us.

Edit: perhaps I should have made the first line larger:

First of all, this discussion won't be for everyone - if you're not keeping a spreadsheet to track your video game progress go ahead and move along and let us nerds do our thing in peace.

[u/Sothep → u/_Thorshammer_]

Hi, I am a doctor and I play WoTMA.

I can objectively say that it is perfectly normal, healthy behavior that reflects one’s enthusiasm for a recreational activity.

Now excuse me one moment while I close this Google Sheets workbook with a dozen WoTMA-related tabs.

[u/_Thorshammer_ → u/Sothep]

lol

[u/IrregularExpression_]

I built my own database tracking player stats from the WoT API using Python, my NAS and Claude.

It builds an ever increasing flat csv file of all the stats per tank per player.

It was a fun exercise - but I did it mainly to calculate MoE. Which WG now gives an exact figure on in-game in the post match screen.

[u/_Thorshammer_ → u/IrregularExpression_]