Ok, so I’ve used things like tpcalc.com and the calculator at GW2TP, and they are very useful for throwing in a sale price and receiving a projected profit that takes out the 15% taxes for you.
However, I’m looking for a way to set either a requested percentage or exact amount of profit, and have Excel spit out the required sell price to reach that goal.
For example: If I buy an item for 10 silver, and I want to make a profit of 1 silver when selling it, I want my spreadsheet to spit out 12silver 95copper for me, instead of me having to putz around with different numbers to get an exact amount. Preferably I’d like to enter in the exact amount that I want to profit over the base price, but it would be nice to enter 10% too.
I’ve got something so far, but it’s not calculating properly. It’s spitting out 12silver 65copper, which is only 75c profit (8%).
Any of you accounting deities willing to share some knowledge?
Where are my gem sales? I want gem sales! Nerf EVERYTHING!
