MESBG army building spreadsheet

Tungdil · **Posted:** Fri Jan 16, 2015 8:46 am

Thank you so much, Sir !

I actively share your website with everyone locally playing the game, so they can experience the awesomeness of the army builder for themselves

GothmogtheWerewolf · **Posted:** Wed Feb 25, 2015 6:28 pm

Well, I've said it before and I'll say it again, amazing work and very helpful.

However, when building an army recently I noticed that for some reason the Venomblade Knights and Castellans of Umbar do not have the Terror rule in your profile despite the fact that, being Black Numenoreans, they should still have them.

Also, should you not have the option for them in the Mordor list too?

LonelyKnight · **Posted:** Wed Feb 25, 2015 8:00 pm

Cheers, fixed the missing Terror
Looked them up, the upgrades are only listed in the Fallen Realms sourcebook, the Mordor profile doesn't have them

dchobbitleague · **Posted:** Sat Feb 28, 2015 1:15 pm

Lonely Knight

We have posted your Army Builder on our DCHL library and linked it to your website! You have done a fantastic job for the community! Keep it up!

DCHL

LonelyKnight · **Posted:** Sat Feb 28, 2015 3:21 pm

Spiffy
I can create a link to dl the file that never changes if you want to hotlink to the file itself.
Not very relevant these days since it rarely changes

Tungdil · **Posted:** Mon Mar 02, 2015 9:46 am

There seems to be an issue when you try to upgrade the Isengard Uruk-Hai Shaman with Armour, as he does not get the +1 to his Defence.

LonelyKnight · **Posted:** Mon Mar 02, 2015 2:48 pm

Cheers, had the wrong value in the upgraded profile, fixed.

thomas · **Joined:** Sun Jul 20, 2014 2:38 am **Posts:** 20

I added the witch king of Angmar with 3 extra might 9 extra will and 3 extra fate points but in the printed sheets it still appeared only with 0-10-0. (though in the wargear/upgrades list it shows the upgrades)

LonelyKnight · **Posted:** Thu Apr 30, 2015 2:23 am

crud I totally forgot about that, while most profiles have separate lines for each variation, those two (WK and basic ringwraith) are supposed to "feed" on the input cells
should go sleep now, I'll fix it tomorrow

EDIT: fixed

thomas · **Joined:** Sun Jul 20, 2014 2:38 am **Posts:** 20

Thanks a lot. Your program is MARVELOUS. Thanks again

Tungdil · **Posted:** Tue Jun 02, 2015 9:39 pm

Hello again!

There seems to be something wrong with the latest file, as when I select Gil-Galad from the Eregion and Rinvendell list, he is costed correctly, but appear as Ghân-buri-Ghân on the Forces of Good summary

Also, not sure if it is intentional, but these heroes have wargear that is selected by default:
Elrond (Eregion and Rivendell)
Thranduil, King of Mirkwood (Lothlorien and Mirkwood)

That was all for now, thanks

LordElrond · **Posted:** Tue Jun 02, 2015 10:11 pm

Elrond and Thranduil have default wargear becuase the Free People's Elrond is essentially the same profile as the hobbit one, but with heavy armour always purchased. The same with Thranduil, who has armour and a bow in the free people's, but only as optional extras in the desolation of smaug.

LonelyKnight · **Posted:** Tue Jun 02, 2015 10:43 pm

Odd, I see gil-galad in the print sheet when I dl the 1.61 version :S
And yeah the pre-selection is as LordElrond explained

Tungdil · **Posted:** Wed Jun 03, 2015 6:06 am

Hm, for some reason the file I had must have been corrupted or something..
When I download the file again now, and open in Excel (not OpenOffice Calc), everything is fine.

Sorry for the disturbance

LonelyKnight · **Posted:** Thu Aug 06, 2015 5:46 pm

Well, somewhat relevant update pointed out by Sacrilege83. Siege weapons were leaving an extra crewman in there.

throxor · **Joined:** Mon Aug 24, 2015 7:50 am **Posts:** 2

First up - great work on the spreadsheet, it's invaluable to me and my friends.

A couple of things I've noticed in v1.62

The White Council
The ranges to calculate units (T1) and points (U1) are incorrect

Easter Kingdoms
There appears to be an issue with the bow limit calculation. I get a #DIV/0! error when I add any Easterling Warriors with bow

LonelyKnight · **Posted:** Tue Oct 06, 2015 4:56 pm

well, fixed the errors I think, but I was quite confused about the Eastern Kingdoms special rule until I went looking in the FAQs.
Gonna go upload it now
Cheers

Tungdil · **Posted:** Fri Feb 19, 2016 8:59 pm

It seems like when I equip the old Legolas with a horse and armour, it shows up that he also have Orcrist in his Wargear.
Atleast when I select him in the 1.63 (newest) version of the builder.
Does not matter if it is the Lothlorien and Mirkwood, The Fellowship or White Council version.

Surely this is an error?

LonelyKnight · **Posted:** Sat Feb 20, 2016 7:12 pm

Huh, you just uncovered a structural formula bug in the equipment section.
Funny stuff, surprised it wasn't found earlier.
Gonna upload now

rumtap · **Posted:** Mon Feb 22, 2016 2:21 am

I just noticed in the Fiefdoms list that Blackroot vale archers are not being picked up by the bow limit. They seems to be counted as regular troops.

Thanks for all your work on this.

MESBG army building spreadsheet

Who is online