#### Duncan MacLeod

##### New Member

- Joined
- Jul 6, 2008

- Messages
- 5

I've been rehabilitating myself to the brilliance of Excel after years of cruelly shunning it due to poor handlings of it by my teachers of the old school:

I didn't count then on my obsessive compulsive nature, which now neccessitate a prompt return to Excel and its functions. Microsoft Office has generally been good as its readily available all the time...

So I'd like to use Excel for the following task -

Basically, I have this game (Patapon,) and it has crazy mechanics in place for attributing its various stats.

And, because I'm crazy, I find myself wanting to first understand these hidden mechanics through repeated in-game trials - ad nauseam - and then because I am crazy again to calculate the best possible way to play the game. And then play the game...

Well - its regarding the calculations step that I am at loss and turn to you forumites.

This is what I want to do:

Chart every possible combination of warrior type to every possible equipment type. Through my coefficients I can deduce the attribute benefits that the articles yield to the stat and through yet more house-made coefficients I can deduce the absolute value of 'greatness' for a particular combination of warrior type/articles from the stats. In terms of just one absolute value.

Well, its just that, now I need to compare values of absolute greatness together with other values of absolute greatness and there are so many possible combinations that I would be a fool twice to track them manually:

The army, is consistant of six-warrior troops. So that's 6 sets per troop. (I'll be manually considering one troop at a time, so that's okay)

- 3 warrior types (I'll be considering) that can be used throughout for the 6 sets in every troop.

- And there is one other warrior type that is mutually exclusive and can only be used once in the troop. So 4 warrior types all together.

Now there's equipment,

- All equipment is mutually exclusive and may only be issued once, once given are out of the count of available equipment, but there's a shield slot and a sword slot for every warrior. I'll have chosen 6 optimal shields and 6 optimal swords to test out and am looking for the most efficient combination of 6 'warrior-types'/shields/swords possible out of the available consortium - Considering that one particular warrior-type *(out of the 4 types available) is mutually exclusive of the other sets and may only be used once, if its used at all where as the other 3 may be used at will and for however many sets you wish.

A set is synonymous with a one warrior/shield/sword combo, I may need to elucidate.

All warrior-types have stats, all equipment types have stats also. I know how a set of stats compares both to each other and absolutely in terms of overall effectiveness of the trooper. Now I need to know what combination of 6 of these warrior-type/shield/swords I should use for maximum effect of the entire troop. I don't want to use an item or warrior type that may be used only once for instance, in the wrong situation... Some equipment complements a particular warrior-type, some detracts from it, relatively speaking.

So, is there a function in excel that will present to me, say: the best/2nd best/3rd best combinations of troop-arrangement within the confines of all equipment being usable once and all warrior types being re-usable apart from the one warrior type that may only be used once?

How would it work? Maybe there are more than one functions to use; then how? Please, help me forumites.

My acumen is only rudiment. Improve it and I shall love Excel forever!

Edit: I'll be inputting all the 4 trooper types and all the 6 shields and all the 6 swords manually, together with their stats and I can provide formulae and coefficients to appropriate the stats to their absolute value in terms of efficiency for each item, right next to the real stats, but then there's also a divergence in terms of how these stats stack together with stats of their kind from other equipment/warrior-type; sometimes they add, sometimes they multiply together. So this feature is going to have to be hard-wired into whatever function it is you suggest for this order. But I won't give any order of preference, I need excel to work this out for me.

I have done all of this manually making faint recourse to excel before, but on a much smaller scale. Using my own discretion. This time, however, there is no other option.

<!-- / message --><!-- edit note -->