Author: Aniruddh

  • Sony Ericsson Xperia Arc S Review Price Specification

    Sony Ericsson Xperia Arc S is a sequel of Sony Ericsson Xperia Arc. This  smartphone runs on Android Gingerbread OS(Ver.2.3) . This new Android smartphone has single core 1.4GHz processor and 512MB RAM. Arc S comes with 4.2 inch TFT capacitive touchscreen with screen resolution of FWVGA, 854 x 480 Pixels.
    Sony Ericsson Arc S has 8.1MP rear camera with auto focus and LED flash. The other features of the rear camera are Video calling, touch focus, geo-tagging, face and smile detection, 3D sweep panorama, image stabilization.  This New Sony Ericsson Arc S is powered by Li-Po  1500 mAh battery which provides a talk time upto 7 hours on both 2G and 3G.
    Xperia Arc S
    Summary of Sony Ericsson Xperia Arc S features:

    • Android v2.3 (Gingerbread) OS upgradable to ICS
    • 8.1 MP Primary Camera
    • 4.2-inch TFT Capacitive Touchscreen
    • 1.4 GHz Scorpion Processor
    • Expandable Storage Capacity upto 32 GB
    • GPRS, EDGE, 3G and Wi-Fi
    • PUSH Email along with Document Viewer and Document Editor
    • 1500 mAh Li-Po battery with upto 7 hours of talk time on 2G and 3G

    Pros and Cons of Sony Ericsson Xperia Arc S

    Pros of Xperia Arc S

    • Faster performance
    • Excellent battery life
    • pseudo 3D capture abilities
    • Screen shot function
    • Sleek form factor
    • Crisp display

    Cons of Xperia Arc S

    • No front camera
    • Single core processor
    • no qHD display

    Sony Ericsson Xperia Arc S sales box content:Handset, Battery, Charger, Headset, 8 GB microSD Card, Data Cable.

    Sony Ericsson Xperia Arc S Specification

    • Operating Freq:GSM – 850, 900, 1800, 1900; UMTS – 2100
    • OS:Android v2.3 (Gingerbread)
    • User Interface : Timescape
    • Java:Yes
    • Processor:1.4 GHz Qualcomm Scorpion
    • Graphics : Adreno 205
    • RAM:512 MB
    • Size:63 x 125 x 8.7 mm
    • Weight:117 g
    • Display: 4.2 inch TFT capacitive touch screen with gesture inputs
    • Screen resolution:FWVGA, 854 x 480 Pixels
    • Primary Camera:Yes, 8.1 Megapixel
    • Flash:LED
    • Video Recording:Yes, 1280 x 720, 30 fps
    • HD Recording:HD
    • Zoom:Digital Zoom – 16x
    • Camera Features:Video Stabilizer, Smile Detection, Auto Focus, Geo-tagging, Red-eye Reduction, Face Recognition, Image Stabiliser, Face Detection, 3D Sweep Panorama
    • Battery Type:Li-Po, 1500 mAh
    • Talktime:7 hrs (2G), 7 hrs (3G)
    • Standby Time:460 hrs (2G), 460 hrs (3G)
    • Internal memory:320 MB
    • Included Memory Card:8 GB
    • Expandable Memory Slot:microSD, upto 32 GB
    • GPRS:Yes, 86 kbps
    • Edge:Yes, 237 kbps
    • 3G:Yes, 14.4 Mbps HSDPA; 5.8 Mbps HSUPA
    • Wifi:Yes, 802.11 b/g/n
    • USB connectivity:Yes, micro USB, v2
    • Tethering:USB, Wi-fi Hotspot
    • GPS Support:Yes, A-GPS with Google Maps
    • Bluetooth:Yes, v2.1, Supported Profiles (A2DP)
    • HDMI Port:Yes
    • Audio Jack:3.5 mm
    • DLNA:Yes
    • FM:Yes
    • Sound Enhancements : xLOUD Engine Audio Filter Technology
    • Ringtone:MP3
    • Music Player:Yes, Supports MP3, eAAC+, WAV
    • Video Player:Yes, Supports MP4, H.263, H.264, WMV, HD Video Playback
    • Sensors : CMOS Sensor, Accelerometer, Proximity Sensor, Digital Compass
    • Additional Features:Bookmarks, 3D Games, ANT+ Technology, Sound Recorder, Predictive Text Input, MMS Enabled, Noise Shield, E-manual, Infinite Button, Flight Mode, Calculator, Alarm Clock, Calendar, Conversation, Album Art, Video Streaming, Voice Input, TV Out Port
    • Important Apps:Facebook, Twitter, Google Talk, Android Market, Google Search, Gmail, Google Latitude, Google Calendar, YouTube, Instant Messaging

    Cost of Sony Ericsson XperiaArc S: Sony Ericsson Xperia Arc S price in India is ₹24,999 and in United states $439.99 and in United Kingdom price is £325.36.

  • Samsung Galaxy Note USB tethering

    Samsung Galaxy Note is a Hybrid of a smartphone and a Tablet. It runs on Android Gingerbread OS. This smartphone is tethering enabled. Hence you can use Samsung Galaxy Note as WiFi Hotspot  or for USB tethering. Advantage of using Galaxy Note USB tethering is that, it will reduce battery consumption compared to WiFi. Below are the steps to enable USB/Wireless tethering of Samsung Galaxy Note.

    USB tethering of Samsung Galaxy Note

    Below are the steps to follow to enable USB tethering on Galaxy note if you are running on Windows 7 or latest versions of Linux such as Ubuntu Linux. However for other OSes PC needs to prepared to accept connection.

    1. Connect your Galaxy Note to PC or laptop using the USB cable provided with the phone.
    2. Go to Settings of your smartphone
    3. Select “Wireless and Network Option”
    4. Choose “Tethering and portable Hotspot”
    5. Check “USB tethering”  to share your phone internet connection with PC or Laptop.
    6. You are done. There will be notification in your system on internet connection
    7. To disable USB tethering of Samsung Galaxy Note, Uncheck “USB tethering” option

    As mentioned above, the procedure works well with Windows 7. However if you are using Windows XP, then you need to configure your computer to enable Galaxy Note tethering.
    USB Tethering of Samsung Galaxy Note on Windows XP:

    • Download the configuration file “tetherxp.inf to your computer. You can download this by visiting Android Driver page
    • Follow step mentioned above from  1 to 4.
    • Once you enable USB tethering on your Galaxy Note, Windows will open up “New Hardware Wizard”.Select “NO.Not at this time” and click “next” on your computer
    • Choose “Install from a list or specific location” and click “Next”
    • Windows uses itself the configuration file which you have downloaded to support USB tethering  with the Samsung Galaxy Note.
    • Once Windows finishes installing the drivers for Android USB Ethernet/RNDIS, click finish
    • Now you can use the new Windows Local area network connection provided by Samsung Galaxy Note via USB tethering.
  • Samsung Galaxy Ace Duos Review Price Specification

    Samsung Galaxy Ace Duos I589 is new addition to Samsung Galaxy series dual sim phone range.  Ace Duos is a CDMA and GSM dual sim phone with dual standby feature. There are very few changes done on Ace duos compared to Galaxy Ace. The main changes are battery capacity and additional CDMA sim support. The rest of the specs such as screen size, processor are remained same. From the negetive aspect, the camera resolution is reduced from 5MP to 3MP and flash is not available in this model.

    Update: This phone is discontinued now. Hence, this Galaxy smartphone will not available on market.

    Samsung Galaxy Ace with Dual Sim
    Samsung Galaxy Ace Duos

    Comparison between Samsung Galaxy Ace S5830 and Samsung Galaxy Ace Duos I589

    Processor: Both have 800 MHz Processor
    SIM: Ace 5830 had single sim support whereas Ace duos support Dual sim. One for GSM and one for CDMA.
    Camera: Samsung Galaxy Ace features 5 MP camera with flash and Samsung Galaxy Ace Duos features 3 MP camera without flash. Both do not feature secondary camera for video calls.
    3G Connectivity: Galaxy Ace supports HSDPA speed upto 7.2MBPS and Galaxy Ace duos supports speed upto 3.1 Mbps EV-DO Rev. A.
    Battery:  Ace S5830 is powered by Li-ion 1350 mAh battery and Ace duos I589 is powered by Li-Ion 1650 mAh battery.
    Display Screen size and Resolution: Both have 3.5 inch capacitive touch screen and has screen resolution of  HVGA 320*480 pixels.
    Operating System: Both the Samsung Galaxy Ace and Samsung Galaxy Ace duos runs on Android Gingerbread OS.
    Size and  weight: Ace S5830 has a dimension of 59.9 x 112.4 x 11.5 mm and weighs 113 grams and Ace Duos I589 has dimension 59.9 x 112.4 x 12.5 mm and weighs 122 grams.
    Features of Samsung Galaxy Ace Duos I589:

    • Android v2.3 (Gingerbread) OS
    • 3 MP Primary Camera
    • Dual Standby SIM (GSM + CDMA)
    • 3.5-inch TFT Capacitive Touchscreen
    • 800 MHz Scorpion Processor
    • Wi-Fi Enabled
    • Expandable Storage Capacity of 32 GB

    Detailed Full Specification of Samsung Galaxy Ace Duos:

    • Operating Freq:GSM – 900, 1800; CDMA – 800
    • OS:Android v2.3 (Gingerbread)
    • User Interface:TouchWiz
    • Java:Yes
    • Processor:800 MHz Qualcomm Scorpion
    • Size:59.9 x 112.4 x 12.5 mm
    • Weight:122 g
    • Display: 3.5 inch capacitive touch screen with HVGA 320*480 pixel resolution
    • Primary Camera:Yes, 3 Megapixel
    • Secondary Camera:No
    • Video Recording:Yes
    • Camera Features:Geo-tagging, Auto Focus, Image Editor
    • Battery Type:Li-Ion, 1650 mAh
    • Talk time:7 hrs (2G)
    • GPRS:Yes
    • Edge:Yes
    • 3G:Yes, 3.1 Mbps EV-DO Rev. A
    • Wifi:Yes, 802.11 b/g/n
    • USB connectivity:Yes, micro USB, v2
    • Tethering:Wi-fi Hotspot
    • GPS Support:Yes, A-GPS with Google Maps
    • Bluetooth:Yes, v3
    • Audio Jack:3.5 mm
    • FM:Yes
    • Ringtone:MP3, WAV
    • Music Player:Yes, Supports MP3, WAV, eAAC+
    • Video Player:Yes, Supports MP4, H.263, H.264

    Cost of Samsung Galaxy Ace Duos I589: Samsung Galaxy Ace Duos price in India is ₹13,899. This is one of the best price currently available and you can it through Flipcart.com.

  • Password protecting Excel VBA macros

    We will be facing many circumstance where we need to password protect the excel VBA code we have written. Some times it may be for avoiding unintentional changes to the VBA codes or for hiding our codes from the others. Excel VBA provides a simple way to protect Excel VBA macro using password. This will not only protects from making changes also it protects the code from viewing. Lets start learning on how to password protect Excel VBA codes.

    Step to protect Excel VBA codes using password

    Below are steps to be followed to password protect the VBA codes.

    • First open VBA editor. Shortcut key for opening VBA editor is Alt+F11
    • Go to tools-> Select “VBA project Properties”
    • There new screen pops up. Select “Protection” Tab. You will get a screen similar to given below

    • Select the check box beside “Lock project for viewing” to hide the codes from viewing without password. If you do not want to hide the macro code and just want to protect your codes, then do not select the check box.
    • Enter the desired password in the “Password” labeled text box. Once again type the same password in the “confirmation password field “too.
    • You are done. Save the sheet and close the excel sheet.
    • Next time if you open VBA explorer you will prompted for password to view or modify the codes.

    This is method of password protecting of Excel VBA codes works on almost all current version of Excel.

  • Saving contacts in CSV format from Outlook 2010

    For back up the contacts or moving contacts, we require to export contacts from Outlook. One of the way is to save the contacts in Excel CSV format. Saving contacts of MS outlook 2010 in CSV formats has many advantages such as searching and ordering of contacts in Excel or Access. Even though Outlook 2010 supports, exporting of contacts in many formats such as Microsoft Access file or xls or csv.

    Due to different tool uses different formatting, .csv format comes more handy. It just takes the content and not the format. One more advantage of exporting contacts from Outlook in CSV format is, you can even import this contacts to your android smartphones. So we will learn how to export the contacts from Outlook and import them in to Microsoft excel.

    Steps to Export Outlook contacts as CSV file:.

    • Open the Outlook contacts for exporting and click on the “Contacts” field in the navigation field of the application.
    • Click Open the “File”  tab in the multi function bar and click on the function “Open” and “Import”
    • Select the option “Export to a file” and click on “Next”.
    • Mark the “Comma Separated Values(Windows)”  on the next page and again click on “Next”
    • Now select the contact folder and give “Next”
    • Select the target location where you want to save the CSV file
    • Click on “Next” and “Finish” to start the export

    Importing CSV format contacts to Excel:

    • In Excel  2010 click on “Data” Menu and then select “From Text” option
    • Select the CSV file which you have exported from Outlook and start the wizard for text conversion by pressing “Import”.
    • On the first page of the wizard, activate the option “Delimited”.
    • In second page remove Tick mark for “Tabular” and set it for “Comma”
    • Select next and Click on Finish.

    In Excel you format the contact in your desired way. You can delete duplicate contacts, merge contacts and perform many tasks which you might be already aware. For importing the contacts to gmail or Android phone, it has standard format. Just align the contents to according to standard format and import.