ups, always a bit messy with siege engines
The whole point of this thread is for peeps to find the mistakes
Cheers, fixed
| The One Ring http://wap.one-ring.co.uk/ |
|
| MESBG army building spreadsheet http://wap.one-ring.co.uk/viewtopic.php?f=42&t=22221 |
Page 24 of 28 |
| Author: | LonelyKnight [ Wed Jun 22, 2022 3:56 pm ] |
| Post subject: | Re: MESBG army building spreadsheet |
ups, always a bit messy with siege engines The whole point of this thread is for peeps to find the mistakes Cheers, fixed |
|
| Author: | SBThirty7 [ Fri Jun 24, 2022 5:35 pm ] |
| Post subject: | Re: MESBG army building spreadsheet |
Hi there, thanks so much for this amazing spreadsheet by the way! Just a couple of things I noticed whilst creating armies, for Dunland it seems "Dunlendin Horsemen" don't show up in the army list once you create the force, I think it's due to the term "horse" within the name breaks one of the vlookups. Also when you select Lurtz within an isengard army, Woodland Creature is selected and kicks off his regular find the hobbit special ability (or whatever it's called). |
|
| Author: | CptMaleck [ Sat Jun 25, 2022 7:01 am ] |
| Post subject: | Re: MESBG army building spreadsheet |
Hi LonelyKnight, amazing work with the spreadsheet. Thank you so much for all the time and effort you put in to it. I spotted a small hiccup in the Dragon host Legendary Legion, I believe. From what I understand, the free upgrade for Easterling Warriors to Black Dragons is available to all warriors who have a Easterling Dragon Knight as a hero. Unfortunately, if you give the Dragon knight an armoured horse, that upgrade is removed from the sheet, when I believe it should remain. Although, it's highly probable that I misread the Legiondary Legion. Thanks for all the awesome work you do and feel free to ridicule me, if I'm incorrect about my assumption. Cheers! |
|
| Author: | LonelyKnight [ Sat Jun 25, 2022 4:05 pm ] |
| Post subject: | Re: MESBG army building spreadsheet |
Same issue as in the Defenders of Erebor, copied over the formulas from there. Fixed, gonna go upload now, cheers. |
|
| Author: | tlarsen20 [ Sun Jul 10, 2022 5:19 am ] |
| Post subject: | Re: MESBG army building spreadsheet |
It looks like I'm getting the same problem. Also, thank you so much for this project, it is so incredibly useful! I'll have to send money again
|
|
| Author: | g.pavely@sky.com [ Sun Jul 10, 2022 3:42 pm ] |
| Post subject: | Re: MESBG army building spreadsheet |
When selecting Muzgúr, Orc Shaman in either a Mordor or an Assault on Lothlórien list, it shows Magical Powers & Heroic Actions for Orc Shaman is this an error? |
|
| Author: | LonelyKnight [ Sun Jul 10, 2022 8:28 pm ] |
| Post subject: | Re: MESBG army building spreadsheet |
g.pavely@sky.com wrote: When selecting Muzgúr, Orc Shaman in either a Mordor or an Assault on Lothlórien list, it shows Magical Powers & Heroic Actions for Orc Shaman is this an error? Tis an error indeed, he was finding "Orc Shaman" within "Muzgúr, Orc Shaman". Cheers, fixed it but I wanted to check the other issue before uploading tlarsen20 wrote: It looks like I'm getting the same problem. Problems with the Easterling points costs in the Legendary Legion? With the version that's currently online I can't find issues in that particular one. |
|
| Author: | tlarsen20 [ Mon Jul 11, 2022 4:40 am ] |
| Post subject: | Re: MESBG army building spreadsheet |
I will re-download the file and try again. Yes, it was the easterlings. Thank you so much for making this! You are a legend |
|
| Author: | tlarsen20 [ Mon Jul 11, 2022 5:44 am ] |
| Post subject: | Re: MESBG army building spreadsheet |
Here's what I get, first step, adding a dragon knight (no horse yet) and 1 black dragon warrior to warband 2. He costs 7 points. (Screenshot is Image 3 in this folder: https://drive.google.com/drive/u/0/fold ... XdoulwgtWv ) When I add the horse, it changes to 9. (Image 4 in the same folder.) This doesn't seem to happen if the black dragon is in Warband 1. Hmm. (Image 5 shows both.) My version of the file with the above warbands is also in the same folder for your perusal. |
|
| Author: | Epiktetos [ Tue Jul 12, 2022 7:37 pm ] |
| Post subject: | Re: MESBG army building spreadsheet |
Rohan Captains are pointed too highly on the spreadsheet for Theodred's Guard. They should be 45 points each but they're currently listed as 55. |
|
| Author: | LonelyKnight [ Tue Jul 12, 2022 7:57 pm ] |
| Post subject: | Re: MESBG army building spreadsheet |
Must have copied from Eomer's Riders Gonna upload with that and the previous fix, not sure what the other issue was. Cheers |
|
| Author: | LonelyKnight [ Tue Jul 12, 2022 10:10 pm ] |
| Post subject: | Re: MESBG army building spreadsheet |
tlarsen20 wrote: Here's what I get, first step, adding a dragon knight (no horse yet) and 1 black dragon warrior to warband 2. He costs 7 points. (Screenshot is Image 3 in this folder: https://drive.google.com/drive/u/0/fold ... XdoulwgtWv ) When I add the horse, it changes to 9. (Image 4 in the same folder.) This doesn't seem to happen if the black dragon is in Warband 1. Hmm. (Image 5 shows both.) My version of the file with the above warbands is also in the same folder for your perusal. I forgot to drag a formula, CB83 had the right one, so it was working for warband 1, but I then forgot to drag it for the other 19  , was failing to replicate cause I was testing with warband 1Will go upload the fixed version, cheers |
|
| Author: | tlarsen20 [ Wed Jul 13, 2022 5:49 am ] |
| Post subject: | Re: MESBG army building spreadsheet |
Thank you! You rock sir |
|
| Author: | g.pavely@sky.com [ Mon Aug 01, 2022 9:24 am ] |
| Post subject: | Re: MESBG army building spreadsheet |
Found an issue in Army of Thror list. When giving a Warrior of Erebor a War Horn, Banner or Shield & Spear they do not show up in the Forces of Good page. When giving them either a Spear or Shield (Not Both) works fine. Regards Windy |
|
| Author: | LonelyKnight [ Mon Aug 01, 2022 5:22 pm ] |
| Post subject: | Re: MESBG army building spreadsheet |
formulas weren't catching Warriors of Erebor past the 2nd one Should be fixed Cheers! |
|
| Author: | g.pavely@sky.com [ Thu Aug 04, 2022 12:11 pm ] |
| Post subject: | Re: MESBG army building spreadsheet |
Found something else.... When selecting a hero in the Cirith Ungol LL it adds special rules for Shelob I really do appreciate the amount of work that you have put into this fantastic resource. List building with this is very easy and saves a lot of time. Regards Windy |
|
| Author: | LonelyKnight [ Thu Aug 04, 2022 2:23 pm ] |
| Post subject: | Re: MESBG army building spreadsheet |
They were being added just because they were rules from the LL. Since they aren't relevant unless you add Shelob in, I added a condition to only add them if that's the case. Cheers |
|
| Author: | SBThirty7 [ Wed Aug 10, 2022 11:37 am ] |
| Post subject: | Re: MESBG army building spreadsheet |
When selecting Dunlending Horsemen in either an Isengard list, or a Dunland LL list, the profile doesn't seem to appear on the army list. I assume it something to do with the keyword "horse" in the name throwing off the formula |
|
| Author: | LonelyKnight [ Thu Aug 11, 2022 2:52 am ] |
| Post subject: | Re: MESBG army building spreadsheet |
You assume correctly. I have changed the Dunlending Horsemen profile entries to fix it. Cheers! |
|
| Author: | riledhuman [ Sat Aug 13, 2022 10:54 am ] |
| Post subject: | Re: MESBG army building spreadsheet |
Hi LK, Noticed an issue with the Rangers of Ithilien. When adding rangers of gondor to anborn and mablungs warband they count against the bow limit when they should not. Cheers 
|
|
| Page 24 of 28 | All times are UTC |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|