fate | Flexible Angular Text Editor | Editor library

How can I automate my scoring formula to count odd rows as 1 for TRUE and even rows as 1 for FALSE?

I'm trying to import a quiz that I found in the back of an ancient, eldritch tome into G Sheets. The order of the questions is fixed - the notes in the margins are very specific that a "dire fate" awaits anyone who "dares disturb these ancient mysteries." So I'm putting the questions in G Sheets in order, but in order to count the scores, I need to have every odd row give +1 if the answer is TRUE and every even row give +1 if the answer is FALSE.

I know I could brute force this with addition, such as

=COUNTIF(C2,TRUE)+COUNTIF(C4,TRUE)+COUNTIF(C6,TRUE)...

but every minute I spend typing, I feel the tendrils of existential dread gnawing at the foundations of my soul. Plus, that sounds super-boring.

So, is there a way to automate having COUNTIF() (or COUNTIFS()) do this for me?

• ROW(), but it doesn't seem to play nice with COUNTIFS(), just gives me a 0.

=COUNTIFS(C2:C666,TRUE,A2:A666,ISEVEN(ROW)

• Adding a cheater-column that does this for me with ROW(), but I'm worried that tinkering with the table will unleash untold horrors on our world.
• Maybe something with DCOUNT or ARRAYFORMULA? But those seem to me MORE forbidden than the Necronomicon, not less.

Did try this, but it's just giving me the total number of true values:

=ARRAYFORMULA(COUNTIFS(A3:A24,ISEVEN(ROW()),A3:A24,TRUE))

What else y'all got?

I have time series data across several sites with species presence absence across years. I want to see which species persisted, dropped or added at each site during the whole timeseries. I am only trying to compare the first and last year i.e. 2000 and 2002. The information of species should be saved in a separate column fate. I am pasting example of data and desired result. Any help is highly appreciated.

I have been trying to sort this list of strings for ten hours now. The ten hours was mostly spent fleshing out a workaround but fate is cruel and after all of that effort my workaround still requires me to sort a list of strings without regard for case.

An example of what I would like this function to do:

I'm attempting to write an If Elif Else statement, and I may be approaching this incorrectly. I've built a DataFrame with Pandas, and what I'm attempting to do is signify 1 of 3 statuses in the column. Special Order, Ready to Ship, and just blank or a hyphen. I've tried this several different ways but can't seem to get it to function. What I'm attempting to do is if something has a price of $0.00 to return that third status of just blank or hyphen. Currently regardless of what I do I get either Special Order or Ready to Ship.

This is the code from the website, I apologize it's so messy it's just the way it was formatted from them.

My vertical menu uses images and the image all have a small gap between them. It was suggested to use "display: block" to close the gap, but it doesn't seem to work. Not sure if something else in the CSS is messing with it. See gaps here

NOTE: the aqua color is not permanent. Its just there to better see the gaps.

So I can't get an image that is in the tags to align in the center of the main wrapper/Ul. I've tried adding class to the image in the tag , the tag itself, and the tag, but no matter if I use position or float the image remains just slightly out of the menu wrapper. It's been a few years since I've this, so I must be forgetting a basic step here to get it to work.

Since I didn't get an answer from the Part 1:

Can shapeless Record type be used as a Poly1?

I assume this feature doesn't exist in shapeless. So I decided own my fate and to write one myself:

have a problem with geomesa failed on adding indexes, maybe someones know where problem is?

I would need to configure my Single board computer as an AP, and I managed to do it before and it was working flawlessly (the AP is isolated and not connected to the WAN).

Then today, I needed to connect it online to install some packages. As I have all my connections config in different .nmconnection files, I have modified my AP config file with autoconnect =false and my client mode connection as autoconnect=true, then I rebooted. After reboot, the device has never shown up in my router list. The connection file was working few months ago when I set it up.

then, I decided to accept my fate, and switch back to the original config (APconnection file with autoconnect, client connection file without autoconnect) and then, at the reboot, the AP doesn't show up now.

Can someone help me to figure out what could have happened or help me to diagnose this?

below my AP conenction file as well as my networkmanager.conf