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

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

Author:  Manadar [ Sun Oct 28, 2018 1:46 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

Rivendell Knight should not count against bow limit with Elrond played.

Author:  LonelyKnight [ Sun Oct 28, 2018 2:39 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

Cheers, missed that line in his profile.
Will upload later along with some profiles working for the good side printable army lists.

EDIT: uploaded, fully working up to and including Minas Tirith
Will do all the factions in the book that is out already, will most likely wait for the hobbit book to do those since the profiles currently available are... well, rules aren't even marked as passive or active so I'm guessing there might be some changes.

Author:  LonelyKnight [ Mon Oct 29, 2018 8:10 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

New version up, had forgotten to update the filters so it was prolly a bit screwy
Profiles are there up to and including Rohan.

EDIT: All good profiles from LotR are done

Author:  Dwarves4thewin! [ Fri Nov 09, 2018 5:39 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

I'm very happy with the work you do, but I see some error when I place orcs in a warband in the Isengard list, the numbers are doubled somehow.
Found something else: the spear options for the Bo'Sun is not pointed out correctly (not sure if I may say the correct pointcost for it in this forum....)
And the 'crossbow' is considered to be a horse in the text box of the warbands..

Author:  LonelyKnight [ Fri Nov 09, 2018 11:09 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

The Orc error was funnily enough a mistake in formulas that was on every sheet, it's just no one else had warriors going all the way down there besides Isengard so no one else was reaching the spot that the mistake affected.
I legit have no idea how the formula for the corsair heroes gear changed, it's in column CW and they are the same in every sheet. Copied from another one over it.
Cheers for the finds, will upload in a bit

Author:  LonelyKnight [ Mon Nov 19, 2018 10:31 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

Added the two Wardens

Author:  Jey [ Wed Nov 21, 2018 8:55 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

Just noticed that Eowyn's equipment point cost is not calculated correctly. There seems to be a mistake with the formula (armour is not checked).

Thanks for the great work, been using this for years!

Author:  LonelyKnight [ Fri Nov 23, 2018 4:18 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

Cheers, it's been updated.
The usual copy paste fail.

Author:  LonelyKnight [ Sun Nov 25, 2018 12:16 am ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

Just pre-ordered the Hobbit Book, hopefully they remembered to put the Castellans and Spiders in there.
Thanks to the people that donated on paypal, it covered the book ^-^.

Author:  adragonsfang [ Wed Nov 28, 2018 9:39 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

Not sure if you want feedback on Hobbit book issues yet, but Bard's wargear options don't add up in either the Army or Survivors of Laketown lists.

Edit: Also Sigrid & Tilda should take up 2 Warband slots in the spreadsheet.

Author:  BrentS [ Thu Nov 29, 2018 1:02 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

Well met old friends! I’m excited to come back to Middle Earth.

I was working on a few “new” army lists using my old models and was happy to see that the Lonely Knights army builder is still being updated!

I found a couple small bugs (at least I think they are both bugs)

1) when adding Radagast the roster page populates as Prince Imrahil
2) for Rohan, the roster page shows that the Riders of Rohan as Strength 4 (instead of 3). Unless I am misreading the rules, they only get the strength imp when they charge and it’s not a base profile change.

Thanks!

Author:  LonelyKnight [ Thu Nov 29, 2018 6:22 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

I don't have the Hobbit book with me yet so it's prolly best to wait on those until I get it. Guessing I'll have to change a few things.

Radagast is as expected for now, he's not in there yet since his profile isn't in the LotR book.
The Rider of Rohan thing... copy paste can have some unintended side effects

Will upload in a bit, need to go ask something unrelated in the rules forum

Author:  jlmb_123 [ Thu Dec 06, 2018 3:30 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

Hello LK (and others)! First-time TOR poster here. I've been using your rad MESBG army builder and noticed that in V1.17b everything in the Corsair list returns Cave Trolls in the Forces of Evil spreadsheet. I haven't had a chance to dig around and see where the sheet's referencing, I'm afraid.

Author:  LonelyKnight [ Fri Dec 07, 2018 3:16 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

That's expected atm, good side for LOTR is almost 100% (not updated for the FAQ yet)
Evil side for LOTR I stopped midway through Mordor, so everything beyond that is not working yet.

Profiles for the Hobbit are all missing.
Hopefully after today's delivery I'll have more time to finish copying the profiles

Author:  LonelyKnight [ Mon Dec 10, 2018 8:49 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

Added Irolas, the FAQ stuff and corrected some hobbit related stuff.
List of Army Lists with missing profiles is under the links to the printable army lists.

Author:  LonelyKnight [ Tue Dec 18, 2018 11:29 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

All profiles from the LotR book should be in.
Changed the formulas so that if a profile isn't in yet it just doesn't appear, instead of having weird ones show up. If any selection from an army list that isn't on the list of missing ones doesn't show up in the printable army lists, that's a bug.
Hopefully I'll have everything copied by christmas, finally have a decent amount of free time.

Author:  LonelyKnight [ Mon Dec 24, 2018 12:48 am ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

Skipped the special rules for now (those take a while to copy) and put in all the profiles. Guessing peeps find those a bit more important.
Also fixed some formulas in the printable part, forgot to reset some when I changed them.
Should be fully working, just missing the text for the special rules in the Hobbit army lists.

Merry Christmas

Author:  Spike314 [ Sat Dec 29, 2018 5:47 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

There is still an issue with the warriors not showing up on the evil printable list.

Author:  LonelyKnight [ Mon Dec 31, 2018 12:32 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

which warriors?
Tried with random stuff in barad-dûr and goblin town and they both showed up so I'm guessing it's a specific one

Author:  Spike314 [ Mon Dec 31, 2018 8:50 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

Warg riders and Morannon Orcs in Mordor

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