Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Class Mechanics » Druids

Reply
 
LinkBack Thread Tools
Old 06/21/11, 9:00 PM   #196
Stommped
Piston Honda
 
Troll Druid
 
Magtheridon
A minor error with the spreadsheet, but appears the Leatherworking Bracer Enchant (130 int) is not included in the spreadsheet, even after selecting it as a profession.

Offline
Reply With Quote
Old 06/23/11, 6:54 PM   #197
 Tecton
Soda Popinski
 
Tecton's Avatar
 
Troll Druid
 
Mal'Ganis
Originally Posted by Stommped View Post
A minor error with the spreadsheet, but appears the Leatherworking Bracer Enchant (130 int) is not included in the spreadsheet, even after selecting it as a profession.
Just checked, it's in there in every version I can see going back for some time. You probably need to scroll up.

Scotland Offline
Reply With Quote
Old 06/24/11, 3:25 AM   #198
fountaiin
Von Kaiser
 
Troll Druid
 
Deathwing
So I've been using WC for a while now, but I've never taken the time to ask.

A) Is there a way to prevent the distortion of stats when I change a buff, for example DI to 'No' makes all my numbers go into the -3000s.

B) Are profiles/armory actually loadable? I've always just changed the items one by one because Load gives me an error (I'm probably using a wrong version: Excel 07 free DL :p). Whenever I change an item here it distorts the stats too.

Thanks in advanced. Sorry for the goofy questions.

Canada Offline
Reply With Quote
Old 06/24/11, 4:21 AM   #199
 Tecton
Soda Popinski
 
Tecton's Avatar
 
Troll Druid
 
Mal'Ganis
As far as the stats question, that's because we disable automatic calculation to avoid the tables recalcing every time you change any option at all. If you hit F9, it'll recalc all of the data tables and give you the figures you need (as noted on the main sheet). Data tables can take a long time to run, which is why we do this.

Profiles are working fine for me on several version on Excel, can you give me the error you're receiving (and have you enabled macros?).

Scotland Offline
Reply With Quote
Old 06/27/11, 6:52 PM   #200
 Hamlet
<Druid Trainer>
 
Hamlet's Avatar
 
Tauren Druid
 
Mal'Ganis
Here's what I have right now, don't actually remember if anything changed. Make any changes you need to and I'll move it to the OP during patch time tomorrow.
Attached Files
File Type: xls WrathCalcs 110621.xls (908.0 KB, 169 views)

Last edited by Hamlet : 06/27/11 at 7:16 PM.


United States Offline
Reply With Quote
Old 06/28/11, 12:34 PM   #201
 Tecton
Soda Popinski
 
Tecton's Avatar
 
Troll Druid
 
Mal'Ganis
OpenOffice should be working now, let me know if there are any issues with the fix.

I've updated the profiles function for the layout changes, I'm fairly sure that I got all of them. If anyone spots anything not copying over properly, please PM me!

[edit] Spotted a bug, updating! [/edit]

[edit2] Hmm, I've got the Gear Setup sheet working fine in OpenOffice, but there's been something introduced elsewhere that it's not liking. I'm trying to track it down now. [/edit2]

[edit3] Ok, tracked down the NEW problem and fixed it. Apparently OpenOffice doesn't like the way Excel fills in TRUE/FALSE via macro. Updated version attached. [/edit]
Attached Files
File Type: xls WrathCalcs 110628.xls (912.0 KB, 350 views)

Last edited by Tecton : 06/28/11 at 2:50 PM.

Scotland Offline
Reply With Quote
Old 06/29/11, 7:33 PM   #202
 Tecton
Soda Popinski
 
Tecton's Avatar
 
Troll Druid
 
Mal'Ganis
Moonwhisper, can you check if this is working for you:
Attached Files
File Type: xls WrathCalcs 110629.xls (875.0 KB, 340 views)

Scotland Offline
Reply With Quote
Old 06/30/11, 5:04 AM   #203
Moonwhisper
Von Kaiser
 
Night Elf Druid
 
Bloodhoof (EU)
Hi Tecton:
I tested the sheet now with my gear and it is working.
The broken dps/damage calculations are ok now. I didnt find any further errors.
Thanks!

Offline
Reply With Quote
Old 07/04/11, 1:36 AM   #204
 Hamlet
<Druid Trainer>
 
Hamlet's Avatar
 
Tauren Druid
 
Mal'Ganis
Was there a bug fix here that I should update to the main sheet?


United States Offline
Reply With Quote
Old 07/04/11, 2:39 AM   #205
 Tecton
Soda Popinski
 
Tecton's Avatar
 
Troll Druid
 
Mal'Ganis
A small OO fix, couldn't hurt to copy it over.

Scotland Offline
Reply With Quote
Old 07/07/11, 1:42 PM   #206
Moonwhisper
Von Kaiser
 
Night Elf Druid
 
Bloodhoof (EU)
I found a small bug in the gear stats of a belt item:
gale rouser belt of the undertow (normal) is wrong, it shows the same value as the heroic version.

Offline
Reply With Quote
Old 07/07/11, 2:09 PM   #207
 Tecton
Soda Popinski
 
Tecton's Avatar
 
Troll Druid
 
Mal'Ganis
Nice catch, I'll fix that in the next update. If you need to fix it now, go to 'Gear List', Row 521 and change "galerouserbeltheroic" to "galerouserbelt" in each of the stat cells.

Scotland Offline
Reply With Quote
Old 07/08/11, 5:36 AM   #208
 Hamlet
<Druid Trainer>
 
Hamlet's Avatar
 
Tauren Druid
 
Mal'Ganis
WC on the main thread with the above OO fix, Gale Rouser fix, the Flickering items listed in TreeCalcs thread, and Wild Mushroom change.


United States Offline
Reply With Quote
Old 07/08/11, 12:04 PM   #209
Alexsiss
Von Kaiser
 
Blood Elf Warrior
 
Doomhammer
I seem to be having an issue in the newest version(7/7) of Wrathcalcs. When I import gear from a previous version(6/28) I seem to be gaining hit rating magically. The 6/28 version seems to be accurate with both in game and armory tool tips so I am thinking it is a bug with the newest version. I looked briefly but couldn't find the issue but I will spend some more time looking later. I can also pm you my 2 copies of the sheet if you would like.

So I finally found the issue. Seem that when you import gearsets with random enchants it defaults them to of Flameblaze rather than preserving the random enchant name from before. I had a ring of Feverflare that this happened to. Hence the gain of hit.

Last edited by Alexsiss : 07/08/11 at 12:22 PM.

United States Offline
Reply With Quote
Old 07/09/11, 6:30 PM   #210
 Tecton
Soda Popinski
 
Tecton's Avatar
 
Troll Druid
 
Mal'Ganis
Originally Posted by Hamlet View Post
That's an option that has to commented better in WC. Right now it assumes you cast exactly one Starfall every Lunar Eclipse. You should really only use it if you're using Glyph of Starsurge in a normal-length cycle. The main reason it exists is to help evaluate Glyph of Starsurge.
From the other thread:

Do you want me to remove it from the dropdown unless GoSS is selected?

Scotland Offline
Reply With Quote
Reply

Go Back   Elitist Jerks » Class Mechanics » Druids

Thread Tools

Similar Threads
Thread Thread Starter Forum Replies Last Post
[Balance] Theorycraft / Spreadsheet Thread (WrathCalcs) Hamlet Druids 0 06/30/10 7:36 PM
TreeCalcs: WrathCalcs, respecced Hamlet Druids 42 02/04/10 3:31 PM
WrathCalcs - Moonkin DPS Spreadsheet Adoriele Druids 93 06/09/09 6:37 PM