whoop | automatic data race analysis for Linux device drivers

I need to make a pass/fail sheet that returns a value in A1 based on the consecutive values in Row1. For example, if B1,C1,D1 are pass, A1=pass. But if B1, C1 are pass and D1 is fail, A1=Fail. Which I know how to do using IFs. BUT the thing I'm struggling with is that I need it to continue searching until it finds 3 consecutive passes or otherwise returns a fail.

So: B1=fail, C1=Pass, D1=Pass, E1=blank, F1=Pass needs to return a Pass for A1. There are no limits to how many attempts will be made to get 3 consecutive passes, but there will certainly be gaps in the days the tests are done.

I would prefer to do this with formulas, but I can make it a macro if there's no other way.

I have an existing async function:

I'm trying to insert a user into my laravel forge site automatically, but the seeder is not working. I can create a user and log in, but I'm trying to have a default admin user once the site is live.

I'd like to create a simple csv parser (using the csv module) and handle the error, when the file does not exist.

If I comment out the sleep methods, the code reaches the Finally (and writes out Some error).

What do I miss? In my real example, I do need to do some awaited task there.

I am facing some issues with loading images from URLs in Flutter. Here is my code:

I have the following test setup:

I tried to solve this problem:

The GET method is not supported for this route. Supported methods: POST.

But I can not find right way and error on Laravel 8.

Here is blade:

I'm working on a formula for a "result" column in a table that looks up data in another table based on some criteria in the main one, then displays it. Of the point where I'm getting stumped at, it is returning a dynamic 2D array (row returns are variable dependent on an FILTER/MATCH lookup). Example (4 columns x 3 rows) return value: {1,2,3,4;1,2,3,4;1,2,3,4}

I want to get the product of the values in each column such that the output from the formula using the example return value above would be this: {1,8,27,64}

(Which is the equivalent of doing this: {1,2,3,4} * {1,2,3,4} * {1,2,3,4})

How do I accomplish this using only formula functions?

All of my google searches have been coming back with methods that assume static table size, multiply the columns against each other, and/or the table "existing" within a sheet somewhere (and still don't give the result I'm looking for).

I've already figured this out via VBA, but due to the nature of how I'm using the sheet, waiting for the updates to run via VBA are too slow. It's not that it takes forever - it's only about 3-4 seconds for ~60 rows - but rather that I make a change to my lookup table, wait for the update to the result column in the main table, check the results, make another change, rinse & repeat 50 some odd times while I fine tune things to look the way I want them to, and the delays are wearing on me.

I'm also unsure that I can use helper rows/columns as the results would need to be packed too close together and would just display #SPILL, which results in the formulas referencing it just showing the same thing. So it looks like this needs to be self contained.

Plugins are an absolute no.

(Other little edit: Whoops, I put INDEX/MATCH above when I meant FILTER/MATCH.)

EDIT: Hopefully this will help clarify?

Here's the structure of my main table where this formula resides:

My Formula takes the words from ColA and ColB and uses FILTER/MATCH to do a lookup that 1) returns multiple results, 2) the return results are entire rows, and 3) is an exact match (it returns nothing for words in ColA and ColB that don't exist in the lookup table).

This means that, as of the current state of the formula, I'm getting 2D arrays back for most of the rows in the main table. AFAICT, I'm not going to be able to stick these into a helper column somewhere as they'll overlap and just cause #SPILL which then won't evaluate in whatever formulas then reference them.

I need to turn these into 1D arrays that are 1 row x same-#-as-source columns where the result in each column is the product of only that column's contents. I'm then going to continue building off from this formula with more formula to achieve my final result that will fit nicely in the single cell. (I already have that piece solved. It's just going from the 2D -> 1D product array I need help with.)

I have a problem with CSS counters once again! In chrome the counter works without problems, in firefox it has trouble counting correctly!