Ok, version with no printable army lists is up.
Dunno when the printable part will be done, might take a while.
Guess it's time to see how many mistakes I made
| 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 12 of 28 |
| Author: | Valadorn [ Wed Sep 19, 2018 5:49 am ] |
| Post subject: | Re: SBG army building spreadsheet Hobbit Trilogy update |
Yes of course. It would save as a lot of time, even if it has minor mistakes. And after that, whenever v1.0 comes, I think ppl are not hasty about that. |
|
| Author: | LonelyKnight [ Sat Sep 22, 2018 11:00 pm ] |
| Post subject: | Re: SBG army building spreadsheet Hobbit Trilogy update |
Ok, version with no printable army lists is up. Dunno when the printable part will be done, might take a while. Guess it's time to see how many mistakes I made
|
|
| Author: | Xintao [ Sun Sep 23, 2018 3:36 am ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
Thank you so much for your time and effort. |
|
| Author: | Coenus Scaldingus [ Sun Sep 23, 2018 7:21 am ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
Excellent! Time to throw my vastly inferior scratch-built version out of the window immediately. Thanks for all the time and effort, again. Will share the news on the GBHL page, I know the new version was much anticipated. |
|
| Author: | Liability [ Sun Sep 23, 2018 9:54 am ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
Couple of issues with the Isengard page: - Uruk-hai warriors with banners appear blank on the list. - Lurtz should have an option for a shield, not armour. Thanks for your work. I wish I was this good at Excel! |
|
| Author: | LonelyKnight [ Sun Sep 23, 2018 11:14 am ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
Fixed the Lurtz thing, can't seem to replicate the problem with uruk-hai warriors, what's the exact selection that's doing it? If you wanna mess around with the formulas there are two hidden sheets that have the blank formulas. Left them in, in case someone wanted to make their own fan made army lists (like the old Fall of Gondolin supplement). Should prolly write somewhere what needs to be edited where to get it working |
|
| Author: | Liability [ Sun Sep 23, 2018 12:39 pm ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
Apologies - Ignore the banner one. I think I accidentally removed a formula! |
|
| Author: | lostpict [ Sun Sep 23, 2018 1:14 pm ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
Great job, as usual. Thanks. |
|
| Author: | LordElrond [ Sun Sep 23, 2018 4:01 pm ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
Elrond's Heavy Armour is only 5pts. Should be 10. |
|
| Author: | LonelyKnight [ Sun Sep 23, 2018 6:28 pm ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
LordElrond wrote: Elrond's Heavy Armour is only 5pts. Should be 10. That error coupled with the username and the pic  Lindir also had the same error Cheers |
|
| Author: | KilljoyPowerhead [ Mon Sep 24, 2018 6:51 am ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
Only thing that I found was the builder adds 5 points for Lurtz's shield, when it's meant to be free - but I imagine that's an easy fix. Cheers for the hard work, bud. You have a paypal link? Really think people should be able to donate a couple of bucks to you for it. |
|
| Author: | LonelyKnight [ Mon Sep 24, 2018 12:36 pm ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
Poor Lurtz, two edits already. I do have a paypal, will add a link to it on the site later. Never really used it much, just have it for some online purchases |
|
| Author: | Grashnar [ Mon Sep 24, 2018 7:25 pm ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
Would it be possible to add both Guritz and Gothmog's Enforcer to the Mordor army list? Their (experimental) rules have already been shown in a Warhammer TV stream and the models have already been available at both Ardacon and the Games Day in Germany. They're Heroes of Valour and cost 60 pts. Also, is it possible to add an additional line for the Morannon Orcs? Right now, there's four lines but if I take a mix of Orcs with hand weapon, Orcs with shield, Orcs with spear and Orcs with spear & shield, I don't have room to add my Banner Orc. |
|
| Author: | Akuyi [ Tue Sep 25, 2018 3:33 pm ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
Hi, first of all: thanks for your work! The army builder is a really great tool! We found a bug on the dead of dunharrow page: The additional armour is not calculated to the total costs for the unit (Warriors and Riders of the Dead). And on the Minas Tirith page I'm not sure if it is a bug or if I'm using the tool in a wrong way. When I add the Gondor Avenger Bolt Thrower to my list, it automatically adds the siege veteran. But the second warrior of the crew is missing. The profile of the gondor avenger bolt thrower describes the crew as 2 warriors with heavy armour and sword and one of them is automatically the siege veteran. Is this a bug or my fault? |
|
| Author: | LonelyKnight [ Tue Sep 25, 2018 4:38 pm ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
put them at the end in red for now and added the extra morannon |
|
| Author: | LonelyKnight [ Wed Sep 26, 2018 5:25 pm ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
huh, I forgot to add the points calculations to the warriors of the dead entirely :| I was about to say that the avenger bolt thrower comes by default with 2 guys so only the leader appears and the rest is implicit in the pop. Then I noticed it adds 3 pop when I add one, need to redo the siege portions (also forgot to add the siege warriors to the bow limit) Will go fix that, will upload soon |
|
| Author: | LonelyKnight [ Wed Sep 26, 2018 5:39 pm ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
holycow I screwed in pooch in many ways in the siege engines, this might take a couple of minutes longer. If it's easier to read, I could change the "Additional Crew" writing when you add extra crew (that is only showing correctly in the minas tirith right now) to just crew, and have it as a permanent number that always displays the current number of crewman. Fairly easy change, dunno which one peeps would prefer EDIT: uploaded and added a paypal.me link in the sidebar |
|
| Author: | Jashmyne [ Thu Sep 27, 2018 7:24 pm ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
For some reason I can't get this to work. Openoffice the file just goes into eternal loading. Google Calc flat out refuse to open it along with a few others stating that the file is too big to be opened. Anyone else got that problem and possible fix ? |
|
| Author: | MacCollac [ Fri Sep 28, 2018 1:19 pm ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
Independent heroes that are put in warbands are not counted for in the warband size. For example, when I put an orc drummer in gothmog's warband it doesn't count towards the size. |
|
| Author: | LonelyKnight [ Fri Sep 28, 2018 3:11 pm ] |
| Post subject: | Re: SBG army building spreadsheet ME SBG update |
Fixed the independent guys issue, cheers. The file is considerably larger than the previous one, think it's mostly cause of the extra space the formulas for the new hero interactions take. Could be smaller in most sheets but then you wouldn't have a one size fits all set of formulas. Dunno why OpenOffice isn't opening it, there were quite a few people using it to use it, guess they'll have better feedback than me on that issue |
|
| Page 12 of 28 | All times are UTC |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|