Page 1 of 1

The easiest SP Calculator

Posted: Mon May 14, 2007 2:35 am
by matrixall
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 :D


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 .... 8)


Here is my Nuclear Bomb :?: ...srry I meant My SP Calculater :D
... :arrow: ( 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...

Image

Image


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 :D ))
[/url]

Posted: Mon May 14, 2007 2:39 am
by gould
WOW!!!! Nice job :)

Seems very organized.

Posted: Mon May 14, 2007 2:41 am
by cin
img dont work

Posted: Mon May 14, 2007 5:39 pm
by vaan89
really nice :)

Posted: Mon May 14, 2007 7:51 pm
by matrixall
cin wrote:img dont work


Try again... :D

Posted: Tue May 15, 2007 7:20 am
by mike2007
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

Posted: Tue May 15, 2007 7:28 am
by satman83
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?

Posted: Tue May 15, 2007 2:08 pm
by flexo
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

Posted: Tue May 15, 2007 2:22 pm
by matrixall
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:

Posted: Tue May 15, 2007 2:29 pm
by flexo
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... :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:


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. :)

Posted: Wed May 16, 2007 6:10 am
by mike2007
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... :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:


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

Posted: Wed May 16, 2007 6:13 am
by cin
nice. img's work. handy tool.

Posted: Wed May 16, 2007 2:23 pm
by mmsicis
http://stud3.tuwien.ac.at/~e0125557/sro/spgain.html - stupid nurds he stole the table from this

Posted: Wed May 16, 2007 3:14 pm
by flexo
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.

Posted: Wed May 16, 2007 11:43 pm
by matrixall
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... :P
I think I mentioned in my post that it is

a developed version of the old one :x

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 ..

Posted: Tue May 29, 2007 7:48 pm
by zirpel
is that the amount of sp you get with grinding without gt or st

Posted: Tue May 29, 2007 7:52 pm
by RuYi
Your poll is corrupted. :)