User avatar
donator Posts: 2
Likes: 0
Horde
Warrior

Wow, incredible work. I would love to use it.

Is it possible to make more guildbank characters than one?

Paladin Holy
User avatar
EU Firemaw
donator Posts: 107
Likes: 84
Human
Paladin

bobbiota wrote:
3 months ago
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!

   bobbiota
- Xcellers
|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

Burning Steppes
User avatar
donator Posts: 24
Likes: 10
Human
Paladin

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.
Paladin Holy
User avatar
EU Firemaw
donator Posts: 107
Likes: 84
Human
Paladin

TJourney wrote:
3 months ago
I'm excited by the features in the 1.5 Update. How will the attendance list export functionality be supported?
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!

While the Mk. Ultra Guild Management Sheet is relatively intuitive to use, its advanced features for raid management can be a challenge to some users. As such, novice users are recommended to go through the basic operational guide, to familiarize themselves with the basic procedure.

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.

   Cowyousaid
- Xcellers
|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

User avatar
US Stalagg
donator Posts: 1
Likes: 1
Alliance
Mage

wow @Xcellers I know what a monumental effort this was. I really appreciate the convenience this gives to the community. Thank You!

   Cowyousaid
EU Mograine
donator Posts: 2
Likes: 0

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...

Paladin Holy
User avatar
EU Firemaw
donator Posts: 107
Likes: 84
Human
Paladin

morel wrote:
2 months ago
wow @Xcellers I know what a monumental effort this was. I really appreciate the convenience this gives to the community. Thank You!
Its really my pleasure man, just happy to provide something useful for the community!
mattey92 wrote:
1 month ago
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...
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|
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

Warrior Protection
User avatar
EU Hydraxian Waterlords
donator Posts: 1325
Likes: 2543
Orc
Warrior

This thread is now locked, please refer to the new topic found here: viewtopic.php?f=3&t=2374

Similar topics
to '[Guild Management] Mk. Ultra - Guild Sheet'
Posts ViewsLast post