Jump to content


WoT Community Tools


  • This topic is locked This topic is locked
74 replies to this topic

Trilandian #1 Posted 04 September 2012 - 03:00 AM

    Captain

  • Player
  • 5938 battles
  • 2,113
  • [DBDH] DBDH
  • Member since:
    05-13-2012

*
POPULAR

I've decided to create a consolidated thread with all the Excel tools I've made.

Disclaimer: These tools have been made with Microsoft Excel 2007; earlier version of Excel and other software that is not directly compatible with Excel 2007 or 2010 are not supported! Using the tools with unsupported software will likely cause them to malfunction.



You can downlod the tools from the following link: WoT Tools (Google Drive)



Weapon Analysis Tool v1.11
Data Set
: (18.12.2012-14.01.2013)
Last update: 18/01/2013 (0.8.3)

This is a specialized tool that seeks to determine a gun's effective damage output, as mainly influenced by its penetration and the armor values of the enemies it's likely to encounter. It now also includes a simulated projection of the shots and time it takes to kill specific tanks.
Insructions and further details are in an attached readme file.


List of Tanks
Last update: 18/01/2013 (0.8.3)

This is a list of all the tanks with all their nations, tiers, battle tiers, health points, hull armor values and top turret armor values (Fixed-gun TDs and SPGs with a separate gun compartment (i.e JagdTiger and AMX 105AM) have adjusted armor values taken from a third-party site).


Tank Stat Calculator
Last update: 5/9/2012 (0.8.3)

This is a calculator that show the effects of the crew's skill on the tank's parameters.

Just fill in the blue cells, everything else auto-updates.


Crew XP Calculator
Last update: 14/12/2012 (0.8.3)

A calculator that shows the amount of XP and battles required to reach certain and specified training levels, as well as projections for the crew's training level after a specified amound of experience or battles, or after retraining and/or skill/perk drop.


Equipment Inventory
Last update: 3/12/2012 (0.8.3)

A tool to help you organize your equipment, and detail the credit cost of reaching your goal of equipment ownership.

Instructions:
In the "Equipment" tab, write down the name of the tank you wish to have equipped (optional), and to the right, select the desired equipment from the drop-down lists.
Next, in the "Inventory" tab, fill in the amount of equipment you already have (just check your in-game depot).
You should now have a summary of the equipment items you need to buy to reach your goal, and the sum of credits it will cost.
Supports up to 100 tanks by default.


Tank Comparison
Last update: 4/11/2012 (0.8.3)

A side-by-side comparison chart between two tanks.


Skill/Perk Itinerary
Last update: 3/12/2012 (0.8.3)

A little log table to help you plan which skills/perks to assign to your tank crews in the future.
Supports up to 100 tanks by default.



I'll make sure to fix and update these tools as necessary, and post new tools when (and if) they become available.

Feel free to post comments, suggestions and bug reports.

Enjoy. :Smile_honoring:

Edited by Trilandian, 18 January 2013 - 05:09 PM.


Anaxagoras #2 Posted 04 September 2012 - 06:28 AM

    Second Lieutenant

  • Player
  • 29005 battles
  • 1,326
  • Member since:
    05-01-2011
Nice work. Thank you very much. +1 ofc

H3ADSHO7 #3 Posted 04 September 2012 - 07:09 AM

    Warrant Officer

  • Player
  • 1575 battles
  • 901
  • Member since:
    04-29-2011
http://wiki.worldoft...makingChart.png

richmi #4 Posted 04 September 2012 - 12:27 PM

    Corporal

  • Player
  • 27279 battles
  • 168
  • [_CALM] _CALM
  • Member since:
    04-27-2011
First of all thank you for sharing :Smile_honoring:

Looking at the camo values, I'm not sure I understand the percentage values there.
Just by comparing provided stationary values for

VK 1602 Leopard - 26,85%
M103 - 26,79%

I sense that something is not right here, because its realy hard to belive that those two have the same camo values/coefficients or whatever the figures mean.
What are those test input data? How was the testing done?

richmi

Trilandian #5 Posted 04 September 2012 - 03:29 PM

    Captain

  • Player
  • 5938 battles
  • 2,113
  • [DBDH] DBDH
  • Member since:
    05-13-2012

View Postrichmi, on 04 September 2012 - 12:27 PM, said:

First of all thank you for sharing :Smile_honoring:

Looking at the camo values, I'm not sure I understand the percentage values there.
Just by comparing provided stationary values for

VK 1602 Leopard - 26,85%
M103 - 26,79%

I sense that something is not right here, because its realy hard to belive that those two have the same camo values/coefficients or whatever the figures mean.
What are those test input data? How was the testing done?

richmi

Those values came from calculations based trial data taken from tests done by players on the Russian server. It was done in a pretty basic fashion, from what I undertand. Supposedly, a tank was driven toward the test tank, and when the test tank became visible, the distance at which the spotting occured was noted. The calculations I've made based on that data are derived from the camouflage formula, found here: http://wiki.worldoft...#Spotting_Range and here: http://wiki.worldoft...nics#Camouflage.

If it says that a Leopard and an M103 have the same stationary camo values, then they very likely do. You may notice that tier 9 and 10 tanks have exceptionally high camo coefficients; this is likely to give high tier tanks an added advantage, and to offset the fact that most tanks at that tier range have an exceedingly high view range.

Oh, and you're welcome. :Smile_blinky:

richmi #6 Posted 04 September 2012 - 07:49 PM

    Corporal

  • Player
  • 27279 battles
  • 168
  • [_CALM] _CALM
  • Member since:
    04-27-2011

View PostTrilandian, on 04 September 2012 - 03:29 PM, said:

Those values came from calculations based trial data taken from tests done by players on the Russian server. It was done in a pretty basic fashion, from what I undertand. Supposedly, a tank was driven toward the test tank, and when the test tank became visible, the distance at which the spotting occured was noted. The calculations I've made based on that data are derived from the camouflage formula, found here: http://wiki.worldoft...#Spotting_Range and here: http://wiki.worldoft...nics#Camouflage.

If it says that a Leopard and an M103 have the same stationary camo values, then they very likely do. You may notice that tier 9 and 10 tanks have exceptionally high camo coefficients; this is likely to give high tier tanks an added advantage, and to offset the fact that most tanks at that tier range have an exceedingly high view range.

Oh, and you're welcome. :Smile_blinky:

Well I understand that it means the same camo coefficient, it's just weird that 60-or-whatever-ton heavy has the same detection chance as small scout. Bigger tanks got bigger view range just because they are bigger, there is nothing bad about it, that it needs compensating is such crazy camo values. In wotdb.info some older camo values for some tanks can be found, and those I've checked differ a lot from the numbers you provided. I'm not saying your numbers are wrong, I just find it very strange. Well, maybe ill try to ask Overlord.

lavaboy #7 Posted 04 September 2012 - 08:10 PM

    Captain

  • Player
  • 15313 battles
  • 2,347
  • Member since:
    05-05-2011
MAKE STICKY PLS
gj Trilandian +1

comic sans FTW

Trilandian #8 Posted 04 September 2012 - 08:14 PM

    Captain

  • Player
  • 5938 battles
  • 2,113
  • [DBDH] DBDH
  • Member since:
    05-13-2012

View Postrichmi, on 04 September 2012 - 07:49 PM, said:

Well I understand that it means the same camo coefficient, it's just weird that 60-or-whatever-ton heavy has the same detection chance as small scout. Bigger tanks got bigger view range just because they are bigger, there is nothing bad about it, that it needs compensating is such crazy camo values. In wotdb.info some older camo values for some tanks can be found, and those I've checked differ a lot from the numbers you provided. I'm not saying your numbers are wrong, I just find it very strange. Well, maybe ill try to ask Overlord.

Well, that data is from before the introduction of the American TD lines, so it's way old.

As for the data I based my calculations on, while I can't guarantee its accuracy in any way, I believe it's the most reliable data currently available.

richmi #9 Posted 05 September 2012 - 07:15 AM

    Corporal

  • Player
  • 27279 battles
  • 168
  • [_CALM] _CALM
  • Member since:
    04-27-2011

View PostTrilandian, on 04 September 2012 - 08:14 PM, said:

Well, that data is from before the introduction of the American TD lines, so it's way old.

As for the data I based my calculations on, while I can't guarantee its accuracy in any way, I believe it's the most reliable data currently available.

Just found out my possible "problem" with the chart, my office 2003 is equipped with unique feature of completely shuffling up the numbers after column sorting/filtering. :facepalmic:

Trilandian #10 Posted 05 September 2012 - 08:55 AM

    Captain

  • Player
  • 5938 battles
  • 2,113
  • [DBDH] DBDH
  • Member since:
    05-13-2012

View Postrichmi, on 05 September 2012 - 07:15 AM, said:

Just found out my possible "problem" with the chart, my office 2003 is equipped with unique feature of completely shuffling up the numbers after column sorting/filtering. :facepalmic:

Hehe, well then, glad you've got things sorted out.

Cheers.

I've added a disclaimer, so there won't be confusions of this sort in the future.

Edited by Trilandian, 05 September 2012 - 06:26 PM.


Trilandian #11 Posted 14 September 2012 - 02:52 PM

    Captain

  • Player
  • 5938 battles
  • 2,113
  • [DBDH] DBDH
  • Member since:
    05-13-2012
Updated "List of tanks".

Added battle tiers and armor values for the hulls and top turrets. Fixed-gun TDs and SPGs with a separate gun compartment (i.e JagdTiger and AMX 105AM) have adjusted armor values taken from a third-party site.

Updated description of "Camo values".

Added relevance disclaimer.

Trilandian #12 Posted 14 September 2012 - 06:12 PM

    Captain

  • Player
  • 5938 battles
  • 2,113
  • [DBDH] DBDH
  • Member since:
    05-13-2012
Added "EDPM v1.0"

Tobsee #13 Posted 14 September 2012 - 06:46 PM

    Private

  • Beta Tester
  • 8771 battles
  • 14
  • Member since:
    10-18-2010
Hm EDPM just says #NAME?

Trilandian #14 Posted 14 September 2012 - 06:54 PM

    Captain

  • Player
  • 5938 battles
  • 2,113
  • [DBDH] DBDH
  • Member since:
    05-13-2012

View PostTobsee, on 14 September 2012 - 06:46 PM, said:

Hm EDPM just says #NAME?

Are you using it with Excel 2007 or 2010?

Tobsee #15 Posted 14 September 2012 - 07:06 PM

    Private

  • Beta Tester
  • 8771 battles
  • 14
  • Member since:
    10-18-2010
well actually open office 3.3

Edited by Tobsee, 14 September 2012 - 07:06 PM.


Trilandian #16 Posted 14 September 2012 - 08:02 PM

    Captain

  • Player
  • 5938 battles
  • 2,113
  • [DBDH] DBDH
  • Member since:
    05-13-2012

View PostTobsee, on 14 September 2012 - 07:06 PM, said:

well actually open office 3.3

View PostTrilandian, on 04 September 2012 - 03:00 AM, said:

Disclaimer: These tools have been made with Microsoft Excel 2007; earlier version of Excel and other software that is not directly compatible with Excel 2007 or 2010 are not supported! Using the tools with unsupported software will likely cause them to malfunction.


Tobsee #17 Posted 14 September 2012 - 08:20 PM

    Private

  • Beta Tester
  • 8771 battles
  • 14
  • Member since:
    10-18-2010
ok yeah didn't see that :Smile_smile:

manti111 #18 Posted 14 September 2012 - 08:30 PM

    Staff Sergeant

  • Beta Tester
  • 25769 battles
  • 393
  • [CIRC2] CIRC2
  • Member since:
    12-22-2010
Maybe convert this to a .ods so poeple with open source pakkets like LibreOffice can open it. Or even better, Google Docs.

Even tempted to open them on my dads pc which has M$ Office 2007, save them .xls and then use LibreOffice calc to make it in a open .ods format.

Edited by manti111, 14 September 2012 - 08:34 PM.


Trilandian #19 Posted 14 September 2012 - 08:52 PM

    Captain

  • Player
  • 5938 battles
  • 2,113
  • [DBDH] DBDH
  • Member since:
    05-13-2012

View Postmanti111, on 14 September 2012 - 08:30 PM, said:

Maybe convert this to a .ods so poeple with open source pakkets like LibreOffice can open it. Or even better, Google Docs.

Even tempted to open them on my dads pc which has M$ Office 2007, save them .xls and then use LibreOffice calc to make it in a open .ods format.

Sorry, but my upload quota is pretty booked as is. Besides, I don't use open office, so I can't guarantee that all the features will carry over.

manti111 #20 Posted 14 September 2012 - 08:59 PM

    Staff Sergeant

  • Beta Tester
  • 25769 battles
  • 393
  • [CIRC2] CIRC2
  • Member since:
    12-22-2010

View PostTrilandian, on 14 September 2012 - 08:52 PM, said:

Sorry, but my upload quota is pretty booked as is. Besides, I don't use open office, so I can't guarantee that all the features will carry over.

I did the research for you. The SUMIFS function is not (yet) supported in LibreOffice 3.5. There are work arounds, but that will take some time.

Google docs same story.

Edited by manti111, 14 September 2012 - 09:02 PM.





1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users