Wow, incredible work. I would love to use it.
Is it possible to make more guildbank characters than one?
Hey @bobbiota - yeah, the Guild Info tab is actually pretty FFA, so you can copy/paste + add/remove as you want to; it was hard for me to configure a single solution for all guilds, so I have tried to leave it vaguely suggestive, but still very much up to you guys to make into something that truly reflects your guild configuration.
Naturally, if anyone runs into issues with this, then I am happy to provide whatever help i can!
- Xcellers
|Paladin|Firemaw EU-PVP|
|Paladin|Firemaw EU-PVP|
Mk. Ultra - Comprehensive Guild Management Spreadsheet
A comprehensive tool for guild managers maintaining rosters & loot distribution in LC based guilds
Vault of the Silverhands, A Gear Primer for Holy Paladins
A progressive and customisable item, enchant and buff overview for Holy Paladins
A comprehensive tool for guild managers maintaining rosters & loot distribution in LC based guilds
Vault of the Silverhands, A Gear Primer for Holy Paladins
A progressive and customisable item, enchant and buff overview for Holy Paladins
I'm excited by the features in the 1.5 Update. How will the attendance list export functionality be supported?
Order of the <Mystical Stump>
Light be with you.
Light be with you.
Hey TJ,
Well I actually wrote up an overview of how all the new elements work for a permanent guide here on the Barrens.chat but what with the launch of Classic, it is still waiting to be released; but I have copied out the run-down of the functions, so you can check it all out!
Step 1. Ensure your Roster tab is populated with key data
SpoilerShow
Ensure that Player Names, Gear Check and Join Date are filled out properly
Step 2. Prepare your Signups Tab
SpoilerShow
Select the appropriate date and raid
Step 3. Await member signups
SpoilerShow
Ensure that your members are aware of the signup needs, and that they do in advance of your raid-planning.
Step 4. Verify your selector overview is populated
SpoilerShow
Data in the overview should correspond to your Signups
Step 5. Begin Force Building
SpoilerShow
Adjust the force composition to your demands; if you maintain a standard approach you can simply leave the tab as is, and just clear the signups when the raid is over.
Step 6. Populate your Raid Group and select Standbys
SpoilerShow
Drop down menus easily enables you to select viable members for your raid group; you can mark them off in the Selector Overview if needed to keep track.
Step 7. Ensure your Raid Group is properly configured
SpoilerShow
An extra check can save you a lot of trouble
Step 8. *NB. POST RAID* Once a Raid group is committed, copy out your Export List
SpoilerShow
The list contains all selected members in the Raid Force, e.g. your Raid Group + up to 20 Standbys
Step 9. Go to your Attendance tab
SpoilerShow
Step 10. *NB. POST RAID* Log Raid + Attendance
SpoilerShow
Select the appropriate date, and CTRL+SHIFT+V to paste your export list to the attendance tracker, this tab will feed your loot distribution overview with data. This tab can manually be adjusted, if needed.
Step 11. Prepare the Raid Assignments tab
SpoilerShow
Select Debuffs for your 16 available debuff slots. Select Raid Date, Select members responsible for world buffs, and dousing runes.
Step 12. Assign responsibilities
SpoilerShow
Assign players using the drop-down menus to specific tasks, and assign these players to debuff slots as required.
Step 13. Kill Bosses and Assign Loot
SpoilerShow
Add items as you go, should you have duplicate items that are not raid-rolled, then the sheet should support adding additional rows
Step 14. Keep watch of the Loot Distribution tab
SpoilerShow
This tab is fed with available raid data based on your entries.
- Xcellers
|Paladin|Firemaw EU-PVP|
|Paladin|Firemaw EU-PVP|
Mk. Ultra - Comprehensive Guild Management Spreadsheet
A comprehensive tool for guild managers maintaining rosters & loot distribution in LC based guilds
Vault of the Silverhands, A Gear Primer for Holy Paladins
A progressive and customisable item, enchant and buff overview for Holy Paladins
A comprehensive tool for guild managers maintaining rosters & loot distribution in LC based guilds
Vault of the Silverhands, A Gear Primer for Holy Paladins
A progressive and customisable item, enchant and buff overview for Holy Paladins
wow @Xcellers I know what a monumental effort this was. I really appreciate the convenience this gives to the community. Thank You!
Hello, can anyone help me with the raid attendance? I don't know how to copy the export list to attendance, all im getting is #REF error...
Its really my pleasure man, just happy to provide something useful for the community!
Hey man,
Most likely you are using CTRL+V to paste the export list to attendance, the issue with this is that this will only paste the formula (which breaks) - what you need to do is to use CTRL+SHIFT+V to paste the content instead, so the sheet can see and count the usernames it relies on for attendance tracking. This should also be noted on the attendance list but it might be easy to miss!
Hope that works out for you!
- Xcellers
|Paladin|Firemaw EU-PVP|
|Paladin|Firemaw EU-PVP|
Mk. Ultra - Comprehensive Guild Management Spreadsheet
A comprehensive tool for guild managers maintaining rosters & loot distribution in LC based guilds
Vault of the Silverhands, A Gear Primer for Holy Paladins
A progressive and customisable item, enchant and buff overview for Holy Paladins
A comprehensive tool for guild managers maintaining rosters & loot distribution in LC based guilds
Vault of the Silverhands, A Gear Primer for Holy Paladins
A progressive and customisable item, enchant and buff overview for Holy Paladins
This thread is now locked, please refer to the new topic found here: viewtopic.php?f=3&t=2374
Admin • Bug reports • Avatar requests
- 1
- 2
