Spreadsheet Powertools Update

Talk about Strategies and share your Replays

Moderators: Global Moderator, Age Moderator

Post Reply
User avatar
Cyclohexane
Honorary Officer
Posts: 384
Joined: Tue Nov 20, 2007 1:44 pm
Location: Houston, Texas
Contact:

Spreadsheet Powertools Update

Post 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
Lead, Follow, or Get the Hell out of the way!

QUICK REFERENCE GUIDE & AOE3 TWC TAD UNIT COMPARISON: AOE3 TWC TAD Quick Reference & AOE3 TWC TAD UNIT COMPARISON

User avatar
I__CHAOS__I
Honorary Member
Honorary Member
Posts: 3007
Joined: Thu Nov 15, 2007 12:55 am
Location: ??

Re: Spreadsheet Powertools Update

Post by I__CHAOS__I »

sweet, will check it at work tomorrow :D
Image
Wisdom is the supreme part of happiness. - Sophocles
Happiness belongs to the self-sufficient. - Aristotle

Post Reply