Folkmore Thread Tracker

[pursuitofcappiness]

Hi all! I thought I would share my personal thread tracker spreadsheet for the game. One of the main purposes of using this thread tracker is that once you put your threads in, you can have it automatically calculate, total, and print the html code required to submit your threads for spoons, and make purchases. Here's a guide on how to use it!

TABLE OF CONTENTS:

1. Installation: How to install the spreadsheet and fill it out for an initial run.
   
2. Guide: A key/legend to the fields on the spreadsheet, separated by tab.
   
   1. Threads: The main tab that contains all your threads you want calculated, or anything that gets tabulated by comment count.
      
   2. Extra: The tab that contains any extra spoons that are not tied to comment count, such as a one-time event bonus.
      
   3. Gains: The tab that contains all purchase information.
      
   4. Network: Tab for you to keep data to print out code for your network posts.
   
   
3. Spoons Menu: A breakdown of all the calculations and code generations available to you to run from the spreadsheet.
   
4. FAQ: Troubleshooting and frequently asked questions.

INSTALLATION

1. Go here and do file-->make a copy. This is very important. If you select the sheets and copy, the scripts will not work. Remember to please make a copy to your own personal folder. If you have two characters, just make 2 copies and rename the titles.
   
2. Fill out the carryover and posting comment fields on the Threads tab. The carryover is how many spoons you currently have, and the posting comment is a link to your comment.
   
3. Fill out the rest of the sheet as you wish. Do not fill out the boxes that have an orange background, those will be generated.
   
4. The first time you run anything from the Spoons menu (above, by File and Help), google will ask you for permission. You must agree to give it permission to run, or the script will not work. For the reason that google needs permission, you must also be logged into a gmail account or google will not know who you are!
   
5. That's it! I've included a guide on which tabs and fields are used for what below. Enjoy!

GUIDE

THREADS

This is the sheet for anything that has the count of spoons dependent on how many comments there are. Items marked * are required fields for a row to be considered. Others are optional.

Carryover* This is how many you have carried over from a previous submission. Because the spreadsheet doesn't know when your previous submission was, you do have to fill this out manually before running any of the scripts in the menu.
Posting Comment You only have to fill this out once. This is just the URL to your comment on the spoons page.
Thread URL* URL to any thread.
Date Date - this is not considered by the script and is just for you. That way you can use google sheets to sort all the data by date if you wish. You can put anything in this field.
Subtract The amount of comments you want subtracted from the total to avoid double-counting your tags. This is for if you only wish to ctrl+f your name on your thread and, for instance, don't want to count your username if it's your post/inbox, or from the dreamwidth login information. You can leave it blank if you would prefer to subtract those numbers from your count by yourself.
CR* Your CR, or a short description of the thread. It's what shows up on the link text when the script is run, so you can also have it just say Tag Proof(s).
Count* How many tags from your character in this thread. Please note a blank here will result in the row not being printed as this will be considered a wip.
Multiplier How much you want to multiply the count by. The accepted syntax is either just the number (EG 3), or numberx (EG 3x).
Multiplier Reason The reason that this thread needs a multiplier, for instance if you are soulmates.
Total Spoons This will be calculated by the script, but you can manually input the calculation if you want. It is unnecessary.
Warnings This will print out a list of warnings for the thread, in parentheses. Please use this to include nsfw markers or cw for the mods or anyone clicking the link.
Complete You can either go to insert-->checkbox, or fill in a line except for this field and then run "Calculate Thread Spoons" to insert a checkbox. Checkbox for whether or not the thread is complete. This is for organizational purposes only and is not considered by the script.
Last Comment URL Link to the latest comment in case the thread is incomplete.
Submitted for Spoons? You can either go to insert-->checkbox, or fill in a line except for this field and then run "Calculate Thread Spoons" to insert a checkbox. This is a checkbox to mark if the thread was submitted. Anything marked as submitted will be ignored by the script. Therefore, you can keep your old threads on this sheet if you want to have them around, just mark as submitted and you're good to go!
Notes This is also for organizational purposes only and is ignored by the script. You can write anything you want in it.

EXTRA SPOONS

This is the sheet for anything that has the count of spoons for any one-time items, such as 100 flat spoons given out for an event. Any spoons that are dependent on number of comments should go in the previous tab. Items marked * are required fields for a row to be considered. Others are optional.

URL* URL to thread or proof of the extra spoons, EG for an event.
Date Date - this is again just for organizational purposes and is not used by the script, so you can put anything you want here.
Spoon Amount* The amount of spoons that you gain extra. Please note a blank here will result in the row not being printed as this will be considered a wip.
Reason* The reason that you gained these extra spoons.
Warnings This will print out a list of warnings in parentheses, please include nsfw or any relevant cw.
Submitted? You can either go to insert-->checkbox, or fill in a line except for this field and then run "Calculate Event Spoons" to insert a checkbox. Checkbox for whether or not it was submitted. Anything marked submitted will be ignored by the script so you can keep this data around for reference if you wish.

GAINS

This is the sheet that you should write the items that you wish to purchase. Items marked * are required fields for a row to be considered. Others are optional.

Requested Item* Item that you want to request.
Submitted You can either go to insert-->checkbox, or fill in a line except for this field and then run "Calculate Gains" to insert a checkbox. Checkbox for if this was submitted. Anything marked submitted will by ignored by the script, so you can keep this data around if you want a full list of your regains.
Date Date - again, this is just for your own organizational purpose and is not used by the script, so feel free to put whatever or not use it.
Extra Code There are a few item regains that require extra fields, such as adoption or soulmates. Simply copy the code from the textarea and place into this cell and fill it out. Because sheets does not like multi-line cells, you must copy into the formula bar on the top of the sheet.

NETWORK

This is the sheet for generating a network post header with the twitter format. Items marked * are required fields for a row to be considered. Others are optional.

Background Pic* URL of the picture in the background.
Profile Pic* URL of your userpic.
Network Username* Chosen username.
Bio* The twitter bio section.

SPOONS MENU

Calculate Thread Spoons This fills out the blank areas of the Threads tab on the spreadsheet that have a blue-green background. It does the calculation only, and does not print out a result. It will populate checkboxes on rows with any data.
Calculate Gains This fills out the blank areas of the Gains tab on the spreadsheet that have a blue-green background. It does the calculation only, and does not print out a result. It will populate checkboxes on rows with any data.
Calculate Event Spoons This fills out the blank areas of the ExtraSpoons tab on the spreadsheet that have a blue-green background. It does the calculation only, and does not print out a result.
Print Threads + Extra This prints out code for the Threads and ExtraSpoons tabs, so you can use it any time you want to claim spoons only. This will also run the calculate thread spoons, but will give you an output.
Print Gains This prints out the code for the Gains tab only, so you can use it anytime you want to make a purchase without claiming spoons. This will run the calculate gains menu item, but will also give you an output.
Print Threads + Event + Gains This prints out the code for all three spoons tabs at once. This is for if you want to claim spoons and make purchases at the same time. Please remember to update the carryover on Threads tab first or the calculation will be inaccurate. This also runs all the calculate options, but includes a print-out. There is no need to run the calculate menu items first unless you just want to check that everything is in order.
Print Network This will print out the items in the network tab, essentially stuffing it into the code on the folkmore network posting template.

FAQ/TROUBLESHOOTING

How do I count top levels?
You have a choice of counting the top level from the root, or making separate entries for each thread in order to continue linking the "last comment" from each thread. Since there are multiple last comment on a multiple-person thread, this is not possible if counting the top level from root.

It's taking a long time to run.
It should take a few minutes to run if you have a lot of threads. If you keep your threads, it will take even longer. To curb this, you can migrate any submitted threads to a different tab or spreadsheet for keeping but that way, the program won't have to check whether or not it wants to consider that entry, which will take up a bit of time.

I got some sort of error up top saying something isn't recognized.
This is most likely due to the fact that something the script is expecting is blank. Most commonly, there are blank rows in between rows that are being used. The script thinks those blank rows are supposed to be populated with data, and gets confused when there is no data. Simply delete those rows or just move up the data on bottom. Let me know if it's erroring out on something else.

This calculation doesn't seem right.
That's probably something I missed. I will most likely need permission to make a copy of your spreadsheet with your data filled in so that I can troubleshoot what's going on there. Just let me know and I'll try to find some time to figure it out!

Can I rename things or reorganize?
Due to the nature of the spreadsheet, moving columns around will break the spreadsheet, so I wouldn't advise this. Also, changing the names of the tab will also break this, so I advise not doing that either!

Can you implement an automatic thread counter?
I used to support sheets in previous games that would automatically count comments on an entry, but due to google's constraints it was often buggy and slow, with performance completely tanking after 20 or so entries. Due to this, I no longer support this feature in my thread trackers at all. Sorry! I also couldn't find this policy but read somewhere that DW admins don't like scrapers, which would need to be in place for this to happen. If you know what I'm talking about and google has improved their performance of xpath support, and can find something about dw's policy, please let me know and I will consider adding it back in.

Comments

PATCH NOTES

[pursuitofcappiness]

Will edit here with any notes from upgrades. Please note that if there is an upgrade, you must re-copy the spreadsheet and install as new, but you can copy/paste your data over to preserve it.

Please do not respond to this as I will be editing this comment!

1. Feb 2023 - update to use new network code

QUESTIONS

[pursuitofcappiness]

Ask any questions here, but please check the FAQ in case your question is already answered.

Re: QUESTIONS

[buckette]

hey! Thanks for awesome code! What should the network page look like on the spreadsheet after I put in everything needed from the instructions?

[pursuitofcappiness]

Hello! If you wish to use that to generate your network code, you only need to fill in row two of those fields (icon, image, username, quote) and then "print network" on the menu. It should print out a code for you to use. If you don't like what the resulting network output looks like, simply change out what is inputted on the spreadsheet.

[buckette]

Thanks!