forums.rs

Forums

Clan List Logger

Quick find code: 86-87-226-65189098

of 36
BluePhenixRS
May Member 2023

BluePhenixRS

Posts: 1,741 Mithril Posts by user Forum Profile RuneMetrics Profile
Blasty said :
If the admin button has disappeared and you've tried refreshing already, try this:

Tools -> Script editor... -> Resources -> Current project's triggers -> Add new trigger -> (onOpen | From spreadsheet | On open)

i

­­
­­<
Blasty
the Blue
>­­
­­

Any information on why this button has gone missing? I was quite confused when it suddenly disappeared yesterday but thank you for this workaround.
Owner of
Lords of Conquest
-
Check us out at:

87-88-699-65702304
#MakeRuneScapeGreatAgain!

05-Jun-2014 19:50:12

Blasty
Feb Member 2017

Blasty

Posts: 9,319 Rune Posts by user Forum Profile RuneMetrics Profile
Working on the next version at the moment, I've just about finished the improved backend of what the current logger does. There'll be a lot of front end to do too though.

I have an algorithm that is pretty good at working out name changes in most typical cases. This is roughly what it does:

1. Given two memberlist tables, it finds the added and parted members.
2. It then filters unique non-recruits with non-zero xp and finds identical XP, kills and ranks - these are paired as name changes.
3. It then filters joiners with between 300k and 2m clan xp and pairs the closest leaver, starting with the highest xp first, with under 10% xp difference IF the second closest is more than twice as far in xp and the rank changes by at most 1, and the the kills increase by no more than 30. The pairs are added to the list of name changes.
4. It then does a similar filter for members over 2m clan xp with a difference of at most 5m.

Obviously this was a bit of a mess to code, so hopefully I might be able to make things neater when I start the hiscores sheet.

It works for all name change cases I've recorded in my sheet, though I imagine there will be unusual exceptions.

I still have to make it possible for an editor to assign a name change pair and also remove it, which is a headache for now as I work out how it affects entries in each column (additions, partitions, joiners, leavers, rankups, rankdowns, name changes).

Next up will be creating the sheet and functions determining membership, then hiscores, then customizable clanmate properties (daily and weekly), then clanmate notes, then clan properties, then notifications, then issues, then settings, then account management, and other misc. settings/properties.

Then I'll start working on the front end.

It looks like lots of work, but I really want to make this the ultimate tool for rank management.

I feel like I managed to include all my clan is looking for in terms of rank management, but I'm still looking for suggestions!
Blasty
// @BlastytheBlue // Blasty#5167
| Co-owner of Mine Nation

19-Jun-2014 20:14:27

SofaKing

SofaKing

Posts: 1,854 Mithril Posts by user Forum Profile RuneMetrics Profile
Two things I will suggest are, and im probably wasting my breath;

-who has capped.
-who recruited who.

This tool is amazing Ive been using it for all 3 chats in my clan. Great work.

19-Jun-2014 20:59:55 - Last edited on 19-Jun-2014 21:00:40 by SofaKing

Blasty
Feb Member 2017

Blasty

Posts: 9,319 Rune Posts by user Forum Profile RuneMetrics Profile
^

I'm making clanmate properties customizable so you can add your own and as many as you like, but yeah I'd definitely like to know what properties you would add, as they'll give me a better idea of how the editing permissions should work and some of them would probably be good to add as defaults.

Thanks :)

i

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

19-Jun-2014 22:05:18

Dashadoking

Dashadoking

Posts: 2,861 Adamant Posts by user Forum Profile RuneMetrics Profile
"Yup, that can be done in the current version.

Tools -> Script editor... -> Resources -> Current project's triggers -> updateLog -> (Day timer -> Hour timer)

However this will mean more frequent failure notifications (just set them to spam), and more new rows being added more frequently (lots of empty rows for clans that update ranks less frequently or don't get new members frequently).

I'll have to look into making the information displayed more compact. I'll add that setting option to my list of things to add.
­<
Blasty
"

I've just tried to change the time, but I had to add another trigger to do it. Because strangely, my script only has the On Open -> From Spreadsheet -> On open trigger. Dash - Founder of the NomNom Family | T7 + 3 Avatars | Recruiting Social and mature members |

20-Jun-2014 05:18:05 - Last edited on 20-Jun-2014 05:28:42 by Dashadoking

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