LeifAmes.com

Slashdot

After 40 Years, Microsoft Excel Will Add Single-Cell Lists and Arrays

Microsoft's senior product manager for Excel acknowledges that "Throughout Excel's 40-year history, you've only been able to put one value per cell." But that's now changing with arrays in cells (as well as nested arrays) and lists. "You can create a list by selecting Insert > List or pressing Ctrl+J, then typing or pasting items separated by commas or semicolons, depending on your regional settings. Selecting the icon in the cell shows the individual values..." "With lists, you can filter by one or more individual items instead of whole text entries. Referencing a list returns all its values for calculations. For example, =B2 spills those values into separate cells..." "For the first time in Excel, arrays can exist natively in cells as values or as formula results. They can be any size or shape and can even contain other arrays. You can now keep the result of any spilling formula in a single cell by "wrapping" the formula body with braces { }." "Since the introduction of dynamic arrays, array results have spilled across cells — for example ={1;2;3}. Wrapping the original array with braces creates a 1x1 array around it, so instead of spilling to multiple cells, the array stays in a single cell. Braces have long been used to describe arrays in Excel and this extends that behavior by allowing multiple layers of braces. This gives you more flexibility when building spreadsheets. Instead of leaving room for a formula to spill, you can keep the result in one cell." "Arrays can now also 'nest' inside other arrays... Previously, a formula that produced an array of arrays would return a truncated result or #CALC! error. Now, supported formulas return the complete nested result... FLATTEN(array, [pad_value], [levels]) simplifies nested arrays by removing one or more levels of nesting..." Three HAS functions check whether values are in an array: — HAS(array, value) returns TRUE if value appears anywhere in array, and FALSE otherwise. — HASANY(array, values) returns TRUE if any of the values appear anywhere in array, and FALSE otherwise. — HASALL(array, values) returns TRUE if all of the values appear anywhere in array, and FALSE otherwise.

HACKADAY

Self-Repairing Conductive Material from Liquid Metal

PCB circuits are cool, but you know what is cooler? Terminator circuits that’s what! And what if the same material that makes Terminator circuits could also be used for smart …read more

Chinese Dictionary

声望 [聲望] shēng wàng

reputation; prestige; public esteem (HSK 7-9)

Guardian USA

‘Miracle on the Hudson’ pilot Chesly Sullenberger inducted into US Aviation Hall of Fame

Sullenberger landed a disabled passenger plane safely in the Hudson River in 2009 without any loss of life

Capt Chesley “Sully” Sullenberger III – the pilot known for safely landing a US Airways flight in New York City’s Hudson River during a 2009 emergency – has been inducted into the US’s National Aviation Hall of Fame, two months after he went public with an Alzheimer’s disease diagnosis.

Sullenberger, 75, received the honor during a ceremony held in Washington DC on Thursday, 17 years after he engineered what has become widely known as the Miracle on the Hudson.

Guardian USA

USMNT v Peru live – analysis and updates from international friendly in Orlando

USA v Peru kicks off at 4.30 ET
Cavan Sullivan, other young players could make debuts
Sign up for our free newsletter for US readers
Email Jeff with thoughts, questions and jokes

This week, Mauricio Pochettino lamented not being “more involved” with the federation’s controversial and successful effort to suspend Folarin Balogun’s red card ban during the World Cup. Perhaps he’s also wishing he’d been more involved in recruiting dual-national Noahkai Banks, as the promising 20-year-old center back has officially made his one-time switch to represent Germany.

I’ll hardly be surprised if Banks follows the career path of a similar US-eligible snub of yester-generation, Neven Subotić, who ultimately became a mainstay for Borussia Dortmund and earned 36 caps for Serbia.

Guardian USA

Seattle prosecutors mull hate crime charge for woman who bit circle in victim’s forehead

Suspect, charged with felony assault, under investigation for making racist and homophobic comments before attack

A Seattle woman will need surgery for a gnarly wound, after a stranger, who called her “an inferior race”, took a bite of flesh from her forehead in a surprise attack.

The incident occurred in broad daylight on 18 September when Diana Gonzalez, 36, was walking to a local convenience store and the alleged assailant, identified by prosecutors as Kamilia Chadli, threw a food wrapper at her, the victim told Seattle police.

Guardian USA

Trump flyover and Secret Service checks greet fans at marquee Texas v Tennessee clash

Air Force One flies low over Neyland before kickoff
Schools coordinate with Secret Service over headsets
Fans urged to arrive early amid enhanced screening

Encouraging fans to get inside Neyland Stadium earlier than usual with Donald Trump coming to Tennessee’s college football game against Texas sure worked Saturday.

Security checks on the stadium’s perimeter went relatively smoothly with Tennessee officials opening the stadium 30 minutes earlier than normal. Fans got half-price off concessions as a reward for showing up early, and Tennessee faithful had the stands half full 90 minutes before kickoff and nearly packed an hour before.

Guardian USA

Third person arrested in death of Tasia Fortune, as police say hanging was staged

Eric Clark, 45, charged with murder as autopsy concludes Fortune was dead days before body discovered in tree

A third person has been arrested in the death of 29-year-old Tasia Fortune in Mississippi’s capital city, while investigators said they had determined the scene where her body was found hanging had been staged.

Eric Clark, 45, surrendered to authorities on Friday and was charged with murder, according to the Jackson police department (JPD). Clark was scheduled to make a court appearance on Monday.

Chinese Dictionary

老年 lǎo nián

elderly / old age / autumn of one's years (HSK 2)

HACKADAY

A Pocket-Sized Digital Fish Tank

The problem with trying to make a fish tank fit in your pocket is that you’ll either end up with water everywhere or a bunch of dead fish. Perhaps that’s …read more

Guardian Tech

‘Charming and disarming’ … how Meta’s technology-packed Muse harnesses the power of cuteness

The tech giant has launched a cute ‘little guy’ that can answer emails, book travel or do your weekly food shop

After the recent backlash against Meta’s so-called “pervert” smartglasses, this week Mark Zuckerberg launched a much cuter alternative: the Muse “charm” device.

With a screen that shows a cutesy little avatar, it has drawn comparisons with Tamagotchis. “We’ve packed a lot of technology into this little guy,” the Meta founder told the San Francisco audience.

Guardian USA

Wisconsin police investigating fraternity for hazing after men found in basement

Pledges found covered in food in heated basement of fraternity house near University of Wisconsin-Madison

Police are investigating suspected illegal hazing after about 30 partially clothed young men covered in food, condiments and other liquids were found recently in the basement of a fraternity house near the University of Wisconsin-Madison campus.

Madison police said some of the men, whom they described as pledges of a fraternity, had signs of being physically assaulted.

Leif Ames