Any interested in squad building & commander/gear tracking spreadsheet
EDIT: Here's the link finally: http://www.mediafire.com/download/ujwtpe2a9m2rp83/Blood_Brothers_2_-_Squad_Builder.xlsm
Given that I work with this kind of stuff all the time and I'm a super nerd...I've made an Excel document for my own personal use. It contains 3 sheets. The first lists my commanders each in their own groups (one table for Melee, one for Cavalry, one for Archers). The second table lists my gear (one table for Equipment, one for Souls). The last table is where things get more 'interesting' and it's where I potentially thought others might benefit from it. Also, if more people are using it I'll be more motivated to add additional features to it etc. Any input on that front would be welcomed.
The third sheet contains 3 tables for each squad. Simply enter the name of the commander and it automatically pulls the base stats from the first page. There are then 2 dropdown lists for each commander (one for gear one for soul) which pulls in the gear and souls you have listed on the second sheet. When you select a soul or gear the stats are automatically updated to reflect your gear choices.
Basically here's how I use the workbook currently.
1) Remove all gear from my commanders in game
2) Sort my commanders by strength and assign them based on the appropriate type (archer/melee/cav) for the given event...obviously taking into account special skills like regen might put a weaker commander like Terul in a stronger squad. Sorting by strength is still a pretty effective way to quickly put commanders in squads
3) Once all squads are formed I enter the names on the 3rd sheet in my workbook. I can then quickly look at all the stats at once to see if i want to move anyone around. Once that's done I can also quickly see how i want to boost the stats of my commanders. You all probably know how you want to do this by now but for any newer players i usually look at 1 or 2 stats that I want to focus on. Maybe i mostly want to boost attack but secondarily also want to boost defense or wisdom. I can then flip to my second sheet and see which souls and gear will accomplish that for me and then assign them via the dropdowns on the 3rd sheet for each commander. (There is a quantity field AND an unassigned field that let me know how many of an Item i have as well as how many i have left to potentially assign to a commander)
4) Once i've assigned all gear/souls on my 3rd sheet I can go into the game and very quickly assign those souls/gear to the appropriate commanders. This is much faster than going back and forth in the game UI and resorting by different stats or clicking on each soul to see what boosts it gives. Obviously for gear this isn't as much of an issue as most just boost one or two stats, but for souls this is very useful.