FREE Army Builder for SBG

Let's hunt some Orc! For discussion of tactics and army lists for the LotR: Strategy Battle Game.

Moderators: Rangers, Leaders

User avatar
Site Admin
Posts: 1040
Joined: Mon Sep 21, 2009 9:15 am

FREE Army Builder for SBG

Mon Nov 30, 2015 9:46 am

Lonely Knight updated his Free Army builder a few weeks ago, so I thought I had better mention it to some of our newer members. It is really useful and a time saver.

Army building spreadsheet for SBG

Need an easy way to build your armies? Try this builder.
Instructions are included in the file

Last updated 06/10/2015 17:58 for the Battle of the Five Armies profiles

Links to the threads where you can report errors or sugest changes on TLA and on TOR

User avatar
Posts: 72
Joined: Thu Nov 12, 2015 1:58 pm

Re: FREE Army Builder for SBG

Mon Nov 30, 2015 11:52 pm

LOTR: 3000pts ANGMAR, 1200 MINAS TIRITH, 2000 DWARFS, 12000 ELVES. I HAVE A PROBLEM... not enough models. :mrgreen:

User avatar
Site Admin
Posts: 1040
Joined: Mon Sep 21, 2009 9:15 am

Re: FREE Army Builder for SBG

Tue Dec 01, 2015 2:25 am

Introduction (by Lonely Knight)
This is an Excel file created to aid in army building. It does not include certain restrictions such as being only able to take a single named hero or one banner per hero so keep those in mind when using this tool.
It was created using the 2010 version but saved in the old format for compatibility with any users that lack the new version.
This is very important: NEVER drag cells around, seriously it messes up the formulas.
The entire document might be protected as a precaution but there is no password so feel free to unprotect it.
The file may be set as read only, since the army creator has an allies system it would be unadvisable to leave an army on the creator. This can also be easily changed in the file’s properties if you wish to do it.

When you enter you see links to every army list on the file arranged according to the sourcebooks where you can find them. There is no link back to this page, but you can easily select it by clicking the 'INDEX' tab on the bottom.
You can also navigate the file using the bottom tabs if you prefer.
In this sheet you can also find a few extras to the right and… well these instructions.

Building Armies
In every army list the top bar is fixed, in this bar you can see a list of equipment/options that each unit may take.
To select a certain equipment for a unit insert a 1 in the proper square in front of the unit’s name, the squares turn green to show the equipment is selected. Some equipment can be purchased more than once, for those you may insert an appropriate number
Once you have selected all the options you desire you can select the unit using the Warband column(s).
If you are selecting a Hero insert the number of the warband you wish said hero to lead. Each army list allows you to select up to 20 warbands so insert a number between 1 and 20 to have the Hero lead the chosen warband. If you wish to have equal Heroes leading different warbands just write both warbands like this: 1 2 or 1,2 or 1;2 or any other combination. Separate the numbers in some way. Remember that you can't have 2 of any named Hero.
If you are selecting a Warrior just insert the number you wish to take in the column of the warband you wish to place them in. You can use the same line to place similar Warriors in all warbands if you choose to.
The Units and Points in that army list can be found in the top bar along with the Bow Limit count and the Total Units and Total Points across all allied armies. The Bow Limit count turns red if you go over the limit.
Right below these values there is a blank space where the warbands you select will appear, if you take too many warriors in a warband it will turn red. You can see how many Warriors you can still add next to the warband number.

If you are using allies you can use the ALLIES CHART. Clicking that link will show you a list of all the allies you can take; you can also see how many points and units each allied army has so far. Clicking on an ally will take you to that army list, clicking on the ARMY CHART link will take you back to the army list in that sheet
Or you could just use the tabs below to navigate, up to you.

User avatar
Posts: 79
Joined: Sat Nov 07, 2015 3:05 pm

Re: FREE Army Builder for SBG

Tue Dec 01, 2015 10:04 am

Thanks Lonely Night.

Posts: 18
Joined: Tue Jan 05, 2016 3:35 pm

Re: FREE Army Builder for SBG

Wed Feb 03, 2016 11:55 pm

Long live the Lonely Knight!

He has made list writing such a pleasure!


Return to SBG Army Building & Tactics

Who is online

Users browsing this forum: No registered users and 7 guests