Mystical Tome Price Calculator
WarrenWolfy - Sanctuary
Posts: 1,686 Arc User
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!
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
PWI Merchanting Guides: warrenwolfy.wordpress.com
Post edited by WarrenWolfy - Sanctuary on
0
Comments
-
Seems pretty useful. I'll try it out.[SIGPIC][/SIGPIC]
Thank you Forsakenx for the picture. b:thanks0 -
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]0 -
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.0
-
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.html0 -
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:victoryCollector of pet eggs, armor, weapons, fashion, and mountsb:chuckle0 -
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."0 -
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)0 -
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.
But seriously, yeah, I can't imagine very many people making Lvl. 6 Tomes at current prices.[SIGPIC][/SIGPIC]
PWI Merchanting Guides: warrenwolfy.wordpress.com0 -
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.Q0 -
*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.com0 -
Very Nice spread sheet went super well thanks for your work on this0
Categories
- All Categories
- 181.9K PWI
- 699 Official Announcements
- 2 Rules of Conduct
- 264 Cabbage Patch Notes
- 61K General Discussion
- 1.5K Quality Corner
- 11.1K Suggestion Box
- 77.4K Archosaur City
- 3.5K Cash Shop Huddle
- 14.3K Server Symposium
- 18.1K Dungeons & Tactics
- 2K The Crafting Nook
- 4.9K Guild Banter
- 6.6K The Trading Post
- 28K Class Discussion
- 1.9K Arigora Colosseum
- 78 TW & Cross Server Battles
- 337 Nation Wars
- 8.2K Off-Topic Discussion
- 3.7K The Fanatics Forum
- 207 Screenshots and Videos
- 22.8K Support Desk