All times are UTC


It is currently Tue Jun 04, 2024 7:59 am



Post new topic Reply to topic  [ 559 posts ]  Go to page Previous  1 ... 19, 20, 21, 22, 23, 24, 25 ... 28  Next
Author Message
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Sun Jan 16, 2022 4:04 am 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 303
Location: Lisboa, Portugal
Cheers

Not being a pain at all, the main purpose of this thread is for peeps to find errors in the file ^-^. Even faster when it's already diagnosed.

Apparently I had messed it up even in the side file where I keep all the profiles
Must have randomly clicked p and overwritten the title :oops:

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: Mon Jan 24, 2022 10:09 am 
Wayfarer
Wayfarer
Offline

Joined: Mon Jan 24, 2022 10:07 am
Posts: 1
Hi there,

Thought I'd mention that in the Pits of Dol Guldur LL page, Azog doesn't have access to the white warg as wargear - could this be added? :)

Many thanks
Eliott
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Mon Jan 24, 2022 5:12 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 303
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 Jan 27, 2022 12:14 pm 
Wayfarer
Wayfarer
Offline

Joined: Wed Jan 26, 2022 4:54 pm
Posts: 1
minas tirith bolt thrower seems to add 3 crew instead of 2.
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Thu Jan 27, 2022 6:54 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 303
Location: Lisboa, Portugal
Cheers, seems I had just copied the trebuchet formulas
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 Jan 28, 2022 3:42 pm 
Wayfarer
Wayfarer
Offline

Joined: Wed Feb 13, 2019 2:31 pm
Posts: 6
LonelyKnight wrote:
Cheers, seems I had just copied the trebuchet formulas
Fixed

No, no. You actually changed it from 2 to 3 correctly because of a FAQ last year. So changing it back is a mistake!
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Fri Jan 28, 2022 4:45 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 303
Location: Lisboa, Portugal
Ah, my bad
I opened the "Designers" file instead of the "Errata" file and did a search for Bolt.
Will change it back to the previous version

_________________
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 Feb 03, 2022 11:01 am 
Wayfarer
Wayfarer
User avatar
Offline

Joined: Sat Nov 03, 2012 10:28 am
Posts: 32
Hi me again...

There is a formula error on the Isengard sheet.
When you select the first Uruk-hai Captain it puts a cost value in the next box down.
The formula is =DO12*(C13+5*(F13+K13+L13+Q13))
Should be =DO13*(C13+5*(F13+K13+L13+Q13))

Also when I download the latest version I add a hyperlink to take me from the list building page direct to the Forces of Good/Evil page.
Is this something you could implement. Just cuts out having to go to the index page.

Regards Windy

_________________
Windy
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Thu Feb 03, 2022 5:07 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 303
Location: Lisboa, Portugal
Cheers, fixed
Added the hyperlink and the new stuff from the Errata

_________________
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 15, 2022 4:18 pm 
Wayfarer
Wayfarer
User avatar
Offline

Joined: Sat Nov 03, 2012 10:28 am
Posts: 32
Found error when using Saruman in an Isengard list it shows the following line in his special rules:
Move any displaced models the minimum distance possible so that they are 1" away from the

Think this belongs to Watcher in the Water.

Regards Windy

_________________
Windy
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Tue Feb 15, 2022 5:34 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 303
Location: Lisboa, Portugal
can't seem to replicate the error
was anything else selected?

_________________
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 Feb 19, 2022 9:11 am 
Elven Warrior
Elven Warrior
User avatar
Offline

Joined: Fri Mar 08, 2013 6:56 am
Posts: 744
Location: Central Coast, NSW, Australia
Hey LK. If you add a Shield to Lurtz wargear the 5 point cost does not add on.

_________________
My trade thread
http://www.one-ring.co.uk/viewtopic.php?f=38&t=25957&p=325932#p325932
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Sat Feb 19, 2022 4:00 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 303
Location: Lisboa, Portugal
Lurtz's shield is marked as free in the Armies of the Lord of the Rings
Prolly cause he doesn't get the defence bonus since he's carrying a bow

_________________
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 Mar 03, 2022 3:19 pm 
Wayfarer
Wayfarer
User avatar
Offline

Joined: Sat Nov 03, 2012 10:28 am
Posts: 32
The error with Saruman in the Isengard list is in the following

This is on the Forces of Evil page under FORCES OF EVIL - Special Rules/Equipment

Voice of Curunír [A]
Saruman's Stand Fast! has a range of 12" and, unlike other Hero models' Stand Fast! rolls, can affect other Hero models. Move any displaced models the minimum distance possible so that they are 1" away from the

Windy

_________________
Windy
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Fri Mar 04, 2022 3:24 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 303
Location: Lisboa, Portugal
oh damn it's in the same line
Though it was grabbing an extra line somewhere, was just me leaving text in a line that shouldn't be there
I have no idea how I did that
Will go fix it, cheers

Edit: Twas the autocomplete, excel just tried to pull the same nonsense again :P

_________________
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 08, 2022 11:57 am 
Wayfarer
Wayfarer
Offline

Joined: Tue Mar 08, 2022 11:12 am
Posts: 1
Hey :)

First of all, thanks a lot for a great tool! Wanted to share a little bit of bugs that I've found when choosing Variags of Khand army list:

1) For the Khandish King and Khandish Chieftain, while choosing chariot, stats and chariot rules are not shown in the Forces of Evil tab. However, when adding Khandish Charotieers to the warband, stats & rules are added immediately.
2) Statistics for Khandish Horsemen are not shown in the Forces of Evil tab.

3) Also, for Easterlings, there is an issue with Dragon Cult Acolyte - it does not show up on the stats list, similarly like Khandish Horseman.
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Wed Mar 09, 2022 4:20 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 303
Location: Lisboa, Portugal
First two bugs were related to how I was detecting the gear
3rd one was the usual "forgot to grab the new unit from the spreadsheet"

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 Apr 28, 2022 12:03 pm 
Wayfarer
Wayfarer
User avatar
Offline

Joined: Sat Nov 03, 2012 10:28 am
Posts: 32
Just looking at a Kingdom of Khazad-dûm list. I have found that the Khazad Guard & Hearthguard are missing their Bodyguard Special Rule.

Regards Windy

_________________
Windy
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Thu Apr 28, 2022 2:44 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 303
Location: Lisboa, Portugal
damn, quite the oversight

added the rule, 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 May 05, 2022 11:37 am 
Wayfarer
Wayfarer
User avatar
Offline

Joined: Sat Nov 03, 2012 10:28 am
Posts: 32
Can you look at the Iron Hills sheet, the siege veteran stats do not show on the forces of good sheet.

Windy

_________________
Windy
Top
  Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 559 posts ]  Go to page Previous  1 ... 19, 20, 21, 22, 23, 24, 25 ... 28  Next

All times are UTC


Who is online

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