How Google earned USD 37.9 Billion in 2011?
USD 37.9 Billion in a year! The most interesting thing is %96 of the revenue comes from Adwords. That’s why we see advertisements on whole Googles services like Gmail, Search, Documents etc.
Check this out:
Google Revenue Infographic
Excel Macro which copies one column to another by matching specific unique column
This is a simple Excel Macro which copy one column to another by comparing specific unique column. There two sheets: Sheet1 and Sheet2. We copy column 2 and 3 at Sheet2 to column 2 and 3 at Sheet1 by matching column 1 at both.
There might be persentage data. You should use NumberFormat parameter in that situation.
Sub CopyCells() '*** Defining variables ***' Dim Value1, Value2 Dim RowsCount1, RowsCount2 '*** Find out rows count ***' RowsCount1 = Worksheets("Sheet1").Range("A1").CurrentRegion.Rows.Count RowsCount2= Worksheets("Sheet2").Range("A1").CurrentRegion.Rows.Count '*** Copying data ***' For C1 = 2 To RowsCount2 ..Set Value1 = Worksheets("Sheet2").Cells(C1, 1) ..For C2 = 3 To RowsCount1 ....Set Value2 = Worksheets("Sheet1").Cells(C2, 1) ....If Value1 = Value2 Then ......Worksheets("Sheet1").Cells(C2, 2) = Worksheets("Sheet2").Cells(C1, 2) ......Worksheets("Sheet1").Cells(C2, 2).NumberFormat = "0.00%" ......Worksheets("Sheet1").Cells(C2, 3) = Worksheets("Sheet2").Cells(C1, 3) ......Worksheets("Sheet1").Cells(C2, 3).NumberFormat = "" ....End If ..Next C2 Next C1 End Sub
.
C1 and C2 mean Counter1 and Counter2.
How to synchronize Google Calendar and Outlook?
If you want to sync Google Calendar and Outlook, Google Calendar Sync tool is all you need. There are 2-way and 1-way synchronizing alternatives. Try it:
http://dl.google.com/dl/googlecalendarsync/googlecalendarsync_installer.exe
Google Calendar Sync tool
If you have Google Apps for Business (I mean you pay for the service), you can use an excellent tool that name is Google Apps Sync for Outlook. It provides mail, calendar, contact, free/busy data syncronization capability.
http://www.google.com/apps/intl/en/business/outlook_sync.html
Lastly, if you bored of Outlook (How can it be possible?) and want to move whole data to Google Apps, Migration Tool is for you:
What do “Domain Name Status Codes” mean?
You might have diffuculty understanding domain name status codes because there are quite a lot of codes. Look at the list and figure.
- ACTIVE: A domain can only be modified by the domain registrar.
- REGISTRY-LOCK: The domain can not be modified or deleted by the registrar. The registry must remove the REGISTRY-LOCK status for the registrar to modify the domain.
- REGISTRAR-LOCK: The domain can not be modified or deleted. The registrar must remove REGISTRAR-LOCK status to modify the domain.
- REGISTRY-HOLD: The domain can not be modified or deleted by the registrar. The registry must remove the REGISTRY-HOLD status for the registrar to modify the domain.
- REGISTRAR-HOLD: The domain can not be modified or deleted. The registrar must remove REGISTRAR-HOLD status to modify the domain.
- REDEMPTIONPERIOD: The registry sets this status when a registrar requests that the domain name be deleted from the registry and the domain has been registered for more than 5 calendar days (if the delete request is received within 5 days of initial domain registration it will instead be deleted immediately). The domain will not be included in the zone. The domain can not be modified or purged; it can only be restored. Any other registrar requests to modify or otherwise update the domain will be rejected. The domain will be held in this status for a maximum of 30 calendar days.
- PENDINGRESTORE: The registry sets this status after a registrar requests restoration of a domain that is in REDEMPTIONPERIOD status. The domain will be included in the zone. Registrar requests to modify or otherwise update the domain will be rejected. The domain will be held in this status while the registry waits for the registrar to provide required restoration documentation. If the registrar fails to provide documentation to the registry within 7 calendar days to confirm the restoration request, the domain will revert to REDEMPTIONPERIOD status. The domain status will be set to ACTIVE only if the registrar provides documentation to the registry within 7 calendar days to confirm the restoration request.
- PENDINGDELETE: The registry sets this status after a domain has been set in REDEMPTIONPERIOD status and the domain has not been restored by the registrar. The domain will not be included in the zone. Once in this status all registrar requests to modify or otherwise update the domain will be rejected. The domain will be purged from the registry database after being in this status for 5 calendar days.
How domain names expire?
The source: http://www.registercompass.com/wiki/domains/pendingdelete.aspx
Installing Android applications to SD card directly
If you have an Android phone, You see that every applications that you download from Adroid Market install Internal Memory automatically. If your Internal Memory is small, this situation is very big problem for you. Probably you look for a solution to install applications External Memory (SD Card) directly.
There are a lot of applications that claim to fix this issue. I have tried almost 10 applications but none of them succeed. Then, I found another way to do that. Here is:
- Download & Install Android SDK.
- Open Commant Prompt (Start > Run > cmd).
- Go to this folder: “C:\Program Files (x86)\Android\android-sdk\platform-tools”.
- Connect your cellphone to the computer via USB.
- Install your cellphone application like HTC Sync for HTC cellphones.
- Activate “USB debugging” on the phone (Menu -> Settings -> Applications -> Development -> Check USB Debugging)
- Go back to Command Prompt. Try this command: “adb devices“. You will see attached cellhphones.
- Then run this command: “adb shell pm setInstallLocation 2“.
- That’s all. After that time, your applications will be installing your external memory.
