Community Event Help Us Solve How Spell Cost Functions!

Alright gamers!

In the new update there were new ids added that change the cost of spells. There's both a % and raw version of these ids, and until now, we had no idea how the calculation involving them worked.

After HOURS of testing, we think we have a functioning formula that catches all awkward edge cases, but we aren't 100% sure and we need your help!

Here's our idea.

1. Start with how much the spell costs normally.
2. Apply the intelligence modifier.
3. Add raw spell cost.
4. Round the value to the nearest whole number.
5. Multiply by the spell cost %.
6. Truncate the value to the nearest whole number.

This SHOULD be the new cost of the spell on the first cast.
Through our testing this appears to be correct, but there could definitely be cases that we missed that break this. This is where you guys come in! See if you can find any strange interactions with spell costs ingame that don't follow this formula, and let us know so we can try and solve this mystery!

Repeat casting works with both raw and % spell cost as expected, the unknown for us is how the first cost is calculated.

Thanks for reading!
-The Item Team

@Major_Lue @jptheflip

 

@Druser @Bart (MC)

 

@dukioooo You can put this on Wynndata. Adding this functionality to WD might help people figure out edge cases that might break this formula. As far as anyone's concerned, this is the right formula.

 

cannot believe i am being ignored here

 

@by2011 ur mom

(pls test this)

 

I'll add this in 11h

 

ohh whhaaaaa jpppp flipflip

 

Just to make sure

ROUNDDOWN( ROUND((baseSpellCost * intelPercent / 100) + spellCostRaw) * spellCostPercent / 100)

right?


So if base spell is 10, Intel 150 (=80.8%), spellCostRaw +1, spellCost% 0:

Rounddown( round( (10 * 80.8 / 100) + 1) * 0 / 100)

Guess spellCostPercent should be (100+spellCost%)? Or 1+(spellCost%/100)

 

Haha, Arrow Shield 8 mana explains why you had 3 mana shields with Spring dukio...

I think that was one of my later formulas, which I abandoned because it didn't work with Arrow Shield lol. However, I recommend looking at situations where the sum of percent spell cost and intelligence modifier is positive (i.e. detrimental). I encountered a case with a weapon that had +25% Totem cost - at 0 Int I had 5 mana totems, which continued up until 29 Int. The moment I reached 29 Int, I got 3 mana totems.

 

Also, I'm pretty sure that first rounding is a rounding upward?

 

Is there a max -% spell cost? If not, how does getting over -100% spell cost work? Does it make that spell become 0 mana no matter how many times you cast it? For example: https://wynndata.tk/s/y6e052 does that mean you can spam cast aura infinite times and have aura still cast 0 mana? or does it use first spell cast as the base for the %?

 

/shrug

Pretty sure minimum for a spell is 1 mana, no matter what.

 

So then would aura have 1 mana forever?

 

continous spell cast add a cost, so it won't be 1 forever

 

mfw the IMs make the damage formula so complicated even they don't know how it works

 

omg jp never tags me :(

 

@Saya 10 char