Tuesday, April 21, 2020

Use Camera Tool to create linked images in Excel2016

Combining Cells without losing data in Excel

How to add Images and background in Excel Spreadsheet

Taking ScreenShot in Excel

Finding Duplicate data in Excel spreadsheet

How to use Speak on return option in Excel 2016

Using Split Screen option in Excel to see your data

Building Dashboard in Excel

Using Macros in Excel

Using Watch Windows in Excel

Using CheckBox in Excel

Excel Data Entry Form

Ifs statement Excel 2016



Excel Alignment Options Tutorial

How to use the Excel Count and CountA functions

Navigating through an Excel Spreadsheet

Excel What-If Analysis: How to Use the Scenario Manager & Goal Seek

Creating and Linking Shapes to Data in Excel

Print Options in Excel: Tips & Tricks

Making a Simple Bar Graph in Excel

Using the Quick Access Toolbar in Excel 2016

How to create an 'if then' statement in Excel

Data Validation and Drop-Down Lists: Excel 2016

Saturday, November 26, 2016

Surface Pro 4 Laptop Review

By the way, because Surface PRO 4 has touch screen, you may use it as Point of sale application as well.

Saturday, June 25, 2016

Tuesday, September 15, 2015

Friday, July 3, 2015

How to make your own POE injector:

 Why I posted this blog on an insignificant device like POE Injector:

Coming from an R&D background, I know the value of good tools and peripherals and I don't mind spending my hard earned dollars on them. But I hate to waste money when the cost of a device can not be justified. The same is true for POE switches. It is shocking to see that cost of a POE switch is approximately 4 to 5 times higher than normal Ethernet switch. And with umpteen numbers of POE devices coming in the market everyday, these vendors are minting money because an average Joe doesn't know what he is paying for.
If that was not enough, a few companies came up with the concept of POE injector. Well, if you have this device then you can use normal switch and feed power to your POE device using this POE injector. Again, if you see the cost, you will be spending somewhere $35-$40 per POE device.

I decided to do some research on the subject and the result was mind boggling. I tested my findings on an actual POE camera and eureka!!! it worked. So this will be saving me at least $10000 per year by not buying POE switches. Well, yet again it is proven that we Kiwis have DIY in our DNA.

Anyway, let us come to the main topic of how to make your own POE injector. Now onwards, I will not be gossiping like above and promise you to be as to the point as possible. So, let us begin!!!

1) RJ45 Pin configuration:
RJ45 pin configuration varies from region to region and in New Zealand we follow 568A which is as given below. You can google to find RJ45 pin configuration for your region. Conceptually, it won't make any difference.
Now, out of the total 4 pairs, 2 pairs are used for data transmission and two pairs remain unused. In 568A, pin nos. 4,5,7 and 8 are unused. Commercially available POE injectors make use of these unused pairs. Believe me, there is no electronics involved.
So, while crimping your RJ45 connector, leave 7 and 8 out of the connector and crimp the remaining 3 pairs. You can choose to use 4 and 5 as well but practically I have found that crimping becomes easier if you drop out the last pair. Also, if your device takes more power and cable runs longer distance, you may decide not to crimp 45, 7 and 8 and use one pair as positive and the other pair as negative.

2) Do not reach a conclusion unless you have tried it:
So now, we decided to try it. We made a patch cable where we did not crimp 7 and 8 pins and connected these two wires to a DC plug as required by our camera. It looked like below:

Then, we connected a normal Ethernet Switch with our IP camera giving power on extra brown and white/brown wires.

And then we configured our IP camera with these connections and you can see below the camera output on the screen.

2) But what if the POE device doesn't have a power input:
 Well, you are stuck if this is the case because then you will have to use POE switch because unlike POE injectors, POE switch uses data signals to give power to the POE devices. Data signal is modulated over power by the POE switch and it is demodulated at the POE device's end. So, if two cameras have exactly similar specs and have the same cost, but one has separate power input and the other doesn't, then the camera with the power input will cost you less because in that case you will save money by not using the POE switch.
You may watch the video below if you prefer watching over reading...

 Finally, do not forget to thank me if you really save a few dollars as a result of my post.

Also, Do you want to learn how to crimp an RJ45 Connector? Watch the video below:

Monday, June 22, 2015

Saturday, August 2, 2014

Belkin Core Laptop Backpack Review

Why choose Belkin Laptop Backpack Core ?

Belkin Core Laptop Backpack

  Belkin is a well known name in computer industry for providing computer and networking accessories and because they understand the requirements of computer professionals, their gadgets are always well thought. Belkin Laptop Backpack Core is another feather in their cap where they provide very very economical solution to carrying laptop in this elegant looking compact backpack. This Belkin laptop backpack Core is suitable for 15.6" laptops and has a few very good padded compartments to store accessories like mouse, pen drives, business cards etc. It is available in black and gray colors. Its shoulder strap is quite comfortable to carry it. It is made using neoprene material. (Actually, I am not aware of this material but as per the reviews, it is very light but durable material). It is really one of the lightest backpack available and if your requirements are pretty basic, then this super economical backpack is just made for you.

Its popularity can be gauged by the fact that it has been reviewed by 254 customers and most of the reviews are very very positive. The customers knew what they are buying and they were quite satisfied by the product. 
Belkin Core Laptop Backpack

Salient Features Of Belkin Laptop Backpack Core:

  • Dimensions: 18 x 14.5 x 4 in

  • Shipping weight 1.4 pound but actual backpack weight is just 1.0 pound. Super light.

  • Suitable for 15.6″ laptop or notebook.

  • Made of light but durable material Neoperene

  • You have 2 color choices black or Gray.

  • Has a comfortable padded shoulder strap

  • Gives you a few divided pockets to store accessories.

  • Comes with removable pouch to separately keep power supply, power chords etc. 
Romance With Art

Saturday, November 24, 2012

Friday, December 30, 2011

Screen Recorder Software: Camtica

Screen Recorder Software

Camtica enables you to create professional screen recordings, presentations, tutorials and more. You can record any desktop activity with voice, webcam and animated mouse clicks. The resulting video can be saved in various formats including AVI and WMV.

Why do you need Camtica?
* To create professional screen recordings, demonstrations, presentations, screencasts, tutorials and more
* To generate effective videos that help you train, teach, sell and more
* To create demonstration videos for any software program
* To show customers how to use your product
* To create on-demand interactive training, tutorials for school or college class
* To create a set of videos answering your most frequently asked questions
* To share your recordings on YouTube, Screencast.com and other videos sites

* Records entire desktop, selected rectangle region, dynamic region around mouse cursor, webcam
* Records anything on the screen including windows, objects, menus, full screen and rectangular regions
* Records desktop screen with audio and webcam together - personalizing your videos by including a webcam movie of yourself over * your desktop at any position
* Records video chats, Skype video calls, games, flash movies played on sites
* Mouse highlighting spotlights the location of the cursor
* Records video in many video file formats including AVI and WMV
* Supports various video and audio codecs
* Free support and advice
* Free lifetime updates and upgrades
* System requirements: Windows XP/2000/2003/Vista/Windows 7

It’s easy to use as one, two, three.

You may get more information about Camtica 4.3.54856 here:

Here is a link to download Camtica 4.3.54856:

Here are links to screenshots of Camtica:
Ticketamerica.com has tickets for Ashley Furniture Homestore Pavilion tickets events in Phoenix, AZ and Bethel Woods Center for the Arts Bethel, NY tickets as well as Blossom Music Center Concert Tickets, Schedule, Seating Chart available.
ashley_furniture homestore pavilion tickets
bethel woods center for the arts tickets
blossom music center tickets

Sunday, January 24, 2010


CorpNet® Incorporation Services

I wrote in Para 3 about CCD vs CMOS cameras and somehow the industrial trend went towards CCD camera. However, it is very much possible to make economical CMOS camera with low power consumption and high resolution. Recently I came across one camera from one of our Chinese companies. I tested their 480 TV lines CMOS camera and found it to be much more effective than 420 TVL CCD camera with very little power consumption.

Saturday, February 9, 2008

Digital Surveillance: An overview

1. Introduction

1.a. Need of Digital Surveillance

1.b. How it compliments Alarm system
1.c. Home Automation
2. Lens Selection
2.a. Focal length of the Lens
2.b. Ambient and varying light conditions
2.c. Manual and motorized Zoom Lens
3. Camera Selection
3.a. Types of cameras: CMOS and CCD
3.b. Selection criteria with respect to resolution and lens
3.c. P/T/Z Cameras
3.d. IP or network Cameras
4. Cable Selection
4.a. Coaxial Cable
4.b. Network Cable with Baluns
5. Power supply
6. Digital Video Recorders
6.a. Selection Criteria
6.b. Remote watch


Need of Digital Surveillance

There is no better proof of an event or incidence that has been seen by one’s eye. That’s why people say “You have to see it to believe”. Unfortunately, not enough research has been done on paranormal activities helping us to be able to be virtually present anywhere at the place of our choice. There comes the advantage of today’s technology: “An electronic Eye”, i.e. the concept of digital surveillance. Although, there are many applications of digital surveillance, we will be primarily discussing about its security application.

How it compliments Alarm system

Almost all of us have Alarm panels installed in our premises to prevent an unwanted intruder. Also, most of these alarm panels are connected to alarm monitoring companies, by means of telephone lines or some kind of internet connection. This connection triggers an alarm at the monitoring company when an unwanted intrusion takes place in the protected premises. Basic purpose of doing this is that, one responsible person / company should be aware of an alarm generated by an unwanted intruder and consequently take action on that. Main problem here remains the delay between, alarm generated, alarm communicated and action taken, because of geographical distance between the protected premises and the monitoring company. This delay goes as an advantage to the intruder. All professional thieves now know that there is an average delay of approximately twenty minutes between the alarm generated and action force from the monitoring company to reach the premises. And these thieves take advantage of this delay. Just imagine a scenario where alarm is generated and monitoring company is able to remotely view your premises and record the event along with sending an action force to the premises. Catching of thieves will become so easy. This concept is nothing new, but basic aim of this article is that you can implement this system yourself at your premises without spending huge amount of dollars.
You may check how the remote view works over internet by clicking here.

Home Automation

Another off-shoot of this system is Home automation, as now you have a bi-directional communication / control of your premises in view of exchange of information, e.g. you are on vacation and you don’t want outsiders to know that nobody is in house for 10-15 days. You may occasionally hop into a internet cafĂ©, log into your home computer, select a light switch on the screen and click it “ON” and the your light point in the living room is “ON” or turn on the TV. Of course home automation is not our subject of discussion today and you may click below if you need further information. You may write to us also and we may help you in implementing this further.
Digital Surveillance

Lens Selection

Focal length of the Lens

Type of lens that you select for your camera, decides what kind of angle i.e. what kind of coverage you are going to get from your camera. Focal length of the camera is the factor which decides the angle of the view of camera. Larger focal length will provide smaller angle of view and hence bigger the size of the object on screen. This is true vice versa also. This is illustrated by the fig. below.

Above figure shows that if the lens’s focal length is large an object will cover most of the TV screen making it look big but the angle of view will be smaller. Similarly, if the lens’s focal length is small an object will cover small part of the TV screen making it look small but the angle of view will be larger.

The following table shows the height and width that will be covered on the screen when the object is viewed at a given distance from the camera with respective lens:

This table can be very effectively used to decide the type of lens you should select depending on whether you wish to cover big area or you wish to view your object from close up on the screen. This all will be decided based on the distance of camera from the object in question.

Ambient and varying light conditions

Second criteria that requires the right lens collection is the ambient light condition. If the camera is out door, obviously the light condition will vary during the day and hence the picture quality will vary. E.g. when the sun comes to an angle where it comes right in front of the camera, camera will hardly be able to see anything. It is like shooting a picture from your still camera looking towards the sun. Even if you want to shoot a picture looking towards a bright light source, you will keep the shutter of your camera closed as much as possible. It’s the same thing in this scenario. But here we call it opening or closing of iris instead of shutter.
There are two types of Lenses available:
1) Manual iris
2) Auto iris

As the name suggests, If the camera is installed in such a way that it is required to look towards a brightly lit area or to be precise, camera has to look towards the light source, we can select a manual iris lens and adjust it to this light condition. This is when the light condition is not varying.

If the light condition is varying like sun light, auto iris will be the right choice where the closing and opening of iris is automatically adjusted based on light condition.
All cameras don’t support auto iris lens. So we must ensure that the camera that we are using can be connected with auto iris lens. There are 2 types of auto iris lens available:
1) DC signal driven
2) Video signal driven
You must check the camera as to what kind (or both) of signal the camera provides and select the lens accordingly.

Lastly, there are two types of camera mounting standard available: ‘C’ mount and ‘CS’ mount.
Just be sure that your camera and lens are compatible with respect to their mount standard.
Manual and motorized Zoom Lens

Earlier we saw how the appearance of the scene varies with the type of lens used with respect to its focal length. Lenses are available where this focal length is variable by means of a knob and the focal length can be set to a desired setting.
This can be manual or motorized. With motorized zoom lens it is possible to focus on an object by a press of a button or click of a mouse. We will discuss about it in detail when we talk about PTZ (pan tilt zoom) camera and digital video recorders.

Types of cameras: CMOS and CCD

There are mainly two types of security cameras available CMOS (complementary metal oxide semiconductor) and CCD (Charged coupled devices). Both have got their own advantages and disadvantages and it is not correct to say that one is better than the other.
Electronically, CMOS cameras consume less power but the images produced by them are slightly less sharp than CCD, not because it cannot be made sharper but making them sharper is more expensive and the manufacturers are trying to cash on its cheaper cost and miniaturization. So CMOS cameras are more useful where less power is to be consumed and miniaturization of camera is required. On the other hand, CCD technology is more suitable when acquiring sharp picture is important where it can be made with less complex manufacturing process. Hence in general CMOS cameras are less expensive than CCD cameras. Ultimately both these types of camera give out a signal known as 1V peak to peak composite video signal. And as long as display device (TV, monitors, DVRs etc.) can accept this signal we need not worry about the technology how this signal is achieved.

Selection criteria with respect to resolution and lens

Second most important thing about a camera to be decided is its resolution. They are available like 330 TV lines, 420 TV Lines, 540 TV Lines and so on. Obviously, higher the resolution, costlier the camera. Resolution may be interpreted as the number of dots (also known as pixels) that can be uniquely displayed on the TV screen. So, more the number of dots better will be the quality of picture.

Another point that needs to be decided is, camera’s sensitivity to light that is measured in terms of “Lux”. Lesser the value of lux, better the camera will be able to view in low light condition. It is specified as 0.1 lux, 0.5lux etc. Since, it easier for black and white cameras to see with good resolution in low light conditions, many manufacturers design cameras in such a way that they show color images in good light conditions but turn black and white in low light conditions. Scene illumination is measured in Foot-candles (FTCD). The following table will give you a very good idea of Camera sensitivity to light in terms of Lux.

PTZ (Pan Tilt Zoom) Camera:

This is very intelligent mechanical-electronics integration, giving very advantageous results. Camera is mounted on a dual motor platform which is controlled by 2 motors, one for horizontal movements (panning) and the other for vertical movements (tilting). These motors are controlled electronically from the control room helping us change the direction and hence the angle of camera. Normally tilt angle is available from 0-90 deg. And pan angle is available from 0-355 deg.
Similarly, camera is provided with a motorized zoom lens by which we can focus on an object and have full control on lens from lower focal length to larger focal length. Range of focal length that a lens can provide varies from lens to lens and is the main factor deciding the price of the lens.
This whole unit is controlled by a micro-controller device which has many advantages. Firstly, instead of controlling all these functions by individual wires, serial differential communication protocols (like RS485 or RS442) are used so that 2 pair twisted or 1 pair twisted cables are sufficient to be laid for all the functions. Another major advantage being, it makes the whole unit intelligent and hence it is possible to create presets i.e. create a few points for PTZ camera and so that the camera always follow those points at a defined interval. E.g. first point may be far end of the gate, then turn by 45 deg. And zoom on an internal door and so on. PTZ cameras are specified for this feature as 64 presets or 128 presets etc. 64 presets means, 64 such points may be programmed.
Since these units now have become intelligent, protocols between PTZ cameras and the control room have to match. These days, Digital video recorders specify the make and models of cameras that can be controlled by the DVR. In case your DVR doesn’t specify a particular model that you are going to use, very often these cameras come with their own keyboards for configuring as well as controlling the cameras.

IP (Network) Cameras:

So far we discussed about cameras which give 1V p-p Composite video signal as final output. Expansion of these cameras is IP or network cameras where video to TCP-IP conversion is implemented within the camera and hence these cameras can be directly connected to an Ethernet switch. They are designed to act as video network servers. Just provide them with an IP address suitable for your network and they are ready to be used on your standard computer. Software are available to add DVR capabilities for these cameras.
These cameras are nothing but a video network server built into a standard camera.

Cable Selection

Mostly co-axial cables are used for video signals of these cameras which are available in various standards like RG59, RG6, RG11 etc. you need to select a cable mainly based on the distance that the cable is going to cover. RG59 is suitable up to 100 mtrs. and RG11 can go up to 800 mtrs. These cables are basically classified with respect to the signal loss that takes place within the cable as they travel to a particular distance and their characteristic impedance. E.g. it is 75 ohms in RG59 and 50 ohms in RG11.
Latest development in this field is to use standard network cable CAT5 instead of co-axial cable by means of using a “BALUN” (balance-unbalanced load). Using CAT5 cable for video application becomes very useful in today’s environment where structured cable is gaining too much importance. (Of course topic of structured cabling is beyond the scope of this discussion, but we can understand the advantage of using CAT5 cable for video application)

Power Supply

There is no hard and fast rule as to what value of power supply a camera should have. Various manufacturers use different voltage for different models. Most common being 12V DC. But 24V DC and 24V AC are also being used as standards.

Similarly current requirement also varies from model to model. As we discussed earlier, since CMOS camera consume less power, they are available with power consumption as low as 50 M.amps at 12VDC.

Power cable termination on camera is normally through a DC2.1mm plug but again there is no hard and fast rule about it.

It is normally recommended to use regulated linear power supply rather than SMPS power supply as linear power supplies are cleaner especially in view of tiny voltage ripples.

Digital Video Recorders

Finally we have reached to the heart of the digital surveillance system, i.e. digital video recorder. Mainly in the market, 2 types of systems are available. Stand alone DVR and the PC based ones. Selecting a DVR on this criterion is actually a matter of choice. Stand alone DVRs are meant for just this application and are dedicated for surveillance system where as PC based DVRs are available either as PCI cards or USB based. Of course USB based DVR have their own limitations because of speed restriction on USB port.

Whether the DVR is stand alone or PC based, their selection criterion is same. Some of the main features that we need to go through before deciding a DVR are:

· Frame rate: If the DVR under consideration is 4 channels DVR and the frame rate is 20 FPS (frames per second), then each camera will get 20 /4=5 FPS. This will not be real time but just sufficient for standard security application. But the same FPS of 20 will be unusable for 16 Channel DVR as per camera FPS will be 20 / 16.
· Again, DVR specs. Should also mention whether this FPS is only for displaying camera pictures or also for recording. It may be the case that display FPS is more than the recorded FPS. In that case, although you will see a better display but the recorded picture might be quite broken one.
· You might be using a high resolution camera but if your DVR doesn’t support high resolution then actually you are wasting your money on having high resolution and hence highly priced camera. Video image resolution are normally available as 320X280, 640X420 etc.
· Motion detection sensitivity: How sensitive is the DVR, to detect motion. This becomes very important when DVR has to record in an event of motion.
· Masking of a part of screen: Whether it is possible to mask / unmask a part of the screen, so that motion in that part is ignored by the DVR.
· User friendliness of overall use of software, especially playback features. How fast you can find an event of interest will depend on whether play back search scheme of the DVR is effectively made or not.
· Another important point to consider is whether the DVR uses hardware video compression technique or the software video compression technique. Hardware technique is more efficient and at the same time costlier.
· Password protection: Normally good software will have multi level password where the administrator should be able to configure various users with defined level of authority.
· What kind of networking features it provides. TCP/IP has its advantages that it is more efficient but web server concept has the advantage that it doesn’t require software at the remote end but it is relatively slow.

Remote Watch:

Any DVR that supports TVP/IP or web server based networking can be viewed over LAN or Internet or Intranet.
Firstly, the DVR needs to be configured for fixed IP address which will be decided by your network. Once the IP is defined, you should be able to view the cameras / recorded pictures over the LAN just by typing IP address of DVR in the address bar of your internet explorer (In case of video web server) or by running a special software application provided by DVR (In case of TCP/IP application)

To view it over internet, your router on the network is to be told to communicate with DVR whenever a valid attempt is made on a particular port number. This port number is configured at the DVR end. If we define that port 1000 is for video images in DVR software, then router has to be configured so that all the data on port 1000 should be directed to the DVR IP address.

Almost all the routers have this facility and they are known as different names like, pin holing, port forwarding or creating virtual server etc.

Blog Search Engine