Redcape's Ret Spreadsheet v4.1 - Now with User Friendly!
 

I have just posted v4.2 to the site. There are a number of upgrades including layout changes, Bryntroll, TAiaJ, Eng Rockets support, corrected % modifier stacking calculation and improved haste / 2t10 calculation.

Sheet is located ->here<-

Enjoy.

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).

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

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?

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

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

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

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.

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.

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.

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?

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.

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.

I apologize if im missing something terribly obvious. But when I download the file, and Unzip it, I get 3 folders and a XML file. And nothing seems to actually open a spread sheet. Could someone tell me what I am missing. Sorry.

Redcape appears to have made the file in Excel 2007 which uses xlsm file. You need to upgrade your Excel or find a MS Office patch that allows you to open 2007 files.

If that isn't your problem, you need to be use a browser like Firefox 3 or Chrome that knows how to download XML files.