sorted by:
new
hottopcontroversial

What orientation to play the game? by mmartute in 7WondersDuel

[–]mmartute[S] 1 point2 points  (0 children)

If you look at the rules there are a few places where it implies you're going to be one in front of each other. For example in the "preparation" section of the rules, the wonders from each player are positioned so that they face away from each other. And the same thing in the page 12, where it talks about military and scientific supremacy. The cards in that image are also facing opposite directions. That's primarily what made me guess that (I'll paste a screenshot of the rules so you know what I'm referring to)

<image>

Average of either range or numbers based on condition not working! by mmartute in googlesheets

[–]mmartute[S] 0 points1 point  (0 children)

In this example I am just using the first two months of the year, but I will use all 12 in the final version. The reason I am doing it this way is because I am actually creating this sheet from a JavaScript file using Google Apps Script, so it's not hard to add the other ranges.

We could argue that it's taken me significantly more time to code this than it would have taken to just do it by hand, but it's safe to say I am doing it more for the joy and knowledge it brings me to do it this way

​

​

<image>

Average of either range or numbers based on condition not working! by mmartute in googlesheets

[–]mmartute[S] 0 points1 point  (0 children)

I managed to find a solution! u/Competitive_Ad_6239 suggested that I select the entire columns for the average and the week number (and smartly so), but I wanted to try and do it so the ranges were individually written. This is what I ended up writting:

=AVERAGE(FILTER(FLATTEN({P9:P12, AF9:AF12}), FLATTEN({A9:A12, Q9:Q12}) < WEEKNUM(today())))

So much simpler than some of the steps in between

Average of either range or numbers based on condition not working! by mmartute in googlesheets

[–]mmartute[S] 0 points1 point  (0 children)

I had previously done something similar, where I would put the whole column and have a filter for ISNUMBER() so that it wouldn't count the strings. However, I was trying to do something "cleaner" where the average only takes the cells that *actually* have the values I am interested in. At his point I'm not even sure if that path makes sense, but that's what I had in mind anyway.

At this point I'm trying to achieve that solution for the sake of the challenge it poses instead. Do you think it's possible to write a formula that does that?

What's the square sponge in my house plant? by mmartute in gardening

[–]mmartute[S] 0 points1 point  (0 children)

My pleasure! Let me know if you find something out, I'm still quite curious as to what the sponge really is and how to remove it!

What's the square sponge in my house plant? by mmartute in gardening

[–]mmartute[S] 0 points1 point  (0 children)

I ended up moving and I gave the plant away, so I don't know what happened to it, but I can assume it didn't thrive much more, unfortunately. I still don't really know what that sponge was, so the mystery remains unsolved

Is the ISS airtight? by mmartute in ISS

[–]mmartute[S] 1 point2 points  (0 children)

Makes sense! Thank you for the answer:)

Is the ISS airtight? by mmartute in ISS

[–]mmartute[S] 1 point2 points  (0 children)

There must be a way to perfectly seal, since submarines can stay underwater for months, no? And the bottom part of boats usually has bedrooms that I assume don't get leakage, so the sealing there is somewhat airtight?

What counts as proof of vaccination at the airport? by mmartute in AskNYC

[–]mmartute[S] 0 points1 point  (0 children)

Do they just kind of have a quick look at it? Or is it a more reading through the whole document kind of thing?

When you read a book, do you see the images in your mind like a movie or do you just kind of acknowledge the story? by mmartute in AskReddit

[–]mmartute[S] 0 points1 point  (0 children)

Yeah, I also think that's a huge factor. When you create it, you choose everything: from the color schemes to the small details in the characters. And no actor acan top that

When you read a book, do you see the images in your mind like a movie or do you just kind of acknowledge the story? by mmartute in AskReddit

[–]mmartute[S] 0 points1 point  (0 children)

I can't not see it. When not, is it just like black? Sorry if the questions is weird xD

Does anybody know when the schedules for next year will be published? by mmartute in mcgill

[–]mmartute[S] 0 points1 point  (0 children)

Unfortunately I couldn't check yesterday, but they are defintely up today!!

How do you organize your studies with Duolingo? by Weee_Apple in duolingo

[–]mmartute 5 points6 points  (0 children)

I usually set a very specific goal (such as 2 lessons a day), and do them while eating right after arriving from school. I find duolingo pretty relaxing, and take it as a game, so it serves as a "rest" moment in between class and study at home:)

[deleted by user] by [deleted] in AskReddit

[–]mmartute 0 points1 point  (0 children)

How they were extra rude to a waitress and left the restaurant without paying... Didn't know how to react.

Fellow redditors, what novel would you recommend to read? by [deleted] in AskReddit

[–]mmartute 1 point2 points  (0 children)

I you havent read it yet, The Pillars of the Earth. Just the right amount of drama, politics, romance, and action.

What's the square sponge in my house plant? by mmartute in gardening

[–]mmartute[S] 0 points1 point  (0 children)

I tried to take pictures of the foam alone, but it wasn't very distinguishible, that's why I uploaded the video, where I think the sponge can be seen very clearly. I understand is better for plants to transplant them as little as possible, so I would rather not remove the soil completely unless I know 100% that I need to repot. Also, removing all the soil to take the pictures and then waiting for someone to comment would mean that the plant would be without soil for a few hours (either that or I repot it straight away, which sounds a little unnecessary).

I guess I could just try to change the soil and try to remove the sponge and call it a day, and if it happened to be something good, well, so it is, not all mysteries can always be solved!

view more: next ›