uf2 | UF2 file format specification

I am a software engineer working on a microcontroller system for a side project. The microcontroller I am using is the SparkFun ProMicro (based on the RP2040 board). I am trying to flash the board so that I can write data to the onboard flash memory.

All of the tutorials I have found online suggest starting in boot mode, dragging and dropping the UF2 file, and done!

When I do this, the microcontroller ejects from my computer. Is that meant to happen? It just reboots then doesn't reboot in bootloader?

Once I got MicroPython installed I moved on to writing and flashing code to the board.

I am using the Thonny IDE which identified the correct board (albeit the PICO), then saved the following file as main.py (taken from RPI foundation). It prints toggle, and I believe the output shows that it is being printed from the board, but the light on the board isn't blinking. (code and output below)

I considered that the pinout could be different from this board and the PICO, but some research shows they both use Pin 25 for the LED control.

All this leads me to believe I am on the right path, but I think I am missing something that is taken for granted in the tutorials. My end goal is to write arbitrary text data to flash storage, but I understand it can only take about 8000-10,000 writes before it becomes unreliable, so I want to test that I can write working code before I use some of those.

Is there something I am missing, or am I not thinking about this in the right way?

I recently started working on a small driver for the raspberry pico and the bme280 sensor. I wanted to use the official bosh API written in C and therefore decided to write all the code in C using the micropython C api to write usermodules. I managed to get my code compiled into a UF2 file and my module shows up when I try to list the modules with help('modules'). When I import my module the class with the driver code shows up in dir(mymodule) but when I try to create an object the terminal connected to the PICO hangs and doesn't respond anymore.

I have one dataframe with staff (in ~8 different positions) assigned at many (~70+) different locations, e.g.

I have another dataframe with openings (unstaffed positions), but the columns are not in the same order. e.g.

I'm ultimately looking for a summary table that shows the staffing rate by location/position, e.g.

So far, I have successfully merged the first two tables together (using left_join because there are some locations with no unfilled jobs that are simply not present in the shortages table) with by = location, suffix = c(".f", ".uf") for filled and unfilled, leading to a table that looks like:

Question: Is there any way (other than looping over job types, using dplyr if possible) to mutate the columns based on matching names, for example data %>% mutate(fill_rate1 = Job1.f / (Job1.f + Job1.uf)) without manually typing a separate line for each job type? My inclination says there should be some "wildcard"/regex matching techniques, but so far I haven't had any luck.

EDIT: Reproducible code below

This should be so easy (and probably is) but I can't see it. I'm hoping someone will see the problem quickly and help me to fix.

So I've got a Listbox1 and users can select items to move into Listbox2. In order to do anything with their selection, I need to move everything from Listbox2 into Excel for further analysis. Sounds simple, doesn't it?

The Userform should then close Me and another Userform should be displayed (either UF1, UF2 or UF3; a formula in G3 calculates which new form should be displayed).

Selecting distinct values from the above result set i.e, thereby eliminating duplicate values and finally storing these values into a variable with a comma-separated list of values. Such that variable assigned with a comma-separated list of values must be given as an input to another SQL IN Operator

I have a 3D oriented point (XYZ + Yaw/Pitch/Roll). Lets say this point is based on "user frame 1" (UF1)(the frame is defined in relation to the world frame (WF)).

I also have another "user frame", lets call it "user frame 2" (UF2) that is also defined in reference to the world frame.

How would I take my 3d oriented point (6 coordinates; 3 location + 3 rotation) from one frame to another ?

For example; Since all user frame are related to the world frame, How would I calculate (transform) my 3d oriented point from UF1 to WF ? Or vice-versa or from any combination ? (UF1->WF, WF->UF2, etc.)

The resulting point must have the 6 coordinates (3 location + 3 rotation) in relation to the destination frame.

PS: I'm mainly working in C#, so if possible code sample or pseudo-code to accomplish this would be appreciated.

In Font Awesome 4x I managed to set the cursor as an icon by changing it into a base-64 image url. Now in Font Awesome 5 it does not work any more.

I've found this solution, but it's not working here.

This is what I've tried.

I'm using the beta MakeCode for Mindstorms EV3 at https://makecode.mindstorms.com/ and I've found an issue that might be a bug.

I'm using the Motor Invert block to reverse the direction of my motors. When I check the result on the simulator, I see the direction of the motors change, but when I download the .uf2 file to the EV3, the motor's direction of rotation doesn't change. I've tried putting the "inverted" setting to "on" and "off" and I see that affecting the simulation but not on the physical robot.

I tried changing the EV3 output ports but that didn't help.

Here is the Javascript version of my code.

I have scenario in which I am storing user email in a table user_info. Its structure is given as below.

user_info(_id,email)

However one user can be friend of other users.So for that purpose i have another table user_friend. Its structure is given below

user_friend(_id,userA , userB)

Now suppose there are 5 user A,B,C,D and E. We got table values something like this.

user_info