The easiest SP Calculator

matrixall · Post by **matrixall** » Mon May 14, 2007 2:35 am

Hello everyone, :wink:

Befor I get started I would like to clear somthing...

If you didn't use the old SP calculator..stop :!:

go and have a look b4 u coninue reading my writing...
if u did b4 just go on

long time ago :roll:

, I was thinking of making new character
and farming all I need of SP untill lvl 70,
I tried to calculat how many I need...
but I didn't know how to divide them through all lvls

.
..so I thought n thought n thought :cry:

I read a lot about newten bohr and even psycologist

... but no progress :banghead:

... and for a while I thought a little bit about my self :wink:

and I discoverd how smart I am ....

Here is my Nuclear Bomb :?:

...srry I meant My SP Calculater

...

( Not mine really but developed version of the old one )

U can download it from this URL:

http://matrixall.tripod.com/SP_Calculator.xls

if it doesn't work above

try this one:

http://rapidshare.com/files/31185933/SP_Calculator.xls

and these some explainations...

The following links are Images links if they don't show up :
http://matrixall.tripod.com/SPexp1.JPG
http://matrixall.tripod.com/SPexp2.JPG

Finally ...I :love:

SRO
Best Regards

*: If u r so busy skip red coloured text .. :wink:

(( too late

))[/url]

gould · Post by **gould** » Mon May 14, 2007 2:39 am

WOW!!!! Nice job

Seems very organized.

cin · Post by **cin** » Mon May 14, 2007 2:41 am

img dont work

vaan89 · Post by **vaan89** » Mon May 14, 2007 5:39 pm

really nice

matrixall · Post by **matrixall** » Mon May 14, 2007 7:51 pm

cin wrote:img dont work

Try again...

mike2007 · Post by **mike2007** » Tue May 15, 2007 7:20 am

very well done and pretty easy to use
i just have two questions
1. if possible could u make a slightly updated version that u can enter in specific lvls and gaps that will give a number without having to manually add up the totals?
2. how the hell did you manage to figure out all the numbers of sp per lvl for each gap? i got the cumaltive totals on the side and bottom but that other part boggles my mind

Website · Post by **satman83** » Tue May 15, 2007 7:28 am

thanks...but like mentioned above can you add slightly updated version
that u can enter in specific lvls and gaps that will give a number without
having to manually add up the totals?

flexo · Post by **flexo** » Tue May 15, 2007 2:08 pm

satman83 wrote:thanks...but like mentioned above can you add slightly updated version
that u can enter in specific lvls and gaps that will give a number without
having to manually add up the totals?

i have a file that is something like this... and I tried to add what you said.

the formula is easy just that you need to convert lvl to row number and the gap to collum-letter. And well I don't think Excel can do that. If someone knows how.. i'll gladly make the update

just in case ppl want mine too.. here it is..I got a SPvsExp table and a trader table in it too.. basicly this are all my data tables

http://rapidshare.com/files/31445535/SR ... s.xls.html

**edit** I didn't edit it.. it's just my file so it has some calculations I did on the side. Ow i'm no fan of keeping a small gap for long so I didn't add the diffrent lvl's sp
I usually make a 5 or 6 gap then close it again. So never do I farm for like 10lvl's straight.

Besides everybody farms at lvl 16, 24, 32, 42,52, and so on.. So although it's a nice file.. I can't really see the point in adding up all the sp for 10lvl's

matrixall · Post by **matrixall** » Tue May 15, 2007 2:22 pm

mike2005 wrote:very well done and pretty easy to use
i just have two questions
1. if possible could u make a slightly updated version that u can enter in specific lvls and gaps that will give a number without having to manually add up the totals?
2. how the hell did you manage to figure out all the numbers of sp per lvl for each gap? i got the cumaltive totals on the side and bottom but that other part boggles my mind

thanks for posting guys... :wink:

well, to answer ur first question... I will try to put some explainations later (time now is studying for exams only)

and the second question, I used the old sp table that posted b4 and I made some edits ...that's it....hope u find it helpfull :wink:

flexo · Post by **flexo** » Tue May 15, 2007 2:29 pm

matrixall wrote:
mike2005 wrote:very well done and pretty easy to use
i just have two questions
1. if possible could u make a slightly updated version that u can enter in specific lvls and gaps that will give a number without having to manually add up the totals?
2. how the hell did you manage to figure out all the numbers of sp per lvl for each gap? i got the cumaltive totals on the side and bottom but that other part boggles my mind

thanks for posting guys...

well, to answer ur first question... I will try to put some explainations later (time now is studying for exams only)

and the second question, I used the old sp table that posted b4 and I made some edits ...that's it....hope u find it helpfull

about the first question.. i don't think that's what he meant... (could be wrong)

but I think he wants something like this:

start lvl: ?
end lvl:?
start gap: ?
end gap: ?

and when you fill that all in.. it comes up with a number of sp. This could easily be programmed in a html/mysql or java.. but i'm lazy.. and not that great with those.

mike2007 · Post by **mike2007** » Wed May 16, 2007 6:10 am

flexo wrote:
matrixall wrote:
mike2005 wrote:very well done and pretty easy to use
i just have two questions
1. if possible could u make a slightly updated version that u can enter in specific lvls and gaps that will give a number without having to manually add up the totals?
2. how the hell did you manage to figure out all the numbers of sp per lvl for each gap? i got the cumaltive totals on the side and bottom but that other part boggles my mind

thanks for posting guys...

well, to answer ur first question... I will try to put some explainations later (time now is studying for exams only)

and the second question, I used the old sp table that posted b4 and I made some edits ...that's it....hope u find it helpfull

about the first question.. i don't think that's what he meant... (could be wrong)

but I think he wants something like this:

start lvl: ?
end lvl:?
start gap: ?
end gap: ?

and when you fill that all in.. it comes up with a number of sp. This could easily be programmed in a html/mysql or java.. but i'm lazy.. and not that great with those.

yup and i donno how to do that myself

cin · Post by **cin** » Wed May 16, 2007 6:13 am

nice. img's work. handy tool.

mmsicis · Post by **mmsicis** » Wed May 16, 2007 2:23 pm

http://stud3.tuwien.ac.at/~e0125557/sro/spgain.html - stupid nurds he stole the table from this

flexo · Post by **flexo** » Wed May 16, 2007 3:14 pm

mmsicis wrote:http://stud3.tuwien.ac.at/~e0125557/sro/spgain.html - stupid nurds he stole the table from this

we all know.. well I do.. still he added some numbers and it's nice..
so keep your name calling to yourself!!

=======================

And to all others.. Can anybody figure out a formula for this.. I'm still looking for one till lvl 80 or maybe even 90. But math ain't my best side.. so if anybody could see the sequence in this. That would help a lot.

matrixall · Post by **matrixall** » Wed May 16, 2007 11:43 pm

mmsicis wrote:http://stud3.tuwien.ac.at/~e0125557/sro/spgain.html - stupid nurds he stole the table from this

first of all I want to thank Mr.mmsicis for his nice words...

I think I mentioned in my post that it is

a developed version of the old one

that is enough as I think to let u, Mr.mmsicis and others, know it's not mine :roll:

thank u all guys and for the first question I don't think I can do what he asked ...but I might find another way of calculation which I'm willing to do ..

zirpel · Post by **zirpel** » Tue May 29, 2007 7:48 pm

is that the amount of sp you get with grinding without gt or st

RuYi · Post by **RuYi** » Tue May 29, 2007 7:52 pm

Your poll is corrupted.

Silkroad Online Forums

The easiest SP Calculator

what do think of my invention ?

The easiest SP Calculator