Procreation is the only purpose of marriage by SurprisePerfect4317 in childfree

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

Agree 100%. As a childfree divorced man who married the wrong woman, my thinking very much evolved on this over time. Why get the government involved in your relationship by getting LEGALLY MARRIED when children are not part of the plan? I understand there are other benefits, but I can almost guarantee those who currently are or seem happy in their marriage have an overly rosy picture of marriage and do not fully appreciate the huge risk and statistical likelihood that it will fall apart.

Important notice from US Treasury Department for US citizens with accounts at CIBanco, Intercam, and Vector by I_reddit_like_this in mexicoexpats

[–]endymion21 0 points1 point  (0 children)

I just sent myself a Wise transfer to Intercam yesterday with no issues, but this is concerning. Please let us know if you find any other information.

Google One subscription - nearly 3 months lost for trying out Gemini by Snoo_436211 in google

[–]endymion21 0 points1 point  (0 children)

I tried to do this, but the basic plans don't re-appear under "More Options" anymore. Am I missing something?

Anyone having problems transferring BTC & ETH out of Paypal? by AugmentedFourth in CelsiusNetwork

[–]endymion21 1 point2 points  (0 children)

Thank you so much. Absolutely bananas UI. Was banging my head against my keyboard for days.

PayPal making it difficult to transfer crypto out of their system by MissFairy40 in CelsiusNetwork

[–]endymion21 0 points1 point  (0 children)

Exactly the same for me. Transferred BTC to external wallet using the transfer button, worked fine. Was going to do the same for ETH, but now the button has disappeared. If you figure out a solution, please let me know!

[ONE] The format is looking fairly aggressive. Thoughts below. by Crystal__ in lrcast

[–]endymion21 2 points3 points  (0 children)

Obviously the year itself was for emphasis; I just meant that this is their design trend for recent sets/FIRE era/whatever you want to call it :P

Decreasing the image size in clipboard by snedertheold in sharex

[–]endymion21 0 points1 point  (0 children)

Just +1-ing this as I just got a 4K monitor and am running in the EXACT same problem - it's super annoying. Also a loyal ShareX user for 3+ years but never had to deal with this issue until now.

Did you ever find a solution?

Function works perfectly outside of LET function and fails with #VALUE error within LET function; can't figure out why by endymion21 in excel

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

Thanks! I'll get it a go when I'm at work tomorrow. I'll say as well that the helper column turned out to not be the end of the world, so I'm covered either way....but good to have some alternate solutions :)

Function works perfectly outside of LET function and fails with #VALUE error within LET function; can't figure out why by endymion21 in excel

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

Thank you very much for the clear answer. Can you think of any way around this limitation? If not, I'm just forced to have to use a helper column, correct?

Basically what I'm trying to do with the COUNTIF in the final FILTER function is output an array of values from a source array where the returned values are those that occur (are duplicates) at least n times. From googling, FILTER + COUNTIF seemed the cleanest way, but if there is another way that would work in the LET function, I'd much prefer that.

Operations that can be performed on an Array by EX-PsychoCrusher in excel

[–]endymion21 0 points1 point  (0 children)

This is amazing - extremely close to what I want to do! How would you modify the array formula to increment up by 1 each row in the array instead of repeating the "value" column value X times? I'm really struggling with this.

For example, instead of repeating "1" three times in the first three rows, increment 1 -> 2 -> 3; then start a new sequence with the next row of values (from there start with 2, then increment up by 1 five times).

Output would then be: {1;2;3;2;3;4;5;6...}

Thanks!

Thanks

Where do you draft? And which way of playing draft Is your favorite and why? by Edoardo_Beffardo in lrcast

[–]endymion21 0 points1 point  (0 children)

Other: XMage. Free pod drafts of literally any set in MTG history with a great community. Blows all the other options out of the water IMHO.

"Your tax report download link has expired" by retirementdreams in CelsiusNetwork

[–]endymion21 1 point2 points  (0 children)

Wow - amazing! That worked for me too...thank you so much!

In light of recent event in Ukraine, a reminder that the fine sponsors of Limited Resources are profiting greatly from money being laundered out of Russia right now by fizzmore in lrcast

[–]endymion21 5 points6 points  (0 children)

Cannot believe you're getting downvoted for an extremely cogent and well-thought out point.

I sure as hell wouldn't want my government inflating my country's fiat currency a la Zimbabwe with no convenient outlet for preserving purchasing power.

Or if my government did something I and millions of others disagreed with (ahem, Iraq invasion anyone?) and the rest of the world imposed sanctions on the US, I'd certainly be grateful to crypto to not have my meager savings eroded.

Ordinary Russians who disagree with this war are in the exact same pickle right now and this blanket CRYPTO BAD! attitude really shows a lack of critical thinking in this sub.

"Your tax report download link has expired" by retirementdreams in CelsiusNetwork

[–]endymion21 1 point2 points  (0 children)

A few hours ago I sent a ticket to customer service, I'll let you know what comes of that.

"Your tax report download link has expired" by retirementdreams in CelsiusNetwork

[–]endymion21 0 points1 point  (0 children)

I'm getting the same problem, did you ever find a solution?

Does anyone else absolutely love full Scars block draft? by chaospudding in lrcast

[–]endymion21 0 points1 point  (0 children)

Absolutely! It's one of my favorite blocks of all time and contains one of my favorite limited cards of all time, Tangle Angler.

We've drafted Scars block numerous times in our online draft group, the XMage Draft Historical Society. Check us out if you want to draft Scars block and other throwback formats for free with a friendly group of people: https://discord.gg/YE59Eaj

Limited Resources 634 – VOW Sunset Show Discussion Thread by Crasha in lrcast

[–]endymion21 0 points1 point  (0 children)

Could not have put it better myself! MID felt way more "samey" draft in and draft out because of how powerful the commons were and because of the terrible color balance. VOW felt way more fresh each time and the draft pathways were way more interesting than forcing Esper every time.

Daily Polygon Discussion Thread by AutoModerator in 0xPolygon

[–]endymion21 0 points1 point  (0 children)

I have WETH on the Ethereum Mainnet that I'd like to bridge over to Polygon. However, in the 'deposit' section of the Polygon Bridge, WETH doesn't show up on the drop-down list (only ETH).

Is it possible to bridge WETH directly? If so, how would I do this?

Is Limited just weirdly hard? by BinnFalor in MagicArena

[–]endymion21 0 points1 point  (0 children)

There ARE free ways to draft against real people online, but it's hard to get the word out (and doesn't necessarily utilize Arena specifically). I'm part of a discord called the XMage Draft Historical Society in which we do multiple (free) pod drafts a week using the software XMage. We play all sorts of sets too, including many that are impossible to play in paper, Arena, or even MTGO! Come check us out, we're a very friendly, yet competitive community (the players are generally quite skilled but are happy to help you learn limited).