Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Class Mechanics » Druids

Closed Thread
 
LinkBack Thread Tools
Old 10/17/09, 5:28 AM   #61
Bootup
Glass Joe
 
Night Elf Druid
 
Eonar
Runed Cardinal Ruby Wrong Value

Originally Posted by xanibear View Post
Hey all. I believe I've noticed a glitch with the spreadsheet. The Runed Cardinal Ruby (epic spellpower gem) seems to have the wrong spellpower coefficient in the gem list. It's listed as 25sp and in game it manifests as 23. The gem list seems to be password protected and I can't manage to change it.

This spreadsheet is invaluable to me and the rest of my resto druids. Thank you so much for working on this!!
I noticed this was mentioned a while back but it seems as if it wasn't addressed. I just downloaded a copy of the spreadsheet and it still shows the Runed Cardinals as 25sp instead of 23. It also shows the same for the Runed Stormjewel.

Offline
Old 11/02/09, 11:32 AM   #62
nikaas
Glass Joe
 
Night Elf Druid
 
Darkmoon Faire (EU)
Are there any plans for making the spreadsheet to work with OpenOffice.org because it seems some VBA macros rewriting is necessary(wich lot of us i suppose cant do ourselves)? If there is some workaround possible i would be realy thankful if someone shares it.

Offline
Old 11/02/09, 9:15 PM   #63
Paininabox
Piston Honda
 
Paininabox's Avatar
 
Night Elf Druid
 
Runetotem
Originally Posted by nikaas View Post
Are there any plans for making the spreadsheet to work with OpenOffice.org because it seems some VBA macros rewriting is necessary(wich lot of us i suppose cant do ourselves)? If there is some workaround possible i would be realy thankful if someone shares it.
There are no plans for me personally making a version of this operational for openoffice. This is mostly due to time constraints.

Level 80 Restoration Druid Spreadsheet here.
(v1.41)

Offline
Old 11/27/09, 8:08 AM   #64
Mesitara
Glass Joe
 
Blood Elf Paladin
 
Ahn'Qiraj (EU)
Looks like the database has been updated. In free time when not feeling lazy i am writing a program for automation the getting the information on items, so soon™ might be able to tell what items are still missing.
Edit. My item parser works in such way: one manually gets html text with items, manually truncates info from it, with winword replaces some text with line breaks, saves result in text file, and only than treats the file to program. Having commas in unexpected places(e.g., item name) doesn't help writing. Getting all ways to get the item isn't easy when item can be obtained in various ways.
Edit2.items2_for_excel.zip is now testable. As always, usage of executables is on your own risk. How to use it: open Items - World of Warcraft in your favorite browser, choose the slot, click apply filter, click view source, select all, paste in notepad, save it. Double click the program, input the file name, and 3 new files should appear. The ones you would like to see, end with 1.txt and 2.txt. Open them with Excel and watch the result. The program shouldn't work with trinkets(one still may try to get the correct link).

Last edited by Mesitara : 12/11/09 at 8:39 AM. Reason: commas, different sources. looks like finished

Offline
Old 11/29/09, 12:17 PM   #65
Paininabox
Piston Honda
 
Paininabox's Avatar
 
Night Elf Druid
 
Runetotem
That would be really handy! If/when you get it up and running give me a jingle. On another note, currently I'm planning out the rewrite of the sheet and plan on making two versions. One will be for WotLK and the other for Cata; hopefully this will make the transition between expansions effortless.

Level 80 Restoration Druid Spreadsheet here.
(v1.41)

Offline
Old 12/01/09, 10:51 AM   #66
alorand
Glass Joe
 
Night Elf Druid
 
Stormreaver
Seems you don't have the Onyxia loot added, I tried adding it in the gearlist, but it is giving me issues. Also, it seems you do not have "Solace of the defeated" added.

Edit: Oh, the error when I hit recalculate is " run-time error"13" type mismatch."
(Great spreadsheet though!)

Last edited by alorand : 12/01/09 at 11:14 AM.

Offline
Old 12/01/09, 11:38 AM   #67
Paininabox
Piston Honda
 
Paininabox's Avatar
 
Night Elf Druid
 
Runetotem
Yeah, adding loot to the Gearlist will error out the calculation, because the lists that the gear and buffs sheet uses are separated from the gearlist itself due to how vlookup works. Thus when the gearlist puts that item into the gear setup, it will cause all the vlookup functions to spit reference errors everywhere and cascades down everything eventually causing the vba code to error. This is one of the big things I'm going to work on in my rewrite, that and some kind of automated method for updating the databases.

Level 80 Restoration Druid Spreadsheet here.
(v1.41)

Offline
Old 12/21/09, 7:55 AM   #68
lxsli
Glass Joe
 
Night Elf Druid
 
Argent Dawn (EU)
Sorry to bug you but any ETA on 3.3? I'm curious how HT is weighing in against Nourish these days.

Offline
Old 01/09/10, 3:26 PM   #69
♦ Carebare
::stare::
 
Carebare's Avatar
 
Tauren Druid
 
Mal'Ganis
When Pain has one ready to work with 3.3 a new thread will be started. Since it's currently out of date I'm going to lock this so we don't end up with a bunch of folks posting for update status.

<Nite_Moogle> i miss raiding with carebare :< she makes me feel like i am not the only person that hates everyone
Aldriana: I am an asshole, it just so happens that some of my colleagues are even *bigger* assholes.
[R] [85:Neux:2]: i hear if you die on Good Friday they are going to make it where you can't get rezzed until easter sunday
Khazal: Yeah, I don't know about Magic Rainbow Unicorn Land, but here in Reality, Rhyolith is the worst encounter Blizzard has ever designed.

United States Offline
Closed Thread

Go Back   Elitist Jerks » Class Mechanics » Druids

Thread Tools

Similar Threads
Thread Thread Starter Forum Replies Last Post
[10m][Horde][Bonechewer] <Escaper> - 8/12HM (PST, 12hr Week) Amijay3 /LFGuild 43 03/24/11 1:47 PM
Resto UI Discussion Tegid Druids 778 12/06/10 6:59 AM
[Shaman] Resto PvP MissnL1nK Player vs. Player 89 08/02/10 6:41 PM
[Resto] 3.1 PTR changes and testing Philondra Shamans 318 04/21/09 5:43 PM
[2v2] Rogue + Resto Druid vs. Warrior + Resto Druid Reubarb Player vs. Player 14 10/07/07 5:47 AM