seems like it
fixed, cheers

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

On the Minas Tirith sheet the "King of Men" get red text when Gandalf the white is selected but not when Húrin the Tall, Warden of the Keys - Ingold, Warden of the Rammas Echor - Irolas, Captain of the Guard are selected. This should be the other way around since Gandalf does not have the keyword "Gondor" but the new models do.

On this note there are a lot of other named heroes on the good side that are in other lists that have the "Gondor" keyword so should also make the Kings red, these include Boromir in the fellowship and all the Fiefdom named Heroes.

cheers, fixed

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

Gwaihir should be an hero of valour if taken from Radagast's Alliance.

fixed, wonder if the new shire book will have anything to add

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

There should be many new heroes to come for shire, sharkey's and angmar.

In Sharkey's Rogues I am getting a #REF! error when I want add whips for the Ruffians.

I figure you'll be looking at the Sharkey's Rogues section shortly... #TrueWhiteWizard

must have dragged something in that sheet, fixed

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

Updated for the Scouring of the Shire, along with the missing special rules for the hobbit evil armies (which I totally hadn't forgotten about) and the august FAQ

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

Just wanted to mention that you wrongly added Throwing Spears as an option to Deorwine in the Legendary Legion, the Errata was for Dernhelm.

cheers, fixed

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

A few things I found:
If you select a Named Captain of Rohan (Gamling, Erkenbrand,...) it will show the Heroic Actions of a generic Captain in the Printout.
Also, in a Rohan army in the Special Rules Section of the Printout, there is a bug where it shows the second half of the Ambush special rule - I tried to find out where this comes from but I got lost because the cells are all referencing each other

And lastly, the Ally status is green for Eorl + Deorwine, Elfhelm, Irolas, Hurin. You probably forgot to edit which cells are checked after you inserted the new heroes. I only noticed it in Rohan because it's my main army but this might be worth checking across every faction which had heroes added lately.

The Ambush special rule thing was due to a mistake in the formulas. or is in Horn of the Riddermark so it was acting like that was the title of a special rule that was present. Now it's checking the cell above to make sure that it's actually a title.

Yeah I tend to forget the extra checks when I add new heroes :|

Cheers

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

Do you know why I downloaded the spreadsheet and when I type any data in, it does not update?

For instance using the Return of the King Army if I enter a 1 for King of the Dead, it does not update units or points. Hoping its not something I did.

I think it's a bug targetting legendary legion, the sheet works fine wherever else.

ooooh, right.
I didn't add legion points to total points cause I figured it wasn't needed (can't ally and all), forgot that those total points are the ones that go on the printing sheet.

Cheers, fixed

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

Hello,
Big thanks to your work it's amazing!

juste noted that in the profil section of the printout, fief does not got the +1 courage when allying with MT.

Yeah the army rule for Minas Tirith only affects "Friendly Gondor models from this army list"

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

Thanks for all this work, LonelyKnight. I really do appreciate your army builder.

Just a couple of fixes for you...

Suladan's horse is free in the Grand Army of the South. Should be 15pts.

In the Shire list, the spreadsheet really doesn't like Gandalf's cart option.

_________________
"There are few left in Middle Earth like Aragorn, son of Arathorn." - Gandalf, Many Meetings

In Arnor, points for Arvedui and malbeth are switched.