AOE3 TWC TAD Unit Comparison
Posted: Mon Jan 28, 2008 10:16 am
DOWNLOAD HERE: CLICK HERE
DETAILS: CLICK HERE
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. You don’t have to join, post in our forums, challenge us to a friendly clan match, nothing, just check it out and consider joining or playing against us if you’re a mature gamer.
Short Description
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.
Description
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.
Here is what is included:
• 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. Does anyone know how to get the actual percentages used (not the in-game UI) for each of the fire pit dances for villagers 1 to 35? If I had these values, I could refine my calculations.
For those of you who do not have Excel, here are some free viewers:
Excel Viewer 2003
This is a free Excel viewer that allows you to view but not edit.
Open Office
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.
DETAILS: CLICK HERE
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. You don’t have to join, post in our forums, challenge us to a friendly clan match, nothing, just check it out and consider joining or playing against us if you’re a mature gamer.
Short Description
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.
Description
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.
Here is what is included:
• 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. Does anyone know how to get the actual percentages used (not the in-game UI) for each of the fire pit dances for villagers 1 to 35? If I had these values, I could refine my calculations.
For those of you who do not have Excel, here are some free viewers:
Excel Viewer 2003
This is a free Excel viewer that allows you to view but not edit.
Open Office
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.