New milestone; guild no. 1300 just adopted the Mk. Ultra for their guild management!
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:
This sheet literally helps every classic guild. Thank you for your time and work. We really appreciate it!
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
Bkatt you guys should be all sorted :wink:
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
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
Mod note: Removed spam link
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!
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 !
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
I had a question, to see if this is possible. For the attendance tab which keeps the percentage of attendance. I've had questions from my guildies to see if it's possible to only show the past 90 days or so of attendance. So instead of the percentage coming from our very first raid, until current day, is there a script/formula to only have it show the past 90 days of attendance?
Just curious if this is possible or has been suggested before. Thank you for all the hard work you put into the sheet, it has helped me and my guild immensely!
Hey, any ideas how to get this sheet for my guild?
Guild Name: Elysium
Faction: Horde
Server: Patchwerk-EU
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
Contact Email (Google Docs/Drive connected):herasgamer@web.de
Did you read and understand the limitations on sharing and usage?: Y
That's a damn sexy sheet you built there Ultra. Do you plan to bring it to TBC ? Looking for a usefull out of game system for my guild.