brainymidget Posted February 6, 2009 Share Posted February 6, 2009 All of these calculators will show the Gp per xp of various different skills. I extracted the GE prices with Google Docs so the prices are always up to date, although I can't embed HTML so this is just a picture which will not be up to date. The links will however be up to date. Fletching Click this link for the always up to date graph. http://spreadsheets.google.com/pub?key=psI...O_sOvs-02vmJ3Rw And picture(Not kept up to date) NOTE: All numbers in this are assuming buying and selling at mid, which you can not do for somethings. Some things may have to be used as junk, and some things may be unbuyable. Firemaking Link for up to date graph http://spreadsheets.google.com/pub?key=psI...O_sN-wixazo59fQ Picture(Not kept up to date) NOTE: All numbers are without Fire ring or Flame Gloves. Prayer Link for up to date graph http://spreadsheets.google.com/pub?key=psI...O_sN0N61v4mYODw Picture(Not kept up to date) Cooking Link for up to date graph http://spreadsheets.google.com/pub?key=psI...O_sPDv2E9XgqGGA Picture(Not kept up to date) NOTE: All numbers are assuming nothing burned. Herblore Link for up to date graph <!-- m -->http://spreadsheets.google.com/pub?key= ... 2v_zp4uLLg<!-- m --> Herb farming http://spreadsheets.google.com/pub?key= ... DZiC5cf_cg Link to comment Share on other sites More sharing options...
Amaranth_GTO Posted February 6, 2009 Share Posted February 6, 2009 Thanks for this, very helpful Link to comment Share on other sites More sharing options...
brainymidget Posted February 6, 2009 Author Share Posted February 6, 2009 Glad to help. I plan to make a lot more. The last 3 of those only took me about 30 minutes. If anyone has any skills they would like me to make, just request it and that can be my next. Link to comment Share on other sites More sharing options...
Kepihan Posted February 6, 2009 Share Posted February 6, 2009 Epic! :o Just wondering, so I can make one for personal use (Smithing) is the Exp per GP just exp/current cost? Link to comment Share on other sites More sharing options...
brainymidget Posted February 6, 2009 Author Share Posted February 6, 2009 Hehe, smithing was actually the one I planned to make next so you can wait til later today and I'll have that one out. And I do Gp / Xp which is either the profit per, loss per, or cost of the product, divided by the experience. Link to comment Share on other sites More sharing options...
Amaranth_GTO Posted February 6, 2009 Share Posted February 6, 2009 Any chance of a herblore xp/hour calculator? :P Link to comment Share on other sites More sharing options...
Abc1230 Posted February 6, 2009 Share Posted February 6, 2009 Could you make one for crafting? YouTube Link to comment Share on other sites More sharing options...
brainymidget Posted February 6, 2009 Author Share Posted February 6, 2009 My current priority list is Smithing, then crafting, then herblore. And I posted this on another site so I'll post this here as well. An explanation on how I make the calculators, the majority of the explanation is in extracting prices. Most of making these is simple, although getting the GE prices can be complicated if you don't know how to do it. Here is a good explanation of it. First off, I start with this formula, to extract the data from the GE database. =ImportHtml("http://itemdb-rs.runescape.com/results.ws?query=Willow Logs", "table", 2) ImportHtml takes the HTML off of the specified site. For things such as extracting data off the hi-scores, the lite hi-scores where they are extracted from are all text, there is no Html involved so you can just use ImportData but for this you have to use ImportHtml. So the link tells you where to take the data from. The second part can either say "table" or "list" to tell it what to look for. If you do list, it's just going to give you the lists that are on the top, like Home, Play now, Account, etc... and the drop down lists from them. I tell it to find tables which is what the prices are in. The third thing in this formula is the 2. This tells it to find the second table. I just tried different numbers there until I found the thing that contained the prices. When I entered this whole code, I came out with something that looked like this. As you can see, that's more information then we need, so we have to narrow it down. You see here that the first column is empty, the second column is the item name, and the third column is prices. Now prices is what we care about. The price of the thing that we want, Willow logs, is in Row 2, column 3. So now we will use "Index" to tell it to only take the information from Row 2, Column 3. Now the code will look like this: =Index(ImportHtml("http://itemdb-rs.runescape.com/results.ws?query=Willow Logs", "table", 2),2,3) So what you did was added "Index(" before Importhtml, and ",2,3)" after it. Now the results will just be "18" the price of willow logs. Sometimes, the first option when you look up an item will not be the item you are looking for, in which case you will have to change the row. If it is the second item, just change it to ",3,3" or "4,3" for the third item, and I think you get it by now. So now you have looked up the prices. Now there is one thing you can do to make it even easier. With my calculators, I don't want to manually enter every item, so I just have the code take the item that is put in after "query=" from within my spreadsheet. To do this, I use "Concat" So now I am going to change my code to =Index(ImportHtml(Concat("http://itemdb-rs.runescape.com/results.ws?query=",A2), "table", 2),2,3). As you can see I added "(Concat" after Importhtml and ",A2" after query=" What this does is tells it to find what to put in that position is the Informaton found in A2. If the price you are looking up is in A3, then just change to A3. So there, now you can successfully look up prices from the GE Database. As for the rest of the calculator. The loss per is just "=E2-F2" or whatever the cells may be. And the Gp / Xp is usually just the profit divided by the experience, and rounded. To do this I use "=ROUND(G2/C2,3)" You can change the G2 and C2 to whatever the appropriate cells are, and the 3 tells it to round to 3 places, you can change this however you like. Link to comment Share on other sites More sharing options...
brainymidget Posted February 16, 2009 Author Share Posted February 16, 2009 Herblore added. Link to comment Share on other sites More sharing options...
thatoweler Posted February 16, 2009 Share Posted February 16, 2009 You are awesome m8! Link to comment Share on other sites More sharing options...
999134 Posted February 16, 2009 Share Posted February 16, 2009 if you kept this updated then this would have a permanent bookmark :D Check it out, huge amount of effort has gone into this massive mod![hide=old sig][/hide] Link to comment Share on other sites More sharing options...
AndyPandy Posted February 16, 2009 Share Posted February 16, 2009 Icanhascraftingtablepl0x? So don't let anyone tell you you're not worth the earth, These streets are your streets, this turf is your turf, Don't let anyone tell you that you've got to give in, Cos you can make a difference, you can change everything, Just let your dreams be your pilot, your imagination your fuel, Tear up the book and write your own damn rules, Use all that heart, hope and soul that you've got, And the love and the rage that you feel in your gut, And realise that the other world that you're always looking for, Lies right here in front of us, just outside this door, And it's up to you to go out there and paint the canvas, After all, you were put on the earth to do this, So shine your light so bright that all can see, Take pride in being whoever the [bleep] you want to be. Link to comment Share on other sites More sharing options...
compfreak847 Posted February 17, 2009 Share Posted February 17, 2009 Throw in time and run XP comparison calcs :thumbsup: Drops: 1x Draconic Visage, 56x Abyssal Whip, 5x Demon Head, D Drops: 37, Barrows Drops: 43, DK Drops: 29GWD drops: 14,000x Bars, 1x Armadyl Hilt, 2x Armadyl Skirt, 4x Sara Sword, 1x Saradomin Hilt, 8x Bandos Hilt, 8x Bandos Platebody, 9x Bandos Tassets, 4x Bandos Boots, 43x Godsword Shard, 82x Dragon BootsDry streak records: Saradomin 412 kills Bandos 988 kills Spirit Mages 633 kills - Slayer Sucks Link to comment Share on other sites More sharing options...
SanNo1 Posted February 17, 2009 Share Posted February 17, 2009 Throw in time and run XP comparison calcs :thumbsup: exactly what I was going to suggest, it would be awesome to see the outcomes There are three sides to every story: There's one side, there's the other, and there's the truth. Link to comment Share on other sites More sharing options...
brainymidget Posted October 6, 2009 Author Share Posted October 6, 2009 Just added herb farming one as I did in old forums but had to carry it over.So ya, and apparently Runescape Wikia made mine outdated so that makes me sad :(But oh well, these can just be examples for my Google Docs GE extracting guide so ya :) EDIT: Wow, just looked at Runescape Wikias. Their calculators are really nice. I'm impressed.I'm not even gonna be using my own calculator anymore, I'm going there :P Link to comment Share on other sites More sharing options...
nerdboyxxx Posted October 6, 2009 Share Posted October 6, 2009 Yeah rs wiki have some awesome calculators. Just wondering, is the exp correct on your fletching calculators? They conflict with the ones on tip.it's fletching guide. Just wondering if tip.it is out-of-date or whatever :P cause I'm making a calculator at the moment for everything fletching wise. Link to comment Share on other sites More sharing options...
brainymidget Posted October 6, 2009 Author Share Posted October 6, 2009 What ones in particular conflict? Because I believe that in Tipits fletching guide, they include the exp for the entire process, while mine is just the final step, such as adding the feathers to the unfinished bolts. Link to comment Share on other sites More sharing options...
nerdboyxxx Posted October 6, 2009 Share Posted October 6, 2009 Ah I see, thanks for clearing that up :) Link to comment Share on other sites More sharing options...
Amonitas Posted November 6, 2009 Share Posted November 6, 2009 This is awesome and very helpful! Thank you. Quest cape since 11th July 99 Farming 4th February 99 Cooking 31st August 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