Tutorial

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:

Installation of the rear speakers on the Suzuki Jimny

If you have a Suzuki Jimny up to 2011 (or later) you probably noticed the very bad sound quality of the original sound system. The bad quality is not from the receiver/player but from the low-end Sanyo speakers included on the car and the absence of rear speakers. This tutorial will teach you how to install the rear speakers.


To preserve the original factory warranty this installation will not alter the electric cables, the car body or the holes for fixation.

Installing an USB/SD/MP3/Aux-in adapter on the Suzuki Jimny OEM Radio

The OEM Clarion Radio that comes with the Suzuki Jimny doesn't allow modern media inputs as most of the car radios. It comes only with a CD player and a AM/FM receiver. Replacing this unit with a convencional 1 or 2-din stereo is not that simple since the dash has an unusual round edges hole. Fortunately the manufacturer of the radio, Clarion, included a CD changer port called Cenet (anyone uses a CD changer nowadays?)