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 13 of 28

Author:  Akuyi [ Sun Sep 30, 2018 5:24 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

Hey,

I found another bug:
The equipment for Moria Goblin Warriors is not added to their point costs.

Thanks!

Author:  Timo [ Sun Sep 30, 2018 8:31 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

Thx for this awesome builder!
Could you include the army bonus text for the factions?

Moria Goblin Captain Shields are 1p (should be 5)
Moria Goblin Captains have D4 (should be 5)
Gothmog has 3 Fate (should be 1)

Author:  Jashmyne [ Sun Sep 30, 2018 9:51 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

LonelyKnight wrote:
Fixed the independent guys issue, cheers.

The file is considerably larger than the previous one, think it's mostly cause of the extra space the formulas for the new hero interactions take. Could be smaller in most sheets but then you wouldn't have a one size fits all set of formulas.
Dunno why OpenOffice isn't opening it, there were quite a few people using it to use it, guess they'll have better feedback than me on that issue

Well I found another program called LibreOffice. It still complains that it's too big but atleast it will load it unlike OpenOffice.

Author:  LonelyKnight [ Mon Oct 01, 2018 1:00 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

Fixed the goblin equipment formulas.

The army bonuses that are built into army choices should already be implemented (like bow limit, warbands without heroes, extra warband capacity and stuff)
The profiles for the printable stuff aren't updated yet, the text of the army bonus will be added to the "Special Rules" page when that part is working. Might take a while to go through all that and update that part.

Not sure how much smaller the size could get to keep the one size fits all

Author:  Xintao [ Tue Oct 02, 2018 1:05 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

Did you ever think of splitting it to 2 spreadsheets? Evil and Good?

Author:  LonelyKnight [ Tue Oct 02, 2018 3:14 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

That would actually work, the formulas don't interact at all between them.
Dunno if some peeps would prefer to still have a version with both in them, guess I can keep all three up.

Author:  Grashnar [ Tue Oct 02, 2018 7:40 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

Some issues with the Thranduil's Halls list:

-Mirkwood Rangers count towards bow limit, even when led by the heroes that should allow them to take 100% bows
-Tauriel's bow only costs a single point, as opposed to five.

Author:  Marsh [ Wed Oct 03, 2018 2:22 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

in the Easterlings section:
Black Dragon Kataphracts are 14 points instead of 16
Easterling Captains pay 15 points for their armoured horse rather then 10

Author:  LonelyKnight [ Wed Oct 03, 2018 9:58 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

huh, I missed that army bonus, now it's even better:
Quote:
Army Bonus: Mirkwood Rangers from this force do not count towards the army’s Bow Limit. Additionally, whilst they are within 3” of Thranduil, all Palace Guard Captains, Mirkwood Elf Captains, Palace Guard, Mirkwood Cavalry and Mirkwood Elves will also gain +1 to their To Wound rolls when making Strikes.

Now they are flat-out 100% if the army bonus is there.

I'll upload tomorrow, apparently I've already burned a good chunk of the website traffic so I'll try moving the file itself somewhere else and link to that for download. (also wanna try to lower the full size and do the split so users can open it more easily)

Author:  LonelyKnight [ Fri Oct 05, 2018 8:57 am ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

fixed the thranduil and easterling stuff

changed it to dropbox, still haven't touched the size but that should keep the free website from colapsing

Author:  Terentius [ Mon Oct 08, 2018 11:30 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

Thank you again Lonely Knight for your fantastic army builder!

I did notice the Mumak War Leader is missing from Far Harad. His revised rules can be found here:

https://www.forgeworld.co.uk/resources/PDF/Downloads/War_Mumak_Leader.pdf

Author:  LonelyKnight [ Tue Oct 09, 2018 8:57 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

That mumâk looks awesome, wonder why they omitted him in the far harad army listing, I hadn't realized it had different rules.
Sooo
Gonna upload as soon as I fix this tiny weeny error where every single evil sheet has the total units and points of the good guys cause potato
EDIT: forgot to mention I'm adding the split good and evil versions

Author:  Coenus Scaldingus [ Wed Oct 10, 2018 4:02 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

The War Leader's rules were written after the book was finished (same with other upcoming releases - Húrin, Skully, etc.). Should all be in the upcoming expansion.

Author:  LonelyKnight [ Wed Oct 10, 2018 7:36 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

Húrin is coming?
I'd heard about skully (I cannot member his name, even though I already added him) but damn, are we finally getting silmarilion? Or is it a steward of Gondor?

Author:  Terentius [ Wed Oct 10, 2018 8:40 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

It’s Hurin the Tall, Warden of the Keys of Minas Tirith. Pictures of him and Ingold, Warden of the Rammas have already been released! The Silmarillion has never been licensed by the Tolkien Estate to anyone, film studio or otherwise

Author:  LonelyKnight [ Thu Oct 11, 2018 4:35 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

Awww, pity. Still new stuff is welcome (skull on head guy!), I don't keep up with the rules quite as much so if I haven't added something it's quite likely that I'm not aware it exists.

Will finally have some free time to start redoing the profile db for the printable part.
Still unsure if it's worth doing that or if I should just try to make a version that runs on a browser with simpler functionality.

Author:  KilljoyPowerhead [ Sun Oct 14, 2018 8:16 am ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

Don't know if it's just me, but since the change to the dropbox I get an error when I click the link and can't access the builder :/

Author:  LonelyKnight [ Sun Oct 14, 2018 11:38 am ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

odd, works for me

does this link work?
https://www.dropbox.com/s/tu4lbegeipl60 ... b.zip?dl=0
the one in the site is the direct link, this one sends to dropbox first

Author:  Grashnar [ Wed Oct 24, 2018 9:42 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

Couple of issues with Azog's Legion:

-Wargear for the Gundabad Orc Warriors (banners, shields, spears...) don't cost any points
-Azog's warband limit isn't increased to 24 when taking the signal tower
-Azog's name is spelled Azof :lol:

Author:  LonelyKnight [ Thu Oct 25, 2018 10:05 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

Everyone knows Azof, he's Azog's less charismatic cousin :oops:
Fixed those 3 things, and a weird fail on the formulas for the mid section

Also... umm you know the huge size of the file? Arnor, dunno why but that one was counting every single cell in the entire sheet as active, which made it take up an entire 2MB alone :|
Might be why some peeps were having trouble opening it as well.

New version is up, cheers

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