ShadowCraft: Rogue spreadsheet for 4.0 - Page 14

nepsi · 03/20/11, 1:11 PM

Awesome work - cudos to all involved.

I noticed that changing talents does not auto update chances to miss etc. (taking Precision out etc.) only after a reforge all or optimize gems they get updated. Bug or feature?

• Aldriana · 03/20/11, 1:13 PM

The short answer is that the model probably isn't 100% accurate, but that on a theoretical uninterrupted single-target burn (which doesn't exist in current content) Combat probably is marginally ahead of Mutilate at equal gear. For a more in-depth discussion of the issue, take a look at this post, which dates to the 4.0.6 PTR but still does a pretty good job of capturing the issue.

Crevan · 03/20/11, 6:17 PM

I've encountered a problem with importing the random enchanted sword from Al'Akir, Stormblast version (hit+crit). Before my armory got updated, I tried manually selecting it from the list in Shadowcrat, but it wasn't there. I remember Antiarc mentioning that these items would be added to the UI when people import them from armory, but when I tried it, my character got imported without a weapon in MH slot. Is this a bug, or do we have to wait a bit for the items to get properly imported?

Meijnrr · 03/20/11, 7:33 PM

Thank you so much for this Spreadsheet Antiarc and anyone else who worked on it, I have just one query. When playing around with Sub, I noticed there is a option to turn off clipping Recuperate in your cycle and that it results in about a 50dps increase for Sub. The thing is I don't understand how not clipping Recuperate when you refresh it would be a dps increase, as you'd inevitably have at least a few tenths of a second of Recuperate downtime.

Crevan · 03/20/11, 7:41 PM

Recuperate gives you energy on every tick, and by refreshing it before it runs out you lose the last one, along with the energy it would provide

Antiarc · 03/20/11, 8:09 PM

@Faergun - I'll check out what's going on with it. I didn't put a lot of time into the Pawn string generation. Should hopefully be easy enough to straighten out.

@Matl1 - Filtering by source is a bit more difficult, since it means adding additional source data to each item, but I'll add it to the wishlist. It won't happy right away, but I'd like to eventually have it.

@LugoMall - I can add a clear button for the log/chart, sure. I won't be making the stats window locked, though, since smaller resolutions can't see the bottom portions of it without scrolling down.

@nepsi - That's a bug. I'll fix it.

@Crevan - that sounds like a bug. I'll see if I can fix it.

On a separate note, I'd like to give a special thanks to Caffeine, who has been checking over my code and has helped track down and eliminate multiple (embarrassing) bugs. Thanks so much for his help, and the continued support and feedback from the community.

TYious · 03/20/11, 9:15 PM

After running Auto reforge, I get this Reforged Dragonwreck Throwing Axe to -28 Haste Rating / +28 Expertise Rating. This doesnt seem right.

Sakuru · 03/21/11, 5:12 AM

I’m having some issues regarding my character import, for reference, I’m assassination specced. The import itself goes without a hiccup, but when I try to use the “Auto-reforge all” button, it wants me to reforge into Combat stats. The same goes for “Optimize gems”, the tool is switching out Rigid (hit) and Fractured (mastery) cogwheels, for Precise (expertise) and Quick (haste) cogwheels, and also it switch around some of my other gems to ignore some socket bonuses, such as in my Wind Dancer’s legguards it is replacing my purple and orange gems for 2 red ones, making me lose the 20 Agi bonus.

The leg gems is not a very big issue, as it basically yields the same EP value with two 40 agi gems as with one 20 agi/20hit and one 20agi/20mastery, I get 9 EP more with the hit/mastery combo (with the socket bonus taken into consideration).

As stated above the main issue is that it seems to be using EP values for Combat to optimize my Assassination specc. The issue persists even if I try different web browsers, I’ve tried Chrome, Firefox4, and IE, they all supply the same results. I’ve also tried to use the stock assassination spec over my imported one, but that does not help.
Secondly I don’t get any dps values or graphs up, is there something I need to activate/click to run an analysis, or is this intended to show up automatically, because the only two buttons I have is “Auto-reforge All” and “Optimize Gems”?

[EDIT]

I've added a link to an image that shows my results after reforging, and optimizing gems, and the result of gem optimizing is a neat -200EP..

Gem and reforge results.

sp00n · 03/21/11, 6:48 AM

That's the code I used for my wowhead JSON parsing (of this page), to classify the drop locations.
It's not 100% perfect, but it's a start.

$category = "";
// Heroic Raids
if ($item["level"] == 372 && $item["heroic"] == 1) {
	$category = "RaidHeroic";
}

// Normal Raids
elseif ($item["level"] == 359 && $item["heroic"] != 1 && isset($item["sourcemore"][0]["z"]) && ($item["source"][0] == 2 || $item["source"][0] == 5)) {	// 2 = Drop, 5 = Vendor
	$category = "Raid";
}

// Heroics
elseif ($item["level"] == 346 && ($item["heroic"] == 1 || $item["source"][0] == 5)) {
	$category = "Heroics";
}

// PvP
elseif ($item["source"][0] == 3 || $item["level"] == 365 || $item["level"] == 352) {
	$category = "PvP";
}

// General
elseif ($item["heroic"] != 1) {
	$category = "General";
}

Had to use some tricks to be able to parse the JSON though.

function json_decode_nice($json, $assoc = true){
	$json = str_replace(array("\n","\r"),"", $json);
	$json = preg_replace('/([{,])(\s*)([^"]+?)\s*:/', '$1"$3":', $json);
	return json_decode($json, $assoc);
}

$data    = array();
$matches = array();
$pattern = "#new Listview\({.* name: '([\w -]+)', .* data: (.*)}\);#";

preg_match_all($pattern, $content, $matches);

$slots   = $matches[1];
$rawData = $matches[2];
foreach ($rawData AS $key => $d) {
	$slot = $slots[$key];
	$data[$slot] = json_decode_nice($d);
}

// Zones
$zonesJSON = '{"1":"Dun Morogh","3":"Badlands","4":"Blasted Lands","8":"Swamp of Sorrows","10":"Duskwood","11":"Wetlands","12":"Elwynn Forest","14":"Durotar","15":"Dustwallow Marsh","16":"Azshara","17":"Northern Barrens","25":"Blackrock Mountain","28":"Western Plaguelands","33":"Northern Stranglethorn","38":"Loch Modan","40":"Westfall","41":"Deadwind Pass","44":"Redridge Mountains","45":"Arathi Highlands","46":"Burning Steppes","47":"The Hinterlands","51":"Searing Gorge","65":"Dragonblight","66":"Zul\'Drak","67":"The Storm Peaks","85":"Tirisfal Glades","130":"Silverpine Forest","139":"Eastern Plaguelands","141":"Teldrassil","148":"Darkshore","206":"Utgarde Keep","209":"Shadowfang Keep","210":"Icecrown","215":"Mulgore","267":"Hillsbrad Foothills","331":"Ashenvale","357":"Feralas","361":"Felwood","394":"Grizzly Hills","400":"Thousand Needles","405":"Desolace","406":"Stonetalon Mountains","440":"Tanaris","457":"The Veiled Sea","490":"Un\'Goro Crater","491":"Razorfen Kraul","493":"Moonglade","495":"Howling Fjord","616":"Mount Hyjal","618":"Winterspring","717":"The Stockade","718":"Wailing Caverns","719":"Blackfathom Deeps","721":"Gnomeregan","722":"Razorfen Downs","796":"Scarlet Monastery","876":"GM Island","1176":"Zul\'Farrak","1196":"Utgarde Pinnacle","1337":"Uldaman","1377":"Silithus","1477":"Sunken Temple","1497":"Undercity","1519":"Stormwind City","1537":"Ironforge","1581":"The Deadmines","1583":"Blackrock Spire","1584":"Blackrock Depths","1637":"Orgrimmar","1638":"Thunder Bluff","1657":"Darnassus","1977":"Zul\'Gurub","2017":"Stratholme","2057":"Scholomance","2100":"Maraudon","2159":"Onyxia\'s Lair","2257":"Deeprun Tram","2366":"The Black Morass","2367":"Old Hillsbrad Foothills","2437":"Ragefire Chasm","2557":"Dire Maul","2597":"Alterac Valley","2677":"Blackwing Lair","2717":"Molten Core","2817":"Crystalsong Forest","3277":"Warsong Gulch","3358":"Arathi Basin","3428":"Temple of Ahn\'Qiraj","3429":"Ruins of Ahn\'Qiraj","3430":"Eversong Woods","3433":"Ghostlands","3456":"Naxxramas","3457":"Karazhan","3483":"Hellfire Peninsula","3487":"Silvermoon City","3518":"Nagrand","3519":"Terokkar Forest","3520":"Shadowmoon Valley","3521":"Zangarmarsh","3522":"Blade\'s Edge Mountains","3523":"Netherstorm","3524":"Azuremyst Isle","3525":"Bloodmyst Isle","3537":"Borean Tundra","3557":"The Exodar","3562":"Hellfire Ramparts","3606":"Hyjal Summit","3607":"Serpentshrine Cavern","3698":"Nagrand Arena","3702":"Blade\'s Edge Arena","3703":"Shattrath City","3711":"Sholazar Basin","3713":"The Blood Furnace","3714":"The Shattered Halls","3715":"The Steamvault","3716":"The Underbog","3717":"The Slave Pens","3789":"Shadow Labyrinth","3790":"Auchenai Crypts","3791":"Sethekk Halls","3792":"Mana-Tombs","3805":"Zul\'Aman","3820":"Eye of the Storm","3836":"Magtheridon\'s Lair","3845":"The Eye","3847":"The Botanica","3848":"The Arcatraz","3849":"The Mechanar","3923":"Gruul\'s Lair","3959":"Black Temple","3968":"Ruins of Lordaeron","4075":"Sunwell Plateau","4080":"Isle of Quel\'Danas","4100":"The Culling of Stratholme","4131":"Magisters\' Terrace","4196":"Drak\'Tharon Keep","4197":"Wintergrasp","4228":"The Oculus","4264":"Halls of Stone","4265":"The Nexus","4272":"Halls of Lightning","4273":"Ulduar","4277":"Azjol-Nerub","4298":"Plaguelands: The Scarlet Enclave","4378":"Dalaran Arena","4384":"Strand of the Ancients","4395":"Dalaran","4406":"The Ring of Valor","4415":"The Violet Hold","4416":"Gundrak","4493":"The Obsidian Sanctum","4494":"Ahn\'kahet: The Old Kingdom","4500":"The Eye of Eternity","4603":"Vault of Archavon","4709":"Southern Barrens","4710":"Isle of Conquest","4714":"Gilneas","4720":"The Lost Isles","4722":"Trial of the Crusader","4723":"Trial of the Champion","4737":"Kezan","4742":"Hrothgar\'s Landing","4755":"Gilneas City","4809":"The Forge of Souls","4812":"Icecrown Citadel","4813":"Pit of Saron","4815":"Kelp\'thar Forest","4820":"Halls of Reflection","4922":"Twilight Highlands","4926":"Blackrock Caverns","4945":"Halls of Origination","4950":"Grim Batol","4987":"The Ruby Sanctum","5004":"Throne of the Tides","5031":"Twin Peaks","5034":"Uldum","5035":"The Vortex Pinnacle","5042":"Deepholm","5088":"The Stonecore","5094":"Blackwing Descent","5095":"Tol Barad","5144":"Shimmering Expanse","5145":"Abyssal Depths","5146":"Vashj\'ir","5287":"The Cape of Stranglethorn","5334":"The Bastion of Twilight","5339":"Stranglethorn Vale","5389":"Tol Barad Peninsula","5396":"Lost City of the Tol\'vir","5416":"The Maelstrom","5449":"The Battle for Gilneas","5600":"Baradin Hold","5630":"The Maelstrom","5638":"Throne of the Four Winds","5695":"Ahn\'Qiraj: The Fallen Kingdom","5706":"The Steam Pools","5723":"Firelands"}';

$zones = json_decode_nice($zonesJSON);

Leiata · 03/21/11, 7:42 AM

Hey Antiarc,

First off thanks so much for the hard work you and the others have done, the new spreadsheet looks great! I was hoping to make one request if it's not something that would require too much work. In the part where you can choose what buffs/debuffs, fight duration, etc is there any way you could add an option for just >35%? I only ask since we can't get the dummies down to below 100% health really so can't do the "backstab phase".

Other than that it's great and I've only encountered a few bugs (regemming producing downgrades and such) but I think it's just near hit cap.

Nyel · 03/21/11, 9:00 AM

First of all, its awesome.

Second, im having the same problems as Sakuru. IE: It is considering Combat EP values for my gear/reforge/gems, even though im Assassination.
Also, i dont have any stat weights, DPS calc/graph and all the glyphs have the same EP value.

I'm using Chrome on WinXP.

thecodester · 03/21/11, 10:47 AM

Well let me start by saying that u guys have done great work here, but i cant seem to get the new shadow craft to load, i keep getting a loading error . i used the beta that was on before , and i would love to try out this new version but i cant get it to load at all. my toon name is Thecodester from darkspear, i have no clue why its not working for me plz help me out. thanks

Lanwa · 03/21/11, 11:40 AM

Hi there,

nice work and pretty tool.

Just found out two little things and a wish:

1. Shadowcraft want to swap gems, if they aren't in the right order

Regemming Agile Bio-Optic Killshades socket 2 from Quick Cogwheel to Fractured Cogwheel
Regemming Agile Bio-Optic Killshades socket 3 from Fractured Cogwheel to Quick Cogwheel

2. The EP of an item isn't calculated by the actual EP-value of the char. Is it a pre defined value by BIS gear?

3. Maybe you can use a raid composition tool for the buff and debuff section (as MMO-Champion RaidComp does). So you just have to define the raid members to get all possible buffs and debuffs.

Cheers

Corik · 03/21/11, 12:25 PM

There seems to be a bug with optimize gems. First there are four delicate chimera's eyes which has been brought up but where they are placed in the gear has not. When I load my character from armory and use optimize gems it is updated to this. It puts two delicate chimera eyes in my chest and belt. For both the extra agility from the chimera eye outweighs the socket bonus for each piece individually but using a glinting demonseye in the blue sockets is more beneficial. If you make the chimera's eyes placed into the first three red sockets, if possible, I believe this would be fixed. The tool also puts two red gems in my legs when matching the sockets is slightly more EP.

Antiarc · 03/21/11, 3:42 PM

@Sakuru and @Nyel: Are you getting a DPS number in the top right? EP values aren't updated until the engine sends back a DPS number, and the default weights are combat weights. If you aren't getting numbers back from the engine for some reason, that'd explain it.

@thecodester: Your profile works fine for me. What browser/OS are you having issues on? What error do you get?

@Lanwa: The gems swapping I'm not worried about - it'll pick the highest-EP ones first. Item EP is calculated based on the weights you see on the sheet, but it's considering socket bonuses and potential reforges, as well. I'm not in a rush to redefine the buffs interface, but I did use the raidcomp tool to provide a list of each of the buffs that give a given raid buff. Maybe I could color code them or something.

@Corik: Good catch. I think I had that working properly at one point, then broke it. I'll see what I can do to un-break it.