Excel’s XLOOKUP function is a powerful tool for data retrieval, allowing users to search for a value in a range and return a corresponding value from another range. However, a common mistake when using XLOOKUP can lead to inaccurate results and potentially costly errors in your spreadsheets. In this guide, we will guide you through […]
The post Master Excel XLOOKUP Data Retrieval appeared first on Geeky Gadgets.
There are two broad schools of design with pocket knives – either make them look so outrageously rugged that they instill fear in their enemies, or design them to be so slick and minimal that their owners treasure them for their collectible-worthy beauty. It’s rare to come across a knife that somehow manages both those things, but the Dragon Ridge holds that unique distinction. Being equally formidable-looking and minimalistic, the Dragon Ridge folding knife sports a skeletal handle modeled on the ribcage of a dragon (a hypothetical one of course). The Dragon Ridge’s handle comes machined from grade 5 titanium, with an M390 martensitic chromium steel blade that has the menacing sharpness of a dragon’s fangs. The knife balances its bare-bone skeletal design with an intimidating aesthetic rather beautifully, giving you essentially a modern EDC icon that’s visually stunning, ergonomically sound, and tactically capable of being your favorite pocket knife.
Designer: TIGO
Click Here to Buy Now: $205 $279 (27% off) Hurry! Only 14 of 50 units left.
The Dragon Ridge has an almost relic-like quality to it thanks to its rather unique design. The handle, which takes all credit for being the knife’s most visually exciting element, sports a skeletal design that resembles a spine and ribcage. This effectively gives the handle a unique ergonomic form that naturally allows the fingers to find their grip, while cutouts in the knife’s design help reduce material and therefore overall weight. This is only possible thanks to the knife’s titanium alloy body, which gives the EDC its durability and strength – something you wouldn’t be able to achieve if the exact same design was machined out of aluminum, carbon fiber, or G10.
The Dragon Ridge measures 4.84 inches when closed (123mm), opening up to a whopper of an 8.2-inch knife when the blade’s out (210mm for the metric folk). This puts the Dragon Ridge well within the size category of a medium-to-large knife, which means it’s a lot bigger and badder than most compact micro-knives out there. That large size makes the knife more grippy, more maneuverable, and perfect for all sorts of activities, whether domestic or outdoor.
Flip open the knife and you’re greeted with a gorgeous 3.4-inch drop-point blade. Made from M390 steel (harder and much more durable than D2 steel seen in most high-end knives), the Dragon Ridge outdoes other knives in its price category handily. The drop-point style blade is a crowd favorite, and is perfect for all sorts of tasks, from cutting vegetables to whittling branches, piercing bark or leather, and even defending yourself in a tactical situation. When time’s of the essence, the knife opens in under a second, thanks to the flipper on the blade that lets you quick-deploy your EDC. Jimping on top of the blade gives you good thumb-grip too, as you apply pressure while cutting.
The knife boasts multiple opening styles, making it fun to operate and just overall hand-candy. A button-lock lets you deploy the blade with a flick of the wrist, while also allowing you to quickly close your blade once you’re done using it. Alternatively, the flipper lets you use your index finger to flip open the blade, and if you have nails, the thumb-hole offers a more traditional opening method.
The martensitic chromium steel blade works exceptionally well in emergencies too, letting you whittle wood, scrape flint, and even cut paracord or seatbelts. When you’re not using the knife, however, it rests comfortably in your pocket, thanks to a deep pocket clip, or even around your wrist or neck, thanks to a lanyard hole on the rear end of the handle.
At 143 grams or just above 5 ounces, the Dragon Ridge is fairly light for an all-metal knife. It’s still in the ballpark of ‘average knife weight’, but your fingers will definitely be pleased once you pick this bad-boy up, realizing it’s not as heavy as you think it is. It’s still well-weighted enough to maneuver deftly, allowing you to go through all sorts of use cases without the feeling of the knife being fragile or not up for the task. Although the maker TIGO doesn’t specifically detail out any warranty information, the Dragon Ridge is built reliably enough to last multiple lifetimes. The ball-bearing hinge and button lock should work very smoothly even with regular use, the blade should hold its edge fairly well (and will respond well to sharpening every few months), and that gorgeous bony titanium handle will promise to look exactly the same after decades, almost echoing the everlasting nature of a dragon fossil!
Click Here to Buy Now: $205 $279 (27% off) Hurry! Only 14 of 50 units left.
The post Dragon-inspired Titanium Pocket Knife has the most breathtaking skeletal handle design first appeared on Yanko Design.
Designed by Rocky Mountain Tiny Homes, the Bandelier tiny home features a decent length of 28 feet. The home is quite cleverly created, and is equipped with a comfy interior for two people, plus some guests. The home has a well-proportioned and designed living area, as well as a bathtub. The Bandelier is a bit different compared to the other builds by Rocky Mountain Tiny Houses, and this is because the shell and exterior were already constructed. The firm only made a few small changes, and finished the interior.
Designer: Rocky Mountain Tiny Homes
You can access the interior via the front door, and it leads you to the living room which is equipped with shelving, a sofa bed for guests, as well as a compact wood-burning stove. This section then leads to the kitchen which is pretty well-sized for a tiny home. It is furnished with quartz counters, seating area, an oven, and a propane-powered stove. It also includes a microwave, full-size fridge/freezer, and sink.
The kitchen and bathroom are connected via a sliding door. The bathroom includes a vanity sink, flushing toilet, as well as a full-size bathtub/shower, which isnt really found in tiny homes. There is some storage space as well. However, the Bandelier only contains a single bedroom, which can be accessed via a storage-integrated staircase. The bedroom is a typical tiny house-style loft with a low ceiling, as well as a double bed, storage, and some generous glazing.
The Bandelier tiny home was constructed for wildland firefighters, and it is located near the Bandelier National Monument in New Mexico. We are unsure of the price but homes by Rocky Mountain Tiny Houses usually cost around US$100,000 when built from scratch.
The post This Cleverly-Designed Tiny Home For Two Is Compact, Comfortable & Functional first appeared on Yanko Design.
The allure of the Omega x Swatch Mission to the Super Blue Moonphase watch pulled me from Dallas to Austin, a journey sparked by the promise of a rare astronomical event. The super blue moon, a captivating phenomenon that merges a supermoon and a blue moon, graces our skies only once every 10 to 20 years. Such rarity naturally inspired this limited-edition watch, which Swatch and Omega designed to celebrate the celestial event and their storied collaboration.
Designer: Omega x Swatch
Choosing a flight over the three-hour drive, I landed in Austin determined and excited, with temperatures soaring over 100 degrees Fahrenheit. The journey to the Swatch store was filled with anticipation as I navigated the city, knowing that this unique timepiece awaited only a select few. Upon arrival, I joined a group of fellow enthusiasts, each driven by the desire to claim this beautifully crafted watch.
Swatch made the strategic decision to begin sales at 5 p.m., a time that coincided with the symbolism of the moonrise and added a layer of thematic significance to the event. This timing was ideal, allowing collectors to gather after work and transforming an ordinary evening into a momentous occasion.
The Mission to the Super Blue Moonphase was available at select Swatch locations across the U.S., including New York, Los Angeles, Miami, Las Vegas, Houston, and Austin. These stores, each a destination for collectors, were carefully chosen to reflect the brand’s reach and dedication to providing access to its limited-edition pieces.
As I took my place as the sixth person in line, the camaraderie among collectors became tangible. Conversations about past releases, the rarity of the super blue moon, and the watch’s technical features filled the air, creating a sense of community among strangers united by a shared passion.
MISSION TO THE MOONPHASE – FULL MOON vs. MISSION TO THE SUPER BLUE MOONPHASE
The Swatch staff managed the crowd expertly, distributing water to keep spirits high despite the oppressive heat. They confirmed the rumors that stocks were limited—only a handful of watches would be available at each location. This news heightened the anticipation, as everyone in line understood the stakes.
Finally, the moment arrived. The doors opened, and we were ushered one by one into the store, our eyes immediately drawn to the centerpiece of the event: the Mission to the Super Blue Moonphase. The watch was displayed under carefully positioned lighting, emphasizing its striking design. Inside, the air conditioning provided relief from the oppressive heat outside, transforming the store into a sanctuary for the watch lovers who had endured the long wait.
The blue bioceramic case shimmered, and the panda dial—adorned with blue and silver opaline—commanded attention with its intricate details. The moon phase indicator at the 2 o’clock position beautifully captured the essence of the super blue moon, rotating to display various phases. At the same time, the hidden details emerged under UV light, revealing an extra layer of sophistication. This feature, alongside the pulsometer scale—traditionally used for measuring heart rates—added aesthetic and functional appeal to the watch.
With its light blue topstitching, the Velcro strap matched the bioceramic case perfectly, creating a cohesive and stylish look. However, as I had experienced with other models, the strap’s design had drawbacks. While visually appealing, the Velcro lacked a locking mechanism, which could be risky for those with active lifestyles. My business partner had even lost his Tiffany Dial MoonSwatch this way—a cautionary tale for potential buyers.
Securing the watch felt like a triumph. The cool touch of bioceramic against my wrist contrasted sharply with the day’s heat, yet the satisfaction of obtaining this rare piece made every moment worth it. Each glance at the dial now serves as a reminder of the excitement and dedication that marked the day.
For those considering this purchase, only ten days remain before the opportunity to buy the Mission to the Super Blue Moonphase directly from Swatch will vanish. After Aug. 19, the only option will be the aftermarket, where prices already exceed the $310 MSRP. The watch is a tangible connection to the rare event that inspired its creation, embodying the beauty and wonder of a unique celestial occurrence.
The post Chasing the Moon: My Quest for the Omega x Swatch MISSION TO THE SUPER BLUE MOONPHASE first appeared on Yanko Design.
Both Russia and Venezuela have blocked access to the encrypted messaging app Signal, The Verge reports.
The Russian news service Interfax broke the news about the block on the Signal app in Russia. Russia’s telecommunications watchdog Roskomnadzor restricted the app due to “violations of the requirements of the Russian legislation whose fulfillment is necessary to prevent the use of the messenger for terrorist and extremist purposes,” according to the Russian report.
The cybersecurity tracker NetBlocks confirmed on X on Friday that Russia has restricted access to Signal “on most internet providers.” NetBlocks also noted the app “remains usable with ‘censorship circumvention’ enabled” in Signal’s settings echoing a recommendation from the Signal’s X account to users who’ve been blocked from their messages in both regions .
The blocking of Signal in Venezuela occurred in the long shadow of the country’s disputed presidential election results from the end of July. Venezuela’s electoral authority declared President Nicolás Maduro the winner without publishing any evidence of his win, sparking protests from detractors and supporters of Maduro’s opponent Edmundo González, according to the Associated Press.
Both regions have been cutting off access to other similar social media apps possibly as a way to quiet dissenting voices. President Maduro banned X earlier today for a period of 10 days claiming that the company’s owner Elon Musk was inciting hatred and “violated” his social network’s rules. VOA News also reported a “mass YouTube outage” in Russia on Thursday.
This article originally appeared on Engadget at https://www.engadget.com/social-media/russia-and-venezuela-have-blocked-encrypted-messaging-app-signal-221433099.html?src=rss
The options for premium true wireless earbuds have gotten more interesting since the Samsung Galaxy Buds 3 Pro debuted with the stem design. Now, users have more reasons to rejoice as Google Buds Pro 2 is just around the corner, according to reliable leaks. The new ANC earbuds for the Pixel ecosystem are slated to make an appearance at the Made by Google event on August 13. The Pixel 9 series smartphones will be released at this event, and we have our calendars marked already.
According to numerous leaks and rumors, the buds will have wings for a secure grip, and unlike the Galaxy Buds 3 Pro that have adapted the stem design (very similar to the AirPods) this time, the Google’s audio accessory will continue with the stemless aesthetic of the current generation. As it goes in the gadget rumor mill, the Buds Pro 2 display unit has been received at a Reddit user’s store.
Designer: Google
User [nothighandmighty] has not been shy about sharing the picture of the display model of the upcoming earbuds. For the most part, the new buds will be a lowkey upgrade to the previous version with incremental improvements that help them stay at par with heavyweights like Sony WF-1000XM5, Bose QuietComfort Earbuds II and Jabra Elite 10 Gen 2. The Buds Pro 2 will be smaller than the current generation Pro model which makes them comfortable and compatible with small ears. Also, the wingtip is slightly larger for a more secure fit and will be color-matched with the chosen option. According to a leak by Dylan Roussel, the earbuds will come in peppy color options including Raspberry, Mojito, Porcelain and Haze.
The case will be smaller as well which makes them easier to carry around in a pocket. [nothighandmighty] notes that there is a small speaker mesh at the bottom, most probably to beam sound for the Find My Device feature just in case you happen to lose them a lot.
The post Google Pixel Buds Pro 2 make first appearance as a display unit ahead of official launch first appeared on Yanko Design.
Oxford University scientists may have solved one of the greatest hindrances of expanding access to solar energy. Scientists from the university’s physics department have created an ultra-thin layer of material that can be applied to the exterior of objects with sunlight access in place of bulky silicon-based solar panels.
The ultra-thin and flexible film is made by stacking layers of light-absorbing layers of perovskite that are just over one micron thick. The new materials are also 150 times thinner than a traditional silicon wafer and can produce 5 percent more energy efficiency than traditional, single-layer silicon photovoltaics, according to a statement released by Oxford University.
Dr. Shauifeng Hu, a postdoctoral fellow at Oxford’s physics department, says he believes “this approach could enable the photovoltaic devices to achieve far greater efficiencies, exceeding 45 percent.”
This new approach to solar energy technology could also reduce the cost of solar energy. Due to their thinness and flexibility, they can be applied to almost any surface. This reduces the cost of construction and installation and could increase the number of solar energy farms producing more sustainable energy.
This technology, however, is still in the research stage and the university doesn’t mention the long-term stability of the newly designed perovskite panels. Going from 6 to 27 percent solar energy efficiency in five years is an impressive feat but stability has always been limited compared to photovoltaic technology, according to the US Department of Energy. A 2016 study in the science journal Solar Energy Materials and Solar Cells also noted that perovskite can provide “efficient, low-cost energy generation” but it also has “poor stability” due its sensitivity to moisture.
Solar energy has also become a cheaper power option just over the last decade. The cost of solar photovoltaic technology has dropped by 90 percent in the last 10 years, according to the Global Change Data Lab.
New solar energy farms are popping up all over the world. The US Department of Energy announced earlier this month its turning an 8,000-acre piece of land that once housed parts of the nuclear weapons program known as the Manhattan Project into a solar farm. Last month, Google invested in a Taiwanese solar company to build a 1 gigawatt pipeline in the region.
This article originally appeared on Engadget at https://www.engadget.com/science/oxford-scientists-new-light-absorbing-material-can-turn-everyday-objects-into-solar-panels-200410760.html?src=rss
Heineken has laid great emphasis on the importance of social connections all these years, even before the times we got familiar with online socializing. For the Gen-Z the brand signifies freedom of thought and enjoyment with no strings attached. Going with this philosophy, a team of designers has conjured up this cool gadget christened Hei-Five.
A culmination of Heineken and high five, the palm-sized music device is about sharing songs with like-minded individuals and discovering new music. For instance, you hear a jiving tune at the trending restaurant in your city and desperately want to add that song to your playlist. Yes folks, the Hei-Five will do that without breaking a sweat.
Designer: LFD Official
Simply push the bottle cap-shaped button on one side and the gadget finds the song, thus allowing you to explore music tastes from around the globe. Whenever you meet a new friend at the beach or even a stranger at the local bar, simply clink each other’s device to create a unique playlist of both your tastes. There’s a dedicated share button to instantly share a song or playlist with someone having a Hei-Five device. That’s not it, when hanging in a group, stack everyone’s device on top of each other to create a potent speaker that plays the most liked songs in everyone’s playlist.
When the Hei-Five runs out of juice, simply dock it on the accompanying charger and it displays the current time and charging levels. The packing of the audio accessory is as interesting as its functionality. As soon as you open the box, there’s a Heineken can concealing the Hei-Five docked in the charging box. Stash it on your desk or living room shelf, onlookers will surely mistake it for a striking-looking beer can!
The post Heineken-themed music device lets you discover new music and create unique jams with strangers first appeared on Yanko Design.
Warner Bros. Discovery has pulled Cartoon Network’s entire website from the web, which means that you can no longer access free episodes and other interactive content. Instead, visitors to CartoonNetwork.com are redirected to the channel’s section on the subscription streaming network Max, Variety reported.
The Cartoon Network website offered full, free episodes and clips of some of its most popular shows including Adventure Time, The Amazing World of Gumball, Teen Titans GO! and Steven Universe. Now if you need a quick fix of those shows, you’ll have to get on Max, pay for them on another digital streaming service or dig up a copy from your stash of old Blu-Rays and DVDs.
A spokesperson for the Cartoon Network told Variety it’s refocusing its efforts on “shows and social media where we find consumers are the most engaged and there is a meaningful potential for growth.” The decision to take down the website will not affect the network’s cable TV programming.
The demise of Cartoon Network’s website comes a week after Warner Bros. Discovery announced the end of its classic cartoon streaming service Boomerang. Warner Bros. Discovery announced that the network for fans of classic cartoons like Tom & Jerry, Wacky Races and the original Looney Tunes shorts will end its operations on September 30. Subscribers will be added to Max’s ad-free tier for no additional cost.
In June, media giant Paramount, too, pulled down some of its cable channels’ old show episodes including The Daily Show with Jon Stewart and The Colbert Report from the Comedy Central website as well as free content from other channels’ websites such as TV Land, CMT and the Paramount Network.
This article originally appeared on Engadget at https://www.engadget.com/entertainment/tv-movies/warner-bros-sends-cartoon-networks-website-to-the-digital-graveyard-174502048.html?src=rssAs we did last Friday and the Friday before that (and shall continue to do until the internet turns itself off), we have rounded up the best deals we spotted this week and put them in one convenient location. These are the tech gadgets we have used, reviewed and recommend that happen to be seeing worthwhile discounts at the moment. This week, a bunch of Apple gear went on sale, some of it new, some of it older, such as the 2024 MacBook Air with the M3 chip for $250 off and the 2021 9th generation iPad for $100 under MSRP. Two of our favorite outdoor pizza ovens, the Frya 12 and the Karu 16, are on sale at Ooni and there's a special Engadget code that'll get you a deal on Roombas at Wellbots. Here are the best tech deals from this week that you can still get today.
Follow @EngadgetDeals on Twitter and subscribe to the Engadget Deals newsletter for the latest tech deals and buying advice.
This article originally appeared on Engadget at https://www.engadget.com/deals/save-150-on-our-favorite-ooni-pizza-oven-plus-the-rest-of-this-weeks-best-tech-deals-172730247.html?src=rss