Can you mark new target with Hunter’s Mark if original shifts to different plane?

In the description for Hunter’s Mark, it says:

If the target drops to 0 hit points before this spell ends, you can use a bonus action on a subsequent turn of yours to mark a new creature.

That seems clear, and it’s how we’ve been running it: the target’s HP must be brought down to 0 before the mark can be moved. We haven’t found anything in RAW specifically saying you can’t move it, but it doesn’t seem to fit the spirit/intent of the spell.

But tonight, something unexpected happened and we were not 100% sure how to rule it. A target marked by the party’s Ranger decided it had taken enough arrows and Plane Shifted elsewhere. While the ranger’s Hunter’s Mark spell was still active, there was no way to track the target at this point, either. Does she have to recast it to mark a new creature, or is she able to move the mark to another target, since the original target is, for all intents and purposes, gone?

optimized multiplications using only shifts and additions

I have some doubts regarding the implementation of multiplications by shifts and adds only.

I have a set of coefficients that I’ve use to multiply some variable. For example, I need to multiply tmp by coefficient 15/36. The coefficient is always in the for of k/2^m, and I have a lot of different coefficients (99 in total, and k<2^m). Hence I have the next:

tmp*15/36 is equivalent to (tmp<<3 + tmp<<2 + tmp<<1 + tmp)>>5. It requires 11 shifts and 3 additions.

Now, with this coefficient it is more efficient to do the next: tmp – tmp*17/36 which is equivalent to tmp – (tmp<<4 + tmp)>>5. In this case the same result is obtained with 9 shifts and 1 addition and 1 subtraction, which is a bit more optimized than in the first case.

Contrary, when coefficient is 19/32 it is more efficient to keep it like that, than to use it as 1-13/32, since the number of shifts and adds will be the same and we will need one subtraction in addition.

In summary, my question is how to determinate when to use coefficient directly, and when to use it in the form of 1-(2^m-k)/2^m? Is there any way to conclude it automatically?

Thank you.

What effects does memory space have on bitwise shifts?

It is true that the bitwise left shift operation (shl) doubles the value of the integer being shifted. However, when constrained to a finite space, such as 8 bits for example, left shift will begin to push bits off the high-order word and will cause loss. What mathematical effect does this loss have on the number? Does it somehow cancel the doubling effect of the shift?

A related operation is the rotate left operation (rol), in which this loss does not occur.

What does Banishment do if the target Plane Shifts back?

When the spell Banishment is cast:

If the target is native to a different plane of existence that the one you’re on, the target is banished with a faint popping noise, returning to its home plane. If the spell ends before 1 minute has passed, the target reappears in the space it left or in the nearest unoccupied space if that space is occupied. Otherwise, the target doesn’t return.

Unlike the case where the target is native to the plane, they are not incapacitated for the duration of the Banishment. That means the target could potentially cast a spell, like Plane Shift, to return to the plane they were banished from.

If they do this, do either of the effects at the end of Banishment (“reappears” if the spell ends early, or “doesn’t return” if it doesn’t) have any actual effect, given that the target has already extracted themself from the plane they were banished to?

Adding a row to PowerQuery table shifts data

I’ve got a small project that is used for keeping track of attendance. In this project i’ve used a single table that is referenced by each sheet (Different weeks) in order to sync up the participants that i need to keep track of.

In each week, i’ve added a number of columns in order to fill them according to wehter they were present that day or not.

That works perfectly. The issue comes in when you add a row to the participant table. The custom columns that i’ve added don’t follow the data loaded from the participants table.

This is before

Normal behaviour

And this is after i added a single row in between

Weird behaviour

(Click the links above for images)

Anyone any idea on how to get similar results? All the cells that can be filled by a user are lists defined with data validation btw.