Autoupdating Excel Spreadsheet for RuneScape Guide

Ok, people have been asking me to make them an autoupdating spreadsheet for their goals and I'm getting a little tired of that so I am going to write a guide XD
I will be using my 99 Farming Price Calc as an example
Step 1: Open Excel
Step 2: Put in basic info of goal and outline of spreadsheet:

Step 3: Put in non-changing values

Step 4: Grab Stats from RS highscores
1.Go to the Data Tab

2. Click on the "From Web" button under the "Get External Data" section

3. Go to the Address Bar and type in this URL, replacing USERNAMEHERE with the username you want to use

Fast one, credits to Fudge

Alternative if that doesn't work


4. Once that page has loaded click on the arrow next to the stats table and click import at the bottom

5. When the Import Data Box opens click on properties and check the box "Refresh data when opening the file", select the cell you want to put the top left of it in and click ok

6. Now you have your stats! Now go to the place where you will be putting your current exp and put in this code where CELL is the cell with your current exp in said skill


7. Now for Exp Needed: x=exp of goal level


8. Now you should already have the exp for making the item or whatever 1 time ex: making one air battlestaff=137.5 Exp. Put in


You should now have the number of actions you need to do in order to get your goal level!

Step 5, Item Prices:
EDIT: The site I used because it wasn't in this format seems to have changed to the xx.xk format instead of the 100,000 format so this will not work anymore so as of now you'll need to put the item values in manually

Step 6:
Now you just need to do multiplication!


If you want to calculate profit simply put in

You put a - in front of the subtraction to make the negative value positive so in the next step you don't have to remember that the profit would be negative and loss would be positive

Then you do


All done, now you have an autoupdating spreadsheet!
I wrote this rather quickly so if I have made any mistakes just tell me and I'll try to fix them

Looks pretty solid to me. I take it that the Hiscore information goes on a separate sheet from the goals to make it less confusing?

thanks so much dude

I use spreadsheets for RuneScape all the time! Here's a screenshot of my runecrafting lights out puzzle solver. (The one in Daemonheim).

wow thats cool, Thanks helped alot

Reading is good

You could potentially use the lite hiscores (http://hiscore.runescape.com/index_lite.ws?player=%@PLAYERNAME) to increase speed, but I use a mac, and haven't used excel for this function before, so I can't try it out.

I thought you said to use http://hiscore.runescape.com/hiscoreper ... s?user1=USERNAMEHERE?

Oh, my bad. I was looking at this on my phone
I think it gives you the same result but it'd probably be faster loading, I'll put that in