rubber-duck | macro impl and discussion about named & default args | Reflection library

SOLVED EDIT

Thank you for the help. Solution here.

ORIGINAL POST

I have made a google sheet to describe the issue I am facing linked here (https://docs.google.com/spreadsheets/d/1yK6ZAX8BFnEqiuQO9HIxuY0l62ewDDccj-8EN1r2i2w/edit?usp=sharing).

I will also describe in words, below, the problem I am facing, along with the solutions I have tried.

The data of column A are random single-digit (0-9). I would like column B to show the most recent even number from column A, but only up to a specific row. That specific row is the row corresponding to the row of the cell in column B. In other words, in cell B7, I want to find the most recently entered even number of column A, specifically only on the range A2:A7 (A1 contains a column header).

This is actually a pretty simple formula, and I can get the desired outputs by simply checking if the value in a cell in column A is even and then returning the value of that cell if it is, or the output of the cell above if it isn't. So the formula would look something like: ​=IF(ISEVEN(A7),A7,B6)​

However, my problem is that the length of the data in column A will be growing as more data are entered, and my current solution of using the fill handle to copy the formula to new cells is inelegant and time-consuming. So my desired solution is to use an array formula entered into the first cell of column B (B2), capable of returning the same value as the other formula. The formula I tried to enter to perform this was the following: ​=ARRAYFORMULA(IF(ISEVEN(A2:A),A2:A,INDIRECT(ADDRESS(ROW(A2:A)-1,2))))​

However, as some of my previous work with arrays has taught me, not all formulas iterate as expected down the array. The formula seems to be able to return the correct output on lines which are already even, but it is unable to return the expected most-recently entered even number for all the other lines. It appears that the formula is not able to appropriately interpret the ​value_if_false​ argument of the ​IF​ formula.

I'm a little new to scripting, so I'm still trying to learn, but I also tried to dabble around with custom functions to no avail. I'm still wet behind the ears when it comes to coding, which is why I've been so lenient on the built-in formulas of Google Sheets, but I fear I may have reached the limit of what Sheets formulas can do.

I am open to trying new approaches, but my only real constraint is that I would really like for this to be a one-touch (or even better no-touch) solution, hope that's not too far beyond the scope of this issue. Any assistance would be much appreciated.

EDIT

After rubber-ducking the problem here, I went back and tried to use the OFFSET formula, hoping I could get it to play nicely with the array formula. Alas, I was unable, but I thought I should at least post my progress here for reference.

Attempt with offset

Still working at it!

I have a bucket (logs) in Amazon S3 (us-east-1) with, unsurprisingly, logs, partitioned by application and date:

(Warning: This question is absolutely enormous because the problem has a really complicated context. Heck, by the time I finish writing this question I may actually end up rubber-ducking myself into actually coming up with the solution...)

(Edit: That didn't happen. I still have no idea what to do. I hope there's not a site rule against gigantic questions like this... here goes...)

I am writing code for a Discord bot (using Node and Discord.js) which interfaces with a database. (Specifically MongoDB.) Of course, this means double the asynchronous behavior. When I write things in the simplest way I can, things work pretty well, and I think I generally understand Promises, callbacks, and await well enough that I can ensure things happen in the right sequence.

However, in refactoring my code to enhance modularity, I've come across a seemingly insurmountable annoyance: I have lost proper error catching, and things print that they have succeeded while in the same breath the module that it executed (correctly) reports that the command has failed.

First, a bit of background.

The bot has a number of commands that use the database; we'll call them "!insult" and "!joke". The idea behind these commands is that they procedurally put together an insult or a joke which is built from components that the users have added to a database. Each command has a separate "collection" (MongoDB term, think SQL table) containing their respective data that was input by users.

The bot was originally written by somebody else, and their solution for adding and removing things to/from each collection was to have four separate commands: "!insultadd", "!insultdelete", "!jokeadd" and "!jokedelete". My first thought on seeing that was "modularity, eat your heart out. Yikes." The codebase contained a lot of code reduplication like this, and so I made it my goal to abstract functionality enough that much of this reduplication could be eliminated and the codebase would be overall much easier to extend and maintain.

So, I have come up with a command called "!db". There is already a layer of modularity to be found: all that !db does, is call "sub-commands" that implement each individual function. These sub-commands are called things like "!dbadd", "!dbdelete", etc. and they are not intended to be called on their own. An important thing to note is that I wrote these sub-commands first, and only once they were all independently functional, I created !db to wrap them in a simplistic manner, just using a case statement. (For example, invoking !db add insultsCollection "ugly" (where insultsCollection is the collection of insulting adjectives) would simply end up calling !dbadd with the appropriate arguments.) So, originally, each sub-command would print out results on its own, using lines like msg.channel.send('Inserted "' + selectedItem + '" into ' + selectedCollection + '.');.

Originally, this worked just fine. !db didn't have to do anything more than simply:

I'm having serious trouble getting this task to cancel. It's inside a small loop, and it runs fine if I use takeLatest inside the accumulator at the bottom of the function. Nothing happens/the flowControl function appears not to run if I use take.

The cancel action fires, but the task keeps right on running - is this a problem with using while? Is this another problem I'm not seeing?

If the problem is in exporting this flow using the *appRoot at the bottom of the page, how does one properly include a flow-control into a React/Redux store?

I'm using a digispark arduino-compatible device to emulate a keyboard with an US layout (it uses DigiKeyboard.h as library to do so). Now,it just takes as input an integer which represent a key and sends it to the computer following the USB keyboard standards, everything fine until this point.

The problem is that I need this device to work with every keyboard layout, my question is: is there a way to "translate" the numeric value representing a character to the numeric value which represent the same character in any other layout using python? Obviously I cannot change the layout via software on the computer.

Example: lets say that in the US layout the character "x" is represented as the number 1. In the ES layout the character "x" is represented as the number 2. I need an hypothetic function that given the number 1 will output the number 2.

EDIT: Had some researches, couldn't find a proper solution, yet the hak5 team has developed something similar for the rubber ducky, you can find useful files on github

I am currently building a game engine.

UML-Diagram:

I asked a question earlier that was taken down, but I have a better idea of what I want now and have an idea of the code I want to use. The idea is that the person will be able to enter an idea and it will email that idea to me when the form is submitted. This is what I've come up with using PHPMailer:

I have been working on a fairly pointless website where there are multiple "random" generators. You can check it out here: randomwordgen.net16.net As you can see there is an unfinished generator at the bottom, that's what I'm here for. I want to get it to generate a list from things you input. My idea is to add the input field's value to the array that will make the list when you hit "Add to List." Then I will have a separate button that will generate the list using that array. The only problem is that I don't know how to add the string to the array when I only know the name of the variable, not the value. If anyone could help me with any of this, that would be great! This is the code for the whole site: