My guild is using and loving Mk Ultra :)

One piece of feedback:

Xcellers wrote: ↑

5 years ago

Thanks for all the feedback, the exclusion of a number of niche class/spec combos is actually intentional as I provide more of a "baseline" version that is suitable for as many guilds as possible, so with stuff like this then it might take a bit of customisation to make it fit perfectly to individual guild needs. If there is enough requests for it, then I can naturally provide some guidelines on how to approach this.

I would love a quick guide on how to add a new class/spec combo, namely our guild has an Elemental Shaman that we'd love to stop putting under healers :)

Seriously awesome tool, it has helped us a lot.

KyleM_TV wrote: ↑

5 years ago

My guild is using and loving Mk Ultra :)

One piece of feedback:

Xcellers wrote: ↑

5 years ago

Thanks for all the feedback, the exclusion of a number of niche class/spec combos is actually intentional as I provide more of a "baseline" version that is suitable for as many guilds as possible, so with stuff like this then it might take a bit of customisation to make it fit perfectly to individual guild needs. If there is enough requests for it, then I can naturally provide some guidelines on how to approach this.

I would love a quick guide on how to add a new class/spec combo, namely our guild has an Elemental Shaman that we'd love to stop putting under healers :)

Seriously awesome tool, it has helped us a lot.

Yeah I will get to work on it ;)

Hi, I would really like to be able to copy the sheet for my Guild Crowned Eu Razorgore - It looks really cool, amazing work!
Here is some information:

Guild Name: Crowned

Faction: Horde

Major (Professional) Streamers in guild? nope

Professional (Paid/Sponsored) guild? nope

Can I publicly list you as sheet users? Sure

Would you like me to inform you of future updates Hel yeah!!

Contact Email (Google Docs/Drive connected): PM

Thank u so much!

Absolutely amazing spreadsheet.

Thank you so much @Xcellers

I have only one suggestion regarding the loot distribution. It would be a very good thing to have an overview sheet with all members listed as well as the loot they received and which date.

Something like this:




Once again, a huge thanks for the sheet which will be incredibly useful for a long time.

Hey,

We've been using the sheet for a few weeks and we find it very useful.

We added a few modifications beacause of your luck : we added rows for wrist/waist loots.

I don't know if it's possible, but we would find useful to have a "Loot review" tab ; a tab where we could select a player in the Roster and the function will search in the MC/BWL/etc.. tab to return the list of the loot/date per player. That will be easier to comprae 2-3 player tto know to who give a loot.

Great job for the Sheet !

Dumbel

Our guild has been using this for a couple of weeks now. Big sigh of relief not to having to rely on random personal sheets and scattered information anymore! All formulas are in a clear and understandable and makes it easy to make adjustments with little Sheets experience.

Thank you!

Fantomen wrote: ↑

5 years ago

Absolutely amazing spreadsheet.

Thank you so much @Xcellers

SpoilerShow

I have only one suggestion regarding the loot distribution. It would be a very good thing to have an overview sheet with all members listed as well as the loot they received and which date.

Something like this:




Once again, a huge thanks for the sheet which will be incredibly useful for a long time.

Dumbelmort wrote: ↑

5 years ago

Hey,

We've been using the sheet for a few weeks and we find it very useful.

SpoilerShow

We added a few modifications beacause of your luck : we added rows for wrist/waist loots.

I don't know if it's possible, but we would find useful to have a "Loot review" tab ; a tab where we could select a player in the Roster and the function will search in the MC/BWL/etc.. tab to return the list of the loot/date per player. That will be easier to comprae 2-3 player tto know to who give a loot.

Great job for the Sheet !

Dumbel

chumppi wrote: ↑

5 years ago

Our guild has been using this for a couple of weeks now. Big sigh of relief not to having to rely on random personal sheets and scattered information anymore! All formulas are in a clear and understandable and makes it easy to make adjustments with little Sheets experience.

Thank you!

Thank you for all the positive feedback guys, and for the suggestions - initially the idea sounds great, tho also rather complex, so its not something I will be able to fit into the next update (if its reasonably possible to include into the sheet naturally)

Cheers for the update :D

Loving the new compare sheet.

Sadly the attendance problem still persists and shows the wrong percentage value. My guildy had a look and found a band aid fix to the problem.

=IFERROR(G3/(countifs(Attendance!$3:$3,">="&Roster!T3) +1),0)

That SUM fixed our issue for everyone, apparently the original SUM was 1 value off for some reason, felt like a google docs bug - If the percentage is off (over 100%) it was an attendance or join date error then.

Before:


After:


Thanks again and keep up the great work.

Schmoopy wrote: ↑

5 years ago

Cheers for the update :D

Loving the new compare sheet.

Sadly the attendance problem still persists and shows the wrong percentage value. My guildy had a look and found a band aid fix to the problem.

=IFERROR(G3/(countifs(Attendance!$3:$3,">="&Roster!T3) +1),0)

That SUM fixed our issue for everyone, apparently the original SUM was 1 value off for some reason, felt like a google docs bug - If the percentage is off (over 100%) it was an attendance or join date error then.

Before:


After:


Thanks again and keep up the great work.

Hey man,

So I tried to replicating the error in the live sheets and in my test version, and the % values in attendance comes out perfectly so I really dont know what to say. What I can say is there has been a shitload of sheets related bugs during the development process with ghost values popping up left and right, so I am in no way doubting that you have this error - I just cant explain it :D

At current levels, the sheet is 50% coding, 40% techno magic and 10% wishful thinking

That being said, then I am closely watching all the feedback coming in, so if others have the same problem, then i will share your solution with them!

Xcellers wrote: ↑

5 years ago

Schmoopy wrote: ↑

5 years ago

Cheers for the update :D

Loving the new compare sheet.

Sadly the attendance problem still persists and shows the wrong percentage value. My guildy had a look and found a band aid fix to the problem.

=IFERROR(G3/(countifs(Attendance!$3:$3,">="&Roster!T3) +1),0)

That SUM fixed our issue for everyone, apparently the original SUM was 1 value off for some reason, felt like a google docs bug - If the percentage is off (over 100%) it was an attendance or join date error then.

Before:


After:


Thanks again and keep up the great work.

Hey man,

So I tried to replicating the error in the live sheets and in my test version, and the % values in attendance comes out perfectly so I really dont know what to say. What I can say is there has been a shitload of sheets related bugs during the development process with ghost values popping up left and right, so I am in no way doubting that you have this error - I just cant explain it :D

At current levels, the sheet is 50% coding, 40% techno magic and 10% wishful thinking

That being said, then I am closely watching all the feedback coming in, so if others have the same problem, then i will share your solution with them!

Hey,

So on the live sheet you linked to copy (sorry ahead of time for inputting the small amount of data that I did) - I added a few extra dates in "Attendance" since they were all the same date and changed the join date from 21st to 20th.

Tried to replicate the problem I had and got this:


Edit: Changing the join date from 20th -> 19th gave me this result:

So it seems that if you have the join date of the person the same as their first raid, it can throw off the total result by 1.

- This would also make sense why our guilds dates were off by 1 since we use the "join date" as a reference for when the member got promoted to trail. This is to to avoid socials who have been in the guild since creation, to end up having low attendance after their first raid.

Edit 2: Found a quick easy solution:

It seems to bypass the same date issue. (I left the SUM as it was originally on the spreadsheet)

I only adjusted the join dates and the dates on the attendance sheet - nothing that would affect anyone who would copy the sheet -

Hope it helps.

Ahh I guess that explains why I couldnt reproduce it - well great spotted, i made the adjustment to the other sheet and I will just write a small How-To notice on it, in-case others get the same error!

Thanks a bunch @Schmoopy

There might be a few, entirely in-explainable bugs going around with the new compare tool feature, if anyone runs into issues with users not having anything counted on their profiles, then lemme know so i can try to pinpoint the item issue in question!

Me and my guilde are using the Xcellers spreadsheet since 3 weeks and everything is working like it supposed to be! :)

Thank you for that awesome work!

This is just incredible!

The greatest boost for our Catalan guild. All our members are so happy and excited for this spreadsheet!
Using it right now. Many thanks for your great work and keep doing! Maybe a website on future? Could get famous!

Agatea wrote: ↑

5 years ago

This is just incredible!

The greatest boost for our Catalan guild. All our members are so happy and excited for this spreadsheet!
Using it right now. Many thanks for your great work and keep doing! Maybe a website on future? Could get famous!

Qhrynne wrote: ↑

5 years ago

Me and my guilde are using the Xcellers spreadsheet since 3 weeks and everything is working like it supposed to be! :)

Thank you for that awesome work!

Thanks guys, happy to hear that you and your respective gangs have been enjoying the sheet!

Just starting to use the spreadsheet now and it's an absolute life saver! So nice to see all the necessary info in one spot. It's easy to use too, thank you Xcellers!

Im playing wow in KOREA.
This Sheet is awesome!!
It became easy to manage for guild.
thanks for sharing sheet.
LOVE SO MUCH!!

Hello,

Is there a FAQ for this spreadsheet i have question and cant seem to find it anywhere on the barrens chat forums

LeStone21 wrote: ↑

5 years ago

Just starting to use the spreadsheet now and it's an absolute life saver! So nice to see all the necessary info in one spot. It's easy to use too, thank you Xcellers!

gigatesju wrote: ↑

5 years ago

Im playing wow in KOREA.
This Sheet is awesome!!
It became easy to manage for guild.
thanks for sharing sheet.
LOVE SO MUCH!!

Hey guys,

Really happy to hear that you guys are liking the sheet! its an absolute pleasure!

gh3tto wrote: ↑

5 years ago

Hello,

Is there a FAQ for this spreadsheet i have question and cant seem to find it anywhere on the barrens chat forums

Hey man,

Well the main post has a lot of info on its own, but of particular note is:

The Basics guide: viewtopic.php?f=3&t=2374#section2
contains a basic run-down of how to use it

The How-To section: viewtopic.php?f=3&t=2374#section6
contains specific guides for making adjustments to the sheet

If its not covered anywhere there, then you can just reach out to me and ill do my best to help out!

Awesome spread sheet, more than a guild could ask for esp for free.

We are just getting our raiding numbers and this is going to be critical to making sure we fill out with what we need for the last slots and to keep track of quite literally everything you could think of!

15/10

Would recommend.

Brickwallbob wrote: ↑

5 years ago

Awesome spread sheet, more than a guild could ask for esp for free.

We are just getting our raiding numbers and this is going to be critical to making sure we fill out with what we need for the last slots and to keep track of quite literally everything you could think of!

15/10

Would recommend.

Happy to hear that you guys like it; the 15/10 score is actually what I am for!