All times are UTC


It is currently Fri Mar 29, 2024 8:05 am



Post new topic Reply to topic  [ 557 posts ]  Go to page Previous  1, 2, 3, 4, 5, 6, 7 ... 28  Next
Author Message
 Post subject: Re: SBG army builder among other things (updated for DoS)
PostPosted: Sun Sep 07, 2014 4:17 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 302
Location: Lisboa, Portugal
Should be ok, it is a very simple file after all.
Merely a combo of VLOOKUP, HLOOKUP, basic maths, CONCATENATE, IF (in a more advanced stage) and Conditional Formatting using a formula. All of these have direct equivalents between Excel and Google Sheets.
Not sure how the conversion handles named ranges but I'll be avoiding them anyway for this one.

_________________
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 builder among other things (updated for DoS)
PostPosted: Sun Sep 07, 2014 4:34 pm 
Elven Warrior
Elven Warrior
Offline

Joined: Mon Sep 07, 2009 2:12 pm
Posts: 665
Location: Hasselt, Belgium
Great, looking forward

_________________
Parva Mundi
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army builder among other things (updated for DoS)
PostPosted: Thu Sep 11, 2014 8:58 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 302
Location: Lisboa, Portugal
Apologies for the delay, having a job sucks. Should be able to finish the demo during the weekend.

_________________
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 builder among other things (updated for DoS)
PostPosted: Fri Sep 12, 2014 4:27 am 
Elven Warrior
Elven Warrior
Offline

Joined: Mon Sep 07, 2009 2:12 pm
Posts: 665
Location: Hasselt, Belgium
LonelyKnight wrote:
Apologies for the delay, having a job sucks. Should be able to finish the demo during the weekend.


No problem at all, no pressure :-D

_________________
Parva Mundi
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army builder among other things (updated for DoS)
PostPosted: Fri Sep 12, 2014 6:27 pm 
Elven Warrior
Elven Warrior
User avatar
Offline

Joined: Fri Mar 06, 2009 5:13 pm
Posts: 791
Location: Manchester UK
Images: 10
Demo for what bud?
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army builder among other things (updated for DoS)
PostPosted: Sat Sep 13, 2014 5:31 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 302
Location: Lisboa, Portugal
An alternate layout and way of selecting units

_________________
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 builder among other things (updated for DoS)
PostPosted: Sat Sep 13, 2014 8:42 pm 
Elven Warrior
Elven Warrior
User avatar
Offline

Joined: Fri Mar 06, 2009 5:13 pm
Posts: 791
Location: Manchester UK
Images: 10
Ahhhhhhhh
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army builder among other things (updated for DoS)
PostPosted: Wed Sep 24, 2014 7:00 pm 
Loremaster
Loremaster
User avatar
Offline

Joined: Sat Oct 09, 2010 11:20 am
Posts: 1776
IS there a place to view the special rules from profiles?
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army builder among other things (updated for DoS)
PostPosted: Thu Sep 25, 2014 12:20 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 302
Location: Lisboa, Portugal
Printable army lists have the special rules from the ones you select (scroll down)
The full list is to the right, past all the profiles, it's not listed alphabetically though.

_________________
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 builder among other things (updated for DoS)
PostPosted: Fri Dec 05, 2014 10:11 am 
Wayfarer
Wayfarer
User avatar
Offline

Joined: Mon Jun 06, 2011 3:18 pm
Posts: 43
I really love your army builder! It is very nicely done and works perfectly, use it for all the armies I build.
However, I noticed a tiny little mistake in the special rules for the Hasharii/Dalamyr I wanted to point out. In the army builder it says that the bane of kings special rule only applies in close combat, however, it applies to all the hasharii weapons. It's just a tiny little thing, but I hope you can change it as it will spare me and probably others the time to get a rulebook and find the hasharii in a tournament as well as having the correct rule in the builder if you don't own the rulebook and want to know the profile.
Again, many thanks.

Jelle

_________________
I love Goblins and I love strategy, so I'm TheGoblinTacticus

If I'm not using correct English, I'm really sorry but I'm Dutch
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army builder among other things (updated for DoS)
PostPosted: Fri Dec 05, 2014 4:02 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 302
Location: Lisboa, Portugal
Cheers
Fixed it, that was one outdated rule version. I hope I don't have too many of those around.

Also on the other thing I was doing for google sheets, I might as well upload the partial version I have since it's taking forever to find time to do it.

_________________
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 builder among other things (updated for DoS)
PostPosted: Fri Dec 05, 2014 4:44 pm 
Wayfarer
Wayfarer
User avatar
Offline

Joined: Mon Jun 06, 2011 3:18 pm
Posts: 43
LonelyKnight wrote:
Cheers
Fixed it, that was one outdated rule version. I hope I don't have too many of those around.


Thank you!

_________________
I love Goblins and I love strategy, so I'm TheGoblinTacticus

If I'm not using correct English, I'm really sorry but I'm Dutch
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army builder among other things (updated for DoS)
PostPosted: Mon Dec 15, 2014 9:34 pm 
Wayfarer
Wayfarer
Offline

Joined: Mon Oct 15, 2012 9:31 pm
Posts: 12
So can we expect the BotFA update any time soon? :-D
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army builder among other things (updated for DoS)
PostPosted: Mon Dec 15, 2014 10:29 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 302
Location: Lisboa, Portugal
stuff has been released??
crud
gonna look it up

EDIT: I'll check with my local store tomorrow

_________________
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 builder among other things (updated for DoS)
PostPosted: Wed Dec 17, 2014 9:27 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 302
Location: Lisboa, Portugal
Got zee book, should be done by the end of next weekend.
Need to add the new stuff and review the FaQs to make sure stuff didn't slip by me.

_________________
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 builder among other things (updated for DoS)
PostPosted: Wed Dec 17, 2014 10:03 pm 
Loremaster
Loremaster
User avatar
Offline

Joined: Sat Aug 17, 2013 9:14 am
Posts: 1121
Excellent, thanks for all the work you've put into this, much appreciated.
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army builder among other things (updated for DoS)
PostPosted: Thu Dec 18, 2014 4:47 pm 
Elven Warrior
Elven Warrior
User avatar
Offline

Joined: Fri Mar 06, 2009 5:13 pm
Posts: 791
Location: Manchester UK
Images: 10
Ye great work buddy
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army builder among other things (updated for DoS)
PostPosted: Fri Dec 19, 2014 12:41 am 
Wayfarer
Wayfarer
User avatar
Offline

Joined: Tue Sep 16, 2014 2:48 pm
Posts: 45
Looking forward to the latest version. Many thanks for creating such a fantastic hobby tool. I would be lost without it!
Top
  Profile  
Reply with quote  
 Post subject: Re: SBG army builder among other things (updated for DoS)
PostPosted: Sat Dec 20, 2014 3:25 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 302
Location: Lisboa, Portugal
Well the formulas are done I think.
Now I just need to do the "fun" part of updating the profile, special rules, magic powers, base wargear lists

_________________
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 builder among other things (updated for DoS)
PostPosted: Sat Dec 20, 2014 7:54 pm 
Craftsman
Craftsman
Offline

Joined: Fri Nov 10, 2006 10:00 pm
Posts: 302
Location: Lisboa, Portugal
New file is up.

_________________
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  [ 557 posts ]  Go to page Previous  1, 2, 3, 4, 5, 6, 7 ... 28  Next

All times are UTC


Who is online

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