Forums
Clan google assist sheets
Quick find code: 135-136-898-65701593
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.
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
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
Thanks
"The North Remembers."
The Young Wolf
|
Founder of:
Winterfell
27-Jan-2019 15:04:27
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 "
"
and
"
You may find something useful there, and each sheet has instructions to get you going.
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
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
Hey,
I tried to use the point spreadsheet, filled in the clan name but somehow I'm not able to get it to work. Help?
I tried to use the point spreadsheet, filled in the clan name but somehow I'm not able to get it to work. Help?
I don't have a signature, but wanted to have some content here.
23-Apr-2019 12:39:46
Hi vlumondoxa, Sorry for the late reply. I have been very busy with real life lately.
However, I did look at your question and I found out the problem.
Immortilized Wolves is actually spelt with an "L" and not an "I".
I tried this on a copy of the clan points plus sheet, and it worked fine with "Lmmortalized Wolves" (all lowercase)
Later when I checked again the L was an "i" : I think this might be a missmatch of character sets between the websites?
I have a copy that works anyway, I could email it to you if needed.
Hope this helps
However, I did look at your question and I found out the problem.
Immortilized Wolves is actually spelt with an "L" and not an "I".
I tried this on a copy of the clan points plus sheet, and it worked fine with "Lmmortalized Wolves" (all lowercase)
Later when I checked again the L was an "i" : I think this might be a missmatch of character sets between the websites?
I have a copy that works anyway, I could email it to you if needed.
Hope this helps
Serenity Isle Clan. - - -
Google assist sheets link here
16-May-2019 19:18:11 - Last edited on 16-May-2019 19:41:55 by II XP II
Hi Enigmatology, I'm not sure which sheet you are referring to, but its probably
"
Which would be difficult to achieve because of the constant name changes, bans and joining and leaving. And that sheet is auto, and could not perform these random acts with out massive errors.
The only sheet that does do this from memory is the
"
Which relies on manual user interaction on the
You could add an extra sheet to your copy, and add those in or better still copy the points sheet and just use it for the days in the clan if you have an admin in your clan to keep it up to date I guess?
However, I will give it some thoughts over the next few days, a light bulb may light up?!
Could you confirm which sheet you are referring too.
"
Runescape demo of clan ranks by xp
"
Which would be difficult to achieve because of the constant name changes, bans and joining and leaving. And that sheet is auto, and could not perform these random acts with out massive errors.
The only sheet that does do this from memory is the
"
Runescape demo of clan ranks by points PLUS
"
Which relies on manual user interaction on the
Added points
TAB.
You could add an extra sheet to your copy, and add those in or better still copy the points sheet and just use it for the days in the clan if you have an admin in your clan to keep it up to date I guess?
However, I will give it some thoughts over the next few days, a light bulb may light up?!
Could you confirm which sheet you are referring too.
Serenity Isle Clan. - - -
Google assist sheets link here
04-Jun-2019 17:34:21
Hey im looking for a custom ranking sheet foy my clan. Im willing to pay for it. Dm me ingame or message me on discord Sashank#2389. Thank you!
Sashank
The Goblin Slayer
07-Jun-2019 14:55:34
Quick find code: 135-136-898-65701593 Back to Top