TOS Community Forum

[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!

There is also another way to do this - which might even be a tad simpler!

A Wand that has been used has LESS then the starting 50 charges: Since a 'full' wand would be a quantity of 1 (for 50 charges), a wand with 12 charges left would be a quantity of 12 ÷ 50.
So in the Quantity column, enter this formula: =12/50 and voila!