Latest

Excel - Pivot tables with text values or numbers without calculations

Objectives

Create a Pivot table that displays text data or number values that are not summarized (count, sum, etc...). This solution does not require macros or long search/replace functions, just the Microsoft Power Query tool that comes with Excel 2016 or can be installed for free as an add-on in previous versions.

Drupal - Duplicate view results in multi language sites

This article explains how to eliminate the duplicate pages that appear in multi-language Drupal site views. The solution was tested on Drupal 8 but works well in previous versions.

Duplicate pages normally appear in:

  • Banners
  • Most Popular Lists
  • Related Content lists
  • Slideshows
  • Taxonomy terms
  • What's new pages
  • Lists or Tables
  • Views in general

Types of duplicate pages

There are two types of duplicate results in multi-language website views:

Equations and algorithm for Reverse Osmosis systems normalization

Normalization is a conversion of operational data that allows the user to compare operation at a specific set of conditions to a reference set of conditions in Reverse Osmosis plants. This allows the user to determine whether changes in flow or rejection are caused by fouling, damage to the membrane, or are just due to different operating conditions: temperature, flow and recovery changes and feed water salinity variations.

Equations and algorithm for Reverse Osmosis membranes comparison

Reverse Osmosis and Nanofiltration membrane datasheets specifications are good for evaluating the quality of the delivered products but almost useless to compare products performance. The main reason for that is that every membrane was tested under different conditions (pressure, salinity, solution composition, recovery, pH and temperature).

Water mass transport coefficient (A-Value) and Salt mass transport coefficient (B-value)

RO and NF membranes can be defined by two parameters known in the industry as A and B-values.