This will calculate a Pathfinder Sorcerer's spells per day including bonus uses. CL is "Caster Level", MOD is "Ability Modifier", and SPELL is "Spell Level".

sorcerer_spells_per_day.google_sheets

=if(
  SPELL=0,
  "∞",

  max(
    0,
    if(
      or(
        SPELL=1,
        gt(CL+1-SPELL*2, 0)
      ),
      roundup((MOD-SPELL+1)/4,0),
      0
    )
  )+

  min(
    6,
    if(

      or(
        SPELL=1,
        gt(CL+1-SPELL*2, 0)
      ),

      max(0,(CL-(SPELL*2-1))+2)+

      if( or(SPELL=1,and(SPELL=9,CL=20)), 1, 0),

        0

    )
  )
)