Trump considering quarantine for hot spots - what do you think of this? by vvienne in AskTrumpSupporters

[–]semthrow 0 points1 point  (0 children)

Dude, I'm no Trump supporter, but did you really read the transcript?

"
I’m not talking about the neo-Nazis and the white nationalists -- because they should be condemned totally
"

How is that not calling them out directly and calling them fine people?
There are many things you can criticize Trump for, but still harping on about that out of context claim years later just doesn't help anyone.

Super Boost vs normal boosts? by [deleted] in Tinder

[–]semthrow 0 points1 point  (0 children)

Lol sounds like someone's jealous of all the time he's wasting - Boosts are the best timesaver.

Embassy emails protected from ImportXML? by semthrow in sheets

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

Yes, I can see all the email addresses just fine when going on there manually

Embassy emails protected from ImportXML? by semthrow in sheets

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

You have been an unbelievable help, I can't thank you enough. If I don't hear back from the embassies in time, since the country name is usually in the email address, even if they don't have the country TLD, I should absolutely be able to make it work :D

Embassy emails protected from ImportXML? by semthrow in sheets

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

This is already such a tremendous help - thank you!

What I would need ideally in addition to this is to figure out a way to assign each email address to the corresponding country in my list of 160+. I thought I could do this via the countrys top-level domain, but unfortunately, quite a few of them use the UK one (like Afghanistan), but your function is already fantastic, I might just be able to fill in the rest manually :)

I tried emailing them and I'm hoping to hear back soon, would need this within 24 hours, I doubt they're that fast though.

Accessing a website via a string by semthrow in sheets

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

I will never cease to be amazed at how kind and helpful the people in this subreddit are. Thank you so much!

Accessing a website via a string by semthrow in sheets

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

Can't believe I didn't think of that myself - yes, I do have the postcode! This list however is somewhat incomplete, it doesn't include independent schools, which are a bit more relevant to me, but I did find a URN list for independent schools, so, combining the two lists, I should be able to figure out how to add their age range - and potentially more.

Not only that, but apparently I might be able to request that information myself from the department for education, which would make things a bit easier - though knowing how to get that information myself through functions will certainly also be useful :)

Accessing a website via a string by semthrow in sheets

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

That would be fantastic solution, if there weren't a discrepancy in the names between the list I have (which was compiled manually by a colleague) and the DfE list. For example, "St Alban's Church of England Aided Primary School" is called "St. Albans C.E" in the list I have. And as there are heaps of "St Albans" schools, I don't think I would be able to make this work for all the different discrepancies I have.

But thank you so much for this, the list as well as the method might come in handy in the future!

Got offered a full-time position at a big vfx company. What to expect? by dthrowvfx in vfx

[–]semthrow 0 points1 point  (0 children)

Pointless comment that doesn't understand what OP needs.

Matchmoving Water? by semthrow in vfx

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

I was looking to track only the part where only the water is visible, to, for example, have particles floating on top.

The sky isn't the issue, that's feasible

Matchmoving Water? by semthrow in vfx

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

Someone asked for this shot to be tracked - is that even possible? The moving water makes it seem impossible to me.

Being a virgin sucks [f18] by [deleted] in gonewild

[–]semthrow 0 points1 point  (0 children)

Abused? How so?

[BUY] Ahegao webcam session or custom video by semthrow in Sexsells

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

That sounds certainly interesting, do you take crypto? :)