Query with Date Selector. Both must be inputted or no information is available?

Currently using:


This is used to grab information from two spreadsheets with the same number of columns, with PRI grabbing data with headers and NON grabbing just data.

D1: "select A, B, C, D, E, I, J, K, L, M, N, O, P, Q, R, S, T WHERE A >= date'" & TEXT(B2,"yyyy-mm-dd") & "' and A <= date '" & TEXT(C2,"yyyy-mm-dd") & "'"

This is the reference for the query to look up the start and end date based on two specific cells.

The query using D1 will filter if both spreadsheets have an entry in a specific date range.

EX: PRI and NON both have an Apr7 entry which the query shows both if START is Apr7 and END is Apr13.

But the issue is if only one of the two spreadsheets has an entry then the query shows nothing if the START and END criteria are still correct despite their being an entry between the date criteria.

Is there a way for the query to recognize both spreadsheets at the same time, instead of a “only run if BOTH PRI and NON have an entry” behavior? I definitely feel the query itself is the problem but I could not find any format that works alongside D1.

.IO 3 letter available domains list

I recently checked for availability of 3 letter domains in .IO zone,
and for now, 95% names are registered (some are, though, reserved by registry), including all premium 3 letter combos.
Only 791 domain is available for now. Here's the list.

 AGQ.io AJQ.io AQD.io AQG.io AQH.io AQK.io AQV.io AYQ.io AZG.io AZV.io CQP.io DQE.io DQF.io DQG.io DQI.io DQK.io DQP.io DQU.io DQV.io DQY.io DQZ.io DTQ.io DVJ.io DYQ.io DZE.io DZK.io DZU.io DZV.io EBQ.io ECJ.io EFJ.io EFZ.io EGQ.io EJQ.io EJV.io...
Code (markup):

.IO 3 letter available domains list

Find out how many laptops Molly can buy based on available money, array of quantities and array of costs

Problem description:
Molly wants to purchase laptops for her school. Find out how many laptops she can purchase by comparing the vendors available.
Each vendor sells the laptops in batches, with a quantity identifying how many laptops on each batch, and a cost for the whole batch.
Sample input: 50 [20,19] [24,20] That means Molly has 50 dollars to spend. The first vendor has 20 laptops per batch and each batch costs 24 dollars. The second vendor has 19 laptops per batch and each batch costs 20 dollars.
The possible answers are 40 and 38. If she buys from the first vendor, she will spend 48 dollars (24 * 2) and since she’s buying 2 batches the total quantity is 40 (20 * 2).
If however she would buy from the second vendor, the maximum quantity would be 38, since each batch has 19 laptops and she’d run out of money after the second batch.
The final answer is then 40, since 40 is higher than 38.
This seems similar to the Knapsack problem.

My solution is listed below. The permute method is there to generate the possible permutations between the indices. For instance if we have 3 items in the input array the permutations are:
012 021 102 120 201 210

import static org.junit.Assert.assertEquals; import java.util.List; import java.util.stream.IntStream;  public class ShoppingBudget {    public static void main(String[] args) {     ShoppingBudget sb = new ShoppingBudget();     assertEquals(40, sb.budgetShopping(50, List.of(20, 19), List.of(24, 20)));     assertEquals(20, sb.budgetShopping(4, List.of(10), List.of(2)));     assertEquals(0, sb.budgetShopping(1, List.of(10), List.of(2)));     assertEquals(41, sb.budgetShopping(50, List.of(20, 1), List.of(24, 2)));   }    private void permute(int start, int moneyAvailable, int[] inputIndices,       List<Integer> budgetQuantities, List<Integer> budgetCosts, MaxQuantity maxQuantity) {     if (start == inputIndices.length) { // base case        int possibleMax = findSolution(inputIndices, moneyAvailable, budgetQuantities, budgetCosts);        maxQuantity.value = Math.max(maxQuantity.value, possibleMax);        return;     }     for (int i = start; i < inputIndices.length; i++) {       // swapping       int temp = inputIndices[i];       inputIndices[i] = inputIndices[start];       inputIndices[start] = temp;       // swap(input[i], input[start]);        permute(start + 1, moneyAvailable, inputIndices, budgetQuantities, budgetCosts, maxQuantity);       // swap(input[i],input[start]);        int temp2 = inputIndices[i];       inputIndices[i] = inputIndices[start];       inputIndices[start] = temp2;     }   }    private int findSolution(int[] inputIndices, int moneyAvailable,        List<Integer> budgetQuantities, List<Integer> budgetCosts) {     int remaining = moneyAvailable;     int counter = 0;      for (int index : inputIndices) {       if (remaining == 0) {         break;       }        int quantity = budgetQuantities.get(index);       int cost = budgetCosts.get(index);        if (cost <= remaining) {         int howManyToBuy = remaining / cost;         counter += howManyToBuy * quantity;         remaining -= (howManyToBuy * cost);       }     }      return counter;   }    private int budgetShopping(int n, List<Integer> budgetQuantities,       List<Integer> budgetCosts) {     int[] inputIndices = IntStream.rangeClosed(0, budgetQuantities.size() - 1).toArray();     MaxQuantity maxQuantity = new MaxQuantity();     maxQuantity.value = Integer.MIN_VALUE;     permute(0, n, inputIndices, budgetQuantities, budgetCosts, maxQuantity);      return maxQuantity.value;   } }  class MaxQuantity {   int value; } 

User profiles not available in security

I have a SharePoint 2016 on-prem server farm that I manage. It is set up to sync users from Active Directory and everything appears to be working fine. Since there are multiple OUs containing accounts that I don’t need in SharePoint, I originally set the profile sync up to use a limited set of OUs. Recently, we got a request to set up a site that would be shared with users in a different OU that I hadn’t imported. I went into the user profile service and modified the AD connector so that it would bring the users in. After performing another sync, I checked and the user profiles are now visible and searchable. However, when I go into People and Groups and attempt to add one of these users into a group, they are not available. Any idea what I’m missing here?

Hideous Laughter: What actions are available?

Ah Tasha’s Hideous Laughter, or simply Hideous Laughter in Pathfinder.

My monster’s fell fast and hard to this spell last night, and though it was a wonderful victory for the PCs, I’m now filled with trepidation at the apparent power of this 2nd level spell.

My first question revolves around the possibilities for the afflicted character/monster, the spell reads [emphasis my own]:

This spell afflicts the subject with uncontrollable laughter. It collapses into gales of manic laughter, falling prone. The subject can take no actions while laughing, but is not considered helpless.

Now, a helpless character means:

A helpless character is paralyzed, held, bound, sleeping, unconscious, or otherwise completely at an opponent’s mercy. A helpless target is treated as having a Dexterity of 0 (–5 modifier).

So, since they aren’t helpless and they can’t take any actions…what exactly can they do once they succumb to Hideous Laughter? — Can they move/stand up? Shift? Take attacks of opportunity? Defend themselves?

Is there any information about the Guild of Wonders beyond what’s available in the Guide to Absalom?

I have a player interested in playing a CN rogue with a penchance for artwork trained by a guild of assassins. The Red Mantis seem too evil and don’t work with his backstory for other reasons, but the Guild of Wonders sounds potentially promising. Is there any information about them beyond what’s available in the Guide to Absalom?

How to Fix The following signatures couldn’t be verified because the public key is not available: NO_PUBKEY 3B4FE6ACC0B21F32

I’am runing kali linux and i want to update my apt-get and thid show up

root@TimothyGanoza:~# sudo apt-get update  Get:1 http://us.archive.ubuntu.com/ubuntu artful InRelease [237 kB]  Err:1 http://us.archive.ubuntu.com/ubuntu artful InRelease         The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 3B4FE6ACC0B21F32    Reading package lists... Done    W: GPG error: http://us.archive.ubuntu.com/ubuntu artful InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 3B4FE6ACC0B21F32    E: The repository 'http://us.archive.ubuntu.com/ubuntu artful InRelease' is no t signed.    N: Updating from such a repository can't be done securely, and is therefore disabled by default.    N: See apt-secure(8) manpage for repository creation and user configuration details. 

i tried to fix this using

sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys     3B4FE6ACC0B21F32 

but an error shows

Executing: /tmp/apt-key-gpghome.1RzTFRK7vp/gpg.1.sh --keyserver keyserver.ubuntu.com --recv-keys 3B4FE6ACC0B21F32 gpg: keyserver receive failed: Connection timed out 

What can i do to fix this hope you can help