This spreadsheet is my next masterpiece. Not only did I update for TAD, I added a ton of functionality to make it user friendly. If you are familiar with my AOE3 TWC TAD Quick Reference Guide, you will be blown away by the work I put into this. All I ask is that you check out the clan I am a member of.
This spreadsheet was created to mathematically compare the performance characteristics of every unit with optional upgrades and the capability to compare base, veteran, guard, and imperial units easily.
Any upgrade in the game can be simulated including arsenal technologies, auras, big button technologies, fire pit dances, shipments, Wonders, etc. Upgrades to speed, hit points, and damage (range, melee, or siege) can be included and then these unit types can be compared.
If you learn to use this power tool, the time it takes to develop strategies can be significantly decreased. If you combine this spreadsheet with my "Quick Reference Guide", there will be no secrets to this game and your only reason for playing badly is not enough practice. It is easy to use, but I wrote instructions for users not familiar with Excel.
Instructions & Notes
Table of Contents
Unit Classification & Counters
Unit Artillery Comparison
Unit Hand Infantry Comparison
Unit Healer Comparison
Unit Hero Comparison
Unit Heavy Infantry Comparison
Unit Light Infantry Comparison
Unit Light Cavalry Comparison
Unit Melee Cavalry Comparison
Unit Pet Comparison
Unit Ship Comparison
Unit Temporary Units
The spreadsheet statistics have been tested and verified in game. At worst case, I am accurate with the in-game user interface by + 1 damage or HP. Round off error is the reason for this. Damage and HP upgrades are calculated without rounding but the last decimal is truncated from the user interface. The decimals do not show up in the UI, but they are there when the unit is upgraded (in barracks, shipment, technology, etc.). Originally, I rounded all of my calculations to make everything appear like it does in the UI. However, with the inclusion of Wonders and Fire Pit dances, the total value increases and amplifies the round off error.
I gathered all my fire pit percentages from the in game user interface. That means that all my fire pit percentages do not include the decimals that are actually included in game but not seen. This leads to values that are slightly off when comparing fire pit dancing. However, you are still in the ball park for all the values.
This is a free Excel viewer that allows you to view but not edit.
OpenOffice.org is a multiplatform and multilingual office suite and an open-source project. Compatible with all other major office suites, the product is free to download, use, and distribute.
If you find any problems or have any questions, please post them here and I will get it fixed.
Lead, Follow, or Get the Hell out of the way!................CYCLOHEXANE'S FREE GUIDES:
-TAD GUIDE: AOE3 TWC TAD Quick Reference -or view online: On-line
AOE3 TWC TAD UNIT COMPARISON SPREADSHEET: Unit Comparison Spreadsheet
See other guides, technological advancements, interviewing tips, and more at my website All Things Miscellaneous