Notifications

Clear all

Mk. Ultra Guild Management Sheet

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

Page 8 / 8 Prev

General

Last Post by Anonymous 1 second ago

113 Posts

55 Users

0 Reactions

119.2 K Views

RSS

Oczaki

(@oczaki)

Posts: 3

New Member

The spreadsheet is very made! Really good job, I think that just like me and many people it helps and makes life easier: D Once again great job!

Posted : 27/01/2021 5:58 pm

Nihla

(@nihla)

Posts: 2

New Member

Hmmm...Mr. Xcellers not answering here nor on discord-pms. Guess he is lost. Does anyone know a similar system (sheet based or hosted stuff) for guild management which is tbc compatible ?

Posted : 15/02/2021 12:22 pm

Furious

(@furious)

Posts: 246

Member Admin

@nihla Yeah unfortunately I don't think it's maintained anymore {orcs}:sad:

Posted : 17/02/2021 1:27 am

sneakzz

(@sneakzz)

Posts: 1

New Member

I would LOVE access to this sheet but it seems the owner has gone MIA :(

Posted : 26/05/2021 3:51 am

chaksur

(@chaksur)

Posts: 2

New Member

spreadsheet is looking better and better with every update.

This post was modified 3 years ago 2 times by chaksur

Posted : 27/12/2021 10:05 am

Lucif3rX166

(@lucif3rx166)

Posts: 37

Eminent Member

@schmoopy no that looks SPECIAL it does. mighty good job

Posted : 03/02/2022 8:06 pm

khallesy

(@khallesy)

Posts: 2

New Member

@xcellers

hi,

how can i have acesso to youre sheet?

Posted : 21/03/2022 11:49 pm

khallesy

(@khallesy)

Posts: 2

New Member

@xcellers

hi,

how can i have acesso to youre sheet?

Posted : 21/03/2022 11:49 pm

Page 8 / 8 Prev

36 Forums
1,800 Topics
32.4 K Posts
0 Online
37.4 K Members

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

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