ups, always a bit messy with siege engines
The whole point of this thread is for peeps to find the mistakes

Cheers, fixed

_________________
Tired of building armies with pen and paper? Try this handy spreadsheet for SBG. Download it here

Hi there, thanks so much for this amazing spreadsheet by the way!

Just a couple of things I noticed whilst creating armies, for Dunland it seems "Dunlendin Horsemen" don't show up in the army list once you create the force, I think it's due to the term "horse" within the name breaks one of the vlookups.

Also when you select Lurtz within an isengard army, Woodland Creature is selected and kicks off his regular find the hobbit special ability (or whatever it's called).

Hi LonelyKnight,

amazing work with the spreadsheet. Thank you so much for all the time and effort you put in to it.

I spotted a small hiccup in the Dragon host Legendary Legion, I believe. From what I understand, the free upgrade for Easterling Warriors to Black Dragons is available to all warriors who have a Easterling Dragon Knight as a hero. Unfortunately, if you give the Dragon knight an armoured horse, that upgrade is removed from the sheet, when I believe it should remain. Although, it's highly probable that I misread the Legiondary Legion.

Thanks for all the awesome work you do and feel free to ridicule me, if I'm incorrect about my assumption.

Cheers!

Same issue as in the Defenders of Erebor, copied over the formulas from there.

Fixed, gonna go upload now, cheers.

_________________
Tired of building armies with pen and paper? Try this handy spreadsheet for SBG. Download it here

It looks like I'm getting the same problem. Also, thank you so much for this project, it is so incredibly useful! I'll have to send money again

When selecting Muzgúr, Orc Shaman in either a Mordor or an Assault on Lothlórien list, it shows Magical Powers & Heroic Actions for Orc Shaman is this an error?

_________________
Windy

Tis an error indeed, he was finding "Orc Shaman" within "Muzgúr, Orc Shaman".
Cheers, fixed it but I wanted to check the other issue before uploading


Problems with the Easterling points costs in the Legendary Legion?
With the version that's currently online I can't find issues in that particular one.

_________________
Tired of building armies with pen and paper? Try this handy spreadsheet for SBG. Download it here

I will re-download the file and try again. Yes, it was the easterlings. Thank you so much for making this! You are a legend

Here's what I get, first step, adding a dragon knight (no horse yet) and 1 black dragon warrior to warband 2. He costs 7 points. (Screenshot is Image 3 in this folder: https://drive.google.com/drive/u/0/fold ... XdoulwgtWv )
When I add the horse, it changes to 9.
(Image 4 in the same folder.)
This doesn't seem to happen if the black dragon is in Warband 1. Hmm. (Image 5 shows both.)

My version of the file with the above warbands is also in the same folder for your perusal.

Rohan Captains are pointed too highly on the spreadsheet for Theodred's Guard. They should be 45 points each but they're currently listed as 55.

Must have copied from Eomer's Riders
Gonna upload with that and the previous fix, not sure what the other issue was.
Cheers

_________________
Tired of building armies with pen and paper? Try this handy spreadsheet for SBG. Download it here

I forgot to drag a formula, CB83 had the right one, so it was working for warband 1, but I then forgot to drag it for the other 19 , was failing to replicate cause I was testing with warband 1
Will go upload the fixed version, cheers

_________________
Tired of building armies with pen and paper? Try this handy spreadsheet for SBG. Download it here

Thank you! You rock sir

Found an issue in Army of Thror list. When giving a Warrior of Erebor a War Horn, Banner or Shield & Spear they do not show up in the Forces of Good page. When giving them either a Spear or Shield (Not Both) works fine.

Regards Windy

_________________
Windy

formulas weren't catching Warriors of Erebor past the 2nd one
Should be fixed
Cheers!

_________________
Tired of building armies with pen and paper? Try this handy spreadsheet for SBG. Download it here

Found something else....

When selecting a hero in the Cirith Ungol LL it adds special rules for Shelob

I really do appreciate the amount of work that you have put into this fantastic resource.

List building with this is very easy and saves a lot of time.

Regards Windy

_________________
Windy

They were being added just because they were rules from the LL.
Since they aren't relevant unless you add Shelob in, I added a condition to only add them if that's the case.
Cheers

_________________
Tired of building armies with pen and paper? Try this handy spreadsheet for SBG. Download it here

When selecting Dunlending Horsemen in either an Isengard list, or a Dunland LL list, the profile doesn't seem to appear on the army list. I assume it something to do with the keyword "horse" in the name throwing off the formula

You assume correctly.
I have changed the Dunlending Horsemen profile entries to fix it.
Cheers!

_________________
Tired of building armies with pen and paper? Try this handy spreadsheet for SBG. Download it here

Hi LK,

Noticed an issue with the Rangers of Ithilien. When adding rangers of gondor to anborn and mablungs warband they count against the bow limit when they should not.

Cheers