Link !!So Ask the Devs have kindly posted the mana regen formula.
Anyone working on a calculator?Let us know
Merv its easy:So Ask the Devs have kindly posted the mana regen formula.
Anyone working on a calculator?Let us know
Focus
Med
Int
Actively meditating?
MR from gear
Med-able Armour?
1 - MR (Base)
2 - MR (Focus)
3A - MR (Meditation)
3B - MR (If meditation is GM)
3C - MR (If actively meditating)
4A - MR (Item base)
4B - MR (Item base modified)
4C - MR (Item intensity)
4D - MR (Item final)
5 - MR (Total)
120
120
150
1
31
1
0.2
=B1/200
=0.0075*B2+0.0025*B3
=IF(B2>99,B10*1.1,B10)
=IF(B4=1,B11*2,B11)
=(B2/2+B1/4)/90
=B13*0.65+2.35
=IF(SQRT(B5)>5.5,5.5,SQRT(B5))
=IF(B5<1,0,(B14*B15-(B14-1))/10)
=IF(B6=1,B8+B9+B12+B16,B8+B9+B16)
Which version of Excel are you using? I didn't get it to work since your are using . instead of , in desimals, and if I fix that it doesnt recognize what you are meaning by , Bx (for example =IF(B2>99, B10*1.1, B10).This is a crude version using MS Excel. If you have Excel,
And copy this to column B:
Not tested in other spreadsheet programs or even google spreadsheet. But it should work. Only issue might be with the SQRT function. If so, use this instead - B5^0.5Code:0.2 =B1/200 =0.0075*B2+0.0025*B3 =IF(B2>99, B10*1.1, B10) =IF(B4=1, B11*2, B11) =(B2/2+B1/4)/90 =B13*0.65+2.35 =IF(SQRT(B5)>5.5, 5.5, SQRT(B5)) =IF(B5<1, 0, (B14*B15-(B14-1))/10) =IF(B6=1, B8+B9+B12+B16, B8+B9+B16)
First 5 rows in column B is where you plug in your values. I am using max possible values as an example.
If the value in B2 is greater than 99,
then return the value in B10 multiplied by 1.1
Else, just return the value in B10.
It says error in the formula.Strange, I'm using excel 2003 as well.
Does Excel say there was an error in the formula?
Or does it give an "#Value!" error?
Or a "#Name" error?
Edit: Btw, the comma isn't a decimal.
=IF(B2>99, B10*1.1, B10) means that
If the value in B2 is greater than 99, then return the value in B10 multiplied by 1.1
If not, just return the value in B10.
See if inserting a space before comma work any better, ie
=IF(B2>99 , B10*1.1 , B10)
Still not working.Ignore the part about adding spaces, I think Excel works better if the spaces are removed.
I have edited the formulas in my original post to remove the spaces. See if this works for you.
Yup, the comma is used by the IF function to separate the variables.Still not working.
If we look B10 for example =0.0075*B2+0.0025*B3
If I change it 0,0075*B2+0,0025*B3 it works. In which "mode" you have your cells? For some reason I think we have different use for , and . here.
I mean, you are using . to put decimals there right? And then you are using , for some other purpose in B12 for example =IF(B4=1,B11*2,B11)
I quess those , have something to do with the IF option?
It's been years since I did anything even a bit complicated with excel...