Monday, 10 September 2018

Renault Duster Modification | getting the USB power concealed

I was looking forward to have my USB power wires to be concealed, for a while now. I normally use power cables for the mobile and the DashCam charging. But as you can see below, its wires running through the dashboard and were cluttered.  Sometime its not good to have them like that when you drive as it can be distraction.

This is after the modification. Top left is the input for the DashCam and Top right is for the mobile.

What you need for the Mod:
1. Fuse Tap  (Ordered from Amazon)
2. Fuse (Small red item) with proper rating, say 5 Amp.  I purchased from local shop.
3. Dual Port USB Car Adapter (Ordered from Amazon
4. 2 USB cables

5. Multimeter to identify the fuse to be connected to
6. Soldering Iron and Solder


1. Identify the fuse port to be used. Fuse box next to the passenger compartment on the left of the dash and you will see it when you open the door. You need a port that gets power only when the key is engaged.  Many ports are live even without even the key engaged. Look for the correct port.  Make sure that the fuse tap is engaged in the orientation in which the power comes through the Fuse.  Check by removing the fuse tap, if the power gets disconnected. otherwise, you will have to reverse the fuse tap orientation.

2. identify the location for the USB Adapter to be placed.  I chose the central light console area.  

3. solder the wires to the adapter.  Center pin is the +ve which has to be connected to the fuse tap.  side pins are negative which has to be connected to any part of the body.  decide the cable length accordingly.

4. Pull the +ve cable to the Fuse box through the top and through the side pillar.  I ran the -ve upto the screw thats used for the sun visor. then the 2 output cables were also routed to the locations needed.

Now I am wireless :)

total time spent : ~ 2.5 hours including soldering

Wednesday, 14 December 2016


Most of us know how to change case before we type a text. But how to change case of a typed text from small-caps, ALL-CAPS, Initial-Caps? It's easy..

* Double tap to select text. Use arrows to expand selection as needed.
* Use the ⬆ arrow on the keyboard to cycle through each option.

Simple, isn't it.. share if you liked it..

Saturday, 21 May 2016

Focus Stacked Bug

Today morning, my son found a dead bug with bright colors around our home. Suddenly I realized the opportunity for a stacked photo and swung into action. I wanted to do it for a while and this was good chance before the colors go away. below are couple of selected ones.

Friday, 13 May 2016

First Focus Stack using automated Rail

I tried to do the real stack using the automated setup. Below is the picture of the final image. Because of the shallow depth of field, I had to do a stack of 64 images to cover the scene. This is next to impossible to do manually. To put things in perspective of the magnification, I have added a hair as well in the frame.

Wednesday, 4 May 2016

Focus stack automation - Rail Integration

As posted last time, I had received the rail. I have it integrated now. Also, i have implemented the camera triggering aspect. I am using opto-isolator for that. I got it all put together. Now I can use it for taking photos as expected. Here are some pictures of the setup.

Wednesday, 27 April 2016

My first Focus Stacked Macro Image

While I am trying to make the automation to do the focus stacking, it is also important to try out the stacking manually.  Today I did my first ever macro focus stacked image of a flower.

Setup: three extension tubes (36mm + 20mm + 12mm = 68mm) and reversed 50mm lens.  This gives a 2:1 macro (double size) image.  Here is the setup and the result.  Its a stack of 10 images done in photoshop.

Saturday, 23 April 2016

Focus Stacking Automation, First proto is ready

Hi there,

I have an update on the project. I was able to, at last, make everything into a prototype mode. It is working and getting into some shape.

Thursday, 21 April 2016

Aurdino for macro stacking - testing the water

I had ordered some of the necessary elements and have started to do some of the basic stuff with each. I am yet to get the rail itself and it may take some more time. But for the testing I have just connected two wheels to the Stepper Motor.

What I have now:
1) Aurdino Uno
2) Stepper Motor
3) LCD Display, 16x4
4) Keypad, 4x4
5) Easydriver for Stepper Motor
And accessories like Breadboard, Jumper wires, multimeter..

Friday, 1 April 2016

Starting with Arduino.. Its exciting prospect.

Recently I came across a post about developing a automated focus stacking. It uses and Arduino based controller at the heart of it.  You can then program the Arduino appropriately. I have had no experience with Arduino. But I have decided to do one myself.  So watch this space for more updates..

Monday, 25 January 2016

Collated this data for my own understanding. Sharing it as others may find it useful. Although care is taken for accuracy, cannot guarantee it and please check yourself before deciding.

Thursday, 25 March 2010

Remove the external links from an Excel File.

Sometimes its so happens that when you open an Excel file, it asks if the External Data needs to be updated or not. But you may not have intentionally given any external links. It’s an irritation then. But How to get rid of it?

Thursday, 18 February 2010

Excel Function :TABLE

Its been a while since I have done some posting. This option in excel is something which I thought would be very useful for many.

Its the TABLE Function in MS Excel. This is especially useful in the following scenarios.

Saturday, 14 November 2009

Treeview Structure in VB.Net

In this post, we will look at how the Treeview can be used.

I am using Visual Basic 2008 Express Edition.

In one of my earlier posts, I had explained in detail about Treeview in Excel-VBA. Through this post, I would like to bring the VB.Net way of the control.