Wizard bonus spells per day

[NM020110]

I am experiencing difficulty in finding a formula to calculate the bonus spells per day a wizard receives from having high intelligence. I would highly appreciate if someone could please assist me in this matter.
Yes, I have tried to use google and the search function for this forum. The closest match was SRD's "In addition, she receives bonus spells per day if she has a high Intelligence score."

[Godskook]

There you go:

http://www.d20srd.org/srd/thebasics.htm

[jiriku]

The table is in the SRD. You should be able to derive the formula from there.

I think it's something like, for every two full points of casting stat you have above 10, you gain one or more bonus spells, such that:
The first bonus spell gained is level x, where x=(casting stat-10)/2
The second bonus spell gained is level y, where y=(casting stat-18)/2
The third bonus spell gained is level z, where z=(casting stat-26)/2
and so forth

This requires that you round all fractions down and ignore any result of 0 or lower.

[Caphi]

Fast rule:

Start at your modifier. That spell level gets +1 spell/day. Count down. Each of those spell levels gets +1 spell/day too. Every four, add another +1 spell/day for each spell level you count past.

So, shall we say, at a +7 modifier, you'd get one spell for 7, 6, 5, and 4, and two spells for 3, 2, and 1.

At a +15, you'd get two spells for 9 and 8, three spells for 7, 6, 5, and 4, and four spells for 3, 2, and 1.

Alternate answer: bonus spells for each spell level = (1 + modifier - spell level) / 4, rounded up.

[NM020110]

Thank you for the prompt and helpful response. +1 cake to all three of you!

[Godskook]

Thank you for the prompt and helpful response. +1 cake to all three of you!

Can it be cheese cake?

[Sinfire Titan]

Can it be cheese cake?

A Christmas cake is fine too.

[Studynot]

I know this is older but a nice clean formula in excel is this:

Roundup((*IntMod*-*SpellLevel*+1)/4,0)

Note: Replace things between *xxxx* appropriately.

If you name a field IntMod and just refer to the level of the spell in a table cell like G5 is 1, G6 is 2, etc such that the actual formula looks like this in cells K5:K14

=Roundup((IntMod-$G5+1)/4,0)
=Roundup((IntMod-$G6+1)/4,0)
=Roundup((IntMod-$G7+1)/4,0)
etc...

[averagejoe]

The Mod They Call Me: Thread necromancy.