It is currently Fri Aug 18, 2017 4:00 am

All times are UTC [ DST ]





Post new topic Reply to topic  [ 35 posts ]  Go to page 1, 2, 3  Next
  Previous topic | Next topic 
Author Message
 Post subject: OSRS Level 3 Skill Guide
PostPosted: Sun Mar 02, 2014 8:50 pm 
Offline
Clan Chat Moderator
Clan Chat Moderator

Joined: Fri May 11, 2012 10:40 am
Posts: 175
Words: 3726
Location: Uk
Runescape Name: domdizzle
Level 3 Dom
Runescape Status: P2P
Forum Status: Member of Peacefull.
World: 114
So I have decided to write up a skill guide for the most efficient way to max 1-99 as a skiller. I actually wrote the list about 2 months ago and it worked out that you would be able to max with money left over using these methods.

Feel free to let me know of any mistakes/changes you think are needed.

Here is an efficient maxing guide with a step by step maxing guide. It shows time taken/costs along the way. It includes when to level what skills and when to do quests.

Maxing guide


Here is the efficiency spreadsheet. The lower the efficiency rating the better.

Efficiency table



All the spreadsheets update with zybez prices.
:)

_________________
Image
Image
Image


Last edited by dom on Wed Mar 26, 2014 7:39 am, edited 20 times in total.

Top
 Profile  
 
 Post subject: Re: OSRS Level 3 Skill Guide
PostPosted: Mon Mar 03, 2014 10:26 pm 
Offline
Honored Member
Honored Member
User avatar

Joined: Sat May 30, 2009 3:21 pm
Posts: 1480
Words: 45397
Runescape Name: Godwyn
Runescape Status: P2P
Forum Status: Willing to help users.
World: 0
Nice work Dom! I always loved these threads. Hopefully a bunch of people will learn how to be a bit more efficient when they're choosing their methods for leveling. It would be nice if we could all contribute and find out xp rates and gp/xp ratios.

_________________
Previous used names:
I Pixil I
Naturiyn
Ouranias
Plate
Korvakov



Image


Top
 Profile  
 
 Post subject: Re: OSRS Level 3 Skill Guide
PostPosted: Tue Mar 04, 2014 1:12 am 
Offline
Honored Member
Honored Member
User avatar

Joined: Fri Sep 04, 2009 5:59 am
Posts: 824
Words: 8437
Runescape Name: Brxn
Runescape Status: P2P
Forum Status: Member of Peacefull.
World: 0
IRC Nick: Brien
spin flax til 99

/thread

_________________
Image


Top
 Profile  
 
 Post subject: Re: OSRS Level 3 Skill Guide
PostPosted: Tue Mar 04, 2014 10:34 pm 
Offline
Clan Chat Moderator
Clan Chat Moderator

Joined: Fri May 11, 2012 10:40 am
Posts: 175
Words: 3726
Location: Uk
Runescape Name: domdizzle
Level 3 Dom
Runescape Status: P2P
Forum Status: Member of Peacefull.
World: 114
Korvakov wrote:
Nice work Dom! I always loved these threads. Hopefully a bunch of people will learn how to be a bit more efficient when they're choosing their methods for leveling. It would be nice if we could all contribute and find out xp rates and gp/xp ratios.


Thanks mate I will work on writing it out with links to vids for the methods over the next few weeks. Gp/xp ratios are easy to work out just that they change and I don't want to be updating them all the time.

Spumy wrote:
spin flax til 99

/thread


Thanks will update to thread.

_________________
Image
Image
Image


Top
 Profile  
 
 Post subject: Re: OSRS Level 3 Skill Guide
PostPosted: Wed Mar 05, 2014 5:17 pm 
Offline
Alumni
Alumni
User avatar

Joined: Sat Mar 23, 2013 7:03 pm
Posts: 82
Words: 526
Location: Belgium
Runescape Name: Vdb
Runescape Status: P2P
World: 0
IRC Nick: Herselt
Mining
01 - 31 The Dig Site
31 - 77 Iron ore - 55k exp
77 - 99 Sandstone/granite - 60k exp

I'm wondering what you have to do to achieve 55k exp with iron.

_________________
Freljord Previously Herselt, Mmkay
Vdb Previously zFreljord, Herselt, Oya


Top
 Profile  
 
 Post subject: Re: OSRS Level 3 Skill Guide
PostPosted: Wed Mar 05, 2014 6:02 pm 
Offline
Honored Member
Honored Member
User avatar

Joined: Sat May 30, 2009 3:21 pm
Posts: 1480
Words: 45397
Runescape Name: Godwyn
Runescape Status: P2P
Forum Status: Willing to help users.
World: 0
With mousekeys and being in like w2.

_________________
Previous used names:
I Pixil I
Naturiyn
Ouranias
Plate
Korvakov



Image


Top
 Profile  
 
 Post subject: Re: OSRS Level 3 Skill Guide
PostPosted: Thu Mar 06, 2014 4:58 am 
Offline
Clan Chat Moderator
Clan Chat Moderator

Joined: Fri May 11, 2012 10:40 am
Posts: 175
Words: 3726
Location: Uk
Runescape Name: domdizzle
Level 3 Dom
Runescape Status: P2P
Forum Status: Member of Peacefull.
World: 114
Nick wrote:
Mining
01 - 31 The Dig Site
31 - 77 Iron ore - 55k exp
77 - 99 Sandstone/granite - 60k exp

I'm wondering what you have to do to achieve 55k exp with iron.


That is the maximum rate if you drop ores while you spin to mine next rock. Right now this is just a rough list but I can find a video that shows the basic method if you like. I believe you need at least a 1800+ populated world to achieve max rates. Personally I was able to get 52k p/h with human error/lag etc.

_________________
Image
Image
Image


Top
 Profile  
 
 Post subject: Re: OSRS Level 3 Skill Guide
PostPosted: Tue Mar 11, 2014 4:16 am 
Offline
Clan Chat Moderator
Clan Chat Moderator

Joined: Fri May 11, 2012 10:40 am
Posts: 175
Words: 3726
Location: Uk
Runescape Name: domdizzle
Level 3 Dom
Runescape Status: P2P
Forum Status: Member of Peacefull.
World: 114
This shows the basic method for mining iron though even the vid isn't perfect. Apparently I somehow rounded up my exp rate so I will adjust it to 54k.

Mining iron:
https://www.youtube.com/watch?v=oa9iVgH8XWs

P.s. If you use Ardougne mining spot the method is the exact same.

In this video you can see the method for mining granite. Again my exp rate was off this time below by apparently 5k-10k (hard for me to test max rate without being 99 mining). I have heard 65k confirmed more than 70k so I will update to 65k for now. If I see a reason to change in the future I will.

Mining granite/sandstone:
https://www.youtube.com/watch?v=OG_T-PZ4iiw

Update: I am currently working on writing a detailed guide using what I consider the most efficient methods. I will also list other methods that people may be interested in that are cheaper/make profit or alternative the majority tend to use. Obviously I will focus on the more efficient first but feel free to leave any exp rates for methods you have tested.

_________________
Image
Image
Image


Top
 Profile  
 
 Post subject: Re: OSRS Level 3 Skill Guide
PostPosted: Tue Mar 18, 2014 6:54 am 
Offline
Clan Chat Moderator
Clan Chat Moderator

Joined: Fri May 11, 2012 10:40 am
Posts: 175
Words: 3726
Location: Uk
Runescape Name: domdizzle
Level 3 Dom
Runescape Status: P2P
Forum Status: Member of Peacefull.
World: 114
Update: 18/03/2014

Working on some spreadsheets. Decided to post what I have so far just to get some feedback. Any other methods you think should be added just let me know. Hopefully will have time this week to improve the guide a lot more. Once I get the spreadsheets up to scratch and figured out how to auto update (currently have to manually update) I will put more detail into the methods listed for 1-99.



Update #2: Finished writing a spreadsheet to work out cost of maxing all skills. Ones currently not included are Thieving/Woodcutting/Mining/Agility/Farming as I am not 100% sure yet on those costs but I will add them in when I can.

Maxing costs

_________________
Image
Image
Image


Top
 Profile  
 
 Post subject: Re: OSRS Level 3 Skill Guide
PostPosted: Thu Mar 20, 2014 5:08 am 
Offline
Global Moderator
Global Moderator
User avatar

Joined: Wed May 30, 2007 1:56 am
Posts: 4184
Words: 122252
Location: SF Bay Area
Runescape Name: Pcfl
Runescape Status: P2P
Forum Status: Willing to help users.
World: 33
IRC Nick: Makin_Pyro
Hey Dom, here's a trick for importing Zybez Exchange data into Google Docs.

Type this formula into a cell in your spreadsheet.
=substitute(substitute(index(Importhtml("http://forums.zybez.net/runescape-2007-prices/2415-magic-seed","table",1),1,2)," GP",""),",","")

The formula is made up of the functions: IMPORTHTML, INDEX, and SUBSTITUTE.

=IMPORTHTML(url , data structure type - in this case, "table" , starting point)
This goes to the page, http://forums.zybez.net/runescape-2007- ... magic-seed, and returns the data table given on the site. Magic seeds, in this case.

=INDEX(reference , row , column)
This returns the value of the row and column of the table passed into reference. The table is the one from our IMPORTHTML function, and the value we're looking for "average sell offer" is in row 1, column 2. If you want to retrieve the "average buy offer", look in row 2 instead. I currently don't know of a way to get it to read the "recent trade price", but that's just an average of the average buy and sell offers.

=SUBSTITUTE(reference , replace this value , with this value instead)
We have to use this function, because only using the first two will return "134,300 GP", which is a string of numbers and letters. We can't do math with that, so we have to remove the comma, space, and letters 'GP', which is where SUBSTITUTE comes in. I nested two functions together to remove both the comma and the ' GP', with the inner substitute function as the reference for the outer. Now it will return "134300", which is a number we can now work with.


So here's a general formula for average buy offer:
Code:
=substitute(substitute(index(Importhtml("<insert url here>","table",1),2,2)," GP",""),",","")

And for average sell offer:
Code:
=substitute(substitute(index(Importhtml("<insert url here>","table",1),1,2)," GP",""),",","")


If you really wanted to get the average trade price, you can add together the average sell offer and average buy offer and divide by two. Note that you have to change the url in two places then.
Code:
=(substitute(substitute(index(Importhtml("<insert url here>","table",1),2,2)," GP",""),",","")+substitute(substitute(index(Importhtml("<insert url here again>","table",1),1,2)," GP",""),",",""))/2

But for the sake of your spreadsheet, I think you're better off just using average sell vs. average buy depending on whether the user is selling or buying.

_________________
Currently playing Old School Runescape on Pcfl ~ W333!
Image
Made by Toahst
Spoiler for Other:

Image
Made by Toahst
Image
Made by Love The Pie

Image
Made by Eww A Lvl 3

Image
Made by Lulla - R.I.P., buddy

Image
Made by me

Fishing Animation
Image :evil:
Image
Made by Robb

99 Fletching - May 8, 2007
99 Firemaking - Sep 15, 2007
99 Cooking - Feb 23, 2008
Global Moderator - March 21, 2008
99 Woodcutting - May 04, 2008
Combat Gained - June 18, 2008
99 Thieving - Oct 12, 2008
100m Total XP - Jan 24, 2009
Player Moderator - Oct 15, 2009
99 Farming - Dec 9, 2009
99 Fishing - March 9, 2010
99 Agility - April 27, 2010
200m Total XP - June 13, 2010
99 Ranged - Jan 5, 2011
Retired - Feb 20, 2012

Started Old School Runescape - Feb 22, 2013
Old School Quest Cape - Jan 23, 2014
99 Firemaking - July 12, 2014


Image
FORMER Image


Top
 Profile  
 
 Post subject: Re: OSRS Level 3 Skill Guide
PostPosted: Fri Mar 21, 2014 3:37 am 
Offline
Clan Chat Moderator
Clan Chat Moderator

Joined: Fri May 11, 2012 10:40 am
Posts: 175
Words: 3726
Location: Uk
Runescape Name: domdizzle
Level 3 Dom
Runescape Status: P2P
Forum Status: Member of Peacefull.
World: 114
Thanks so much for the help Austin! Spreadsheets have been vastly improved. Once I am done with the "Efficiency table" I will try and make a custom table where you can choose what methods you use to max and it works out cost/time for you. I am also going to work on writing out an explanation on all these methods and making the guide more visually appealing. Expect these updates over the next few weeks.

_________________
Image
Image
Image


Top
 Profile  
 
 Post subject: Re: OSRS Level 3 Skill Guide
PostPosted: Sun Mar 23, 2014 9:27 pm 
Offline
Clan Chat Moderator
Clan Chat Moderator

Joined: Fri May 11, 2012 10:40 am
Posts: 175
Words: 3726
Location: Uk
Runescape Name: domdizzle
Level 3 Dom
Runescape Status: P2P
Forum Status: Member of Peacefull.
World: 114
Update: Tweaked a few methods/exp rates in Efficient Maxing spreadsheet. Added in the useful quest exp rewards.

Currently it assumes your money making method is rc (most efficient I know of). Since this a guide to max I am factoring in that you don't value any gp you don't need for maxing so the spreadsheet will update the amount of exp you do with lava/nats as the zyb prices update. Haven't been able to make it even out exactly yet but I will eventually!

_________________
Image
Image
Image


Top
 Profile  
 
 Post subject: Re: OSRS Level 3 Skill Guide
PostPosted: Mon Mar 24, 2014 7:59 pm 
Offline
Clan Chat Moderator
Clan Chat Moderator

Joined: Fri May 11, 2012 10:40 am
Posts: 175
Words: 3726
Location: Uk
Runescape Name: domdizzle
Level 3 Dom
Runescape Status: P2P
Forum Status: Member of Peacefull.
World: 114
Update: Did some more changes to the Efficient Maxing spreadsheet. It now evens out so you should end up breaking even using all the methods shown.

I also made an extra spreadsheet which will show the basic layout of my written guide. This shows everything to do starting from coming off the tutorial island until you are maxed. I had to guess at what times you would reach certain levels such as Slayer/Farming but i assumed you got a lamp every 4 hours at least and played 4 hours/day.

Will be working on getting it in written format but I have things coming up IRL which may slow down my progress with the updates.

Step by Step Maxing List

_________________
Image
Image
Image


Top
 Profile  
 
 Post subject: Re: OSRS Level 3 Skill Guide
PostPosted: Wed Mar 26, 2014 7:47 pm 
Offline
Global Moderator
Global Moderator

Joined: Fri Dec 27, 2013 11:55 pm
Posts: 340
Words: 5573
This guide is really really helpful, I have been using it a lot lately!

One question I have is if all the cooking information is calculated with or without using gauntlets?

_________________
Image

Spoiler for Previous Signatures:

Image


Top
 Profile  
 
 Post subject: Re: OSRS Level 3 Skill Guide
PostPosted: Thu Mar 27, 2014 2:04 am 
Offline
Clan Chat Moderator
Clan Chat Moderator

Joined: Fri May 11, 2012 10:40 am
Posts: 175
Words: 3726
Location: Uk
Runescape Name: domdizzle
Level 3 Dom
Runescape Status: P2P
Forum Status: Member of Peacefull.
World: 114
Thanks joey! It's without gauntlets. So it takes into consideration burning everything except lobsters in the maxing guide (only one you cook past non burning level) and just considers shark on the other spreadsheet. I need to get some more data on actual burn rates so they may be tweaked slightly in the future.

I also still need to add in costs for mining (Waterskins at granite) and thieving (food/antipoisons/energy pots/duel rings). Holding off mining to see what update is like and will add in thieving when i test it (currently just focusing on exp rates at pp).

Also been working on a money making spreadsheet which is looking really interesting right now. If anyone knows any methods feel free to post them as I am only human and i'm sure when it's done there will be some that i've missed out.

_________________
Image
Image
Image


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 35 posts ]  Go to page 1, 2, 3  Next

All times are UTC [ DST ]


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron




Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
Style supported by CodeMiles Team.