Great work, looking things over now and I may be better geared than I originally thought... hah.
Anyone else seeing problems with the import function? I noticed in the macro it lists the URL as:
"http://" & server & ".wowarmory.com/character-talents.xml?r=" & realm & "&n=" & character & "&lang=en_us"
but the URL for armory for me is:
"http://www.wowarmory.com/character-talents.xml?r=" & realm & "&n=" & character
I've tried editting the URL in the macro and commenting out the server string on my side but still not playing well for me.
EDIT: Gleaming Lionseye had a trailing space throwing off the VLOOKUP and Storm Master's Helm does not have a socket bonus, should be updated to 4 Crit.
Fixed the edit stuff. As for the import function, I'm not exactly sure what the problem is with the url as Moshne was the one that added it in. What errors are you getting on the import? Version Mismatch? I'm currently looking at one that appears to be related to a pvp gem but I'm not sure how.
Originally Posted by Treylah
Just a question of clarification. On the neck items tab, you have listed the Shatterd Sun Pendant of Acumen (and of restoration). They're both listed as "Exalted - Aldor" (column I). It looks you've already factored in the procs that are associated with it. Did you intentionally leave out the Scryer version of the Shatterd Sun Pendant of Acumen?
[edit] I did select Scryer in the faction box on the main tab. So I'm assuming it's only a labeling issue at this current iteration of the spreadsheet. Looking at the formula, I think I was just mislead by the description in column I. The cell contents references the Scryer proc.
Yeah, it was a product of how I used to handle it (different items), but that broke the armory import so I settled on the faction selection
Great work, looking things over now and I may be better geared than I originally thought... hah.
Anyone else seeing problems with the import function? I noticed in the macro it lists the URL as:
"http://" & server & ".wowarmory.com/character-talents.xml?r=" & realm & "&n=" & character & "&lang=en_us"
but the URL for armory for me is:
"http://www.wowarmory.com/character-talents.xml?r=" & realm & "&n=" & character
I've tried editting the URL in the macro and commenting out the server string on my side but still not playing well for me.
EDIT: Gleaming Lionseye had a trailing space throwing off the VLOOKUP and Storm Master's Helm does not have a socket bonus, should be updated to 4 Crit.
The armory string is composed of the server (eu., or www.), your realm name, character name and language
"http://" & server & ".wowarmory.com/character-talents.xml?r=" & realm & "&n=" & character & "&lang=en_us"
The extra text isn't relevent to US based searches and "shouldn't be interfering. If you have any errors, please give me as much information as is being generated, but in my last test I was able to get it to work off your character name/server.
Binks sheet does not work with OO. There are issues with the dropdown selections that prevent OO from working with his setup. I have tried to keep my sheet simple so that it is compatible with OO, google, and MS however mine lacks the gear selection features and is focused on pure calculations. I'm thinking about how I can include similar functionality and keeping everything compatible. If I have some time I might try to do a rough equivalent in my sheet
I'm going to try to make it more OO compatible, starting with removing the indirect vlookup values which seems to be an excel only thing.
Originally Posted by Thogra
small thing: enchant Major Spellpower on weapon
Enchant lookups are now per-item.
Originally Posted by Ballam
EDIT: Gleaming Lionseye had a trailing space throwing off the VLOOKUP and Storm Master's Helm does not have a socket bonus, should be updated to 4 Crit.
Added in. Also added in missing resilience gems.
Originally Posted by Treylah
Just a question of clarification. On the neck items tab, you have listed the Shatterd Sun Pendant of Acumen (and of restoration). They're both listed as "Exalted - Aldor" (column I). It looks you've already factored in the procs that are associated with it. Did you intentionally leave out the Scryer version of the Shatterd Sun Pendant of Acumen?
[edit] I did select Scryer in the faction box on the main tab. So I'm assuming it's only a labeling issue at this current iteration of the spreadsheet. Looking at the formula, I think I was just mislead by the description in column I. The cell contents references the Scryer proc.
The armory string is composed of the server (eu., or www.), your realm name, character name and language
"http://" & server & ".wowarmory.com/character-talents.xml?r=" & realm & "&n=" & character & "&lang=en_us"
The extra text isn't relevent to US based searches and "shouldn't be interfering. If you have any errors, please give me as much information as is being generated, but in my last test I was able to get it to work off your character name/server.
Ok, I see the way that's set up now... Here's the errors, odd thing is there's two different ones, assuming that's because one is a VBA project and the other is a macro linked to the button.
A couple of other small things that I noted was that changing flasks, or not even using a flask, shows no increase or decrease in DPS or TTOOM. Also, if I choose to use battle and guardian elixirs instead, using an elixir of major mageblood has no effect on TTOOM.
Other than that, this new version seems to be working perfectly, thanks for all your hard work!
Ok, I see the way that's set up now... Here's the errors, odd thing is there's two different ones, assuming that's because one is a VBA project and the other is a macro linked to the button.
Double checked and I'm running Excel 2003.
May actually be a problem with your DNS/connection, as it works fine for me. Are you able to ping the server address?
Originally Posted by Alchaeus
A couple of other small things that I noted was that changing flasks, or not even using a flask, shows no increase or decrease in DPS or TTOOM. Also, if I choose to use battle and guardian elixirs instead, using an elixir of major mageblood has no effect on TTOOM.
Other than that, this new version seems to be working perfectly, thanks for all your hard work!
Ah, the flask table lookups were off by one. (just add one to the column values and it should fix it)
May actually be a problem with your DNS/connection, as it works fine for me. Are you able to ping the server address?
Nah, can reach the site fine but it may be related to work proxy... no big deal, I can update it manually until I figure it out. Probably a timeout due to the proxy.
Just so you know, there's a problem with consumables at the moment. I've fixed it, but also managed to break some of the armory import, so I've sent that off to Moshne to have a look at and tell me what I screwed up :s
Might start making a wotlk version now, getting the talents in & stuff.
When I compare the Lightning Capacitor in the Upgrades tab it gives no EP/DP due to the way EP/DP are calculated on that page. Instead of performing the calculation on this tab, would it make more sense to set EP/DP/SP on Upgrades as a VLOOKUP of the item in it's appropriate sheet?
Something along these lines since not all items have stats to calculate but do have values?
Named range encompases the trinket name and EP/DP/SP stat cells
EP=VLOOKUP(B#,trinkstat,2,FALSE)
DP=VLOOKUP(B#,trinkstat,3,FALSE)
SP=VLOOKUP(B#,trinkstat,4,FALSE)
Adjust for each comparative section; i.e: Helm, Neck, etc.
Or was this a step in trying to get away from VLOOKUP?
When I compare the Lightning Capacitor in the Upgrades tab it gives no EP/DP due to the way EP/DP are calculated on that page. Instead of performing the calculation on this tab, would it make more sense to set EP/DP/SP on Upgrades as a VLOOKUP of the item in it's appropriate sheet?
Something along these lines since not all items have stats to calculate but do have values?
Named range encompases the trinket name and EP/DP/SP stat cells
EP=VLOOKUP(B#,trinkstat,2,FALSE)
DP=VLOOKUP(B#,trinkstat,3,FALSE)
SP=VLOOKUP(B#,trinkstat,4,FALSE)
Adjust for each comparative section; i.e: Helm, Neck, etc.
Or was this a step in trying to get away from VLOOKUP?
I think the reason I did that was to include enchants in the upgrades list. May be a good idea to revert it.
The "Get Talents" function is not working correctly. When you click get talents, it fills in elemental just fine, but then copies your talent points from elemental into enhancement, and leaves resto blank, essentially giving you a 41/41/0 build.
Ah, I see what I did. In removing two columns & moving the talent tables left, it screwed up the references for the import.
Fixed and uploading a new one shortly.
I cant find the Cloak of the Frigid Winds in the Back list. i went to go add it, but i cant figure out how to calculate the EP and DP numbers. i think this is why the main sheet just keeps showing "#N/A" in most of the fields.
I was working on this for a friend and noticed that the amount of points in Unrelenting Storm isn't affecting mp5, which i notice blessing of wisdom isnt either but that does affect the TTOOM listing whereas Unrelenting Storm is affecting neither. Otherwise great spreadsheet, wish our lock one had the automatic fillout yours does.
I was working on this for a friend and noticed that the amount of points in Unrelenting Storm isn't affecting mp5, which i notice blessing of wisdom isnt either but that does affect the TTOOM listing whereas Unrelenting Storm is affecting neither. Otherwise great spreadsheet, wish our lock one had the automatic fillout yours does.
Thanks for the great spreadsheet. It really is nifty.
I did come across a bug, silly in nature, though. I had on [Don Carlos' Famous Hat] the other day when I imported my character and I got errors all across the spreadsheet just from that one hat. I fear this hat may be too overpowered for the spreadsheet to handle.
07/14/08, 6:01 PM
Similar Threads
