What are the various banner size for a website?

I was looking for an article that could give me the recommended size if I had to create advertisements for my own website.

I found this useful to start with. Kindly explore and I did manage to try a few variations with a tool called Inkscape.

Size	Style	Gif Weight	Flash Weight
468 x 60	Full Banner	20 KB	30 KB
728 x 90	Leaderboard	25 KB	35 KB
336 x 280	Square	25 KB	35 KB
300 x 250	Square	25 KB	35 KB

Credits : http://designerstoolbox.com/designresources/banners/

http://tim-stanley.com/post/standard-web-digital-image-sizes/

What are the alternatives to Java Swing?

I was going through some educational videos and found this interesting:
These are the alternatives to Java Swing - 1998. Sun/Oracle, part of SE.

• AWT 1996 , Sun Oracle, part of SE
• SWT 2001 - IBM, now open source ( Eclipse foundation )
• QT Jambi 2006 Troltech, Nokia
• Pivot WTK 2010, Open Source ( Apache Foundation )
• Java Fx (2.x) 2011. Sun/Oracle, part of SE - rolled with Java 7 update 6
• version 2,3,4,5,6,7 were skipped and Java FX 8 was release with Java 8.

Following are the Look and Feels a.k.a L&F's that come with Java Swing

• Metal
• Nimbus
• CDE/Motif
• Windows
• Mac
• GTK+ - Unix where GTK is installed.

Metal, Number and CDE can run cross platform.

UIManager.getInstalledLookAndFeel

Drawing Animations for youtube video

Try VideoScribe
https://www.quora.com/What-are-some-open-source-or-free-softwares-for-video-scribing-or-whiteboard-animations

Excel Object Model - Part1

Excel Object Model

Application, Workbook, Worksheet, Range



Ctrl+Y - deletes an entire line
Declaring Variables

Dim Age as Integer
Age= 77777 Integer - error 6 - overflow error
Dim decimals as a Double
Dim DOB as Date
Dim
false = 0 = No
True - not zero

Dim SuperRange as Range
Dim SuperWorksheet as Worksheet

variable names

s- string - Dim sFname as String
i- Integer
d- decimal
dt-Date
b - boolean
r - range
wk - worksheet
wb - workbook

Option Explicit - Declare your variables

Module based variable
Option Explicit

Private miAge as Integer

Private miAge as Integer ' Available across modules

Documentation

'Define variables
'Set Variables
' Change comments with green or highlight


Constant

const cFIRST  as Integer =0
You cannot define Dim sName as String = "Tim" - not allowed

Concatenation

Public Function FullName()
    ' Define Variables
    Dim sFirstName As String
    Dim sLastName As String
 
    'Set Variables
    sFirstName = "Ajith"
    sLastName = "Moni"
 
    'Combine variables
    FullName = sFirstName & sLastName
End Function


' Provide a # pound sign to signify the date to the parser #7/9/1965#

vbDefaultButton2

Public Sub Tester()
'Define Varibales
Dim sName As String

' Prompt the user for input data
sName = InputBox("Please enter your name", "Test", "First Name")

' Ask the user if the information is correct?
MsgBox "Are you sure this information is correct", vbQuestion + vbYesNoCancel + vbDefaultButton2, Verification

Src: http://techbus.safaribooksonline.com/video/office-and-productivity-applications/00022cworks

Excel Object Model VBA - Part2 - MsgBox and Functions

Public Sub msgBoxTester()
'Define Varibales
Dim sName As String

' Prompt the user for input data
sName = InputBox("Please enter your name", "Test", "First Name")

' Ask the user if the information is correct?
'MsgBox "Are you sure this information is correct", vbQuestion + vbYesNoCancel + vbDefaultButton2, Verification = vbIgnore

MsgBox Left(sName, 3)
MsgBox Right(sName, 3)
MsgBox Mid(sName, 3, 5)
MsgBox Mid(sName, 3)

'InStr - In string - search
' VB - We count 0,1,2,3,4,5
' InStr - Value > 0 - position starts from 1
MsgBox InStr(1, sName, " ")

' Get First Name
MsgBox Left(InStr(1, sName, " "))

' Get Last Name
MsgBox Right(InStr(1, sName, " "))

' Gives this with spaces
MsgBox Mid(InStr(1, sName, " "))

' Trim Function
' Ltrim, Trim, RTrim
MsgBox Mid(Trim(InStr(1, sName, " ")))

End Sub

What font size should i use for billboards, Desktop or mobile?

I wanted to find out the font size and readability of the font size to decide a comfortable distance which people can read. Example a project text.

What I learnt is we use pt or points in our PPT. This is the line height.

1 inch is 72 points. Or 72 points make an inch.

Now take a look at the table and choose what font size in inches or points is required when read at a distance measured in feet.

Example : if I am at a distance of 240 feet, I would need a 24 inch font for easier readability.

A 1 inch font size or 72 pt will serve the purpose of reading it from a 10 feet distance.

I found a multiplication factor or 10 when u convert inches to feet as described in the article below.

http://www.meadowoutdoor.com/billboard-design/good-vs-bad/font-size

How to design a logo? What should be the correct image size for web or mobile?

Day in and day out, we see a lot of images, some in the form or logos, some as icons, images in the form of advertisements.

I had been wondering as to what would it take for me to design a logo, a pamphlet, a billboard and following are some key takeaways as part of my learning's across the web.

1. Do read about raster graphics vs Vector graphics. Don't get into it too much. Summary is : Design in vector graphics and convert to raster graphics. Spend not more than 30 mins to understand the difference.

2. What should be the size of my image when viewed on a desktop, mobile or any other media output?
Learn about pixels. Again, material design takes a lot of reading but in simple terms, create a vector graphic image. Convert them into pixels of 16px x16px, 32px x 32px upto 196px x 196px.
Browers and mobile apps have their own way of rending as long as we manage to have muleiple images created to help them choose which to display for what screen size (mobile, desktop/laptop screens).

Note: Basic point, choose designing in Vector graphic and then convert to various sizes (16x x 16x to 96px x 96px) in PNG, JPEG or any format or your choice to avoid losing image quality. Allocate 30 mins to an hour for reading.

192x192 Pixel (XXHDPI)144x144 Pixel (XXHDPI)96x96 Pixel     (XHDPI)72x72 Pixel     (HDPI)48x48 Pixel     (MDPI)36x36 Pixel     (LDPI)

Do go through material design anything to get the basics of creating a logo and editing images. They own rendering images and text. Let's stick to their well designed and defined principles as a start. Read about font em,pt and % if you wanna know more. ( 2 articles. This heats your brain. 30 mins at max to an hour)

3. What software can I use to create a logo, edit an image?
Remember, a logo is complicated and consists of multiple images layered one above the other to materilize your idea of thousand words as a picture. ( Download and play around).

If you plan on designing one, you will need software's like photoshop, Adobe Illustrator, Paint.Net, Corel Draw etc., if you can afford
or
thank open source tools such as GIMP and an recent alternative "InkScape".
Note: Each of these tools does take a loooooong time to get a feel of creating one.

Summary:

I spend about 6 man hours to read and 15 mins to write this article.
However, my search to get to this stage has been a constant thought over a period of 5 years to get to this. Wish me good luck in self design of a logo, not to be a professional, but to own what i do and understand what it takes.

Disclaimer:
I am not promoting any of the tools mentioned above. My knowledge is limited to what I have read and I claim no expertise in the mention of the tools and companies in this article. I don't want to forget what I learnt, so I have documented the same on a shared platform in the form of blog for me and my fellow beings who in the same way have helped me gain the deeper understanding to what I am here today.

Additional Read:
http://tim-stanley.com/post/standard-web-digital-image-sizes/

VBA Excel Get the count of rows and columns

' Used Range for sheet1 as an example
MsgBox Sheet1.UsedRange.Rows.Count
MsgBox Sheet1.UsedRange.Columns.Count


' Used Range for a specific sheet
MsgBox Sheets("Customers").UsedRange.Rows.Count
MsgBox Sheets("Customers").UsedRange.Columns.Count

VBA Excel Populate date and time in excel cell

'Populate Date and time in Date field G8
Sheets("sheet1").Range("A1") = Format(Now, "dd-mm-yyyy hh:mm")

How is meta tag used in a HTML page

 

 

<meta http-equiv="X-UA-Compatible" content="IE=10">

 

 <meta http-equiv="refresh" content="30">

<meta name="generator" content="Oracle UIX"> 

<meta name="viewport" content="width=device-width,initial-scale=1.0">

 

Use the name attribute to define a description, keywords, and the author of an HTML document.

 

 <meta name="value"> 

 

Attribute Values:

 

 application-name

author

<head>
  <meta name="description" content="Free Web tutorials">
  <meta name="keywords" content="HTML,CSS,JavaScript">
  <meta name="author" content="John Doe">
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
</head> 

 

 

 

 The http-equiv attribute provides an HTTP header for the information/value of the content attribute.

 

<head>
  <meta http-equiv="refresh" content="30">
</head>

 

Note: If the http-equiv attribute is set, the name attribute should not be set. 

 

HTML5 introduced a method to let web designers take control over the viewport (the user's visible area of a web page), through the <meta> tag  

 

<meta name="viewport" content="width=device-width, initial-scale=1.0"> 

 

The width=device-width part sets the width of the page to follow the screen-width of the device (which will vary depending on the device).
The initial-scale=1.0 part sets the initial zoom level when the page is first loaded by the browser.

 

 

How is DOCTYPE and DTD used in a HTML page?

 

<!DOCTYPE html>

 

The <!DOCTYPE> declaration is not an HTML tag

 

The DTD specifies the rules for the markup language, so that the browsers render the content correctly. 

 Tip: Always add the <!DOCTYPE> declaration to your HTML documents, so that the browser knows what type of document to expect.

HTML 4.01 Strict

This DTD contains all HTML elements and attributes, but does NOT INCLUDE presentational or deprecated elements (like font). Framesets are not allowed.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">

 

 

HTML 4.01 Transitional

This DTD contains all HTML elements and attributes, INCLUDING presentational and deprecated elements (like font). Framesets are not allowed.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

 

FAQ : What is DTD?

 

A DTD defines the structure and the legal elements and attributes of an XML document.

With a DTD, independent groups of people can agree on a standard DTD for interchanging data.
An application can use a DTD to verify that XML data is valid.

<!DOCTYPE note SYSTEM "note.dtd">
<note>
  <to>Tove</to>
  <from>Jani</from>
  <heading>Reminder</heading>
  <body>Don't forget me this weekend!</body>
</note>

Seen from a DTD point of view, all XML documents are made up by the following building blocks:

• Elements
• Attributes
• Entities
• PCDATA
• CDATA

  

Elements

Elements are the main building blocks of both XML and HTML documents.
Examples of HTML elements are "body" and "table".
Examples of XML elements could be "note" and "message".

<body>some text</body>
<message>some text</message>

Entities

Some characters have a special meaning in XML, like the less than sign (<) that defines the start of an XML tag.

PCDATA

PCDATA means parsed character data.
Think of character data as the text found between the start tag and the end tag of an XML element.

 

CDATA

CDATA means character data.
CDATA is text that will NOT be parsed by a parser. Tags inside the text will NOT be treated as markup and entities will not be expanded.