Community Event Let's Find How Spell Cost Is Calculated, 8le!

Yea that’s what I’m suspecting, yhat equation should work barring that one edge case. Should be easy checking for that though.

 

welp... if you manage to find a working formula let me know :/

 

So the formula we posted doesn't function? Can you give us a specific build with specific values so that we can test? We can create items to test it, if necessary too.

 

Well it should work for most cases, the ONE place it doesn't work is if a spell it reduced to one purely by intelligence and rounding. Certain spells seem to be able, but certain spells don't.

It seems to be that ALL spells that have a cost <6 are able to be reduced to one, despite, if the formula is true, that it should round down after intelligence is applied. Thats what I figured out anyways

 

Blue mask, vaward, spring ... ids don't matter

Add +100 intel, you'll end up with 140 intel when holding spring

Spells should be:
2 1 1 3
(astorm, escape, bomb, ashield)

 

The equation I have so far is

Code:

netSpellCost = (int)(Math.round((spellCost * (1-intMod)) + rawSpellCost) *(1+spellCostPercent));

if(nonModifiedSpellCost > 5 && netSpellCost < 2 && spellCost == 0 && spellCostPercent = 0){
      netSpellCost = 2;}

 

Code:

finalCost = floor(ceil(spellBaseMana * (1 - intPct / 100) + idSpellCostRaw) * (1 + idSpellCostPct / 100));
if (finalCost < 1)
    finalCost = 1;

 

that doesnt work, arrow storm would cost 1 using that equation, not 2 like it should.

 

The cost of arrow storm with this formula actually comes out to 2. The key difference is that it uses ceiling in place of round, bringing the 1.308 value (6 * (1 - 0.782)) up to 2. It rounds up regardless of how small the fraction is.

 

That doesn’t work, arrow shield costs 4, I tried that as well

 

Are you sure you're using the correct base mana cost for arrow shield? The mana table on Wynndata is incorrect; the cost of arrow shield at 0 intelligence is 8 mana. The resulting cost with this formula should be 3 rather than 4 if you use 8 instead of 10 as the base cost.

 

That’s at 31, at max upgrade it costs 10 mana

edit: huh, the mana costs online Is incorrect.

Edit: it seems ceiling should work, that’s what I originally tried, but the website is wrong about base mana costs. Strange

 

why not just ask the dev?

 

I dont think they ever spoiled how something is calculated

 

they want to keep the mystery hunt i guess

 

I think the formula I had was this:

Although IM testing implies normal rounding. So... idk lol.

 

This works with my Spring / test scenario. I'll have to test more but looks like you got it....

also yep, for all this time I was testing with arrow shield costing 10 while it actually cost 8, I went through and rechecked all the formulas posted in this thread just to be sure.... yours is the only one working with my spring.

I'll do some more testing but I'm pretty sure you are the winner :)

 

the correct formula has already been found and the reward given

 

Locked on OPs request, if you want an unlock just report this or PM a mod