Software Versioning Information

Normally,Software versioning is defined as illustrated below:

<Major.Minor.Revision.Build>

Where:

Major is a major update to the software
Minor is a small update to the software
Revision is any change made (bug fixes, small updates)
Build number (normally an auto increment if used)

In your example : 1.7.1.0

Major version 1
Had 7 minor updates
First revision/bugfix
No build number

MS Excel Keyboard Short-cuts

MS Excel offers many keyboard short-cuts. If you are familiar with windows operating system, you should be aware of most of them. Below is the list of all the major shortcut keys in Microsoft Excel.

Ctrl + A − Selects all contents of the worksheet.

Ctrl + B − Bold highlighted selection.

Ctrl + I − Italicizes the highlighted selection.

Ctrl + K − Inserts link.

Ctrl + U − Underlines the highlighted selection.

Ctrl + 1 − Changes the format of selected cells.

Ctrl + 5 − Strikethrough the highlighted selection.

Ctrl + P − Brings up the print dialog box to begin printing.

Ctrl + Z − Undo last action.

Ctrl + F3 − Opens Excel Name Manager.

Ctrl + F9 − Minimizes the current window.

Ctrl + F10 − Maximize currently selected window.

Ctrl + F6 − Switches between open workbooks or windows.

Ctrl + Page up − Moves between Excel work sheets in the same Excel document.

Ctrl + Page down − Moves between Excel work sheets in the same Excel document.

Ctrl + Tab − Moves between Two or more open Excel files.

Alt + = − Creates a formula to sum all of the above cells

Ctrl + ' − Inserts the value of the above cell into cell currently selected.

Ctrl + Shift + ! − Formats the number in comma format.

Ctrl + Shift + $ − Formats the number in currency format.

Ctrl + Shift + # − Formats the number in date format.

Ctrl + Shift + % − Formats the number in percentage format.

Ctrl + Shift + ^ − Formats the number in scientific format.

Ctrl + Shift + @ − Formats the number in time format.

Ctrl + Arrow key − Moves to the next section of text.

Ctrl + Space − Selects the entire column.

Shift + Space − Selects the entire row.

Ctrl + - − Deletes the selected column or row.

Ctrl + Shift + = − Inserts a new column or row.

Ctrl + Home − Moves to cell A1.

Ctrl + ~ − Switches between showing Excel formulas or their values in cells.

F2 − Edits the selected cell.

F3 − After a name has been created F3 will paste names.

F4 − Repeat last action. For example, if you changed the color of text in another cell pressing F4 will change the text in cell to the same color.

F5 − Goes to a specific cell. For example, C6.

F7 − Spell checks the selected text or document.

F11 − Creates chart from the selected data.

Ctrl + Shift + ; − Enters the current time.

Ctrl + ; − Enters the current date.

Alt + Shift + F1 − Inserts New Worksheet.

Alt + Enter − While typing text in a cell pressing Alt + Enter will move to the next line allowing for multiple lines of text in one cell.

Shift + F3 − Opens the Excel formula window.

Shift + F5 − Brings up the search box.

AutoIT - Basics with Example

1. MsgBox

#include <MsgBoxConstants.au3>

MsgBox($MB_SYSTEMMODAL,"Process Identifier...",@AutoItPID,5)
Send("{ENTER}")

ConsoleWrite("Enter key is pressed..")
Send("{ENTER}")

MsgBox($MB_SYSTEMMODAL,"Script Name..",@ScriptName,5)
Send("{ENTER}")

MsgBox($MB_SYSTEMMODAL,"Script Full Path",@ScriptFullPath,2)
Send("{ENTER}")

MsgBox($MB_SYSTEMMODAL,"Script Directory",@ScriptDir,6)
Send("{ENTER}")

MsgBox($MB_SYSTEMMODAL,"Script Line Number",@ScriptLineNumber,5)
Send("{ENTER}")

2. Variable

Global $first,$second,$third,$fourth

$first = 100

$second = 125

$third = $first + $second

$fourth = 1250

Local $res = $fourth % 2

MsgBox(262144, 'Debug line ~' & @ScriptLineNumber, 'Selection:' & @CRLF & ' $res' & @CRLF & @CRLF & 'Return:' & @CRLF &  $res) ;### Debug MSGBOX

ConsoleWrite("$fourth % 2" & $res)

If $second > $first Then

MsgBox(0,"Second is greater than First","Second is " & $second)

EndIf

MsgBox(0,"Result","$first + $second = " & $third)

3. Array

#include <String.au3>

$Source = BinaryToString(InetRead("https://www.youtube.com/watch?v=IeH5iKfI8DY&list=PLNpExbvcyUkOJvgxtCPcKsuMTk9XwoWum"),1)

$FirstChunks = _StringBetween($Source,'content="','">')

For $a In $FirstChunks

ConsoleWrite($a & @CRLF)

Sleep(1000)

Next

Global $Array[10],$Variable

$Array[0] = 0

$Array[1] = 123

$Array[9] = "Finish"

$Array[19] = "Success"

For $a = 0 To 9

ConsoleWrite($Array[$a] & @CRLF)

Next

For $a = 0 To (UBound($Array) - 1)  ;9

ConsoleWrite($Array[$a] & @CRLF)

Next

For $a In $Array

ConsoleWrite($a & @CRLF)

Next

4. InputBox

Global $name

$name = InputBox("SignUp - User Info","Enter your name")

MsgBox(0,"Registered User Info","Thank you for typing name into system and your username is " & $name)

5. If-Else

Global $buttonPressed

$buttonPressed = MsgBox(4,"Select Choice","Press Yes or No")

If $buttonPressed = 6 Then

MsgBox(0,"You have selected","You have pressed YES button!")

ElseIf $buttonPressed = 7 Then

MsgBox(0,"You have selected","You have pressed NO button!")

EndIf

6. Do-While and For loop

Global $first,$second,$third,$fourth

$first = 1

$second = 5

Do

MsgBox(0,"Text",$first)

$first += 1

Until $first = 5

While $first <> 5

MsgBox(0,"Text",$first)

$first += 1

WEnd

For $a = 1 To 10  ;Step + 1

MsgBox(0,"Number",$a)

Next

For $a = $first To $second   ;Step + 1

MsgBox(0,"Number",$a)

Next

7. HotKey Set

HotKeySet('h','HotKey1')

HotKeySet('p','HotKey2')

HotKeySet('x','ExitProgram')

While 1

Sleep(50)

WEnd

Func HotKey1()

ConsoleWrite("The Hotkey was presseed.!" & @CRLF)

EndFunc

Func HotKey2()

MsgBox(0,"This hotkey worked","This hotkey was pressed")

Run('notepad.exe')

EndFunc

Func ExitProgram()

Exit

EndFunc

Mini Bug - Issue Tracker and To-do List

Mini Bug is a barebones, simple issue tracker and to-do list. It is a Windows desktop single-user application.

MiniBug does not use a database to store data: instead the application stores each project in a .json file. This means that if you need to work on projects, in different computers, you can share a MiniBug project between computers, by putting the .json file in something like Dropbox.

Features

• Issues: create, edit, delete, clone
• Tasks: create, edit, delete, clone
• Show/hide/sort columns
• Some user defined settings
• Export issues and tasks to CSV format

Sample project

I've made a small sample project, with bugs and tasks copied from some applications' public bug trackers (Inkscape, Firefox, MariaDB and Kodi).

Download the file minibug-MiniBug Sample Project.json and open it in MiniBug.

Getting Started

Prerequisites

• Microsoft Windows 7 (maybe it works on older versions but I haven't tested)
• Microsoft .NET Framework 4.6.1

How To Use

First you need to create a new project (File > New Project), define a project name and choose a location to save it:

Next you can start adding issues and tasks:

• issues are bugs/problems
• tasks are items in a to-do list

Issues

Tasks

Settings

The user can modify some settings (File > Settings) in order to customize the look and feel of the application:

Settings in action:

Sorting

You can sort the grid rows in two ways:

• by clicking on a column header:

• by using the Configure Columns window:

Using the second method you can sort by up to two columns and with different criteria (ascending or descending).

Column visibility

You can show/hide any column (except the ID column, which is always visible), using the Configure Columns window:

Exporting

You can export a project's issues and tasks to CSV (comma separated values) files:

Because issues and tasks have a slightly different structure, they are exported to separate files. If a project only has issues or tasks, only one file will be generated:

License

This project is licensed under the MIT License - see the LICENSE.md file for details.

Acknowledgments

This project uses the following libraries:

• Json.NET: for reading/writing to .json files
• CsvHelper: for exporting to CSV