Tutorial by Examples: l

The core idea of VLOOKUP is to look up information in a spreadsheet table and place it in another. For example, suppose this is the table in Sheet1: John 12/25/1990 Jane 1/1/2000 In Sheet2, place John, Andy, and Jane in A1, A2, and A3. In B1, to the right of John, I placed: =VL...

HeroChildComponent has two input properties, typically adorned with @Input decorations. import { Component, Input } from '@angular/core'; import { Hero } from './hero'; @Component({ selector: 'hero-child', template: ` <h3>{{hero.name}} says:</h3> <p>I, {{hero.nam...

Occasionally it's useful to assign one or more ports manually vs using the defaults. Doing so can solve port availability/permissions issues or accommodate running more than one ember instance at a time. To have ember-cli attempt to identify and assign an available port, use: ember serve --port ...

First you add System.Security.Cryptography and System.IO to your project public string GetSha1Hash(string filePath) { using (FileStream fs = File.OpenRead(filePath)) { SHA1 sha = new SHA1Managed(); return BitConverter.ToString(sha.ComputeHash(fs...

first you add System.Security.Cryptography namespace to your project public string GetSha1Hash(string filePath) { using (FileStream fs = File.OpenRead(filePath)) { SHA1 sha = new SHA1Managed(); return BitConverter.ToString(sha.ComputeHash(fs)); ...

Detailed instructions on getting azure-functions set up or installed.

The code example below demonstrate how you can get a lighter and darker shade of a given color, useful in applications having dynamic themes For Darker Color + (UIColor *)darkerColorForColor:(UIColor *)c { CGFloat r, g, b, a; if ([c getRed:&r green:&g blue:&b alpha:&a]) ...

As stated above Functions are smaller procedures that contain small pieces of code which may be repetitive inside a Procedure. Functions are used to reduce redundancy in code. Similar to a Procedure, A function can be declared with or without an arguments list. Function is declared as a return ty...

Detailed instructions on getting mainframe set up or installed.

In Sprite-Kit, there is the concept of collisions which refers to the SK physics engine handling how physics objects interact when they collide i.e. which ones bounce off which other ones. It also has the concept of contacts, which is the mechanism by which your program gets informed when 2 physics...

y ~ . : Here . is interpreted as all variables except y in the data frame used in fitting the model. It is equivalent to the linear combinations of predictor variables. For example y ~ var1 + var2 + var3+...+var15 y ~ . ^ 2 will give all linear (main effects) and second order interaction terms of t...

const languages = [ 'JavaScript', 'Python', 'Java', 'Elm', 'TypeScript', 'C#', 'F#' ] // one liner const Language = ({language}) => <li>{language}</li> Language.propTypes = { message: React.PropTypes.string.isRequired } /** * If there are more ...

The C99 and C11 standards specify the following length modifiers for printf(); their meanings are: ModifierModifiesApplies tohhd, i, o, u, x, or Xchar, signed char or unsigned charhd, i, o, u, x, or Xshort int or unsigned short intld, i, o, u, x, or Xlong int or unsigned long intla, A, e, E, f, F, ...

Detailed instructions on getting network-programming set up or installed.

Gin is a web framework written in Golang. It features a martini-like API with much better performance, up to 40 times faster. If you need performance and good productivity, you will love Gin. There will be 8 packages + main.go controllers core libs middlewares public routers services...

CREATE USER readonly WITH ENCRYPTED PASSWORD 'yourpassword'; GRANT CONNECT ON DATABASE <database_name> to readonly; GRANT USAGE ON SCHEMA public to readonly; GRANT SELECT ON ALL SEQUENCES IN SCHEMA public TO readonly; GRANT SELECT ON ALL TABLES IN SCHEMA public TO readonly;

There is a way to simplify defining autolayout for views using VFL. It may seem hard at first, but it is actually really easy to use. Some definitions first: | represents superview H: or V: represent current orientation - horizontal or vertical view names should be enclosed in square brackets ...

A savepoint stores two things: (a) the positions of all datasources, (b) the states of operators. Savepoints are useful in many circonstances: slight application code updates Flink update changes in parallelism ... As of version 1.3 (also valid for earlier version): checkpoint must be ...

Before 1.2, the only way to persist state/retain a checkpoint after a job termination/cancellation/persistant failure was through a savepoint, which is triggered manually. Version 1.2 introduced persistent checkpoints. Persistent checkpoints behave very much like regular periodic checkpoints except...

import UIKit class DoggyListViewController: UIViewController, UITableViewDataSource { @IBOutlet weak var emptyView: UIView? @IBOutlet weak var tableView: UITableView? @IBOutlet weak var spinner: UIActivityIndicatorView? fileprivate let dogPresenter = DoggyPresenter(dogSe...