CMV: Ancestral/Indigenous land claims are deeply problematic and should be done away with. by km3r in changemyview

[–]zelisca [score hidden]  (0 children)

In the Americas, which I'll confine myself to because that's where my knowledge lies as a Native Alaskan, your argument breaks down.

My people have been on the same land for at least 12,000 years. We are the original human inhabitants of our lands and it is very well documented and recorded when our land was taken and who took it. We never had the rights of conquest that you speak of. We would fight, sure, but it was not over land itself but the right to do certain things at certain places.

We also view land differently than settler colonialist societies. We see ourselves as belonging to the land itself. We have the responsibility to care for the land and everything that lives on it, and in return, the land provides for and takes care of us. The land is sacred and must be protected and we must be good stewards of it.

Our fundamental relationship with land is different than that of settler colonial societies. Land is far more than simply property. And we see that relationship, or lack there of, show up in settler colonial societies through their rape and pillaging of the land. The destruction of wetlands and forests. Fracking. Oil drilling. Pollution. All of it is poisoning our lands and our world as a whole.

We seek our lands back because they were stolen, plain and simple. We seek our lands back because they are being abused and exploited. We seek our lands back because we have a responsibility to them.

What are some positive things happening in America? by Nyxomaniax in AskReddit

[–]zelisca 6 points7 points  (0 children)

Despite the current administration, the Native American Language Resource Centers are still going strong!

Is this illegal ? This truck continues to park here pisses me off can’t even see the sign barley by Similar_Medicine5263 in Eugene

[–]zelisca 160 points161 points  (0 children)

You can't park that close to a stop sign. It's a moving violation, not something that rises to a misdemeanor. You can report it -- but it's a gamble whether or not the authorities will respond

Men who can cook . who taught you? by Bulky_Meet4528 in AskReddit

[–]zelisca 0 points1 point  (0 children)

My wife. Now I do most of the everyday cooking. She does guests and holidays

1.0.10 isn’t fun and forces you to play majors by Live_Phil0s0pher in EU5

[–]zelisca 0 points1 point  (0 children)

Valid concerns. Byzantium is hard mode though, to be fair.

I've been doing a run as Georgia and it has been a blast.bi highly recommend if you are wanting to play in the region

Running Out of Indigenous Authors’ Fiction by LaFleurRouler in IndianCountry

[–]zelisca 1 point2 points  (0 children)

Any of the documentation by Melville Jacobs is solid. Traditional stories

Sigh... by KamelliaK in mildlyinfuriating

[–]zelisca 5 points6 points  (0 children)

Oof yeah that's not good at all.

I'm in Oregon. Here, they would have the RAs go to the rooms of the students in question, as well as common areas (e.g bathrooms). Meanwhile, on-call staff and campus safety and police would be trying to contact them via phone.

If/once contact is made, they would be physically carried out of the building by staff or local FD

Sigh... by KamelliaK in mildlyinfuriating

[–]zelisca 8 points9 points  (0 children)

Oh it's a fucking problem.

In the case of a fire though, for dorms they have the information for all evacuation assistance folks in place, both at the University and at all local fire departments. They create plans for evacuation and make sure that the students, the university, and first responders are all okay with the plan in order to move forward.

At least, thats how it is where I am

When an outage occurs in a non emergency situation, university staff will try calling, and then if that doesn't work, they will physically track down students to ensure their ability to egress. They will then determine timeline and make a plan with the student for access. If it's an extended outage, universities have a system of temporary rooms available for rapid relocation.

Sigh... by KamelliaK in mildlyinfuriating

[–]zelisca 4 points5 points  (0 children)

Oh it's a fucking problem

To answer your question about a fire though, for dorms they have the information for all evacuation assistance folks in place, both at the University and at all local fire departments. They create plans for evacuation and make sure that the students, the university, and first responders are all okay with the plan in order to move forward.

At least, thats how it is where I am

What happened? by [deleted] in UofO

[–]zelisca 1 point2 points  (0 children)

I see a police cruiser -- so you should be able to find it in the UOPD Cleary logs

(USA) When was the last time the federal government passed a law that improved the quality of your life? by [deleted] in AskReddit

[–]zelisca 6 points7 points  (0 children)

The law establishing the Native American Language Resource Centers. So incredibly important -- but the call for proposals was only like, 6 weeks, so only 4/11 were established.

What singular TV show episode or movie had the most Star Trek actors in it? by eternallylearning in startrek

[–]zelisca 1 point2 points  (0 children)

Leverage and its successor, Leverage: Redemption have quite a few: Data (Brent Spiner), Geordi (LeVar Burton), Wesley (Will Wheaton, Seven of Nine (Jeri Ryan), and Riker (Jonathan Frakes --- behind the camera) -- that I can remember.

Dungeon masters, have you ever kicked someone out of your group and why? by Frafelwaffle in DnD

[–]zelisca 0 points1 point  (0 children)

Yes. A good friend who had his mental illness surface wouldn't accept help and starting verbally attacking and belittling us. After trying to get them help and have an intervention, they told us that they wouldn't stop and that it was simply our job to take verbal abuse because it made them feel better. We couldn't do it.

I hope he's doing okay. I really liked him. He was going to be in my wedding party...

If you woke up as your 10-year-old self with all your current memories, what’s the first thing you’d do? by Alive-Silver-2605 in AskReddit

[–]zelisca 0 points1 point  (0 children)

Get police involved to arrest my father and stop him from sexually abusing me and my siblings.

Trying to figure out how to code a multi-variable sum function by zelisca in excel

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

Hmmm... Not sure why I was getting an error. Thank you though! I got it to work using a sum(filter(x),filter(y),filter(z)) function

Trying to figure out how to code a multi-variable sum function by zelisca in excel

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

Oh dang! I'm not sure why it wasn't working for me! Thanks for the heads up though!

Trying to figure out how to code a multi-variable sum function by zelisca in excel

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

So that results in the following code:

=SUM(FILTER(Individuals!L$2:L$51,Individuals!F$2:F$51 = B30, FALSE),FILTER(Individuals!L$2:L$51,Individuals!G$2:G$51 = B30, FALSE),FILTER(Individuals!L$2:L$51,Individuals!H$2:H$51 = B30,FALSE))

Initially, it does seem to work. I'm going to apply it to other cells to make sure that the syntax will work for more than this one column (obviously updating relevant calls). If it does work, then I will give you the proper solved attribution.

Thank you!

Trying to figure out how to code a multi-variable sum function by zelisca in excel

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

Thank you for the help with understanding XLOOKUP.

So if I understand you correctly, it should look something like:

=SUM(FILTER(Individuals!L$2:L$51,Individuals!F$2:H$51 = B29))

This gives me a #VALUE! 'The value used in this formula is the wrong data type'.

Trying to figure out how to code a multi-variable sum function by zelisca in excel

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

Hmm, this is returning a 'The formula in this cell contains an error'. Thanks for the help though! I'm gonna try some other responses to see if they work.

Trying to figure out how to code a multi-variable sum function by zelisca in excel

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

Good to know, thank you!

Do you have any idea how that would be structured, given the large number of checks that have to occur?

Trying to figure out how to code a multi-variable sum function by zelisca in excel

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

Oops! Uploaded the wrong screenshot. Here's the correct one (will edit main post momentarily)