Wide receiver George Pickens is thriving with the Dallas Cowboys this season. Pickens has more receiving yards through 10 games this season than he had in 14 contests last year. He has also set a career high with seven touchdowns. That’s led some pundits to criticize the Pittsburgh Steelers for trading Pickens before the 2025 NFL season. The Steelers sent Pickens to the Cowboys for a 2026 third-round pick. In his most recent admission to the media, Pickens explained he understood the trade and explained he views the Steelers organization very positively. The receiver also suggested he is still on good terms with head coach Mike Tomlin. “I can call up Coach T [Mike Tomlin] right now, and we’d have a real conversation,” Pickens wrote in The Players’ Tribune on Friday. “What I respect about him most is he always told me, ‘Just keep being you, George.’ “It just wasn’t the long-term fit for where my journey was headed, and that’s ok.” George Pickens Speaks out on Steelers Departure Previously, Pickens has indirectly put the Steelers on notice about his exit from the team. In August, the receiver told NFL Network’s Jane Slater that the trade to Dallas “was good for” him. That comment angered Steelers Nation a bit. But Pickens may have not really meant that comment as a diss at the Steelers. The wideout appeared to put those comments in better context while addressing his Pittsburgh tenure in his article this week. “Everything started off so good, too. I had the one-handed catch in my third game, and y’all know the numbers,” Pickens wrote. “Second year, 1, 100 yards. I don’t gotta bore you. “But I was still a kid. I made some mistakes. I’ll own that. I let my emotions get the best of me a few times because I’m always riding that line. That’s just who I am. I’ve tried to learn from it and grow while still being ME.” The Steelers acquired DK Metcalf and signed him to a 4-year, $132 million extension. Pickens wrote that at that time, he knew his time in Pittsburgh was coming to an end. Even then, though, the receiver suggested the two sides remained respectful through the trade to Dallas. “They did right by me,” Pickens added. “They sent me to the perfect spot in Dallas. What more do you want me to say? “There’s no drama, bro. No headlines to write. THey’re doing their things way up there, and I’m down here in Dallas with CeeDee and Dak doing what I do best. Everybody wins.” Pundits stirring hot takes that the Steelers lost the Pickens trade will disagree. Yet, it’s still hard to argue with that sentiment. While the Steelers could use a better WR2 this season, Pickens wouldn’t have been the right fit. In 2025, he would have taken a back seat to Metcalf and the multi-tight end set offense, which likely would have frustrated him to no end. Instead of that potential drama, the Steelers traded Pickens for draft capital that could help the team land a future franchise quarterback. Will Pickens Stay in Dallas? The Steelers clearly didn’t have Pickens in their long-term plans. The question, though, is do the Cowboys plan to keep the receiver beyond 2025? Pickens’ rookie contract will expire at the end of the season. He will be an unrestricted free agent in March. The Cowboys already have about $65 million to the salary cap dedicated to quarterback Dak Prescott and fellow receiver CeeDee Lamb. Spotrac projected Pickens’s market value at $29. 4 million for his average annual salary. Dallas could place the franchise tag on Pickens. According to Over The Cap, though, that would only save the team about $1. 3 million. Pickens seems to have matured over the last year, but he hasn’t been completely drama free in Dallas. Cowboys insider Clarence Hill Jr. reported the receiver didn’t make the team bus last week in Las Vegas. Hill implied that could become a factor in his contract negotiations. Overall, though, there’s been a lot of positivity about Pickens staying in Dallas after this season.
https://heavy.com/sports/nfl/pittsburgh-steelers/george-pickens-nfl-news-mike-tomlin/
All posts by admin
BTC Price Prediction: Sharp Rebound to $95,000-$100,000 by December 2025
BTC Price Prediction: Technical Setup Points to December Recovery BTC Price Prediction Summary • BTC short-term target (1 week): $88,000-$90,000 (+4-7% from current levels) • Bitcoin medium-term forecast (1 month): $95,000-$100,000 range • Key level to break for bullish continuation: $90,000 resistance • Critical support if bearish: $80,600 (strong support level) Recent Bitcoin Price Predictions from Analysts The latest BTC price prediction landscape reveals a divided analyst community. While CoinLore’s short-term Bitcoin forecast projects a decline to $83,176 by November 23rd, their long-term outlook remains aggressively bullish with a BTC price target of $195,067 by 2026. This stark contrast highlights the uncertainty in current market conditions. Derive. xyz presents a more conservative view, suggesting a 50% probability that Bitcoin will end 2025 below $90,000, with only a 30% chance of breaking $100,000. However, Fundstrat’s Sean Farrell offers the most compelling contrarian perspective, identifying Bitcoin’s approach to a critical value zone that could trigger a sharp rebound. The consensus among these predictions suggests that while near-term weakness is possible, the technical setup increasingly favors a recovery scenario, particularly given Bitcoin’s oversold conditions. BTC Technical Analysis: Setting Up for Oversold Bounce The current Bitcoin technical analysis reveals compelling evidence for an imminent reversal. With the RSI plunging to 22. 49, Bitcoin has entered deeply oversold territory not seen since major market bottoms. Historical analysis shows that RSI readings below 25 have consistently marked significant buying opportunities for BTC. The MACD histogram at -1290. 35 confirms bearish momentum, but the divergence between price action and RSI suggests this selling pressure may be nearing exhaustion. Bitcoin’s position at 0. 02 within the Bollinger Bands indicates the price is hugging the lower band support at $83,869. 92, a classic setup for mean reversion toward the middle band at $97,571. Volume analysis from Binance shows $2. 27 billion in 24-hour trading, indicating sufficient liquidity to support a meaningful bounce. The daily ATR of $4,396. 80 suggests that any reversal could produce significant price movements in either direction. Bitcoin Price Targets: Bull and Bear Scenarios Bullish Case for BTC The primary BTC price prediction scenario targets a recovery to $95,000-$100,000 within 4-6 weeks. This Bitcoin forecast is based on several technical factors converging simultaneously. First, the oversold RSI condition typically resolves with a 15-25% bounce, which would place Bitcoin near $97,000. Second, a reclaim of the 20-day SMA at $97,571 would confirm the reversal and open the path to test the previous consolidation zone. For this bullish scenario to materialize, Bitcoin needs to break above $90,000 decisively, which represents both the immediate resistance and the psychological barrier identified in recent analyst reports. A successful break would likely trigger short covering and renewed institutional buying, potentially driving the BTC price target toward $100,000. Bearish Risk for Bitcoin The alternative scenario sees Bitcoin breaking below the critical $80,600 support level, which could trigger a cascade toward $76,000-$78,000. This bearish Bitcoin forecast would invalidate the oversold bounce thesis and suggest that the current weakness reflects fundamental rather than technical selling pressure. Key risk factors include potential regulatory concerns, macroeconomic headwinds affecting risk assets, and continued outflows from Bitcoin ETFs. If the $80,600 support fails, the next significant level lies near the 52-week low at $76,322, representing a potential 9-10% decline from current levels. Should You Buy BTC Now? Entry Strategy Based on the current Bitcoin technical analysis, a staged entry approach appears optimal. The immediate BTC price prediction suggests waiting for either a bounce from current levels or a break below $80,600 before taking action. For aggressive buyers, initial positions could be established near $83,000-$84,000 with stop-losses below $80,000. Conservative investors should wait for confirmation above $88,000-$90,000 before entering, as this would signal the beginning of the predicted recovery phase. Position sizing should reflect the elevated volatility, with risk management paramount given the conflicting analyst forecasts. Consider scaling into positions rather than making large single entries, particularly given the mixed sentiment in current BTC price predictions. BTC Price Prediction Conclusion The weight of technical evidence supports a medium-confidence prediction that Bitcoin will rebound toward $95,000-$100,000 by late December 2025. The oversold RSI, Bollinger Band positioning, and historical precedent for bounces from these levels provide the foundation for this Bitcoin forecast. However, the $80,600 support level represents the critical make-or-break point for this prediction. A decisive break below this level would invalidate the bullish scenario and suggest deeper weakness ahead. Key indicators to monitor include RSI divergences, volume confirmation on any bounce attempts, and the market’s reaction to the $90,000 resistance level. The timeline for this BTC price prediction to materialize extends through December 2025, with initial confirmation expected within the next 1-2 weeks if the oversold bounce scenario unfolds as anticipated. Image source: Shutterstock.
https://Blockchain.News/news/20251122-price-prediction-btc-sharp-rebound-to-95000-100000-by
Shelter-in-place order lifted for communities near hazardous cargo ship fire in Port of L.A.
A shelter-in-place order that was issued in the wake of a large hazardous container ship fire for some residents of San Pedro and Wilmington on Friday evening has been lifted. The order was issued because the vessel, One Henry Hudson, caught fire around 7:15 p.m. Friday while docked at the Port of Los Angeles. […]
https://ktla.com/news/local-news/shelter-in-place-order-lifted-for-communities-near-hazardous-cargo-ship-fire-in-port-of-l-a/
“Wuthering Heights”: New Poster Is A Homage To Classic Romance Novels
The official trailer for “Wuthering Heights” was released last week, but this week we got a new poster that pays homage to classic romance novels. The lit nerds in your life are going to be mad for the next three months, and you should probably just accept it. When it comes to the works of Emily Brontë, people have big opinions and even bigger feelings, so this new adaptation of Wuthering Heights was always going to draw a lot of criticism. When the first set photos leaked, costume and fashion nerds jumped in to talk about how the clothing did not fit the era of the film at all. The first teaser trailer for the film was released in September, and everyone pitched a fit. Two and a half months later, we have the official trailer, and people are still big mad. There have been plenty of good films that have been sold poorly in trailers, but to say that “Wuthering Heights” will be heading into its opening weekend on the back foot is an understatement unless the conversation around this film shifts dramatically. The team behind this film is a little self-aware, or someone on the team is a little self-aware, because the new poster is a perfect homage to classic bodice rippers. “Wuthering Heights”: Summary, Cast List, Release Date From Warner Bros. Pictures and Academy Award and BAFTA-winning filmmaker Emerald Fennell comes “WUTHERING HEIGHTS,” starring Academy Award and BAFTA nominee Margot Robbie opposite BAFTA nominee Jacob Elordi. A bold and original imagining of one of the greatest love stories of all time, Emerald Fennell’s “WUTHERING HEIGHTS” stars Margot Robbie as Cathy and Jacob Elordi as Heathcliff, whose forbidden passion for one another turns from romantic to intoxicating in an epic tale of lust, love and madness. The film also stars alongside Oscar nominee Hong Chau, Shazad Latif, Alison Oliver, BAFTA winner Martin Clunes and Ewan Mitchell. Fennell directs from her own screenplay, and produces alongside Oscar nominee and BAFTA award winner Josey McNamara and Robbie. Oscar nominee Tom Ackerley and Sara Desmond are executive producing. Behind the scenes, Fennell worked with such frequent collaborators as Oscar- and BAFTA-winning director of photography Linus Sandgren, Oscar- and BAFTA-nominated production designer Suzie Davies, BAFTA-nominated editor Victoria Boydell, award-winning casting director Kharmel Cochrane and BAFTA-nominated composer Anthony Willis. Oscar and BAFTA winner Jacqueline Durran designed the costumes. Original songs by Charli XCX. Warner Bros. Pictures and MRC Present A Lie Still & LuckyChap Entertainment Production, a film by Emerald Fennell, “WUTHERING HEIGHTS.” Distributed by Warner Bros. Pictures, the film will be in theaters nationwide on February 13, 2026, and internationally beginning 11 February.
https://bleedingcool.com/movies/wuthering-heights-new-poster-is-a-homage-to-classic-romance-novels/
Comic books once stoked fears of crime, but a California city wants to confront that history
SACRAMENTO, Calif. On a recent day at Sacramento native Lecho Lopez’s comic shop in the city, his 5-year-old nephew read his first word aloud: “bad.” It was from a graphic novel. There was irony in that being his first word, because Lopez credits comic books with many positive things in his life. That’s why he supports repealing a city ordinance dating back to 1949 that bars the distribution of many comic books to kids and teens. It’s not enforced today. “It’s a silly law,” said Lopez, who has a red-and-black tattoo of the Superman logo on his forearm, in an interview at his store, JLA Comics. “A lot of good things come out of comic books.” A City Council committee unanimously voted this week to advance the repeal and designate the third week of September as “Sacramento Comic Book Week.” It now heads to the full council for a vote. The ban applies to comic books prominently featuring an account of crime that show images of illegal acts such as arson, murder or rape. In the mid-20th century, as comic books were on the rise, fears spread over their impact on children, with some arguing they could lead to illiteracy or inspire violent crime. The industry decided to regulate itself, and local governments from Los Angeles County to Lafayette, Louisiana passed bans to shield certain comics from young people. While some cities like Sacramento still have those laws on the books, they are rarely if ever enforced. Now, proponents of repealing the Sacramento law say it’s necessary to reflect the value of comics and help protect against a modern wave of book bans. Local artist pushes for repeal Comic book author Eben Burgoon, who started a petition to overturn Sacramento’s ban, said comics “have this really valuable ability to speak truth to power.” “These antiquated laws kind of set up this jeopardy where bad actors could work hard to make this medium imperiled,” he said at a hearing Tuesday held by the city council’s Law and Legislation Committee. Sacramento is a great place to devote a week to celebrating comics, Burgoon said. The city has a “wonderful” comic book community, he said, and hosts CrockerCon, a comics showcase at a local art museum, every year. Sam Helmick, president of the American Library Association, said “there is no good reason” to have a ban such as Sacramento’s on the books, saying it “flies in the face of modern First Amendment norms.” The history behind comic book bans The movement to censor comics decades ago was not an aberration in U. S. history, said Jeff Trexler, interim director of the Comic Book Legal Defense Fund, which fights to protect the free-speech rights of people who read or make comics. New York, for example, created a commission in the 1920s dedicated to reviewing films to determine whether they should be licensed for public viewing, based on whether they were “obscene” or “sacrilegious” and could “corrupt morals” or “incite crime,” according to the state archives. “Every time there’s a new medium or a new way of distributing a medium, there is an outrage and an attempt to suppress it,” Trexler said. The California Supreme Court ruled in 1959 that a Los Angeles County policy banning the sale of so-called “crime” comic books to minors was unconstitutional because it was too broad. Sacramento’s ban probably doesn’t pass muster for the same reason, Trexler said. There’s not a lot of recent research on whether there’s a link between comic books and violent behavior, said Christopher Ferguson, a professor of psychology at Stetson University in Florida. But, he said, similar research into television and video games has not shown a link to “clinically relevant changes in youth aggression or violent behavior.” Comic-book lovers tout their benefits Leafing through comics like EC Comics’ “Epitaphs from the Abyss” and DC’s and Marvel’s collaboration “Batman/Deadpool,” Lopez showed an Associated Press reporter images of characters smashing the windshield of a car, smacking someone across the face and attacking Batman using bows and arrows the kinds of scenes that might be regulated if Sacramento’s ban were enforced. But comics with plot lines that include violence can contain positive messages, said Benjamin Morse, a media studies lecturer at the University of Nevada, Las Vegas. “Spider-Man is a very mature concept,” said Morse, who became an “X-Men” fan as a kid and later worked at Marvel for 10 years. “It’s a kid who’s lost his parents, his uncle dies to violence and he vows to basically be responsible.” Lopez’s mother bought him his first comic book, “Ultimate Spider-Man #1,” when he was around 9 years old, he said. But it was “Kingdom Come,” a comic featuring DC’s Justice League, that changed his life at a young age, with its “hyper-realistic” art that looked like nothing he’d ever seen before, he said. He said his interest in comic books helped him avoid getting involved with gangs growing up. They also improved his reading skills as someone with dyslexia. “The only thing that I was really able to read that helped me absorb the information was comic books because you had a visual aid to help you explain what was going on in the book,” Lopez said. And a comic book can offer so much more, Burgoon said at this week’s hearing. “It makes imaginative thinkers,” he said. “It does not make widespread delinquency. It does not make societal harm.”.
https://www.clickorlando.com/entertainment/2025/11/22/comic-books-once-stoked-fears-of-crime-but-a-california-city-wants-to-confront-that-history/
Unidentified victim dead in double shooting Friday night in Loop
An unidentified man was pronounced dead Friday night in a shooting that left an 18-year-old man seriously wounded in the Loop neighborhood, Chicago police said. Around 10: 40 p. m., officers responded to a call of someone shot in the 100 block of South Dearborn Street and found two victims struck by gunfire. The first victim suffered multiple wounds to the body, and was taken to Northwestern Memorial Hospital where he was pronounced dead. An 18-year-old man suffered a wound to a leg and was taken to the same hospital where he was listed in serious condition, police said. No one was in custody and detectives were investigating.
https://www.chicagotribune.com/2025/11/22/unidentified-victim-dead-in-double-shooting-friday-night-in-loop/
Hulk Hogan’s Son Teases Potential Wrestling Career
Hulk Hogan’s son, Nick, has teased a potential wrestling career. The Hulkster passed away in July at the age of 71. He left behind an in-ring legacy that few can match. Now, it seems his son is hinting at following in his footsteps. A few days ago, Nick shared photos on Instagram of training with NWA star Bryan Idol. This led to speculation about whether he’s preparing for an in-ring career. Thanks for the submission! TMZ Sports had a chat with Nick and asked him if the training with Idol meant a pro wrestling career is on the horizon. While he refused to confirm anything, he did say it is in his blood. He also mentioned wrestling makes him feel closer to his late father. “You never know, you never know, man. It’s in the blood, so you never know. I have always loved the business. Obviously, it makes me feel so much closer to Dad, being around the business and being, kind of, in that environment. I have a lot of love for it, and like I said, it’s in the blood,” he said. When asked if anybody has reached out to him regarding his potential wrestling career, Nick mentioned that he’s in touch with everybody. “I have always been in touch with everybody, and I always try and stay in touch with everybody. I like to be close to those guys and close to the environment in the company. Like I said, it’s a family,” he added. When asked if he has a finishing move, he said he is working on a couple of things, and it never hurts “to drop a leg here and there.” Hulk Hogan’s son penned an emotional note for late father A few days ago, Nick Khan posted an emotional note for his late father, Hulk Hogan, on Instagram. Nick posted a series of photos with the WWE legend and wrote how he misses him every day. He mentioned that the pain of losing him hasn’t gone away, but he is doing a lot of things that would make him proud. He wrote the photos brought back memories of Hulk Hogan, as he feels he is watching over him. If you use quotes from this article, please credit TMZ Sports and give an H/T to Sportskeeda Wrestling for the transcription.
https://www.sportskeeda.com/wwe/news-hulk-hogan-s-son-teases-potential-wrestling-career
Are Bitcoin traders convinced this changes things?
CME FedWatch now implies better than 70% odds that the Federal Reserve will cut rates by 25 basis points at its Dec. 9-10 meeting, dropping the target range from 3. 75%-4. 00% to 3. 50%-3. 75%. That marks a dramatic intraday reversal on Nov. 21, when New York Fed President John Williams told reporters the Fed can still trim rates “in the near term” without threatening its 2% inflation target. A few days before, the same probability sat near 30%, weighed down by a government data blackout and hawkish Fed commentary. The question now is whether a December cut carries enough conviction to pull Bitcoin (BTC) out of protection mode, or whether the macro tailwind arrives too late for a market already bleeding leverage and ETF flows. Between Nov. 20 and 21, Bitcoin dove from $91,554. 96 to $80,600, before recovering to $84,116. 67 as of press time. The movement worried investors, who are not certain if BTC reached its local top this cycle at $126,000, and there is no steam left for an upward movement. The rate-cut narrative matters for Bitcoin because it translates directly into real yields and liquidity. Over the past two months, inflation-adjusted Treasury returns climbed as markets priced out easing, pulling capital away from high-beta assets and tightening global liquidity. If the Fed now delivers the cut markets expect and signals more to come, real yields should compress and liquidity should expand, conditions that historically correlate with Bitcoin outperformance. However, on-chain data from Glassnode and derivatives positioning show the market hasn’t flipped yet. Recent buyers are underwater, ETFs are bleeding, and options traders are paying double-digit premiums for downside protection. What changed and why it moved odds so fast Williams’ comments hit a market that had just repriced December odds down to 30% amid uncertainty over employment data. By Nov. 21 close, FedWatch probabilities had spiked above 70%, reversing a multi-week drift lower. The swing reflects how sensitive markets have become to Fed messaging after two cuts already delivered in 2025, the most recent on Oct. 29, which brought the funds rate to 3. 75%-4. 00% and announced that quantitative tightening would end Dec. 1. September payrolls printed at 119, 000 with unemployment edging up to 4. 4%, data that split Wall Street. JPMorgan, Standard Chartered, and Morgan Stanley pulled their December-cut forecasts, arguing the jobs print wasn’t weak enough to justify further easing. Citi, Deutsche Bank, and Wells Fargo held firm, pointing to the uptick in unemployment as proof that the Fed has room to ease. Williams’ remarks tipped the balance, validating the dovish camp. Markets now price a 70% chance the Fed follows through in December, with further easing expected in 2026 if inflation remains contained. The 10-year nominal Treasury yield has already fallen roughly 60 basis points this year, and TIPS breakevens sit just above 2. 2%, suggesting markets believe inflation can stay anchored even as policy eases. Real yields, liquidity, and why Bitcoin cares The relationship between Bitcoin and real yields has become the dominant macro narrative this fall. Rising inflation-adjusted returns on Treasurys pull capital away from zero-yielding assets like Bitcoin. S&P Global’s work shows a negative correlation between Bitcoin and real yields that has strengthened since 2017, with the asset tending to outperform when policy eases and liquidity expands. Bitwise’s research overlays Bitcoin against global M2 money supply, showing that periods of re-accelerating money growth and easier Fed policy coincide with stronger Bitcoin performance. The recent dollar pullback and renewed M2 expansion should become tailwinds once markets trust that cuts will continue. A December cut backed by guidance toward further easing would cap real yields and rebuild the liquidity backdrop that historically supports Bitcoin. Yet, the mechanics only work if the cut arrives with conviction. A one-and-done cut followed by hawkish guidance would leave real yields elevated and liquidity constrained. Williams’ comments matter because they suggest the Fed sees room for multiple moves, not just a token cut in December. If that proves true, the path toward falling real yields and a softer dollar becomes credible, giving Bitcoin a chance to flip from selling off with liquidity to trending with it. What Glassnode sees on-chain and in derivatives Glassnode’s Nov. 19 report maps how hard the recent drawdown hit and why positioning remains defensive. 21 with BTC almost losing the $80,000 footing. That leaves almost all recent cohorts sitting at an unrealized loss and turns the $95,000-$97,000 zone into resistance. Glassnode estimates 6. 3 million BTC now sit underwater, mostly in the -10% to -23. 6% range, a distribution that resembles 2022’s range-bound bear market more than full capitulation. Two price levels stand out. The Active Investors’ Realized Price sits around $88,600, representing the average cost basis for coins that move regularly. The True Market Mean, near $82,000, marks the threshold between a mild correction and a deeper 2022-style bear phase. Bitcoin currently trades between those levels. Off-chain flows reinforce the caution. US spot ETFs show a firmly negative seven-day average, with November outflows approaching $3 billion. That suggests institutional allocators aren’t stepping in to buy the dip. Futures open interest drifts lower alongside price, implying traders are de-risking rather than adding leverage. Options positioning screams protection mode. Implied volatility spiked back toward levels last seen during October’s liquidation event, skew tilts sharply negative, and one-week puts trade at a double-digit premium to calls. Net flows show traders paying up for $90,000 downside strikes while adding only modest call exposure. Glassnode’s read is that dealers are short delta and hedging through futures selling, which mechanically adds pressure when the market weakens. The path forward depends on Fed conviction A December cut accompanied by guidance toward further easing would cap real yields and rebuild liquidity, the conditions Bitwise and S&P Global identify as historically favorable for Bitcoin. The 70% probability now priced into FedWatch reflects growing confidence that the Fed sees a path to ease without reigniting inflation, which is exactly what Bitcoin needs to flip the narrative. But Glassnode’s on-chain and derivatives data show the immediate setup remains fragile. Recent buyers are underwater, ETFs are bleeding, leverage is unwinding, and options positioning favors protection over conviction. That means even a December cut might not trigger an immediate reversal if it comes without clear guidance on future moves. If the Fed blinks or delivers a one-and-done cut while emphasizing inflation risk, the macro impulse could prove too weak to shift ETF flows or flip risk appetite. Bitcoin would remain pinned below the $95,000-$97,000 resistance that Glassnode now considers structural. Williams’ comments cracked the door open. A December cut with forward guidance could push it wider. Whether that’s enough to pull Bitcoin through depends on whether the Fed treats December as the start of a new easing cycle or the end of a brief recalibration. Markets are pricing the former at 70% odds. The on-chain data suggests traders aren’t convinced yet.
https://bitcoinethereumnews.com/bitcoin/are-bitcoin-traders-convinced-this-changes-things/
I use these 3 Excel formulas to organize my daily life
Microsoft Excel isn’t just for work. In fact, by leveraging just three single, powerful formulas, I use the popular spreadsheet software at home to track warranties, manage my budget, and ensure I never forget a birthday. Thanks to Excel, I’ve ditched my chaotic life for one that’s highly organized. There’s nothing more frustrating than realizing a key household item is failing, only to later find out you missed the warranty expiration by a few days. To avoid this, I use the FILTER function to track when product warranties expire, so I can check the condition of my products well in advance. In my spreadsheet below, when I enter a month and year into cells G2 and G3, respectively, the formula checks the Warranty column of the T_Receipts table for matching dates and automatically populates the lookup table with a spilled dynamic array. Achieving this requires only one formula, which I entered into cell F6: =FILTER(T_Receipts,(MONTH(T_Receipts[Warranty])=MONTH(DATEVALUE(G2&”1″)))*(YEAR(T_Receipts[Warranty])=G3),”No items”) Here’s how the formula works. Part 1: Initiating the FILTER function The FILTER function filters an array based on certain criteria. In this case, the array is a table named T_Receipts: FILTER(T_Receipts Part 2: Specifying the filtering criteria The second part of the formula is the inclusion criteria, and since I need it to consider the month and the year, it consists of two segments. The first segment looks for dates in the Warranty column whose month matches the month in cell G2. However, because the full month name is used in cell G2, it needs to be converted into a month number. First, the month in cell G2 is concatenated with 1 to create a date string (such as January 1). Then, the DATEVALUE function converts the string to a numeric value, which the MONTH function extracts from the date. Then, it compares that target month number to the month number of every warranty date in the Warranty column of the T_Receipts table: (MONTH(T_Receipts[Warranty])=MONTH(DATEVALUE(G2&”1″))) The second segment extracts the year from every date in the Warranty column of the T_Receipts table and checks if it’s equal to the year in cell G3: (YEAR(T_Receipts[Warranty])=G3) Use data validation drop-down lists to ensure the dates match the format the FILTER function expects. Also, because Excel treats dates as serial numbers, be sure to select the date column in the lookup table and change the number formatting to “Date.” Multiplying these two segments together forces Excel to treat them as a single logical test. Only when both segments return TRUE (represented as 1 in Excel’s logic) will the multiplication equal 1. Then, any rows where 1 is the result are extracted into the filtered list. Categorize and track a budget Managing my personal finances used to mean manually comparing my spending against my budget for various categories, but this was unreliable and time-consuming. Now, I use a single Excel formula to automate this comparison and give me instant feedback on my financial health. As you can see in the screenshot below, this formula is invaluable because it tells me if I’m within, near, or over my budget for each category in a given month. Here’s the formula I entered into cell G2, which I then expanded to cell G8 using autofill: =LET(Spend, SUMIF(T_Budget[Category], E2, T_Budget[Cost]), IFS(Spend>F2,”Over budget”, Spend=F2,”Budget hit”, Spend>(F2*0. 9),”Near budget”, TRUE,”Within budget”)) Let’s break the formula down to understand what’s going on. Part 1: Defining the Spend variable The LET function is one of Excel’s most versatile functions, as it lets me name a result and refer to it multiple times. This makes the final formula easier to parse and faster to execute. In this case, I’m calling the result Spend: =LET(Spend Now, I need to define what the Spend variable represents. To do this, I’ll use the SUMIF function to calculate the total cost for the specific budget category in question: =LET(Spend, SUMIF(T_Budget[Category], E2, T_Budget[Cost]) T_Budget[Category]: This is the range to check. E2: This is the criterion. It checks if the category in the table matches the category name in cell E2. T_Budget[Cost]: This is the range to sum. If the categories match, the corresponding value in the Cost column is added. Because I used the LET function, the Spend variable holds the total amount I’ve spent for the category listed in cell E2. Part 2: Determining the budget status The final part of the LET function uses the calculated Spend variable inside the IFS function to determine the status. The IFS function evaluates multiple conditions from left to right until one returns TRUE. Then, it returns the corresponding value: IFS(Spend>F2,”Over budget”, Spend=F2,”Budget hit”, Spend>(F2*0. 9),”Near budget”, TRUE,”Within budget”) Spend>F2,”Over budget”: This is the first test. If the total spend is greater than the budget limit in cell F2, the formula stops and returns “Over budget.” Spend=F2,”Budget hit”: If the first test isn’t met, Excel moves onto the second test. In this case, it checks whether the spending exactly matches the limit in cell F2 and, if so, returns “Budget hit.” Spend>(F2*0. 9),”Near budget”: If neither of the first two tests is met, I want Excel to check whether the spending for a category exceeds 90% of the budget in cell F2. If this is the case, it returns “Near budget.” TRUE,”Within budget”: The final test is the catch-all-if my spending hasn’t triggered any of the other three tests, the formula returns “Within budget.” Work out the next time it’s someone’s birthday If, like me, you’re terrible at tracking birthdays, Excel can help you out. This table tells me how many days are left until each person’s birthday: This is the formula I constructed in cell C2. Because I entered it into an Excel table, it duplicated down the Days column automatically when I pressed Enter: =IF(DATE(YEAR(TODAY), MONTH([@Birthday]), DAY([@Birthday]))https://www.howtogeek.com/microsoft-excel-formulas-organize-my-daily-life/
Drew McIntyre to be removed from The Vision’s team & replaced by former WWE Champion? WarGames possibility explored
Former WWE Champion Drew McIntyre is officially a part of the Men’s WarGames match this year at the Survivor Series 2025 Premium Live Event.
https://www.sportskeeda.com/wwe/drew-mcintyre-removed-the-vision-s-team-replaced-former-wwe-champion-wargames-possibility-explored