stow | Simple object persistence with boltdb | Key Value Database library

I am in need of help trying to get this VBA macro work, I seem to be messing up with the ability to skip the cell's formula returning a 0 value and moving to the next available cell. In the sample image B1:B5 is good but once it hits B7 and B8 I'd like for it to instead return the next value into B9. The area I have quoted out is the area I am running into issues with.

I've looked everywhere and I can't seem to find an answer, or at least one I can understand at my very limited skill level (I'm essentially teaching myself html, css, and js with practice and Google). I am trying to use document.getElementById("button").onclick = buttonfunc; as part of a function with buttonfunc as a parameter. I've been able to call this function easily enough with something equivalent to Buttons(MyFunction);, because if I put the parentheses like Buttons(MyFunction()); my understanding is that it treats the parameter as the value of MyFunction(), even though it's a void function. The problem with this is that I can't pass parameters with the function, meaning I have to make a new function for every new thing I want a button to do, which I would like to avoid if I can because there might be very mundane or similar function. Is there a way to pass a parameter with the function so that I don't have to make a new one for every minute difference? Thanks in advance!

Here is the full code of the function and some examples of its use (I'm making a text adventure with 8 buttons).

I have a table in KDB with columns date, time, and returns. I need the cumulative returns per day stowed in a new column, but I'm not sure how to separate the sums function by date. This is what I tried:

I have a table with two columns: time, separation. My goal is to calculate the average time intervals that non-negative separation occurs over the table; so if separation is positive for a while and then switches to negative, I want the amount of time that separation remained positive to be stowed in another table (and vice versa). With a table fully built out of just time intervals where separation switched signs, I need to calculate the average of that.

I also would love to be able to stow the average value of separation over the specific time interval into the table and have it keyed with the length of the time interval.

Hoping to have an end table that has a magnitude of time interval in one column (i.e. 00:00:04.129) and the average value of the separation in that interval (something like +0.0014).

So, how can I grab a time range where the separation column is + or -, and match that with the average value of separation over that period?

I get some errors from this SQL code. I am making a mock database for practice. I have looked at some work around and have redone the code a few times.

Everything has been created in order (I believe). Any help would be great! Am I referencing the incorrect tables/columns? Am I referencing different Data types that shouldn't be?

Here are the errors I get:

Msg 547, Level 16, State 0, Line 186
The INSERT statement conflicted with the FOREIGN KEY constraint "fk_bookid". The conflict occurred in database "db_City_Library", table "dbo.Books", column 'BookID'.

Msg 547, Level 16, State 0, Line 63
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "fk_publisher_name_books". The conflict occurred in database "db_City_Library", table "dbo.Publisher",

Code:

I have two git repositories with a few shared subdirectories between them, as shown below.

When I run:

stow -D folderName

I get:

I have successfully deployed and maintained a Google App Engine + Laravel Project using Google Cloud SQL as a database. I'm using Cloud Build to deploy, however on manual deployment my problem occurs just the same. I'm trying to get the locally working Laravel Passport installation to work on Google App Engine.

Laravel Passport needs to run php artisan passport:install in order to generate it's encryption keys and stow them into the database.
The only slot where this is possible in the GAE automatic build process is in "post-install-cmd":[] in composer, however at that stage the database connection is not established yet. => SQL Error while running passport:install

I have also tried SSHing into the App Engine Instance and running passport:install manually, chmod'ing the storage directory to 0600, chown'ing the required passport encryption keys to www-data and yet I still get the following error:
LogicException Key path "file:///app/storage/oauth-private.key" does not exist or is not readable

I am at a lack of options now and sadly cannot find a reference where Laravel Passport has been deployed to a GAE Project.

What I'm looking for is another viewpoint of what might be going wrong. Am I missing something with permissions that's specific to Google App Engine?

Thanks in advance!

I did a fresh install of Laravel 5.4 using the official Laravel installer for Composer. I ran php artisan make:auth to create the system for login/register. The login page works when I manually enter in the user in the database, but my register page gives me the following error: