I was wondering if there is way to enable macros for a Mac-based Excel. It seems to disable them for me and I can't update/load/change anything. The .xlms and other recommended "Save-As" templates are only causing errors when trying to open them and not really solving any problems.
Sorry if this has been mentioned before but I can't seem to find anything about it. In a previous version of the spreadsheet there was an option to 'assume hit capped' or something along those lines. I personally think that's a brilliant idea especially the way spreadsheet seems to treat hit for me.
I am 72 over the hit cap and yet hit is, according to the overview tab, more valuable to me than agility or any other stat for that matter. I have tried everything I can think of to fix it. The only thing that seems to work is giving myself custom gear with ridiculous amounts of hit (actually it has to be > 10^19). Then the attribute value jumps from 1.6 down to zero and the Needed to Hit Cap value can't be dislayed (you just get a cell full of #####). Then ofc, the recalculate dps button needs debugging as the line
from the regemmer macro can't be understood. Using the debugger to change hitToCap = 0 just broke the gear planner completely but using a negative number seemed to work. Using a large number in the order of 10^4 again broke the line but after testing with various different powers of 10 it doesn't seem to make a difference to the gear planner. Any negative number gives the same results. But not in the way I'd expect. I've ended up using -1 and -9999. Items with hit didn't become less of an upgrade in fact mostly the opposite happened. My neck, for example, [Sparkling Onyxia Tooth Pendant] was given a better delta value than before. Another interesting thing happened to the trinkets. Suddenly [Bandit's Insignia] and [Gnomish Lightning Generator] are the two BiS with undisplayably large delta values. Another thing to note is that although changing the line in the regemmer code does then allow the recalculate dps button to work, it does seem to have broken parts of what I assume are the regemmer. Basically the gear planner no longer shows 'Current Item with Regem'.
As far as I understand it hit vs. a lvl 83 boss isn't a soft cap. Once you have 0% chance to miss surely that's it, having more hit is useless. Ofc, I know very little about the inner workings of this spreadsheet, but I assume that these attribute values help calculate dps upgrades in the gear planner? So I thought you might like to know. Sorry if its working as intended and I'm actually an idiot but if anyone has the time I'd love someone to explain why this is happening... just for interest's sake.
Well assuming you had the boss still at level 83 you need a lot of +hit to compensate the level difference. And it's not precisely a situation the sheet can cope with (or was designed to cope with).
Using it out of the bounds defined for use (i.e. being level 80 attacking a level 83 boss) is not something I've really kept up-to-date or bugfixed, sorry. It is very likely a lot of the calculations will bug out or show undesired results.
Sorry I didn't mean to sound ungrateful for all your work. I am using the spreadsheet on all of its default settings except for the odd test I've done trying to tweak things, which I've described above. (Ofc I don't except it to be able to coupe with my messing around with the code. I was just telling you what I'd tried). As I understand hit, you need 8% +hit in order not to miss against a lvl 83 boss. I have over 8% and the spreadsheet seems to be telling me I need more. I was just wondering if there was a way to stop this, as a previous version had the option to disregard hit.
Do not mistake the numbers on the overview page. The +hit value doesn't cap out and go to 0. It's the average value +1 hit going from 0 hit to hit-capped. The gear planner doesn't use those values though since it actually tries out each item.
The "CD until" for the Aimed Shot is listed as 23.60.
The code in VB that makes the control is
If haveShot = 0 And ShotTable(i, 2) <= currentTime + And ShotTable(i, 1) <> "None" Then
Using "<=" it should pick the Aimed shot... but it does not.
Iamcal, that made the last major update to the Rawr wow simulator (major Update made in the v2.2.14 release), where he made the hunter module copy the spreadsheets calculations as close as possible (to the current v91e spreadsheet) noticed the same challenge while programming in C#.
He solved it by an "ugly" hack.
Snipet from Rawr code
// this is a horrible round hack, i know. the issue probably comes
// somewhere from a float->double cast.
// the issue is that we have currentTime at (e.g.) 65.35 and steady shot CD is at 65.3500000001
// so we skip forward by 0.1 seconds when we didn;t really need to.
if (!haveShot && s.time_until_off_cd <= currentTime+0.00001)
Adding the "+0.00001" to the spreadsheets code seem to solve the problem as well.
If haveShot = 0 And ShotTable(i, 2) <= (currentTime + 0.00001) And ShotTable(i, 1) <> "None" Then
I have no idea what causes the problem. When debugging the VB code and adding watches... both variables shows 23.6.
I also tried to have the currenttime variable dim'ed as variant as well... but that did not help.
No, the actual problem is due to the fact that 0.01 (and most of its multiples) have no exact representation in binary floating point (as does 0.1, etc.) So if one computation gets to 23.6 by adding some number of multiples of .01 and another computation gets to 23.6 by adding a different number of multiples of .01, the two results generally will not match.
The simplest way to fix the problem is just to multiply the times by 100 or 1000 (i.e. work in integral milliseconds.) Older spreadsheets used to support BCD numbers; I couldn't find any reference to that in the Excel documentation.
I am looking at 92.b of the spreadsheet. One the Calculations worksheet in the Armor Penetration block. The calculation for the armor Constant looks correct when compared to wowwiki, but the Level_Selected parameter appears to be set to 80 when the boss level is set to 83. The result is a Constant of 15232.5 for a level 83 boss.
This quote is from wowwiki
For a level 80 target, C=15232.5. For a level 83, C=16635.
I am wondering if wowwiki has it wrong, I have my spreadsheet setup wrong, or there is a possible bug with the calculation. Can anyone else confirm or deny?
I searched the forums for armor + pen + constant before posting and only saw a quote of the wowwiki page I am referencing with no rebuttal of the information presented there. If this has been previously reported, I apologize.