Single Player Hardcore Leaderboards - Topic

Member

Posts: 36,392

Joined: Oct 16 2004

Gold: 74.00

Mar 14 2018 03:23am

Quote (PikaBhew @ 14 Mar 2018 01:58)

Added!

I think I got it!! Just need to do the refresh by sorting again, since it doesn't do it automatically upon level changing. I've tested it, and it does work on other tab sheets.

To double check, I need someone to go up in ranking! :D

Looks like Azketh went up about 10 levels ^_^

Vorp

Member

Posts: 15,914

Joined: Jan 5 2011

Gold: 5,440.00

#32

Mar 14 2018 03:24am

Quote (Belarathon @ Mar 14 2018 04:23am)

Looks like Azketh went up about 10 levels ^_^

Just testing to see how it effects the board

Turns out, whoever moves up/down adjusts the whole board on each class division. Which doesn't really move it much, just has to re sort each one.

/e nope it didn't work, some get deleted

oh well. Leevee is an expert in the spreadsheet field. He'll take care of it, if it's possible. If not, it's cool just to have the first leaderboard.

This post was edited by PikaBhew on Mar 14 2018 03:29am

Kenorwox

Member

Posts: 2,216

Joined: May 29 2010

Gold: 738.00

#33

Mar 14 2018 06:17am

You can always add another admin or two and just make them responsible for changing both values.

I was looking up how to automate it but it seems hard since their position may change on the leaderboard so setting up a formula that refers to a certain row on a specific sheet isn't reliable.

Leevee

Member

Posts: 20,223

Joined: Apr 30 2008

Gold: 5,169.82

#34

Mar 14 2018 08:17am

It can easily be done with a VLOOKUP referring to the main sheet. Then the maintainers only need to fill in the character name and everything else happens automatically.

I'll make it work later today.

Vorp

Member

Posts: 15,914

Joined: Jan 5 2011

Gold: 5,440.00

#35

Mar 14 2018 11:09am

Quote (Leevee @ Mar 14 2018 09:17am)

I tried that, but I guess I did something wrong because I got error or something haha