The One Ring
http://www.one-ring.co.uk/

MESBG army building spreadsheet
http://www.one-ring.co.uk/viewtopic.php?f=42&t=22221
Page 9 of 28

Author:  adragonsfang [ Fri Feb 03, 2017 7:22 pm ]
Post subject:  Re: SBG army building spreadsheet Hobbit Trilogy update

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.

Author:  LonelyKnight [ Sat Feb 04, 2017 1:52 am ]
Post subject:  Re: SBG army building spreadsheet Hobbit Trilogy update

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 :P), 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

Author:  infinateremains [ Fri Feb 10, 2017 4:27 pm ]
Post subject:  Re: SBG army building spreadsheet Hobbit Trilogy update

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.

Author:  LonelyKnight [ Sat Feb 11, 2017 11:53 pm ]
Post subject:  Re: SBG army building spreadsheet Hobbit Trilogy update

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 :P

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

Cheers, gonna upload

Author:  Terentius [ Thu Mar 02, 2017 7:08 pm ]
Post subject:  Re: SBG army building spreadsheet Hobbit Trilogy update

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.

Author:  LonelyKnight [ Thu Mar 02, 2017 8:31 pm ]
Post subject:  Re: SBG army building spreadsheet Hobbit Trilogy update

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

Author:  LonelyKnight [ Sat Mar 04, 2017 4:37 pm ]
Post subject:  Re: SBG army building spreadsheet Hobbit Trilogy update

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

Author:  infinateremains [ Mon Mar 06, 2017 8:45 am ]
Post subject:  Re: SBG army building spreadsheet Hobbit Trilogy update

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.

Author:  LonelyKnight [ Mon Mar 06, 2017 4:50 pm ]
Post subject:  Re: SBG army building spreadsheet Hobbit Trilogy update

Cheers, fixed

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

Author:  GothmogtheWerewolf [ Mon Mar 06, 2017 11:58 pm ]
Post subject:  Re: SBG army building spreadsheet Hobbit Trilogy update

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.

Author:  LonelyKnight [ Tue Mar 07, 2017 12:36 am ]
Post subject:  Re: SBG army building spreadsheet Hobbit Trilogy update

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

Author:  infinateremains [ Tue Mar 07, 2017 11:31 am ]
Post subject:  Re: SBG army building spreadsheet Hobbit Trilogy update

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.

Author:  LonelyKnight [ Tue Mar 07, 2017 11:57 am ]
Post subject:  Re: SBG army building spreadsheet Hobbit Trilogy update

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 :D
Will reupload once I'm done fixing that
Cheers

Author:  adragonsfang [ Tue Jun 27, 2017 6:47 pm ]
Post subject:  Re: SBG army building spreadsheet Hobbit Trilogy update

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.

Author:  LonelyKnight [ Wed Jun 28, 2017 1:43 pm ]
Post subject:  Re: SBG army building spreadsheet Hobbit Trilogy update

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

Author:  LonelyKnight [ Sat Jul 15, 2017 3:05 pm ]
Post subject:  Re: SBG army building spreadsheet Hobbit Trilogy update

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

Author:  turwaitheon [ Sat Jul 15, 2017 5:03 pm ]
Post subject:  Re: SBG army building spreadsheet Hobbit Trilogy update

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!

Author:  GothmogtheWerewolf [ Tue Jul 18, 2017 9:01 pm ]
Post subject:  Re: SBG army building spreadsheet Hobbit Trilogy update

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.

Author:  LonelyKnight [ Thu Jul 20, 2017 9:49 am ]
Post subject:  Re: SBG army building spreadsheet Hobbit Trilogy update

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

Author:  infinateremains [ Wed Jul 26, 2017 11:04 am ]
Post subject:  Re: SBG army building spreadsheet Hobbit Trilogy update

I noticed that Gandalf the grey in the shire doesn't have the cart upgrade.
Also equipping Glorfindel with his heavy armour doesn't change his defence on the army list.
On Rivendell the font colour on the upgraded warriors need to be moved as the knights are currently displayed in red.
Arnor has a lot of space between warrior equipment and unit quantity.
Think that's it for now, keep up the great work! thank you for all your effort.

Page 9 of 28 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/