Tech2 Touch

Author: Aniruddh

  • Nokia non camera dual sim mobile pricelist

    Nokia is has lot of dual sim models. However only some dual sim mobiles do not have camera. If you are looking for non camera dual sim mobiles from Nokia here is the quick list. Having good dual sim camera phone provides few advantages in certain situations. For example, some companies, do not allow carrying a phone with camera inside office premises.

    Having dual sim option is one of the essential requirement in India. This is due to the cellular signal availability and cost of call charges.  Whatever may be the reason, if you are looking for a dual sim feature phone without camera, then here is the list of Nokia Phones which do not have camera.

    Nokia non camera dual sim mobiles

    There are few phones which do not have camera.

    Nokia 130 Dual sim

    Nokia 130 has 1.8 inch QQVGA LCD  transmissive display with 160 x 128 pixels resolution, 114 ppi pixel density and 64K color support. It runs on Nokia Series 30+ operating system and supports microSD card upto 32GB. It has 1020 mAh lithium-ion battery. Nokia 130 Dual sim price in India is around Rs.1,699.

    Nokia 130 Dual sim Features

    • 1.8-inch (4.57 centimeters) QQVGA LCD Display.
    • Nokia Series 30+ operating system.
    • microSD card support upto 32GB.
    • 1020mAH lithium-ion battery.
    • FM Radio.

    Nokia 101:

    Nokia 101 quick specs:

    • Dual SIM (GSM + GSM)
    • 1.8-inch TFT Screen
    • Alphanumeric Keypad
    • FM Radio
    • 16GB expandable memory
    • 6 hours of talk time and upto 610 hours(25 days) of standby time

    Nokia 101 price in India is ₹1445
    Nokia X1-01:

    Nokia X1-01 quick specs:

    • Dual Standby SIM
    • 1.8 inch TFT Display
    • FM Radio and Music Player
    • Speaking Alarm Clock
    • 16 GB expandable memory
    • 13 hours of talk time and upto 1032 hours (44 days approx) standby time)

    Nokia X1-01 price in India is ₹1920.

    Nokia 101 and Nokia X1-01 ared very difficult get in the online market. There may be chances of availability in your local stores. Nokia 130 dual sim is available on amazon india and paytm sites.

  • Write Rupee Symbol using Keyboard Keys

    Rupee got symbol last year. The font for rupee symbol  is added in Microsoft update. However the manuals do not mention about what are the keys to  use to get  rupee symbol. After searching a lot on internet and manual experiment i got below solution. That is I am able to use rupee symbol ₹ using the key which contains rupee symbol or the keyboards without rupee symbol can use the key with $ symbol. This works for most of the keyboards. Below steps will demonstrate on how to use Rupee symbol (₹). If you want to insert Rupee symbol in Excel, please refer my post on Type  Rupee Symbol in Excel 2010.

    Steps to write Rupee symbol using keyboard:

    • Download the Microsoft driver update which enable the Windows to detect rupee symbol. You can download Microsoft update which supports rupee symbol from here.
    • Download the appropriate version of the update based on your version of Windows.  Once download completes, install the update.
    • In Control Panel, click Clock, Language, and Region, and then click Change keyboards or other input methods.
    • On the Region and Language screen, click Change keyboard on the Keyboards and Languages tab.
    • On the Text Services and Input Languages screen, click Add.
    • On the Add Input Language screen select English (India), and then select the India keyboard check box.
    • Restart the system.
    • Now your keyboard will be able to write rupee symbol.
    • For writing rupee symbol now on wards use Ctrl+Alt+₹(4 or $ on regular key). The Keyboards without rupee symbol, can use Ctrl+Alt+$

    Write Rupee symbol in Dell Laptops

    The method given above works with most of the laptop keyboards and normal keyboards. Recently, I was working on Dell Vostro laptop and above shortcut didn’t worked. In this situation, as mentioned above, you need to change the keyboard layout to India and then use right Alt+$(4). This made me to write rupee symbol on Dell Vostro laptop. Please share you have problems using Rupee symbol in any other keyboards.
    Note:

    • This works with most of the keyboards irrespective whether rupee symbol is present on the key or not. The key with $ will be used to write rupee symbol.
    • Once the rupee support update is installed, we can use rupee currency in excel sheets to as currency format.
    • The using above method to type Rupee symbol using Keyboard key worked well with Logitech Keyboard and Dell Laptop keyboard.
    • Same combination of keys will type rupee symbol in MS Word, Excel or any Microsoft Office documents.

    Incoming Search words:
    Type Rupee Symbol in Keyboard
    How to Type Rupee symbol in Keyboard
    Type Indian Rupee Symbol on keyboard
    Type Rupee Symbol in Dell Keyboard
    Type Rupee Symbol in HP Keyboard

  • Equations in Blogger | CodeCogs Equation Editor

    There are many situations where we need to write equation or quotes of some one in blogger. So writing the formulas with super script in blogger needs little coding. The detailed step by step guide to write equation in blogger is given by codecogs.com.
    To use the subscript and superscript in blogger, we need to take the help of Latex script. To install this script follow the instruction given below.
    Steps to Write equation in Blogger
    Step1:  Open Blogger.com and login.
    Step 2: Go to Layout from the drop down list menu underneath the “More Option” Button.
    Step 3: Within the manage Blogs section, select Design.
    Step 4: On the right hand side, click Add a gadget.
    Step 5: Select the ‘HTML/Javascript’.
    Step 6: Before entering the following text, make sure that you are in ‘Edit HTML’ mode(you are in that mode when that ‘Rich Text’ title is showed in upper right corner), enter the following text into the ‘Content’ area:

    Now select ‘Save’ and exit.Before entering the following text, make sure that you are in ‘Edit HTML’ mode(you are in that mode when that ‘Rich Text’ title is showed in upper right corner), enter the following text into the ‘Content’ area:

    Now select ‘Save’ and exit.
    This script is made to work only convert equations within the …
    and
    You might me thinking why equations found anywhere are not converted, this is dangerous because other scripts may place javascript within your page, which might also contain ‘$’. In particular if you use any jQuery scripts on your page then you’re likely to experience problems.
    Note: If you are using the Dynamic view templates of blogger then, you need to add following script on the end of post while composing in HTML mode.
    Equations in Blogger | CodeCogs Equation Editor:

    Note: Writing equation sin wordpress is very easy. You just need to enable Beautiful Math in jetpack. Using that module you can easily type equation in wordpress blogs.

  • Using Ubuntu Classic Desktop in Ubuntu 11.10

    Ubuntu 11.10 automatically  uses Unity as default session and fall back to 2D for the systems which do not have 3D graphic controllers. To use Ubuntu Classic Desktop(GNOME), you need do little tweaking.

    Steps to be followed to use Ubuntu Classic Desktop(GNOME) in Ubuntu 11.10

    • Open the terminal.  To open terminal, keyboard shortcut is Ctrl+Alt+T
    • In terminal, type sudo apt-get install gnome-session-fallback
    • On completion of installation, restart or log off
    • While logging in back choose GNOME Classic
    • Enjoy the Gnome Classic Session.

  • Creating Templates in Excel

    Excel templates are very useful whenever we need to do repeated tasks. Excel VBA does it. But Excel VBA is a little hard to learn and implement.

    Excel templates is nothing but pre defined format. For example if you want to get Agent productivity report in Excel. You have raw reports which has productive hours, non productive hours and other details. Instead of doing every day look up and sum function, create template. That create a new sheet.  In that put all the fiormula or excel functions and required data. So now onwards whenever you need to do the report, just put the raw reports you will get output immediately.

    Advantages of Excel Templates:

    • Saves lot of time
    • Accuracy of the reports increases as manual work is reduced
    • No need to know complicated VB codes.
    • Get time explore new things
    • Do more analysis on data.
    Useful functions and tools to create Excel Templates: Below are minimum Excel formula you should know to create a simple and effective excel templates.
    • Pivot tables: This is one of the tool very useful. You can customize the data the way you want to. Create calculated fields in pivot table to enhance the look and get more data.
    • Vlookup and Hlookup functions: These lookup functions will be very handy while you need to map some fields based on some data criteria. 
    • Conditional sum and count:  Conditional sum function sumif and conditional count function countif are useful when you need to count or sum of the data for a particular data.
    • Multi conditional sum and count: There are many occasions we need to find sum or count based on multiple criteria. SUMIFS, COUNTIFS and sumproduct are the useful functions
    Tips on Creating Excel Templates:
    • Always create a template such a way that, the output of the template matches with desired report format. Do not give a scope for manual work on template on regular basis. This will save time.
    • Use Conditional functions to get ride of error codes such as #n/a.  For this IF function with iserror function will be very useful.
    • While selecting the range, select only the range you have data. Do not select complete sheet. Selecting whole sheet will slow down the template. Using Dynamic ranges will also helpful.