everyday | code from the book Exploring Everyday Things with R | Math library

Simple problem that most likely has a simple solution.

Created a custom menu with 1 function. Now I want to be able to have this custom menu appear in all G sheets. I create a new spreadsheet everyday in Excel and move it to G Drive so that it can be viewed/shared with the whole team. When this new spreadsheet is added to the drive, I want the custom menu to show up so that the one function can be ran to clean up this daily rotating document.

How do I make this custom menu appear in all sheets: new, old, uploaded? I will note this App Script is tide to a

Story: in my java code i have a few ScheduledFuture's that i need to run everyday on specific time (15:00 for example), the only available thing that i have is database, my current application and openshift with multiple pods. I can't move this code out of my application and must run it from there.

Problem: ScheduledFuture works on every pod, but i need to run it only once a day. I have a few ideas, but i don't know how to implement them.

Idea #1: Set environment variable to specific pod, then i will be able to check if this variable exists (and its value), read it and run schedule task if required. I know that i have a risk of hovered pods, but that's better not to run scheduled task at all than to run it multiple times.

Idea #2: Determine a leader pod somehow, this seems to be a bad idea in my case since it always have "split-brain" problem.

Idea #3 (a bit offtopic): Create my own synchronization algorithm thru database. To be fair, it's the simplest way to me since i'm a programmer and not SRE. I understand that this is not the best one tho.

Idea #4 (a bit offtopic): Just use quartz schedule library. I personally don't really like that and would prefer one of the first two ideas (if i will able to implement them), but at the moment it seems like my only valid choice.

UPD. May be you have some other suggestions or a warning that i shouldn't ever do that?

im new to python and trying to understand how to send email alerts. I have a csv file, the below is the dataframe for it:

I want to create a macro where it will copy some data from one workbook (whose name stays always same - "SameNameWorkbook") and pastes that data in another open workbook whose name is changing everyday (because its name is a date). For example today my workbook which I want to paste the data in is called "11.06.2021". What I did is I created a =today() formula in the J2 cell in the active workbook (different from the other 2 and named "CurrentWorkbook") and created a variable in VBA for the workbook with changing name:

I'm having connection pool issues on my service (max reached), everywhere that I try to open a connection I wrap it on a using statement to dispose it correctly, but I think something is not allowing it to work. I think it is because I'm using a method that expects a SqlCommand as a parameter, this is an example:

I have some tables to load from big query to Postgre cloud sql database. I need to do this everyday and create some stored procedures in cloud sql. What is the best way to load tables from big query to cloud sql everyday? What are the costing implications for transferring the data and keeping cloud sql on 24/7? Appreciate your help.

Thanks, J.

Building on Count number of elements with same tag

I will be running this query with BaseX 9.5.2.

Given the data

Building upon books.xml transform to CSV: repeat title on each row:

For the document below, how can I count

• the number of authors per book
• the number of unique authors per book?

In this case, they would both be the same:

I am trying to design a file watcher solution in which I need to watch a particular folder for different file names everyday, once the file name is found, I need to call a script specific to the file name.

Example: