2022.01.26 16:51 Ok-Praline-2940 I want a bear friend, and it is not a stupid goal.
Bears are awesome. I want grizzly bear that can be my best friend, and can live in the forest with me. Of course, I don’t want it captive, so it’ll do it’s thing and come and visit when it wants. It will be my brother from a different mother, and our adventures will be legendary.
To everyone saying “it is dangerous,” and “grow up.” I am a grown boy and can make my own decisions. If bears were really so dangerous, why are they shaped like friendship? Really? They are what I think of when I think friendship. How can a friendship shaped creature be dangerous. I’m not trolling when I say, I would rather die to the hands of a bear than live a life without one.
P.S. I am talking about the animal, not the hairy gay men.
submitted by Ok-Praline-2940 to The10thDentist [link] [comments]
2022.01.26 16:51 hendriredd Ho-Ri Type III, first M on it. Amazing tank. Definition of a t.d made for carrying teams all the way to victory.
|submitted by hendriredd to WorldOfTanksBlitz [link] [comments]|
2022.01.26 16:51 FrontpageWatch2020 [#338|+965|12] And then this happened [r/rickandmorty]
2022.01.26 16:51 realHadAdo Pretty sus ngl
|submitted by realHadAdo to linuxmemes [link] [comments]|
2022.01.26 16:51 GrimClippers11 If then but if a cell is blank skip row
It's been quite some time since I've done much with sheets or excel, so forgive my ignorance. I am I have a master sheet that I am trying to break down into smaller more pertinent sheets. Currently I'm using =IF function, but that will only import is the same row in the master has the key phrase. I would like to be able to condense information so that are not a bunch of blank rows. I had thought to use =Query, but the sheets are 90% text. I'm sure there is an easy way to do it, but the correct phrasing alludes me. My current formula is below.
=IF('Master sheet'!$D:$D="keyword",'Master sheet'!A:A,"")
Any help would be greatly appreciated.
submitted by GrimClippers11 to sheets [link] [comments]
2022.01.26 16:51 madbobofruit I'm going to become the joker
submitted by madbobofruit to okbuddyvowsh [link] [comments]
2022.01.26 16:51 DefinetlyNotTooLong Cant join official discord
I tried joining the discord through the invite link which opened it on my unclaimed browser discord account and i now cant use the link to join on my standard discord. How can i join it o.O
submitted by DefinetlyNotTooLong to R6Extraction [link] [comments]
2022.01.26 16:51 TheFlintASteel F
|submitted by TheFlintASteel to whenthe [link] [comments]|
2022.01.26 16:51 thatviralvella Huuu
|submitted by thatviralvella to dankindianmemes [link] [comments]|
2022.01.26 16:51 PotatoUmaru They accomplished their mission to stop working
|submitted by PotatoUmaru to ConservativeMemes [link] [comments]|
2022.01.26 16:51 ColTrks $LAB ⚗️ Labswap | DEX Live on | Stake & Yield Farming Incoming | DeFi | Organic Grow | Low Market Cap | Huge Potential | 0% Tax fee | Don’t miss this rocket 🚀
🧬The Labswap ecosystem is expanding!! Our decentralized exchange (DEX) and automated market maker (AMM) Live on! Stake & Yield Farming Launching coming soon!
🧪Our staking and other DeFi features will further increase the demand and reduce the supply, while continuing to enable growth in value through staking and NFTs.
🧫With our yield farm, you will be able to get more benefit from your Labswap. Because our token ($LAB) is not exploitable, we may adopt a dual token mechanism and use an alternative token to make profits.
$LAB is a decentralized finance (DeFi) token that operates on the Binance Smart Chain (BEP-20).
The token was launched with an initial 10B (billions) tokens 0% Tax fee
✅ We are already launched on pancakeswap!
Token symbol: LAB
Maximum supply: 10,000,000,000
Network: Binance Smart Chain \\\BSC\\\
● 60% for Liquidity :. 6,000,000,000
● 10% Marketing :: :. 1,000,000,000
● 10% Ecosystem :. 1,000,000,000
● 15% Exchange Listings :. 1,500,000,000
● 5% for Core Team :. 500,000,000
Don’t miss this moonshot! Join us before FOMO!! 🚀
📲 Twitter: https://twitter.com/labswap_io
🌐 website: https://www.labswap.io
submitted by ColTrks to CryptoMoonCoins [link] [comments]
2022.01.26 16:51 FADEDTOMONOCHROME HELP
The only remaining moderator of the CharaNeutralistSquad, u/PunchFrog, is refusing to allow me access to my subreddit as a mod while under a new account. Ive tried talking to them, but they just made a samsung smart fridge joke after leading me on for a few hours. I know this probably breaks a few rules, but i need my subreddit back! Its fallen into a disorganized mess, and nobody can post without permission, even! This wasn't what I made my sub to be! Please help!.
submitted by FADEDTOMONOCHROME to Undertale [link] [comments]
2022.01.26 16:51 FrontpageWatch2020 [#303|+1758|401] [Superintendent]: 'Furries' are not using litter boxes in Midland school's bathrooms [r/nottheonion]
2022.01.26 16:51 BicycleOk3465 MTK Global On Everipedia
|submitted by BicycleOk3465 to Everipedia [link] [comments]|
2022.01.26 16:51 RLCD-Bot [Breakout Type-S] [Cobalt Breakout Type-S: Mobo] [Sky Blue Ion] [P-SIMM: Inverted] [Cobalt Lightspeed]
|submitted by RLCD-Bot to RLCustomDesigns [link] [comments]|
2022.01.26 16:51 yollysabra Love Pairing My Stirrup Leggings with Stilettos ☺
|submitted by yollysabra to stirruppants [link] [comments]|
2022.01.26 16:51 JRepin Steam Deck Launching February 25th
|submitted by JRepin to technology [link] [comments]|
2022.01.26 16:51 thewhatpodcast The What Podcast’s 2022 Festival Lineup Rankings: Coachella, Shaky Knees, Bonnaroo, and more
|submitted by thewhatpodcast to festivals [link] [comments]|
2022.01.26 16:51 where_is_carmen My brain everyday with ADHD (Honey, I'm Going on Strike)
2022.01.26 16:51 Chronic_haze What to put in loot chests
I'm building my first playable dungeon on my isle of siptah rp server and would like advice on what to put in the loot chests as I don't want to go overboard but would like better prizes then what siptah likes to hand out. Thank you all in advance for your advice
submitted by Chronic_haze to ConanExiles [link] [comments]
2022.01.26 16:51 DifficultFox1 Tom’s Goblin ain’t so smart 🤣 it is enjoyable seeing her so triggered.
|submitted by DifficultFox1 to 90dayfianceuncensored [link] [comments]|
2022.01.26 16:51 Tikkanen SI: Teaming up with wife Beth Phoenix is a dream come true for Edge - A decade ago, Adam and Beth Copeland were retired from wrestling. Now they’re teaming up for a match together at the Royal Rumble
2022.01.26 16:51 Jending What Makes the Gary Gensler Video So Important
If you don't already know, there's a landmark case currently being adjudicated in the Southern District of New York, here in the United States. It's Ripple vs the SEC, and the outcome is expected to impact every cryptocurrency there is. More details here:
Without paywall here:
Basically, the SEC accuses Ripple of selling unregistered Securities. Among other things, Ripple counters by invoking a Fair Notice Defense - essentially saying they never had reasonable fair notice that selling XRP was selling an unregistered Security:
Recently, the SEC filed a motion before District Judge Analisa Torres and Federal Magistrate Judge Sarah Netburn to strike the Fair Notice Defense; observers expect a "bazooka" ruling in the next few months:
It's a monumental decision.
If Ripple loses - if a legal precedent is established that they knew or should have known that selling their coin was selling a Security, then it's safe to assume other developers of other coins knew or should have known it too. According to this attorney, that includes every last one:
Because I think it's important to do your own research - you know, DYOR - I've spent the past few months reading about and listening to various cryptocurrency conferences most people never even knew existed. Some occurred years ago. Instead of watching football, I spend my winter weekends scrolling through YouTube, Bloomberg, and other social media sites, searching for some sort of Fair Notice given to Ripple.
But I don't regret it. Because this is the video I found:
This Bloomberg Conference convened in 2018, and one of their speakers was Gary Gensler, currently the Chairman of the Securities and Exchange Commission here in the United States - the SEC. At the 38:45 mark, you can watch and hear him refer to Ripple as a Security because it passes all four prongs of the Howey Test - but he qualifies his remarks by saying "probably". Well, that's probably not enough evidence to convince a Federal Judge Ripple had reasonable fair notice selling XRP was selling a Security.
However, if you skip to 48:34, you can watch and hear him answer a question by definitively explaining what DOESN'T qualify as a Security. At the risk of making this an extra long post, I'll transcribe it here:
"I think you're talking about Mr. Hinman. At the Securities and Exchange Commission, what they basically said is while ETH, the token under Ethereum Network, may well have been a Security in 2014, he's careful in his words, he was very careful in his words, he said it has now become sufficiently decentralized, and I appreciate that. That was a regulatory trade-off. I, for one, think there's a pretty good case, that even today, it's still so centralized. But I respect his view on that.
I think it's basically - is there some central group of players that have an asymmetric advantage of information. And he talked in that speech about asymmetry of information. Think about if there's an issuer who basically still controls a network, either because they legally control it, or they control the nodes - the various nodes in the network - or they could just easily 'bigfoot' it, because they have the development standing.
In essence, if the Ethereum Foundation went away, would the Ethereum Network and ETH, still have some standing? And what the SEC felt - probably would. But on the other hand, if many of these others - the company behind EOS, for instance, or the company behind Ripple, or the company behind Tezos, or Faultcoin, etcetera, etcetera - went away, would the network.....Like, by a show of hands, who would really want to hold any of those tokens if the development team went away, and that's, I think, the 'duck test' to centralization. Would you want to hold the token if the central core team around EOS or Ripple or Tezos or Faultcoin went away? Whereas on Ether, they're saying - probably enough there, now, that it's decentralized.
Does that help?"
Sure does Gary.
Because it doesn't appear he's accurately describing Ripple, or Ethereum, or Binance Coin, or Safemoon, or Shiba Inu, or any of these other coins with promoters and third-parties. However, it certainly does appear he's definitively describing Iron Titanium Token - TITAN!
Remember, after the first "bankrun" in de-fi history, Iron Finance - the developer of TITAN - "went away", by simply abandoning the coin. They renounced ownership of the contract, and burned the minting keys:
Now, please understand - this description of TITAN, this opinion, isn't coming from some bartender somewhere, or even your local tax attorney; it's coming from the head of the SEC himself, the Chairman, the Big Boss, the guy who makes decisions. It says everything we want it to say from the man we want to say it! It's a gift on a silver platter, a diamond in the rough. Hell, if Ripple loses, or if the SEC even negotiates a settlement that preserves their right to go after other cryptocurrencies, it's our Get Out of Jail Free Card!
In short, it makes TITAN a hedge - actually THE hedge - against regulation. And don't be fooled - regulation is coming. This is the latest on Ethereum:
So right now, I think TITAN is more valuable than any of these other coins. But please take that for what it's worth - that's coming from a bartender.
submitted by Jending to TitanCommunity [link] [comments]
2022.01.26 16:51 xhoneychiix Possible change to the Super Stylist offer
I just noticed it changed from 2000sb to 2500sb, but I've heard people tried and gave up since it was impossible to get to level 50. Just wondering if people think the offer might change too
submitted by xhoneychiix to SwagBucks [link] [comments]
2022.01.26 16:51 DarkDutchDemon Monstercat Silk Showcase 631 (Hosted by Sundriver)
Every Wednesday 12AM PDT / 3PM EDT / 9PM CET
Watch on the Monstercat Radio
Listen to past episodes of Monstercat Silk Showcase!
Tweet with #MSSRadio
Share the tracklist: monster.cat/MS631
submitted by DarkDutchDemon to Monstercat [link] [comments]