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/ |