Mystical Tome Price Calculator

WarrenWolfy - Sanctuary
WarrenWolfy - Sanctuary Posts: 1,686 Arc User
edited September 2011 in Dungeons & Tactics
Way back before Anniversary Packs came out I made a spreadsheet to help me calculate Tome prices. My plan was to one day make "The Voidlands", but then Anniversary Packs came out and "Love: Up and Down" became the de-facto Tome that everybody drools over.

Anyway, now that Level 6 Tomes can be manufactured I decided to dust off the old spreadsheet, add in the new Tomes, convert it to use Tokens rather than Gold in order to calculate Page prices (since Tokens are much cheaper), and make it more user-friendly.

Here's the spreadsheet: http://public.sheet.zoho.com/public/warren.forrest/perfect-world-tomes

To use it, put the quantities of each kind of Tome you wish to manufacture in the blue "# Wanted" column. Then put the current prices for Fragments and Tokens in the blue boxes at the bottom of the spreadsheet.

The spreadsheet will then calculate the total price. In addition, the "# Required" column will then give you a step-by-step guide to exactly how many of each kind of Tome you will need to manufacture in order to get the Tomes that you want.

Note: Only edit BLUE boxes! Don't change anything else!

A handy example:

I want to manufacture the level 5 Tome: "The Voidlands"

1) Put a "1" in "# Wanted" column beside "The Voidlands"
2) Put "10000" in "Fragment Price"
3) Put "11500" in "Token Price"

Total Cost: 65,550,000

The spreadsheet tells me I'll need the following Level 1 Tomes to get started:

8 Underestimated Resolve
11 Tome of Fecundity
14 Retribution's Flame
8 Tome of River Spirits
7 Flanker's Tome
8 Tome of Hyperbolic Boasts
11 Tome of Grace
1 A Flowerless Plant
1 Eternity's Moon

Once I'm done making them, I can then follow the spreadsheet's guide for what Level 2 Tomes I'll need, then the Level 3s, then the Level 4s, and finally I can make my "The Voidlands".

- EDIT -

Oops, the initial post linked to an older buggy version. I've replaced it with the correct version, but I'd appreciate if others could double-check my work. If there are any errors, please let me know!
[SIGPIC][/SIGPIC]
PWI Merchanting Guides: warrenwolfy.wordpress.com
Post edited by WarrenWolfy - Sanctuary on

Comments

  • AlbireoTwo - Lost City
    AlbireoTwo - Lost City Posts: 2,056 Arc User
    edited April 2010
    Seems pretty useful. I'll try it out.
    [SIGPIC][/SIGPIC]

    Thank you Forsakenx for the picture. b:thanks
  • MagicHamsta - Lost City
    MagicHamsta - Lost City Posts: 10,466 Arc User
    edited April 2010
    not bad
    ^_^
    darthpanda16: Firefox crashed on me. Aryannamage: I don't think I am a GM that would be new.
    Hawk:Do this. closing thread
    frankieraye: I'll see if we can replace the woman with a stick figure and the tiger fangs with marshmallows.//Issues like these need to get escalated quickly to minimize the damage.
    Kantorek: Yeah.. you should try it. It's awesome.
    Sihndra: Nope- not currently possible under any circumstances. Sorry.
    LokisDottir: I mean...not haunting the forums, nope nope..
    Konariraiden: You don't know what you are up against. You will lose.
    Waiting for...Hamster Packs!
    58% chance to get tokens
    41% chance to get an all class pet hamster....but they has already been freed by the magic hamster.
    1% chance to get ban hamstered with the message "Hamsters United!"
    [SIGPIC][/SIGPIC]
  • Michael_Dark - Lost City
    Michael_Dark - Lost City Posts: 9,091 Arc User
    edited April 2010
    That's really nice, except for the fact that the tome I want is just too expensive to make. Could make nirvana axes for that price QQ.
    I post in forums. This one and others. That's why I post.
  • Asterelle - Sanctuary_1381265973
    Asterelle - Sanctuary_1381265973 Posts: 7,881 Arc User
    edited April 2010
    Not to take away from Warrens uber spread sheet (very nice) but an old guildmate of mine made something similar with pretty graphics (only up to lvl 5 tome).

    http://calcs.ucoz.com/tomes.html

    He also did apothecary stuff (missing detection potion)

    http://calcs.ucoz.com/apoth/elixirs.html
    [SIGPIC][/SIGPIC]
    Refining Simulator - aster.ohmydays.net/pw/refiningsimulator.html (don't use IE)
    Genie Calculator - aster.ohmydays.net/pw/geniecalculator.html - (don't use IE)
    Socket Calculator - aster.ohmydays.net/pw/socketcalculator.html
  • anwynd
    anwynd Posts: 0 Arc User
    edited April 2010
    Asterelle - Sanctuary wrote: »
    Not to take away from Warrens uber spread sheet (very nice) but an old guildmate of mine made something similar with pretty graphics (only up to lvl 5 tome).

    http://calcs.ucoz.com/tomes.html

    He also did apothecary stuff (missing detection potion)

    http://calcs.ucoz.com/apoth/elixirs.html

    those will be rlly useful thnks for posting themb:victory
    Collector of pet eggs, armor, weapons, fashion, and mountsb:chuckle
  • Ermengarde - Sanctuary
    Ermengarde - Sanctuary Posts: 6 Arc User
    edited April 2010
    I like this--thanks for putting this together!

    Also, am I the only one enchanted by the poetic tome titles? They're so classically Chinese. I want to read them, especially "A Bewitching Proposal."
  • Hunter_PT - Heavens Tear
    Hunter_PT - Heavens Tear Posts: 1,222 Arc User
    edited April 2010
    Awesome work, thank you b:thanks.

    However, i now know that making the 'Book of Fragrances' would cost me 230,850,000 so looks like i will be getting something else b:chuckle.
    Executor Of Reunited ~ Level 3 ~ Level 85+ ~ No Drama, No Pressure Faction.

    Hunter_PT - Cleric 9X, (Active/Main)
    PoisonedTip - Veno 7x (Retired)
    Skeln - Barbarian 4X (Rarely-Active)
    Hunter_The - BM 1X (Rarely-Active)
  • WarrenWolfy - Sanctuary
    WarrenWolfy - Sanctuary Posts: 1,686 Arc User
    edited April 2010
    Hunter_PT - Heavens Tear wrote: »
    Awesome work, thank you b:thanks.

    However, i now know that making the 'Book of Fragrances' would cost me 230,850,000 so looks like i will be getting something else b:chuckle.
    "Pan Gu, Creator" is the cheapest Lvl. 6 Tome. It's the light version of "Love:Up and Down", and it's practically a steal at 208,050,000! b:chuckle

    But seriously, yeah, I can't imagine very many people making Lvl. 6 Tomes at current prices.
    [SIGPIC][/SIGPIC]
    PWI Merchanting Guides: warrenwolfy.wordpress.com
  • LifeHunting - Heavens Tear
    LifeHunting - Heavens Tear Posts: 2,023 Arc User
    edited April 2010
    The price i got for what i wanted.....

    I could get me all my TT80 Gold mats and be happy as heck with all the leftover cash Q.Q
  • WarrenWolfy - Sanctuary
    WarrenWolfy - Sanctuary Posts: 1,686 Arc User
    edited April 2010
    *snickers*

    I find it funny this got moved into "Beginner's Guide". I can't think of any beginners who can afford even Lvl. 1 tomes. b:chuckle

    Perhaps I should have posted it in "The Crafting Nook" to begin with...
    [SIGPIC][/SIGPIC]
    PWI Merchanting Guides: warrenwolfy.wordpress.com
  • sakit
    sakit Posts: 6 Arc User
    edited September 2011
    Very Nice spread sheet went super well thanks for your work on this

Categories