[TIP] How to sell a Wand with less then 50 Charges!
Posted: Mon Mar 22, 2010 12:33 pm
[TIP] How to sell a Wand with less then 50 Charges!
Most of the Wands you will find are not fully charged up to their 50 charges. Yet, the wands listed in the Loot Divider are priced at their 'full charge' value. So how do you sell a wand that does not have all of its charges left?
Easy: Adjust the sell rate to reflect the value of the remaining charges!!
Let's sell a Wand of Bear’s Endurance with 12 charges left. It's value would be equal to 12/50 of the full value (1080gp). So for this item, you would enter a custom rate with this formula:
=in_Rate*(12/50)
which would sell this wand for half the 1080gp value! (half because we are selling at a %50 rate)
in_Rate is a named cell that represents the standard rate you have defined at the top (usually that 50%). Of course, if you sell wands at another rate, you can replace it with another decimal - like 0.75 for a 75% rate.
Here is the results using the formulas above: If one of the Players is keeping the Wand, you can easily note the remaining charges like this: Hope this helps!
Most of the Wands you will find are not fully charged up to their 50 charges. Yet, the wands listed in the Loot Divider are priced at their 'full charge' value. So how do you sell a wand that does not have all of its charges left?
Easy: Adjust the sell rate to reflect the value of the remaining charges!!
Let's sell a Wand of Bear’s Endurance with 12 charges left. It's value would be equal to 12/50 of the full value (1080gp). So for this item, you would enter a custom rate with this formula:
=in_Rate*(12/50)
which would sell this wand for half the 1080gp value! (half because we are selling at a %50 rate)
in_Rate is a named cell that represents the standard rate you have defined at the top (usually that 50%). Of course, if you sell wands at another rate, you can replace it with another decimal - like 0.75 for a 75% rate.
Here is the results using the formulas above: If one of the Players is keeping the Wand, you can easily note the remaining charges like this: Hope this helps!