Mirtyl

I'm a long time reader and I rarely post on this forum but what i'm reading here really shockec me.

I just want to give you all my support Bakka and thank you so much for all your hard work !

Keep the faith !

 

Viper007Bond

I'd just like to say ignore the ungreatful retards. He may not be greatful for your work, but there's 100 (if not more) other people out there who are. Don't let douchebags like that get you down.

 

mellowmarshall

I gave this thread a quick go-over and didn't notice anyone posting a fix for the TNS (the_next_stat) function, so I thought I'd throw this out there.

Worksheet DPS, Cell N2 should read:
"=Gear_Buffs!G4+Gear_Buffs!H4"

Worksheet DPS, Cell N3 should read:
"=Gear_Buffs!G4+Gear_Buffs!I4"

Worksheet DPS, Cell N4 should read:
"=1.701+N7/(500/3)+Gear_Buffs!$K$4/DPS!$L$3+d_tactics*2+backlash+scorch+ToW"

I believe the other cells are correct. Essentially the problem with the tns calculations is that it was comparing your base stats on the DPS worksheet to your buffed stats on hidden tns worksheets, making any stat increase appear to be incredibly valuable. If you make those changes and the tns #s still look strange, try this:

Use alt+F11 to bring up the visual basic editor.
Find the box in the top left corner with a list of worksheets.
Scroll down to Feuil5 (TNS-sdmg).
In the box below, click the "Categorized" tab, and change the "Visible" option at the bottom to 1 - xlSheetVisible.

Now compare the stats shown in the TNS-sdmg worksheet with those in the DPS worksheet, and try to find a discrepancy. Note that the TNS-sdmg worksheet is going to show your actual sdmg+1, since it is calculating the dps increase for 1 additional spell power. This is not the discrepancy. What I noticed is that my crit on the DPS spreadsheet was showing 26.50%, but on TNS-sdmg it was 39.80. The difference was calculations for ToW, Boomkin aura, Scorch, etc.

 

sandwiches

Not to discredit your work but I believe you may have an old version of the sheet since in version 3.0b, the Additional Shadow and Additional Fire damage values in the DPS sheet are correct the way they are without modification. The TNS numbers it was showing, on my sheet at least, were completely fine.

Also, cell N4 in the DPS sheet already has that value you suggested but in separate lines. If you missed this, I see how you might have misread the "Add Shad" and "Add Fire" values. I would not recommend anyone from changing the values to those cells to those suggested by mellowmarshall, right now.

 

mellowmarshall

I just grabbed the most recent version from the website a few hours ago, it is vers 3.08b. Anyways, it was all jacked up when I opened it, and after a bit of reading on leulier.com it looks like bakka was aware of the issue but hadn't fixed it yet.

Also, my N4 cell referred to some random cell instead of N7, resulting in my int for calculations to be 0.

 

sandwiches

The only way I can see all those problems happening is if you're using a program other than Excel 2007, which is the only "officially" supported spreadsheet program.

 

Poupette

Hi Guys,

I don't know how you get this sheet but me I take it from WoW Warlock DPS Spreadsheet.

So I put a post here to thanks Bakka a lot for his sheet.

As he wrote on the last topic, it's shame that someone instulting him for this awesone and free sheet. As comments are disable on his topic, I use this post to totaly disagree with this idiot that insulting him.

I hope the break before 3.1 will make Bakka appier with his sheet and let him share his wonderfull job. If not, I will understand try to refect change on the 3.0.8 version.

Another thanks for your job Bakka^^

 

Kana

It's too bad there are a lot of ungrateful idiots in the world.

It's too bad we aren't better at ignoring them. Some douche is out there feeling good about himself because he got to tear down something meaningful.

Since the spreadsheet probably won't by some miracle get updated for 3.1, thanks to bakka for maintaining it this far, It's been a wonderful tool for me for, man, more than a year now.

 

icynrvna

i do hope he continues his work on the spreadsheet, its a great help to all warlocks out there.

 

Yeda

Giving my support and a huge thanks to Bakka for the spreadsheet! Dont mind those bastards

 

Zeetocht

I've searched this forum and haven't found anywhere where this issue is addressed- forgive me if I missed it somwhere.

I'm using Excel 2007 and when I try to save a completed spreadsheet, either in the default or macro-enabled format, and then re-open it I have the #NAME? errors. When I do try to save it I get the following message:

"The name, mp5, either concflicts with a valid range referenace or is invalid for Excel. The name has been replaced with _mp5.

You may still need to manually update any references to this name used in VBA code or as text arguments in functions. You must close and re-open the workbook before these changes take effect."

Am I missing some noob thing somewhere?


Thanks

 

elessar44

Anyone else have trouble with v308b? I just downloaded it and the DPS number in the Gear Buffs tabs gives me a #### error. also the +spell dmg gives me a #NAME error. I have v303iand it works alright.

Am I doing something wrong here?

p.s. thanks for all the hardwork on the spreadsheet, it is a massive help and I appreciate the energy you've put into it.

 

Shayo

I'm not sure if this will help, but I get #NAME errors when I have the glyph of corruption and NF/GoC Proc set to 1 on the dps sheet. If I set it to 0 and then back to 1, this error gets resolved.

 

elessar44

Hmm tried messing around with that, no dice. Thanks though.

I just realized I'm using an older copy of Excel, 2002 to be exact, I wonder if that could be an issue?

 

Shayo

Yeah, if you didn't follow the instructions for adding the IfError function (introduced in Excel 2007) through the visual basic editor (use the forum's search feature), then you'll get these and other errors.

Also, one thing that I found handy in Excel 2003 was the "Trace Error" function. I'm not sure if this exists in 2002. Click Tools > Formula Auditing > Trace Error and that is what eventually allowed me to find all the problems I needed to resolve to get the spreadsheet to work. I highly recommend reading the thread and the numerous fixes for errors posted here, likely your problem has already been addressed.

 

dualaud

If you are using the spreadsheet on the Mac, you are fragged even with the newest Excel application.

That said, Bakka, I've been using your spreadsheet since I started playing my main character, and the sheet has always been an enormous help. I wouldn't be where I am now as a wow gamer knowledgewise, if it wasn't for your spreadsheet.
It brought me closer to understanding, 'what is going on in the background'.

I sincerely hope you change your mind about not updating the spreadsheet for the public community of warlock players anymore.
There is always a dumb f**k amongst a big (and growing) crowd. Don't let him put you down.
I think, I speak for the whole community, when I say, that everyone appreciated you work and you are leaving a big hole, when you really decide to quit sharing.
Keep it up!

Cheers,
dualaud

 

Kana

For the record, I pasted in the little vBasic function posted earlier, and it didn't solve the problem in excel 2002. Possible I did ir wrong, but the instructions seemed simple enough.

 

Natasmai

did you paste the new macro and then replace all instances of one "IFerror" to the correct "IFerror" including unhiding all the hidden tabs? It takes some considerable work to get the sheet to work with Excel 2003 (I assume the same for 2002) but once you do it, you can save it and it should work permanently until a new version (HOPEFULLY!) gets released.

Another thing to consider, if you changed everything and it still doesnt work, change the nightfall proc/corr glyph on the DPS tab to 0 and back to 1. This is usually the final thing that is broken.

 

Kana

I probably did it wrong, then. I unhid the hidden tabs (at least, I think I did) and did a find+replace. It found a bunch of instances of the old IFerror, but apparently not all of them.

that, or excel 2002 is doing something different that is causing trouble.

 

Zonker13

Please don't let that moronic Troll screw up a great contribution to the warlock community Bakka! We very much appreciate your hard work.

 

Trickykid

You will need to find/replace on every tab, which means you need to be sure under search options that you choose "within workbook" rather than just within the sheet.

 

Bakka

I'm back. I, as of 5 minutes ago, own a new site which I am in the process of setting up, making functional, etc. and more importantly, I'm the full admin of. I want to be able to do with this site what I couldn't do with the other which is allow other people to have 'editor' rights. So I'm taking volunteers for anyone who wants to work on this 'new' spreadsheet and site going forward. The new site can be found at Warlock DPS Spreadsheet . So once you're registered, send me a PM or post on here with what you're interested in doing and I'll set people up with correct permissions. I'm looking for people who want to do anything from develop new features for the spreadsheet to maintaining a how-to/faq for the thing. The site is a wordpress site much like the old one, so now it's just a matter of getting it back to the same state as the old one and then moving forward.

Thanks for the support on this.

 

Rozzenwyn

<3 YOU BAKKA

 

elessar44

Well a friend managed to let me borrow a copy of 2007 and I now have a working copy of 3.08b. Thanks Bakka and everyone else who offered up help.

Helps to know I'm using the most up to date info for my gear selection. The old one was saying sticking with Distorded Limbs was a bigger DPS number than switching to my t7.5 legs for the 2 set bonus. Was weird.

 

kows

it's nice to see that you haven't given up on the community as a whole because of one guy trying to take a shot at you! thanks for the effort.