Paladin Holy
User avatar
EU Firemaw
Posts: 141
Likes: 112
Human
Paladin
9 months ago (1.13.3)
 •  Unread

1000 Guild treshold broken!

In celebration of breaking the milestone of 1000 guild users, I am happy to announce that the Version 1.7 update is under the final bit of polishing, and should deploy to the user-base within a day, so it can be put too good use as we embark for Nefarian's Lair in Blackwing Spire. The new update introduces higher levels of automation, and creates a baseline for more complex technical solutions, while also cutting excess weight to provide a more optimized solution, in the longer run.

The growth of the project has come at a cost, as managing communication with so many guilds is no longer possible using a simple gmail account (as mass-mailing updates to 1000 guilds is a great way to get all your Gmail account suspended) - this does mean a reevaluation of donation options for the Mk. Ultra as it is no longer running as a cost-less operation for me. This will not impact the non-profit status, but I will look into what options might be available.

Mk. Ultra Survey
As part of the celebration, I am also happy to share a bit of information on the recently concluded Mk. Ultra survey, which is a tool used to assist in development planning, and create direction of the Mk. Ultra sheet.

User-base data
Data has been gained through an online survey, sent out to entirety of the user-base, at the time 965 guilds, and maintained a response rate of sub-10% which is not exactly great, but also not surprising.

Faction Balance
Image

Overall Satisfaction Level
Guilds maintain an average satisfaction level, on a scale from 1-100%, of 88%

Version Status on Mk. Ultra Sheet
Image

Knowledge of the Barrens.chat thread
80% of the user-base already knew of the Barrens.chat, and the main Mk. Ultra discussion topic on here.

Donations
2.4% of the user-base donated to the suggested charities. The average contribution was €20, projections of almost €500 raised for AfghanAid, Halo Trust & Ghurka Welfare Trust so far!

Demographics
Average guild size: 337 members
Total amount of guild members benefiting from the Mk. Ultra: 338.000

Reliance on External Tools
Image
Image
Image
Image

Early research into further inclusion of external tools has begun, starting with Warcraft Logs, this is however borderline techno magic to me, so it is a slow process, that I am hoping for additional assistance in.

Reliance on Internal Tools
Image
Image
Image

A direct result of this, was that Raid Assignments for MC+BWL has been cut from the sheet, its a lot of work to make, it suffers from memory leaks and if nobody uses it, its out. The use on the Raid Builder system is fairly good, and with the new updates coming to this, I hope more people will find it useful. Alternatives are being planned to appease everyone tho, so no sweat if you are not a fan.

Feedback
Quite a lot of general feedback was provided through the survey, but in terms of moving the project forward, then the following was of particular interest.

Top 3 Promotion wishes
1 YouTube (Guides/Reviews/Interviews)
2 Podcasts (Interviews)
3 Official forum post

Regarding Guides/Review, then I hope there would be actual users that would want to do that, as it would be plain weird if I had to review my own work, and as I do not stream or produce that type of content, then video guides are sadly not really my forte. I am however always happy to talk about the project, tho I am not sure who would actually want to host it, or listen to it.

Top 5 Development Wishes
1 Integration of Internal tools (planned)
2 Infraction system
3 MS/OS system
4 Filters
5 Compare expansion (included, planned)

A few totally new things for me, and some already considered wishes. MS/OS is a system that i addressed by simply recommending users to NOT log anything but MS loot, but i can see the attraction in both (and the possible workload). Filters has been tested, but I promise to revisit it again. Infractions, for being late or not-prepared makes sense, but I will have to consider this a bit, as it is a bit of a name and shame move, that should maybe be handled more out of sight by guild managers. Further integration, absolute..

   teebling Bkatt
- 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


Vault of the Silverhands, A Gear Primer for Holy Paladins
A progressive and customisable item, enchant and buff overview for Holy Paladins

Paladin Holy
User avatar
EU Firemaw
Posts: 141
Likes: 112
Human
Paladin
9 months ago (1.13.3)
 •  Unread

Version 1.7 has been deployed

Announcement Email can be accessed here

- 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


Vault of the Silverhands, A Gear Primer for Holy Paladins
A progressive and customisable item, enchant and buff overview for Holy Paladins

User avatar
US Old Blanchy
Posts: 7
Likes: 5
Horde
Shaman
9 months ago (1.13.3)
 •  Unread

Awesome! I'm excited to finally try it out! When can I know how to contact you? I'm throwing in a bounty (or donation) since you got this done before BWL. You'll have to let me know a way to tip you when you have time to give me access.

Paladin Holy
User avatar
EU Firemaw
Posts: 141
Likes: 112
Human
Paladin
9 months ago (1.13.3)
 •  Unread

mechler wrote:
9 months ago
Awesome! I'm excited to finally try it out! When can I know how to contact you? Also, I'm throwing in a nice bounty since you got this done before BWL. You'll have to let me know a way to tip you when you have time to give me access.
PMs are actually great through here, its by far the easiest for me!

- 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


Vault of the Silverhands, A Gear Primer for Holy Paladins
A progressive and customisable item, enchant and buff overview for Holy Paladins

User avatar
US Old Blanchy
Posts: 7
Likes: 5
Horde
Shaman
9 months ago (1.13.3)
 •  Unread

Xcellers wrote:
9 months ago
PMs are actually great through here, its by far the easiest for me!
Done! Thanks for being so attentive!

User avatar
EU Shazzrah
Posts: 1
Likes: 0
Horde
Mage
9 months ago (1.13.3)
 •  Unread

Send you a PM :)

Paladin Holy
User avatar
EU Firemaw
Posts: 141
Likes: 112
Human
Paladin
9 months ago (1.13.3)
 •  Unread

Got you both sorted!

For anyone curious, there is a lot of info if you scroll up on this page ;)

- 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


Vault of the Silverhands, A Gear Primer for Holy Paladins
A progressive and customisable item, enchant and buff overview for Holy Paladins

Paladin Holy
User avatar
EU Firemaw
Posts: 141
Likes: 112
Human
Paladin
9 months ago (1.13.3)
 •  Unread

Pushed down, but not forgotten

- 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


Vault of the Silverhands, A Gear Primer for Holy Paladins
A progressive and customisable item, enchant and buff overview for Holy Paladins

Paladin Holy
User avatar
EU Firemaw
Posts: 141
Likes: 112
Human
Paladin
9 months ago (1.13.3)
 •  Unread

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

- 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


Vault of the Silverhands, A Gear Primer for Holy Paladins
A progressive and customisable item, enchant and buff overview for Holy Paladins

User avatar
US Mankrik
Posts: 1
Likes: 0
Horde
Mage
8 months ago (1.13.4)
 •  Unread

I have a Suggestion, In the Compare Tab, with your integration to RCloot, can we see the selected option, such as Mainspec/BiS, Minor upgrade etc..?

that would be a fantastic addition

User avatar
US Smolderweb
Posts: 1
Likes: 0
Orc
Warrior
8 months ago (1.13.4)
 •  Unread

I am reaching out to say thank you very much for sharing this tool. It enhanced the credibility of our LC and the tool strengthens our guild long term.

User avatar
US Kurinaxx
Posts: 1
Likes: 0
Horde
Druid
7 months ago (1.13.4)
 •  Unread

Guild Name: Distant

Faction: Horde

Server: Kurinnaxx

Major (Professional) Streamers in guild? N

Professional (Paid/Sponsored) guild? N

Can I publicly list you as sheet users? Y

Would you like me to inform you of future updates Y

Did you read and understand the limitations on sharing and usage?: Y

Paladin Holy
User avatar
EU Firemaw
Posts: 141
Likes: 112
Human
Paladin
7 months ago (1.13.4)
 •  Unread

For those not subscribed to the newsletter, running a sheet version with no ZG tab, then please see; https://bit.ly/3caCh9Y for guidelines on how to get sorted and my recommendations for not tracking ZG loot and attendance as you would in a main raid.

- 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


Vault of the Silverhands, A Gear Primer for Holy Paladins
A progressive and customisable item, enchant and buff overview for Holy Paladins

Mulgore
User avatar
EU Sulfuron
Posts: 1
Likes: 0
Human
Paladin
7 months ago (1.13.4)
 •  Unread

Thank you very much : ) Very helpful and well made !

Paladin Holy
User avatar
EU Firemaw
Posts: 141
Likes: 112
Human
Paladin
7 months ago (1.13.4)
 •  Unread

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

- 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


Vault of the Silverhands, A Gear Primer for Holy Paladins
A progressive and customisable item, enchant and buff overview for Holy Paladins

Paladin Holy
User avatar
EU Firemaw
Posts: 141
Likes: 112
Human
Paladin
6 months ago (1.13.4)
 •  Unread

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

- 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


Vault of the Silverhands, A Gear Primer for Holy Paladins
A progressive and customisable item, enchant and buff overview for Holy Paladins

User avatar
EU Amnennar
Posts: 2
Likes: 0
Horde
Priest
6 months ago (1.13.4)
 •  Unread

Hi,

Thanks again for this wonderful Sheet ^^

We decided with my guild to use the compare tab for explaining to everyone our loot distribution system. But there was a problem on the date displaying on the collumns, so we could not have the last date of loot for a selected member.

=SI(ESTERREUR(INDEX(MC!$B$2:$Y$2,,EQUIV($A$3,INDEX(MC!$B$5:EF$200,EQUIV(B13,MC!$A$5:$A$200,0),),0))),"",(INDEX(MC!$B$2:$Y$2,,EQUIV($A$3,INDEX(MC!$B$5:EF$200,EQUIV(B13,MC!$A$5:$A$200,0),),0)))
)
(yes i know, french code ^^)

The "MC!$B$2:$Y$2" blocks the reseach of the data sheet, and should be (for example) "MC!$B$2:$ZZ$2" so even if you add columns in the MC tab, you can have the date.

Second thing is the problem in the name of loots, we vahe many times "Tier 1 - Hands" in the loot table, so the sheet can't decide wich one choose, i decided to add A B C on theses loot and so i can have a nice view of wich player looted for the last time in our raid :)

Hope this help someone ^^

Dumbelmort

PS: sorry if my english is not perfect :biggrin:

User avatar
EU Lucifron
Posts: 1
Likes: 0
Orc
Druid
5 months ago (1.13.4)
 •  Unread

This sheet literally helps every classic guild. Thank you for your time and work. We really appreciate it!

User avatar
Posts: 1
Likes: 0
Alliance
Mage
5 months ago (1.13.4)
 •  Unread

Hello,

I stumbled upon this project a couple months back when I was deciding on forming my own guild.. Fast forward to today I am proud to say that I have started my own guild and currently have 80+ Lvl 60s. We are in the process of forming a second raid group and I desperately need a tool that will help me keep the guild organized for loot, consumables and raid roster. How do I get my hands on this? I'm very interested to test it out and to see how it may benefit my guild.

<Novus Imperium>
Windseeker US
Bkatt - Human Mage

Paladin Holy
User avatar
EU Firemaw
Posts: 141
Likes: 112
Human
Paladin
5 months ago (1.13.4)
 •  Unread

@Bkatt you guys should be all sorted :wink:

- 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


Vault of the Silverhands, A Gear Primer for Holy Paladins
A progressive and customisable item, enchant and buff overview for Holy Paladins

User avatar
US Kromcrush
Posts: 1
Likes: 0
Horde
Mage
5 months ago (1.13.4)
 •  Unread

Guild Name: <mlords>
Faction: Horde
Server: Kromcrush
Major (Professional) Streamers in guild? N
Professional (Paid/Sponsored) guild? N
Can I publicly list you as sheet users? Y
Would you like me to inform you of future updates Y
Did you read and understand the limitations on sharing and usage?: Y
IGN: Íneedbøngrip

Have been looking for a good guild management spreadsheet for awhile. I have a few ones I hacked together but nothing that is anywhere near as complex and complete yours appears to be. Would love to try it out. Seems like it would be a great and suitable fit

EU Dragon’s Call
Posts: 1
Likes: 0
5 months ago (1.13.4)
 •  Unread

Bkatt wrote:
5 months ago
Hello,

I stumbled upon this project a couple months back when I was deciding on forming my own guild.. Fast forward to today I am proud to say that I have started my own guild and currently have 80+ Lvl 60s. We are in the process of forming a second raid group and I desperately need a omegle tool that will help me keep the guild organized for loot, consumables and raid roster. How do I get my hands on this? I'm very interested to test it out and to see how it may benefit my guild.

<Novus Imperium>
Windseeker US
Bkatt - Human Mage
The problem in the name of loots, we vahe many times "Tier 1 - Hands" in the loot table, so the sheet can't decide wich one choose, i decided to add A B C on theses loot and so i can have a nice view of wich player looted for the last time in our raid

Paladin Holy
User avatar
EU Firemaw
Posts: 141
Likes: 112
Human
Paladin
4 months ago (1.13.4)
 •  Unread

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!

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


Vault of the Silverhands, A Gear Primer for Holy Paladins
A progressive and customisable item, enchant and buff overview for Holy Paladins

User avatar
EU Sulfuron
Posts: 1
Likes: 0
Undead
Rogue
4 months ago (1.13.4)
 •  Unread

Guild Name: <kzu>
Faction: Horde
Server: SULFURON
Major (Professional) Streamers in guild? N
Professional (Paid/Sponsored) guild? N
Can I publicly list you as sheet users? Y
Would you like me to inform you of future updates Y
Did you read and understand the limitations on sharing and usage?: Y

French GM for a French Guild^^ very interesting in using your spread !

User avatar
EU Amnennar
Posts: 1
Likes: 0
Dwarf
Priest
4 months ago (1.13.4)
 •  Unread

Xcellers wrote:
9 months ago
Early research into further inclusion of external tools has begun, starting with Warcraft Logs, word counter this is however borderline techno magic to me, so it is a slow process, that I am hoping for additional assistance in.
Yes, I look forward to improvement and support

Similar topics
to 'Mk. Ultra Guild Management Sheet'
Posts ViewsLast post

Latest Blue Posts

View all
  • Screenshot of the Month

    View gallery