Mk. Ultra Guild Man...
 
Notifications
Clear all

Mk. Ultra Guild Management Sheet

Page 7 / 8
Xcellers
(@xcellers)
Estimable Member

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

ReplyQuote
Topic starter Posted : 24/05/2020 1:32 am
Dumbelmort
(@dumbelmort)
New Member

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$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 Smile
Hope this help someone ^^

Dumbelmort

PS: sorry if my english is not perfect

ReplyQuote
Posted : 26/05/2020 5:37 am
Razfaz
(@razfaz)
New Member

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

ReplyQuote
Posted : 02/06/2020 8:59 am
Bkatt
(@bkatt)
New Member

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

ReplyQuote
Posted : 09/06/2020 6:31 pm
Xcellers
(@xcellers)
Estimable Member

Bkatt you guys should be all sorted Wink

ReplyQuote
Topic starter Posted : 12/06/2020 1:15 am
ramboozer
(@ramboozer)
New Member

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

ReplyQuote
Posted : 12/06/2020 1:44 pm
calcify
(@calcify)
New Member

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

ReplyQuote
Posted : 27/06/2020 9:31 pm
Xcellers
(@xcellers)
Estimable Member

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!

ReplyQuote
Topic starter Posted : 10/07/2020 11:26 am
valdo
(@valdo)
New Member

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 !

ReplyQuote
Posted : 13/07/2020 2:46 am
chinachin
(@chinachin)
New Member

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

ReplyQuote
Posted : 13/07/2020 8:25 pm
Vexer
(@vexer)
New Member

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!

ReplyQuote
Posted : 15/07/2020 6:12 pm
Cassanova3737
(@cassanova3737)
New Member

Hey, any ideas how to get this sheet for my guild?

ReplyQuote
Posted : 10/01/2021 1:09 am
heras
(@heras)
New Member

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

ReplyQuote
Posted : 12/01/2021 12:19 pm
heras
(@heras)
New Member

@valdo did you get the Sheet? can you share it with me? Greetings

 

ReplyQuote
Posted : 13/01/2021 7:16 am
Nihla
(@nihla)
New Member

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.

ReplyQuote
Posted : 18/01/2021 2:57 pm
Page 7 / 8
Scroll to Top