All times are UTC


It is currently Wed Nov 27, 2024 10:45 pm



Post new topic Reply to topic  [ 564 posts ]  Go to page Previous  1 ... 17, 18, 19, 20, 21, 22, 23 ... 29  Next
Author Message
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Sun Feb 14, 2021 11:54 am 
Wayfarer
Wayfarer
User avatar
Offline

Joined: Sat Nov 03, 2012 10:28 am
Posts: 32
Thanks for that.
I have a question about the Helm's Guard Legendary Legion, I can't seem to find it in any of the books. Can you tell me where it is?

_________________
Windy
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Sun Feb 14, 2021 1:52 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
War in Rohan pages 128-129 (the last 2 pages)

_________________
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 15, 2021 11:52 am 
Wayfarer
Wayfarer
User avatar
Offline

Joined: Sat Nov 03, 2012 10:28 am
Posts: 32
Thanks'
Obviously not looking hard enough. :)

_________________
Windy
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Mon Feb 15, 2021 12:36 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
They often put stuff that isn't in the main narrative at the end in an appendix.

_________________
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 Mar 06, 2021 5:14 pm 
Wayfarer
Wayfarer
Offline

Joined: Sun Mar 01, 2020 4:51 am
Posts: 10
Hiya, the Keeper of the Dungeons is listed as Valour but in the book he is Fortitude. Dishonor! Dishonor on your whole family!
Best wishes,
CJ
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Sat Mar 06, 2021 9:30 pm 
Wayfarer
Wayfarer
Offline

Joined: Sat Mar 06, 2021 9:27 pm
Posts: 1
Just wanted to note
the printable good version does not show glorfindel when you add him to your list, in the Stats part where it has move, fight , ect.
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Mon Mar 08, 2021 4:46 am 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
CJSBG wrote:
Hiya, the Keeper of the Dungeons is listed as Valour but in the book he is Fortitude. Dishonor! Dishonor on your whole family!
Best wishes,
CJ

Must have been a copy paste slip up

talism wrote:
Just wanted to note
the printable good version does not show glorfindel when you add him to your list, in the Stats part where it has move, fight , ect.

When you selected both upgrades I had messed up in the id he would look for in the list.

Cheers to both, 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 Mar 18, 2021 10:04 am 
Wayfarer
Wayfarer
Offline

Joined: Wed Feb 13, 2019 2:31 pm
Posts: 6
Hi man,

Many thanks for keeping this file still up to date!

The profiles that are shown in the "Forces of Good" section for Oin and Ori if you take them in the Kingdom of Khazad-Dum (not Erebor Reclaimed) are switched.
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Fri Mar 19, 2021 9:17 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
Seems I had them with names switched before and when I copied instead of correcting the name used for reference I "corrected" the name in the profile :|
Cheers, I'll upload in a bit

_________________
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 23, 2021 3:57 am 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
Added the Dragon Cult Acolyte profile

_________________
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 29, 2021 6:37 am 
Wayfarer
Wayfarer
Offline

Joined: Sun Mar 31, 2019 8:54 am
Posts: 10
Thanks for that tool, it's awesome! The pandemic brought me back to tabletop gaming and I had a lot of time to paint minis, but since I couldn't find anyone to play with, I just bought and painted what looked cool without giving much of a thought about armies...
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Wed Apr 21, 2021 7:49 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
Added the new Dain & Thorin III rules

_________________
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 Jun 19, 2021 11:25 pm 
Kinsman
Kinsman
Offline

Joined: Sun Jul 13, 2008 11:37 pm
Posts: 235
Tiny thing: The Cirith Ungol LL has its Orc and Uruk warbands flipped. So if I take an Orc Captain, it'll highlight Mordor Uruk-Hai as the available warriors, and vice-versa. Also happens on Shagrat and Gorbag's profiles.

I don't think I've ever thanked you for the file over the past decade+, so thanks LonelyKnight! You're really helped a lot of people with the army builder.
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Sun Jun 20, 2021 12:38 am 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
Well that was a silly thing on my part
If you check the conditional formatting I put "o" for the uruk-hai and "u" for the orcs...
Gonna upload the fixed version,
Cheers

It has been a while... I still have the original LOME version from 2008

_________________
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 Jun 20, 2021 5:09 am 
Kinsman
Kinsman
Offline

Joined: Sun Jul 13, 2008 11:37 pm
Posts: 235
Silly mistakes happen to us all. Looks good now, thanks again!

I think I still have the LOME and WOTR spreadsheets stowed away somewhere on an old computer
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Wed Jul 14, 2021 9:25 pm 
Wayfarer
Wayfarer
Offline

Joined: Wed Jul 14, 2021 8:44 pm
Posts: 4
Dear Lonely,

Hopping you're fine, I and my comrades here in Chile. We're using alot your spreadsheet. Please allow me to give you my congratulations for your big work here!, so thank you!

We have some issues in your spreadsheet if you can fix it:

1) Fix the unit count of the War Mumak of Harad (serpent horde), today its 1, but they're 2 units (comander+beast) if I go alone (no units mounted in Howdah)
2) There's an issue in the profile of the Mahud Rider, you have a slot for spear. All Mahud riders brings war spears.
3) Fix the unit count for Warg Marauder (moria) today its 1, but They're 3 units in total. (3 goblins mounted in warg)
4) Fix the unit count of the Mumak War Leader (LL Grand army of the south), today its 1, but they're 2 units (comander+beast) if I go alone (no units mounted in Howdah).

Many thanks and big hugs from Chile!

I let you know if I discover another issues.

Cheers!
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Thu Jul 15, 2021 3:16 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
The warg marauder is actually meant to be like that according to the FAQs

Quote:
Q: How many models does a Warg Marauder count as for the
purpose of building an army and Bow Limit? (p.164)
A: Like all Cavalry models, it will count as a single model.
As it is armed with an Orc bow it will also count as a
model towards your Bow Limit.

From page 4 of the Designers notes on the Armies of the Lord of the Rings

The rest I've fixed, gonna go upload now.
I assume the Mûmak is an automatic part of the commander's warband

Cheers

Bit by bit the errors get hammered out

_________________
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 Jul 15, 2021 11:46 pm 
Wayfarer
Wayfarer
Offline

Joined: Thu Jul 15, 2021 11:32 pm
Posts: 2
Hi,

Thanks for your amazing work on this army builder!

I was putting together an Easterling list and noticed a couple of things:

1. I added Khamul on armoured Fell Beast. When I go to the 'Forces of Evil' tab it shows Khamul on armoured Fell Beast on the first page. However, in the table with all the stats it shows 'Fell Beast' (not 'armoured Fell Beast'). Same on the list of wargear/upgrades.

2. On the 'Forces of Evil' tab, the list of Special Rules/Equipment is not aligned for printing (the page is split in two, left and right so to speak). To print this page I had to mark the exact cells I wanted to print. Is it supposed to behave like that? Did I do something wrong?

Cheers,
Magnus
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Fri Jul 16, 2021 9:55 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
The first issue was an interesting mismatch
Since excel starts mixing stuff up if the character strings overlap, I was supposed to have armoured Fell beast, instead of Beast.
Funnily enough it was wrong in almost every place, except the corsairs of umbar

Second one is prolly page setup. Should work with margins of 1cm (0.4") on A4. No idea what it looks like on letter, but you can always print to pdf in A4 and then if you wanna print physically in letter the pdf will fit it
When you have too many he does spill over onto a second page

Cheers, gonna go upload 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: Sun Jul 18, 2021 10:56 pm 
Wayfarer
Wayfarer
Offline

Joined: Thu Jul 15, 2021 11:32 pm
Posts: 2
Great! Thanks for the update.

I solved my printing issue by changing to 0,5 cm top/bottom margins (1 cm in A4 does not work for me as I wrote earlier).
Top
  Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 564 posts ]  Go to page Previous  1 ... 17, 18, 19, 20, 21, 22, 23 ... 29  Next

All times are UTC


Who is online

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