Jump to content

Brainymidget's Gp / Xp Calculators


brainymidget

Recommended Posts

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)

 

fletchingcalculatorha8.png

 

 

 

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)

 

firemakingcalculatorts3.png

 

 

 

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)

 

prayercalculatoruk4.png

 

 

 

Cooking

 

 

 

Link for up to date graph

 

http://spreadsheets.google.com/pub?key=psI...O_sPDv2E9XgqGGA

 

 

 

Picture(Not kept up to date)

 

cookingcalculatordq5.png

 

 

 

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

Brainymidget.png

multimultiza9.gif

Link to comment
Share on other sites

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.

Brainymidget.png

multimultiza9.gif

Link to comment
Share on other sites

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.

 

importhtmlfq5.png

 

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.

Brainymidget.png

multimultiza9.gif

Link to comment
Share on other sites

  • 2 weeks later...

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

Throw in time and run XP comparison calcs :thumbsup:

DeviledEgg24.png

Drops: 1x Draconic Visage, 56x Abyssal Whip, 5x Demon Head, D Drops: 37, Barrows Drops: 43, DK Drops: 29

GWD 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 Boots

Dry streak records: Saradomin 412 kills Bandos 988 kills Spirit Mages 633 kills - Slayer Sucks

Link to comment
Share on other sites

Throw in time and run XP comparison calcs :thumbsup:

 

 

 

exactly what I was going to suggest, it would be awesome to see the outcomes <3:

nekusig2fcopy.jpg

 

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

  • 7 months later...

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

Brainymidget.png

multimultiza9.gif

Link to comment
Share on other sites

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.

disturbeda.png

Link to comment
Share on other sites

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.

Brainymidget.png

multimultiza9.gif

Link to comment
Share on other sites

  • 1 month later...

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.