Warlord mini list builder

[dewen]

It is nothing like the tool others are working on, but functions as a simple list builder. The important part is that it contains all the data :)

 

Minor Update 10/15/2007

Moandain was missing Spy and Tactician. I accidently typed it into Mister Blood

 

Fixed the buggy elite calculation. The elite calculation does not consider the qty, so only enter 1. If you have more than one of a non-unique elite, they need to be on separate lines.

 

Reformatted footer

 

BIG UPDATE 6/25/2007

Warlord List

Warlord List Example

 

***NEW***

New Models

Models available to Factions and sublists are filtered by selection

Non-Unique/Grunt determination by Faction and Sublist is determined for you

Updated Spell Points

Holy Symbol Added

 

*** WAS NEW ***

Outrider handled by Upgrade (only way I could handle it)

Totals for leaders, including elites

Totals for spells

Several warnings are displayed in red. For example if you do not follow the troop limits or spell grade limits of a model

 

Tips

Make sure you work top to bottom and across. If you go back and change the faction after completing the entire list, it will cause problems.

 

The white areas are the fields that you should be entering info. The colored areas have calculations and lookups.

 

Faction – Select first. Includes the sublists which are prefixed by the main faction.

# – Identifies the model in the troop. Used to associate Upgrades and Spells to a model by enter this number from the troops section in the Upgrades and Spells

Tr – A number to identify which Troop the model is in

Model Nume – If you don’t know what this is, maybe you shouldn’t be using the sheet :P

Qty – Quantity or number of model or Spells is a caster selects more than one Bolt for example.

Model Num – Reaper’s Model Number

Faction – hmmmm…you better know this one too

Al – Model’s alignment (G = Good, E = Evil, N = Neutral)

Rank – Model’s Rank. (U) Indicates if the model is unique. The Rank should change when selecting a faction or sublist for those Models that change to Non-Unique/Grunt

Troop – Leader models Troop stats

Troop Use – For Leader models the first column is the total number of models assigned to the leader including the leader. This is derived from the Tr assignment. The second column is the number of elites assigned. If either of these do not meet the Leader’s limits, they will be displayed in red.

Pts – Model’s point value

Up Pts – Total Upgrade points assigned to the model. This is derived from the models # column as it correlates to the Troop # and the Upgarde #

Pts – If the model is a caster, the type is displayed here with its grade and spell limit

Sp Pts – Total number of Spell points assigned to the model. This is derived from the models # column as it correlates to the Troop # and the Spell #

Sp Gr – Total number of Spell Grade used for the model. Example: If a model has two Cure 2 spells assigned, the Sp Gr would be 4 = 2 x Grade 2 spells

Ttl Pts – Total number of points for the row in the troop.

 

Thanks for the feedback

[wildbill]

I am not sure how difficult my suggestion would be to code in, so if it's uber-tough, I apologize.

 

Since you already have a drop down box to select the Faction you are playing, is it possible to have your spreadsheet automatically weed out all of the other factions based upon the faction you choose? Example: If I choose Darkspawn, the only models I see available are the Darkspawn ones.

 

And one other suggestion: can you add Freelance to the list of possible factions? And, if you can do my first suggestion, then when you select Freelance every model would show up since that is how Freelance works.

 

Wild Bill

 

 

Edit: I also added Outrider to the list of Upgrades as well. That was accidentally overlooked!

[dewen]

I am not sure how difficult my suggestion would be to code in, so if it's uber-tough, I apologize.

 

Since you already have a drop down box to select the Faction you are playing, is it possible to have your spreadsheet automatically weed out all of the other factions based upon the faction you choose? Example: If I choose Darkspawn, the only models I see available are the Darkspawn ones.

 

And one other suggestion: can you add Freelance to the list of possible factions? And, if you can do my first suggestion, then when you select Freelance every model would show up since that is how Freelance works.

 

Wild Bill

 

 

Edit: I also added Outrider to the list of Upgrades as well. That was accidentally overlooked!

I am currently trying to determine the best way to do that. Right now, I remove all the models from the list for the faction I am building. That's not convienent with the number of factions available. I play three, so I could maintain 3 list builders.

 

Something that is coming soon...new columns on the troop/model to determine the total cost of upgrades, total cost of spells, and the total number of spell grades used per model. Those are useful for bounty points.

[wildbill]

I had a spreadsheet at home that I had developed around the Knotthorn map in the back of the Rulebook in the Campaign Section. I had those drop down menus and a ton of cells with all of these If-Then statements regarding what happens depending on the selection. But, it was essentially a display, not creating another drop down menu. I'm sure it can be done, but I'm not computer programming whiz-y enough to help much more than that.

 

Wild Bill

[mattmcl]

I had something go weird. When I sorted the Models sheet by Faction, the stats on the List sheet got wonky- they were pulling the stats from different models. I made sure to include the entire rows when sorting too. The one model that I can remember having problems was the Isiri Warrior.

 

This sheet rocks! Thanks.

[shakhak]

@Dewen

You may be climbing that management ladder, but you're a programmer at heart.... Even if you have to use excel to vent lol

 

 

This thing is pretty sweet. I still have a hard time giving up control when I build an army list. It's stupid, but I like to have my hands in everything.

[dewen]

I had something go weird. When I sorted the Models sheet by Faction, the stats on the List sheet got wonky- they were pulling the stats from different models. I made sure to include the entire rows when sorting too. The one model that I can remember having problems was the Isiri Warrior.

 

This sheet rocks! Thanks.

I need to change the lookup type I am doing to handle the models not being sorted by name. If they are not sorted by name, the values that are pulled from the models tab are goofed.

[dewen]

@Dewen

You may be climbing that management ladder, but you're a programmer at heart.... Even if you have to use excel to vent lol

true...reduced to MS Office tools It may turn into a full blown application when I can no longer get what I want out of Excel and begin using a real tool...VS Studio 2007

This thing is pretty sweet. I still have a hard time giving up control when I build an army list. It's stupid, but I like to have my hands in everything.

I am going to continue to improve on these. I post as I make the improvements. I wanted to get what I had complete out.

 

1> Change the lookup

2> Total model upgrades pts, spell pts, and spell grade

3> Apply filtering to limit available models to faction and sub lists

[dewen]

Added the following:

1) Total model upgrades pts, spell pts, and spell grade.

2) Total Number of Cards for Initiative - Includes SA Tactician model plus number of troops. Book of tactics also included.

2) Total Number of Spies - Includes SA Spy models and Shadowy Contacts

 

All feedback is appreciated

[wildbill]

You didn't add Freelance to the army choices and you didn't add Outrider either.

 

I know Outrider is a SA, not an item, but the points need to be counted for somehow!

 

Wild Bill

[dewen]

You didn't add Freelance to the army choices and you didn't add Outrider either.

 

I know Outrider is a SA, not an item, but the points need to be counted for somehow!

 

Wild Bill

Those are the next two features :)

 

I have been spending a great deal of time with the model list being filtered by selected faction. I know it will work, but it is a lot of work.

[mattmcl]

The new changes rock. THanks!

[Millerthyme]

I love this spreadsheet! I have two requests though:

 

1.) If you have selected a spell caster for your army, filter out the spells he is available to take i.e. Mage with 3/10 is selected and the drop down menu will only show Mage spells up to level 3 or a Cleric 2/8 and the drop down list will only show Cleric spells up to level 2.

 

2.) I'm not too sure if this has been added or not but add the capability for the Outrider option. I was thinking something along the lines of the models with the outrider capability be identified on the models workbook. Then if they are selected in the army list being built, a hidden column will appear with the option of marking it as an Outrider or not. If the option is marked "yes" it will add the additional 15 points to the models cost.

[dewen]

I love this spreadsheet! I have two requests though:

 

1.) If you have selected a spell caster for your army, filter out the spells he is available to take i.e. Mage with 3/10 is selected and the drop down menu will only show Mage spells up to level 3 or a Cleric 2/8 and the drop down list will only show Cleric spells up to level 2.

Complete

2.) I'm not too sure if this has been added or not but add the capability for the Outrider option. I was thinking something along the lines of the models with the outrider capability be identified on the models workbook. Then if they are selected in the army list being built, a hidden column will appear with the option of marking it as an Outrider or not. If the option is marked "yes" it will add the additional 15 points to the models cost.

Outrider is handled through Upgrades

[dewen]

What's new?

Lots and lots

Models available to Factions and sublists are filtered by selection including the determination of model being unique

Outrider handled by Upgrade (only way I could handle it)

Totals for leaders, including elites

Totals for spells

Several warnings are displayed in red. For example if you do not follow the troop limits or spell grade limits of a model

 

Tips

Make sure you work top to bottom and across. If you go back and change the faction after completing the entire list, it will cause problems.