All 276 Unit Spreadsheet with all information. (Armor, Weapons, Skills, Etc.) For easy sorting and comparison.

[Yasashii Hito]

Nice, good ****! My head hurts just thinking about how long this must've took.

Haha, roughly 7 hours last night, and my numpad skills improved dramatically!

 

[Yasashii Hito]

Great job man. You will probably hate me even for asking ? but is there a way to extract/list the armours of the troops? Since all ppl have the same hp, armour (and equipment of course) seems to be the most important to me.

Unfortunately not, but I for one am going to write a suggestion, asking for a display of their different armor stats on all slots, head, chest, etc.
If they add that, I will for sure add it to my document!

 

[Yasashii Hito]

Bump

 

[MountainBladesMan]

Always felt units had weird equipment that wasn't very fitting. Why do legionaries and high-tier missile units wear the same armor cataphracts and lords do? Why does only one tier of Empire infantry have javalins? Why do Palatina archers wear lord helmets?

 

[Yasashii Hito]

Always felt units had weird equipment that wasn't very fitting. Why do legionaries and high-tier missile units wear the same armor cataphracts and lords do? Why does only one tier of Empire infantry have javalins? Why do Palatina archers wear lord helmets?

Hehe yeah, some of the equipment seems a bit off. I've also come across some weird combinations while comparing units to sort the rankings of each role.

 

[black_bulldog]

Wow really nice job, kudos to you sir.

 

[MountainBladesMan]

Hehe yeah, some of the equipment seems a bit off. I've also come across some weird combinations while comparing units to sort the rankings of each role.

I'm pretty sure there is some absurdly expensive armor in the game called 'legionary's armor' or something to protects better than lammenar. Make you wonder why they didn't go with that for the high-tier infantry.

 

[SkiFreeYeti]

Looks like a lot of mistakes were made. Pitiful stats for weapons among highest tier troops, no experience in the weapons they're equipped with...
Not that Fian Champions need any help but they certainly should have the proper sword instead of useless numbers allocated.

 

[Yasashii Hito]

Looks like a lot of mistakes were made. Pitiful stats for weapons among highest tier troops, no experience in the weapons they're equipped with...
Not that Fian Champions need any help but they certainly should have the proper sword instead of useless numbers allocated.

Yeah, I reported the mistakes I found, stats wise, which just didn't make any sense. On the Battanian Fian Champion, I'm not sure if they're supposed to switch One Handed and Two Handed skills, or if they're supposed to have a Two Handed Sword, like the earlier promotions.

 

[bantad87]

I tried opening it as a guest to see what you could see, and it was possible to sort by column, by right clicking it, or just using the arrow. The top 2/3 rows are just ignored when doing this.

Can you get it to work?

Edit: Ahh, I see. You can change it here:
Change the A1 to an A4, it changes the row where the sorting starts.

Sorry, I think I misspoke earlier. Not sort by column, I meant allow user to apply filters to the spreadsheet. For example, when I play Sturgia, I only want to see Sturgian units.

 

[missionAvs]

This is amazing work OP.

 

[Yasashii Hito]

Sorry, I think I misspoke earlier. Not sort by column, I meant allow user to apply filters to the spreadsheet. For example, when I play Sturgia, I only want to see Sturgian units.

Ohh, I see what you mean. You can sort first by skill, and then by nationality. Or just by nationality at first, doesn't that solve what you need?
Otherwise I can make tabs of each nations units, while also having the one with all of them.

 

[Yasashii Hito]

bump

 

[Tuco]

Thanks for the spreadsheet.

Is there a reason that exporting/saving the document is disabled?

 

[Yasashii Hito]

Thanks for the spreadsheet.

Is there a reason that exporting/saving the document is disabled?

No, that's a mistake, I just found it and changed it.

 

[Tuco]

Yeah, I think so too, but as the numbers aren't available, I would have to go for visual recognition of the different parts, and I don't trust my judgement on that one. If they will implement a way of showing it, I will add it for sure.

You might know this already but all the armor / stats are listed in

\Mount & Blade II Bannerlord\Modules\SandBoxCore\ModuleData\spnpccharacters.xml

The Imperial Menavliaton, for example, has these stats/equipment:

  <NPCCharacter id="imperial_menavliaton"
                default_group="Infantry"
                level="21"
                civilianTemplate="NPCCharacter.empire_troop_civilian_template_t2"
                name="{=e8qbF7Ey}Imperial Menavliaton"
                occupation="Soldier"
                culture="Culture.empire">
    <face>
      <face_key_template value="NPCCharacter.villager_empire" />
    </face>
    <skills>
      <skill id="Athletics"
             value="100" />
      <skill id="Riding"
             value="15" />
      <skill id="OneHanded"
             value="100" />
      <skill id="TwoHanded"
             value="60" />
      <skill id="Polearm"
             value="100" />
      <skill id="Bow"
             value="45" />
      <skill id="Crossbow"
             value="45" />
      <skill id="Throwing"
             value="60" />
    </skills>
    <equipmentSet>
      <equipment slot="Item1"
                 id="Item.empire_sword_4_t4" />
      <equipment slot="Item0"
                 id="Item.empire_polearm_1_t4" />
      <equipment slot="Body"
                 id="Item.imperial_mail_over_leather" />
      <equipment slot="Gloves"
                 id="Item.mail_mitten" />
      <equipment slot="Leg"
                 id="Item.leather_cavalier_boots" />
      <equipment slot="Head"
                 id="Item.imperial_nasal_helm" />
      <equipment slot="Cape"
                 id="Item.empire_warrior_padded_armor_shoulder" />
    </equipmentSet>
    <equipmentSet>
      <equipment slot="Item1"
                 id="Item.empire_sword_4_t4" />
      <equipment slot="Item0"
                 id="Item.empire_polearm_1_t4" />
      <equipment slot="Body"
                 id="Item.imperial_mail_over_leather" />
      <equipment slot="Leg"
                 id="Item.leather_cavalier_boots" />
      <equipment slot="Gloves"
                 id="Item.mail_mitten" />
      <equipment slot="Head"
                 id="Item.imperial_nasal_helm" />
    </equipmentSet>
    <equipmentSet>
      <equipment slot="Item1"
                 id="Item.empire_sword_4_t4" />
      <equipment slot="Item0"
                 id="Item.empire_polearm_1_t4" />
      <equipment slot="Body"
                 id="Item.imperial_mail_over_leather" />
      <equipment slot="Leg"
                 id="Item.leather_cavalier_boots" />
      <equipment slot="Head"
                 id="Item.imperial_nasal_helm" />
      <equipment slot="Cape"
                 id="Item.empire_warrior_padded_armor_shoulder" />
      <equipment slot="Gloves"
                 id="Item.mail_mitten" />
    </equipmentSet>
    <upgrade_targets>
      <upgrade_target id="NPCCharacter.imperial_elite_menavliaton" />
    </upgrade_targets>
  </NPCCharacter>

Might be worth looking for which NPCs have really powerful weapons.

 

[2mLi]

Thanks for the spreadsheet! Are you happy for me to provide a translated version of the spreadsheet on Chinese M&B forums? Will definitely mention this original threat and authorship.

 

[masarius]

Amazing!

 

[Yasashii Hito]

You might know this already but all the armor / stats are listed in

\Mount & Blade II Bannerlord\Modules\SandBoxCore\ModuleData\spnpccharacters.xml

The Imperial Menavliaton, for example, has these stats/equipment:

  <NPCCharacter id="imperial_menavliaton"
                default_group="Infantry"
                level="21"
                civilianTemplate="NPCCharacter.empire_troop_civilian_template_t2"
                name="{=e8qbF7Ey}Imperial Menavliaton"
                occupation="Soldier"
                culture="Culture.empire">
    <face>
      <face_key_template value="NPCCharacter.villager_empire" />
    </face>
    <skills>
      <skill id="Athletics"
             value="100" />
      <skill id="Riding"
             value="15" />
      <skill id="OneHanded"
             value="100" />
      <skill id="TwoHanded"
             value="60" />
      <skill id="Polearm"
             value="100" />
      <skill id="Bow"
             value="45" />
      <skill id="Crossbow"
             value="45" />
      <skill id="Throwing"
             value="60" />
    </skills>
    <equipmentSet>
      <equipment slot="Item1"
                 id="Item.empire_sword_4_t4" />
      <equipment slot="Item0"
                 id="Item.empire_polearm_1_t4" />
      <equipment slot="Body"
                 id="Item.imperial_mail_over_leather" />
      <equipment slot="Gloves"
                 id="Item.mail_mitten" />
      <equipment slot="Leg"
                 id="Item.leather_cavalier_boots" />
      <equipment slot="Head"
                 id="Item.imperial_nasal_helm" />
      <equipment slot="Cape"
                 id="Item.empire_warrior_padded_armor_shoulder" />
    </equipmentSet>
    <equipmentSet>
      <equipment slot="Item1"
                 id="Item.empire_sword_4_t4" />
      <equipment slot="Item0"
                 id="Item.empire_polearm_1_t4" />
      <equipment slot="Body"
                 id="Item.imperial_mail_over_leather" />
      <equipment slot="Leg"
                 id="Item.leather_cavalier_boots" />
      <equipment slot="Gloves"
                 id="Item.mail_mitten" />
      <equipment slot="Head"
                 id="Item.imperial_nasal_helm" />
    </equipmentSet>
    <equipmentSet>
      <equipment slot="Item1"
                 id="Item.empire_sword_4_t4" />
      <equipment slot="Item0"
                 id="Item.empire_polearm_1_t4" />
      <equipment slot="Body"
                 id="Item.imperial_mail_over_leather" />
      <equipment slot="Leg"
                 id="Item.leather_cavalier_boots" />
      <equipment slot="Head"
                 id="Item.imperial_nasal_helm" />
      <equipment slot="Cape"
                 id="Item.empire_warrior_padded_armor_shoulder" />
      <equipment slot="Gloves"
                 id="Item.mail_mitten" />
    </equipmentSet>
    <upgrade_targets>
      <upgrade_target id="NPCCharacter.imperial_elite_menavliaton" />
    </upgrade_targets>
  </NPCCharacter>

Might be worth looking for which NPCs have really powerful weapons.

I had no idea, I tried looking for it, but not thoroughly. I will be looking into it right after I finish playing EU4 with my mate!

 

[Yasashii Hito]

Thanks for the spreadsheet! Are you happy for me to provide a translated version of the spreadsheet on Chinese M&B forums? Will definitely mention this original threat and authorship.

Ofc! Please do, I want it to be available for all, but I plan on looking into adding the armor values if I can find them later tonight. If you want to wait until after, or something, please be my guest.