MESBG army building spreadsheet

Natas234 · **Joined:** Thu Jan 03, 2019 5:23 pm **Posts:** 5

Great job, thx! I notice that neither suladan nor cave troll profiles (in every army) appear in the profiles tables

LonelyKnight · **Posted:** Sun Feb 03, 2019 10:03 pm

They seem to be appearing for me.
Any specific selection that's causing it?

Sorry for the delay.

Currently adding in the Gondor at War profiles, and the Legendary Legions.

Natas234 · **Joined:** Thu Jan 03, 2019 5:23 pm **Posts:** 5

I checked, and noticed that it doesn't appear when played with goulavhar. Soulandan IDK.

Thx

Natas234 · **Joined:** Thu Jan 03, 2019 5:23 pm **Posts:** 5

for the troll issue: I checked again in other armys and I noticed that the troll never seems to appear when played in the first warband

LonelyKnight · **Posted:** Sat Feb 09, 2019 1:01 am

Seems to work on my end, no idea why it doesn't show for you.

New version with Gondor at War is up

Natas234 · **Joined:** Thu Jan 03, 2019 5:23 pm **Posts:** 5

Hello. I discovered the troll issue: when played in the first warband and equipped with the chain, it doesn't show up in the profiles table.

Thx 4 gondor!

LonelyKnight · **Posted:** Mon Feb 11, 2019 5:46 pm

oh right wargear combos change the id, will go try suladan combos as well to see if the error pops up

EDIT: Aye, the horse makes him vanish

EDIT 2: fixed, cheers ^-^

Manadar · **Joined:** Fri Apr 13, 2012 4:22 pm **Posts:** 180

There is something funky happening when adding the second Dragon Knight (Easterling), it is adding at the same time points from the captain below. I have figured it's tied to some error in columns "DO" to "EJ" but I can't understand what's their purpose sorry.

LonelyKnight · **Posted:** Tue Feb 12, 2019 3:37 pm

The error was actually in column S, it was pointing at DO +1 instead of at the same line after that second dragon knight

DO to EJ are actually quite simple to explain (well the basic function is simple to explain). Look at the numbers above (1-20), each column in DP to EI changes by 1 if they detect that the guy in that line had the number in his column in his warbands.
Or in practical terms, write 1 3 in the warbands of a guy, then go to this section and you'll see that for the columns with 1 (DP) and 3 (DR) at the top it'll change from 1 to 2 after the line of that guy.
These keys are then used to populate DE using the LOOKUP function (that part is a bit more complex with the INDEX use and all).

EJ is a helper for the 1 (DP) column, since 1 can be found in 10-19 this helper cleans out those instances so that DP can find lone 1s, so it looks just like column R minus 10-19

DO is just a tally of how many times that hero was selected, sum of next line - sum of this line and you see how many times the +1 occurred, or in other words, in how many warbands it was selected. DN multiplies by 1 + extras (elladan and elrohir has 1 extra for example) and you get the full number of models.

Will upload a bit later, copying some of the missing special rules text from the hobbit armies.

EDIT: Updated

Scarten3 · **Joined:** Wed Feb 13, 2019 2:31 pm **Posts:** 6

Thanks for updating the builder with the Legendary Legions so fast!

Warriors of Minas Tirith have the cost of their War horn and Banner switched. This error also occurs in the "Rangers of Ithilien" Legendary Legion and in the "Men of the West" Legendary Legion. In the latter the error occurs for all available Warrior models.

Manadar · **Joined:** Fri Apr 13, 2012 4:22 pm **Posts:** 180

Oh I see, that's quite clever how you manage to get this done.

LonelyKnight · **Posted:** Thu Feb 14, 2019 4:18 pm

Cheers, the two legendary legions had been copied from Minas Tirith, hence the repeat of the error.

BrentS · **Posted:** Wed Feb 27, 2019 4:28 am

I think I found a small error in the Théodens Host legendary legion. Elfhelm should cost 75 points and not 65.

LonelyKnight · **Posted:** Wed Feb 27, 2019 6:18 pm

Aye, forgot to add the horse cost to that one
Fixed, Cheers

praeternaturam · **Joined:** Sun Mar 03, 2019 12:07 pm **Posts:** 3

This is such a great resource and I am glad to see it has been updated for the new rules.

I am trying to include the Dwimmerlaik in an army list. I can select it, but then his profile does not appear on the Forces of Evil page - just on the first listing page.

LonelyKnight · **Posted:** Mon Mar 04, 2019 1:12 pm

Cheers, fixed.
Similar issue to the previously reported Suladan problem.

praeternaturam · **Joined:** Sun Mar 03, 2019 12:07 pm **Posts:** 3

Great - thank you!

praeternaturam · **Joined:** Sun Mar 03, 2019 12:07 pm **Posts:** 3

Tried to download the new version 1.31 and seems there is an Error (401) for Dropbox?

LonelyKnight · **Posted:** Mon Mar 11, 2019 10:58 am

The latest version is 1.32, your browser probably didn't refresh the website (and I deleted 1.31 from dropbox)

denbilicious · **Joined:** Tue Mar 26, 2019 11:25 am **Posts:** 1

I think you have the wrong points value for mirkwood elves, they should be 9 not 10?

MESBG army building spreadsheet

Who is online