Hey,

 

I had a relatively simple question really, I want to know how to program excel to automatically pull my character's experience in each skill from the Runescape high scores, and place the data on my spreadsheet so I can do some tracking/calculations.

 

I'm running Excel 2007.

 

Thanks :)

Is there any reason why you're using excel instead of google spreadsheets?

I prefer using excel, plus I have hundreds of different excel logs that I link between each other so using Google Docs won't really help me.

First of all you need to setup the spread sheet, you need to format 41 cells in a column to type TEXT(

), we do this so that excel doesn't mess up the number formatting by adding extra ","'s, and this needs to be done before the data import.

 

For the first 27 cells you use the following three formulae.

=LEFT(A1, FIND(",", A1, 1) - 1)
=MID(A1, FIND(",", A1, 1) + 1, FIND(",", A1, FIND(",", A1, 1) + 1) - FIND(",", A1, 1) - 1)
=RIGHT(A1, LEN(A1) - FIND(",", A1, FIND(",", A1, 1) + 1 ))

 

For the next 14 cells you use these two:

=LEFT(A28, FIND(",", A28, 1) - 1)
=RIGHT(A28, LEN(A28) - FIND(",", A28, 1))

 

You will need to change the cell references.

 

Edit: I assumed you would be using the lite hiscores api:

http://hiscore.runescape.com/index_lite.ws?player=zezima