Monthly Archives: June 2015

Synkronizer 9.5

Last year I came across this software called Synkronizer 9.5. My requirement was to compare the data in two excels.

I tried to find free software but none of them were found to be helpful. Suddenly I found the link for Synkronizer 9.5 which is not free but you can try it for 30 days with full functionality. After 30 days you need to register to continue using it. The software comes in 4 different versions: Light Version, Standard Version, Premium Version and Developer Version.

The basic differences between these versions are the existence of some functionalities like “Highlighting Differences”, “Creating Difference Report”, “Navigator Toolbar”, “Access/ODBC files” and “Synkronizer VBA”. This software proved to be a very helpful to me. It’s not just a comparison tool but more than that. It has different types of settings based on your requirement to get the comparison report.

First of all, let me tell you that it is installed as an Add-In in Microsoft excel. First you click on the icon available in the “Tools” menu and then click on the icon for Synkronizer to open a wizard. The wizard asks you to choose two excel files. The first file to be chosen is called as a “Master” file and the other file to be chosen is called as “Update” file. Interesting thing I found here is that you can choose the same file as a “Master” and an “Update” file but need to choose two different sheets of the same file. You can specify the worksheets as databases also.

You can set some filters which will be used as a filter while comparing the sheets. Some of the are like “Case Sensitive”, “White space Trim”, “Ignoring Data type”, “Ignoring Constraints”, “Ignoring Formulas”. You can set for numeric tolerance in case of numbers in the data. Also the software lets you to configure the difference report after the sheets are compared. You can configure how you want the software to compare the two sheets. The most important feature of this software is Configuration. This tool compares two sheets according to your wish. Whatever you tell, it will do it. It has some default settings which can be changed as required. There are also configurations for colors. Language setting is also a good feature. You can configure the tool to compare in terms of values or formulas. This comparison tool is very easy-to use and needs no training.

It is self explanatory and I would like to refer this tool to all those who is looking for the best excel comparison tool. I actually completed a project of one month using this tool and VBA coding. Another Advanced feature that comes with the Developer version is that Synkronizer can be controlled using Visual Basic for Applications (VBA). Recurring, standardized or complex comparison processes can be automated using Synkronizer and VBA.

Little Snitch

Little Snitch for Mac OSX Little Snitch is a network monitoring program for Mac OS X developed by Objective Development.

It’s a shareware program that lets you know when another program tries to “phone home” or access an outbound port on your computer. You can easily install the program by downloading the .dmg file then dragging it into the applications folder. While this may seem like a superfluous program to have on a Mac, it is nice to be able to decide when and how certain programs access the net. Little Snitch isn’t a firewall, instead it uses the programs name to let you know what’s happening. For example, does the realplayer really NEED to phone home? You can decide. Although malware is limited for OSX, trojans can still potentially be downloaded and installed by the user.

Little Snitch will detect the network activity and let you know so you can block it. In demo mode Little Snitch is fully functional, but only for 3 hours after start up. You can easily reset this timer (they even tell you how) so that it will run for another 3 hours after that. If you decide to purchase, it’s $24.95. Not too expensive. It’s important to keep the dmg file after downloading in case you want to uninstall. This is one of the programs you can’t just drag to the trash.