All times are UTC


It is currently Mon Nov 11, 2024 12:21 am



Post new topic Reply to topic  [ 564 posts ]  Go to page Previous  1 ... 14, 15, 16, 17, 18, 19, 20 ... 29  Next
Author Message
 Post subject: Re: SBG army building spreadsheet ME SBG update
PostPosted: Thu Mar 28, 2019 3:33 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
seems like it
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 ME SBG update
PostPosted: Tue Jul 23, 2019 7:19 pm 
Wayfarer
Wayfarer
Offline

Joined: Fri Dec 23, 2011 6:37 pm
Posts: 25
On the Minas Tirith sheet the "King of Men" get red text when Gandalf the white is selected but not when Húrin the Tall, Warden of the Keys - Ingold, Warden of the Rammas Echor - Irolas, Captain of the Guard are selected. This should be the other way around since Gandalf does not have the keyword "Gondor" but the new models do.

On this note there are a lot of other named heroes on the good side that are in other lists that have the "Gondor" keyword so should also make the Kings red, these include Boromir in the fellowship and all the Fiefdom named Heroes.
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet ME SBG update
PostPosted: Fri Jul 26, 2019 1:49 am 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
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 ME SBG update
PostPosted: Fri Jul 26, 2019 7:41 am 
Kinsman
Kinsman
User avatar
Offline

Joined: Fri Apr 13, 2012 4:22 pm
Posts: 180
Gwaihir should be an hero of valour if taken from Radagast's Alliance.
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet ME SBG update
PostPosted: Sun Jul 28, 2019 2:19 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
fixed, wonder if the new shire book will have anything to add

_________________
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 ME SBG update
PostPosted: Sun Jul 28, 2019 9:38 pm 
Kinsman
Kinsman
User avatar
Offline

Joined: Fri Apr 13, 2012 4:22 pm
Posts: 180
There should be many new heroes to come for shire, sharkey's and angmar.
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet ME SBG update
PostPosted: Mon Jul 29, 2019 6:09 am 
Wayfarer
Wayfarer
Offline

Joined: Mon Aug 24, 2015 7:50 am
Posts: 2
In Sharkey's Rogues I am getting a #REF! error when I want add whips for the Ruffians.

I figure you'll be looking at the Sharkey's Rogues section shortly... #TrueWhiteWizard
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet ME SBG update
PostPosted: Mon Jul 29, 2019 12:54 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
must have dragged something in that sheet, 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: MESBG army building spreadsheet
PostPosted: Wed Aug 07, 2019 3:14 am 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
Updated for the Scouring of the Shire, along with the missing special rules for the hobbit evil armies (which I totally hadn't forgotten about) and the august FAQ

_________________
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: MESBG army building spreadsheet
PostPosted: Fri Aug 23, 2019 8:29 am 
Wayfarer
Wayfarer
Offline

Joined: Wed Feb 13, 2019 2:31 pm
Posts: 6
Just wanted to mention that you wrongly added Throwing Spears as an option to Deorwine in the Legendary Legion, the Errata was for Dernhelm.
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Sun Aug 25, 2019 4:23 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
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: MESBG army building spreadsheet
PostPosted: Thu Sep 26, 2019 9:26 am 
Wayfarer
Wayfarer
Offline

Joined: Sat Feb 14, 2015 4:37 pm
Posts: 1
A few things I found:
If you select a Named Captain of Rohan (Gamling, Erkenbrand,...) it will show the Heroic Actions of a generic Captain in the Printout.
Also, in a Rohan army in the Special Rules Section of the Printout, there is a bug where it shows the second half of the Ambush special rule - I tried to find out where this comes from but I got lost because the cells are all referencing each other ;-)

And lastly, the Ally status is green for Eorl + Deorwine, Elfhelm, Irolas, Hurin. You probably forgot to edit which cells are checked after you inserted the new heroes. I only noticed it in Rohan because it's my main army but this might be worth checking across every faction which had heroes added lately.
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Sun Sep 29, 2019 2:40 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
The Ambush special rule thing was due to a mistake in the formulas. or is in Horn of the Riddermark so it was acting like that was the title of a special rule that was present. Now it's checking the cell above to make sure that it's actually a title.

Yeah I tend to forget the extra checks when I add new heroes :|

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: MESBG army building spreadsheet
PostPosted: Thu Oct 10, 2019 2:00 pm 
Wayfarer
Wayfarer
Offline

Joined: Tue Oct 16, 2018 9:09 pm
Posts: 2
Do you know why I downloaded the spreadsheet and when I type any data in, it does not update?

For instance using the Return of the King Army if I enter a 1 for King of the Dead, it does not update units or points. Hoping its not something I did.
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Tue Oct 15, 2019 11:03 pm 
Kinsman
Kinsman
User avatar
Offline

Joined: Fri Apr 13, 2012 4:22 pm
Posts: 180
I think it's a bug targetting legendary legion, the sheet works fine wherever else.
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Wed Oct 16, 2019 4:52 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
ooooh, right.
I didn't add legion points to total points cause I figured it wasn't needed (can't ally and all), forgot that those total points are the ones that go on the printing sheet.

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: MESBG army building spreadsheet
PostPosted: Sun Nov 03, 2019 11:43 am 
Wayfarer
Wayfarer
Offline

Joined: Sun Nov 03, 2019 11:23 am
Posts: 2
Hello,
Big thanks to your work it's amazing!

juste noted that in the profil section of the printout, fief does not got the +1 courage when allying with MT.
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Wed Nov 06, 2019 6:25 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
Yeah the army rule for Minas Tirith only affects "Friendly Gondor models from this army 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: MESBG army building spreadsheet
PostPosted: Thu Nov 14, 2019 10:43 pm 
Loremaster
Loremaster
Offline

Joined: Sun Feb 21, 2010 6:48 pm
Posts: 1979
Location: Birmingham, UK
Images: 6
Thanks for all this work, LonelyKnight. I really do appreciate your army builder. :)

Just a couple of fixes for you...

Suladan's horse is free in the Grand Army of the South. Should be 15pts.

In the Shire list, the spreadsheet really doesn't like Gandalf's cart option.

_________________
"There are few left in Middle Earth like Aragorn, son of Arathorn." - Gandalf, Many Meetings
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Sat Nov 16, 2019 7:34 pm 
Kinsman
Kinsman
User avatar
Offline

Joined: Fri Apr 13, 2012 4:22 pm
Posts: 180
In Arnor, points for Arvedui and malbeth are switched.
Top
  Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 564 posts ]  Go to page Previous  1 ... 14, 15, 16, 17, 18, 19, 20 ... 29  Next

All times are UTC


Who is online

Users browsing this forum: No registered users and 15 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: