Leulier's Warlock DPS Spreadsheet - Page 14

LittleNut · 04/24/09, 5:02 PM

Thanks to Bakka and others that brought us this great tool. If the following is consolidated elsewhere, please let me know.

I use Excel 2003 and people who have used the the later Warlock spreadsheets know there is a workaround to use the spreadsheet with Excel2003. The steps for the workaround exist on different pages on this thread. It is not difficult to piece together, but a single post w/ attribution is much easier for anyone with this problem. Below is what I needed to do to use Bakka’s spreadsheet.

The below is taken from several posts by Trickykid.

1. Basically you're just adding a macro that defines the function (that works in Excel 2007). I believe it's alt F11 by default to pull up the macro window (or Tools> Macro>VB editor), insert module, and then paste the following and save:

Function IfError(formula As Variant, show As String)

On Error GoTo ErrorHandler

If IsError(formula) Then
IfError = show
Else
IfError = formula
End If

Exit Function

ErrorHandler:
Resume Next

End Function

2. Okay well that macro makes the function IFERROR work, but apparently when you open the file and it didn't know about it it leaves the functions as "_xlfn.IFERROR". You need to find/replace those from that to IFERROR.

They show up on hidden tabs, so you will need to unhide all the tabs and then do a find/replace. [“ALT”.”o”,”h”,”u”,”ENTER”, repeat until done. 327 replacements on latest 3.1b]

3. Do you have GoC/NF turned on? Pretty sure this is the source of the remaining problems. Try turning it off and then back on (set to 0 and then back to 1).

4. Rehide the appropriate sheets

HTH

EDITTED TYPOS 4/27

Aberon · 04/25/09, 1:56 PM

Should add the new Staff enchant 81SP i think

ruthlessmind · 04/25/09, 4:03 PM

Originally Posted by Aberon

Should add the new Staff enchant 81SP i think

Until the sheet is updated it is easy to add in yourself. Unhide the enchant tab. Insert a line under the weapon enchant section. Type in a name. Add the 81 spell power under the appropriate column. Copy the dps value formula down. Add a comment. It will show up fine in the drop down menu and will also correctly import from the armory as well.

gorf · 04/26/09, 6:36 AM

Following the discussion over on the pet use thread, it would be useful I think to have a full set of raid buffs included in the spread sheet, including the Melee orientated buffs to give a more accurate picture of dps from the melee pets.

Currently there are a number of buffs we can't take account of in comparing pet dps that might make a difference.

Pach · 04/26/09, 2:15 PM

I believe you can take them into account actually on the pet tab. Scroll up and there are a list of buffs that may be on your pet, including Blessing of Might

PawnedDaily · 04/26/09, 3:28 PM

I am using excel 2007 and with the latest version (3.1b) I am getting a large number of circular references as soon as I open it. I love this tool and help with this would be great.

Thanks

Trickykid · 04/26/09, 6:23 PM

It uses circular references to solve since many stats rely on each other. Just go to formula options and allow more iterations for them.

Vampyl · 04/27/09, 8:39 PM

thanks littlenut for consolidating that information into one message, worked like a charm fixing all the #name? errors on my spreadsheet. And i'm not sure if anyone mentioned this yet, but you can't fix your spreadsheet on a mac using those steps. I had to use a windows then put the spreadsheet on a flashdrive to get it on my mac

Hellfrog · 04/28/09, 9:08 AM

Does somebody know when leulier.com is going to be online again?

Bakka · 04/28/09, 11:18 AM

Originally Posted by Hellfrog

Does somebody know when leulier.com is going to be online again?

Don't know. The sheet hasnt been hosted there for over a month now.

NinjaSquirrel · 04/28/09, 12:05 PM

Originally Posted by Hellfrog

Does somebody know when leulier.com is going to be online again?

Perhaps a thread name change to Bakka's Warlock DPS Spreadsheet would be helpful to the new people visiting this site.

Neron · 04/29/09, 7:15 AM

Originally Posted by Bakka

For those of you who use OpenOffice, use the Novell edition and vba macros work fine with no modifications to the spreadsheet. So glad I took all 30 seconds of time to google that tid bit of info and then an hour to download and install.

I still get all those #MAKRO? in the fields where dmg is calculated... is this supposed to be that way, and am I just missing something?

jumanji · 04/30/09, 3:40 AM

I'm still having problems with 80% of the macros not working in the spreadsheet. Tried all methods posted in this thread and there's still many #MACRO? errors. Anyone has a reliable way? I'm using Openoffice novell edition and Excel2007.

jeanvaljean · 04/30/09, 10:44 AM

My one problem with the spreadsheet is that I can't get it to consolidate the theory that raid-buffed, a succubus is the best dps pet behind Doomguard.

Swimmfst · 04/30/09, 5:05 PM

I believe that Infernal>Doomguard>Succubus>Felhunter>Imp ... but not sure about the order of Felhunter vs. Imp

gorf · 05/01/09, 5:33 AM

Originally Posted by jeanvaljean

My one problem with the spreadsheet is that I can't get it to consolidate the theory that raid-buffed, a succubus is the best dps pet behind Doomguard.

Originally Posted by Swimmfst

I believe that Infernal>Doomguard>Succubus>Felhunter>Imp ... but not sure about the order of Felhunter vs. Imp

I also found the spreadsheet implies that the Imp gives the Best DPS for Affliction spec, not counting situational use of Infernal or Doomguard.

According to the spreadsheet the Imp gives around 175 dps more than the Succubus if you spec into Imp. Imp. and Demonic Power. It also implies that Eradication is nowhere near as much as a buff as first impressions might suggest since dropping 2 points there to buff the Imp doesnt have an impact on overall DPS.

The argument is that the Succubus benefits from melee buffs which are hard to account for specifically in the spreadsheet where as the spell power / crit buffs the imp benefits from are clearly shown.

There was a bit of discussion around this in the Which Pet to Use thread as well.

Natasmai · 05/04/09, 8:33 AM

All of the melee buffs are accounted for in the Felguard area. Look to those fields for how it was done and you should be able to duplicate it for the Felhunter and Succy. All of the numbers for the melee buffs are there already, just transplant them where needed. I find the Felguard to be extremely accurate, especially considering all the things effecting its output.

Quaiche · 05/04/09, 11:12 AM

One thing is missing from the PetDPS section is pet food. I always use Spiced Mammoth Treats on my Fel Guard, but some still use Kibbler's Bits (cheaper mats).

duffry · 05/10/09, 6:24 AM

Not been able to use this sheet for some time and I really miss it. I do fully appreciate the efforts put in by those who keep this going but feel that if I'm struggling (and I'm not the biggest luddite with these things) then there are many others out there who are missing out of the benefits this sheet brings.

I don't want to come off as moaning here and am more than happy to do as much of the leg work on any of my suggestions as I am able to.

Compatability
This seems to be a biggie and from what I can see a lot of effort in posting and replying to posts is being directed here rather than to the actual function of the system and the (reverse) engineering of the numbers. Seems a bit of a waste and despite many suggestions that seem to work for some there are still those who can't get them to work (for one reason or another).

Would be nice to have a systematic approach to resolving this. If we could make a list of known spreadsheet apps and versions then we could have a support guide for each. It may be more complex than that but without proper trailing and reporting it seems a lot of confusion still abounds.

Again, I'm happy to participate or lead this though as someone who is still getting the #NAME? error I might not be best qualified from a technical standpoint. I do work in software testing though so may be able to organise stuff. I do think that this should not have to be done by Bakka himself, he has enough to do and whoever does do it maybe just use him for some technical guidance.

Reference
Someone put together a simple 'quick-start' guide a while back that introduced a new user to the basic function. I expect that if I trawl through this thread I would be able to find it but if it is still valid (and I expect it is) then it would be nice if it were more accessible. This should also forestall repeated simple questions clogging this thread.

I would suggest that this and any other guides that the community can be persuaded to produce, should be linked on the download page and in the sheet itself. Whether this be in the form of a wiki or just links to helpful posts I think it would all help a lot. If they are readily accessible and easy to use then more can be produced without having the effort be wasted by obscurity. If there is no chance to host at bakkadps.com than I would be willing to host something (wiki, support forum...).

Would also be handy to have a link to this thread on the download page and agree, would be good to change the title of the thread. Though if the collected wisdom in it could be put somewhere more accessible then a new one could be started.

Sorry
Sorry for the wall of text. I would really like to start using this sheet again and am willing to put in the graft to get myself (and those in this boat with me) using it. What say people and, most importantly Bakka, to the things I suggest?
________________________

Oh and while I admit I might be missing something cos it's not working for me, where has Immolate gone from the spell list on the DPS tab? I see that the rest of the row references it (both used_immo and used_conflag) but the spell in A26 is UA.
[edit] This is in: warlock_dps_v31d

Damphair · 05/10/09, 6:03 PM

Re: Using the Spreadsheet in Mac OS X.4

Originally Posted by Vampyl

thanks littlenut for consolidating that information into one message, worked like a charm fixing all the #name? errors on my spreadsheet. And i'm not sure if anyone mentioned this yet, but you can't fix your spreadsheet on a mac using those steps. I had to use a windows then put the spreadsheet on a flashdrive to get it on my mac

When I tried to modify the macros as described by others, under Microsoft Office X (2008) in OSX.4, I found that I could not get around the permission error. After searching around different Q&A websites on Excel and VBA, I still couldn't fix it. What I found that seems to work is to get the Open Office for Mac OSX for it. When I opened the v31d worksheet in Open Office, I was able to access the macro modules and make the changes. So for those who don't have access to a PC with Excel 2007, this might be an alternate solution.

Re: Spreadsheet problems

After getting the Spreadsheet to open properly in Open Office, I followed the instructions consolidated in LittleNut's post. However, I am still getting #value! error, e.g.

.

When I toggle "NF/GoC Proc", I either get #VALUE! error or #DIV/0! error on the DPS sheet. As far as I can tell, I've filled out all the stuff on the DPS sheet. Here's an image capture of it:

.

So what am I doing wrong here? Any help will be appreciated.

gorf · 05/14/09, 5:02 AM

Does anyone have a formula for calculating the DPS from the 4 piece T7 set bonus?

It's not in the current version of the spread sheet and I'm having a hard time figuring it out ( maths was never my strong point ).

Valilock · 05/14/09, 1:50 PM

My question may well have been answered by the above post but can ayone confirm:

Does the spreadsheet include the DPS provided by the 4pc T7 bonus? I got some shoudlers that are a small upgrade but I would need to swap out my legs as well to maintain the 13% hit cap. According to the sheet this is a small DPS increase but I also lose my T7 set bonus so I need to know for certain if the sheet calculates this.

Bakka · 05/19/09, 12:32 PM

Originally Posted by Valilock

My question may well have been answered by the above post but can ayone confirm:

Does the spreadsheet include the DPS provided by the 4pc T7 bonus? I got some shoudlers that are a small upgrade but I would need to swap out my legs as well to maintain the 13% hit cap. According to the sheet this is a small DPS increase but I also lose my T7 set bonus so I need to know for certain if the sheet calculates this.

No I do not include 4pc T7 anywhere in the sheet.

Natasmai · 05/19/09, 4:13 PM

Originally Posted by duffry

Oh and while I admit I might be missing something cos it's not working for me, where has Immolate gone from the spell list on the DPS tab? I see that the rest of the row references it (both used_immo and used_conflag) but the spell in A26 is UA.
[edit] This is in: warlock_dps_v31d

I dont think I saw anyone respond to this, so I will give it a reply. Affliction cannot cast Immolate because it overwrites their UA. In the latest release of the spread sheet, bakka made it so that it forces UA if you have the talent or it switches to Immolate if you arent specced into UA. I will then assume that you are currently set up to be specced into deep affliction and therefore Immolate doesnt apply to you. If you change your spec, it should appear. I am currently running in Excel 2003 with all the modifications done as outlined above to correct the IFERROR problem and I have no issues at all.

I do find it is a pain to have to reapply the IFERROR fix every time a new version is released, but it is most definately our problem for using an old software and not Bakka's. All required changes needed to make this sheet work with older Excel versions has been outlined many times and I really dont see a reason to discuss it further. It's annoying, but not impossible by any account.

I would love to see 4pc T7 somewhere in the sheet, but unfortunately I expect it is rapidly becoming a moot point to include it now since we all know 2pcT8 and 4pcT8 are better overall. And lastly, I would love to see the pets working better. I know someone put some huge efforts into correcting Felguard a while back and I feel it is very solid now. Imp seems to be good as well, but Succy and Felhunter cant be right. Other forum threads show succy as a better option than imp for affliction, but I show on this sheet that imp is easily 200+ more dps than Succy and imp glyph is another 100 dps. I assume Succy is in error somehow, but I dont know enough to find the errors myself. I did find an error with a cell name in the succy data on the "Pet-TNS" tab about "ISB uptime", fixed it and it didnt seem to effect any outcomes.

Just some random thoughts, I love the sheet and I prefer to use it over the SimulationCraft program, I trust this more except those few missing things.

Anthraxx · 05/20/09, 4:22 AM

Originally Posted by Natasmai

And lastly, I would love to see the pets working better. I know someone put some huge efforts into correcting Felguard a while back and I feel it is very solid now. Imp seems to be good as well, but Succy and Felhunter cant be right. Other forum threads show succy as a better option than imp for affliction, but I show on this sheet that imp is easily 200+ more dps than Succy and imp glyph is another 100 dps. I assume Succy is in error somehow, but I dont know enough to find the errors myself. I did find an error with a cell name in the succy data on the "Pet-TNS" tab about "ISB uptime", fixed it and it didnt seem to effect any outcomes.

My guess would be that spreadsheet doesn't take raid melee buffs/debuffs into account. Succubus/felguard scale much better with them then imp with caster equivalents.