duffry

Version 3.1.3c
Now available for download.

-> Sheet home
-> Changelog
-> Discussion & Development Forum

Primary change:

• Fixed issue with loading talents into DPS sheet.

A load of gear needs to be added for hardmodes and upcoming 3.2.
This is an outstanding action now tracked here.

Guessing you also used runes in that fight.
There's a couple of comments about deep destro getting too much damage in the calculations, possibly around the crit. I'm currently working on expanding out all the mechanics and calcs and with luck this will expose the issue or at least ease the investigation.

 

blgdinger

I was talking about nothing but steelbreaker only because I'm not moving and I'll have every single buff listed so my dps should be pretty close. I can't say whether or not that shit is way off but I'll see about it this week and report back here

 

duffry

Version 3.1.3d
Now available for download.

-> Sheet home
-> Changelog
-> Discussion & Development Forum

Primary change:
2 bug fixes, see changelog for details.

 

Koshir

Its seems like "Mana" at "B11" is not increased in "TNS-int" tab.

 

duffry

Seems like it does for me.

Please provide more info when reporting a bug.

• Details to include:
  • Version of the sheet you are using
  • Application you are running it in (eg Excel 2003)
  • Steps to reproduce the issue
  • Expected result
  • Actual result received
  • Any and all other info you think might help resolve the issue

 

Koshir

Steps:
1. Look at J12 in "DPS" tab (21830 for example)
2. Look at B11 in "TNS-int" tab (the same value - 21830)
EXP: 21830+(TNS_Intellect-Base_Intellect)*Intellect_To_Mana

 

emcee

icecore staff stats are outdated

 

duffry

Version 3.1.3e
Now available for download.

-> Sheet home
-> Changelog
-> Discussion & Development Forum

Primary change:
EU servers added, see changelog for details.

 

Bersi

Wonderfull sheet, exactly what i needed. Could you please add Misery (Misery - Spell - World of Warcraft) to the Gear_Buffs -> Raid Buff List?

 

Daidai

The effect of ImpSoulleech is not working, so the actual 0/13/58 is not working (LT-Count should decrease)

Maybe this can be modeled, because Soulleech is working?

 

Marklar

Misery is a debuff, so it's listed on the DPS sheet with the other target debuffs. You'll find it in cell H16.

 

Koshir

So, could it be implemented? It affects 0/13/58 build Int tns because of extra mana regeneration.

 

duffry

Issue raised in the Discussion & Development Forum

 

sephx

Actually take a look at the raid buffs.... make sure you are unchecking and checking the ones that you have or dont have. I noticed removing them I got nearly the same dps as the spread sheet said I had (as destro) on the dummy's. So it's not too far off, it just needs some tweaks.

 

duffry

Quoted from the sheet's Discussion and Development forum in case there are those who read this forum but not that and share these concerns.

Since I am hosting this sheet, it's discussion and development forum and supporting wiki pages on my guild/community site it should be fairly easy for anyone to get an idea of my experience but since you asked so nicely I'll put down a condensed version.

I started playing WoW casually during Vanilla while the DMZ community (of which I'm a founder) were still focussed on the Battlefield games where we competed in Euro clan matches. The serious BF community was gasping it's last at the time so we were looking for something new and moved over to WoW shortly after TBC. I supported the guild through levelling to 70 and then organised and led raids from first steps into Karazhan. We have maintained a 'community > progress' attitude since the beginning but despite starting late in TBC we take our raiding seriously. We cleared all TBC bosses outside Sunwell before the pre-LK uber-nerf again with my organising and leading the raids. In Wrath I have continued to lead the raiding and (as you have seen) we have cleared content up to Yogg (25 man guild focus), with all T7 including TV and TZ. I have variously played all lock specs in PvE and tanked all the regulars (Leo, Cap, Illi) and void-tanked Sarth 10 & 25 and even Kalecgos in that crazy time while void threat was off the chart. The lock has been my main throughout all of that.

Outside of WoW I work in software development for an international consultancy firm and have experience within design, build, test, implementation and support phases of the project development lifecycle as well as some management experience.

If you were to look about on EJ and bakkadps.com you would see that I made numerous fruitless attempts to contact Bakka and made calls for anyone else interested in maintaining the sheet to step forward. Since it was silent on both counts I started looking closer at the sheet and what known issues there were with it. As a lot of people do use this sheet I was unhappy to see it undeveloped and so started to apply fixes and release updates. I don't see that the sheet has any owner, merely custodians. The sheet belongs to the community that uses it and as such anyone could develop and release their own changes. This could obviously become very chaotic very quickly, hence it is wise to have a custodian who can administer the development and co-ordinate releases.

I appreciate your suggestion about release scheduling however I think you might be exaggerating somewhat. I have no intention of releasing new versions every couple of days. However when a significant bug is detected and a fix is known it is no great bother to release it and no real benefit in not doing so. I'm keeping a clear and accurate changelog so anyone seeing that their current version is out of date can quickly check to see if the new changes are pertinent to them and decide if they need to upgrade. This changelog can be easily reached from the link on the info tab within the sheet itself.

I recognise your concern that 'just anyone' might have picked up development of a resource you rely on and that this person might be a total noob and ruin everything. I had the same concerns myself. I do not pretend to be the best theorycrafter, player, warlock or... well anything but I am prepared to look after this sheet and develop it for the better. I will be taking a more 'open to the community' approach than has been adopted in the past and (as you can see) I've started exposing the formulas and mechanics used to make them more accessible and easier to update (reuse of common components etc).

I hope this addresses your concerns and those of anyone that shares them. I didn't think I would have to essentially apply for the job since I seemed to be the only one volunteering to invest the time and commitment into doing it.

 

Phearbot

Having huge problems with the spreadsheet. On excel I get "This workbook has lost its VBA project, Activex controls and any other programmability related feature."

On OpenOffice I can load the spreadsheet and enable macros... but the load from armory button does not work at all. I never had a problem with the old spreadsheet. Any help would be greatly appreciated.

 

duffry

I don't suppose I can be too frustrated, I spend a fair amount of time on every project trying to get testers to provide proper info and they are paid to do it!

The issue you have with excel sounds like an issue with your version or installation or setup of excel. If it were the sheet I'm pretty sure someone else would have said by now. Since you haven't confirmed the version of the sheet or version of excel or steps to reproduce I can't help at all.

Again, with OpenOffice you don't state the version you are using so I can't start to retest. Once again, give me steps to reproduce and I'll see if I can recreate it. There are two buttons that load details from the armory, you don't state which you are using. It may sound odd but there are many types of "does not work at all", please give the expected result of the steps and the actual result in as much detail as possible.

You also failed to say what version you refer to as 'the old spreadsheet'.

I'm not trying to be unhelpful or 'have a go'. i want people reporting the issues they have as i want there to be as few issues as possible. if people are having issues that are not directly associated with the sheet then I may not be able to resolve them but I may be able to put some info and support in place to help people avoid them going forward.

however, I am not about to try and guess what peoples issues are, there are enough that are well documented for me to worry about.

Please read the info on How to report an issue on the sheet's home page.
-> Warlock DPS Spreadsheet - DMZWiki

[edit]
When doing a Google search for your error message ("This workbook has lost its VBA project, Activex controls and any other programmability related feature.") these are the top three results.
-> ASAP Utilities - Excel 2007: This workbook has lost its VBA project.... - Questions and answers - Excel software
-> Some Excel features are unavailable if you disable Visual Basic for Applications and run Excel
-> This workbook has lost its VBA project, ActiveX controls and any other programmability-related features. - Operating Systems

Doing this search would have been easier than posting, solved your problem and stopped you from looking a bit silly raising an issue on a sheet when you had simply not installed Excel properly. I don't see any way that this could have worked with any version of this sheet.

 

sephx

First Why would you criticize Duffry for trying to take over this project. If you did your homework you would know that Bakka discontinued his work on updating the spreadsheet and you should be grateful that someone is taking over the spreadsheet.

Imo, Duffry is doing a great job on the spreadsheet so far and trying to fix any bugs that come up. Non-Constructive criticism is what made Bakka quit doing the spreadsheet in the first place.... So instead of just posting and forum trolling, try actually READING some of the things that duffry posts as well as the links he provides for more information on bugs, changes, etc.

 

Vampyl

Seriously thanks for taking this up Duffry, there will always be people who will criticize and be general d**ks but there will always be plenty more thankful people. Also thank you for implenting the IFERROR fix as I can now use the sheet because of that

 

Rayvven

It seems I am having the same problem Phearbot is having.

Version: Warlock_dps_v313e
Application running it: OpenOffice 3.1.0
Steps to reproduce: I open the spreadsheet in Calc and enable macros when the popup appears. Under the ArmoryInfo tab I change all the information to fit my character. Then change to the Gear or Talents tab and click on Load from Armory.
Expected result: I would expect all of my character specific information to populate the cells.
Actual result: Nothing changes at all. The Load from Armory tab does, however, depress when clicking on it.
Other information: I have my macro settings defaulted at Medium, but even changing it to Low doesn't work either. Also note that my version of OpenOffice is unregistered.

I had this problem with an earlier version of OpenOffice as well. When I saw you comment earlier that you used a newer version, I figured that might be the reason the macros weren't working correctly. It seems that isn't the case. I am now assuming there is something wrong on my end. Because this problem has been stated above without going into detail, I decided to include mine. Hopefully this will help.

 

duffry

Thank you for the detailed report.

There have been some recent changes in this area due to the changes implemented in the Armory. These have not beed tested (by me) on OpenOffice as yet.

Further changes are likely to go into the next release around dual specs and I'll try and get some cross-app tests and debugging performed.

Issue raised in the development forum and will be tracked from there.
-> DMZ-Gaming / Armory lookup doesn't in OpenOffice

 

TiaMaster

The Spreadsheet just shows a bunch of "#MACRO"s in most fields for me. Medium macro security in OpenOffice 3.1, latest Spreadsheet version.

Also, No import functionality works, import from armory buttons just don't do anything. Getting 'Scripting Framework' errors from "Save" or "Load" type buttons.

I manually put everything in and nothing changed or populated.

I can't load the website so can't post on those forums.

 

duffry

As stated above I have not tested on OpenOffice as yet.

If you can't access the DMZ site then our hosts are probably failing on their 99.99% uptime promise once again.
I've not seen it down today though so it should be fine on refresh.

 

duffry

Version 3.1.3f
Now available for download.

Sheet home
Changelog
Discussion & Development Forum

Primary changes:

• Added dual talent spec support
• Added Demonic Pact calculator

See changelog for details.

 

dualaud

Thank you for your continuing effort.
Using the spreadsheet since its early beginnings, and the import from armory function never actually worked for me on Mac OS X using Office 2004, Office 2008 or Open Office.

If there is anything I can do to help the issue, please send a personal message.