Originally Posted by ruizAw
yes, its fix. But weigh 1 hitr still not equal (Hit=50=3,96% -> 1 hit=2,202; Hit=27=2,14% -> 1,698) - im not swap items, just add hitr in cell P15
|
Ops, try =A72*IF($B$21>0.16,0.99-D21+(B21-0.16),C21-D21)
Originally Posted by SneakerXZ
Hey, nice tool!
I tried it and I found bug. I wrote fix for it. Spell Crit Rating is calculated wrong. You ignore values from elixirs, flasks, oils and food, though you forgot add [Skullfish Soup].
I wrote fix for it. Put this to K7
=O15+VLOOKUP(B4;flasktable;9;FALSE)+VLOOKUP(B5;belixirtable;9;FALSE)+VLOOKUP(B6;gelixirtable;9;FALSE)+VLOOKUP(B7;oiltable;9;FALSE)+VLOOKUP(B8;foodtable;9;FALSE)
and fix for hit:
Put this to K8
=P15+VLOOKUP(B4;flasktable;10;FALSE)+VLOOKUP(B5;belixirtable;10;FALSE)+VLOOKUP(B6;gelixirtable;10;FALSE)+VLOOKUP(B7;oiltable;10;FALSE)+VLOOKUP(B8;foodtable;10;FALSE)
You should this add for other stats like stamina, spirit etc.
Don't forget remove it this calculation from total crit. |
You didn't check M7 & M8 did you? But you're right about the Skullfish Soup bit.
Hmm. Now that you mention it I'm just chaining a couple of cell references there, so I could tidy that up and make M3-9 refer to the row 15 stats rather than doing it via K3-9