fen's spreadsheet hell

[Fenris]

yo i have spreadsheets? lots of them? i post them in chat sometimes but then they get buried under the rest of chat so it seemed like a good idea to put them somewhere more like permanently accessible.

v7 stuff:

Pregame Data: all threads in pregame from all sections, listed w/ their location, the date of their first and last posts, number of posts, characters and handlers involved, and all characters who aren't actually in the thread but are mentioned IC. up to date and updated occasionally since pregame is basically over but ill update memories whenever i get around to it

Game Data: same as above but for the game proper, w/ extra data including the IC day each thread takes place on and any deaths that occur in them. up to date and updated in basically real time when i'm not asleep

Meanwhile Data: now running! same as above but for meanwhile. includes separate columns for "characters" (v7 characters not on the trip), "related characters" (v7 characters who are on the trip, whose family members are included in the thread), "past characters" (characters from v1-6) and "npcs" (any character in the thread that doesn't fit into the prior categories including family members). updated sporadically since im not paying that much attention to meanwhile right now but it'll be complete eventually

Status: a quick list of characters kept constantly up to date on who's currently in what area/thread as well as who's dead. also is gonna be the most up-to-date repository for sprites. updated also in more-or-less real time when im not sleeping update: also includes an Area Status tab, which shows what threads are open in each area in basically real time. also, all sprites are being replaced with death sprites as people die. if you need the original sprite for one reason or another just let me know and i'll send it to you!

Gacha: memes. this is where im putting all the gacha cards as i make them along w/ gacha-related data (kill count, days survived, and bda/bka wins). updated as kids die or as mimi does art that i can make cards out of

Murder Rankings: my pre-v7-actually-existing opinions on who's gonna do murders. finished up to like the last mad dash of profiles. no longer being updated since the island has started and all.

Birthdays: all the IC birthdays. hasn't been updated in a while, poke me if you wanna add your kids i guess

More Data: currenly contains the number of mentions each kid has, in pregame only (i'll make a separate spreadsheet for the game proper when we're further in). will later include announcement data, cards, probably more random data analysis like what handlers write together the most, that virgin spreadsheet yall are so keen on pregame mentions are being updated as they come up, everything else will be done whenever i dunno

other stuff:

Songtest Data: the stupid algorithm i use to keep track of who's the Best at Songtests. i believe mara started this one so ty to him for that. updated at the end of every songtest

Advanced Songtest Masterlist: brackie has the regular masterlist lmao. the work in progress is a separate version that contains full data for each song: who submitted it, how it placed, and how many points it got. bc data. work in progress, will be done eventually, its a lot of work lmao update: this exists now! it only currently includes who submitted what song. other data will be added if and when i ever have time lmao

also, this isn't a spreadsheet but it's a project i'm updating over time so i figured i'd post it here: the Death Map. i'll try to update this quickly as deaths happen and repost it here.

[+] death map

[Maraoone]

[Fenris]

updates!!!

• meanwhile spreadsheet Exists now
• Area Status was added to the Status spreadsheet, so that one has two tabs now, one that keeps track of each kids' status and one that keeps track of what threads are currently happening in each area
• also in the Status spreadsheet, all v7 sprites are now complete!
• the Advanced Songtest Masterlist now exists! lots more data will be added over time but now its current for "who submitted what song" so thats a start
• uh also theres a link to this in my signature now. thats not a real update but i dunno

[Fenris]

patch notes v1.5:

• added the gacha spreadsheet
• updated info on some of the other spreadsheets
• included the Death Map

[Fenris]

woomph. patch notes 1.7? something like that

• added danger zones to the Area Status sheet
• added the current day a thread is on to the Area Status sheet
• updated the Open? column in the Area Status sheet to include CLOSING as a status, indicating that people are currently moving out of the thread
• updated the Status column in the Character Status sheet to include ROLLED as a status, to track what kids are gonna be dying in the near future (to be updated as swaps/heroes take place)
• CAUGHT UP WITH ALL THE READING I HAVENT BEEN DOING IM SORRY

to-do: deadsprites and gacha cards for the newly dead + updating the death map again. also the sprite part of the game data sheet needs to be updated. also i was gonna keep track of cards and i forgot about it? death 2 me