sven_bohikus

I remember clawing my way to 44 Runecrafting -- mining 3k pure ess and making nats -- then rebuying pure ess and doing it again and again. Got my first whip that way. I remember when I realized it had ~only~ 8k fires to make to get to 44 and I power leveled it.

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.

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!] [hide=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[/hide][hide=1. Rationale]My use of spreadsheets to track RS high scores started while I was a council member of Skillaz clan. We would regularly host a 'skill week' wherein members were encouraged to gain as much exp in one skill as they could in a period of time (I once posted 2 million thieving exp. in 3 days). High scoring skillers would get prizes before the trade limits and later were given special signatures for their effort. Keeping track of the experience gained by 30+ clan mates was difficult to do by hand, and while creating an html or php based file to show simple high score data and differentials was easy, finding hosting for such a file was troublesome. Google Docs turned out to be the answer, offering a simple and easy to use front end, free hosting, and the ability to read high scores. Getting the high scores data into the spread sheet was tricky though and people have often asked my my technique for doing so, hence this guide.[/hide][hide=2. Getting started]You will need a google gmail account to make google documents. If you have a gmail account, you're ready to go. Sign into the google documents web page at http://docs.google.com If you do not have a gmail account, you can create one on the same page. Note: I used to have privacy concerns surrounding the use of Google for document storage, and I still do. However in this instance the data on your spreadsheet is already available on the Internet in another form. Should you choose to use Google Documents more extensively, you should use caution and consider what sort of other files you really wish Google to hold for you. Most importantly pay close attention to the terms of service http://www.google.com/accounts/TOS?hl=en and the privacy policy http://www.google.com/google-d-s/privacy.html .[/hide][hide=3. Setting up your spreadsheet]Choose From the 'New' menu choose 'Spreadsheet' In row number 1 type in the headings for your spreadsheet. I use Name, Starting exp, Current Exp, and Exp Delta. You can call them anything you like. Grab the divider line as shown in the image below and slide it down below your headings. This will freeze your heading and make it easier to sort the remainder of the spreadsheet. You want to grab the grey rectangle indicated by the yellow box and drag it with the mouse down. It should look like this when you have it moved correctly. Add a player's RS name in column A row #2 -- Type in my name 'sven_bohikus' or any other name you like. Add starting exp for the same user in column B row #2, here you can find any variety of sources for this data, I like to get a PDF of scores from RuneHead, then copy and paste the data from there. Take a moment and Save your spreadsheet before the next step.[/hide][hide=4. Reading in high score data]The next step is a formula for the cell at column C row #2. This formula will get experience data from the RS high scores page automatically and parse the data until we have a single data value from a user's high scores page. Here is the formula for the cell: =INDEX(ImportDATA(CONCAT("http://hiscore.runescape.com/index_lite.ws?player=",A2)),9,3) Explaining the parts of this might be tricky: INDEX - allows us to pick one ROW and COLUMN as if you were looking at the official RS High scores page. Row 9 column 3 in the example is current exp points for cooking. ImportDATA - gets the contents of a URL, in this case it gets a table of high score numbers for a given user. CONCAT - this will concatenate the high scores retrieval stub to the player name in the cell to the left. Put it all together and you will get a single integer value back from the high scores table, if your user's name is correct. Use the fill handle (small black square handle on the bottom right hand corner of a cell selection rectangle) to fill this formula down for all the rows in your spreadsheet.[/hide][hide=5. Finding experience point deltas] In cell D2 type the following '=C2-B2' this will subtract the starting exp from the current exp. As before use the fill handle to fill this formula down for all rows of your spreadsheet.[/hide][hide=6. Keeping your spreadsheet sorted]In our uses we liked to see who the top 10 experience gainers were for the time period of the competition. This required sorting the data by the Exp Delta column. I haven't found a way to keep the spreadsheet sorted automatically, but if you click the grey bar under the Exp Delta header, you will get a menu that allows everything under the divider bar to be sorted in ascending or descending order. [/hide][hide=7. Charting your top-10]You can make a second sheet in your document to hold a top 10 chart and have it automatically redraw every time you open the document. On the bottom of the Google Docs window, look for a button 'Add Sheet' and click it. You will be taken to the second sheet immediately. In Cell A1 add a title for your chart - for example 'Cooking Competition'. In cell A2 of Sheet2, type an = (equal sign) and then click on the tab for Sheet1, and select cell A2 on Sheet1 then hit enter. This will bring the Player name from A2 on Sheet1 to A2 on Sheet2. Do the same thing in column B to bring the Exp from Sheet1 to Sheet2. Position the chart to the right of your list of people to chart. Use the fill function to extend the number of data items to copy over from the 1st sheet. As i said before we used to use a top 10 but you can copy all of them over if you wish.[/hide][hide=8. Sharing and publishing your document]This is the best part - want to put your high scores and chart on the Internet? Well what great luck for you today, it already it is! Its important to know the difference between 'Sharing' and 'Publishing' in Google Docs terms. Sharing means giving google the names of other google docs users who can open or edit your documents. In practice I have rarely used this. Publish means to put the data in your document on the Internet where it will be accessible by a public URL. Most often you will want to use Publish, unless you have high scores helpers. If you do have multiple people helping you, you will always be able to see ALL revisions listed by date and time, and be able to revert to any version of your document at any time - so share fearlessly. In the upper right hand corner of the Google Docs window, look for the Publish tab and click it. The first time you choose this you must click 'Publish now' The window will change to show you an active link to your published document. Be sure to check the 'Automatically republish' box if you wish to have the published document follow your changes when you save. If you have added a second worksheet with a chart, it will be included if you choose All Sheets. [/hide][hide=9. Limitations]Google will only let you put 40 ImportDATA functions into any one spreadsheet. This can be troublesome if you have a very large clan or competition. ImportData functions only update once an hour, clearly something closer to real time would be better, but at least no one can say you're hammering the RS high score system with many needless requests. The sheet doesn't stay sorted unless you go in and poke it to be sorted. This can be a bother and is a good place for you to 'Share' the document so others can help you keep it sorted ans shipshape. Some times, ImportDATA functions decide not to get their data. Sometimes, this happens, you need to be patient and wait until the next time the cell is due for an update. At all times remember how much you are paying for this service -- nothing.[/hide][hide=10. Thanks to old friends and new]Thanks to bernice00 who is awesome and not just because she has the word nice in her name for finally getting me to write this guide. Also thanks to SDK_Loyal for his asking for the instructions earlier. Best wishes to all the former members of Skillaz clan, and to all the current members of Solers clan of which I am now a part. Thanks to everyone in RS who has made me feel welcome in this great game... and as for the rest of you ... you'll get yours later.[/hide]

Got that one wrong eh?

The only place they dont give exp is in the cave where you fight and kill 10 trolls with the help of the honor guard during the quest. All the others do give exp. Actually I understand the quest trolls dont give drops either. All the drops for the trolls are still the same. In one slayer assignment for trolls I collected around 20 addy full helms, 4 mithril warhammers 7 addy wc axes, 4 rune warhammers 2 rune kites, 50 raw sharks 338 balls of wool, 120 seaweed, and a granite shield. Again thats in about 150 trolls - amazing really.

The best safe spot for ranging (for me) was the spot indicated in yellow -- range them over the river as well and you'll never run out of trolls. What to bring additions... 20 law runes and 200 airs and 200 fires -- to stay behind the rocks and grab the good drops -- to alch lesser items like addy helms -- grab all laws and nats Enchanted Lyre -- most players do not know you can make many enchanted lyres, I have 30 :lol: -- recharge your lyre with bass and your ring of charos -- use your lyre to tele back to the gate of Rellekka run north and then take ferry to the Nietisnot. Easy 1 click escape tele as well in case of emergency. Don't forget that these trolls count for troll slayer assignments. Also it should be noted this is a -very- cost effective crystal bow training location. :thumbsup: