Kolin Posted August 15, 2012 Share Posted August 15, 2012 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 :) Link to comment Share on other sites More sharing options...
Hedgehog Posted August 15, 2012 Share Posted August 15, 2012 Is there any reason why you're using excel instead of google spreadsheets? Link to comment Share on other sites More sharing options...
Kolin Posted August 15, 2012 Author Share Posted August 15, 2012 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. Link to comment Share on other sites More sharing options...
Markup Posted August 15, 2012 Share Posted August 15, 2012 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now