Hey everyone!
I've just made this for myself to use while buying and levelling exalt fodder dragons and I've found it quite useful, so I thought I'd share it for everyone to use.
[br]
[center][size=6][b][url=https://docs.google.com/spreadsheets/d/13O7hFJczBNBmGCJXZ7A8jLZfg0wuT3bcCYev6fVp1Cg/edit?usp=sharing][font=cursive]Straightforward Exalt Profit Tracker[/font][/url][/b][/size]
[img]http://i.imgur.com/jNgs8Odl.png[/img]
[/center]
It's very simple. The leftmost column contains [size=4][b]Gross profit, net profit[/b] and[b] total expense[/b][/size] boxes. These don't need updating, and will simply track your totals for these figures:
[LIST]
[*]Gross is everything you've gotten back from exalting - what you should have in your account.
[*]Net shows you what you've earned, less expenses - the true profit value.
[*]Total Expenses tells you what you paid to get the exalt fodder.
[/LIST]
To the right are three main columns, Purchased, Payout and Profit. Again, pretty self explanatory:
[LIST]
[*]Purchased is what you paid for the dragon.
[*]Payout is the exalt payout figure.
[*]Profit subtracts the cost of the dragon from the payout.
[/LIST]
The next column I included for my own interest, and is the dragon's level. This doesn't factor into any equations.
The final column, in grey, is for ID number tracking. Occasionally I keep note of these for dragons I want to replace in the future with similar ones, dragons I kept for a long time or sometimes just for the hell of it.
I hope you find this useful! Let me know if there's any further wizardry that can be added, and happy profit pushing!
Hey everyone!
I've just made this for myself to use while buying and levelling exalt fodder dragons and I've found it quite useful, so I thought I'd share it for everyone to use.
It's very simple. The leftmost column contains
Gross profit, net profit and total expense boxes. These don't need updating, and will simply track your totals for these figures:
- Gross is everything you've gotten back from exalting - what you should have in your account.
- Net shows you what you've earned, less expenses - the true profit value.
- Total Expenses tells you what you paid to get the exalt fodder.
To the right are three main columns, Purchased, Payout and Profit. Again, pretty self explanatory:
- Purchased is what you paid for the dragon.
- Payout is the exalt payout figure.
- Profit subtracts the cost of the dragon from the payout.
The next column I included for my own interest, and is the dragon's level. This doesn't factor into any equations.
The final column, in grey, is for ID number tracking. Occasionally I keep note of these for dragons I want to replace in the future with similar ones, dragons I kept for a long time or sometimes just for the hell of it.
I hope you find this useful! Let me know if there's any further wizardry that can be added, and happy profit pushing!
If someone knows how to make the spreadsheet tell you what your return is on average for a certain level, that would certainly be interesting. But I have no idea where to start.
If someone knows how to make the spreadsheet tell you what your return is on average for a certain level, that would certainly be interesting. But I have no idea where to start.
Thanks! I've saved a copy for myself! :D
@
Ithika
Thanks for this! I was already doing something similar, but yours is shinier.
By the way, congratulations on your 1000th post.
@
Ithika
Thanks for this! I was already doing something similar, but yours is shinier.
By the way, congratulations on your 1000th post.
Thanks, this is really helpful :)
Thanks, this is really helpful :)
@
Ithika
There are two things that I know of that you may be looking for:
http://flightrising.com/main.php?board=gde&id=746775&p=mb - Exalting Treasure Payout Chart; this is basically the average payout at each level of exalting.
http://flightrising.com/main.php?board=gde&id=1172743&p=mb - this board has a link to a spreadsheet that calculates your personal average profit based on how long it takes you grind to a certain level.
Hope that helps/what you are looking for!
@
Ithika
Thank you, this is very useful. I'm not very spreadhseet-savvy so this is a great resource for me. (:
@
Ithika
Thank you, this is very useful. I'm not very spreadhseet-savvy so this is a great resource for me. (:
a star sign out of whack.
@Ithika Thanks so much for this. It's a nice little record to see real numbers when exalting for profit.
Because I'm lazy with figuring the profits, I made a formula to put in cell D3 that will calculate your profit for you for people who want to use it. ^^
[code]=ARRAYFORMULA(IF(C3:C,C3:C-B3:B,""))[/code]
I do have a question though, after row 12 the numbers entered stop formatting themselves with commas and cents. Is there a way to bring this back (and maybe remove the cents part since FR doesn't have that ^^; )
@
Ithika Thanks so much for this. It's a nice little record to see real numbers when exalting for profit.
Because I'm lazy with figuring the profits, I made a formula to put in cell D3 that will calculate your profit for you for people who want to use it. ^^
Code:
=ARRAYFORMULA(IF(C3:C,C3:C-B3:B,""))
I do have a question though, after row 12 the numbers entered stop formatting themselves with commas and cents. Is there a way to bring this back (and maybe remove the cents part since FR doesn't have that ^^; )
Wah I lost this thread and these pings! I'll reply to things tomorrow - hello 1am! Thank you for all your replies, though :)
Wah I lost this thread and these pings! I'll reply to things tomorrow - hello 1am! Thank you for all your replies, though :)