Android Soultions

Formatting Indian numbers in Excel

2020-07-31T04:14:00.000-07:00

Formatting Indian Lakh and Crore numbers into Microsoft Excel

So, you are working on a excel sheet and calculating the amounts for a client. But the problem is everything you are asked you have to check the commas to convert the millions into crores.

It's a big hassle and a problem if you make a human error, luckily you can convert it into native number formats and this will not only make calculations easy but also look good.

Let's see how

Let's start with a basic number

Right click of the cell and select "Format Cells" or check Ctrl + 1 after moving to that cell

In the format cell window, you will see various options

If you select Number you can format it has a number and select the decimals and commas

But that will give you the numbers in millions and billions

to convert to Indian system do the following:

in format cells select 'Custom'

In the type cell delete whatever is written and paste the code given below

[>=10000000]##\,##\,##\,##0;[>=100000]##\,##\,##0;##,##0

and press enter

Now you will see that the number have changed to Indian format

If you also want to add decimals then use this code in custom type

[>=10000000]##\,##\,##\,##0.00;[>=100000]##\,##\,##0.00;##,##0.00

If you want to add the rupee symbol '₹' as well

use the below formula

[>=10000000]₹##\,##\,##\,##0;[>=100000]₹##\,##\,##0;₹##,##0

for both rupee symbol and decimals use the following code

[>=10000000]₹##\,##\,##\,##0.00;[>=100000]₹##\,##\,##0.00;₹##,##0.00

Now you are done with formatting you number system

Finally, In case your client doesn't want to see such big numbers in and wants you to round them to Cr value so that the numbers are only given as their crore value and decimal.

You can use the below code and paste it in the custom tab in format cell and it will give only the cr value

[>=10000000]#\.0,, "Cr";[<10000000]0\.#0,, "Cr"

And it will give you the lakh and crore values in rounded figures with decimal in place

Through this method you can easily convert all the figures into Indian number system format as per your needs.

PocketCHIP in 2019, a good idea?

2019-01-11T22:41:00.000-08:00

PocketCHIP is a product from Next Thing Co that is like a case for CHIP the single board computer, which include a battery, touchscreen, keyboard and a obviously the CHIP SBC itself.

When you buy a PocketCHIP you get an customized Debian preinstalled on the CHIP which provide a practical user interface for the hardware.

Now first thing first, Next Thing Co is now defunct and that is a problem, as its a full pledge Linux computer with a terminal.
Being a Linux operating software you would want to use the terminal and obviously download new software with apt-get as well as get updates.

This is a problem as since the Next Thing Co is now defunct their repositories are now dead, so you can't get that updates or new software for PocketCHIP.
Particularly if you want to update PICO-8 that comes preinstalled, without updating you are not able to run the new PICO-8 games from the forums.

PICO-8 is a fantasy console for playing and developing 8-bit games, if you want it you have to pay $15 for windows, mac or linux. You get it free with PocketCHIP and moreover you can download games directly onto your PocketCHIP from your Linux terminal through apt-get like chocolate-doom or prboom and many more.

So how you can fix the issue with you repositories, well there are some mirror repositories that you can use to fix this issue.
Now it is not ideal as in the long run the repositories may get outdated, but for now it has the latest packages till the Next Thing Co's last update.

So there is a mirror repository at : http://chip.jfpossibilities.com/chip/debian/

You can edit your repositories from you terminal by running these commands:
(Check the original post for this solution at https://www.lexaloffle.com/bbs/?tid=32715)
sudo nano /etc/apt/sources.list
## Paste stuff from that post; save
sudo nano /etc/apt/preferences
## Paste stuff from that post; save
## Then, check for updates and install them
sudo apt-get update
sudo apt-get upgrade

So all in all there are certain problems with the PocketCHIP but it is still a novelty item that is worth buying if you want to play around with it.

If you can get your hands on one of these then that is up to you, if you can spare money and time for a handheld gameboy like Linux terminal system.

You can check my video where I talk on the same as well as give my view on PocketCHIP.

Let everyone know if you know some other mirror repositories or better things to do with PocketCHIP.

Leave your comments below and thanks for reading.

Android Mobile internet settings APN

2011-09-07T06:13:00.000-07:00

Android OS APN settings

Android OS APN settings or internet settings usually automatically appear in configuration as soon as you insert your sim card and switch on your phone.
However sometimes these settings does not appear automatically, and unlike your Symbian OS phone, like your Nokia, these setting may not be configured by sending an sms request to your service provider.

What you do in that situation is that you can set them up manually, here how:

Firstly take out your sim card(which you are use with your android phone) and place it in a normal Symbian(Nokia) or Bada(Samsung) phone, then request the internet settings from your service provider like you normally do by sending an sms, once you receive them install them.

Now you need to go to internet setting/browser setting in your normal phone look for profiles, these are your internet settings. There you will see the settings for example if you use vodafone then you will find Vodafone Live or if you are using aircel you will find Pocket Internet or for airtel you will find airtel live and etc etc etc This settings are called APN which is short for Access Point Name. These are your internet settings, there will also be some GPRS settings and MMS setting, like Mobile Office for airtel, AircelGPRS for sircel, etc etc etc.
Note this setting are at different places on different phones, you may need to look around in your phones settings to find them.
To run internet only internet APN setting are required but if you want to run GPRS services like using internet for other programs or apps on your phone(which is required for an Android OS) you need GPRS settings.
And so you need you MMS setting if you wish to send and receive MMS.

Now need to go to edit option here you will find the details of settings like
Access name/APN name
Set name/profile Name
proxy/proxy address
port

Write all these setting on paper.
(Note there will be other things as well like username, server, etc. You don't need to copy that)

Now take out the sim card and place it into your android phone, once started go to settings, there you will find Wireless & Networks settings here look for mobile networks. Inside you may find GSM options here click on it and you will see an option called Access Point Names or simply APNs(or inside mobile networks you will find Access Point Name). Inside this option, click on menu button and then click New APN.

Now here you will see the same thing you saw in your regular phone Name, proxy, APN, Port, etc fill in the details that you wrote on paper and save.

Now run your browser, I guess it will work fine now.
Also set up your GPRS settings also because without it your internet based apps won't run on mobile internet.

Now you are ready to enjoy the wonderful world of Android phones

Enjoy!

This blog is about:

Mobile Internet, Vodafone APN settings, internet through mobile phone, mobile for internet, gprs internet settings, mobile phones internet, vodafone live apn settings, internet through cell phone, quick settings android, Internet settings android, vodafone mobile internet APN, Vodafone internet APN, internet connection help, android internet help, android APN help, WAP set up, WAP setting, aircel APN settings, aircel android APN settings, aircel internet settings, aircel mobile internet, idea APN settings, idea internet settings, idea android apn setting, idea android internet, idea android internet settings