| The One Ring http://one-ring.co.uk/ |
|
| MESBG army building spreadsheet http://one-ring.co.uk/viewtopic.php?f=42&t=22221 |
Page 8 of 28 |
| Author: | adragonsfang [ Sat Jan 07, 2017 12:21 pm ] |
| Post subject: | Re: SBG army building spreadsheet Hobbit Trilogy update |
Absolutley Love your army builder, thanks for the update for the new lists and profiles. Something I noticed is that Yazneg in the Azog's Hunters list is at his old points value of 50 when he is now 45. EDIT: Also I may be doing it wrong but when I have Bolg, the hunter orcs don't update to say they have Morgul Arrows with their Many Blades special rule. EDIT2: Seems like bow limit is being calculated incorrectly on Fiefdoms, Looks liek the dead are being counted as bows and the Black root vale guys not. Gloin COE is also incorrectly pointed |
|
| Author: | GothmogtheWerewolf [ Sat Jan 07, 2017 1:37 pm ] |
| Post subject: | Re: SBG army building spreadsheet Hobbit Trilogy update |
Hi, for some reason when you try to add 2 War Bats to a warband that has 1 Ogre, it says 2 Gundabad Ogres and 1 War Bat for some reason. Otherwise, it's amazing. |
|
| Author: | LonelyKnight [ Sat Jan 07, 2017 11:45 pm ] |
| Post subject: | Re: SBG army building spreadsheet Hobbit Trilogy update |
huh, I missed that about Bolg thing Corrected Yazned and that fiefdoms thing.. somehow I forgot to set their bow limit when I redid the formulas. Guess I jumped them somehow, that what you get when you are second  The error you found was more widespread Gothmog, Warband 1 was broken in every single army list. Gonna upload the update now Cheers Also removed the notes to myself that I had forgotten to erase previously. |
|
| Author: | Terentius [ Wed Jan 11, 2017 12:59 am ] |
| Post subject: | Re: SBG army building spreadsheet Hobbit Trilogy update |
Thank you so much for updating this. Here are a few bugs I've noticed with version 1.71: -When you click on the Army of Lake-town and Garrison of Dale links in the main index, an error message pops up saying the reference is invalid -If you select the Signal Tower as an upgrade for Azog, it gives his warband as 7/24, presumably including Azog's Lieutenants as part of his warband. However, the book explicitly states that the Lieutenants are NOT counted as part of Azog's warband. Thanks again and keep up the great work! |
|
| Author: | LonelyKnight [ Wed Jan 11, 2017 2:51 pm ] |
| Post subject: | Re: SBG army building spreadsheet Hobbit Trilogy update |
Huh, silly miss on my part Fixed, Cheers |
|
| Author: | Luizasso [ Thu Jan 12, 2017 12:46 pm ] |
| Post subject: | Re: SBG army building spreadsheet Hobbit Trilogy update |
Moria and Isengard points total are a bit off. It looks like the warband number for the heroes is being added on the final result. And from Army of Thror, Young Dwalin's profile is missing, he appears as a Woses Warrior on the printable army list. Everything else seems fine. Edit: On the moria and isengard lists, the points total is summing the column with the warbands number. |
|
| Author: | LonelyKnight [ Fri Jan 13, 2017 11:28 am ] |
| Post subject: | Re: SBG army building spreadsheet Hobbit Trilogy update |
Forgot to copy the new formulas to those two, and... Well... Yound Dwalin is there, I just called him "Young Dwalin the Dwarf" in the profiles list.. which makes it impossible for the spreadsheet to find it -.- schmart! Cheers, Fixed |
|
| Author: | Terentius [ Tue Jan 17, 2017 4:22 pm ] |
| Post subject: | Re: SBG army building spreadsheet Hobbit Trilogy update |
Thank you for the updates. I've noticed a couple things. Alfrid the Councilor is missing from the Survivors of Lake-town list. Also, the Iron Hills bow limit calculator doesn't work properly. It seems to think every warrior option is carrying a missile weapon. That's all for now, and thanks again! |
|
| Author: | Jey [ Wed Jan 18, 2017 8:32 pm ] |
| Post subject: | Re: SBG army building spreadsheet Hobbit Trilogy update |
Awesome work! Two little things: -in the Iron Hills List, if you give crossbows to dwarves, they seem to not count against the bow limit. -Mordor List: If you give a generic Ringwraith extra Might / Will / Fate it is only displayed in the middle column of the spreadsheet if you buy max 1 point each. If you buy 2 or more, it's not showing up. |
|
| Author: | LonelyKnight [ Thu Jan 19, 2017 3:26 pm ] |
| Post subject: | Re: SBG army building spreadsheet Hobbit Trilogy update |
Cheers, fixed Missed that [word deleted] in the survivors list |
|
| Author: | Terentius [ Thu Jan 19, 2017 6:50 pm ] |
| Post subject: | Re: SBG army building spreadsheet Hobbit Trilogy update |
Thank you! |
|
| Author: | yggdrasil [ Sun Jan 22, 2017 8:26 am ] |
| Post subject: | Re: SBG army building spreadsheet Hobbit Trilogy update |
First off I want to thank you for this fantastic tool you're providing to the community. As for bug reports: In the Lothlorien and Mirkwood list, I'm getting the message that regular Haldir (not Defender) can't lead troops. That is, his warband is at 0/0, when I choose him has the leader. |
|
| Author: | LonelyKnight [ Tue Jan 24, 2017 12:59 am ] |
| Post subject: | Re: SBG army building spreadsheet Hobbit Trilogy update |
Huh, had the same mistake in the erebor reclaimed list Cheers, fixed |
|
| Author: | Michaelc [ Tue Jan 24, 2017 2:22 am ] |
| Post subject: | Re: SBG army building spreadsheet Hobbit Trilogy update |
Big thank you for doing this, I've been using your file for years now. However this version seems a bit buggy at the moment. Haven't used it too much yet but a couple of things I've noticed: In all(?) lists there seems to be a problem with assigning *multiple* troop types to the *first* warband. Usually the highest (towards the top) troop selected will display correctly but lower troops won't correctly display. For example under Moria add 3 Giant Spiders to the first warband - it correctly displays 3 giant spiders. Now add 3 Dwellers - it shows 3 dwellers but now [blank] giant spiders. Warband 2+ seem to be working fine. In the fiefdom's list Armoured Horse are counting towards the bow limit. |
|
| Author: | LonelyKnight [ Tue Jan 24, 2017 9:09 pm ] |
| Post subject: | Re: SBG army building spreadsheet Hobbit Trilogy update |
I redid all the formulas for the army lists, hence why the file went from 3MB to 2MB, hence all the bugs. Quite often the bug is just Minas Tirith's formulas being applied to everything else (aka: I failed to correct them for that list -.-) These appear to be bugs that were already reported earlier, the 1st warband thing was reported by Gothmog, don't remember who pointed out the fiefdoms bow limit error, but the same error was present in other lists. Hopefully the whack-a-mole is nearly done, re-doing the formulas has this problem, but it makes it easier to update in the future. Sorry about the mess :/ |
|
| Author: | infinateremains [ Wed Jan 25, 2017 1:07 pm ] |
| Post subject: | Re: SBG army building spreadsheet Hobbit Trilogy update |
Things I saw when using the new one; 1. The Gundabad Ogre shows both versions of Relentless Advance, the Ogre's and the goblin king's, in the special rules section. 2. The Catapult Troll comes up with two versions of the area of effect rule in the special rules section. 3. Selecting Beorn from the Radagast alliance list does not bring up an entry on the army list selection. 4. The white council selection doesn't seem to work correctly and Gandalf comes up as a "-" Thank you for all the work you put in to make our lives easier! |
|
| Author: | billyboyd [ Wed Jan 25, 2017 3:34 pm ] |
| Post subject: | Re: SBG army building spreadsheet Hobbit Trilogy update |
Thank you for this awesome tool!! It really is an amazing spreadsheet. I can't imagine the time it takes you to build and maintain the whole thing. I feel like my words fall far short of the praise you deserve. I noticed that on the Wanderers in the Wild sheet, Thrain the Broken's points don't get added to the army's points at the top of the sheet. It counts him as a unit but still says 0 points. |
|
| Author: | Valadorn [ Thu Jan 26, 2017 10:06 am ] |
| Post subject: | Re: SBG army building spreadsheet Hobbit Trilogy update |
A huge smile came into my face when I saw this is still updated. Horns up for the LonelyKnight once more...! |
|
| Author: | LonelyKnight [ Fri Jan 27, 2017 1:28 am ] |
| Post subject: | Re: SBG army building spreadsheet Hobbit Trilogy update |
1&2.. the dreaded same name different rules situation  3, I have no clue where that error came from, formula pointing in the wrong direction in the army lists sheet 4, umm guess I must have broken this when I deleted some entries. I didn't actually redo the formulas for the "heroes only" army lists. Gandalf's points were using Celeborn's selection apparently. Should prolly redo those as well eventually. Forgot to extend the sum to include thrain's points -.- Cheers, fixed |
|
| Author: | Michaelc [ Sat Jan 28, 2017 1:03 am ] |
| Post subject: | Re: SBG army building spreadsheet Hobbit Trilogy update |
LonelyKnight wrote: Sorry about the mess :/ No need to apologize - very grateful you're giving your time to make building an army easier for the rest of us. |
|
| Page 8 of 28 | All times are UTC |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|