Jump to content

Welcome to Rune Tips, the first ever RuneScape help site. We aim to offer skill guides, quest guides, maps, calculators, informative databases, tips, and much more to help you get the most from the Massive Online Adventure Game, RuneScape, by Jagex Ltd © 2009.

Report Ad

Welcome to Forum.Tip.It
Register now to gain access to all of our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more. If you already have an account, login here - otherwise create an account for free today!
Photo

Sven's Guide to RS High scores Tracking with Google Docs


  • Please log in to reply
22 replies to this topic

#1
sven_bohikus
[ Display Name History ]

sven_bohikus

    Rat Meat

  • Members
  • 33 posts
  • Gender:Not Telling
  • Joined:25 February 2007
  • RuneScape Status:P2P
  • RSN:Svenne
  • RSN2:d4damager
  • Clan:Supreme Skillers
Sven Bohikus' Guide to RS High scores Tracking with Google Docs Spreadsheets



[This thread was lost in the great tip.it flood of 2008 - luckily I had edited and saved my post on a GoogleDoc! Reposted here for your convenience!]



Table of contents
1. Rationale
2. Getting started
3. Setting up your spreadsheet
4. Reading in high score data
5. Finding experience point deltas
6. Keeping your spreadsheet sorted
7. Charting your top-10
8. Sharing and publishing your document
9. Limitations
10. Thanks to old friends and new


#14340th to 99 magic!! w000t

#2
mchainmail
[ Display Name History ]

mchainmail

    Moss Giant Whipper

  • Members
  • 2,672 posts
  • Joined:7 March 2006
That's awesome.



Is there any way to store the imported data like every 24 hours?
Posted Image

#3
sven_bohikus
[ Display Name History ]

sven_bohikus

    Rat Meat

  • Members
  • 33 posts
  • Gender:Not Telling
  • Joined:25 February 2007
  • RuneScape Status:P2P
  • RSN:Svenne
  • RSN2:d4damager
  • Clan:Supreme Skillers
It republishes the data to the same web page -- if you used a mirroring script it could pull it down periodically.



I haven't found a way to grow the spreadsheet with tracker-like data imports by date.

#14340th to 99 magic!! w000t

#4
zoomkey
[ Display Name History ]

zoomkey

    Chicken Feather

  • Members
  • 17 posts
  • Joined:30 September 2007
very, very nice guide!



Could you give a code for tracking prices of the ge database? It would help A LOT of moneymaking guides who want to give an accurate money/hour. It's just an idea but i'm pretty sure loads of people would use it.

#5
sven_bohikus
[ Display Name History ]

sven_bohikus

    Rat Meat

  • Members
  • 33 posts
  • Gender:Not Telling
  • Joined:25 February 2007
  • RuneScape Status:P2P
  • RSN:Svenne
  • RSN2:d4damager
  • Clan:Supreme Skillers
This is a bump for the purpose of insuring this be kept for the Player Made Guides forum.



Erm ... -bump-

#14340th to 99 magic!! w000t

#6
Wkw
[ Display Name History ]

Wkw

    Ice Giant Melter

  • Members
  • 3,565 posts
  • Gender:Not Telling
  • Joined:25 February 2005
  • RuneScape Status:None
  • RSN:wkw
=INDEX(ImportDATA(CONCAT("http://hiscore.runescape.com/index_lite.ws?player=",A2)),9,3)

That is for cooking..

How do I tweek it for something else?



I got it!



9 is the skill, 3 is what you want it to be. GOT IT :D

aaaaauserbar.gif

Wkw.png

Runescape player since January 2005
Ego Sum Deus Quo Malum Caligo et Barathum


 


#7
ikkevincent
[ Display Name History ]

ikkevincent

    Goblin Armour

  • Members
  • 114 posts
  • Gender:Not Telling
  • Joined:13 November 2004
  • RuneScape Status:None
Hi sven. i got a question about your tracking system.



Could i apply this on the GE prices too? ive tried a couple of things, and failed.

i would like to insert the price from wolf bones, this is the link

http://itemdb-rs.run...tem.ws?obj=2859



Thank you



ikkevincent

#8
Sativas
[ Display Name History ]

Sativas

    Chicken Feather

  • Members
  • 14 posts
I've been looking for something like this forever, HUGE bump and thanks.



I was wondering if you could do the same thing with excel, and if so how would you import the stats on there?

#9
sven_bohikus
[ Display Name History ]

sven_bohikus

    Rat Meat

  • Members
  • 33 posts
  • Gender:Not Telling
  • Joined:25 February 2007
  • RuneScape Status:P2P
  • RSN:Svenne
  • RSN2:d4damager
  • Clan:Supreme Skillers

Hi sven. i got a question about your tracking system.



Could i apply this on the GE prices too? ive tried a couple of things, and failed.

i would like to insert the price from wolf bones, this is the link

http://itemdb-rs.run...tem.ws?obj=2859



Thank you



ikkevincent




I think you already found this other thread but I will link it here:

How to use Google Docs to extract GE prices ~By Brainymidget

http://forum.tip.it/...?f=180&t=782319

#14340th to 99 magic!! w000t

#10
sven_bohikus
[ Display Name History ]

sven_bohikus

    Rat Meat

  • Members
  • 33 posts
  • Gender:Not Telling
  • Joined:25 February 2007
  • RuneScape Status:P2P
  • RSN:Svenne
  • RSN2:d4damager
  • Clan:Supreme Skillers

I've been looking for something like this forever, HUGE bump and thanks.



I was wondering if you could do the same thing with excel, and if so how would you import the stats on there?




I started off with Excel and it does work - but it wasn't easy to share with others. You use the 'get external data' function of excel and it creates an entire sheet of the imported HTML. You can then reference the cells in the new sheet using regular Excel formulas.



Some reference links on Excel and web data are available here:

http://www.exceluser...ebqueries_1.htm

http://support.microsoft.com/kb/165499

#14340th to 99 magic!! w000t

#11
Joe1992b
[ Display Name History ]

Joe1992b

    Chicken Feather

  • Members
  • 2 posts
  • Joined:25 April 2009

=INDEX(ImportDATA(CONCAT("http://hiscore.runescape.com/index_lite.ws?player=",A2)),9,3)

That is for cooking..

How do I tweek it for something else?



I got it!



9 is the skill, 3 is what you want it to be. GOT IT :D




9 is the skill id, and 3 is exp in that skill realtime.



if you follow the address for the html grab (http://hiscore.runes...lite.ws?player=",)

change player to any username and make your window small so you only have 3 columns then the first row is total level and the third column is exp in that skill ( 1,3 )

so do the same for any skill; 9,3 = cooking etc always keep the 3 (as it is the exp value as oppose to rank or level) and change the first number to suite the skill you want,



anyways nice guide man helped alot

hope i helped

#12
xequma
[ Display Name History ]

xequma

    Chicken Feather

  • Members
  • 19 posts
  • Joined:3 April 2006
  • RSN2:Xequma
I do that with excel, but is excel really the same thing as what your doing?

#13
Ultimute
[ Display Name History ]

Ultimute

    Chicken Feather

  • Members
  • 3 posts
  • Joined:24 July 2009
ty good guide! \<img src=/' />
Posted Image

#14
AgingMiser
[ Display Name History ]

AgingMiser

    Goblin Armour

  • Members
  • 96 posts
  • Gender:Not Telling
  • Joined:23 October 2008
  • RuneScape Status:Retired
  • RSN:Aging Miser
  • RSN2:Evil Scruff
  • Clan:TTFS
Cool. This is better if you're tracking xp over a set amount of time though, like 2 weeks or whatever.



For daily xp and such, there are tracker sites like rsstats.nl & runemonkey.net that you can use, which tbh, I'd much rather prefer using.



Still, cool and informative =D>
Posted Image

#15
TyrantElf
[ Display Name History ]

TyrantElf

    Unicorn Horn

  • Members
  • 197 posts
  • Gender:Male
  • Location:Runescape
  • Joined:1 March 2008
  • RuneScape Status:P2P
  • RSN:TyrantElf
  • RSN2:dauth reona
  • Clan:Hunt4stars
could you make/find a way for it to put down the information periodically?


Proud Ubuntu User!

There are no stupid questions, just stupid people. -Scott Adams
“A computer once beat me at chess, but it was no match for me at kick boxing.”-Emo Phillips


My Blog!
Posted Image
Posted Image


#16
x1donut
[ Display Name History ]

x1donut

    Chicken Feather

  • Members
  • 4 posts
  • Joined:26 February 2010
this is great

#17
x1donut
[ Display Name History ]

x1donut

    Chicken Feather

  • Members
  • 4 posts
  • Joined:26 February 2010
K so i have a problem when i paste the link =INDEX(ImportDATA(CONCAT("http://hiscore.runes....ws?player=",A2)),9,3) what would it be if i wanted to get excell to pull the data insted of useing google docs?

#18
GlobalSmack
[ Display Name History ]

GlobalSmack

    Chicken Feather

  • Members
  • 24 posts
  • Gender:Male
  • Location:Lumbridge
  • Joined:22 March 2010
  • RuneScape Status:P2P
  • RSN:Global Smack
Very nice, Sven. Simple and easy to amend to my own needs...Here's an example of something I threw together for myself that could be used to track goal completion and average daily gains.

http://spreadsheets....Y2OGY2NFE&hl=en

There's a nice function in the Google spreadsheet that allows you to just continue from the previous cell...so you can work around that limitation on how many indexes you pull from.

HOW THAT WORKS:
I'll go with the example you set up in your guide...
Posted Image
so in C3 we have the formula to pull the Cooking XP.
in C4, we just use the formula "=CONTINUE(C3,10,3)"
that will pull the XP of the next skill, Smithing. (Reuse the cell's index, row 10, col 3)

This would only really work if you want to read multiple entries from a certain table you pull from. The limitation is 50 References, the CONTINUE function allows you to use a reference more than once...perfect if you're just making a personal skill list or something.




(side note: nice to see a former fellow skillaz member, hope all is well)
Posted ImagePosted Image

#19
sven_bohikus
[ Display Name History ]

sven_bohikus

    Rat Meat

  • Members
  • 33 posts
  • Gender:Not Telling
  • Joined:25 February 2007
  • RuneScape Status:P2P
  • RSN:Svenne
  • RSN2:d4damager
  • Clan:Supreme Skillers
I'm always impressed when I see other people's RuneScape related Google docs and they mention this post as how they got started. This is looking a little old and creaky now but still seems to be helping people.

One thing I thought I should mention, something that took me a while to figure out. If you are in another country where the comma is used instead of a decimal point (ie 3,14 for PI rather than 3.14) then you will be using a SEMICOLON to separate elements in your IF statements instead of COMMAS.

That took ages to realize and only occurred when someone from Portugal created a new document with my instructions and pasted my IF's into their document.

Good luck to everyone who continues to make and use Google docs!

#14340th to 99 magic!! w000t

#20
Waave
[ Display Name History ]

Waave

    Chicken Feather

  • Members
  • 3 posts
  • Gender:Male
  • Location:Minecraftia
  • Joined:17 March 2011
  • RuneScape Status:F2P
  • RSN:Waave
  • RSN2:SoundRift
I do realize that this post is somewhat old and that this is the first reply in some time. However, as I was trying to figure out how to do exactly what this guide means to explain, I realized that Jagex has changed their website format; the ImportDATA and link do not work anymore. The solution I found is the following cell formula:

=Index(ImportHTML("http://services.rune...aave","table",1),23,5)


My username is Waave, so just replace that with your username and the cell should spit out the appropriate information. The above formula gives Runecrafting experience.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users