Spreads | Exploratory Analysis of Data Streams | Time Series Database library

For practice I've implemented the qoi specification in rust. In it there is a small hash function to store recently used pixels:

index_position = (r * 3 + g * 5 + b * 7 + a * 11) % 64

where r, g, b, and a are the red, green, blue and alpha channels respectively.

I assume this works as a hash because it creates a unique prime factorization for the numbers with the mod to limit the number of bytes. Anyways I implemented it naively in my code.

While looking at other implementations I came across this bit hack to optimize the hash calculation:

I'm trying to find a way to determine if a time falls between two specific times - with two different scenarios to flag. So far, I'm coming up empty (and frustrated!)

Column B has date/times such as:

I have multiply taps in one sheet A, each tap has 5000+ rows, some rows have the same content and want to find specific rows, while entering content and copy those rows which are matching to a different sheet B and keep the formatting etc from sheet A.

Example: I need to make a shipping/order list I have 2 sheets Sheet A is full of information (my stockload), multiply tabs with a lot of rows in each tab. in Sheet B (new URL) I want to filter the information.

Lets say, I have 5000 articles spread in 5 tabs on Sheet A, someone is ordering 20 articles, so I just want to scan the EAN or any other code on that article to Sheet B, and all rows with that data, will be imported. Now I have a brand new list with only the 20 articles, which I can share to the client.

I have tried with script:

I'm not sure how to even ask about this; hopefully this explanation is clear enough.

Using a VBA recorded macro, with the relative selection on, I have a formula that uses the countif($C$656:C656,[@Column1]) (which is actually the cell directly below the Table Header, Column1)

The problem I'm facing is the formula doesn't translate as the variable locations because I don't know how to use relative code to actually tell vba to search all the way up the Table column until you reach the cell directly below the header. It must be relative because the table is not always created on row 655 and has varying numbers of rows within the table itself so I can't tell VBA R[1]C[1]:R[367]c[1] for example.

Below is the formula entered in the cell itself (B656).

Im trying to bring the first 7 column from a spreadsheet to another spreadsheet using google app script but I honestly searched a lot and didn't find a way to do so.

GOOGLE SPREAD SHEET 2 ( TABLE )

Been trying a scenario where i want to spread out the return data into several columns instead of lengthy rows

e.g.

I am trying to render a table on shinyapps.io, but it is populating with all NA's. I am scraping NCAA basketball spreads from https://www.vegasinsider.com/college-basketball/odds/las-vegas/. Locally, the table renders fine. But on shinyapps.io, all the numeric spreads display as NA's. It only displays correctly on shinyapps.io if all the spread values are characters. But then I cannot perform any math operations. As soon as the BetMGM, Caesers, FanDuel columns are numeric, they display with NA. I'll provide some code and data to help recreate the issue. There was a lot of data cleaning steps that I will skip for the sake of brevity.

@akrun here is the code to scrape the table. I do this and then some regex to split apart the game_info into components.

I am creating an InDesign plugin where one of the features is to draw shapes on a given page.

I get a drawing from the backend with the page number on which it should be drawn.

For this, I do : app.activeDocument.pages[index] to get the page I want.

Unfortunately, I realized that this technique only works when the pages are not facing each other like this :

When the pages are facing each other like this :

, the shapes on page 3 will be drawn on page 2 instead of on page 3.

Here, the drawings are on the right page :

But here, the rectangle isn't on the right page :

I also tried to draw the shape in a raw way by doing app.activeDocument.spreads[indexSpread].pages[1], which should logically write the note on the 2nd page of the board in question except that it is always drawn on the 1st page of the board.

Here is my code to draw the rectangle :