Page 1 of 1

Spreadsheet Powertools Update

Posted: Fri Feb 29, 2008 12:22 am
by Cyclohexane
I made some major additions to my Unit Comparison Guide. With the exception of future patches, this will be the last major update since it does everything I can possibly think of. Here is a list of the new updates:

• Added unique church technology toggle switches and their respective unique units.
• Added monastery technologies in the Hero Comparison and all of the new TAD auras from shipments or technologies.
• Added Aztec Ruthlessness toggle switch (for Eagle Knight) and Flamethrower to Light Infantry Comparison.
• Added a worksheet called "Unit Upgrades Available". This worksheet summarizes all of the upgrades available. I was careful not to include the % upgrades of shipments / technologies twice (if already has a toggle switch on respective comparison worksheet). Now you can type in these values into the yellow highlighted cells (speed, damage, or hit point cells), toggle specific shipments & technologies, select an age, and view statistics of a fully upgraded unit. Anything can be easily simulated and then sorted based on the effectiveness calculation and type of damage received!

Sounds like just a few things but the unit upgrade worksheet was time consuming. It lists all of the shipments and technologies available and cross references all of the units available! If you have not checked this out, download it now. I spent just as much time on this spreadsheet as my Quick Reference Guide and the values are extremely accurate. There is no other tool anywhere that is more comprehensive. And the best thing about it is that it is free!

DOWNLOAD HERE: UNIT COMPARISON CLICK HERE

ORIGINAL THREAD DETAILS: N3O CLICK HERE


In addition to the updates above, I also made a few changes to my Quick Reference Guide. In particular:

• Added notes to the "Misc - Random Notes" worksheet regarding aura effects from shipments / technologies.
• Added Colonial Militia (and Great House / Team Teutonic Center) toggle switch to "Buildings -Defensive Structures" and made this worksheet much more interactive.

DOWNLOAD HERE: AOE3 TWC TAD QUICK REFERENCE
VIEW ONLINE: On-Line Version

ORIGINAL THREAD DETAILS: N3O CLICK HERE

Re: Spreadsheet Powertools Update

Posted: Fri Feb 29, 2008 5:32 am
by I__CHAOS__I
sweet, will check it at work tomorrow :D