Thanks - that fixed the issue.

Got an additional question. Been searching through the thread but can't seem to find the answer so my sincere apoligize if it's already been asked.

Will the spreadsheet notify me when I hit the crit cap or will it "only" notify me by telling me that a 20 hit gem will give me more dps than a 20 crit gem?

Not that those gems are optimal - Just as an example of course.

Thanks, that worked.

Also, [Gangrenous Leggings] have the wrong stats in the sheet. They should have 200 AP, 84 hit, 1 extra blue socket and 8 Agi socket bonus.

It will only show hit gems being better

I implemented changes to [Tiny Abomination in a Jar] and [Heartpierce], also fixed some crit capping issues.

Greetings Vef and the EJ Rogue community!

I am using your latest uploaded version of the sheet for COMBAT (uploaded on 01/17/2010), and seem to have come across an issue of sorts.
In game and on the armory, my characters Effective AP is 4958. According to the sheet, my characters Effective AP is 4874. This is a difference of 84 AP.

I've gone over the equipment stats (God help me if I've missed one) and noticed no differences to what appears in game to what is represented in the sheet.

I am getting quite blurry-eyed and brain-frazzled trying to figure out where the sheet has "thrown awry" or "incorrectly calculating" these values.

If anyone could possibly shed any light as to why this might be different, I'd greatly appreciate it.

For reference ---

Sheet Stats:

Strength 133
Agility 1949
AP 4874
Hit Rating 401
Crit Rating 742
Crit % 44.26%
Expertise 148
Haste 539
Armor Pen 391

Armory Stats:

Strength: 133
Agility: 1949
AP: 4958 EFF
Hit Rating: 401
Crit Rating: 742
Crit %: 44.26
Expertise: 148

Have you checked to make sure you have the leatherworking bracer enchant selected? That should roughly account for the difference.

For those who can't wait to get an update on the sheet and want to see what the change will be after patch 3.3.3, you should do the following:

Change cell U20 on the "Gear"-tab to "TRUE", which will permanently activate the "old" tier 8 4 piece setbonus.

I keep getting an error when I click on gear upgrade check or gem upgrade check. I have the roguecraft 3.3 sheet and I'm using open office. It says "the following basic script is not found" etc. Has anyone else had this problem? How can I fix it?

OpenOffice doesn't work well with excel macros. You can, however, download windows office 2010 for free, as it is in open beta. That should work just fine.

I finally fixed Abomination in a Jar and some socket bonuses

Thanks for this update. You may want to take a look at Tiny Abom again. In this version its showing as a 100 dps decrease for me from normal Death's Choice. However, in Aldriana's spreadsheet Tiny Abom is a 50 dps increase. Nowhere else have I found such a large discrepancy between the two spreadsheets (except for the too high Tiny Abom dps in the last version).

Thanks for looking at this. I'm still finding an approx. 120 dps difference (lower) than Aldrianna's sheet. I tried looking at some of the formulas but got a bit lost. One thing did stick out. Both the MH and OH DPS calculations (cells B39 and B40) on the DPS sheet seem to subtract out a SS miss rate (D13) for the Tiny Abom even when the miss rate is 0 due to the way the formula was crafted. I don't know if that was the intention.

Because people asked, I`m still updating the spreadsheet and will so in future : )

Thanks for the update, Vef. Just a note - the stats on heroic Heartpierce and LK weapons are still wrong: Heartpierce should have 95 AP, Heaven's Fall has haste instead of ArPen and Stormfury has expertise instead of ArPen.

First of all, thanks for keeping this sheet updated. But there're somes typo remaining:
_ Gangrenous Leggings Heroic: they don't have the blue socket
_ Haste Potion usage is not calculated even I have a combat duration so the message " <-- calculated only, if combat duration is set" is no more revelant.

I guess there is a misunderstanding with the <-- calculated only, if combat duration is set row.
In the buff sheet you enter a "1" for haste potion, just like any other buff usage and in the Talents & settings sheet you set a combat duration other than "0". That's how it should work.

Hi Vef,

Thank you for producing an update spreadsheet.

I don't know if you would do this as a request, but would you consider adding Cat's Swiftness (+6agi & Speed Increase) as an available option under boot enchants for the combat spreadsheet?

You can easily do it yourself, just unhide the Foot tab and add another row with the required name/stats under the Enchant section.

I finalized the combat cycle calculations, which sadly does increase the upgrade-check-macro significantly, but I will try to solve that problem

I stumbled across a qierd error with the spreadhseet you updated from the orgininal author Vulajin.
The mutilate sheet works excellent, but it is the combat sheet thats the problem.
I can import gear and everything else but , and i say but, when i try to change combo builder from mutilate to sinister strike all dps stats calculations get an err 502.

I am using openoffice if that has something to do with the error.

Any smart person that have a good solution to how to fix this?

I'm having the same issue with Roguecraft 3.3.5 macro.xls. When I hit either the Gear or Gem Upgrade Check, the drop-down menus cycle through all available gems...the DPS changes, but it always finishes on the original gem. If anyone could tell me what I'm doing wrong that would be great

The upgrade macros put comments on the cells - mouse over the cells with the green arrows, and it'll show you a list of possible upgrades.