formulas – Google Sheets – How can i collect and add values related to a value next to it in a table and add them to another table

I’m using app sheets to see what I do in a day. I select the task i am starting on the app and app sheets dumps the data into a table in google sheets.

I have made an example of what this looks like. Sheet1 is what it looks like At the moment and sheet2 is what I would like it to look like.

I can get the dates in just fine using the UNIQUE function but I’m struggling with the values.

If you have any questions or answers please tell me as I have been pulling my hair out trying to do this.

Is there a music streaming service that auto plays related tracks, but always me to mark “bad” tracks so I never hear them again?

One thing I love about YouTube is the auto play feature. I pick a track I like, and it starts a playlist of “related” music. I find a lot of new music I like this way.

But it often chooses tracks I can’t stand. What I long for is a button that tells YouTube to skip a track and never auto play it for me again.

I am vaguely aware of a Spotify feature that selects ~30 new tracks for me every week, but what I really want is something like YouTube that I can just turn on and let run.

Tree-structured filter and related table columns

I’m struggling with the logic of a filtering option. In that filter I have multiple roots and nodes (see example below):

root structured filter

The user can interact with the filter and select either an entire root and all its nodes (e.g. Fruit), or just some nodes inside one root (e.g. Apple and Zucchini).

In the table where the selected options will be filtered for, I would like to display roots and nodes in two distinct columns, like so:

enter image description here

The first column (e.g. Groceries category) is the one the user will go check most of the time to have a high overview of the elements in the table, but I don’t know if it makes sense to have two columns for one filter.


How are these two leaky bucket algorithms related?

enter image description here

enter image description here

I am studying about leaky bucket algorithm but I am unable to relate these 2 algorithms

I will do guest post on high DA & PA dofollow seo backlinks on related sites for $10

I will do guest post on high DA & PA dofollow seo backlinks on related sites

Would you like to publish a GUEST POST with a permanent do-follow backlink on a high DA site? Guest posts with permanent backlinks from the website are enough for ranking online!

Is there a reason you should hire me? It’s best to keep it simple. Using best result websites, I will create high-quality backlinks boosting the ranking of your website.

A well-built and organically-trafficked website will also give it good results.


  • Do follow permanent Backlink
  • Guest post on high da site
  • 100% Quality work
  • Real traffic
  • Index guaranteed
  • Boost Ranking
  • High DA/PA
  • Good referring domains

If you have any question, you can contact me


wp query – Display related CPT with custom taxonomy

I have two custom post types: “storefront_location” and “services”

These are linked by a custom taxonomy “location”

I am building a post template for “storefront_location” and would like to display a listing of the “services” posts associated with any given storefront.

What I’m trying to achieve:

A “storefront-location” post, London, is categorized with “london” (“location” taxonomy).
I would like that London “storefront-location” post to display all “services” which are also categorized with “london” (“location” taxonomy). Users could then click on each service to read about it, since these are post types.

I’m trying to get the taxonomy information of the current post (London) and use tax-query to find all the services that share the same taxonomy with that specific London post.

Note: this is for a WP_query filter in Elementor, so the extra code for the Elementor query is from their tutorial here.

I’m fairly new to this, so there might be a newbie problem here. I’ve been trying to figure this out from other code examples here on stack exchange. I’d appreciate any help!

add_action( 'elementor/query/my_filter', function( $query ) {
//get the storefront-location post's location
   $custom_terms = wp_get_post_terms($post->ID, 'location');

if( $custom_terms ){

    //hold tax query parameters
    $tax_query = array();

    // loop through locations and build a tax query
    foreach( $custom_terms as $custom_term ) {

        $tax_query() = array(
            'taxonomy' => 'location',
            'field' => 'slug',
            'terms' => $custom_term->slug,


    // put all the WP_Query args together
    $args = array( 'post_type' => 'services',
                    'posts_per_page' => -1,
                    'tax_query' => $tax_query );

    // finally run the query
    $loop = new WP_Query($args);

    if( $loop->have_posts() ) {

        while( $loop->have_posts() ) : $loop->the_post(); ?>

        <div class="listing-title"><?php the_title(); ?></div>     
        <?php endwhile;



How can I index arbitrarily related entity data in a Search API index the same as if it were an entity reference?

This is possible with custom search_api processors.

First, I created an abstract class to use as a base for the shared functionality. I.e. a method to index arbitrary entity data with a piece of content.

namespace Drupalmy_modulePluginsearch_apiprocessor;

use DrupalCoreEntityContentEntityInterface;
use Drupalsearch_apiDatasourceDatasourceInterface;
use Drupalsearch_apiItemItemInterface;
use Drupalsearch_apiProcessorEntityProcessorProperty;
use Drupalsearch_apiProcessorProcessorPluginBase;
use Drupalsearch_apiUtilityUtility;

 * Base plugin class for indexing arbitrarily related entity data.
 * This can be helpful to index properties of entities referencing an entity or
 * entities related in some other arbitrary way.
 * @package Drupalmy_modulePluginsearch_apiprocessor
abstract class RelatedEntityBase extends ProcessorPluginBase {

   * {@inheritdoc}
  public function getPropertyDefinitions(DatasourceInterface $datasource = NULL) {
    $plugin_definition = $this->getPluginDefinition();
    $properties = ();

    if (!$datasource || $datasource->getEntityTypeId() !== $this->getIndexedEntityTypeId()) {
      return $properties;

    $definition = (
      'label' => $plugin_definition('label'),
      'description' => $plugin_definition('description'),
      'type' => 'entity:' . $this->getRelatedEntityTypeId(),
      'processor_id' => $this->getPluginId(),
      'is_list' => TRUE,
    $property = new EntityProcessorProperty($definition);
    $properties($this->getPluginId()) = $property;

    return $properties;

   * {@inheritdoc}
  public function addFieldValues(ItemInterface $item) {
    /** @var DrupalCoreEntityContentEntityInterface $entity */
    $entity = $item->getOriginalObject()->getValue();

    $to_extract = ();
    foreach ($item->getFields() as $field) {
      $datasource = $field->getDatasource();
      $property_path = $field->getPropertyPath();
      ($direct, $nested) = Utility::splitPropertyPath($property_path, FALSE);
      if ($datasource && $datasource->getEntityTypeId() === $entity->getEntityTypeId() && $direct === $this->getPluginId()) {
        $to_extract($nested)() = $field;

    foreach ($this->getRelatedEntities($entity) as $relation) {
        ->extractFields($relation->getTypedData(), $to_extract, $item->getLanguage());

   * Get an array of related entities.
   * This should return an array of fully loaded entities that relate to the
   * $entity being indexed.
   * @param DrupalCoreEntityContentEntityInterface $entity
   *   The entity being indexed.
   * @return array
   *   An array of entities related to $entity.
  abstract protected function getRelatedEntities(ContentEntityInterface $entity): array;

   * Get the entity type id of the entity being indexed.
   * This is the entity type of the $entity passed to
   * $this->getRelatedEntities().
   * @return string
   *   An entity type id string, e.g. 'node', 'media', or 'taxonomy_term'.
  abstract protected function getIndexedEntityTypeId(): string;

   * Get the entity type id of the related entities.
   * This is the entity type of the items returned from
   * $this->getRelatedEntities().
   * @return string
   *   An entity type id string, e.g. 'node', 'media', or 'taxonomy_term'.
  abstract protected function getRelatedEntityTypeId(): string;


Next, I created plugin classes that extended my abstract class for each case (Collection’s Authors, Article’s Collections, Author’s Collections). For example, to index data from an Article’s Collections as part of the Article’s indexed data:

namespace Drupalmy_modulePluginsearch_apiprocessor;

use DrupalCoreEntityContentEntityInterface;
use Drupalmy_modulePluginsearch_apiprocessorRelatedEntityBase;

 * Index properties from Collections referencing an Article.
 * @SearchApiProcessor(
 *   id = "my_module_article_collections",
 *   label = @Translation("Article's Collections"),
 *   description = @Translation("Index properties from Collections referencing this Article."),
 *   stages = {
 *     "add_properties" = 0,
 *   },
 * )
class ArticleCollections extends RelatedEntityBase {

   * {@inheritdoc}
  protected function getRelatedEntities(ContentEntityInterface $entity): array {
    return my_function_to_get_article_collections($entity)

   * {@inheritdoc}
  protected function getIndexedEntityTypeId(): string {
    return 'node';

   * {@inheritdoc}
  protected function getRelatedEntityTypeId(): string {
    return 'node';


This allowed me to index data from a Collection as part of an Article’s data, for example the Article’s Collection Ids (i.e. the Ids of Collections referencing the Article). I can index any field from the Collection – by selecting the field I want in the UI – the same as if the Article had an entity reference field referencing the Collection. (Note: before you can index any fields with the custom processor, you must first enable it on the Processor tab for your index.)

This all worked great, however, my indexed data did not stay synced with reality. For example, if I added a new Article to a Collection, the indexed data for that new Article would not get updated with information for the new Collection. I.e. the Article was not getting re-indexed if a Collection referencing it was updated. I resolved this with a hook_ENTITY_TYPE_update() implementation that marks dependent Articles to be re-indexed when a Collection is saved.

use DrupalnodeNodeInterface;

 * Implements hook_ENTITY_TYPE_update().
function my_module_node_update(NodeInterface $node) {
  if ($node->bundle() == 'collection') {
    $articles = ();

    // Gather all Articles that this Collection references.
    $articles = my_function_to_get_collection_articles($node);
    // Also gather any Articles that were referenced before this save, but are
    // no longer referenced.
    $original_node = isset($node->original) ? $node->original : NULL;
    if ($original_node instanceof NodeInterface) {
      $articles += my_function_to_get_collection_articles($original_node);

    // Mark the articles to be re-indexed.
    foreach ($articles as $article) {
      /** @var Drupalsearch_apiPluginsearch_apidatasourceContentEntityTrackingManager $tracking_manager */
      $search_api_tracking_manager = Drupal::service('search_api.entity_datasource.tracking_manager');

      $indexes = $search_api_tracking_manager->getIndexesForEntity($article);
      if (!empty($indexes)) {
        $item_ids = ();
        foreach ($article->getTranslationLanguages() as $langcode => $language) {
          $item_ids() = $article->id() . ':' . $langcode;
        foreach ($indexes as $index) {
          $index->trackItemsUpdated('entity:node', $item_ids);

After all of this, I can safely index data from arbitrarily related entities.

arithmetic geometry – A specific Diophantine equation related to the congruent number question

Let $n$ be an odd square free natural number. J.B. Tunnel in his 1983 paper, showed that a number $n$ is congruent, if and only if the number of triples of integers satisfying $2x^2+y^2+8z^2=n$ is equal to twice the number of triples of integers satisfying $2x^2+y^2+32z^2=n$. This is by assuming the BSD conjecture, but still we do not know an efficient (polynomial time) algorithm to determine whether a number is congruent or not, from the theorem stated above.

I am trying to move with this problem a little. A simple observation tells us that, if $(alpha,beta,gamma)$ satisfies $2x^2+y^2+32z^2=n$, then $(alpha,beta,2gamma)$ and $(alpha,beta,-2gamma)$ satisfies $2x^2+y^2+8z^2=n$. So, like this we deduce that if $2x^2+y^2+8z^2=n$ has twice integral solution than $2x^2+y^2+32z^2=n$, then $2x^2+y^2+8z^2=n$ cannot have its integral solution with $z$ odd.

So, now the problem reduces to for what values of $n$, we will have an integral solution of $2x^2+y^2+8(2z+1)^2=n$. If it has a solution then $n$ is not congruent, otherwise it is. Now, I do not know how to proceed any further. As, the equation is not homogenous, one cannot directly invoke Hasse Minkowski’s local global principle, so trying to solve over $p$-adics is not an option. However, if one fails to find solution over $mathbb{Q}_p$ for any $p$ for a particular $n$, then $n$ is congruent. By this, I was able to prove that the numbers $nequiv 5$ mod $8$ and $nequiv 7$ mod $8$ are always congruent, as this type of numbers were failing to give any solution mod $8$ and hence, there was no $mathbb{Q}_2$ solutions. But this will never say whether a number is not congruent.

I do not have any idea to proceed with the problem. Again, the diophantine problem is for what $n$, does $2x^2+y^2+8(2z+1)^2=n$ has integral solutions. Any suggestions or directions to move will be really helpful.

799 Casino, Gambling, Poker, Betting Related High Authority unique PBNs Blog Post INDEX backlinks for $99

799 Casino, Gambling, Poker, Betting Related High Authority unique PBNs Blog Post INDEX backlinks

799 Casino, Gambling, Betting Related High Authority unique PBNs Blog Post INDEX backlinks

799+ Mix Backlinks Poker Casino Gambling Situs Judi Agen Bola Slot web 2.0 PBNs Post Boost Your Site

We create manual & Powerfully backlinks such as PBN, Web 2.0 Blog, Wiki Blog, Forum Blog, Article Submission & Google maps. Those backlinks are most important for you website/ SEO & get huge traffic & get more benefit. Here we build SEO campaign for your poker, slot, bingo, blackjack website which contain highly diversify, unique, High DA PA backlinks by our expert team which help you to get ranked organically

Get higher-ranked against your competitors, give your website an SEO boost to get more visitors. You can Rank Easily Google First Page you Website By Our All In One Service. All In One Service is most essential for the SEO.

Service Features :

DR( Domain Rating) 50 to 75

Spam score zero

100% Niche Relevant Permanent links

High Quality Contextual Backlinks

White hat SEO Technique

100% Niche Relevant

SEO optimized article

Unique casino related article post links

All Links are Homepage Dofollow and permanent

Safe according to google new updates 2021

Fastest Ranking Improvement

100% Google Index

Permanent Роst

Get More Traffic

100 % Highly Еffесtіvе

Delivery On Time

Boost Уоur Wеbsіtеs Ranking

Friendly Customer Service

What Will You Get:-

100 Web 2.0 submissions

100 Forum Links

100 Social Bookmarking

100 Article submission

100 Wiki Backlinks service

100 Social network

100 Quality DA 80+ Profile Backlinks

99 Pr9 backlinks

Please contact me if you want to discuss before starting work, I am available 24*7 to discuss & will be happy to help you.

Place the order now and help your website improve on Google rankings with High-Quality SE0 service!


domains – What are the best suitable TLDs for IT related website?

domains – What are the best suitable TLDs for IT related website? – Webmasters Stack Exchange

DreamProxies - Cheapest USA Elite Private Proxies 100 Cheap USA Private Proxies Buy 200 Cheap USA Private Proxies 400 Best Private Proxies Cheap 1000 USA Private Proxies 2000 USA Private Proxies 5000 Cheap USA Private Proxies - Buy Cheap Private Proxies Buy 50 Private Proxies Buy 100 Private Proxies Buy 200 Private Proxies Buy 500 Private Proxies Buy 1000 Private Proxies Buy 2000 Private Proxies New Proxy Lists Every Day Best Quality USA Private Proxies