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)
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.
First: Enter your BTA stats and a troop level (0-100%) on the first page
Second: Select your equipment and lvl on the second page
Third: Provide all necessary info on the third page
Fourth: Provide info about mith and pot usage on the fourth page
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...)
Where do I get it?
Actual version: v3.7a (31 January 2014)
Well... just grab it from the link(s) down here:
Download from Google Docs: (Excel 2010 .xlsx version)
Download Kaw Build Calculator (.xlsx)
Download from Google Docs: (Excel 97-2003 .xls version)
Download Kaw Build Calculator (.xls)
Preview on Google Docs: (still trying to work on a decent viewable version though...)
(Pre)View Kaw Build Calculator
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:
- Update the stats for missing moth and Smoke Signals equipment
- Inclusion of a basic build calculator
- Addition of a global select/deselect button for pots
- review of the layout and colors (pure cosmetics)
- BiS (Best in Slot) gear lists for different situations
- gear finder (what drops where?). Low priority though
Any other ideas what I might include?
Feel free to contact me...
This tool has largely been inspired by the amazing tool that is Stoneford´s KaW build calculator
Most data stems from the excellent compilation in Resilience´s ★Guide to Equipment★. Without that one, I guess I still would be screenshotting players´gears by this date...
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!