#accessibility spreadsheet

[why-animals-do-the-thing]

Are you disabled and do you like visiting zoos? If yes, I want your feedback!

I am giving a presentation this fall on small/easy things that zoos and aquariums can do to be more disability friendly (above and beyond simply being ADA compliant). I’m drawing from my own experiences as well as all the information contributed to the accessibility spreadsheet.

I realized that there’s probably a lot of feedback and great ideas I’m missing because the spreadsheet asks for specifics about facilities, and folk might not remember where something occurred or know enough details to feel like they should contribute. I want to fix that!

So, if you’ve had accessibility issues at zoos and aquariums, and want to share your thoughts on the problems or the solutions, I’d love to hear it. I want as much information as possible to inform this presentation.

Please feel free to comment here or message me! No facility location / dates needed (but if you want to include that, I can add your thoughts to the spreadsheet too).

[critter-creature-or-beast]

[pilmyeol]

my mom came in to talk to me about the job she got by being insane about card games she is truly living the dream

[machinavocis]

making some sort of fancy Friend Communication Reminder Calendar Spreadsheet Thing would probably genuinely really help me maintain human connections to people i really miss having in my life

but i have this vague viral-internet-memory of this one time an autistic person did something similar & shared it online & everyone was like holy shit what a weird sociopath thing you'd only do if you only valued the performance of friendship & had no actual empathy for your fellow human beings!! ew gross creepy bad fuck off etc.

& so every time i inevitably circle back around to this idea i remember that guy & overthink everything & chicken tf out.

[phannibal]

okay i’m officially going to begin tackling the x files episode novelizations. HOWEVER. the order in which i should read them is not readily apparent. they were kind of loosey goosey with the order they published them in so it’ll go like. s1 episode s3 episode s1 episode etc. so reading them in order of publication is NOT the same as reading them in actual episode order.

HOWEVER #2: yes it seems most obvious to read them in episode order but if i do that, i’ll be jumping around in the three different age group series. bc one chunk of books is meant for kids and another is meant for teens so i assume they will feel somewhat different.

for the original novels, i read them grouped by author kind of accidentally. which is also something i could do here since there’s like 4-5 main people writing these. feels weird but it does help get a sense for a specific author’s style. so:

[spongebob-connoisseur]

After Dark

[episodes-without-incident]

I finished the graph of the Drawfee Cascada streak, so for any other numbers nerds:

(How to read it: The chart shows how long it has been since Drawfee last made an "every time" joke. For example, on September 28, they hadn't for 12 episodes.)

Here's the current graph of the Cats (2019) streak as well:

You can find links to view interactive versions of the charts (as well as the data spreadsheets) in my pinned post.

[blondephil]

dnp movie analysis p2: genres, studios, franchises

thanks everyone for enabling me <3 i'm back with some more analysis by genre, franchise, and studio!

genre ratings

first, genre ratings (genre is kinda arbitrary here, tbh; there's a lot of overlap!)

here we have the first table (please tumblr don't mess with the quality) (i can post the excel sheets if needed; r tables were being a pita)

here we have the number, mean (= median for all of this analysis), minimum, and maximum ratings by genre. within each statistic, i've highlighted the minimum (light) and maximum (dark) for dan (blue) and phil for genres with >1 movie (just realized i fucked up western, ignore that lmao)

phil has watched the most horror (64) and dan mostly sci-fi (53). interestingly, but presumably because of their love for these genres, each of their minimum scores went to these genres. if you watch a lot of one type of movie, you're gonna find the duds.

both of them liked christmas movies (tbh this was like, home alone, so), with their highest minimum and mean ratings being for that category (nostalgia, i assume because like, same). lowest mean scores were for superhero movies (both) and mystery (phil). for both of them, marvel was pretty all over the place (we'll get into that in a sec), so that's not super surprising.

their highest minimum scores were both given to war movies, which is a little surprising but this include movies like 1917 and dunkirk which are ~critically acclaimed~, so makes some sense. their minimum max scores went to westerns and mysteries for dan, and musicals, mysteries, and biopics for phil.

here are the histograms/bar charts for genres. these aren't the prettiest tbh, and i excluded some that had only one or two movies / weren't very interesting. without delving deep into the data, you can see how their preferences play out especially in horror and sci-fi, where phil has more highly-rated horror movies (partly because he's rated more) and dan has a lot of highly-rated sci-fi (but also low ratings). you also see how superhero movies are pretty middling -- there's almost a normal distribution! (not really, but sort of!). romance too. there's in general a lot of left skew here -- they like to rate movies highly.

final genre analysis is number of movies in one genre rated by one and not the other. i'm so sorry this table is so long.

i highlighted here the top three genres one has watched without the other. again we see phil likes his horror (and as i said in my last post, a fair amount of these movies were watched when dan was on tour, and this doesn't even include the guillermo del toro's cabinet of curiosities episodes he rated), but also thrillers (similar!) and comedies (which i get; i love to put a comedy on in the background). unsuprisingly, dan's watched a lot of sci-fi without phil, but also horror and comedy. in general, though, his genres are more distributed.

next, studios/franchises!

again, i've highlighted the maximum and minimum in each column, only for franchises. both of them really like ghibli, and dan likes disney more than phil (though i think this is missing big hero 6 now that i'm looking at it again, because dan rated that lower). that's theatre kid behavior: the 4.5 was beauty and the beast, all pixar and aladdin and so on were highly rated.

i fucked up the matrix somehow so just ignore that -- they both gave matrix sequels low scores

turning to franchises, phil is a harry potter hater (valid at this point). but loves lord of the rings. so does dan, though his dan's ratings actually skew pretty high for franchises in general (see: his maximum scores for each franchise are 4.5 or 5); he can pretend to be alternative or whatever but he's still a millennial at heart. their minimums minimums are both for star wars (sequels!) and marvel, which, valid. phil's highest minimum is bond (there were only a couple rated) and dan's is the hunger games, but unlike phil he only rated thg and catching fire, not either mockingjay.

and bar charts!

i only picked the most interesting ones here as well. marvel follows a similar distribution to the superhero movies, which, since they each only rated a couple dc movies (and i didn't include nolan's batmans), makes sense. again they both rate lotr highly, but the hobbit was low. the studio ones are less interesting imo because they skew so far left, but again: dan is such a disney kid.

that's all i have! i love this because dan, for all his faux cynicism, just rates movies so highly + it's so often the movies that don't fit his curated doomer persona but moreso the pooh one. and also phil expressing opinions! phil just watching a lot of horror!! i love it.

[meatsouuuuup]

I’ve been giggling at this dumb line all week

[thatrandombystander]

Hey can someone check this YouTube playlist and tell me if the Kingdom Hearts 3 video is available/shows up for you? I'm trying to work out if the video has been taken down or if it's just geo-blocked and not available in Australia for some reason

[biancasbow]

Yall are always in danger even if I need my brain to shut the fuck up

[straightbaittournament]

i was gonna say "you can't see it but her hand is in his back pocket" but i think his coat prevents that from happening. anyway, ichabbie propaganda for @bikarma !! my charger stopped working and then my tablet died, so for the sake of posting this before their poll finishes, you get a traditional sketch! if this in any way moves you to vote for them, you can do that here. if you want your own propaganda follow the instructions here. thanks for participating!!

[fuck-yeah-spreadsheets]

Simple Shit

Hey, ever have your spreadsheet looking like this?

Wanna hide them zeros??? Would you usually just set conditional formatting to turn the text white if the cell=0? Okay cool but you know weirdly printers like to print those 0 even if they're white so it looks a bit shitty when you print it off, and what if you want to make it pretty (get your shit together and format like this for accesibility and easy reading) like...

Then what? Make separate cond format for each other row? NO FUCK THAT. TRY THIS.

Go to "Custom" in the number formatting and type in the box ";;;" (that's three semi-colons).

And it will hide any text in the cell if it meets the right requirements.

❤ ~~ three semicolons my beloved ~~ ❤

BOOM. GOodbye ugly zeros.

YOU GOT THIS :: Follow for more !!

[doodlebeeberry]

Hm. Should i use a google form for the gift exchange sign ups this year?

[apigeonisapigeon]

okay arson and other fires update: here's a spreadsheet of all the bits i've written so far. i just started part 2C (titled spooky action at a distance). part 3 (idk how i'm subdividing it, that's a problem for future me) will be the last one.

[paranoidgemsbok]

grahhhhhhh i need to update my pinned post and the shop for winter soabs n stuff