A movement toward greater use of telemedicine is widening the spectrum of care doctors can provide from afar and enabling more outsourcing of services overseas.
-The Washington Post

IBM Cognos Transformer 11.0.0.68 Microsoft Windows Multilingual

IBM Cognos Analytics Client 11.1.5 Multiplatform Multilingual

IBM Cognos Analytics Client 11.1.6 Multiplatform Multilingual

I've been working with this Excel formula for a month or so. It comes from Leila Gharani's Youtube tutorial.

=IF(ROWS($A$1000:$A1000)<$J$291,INDEX($B$2:$B$300,AGGREGATE(15,3,($N$2:$N$300="Japanese")/($N$2:$N$300="Japanese")*ROW($N$2:$N$300)-ROW($N$1),ROWS($A$1000:$A1000)))," ")

In this iteration, it's indexing column B, which is a list of movie names, and returning a list of every Japanese language film. Film languages are listed in column N. The formula takes advantage of Aggregate's "Ignore error" option; since Excel treats yeses as 1's and nos as 0's, dividing the aggregate results by itself returns an error for all the nos, since you can't divide by zero. Pretty clever. Then the formula multiplies the 1 by the row where it's located, and finally returns the smallest number in the list to the index function (then the second smallest, then third smallest as you drag down the formula).

My question is, how do I add criteria so the film not only has to be in Japanese, but also has to have a RottenTomatoes score of >75%, if Column T is RottenTomatoes scores? I'm feel I should just multiply the Japanese criteria by the RT criteria in brackets and then divide that product by itself, but I keep getting errors when I try this. Maybe my syntax is screwy?

And yes, I know it would be a lot easier to do this using VBA, but I'm running the workbook on Sharepoint, which doesn't support VBA.

Thanks!

Currently I’m in Cork, Ireland to present and perform at the International Sound in Science Technology and the Arts (ISSTA 2019) conference. This year on Thursday, October 31st I am scheduled to give a paper about a project I have … Continue reading →

Hay medidas buenas y no tan buenas, pero el punto de fondo es que todos pongan para superar el Covid19

A movement toward greater use of telemedicine is widening the spectrum of care doctors can provide from afar and enabling more outsourcing of services overseas.

The CFL is idle during the coronavirus pandemic.

The Woodinville grad, who plays for the Philadelphia Eagles, sent packages the school will distribute to its athletes.

Working with a specialty coach for 10 weeks dropped their 40-yard dash times considerably.

One reader reports success with molasses for normalizing bowel movements.

Twice the normal amount of snowfall fell in January and enough snow continued in February and March to maintain a slightly above normal snowpack.

CHATSWORTH, Ga. (AP) — Storms that killed more than 30 people in the Southeast, piling fresh misery atop a pandemic, spread across the eastern United States on Monday, leaving more than 1 million homes and businesses without power amid floods and mudslides. In Alabama, people seeking shelter from tornadoes huddled in community shelters, protective masks […]

You can store and trade Pokémon for free with this cloud-service app when it launches next month, but premium users get expanded capabilities.

The Woodinville grad, who plays for the Philadelphia Eagles, sent packages the school will distribute to its athletes.

Working with a specialty coach for 10 weeks dropped their 40-yard dash times considerably.

The Seahawks announced the signings of five rookie undrafted free agents Friday, including former Washington State quarterback Anthony Gordon and ex-Washington receiver Aaron Fuller. Others announced: Mississippi State tackle Tommy Champion, Albany defensive end Eli Mencer and Texas A&M cornerback Debione Renfro. None was a surprise, as all five were among the undrafted free agents […]

Greg Olsen’s days currently consist of waking up in his permanent home in Charlotte and heading to an office about five minutes away to spend his afternoon zooming in to virtual meetings with the Seahawks.

Earl Thomas was not arrested in the incident, TMZ reported. Nina Thomas, according to the report, was arrested for burglary of a residence with intent to commit aggravated assault. She was released on bond.

WASHINGTON (AP) — A bitterly partisan debate unfolding on whether more Americans should cast their votes through the mail during a pandemic is provoking online disinformation and conspiracy theories that could undermine trust in the results, even if there are no major problems. With social distancing guidelines possibly curtailing in-person voting at the polls in […]

The lawsuit echoed allegations made by other former employees claiming Mark Roe spoke and acted inappropriately while serving as the county’s top prosecutor from 2009 until his retirement in 2018.

Superstar cities bounced back stronger than ever after the Great Recession. But the COVID-19 shutdown is different and the way back will be a challenge unlike any other.

Taylor is seeking his second PGA Tour victory. Phil Mickelson, who is in second place, has won five Pebble Beach tournaments.

Taylor, 31, led after each round in his second PGA Tour victory.

JUNEAU, Alaska (AP) — Byron Mallott, who served as Alaska’s lieutenant governor as part of a “unity ticket” with former Gov. Bill Walker, died Friday. He was 77. Walker called Mallott’s death a “huge shock.” He said they maintained a relationship after leaving office in 2018 and that his last communication with Mallott was about […]

In an article for The Players' Tribune, Seattle Storm star Sue Bird weighed in on what it's like to witness her girlfriend get criticized on Twitter by President Donald Trump, on pay equity in women's athletics and more.

A year and a half after announcing its creation, Facebook has named the initial 20 members of its oversight board, a quasi-independent panel that is to make decisions on thorny issues. The board’s members were named by Facebook and hail from a broad swath of regions around the world. They include Tawakkol Karman, a Nobel […]

A year and a half after announcing its creation, Facebook has named the initial 20 members of its oversight board, a quasi-independent panel that is to make decisions on thorny issues. The board’s members were named by Facebook and hail from a broad swath of regions around the world. They include Tawakkol Karman, a Nobel […]

Since 1993, just five Washington quarterbacks have been drafted in the last 27 seasons — and with little sustained success. Could Jacob Eason finally be the one to snap the streak?

With guests over and nothing to celebrate, UW's Mark Brunell went through an "absolutely horrible" draft day. But his career is proof that what matters isn’t what round you are drafted in, but “the situation you find yourself in."

Former UW quarterback Jacob Eason fell to the fourth round, where the Indianapolis Colts selected him on Saturday to learn from aging veteran Philip Rivers.

On Saturday, Nick Harris was selected by the Cleveland Browns with the 160th overall pick in the fifth round of the 2020 NFL Draft.

The Storm added another veteran forward to its roster on Monday, trading with the Connecticut Sun for Morgan Tuck and a No. 11 pick in the upcoming WNBA draft in exchange for the No. 7 pick. 

Lauren Jackson and Swin Cash, two of the best players in Storm history, have been elected to the Women’s Basketball Hall of Fame.

The Storm re-signed 2018 WNBA MVP and finals MVP Breanna Stewart, the team announced Thursday. 

On a busy day of transactions, the Storm traded guard Kaleena Mosqueda-Lewis on Monday hours after signing free-agent guard Epiphanny Prince. Seattle sent Mosqueda-Lewis to Connecticut for a 2021 second-round WNBA draft pick. The five-year veteran was selected at No. 3 overall by the Storm in the 2015 draft.  She averaged 5.3 points, 1.1 rebounds […]

Storm legend Sue Bird will return for her 19th WNBA season where it began -- in Seattle. The veteran guard and three-time champ has re-signed with the Storm, the team announced Tuesday.

In what felt like a formality, the WNBA on Friday announced its season will be postponed indefinitely due to the coronavirus pandemic.

Live basketball is still on hold, but the Storm held a lot of practice the past week. Ahead of the first WNBA virtual draft, team officials have held practice sessions, focusing on how info will be shared with each other and with the rest of the league's teams.

The Storm selected Kitija Laksa with its first-round pick in the WNBA draft Friday. The shooting guard from Latvia played three years at South Florida but missed her 2018-19 season due to a knee injury.

Analysts expected as much, and that's one reason Microsoft's stock is closing in on the all-time high it hit in early February.

These costumes, from “Downton Abbey” creator Julian Fellowes’ new EPIX miniseries “Belgravia,” are made by their details — and are the perfect relief, in photo form, for the day/week/month/year’s stresses.

Crew member Kai Hamik was already worn down from nearly a month at sea, but the Destination had to hurry to harvest the lucrative snow crab. And icy weather was on the way. Read Chapter 5 of No Return: The final voyage of the Destination.

The Destination is finally discovered lying on its side at the bottom of the Bering Sea. In federal hearings a month later, Dylan Hatfield, who’d lost so much when the crab boat went down, gets to speak his mind. Read the final chapter of No Return: The final voyage of the Destination.

The plot in Kristen Millares Young’s new novel centers around a history of storytelling in Neah Bay, with a quiet, powerful narrative that shakes readers like an earthquake.

With a narrative that follows a 14-year-old seeking liberation from a cult church, Chelsea Bieker gets under readers’ skin with heart-filled prose in her sparkling debut “Godshot,” out now via Catapult.