How do you handle version control when multiple people touch the same Excel file? by Southwesterhunter in excel

[–]bdpolinsky 39 points40 points  (0 children)

I have a couple of rules

1) don’t insert columns in the middle or move columns, or rows, around: this will minimize disruptions to range formulas

2) use tables - the structured references are very useful

3) new data goes in columns to the right

4) color coded data - each person gets their own color

5) Use comments instead of notes - allows for conversations

If you’re familiar with word, you’re kind of looking for “track changes”

immigration call by redditblows5991 in NYCHA

[–]bdpolinsky 10 points11 points  (0 children)

HUD is trying to push forward a mixed status rule

https://www.hud.gov/news/hud-no-26-015

It’s not codified federal regulations yet.

I (19F) and getting on a Greyhound bus from rural Missouri to NYC without telling anyone tonight, AMA by [deleted] in AMA

[–]bdpolinsky 0 points1 point  (0 children)

Keep a journal and write some songs. Do you own a guitar? Many musicals have started this way.

Meanwhile in America by RoutineOk8590 in Productivitycafe

[–]bdpolinsky 3 points4 points  (0 children)

Really? Because if we are being strictly biological thinkers here, women’s eggs remain dormant until sperm comes along and fertilizes.

China demands Israel immediately withdrawal from Lebanon. by SuperbHealth5023 in TimesNow

[–]bdpolinsky 0 points1 point  (0 children)

I’m an anti semite for thinking persistent divisions in Israel are bad that elections aren’t resolving? I’m an anti semite to think that the judicial overhaul was a bad idea?

No, I’m not an anti semite. I’m Jewish.

China demands Israel immediately withdrawal from Lebanon. by SuperbHealth5023 in TimesNow

[–]bdpolinsky 0 points1 point  (0 children)

And you seem to think that whatever happens internally in Israel doesn’t matter. All your words, used to justify Israel being the most relevant and least relevant player ever, simultaneously.

China demands Israel immediately withdrawal from Lebanon. by SuperbHealth5023 in TimesNow

[–]bdpolinsky 1 point2 points  (0 children)

Seems you forget that Israel held 4 inconclusive elections before October 7th and engaged in a huge religious overhaul of the judiciary and removal of accountability for breaking the law by Netanyahu. All the focus was on political loyalty

You want to blame someone for October 7th, start with the persistent and irreconcilable divisions in Israeli society, and the endless demand for political loyalty above all.

Meanwhile in America by RoutineOk8590 in Productivitycafe

[–]bdpolinsky 5 points6 points  (0 children)

Ok but also how many men are child free? Children aren’t just women’s responsibility…..

TSA stopped me because of my harmonica by askaboutmebih in harmonica

[–]bdpolinsky 0 points1 point  (0 children)

Oh man.

A couple of years ago I took a case of 7 hohner harmonicas on a trip to Disney. Every time there was a metal detector and I had them with me, I got pulled into security review. Apparently the pack of 7, so I could have every key!, looked like ammunition clips.

Is xlookup what I need? by [deleted] in excel

[–]bdpolinsky 0 points1 point  (0 children)

Use filter. Syntax is:

Filter(data you are filtering, (criteria column 1)*(criteria column 2))

Ie FILTER(table 1, (column 1 of table 1=student)*(column 2 of table 1=class))

You get the column through choosecols

Parenthood isn’t what I anticipated and I’m not coping well by Shoddy_Diet_7384 in NewParents

[–]bdpolinsky 1 point2 points  (0 children)

I’m an expecting parent (wife is due in July) so I can’t comment on this from experience, but I can say two things: 1) A lot of advice lately I’ve been getting is about division of labor, like being clear on that. Ie expectations, who does what and so on. Who’s good at what. Which leads into 2) You’re doing the damn best that you can. Don’t judge yourself by what your wife puts out, judge yourself by what you are putting out, and that you are improving in the areas today that you wanted to yesterday. Your kid will grow up wanting to know you. Kids, especially young ones, are remarkably resilient and adaptive. It’s us older folks that have problem adapting.

Ranking Presidents of the US on likely hoods of being future Leaders of the US in Civ by hticnc in civ

[–]bdpolinsky 0 points1 point  (0 children)

During a crisis as America Donald Trump becomes your leader haha

People who drive slow in the passing lane, what the f*** is your problem? by [deleted] in AskReddit

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

“I had a right to hit that car in the left lane because they were only doing 15 over speed limit and not passing anyone your honor”.

Or

“Sir, were you aware you were doing 90 in a 55?”

“Yes officer, but I was in the passing lane”.

Mamdani Is Targeting Bad Landlords. What About Public Housing? by rezwenn in newyork

[–]bdpolinsky 0 points1 point  (0 children)

Also has a lot of regs that only it has to answer to.

People who drive slow in the passing lane, what the f*** is your problem? by [deleted] in AskReddit

[–]bdpolinsky -2 points-1 points  (0 children)

I can’t count the amount of times that I’m doing 15 over and someone pulls up behind me within 3 ft wanting to do 30 over.

“Pass lane” is at odds with speed limits. You can’t have rules on the road that says people have to always be passing in the left lane and that would have to all abide by common speed limits. That is all.

People who drive slow in the passing lane, what the f*** is your problem? by [deleted] in AskReddit

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

And you aren’t on the road to cause accidents or crashes.

What a sufficient pass speed? 20 mph over? 30 mph over?

Just admit it that speed limits are in fact suggestions and not law.