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 |
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 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/ |