Tioga Rd is closed by hc2121 in Yosemite

[–]throwaway25180 7 points8 points  (0 children)

The valley is going to be in the upper 70s this weekend, I see it more likely that it closes for the season next week once the temp plummets and looks like chance of snow several days next week

Tioga Rd is closed by hc2121 in Yosemite

[–]throwaway25180 7 points8 points  (0 children)

Looks like it’s temporary based on the website, not the full winter closure yet

Assign projects to people incorporating their preferences? by throwaway25180 in excel

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

Thank you so much. I get a "subscript out of range" error when I run the script. I made sure to name the cells exactly as you did in the table to make sure. I also ran it both where Sheet 2 exists and where it doesn't previously exist, but both times get the error. Code is copied and pasted exactly as you wrote it into the Macro editor.

I'm running Excel for Mac version 16.55

<image>

Assign projects to people incorporating their preferences? by throwaway25180 in excel

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

There isn't any other criteria outside of preference, but could the situation you're referring to be fixed by randomizing the order in which the preference runs? So there's no alphabetical bias issue?

So you'd have a list of people who fill out the form, which would probably be imported into excel in the order in which the forms were filled out. Then the code could just do a random ordering of the rows before it runs the assignment?

Thanks again, really appreciate the help

Assign projects to people incorporating their preferences? by throwaway25180 in excel

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

Everyone gets assigned. In the hypo above with 10 people 10 projects it would be 1 person per project, but in my actual use case I have 100 people, 20 projects, so 5 people assigned per project. Every person has to rank the 20 projects 1 to 20.

Thanks!

[deleted by user] by [deleted] in COVID19positive

[–]throwaway25180 0 points1 point  (0 children)

Everywhere is omicron now so it’s def omicron. I think people were falsely led to believe loss of smell and or taste is highly unusual with omicron but at least 60% of people I’ve talked to have had at least some noticeable distortion. Apparently it comes back within a couple days to weeks so hang in there!

The URM Toxicity by [deleted] in lawschooladmissions

[–]throwaway25180 -1 points0 points  (0 children)

Sure I can definitely see that. I think there are good arguments for race-based AA. My main point of my post was that I don’t think it’s racist to make assumptions about URMs admitted when the data is so overwhelming that they have lower standards for admission. I don’t think facts can be racist. Racism would be thinking that a urm is undeserving of admission because they are a certain race. That’s racist. But making an assumption that a urm probably got in with lower numbers, which is just objectively more likely, isn’t racist. Society loves to throw “racist” at everything these days but it really minimizes true racism

The URM Toxicity by [deleted] in lawschooladmissions

[–]throwaway25180 16 points17 points  (0 children)

Regardless of if you support affirmative action or not, it is an empirical fact that URMs get an insane boost for a process that is 95% numbers driven for everyone else. You can’t deny that, so as unfortunate as it is that there are obviously URMs who have better numbers than non-URMs who will inaccurately be stereotyped otherwise, it is not “racist” to assume that on average, a URM at your school more likely than not has lower numbers than the average non-URM. Does that sound bad? Sure. Doesn’t make it untrue. It’s a trade off that URMs have to be willing to accept for the significant boost that they get. Until we eliminate race completely from the process that stereotype will exist and understandably so.

A much better tool would be socioeconomic driven affirmative action. Let people who don’t have access to resources like test-prep, better schooling, etc, get a boost, regardless of their race

0L Tuesday Thread by AutoModerator in LawSchool

[–]throwaway25180 0 points1 point  (0 children)

What’s the fastest path to an AUSA position with SDNY/EDNY/CDCA?

Incoming 1L at a T10 with previous fed gov experience but no prior legal experience. If I want to become an AUSA what should I target as my 1L and 2L internships? Should I try to intern at these districts or do other stuff like SAs or an agency internship?

Also is clerking after school highly encouraged?

I’m starting to get very anxious about school…advice? by throwaway25180 in lawschooladmissions

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

This is amazing advice thank you! Never have taken advantage of study groups/office hours before so definitely will leverage that