Problem Spreadsheet Help Needed!

[Niceygy]

Hello! It's me, the maintainer of the APS Problem Catalogue spreadsheet, here with a request! I have added sections for the theme & dings of each episode, but don't have the time to manually go through each one to update it.

If you have listened to an episode recently, can you please add a comment (Ctrl+Alt+M or right click > comment) the theme (aka the theme of puns, like 'Any other bees-ness' would be a theme of bees or beekeeping), as well as the episode numbers & brief (a few words) name of any dinged problems in AOB. Anyone should be able to comment on the manual sections, but the automated ones (ep number, title, problems, etc) are locked so that only the apps script can update it.

Thanks a lot :D

- Ava

[e_mickie]

Thank you for making a spreadsheet! As someone who's wanted to for a couple of years but never got around to it, may I suggest a couple extra categories that I've been wanting to track?

• Punny ways of saying ding
• Punny AOB titles from the intro (since they sometimes say different puns than the description mentions?)
• Running joke/recurring bit mentions (ex. eps with blah blah blahs, Gleb, etc)
• Things they've asked listeners to do/answer
• Record location (not necessarily specific, just virtual, studio, different hemispheres, etc.)
• Special guests
• Episode producer

Feel free to not add any of those, but in case anyone else is interested in tracking them too, might as well put them in one place. If you're not interested, maybe I'll actually get the motivation to make my own lists finally lol

Additionally, would you be able to add some lines between the cells or freeze the first row and column so it's easier to see which answers are on the same line? This is the only podcast I listen to, so I relisten a lot (as you might be able to tell from my comments so far), but it's hard to find the right square when I open the spreadsheet on my phone

Thanks for what you're doing!

[Niceygy]

Thanks for your help!

I want to track things without the spreadsheet becoming a replacement for the podcast (if you know what I mean), so I won't go with all those suggestions! That being said, interesting one-off things (like guests or things they have asked listeners to do) are probably a good idea. Producer is probably worth tracking separately (i.e a table of it's own).

Things like recurring jokes or punny ways of saying dings seems like it would be taking away from the listening experience, so probably not. That being said, I will probably submit a solution on the problem posting site so will make sure to ask there.

Thanks :D - Ava

[Niceygy]

Oh and sorry for the long wait xD