Forums

Clan google assist sheets

Quick find code: 135-136-898-65701593

Silently
Aug Member 2014

Silently

Posts: 186 Iron Posts by user Forum Profile RuneMetrics Profile
Greetings and my first words to you are, very nice!

I am particularly loving the Clan rank/name change sheets! (:
I knew it'd be a messy task and hours of fiddling, so I took to tutorials within the first 30 minutes.
I couldn't quite get the import data function to work correctly for what I wanted it to import, but studying your sheet I can see now it uses a different link I wasn't able to come across nor did I understand how it'd paste the data in from seeing quick tips on table/list importing.

I'm now just using your two sheets instead with change of colouring to match themes and as well as giving you credit on it of course, if our new clan ever grows for others to make use of it!

Thank you very much for providing these, they're really great tools for people to learn as well!

Kind regards,
Silently
Stay Strong. Stay Silent .

11-Jan-2016 14:02:17 - Last edited on 11-Jan-2016 14:03:49 by Silently

II XP II
Jun Member 2011

II XP II

Posts: 1,038 Mithril Posts by user Forum Profile RuneMetrics Profile
Thank you Silently for taking the time to send me feedback, its always useful to know which sheets to adapt and work on further. Good luck with you're clan in 2016.
:)

Edit : I have updated both of those sheets by the way, I often update things depending on players requests, so checking the revision numbers from time to time is a good idea.
Serenity Isle Clan. - - -
Google assist sheets link here

11-Jan-2016 15:50:14 - Last edited on 12-Jan-2016 12:39:20 by II XP II

Silently
Aug Member 2014

Silently

Posts: 186 Iron Posts by user Forum Profile RuneMetrics Profile
II XP II said :

Edit : I have updated both of those sheets by the way, I often update things depending on players requests, so checking the revision numbers from time to time is a good idea.


I'll keep that in mind and I'll be sure to take a sticky beak now and then.

Though I've been making adjustments after going through it all and understanding how it simply compares the two information blocks/values just on the basis of how your pasted data is the history. All while still giving you credit on each of the pages of course for it! (:
The summary sheet is interesting, I like the query function, that's very useful! :)
Silently
Stay Strong. Stay Silent .

13-Jan-2016 03:55:45

MissyPT
Jun Member 2013

MissyPT

Posts: 9,810 Rune Posts by user Forum Profile RuneMetrics Profile
Hi II XP II, my spreadsheet is bugging atm and I don't really know how to fix it, are you familiar with the programming that makes the spreadsheets update from the RS website? Was wondering if you could help me.
MissyPT

~~ Keep your face always toward the sunshine - and shadows will fall behind you ~~
ø
The Cookie Armada Clan
ø

02-Feb-2016 14:12:12

II XP II
Jun Member 2011

II XP II

Posts: 1,038 Mithril Posts by user Forum Profile RuneMetrics Profile
@ Mariana D
Hi, I know we had quite a long chat, and I suggested you tried a different route maybe? One without scripts.
But I did take another look at your sheets, and I think I found a fix, but not knowing the full workings of what it was doing before. I'm not totally sure if its 100% now.
Take a look and let me know, I emailed you a link to a copied sheet.
:)
Serenity Isle Clan. - - -
Google assist sheets link here

02-Feb-2016 20:55:38

Xavier
Apr Member 2020

Xavier

Posts: 1,405 Mithril Posts by user Forum Profile RuneMetrics Profile
Hi Mariana

What exactly is your issue with your google sheet?

Have you gone to the productforums and reach out to the Googlers there?

I do play from time to time you can pm me ingame if you need assistance with the bugged sheet.
Google Drive & Docs L1 | Traveler |Scaper by night :)

07-Feb-2016 22:19:04 - Last edited on 07-Feb-2016 22:22:05 by Xavier

Noetica
Jul Member 2010

Noetica

Posts: 1,559 Mithril Posts by user Forum Profile RuneMetrics Profile
Hi I have been using google spreadsheets for clan tracking since mid-2012, but last few days I can't get my spreadsheets to respond at all. I use a "Clan Log" that was originally posted in CLF, and it is still automatically updating daily but it just does not respond to any commands. Often when opened they just show the "Working..." for hours. Is anyone else having problems like this? Opening some of the spreadsheets from those done by II XP II does the same thing, nothing happens when I attempt to click on File to make a copy. Should I go to google for help?
~•••~ | Leader of
The Rune Lounge
| ~•••~

13 yrs playing, 13 yrs leading clans

~•••~ | Applying Buddhist ideals to the game, Namaste | ~•••~

17-Apr-2016 07:21:55

II XP II
Jun Member 2011

II XP II

Posts: 1,038 Mithril Posts by user Forum Profile RuneMetrics Profile
Hi Noetika,
I have not seen this problem recently, there was a problem some months ago with some import comands but thats been fixed. I tried several of my demo sheets and they all updated ok with no stuck "working" message. I have seen the "Fonts failed to load" message recently though, so something may have changed. I would suggest that its something changed or new on your pc that is causing this problem. If you use chrome, trying incognito mode may prove this, or temperaly turn off antivirus and or fire wall, just to see if its those stopping the download to happen. PUPS from anti virus programs have caused this in the past, even though not technically a virus, they do take control and other programs will not interact with such malware. If not tried yet run a malware scan, such as malwarebytes (free). Let us know how your getting on. I understand how frustrating these things can get.
Serenity Isle Clan. - - -
Google assist sheets link here

18-Apr-2016 10:08:46 - Last edited on 18-Apr-2016 10:17:13 by II XP II

Xavier
Apr Member 2020

Xavier

Posts: 1,405 Mithril Posts by user Forum Profile RuneMetrics Profile
Noetica said :
Hi I have been using google spreadsheets for clan tracking since mid-2012, but last few days I can't get my spreadsheets to respond at all. I use a "Clan Log" that was originally posted in CLF, and it is still automatically updating daily but it just does not respond to any commands. Often when opened they just show the "Working..." for hours. Is anyone else having problems like this? Opening some of the spreadsheets from those done by II XP II does the same thing, nothing happens when I attempt to click on File to make a copy. Should I go to google for help?


Hi Noetika.

There are many reasons this could be happening. You would be using =Importdata() am i right? There has been a global issue with the imports recently, Talk to me ingame and I'll see what I can do for your Google spreadsheet. If it's a bug, I'll report it to the engineers. Usually reports get sent to us directly, or via Google productforums. I'll lobby for the next 5-7 hours, pm me when you can
Google Drive & Docs L1 | Traveler |Scaper by night :)

30-Apr-2016 05:42:14 - Last edited on 30-Apr-2016 05:49:54 by Xavier

NG O

NG O

Posts: 13,930 Opal Posts by user Forum Profile RuneMetrics Profile
Xavier said :
Noetica said :
Hi I have been using google spreadsheets for clan tracking since mid-2012, but last few days I can't get my spreadsheets to respond at all. I use a "Clan Log" that was originally posted in CLF, and it is still automatically updating daily but it just does not respond to any commands. Often when opened they just show the "Working..." for hours. Is anyone else having problems like this? Opening some of the spreadsheets from those done by II XP II does the same thing, nothing happens when I attempt to click on File to make a copy. Should I go to google for help?


Hi Noetika.

There are many reasons this could be happening. You would be using =Importdata() am i right? There has been a global issue with the imports recently, Talk to me ingame and I'll see what I can do for your Google spreadsheet. If it's a bug, I'll report it to the engineers. Usually reports get sent to us directly, or via Google productforums. I'll lobby for the next 5-7 hours, pm me when you can
if you have time please add me in-game T_T

01-May-2016 06:10:40

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