At what age did you learn that dinosaur’s have feathers?

2021.11.29 11:07 istoleyourpoptarts At what age did you learn that dinosaur’s have feathers?

submitted by istoleyourpoptarts to AskReddit [link] [comments]


2021.11.29 11:07 ASICmachine Akon unveils new cryptocurrency called Akoin (x-post from /r/Cryptocurrency)

Akon unveils new cryptocurrency called Akoin (x-post from /Cryptocurrency) submitted by ASICmachine to CryptoCurrencyClassic [link] [comments]


2021.11.29 11:07 ShortAlgo $TCRR Watching closely for a Spike with https://t.co/WBARPaK0Cc on TCRR https://t.co/wBtOxdpKOv

$TCRR Watching closely for a Spike with https://t.co/WBARPaK0Cc on TCRR https://t.co/wBtOxdpKOv submitted by ShortAlgo to UltraAlgo [link] [comments]


2021.11.29 11:07 memesandfuckerylol Places to live advice

hello! I hoping for helping on deciding where to live in a couples since I’m moving in with my S.o soon. She goes to school in colton where as I work in a lab in temple city. We decided so go half way and are trying to get 30 min commutes. I thought about pomona or chino hills but not sure what the cost of living is around there . Any advice or information would be great!
submitted by memesandfuckerylol to InlandEmpire [link] [comments]


2021.11.29 11:07 Bcpjw Virgil Abloh Dead at 41

Virgil Abloh Dead at 41 submitted by Bcpjw to streetwear [link] [comments]


2021.11.29 11:07 JohnnyRedSox I got the new Kindle Paperwhite Kids for $1.90 - should I have waited for a better deal? /s

I got the new Kindle Paperwhite Kids for $1.90 - should I have waited for a better deal? /s submitted by JohnnyRedSox to kindle [link] [comments]


2021.11.29 11:07 ASICmachine Near Protocol — The emerging Coinbase backed next generation blockchain platform set to explode in 2022 (x-post from /r/Cryptocurrency)

Near Protocol — The emerging Coinbase backed next generation blockchain platform set to explode in 2022 (x-post from /Cryptocurrency) submitted by ASICmachine to CryptoCurrencyClassic [link] [comments]


2021.11.29 11:07 Bobdmapel Cannot extend conditional formatting across rows, what am I doing wrong?

What I'm trying to accomplish: I want to extend conditional formatting across rows using a formula. Note that I'm going to be granular as to what I do, as that probably has something to do with the problem I'm having -- I just don't know where and when.
So if you have patience, read on. Note that I really, really would appreciate it, as this problem is costing me a ton of time and patience.
Example: Let's say I have this text in cells A1:A4:
https://preview.redd.it/eguheylu7j281.png?width=127&format=png&auto=webp&s=36332d97670366fba4f6526094b58de7a72e6bb4
Based on the text in each cell, I want to color fill cells B1:C4 based on the text. So it should look like this when I'm done:
What I want it to look like after I create conditional-format rules
What I will do is create a rule in B1 then extend it down to B4. Then I will extend the col B to col C.
Let's delete the colors so you know where I'm starting from.
Start state: no rules have been created. This is it -- just text in cells.

_______________________________________________________________________________________________

Create a Rule in B1 Highlight B1 then create the rule. Inside the wizard, when I create the formula, it automatically does an absolute reference to the cell that I'm referencing:
All I've done is create the rule, clicked on A1, and typed '=\"Red\"'
Then I format and hit OK:
https://preview.redd.it/48yekv21bj281.png?width=511&format=png&auto=webp&s=3239b2bfd895029b6ac31197a304404862ca4b27
As you can expect, B1 is now red:
https://preview.redd.it/hhutzax5bj281.png?width=303&format=png&auto=webp&s=02960255bb50f9955936ac71b202334ef8d13b2b


__________________________________________________________________________________________

Extend the formatting from B1 to B1:B4 Then I can do two actions that do the same thing. I can highlight B1 and drag down (like you would a formula), or I can highlight B1, hit Clipboard -> Formula Painter, then highlight B2:B4.
Either way, the conditional formatting extends from B1 to B2:B4. The problem is this: the rule is absolutely referencing A1, so ALL the cells are red:
absolute reference sort of ruins it

__________________________________________________________________________________________________

Edit the formula to remove the absolute reference I'm unable to actually edit the formula in the "edit" text field. It freaks out on me -- all kinds of nonsense starts popping into the field when I attempt to edit it. All I can do is copy the original formula (with the absolute references), paste it into a text editor, edit, and paste back in. Here's what it should look like -- after I've done the editing elsewhere and pasted it back in:
edited the formula to remove abs ref
After I do that, it works:
much better

_________________________________________________________________________________________________

Create additional rules for Green and Blue Next I repeat the process for the other colors, creating two new rules. In the end, this is what I have: rules that work for just one column:
So far, so good -- all I need to do now is extend the rules so they apply from B1:B4:C1:C4

____________________________________________________________________________________________________

Extend rules to other columns This is where I'm stuck. Here's what I've tried.
Most common solution according to interwebs: format painter If you google how to extend conditional formatting rules from one column to another, the most common solution is to highlight the row / cells that you want to extend, hit Clipboard -> Format Painter, then highlight the cells where you want them to go.
It actually works as far as the Rules Manager is concerned. But it doesn't work in that nothing actually happens.
First, I highlight the cells B1:B4 and then hit Format Painter:
select B1:B4, hit Format Painter

Next, with the paintbrush icon active, I select the cells where I want the rules to be extended to.
At this point the rules should be extended, and although the Rules Manager claims that, yes, the rules are extended, nothing actually happens:
what I see after I extend the rules

Let's look at the Rule Manager. This is where I'm a little confused. If I select cells B1:B4:C1:C4, and then hit Conditional Formatting -> Manage Rules, this is what I see:
Cells B1:B4:C1:C4 are highlighted, according to the Rules Manager I have rules for both columns, yet the rules are NOT applied for C1:C4
WTF?!?


_______________________________________________________________________________________________


What else have I tried? If it's been posted on the internet, I've tried it.
The only solution that I can find is to create a new set of rules for each column. The funny thing is is that I end up with the same Rules Manager as you see above, only it works.
In real life I have a metric TON of columns with a metric TON of rules. I spend hours copying and pasting because I have to get it done.
I need help. I'm wasting so. much. time. with this.
What am I doing wrong?!?
submitted by Bobdmapel to excel [link] [comments]


2021.11.29 11:07 PM_ME_GAME_NEWS LF: heart scales, have stones to trade

submitted by PM_ME_GAME_NEWS to PokemonBDSPTrades [link] [comments]


2021.11.29 11:07 supergodmasterforce This popped up on my "Recommended" list on YouTube: How It's Made - Bourbon

This popped up on my submitted by supergodmasterforce to WhiskeyTribe [link] [comments]


2021.11.29 11:07 ASICmachine HODL! MicroStrategy bought bitcoin for $ 414 million (x-post from /r/Cryptocurrency)

HODL! MicroStrategy bought bitcoin for $ 414 million (x-post from /Cryptocurrency) submitted by ASICmachine to CryptoCurrencyClassic [link] [comments]


2021.11.29 11:07 ShortAlgo $ATRA waiting for short signal on ATRA

$ATRA waiting for short signal on ATRA submitted by ShortAlgo to UltraAlgo [link] [comments]


2021.11.29 11:07 tmart2322 Getting the Maximum Value from Combination of Order Lists of Values

Hi Reddit,
Was looking for some guidance for this particular problem that I'm facing (for a website I'm building... not homework related) or for further reading if you know of anything.
Problem:
Given two ordered lists of doubles List A and List B (ordered from largest to smallest) and the sum of a collection of elements from List A (Sum A) and a sum of a collection of elements from List B (Sum B), the following should be true:

  1. Absolute Value of Sum B should be +/- 20% the size of Sum A
  2. Sum A + Sum B should be a non-zero value
  3. Sum A + Sum B should be the highest possible value that also satisfies (1) and (2)
Example 1:
Given: List A: 10, 5, 3 List B: 15, 3, 1
Answer: Sum A = 18 (10 + 5 + 3) Sum B = 19 (15 + 3 + 1)
Criteria: (1) ABS(19) / 18 = 1.05 => ~5% Greater ✓ (2) 18 + 19 = 37 > 0 ✓ (3) 37 is the highest possible value that satisfies the above criteria
Comments: - No exclusions because all criteria can be met with the given values
Example 2:
Given: List A: 50, 10, 5 List B: -9, -3, -2, -1, -1
Answer: Sum A = 16 (10 + 5) Sum B = -13 (-9 + -3 + -1) OR -13 (-9 + -2 + -1 + -1)
Criteria: (1) ABS(-13) / 16 = .8125 => ~19% Less ✓ (2) 16 + -13 = 3 > 0 ✓ (3) 3 is the highest possible value that satisfies the above criteria
Comments: - 50 from List A could not be used in Sum A because no there is no Sum B that is +/- 20% of 50. - Sum B could not be -12 (-9 + -3) in this case because ABS(-12) / 16 = .75 which IS NOT +/- 20% of 16 (it's at 25% Less in this case) - There are two possible combinations for Sum B as they are the exact same summarized value.
submitted by tmart2322 to learnmath [link] [comments]


2021.11.29 11:07 LordArtoriass 3.16 Gauntlet Practice link below

Just made a new SSFSC Gauntlet practice, if anyone wants to join.
https://www.pathofexile.com/private-leagues/join/Toxic+Rain+Champ+DocLeave/OxUi_PdIfOkWONshxBR1
submitted by LordArtoriass to PathOfExileBuilds [link] [comments]


2021.11.29 11:07 ASICmachine 27% of Dutch youngsters own cryptocurrency (x-post from /r/Cryptocurrency)

submitted by ASICmachine to CryptoCurrencyClassic [link] [comments]


2021.11.29 11:07 PotentialFortune NFTs Are More Than Just JPEGs. They Are The Future Of Community, Access, And Ownership

NFTs Are More Than Just JPEGs. They Are The Future Of Community, Access, And Ownership submitted by PotentialFortune to NFTsMarketplace [link] [comments]


2021.11.29 11:07 realityhacker55 Midnight in the Garden of Reddit.

submitted by realityhacker55 to sixwordstories [link] [comments]


2021.11.29 11:07 nosferatu95 Some of my mods, I’m a lime opal fan if that wasn’t obvious

Some of my mods, I’m a lime opal fan if that wasn’t obvious submitted by nosferatu95 to bodymods [link] [comments]


2021.11.29 11:07 ShortAlgo $ATRC waiting for buy signal on ATRC

$ATRC waiting for buy signal on ATRC submitted by ShortAlgo to UltraAlgo [link] [comments]


2021.11.29 11:07 ASICmachine Checking your portfolio way too often? Here's a fix. (x-post from /r/Cryptocurrency)

submitted by ASICmachine to CryptoCurrencyClassic [link] [comments]


2021.11.29 11:07 SlitaLive iCUE H150i ELITE CAPELLIX with LGA 1700 motherboard

hello i was gonna order this cpu cooler above and i was just a little confused if i had to order this additional bracket to make it fit my ASUS Z690 ROG Maximus DDR5 Intel LGA 1700 ATX Motherboard
or if it comes along in the box thanks for the help (and when is it gonna get restocked if i do need it)
https://www.corsair.com/us/en/Categories/Products/Accessories-%7C-Parts/PC-Components/Cooling/ELITE-Series-Retention-Kit/p/CW-8960093
submitted by SlitaLive to Corsair [link] [comments]


2021.11.29 11:07 Wallvents Found Connor.

submitted by Wallvents to ConnorEatsPants [link] [comments]


2021.11.29 11:07 Spirited_Work_4997 💎 Crosswise DEX IDO Presale 2nd Round on BSC 💎| 🌟 Sold out Round 1 with 1.1 Million BUSD Hard Cap 🌟| 2. Round with 750K BUSD Hard Cap | 2Cross-Chain with own Bridge & Gasless Feature & Many Features | Soft Cap Hit after 14 Min | Audited by TechRate & CertiK ⚡

Crosswise is bringing together the best of two worlds: the support and variety of functions you are used to from a centralized exchange and the widespread technical possibilities of a decentralized exchange. They are offering accountability and support on their DAPP which retail investors are missing on other exchanges.
A few Key Points:
⚡️ Ongoing ICO Presale currently at Stage 2 with 0.7 BUSD per Coin
⚡️ Price @ 0.95 USD at launch in December
⚡️ IDO Challenge ongoing: Win 2x 1k CRSS Coins (worth 1500 USD) & every 10. Investor gets his Investment refunded
⚡️ Soft Cap hit after 14 Min. Soft Cap @ 200k BUSD, Hard Cap of Stage 1 hit with 1.1 Million
⚡️ Stage 2 start 25.November 2021 at 8am UTC
⚡️ Audited by TechRate and CertiK:
⚡️ Partnerships with Chainlink & Biconomy
⚡️ Cross-Chain DEX launching in December 2021
⚡️ Experienced DOXXED Team
⚡️ Complex Tokenomics with 2 Coins, whereas one is used for Vesting of Farm Rewards
⚡️ Many unique features, including Gasless Features, Advanced Statistics, Limit Orders with Orderbook, LaunchHub Token Incubation Area, Auto-Compound, Real Live Support and much more
⚡️ Development ongoing for 6 months with strong Dev Team (10 Devs)
⚡️ Founder NFTs for the first 500 Investors
Tokenomics:
🚀Ticker: $CRSS
🚀 Max Supply: 50 Million
🚀 Emission after Launch: 1.2 per Block for 14 Days, 1 after 14 Days
🚀 8% Emission going to Dev/ Marketing Wallet
🚀 Farm rewards getting vested within 5 months with 20% unlocked every month
🚀 Deflationary mechanisms: 0.1% fee on Coin for Buyback/Burn, 5% Fee on Profits from Auto Compound, and much more
🚀0.2% Fee on Swaps, 0.3% Fee on Cross-Chain Swaps with Bridge
🏷️ Contract Address: 0x7C90E681F25BD248aDB105f05f36d3844759cf21
Pancakeswap: https://pancakeswap.finance/swap?outputCurrency=0x7C90E681F25BD248aDB105f05f36d3844759cf21
🔹 Renounced Ownership: https://bscscan.com/token/0x7C90E681F25BD248aDB105f05f36d3844759cf21#readContract
submitted by Spirited_Work_4997 to CryptoMars [link] [comments]


2021.11.29 11:07 AutoNewspaperAdmin [Entertainment] - Chicago-area theaters offer eclectic mix of shows for the holiday season | Chicago Sun-Times

[Entertainment] - Chicago-area theaters offer eclectic mix of shows for the holiday season | Chicago Sun-Times submitted by AutoNewspaperAdmin to AutoNewspaper [link] [comments]


2021.11.29 11:07 ASICmachine Bitcoin to touch half a million in the next 10 years: Michael Terpin (x-post from /r/Cryptocurrency)

Bitcoin to touch half a million in the next 10 years: Michael Terpin (x-post from /Cryptocurrency) submitted by ASICmachine to CryptoCurrencyClassic [link] [comments]


http://sdobacafe.ru