[TIP] How to sell a Wand with less then 50 Charges!

Need Help with the Loot Divider?
Ask in this section!
Post Reply
User avatar
admin
-={ ARCHMAGE }=-
-={ ARCHMAGE }=-
Posts: 11402
Joined: Wed May 25, 2005 5:51 pm
Location: Golarion
Contact:

[TIP] How to sell a Wand with less then 50 Charges!

Post by admin »

[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:
SellingAWand.png
SellingAWand.png (10.59 KiB) Viewed 6273 times
If one of the Players is keeping the Wand, you can easily note the remaining charges like this:
AssignAWand.png
AssignAWand.png (8.94 KiB) Viewed 6273 times
Hope this helps!
User avatar
admin
-={ ARCHMAGE }=-
-={ ARCHMAGE }=-
Posts: 11402
Joined: Wed May 25, 2005 5:51 pm
Location: Golarion
Contact:

Re: [TIP] How to sell a Wand with less then 50 Charges!

Post by admin »

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!
wand.png
wand.png (18.22 KiB) Viewed 6221 times
Post Reply

Return to “Help Desk”