This thread is locked, please refer to the new topic found here: viewtopic. 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. 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 members, but can be scaled up - if required. The sheet comes in both Alliance and Horde versions.
DATA SHEET 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. 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.
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. The entire process serves to provide transparency to members, and to assist the Loot Council in handing out loot more fairly.
For each raid, all viable drops, from all bosses and trash, is listed in the overview. 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. Some items, such as MC trash drops might be entirely disregarded, such approaches are guild specific. This also includes access to the Guide tab, that is not covered in this post. 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. 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. 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.
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!During these challenging times, we guarantee we will work tirelessly to support you.
We will continue to give you accurate and timely information throughout the crisis, and we will deliver on our mission — to help everyone in the world learn how to do anything — no matter what. Thank you to our community and to all of our readers who are working to aid others in this time of crisis, and to all of those who are making personal sacrifices for the good of their communities.
We will get through this together. This is an instructional guide to teach you how to use Cheeky's Spreadsheet to make intelligent decisions on gearing up your World of Warcraft Hunter. Cheeky's Spreadsheet is and continues to be one of the most useful tools a Hunter can have to determine what pieces of gear are best for them and their talent choices.
Article Edit. Learn why people trust wikiHow. Author Info Updated: October 3, To create this article, 11 people, some anonymous, worked to edit and improve it over time. This article has also been viewed 9, times. Learn more Explore this Article Steps. Tips and Warnings. Related Articles. Download Cheeky's Spreadsheet. The newest version can always be found online. Bookmark it if you need to. Go to the third tab of the workbook called "Setting and Results" to change a few things before getting started.
Under Character, Realm, and Server Set type in the obvious here. Make sure that you type your server name exactly as it is in-game.Use the! Keywords: bench, late, tentative, absence!
Limited to 1 per channel. If no channelId is provided, the current channels recurring event will be edited. The bot will DM you and ask for the paypal transaction id.
Removes the specified default emote for this template. Keywords: bench, late, tentative, absence. Starts the event creation and initates the recurrence of that event every days. Edits the recurring event in the specified channel. If you donated and wish to activate the donator features, use this command. You can either upload these emotes to use them with the custom template or you can use the emote id filenames in this pack Example:!
Setting the Raider Sign-Up to true will only allow users with a raider role to sign up for events. If the setting is set to false it will allow everyone to sign up for events. Synchronizes an event with its reactions in case the bot was unresponsive. The event will be updated after a 1 minute delay. Open a manually locked event. Does not work if the event simply expired, in that case you need to edit the event date.
Removes the user from the specified event. To remove multiple users, put the user names in  brackets and separate by comma.
Adds the users with the specified reactions to an event.GitHub is home to over 40 million developers working together to host and review code, manage projects, and build software together. If nothing happens, download GitHub Desktop and try again. If nothing happens, download Xcode and try again. If nothing happens, download the GitHub extension for Visual Studio and try again. Main code is within wow. Skip to content. Dismiss Join GitHub today GitHub is home to over 40 million developers working together to host and review code, manage projects, and build software together.
Contributing To run the automated checks, install npm. Then, install the project dependencies: npm install. You signed in with another tab or window.
Reload to refresh your session.My Account. Remember Me? Need an account? Register Now. Recent Blue Posts 13 hours ago. Recent Forum Posts PM.
Ultra - Guild Management Spreadsheet Updated. Thread: Mk. Ultra - Guild Management Spreadsheet Updated Hi everyoneJust before the launch of Classic, I published a comprehensive spreadsheet intended to help, what I anticipated to be just a few, Loot Council based guilds in handling all the organisational tasks. Since then the project has grown, and now with about guilds using it and its sixth update going live, then I figured it was time to reshare it with the community.
Feature Gallery Roster Comprehensive overview of all member info Data sheet Key metrics for roster data and recruitment Guild Info Overview of guild management roles Loot Distribution overview Grand overview of attendance, metrics and loot allocations for all members Compare tool Detailed compare tool with increased data on up to four members at a time Signups and Absence Built in signup and MIA system Raid Building Raid Group builder, incl assignments not shown Attendance tacking Attendance tracking Raid specific loot handling Loot logs for all raids.
Reply With Quote. Jesus that's a lot of work. Makes my spreadsheet look primitive in comparison. And my sheet's pretty nifty too, with charts that auto populate, and totals tallies, etc.
Add or Search characters guilds. Ny'alotha, the Waking City. Removing non-active WoW characters. Due to the updated Blizzard API Policy, we have to refresh all the characters no less frequently than every 30 days. At the moment WoWProgress updates members of active raiding guilds several times a month. Characters that are not members of such guilds most probably will be removed from our database if you don't update them manually.
If a character was deleted or moved by the player, we also have to remove it from our database. Comments: WoWProgress on Facebook. Complexity Limit. FatSharkYes r. Practice r. Big Dumb Guild r. PMA r. Unwealthy Homeless. Alterac Deviants r. Midwinter r.
Two version to choose from!
Club Camel r. Walkthrough r. Lighthard EU alliance. Pryde EU horde. Katakurrii EU horde. Weinar US horde. Connection Lost EU-Magtheridon.Author note: This post and the attached link are best viewed on desktop rather than mobile due to the size of the content. This is a useful tool for Raiders and Raid Leads alike.
The Summary is not really an important page. You can also see your ilvl and artifact traits, much like on the Summary page. For example, we can tell at a glance that most people have back pieces High Command and Chest Eonarbut not a lot of people have the head piece Aggramar or shoulders Coven. Depending on raid comp, we may decide to forego or nail down specific bosses for tier sets.
The Roster page is not immediately useful to a guild like ours. This is the most useful page for an individual to view.Warcraft (WoW) 12-Class All-The-Things Challenge: The Spreadsheet
Next, you get a quick glance at your missing gems and enchants. You also get to see what you have equipped and can follow Wowhead links to each. Also, in the column above, the third relic slot can be tricky as well. I do not, in fact, have an relic. Just like addons and Warcraft Logs, the Wow Audit is just a tool. My suggestion would be to check it before raid starts, just to make sure you have all your best bits in place. Also, as a caveat: the audit sheet automatically updates every 3 hours or so from the armory.
This means you need to log out and wait a while to see any changes. Not a part of the WoW Audit? For the most part, only regular raiders are included regardless of Raider status because of limited spots. Author note: This post and the attached link are best viewed on desktop rather than mobile due to the size of the content A few weeks ago, I added a link to the Raid Announcements channel on discord: a Ministry of Defense WoW Audit. Summary The Summary is not really an important page.
Roster The Roster page is not immediately useful to a guild like ours. Single View This is the most useful page for an individual to view.