Tutorial by Examples: s

Count Unique values in Range

Function countUnique(r As range) As Long 'Application.Volatile False ' optional Set r = Intersect(r, r.Worksheet.UsedRange) ' optional if you pass entire rows or columns to the function Dim c As New Collection, v On Error Resume Next ' to ignore the Run-time error 457: "Th...

excel-vba • User Defined Functions (UDFs)

Format Excel files with xlsxwriter

import xlsxwriter # create a new file workbook = xlsxwriter.Workbook('your_file.xlsx') # add some new formats to be used by the workbook percent_format = workbook.add_format({'num_format': '0%'}) percent_with_decimal = workbook.add_format({'num_format': '0.0%'}) bold = workbook.add_forma...

Python Language • Python and Excel

Character modifications

Character modifying functions include converting characters to upper or lower case characters, converting numbers to formatted numbers, performing character manipulation, etc. The lower(char) function converts the given character parameter to be lower-cased characters. SELECT customer_id, lower(cu...

SQL • Functions (Scalar/Single Row)

Definition: Intrinsic Content Size

Before Auto Layout, you always had to tell buttons and other controls how big they should be, either by setting their frame or bounds properties or by resizing them in Interface Builder. But it turns out that most controls are perfectly capable of determining how much space they need, based on their...

iOS • Content Hugging/Content Compression in Autolayout

This is part of the layout file

<?php /* this example is based on the advanced template * This file is located in * backend/views/layouts/main.php */ use yii\helpers\Html; // here the asset is registered use cinghie\adminlte\AdminLTEAsset; AdminLTEAsset::register($this); ?> <?php $this->beginPage...

yii2 • Asset management

This is the Asset File

<?php /** * This file is the Asset Bundle File located in * vendor/cinghie/yii2-admin-lte/AdminLTEAsset.php * @copyright Copyright &copy; Gogodigital Srls * @company Gogodigital Srls - Wide ICT Solutions * @website http://www.gogodigital.it * @github https://github.com/cinghie/yii...

yii2 • Asset management

The generated HTML with automaticaly loaded assets

<!DOCTYPE html> <html lang="en-EN"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta name="csrf-param" content="_csrf"> <me...

yii2 • Asset management

Create your own collection and use it to collect all your losses.

Here we will create collection for losses of Neural Network's computational graph. First create a computational graph like so: with tf.variable_scope("Layer"): W = tf.get_variable("weights", [m, k], initializer=tf.zeros_initializer([m, k], dtype=tf.float32)) ...

tensorflow • How to use TensorFlow Graph Collections?

Installation or Setup

Detailed instructions on getting logstash set up or installed.

logstash • Getting started with logstash

Simple Looping

First lets get some data into a temp table named #systables and ad a incrementing row number so we can query one record at a time select o.name, row_number() over (order by o.name) as rn into #systables from sys.objects as o where o.type = 'S' Next we declare some var...

Microsoft SQL Server • Stored Procedures

More on Packages

In the Hello World, you were introduced to the package Ada.Text_IO, and how to use it in order to perform I/O operations within your program. Packages can be further manipulated to do many different things. Renaming: To rename a package, you use the keyword renames in a package declaration, as such...

ada • Packages

Using an Icon

The <use> element is often used for reuseable icons, in collaboration with the <symbol> element. That looks like this: <svg> <symbol viewBox="0 0 16 16" id="icon-star"> <path d="M16 6.216l-6.095-.02L7.98.38 6.095 6.196 0 6.215h.02l4....

SVG • use

Warning: Elements in a ReadOnlyCollection are not inherently read-only

If the source collection is of a type that is not immutable, elements accessed through a ReadOnlyCollection can be modified. public class Item { public string Name { get; set; } public decimal Price { get; set; } } public static void FillOrder() { // An order is generated ...

.NET Framework • ReadOnlyCollections

Basic usage

Create a new JobService This is done by extending the JobService class and implementing/overriding the required methods onStartJob() and onStopJob(). public class MyJobService extends JobService { final String TAG = getClass().getSimpleName(); @Override public boolean onStart...

Android • Job Scheduling

Getting Nearby Places from Current Location

Prerequisites Install pods in your project Install the GooglePlaces SDK Enable location services First we need to get the users location by getting their current longitude and latitude. Import GooglePlaces and GooglePlacePicker import GooglePlaces import GooglePlacePicker Add the...

iOS • iOS Google Places API

Google Analytics in cordova without any plugin.

Insert the analytics function within index.js function analytics(){ (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){ (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o), m=s.getElementsByTagName(o)[0];a.async=1;a...

Cordova • Google Analytics in Cordova

Break the locked lease of blob storage in Microsoft Azure

There’s no API that can break the locked lease of blob storage in Microsoft Azure . This code snippet demonstrates break the locked lease of blob storage in Microsoft Azure (PowerShell). $key = (Get-AzureRmStorageAccountKey -ResourceGroupName $selectedStorageAccount.ResourceGroupName -name $select...

azure • Azure Storage Options

Form validation using NSPredicate

NSString *emailRegex = @"[A-Z0-9a-z]([A-Z0-9a-z._-]{0,64})+[A-Z0-9a-z]+@[A-Z0-9a-z]+([A-Za-z0-9.-]{0,64})+([A-Z0-9a-z])+\\.[A-Za-z]{2,4}"; NSString *firstNameRegex = @"[0-9A-Za-z\"'-]{2,32}$"; NSString *firstNameRegex = @"[ 0-9A-Za-z]{2,32}$"; NSString *lastNa...

iOS • NSPredicate

Installation or Setup

PowerBI reports can be created using PowerBI Desktop application. Download link: https://powerbi.microsoft.com/en-us/desktop/ Requirements (as of 5 April 2017): Windows 7 / Windows Server 2008 R2, or later .NET 4.5 Internet Explorer 9 or later Memory (RAM): At least 1 GB available, 1.5 GB...

powerbi • Getting started with powerbi

Break-continue statements

The break statement, on execution makes the current loop to force exit package main import "fmt" func main() { i:=0 for true { if i>2 { break } fmt.Println("Iteration : ",i) i++ } } The continue statement, on execution...

Go • Branching