Skip to content

Binary <-> Decimal Conversation Calculator in Google Sheets

2016 February 14

I  was going through my old engineering days during late night party with geeky friends. And we ended up with quick Binary <-> Decimal Conversation Calculator.  It has reminded me one subject called Digital Electronics. I was pretty bad at it, but there was interesting stuff, which i remembered right now, Binary <-> Decimal Conversation and how it is utilize by computers for In/Out of any characters from Disk, of course with help of encoding methodology (ASCII / UNICODE / …). Same time, I encountered with great teaching of the same by one of the great Professor over the INTERNET and it has encouraged me to designed Binary <-> Decimal Conversation Calculator in Google Sheets, rather then i pulled out my programming expertise to design one.

And see, here is the outcome of the same. Thanks to my INTERNET friends. Feel free to enjoy, Drop your comments if you need copy of the same.

Binary <-> Decimal Conversation Calculator in Google Sheets [1].


PS: Of-course, it has enhanced my Google Sheets Formula Developing skills and that was my subTarget 😉

Make Me Glow – Control PiGlow from Ubuntu Phone

2015 October 21
by Hardik Dalwadi

Recently i have written blog about assembling Ubuntu Orange Matchbox (Ubuntu Branded Pibow for Raspberry Pi 2 & PiGlow) & Demonstration of Snappy Ubuntu Core with it.

Now with Make-Me-Glow LP Project, we have built an application for controlling PiGlow from Ubuntu Phone. The PiGlow is a small add on board for the Raspberry Pi that provides 18 individually controllable LEDs. Recently Victor Tuson Palau has released glowapi for Snappy Ubuntu Core, which will allow us to control PiGlow over HTTP Protocol.

We decided to build quick Ubuntu Phone application to control  PiGlow during Ubuntu Hackathon India using glowapi for Snappy Ubuntu Core. As a result of this, we came with Make-Me-Glow LP Project. Big Thanks


What It Does:

It will allow you to control any LED of PiGlow from Ubuntu Phone. You have to  download “Make Me Glow” application from Ubuntu Phone Store. For example, if you want to On/Off Orange LED on Leg 1 with specific Intensity on PiGlow, Make Me Glow UI will allow you to do the same. Just make sure that you have to enter correct IP address of your Ubuntu Orange Matchbox (Ubuntu Branded Pibow for Raspberry Pi 2 & PiGlow). We are assuming that you have already installed  glowapi for Snappy Ubuntu Core on your  Ubuntu Orange Matchbox (Ubuntu Branded Pibow for Raspberry Pi 2 & PiGlow)

How It Does:

As i said erlier, we are using glowapi for Snappy Ubuntu Core which can operate PiGlow according to HTTP Protocol POST request.  We are issuing POST request over HTTP Protocol from Ubuntu Phone Application – Make Me Glow as per user configuration and PiGlow does operate accordingly. We have written simple QML function for the same, which request URL using POST over HTTP  according to user input. It is very very easy to develop Ubuntu Phone Application using Ubuntu SDK. Big Thanks to XiaoGuo Liu, without it would not be possible to execute this project.

function request(url) {
var xhr = new XMLHttpRequest();‘POST’, url, true);

Future Roadmap:

We are working on few animations. In fact  i have already made the proof of concept using bash script, like Fan &  FadeOut animation with bash scripting. If you want to contribute for the same please visit Make-Me-Glow LP Project.


Goal behind this demonstration is to defined immense possibility of Snappy Ubuntu Core to control devices remotely, within Ubuntu Ecosystem. If you are planning to dive in to IOT based solutions, Snappy Ubuntu Core is great start for you. After this demonstration, I am planning to control my Home Lights connected to device running Snappy Ubuntu Core and controlling the same through Ubuntu Phone.  Stay tuned…

Ubuntu Orange Matchbox & Snappy Ubuntu Core Demonstration

2015 October 1
by Hardik Dalwadi

In this edition i will demonstrate how to assemble your own Ubuntu Orange Matchbox: Ubuntu Branded Pibow for Raspberry Pi 2 & PiGlow. As shown below.

Ubuntu Orange Matchbox: Ubuntu Branded Pibow for Raspberry Pi 2 & PiGlow.

Basically, at the end of this blog i will demonstrate how to assemble your own Ubuntu Orange Matchbox: Ubuntu Branded Pibow for Raspberry Pi 2 & PiGlow. Flash it with latest Snappy Ubuntu Core, which has support for  Raspberry Pi 2’s GPIO & I2C. I will also managing Snap packages from Ubuntu Phone Browser & Snappy Scope (Beta). I will also share tips & tricks to enable WiFi on Snappy Ubuntu Core. At the end, i will demonstrate Snappy Ubuntu Core + Raspberry Pi 2 + PiGLow in action. PiGlow will blink LEDs, as per the CPU Resource Utilization by  Snappy Ubuntu Core.

We have divided this post in four different part:

  • Make In India: Ubuntu Orange Matchbox: Ubuntu Branded Pibow for Raspberry Pi 2 & PiGlow
  • Install Snappy Ubuntu Core @ Ubuntu Orange Matchbox: Ubuntu Branded Pibow for Raspberry Pi 2 & PiGlow
  • Tips & Tricks to enable WiFi @ Snappy Ubuntu Core
  • CPU Resource Utilization Demonstration @Snappy Ubuntu Core

Make In India: Ubuntu Orange Matchbox: Ubuntu Branded Pibow for Raspberry Pi 2 & PiGlow:

Here are the list of ingredients which i have used to cook my own Ubuntu Orange Matchbox. I have also share the link from where you can procure those stuffs in India.

  1. Raspberry Pi 2 with USB WiFi Dongle  & 5V, 2A USB Power Adapter
  2. Tangerine Pibow for Raspberry Pi 2
  3. PiGlow, It is small add on for Raspbeery Pi that provides 18 Individually controllable LEDs.
  4. Mixed Ubuntu Stickers







Assemble Raspberry Pi 2 with Tangerine Pibow.  Remove white laminate plastic sheet of closing cover of Tangerine Pibow.  This actions will give you transparent Pibow for Raspberry Pi 2.


Now, it’s time to give Ubuntu Branding. Just stick transparent Ubuntu Logo sticker on  transparent Pibow closing cover. You can also install PiGlow before closing the cover.  If you know any laser engraving service provider for metal / plastic, consult them and get your Ubuntu Branding engraving on transparent Pibow closing cover. But my trick will give you Ubuntu Orange Logo 😉


Final Version:


Install Snappy Ubuntu Core @ Ubuntu Orange Matchbox: Ubuntu Branded Pibow for Raspberry Pi 2 & PiGlow:

Recently, Snappy Ubuntu Core get latest updated for Raspberry Pi 2, which has latest updates & upgrades. Please follow this page Getting Started with Snappy Ubuntu Core for Raspberry Pi 2. It is having latest info and procedure to play with Snappy Ubuntu Core @ Raspberry Pi 2. You can even build your own image.

Here is sort summary to do the same. Get 4 Gb Class 10 micro SDHC Card. Format it and flash it with latest Snappy Ubuntu Core image.

# Note: replace /dev/sdX with the device name of your SD card (e.g. /dev/mmcblk0, /dev/sdg1 ...)
xzcat ubuntu-15.04-snappy-armhf-rpi2.img.xz | sudo dd of=/dev/sdX bs=32M

Now, boot your Ubuntu Orange Matchbox with Snappy Ubuntu Core. Default Username / Password is ubuntu / ubuntu. You can manage Snappy Ubuntu Core web store through Webdm, by pointing your browser to Ubuntu Orange Matchbox IP:4200 or webdm.local. Make sure that you are connected to LAN.

Tips & Tricks to enable WiFi @ Snappy Ubuntu Core:

Snappy Ubuntu Core has inbuilt support for Ethernet port, So, connecting your Raspberry Pi 2 to LAN will get LAN IP from Router. Since, this is headless device, you can always do SSH from your host machine if you do not want to connect it with separate monitor.

It does not have support for WiFi. Here are the steps to enable WiFi and add support for USB wi-fi adapter, having Ralink RA5370 chipset. I got this with my Raspberry Pi 2 kit, please check chipset for your USB wi-fi Adapter, you may need different firmware.

Please follow this solution @ Enable WiFi with Snappy Ubuntu Core. You may need to get below package instead of  – wpasupplicant_0.7.3-6ubuntu2.3_armhf.deb

wget -c

I would also prefer to install nano for better modification of WiFi SSID configuration in future. Get it from here.


CPU Resource Utilization Demonstration @ Snappy Ubuntu Core:

Now, it’s time to demonstrate CPU Resource Utilization through PiGlow.  It is small add on for Raspbeery Pi that provides 18 Individually controllable LEDs. We will feed CPU Resource Utilization such a way that it will glow more when we have more CPU Resource Utilization. As i said erlier, recently we got GPIO & I2C support on Snappy Ubuntu Core, it is possible to do the same. And we have snap package available from the same, called PiGlow Top.

Access your Snappy Ubuntu Core from WebDM or CLI through SSH and install PiGlow Top snap available from Snappy Ubuntu Core Web Store. After installation, we need to grant access to I2C hardware, do the same over SSH.

sudo snappy hw-assign piglowtop.kyrofa /dev/i2c-1

Now it’s time for the demonstration, grab your Ubuntu Phone, access the Snappy Ubuntu Core Webdm from your Ubuntu Phone Browser, Do some activity to increase CPU Utilization, for example Install / Remove any snap from Snappy Ubuntu Core Web Store. I have prepared small video Demonstration for your reference.

Make In India Your First Ubuntu Phone

2015 March 10
by Hardik Dalwadi


Finally, First Ubuntu Phone has been launched by Canonical / BQ in Europe. Ubuntu fans are excited to get the one, but before i share how to get / make your own in India, here are couple of news posts in Indian Media about First Ubuntu Phone launch.

Canonical Launches First Ubuntu Phone With Spain’s BQ

World’s first Ubuntu phone set to go on sale

First Ubuntu phone is ready for launch

Also, I am getting random e-mails, pokes, tweets, messages on how to get First Ubuntu Phone in India. Ubuntu Fans & Community is very excited about Ubuntu Phone. In fact there was question on , asking..

Ubuntu phone release in India


And, all those have put me in situation to write  this blog post. It is very easy to make Ubuntu Phone in India. Here are my steps, how i did it for me. In fact, i am using Ubuntu Phone since 2013, it’s first development release. 

1. Get One Nexus 4 Device, If you have it then you are almost done.

2. Flash it with latest Ubuntu Phone build, there is detailed how-to for Installing Ubuntu Phone Build on Ubuntu Developer Wiki, just follow it.

3. You can convert you Nexus 4 with Ubuntu Phone, by customized Nexus 4 Skin with Ubuntu Logo & your desired slogan for the same. I have done the same using 

4. Synchronize your contacts / calendar’s invitees & e-Mails from you existing Google Account & That’s it you are ready to use your Ubuntu Phone.

4. Now, Make your first Call from Your Ubuntu Phone…

Here are photos / screen shots of my First Ubuntu Phone In India … Make In India 😉



5 Minutes Cloud Recipe with Ubuntu Cloud Live 12.04

2014 January 1

Have you ever think of baking your own cloud within  5 Minutes? Have you ever think of Elastic Compute (Nova-Compute) within 5 Minutes?  Have you ever think of Elastic Storage (Nova-Volumes) within 5 minutes? Have you ever think of your hands on Open Stack Dash Board (Horizon) within 5 Minutes? Now you should think of it. With release of Ubuntu 12.04, It’s time for Ubuntu Cloud Live 12.04.  Ubuntu / Canonical  has released Ubuntu Cloud Live 12.04, Hybrid Image, Burn on your DVD , CD or USB Stick, you can say Cloud On DVD, Cloud on Stick, Yes, it’s as easy as you reading this.

Ubuntu Cloud Live is a live CD/USB image that allows you to get a glimpse of Ubuntu Cloud Infrastructure. Project’s web site is located at Launchpad – Procedure is very simple; download an image, burn it on CD or dd it on the USB key and boot of that device. System will boot in Unity or Unity2D and present you with at Getting Started document. Notice that we do not include full Ubuntu desktop experience – we’ve removed all components that aren’t necessary for this project, to make image as small as possible.

Once you finish with Getting Started document, you’ll be able to log into the dashboard and start instances. All of this without installing anything on your computer! For the purpose of demo, we’ve provided a small CirrOS image which you can run and log in to. Since everything is running in RAM, you will have better experience if your system has 4 or more gigabytes of memory. 2GB is enough to get system booted, but you won’t be able to do much more after that.

For a little extra, we’ve configured Ubuntu Cloud Live with support for Nova Volume. All you have to do is plug in additional disk, create a PV volume on it (pvcreate /dev/xyz), create nova-volumes VG (vgcreate nova-volumes /dev/xyz) and restart nova volume (service nova-volume restart).

Image is built with live-build and the source is available on Launchpad. Build process pulls in one package that’s also available on Launchpad. Procedure for building your own Cloud Live is very simple:

  1. Install Ubuntu 12.04, 64bit
  2. Install live-build package
  3. Create working directory – mkdir ~/cloud-live ; cd ~/cloud-live
  4. Branch bzr code – bzr branch lp:cloud-live config
  5. [OPTIONAL] Customize config/* files
  6. Build an image – sudo lb build
  7. Burn or dd resulting image – binary-hybrid.iso

Or, if you just want default, official, Ubuntu Cloud Live image, go to and grab it!


Update / Observation:

I have found that, since Red Hat came up with Red Hat OpenStack Administration (CL210), lot of students in India/ My City are struggling to see working OpenStack Demonstration, and even for the they enrolling to this course. Even trying hard with Fedora and spending whole day. So, i am posting this article  for students to create Open Stack Based Cloud within 5 Minutes, for the demonstration and understanding of Openstack & Cloud Computing.