The Armory

Military Analysis, turn 144


4 horsemen (4 veteran) = 64
11 Knight (1 Elite, 10 Veteran) = 405
17 hoplites (17 veteran) = 306
11 MDI (7 veteran, 4 regular) = 320
1 catapult = ? (I'll get to this soon, I promise)
2 galleys (1 veteran, 1 regular) = 25
1 Caravel (1 veteran) = 14
TOTAL = 1134

KISS is STILL STRONG > 1361 :eek:
DNUTS are Weak < 907
TNT is Weak < 907

KISS Analysis:
KISS t96 < 392
KISS t97 < 412
KISS t98 < 412
KISS t99 < 440
KISS t100 < 462
(produce 1 GS @ 26)
KISS t101 > 481
(Produce 1 GS @ 26)
KISS t102 < 516
KISS t103 < 570
KISS t104 < 570
KISS t105 < 570
KISS t106 > 570
KISS t107 > 570
KISS t108 > 570
KISS t109 > 590
.....
KISS t122 > 600 776

8 turns pass with no change in standings...

KISS t130 > 955
KISS t134 > 998
KISS t137 > 1085
KISS t138 > 1085
KISS t139 > 1128
KISS t141 > 1171
KISS t144 > 1361​

TNT Analysis
t136 TNT 724 - 1084
t137 TNT < 723, but KISS remains > 1084, despite losing xxx points
t138 TNT < 723
t139 TNT < 772
t141 TNT < 781
t144 TNT < 907​
 
Just to keep everyone in the loop, so to speak, I'm searching for a graphing program that will allow me to display the status of the other teams' military over the past hundred turns. So far, the programs that I've come across are much more powerful than I require, so I'm still looking.

The biggest hurdle that I'm facing is how to enter a range for a given data point. Those programs demand discreet values, where we need to enter a range for someone if they are average to us.

Maybe there's a way to get excel to do this, but I've no idea.

Thanks for the gratitude, Fe :)
 
Have you spoken to your accounting people at work?

You'd be supprised what little programmes the bean counters have in their private collections ;)
 
Peter, I believe you can easily use Excel for this.

To set up a data range, simply use another column in the table to determine if a value falls within a range. Within the new column, use the IF function in combination with the AND function, and set the range.

For example, this function will determine if a number in a table falls between 1 and 5. If it does, the function will return "true."

=IF(AND(A14>1,A14<5),"true","false")
Click to expand...

To make it work better for your purpose, you could put calculations into the "true" and "false" spots instead.

For example, this function will check to see if the value falls between 1 and 5, and if it does, it will multiply it by 2. Otherwise, it will return "false".

=IF(AND(A1>1,A1<5),A1*2,"false")
Click to expand...

Was this any help?

~The Official Bean Counter of MIA~
 
Peter sent me raw Excel data

I will forward to gbno1fan as I am only familiar with basic graphs (and have a horrible premonition about a possible health scenario which will affect ability to concentrate :( ... we see doc this week to see <gulp> )

So you maybe able to whip something presentable up easier. :D
 
Military Analysis, turn 144


4 horsemen (4 veteran) = 64
12 Knight (1 Elite, 11 Veteran) = 441
17 hoplites (17 veteran) = 306
11 MDI (7 veteran, 4 regular) = 320
1 catapult = ? (I'll get to this soon, I promise)
2 galleys (1 veteran, 1 regular) = 25
1 Caravel (1 veteran) = 14
TOTAL = 1170

KISS is still STRONG > 1404 :eek:
DNUTS are Weak < 936
TNT is Weak < 936

KISS Analysis:
KISS t96 < 392
KISS t97 < 412
KISS t98 < 412
KISS t99 < 440
KISS t100 < 462
(produce 1 GS @ 26)
KISS t101 > 481
(Produce 1 GS @ 26)
KISS t102 < 516
KISS t103 < 570
KISS t104 < 570
KISS t105 < 570
KISS t106 > 570
KISS t107 > 570
KISS t108 > 570
KISS t109 > 590
.....
KISS t122 > 600 776

8 turns pass with no change in standings...

KISS t130 > 955
KISS t134 > 998
KISS t137 > 1085
KISS t138 > 1085
KISS t139 > 1128
KISS t141 > 1171
KISS t144 > 1361
KISS t146 > 1404​

TNT Analysis
t136 TNT 724 - 1084
t137 TNT < 723, but KISS remains > 1084, despite losing xxx points
t138 TNT < 723
t139 TNT < 772
t141 TNT < 781
t144 TNT < 907
t146 TNT < 935​
 
Military Analysis, turn 148


4 horsemen (4 veteran) = 64
13 Knight (1 Elite, 12 Veteran) = 477
17 hoplites (17 veteran) = 306
11 MDI (7 veteran, 4 regular) = 320
1 catapult = ? (I'll get to this soon, I promise)
1 galley (1 veteran) = 7.5
2 Caraves (2 regular) = 21
TOTAL = 1195

KISS is now AVERAGE!! = 958 - 1432
DNUTS are Weak < 958
TNT is Weak < 958

KISS Analysis:
KISS t96 < 392
KISS t97 < 412
KISS t98 < 412
KISS t99 < 440
KISS t100 < 462
(produce 1 GS @ 26)
KISS t101 > 481
(Produce 1 GS @ 26)
KISS t102 < 516
KISS t103 < 570
KISS t104 < 570
KISS t105 < 570
KISS t106 > 570
KISS t107 > 570
KISS t108 > 570
KISS t109 > 590
.....
KISS t122 > 600 776

8 turns pass with no change in standings...

KISS t130 > 955
KISS t134 > 998
KISS t137 > 1085
KISS t138 > 1085
KISS t139 > 1128
KISS t141 > 1171
KISS t144 > 1361
KISS t146 > 1404
KISS t148 > 958 < 1432​

TNT Analysis
t136 TNT 724 - 1084
t137 TNT < 723, but KISS remains > 1084, despite losing xxx points
t138 TNT < 723
t139 TNT < 772
t141 TNT < 781
t144 TNT < 907
t146 TNT < 935
t148 TNT < 958​
 
Quiet, you!

I'm surprised you haven't jumped all over me for the incorrect data on the Caravel above :)

I'll edit that now (not the catapult stuff, though....)

It does make me wonder if TNT's theft of KISS Trebuchets was just enough to lower KISS into our range. We should probably let TNT know about KISS's numbers
 
Military Analysis, turn 150


4 horsemen (4 veteran) = 64
16 Knight (1 Elite, 15 Veteran) = 585
17 hoplites (17 veteran) = 306
11 MDI (7 veteran, 4 regular) = 320
1 catapult = ? (I'll get to this soon, I promise)
1 galley (1 veteran) = 7.5
2 Caraves (2 regular) = 21
TOTAL = 1303

KISS is still AVERAGE!! = 1043 - 1563
DNUTS are Weak < 1043
TNT is Weak < 1043

KISS Analysis:
KISS t96 < 392
KISS t97 < 412
KISS t98 < 412
KISS t99 < 440
KISS t100 < 462
(produce 1 GS @ 26)
KISS t101 > 481
(Produce 1 GS @ 26)
KISS t102 < 516
KISS t103 < 570
KISS t104 < 570
KISS t105 < 570
KISS t106 > 570
KISS t107 > 570
KISS t108 > 570
KISS t109 > 590
.....
KISS t122 > 600 776

8 turns pass with no change in standings...

KISS t130 > 955
KISS t134 > 998
KISS t137 > 1085
KISS t138 > 1085
KISS t139 > 1128
KISS t141 > 1171
KISS t144 > 1361
KISS t146 > 1404
KISS t148 > 958 < 1432
KISS t150 > 1043 < 1563​

TNT Analysis
t136 TNT 724 - 1084
t137 TNT < 723, but KISS remains > 1084, despite losing xxx points
t138 TNT < 723
t139 TNT < 772
t141 TNT < 781
t144 TNT < 907
t146 TNT < 935
t148 TNT < 958
t150 TNT < 1043​
 
Military Analysis, turn 151


4 horsemen (4 veteran) = 64
17 Knight (1 Elite, 16 Veteran) = 621
17 hoplites (17 veteran) = 306
11 MDI (7 veteran, 4 regular) = 320
1 catapult = ? (I'll get to this soon, I promise)
1 galley (1 veteran) = 7.5
2 Caraves (2 regular) = 21
TOTAL = 1339

KISS is still AVERAGE!! = 1071 - 1607
DNUTS are Weak < 1071
TNT is Weak < 1071

KISS Analysis:
KISS t96 < 392
KISS t97 < 412
KISS t98 < 412
KISS t99 < 440
KISS t100 < 462
(produce 1 GS @ 26)
KISS t101 > 481
(Produce 1 GS @ 26)
KISS t102 < 516
KISS t103 < 570
KISS t104 < 570
KISS t105 < 570
KISS t106 > 570
KISS t107 > 570
KISS t108 > 570
KISS t109 > 590
.....
KISS t122 > 600 776

8 turns pass with no change in standings...

KISS t130 > 955
KISS t134 > 998
KISS t137 > 1085
KISS t138 > 1085
KISS t139 > 1128
KISS t141 > 1171
KISS t144 > 1361
KISS t146 > 1404
KISS t148 > 958 < 1432
KISS t150 > 1043 < 1563
KISS t151 > 1071 < 1607​

TNT Analysis
t136 TNT 724 - 1084
t137 TNT < 723, but KISS remains > 1084, despite losing xxx points
t138 TNT < 723
t139 TNT < 772
t141 TNT < 781
t144 TNT < 907
t146 TNT < 935
t148 TNT < 958
t150 TNT < 1043
t151 TNT < 1071​
 
Military Analysis, turn 152


4 horsemen (4 veteran) = 64
18 Knight (1 Elite, 17 Veteran) = 657
17 hoplites (17 veteran) = 306
11 MDI (7 veteran, 4 regular) = 320
1 catapult = ? (I'll get to this soon, I promise)
1 galley (1 veteran) = 7.5
2 Caraves (2 regular) = 21
TOTAL = 1375

KISS is still AVERAGE!! = 1100 - 1650
DNUTS are Weak < 1100
TNT is Weak < 1100

KISS Analysis:
KISS t96 < 392
KISS t97 < 412
KISS t98 < 412
KISS t99 < 440
KISS t100 < 462
(produce 1 GS @ 26)
KISS t101 > 481
(Produce 1 GS @ 26)
KISS t102 < 516
KISS t103 < 570
KISS t104 < 570
KISS t105 < 570
KISS t106 > 570
KISS t107 > 570
KISS t108 > 570
KISS t109 > 590
.....
KISS t122 > 600 776

8 turns pass with no change in standings...

KISS t130 > 955
KISS t134 > 998
KISS t137 > 1085
KISS t138 > 1085
KISS t139 > 1128
KISS t141 > 1171
KISS t144 > 1361
KISS t146 > 1404
KISS t148 > 958 < 1432
KISS t150 > 1043 < 1563
KISS t151 > 1071 < 1607
KISS t152 > 1100 < 1650​

TNT Analysis
t136 TNT 724 - 1084
t137 TNT < 723, but KISS remains > 1084, despite losing xxx points
t138 TNT < 723
t139 TNT < 772
t141 TNT < 781
t144 TNT < 907
t146 TNT < 935
t148 TNT < 958
t150 TNT < 1043
t151 TNT < 1071
t152 TNT < 1100​
 
Military Analysis, turn 153


4 horsemen (4 veteran) = 64
19 Knight (1 Elite, 18 Veteran) = 693
17 hoplites (17 veteran) = 306
11 MDI (7 veteran, 4 regular) = 320
1 catapult = 6 (I'll get to this soon, I promise)
1 trebuchet = 9 (I'll get to this as soon as Chamnix makes a big enough stink ;))
1 galley (1 veteran) = 7.5
2 Caravels (2 regular) = 21
TOTAL = 1411 1426

KISS is still AVERAGE!! = 1129 - 1693 1142 - 1700
DNUTS are Weak < 1129 1141
TNT is Weak < 1129 1141

KISS Analysis:
KISS t96 < 392
KISS t97 < 412
KISS t98 < 412
KISS t99 < 440
KISS t100 < 462
(produce 1 GS @ 26)
KISS t101 > 481
(Produce 1 GS @ 26)
KISS t102 < 516
KISS t103 < 570
KISS t104 < 570
KISS t105 < 570
KISS t106 > 570
KISS t107 > 570
KISS t108 > 570
KISS t109 > 590
.....
KISS t122 > 600 776

8 turns pass with no change in standings...

KISS t130 > 955
KISS t134 > 998
KISS t137 > 1085
KISS t138 > 1085
KISS t139 > 1128
KISS t141 > 1171
KISS t144 > 1361
KISS t146 > 1404
KISS t148 > 958 < 1432
KISS t150 > 1043 < 1563
KISS t151 > 1071 < 1607
KISS t152 > 1100 < 1650
KISS t153 > 1129 < 1693 1142 - 1700​

TNT Analysis*
t136 TNT 724 - 1084
t137 TNT < 723, but KISS remains > 1084, despite losing xxx points
t138 TNT < 723
t139 TNT < 772
t141 TNT < 781
t144 TNT < 907
t146 TNT < 935
t148 TNT < 958
t150 TNT < 1043
t151 TNT < 1071
t152 TNT < 1100
t153 TNT < 1129 1141*​

*These hosers have only one city left. There is no need for me to keep tracking their lack-of-strength. As of T154 this section will be devoted to DNUTs, who are currently Weak to us.
 
Update! I finally added in the Catapult and Trebuchet data. I treated our bombard units as regulars. Please advise if that is incorrect :)
 
Military Analysis, turn 154


4 horsemen (4 veteran) = 64
20 Knight (1 Elite, 19 Veteran) = 729
17 hoplites (17 veteran) = 306
11 MDI (7 veteran, 4 regular) = 320
1 catapult = 6
1 trebuchet = 9
1 galley (1 veteran) = 7.5
2 Caravels (2 regular) = 21
TOTAL = 1462

KISS is still AVERAGE!! = 1141 - 1699 1210 - 1714
DNUTS are Weak < 1210
TNT is Weak < 1210

KISS Analysis:
KISS t96 < 392
KISS t97 < 412
KISS t98 < 412
KISS t99 < 440
KISS t100 < 462
(produce 1 GS @ 26)
KISS t101 > 481
(Produce 1 GS @ 26)
KISS t102 < 516
KISS t103 < 570
KISS t104 < 570
KISS t105 < 570
KISS t106 > 570
KISS t107 > 570
KISS t108 > 570
KISS t109 > 590
.....
KISS t122 > 600 776

8 turns pass with no change in standings...

KISS t130 > 955
KISS t134 > 998
KISS t137 > 1085
KISS t138 > 1085
KISS t139 > 1128
KISS t141 > 1171
KISS t144 > 1361
KISS t146 > 1404
KISS t148 > 958 < 1432
KISS t150 > 1043 < 1563
KISS t151 > 1071 < 1607
KISS t152 > 1100 < 1650
KISS t153 > 1142 - 1700
KISS t154 > 1210 < 1714​

DNUT/TNT Analysis
t136 TNT 724 - 1084
t137 TNT < 723, but KISS remains > 1084, despite losing xxx points
t138 TNT < 723
t139 TNT < 772
t141 TNT < 781
t144 TNT < 907
t146 TNT < 935
t148 TNT < 958
t150 TNT < 1043
t151 TNT < 1071
t152 TNT < 1100
t153 TNT < 1141
t154 DNUT/TNT < 1210​
 
Military Analysis, turn 154


4 horsemen (4 veteran) = 64
21 Knight (1 Elite, 20 Veteran) = 765
17 hoplites (17 veteran) = 306
11 MDI (7 veteran, 4 regular) = 320
1 catapult = 6
1 trebuchet = 9
1 galley (1 veteran) = 7.5
2 Caravels (2 regular) = 21
TOTAL = 1518

KISS is still AVERAGE!! = 1210 - 1714 1215 - 1821
DNUTS are Weak < 1215
TNT is Weak < 1215

KISS Analysis:
KISS t96 < 392
KISS t97 < 412
KISS t98 < 412
KISS t99 < 440
KISS t100 < 462
(produce 1 GS @ 26)
KISS t101 > 481
(Produce 1 GS @ 26)
KISS t102 < 516
KISS t103 < 570
KISS t104 < 570
KISS t105 < 570
KISS t106 > 570
KISS t107 > 570
KISS t108 > 570
KISS t109 > 590
.....
KISS t122 > 600 776

8 turns pass with no change in standings...

KISS t130 > 955
KISS t134 > 998
KISS t137 > 1085
KISS t138 > 1085
KISS t139 > 1128
KISS t141 > 1171
KISS t144 > 1361
KISS t146 > 1404
KISS t148 > 958 < 1432
KISS t150 > 1043 < 1563
KISS t151 > 1071 < 1607
KISS t152 > 1100 < 1650
KISS t153 > 1142 - 1700
KISS t154 > 1210 < 1714
KISS t155 > 1215 < 1821​


DNUT/TNT Analysis
t136 TNT 724 - 1084
t137 TNT < 723, but KISS remains > 1084, despite losing xxx points
t138 TNT < 723
t139 TNT < 772
t141 TNT < 781
t144 TNT < 907
t146 TNT < 935
t148 TNT < 958
t150 TNT < 1043
t151 TNT < 1071
t152 TNT < 1100
t153 TNT < 1141
t154 DNUT/TNT < 1210
t155 DNUT/TNT < 1215​
 
Military Analysis, turn 157


4 horsemen (4 veteran) = 64
23 Knight (1 Elite, 22 Veteran) = 832
17 hoplites (17 veteran) = 306
11 MDI (7 veteran, 4 regular) = 320
1 catapult = 6
2 trebuchet = 18
1 galley (1 veteran) = 7.5
1 Galleon = 14
2 Caravels (2 regular) = 21
TOTAL = 1518

KISS is still AVERAGE!! = 1215 - 1821 1284 - 1926
DNUTS are Weak < 1284
TNT is Weak < 1284

KISS Analysis:
KISS t96 < 392
KISS t97 < 412
KISS t98 < 412
KISS t99 < 440
KISS t100 < 462
(produce 1 GS @ 26)
KISS t101 > 481
(Produce 1 GS @ 26)
KISS t102 < 516
KISS t103 < 570
KISS t104 < 570
KISS t105 < 570
KISS t106 > 570
KISS t107 > 570
KISS t108 > 570
KISS t109 > 590
.....
KISS t122 > 600 776

8 turns pass with no change in standings...

KISS t130 > 955
KISS t134 > 998
KISS t137 > 1085
KISS t138 > 1085
KISS t139 > 1128
KISS t141 > 1171
KISS t144 > 1361
KISS t146 > 1404
KISS t148 > 958 < 1432
KISS t150 > 1043 < 1563
KISS t151 > 1071 < 1607
KISS t152 > 1100 < 1650
KISS t153 > 1142 - 1700
KISS t154 > 1210 < 1714
KISS t155 > 1215 < 1821
KISS t157 > 1284 < 1926​

DNUT/TNT Analysis
t136 TNT 724 - 1084
t137 TNT < 723, but KISS remains > 1084, despite losing xxx points
t138 TNT < 723
t139 TNT < 772
t141 TNT < 781
t144 TNT < 907
t146 TNT < 935
t148 TNT < 958
t150 TNT < 1043
t151 TNT < 1071
t152 TNT < 1100
t153 TNT < 1141
t154 DNUT/TNT < 1210
t155 DNUT/TNT < 1215
t157 DNUT/TNT < 1284​
 
Military Analysis, turn 159


4 horsemen (4 veteran) = 64
27 Knight (1 Elite, 26 Veteran) = 976
17 hoplites (17 veteran) = 306
11 MDI (7 veteran, 4 regular) = 320
1 catapult = 6
2 trebuchet = 27
1 Galleon = 14
2 Caravels (2 regular) = 21
TOTAL = 1681

KISS is still AVERAGE!! = 1284 - 1926 1345 - 2017
DNUTS are Weak < 1345
TNT is Weak < 1345

KISS Analysis:
KISS t96 < 392
KISS t97 < 412
KISS t98 < 412
KISS t99 < 440
KISS t100 < 462
(produce 1 GS @ 26)
KISS t101 > 481
(Produce 1 GS @ 26)
KISS t102 < 516
KISS t103 < 570
KISS t104 < 570
KISS t105 < 570
KISS t106 > 570
KISS t107 > 570
KISS t108 > 570
KISS t109 > 590
.....
KISS t122 > 600 776

8 turns pass with no change in standings...

KISS t130 > 955
KISS t134 > 998
KISS t137 > 1085
KISS t138 > 1085
KISS t139 > 1128
KISS t141 > 1171
KISS t144 > 1361
KISS t146 > 1404
KISS t148 > 958 < 1432
KISS t150 > 1043 < 1563
KISS t151 > 1071 < 1607
KISS t152 > 1100 < 1650
KISS t153 > 1142 - 1700
KISS t154 > 1210 < 1714
KISS t155 > 1215 < 1821
KISS t157 > 1284 < 1926
KISS t159 > 1345 < 2017​

DNUT/TNT Analysis
t136 TNT 724 - 1084
t137 TNT < 723, but KISS remains > 1084, despite losing xxx points
t138 TNT < 723
t139 TNT < 772
t141 TNT < 781
t144 TNT < 907
t146 TNT < 935
t148 TNT < 958
t150 TNT < 1043
t151 TNT < 1071
t152 TNT < 1100
t153 TNT < 1141
t154 DNUT/TNT < 1210
t155 DNUT/TNT < 1215
t157 DNUT/TNT < 1284
t159 DBUT/TNT < 1345​
 
Military Analysis, turn 160


4 horsemen (4 veteran) = 64
28 Knight (1 Elite, 27 Veteran) = 1010
17 hoplites (17 veteran) = 306
11 MDI (7 veteran, 4 regular) = 320
1 catapult = 6
4 trebuchet = 36
1 Galleon = 14
2 Caravels (2 regular) = 21
TOTAL = 1726

KISS is still AVERAGE!! = 1345 - 2017 1381 - 2071
DNUTS are Weak < 1381
TNT is Weak < 1381

KISS Analysis:
KISS t96 < 392
KISS t97 < 412
KISS t98 < 412
KISS t99 < 440
KISS t100 < 462
(produce 1 GS @ 26)
KISS t101 > 481
(Produce 1 GS @ 26)
KISS t102 < 516
KISS t103 < 570
KISS t104 < 570
KISS t105 < 570
KISS t106 > 570
KISS t107 > 570
KISS t108 > 570
KISS t109 > 590
.....
KISS t122 > 600 776

8 turns pass with no change in standings...

KISS t130 > 955
KISS t134 > 998
KISS t137 > 1085
KISS t138 > 1085
KISS t139 > 1128
KISS t141 > 1171
KISS t144 > 1361
KISS t146 > 1404
KISS t148 > 958 < 1432
KISS t150 > 1043 < 1563
KISS t151 > 1071 < 1607
KISS t152 > 1100 < 1650
KISS t153 > 1142 - 1700
KISS t154 > 1210 < 1714
KISS t155 > 1215 < 1821
KISS t157 > 1284 < 1926
KISS t159 > 1345 < 2017
KISS t160 > 1381 < 2071​

DNUT/TNT Analysis
t136 TNT 724 - 1084
t137 TNT < 723, but KISS remains > 1084, despite losing xxx points
t138 TNT < 723
t139 TNT < 772
t141 TNT < 781
t144 TNT < 907
t146 TNT < 935
t148 TNT < 958
t150 TNT < 1043
t151 TNT < 1071
t152 TNT < 1100
t153 TNT < 1141
t154 DNUT/TNT < 1210
t155 DNUT/TNT < 1215
t157 DNUT/TNT < 1284
t159 DNUT/TNT < 1345
t160 DNUT/TNT < 1381​
 
You must log in or register to reply here.

Similar threads

I
Cities can train up to 2 units instead of one mod.
Replies
0
Views
350
infiniterocks
I
bengalryan9
Civ Discussion - Antiquity Age Summary/Tier Lists
Replies
14
Views
1K
Boris Gudenuf
Boris Gudenuf
Marla_Singer
  • Locked
*** Site experiencing technical issues ***
Replies
13
Views
865
The_J
The_J
C
Chrispresso's Debug Console (CDC)
Replies
0
Views
269
chrispresso
C
SiBr3
SiBr3's Transparent Appeal
Replies
10
Views
755
SiBr3
SiBr3
Back
Top Bottom