Results 1 to 5 of 5

Thread: My spreadsheet about herblor

  1. #1
    Join Date
    Apr 2012
    Posts
    365
    Mentioned
    0 Post(s)
    Quoted
    30 Post(s)

    Default My spreadsheet about herblor

    A while ago, somebody had posted a guide about how to use the Google spreadsheet to pull the data from official grand exchange website and use them for some calculation. Therefor, I have make the a herblor calculator that similiar with the one on wikia.
    ---------------------------link remove-----------------------------
    1. Why i make another calculator there already exist one on the wikia?
    because how wikia evaluate the cost of making potion is not right.
    First, it use the price of potion (3) instead of potion (4) in it's calculation. Since the Bob Barter at the Grand Exchange can decant the potion in the noted form, I believe most potion are traded in the form of 4 doze per vial, so using the price of potion (4) is more accurate.
    Second, it assume the value of untradeable stuff to be zero, which is terribly wrong. For some example, Nightshade is an untradeable ingredient that are using in weapon poison++, and collecting Nightshade is time costing. So in my calculator, I assume it value is 8000 gp.
    2. Why I didn't include the torstol?
    Because for the item that has value more than 10k, the website will not provide an accurate price, which will make the evaluation about cleaning torstol not that useful.
    Instruction
    The first page of the spreadsheet is the cost evaluation about potion making, and the second page is profit about herb cleaning. With some basic calculation about the gp/xp, I also place the result of xp/hr and gp/hr, so you can have more information about whether potion mkaing or herb cleaning is more suitable for you.
    The third page is the price of all the ingredient. If you are interested about the value I set for untradable stuff, see the bottom of this page.
    Last edited by freezeyp; 03-09-2013 at 04:23 PM. Reason: my spread sheet isn't as explicit as the one on xp waste

  2. #2
    Join Date
    Apr 2012
    Posts
    365
    Mentioned
    0 Post(s)
    Quoted
    30 Post(s)

    Default

    Going to update the sheet, since there are some new potion been release.
    After the reconstruction, I'll bump the thread again

  3. #3
    Join Date
    Jul 2011
    Location
    /home/litoris
    Posts
    2,226
    Mentioned
    0 Post(s)
    Quoted
    159 Post(s)

    Default

    There's a famous one from xp-waste.com or whatever the domain is, if you are doing this out of need you shouldn't really bother.
    Miner & Urn Crafter & 07 Chicken Killer
    SPS BlindWalk Tutorial

    Working on: Nothing

    teacher in every art, brought the fire that hath proved to mortals a means to mighty ends

  4. #4
    Join Date
    Apr 2012
    Posts
    365
    Mentioned
    0 Post(s)
    Quoted
    30 Post(s)

    Default

    Quote Originally Posted by litoris View Post
    There's a famous one from xp-waste.com or whatever the domain is, if you are doing this out of need you shouldn't really bother.
    Can I have the link please?

  5. #5
    Join Date
    Jul 2011
    Location
    /home/litoris
    Posts
    2,226
    Mentioned
    0 Post(s)
    Quoted
    159 Post(s)

    Default

    Miner & Urn Crafter & 07 Chicken Killer
    SPS BlindWalk Tutorial

    Working on: Nothing

    teacher in every art, brought the fire that hath proved to mortals a means to mighty ends

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •