Scroll Expenses Calculator | Guides

| SCROLL EXPENSES CALCULATOR |
link

Hey everyone! If you, like me, suffer from an incurable gene addiction then I have just the spreadsheet for you! It will help you keep track of how many specialty scrolls you need for your gene projects and how much it will cost you. There are only three things you should ever have to edit on the sheets:
Amounts - How many of each scroll you require.
Discount - Flight discount. Enter 0 for no discount, 0.07 for a half-discount, or 0.15 for a full discount.
Gem:Treasure Ratio - Please make sure you're entering the treasure price of a single gem as opposed to the entire ratio. For example, if the current ratio is 1:460 then you would only enter 460. It'll mess up if you enter the whole thing!

To get your own, all you have to do is copy the spreadsheet to your own Google drive and edit away. The "Overall Total" on the Gems page calculates the treasure total from both pages.
Tip: To help me keep track of which dragons I have considered in my calculations I like to add comments to each of the Amount boxes with their names. You can do this by clicking on a box and selecting Insert > Comment from the menu.

Please feel free to ping me if something needs edited or if you have any questions.

Chanilove

0

80

399

1078

February 03, 2015 09:03:52

| SCROLL EXPENSES CALCULATOR |
link

Hey everyone! If you, like me, suffer from an incurable gene addiction then I have just the spreadsheet for you! It will help you keep track of how many specialty scrolls you need for your gene projects and how much it will cost you. There are only three things you should ever have to edit on the sheets:
Amounts - How many of each scroll you require.
Discount - Flight discount. Enter 0 for no discount, 0.07 for a half-discount, or 0.15 for a full discount.
Gem:Treasure Ratio - Please make sure you're entering the treasure price of a single gem as opposed to the entire ratio. For example, if the current ratio is 1:460 then you would only enter 460. It'll mess up if you enter the whole thing!

To get your own, all you have to do is copy the spreadsheet to your own Google drive and edit away. The "Overall Total" on the Gems page calculates the treasure total from both pages.
Tip: To help me keep track of which dragons I have considered in my calculations I like to add comments to each of the Amount boxes with their names. You can do this by clicking on a box and selecting Insert > Comment from the menu.

Please feel free to ping me if something needs edited or if you have any questions.

Last edited on Oct 17, 2015 23:07:38 by Chanilove

This is really helpful! I've been doing all my calculating manually and this makes it so much easier to keep it all in one place.