All times are UTC


It is currently Sat Sep 21, 2024 6:42 am



Post new topic Reply to topic  [ 561 posts ]  Go to page Previous  1 ... 18, 19, 20, 21, 22, 23, 24 ... 29  Next
Author Message
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Wed Jul 21, 2021 6:21 pm 
Wayfarer
Wayfarer
Offline

Joined: Sat Oct 27, 2018 8:27 am
Posts: 6
It is still wierd to print from Andriod devices. On My Samsung S9, i have to select all the pages i want printed, then hit print and change it to "Selection only". Then select the pages that i want to print as it brings up the whole lot. Not sure if this can be improved but thought it was worth bringing up.

Also will you be updating the Spell cards. They are an amazing resource but a little our of date and would help players that cannot afford the GW ones.
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Thu Jul 22, 2021 5:33 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 304
Location: Lisboa, Portugal
if I hide the cells that aren't supposed to be printed it should limit it somewhat, it'll still have some empty pages in the mix but I guess it could be better.

Haven't looked at those in ages, guessing the base spells are still correct but they are missing the new spells that pop up now and then.
I'll give it a look

EDIT: Huh, they don't even include the channeling effects

_________________
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 Aug 09, 2021 6:47 am 
Wayfarer
Wayfarer
Offline

Joined: Wed Feb 13, 2019 2:31 pm
Posts: 6
Something I noticed: the official Gondor at War FAQ states that Dernhelm is considered 2 models (Eowyn+Merry) when considering Break Point and army list total. In the file it shows as 1 only.

Thanks for keeping this updated.
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Fri Aug 13, 2021 4:36 pm 
Wayfarer
Wayfarer
Offline

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

Hi again, plz can you check the formula of the archery count check in Rivendell Army Sheet.

The main problem is when you choose Elrond and Rivendell Knights and another model with bow.

The total count of archers formula it's doesn't match with our count.

Thank you so much for your time!

Cheers
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Sat Aug 14, 2021 1:56 am 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 304
Location: Lisboa, Portugal
Cheers, Fixed
Also changed some things for the august patch and added the new dale stuff
haven't added the correct new allies when you pick the war of the ring heroes

_________________
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 14, 2021 10:15 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 304
Location: Lisboa, Portugal
Huh, only saw the message from the 13th now..
Yeah I was supposed to pull them out of the bow limit completely
Gonna go do it 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: Mon Aug 16, 2021 3:04 pm 
Wayfarer
Wayfarer
Offline

Joined: Mon May 02, 2016 7:35 pm
Posts: 29
Love your army builder. I use it all the time and recommend it to my friends. I have discovered an error. The Gondor Avenger Bolt Thrower from the Minas Tirith army lists shows the default warband as 2/6 when selected. This should be 1/6 though because the base Bolt Thrower only comes with 2 crew not 3.

Thanks,
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Wed Aug 18, 2021 8:29 am 
Wayfarer
Wayfarer
Offline

Joined: Wed Feb 13, 2019 2:31 pm
Posts: 6
Terentius wrote:
Love your army builder. I use it all the time and recommend it to my friends. I have discovered an error. The Gondor Avenger Bolt Thrower from the Minas Tirith army lists shows the default warband as 2/6 when selected. This should be 1/6 though because the base Bolt Thrower only comes with 2 crew not 3.

Thanks,

It's 3. The official Errata changed it.
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Wed Aug 25, 2021 8:20 am 
Wayfarer
Wayfarer
Offline

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

Thank you very much for creating your excel sheet. It has been invaluable to me.

I don't know if you are in the process of adding this, or have already added it, but please could you add the Rangers of Ithilien legiondary legion from the Quest of the Ringbearer. If you have already added it, then my apologies for pestering you.

Thanks again for the awesome work you do!
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Sun Sep 05, 2021 2:40 pm 
Elven Warrior
Elven Warrior
User avatar
Offline

Joined: Fri Mar 06, 2009 5:13 pm
Posts: 791
Location: Manchester UK
Images: 10
Hi dude, Am trying to print army sheets, all is fine till its get to the pages with "special rules and equipment" , it seems to cut the pages in half and spread over two pages??
Do I need to change my printer settings to accom this?
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Fri Nov 12, 2021 4:59 pm 
Wayfarer
Wayfarer
Offline

Joined: Wed Jul 14, 2021 8:44 pm
Posts: 4
Hi LK how are you?

I hope that you're ok!

Can I ask you if you're going to update your excel with the new LL from the last suplement "Fall of the Necromancer"

Besides, can you check the Mumak Capacity from Serpent Horde and Far Harad armies? because they can have 12 model in the Howdah plus the Commander, so in total are 14 units no 13 units like say your excel.

Thank you so much!!

Hugs from Chile!

Cheers
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Mon Nov 22, 2021 7:42 pm 
Loremaster
Loremaster
Offline

Joined: Sun Feb 21, 2010 6:48 pm
Posts: 1979
Location: Birmingham, UK
Images: 6
Hi LK,

On the Paths of the Druadan LL, the Outriders each cost 18pts, rather than the correct 13pts.

Thanks, as ever, for all your work on this. :)

_________________
"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: Mon Dec 06, 2021 2:37 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 304
Location: Lisboa, Portugal
Sorry for the delay on the FotN
Been busy, should be able to get it done by next weekend

_________________
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 Dec 11, 2021 3:08 am 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 304
Location: Lisboa, Portugal
Ok, FotN is up

_________________
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 Dec 13, 2021 5:08 pm 
Wayfarer
Wayfarer
User avatar
Offline

Joined: Sat Nov 03, 2012 10:28 am
Posts: 32
Great job.
Just looked at the FotN page.
Cells Y2 & Z2 have the wrong range. They are both showing Good instead of Evil.
Also the data is not being displayed on the Forces of Good/Evil sheets.

_________________
Windy
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Mon Dec 13, 2021 7:12 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 304
Location: Lisboa, Portugal
Ah right, forgot to extend the formulas in the army list sheets to capture the new sheets
Will have to sort that out.

The good instead of evil mistake is because I re-used a white council sheet to make that one :P
Slipped my mind

_________________
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 Dec 13, 2021 8:27 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 304
Location: Lisboa, Portugal
Ok 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 06, 2022 4:36 pm 
Wayfarer
Wayfarer
User avatar
Offline

Joined: Sat Nov 03, 2012 10:28 am
Posts: 32
Looking at creating a Cirith Ungol LL.
When selecting heroes the highlighting on the allowed warriors disappears all good so far.
However when I give the heroes additional wargear (example: give Gorbag a shield) the highlighting comes back.

I'm guessing it is to do with the conditional formatting.

Windy

_________________
Windy
Top
  Profile  
Reply with quote  
 Post subject: Re: MESBG army building spreadsheet
PostPosted: Thu Jan 06, 2022 6:43 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 304
Location: Lisboa, Portugal
Was a silly mistake, I was comparing the guy in charge of the warband with the original name instead of checking if the original name was part of the guy in charge (and "Gorbag with shield" does not match "Gorbag"

Went through all the lists that had similar issues.

Added the two new Orc Heroes as well

_________________
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 Jan 15, 2022 3:32 pm 
Wayfarer
Wayfarer
User avatar
Offline

Joined: Sat Nov 03, 2012 10:28 am
Posts: 32
Sorry to be such a pain but...

I have found an error.

I tracked it down to a cell on the Forces of Good sheet.
Cell FJ117 is showing the letter 'p'
This is causing Helm Hammerhand's LL Special Rule to appear for a lot of the armies.
When I changed this to 'The King of Rohan' it seems to have resolved the issue.

Just thought I'd let you know.

Windy

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

All times are UTC


Who is online

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