RYSLIG - THREAD/AC TRACKER

[loupnoir]

November 2022 Update: Nix (nixthat) made a tweaked version of the AC tracker that improves and clarifies the spreadsheet layout--you can check it out here!

---

Hey, everyone! This is Everett (wolfnoir), and I've put together an AC tracker for Ryslig in Google Sheets! I've seen people struggling to putting together their AC comments, and I figure, why not make a spreadsheet that automatically generates the comment and calculates bonus AC? The neat thing about this AC tracker is that you're free to put in threads that are less than three comments, as it will only count threads that are eligible for AC!

This tracker was inspired by Xy's Deerington AC Tracker, who was kind enough to let me use their script as a starting point! Please let me know if you have any questions using this spreadsheet.

INSTRUCTIONS

1. Navigate to this spreadsheet and click File > Make a Copy. Save it to your Google Drive.

2. Ensure that the current sheet you are using to track this month's activity is named CurrentMonth.

3. Fill out the necessary fields except the ones in dark blue. Do not edit the dark blue fields. The cells in dark blue are the ones with the necessary formulas! More information and instructions on each field can be found in the "Information" sheet at the bottom.

4. At the top, select Ryslig Activity > Print Activity Comment. You need to give the script permission to run on your account. Once permission has been granted, the script will run normally. A panel should pop up displaying the information you need.

5. To make a new sheet to track threads for a new month, right click on the Blank Template and click Duplicate. Make sure the duplicated sheet is renamed CurrentMonth so that the script can find the appropriate sheet to generate the comment.

FAQ

How do I use this spreadsheet?
This spreadsheet is just a way to keep track of your threads for the month and print out an already-formatted comment for Ryslig's Activity Check. No fumbling with HTML, you just run the script, copy what it gives you, and paste it for your activity check comment. It's that easy!

The spreadsheet itself does NOT automatically count comments, due to the fact Ryslig is locked behind a "discretion advised" filter. You will have to manually input how many comments you've made in a thread.

Help! I edited the sheet and accidentally erased the formula in one of the cells!
Not to worry, the formulas for each of the dark blue cells can be found below! Simply copy and paste what you need.

Current Coin Count
=G9-H9

Total Comments
=SUMIF(E7:E,">=3")

This Month's Coins
=IF(K7>=200+K11,IF(G13="Yes",40,20),IF(G13="Yes",FLOOR(MAX(MIN((K7-K11)/10), 0))*2,FLOOR(MAX(MIN((K7-K11)/10), 0)))) + IF(AND(G11="Yes",K7<200+K11),1,0)

Updated Coin Total
=G9+L7

Updated Coin Count
=I9+L7

The Activity Comment Printer isn't printing correctly/is bringing up an error.
Check to make sure that all fields are filled out appropriately, and then check to make sure that the sheet you want to print is labelled "CurrentMonth". If you are still encountering issues, please leave a comment with the error that occurred and I will get back to you as quickly as possible!

Something else happened! Feel free to ask any questions below!

Comments

[digiorno]

howdy! i have a very non-urgent question about a possible addition to this coding, with the caveat that i'm frankensteining and know almost nothing about properly coding sheets. regarding the comments column, in the past i've used the following code to auto-count comments:

=COUNTIF(importxml(URL-CELL,"//span[class='ljuser']"),"USERNAME")

example:

=COUNTIF(importxml(B7,"//span[class='ljuser']"),"digiorno")

however, inputting that into the prefab sheet isn't producing an autocount result. do you have any idea why? if not that's totally fine, i am just trying to frankenstein like i said. thank you!!

[loupnoir]

Hi! Thanks for coming to me about this question. I looked into the issue, I think this is a result of the fact that Ryslig is locked behind an 18+ filter that the user needs to manually click on if not logged in, and as a result the formula can't automatically calculate comment total. This applies to any sort of 18+ community, unfortunately.

So, while the formula could theoretically work for inbox threads that aren't locked, it seems like you have to tally up the totals yourself. Sorry about that! I recommend using CTRL + F for this, though, to make it a little easier.

EDIT: SORRY not 18+ it's a view with discretion filter!! But same thing happens.

[digiorno]

oh damn i would not even have thought of that. thank you! that makes a lot of sense, and i appreciate the explanation — thinking on it now, when i've used this formula in the past it's been with communities that for one reason or another don't have a discretion or 18+ filter. today i learned!

[bugbeverage]

Hello! Thank you for putting this together.

I'm having trouble getting the comment printer to even appear. I have no "Ryslig Activity" option on my option bar and I have full permissions set for the sheet.

[loupnoir]

That's super weird! If you create a duplicate sheet, does it still not show up? What browser are you using? I'll try and see if I can reproduce it in the morning.

[bugbeverage]

Just duplicated the current sheet and still no prompt or anything.

I'm using Google Chrome.

[loupnoir]

Can you share your sheet with me and give me edit access so I can poke around?

[bugbeverage]

Sheet can be found here: https://docs.google.com/spreadsheets/d/1PhrVi0X5kCHcBiIy2OhXI8nMQZUORzysTEboUODQCMs/edit#gid=1588966845

Full permissions.

[loupnoir]

OKAY, I THINK I FIXED IT. I went to Extensions > App Script to see if anything had happened to the script it was running, and for some reason, it just straight up didn't exist??? So I copied the script from the original spreadsheet and it seems to be working now. Thanks for being patient, you can rescind the permissions now. Let me know if there are any other issues!

[bugbeverage]

It shows up for me now! Thank you so much for taking the time to help me!