|
|
| General | Hosted Sites | CivRev | Colonization | Civilization IV | Civilization III | Civilization II | Civilization | Misc | Marketplace |
 |
|
|
Welcome to Civilization Fanatics' Center. You are currently viewing our site as a guest which gives you limited access to our site features. By joining our free community, you will be able to participate in the discussions, search the forum, send private messages, vote in polls, upload your own screenshots to the gallery, and access many other special features. Registration is fast, simple and absolutely free, so sign up today! If you have any problems with the registration process or your account login, please contact support. |
|
|||||||
 |
|
|
Thread Tools |
Dec 08, 2003, 01:02 PM
|
#1 |
|
P51 Mustang Pilot
Join Date: Jul 2003
Location: Missouri USA
Posts: 793
|
Best Attacker Utility (Excel)
This is something I created to see how varying the unit stats or HP in my mod would effect combat vs other units. It will list all the combinations from a 1hp 1 Attacker (e.g.- A 1hp Warrior) through a 6hp 24 Attacker (e.g.- A hypothetical super-elite modern armor).
It includes a sort function that sorts in probability of winning... It is in a preliminary stage, as it was made for my own use, but it is very effective at determining which unit is superior in a given encounter. The relationship between HP and Attack value may surprise some... For example, notice below that a 6hp Ancient Cavalry (3.2.2) is better than a 3hp Cavalry (6.3.3)...
__________________
  NEW Civ III Combat Calculator for C3C (.EXE) NEW Civ III Best Attacker Utility (.XLS) Anti-Air Combat Formula Revealed Comprehensive Retreat Study Last edited by BomberEscort; Aug 04, 2006 at 07:57 PM. |
|
|
|
Dec 08, 2003, 01:05 PM
|
#2 |
|
P51 Mustang Pilot
Join Date: Jul 2003
Location: Missouri USA
Posts: 793
|
Screenshot...
Screenshot
__________________
NEW Civ III Combat Calculator for C3C (.EXE) NEW Civ III Best Attacker Utility (.XLS) Anti-Air Combat Formula Revealed Comprehensive Retreat Study Last edited by BomberEscort; Aug 04, 2006 at 07:57 PM. |
|
|
|
|
Dec 10, 2003, 03:11 AM
|
#3 |
|
Civ & Hattrick addict
Join Date: Sep 2003
Location: Saarländer in Hannover (GER)
Posts: 1,295
|
Have you already seen the announcement of the C3C Beta Patch...
There are changes in the combat system, so then a 3HP Cavalry might be better than 6HP Ancient Cav. In any case, you get new work...
__________________
Star Trek and Football fan.(Thanks to Mistfit for the avatar) |
|
|
|
|
Dec 11, 2003, 04:29 PM
|
#4 |
|
Vassalising Spain
Join Date: Jun 2002
Location: Oporto, Portugal (duh)
Posts: 2,563
|
 Just a question: HOW CAN I INSERT THAT BUTTONS IN EXCEL?!? 
__________________
Incarnating D. João II in Civ4! Linked In: http://www.linkedin.com/in/campelodemagalhaes Last edited by Padma; Dec 12, 2003 at 08:36 AM. |
|
|
|
|
Dec 12, 2003, 07:38 AM
|
#5 | |
|
P51 Mustang Pilot
Join Date: Jul 2003
Location: Missouri USA
Posts: 793
|
Quote:
"Run a macro from a button or graphic control" It is a several step process, but this is a good place to start... 
__________________
NEW Civ III Combat Calculator for C3C (.EXE) NEW Civ III Best Attacker Utility (.XLS) Anti-Air Combat Formula Revealed Comprehensive Retreat Study Last edited by Padma; Dec 12, 2003 at 08:36 AM. |
|
|
|
|
|
Dec 12, 2003, 07:40 AM
|
#6 | |
|
P51 Mustang Pilot
Join Date: Jul 2003
Location: Missouri USA
Posts: 793
|
Quote:
|
|
|
|
|
|
Feb 16, 2004, 02:23 PM
|
#7 |
|
Death-To-Pedestrians
Join Date: Jan 2004
Location: if only you knew...
Posts: 2,233
|
Bad A$$ I need this for my mods THANK YOU BOMBER ESCORT
|
|
|
|
|
| Bookmarks |
|
| Thread Tools | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Mobile Airplanes don't fight each other ? Attacker always wins ? | Skybuck | Civ3 - Creation & Customization | 5 | Oct 26, 2007 02:59 PM |
| Late-Game Amphibious attacker? | automator | Civ4 - General Discussions | 7 | Aug 23, 2006 05:07 PM |
| Be the attacker! | carn | Civ4 Strategy Articles | 9 | Jul 24, 2006 03:19 AM |
| Melee defense vs ranged attacker | Solav | Civ4 - General Discussions | 1 | Nov 12, 2005 03:38 PM |
| Repeat attacker UU's mostly worthless? | TruePurple | Civ3 - General Discussions | 18 | Jul 30, 2005 03:11 AM |
