Forums

Due to the failure of the import functions and the dreaded #N/A results over many months now. I have reluctantly moved over to using scripts to perform the download.
Its not as straight forward, but there is a beta version and an instruction sheet on the serenityisleclan off site forum in the help/advice section.
Give me your feedback.

You will need to activate the script and allow it to operate.
Plus set up an auto update trigger and allow that also.
There are instructions on each sheet.

Serenity Isle Clan. - - -

Google assist sheets link here

13-Jan-2017 18:48:48 - Last edited on 18-Jan-2017 13:31:23 by II XP II

Nice use of scripts!

I noticed you used the =substitute() formula. to remove the question mark

you could erase the use of this by using a find and a replace script:

function fandr() {
var r=SpreadsheetApp.getActiveSheet().getDataRange();
var rws=r.getNumRows();
var cls=r.getNumColumns();
var i,j,a,find,repl;
find="add the unicodequestion mark here";
repl=" ";
for (i=1;i<=rws;i++) {
for (j=1;j<=cls;j++) {
a=r.getCell(i, j).getValue();
if (r.getCell(i,j).getFormula()) {continue;}
try {
a=a.replace(find,repl);
r.getCell(i, j).setValue(a);
}
catch (err) {continue;}
}
}
}

It's not needed but it can help de-clutter. Google Drive & Docs L1 | Traveler |Scaper by night

31-Jan-2017 07:09:44 - Last edited on 03-Feb-2017 01:30:02 by Xavier

Thanks Xavier, I will take a closer look when I have more time.

Serenity Isle Clan. - - -

Google assist sheets link here

31-Jan-2017 09:07:48

Profiled .

~Australian

~Max Total OSRS

01-Mar-2017 10:14:56

OKay so posting here in more detail for you. I am trying to use the sheet you have to track clan rank changes. I was wondering if it were possible to add another page to it that will alllow me to see all members of my clan and have a column with a formula that will allow me to manually input a value every time a member caps and after so many inputs will red flag with a message such as due for rank up or something like that. So that after input of several members i can go back thru and rank up the red flagged members. Also maybe adding a code to show that they are due for a rank after x amount of caps if the rank up is say every two weeks. so after rank up, they cap the first week say rank up due in two weeks, cap again, rank up due in 1 week, cap again, rank up due now. something like that. shoot me a pm if needed with any other input. I feel this would get used alot if done correct, and you seem to be the one who could do it.

13-Mar-2017 12:13:34

Hi B-Mills,
Thanks for taking the time to explain what you wanted.
I have added an events page to that sheet "Clan rank / name changes".

Take a look and see if it comes anything close to what you needed.
Regards II XP II

Serenity Isle Clan. - - -

Google assist sheets link here

13-Mar-2017 17:03:13

Thanks mate. just pulled it up. looks great. I think this will work for my needs. and based on looks im sure alot of people can use it. You're amazing my friend. Ill report any feedback as i use it over these next few days

13-Mar-2017 20:34:58

24-Mar-2017 05:34:05 - Last edited on 24-Mar-2017 06:04:36 by Roshi

Hi Xi, The "Runescape demo of clan PLUS" sheet virtual level table is on the "Summary" tab.
Columns SJ - SN (row 111 - 262).

There are two tables though, one for the standard skills, and one for the invention skill with a different xp curve. So you may wish to take note of that before removing anything.

You could just change the 121 thru 127, all to read 120 this would be the better way I think.

But you could also remove rows 232 - 238 on column SJ - SK should do the trick also, but I did not try it on the demo, I did overmark those on my demo though in 'red' if your still not sure which I'm on about.

Hope this assists you, let me know.

Serenity Isle Clan. - - -

Google assist sheets link here

24-Mar-2017 09:45:58