Tech2 Touch

Author: Aniruddh

  • Samsung Galaxy S Duos Review Specification Price

    Samsung Galaxy S Duos S7562 is a mid range Dual sim Android smartphone. It is powered by 1GHz Cortex A5 processor with 768MB of RAM and Adreno 200 GPU. The device measures 63.1×121.5×10.5 mm and weighs 120 grams. The overall design of the phone is much inspired by the Samsung Flagship model Galaxy S3. Samsung Galaxy S Duos price in India is ₹9,599.
    Samsung Android Dual sim phones

    Samsung Galaxy S Duos comes with 5MP primary camera and VGA front facing camera. The camera has features such as auto focus, panorama and photo effects, 2X digital zoom along with LED flash. The dual sim Android smartphone capable of shooting 480p videos at 30fps.Internal memory of the Galaxy S Duos 7562 is 4GB which can be further increased by adding microSD card upto 32GB. The device comes with 1500mAh battery which will provide talk time upto 12 hours and 570 hours of standby time.

    Samsung Galaxy S Duos supports GPRS, EDGE, Wi-Fi and Wi-Fi Hotspot, Bluetooth and USB connectivity. It also supports GPS with AGPS service. The S7562 is bundled with popular apps such as Chat ON, SNS Integration, Play Store, Samsung Apps, Google Search apps.
    Samsung Galaxy S Duos S7562 is going get Jelly Bean update soon. The updates can be installed through OTA or using the Latest Samsung Kies. With the help of Samsung Kies, the device can be used as modem through USB tethering. The devices with WiFi connectivity can be easily connected through the WiFi Tethering features. Like any other Galaxy Device, this device to support Samsung Mobile PC suite Kies 2.6.  It is highly recommended to have Samsung Kies installed in your PC as this device at time requires firmware updates through PC only.

    Merits and Demerits of Samsung Galaxy S Duos S7562

    Merits of Galaxy S Duos:

    • Decent snappy processor with 768MB RAM
    • Dual sim support with Smart Dual feature
    • Front facing camera support
    • Stylish and slim design
    • Excellent battery life for Android Standards

    Demerits of Galaxy S Duos:

    • No HD video recording support. It supports on 480p videos
    • The touch response is not that great
    • Phone hangs some times
    • No Dedicated shutter key
    • No Ambient Light Sensor

    Samsung Galaxy S Duos Specification Summary

    • Runs on Android 4.0 ICS OS. Upgradable to Jelly Bean
    • 1GHz Cortex A5 processor with 768MB RAM and Adreno 200GPU
    • 4 inch TFT capacitive touch screen with WVGA 480*800 pixel resolution
    • 5MP auto focus camera with LED flash and VGA front facing camera
    • Dimensions- 63.1×121.5×10.5 mm and weighs 120grams
    • Accelerometer, Proximity Sensor, Compass sensors
    • 4GB internal memory and expandable memory support upto 32GB
    • 1500mAh battery with talk time upto 12 hours and standby time upto 570 hours.
    • GPRS, EDGE, Wi-Fi and Wi-Fi Hotspot, Bluetooth and USB

  • Samsung Guru E1207T Dual Sim Review Price Specification

    Samsung Guru E1207T is a basic budget feature phone with dual sim support. The device supports GSM+GSM dual sim with dual standby feature and it supports mini SIM. Samsung Guru E1207T price in India is ₹1340.

    Samsung Guru Dual sim phones

    Samsung Guru E1207T measures 45.5x108x13.5 mm and has 1.52 inch TFT display screen with 128*128 pixel resolution.  This Samsung Dual sim feature phone is powered by 800 mAh battery which provides talk time upto 8 hours and standby time upto 430 hours. Other features of this Cheap Dual sim Samsung phone are FM Player, Torch, 5 Way Navigation Key, Anti-dust Keypad, Mobile Prayer, News and Weather. SAR value of the device is 0.920W/Kg. The Samsung phone has 500 SMS memory and 1000 phone book memory. Samsung Guru E1207T comes with 1 year manufacturer for phone and 6 month warranty for the box accessories.
    Key Features of Samsung Guru E1207T dual sim:

    • 1.52 inch TFT display screen
    • GSM+GSM dual sim support with dual standby time
    • 800mAh battery with talk time upto 8 hours and standby time upto 430 hours
    • Alphanumeric anti dust keypad
    • Built in FM Radio

    Samsung Guru E1207T Full Specifications:

    • Operating Frequency:GSM – 900, 1800
    • Size:45.5x108x13.5 mm
    • SAR Value:0.920 W/Kg
    • Display: 1.52inch TFT
    • Screen Resolution: 128*128 pixels
    • Battery: 800 mAh
    • Talk Time:8 hrs
    • Standby Time:430 hrs
    • Call Memory:Yes
    • SMS Memory:500
    • Phone Book Memory:1000
    • Additional Features:GSM, FM Player, Torch, 5 Way Navigation Key, Anti-dust Keypad, Mobile Prayer, News and Weather

  • Counting Non Duplicate Entries in a Range in Excel

    When we are doing analysis in excel or preparing the reports, we will face situations where we need to calculate the unique entries. There is no direct function in Excel to calculate only non duplicate entries in a Range. However this can be achieved through array functions of Excel. Below is the example through which we will learn to use Excel function to calculate non duplicate entries count.

    Count non duplicate values

    The above example has list of gadgets in Column A2 to A10. However there are duplicates in List. Our goal is calculate unique number of Gadgets. So the formula to count non duplicate entry is
    =SUM(1/COUNTIF(A2:A10,A2:A10)) which returns 5. i.e out of 9 entries only 5 items are unique.
    Note: For using array functions, press Ctrl+Shift+Enter(Not Just Enter). Excel surrounds the formula with braces to remind you that it is a array formula.
    This formula is first used by David Hager and then passed around on various web sites and newsgroups. The  above array formula works fine unless the range contains one or empty cells. To overcome this short fall we should use below formula with new IFERROR function.
    =SUM(IFERROR(1/COUNTIF(A1:A10,A1:A10),0))
    The preceding formula work with both values and text. If the range contains only numeric values or blank cells(But no text), we can use the below mentioned formula(This is not array formula) to count the number of non duplicate or unique values.
    =SUM(N(FREQUENCY(A1:A10,A1:A10)>0))

  • Calculating Weighted Average in Excel

    Excel inbuilt Average function returns the average(or Mean) of a range of a data. However in many occasions we are required to calculate weighted average. Though Excel do not comes with a straight function to calculate weighted average. This can be done with the use of SUMPRODUCT and SUM functions. Let us start learning about weighted average with an example.

    Below is the sample data from a call center and let us calculate the Average Handle Time(AHT) for the day using different intervals calls and AHT.  The below data shows that initial hours calls were less and the AHT too was less. But as the call volume increased the AHT also increased.,

    Excel Formula Example

    The simple average formula =AVERAGE(C3:C9) returns 216.42. The problem with this is that it calculates average without considering the number calls. So we need to calculate average considering the number of calls received on each intervals. Ideally, the weighted average is the appropriate method to calculate like this calculations.

    So weighted average formula for the above example is =SUMPRODUCT(C3:C9,B3:B9)/SUM(B3:B9)
    This formula multiplies each AHT by its corresponding number calls and then adds all those products. The result is then divided by the number of days. This formula can be easily implemented to other types of calculations where weighted average is required.

  • Creating a Drop Down List in a Cell in Excel 2012

    There are situations, where we need to use restricted set of data in a list. When in data entry works are carried out by many people, chances are vast that small errors might occur. To overcome this, we can use drop down list in Excel. This not only restricts the user to enter the correct data also it helps to reduce the time to write it manually.  So for creating Drop down list, do we need to use Excel VBA feature? No;. Excel provides this feature in the form of data validation. So let us see how to create drop down list in Excel.
    Steps to Create Drop List in Excel:

    • Enter the list of items in a range
    • Select the cell that will contain the drop down list
    • Choose Data-> Data Tools->Data Validation
    • In the data validation dialog box, click the settings Tab
    • In the allow drop-down list select List.
    • In the source box specify the range that contains the items
    • Make sure that the In-Cell Drop down option is checked and Click OK
    • You are done. The drop down list is created in your desired Cell.

    Note:

    • If your list is small, then you can manually enter the list of items in the source box in the Data Validation dialog box.
    • You can copy paste the Drop down list created cell to other cells to carry the drop down list.