Paladin Holy
User avatar
EU Firemaw
Posts: 67
Likes: 66
Human
Paladin
2 months ago (Beta)
 •  Unread

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 here

ROSTER SHEET
Image
Overview of the roster

The 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 SHEET
Image
Example Datasheet output

Siphoning 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 INFO
Image
Example version of a fully formed guild info sheet

The 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 CRAFTERS
Image
Unpopulated Master Crafter list

To 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 DISTRIBUTION
Image
Unpopulated version of the Loot Distribution overview

The 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 SHEETS
Image
Unpopulated Molten Core sheet as an example, all raids shares the aesthetics and approach

Raid 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 VERSION

For 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. This also includes access to the Guide tab, that is not covered in this post.

Mk. Ultra - Public Test Version

PLEASE DO NOT REQUEST ACCESS TO THE PUBLIC TEST VERSION

THIS IS NOT THE VERSION THAT YOU WANNA USE (YOU JUST THINK YOU DO!)


USAGE

If the Mk. Ultra Roster is something that you wish to use for your guild, then I am naturally happy to assist you in that; it is naturally absolutely free, and you wont need to join any streams, servers, or patreons.

While it is possible that I host the sheet for you and your guild, most guilds has wished to maintain a decentralised copy, and instead opting in for guided updates via mail, in practice, all you need to do, is to have a senior officer contact me (preferably a GM through a PM) and supply me with some basic (qualifying) information. see below.

Guild Name:

Faction:

Major (Professional) Streamers in guild? Y/N

Professional (Paid/Sponsored) guild? Y/N

Can I publicly list you as sheet users? Y/N

Would you like me to inform you of future updates Y/N

Contact Email (Google Docs/Drive connected):
It should be noted, that this is a non-profit service, intended for non-profit guilds and organisations, with no commercial interests. Furthermore, usage is personal and guild tied, and it is requested that you or your guilds do not share it with third parties.

FAQ
  • Why is it called Mk. Ultra?
MK. Ultra (MKUltra) was a CIA mind control program running in the 1950/60/70s, I wont spoil the story, but recommend you putting on one of the many documentaries on the subject, while you level your characters. The tie in here is less nefarious than the original CIA covert project, as the goal here is not mind control, but rather to provide strong and professional looking infrastructure to guilds, so that it rubs off on members; look pro, think pro, feel pro.

  • Response Rate
After churning through a few hundred messages back and forth, it seems the worst hurdle has passed; I am CEST based (Denmark) so I can normally be reached during normal EU hours - and I am definetly doing my best to get back to you ASAP.

  • How-To X/Y/Z?
Recurring issues will get short how-to guides, if its a more elaborate issue, then just get a hold of me, and i will do my best to get you sorted!

HOW-TO: Edit Ranks

HOW-TO: Recover all Class Icons

  • Contact Info
A Barrens.chat PM is perfectly fine, alternatives are opening a chat with me through reddit, or as an alternative you can reach me on Xcellers#1681 via discord

  • Can I share this sheet with others?
In short; No. - you are most welcome to direct them here and they can get a copy through me, the same way that you got it - but requests are personal and intended for you and your guild.

CURRENT GUILDS ON MK. ULTRA: 140

Image

CREDITS

Raid Banners, Courtesy of @Teebling @ The Barrens Chat @ https://barrens.chat

Class Icons, Courtesy of WowPedia @ https://wow.gamepedia.com

   Genecide teebling s1atan TJourney Dolamite ClassicRaids tygoro Kazukii ImQk mookey Czar Cram Skye unsane Cowyousaid Hodor SHIFTD Biggsy Jimjo
- 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
ImageImage

Vault of the Silverhands, A Gear Primer for Holy Paladins
A progressive and customisable item, enchant and buff overview for Holy Paladins
Image
Burning Steppes
User avatar
Posts: 24
Likes: 10
Human
Paladin
2 months ago (Beta)
 •  Unread

Wow Xcellers, thank you for all the work you've done on this - it is indeed quite extensive. I'll send you a PM

   Xcellers
Order of the <Mystical Stump>
Image
Light be with you.
Thunder Bluff
User avatar
Posts: 68
Likes: 64
Tauren
Druid
2 months ago (Beta)
 •  Unread

Xcellers wrote:
2 months ago
I have spent a bit of time
I think we have a different definition of "a bit of time" lol

But in all seriousness, this is an amazing run-down of everything a GM and their officers would need. Great job!

   Xcellers
Nala - Feral Druid - Grobbulus
"May the eternal sun shine upon thee"
Image
Paladin Holy
User avatar
EU Firemaw
Posts: 67
Likes: 66
Human
Paladin
2 months ago (Beta)
 •  Unread

SweaterMonster wrote:
2 months ago
Xcellers wrote:
2 months ago
I have spent a bit of time
I think we have a different definition of "a bit of time" lol

But in all seriousness, this is an amazing run-down of everything a GM and their officers would need. Great job!
I eh, I might have understated how much time exactly went into this :eek:

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

Vault of the Silverhands, A Gear Primer for Holy Paladins
A progressive and customisable item, enchant and buff overview for Holy Paladins
Image
User avatar
US Thalnos
Posts: 32
Likes: 11
Horde
Shaman
2 months ago (Beta)
 •  Unread

Great job!

   Xcellers powerfool
Español, por favor.
Paladin Holy
User avatar
EU Firemaw
Posts: 67
Likes: 66
Human
Paladin
2 months ago (Beta)
 •  Unread

Genecide wrote:
2 months ago
Great job!
TJourney wrote:
2 months ago
Wow Xcellers, thank you for all the work you've done on this - it is indeed quite extensive. I'll send you a PM
Thanks a bunch guys, just spreading a bit of the light to the community, one spreadsheet at a time!

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

Vault of the Silverhands, A Gear Primer for Holy Paladins
A progressive and customisable item, enchant and buff overview for Holy Paladins
Image
Paladin Holy
User avatar
EU Firemaw
Posts: 67
Likes: 66
Human
Paladin
2 months ago (Beta)
 •  Unread

For those on the fence, the Mk. Ultra sheet has now been updated and now features a member cap of 500 (instead of just 100) and its naturally still free and available (to non-profit based guilds and organisations).

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

Vault of the Silverhands, A Gear Primer for Holy Paladins
A progressive and customisable item, enchant and buff overview for Holy Paladins
Image
Shaman Elemental
User avatar
Posts: 64
Likes: 16
2 months ago (Beta)
 •  Unread

Wow, this is an amazing resource Xcellers! Very much needed and I'm sure appreciated by the community. Thank you for your contribution :mrgreen:

Image
Hey there, ClassicRaids here! Join our weekly Free WoW Game Time Giveaway!

ClassicRaids is a website centered around endgame content for World of Warcraft Classic. We help our users with a WoW Classic Guild Recruitment List, Character Search & Lookup, and Gold Making Profession Guides. Check us out and let us know if there's anything we can do to better support the Classic WoW community!
User avatar
Posts: 2
Likes: 0
Orc
Hunter
2 months ago (Beta)
 •  Unread

Great Spreadsheet for any guid looking to play in Classic!

Paladin Holy
User avatar
EU Firemaw
Posts: 67
Likes: 66
Human
Paladin
2 months ago (Beta)
 •  Unread

ClassicRaids wrote:
2 months ago
Wow, this is an amazing resource Xcellers! Very much needed and I'm sure appreciated by the community. Thank you for your contribution :mrgreen:
Much appreciated man, and I should really say the same! I hope more guilds tune to ClassicRaids as a recruitment platform, it is just so much more convenient than drowning Discords or forums!
FudinTheKing wrote:
2 months ago
Great Spreadsheet for any guid looking to play in Classic!
Thanks a bunch Fudin, I hope the sheet turns out well for you guys!

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

Vault of the Silverhands, A Gear Primer for Holy Paladins
A progressive and customisable item, enchant and buff overview for Holy Paladins
Image
Warlock Destruction
User avatar
EU Firemaw
Posts: 292
Likes: 337
Undead
Warlock
2 months ago (Beta)
 •  Unread

Amazing work! I really like the PvP rank feature since I'm running a WPvP guild that's going to use LC and will factor in involvement in PvP during the LC.

Mulgore
User avatar
EU Shazzrah
Posts: 22
Likes: 16
Horde
Warrior
2 months ago (Beta)
 •  Unread

Amazing job, sending a request for a copy for my guild

Comments:
- Sages & Brute force does not stack with buffs and more powerfull elixirs/buffs, so they are irrelevant
- Missing: Greater Firepower & Gift of Arthas
- Missing: Thorium Shield Spike (just rename Mithril, noone uses it), Steel Weapon Chain, Mithril Spurs, Dark Iron Helm, Legs, Gloves, Bracers, Boots (NR gear comes too late, and frost gear is only important for tanks, so maybe not needed)
- Missing: Tender Wolf Steak, very popular for early raiding
- There are enchants that noone is using, but it is comprehensive
- Engineering: All reflectors are important and Arcanite Dragonling, also guild would list who can make sappers
- LW: It is very important who is making frost gear, as LW makes both leather and mail, and those are best for all physical damage dealers including warriors. I would split devilsaur into two, they are separate recipes.
- Tailoring: Needs Bloodvine set, NR cloak (Gaea's), and frost gear
- Loot: I would list all, not only "Tier1 wrist" as this way will go 40+ columns wide, same goes for rest of the stuff (if you want this I have it already written down in the spreadsheet, can export it for you to save you time)

- - -
Mookey & Cosá @ Shazzrah EU
Past: Mookey <The Celestial Defender> Xavius EU & Cosa @ Lightning's Blade / Northdale / Lightbringer
Paladin Holy
User avatar
EU Firemaw
Posts: 67
Likes: 66
Human
Paladin
2 months ago (Beta)
 •  Unread

mookey wrote:
2 months ago
Amazing job, sending a request for a copy for my guild

Comments:
....

Great feedback Mookey, the crafts section was a bit - quick n dirty - as its easy to expand upon, but I will make an adjustment to the core sheets, and send out an update (hopefully today.

Regarding wrists (especially) then my initial tests of multi-adding names was a bit misguided, as I had only tested manual entries of multiple names (which works) but not the drop-down menu solution that is currently in place (where multi-names does not work) so this might be quite useful. It should mainly be a problem for trash loot as bosses have assigned tier loot slots, depending on their drop-cap of these items (trash on the other hand.. )

Again, really great and highly useful feedback! much appreciated!

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

Vault of the Silverhands, A Gear Primer for Holy Paladins
A progressive and customisable item, enchant and buff overview for Holy Paladins
Image
User avatar
EU Gandling
Posts: 3
Likes: 2
Orc
Hunter
2 months ago (Beta)
 •  Unread

Impressive work!

Mulgore
User avatar
Posts: 44
Likes: 29
Tauren
Warrior
2 months ago (Beta)
 •  Unread

Damn. You deserve a (where a is a natural number from 1...n) beer, sir!

Paladin Holy
User avatar
EU Firemaw
Posts: 67
Likes: 66
Human
Paladin
2 months ago (Beta)
 •  Unread

Cram wrote:
2 months ago
Damn. You deserve a (where a is a natural number from 1...n) beer, sir!
Frosken wrote:
2 months ago
Impressive work!
Nymis wrote:
2 months ago
Amazing work! I really like the PvP rank feature since I'm running a WPvP guild that's going to use LC and will factor in involvement in PvP during the LC.
Thank you for all the positive comments guys, its the sort of stuff that makes investing time into the community all the more sweeter!

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

Vault of the Silverhands, A Gear Primer for Holy Paladins
A progressive and customisable item, enchant and buff overview for Holy Paladins
Image
Priest Holy
User avatar
EU Zandalar Tribe
Posts: 102
Likes: 54
Dwarf
Priest
2 months ago (Beta)
 •  Unread

Wow thank you so much for this! What an awesome sheet

Elwynn Forest
User avatar
US Pagle
Posts: 96
Likes: 49
Alliance
Druid
2 months ago (Beta)
 •  Unread

Holy crap, this is amazing. Very nice work @Xcellers
Would you call this completed, or v0.1?

Paladin Holy
User avatar
EU Firemaw
Posts: 67
Likes: 66
Human
Paladin
2 months ago (Beta)
 •  Unread

beached wrote:
2 months ago
Holy crap, this is amazing. Very nice work @Xcellers
Would you call this completed, or v0.1?
I would call it a 1.3 - next big hurdle is adding attendance tracking for the guilds interested in that sorta thing, and then I have a backlog of requests to consider; I am guessing I will have plenty to do for a while still!
Grindhouse wrote:
2 months ago
Wow thank you so much for this! What an awesome sheet
Thanks a bunch! Its been a bit of a hassle but its definitely also been worth it!

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

Vault of the Silverhands, A Gear Primer for Holy Paladins
A progressive and customisable item, enchant and buff overview for Holy Paladins
Image
Priest Holy
User avatar
EU Zandalar Tribe
Posts: 102
Likes: 54
Dwarf
Priest
2 months ago (Beta)
 •  Unread

I have already send a link to our GM :)

Paladin Holy
User avatar
EU Firemaw
Posts: 67
Likes: 66
Human
Paladin
2 months ago (Beta)
 •  Unread

Grindhouse wrote:
2 months ago
I have already send a link to our GM :)
Ill keep my eye out Grind, hopefully we can get you guys sorted ASAP :lol:

   Grindhouse
- 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
ImageImage

Vault of the Silverhands, A Gear Primer for Holy Paladins
A progressive and customisable item, enchant and buff overview for Holy Paladins
Image
Hunter Marksman
User avatar
Posts: 28
Likes: 19
Horde
Hunter
1 month ago (Beta)
 •  Unread

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

Together we thrive, divided we survive.
In the darkest night, we are the light.

Sol In Noctem

Image
Paladin Holy
User avatar
EU Firemaw
Posts: 67
Likes: 66
Human
Paladin
1 month ago (Beta)
 •  Unread

Soupoftheday wrote:
1 month ago
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:

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

Vault of the Silverhands, A Gear Primer for Holy Paladins
A progressive and customisable item, enchant and buff overview for Holy Paladins
Image
Burning Steppes
User avatar
Posts: 24
Likes: 10
Human
Paladin
1 month ago (Beta)
 •  Unread

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.

Order of the <Mystical Stump>
Image
Light be with you.
Paladin Holy
User avatar
EU Firemaw
Posts: 67
Likes: 66
Human
Paladin
1 month ago (Beta)
 •  Unread

TJourney wrote:
1 month ago
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.
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

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

Vault of the Silverhands, A Gear Primer for Holy Paladins
A progressive and customisable item, enchant and buff overview for Holy Paladins
Image
Similar topics
to '[Guild Management] Mk. Ultra - Guild Sheet'
Posts ViewsLast post