| The One Ring http://one-ring.co.uk/ |
|
| MESBG army building spreadsheet http://one-ring.co.uk/viewtopic.php?f=42&t=22221 |
Page 16 of 28 |
| Author: | Natas234 [ Mon Jan 28, 2019 3:47 pm ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
Great job, thx! I notice that neither suladan nor cave troll profiles (in every army) appear in the profiles tables |
|
| Author: | LonelyKnight [ Sun Feb 03, 2019 10:03 pm ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
They seem to be appearing for me. Any specific selection that's causing it? Sorry for the delay. Currently adding in the Gondor at War profiles, and the Legendary Legions. |
|
| Author: | Natas234 [ Mon Feb 04, 2019 1:49 pm ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
I checked, and noticed that it doesn't appear when played with goulavhar. Soulandan IDK. Thx |
|
| Author: | Natas234 [ Mon Feb 04, 2019 1:54 pm ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
for the troll issue: I checked again in other armys and I noticed that the troll never seems to appear when played in the first warband |
|
| Author: | LonelyKnight [ Sat Feb 09, 2019 1:01 am ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
Seems to work on my end, no idea why it doesn't show for you. New version with Gondor at War is up |
|
| Author: | Natas234 [ Mon Feb 11, 2019 3:41 pm ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
Hello. I discovered the troll issue: when played in the first warband and equipped with the chain, it doesn't show up in the profiles table. Thx 4 gondor! |
|
| Author: | LonelyKnight [ Mon Feb 11, 2019 5:46 pm ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
oh right wargear combos change the id, will go try suladan combos as well to see if the error pops up EDIT: Aye, the horse makes him vanish EDIT 2: fixed, cheers ^-^ |
|
| Author: | Manadar [ Tue Feb 12, 2019 1:05 pm ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
There is something funky happening when adding the second Dragon Knight (Easterling), it is adding at the same time points from the captain below. I have figured it's tied to some error in columns "DO" to "EJ" but I can't understand what's their purpose sorry. |
|
| Author: | LonelyKnight [ Tue Feb 12, 2019 3:37 pm ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
The error was actually in column S, it was pointing at DO +1 instead of at the same line after that second dragon knight DO to EJ are actually quite simple to explain (well the basic function is simple to explain). Look at the numbers above (1-20), each column in DP to EI changes by 1 if they detect that the guy in that line had the number in his column in his warbands. Or in practical terms, write 1 3 in the warbands of a guy, then go to this section and you'll see that for the columns with 1 (DP) and 3 (DR) at the top it'll change from 1 to 2 after the line of that guy. These keys are then used to populate DE using the LOOKUP function (that part is a bit more complex with the INDEX use and all). EJ is a helper for the 1 (DP) column, since 1 can be found in 10-19 this helper cleans out those instances so that DP can find lone 1s, so it looks just like column R minus 10-19 DO is just a tally of how many times that hero was selected, sum of next line - sum of this line and you see how many times the +1 occurred, or in other words, in how many warbands it was selected. DN multiplies by 1 + extras (elladan and elrohir has 1 extra for example) and you get the full number of models. Will upload a bit later, copying some of the missing special rules text from the hobbit armies. EDIT: Updated |
|
| Author: | Scarten3 [ Wed Feb 13, 2019 3:09 pm ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
Thanks for updating the builder with the Legendary Legions so fast! Warriors of Minas Tirith have the cost of their War horn and Banner switched. This error also occurs in the "Rangers of Ithilien" Legendary Legion and in the "Men of the West" Legendary Legion. In the latter the error occurs for all available Warrior models. |
|
| Author: | Manadar [ Wed Feb 13, 2019 6:07 pm ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
Oh I see, that's quite clever how you manage to get this done. |
|
| Author: | LonelyKnight [ Thu Feb 14, 2019 4:18 pm ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
Cheers, the two legendary legions had been copied from Minas Tirith, hence the repeat of the error. |
|
| Author: | BrentS [ Wed Feb 27, 2019 4:28 am ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
I think I found a small error in the Théodens Host legendary legion. Elfhelm should cost 75 points and not 65. |
|
| Author: | LonelyKnight [ Wed Feb 27, 2019 6:18 pm ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
Aye, forgot to add the horse cost to that one Fixed, Cheers |
|
| Author: | praeternaturam [ Sun Mar 03, 2019 12:09 pm ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
This is such a great resource and I am glad to see it has been updated for the new rules. I am trying to include the Dwimmerlaik in an army list. I can select it, but then his profile does not appear on the Forces of Evil page - just on the first listing page. |
|
| Author: | LonelyKnight [ Mon Mar 04, 2019 1:12 pm ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
Cheers, fixed. Similar issue to the previously reported Suladan problem. |
|
| Author: | praeternaturam [ Tue Mar 05, 2019 8:11 am ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
Great - thank you! |
|
| Author: | praeternaturam [ Sat Mar 09, 2019 4:15 pm ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
Tried to download the new version 1.31 and seems there is an Error (401) for Dropbox? |
|
| Author: | LonelyKnight [ Mon Mar 11, 2019 10:58 am ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
The latest version is 1.32, your browser probably didn't refresh the website (and I deleted 1.31 from dropbox) |
|
| Author: | denbilicious [ Tue Mar 26, 2019 11:29 am ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
I think you have the wrong points value for mirkwood elves, they should be 9 not 10? |
|
| Page 16 of 28 | All times are UTC |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|