Forums

Clan Cup 2016 Planning

Quick find code: 86-87-873-65810396

Hopalong
Mar Member 2011

Hopalong

Posts: 1,480 Mithril Posts by user Forum Profile RuneMetrics Profile
Screenshots are unreliable, and not usually displayed in a plain text format. With screenshots you can't simply hit control-F and find the username you're looking up (if you were checking the other team let's say). Additionally, having to open up 100000 links and hoping to find the right one with the right people in it is not preferable. I like having everything in one space, and screenshots cannot do this in a way I'm satisfied with. For example, I could screenshot everybody's name on my clan list, but that would take quite a few screenshots, and if not might be unreadable, whereas I could do a similar thing in Google Docs and import & manually archive each clan, while retaining the ability to search for names, which makes the user experience like 100x better and easier. Here's a sample one for my clan:
https://docs.google.com/spreadsheets/d/1eAmi8YHEjERaLDWTJgktGDjs-i5yKZGMcwyrLOdl-bU/edit?usp=sharing
(the importhtml's may not be fully loaded yet but they should eventually load). Something like this is vastly better than just screenshots.
Leader of the Slayer Nest . Join us today!

04-Aug-2016 22:31:16

Calm Enigma

Calm Enigma

Forum Moderator Posts: 10,882 Opal Posts by user Forum Profile RuneMetrics Profile
@Hop

That looks good but isn't there a limit on the amount on importhtml's you can use in a single google doc? Iirc it's ~5

Perhaps it would just be easier to make a self-updating excel doc (not online) and post a copy of it week it each week for public view? We could give out a copy of the doc to various organisers as well for back-up and checking reasons. This may also be easier than a google doc for drawing skilling cup data too perhaps?
-
C.E.

Clam Enigma's evil twin | Council of the RS
W
arring League

-•¤{
Wicked
Fury
}¤•-

08-Aug-2016 06:20:54

Hopalong
Mar Member 2011

Hopalong

Posts: 1,480 Mithril Posts by user Forum Profile RuneMetrics Profile
Calm Enigma said :
@Hop

That looks good but isn't there a limit on the amount on importhtml's you can use in a single google doc? Iirc it's ~5

They removed that limitation a while ago, I think on one of my larger docs I've got somewhere around 30 running. To get around it last time we just split it over different documents and it went fine from what I know. I believe there is some limit but this shouldn't be a huge problem to get around.
Calm Enigma said :
Perhaps it would just be easier to make a self-updating excel doc (not online) and post a copy of it week it each week for public view?

Self updating one clan (something I have to do monthly due to various reasons) sucks. Self updating 40 clans would be an absolute nightmare. I don't see this being feasible and any time we can cut out from that (this would be super resource intensive) the more we can spend elsewhere. I also don't really see an advantage to going offline as opposed to online, seems kinda weird to me. Like I've mentioned above, it'll take all of ~2-3 minutes per clan to update their member lists and archive them. Doing this manually can take a painstakingly long time (probably about 30 mins-1 hour per clan) and is prone to errors or fraud. So yea, I don't see that being the way to go.
As far as Skilling Cup data goes, I honestly don't know, I'll do some research and let you know what I think.
Leader of the Slayer Nest . Join us today!

09-Aug-2016 09:05:41 - Last edited on 09-Aug-2016 09:08:30 by Hopalong

Jamo
Jul Member 2011

Jamo

Posts: 445 Silver Posts by user Forum Profile RuneMetrics Profile
Apologies for my lack of replies, been a bit busy and this hasn't been on my mind, but I'm back now! :)

Ceecs said :
U can easily pull the member list from the clan page or check Runeclan when people are joined in that clan or left it. Just someone has to check this when they argue about rules and post their particiapants for wars against other clans.

Calm Enigma said :
@Ceecs - you can do that for the current memberlist, but to check for multiclanning and mass recruiting you also need past memberlists =\ As in the past, we'd have to require clans post a ml every week, or post them ourselves on a google doc as Hop suggests. Hopefully a techie will be able automatically pull all the lists we need every week


Not sure if you've come to an agreement with using a google doc, but you can make competitions on Runeclan, and they (clan leaders), can manually add each player taking part. This also keeps track of members who have left and can't add members to it after it starts, it would also make it easier to follow any name changes, however seems as it's mostly going to be a player-run cup this year, I don't have anything against not allowing name changes. If making the competitions on Runeclan is an entry requirement for each clan that may help a bit?
Trimmed Completionist
Owner of 'Renown'
@RSJamo

09-Aug-2016 12:21:40 - Last edited on 09-Aug-2016 12:23:11 by Jamo

Ceecs
Mar Member 2010

Ceecs

Posts: 16,166 Opal Posts by user Forum Profile RuneMetrics Profile
Jamo said :
Not sure if you've come to an agreement with using a google doc, but you can make competitions on Runeclan, and they (clan leaders), can manually add each player taking part. This also keeps track of members who have left and can't add members to it after it starts, it would also make it easier to follow any name changes, however seems as it's mostly going to be a player-run cup this year, I don't have anything against not allowing name changes. If making the competitions on Runeclan is an entry requirement for each clan that may help a bit?


Might be a good idea if there nog bugs with that.
Ceecs - leader of Ceecs Clan
Rank in Star Find, Harmed Ore, Beach FC | Ex-Rank in Fast SC

Ceecs Clan: DUTCH ONLY RS3 clan & Winner of the Iron Skilled Cup 2015!

09-Aug-2016 12:52:34

Calm Enigma

Calm Enigma

Forum Moderator Posts: 10,882 Opal Posts by user Forum Profile RuneMetrics Profile
Last I checked runeclan didn't pick up brand new f2p ironmen accounts. Worth checking again though because it would be the easiest option

Edit: Checked out Runeclan and it seems you can only create competitions for members of a specific clan. Runetrack is probably a better option as it allows you to create competitions composed of any players.


@Hop - so you're saying that automising memberlist archiving isn't feasible but that doing it manually takes too long? What's the remaining option? Feels like we've misunderstood each other somewhere :P
-
C.E.

Clam Enigma's evil twin | Council of the RS
W
arring League

-•¤{
Wicked
Fury
}¤•-

09-Aug-2016 14:54:26 - Last edited on 09-Aug-2016 18:05:40 by Calm Enigma

Calm Enigma

Calm Enigma

Forum Moderator Posts: 10,882 Opal Posts by user Forum Profile RuneMetrics Profile
Also we could just make multi clanning and mass recruiting rules such that we only need the memberlist a for each clan when they sign up to the Cup and at the time when a dispute regarding those two rules is lodged. Would be easiest since we'd have to do basically no archiving and it could even be done manually in little time.

E.g.
Mass recruiting = no more than 25% of participants in a war may have been recruited outside of the initial memberlists

Multi clanning = players are registered to the clans on whose memberlist they can be found when that clan signs up to the Cup. Clans may not field players that were initially registered with another participating clan
-
C.E.

Clam Enigma's evil twin | Council of the RS
W
arring League

-•¤{
Wicked
Fury
}¤•-

09-Aug-2016 15:00:20 - Last edited on 09-Aug-2016 15:00:40 by Calm Enigma

Calm Enigma

Calm Enigma

Forum Moderator Posts: 10,882 Opal Posts by user Forum Profile RuneMetrics Profile
Regarding the skilling cup, there may be no need to track that either tbh. The important thing is that participants don't play over the 6 hour limit, which necessarily needs to be checked by a JMod. Other than that we just need to know the xp of each participant at the deadline for the week, which can be inputted manually easily (unless making a function that draws hiscore values for a certain player name is doable, in which case that's obviously better).

TLDR: both memberlist rules (multiclanning and mass recruiting) and the skilling cup can be effectively dealt with without any particular tech knowledge if we are in a position where noone is able to make us handy sheets
-
C.E.

Clam Enigma's evil twin | Council of the RS
W
arring League

-•¤{
Wicked
Fury
}¤•-

09-Aug-2016 20:40:36

Quick find code: 86-87-873-65810396 Back to Top