Saturday, June 2, 2012

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

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.
Lava Dual sim touch screen phones

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

Friday, June 1, 2012

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.
Samsung Smart TV smart Hub

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 smartphones

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

Thursday, May 31, 2012

Samsung Galaxy SIII launched in India

Samsung Has launched its flagship model Samsung Galaxy SIII in India on Thursday. This new Galaxy Smartphone runs on latest android OS Ice Cream Sandwich and powered by quad core 1.4GHz processor with 1GB of RAM.  Samsung Galaxy S3 price in India is set to be ₹43,180. However Flipcart best buy offer price on S3 is ₹38,900. It is available in two colors. The white color variant will be available immediately and Pebbel Blue variant will be little delayed.
Samsung Galaxy SIII is first announced at  press event in London early May. It has 4.8 inch Super AMOLED screen with a screen resolution of 720p. Customers can chose two internal memory options 16GB and 32GB.  Other features of Galaxy S3 are 32GB storage with a slot for microSD card, 8MP camera with burst mode, zero shutter lag and backlit sensor, 2,100mAh battery, Wi-Fi, 3G and Bluetooth. The phone has a dimensions of 70.6 x 136.6 x 8.6 mm and weighs 133 grams. For more details view Samsung Galaxy S3 Review.
Samsung Galaxy SIII

Key Specification of Samsung Galaxy S3:

  • Dimensiion:70.6 x 136.6 x 8.6 mm
  • Weight:133 grams
  • 1.4GHz quad core processor with 1GB RAM
  • 16GB/32GB internal memory
  • Expandable memory through microSD card is 32GB
  • Runs on Android Ice Cream Sandwich OS with  TouchWiz Nature UX user interface.
  • 8MP rear camera with Geo-tagging, Touch Focus, Face and Smile Detection, Image Stabilization, Auto Focus, Image Edito
  • VGA Front camera
  • 2G, 21 Mbps HSDPA; 5.76 Mbps HSUPA, WiFi and USB connectivity
  • MP4, DivX, XviD, WMV, H.264, H.263, HD Video Playback video formats supported
  • MP3, WAV, eAAC+, AC3, FLAC audio formats supported
  • Accelerometer, Gyro Sensor, RGB Sensor, Proximity Sensor, Barometer, Compass sensors
  • S Voice, Social Tag, S Beam, Wi-Fi Direct, Voice Input

Bajaj Discover 100 4G Review Price Specification

There are many new comers into the 100cc commuter bike segment. The new Entrant is Bajaj Discover 100 4G.  It has 94.38cc Single cylinder 4 stroke air cooled engine with max power upto 7.7@7500rpm and max torque of 7.85Nm@5000rpm. The new Bajaj Discover has 8 liter fuel tank(2.5 liter reserve) and provides a mileage upto 89kmpl on highways and 70kmpl on city traffic. This new 100cc bike is available in 4 color shades, Black blue, Black Green, Black Magneta, Flame Red. Bajaj Discover 100cc price in India is ₹44,500.
Bajaj Discover 4G

Key features of Bajaj Discover 100 4G:

  • 94.38cc Single cylinder 4 stroke air cooled engine
  • Max power upto 7.7@7500rpm
  • Max torque of 7.85Nm@5000rpm.
  • Upto 89kmpl mileage on Highway and upto 70kmpl mileage on city road
  • 5-speed gearbox-All down 5 speed gears for smooth ride
  • Front and rear Drum brakes
Advantages and Disadvantages of Bajaj Discover 100 4G:
Pros of Bajaj Discover 100cc:
  • Good on road mileage
  • Comfortable riding
  • decent look and design
Cons of Bajaj Discover 100 4G:
  • Lacks power and Pickup
  • Develops timer chain noise
Bajaj Discover 100 4G Specification:
Engine
  • Type :Single cylinder, 4 stroke, air cooled
  • Displacement:94.38 cc
  • Compression ratio:9.8 : 01
  • Max. Power :7.7Ps @ 7500RPM
  • Max. Torque:7.85Nm @ 5000RPM
Transmission
  • Clutch Type:Wet multiplate
  • No. of gear:5
  • Gear shift pattern:All down
Suspension
  • Front:Telescopic, wheel travel 130 mm
  • Rear:Nitrox, wheel travel 110 mm
Brakes
  • Front:Drum, 130 mm
  • Rear:Drum, 110 mm
Tyre
  • Front:2.75 X 17" (Unidirectional)
  • Rear:3.00 X 17" (Unidirectional)
Fuel Tank
  • Fuel tank capacity:8 liter full (2.3 liter reserve)
Chassis
  • Type Single down tube
Electricals
  • Battery:12V, 5Ah
  • Head lamp:35 / 35 W
  • Tail / stop lamp:LED type
  • Horn type & no.:DC / one
Dimensions
  • Length:2040 mm
  • Width:760 mm
  • Height:1087 mm
  • Wheel base:1305 mm
  • Ground Clearance:162 mm
  • Kerb weight:115 kg