I was hoping that when you entered loot on the treasure tab and assigned it, that the Player's Loot and Group tabs would be automatically populated. This does not appear to be the case for either Excel 2011 or Excel 2010. Can someone confirm for me if this expected but not realized behavior is by design (thus a bug) or naivety on my part?
Thanks...
Player and Group Loot auto population
-
- Squire
- Posts: 3
- Joined: Thu Jun 02, 2011 6:46 pm
Re: Player and Group Loot auto population
There is no 'direct' link to what you enter on the Treasure! sheet, and the other sheets - for several reasons.chriswilliams wrote:I was hoping that when you entered loot on the treasure tab and assigned it, that the Player's Loot and Group tabs would be automatically populated. This does not appear to be the case for either Excel 2011 or Excel 2010. Can someone confirm for me if this expected but not realized behavior is by design (thus a bug) or naivety on my part?
Thanks...
For instance, the Treasure sheet is much 'bigger' than the other sheets. Another reasons is that and you can enter information that is NOT treasure (like Titles!!)... so any coding done would try to 'guess what the user wants to do in some cases - something that is quite complex to do!!
admin
-
- Squire
- Posts: 3
- Joined: Thu Jun 02, 2011 6:46 pm
Re: Player and Group Loot auto population
vlookup will do the trick. This greatly reduces the usefulness of this tool. Another way of doing this would be pivot tables, but because the sheet is locked, there's no modifications that can be done.
Re: Player and Group Loot auto population
What happens if you find this treasure:chriswilliams wrote:vlookup will do the trick. This greatly reduces the usefulness of this tool. Another way of doing this would be pivot tables, but because the sheet is locked, there's no modifications that can be done.
Potion of Fly
Then, a few games later, you find:
Potion of Fly
VLOOKUP() can't find the second occurrence, unfortunately - and it happens often that sessions will have identical loot.
admin
-
- Squire
- Posts: 3
- Joined: Thu Jun 02, 2011 6:46 pm
Re: Player and Group Loot auto population
Leveraging search and vlookup you can return a list of all treasure belonging to PCx including duplicates. I have to do it in writing sheets for tracking hardware in multiple regions for work. You can also run filter extracts to create list dependencies on names fields.
Re: Player and Group Loot auto population
You can use the Suggestion Box section to detail any improvements you can think of! (and solution to possible problems that could arise from such ideas!)chriswilliams wrote:Leveraging search and vlookup you can return a list of all treasure belonging to PCx including duplicates. I have to do it in writing sheets for tracking hardware in multiple regions for work. You can also run filter extracts to create list dependencies on names fields.
admin