Mona Lisa wrote:
Anjire, I fear whatever data source you used fo the stats is not even remotely accurate, off by at least 30 to 100% + in some (likely more).
|
The information is compiled from the publicly posted stats on the tournament detail pages. Make sure you are looking at the spreadsheet correctly and have the correct tab opened up.
To Clarify:
Attacking Alliance tab - only stats when an alliance is the attacker are compiled on this sheet. This sheet is sorted by defender casualties because on attack you want to know how many and at what ratio you killed off the defender units. A higher ratio = better (AC/DC)
Defending Alliance tab - Only the stats when an alliance is the defender are compiled on this sheet. This sheet is sorted by Attacker casualties because on defense you want to know how many and at what ratio you killed off the attacking units. A lower ratio = better (AC/DC)
Alliance Combined - This sheet takes the totals from the previous tabs to calculate Combined Attacking and Defending Totals = Total Casualties, Combined Defending and Attacking Casualties = Total Kills. Ratio = TK/TC Higher = better. Also on this sheet is the number of Champions each alliance captured and then the calculated Casualty/Medal cost. This is the sheet you want to compare TOTAL losses, kills on not the prior two sheets.
Individual stats Alphabetical: Again, only attacking stats are available for this sheet same set up as Attacking Alliance tab with every individual that attacked a square listed.
Individual Stats(HDC -> LDC): This is the same information as the prior tab only sorted based on highest defender casualties inflicted to lowest defender casualties.
If you wish to mess around the data yourself - I have the raw data saved in its own file. It is simply a copy and paste of all the detail attack reports from all the regions.