Thread Tools
Old January 17, 2003, 14:02   #1
Jaguar
C4DG Sarantium
Emperor
 
Jaguar's Avatar
 
Local Time: 10:37
Local Date: November 1, 2010
Join Date: Apr 2000
Location: New Haven, CT
Posts: 4,790
The underrated power of the Immortal/Catapult/Spearman stack: a statistical analysis
The Mounted Warrior has long been favored over the Immortal by the warmongers of the civ community as the best ancient age attack unit because its retreat ability and its fast movement. Its retreat ability supposedly makes more of them survive. Immortals can survive just as easily.


Here is a calculations for a stack of 2 Immortals, a Spearman, and 2 Catapults vs 2 Spearmen:

Now suppose that all units in this game are regulars for now. The probability that the Immortal stack will take the town without casualties can be calculated as follows:

Strength of a spearman fortified in a town on plains: 2.7
Bombard strength of a catapult: 4


Chance that the catapult will hit (if the game chooses to go for units instead of improvements or citizens: 4/6.7 or 59.7%. That chance is halved to 29.8% because of the chance that the catapult rolls against improvements or citizens.

So, the odds that both catapults hit a spearman are .298 x .298, or 8.9%. The odds that both miss are .702 x .702, or 49.2%. The odds that one misses, the other hits, therefore are 100 - 58.1%, or 41.9%.

So, lets start with the one misses, the other hits scenario. Now we have two reg immortals vs. two spearman, one a regular and one with only 2hp. The odds that the first immortal will win are 67.7%. The odds that the second will win are higher, because the spearman wounded by the catapult is now defending. The odds are 81.2% that the second battle will be won. .812 x .677 equals the probability that the town will be taken with no casualties: 55.0%

If both catapults hit, there will be two 2hp spearmen: therefore the odds of both immortals winning are .812 * .812, or 65.9%.

If neither catapult hits, there will be two 3hp spearmen: odds of both immortals winning are .677 x .677, or 45.8%.

Now we get the total odds of taking the town with out any casualties...

(.550 x .419)+(.659x.089)+(.458x.492)

This comes out to .230+.059+.223, or 51.2%.

51.2% chance of having no casualties. And a spearman and two catapults to defend the town. And those are Immortal regulars that I was calculating the odds for.


Just for the record, if these immortals were vets and the spearmen were regulars, (common when attacking the AI,) these would be the odds:

(.910x.816x.419)+(.910x.910x.089)+(.816x.816x.492)
That's .311+.074+.328, or 71.3%.

A 71.3% chance of coming off with no casualties. I'd say that's a high survival rate.
__________________
"You're the biggest user of hindsight that I've ever known. Your favorite team, in any sport, is the one that just won. If you were a woman, you'd likely be a slut." - Slowwhand, to Imran

Eschewing silly games since December 4, 2005
Jaguar is offline  
Old January 17, 2003, 14:19   #2
Jaguar
C4DG Sarantium
Emperor
 
Jaguar's Avatar
 
Local Time: 10:37
Local Date: November 1, 2010
Join Date: Apr 2000
Location: New Haven, CT
Posts: 4,790
Oh I forgot to show the significance of a spearman. Well you know how the AI likes archers in their cities for counterattacks? If there's a reg archer attacking the stack's spearman, the odds that it will win are extremely low. A catapult has bombard of 4, archer has attack of 2. The odds are therefore 66.7% that the catapult will hit it before it attacks the spearman. A nonfortified spearman on forest, for example (those catapults are wheeled, so you can't use mountain ranges.) has a defense of 2.5, so an archer has a 60.3% chance of being killed if the catapult misses. If it hits, he has a 76.6% chance of losing. Therefore, the spearman will have a (.766x.667)+(.603x.333) chance of winning. That's .511+.201, or a 71.2% chance that the spearman will win. That dispells the other complaint about immortals, the complaint that they are easy to kill. They aren't with a spearman defender.

It also shows that catapults are useful; the spearman's chance with catapult help is 10% higher than without. Not to mention the affect it has on the attack. (5% more chance of 0 casualties)
__________________
"You're the biggest user of hindsight that I've ever known. Your favorite team, in any sport, is the one that just won. If you were a woman, you'd likely be a slut." - Slowwhand, to Imran

Eschewing silly games since December 4, 2005
Jaguar is offline  
Old January 17, 2003, 14:29   #3
Dominae
BtS Tri-LeaguePtWDG Gathering StormC4DG Gathering StormApolytoners Hall of Fame
Emperor
 
Dominae's Avatar
 
Local Time: 10:37
Local Date: November 1, 2010
Join Date: Jan 2002
Posts: 7,017
You've demonstrated that Immortals are effective against Regular Spearmen defenders. You forgot to calculate the odds and survival rate of MWs doing the same thing at similar cost, and comparing the two UUs based on this information.


Dominae
Dominae is offline  
Old January 17, 2003, 14:47   #4
Jaguar
C4DG Sarantium
Emperor
 
Jaguar's Avatar
 
Local Time: 10:37
Local Date: November 1, 2010
Join Date: Apr 2000
Location: New Haven, CT
Posts: 4,790
I know but I realized I wasn't quite sure how the retreat bonus works. If someone could enlighten me I would do a similar calculation for MWs.

One thing that bothers me a bit: the MW's speed is always hailed as a great advantage... but they're absolutely abysmal at defending cities. If you want to hold a city, you often need to send a spearman with them, which slows them down.
__________________
"You're the biggest user of hindsight that I've ever known. Your favorite team, in any sport, is the one that just won. If you were a woman, you'd likely be a slut." - Slowwhand, to Imran

Eschewing silly games since December 4, 2005
Jaguar is offline  
Old January 17, 2003, 14:51   #5
Dominae
BtS Tri-LeaguePtWDG Gathering StormC4DG Gathering StormApolytoners Hall of Fame
Emperor
 
Dominae's Avatar
 
Local Time: 10:37
Local Date: November 1, 2010
Join Date: Jan 2002
Posts: 7,017
I thought retreat is a 50% chance when down to the last HP.

The key to defending with fast-movers is to bring the battles out of cities and into the open, where the extra mobility rules. The only problem is rugged terrain (Mountains, Hills, etc.).


Dominae
Dominae is offline  
Old January 17, 2003, 15:13   #6
Jaguar
C4DG Sarantium
Emperor
 
Jaguar's Avatar
 
Local Time: 10:37
Local Date: November 1, 2010
Join Date: Apr 2000
Location: New Haven, CT
Posts: 4,790
I'm pretty sure that there are some rules about elites retreating more often than vets, too.
__________________
"You're the biggest user of hindsight that I've ever known. Your favorite team, in any sport, is the one that just won. If you were a woman, you'd likely be a slut." - Slowwhand, to Imran

Eschewing silly games since December 4, 2005
Jaguar is offline  
Old January 17, 2003, 15:15   #7
Arrian
PtWDG Gathering StormInterSite Democracy Game: Apolyton TeamApolyton UniversityC4DG Gathering StormPtWDG2 Cake or Death?
Deity
 
Arrian's Avatar
 
Local Time: 10:37
Local Date: November 1, 2010
Join Date: Jul 2001
Location: Kneel before Grog!
Posts: 17,978
Dominae,

Retreat chance is modified by experience level (reg/vet/elite). I think it's about 50% for vets, a bit more for eiltes, a bit less for regulars.

But the real key problem with Immortals is their speed; or rather their lack of it. MWs can take a city w/o spending any time sitting in enemy territory waiting to be attacked. That is their advantage (at least on open ground). It gets even better with the Rider... which I think is the most powerful unit in the game (MW running a CLOSE #2).

-Arrian
__________________
grog want tank...Grog Want Tank... GROG WANT TANK!

The trick isn't to break some eggs to make an omelette, it's convincing the eggs to break themselves in order to aspire to omelettehood.
Arrian is offline  
Old January 17, 2003, 15:20   #8
Jaguar
C4DG Sarantium
Emperor
 
Jaguar's Avatar
 
Local Time: 10:37
Local Date: November 1, 2010
Join Date: Apr 2000
Location: New Haven, CT
Posts: 4,790
Arrian:
Quote:
Originally posted by Jaguar Warrior One thing that bothers me a bit: the MW's speed is always hailed as a great advantage... but they're absolutely abysmal at defending cities. If you want to hold a city, you often need to send a spearman with them, which slows them down.
How are you going to hold the city with a few mounted warriors who have been injured in the attack?


(BTW I know it works when you have 15 of them, because they can just move on and kill anything that heads for the city. However, I would argue that if you had 15 Immortals you owuld be equally invincible.)
__________________
"You're the biggest user of hindsight that I've ever known. Your favorite team, in any sport, is the one that just won. If you were a woman, you'd likely be a slut." - Slowwhand, to Imran

Eschewing silly games since December 4, 2005
Jaguar is offline  
Old January 17, 2003, 15:30   #9
Brizey
Civilization III PBEM
Prince
 
Brizey's Avatar
 
Local Time: 09:37
Local Date: November 1, 2010
Join Date: Apr 2002
Location: The Republic of Texas
Posts: 305
Combat Calculator
JW:

I have attached my combat calculator (requires Excel). It includes all bonuses and retreats. Note that it is only for non-army, non-naval, non-bombardment combat. I have some pretty tricky Excel poop in there, so be careful making changes.

Open up the standard BIC with the editor to see the chances of retreat.

If you wish, look at all the worksheets in the workbook. Several of them show a tree of every possible result during the combat.

Arrian:

I agree about the Rider. The Chinese are one of my favorite civs.
Attached Files:
__________________
Got my new computer!!!!
Brizey is offline  
Old January 17, 2003, 15:31   #10
Dominae
BtS Tri-LeaguePtWDG Gathering StormC4DG Gathering StormApolytoners Hall of Fame
Emperor
 
Dominae's Avatar
 
Local Time: 10:37
Local Date: November 1, 2010
Join Date: Jan 2002
Posts: 7,017
If an invincible stack of 15 MWs confronts an invincible stack of 15 Immortals, what happens?!



Arrian, thanks for the info about retreating; I never knew that it varied with experience.

Dominae
Dominae is offline  
Old January 17, 2003, 15:32   #11
Brizey
Civilization III PBEM
Prince
 
Brizey's Avatar
 
Local Time: 09:37
Local Date: November 1, 2010
Join Date: Apr 2002
Location: The Republic of Texas
Posts: 305
Another thing about my calculator:

If you play a modded version, just change the numbers in all the table worksheets, the macro and control page reads the data from them. You can even delete lines or add lines to the tables (handling this is one of my tricky Excel poop tricks).
__________________
Got my new computer!!!!
Brizey is offline  
Old January 17, 2003, 15:44   #12
joncnunn
Civilization III Democracy GameC3C IDG: Apolyton TeamCivilization III PBEMApolyton UniversityC3CDG Team BabylonApolyton Storywriters' GuildCiv4 SP Democracy GameC4DG SarantiumC4BtSDG Templars
Emperor
 
joncnunn's Avatar
 
Local Time: 09:37
Local Date: November 1, 2010
Join Date: Sep 2002
Location: Maryland Heights, MO
Posts: 6,188
By having previously left a city purposely undefended (important: NOT near the path your MWs are going to take) to sucker the AI into sending all it's offensive units after it.

Don't keep the MW in the town you captured for long, just long enough to heal and send them to the next target.

The AI force that was attracted to one of your undefended cities now turns around and starts marching back towards the undefended city you just took.

Ignore that force for now, and take another city, because you can almost certaintely do so before that AI force gets back.

By now, the enemy forces may be close to reaching the cities you just took so sue for peace for the best possible deal and use the time to bring up defenders to the newly acquired acquistions and build culture improvemnts to them while the core area builds settlers to replace the auto-razed cities and fill in unoccuplied territory followed by building more MWs for the next war to start in about 20 turns.

Quote:
Originally posted by Jaguar Warrior
Arrian:

How are you going to hold the city with a few mounted warriors who have been injured in the attack?

(BTW I know it works when you have 15 of them, because they can just move on and kill anything that heads for the city. However, I would argue that if you had 15 Immortals you owuld be equally invincible.)
__________________
1st C3DG Term 7 Science Advisor 1st C3DG Term 8 Domestic Minister
Templar Science Minister
AI: I sure wish Jon would hurry up and complete his turn, he's been at it for over 1,200,000 milliseconds now. :mad:
joncnunn is offline  
Old January 17, 2003, 16:30   #13
Catt
PtWDG Gathering StormApolyton University
King
 
Catt's Avatar
 
Local Time: 07:37
Local Date: November 1, 2010
Join Date: May 2002
Location: California - SF Bay Area
Posts: 2,120
Jaguar Warrior - nice analysis (lots of math!).

But I think this is one of those comparisons (immortals+catapults+spears vs. MWs) that is more relevant when taking into account non-mathematical variables: who is the target? what is the terrain like? what map features are prominent? etc.

The key strength of an MW attack is its speed. Only rarely need one worry about defending cities with MWs if conducting a well-planned campaign. The MWs will almost always be on offence, and the border expansions that come with taking cities reinforces this. Slow moving spears take up the rear and reinforce behind the blitzkrieg.

On the other hand, with very rough terrain (taking away the MW speed advantage), an opponent that likes to build fast-movers (e.g., Iroquois, Egypt), and/or map features that promise a more scattershot approach rather then a linear march of conquest, a slowmoving, mixed-unit force that is great on offense and defense makes a heckuva lot more sense.

I find that part of the fun of Civ is that it's so da*n hard to say that MWs or the approach you analyze is the better -- it all depends on circumstance!

Catt

BTW - some testing by etj4Eagle and sumthinelse at CFC seemed to indicate pretty clearly that the bombardment targeting ratios have changed with PTW -- it now seems that bombardments will target a unit (rather than a city improvement or pop point) only 30% or 33% of the time -- it seemed to be 50% of the time in vanilla Civ - so the catapult damage percentage in your post should be a small bit lower).

Edit for spelling.

Last edited by Catt; January 17, 2003 at 16:47.
Catt is offline  
Old January 17, 2003, 16:43   #14
Arrian
PtWDG Gathering StormInterSite Democracy Game: Apolyton TeamApolyton UniversityC4DG Gathering StormPtWDG2 Cake or Death?
Deity
 
Arrian's Avatar
 
Local Time: 10:37
Local Date: November 1, 2010
Join Date: Jul 2001
Location: Kneel before Grog!
Posts: 17,978
Quote:
Originally posted by Jaguar Warrior
Arrian:


How are you going to hold the city with a few mounted warriors who have been injured in the attack?


(BTW I know it works when you have 15 of them, because they can just move on and kill anything that heads for the city. However, I would argue that if you had 15 Immortals you owuld be equally invincible.)
Simple. First, when I open my attack, I do bring some spearmen along. I stack up my units at the border (hopefully at the good angle, where you can do a "move 1 tile and hit" attack even on a city with a cultural influence of 2). Then, my mounted troops move into enemy territory, attack, and take the city. Then, my spearmen (2 or 3 at the start of the campaign, prolly*) use the road (which is now mine) to enter the city and fortify. Yes, I know this requires roads, but there usually are roads built by the time I unleash a major mounted attack. Otherwise, I send in the spearmen/swordsmen 1 turn earlier, such that they are adjacent to the enemy city when my mounted troops attack.

* - I often ditch the spearmen in favor of swordsmen upgraded from warriors. They can hit and defend. Newly captured cities poprush regular spearmen and are left behind.

-Arrian
__________________
grog want tank...Grog Want Tank... GROG WANT TANK!

The trick isn't to break some eggs to make an omelette, it's convincing the eggs to break themselves in order to aspire to omelettehood.
Arrian is offline  
Old January 17, 2003, 19:06   #15
Jaguar
C4DG Sarantium
Emperor
 
Jaguar's Avatar
 
Local Time: 10:37
Local Date: November 1, 2010
Join Date: Apr 2000
Location: New Haven, CT
Posts: 4,790
Quote:
Originally posted by Dominae
If an invincible stack of 15 MWs confronts an invincible stack of 15 Immortals, what happens?!
Stalemate. The MW's speed ensures that it can always be on the attack when it faces the Immortal. They win about 3/5 to 2/3 of the time attacking Immortals on flat ground. However, the key is "on flat ground." The immortals would head for the mountains, and the MW general would unsuccessfully try to lure them onto flat ground.
__________________
"You're the biggest user of hindsight that I've ever known. Your favorite team, in any sport, is the one that just won. If you were a woman, you'd likely be a slut." - Slowwhand, to Imran

Eschewing silly games since December 4, 2005
Jaguar is offline  
Old January 17, 2003, 19:32   #16
DaveMcW
Prince
 
DaveMcW's Avatar
 
Local Time: 09:37
Local Date: November 1, 2010
Join Date: Aug 2002
Posts: 699
I don't mind casualties while taking enemy towns. By the time my invasion is ready I am producing at least 30 shields per turn, probably closer to 60. So I can afford to lose 1-2 units per turn.
DaveMcW is offline  
Old January 17, 2003, 19:47   #17
nbarclay
PtWDG Gathering StormInterSite Democracy Game: Apolyton TeamApolyton UniversityC4DG Gathering Storm
Emperor
 
nbarclay's Avatar
 
Local Time: 08:37
Local Date: November 1, 2010
Join Date: Dec 1999
Location: Huntsville, Alabama
Posts: 6,676
A proper analysis comparing the merits of the units must be dynamic, not just static. The longer a war lasts, the more troops the enemy will build. Thus, even if the mixed force described here suffers fewer casualties per enemy unit encountered, it may still suffer more casualties overall in the course of the war. Also, a longer war may result in more rush building by the AI, and hence greater happiness problems in captured cities if you capture rather than razing. And finally, immortals will spend more time in enemy territory to conquer the same amount of land. To the extent that having troops in enemy territory affects war weariness, immortals would produce a greater war weariness problem under Republic than MWs.

Edit: not that the analysis isn't some pretty nice work as far as it goes.

Nathan

Last edited by nbarclay; January 18, 2003 at 04:29.
nbarclay is offline  
Old January 19, 2003, 19:32   #18
yxhuvud
Chieftain
 
Local Time: 15:37
Local Date: November 1, 2010
Join Date: Jul 2002
Posts: 67
nb:

A few points:

That the opponent will get more troops while the war lasts is seldom a problem. If you are doing oscilating wars, there isn't any problems at all, since the wars very seldom lasts for more than a few turns, at least they don't for me. Also, while it is true that the oponent get mer troops while the war is going on, so do you. And if it is you that are on the offensive, then if you had built enough troops prior to the war, you should be able to at least hurt their production ability somewhat, making for a better situation for you.

This should hold if you are fighting oscilating war against any civ, or regular warring agaisnt a same sized civ. the reason it holds for oscilating war for bigger as well is that if you build enough troops, you should be able to hurt them enough for them to make peace before the bulk of their reinforcement troops arrive, regardless of wheather you use one or two move units.

And if you are having trouble with war weariness when using immortals, then you are doing something wrong, probably holding off the attack way too long, or using republic, whihc is seldom worthwhile if you are playing the persians and have iron

I am having my best shot so far at deity (tiny, pangaea) with the persians at the moment. I started with only the english as neighbour, but with the chinese being close on the other side of them. They must have had an early war, since when I attacked the english in the 1300's BC tehy had only two spears a city and no other troops. Razed london, which had *3* wonders 1280BC.

Presently I have like one city left of the english to take, and a few of the americans as well. I am leading the power league and I have the most land area. However, I am very frightened of the japanese, since I am far behind in tech still in the ancient age, and I am afraid they have samurais, which could turn the game into a very ugly one should they chose to attack. Hopefully I will be able to clear the last other civs and be able to set up a killing grounds close to a chokepoint before that happens, but it is a war against time.
yxhuvud is offline  
Old January 20, 2003, 15:09   #19
Bamspeedy
Chieftain
 
Bamspeedy's Avatar
 
Local Time: 08:37
Local Date: November 1, 2010
Join Date: Sep 2002
Location: Wisconsin, USA
Posts: 60
Sure, I'd love the immortals on tiny maps. But on larger maps, the 1-move units are next to worthless if you want to wage any sort of quick warfare. And they don't upgrade to anything.
Bamspeedy is offline  
Old January 20, 2003, 17:44   #20
Theseus
PtWDG Gathering StormApolyton UniversityApolytoners Hall of FameBtS Tri-LeagueC4DG Gathering StormApolyCon 06 Participants
Emperor
 
Theseus's Avatar
 
Local Time: 10:37
Local Date: November 1, 2010
Join Date: Apr 2002
Location: The warmonger formerly known as rpodos. Gathering Storm!
Posts: 8,907
"Slow warfare" has its advantages though... more opportunities for GLs.
__________________
The greatest delight for man is to inflict defeat on his enemies, to drive them before him, to see those dear to them with their faces bathed in tears, to bestride their horses, to crush in his arms their daughters and wives.

Duas uncias in puncta mortalis est.
Theseus is offline  
Old January 20, 2003, 18:07   #21
Arrian
PtWDG Gathering StormInterSite Democracy Game: Apolyton TeamApolyton UniversityC4DG Gathering StormPtWDG2 Cake or Death?
Deity
 
Arrian's Avatar
 
Local Time: 10:37
Local Date: November 1, 2010
Join Date: Jul 2001
Location: Kneel before Grog!
Posts: 17,978
Theseus,

Ah! But you can execute "slow warfare" even more effectively with fast-movers! Slow warfare is then a choice to suit your wants/needs, rather than a condition forced upon you because your troops are slow.

-Arrian
__________________
grog want tank...Grog Want Tank... GROG WANT TANK!

The trick isn't to break some eggs to make an omelette, it's convincing the eggs to break themselves in order to aspire to omelettehood.
Arrian is offline  
Old January 21, 2003, 09:28   #22
Zachriel
King
 
Zachriel's Avatar
 
Local Time: 10:37
Local Date: November 1, 2010
Join Date: Dec 2001
Location: U.S.A.
Posts: 1,194
Quote:
Originally posted by Catt
But I think this is one of those comparisons (immortals+catapults+spears vs. MWs) that is more relevant when taking into account non-mathematical variables: who is the target? what is the terrain like? what map features are prominent? etc.


Add to that the relative strengths of the Civs involved. The Combined Arms Stack is stronger, but slower. If you are significantly behind your enemy in production, they might be able to take out your units faster than you can make them. When the AI is competitive, the Combined Arms Stack can take the heat and still carry the attack forward.

Of course, if you are playing Iroquois, you would normally build at least some Mounted Warriors to support your Combined Arms Stack by skirmishing with counterattacking units, such as Archers and Horsemen caught in the open.
Zachriel is offline  
Old January 21, 2003, 19:45   #23
Brizey
Civilization III PBEM
Prince
 
Brizey's Avatar
 
Local Time: 09:37
Local Date: November 1, 2010
Join Date: Apr 2002
Location: The Republic of Texas
Posts: 305
I see that a few of you have downloaded my calculator. Any feedback, in particular contructive criticism?
__________________
Got my new computer!!!!
Brizey is offline  
 

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump


All times are GMT -4. The time now is 10:37.


Design by Vjacheslav Trushkin, color scheme by ColorizeIt!.
Powered by vBulletin® Version 3.8.2
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Apolyton Civilization Site | Copyright © The Apolyton Team