Author: Aniruddh

  • Xiaomi MiPad With Tegra K1 SOC and 7.9 inch Display

    Xiaomi on its event on 12th March, launched two devices in India. The first one is Redme 2 and the other one is table which is named as MiPad.  It was first unveiled in China last year May month. Xiaomi first table in India is available exclusively on Flipkart. Unlike other Xiaomi devices, this will be available without flash sales. Xiaomi MiPad price in India is Rs.12,999.

    Xiaomi MiPad  sports 7.9-inch IPS Retina display with screen resolution of QXGA (2048×1536 pixel)  and a pixel density of 324ppi, all of which is protected by Corning Gorilla Glass 3 screen. This tablet runs on Android 4.4 Kitkat along with MiUI.

    Xiaomi MiPad is powered by ‘4+1’-core Nvidia Tegra K1 SoC ARM Cortex-A15 processor clocked at 2.2GHz with the 192-core Kepler GPU, alongside 2GB of LPDDR3 RAM. This tablets claims to pack Kepler GPU architecture and supports OpenGL 4.4 and OpenGL ES 3.1. Connectivity features of the tablet includes dual-band Wi-Fi 802.11 a/b/g/n/ac and Bluetooth 4.0.  The MiPad tablet houses 6700mAh Li-ion battery. The internal storage of this tablet is 16GB.

    Xiaomi Tablet

    Xiaomi MiPad houses a  8-megapixel rear camera with a Sony BSI sensor that can shoot full-HD resolution videos. There is also a 5MP front facing camera with OmniVision sensor. Both camera do feature  f2.0 aperture. MiPad measures 135.4×202.1×8.5mm and weighs 360 grams.

    Considering at the specification, this Xiaomi tablet looks of the best value for money tablet. However, real time performance will be known once we get the device for review. Only thing which strikes as of now is lack of Android 5.0 Lollipop out of the box.

    Xiaomi MiPad Specification

    • ‘4+1’-core Nvidia Tegra K1 SoC ARM Cortex-A15 processor clocked at 2.2GHz with the 192-core Kepler GPU.
    • 2GB of LPDDR3 RAM and 16GB internal storage.
    • 8-megapixel rear camera with a Sony BSI sensor
    • 5MP front facing camera with OmniVision sensor
    • 135.4×202.1×8.5mm and weighs 360 grams
    • dual-band Wi-Fi 802.11 a/b/g/n/ac and Bluetooth 4.0
    • 6700mAh Li-ion battery.
  • Xiaomi Redmi 2 Launched in India at Rs.6999

    Xiaomi Redme 2 is the successor to  popular budget dual sim Android smartphone Redme 1s. The device is priced at Rs. 6999 and will be available exclusively on Flipart. Like Redme 1S, this also available through flash sales.  The registration starts from today and sale starts on March 24. The limited edition Redme 2 with 2GB RAM and 16GB internal storage will be launched in India on later date.

    Recommended Readin: 

    Xiaomi Redmi 2 Now Available for Rs.5,999

    Lenovo Vibe P1m with 3900 mAh battery and 5 inch HD display at Rs.7999

    Guide on How to download Redme 2 PC Suite

    Xiaomi Redme 2 has many features same as its predecessor and some upgrades. It is powered by 64bit 1.2GHz quad core Snapdragon 410 processor with 1GB of RAM. The device has 8GB of internal storage and supports microSD card  for additional storage. It runs on Android 4.4 Kitkat with MIUI 6 UI. Redme 2 is dual sim 4G and both sim supports 4G.

    Xiaomi Redme 2 Dual sim

    Xiaomi Redme 2 sports 4.7inch IPS display with screen resolution of 1280×720 pixels and 312 ppi pixel density. The display has Corning Gorilla Glass 2 protection. The device is 9.4mm thin and has matte touch back cover along with fingerprint and grease resistance.

    Xiaomi Redme 2 houses 8MP primary camera with LED flash and 2Mp front facing camera. The connectivity features of the device includes 2G, 3G, 4G, Bluetooth and GPS. The device also supports USB OTG. Xiaomi Redme 2 will be available in pink, yellow, green, grey and white colors. This device will compete with other budget 4G smartphones in India such as Lenovo A6000,  Yu Yureka and Moto E 4G edition.

    Read:

    Lenovo A6000 Review

    Yu Yureka Review

    Xiaomi Redmi 2 Specifications

    • 64bit 1.2GHz quad core Snapdragon 410 processor with 1GB of RAM.
    •  4.7inch IPS display with screen resolution of 1280×720 pixels and 312 ppi pixel density.
    • 8GB of internal storage and support for  microSD card.
    • 2G, 3G, 4G, Bluetooth and GPS
    • Android 4.4 Kitkat with MIUI 6 UI
    • 2200mAh battery.
  • Xiaomi Mi4 Cons and Pros Review

    Xiaomi Mi4 is the last year flagship model of the company. Almost a year later it is available for Indian customers. The previous models Xiaomi Mi3, Redme 1s got huge success. However, Redme Note not received the same response like the other. When Xiaomi launched Mi3 or Redme 1s, it was something great offering for that price. Now Xiaomi Mi4 has many competitors such as with same price tag and specification. We will see how is the performance of this device.

    Read:

    OnePlus One review

    Huawei Honor 6 Review

    Xiaomi Mi4 is powered by 2.5GHz Quad core Snapdragon 801 CPU with Adreno 330 GPU and 3GB of RAM. It comes with 16 or 64GB internal storage. Unfortunately there is no option to add additional storage through microSD card. Out of the box device runs on Android 4.4.4 Kitkat with MIUI 6 skin.

    Xiaomi Mi4 Review

    Xiaomi Redme Mi4 sports 5 inch IPS  capacitive touch screen with screen resolution of 1080*1920 pixels which results in pixel density of 441. The screen has Corning One glass Solution for protection against scratches. Connectivity features of the device includes 2G, 3G, 4G, WiFi, Bluetooth and USB. 4G of this device is not compatible with Indian 4G networks.

    Xiaomi Mi4 houses 13MP front facing camera which can record upto 4K resolution videos and 8MP front facing camera.  It has 3000 mAh battery. It does supports Qualcomm fast charging and the stock charger supports this feature as well.

    Advantages and disadvantages of Xiaomi Mi4

    Pros of Xiaomi Mi4

    • Brilliant display screen: The viewing angles and sunlight legibility is great.
    • Good camera performance:  Both primary 13MP and secondary 8MP camera performance is very impressive.
    • Excellent performance:  The performance of this device is excellent. The multitasking and gaming performance of Mi4 is exceptional and at par with other high end smartphones.
    • Great Battery Life: The battery life of Mi4 Coupled with fast charging feature, it  is much better than many other smartphone in the segment.
    • Great value for money

    Cons of Xiaomi Mi4

    • High SAR value: The SAR value of Xiaomi Mi4 is 1.360 W/Kg which is very high compared to other smartphones. If you are a health conscious, then you need to take this into consideration.
    • Color rendering of the screen is not accurate:  The colors in the display look vivid and great. However, colors doesn’t look natural even if we set Saturation level to Standard.
    • Indian 4G band is supported: Though it has 4G support, it is not compatible with Indian 4G bands.
    • No expandable storage: The device does support adding additional storage through microSD card.
    • No NFC: This is one features which was present in Mi3 and omitted in this model.
    • Average Speaker: The mono speaker of Mi4 does not provide loud output.

    Xiaomi Mi4 Specification

    • 2.5GHz Quad core Snapdragon 801 CPU with Adreno 330 GPU
    • 3GB of RAM and 16/64Gb internal storage
    • 5 inch IPS  capacitive touch screen with full HD resolution
    • 13 MP primary camera and 8MP front facing camera
    • 2G, 3G, 4G, WiFi, Bluetooth and USB
    •  3000 mAh battery.
    Xiaomi Mi4
    8 / 10 stars
  • Ulefone Be Pro Pros and Cons Review

    Ulefone Be Pro 5.5 is affordable Dual sim smartphone phablet with 4G capability. The large 5.5 inch screen with 720p resolution coupled with good performance makes this one of the best option to buy in this segment. The price of  Ulefone Be Pro 5.5 is $169.99. For all the readers of our blog, there is a special discount offer of $25 is available. For availing this, use the promotion code BePro if you are  buying this from gearbest.com.

    Ulefone Be Pro 5.5 is powered by 1.5GHz Quad core CPU which is based on 64-bit ARM cortex-A53 with MTK6732 chipset. It also comes with ARM Mali-T760 GPU @ 695MHz (400% more efficient than T604) based on cutting edge Midgard (3rd gen) architecture and 2GB of RAM.

    Ulefone Be Pro Android Phablet
    Ulefone Be Pro 5.5

     

    Ulefone Be Pro sports 5.5 inch IPS OGS capacitive touch screen with screen resolution of 1280×720 which results in a pixel density of 267 which is decent. The viewing angles, colour reproduction and sunlight legibility are acceptable. Only con of the display is it does not have the Corning Gorilla Glass protection. So you need to have a screen guard to prevent the screen from attracting scratches.

    Ulefone Be Pro houses 13MP Sony IMX with f/2.2 aperture primary camera with LED flash and autofocus. For Selfie lovers, there is a 8MP front facing camera which can also record videos at good resolution. Coming to storage, it has 16GB of internal storage and supports microSD card upto 64GB.

    Connectivity features of Ulefone Be Pro are 2G, 3G, 4G,WiFi and Bluetooth. This device also supports USB tethering and WiFi hotspots through which you can use Ulefone Be Pro as modem. The Dual sim Android phablet comes with 2600 mAh battery and runs on Android 4.4 Kitkat which will get Android 5.0 Lollipop update according the company.

    Advantages and Disadvantages of Ulefone Be Pro

    Pros of Ulefone Be Pro

    • Decent performance
    • Reasonably good camera performance
    • Good connectivity options
    • Good display screen

    Cons of Ulefone Be Pro

    • Out of the box, there is no Android 5.0.
    • Screen does not have the corning Gorilla Glass Protection.

    Ulefone Be Pro Specification

    • 1.5GHz Quad core CPU based on Mediatek chipset and 2GB RAM.
    • ARM Mali-T760 GPU
    • 5.5 inch IPS OGS capacitive touch screen with screen resolution of 1280×720
    • 13MP Primary camera and 8MP front facing camera
    • 2G, 3G, 4G,WiFi and Bluetooth
    • Dual sim and Android 4.4 Kitkat
    • 2600 mAh battery

    For all the readers of our blog, there is a special discount offer of $25 is available. For availing this, use the promotion code BePro.

  • How to Create Pie of Pie or Pie of Bar Charts in Excel

    The Pie charts well known for representing size relationship between the parts and entire thing. For example, if a company has multiple units, if you represent the profit of each unit in Pie Charts, it shows profit per unit in percentage. Sum of all slices/units is the total profit of the company.  Sometimes, we have the data where some slices are very tiny because of small values which something look like below image. In this scenario pie of Pie or Pie of Bar charts are useful.  Let us see how to use Pie of Pie charts in Excel.

     

    Pie-Chart-in-ExcelHow to use Pie of Pie Charts in Excel

    Pie of Pie charts in Excel is used to represent separate  tiny slices from the main Pie chart and show them in additional Pie charts. Let us see how to Pie of Pie charts in Excel with an example.

    1: Select data for which you want to Draw Pie of Pie or Pie of Bar Chart.

    2: Go to Insert-> Pie and select Pie of Pie or Pie of Bar Chart.

    Sample data for Pie of Pie Chart

    3: You will get the chart as shown below. Now you can add the data labels to the charts which looks like below.

    How to customize Pie of Pie or Pie of Bar Chart

    4.By default, Pie of Pie charts in Excel takes some values. You can customize which type of values to moved to the additional chart. For this right click on the chart and choose Format Data Series from the menu.

    Sample Pie of Pie Charts in Excel

     

    5. In the Format Data Series dialog, click the drop down list beside Split Series to choose what you want to set the value you want to display in the second pie or bar. You can set Value or Percentage or Position. In this example, I have chosen the less than 10% percentage.  The position will be useful if you want to move a specific set of series to second pie.