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 15 of 28

Author:  LonelyKnight [ Tue Jan 01, 2019 6:37 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

Two errors funnily enough, all the warriors from mordor were missing, and anything using "Warg" in its name wasn't showing up in any list
Cheers, updated

Author:  Manadar [ Wed Jan 02, 2019 9:51 am ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

Where do you store all the profiles ? I planned on getting and filtering them to better plan my armies. For instance a filter to find all heroes with 3Might under 60 points. It would be easier than scanning each book or using memory !

Author:  LonelyKnight [ Wed Jan 02, 2019 12:08 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

they are in each army list page to the right of the display, they don't have points in that list though.

Author:  Spike314 [ Wed Jan 02, 2019 6:14 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

Thanks Lonely. The update works better now. One small issue im not to worried about is that on the new page for Heroic's, its randomly added an Orc Captain and his Heroic March to the top of page. Also when printing, it chops off the page numbers detailing where to find the Heroics.

Author:  Natas234 [ Thu Jan 03, 2019 5:29 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

Thx so much for the work u ve done! Angmar have the same issue you've already corrected for mordor. Warg riders dont show up when listed.

Author:  Manadar [ Fri Jan 04, 2019 9:13 am ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

LonelyKnight wrote:
they are in each army list page to the right of the display, they don't have points in that list though.


Thank you

Author:  syrhobbs [ Sat Jan 05, 2019 4:15 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

Lonely love the spread sheet and have used it for several years now. thank you. By chance is there a way to take ore than one Dragon Knight for an Easterling army? For a 1000 point game it would be nice to have the option to take 3-4 at least. cheers

Author:  LonelyKnight [ Sat Jan 05, 2019 4:24 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

Well crud, the search for the heroic portion is seeing "Orc Captain" written in other profiles and assuming that means there's Orc Captains in there. Had to add the sneaky cheat of making it Orc Captain (2 spaces).
The Angmar ones slipped by me when I was looking for models with Warg in the name. Hopefully that's all of them.

The cutting off the heroic number seems to be a zoom issue, not sure why it does that. At 100% zoom (and if you print to pdf) it's there, but once you zoom out it gets cut and then at 70% it's totally gone.

Really need to redo the whole thing as a program one day, would make maintenance a lot easier

Gonna upload, cheers

Author:  LonelyKnight [ Mon Jan 07, 2019 2:57 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

syrhobbs wrote:
Lonely love the spread sheet and have used it for several years now. thank you. By chance is there a way to take ore than one Dragon Knight for an Easterling army? For a 1000 point game it would be nice to have the option to take 3-4 at least. cheers


you just need to write the warbands they lead
1 2 3 4 or 1,2,3,4 or anything else works as longs as the numbers aren't touching

Author:  GothmogtheWerewolf [ Mon Jan 07, 2019 10:38 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

Hi, how are you? Have you updated the spreadsheet recently?

Author:  LonelyKnight [ Tue Jan 08, 2019 4:47 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

GothmogtheWerewolf wrote:
Hi, how are you? Have you updated the spreadsheet recently?


Has all the profiles now in theory, only missing the special rules full write up in some army lists.
Army building wise it should have everything up to the current releases.

Me, I'm suffering from a dearth of free time, fun stuff. Hopefully will manage to get back into actually playing the game on weekends now and then.

Author:  Spike314 [ Wed Jan 09, 2019 1:26 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

Found a new error that the lothlorian list does not calculate the bow limit correctly

Author:  LonelyKnight [ Fri Jan 11, 2019 12:24 am ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

cheers, fixed

Author:  syrhobbs [ Fri Jan 11, 2019 2:39 am ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

LonelyKnight wrote:
syrhobbs wrote:
Lonely love the spread sheet and have used it for several years now. thank you. By chance is there a way to take ore than one Dragon Knight for an Easterling army? For a 1000 point game it would be nice to have the option to take 3-4 at least. cheers


you just need to write the warbands they lead
1 2 3 4 or 1,2,3,4 or anything else works as longs as the numbers aren't touching


Thank you. That worked perfectly. One more quick question. How would one go about adding both a foot and a mounted Dragon Knight? cheers

Author:  LonelyKnight [ Wed Jan 16, 2019 1:15 am ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

ah.. it seems I missed that detail. If it has two forms it should have two lines, will go add it.
Cheers

Author:  syrhobbs [ Wed Jan 16, 2019 4:56 am ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

Very nice thank you

Author:  Epiktetos [ Tue Jan 22, 2019 7:28 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

In the Survivors of Lake-town list, shouldn't Sigrid and Tilda fill two spots in a warband and count as two models for the count?

Author:  LonelyKnight [ Wed Jan 23, 2019 2:00 am ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

They should indeed, fixed, cheers.

Author:  Dwarves4thewin! [ Thu Jan 24, 2019 6:33 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

Found a small bug, the lines from the captains and kings of Minas Tirith are 'wrong numbered' (I'm not sure if that's a correct term, but I think you know what I mean).
If you give one of them a shield and say in what warband it's leading, then the pointcost is given from the one under it, without the shield (and other options as well).

But, what I've not said yet, is that I'm very happy with what you made, very usefull! Keep up the good work ;)

Author:  LonelyKnight [ Thu Jan 24, 2019 9:49 pm ]
Post subject:  Re: SBG army building spreadsheet ME SBG update

cheers, must have messed it up when I added Irolas.
Gonna upload

Page 15 of 28 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/