MESBG army building spreadsheet

LonelyKnight · **Posted:** Sun Sep 07, 2014 4:17 pm

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.

werner · **Posted:** Sun Sep 07, 2014 4:34 pm

Great, looking forward

LonelyKnight · **Posted:** Thu Sep 11, 2014 8:58 pm

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

werner · **Posted:** Fri Sep 12, 2014 4:27 am

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

ste271276 · **Posted:** Fri Sep 12, 2014 6:27 pm

Demo for what bud?

LonelyKnight · **Posted:** Sat Sep 13, 2014 5:31 pm

An alternate layout and way of selecting units

ste271276 · **Posted:** Sat Sep 13, 2014 8:42 pm

Ahhhhhhhh

Sticky Fingersss · **Joined:** Sat Oct 09, 2010 11:20 am **Posts:** 1776

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

LonelyKnight · **Posted:** Thu Sep 25, 2014 12:20 pm

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.

TheGoblinTacticus · **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

LonelyKnight · **Posted:** Fri Dec 05, 2014 4:02 pm

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.

TheGoblinTacticus · **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!

GrashnarTheSecond · **Joined:** Mon Oct 15, 2012 9:31 pm **Posts:** 12

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

LonelyKnight · **Posted:** Mon Dec 15, 2014 10:29 pm

stuff has been released??
crud
gonna look it up

EDIT: I'll check with my local store tomorrow

LonelyKnight · **Posted:** Wed Dec 17, 2014 9:27 pm

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.

Coenus Scaldingus · **Joined:** Sat Aug 17, 2013 9:14 am **Posts:** 1121

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

ste271276 · **Posted:** Thu Dec 18, 2014 4:47 pm

Ye great work buddy

Hands_Hammerhelm · **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!

LonelyKnight · **Posted:** Sat Dec 20, 2014 3:25 pm

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

LonelyKnight · **Posted:** Sat Dec 20, 2014 7:54 pm

New file is up.

MESBG army building spreadsheet

Who is online