forums.rs

Forums

Clan List Logger

Quick find code: 86-87-226-65189098

of 36
Thylordship
Apr Member 2023

Thylordship

Posts: 1,372 Mithril Posts by user Forum Profile RuneMetrics Profile
Dude I rarely post on here but this logger is amazing work! Thank you for making and sharing it! This is really useful and the raw data is very easy to manipulate to fit many different needs. And thank you for the instructions for I have never used something like this before. It's very impressive!

23-Oct-2013 21:01:24

Blasty
Feb Member 2017

Blasty

Posts: 9,319 Rune Posts by user Forum Profile RuneMetrics Profile
­­Thanks for all the compliments everyone :) I wanted to make it easy to access and use and I'm glad it's working out well.

01astronaute said :
I have a decent algorithm to guess if someone changed his name, if you want. Need to store previous day's clan members hiscores, though.

I wrote a site for our clan with similar functions. A real site is more flexible, though. :P

I'm planning on adding hiscores lookups as a feature since that's how membership can be determined. Since a full list of clan hiscores can be very large I'll only be storing one set at any time, which should still make confirming name changes possible. Since I imagine it being quite a lot of work I'll leave it as a feature for later. If you could give an outline of the algorithm and/or show it somehow, it'll help for when I get to it. :)

Subzero said :
Found a bug in your spreadsheet mate, illustrated in the screenshot located at
http://puu.sh/4XD0D/284fb4bfcd.png


Rank-ups are showing as Rank-downs, and vice versa. :)

Subzero

The Cold One
Leader of Incursione

Haha, I definitely should work on my Q&A testing. Thanks for pointing it out, I'll quickly sort that out.

­­­­
<
Blasty
the Blue
>
­­­­
Blasty
// @BlastytheBlue // Blasty#5167
| Co-owner of Mine Nation

24-Oct-2013 01:19:55

Blasty
Feb Member 2017

Blasty

Posts: 9,319 Rune Posts by user Forum Profile RuneMetrics Profile
­­So after doing some reading, I found out about using apps-script libraries which should mean that the next version will be the last time you will need to download a new spreadsheet to update it.

After that, it will tell you when a new version is ready and all you have to do is change the library version which should be simple enough.

About the leavers/joiners swap, I know what caused it and I have a fix. I don't want to have to make you download another spreadsheet just to make that change. It will be fixed in the next version.

If you want it to be fixed you can make these changes (Tools -> Script editor...):

Line 59
change:
var differences=compareClans(
raw
,
prev
);
to:
var differences=compareClans(
prev
,
raw
);

Line 125
change:
output.
leavers
.push([rawNames[ i],rawRanks[ i]]);
to:
output.
joiners
.push([rawNames[ i],rawRanks[ i]]);

Line 131
change:
output.
joiners
.push([prevNames[ i],prevRanks[ i]]);
to:
output.
leavers
.push([prevNames[ i],prevRanks[ i]]);

­­­­
<
Blasty
the Blue
>
­­­­
Blasty
// @BlastytheBlue // Blasty#5167
| Co-owner of Mine Nation

24-Oct-2013 04:31:03 - Last edited on 24-Oct-2013 04:32:20 by Blasty

Quick find code: 86-87-226-65189098 Back to Top