I think some tweaking needs to/should be done to the Dark Denizens of Mirkwood list.

Firstly as warriors don't need heroes to be taken it would be nice if the warbands were listed off as if a hero was present. At the moment it just provides a long list of the different warriors taken with no segregation of warbands.

Secondly it would be good to warn the user about the leader selection to make sure they have a hero in their army that can be the leader.

Thirdly, the troops have warband size limits. spiders must be taken atleast two to a warband and fell wargs atleast 6. or combined together or with bats and wargs must be taken in atleast 10.

Just suggestions though as this isn't necessarily a bug. Might be worth you going back over the army rules for this faction and coming up with something you think works.

That is an actual bug, I did do the formulas for all that stuff, I just killed it when I corrected another bug.
The army leader thing I'll leave to the user (same as don't take two aragorns ), but everything else you mentioned was already in there, but when I corrected the earlier error with the first warband I erased the special warband title formulas for this army list, hiding the headers that contain all the useful info about limits... yay -.-
Gonna reupload a fixed version now,
Cheers

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

Couple of new things I have noticed;
1. Thranduil's elk doesn't appear on the army list.
2. Thranduil's bladelord rule has some grammatical incorrectness.
3. Sigrid & Tilda appear as a hobbit sheriff on the army list.

huh, not sure what's happening with thranduil's elk, it's appearing for me.
Can you list the exact selection so I can check what odd wonkyness is going on?

add and extra attack

I giggled at the Sigrid & Tilda one
& instead of and made the lists fail

Cheers, gonna upload

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

Per the new FAQ for There and Back Again, you can now remove the Dol Guldur upgrades from the Mordor lists.

https://www.warhammer-community.com/2017/02/17/the-hobbit-motion-picture-trilogy-there-and-back-again-faq/

Also for some reason, maybe its just me, but the Index link is not working in the latest version.

Thanks again.

Huh, need to redo a few things
For one they say that the two white councils are separate
Need to check those special rules, and there's that dol guldur thing you mentioned
Will look over it tomorrow
Thx for the heads up

EDIT:
Almost done, just need to add a separate white council list
Not sure what's wrong with the links, they work fine in excel but they don't seem to work in libre office

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

Updated for the new FAQ
Hopefully I didn't break anything

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

I just tried it out with the necromancer on the mordor list and when I put 1 in the choices it add a spider queen so the selection equations seem out.

Cheers, fixed

Had missed the points formulas, forgot to redirect those to the new spots

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

Hi, sorry to bother you, but this is something I've only just noticed is a bug. I have often taken the Witch-king as part of an Angmar army and never been bothered by the fact that he shows up as 0/10/0 in M/W/F in the sheet no matter how much I give him. However, I was just selecting a Budget Wraith in a Mordor army and saw that is said 1/10/2 or whatever in the spreadsheet. I did a double take and quickly selected the Witch-king and put in 3 extra Will and sure enough, the spreadsheet said 0/13/0. So it seems that all this time I've been making sure to write down how much I've given him.
I apologise for the length of the anecdote and for bothering you with such a trivial matter on your amazing army builder, but I thought it worth a mention.

_________________
"I am the Flying Spagetti Monster. Thou shall have no other monsters before me"
-FSM.

holycow
that has got to be one of the oldest bugs in the spreadsheet, I just completely forgot about him in angmar XD
and I forgot to erase the dol guldur stuff from angmar...
Umm, I may have issues remembering angmar exists :3
I promise it has nothing to do with me being a Glorfindel fanboy

Gonna fix those two things and re-upload, cheers

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

Just a nit pick really but the format of some of the armies spreadsheets are different - to elaborate, the floating top bar with the upgrades doesn't work on some but works on others, I don't know if this is intentional and also the size of the font seems larger, when compared to previous iterations.

font is the same size, zoom may vary
Think I used to leave them all at 85% zoom
Changing them to 90% zoom

The top bar being unpinned
Yeah that was an oversight
They are meant to all be pinned, must have forgotten to do that when I redid the formulas

Nit picks are important
Will reupload once I'm done fixing that
Cheers

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

From what I understand from talking and reading on the facebook group, is that the iron hills chariot only counts as one model. so it only takes one warband slot and if a captain is taken then it only takes the captain slot and therefore no warband slots.

yeah they aren't terribly clear about the basic iron hill chariot, but they do say that the one with a captain is "a Hero" period so it makes sense for it to be that way.
Oddly enough I had it as a single unit in Erebor reclaimed.

Fixed
Cheers

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

Added a file for the Throne of Skulls additional rules in case anyone is interested

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

Some of the points aren't added to the faction total:

Like Bilbo's points aren't added if you add him in the Rivendell armylist, the number of total units goes up, but the points don't. This is also the case for the Knights of Rivendell.

It's the same for Gandalf the White in Minas Tirith; Hobbit Archers in arnor; Gandalf the Grey and Dunedain in the Shire. Only the unit count goes up, not the points for those models in those lists.

Except for that it's working fine!

_________________
You... will get... Coal!!!!!

I've tried creating army lists for Goblin Town and Angmar using the experimental rules I downloaded, but none of the units or warbands show up on the printable army list sheet at the back, only the profiles.

I'm glad and surprised that you have done these rules up though. Thank you.

_________________
"I am the Flying Spagetti Monster. Thou shall have no other monsters before me"
-FSM.

well Devlan Mud, forgot to drag down the points formulas
re-checked every army list and found some similar issue in the SBG file as well

the formulas in the printable part were off for those two due to all of the dragging
should be correct now

cheers

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