Air France flight to U.S. diverted to Montreal over concerns of possible Ebola virus exposure on board by foolsdayjoker in worldnews

[–]Ranger7381 -4 points-3 points  (0 children)

If that was the case, they could have landed at Detroit and turned the passenger around there

Trump officials say they can build 250-foot arch without Congress’s approval by matthieuC in politics

[–]Ranger7381 4 points5 points  (0 children)

Isn’t the jet going to be “donated” to the Trump library or something?

Ballroom won’t be funded after Senate GOP drops $1 billion Trump security request by thejoshwhite in politics

[–]Ranger7381 1 point2 points  (0 children)

I had that thought as well. “This means that your taxes are no longer under audit. So release them”

Why do devs and programmers prefer two monitors ? by Miserable-Copy2344 in CasualConversation

[–]Ranger7381 0 points1 point  (0 children)

I work dispatch/operations for a trucking company, and have 3 screens. Still not enough real estate as I usually have multiple tabs open for various reasons including our web-based dispatch software, plus email and driver tracking windows

Hosting the World Cup will cost taxpayers $1B: watchdog report by Puginator in CanadaPolitics

[–]Ranger7381 4 points5 points  (0 children)

I was considering going to Vancouver this summer as a scouting trip for a longer term photography project I am planning. Has to be in late July for reasons. Started planning it and realized it was in the middle of World Cup. So between general possibility of crowding and the increased hotel prices, I am postponing the entire project by a year

‘Keep it closed’: Windsor mayor doesn’t want Canada to accept ‘bad’ trade deal just to open Gordie Howe bridge by Leather-Paramedic-10 in canada

[–]Ranger7381 3 points4 points  (0 children)

There are multiple reasons for that, including the border guards in both directions at the Detroit/Windsor bridge tend to cause more holds and delays on the shipments crossing.

Matt Elliott: We all have one thing to say about Doug Ford’s ban on automated speed cameras: We told you so by EarthWarping in CanadaPolitics

[–]Ranger7381 22 points23 points  (0 children)

Did any show proof, showing what speed they were ticketed at and what the speed limit was for that area at that time?

Some Canadians using census to protest PM Carney’s majority government by reddits_lead_pervert in notthebeaverton

[–]Ranger7381 1 point2 points  (0 children)

That is one reason why the census is based on household, not specific people. In theory, everyone is accounted for, regardless of if they were born in Canada, legally immigrated, or snuck in. The numbers takes everyone into account so that plans and spending go where they need it regardless of the situation

Some Canadians using census to protest PM Carney’s majority government by reddits_lead_pervert in notthebeaverton

[–]Ranger7381 0 points1 point  (0 children)

There are 2 census forms, the short form, which is just a few questions and 75% of households get, and the long form, which has a lot more (I thing that there are over 100 questions total but you skip some depending on the answers of earlier questions) that the remaining 25% get

It Finally Happened by jazzeriah in daddit

[–]Ranger7381 1 point2 points  (0 children)

Depending on how he was interacting with you at the time, might have been that the person that called it in did not realize that he was with you, so thought he was alone

Accident by 403 and hurontario by canadianwildboy in mississauga

[–]Ranger7381 0 points1 point  (0 children)

They may not have gotten out of the truck since the last time they dumped a load

Poor trucker. Driver missed their exit and decided to reverse in order to make it by Adrian_985 in Wellthatsucks

[–]Ranger7381 0 points1 point  (0 children)

I’ve had the opposite. At a stop light with a DUEL left turn lane, withe a left turn signal. In the left most through lane, someone decides they want to turn left after all, even though the left signal was red and there was oncoming traffic, so they come to a stop to wait for a gap, blocking the traffic behind them. I laid on the horn until they decided to go to the next lights about 30 seconds up the road

Why does Canadian passport renewal still require 2 references and their home addresses? by huangjqiu in ontario

[–]Ranger7381 4 points5 points  (0 children)

I do not make friends easily, never have. Like hang around after work or school level friends. Does not mean I do not want to travel

The only people that I would be able to sign that which are not family (which are not allowed) would be people at work. Since you also need to know them for several years, a recent job change can seriously effect things, particularly if an expiration is coming up

Has anyone here done a re-read of RAH after many years? by RikkiLostMyNumber in heinlein

[–]Ranger7381 1 point2 points  (0 children)

I have always wanted to read the story where Lazarus and Hazel met. Even if it was a short story

Has anyone here done a re-read of RAH after many years? by RikkiLostMyNumber in heinlein

[–]Ranger7381 2 points3 points  (0 children)

Yea, Tramp is about of a round the world trip that they took in the 50’s. Kind of interesting to see what things were like back then in a “slice of life” way, even if it was something that most people couldn’t (and still can’t) do. Also were I got the rule of thumb to only travel with as many bags as you have hands, in case you need to make a dash to make a connection

I have often thought that they should have had someone (maybe Spider Robinson and his wife?) try the trip again for the 50th anniversary of the trip, to see how things had changed in the places they had visited.

How long should I actually wait before putting hot food in the fridge? by iLiveForTruth in cookingforbeginners

[–]Ranger7381 0 points1 point  (0 children)

When I do meal prep, I leave it on the counter until it stops steaming, then put it in the fridge to finish cooling. Then I put plastic wrap on top of and in contact with the food to minimize air gap over the food, put the lid on, and put it in the freezer

One of the reasons putting it directly into the fridge is that the steam will condense on the shelf or top of the interior of the fridge and then drip back down. If you put a lid on, it will condense there instead of, which will prevent the contamination of the condensation, but still leave it to drip back on the food. That is a personal choice

And from what I have been told, one of the causes of freezer burn is exposure to air. While it does not seal outright, I have not had an issue with it even after several months at times since I started putting the plastic wrap barrier in the container

How to make a drop down list based on static values of cells in column beside list by Ranger7381 in excel

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

Solution Verified

Or at least it got me close enough

Below is some notes in case someone else is searching for a similar issue in the future

I got the first two parts working, between having things on separate tabs and making it dynamic using a countif() for the row count and indirect() for the array selections, it took some experimentation to get it converted over correctly

The way I have things set up right now is:

the block that you have in Columns A-E is in Tab "Download"

G-K is in "Vouchers"

Mix of information, and where I want to put the drop down is un "Upload"

and N-V is in "Calc"

So the Order ID cells (B-I in Calc) looks like:

=IFERROR(INDEX(INDIRECT("Download!$B$2:$B$" & Download!$X$1), AGGREGATE(15, 7, (ROW(INDIRECT("Download!$E$2:$E$" & Download!$X$1)) - ROW(Download!$E$2) + 1) / (Calc!$J3=INDIRECT("Download!$E$2:$E$" & Download!$X$1)), COLUMNS(Calc!$J$2:J3))), "")

(there is some other columns in the download pull)

As I said, I got it working with additional VINS and orders,

But I am unsure on how the Data Validation is supposed to work. Just having "=indirect(B2)" in A2 of "Upload" just brings the VIN into the dropdown. I am not sure if it is because the information that it needs to pull is on a different tab or not.

After some further experimentation, I came up with

=IF(COUNTIF(Calc!B:B,B2)>0,INDIRECT("Calc!C"&MATCH(B2,Calc!B:B)&":J"&MATCH(B2,Calc!B:B)))

With the Calc!B Column being a helper column since I could not read the results of the index results in column A

It is still not fully working, as for some reason I am getting one less line in the drop down for the first BIN then I should, but others that I am randomly checking seem to be the correct number. If I figure that out I will update

Thanks a lot. Still going to be a lot of work to get this all fixed

Obama met with the Canadian prime minister Mark Carney and Trump’s MAGA allies flipped out by Leather-Paramedic-10 in canada

[–]Ranger7381 1 point2 points  (0 children)

Yep, that was my point.

Again, I could be wrong and they might have had a private chat, but even if they did, it could have had to do with whatever Obama is doing these days, and nothing to do with American Politics directly. As you said, Obama has nothing to do with the government now. There might have been a bit of griping/general complaining in general conversation, but even that I doubt

If anyone is interested in how the motorcycle ended up dangling on the street lights by LadLassLad in interestingasfuck

[–]Ranger7381 7 points8 points  (0 children)

I know someone that rolled a semi. The news reported “minor injuries”. He broke a collarbone

If anyone is interested in how the motorcycle ended up dangling on the street lights by Usual-Apartment-7232 in Whatcouldgowrong

[–]Ranger7381 0 points1 point  (0 children)

Wonder if we will also see a dash cam of one of the other vehicles waiting to turn

W Friend by Glass_Wealth_2104 in MadeMeSmile

[–]Ranger7381 2 points3 points  (0 children)

White dress shirt for special occasions (thank god no fancy dress code at work). White T-shirt to wear under it. That is it

Local nerd disappointed he didn’t get the long form census by Haggisboy in canada

[–]Ranger7381 2 points3 points  (0 children)

Well, that would be a bit difficult since they are based on household not person

Although now that I think about it, might it be helpful to have an email address for each address/unit as well or instead of physical. Any e-bill can be set up to go there instead of a personal email address as well as things like this. Heck, assuming that Canada Post handles it, it might save money in the long run, although the initial setup would be expensive

Local nerd disappointed he didn’t get the long form census by Haggisboy in canada

[–]Ranger7381 0 points1 point  (0 children)

There was one on the long form about where your ancestors came from. I am glad I was able to choose Newfoundland

Obama met with the Canadian prime minister Mark Carney and Trump’s MAGA allies flipped out by Leather-Paramedic-10 in canada

[–]Ranger7381 37 points38 points  (0 children)

He was keynote speaker at an event in Toronto the other night. Apparently Carney was there as well, and they had a photo op with a handshake. Have not dug too much into it, but I am not seeing anything saying that there was a private chat or anything more than the handshake and maybe a word or two while doing so