skill calculator in excel

A place for general discussion about Silkroad Online. Talk about the game or ask questions. Please keep threads Silkroad Online related.
Post Reply
User avatar
linya
Casual Member
Posts: 60
Joined: Wed Mar 26, 2008 2:49 pm
Quick Reply: Yes
Location: mercury

skill calculator in excel

Post by linya »

yo

actually i am trying to increase my excel skills, so i thought i may can make a skill calculator in excel. but for this i need to know how many sp i need when i up a skill or a mastery at what lvl. i dun wanna use rev6 or nivlam, i wanna get this info directly out of media.pk2. but i cannot find the file. can anyone tell me hows the name of the file(s) what i am searching for ? would be pretty nice !
Image
ISRO Mercury
[enLightens] * GreenFairy Absynthe

User avatar
Cruor
Loyal Member
Posts: 1999
Joined: Wed Apr 12, 2006 1:22 am
Quick Reply: Yes
Location: Off topic

Re: skill calculator in excel

Post by Cruor »

That information is in Media/server_dep/skilldata_*.txt. The level you acquire the skill is in the 37th column, and the SP requirement is in the 47th column. The actual names of the skills are in Media/server_dep/textdataname.txt, and you'll probably want to use something like Access to relate them to the skilldata. I've attached a command-line utility for cleaning up the text files for import.
Attachments
silk2tsv.zip
Utility for cleaning up Silkroad text files.
(6.83 KiB) Downloaded 101 times
Image

User avatar
linya
Casual Member
Posts: 60
Joined: Wed Mar 26, 2008 2:49 pm
Quick Reply: Yes
Location: mercury

Re: skill calculator in excel

Post by linya »

k thx imma check it out
Image
ISRO Mercury
[enLightens] * GreenFairy Absynthe

User avatar
zico
Casual Member
Posts: 57
Joined: Thu Sep 17, 2009 4:23 pm
Quick Reply: Yes
Location: Nowhere

Re: skill calculator in excel

Post by zico »


Post Reply

Return to “Silkroad General Discussion”