All times are UTC


It is currently Thu Nov 28, 2024 2:50 am



Post new topic Reply to topic  [ 564 posts ]  Go to page Previous  1 ... 10, 11, 12, 13, 14, 15, 16 ... 29  Next
Author Message
 Post subject: Re: SBG army building spreadsheet ME SBG update
PostPosted: Sun Sep 30, 2018 5:24 pm 
Wayfarer
Wayfarer
Offline

Joined: Tue Sep 25, 2018 10:15 am
Posts: 2
Hey,

I found another bug:
The equipment for Moria Goblin Warriors is not added to their point costs.

Thanks!
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet ME SBG update
PostPosted: Sun Sep 30, 2018 8:31 pm 
Wayfarer
Wayfarer
Offline

Joined: Sun Sep 30, 2018 8:19 pm
Posts: 1
Thx for this awesome builder!
Could you include the army bonus text for the factions?

Moria Goblin Captain Shields are 1p (should be 5)
Moria Goblin Captains have D4 (should be 5)
Gothmog has 3 Fate (should be 1)
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet ME SBG update
PostPosted: Sun Sep 30, 2018 9:51 pm 
Wayfarer
Wayfarer
Offline

Joined: Thu Sep 27, 2018 7:20 pm
Posts: 2
LonelyKnight wrote:
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

Well I found another program called LibreOffice. It still complains that it's too big but atleast it will load it unlike OpenOffice.
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet ME SBG update
PostPosted: Mon Oct 01, 2018 1:00 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
Fixed the goblin equipment formulas.

The army bonuses that are built into army choices should already be implemented (like bow limit, warbands without heroes, extra warband capacity and stuff)
The profiles for the printable stuff aren't updated yet, the text of the army bonus will be added to the "Special Rules" page when that part is working. Might take a while to go through all that and update that part.

Not sure how much smaller the size could get to keep the one size fits all

_________________
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: Tue Oct 02, 2018 1:05 pm 
Craftsman
Craftsman
User avatar
Offline

Joined: Thu Dec 26, 2013 12:08 pm
Posts: 252
Location: USA
Did you ever think of splitting it to 2 spreadsheets? Evil and Good?

_________________
Xintao
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet ME SBG update
PostPosted: Tue Oct 02, 2018 3:14 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
That would actually work, the formulas don't interact at all between them.
Dunno if some peeps would prefer to still have a version with both in them, guess I can keep all three up.

_________________
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: Tue Oct 02, 2018 7:40 pm 
Wayfarer
Wayfarer
Offline

Joined: Mon Sep 24, 2018 7:20 pm
Posts: 4
Some issues with the Thranduil's Halls list:

-Mirkwood Rangers count towards bow limit, even when led by the heroes that should allow them to take 100% bows
-Tauriel's bow only costs a single point, as opposed to five.
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet ME SBG update
PostPosted: Wed Oct 03, 2018 2:22 pm 
Wayfarer
Wayfarer
Offline

Joined: Wed Oct 03, 2018 2:04 pm
Posts: 1
in the Easterlings section:
Black Dragon Kataphracts are 14 points instead of 16
Easterling Captains pay 15 points for their armoured horse rather then 10
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet ME SBG update
PostPosted: Wed Oct 03, 2018 9:58 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
huh, I missed that army bonus, now it's even better:
Quote:
Army Bonus: Mirkwood Rangers from this force do not count towards the army’s Bow Limit. Additionally, whilst they are within 3” of Thranduil, all Palace Guard Captains, Mirkwood Elf Captains, Palace Guard, Mirkwood Cavalry and Mirkwood Elves will also gain +1 to their To Wound rolls when making Strikes.

Now they are flat-out 100% if the army bonus is there.

I'll upload tomorrow, apparently I've already burned a good chunk of the website traffic so I'll try moving the file itself somewhere else and link to that for download. (also wanna try to lower the full size and do the split so users can open it more easily)

_________________
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: Fri Oct 05, 2018 8:57 am 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
fixed the thranduil and easterling stuff

changed it to dropbox, still haven't touched the size but that should keep the free website from colapsing

_________________
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 Oct 08, 2018 11:30 pm 
Wayfarer
Wayfarer
Offline

Joined: Mon May 02, 2016 7:35 pm
Posts: 29
Thank you again Lonely Knight for your fantastic army builder!

I did notice the Mumak War Leader is missing from Far Harad. His revised rules can be found here:

https://www.forgeworld.co.uk/resources/PDF/Downloads/War_Mumak_Leader.pdf
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet ME SBG update
PostPosted: Tue Oct 09, 2018 8:57 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
That mumâk looks awesome, wonder why they omitted him in the far harad army listing, I hadn't realized it had different rules.
Sooo
Gonna upload as soon as I fix this tiny weeny error where every single evil sheet has the total units and points of the good guys cause potato
EDIT: forgot to mention I'm adding the split good and evil versions

_________________
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 Oct 10, 2018 4:02 pm 
Loremaster
Loremaster
User avatar
Offline

Joined: Sat Aug 17, 2013 9:14 am
Posts: 1121
The War Leader's rules were written after the book was finished (same with other upcoming releases - Húrin, Skully, etc.). Should all be in the upcoming expansion.
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet ME SBG update
PostPosted: Wed Oct 10, 2018 7:36 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
Húrin is coming?
I'd heard about skully (I cannot member his name, even though I already added him) but damn, are we finally getting silmarilion? Or is it a steward of Gondor?

_________________
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 Oct 10, 2018 8:40 pm 
Wayfarer
Wayfarer
Offline

Joined: Mon May 02, 2016 7:35 pm
Posts: 29
It’s Hurin the Tall, Warden of the Keys of Minas Tirith. Pictures of him and Ingold, Warden of the Rammas have already been released! The Silmarillion has never been licensed by the Tolkien Estate to anyone, film studio or otherwise
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet ME SBG update
PostPosted: Thu Oct 11, 2018 4:35 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
Awww, pity. Still new stuff is welcome (skull on head guy!), I don't keep up with the rules quite as much so if I haven't added something it's quite likely that I'm not aware it exists.

Will finally have some free time to start redoing the profile db for the printable part.
Still unsure if it's worth doing that or if I should just try to make a version that runs on a browser with simpler functionality.

_________________
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 Oct 14, 2018 8:16 am 
Wayfarer
Wayfarer
User avatar
Offline

Joined: Thu Apr 03, 2014 2:25 pm
Posts: 20
Don't know if it's just me, but since the change to the dropbox I get an error when I click the link and can't access the builder :/
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet ME SBG update
PostPosted: Sun Oct 14, 2018 11:38 am 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
odd, works for me

does this link work?
https://www.dropbox.com/s/tu4lbegeipl60 ... b.zip?dl=0
the one in the site is the direct link, this one sends to dropbox first

_________________
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 Oct 24, 2018 9:42 pm 
Wayfarer
Wayfarer
Offline

Joined: Mon Sep 24, 2018 7:20 pm
Posts: 4
Couple of issues with Azog's Legion:

-Wargear for the Gundabad Orc Warriors (banners, shields, spears...) don't cost any points
-Azog's warband limit isn't increased to 24 when taking the signal tower
-Azog's name is spelled Azof :lol:
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army building spreadsheet ME SBG update
PostPosted: Thu Oct 25, 2018 10:05 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 306
Location: Lisboa, Portugal
Everyone knows Azof, he's Azog's less charismatic cousin :oops:
Fixed those 3 things, and a weird fail on the formulas for the mid section

Also... umm you know the huge size of the file? Arnor, dunno why but that one was counting every single cell in the entire sheet as active, which made it take up an entire 2MB alone :|
Might be why some peeps were having trouble opening it as well.

New version is up, cheers

_________________
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 ... 10, 11, 12, 13, 14, 15, 16 ... 29  Next

All times are UTC


Who is online

Users browsing this forum: No registered users and 14 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: