Players Loot value wrong when Qty > 1

Need Help with the Loot Divider?
Ask in this section!
Post Reply
neofax
Soldier
Soldier
Posts: 11
Joined: Wed Mar 17, 2010 1:26 pm

Players Loot value wrong when Qty > 1

Post by neofax »

If I place a Qty of 2 Potion of Cure Moderate Wounds on the Player's Loot page, the value shows 300 instead of 600. I know I can add a second Potion of Cure Moderate Wounds, but that defeats the purpose of having qty. Also, is there a way to fix when I move the items and now the locked formulas follow the move? i.e. I select blocks cells B14-16 and drag and drop them onto B11-13 I had to close w/o saving and re-do what I did.
User avatar
Duniagdra
Divine Rank 21
Divine Rank 21
Posts: 2266
Joined: Sat Dec 29, 2007 5:17 pm
Location: Newark, New Jersey, USA
Contact:

Re: Players Loot value wrong when Qty > 1

Post by Duniagdra »

When you moved the data, did you copy and pasts special>>formulas?
Image Marcus Tilsworth - Human Sorcerer
Image Agrous: Human Cleric
Image Ulyuk Bok - Elan Gestalt
Image Tryzscatzmel Ry - Gnome Alchemist
Image Image
Image
neofax
Soldier
Soldier
Posts: 11
Joined: Wed Mar 17, 2010 1:26 pm

Re: Players Loot value wrong when Qty > 1

Post by neofax »

No, I did not. Not a big deal, as I can re-accomplish by starting over. However, I was wondering if there was a way to reset the formulas.
User avatar
Duniagdra
Divine Rank 21
Divine Rank 21
Posts: 2266
Joined: Sat Dec 29, 2007 5:17 pm
Location: Newark, New Jersey, USA
Contact:

Re: Players Loot value wrong when Qty > 1

Post by Duniagdra »

Perhaps I misunderstood your question. If you're asking about formulas that you cannot edit, then no, there's no way for you to do anything with that. They are protected for a reason.

If I'm still off, then please explain or maybe someone else might see what I'm missing in your post.
Image Marcus Tilsworth - Human Sorcerer
Image Agrous: Human Cleric
Image Ulyuk Bok - Elan Gestalt
Image Tryzscatzmel Ry - Gnome Alchemist
Image Image
Image
User avatar
admin
-={ ARCHMAGE }=-
-={ ARCHMAGE }=-
Posts: 11402
Joined: Wed May 25, 2005 5:51 pm
Location: Golarion
Contact:

Re: Players Loot value wrong when Qty > 1

Post by admin »

neofax wrote:If I place a Qty of 2 Potion of Cure Moderate Wounds on the Player's Loot page, the value shows 300 instead of 600. I know I can add a second Potion of Cure Moderate Wounds, but that defeats the purpose of having qty.
Ok that's a good point.
I've modified the Loot Divider to 'insert' a formula that will take into account changes in Quantity (and not bug out if the quantity remains empty - it will assume a quantity of one in that case). This will be available in the next update - this automation can only work on Excel's VBA - thanks!!!

admin
Post Reply

Return to “Help Desk”