Forums

Clan google assist sheets

Quick find code: 135-136-898-65701593

of 9
Miradelle
Apr Gold Premier Club Member 2016

Miradelle

Posts: 34Bronze Posts by user Forum Profile RuneMetrics Profile
Hi there!! First, I want to thank you for having such amazing sheets available for us to use. However, I am having an issue with our clan capping tracker. when I ran it the 1st time, it showed everyone who had visited and/or capped without any trouble. As of yesterday, 3 of our members are not showing up as having visited OR capped. Their XP will update just fine, but no capping info. These people were previously shown as having capped/visited so why its not showing now is a mystery.

Also, none of these players have their profiles hidden (I even asked to be sure,) so I dont see a reason why only a couple of people aren't working when they were previously. I also started from scratch and made a new copy of the sheet just in case I messed up something, but still the same result with the same people.

What am I doing wrong to cause this? I am not doing anything fancy with the scripts because it's not something I am terribly great at so I dont want to mess around with what's already plugged in. Thank you in advance for any help you can offer!
Proud member of The Drifters...and also slightly insane. Only slightly...

**also a certifiable dork, mom, and music lover** =p

06-Aug-2018 00:32:53

II XP II
Jun Gold Premier Club Member 2011

II XP II

Posts: 1,016Mithril Posts by user Forum Profile RuneMetrics Profile
Hi Miradelle,
I can't be absolutley sure without seeing the sheets and players data.
But I think it must be that the capping data has been written over in their adventure log.
If the players boss a lot or perform skills or quests that report to the adventure log, then the data could have been over written. The Adventure log only holds 20 statements, which automatically get over written with each new item logged.
It could also be a players adv log setting turned off reporting such items.
If you can look at the affected players adventure logs via runemetrics, that might shed more light upon the problem.
This is why some clans set up the sheets to auto collect the data each day, but it isnt perfect. Unfortunately we are only scrapping data from a constantly changing data stream.
I don't think you are doing anything wrong, and is why the data collection sheet stores each set of data seperately on the "Query capped data" tab, with the date.
That is where the query 'start and end' sort date is usefull, to pick out all those capped over the week.
Hope this helps you understand more about how this sheet works.
:)
Serenity Isle Clan. - - -
Google assist sheets link here

07-Aug-2018 08:36:55

Miradelle
Apr Gold Premier Club Member 2016

Miradelle

Posts: 34Bronze Posts by user Forum Profile RuneMetrics Profile
Thanks a bunch! That does help, and it has been working a lot better. Much appreciated for the reply!
Proud member of The Drifters...and also slightly insane. Only slightly...

**also a certifiable dork, mom, and music lover** =p

11-Aug-2018 21:11:52

Robb Stark
Aug Gold Premier Club Member 2011

Robb Stark

Posts: 546Steel Posts by user Forum Profile RuneMetrics Profile
Is there a spreadsheet that counts the total amount of times a clan member has capped at the citadel since the date they have joined? This would be really helpful as my clan goes by a task based rank system.

Thanks :)
"Join us in protecting our home, for winter is coming."

The Young Wolf
| King of:
Winterfell

27-Jan-2019 15:04:27

II XP II
Jun Gold Premier Club Member 2011

II XP II

Posts: 1,016Mithril Posts by user Forum Profile RuneMetrics Profile
Hi Robb Stark,
There are two sheets clans tend to use for citadel and points awarded. They can be found on my google site, where you can make yourself a copy if you want them as a starter sheet or to use as it is. I would post links, but this forum forbids external links.

Search "
runescapeassistsheets
" or and "
/runescape-clan-assist-sheets
"

"
Runescape demo of Citadel Capping scanner and tracker
" with a yearly manual event tracker.
and
"
Runescape demo of clan ranks by points PLUS
"

You may find something useful there, and each sheet has instructions to get you going.
It also outlines why the citadel capping data is not that easy to gather automatically or from those with accounts set to private.


Best of luck
;)
Oh bye the way - discord bots may have something, I know they have a thread here too. But I won't touch that site myself, but you might find it more helpful?
Quick find code: 135-136-101-65981898
Serenity Isle Clan. - - -
Google assist sheets link here

28-Jan-2019 14:00:11 - Last edited on 28-Jan-2019 15:16:15 by II XP II

Quick find code: 135-136-898-65701593Back to Top