Snarkhunter
Prince
well... I'm not saying that all units have DEFINITE and the ONLY attack/defense values, but lets get real.... if a massive army of archers charged (while firing) at a massive army of swordsmen (same size army) I'd say its pretty obvious who'd win.
As for the pike, yes, it was used for attacking, but that was also when most of the weapons were too expensive to build, and building pikes/spears was a real cheap and efficient weapon, and I'm not sure of anyone who was fully educated on the subject would say that the pike was more efficient when attacking than when in the proper defensive stance.
Yes, but that's not how archers were used, historically. Except for something like horse archers, which did attack swordsmen & handed them their fundiments, more often than not.
It was certainly cheaper to arm large numbers with pikes than with plate armor and broadswords, but that wasn't its main advantage. Instead, it gave infantry something it had lacked for nearly a thousand years: shock capability. Shock and firepower were the two main quantities in offensive warfare for thousands of years. (They still are, but are carried out differently today.) During the heyday of western knights, shock dominated massively & firepower was all but non-existent; this began to pass with longbows & even more with crossbows (& later gunpowder, of course), but pikes were even more effective for shock value, if used properly. And that took some training--you couldn't just hand a peasant a pike & expect him to do anything useful with it on the battlefield. Note finally that from the get-go, the Swiss pikes attacked cavalry on the battlefield; they didn't wait around to receive an attack.
As for "fully educated", well, the great commanders during say the 15th-17th century knew far more about it than everyone on this list put together. . . and they didn't have any problem finding a place for pikes--defensively and offensively--in their armies. As for de Saxe, he's one of the great military theorists--who also backed up his theories on the battlefield. With victories. Get ye to Amazon & score a copy of Reveries without delay if you've never read it!
Marsden, as for Agincourt, the longbows acted first as bombardment units. Then after a certain point, the archers thrw away their bows and became in effect warriors, armed with axes and daggers & took their melee value of "1" against a melee defense of "0"--4/4 longbow-->5/5 warrior

To really capture all this, you'd need to rate units separately for firepower & shock--call it melee-- & still further perhaps for offensive and defensive melee, but that is too refined for Civ3

kk