All times are UTC


It is currently Thu Nov 28, 2024 6:45 pm



Post new topic Reply to topic  [ 564 posts ]  Go to page Previous  1 ... 9, 10, 11, 12, 13, 14, 15 ... 29  Next
Author Message
 Post subject: Re: SBG army building spreadsheet Hobbit Trilogy update
PostPosted: Wed Sep 19, 2018 5:49 am 
Elven Warrior
Elven Warrior
User avatar
Offline

Joined: Mon Mar 10, 2014 10:02 pm
Posts: 659
Location: Greece
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.

_________________
Conversation/Ideas over painting etc, can check here:
http://www.one-ring.co.uk/viewtopic.php?f=50&t=29455
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet Hobbit Trilogy update
PostPosted: Sat Sep 22, 2018 11:00 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
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 :P

_________________
Tired of building armies with pen and paper? Try this handy spreadsheet for SBG. Download it here
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet ME SBG update
PostPosted: Sun Sep 23, 2018 3:36 am 
Craftsman
Craftsman
User avatar
Offline

Joined: Thu Dec 26, 2013 12:08 pm
Posts: 252
Location: USA
Thank you so much for your time and effort.

_________________
Xintao
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet ME SBG update
PostPosted: Sun Sep 23, 2018 7:21 am 
Loremaster
Loremaster
User avatar
Offline

Joined: Sat Aug 17, 2013 9:14 am
Posts: 1121
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.
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet ME SBG update
PostPosted: Sun Sep 23, 2018 9:54 am 
Wayfarer
Wayfarer
Offline

Joined: Sun Sep 23, 2018 9:45 am
Posts: 2
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!
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet ME SBG update
PostPosted: Sun Sep 23, 2018 11:14 am 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
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

_________________
Tired of building armies with pen and paper? Try this handy spreadsheet for SBG. Download it here
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet ME SBG update
PostPosted: Sun Sep 23, 2018 12:39 pm 
Wayfarer
Wayfarer
Offline

Joined: Sun Sep 23, 2018 9:45 am
Posts: 2
Apologies - Ignore the banner one. I think I accidentally removed a formula!
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet ME SBG update
PostPosted: Sun Sep 23, 2018 1:14 pm 
Kinsman
Kinsman
Offline

Joined: Tue Aug 17, 2004 5:13 pm
Posts: 63
Location: Richmond VA
Great job, as usual. Thanks.

_________________
Lost Pict :sauron:

http://sfdfsfd.wordpress.com/
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet ME SBG update
PostPosted: Sun Sep 23, 2018 4:01 pm 
Loremaster
Loremaster
User avatar
Offline

Joined: Sun Dec 16, 2012 4:21 pm
Posts: 1614
Location: Watford, UK
Elrond's Heavy Armour is only 5pts. Should be 10.
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet ME SBG update
PostPosted: Sun Sep 23, 2018 6:28 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
LordElrond wrote:
Elrond's Heavy Armour is only 5pts. Should be 10.

That error coupled with the username and the pic 8)

Lindir also had the same error
Cheers

_________________
Tired of building armies with pen and paper? Try this handy spreadsheet for SBG. Download it here
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet ME SBG update
PostPosted: Mon Sep 24, 2018 6:51 am 
Wayfarer
Wayfarer
User avatar
Offline

Joined: Thu Apr 03, 2014 2:25 pm
Posts: 20
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.
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet ME SBG update
PostPosted: Mon Sep 24, 2018 12:36 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
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

_________________
Tired of building armies with pen and paper? Try this handy spreadsheet for SBG. Download it here
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet ME SBG update
PostPosted: Mon Sep 24, 2018 7:25 pm 
Wayfarer
Wayfarer
Offline

Joined: Mon Sep 24, 2018 7:20 pm
Posts: 4
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.
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet ME SBG update
PostPosted: Tue Sep 25, 2018 3:33 pm 
Wayfarer
Wayfarer
Offline

Joined: Tue Sep 25, 2018 10:15 am
Posts: 2
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?
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet ME SBG update
PostPosted: Tue Sep 25, 2018 4:38 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
put them at the end in red for now and added the extra morannon

_________________
Tired of building armies with pen and paper? Try this handy spreadsheet for SBG. Download it here
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet ME SBG update
PostPosted: Wed Sep 26, 2018 5:25 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
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

_________________
Tired of building armies with pen and paper? Try this handy spreadsheet for SBG. Download it here
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet ME SBG update
PostPosted: Wed Sep 26, 2018 5:39 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
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

_________________
Tired of building armies with pen and paper? Try this handy spreadsheet for SBG. Download it here
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet ME SBG update
PostPosted: Thu Sep 27, 2018 7:24 pm 
Wayfarer
Wayfarer
Offline

Joined: Thu Sep 27, 2018 7:20 pm
Posts: 2
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 ?
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet ME SBG update
PostPosted: Fri Sep 28, 2018 1:19 pm 
Kinsman
Kinsman
User avatar
Offline

Joined: Sat May 28, 2016 9:15 am
Posts: 217
Location: Netherlands
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.
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet ME SBG update
PostPosted: Fri Sep 28, 2018 3:11 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
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

_________________
Tired of building armies with pen and paper? Try this handy spreadsheet for SBG. Download it here
Top
  Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 564 posts ]  Go to page Previous  1 ... 9, 10, 11, 12, 13, 14, 15 ... 29  Next

All times are UTC


Who is online

Users browsing this forum: No registered users and 4 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to: