Mk. Ultra Guild Man...
 
Notifications
Clear all

Mk. Ultra Guild Management Sheet

Page 7 / 8

Xcellers
Posts: 141
Topic starter
(@xcellers)
Estimable Member
Joined: 2 years ago

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

Reply
Dumbelmort
Posts: 2
(@dumbelmort)
New Member
Joined: 1 year ago

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

Dumbelmort

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

Reply
Razfaz
Posts: 1
(@razfaz)
New Member
Joined: 9 months ago

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

Reply
Bkatt
Posts: 1
(@bkatt)
New Member
Joined: 9 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 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

Reply
Xcellers
Posts: 141
Topic starter
(@xcellers)
Estimable Member
Joined: 2 years ago

Bkatt you guys should be all sorted Wink

Reply
ramboozer
Posts: 1
(@ramboozer)
New Member
Joined: 9 months ago

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

Reply
calcify
Posts: 1
(@calcify)
New Member
Joined: 8 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

Mod note: Removed spam link

Reply
Xcellers
Posts: 141
Topic starter
(@xcellers)
Estimable Member
Joined: 2 years ago

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!

Reply
valdo
Posts: 1
(@valdo)
New Member
Joined: 8 months ago

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 !

Reply
1 Reply
heras
(@heras)
Joined: 2 months ago

New Member
Posts: 3

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

 

Reply
chinachin
Posts: 1
(@chinachin)
New Member
Joined: 8 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

Reply
Vexer
Posts: 2
(@vexer)
New Member
Joined: 1 year ago

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!

Reply
Cassanova3737
Posts: 1
(@cassanova3737)
New Member
Joined: 2 months ago

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

Reply
heras
Posts: 3
(@heras)
New Member
Joined: 2 months ago

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):[email protected]

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

Reply
Nihla
Posts: 2
(@nihla)
New Member
Joined: 1 month ago

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.

Reply
Oczaki
Posts: 3
(@oczaki)
New Member
Joined: 1 month ago

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!

Reply
Page 7 / 8
Scroll to Top