Category: Free Tools

The free tools contained here are available for download, and we hope that you will find them useful. Although they are free, they are much more than just spreadsheets and contain all the VBA code, conditional formatting, and data validation to ensure that they offer sophisticated functionality and operate in a user-friendly, error-free way.

If you’re uncomfortable downloading a file that contains code from a website, well, I don’t blame you. Feel free to contact me so that we can talk before you download if you wish.

Individuals SPC Application

For many small companies, or any company with only a small SPC need, a true SPC software package can seem unnecessarily expensive. This application allows you to track up to three individual variables at no cost and multiple versions of the file can be created for more variables.

The program allows you to log the data along with associated notes, and it visually identifies any OOC points at both the data entry field and in the automatically created control charts. In addition to the three-standard deviation violation, it also identifies eight rules in total including trends, three different runs, over-control, stratification, and mixture violation. The user can control which rules are applied along with the number of points displayed on the control charts.

If you’d like more variables accommodated in one file, or any other customization, please contact me.

Get the SPC chart

Time Tracker Tool

This program tracks time spent on activities, clients, projects, or any categories that you wish. Select the category that the time applies to, click start when you begin, stop when you finish, and enter any notes that are associated with the time spent.

Creative thinking can find many applications for this tool. I use it to track my billable time on client’s project to the fraction of an hour with little effort. By adding the project’s revision number to the notes, along with the activities I spent the time on, it also easily accommodates revision control. Other potential uses include time studies for value stream mapping, accounting for office worker’s time, collecting data for developing activity models, etc.

If you would like a modification to the program for your own specific needs, don’t hesitate to contact me.

Get the Time Tracker Tool