Forums

Clan Google Doc Excel Help

Quick find code: 135-136-900-66014248

Soffles
May Member 2014

Soffles

Posts: 177 Iron Posts by user Forum Profile RuneMetrics Profile
Hey,

We're in the process of creating a rank system based on points acquired. These points will be acquired by attending events, recruiting, capping and clan XP. So far we've managed to link runeclan, so our document tracks clan XP gained. The rest we're struggling to automate and struggle with commands. Any help would be greatly appreciated.

Please guest in 'Immolate' if you're willing to help & I'll add you!

:)
~
Immolate
PvM Clan ~

23-May-2018 21:52:02

II XP II
Jun Member 2011

II XP II

Posts: 1,038 Mithril Posts by user Forum Profile RuneMetrics Profile
Hi Soffles, To be honest Excel isn't really a good tool to use for this.
Google sheets are much better and work automatically, I have many pre made google sheets for players and clans to use. They are free to any one, and many clans use the points sheet you talk about.
My thread QFC : 135-136-898-65701593
(Also a link in my footer)

I can't post links to my demo's on this forum unfortunately, so I direct you to our clan offsite or my google " runescapeassistsheets" web site.
All my sheets start with " Runescape demo of" so google is usefull too.
So "Runescape demo of clan ranks by points PLUS (With Script)" you might find useful.

You could also try the Discord bots that some players are using, but I'm not a fan of the discord site myself. It expects too much private data, but many seem to like that just fine.

Best regards :P

Oh ps, Runeclan expects payment for downloads off his website, all my sheets only use the RS API
Serenity Isle Clan. - - -
Google assist sheets link here

24-May-2018 08:20:03 - Last edited on 24-May-2018 08:22:24 by II XP II

Macka
Oct Member 2010

Macka

Posts: 4,318 Adamant Posts by user Forum Profile RuneMetrics Profile
The Clan Discord Bot can output the data you need into a spreadsheet and you can ask the Discord members to help you with organising it as well - Highly recommend using the bot.

I'll bump it up for everyone
My physique is a product of my mindset

Macka#7877
-
Taiwanese Aussie Physique Bodybuilder

28-May-2018 06:46:56

Soffles
May Member 2014

Soffles

Posts: 177 Iron Posts by user Forum Profile RuneMetrics Profile
Thanks guys! Fortunately some excel whizzes were in the clan and I had no idea... so we got everything automated using google docs!

:)
~
Immolate
PvM Clan ~

11-Jun-2018 14:32:44 - Last edited on 11-Jun-2018 14:35:08 by Soffles

Quick find code: 135-136-900-66014248 Back to Top