Twin High Maintenance Machines

I realize that tumblr may not be the most effective place to ask for help with this, but I need some help with Google Spreadsheets.

I’m trying to create a formula in cell B5 that does the following:

M1 is conditional, based on the user input in cell K1. Cell B2 is the sum of cells K3+K4+a user input constant, so I can’t just compare to static values (which would probably simplify things a lot!)

I think that I should be using SUMIF() or COUNT() for at least part of this, but I can’t quite snap the pieces together in a way that makes sense.

If you’ve got any advice or can at least give me a signal boost, that’d be great! Thanks.

- -Endreal

Someone passed this on to me and I figured I'd waste some time doing this. I made a simplified version of the problem. I used fake values for M1 (which is C2 in mine) and B2, but you should just be able to plug whatever values you want into it. The formula is in E2.

I don't use spreadsheets a lot to do things that would be easier in even the most lightweight of scripting languages. The basic idea is that the ARRAYFORMULA function allows you to iterate over a range and return the results of it as an array. If you just jam that into a COUNTIF you can make a conditional counter that iterates over the array.

Let me know if this helps at all, endreal.

tvtropes.org

Arts wiki

According to a discussion on their forums, the password is stored locally in a cookie, and transmitted in cleartext on every request.

Editor’s Note: And of course, they do not support HTTPS.

jesus christ

is feta cheese impossible to melt

i’ve been trying to melt this feta cheese for about ten minutes now

how do i melt this fucking cheese

It requires some work

Microsoft has this idea that everyone is comforted by these simple phrases “Getting Ready” “Configuring devices” and shit but like No I’d actually feel more confident you’re doing something and not crashing if you were specific, why not “copying system files” or…

But the Sims loading screens rule.

Good point.

Microsoft has this idea that everyone is comforted by these simple phrases “Getting Ready” “Configuring devices” and shit but like No I’d actually feel more confident you’re doing something and not crashing if you were specific, why not “copying system files” or “rebuilding app database” or stuff like that

The Outlook web app says something like “Still trying” if loading takes a while, which is usually because my connection is spotty. Thanks for the lack of info

I don’t think it would really help most people to be more detailed. I mean, as far as I can tell most people only have like the most rudimentary idea of what a system file is or a database. Filling a screen with jargon would be about as effective as The Sims loading screens.

fynney is curled up on my floor with her froggie blanket wrapped around her head because my dad is playin’ my keyboard for SPECIAL IN TUNE PLAYTIME (he has an upright downstairs but it is WOEFULLY OUT OF TUNE)

You should get her a Robin blanket to match your Batman one.

So I think the thing I take from stuff like Kill La Kill, Madoka Magica, and Bayonetta is that often literary feminism is almost entirely a death of the author affair. Some women love this stuff, some find it sexist trash and this stuff always straddles a line that both arguments tend to have points. 

Empowerment’s kind of a strange beast to me. I’ve met women who insisted Twilight empowered them. It’s something I literally cannot argue against. I can spew all the sexist acts and damaging relationship actions the book has until I’m blue in the face (and have) but I can’t tell someone they didn’t find something resonant in a medium. (see also Sailor Moon) By the same token I can’t really tell someone they don’t find something repugnant in fiction.

I guess the only thing I can do is listen to their logic, but even then how much is rationalization? How much is apologism. At the end of the day, I guess you gotta just let people like what they like and dislike what they like.

I guess this also means accepting I’m… I’m not always right that it’s possible that in some point in time I may have been slightly misguided.

As a woman who really loves the sort of stuff you listed like Kill La Kill, Bayonetta, etc. it’s always been really weird to me. All these female characters I love that have actual depth to them, that are actually fun and awesome and are more than just one-dimensional sex dolls, are lambasted on the internet because they wear skimpy outfits, or because their boobs jiggle, or because they’re just plain sexual like in Bayonetta’s case.

And I get that it bothers people. That’s fine. But in my own personal case I’ve found that I just…don’t…care. Yeah it’s sexual, so what? They’re still great characters, I don’t see why sexuality makes them worse. I don’t see how sex in and of itself is a negative. Maybe it’s just because I’m a rather sexual person. Maybe it’s because, if it weren’t for the negative attention I’d get, I’d wear skimpy outfits like theirs every damn day. I dunno. But in any case this has often made me feel like the odd one out as far as feminism goes.

I think that part of it depends on what stroke of feminism you go with. Some think Ryuuko and Bayonetta would be empowering, others think it’s just sexist, etc. Hell, that one post in response to that one powerpoint indicates that it also varies with culture (that’s not the only evidence for that, though, but it goes to show how oddly…I dunno, fractious feminism can be, I guess?).

I like that the majority of the notes on this post seem confused by sex negative feminism. I should dig up the essay I read that explained it in a way that I particularly liked so I can share it.

The Wall Street Journal is reporting that Netflix has betrayed net neutrality supporters by caving into Comcast’s extortion demands. Kiss $7.99 a month for Netflix good-bye as other broadband providers demand a piece of the same action that Comcast is getting.

The Verge has more details here.

More details? Like the extent of known facts about this deal is that Netflix is paying for a direct broadband access to Comcast. The terms of the deal haven't been disclosed.

In fact, let's go with a source that's a little more vocal about what can happen from here.

It's also kind of unlikely that $7.99 a month Netflix is going to go away. At worst you're going to see pricing tiers that determine if you get HD or not.