The One Ring
http://www.one-ring.co.uk/

MESBG army building spreadsheet
http://www.one-ring.co.uk/viewtopic.php?f=42&t=22221
Page 4 of 28

Author:  LonelyKnight [ Sun Sep 07, 2014 4:17 pm ]
Post subject:  Re: SBG army builder among other things (updated for DoS)

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.

Author:  werner [ Sun Sep 07, 2014 4:34 pm ]
Post subject:  Re: SBG army builder among other things (updated for DoS)

Great, looking forward

Author:  LonelyKnight [ Thu Sep 11, 2014 8:58 pm ]
Post subject:  Re: SBG army builder among other things (updated for DoS)

Apologies for the delay, having a job sucks. Should be able to finish the demo during the weekend.

Author:  werner [ Fri Sep 12, 2014 4:27 am ]
Post subject:  Re: SBG army builder among other things (updated for DoS)

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

Author:  ste271276 [ Fri Sep 12, 2014 6:27 pm ]
Post subject:  Re: SBG army builder among other things (updated for DoS)

Demo for what bud?

Author:  LonelyKnight [ Sat Sep 13, 2014 5:31 pm ]
Post subject:  Re: SBG army builder among other things (updated for DoS)

An alternate layout and way of selecting units

Author:  ste271276 [ Sat Sep 13, 2014 8:42 pm ]
Post subject:  Re: SBG army builder among other things (updated for DoS)

Ahhhhhhhh

Author:  Sticky Fingersss [ Wed Sep 24, 2014 7:00 pm ]
Post subject:  Re: SBG army builder among other things (updated for DoS)

IS there a place to view the special rules from profiles?

Author:  LonelyKnight [ Thu Sep 25, 2014 12:20 pm ]
Post subject:  Re: SBG army builder among other things (updated for DoS)

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.

Author:  TheGoblinTacticus [ Fri Dec 05, 2014 10:11 am ]
Post subject:  Re: SBG army builder among other things (updated for DoS)

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

Author:  LonelyKnight [ Fri Dec 05, 2014 4:02 pm ]
Post subject:  Re: SBG army builder among other things (updated for DoS)

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.

Author:  TheGoblinTacticus [ Fri Dec 05, 2014 4:44 pm ]
Post subject:  Re: SBG army builder among other things (updated for DoS)

LonelyKnight wrote:
Cheers
Fixed it, that was one outdated rule version. I hope I don't have too many of those around.


Thank you!

Author:  GrashnarTheSecond [ Mon Dec 15, 2014 9:34 pm ]
Post subject:  Re: SBG army builder among other things (updated for DoS)

So can we expect the BotFA update any time soon? :-D

Author:  LonelyKnight [ Mon Dec 15, 2014 10:29 pm ]
Post subject:  Re: SBG army builder among other things (updated for DoS)

stuff has been released??
crud
gonna look it up

EDIT: I'll check with my local store tomorrow

Author:  LonelyKnight [ Wed Dec 17, 2014 9:27 pm ]
Post subject:  Re: SBG army builder among other things (updated for DoS)

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.

Author:  Coenus Scaldingus [ Wed Dec 17, 2014 10:03 pm ]
Post subject:  Re: SBG army builder among other things (updated for DoS)

Excellent, thanks for all the work you've put into this, much appreciated.

Author:  ste271276 [ Thu Dec 18, 2014 4:47 pm ]
Post subject:  Re: SBG army builder among other things (updated for DoS)

Ye great work buddy

Author:  Hands_Hammerhelm [ Fri Dec 19, 2014 12:41 am ]
Post subject:  Re: SBG army builder among other things (updated for DoS)

Looking forward to the latest version. Many thanks for creating such a fantastic hobby tool. I would be lost without it!

Author:  LonelyKnight [ Sat Dec 20, 2014 3:25 pm ]
Post subject:  Re: SBG army builder among other things (updated for DoS)

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

Author:  LonelyKnight [ Sat Dec 20, 2014 7:54 pm ]
Post subject:  Re: SBG army builder among other things (updated for DoS)

New file is up.

Page 4 of 28 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/