Elitist Jerks - View Single Post

SneakerXZ · 04/26/08, 6:35 PM

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.

04/26/08, 6:35 PM	#10 (permalink)
SneakerXZ Glass Joe Seidhkona Draenei Shaman Burning Steppes (EU)	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. Last edited by SneakerXZ : 04/26/08 at 6:50 PM.