Talk:Clan Home

Clan Mate List
I keep a very detailed list of my clan mates using data from the clan mate list provided us in the Clan Home Page.

I have a couple issues at the moment, and any clear help is greatly appreciated.

Firstly, I like to keep my spreadsheet of clanmates in the same order as they appear on the one provided us by Jagex for ease of comparison. Why does the one they provide keep switching the order when people are not name changing, leaving clan (losing a clanmate) or entering clan (gaining a clanmate)? I can't for the life of me see a pattern why names are switching around. When it first came out, it showed us in descending rank, and those of the same rank showed the ones who were newest to clan last. It was perfect. Now it still shows us in descending rank, but those of the same rank seem to be randomly chosen to display before others. I haven't seen an alphabetical sorting used, nor is it sorting by kills or xp. I'm stumped. To be honest, if Jagex could just return the list to always show same ranks with newest clanmates last, this issue for me is solved.

Secondly and most importantly, my clan does not remain friends with anyone who's been caught botting. Anybody who has had their xp rolled back for botting and I've seen and captured the proof in screenshots gets perm banned from the clan. The issue here is going through each clanmates' xp on a daily basis. It is getting very annoying, especially with the constant re-ordering of the list. Is there a way to grab the raw data and have it automatically input to the correct cell in my excel spreadsheet so that the spreadsheet flags those who have been caught for botting? The only question I have of this is how to deal with name changers, but I'm ok manually changing the formula to the new name. I do know of the raw data that is accessible for grabbing players' total xp from the hiscores table. On the other hand, I do not know how to put only their total xp into the specific cell into the spreadsheet on a one time daily schedule where any xp losses are flagged. I do this all 1 by 1 at the moment and it's getting on my nerves.

If you are able to help and love a challenge for problem solving, I'd be thrilled to work with you. I can login to this with a name if necessary and even use skype to confer on how to handle this task.

If I'm wrong for asking this here, please let me know and I'll delete the page myself. I just didn't know where else to ask for help. And if any of my plight can be used to enhance the wiki, I'm all for being the guinea pig.

Thank you.