Mk. Ultra Guild Management Sheet – Page 2 – General

Xcellers · 2019-08-30T06:21:24Z

Mk. Ultra - Comprehensive Guild Management Spreadsheet by Xcellers • 26th August 2019 A key challenge for Classic raiding guilds is heavy administrative tasks, involved in managing one or more 40-man raid groups. Adding to this challenge, is the strategic overview needed to successfully ensure the fair and transparent distribution of loot in Loot Council based settings. To this end the Mk. Ultra spreadsheet seeks to provide a intuitive & comprehensive platform for this, easing the administrative burden on officers, while ultimately benefiting the guilds member base. NB. Guide Materials and Public Version is currently outdated, and as there is a big push for the next major content update before ZG launches, it will remain outdated for the time being. The current version changes are covered in the newsletter that went out to all users and is linked in the discussion - for reference you can find the info here:Important Notice - July 2020 - Due to IRL obligations, then the major 2.0 content overhaul is unlikely to be launched in advance of AQ, additionally, expect extended delays in getting access to the sheet in the coming months. I will be deploying to a diplomatic mission in Africa for the next foreseeable future and as you might expect, my focus is on that. I am still hoping to manage everything, but fair warning given! images/guides/rg_contents.png IntroductionSpreadsheet OverviewBasicsPublic Test VersionUsageUpdates Version 1.2 Version 1.3 Version 1.4 Version 1.5 Version 1.6 Version 1.7 HOW-TOs Adjusting Ranks Recovering Class Icons Adding Week Numbers to Raids/Attendance Adding profession specialisations Switching to Simple Attendance Tracking instead of Raid Builder mode Adjusting Time Formats Cleaning up Unused Tabs Hotfix the Compare Tab Enable Scripts Add room for duplicate items FAQCredits intro /images/guides/wp_intro.png The Mk. Ultra Guild Management Spreadsheet consists of a range of core elements, tracking valuable information on guild composition, crafting capabilities and heirachy to facilitate a single-visit location for all daily information needs. As noted, the spreadsheet maintains a design focus onloot council based guilds, as these adhere to less rigid formats for loot management, than the strict point accounting systems used in DKP settings. The spreadsheet is specifically designed as a non-profit to non-profit, community oriented project, and as such the target audience is solely guilds operating without any economic interests tied to the game. This stance means that all users will be screened, providing practical information to facilitate the correct version of the sheet, opt in/out for updates and general administrative information. For more information on getting access to this guild management tool for your guild, please see the usage section. As as passion-project, the Mk. Ultra is intended for running updates, as the current configuration of the the spreadsheet requires users to copy a faction specific sheet to their own google drive, and populate/implement it from there, it also means that updates has been decentralized. This means, that guilds who opt in for updates, will receive occasional update information with clear guidelines on updating the sheets. The first waves of these updates has already been successfully deployed and a number of requests are already being converted into new, fresh updates for the sheet. For those wishing to avoid this kind of hassle, then the initial invite version you will receive, will always be updated to the newest version, and each release can be tracked via. the guide tab. section1 /images/guides/wp_overview.png Below is a run-through of how the sheet is currently configured, modules are still being released so this overview may be expanded in the future with commonly requested features such as attendance tracking, raid composition and similar. At its core, the spreadsheet will share data between tabs, basing itself around the initial Roster tab. The populated Roster tab will provide player data for all drop-down menus, and as a basis for all calculations across the sheet. The goal is to automate as many administrative tasks as possible, while still keeping the day-to-day operations as transparent as possible for members. It is highly recommended to protect most of the available sheets so that only guild officers have direct access to them, while still leaving them view-able by members, to ensure better oversight; notably in regard to loot distribution. Roster Data Guild Info Master Crafters Loot Distribution Compare Signups Raid Composition Attendance MC Assignments MC BWL AQ40 Naxx WBs Ony ZG AQ20 Guide 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 colo...

Xcellers

(@xcellers)

Posts: 141

Estimable Member

Topic starter

Great resource for guilds! Many thanks @Xcellers!

Much appreciated man, just happy to assist the community tbh!

Posted : 24/09/2019 8:55 am

gibzy

(@gibzy)

Posts: 1

New Member

Received a copy today, and after playing around a bit in it, I can say it's very much what I was looking for. Even though we don't run loot council, the loot tabs are still useful for general overview.
And I especially love the visualization that the Data tab provides.
Much thanks to the creator!!

Posted : 01/10/2019 2:07 am

Xcellers

(@xcellers)

Posts: 141

Estimable Member

Topic starter

Received a copy today, and after playing around a bit in it, I can say it's very much what I was looking for. Even though we don't run loot council, the loot tabs are still useful for general overview.
And I especially love the visualization that the Data tab provides.
Much thanks to the creator!!

Really happy to hear that man, and as always its really just my pleasure to assist the community a bit!

Posted : 03/10/2019 12:12 pm

Xcellers

(@xcellers)

Posts: 141

Estimable Member

Topic starter

New milestone; guild no. 300 just adopted the Mk. Ultra for their guild management!

Posted : 04/10/2019 2:30 pm

TJourney

(@tjourney)

Posts: 24

Eminent Member

Congratulations Xcellers! Well done.

Posted : 04/10/2019 3:05 pm

mattey92

(@mattey92)

Posts: 2

New Member

Very nice sheet.

Posted : 06/10/2019 6:28 am

Schmoopy

(@schmoopy)

Posts: 3

New Member

Hey - I've been having a great time using your spreadsheet and the guild is impressed and thankful as well.

The only two things that are worth to mention in regards to changes:

1. There is no DPS paladin sign up.

2. For the Loot Distribution tab - I don't know if there is a way already to fix my situation but, New recruits that join and get added to the roster, their join date is already past the last 2 raid days - but they show up as 33% attendance even though it was their first raid today. I've been trying solve it myself but cannot see if there is already a Function to track Guild member raid attendance based on their join date. Feels if this keeps going I will have member who join on the 20th raid and will have to work with 5% attendance on day one.

There's a few other small details but it's not something that I could not change myself.

The spreadsheet is absolutely amazing regardless, Thanks.

https://imgur.com/a/9mIfMX2

1 Day in the guild - 1 Raid attended (3 Total Raids) - 33% Attendance - Example

Posted : 09/10/2019 3:40 pm

Vexer

(@vexer)

Posts: 2

New Member

Hello! Thank you Xcellsers. I just got into it and I'm setting it up for my guild. This is exactly what I was looking for to help manage my guild.

Thanks again!

Posted : 13/10/2019 8:38 am

atomares

(@atomares)

Posts: 1

New Member

Great Ressource and Thanks for Sharing it with us <3

edit: Everything Worked :) thank you <3

Posted : 14/10/2019 7:56 am

Xcellers

(@xcellers)

Posts: 141

Estimable Member

Topic starter

Great Ressource and Thanks for Sharing it with us <3

edit: Everything Worked :) thank you <3

Hello! Thank you Xcellsers. I just got into it and I'm setting it up for my guild. This is exactly what I was looking for to help manage my guild.

Thanks again!

Very nice sheet.

Congratulations Xcellers! Well done.

Thank you so much for the support guys, hope you are thoroughly enjoying the sheet!

Hey - I've been having a great time using your spreadsheet and the guild is impressed and thankful as well.

The only two things that are worth to mention in regards to changes:

1. There is no DPS paladin sign up.

2. For the Loot Distribution tab - I don't know if there is a way already to fix my situation but, New recruits that join and get added to the roster, their join date is already past the last 2 raid days - but they show up as 33% attendance even though it was their first raid today. I've been trying solve it myself but cannot see if there is already a Function to track Guild member raid attendance based on their join date. Feels if this keeps going I will have member who join on the 20th raid and will have to work with 5% attendance on day one.

There's a few other small details but it's not something that I could not change myself.

The spreadsheet is absolutely amazing regardless, Thanks.

https://imgur.com/a/9mIfMX2

1 Day in the guild - 1 Raid attended (3 Total Raids) - 33% Attendance - Example

Hey man,

Thanks for all the feedback, the exclusion of a number of niche class/spec combos is actually intentional as I provide more of a "baseline" version that is suitable for as many guilds as possible, so with stuff like this then it might take a bit of customisation to make it fit perfectly to individual guild needs. If there is enough requests for it, then I can naturally provide some guidelines on how to approach this.

Regarding attendance, then yeah this is a bit of an issue, and it is something that I am trying to address in the next quality of life update to the sheet, so hopefully i can provide a workaround update that includes this fairly soon!

Posted : 15/10/2019 6:41 am

KyleM_TV

(@kylem_tv)

Posts: 1

New Member

My guild is using and loving Mk Ultra :)

One piece of feedback:

Thanks for all the feedback, the exclusion of a number of niche class/spec combos is actually intentional as I provide more of a "baseline" version that is suitable for as many guilds as possible, so with stuff like this then it might take a bit of customisation to make it fit perfectly to individual guild needs. If there is enough requests for it, then I can naturally provide some guidelines on how to approach this.

I would love a quick guide on how to add a new class/spec combo, namely our guild has an Elemental Shaman that we'd love to stop putting under healers :)

Seriously awesome tool, it has helped us a lot.

Posted : 15/10/2019 2:14 pm

Xcellers

(@xcellers)

Posts: 141

Estimable Member

Topic starter

My guild is using and loving Mk Ultra :)

One piece of feedback:

Thanks for all the feedback, the exclusion of a number of niche class/spec combos is actually intentional as I provide more of a "baseline" version that is suitable for as many guilds as possible, so with stuff like this then it might take a bit of customisation to make it fit perfectly to individual guild needs. If there is enough requests for it, then I can naturally provide some guidelines on how to approach this.

I would love a quick guide on how to add a new class/spec combo, namely our guild has an Elemental Shaman that we'd love to stop putting under healers :)

Seriously awesome tool, it has helped us a lot.

Yeah I will get to work on it ;)

Posted : 17/10/2019 9:00 am

Xcellers

(@xcellers)

Posts: 141

Estimable Member

Topic starter

New milestone; guild no. 400 just adopted the Mk. Ultra for their guild management!

Posted : 17/10/2019 9:01 am

Vils

(@vils)

Posts: 1

New Member

Hi, I would really like to be able to copy the sheet for my Guild Crowned Eu Razorgore - It looks really cool, amazing work!
Here is some information:

Guild Name: Crowned

Faction: Horde

Major (Professional) Streamers in guild? nope

Professional (Paid/Sponsored) guild? nope

Can I publicly list you as sheet users? Sure

Would you like me to inform you of future updates Hel yeah!!

Contact Email (Google Docs/Drive connected): PM

Thank u so much!

Posted : 18/10/2019 5:50 am

Fantomen

(@fantomen)

Posts: 1

New Member

Absolutely amazing spreadsheet.

Thank you so much Xcellers

I have only one suggestion regarding the loot distribution. It would be a very good thing to have an overview sheet with all members listed as well as the loot they received and which date.

Something like this:

Once again, a huge thanks for the sheet which will be incredibly useful for a long time.

Posted : 20/10/2019 3:23 am