Sony Xperia Ion Review Price Specification

Sony Xperia Ion is the first 4G LTE supported device from Sony Xperia series. It has pair of HD cameras.  The main rear camera has ultra sharp 12MP sensor with LED flash and auto focus. The 1.3 MP  front facing camera too capable of recording HD videos at 720p. Sony Xperia Ion is available in two colors black and white.
Sony Xperia Ion has 1.5GHz dual core processor with 1GB RAM and 16GB of internal memory. It sports 4.6 inch HD  LED-backlit LCD, capacitive touchscreen with screen resolution of 720*1280 pixels which sums upto 323 pixel density. Sony Xperia Ion is powered by Li-ion 1900 mAh battery which promises to provide talk time upto 10 hours and standby time upto 400 hours.

Key Features of Sony Xperia Ion:

• 4G LTE network support
• 12MP rear camera with auto focus and LED flash
• 1.3 MP front facing camera with HD video recording capability
• 1.5GHz dual core processor
• 1GB RAM and 16GB internal memory
• Expandable memory upto 32GB through microSD card
• 1900 mAh battery

Advantages and Disadvantages of Sony Xperia Ion:

Pros of Sony Xperia Ion:

• Paid of HD camera
• Faster 4G LTE network support
• Impressive large display screen with good screen resolution
• Good inbuilt memory
• Decent performance

Disadvantages of Sony Xperia Ion:

• Still runs on Android Gingerbread OS. Even though Sony is planning to upgrade to ICS, being in the high end smartphone, missing of latest Android OS is a big disadvantage.

Sony Xperia Ion Specification:

• Operating Frequency:2G:GSM 850 / 900 / 1800 / 1900; 3G:HSDPA 850 / 1900 / 2100;4G:LTE 700 MHz Class 17 / 1700 / 2100 - LT28at
• OS:Android OS, v2.3 (Gingerbread), planned upgrade to v4.0
• User Interface:Timescape UI
• Java:Yes, via Java MIDP emulator
• Processor:Dual-core 1.5 GHz
• Chipset:Qualcomm MSM8260 Snapdragon
• Graphics:Adreno 220
• RAM:1GB
• Size:133 x 68 x 10.8 mm
• Weight: 144 grams
• Display: 4.6 inch LED-backlit LCD, capacitive touchscreen, 16M colors
• Screen Resolution:720 x 1280 pixels(~323 ppi pixel density)
• Display Features:Scratch-resistant glass,Sony Mobile BRAVIA Engine
• Primary Camera: Yes, 12 MP, 4000x3000 pixels
• Secondary Camera:Yes,1.3 MP;720p@30fps
• Flash:LED
• Video Recording:Yes,1080p@30fps, continuous autofocus, video light, video stabilizer
• Camera Features:Geo-tagging, touch focus, face and smile detection, 3D sweep panorama, image stabilization
• Battery type:Li-Ion 1900 mAh
• Talktime:Up to 10 h (2G) / Up to 4 h (3G)
• Standby Time:Up to 400 h (2G) / Up to 350 h (3G)
• GPRS:Yes.Up to 86 kbps
• EDGE:Yes.Up to 237 kbps
• SPEED:HSDPA, 21.1 Mbps; HSUPA, 5.8 Mbps; LTE, Cat3, 50 Mbps UL, 100 Mbps DL (LT28at only)
• Wifi:Yes, 802.11 b/g/n
• USB connectivity:Yes, micro USB, v2
• Tethering:USB, Wi-fi Hotspot
• GPS Support:Yes, Yes, with A-GPS support and GLONASS
• Bluetooth:Yes
• Audio Jack:3.5 mm
• DLNA:Yes
• Internal memory:16 GB
• Expandable Memory Slot: microSD, upto 32 GB
• Music Player:Yes, Supports MP3/eAAC+/WMA/WAV player
• Video Player: Yes, Supports MP4/H.263/H.264/WMV player
• Radio:Yes.Stereo FM radio with RDS
• Ringtone:MP3, WAV 

Cost of Sony Xperia Ion: Sony Xperia Ion Price details are currently unavailable,

Sony Xperia Acro S and Sony Xperia Go Unveiled

Sony has launched two water proof smartphones called as Sony Xperia Acro S and Sony Xperia Go respectively.  These two Sony Smartphones are expected to be available globally in the third quarter of 2012. The prices of these also not revealed. However brief details of the Sony Xperia Acro S and Sony Xperia Go are below.
Sony Xperia Acro S: This comes with IP55 and IP57 ratings for the dust and water proof. That means this phone has the protection from the protection against dust-limited to ingress (no harmful deposits) and the effects of immersion up to 1 m for 30 minutes.  Sony Xperia Acro S has 4.3 inch 720p HD reality display,12MP rear camera with auto focus and LED flash. It is powered by Dual core 1.5GHz Scorpion processor with 1GB of RAM. This phone is also called as Sony LT26w.

Key Specifications of Sony Xperia Acro S:

• Android 4.0 Ice Cream Sandwich OS
• Dual Core 1.5GHz Scorpion Processor with Qualcomm MSM8260 Snapdragon chipset and Adreno 220 GPU
• 1GB RAM and 16GB internal memory
• Expandable memory through microSD card slot is 32GB
• 4.3 inch LED-backlit LCD, capacitive touchscreen
• 720 x 1280 pixels screen resolution which sums upto 342 ppi pixel density
• 12MP Rear camera with Auto Focus and LED flash
• Geo-tagging, touch focus, face and smile detection, 3D sweep panorama, image stabilization camera Features.
• 1.3MP front facing Camera
• Video recording 1080p@30 fps with continuous autofocus, video light, video stabilizer
• Li-Ion 1910 mAh battery with talk time upto 7 hours 10 minutes and standby time upto 310 hours.

Cost of Sony Xperia Acro S :Sony Xperia Acro S price is not revealed yet. 

Sony Xperia Go:  This Sony Smartphone offers the highest level of dust and water resistance available on a smartphone.  Sony Xperia Go is protected from Dust and immersion in upto 1m of water for 30 minutes.  The Xperia Go features 3.5 inch Reality Display screen, 5MP rear camera, 1GHz dual core processor. It runs on Android Gingerbread OS.

Key Specifications of Sony Xperia Go:

• Android 2.3 Gingerbread OS
• Dual-core 1 GHz Cortex-A9 with NovaThor U8500 chipset and Mali-400 GPU
• 512MB RAM and 8GB internal memory
• Expandable memory through microSD card slot is 32GB
• 3.5 inch LED-backlit LCD, capacitive touchscreen
• 320 x 480 pixels Screen resolution which comes upto 165 ppi pixel density
• 5MP Auto focus rear camera with LED flash
• Geo-tagging, touch focus, face and smile detection, 3D sweep panorama camera features
• vide recording:720p@30fps, continuous autofocus, video light, video stabilizer
• Li-Ion 1305 mAh battery with talk time upto 6 hours 30 minutes and standby time upto 520 hours  

Cost of Sony Xperia Go: Sony Xperia Go price is not yet revealed.

LG Optimus 3D Max P720 Review Price Specification

LG Optimus 3D Max P720 is a successor of LG original Optimus 3D smartphone. It sports Dual core 1.2Ghz processor with 1GB Ram and runs on Android Gingerbread OS. Internal memory of the phone is 8GB and memory can be added upto 32GB through microSD card. LG Optimus 3D Max P720 has 4.3 inch 3D LCD capacitive touchscreen with screen resolution of 480*800 pixels and has Cornering Gorilla glass protection. This 3D phone comes with Li-ion 1520 mAh battery which is rated to provide talk time upto 4 hours and standby time upto 422 hours. LG Optimus 3D Max P720 price is given in the last part of the post.

LG Optimus 3D Max P720 Features:

• 4.3 inch 3D LCD capacitive touchscreen
• Android Gingerbread OS
• Dual 5 MP, 2592х1944 pixels, autofocus, LED flash
• VGA Front camera
• Dual core 1.2GHz processor with 1GB RAM
• 8GB internal memory
• Upto 32GB expandable memory through microSD card

Main Disadvantages of LG Optimus 3D Max P720:

• Display has a narrow viewing angle when in 3D mode
• Buggy 3D Software
• Not comes loaded with latest Android OS ICS
• Less impressive camera performance

LG Optimus 3D Max P720 Specification:

• Operating Frequency:2G:GSM 850 / 900 / 1800 / 1900; 3G:HSDPA 900 / 1900 / 2100
• OS:Android OS, v2.3 (Gingerbread), planned upgrade to v4.0
• User Interface:LG 3D UI
• Java:Yes, via Java MIDP emulator
• Processor:Dual-core 1.2 GHz Cortex-A9
• Chipset:TI OMAP 4430
• Graphics:PowerVR SGX540
• RAM:1GB
• Size:126.8 x 67.4 x 9.6 mm
• Weight:148 grams
• Display: 4.3 inch 3D LCD capacitive touchscreen
• Screen Resolution:480 x 800 pixels,(~217 ppi pixel density)
• Primary Camera: Yes,Dual 5 MP, 2592х1944 pixels
• Secondary Camera:Yes, VGA
• Flash:LED
• Video Recording:Yes, 1080p@30fps (2D), 720p@30fps (3D), video stabilization
• Camera Features: autofocus,Stereoscopic photos & videos, geo-tagging, out-focusing shot
• Battery type: Li-Ion 1520 mAh
• Talktime:4 h (2G) / Up to 3 h (3G)
• Standby Time:422 h (2G) / Up to 330 h (3G)
• GPRS:Yes
• EDGE:Yes
• 3G:Yes, 21 Mbps HSDPA; 5.76 Mbps HSUPA
• Wifi:Yes, 802.11 b/g/n
• USB connectivity:Yes, Yes, microUSB (MHL) v2.0
• Tethering:USB, Wi-fi Hotspot
• GPS Support:Yes, with A-GPS support
• Bluetooth:Yes
• Audio Jack:3.5 mm
• DLNA:Yes
• Internal memory:8 GB(5.3GB user available)
• Expandable Memory Slot: microSD, upto 32 GB
• Music Player:Yes, Supports MP3/WAV/WMA/eAAC+ player
• Video Player:Yes, Supports MP4/DivX/XviD/H.264/H.263/WMV player
• FM:No
• Ringtone:MP3, WAV
• Messaging:SMS (threaded view), MMS, Email, Push Email, IM
• Sensors:Accelerometer, gyro, proximity, compass

Cost of LG Optimus 3D P720: LG Optimus 3D Max P720 price is  not yet disclosed.

Lava KKT51 Review Price Specification

Lava KKT51 is a entry level dual sim touchscreen phone from Lava Mobiles. It has 3.2 inch touchscreen with screen resolution of QVGA 240*320 pixels. This Lava dual sim phone sports 1.3MP camera for taking the snaps. Interms of connectivity this phone has GPRS, USB and Bluetooth. Lava KKT51 is powered by 1450 mAh battery and has microSD card slot through which memory can added upto 16GB. Lava KKT 51 Price in India is ₹2620.

Features of Lava KKT51:

• 1.3 MP Primary Camera
• Dual SIM (GSM + GSM)
• 3.2-inch Touchscreen
• GPRS Enabled
• FM Radio with Recording
• Expandable Storage Capacity of 16 GB

Lava KKT51 Specifications:

• Operating Freq:GSM - 900, 1800
• Java:Yes
• Size:60.4 x 112.2 x 13.8 mm
• Display:3.5 inch touch screen
• Screen Resolution:QVGA, 240 x 320 Pixels
• Primary Camera:Yes, 1.3 Megapixel
• Battery:1450 mAh
• Expandable Memory Slot:microSD, upto 16 GB
• GPRS:Yes
• WAP:Yes
• USB connectivity:Yes
• Tethering:USB
• Bluetooth:Yes
• Audio Jack:3.5 mm
• Music Player:Yes, Supports MP3
• Video Player:Yes
• FM:Yes, with Recording
• Call Memory:Yes
• SMS Memory:500
• Phonebook Memory:1000
• Additional Features:Games, English and Hindi Language Support, Torch, Calculator, Alarm Clock, Auto Call Recording, PC Suite, Converter, To-do List, Phonebook and Message Backup, FM Alarm, Privacy Support, Auto-redial, Webcam, Animated Wallpapers, Dictionary
• Important Apps:Facebook, Twitter, Nimbuzz, Yahoo Messenger, Apps Stores

Grouping Items By Date in A Pivot Table Excel

Excel Pivot table offers many useful functions. One of them is to combine items into groups.  Grouping items in Pivot table is very simple. Just select the range where you need to group and choose Pivot Table Tools-> options-> Group-> Group Selection. If the field contains dates, then Excel can automatically group them into months, Year, Quarter or the three.  Below is the procedure to group different dates into Monthwise summary or year wise summary.
Steps to Group Dates into Months, Year and Quarter in Excel Pivot Table:
Let us start with using a example on the same. Below is the sample data which has two columns of data. Date and Total Sale Value. The table has 20 rows and cover dates between January 2011 to May 2012.
The desired final output is to summarize the sales information by months.
Step 1: Create the pivot table using the table.  The initial pivot table looks almost similar to the raw data.

Step2: To group item by month, right click any cell in date column of the pivot table and select Group from the shortcut menu.  A Grouping dialog menu appears.
Step3: In the list box Select Months and Years and verify that the starting and ending dates are correct and Click OK.
The date Items in the pivot table are grouped by years and by months. Even you can group the dates by quarter and years too. Below the final output of Grouping by month and year, quarter and Year.

Samsung Smart TV Review Price Specification

Samsung has launched Smart TV in India recently. The Smart TV allows the user to chat with friends,search movies and even browse the internet apart from watching the  Live TV programs in high Definition screen. Like Smartphone, the Samsung Smart TV comes with Smart Hub from where the users can access several features such as viewing movies, open web browser for surfing or launch apps that were downloaded on the TV.
The Samsung Smart TV comes with preloaded web browser, which is optimized  for the use of Smart TV. This enables the user to surf the internet, read the news on TV.  There is also function called Search all Functions with which users can locate the shows to watch and help organised related content even when viewing the Live TV.  The Video Recommendation engine suggest the latest videos based on the users individual taste.

There are many apps to chose and download to the smartTV such as NetFlix, Blockbuster, Youtube and Hulu Plus to name a few.User can also get social updates from Twitter or Facebook.
Price of Samsung Smart TV: Below are the prices of Samsung Smart TV for the various variants.

Samsung Smart TV 8 Series Price List:

• 60D8000 LED TV Price ₹4,00,000
• 55D8000 LED TV Price ₹2,49,990

Samsung Smart TV 7 Series Price List

• 46D7000 LED TV Price ₹1,59,990

Samsung Smart TV 6 Series Price List

• 55D6600 LED TV Price ₹2,00,000
• 46D6600 LED TV Price ₹1,39,990
• 40D6600 LED TV Price ₹ 99,900
• 46D6000 LED TV Price ₹ 1,10,000
• 40D6000 LED TV Price ₹ 83,990
• 32D6000 LED TV Price ₹ 57,900

Samsung Smart TV 5 Series

• 46D5500 LED TV Price ₹93,900
• 40D5500 LED TV Price ₹68,900

Blackberry Curve 9320 Review Price Specification

Blackberry Curve 9320 is 3G enabled smartphone from RIM. It has 2.44 inch TFT display screen with screen resolution of QVGA 240*320 pixels. The QWERTY keypad of this phone makes the typing ease. The Blackberry Curve 9320 sports 3.2MP rear camera with LED flash.Blackberry Curve 9320 is powered by Li-ion 1450 mAh battery which is rated to provide standby time upto 432 hours and talk time upto 7 hours. This is second smartphone RIM to available for affordable price. The other one is Blackberry Curve 9220.  The Blackberry Curve 9320 price in India is ₹15,500(~$282).

Blackberry Curve 9320 Features:

• Latest BlackBerry 7.1 Operating System
• 3.2 MP rear Camera with LED flash and auto focus
• 2.44-inch TFT LCD Screen
• QWERTY Keypad
• 3G-7.2 Mbps HSDPA; 5.76 Mbps HSUPA
• GPRS and EDGE Enabled
• Expandable Storage Capacity of 32 GB
• Li-ion 1450 mAh battery

Advantages and Disadvantages of Blackberry Curve 9320:

Pros of Blackberry Curve 9320:

• Well spaced QWERTY keypad
• Decent camera
• Good battery performance
• Expandable memory and 3G connectivity

Cons of Blackberry Curve 9320:

• No Front facing camera for video calling and video chatting
• Small screen size

Blackberry Curve 9320 Sales box Content: Handset, Battery, Charger, Headset, 2 GB microSD Card, Data Cable, User Manual

Blackberry Curve 9320 Specification:

• Operating Frequency:GSM - 900, 1800; UMTS - 2100
• OS:BlackBerry 7.1 OS
• RAM: 512MB
• Java:No
• Size:60 x 109 x 12.7 mm
• Weight:103 g
• Display: 2.44 inch TFT
• Screen Resolution:QVGA, 240 x 320 Pixels
• Primary Camera:Yes, 3.2 Megapixel
• Secondary Camera:No
• Flash:LED
• Video Recording:Yes
• Zoom:Digital Zoom - 4x
• Camera Features:Geo-tagging, Image Stabilization
• Type:Li-Ion, 1450 mAh
• Talktime: Upto 7 hrs
• Standby Time: Upto 432 hrs
• Expandable Memory Slot:Yes.microSD, upto 32 GB
• GPRS:Yes
• Edge:Yes
• 3G:Yes, 7.2 Mbps HSDPA; 5.76 Mbps HSUPA
• Wifi:Yes, 802.11 b/g/n
• USB connectivity:Yes, micro USB, v2
• Tethering:Wi-fi Hotspot
• GPS Support:Yes, A-GPS with BlackBerry Maps
• Bluetooth:Yes, v2.1, Supported Profiles (A2DP, HSP, HFP, OBEX, PBAP, DUN, AVRCP, SPP, SSP, MAP)
• Audio Jack:3.5 mm
• Music Player:Yes, Supports MP3, eAAC+, WAV
• Video Player:Yes, Supports MP4, H.263, H.264, M4A, 3GP, 3GP2, M4V, AVI, ASF, WMV
• FM:Yes
• Ringtone:MP3, 64 Polyphonic, MIDI, WAV
• Sensors:Accelerometer, Proximity Sensor, Compass