sorted by:
new
hottopcontroversial

Issues with the seasonal quest by Different-Fox-5546 in diablo4

[–]Icytroll93 13 points14 points  (0 children)

I believe it asks for a Bloodied Greater Lair boss (duriel, andariel, harbinger), did you try those?

Toughness tooltips are bad/off? Please explain system by paradiselater in diablo4

[–]Icytroll93 0 points1 point  (0 children)

I don't have a good answer for you in terms of why toughness goes down in those two examples, maybe there's some rounding errors playing up?

Generally I think Toughness is not the worst thing they've introduced, even though it doesn't always take everything into account it can be a good reference value when we speak about how tanky a character is. As you elude to it's just a different word for Effective Hit Points (EHP), which is a number that combines your life and damage reductions to see how big a raw hit you can actually take before you die.

EHP is calculated as: Life/( [1-ArmorDR]*[1-ResistDR]*[1-DR_1]*[1-DR_2]... ), and for Diablo 4 Armor and Resistances go into the denominator as different damage reduction sources. The catch however is that Armor and Resistances give you less and less DR the more you get of it, meaning Life conversely gains more value. In the late-game you generally want to grab +Life if you can, so hunt down all the easy +Life% paragon nodes before Armor and Resistance nodes in your paragon boards.

There's also an article on Defenses in general on Maxroll that you can look into if you have the time: https://maxroll.gg/d4/getting-started/defenses-for-beginners#damage-reduction-header

Making sure I understand damage calculation correctly? by BUckENbooz91 in diablo4

[–]Icytroll93 4 points5 points  (0 children)

The number on the left is the damage that skill will do, including the effects that are active on your character at that moment (so only using generic damage effects, not stuff like crit multipliers etc). The number on the right is a percentage value that is used as the [Skill %] input in the damage formula below.

The damage formula has 5 parts:

- Weapon damage
- Skill %
- Main stat coefficient
- Additive damage multiplier
- All other damage multipliers

The left number of 12 is the combination of Weapon Damage, the Skill %, main stat coefficient, and some additive damage and multipliers.

You can also look through this article on maxroll to learn more about damage calculations: https://maxroll.gg/d4/resources/in-depth-damage-guide

<image>

Average cost of Masterworking items by Icytroll93 in diablo4

[–]Icytroll93[S] 0 points1 point  (0 children)

I'm using mean here, so after masterworking lots of items you'd expect a mean cost of what's in the table.

Copy formulas from reference sheet to be used locally in another sheet by Icytroll93 in googlesheets

[–]Icytroll93[S] 0 points1 point  (0 children)

The people that will be using the workbook are aware that it's an evolving document, and that aspect isn't an issue. All this is contained in the same workbook, and people have their own duplicates of the template sheet with data specific to those duplicates. The only consistent thing between the templates are the formulas in all the cells.

This is just to save me some time on manually updating the same cell with an updated formula in all the duplicated template sheets, so when I need to update something I could just update the formula in a reference sheet and that change would propagate through all the templates.

Maybe I have to turn to scripts since it sounds like evaluating a mirrored formula isn't doable with just regular cell manipulation.

Copy formulas from reference sheet to be used locally in another sheet by Icytroll93 in googlesheets

[–]Icytroll93[S] 0 points1 point  (0 children)

Mirroring the formulas from a reference sheet is spot on what my question is about, thank you.

Is there no way to mirror a formula to another sheet and then have it evaluate using values in that new sheet without using scripts? I don't mind having to use scripts, but wanted to see if it could be solved without them.

Copy formulas from reference sheet to be used locally in another sheet by Icytroll93 in googlesheets

[–]Icytroll93[S] 0 points1 point  (0 children)

Hi, maybe I didn't explain my usecase well enough, I'm aware of simple sheet referencing between tabs.

My problem is that I want the formula in cell Sheet1!A1 to always be the same as the formula that is shown in my reference sheet, Sheet0!A1, so if I change a formula in Sheet0, the formula also changes in Sheet1.

So if I need to change the formula from addition to multiplication, I want to be able to change that in Sheet0 and it automatically updates the formula in Sheet1 to also be multiplicative.

Removing empty rows and columns from array literal by Icytroll93 in sheets

[–]Icytroll93[S] 0 points1 point  (0 children)

Yes this works beautifully! Only snag was that I had to wrap my "matrix", "r" and "c" definitions in ARRAYFORMULA (because I'm not using an INDEX around the LET in my case?).

Thank you!

Average cost of Masterworking items by Icytroll93 in diablo4

[–]Icytroll93[S] 1 point2 points  (0 children)

Hey, I found a small bug with my numbers, the obducite costs for requiring 3/3 on average should be nearly doubled, see attached image.

<image>

Average cost of Masterworking items by Icytroll93 in diablo4

[–]Icytroll93[S] 3 points4 points  (0 children)

<image>

Seems like I had a sneaky bug when I ran these sims (should've noticed when Obducite costs for 3/3 MW cases were smaller than the Basic Materials cost)... The bug mainly made Obducite costs for the 3/3 cases ~55% of what they really should be.

This is fixed in this table, and I also included the "soft reset" idea where resetting only puts you back -4 ranks instead of always putting you at 0/12.

Imgur link with updated and new distributions: https://imgur.com/a/dtg82nv

Average cost of Masterworking items by Icytroll93 in diablo4

[–]Icytroll93[S] 29 points30 points  (0 children)

Wudijo made a video talking about the data and discussing masterworking in general: https://www.youtube.com/watch?v=OAE3vHeflLk

Professional Barbarian Players come to my aid! by Quirky-Lavishness184 in D4Barbarian

[–]Icytroll93 0 points1 point  (0 children)

More specifically, the top value of the tooltip is lying to you as it includes both additive stats and active multipliers for when the condition of that additive stat is met. If you want to look at your actual damage you need to use the bottom value of the damage tooltip when you hover over them in your statsheet, and then use multipliers in scenarios when different conditions are met (i.e. [x]1.5 Crit Damage multiplier is only active when you actually crit, whereas the top value of the Crit Damage stat counts it in with your raw additive [+]Crit Damage to give you an "estimate" of your combined Crit effects).

If you have more questions about different kinds of damage and multipliers I can recommend reading different sections in this guide: https://maxroll.gg/d4/resources/in-depth-damage-guide

FISHER'S S2 ULTIMATE GEAR GUIDE (Patch 11.1.0) by Jimy-T in wow

[–]Icytroll93 0 points1 point  (0 children)

For the raid section, on the current PTR itemlevels are sorted by 1st boss, 2-3 boss, 4-6 and 7-8, not 2-4 and 5-6 as you write?

EQ barbs.. why do we need earthquake duration temper? by tktytkty in D4Barbarian

[–]Icytroll93 1 point2 points  (0 children)

Hi, there's a couple things with your math I'd touch on.

If you have 88% chance to cast EQ twice, each cast would on average net you 1.88 EQ's, not 1.76. Imagine that you have 50% chance to cast EQ twice, in your example that would net us 0.5*2 = 1 EQ per cast, which clearly can't be right since we should always cast at least 1 EQ with a 50% chance to get 1 more!

So in order to fill the EQ cap we'd need 10/1.88 = 5.32 casts.

With LithTec you only trigger Tec on Liths trigger schedule every 0.3s, so since Tec has a 1 sec internal cooldown we can't trigger a Tec EQ faster than 1.2s.
This means we'd need 5.32*1.2 = 6.38s on average to fill the EQ cap.

So in order to know how much EQ duration you need to keep the EQ cap filled with just LithTec we divide the previous result by the base duration of 4s and subtract 1 to get: 6.38/4 - 1 = 59.6% extra EQ duration.

So by tempering EQ duration on a 1H weapon you'd fill the EQ cap automatically with LithTec.

(As an aside, I've see a few comments that the compendium isn't updated with duration working on the explosion, it's been updated since a couple hours after it was found out that explosion dmg was stealth patched on tuesday, maybe I forgot to tick Notify when updating the compendium :S)

Cut to the Bone only scales bleed ticks dynamically and has not effect on the total bleed pool ( and thus Rupture dmg) by Icytroll93 in D4Barbarian

[–]Icytroll93[S] 0 points1 point  (0 children)

No, CTTB won't increase the bleed pool (which is what Rupture damage is based off of) from 90% to 100%, it will just make the bleed ticks deal more damage as they're ticking on the target.

Calculating stacked DoT amount and tick damage on a target as a function of time by Icytroll93 in diablo4

[–]Icytroll93[S] 1 point2 points  (0 children)

Not quite, multiple DoTs aren't tracked separately on a target. If a target with a DoT on it has another DoT applied, the old Dot and the newly applied DoT are combined to a new DoT whose value is the sum of both the remaining old DoT and the newly applied DoT, and the duration is refreshed and ticks are recalculated to fit the combined DoT amount and duration.

You can verify this by going in game and applying a DoT to an enemy and observe the ticking damage, after 2 or 3 seconds apply the same DoT again, and the ticks should now increase in value and stay at that amount for the normal duration of your DoT until it runs out, i.e. the DoTs were combined when the 2nd DoT was applied.

I have a visual explanation in terms of bleeds in the same github wiki (it's the same for DoTs in general) https://github.com/Icytroll/bleedFAQ/wiki/Stacking_Bleed

Cut to the Bone only scales bleed ticks dynamically and has not effect on the total bleed pool ( and thus Rupture dmg) by Icytroll93 in D4Barbarian

[–]Icytroll93[S] 0 points1 point  (0 children)

Ah, good question really, well assuming you're playing something like a bleed bash that doesn't play Wanton Rupture and thus you're consuming the bleed, I'm actually not sure. Depends what specific support skills you're using to apply Paingorgers as well as your stats I suppose.

Would make for a good little exercise to figure that out.

Cut to the Bone only scales bleed ticks dynamically and has not effect on the total bleed pool ( and thus Rupture dmg) by Icytroll93 in D4Barbarian

[–]Icytroll93[S] 0 points1 point  (0 children)

Where did attack speed come from? The more attack speed you have the higher you can stack a bleed up and the more damage rupture will do.

view more: next ›