The One Ring
http://ww.one-ring.co.uk/

MESBG army building spreadsheet
http://ww.one-ring.co.uk/viewtopic.php?f=42&t=22221		 Page 18 of 29
Author:  LonelyKnight [ Sat Nov 16, 2019 9:51 pm ]
Post subject:  Re: MESBG army building spreadsheet
Cheers

In the Shire thing it was actually rather funny, pony was being written as cart and cart had nothing to write in the display
Author:  LonelyKnight [ Sun Jan 12, 2020 6:39 pm ]
Post subject:  Re: MESBG army building spreadsheet
For anyone wondering, I do have the Rohan book, just a bit busy atm so I'll have to do it next weekend.
Author:  Dwarves4thewin! [ Tue Jan 14, 2020 2:09 pm ]
Post subject:  Re: MESBG army building spreadsheet
Thanks LonelyKnight!

And I saw a question on the site, from bilbobaggings123, about your work, so I repost it here:

Hi Guys,

My name is Kevin, nice to meet you all! I am trying to get back into the hobby after a long absence and I was playing around with LK's mesbg army builder (thank you so much for making it, such a great tool!) and I noticed there is only 1 slot for shades and barrow wights.

Does this mean your now only allowed to take one shade and one barrow wight in your Angmar army list?

Thanks in advance guys!
Author:  LonelyKnight [ Tue Jan 14, 2020 4:02 pm ]
Post subject:  Re: MESBG army building spreadsheet
It just means they have no options, so no need for two lines. You use numbers to specify the amount so he can fill up all of the warbands with them if he wants.
Author:  LonelyKnight [ Sun Feb 09, 2020 2:01 am ]
Post subject:  Re: MESBG army building spreadsheet
Finally finished the update, sorry for the delay
Included the new FAQ

The file is getting a bit unwieldy with all the Legendary Legions, thinking of splitting them off into a separate file.
Created a simple poll to see what peeps think about that
http://www.strawpoll.me/19366645
Author:  General Elessar [ Sun Feb 09, 2020 4:49 pm ]
Post subject:  Re: MESBG army building spreadsheet
LonelyKnight wrote:
Finally finished the update, sorry for the delay
Included the new FAQ

The file is getting a bit unwieldy with all the Legendary Legions, thinking of splitting them off into a separate file.
Created a simple poll to see what peeps think about that
http://www.strawpoll.me/19366645


Thanks for the update! Really appreciate all your work on this. :)
Author:  salamanderdan [ Sun Feb 09, 2020 6:23 pm ]
Post subject:  Re: MESBG army building spreadsheet
Great work as always.

Found a couple bugs: When add merry and pippen to treebeard only merry shows up on the forces of good page.
Quickbeam and Beechbone both don't show up on the forces of good page
I am also not sure that fangorn models have the fearless special rule

Would splitting the spreadsheet my good and evil make it easier?
Author:  ali [ Mon Feb 10, 2020 10:33 am ]
Post subject:  Re: MESBG army building spreadsheet
Hello,

thank's a lot for your work!!
I found two mistake:

in LL Defenders of Helm's deep, Royal guard cost 15 point instead of 10.
in LL Ugluk's scout, the number of point appear a line down to the hero selected for snaga and captain.
Author:  LonelyKnight [ Tue Feb 11, 2020 1:32 am ]
Post subject:  Re: MESBG army building spreadsheet
Quote:
Would splitting the spreadsheet my good and evil make it easier?


Splitting good and evil would also make the individual files smaller.
Legendary Legions take up a lot more time adding than the rest of the file, so I figured if I split them I could have the army list portion more quickly updated.

Quote:
I am also not sure that fangorn models have the fearless special rule

They don't, it's from the army list bonus, it'll vanish if the alliance is no longer valid.

Quote:
Found a couple bugs: When add merry and pippen to treebeard only merry shows up on the forces of good page.
Quickbeam and Beechbone both don't show up on the forces of good page

Thx

Quote:
in LL Defenders of Helm's deep, Royal guard cost 15 point instead of 10.
in LL Ugluk's scout, the number of point appear a line down to the hero selected for snaga and captain.

Copy paste and dragging cells
Thx

Gonna go upload now
Author:  reszkov [ Sun Feb 16, 2020 10:39 pm ]
Post subject:  Re: MESBG army building spreadsheet
Hi,

Shieldbearer from Khazadum dosen't seem to appear on the "Forces of good" fully.

its profile part only is missing (movment, fighting, might etc)

BTW, love this army builder, thank you !
Author:  LonelyKnight [ Mon Feb 17, 2020 2:33 pm ]
Post subject:  Re: MESBG army building spreadsheet
Huh, had to do with the "Shield" in its name.

Fixed now, cheers
Author:  GothmogtheWerewolf [ Mon Feb 24, 2020 10:49 pm ]
Post subject:  Re: MESBG army building spreadsheet
@LonelyKnight, I've noticed that you've forgotten to add the new Dunland stuff in the Isengard list, only in the Legendary Legion. Could you add them please?

Also, I'm not sure if it's just me but when you add Uruk-hai Scout Captain in Ugluk's Legendary Legion it seems to want Orcs instead of Uruks?
Author:  LonelyKnight [ Tue Feb 25, 2020 3:49 pm ]
Post subject:  Re: MESBG army building spreadsheet
I didn't notice they were also in the Isengard list :oops:

Not sure what's going on with the uruk-hai scout captain, it was wrong for the drummer but the rest seems to have been working.

Did the changes for the second february FAQ
Author:  salamanderdan [ Fri Feb 28, 2020 8:36 pm ]
Post subject:  Re: MESBG army building spreadsheet
Thanks for the fast fixes
Another little bug: on the index pages the unit and points totals do not include the war in rohan legendary legions. (the sum just doesnt go far enough down)
Author:  LonelyKnight [ Sat Feb 29, 2020 10:33 pm ]
Post subject:  Re: MESBG army building spreadsheet
Cheers, fixed
Author:  CJSBG [ Sun Mar 01, 2020 5:10 am ]
Post subject:  Re: MESBG army building spreadsheet
Good morning, let me just say this tool is absolutely incredible, lets me write lists for fun with incredible ease and compare lists for the same pts values to choose for tournaments. Thanks very much for the work you do :)

In terms of bugs, in the past few updates the Assault on Helm's Deep legion page has a problem with pts values. If you select the uruk leader it charges you double and adds a 2nd captain you didn't ask for and the more options you pick the more it snowballs. And I think an Iron Hills captain in chariot should be 250pts instead of 255. The numbers also don't seem to pick up the 4 in the chariot and only counts the captain driving it. Similarly, a gondor trebuchet only counts two models, and an IH ballista only 3. I haven't checked all the other siege engines, is it deliberate because the veteran/captain leads that warband?

Please keep up the work you do on this, it is such a helpful tool, especially for players with disabilities. For your polling, I agree that having separate spreadsheets for LLs, Evil and Good would be a good idea. Currently there is a lot of scrolling to get from the Gondor sheet all the way to the Forces of Good sheet! Best wishes, CJ
Author:  LonelyKnight [ Sun Mar 01, 2020 4:31 pm ]
Post subject:  Re: MESBG army building spreadsheet
Had the formulas off for the Hero points in the Legion. Iron Hills captain is indeed 250, not sure why I left it with only 1 model, changed it to count 4

The siege engines seem to be ok, they count 3 models for trebuchet, but only 2 for the warband.

Cheers, fix has been uploaded
Author:  g.pavely@sky.com [ Fri Mar 06, 2020 2:10 pm ]
Post subject:  Re: MESBG army building spreadsheet
Thanks for all your hard work on an excellent resource for MESBG.
Found a formula error on the Wolves of Isengard LL.
Formula in S3 needs to be dragged down to S9.

Windy
Author:  LonelyKnight [ Sat Mar 07, 2020 4:44 pm ]
Post subject:  Re: MESBG army building spreadsheet
Seems to be correct, S3 has one formula, S4-7 has another and S8-9 another
Author:  Budalex [ Thu Mar 12, 2020 7:49 am ]
Post subject:  Re: MESBG army building spreadsheet
Hello Lonely Knight !

First, a big thanks to your army building spreadsheet ! It’s very useful to imagine new/future lists, and keep a eye on the whole thing during the conception.

I’m building a Sharkey’s Rogue band, and I have some questions about the sheet ou did for them:

1) Why didn’t you put the option to swap weapon? Because they have knife or club as starting weapons, and both of them are in the list of weapons which have access to the option.
2) Is it possible to add at least one line of Ruffians in the next update please ? It is linked to my previous point, because if you imagine to swap weapon for a Ruffian who has also a bow or a whip, you finally don’t habe enough lines for that...

Again, thanks a lot for your work, and I hope you the best for the future ! :D
Page 18 of 29 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/