All times are UTC


It is currently Wed Nov 27, 2024 5:56 pm



Post new topic Reply to topic  [ 564 posts ]  Go to page Previous  1 ... 23, 24, 25, 26, 27, 28, 29  Next
Author Message
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Fri Feb 03, 2023 8:44 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
Bilbo Baggins in Rivendell wasn't even being sent to the Forces of Good, you could say he was invisible.
For both... well I changed what I had previously (had Bilbo Baggins, Bilbo Baggins (Old), changed to Bilbo Baggins (TC), Bilbo Baggins) and forgot to change in those two sheets.

Rivendell army bonus was a bit of a derp :oops:. It's called "Tangado haid, leithio i philinn!" [] in the listed rules, but I wrote it without the " in the place that links it to Rivendell, so it wasn't adding it.

For the Helm thing, I had forgotten to add a Profile line for when he's on a horse.


CJSBG wrote:
Hiya, just a suggestion for list building- Could you put in a column C perhaps the heroics that the heroes have? It's an important part of list building and would be really convenient to not need to check back to the books. I know that the heroics appear in the end page which is handy for printing off with the army list but could they also appear in the faction pages to help with choosing heroes in the first place please? Best wishes and happy holidays :)

Problem is mostly the space. Some have a lot of heroic actions. Could present a bunch of acronyms like HDef, HStk, HStr, HRsv, HChan, HMrc,
HAcc, HChlg but some heroes would still need a lot of space.
Could look into making them appear when you select the hero's name.

For the Witch King, the armoured Horse is a horse with armour by itself, not an adding of armour to the horse, if you select both he doesn't show up, if you select either it seems to work.

For the printing, is it happening with printing to A4?
The cell sizes are sized to make it fit in A4, if it's letter you want just print to pdf in A4 and then when you physically print tell it to fit and it'll handle the scaling.
If it's happening with A4 then I'm not sure what's happening, looks fine on my end.


Sorry again for the delay. I just popped in today cause stumbled upon a MESBG youtuber who didn't know about the spreadsheet and figured I'd tell him about it and popped by, might have not come by until the next release otherwise thinking no errors were found :( .
If I don't reply for more than a week it is prolly safe to assume I'm not being notified again, try sending a pm, that'll prolly notify me. (I may have a busy week at work but at least on weekends I'll check my emails)

Gonna go upload now
Cheers guys

_________________
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: Mon Feb 06, 2023 8:02 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
Updated for the 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: Tue Feb 07, 2023 12:04 pm 
Wayfarer
Wayfarer
Offline

Joined: Sun Mar 01, 2020 4:51 am
Posts: 10
If I use the signal tower for Azog the model count doesn't include his seven lieutenants which are added on top, so his warband total ends up being 31+him.
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Tue Feb 07, 2023 7:46 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
I got the email notification ^-^.
Will go look into that

_________________
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: Tue Feb 07, 2023 8:01 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
Ok so they are not actually part of his warband, they are deployed on the signal tower before any other models.
They are however still models that are part of the army so they should have been added to the unit count.
Gonna go upload that fix now.

_________________
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: Tue Feb 28, 2023 2:24 pm 
Wayfarer
Wayfarer
User avatar
Offline

Joined: Sat Nov 03, 2012 10:28 am
Posts: 32
The Wild Warg Chieftain does not show up in the stats when selected as part of Angmar or the Assault on Lothlórien LL.
Neither does the Wild Warg.

_________________
Windy
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Thu Mar 02, 2023 8:07 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
Was an issue due to them having Warg in the name.
Fixed now.

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: Tue Mar 07, 2023 12:55 pm 
Wayfarer
Wayfarer
Offline

Joined: Tue Mar 07, 2023 12:47 pm
Posts: 6
Hey, I have noticed an issue with Tauriel's cost in the Rangers of Mirkwood LL. She is showing as 85 points and without a bow but she is forced to be 90 points with a Bow,

Thank you
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Wed Mar 08, 2023 10:31 am 
Wayfarer
Wayfarer
Offline

Joined: Sun Mar 01, 2020 4:51 am
Posts: 10
Bain needs to be an Independent Hero in the Army of Lake Town list please :)
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Fri Mar 10, 2023 8:19 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
Fixed the Tauriel issue

Bain is a Minor Hero in the Armies of the Hobbit Book, and the FAQ doesn't mention him. Is he put as Independent somewhere?

_________________
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: Mon Mar 13, 2023 2:45 pm 
Wayfarer
Wayfarer
Offline

Joined: Tue Mar 07, 2023 12:47 pm
Posts: 6
LonelyKnight wrote:
Fixed the Tauriel issue

Bain is a Minor Hero in the Armies of the Hobbit Book, and the FAQ doesn't mention him. Is he put as Independent somewhere?



He is independent if taken as part of Army of lake town, this is mentioned where it shows the army composition.

Jake
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Mon Mar 27, 2023 11:11 am 
Wayfarer
Wayfarer
User avatar
Offline

Joined: Sat Nov 03, 2012 10:28 am
Posts: 32
When adding bows to a Far Harad list they do not appear in the stats sheet.
They are listed in the army composition but nowhere else.
Also on the main selection page the warbands columns remain pink regardless of what heroes are selected.

Regards Windy

_________________
Windy
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Wed Mar 29, 2023 11:25 am 
Wayfarer
Wayfarer
Offline

Joined: Tue Mar 07, 2023 12:47 pm
Posts: 6
Hey,
ive noticed an issue when creating a Beorning LL.
I add the axe dudes to the warband, but when I try adding the bows, they don't appear in the army list.

if I remove the axe dudes, then the bows appear. strange.
Jake
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Thu Mar 30, 2023 8:33 am 
Wayfarer
Wayfarer
Offline

Joined: Thu Mar 30, 2023 8:27 am
Posts: 3
Hi. Thank you so much for creating this army builder!

I've built a Radagast's Alliance list and encountered two issues. If I select Radagast on a Sleigh then his magical powers do not show up in the print out section (they do if I select him on an Eagle). And Nature's Wrath has a range of 3" and I think it should be 6".
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Sat Apr 01, 2023 1:25 pm 
Elven Warrior
Elven Warrior
User avatar
Offline

Joined: Thu Feb 20, 2014 2:39 pm
Posts: 967
Location: The Old Dominion
While I cannot speak to the program itself, I can say the Nature's Wrath range of 3" correct, going by GW's FAQ and the 1.5 version of the rules. The Middle Earth team lowered the range about a year after the book came out to make the spell less of a central focus of the armies that could use it. Same with Wrath of Bruinen.

_________________
"Draw your sword with a heavy heart, but swing it with a heavy hand"
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Mon Apr 03, 2023 8:07 pm 
Wayfarer
Wayfarer
Offline

Joined: Thu Mar 30, 2023 8:27 am
Posts: 3
Thanks. I got my rulebook in the Pellenor boxed set.
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Thu Apr 06, 2023 7:15 pm 
Wayfarer
Wayfarer
Offline

Joined: Tue Mar 07, 2023 12:47 pm
Posts: 6
jakethesnake555 wrote:
Hey,
ive noticed an issue when creating a Beorning LL.
I add the axe dudes to the warband, but when I try adding the bows, they don't appear in the army list.

if I remove the axe dudes, then the bows appear. strange.
Jake


It looks like there is only one line on the right hand side formulas for 1 loadout type of unit, so not one for bows, then one for axes.

jake
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Tue May 02, 2023 1:24 pm 
Wayfarer
Wayfarer
Offline

Joined: Thu Mar 30, 2023 8:27 am
Posts: 3
--- deleted as irrelevant LonelyKnight released a fix at lightspeed ---


Last edited by bddbrown on Mon May 08, 2023 4:37 pm, edited 1 time in total.
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Thu May 04, 2023 6:47 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
Wasn't getting the notifications again, thanks to the peeps who DMd (still took a while to get notified of that but at least I did)
Gonna go check the posts now

_________________
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 May 04, 2023 7:18 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
jakethesnake555 wrote:
He is independent if taken as part of Army of lake town, this is mentioned where it shows the army composition.

Nice, funny how I got the part about his Dad right but somehow missed him

g.pavely@sky.com wrote:
When adding bows to a Far Harad list they do not appear in the stats sheet.
They are listed in the army composition but nowhere else.
Also on the main selection page the warbands columns remain pink regardless of what heroes are selected.
Same thing was happening in Harad, it had to do with having "poisoned" and me forgetting to add a 1. somewhere.

The Haradrim can only be added on the Mûmak War Leader's Howdah within that list (Gondor at War). Turn white for me in the column that I put that guy in.

jakethesnake555 wrote:
ive noticed an issue when creating a Beorning LL.
I add the axe dudes to the warband, but when I try adding the bows, they don't appear in the army list.

You found a funny bug, I have no idea which other spreadsheet I reused for this, prolly the eagles one. Whichever it was, they only had the ability to add 1 warrior type and I clearly forgot to change for this one.
Should have based it on the Drúadan folks.

bddbrown wrote:
I've built a Radagast's Alliance list and encountered two issues. If I select Radagast on a Sleigh then his magical powers do not show up in the print out section (they do if I select him on an Eagle).

Implemented the fix you mentioned in the PM

Will go upload now, Cheers guys

_________________
Tired of building armies with pen and paper? Try this handy spreadsheet for SBG. Download it here
Top
  Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 564 posts ]  Go to page Previous  1 ... 23, 24, 25, 26, 27, 28, 29  Next

All times are UTC


Who is online

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