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!