All times are UTC


It is currently Thu Nov 28, 2024 8:25 pm



Post new topic Reply to topic  [ 564 posts ]  Go to page Previous  1 ... 5, 6, 7, 8, 9, 10, 11 ... 29  Next
Author Message
 Post subject: Re: SBG army building spreadsheet Hobbit Trilogy update
PostPosted: Sat Jan 07, 2017 12:21 pm 
Wayfarer
Wayfarer
Offline

Joined: Fri Dec 23, 2011 6:37 pm
Posts: 25
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


Last edited by adragonsfang on Sat Jan 07, 2017 9:38 pm, edited 2 times in total.
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet Hobbit Trilogy update
PostPosted: Sat Jan 07, 2017 1:37 pm 
Elven Elder
Elven Elder
User avatar
Offline

Joined: Thu Jun 23, 2011 3:04 pm
Posts: 6308
Location: Wandering around looking for Middle-earth
Images: 58
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.

_________________
"I am the Flying Spagetti Monster. Thou shall have no other monsters before me"
-FSM.
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet Hobbit Trilogy update
PostPosted: Sat Jan 07, 2017 11:45 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
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 :P

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.

_________________
Tired of building armies with pen and paper? Try this handy spreadsheet for SBG. Download it here
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet Hobbit Trilogy update
PostPosted: Wed Jan 11, 2017 12:59 am 
Wayfarer
Wayfarer
Offline

Joined: Mon May 02, 2016 7:35 pm
Posts: 29
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!
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet Hobbit Trilogy update
PostPosted: Wed Jan 11, 2017 2:51 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
Huh, silly miss on my part
Fixed,
Cheers

_________________
Tired of building armies with pen and paper? Try this handy spreadsheet for SBG. Download it here
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet Hobbit Trilogy update
PostPosted: Thu Jan 12, 2017 12:46 pm 
Wayfarer
Wayfarer
Offline

Joined: Thu Apr 07, 2016 4:40 pm
Posts: 20
Location: Brazil
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.
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet Hobbit Trilogy update
PostPosted: Fri Jan 13, 2017 11:28 am 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
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

_________________
Tired of building armies with pen and paper? Try this handy spreadsheet for SBG. Download it here
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet Hobbit Trilogy update
PostPosted: Tue Jan 17, 2017 4:22 pm 
Wayfarer
Wayfarer
Offline

Joined: Mon May 02, 2016 7:35 pm
Posts: 29
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!
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet Hobbit Trilogy update
PostPosted: Wed Jan 18, 2017 8:32 pm 
Wayfarer
Wayfarer
Offline

Joined: Wed Mar 16, 2016 10:34 am
Posts: 3
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.
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet Hobbit Trilogy update
PostPosted: Thu Jan 19, 2017 3:26 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
Cheers, fixed
Missed that [word deleted] in the survivors list

_________________
Tired of building armies with pen and paper? Try this handy spreadsheet for SBG. Download it here
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet Hobbit Trilogy update
PostPosted: Thu Jan 19, 2017 6:50 pm 
Wayfarer
Wayfarer
Offline

Joined: Mon May 02, 2016 7:35 pm
Posts: 29
Thank you!
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet Hobbit Trilogy update
PostPosted: Sun Jan 22, 2017 8:26 am 
Wayfarer
Wayfarer
User avatar
Offline

Joined: Tue Nov 12, 2013 11:40 pm
Posts: 18
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.
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet Hobbit Trilogy update
PostPosted: Tue Jan 24, 2017 12:59 am 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
Huh, had the same mistake in the erebor reclaimed list

Cheers, fixed

_________________
Tired of building armies with pen and paper? Try this handy spreadsheet for SBG. Download it here
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet Hobbit Trilogy update
PostPosted: Tue Jan 24, 2017 2:22 am 
Kinsman
Kinsman
Offline

Joined: Wed Jun 11, 2014 4:59 pm
Posts: 58
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.
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet Hobbit Trilogy update
PostPosted: Tue Jan 24, 2017 9:09 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
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 :/

_________________
Tired of building armies with pen and paper? Try this handy spreadsheet for SBG. Download it here
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet Hobbit Trilogy update
PostPosted: Wed Jan 25, 2017 1:07 pm 
Kinsman
Kinsman
User avatar
Offline

Joined: Sun Jul 26, 2015 3:23 pm
Posts: 180
Location: United Kingdom
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!
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet Hobbit Trilogy update
PostPosted: Wed Jan 25, 2017 3:34 pm 
Wayfarer
Wayfarer
User avatar
Offline

Joined: Mon Apr 27, 2015 1:35 pm
Posts: 10
Location: Minnesota USA
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.
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet Hobbit Trilogy update
PostPosted: Thu Jan 26, 2017 10:06 am 
Elven Warrior
Elven Warrior
User avatar
Offline

Joined: Mon Mar 10, 2014 10:02 pm
Posts: 659
Location: Greece
A huge smile came into my face when I saw this is still updated.
Horns up for the LonelyKnight once more...!

_________________
Conversation/Ideas over painting etc, can check here:
http://www.one-ring.co.uk/viewtopic.php?f=50&t=29455
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet Hobbit Trilogy update
PostPosted: Fri Jan 27, 2017 1:28 am 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
1&2.. the dreaded same name different rules situation :D
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

_________________
Tired of building armies with pen and paper? Try this handy spreadsheet for SBG. Download it here
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet Hobbit Trilogy update
PostPosted: Sat Jan 28, 2017 1:03 am 
Kinsman
Kinsman
Offline

Joined: Wed Jun 11, 2014 4:59 pm
Posts: 58
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.
Top
  Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 564 posts ]  Go to page Previous  1 ... 5, 6, 7, 8, 9, 10, 11 ... 29  Next

All times are UTC


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to: