Monday, May 31, 2010

What is 3G Technology?

About 3G

Based on the International Telecommunications Union standards, the 3G network is the 3rd generation of mobile networking and telecommunications. It features a wider range of services and advances network capacity over the previous 2nd generation network. The 3G network increases the rate of information transfer known as spectral efficiency. Telephony has received a wider area and more range, while video and broadband wireless data transfers have also been positively affected. These criteria are identified as the IMT-2000 standard.


Japan and South Korea were the first countries to successfully launch this network. The Japanese company FOMA launched in May 2001 and South Korea's SK Telecom launched in January 2002. British Telecom in the United Kingdom and Monet Mobile Networks in the United States followed suit.

Now most of the countries had started implementation of this technology....


Some of the Advantages of 3G services are

1. Faster data connectivity (Picture Messaging, download stuffs faster, Watcing TV on mobile, Surfing, online gaming, and lots more)
2. Uninterrupted video streaming on phones.
3. Video calls and big MMS.
4. Data intensive applications.


While 3G packet based networks will allow users to be online all the time....

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Recently in India there was an Auction for the 3G Service and bids end for pan-India licence touching Rs 16,751 crore which ensures the Government of India a revenue of Rs 67,719 crore. :)

The List of 3G Winners
Private Operators

Delhi & NCR: Vodafone, Bharti, Reliance Communications at Rs 3316.93 cr

Mumbai: Reliance, Vodafone, Bharti Airtel at Rs.3247.07 cr

Maharashtra & Goa: Tata Com, Idea cellular, Vodafone at Rs.1257.82 cr

Gujarat: Tata Com, Vodafone, Idea at Rs.1076.06 cr

Andhra Pradesh: Bharti Airtel, Idea, Aircel at Rs.1373.14 cr

Karnataka: Tata Telecommunication, Aircel, Bharti at Rs.1579.91 cr

Tamil Nadu: Bharti, Vodafone, Aircel at Rs.1464.94 cr

Kolkata: Vodafone, Aircel, Reliance Communications at Rs.544.26 cr

Kerela: Idea cellular, Tata Telecommunications, Aircel at Rs.312.48 cr

Punjab: Idea Cellular, Reliance Communications, Tata Telecommunications, Aircel at Rs.322.01 cr

Haryana: Idea Cellular, Tata Telecommunications, Vodafone at Rs. 222.58 cr

Madhya Pradesh & Chattishgarh: Idea Cellular, Reliance Communications, Tata Telecommunications at Rs.258.4 cr

Rajasthan: Reliance Communications, Bharti, Tata Telecommunications at Rs.321 cr

U.P. (West): Bharti, Idea Cellular, Tata Telecommunications at Rs. 514 cr

U.P (East): Aircel, Idea Cellular, Vodafone at Rs.364.6 cr

West Bengal:Bharti,Reliance Telecom,Vodafone, Aircel at Rs.123.36 cr

Himachal Pradesh :Bharti, Stel, Idea cellular, Reliance at Rs.37.23 cr.

Bihar & Jharkhand : Stel, Bharti, Reliance, Aircel at Rs.203.46 cr

Orissa : Stel, Aircel,Reliance at Rs.96.98 cr

Assam: Reliance, Bharti, Aircel at Rs.41.48 cr

North East: Aircel, Bharti, Reliance at Rs.42.30 cr

Jammu & Kashmir : Idea, Aircel, Bharti, Reliance at Rs.30.30 cr


Let's C what we have in next few years....





List of some Mobile phone in India

Mobile Phones available in India

1. Nokia
2. Sony Ericsson
3. Samsung
4. Motorola
5. Spice Telecom
6. LG
7. Siemens
8. Fly
9. Huawei
10. Intex
11. Kycon
12. Usha-Lexus
13. Philips
14. Haier
15. Zte
16. Sansui
17. Gee Pee
18. Olive
19. Lava
20. Xcite
21. BPL
22. Orpat
23. Maxx
24. Magicon
25. Karbonn mobiles - dual SIM phones
26. PAXMA mobiles
27. MicroMax
28. Rage
29. Voice
30. Lemon
31. Airphone
32. Byond tech
33. etouch
34. Onida
35. Movil
36. Win
37. Videocon
38. Hansum Mobiles
39. BUMBUM
40. LOGITEC
41. QUANTUM
42. TECHNOTECH
43. Fortune
44. Simoco
45. Melbon
46. Lexus
47. Lon
48. Bleu
49. Pagaria
50. Ray
51. Daya
52. Sagem
53. GFone




Mobile Phone Service Providers

1. Aircel

2. Airtel

3. BSNL

4. MTNL

5. Idea Cellular

6. Ping Mobile

7. Tata Indicom

8. Tata DoCoMo

9. Reliance Communications

10. Loop Mobile India (Formerly BPL Mobile)

11. Etisalat DB Telecom (formerly SWAN Telecom)

12. Virgin Mobile

13. Vodafone Essar (Formerly Hutchison Essar/Hutch Orange/Hutch Pink)

14. Videocon Telecommunications (Formerly Datacom Solutions)

15. Uninor

16. MTS India

17. S Tel

18. Virgin Mobile GSM

19. Spice Telecom

Friday, October 2, 2009

New features in Office 2010

Ribbon


Office 2010 the Ribbon to all the Office programs, including Outlook and OneNote. New thing is, now you have control over your Ribbon, what items appear on its tabs and you can even add tabs of your own. Put your favorite commands on there.



















Outlook improvement

  • New Ignore button : Makes it easy to bypass entire conversation threads.
  • New Quick Steps section : Lets you perform multi-step tasks with one click.
  • Actions: You can perform more actions on a conversational thread, including clean up.

Easier screen shots

Inserting screen shots into Word is easier than ever.

If you’re a tech writer, you’ll appreciate a new feature in Word 2010 — the ability to capture screen shots from inside the application and paste them into the document, all in a couple of clicks. The Screen shot button has been added to the Insert tab of the Ribbon.

When you click the Screen shot button, you’ll see the available screen shots, and you can click on the one you want to insert into the document. After you insert a screen shot, the picture tools will automatically appear to allow you to perform photo editing.

Excel sparklines and slicers

The most notable additions to Excel 2010 are two new features called sparklines and slicers. Sparklines are tiny charts that fit into a cell, as shown in Figure.

Sparklines are charts that fit into a cell on an Excel spreadsheet.

The sparklines shown in the figure use the line format, but you can also create column or win/loss sparklines. You can edit the design of the sparklines.

You can edit the design of your sparklines.

Slicers are objects you can use to filter the data in pivot tables, which you can move around or resize on the screen. When data in the pivot table changes, the slicer is automatically updated. Both sparklines and slicers are created via the Insert tab on the Ribbon.

You create sparklines and slicers via the Insert tab on the Ribbon.

To see a demo of the new Excel features, check out the video at http://www.microsoft.com/office/2010


Simultaneous editing

Here is another one of my favorite. Often we leave a document that we are working on one computer, and then need to open and work on it from a different computer. we get the familiar “file in use” dialog box that gives us the option to open a read-only copy, create a local copy to merge later, or receive notification when the original is available. Office 2010 does away with that annoyance.

Now we can pick up where we left off, or two people can edit a document simultaneously. A notification in the status bar tells you who else is currently editing the document, and where they’re making changes. Very cool!

Word can also cache shared documents so we can edit them when we are offline, and any changes we make will automatically be synchronized with the original on the server when we come back online. Now we don’t have to remember to merge document when we get back.

Setting up the web query

Excel provides a very useful option to gather data from websites, called web queries. These have been introduced with Excel 97 and have been further enhanced in the versions released after Excel 97. This article shows how you can setup a web query so that you can make the worksheet dynamically update based on values in so called parameter cells.

Setting up a web query is as simple as clicking the Data tab and then clicking the “From Web button on the Get External Data tab.

image

You’ll get this screen:

image

Enter http://moneycentral.msn.com/companyreport?symbol=MSFT and click the Go Button.

Don’t do anything yet, first click the “Options” button and set the webquery to return full html formatting results (if so desired):

image

After changing these settings, select the part you want to be imported into your sheet by clicking the appropriate black-on-yellow arrow:

image

Now we’re ready to click “Import”. If the page takes time to load, you’ll see a progress screen:

image

Next Excel asks where to put the results; put them in cell A3 so we have room above the table:

image

If you want an interactive result in your sheet, enabling you to enter new search criteria in a cell, you have to go through a little VBA. Don’t worry, this is easy.

These steps are needed:

  1. Click any cell in the new table.
  2. Open the Visual Basic Editor by hitting the Alt+F11 key.
  3. Hit control+g to open the immediate window.
  4. Now type the following line:

    activecell.QueryTable.Connection="URL;http://moneycentral.msn.com/companyreport?symbol=[""Ticker""]"
  5. Click Enter to confirm.
  6. Close the Visual Basic Editor.

You have now made part of the url work as a parameter, by replacing that part of the url with some text between quotes and square brackets (we used a bit of VBA because with the MSN site you can’t do this through the user interface). The string you entered will be used as both the name of the parameter and the prompt.

Click the refresh all button on the data tab of the ribbon, in the connections group. Excel will interpret the part between the square brackets as a parameter and prompt you for a value:

image

Excel detects we have a parameter and now asks what value you want.

Thursday, October 1, 2009

Using the New Microsoft Office File Format

Starting with the 1997 release, all Microsoft Office programs have used a binary file format that computers (but not humans) can read. Excel 2007, Microsoft Office Word 2007, and Microsoft Office PowerPoint® 2007 have a new and improved file format that, in addition to being somewhat readable, creates much smaller files than the older binary format.

The new Microsoft Office Open XML Formats combine the XML and the Zip file compression format to create robust files that (on average) are about half the size of similar Excel 972003 files. You can open and save Excel 972003 files in Excel 2007, of course. If you want to open Excel 2007 files in Excel 2000, Excel 2002, or Excel 2003, you can install the Microsoft Office Compatibility Pack for Office Word 2007, Excel 2007, and Office PowerPoint 2007 file formats from this book's companion CD.

Besides smaller file sizes, the 2007 Microsoft Office system file formats offer several other advantages:

  • Improved interoperability. Because the new file formats use XML as their base, it is much easier for organizations to share and exchange data between the Microsoft Office system programs and other applications. The older binary file format was difficult to read and wasn't standards-based.
  • Enhanced customization. The letter "X" in XML stands for "extensible," which means that information professionals and developers can create custom document structures, or schema, that meet their organization's needs.
  • Improved automation. The Excel 2007 file format is based on open standards, which means that any program written to process data based on those standards will work with Excel 2007. In other words, you don't need to write special routines or use another program in the Microsoft Office system to handle your Excel 2007 data programmatically.
  • Compartmentalizing information. The new Microsoft Office system file format separates document data, macro code, and header information into separate containers, which Excel 2007 then combines into the file you see when you open your workbook. Separating macro code (automated program instructions) from your worksheet data improves security by identifying that a workbook contains a macro and enables you to prevent Excel 2007 from executing code that could harm your computer or steal valuable personal or business information.