Trying to figure out Guild Exp list

[Damian666]

s... i am trying to define a fair guild exp list for leveling up.

but im having trouble finding a good calculation for it...

this is what i have atm:

Public Sub LoadGuildExp()
        Dim I As Long

        GuildExpList(1) = 10

        For I = 2 To 100
            GuildExpList(I) = GuildExpList(I - 1) + GuildExpList(I - 1) / 4
            Debug.Print("Exp " & I & " : " & GuildExpList(I) & vbCrLf)
        Next
    End Sub

which is nice on earlier levels, but level 100 is a staggering:

Exp 100 : 39876618672

so yeah, any one know of a better way to generate the exp list?

[Kibbelz]

Remember, somthing like this is also relitive to how your games experience scales as well. Even with the "right" formula distributing too much or not enough exp also impacts on the formula. My personal recomendation would be:

((I * 10) + total_exp_of_all_levels_before) / I

[Damian666]

yeah i know that, but seeying this is for a pokemon game, and they get just 1 exp per wild, and 2 per player battle, it should be ok.

what does your I stand for in this context?

[jcsnider]

It is the same I variable you use in your for loop.

[Damian666]

aaah, ok, so its 1x10 etc, gotcha

[Kibbelz]

Yeah. That formula is used for most experience formula in most games. It will work for you assuming the experience earnt is set around the formula.

[Damian666]

k cool, ill try it out, thanx guys