Redcape

It is time for a new version of my Ret Paladin DPS Spreadsheet. This is a major revamp and improvement, hence the change to 4.x version numbers. The sheet supports the new t10 bonuses, and although the way the new 2 piece works isn't clear yet you can tweak the sheet to model various implementations and test. To test the t10 bonuses make sure to turn on t10 2P in the Talents, Buffs, Enchants section and then look at the top left of the Calculations page for specifics.

Sheet is located ->here<-

Major Changes:

- Rotation builder added. Now you can enter your priority system, latency and other factors and the sheet will automatically supply you with a rotation.

- Gear entry improved (a lot). Now when you enter gear you pick gems and socket bonuses from drop down menus instead of adding them in manually. Enchants are also much improved and moved to a more logical location in the sheet.

- Layout Revamp! The sheet has been changed to be much more user friendly. The information on the Main page is everything most people really want to see, while all the background breakdowns are still available on the Ability Use Information page. I have added Instructions and an introduction for people who have little/no idea about spreadsheets and info boxes throughout the sheet to explain each area's function and use.

- Open Office/Mac support improved. I removed as many macros from the sheet as was possible, and now people not using Excel can make good use of the sheet. Getting stat weights requires a little data entry (very little) on your part, but is completely supported. The only things totally unavailable are the copy/paste and save buttons (you can copy stuff yourself quite trivially) and the rotation builder. Unfortunately there simply is no way for me to easily add a rotation builder without using macros, so people without Excel will have to use the default cooldowns or work them out themselves.

Enjoy, and please do send along any bugs/constructive criticism/t10 testing reports so I can keep updated.

 

• frmorrison

Wow, big improvement.

4T10 should only affect Seal and Judgement. You have the SoV DoT included as well.
2T10 seems too good, I was getting a 6% damage increase. However, DK have a 4 piece that gave about the same increase (but it is being changed in 3.3). Maybe the bonus will only proc on white hits (the target dps gain should be between 1% to 3%).

A suggestion is to save the sheet on the Instruction sheet (opening the file showed the calculations).

DK - Ashbane Failure is the condiment that gives success its flavor.

 

• Golijov

I can't appear to open this sheet with Excel 2003. Am I doing something wrong or is it just incompatible?

 

Redcape

Both the t10 bonuses are modeled according to my guesses at the moment. As soon as we have concrete data I will update them as necessary, but I don't see any reason to assume your version of what they will do is more likely to be accurate. The bonus certainly doesn't specify one way or the other from what I have seen.

I should indeed save it to the Instruction sheet. I in fact did that, but had to add a small fix after first uploading it, and ended up saved on the Calculation sheet on that version. Curses.

I am not doing anything exciting with the sheet that should make it incompatible, but I am no expert on that topic. What exactly is the error you are getting?

 

• Golijov

Figured it out - the format xlsm is an excel 2007+ format and its not backwards compatible.

 

• frmorrison

I am pretty sure there is a patch to open Excel 2007 files with 2003.

DK - Ashbane Failure is the condiment that gives success its flavor.

 

• Golijov

Ah thanks, I hadn't thought to look for one. Here's a link to the compatibility patch for anyone else who encounters this: http://www.microsoft.com/downloads/d...displaylang=en

 

Sinsei

I like the sheet, are there any future plans for adding the actual gear to the worksheet in lieu of stats?

I know it's a lot of work, just asking.

 

Redcape

It is a possibility. There are two options as far as I can see:

1. Add a list of all relevant gear stats to the sheet itself. I could have a page that records all relevant gear stats and lets you pick gear from a dropdown menu. This is a really serious amount of data entry, but is possible without a ton of reengineering. It would also allow non excel users to use the feature. It would require constant updating with each patch as gear is added however.

2. Set it up so VBA searches the armory for your gearstats and imports them, and/or gets all gearstats from wowhead or something. I have no idea how to do this, but clearly I could learn. It would be a lot of work on my part initially but would be less work to maintain since I don't have to update the lists myself, but would not function for anyone not using excel. I don't have a handle on how long this would take since I don't yet know how it works.

 

agoat

Would it be possible to have the Engineering only enchants added? 23 agi to cloak, rockets and the nitro boosts crit to feet. I don't know how much work that would entail but I would appreciate it as I do the work you put in on the whole sheet.

 

bstrange

The DL folder on your site lists DL as Ret_dps4.0.xlsm; however when I actually download it it is Ret_dps4.0.zip and there are no xlsm files inside, just xml, vml, and rel files. Am I missing something or am I just too stupid?

 

Neraya

An XLSM file _IS_ a zip file with a set of xml, vml etc files inside it.

It's Microsoft's way to make a easy to read format (xml) while also providing reduced size (zip) and doing this in a non proprietary way.

When downloading, it's possible the browser detects the file as being a zip and renames it.

-> rename the file to .xlsm and it should load properly in excel.

 

Redcape

The rockets are really annoying to implement because they don't fit well into a stat list. For the moment you are just going to have to figure those out yourself, though I may at some point try to rejig it.

The cloak and boot enchants should have been in the last release and not having them was just an oversight on my part. That said, you CAN put in 22 agility to cloak instead of 23, so I don't really see it being a huge issue. The feet enchant is worth having on though so I will get that in next update.

Thanks for catching those.