New in version 4.2:Added the Lure of the Hive 2014 hunt equipment (complete data)

After further enhancing my previously published KaW Equipment Calculator, that was basically a tool for playing around with equipment, I decided to give it a new name as it really wasn't just about equipment anymore.

What it does...

This spreadsheet based tool has in fact grown into a whole series of tools, mainly consisting of a BFE calculator, an equipment comparison tool, and a BFA/BFE calculator for any possible build.

Strength (BFA/BFE) calculator: The very first tab of the tool will present you with all possible information about your BFE, BFA and whatever other stats concerning your build, once you have entered the necessary info into tab 1 (your own stats), tab 2 (your equipment), tab 3 (miscellaneous stats like allies, pro-packs, and so on) and tab 4 (mithril spells and pots).This tool now takes your troop level into consideration. For this to work correctly, you'll have to enter some information about your build (towers and castle) at the bottom of tab 3 first, as well as to choose a troop level on tab 1.On the 4th tab, you now can select which mithril spells you have casted as well as what pots you will be using to be included in your strength calculation.

You always wanted to know what your stats looked like at 0% troops? Well, nothing easier now with this tool at hand!

Equipment build (BFE) calculator: The second tab of this tool lets you easily calculate the Bonus from Equipment (BFE) any kind of equipment build will have. Just select the desired equipment as well as its enchanted level and see the stats change!Enter your actual or desired equipment on that tab in order to get it reflected on the strength calculator on the front page.

Equipment comparison tool: The fifth tab contains a tool to easily compare your choice of two equipment among all available ones at all enchanted levels. Find out easily if your existing Armor of the Bronze Dragon lvl 5 beats your new drop!This tool now uses information about your troop level. For this to work correctly, you'll have to enter some information about your build (towers and castle) at the bottom of tab 3.YAY! Finally find out if that Abyssal Sword really rocks or if you should stick to your Soulreaper lvl10...

The third tab asks you to provide additional information that will be considered for calculation your final BFE/BFA/Strength on the main page.This info will be related to your allies, pro-packs, reset bonuses, personal and clan achievement bonuses as well as build info for static stats calculation.

On a sixth tab (ShortData), you´ll find a short list of all available equipment, as well as its origin and its Maximum enchanting level. I quite like to use it as quick reference when getting asked what drops where...

The core data can be found on the seventh tab (Data), listing all available stats data of all in-game equipment. This can be used as a reference about all questions concerning equipment and its stats.

Getting started

First: Enter your BTA stats and a troop level (0-100%) on the first pageSecond: Select your equipment and lvl on the second pageThird: Provide all necessary info on the third pageFourth: Provide info about mith and pot usage on the fourth page

Done!

The front page will now show all possible info about your strength/BFE/BFA at the given troop level.

What it doesn´t do...

This isn´t a magical tool that will tell you what gear you should equip for what occasion...It won´t increase your drop chance for equipment, inferno or aqua in epic battles either...It won't help you avoid the wandering villager either, even if your BFE is over 9000...

A few limitations that I bumped into so far are:

no check is done on equipping duplicate rings

when switching gear, the enchant lvl won´t be reset to a default of zero

without knowing your exact build it is not possible to compute correct BFE values for non-full troops Scenarios with % gear equipped (Yay, I finally made it! Forget this point...)

I do hope it works for you. If not, drop a comment and I´ll try to figure out what´s wrong...

I do know that there are incompatibility issues when using those spreadsheets outside of Excel (buttons not working, scroll down lists not showing up,...) and I am working on an open office version (calc) in the hope that it could solve a few of those.

What I would like it to do...

In future releases, I am thinking of enhancing the tool with the following goodies:

Do not hesitate to express your suggestions, ask your questions and point out the remaining errors...

Thanks to Watchmee for pointing out one particularity: For players not on any iDevice, there are only 6 propacks available instead of 7... The Guardian pack (5% defense) is only available for purchase at the oracle on iDevices. Watch out when filling out your propack bonuses on the calculator.

Thanks a bunch to Versa and Shadow for providing me with the majority of the Estoc Trials Season 2 equipment stats!

Thanks a lot to Seto for providing me with all of the Estoc Trials Season 3 equipment stats!

Last edited by DN_Kassio on Aug 1 2014, 1:01am, edited 18 times in total.

New in version 4.2:Added the Lure of the Hive 2014 hunt equipment (complete data)

New in version 4.1:Added the Dragon melee hunt 2014 equipment (complete data)

New in version 4.0:Added the Quetzal feather hunt 2014 equipment (complete data)Added T6 lvl4 and 5 def and spydef towers statsAdded some data for Smoke Signals and The Summoner equipment (still incomplete)

New in version 3.8:Added the new S3 gear (complete data)Added some data for Smoke Signals and The Summoner equipment (still incomplete)

New in version 3.7a:Bug fixes (new banner system was erroneous)

New in version 3.7:Added the new banner system (moved the banners under the BFE tab).Added Smoke Signals equipment (level 0 and 1 only)

New in version 3.6a:Added seasonal moth event equipment (missing a few values though)

New in version 3.5:Added Estoc Trials Season 2 equipment

New in version 3.4:Added Halloween 2013 equipment (Fiendbow)

New in version 3.3:Added T6 lvl3 defense and spy defense towers for the static stats calculation Added equipment for The Sleeping Giant

New in version 3.2: Added T6 lvl2 defense and spy defense towers for the static stats calculation (as well as projected values for T6 lvl3)Added equipment for Wasteland Wilds and Glacial SquallCorrected some wrong calculation that might occur with normal def towers

New in version 3.1: Added T6 lvl1 defense and spy defense towers for the static stats calculation

New in version 3.0: Added a tab to include mithril spells as well as pots into the BFA calculation.

New in version 2.0: You now may do all calculations depending on your troop level: Calculate your BFA/BFE/strength for a certain troop level or compare Equipments with the equipment comparison tool at a given troop level.

Last edited by DN_Kassio on Aug 1 2014, 1:02am, edited 10 times in total.