I noticed the sheet does some weird things as far as combat table calculations go. For example, in the case of dual wielding with 15% hit, at 300 weapon skill vs a lvl 63 mob, the sheet gives 44,8% as crit cap.
I believe that in this case, the cap should be a flat 43%. Example table assuming 10% spellbook crit chance below:
Now, to find the crit cap, we calculate [Crit Cap] =[Hit Chance] + [Crit Chance] + [Weapon Skill Difference x 0,04]
Which amounts to 33 + 9,4 + 0,6 = 43%
Next & related issue, I believe the sheet does not treat bonus weapon skill correctly. Same situation as above, but 305 skill because of human racial. The sheet says 45,2% which is 0,4% more than at 300 skill. Let's look at another example table with the same assumptions as before:
What has changed? We gained 2% hit from the 5 skill jump, we gained 0,2% crit, and we lost 0,2% dodge.
The crit cap now amounts to 35 + 9,6 + 0,4 = 45%
Those were just some examples that I thought might be helpful. I can see in the 'Calcs' section that the combat tables (or 'Hit Tables' as they are called there) behave quite differently from the way I believe they work on Kronos. I myself have had a go at just getting the tables right, so in case you would like to take a look, you can do that here.
I believe that in this case, the cap should be a flat 43%. Example table assuming 10% spellbook crit chance below:
- 33 Hit
- 9,4 Crit
- 12 Miss
- 5,6 Dodge
- 0 Parry
- 40 Glancing
- -----------
- 100 Sum
Now, to find the crit cap, we calculate [Crit Cap] =[Hit Chance] + [Crit Chance] + [Weapon Skill Difference x 0,04]
Which amounts to 33 + 9,4 + 0,6 = 43%
Next & related issue, I believe the sheet does not treat bonus weapon skill correctly. Same situation as above, but 305 skill because of human racial. The sheet says 45,2% which is 0,4% more than at 300 skill. Let's look at another example table with the same assumptions as before:
- 35 Hit
- 9,6 Crit
- 10 Miss
- 5,4 Dodge
- 0 Parry
- 40 Glancing
- -----------
- 100 Sum
What has changed? We gained 2% hit from the 5 skill jump, we gained 0,2% crit, and we lost 0,2% dodge.
The crit cap now amounts to 35 + 9,6 + 0,4 = 45%
Those were just some examples that I thought might be helpful. I can see in the 'Calcs' section that the combat tables (or 'Hit Tables' as they are called there) behave quite differently from the way I believe they work on Kronos. I myself have had a go at just getting the tables right, so in case you would like to take a look, you can do that here.