Google Sheets - Blog Posts
Crayola made a habit tracking spreadsheet for the new year!
I'm not sure if they'll actually be using it though...
As a neurodivergent fucker myself, it's always so very rewarding any time I can introduce one of my equally neurodivergent peers to the joys that is microsoft excel/google sheets.
Anyways, here's a link to a google sheets version of my supernatural masterdoc tracking every on-screen death. It's filled with some pretty creative solutions and formulas if I dare say so myself
(I work in excel, but it's a bit finnicky with sharing there, so just lmk if you want the proper document and I can mail you the file. Had to remove a couple of things that didn't translate to google, so the true document also has a list of every single killer in the show, and a list of episodes with no deaths)
Gamehouse games order
Another useless spreadsheet! But I also like this one, so I'm sharing.
Maybe someone else like Delicious series by Gamehouse and its spin-offs (I treat them as such) and wants to know correct timeline order to play them all. Well.. Not all. There's only ones I like.
List of game series included:
Delicious
Heart's Medicine
Fabulous
Dr. Cares
Sally's Salon
Parker & Lane (though it doesn't have any connections to Delicious)
Last two don't have their locations named, because I haven't played them yet :)
Rugrats episodes
Huh, this one is completely useless for normal people, but I like how it looks, so I'll post it too.
This is just list of Rugrats (1991) episodes you can find on Wikipedia.
I made it to check what episodes I have on my old DVDs and how many I'm missing. It's one of my favourite shows I still rewatch sometimes.
I deleted markings, but if you're interested, I have first three seasons almost in full and lots of random episodes from seasons 4-8. And three movies, but they're on separate DVDs, so no surprises there.
On second page you can find it filtered in production order (that partially helped me to explain why some older episodes were on my DVDs)
Talent materials for all chars of Genshin Impact and Honkai: Star Rail
Okay, this one is probably the biggest project I've been using for years now. It lost it's usefulness in last year as Hoyo started implementing many things from here into HoYoLab and game itself (not like if they look my work as basis, but as functions presented here aren't unique anymore), but I still prefer to use my own thing. Game's version feels more convoluted and it's just easier to see full picture.
Включает русскую версию
There's instructions on the bottom Weekly boss materials ones, but it works about the same as Hoyo accompany rewards sheet. You'll have to make your own copy to use it. File -> Make copy. Also, there's links to my updating sheets, so you could easily access them from your copy.
There's two pages, named after languages they're in. GO INTO "ENGLISH" ONE.
Links are supposed to lead directly to English page, after you get your copy, just delete Russian page if you don't need it.
Everything updates as soon as materials get officially announced.
These little sticker note looking things on the right show how many silver and gold items you can craft out of extra mats you have (gold ones take into consideration silver ones you can craft!)
Sadly, you'll have to manually change amount of mats needed for character if you level their talent, as well as amount of mats you have. I thought about automating it, but haven't come to solution yet.
It is automated now, you just set character's talent levels and it counts everything. I kept old version too if someone prefers it that way.
______________________________________________________________
I'm that into building characters, in fact, I have all genshin characters at 9-9-9 talents, except Mizuki (because I don't have her) and those who uses newest weekly boss (but I have all needed talent books for them and those who I don't have). I used my spreadsheets to keep track of materials needed.
Maybe I could make similar spreadsheet for enemy and local specialty mats? Let me know, if you'd want it.
I actually made these too, check them out, if interested.
I also plan to make something similar for ZZZ, but not sure how yet. It probably won't have Russian version, cause my mom doesn't play it, so maybe it could be one file with three pages for different things? Weekly bosses, regular bosses and skill materials. I know someone already made very nice site and there's useful feature in game, but again, my goal is to generally build everyone, not focus on one character.
I made ZZZ one too, just gotta find time to post it.
I'm sorry for Russian version being on the first page, my mom also uses these and she might get lost if English one would be first.
______________________________________________________________
Genshin Impact
Weekly boss materials tracker
Talents
Honkai: Star Rail
Weekly boss materials tracker
Traces
Pokémon games spreadsheet
So, this one doesn't have any functionality and is only meant to make Pokémon games less intimidating for a newbie. I literally made it just to get understanding of all these games, generations and what came when, etc. Mainline and Legends only.
It has Pokémon Green as "Third version" for Red&Blue, but I just wanted to show that in Japan it was "Red&Green" (they also got their own Blue later). There's a note about it, but it's not all that noticeable.
I might have had links to ROMs here originally, but I don't want Nintendo to hunt me down, so I removed them from this spreadsheet.
Hoyo Accompany rewards
So, let's start with something useful if you're a something of a collector yourself. This spreadsheet helps you track your accompany rewards.
I'm a little crazy about collecting virtual stuff that I can track like this, so I made this spreadsheet. It has all characters that have their own widgets. Sometimes, you can accompany characters even before they're released or got widget of their own through HoYoLab (currently Tribbie, Mydei and Mizuki are such characters), so I want to note that I only add those who has widget.
***
Besides letting you mark what you have already collected, it shows how many points you still need to be able to get everything (including what might be added in the future) and how many days it'll take.
Every character is meant to have Badge, Frame, Background, Comment decoration, UI style and Sticker set. Everything, except stickers (70 points) costs 160 points.
Gray columns on the right are additional stuff some characters get and if it's gray, it doesn't get taken into account.
When there's 10 or less days left, days cell will turn green, because I like to keep them in round numbers. It won't be highlighted after you have enough points, getting toned down instead.
"LVL90/80/60" flags are meant to show you that there's more than 10 days left, but if you can max out character's level, you'll get enough points in time without starting new 10 day cycle. You can ignore it or keep track of maxed out character levels if you want. It's just my personal quirk.
***
This spreadsheet gets regular updates for newly released characters, but if old characters get updated I might miss it. You can inform me about it and I fix it.
It has links lo my Tumblr and BlueSky as well as to itself, because to be able to use it, you'll have to make your own copy of it (File -> Make copy), which won't be updated automatically. You can always just add new characters yourself, if it feels like too much hassle :)
Please, note that it has three pages, one for each game.
I, personally, use a bit different version with my own markings and such, but for simplicity I changed most of it to simple flag marks.
English isn't my native language, so I'm sorry if my sentences or choice of words seems weird or wrong.
I make spreadsheets
Okay, I'm done, I want to share my stuff with someone who isn't my mom.
So, I make lots of different spreadsheets in Google Sheets, either just informative or with some functions. All in different themes and fandoms. I plan to post them separately and use this post as masterpost with links.
I feel like Tumblr is the least scary place to post stuff like this, but maybe I'll post them in BlueSky as well one day.
There won't be lots immediately, cause I want them look good if I'm going to actually show them, so I'll post the ones that are already in presentable shape.
I hope people would find at least some of them useful.
There's like... Four of them? Damn. Can't show really personal ones, sadly. But I constantly update and make upgrades to some interactive ones, so it feels like I did a lot of work.
Also, if you have an idea for a spreadsheet, message me, I'd love to make something, I take great joy in making them. Fandom doesn't matter.
Links:
Hoyo Accompany rewards
Pokémon games spreadsheet
Talent materials for all chars of Genshin Impact and Honkai: Star Rail
Rugrats episodes
Gamehouse games order
Pokémon weaknesses and effectiveness charts