Total Profile Attack and defense stats vs A/D of units bought??? doesn't add up.

[Valsta]

I've read and read and read, but I can't seem to come across a thread that answers my question. In the beginning when purchasing a unit the A/D values of the unit would add into my A/D total stats at 100%. However, at some point all units stop adding to your total A/D stats at 100% of the value shown for the unit. Clearly I first figured this out after buying 300 scouts and realized my stats hadn't increased by 300 in A/D. Since then I have kept track on several units when purchasing them and noticed that at some point the values are reduced by a percentage and not necessarily the same percent for both A/D. For example when purchasing some Bradley fighting vehicles today (attack - 7 / defense - 7) I only got an increase of 5 on attack and 4 on defense to my total A/D stats.

I'm not asking about the value of A/D you can take into battle based off of your ally count and your current level.

There is a lot of talk of spreadsheets on the forum, but I have yet to find one that addresses this.

[Mcdoc]

That's because Scouts have such low stats that they fall below your top units brought into battle. So say you have 100 allies and therefore bring 400 units into battle (it says you bring 4 units per ally) - so obviously if you have 350 units with higher stats than your 300 scouts - you would only bring 50 scouts with you.

.

A better strategy would have been to buy 30 more expensive units with far superior stats than the 300 scouts.

.

Good luck.

[bigflan]

I've read and read and read, but I can't seem to come across a thread that answers my question. In the beginning when purchasing a unit the A/D values of the unit would add into my A/D total stats at 100%. However, at some point all units stop adding to your total A/D stats at 100% of the value shown for the unit. Clearly I first figured this out after buying 300 scouts and realized my stats hadn't increased by 300 in A/D. Since then I have kept track on several units when purchasing them and noticed that at some point the values are reduced by a percentage and not necessarily the same percent for both A/D. For example when purchasing some Bradley fighting vehicles today (attack - 7 / defense - 7) I only got an increase of 5 on attack and 4 on defense to my total A/D stats.

I'm not asking about the value of A/D you can take into battle based off of your ally count and your current level.

There is a lot of talk of spreadsheets on the forum, but I have yet to find one that addresses this. The attack and defense stat on your stat screen are based off 4 factors the units you use in battle stats combined ,country bonus , boost building and defense building are all taken into account

[bigflan]

The attack and defense stat on your stat screen are based off 4 factors the units you use in battle stats combined ,country bonus , boost building and defense building are all taken into accountYou see here if my lowest defense unit has 8 defense that is used to defend and I buy a k150 stratotanker which has 18 defense so it kicks the unit with 8 defense out and the difference between them is 10 so my defense increases by 10

[StuN]

Ok, I've been seeing this but I've not said anything because I thought I was missing someting obvious. However, tonight I bought a carrier which has 46 def. My def was 27000 before I bought it but only 27038 after it was added. Obviously, it was added to my def but why only a 38 point increase & not 46? In fact if the boosts were working correctly, it should have been more than 46 as my nation is UK, I have a lvl 1 Naval Research building & a lvl 6 Composite building. The sums don't add up
Also I have 450 allies & 2967 units

[Maverick50727]

Ok, I've been seeing this but I've not said anything because I thought I was missing someting obvious. However, tonight I bought a carrier which has 46 def. My def was 27000 before I bought it but only 27038 after it was added. Obviously, it was added to my def but why only a 38 point increase & not 46? In fact if the boosts were working correctly, it should have been more than 46 as my nation is UK, I have a lvl 1 Naval Research building & a lvl 6 Composite building. The sums don't add up
Also I have 450 allies & 2967 unitsWhat is not adding up? 46-38=8 so it replaced a unit with 7-8 defenese depending on all your bonuses. If you really want to verify you can dump all of your units A/D and qty. Then you just sort by the A or D values, and you know how many units are taken in. That should show you what units you are taking into battle on the defense side. Attack side is easy of you aren't taking in more than 45 different type, you can just see your units. If over you have to do the spreadsheet again. If you have mutiple units with same attack value as your lowest unit , say 3 units all with 11A but have different Def values like 11A/26D, 11A/18D and 11A/15D. Then the Attack unit with 11/26 will be dropped if you are at your max limit. So if you are at your unit limt you might on bring all your 11/18 and 11/15 units, but only bring X of your Qty of 11/26 up to your limit. This has been my experience that I noticed. 11/26 was a minelauncher and I was only bring a few in, but really wanted them just for defense so I can add any unit with 12A to drop them out of my attack unit list.

Hope this makes sense.

What level and income are you to be buying aircraft carriers. I'm at L104 and not even buying them. the valor M270s with defense of 37 do me just fine for now.

[Mcdoc]

What is not adding up? 46-38=8 so it replaced a unit with 7-8 defense That's the simple answer. You didn't just ADD a unit, REPLACED a lower unit with a higher unit, so the math isn't exactly the stats of the higher unit.

[Valsta]

Maverick... it sounds as though you are stating that a higher A/D unit will replace a lower one? And I am assuming you are basing that off of the number of allies taken into battle multiplied by your level. If that were the case then why is it that I can buy lower A/D units and still see "some" affect on my overall A/D status?

For example, I have the following overall stats: A-9822 and D-12294, # of units 2265, Level 70, # allies 1088 (I spent a lot of time acquiring allies early in the game before I discovered you can't bring all of them in)

I just bought a Drone Spy Plane (A2, D7) and saw the following increases: A-0, D-5. Why should I see any increase at all when I have more than 280 units (level 70 x 4 allies) that have a greater defense value of 5. The only thing that makes sense to me is that the "total units" brought into battle is evaluated on each unit type separately. So for my situation that would be my best 280 infantry, best 280 ground, best 280 air, and best 280 sea. I state this because I have 336 air units with an attack value greater than that of the drone (hence, maybe why I had a zero increase on attack), but I only have 220 air units with a greater defense value of the drone (hence, maybe why I received +5 in defense).

I almost had myself convinced that was it... to test this theory I bought a harrier jet (A18, D14), but I still was left short. I only received A16 and D14.

What was different... well I had 49 drones and bought number 50 and I had 16 harriers and I bought number 17. So I figured it must have to do with the number of units of that item I had.

Once again I thought I had it solved... so I bought an osprey VTOL, which I only had one of. An Osprey stats are A17 and D22. I'm baffled because I only got A15 and D20.

My theory... Each unit will give you 100% of the A/D value up to a specific number of those units. In addition, I believe the "number" of units changes as one excels in the game, most likely what level you are at.

Now, I realize everyone keeps stating it is your best units that are being counted and therefore one is replacing another one and therefore I must have some other units that are competing with the examples above. So, I did the math in reverse. If I'm at level 70 then my total number of units brought into battle is 280 (70 x 4). To make it easier I am just going to focus on defense... I now have 12314 in defense. So, 12314 divided by 280 equals 43.97. Are you following me? What I am stating is that ALL of my best units would have to have a defense score of equal to or greater than 44!!! The only unit with that, other than gold units which I don't have, is a ship that I don't know the name of because I haven't upgraded the dry docks to level 3.

I thought I was confused after reading Mavericks statement... I'm really confused now.

[What?]

The easiest way to explain it is if you have an army maxed out, that is all available units filled in an attack and defense force, if you purchase a new unit that is higher than your lowest unit. The lowest unit will be replaced. So that means that attack or defense score of the unit that was replaced no longer is added to your total score. It has now been replaced in your army so if you had a unit that was replaced with a score of 10 and it was being replaced with a unit that has 25 your score would only go up 15 not 25.

[Mcdoc]

@Valsta: there is more to the equation. You are only credited for 5 allies per level for bringing units into battle. So it's LEVEL x 5 to get your Allies credit and then Allies time 4 to get your total units.

70 x 5= 350 maximum Allies credited
350 x 4 = 1400 Units brought in

So you are bringing in your top 1400 units with the highest ATTACK score when you are the aggressor and bringing 1400 units with the highest DEFENSE score when you are the one being attacked.

So you have and extra 865 units (2265-1400) that are just in your inventory and won't be used unless you lose a lot of higher units and start dipping down into your lower units.

So once again, even though you are ADDING a unit to your inventory, you are only REPLACING a unit brought into battle.


The only thing that makes sense to me is that the "total units" brought into battle is evaluated on each unit type separately. So for my situation that would be my best 280 infantry, best 280 ground, best 280 air, and best 280 sea

The above statement is completely out of line with this game. Those rules apply to Crime City, but in Modern War, it is truly your top 1400 units based solely off their individual stats - regardless of what type of unit they are.

Hope that explains it.

[bigflan]

The one above is the best explanation

[StuN]

Good answer Mav & that's exactly how I figured it worked out but (and here's the killer) I counted up all my units that had a def value below 8 & it turns out it couldn't have replaced a unit with the value of 8 because there are too many of the former. The lowest value unit it had to have replaced was 4. That's if I'm correct in thinking 450 allies = 1800 units?

M270s have a great def value but I don't get the most from them as I'm UK so I figured I would get more value from an AC? My economy would allow me to buy one a day at roughly 6mil income per day but it was a test to see what value they would add to my def. I won't be bothering again for a while as it wasn't as good as I thought lol

[Valsta]

You are only credited for 5 allies per level for bringing units into battle. So it's LEVEL x 5 to get your Allies credit and then Allies time 4 to get your total units.

70 x 5= 350 maximum Allies credited
350 x 4 = 1400 Units brought in

So you are bringing in your top 1400 units with the highest ATTACK score when you are the aggressor and bringing 1400 units with the highest DEFENSE score when you are the one being attacked.

So you have and extra 865 units (2265-1400) that are just in your inventory and won't be used unless you lose a lot of higher units and start dipping down into your lower units.

So once again, even though you are ADDING a unit to your inventory, you are only REPLACING a unit brought into battle.

MCDOC... Wow... I almost didn't respond back because I feel REALLY stupid for not catching that sooner. I've been playing for months now and my only excuse is that I have excluded PVP from my game play simply because of casualties and I don't really have a lot of time to search for weaker opponents. I just did a couple PVP to see what units were being used and the number of allies brought into battle is clearly stated... I had seen that before... just forgot.

So, the reason I decided to respond to this (even though I feel stupid) was 1.) Mcdoc thanks for taking the time to explain it so well 2.) To point out to JohnnyR that your explanation in the FNG guide is easily misread and I would strongly suggest that you incorporate Mcdoc's explanation here in place of your "numbers" sectiion. In your explanation you went from "5 X Level" (I think you example is level 5 giving you 25 allies) to "you've got 100 units" brought into battle. Since you didn't spell out that to get to 100 it was 4 times allies I just overlooked that you did more math to get there. 3.) Also JohnnyR an explanation of the missing A/D scores seen when purchasing... ie. this thread... may be very useful to future FNG's.

Now that I understand the "total units" the missing A/D stats due to "replacement" of units makes a lot of sense. FINALLY I GET IT!!!!

To help other FNG's out let me point out that my strategy has been to purchase equal amounts of ALL units... just because I didn't really know what else to do and since missions force you to purchase many of them up to a certain quantity I guess I figured that the game was essentially telling me how many I needed. Now I'm thinking otherwise.

Can any of you suggest the best "unit purchasing" strategy? It seems to me that the first strategy would be to max out your unit count with whatever you can afford... using the above thread as explanation. After that it seems that buying units that give you the best bang for your buck might be the best option. For example, I am currently purchasing the Military Ambulance because of its 18 Defense and it is only $84k. There are a few units available to me with higher stats like the Osprey VTOL D22, but at $640k a pop I wouldn't be getting many. I guess my question is, "is there any reason NOT to pick an item and just purchase as many as you can for its A/D value"? Is there some X factor in regards to having an army that has a balance of all units? As for the Attack side I am leveling up my barracks to level 10 to buy what looks to be a demolitions unit with an attack of 20 for $200k.

If I were to max out my total unit count with these units then I could pick another set of units with higher stats to go after, but we are talking like $400,000,000 to do so... clearly I would have leveled up by then and in essence the unit count would grow faster than I could fill it.

The only unit with similar stats A20 D18 is a Tank and it costs like $540k... so basically double what I could get these units for separately.

I read about many of you talking about purchasing units with greater stats, but Why? If you can get relatively the same A/D stats for a lot less what is the point of purchasing these more expensive ones?

Perhaps I should have created a new thread for this... or perhaps there is one that already exists that you could direct me to.

Thanks again.

[Hello Kitty]

Below are my own stats to illustrate how Attack is calculated, Defense uses similar calculations.

My Level = 38
My Allies = 37

All Players:
Max Allies available to Battle per Level = 5
Max Units available per Ally to Battle = 4

Using My Stats:

Total Units Available to Battle = Level x 5 Allies/Level x 4 Units/Ally = 38 x 5 x 4 = 760.

Since my Actual Ally count (37) is less than the Max Allies I’m allowed to bring to Battle (5 x 38 = 190), I can only bring 37 allies x 4 units = 148 units to battle.

The summary of my inventory for these 148 units is:



Unit Type

# Units to Battle

Total Attack

Building Boost

Att w Boost



Air

14

799

2%

814



Ground

53

1820

2%

1856



Infantry

73

2249

4%

2338



Sea

8

593

2%

604



Totals

148

5461


5612



Attack Skill Points




4



Total Attack




5616






Actual Attack on my Profile = 5616

Note: I'm also USA. The following are additional boosts that are cumulative (Total Attack Score x Building Boost x Country Boost) depending on your country:

China = 10% boost to Infantry
Germany = 10% boost to Ground
Russia = 10% boost to Air
United Kingdom = 10% boost to Sea

My current Attack strategy is to keep my ally count to 37, continue buying Units with attack above 20 and to continue upgrading my boost buildings (Genetics Lab for Infantry, Eletronics Lab for Ground, Airship Hangar for Air, and Naval Research Center for Sea). Since I am only at level 38, I cannot test what happens in PvP at the higher levels where casualties are heavy, so I'm sure my strategy will change per level. I will also eventually consider changing countries. If I were to do that now, I would select either Germany (ground) or China (Infantry) because that’s where I have my largest total Attack values (1856 and 2338, respectively).

Below is a detailed Inventory of my 148 units that I currently take into battle (only Attack is analyzed here). Note: I don’t use 10 of my 19 Strike Eagles because I can only take 148 units to battle. Any Unit I purchase now above an attack score of 19 will continue to replace the Strike Eagles until I retire them. After that I will start depleting my Rapid Fire-Attack Vehicle (attack 20).




Unit

Type

Attack

Defense

My Inventory

Total Attack



Mobile Meeting Room

ground

200

243

1

200



Attack Dog Soldier

infantry

164

101

1

164



Silent Drifter

air

156

114

1

156



Hill Fighter

infantry

140

92

1

140



Sea Shadow

sea

132

109

1

132



Chariot Tank

ground

118

112

1

118



Tarawa Drop Ship

sea

110

290

1

110



SSGN

sea

104

77

2

208



Arctic Tank

ground

95

108

1

95



Shamrock Tank

ground

92

65

1

92



Spetsnaz

infantry

90

71

2

180



Raptor

air

88

66

2

176



Strikepoint Robot

ground

82

47

1

82



Viking Incursion Craft

air

80

56

2

160



Naval Marine

infantry

76

63

2

152



Heavy Cannon

ground

73

54

1

73



Fox Fighter

ground

72

62

2

144



Tyrant UAV

air

70

88

1

70



J-20 Fighter

air

70

58

1

70



Bomb Technician

infantry

55

64

1

55



Gladiator Anti-Air Tank

ground

48

52

1

48



Fast Attack Craft

sea

44

36

2

88



Liason

infantry

40

97

2

80



IRA Fighter

infantry

39

21

2

78



Super Cobra

air

36

30

2

72



MARSOC

infantry

32

20

5

160



Outlander

ground

31

26

1

31



Pirate Gunner

infantry

30

19

2

60



Desert Attack Robot

ground

29

18

2

58



MK5 Landing Craft

sea

28

102

1

28



Rocket Truck

ground

28

19

2

56



Abrams M1 Tank

ground

27

26

1

27



Raider Attack Boat

sea

27

22

1

27



Nyla APC

ground

25

23

5

125



Gatling Tank

ground

24

26

2

48



Blaster Cannon

ground

23

17

1

23



GIGN

infantry

22

19

25

550



Chemical Weapon Specialist

infantry

21

13

30

630



Rapid-Fire Attack Vehicle

ground

20

18

30

600



Strike Eagle

air

19

11

15

285






Totals

158

5651



Remove 10 Strike Eagle

air

(10)


(10)

(190)







148

5461

[Maverick50727]

Valsta,
Sorry for the confusion and thanks to McDoc. I'm not in the forum every day checking threads. You can always reach me via PM easier as I check that more than threads.

Sometimes you can go crazy try to get the numbers to match. I have no idea why when you bought a harrier jet (A18, D14), you only received A16 and D14. It should have been A16/D12 you got since it was replacing a weak unit of 2A/2D it looks like. Probably a patrol boat, old battelship, compound soldier or rebel soldier (all have 2/2).

When you try to match numbers of your stats and other people remember some of this:
-your def may increase a the same time if you finish a base def upgrade as that is added to your alliance def
-not all changes are immediate!!! I personally have seen units lost in my news feed take 2-3 hours before they reflected in my stats. Normally it should update if you close and restart and it connects to the server.
-boost upgrades count on cash units only
-the game is dynamic so as you attack/raid or someone hits you you may lose or gain units that may not be immediately reflected.

Look at trampstamp's spreadsheet and choose units with low consumption rates, use high end valor units only (better consumption rates, stay away from GIGN IMO). Also get units with strong against if possible. Choose wisely, for instance a harrier (18A/14D)stinks IMO 360K for Meidum .01206 consumption rate vs VTOL (17A/22D) 640K for Low .0335 CR. A hornet is 36A/26D with .003 CR.

I myself quit doing mission for now because the units required to complete cost too much and then I end up taking them into battle. I try to keep my unit type list small (under 45) so I can see them all when I attack and know exactly which units I use. If not you have to make a big spreadsheet and do some sorting. Most people are surprised to find out their lowest unit since on the top 45 are displayed until they lose one in battle. Use your ally count to manage your units taken into battle if you can to reduce taking in you defense units like sea scouts, etc. Doing so you may see greater results. I'll send you a Private Message also.

[Maverick50727]

[QUOTE=Hello Kitty;161046]Below are my own stats to illustrate how Attack is calculated, Defense uses similar calculations....
QUOTE]

WOW Kitty. Someone else tracks their stuff. You must be an accountant. LOL
Yeah it gets harders and harder to compute these days with the boost buildings and the higher you go with higher unit counts.

For Alliance Defense it is the same execpt you add in the sum of your base defense structure values.

[Bronson]

Welcome Valsta, you got two good members there in McDoc and Mav answering those questions so stick to what they say and you won't go wrong. Also if you ever need a spreadsheet speak to Kitty!

Just a point on what Mav said keep an eye on consumption rate, I personally would never buy Lvl 10 infantry (demolitions) as they will be lost constantly.

Here is a list of consumptions, the closer to 0 the less they will be lost

https://docs.google.com/spreadsheet/lv?key=0AgjEOMAMom92dFhOellvbTAwQ0dvZGJfYk9EQjMxRn c

Also if you click on the thread in my signature Digitalwalker has listed all the units that have "strong against" properties that come in helpfull when defending an attack or raid.

[Hello Kitty]

WOW Kitty. Someone else tracks their stuff. You must be an accountant. LOL
Yeah it gets harders and harder to compute these days with the boost buildings and the higher you go with higher unit counts.

For Alliance Defense it is the same execpt you add in the sum of your base defense structure values.Love my bean counter friends, but no, I'm an engineer by discipline. I've built a calculator and you're correct, the difficulty is making sure the unit list is current (new LEs, crates, events...) and ensuring the actual inventory of units are accurate the higher you go with either ally or level or both. The building and country boosts are just factors that change, so that's the easy part.

Correct on Defense, similar calculations, but takes into account boost from Composites Factory, Defense Skills, Defense Buildings.

[Bronson]

I need to get me some spreadsheets but it's so hard to do. Will have to keep ripping off others info and work it out in my head.

[Agent Orange]

Or the devs have now split the attack and defense stats so that your attack total is made up of only your strongest Attacking units while the defense stat is made up of your strongest defensive units. That would account for zero attack added but most of the defense since you probably had units with higher attack values factored in.

[Hello Kitty]

Or the devs have now split the attack and defense stats so that your attack total is made up of only your strongest Attacking units while the defense stat is made up of your strongest defensive units. That would account for zero attack added but most of the defense since you probably had units with higher attack values factored in.

According to my analysis, yes, the Attack and Defense scores are separate values based on strongest allowed attacking units for attack and strongest allowed defense units for defense. The Defense is calculated a little differently because of the available variables. Here are the formulas for both should anyone want to analyze their Units allowed into battle and know how your lowest unit into battle is being displaced:

Allowable # Units Available to Battle:

Max Allies to battle = Level x 5,
Allowable # units available to battle = Max Allies to battle x 4 Units/Ally

If Actual Allies < Max Allies,
Allowable # units available to battle = Actual Allies to battle x 4 Units/Ally

Attack Score =

Truncated([Sum of attack values from available Air units] x [% Boost from Airship Hangar] x [10% Boost, if Russia])
+
Truncated([Sum of attack values from available Sea units] x [% Boost from Naval Research Center] x [10% Boost, if UK])
+
Truncated([Sum of attack values from available Ground units] x [% Boost from Electronics Factory] x [10% Boost, if Germany])
+
Truncated([Sum of attack values from available Infantry units] x [% Boost from Genetics Lab] x [10% Boost, if China])
+
Attack Skills points1


Defense Score =

Truncated([Sum of defense values from available Air units] x [% Boost Composites Factory] x [10% Boost, if Russia])
+
Truncated([Sum of defense values from available Sea units] x [% Boost Composites Factory] x [10% Boost, if UK])
+
Truncated([Sum of defense values from available Ground units] x [% Boost Composites Factory] x [10% Boost, if Germany])
+
Truncated([Sum of defense values from available Infantry units] x [% Boost Composites Factory] x [10% Boost, if China])
+
[Sum of defense values of all Defense Buildings]
+
Defense Skills points1
+
n-factor x [Sum of built in defense for all Buildings]2

Assumptions:

1It is assumed that Attack and Defense Skill Points (SP) are not only values added to the overall A/D scores, but perhaps also used in some other algorithm as a factor that gets applied to the A/D actually used in battle. This assumption remains unconfirmed.

2Every building (unit, money, defense, and boost) has some inherent value of defense assigned to that building and that value increases for each upgrade. There is some unknown factor that is applied to the sum of all the inherent defense assigned to each building. Without knowing what the defense values are per building, it's difficult to reverse engineer this portion of the equation. This assumption remains unconfirmed.

Each of these assumptions add a margin of error when calculating these values, but using the general forumlas gets one pretty close in the ballpark of actual Attack and Defense stats for planning purposes.

Info from support:

Support has confirmed that unit-boost buildings only apply to Attack; however, forum members are indicating the game is behaving otherwise (unit boost applies to both Attack and Defense scores).

Question: "[...]boost buildings - do they affect only attack or both attack and defense (i.e. electronics factory, hangar airship, genetics lab, naval research buildings)?

Response from support on 7/15/2012: "The unit-specific ones are attack only."

Country boosts are also confirmed by support as follows:

Question: "For the countries with boosts, does it apply to both attack and defense or one or the other?"

Response from support on 7/12/2012: "The country boosts do apply to attack and defense, both."

[StuN]

Oh my HK, that's seriously in depth

[Poopenshire]

she is good

[Powell UK in USA]

OK
I have read many posts on the math behind units.
From what I think I understand the lower value units get moved down your list as you buy better units. OK.
However !
Why if I buy a unit would my A/D score go down ?
This has been the case for me so many times I try to find units that I like for ex "Frigates" I've built up good cash for unit purchase say 5 Mil and tapped away until I'm broke thinking I should see a great move upwards in A/D but only to find nothing and even a loss of A/D.
"Your better units are being used" you say !
WRONG I was down to hardly any at all. (lost from constant battle)
To second my point and a far worse experience is getting huge valour earnings for BP rank climb and to see it do nothing after buying all expensive units and later on buy some junk and see a positive result.

The same thing goes for Allies I accept more and then in return I get to watch my A/D take another dive.

What am I missing here

[manbeast]

i have never figured that out. a couple weeks ago i noticed the same thing when buying snipers. every sniper i got caused my atk to go down by 1..

[JohnnyR]

I'm 99% sure this has to do with boosts.

The attack stat on your units determine placement. If a unit is lower in initial stat, but higher in boost, it might be possible that a unit less boosted but higher initial stat to push it out. There might be some loot units you're pushing out MB, I can't think of any Sea, Air, or Ground units your snipers are pushing out....

On the flipside, I think this fact might be tried successfully to keep certain other defense units from reaching battle if thought out well enough.

[Q Raider]

Apart from one oddity of the Fox Fighter appearing before the Panzer Artillery in my excel sheet I have a match for every other positions in the visible top 45 as follows.

Take the stat of the unit and apply the country bonus as applicable.

Sort this stat DEFENCE wise first highest to lowest and number them from top to bottom in another column.
Then resort by ATTACK stat highest to lowest and repeat the numbering process in a separate column.
I then do a multi sort with Attack first and Defence second and it comes up with the list in the correct position apart from the oddity mentioned above (which could just be an alphabetical factor).