premetto che sono un Genio nell'uso di excell quindi "perdonatemi" se vi sembro un po ritardato.. arriviamo al dunque:
Avrei bisogno di creare una sorta di funzione che mi permetta di generare accoppiamenti casuali tra due gruppi:
VADO NELLO SPECIFICO:
- Codice: Seleziona tutto
LISTA PRIMARI:
1)Pounding: Inflicts an additional 8.5% damage to any type of monsters. Decrease damage by 2.2% from enraged monsters.
2)Bitter: Critical attacks against any type of monsters do +1.52 times damage when attacking from the rear. Cannot stack with other Destroyer Rage crystals. Regenerates 28 MP when attacked by a player.
3)Forceful: Critical attacks will increase your Power by 21 for 10 seconds when attacking opponents from the rear. Cannot stack with other Forceful crystals. Resist critical hits 2.5% more when below 50% HP
4)Savage: Critical attacks do an additional +1.32 times damage when attacking from the rear. Cannot stack with other Savage crystals. Increase maximum HP by 1359.
5)Slaying: Chance to inflict an additional +1.74 critical damage to monsters when below 50% HP. Cannot stack with other crystals with the same effect. Decrease damage by 2.5% when below 50% HP
6)Furious: Chance to inflict an additional 10.5% damage to enemies when below 50% HP. Provides HP regeneration of 91 per 5 seconds.
7)Focused: Your attacks do an additional +1.88 times critical damage against enraged monsters. Cannot stack with other Focused crystals.
8)Virulent: Inflict critical hit on a knocked down target, they'll receive 1373 damage every second up to 5 seconds. Cannot stack with other Virulent crystals.
9)Brutal: Inflicts 10.2% more damage on a knocked-down opponent.
10)Cruel: Increases your crit damage by +0.48 for 7 seconds against knocked-down opponents. Cannot stack with other Cruel crystals.
11)Threatening: Increases monster aggro by 16%.
12)Carving: Increases crit rate by 3.3%. Cannot stack with other Carving crystals.
13)Salivating: Immediately regenerates 89 MP when attacking a player. Cannot stack with other Salivating crystals.
14)Brilliant: Provides MP regeneration of 43 per 5sec.
15)Infused: Regenerates up to 285 MP total when knocked down. Cannot stack with other Infused crystals.
16)Swift: Increases movement speed by 18 while in combat. Cannot stack with other Swift crystals.
17)Cunning: Increases maximum MP by 278.
18)Glistening: Critical hits recovers of 85 MP every second up to 3 seconds when attacking from the rear. Cannot stack with other Glistening crystals.
- Codice: Seleziona tutto
LISTA SECONDARI:
1)Decrease damage by 2.2% from enraged monsters.
2)Regenerates 28 MP when attacked by a player.
3)Resist critical hits 2.5% more when below 50% HP
4)Increase maximum HP by 1359.
5)Decrease damage by 2.5% when below 50% HP
6)Provides HP regeneration of 91 per 5 seconds.
ecco io dovrei "generare" casualmente accoppiamenti tra il 1° e il 2° gruppo che per esempio dia come risultato:
-Threatening: Increases monster aggro by 16%.-Decrease damage by 2.5% when below 50% HP
il risultato sarebbe un generatore di bonus che mi servirebbe da utilizzare in un MMORPG
*la cilieggina sulla torta sarebbe piu se sia possibile tipo in java da poter usare anche direttamente dal web.. ma qualsiasi sorta di aiuto che potete darmi va piu che bene....
GRAZIE in anticipo