Notifications

Clear all

[Guild Management] Mk. Ultra - Guild Sheet

Xcellers · 2019-08-13T07:05:53Z

This thread is locked, please refer to the new topic found here:Hi all,I have spent a bit of time, putting together a easy-to-use framework, to off-set the administrative tasks associated with running a Loot Council based guild. While by no means a innovative project, it is however a rock-solid basis, that new and experienced guild leaders can use to maintain most of the day-to-day administrative tasks, while keeping things easy and approachable, when considering topics such as transparency, oversight and cooperation internally in the guild.The spreadsheet is based around a number of core elements; a Roster, a data sheet, an optional guild info sheet, the loot distribution module and its associated loot modules for each raids. It is not a final product, and a number of module requests are already being evaluated and planned. It should also be noted that this is a cross-post from Reddit, but hopefully nobody will take offence from that - Link to original post hereROSTER SHEEof the rosterThe Roster is intended to be filled out by regular members in the following segments "Basic-, Class-, Crafting-, PVP-, Attunement- and Misc Info". The information can be sorted in whatever ways wanted, but by class gives the best overview. As soon as a member selects a class, the Roster will automatically assign them a corresponding colour, officers will however need to manually sort the sheet with regular intervals to keep things tidy.A last segment of the Roster is the Officer Info, this is reserved for displaying special functions within the guild or to relay short information bits. The segment also has a tick box for gear checks, to provide an easy overview for Loot Councils if a player has adequately prepared for raiding, but pre-raid gearing. How this is approached in effect, is up to the individual guilds.By default, the sheet supports 100 members, but can be scaled up - if required. The sheet comes in both Alliance and Horde versions.DATA SHEEDatasheet outputSiphoning information from the Roster, the Data sheet provides easy oversight of the guild composition, this is mainly a neat feature, but is also useful for guilds setting specific roster targets, for recruitment purposes. Socials are sadly counted in this overview, so they will interfere with target values, if listed.Set Targets can be adjusted to suit your specific recruitment needs.GUILD INFversion of a fully formed guild info sheetThe Guild Info sheet is a manually filled out sheet, typically locked to the GM, who can provide the guild with a strategic overview of the management core, and their responsibilities. The page can be adjusted to suit whatever heirachy is in effect for respective guilds, and is essentially a (highly recommended to use) playground that you can adjust as you see fit.MASTER CRAFTERMaster Crafter listTo easier facilitate member crafting needs, with member crafting capacities, the sheet also includes a Master Crafter list, these are your typical (tho by no means comprehensive) lists of desired items and services, that might be required in endgame settings.The drop down lists on the sheet, are automatically populated based on roster list, and will be displayed in the order of your choosing (e.g. how you have your Roster sorted)LOOT DISTRIBUTIOversion of the Loot Distribution overviewThe Loot Distribution sheet is a locked sheet, that automatically imports guild members from the Roster Sheet, and performs automatic and instantaneous counts these usernames, in the following Raid Specific Sheets. The entire process serves to provide transparency to members, and to assist the Loot Council in handing out loot more fairly.RAID SPECIFIC SHEETMolten Core sheet as an example, all raids shares the aesthetics and approachRaid Specific sheets can be found for all available raids and world bosses, and all feed the Loot Distribution sheet to grant an overview of allocations.For each raid, all viable drops, from all bosses and trash, is listed in the overview. generic blues, crafting recipes and similar are not supported as they tend to be handed out in a slightly different context than raid quality epics.Data entry is suggested as locked to Officers and Privileged Users, and works by selecting a raid date by double-clicking in the date selector cells, and picking the raid date. As items drops through the course of the raid, the Loot Council can assign names to the items, as they are distributed, using an automatically populated list of members, much akin to the one under Master Crafters. Each time a name appears in these cells, will be credited to the Loot Distribution sheet.Should multiple items drop, then the sheet supports multi-entries per cell, as long as they are spaced with a ", " (comma+space). Some items, such as MC trash drops might be entirely disregarded, such approaches are guild specific.PUBLIC TEST VERSIONFor those of you wishing to check things out further, then I have a public test version (set on view mode) that you can browse through...

Page 2 / 2 Prev

Last Post

RSS

Xcellers

(@xcellers)

Estimable Member

I have already send a link to our GM :)

Ill keep my eye out Grind, hopefully we can get you guys sorted ASAP :lol:

ReplyQuote

Topic starter Posted : 16/08/2019 2:53 pm

Soupoftheday

(@soupoftheday)

Eminent Member

Incredible, this is exactly what we need, especially with the new 500 member cap! You truly are a hero of Azeroth! Thank you!

ReplyQuote

Posted : 18/08/2019 7:21 am

Xcellers

(@xcellers)

Estimable Member

Incredible, this is exactly what we need, especially with the new 500 member cap! You truly are a hero of Azeroth! Thank you!

Well we better make sure you guys get sorted asap then Soup! :cool:

ReplyQuote

Topic starter Posted : 18/08/2019 3:38 pm

TJourney

(@tjourney)

Eminent Member

Hey Xcellers I have a feature-request: Could you add a sheet for storing a Player Roster, with a column on the existing roster sheet which validates to a playername from the player roster sheet? This would be helpful for tracking the relation of multiple alt characters to the same player, organizing relevant recruitment/promotion data, and relating characters to out-of-game contact info.

ReplyQuote

Posted : 19/08/2019 2:37 pm

Xcellers

(@xcellers)

Estimable Member

Hey TJourney ,

I can put it on the list for sure, but it would most likely end up being a post-launch thing, right now focus is on all the attendance stuff

ReplyQuote

Topic starter Posted : 20/08/2019 12:57 am

bobbiota

(@bobbiota)

New Member

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

Is it possible to make more guildbank characters than one?

ReplyQuote

Posted : 20/08/2019 3:41 am

Xcellers

(@xcellers)

Estimable Member

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!

ReplyQuote

Topic starter Posted : 20/08/2019 5:31 am

TJourney

(@tjourney)

Eminent Member

I'm excited by the features in the 1.5 Update. How will the attendance list export functionality be supported?

ReplyQuote

Posted : 27/08/2019 12:16 pm

Xcellers

(@xcellers)

Estimable Member

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!

/images/guides/wg_basics.png
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

Ensure that Player Names, Gear Check and Join Date are filled out properly

Step 2. Prepare your Signups Tab

Select the appropriate date and raid

Step 3. Await member signups

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

Data in the overview should correspond to your Signups

Step 5. Begin Force Building

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

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

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

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

Step 10. *NB. POST RAID* Log Raid + Attendance

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

Select Debuffs for your 16 available debuff slots. Select Raid Date, Select members responsible for world buffs, and dousing runes.

Step 12. Assign responsibilities

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

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

This tab is fed with available raid data based on your entries.

ReplyQuote

Topic starter Posted : 27/08/2019 12:57 pm

morel

(@morel)

New Member

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

ReplyQuote

Posted : 02/10/2019 2:14 pm

mattey92

(@mattey92)

New Member

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

ReplyQuote

Posted : 29/10/2019 5:07 am

Xcellers

(@xcellers)

Estimable Member

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

ReplyQuote

Topic starter Posted : 29/10/2019 6:50 am

teebling

(@teebling)

Noble Member

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

ReplyQuote

Posted : 29/10/2019 7:27 am

heras

(@heras)

New Member

@tjourney hey did you get the Ultra Sheet? i want to use it but dont know xeller sseems to be inaktive

ReplyQuote

Posted : 13/01/2021 9:19 am

Page 2 / 2 Prev

RE: What is everyone playing right now?

Last year I played DOTA 2 and ...

By garrylazaret , 3 years ago
RE: EIP Discord Game Giveaways!

Interested in games WoW and Lo...

By humbertplug , 3 years ago
RE: How to Get to Winterspring in WoW Classic

To reach Winterspring, head th...

By sherrly , 3 years ago
RE: What music will you listen to?

Does anybody listen Jaychou?

By sherrly , 3 years ago
[H] Mankrik

Who we areWe are a core group ...

By matymathew , 3 years ago

Forum Statistics

36 Forums

1,800 Topics

32.4 K Posts

0 Online

37.7 K Members

Latest Post: What is everyone playing right now? Our newest member: Didko89 Recent Posts Unread Posts Tags

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed