Tutorial by Examples: on

Highlighting Duplicate Values With Range("E1:E100").FormatConditions.AddUniqueValues .DupeUnique = xlDuplicate With .Font .Bold = True .ColorIndex = 3 End With End With Highlighting Unique Values With Range("E1:E100").FormatConditions.AddUniqueVa...

Highlighting Top 5 Values With Range("E1:E100").FormatConditions.AddTop10 .TopBottom = xlTop10Top .Rank = 5 .Percent = False With .Font .Bold = True .ColorIndex = 3 End With End With

With Range("E1:E100").FormatConditions.AddAboveAverage .AboveBelow = xlAboveAverage With .Font .Bold = True .ColorIndex = 3 End With End With Operators: NameDescriptionXlAboveAverageAbove averageXlAboveStdDevAbove standard deviationXlBelowAverageBelow ...

You need to include the Pagination.php in your page/s. require_once 'Paginator.php'; $Paginator = new Paginator('mysql:host=localhost;dbname=ng_app', 'root', '000000'); $Paginator->setItemLimitPerPage(4); $Paginator->setTable('comments'); $Paginator->createPages(); // this will creat...

Range("a1:a10").FormatConditions.AddIconSetCondition With Selection.FormatConditions(1) .ReverseOrder = False .ShowIconOnly = False .IconSet = ActiveWorkbook.IconSets(xl3Arrows) End With With Selection.FormatConditions(1).IconCriteria(2) .Type = xlConditionValueP...

Normally when rails environment is run by typing. This just runs the default environment which is usually development rails s The specific environment can be selected by using the flag -e for example: rails s -e test Which will run the test environment. The default environment can be change...

If running on a remote server that is using Passenger change apache.conf to to the environment you want to use. For example this case you see RailsEnv production. <VirtualHost *:80> ServerName application_name.rails.local DocumentRoot "/Users/rails/application_name/public" ...

Detailed instructions on getting loadrunner set up or installed.

Due to its computational goals, mathematical operations on arrays are straight forward in Fortran. Addition and subtraction Operations on arrays of the same shape and size are very similar to matrix algebra. Instead of running through all the indices with loops, one can write addition (and subtra...

CREATE TABLE Table1 ( id INT UNSIGNED NOT NULL, created_on DATE NOT NULL, PRIMARY KEY (id) ) CREATE TABLE Table2 ( id INT UNSIGNED NOT NULL, personName VARCHAR(255) NOT NULL, PRIMARY KEY (id) ) CREATE TABLE Table3 ( id INT UNSIGNED NOT NULL, accountName VA...

Detailed instructions on getting genetic-algorithm set up or installed.

import Json.Decode as JD import Json.Decode.Pipeline as JP type PostType = Image | Video type alias Post = { id: Int , postType: PostType } -- assuming server will send int value of 0 for Image or 1 for Video decodePostType: JD.Decoder PostType decodePostType = JD.int |&...

Processlist This will show all active & sleeping queries in that order then by how long. SELECT * FROM information_schema.PROCESSLIST ORDER BY INFO DESC, TIME DESC; This is a bit more detail on time-frames as it is in seconds by default SELECT ID, USER, HOST, DB, COMMAND, TIME as time_second...

If you want to notify other clients/users throughout the application ,you not need to worry about the connection because signalr new connection is created every time you visit other pages in the web app. we can leverage the users feature of signalr to achieve the same. see the example below: Here...

program ForLoopWithContinueAndBreaks; {$APPTYPE CONSOLE} var var i : integer; begin for i := 1 to 10 do begin if i = 2 then continue; (* Skip this turn *) if i = 8 then break; (* Break the loop *) WriteLn( i ); end; WriteLn('Finish.'); end. Outpu...

std::async: performs an asynchronous operation. std::future: provides access to the result of an asynchronous operation. std::promise: packages the result of an asynchronous operation. std::packaged_task: bundles a function and the associated promise for its return type.

This sample used to common function for all type object serialization and deserialization. using System.Runtime.Serialization.Formatters.Binary; using System.Xml.Serialization; namespace Framework { public static class IGUtilities { public static string Serialization(this T obj) ...

When a remote session is created via the New-PSsession cmdlet, the PSSession persists until the current PowerShell session ends. Meaning that, by default, the PSSession and all associated resources will continue to be used until the current PowerShell session ends. Multiple active PSSessions can b...

Copy: Sub CopyFile() Dim fso as Scripting.FileSystemObject Set fso = CreateObject("Scripting.FileSystemObject") fso.CopyFile "c:\Documents and Settings\Makro.txt", "c:\Documents and Settings\Macros\" End Sub Move: Sub MoveFile() Dim fso as Scri...

Create: Sub CreateFolder() Dim fso as Scripting.FileSystemObject Set fso = CreateObject("Scripting.FileSystemObject") fso.CreateFolder "c:\Documents and Settings\NewFolder" End Sub Copy: Sub CopyFolder() Dim fso as Scripting.FileSystemObject Set fso...