google sheets – How to keep cells “paired” with query results

I am using an importrange query from other sheet to filter data: https://docs.google.com/spreadsheets/d/1FbeoKhiJ3jqYXqfIgAK_tHXPZ_Z1Xrm33ulu9gomXuE/edit?usp=sharing

The “colors” sheet has data populated from query (“items” sheet) and users are allowed to write comments on each row.

Problem: if row order is changed on “items” sheet, the “colors” sheet row order
will be lost and any previous comment will not match the correct row.

How can I prevent this? Is there a way to keep paired query row results and comments? Maybe using timestamp as a reference?

At the moment sheet “colors” contains a correct pairing, once a row is inserted between “items”, the pairing is lost

multi factor – What are security benefits (if any) of using multiple passwords (device, password manager, …) vs single strong password when paired with FIDO U2F?

I am evaluating security benefits of requiring employees (in enterprise context) to use multiple passwords (or passphrases) vs single strong randomly generated passphrase (minimum of 8 words) when paired with FIDO U2F (using YubiKey).

My gut feeling is that the more passwords we ask employees to create (and memorize), the weaker they tend to be, especially when enforcing regular password rotations.

I would assume many will likely write them on a piece of paper resulting is increased opsec attack surface.

Are there significant security benefits to using difference passwords (or passphrases) to unlock computer vs unlock password manager for example?

My understanding is that both are subject to same keylogger exploits.

Would love to read you guys on this!

cyberpunk 2020 – What book specifies rules for running fast on paired cyberlegs?

In Cyberpunk 2020, suppose you have a team with three members: Apple, Banana, and Canteloupe.

Movement Allowance {MA): This is an index of how fast your character
can run (important in combat situations). The higher your Movement
Allowance (MA), the more distance you can cover in a turn. RUN: To
determine how far your character can run in a single combat round
(@3.2 seconds) in meters, multiply your MA by 3. The character can run
three times this distance in a full 10 second turn. Write this in the
RUN section of your Hardcopy Form. LEAP: To determine how far your
character can leap (from a running start), divide your RUN by 4.
Write this in the LEAP section of your Hardcopy Form.

(p.26, 2020 rulebook)

The Solo, Apple, starts with a Movement Allowance of 2.
This means he can run 6 meters in 3.2 seconds and his RUN score is 18; that is, he can run 18 meters in 10 seconds. His LEAP stat is 18/4=4.5; this means he can do a running jump of 4.5 meters.

His friends, Banana and Canteloupe, have Movement Allowances of 3 and 4. They have RUN scores of 27 and 36; thus they have LEAP stats of 6.75 and 9, respectively. Because the basic rules do not mention vertical leaping, I assume that they cannot vertically leap to any major extent.

This solo, Apple, gets paired cyberlegs.

“Characters with paired cyberlegs can leap 6 meters straight
up, or make a running jump of up to 8 meters.”

(p. 89, 2020 rulebook)

This means that Apple effectively has a LEAP stat of 8. Assuming consistent equations, Apple’s RUN score should be 32. So Apple can run faster than Banana but is still slower than Canteloupe.

As far as I can tell, even though Apple can leap vertically, he is not protected from most falling damage. (If I were GM, I would say because he can leap up 6 meters, he can also fall 6 meters without taking damage IF he lands on his feet, but would take ordinary falling damage if he failed to land on his feet. I can’t find anything in the rules about that.)

As play proceeds, Apple wants to modify his legs so that he can run very fast. In the core rulebook, I cannot find any rules covering this. Some old R. Talsorian books probably have various rules. Which books have rules for running?

combinatorics – How many ways can be 8 players be paired in a group of 5 such that no two players fall in the same group more than 2 times?

I want to know different ways by which n players can be paired in groups of m such that no two players fall in the same group more than two times.

Example:

Input: [1, 2, 3, 4, 5, 6, 7, 8]

Output: {1.2.3.4.5, 1.2.3.6.7, 1.4.5.6.7, 2.4.6.8, 2.5.7.8, 3.4.7.8, 3.5.6.8}

I was able to compute all the permutations possible. But I need to filter that out such that no two players fall in the same group more than 2 times.

proof of work – Decreasing Energy Consumption of Bitcoin’s PoW with paired mining rounds

I found the following whitepaper on an algorithm called “Green-PoW” by the authors and i’m quite sure this would be a perfacet solution and also would get acceptance by the miners and the community.

You can find the white paper here:
https://arxiv.org/pdf/2007.04086.pdf

Key point of the paper here as a quote:

“In order to reduce the energy consumption in PoW, Green-PoW considers
mining rounds in pairs and adjusts the election mechanism during the
first mining round in the pair, to allow the election of a small
subset of miners that will exclusively mine in the second round.
Assuming the total network hashing power is equally distributed among
miners, a significant energy saving up to 50% could thus be achieved”

What is your opinion on this approach, are there any problems with this?

google sheets – How to keep cells “paired” with query results

I am using an importrange query from other sheet to filter data: https://docs.google.com/spreadsheets/d/1FbeoKhiJ3jqYXqfIgAK_tHXPZ_Z1Xrm33ulu9gomXuE/edit?usp=sharing

The “colors” sheet has data populated from query (“items” sheet) and users are allowed to write comments on each row.

Problem: if row order is changed on “items” sheet, the “colors” sheet row order
will be lost and any previous comment will not match the correct row.

How can I prevent this? Is there a way to keep paired query row results and comments? Maybe using timestamp as a reference?

At the moment sheet “colors” contains a correct pairing, once a row is inserted between “items”, the pairing is lost

windows 7 – Creative Outlier Air (bluetooth headphones) – paired successfully, indicator still shows not connected

I bought my GF a pair of Creative Outlier Airs and she loves them when working out. However, she wanted to use them with her (old Win7) laptop as well, so I bought her a bluetooth adapter (TP-LINK UB400).

Now, after a few hurdles I was able to pair the headphones. When I open the bluetooth devices menu, I can see both of them there however with a checkmark in a grey circle, which is supposed to indicate that the device is paired but not connected. This is definitely the case since when I right click the headphones (in the same bluetooth menu) and go to properties – it says State / Status: Not Connected.

The sound settings doesn’t display any bluetooth speaker or headphones.

Naturally, I googled and a couple of people suggested going into Devices and Printers and try ‘Adding a Device’. Windows doesn’t find any new devices.

One thing that might be pertinent to this is that there is a ‘Dongle’ device there which cannot be removed and doesn’t disappear even when the headphones are switched off or the bluetooth adapter is removed from USB, so it’s not clear, at least to me, whether Win7 is considering the heaphones a dongle or whether it is completely unrelated.

Any ideas are very welcome

fitting – Exact line search paired with Nesterov Acceleration for least square sproblem

Thanks for contributing an answer to Mathematica Stack Exchange!

  • Please be sure to answer the question. Provide details and share your research!

But avoid

  • Asking for help, clarification, or responding to other answers.
  • Making statements based on opinion; back them up with references or personal experience.

Use MathJax to format equations. MathJax reference.

To learn more, see our tips on writing great answers.

bluetooth – Xiaomi Mi Band 2 cannot be paired with App Mi Fit in Android 8.1.0

I wanted to pair the LG Q6 with the Mi Band 2.

I installed Mi Fit, created a google account and wanted to pair with the device. However, after a while, an error is displayed stating that it could not be paired and if I want to reset the device.

If I select yes, the 4-digit number will be displayed on Mi Band 2. A window with a box where I should enter the number will appear on my mobile phone. However, this window is partially covered by another error message that it cannot be reset and whether to cancel or resend. In any case, this window cannot be hidden, so it was not possible to write the number.

So I uninstalled and installed the application, but the only thing that has changed is that the reset fails and the number does not appear on the device at all.

Please help

Thank you

PS. Android itself can be paired with the device.

Audio – How do I connect to a paired headset in Windows 8?

In Windows 8 there are 3 Bluetooth menus instead of Windows 7. And none of them offers the possibility to connect to an already paired Bluetooth headset

I can see that the device is paired with devices and printers, and by right-clicking on the Bluetooth icon in the system tray.

However, it does not appear under playback devices

There should be an option to connect to a paired device. This is how Bluetooth works and how it works on my phone.

Why is this option nowhere to be found in Windows 8? Does it somehow try to connect to it automatically? it doesn't make it successful

Please let me know how I can manually connect to an already paired headset. Thanks a lot,