All times are UTC


It is currently Sun Nov 24, 2024 3:03 pm



Post new topic Reply to topic  [ 564 posts ]  Go to page Previous  1 ... 21, 22, 23, 24, 25, 26, 27 ... 29  Next
Author Message
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Wed Jun 22, 2022 3:56 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
ups, always a bit messy with siege engines
The whole point of this thread is for peeps to find the mistakes :P

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: Fri Jun 24, 2022 5:35 pm 
Wayfarer
Wayfarer
Offline

Joined: Fri Jun 24, 2022 5:29 pm
Posts: 2
Hi there, thanks so much for this amazing spreadsheet by the way!

Just a couple of things I noticed whilst creating armies, for Dunland it seems "Dunlendin Horsemen" don't show up in the army list once you create the force, I think it's due to the term "horse" within the name breaks one of the vlookups.

Also when you select Lurtz within an isengard army, Woodland Creature is selected and kicks off his regular find the hobbit special ability (or whatever it's called).
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Sat Jun 25, 2022 7:01 am 
Wayfarer
Wayfarer
Offline

Joined: Wed Aug 25, 2021 8:14 am
Posts: 5
Hi LonelyKnight,

amazing work with the spreadsheet. Thank you so much for all the time and effort you put in to it.

I spotted a small hiccup in the Dragon host Legendary Legion, I believe. From what I understand, the free upgrade for Easterling Warriors to Black Dragons is available to all warriors who have a Easterling Dragon Knight as a hero. Unfortunately, if you give the Dragon knight an armoured horse, that upgrade is removed from the sheet, when I believe it should remain. Although, it's highly probable that I misread the Legiondary Legion.

Thanks for all the awesome work you do and feel free to ridicule me, if I'm incorrect about my assumption.

Cheers!
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Sat Jun 25, 2022 4:05 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
Same issue as in the Defenders of Erebor, copied over the formulas from there.

Fixed, gonna go upload 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: Sun Jul 10, 2022 5:19 am 
Wayfarer
Wayfarer
Offline

Joined: Wed Jan 07, 2015 9:43 pm
Posts: 4
It looks like I'm getting the same problem. Also, thank you so much for this project, it is so incredibly useful! I'll have to send money again :P
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Sun Jul 10, 2022 3:42 pm 
Wayfarer
Wayfarer
User avatar
Offline

Joined: Sat Nov 03, 2012 10:28 am
Posts: 32
When selecting Muzgúr, Orc Shaman in either a Mordor or an Assault on Lothlórien list, it shows Magical Powers & Heroic Actions for Orc Shaman is this an error?

_________________
Windy
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Sun Jul 10, 2022 8:28 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
g.pavely@sky.com wrote:
When selecting Muzgúr, Orc Shaman in either a Mordor or an Assault on Lothlórien list, it shows Magical Powers & Heroic Actions for Orc Shaman is this an error?


Tis an error indeed, he was finding "Orc Shaman" within "Muzgúr, Orc Shaman".
Cheers, fixed it but I wanted to check the other issue before uploading

tlarsen20 wrote:
It looks like I'm getting the same problem.

Problems with the Easterling points costs in the Legendary Legion?
With the version that's currently online I can't find issues in that particular one.

_________________
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 Jul 11, 2022 4:40 am 
Wayfarer
Wayfarer
Offline

Joined: Wed Jan 07, 2015 9:43 pm
Posts: 4
I will re-download the file and try again. Yes, it was the easterlings. Thank you so much for making this! You are a legend
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Mon Jul 11, 2022 5:44 am 
Wayfarer
Wayfarer
Offline

Joined: Wed Jan 07, 2015 9:43 pm
Posts: 4
Here's what I get, first step, adding a dragon knight (no horse yet) and 1 black dragon warrior to warband 2. He costs 7 points. (Screenshot is Image 3 in this folder: https://drive.google.com/drive/u/0/fold ... XdoulwgtWv )
When I add the horse, it changes to 9.
(Image 4 in the same folder.)
This doesn't seem to happen if the black dragon is in Warband 1. Hmm. (Image 5 shows both.)

My version of the file with the above warbands is also in the same folder for your perusal.
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Tue Jul 12, 2022 7:37 pm 
Kinsman
Kinsman
Offline

Joined: Sat Sep 24, 2011 5:13 pm
Posts: 83
Location: N. Devon, UK
Rohan Captains are pointed too highly on the spreadsheet for Theodred's Guard. They should be 45 points each but they're currently listed as 55.
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Tue Jul 12, 2022 7:57 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
Must have copied from Eomer's Riders
Gonna upload with that and the previous fix, not sure what the other issue was.
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 Jul 12, 2022 10:10 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
tlarsen20 wrote:
Here's what I get, first step, adding a dragon knight (no horse yet) and 1 black dragon warrior to warband 2. He costs 7 points. (Screenshot is Image 3 in this folder: https://drive.google.com/drive/u/0/fold ... XdoulwgtWv )
When I add the horse, it changes to 9.
(Image 4 in the same folder.)
This doesn't seem to happen if the black dragon is in Warband 1. Hmm. (Image 5 shows both.)

My version of the file with the above warbands is also in the same folder for your perusal.


I forgot to drag a formula, CB83 had the right one, so it was working for warband 1, but I then forgot to drag it for the other 19 :oops:, was failing to replicate cause I was testing with warband 1
Will go upload the fixed version, 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: Wed Jul 13, 2022 5:49 am 
Wayfarer
Wayfarer
Offline

Joined: Wed Jan 07, 2015 9:43 pm
Posts: 4
Thank you! You rock sir
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Mon Aug 01, 2022 9:24 am 
Wayfarer
Wayfarer
User avatar
Offline

Joined: Sat Nov 03, 2012 10:28 am
Posts: 32
Found an issue in Army of Thror list. When giving a Warrior of Erebor a War Horn, Banner or Shield & Spear they do not show up in the Forces of Good page. When giving them either a Spear or Shield (Not Both) works fine.

Regards Windy

_________________
Windy
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Mon Aug 01, 2022 5:22 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
formulas weren't catching Warriors of Erebor past the 2nd one
Should be 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: MESBG army building spreadsheet
PostPosted: Thu Aug 04, 2022 12:11 pm 
Wayfarer
Wayfarer
User avatar
Offline

Joined: Sat Nov 03, 2012 10:28 am
Posts: 32
Found something else....

When selecting a hero in the Cirith Ungol LL it adds special rules for Shelob

I really do appreciate the amount of work that you have put into this fantastic resource.

List building with this is very easy and saves a lot of time.

Regards Windy

_________________
Windy
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Thu Aug 04, 2022 2:23 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
They were being added just because they were rules from the LL.
Since they aren't relevant unless you add Shelob in, I added a condition to only add them if that's the case.
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: Wed Aug 10, 2022 11:37 am 
Wayfarer
Wayfarer
Offline

Joined: Fri Jun 24, 2022 5:29 pm
Posts: 2
When selecting Dunlending Horsemen in either an Isengard list, or a Dunland LL list, the profile doesn't seem to appear on the army list. I assume it something to do with the keyword "horse" in the name throwing off the formula
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Thu Aug 11, 2022 2:52 am 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
You assume correctly.
I have changed the Dunlending Horsemen profile entries to fix it.
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: Sat Aug 13, 2022 10:54 am 
Wayfarer
Wayfarer
Offline

Joined: Sat Aug 13, 2022 10:50 am
Posts: 1
Hi LK,

Noticed an issue with the Rangers of Ithilien. When adding rangers of gondor to anborn and mablungs warband they count against the bow limit when they should not.

Cheers :)
Top
  Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 564 posts ]  Go to page Previous  1 ... 21, 22, 23, 24, 25, 26, 27 ... 29  Next

All times are UTC


Who is online

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